Please enter the fraction of the waste by weight which is degradable organic carbonPlease enter a number between 0 and 1Please enter the fraction of the DOC which will dissimilate in the SWDSPlease enter a number between 0 and 1Please enter a number between 0 and 10000Please enter a whole number of months between 0 and 24Please enter a number between 0 and 1Enter a fraction between 0 and 1Please enter a number between 0 and 1. Guidance can be found in the 2006 IPCC Guidelines.Please enter the percentage of waste going to this site type in this yearPlease enter a number between 0% and 100%Please enter a number between 1% and 100%Please enter a year between 1900 and 20002006 IPCC Guidelines for National Greenhouse Gas InventoriesThis spreadsheet implements the Tier 1 method for estimating emissions of methane from solid waste disposal sites. For details of the method see the 2006 IPCC Guidelines for National Greenhouse Gas Inventories Volume 5 Chapter 3IPCC 2006

ParametersCountryRegionPlease enter parameters in the yellow cells. If no national data are available, copy the IPCC default value.Help on parameter selection can be found in the 2006 IPCC guidelinesIPCC default valueCountry-specific parametersValueReference and remarksNotesStarting year19501950Specified Inputs: expanded for spreadsheet calculationsDOC (Degradable organic carbon)(weight fraction, wet basis)RangeDefaultSelected DOC inputsFood waste0.08-0.200,150,15May include garden waste provided that a suitable value of DOC is usedThis may include garden waste provided that a suitable value of DOC is used

Food waste0,15Garden0.18-0.220,20,2Garden (yard) and park waste and other moderately fast degrading wasteGarden and park waste and other moderately fast degrading waste

Garden0,2Paper0.36-0.450,40,4Paper0,4Wood and straw0.39-0.460,430,43Wood and straw0,43Textiles0.20-0.400,240,24Natural textiles such as wool and cotton. The default DOC value assumes 40% of textiles are synthetic materials that do not contain DOCNatural textiles such as wool and cotton. The default DOC value assumes 40% of textiles are synthetic materials that do not contain DOC.

Textiles0,24Disposable nappies0.18-0.320,240,24Disposable nappies0,24Sewage sludge0.04-0.050,050,05Sewage sludge0,050Bulk MSW0Industrial waste0-0.540,150,15The composition of industrial waste will vary significantly by country. This DOC value should match the amounts entered (see Guidelines).The composition of industrial waste will vary significantly by country. This DOC value should match the amounts entered (see guidelines).

Industrial waste0,15DOCf (fraction of DOC dissimilated)0,50,5Methane generation rate constant (k)(years-1)RangeDefaultSelected half-life inputsFood waste0.10.20,1850,185May include garden waste provided that a suitable value of DOC is usedThis may include garden waste provided that a suitable value of DOC is used

Food waste0,185Garden0.060.10,10,1Garden (yard) and park waste and other moderately fast degrading wasteGarden and park waste and other moderately fast degrading waste

Garden0,1Paper0.050.070,060,06Paper0,06Wood and straw0.020.040,030,03Wood and straw0,03Textiles0.050.070,060,06Natural textiles such as wool and cotton. Synthetic textiles are assumed not to contain DOCNatural textiles such as wool and cotton. Synthetic textiles are assumed not to contain DOC

Textiles0,06Disposable nappies0.060.10,10,1Disposable nappies0,1Sewage sludge0.10.20,1850,185Sewage sludge0,1850Bulk MSW0,09Industrial waste0.080.10,090,09The composition of industrial waste will vary significantly by country. This DOC value should match the amounts entered (see Guidelines).The composition of industrial waste will vary significantly by country. This DOC value should match the amounts entered (see guidelines).

Industrial waste0,09This is the average time before anaerobic decay begins - usually assumed to be a few months

Delay time (months)66Fraction of methane (F) in developed gas0,50,5Conversion factor, C to CH41,331,33Oxidation factor (OX)00Parameters for carbon storage% paper in industrial waste0%0%% wood in industrial waste0%0%For Harwested Wood Products calculations for Bulk waste option only:

Methane Correction Factor (MCF)Calculated values for MCFThis worksheet calculates a weighted average MCF from the estimated distribution of site typesEnter either IPCC default values or national values into the yellow MCF cells in row 12Then enter the approximate distribution of waste disposals (by mass) between site types in the columns below.Totals on each row must add up to 100% (see "distribution check" values)MSWIndustrialMSWIndustrialUn-managed, shallowUn-managed, deepManagedManaged, semi-aerobicUncate-gorisedDistri-bution CheckUn-managed, shallowUn-managed, deepManagedManaged, semi-aerobicUncate-gorisedDistri-bution CheckReferences / remarksWeighted average MCF for MSWWeighted average MCF for Industrial WasteMCFMCFMCFMCFIPCC default0,40,810,50,60,40,810,50,6Country-specific value0,40,810,50,60,40,810,50,6Distribution of Waste by Waste Management TypeDistribution of Waste by Waste Management Type"Fixed" Country-specifc value% of waste to site type: Enter value for % by waste to site type here (as a start) to quickly fill-in a fixed % by site type for all years.

25%% of waste to site type: Enter value for % by waste to site type here (as a start) to quickly fill-in a fixed % by site type for all years.

30%% of waste to site type: Enter value for % by waste to site type here (as a start) to quickly fill-in a fixed % by site type for all years.

25%5%% of waste to site type: Enter value for % by waste to site type here (as a start) to quickly fill-in a fixed % by site type for all years.

15%Total (100%)% of waste to site type: Enter value for % by waste to site type here (as a start) to quickly fill-in a fixed % by site type for all years.

20%% of waste to site type: Enter value for % by waste to site type here (as a start) to quickly fill-in a fixed % by site type for all years.

30%% of waste to site type: Enter value for % by waste to site type here (as a start) to quickly fill-in a fixed % by site type for all years.

25%5%% of waste to site type: Enter value for % by waste to site type here (as a start) to quickly fill-in a fixed % by site type for all years.

20%Total (100%)Year%%%%wt. fractionwt. fraction195025%30%25%5%15%100%20%30%25%5%20%100%0,710,72195125%30%25%5%15%100%20%30%25%5%20%100%0,710,72195225%30%25%5%15%100%20%30%25%5%20%100%0,710,72195325%30%25%5%15%100%20%30%25%5%20%100%0,710,72195425%30%25%5%15%100%20%30%25%5%20%100%0,710,72195525%30%25%5%15%100%20%30%25%5%20%100%0,710,72195625%30%25%5%15%100%20%30%25%5%20%100%0,710,72195725%30%25%5%15%100%20%30%25%5%20%100%0,710,72195825%30%25%5%15%100%20%30%25%5%20%100%0,710,72195925%30%25%5%15%100%20%30%25%5%20%100%0,710,72196025%30%25%5%15%100%20%30%25%5%20%100%0,710,72196125%30%25%5%15%100%20%30%25%5%20%100%0,710,72196225%30%25%5%15%100%20%30%25%5%20%100%0,710,72196325%30%25%5%15%100%20%30%25%5%20%100%0,710,72196425%30%25%5%15%100%20%30%25%5%20%100%0,710,72196525%30%25%5%15%100%20%30%25%5%20%100%0,710,72196625%30%25%5%15%100%20%30%25%5%20%100%0,710,72196725%30%25%5%15%100%20%30%25%5%20%100%0,710,72196825%30%25%5%15%100%20%30%25%5%20%100%0,710,72196925%30%25%5%15%100%20%30%25%5%20%100%0,710,72197025%30%25%5%15%100%20%30%25%5%20%100%0,710,72197125%30%25%5%15%100%20%30%25%5%20%100%0,710,72197225%30%25%5%15%100%20%30%25%5%20%100%0,710,72197325%30%25%5%15%100%20%30%25%5%20%100%0,710,72197425%30%25%5%15%100%20%30%25%5%20%100%0,710,72197525%30%25%5%15%100%20%30%25%5%20%100%0,710,72197625%30%25%5%15%100%20%30%25%5%20%100%0,710,72197725%30%25%5%15%100%20%30%25%5%20%100%0,710,72197825%30%25%5%15%100%20%30%25%5%20%100%0,710,72197925%30%25%5%15%100%20%30%25%5%20%100%0,710,72198025%30%25%5%15%100%20%30%25%5%20%100%0,710,72198125%30%25%5%15%100%20%30%25%5%20%100%0,710,72198225%30%25%5%15%100%20%30%25%5%20%100%0,710,72198325%30%25%5%15%100%20%30%25%5%20%100%0,710,72198425%30%25%5%15%100%20%30%25%5%20%100%0,710,72198525%30%25%5%15%100%20%30%25%5%20%100%0,710,72198625%30%25%5%15%100%20%30%25%5%20%100%0,710,72198725%30%25%5%15%100%20%30%25%5%20%100%0,710,72198825%30%25%5%15%100%20%30%25%5%20%100%0,710,72198925%30%25%5%15%100%20%30%25%5%20%100%0,710,72199025%30%25%5%15%100%20%30%25%5%20%100%0,710,72199125%30%25%5%15%100%20%30%25%5%20%100%0,710,72199225%30%25%5%15%100%20%30%25%5%20%100%0,710,72199325%30%25%5%15%100%20%30%25%5%20%100%0,710,72199425%30%25%5%15%100%20%30%25%5%20%100%0,710,72199525%30%25%5%15%100%20%30%25%5%20%100%0,710,72199625%30%25%5%15%100%20%30%25%5%20%100%0,710,72199725%30%25%5%15%100%20%30%25%5%20%100%0,710,72199825%30%25%5%15%100%20%30%25%5%20%100%0,710,72199925%30%25%5%15%100%20%30%25%5%20%100%0,710,72200025%30%25%5%15%100%20%30%25%5%20%100%0,710,72200125%30%25%5%15%100%20%30%25%5%20%100%0,710,72200225%30%25%5%15%100%20%30%25%5%20%100%0,710,72200325%30%25%5%15%100%20%30%25%5%20%100%0,710,72200425%30%25%5%15%100%20%30%25%5%20%100%0,710,72200525%30%25%5%15%100%20%30%25%5%20%100%0,710,72200625%30%25%5%15%100%20%30%25%5%20%100%0,710,72200725%30%25%5%15%100%20%30%25%5%20%100%0,710,72200825%30%25%5%15%100%20%30%25%5%20%100%0,710,72200925%30%25%5%15%100%20%30%25%5%20%100%0,710,72201025%30%25%5%15%100%20%30%25%5%20%100%0,710,72201125%30%25%5%15%100%20%30%25%5%20%100%0,710,72201225%30%25%5%15%100%20%30%25%5%20%100%0,710,72201325%30%25%5%15%100%20%30%25%5%20%100%0,710,72201425%30%25%5%15%100%20%30%25%5%20%100%0,710,72201525%30%25%5%15%100%20%30%25%5%20%100%0,710,72201625%30%25%5%15%100%20%30%25%5%20%100%0,710,72201725%30%25%5%15%100%20%30%25%5%20%100%0,710,72201825%30%25%5%15%100%20%30%25%5%20%100%0,710,72201925%30%25%5%15%100%20%30%25%5%20%100%0,710,72202025%30%25%5%15%100%20%30%25%5%20%100%0,710,72202125%30%25%5%15%100%20%30%25%5%20%100%0,710,72202225%30%25%5%15%100%20%30%25%5%20%100%0,710,72202325%30%25%5%15%100%20%30%25%5%20%100%0,710,72202425%30%25%5%15%100%20%30%25%5%20%100%0,710,72202525%30%25%5%15%100%20%30%25%5%20%100%0,710,72202625%30%25%5%15%100%20%30%25%5%20%100%0,710,72202725%30%25%5%15%100%20%30%25%5%20%100%0,710,72202825%30%25%5%15%100%20%30%25%5%20%100%0,710,72202925%30%25%5%15%100%20%30%25%5%20%100%0,710,72203025%30%25%5%15%100%20%30%25%5%20%100%0,710,72

MSW activity data Industrial waste activity data Enter population, waste per capita and MSW waste composition into the yellow cells. Enter GDP, waste generation rate, % to SWDS and distribution of waste between site types into the yellow cells. Help and default regional values are given in the 2006 IPCC Guidelines.Help and default regional values are given in the 2006 IPCC Guidelines.Industrial waste activity data must be entered separately starting in Column Q.IPCC Regional defaults56047%24%0%28%11%0%0%37%100%This should be the composition of the waste entering the disposal sites, after any removal of material for recycling etc.Other categories, e.g. street sweepings, should be re-categorised into the columns below (see guidance).

Composition of waste going to solid waste disposal sitesYearEnter the population for which waste collection is organised (could be urban population)

PopulationWaste per capitaTotal MSWEnter the percentage of waste generated which goes to solid waste disposal sites

% to SWDSFoodGardenPaperWoodTextileNappiesInert waste, i.e. not containing degradable organic carbon, e.g. glass, metal etc. (DOC=0)

Plastics, other inertTotalYearGDPWaste generation rateTotal industrial wasteEnter the percentage of waste generated which goes to solid waste disposal sites

% to SWDSTotal to SWDSmillionskg/cap/yr1 gigagram (Gg) is 1000 tonnes

Gg%%%%(=100%)$ millionsGg/$m GDP/yr1 gigagram (Gg) is 1000 tonnes

Gg%Gg195010560560047%24%0%28%11%0%0%37%100%19501005500100%500195110560560047%24%0%28%11%0%0%37%100%19511005500100%500195210560560047%24%0%28%11%0%0%37%100%19521005500100%500195310560560047%24%0%28%11%0%0%37%100%19531005500100%500195410560560047%24%0%28%11%0%0%37%100%19541005500100%500195510560560047%24%0%28%11%0%0%37%100%19551005500100%500195610560560047%24%0%28%11%0%0%37%100%19561005500100%500195710560560047%24%0%28%11%0%0%37%100%19571005500100%500195810560560047%24%0%28%11%0%0%37%100%19581005500100%500195910560560047%24%0%28%11%0%0%37%100%19591005500100%500196010560560047%24%0%28%11%0%0%37%100%19601005500100%500196110560560047%24%0%28%11%0%0%37%100%19611005500100%500196210560560047%24%0%28%11%0%0%37%100%19621005500100%500196310560560047%24%0%28%11%0%0%37%100%19631005500100%500196410560560047%24%0%28%11%0%0%37%100%19641005500100%500196510560560047%24%0%28%11%0%0%37%100%19651005500100%500196610560560047%24%0%28%11%0%0%37%100%19661005500100%500196710560560047%24%0%28%11%0%0%37%100%19671005500100%500196810560560047%24%0%28%11%0%0%37%100%19681005500100%500196910560560047%24%0%28%11%0%0%37%100%19691005500100%500197010560560047%24%0%28%11%0%0%37%100%19701005500100%500197110560560047%24%0%28%11%0%0%37%100%19711005500100%500197210560560047%24%0%28%11%0%0%37%100%19721005500100%500197310560560047%24%0%28%11%0%0%37%100%19731005500100%500197410560560047%24%0%28%11%0%0%37%100%19741005500100%500197510560560047%24%0%28%11%0%0%37%100%19751005500100%500197610560560047%24%0%28%11%0%0%37%100%19761005500100%500197710560560047%24%0%28%11%0%0%37%100%19771005500100%500197810560560047%24%0%28%11%0%0%37%100%19781005500100%500197910560560047%24%0%28%11%0%0%37%100%19791005500100%500198010560560047%24%0%28%11%0%0%37%100%19801005500100%500198110560560047%24%0%28%11%0%0%37%100%19811005500100%500198210560560047%24%0%28%11%0%0%37%100%19821005500100%500198310560560047%24%0%28%11%0%0%37%100%19831005500100%500198410560560047%24%0%28%11%0%0%37%100%19841005500100%500198510560560047%24%0%28%11%0%0%37%100%19851005500100%500198610560560047%24%0%28%11%0%0%37%100%19861005500100%500198710560560047%24%0%28%11%0%0%37%100%19871005500100%500198810560560047%24%0%28%11%0%0%37%100%19881005500100%500198910560560047%24%0%28%11%0%0%37%100%19891005500100%500199010560560047%24%0%28%11%0%0%37%100%19901005500100%500199110560560047%24%0%28%11%0%0%37%100%19911005500100%500199210560560047%24%0%28%11%0%0%37%100%19921005500100%500199310560560047%24%0%28%11%0%0%37%100%19931005500100%500199410560560047%24%0%28%11%0%0%37%100%19941005500100%500199510560560047%24%0%28%11%0%0%37%100%19951005500100%500199610560560047%24%0%28%11%0%0%37%100%19961005500100%500199710560560047%24%0%28%11%0%0%37%100%19971005500100%500199810560560047%24%0%28%11%0%0%37%100%19981005500100%500199910560560047%24%0%28%11%0%0%37%100%19991005500100%500200010560560047%24%0%28%11%0%0%37%100%20001005500100%500200110560560047%24%0%28%11%0%0%37%100%20011005500100%500200210560560047%24%0%28%11%0%0%37%100%20021005500100%500200310560560047%24%0%28%11%0%0%37%100%20031005500100%500200410560560047%24%0%28%11%0%0%37%100%20041005500100%500200510560560047%24%0%28%11%0%0%37%100%20051005500100%500200610560560047%24%0%28%11%0%0%37%100%20061005500100%500200710560560047%24%0%28%11%0%0%37%100%20071005500100%500200810560560047%24%0%28%11%0%0%37%100%20081005500100%500200910560560047%24%0%28%11%0%0%37%100%20091005500100%500201010560560047%24%0%28%11%0%0%37%100%20101005500100%500201110560560047%24%0%28%11%0%0%37%100%20111005500100%500201210560560047%24%0%28%11%0%0%37%100%20121005500100%500201310560560047%24%0%28%11%0%0%37%100%20131005500100%500201410560560047%24%0%28%11%0%0%37%100%20141005500100%500201510560560047%24%0%28%11%0%0%37%100%20151005500100%500201610560560047%24%0%28%11%0%0%37%100%20161005500100%500201710560560047%24%0%28%11%0%0%37%100%20171005500100%500201810560560047%24%0%28%11%0%0%37%100%20181005500100%500201910560560047%24%0%28%11%0%0%37%100%20191005500100%500202010560560047%24%0%28%11%0%0%37%100%20201005500100%500202110560560047%24%0%28%11%0%0%37%100%20211005500100%500202210560560047%24%0%28%11%0%0%37%100%20221005500100%500202310560560047%24%0%28%11%0%0%37%100%20231005500100%500202410560560047%24%0%28%11%0%0%37%100%20241005500100%500202510560560047%24%0%28%11%0%0%37%100%20251005500100%500202610560560047%24%0%28%11%0%0%37%100%20261005500100%500202710560560047%24%0%28%11%0%0%37%100%20271005500100%500202810560560047%24%0%28%11%0%0%37%100%20281005500100%500202910560560047%24%0%28%11%0%0%37%100%20291005500100%500203010560560047%24%0%28%11%0%0%37%100%20301005500100%500

Amount deposited data Country0Countries with good inventory data:Enter those data onto this sheet.Amounts deposited in SWDSYearFoodGardenPaperWoodTextileNappiesSludgeDeposited MSWInert waste are wastes that do not contain degradable organic carbon (i.e., DOC=0). E.g., plastic, glass, metal etc.

InertIndustrial1 gigagram (Gg) is 1000 tonnes

GgGgGgGg195063707242900002.632982500195163707242900002.632982500195263707242900002.632982500195363707242900002.632982500195463707242900002.632982500195563707242900002.632982500195663707242900002.632982500195763707242900002.632982500195863707242900002.632982500195963707242900002.632982500196063707242900002.632982500196163707242900002.632982500196263707242900002.632982500196363707242900002.632982500196463707242900002.632982500196563707242900002.632982500196663707242900002.632982500196763707242900002.632982500196863707242900002.632982500196963707242900002.632982500197063707242900002.632982500197163707242900002.632982500197263707242900002.632982500197363707242900002.632982500197463707242900002.632982500197563707242900002.632982500197663707242900002.632982500197763707242900002.632982500197863707242900002.632982500197963707242900002.632982500198063707242900002.632982500198163707242900002.632982500198263707242900002.632982500198363707242900002.632982500198463707242900002.632982500198563707242900002.632982500198663707242900002.632982500198763707242900002.632982500198863707242900002.632982500198963707242900002.632982500199063707242900002.632982500199163707242900002.632982500199263707242900002.632982500199363707242900002.632982500199463707242900002.632982500199563707242900002.632982500199663707242900002.632982500199763707242900002.632982500199863707242900002.632982500199963707242900002.632982500200063707242900002.632982500200163707242900002.632982500200263707242900002.632982500200363707242900002.632982500200463707242900002.632982500200563707242900002.632982500200663707242900002.632982500200763707242900002.632982500200863707242900002.632982500200963707242900002.632982500201063707242900002.632982500201163707242900002.632982500201263707242900002.632982500201363707242900002.632982500201463707242900002.632982500201563707242900002.632982500201663707242900002.632982500201763707242900002.632982500201863707242900002.632982500201963707242900002.632982500202063707242900002.632982500202163707242900002.632982500202263707242900002.632982500202363707242900002.632982500202463707242900002.632982500202563707242900002.632982500202663707242900002.632982500202763707242900002.632982500202863707242900002.632982500202963707242900002.632982500203063707242900002.632982500

Methane Recovery and methane oxidised in top layer (OX)Enter the total amount of methane recovered from all SWDS. Amount of Methane Recovered from SWDSReferences / remarksFraction recovered methaneMethane oxidised (OX)References/remarksIPCC default00Year1 gigagram (Gg) is 1000 tonnes

GgFraction19500,00,000,0019510,00,000,0019520,00,000,0019530,00,000,0019540,00,000,0019550,00,000,0019560,00,000,0019570,00,000,0019580,00,000,0019590,00,000,0019600,00,000,0019610,00,000,0019620,00,000,0019630,00,000,0019640,00,000,0019650,00,000,0019660,00,000,0019670,00,000,0019680,00,000,0019690,00,000,0019700,00,000,0019710,00,000,0019720,00,000,0019730,00,000,0019740,00,000,0019750,00,000,0019760,00,000,0019770,00,000,0019780,00,000,0019790,00,000,0019800,00,000,0019810,00,000,0019820,00,000,0019830,00,000,0019840,00,000,0019850,00,000,0019860,00,000,0019870,00,000,0019880,00,000,0019890,00,000,0019900,00,000,0019910,00,000,0019920,00,000,0019930,00,000,0019940,00,000,0019950,00,000,0019960,00,000,0019970,00,000,0019980,00,000,0019990,00,000,00200010,00,080,00200110,00,080,00200210,00,080,00200310,00,080,00200410,00,080,00200510,00,080,00200610,00,080,00200710,00,080,00200810,00,080,00200910,00,080,00201010,00,080,00201110,00,080,00201210,00,080,00201310,00,080,00201410,00,080,00201510,00,080,00201610,00,080,00201710,00,080,00201810,00,080,00201910,00,080,00202010,00,080,00202110,00,080,00202210,00,080,00202310,00,070,00202410,00,070,00202510,00,070,00202610,00,070,00202710,00,070,00202810,00,070,00202910,00,070,00203010,00,070,00

ResultsCountry0Enter starting year, industrial waste disposal data and methane recovery into the yellow cells. MSW activity data is entered on MSW sheetMethane generatedYearFoodGardenPaperWoodTextileNappiesSludgeMSWIndustrialTotalMethane recoveryFinal summation. Adds the methane produced from the different materials and subtracts the methane recovery. Finally it subtracts the methane oxidation in the top layer. Equation 10 on the Theory sheet.

Methane emissionA BCDEFGHJKLM = (K-L)*(1-OX)1 gigagram (Gg) is 1000 tonnes

GgGgGgGgGgGgGg195000000000000195140410002100101952708200031901919531001130004280281954120153000535035195514018400064204219561502150007480481957160236000854054195817026600095905919591802870001063063196019031800011680681961200338000117207219622003590001276076196320037900012790791964210391000013820821965210401100013850851966210421100014880881967210441200014910911968220451200014930931969220461300015950951970220481300015980981971220491400015100010019722205014000151010101197322051150001610301031974220521500016105010519752205315000161070107197622054160001610801081977220551600016109010919782205517000161110111197922056170001711201121980220571700017113011319812205718000171140114198222058180001711501151983220591800017116011619842205919000171170117198522060190001711801181986220601900017119011919872206120000171200120198822061200001712101211989220612000017121012119902206220000171220122199122062210001712301231992220632100017123012319932206321000181240124199422063210001812501251995220632200018125012519962206422000181260126199722064220001812601261998220642200018127012719992206423000181270127200022065230001812810118200122065230001812810118200222065230001812810118200322065230001812910119200422065230001812910119200522066240001812910119200622066240001813010120200722066240001813010120200822066240001813010120200922066240001813110121201022066240001813110121201122066250001813110121201222066250001813110121201322066250001813210122201422067250001813210122201522067250001813210122201622067250001813210122201722067250001813210122201822067250001813310123201922067260001813310123202022067260001813310123202122067260001813310123202222067260001813310123202322067260001813310123202422067260001813410124202522067260001813410124202622067260001813410124202722067260001813410124202822067260001813410124202922067270001813410124203022067270001813410124

Harwested Wood ProductsThis sheet gives information on the methane emission from HWP, and HWP C long-term stored in SWDSLong-term stored CLong term stored C accumulatedCH4 generatedCH4 emittedYearGarden CPaper CWood CGarden CPaper CWood CGardenPaperWoodGardenPaperWood1 gigagram (Gg) is 1000 tonnes

GgGgGgGgGgGgGgGgGgGgGgGg1950010244010244000000195101024402048804104119520102440306132082082195301024404081760113011319540102440510219015301531955010244061226301840184195601024407143070215021519570102440816351023602361958010244091939502660266195901024401.02143902870287196001024401.12348303180318196101024401.22552703380338196201024401.32757003590359196301024401.42961403790379196401024401.5316580391003910196501024401.6337020401104011196601024401.7357460421104211196701024401.8377900441204412196801024401.9398340451204512196901024402.0418780461304613197001024402.1439220481304813197101024402.2459650491404914197201024402.3471.0090501405014197301024402.4491.0530511505115197401024402.5511.0970521505215197501024402.6531.1410531505315197601024402.7561.1850541605416197701024402.8581.2290551605516197801024402.9601.2730551705517197901024403.0621.3170561705617198001024403.1641.3600571705717198101024403.2661.4040571805718198201024403.3681.4480581805818198301024403.4701.4920591805918198401024403.5721.5360591905919198501024403.6741.5800601906019198601024403.7761.6240601906019198701024403.8781.6680612006120198801024403.9801.7110612006120198901024404.0821.7550612006120199001024404.1841.7990622006220199101024404.2861.8430622106221199201024404.3881.8870632106321199301024404.4901.9310632106321199401024404.5931.9750632106321199501024404.6952.0190632206322199601024404.7972.0630642206422199701024404.8992.1060642206422199801024405.0012.1500642206422199901024405.1032.1940642306423200001024405.2052.2380652306021200101024405.3072.2820652306021200201024405.4092.3260652306021200301024405.5112.3700652306021200401024405.6132.4140652306022200501024405.7152.4580662406022200601024405.8172.5010662406122200701024405.9192.5450662406122200801024406.0212.5890662406122200901024406.1232.6330662406122201001024406.2252.6770662406123201101024406.3272.7210662506123201201024406.4302.7650662506123201301024406.5322.8090662506123201401024406.6342.8520672506223201501024406.7362.8960672506223201601024406.8382.9400672506223201701024406.9402.9840672506223201801024407.0423.0280672506224201901024407.1443.0720672606224202001024407.2463.1160672606224202101024407.3483.1600672606224202201024407.4503.2040672606224202301024407.5523.2470672606224202401024407.6543.2910672606224202501024407.7563.3350672606224202601024407.8583.3790672606224202701024407.9603.4230672606224202801024408.0623.4670672606224202901024408.1643.5110672706225203001024408.2673.5550672706225

Country0Long-term stored C in SWDSIn this sheet carbon long-term stored C in SWDS is calculated.DOC:MSW0Food waste0,15Nappies0,24Paper0,4Garden0,2Sludge0,05Wood0,43Textiles0,24Industry0,15YearMSWFoodGardenPaperWoodTextilesNappiesSludgeC, IndustryPaper, industry subtotalWood, industry subtotalLong-term stored CLong-term stored C accumulated1 gigagram (Gg) is 1000 tonnes

GgGgGgGgGgGgGgGgGgGg19500340102440002700206206195103401024400027002064131952034010244000270020661919530340102440002700206826195403401024400027002061.032195503401024400027002061.239195603401024400027002061.445195703401024400027002061.651195803401024400027002061.858195903401024400027002062.064196003401024400027002062.271196103401024400027002062.477196203401024400027002062.684196303401024400027002062.890196403401024400027002063.096196503401024400027002063.303196603401024400027002063.509196703401024400027002063.716196803401024400027002063.922196903401024400027002064.129197003401024400027002064.335197103401024400027002064.541197203401024400027002064.748197303401024400027002064.954197403401024400027002065.161197503401024400027002065.367197603401024400027002065.574197703401024400027002065.780197803401024400027002065.986197903401024400027002066.193198003401024400027002066.399198103401024400027002066.606198203401024400027002066.812198303401024400027002067.019198403401024400027002067.225198503401024400027002067.432198603401024400027002067.638198703401024400027002067.844198803401024400027002068.051198903401024400027002068.257199003401024400027002068.464199103401024400027002068.670199203401024400027002068.877199303401024400027002069.083199403401024400027002069.289199503401024400027002069.496199603401024400027002069.702199703401024400027002069.9091998034010244000270020610.1151999034010244000270020610.3222000034010244000270020610.5282001034010244000270020610.7342002034010244000270020610.9412003034010244000270020611.1472004034010244000270020611.3542005034010244000270020611.5602006034010244000270020611.7672007034010244000270020611.9732008034010244000270020612.1792009034010244000270020612.3862010034010244000270020612.5922011034010244000270020612.7992012034010244000270020613.0052013034010244000270020613.2122014034010244000270020613.4182015034010244000270020613.6242016034010244000270020613.8312017034010244000270020614.0372018034010244000270020614.2442019034010244000270020614.4502020034010244000270020614.6572021034010244000270020614.8632022034010244000270020615.0692023034010244000270020615.2762024034010244000270020615.4822025034010244000270020615.6892026034010244000270020615.8952027034010244000270020616.1022028034010244000270020616.3082029034010244000270020616.5142030034010244000270020616.721

IPCC Spreadsheet for Estimating Methane emissions from Solid Waste Disposal SitesBulk waste and waste composition options.Theory and equations

The basic equation for the first order decay model is:

(1) DDOCm = DDOCm(0) * e^-kt

where DDOCm(0) is the mass of decomposable degradable organic carbon (DOC) at the start of the reaction, when t=0 and e^-kt=1, k is the reaction constant and t is the time in years. DDOCm is the mass of DDOC at any time.

From equation (I) it is easy to see that at the end of year 1 (going from point 0 to point 1 on the time axis) the mass of DDOC left not decomposed in the SWDS is:

(2) DDOCm(1) = DDOCm(0) * e^-k

and the mass of DDOC decomposed into CH4 and CO2 will be:

(3) DDOCmdecomp(1) = DDOCm(0) * (1 - e^-k)

In a first order reaction, the amount of product (here decomposed DDOCm) is always proportional to the amount of reactant (here DDOCm). This means that it does not matter when the DDOCm was deposited. This also means that when the amount of DDOCm accumulated in the SWDS, plus last year's deposit, is known, CH4 production can be calculated as if every year is year number one in the time series. Then all calculations can be done by equations (2) and (3) in a simple spreadsheet.

The default assumption is that CH4 generation from all the waste deposited each year begins on the 1st of January in the year after deposition. This is the same as an average six month delay until substantial CH4 generation begins (the time it takes for anaerobic conditions to become well established). However, the worksheet includes the possibility of an earlier start to the reaction, in the year of deposition of the waste. This requires separate calculations for the deposition year. For longer delay times than 6 months, DDOCmd in the columns F and G cells in the CH4 calculating sheets, have to be readdressed one cell down, and the number 13 in exp2 has to be changed to 25 (7 to 18 months delay time).

The equations used in these spreadsheets are: (As the mathematics of every waste fraction/category is the same, indexing for fraction/category is omitted for equations 4-9.)

To calculate mass of decomposable DOC (DDOCm) from amount of waste material (W):

(4) DDOCmd(T), = W(T) DOC * DOCf MCF

The amount of deposited DDOCm remaining not decomposed at the end of deposition year T:

(5) DDOCmrem(T) = DDOCmd(T) e^(-k ((13-M)/12)

The amount of deposited DDOCm decomposed during deposition year T:

(6) DDOCmdec(T) = DDOCmd(T) (1 e^(-k ((13-M)/12)))

The amount of DDOCm accumulated in the SWDS at the end of year T

(7) DDOCma(T) = DDOCmrem(T) + ( DDOCma(T-1) e^-k)

The total amount of DDOCm decomposed in year T

(8) DDOCmdecomp(T) = DDOCmdec(T) + (DDOCma(T-1) (1 - e^-k))

The amount of CH4 generated from DOC decomposed

(9) CH4 generated(T) = DDOCmdecomp(T) F 16/12

The amount of CH4 emitted

(10) CH4 emitted in year T = (xCH4 generated (x,T) R(T)) (1- OX(T))

Where: T = the year of inventoryx = material fraction/waste categoryW(T) = amount deposited in year TMCF = Methane Correction FactorDOC = Degradable organic carbon (under aerobic conditions)DOCf = Fraction of DOC decomposing under anaerobic conditionsDDOC = Decomposable Degradable Organic Carbon (under anaerobic conditions)DDOCmd(T) = mass of DDOC deposited year TDDOCmrem(T) = mass of DDOC deposited in inventory year T, remaining not decomposed at the end of year.DDOCmdec(T) = mass of DDOC deposited in inventory year T, decomposed during the year.DDOCma(T) = total mass of DDOC left not decomposed at end of year T. DDOCma(T-1) = total mass of DDOC left not decomposed at end of year T-1.DDOCmdecomp(T) = total mass of DDOC decomposed in year T.CH4 generated(T) = CH4 generated in year TF = Fraction of CH4 by volume in generated landfill gas16/12 = Molecular weight ratio CH4/C R(T) = Recovered CH4 in year TOX(T) = Oxidation factor in year T (fraction)k = rate of reaction constant M = Month of reaction start (= delay time + 7)

IPCC DEFAULT METHANE GENERATION RATE CONSTANTS (1/yr)IPCC DEFAULT DOC VALUESIPCC REGIONAL DEFAULT VALUES FOR WASTE COMPOSITION, WASTE GENERATION, AND FRACTION DISPOSED(Derived from k values obtained in experimental measurements, calculated by models, or used in GHG inventories and other studies) Default DOC0,40,240,150,430,20,240,050,390TemperateTropicalSelect313MSW Generation Rate (tonnes/cap/yr)Fraction MSW disposed to SWDSRegional Average DOC (wt fraction)DryWetDryMoist and WetPercent Waste Composition DataType of WasteDefault ValueRangeDefault ValueRangeDefault ValueRangeDefault ValueRangeDefault ValueRangePaper/ card boardTextilesFood wasteWoodGarden / parkNappies / DiapersSewage sludgeRubber / leatherIncludes plastic, metal, glass, ash, and other inert material (i.e., material with DOC=0).

All other, inertsSlowly degrading wastePaper/textile waste0,040.030.050,060.050.070,0450.040.060,070.060.085Food waste0,150.08-0.201Asia: Eastern18,83,526,23,51,047,00,550,550,14Wood/ straw/ rubber waste0,020.010.030,030.020.040,0250.020.040,0350.030.05Garden0,20.18-0.222Asia: South-central11,32,540,37,90,837,20,210,740,15Moderately degrading wasteGarden and park waste0,050.040.060,10.060.10,0650.050.080,170.150.2Paper0,40.36-0.453Asia- Southeast12,92,743,59,90,930,10,270,590,17Rapidly degrading wasteFood waste/ sewage sludge0,060.050.080,1850.10.20,0850.070.10,40.170.7 Wood and straw0,430.39-0.464Asia- Western & Middle East18,02,941,19,80,627,6No data; defulat is average of all available regional data.

0,42No data; defulat is average of all available regional data.

0,680,19Bulk MSW or Industrial WasteMixed composition0,050.040.060,090.080.10,0650.050.080,170.150.2Textiles0,240.20-0.405Africa: Eastern7,71,753,97,01,128,60,290,690,15Disposable nappies0,240.18-0.326Africa: Middle16,82,543,46,530,80,290,690,17IPCC Climate Zone DefinitionsSewage sludge0,050.04-0.057Africa: Northern16,52,551,12,027,90,290,690,16Rubber0,390.398Africa: Southern25,023,015,037,00,290,690,20MATMAPMAP/PETThis cell records which climate zone is selected in the drop-down box on the parameter sheet.

Selected:Bulk MSW waste0,180.12-0.289Africa: Western9,81,040,44,444,40,290,690,121Dry temperate0 - 20C111Europe: Northern30,62,023,810,033,60,640,470,213Dry tropical> 20C 20C>1000 mm12Bulk waste data only13Europe: Western27,524,211,037,30,560,470,1914Oceania: Austrailia & New Zealand30,036,024,010,00,690,850,2815Oceania: Other Oceania6,067,52,524,00,690,850,14MAT Mean annual temperature; 16America: North23,23,933,96,21,431,40,650,580,19MAP Mean annual precipitation; 17America: Central13,72,643,813,51,824,60,210,500,19PET Potential evapotranspiration. 18America: South17,12,644,94,70,730,00,260,540,16The average annual MAT, MAP and PET during the time series selected to estimate the emission and indicated by the nearest representative meteorological station. The information available is not adequate to subdivide temperate into cold (