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:

• Downloading a Calculation Spreadsheet
• General Information on Using a Calculation Spreadsheet
• Using the Equation TT-1 Calculation Spreadsheet
• Using the Equation TT-2 Calculation Spreadsheet
• Using the Equations TT-3, TT-4a, and TT-4b Calculation Spreadsheet
• Using the Equation TT-5 Calculation Spreadsheet
• Using the Equation TT-6 Calculation Spreadsheet

 

Downloading a Calculation Spreadsheet 

Calculation spreadsheets for Subpart TT 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.

General Information on Using a Calculation Spreadsheet

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

This calculation spreadsheet will calculate the modeled CH₄ generation for each waste stream disposed of in the landfill and then sum the CH₄ generation rates for all waste streams disposed of in the landfill to get the total annual CH₄ generation rate of the landfill for the reporting year.

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. Note that if data are not available for the Methane Correction Factor (MCF) and the Fraction of Degradable Organic Carbon (DOC_F), enter their respective default values of 1 and 0.5.

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 TT-6 Calculation Spreadsheet for this landfill.

Using the Equation TT-2 Calculation Spreadsheet

For each waste stream disposed of in the landfill, the calculation spreadsheet will calculate the average waste disposal rate per unit of production or unit throughput using all available waste quantity data and corresponding production or processing rates for the process generating that waste or, if appropriate, the facility.

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.

Enter the first year in which disposal production/throughput data are available and the first year that GHG emissions from this industrial landfill must be reported. Then, input the necessary quantities in the green input cells for the corresponding years.

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 TT-3 Calculation Spreadsheet for this landfill.

Using the Equations TT-3, TT-4a, and TT-4b Calculation Spreadsheet

For each waste stream disposed of in the landfill, you must calculate the waste disposal quantities for historic years in which direct waste disposal measurements are not available using historical production data and Equation TT-3.

For any year in which historic production or processing data are not available (i.e., historic waste quantities cannot be estimated using Equation TT-3), calculate an average annual bulk waste disposal quantity using either Equation TT-4a when data are available consecutively for the most recent disposal years or Equation TT-4b of this section when data are available for sporadic (non-consecutive) years.

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 (TT-3, TT-4a, and TT-4b) in the green input cells of the general information table. This is for your records.

Using the Equation TT-3

For Equation TT-3, enter the average waste disposal factor from Equation TT-2, and then input the waste quantities corresponding to each year. Those quantities will be multiplied by the was disposal factor for use in Equation TT-1 for years when direct waste disposal measurements are not available.

Using the Equations TT-4a and TT-4b

For Equation TT-4a, enter the requested information in the green input cells. Note that this equation should only be used when when data are available consecutively for the most recent disposal years.

Use the final value in the red bordered box in Equation TT-1 for years when waste disposal quantities are not available from measurement data or from Equation TT-3.

For Equation TT-4b, enter the requested quantity information in the green input cells. Note that this equation should only be used when when data are available for sporadic (non-consecutive) disposal years.

Use the final value in the red bordered box in Equation TT-1 for years when waste disposal quantities are not available from measurement data or from Equation TT-3.

Using the Equation TT-5 Calculation Spreadsheet

For years for which bulk waste disposal quantities are determined, you must calculate the weighted average bulk DOC value according to the following: Calculate the average DOC value for each waste stream as the arithmetic average of all DOC measurements of that waste stream that follows the methods provided in 98.464(b) (generally, this will include only the DOC values determined in the first year in which GHG emissions from this industrial waste landfill must be reported), calculate the average annual disposal quantity for each waste stream as the arithmetic average of the annual disposal quantities for each year in which waste stream-specific disposal quantities have been determined, and calculate the bulk waste DOC value using Equation TT-5 of this section.

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 number of waste streams at the landfill in the green cell, and then input the average DOC and the average annual quantity of waste (for years in which waste stream-specific disposal quantities have been determined) for each corresponding waste stream.

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 TT-1 Calculation Spreadsheet for years when waste disposal quantities are not available from measurement data or from Equation TT-3.

Using the Equation TT-6 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).

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 TT-1 as calculated using the Equation TT-1 Calculation Spreadsheet.

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.