Using Subpart E 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
Downloading the Calculation Spreadsheet
Downloading

...

the

...

Calculation

...

Spreadsheet

The calculation spreadsheets for Subpart E may be downloaded by clicking the link in the first column of the table below. Users may also jump to instructions for each calculation spreadsheet by clicking the link in the second column.

...

Anchor
General

...

Information on Using a Calculation Spreadsheet
General Information on Using a Calculation Spreadsheet

The guidance provided in this section applies to calculation spreadsheets for all subparts. Additional guidance specific to Subpart E is provided in the following section.

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

...

Anchor
Using

...

the Equation E-2 Calculation Spreadsheet
Using the Equation E-2

...

Calculation

...

Spreadsheet

Use the Equation E-2 Calculation Spreadsheet to calculate the abatement factor for N2O emissions for each abatement technology used by the unit. A separate spreadsheet is to be used for each unit. Users should not use aggregated data from multiple units in a single calculation spreadsheet. The Equation E-2 Calculation Spreadsheet performs the calculations using Equation E-2 provided below (see calculation spreadsheet for definitions of variables). 

  

Begin by entering the facility name, your name, the unit name or identifier, the reporting period and any additional comments in the green input cells of the General Information table located immediately below the equations in the calculation spreadsheet. This is for your records.

Next, enter the requested information in the green input cells of the input data table.



The calculation spreadsheet will then calculate the abatement utilization factor for each N2O abatement technology associated with this adipic acid production unit. The calculated values will be displayed in red-bordered cells in the column on the far right of the Data Input table. These values should be entered in the applicable calculation spreadsheet for Equation E-3a, Equation E-3b or Equation E-3c. 

...

Anchor
Using the Equation E-3a Calculation Spreadsheet
Using

...

the

...

Equation

...

E-3a

...

Calculation

...

Spreadsheet
 

Use the Equation E-3a Calculation Spreadsheet to calculate annual N2O mass emissions for a unit where a single N2O abatement technology "N" is located after your test point. A separate spreadsheet is to be used for each unit. Users should not use aggregated data from multiple units in a single calculation spreadsheet. The Equation E-3a Calculation Spreadsheet performs the calculations using Equation E-3a provided below (see calculation spreadsheet for definitions of variables).   

Image Modified

 

Begin by entering the facility name, your name, the unit name or identifier, the reporting period and any additional comments in the green input cells of the General Information table located immediately below the equations in the calculation spreadsheet. This is for your records.

Next, enter the requested information in the green input cells of the input data table.

 

Image Modified

 

The calculation spreadsheet will then calculate the annual N2O mass emissions for this adipic acid production unit. The calculated values will be displayed in the red-bordered cell in the annual N2O mass emissions table. This value should be used in Equation E-4 to calculate total annual N2O emissions for the facility.

 

Image Modified

...

Anchor
Using the Equation E-3b Calculation Spreadsheet
Using

...

the

...

Equation

...

E-3b

...

Calculation

...

Spreadsheet

Use the Equation E-3b Calculation Spreadsheet to calculate annual N2O mass emissions for a unit where a multiple N2O abatement technologies are located in series after your test point. A separate spreadsheet is to be used for each unit. Users should not use aggregated data from multiple units in a single calculation spreadsheet. The Equation E-3b Calculation Spreadsheet performs the calculations using Equation E-3b provided below (see calculation spreadsheet for definitions of variables). 

...

Begin by entering the facility name, your name, the unit name or identifier, the reporting period and any additional comments in the green input cells of the General Information table located immediately below the equations in the calculation spreadsheet. This is for your records.

Next, enter the requested information in the green input cells of the input data table. 

The calculation spreadsheet will then calculate the annual N2O mass emissions for this adipic acid production unit. The calculated values will be displayed in the red-bordered cell in the annual N2O mass emissions table. This value should be used in Equation E-4 to calculate total annual N2O emissions for the facility. 

...

Anchor
Using

...

the Equation E-3c Calculation Spreadsheet
Using the Equation E-3c

...

Calculation

...

Spreadsheet

Use the Equation E-3c Calculation Spreadsheet to calculate annual N2O mass emissions for a unit where a multiple N2O abatement technologies are located in parallel after your test point. A separate spreadsheet is to be used for each unit. Users should not use aggregated data from multiple units in a single calculation spreadsheet. The Equation E-3c Calculation Spreadsheet performs the calculations using Equation E-3c provided below (see calculation spreadsheet for definitions of variables). 

...

Begin by entering the facility name, your name, the unit name or identifier, the reporting period and any additional comments in the green input cells of the General Information table located immediately below the equations in the calculation spreadsheet. This is for your records.

Next, enter the requested information in the green input cells of the input data tables. 

The calculation spreadsheet will then calculate the annual N2O mass emissions for this adipic acid production unit. The calculated values will be displayed in the red-bordered cell in the annual N2O mass emissions table. This value should be used in Equation E-4 to calculate total annual N2O emissions for the facility.

...

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