Using Subpart C Calculation Spreadsheets
Note: The Cal e-GGRT help system includes general instruction on using the California GHG reporting tool. However, the help system may not explain differences between California and U.S. EPA reporting requirements. Please refer to the ARB reporting website for California-specific reporting requirements and additional help.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

Anchor
Top
Top
This help page provides guidance for working with the supplemental subpart C calculation spreadsheets. The guidance provides step-by-step instructions for the following tasks:

Specific information on each of the calculation spreadsheets is provided below:

h3.anchor
Selecting the Appropriate Calculation Spreadsheet

To calculate emissions for stationary combustion units reporting under subpart C, users may use the spreadsheets described in the table below. The equations for calculating CO2 mass emissions and CH4/N2O mass emissions are combined onto one spreadsheet as appropriate. The table below describes the equation inputs, outputs, and the Tier and Cal e-GGRT configuration types in which each equation may apply. Note that some Tiers and Configurations only allow the use of a given equation for certain situations. Ultimately, the user should refer to 40 CFR 98.33(b) to determine which Tier is allowed and to 40 CFR 98.33(a) to determine which equation within a Tier is appropriate. If a configuration combusts multiple fuel types, it is possible that different tiers and different equations may be used for that given configuration. The spreadsheets are designed to account for one type of fuel, so each additional fuel combusted in a configuration will need a new spreadsheet.

Calculation Spreadsheet

Tier

Basis for Calculations

Configuration
Types

Output(s)

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

2

Fuel Use, Measured Fuel Carbon Content

1, 3, 4

CCannual

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

2

Fuel Use, Measured Fuel Carbon Content, Measured Molecular Weight

1, 3, 4

CCannual
MWannual

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

2

Fuel Use, Measured High Heat Value

1, 3, 4

HHVannual

Tier 2 Calculation Methodology

Equation C-2b (CC) Calculation Spreadsheet

Use this spreadsheet to calculate the annual average CC emissions for a fuel combustion configuration that uses the Equation C-2b, Tier 2 calculation methodology. This spreadsheet performs the calculations using Equations C-2b (CC), which are provided below:

(Equation C-2b (CC))

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

Use this spreadsheet to calculate the annual average CC and MW emissions for a fuel combustion configuration that uses the Equation C-2b, Tier 2 calculation methodology. This spreadsheet performs the calculations using Equations C-2b (CC and MW), which are provided below:

(Equation C-2b (CC and MW))

Equation C-2b (HHV) Calculation Spreadsheet

Use this spreadsheet to calculate the annual average HHV emissions for a fuel combustion configuration that uses the Equation C-2b, Tier 2 calculation methodology. This spreadsheet performs the calculations using Equations C-2b (HHV), which are provided below:

(Equation C-2b (HHV))

h3.anchor
Downloading a Calculation Spreadsheet

Calculation spreadsheets for subpart C may be downloaded by clicking one of the links in the first column of the table below. Users may also jump to instructions for each calculation spreadsheet by clicking one of the links in the second column.

h3.anchor
Using a Calculation Spreadsheet to Make Calculations

The guidance provided in this section applies to each of the calculation spreadsheets for subpart C. Additional guidance is provided for each individual calculation spreadsheet in the sections below.

Include Page
Spreadsheet Color Coding
Spreadsheet Color Coding
Include Page
Spreadsheet Stop and Warning Messages
Spreadsheet Stop and Warning Messages

Multiple Configuration Types and Multiple Fuels

Users with multiple configuration types and multiple fuels should use separate calculation spreadsheets for each configuration type and for each fuel. Users should not aggregate data for multiple configuration types or fuels when using these calculation spreadsheets.

h3.anchor
Using the Equation C-2b (CC) Calculation Spreadsheet

Use this spreadsheet to calculate the annual average CC emissions for a stationary fuel combustion configuration that uses the Equation C-2b (CC), Tier 2 calculation methodology. Use a separate spreadsheet for each configuration and for each fuel. The Equation C-2b (CC) Calculation Spreadsheet performs the calculations using Equations C-2b (CC) provided below.

(Equation C-2b (CC))

Begin by entering the facility name, your name, the configuration identifier, reporting period, and any additional comments in the green input cells of the general information table located immediately below the equation in the calculation spreadsheet. This is for your records.

Next, enter the requested information in the green input cells in the Fuel Input Data table.

The calculation spreadsheet will calculate the annual average CC emissions of fuel. The calculated values will be displayed in red-bordered cells at the bottom of the spreadsheet. These values should be entered in Cal e-GGRT for this fuel and configuration type combination.

h3.anchor
Using the Equation C-2b (CC and MW) Calculation Spreadsheet

Use this spreadsheet to calculate the annual average CC and MW emissions for a fuel combustion configuration that uses the Equation C-2b (CC and MW), Tier 2 calculation methodology. Use a separate spreadsheet for each configuration and for each fuel. The Equation C-2b (CC and MW) Calculation Spreadsheet performs the calculations using Equations C-2b (CC and MW) provided below.

(Equation C-2b (CC))

(Equation C-2b (MW))

Begin by entering the facility name, your name, the configuration identifier, reporting period, and any additional comments in the green input cells of the general information table located immediately below the equation in the calculation spreadsheet. This is for your records.

Next, enter the requested information in the green input cells in the Fuel Input Data table.

The calculation spreadsheet will calculate the annual average CC and MW emissions of fuel. The calculated values will be displayed in red-bordered cells at the bottom of the spreadsheet. These values should be entered in Cal e-GGRT for this fuel and configuration type combination.

h3.anchor
Using the Equation C-2b (HHV) Calculation Spreadsheet

Use this spreadsheet to calculate the annual average HHV emissions for a fuel combustion configuration that uses the Equation C-2b (HHV), Tier 2 calculation methodology. Use a separate spreadsheet for each configuration and for each fuel. The Equation C-2b (HHV) Calculation Spreadsheet performs the calculations using Equations C-2b (HHV) provided below.

(Equation C-2b (HHV))

Begin by entering the facility name, your name, the configuration identifier, reporting period, and any additional comments in the green input cells of the general information table located immediately below the equation in the calculation spreadsheet. This is for your records.

Next, enter the requested information in the green input cells in the Fuel Input Data table.

The calculation spreadsheet will calculate the annual average HHV emissions of fuel. The calculated values will be displayed in red-bordered cells at the bottom of the spreadsheet. These values should be entered in Cal e-GGRT for this fuel and configuration type combination.

Back to Top

See Also

Children Display

This web site is maintained by a contractor to the California Air Resources Board (RY2015.R.03)