Using Subpart P 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 P calculation spreadsheets. The guidance provides step-by-step instructions for the following tasks:

...

For each process unit with a gaseous feedstock, users should calculate annual CO2 emissions using Equation P-1 via the Equation P-1 Calculation Worksheet. Equation P-1 is provided below:

Image Added (Equation P-1)

...

For each process unit with a liquid feedstock, users should calculate annual CO2 emissions using Equation P-2 via the Equation P-2 Calculation Worksheet. Equation P-2 is provided below:

Image Added (Equation P-2)

...

Image Removed

For each process unit with a solid feedstock, users should calculate annual CO2 emissions using Equation P-3 via the Equation P-3 Calculation Worksheet. Equation P-3 is provided below:

Image Added (Equation P-3)

...

 

h3.anchor
Downloading a Calculation Spreadsheet

...

The guidance provided in this section applies to each of the calculation spreadsheets for Subpart P. 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

h4.anchor
Multiple process units

...

Use the P-1 Calculation Worksheet to calculate the annual CO2 emissions from each hydrogen production process unit with a gaseous feedstock. A separate worksheet is to be used for each fuel and feedstock used in each hydrogen production process unit. Calculations for hydrogen production process units with liquid and or solid feedstocks should be performed using different calculation worksheets and different equations. The P-1 Calculation Worksheet performs the calculation using Equation P-1, provided below.

(Equation P-1)

Image Removed Image Added

Begin by entering the facility name, your name, the process 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 equation in the calculation spreadsheet. This is for your records.

...

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

Image RemovedImage Added

The calculation worksheet will calculate the annual CO2 emissions from a unit with a gaseous feedstock. This calculated value will be displayed in the red-bordered cell in the Annual CO2 Emissions (metric tons) from Equation P-1 table at the bottom of the worksheet. This value should be entered in e-GGRT for this process unit.

Image RemovedImage Added

h3.anchor
Using the P-2 Calculation Spreadsheet

Use the P-2 Calculation Worksheet to calculate the annual CO2 emissions from each hydrogen production process unit with a liquid feedstock. A separate worksheet is to be used for each fuel and or feedstock used in each hydrogen production process unit. Calculations for process units with gaseous and or solid feedstocks should be performed using different calculation worksheets and different equations. The P-2 Calculation Worksheet performs the calculation using Equation P-2, provided below.

...

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

Image RemovedImage Added

The calculation worksheet will calculate the annual CO2 emissions from a unit with a liquid feedstock. This calculated value will be displayed in the red-bordered cell in the Annual CO2 Emissions (metric tons) from Equation P-2 table at the bottom of the worksheet. This value should be entered in e-GGRT for this process unit.

Image Added

Image Removed 

h3.anchor
Using the P-3 Calculation Spreadsheet

Use the P-3 Calculation Worksheet to calculate the annual CO2 emissions from each hydrogen production process unit with a solid feedstock. A separate worksheet is to be used for each fuel and or feedstock used in each hydrogen production process unit. Calculations for process units with gaseous and or liquid feedstocks should be performed using different calculation worksheets and different equations. The P-3 Calculation Worksheet performs the calculation using Equation P-3, provided below.

...

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

Image RemovedImage Added

The calculation worksheet will calculate the annual CO2 emissions from a unit with a solid feedstock. This calculated value will be displayed in the red-bordered cell in the Annual CO2 Emissions (metric tons) from Equation P-3 table at the bottom of the worksheet. This value should be entered in e-GGRT for this process unit.

Image RemovedImage Added

Gather the data from all spreadsheets used for this unit to total the CO2 emissions from the unit during the reporting year. The final step is to enter this total quantity of annual CO2 emissions for this unit in the red box on the corresponding hydrogen production process unit page of e-GGRT

Back to Top

 

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