{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Introduction","Table of Contents","Operations in Inventory","Direct - Fuel Combust.","Mobile & Transportation","Waste Mngmt.","CHP Allocation","Indirect - Energy Imports","Indirect - Energy Exports","Summary Table","Custom Emission Factors","Energy content","Conversion Factors","Biomass Combustion CO2","GWPs","Revisions"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":3,"defined_names":126,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[24,2,24,7],[26,3,26,8],[27,3,27,8],[28,3,28,8],[0,1,0,10],[1,2,1,8],[3,2,5,10],[6,2,6,7],[7,2,8,7],[22,2,22,7]]}
[null,"NCASI Spreadsheet for Calculating GHG Emissions from \nWood Products Manufacturing Facilities\n\nEnglish Units\n\nWorkbook Version 1.1 (see below for USER AGREEMENT)"]
[null,null,"An aid to developing estimates using the methods in \"Calculation tools for estimating greenhouse gas emissions from wood products manufacturing facilities,\" Report Version 1.0"]
[]
[null,null,"This tool intends to facilitate the calculation of direct CO2, CH4, and N2O emissions from wood products manufacturing facilities and ancillary operations.  It also addresses emissions attributable to the purchase and export of electricity and/or steam. \n\n"]
[]
[]
[]
[null,null,"The example reporting format provided in the \"Calculation tools for estimating greehouse gas emissions from wood products manufacturing facilities\" can be achieved by printing the following completed worksheets:"]
[]
[null,null,null,"Operations in Inventory"]
[null,null,null,"Direct - Fuel Combust.",null,null,"EXPLANATION OF CELL COLOR SCHEME"]
[null,null,null,"Direct - Mobile & Transportation"]
[null,null,null,"Direct - Waste Mngmt.",null,null,null,"User entry"]
[null,null,null,"CHP allocation",null,null,null,"Calculated value"]
[null,null,null,"Indirect - Energy Imports"]
[null,null,null,"Indirect - Energy Exports"]
[null,null,null,"Summary Table"]
[null,null,null,"Supporting Information on Biomass"]
[]
[null,null,"Global warming potentials used in this tool are:",null,null,{"$f":"GWP_CH4_AR6","v":27.9},"lb CO2 eq./lb CH4"]
[null,null,null,null,null,{"$f":"GWP_N2O_AR6","v":273},"lb CO2 eq./lb N2O"]
[]
[null,null,"This spreadsheet was developed by NCASI with some material from WRI and WBCSD.  Questions or comments on this material can be directed to:\n\nBarry Malmberg\nNCASI \nPO Box 271\nSheridan, WY, USA 82801\nphone: (541) 249-3986\ne-mail:  bmalmberg@ncasi.org"]
[]
[null,null,"User Agreement:  By using the Spreadsheets and associated materials in any manner, the User agrees to the following terms of this agreement:"]
[]
[null,null,"1 ","Copyright:  Portions of the spreadsheets and associated materials were developed by WRI, WBCSD or NCASI, are copyrighted, and are published here with the permission of those developers.  The User acknowledges these copyrights.  "]
[null,null,"2 ","Acknowledgement:  The User agrees to acknowledge WRI, WBCSD, and NCASI for their roles in developing the Spreadsheets whenever the User authors reports or publications based in whole or in part on the use of the Spreadsheets.  "]
[null,null,"3 ","Disclaimer: These Spreadsheets and associated materials have been prepared with a high degree of expertise and professionalism, and it is believed that the Spreadsheets provide a useful and accurate approach for calculating greenhouse gas emissions.  However, the organizations involved in their development, including WRI, WBCSD, and NCASI, collectively and individually, do not warrant these Spreadsheets for any purpose, nor do they make any representations regarding their fitness for any use or purpose whatsoever.  Each User agrees to decide if, when and how to use the Spreadsheets, and does so at his or her sole risk.  Under no circumstances shall WRI, WBCSD, or NCASI be liable for any damages, including incidental, special or consequential damages, arising from the use of these Spreadsheets or an inability to use them.  "]

{"sheet":"Table of Contents","index":1,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[19,3,19,8],[20,3,20,8],[21,3,21,8],[22,3,22,8],[6,3,6,7],[9,3,9,7],[10,3,10,7],[11,3,11,7],[13,3,13,6],[14,3,14,5]]}
[null,"TABLE OF CONTENTS"]
[null,null,"Name of worksheet","Content / purpose"]
[]
[null,null,"Introduction"]
[null,null,"Table of Contents"]
[null,null,"Operations in Inventory","Describing the inventory boundaries and listing the operations included in the inventory"]
[null,null,"Direct - Fuel Combust.","Direct emissions of CO2, CH4, and N2O resulting from fuel combustion in stationary devices - includes emission factors from IPCC"]
[null,null,"Mobile & Transportation","Emissions of CO2, CH4, and N2O from fuel combustion in mobile equipment and transportation devices"]
[null,null,"Waste Mngmt.","Emissions of CH4 resulting from mill-owned landfills or anaerobic treatment operations"]
[null,null,"CHP Allocation","Allocation emissions from combined heat and power systems"]
[null,null,"Indirect - Energy Imports","GHG emissions resulting from electricity and /or steam imports"]
[null,null,"Indirect - Energy Exports","GHG emission impacts associated with electricity and /or steam exports"]
[null,null,"Summary Table","Summarizes results of inventory"]
[null,null,"Custom Emission Factors","Calculating custom emission factors"]
[null,null,"Energy Content","Fuel specific higher heating values"]
[null,null,"Conversion Factors","Factors for converting among common units of measure"]
[null,null,"Supporting Info. on Biomass","Direct emissions of biomass CO2 for informational purposes only (do not include in GHG inventory)"]
[null,null,"GWPs","Global warming potentials from IPCC reports"]

{"sheet":"Operations in Inventory","index":2,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[14,5,14,6],[15,5,15,6],[17,5,17,6],[1,1,1,7],[4,1,4,5],[7,5,7,6],[8,5,8,6],[9,5,9,6],[12,5,12,6]]}
[null,"OPERATIONS IN INVENTORY"]
[null,"This worksheet is for showing which operations are included in the inventory"]
[null,null,null,null,null,"User enters information in spaces with this color  "]
[]
[null,"Operations in the Inventory"]
[]
[null,null,null,null,null,"Identifying name assigned to this inventory:"]
[]
[null,null,null,null,null,"Use this space to provide a general description of operational boundaries."]
[]
[]
[null,null,null,null,null,"Use this space to provide additional information helpful to understanding the operational boundaries of the inventory. "]
[]
[]
[null,null,null,null,null,"Use this space to provide additional information helpful to understanding how emissions from partial ownership situations are allocated. "]
[]
[]
[null,null,null,null,null,"The following information is not directly used in the GHG emissions calculations but is intended to provide clarification of the type of facility for which the inventory is being performed."]
[null,null,null,null,null,"Core Operations that might be included in the inventory are listed below","Place an \"X\" below where appropriate to indentify operations included in the inventory"]
[null,null,null,null,null,"Harvesting"]
[null,null,null,null,null,"Wood/chip/bark/other raw material transportation vehicles"]
[null,null,null,null,null,"Product, by-product or waste transportation vehicles"]
[null,null,null,null,null,"Debarking"]
[null,null,null,null,null,"Chipping"]
[null,null,null,null,null,"Mechanical pulping/refining"]
[null,null,null,null,null,"Thermal oil heaters"]
[null,null,null,null,null,"Natural gas direct-fired dryers"]
[null,null,null,null,null,"Other fossil fuel-fired dryers"]
[null,null,null,null,null,"On-site power and steam boilers"]
[null,null,null,null,null,"On-site combustion turbines"]
[null,null,null,null,null,"Air emissions control devices (e.g., RTOs, RCOs, ESPs, etc.)"]
[null,null,null,null,null,"Wastewater treatment operations"]
[null,null,null,null,null,"Sludge processing"]
[null,null,null,null,null,"Landfill receiving mill waste"]
[null,null,null,null,null,"On-site vehicles and machinery"]
[null,null,null,null,null,"Normal offices/workspace for mill employees"]
[null,null,null,null,null,"Imports of electrical power"]
[null,null,null,null,null,"Imports of steam or hot water"]
[null,null,null,null,null,"Exports of electrical power"]
[null,null,null,null,null,"Exports of steam or hot water"]
[null,null,null,null,null,"Other Operation – describe:"]
[null,null,null,null,null,"Other Operation – describe:"]
[null,null,null,null,null,"Other Operation – describe:"]
[null,null,null,null,null,"Other Operation – describe:"]

{"sheet":"Direct - Fuel Combust.","index":3,"n_rows":77,"n_cols":13,"rows_kept":77,"cut":false,"hidden":false,"merged":[[76,3,76,6],[74,3,74,6],[38,3,39,6],[41,2,41,7],[46,2,46,7],[54,2,54,7],[68,2,68,7],[3,2,3,6],[6,1,6,2],[7,1,7,2],[33,6,33,7],[11,8,11,11],[11,5,11,7],[15,5,15,7]]}
[]
[]
[null,null,"Direct Emissions - Stationary Fuel Combustion, (including methane and nitrous oxide emissions from biomass fuels)"]
[null,null,"Note: Emissions from mobile sources are reported on the \"Direct - Mobile & Transportation\" spreadsheet immediately behind this spreadsheet"]
[]
[null,"EXPLANATION OF CELL COLOR SCHEME"]
[null,"User entry"]
[null,"Calculated value"]
[]
[]
[null,"Direct Emissions - Stationary Fuel Combustion"]
[null,null,null,null,"Step 1","Step 2",null,null,"Step 3"]
[null,null,null,null,"A","B","C ","D","E","F","G","H"]
[null,null,null,null,"Quantity of fuel burned","CO2 emission factor\n[Emission factors from IPCC are shown below]","CH4 emission factor\n[Emission factors from IPCC are shown below]","N2O emission factor\n[Emission factors from IPCC are shown below]","CO2 emissions in metric tonnes","CH4 emissions in metric tonnes","N2O emissions in metric tonnes","Total emissions in terms of CO2 equivalents\n(metric tonnes)"]
[null,null,null,null,"(MMBtu HHV)","(lb CO2/MMBtu HHV)","(lb CH4/MMBtu HHV)","(lb N2O/MMBtu HHV)"]
[null,null,null,null,null,"IMPORTANT! For equations to function correctly, numerator of emission factors must be in terms of lb of GHG and denominator must match units of fuel quantity!!",null,null,"E = A * B / 2205","F = A * C / 2205","G = A * D / 2205","H = E + (F*GWP_CH4) + (G*GWP_N2O)"]
[null,null,"Example: Source 1","Natural gas",100000,117,2.8999999999999998E-3,2.0000000000000001E-4,{"$f":"$E17*F17/2205","v":5306.1224489795923},{"$f":"$E17*G17/2205","v":0.13151927437641722},{"$f":"$E17*H17/2205","v":9.0702947845804991E-3},{"$f":"I17+(J17*GWP_CH4)+(K17*GWP_N2O)","v":5312.2680272108855}]
[null,null,"Source description","Fuel type"]
[null,null,null,null,null,null,null,null,{"$f":"$E19*F19/2205","v":0},{"$f":"$E19*G19/2205","v":0},{"$f":"$E19*H19/2205","v":0},{"$f":"I19+(J19*GWP_CH4)+(K19*GWP_N2O)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"$E20*F20/2205","v":0},0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,"CO2","CH4","N2O","CO2 Equivalents"]
[null,null,null,null,null,null,"Step 4: Sum GHG emissions: ",null,{"$f":"SUM(I19:I32)","v":0},{"$f":"SUM(J19:J32)","v":0},{"$f":"SUM(K19:K32)","v":0},{"$f":"SUM(L19:L32)","v":0},"metric tonnes"]
[]
[]
[]
[]
[null,null,null,"Emission factors for stationary sources from IPCC\nCO2 factors are Tier 1, CH4 and N2O factors are Tier 2 unless noted otherwise\n(corrected for unoxidized carbon unless noted otherwise)"]
[]
[null,null,"Fuel type","lb CO2 / MMBtu fuel*\n[based on higher heating value, gross calorific value]","lb CH4 / MMBtu fuel \n[based on higher heating value, gross calorific value]","lb N2O / MMBtu fuel \n[based on higher heating value, gross calorific value]","lb CO2 equiv. / MMBtu fuel*\n[based on higher heating value, gross calorific value]","Notes"]
[null,null,"Liquid fossil"]
[null,null,"Kerosene",157,null,null,{"$f":"D43+GWP_CH4*E43+GWP_N2O*F43","v":157},"IPCC does not provide CH4 or N2O emission factors"]
[null,null,"Distillate fuel in boilers\n(No.1, No.2, No.4 fuel oil and diesel)",162,4.0000000000000002E-4,8.9999999999999998E-4,{"$f":"D44+GWP_CH4*E44+GWP_N2O*F44","v":162.25685999999999}]
[null,null,"Residual fuel oil in boilers\n(No.5, No.6 fuel oil)",169,7.0000000000000001E-3,6.9999999999999999E-4,{"$f":"D45+GWP_CH4*E45+GWP_N2O*F45","v":169.38640000000001}]
[null,null,"LPG",138,null,null,{"$f":"D46+GWP_CH4*E46+GWP_N2O*F46","v":138},"IPCC does not provide CH4 or N2O emission factors"]
[null,null,"Gaseous fossil"]
[null,null,"Natural gas (dry) - boilers and IR dryers",117,2.8999999999999998E-3,2.0000000000000001E-4,{"$f":"D48+GWP_CH4*E48+GWP_N2O*F48","v":117.13551},"N2O factor is Tier 1"]
[null,null,"Natural gas (dry) - turbines",117,1E-3,2.0000000000000001E-4,117.0825,"N2O factor is Tier 1"]
[null,null,"Natural gas (dry) - Int. Comb. Engine\n2 - cycle lean burn",117,3.5999999999999997E-2,2.0000000000000001E-4,118.059,"N2O factor is Tier 1"]
[null,null,"Natural gas (dry) - Int. Comb. Engine\n4 - cycle lean burn",117,2.7E-2,2.0000000000000001E-4,117.80789999999999,"N2O factor is Tier 1"]
[null,null,"Natural gas (dry) - Int. Comb. Engine\n4 - cycle rich burn",117,6.1000000000000004E-3,2.0000000000000001E-4,117.22479,"N2O factor is Tier 1"]
[null,null,"Natural Gas\nOther Combustion Devices",117,0.01,2.0000000000000001E-4,117.33359999999999,"CH4 and N2O factors are Tier 1"]
[null,null,"Propane**","139 (USDOE 2003)",null,null,"139 (USDOE 2003)","USDOE does not provide CH4 nor N2O emission factors"]
[null,null,"Solid fossil"]
[null,null,"Anthracite",213,0.02,3.0999999999999999E-3,{"$f":"D56+GWP_CH4*E56+GWP_N2O*F56","v":214.40430000000001},"CH4 and N2O factors are Tier 1"]
[null,null,"Bituminous coal\nOverfeed stoker boiler",205,2E-3,3.5000000000000001E-3,206.01130000000001]
[null,null,"Bituminous coal\nUnderfeed stoker boiler",205,3.1E-2,3.5000000000000001E-3,206.82040000000001]
[null,null,"Bituminous coal - Pulverized\nDry bottom, wall fired",205,1.5E-3,3.5000000000000001E-3,205.99735000000001]
[null,null,"Bituminous coal - Pulverized\nDry bottom, tangential firing",205,1.5E-3,1E-3,205.31485000000001]
[null,null,"Bituminous coal - Pulverized\nWet bottom",205,2E-3,3.5000000000000001E-3,206.01130000000001]
[null,null,"Bituminous coal\nSpreader stoker boiler",205,2E-3,3.5000000000000001E-3,206.01130000000001]
[null,null,"Bituminous coal - fluidized bed\nCirculating or bubbling",205,2E-3,0.21,262.38580000000002]
[null,null,"Sub-bituminous coal\nOverfeed stoker boiler",208,2E-3,3.5000000000000001E-3,209.01130000000001]
[null,null,"Sub-bituminous coal\nUnderfeed stoker boiler",208,3.1E-2,3.5000000000000001E-3,209.82040000000001]
[null,null,"Sub-bituminous coal - fluidized bed\nCirculating or bubbling",208,2E-3,0.21,265.38580000000002]
[null,null,"Lignite",219,0.02,3.0999999999999999E-3,220.40430000000001,"CH4 and N2O factors are Tier 1"]
[null,null,"Peat \n(CH4 and N2O factors are from biomass boilers)",232,2.7E-2,8.9999999999999993E-3,235.21029999999999,"Median values determined from a data set originating from a variety of sources, see Table 6, Section 9.2 of Calculation Tools for Estimating Greenhouse Gas Emissions from Wood Products Manufacturing Facilities."]
[null,null,"Biofuels"]
[null,null,"Wood and wood waste","Should not be included in GHG inventory.\nSee Spreadsheet on \"Supporting Info. On Biomass\"",2.7E-2,8.9999999999999993E-3,{"$f":"GWP_CH4*E70+GWP_N2O*F70","v":3.2102999999999997},"Median values determined from a data set originating from a variety of sources, see Table 6, Section 9.2 of Calculation Tools for Estimating Greenhouse Gas Emissions from Wood Products Manufacturing Facilities."]
[null,null,"Resinated Wood Residuals","CO2 produced from burning the resin in resinated wood residuals may be considered a greenhouse gas.  More information, including methods to estimate these emissions, are in Section 8.1.1 of the GHG Calculation Tools Report",2.7E-2,8.9999999999999993E-3,{"$f":"GWP_CH4*E71+GWP_N2O*F71","v":3.2102999999999997},"Median values determined from a data set originating from a variety of sources, see Table 6, Section 9.2 of Calculation Tools for Estimating Greenhouse Gas Emissions from Wood Products Manufacturing Facilities."]
[null,null,"* Includes a 2% correction (coal), 1% correction (petroleum products), or 0.5% correction (natural gas) for unoxidized carbon"]
[null,null,"** Not corrected for unoxidized carbon"]
[]
[null,null,"Sources:","Unless noted otherwise, all emission factors are from:  Intergovernmental Panel on Climate Change (IPCC).  1997.  Revised 1996 IPCC guidelines for national greenhouse gas inventories:  Reference manual (volume 3).  IPCC National Greenhouse Gas Inventory Program.  http://www.ipcc-nggip.iges.or.jp/public/gl/invs6.htm ( as of 2 July 2003).\nConverted from a LHV basis to a HHV basis using relations described in the report Calculation Tools for Estimating Greenhouse Gas Emissions from Wood Products Maufacturing Facilities"]
[]
[null,null,null,"United States Department of Energy (USDOE).  2003.  Instructions for Form EIA-1605 Voluntary Reporting of Greenhouse Gases For Data Through 2002.  Appendix B, Table B1.  U.S. Department of Energy Voluntary Reporting of Greenhouse Gases Energy Information Administration.  http://www.eia.doe.gov/pub/oiaf/1605/cdrom/pdf/1605INST02.pdf (14 Nov. 2003)"]

{"sheet":"Mobile & Transportation","index":4,"n_rows":110,"n_cols":29,"rows_kept":110,"cut":false,"hidden":false,"merged":[[17,6,17,7],[22,22,23,27],[95,24,98,28],[7,1,7,2],[4,2,4,11],[16,4,19,4],[8,1,8,2],[106,8,106,10],[106,11,106,13],[47,22,49,25],[78,4,78,5],[101,6,101,8],[94,25,94,27],[99,24,101,28],[82,6,82,8],[78,12,78,14],[78,9,78,11],[90,23,90,28],[78,6,78,8],[99,9,99,11],[99,12,99,14]]}
[null,null,"Direct or Indirect - Mobile and Transportation Source Emissions"]
[null,null,"Note: Emissions from stationary sources are reported on the \"Direct-Fuel Combust.\" spreadsheet immediately in front of this spreadsheet"]
[]
[]
[null,null,"This worksheet can be used to calculate emissions from mobile combustion sources, including transportation.\nThe worksheet contains two parts:\n    Part 1 is used to calculate transportation emissions based on quantity of fuels consumed.\n    Part 2 is used to calculate emissions from non-transportation mobile sources such as harvesting equipment.\n\nAvoid double counting!  If transportation emissions for a fleet are estimated using Part 1, do not also estimate emissions for this same fleet using Part 2.\n\nDo not include any combustion sources on this page that were already addressed in the \"Direct - Fuel Combust.\" sheet."]
[]
[null,"EXPLANATION OF CELL COLOR SCHEME"]
[null,"User entry"]
[null,"Calculated value"]
[]
[]
[]
[]
[null,"Part 1.  Transportation Emissions Calculated from Fuel Used:  All Modes of Transport ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q17>0,Q19>0),\"Enter mpg OR l/100km, not both!\",\"\")","v":""}]
[null,"Note:  Use this worksheet to calculate emissions from amount of fuel consumed. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Optional Calculator"]
[null,null,null,"A1","A2","B","C","D","E1","E2","F","G1","G2","H1","H2",null,1000," = Distance traveled","<<< enter this value"]
[null,null,null,null,"Fraction of total emissions claimed as direct for this entry (between 0 and 1)","Fuel used",null,null,"Energy used",null,null,"Emissions Factor",null,"Direct Emissions","Indirect Emissions",null,0," = miles per gallon"]
[null,null,null,null,null,null,"Type of Fuel Used",null,"MMBtu per Fuel Unit",null,"MMBtu energy","lb CO2 per MMBtu",null,"metric tonnes","metric tonnes",null,null,"        OR","<<< enter one of these"]
[null,null,null,null,null,"Amount of","Fuel","Fuel","From API","Custom","Used","From IPCC*","Custom","H1 =A2xFxG/2205","H2 =(1-A2)xFxG/2205",null,30," = litres per 100 km"]
[null,null,null,"Source Description",null,"fuel used","Units","Type","MMBtu HHV /unit","MMBtu/unit","F = B x E","lb CO2/MMBtu HHV","lb CO2/MMBtu","Metric ton  CO2","Metric ton  CO2",null,{"$f":"IF(AND(Q17>0,Q19>0),\"Error\",IF(Q17>0,Q16/Q17,Q16/100*Q19))","v":300},{"$f":"IF(Q17>0,\"Gallons used\",\"litres used\")","v":"litres used"},"<<< calculated"]
[null,null,"Road transportation",null,null,null,null,null,null,null,{"$f":"SUM(K23:K37)","v":0},null,null,{"$f":"SUM(N23:N37)","v":0},{"$f":"SUM(O23:O37)","v":0},null,{"$f":"IF(AND(Q17>0,Q19>0),\"Enter mpg OR l/100km, not both!\",\"\")","v":""}]
[null,null,"Example >>>","Sample fleet",0.8,30000,"US gals","Gasoline",0.13,null,{"$f":"F22*IF(J22=0,I22,J22)","v":3900},152,null,{"$f":"E22*K22*IF(M22=0,L22,M22)/2205","v":215.0748299319728},{"$f":"(1-E22)*K22*IF(M22=0,L22,M22)/2205","v":53.768707482993186},null,null,null,null,null,null,null,"Emission factors from Revised 1996 IPCC Guidelines for National Greenhouse Gas Inventories: Workbook (Volume 2), if not otherwise noted."]
[null,null,null,null,null,null,"US gals","Gasoline",0.13,null,0,152,null,0,0,null,null,null,null,null,null,null,"Higher heating values and densities from American Petroleum Institute (API), Compendium of Greenhouse Gas Emissions Estimation Methodologies for the Oil & Gas Industry (Pilot Test Version), 2001"]
[null,null,null,null,null,null,"Imp. gals","Gasoline",0.156,null,0,152,null,0,0]
[null,null,null,null,null,null,"litres","Gasoline",3.4299999999999997E-2,null,0,152,null,0,0]
[null,null,null,null,null,null,"litres","Gasoline",3.4299999999999997E-2,null,0,152,null,0,0,null,null,null,null,null,null,null,"Fuel","lb CO2 / MMBtu HHV*","Higher Heating Values","Typical density"]
[null,null,null,null,null,null,"Metric tonnes","Gasoline",46.4,null,0,152,null,0,0,null,null,null,null,null,null,null,null,null,"(units converted)"]
[null,null,null,null,null,null,"US gals","Diesel",0.13700000000000001,null,0,162,null,0,0]
[null,null,null,null,null,null,"Imp. gals","Diesel",0.16500000000000001,null,0,162,null,0,0,null,null,null,null,null,null,null,"Gasoline / petrol",152,"0.130 MMBtu/gal","6.17 lb/gal"]
[null,null,null,null,null,null,"litres","Diesel",3.6200000000000003E-2,null,0,162,null,0,0,null,null,null,null,null,null,null,"Kerosene",157,"0.135 MMBtu/gal","6.76 lb/gal"]
[null,null,null,null,null,null,"Metric tonnes","Diesel",42.6,null,0,162,null,0,0,null,null,null,null,null,null,null,"Jet Fuel**","156 (USDOE 2003)"]
[null,null,null,null,null,null,"lbs.","CNG",2.3699999999999999E-2,null,0,117,null,0,0,null,null,null,null,null,null,null,"Aviation gasoline**","153 (USDOE 2003)"]
[null,null,null,null,null,null,"kg","CNG",5.2200000000000003E-2,null,0,117,null,0,0,null,null,null,null,null,null,null,"Diesel",162,"0.137 MMBtu/gal","7.10 lb/gal"]
[null,null,null,null,null,null,"lbs.","LPG",2.0799999999999999E-2,null,0,138,null,0,0,null,null,null,null,null,null,null,"Distillate fuel oil No.1",162,"0.140 MMBtu/gal","7.05 lb/gal"]
[null,null,null,null,null,null,"kg","LPG",4.58E-2,null,0,138,null,0,0,null,null,null,null,null,null,null,"Distillate fuel oil No.2",162,"0.140 MMBtu/gal","7.05 lb/gal"]
[null,null,null,null,null,null,"US gals","LPG",0.94,null,0,138,null,0,0,null,null,null,null,null,null,null,"Residual Fuel oil#4",169,"0.143 MMBtu/gal","7.59 lb/gal"]
[null,null,null,null,null,null,"litres","LPG",2.4799999999999999E-2,null,0,138,null,0,0,null,null,null,null,null,null,null,"Residual Fuel oil#5",169,"0.150 MMBtu/gal","7.93 lb/gal"]
[null,null,"Rail transportation ",null,null,null,null,null,null,null,{"$f":"SUM(K39:K53)","v":0},null,null,{"$f":"SUM(N39:N53)","v":0},{"$f":"SUM(O39:O53)","v":0},null,null,null,null,null,null,null,"Residual Fuel oil#6",169,"0.153 MMBtu/gal","8.45 lb/gal"]
[null,null,null,null,null,null,"US gals","Gasoline",0.13,null,{"$f":"F39*IF(J39=0,I39,J39)","v":0},152,null,{"$f":"E39*K39*IF(M39=0,L39,M39)/2205","v":0},{"$f":"(1-E39)*K39*IF(M39=0,L39,M39)/2205","v":0},null,null,null,null,null,null,null,"LPG",138,"0.0940 MMBtu/gal","4.52 lb/gal (liquid)"]
[null,null,null,null,null,null,"Imp. gals","Gasoline",0.156,null,0,152,null,0,0,null,null,null,null,null,null,null,"Anthracite",213,"0.0125 MMBtu/lb"]
[null,null,null,null,null,null,"litres","Gasoline",3.4299999999999997E-2,null,0,152,null,0,0,null,null,null,null,null,null,null,"Bituminous coal",205,"0.0135 MMBtu/lb"]
[null,null,null,null,null,null,"Metric tonnes","Gasoline",46.4,null,0,152,null,0,0,null,null,null,null,null,null,null,"Propane**","139 (USDOE 2003)","0.0905 MMBtu/gal","4.24 lb/gal (liquid)"]
[null,null,null,null,null,null,"US gals","Diesel",0.13700000000000001,null,0,162,null,0,0,null,null,null,null,null,null,null,"Sub-bituminous coal",208,"0.00874 MMBtu/lb"]
[null,null,null,null,null,null,"Imp. gals","Diesel",0.16500000000000001,null,0,162,null,0,0,null,null,null,null,null,null,null,"Natural gas***",117,"1050 Btu/ft3","0.042 lb/ft3"]
[null,null,null,null,null,null,"litres","Diesel",3.6200000000000003E-2,null,0,162,null,0,0,null,null,null,null,null,null,null,"*Emission factors include a 2% correction (coal), 1% correction (petroleum products), or 0.5% correction (natural gas) for unoxidized carbon"]
[null,null,null,null,null,null,"Metric tonnes","Diesel",42.6,null,0,162,null,0,0,null,null,null,null,null,null,null,"** Not corrected for unoxidized carbon"]
[null,null,null,null,null,null,"US gals","Residual #4",0.14299999999999999,null,0,169,null,0,0,null,null,null,null,null,null,null,"*** Based on \"standard conditions\" of 60oF (15.6oC) and 1 atm pressure, per API"]
[null,null,null,null,null,null,"Imp gals","Residual #4",0.17199999999999999,null,0,169,null,0,0,null,null,null,null,null,null,null,"‡Calculated from data in Instructions for Form EIA-1605b Voluntary Reporting of Greenhouse Gases, for Data Through 2002, US Department of Energy, Energy Information Administration, Form EIA-1605 (2003), OMB No. 1905-0194, Appendix B, Page 48, available on the internet at ftp://ftp.eia.doe.gov/pub/oiaf/1605/cdrom/pdf/1605INSTR02.pdf (31 October 2003)"]
[null,null,null,null,null,null,"Barrels","Residual #4",6.01,null,0,169,null,0,0]
[null,null,null,null,null,null,"Metric tonnes","Residual #4",42.2,null,0,169,null,0,0]
[null,null,null,null,null,null,"Short tons","Bituminous Coal",27,null,0,205,null,0,0]
[null,null,null,null,null,null,"Metric tonnes","Bituminous Coal",29.8,null,0,205,null,0,0]
[null,null,null,null,null,null,null,"Other fuel",null,null,0,null,null,0,0]
[null,null,"Water transportation ",null,null,null,null,null,null,null,{"$f":"SUM(K55:K69)","v":0},null,null,{"$f":"SUM(N55:N69)","v":0},{"$f":"SUM(O55:O69)","v":0}]
[null,null,null,null,null,null,"US gals","Gasoline",0.13,null,{"$f":"F55*IF(J55=0,I55,J55)","v":0},152,null,{"$f":"E55*K55*IF(M55=0,L55,M55)/2205","v":0},{"$f":"(1-E55)*K55*IF(M55=0,L55,M55)/2205","v":0}]
[null,null,null,null,null,null,"Imp. gals","Gasoline",0.156,null,0,152,null,0,0]
[null,null,null,null,null,null,"litres","Gasoline",3.4299999999999997E-2,null,0,152,null,0,0]
[null,null,null,null,null,null,"Metric tonnes","Gasoline",46.4,null,0,152,null,0,0]
[null,null,null,null,null,null,"US gals","Diesel",0.13700000000000001,null,0,162,null,0,0]
[null,null,null,null,null,null,"Imp. gals","Diesel",0.16500000000000001,null,0,162,null,0,0]
[null,null,null,null,null,null,"litres","Diesel",3.6200000000000003E-2,null,0,162,null,0,0]
[null,null,null,null,null,null,"Metric tonnes","Diesel",42.6,null,0,162,null,0,0]
[null,null,null,null,null,null,"US gals","Residual #4",0.14299999999999999,null,0,169,null,0,0]
[null,null,null,null,null,null,"Imp gals","Residual #4",0.17199999999999999,null,0,169,null,0,0]
[null,null,null,null,null,null,"Barrels","Residual #4",6.01,null,0,169,null,0,0]
[null,null,null,null,null,null,"Metric tonnes","Residual #4",42.2,null,0,169,null,0,0]
[null,null,null,null,null,null,"Short tons","Bituminous Coal",27,null,0,205,null,0,0]
[null,null,null,null,null,null,"Metric tonnes","Bituminous Coal",29.8,null,0,205,null,0,0]
[null,null,null,null,null,null,null,"Other fuel",null,null,0,null,null,0,0]
[null,null,"Last row above totals enter no data here"]
[null,null,"Total transportation emissons based on fuel use >>>",null,null,null,null,null,null,null,null,null,null,{"$f":"(SUM(N23:N70)+N21)/2","v":0},{"$f":"(SUM(O23:O70)+O21)/2","v":0}]
[null,null,"*Emission factor includes a 2% correction (coal), 1% correction (petroleum products), or 0.5% correction (natural gas) for unoxidized carbon"]
[]
[]
[]
[null,null,"Part 2.  Emissions Associated with Mobile Equipment Based on Fuel Consumption "]
[null,"Fuel Combustion in mobile devices such as harvesting equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emission factors for mobile sources from IPCC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO2 factors are Tier 1, CH4 and N2O factors are Tier 2 unless noted otherwise"]
[null,null,null,null,"Step 1",null,"Step 2",null,null,"Step 3",null,null,"Step 4",null,null,null,null,null,null,null,null,null,null,null,"(Corrected for unoxidized carbon unless noted otherwise)"]
[null,null,null,null,"A1","A2","B","C ","D","E","F","G","H","I","J",null,null,null,null,null,null,null,null,"Fuel type","lb CO2 / MMBtu fuel*\n[based on higher heating value]","lb CH4 / MMBtu fuel \n[based on higher heating value]","lb N2O / MMBtu fuel \n[based on higher heating value]","lb CO2 equiv. / MMBtu fuel*\n[based on higher heating value]","Notes"]
[null,null,null,null,"Fraction of total emissions claimed as direct for this entry (between 0 and 1)","Quantity of fuel burned","CO2 emission factor\nEmission factors from IPCC are shown at right","CH4 emission factor\nEmission factors from IPCC are shown at right","N2O emission factor\nEmission factors from IPCC are shown at right","DIRECT\nCO2 emissions (metric tonnes)","DIRECT\nCH4 emissions (metric tonnes)","DIRECT\nN2O emissions (metric tonnes)","INDIRECT\nCO2 emissions (metric tonnes)","INDIRECT\nCH4 emissions (metric tonnes)","INDIRECT\nN2O emissions (metric tonnes)",null,null,null,null,null,null,null,null,"Liquid fossil"]
[null,null,null,null,null,"(MMBtu HHV)","(lb CO2/MMBtu HHV)","(lb CH4/MMBtu HHV)","(lb N2O/MMBtu HHV)","E = A1 × A2 × B / 2205","F = A1 × A2 × C / 2205","E = A1 × A2 × D / 2205","H = (1-A1) × A2 × B / 2205","I = (1-A1) × A2 × C / 2205","J = (1-A1) × A2 × D / 2205",null,null,null,null,null,null,null,null,"Gasoline / petrol\nMobile 4-stroke engines",152,0.1,4.0000000000000001E-3,{"$f":"Y82+GWP_CH4*Z82+GWP_N2O*AA82","v":155.88200000000001}]
[null,null,null,null,null,null,"IMPORTANT! For equations to function correctly, numerator of emission factors must be in terms of lb of GHG and denominator must match units of fuel quantity!!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gasoline / petrol\nMobile 2-stroke engines, general",152,0.28999999999999998,8.9999999999999998E-4,{"$f":"Y83+GWP_CH4*Z83+GWP_N2O*AA83","v":160.33670000000001}]
[null,null,"Example: Source 1","Natural gas",0.75,100000,117,0.01,2.0000000000000001E-4,{"$f":"$F84*$E84*G84/2205","v":3979.591836734694},{"$f":"$F84*$E84*H84/2205","v":0.3401360544217687},{"$f":"$F84*$E84*I84/2205","v":6.8027210884353739E-3},{"$f":"$F84*(1-$E84)*G84/2205","v":1326.5306122448981},{"$f":"$F84*(1-$E84)*H84/2205","v":0.11337868480725624},{"$f":"$F84*(1-$E84)*I84/2205","v":2.2675736961451248E-3},null,null,null,null,null,null,null,null,"Gasoline / petrol \nMobile 2-stroke engines, forestry",152,0.38,8.9999999999999998E-4,{"$f":"Y84+GWP_CH4*Z84+GWP_N2O*AA84","v":162.8477}]
[null,null,"Source description","Fuel type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kerosene",157,null,null,{"$f":"Y85+GWP_CH4*Z85+GWP_N2O*AA85","v":157},"IPCC does not provide CH4 nor N2O factors"]
[null,null,null,null,null,null,null,null,null,{"$f":"$F86*$E86*G86/2205","v":0},{"$f":"$F86*$E86*H86/2205","v":0},{"$f":"$F86*$E86*I86/2205","v":0},{"$f":"$F86*(1-$E86)*G86/2205","v":0},{"$f":"$F86*(1-$E86)*H86/2205","v":0},{"$f":"$F86*(1-$E86)*I86/2205","v":0},null,null,null,null,null,null,null,null,"Jet Fuel**","156 (USDOE 2003)",null,null,"67.2 (USDOE 2003)","USDOE does not provide CH4 nor N2O factors"]
[null,null,null,null,null,null,null,null,null,{"$f":"$F87*$E87*G87/2205","v":0},{"$f":"$F87*$E87*H87/2205","v":0},{"$f":"$F87*$E87*I87/2205","v":0},{"$f":"$F87*(1-$E87)*G87/2205","v":0},{"$f":"$F87*(1-$E87)*H87/2205","v":0},{"$f":"$F87*(1-$E87)*I87/2205","v":0},null,null,null,null,null,null,null,null,"Aviation gasoline**","153 (USDOE 2003)",null,null,"65.7 (USDOE 2003)","USDOE does not provide CH4 nor N2O factors"]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"Distillate fuel \n(No.1, No.2, No.4 fuel oil and diesel)\nMobile sources",162,8.9999999999999993E-3,6.6000000000000003E-2,{"$f":"Y88+GWP_CH4*Z88+GWP_N2O*AA88","v":180.26910000000001}]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"LPG",138,null,null,{"$f":"Y89+GWP_CH4*Z89+GWP_N2O*AA89","v":138},"IPCC does not provide CH4 nor N2O factors"]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"Propane**","139 (USDOE 2003)",null,null,"59.8 (USDOE 2003)","USDOE does not provide CH4 nor N2O factors"]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"Gaseous fossil"]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"Natural gas (dry)",117,0.01,2.0000000000000001E-4,{"$f":"Y92+GWP_CH4*Z92+GWP_N2O*AA92","v":117.33359999999999},"CH4 factor is Tier 1, N2O factor is Tier 1"]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"*Includes a 2% correction (coal), 1% correction (petroleum products), or 0.5% correction (natural gas) for unoxidized carbon"]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"** Not corrected for unoxidized carbon"]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,"Sources:  ","Unless noted otherwise, all emission factors are from:  Intergovernmental Panel on Climate Change (IPCC).  1997.  Revised 1996 IPCC guidelines for national greenhouse gas inventories:  Reference manual (volume 3).  IPCC National Greenhouse Gas Inventory Program.  http://www.ipcc-nggip.iges.or.jp/public/gl/invs6.htm ( as of 2 July 2003).\nConverted from a LHV basis to a HHV basis using relations described in the report Calculation Tools for Estimating Greenhouse Gas Emissions from Wood Products Maufacturing Facilities"]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"DIRECT EMISSIONS",null,null,"INDIRECT EMISSIONS",null,null,null,null,null,null,null,null,null,null,null,"United States Department of Energy (USDOE).  2003.  Instructions for Form EIA-1605 Voluntary Reporting of Greenhouse Gases For Data Through 2002.  Appendix B, Table B1.  U.S. Department of Energy Voluntary Reporting of Greenhouse Gases Energy Information Administration.  http://www.eia.doe.gov/pub/oiaf/1605/cdrom/pdf/1605INST02.pdf (14 Nov. 2003)"]
[null,null,null,null,null,null,null,null,null,"tonnes CO2","tonnes CH4","tonnes N2O","tonnes CO2","tonnes CH4","tonnes N2O"]
[null,null,null,null,null,null,"Total emissions from mobile equipment: ",null,null,{"$f":"SUM(J86:J99)","v":0},0,0,0,0,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"DIRECT EMISSIONS",null,null,"INDIRECT EMISSIONS"]
[null,null,null,null,null,null,null,null,"tonnes CO2","tonnes CH4","tonnes N2O","tonnes CO2","tonnes CH4","tonnes N2O"]
[null,null,null,null,null,null,null,"Grand Total of all Mobil and Transportation Emissions (sum of results from Parts 1 and 2):",{"$f":"SUM(N71,J102)","v":0},{"$f":"K102","v":0},{"$f":"L102","v":0},{"$f":"SUM(O71,M102)","v":0},{"$f":"N102","v":0},{"$f":"O102","v":0}]
[null,null,null,null,null,null,null,"Note: Do not double count emissions by estimating the same fuel consumption by two different methods above."]

{"sheet":"Waste Mngmt.","index":5,"n_rows":157,"n_cols":57,"rows_kept":157,"cut":false,"hidden":false,"merged":[[12,2,12,6],[48,2,48,11],[43,10,43,13],[122,2,122,5],[7,1,7,2],[8,1,8,2],[13,2,13,8],[15,4,15,13],[31,4,31,10],[152,4,152,9],[156,3,156,8],[27,8,27,11],[115,9,115,12],[45,10,45,13],[31,11,31,14],[29,2,29,11],[140,4,140,11],[138,2,138,5],[137,5,137,10],[54,2,54,4],[55,2,55,4],[125,4,125,12]]}
[null,null,"Direct or Indirect Emissions - Waste Management"]
[null,null,"For landfills and anaerobic wastewater treatment and sludge digestion systems"]
[null,null,"Note: Scroll down the page to find the spreadsheet for anaerobic treatment systems"]
[]
[]
[]
[null,"EXPLANATION OF CELL COLOR SCHEME"]
[null,"User entry"]
[null,"Calculated value"]
[]
[]
[null,null,"Note: On this sheet, Standard conditions refers to 0°C and 1 atm pressure"]
[null,null,"Methane emissions from landfills\nNote: Use only one of the following methods for each landfill."]
[null,null,"Method 1 - For landfills with low permeability caps and effective gas recovery systems \nwhere measurements are made of amounts of gas collected\nIT IS IMPORTANT TO NOT ESTIMATE EMISSIONS FOR A SINGLE LANDFILL BY MORE THAN ONE METHOD TO AVOID DOUBLE COUNTING!"]
[]
[null,null,null,null,"Step 1"]
[null,null,null,null,"A1","A2","B","C","D","E","F","G","H1","H2"]
[null,null,null,null,"Fraction of total emissions claimed as direct for this entry (between 0 and 1)","Quantity of gas collected\n[dry standard cubic feet/yr]","Efficiency of gas collection system\n[default = 0.75]","Fraction of collected gas that is burned\n[default = 1.0]","Methane content of gas\n[default = 0.5]","Fraction of uncollected methane that oxidizes in the landfill cover\n[default = 0.1]","Quantity of methane released\n[dry standard cubic feet/yr]","Methane emissions in metric tons ","Direct\nMethane emissions in metric tonnes","Indirect\nMethane emissions in metric tonnes"]
[null,null,null,null,null,null,null,null,null,null,"F=((A2/B)*(1-B)*D*(1-E))+(A*D*(1-C))","G = F * [0.042 lb/standard cubic foot] / [2205 lb/tonne]","H1 = A1 * G","H2 = (1-A1) * G"]
[null,null,"Example: Landfill A","Mill sludge, ash and misc.",0.5,29000000,0.75,0.9,0.47,0.1,{"$f":"((F20/G20)*(1-G20)*I20*(1-J20))+(F20*I20*(1-H20))","v":5452000},{"$f":"K20*0.042/2205","v":103.84761904761905},{"$f":"E20*L20","v":51.923809523809524},{"$f":"(1-E20)*L20","v":51.923809523809524}]
[null,null,"Landfill description","Waste type"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G22=0,0,((F22/G22)*(1-G22)*I22*(1-J22))+(F22*I22*(1-H22)))","v":0},{"$f":"K22*0.042/2205","v":0},{"$f":"E22*L22","v":0},{"$f":"(1-E22)*L22","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G23=0,0,((F23/G23)*(1-G23)*I23*(1-J23))+(F23*I23*(1-H23)))","v":0},{"$f":"K23*0.042/2205","v":0},{"$f":"E23*L23","v":0},{"$f":"(1-E23)*L23","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G24=0,0,((F24/G24)*(1-G24)*I24*(1-J24))+(F24*I24*(1-H24)))","v":0},{"$f":"K24*0.042/2205","v":0},{"$f":"E24*L24","v":0},{"$f":"(1-E24)*L24","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G25=0,0,((F25/G25)*(1-G25)*I25*(1-J25))+(F25*I25*(1-H25)))","v":0},{"$f":"K25*0.042/2205","v":0},{"$f":"E25*L25","v":0},{"$f":"(1-E25)*L25","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G26=0,0,((F26/G26)*(1-G26)*I26*(1-J26))+(F26*I26*(1-H26)))","v":0},{"$f":"K26*0.042/2205","v":0},{"$f":"E26*L26","v":0},{"$f":"(1-E26)*L26","v":0}]
[]
[null,null,null,null,null,null,null,null,"Step 2: Sum mill landfill methane emissions from Method 1: ",null,null,null,{"$f":"SUM(M22:M26)","v":0},{"$f":"SUM(N22:N26)","v":0},"metric tonnes CH4"]
[null,null,"Method 2 - For landfills that cannot use Method 1.  "]
[null,null,"Method 2 is applicable to landfills where the amounts of waste deposited are reasonably constant from year-to-year \nand the landfill design has not been changed in ways that would substantially alter landfill gas releases.\nIT IS IMPORTANT TO NOT ESTIMATE EMISSIONS FOR A SINGLE LANDFILL BY MORE THAN ONE METHOD TO AVOID DOUBLE COUNTING!"]
[]
[null,null,null,null,"Step 1",null,null,null,null,null,null,"Step 2"]
[null,null,null,null,"A1","A2","B","C","D","E","F","G","H","I","J","K","L1","L2"]
[null,null,null,null,"Fraction of total emissions claimed as direct for this entry (between 0 and 1)","Annual waste deposits\n[Dry short tons / year]","Ultimate Methane Potential, Lo, in\ncubic feet methane per dry short ton waste\n[default for mill waste = 3200 ft3/dry ton]","First order methane generation rate constant, k\n[default for mill waste = 0.03 per year","Years since landfill opened","Years since landfill stopped receiving waste","Quantity of methane generated\n[dry standard cubic feet/yr]","Fraction of uncollected methane that oxidizes in the landfill cover\n[default = 0.1]","Fraction of landfill gas that is collected","Fraction of collected landfill gas that is burned","Methane emissions in cubic feet per year","Methane emissions in metric tons ","Direct\nMethane emissions in metric tonnes ","Indirect\nMethane emissions in metric tonnes"]
[null,null,null,null,null,null,null,null,null,null,"F = A2 * B * (e^(-k*E) - e^(-k*D))",null,null,null,"J = (F*(1-H)*(1-G))+(F*H*(1-I))","K = J * [0.045 lb/standard cubic foot] / [2205 lb/tonne]","L1 = A1 * K","L2 = (1-A1) * K"]
[null,null,"Example: Landfill A","Mill sludge, ash and misc.",0.7,19300,3200,0.03,20,0,{"$f":"F36*G36*(EXP(-H36*J36)-EXP(-H36*I36))","v":27865393.354832929},0.1,0,0,{"$f":"(K36*(1-M36)*(1-L36))+(K36*M36*(1-N36))","v":25078854.019349635},{"$f":"O36*0.045/2205","v":511.81334733366594},{"$f":"E36*P36","v":358.26934313356617},{"$f":"(1-E36)*P36","v":153.54400420009981}]
[null,null,"Landfill description","Waste type"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"F38*G38*(EXP(-H38*J38)-EXP(-H38*I38))","v":0},null,null,null,{"$f":"(K38*(1-M38)*(1-L38))+(K38*M38*(1-N38))","v":0},{"$f":"O38*0.045/2205","v":0},{"$f":"E38*P38","v":0},{"$f":"(1-E38)*P38","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"F39*G39*(EXP(-H39*J39)-EXP(-H39*I39))","v":0},null,null,null,{"$f":"(K39*(1-M39)*(1-L39))+(K39*M39*(1-N39))","v":0},{"$f":"O39*0.045/2205","v":0},{"$f":"E39*P39","v":0},{"$f":"(1-E39)*P39","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"F40*G40*(EXP(-H40*J40)-EXP(-H40*I40))","v":0},null,null,null,{"$f":"(K40*(1-M40)*(1-L40))+(K40*M40*(1-N40))","v":0},{"$f":"O40*0.045/2205","v":0},{"$f":"E40*P40","v":0},{"$f":"(1-E40)*P40","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"F41*G41*(EXP(-H41*J41)-EXP(-H41*I41))","v":0},null,null,null,{"$f":"(K41*(1-M41)*(1-L41))+(K41*M41*(1-N41))","v":0},{"$f":"O41*0.045/2205","v":0},{"$f":"E41*P41","v":0},{"$f":"(1-E41)*P41","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"F42*G42*(EXP(-H42*J42)-EXP(-H42*I42))","v":0},null,null,null,{"$f":"(K42*(1-M42)*(1-L42))+(K42*M42*(1-N42))","v":0},{"$f":"O42*0.045/2205","v":0},{"$f":"E42*P42","v":0},{"$f":"(1-E42)*P42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direct","Indirect"]
[null,null,null,null,null,null,null,null,null,null,"Step 3: Sum mill landfill methane emissions from Method 2: ",null,null,null,null,null,{"$f":"SUM(Q38:Q42)","v":0},{"$f":"SUM(R38:R42)","v":0},"metric tonnes CH4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direct","Indirect"]
[null,null,"Sum of emissions from landfills >>",null,null,null,null,null,null,null,"Sum of mill landfill methane emissions from Methods 1, 2 & 3: ",null,null,null,null,null,{"$f":"IF(OR(G55=\"Invalid Year\",ISERROR(G55)),+M28+Q44,+M28+Q44+G55)","v":0},{"$f":"IF(OR(G55=\"Invalid Year\",ISERROR(G55)),+N28+R44,+N28+R44+G56)","v":0},"metric tonnes CH4"]
[]
[null,null,"Method 3 - For landfills that cannot use Methods 1 or 2.  "]
[null,null,"Method 3 is applicable to landfills where the amounts of waste deposited vary substantially from year-to-year \nand the landfill design has changed in ways that would substantially alter landfill gas releases.\n\nThis table for Method 3 can only estimate emissions from a single landfill.  If emissions from multiple landfills are to be estimated, \nmake a separate copy of this Excel worksheet for each additional landfill to be considered.  In this case, the user will have to manually \nsum all landfill emission estimates and enter this value in the appropriate cell of the \"Summary Table\" worksheet."]
[null,null,"Landfill description","Waste type","Fraction of total emissions claimed as direct for this entry (between 0 and 1)"]
[]
[null,null,"First year that material was deposited in landfill (or that data is available):"]
[null,null,"Last year that material was deposited in landfill (or that data is available):"]
[null,null,"Year of interest for emission estimate:"]
[null,null,"Estimated Direct Emissions [metric tonnes CH4]:",null,null,null,{"$f":"IF(G54>=G52,IF(ISERROR(LOOKUP(G54,H57:BE57,H59:BE59)),0,E51*LOOKUP(G54,H57:BE57,H59:BE59)),\"Invalid Year\")","v":0},"metric tonnes CH4"]
[null,null,"Estimated Indirect Emissions [metric tonnes CH4]:",null,null,null,{"$f":"IF(G54>=G52,IF(ISERROR(LOOKUP(G54,H57:BE57,H59:BE59)),0,(1-E51)*LOOKUP(G54,H57:BE57,H59:BE59)),\"Invalid Year\")","v":0},"metric tonnes CH4"]
[null,null,null,null,null,null,"Year Emissions Estimated",{"$f":"+IF(G52=\"\",\"\",G52)","v":""},{"$f":"+IF(ISERROR(AND(H57+1>$G53,H57+1>$G54)),\"\",IF((AND(H57+1>$G53,H57+1>$G54)),\"\",H57+1))","v":""},{"$f":"+IF(ISERROR(AND(I57+1>$G53,I57+1>$G54)),\"\",IF((AND(I57+1>$G53,I57+1>$G54)),\"\",I57+1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"Methane emissions in metric tons CO2 equivalents ",{"$f":"IF(ISERROR(H59*GWP_CH4),\"\",H59*GWP_CH4)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(ISERROR(AN59*GWP_CH4),\"\",AN59*GWP_CH4)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Methane emissions in metric tons ",{"$f":"IF(ISERROR(H60*0.045/2205),\"\",H60*0.045/2205)","v":0},{"$f":"IF(ISERROR(I60*0.045/2205),\"\",I60*0.045/2205)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Methane emissions in cubic feet per year",{"$f":"IF(ISERROR(H61*((1-H63)*(1-H62)+(H63*(1-H64)))),\"\",H61*((1-H63)*(1-H62)+(H63*(1-H64))))","v":0},{"$f":"IF(ISERROR(I61*((1-I63)*(1-I62)+(I63*(1-I64)))),\"\",I61*((1-I63)*(1-I62)+(I63*(1-I64))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Quantity of methane generated\n[dry standard cubic feet/yr]",{"$f":"IF(ISERROR(SUM(H$65:H$114)),\"\",SUM(H$65:H$114))","v":0},{"$f":"IF(ISERROR(SUM(I$65:I$114)),\"\",SUM(I$65:I$114))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Data for Method 3 - Landfills",null,null,"Fraction of uncollected methane that oxidizes in the landfill cover\n[default = 0.1]"]
[null,null,null,null,null,null,"Fraction of landfill gas that is collected"]
[null,null,"Year of Placement\n(auto-calculated from information entered above in cells G54 and G55)","Quantity Placed\n[Wet short tons]","Ultimate Methane Potential, Lo, \n[default for mill waste\nLo =3500 ft3/wet short ton]","First order methane generation rate constant, k\n[default for mill waste\nk = 0.03/yr]","Fraction of collected landfill gas that is burned"]
[null,null,{"$f":"+IF(H$57<=$G$53,H$57,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISERROR($F65*$E65*EXP(-$F65*(I$57-$C65))*$D65),\"\",$F65*$E65*EXP(-$F65*(I$57-$C65))*$D65)","v":""},{"$f":"IF(ISERROR($F65*$E65*EXP(-$F65*(J$57-$C65))*$D65),\"\",$F65*$E65*EXP(-$F65*(J$57-$C65))*$D65)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(I$57<=$G$53,I$57,\"\")","v":""},null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR($F66*$E66*EXP(-$F66*(AE$57-$C66))*$D66),\"\",$F66*$E66*EXP(-$F66*(AE$57-$C66))*$D66)","v":""},"","","","","","","","","","","",{"$f":"IF(ISERROR($F66*$E66*EXP(-$F66*(AQ$57-$C66))*$D66),\"\",$F66*$E66*EXP(-$F66*(AQ$57-$C66))*$D66)","v":""},"","","","","","","",{"$f":"IF(ISERROR($F66*$E66*EXP(-$F66*(AY$57-$C66))*$D66),\"\",$F66*$E66*EXP(-$F66*(AY$57-$C66))*$D66)","v":""},"","","","","",""]
[null,null,{"$f":"+IF(J$57<=$G$53,J$57,\"\")","v":""},null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(K$57<=$G$53,K$57,\"\")","v":""},null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(L$57<=$G$53,L$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR($F69*$E69*EXP(-$F69*(BE$57-$C69))*$D69),\"\",$F69*$E69*EXP(-$F69*(BE$57-$C69))*$D69)","v":""}]
[null,null,{"$f":"+IF(M$57<=$G$53,M$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(N$57<=$G$53,N$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(O$57<=$G$53,O$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(P$57<=$G$53,P$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(Q$57<=$G$53,Q$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(R$57<=$G$53,R$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(S$57<=$G$53,S$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(T$57<=$G$53,T$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(U$57<=$G$53,U$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","",{"$f":"IF(ISERROR($F78*$E78*EXP(-$F78*(AD$57-$C78))*$D78),\"\",$F78*$E78*EXP(-$F78*(AD$57-$C78))*$D78)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(V$57<=$G$53,V$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR($F79*$E79*EXP(-$F79*(AP$57-$C79))*$D79),\"\",$F79*$E79*EXP(-$F79*(AP$57-$C79))*$D79)","v":""},"","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(W$57<=$G$53,W$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(X$57<=$G$53,X$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($F81*$E81*EXP(-$F81*(Y$57-$C81))*$D81),\"\",$F81*$E81*EXP(-$F81*(Y$57-$C81))*$D81)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(Y$57<=$G$53,Y$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(Z$57<=$G$53,Z$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR($F83*$E83*EXP(-$F83*(AX$57-$C83))*$D83),\"\",$F83*$E83*EXP(-$F83*(AX$57-$C83))*$D83)","v":""},"","","","","","",""]
[null,null,{"$f":"+IF(AA$57<=$G$53,AA$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AB$57<=$G$53,AB$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AC$57<=$G$53,AC$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AD$57<=$G$53,AD$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AE$57<=$G$53,AE$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($F88*$E88*EXP(-$F88*(AF$57-$C88))*$D88),\"\",$F88*$E88*EXP(-$F88*(AF$57-$C88))*$D88)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AF$57<=$G$53,AF$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AG$57<=$G$53,AG$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AH$57<=$G$53,AH$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AI$57<=$G$53,AI$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AJ$57<=$G$53,AJ$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AK$57<=$G$53,AK$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AL$57<=$G$53,AL$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AM$57<=$G$53,AM$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AN$57<=$G$53,AN$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AO$57<=$G$53,AO$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AP$57<=$G$53,AP$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AQ$57<=$G$53,AQ$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($F100*$E100*EXP(-$F100*(AR$57-$C100))*$D100),\"\",$F100*$E100*EXP(-$F100*(AR$57-$C100))*$D100)","v":""},"","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AR$57<=$G$53,AR$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AS$57<=$G$53,AS$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AT$57<=$G$53,AT$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","",""]
[null,null,{"$f":"+IF(AU$57<=$G$53,AU$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",""]
[null,null,{"$f":"+IF(AV$57<=$G$53,AV$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","",""]
[null,null,{"$f":"+IF(AW$57<=$G$53,AW$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[null,null,{"$f":"+IF(AX$57<=$G$53,AX$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,{"$f":"+IF(AY$57<=$G$53,AY$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($F108*$E108*EXP(-$F108*(AZ$57-$C108))*$D108),\"\",$F108*$E108*EXP(-$F108*(AZ$57-$C108))*$D108)","v":""},"","","","",""]
[null,null,{"$f":"+IF(AZ$57<=$G$53,AZ$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,{"$f":"+IF(BA$57<=$G$53,BA$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[null,null,{"$f":"+IF(BB$57<=$G$53,BB$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,{"$f":"+IF(BC$57<=$G$53,BC$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,{"$f":"+IF(BD$57<=$G$53,BD$57,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"+IF(BE$57<=$G$53,BE$57,\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Methane emissions from anaerobic wastewater \ntreatment or sludge digestion systems\nNote: Use only one of the following methods for each source."]
[null,null,"Method 1 - For anaerobic wastewater treatment and sludge digestion systems where gas is collected"]
[null,null,"NOTE: If the gas collection system is highly efficient and all gas is burned, the direct GHG emissions can be assumed to be zero."]
[null,null,null,null,"Step 1"]
[null,null,null,null,"A1","A2","B","C","D","E ","F","G1","G2"]
[null,null,null,null,"Fraction of total emissions claimed as direct for this entry (between 0 and 1)","Quantity of gas collected\n[dry standard cubic meters/yr]","Efficiency of gas collection system\n[default = 1.0]","Fraction of collected gas that is burned\n[default = 1.0]","Methane content of gas\n[default = 0.5]","Quantity of methane released\n[dry standard cubic meters/yr]","Methane emissions in metric tons ","Direct\nMethane emissions in metric tonnes","Indirect\nMethane emissions in metric tonnes"]
[null,null,null,null,null,null,null,null,null,"E=((A/B)*(1-B)*D)+(A*D*(1-C))","F = E * [ 0.72 kg / standard cubic meter ] / 1000","G1 = A1 * F","G2 = (1-A1) * F"]
[null,null,"Example: System A","Anaerobic treatment system",0.7,1000,0.9,0.5,0.5,{"$f":"((F130/G130)*(1-G130)*I130)+(F130*I130*(1-H130))","v":305.55555555555554},{"$f":"J130*0.72/1000","v":0.21999999999999997},{"$f":"E130*K130","v":0.15399999999999997},{"$f":"(1-E130)*K130","v":6.6000000000000003E-2}]
[null,null,"System description","Waste type"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G132=0,0,((F132/G132)*(1-G132)*I132)+(F132*I132*(1-H132)))","v":0},{"$f":"J132*0.72/1000","v":0},{"$f":"E132*K132","v":0},{"$f":"(1-E132)*K132","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G133=0,0,((F133/G133)*(1-G133)*I133)+(F133*I133*(1-H133)))","v":0},{"$f":"J133*0.72/1000","v":0},{"$f":"E133*K133","v":0},{"$f":"(1-E133)*K133","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G134=0,0,((F134/G134)*(1-G134)*I134)+(F134*I134*(1-H134)))","v":0},{"$f":"J134*0.72/1000","v":0},{"$f":"E134*K134","v":0},{"$f":"(1-E134)*K134","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G135=0,0,((F135/G135)*(1-G135)*I135)+(F135*I135*(1-H135)))","v":0},{"$f":"J135*0.72/1000","v":0},{"$f":"E135*K135","v":0},{"$f":"(1-E135)*K135","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G136=0,0,((F136/G136)*(1-G136)*I136)+(F136*I136*(1-H136)))","v":0},{"$f":"J136*0.72/1000","v":0},{"$f":"E136*K136","v":0},{"$f":"(1-E136)*K136","v":0}]
[]
[null,null,null,null,null,"Step 2: Sum anaerobic wastewater or sludge treatment methane emissions from Method 1: ",null,null,null,null,null,{"$f":"SUM(L132:L136)","v":0},{"$f":"SUM(M132:M136)","v":0},"metric tonnes CH4"]
[null,null,"Method 2 - For anaerobic wastewater treatment and sludge digestion systems \nwhere gas is NOT collected or the collection efficiency is not known."]
[]
[null,null,null,null,"Step 1"]
[null,null,null,null,"A1","A2","B","C","D","E","F1","F2"]
[null,null,null,null,"Fraction of total emissions claimed as direct for this entry (between 0 and 1)","Amount of organic matter sent to treatment per year\n[kg BOD or COD per year]","Methane emission factor\n[default for mill wastes = 0.25 kg methane per kg COD in the feed or\n0.60 kg methane per kg BOD in the feed.\nUnits must match column A]","Amount of methane captured and burned\n[kg methane / yr]","Quantity of methane released\n[kg methane / yr]","Methane emissions in metric tons ","Direct\nMethane emissions in metric tonnes","Indirect\nMethane emissions in metric tonnes"]
[null,null,null,null,null,null,null,null,"D = (A * B) - C","E = D / 1000","F1 = A1 * E","F2 = (1-A1) * E"]
[null,null,"Example: System B","Anaerobic treatment system",0.7,3000000,0.25,600000,{"$f":"F145*G145-H145","v":150000},{"$f":"I145/1000","v":150},{"$f":"E145*J145","v":105},{"$f":"(1-E145)*J145","v":45.000000000000007}]
[null,null,"System description","Waste type"]
[null,null,null,null,null,null,null,null,{"$f":"F147*G147-H147","v":0},{"$f":"I147/1000","v":0},{"$f":"E147*J147","v":0},{"$f":"(1-E147)*J147","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F148*G148-H148","v":0},{"$f":"I148/1000","v":0},{"$f":"E148*J148","v":0},{"$f":"(1-E148)*J148","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F149*G149-H149","v":0},{"$f":"I149/1000","v":0},{"$f":"E149*J149","v":0},{"$f":"(1-E149)*J149","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F150*G150-H150","v":0},{"$f":"I150/1000","v":0},{"$f":"E150*J150","v":0},{"$f":"(1-E150)*J150","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F151*G151-H151","v":0},{"$f":"I151/1000","v":0},{"$f":"E151*J151","v":0},{"$f":"(1-E151)*J151","v":0}]
[]
[null,null,null,null,"Step 2: Sum anaerobic wastewater or sludge treatment methane emissions from Method 2: ",null,null,null,null,null,{"$f":"SUM(K147:K151)","v":0},{"$f":"SUM(L147:L151)","v":0},"metric tonnes CH4"]
[]
[null,null,"Sum of emissions from anaerobic wastewater treatment and sludge digestion systems >>"]
[null,null,null,null,null,null,null,null,null,"Direct","Indirect"]
[null,null,null,"Sum anaerobic wastewater or sludge treatment methane emissions from Methods 1 and 2: ",null,null,null,null,null,{"$f":"(L138+K153)","v":0},{"$f":"(M138+L153)","v":0},"metric tonnes CH4"]

{"sheet":"CHP Allocation","index":6,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,3,2,11],[11,2,11,10],[13,3,13,11],[17,8,17,9],[30,1,30,9]]}
[]
[]
[null,null,null,"Combined heat and power:  \nAllocating emissions based on the efficiency of heat and power production"]
[]
[null,null,null,"Note:  If a facility is using all of the energy outputs of a CHP system, there is no need to allocate the emissions."]
[]
[null,null,null,"EXPLANATION OF CELL COLOR SCHEME"]
[null,null,null,null,"User entry"]
[null,null,null,null,"Calculated value"]
[]
[]
[null,null,"Combined heat and power:  \nAllocating emissions based on the efficiency of heat and power production"]
[]
[null,null,null,"Simplified Efficiency Method: \nAllocation based on assumed efficiencies for both steam and power production and total CHP emissions"]
[]
[null,null,null,"Step 1","Step 2","Step 3","Step 4","Step 5",null,null,"Step 6","Step 7","Step 8","Step 9","Step 10","Step 11","Step 12"]
[null,null,null,"A","B","C","D","E",null,null,"F","G","H","I","J","K","L"]
[null,null,null,"H  Heat output (district heat, process heat, other steam)","P  Power output","T Total Fuel input","Energy Unit used\nin A, B, and C","ET  Total direct emissions from CHP facility","Allowed input values for ratio of heat production efficiency to power production efficiency, eh/ep",null,"Assigned ratio of efficiencies","ep  (efficiency of typical power production)","eh  (efficiency of typical heat production)","EH  Emissions share allocated to heat production","EP  Emissions share allocated to electricity production","Emission factor for heat production","Emission factor for electricity production"]
[null,null,null,null,null,null,null,"Use methods outlined in \"Direct - Fuel Combust.\"","Minimum ratio allowed by energy balance","Maximum ratio allowed by energy balance","Efficiency of heat production divided by efficiency of power production (default ratio of 0.8/.35=2.29)","G = ( A + B * F ) / ( C * F )","H = G * F","I = E * ( A / ( A + B * F ) )","J = E - I","K = I * 1000 / A","L = J * 1000 / B"]
[null,null,null,"(GJ, BTU or kWh)","(same unit as in column A)","(same unit as in column A)","(GJ, BTU or kWh)","metric tons CO2 equiv.",null,null,"eh/ep",null,null,"metric tons CO2 equiv.","metric tons CO2 equiv.","kg CO2 / energy unit in D","kg CO2 / energy unit in D"]
[null,null,"Example>>",1000000,500000,2679000,"kWh",587.4,{"$f":"IF(ISERROR(D21/(F21-E21)),\"\",D21/(F21-E21))","v":0.45892611289582375},{"$f":"IF(ISERROR((F21-D21)/E21),\"\",(F21-D21)/E21)","v":3.3580000000000001},2.2999999999999998,{"$f":"+IF(ISERROR((D21+K21*E21)/(F21*K21)),\"\",(D21+K21*E21)/(F21*K21))","v":0.3489296784978172},{"$f":"IF(ISERROR(K21*L21),\"\",K21*L21)","v":0.80253826054497945},{"$f":"+IF(ISERROR(H21*(D21/(D21+E21*K21))),\"\",H21*(D21/(D21+E21*K21)))","v":273.2093023255814},{"$f":"IF(ISERROR(H21-N21),\"\",H21-N21)","v":314.19069767441857},{"$f":"IF(ISERROR(N21*1000/D21),\"\",N21*1000/D21)","v":0.27320930232558144},{"$f":"IF(ISERROR(O21*1000/E21),\"\",O21*1000/E21)","v":0.62838139534883708}]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(D22/(F22-E22)),\"\",D22/(F22-E22))","v":""},{"$f":"IF(ISERROR((F22-D22)/E22),\"\",(F22-D22)/E22)","v":""}]
[null,"Purchased steam",null,null,null,null,null,null,{"$f":"IF(ISERROR(D23/(F23-E23)),\"\",D23/(F23-E23))","v":""},{"$f":"IF(ISERROR((F23-D23)/E23),\"\",(F23-D23)/E23)","v":""},null,{"$f":"+IF(ISERROR((D23+K23*E23)/(F23*K23)),\"\",(D23+K23*E23)/(F23*K23))","v":""},{"$f":"IF(ISERROR(K23*L23),\"\",K23*L23)","v":""},{"$f":"+IF(ISERROR(H23*(D23/(D23+E23*K23))),\"\",H23*(D23/(D23+E23*K23)))","v":""},{"$f":"IF(ISERROR(H23-N23),\"\",H23-N23)","v":""},{"$f":"IF(ISERROR(N23*1000/D23),\"\",N23*1000/D23)","v":""},""]
[null,"Exported power",null,null,null,null,null,null,{"$f":"IF(ISERROR(D24/(F24-E24)),\"\",D24/(F24-E24))","v":""},{"$f":"IF(ISERROR((F24-D24)/E24),\"\",(F24-D24)/E24)","v":""},null,{"$f":"+IF(ISERROR((D24+K24*E24)/(F24*K24)),\"\",(D24+K24*E24)/(F24*K24))","v":""},{"$f":"IF(ISERROR(K24*L24),\"\",K24*L24)","v":""},{"$f":"+IF(ISERROR(H24*(D24/(D24+E24*K24))),\"\",H24*(D24/(D24+E24*K24)))","v":""},{"$f":"IF(ISERROR(H24-N24),\"\",H24-N24)","v":""},"",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(D25/(F25-#REF!)),\"\",D25/(F25-#REF!))","v":""},{"$f":"IF(ISERROR((F25-D25)/#REF!),\"\",(F25-D25)/#REF!)","v":""},null,{"$f":"+IF(ISERROR((D25+K25*#REF!)/(F25*K25)),\"\",(D25+K25*#REF!)/(F25*K25))","v":""},{"$f":"IF(ISERROR(K25*L25),\"\",K25*L25)","v":""},{"$f":"+IF(ISERROR(H25*(D25/(D25+#REF!*K25))),\"\",H25*(D25/(D25+#REF!*K25)))","v":""},{"$f":"IF(ISERROR(H25-N25),\"\",H25-N25)","v":""},"",{"$f":"IF(ISERROR(O25*1000/#REF!),\"\",O25*1000/#REF!)","v":""}]
[]
[]
[]
[]
[]
[null,"The equations used to calculate emission allocations in the table above are mathematically identical to those in the current WRI default efficiency method.  However, they have been rearranged to allow the user to select a value for the parameter that controls the allocation (the ratio of efficiencies) in a way that is consistent with the energy balance for the CHP system.  The rearrangements have been made so that the assumptions inherrent to the efficiency method, and their implications, are more clear.  The equations make it clear that (a) the parameter that controls the allocation is the ratio of the efficiencies for heat and power generation, and (b) this ratio and the individual efficiencies are constrained by the energy balance."]

{"sheet":"Indirect - Energy Imports","index":7,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[[28,5,28,6],[30,2,30,9],[10,4,10,6],[10,7,10,9]]}
[null,null,"Indirect Emissions"]
[null,null,"Electricity and/or steam imports"]
[]
[null,"EXPLANATION OF CELL COLOR SCHEME"]
[null,null,null,"User entry"]
[null,null,null,"Calculated value"]
[]
[]
[null,null,"Indirect Emissions from electricity and steam imports"]
[]
[null,null,null,"Step 1","Step 2",null,null,"Step 3",null,null,"Step 4"]
[null,null,null,"A","B","C","D","E","F","G","H"]
[null,null,null,"Electricity and/or steam Import","CO2 emission factor for imported electricity or steam*","CH4 emission factor for imported electricity or steam*","N2O emission factor for imported electricity or steam*","Indirect CO2 emissions in metric tonnes","Indirect CH4 emissions in metric tonnes","Indirect N2O emissions in metric tonnes","Explain source or basis of emission factors for estimating emissions from imported electricity or steam"]
[null,null,null,null,null,null,null,"E = A * B / 2205","F = A * C / 2205","G = A * D / 2205"]
[null,null,null,"MWh","lb CO2 / MWh","lb CH4 / MWh","lb N2O / MWh"," metric tons CO2"," metric tons CH4"," metric tons N2O","Text explanation"]
[]
[null,null,"Stream description"]
[null,null,null,null,null,null,null,{"$f":"$D18*E18/2205","v":0},{"$f":"$D18*F18/2205","v":0},{"$f":"$D18*G18/2205","v":0}]
[null,null,null,null,null,null,null,{"$f":"$D19*E19/2205","v":0},{"$f":"$D19*F19/2205","v":0},{"$f":"$D19*G19/2205","v":0}]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,"tonnes CO2","tonnes CH4","tonnes N2O"]
[null,null,null,null,null,"Step 4: Sum GHG emissions:",null,{"$f":"SUM(H18:H27)","v":0},{"$f":"SUM(I18:I27)","v":0},{"$f":"SUM(J18:J27)","v":0}]
[]
[null,null,"* Emission factors for purchased electricity can normally be obtained from national authorities or from the supplier of the purchased electricity.\n  Emission factors for imported electricity or steam from CHP systems can be determined by the methods outlined in the \"CHP Allocation\" worksheet."]
[]
[]
[]
[null,null,"Note: The emissions associated with electricity and/or steam import "]
[null,null,"should be reported in scope 2 as indirect emissions."]

{"sheet":"Indirect - Energy Exports","index":8,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,4,32,7],[10,2,10,7],[15,4,15,6],[15,8,15,10]]}
[null,null,"Emissions Associated with Exports of Electricity and Steam"]
[]
[null,null,"Note: The emissions and indirect emissions impacts related to electricity and steam exports "]
[null,null,"should be reported separately from indirect emissions from imported power or steam"]
[]
[]
[null,null,"User entry"]
[null,null,"Calculated value"]
[]
[]
[null,null,"Indirect emission impacts related to electricity and steam exports"]
[]
[]
[null,null,"The indirect emissions impact is based on amount of emissions associated with producing the exported power or steam"]
[]
[null,null,null,"Step 1","Step 2",null,null,"Step 3","Step 4",null,null,"Step 5"]
[null,null,null,"A","B","C","D","E","F","G","H","I"]
[null,null,null,"Total electricity/steam production by generator","Total direct CO2 emissions from generating the total electricity/steam","Total direct CH4 emissions from generating the total electricity/steam","Total direct N2O emissions from generating the total electricity/steam","Electricity/steam exports from generator","Indirect CO2 emissions impact related to exported power or steam","Indirect CH4 emissions impact related to exported power or steam","Indirect N2O emissions impact related to exported power or steam","Carbon intensity of exported power or steam",null,"Carbon intensity of power on the grid into which the export occurred\n(applies to electricity only)"]
[null,null,null,null,null,null,null,null,"F = B * E / A","G = C * E / A","H = D * E / A","I = [ F + (G*GWP_CH4) + (H*GWP_N2O) ] / E"]
[null,null,null,"MWh","metric tonnes CO2","metric tonnes CH4","metric tonnes N2O","MWh","metric tonnes CO2","metric tonnes CH4","metric tonnes N2O","metric tonnes CO2 equiv. / MWh",null,"metric tonnes CO2 equiv / MWh"]
[]
[null,null,"Stream description"]
[null,null,null,null,null,null,null,null,{"$f":"IF($D23=0,\"\",E23*$H23/$D23)","v":""},{"$f":"IF($D23=0,\"\",F23*$H23/$D23)","v":""},{"$f":"IF($D23=0,\"\",G23*$H23/$D23)","v":""},{"$f":"+IF(H23=0,\"\",(I23+J23*GWP_CH4+K23*GWP_N2O)/H23)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF($D24=0,\"\",E24*$H24/$D24)","v":""},"","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF($D31=0,\"\",E31*$H31/$D31)","v":""},"","",""]
[null,null,null,null,null,null,null,null,"tonnes CO2","tonnes CH4","tonnes N2O"]
[null,null,null,null,"Step 5: Sum CO2 emissions impacts related to exported power or steam:",null,null,null,{"$f":"SUM(I23:I31)","v":0},{"$f":"SUM(J23:J31)","v":0},{"$f":"SUM(K23:K31)","v":0}]

{"sheet":"Summary Table","index":9,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,2,30,4],[3,5,3,8],[5,5,5,8],[3,2,3,4],[12,2,12,3],[29,2,29,3],[18,2,18,3],[21,2,21,4],[23,2,23,4],[25,2,25,4],[10,3,10,4],[14,2,14,4],[16,2,16,4],[5,2,5,4],[19,2,19,4],[8,2,8,3]]}
[null,null,"Summary of Inventory Results"]
[]
[null,null,"Summary of Inventory Results"]
[null,null,"Name of Inventory",null,null,{"$f":"IF('Operations in Inventory'!F8=\"\",\"\",'Operations in Inventory'!F8)","v":""}]
[]
[null,null,"General description of inventory boundaries",null,null,{"$f":"IF('Operations in Inventory'!F10=\"\",\"\",'Operations in Inventory'!F10)","v":""}]
[]
[null,null,"Direct Emission Impacts",null,null,"CO2\n(metric tonnes)","CH4\n(metric tonnes)","N2O\n(metric tonnes)","CO2-equiv\n(metric tonnes)"]
[null,null,"Direct emissions from stationary fuel combustion",null,null,{"$f":"'Direct - Fuel Combust.'!I34","v":0},{"$f":"'Direct - Fuel Combust.'!J34","v":0},{"$f":"'Direct - Fuel Combust.'!K34","v":0},{"$f":"F9+G9*GWP_CH4+H9*GWP_N2O","v":0}]
[]
[null,null,null,"Direct emissions attributable to exports of steam and power (a subset of direct emissions from stationary combustion)",null,{"$f":"'Indirect - Energy Exports'!I33","v":0},{"$f":"'Indirect - Energy Exports'!J33","v":0},{"$f":"'Indirect - Energy Exports'!K33","v":0},{"$f":"F11+G11*GWP_CH4+H11*GWP_N2O","v":0}]
[]
[null,null,"Direct emissions from transportation and mobile sources",null,null,{"$f":"'Mobile & Transportation'!I109","v":0},{"$f":"'Mobile & Transportation'!J109","v":0},{"$f":"'Mobile & Transportation'!K109","v":0},{"$f":"F13+G13*GWP_CH4+H13*GWP_N2O","v":0}]
[]
[null,null,"Direct emissions from waste management",null,null,"N/A",{"$f":"'Waste Mngmt.'!Q46+'Waste Mngmt.'!J157","v":0},"N/A",{"$f":"G15*GWP_CH4","v":0}]
[]
[null,null,"Total direct emissions",null,null,{"$f":"F9+F13","v":0},{"$f":"G9+G13+G15","v":0},{"$f":"H9+H13","v":0},{"$f":"F17+G17*GWP_CH4+H17*GWP_N2O","v":0}]
[]
[null,null,"Indirect Emission Impacts",null,null,"CO2\n(metric tonnes)","CH4\n(metric tonnes)","N2O\n(metric tonnes)","CO2-equiv\n(metric tonnes)"]
[null,null,"Indirect emissions from steam and power imports",null,null,{"$f":"'Indirect - Energy Imports'!H29","v":0},{"$f":"'Indirect - Energy Imports'!I29","v":0},{"$f":"'Indirect - Energy Imports'!J29","v":0},{"$f":"F20+G20*GWP_CH4+H20*GWP_N2O","v":0}]
[]
[null,null,"Indirect emissions from transportation and mobile sources",null,null,{"$f":"'Mobile & Transportation'!L109","v":0},{"$f":"'Mobile & Transportation'!M109","v":0},{"$f":"'Mobile & Transportation'!N109","v":0},{"$f":"F22+G22*GWP_CH4+H22*GWP_N2O","v":0}]
[]
[null,null,"Indirect emissions from waste management",null,null,"N/A",{"$f":"'Waste Mngmt.'!R46+'Waste Mngmt.'!K157","v":0},"N/A",{"$f":"G24*GWP_CH4","v":0}]
[]
[null,null,"Total indirect emissions",null,null,{"$f":"F20+F22","v":0},{"$f":"G20+G22+G24","v":0},{"$f":"H20+H22","v":0},{"$f":"F26+G26*GWP_CH4+H26*GWP_N2O","v":0}]
[]
[]
[]
[null,null,"Combustion-Related Releases of Biomass-Derived CO2",null,null,"CO2\n(metric tonnes)",null,null,"CO2-equiv\n(metric tonnes)"]
[null,null,"Combustion-Related Releases of Biomass-Derived CO2\n[ metric tons CO2  / year ]",null,null,{"$f":"'Biomass Combustion CO2'!J33","v":0},"N/A","N/A","N/A"]

{"sheet":"Custom Emission Factors","index":10,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Custom Emission Factors"]
[null,null,"Calculating custom emission factors"]
[]
[null,"EXPLANATION OF CELL COLOR SCHEME"]
[null,null,null,"User entry"]
[null,null,null,"Calculated value"]
[]
[]
[]
[null,null,null,"A","B","C"]
[null,null,null,"Fuel Higher Heating Value (HHV)","Carbon Content","Emission Factor"]
[null,null,null,null,null,"C = 2000 * B * 3.664 / A"]
[null,null,null,"MMBtu HHV / short ton","(% w/w)","lb CO2 / MMBtu HHV"]
[null,null,null,null,"This should be entered as a fraction, i.e. 0 > x > 1 "]
[]
[null,null,"Fuel Type"]
[null,null,null,null,null,{"$f":"IF(D18=0,0,3.664*2000*E18/D18)","v":0}]
[null,null,null,null,null,{"$f":"IF(D19=0,0,3.664*2000*E19/D19)","v":0}]
[null,null,null,null,null,{"$f":"IF(D20=0,0,3.664*2000*E20/D20)","v":0}]
[null,null,null,null,null,{"$f":"IF(D21=0,0,3.664*2000*E21/D21)","v":0}]
[null,null,null,null,null,{"$f":"IF(D22=0,0,3.664*2000*E22/D22)","v":0}]

{"sheet":"Energy content","index":11,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,0,2,5],[31,1,31,4],[33,1,33,4],[34,1,34,4],[32,1,32,4]]}
[]
["Energy content (HHV)"]
["Fuel specific higher heating values"]
["Based on information in WRI/WBCSD Calculation tools"]
[]
[]
[]
[null,"Fuel type","Higher heating value","Carbon, % by weight","Typical density"]
[null,null,"(MMBtu HHV/bbl - 42 gal) if not otherwise mentioned",null,"( lb/gal ) if not otherwise mentioned"]
[]
[null,"Gasoline / petrol",5.46,85.5,6.17]
[null,"Kerosene",5.67,86.01,6.76]
[null,"Distillate fuel oil No.1",5.88,86.6,7.05]
[null,"Distillate fuel oil No.2",5.88,87.3,7.05]
[null,"Residual fuel oil No.4",6.01,86.4,7.59]
[null,"Residual fuel oil No.5",6.3,88.7,7.93]
[null,"Residual fuel oil No.6",6.43,88.3,8.4499999999999993]
[null,"LPG",3.95,null,"4.52 (liquid)"]
[null,"Anthracite","12,500 Btu/lb",80.599999999999994]
[null,"Bituminous coal","13,500 Btu/lb",80.099999999999994]
[null,"Sub Bituminous coal‡","8735 Btu/lb"]
[null,"Lignite‡","6480 Btu/lb"]
[null,"Butane",4.09,83.6,"4.84 (liquid)"]
[null,"Propane",3.8,81.599999999999994,"4.24 (liquid)"]
[null,"Coke","12,690 Btu/lb",85]
[null,"Natural gas*","1050 Btu/ft3","69.4 wt% C (92.5 wt% CH4)","0.042 lb/ft3"]
[null,"Wood (40% H2O)**","10.9 MMBtu/ton"]
[null,"Wood (20% H2O)**","15.5 MMBtu/ton"]
[null,"Wood (15% H2O)**","16.6 MMBtu/ton"]
[null,"Wood (0% H2O)**","20.0MMBtu/ton"]
[]
[null,"Source (unless otherwise noted): American Petroleum Institute (API), Compendium of Greenhouse Gas Emissions Estimation Methodologies for the Oil & Gas Industry (Pilot Test Version), 2001."]
[null,"*Based on \"standard conditions\" of 60oF (15.6oC) and 1 atm pressure, per API"]
[null,"** calculated based on LHV values contained in Revised 1996 IPCC Guidelines for National Greenhouse Gas Inventories:  Reference Manual Volume 3, Table 1-13; converted to HHV values based on the assumption that, for biomass fuels, LHV is 95% of HHV."]
[null,"‡Calculated from data in Instructions for Form EIA-1605b Voluntary Reporting of Greenhouse Gases, for Data Through 2002, US Department of Energy, Energy Information Administration, Form EIA-1605 (2003), OMB No. 1905-0194, Appendix B, Page 48, available on the internet at ftp://ftp.eia.doe.gov/pub/oiaf/1605/cdrom/pdf/1605INSTR02.pdf (31 October 2003)"]

{"sheet":"Conversion Factors","index":12,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
["Conversion Factors"]
["Based on information in WRI/WBCSD Calculation tools"]
[]
[]
[null,null,"Mass"]
[null,null,"1 pound (lb)","453.6 grams (g)","0.4536 kilograms (kg)","0.0004536 metric tonnes"]
[null,null,"1 kilogram (kg)","2.205 pounds (lb)"]
[null,null,"1 short ton (ton)","2,000 pounds (lb)","907.2 kilograms (kg)"]
[null,null,"1 metric tonne","2,205 pounds (lb)","1,000 kilograms (kg)","1.1023 short tons (tons)"]
[]
[null,null,"Volume"]
[null,null,"1 cubic foot (ft 3)","7.4805 gallons (gal)","0.1781 barrel (bbl)"]
[null,null,"1 cubic foot (ft 3)","28.32 liters (L)","0.02832 cubic meters (m 3)"]
[null,null,"1 gallon (US liquid - gal)","0.0238 barrel (bbl)","3.785 liters (L)","0.003785 cubic meters (m 3)"]
[null,null,"1 barrel (bbl)","42 gallons (gal)","158.99 liters (L)","0.1589 cubic meters (m 3)"]
[null,null,"1 litre (L)","0.001 cubic meters (m 3)","0.2642 gallons (gal)"]
[null,null,"1 cubic meter (m 3)","6.2897 barrels (bbl)","264.2 gallons (gal)","1,000 liters (L)"]
[]
[null,null,"Energy"]
[null,null,"1 kilowatt hour (kWh)","3412 Btu (btu)","3,600 kilojoules (KJ)"]
[null,null,"1 megajoule (MJ)","0.001 gigajoules (GJ)"]
[null,null,"1 gigajoule (GJ)","0.9478 million Btu (million btu)","277.8 kilowatt hours (kWh)"]
[null,null,"1 Btu (btu)","1,055 joules (J)"]
[null,null,"1 million Btu (million btu)","1.055 gigajoules (GJ)","293 kilowatt hours (kWh)"]
[null,null,"1 therm (therm)","100,000 btu ","0.1055 gigajoules (GJ)","29.3 kilowatt hours (kWh)"]
[]
[null,null,"Other"]
[null,null,"kilo","1,000"]
[null,null,"mega","1,000,000"]
[null,null,"giga","1,000,000,000"]
[null,null,"tera","1,000,000,000,000"]
[null,null,"1 psi","0.06895 bar"]
[null,null,"1 kgf / cm 3 (tech atm)","0.9807 bar"]
[null,null,"1 atmosphere (atm)","1.01325 bar","101.325 kilo pascals","14.696 pounds per square inch (psia)"]
[null,null,"1 mile (statue)","1.609 kilometers"]
[null,null,"1 metric tonne carbon","3.664 metric tonnes CO2"]

{"sheet":"Biomass Combustion CO2","index":13,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,12],[4,1,4,6],[6,1,6,6],[8,1,8,6],[34,3,34,12],[12,1,12,2],[13,1,13,2],[32,6,32,8],[18,8,18,9],[18,4,18,5],[18,6,18,7]]}
[]
[]
[null,null,"Additional Information on Biomass"]
[null,null,"Estimating CO2 Emissions from Biomass Combustion."]
[null,"Many wood products manufacturing facilities generate more than half of their energy needs from biomass fuels recovered from the industry’s waste and process streams.  The CO2 generated when biomass fuels are burned is not included in GHG emissions totals.  The GHG Protocol, however, requires that biomass-derived CO2 be reported as additional information.  This is the approach generally prescribed for national inventories by the United Nations Framework Convention on Climate Change."]
[]
[null,"Any increases or decreases in the amount of carbon sequestered by the forests are accounted for in the comprehensive forest accounting system.  This is the approach generally prescribed for national inventories by the United Nations Framework Convention on Climate Change.  Most international protocols including that of the Intergovernmental Panel on Climate Change (IPCC) have adopted the convention set out by the United Nations."]
[]
[null,"Estimated Biomass Emissions:\nThe information reported below on biomass emissions is being supplied:\n\n To ensure that readers understand the entity’s overall energy profile in terms of both greenhouse gas emissions, and non-greenhouse gas emissions, and\n To provide awareness and understanding of how biomass fuels are generated and used in the manufacture of wood products.\n\nAlso, note that the information reported below is in conformance with the general greenhouse gas protocol designed by the World Resources Institute and the World Business Council for Sustainable Development.  Users of these calculation tools may elect to modify the format and type of information presented based on specific facility or company needs.\n"]
[]
[]
[null,"EXPLANATION OF CELL COLOR SCHEME"]
[null,"User entry "]
[null,"Calculated value"]
[]
[]
[]
[null,null,"Additional Information on Biomass Carbon Emissions from Combustion of Wood or Bark"]
[null,null,null,null,"Step 1",null,"Step 2",null,"Step 3"]
[null,null,null,null,"A","B","C ","D","E","F"]
[null,null,null,null,"Quantity of fuel burned","Unit used to measure quantitiy of fuel use\n[Note: Be careful not to mix HHVs and LHVs.]","CO2 emission factor:\n[default value is:\nsolid biomass:  240*\nlb CO2/MMBtu HHV]","Unit of CO2 emission factor","CO2 emissions in lb CO2/yr ","CO2 emissions in metric tonnes/yr"]
[null,null,null,null,null,null,null,null,"E = A * C","F = E / 2205"]
[null,null,"Example: Bark Boiler","Bark",500000,"MMBtu  (HHV)",240,"lb CO2 / MMBtu HHV",{"$f":"E23*G23","v":120000000},{"$f":"I23/2205","v":54421.768707482996}]
[null,null,"Source description","Fuel type"]
[null,null,null,null,null,null,null,null,{"$f":"IF(E25=\"\",\"\",E25*G25)","v":""},{"$f":"IF(ISERROR(I25/2205),\"\",I25/2205)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(E26=\"\",\"\",E26*G26)","v":""},{"$f":"IF(ISERROR(I26/2205),\"\",I26/2205)","v":""}]
[null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,"",""]
[]
[null,null,null,null,null,null,"Biomass Carbon Released as CO2 from Combustion of Wood or Bark",null,null,{"$f":"SUM(J25:J31)","v":0},"Metric Tonne /year"]
[]
[null,null,"Note:  ","* Emission factor for solid biomass from Intergovernmental Panel on Climate Change (IPCC). 1997. Revised 1996 IPCC Guidelines for National Greenhouse Gas Inventories: Reference Manual (Volume 3). Table 1.1, corrected for 1% unburned carbon per USEPA  AP-42 Emission Factors for Wood Residue Combustion in Boilers – Supplement G, July 2001.  United States Environmental Protection Agency. Washington, D.C."]
[null,null,null,"Based on HHV - normally LHV assumed to be 95% of HHV for biomass fuels"]

{"sheet":"GWPs","index":14,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,2,1,6],[1,7,1,11],[1,12,1,16]]}
["Global Warming Potentials from IPCC Assessment Reports"]
[null,null,"20 year time horizon",null,null,null,null,"100 year time horizon",null,null,null,null,"500 year time horizon"]
["Species","Chemical formula","SAR (AR2)","TAR (AR3)","AR4","AR5","AR6","SAR (AR2)","TAR (AR3)","AR4","AR5","AR6","SAR (AR2)","TAR (AR3)","AR4","AR5","AR6"]
["Carbon dioxide","CO2",1,1,1,1,1,1,1,1,1,1,1,1,1,null,1]
["Methane","CH4",56,62,72,84,81.2,21,23,25,28,27.9,6.5,7,7.6,null,7.95]
["Methane, fossil origin","CH4",null,null,null,85,82.5,null,null,null,30,29.8,null,null,null,null,10]
["Methane, non-fossil origin","CH4",null,null,null,null,80.8,null,null,null,null,27.2,null,null,null,null,7.3]
["Nitrous oxide","N2O",280,275,289,264,273,310,296,298,265,273,170,156,153,null,130]
[]
["IPCC Assessment Report","Year ","Link"]
["AR6",2021,"https://www.ipcc.ch/report/ar6/wg1/downloads/report/IPCC_AR6_WGI_Full_Report.pdf"]
["AR5",2013,"https://www.ipcc.ch/site/assets/uploads/2018/02/WG1AR5_all_final.pdf"]
["AR4",2007,"https://www.ipcc.ch/site/assets/uploads/2018/05/ar4_wg1_full_report-1.pdf"]
["TAR (AR3)",2001,"https://www.ipcc.ch/site/assets/uploads/2018/03/WGI_TAR_full_report.pdf"]
["SAR (AR2)",1996,"https://www.ipcc.ch/site/assets/uploads/2018/02/ipcc_sar_wg_I_full_report.pdf"]

{"sheet":"Revisions","index":15,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Version","Changes","Implementor","Date"]
[1.1000000000000001,"Updated 100 year global warming potentials to IPCC AR6 and modified spreadsheet to enable easily changed GWPs.","BJM","2022-02-10"]
[null,"Corrected error in Method 3 for reported methane generation.","BJM","2022-02-10"]
[null,"Changed Method 3 on waste management tab to conform to IPCC methodology","BJM","2022-03-01"]
[null,"Created Revision tab","BJM","2022-03-01"]