Using Subpart P 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 Spreadsheets
(click to download)

Selection Criteria: Feedstock Type

Instructions
(click to view)

Equation P-1 Calculation Spreadsheet.xls

Gaseous

P-1 Help

Equation P-2 Calculation Spreadsheet.xls

Liquid

P-2 Help

Equation P-3 Calculation Spreadsheet.xls

Solid

P-3 Help

...

Anchor
Selecting the Appropriate Calculation Spreadsheet
Selecting

...

the

...

Appropriate

...

Calculation

...

Spreadsheet

Subpart P requires a facility to report annual CO2 emissions from each hydrogen production process unit. To calculate the annual CO2 emissions from each hydrogen production process unit, users must use one or more of three equations based on the unit feedstock consumed during the data collection year. Users may use different calculation worksheets for different process units as required by the feedstock type for each unit. Users may use more than one calculation worksheet for a process unit if the unit has more than one type of feedstock.

...

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:

 (Equation P-3)

 

...

Anchor
Downloading a Calculation Spreadsheet
Downloading

...

a

...

Calculation

...

Spreadsheet

Calculation spreadsheets for Subpart P 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 Spreadsheets
(click to download)

Selection Criteria: Feedstock Type

Instructions
(click to view)

Equation P-1 Calculation Spreadsheet.xls

Gaseous

P-1 Help

Equation P-2 Calculation Spreadsheet.xls

Liquid

P-2 Help

Equation P-3 Calculation Spreadsheet.xls

Solid

P-3 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 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

...

Anchor
Using a Spreadsheet to Make Calculations
Using a Spreadsheet to Make Calculations

...

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 P-1 Calculation Spreadsheet
Using

...

the

...

P-1

...

Calculation

...

Spreadsheet

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 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 Modified

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.

...

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.

...

Anchor
Using

...

the P-2 Calculation Spreadsheet
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 or feedstock used in each hydrogen production process unit. Calculations for process units with gaseous 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.

(Equation P-2)

Image Modified

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.

...

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.

 

...

Anchor
Using the P-3 Calculation Spreadsheet
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 or feedstock used in each hydrogen production process unit. Calculations for process units with gaseous 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.

(Equation P-3)

Image Modified

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.

...

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