Using Subpart S 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

...

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

...

Anchor
Understanding the Subpart S Calculation Spreadsheets
Understanding

...

the

...

Subpart

...

S

...

Calculation

...

Spreadsheets

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

(Equation S-1)

Image Modified

(Equation S-2)

Image Modified

(Equation S-3)

Image Modified

(Equation S-4)

Image Modified

Equations S-1, S-2 and S-3 calculate results that are subsequently used in Equation S-4. Separate spreadsheets exist for each equation. To calculate the total annual CO2 process emissions using the optional spreadsheets, all four spreadsheets should be downloaded.

...

Anchor
Downloading a Calculation Spreadsheet
Downloading

...

a

...

Calculation

...

Spreadsheet

Calculation spreadsheets for Subpart S may be downloaded by clicking the links in the first column of the table below. Users may also jump to instructions for each spreadsheet by clicking the links in the third column.

Calculation Spreadsheet
(click to download)

Calculation
Result

Instructions
(click to view)

Equation S-1 Calculation Spreadsheet.xls

Lime Product EF

S-1 Help

Equation S-2 Calculation Spreadsheet.xls

Byproduct/Waste EF

S-2 Help

Equation S-3 Calculation Spreadsheet.xls

Byproduct/Waste Emissions

S-3 Help

Equation S-4 Calculation Spreadsheet.xls

Total Annual Process Emissions

S-4 Help

...

Anchor
General Information on Using a Calculation Spreadsheet
General

...

Information

...

on

...

Using

...

a

...

Calculation

...

Spreadsheet

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

...

Users should first complete calculations using the S-1, S-2 and S-3 Spreadsheets and then enter the results of each calculation into the S-4 Spreadsheet to calculate the total annual CO2 process emissions from lime production for all kilns.

...

Anchor
Using the S-1 Calculation Spreadsheet
Using

...

the

...

S-1

...

Calculation

...

Spreadsheet

Use the S-1 Calculation Spreadsheet to calculate the monthly emission factors for a lime type. A separate spreadsheet is to be used for each lime type produced. The S-1 Spreadsheet performs the calculation using Equation S-1, provided below.

(Equation S-1)

Image Modified

Begin by entering the facility name, your name, the lime type description, the reporting year and any additional comments in the green input cells of the General Information table located immediately below the equation in the spreadsheet. This is for your records.

...

The spreadsheet will calculate the monthly emission factors for a given lime type. These calculated values will be displayed in the red-bordered cells in the S-1 Results table at the bottom of the spreadsheet. These values should be entered in the S-4 Spreadsheet for each lime type to calculate annual CO2 process emissions from lime production for all kilns. When completed, each lime product produced at the lime facility must have an S-1 Spreadsheet.

...

Anchor
Using the S-2 Calculation Spreadsheet
Using

...

the

...

S-2

...

Calculation

...

Spreadsheet

Use the S-2 Calculation Spreadsheet to calculate the monthly emission factors for a calcined-lime byproduct or waste type that is sold. A separate spreadsheet is to be used for each byproduct or waste type sold. The S-2 Spreadsheet performs the calculation using Equation S-2, provided below.

(Equation S-2)

Image Modified

Begin by entering the facility name, your name, the byproduct/waste type description, the reporting period, and any additional comments in the green input cells of the General Information table located immediately below the equation in the spreadsheet. This is for your records.

...

The spreadsheet will calculate the monthly emission factors for a given calcined-lime byproduct or waste type that is sold. These calculated values will be displayed in the red-bordered cells in the S-2 Results table at the bottom of the spreadsheet. These values should be entered in the S-4 Spreadsheet for each byproduct or waste type sold to calculate annual CO2 process emissions from lime production for all kilns. When completed, each lime byproduct or waste that is sold by the lime facility must have an S-2 Spreadsheet.

...

Anchor
Using the S-3 Calculation Spreadsheet
Using

...

the

...

S-3

...

Calculation

...

Spreadsheet

Use the S-3 Calculation Spreadsheet to calculate the annual CO2 emissions for a calcined-lime byproduct or waste type that is not sold. A separate spreadsheet is to be used for each byproduct or waste type that is not sold. The S-3 Spreadsheet performs the calculation using Equation S-3, provided below.

(Equation S-3)

Image Modified

Begin by entering the facility name, your name, the byproduct/waste type description, the reporting period, and any additional comments in the green input cells of the General Information table located immediately below the equation in the spreadsheet. This is for your records.

...

The spreadsheet will calculate the annual CO2 emissions for a calcined-lime byproduct or waste type that is not sold. This calculated value will be displayed in the red-bordered cell in the S-3 Results table at the bottom of the spreadsheet. This value should be entered in the S-4 spreadsheet for each byproduct or waste type that is not sold to calculate annual CO2 process emissions from lime production for all kilns. When completed, each lime byproduct or waste that is not sold by the lime facility must have an S-3 Spreadsheet.

...

Anchor
Using the S-4 Calculation Spreadsheet
Using

...

the

...

S-4

...

Calculation

...

Spreadsheet

Use the S-4 Calculation Spreadsheet to calculate the annual CO2 process emissions from lime production from all kilns. The S-4 Spreadsheet performs the calculation using Equation S-4, provided below.

(Equation S-4)

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 spreadsheet. This is for your records.

...

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