E-GGRT currently reflects the rules deferring reporting of inputs to emission equations for direct emitters. In August 2011, EPA deferred the reporting deadline for inputs to equations until either March 31, 2013 or March 31, 2015 to allow time to fully evaluate the potential impact from the release of this data. The inputs to equations whose reporting deadline was deferred until 2013 are listed in Table A-6 of subpart A of the GHG reporting rule. e-GGRT webforms and reporting forms have been modified to include input to equations that are no longer deferred. As a result some optional calculation spreadsheets that were use in prior reporting years have been subsumed by webforms or reporting forms and are no longer provided below. Please refer to the calculation spreadsheet archive to review obsolete calculation spreadsheets.
EPA is providing OPTIONAL calculational spreadsheets that you can use to perform the calculations called for in the emission equations for situations where an input is still deferred (e.g., until 2015). 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, presented on the spreadsheet displaying 7 decimals of precision. Users may copy the results from spreadsheets into e-GGRT manually or by using a copy and paste commnand.
Subpart | Calculation Spreadsheets (click to download) |
---|
C - Combustion | Equation C-1, C-8 Calculation Spreadsheet.xls |
Equation C-1a, C-8a Calculation Spreadsheet.xls |
Equation C-1b, C-8b Calculation Spreadsheet.xls |
Equation C-2a, C-2b, C-9a Calculation Spreadsheet.xls |
Equation C-2c, C-9b Calculation Spreadsheet.xls |
Equation C-3, C-8 Calculation Spreadsheet.xls |
Equation C-4, C-8 Calculation Spreadsheet.xls |
Equation C-5, C-8 Calculation Spreadsheet.xls |
Equation C-10 Calculation Spreadsheet.xls |
E - Adipic Acid | Equation E-2 Calculation Spreadsheet.xls |
Equation E-3a Calculation Spreadsheet.xls |
Equation E-3b Calculation Spreadsheet.xls |
Equation E-3c Calculation Spreadsheet.xls |
G - Ammonia | Equation G-1 Calculation Spreadsheet.xls |
Equation G-2 Calculation Spreadsheet.xls |
Equation G-3 Calculation Spreadsheet.xls |
I - Electronics Manufacturing | Subpart I Calculation Tool for RY2014 and beyond.xlsx |
H - Cement Production | Equation H-1 Calculation Spreadsheet.xls |
Equation H-2, H-3, H-4 Calculation Spreadsheet.xls |
Equation H-5 Calculation Spreadsheet.xls |
K - Ferroalloy Production | Equation K-1, K-3 Calculation Spreadsheet.xls |
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 | Equation N-1 Calculation Spreadsheet.xls |
P - Hydrogen Production | Equation P-1 Calculation Spreadsheet.xls |
Equation P-2 Calculation Spreadsheet.xls |
Equation P-3 Calculation Spreadsheet.xls |
Sum of Equation P-1, P-2, P-3 Calculation Spreadsheet.xls |
Q - Iron and Steel
| Equation Q-1 Calculation Spreadsheet.xls |
Equation Q-2 Calculation Spreadsheet.xls |
Equation Q-3 Calculation Spreadsheet.xls |
Equation Q-4 Calculation Spreadsheet.xls |
Equation Q-5 Calculation Spreadsheet.xls |
Equation Q-6 Calculation Spreadsheet.xls |
Equation Q-7 Calculation Spreadsheet.xls |
Equation Q-8 EF Approach Calculation Spreadsheet.xls |
S - Lime Manufacturing | Equation S-1 Calculation Spreadsheet.xls |
Equation S-2 Calculation Spreadsheet.xls |
Equation S-3 Calculation Spreadsheet.xls |
Equation S-4 Calculation Spreadsheet.xls |
T - Magnesium Production | Equation T-1 Calculation Spreadsheet.xls |
Equation T-2 ,T-3 Calculation Spreadsheet.xls |
U - Carbonate
| Equation U-1 Calculation Spreadsheet.xls |
Equation U-2 Calculation Spreadsheet.xls |
V - Nitric Acid
| Equation V-2 Calculation Spreadsheet.xls |
Equation V-3a Calculation Spreadsheet.xls |
Equation V-3b Calculation Spreadsheet.xls |
Equation V-3c Calculation Spreadsheet.xls |
W - Petroleum and Nat. Gas | Subpart W All Onshore Equations Calculation Spreadsheet for RY11 and RY12 Subpart W All Onshore Equations Calculation Spreadsheet for RY13 and RY14 Subpart W All Onshore Equations Calculation Spreadsheet for RY15 Subpart W All Onshore Equations Calculation Spreadsheet for RY16 Subpart W All Onshore Equations Calculation Spreadsheet for RY17 and Later (Updated February 2023) |
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
| Equation X-1 Calculation Spreadsheet.xls |
Equation X-2 Calculation Spreadsheet.xls |
Equation X-3 Calculation Spreadshee.xls |
Equation X-4 Calculation Spreadsheet.xls |
Y - Petroleum Refineries
| Equation Y-1a Calculation Spreadsheet.xls |
Equation Y-1b Calculation Spreadsheet.xls |
Equation Y-2 Calculation Spreadsheet.xls |
Equation Y-3 Calculation Spreadsheet.xls |
Equation Y-4, Y-5 Calculation Spreadsheet3.xls |
Equation Y-6, Y-7a, Y-7b Calculation Spreadsheet.xls |
Equation Y-8 Calculation Spreadsheet.xls |
Equation Y-9, Y-10 Calculation Spreadsheet.xls |
Equation Y-11 Calculation Spreadsheet.xls |
Equation Y-12 Calculation Spreadsheet.xls |
Equation Y-13 Calculation Spreadsheet.xls |
Equation Y-14, Y-15 Calculation Spreadsheet.xls |
Equation Y-16a, Y-16b, Y-17 Calculation Spreadsheet.xls |
Equation Y-18 Calculation Spreadsheet.xls (applicable to RY2017 and prior years) |
Equation Y-19 Calculation Spreadsheet.xls |
Equation Y-20 Calculation Spreadsheet.xls |
Equation Y-21 Calculation Spreadsheet.xls |
Equation Y-22 Calculation Spreadsheet.xls |
Equation Y-23 Calculation Spreadsheet.xls |
Z - Phosphoric Acid | Equation Z-1a, Z-1b Calculation Spreadsheet.xls |
AA - Pulp and Paper | Equation AA-1 Calculation Spreadsheet.xls |
Equation AA-2 Calculation Spreadsheet.xls |
Equation AA-3 Calculation Spreadsheet.xls |
BB - Silicon Carbide | Equation BB-1, BB-2 Calculation Spreadsheet.xls |
CC - Soda Ash | Equation CC-3, CC-4, CC-5 Calculation Spreadsheet.xls |
EE - Titanium Dioxide | Equation EE-2 Calculation Spreadsheet.xls |
Equation EE-3 Calculation Spreadsheet.xls |
HH - Landfills | Equation HH-1 Calculation Spreadsheet.xls |
Equation HH-4 Calculation Spreadsheet.xls |
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 | Equation II-4 Calculation Spreadsheet.xls |
NN - Suppliers of Natural Gas and Natural Gas Liquids | EIA 176 and Subpart NN Crosswalk.xlsx |
SS - Electrical Equipment Manufacturer or Refurbishment
| Equation SS-2 Calculation Spreadsheet.xls |
Equation SS-3 SS-4 Calculation Spreadsheet.xls |
TT - Industrial Landfills | Equation TT-1 Calculation Spreadsheet.xls |
Equation TT- 6 Calculation Spreadsheet.xls |
Equation HH-4 Calculation Spreadsheet.xls |
Equation HH-6 HH-7 HH-8 Calculation Spreadsheet.xls |
Methane Flux Calculation Spreadsheet.xls |