Using Subpart C Calculation Spreadsheets

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
Top
Top

...

Overview

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:

...

Calculation Spreadsheet
(click to download)

...

Instructions
(click to view)

Info

These optional spreadsheets are provided to assist reporters in calculating emissions and in keeping records of these calculations.

Reporters are required to keep records of these calculations under 40 CFR 98.3(g) and additional subpart-specific provisions, but are not required to use these spreadsheets or to submit any spreadsheets to EPA.

Spreadsheets may include inputs to emission equations, reporting of which EPA deferred some until 2015.
(See 76 FR 53057, published August 25, 2011, http://www.gpo.gov/fdsys/pkg/FR-2011-08-25/pdf/2011-21727.pdf).

The data elements deferred until 2013 that will be collected for the first time in RY2012 enable emissions calculations to be executed within e-GGRT for certain subpart equations. As a result, affected Optional Calculation Spreadsheets will become obsolete. The Optional Calculation Spreadsheets associated with the equations below will become obsolete for this subpart beginning RY2012:

  • Equation C-10
  • Equation C-11

Copies of these spreadsheets can be downloaded at the Calculation Spreadsheet Archive.

Overview

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:

...

Equation C-1, C-8 Calculation Spreadsheet.xls

...

...

C-1a, C-8a Help

...

...

...

...

...

C-2a, C-2b, C-9a Help

...

C-2c, C-9b Help

...

C-3, C-8 Help

...

C-4, C-8 Help

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

h3.anchor
Selecting the Appropriate Calculation Spreadsheet
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 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. 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 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-1, C-8 Calculation Spreadsheet.xls

1

EF, Fuel Use, Default HHV

1, 3, 4

CO2
CH4
N2O

Equation C-1a, C-8a Calculation Spreadsheet.xls

1

EF, Natural Gas Billing Records

1, 3, 4

CO2
CH4
N2O

Equation C-1b, C-8b Calculation Spreadsheet.xls

1

EF, Natural Gas Billing Records

1, 3, 4

CO2
CH4
N2O

Equation C-2a, C-2b, C-9a Calculation Spreadsheet.xls

2

EF, Fuel Use, Measured HHV

1, 3, 4

CO2
CH4
N2O

Equation C-2c, C-9b Calculation Spreadsheet.xls

2

EF, Steam Use, Boiler Max Rated Heat Input Capacity

1, 3, 4

CO2
CH4
N2O

Equation C-3, C-8 Calculation Spreadsheet.xls

3

Fuel Use, Measured Fuel Carbon Content

1, 3, 4

CO2
CH4
N2O

Equation C-4, C-8 Calculation Spreadsheet.xls

3

Fuel Use, Measured Fuel Carbon Content

1, 3, 4

CO2
CH4
N2O

Equation C-5, C-8 Calculation Spreadsheet.xls

3

Fuel Use, Measured Fuel Carbon Content

1, 3, 4

CO2
CH4
N2O

Equation C-10 Calculation Spreadsheet.xls

4

EF, Heat Input from Combustion

2, 5, 6

CH4
N2O

Equation C-11 Calculation Spreadsheet.xls

N/A

Sorbent Use, Normalized moles CO2 Released upon Capture, Molecular Weight CO2, Molecular Weight of Sorbent

1, 3

CO2

Tier 1 Calculation Tier 1 Calculation Methodology

To calculate annual CO2, CH4, and N2O mass emissions for each type of fuel using Tier 1 in each reporting configuration, use Equation C-1, C-8 Calculation Spreadsheet, Equation C-1a, C-8a Calculation Spreadsheet (natural gas billed in therms only), or Equation C-1b, C-8b Calculation Spreadsheet (natural gas billed in mmBtu only).

...

(Equation C-5)

(Equation C-8)

Tier 4 Calculation Methodology

To calculate the annual CH4, and N2O mass emissions for each type of fuel in each reporting configuration, use Equation C--10 Calculation Spreadsheet.

In addition to units reporting under Tier 4, this spreadsheet may also be used by units using the alternative reporting option in 40 CFR 98.33(a)(5) and by units reporting under subpart D. This spreadsheet performs the calculation using Equation C-10, which is provided below. The provided spreadsheets do not assist the user in calculating CO2 emissions for units using CEMS.

(Equation C-10)

Image Removed

Annual CO2 Mass Emissions from Sorbent Use

When a unit is a fluidized bed boiler, is equipped with a wet flue gas desulfurization system, or uses other acid gas emission controls with sorbent injection to remove acid gases, and if the chemical reaction between the acid gas and the sorbent produces CO2 emissions, use Equation C-11 to calculate the CO2 emissions from the sorbent, except when those CO2 emissions are monitored by CEMS. Reporting of CO2 mass emissions from sorbent is only required for Configuration Types 1 and 3. To calculate CO2 mass emissions from sorbent use for each reporting configuration, use Equation C-11 Calculation Spreadsheet. This spreadsheet performs the calculation using Equation C-11, which is provided below.

(Equation C-11)

Image Removed

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.

...

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
help:Spreadsheet Color Coding
help:Spreadsheet Color Coding
Include Page
help:Spreadsheet Stop and Warning Messages
help: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.

...

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-1, C-8 Calculation Spreadsheet

Use this spreadsheet to calculate the annual CO2, CH4, and N2O mass emissions for a stationary fuel combustion configuration that uses the Equation C-1, Tier 1 calculation methodology for any given fuel. Use Equation C-1 on this spreadsheet except when natural gas billing records are used to quantify fuel usage and gas consumption is expressed in units of therms or million Btu. In that case, use Equation C-1a or C-1b, as applicable. Use a separate spreadsheet for each configuration and for each fuel. The Equation C-1, C-8 Calculation Spreadsheet performs the calculations using Equations C-1 and C-8 provided below.

(Equation C-1)

Image Removed

(Equation C-8)

Image Removed

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.

Image Removed

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

Image Removed

The calculation spreadsheet will calculate the annual CO2, CH4, and N2O emissions from fuel combustion. The calculation spreadsheet will also convert CH4 and N2O emissions to units of carbon dioxide equivalent (CO2e). The calculated values will be displayed in red-bordered cells at the bottom of the spreadsheet. These values should be entered in e-GGRT for this fuel and configuration type combination.

Image Removed

h3.anchor
Using the Equation C-1a, C-8a Calculation Spreadsheet

Use this spreadsheet to calculate the annual CO2, CH4, and N2O emissions from natural gas usage for a configuration that fires natural gas and if billing records are used to quantify fuel usage and gas consumption is expressed in units of therms. Use a separate spreadsheet for each configuration and for each fuel. The Equation C-1a, C-8a Calculation Spreadsheet performs the calculations using Equations C-1a and C-8a provided below.

(Equation C-1a)

Image Removed

(Equation C-8a)

Image Removed

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.

Image Removed

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

Image Removed

The calculation spreadsheet will calculate the annual CO2, CH4, and N2O emissions from fuel combustion. The calculation spreadsheet will also convert CH4 and N2O emissions to units of carbon dioxide equivalent (CO2e). The calculated values will be displayed in red-bordered cells at the bottom of the spreadsheet. These values should be entered in e-GGRT for this fuel and configuration type combination.

Image Removed

h3.anchor
Using the Equation C-1b1, C-8b8 Calculation Spreadsheet

Use this spreadsheet to calculate the annual CO2, CH4, and N2O mass emissions from natural gas usage for a configuration that fires natural gas and if stationary fuel combustion configuration that uses the Equation C-1, Tier 1 calculation methodology for any given fuel. Use Equation C-1 on this spreadsheet except when natural gas billing records are used to quantify fuel usage and gas consumption is expressed in units of mmBtutherms or million Btu. In that case, use Equation C-1a or C-1b, as applicable. Use a separate spreadsheet for each configuration and for each fuel. The Equation C-1b1, C-8b 8 Calculation Spreadsheet performs the calculations using Equations C-1b 1 and C-8b 8 provided below.

(Equation C-1b1)

Image Removed Image Added

(Equation C-8b)

Image Removed

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.

Image Removed

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

Image Removed

The calculation spreadsheet will calculate the annual CO2, CH4, and N2O emissions from fuel combustion. The calculation spreadsheet will also convert CH4 and N2O emissions to units of carbon dioxide equivalent (CO2e). The calculated values will be displayed in red-bordered cells at the bottom of the spreadsheet. These values should be entered in e-GGRT for this fuel and configuration type combination.

Image Removed

h3.anchor
Using the Equation C-2a, C-2b, C-9a Calculation Spreadsheet

8)

Image Added

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.

Image Added

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

Image Added

The calculation spreadsheet will Use this spreadsheet to calculate the annual CO2, CH4, and N2O mass emissions for a stationary fuel combustion configuration that uses the Equation C-2a, Tier 2 calculation methodology. This spreadsheet performs the calculation using Equations C-2a, C-2b, and C-9a, which are provided below (although included, Equation C-2b is not always required, see 40 CFR 98.33(a)(2)(ii)). Use a separate spreadsheet for each configuration and for each fuel. The Equation C-2a, C-2b, C-9a Calculation Spreadsheet performs the calculations using Equations C-2a, C-2b, and C-9a provided below.

(Equation C-2a)

Image Removed

(Equation C-2b)

Image Removed

(Equation C-9a)

Image Removed

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.

Image Removed

Next, enter the requested information in the green input cells in the Input for Weighted Annual Average HHV (only if required or elected) table.

Image Removed

The calculation spreadsheet will calculate the weighted annual average high heat value of the fuel (HHVannual). The calculated value will be displayed in a red-bordered cell with yellow fill above the Fuel Input Data table. This value should be entered in the Fuel Input Data table (shown below) along with the mass or volume of fuel combusted during the reporting year. Alternatively, you may enter an annual average HHV consistent with Section 98.33(a)(2)(ii).

from fuel combustion. The calculation spreadsheet will also convert CH4 and N2O emissions to units of carbon dioxide equivalent (CO2e). The calculated values will be displayed in red-bordered cells at the bottom of the spreadsheet. These values should be entered in e-GGRT for this fuel and configuration type combination.

Image Added

h3.anchor
Using the Equation C-1a, C-8a Calculation Spreadsheet

Use this spreadsheet to calculate the annual CO2, CH4, and N2O emissions from natural gas usage for a configuration that fires natural gas and if billing records are used to quantify fuel usage and gas consumption is expressed in units of therms. Use a separate spreadsheet for each configuration and for each fuel. The Equation C-1a, C-8a Calculation Spreadsheet performs the calculations using Equations C-1a and C-8a provided below.

(Equation C-1a)

Image Added

(Equation C-8a)

Image Added

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.

Image AddedImage Removed

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

Image RemovedImage Added

The calculation spreadsheet will calculate the annual CO2, CH4, and N2O emissions from fuel combustion. The calculation spreadsheet will also convert CH4 and N2O emissions to units of carbon dioxide equivalent (CO2e). The calculated values will be displayed in red-bordered cells with white fill at the bottom of the spreadsheet. These values should be entered in e-GGRT for this fuel and configuration type combination.

Image Removed Image Added

h3.anchor
Using the Equation C-2c1b, C-9b8b Calculation Spreadsheet

Use this spreadsheet to calculate the annual CO2 , CH4, and N2O emissions from natural gas usage for a stationary fuel combustion configuration that uses the Equation C-2c, Tier 2 calculation methodology. This spreadsheet should be used for MSW when the use of Tier 2 is allowed or (optionally) for solid fuels using Tier 2 in units that generate steamconfiguration that fires natural gas and if billing records are used to quantify fuel usage and gas consumption is expressed in units of mmBtu. Use a separate spreadsheet for each configuration and for each fuel. The Equation C-2c1b, C-9b 8b Calculation Spreadsheet performs the calculations using Equations C-2c 1b and C-9b 8b provided below.

(Equation C-2c1b)

Image Removed Image Added

(Equation C-9b8b)

Image Removed Image Added

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.

Image RemovedImage Added

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

Image RemovedImage Added

The calculation spreadsheet will calculate the annual CO2, CH4, and N2O emissions from fuel combustion. The calculation spreadsheet will also convert CH4 and N2O emissions to units of carbon dioxide equivalent (CO2e). The calculated values will be displayed in red-bordered cells at the bottom of the spreadsheet. These values should be entered in e-GGRT for this fuel and configuration type combination.

Image RemovedImage Added

h3.anchor
Using the Equation C-32a, C-2b, C-89a Calculation Spreadsheet

Use this spreadsheet to calculate the annual CO2, CH4, and N2, CH4, and N2O mass emissions for solid fuels using Tier 3 Calculation methodology at each configurationO mass emissions for a stationary fuel combustion configuration that uses the Equation C-2a, Tier 2 calculation methodology. This spreadsheet performs the calculation using Equations C-2a, C-2b, and C-9a, which are provided below (although included, Equation C-2b is not always required, see 40 CFR 98.33(a)(2)(ii)). Use a separate spreadsheet for each configuration and for each fuel. The Equation C-3, C-8 Calculation Spreadsheet performs the calculations using Equations C-3 and C-8 provided below.

(Equation C-3)

Image Removed

(Equation C-8)

Image Removed

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.

. The Equation C-2a, C-2b, C-9a Calculation Spreadsheet performs the calculations using Equations C-2a, C-2b, and C-9a provided below.

(Equation C-2a)

Image Added

(Equation C-2b)

Image Added

(Equation C-9a)

Image Added

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.

Image Added

Next, enter the requested information in the green input cells in the Input for Weighted Annual Average HHV (only if required or elected) table.

Image Added

The calculation spreadsheet will calculate the weighted annual average high heat value of the fuel (HHVannual). The calculated value will be displayed in a red-bordered cell with yellow fill above the Fuel Input Data table. This value should be entered in the Fuel Input Data table (shown below) along with the mass or volume of fuel combusted during the reporting year. Alternatively, you may enter an annual average HHV consistent with Section 98.33(a)(2)(ii).

Image AddedImage Removed

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

Image RemovedImage Added

The calculation spreadsheet will calculate the annual CO2, CH4, and N2O emissions from fuel combustion. The calculation spreadsheet will also convert CH4 and N2O emissions to units of carbon dioxide equivalent (CO2e). The calculated values will be displayed in red-bordered cells with white fill at the bottom of the spreadsheet. These values should be entered in e-GGRT for this fuel and configuration type combination.

Image RemovedImage Added

h3.anchor
Using the Equation C-42c, C-89b Calculation Spreadsheet

Use this spreadsheet to calculate the annual CO2, CH4, and N2O mass emissions for liquid fuels using the Tier 3 calculation methodology at each configurationspreadsheet to calculate the annual CO2, CH4, and N2O emissions for a stationary fuel combustion configuration that uses the Equation C-2c, Tier 2 calculation methodology. This spreadsheet should be used for MSW when the use of Tier 2 is allowed or (optionally) for solid fuels using Tier 2 in units that generate steam. Use a separate spreadsheet for each configuration and for each fuel. The Equation C-42c, C-8 9b Calculation Spreadsheet performs the calculations using Equations C-4 2c and C-8 9b provided below.

(Equation C-42c)

Image Removed Image Added

(Equation C-89b)

Image Removed Image Added

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.

Image RemovedImage Added

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

Image RemovedImage Added

The calculation spreadsheet will calculate the annual CO2, CH4, and N2O emissions from fuel combustion. The calculation spreadsheet will also convert CH4 and N2O emissions to units of carbon dioxide equivalent (CO2e). The calculated values will be displayed in red-bordered cells at the bottom of the spreadsheet. These values should be entered in e-GGRT for this fuel and configuration type combination.

Image RemovedImage Added

h3.anchor
Using the Equation C-53, C-8 Calculation Spreadsheet

Use this spreadsheet to calculate the annual CO2, CH4, and N2O mass emissions for gaseous solid fuels using the Tier 3 calculation Calculation methodology at each configuration. Use a separate spreadsheet for each configuration and for each fuel. The Equation C-53, C-8 Calculation Spreadsheet performs the calculations using Equations C-5 3 and C-8 provided below.

(Equation C-53)

Image Removed Image Added

(Equation C-8)

Image Modified

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.

Image RemovedImage Added

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

Image RemovedImage Added

The calculation spreadsheet will calculate the annual CO2, CH4, and N2O emissions from fuel combustion. The calculation spreadsheet will also convert CH4 and N2O emissions to units of carbon dioxide equivalent (CO2e). The calculated values will be displayed in red-bordered cells at the bottom of the spreadsheet. These values should be entered in e-GGRT for this fuel and configuration type combination.

Image RemovedImage Added

h3.anchor
Using the Equation C-104, C-8 Calculation Spreadsheet

Use the Equation C-10 Calculation Spreadsheet this spreadsheet to calculate the annual CO2, CH4, and N2O mass emissions using an emission factor and the annual heat input from a fuel combusted in units that use Tier 4 (CEMS, Configuration Types 2 and 5) or units that report under 40 CFR Part 75 (Configuration Type 6)for liquid fuels using the Tier 3 calculation methodology at each configuration. Use a separate spreadsheet for each configuration and for each fuel. The Equation C-4, C-10 8 Calculation Spreadsheet performs the calculations using Equation Equations C-4 and C-10 8 provided below.

(Equation C-4)

Image Added

(Equation C-810)

Image Removed Image Added

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.

Image RemovedImage Added

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

Image Removed

The calculation spreadsheet will calculate the annual CH4 and N2O emissions from fuel combustion. The calculated values will be displayed in red-bordered cells near the bottom of the spreadsheet.

Note

Note: These values should be entered in e-GGRT if this is NOT a "part 75 unit" (i.e. a unit that is subject to subpart D or a unit that uses the methods in part 75 to quantify CO2 mass emissions in accordance with ยง98.33(a)(5)).

Image Removed

the Fuel Input Data table.

Image Added

The calculation spreadsheet will calculate the annual CO2, CH4, and N2O emissions from fuel combustion. The calculation spreadsheet will also convert CH4 and N2O emissions to units of carbon dioxide equivalent (CO2e). The calculated values will be displayed in red-bordered cells at the bottom of the spreadsheet.

...

These values should be entered in e-GGRT

...

for this fuel and configuration type combination.

Image Added

h3.anchor
Using the Equation C-5, C-8 Calculation Spreadsheet

Use this spreadsheet to calculate the annual CO2, CH4, and N2O mass emissions for gaseous fuels using the Tier 3 calculation methodology at each configuration. Use a separate spreadsheet for each configuration and for each fuel. The Equation C-5, C-8 Calculation Spreadsheet performs the calculations using Equations C-5 and C-8 provided below.

(Equation C-5)

Image Added

(Equation C-8)

Image Added

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.

Image Added

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

Image Added

The calculation spreadsheet will calculate the annual CO2, CH4, and N2O emissions from fuel combustion. The calculation spreadsheet will also convert CH4 and N2O emissions to units of carbon dioxide equivalent (CO2e). The calculated values will be displayed in red-bordered cells at the bottom of the spreadsheet. These values should be entered in e-GGRT for this fuel and configuration type combination.

Image Added

h3.anchor
Using the Equation C-10 Calculation Spreadsheet

Use the Equation C-10 Calculation Spreadsheet to calculate annual CH4, and N2O emissions using an emission factor and the annual heat input from a fuel combusted in units that use Tier 4 (CEMS, Configuration Types 2 and 5) or units that report under 40 CFR Part 75 (Configuration Type 6). Use a separate spreadsheet for each configuration and for each fuel. The Equation C-10 Calculation Spreadsheet performs the calculations using Equation C-10 provided below.

Image Removed

h3.anchor
Using the Equation C-11 Calculation Spreadsheet

Use the Equation C-11 Calculation Spreadsheet to calculate annual CO2 emissions from sorbent use using annual sorbent use, the number of moles CO2 released upon capture of one mole of the acid gas species being removed, the molecular weight of CO2, and the molecular weight of sorbent. This data is only required for configuration types 1 and 3. Use a separate spreadsheet for each configuration and for each fuel. The Equation C-11 Calculation Spreadsheet performs the calculations using Equation C-11 provided below.

(Equation C-11)

Image Removed

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.

Image Removed

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

Image Removed

The calculation spreadsheet will calculate the annual CO2 emissions from sorbent use. The calculated value will be displayed in red-bordered cell at the bottom of the spreadsheet. This value should be entered in e-GGRT for this fuel and configuration type combination.

Image Removed

Back to Top

See Also

...

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