Optional Calculation Spreadsheet Instructions

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
Excerpt Include
help:Spreadsheet Usage Warning
Spreadsheet Usage Warningnopaneltrue

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.


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 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.

Excerpt Include
help:Calculation Spreadsheetshelp:Calculation Spreadsheets
Calculation Spreadsheets

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