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:

• Selecting the Appropriate Spreadsheet
• Downloading a Spreadsheet
• Using the Equation AA-1 Calculation Spreadsheet
• Using the Equation AA-2 Calculation Spreadsheet
• Using the Equation AA-3 Calculation Spreadsheet

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

Selecting the Appropriate Spreadsheet

Subpart AA requires a facility to report annual biogenic CO₂, CH₄, and N₂O emissions from the combustion of spent liquor solids and annual CO₂ 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 CO₂, CH₄, and N₂O 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:

For each chemical recovery combustion unit, users should calculate annual CH₄, and N₂O emissions from the combustion of spent liquor solids using Equation AA-1 and the Equation AA-1 Calculation Spreadsheet and should calculate annual biogenic CO₂ 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:

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

Downloading a Spreadsheet

Calculation spreadsheets for Subpart AA 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 spreadsheet by clicking one of the links in the third column.

Using a Spreadsheet to Make Calculations

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.

Multiple Furnaces or Combustion Units

Users with multiple furnaces or combustion units should use separate spreadsheets for each furnace or combustion unit. Users should not aggregate data for multiple furnaces or combustion units when using these spreadsheets.

Using the Equation AA-1 Calculation Spreadsheet

Use the Equation AA-1 Calculation Spreadsheet to calculate the annual biogenic CO₂, CH₄, and N₂O 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 CH₄, and N₂O 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.

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.

The spreadsheet will calculate the annual biogenic CO₂, CH₄, and N₂O 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.

Using the Equation AA-2 Calculation Spreadsheet

Use the Equation AA-2 Calculation Spreadsheet to calculate the annual biogenic CO₂ 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.

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.

The spreadsheet will calculate the annual biogenic CO₂ 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.

Using the Equation AA-3 Calculation Spreadsheet

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

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.

The spreadsheet will calculate the annual CO₂ 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.

Back to Top