Subpart C Optional Calculation Spreadsheets contain old GWP values

Issue: Several Subpart C Optional Calculation Spreadsheets contain hard-coded GWP values for CH4 and N2O, and will not estimate RY2024 CO2 equivalent emissions correctly. The spreadsheets are found at https://ccdsupport.com/confluence/display/help/Optional+Calculation+Spreadsheet+Instructions. The Agency updated GWPs this year and in particular the RY2024 GWP for Methane is 28 and the RY2024 GWP for Nitrous Oxide is 265. While e-GGRT takes these new GWPs into consideration, users with their own calculation spreadsheets and XML reporters must incorporate revised GWP depending on the reporting year being submitted. 

For more information about changing GWPs please consult: https://www.epa.gov/system/files/documents/2024-07/gwp_update_2024.pdf.

For more detail on the GWPs to be used by reporting year please consult: https://ccdsupport.com/confluence/display/help/Table+A-1+of+Subpart+A+of+Part+98+-+Global+Warming+Potentials.

Workaround: Until the spreadsheets can be corrected, you must update the GWP values as appropriate (these workbooks are not locked)

RY2020 and RY2021 "Adjusted" CO2 equivalent values may be incorrect for Suppliers reporting under Subparts LL-QQ

Issue: The "By CO2e" trend report calculates adjusted CO2 equivalent values by applying the new RY2024 GWP values (4/25/24 final rule) to prior year emissions values. These adjusted values are shown on the bottom half or the report in the "ADJUSTED" section of the report, which follows the "AS SUBMITTED" section of the report. RY2021 Adjusted values for "CO2e from products supplied (LL-QQ)" are incorrectly shown on the "CO2 sequestered (RR)" row, and RY2020 Adjusted values for "CO2e from products supplied (LL-QQ)" are not correctly included in the report. The RY2020 column incorrectly includes the RY2021 value for "for "CO2e from products supplied (LL-QQ)".

Workaround: None. This issue will be addressed in a future e-GGRT maintenance release.

Reference: #516

Validation message 0-088 is incorrectly flagged

Issue: Subpart O users will receive validation message O-088 which states "The annual HFC-23 emission for reporting year 2024 is NNN metric tons.  This value is significantly different from the 2023 annual HFC-23 emissions of YYY metric tons"

Workaround:  You may ignore this message.

Reference: #468

Incorrect calculations in the RY24 Subpart W Optional Calculation Tool workbook with update date of 1/17/2025

Issue: Errors in calculation formulas for pneumatic devices, centrifugal compressors, and reciprocating compressors, equipment leaks in the Optional Calculation Workbook 

Resolved:  Download revised version 4 (v4) of the Optional Calculation Workbook with an update date of 2/18/2025 at Optional Calculation Spreadsheet Instructions

In the supersized Subpart W form with last update last update prior to 3/20/2025, some fields do not auto populate data

Issue: Missing formula to populate sub-basin ID in sections of Table AA.1.ii  and Table F.2 in the supersized reporting form.  Missing formula to populate the Unit ID or Name in sections of Tables D.3, D.4,  and D.5

Resolved:  Download revised version of the Subpart W reporting form with an last update date of 3/20/25 at Reporting Form Instructions

In the Subpart W form with last update prior to 3/20/2035, the Natural gas distribution industry segment calculated total emissions on worksheet (q,r) Equipment Leaks is incorrect

Issue: The calculated total emissions on worksheet (q,r) Equipment leaks is counting emissions in for current year T-D Station emissions and T-D transfer station emissions in multi-year 

Resolved:  Download revised version of the Subpart W reporting form with an last update date of 3/20/25 at Reporting Form Instructions

Non-biogenic CO2e emissions from facility subparts C-II, SS, and TT  do not include reported emission from Subpart W

Issue: The application is omitting  emissions contributions from subpart W and only includes contributions from other subparts.  If the facility only reports to Subpart W, the non-biogenic CO2e emissions will appear as 0.

Workaround: 

Follow the steps below to self-correct and recalculate your non-biogenic CO2e emissions from facility subparts C-II, SS, and TT in your annual report:   
1) Login to e-GGRT and open your facility
2) Open Subpart C from the Facility Overview page
3) Click the "OPEN" button for any of your reported Subpart C units/configurations
4) Click the "OPEN" button under "Configuration-Level Emissions Information"
5) Click the "SAVE" button on that page

After saving the information on the Configuration-level Emissions Information page, please return to the Facility Overview and re-check the CO2e emissions values. The steps above should trigger a re-calculation of your facility’s total CO2 equivalent emissions calculation.

If your facility only reports Subpart W, then alternatively, you can reupload your Subpart W reporting form and wait until your form is fully uploaded.  To recalculate your annual report, follow the steps below:

1) Login to e-GGRT and open your facility
2) Open Subpart W from the Facility Overview page
3) Save your current Subpart W reporting form by clicking the hyperlinked file name
4) Delete the current uploaded reporting form
5) Reupload the same file you recently saved by clicking the CHOOSE FILE button and selecting the recently saved file to upload again.
6) It is recommended the user stay on the page until the process completes and can see the subpart level emission values in the calculator panel. Once these values appear, you may navigate back to the Facility Overview page and regenerate and resubmit your annual report.