Using Subpart X 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 X calculation spreadsheets. The spreadsheets calculate the CO2 process emissions in accordance with Equations X-1 through X-4 in subpart X. A facility must use these equations to calculate emissions when complying with the mass balance option in subpart X. As stated in §98.242, process emissions for the mass balance option are the total CO2 generated in the process itself plus the CO2 generated by combustion of off-gas from the process. The guidance provides step-by-step instructions for the following tasks:

...

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.

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

Multiple Process Units

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.

...

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

Image Added

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

Image RemovedImage Added

Then, enter the requested information in the green input cells in the Input Data for Products table.

Image RemovedImage Added

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.

Image Added

Image Removed 

h3.anchor
Using the Equation X-2 Calculation Spreadsheet

...

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

Image RemovedImage Added

Then, enter the requested information in the green input cells in the Input Data for Products table.

Image RemovedImage Added

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.

Image Added

 Image Removed

h3.anchor
Using the Equation X-3 Calculation Spreadsheet

...

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

Image RemovedImage Added

Then, enter the requested information in the green input cells in the Input Data for Products table.

Image RemovedImage Added

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.

Image Added

 Image Removed

h3.anchor
Using the Equation X-4 Calculation Spreadsheet

...

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

Image RemovedImage Added

The calculation spreadsheet will calculate the annual CO2 process emissions in metric tons per year for a process unit. This calculated value will be displayed in the red-bordered cell with white fill at the bottom of the spreadsheet. This value should be entered in e-GGRT for this process unit.

Image RemovedImage Added

Back to Top

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