These optional spreadsheets are provided to assist reporters in calculating emissions and in keeping records of these calculations.
Reporters are required to keep records of these calculations under 40 CFR 98.3(g) and additional subpart-specific provisions, but are not required to use these spreadsheets or to submit any spreadsheets to EPA.
Overview
This help page provides guidance for working with the supplemental Subpart G spreadsheet tools. The guidance provides step-by-step instructions for the following tasks:
- Selecting the appropriate spreadsheet tool
- Downloading a spreadsheet tool
- General Information on using a spreadsheet tool
- Using the G-1 Spreadsheet Tool
- Using the G-2 Spreadsheet Tool
- Using the G-3 Spreadsheet Tool
Specific information on each of the spreadsheet tools is provided below.
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) |
|
|---|
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) |
|
|---|
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) |
|
|---|
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 | Selection Criteria: | Instructions |
|---|---|---|
Gaseous | ||
Liquid | ||
Solid |
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.
Color coding
The calculation spreadsheets contain green input cells, gray informational cells, and red-bordered results cells filled with yellow or white. Users should use green input cells to enter all data specific to their facility, unit, or process. Gray informational cells contain parameter names, column and row headings, equation constants and subtotals. Calculation results are displayed in red-bordered results cells filled with yellow or white. For red-bordered, yellow-filled results cells, the values in these cells should be entered in the appropriate and separate calculation spreadsheet (as directed below cell) where additional calculations will be made. For red-bordered, white filled results cells, the values in these cells should be entered in e-GGRT for the appropriate process units. All cells that are not green input cells are locked and cannot be modified.
|
Green input cell (data entry) |
|
Gray informational cells (locked) |
|
Red-bordered, yellow-filled results cells (enter in appropriate and separate calculation spreadsheet) |
|
Red-bordered, white filled results cells (enter in e-GGRT) |
Stop and Warning Messages
The calculation spreadsheets will display a stop message if the user enters a value that is invalid or a warning message if the user enters a value outside the EPA estimated range for a particular data element. For invalid data entries, the stop messages will not allow a user to proceed and the user must reenter valid data before moving forward. For data entries that are outside the EPA estimated range for a particular data element, the warning messages will allow a user to proceed if the user deems the entered value to be accurate.
Multiple process units
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.
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) |
|
|---|
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.
Next, enter the requested information in the green input cells in the table titled G-1 Input Data.
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.
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) |
|
|---|
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.
Next, enter the requested information in the green input cells in the table titled G-2 Input Data.
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.
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) |
|
|---|
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.
Next, enter the requested information in the green input cells in the table titled G-3 Input Data.
The spreadsheet tool will calculate the Annual CO2 process emissions from a unit with a solid feedstock. This calculated value will be displayed in the red-bordered cell in the G-3 Results table at the bottom of the spreadsheet. This value should be entered in e-GGRT for this process unit.
