Optional Calculation Spreadsheet Instructions

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

Excerpt Include
Spreadsheet Usage Warning
Spreadsheet Usage Warning
nopaneltrue

...

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 Calculation Spreadsheet Archive to review obsolete calculation spreadsheets.

EPA is providing OPTIONAL calculational calculation 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.

...

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 displaying in 7 decimals of precision. Users may copy the results from spreadsheets into e-GGRT manually or by using a copy and paste commnandcommand.

Excerpt Include
Calculation Spreadsheets
Calculation Spreadsheets
nopaneltrue

...

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