Tier 2 Subpart C Streamlined Reporting
Skip to end of metadata
Go to start of metadata

Tier 2

For Subpart C facilities that use the Tier 2 calculation methodology, using the new Tier 2 Streamlined Reporting Tool (i.e., Tier 2 Equation Inputs Bulk Reporting) will allow for simultaneous entry of all fuel-level emissions equation inputs (i.e., fuel quantities and HHVs) and other required information across all configurations in a single Excel Worksheet (with the exception of Tier 2 Blended Fuels). If a facility has configurations and fuels that are eligible for Tier 2 Streamlined Reporting, the pop-up box shown below will appear on the Subpart C Overview Page. This feature is only applicable in Reporting Year 2019 (RY19) and forward, and is available for both fuels and configurations which are carried forward from the prior RY, and new configurations and fuels added in the current RY.

To maximize the time and effort savings available from Tier 2 Equation Inputs Bulk Reporting, users should first ensure all of their configurations and fuels are present in e-GGRT (either by adding them to the current RY, or as carried forward from the prior RY), and then download the Excel Worksheet. Adding the configurations and fuels in e-GGRT, without entering equation input values for Equations C-2a, C-2b and C-2c, will allow e-GGRT to provide those rows in the streamlined reporting worksheet, thus allowing reporters to use the centralized data entry available in the worksheet and eliminate the need to navigate across several traditional e-GGRT webforms. 


Click this link to expand 

After clicking, "LAUNCH Tier 3", users are taken to the Tier 3 Equation Inputs Bulk Reporting Page. From here, users can download a Microsoft Excel spreadsheet which will be pre-populated with all of the eligible information for each configuration.

Click this link to expand 


After downloading and opening the form, users can enter all fuel-level information and equation inputs into this spreadsheet. The grey highlighted information that is pre-populated in the Microsoft Excel sheet cannot be altered in any way. If a user wishes to make alterations to the configuration or fuel information in the bulk reporting form, they should make the changes in the traditional e-GGRT webforms, and then download a new version of the Microsoft Excel form. The new form will have the updates represented in the grey cells.


Certain Copy and Paste functions can corrupt this form. To avoid this, only use the ‘Paste Values (V)’ option when pasting into this form


Click this link to expand 

Any cell that needs to be completed will be represented by a blue background, and additional limitations are placed in the Microsoft Excel sheet in order to prevent erroneous data entry. Any data element which is closed (has a black fill) needs no data entry. If a user believes that they should enter data into a cell which they do not have access, they are encouraged to check the traditional e-GGRT webforms for the configuration/fuel in the row they believe to be incorrect.

Click this link to expand  

After a user has completed a Microsoft Excel form, they upload it using the "Choose File" link on the Tier 2 Equation Inputs Bulk Reporting Page and then clicking the “UPLOAD” button.

Click this link to expand 

If the uploaded form is missing some required data or the data provided cannot be processed by e-GGRT, the user will receive warning messages as show below. These must be addressed before the form can be completely processed by e-GGRT. Any blanks in the data input reporting form will be processed as a blank data entry and will need to be addressed prior to submitting the report.

Click this link to expand 

After addressing any data errors and successfully uploading a Microsoft Excel sheet, a summary page appears which displays all fuels using the Tier 2 Equation Inputs Bulk Reporting Form. Users should review the annual emissions calculations, and, when satisfied the values are correct, click "Finished" at the bottom of the page.

Click this link to expand 

Any remaining information that is required to be reported for eligible configurations, or any configuration that does not use the Tier 2 Equation Inputs Bulk Reporting Form, will still need to be completed using the traditional e-GGRT webforms before the Subpart C reporting is complete.

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