Using Subpart X 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 calculation spreadsheets is provided below:

Calculation Spreadsheet
(click to download)

Calculation
Result

Selection Criteria:
Feedstock/Product Type

Instructions
(click to view)

Equation X-1 Calculation Spreadsheet.xls

Net Contribution to Calculated Emissions from Carbon Materials

Gaseous

X-1 Help

Equation X-2 Calculation Spreadsheet.xls

Net Contribution to Calculated Emissions from Carbon Materials

Liquid

X-2 Help

Equation X-3 Calculation Spreadsheet.xls

Net Contribution to Calculated Emissions from Carbon Materials

Solid

X-3 Help

Equation X-4 Calculation Spreadsheet.xls

Annual CO2 Emissions

N/A

X-4 Help

...

Anchor
Selecting the Appropriate Calculation Spreadsheet
Selecting

...

the

...

Appropriate

...

Calculation

...

Spreadsheet

Subpart X requires a facility to report annual CO2 process emissions from each process unit used to produce petrochemicals. To calculate emissions from a process unit, users must first calculate the annual net contribution to calculated emissions from carbon in gaseous, liquid, and solid feedstocks and products using calculation spreadsheets for equations X-1, X-2, and X-3, respectively. Once completed, users should then copy the results from those spreadsheets into the Equation X-4 Calculation Spreadsheet. This sequence must be repeated for each process unit.

For each process unit with any gaseous feedstocks or products, users should calculate the annual net contribution to calculated emissions from the gaseous carbon materials using Equation X-1 and the Equation X-1 Calculation Spreadsheet. Equation X-1 is provided below:

(Equation X-1)

Image Modified

For each process unit with any liquid feedstocks or products, users should calculate the annual net contribution to calculated emissions from the liquid carbon materials using Equation X-2 and the Equation X-2 Calculation Spreadsheet. Equation X-2 is provided below:

(Equation X-2)

Image Modified

For each process unit with any solid feedstocks or products, users should calculate the annual net contribution to calculated emissions from the solid carbon materials using Equation X-3 and the Equation X-3 Calculation Spreadsheet. Equation X-3 is provided below:

(Equation X-3)

Image Modified

For each process unit, users should calculate the annual CO2 mass emissions from process operations and process off-gas combustion using Equation X-4 and the Equation X-4 Calculation Spreadsheet. Equation X-4 is provided below:

(Equation X-4)

Image Modified

...

Anchor
Downloading

...

a Calculation Spreadsheet
Downloading a

...

Calculation

...

Spreadsheet

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

Calculation Spreadsheet
(click to download)

Calculation
Result

Selection Criteria:
Feedstock/Product Type

Instructions
(click to view)

Equation X-1 Calculation Spreadsheet.xls

Net Contribution to Calculated Emissions from Carbon Materials

Gaseous

X-1 Help

Equation X-2 Calculation Spreadsheet.xls

Net Contribution to Calculated Emissions from Carbon Materials

Liquid

X-2 Help

Equation X-3 Calculation Spreadsheet.xls

Net Contribution to Calculated Emissions from Carbon Materials

Solid

X-3 Help

Equation X-4 Calculation Spreadsheet.xls

Annual CO2 Emissions

N/A

X-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 calculation spreadsheets for Subpart X. Additional guidance is provided for each individual calculation spreadsheet in the sections below.

...

Users with multiple process units should use separate calculation spreadsheets for each process unit. Users should not aggregate data for multiple process units when using these calculation spreadsheets.

...

Anchor
Using the Equation X-1 Calculation Spreadsheet
Using

...

the

...

Equation

...

X-1

...

Calculation

...

Spreadsheet

Calculate the annual net contribution to calculated emissions from carbon materials for each process unit with gaseous feedstocks and/or products using Equation X-1 and the Equation X-1 Calculation Spreadsheet. Space is provided for up to three gaseous feedstocks and three gaseous products in the spreadsheet. Use additional copies of this spreadsheet for additional materials and add the contributions prior to entering in the Equation X-4 Calculation Spreadsheet. Equation X-1 is provided below:

(Equation X-1)

Image Modified

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

...

The calculation spreadsheet will calculate the net contribution to calculated emissions from all carbon-containing gaseous feedstocks and products in a process unit. This calculated value will be displayed in the red-bordered cell with yellow fill at the bottom of the spreadsheet. This value should be entered in the Equation X-4 Calculation Spreadsheet for this process unit.

 

...

Anchor
Using the Equation X-2 Calculation Spreadsheet
Using

...

the

...

Equation

...

X-2

...

Calculation

...

Spreadsheet

Calculate the annual net contribution to calculated emissions from carbon materials for each process unit with liquid feedstocks and/or products using Equation X-2 and the Equation X-2 Calculation Spreadsheet. Space is provided for up to three liquid feedstocks and three liquid products in the spreadsheet. Use additional copies of this spreadsheet for additional materials and add the contributions prior to entering in the Equation X-4 Calculation Spreadsheet. Equation X-2 is provided below:

(Equation X-2)

Image Modified

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

...

The calculation spreadsheet will calculate the net contribution to calculated emissions from all carbon-containing liquid feedstocks and products in a process unit. This calculated value will be displayed in the red-bordered cell with yellow fill at the bottom of the spreadsheet. This value should be entered in the Equation X-4 Calculation Spreadsheet for this process unit.

 

...

Anchor
Using the Equation X-3 Calculation Spreadsheet
Using

...

the

...

Equation

...

X-3

...

Calculation

...

Spreadsheet

Calculate the annual net contribution to calculated emissions from carbon materials for each process unit with solid feedstocks and/or products using Equation X-3 and the Equation X-3 Calculation Spreadsheet. Space is provided for up to three solid feedstocks and three solid products in the spreadsheet. Use additional copies of this spreadsheet for additional materials and add the contributions prior to entering in the Equation X-4 Calculation Spreadsheet. Equation X-3 is provided below:

(Equation X-3)

Image Modified

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

...

The calculation spreadsheet will calculate the net contribution to calculated emissions from all carbon-containing solid feedstocks and products in a process unit. This calculated value will be displayed in the red-bordered cell with yellow fill at the bottom of the spreadsheet. This value should be entered in the Equation X-4 Calculation Spreadsheet for this process unit.

 

...

Anchor
Using the Equation X-4 Calculation Spreadsheet
Using

...

the

...

Equation

...

X-4

...

Calculation

...

Spreadsheet

Calculate the annual mass of CO2 process emissions using the results from the X-1, X-2, and X-3 calculation spreadsheets in Equation X-4, and the Equation X-4 Calculation Spreadsheet. Equation X-4 is provided below:

(Equation X-4)

Image Modified

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

...

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