Using Subpart G Calculation Spreadsheets

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Specific information on each of the spreadsheet tools is provided below.

...

Anchor
Selecting the appropriate spreadsheet tool
Selecting

...

the

...

appropriate

...

spreadsheet

...

tool

Subpart G requires a facility to report annual CO2 process emissions from each process unit used to produce ammonia. To calculate the annual CO2 emissions from each process unit, users must use one of three equations based on the unit feedstock. Users may use different spreadsheet tools for different process units as required by the feedstock type for each unit. Users may use more than one spreadsheet tool for a process unit if the unit has more than one type of feedstock.

For each process unit with a gaseous feedstock, users should calculate annual CO2 process emissions using Equation G-1 and the G-1 Spreadsheet Tool. Equation G-1 is provided below:

(Equation G-1)

Image Modified

For each process unit with a liquid feedstock, users should calculate annual CO2 emissions using Equation G-2 and the G-2 Spreadsheet Tool. Equation G-2 is provided below:

(Equation G-2)

Image Modified

For each process unit with a solid feedstock, users should calculate annual CO2 emissions using Equation G-3 and the G-3 Spreadsheet Tool. Equation G-3 is provided below:

(Equation G-3)

Image Modified

...

Anchor
Downloading a spreadsheet tool
Downloading

...

a

...

spreadsheet

...

tool

Spreadsheet tools for Subpart G may be downloaded by clicking one of the links in the first column of the table below. Users may also jump to instructions for each spreadsheet tool by clicking one of the links in the third column.

Spreadsheet Tools

Spreadsheet Tools
(click to download)

Selection Criteria:
Feedstock Type

Instructions
(click to view)

Equation G-1 Calculation Spreadsheet.xls

Gaseous

G-1 Help

Equation G-2 Calculation Spreadsheet.xls

Liquid

G-2 Help

Equation G-3 Calculation Spreadsheet.xls

Solid

G-3 Help

...

Anchor
Using a spreadsheet tool to make calculations
Using

...

a

...

spreadsheet

...

tool

...

to

...

make

...

calculations

The guidance provided in this section applies to each of the spreadsheet tools for Subpart G. Additional guidance is provided for each individual spreadsheet tool in the sections below.

...

Users with multiple process units should use separate spreadsheet tools for each process unit. Users should not aggregate data for multiple process units when using these spreadsheet tools.

...

Anchor
Using the G-1 Spreadsheet Tool
Using

...

the

...

G-1

...

Spreadsheet

...

Tool

Use the G-1 Spreadsheet Tool to calculate the annual CO2 process emissions from a process unit with a gaseous feedstock. A separate spreadsheet is to be used for each process unit. Calculations for process units with liquid and solid feedstocks should be performed using different spreadsheet tools and different equations. The G-1 Spreadsheet Tool performs the calculation using Equation G-1, provided below.

(Equation G-1)

Image Modified

Begin by entering the facility name, your name, the process unit name or identifier, process unit description, and any additional comments in the green input cells of the General Information table located immediately below the equation in the spreadsheet tool. This is for your records.

...

The spreadsheet tool will calculate the Annual CO2 process emissions from a unit with a gaseous feedstock. This calculated value will be displayed in the red-bordered cell in the G-1 Results table at the bottom of the spreadsheet. This value should be entered in e-GGRT for this process unit.

...

Anchor
Using the G-2 Spreadsheet Tool
Using

...

the

...

G-2

...

Spreadsheet

...

Tool

Use the G-2 Spreadsheet Tool to calculate the annual CO2 process emissions from a process unit with a liquid feedstock. A separate spreadsheet is to be used for each process unit. Calculations for process units with gaseous and solid feedstocks should be performed using different spreadsheet tools and different equations. The G-2 Spreadsheet Tool performs the calculation using Equation G-2, provided below.

(Equation G-2)

Image Modified

Begin by entering the facility name, your name, the process unit name or identifier, process unit description, and any additional comments in the green input cells of the General Information table located immediately below the equation in the spreadsheet tool. This is for your records.

...

The spreadsheet tool will calculate the Annual CO2 process emissions from a unit with a liquid feedstock. This calculated value will be displayed in the red-bordered cell in the G-2 Results table at the bottom of the spreadsheet. This value should be entered in e-GGRT for this process unit.

...

Anchor
Using the G-3 Spreadsheet Tool
Using

...

the

...

G-3

...

Spreadsheet

...

Tool

Use the G-3 Spreadsheet Tool to calculate the annual CO2 process emissions from a process unit with a solid feedstock. A separate spreadsheet is to be used for each process unit. Calculations for process units with gaseous and liquid feedstocks should be performed using different spreadsheet tools and different equations. The G-3 Spreadsheet Tool performs the calculation using Equation G-3, provided below.

(Equation G-3)

Image Modified

Begin by entering the facility name, your name, the process unit name or identifier, process unit description, and any additional comments in the green input cells of the General Information table located immediately below the equation in the spreadsheet tool. This is for your records.

...

This web site is maintained by a contractor to the U.S. Environmental Protection Agency (RY2023.R.01)