Overview

This help page provides guidance for working with the supplemental Subpart HH calculation spreadsheets. The guidance provides step-by-step instructions for the following tasks:

...

1. First using Equation HH-5 and the Equation HH-5 Calculation Spreadsheet to determine CH₄ generation (adjusted for oxidation) and then using Equation HH-6 and the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet which subtracts the measured amount of CH₄ recovered from the modeled annual CH₄ generation (with adjustments for soil oxidation and destruction efficiency of the destruction device).
2. Using Equations HH-7 and HH-8 and the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet which applies a gas collection efficiency to the measured amount of CH₄ recovered and accounts for CH₄ that is emitted through the landfill surface (adjusted for soil oxidation). Default collection efficiencies that take into account collection system coverage and landfill cover materials are specified in Table HH-3 found in a separate tab within the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet. If a single measurement location is used to determine gas recovery for multiple destruction devices, the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet also provides equations for computing destruction efficiency and fraction of hours destruction devices were operating in the "MultiDD“MultiDD_per_MeasLocation" MeasLocation” tab.

Equation HH-5 is provided above. Equations HH-6, HH-7 and HH-8 are provided below.

...

The Equation HH-6, HH-7, HH-8 Calculation Spreadsheet also provides alternate equations to implement Equations HH-6, HH-7, and HH-8 when multiple gas recovery measurement locations are used (in tab "Equation “Equation HH-6,HH-7,HH-8_Multi"Multi”). These alternate forms of Equations HH-6, HH-7, and HH-8 are provided below.

...

...

Next, enter the requested information in the green input cells in the Input Data table. Based on your entries in the first Input Data table, required cells will be activated to green input cells in the second Input Data table.

{composition-setup}{composition-setup}

{toggle-cloak

:id

=PNG1}

{cloak:id=PNG1|cloak.toggle.type=none|cloak.toggle.zone=true}

{cloak}

The calculation spreadsheet will calculate the annual quantity of CH₄ recovered from the landfill. The calculated value will be displayed in a red-bordered cell with yellow fill at the bottom of the spreadsheet. This value should be entered in the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet for this landfill.

...

Calculate the annual CH₄ emissions from the modeled CH₄ generation and measured CH₄ recovery using Equation HH-6 and the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet for a landfill. This tab only applies to landfills with landfill gas collection systems with a single gas recovery measurement location. If multiple gas recovery measurement locations are used, see "Using “Using the Equation HH-6, HH-7, HH-8_Multi Tab in the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet." ” Equation HH-6 is provided below.

...

Next, enter the requested information in the green input cells in the Input Data table, including the result of Equation HH-1 as calculated using the Equation HH-1 Calculation Spreadsheet and the result of Equation HH-4 as calculated using the Equation HH-4 Calculation Spreadsheet. If gas recovery measurements are made at a single location for multiple destruction devices, use the "MultiDD“MultiDD_per_MeasLocation" MeasLocation” tab in the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet to determine appropriate values for the destruction efficiency DE and the fraction of hours the destruction device was operating fDest. See section below for further explanation on using the "MultiDD“MultiDD_per_MeasLocation" MeasLocation” tab.

The calculation spreadsheet will calculate the CH₄ emissions from the landfill in the reporting year. The calculated value will be displayed in a red-bordered cell with white fill at the bottom of the spreadsheet. This value should be entered into e-GGRT for this landfill.

...

Calculate CH₄ generation and CH(₎₄ emissions from a landfill using measured CH₄ recovery and estimated gas collection efficiency. These calculations employ Equations HH-7 and HH-8 and the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet. This tab only applies to landfills with landfill gas collection systems with a single gas recovery measurement location. If multiple gas recovery measurement locations are used, see "Using “Using the Equation HH-6, HH-7, HH-8_Multi Tab in the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet." ” Equations HH-7 and HH-8 are provided below.

...

Next, enter the requested information in the green input cells in the Input Data table, including the result of Equation HH-4 as calculated using the Equation HH-4 Calculation Spreadsheet. If gas recovery measurements are made at a single location for multiple destruction devices, use the "MultiDD“MultiDD_per_MeasLocation" MeasLocation” tab in the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet to determine appropriate values for the destruction efficiency DE and the fraction of hours the destruction device was operating f_Dest.

...