Using Subpart Y Calculation Spreadsheets

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

Anchor
Top
Top

Excerpt Include
help:Spreadsheet Usage Warning
nopaneltrue
help:Spreadsheet Usage Warningnopaneltrue

Overview

This help page provides guidance for working with the supplemental Subpart Y calculation spreadsheets. 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 Y. Additional guidance is provided for each individual calculation spreadsheet in the sections below.

Include Page
help:Spreadsheet Color Codinghelp:
Spreadsheet Color Coding
Include Page
help:Spreadsheet Stop and Warning Messageshelp:
Spreadsheet Stop and Warning Messages

...

Next, enter the requested information in the green input cells in the first Input Data table. Based on your entries in the first Input Data table, a number of green input cells will be activated in the second Input data table. Enter the requested information in the green input cells in the second Input Data table. Space is provided for up to 20 carbon-containing compounds in the fuel stream.

Wiki Markup
{composition-setup}{composition-setup}

Wiki Markup
{toggle-cloak
:id
=PNG1}
Click image to expand

true
Wiki Markup
Cloak
{cloak:id=PNG1|cloak.toggle.type=none|cloak.toggle.zone=true}
Panel

Image Added

none
Wiki Markup
{cloak}
idPNG1
cloak.toggle.type

The calculation spreadsheet will calculate the annual CO2 emissions for a fuel stream combusted in a flare. The calculated value will be displayed in the red-bordered cell at the bottom of the spreadsheet. This value should be entered in e-GGRT and the Equation Y-4, Y-5 Calculation Spreadsheet for this flare. If different fuel types are separately monitored, add together the CO2 emissions calculated for each fuel type for a given flare and use the resulting sum for entry in e-GGRT and the Equation Y-4, Y-5 Calculation Spreadsheet for this flare.

...

Next, enter the requested information in the green input cells in the first Input Data table. Based on your entries in the first Input Data table, a number of green input cells will be activated in the second Input data table. Enter the requested information in the green input cells in the second Input Data table.

Wiki Markup
{toggle-cloak
:id
=PNG2}
Click image to expand

true
Wiki Markup
{cloak:id=PNG2|cloak.toggle.type=none|
Cloak
cloak.toggle.zone=true}
Panel

Image Added

none
Wiki Markup
{cloak}
idPNG2
cloak.toggle.type

The calculation spreadsheet will calculate the annual CO2, CH4, and N2O emissions from for a process vent. The calculated values will be displayed in the red-bordered cells at the bottom of the spreadsheet. These values should be entered in e-GGRT for this process vent (or for this process unit for units electing to use the process vent method).

...

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