{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Calculator","Detailed Results","Year (Hidden)","Documentation_Food Waste Decay","Documentation_Methane Fate","Documentation_Example Calc","Sources"],"not_rendered":{"images":2},"read":"whole","date_system":"1900"}

{"sheet":"Calculator","index":0,"n_rows":59,"n_cols":3,"rows_kept":59,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,2],[16,0,16,2],[17,0,17,2],[18,0,18,2],[23,0,23,2],[24,0,25,2],[55,0,55,2],[58,0,58,2]]}
[]
["Methane (CH4), a powerful greenhouse gas, is emitted from landfills resulting from the decaying of organic waste over time under anaerobic conditions. With this Avoided Landfilled Food Waste Emissions Calculator, users can estimate the amount of methane emissions avoided by not sending food waste to a landfill. The calculator is built upon the methodology included in EPA’s Quantifying Methane Emissions from Landfilled Food Waste report. The calculator relies on key landfill parameters (e.g., gas collection system schedule and efficiency) that are representative of a national average. Results at specific landfill sites may vary. "]
["The calculator assumes food waste is prevented rather than landfilled. If, instead, food waste is generated and managed through a different pathway, such as anaerobic digestion or composting, some emissions may occur. Please see EPA report “From Field to Bin: The Environmental Impacts of U.S. Food Waste Pathways” for information on relative greenhouse gas emissions of other pathways. For detailed information on the calculator methodology, please see the Documentation tabs."]
["User Input"]
["To use the calculator, please enter values in the GREEN cells. Enter the starting year and tonnages of food waste not going to landfill per year for up to six years. Select a global warming potential (GWP) or use the default value (28). EPA suggests using a value of 28 to estimate 100-year GWP of methane and a value of 84 to estimate 20-year GWP. All other fields and tabs of the calculator are protected to avoid unintentional changes to the underlying modeling."]
["Variable","Value","Assumptions/Notes"]
["Enter Methane Global Warming Potential:\n(kgCO2 equivalent/kg CH4)",28,"Default for 100-year time horizon: 28\nDefault for 20-year time horizon: 84"]
["Select starting calendar year:",2025]
["Year","Enter the Value of Food Waste Not Sent to Landfill Each Year (Short tons per year)","Assumptions/Notes (Use this column as needed to note food waste amounts and assumptions)"]
[{"$f":"_xlfn.CONCAT(\"Year 1 / \",'Detailed Results'!A68)","v":"Year 1 / 2025"},1000]
[{"$f":"_xlfn.CONCAT(\"Year 2 / \",'Detailed Results'!A69)","v":"Year 2 / 2026"},1000]
[{"$f":"_xlfn.CONCAT(\"Year 3 / \",'Detailed Results'!A70)","v":"Year 3 / 2027"},1000]
[{"$f":"_xlfn.CONCAT(\"Year 4 / \",'Detailed Results'!A71)","v":"Year 4 / 2028"},1000]
[{"$f":"_xlfn.CONCAT(\"Year 5 / \",'Detailed Results'!A72)","v":"Year 5 / 2029"},1000]
[{"$f":"_xlfn.CONCAT(\"Year 6 / \",'Detailed Results'!A73)","v":"Year 6 / 2030"},1000]
[]
["Results - Summary"]
["Based on results from the EPA’s Avoided Landfilled Food Waste Methane Emissions Calculator, approximately "]
[{"$f":"_xlfn.CONCAT(ROUND(B21,1),\" total metric tons of methane would be avoided between \",A28,\" and \",A53,\".\")","v":"263.7 total metric tons of methane would be avoided between 2025 and 2050."}]
["Total Avoided Emissions","Value"]
["Total Metric Tons CH4 Avoided",{"$f":"B54","v":{"v":263.66674352873684,"d":"263.7"}}]
["Total Metric Tons of CO2eq. Avoided",{"$f":"C54","v":{"v":7382.668818804636,"d":"7383"}}]
[]
["Results - Methane Emissions Avoided by Year"]
["The table below shows avoided methane emissions expressed as metric tons (MT) of methane emissions\n and metric tons (MT) of carbon dioxide equivalents (CO2eq)."]
[]
["Year","Metric Tons (MT) CH4 Avoided","Metric Tons (MT) CO2 Equivalent Avoided"]
[{"$f":"'Detailed Results'!A68","v":2025},{"$f":"'Detailed Results'!C68","v":{"v":10.091743308423112,"d":"10.09"}},{"$f":"B28*$B$7","v":{"v":282.56881263584717,"d":"282.6"}}]
[{"$f":"A28+1","v":2026},{"$f":"'Detailed Results'!C69","v":{"v":18.437202614735412,"d":"18.44"}},{"v":516.2416732125915,"d":"516.2"}]
[{"$f":"A29+1","v":2027},{"$f":"'Detailed Results'!C70","v":{"v":25.338556415043,"d":"25.34"}},{"v":709.479579621204,"d":"709.5"}]
[2028,{"$f":"'Detailed Results'!C71","v":{"v":31.045693976782104,"d":"31.05"}},{"v":869.2794313498989,"d":"869.3"}]
[2029,{"$f":"'Detailed Results'!C72","v":{"v":35.7652635121335,"d":"35.77"}},{"v":1001.427378339738,"d":"1001.4"}]
[2030,{"$f":"'Detailed Results'!C73","v":{"v":37.53028097999572,"d":"37.53"}},{"v":1050.8478674398802,"d":"1050.8"}]
[2031,{"$f":"'Detailed Results'!C74","v":{"v":28.89813498819086,"d":"28.90"}},{"v":809.1477796693441,"d":"809.1"}]
[2032,{"$f":"'Detailed Results'!C75","v":{"v":21.759703014735244,"d":"21.76"}},{"v":609.2716844125869,"d":"609.3"}]
[2033,{"$f":"'Detailed Results'!C76","v":{"v":15.856511492252782,"d":"15.86"}},{"v":443.9823217830779,"d":"444.0"}]
[2034,{"$f":"'Detailed Results'!C77","v":{"v":10.974813343318885,"d":"10.97"}},{"v":307.2947736129288,"d":"307.3"}]
[2035,{"$f":"'Detailed Results'!C78","v":{"v":6.6502307541257695,"d":"6.65"}},{"v":186.20646111552153,"d":"186.2"}]
[2036,{"$f":"'Detailed Results'!C79","v":{"v":5.211851349177534,"d":"5.21"}},{"v":145.93183777697095,"d":"145.9"}]
[2037,{"$f":"'Detailed Results'!C80","v":{"v":4.022370362179573,"d":"4.02"}},{"v":112.62637014102805,"d":"112.6"}]
[2038,{"$f":"'Detailed Results'!C81","v":{"v":3.038718195329642,"d":"3.04"}},{"v":85.08410946922997,"d":"85.1"}]
[2039,{"$f":"'Detailed Results'!C82","v":{"v":2.225278051329912,"d":"2.23"}},{"v":62.30778543723754,"d":"62.3"}]
[2040,{"$f":"'Detailed Results'!C83","v":{"v":1.5192262234040625,"d":"1.52"}},{"v":42.53833425531375,"d":"42.5"}]
[2041,{"$f":"'Detailed Results'!C84","v":{"v":1.2229679310411998,"d":"1.22"}},{"v":34.24310206915359,"d":"34.2"}]
[2042,{"$f":"'Detailed Results'!C85","v":{"v":0.9779744301652675,"d":"0.98"}},{"v":27.38328404462749,"d":"27.4"}]
[2043,{"$f":"'Detailed Results'!C86","v":{"v":0.7753748168591543,"d":"0.78"}},{"v":21.710494872056323,"d":"21.7"}]
[2044,{"$f":"'Detailed Results'!C87","v":{"v":0.6078332161022708,"d":"0.61"}},{"v":17.019330050863584,"d":"17.0"}]
[2045,{"$f":"'Detailed Results'!C88","v":{"v":0.4692831590408737,"d":"0.47"}},{"v":13.139928453144464,"d":"13.1"}]
[2046,{"$f":"'Detailed Results'!C89","v":{"v":0.37740561133217065,"d":"0.38"}},{"v":10.567357117300778,"d":"10.6"}]
[2047,{"$f":"'Detailed Results'!C90","v":{"v":0.30142663405014164,"d":"0.30"}},{"v":8.439945753403967,"d":"8.4"}]
[2048,{"$f":"'Detailed Results'!C91","v":{"v":0.2385951247990925,"d":"0.24"}},{"v":6.68066349437459,"d":"6.7"}]
[2049,{"$f":"'Detailed Results'!C92","v":{"v":0.18663603432449052,"d":"0.19"}},{"v":5.225808961085734,"d":"5.2"}]
[2050,{"$f":"'Detailed Results'!C93","v":{"v":0.1436679898651289,"d":"0.14"}},{"v":4.022703716223609,"d":"4.0"}]
["Total",{"$f":"SUM(B28:B53)","v":{"v":263.66674352873684,"d":"263.7"}},{"$f":"SUM(C28:C53)","v":{"v":7382.668818804636,"d":"7383"}}]
["ACKNOWLEDGEMENTS"]
["U.S. EPA would like to thank the following people for their independent peer review of the calculator: Nicole Berge, University of South Carolina; Andrew Carpenter, Northern Tilth LLC; and Debra Reinhart, University of Central Florida. The calculator was prepared with support from ERG under U.S. EPA Contract No. 68HERH22A0020 and 68HERC21D0003. The external peer review of the calculator was coordinated by Versar, Inc. under U.S. EPA Contract No. GS-00F-079CA."]
["RECOMMENDED CITATION"]
["Please use the following citation when referencing this calculator:"]
["U.S. EPA (2024). Avoided Landfilled Food Waste Methane Emissions Calculator. \nRetrieved from: https://www.epa.gov/land-research/quantifying-methane-emissions-landfilled-food-waste."]

{"sheet":"Detailed Results","index":1,"n_rows":312,"n_cols":8,"rows_kept":312,"merged":[[1,0,1,8],[2,0,2,8],[3,0,3,8],[4,0,4,8],[5,0,5,8],[6,0,6,8],[7,0,7,8],[8,0,8,8],[9,0,9,8],[10,0,10,8],[11,0,11,8],[12,0,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3]]}
["Avoided Landfilled Food Waste  Methane Emissions Calculator - Detailed Calculations"]
["This tab contains the detailed inputs and calculations used to determine both the total and yearly amounts of methane released from food waste landfilling. "]
["Inputs and Landfill Profile"]
["Table A: Calculator Inputs summarizes the user inputs from the \"Summary Results\" tab and the methane generation potential, food waste decay rate, and landfill capacity fraction used as inputs. "]
["Table B: Landfill Profile and Methane Fate details the landfill characteristics used to generate the methane emissions summary, which was created from EPA's Quantifying Methane Emissions from Landfilled Food Waste\" Report (2023) "]
["Oxidation rate for 0-4 'years from initial waste placement' is assumed to be 10%, when the recently disposed food waste is still close to the working face of the landfill, similar to IPCC guidelines. "]
["Additionally, the calculator assumes that food waste decay begins the year the food waste is landfilled. Since the methane generation potential is given per unit of wet weight of food waste, the moisture content is not accounted for in these calculations. These calculations are only valid at 70% moisture content."]
["Detailed Annual Calculations"]
["Table C: Methane Emissions Summary details the methane emissions generated and released for each year. Final methane emissions values are rounded to 2 decimals and CO2eq values are rounded to 1 decimal in the results table. The final summary value is arounded to 1 decimal. This allows users to see changes due to approximately 1 short ton of avoided food waste. "]
["The remaining tables below Table C detail the methane mass balance for each year. Tables below calculates the emissions over 30 years from a year's worth of food waste being landfilled, taking into account the amount of methane generated that is captured and destroyed and oxidized in the soil cover."]
["Links to each source are included in the Source tab at the end of this calculator."]
[]
["Units"]
["m3  ","cubic meters "]
["MT ","metric ton "]
["CO2eq","CO2 equivalent (Default Global Warming Potential [GWP] CH4 = 28) "]
["Inputs and Landfill Profile"]
["Table A: Calculator Inputs"]
["Variables and Constants","Value","Unit","Source","Notes"]
["Methane Generation Potential",{"$f":"1.62/25","v":{"v":0.06480000000000001,"d":"0.0648"}},"MT CH4/short ton food waste","U.S. EPA. (2020)","Original factor was 1.62 metric ton CO2eq/short ton food waste, which used a GWP factor of 25 for methane. The value used here (0.0648) is converted to MT CH4 from 1.62 metric ton CO2eq/short ton food waste.\nThis value assumes 70% moisture content and is used on a wet basis in the calculation table."]
["Food Waste Decay Rate",0.19,"Food decay rate(yr-1)","U.S. EPA. (2020)"]
["Landfill Capacity Fraction with Gas Capture",0.927,"Fraction of total landfill capacity","U.S. EPA. (2024)"]
["Food Waste Avoided, Year 1",{"$f":"Calculator!B10","v":{"v":1000,"d":"1000.00"}},"Short tons Food Waste","User Input","Entered on the Summary Results Tab"]
["Food Waste Avoided, Year 2",{"$f":"Calculator!B11","v":{"v":1000,"d":"1000.00"}},"Short tons Food Waste","User Input","Entered on the Summary Results Tab"]
["Food Waste Avoided, Year 3",{"$f":"Calculator!B12","v":{"v":1000,"d":"1000.00"}},"Short tons Food Waste","User Input","Entered on the Summary Results Tab"]
["Food Waste Avoided, Year 4",{"$f":"Calculator!B13","v":{"v":1000,"d":"1000.00"}},"Short tons Food Waste","User Input","Entered on the Summary Results Tab"]
["Food Waste Avoided, Year 5",{"$f":"Calculator!B14","v":{"v":1000,"d":"1000.00"}},"Short tons Food Waste","User Input","Entered on the Summary Results Tab"]
["Food Waste Avoided, Year 6",{"$f":"Calculator!B15","v":{"v":1000,"d":"1000.00"}},"Short tons Food Waste","User Input","Entered on the Summary Results Tab"]
[]
["Table B: Landfill Profile and Methane Fate"]
["Year from Initial Waste Placement","Collection Efficiency","Destruction Efficiency for Collected Methane","Oxidation Rate"]
[0,{"v":0,"d":"0.00%"},0,{"v":0.1,"d":"10%"}]
[1,{"v":0,"d":"0.00%"},0,{"v":0.1,"d":"10%"}]
[2,{"v":0,"d":"0.00%"},0,{"v":0.1,"d":"10%"}]
[3,{"v":0,"d":"0.00%"},0,{"v":0.1,"d":"10%"}]
[4,{"v":0,"d":"0.00%"},0,{"v":0.1,"d":"10%"}]
[5,{"v":0.5,"d":"50.00%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[6,{"v":0.5,"d":"50.00%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[7,{"v":0.5,"d":"50.00%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[8,{"v":0.5,"d":"50.00%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[9,{"v":0.5,"d":"50.00%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[10,{"v":0.75,"d":"75.00%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[11,{"v":0.75,"d":"75.00%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[12,{"v":0.75,"d":"75.00%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[13,{"v":0.75,"d":"75.00%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[14,{"v":0.75,"d":"75.00%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[15,{"v":0.825,"d":"82.50%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[16,{"v":0.825,"d":"82.50%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[17,{"v":0.825,"d":"82.50%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[18,{"v":0.825,"d":"82.50%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[19,{"v":0.825,"d":"82.50%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[20,{"v":0.825,"d":"82.50%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[21,{"v":0.9,"d":"90%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[22,{"v":0.9,"d":"90%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[23,{"v":0.9,"d":"90%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[24,{"v":0.9,"d":"90%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[25,{"v":0.9,"d":"90%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[26,{"v":0.9,"d":"90%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[27,{"v":0.9,"d":"90%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[28,{"v":0.9,"d":"90%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[29,{"v":0.9,"d":"90%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[30,{"v":0.9,"d":"90%"},{"v":0.99,"d":"99%"},{"v":0.25,"d":"25%"}]
[]
[]
["Detailed Annual Calculations"]
["Table C: Methane Emissions Summary"]
["Year","Yearly Methane Generated (MT CH4)","Yearly Methane Released (MT CH4)"]
[{"$f":"Calculator!B8","v":2025},{"$f":"SUM(E104,E139,E174,E210,E246,E282)","v":{"v":11.213048120470125,"d":"11.21"}},{"$f":"SUM(H104,H139,H174,H210,H246,H282)","v":{"v":10.091743308423112,"d":"10.09"}}]
[{"$f":"A68+1","v":2026},{"v":20.485780683039344,"d":"20.49"},{"v":18.437202614735412,"d":"18.44"}]
[2027,{"v":28.153951572270003,"d":"28.15"},{"v":25.338556415043,"d":"25.34"}]
[2028,{"v":34.49521552975789,"d":"34.50"},{"v":31.045693976782104,"d":"31.05"}]
[2029,{"v":39.739181680148334,"d":"39.74"},{"v":35.7652635121335,"d":"35.77"}]
[2030,{"v":44.07572738630352,"d":"44.08"},{"v":37.53028097999572,"d":"37.53"}]
[2031,{"v":36.448825347301295,"d":"36.45"},{"v":28.89813498819086,"d":"28.90"}]
[2032,{"v":30.141689042457152,"d":"30.14"},{"v":21.759703014735244,"d":"21.76"}]
[2033,{"v":24.9259450661405,"d":"24.93"},{"v":15.856511492252782,"d":"15.86"}]
[2034,{"v":20.61273794461537,"d":"20.61"},{"v":10.974813343318885,"d":"10.97"}]
[2035,{"v":17.045891918880606,"d":"17.05"},{"v":6.6502307541257695,"d":"6.65"}]
[2036,{"v":14.096256018529665,"d":"14.10"},{"v":5.211851349177534,"d":"5.21"}]
[2037,{"v":11.657027668927201,"d":"11.66"},{"v":4.022370362179573,"d":"4.02"}]
[2038,{"v":9.63988550544985,"d":"9.64"},{"v":3.038718195329642,"d":"3.04"}]
[2039,{"v":7.971791368899979,"d":"7.97"},{"v":2.225278051329912,"d":"2.23"}]
[2040,{"v":6.592345686402698,"d":"6.59"},{"v":1.5192262234040625,"d":"1.52"}]
[2041,{"v":5.451600479482836,"d":"5.45"},{"v":1.2229679310411998,"d":"1.22"}]
[2042,{"v":4.5082508111183435,"d":"4.51"},{"v":0.9779744301652675,"d":"0.98"}]
[2043,{"v":3.728139186361886,"d":"3.73"},{"v":0.7753748168591543,"d":"0.78"}]
[2044,{"v":3.0830187527741364,"d":"3.08"},{"v":0.6078332161022708,"d":"0.61"}]
[2045,{"v":2.5495305177252447,"d":"2.55"},{"v":0.4692831590408737,"d":"0.47"}]
[2046,{"v":2.1083575489002406,"d":"2.11"},{"v":0.37740561133217065,"d":"0.38"}]
[2047,{"v":1.743525532681493,"d":"1.74"},{"v":0.30142663405014164,"d":"0.30"}]
[2048,{"v":1.441824364514427,"d":"1.44"},{"v":0.2385951247990925,"d":"0.24"}]
[2049,{"v":1.1923298277772891,"d":"1.19"},{"v":0.18663603432449052,"d":"0.19"}]
[2050,{"v":0.9860080417535454,"d":"0.99"},{"v":0.1436679898651289,"d":"0.14"}]
[2051,{"v":0.8153883562697025,"d":"0.82"},{"v":0.10813517303177535,"d":"0.11"}]
[2052,{"v":0.674292848928295,"d":"0.67"},{"v":0.08942336903917258,"d":"0.09"}]
[2053,{"v":0.5576126303739453,"d":"0.56"},{"v":0.07394947181493185,"d":"0.07"}]
[2054,{"v":0.4611228578899179,"d":"0.46"},{"v":0.06115319116764512,"d":"0.06"}]
[2055,{"v":0.38132975920213463,"d":"0.38"},{"v":0.05057119000586869,"d":"0.05"}]
[]
[]
["Annual Methane Emissions Summary Tables Years 1 through 6 (based on the Year 1 selection from the Summary Results Tab) "]
[{"$f":"_xlfn.CONCAT(\"Food Waste Addition during \",Calculator!A10)","v":"Food Waste Addition during Year 1 / 2025"}]
["Year","Year Since Placement","Food Waste in Landfill (short tons, start of year)","Food Waste Decayed (short tons)","Methane Generated (MT CH4)","Methane Captured (MT CH4)","Methane Oxidized (MT CH4)","Methane Released (MT CH4)"]
[{"$f":"Calculator!$B8","v":2025},0,{"$f":"Calculator!B10","v":1000},{"$f":"C104*(1-EXP(-$B$21))","v":{"v":173.0408660566377,"d":"173"}},{"$f":"D104*$B$20","v":{"v":11.213048120470125,"d":"11.21"}},{"$f":"E104*_xlfn.XLOOKUP(B104,$A$32:$A$62,$B$32:$B$62)*$B$22","v":{"v":0,"d":"0.00"}},{"$f":"(E104-F104)*_xlfn.XLOOKUP(B104,$A$32:$A$62,$D$32:$D$62)","v":{"v":1.1213048120470126,"d":"1.12"}},{"$f":"E104-F104*_xlfn.XLOOKUP(B104,$A$32:$A$62,$C$32:$C$62)-G104","v":{"v":10.091743308423112,"d":"10.09"}}]
[{"$f":"A104+1","v":2026},{"$f":"B104+1","v":1},{"$f":"C104-D104","v":{"v":826.9591339433623,"d":"827"}},{"$f":"C105*(1-EXP(-$B$21))","v":{"v":143.09772473100648,"d":"143"}},{"$f":"D105*$B$20","v":{"v":9.272732562569221,"d":"9.27"}},{"v":0,"d":"0.00"},{"v":0.9272732562569221,"d":"0.93"},{"v":8.345459306312298,"d":"8.35"}]
[{"$f":"A105+1","v":2027},2,{"$f":"C105-D105","v":{"v":683.8614092123559,"d":"684"}},{"v":118.33597051281878,"d":"118"},{"v":7.668170889230658,"d":"7.67"},{"v":0,"d":"0.00"},{"v":0.7668170889230659,"d":"0.77"},{"v":6.901353800307592,"d":"6.90"}]
[2028,3,{"v":565.5254386995371,"d":"566"},{"v":97.85901168962788,"d":"98"},{"v":6.341263957487888,"d":"6.34"},{"v":0,"d":"0.00"},{"v":0.6341263957487888,"d":"0.63"},{"v":5.707137561739099,"d":"5.71"}]
[2029,4,{"v":467.66642700990917,"d":"468"},{"v":80.92540355540802,"d":"81"},{"v":5.243966150390441,"d":"5.24"},{"v":0,"d":"0.00"},{"v":0.5243966150390441,"d":"0.52"},{"v":4.719569535351397,"d":"4.72"}]
[2030,5,{"v":386.74102345450115,"d":"387"},{"v":66.92200163819732,"d":"67"},{"v":4.336545706155187,"d":"4.34"},{"v":2.009988934802929,"d":"2.01"},{"v":0.5816391928380644,"d":"0.58"},{"v":1.7650174678622224,"d":"1.77"}]
[2031,6,{"v":319.8190218163038,"d":"320"},{"v":55.34176051647992,"d":"55"},{"v":3.5861460814678994,"d":"3.59"},{"v":1.6621787087603714,"d":"1.66"},{"v":0.480991843176882,"d":"0.48"},{"v":1.4595973166182497,"d":"1.46"}]
[2032,7,{"v":264.4772612998239,"d":"264"},{"v":45.7653743476092,"d":"46"},{"v":2.965596257725077,"d":"2.97"},{"v":1.3745538654555733,"d":"1.37"},{"v":0.3977605980673759,"d":"0.40"},{"v":1.2070273328566834,"d":"1.21"}]
[2033,8,{"v":218.7118869522147,"d":"219"},{"v":37.84609433509267,"d":"38"},{"v":2.4524269129140057,"d":"2.45"},{"v":1.1366998741356418,"d":"1.14"},{"v":0.328931759694591,"d":"0.33"},{"v":0.9981622778251295,"d":"1.00"}]
[2034,9,{"v":180.86579261712205,"d":"181"},{"v":31.297173394487032,"d":"31"},{"v":2.02805683596276,"d":"2.03"},{"v":0.9400043434687394,"d":"0.94"},{"v":0.27201312312350523,"d":"0.27"},{"v":0.8254394128052029,"d":"0.83"}]
[2035,10,{"v":149.56861922263502,"d":"150"},{"v":25.881483405180234,"d":"26"},{"v":1.6771201246556795,"d":"1.68"},{"v":1.1660177666668612,"d":"1.17"},{"v":0.12777558949720458,"d":"0.13"},{"v":0.39498694615828245,"d":"0.39"}]
[2036,11,{"v":123.68713581745479,"d":"124"},{"v":21.40292910191735,"d":"21"},{"v":1.3869098058042446,"d":"1.39"},{"v":0.9642490424854011,"d":"0.96"},{"v":0.10566519082971088,"d":"0.11"},{"v":0.3266380629139866,"d":"0.33"}]
[2037,12,{"v":102.28420671553744,"d":"102"},{"v":17.699347713972756,"d":"18"},{"v":1.1469177318654347,"d":"1.15"},{"v":0.7973945530794435,"d":"0.80"},{"v":0.08738079469649779,"d":"0.09"},{"v":0.2701163296202878,"d":"0.27"}]
[2038,13,{"v":84.58485900156468,"d":"85"},{"v":14.63663725690934,"d":"15"},{"v":0.9484540942477254,"d":"0.95"},{"v":0.6594127090257311,"d":"0.66"},{"v":0.07226034630549857,"d":"0.07"},{"v":0.22337516600675303,"d":"0.22"}]
[2039,14,{"v":69.94822174465534,"d":"70"},{"v":12.103900869816899,"d":"12"},{"v":0.7843327763641351,"d":"0.78"},{"v":0.545307362767165,"d":"0.55"},{"v":0.05975635339924254,"d":"0.06"},{"v":0.1847221338253993,"d":"0.18"}]
[2040,15,{"v":57.844320874838445,"d":"58"},{"v":10.009431380640091,"d":"10"},{"v":0.648611153465478,"d":"0.65"},{"v":0.496041594891561,"d":"0.50"},{"v":0.038142389643479255,"d":"0.04"},{"v":0.11938758487935337,"d":"0.12"}]
[2041,16,{"v":47.83488949419835,"d":"48"},{"v":8.277390705799643,"d":"8"},{"v":0.5363749177358169,"d":"0.54"},{"v":0.4102061277114094,"d":"0.41"},{"v":0.03154219750610188,"d":"0.03"},{"v":0.09872865379541973,"d":"0.10"}]
[2042,17,{"v":39.5574987883987,"d":"40"},{"v":6.845063849378908,"d":"7"},{"v":0.4435601374397533,"d":"0.44"},{"v":0.3392237041104873,"d":"0.34"},{"v":0.026084108332316502,"d":"0.03"},{"v":0.08164456203805437,"d":"0.08"}]
[2043,18,{"v":32.71243493901979,"d":"33"},{"v":5.6605880726694,"d":"6"},{"v":0.36680610710897715,"d":"0.37"},{"v":0.280524140564268,"d":"0.28"},{"v":0.02157049163617729,"d":"0.02"},{"v":0.06751671631417457,"d":"0.07"}]
[2044,19,{"v":27.051846866350395,"d":"27"},{"v":4.681075010184813,"d":"5"},{"v":0.3033336606599759,"d":"0.30"},{"v":0.2319820003312331,"d":"0.23"},{"v":0.017837915082185705,"d":"0.02"},{"v":0.05583356524986944,"d":"0.06"}]
[2045,20,{"v":22.370771856165582,"d":"22"},{"v":3.871057736346349,"d":"4"},{"v":0.2508445413152435,"d":"0.25"},{"v":0.19183963408436533,"d":"0.19"},{"v":0.014751226807719536,"d":"0.01"},{"v":0.04617207676400226,"d":"0.05"}]
[2046,21,{"v":18.499714119819235,"d":"18"},{"v":3.2012065530937295,"d":"3"},{"v":0.2074381846404737,"d":"0.21"},{"v":0.17306567744554724,"d":"0.17"},{"v":0.008593126798731615,"d":"0.01"},{"v":0.027510037170650314,"d":"0.03"}]
[2047,22,{"v":15.298507566725505,"d":"15"},{"v":2.6472669987202067,"d":"3"},{"v":0.1715429015170694,"d":"0.17"},{"v":0.14311824273569101,"d":"0.14"},{"v":7.1061646953445995E-3,"d":"0.01"},{"v":0.0227496765133907,"d":"0.02"}]
[2048,23,{"v":12.651240568005298,"d":"13"},{"v":2.189181624578506,"d":"2"},{"v":0.1418589692726872,"d":"0.14"},{"v":0.11835293806420295,"d":"0.12"},{"v":0.005876507802121064,"d":"0.01"},{"v":0.018813052787005225,"d":"0.02"}]
[2049,24,{"v":10.462058943426792,"d":"10"},{"v":1.810363740306164,"d":"2"},{"v":0.11731157037183945,"d":"0.12"},{"v":0.09787304316122566,"d":"0.10"},{"v":0.004859631802653447,"d":"0.00"},{"v":0.015557625839572597,"d":"0.02"}]
[2050,25,{"v":8.651695203120628,"d":"9"},{"v":1.4970968308060515,"d":"1"},{"v":0.09701187463623215,"d":"0.10"},{"v":0.0809370070090085,"d":"0.08"},{"v":0.004018716906805914,"d":"0.00"},{"v":0.012865520790507831,"d":"0.01"}]
[2051,26,{"v":7.1545983723145765,"d":"7"},{"v":1.2380378986327247,"d":"1"},{"v":0.08022485583140057,"d":"0.08"},{"v":0.0669315972201375,"d":"0.07"},{"v":3.3233146528157675E-3,"d":"0.00"},{"v":0.010639259930648681,"d":"0.01"}]
[2052,27,{"v":5.916560473681852,"d":"6"},{"v":1.0238067484423783,"d":"1"},{"v":0.06634267729906612,"d":"0.07"},{"v":0.05534969567061087,"d":"0.06"},{"v":2.748245407113813E-3,"d":"0.00"},{"v":0.00879823317804755,"d":"0.01"}]
[2053,28,{"v":4.892753725239473,"d":"5"},{"v":0.8466463420172788,"d":"1"},{"v":0.05486268296271968,"d":"0.05"},{"v":0.045771936395797026,"d":"0.05"},{"v":0.002272686641730663,"d":"0.00"},{"v":0.007275779289149959,"d":"0.01"}]
[2054,29,{"v":4.046107383222194,"d":"4"},{"v":0.7001419257509245,"d":"1"},{"v":0.045369196788659916,"d":"0.05"},{"v":0.03785152088077897,"d":"0.04"},{"v":1.8794189769702364E-3,"d":"0.00"},{"v":6.0167721397185025E-3,"d":"0.01"}]
[2055,30,{"v":3.3459654574712694,"d":"3"},{"v":0.5789887605564225,"d":"1"},{"v":0.037518471684056184,"d":"0.04"},{"v":0.03130166092600808,"d":"0.03"},{"v":1.5542026895120267E-3,"d":"0.00"},{"v":0.004975624677796163,"d":"0.00"}]
[]
[]
[{"$f":"_xlfn.CONCAT(\"Food Waste Addition during \",Calculator!A11)","v":"Food Waste Addition during Year 2 / 2026"}]
["Year","Year Since Placement","Food Waste in Landfill (short tons, start of year)","Food Waste Decayed (short tons)","Methane Generated (MT CH4)","Methane Captured (MT CH4)","Methane Oxidized (MT CH4)","Methane Released (MT CH4)"]
[{"$f":"Calculator!$B8","v":2025}]
[{"$f":"A139+1","v":2026},0,{"$f":"Calculator!B11","v":1000},{"$f":"C140*(1-EXP(-$B$21))","v":{"v":173.0408660566377,"d":"173"}},{"$f":"D140*$B$20","v":{"v":11.213048120470125,"d":"11.21"}},{"$f":"E140*_xlfn.XLOOKUP(B140,$A$32:$A$62,$B$32:$B$62)*$B$22","v":{"v":0,"d":"0.00"}},{"$f":"(E140-F140)*_xlfn.XLOOKUP(B140,$A$32:$A$62,$D$32:$D$62)","v":{"v":1.1213048120470126,"d":"1.12"}},{"$f":"E140-F140*_xlfn.XLOOKUP(B140,$A$32:$A$62,$C$32:$C$62)-G140","v":{"v":10.091743308423112,"d":"10.09"}}]
[{"$f":"A140+1","v":2027},1,{"$f":"C140-D140","v":{"v":826.9591339433623,"d":"827"}},{"v":143.09772473100648,"d":"143"},{"$f":"D141*$B$20","v":{"v":9.272732562569221,"d":"9.27"}},{"v":0,"d":"0.00"},{"v":0.9272732562569221,"d":"0.93"},{"v":8.345459306312298,"d":"8.35"}]
[{"$f":"A141+1","v":2028},2,{"v":683.8614092123559,"d":"684"},{"v":118.33597051281878,"d":"118"},{"v":7.668170889230658,"d":"7.67"},{"v":0,"d":"0.00"},{"v":0.7668170889230659,"d":"0.77"},{"v":6.901353800307592,"d":"6.90"}]
[{"$f":"A142+1","v":2029},3,{"v":565.5254386995371,"d":"566"},{"v":97.85901168962788,"d":"98"},{"v":6.341263957487888,"d":"6.34"},{"v":0,"d":"0.00"},{"v":0.6341263957487888,"d":"0.63"},{"v":5.707137561739099,"d":"5.71"}]
[{"$f":"A143+1","v":2030},4,{"v":467.66642700990917,"d":"468"},{"v":80.92540355540802,"d":"81"},{"v":5.243966150390441,"d":"5.24"},{"v":0,"d":"0.00"},{"v":0.5243966150390441,"d":"0.52"},{"v":4.719569535351397,"d":"4.72"}]
[{"$f":"A144+1","v":2031},5,{"v":386.74102345450115,"d":"387"},{"v":66.92200163819732,"d":"67"},{"v":4.336545706155187,"d":"4.34"},{"v":2.009988934802929,"d":"2.01"},{"v":0.5816391928380644,"d":"0.58"},{"v":1.7650174678622224,"d":"1.77"}]
[{"$f":"A145+1","v":2032},6,{"v":319.8190218163038,"d":"320"},{"v":55.34176051647992,"d":"55"},{"v":3.5861460814678994,"d":"3.59"},{"v":1.6621787087603714,"d":"1.66"},{"v":0.480991843176882,"d":"0.48"},{"v":1.4595973166182497,"d":"1.46"}]
[{"$f":"A146+1","v":2033},7,{"v":264.4772612998239,"d":"264"},{"v":45.7653743476092,"d":"46"},{"v":2.965596257725077,"d":"2.97"},{"v":1.3745538654555733,"d":"1.37"},{"v":0.3977605980673759,"d":"0.40"},{"v":1.2070273328566834,"d":"1.21"}]
[{"$f":"A147+1","v":2034},8,{"v":218.7118869522147,"d":"219"},{"v":37.84609433509267,"d":"38"},{"v":2.4524269129140057,"d":"2.45"},{"v":1.1366998741356418,"d":"1.14"},{"v":0.328931759694591,"d":"0.33"},{"v":0.9981622778251295,"d":"1.00"}]
[{"$f":"A148+1","v":2035},9,{"v":180.86579261712205,"d":"181"},{"v":31.297173394487032,"d":"31"},{"v":2.02805683596276,"d":"2.03"},{"v":0.9400043434687394,"d":"0.94"},{"v":0.27201312312350523,"d":"0.27"},{"v":0.8254394128052029,"d":"0.83"}]
[{"$f":"A149+1","v":2036},10,{"v":149.56861922263502,"d":"150"},{"v":25.881483405180234,"d":"26"},{"v":1.6771201246556795,"d":"1.68"},{"v":1.1660177666668612,"d":"1.17"},{"v":0.12777558949720458,"d":"0.13"},{"v":0.39498694615828245,"d":"0.39"}]
[{"$f":"A150+1","v":2037},11,{"v":123.68713581745479,"d":"124"},{"v":21.40292910191735,"d":"21"},{"v":1.3869098058042446,"d":"1.39"},{"v":0.9642490424854011,"d":"0.96"},{"v":0.10566519082971088,"d":"0.11"},{"v":0.3266380629139866,"d":"0.33"}]
[{"$f":"A151+1","v":2038},12,{"v":102.28420671553744,"d":"102"},{"v":17.699347713972756,"d":"18"},{"v":1.1469177318654347,"d":"1.15"},{"v":0.7973945530794435,"d":"0.80"},{"v":0.08738079469649779,"d":"0.09"},{"v":0.2701163296202878,"d":"0.27"}]
[{"$f":"A152+1","v":2039},13,{"v":84.58485900156468,"d":"85"},{"v":14.63663725690934,"d":"15"},{"v":0.9484540942477254,"d":"0.95"},{"v":0.6594127090257311,"d":"0.66"},{"v":0.07226034630549857,"d":"0.07"},{"v":0.22337516600675303,"d":"0.22"}]
[{"$f":"A153+1","v":2040},14,{"v":69.94822174465534,"d":"70"},{"v":12.103900869816899,"d":"12"},{"v":0.7843327763641351,"d":"0.78"},{"v":0.545307362767165,"d":"0.55"},{"v":0.05975635339924254,"d":"0.06"},{"v":0.1847221338253993,"d":"0.18"}]
[{"$f":"A154+1","v":2041},15,{"v":57.844320874838445,"d":"58"},{"v":10.009431380640091,"d":"10"},{"v":0.648611153465478,"d":"0.65"},{"v":0.496041594891561,"d":"0.50"},{"v":0.038142389643479255,"d":"0.04"},{"v":0.11938758487935337,"d":"0.12"}]
[{"$f":"A155+1","v":2042},16,{"v":47.83488949419835,"d":"48"},{"v":8.277390705799643,"d":"8"},{"v":0.5363749177358169,"d":"0.54"},{"v":0.4102061277114094,"d":"0.41"},{"v":0.03154219750610188,"d":"0.03"},{"v":0.09872865379541973,"d":"0.10"}]
[{"$f":"A156+1","v":2043},17,{"v":39.5574987883987,"d":"40"},{"v":6.845063849378908,"d":"7"},{"v":0.4435601374397533,"d":"0.44"},{"v":0.3392237041104873,"d":"0.34"},{"v":0.026084108332316502,"d":"0.03"},{"v":0.08164456203805437,"d":"0.08"}]
[{"$f":"A157+1","v":2044},18,{"v":32.71243493901979,"d":"33"},{"v":5.6605880726694,"d":"6"},{"v":0.36680610710897715,"d":"0.37"},{"v":0.280524140564268,"d":"0.28"},{"v":0.02157049163617729,"d":"0.02"},{"v":0.06751671631417457,"d":"0.07"}]
[{"$f":"A158+1","v":2045},19,{"v":27.051846866350395,"d":"27"},{"v":4.681075010184813,"d":"5"},{"v":0.3033336606599759,"d":"0.30"},{"v":0.2319820003312331,"d":"0.23"},{"v":0.017837915082185705,"d":"0.02"},{"v":0.05583356524986944,"d":"0.06"}]
[{"$f":"A159+1","v":2046},20,{"v":22.370771856165582,"d":"22"},{"v":3.871057736346349,"d":"4"},{"v":0.2508445413152435,"d":"0.25"},{"v":0.19183963408436533,"d":"0.19"},{"v":0.014751226807719536,"d":"0.01"},{"v":0.04617207676400226,"d":"0.05"}]
[{"$f":"A160+1","v":2047},21,{"v":18.499714119819235,"d":"18"},{"v":3.2012065530937295,"d":"3"},{"v":0.2074381846404737,"d":"0.21"},{"v":0.17306567744554724,"d":"0.17"},{"v":0.008593126798731615,"d":"0.01"},{"v":0.027510037170650314,"d":"0.03"}]
[{"$f":"A161+1","v":2048},22,{"v":15.298507566725505,"d":"15"},{"v":2.6472669987202067,"d":"3"},{"v":0.1715429015170694,"d":"0.17"},{"v":0.14311824273569101,"d":"0.14"},{"v":7.1061646953445995E-3,"d":"0.01"},{"v":0.0227496765133907,"d":"0.02"}]
[{"$f":"A162+1","v":2049},23,{"v":12.651240568005298,"d":"13"},{"v":2.189181624578506,"d":"2"},{"v":0.1418589692726872,"d":"0.14"},{"v":0.11835293806420295,"d":"0.12"},{"v":0.005876507802121064,"d":"0.01"},{"v":0.018813052787005225,"d":"0.02"}]
[{"$f":"A163+1","v":2050},24,{"v":10.462058943426792,"d":"10"},{"v":1.810363740306164,"d":"2"},{"v":0.11731157037183945,"d":"0.12"},{"v":0.09787304316122566,"d":"0.10"},{"v":0.004859631802653447,"d":"0.00"},{"v":0.015557625839572597,"d":"0.02"}]
[{"$f":"A164+1","v":2051},25,{"v":8.651695203120628,"d":"9"},{"v":1.4970968308060515,"d":"1"},{"v":0.09701187463623215,"d":"0.10"},{"v":0.0809370070090085,"d":"0.08"},{"v":0.004018716906805914,"d":"0.00"},{"v":0.012865520790507831,"d":"0.01"}]
[{"$f":"A165+1","v":2052},26,{"v":7.1545983723145765,"d":"7"},{"v":1.2380378986327247,"d":"1"},{"v":0.08022485583140057,"d":"0.08"},{"v":0.0669315972201375,"d":"0.07"},{"v":3.3233146528157675E-3,"d":"0.00"},{"v":0.010639259930648681,"d":"0.01"}]
[{"$f":"A166+1","v":2053},27,{"v":5.916560473681852,"d":"6"},{"v":1.0238067484423783,"d":"1"},{"v":0.06634267729906612,"d":"0.07"},{"v":0.05534969567061087,"d":"0.06"},{"v":2.748245407113813E-3,"d":"0.00"},{"v":0.00879823317804755,"d":"0.01"}]
[{"$f":"A167+1","v":2054},28,{"v":4.892753725239473,"d":"5"},{"v":0.8466463420172788,"d":"1"},{"v":0.05486268296271968,"d":"0.05"},{"v":0.045771936395797026,"d":"0.05"},{"v":0.002272686641730663,"d":"0.00"},{"v":0.007275779289149959,"d":"0.01"}]
[{"$f":"A168+1","v":2055},29,{"v":4.046107383222194,"d":"4"},{"v":0.7001419257509245,"d":"1"},{"v":0.045369196788659916,"d":"0.05"},{"v":0.03785152088077897,"d":"0.04"},{"v":1.8794189769702364E-3,"d":"0.00"},{"v":6.0167721397185025E-3,"d":"0.01"}]
[]
[]
[{"$f":"_xlfn.CONCAT(\"Food Waste Addition during \",Calculator!A12)","v":"Food Waste Addition during Year 3 / 2027"}]
["Year","Year Since Placement","Food Waste in Landfill (short tons, start of year)","Food Waste Decayed (short tons)","Methane Generated (MT CH4)","Methane Captured (MT CH4)","Methane Oxidized (MT CH4)","Methane Released (MT CH4)"]
[{"$f":"Calculator!$B8","v":2025}]
[{"$f":"A174+1","v":2026}]
[{"$f":"A175+1","v":2027},0,{"$f":"Calculator!B12","v":1000},{"$f":"C176*(1-EXP(-$B$21))","v":{"v":173.0408660566377,"d":"173"}},{"$f":"D176*$B$20","v":{"v":11.213048120470125,"d":"11.21"}},{"$f":"E176*_xlfn.XLOOKUP(B176,$A$32:$A$62,$B$32:$B$62)*$B$22","v":{"v":0,"d":"0.00"}},{"$f":"(E176-F176)*_xlfn.XLOOKUP(B176,$A$32:$A$62,$D$32:$D$62)","v":{"v":1.1213048120470126,"d":"1.12"}},{"$f":"E176-F176*_xlfn.XLOOKUP(B176,$A$32:$A$62,$C$32:$C$62)-G176","v":{"v":10.091743308423112,"d":"10.09"}}]
[{"$f":"A176+1","v":2028},1,{"$f":"C176-D176","v":{"v":826.9591339433623,"d":"827"}},{"v":143.09772473100648,"d":"143"},{"$f":"D177*$B$20","v":{"v":9.272732562569221,"d":"9.27"}},{"v":0,"d":"0.00"},{"v":0.9272732562569221,"d":"0.93"},{"v":8.345459306312298,"d":"8.35"}]
[{"$f":"A177+1","v":2029},2,{"v":683.8614092123559,"d":"684"},{"v":118.33597051281878,"d":"118"},{"v":7.668170889230658,"d":"7.67"},{"v":0,"d":"0.00"},{"v":0.7668170889230659,"d":"0.77"},{"v":6.901353800307592,"d":"6.90"}]
[{"$f":"A178+1","v":2030},3,{"v":565.5254386995371,"d":"566"},{"v":97.85901168962788,"d":"98"},{"v":6.341263957487888,"d":"6.34"},{"v":0,"d":"0.00"},{"v":0.6341263957487888,"d":"0.63"},{"v":5.707137561739099,"d":"5.71"}]
[{"$f":"A179+1","v":2031},4,{"v":467.66642700990917,"d":"468"},{"v":80.92540355540802,"d":"81"},{"v":5.243966150390441,"d":"5.24"},{"v":0,"d":"0.00"},{"v":0.5243966150390441,"d":"0.52"},{"v":4.719569535351397,"d":"4.72"}]
[{"$f":"A180+1","v":2032},5,{"v":386.74102345450115,"d":"387"},{"v":66.92200163819732,"d":"67"},{"v":4.336545706155187,"d":"4.34"},{"v":2.009988934802929,"d":"2.01"},{"v":0.5816391928380644,"d":"0.58"},{"v":1.7650174678622224,"d":"1.77"}]
[{"$f":"A181+1","v":2033},6,{"v":319.8190218163038,"d":"320"},{"v":55.34176051647992,"d":"55"},{"v":3.5861460814678994,"d":"3.59"},{"v":1.6621787087603714,"d":"1.66"},{"v":0.480991843176882,"d":"0.48"},{"v":1.4595973166182497,"d":"1.46"}]
[{"$f":"A182+1","v":2034},7,{"v":264.4772612998239,"d":"264"},{"v":45.7653743476092,"d":"46"},{"v":2.965596257725077,"d":"2.97"},{"v":1.3745538654555733,"d":"1.37"},{"v":0.3977605980673759,"d":"0.40"},{"v":1.2070273328566834,"d":"1.21"}]
[{"$f":"A183+1","v":2035},8,{"v":218.7118869522147,"d":"219"},{"v":37.84609433509267,"d":"38"},{"v":2.4524269129140057,"d":"2.45"},{"v":1.1366998741356418,"d":"1.14"},{"v":0.328931759694591,"d":"0.33"},{"v":0.9981622778251295,"d":"1.00"}]
[{"$f":"A184+1","v":2036},9,{"v":180.86579261712205,"d":"181"},{"v":31.297173394487032,"d":"31"},{"v":2.02805683596276,"d":"2.03"},{"v":0.9400043434687394,"d":"0.94"},{"v":0.27201312312350523,"d":"0.27"},{"v":0.8254394128052029,"d":"0.83"}]
[{"$f":"A185+1","v":2037},10,{"v":149.56861922263502,"d":"150"},{"v":25.881483405180234,"d":"26"},{"v":1.6771201246556795,"d":"1.68"},{"v":1.1660177666668612,"d":"1.17"},{"v":0.12777558949720458,"d":"0.13"},{"v":0.39498694615828245,"d":"0.39"}]
[{"$f":"A186+1","v":2038},11,{"v":123.68713581745479,"d":"124"},{"v":21.40292910191735,"d":"21"},{"v":1.3869098058042446,"d":"1.39"},{"v":0.9642490424854011,"d":"0.96"},{"v":0.10566519082971088,"d":"0.11"},{"v":0.3266380629139866,"d":"0.33"}]
[{"$f":"A187+1","v":2039},12,{"v":102.28420671553744,"d":"102"},{"v":17.699347713972756,"d":"18"},{"v":1.1469177318654347,"d":"1.15"},{"v":0.7973945530794435,"d":"0.80"},{"v":0.08738079469649779,"d":"0.09"},{"v":0.2701163296202878,"d":"0.27"}]
[{"$f":"A188+1","v":2040},13,{"v":84.58485900156468,"d":"85"},{"v":14.63663725690934,"d":"15"},{"v":0.9484540942477254,"d":"0.95"},{"v":0.6594127090257311,"d":"0.66"},{"v":0.07226034630549857,"d":"0.07"},{"v":0.22337516600675303,"d":"0.22"}]
[{"$f":"A189+1","v":2041},14,{"v":69.94822174465534,"d":"70"},{"v":12.103900869816899,"d":"12"},{"v":0.7843327763641351,"d":"0.78"},{"v":0.545307362767165,"d":"0.55"},{"v":0.05975635339924254,"d":"0.06"},{"v":0.1847221338253993,"d":"0.18"}]
[{"$f":"A190+1","v":2042},15,{"v":57.844320874838445,"d":"58"},{"v":10.009431380640091,"d":"10"},{"v":0.648611153465478,"d":"0.65"},{"v":0.496041594891561,"d":"0.50"},{"v":0.038142389643479255,"d":"0.04"},{"v":0.11938758487935337,"d":"0.12"}]
[{"$f":"A191+1","v":2043},16,{"v":47.83488949419835,"d":"48"},{"v":8.277390705799643,"d":"8"},{"v":0.5363749177358169,"d":"0.54"},{"v":0.4102061277114094,"d":"0.41"},{"v":0.03154219750610188,"d":"0.03"},{"v":0.09872865379541973,"d":"0.10"}]
[{"$f":"A192+1","v":2044},17,{"v":39.5574987883987,"d":"40"},{"v":6.845063849378908,"d":"7"},{"v":0.4435601374397533,"d":"0.44"},{"v":0.3392237041104873,"d":"0.34"},{"v":0.026084108332316502,"d":"0.03"},{"v":0.08164456203805437,"d":"0.08"}]
[{"$f":"A193+1","v":2045},18,{"v":32.71243493901979,"d":"33"},{"v":5.6605880726694,"d":"6"},{"v":0.36680610710897715,"d":"0.37"},{"v":0.280524140564268,"d":"0.28"},{"v":0.02157049163617729,"d":"0.02"},{"v":0.06751671631417457,"d":"0.07"}]
[{"$f":"A194+1","v":2046},19,{"v":27.051846866350395,"d":"27"},{"v":4.681075010184813,"d":"5"},{"v":0.3033336606599759,"d":"0.30"},{"v":0.2319820003312331,"d":"0.23"},{"v":0.017837915082185705,"d":"0.02"},{"v":0.05583356524986944,"d":"0.06"}]
[{"$f":"A195+1","v":2047},20,{"v":22.370771856165582,"d":"22"},{"v":3.871057736346349,"d":"4"},{"v":0.2508445413152435,"d":"0.25"},{"v":0.19183963408436533,"d":"0.19"},{"v":0.014751226807719536,"d":"0.01"},{"v":0.04617207676400226,"d":"0.05"}]
[{"$f":"A196+1","v":2048},21,{"v":18.499714119819235,"d":"18"},{"v":3.2012065530937295,"d":"3"},{"v":0.2074381846404737,"d":"0.21"},{"v":0.17306567744554724,"d":"0.17"},{"v":0.008593126798731615,"d":"0.01"},{"v":0.027510037170650314,"d":"0.03"}]
[{"$f":"A197+1","v":2049},22,{"v":15.298507566725505,"d":"15"},{"v":2.6472669987202067,"d":"3"},{"v":0.1715429015170694,"d":"0.17"},{"v":0.14311824273569101,"d":"0.14"},{"v":7.1061646953445995E-3,"d":"0.01"},{"v":0.0227496765133907,"d":"0.02"}]
[{"$f":"A198+1","v":2050},23,{"v":12.651240568005298,"d":"13"},{"v":2.189181624578506,"d":"2"},{"v":0.1418589692726872,"d":"0.14"},{"v":0.11835293806420295,"d":"0.12"},{"v":0.005876507802121064,"d":"0.01"},{"v":0.018813052787005225,"d":"0.02"}]
[{"$f":"A199+1","v":2051},24,{"v":10.462058943426792,"d":"10"},{"v":1.810363740306164,"d":"2"},{"v":0.11731157037183945,"d":"0.12"},{"v":0.09787304316122566,"d":"0.10"},{"v":0.004859631802653447,"d":"0.00"},{"v":0.015557625839572597,"d":"0.02"}]
[{"$f":"A200+1","v":2052},25,{"v":8.651695203120628,"d":"9"},{"v":1.4970968308060515,"d":"1"},{"v":0.09701187463623215,"d":"0.10"},{"v":0.0809370070090085,"d":"0.08"},{"v":0.004018716906805914,"d":"0.00"},{"v":0.012865520790507831,"d":"0.01"}]
[{"$f":"A201+1","v":2053},26,{"v":7.1545983723145765,"d":"7"},{"v":1.2380378986327247,"d":"1"},{"v":0.08022485583140057,"d":"0.08"},{"v":0.0669315972201375,"d":"0.07"},{"v":3.3233146528157675E-3,"d":"0.00"},{"v":0.010639259930648681,"d":"0.01"}]
[{"$f":"A202+1","v":2054},27,{"v":5.916560473681852,"d":"6"},{"v":1.0238067484423783,"d":"1"},{"v":0.06634267729906612,"d":"0.07"},{"v":0.05534969567061087,"d":"0.06"},{"v":2.748245407113813E-3,"d":"0.00"},{"v":0.00879823317804755,"d":"0.01"}]
[{"$f":"A203+1","v":2055},28,{"v":4.892753725239473,"d":"5"},{"v":0.8466463420172788,"d":"1"},{"v":0.05486268296271968,"d":"0.05"},{"v":0.045771936395797026,"d":"0.05"},{"v":0.002272686641730663,"d":"0.00"},{"v":0.007275779289149959,"d":"0.01"}]
[]
[]
[]
[{"$f":"_xlfn.CONCAT(\"Food Waste Addition during \",Calculator!A13)","v":"Food Waste Addition during Year 4 / 2028"}]
["Year","Year Since Placement","Food Waste in Landfill (short tons, start of year)","Food Waste Decayed (short tons)","Methane Generated (MT CH4)","Methane Captured (MT CH4)","Methane Oxidized (MT CH4)","Methane Released (MT CH4)"]
[{"$f":"Calculator!$B8","v":2025}]
[{"$f":"A210+1","v":2026}]
[{"$f":"A211+1","v":2027}]
[{"$f":"A212+1","v":2028},0,{"$f":"Calculator!B13","v":1000},{"$f":"C213*(1-EXP(-$B$21))","v":{"v":173.0408660566377,"d":"173"}},{"$f":"D213*$B$20","v":{"v":11.213048120470125,"d":"11.21"}},{"$f":"E213*_xlfn.XLOOKUP(B213,$A$32:$A$62,$B$32:$B$62)*$B$22","v":{"v":0,"d":"0.00"}},{"$f":"(E213-F213)*_xlfn.XLOOKUP(B213,$A$32:$A$62,$D$32:$D$62)","v":{"v":1.1213048120470126,"d":"1.12"}},{"$f":"E213-F213*_xlfn.XLOOKUP(B213,$A$32:$A$62,$C$32:$C$62)-G213","v":{"v":10.091743308423112,"d":"10.09"}}]
[{"$f":"A213+1","v":2029},1,{"$f":"C213-D213","v":{"v":826.9591339433623,"d":"827"}},{"v":143.09772473100648,"d":"143"},{"$f":"D214*$B$20","v":{"v":9.272732562569221,"d":"9.27"}},{"v":0,"d":"0.00"},{"v":0.9272732562569221,"d":"0.93"},{"v":8.345459306312298,"d":"8.35"}]
[{"$f":"A214+1","v":2030},2,{"v":683.8614092123559,"d":"684"},{"v":118.33597051281878,"d":"118"},{"v":7.668170889230658,"d":"7.67"},{"v":0,"d":"0.00"},{"v":0.7668170889230659,"d":"0.77"},{"v":6.901353800307592,"d":"6.90"}]
[{"$f":"A215+1","v":2031},3,{"v":565.5254386995371,"d":"566"},{"v":97.85901168962788,"d":"98"},{"v":6.341263957487888,"d":"6.34"},{"v":0,"d":"0.00"},{"v":0.6341263957487888,"d":"0.63"},{"v":5.707137561739099,"d":"5.71"}]
[{"$f":"A216+1","v":2032},4,{"v":467.66642700990917,"d":"468"},{"v":80.92540355540802,"d":"81"},{"v":5.243966150390441,"d":"5.24"},{"v":0,"d":"0.00"},{"v":0.5243966150390441,"d":"0.52"},{"v":4.719569535351397,"d":"4.72"}]
[{"$f":"A217+1","v":2033},5,{"v":386.74102345450115,"d":"387"},{"v":66.92200163819732,"d":"67"},{"v":4.336545706155187,"d":"4.34"},{"v":2.009988934802929,"d":"2.01"},{"v":0.5816391928380644,"d":"0.58"},{"v":1.7650174678622224,"d":"1.77"}]
[{"$f":"A218+1","v":2034},6,{"v":319.8190218163038,"d":"320"},{"v":55.34176051647992,"d":"55"},{"v":3.5861460814678994,"d":"3.59"},{"v":1.6621787087603714,"d":"1.66"},{"v":0.480991843176882,"d":"0.48"},{"v":1.4595973166182497,"d":"1.46"}]
[{"$f":"A219+1","v":2035},7,{"v":264.4772612998239,"d":"264"},{"v":45.7653743476092,"d":"46"},{"v":2.965596257725077,"d":"2.97"},{"v":1.3745538654555733,"d":"1.37"},{"v":0.3977605980673759,"d":"0.40"},{"v":1.2070273328566834,"d":"1.21"}]
[{"$f":"A220+1","v":2036},8,{"v":218.7118869522147,"d":"219"},{"v":37.84609433509267,"d":"38"},{"v":2.4524269129140057,"d":"2.45"},{"v":1.1366998741356418,"d":"1.14"},{"v":0.328931759694591,"d":"0.33"},{"v":0.9981622778251295,"d":"1.00"}]
[{"$f":"A221+1","v":2037},9,{"v":180.86579261712205,"d":"181"},{"v":31.297173394487032,"d":"31"},{"v":2.02805683596276,"d":"2.03"},{"v":0.9400043434687394,"d":"0.94"},{"v":0.27201312312350523,"d":"0.27"},{"v":0.8254394128052029,"d":"0.83"}]
[{"$f":"A222+1","v":2038},10,{"v":149.56861922263502,"d":"150"},{"v":25.881483405180234,"d":"26"},{"v":1.6771201246556795,"d":"1.68"},{"v":1.1660177666668612,"d":"1.17"},{"v":0.12777558949720458,"d":"0.13"},{"v":0.39498694615828245,"d":"0.39"}]
[{"$f":"A223+1","v":2039},11,{"v":123.68713581745479,"d":"124"},{"v":21.40292910191735,"d":"21"},{"v":1.3869098058042446,"d":"1.39"},{"v":0.9642490424854011,"d":"0.96"},{"v":0.10566519082971088,"d":"0.11"},{"v":0.3266380629139866,"d":"0.33"}]
[{"$f":"A224+1","v":2040},12,{"v":102.28420671553744,"d":"102"},{"v":17.699347713972756,"d":"18"},{"v":1.1469177318654347,"d":"1.15"},{"v":0.7973945530794435,"d":"0.80"},{"v":0.08738079469649779,"d":"0.09"},{"v":0.2701163296202878,"d":"0.27"}]
[{"$f":"A225+1","v":2041},13,{"v":84.58485900156468,"d":"85"},{"v":14.63663725690934,"d":"15"},{"v":0.9484540942477254,"d":"0.95"},{"v":0.6594127090257311,"d":"0.66"},{"v":0.07226034630549857,"d":"0.07"},{"v":0.22337516600675303,"d":"0.22"}]
[{"$f":"A226+1","v":2042},14,{"v":69.94822174465534,"d":"70"},{"v":12.103900869816899,"d":"12"},{"v":0.7843327763641351,"d":"0.78"},{"v":0.545307362767165,"d":"0.55"},{"v":0.05975635339924254,"d":"0.06"},{"v":0.1847221338253993,"d":"0.18"}]
[{"$f":"A227+1","v":2043},15,{"v":57.844320874838445,"d":"58"},{"v":10.009431380640091,"d":"10"},{"v":0.648611153465478,"d":"0.65"},{"v":0.496041594891561,"d":"0.50"},{"v":0.038142389643479255,"d":"0.04"},{"v":0.11938758487935337,"d":"0.12"}]
[{"$f":"A228+1","v":2044},16,{"v":47.83488949419835,"d":"48"},{"v":8.277390705799643,"d":"8"},{"v":0.5363749177358169,"d":"0.54"},{"v":0.4102061277114094,"d":"0.41"},{"v":0.03154219750610188,"d":"0.03"},{"v":0.09872865379541973,"d":"0.10"}]
[{"$f":"A229+1","v":2045},17,{"v":39.5574987883987,"d":"40"},{"v":6.845063849378908,"d":"7"},{"v":0.4435601374397533,"d":"0.44"},{"v":0.3392237041104873,"d":"0.34"},{"v":0.026084108332316502,"d":"0.03"},{"v":0.08164456203805437,"d":"0.08"}]
[{"$f":"A230+1","v":2046},18,{"v":32.71243493901979,"d":"33"},{"v":5.6605880726694,"d":"6"},{"v":0.36680610710897715,"d":"0.37"},{"v":0.280524140564268,"d":"0.28"},{"v":0.02157049163617729,"d":"0.02"},{"v":0.06751671631417457,"d":"0.07"}]
[{"$f":"A231+1","v":2047},19,{"v":27.051846866350395,"d":"27"},{"v":4.681075010184813,"d":"5"},{"v":0.3033336606599759,"d":"0.30"},{"v":0.2319820003312331,"d":"0.23"},{"v":0.017837915082185705,"d":"0.02"},{"v":0.05583356524986944,"d":"0.06"}]
[{"$f":"A232+1","v":2048},20,{"v":22.370771856165582,"d":"22"},{"v":3.871057736346349,"d":"4"},{"v":0.2508445413152435,"d":"0.25"},{"v":0.19183963408436533,"d":"0.19"},{"v":0.014751226807719536,"d":"0.01"},{"v":0.04617207676400226,"d":"0.05"}]
[{"$f":"A233+1","v":2049},21,{"v":18.499714119819235,"d":"18"},{"v":3.2012065530937295,"d":"3"},{"v":0.2074381846404737,"d":"0.21"},{"v":0.17306567744554724,"d":"0.17"},{"v":0.008593126798731615,"d":"0.01"},{"v":0.027510037170650314,"d":"0.03"}]
[{"$f":"A234+1","v":2050},22,{"v":15.298507566725505,"d":"15"},{"v":2.6472669987202067,"d":"3"},{"v":0.1715429015170694,"d":"0.17"},{"v":0.14311824273569101,"d":"0.14"},{"v":7.1061646953445995E-3,"d":"0.01"},{"v":0.0227496765133907,"d":"0.02"}]
[{"$f":"A235+1","v":2051},23,{"v":12.651240568005298,"d":"13"},{"v":2.189181624578506,"d":"2"},{"v":0.1418589692726872,"d":"0.14"},{"v":0.11835293806420295,"d":"0.12"},{"v":0.005876507802121064,"d":"0.01"},{"v":0.018813052787005225,"d":"0.02"}]
[{"$f":"A236+1","v":2052},24,{"v":10.462058943426792,"d":"10"},{"v":1.810363740306164,"d":"2"},{"v":0.11731157037183945,"d":"0.12"},{"v":0.09787304316122566,"d":"0.10"},{"v":0.004859631802653447,"d":"0.00"},{"v":0.015557625839572597,"d":"0.02"}]
[{"$f":"A237+1","v":2053},25,{"v":8.651695203120628,"d":"9"},{"v":1.4970968308060515,"d":"1"},{"v":0.09701187463623215,"d":"0.10"},{"v":0.0809370070090085,"d":"0.08"},{"v":0.004018716906805914,"d":"0.00"},{"v":0.012865520790507831,"d":"0.01"}]
[{"$f":"A238+1","v":2054},26,{"v":7.1545983723145765,"d":"7"},{"v":1.2380378986327247,"d":"1"},{"v":0.08022485583140057,"d":"0.08"},{"v":0.0669315972201375,"d":"0.07"},{"v":3.3233146528157675E-3,"d":"0.00"},{"v":0.010639259930648681,"d":"0.01"}]
[{"$f":"A239+1","v":2055},27,{"v":5.916560473681852,"d":"6"},{"v":1.0238067484423783,"d":"1"},{"v":0.06634267729906612,"d":"0.07"},{"v":0.05534969567061087,"d":"0.06"},{"v":2.748245407113813E-3,"d":"0.00"},{"v":0.00879823317804755,"d":"0.01"}]
[]
[]
[]
[{"$f":"_xlfn.CONCAT(\"Food Waste Addition during \",Calculator!A14)","v":"Food Waste Addition during Year 5 / 2029"}]
["Year","Year Since Placement","Food Waste in Landfill (short tons, start of year)","Food Waste Decayed (short tons)","Methane Generated (MT CH4)","Methane Captured (MT CH4)","Methane Oxidized (MT CH4)","Methane Released (MT CH4)"]
[{"$f":"Calculator!$B8","v":2025}]
[{"$f":"A246+1","v":2026}]
[{"$f":"A247+1","v":2027}]
[{"$f":"A248+1","v":2028}]
[{"$f":"A249+1","v":2029},0,{"$f":"Calculator!B14","v":1000},{"$f":"C250*(1-EXP(-$B$21))","v":{"v":173.0408660566377,"d":"173"}},{"$f":"D250*$B$20","v":{"v":11.213048120470125,"d":"11.21"}},{"$f":"E250*_xlfn.XLOOKUP(B250,$A$32:$A$62,$B$32:$B$62)*$B$22","v":{"v":0,"d":"0.00"}},{"$f":"(E250-F250)*_xlfn.XLOOKUP(B250,$A$32:$A$62,$D$32:$D$62)","v":{"v":1.1213048120470126,"d":"1.12"}},{"$f":"E250-F250*_xlfn.XLOOKUP(B250,$A$32:$A$62,$C$32:$C$62)-G250","v":{"v":10.091743308423112,"d":"10.09"}}]
[{"$f":"A250+1","v":2030},1,{"$f":"C250-D250","v":{"v":826.9591339433623,"d":"827"}},{"v":143.09772473100648,"d":"143"},{"$f":"D251*$B$20","v":{"v":9.272732562569221,"d":"9.27"}},{"v":0,"d":"0.00"},{"v":0.9272732562569221,"d":"0.93"},{"v":8.345459306312298,"d":"8.35"}]
[{"$f":"A251+1","v":2031},2,{"v":683.8614092123559,"d":"684"},{"v":118.33597051281878,"d":"118"},{"v":7.668170889230658,"d":"7.67"},{"v":0,"d":"0.00"},{"v":0.7668170889230659,"d":"0.77"},{"v":6.901353800307592,"d":"6.90"}]
[{"$f":"A252+1","v":2032},3,{"v":565.5254386995371,"d":"566"},{"v":97.85901168962788,"d":"98"},{"v":6.341263957487888,"d":"6.34"},{"v":0,"d":"0.00"},{"v":0.6341263957487888,"d":"0.63"},{"v":5.707137561739099,"d":"5.71"}]
[{"$f":"A253+1","v":2033},4,{"v":467.66642700990917,"d":"468"},{"v":80.92540355540802,"d":"81"},{"v":5.243966150390441,"d":"5.24"},{"v":0,"d":"0.00"},{"v":0.5243966150390441,"d":"0.52"},{"v":4.719569535351397,"d":"4.72"}]
[{"$f":"A254+1","v":2034},5,{"v":386.74102345450115,"d":"387"},{"v":66.92200163819732,"d":"67"},{"v":4.336545706155187,"d":"4.34"},{"v":2.009988934802929,"d":"2.01"},{"v":0.5816391928380644,"d":"0.58"},{"v":1.7650174678622224,"d":"1.77"}]
[{"$f":"A255+1","v":2035},6,{"v":319.8190218163038,"d":"320"},{"v":55.34176051647992,"d":"55"},{"v":3.5861460814678994,"d":"3.59"},{"v":1.6621787087603714,"d":"1.66"},{"v":0.480991843176882,"d":"0.48"},{"v":1.4595973166182497,"d":"1.46"}]
[{"$f":"A256+1","v":2036},7,{"v":264.4772612998239,"d":"264"},{"v":45.7653743476092,"d":"46"},{"v":2.965596257725077,"d":"2.97"},{"v":1.3745538654555733,"d":"1.37"},{"v":0.3977605980673759,"d":"0.40"},{"v":1.2070273328566834,"d":"1.21"}]
[{"$f":"A257+1","v":2037},8,{"v":218.7118869522147,"d":"219"},{"v":37.84609433509267,"d":"38"},{"v":2.4524269129140057,"d":"2.45"},{"v":1.1366998741356418,"d":"1.14"},{"v":0.328931759694591,"d":"0.33"},{"v":0.9981622778251295,"d":"1.00"}]
[{"$f":"A258+1","v":2038},9,{"v":180.86579261712205,"d":"181"},{"v":31.297173394487032,"d":"31"},{"v":2.02805683596276,"d":"2.03"},{"v":0.9400043434687394,"d":"0.94"},{"v":0.27201312312350523,"d":"0.27"},{"v":0.8254394128052029,"d":"0.83"}]
[{"$f":"A259+1","v":2039},10,{"v":149.56861922263502,"d":"150"},{"v":25.881483405180234,"d":"26"},{"v":1.6771201246556795,"d":"1.68"},{"v":1.1660177666668612,"d":"1.17"},{"v":0.12777558949720458,"d":"0.13"},{"v":0.39498694615828245,"d":"0.39"}]
[{"$f":"A260+1","v":2040},11,{"v":123.68713581745479,"d":"124"},{"v":21.40292910191735,"d":"21"},{"v":1.3869098058042446,"d":"1.39"},{"v":0.9642490424854011,"d":"0.96"},{"v":0.10566519082971088,"d":"0.11"},{"v":0.3266380629139866,"d":"0.33"}]
[{"$f":"A261+1","v":2041},12,{"v":102.28420671553744,"d":"102"},{"v":17.699347713972756,"d":"18"},{"v":1.1469177318654347,"d":"1.15"},{"v":0.7973945530794435,"d":"0.80"},{"v":0.08738079469649779,"d":"0.09"},{"v":0.2701163296202878,"d":"0.27"}]
[{"$f":"A262+1","v":2042},13,{"v":84.58485900156468,"d":"85"},{"v":14.63663725690934,"d":"15"},{"v":0.9484540942477254,"d":"0.95"},{"v":0.6594127090257311,"d":"0.66"},{"v":0.07226034630549857,"d":"0.07"},{"v":0.22337516600675303,"d":"0.22"}]
[{"$f":"A263+1","v":2043},14,{"v":69.94822174465534,"d":"70"},{"v":12.103900869816899,"d":"12"},{"v":0.7843327763641351,"d":"0.78"},{"v":0.545307362767165,"d":"0.55"},{"v":0.05975635339924254,"d":"0.06"},{"v":0.1847221338253993,"d":"0.18"}]
[{"$f":"A264+1","v":2044},15,{"v":57.844320874838445,"d":"58"},{"v":10.009431380640091,"d":"10"},{"v":0.648611153465478,"d":"0.65"},{"v":0.496041594891561,"d":"0.50"},{"v":0.038142389643479255,"d":"0.04"},{"v":0.11938758487935337,"d":"0.12"}]
[{"$f":"A265+1","v":2045},16,{"v":47.83488949419835,"d":"48"},{"v":8.277390705799643,"d":"8"},{"v":0.5363749177358169,"d":"0.54"},{"v":0.4102061277114094,"d":"0.41"},{"v":0.03154219750610188,"d":"0.03"},{"v":0.09872865379541973,"d":"0.10"}]
[{"$f":"A266+1","v":2046},17,{"v":39.5574987883987,"d":"40"},{"v":6.845063849378908,"d":"7"},{"v":0.4435601374397533,"d":"0.44"},{"v":0.3392237041104873,"d":"0.34"},{"v":0.026084108332316502,"d":"0.03"},{"v":0.08164456203805437,"d":"0.08"}]
[{"$f":"A267+1","v":2047},18,{"v":32.71243493901979,"d":"33"},{"v":5.6605880726694,"d":"6"},{"v":0.36680610710897715,"d":"0.37"},{"v":0.280524140564268,"d":"0.28"},{"v":0.02157049163617729,"d":"0.02"},{"v":0.06751671631417457,"d":"0.07"}]
[{"$f":"A268+1","v":2048},19,{"v":27.051846866350395,"d":"27"},{"v":4.681075010184813,"d":"5"},{"v":0.3033336606599759,"d":"0.30"},{"v":0.2319820003312331,"d":"0.23"},{"v":0.017837915082185705,"d":"0.02"},{"v":0.05583356524986944,"d":"0.06"}]
[{"$f":"A269+1","v":2049},20,{"v":22.370771856165582,"d":"22"},{"v":3.871057736346349,"d":"4"},{"v":0.2508445413152435,"d":"0.25"},{"v":0.19183963408436533,"d":"0.19"},{"v":0.014751226807719536,"d":"0.01"},{"v":0.04617207676400226,"d":"0.05"}]
[{"$f":"A270+1","v":2050},21,{"v":18.499714119819235,"d":"18"},{"v":3.2012065530937295,"d":"3"},{"v":0.2074381846404737,"d":"0.21"},{"v":0.17306567744554724,"d":"0.17"},{"v":0.008593126798731615,"d":"0.01"},{"v":0.027510037170650314,"d":"0.03"}]
[{"$f":"A271+1","v":2051},22,{"v":15.298507566725505,"d":"15"},{"v":2.6472669987202067,"d":"3"},{"v":0.1715429015170694,"d":"0.17"},{"v":0.14311824273569101,"d":"0.14"},{"v":7.1061646953445995E-3,"d":"0.01"},{"v":0.0227496765133907,"d":"0.02"}]
[{"$f":"A272+1","v":2052},23,{"v":12.651240568005298,"d":"13"},{"v":2.189181624578506,"d":"2"},{"v":0.1418589692726872,"d":"0.14"},{"v":0.11835293806420295,"d":"0.12"},{"v":0.005876507802121064,"d":"0.01"},{"v":0.018813052787005225,"d":"0.02"}]
[{"$f":"A273+1","v":2053},24,{"v":10.462058943426792,"d":"10"},{"v":1.810363740306164,"d":"2"},{"v":0.11731157037183945,"d":"0.12"},{"v":0.09787304316122566,"d":"0.10"},{"v":0.004859631802653447,"d":"0.00"},{"v":0.015557625839572597,"d":"0.02"}]
[{"$f":"A274+1","v":2054},25,{"v":8.651695203120628,"d":"9"},{"v":1.4970968308060515,"d":"1"},{"v":0.09701187463623215,"d":"0.10"},{"v":0.0809370070090085,"d":"0.08"},{"v":0.004018716906805914,"d":"0.00"},{"v":0.012865520790507831,"d":"0.01"}]
[{"$f":"A275+1","v":2055},26,{"v":7.1545983723145765,"d":"7"},{"v":1.2380378986327247,"d":"1"},{"v":0.08022485583140057,"d":"0.08"},{"v":0.0669315972201375,"d":"0.07"},{"v":3.3233146528157675E-3,"d":"0.00"},{"v":0.010639259930648681,"d":"0.01"}]
[]
[]
[]
[{"$f":"_xlfn.CONCAT(\"Food Waste Addition during \",Calculator!A15)","v":"Food Waste Addition during Year 6 / 2030"}]
["Year","Year Since Placement","Food Waste in Landfill (short tons, start of year)","Food Waste Decayed (short tons)","Methane Generated (MT CH4)","Methane Captured (MT CH4)","Methane Oxidized (MT CH4)","Methane Released (MT CH4)"]
[{"$f":"Calculator!$B8","v":2025}]
[{"$f":"A282+1","v":2026}]
[{"$f":"A283+1","v":2027}]
[{"$f":"A284+1","v":2028}]
[{"$f":"A285+1","v":2029}]
[{"$f":"A286+1","v":2030},0,{"$f":"Calculator!B15","v":1000},{"$f":"C287*(1-EXP(-$B$21))","v":{"v":173.0408660566377,"d":"173"}},{"$f":"D287*$B$20","v":{"v":11.213048120470125,"d":"11.21"}},{"$f":"E287*_xlfn.XLOOKUP(B287,$A$32:$A$62,$B$32:$B$62)*$B$22","v":{"v":0,"d":"0.00"}},{"$f":"(E287-F287)*_xlfn.XLOOKUP(B287,$A$32:$A$62,$D$32:$D$62)","v":{"v":1.1213048120470126,"d":"1.12"}},{"$f":"E287-F287*_xlfn.XLOOKUP(B287,$A$32:$A$62,$C$32:$C$62)-G287","v":{"v":10.091743308423112,"d":"10.09"}}]
[{"$f":"A287+1","v":2031},1,{"$f":"C287-D287","v":{"v":826.9591339433623,"d":"827"}},{"v":143.09772473100648,"d":"143"},{"$f":"D288*$B$20","v":{"v":9.272732562569221,"d":"9.27"}},{"v":0,"d":"0.00"},{"v":0.9272732562569221,"d":"0.93"},{"v":8.345459306312298,"d":"8.35"}]
[{"$f":"A288+1","v":2032},2,{"v":683.8614092123559,"d":"684"},{"v":118.33597051281878,"d":"118"},{"v":7.668170889230658,"d":"7.67"},{"v":0,"d":"0.00"},{"v":0.7668170889230659,"d":"0.77"},{"v":6.901353800307592,"d":"6.90"}]
[{"$f":"A289+1","v":2033},3,{"v":565.5254386995371,"d":"566"},{"v":97.85901168962788,"d":"98"},{"v":6.341263957487888,"d":"6.34"},{"v":0,"d":"0.00"},{"v":0.6341263957487888,"d":"0.63"},{"v":5.707137561739099,"d":"5.71"}]
[{"$f":"A290+1","v":2034},4,{"v":467.66642700990917,"d":"468"},{"v":80.92540355540802,"d":"81"},{"v":5.243966150390441,"d":"5.24"},{"v":0,"d":"0.00"},{"v":0.5243966150390441,"d":"0.52"},{"v":4.719569535351397,"d":"4.72"}]
[{"$f":"A291+1","v":2035},5,{"v":386.74102345450115,"d":"387"},{"v":66.92200163819732,"d":"67"},{"v":4.336545706155187,"d":"4.34"},{"v":2.009988934802929,"d":"2.01"},{"v":0.5816391928380644,"d":"0.58"},{"v":1.7650174678622224,"d":"1.77"}]
[{"$f":"A292+1","v":2036},6,{"v":319.8190218163038,"d":"320"},{"v":55.34176051647992,"d":"55"},{"v":3.5861460814678994,"d":"3.59"},{"v":1.6621787087603714,"d":"1.66"},{"v":0.480991843176882,"d":"0.48"},{"v":1.4595973166182497,"d":"1.46"}]
[{"$f":"A293+1","v":2037},7,{"v":264.4772612998239,"d":"264"},{"v":45.7653743476092,"d":"46"},{"v":2.965596257725077,"d":"2.97"},{"v":1.3745538654555733,"d":"1.37"},{"v":0.3977605980673759,"d":"0.40"},{"v":1.2070273328566834,"d":"1.21"}]
[{"$f":"A294+1","v":2038},8,{"v":218.7118869522147,"d":"219"},{"v":37.84609433509267,"d":"38"},{"v":2.4524269129140057,"d":"2.45"},{"v":1.1366998741356418,"d":"1.14"},{"v":0.328931759694591,"d":"0.33"},{"v":0.9981622778251295,"d":"1.00"}]
[{"$f":"A295+1","v":2039},9,{"v":180.86579261712205,"d":"181"},{"v":31.297173394487032,"d":"31"},{"v":2.02805683596276,"d":"2.03"},{"v":0.9400043434687394,"d":"0.94"},{"v":0.27201312312350523,"d":"0.27"},{"v":0.8254394128052029,"d":"0.83"}]
[{"$f":"A296+1","v":2040},10,{"v":149.56861922263502,"d":"150"},{"v":25.881483405180234,"d":"26"},{"v":1.6771201246556795,"d":"1.68"},{"v":1.1660177666668612,"d":"1.17"},{"v":0.12777558949720458,"d":"0.13"},{"v":0.39498694615828245,"d":"0.39"}]
[{"$f":"A297+1","v":2041},11,{"v":123.68713581745479,"d":"124"},{"v":21.40292910191735,"d":"21"},{"v":1.3869098058042446,"d":"1.39"},{"v":0.9642490424854011,"d":"0.96"},{"v":0.10566519082971088,"d":"0.11"},{"v":0.3266380629139866,"d":"0.33"}]
[{"$f":"A298+1","v":2042},12,{"v":102.28420671553744,"d":"102"},{"v":17.699347713972756,"d":"18"},{"v":1.1469177318654347,"d":"1.15"},{"v":0.7973945530794435,"d":"0.80"},{"v":0.08738079469649779,"d":"0.09"},{"v":0.2701163296202878,"d":"0.27"}]
[{"$f":"A299+1","v":2043},13,{"v":84.58485900156468,"d":"85"},{"v":14.63663725690934,"d":"15"},{"v":0.9484540942477254,"d":"0.95"},{"v":0.6594127090257311,"d":"0.66"},{"v":0.07226034630549857,"d":"0.07"},{"v":0.22337516600675303,"d":"0.22"}]
[{"$f":"A300+1","v":2044},14,{"v":69.94822174465534,"d":"70"},{"v":12.103900869816899,"d":"12"},{"v":0.7843327763641351,"d":"0.78"},{"v":0.545307362767165,"d":"0.55"},{"v":0.05975635339924254,"d":"0.06"},{"v":0.1847221338253993,"d":"0.18"}]
[{"$f":"A301+1","v":2045},15,{"v":57.844320874838445,"d":"58"},{"v":10.009431380640091,"d":"10"},{"v":0.648611153465478,"d":"0.65"},{"v":0.496041594891561,"d":"0.50"},{"v":0.038142389643479255,"d":"0.04"},{"v":0.11938758487935337,"d":"0.12"}]
[{"$f":"A302+1","v":2046},16,{"v":47.83488949419835,"d":"48"},{"v":8.277390705799643,"d":"8"},{"v":0.5363749177358169,"d":"0.54"},{"v":0.4102061277114094,"d":"0.41"},{"v":0.03154219750610188,"d":"0.03"},{"v":0.09872865379541973,"d":"0.10"}]
[{"$f":"A303+1","v":2047},17,{"v":39.5574987883987,"d":"40"},{"v":6.845063849378908,"d":"7"},{"v":0.4435601374397533,"d":"0.44"},{"v":0.3392237041104873,"d":"0.34"},{"v":0.026084108332316502,"d":"0.03"},{"v":0.08164456203805437,"d":"0.08"}]
[{"$f":"A304+1","v":2048},18,{"v":32.71243493901979,"d":"33"},{"v":5.6605880726694,"d":"6"},{"v":0.36680610710897715,"d":"0.37"},{"v":0.280524140564268,"d":"0.28"},{"v":0.02157049163617729,"d":"0.02"},{"v":0.06751671631417457,"d":"0.07"}]
[{"$f":"A305+1","v":2049},19,{"v":27.051846866350395,"d":"27"},{"v":4.681075010184813,"d":"5"},{"v":0.3033336606599759,"d":"0.30"},{"v":0.2319820003312331,"d":"0.23"},{"v":0.017837915082185705,"d":"0.02"},{"v":0.05583356524986944,"d":"0.06"}]
[{"$f":"A306+1","v":2050},20,{"v":22.370771856165582,"d":"22"},{"v":3.871057736346349,"d":"4"},{"v":0.2508445413152435,"d":"0.25"},{"v":0.19183963408436533,"d":"0.19"},{"v":0.014751226807719536,"d":"0.01"},{"v":0.04617207676400226,"d":"0.05"}]
[{"$f":"A307+1","v":2051},21,{"v":18.499714119819235,"d":"18"},{"v":3.2012065530937295,"d":"3"},{"v":0.2074381846404737,"d":"0.21"},{"v":0.17306567744554724,"d":"0.17"},{"v":0.008593126798731615,"d":"0.01"},{"v":0.027510037170650314,"d":"0.03"}]
[{"$f":"A308+1","v":2052},22,{"v":15.298507566725505,"d":"15"},{"v":2.6472669987202067,"d":"3"},{"v":0.1715429015170694,"d":"0.17"},{"v":0.14311824273569101,"d":"0.14"},{"v":7.1061646953445995E-3,"d":"0.01"},{"v":0.0227496765133907,"d":"0.02"}]
[{"$f":"A309+1","v":2053},23,{"v":12.651240568005298,"d":"13"},{"v":2.189181624578506,"d":"2"},{"v":0.1418589692726872,"d":"0.14"},{"v":0.11835293806420295,"d":"0.12"},{"v":0.005876507802121064,"d":"0.01"},{"v":0.018813052787005225,"d":"0.02"}]
[{"$f":"A310+1","v":2054},24,{"v":10.462058943426792,"d":"10"},{"v":1.810363740306164,"d":"2"},{"v":0.11731157037183945,"d":"0.12"},{"v":0.09787304316122566,"d":"0.10"},{"v":0.004859631802653447,"d":"0.00"},{"v":0.015557625839572597,"d":"0.02"}]
[{"$f":"A311+1","v":2055},25,{"v":8.651695203120628,"d":"9"},{"v":1.4970968308060515,"d":"1"},{"v":0.09701187463623215,"d":"0.10"},{"v":0.0809370070090085,"d":"0.08"},{"v":0.004018716906805914,"d":"0.00"},{"v":0.012865520790507831,"d":"0.01"}]

{"sheet":"Year (Hidden)","index":2,"n_rows":33,"n_cols":1,"rows_kept":33,"hidden":true}
["Selectable starting years"]
[]
[2020]
[{"$f":"A3+1","v":2021}]
[2022]
[2023]
[2024]
[2025]
[2026]
[2027]
[2028]
[2029]
[2030]
[2031]
[2032]
[2033]
[2034]
[2035]
[2036]
[2037]
[2038]
[2039]
[2040]
[2041]
[2042]
[2043]
[2044]
[2045]
[2046]
[2047]
[2048]
[2049]
[2050]

{"sheet":"Documentation_Food Waste Decay","index":3,"n_rows":80,"n_cols":16,"rows_kept":80,"merged":[[0,0,0,19],[2,0,3,19],[4,0,4,19],[5,0,5,19],[6,0,7,19],[8,0,8,19],[10,0,10,19],[12,0,13,19],[15,0,15,19],[16,0,17,19],[18,0,18,19],[19,0,19,19],[20,0,20,19],[21,6,21,7],[21,8,21,13],[22,6,22,7],[22,8,22,13],[23,6,23,7],[23,8,23,13],[24,6,24,7],[24,8,24,13],[25,6,25,7],[25,8,25,13],[26,6,26,7],[26,8,26,13],[27,6,27,7],[27,8,27,13],[29,0,29,19],[30,5,30,16],[31,0,32,3],[31,4,32,4],[31,5,32,6],[31,7,32,8],[31,9,32,10],[31,11,32,12],[31,13,32,14],[31,15,32,16],[31,17,32,19],[33,5,33,6],[33,7,33,8],[33,9,33,10],[33,11,33,12],[33,13,33,14],[33,15,33,16],[34,5,34,6],[34,7,34,8],[34,9,34,10],[34,11,34,12],[34,13,34,14],[34,15,34,16],[35,5,35,6],[35,7,35,8],[35,9,35,10],[35,11,35,12],[35,13,35,14],[35,15,35,16],[36,5,36,6],[36,7,36,8],[36,9,36,10],[36,11,36,12],[36,13,36,14],[36,15,36,16],[37,5,37,6],[37,7,37,8],[37,9,37,10],[37,11,37,12],[37,13,37,14],[37,15,37,16],[38,5,38,6],[38,7,38,8],[38,9,38,10],[38,11,38,12],[38,13,38,14],[38,15,38,16],[39,5,39,6],[39,7,39,8],[39,9,39,10],[39,11,39,12],[39,13,39,14],[39,15,39,16],[40,5,40,6],[40,7,40,8],[40,9,40,10],[40,11,40,12],[40,13,40,14],[40,15,40,16],[41,5,41,6],[41,7,41,8],[41,9,41,10],[41,11,41,12],[41,13,41,14],[41,15,41,16],[42,5,42,6],[42,7,42,8],[42,9,42,10],[42,11,42,12],[42,13,42,14],[42,15,42,16],[44,0,44,19],[46,0,47,19],[49,0,49,19],[51,0,52,19],[54,0,54,19],[56,0,57,19],[59,0,59,19],[60,0,60,19],[61,0,61,19],[63,0,65,19],[67,0,67,19],[68,6,69,7],[68,8,69,9],[68,10,69,11],[68,12,69,13],[70,6,70,7],[70,8,70,9],[70,10,70,11],[70,12,70,13],[71,6,71,7],[71,8,71,9],[71,10,71,11],[71,12,71,13],[72,6,72,7],[72,8,72,9],[72,10,72,11],[72,12,72,13],[73,6,73,7],[73,8,73,9],[73,10,73,11],[73,12,73,13],[74,6,74,7],[74,8,74,9],[74,10,74,11],[74,12,74,13],[75,6,75,7],[75,8,75,9],[75,10,75,11],[75,12,75,13],[76,6,76,7],[76,8,76,9],[76,10,76,11],[76,12,76,13],[77,6,77,7],[77,8,77,9],[77,10,77,11],[77,12,77,13],[78,6,78,7],[78,8,78,9],[78,10,78,11],[78,12,78,13],[79,6,79,7],[79,8,79,9],[79,10,79,11],[79,12,79,13]]}
["Documentation - Food Waste Decay"]
[]
["This document describes the calculations and references used to calculate the amount of methane avoided by preventing or avoiding the landfilling of food waste. It will walk through an example calculation. The calculator is built upon the peer-reviewed methodology found in EPA’s “Quantifying Methane Emissions from Landfilled Food Waste” report. "]
[]
["Food waste decays into methane (CH4) and carbon dioxide (CO2) when landfilled. As a result, when food waste landfilling is prevented or avoided, those emissions are also avoided."]
["The exact amount of methane and CO2 avoided depends on both food waste properties (such as carbon content and moisture content) and landfill properties (average temperature and rainfall). "]
["This calculator assumes that food waste characteristics are an average for the U.S. (the most important being methane generation potential and moisture) and that the landfill has average characteristics for a U.S. landfill; these parameters are static and are not intended to be adjusted by the end-user. This document notes where these assumptions about parameters occur in the calculation steps. "]
[]
["The calculator models emissions over a 25 year timeline and this documentation uses the first 10 years as an example to demonstrate calculation steps."]
[]
["Tonnage of Landfilled Food Waste Avoided Per Year"]
[]
["The calculator allows the user to specify the amount of landfilled food waste avoided per year, for a 6-year period. This value is entered in wet short tons with an assumed moisture content of 70%. Food waste avoided during each year is assumed to have independent, average gas collection installation schedules. Landfill gas collection efficiency is calculated based on the years since placement, not on the overall year in the scenario."]
[]
[]
["Example"]
["In Table 1 a hypothetical user specifies the amounts of landfilled food waste avoided, with a starting year of 2025. These values will be used throughout this documentation as an example scenario. Table 2 shows how food waste ages, and how each year’s addition ages independently of other additions. Please note that “years since placement” is staggered each year’s amount of avoided food waste. \n"]
[]
["The example details 10 years of methane emissions to briefly showcase calculations. The actual calculator covers emissions over 25-year timeline."]
[]
["Table 1. Sample Scenario of Landfilled Food Waste Avoided"]
[{"$nulls":6},"Year",null,"Landfilled Food Waste Avoided per year (Short tons per year)"]
[{"$nulls":6},"Year 1 / 2025",null,500]
[{"$nulls":6},"Year 2 / 2026",null,500]
[{"$nulls":6},"Year 3 / 2027",null,1000]
[{"$nulls":6},"Year 4 / 2028",null,1000]
[{"$nulls":6},"Year 5 / 2029",null,1000]
[{"$nulls":6},"Year 6 / 2030",null,1000]
[]
["Table 2. Sample Scenario of Food Waste Landfilled Food Waste Avoided, Years Since Placement"]
[{"$nulls":5},"Years Since Placement"]
[{"$nulls":4},"Year","Food Waste Landfilled in Year 1",null,"Food Waste Landfilled in Year 2",null,"Food Waste Landfilled in Year 3",null,"Food Waste Landfilled in Year 4",null,"Food Waste Landfilled in Year 5",null,"Food Waste Landfilled in Year 6"]
[]
[{"$nulls":4},"Year 1",0]
[{"$nulls":4},"Year 2",1,null,0]
[{"$nulls":4},"Year 3",2,null,1,null,0]
[{"$nulls":4},"Year 4",3,null,2,null,1,null,0]
[{"$nulls":4},"Year 5",4,null,3,null,2,null,1,null,0]
[{"$nulls":4},"Year 6",5,null,4,null,3,null,2,null,1,null,0]
[{"$nulls":4},"Year 7",6,null,5,null,4,null,3,null,2,null,1]
[{"$nulls":4},"Year 8",7,null,6,null,5,null,4,null,3,null,2]
[{"$nulls":4},"Year 9",8,null,7,null,6,null,5,null,4,null,3]
[{"$nulls":4},"Year 10",9,null,8,null,7,null,6,null,5,null,4]
[]
["Food Waste Decay"]
[]
["It will take time for food waste to decay, with some food waste lasting for years in the landfill. The calculator uses the national average food waste decay rate of 0.19 yr-1 from EPA’s Waste Reduction Model (WARM) and “Quantifying Methane Emissions from Landfilled Food Waste” report. This rate is used with a pseudo first order reaction rate equation to determine what fraction of food waste decays each year:"]
[]
[]
["fraction of food waste decayed = 1-e^(-0.19)"]
[]
["This means that about 17.3% of food waste will decay year-over-year. This calculator will use wet mass since the methane generation potential is specifically on a wet mass basis. This is the same assumption made by EPA’s Waste Reduction Model (WARM) v.15 and “Quantifying Methane Emissions from Landfilled Food Waste” report."]
[]
[]
["Example"]
[]
["Note: Due to rounding, performing the calculations given in the equations below may not return the exact results shown.\nUsing the same user specified food waste amounts, food waste decayed and food waste remaining can be calculated for each year. Below is an example of that calculation sequence and the mass balance of Table 1."]
[]
[]
["Initial mass of food waste: 500 short tons"]
["Mass of food waste decayed over the year:  500 short tons food waste* (1-e^(-0.19) ) = 86.5 short tons food waste"]
["Mass of food waste still in the landfill at the end of the year: 500-86.5 = 413.5 short tons food waste"]
[]
["At the beginning of year 2 an additional 500 short tons of food waste is added to the landfill, but this addition is assumed to be independent of the food waste from year 1, with its own collection installation schedule. Therefore, food waste landfilled in year 1 will begin gas collection before food waste landfilled in year 2. Please refer to Table 2 for how ‘years since placement’ is staggered for each year. Table 3 shows the mass of food waste decayed and the mass remaining for the 500 tons of food waste landfilled in 2025."]
[]
[]
[]
["Table 3. Sample Scenario of Food Waste Decay and Mass Balance for 500 Short Tons of Food Waste"]
[{"$nulls":6},"Year",null,"Initial Mass \n(Wet short tons)",null,"Food Waste Decayed \n(Wet short tons)",null,"Remaining Mass (Wet short tons)"]
[]
[{"$nulls":6},"Year 1 / 2025",null,500,null,86.5,null,413.5]
[{"$nulls":6},"Year 2 / 2026",null,413.5,null,71.5,null,341.9]
[{"$nulls":6},"Year 3 / 2027",null,341.9,null,59.2,null,282.8]
[{"$nulls":6},"Year 4 / 2028",null,282.8,null,48.9,null,233.8]
[{"$nulls":6},"Year 5 / 2029",null,233.8,null,40.5,null,193.4]
[{"$nulls":6},"Year 6 / 2030",null,193.4,null,33.5,null,159.9]
[{"$nulls":6},"Year 7 / 2031",null,159.9,null,27.7,null,132.2]
[{"$nulls":6},"Year 8 / 2032",null,132.2,null,22.9,null,109.4]
[{"$nulls":6},"Year 9 / 2033",null,109.4,null,18.9,null,90.4]
[{"$nulls":6},"Year 10 / 2034",null,90.4,null,15.6,null,74.8]

{"sheet":"Documentation_Methane Fate","index":4,"n_rows":108,"n_cols":14,"rows_kept":108,"merged":[[0,0,0,19],[1,0,1,19],[2,0,2,19],[4,0,4,19],[23,0,24,19],[26,0,26,19],[27,0,30,19],[32,0,32,19],[34,0,34,19],[35,0,35,19],[37,0,37,19],[39,0,39,19],[40,0,40,19],[42,0,43,19],[45,0,45,19],[47,0,48,19],[50,0,50,19],[52,5,53,6],[52,7,53,8],[52,9,53,10],[52,11,53,12],[52,13,53,14],[54,5,54,6],[54,7,54,8],[54,9,54,10],[54,11,54,12],[54,13,54,14],[55,5,55,6],[55,7,55,8],[55,9,55,10],[55,11,55,12],[55,13,55,14],[56,5,56,6],[56,7,56,8],[56,9,56,10],[56,11,56,12],[56,13,56,14],[57,5,57,6],[57,7,57,8],[57,9,57,10],[57,11,57,12],[57,13,57,14],[58,5,58,6],[58,7,58,8],[58,9,58,10],[58,11,58,12],[58,13,58,14],[59,5,59,6],[59,7,59,8],[59,9,59,10],[59,11,59,12],[59,13,59,14],[60,5,60,6],[60,7,60,8],[60,9,60,10],[60,11,60,12],[60,13,60,14],[61,5,61,6],[61,7,61,8],[61,9,61,10],[61,11,61,12],[61,13,61,14],[62,5,62,6],[62,7,62,8],[62,9,62,10],[62,11,62,12],[62,13,62,14],[63,5,63,6],[63,7,63,8],[63,9,63,10],[63,11,63,12],[63,13,63,14],[65,0,65,19],[66,0,66,19],[67,0,69,19],[67,20,69,39],[67,40,69,59],[67,60,69,79],[67,80,69,99],[67,100,69,119],[67,120,69,139],[67,140,69,159],[67,160,69,179],[67,180,69,199],[67,200,69,219],[67,220,69,239],[67,240,69,259],[67,260,69,279],[67,280,69,299],[67,300,69,319],[67,320,69,339],[67,340,69,359],[67,360,69,379],[67,380,69,399],[67,400,69,419],[67,420,69,439],[67,440,69,459],[67,460,69,479],[67,480,69,499],[67,500,69,519],[67,520,69,539],[67,540,69,559],[67,560,69,579],[67,580,69,599],[67,600,69,619],[67,620,69,639],[67,640,69,659],[67,660,69,679],[67,680,69,699],[67,700,69,719],[67,720,69,739],[67,740,69,759],[67,760,69,779],[67,780,69,799],[67,800,69,819],[67,820,69,839],[67,840,69,859],[67,860,69,879],[67,880,69,899],[67,900,69,919],[67,920,69,939],[67,940,69,959],[67,960,69,979],[67,980,69,999],[67,1000,69,1019],[67,1020,69,1039],[67,1040,69,1059],[67,1060,69,1079],[67,1080,69,1099],[67,1100,69,1119],[67,1120,69,1139],[67,1140,69,1159],[67,1160,69,1179],[67,1180,69,1199],[67,1200,69,1219],[67,1220,69,1239],[67,1240,69,1259],[67,1260,69,1279],[67,1280,69,1299],[67,1300,69,1319],[67,1320,69,1339],[67,1340,69,1359],[67,1360,69,1379],[67,1380,69,1399],[67,1400,69,1419],[67,1420,69,1439],[67,1440,69,1459],[67,1460,69,1479],[67,1480,69,1499],[67,1500,69,1519],[67,1520,69,1539],[67,1540,69,1559],[67,1560,69,1579],[67,1580,69,1599],[67,1600,69,1619],[67,1620,69,1639],[67,1640,69,1659],[67,1660,69,1679],[67,1680,69,1699],[67,1700,69,1719],[67,1720,69,1739],[67,1740,69,1759],[67,1760,69,1779],[67,1780,69,1799],[67,1800,69,1819],[67,1820,69,1839],[67,1840,69,1859],[67,1860,69,1879],[67,1880,69,1899],[67,1900,69,1919],[67,1920,69,1939],[67,1940,69,1959],[67,1960,69,1979],[67,1980,69,1999],[67,2000,69,2019],[67,2020,69,2039],[67,2040,69,2059],[67,2060,69,2079],[67,2080,69,2099],[67,2100,69,2119],[67,2120,69,2139],[67,2140,69,2159],[67,2160,69,2179],[67,2180,69,2199],[67,2200,69,2219],[67,2220,69,2239],[67,2240,69,2259],[67,2260,69,2279],[67,2280,69,2299],[67,2300,69,2319],[67,2320,69,2339],[67,2340,69,2359],[67,2360,69,2379],[67,2380,69,2399],[67,2400,69,2419],[67,2420,69,2439],[67,2440,69,2459],[67,2460,69,2479],[67,2480,69,2499],[67,2500,69,2519],[67,2520,69,2539],[67,2540,69,2559],[67,2560,69,2579],[67,2580,69,2599],[67,2600,69,2619],[67,2620,69,2639],[67,2640,69,2659],[67,2660,69,2679],[67,2680,69,2699],[67,2700,69,2719],[67,2720,69,2739],[67,2740,69,2759],[67,2760,69,2779],[67,2780,69,2799],[67,2800,69,2819],[67,2820,69,2839],[67,2840,69,2859],[67,2860,69,2879],[67,2880,69,2899],[67,2900,69,2919],[67,2920,69,2939],[67,2940,69,2959],[67,2960,69,2979],[67,2980,69,2999],[67,3000,69,3019],[67,3020,69,3039],[67,3040,69,3059],[67,3060,69,3079],[67,3080,69,3099],[67,3100,69,3119],[67,3120,69,3139],[67,3140,69,3159],[67,3160,69,3179],[67,3180,69,3199],[67,3200,69,3219],[67,3220,69,3239],[67,3240,69,3259],[67,3260,69,3279],[67,3280,69,3299],[67,3300,69,3319],[67,3320,69,3339],[67,3340,69,3359],[67,3360,69,3379],[67,3380,69,3399],[67,3400,69,3419],[67,3420,69,3439],[67,3440,69,3459],[67,3460,69,3479],[67,3480,69,3499],[67,3500,69,3519],[67,3520,69,3539],[67,3540,69,3559],[67,3560,69,3579],[67,3580,69,3599],[67,3600,69,3619],[67,3620,69,3639],[67,3640,69,3659],[67,3660,69,3679],[67,3680,69,3699],[67,3700,69,3719],[67,3720,69,3739],[67,3740,69,3759],[67,3760,69,3779],[67,3780,69,3799],[67,3800,69,3819],[67,3820,69,3839],[67,3840,69,3859],[67,3860,69,3879],[67,3880,69,3899],[67,3900,69,3919],[67,3920,69,3939],[67,3940,69,3959],[67,3960,69,3979],[67,3980,69,3999],[67,4000,69,4019],[67,4020,69,4039],[67,4040,69,4059],[67,4060,69,4079],[67,4080,69,4099],[67,4100,69,4119],[67,4120,69,4139],[67,4140,69,4159],[67,4160,69,4179],[67,4180,69,4199],[67,4200,69,4219],[67,4220,69,4239],[67,4240,69,4259],[67,4260,69,4279],[67,4280,69,4299],[67,4300,69,4319],[67,4320,69,4339],[67,4340,69,4359],[67,4360,69,4379],[67,4380,69,4399],[67,4400,69,4419],[67,4420,69,4439],[67,4440,69,4459],[67,4460,69,4479],[67,4480,69,4499],[67,4500,69,4519],[67,4520,69,4539],[67,4540,69,4559],[67,4560,69,4579],[67,4580,69,4599],[67,4600,69,4619],[67,4620,69,4639],[67,4640,69,4659],[67,4660,69,4679],[67,4680,69,4699],[67,4700,69,4719],[67,4720,69,4739],[67,4740,69,4759],[67,4760,69,4779],[67,4780,69,4799],[67,4800,69,4819],[67,4820,69,4839],[67,4840,69,4859],[67,4860,69,4879],[67,4880,69,4899],[67,4900,69,4919],[67,4920,69,4939],[67,4940,69,4959],[67,4960,69,4979],[67,4980,69,4999],[67,5000,69,5019],[67,5020,69,5039],[67,5040,69,5059],[67,5060,69,5079],[67,5080,69,5099],[67,5100,69,5119],[67,5120,69,5139],[67,5140,69,5159],[67,5160,69,5179],[67,5180,69,5199],[67,5200,69,5219],[67,5220,69,5239],[67,5240,69,5259],[67,5260,69,5279],[67,5280,69,5299],[67,5300,69,5319],[67,5320,69,5339],[67,5340,69,5359],[67,5360,69,5379],[67,5380,69,5399],[67,5400,69,5419],[67,5420,69,5439],[67,5440,69,5459],[67,5460,69,5479],[67,5480,69,5499],[67,5500,69,5519],[67,5520,69,5539],[67,5540,69,5559],[67,5560,69,5579],[67,5580,69,5599],[67,5600,69,5619],[67,5620,69,5639],[67,5640,69,5659],[67,5660,69,5679],[67,5680,69,5699],[67,5700,69,5719],[67,5720,69,5739],[67,5740,69,5759],[67,5760,69,5779],[67,5780,69,5799],[67,5800,69,5819],[67,5820,69,5839],[67,5840,69,5859],[67,5860,69,5879],[67,5880,69,5899],[67,5900,69,5919],[67,5920,69,5939],[67,5940,69,5959],[67,5960,69,5979],[67,5980,69,5999],[67,6000,69,6019],[67,6020,69,6039],[67,6040,69,6059],[67,6060,69,6079],[67,6080,69,6099],[67,6100,69,6119],[67,6120,69,6139],[67,6140,69,6159],[67,6160,69,6179],[67,6180,69,6199],[67,6200,69,6219],[67,6220,69,6239],[67,6240,69,6259],[67,6260,69,6279],[67,6280,69,6299],[67,6300,69,6319],[67,6320,69,6339],[67,6340,69,6359],[67,6360,69,6379],[67,6380,69,6399],[67,6400,69,6419],[67,6420,69,6439],[67,6440,69,6459],[67,6460,69,6479],[67,6480,69,6499],[67,6500,69,6519],[67,6520,69,6539],[67,6540,69,6559],[67,6560,69,6579],[67,6580,69,6599],[67,6600,69,6619],[67,6620,69,6639],[67,6640,69,6659],[67,6660,69,6679],[67,6680,69,6699],[67,6700,69,6719],[67,6720,69,6739],[67,6740,69,6759],[67,6760,69,6779],[67,6780,69,6799],[67,6800,69,6819],[67,6820,69,6839],[67,6840,69,6859],[67,6860,69,6879],[67,6880,69,6899],[67,6900,69,6919],[67,6920,69,6939],[67,6940,69,6959],[67,6960,69,6979],[67,6980,69,6999],[67,7000,69,7019],[67,7020,69,7039],[67,7040,69,7059],[67,7060,69,7079],[67,7080,69,7099],[67,7100,69,7119],[67,7120,69,7139],[67,7140,69,7159],[67,7160,69,7179],[67,7180,69,7199],[67,7200,69,7219],[67,7220,69,7239],[67,7240,69,7259],[67,7260,69,7279],[67,7280,69,7299],[67,7300,69,7319],[67,7320,69,7339],[67,7340,69,7359],[67,7360,69,7379],[67,7380,69,7399],[67,7400,69,7419],[67,7420,69,7439],[67,7440,69,7459],[67,7460,69,7479],[67,7480,69,7499],[67,7500,69,7519],[67,7520,69,7539],[67,7540,69,7559],[67,7560,69,7579],[67,7580,69,7599],[67,7600,69,7619],[67,7620,69,7639],[67,7640,69,7659],[67,7660,69,7679],[67,7680,69,7699],[67,7700,69,7719],[67,7720,69,7739],[67,7740,69,7759],[67,7760,69,7779],[67,7780,69,7799],[67,7800,69,7819],[67,7820,69,7839],[67,7840,69,7859],[67,7860,69,7879],[67,7880,69,7899],[67,7900,69,7919],[67,7920,69,7939],[67,7940,69,7959],[67,7960,69,7979],[67,7980,69,7999],[67,8000,69,8019],[67,8020,69,8039],[67,8040,69,8059],[67,8060,69,8079],[67,8080,69,8099],[67,8100,69,8119],[67,8120,69,8139],[67,8140,69,8159],[67,8160,69,8179],[67,8180,69,8199],[67,8200,69,8219],[67,8220,69,8239],[67,8240,69,8259],[67,8260,69,8279],[67,8280,69,8299],[67,8300,69,8319],[67,8320,69,8339],[67,8340,69,8359],[67,8360,69,8379],[67,8380,69,8399],[67,8400,69,8419],[67,8420,69,8439],[67,8440,69,8459],[67,8460,69,8479],[67,8480,69,8499],[67,8500,69,8519],[67,8520,69,8539],[67,8540,69,8559],[67,8560,69,8579],[67,8580,69,8599],[67,8600,69,8619],[67,8620,69,8639],[67,8640,69,8659],[67,8660,69,8679],[67,8680,69,8699],[67,8700,69,8719],[67,8720,69,8739],[67,8740,69,8759],[67,8760,69,8779],[67,8780,69,8799],[67,8800,69,8819],[67,8820,69,8839],[67,8840,69,8859],[67,8860,69,8879],[67,8880,69,8899],[67,8900,69,8919],[67,8920,69,8939],[67,8940,69,8959],[67,8960,69,8979],[67,8980,69,8999],[67,9000,69,9019],[67,9020,69,9039],[67,9040,69,9059],[67,9060,69,9079],[67,9080,69,9099],[67,9100,69,9119],[67,9120,69,9139],[67,9140,69,9159],[67,9160,69,9179],[67,9180,69,9199],[67,9200,69,9219],[67,9220,69,9239],[67,9240,69,9259],[67,9260,69,9279],[67,9280,69,9299],[67,9300,69,9319],[67,9320,69,9339],[67,9340,69,9359],[67,9360,69,9379],[67,9380,69,9399],[67,9400,69,9419],[67,9420,69,9439],[67,9440,69,9459],[67,9460,69,9479],[67,9480,69,9499],[67,9500,69,9519],[67,9520,69,9539],[67,9540,69,9559],[67,9560,69,9579],[67,9580,69,9599],[67,9600,69,9619],[67,9620,69,9639],[67,9640,69,9659],[67,9660,69,9679],[67,9680,69,9699],[67,9700,69,9719],[67,9720,69,9739],[67,9740,69,9759],[67,9760,69,9779],[67,9780,69,9799],[67,9800,69,9819],[67,9820,69,9839],[67,9840,69,9859],[67,9860,69,9879],[67,9880,69,9899],[67,9900,69,9919],[67,9920,69,9939],[67,9940,69,9959],[67,9960,69,9979],[67,9980,69,9999],[67,10000,69,10019],[67,10020,69,10039],[67,10040,69,10059],[67,10060,69,10079],[67,10080,69,10099],[67,10100,69,10119],[67,10120,69,10139],[67,10140,69,10159],[67,10160,69,10179],[67,10180,69,10199],[67,10200,69,10219],[67,10220,69,10239],[67,10240,69,10259],[67,10260,69,10279],[67,10280,69,10299],[67,10300,69,10319],[67,10320,69,10339],[67,10340,69,10359],[67,10360,69,10379],[67,10380,69,10399],[67,10400,69,10419],[67,10420,69,10439],[67,10440,69,10459],[67,10460,69,10479],[67,10480,69,10499],[67,10500,69,10519],[67,10520,69,10539],[67,10540,69,10559],[67,10560,69,10579],[67,10580,69,10599],[67,10600,69,10619],[67,10620,69,10639],[67,10640,69,10659],[67,10660,69,10679],[67,10680,69,10699],[67,10700,69,10719],[67,10720,69,10739],[67,10740,69,10759],[67,10760,69,10779],[67,10780,69,10799],[67,10800,69,10819],[67,10820,69,10839],[67,10840,69,10859],[67,10860,69,10879],[67,10880,69,10899],[67,10900,69,10919],[67,10920,69,10939],[67,10940,69,10959],[67,10960,69,10979],[67,10980,69,10999],[67,11000,69,11019],[67,11020,69,11039],[67,11040,69,11059],[67,11060,69,11079],[67,11080,69,11099],[67,11100,69,11119],[67,11120,69,11139],[67,11140,69,11159],[67,11160,69,11179],[67,11180,69,11199],[67,11200,69,11219],[67,11220,69,11239],[67,11240,69,11259],[67,11260,69,11279],[67,11280,69,11299],[67,11300,69,11319],[67,11320,69,11339],[67,11340,69,11359],[67,11360,69,11379],[67,11380,69,11399],[67,11400,69,11419],[67,11420,69,11439],[67,11440,69,11459],[67,11460,69,11479],[67,11480,69,11499],[67,11500,69,11519],[67,11520,69,11539],[67,11540,69,11559],[67,11560,69,11579],[67,11580,69,11599],[67,11600,69,11619],[67,11620,69,11639],[67,11640,69,11659],[67,11660,69,11679],[67,11680,69,11699],[67,11700,69,11719],[67,11720,69,11739],[67,11740,69,11759],[67,11760,69,11779],[67,11780,69,11799],[67,11800,69,11819],[67,11820,69,11839],[67,11840,69,11859],[67,11860,69,11879],[67,11880,69,11899],[67,11900,69,11919],[67,11920,69,11939],[67,11940,69,11959],[67,11960,69,11979],[67,11980,69,11999],[67,12000,69,12019],[67,12020,69,12039],[67,12040,69,12059],[67,12060,69,12079],[67,12080,69,12099],[67,12100,69,12119],[67,12120,69,12139],[67,12140,69,12159],[67,12160,69,12179],[67,12180,69,12199],[67,12200,69,12219],[67,12220,69,12239],[67,12240,69,12259],[67,12260,69,12279],[67,12280,69,12299],[67,12300,69,12319],[67,12320,69,12339],[67,12340,69,12359],[67,12360,69,12379],[67,12380,69,12399],[67,12400,69,12419],[67,12420,69,12439],[67,12440,69,12459],[67,12460,69,12479],[67,12480,69,12499],[67,12500,69,12519],[67,12520,69,12539],[67,12540,69,12559],[67,12560,69,12579],[67,12580,69,12599],[67,12600,69,12619],[67,12620,69,12639],[67,12640,69,12659],[67,12660,69,12679],[67,12680,69,12699],[67,12700,69,12719],[67,12720,69,12739],[67,12740,69,12759],[67,12760,69,12779],[67,12780,69,12799],[67,12800,69,12819],[67,12820,69,12839],[67,12840,69,12859],[67,12860,69,12879],[67,12880,69,12899],[67,12900,69,12919],[67,12920,69,12939],[67,12940,69,12959],[67,12960,69,12979],[67,12980,69,12999],[67,13000,69,13019],[67,13020,69,13039],[67,13040,69,13059],[67,13060,69,13079],[67,13080,69,13099],[67,13100,69,13119],[67,13120,69,13139],[67,13140,69,13159],[67,13160,69,13179],[67,13180,69,13199],[67,13200,69,13219],[67,13220,69,13239],[67,13240,69,13259],[67,13260,69,13279],[67,13280,69,13299],[67,13300,69,13319],[67,13320,69,13339],[67,13340,69,13359],[67,13360,69,13379],[67,13380,69,13399],[67,13400,69,13419],[67,13420,69,13439],[67,13440,69,13459],[67,13460,69,13479],[67,13480,69,13499],[67,13500,69,13519],[67,13520,69,13539],[67,13540,69,13559],[67,13560,69,13579],[67,13580,69,13599],[67,13600,69,13619],[67,13620,69,13639],[67,13640,69,13659],[67,13660,69,13679],[67,13680,69,13699],[67,13700,69,13719],[67,13720,69,13739],[67,13740,69,13759],[67,13760,69,13779],[67,13780,69,13799],[67,13800,69,13819],[67,13820,69,13839],[67,13840,69,13859],[67,13860,69,13879],[67,13880,69,13899],[67,13900,69,13919],[67,13920,69,13939],[67,13940,69,13959],[67,13960,69,13979],[67,13980,69,13999],[67,14000,69,14019],[67,14020,69,14039],[67,14040,69,14059],[67,14060,69,14079],[67,14080,69,14099],[67,14100,69,14119],[67,14120,69,14139],[67,14140,69,14159],[67,14160,69,14179],[67,14180,69,14199],[67,14200,69,14219],[67,14220,69,14239],[67,14240,69,14259],[67,14260,69,14279],[67,14280,69,14299],[67,14300,69,14319],[67,14320,69,14339],[67,14340,69,14359],[67,14360,69,14379],[67,14380,69,14399],[67,14400,69,14419],[67,14420,69,14439],[67,14440,69,14459],[67,14460,69,14479],[67,14480,69,14499],[67,14500,69,14519],[67,14520,69,14539],[67,14540,69,14559],[67,14560,69,14579],[67,14580,69,14599],[67,14600,69,14619],[67,14620,69,14639],[67,14640,69,14659],[67,14660,69,14679],[67,14680,69,14699],[67,14700,69,14719],[67,14720,69,14739],[67,14740,69,14759],[67,14760,69,14779],[67,14780,69,14799],[67,14800,69,14819],[67,14820,69,14839],[67,14840,69,14859],[67,14860,69,14879],[67,14880,69,14899],[67,14900,69,14919],[67,14920,69,14939],[67,14940,69,14959],[67,14960,69,14979],[67,14980,69,14999],[67,15000,69,15019],[67,15020,69,15039],[67,15040,69,15059],[67,15060,69,15079],[67,15080,69,15099],[67,15100,69,15119],[67,15120,69,15139],[67,15140,69,15159],[67,15160,69,15179],[67,15180,69,15199],[67,15200,69,15219],[67,15220,69,15239],[67,15240,69,15259],[67,15260,69,15279],[67,15280,69,15299],[67,15300,69,15319],[67,15320,69,15339],[67,15340,69,15359],[67,15360,69,15379],[67,15380,69,15399],[67,15400,69,15419],[67,15420,69,15439],[67,15440,69,15459],[67,15460,69,15479],[67,15480,69,15499],[67,15500,69,15519],[67,15520,69,15539],[67,15540,69,15559],[67,15560,69,15579],[67,15580,69,15599],[67,15600,69,15619],[67,15620,69,15639],[67,15640,69,15659],[67,15660,69,15679],[67,15680,69,15699],[67,15700,69,15719],[67,15720,69,15739],[67,15740,69,15759],[67,15760,69,15779],[67,15780,69,15799],[67,15800,69,15819],[67,15820,69,15839],[67,15840,69,15859],[67,15860,69,15879],[67,15880,69,15899],[67,15900,69,15919],[67,15920,69,15939],[67,15940,69,15959],[67,15960,69,15979],[67,15980,69,15999],[67,16000,69,16019],[67,16020,69,16039],[67,16040,69,16059],[67,16060,69,16079],[67,16080,69,16099],[67,16100,69,16119],[67,16120,69,16139],[67,16140,69,16159],[67,16160,69,16179],[67,16180,69,16199],[67,16200,69,16219],[67,16220,69,16239],[67,16240,69,16259],[67,16260,69,16279],[67,16280,69,16299],[67,16300,69,16319],[67,16320,69,16339],[67,16340,69,16359],[67,16360,69,16379],[67,16380,69,16383],[71,0,71,19],[73,6,74,7],[73,8,74,9],[73,10,74,11],[73,12,74,13],[75,6,75,7],[75,8,75,9],[75,10,75,11],[75,12,75,13],[76,6,76,7],[76,8,76,9],[76,10,76,11],[76,12,76,13],[77,6,77,7],[77,8,77,9],[77,10,77,11],[77,12,77,13],[78,6,78,7],[78,8,78,9],[78,10,78,11],[78,12,78,13],[79,6,79,7],[79,8,79,9],[79,10,79,11],[79,12,79,13],[81,0,81,19],[82,0,84,19],[86,0,86,19],[88,0,88,19],[89,0,89,19],[91,0,91,19],[93,0,93,19],[94,0,96,19],[94,20,96,39],[94,40,96,59],[94,60,96,79],[94,80,96,99],[94,100,96,119],[94,120,96,139],[94,140,96,159],[94,160,96,179],[94,180,96,199],[94,200,96,219],[94,220,96,239],[94,240,96,259],[94,260,96,279],[94,280,96,299],[94,300,96,319],[94,320,96,339],[94,340,96,359],[94,360,96,379],[94,380,96,399],[94,400,96,419],[94,420,96,439],[94,440,96,459],[94,460,96,479],[94,480,96,499],[94,500,96,519],[94,520,96,539],[94,540,96,559],[94,560,96,579],[94,580,96,599],[94,600,96,619],[94,620,96,639],[94,640,96,659],[94,660,96,679],[94,680,96,699],[94,700,96,719],[94,720,96,739],[94,740,96,759],[94,760,96,779],[94,780,96,799],[94,800,96,819],[94,820,96,839],[94,840,96,859],[94,860,96,879],[94,880,96,899],[94,900,96,919],[94,920,96,939],[94,940,96,959],[94,960,96,979],[94,980,96,999],[94,1000,96,1019],[94,1020,96,1039],[94,1040,96,1059],[94,1060,96,1079],[94,1080,96,1099],[94,1100,96,1119],[94,1120,96,1139],[94,1140,96,1159],[94,1160,96,1179],[94,1180,96,1199],[94,1200,96,1219],[94,1220,96,1239],[94,1240,96,1259],[94,1500,96,1519],[94,1520,96,1539],[94,1540,96,1559],[94,1560,96,1579],[94,1580,96,1599],[97,0,97,19],[99,0,99,19],[101,0,101,19],[102,0,103,19],[105,0,105,19],[107,0,108,19]],"merged_total":1752,"flags":["merged_cut"]}
["Documentation - Methane Fate"]
["This tab describes the underlying calculations and references used to calculate the amount of methane avoided by preventing or avoiding the landfilling of food waste, including an example calculation. "]
["This tab specifically details the calculations on methane fate.  In the diagram below, the steps following methane generation are detailed in this tab. "]
[]
["Figure 1. General Schematic of Methane Generation and Fate"]
{"$rows_empty":18}
["Figure 1 descriptive text: A block flow diagram shows the general steps for calculations in this calculator. A portion of the diagram is circled to show the steps detailed in this specific tab. These steps are whether or not methane is captured, destroyed, oxidized, or released."]
[]
[]
["Methane Generation Potential"]
["EPA’s “Quantifying Methane Emissions from Landfilled Food Waste” report estimated methane emissions for landfilled food waste using average food waste and landfill characteristics. This calculator makes the same food waste and landfill assumptions as that report but uses an updated global warming potential (GWP). The “Quantifying Methane Emissions from Landfilled Food Waste” report assumes a GWP value of 25 for methane and a methane generation potential of 1.62 metric tons of CO2equivalents (CO2eq)/ wet short ton food waste. This 100-year time horizon GWP value of 25 for methane was the official value at time of the modeling for that report, but EPA has since updated that value to 28."]
[]
[]
[]
[]
["(1.62 metric tons CO_2 eq.)/(1 wet short ton food waste)*(1 metric ton CH_4)/(25 metric ton CO_2 eq.) = (0.0648  metric tons CH_4)/(1 wet short ton food waste)  "]
[]
["Converting the methane generation potential to a methane basis, rather than CO2eq. allows for the user to specify a methane GWP other than 25."]
["Methane generated each year is calculated by multiplying the total amount of food waste decayed (on a wet basis) by the methane generation potential."]
[]
["(0.0648  metric tons CH_4)/(1 wet short ton food waste)*food waste decayed (wet short tons) = metric tons CH_4  generated"]
[]
["Example"]
["Note: Due to rounding, performing the calculations given in the equations below may not return the exact results shown."]
[]
["Using the previous mass balance table (Table 3), and the methane generation potential of 0.0648 metric tons CH4/wet short ton food waste, methane generated can be calculated. In the first year, 86.5 wet short tons of food waste decays. Therefore, the total amount of methane generated in the first year is:"]
[]
[]
["(0.0648  metric tons CH_4)/(1 wet short ton food waste)*86.5 wet short tons = 5.6 metric tons CH_4  generated"]
[]
["Table 4 shows the amount of methane generated for the first 10 years for food that is landfilled in year 1. Food waste landfilled in subsequent years has the same decay profile, but staggered by one year, two years, and so forth since decay is based on years since placement."]
[]
[]
["Table 4. Sample Scenario of Methane Generation from Food Waste Decay, Mass Balance for Year 1"]
[]
[{"$nulls":5},"Year",null,"Initial Mass \n(Wet short tons)",null,"Food Waste Decayed \n(Wet short tons)",null,"Remaining Mass (Wet short tons)",null,"Remaining Mass (Wet short tons)"]
[]
[{"$nulls":5},"Year 1 / 2025",null,500,null,86.5,null,413.5,null,5.6]
[{"$nulls":5},"Year 2 / 2026",null,413.5,null,71.5,null,341.9,null,4.6]
[{"$nulls":5},"Year 3 / 2027",null,341.9,null,59.2,null,282.8,null,3.8]
[{"$nulls":5},"Year 4 / 2028",null,282.8,null,48.9,null,233.8,null,3.2]
[{"$nulls":5},"Year 5 / 2029",null,233.8,null,40.5,null,193.4,null,2.6]
[{"$nulls":5},"Year 6 / 2030",null,193.4,null,33.5,null,159.9,null,2.2]
[{"$nulls":5},"Year 7 / 2031",null,159.9,null,27.7,null,132.2,null,1.8]
[{"$nulls":5},"Year 8 / 2032",null,132.2,null,22.9,null,109.4,null,1.5]
[{"$nulls":5},"Year 9 / 2033",null,109.4,null,18.9,null,90.4,null,1.2]
[{"$nulls":5},"Year 10 / 2034",null,90.4,null,15.6,null,74.8,null,{"v":1,"d":"1.0"}]
[]
["Methane Fate"]
["Once methane is generated it can be released to the atmosphere, destroyed via oxidation in the landfill cover, captured and destroyed, or captured and released (such as via a leak or faulty flare). "]
["This calculator uses the same assumptions as the “Quantifying Methane Emissions from Landfilled Food Waste” report and WARM v15 model for gas collection installation schedule and gas capture and destruction efficiency. Table 5 details the gas collection and destruction efficiency and schedule. The 99% destruction efficiency accounts for 1% loss of captured methane flaring and the collection efficiency accounts for leaks from equipment."]
[]
[]
[]
["Table 5. Gas Collection Efficiency and Schedule"]
[]
[{"$nulls":6},"Year Since Placement",null,"Collection Efficiency (%)",null,"CH4 Destruction Efficiency (%)",null,"Oxidation Rate (%)"]
[]
[{"$nulls":6},"0-4",null,{"v":0,"d":"0.0%"},null,"N/A",null,{"v":0.1,"d":"10%"}]
[{"$nulls":6},"5-9",null,{"v":0.5,"d":"50.0%"},null,{"v":0.99,"d":"99%"},null,{"v":0.25,"d":"25%"}]
[{"$nulls":6},"10-14",null,{"v":0.75,"d":"75.0%"},null,{"v":0.99,"d":"99%"},null,{"v":0.25,"d":"25%"}]
[{"$nulls":6},"15-20",null,{"v":0.825,"d":"82.5%"},null,{"v":0.99,"d":"99%"},null,{"v":0.25,"d":"25%"}]
[{"$nulls":6},"21-25",null,{"v":0.9,"d":"90.0%"},null,{"v":0.99,"d":"99%"},null,{"v":0.25,"d":"25%"}]
[]
["Methane Captured"]
["When there is a gas capture system in place, methane generated is multiplied by the collection efficiency to determine how much is captured. In Year 5, 50% of methane generated is captured and in Year 18, 82.5% is captured. The full capture schedule is detailed above in Table 5. Using EPA’s Landfill Methane Outreach Program database, the amount of landfills with gas capture systems (on a total mass landfilled-weighted basis) was calculated at 92.7%. This value is close to the 92.3% that was calculated in the “Quantifying Methane Emissions from Landfilled Food Waste” report for 2020. This value is assumed to be constant."]
[]
[]
[]
["methane captured (metric tons CH_4 ) = methane generated (metric tons CH_4 )*collection efficiency (fraction CH_4  collected)*0.927 "]
[]
["Methane Destroyed"]
["99% of methane captured is destroyed by combustion and becomes biogenic CO2, which is assumed to have a GWP value of zero, as described in the formula below. "]
[]
["methane destroyed (metric tons CH_4 ) = methane captured (metric tons CH_4 )*0.99"]
[]
["Methane Oxidized"]
["Several factors limit the capture of methane: newly landfilled food waste can be uncovered for several years, landfills with gas capture systems in place do not capture all methane, and some landfills do not implement gas capture at all. For these scenarios the calculator assumes that methane passes through the landfill cover where some is oxidized, then it is released to the atmosphere. This calculator assumes that 10% of methane is oxidized in the landfill cover in the initial five years (year 0-4 since placement), and 25% afterwards."]
[]
[]
["It is assumed that 92.7% of landfills have a gas capture system and 7.3% do not. The collection efficiency of any given year only applies to the landfills with gas capture systems."]
[]
["methane oxidized (metric tons CH_4 ) = [methane generated (metric tons CH_4 )-methane captured (metric tons CH_4 )]*oxidation rate (fraction CH_4  oxidized)"]
[]
["Methane Released"]
["Methane that is not destroyed or oxidized is instead released to the environment. This value is the emissions of methane that would occur if food waste was landfilled. The amount of methane release each year is summed to get the total avoided emissions for food waste that is not landfilled. This value is calculated as the balance of methane generated, as shown below:"]
[]
[]
["methane released (metric tons CH_4 ) = methane generated-methane destroyed-methane oxidized"]
[]
["Please note that this value does not consider if food waste is managed in another pathway, those impacts are outside the scope of this calculation. More extensive modeling on food waste management can be found in EPA’s Waste Reduction Model (WARM)."]

{"sheet":"Documentation_Example Calc","index":5,"n_rows":94,"n_cols":20,"rows_kept":94,"merged":[[0,0,0,19],[1,0,1,19],[2,0,2,19],[4,0,4,19],[5,0,5,19],[7,0,8,19],[10,0,10,19],[12,0,12,19],[14,0,14,19],[16,0,16,19],[16,20,16,39],[16,40,16,59],[16,60,16,79],[16,80,16,99],[16,100,16,119],[16,120,16,139],[16,140,16,159],[16,160,16,179],[16,180,16,199],[16,200,16,219],[16,220,16,239],[16,240,16,259],[16,260,16,279],[16,280,16,299],[16,300,16,319],[16,320,16,339],[16,340,16,359],[16,360,16,379],[16,380,16,399],[16,400,16,419],[16,420,16,439],[16,440,16,459],[16,460,16,479],[16,480,16,499],[16,500,16,519],[16,520,16,539],[16,540,16,559],[16,560,16,579],[16,580,16,599],[16,600,16,619],[16,620,16,639],[16,640,16,659],[16,660,16,679],[16,680,16,699],[16,700,16,719],[16,720,16,739],[16,740,16,759],[16,760,16,779],[16,780,16,799],[16,800,16,819],[16,820,16,839],[16,840,16,859],[16,860,16,879],[16,880,16,899],[16,900,16,919],[16,920,16,939],[16,940,16,959],[16,960,16,979],[16,980,16,999],[16,1000,16,1019],[16,1020,16,1039],[16,1040,16,1059],[16,1060,16,1079],[16,1080,16,1099],[16,1100,16,1119],[16,1120,16,1139],[16,1140,16,1159],[16,1160,16,1179],[16,1180,16,1199],[16,1200,16,1219],[16,1220,16,1239],[16,1240,16,1259],[16,1260,16,1279],[16,1280,16,1299],[16,1300,16,1319],[16,1320,16,1339],[16,1340,16,1359],[16,1360,16,1379],[16,1380,16,1399],[16,1400,16,1419],[16,1420,16,1439],[16,1440,16,1459],[16,1460,16,1479],[16,1480,16,1499],[16,1500,16,1519],[16,1520,16,1539],[16,1540,16,1559],[16,1560,16,1579],[16,1580,16,1599],[16,1600,16,1619],[16,1620,16,1639],[16,1640,16,1659],[16,1660,16,1679],[16,1680,16,1699],[16,1700,16,1719],[16,1720,16,1739],[16,1740,16,1759],[16,1760,16,1779],[16,1780,16,1799],[16,1800,16,1819],[16,1820,16,1839],[16,1840,16,1859],[16,1860,16,1879],[16,1880,16,1899],[16,1900,16,1919],[16,1920,16,1939],[16,1940,16,1959],[16,1960,16,1979],[16,1980,16,1999],[16,2000,16,2019],[16,2020,16,2039],[16,2040,16,2059],[16,2060,16,2079],[16,2080,16,2099],[16,2100,16,2119],[16,2120,16,2139],[16,2140,16,2159],[16,2160,16,2179],[16,2180,16,2199],[16,2200,16,2219],[16,2220,16,2239],[16,2240,16,2259],[16,2260,16,2279],[16,2280,16,2299],[16,2300,16,2319],[16,2320,16,2339],[16,2340,16,2359],[16,2360,16,2379],[16,2380,16,2399],[16,2400,16,2419],[16,2420,16,2439],[16,2440,16,2459],[16,2460,16,2479],[16,2480,16,2499],[16,2500,16,2519],[16,2520,16,2539],[16,2540,16,2559],[16,2560,16,2579],[16,2580,16,2599],[16,2600,16,2619],[16,2620,16,2639],[16,2640,16,2659],[16,2660,16,2679],[16,2680,16,2699],[16,2700,16,2719],[16,2720,16,2739],[16,2740,16,2759],[16,2760,16,2779],[16,2780,16,2799],[16,2800,16,2819],[16,2820,16,2839],[16,2840,16,2859],[16,2860,16,2879],[16,2880,16,2899],[16,2900,16,2919],[16,2920,16,2939],[16,2940,16,2959],[16,2960,16,2979],[16,2980,16,2999],[16,3000,16,3019],[16,3020,16,3039],[16,3040,16,3059],[16,3060,16,3079],[16,3080,16,3099],[16,3100,16,3119],[16,3120,16,3139],[16,3140,16,3159],[16,3160,16,3179],[16,3180,16,3199],[16,3200,16,3219],[16,3220,16,3239],[16,3240,16,3259],[16,3260,16,3279],[16,3280,16,3299],[16,3300,16,3319],[16,3320,16,3339],[16,3340,16,3359],[16,3360,16,3379],[16,3380,16,3399],[16,3400,16,3419],[16,3420,16,3439],[16,3440,16,3459],[16,3460,16,3479],[16,3480,16,3499],[16,3500,16,3519],[16,3520,16,3539],[16,3540,16,3559],[16,3560,16,3579],[16,3580,16,3599],[16,3600,16,3619],[16,3620,16,3639],[16,3640,16,3659],[16,3660,16,3679],[16,3680,16,3699],[16,3700,16,3719],[16,3720,16,3739],[16,3740,16,3759],[16,3760,16,3779],[16,3780,16,3799],[16,3800,16,3819],[16,3820,16,3839],[16,3840,16,3859],[16,3860,16,3879],[16,3880,16,3899],[16,3900,16,3919],[16,3920,16,3939],[16,3940,16,3959],[16,3960,16,3979],[16,3980,16,3999],[16,4000,16,4019],[16,4020,16,4039],[16,4040,16,4059],[16,4060,16,4079],[16,4080,16,4099],[16,4100,16,4119],[16,4120,16,4139],[16,4140,16,4159],[16,4160,16,4179],[16,4180,16,4199],[16,4200,16,4219],[16,4220,16,4239],[16,4240,16,4259],[16,4260,16,4279],[16,4280,16,4299],[16,4300,16,4319],[16,4320,16,4339],[16,4340,16,4359],[16,4360,16,4379],[16,4380,16,4399],[16,4400,16,4419],[16,4420,16,4439],[16,4440,16,4459],[16,4460,16,4479],[16,4480,16,4499],[16,4500,16,4519],[16,4520,16,4539],[16,4540,16,4559],[16,4560,16,4579],[16,4580,16,4599],[16,4600,16,4619],[16,4620,16,4639],[16,4640,16,4659],[16,4660,16,4679],[16,4680,16,4699],[16,4700,16,4719],[16,4720,16,4739],[16,4740,16,4759],[16,4760,16,4779],[16,4780,16,4799],[16,4800,16,4819],[16,4820,16,4839],[16,4840,16,4859],[16,4860,16,4879],[16,4880,16,4899],[16,4900,16,4919],[16,4920,16,4939],[16,4940,16,4959],[16,4960,16,4979],[16,4980,16,4999],[16,5000,16,5019],[16,5020,16,5039],[16,5040,16,5059],[16,5060,16,5079],[16,5080,16,5099],[16,5100,16,5119],[16,5120,16,5139],[16,5140,16,5159],[16,5160,16,5179],[16,5180,16,5199],[16,5200,16,5219],[16,5220,16,5239],[16,5240,16,5259],[16,5260,16,5279],[16,5280,16,5299],[16,5300,16,5319],[16,5320,16,5339],[16,5340,16,5359],[16,5360,16,5379],[16,5380,16,5399],[16,5400,16,5419],[16,5420,16,5439],[16,5440,16,5459],[16,5460,16,5479],[16,5480,16,5499],[16,5500,16,5519],[16,5520,16,5539],[16,5540,16,5559],[16,5560,16,5579],[16,5580,16,5599],[16,5600,16,5619],[16,5620,16,5639],[16,5640,16,5659],[16,5660,16,5679],[16,5680,16,5699],[16,5700,16,5719],[16,5720,16,5739],[16,5740,16,5759],[16,5760,16,5779],[16,5780,16,5799],[16,5800,16,5819],[16,5820,16,5839],[16,5840,16,5859],[16,5860,16,5879],[16,5880,16,5899],[16,5900,16,5919],[16,5920,16,5939],[16,5940,16,5959],[16,5960,16,5979],[16,5980,16,5999],[16,6000,16,6019],[16,6020,16,6039],[16,6040,16,6059],[16,6060,16,6079],[16,6080,16,6099],[16,6100,16,6119],[16,6120,16,6139],[16,6140,16,6159],[16,6160,16,6179],[16,6180,16,6199],[16,6200,16,6219],[16,6220,16,6239],[16,6240,16,6259],[16,6260,16,6279],[16,6280,16,6299],[16,6300,16,6319],[16,6320,16,6339],[16,6340,16,6359],[16,6360,16,6379],[16,6380,16,6399],[16,6400,16,6419],[16,6420,16,6439],[16,6440,16,6459],[16,6460,16,6479],[16,6480,16,6499],[16,6500,16,6519],[16,6520,16,6539],[16,6540,16,6559],[16,6560,16,6579],[16,6580,16,6599],[16,6600,16,6619],[16,6620,16,6639],[16,6640,16,6659],[16,6660,16,6679],[16,6680,16,6699],[16,6700,16,6719],[16,6720,16,6739],[16,6740,16,6759],[16,6760,16,6779],[16,6780,16,6799],[16,6800,16,6819],[16,6820,16,6839],[16,6840,16,6859],[16,6860,16,6879],[16,6880,16,6899],[16,6900,16,6919],[16,6920,16,6939],[16,6940,16,6959],[16,6960,16,6979],[16,6980,16,6999],[16,7000,16,7019],[16,7020,16,7039],[16,7040,16,7059],[16,7060,16,7079],[16,7080,16,7099],[16,7100,16,7119],[16,7120,16,7139],[16,7140,16,7159],[16,7160,16,7179],[16,7180,16,7199],[16,7200,16,7219],[16,7220,16,7239],[16,7240,16,7259],[16,7260,16,7279],[16,7280,16,7299],[16,7300,16,7319],[16,7320,16,7339],[16,7340,16,7359],[16,7360,16,7379],[16,7380,16,7399],[16,7400,16,7419],[16,7420,16,7439],[16,7440,16,7459],[16,7460,16,7479],[16,7480,16,7499],[16,7500,16,7519],[16,7520,16,7539],[16,7540,16,7559],[16,7560,16,7579],[16,7580,16,7599],[16,7600,16,7619],[16,7620,16,7639],[16,7640,16,7659],[16,7660,16,7679],[16,7680,16,7699],[16,7700,16,7719],[16,7720,16,7739],[16,7740,16,7759],[16,7760,16,7779],[16,7780,16,7799],[16,7800,16,7819],[16,7820,16,7839],[16,7840,16,7859],[16,7860,16,7879],[16,7880,16,7899],[16,7900,16,7919],[16,7920,16,7939],[16,7940,16,7959],[16,7960,16,7979],[16,7980,16,7999],[16,8000,16,8019],[16,8020,16,8039],[16,8040,16,8059],[16,8060,16,8079],[16,8080,16,8099],[16,8100,16,8119],[16,8120,16,8139],[16,8140,16,8159],[16,8160,16,8179],[16,8180,16,8199],[16,8200,16,8219],[16,8220,16,8239],[16,8240,16,8259],[16,8260,16,8279],[16,8280,16,8299],[16,8300,16,8319],[16,8320,16,8339],[16,8340,16,8359],[16,8360,16,8379],[16,8380,16,8399],[16,8400,16,8419],[16,8420,16,8439],[16,8440,16,8459],[16,8460,16,8479],[16,8480,16,8499],[16,8500,16,8519],[16,8520,16,8539],[16,8540,16,8559],[16,8560,16,8579],[16,8580,16,8599],[16,8600,16,8619],[16,8620,16,8639],[16,8640,16,8659],[16,8660,16,8679],[16,8680,16,8699],[16,8700,16,8719],[16,8720,16,8739],[16,8740,16,8759],[16,8760,16,8779],[16,8780,16,8799],[16,8800,16,8819],[16,8820,16,8839],[16,8840,16,8859],[16,8860,16,8879],[16,8880,16,8899],[16,8900,16,8919],[16,8920,16,8939],[16,8940,16,8959],[16,8960,16,8979],[16,8980,16,8999],[16,9000,16,9019],[16,9020,16,9039],[16,9040,16,9059],[16,9060,16,9079],[16,9080,16,9099],[16,9100,16,9119],[16,9120,16,9139],[16,9140,16,9159],[16,9160,16,9179],[16,9180,16,9199],[16,9200,16,9219],[16,9220,16,9239],[16,9240,16,9259],[16,9260,16,9279],[16,9280,16,9299],[16,9300,16,9319],[16,9320,16,9339],[16,9340,16,9359],[16,9360,16,9379],[16,9380,16,9399],[16,9400,16,9419],[16,9420,16,9439],[16,9440,16,9459],[16,9460,16,9479],[16,9480,16,9499],[16,9500,16,9519],[16,9520,16,9539],[16,9540,16,9559],[16,9560,16,9579],[16,9580,16,9599],[16,9600,16,9619],[16,9620,16,9639],[16,9640,16,9659],[16,9660,16,9679],[16,9680,16,9699],[16,9700,16,9719],[16,9720,16,9739],[16,9740,16,9759],[16,9760,16,9779],[16,9780,16,9799],[16,9800,16,9819],[16,9820,16,9839],[16,9840,16,9859],[16,9860,16,9879],[16,9880,16,9899],[16,9900,16,9919],[16,9920,16,9939],[16,9940,16,9959],[16,9960,16,9979],[16,9980,16,9999],[16,10000,16,10019],[16,10020,16,10039],[16,10040,16,10059],[16,10060,16,10079],[16,10080,16,10099],[16,10100,16,10119],[16,10120,16,10139],[16,10140,16,10159],[16,10160,16,10179],[16,10180,16,10199],[16,10200,16,10219],[16,10220,16,10239],[16,10240,16,10259],[16,10260,16,10279],[16,10280,16,10299],[16,10300,16,10319],[16,10320,16,10339],[16,10340,16,10359],[16,10360,16,10379],[16,10380,16,10399],[16,10400,16,10419],[16,10420,16,10439],[16,10440,16,10459],[16,10460,16,10479],[16,10480,16,10499],[16,10500,16,10519],[16,10520,16,10539],[16,10540,16,10559],[16,10560,16,10579],[16,10580,16,10599],[16,10600,16,10619],[16,10620,16,10639],[16,10640,16,10659],[16,10660,16,10679],[16,10680,16,10699],[16,10700,16,10719],[16,10720,16,10739],[16,10740,16,10759],[16,10760,16,10779],[16,10780,16,10799],[16,10800,16,10819],[16,10820,16,10839],[16,10840,16,10859],[16,10860,16,10879],[16,10880,16,10899],[16,10900,16,10919],[16,10920,16,10939],[16,10940,16,10959],[16,10960,16,10979],[16,10980,16,10999],[16,11000,16,11019],[16,11020,16,11039],[16,11040,16,11059],[16,11060,16,11079],[16,11080,16,11099],[16,11100,16,11119],[16,11120,16,11139],[16,11140,16,11159],[16,11160,16,11179],[16,11180,16,11199],[16,11200,16,11219],[16,11220,16,11239],[16,11240,16,11259],[16,11260,16,11279],[16,11280,16,11299],[16,11300,16,11319],[16,11320,16,11339],[16,11340,16,11359],[16,11360,16,11379],[16,11380,16,11399],[16,11400,16,11419],[16,11420,16,11439],[16,11440,16,11459],[16,11460,16,11479],[16,11480,16,11499],[16,11500,16,11519],[16,11520,16,11539],[16,11540,16,11559],[16,11560,16,11579],[16,11580,16,11599],[16,11600,16,11619],[16,11620,16,11639],[16,11640,16,11659],[16,11660,16,11679],[16,11680,16,11699],[16,11700,16,11719],[16,11720,16,11739],[16,11740,16,11759],[16,11760,16,11779],[16,11780,16,11799],[16,11800,16,11819],[16,11820,16,11839],[16,11840,16,11859],[16,11860,16,11879],[16,11880,16,11899],[16,11900,16,11919],[16,11920,16,11939],[16,11940,16,11959],[16,11960,16,11979],[16,11980,16,11999],[16,12000,16,12019],[16,12020,16,12039],[16,12040,16,12059],[16,12060,16,12079],[16,12080,16,12099],[16,12100,16,12119],[16,12120,16,12139],[16,12140,16,12159],[16,12160,16,12179],[16,12180,16,12199],[16,12200,16,12219],[16,12220,16,12239],[16,12240,16,12259],[16,12260,16,12279],[16,12280,16,12299],[16,12300,16,12319],[16,12320,16,12339],[16,12340,16,12359],[16,12360,16,12379],[16,12380,16,12399],[16,12400,16,12419],[16,12420,16,12439],[16,12440,16,12459],[16,12460,16,12479],[16,12480,16,12499],[16,12500,16,12519],[16,12520,16,12539],[16,12540,16,12559],[16,12560,16,12579],[16,12580,16,12599],[16,12600,16,12619],[16,12620,16,12639],[16,12640,16,12659],[16,12660,16,12679],[16,12680,16,12699],[16,12700,16,12719],[16,12720,16,12739],[16,12740,16,12759],[16,12760,16,12779],[16,12780,16,12799],[16,12800,16,12819],[16,12820,16,12839],[16,12840,16,12859],[16,12860,16,12879],[16,12880,16,12899],[16,12900,16,12919],[16,12920,16,12939],[16,12940,16,12959],[16,12960,16,12979],[16,12980,16,12999],[16,13000,16,13019],[16,13020,16,13039],[16,13040,16,13059],[16,13060,16,13079],[16,13080,16,13099],[16,13100,16,13119],[16,13120,16,13139],[16,13140,16,13159],[16,13160,16,13179],[16,13180,16,13199],[16,13200,16,13219],[16,13220,16,13239],[16,13240,16,13259],[16,13260,16,13279],[16,13280,16,13299],[16,13300,16,13319],[16,13320,16,13339],[16,13340,16,13359],[16,13360,16,13379],[16,13380,16,13399],[16,13400,16,13419],[16,13420,16,13439],[16,13440,16,13459],[16,13460,16,13479],[16,13480,16,13499],[16,13500,16,13519],[16,13520,16,13539],[16,13540,16,13559],[16,13560,16,13579],[16,13580,16,13599],[16,13600,16,13619],[16,13620,16,13639],[16,13640,16,13659],[16,13660,16,13679],[16,13680,16,13699],[16,13700,16,13719],[16,13720,16,13739],[16,13740,16,13759],[16,13760,16,13779],[16,13780,16,13799],[16,13800,16,13819],[16,13820,16,13839],[16,13840,16,13859],[16,13860,16,13879],[16,13880,16,13899],[16,13900,16,13919],[16,13920,16,13939],[16,13940,16,13959],[16,13960,16,13979],[16,13980,16,13999],[16,14000,16,14019],[16,14020,16,14039],[16,14040,16,14059],[16,14060,16,14079],[16,14080,16,14099],[16,14100,16,14119],[16,14120,16,14139],[16,14140,16,14159],[16,14160,16,14179],[16,14180,16,14199],[16,14200,16,14219],[16,14220,16,14239],[16,14240,16,14259],[16,14260,16,14279],[16,14280,16,14299],[16,14300,16,14319],[16,14320,16,14339],[16,14340,16,14359],[16,14360,16,14379],[16,14380,16,14399],[16,14400,16,14419],[16,14420,16,14439],[16,14440,16,14459],[16,14460,16,14479],[16,14480,16,14499],[16,14500,16,14519],[16,14520,16,14539],[16,14540,16,14559],[16,14560,16,14579],[16,14580,16,14599],[16,14600,16,14619],[16,14620,16,14639],[16,14640,16,14659],[16,14660,16,14679],[16,14680,16,14699],[16,14700,16,14719],[16,14720,16,14739],[16,14740,16,14759],[16,14760,16,14779],[16,14780,16,14799],[16,14800,16,14819],[16,14820,16,14839],[16,14840,16,14859],[16,14860,16,14879],[16,14880,16,14899],[16,14900,16,14919],[16,14920,16,14939],[16,14940,16,14959],[16,14960,16,14979],[16,14980,16,14999],[16,15000,16,15019],[16,15020,16,15039],[16,15040,16,15059],[16,15060,16,15079],[16,15080,16,15099],[16,15100,16,15119],[16,15120,16,15139],[16,15140,16,15159],[16,15160,16,15179],[16,15180,16,15199],[16,15200,16,15219],[16,15220,16,15239],[16,15240,16,15259],[16,15260,16,15279],[16,15280,16,15299],[16,15300,16,15319],[16,15320,16,15339],[16,15340,16,15359],[16,15360,16,15379],[16,15380,16,15399],[16,15400,16,15419],[16,15420,16,15439],[16,15440,16,15459],[16,15460,16,15479],[16,15480,16,15499],[16,15500,16,15519],[16,15520,16,15539],[16,15540,16,15559],[16,15560,16,15579],[16,15580,16,15599],[16,15600,16,15619],[16,15620,16,15639],[16,15640,16,15659],[16,15660,16,15679],[16,15680,16,15699],[16,15700,16,15719],[16,15720,16,15739],[16,15740,16,15759],[16,15760,16,15779],[16,15780,16,15799],[16,15800,16,15819],[16,15820,16,15839],[16,15840,16,15859],[16,15860,16,15879],[16,15880,16,15899],[16,15900,16,15919],[16,15920,16,15939],[16,15940,16,15959],[16,15960,16,15979],[16,15980,16,15999],[16,16000,16,16019],[16,16020,16,16039],[16,16040,16,16059],[16,16060,16,16079],[16,16080,16,16099],[16,16100,16,16119],[16,16120,16,16139],[16,16140,16,16159],[16,16160,16,16179],[16,16180,16,16199],[16,16200,16,16219],[16,16220,16,16239],[16,16240,16,16259],[16,16260,16,16279],[16,16280,16,16299],[16,16300,16,16319],[16,16320,16,16339],[16,16340,16,16359],[16,16360,16,16379],[16,16380,16,16383],[17,0,17,19],[17,20,17,39],[17,40,17,59],[17,60,17,79],[17,80,17,99],[17,100,17,119],[17,120,17,139],[17,140,17,159],[17,160,17,179],[17,180,17,199],[17,200,17,219],[17,220,17,239],[17,240,17,259],[17,260,17,279],[17,280,17,299],[17,300,17,319],[17,320,17,339],[17,340,17,359],[17,360,17,379],[17,380,17,399],[17,400,17,419],[17,420,17,439],[17,440,17,459],[17,460,17,479],[17,480,17,499],[17,500,17,519],[17,520,17,539],[17,540,17,559],[17,560,17,579],[17,580,17,599],[17,600,17,619],[17,620,17,639],[17,640,17,659],[17,660,17,679],[17,680,17,699],[17,700,17,719],[17,720,17,739],[17,740,17,759],[17,760,17,779],[17,780,17,799],[17,800,17,819],[17,820,17,839],[17,840,17,859],[17,860,17,879],[17,880,17,899],[17,900,17,919],[17,920,17,939],[17,940,17,959],[17,960,17,979],[17,980,17,999],[17,1000,17,1019],[17,1020,17,1039],[17,1040,17,1059],[17,1060,17,1079],[17,1080,17,1099],[17,1100,17,1119],[17,1120,17,1139],[17,1140,17,1159],[17,1160,17,1179],[17,1180,17,1199],[17,1200,17,1219],[17,1220,17,1239],[17,1240,17,1259],[17,1260,17,1279],[17,1280,17,1299],[17,1300,17,1319],[17,1320,17,1339],[17,1340,17,1359],[17,1360,17,1379],[17,1380,17,1399],[17,1400,17,1419],[17,1420,17,1439],[17,1440,17,1459],[17,1460,17,1479],[17,1480,17,1499],[17,1500,17,1519],[17,1520,17,1539],[17,1540,17,1559],[17,1560,17,1579],[17,1580,17,1599],[17,1600,17,1619],[17,1620,17,1639],[17,1640,17,1659],[17,1660,17,1679],[17,1680,17,1699],[17,1700,17,1719],[17,1720,17,1739],[17,1740,17,1759],[17,1760,17,1779],[17,1780,17,1799],[17,1800,17,1819],[17,1820,17,1839],[17,1840,17,1859],[17,1860,17,1879],[17,1880,17,1899],[17,1900,17,1919],[17,1920,17,1939],[17,1940,17,1959],[17,1960,17,1979],[17,1980,17,1999],[17,2000,17,2019],[17,2020,17,2039],[17,2040,17,2059],[17,2060,17,2079],[17,2080,17,2099],[17,2100,17,2119],[17,2120,17,2139],[17,2140,17,2159],[17,2160,17,2179],[17,2180,17,2199],[17,2200,17,2219],[17,2220,17,2239],[17,2240,17,2259],[17,2260,17,2279],[17,2280,17,2299],[17,2300,17,2319],[17,2320,17,2339],[17,2340,17,2359],[17,2360,17,2379],[17,2380,17,2399],[17,2400,17,2419],[17,2420,17,2439],[17,2440,17,2459],[17,2460,17,2479],[17,2480,17,2499],[17,2500,17,2519],[17,2520,17,2539],[17,2540,17,2559],[17,2560,17,2579],[17,2580,17,2599],[17,2600,17,2619],[17,2620,17,2639],[17,2640,17,2659],[17,2660,17,2679],[17,2680,17,2699],[17,2700,17,2719],[17,2720,17,2739],[17,2740,17,2759],[17,2760,17,2779],[17,2780,17,2799],[17,2800,17,2819],[17,2820,17,2839],[17,2840,17,2859],[17,3100,17,3119],[17,3120,17,3139],[17,3140,17,3159],[17,3160,17,3179],[17,3180,17,3199],[18,0,18,19],[19,0,19,19],[20,0,20,19],[32,0,32,19],[33,0,33,19],[34,0,34,19],[35,0,35,19],[36,0,36,19],[37,0,37,19],[38,0,38,19],[40,0,40,19],[41,0,41,19],[43,0,44,19],[46,0,46,19],[48,0,48,19],[50,0,50,19],[52,0,52,19],[65,0,65,19],[66,0,66,19],[67,0,67,19],[68,0,68,19],[69,0,69,19],[71,0,71,19]],"merged_total":9986,"flags":["merged_cut"]}
["Documentation - Example Calculation"]
["This tab describes the underlying calculations and references used to calculate the amount of methane avoided by preventing or avoiding the landfilling of food waste, including an example calculation. "]
["This tab specifically details the example calculations. Table 6 at the bottom includes methane fate for the example scencario. References for the calculator are included on the Sources tab."]
[]
["Example 1"]
["Note: Due to rounding, performing the calculations given in the equations below may not return the exact results shown."]
[]
["Using the methane generation amounts previously calculated for the first 10 years of the sample scenario, methane release amounts can be calculated. In this example methane released in the first year is calculated for 500 short tons of food waste."]
[]
[]
["Methane Generated"]
[]
["Year 1 (2025):  5.6 Metric tons CH_4 generated, see Table 4"]
[]
["Methane Destroyed"]
[]
["Gas Collection Efficiency: 0%"]
["Landfills with Gas Collection: 92.7%"]
["Destruction efficiency: 99%"]
[]
["5.6 metric tons  CH_4*0*0.927*0.99 = 0 metric tons  CH_4  destroyed"]
[]
["No methane is captured and destroyed since the gas collection system has not been implemented yet."]
[]
["Methane Oxidized"]
[]
["Gas Collection Efficiency: 0%"]
["Landfills with Gas Collection: 92.7%"]
["Methane Oxidation Amount: 10%"]
[]
["5.6 metric tons  CH_4*[(1-0)*0.927+0.0723]*0.10 = 0.6 metric tons  CH_4  oxidized"]
[]
["0.6 metric tons of methane is oxidized in the landfill cover for Year 1 (2025)."]
[]
["Methane Released"]
[]
["Since zero methane is captured and destroyed and 0.6 metric tons is oxidized, the balance amount is released."]
[]
["5.6-0-0.6 = 5.0 metric tons  CH_4  released"]
[]
["Example 2"]
["Note: Due to rounding, performing the calculations given in the equations below may not return the exact results shown."]
[]
["Using the methane generation amounts previously calculated for the first 10 years of the sample scenario (where 500 tons of food waste is landfilled), methane release amounts can be calculated. Unlike Example 1, which calculated methane releases in the initial placement year, in Year 6 the gas collection system is installed and some methane is capture and destroyed."]
[]
[]
["Methane Generated"]
[]
["Year 6 (2030):  2.2 Metric tons CH_4 generated, see Table 4"]
[]
["Methane Destroyed"]
[]
["Gas Collection Efficiency: 0%"]
["Landfills with Gas Collection: 92.7%"]
["Destruction efficiency: 99%"]
[]
["2.2  metric tons  CH_4*0.5*0.927*0.99 = 1.0 metric tons  CH_4  destroyed"]
[]
["1.0 metric tons of methane is captured and destroyed for Year 6 (2030)."]
[]
["Methane Oxidized"]
[]
["Gas Collection Efficiency: 0%"]
["Landfills with Gas Collection: 92.7%"]
["Methane Oxidation Amount: 25%"]
[]
["2.2 metric tons  CH_4*[(1-0.5)*0.927+0.0723]*0.25 = 0.3 metric tons  CH_4  oxidized"]
[]
["0.3 metric tons of methane is oxidized in the landfill cover for Year 6 (2030)."]
[]
["Methane Released"]
[]
["Since 1.0 metric tons of methane is captured and destroyed and 0.3 metric tons is oxidized, the balance amount is released."]
[]
["2.2-1.0-0.3 = 0.9 metric tons  CH_4  released"]
[]
["Table 6 below details methane fate for 500 short tons of food waste for the first 10 years. Please note that the listed gas collection schedule column and methane oxidation rate would only apply to food waste landfilled in Year 1 (2025). Due to rounding, the values in the table below may not add up exactly. "]
[]
[]
["Table 6. Sample Scenario of Food Waste Decay and Methane Fate for 500 Short Tons of Food Waste Avoided in Year 1"]
[]
["Year",null,"Initial Mass \n(Wet short tons)",null,"Food Waste Decayed \n(Wet short tons)",null,"Remaining Mass (Wet short tons)",null,"Methane Generated (Metric tons CH4)",null,"Capture Efficiency","Methane Captured per Year (Metric tons CH4)\n(Wet short tons)",null,"Methane Destroyed Per Year\n(Metric tons CH4)",null,"Methane Oxidation Rate","Methane Oxidized per year (Metric tons CH4)",null,"Methane Released per Year \n(Metric tons CH4)"]
[]
[]
["Year 1 / 2025",null,500,null,86.5,null,413.5,null,5.6,null,{"v":0,"d":"0%"},0,0,0,0,{"v":0.1,"d":"10%"},0.6,0.6,5,5]
["Year 2 / 2026",null,413.5,null,71.5,null,341.9,null,4.6,null,{"v":0,"d":"0%"},0,0,0,0,{"v":0.1,"d":"10%"},0.5,0.5,4.2,4.2]
["Year 3 / 2027",null,341.9,null,59.2,null,282.8,null,3.8,null,{"v":0,"d":"0%"},0,0,0,0,{"v":0.1,"d":"10%"},0.4,0.4,3.5,3.5]
["Year 4 / 2028",null,282.8,null,48.9,null,233.8,null,3.2,null,{"v":0,"d":"0%"},0,0,0,0,{"v":0.1,"d":"10%"},0.3,0.3,2.9,2.9]
["Year 5 / 2029",null,233.8,null,40.5,null,193.4,null,2.6,null,{"v":0,"d":"0%"},1.2,1.2,1.2,1.2,{"v":0.1,"d":"10%"},0.3,0.3,2.4,2.4]
["Year 6 / 2030",null,193.4,null,33.5,null,159.9,null,2.2,null,{"v":0.5,"d":"50%"},1,1,1,1,{"v":0.25,"d":"25%"},0.3,0.3,0.9,0.9]
["Year 7 / 2031",null,159.9,null,27.7,null,132.2,null,1.8,null,{"v":0.5,"d":"50%"},0.8,0.8,0.8,0.8,{"v":0.25,"d":"25%"},0.2,0.2,0.7,0.7]
["Year 8 / 2032",null,132.2,null,22.9,null,109.4,null,1.5,null,{"v":0.5,"d":"50%"},0.7,0.7,0.7,0.7,{"v":0.25,"d":"25%"},0.2,0.2,0.6,0.6]
["Year 9 / 2033",null,109.4,null,18.9,null,90.4,null,1.2,null,{"v":0.5,"d":"50%"},0.6,0.6,0.6,0.6,{"v":0.25,"d":"25%"},0.2,0.2,0.5,0.5]
["Year 10 / 2034",null,90.4,null,15.6,null,74.8,null,{"v":1,"d":"1.0"},null,{"v":0.5,"d":"50%"},0.5,0.5,0.5,0.5,{"v":0.25,"d":"25%"},0.1,0.1,0.4,0.4]

{"sheet":"Sources","index":6,"n_rows":8,"n_cols":1,"rows_kept":8,"merged":[[1,0,1,23],[2,0,2,23],[3,0,3,23],[4,0,4,23],[5,0,5,23],[6,0,6,23],[7,0,7,23]]}
["Sources"]
["IPCC (2019). 2019 Refinement to the 2006 IPCC Guidelines for National Greenhouse Gas Inventories, Chapter 3 Solid Waste Disposal. https://www.ipcc-nggip.iges.or.jp/public/2019rf/pdf/5_Volume5/19R_V5_3_Ch03_SWDS.pdf"]
["U.S. EPA. (2020a). Documentation for Greenhouse Gas Emission and Energy Factors Used in the Waste Reduction Model (WARM).  https://www.epa.gov/sites/default/files/2020-12/documents/warm_background_v15_10-29-2020.pdf "]
["U.S. EPA. (2020b). Documentation for Greenhouse Gas Emission and Energy Factors Used in the Waste Reduction Model (WARM). https://www.epa.gov/sites/default/files/2020-12/documents/warm_management_practices_v15_10-29-2020.pdf"]
["U.S. EPA. (2023a). Quantifying Methane Emissions from Landfilled Food Waste (EPA-600-R-23-064). Office of Research and Development. https://www.epa.gov/system/files/documents/2023-10/food-waste-landfill-methane-10-8-23-final_508-compliant.pdf  "]
["U.S. EPA. (2023b). Catalog of IPCC AR4, AR5, and AR6 20-, 100-, and 500-year GWPs https://catalog.data.gov/dataset/ipcc-ar4-ar5-and-ar6-20-100-and-500-year-gwps  "]
["U.S. EPA. (2023c). From Field to Bin: The Environmental Impacts of U.S. Food Waste Management Pathways. https://www.epa.gov/system/files/documents/2023-10/part2_wf-pathways_report_formatted_no-appendices_508-compliant.pdf"]
["U.S. EPA (2024). Landfill Methane Outreach Program Database. https://www.epa.gov/lmop/lmop-landfill-and-project-database   "]