Description
Tool for estimating city-level annual emissions of methane, black carbon, and other pollutants including CO2 from various sources in the waste sector.
Questions this resource can help answer
- What are the first order emissions of methane, black carbon, and other pollutants from different components of waste management?
- What are the impacts of different scenarios for emissions reduction?
- What are the contributions of the waste sector to overall city emissions?
How do I use this resource?
Instructions are provided in each tab of the spreadsheet tool. Cells shaded blue require data to be entered by the user. Yellow cells are default values or assumptions. You have to work through all four blue tabs of the tool. When you have filled in all of the blue cells, the red cells on rows 45-47 of the "General Information" tab will turn green and will say "NO" for missing inputs. When you have completed the data entry, emissions results are in the black tabs to the far right.
Pro tips
You have to "Enable Macros" for the tool to function.
Resource information
Technical specifications
Uses state-of-the-industry assumptions and calculation methods. Methane emissions from disposal sites are estimated as the amount of methane generated, minus the amount either collected and destroyed in a combustion device or oxidized in cover soils. Methane emissions rates and oxidation rates are not measured in the field except at a few research sites, so actual methane generation, oxidation, and emissions are usually unknown and must be estimated. Specific information on the model estimation parameters are provided in a detailed user's manual.
Requires Microsoft Excel