California Air Resources Board

Reporting Forms and Calculation Workbooks

This page provides information for using Reporting Forms and Calculation Workbooks when reporting GHG emissions data as well as other required information in Cal e-GGRT. For each applicable subpart from the list below, and depending on the type of data being reported, users may be required to submit supplemental data and information using Excel-based Reporting Forms and Calculation Workbooks. 

The "via XML" label below indicates the document must be exported in XML format before uploading the workbook. The "supports calculation" label below indicates the workbook can be used to perform the calculation used to estimate emissions. All other Excel documents must be uploaded into Cal e-GGRT.

Please note: XML functionality is not supported in the web browser version of Microsoft Excel (Office 365).  If you upload a workbook to Office 365 (or your browser automatically opens it) and you see a message saying the file contains unsupported features, please use the Excel desktop application to open and use the workbook instead.

----------

Reporting Forms

(To input data, click the appropriate link, enter data, then upload to Cal e-GGRT if required )

Subpart EPE - Electric Power Entities

ONE - EPE Importers and Exporters.xlsm

Subpart A - Forest Product

Forest Product.xls

Subpart A - Missing Data Substitution Reporting Form

Missing Data Substitution Reporting Form.xlsx

Subpart C - Stationary Combustion

Equation C-2b (HHV) Calculation Spreadsheet.xls

Equation C-2b (CC) Calculation Spreadsheet.xls

Equation C-2b (CC and MW) Calculation Spreadsheet.xls

Subpart N - Glass Production

Equation N-1 Calculation Spreadsheet.xls

Subpart P - Hydrogen Production

Equation P-1 Calculation Spreadsheet.xls (via XML)

Equation P-2 Calculation Spreadsheet.xls (via XML)

Equation P-3 Calculation Spreadsheet.xls (via XML)

Subpart R - Lead Production

Subpart R Reporting Form.xls

Subpart S - Lime Manufacturing

Subpart S Equation Calculation Spreadsheet.xls

Subpart V - Nitric Acid Production

Subpart V GHG Reporting Form - Required Data.xls

Equation V-2 Calculation Spreadsheet.xls

Equation V-3c Calculation Spreadsheet.xls

Subpart W - Petroleum and Natural Gas Systems (Subarticle 5)

Petroleum and Natural Gas Systems - Emissions Reporting Workbook.xlsm (via XML)

Petroleum and Natural Gas Systems - Activity Data Workbook.xlsx

Subpart Y - Petroleum Refineries (production data)

Subpart Y Additional Production Data.xlsm (via XML)

Complexity Weighted Barrel (CWB) Reporting Form.xlsx (via XML)

Subpart Y - Petroleum Refineries (emissions data)

Equation Y-1a Calculation Spreadsheet.xls (supports calculation)

Equation Y-1b Calculation Spreadsheet.xls (supports calculation)

Equation Y-2 Calculation Spreadsheet.xls (supports calculation)

Equation Y-4, Y-5 Calculation Spreadsheet.xls (via XML)

Equation Y-6, Y-7a, Y-7b Calculation Spreadsheet.xls (supports calculation)

Equation Y-9, Y-10 Calculation Spreadsheet.xls (via XML)

Equation Y-11 Calculation Spreadsheet.xls (supports calculation)

Equation Y-12 Calculation Spreadsheet.xls (via XML)

Equation Y-13 Calculation Spreadsheet.xls (via XML)

Equation Y-14, Y-15 Calculation Spreadsheet.xls (via XML)

Equation Y-16a, Y-16b, Y-17 Calculation Spreadsheet.xls (via XML)

Equation Y-18 Calculation Spreadsheet.xls (via XML)

Equation Y-19 Calculation Spreadsheet.xls (supports calculation)

Equation Y-21 Calculation Spreadsheet.xls (via XML)

Equation Y-22 Calculation Spreadsheet.xls (via XML)

Equation Y-23 Calculation Spreadsheet.xls (via XML)

Equation Y-SSM Calculation Spreadsheet.xls (via XML)

Subpart MM - Suppliers of Transportation Fuels Calculation and Reporting Tool

Suppliers of Transportation Fuels Calculation and Reporting Tool.xls

Subpart NN - Suppliers of Natural Gas and NGLs

Subpart NN Natural Gas Received by End Users.xls

Subpart NN Natural Gas Deliveries to Pipelines and LDCs.xls

Subpart NN - Interstate NG Pipeline.xls

Subpart NN - LNG Received by End-Users.xls