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.
Please refer to the Calculation Spreadsheet Archive to review obsolete calculation spreadsheets.
EPA is providing OPTIONAL calculation spreadsheets that you can use to perform the calculations called for in the emission equations. These Microsoft Excel spreadsheets can be downloaded and opened on your own computer. Just click the hyperlink on the web-form to view and download the appropriate calculation spreadsheet for the equation you are working on. You can enter the data, including equation inputs, necessary to perform the calculation for the equation, and the spreadsheets will calculate the result for you. Once you have calculated the result, enter the result onto the e-GGRT web form.
E-GGRT will NOT collect the calculation spreadsheets and you do NOT need to submit them outside of e-GGRT. The use of these calculation spreadsheets is voluntary. The spreadsheets are meant to support reporters as they complete the e-GGRT online reporting process. You do not need to use EPA’s spreadsheets to perform the calculations for the emissions equations, but you do need to keep records of these calculations (under 40 CFR 98 3(g) and additional subpart-specific provisions) whether or not you use the calculation spreadsheets provided by EPA. If you do use the spreadsheets, you may choose to maintain copies to help meet your record-keeping requirements.
Calculation spreadsheets include no rounding of results. All calculations in these spreadsheets are conducted using double decimal precision, as native in MS Excel. The resultant values are presented on the spreadsheet in 7 decimals of precision. Users may copy the results from spreadsheets into e-GGRT manually or by using a copy and paste command.
Subpart | Calculation Spreadsheets |
|---|---|
C - Combustion | |
| Equation C-1b, C-8b Calculation Spreadsheet.xls | |
| Equation C-10 Calculation Spreadsheet.xls | |
E - Adipic Acid | |
G - Ammonia | |
I - Electronics Manufacturing | |
H - Cement Production | |
K - Ferroalloy Production | |
L - Flourinated Gas Production | Subpart L Calculation Spreadsheets - Emission Factor Equations.xls |
Subpart L Calculation Spreadsheets - Mass Balance Equations.xls | |
| Subpart L Calculation Spreadsheet - Summarize Process Level CO2e by f-GHG.xls | |
N - Glass Production | |
P - Hydrogen Production | |
Q - Iron and Steel | |
S - Lime Manufacturing | |
T - Magnesium Production | |
| Equation T-2 ,T-3 Calculation Spreadsheet.xls | |
U - Carbonate | |
V - Nitric Acid | |
W - Petroleum and Nat. Gas | Subpart W All Onshore Equations Calculation Spreadsheet for RY17 to RY23 (Updated February 2023) Subpart W Calculation Tool for RY24_v5.xlsx (Updated 4/23/2025) Changes to RY24 Subpart W Calculation Tool for RY24 v5 compared to v1
|
Subpart W Offshore Equations Calculation Spreadsheet for RY11 and RY12 | |
| Subpart W Offshore Equations Calculation Spreadsheet for RY13 and RY14 | |
| Subpart W Offshore Equations Calculation Spreadsheet for RY15 and Later | |
X - Petrochemical Production | |
Y - Petroleum Refineries | |
Equation Y-18 Calculation Spreadsheet.xls (applicable to RY2017 and prior years) | |
Z - Phosphoric Acid | |
AA - Pulp and Paper | |
BB - Silicon Carbide | |
CC - Soda Ash | |
EE - Titanium Dioxide | |
HH - Landfills | |
| Equation HH-5 Calculation Spreadsheet.xls | |
| Equation HH-6 HH-7 HH-8 Calculation Spreadsheet Revised 2021.xls | |
| Methane Flux Calculation Spreadsheet.xls | |
II - Industrial Wastewater Treatment | |
| NN - Suppliers of Natural Gas and Natural Gas Liquids | EIA 176 and Subpart NN Crosswalk.xlsx |
SS - Electrical Equipment Manufacturer or Refurbishment | |
TT - Industrial Landfills | |
| Equation HH-6 HH-7 HH-8 Calculation Spreadsheet.xls | |
| Methane Flux Calculation Spreadsheet.xls |