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:

• #Selecting the Appropriate Calculation Spreadsheet
• #Downloading a Calculation Spreadsheet
• #General Information on Using a Calculation Spreadsheet
• Using the Equation HH-1 Calculation Spreadsheet
• Using the Equation HH-2, HH-3 Calculation Spreadsheet
• Using the Equation HH-4 Calculation Spreadsheet
• Using the Equation HH-5 Calculation Spreadsheet
• Using the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet

Specific information on each of the calculation spreadsheets is provided below:

Selecting the Appropriate Calculation Spreadsheet

For all landfills subject to the reporting requirements of Subpart HH, calculate annual modeled CH₄ generation using the Equation HH-1 Calculation Spreadsheet and according to the requirements in 98.343(a)(1) through 98.343(a)(3). Equation HH-1 is provided below.

Per 98.343(a)(3), beginning in the first emissions reporting year, and each year thereafter, waste quantities must be determined using scales or the working capacity for each vehicle/container, for loads other than cars, light-duty trucks, and loads that cannot be measured with scales due to physical or operational limitations. If scales are in place at the landfill, they must be used to determine waste quantities for the first emissions reporting year and each year thereafter. Scales and/or working capacity may also have been used for any previous years for which waste disposal quantities were measured. Tipping receipts and company records may also be used to determine waste disposal quantities prior to 2010. For the range of years prior to 2010, for which measurement data, tipping receipts or company records are not available, estimate historical annual waste disposal quantities using one of the following methods:

1. Assume all prior year's waste disposal quantities are the same as the waste quantity in the first year for which waste quantities were measured and data are available.
2. Use Equation HH-2 and the Equation HH-2, HH-3 Calculation Spreadsheet which is based on the estimated population served by the landfill in each year and the values for average per capita waste disposal rate.
3. Use Equation HH-3 and the Equation HH-2, HH-3 Calculation Spreadsheet which is based on the landfill capacity or, for operating landfills, the amount of waste-in-place, and the number of years waste was received to estimate a constant average waste disposal quantity.

Equations HH-2 and HH-3 are provided below.

For landfills that do not collect and destroy landfill gas, adjust the modeled annual CH₄ generation (result of Equation HH-1) to account for soil oxidation (CH₄ that is converted to CO₂ as it passes through the landfill cover before being emitted) using the Equation HH-5 Calculation Spreadsheet. The resulting value represents both CH₄ generation (adjusted for oxidation) and CH₄ emissions for landfills that do not collect and destroy landfill gas. For landfills that do collect and control landfill gas, the result of Equation HH-5 and the Equation HH-5 Calculation Spreadsheet represents only CH₄ generation (adjusted for oxidation). Equation HH-5 is provided below.

For landfills that collect and control landfill gas, calculate the annual quantity of CH₄ recovered and destroyed using Equation HH-4 and the Equation HH-4 Calculation Spreadsheet which is based on continuous monitoring of gas flow rate and continuous or weekly monitoring of CH₄ concentration, temperature, pressure, and moisture content of the collected gas prior to the destruction device. Equation HH-4 is provided below.

Facilities that collect and control landfill gas must then calculate CH₄ generation (adjusted for oxidation) and CH₄ emissions in two ways each and report all four results. CH₄ generation (adjusted for oxidation) and CH₄ emissions should be calculated by:

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_per_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 HH-6,HH-7,HH-8_Multi"). These alternate forms of Equations HH-6, HH-7, and HH-8 are provided below.

Downloading a Calculation Spreadsheet

Calculation spreadsheets for Subpart HH 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 fourth column.

Using a Calculation Spreadsheet to Make Calculations

The guidance provided in this section applies to each of the calculation spreadsheets for Subpart HH. Additional guidance is provided for each individual calculation spreadsheet in the sections below.

Color Coding

The calculation spreadsheets contain green input cells, gray informational cells and red-bordered results cells. Users should use green input cells to enter all data specific to their facility, unit, or process. As you progress through a reporting form, you may notice some green input cells changing to black deactivated cells. Black deactivated cells are not applicable to the user based on previous data entries in the form. Users should not enter data into these cells. Gray informational cells contain parameter names, column and row headings, equation constants and subtotals. Calculation results are displayed in red-bordered results cells. Values displayed in red-bordered cells with yellow fill should be entered into another cell within the same calculation spreadsheet or in another calculation spreadsheet as directed by spreadsheet instructions. Values displayed in red-bordered cells with white fill should be entered directly into e-GGRT. All cells that are not green input cells are locked and cannot be modified.

Using the Equation HH-1 Calculation Spreadsheet

Calculate the annual modeled CH₄ generation using Equation HH-1 and the Equation HH-1 Calculation Spreadsheet for a landfill. Use the appropriate parameter values for k, DOC, MCF, DOC_F, and F shown in Table HH-1 within the calculation spreadsheet. For years when waste composition data are not available, use either the bulk waste or the modified bulk MSW parameter values for k and DOC in Table HH-1 for the total quantity of waste disposed in those years.

If, prior to 2010, the quantity of waste disposed each year (W_x) is estimated using Equation HH-2 or HH-3, use the Equation HH-2, HH-3 Calculation Spreadsheet first and enter the resulting Wx values in the appropriate column in the Equation HH-1 Calculation Spreadsheet.

Equation HH-1 is provided below:

Begin by entering the facility name, your name, the 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.

The calculation spreadsheet will calculate the modeled CH₄ generation from the landfill in the reporting year. 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-5 Calculation Spreadsheet for this landfill.

Using the Equation HH-2, HH-3 Calculation Spreadsheet

Estimate historical annual waste disposal quantities for the range of years prior to 2010 in which measurement data was not available using proxy year measurement data or the Equation HH-2, HH-3 Calculation Spreadsheet. This spreadsheet is only needed when following the methodologies in 98.343(a)(4)(ii) or 98.343(a)(4)(iii). This spreadsheet performs the calculation using Equation HH-2 or Equation HH-3, which are provided below. Equation HH-2 is based on the estimated population served by the landfill in each year and the values for average per capita waste disposal rate and should be used when applying the methodology described in 98.343(a)(4)(ii); Equation HH-3 is based on the landfill capacity or, for operating landfills, the amount of waste-in-place to estimate a constant average waste disposal quantity and should be used when applying the methodology described in 98.343(a)(4)(iii). The result from either equation is entered into the Equation HH-1 Calculation Spreadsheet for this landfill.

Begin by entering the facility name, your name, the unit name or identifier, the reporting period, any additional comments, and the equation you wish to use (HH-2 or HH-3) 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 Annual Calculated W_x table for either Equation HH-2 or HH-3, but not both.

The calculation spreadsheet will calculate the quantity of waste placed in the landfill in year x using either Equation HH-2 or HH-3.

If Equation HH-2 was used, the calculated values will be displayed in red-bordered cells with yellow fill in the fourth column of the Annual Calculated Wx Using Equation HH-2 table. These values should be entered in the Equation HH-1 Calculation Spreadsheet for this landfill (see above).

If Equation HH-3 was used, the calculated value will be displayed in a red-bordered cell with yellow fill in the fourth column of the Annual Calculated Wx Using Equation HH-3 table. This value should be entered in the Equation HH-1 Calculation Spreadsheet for this landfill (see above).

Using the Equation HH-4 Calculation Spreadsheet

For landfills that collect and control landfill gas, calculate the annual quantity of CH₄ recovered and destroyed using Equation HH-4 and the Equation HH-4 Calculation Spreadsheet. If you do not continuously monitor according to paragraph 98.343(b)(1), you must determine the volumetric flow rate, CH₄ concentration, temperature, pressure, and moisture content of the landfill gas that is collected and routed to a destruction device (before any treatment equipment) according to the requirements in paragraphs 98.343(b)(2)(i) through 98.343(b)(2)(iii). Equation HH-4 is provided below.

Begin by entering the facility name, your name, the 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. 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.

Click image to expand

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.

Using the Equation HH-5 Calculation Spreadsheet

Calculate the annual CH₄ generation (adjusted for oxidation) using Equation HH-5 and the Equation HH-5 Calculation Spreadsheet for a landfill. For landfills that do not have landfill gas collection systems, the annual CH₄ emissions are equal to the CH₄ generation (MG) calculated using Equation HH-5 (calculate CH₄ emissions using the Equation HH-6 Calculation Spreadsheet for landfills with landfill gas collection systems). Equation HH-5 is provided below.

Begin by entering the facility name, your name, the 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, including the result of Equation HH-1 as calculated using the Equation HH-1 Calculation Spreadsheet.

The calculation spreadsheet will calculate the CH₄ generation (adjusted for oxidation) from the landfill in the reporting year. For landfills that do not have landfill gas collection systems, the annual CH₄ emissions are equal to the annual CH₄ generation (adjusted for oxidation). 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.

NOTE: Facilities that collect and control landfill gas must calculate CH₄ generation (adjusted for oxidation) and CH₄ emissions in two ways each and report all four results. Calculate CH₄ generation (adjusted for oxidation) using both Equation HH-5 (above) and Equation HH-7 (below). Calculate CH₄ emissions using both Equation HH-6 and Equation HH-8 (both are below). Calculation spreadsheets are provided for each of these equations. Enter all resulting values into e-GGRT.

Using the Equation HH-6 Tab in the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet

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

Begin by entering the facility name, your name, the 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, 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_per_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_per_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.

Using the Equation HH-7, HH-8 Tab in the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet

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

Begin by entering the facility name, your name, the 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.

Then, enter the requested information in the green input cells in the Input Data for Calculating Weighted Average for CE table to estimate the collection efficiency at the landfill, taking into account system coverage, operation, and cover system materials from Table HH-3. Table HH-3 may be found in a separate tab within the Equation HH-7, HH-8 Calculation Spreadsheet. The calculated area-weighted collection efficiency will be displayed in a red-bordered cell with yellow fill below the table. This value should be entered into the Input Data table below. If area by soil cover type information is not available, use a default value of 0.75 for all areas under active influence of the collection system.

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_per_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.

The calculation spreadsheet will calculate the CH₄ generation and CH₄ emissions from this landfill in the reporting year. The calculated values will be displayed in red-bordered cells with white fill at the bottom of the spreadsheet. These values should be entered into e-GGRT for this landfill.

Using the Equation HH-6, HH-7, HH-8 Multi Tab in the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet

The Equation HH-6, HH-7, HH-8_Multi tab in the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet provides the appropriate application of Equations HH-6, HH-7, and HH-8 when multiple gas recovery measurement locations are used at a single MSW landfill facility. Equations HH-6, HH-7 and HH-8 suitable for facilities with multiple landfill gas recovery measurement locations are provided below.

Begin by entering the facility name, your name, the 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.

Then, 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, the result of Equation HH-4 as calculated using the Equation HH-4 Calculation Spreadsheet for each of the different gas recovery measurement locations, and the result of the collection efficiency at the landfill taking into account system coverage, operation, and cover system materials from Table HH-3 using the Equation HH-7, HH-8 tab of the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet.

The calculation spreadsheet will calculate the CH(₎₄ generation and CH(₎₄ emissions from this landfill in the reporting year. The calculated values will be displayed in red-bordered cells with white fill at the bottom of the spreadsheet. These values should be entered into e-GGRT for this landfill.

Using the MultiDD_per_MeasLocation Tab in the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet

The MultiDD_per_MeasLocation tab in the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet provides the appropriate calculation of destruction efficiency DE and fraction of hours the destruction device was operating fDest for when a single gas recovery measurement location is used but the gas is destroyed via multiple destruction devices.

Begin by entering the facility name, your name, the 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.

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

The calculation spreadsheet will calculate the destruction efficiency DE and the fraction of hours the destruction devices were operating fDest. The calculated values will be displayed in red-bordered cells with white fill at the bottom of the spreadsheet. These values should be entered into the appropriate input data tables for Equations HH-6, HH-7, and HH-8 in the Equation HH-6, HH-7, HH-8 Calculation Spreadsheet.

Back to Top