Using Subpart H Calculation Spreadsheets

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

Excerpt Include
Spreadsheet Usage Warning
Spreadsheet Usage Warning
nopaneltrue

Overview

This help page provides guidance for working with the supplemental Subpart H calculation spreadsheets. The guidance provides step-by-step instructions for the following tasks:

...

Specific information on each of the spreadsheet tools is provided below:

Calculation Spreadsheet
(click to download)

Unit
Level

Calculation
Result

Instructions
(click to view)

Equation H-1 Calculation Spreadsheet.xls

All kilns

Total CO2 from Cement Production

H-1 Help

Equation H-2, H-3, H-4 Calculation Spreadsheet.xls

Single kiln

CO2 from Clinker Production

H-2, H-3, H-4 Help

Equation H-5 Calculation Spreadsheet.xls

Single kiln

CO2 from Raw Materials

H-5 Help

...

 

Anchor
Understanding the Flow of Subpart H Calculation Spreadsheets
Understanding

...

the

...

Flow

...

of

...

Subpart

...

H

...

Calculation

...

Spreadsheets

Subpart H requires a facility to report annual CO2 process emissions from cement production for all kilns. To calculate these emissions, users must use the five equations displayed below:

(Equation H-1)

Image Modified

(Equation H-2)

Image Modified

(Equation H-3)

Image Modified

(Equation H-4)

Image Modified

(Equation H-5)

Image Modified

Equations H-2, H-3, H-4, and H-5 calculate results for a kiln that are subsequently used in Equation H-1. Three different calculation spreadsheets must be used to calculate the total annual CO2 process emissions from cement production for all kilns (Equations H-2, H-3, and H-4 are grouped into a single calculation spreadsheet). Users should first complete calculations using Equation H-2, H-3, H-4 Calculation Spreadsheet and Equation H-5 Calculation Spreadsheet for each kiln and then enter the results for each kiln into the Equation H-1 Calculation Spreadsheet to calculate the total annual CO2 process emissions from cement production for all kilns.

...

Anchor
Downloading

...

a Calculation Spreadsheet
Downloading a

...

Calculation

...

Spreadsheet

Calculation spreadsheets for Subpart H 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 third column.

Calculation Spreadsheet
(click to download)

Unit
Level

Calculation
Result

Instructions
(click to view)

Equation H-1 Calculation Spreadsheet.xls

All kilns

Total CO2 from Cement Production

H-1 Help

Equation H-2, H-3, H-4 Calculation Spreadsheet.xls

Single kiln

CO2 from Clinker Production

H-2, H-3, H-4 Help

Equation H-5 Calculation Spreadsheet.xls

Single kiln

CO2 from Raw Materials

H-5 Help

...

Anchor
Using a Spreadsheet to Make Calculations
Using

...

a

...

Spreadsheet

...

to

...

Make

...

Calculations

The guidance provided in this section applies to each of the calculation spreadsheets for Subpart H. Additional guidance is provided for each individual calculation worksheet in the sections below.

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

...

Anchor
Multiple

...

Kilns
Multiple Kilns

Users with multiple kilns should use separate calculation spreadsheets for each kiln. Users should not aggregate data from multiple kilns until requested to do so in the Equation H-1 Calculation Spreadsheet.

...

Anchor
Using

...

the Equation H-1 Calculation Spreadsheet
Using the Equation H-1

...

Calculation

...

Spreadsheet

Use this spreadsheet to calculate total annual CO2 process emissions from all kilns used in cement production. Calculated results from the Equation H-2, H-3, H-4 Calculation Spreadsheet and the Equation H-5 Calculation Spreadsheet are required as inputs to the Equation H-1 Calculation Spreadsheet. Be sure to complete the Equation H-2, H-3, H-4 Calculation Spreadsheet and the Equation H-5 Calculation Spreadsheet before beginning work on the Equation H-1 Calculation Spreadsheet. Equation H-1 is provided below.

(Equation H-1)

Image Modified

Begin by entering the facility name, your name, the 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 H-1 calculation spreadsheet will calculate the total annual CO2 process emissions from cement production for all kilns. The calculated value will be displayed in a red-bordered cell with white fill at the bottom of the spreadsheet. This value should be entered in e-GGRT for this facility.

...

Anchor
Using the Equation H-2, H-3, H-4 Calculation Spreadsheet
Using the Equation

...

H-2,

...

H-3,

...

H-4

...

Calculation

...

Spreadsheet

Use this spreadsheet to calculate the annual CO2 emissions from clinker production for each kiln by first using Equations H-3 and H-4 to calculate emission factors which are then used in Equation H-2 to calculate emissions. Equations H-2, H-3, and H-4 are provided below.

(Equation H-2)

Image Modified

(Equation H-3)

Image Modified

(Equation H-4)

Image Modified

Begin by entering the facility name, your name, the unit (e.g. kiln) name or identifier, the 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 spreadsheet will calculate the annual CO2 process emissions from clinker production for a single kiln. The calculated value will be displayed in a red-bordered cell with yellow fill at the bottom of the spreadsheet. This value should be entered into the Equation H-1 Calculation Spreadsheet.

...

Anchor
Using

...

the Equation H-5 Calculation Spreadsheet
Using the Equation H-5

...

Calculation

...

Spreadsheet

Use this spreadsheet to calculate the total annual CO2 emissions from raw materials used in cement production. Equation H-5 is provided below.

(Equation H-5)

Image Modified

Begin by entering the facility name, your name, the 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.

...

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