Using Subpart AA Calculation Spreadsheets

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

Anchor
Top
Top

Excerpt Include
Spreadsheet Usage Warning
Spreadsheet Usage Warning
nopaneltrue

...

Overview

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

...

Subpart AA requires a facility to report annual biogenic CO2, CH4, and N2O emissions from the combustion of spent liquor solids and annual CO2 emissions from make-up chemical use. To calculate the emissions, use the three equations below. Use different spreadsheet tools for different furnaces or combustion units as required.
For each kraft or soda mill chemical recovery furnace, calculate annual biogenic CO2, CH4, and N2O emissions from the combustion of spent liquor solids, using Equation AA-1 and the Equation AA-1 Calculation Spreadsheet. Equation AA-1 is provided below:

(Equation AA-1)

Image Modified

For each chemical recovery combustion unit, users should calculate annual CH4, and N2O emissions from the combustion of spent liquor solids using Equation AA-1 and the Equation AA-1 Calculation Spreadsheet and should calculate annual biogenic CO2 emissions from the combustion of spent liquor solids using Equation AA-2 and the Equation AA-2 Calculation Spreadsheet. Equation AA-2 is provided below:

(Equation AA-2)

Image Modified

For each facility with make-up chemical use, users should calculate annual CO2 emissions from make-up chemical use using Equation AA-3 and the Equation AA-3 Calculation Spreadsheet. Equation AA-3 is provided below:

(Equation AA-3)

Image Modified

h3.anchor
Downloading a Spreadsheet

...

The guidance provided in this section applies to each of the calculation spreadsheets for Subpart AA. Additional guidance is provided for each individual 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 Furnaces or Combustion Units

...

Use the Equation AA-1 Calculation Spreadsheet to calculate the annual biogenic CO2, CH4, and N2O emissions from the combustion of spent liquor solids for each kraft or soda mill chemical recovery furnace. Also use the Equation AA-1 Calculation Spreadsheet to calculate the annual CH4, and N2O emissions from the combustion of spent liquor solids for each chemical recovery combustion unit. A separate spreadsheet should be used for each furnace or combustion unit. The Equation AA-1 Calculation Spreadsheet performs the calculations using Equation AA-1, provided below.

(Equation AA-1)

Image Modified

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

...

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

Image RemovedImage Added

The spreadsheet will calculate the annual biogenic CO2, CH4, and N2O emissions from the combustion of spent liquor solids. These calculated values will be displayed in the red-bordered cells at the bottom of the spreadsheet. These values should be entered in e-GGRT for this furnace or combustion unit.

 

Image RemovedImage Added

h3.anchor
Using the Equation AA-2 Calculation Spreadsheet

Use the Equation AA-2 Calculation Spreadsheet to calculate the annual biogenic CO2 emissions from the combustion of spent liquor solids for each chemical recovery combustion unit. Use a separate spreadsheet for each combustion unit. The Equation AA-2 Calculation Spreadsheet performs the calculation using Equation AA-2, provided below.

(Equation AA-2)

Image Modified

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

...

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

Image RemovedImage Added

The spreadsheet will calculate the annual biogenic CO2 emissions from the combustion of spent liquor solids. This calculated value will be displayed in the red-bordered cells at the bottom of the spreadsheet. This value should be entered in e-GGRT for this combustion unit.

 

Image RemovedImage Added

h3.anchor
Using the Equation AA-3 Calculation Spreadsheet

Use the Equation AA-3 Calculation Spreadsheet to calculate the annual CO2 emissions from make-up chemical use. The Equation AA-3 Calculation Spreadsheet performs the calculation using Equation AA-3, provided below.

(Equation AA-3)

Image Modified

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

...

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

Image RemovedImage Added

The spreadsheet will calculate the annual CO2 emissions from make-up chemical use. This calculated value will be displayed in the red-bordered cells at the bottom of the spreadsheet. This value should be entered in e-GGRT for this combustion unit.

 

Image AddedImage Removed

Back to Top

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