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.
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:
Calculation Spreadsheet | Calculation Results | Instructions |
|---|---|---|
Biogenic CO2, CH4, N2O | ||
Biogenic CO2 | ||
CO2 |
Selecting the Appropriate Spreadsheet
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) |
|
|---|
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) |
|
|---|
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) |
|
|---|
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.
Calculation Spreadsheet | Calculation Results | Instructions |
|---|---|---|
Biogenic CO2, CH4, N2O | ||
Biogenic CO2 | ||
CO2 |
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.
Color coding
The calculation spreadsheets contain green input cells, gray informational cells, and red-bordered results cells filled with yellow or white. Users should use green input cells to enter all data specific to their facility, unit, or process. Gray informational cells contain parameter names, column and row headings, equation constants and subtotals. Calculation results are displayed in red-bordered results cells filled with yellow or white. For red-bordered, yellow-filled results cells, the values in these cells should be entered in the appropriate and separate calculation spreadsheet (as directed below cell) where additional calculations will be made. For red-bordered, white filled results cells, the values in these cells should be entered in e-GGRT for the appropriate process units. All cells that are not green input cells are locked and cannot be modified.
|
Green input cell (data entry) |
|
Gray informational cells (locked) |
|
Red-bordered, yellow-filled results cells (enter in appropriate and separate calculation spreadsheet) |
|
Red-bordered, white filled results cells (enter in e-GGRT) |
Stop and Warning Messages
The calculation spreadsheets will display a stop message if the user enters a value that is invalid or a warning message if the user enters a value outside the EPA estimated range for a particular data element. For invalid data entries, the stop messages will not allow a user to proceed and the user must reenter valid data before moving forward. For data entries that are outside the EPA estimated range for a particular data element, the warning messages will allow a user to proceed if the user deems the entered value to be accurate.
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 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) |
|
|---|
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 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.
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) |
|
|---|
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 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.
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) |
|
|---|
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 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.
