{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Introduction","Table of Contents","Operations in Inventory","Stationary Combustion","Mobile & Transportation","Waste Mngmt.","Direct - Make-up Carbonates","CHP Allocation","Indirect - Energy Imports","Energy Exports","CO2 Imports and Exports","Summary Table","Custom Emission Factors","Energy content","Conversion Factors","Energy Factors","Raw Data Log","Supporting Info. on Biomass","Revision Log"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":1,"defined_names":47,"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":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,9],[10,2,10,9],[26,2,26,8],[3,2,8,9],[12,2,13,7],[11,2,11,7],[1,2,1,8],[28,2,28,8],[30,3,30,8],[31,3,31,8],[32,3,32,8]]}
["        ","ICFPA/NCASI Spreadsheets for \nCalculating GHG emissions from pulp and paper manufacturing\n\nWorkbook Version 2.1a, for the USDOE 1605(b) \nVoluntary Reporting of Greenhouse Gases Program\n\n (see below for USER AGREEMENT)"]
[null,null,"An aid to developing estimates using the methods in \"Calculation tools for estimating greenhouse gas emissions from pulp and paper mills,\" Report Version 1.0"]
[]
[null,null,"This tool intends to facilitate the calculation of direct CO2, CH4, and N2O emissions from pulp and paper mills and ancillary operations.  It also addresses emissions attributable to the purchase and export of electricity and/or steam. This document is to be used in conjunction with three additional documents:\n1) 'Calculation tools for estimating Greenhouse Gas Emissions from pulp and paper mills,' and\n2) ‘Corporate GHG Accounting and Reporting: Corporate Inventory Module’, available at www.ghgprotocol.org \n3) 'Instructions for Form EIA-1605 Voluntary Reporting of Greenhouse Gases, For Data Through 2002,' available from the USDOE at http://www.eia.doe.gov/oiaf/1605/techassist.html\n\n"]
[]
[]
[]
[]
[]
[]
[null,null,"These spreadsheets include significant amounts of material copied from other WRI and WBCSD calculation tools. \n Intellectual property rights of the WRI and WBCSD calculation tools belong to WRI and WBCSD, unless stated otherwise."]
[]
[null,null,"The reporting format for the \"Calculation tools for estimating greehouse gas emissions from pulp and paper mills\" can be satisfied by printing the following completed worksheets:"]
[]
[null,null,null,"Operations in Inventory"]
[null,null,null,"Stationary Combustion"]
[null,null,null,"Mobile & Transportation"]
[null,null,null,"Waste Mngmt."]
[null,null,null,"Direct - Make-up Carbonates"]
[null,null,null,"CHP allocation"]
[null,null,null,"Indirect - Energy Imports"]
[null,null,null,"Energy Exports"]
[null,null,null,"CO2 Imports and Exports"]
[null,null,null,"Summary Table"]
[null,null,null,"Supporting Information on Biomass"]
[]
[null,null,"These spreadsheets were developed by NCASI for the Climate Change Working Group of the International Council of Forest and Paper Associations (ICFPA).  Questions or comments on this material can be directed to:\n\nBarry Malmberg\nNCASI\nPO Box 271\nSheridan, WY 82801\nphone: + 541-752-8806\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, ICFPA, 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, ICFPA 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, ICFPA 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":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[6,3,6,7],[11,3,11,7],[12,3,12,7],[10,3,10,7],[15,3,15,6],[25,3,25,8],[16,3,16,5],[22,3,22,8],[23,3,23,8],[24,3,24,8]]}
[]
[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,"Stationary Combustion","Direct emissions of CO2, CH4, and N2O resulting from fuel combustion - includes default emission factors"]
[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,"Direct - Make-up Carbonates","Direct emissions of CO2 from make-up carbonates used in the pulp mill"]
[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,"Energy Exports","GHG emission impacts associated with electricity and /or steam exports"]
[null,null,"CO2 Imports and Exports","CO2 emissions exported to precipitated calcium carbonate plants and CO2 imports (e.g. for neutralization)"]
[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,"Energy Factors","Contains conversion factors and emission factors for use by formulas imbedded in the data entry forms"]
[null,null,"Raw Data Log","Provides a place for the automatic entry of raw data entered into the data entry forms, prior to unit conversion"]
[null,null,"Supporting Info. on Biomass","Direct emissions of biomass CO2 for informational purposes only (do not include in GHG inventory)"]

{"sheet":"Operations in Inventory","index":2,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[17,5,17,6],[1,1,1,7],[4,1,4,5],[14,5,14,6],[15,5,15,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[11,5,11,6],[12,5,12,6]]}
[]
[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/wastepaper/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"]
[null,null,null,null,null,"Chemical pulping – kraft"]
[null,null,null,null,null,"Chemical pulping – sulfite"]
[null,null,null,null,null,"Chemical pulping – other"]
[null,null,null,null,null,"Semichemical pulping "]
[null,null,null,null,null,"Recovery furnace – kraft"]
[null,null,null,null,null,"Liquor furnace – sulfite"]
[null,null,null,null,null,"Liquor furnace – semichem"]
[null,null,null,null,null,"Lime kiln or calciner"]
[null,null,null,null,null,"Incinerators for noncondensible gases, etc."]
[null,null,null,null,null,"Wastepaper pulping and cleaning"]
[null,null,null,null,null,"Deinking"]
[null,null,null,null,null,"Bleaching of chemical or semichemical pulp"]
[null,null,null,null,null,"Brightening of deinked pulp"]
[null,null,null,null,null,"On-site preparation of chemicals used in core operations (e.g. ClO2 or O3)"]
[null,null,null,null,null,"Paper and/or paperboard production"]
[null,null,null,null,null,"Coating (including extrusion coating)"]
[null,null,null,null,null,"Roll trimming, roll wrapping, sheet cutting"]
[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,"Gas-fired infrared dryers"]
[null,null,null,null,null,"Other fossil fuel-fired dryers"]
[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,"Air emissions control devices"]
[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"]

{"sheet":"Stationary Combustion","index":3,"n_rows":105,"n_cols":12,"rows_kept":105,"cut":false,"hidden":false,"merged":[[104,3,104,6],[5,2,5,8],[14,5,14,7],[56,3,56,6],[54,3,54,6],[14,8,14,11],[102,2,102,6],[101,2,101,6],[10,1,10,2],[3,2,3,6],[8,1,8,2],[9,1,9,2],[103,3,103,6],[49,4,49,7],[48,4,48,7],[47,4,47,7]]}
[]
[]
[null,null,"Direct Emissions - Stationary Fuel Combustion, (including methane and nitrous oxide emissions from biomass fuels)"]
[null,null,"Note: Where mills are exporting CO2 to precipitated calcium carbonate (PCC) plants, these exports are not considered emissions.  Amounts of exported CO2 are calculated in the sheet for \"CO2 Imports and Exports.\"  On the \"Stationary Combustion\" sheet (this sheet), the amounts of exported CO2 are automatically subtracted from the sum of direct emissions from stationary fossil fuel combustion.  \n\nAlso, emissions from mobile sources are reported on the \"Mobile & Transportation\" spreadsheet immediately behind this spreadsheet"]
[]
[null,null,"These spreadsheets include significant amounts of material copied from other WRI and WBCSD calculation tools. \n Intellectual property rights of the WRI and WBCSD calculation tools belong to WRI and WBCSD, unless stated otherwise."]
[]
[null,"EXPLANATION OF CELL COLOR SCHEME"]
[null,"User entry: Source / fuel description"]
[null,"User entry: Fuel use / emission factor values",null,null,"Suggested default emission factors shown below"]
[null,"Auto 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\nSuggested default emission factors shown below","CH4 emission factor\nSuggested default emission factors shown below","N2O emission factor\nSuggested default emission factors shown below","CO2 emissions in metric tonnes","CH4 emissions in metric tonnes","N2O emissions in metric tonnes","Total emissions in terms of CO2 equivalents (metric tonnes)"]
[null,null,null,null,"MMBtu HHV","(lb CO2 / MMBtu HHV)","(lb CH4 / MMBtu HHV)","(lb N2O / MMBtu HHV)","E = A * B / 2205","F = A * C / 2205","G = A * D / 2205","H = E + (F * 21) + (G * 310)"]
[null,null,"Example: Source 1","Natural gas",1000,117.08,2.8999999999999998E-3,2.0000000000000001E-4,{"$f":"IF(E19=\"\",\"\",E19*F19/2205)","v":53.09750566893424},{"$f":"IF(G19=\"\",\"\",E19*G19/2205)","v":1.3151927437641724E-3},{"$f":"IF(H19=\"\",\"\",E19*H19/2205)","v":9.0702947845804991E-5},{"$f":"IF(E19=\"\",\"\",IF(I19=\"\",0,I19)+IF(J19=\"\",0,J19*21)+IF(K19=\"\",0,K19*310))","v":53.153242630385485}]
[null,null,"Source description","Fuel type","Fuel Quant","CO2 Em. Factor","CH4 Em. Factor","N2O Em. Factor","CO2 emissions (tonne)","CH4 emissions (tonnes)","N2O emissions (tonnes)","Total EM "]
[null,null,null,null,null,null,null,null,{"$f":"IF(E21=\"\",\"\",E21*F21/2205)","v":""},{"$f":"IF(G21=\"\",\"\",E21*G21/2205)","v":""},{"$f":"IF(H21=\"\",\"\",E21*H21/2205)","v":""},{"$f":"IF(E21=\"\",\"\",IF(I21=\"\",0,I21)+IF(J21=\"\",0,J21*21)+IF(K21=\"\",0,K21*310))","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,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,"","","",""]
[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\n(metric tonnes)","CH4\n(metric tonnes)","N2O\n(metric tonnes)","CO2 Equivalents\n(metric tonnes)"]
[null,null,null,null,"Step 4: Sum total of GHG emissions (including CO2 exports): ",null,null,null,{"$f":"SUM(I21:I45)","v":0},{"$f":"SUM(J21:J45)","v":0},{"$f":"SUM(K21:K45)","v":0},{"$f":"I48+J48*21+K48*310","v":0}]
[null,null,null,null,"Step 5: CO2 exported to PCC plant (calculated in \"CO2 Imports and Exports\" worksheet)",null,null,null,{"$f":"'CO2 Imports and Exports'!E20","v":0},"N/A","N/A","N/A"]
[null,null,null,null,"Step 6:  Total GHG emissions from stationary fossil fuel combustion",null,null,null,{"$f":"+I48-I49","v":0},{"$f":"+J48","v":0},{"$f":"+K48","v":0},{"$f":"I50+J50*21+K50*310","v":0}]
[]
[]
[]
[]
[null,null,null,"Suggested Default Emission Factors"]
[]
[null,null,"Sources (unless otherwise noted):","CO2 Emission factors are from DOE Instructions for Form EIA-1605, Appendix B, March 2003\nCH4 Emission Factors are from Revised 1996 IPCC Guidelines for National Greenhouse Gas Inventories: Reference Manual (Vol. 3)\nN2O Emission Factors are from Revised 1996 IPCC Guidelines for National Greenhouse Gas Inventories: Reference Manual (Vol. 3)"]
[null,null,"Fuel type","lb CO2 / MMBtu  fuel\n[based on higher heating value, HHV]","lb CH4 / MMBtu fuel \n[based on higher heating value, HHV]","lb N2O / MMBtu fuel \n[based on higher heating value, HHV]","Comments"]
[null,null,"Liquid fossil"]
[null,null,"Gasoline",156.42500000000001,null,null,"IPCC does not provide CH4 or N2O factors for this fuel"]
[null,null,"Kerosene",159.535,null,null,"IPCC does not provide CH4 or N2O factors for this fuel"]
[null,null,"Jet Fuel",156.25800000000001,null,null,"IPCC does not provide CH4 or N2O factors for this fuel"]
[null,null,"Aviation gasoline",152.71700000000001,null,null,"IPCC does not provide CH4 or N2O factors for this fuel"]
[null,null,"Distillate fuel (No.1, No.2, No.4 fuel oil and diesel) Stationary sources except lime kilns and calciners",161.386,4.0000000000000002E-4,8.9999999999999998E-4,"IPCC Tier 2 CH4 and N2O factors"]
[null,null,"Distillate fuel (No.1, No.2, No.4 fuel oil and diesel) Lime kilns",161.386,6.0000000000000001E-3,0,"CH4 factor from NCASI 1981\nN2O factor from IPCC discussion of formation requirements"]
[null,null,"Distillate fuel (No.1, No.2, No.4 fuel oil and diesel) Calciners",161.386,6.0000000000000001E-3,1E-3,"CH4 factor from NCASI 1981\nN2O factor is IPCC Tier 1"]
[null,null,"Residual fuel oil (No.5, No.6 fuel oil)",173.90600000000001,7.0000000000000001E-3,6.9999999999999999E-4,"IPCC Tier 2 CH4 and N2O factors"]
[null,null,"Residual fuel oil (No.5, No.6 fuel oil) Lime kilns",173.90600000000001,6.0000000000000001E-3,0,"CH4 factor from NCASI 1981\nN2O factor from IPCC discussion of formation requirements"]
[null,null,"Residual fuel oil (No.5, No.6 fuel oil) Calciners",173.90600000000001,6.0000000000000001E-3,1E-3,"CH4 factor from NCASI 1981\nN2O factor is IPCC Tier 1"]
[null,null,"LPG",139.03899999999999,null,null,"IPCC does not provide CH4 or N2O factors for this fuel"]
[null,null,"Propane",139.178,null,null,"IPCC does not provide CH4 or N2O factors for this fuel"]
[null,null,"Petroleum coke",225.13,null,null,"IPCC does not provide CH4 or N2O factors for this fuel"]
[null,null,"Gaseous fossil"]
[null,null,"Natural gas (dry) - boilers and IR dryers",117.08,2.8999999999999998E-3,2.0000000000000001E-4,"N2O factor is IPCC Tier 1"]
[null,null,"Natural gas (dry) - turbines",117.08,1E-3,2.0000000000000001E-4,"N2O factor is IPCC Tier 1"]
[null,null,"Natural gas (dry) - lime kiln",117.08,5.7000000000000002E-3,0,"CH4 factor from NCASI 1981\nN2O factor from IPCC discussion of formation requirements"]
[null,null,"Natural gas (dry) - calciners",117.08,5.7000000000000002E-3,2.0000000000000001E-4,"CH4 factor from NCASI 1981\nN2O factor is IPCC Tier 1 for natural gas"]
[null,null,"Natural gas (dry) - Int. Comb. Engine 2 - cycle lean burn",117.08,3.5999999999999997E-2,2.0000000000000001E-4,"N2O factor is IPCC Tier 1"]
[null,null,"Natural gas (dry) - Int. Comb. Engine 4 - cycle lean burn",117.08,2.7E-2,2.0000000000000001E-4,"N2O factor is IPCC Tier 1"]
[null,null,"Natural gas (dry) - Int. Comb. Engine 4 - cycle rich burn",117.08,6.1000000000000004E-3,2.0000000000000001E-4,"N2O factor is IPCC Tier 1"]
[null,null,"Methane",115.258,null,null,"IPCC does not provide CH4 or N2O factors for this fuel"]
[null,null,"Solid fossil"]
[null,null,"Anthracite",227.4,0.02,3.0999999999999999E-3,"IPCC Tier 1 CH4 and N2O factors"]
[null,null,"Bituminous coal Overfeed stoker boiler",205.3,2E-3,3.5000000000000001E-3,"IPCC Tier 2 CH4 and N2O factors"]
[null,null,"Bituminous coal Underfeed stoker boiler",205.3,3.1E-2,3.5000000000000001E-3,"IPCC Tier 2 CH4 and N2O factors"]
[null,null,"Bituminous coal - Pulverized Dry bottom, wall fired",205.3,1.5E-3,3.5000000000000001E-3,"IPCC Tier 2 CH4 and N2O factors"]
[null,null,"Bituminous coal - Pulverized Dry bottom, tangential firing",205.3,1.5E-3,1E-3,"IPCC Tier 2 CH4 and N2O factors"]
[null,null,"Bituminous coal - Pulverized Wet bottom",205.3,2E-3,3.5000000000000001E-3,"IPCC Tier 2 CH4 and N2O factors"]
[null,null,"Bituminous coal Spreader stoker boiler",205.3,2E-3,3.5000000000000001E-3,"IPCC Tier 2 CH4 and N2O factors"]
[null,null,"Bituminous coal - fluidized bed Circulating or bubbling",205.3,2E-3,0.21,"IPCC Tier 2 CH4 and N2O factors"]
[null,null,"Sub-bituminous coal Overfeed stoker boiler",212.7,2E-3,3.5000000000000001E-3,"IPCC Tier 2 CH4 and N2O factors"]
[null,null,"Sub-bituminous coal Underfeed stoker boiler",212.7,3.1E-2,3.5000000000000001E-3,"IPCC Tier 2 CH4 and N2O factors"]
[null,null,"Sub-bituminous coal - fluidized bed Circulating or bubbling",212.7,2E-3,0.21,"IPCC Tier 2 CH4 and N2O factors"]
[null,null,"Lignite",215.4,0.02,3.0999999999999999E-3,"IPCC Tier 1 CH4 and N2O factors"]
[null,null,"Biofuels*"]
[null,null,"Wood and wood waste",0,2.7E-2,8.9999999999999993E-3,"Median values determined from a data set originating from a variety of sources, see NCASI 2002."]
[null,null,"Pulping liquors",0,5.4999999999999997E-3,4.4000000000000003E-3,"Median values determined from a data set originating from a variety of sources, see NCASI 2002."]
[null,null,"Biogas used in boilers or kilns",0,6.0000000000000001E-3,0,"CH4 factor from NCASI 1981\nN2O factor from IPCC discussion of formation requirements"]
[null,null,"Other fuels"]
[null,null,"Tires and tire derived fuel",189.53800000000001,null,null,"IPCC does not provide CH4 or N2O factors for this fuel"]
[null,null,"Municipal solid waste**",91.9,null,null,"IPCC does not provide CH4 or N2O factors for this fuel"]
[null,null,"* Wood and wood residuals contain ‘biogenic’ carbon.  Under international greenhouse gas accounting methods developed by the IPCC, biogenic carbon is considered to be part of the natural carbon balance and does not add to atmospheric concentrations of carbon dioxide.  Reporters may wish to use an emission factor of zero for wood, wood waste, and other biomass fuels in which the carbon is entirely biogenic.\n\n*Reporters wishing to compute quantities of \"climate neutral\" carbon dioxide emissions from biomass combustion may do so using the material in the \"Supporting Info. on Biomass\" sheet of this file.  Estimates of climate neutral CO2 emissions are not included in the inventory results."]
[null,null,"** This factor from DOE is based on the non-organic (non-biogenic) portion of material in municipal solid waste, and corresponds to a factor of 919 lb CO2/short ton of municipal solid waste and an average energy content of 5000 Btu/lb"]
[null,null,"Other sources:","National Council for Air and Stream Improvement, Inc. (NCASI).  1981.  A study of the kraft process lime kiln total gaseous non-methane organic emissions.  Technical Bulletin No. 358.  Research Triangle Park, NC: National Council for Air and Stream Improvement, Inc."]
[null,null,null,"National Council for Air and Stream Improvement, Inc. (NCASI).  2002.  Calculation Tools for Estimating Greenhouse Gas Emissions from Pulp and Paper Mills, Version 1.0.  Research Triangle Park, NC: National Council for Air and Stream Improvement, Inc."]

{"sheet":"Mobile & Transportation","index":4,"n_rows":97,"n_cols":28,"rows_kept":97,"cut":false,"hidden":false,"merged":[[55,6,55,8],[55,9,55,11],[44,10,44,12],[86,9,86,11],[66,18,66,19],[67,18,67,19],[86,12,86,14],[68,18,68,19],[70,18,70,19],[69,18,69,19],[94,9,94,11],[60,18,60,21],[77,18,77,23],[16,21,16,24],[55,12,55,14],[44,13,44,15],[62,18,62,19],[72,18,72,19],[73,18,73,19],[71,18,71,19],[18,21,18,26],[63,18,63,19],[64,18,64,19],[65,18,65,19],[3,2,3,10],[8,1,8,2],[5,2,5,11],[9,1,9,2],[10,1,10,2],[55,4,55,5]]}
[null,null,"Direct or Indirect Emissions - Mobile and Transportation Sources"]
[null,null,"Note: Emissions from stationary sources are reported on the \"Direct-Fuel Combust.\" spreadsheet immediately in front of this spreadsheet"]
[]
[null,null,"These spreadsheets include significant amounts of material copied from other WRI and WBCSD calculation tools. \n Intellectual property rights of the WRI and WBCSD calculation tools belong to WRI and WBCSD, unless stated otherwise."]
[]
[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\nFor transportation emissions, if total fuel consumption is not known, but distance traveled and vehicle efficiency are known, the \"Optional Calculator\" (to the right of the Part 1 table) can be used to estimate fuel consumption based on distance and efficiency information.\n\nBe careful to avoid double counting!  If emissions for a source are estimated using Part 1, do not also estimate emissions for this same source 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: Source / fuel description"]
[null,"User entry: Fuel use / emission factor values",null," "]
[null,"Auto calculated value:"]
[]
[]
[]
[null,"Emissions from Transportation and Mobile Equipment"]
[]
[null,"Part 1.  Emissions Associated with Transportation Based on Fuel Consumption ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(R21>0,R23>0),\"Enter mpg OR l/100km, not both!\",\"\")","v":""},null,null,"Suggested default emission factors for Part 1, Transportation:"]
[null,"Note:  Use this worksheet to calculate your emissions from amount of fuel consumed. "]
[null,null,null,"Source Name","Fuel Type","Fraction of total emissions claimed as direct for this entry (between 0 and 1)","Fuel Quantity (MMBtu HHV)","Em. Factor (lb CO2/MMBtu HHV)","Em. Factor (lb CH4/MMBtu HHV)","Em. Factor (lb N2O/MMBtu HHV)","Direct Emissions (tonne CO2)","Direct Emissions (tonne CH4)","Direct Emissions (tonne N2O)","Indirect Emissions (tonne CO2)","Indirect Emissions (tonne CH4)","Indirect Emissions (tonne N2O)",null,"Optional Calculator",null,null,null,"CO2 Emission factors are from DOE Instructions for Form EIA-1605, Appendix B, March 2003\n\nAlthough no CH4 or N2O emission factors are suggested here, the user is free to estimate emissions of these gases based on user-provided emission factors.  One potential source of these factors is the Revised 1996 IPCC Guidelines for National Greenhouse Gas Inventories: Reference Manual (Vol. 3)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G20=\"\",\"\",F20*G20*H20/2205)","v":""},{"$f":"IF(G20=\"\",\"\",F20*G20*I20/2205)","v":""},{"$f":"IF(G20=\"\",\"\",F20*G20*J20/2205)","v":""},{"$f":"IF(G20=\"\",\"\",(1-F20)*G20*H20/2205)","v":""},{"$f":"IF(G20=\"\",\"\",(1-F20)*G20*I20/2205)","v":""},{"$f":"IF(G20=\"\",\"\",(1-F20)*G20*J20/2205)","v":""},null,1000," = Distance traveled","<<< enter this value"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G21=\"\",\"\",F21*G21*H21/2205)","v":""},{"$f":"IF(G21=\"\",\"\",F21*G21*I21/2205)","v":""},{"$f":"IF(G21=\"\",\"\",F21*G21*J21/2205)","v":""},{"$f":"IF(G21=\"\",\"\",(1-F21)*G21*H21/2205)","v":""},{"$f":"IF(G21=\"\",\"\",(1-F21)*G21*I21/2205)","v":""},{"$f":"IF(G21=\"\",\"\",(1-F21)*G21*J21/2205)","v":""},null,2," = miles per gallon"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G22=\"\",\"\",F22*G22*H22/2205)","v":""},{"$f":"IF(G22=\"\",\"\",F22*G22*I22/2205)","v":""},{"$f":"IF(G22=\"\",\"\",F22*G22*J22/2205)","v":""},{"$f":"IF(G22=\"\",\"\",(1-F22)*G22*H22/2205)","v":""},{"$f":"IF(G22=\"\",\"\",(1-F22)*G22*I22/2205)","v":""},"",null,null,"        OR","<<< enter one of these",null,"Fuel type","lb CO2/MMBtu HHV","lb CH4/MMBtu HHV","lb N2O/MMBtu HHV","Higher Heating Values*","HHV Units","Typical Densities**"]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null," = litres per 100 km",null,null,null,null,null,null,"(HHV)",null,"(lb/gal)"]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,{"$f":"IF(AND(R21>0,R23>0),\"Error\",IF(R21>0,R20/R21,R20/100*R23))","v":500},{"$f":"IF(R21>0,\"Gallons used\",\"litres used\")","v":"Gallons used"},"<<< calculated",null,"Gasoline / petrol",156.42500000000001,null,null,0.1202,"MMBtu HHV/gallon",6.17]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,null,null,"Kerosene",159.535,null,null,0.13500000000000001,"MMBtu HHV/gallon",6.76]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,null,null,"Jet Fuel",156.25800000000001,null,null,0.13500000000000001,"MMBtu HHV/gallon"]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,null,null,"Aviation gasoline",152.71700000000001,null,null,0.1202,"MMBtu HHV/gallon"]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,null,null,"Diesel",161.386,null,null,0.13869999999999999,"MMBtu HHV/gallon",7.1]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,null,null,"Distillate fuel oil No.1",161.386,null,null,0.13869999999999999,"MMBtu HHV/gallon",7.05]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,null,null,"Distillate fuel oil No.2",161.386,null,null,0.13869999999999999,"MMBtu HHV/gallon",7.05]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,null,null,"Fuel oil #4",161.386,null,null,0.13869999999999999,"MMBtu HHV/gallon",7.59]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,null,null,"Residual Fuel oil#5",173.90600000000001,null,null,0.1497,"MMBtu HHV/gallon",7.93]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,null,null,"Residual Fuel oil#6",173.90600000000001,null,null,0.1497,"MMBtu HHV/gallon",8.4499999999999993]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,null,null,"LPG",139.03899999999999,null,null,9.2100000000000001E-2,"MMBtu HHV/gallon",4.5199999999999996]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,null,null,"Propane",139.178,null,null,9.0999999999999998E-2,"MMBtu HHV/gallon",4.24]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,null,null,"Natural gas",117.08,null,null,1.03,"MMBtu HHV/ 1000 ft3"]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,null,null,"Methane",115.258,null,null,1.01,"MMBtu HHV/ 1000 ft3"]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,null,null,"Anthracite",227.4,null,null,16.940000000000001,"MMBtu HHV/short ton"]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,null,null,"Bituminous coal",205.3,null,null,24.02,"MMBtu HHV/short ton"]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,null,null,"Sub-bituminous coal",212.7,null,null,17.47,"MMBtu HHV/short ton"]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,null,null,"Lignite",215.4,null,null,12.96,"MMBtu HHV/short ton"]
[null,null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,null,null,"* Calculated from information in DOE Instructions for Form EIA-1605, Appendix B, March 2003"]
[null,null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,null,null,"**Source: 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,null,null,null,null,"DIRECT EMISSIONS",null,null,"INDIRECT EMISSIONS",null,null,null,null,null,null,null,"*** From DOE Instructions for Form EIA-1605, March 2003"]
[null,null,null,null,null,null,null,null,null,null,"tonnes CO2","tonnes CH4","tonnes N2O","tonnes CO2","tonnes CH4","tonnes N2O"]
[null,null,"Total transportation emissons based on fuel use >>>",null,null,null,null,null,null,null,{"$f":"SUM(K20:K44)","v":0},0,0,0,0,0]
[]
[]
[]
[]
[]
[null,null,"Emissions from Transportation and Mobile Equipment"]
[null,null,"Part 2.  Emissions Associated with Mobile Equipment Based on Fuel Consumption "]
[null,null,"Emissions - Fuel Combustion in mobile devices such as harvesting equipment"]
[null,null,null,null,"Step 1",null,"Step 2",null,null,"Step 3",null,null,"Step 4"]
[null,null,null,null,"A1","A2","B","C ","D","E","F","G","H","I","J"]
[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\nSuggested default emission factors shown at right","CH4 emission factor\nSuggested default emission factors shown at right","N2O emission factor\nSuggested default emission factors shown at right","DIRECT\nCO2 emissions in metric tonnes","DIRECT\nCH4 emissions in metric tonnes","DIRECT\nN2O emissions in metric tonnes","INDIRECT\nCO2 emissions in metric tonnes","INDIRECT\nCH4 emissions in metric tonnes","INDIRECT\nN2O emissions in metric tonnes"]
[null,null,null,null,null,"units of MMBtu HHV","lb CO2/MMBtu HHV","lb CH4/MMBtu HHV","lb N2O/MMBtu HHV","E = A1 * A2 * B / 2205","F = A1 * A2 * C / 2205","G = A1 * A2 * D / 2205","H = (1-A1) * A2 * B / 2205","I = (1-A1) * A2 * C / 2205","J = (1-A1) * A2 * D / 2205"]
[null,null,"Example: Source 1","Natural gas",0.75,1000,117.08,0.01,2.0000000000000001E-4,{"$f":"IF(F60=\"\",\"\",E60*F60*G60/2205)","v":39.823129251700678},{"$f":"IF(F60=\"\",\"\",E60*F60*H60/2205)","v":3.4013605442176869E-3},{"$f":"IF(F60=\"\",\"\",E60*F60*I60/2205)","v":6.802721088435374E-5},{"$f":"IF(F60=\"\",\"\",(1-E60)*F60*G60/2205)","v":13.27437641723356},{"$f":"IF(F60=\"\",\"\",(1-E60)*F60*H60/2205)","v":1.1337868480725624E-3},{"$f":"IF(F60=\"\",\"\",(1-E60)*F60*I60/2205)","v":2.2675736961451248E-5}]
[null,null,"Source description","Fuel type","Fraction as Direct","Fuel Quantity","Units","Em. factor","Units","Direct CO2 (tonne)","Direct CH4 (tonne)","Direct N2O (tonne)","Indirect CO2 (tonne)","Indirect CH4 (tonne)","Indirect N2O (tonne)",null,null,null,"Suggested default emission factors for Part 2, Mobile Equipment:"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(F62=\"\",\"\",E62*F62*G62/2205)","v":""},{"$f":"IF(F62=\"\",\"\",E62*F62*H62/2205)","v":""},{"$f":"IF(F62=\"\",\"\",E62*F62*I62/2205)","v":""},{"$f":"IF(F62=\"\",\"\",(1-E62)*F62*G62/2205)","v":""},{"$f":"IF(F62=\"\",\"\",(1-E62)*F62*H62/2205)","v":""},{"$f":"IF(F62=\"\",\"\",(1-E62)*F62*I62/2205)","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(F63=\"\",\"\",E63*F63*G63/2205)","v":""},{"$f":"IF(F63=\"\",\"\",E63*F63*H63/2205)","v":""},{"$f":"IF(F63=\"\",\"\",E63*F63*I63/2205)","v":""},{"$f":"IF(F63=\"\",\"\",(1-E63)*F63*G63/2205)","v":""},{"$f":"IF(F63=\"\",\"\",(1-E63)*F63*H63/2205)","v":""},{"$f":"IF(F63=\"\",\"\",(1-E63)*F63*I63/2205)","v":""},null,null,null,"Fuel type",null,"lb CO2/MMBtu HHV","lb CH4/MMBtu HHV","lb N2O/MMBtu HHV","Higher Heating Values (HHV)*","HHV Units","Typical Densities (lb/gal)**"]
[null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,"Gasoline / petrol Mobile 4-stroke engines",null,156.42500000000001,0.1,4.0000000000000001E-3,0.1202,"MMBtu HHV/gallon",6.17]
[null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,"Gasoline / petrol Mobile 2-stroke engines, general",null,156.42500000000001,0.28999999999999998,8.9999999999999998E-4,0.1202,"MMBtu HHV/gallon",6.17]
[null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,"Gasoline / petrol Mobile 2-stroke engines, forestry",null,156.42500000000001,0.38,8.9999999999999998E-4,0.1202,"MMBtu HHV/gallon",6.17]
[null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,"Kerosene, Mobile sources",null,159.535,null,null,0.13500000000000001,"MMBtu HHV/gallon",6.76]
[null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,"Diesel, Mobile sources",null,161.386,8.9999999999999993E-3,6.6000000000000003E-2,0.13869999999999999,"MMBtu HHV/gallon",7.1]
[null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,"Distillate fuel, No.1, Mobile sources",null,161.386,null,null,0.13869999999999999,"MMBtu HHV/gallon",7.05]
[null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,"Distillate fuel, No. 2, Mobile sources",null,161.386,null,null,0.13869999999999999,"MMBtu HHV/gallon",7.05]
[null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,"No. 4 fuel oil, Mobile sources",null,161.386,null,null,0.13869999999999999,"MMBtu HHV/gallon",7.59]
[null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,"LPG, Mobile sources",null,139.03899999999999,null,null,9.2100000000000001E-2,"MMBtu HHV/gallon",4.5199999999999996]
[null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,"Propane, Mobile sources",null,139.178,null,null,9.0999999999999998E-2,"MMBtu HHV/gallon",4.24]
[null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,"Natural gas (dry), Mobile sources",null,117.08,0.01,2.0000000000000001E-4,1.03,"MMBtu HHV/1000 ft3"]
[null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,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 Emission factors are from DOE Instructions for Form EIA-1605, Appendix B, March 2003"]
[null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,"CH4 or N2O emission factors, where listed, are Tier 2 from Revised 1996 IPCC Guidelines for National Greenhouse Gas Inventories: Reference Manual (Vol. 3), Table 1-49, except for Natural Gas factors, which are IPCC Tier 1"]
[null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,"* Calculated from information in DOE Instructions for Form EIA-1605, Appendix B, March 2003"]
[null,null,null,null,null,null,null,null,null,"","","","","","",null,null,null,"**Source: 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,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","",""]
[null,null,null,null,null,null,null,null,null,"DIRECT EMISSIONS",null,null,"INDIRECT EMISSIONS"]
[null,null,null,null,null,null,null,null,null,"tonnes CO2","tonnes CH4","tonnes N2O","tonnes CO2","tonnes CH4","tonnes N2O"]
[null,null,"Total emissions from mobile equipment: ",null,null,null,null,null,null,{"$f":"SUM(J62:J86)","v":0},0,0,0,0,0]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Direct Emissions",null,null,null,"Indirect Emissions"]
[null,null,null,null,null,null,null,"Grand Total of all Mobil and Transportation Emissions (sum of results from Parts 1 and 2):",null,"tonnes CO2","tonnes CH4","tonnes N2O","tonnes CO2","tonnes CH4","tonnes N2O"]
[null,null,null,null,null,null,null,"Note: Do not double count emissions by estimating the same fuel consumption by two different methods above.",null,{"$f":"SUM(K47,J89)","v":0},0,0,0,0,0]

{"sheet":"Waste Mngmt.","index":5,"n_rows":158,"n_cols":57,"rows_kept":158,"cut":false,"hidden":false,"merged":[[9,1,9,2],[10,1,10,2],[32,4,32,10],[138,5,138,9],[126,4,126,11],[116,9,116,12],[16,4,16,12],[4,1,4,9],[14,2,14,6],[13,2,13,6],[49,2,49,11],[44,10,44,13],[8,1,8,2],[28,7,28,10],[46,10,46,13],[32,11,32,14],[30,2,30,11],[153,4,153,8],[157,4,157,8],[139,2,139,5],[55,2,55,3],[123,2,123,5],[56,2,56,3]]}
[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,"These spreadsheets include significant amounts of material copied from other WRI and WBCSD calculation tools. \n Intellectual property rights of the WRI and WBCSD calculation tools belong to WRI and WBCSD, unless stated otherwise."]
[]
[]
[null,"EXPLANATION OF CELL COLOR SCHEME"]
[null,"User entry: Source description"]
[null,"User entry: Data and parameter values"]
[null,"Auto calculated value:"]
[]
[]
[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"]
[]
[null,null,null,null,"Step 1"]
[null,null,null,null,"A1","A2","B","C","D","E","F","G","H"]
[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 = 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 meters/yr]","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))+(A2*D*(1-C))","G = A1 * F * [ 0.72 kg / standard cubic meter ] / 1000","H = (1-A1) * F * [ 0.72 kg / standard cubic meter ] / 1000"]
[null,null,"Example: Landfill A","Mill sludge, ash and misc.",0.5,820000,0.75,0.9,0.47,0.1,{"$f":"((F21/G21)*(1-G21)*I21*(1-J21))+(F21*I21*(1-H21))","v":154160},{"$f":"E21*K21*0.72/1000","v":55.497599999999998},{"$f":"(1-E21)*K21*0.72/1000","v":55.497599999999998}]
[null,null,"Landfill description","Waste type","Fraction as direct","Gas Quantity","Collect. Eff.","Fract. burned","CH4 content","Fract. ox. in cover","CH4 released","Direct emissions (tonne CH4)","Indirect emissions (tonne CH4) "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F23=0,\"\",((F23/G23)*(1-G23)*I23*(1-J23))+(F23*I23*(1-H23)))","v":""},{"$f":"IF(F23=\"\",\"\",E23*K23*0.72/1000)","v":""},{"$f":"IF(F23=\"\",\"\",(1-E23)*K23*0.72/1000)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F24=0,\"\",((F24/G24)*(1-G24)*I24*(1-J24))+(F24*I24*(1-H24)))","v":""},{"$f":"IF(F24=\"\",\"\",E24*K24*0.72/1000)","v":""},{"$f":"IF(F24=\"\",\"\",(1-E24)*K24*0.72/1000)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F25=0,\"\",((F25/G25)*(1-G25)*I25*(1-J25))+(F25*I25*(1-H25)))","v":""},{"$f":"IF(F25=\"\",\"\",E25*K25*0.72/1000)","v":""},{"$f":"IF(F25=\"\",\"\",(1-E25)*K25*0.72/1000)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F26=0,\"\",((F26/G26)*(1-G26)*I26*(1-J26))+(F26*I26*(1-H26)))","v":""},{"$f":"IF(F26=\"\",\"\",E26*K26*0.72/1000)","v":""},{"$f":"IF(F26=\"\",\"\",(1-E26)*K26*0.72/1000)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F27=0,\"\",((F27/G27)*(1-G27)*I27*(1-J27))+(F27*I27*(1-H27)))","v":""},{"$f":"IF(F27=\"\",\"\",E27*K27*0.72/1000)","v":""},{"$f":"IF(F27=\"\",\"\",(1-E27)*K27*0.72/1000)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Direct","Indirect"]
[null,null,null,null,null,null,null,"Step 2: Sum mill landfill methane emissions from Method 1: ",null,null,null,{"$f":"SUM(L23:L27)","v":0},{"$f":"SUM(M23:M27)","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."]
[]
[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","L"]
[null,null,null,null,"Fraction of total emissions claimed as direct for this entry (between 0 and 1)","Annual waste deposits\n[Wet metric tons / year]","Ultimate Methane Potential, Lo, in\ncubic meters methane per wet metric ton waste\n[default for mill waste = 100 m3/wet Mg]","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 meters/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 meters per year","Direct\n Methane 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 = A1 * J * [ 0.72 kg / standard cubic meter ] / 1000","L = (1-A1) * J * [ 0.72 kg / standard cubic meter ] / 1000"]
[null,null,"Example: Landfill A","Mill sludge, ash and misc.",0.25,17500,100,0.03,20,0,{"$f":"F37*G37*(EXP(-H37*J37)-EXP(-H37*I37))","v":789579.6368354538},0.1,0,0,{"$f":"(K37*(1-M37)*(1-L37))+(K37*M37*(1-N37))","v":710621.67315190844},{"$f":"E37*O37*0.72/1000","v":127.91190116734352},{"$f":"(1-E37)*O37*0.72/1000","v":383.7357035020305}]
[null,null,"Landfill description","Waste type","Fraction as direct","Deposit (tonne/yr)","Lo","1st order rate const","Yrs since opened","Yrs since closed","CH4 generated (dry std m3)","Fract. ox. in cover","Fract. collected","Fraction burned",null,"Direct emissions (tonne CH4)","Indirect emissions (tonne CH4) "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F39=\"\",\"\",F39*G39*(EXP(-H39*J39)-EXP(-H39*I39)))","v":""},null,null,null,{"$f":"IF(K39=\"\",\"\",(K39*(1-M39)*(1-L39))+(K39*M39*(1-N39)))","v":""},{"$f":"IF(O39=\"\",\"\",E39*O39*0.72/1000)","v":""},{"$f":"IF(O39=\"\",\"\",(1-E39)*O39*0.72/1000)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F40=\"\",\"\",F40*G40*(EXP(-H40*J40)-EXP(-H40*I40)))","v":""},null,null,null,{"$f":"IF(K40=\"\",\"\",(K40*(1-M40)*(1-L40))+(K40*M40*(1-N40)))","v":""},{"$f":"IF(O40=\"\",\"\",E40*O40*0.72/1000)","v":""},{"$f":"IF(O40=\"\",\"\",(1-E40)*O40*0.72/1000)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F41=\"\",\"\",F41*G41*(EXP(-H41*J41)-EXP(-H41*I41)))","v":""},null,null,null,{"$f":"IF(K41=\"\",\"\",(K41*(1-M41)*(1-L41))+(K41*M41*(1-N41)))","v":""},{"$f":"IF(O41=\"\",\"\",E41*O41*0.72/1000)","v":""},{"$f":"IF(O41=\"\",\"\",(1-E41)*O41*0.72/1000)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F42=\"\",\"\",F42*G42*(EXP(-H42*J42)-EXP(-H42*I42)))","v":""},null,null,null,{"$f":"IF(K42=\"\",\"\",(K42*(1-M42)*(1-L42))+(K42*M42*(1-N42)))","v":""},{"$f":"IF(O42=\"\",\"\",E42*O42*0.72/1000)","v":""},{"$f":"IF(O42=\"\",\"\",(1-E42)*O42*0.72/1000)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F43=\"\",\"\",F43*G43*(EXP(-H43*J43)-EXP(-H43*I43)))","v":""},null,null,null,{"$f":"IF(K43=\"\",\"\",(K43*(1-M43)*(1-L43))+(K43*M43*(1-N43)))","v":""},{"$f":"IF(O43=\"\",\"\",E43*O43*0.72/1000)","v":""},{"$f":"IF(O43=\"\",\"\",(1-E43)*O43*0.72/1000)","v":""}]
[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,{"$f":"SUM(P39:P43)","v":0},{"$f":"SUM(Q39:Q43)","v":0},"metric tonnes CH4"]
[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,{"$f":"IF(OR(G56=\"Invalid Year\",ISERROR(G56)),+L29+P45,+L29+P45+G56)","v":0},{"$f":"IF(OR(G56=\"Invalid Year\",ISERROR(G56)),+M29+Q45,+M29+Q45+G57)","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,"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(G55>=G53,IF(ISERROR(LOOKUP(G55,H58:BE58,H60:BE60)),0,E52*LOOKUP(G55,H58:BE58,H60:BE60)),\"Invalid Year\")","v":0},"metric tonnes CH4"]
[null,null,"Estimated Indirect Emissions [metric tonnes CH4]:",null,null,null,{"$f":"IF(G55>=G53,IF(ISERROR(LOOKUP(G55,H58:BE58,H60:BE60)),0,(1-E52)*LOOKUP(G55,H58:BE58,H60:BE60)),\"Invalid Year\")","v":0},"metric tonnes CH4"]
[null,null,null,null,null,null,"Year Emissions Estimated",{"$f":"+IF(G53=\"\",\"\",G53)","v":""},{"$f":"+IF(ISERROR(AND(H58+1>$G54,H58+1>$G55)),\"\",IF((AND(H58+1>$G54,H58+1>$G55)),\"\",H58+1))","v":""},{"$f":"+IF(ISERROR(AND(I58+1>$G54,I58+1>$G55)),\"\",IF((AND(I58+1>$G54,I58+1>$G55)),\"\",I58+1))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"Methane emissions in metric tonnes CO2 equivalents ",{"$f":"IF(ISERROR(H60*21),\"\",H60*21)","v":0},{"$f":"IF(ISERROR(I60*21),\"\",I60*21)","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 metric tonnes CH4",{"$f":"IF(ISERROR(H61*0.0007167),\"\",H61*0.0007167)","v":0},{"$f":"IF(ISERROR(I61*0.0007167),\"\",I61*0.0007167)","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 meters per year",{"$f":"IF(ISERROR(H62*((1-H64)*(1-H63)+(H64*(1-H65)))),\"\",H62*((1-H64)*(1-H63)+(H64*(1-H65))))","v":0},{"$f":"IF(ISERROR(I62*((1-I64)*(1-I63)+(I64*(1-I65)))),\"\",I62*((1-I64)*(1-I63)+(I64*(1-I65))))","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 meters/yr]",{"$f":"IF(ISERROR(SUM(H$66:H$115)),\"\",SUM(H$66:H$115))","v":0},{"$f":"IF(ISERROR(SUM(I$66:I$115)),\"\",SUM(I$66:I$115))","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 G53 and G54)","Quantity Placed\n[Wet metric tons]","Ultimate Methane Potential, Lo, \n[default for mill waste\nLo =100m3/wet Mg]","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$58<=$G$54,H$58,\"\")","v":""},null,null,null,null,{"$f":"IF(ISERROR($F66*$E66*EXP(-$F66*(H$58-$C66+0.5))*$D66),\"\",$F66*$E66*EXP(-$F66*(H$58-$C66+0.5))*$D66)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR($F66*$E66*EXP(-$F66*(AN$58-$C66+0.5))*$D66),\"\",$F66*$E66*EXP(-$F66*(AN$58-$C66+0.5))*$D66)","v":""},"","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(I$58<=$G$54,I$58,\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISERROR($F67*$E67*EXP(-$F67*(I$58-$C67+0.5))*$D67),\"\",$F67*$E67*EXP(-$F67*(I$58-$C67+0.5))*$D67)","v":""},"","","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR($F67*$E67*EXP(-$F67*(AD$58-$C67+0.5))*$D67),\"\",$F67*$E67*EXP(-$F67*(AD$58-$C67+0.5))*$D67)","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(ISERROR($F67*$E67*EXP(-$F67*(AT$58-$C67+0.5))*$D67),\"\",$F67*$E67*EXP(-$F67*(AT$58-$C67+0.5))*$D67)","v":""},"","",{"$f":"IF(ISERROR($F67*$E67*EXP(-$F67*(AW$58-$C67+0.5))*$D67),\"\",$F67*$E67*EXP(-$F67*(AW$58-$C67+0.5))*$D67)","v":""},"","","","","","","",""]
[null,null,{"$f":"+IF(J$58<=$G$54,J$58,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(ISERROR($F68*$E68*EXP(-$F68*(J$58-$C68+0.5))*$D68),\"\",$F68*$E68*EXP(-$F68*(J$58-$C68+0.5))*$D68)","v":""},"","","","","","","","","","","","","","","","","","","",{"$f":"IF(ISERROR($F68*$E68*EXP(-$F68*(AD$58-$C68+0.5))*$D68),\"\",$F68*$E68*EXP(-$F68*(AD$58-$C68+0.5))*$D68)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(K$58<=$G$54,K$58,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(ISERROR($F69*$E69*EXP(-$F69*(K$58-$C69+0.5))*$D69),\"\",$F69*$E69*EXP(-$F69*(K$58-$C69+0.5))*$D69)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(L$58<=$G$54,L$58,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($F70*$E70*EXP(-$F70*(L$58-$C70+0.5))*$D70),\"\",$F70*$E70*EXP(-$F70*(L$58-$C70+0.5))*$D70)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(M$58<=$G$54,M$58,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($F71*$E71*EXP(-$F71*(M$58-$C71+0.5))*$D71),\"\",$F71*$E71*EXP(-$F71*(M$58-$C71+0.5))*$D71)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(N$58<=$G$54,N$58,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($F72*$E72*EXP(-$F72*(N$58-$C72+0.5))*$D72),\"\",$F72*$E72*EXP(-$F72*(N$58-$C72+0.5))*$D72)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(O$58<=$G$54,O$58,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($F73*$E73*EXP(-$F73*(O$58-$C73+0.5))*$D73),\"\",$F73*$E73*EXP(-$F73*(O$58-$C73+0.5))*$D73)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(P$58<=$G$54,P$58,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($F74*$E74*EXP(-$F74*(P$58-$C74+0.5))*$D74),\"\",$F74*$E74*EXP(-$F74*(P$58-$C74+0.5))*$D74)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(Q$58<=$G$54,Q$58,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($F75*$E75*EXP(-$F75*(Q$58-$C75+0.5))*$D75),\"\",$F75*$E75*EXP(-$F75*(Q$58-$C75+0.5))*$D75)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(R$58<=$G$54,R$58,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($F76*$E76*EXP(-$F76*(R$58-$C76+0.5))*$D76),\"\",$F76*$E76*EXP(-$F76*(R$58-$C76+0.5))*$D76)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(S$58<=$G$54,S$58,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($F77*$E77*EXP(-$F77*(S$58-$C77+0.5))*$D77),\"\",$F77*$E77*EXP(-$F77*(S$58-$C77+0.5))*$D77)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(T$58<=$G$54,T$58,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($F78*$E78*EXP(-$F78*(T$58-$C78+0.5))*$D78),\"\",$F78*$E78*EXP(-$F78*(T$58-$C78+0.5))*$D78)","v":""},"","","","","","","","",{"$f":"IF(ISERROR($F78*$E78*EXP(-$F78*(AC$58-$C78+0.5))*$D78),\"\",$F78*$E78*EXP(-$F78*(AC$58-$C78+0.5))*$D78)","v":""},{"$f":"IF(ISERROR($F78*$E78*EXP(-$F78*(AD$58-$C78+0.5))*$D78),\"\",$F78*$E78*EXP(-$F78*(AD$58-$C78+0.5))*$D78)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(U$58<=$G$54,U$58,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($F79*$E79*EXP(-$F79*(U$58-$C79+0.5))*$D79),\"\",$F79*$E79*EXP(-$F79*(U$58-$C79+0.5))*$D79)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(V$58<=$G$54,V$58,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($F80*$E80*EXP(-$F80*(V$58-$C80+0.5))*$D80),\"\",$F80*$E80*EXP(-$F80*(V$58-$C80+0.5))*$D80)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(W$58<=$G$54,W$58,\"\")","v":""},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*(W$58-$C81+0.5))*$D81),\"\",$F81*$E81*EXP(-$F81*(W$58-$C81+0.5))*$D81)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(X$58<=$G$54,X$58,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($F82*$E82*EXP(-$F82*(X$58-$C82+0.5))*$D82),\"\",$F82*$E82*EXP(-$F82*(X$58-$C82+0.5))*$D82)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(Y$58<=$G$54,Y$58,\"\")","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(Z$58<=$G$54,Z$58,\"\")","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(AA$58<=$G$54,AA$58,\"\")","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,{"$f":"+IF(AB$58<=$G$54,AB$58,\"\")","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(ISERROR($F86*$E86*EXP(-$F86*(AT$58-$C86+0.5))*$D86),\"\",$F86*$E86*EXP(-$F86*(AT$58-$C86+0.5))*$D86)","v":""},"","","","","","","","","","",""]
[null,null,{"$f":"+IF(AC$58<=$G$54,AC$58,\"\")","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(AD$58<=$G$54,AD$58,\"\")","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(AE$58<=$G$54,AE$58,\"\")","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(AF$58<=$G$54,AF$58,\"\")","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,{"$f":"+IF(AG$58<=$G$54,AG$58,\"\")","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(AH$58<=$G$54,AH$58,\"\")","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(AI$58<=$G$54,AI$58,\"\")","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(AJ$58<=$G$54,AJ$58,\"\")","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(ISERROR($F94*$E94*EXP(-$F94*(AJ$58-$C94+0.5))*$D94),\"\",$F94*$E94*EXP(-$F94*(AJ$58-$C94+0.5))*$D94)","v":""},"","","","","","","","","","","","","","","","","","","","",""]
[null,null,{"$f":"+IF(AK$58<=$G$54,AK$58,\"\")","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(AL$58<=$G$54,AL$58,\"\")","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(AM$58<=$G$54,AM$58,\"\")","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(AN$58<=$G$54,AN$58,\"\")","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(AO$58<=$G$54,AO$58,\"\")","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(AP$58<=$G$54,AP$58,\"\")","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(AQ$58<=$G$54,AQ$58,\"\")","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(AR$58<=$G$54,AR$58,\"\")","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,{"$f":"+IF(AS$58<=$G$54,AS$58,\"\")","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(AT$58<=$G$54,AT$58,\"\")","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(AU$58<=$G$54,AU$58,\"\")","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(ISERROR($F105*$E105*EXP(-$F105*(AU$58-$C105+0.5))*$D105),\"\",$F105*$E105*EXP(-$F105*(AU$58-$C105+0.5))*$D105)","v":""},"","","","","","","","","",""]
[null,null,{"$f":"+IF(AV$58<=$G$54,AV$58,\"\")","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(AW$58<=$G$54,AW$58,\"\")","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(AX$58<=$G$54,AX$58,\"\")","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(AY$58<=$G$54,AY$58,\"\")","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(AZ$58<=$G$54,AZ$58,\"\")","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,{"$f":"+IF(BA$58<=$G$54,BA$58,\"\")","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(BB$58<=$G$54,BB$58,\"\")","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(BC$58<=$G$54,BC$58,\"\")","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(BD$58<=$G$54,BD$58,\"\")","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(BE$58<=$G$54,BE$58,\"\")","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,"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","G"]
[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]","Direct\nMethane emissions in metric tonnes CH4","Indirect\nMethane emissions in metric tonnes CH4"]
[null,null,null,null,null,null,null,null,null,"E=((A2/B)*(1-B)*D)+(A2*D*(1-C))","F = A1 * E * [ 0.72 kg / standard cubic meter ] / 1000","G = (1-A1) * E * [ 0.72 kg / standard cubic meter ] / 1000"]
[null,null,"Example: System A","Anaerobic treatment system",0.7,1000,0.9,0.5,0.5,{"$f":"((F131/G131)*(1-G131)*I131)+(F131*I131*(1-H131))","v":305.55555555555554},{"$f":"E131*J131*0.72/1000","v":0.15399999999999997},{"$f":"(1-E131)*J131*0.72/1000","v":6.6000000000000003E-2}]
[null,null,"System description","Waste type","Fraction as Direct","Quant. gas collected (std. dry m3)","Eff. of collection system","Fraction burned","CH4 content of gas","Em. (m3 CH4/yr)","Em. (tonne CH4)","Dir. Em. (tonne CO2 eq)"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G133=0,\"\",((F133/G133)*(1-G133)*I133)+(F133*I133*(1-H133)))","v":""},{"$f":"IF(J133=\"\",\"\",E133*J133*0.72/1000)","v":""},{"$f":"IF(J133=\"\",\"\",(1-E133)*J133*0.72/1000)","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G134=0,\"\",((F134/G134)*(1-G134)*I134)+(F134*I134*(1-H134)))","v":""},{"$f":"IF(J134=\"\",\"\",E134*J134*0.72/1000)","v":""},{"$f":"IF(J134=\"\",\"\",(1-E134)*J134*0.72/1000)","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G135=0,\"\",((F135/G135)*(1-G135)*I135)+(F135*I135*(1-H135)))","v":""},{"$f":"IF(J135=\"\",\"\",E135*J135*0.72/1000)","v":""},{"$f":"IF(J135=\"\",\"\",(1-E135)*J135*0.72/1000)","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G136=0,\"\",((F136/G136)*(1-G136)*I136)+(F136*I136*(1-H136)))","v":""},{"$f":"IF(J136=\"\",\"\",E136*J136*0.72/1000)","v":""},{"$f":"IF(J136=\"\",\"\",(1-E136)*J136*0.72/1000)","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G137=0,\"\",((F137/G137)*(1-G137)*I137)+(F137*I137*(1-H137)))","v":""},{"$f":"IF(J137=\"\",\"\",E137*J137*0.72/1000)","v":""},{"$f":"IF(J137=\"\",\"\",(1-E137)*J137*0.72/1000)","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Direct","Indirect"]
[null,null,null,null,null,"Step 2: Sum anaerobic wastewater or sludge treatment methane emissions from Method 1: ",null,null,null,null,{"$f":"SUM(K133:K137)","v":0},{"$f":"SUM(L133:L137)","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","F"]
[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]","Direct\nMethane emissions in metric tonnes ","Indirect\nMethane emissions in metric tonnes"]
[null,null,null,null,null,null,null,null,"D = (A2 * B) - C","E = A1 * D / 1000","F = (1-A1) * D / 1000"]
[null,null,"Example: System B","Anaerobic treatment system",0.7,3000000,0.25,600000,{"$f":"F146*G146-H146","v":150000},{"$f":"E146*I146/1000","v":105},{"$f":"(1-E146)*I146/1000","v":45.000000000000007}]
[null,null,"System description","Waste type","Fraction as Direct","Amount of organic matter (kg)","CH4 em. factor","CH4 burned (kg/yr)","Em (kg CH4/yr)","Em. (tonne CH4)","Dir. Em. (tonne CO2 eq)"]
[null,null,null,null,null,null,null,null,{"$f":"IF(F148=\"\",\"\",F148*G148-H148)","v":""},{"$f":"IF(I148=\"\",\"\",E148*I148/1000)","v":""},{"$f":"IF(I148=\"\",\"\",(1-E148)*I148/1000)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(F149=\"\",\"\",F149*G149-H149)","v":""},{"$f":"IF(I149=\"\",\"\",E149*I149/1000)","v":""},{"$f":"IF(I149=\"\",\"\",(1-E149)*I149/1000)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(F150=\"\",\"\",F150*G150-H150)","v":""},{"$f":"IF(I150=\"\",\"\",E150*I150/1000)","v":""},{"$f":"IF(I150=\"\",\"\",(1-E150)*I150/1000)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(F151=\"\",\"\",F151*G151-H151)","v":""},{"$f":"IF(I151=\"\",\"\",E151*I151/1000)","v":""},{"$f":"IF(I151=\"\",\"\",(1-E151)*I151/1000)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(F152=\"\",\"\",F152*G152-H152)","v":""},{"$f":"IF(I152=\"\",\"\",E152*I152/1000)","v":""},{"$f":"IF(I152=\"\",\"\",(1-E152)*I152/1000)","v":""}]
[null,null,null,null,null,null,null,null,null,"Direct","Indirect"]
[null,null,null,null,"Step 2: Sum anaerobic wastewater or sludge treatment methane emissions from Method 2: ",null,null,null,null,{"$f":"SUM(J148:J152)","v":0},{"$f":"SUM(K148:K152)","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,null,"Sum anaerobic wastewater or sludge treatment methane emissions from Methods 1 and 2: ",null,null,null,null,{"$f":"(K139+J154)","v":0},{"$f":"(L139+K154)","v":0},"metric tonnes CH4"]

{"sheet":"Direct - Make-up Carbonates","index":6,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[18,1,18,12],[3,2,3,6],[5,2,5,6],[1,1,1,12],[12,1,12,6]]}
[]
[null,"These spreadsheets include significant amounts of material copied from other WRI and WBCSD calculation tools. \n Intellectual property rights of the WRI and WBCSD calculation tools belong to WRI and WBCSD, unless stated otherwise."]
[]
[null,null,"Direct Emissions - Emissions from Make-up \ncarbonates used in the pulp mill*"]
[]
[null,null,"Direct Emissions - Emissions from Make-up \ncarbonates used in the pulp mill"]
[]
[null,null,"Chemical","Amount used in the pulp mill [short tons/year]","Emission factor [kg CO2 per kg chemical]","CO2 Emissions [metric tonnes CO2 per year]"]
[null,null,"Sodium Carbonate",null,0.41499999999999998,{"$f":"D9*E9*0.9072","v":0}]
[null,null,"Calcium Carbonate*",null,0.44,{"$f":"D10*E10*0.9072","v":0}]
[null,null,null,null,"Total CO2 from Make-up=",{"$f":"F10+F9","v":0}]
[]
[null,"*It is important to note that the calcium make-up is required because of losses from the causticizing area, most of which are in the form of calcium carbonate.  This lost material is usually landfilled, thereby sequestering the carbon contained in the calcium carbonate.  Because the default method in these calculation tools does not consider this loss of carbon from the system, the estimated CO2 emissions from make-up calcium carbonate will be higher than actual emissions.  Where these emissions are significant, companies may want to perform the more detailed analyses required to correct the emissions estimates to account for the carbon that leaves the causticizing area in calcium carbonate.  "]

{"sheet":"CHP Allocation","index":7,"n_rows":34,"n_cols":19,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,1,14],[10,3,10,4],[11,3,11,4],[33,1,33,9],[20,10,20,11],[3,3,3,11],[9,3,9,4],[14,2,14,8],[16,5,16,13]]}
[]
[null,"These spreadsheets include significant amounts of material copied from other WRI and WBCSD calculation tools. \n Intellectual property rights of the WRI and WBCSD calculation tools belong to WRI and WBCSD, unless stated otherwise."]
[]
[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,"EXPLANATION OF CELL COLOR SCHEME"]
[null,null,null,null,"User entry: Source / fuel description"]
[null,null,null,"User entry: Fuel use / emission factor values"]
[null,null,null,"User enrty: Physical units:"]
[null,null,null,"Auto calculated value:"]
[]
[]
[null,null,"Combined heat and power:  \nAllocating emissions based on the efficiency of heat and power production"]
[]
[null,null,null,null,null,"Simplified Efficiency Method: \nAllocation based on assumed efficiencies for both steam and power production and total CHP emissions"]
[]
[null,null,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,null,null,"A","B","C","D","E",null,null,"F","G","H","I","J","K","L"]
[null,null,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 of a GHG 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,null,null,"Use methods outlined in \"Direct - Fuel Combust.\"\n\nEach GHG must be allocated individually (e.g., use a separate row for CO2, CH4, and N2O)","Minimum ratio allowed by energy balance","Maximum ratio allowed by energy balance","Efficiency of heat production divided by efficiency of power production (recommended 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 * 2205 / A","L = J * 2205 / B"]
[null,null,null,"Description of Entry","GHG","(MMBtu or MWh)","(same unit as in column A)","(same unit as in column A)","(MMBtu or MWh)","metric tonnes GHG",null,null,"eh/ep",null,null,"metric tonnes GHG","metric tonnes GHG","lb GHG / energy unit in D","lb GHG / energy unit in D"]
[null,null,"Example>>","Cogen system 1","CO2",1000,500,2679,"MWh",587.4,{"$f":"IF(ISERROR(F24/(H24-G24)),\"\",F24/(H24-G24))","v":0.45892611289582375},{"$f":"IF(ISERROR((H24-F24)/G24),\"\",(H24-F24)/G24)","v":3.3580000000000001},2.2999999999999998,{"$f":"+IF(ISERROR((F24+M24*G24)/(H24*M24)),\"\",(F24+M24*G24)/(H24*M24))","v":0.3489296784978172},{"$f":"IF(ISERROR(M24*N24),\"\",M24*N24)","v":0.80253826054497945},{"$f":"+IF(ISERROR(J24*(F24/(F24+G24*M24))),\"\",J24*(F24/(F24+G24*M24)))","v":273.2093023255814},{"$f":"IF(ISERROR(J24-P24),\"\",J24-P24)","v":314.19069767441857},{"$f":"IF(ISERROR(P24*2205/F24),\"\",P24*2205/F24)","v":602.42651162790708},{"$f":"IF(ISERROR(Q24*1000/G24),\"\",Q24*2205/G24)","v":1385.5809767441858}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(F25/(H25-G25)),\"\",F25/(H25-G25))","v":""},{"$f":"IF(ISERROR((H25-F25)/G25),\"\",(H25-F25)/G25)","v":""}]
[null,"Purch stm:",null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(F26/(H26-G26)),\"\",F26/(H26-G26))","v":""},{"$f":"IF(ISERROR((H26-F26)/G26),\"\",(H26-F26)/G26)","v":""},null,{"$f":"+IF(ISERROR((F26+M26*G26)/(H26*M26)),\"\",(F26+M26*G26)/(H26*M26))","v":""},{"$f":"IF(ISERROR(M26*N26),\"\",M26*N26)","v":""},{"$f":"+IF(ISERROR(J26*(F26/(F26+G26*M26))),\"\",J26*(F26/(F26+G26*M26)))","v":""},{"$f":"IF(ISERROR(J26-P26),\"\",J26-P26)","v":""},{"$f":"IF(ISERROR(P26*2205/F26),\"\",P26*2205/F26)","v":""},""]
[null,"Export pwr:",null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(F27/(H27-G27)),\"\",F27/(H27-G27))","v":""},{"$f":"IF(ISERROR((H27-F27)/G27),\"\",(H27-F27)/G27)","v":""},null,{"$f":"+IF(ISERROR((F27+M27*G27)/(H27*M27)),\"\",(F27+M27*G27)/(H27*M27))","v":""},{"$f":"IF(ISERROR(M27*N27),\"\",M27*N27)","v":""},{"$f":"+IF(ISERROR(J27*(F27/(F27+G27*M27))),\"\",J27*(F27/(F27+G27*M27)))","v":""},{"$f":"IF(ISERROR(J27-P27),\"\",J27-P27)","v":""},"",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(F28/(H28-#REF!)),\"\",F28/(H28-#REF!))","v":""},{"$f":"IF(ISERROR((H28-F28)/#REF!),\"\",(H28-F28)/#REF!)","v":""},null,{"$f":"+IF(ISERROR((F28+M28*#REF!)/(H28*M28)),\"\",(F28+M28*#REF!)/(H28*M28))","v":""},{"$f":"IF(ISERROR(M28*N28),\"\",M28*N28)","v":""},{"$f":"+IF(ISERROR(J28*(F28/(F28+#REF!*M28))),\"\",J28*(F28/(F28+#REF!*M28)))","v":""},{"$f":"IF(ISERROR(J28-P28),\"\",J28-P28)","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":8,"n_rows":120,"n_cols":11,"rows_kept":120,"cut":false,"hidden":false,"merged":[[39,2,39,5],[30,2,30,6],[32,2,32,10],[0,1,0,12],[6,3,6,4],[7,3,7,4],[5,3,5,4],[12,4,12,6],[12,7,12,9]]}
[null,"These spreadsheets include significant amounts of material copied from other WRI and WBCSD calculation tools. \n Intellectual property rights of the WRI and WBCSD calculation tools belong to WRI and WBCSD, unless stated otherwise."]
[null,null,"Indirect Emissions"]
[null,null,"Electricity and/or steam imports"]
[]
[null,"EXPLANATION OF CELL COLOR SCHEME"]
[null,null,null,"User entry: Source description"]
[null,null,null,"User entry: Fuel use / emission factor values"]
[null,null,null,"Auto 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,"Suggested emission factors from DOE shown below","Suggested emission factors from DOE shown below","Suggested emission factors from DOE shown below","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 tonnes CO2"," metric tonnes CH4"," metric tonnes N2O","Text explanation"]
[]
[null,null,"Stream description","Electricty/steam Imports (MWh)","Em. factor (lb CO2/MWh)","Em. factor (lb CH4/MWh)","Em. factor (lb N2O/MWh)","Em. (tonne CO2)","Em. (tonne CH4)","Em. (tonne N2O)","em. factor source/basis"]
[null,null,null,null,null,null,null,{"$f":"IF(D20=\"\",\"\",D20*E20/2205)","v":""},{"$f":"IF(D20=\"\",\"\",D20*F20/2205)","v":""},{"$f":"IF(D20=\"\",\"\",D20*G20/2205)","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(D21=\"\",\"\",D21*E21/2205)","v":""},{"$f":"IF(D21=\"\",\"\",D21*F21/2205)","v":""},{"$f":"IF(D21=\"\",\"\",D21*G21/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,null,null,null,"","",""]
[null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,"CO2","CH4","N2O"]
[null,null,"Step 4: Sum of indirect emissions from purchased electricity or steam (in metric tonnes):",null,null,null,null,{"$f":"SUM(H20:H29)","v":0},{"$f":"SUM(I20:I29)","v":0},{"$f":"SUM(J20:J29)","v":0}]
[]
[null,null,"* Emission factors for purchased electricity can normally be obtained from national authorities or from the supplier of the purchased electricity.  These tools provide, as suggested defaults, purchased electricity emission factors provided in the DOE's Instructions for Form EIA-1605 Voluntary Reporting of Greenhouse Gases, For Data Through 2002, dated March 2003\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,"Suggested default emission factors for purchased electricity:"]
[null,null,"Adjusted Electricity Emission Factors by State and Region, reproduced from DOE Instructions for Form EIA-1605 Voluntary Reporting of Greenhouse Gases For Data Through 2002, Appendix C"]
[]
[]
[null,null,null,"Carbon Dioxide","Methane","Nitrous Oxide"]
[null,null,"Region/State","lbs/MWh","lbs/MWh","lbs/MWh"]
[null,null,"New England",980,2.07E-2,1.46E-2]
[null,null,"Connecticut",940,1.7399999999999999E-2,1.2E-2]
[null,null,"Maine",850,5.6500000000000002E-2,2.7E-2]
[null,null,"Massachusetts",1280,1.7399999999999999E-2,1.5900000000000001E-2]
[null,null,"New Hampshire",680,1.72E-2,1.41E-2]
[null,null,"Rhode Island",1050,6.7999999999999996E-3,4.7000000000000002E-3]
[null,null,"Vermont",30,9.5999999999999992E-3,3.8999999999999998E-3]
[null,null,"Mid Atlantic",1040,9.2999999999999992E-3,1.4500000000000001E-2]
[null,null,"New Jersey",710,7.7000000000000002E-3,7.9000000000000008E-3]
[null,null,"New York",860,8.0999999999999996E-3,8.8999999999999999E-3]
[null,null,"Pennsylvania",1260,1.0699999999999999E-2,2.0299999999999999E-2]
[null,null,"East-North Central",1630,1.23E-2,2.5700000000000001E-2]
[null,null,"Illinois",1160,8.2000000000000007E-3,1.7999999999999999E-2]
[null,null,"Indiana",2080,1.43E-2,3.2300000000000002E-2]
[null,null,"Michigan",1580,1.46E-2,2.5000000000000001E-2]
[null,null,"Ohio",1800,1.2999999999999999E-2,2.8799999999999999E-2]
[null,null,"Wisconsin",1640,1.38E-2,2.5999999999999999E-2]
[null,null,"West-North Central",1730,1.2699999999999999E-2,2.69E-2]
[null,null,"Iowa",1880,1.38E-2,2.98E-2]
[null,null,"Kansas",1680,1.12E-2,2.5399999999999999E-2]
[null,null,"Minnesota",1520,1.5699999999999999E-2,2.47E-2]
[null,null,"Missouri",1840,1.26E-2,2.8799999999999999E-2]
[null,null,"Nebraska",1400,9.4999999999999998E-3,2.1899999999999999E-2]
[null,null,"North Dakota",2240,1.47E-2,3.39E-2]
[null,null,"South Dakota",800,5.3E-3,1.21E-2]
[null,null,"South Atlantic",1350,1.2699999999999999E-2,2.07E-2]
[null,null,"Delaware",1830,1.23E-2,2.2700000000000001E-2]
[null,null,"Florida",1390,1.4999999999999999E-2,1.7999999999999999E-2]
[null,null,"Georgia",1370,1.29E-2,2.2599999999999999E-2]
[null,null,"Maryland*",1370,1.18E-2,2.06E-2]
[null,null,"North Carolina",1240,1.0500000000000001E-2,2.0299999999999999E-2]
[null,null,"South Carolina",830,9.1000000000000004E-3,1.4500000000000001E-2]
[null,null,"Virginia",1160,1.37E-2,1.9199999999999998E-2]
[null,null,"West Virginia",1980,1.37E-2,3.1600000000000003E-2]
[null,null,"East-South Central",1490,1.2800000000000001E-2,2.4E-2]
[null,null,"Alabama",1310,1.37E-2,2.23E-2]
[null,null,"Kentucky",2010,1.4E-2,3.2099999999999997E-2]
[null,null,"Mississippi",1290,1.32E-2,1.6500000000000001E-2]
[null,null,"Tennessee",1300,1.0500000000000001E-2,2.12E-2]
[null,null,"West-South Central",1430,8.6999999999999994E-3,1.5299999999999999E-2]
[null,null,"Arkansas",1290,1.2500000000000001E-2,2.0299999999999999E-2]
[null,null,"Louisiana",1180,9.4000000000000004E-3,1.12E-2]
[null,null,"Oklahoma",1720,1.0999999999999999E-2,2.23E-2]
[null,null,"Texas",1460,7.7000000000000002E-3,1.46E-2]
[null,null,"Mountain",1560,1.0800000000000001E-2,2.3599999999999999E-2]
[null,null,"Arizona",1050,6.7999999999999996E-3,1.54E-2]
[null,null,"Colorado",1930,1.2699999999999999E-2,2.8899999999999999E-2]
[null,null,"Idaho",30,8.0000000000000002E-3,3.3E-3]
[null,null,"Montana",1430,1.0800000000000001E-2,2.2700000000000001E-2]
[null,null,"Nevada",1520,8.9999999999999993E-3,1.95E-2]
[null,null,"New Mexico",2020,1.3100000000000001E-2,2.9600000000000001E-2]
[null,null,"Utah",1930,1.34E-2,3.0800000000000001E-2]
[null,null,"Wyoming",2150,1.47E-2,3.3799999999999997E-2]
[null,null,"Pacific Contiguous",450,5.3E-3,3.7000000000000002E-3]
[null,null,"California",610,6.7000000000000002E-3,3.7000000000000002E-3]
[null,null,"Oregon",280,3.3E-3,3.3999999999999998E-3]
[null,null,"Washington",250,3.7000000000000002E-3,4.0000000000000001E-3]
[null,null,"Pacific Non-contiguous",1560,1.61E-2,1.49E-2]
[null,null,"Alaska",1380,6.7999999999999996E-3,8.8999999999999999E-3]
[null,null,"Hawaii",1660,2.1399999999999999E-2,1.83E-2]
[null,null,"United States",1340,1.11E-2,1.9199999999999998E-2]
[]
[null,null,"Note:  These state- and regional-level electricity emission factors represent"]
[null,null,"average emissions per MWh generated by utility and nonutility electric"]
[null,null,"generators for the 1998-2000 time period.  The Voluntary Reporting of"]
[null,null,"Greenhouse Gases Program believes these factors provide reasonably"]
[null,null,"accurate default values for power generated in a given state or region (US"]
[null,null,"Census Division).  However, reporters should use these state- and regional-"]
[null,null,"level factors only if utility-specific or power pool-specific emission factors"]
[null,null,"are not available"]
[]
[null,null,"*Includes the District of Columbia"]
[]
[null,null,"Source:  Energy Information Administration, Updated State- and Regional-"]
[null,null,"level Greenhouse Gas Emission Factors for Electricity (March 2002),"]
[null,null,"http:/www.eia.doe.gov/oiaf/1605/e-factor.html."]

{"sheet":"Energy Exports","index":9,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,3,34,7],[17,8,17,10],[0,1,0,12],[7,3,7,4],[8,3,8,4],[9,3,9,4],[17,4,17,6],[12,2,12,7]]}
[null,"These spreadsheets include significant amounts of material copied from other WRI and WBCSD calculation tools. \n Intellectual property rights of the WRI and WBCSD calculation tools belong to WRI and WBCSD, unless stated otherwise."]
[null,null,"Emissions Associated with Exports of Electricity and Steam"]
[]
[null,null,"Note: The emissions related to electricity and steam exports "]
[null,null,"should be reported separately from indirect emissions from imported power or steam"]
[]
[null,"EXPLANATION OF CELL COLOR SCHEME"]
[null,null,null,"User entry: Source description"]
[null,null,null,"User entry: Fuel use / emission factor values"]
[null,null,null,"Auto calculated value:"]
[]
[]
[null,null,"Direct emissions attributable to electricity and steam exports"]
[]
[]
[null,null,"The direct 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","Portion of direct CO2 emissions related to exported power/steam","Portion of direct CH4 emissions related to exported power/steam","Portion of direct N2O emissions related to exported power/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*21)+(H*310)]/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 tons CO2 equiv / MWh"]
[]
[null,null,"Stream description","Total energy prod. (MWh)","Total emissions (tonne CO2)","Total emissions (tonne CH4)","Total emissions (tonne N2O)","Energy exports (MWh)","CO2 emissions (tonnes)","CH4 emissions (tonnes)","N2O emissions (tonnes)","Carbon intensity (tonnes CO2 eq/MWh)",null,"Carbon intensity on grid (tonne CO2 eq. / MWh)"]
[null,null,null,null,null,null,null,null,{"$f":"IF($D25=0,\"\",E25*$H25/$D25)","v":""},{"$f":"IF($D25=0,\"\",F25*$H25/$D25)","v":""},{"$f":"IF($D25=0,\"\",G25*$H25/$D25)","v":""},{"$f":"+IF(D25=0,\"\",(E25+(F25*21)+(G25*310))/D25)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF($D26=0,\"\",E26*$H26/$D26)","v":""},{"$f":"IF($D26=0,\"\",F26*$H26/$D26)","v":""},{"$f":"IF($D26=0,\"\",G26*$H26/$D26)","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,"","","",""]
[null,null,null,null,null,null,null,null,"CO2","CH4","N2O"]
[null,null,null,"Step 5: Sum of direct emissions attributable to exported power or steam (metric tonnes):",null,null,null,null,{"$f":"SUM(I25:I33)","v":0},{"$f":"SUM(J25:J33)","v":0},{"$f":"SUM(K25:K33)","v":0}]

{"sheet":"CO2 Imports and Exports","index":10,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,7],[0,1,0,12],[14,2,14,4]]}
[null,"These spreadsheets include significant amounts of material copied from other WRI and WBCSD calculation tools. \n Intellectual property rights of the WRI and WBCSD calculation tools belong to WRI and WBCSD, unless stated otherwise."]
[null,"Imports and Exports of Fossil CO2 , including exports to satellite precipitated calcium carbonate (PCC) plants"]
[]
[null,null,"Fossil CO2 imported to mill site (e.g. for neutralization)"]
[]
[null,null,"Total fossil CO2 imported to mill\n[metric tonnes CO2 per year]"]
[null,"Example",19375]
[]
[]
[]
[]
[]
[null,null,"Fossil fuel-derived CO2 exported to satellite precipitated calcium carbonate (PCC) plants"]
[]
[null,null,"Note that where CO2 exports consist of gases from a fossil fuel fired lime kiln or calciner, the exports of fossil fuel-derived CO2 shown in the GHG inventory results will be accompanied by exports of climate-neutral biomass-derived CO2.  As a general approximation, the amounts of climate-neutral biomass-derived CO2 will be twice the exports of fossil fuel-derived CO2 (Miner, R. and Upton, B.  2002.  Methods for estimating greenhouse gas emissions from lime kilns at kraft pulp mills.  Energy, Volume 27 No. 8, pp. 729-738 (Sept. 2002).)  \n\nAdditional information on biomass is presented in the \"Supporting Info. on Biomass\" worksheet."]
[]
[null,null,"Total CO2 generated by burning fossil fuel in the combustion unit supplying the PCC plant\n[metric tonnes CO2 per year]","Fraction of the gas from this source that is sent to the PCC plant over a year's time \n\n(Note: Amounts released by the mill rather than exported to the PCC plant should be shown on the \"Direct - fuel combust.\" worksheet)","Fossil CO2 Exports to PCC plant\n[metric tonnes CO2 per year]"]
[null,"Example",47000,0.9,{"$f":"D18*C18","v":42300}]
[null,null,"Total CO2 Generated","Fraction gas sent to PCC","CO2 Exports to PCC (tonne)",null,"Total  Fossil CO2 Imports (tonnes)"]
[null,null,null,null,{"$f":"D20*C20","v":0},null,{"$f":"IF(C9=0,\"\",C9)","v":""}]

{"sheet":"Summary Table","index":11,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[15,2,15,3],[17,2,17,3],[0,2,0,14],[4,2,4,3],[6,2,6,3],[9,2,9,3],[33,2,33,8],[30,2,30,3],[4,5,4,8],[6,5,6,8],[32,2,32,8],[20,2,20,3],[22,2,22,3],[24,2,24,3],[28,2,28,3],[13,2,13,3]]}
[null,null,"These spreadsheets include significant amounts of material copied from other WRI and WBCSD calculation tools. \n Intellectual property rights of the WRI and WBCSD calculation tools belong to WRI and WBCSD, unless stated otherwise."]
[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 Emissions",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 combustion",null,null,{"$f":"'Stationary Combustion'!I50","v":0},{"$f":"'Stationary Combustion'!J50","v":0},{"$f":"'Stationary Combustion'!K50","v":0},{"$f":"'Stationary Combustion'!L50","v":0}]
[]
[null,null,null,"GHGs associated with electricity/steam wholesaling\n(this is a subset of direct emissions from stationary combustion)*",null,{"$f":"'Energy Exports'!I35","v":0},{"$f":"'Energy Exports'!J35","v":0},{"$f":"'Energy Exports'!K35","v":0},{"$f":"F12+G12*21+H12*310","v":0}]
[]
[null,null,"Direct emissions from transportation and mobile Sources",null,null,{"$f":"'Mobile & Transportation'!J97","v":0},{"$f":"'Mobile & Transportation'!K97","v":0},{"$f":"'Mobile & Transportation'!L97","v":0},{"$f":"F14+G14*21+H14*310","v":0}]
[]
[null,null,"Direct emissions from waste management",null,null,"N/A",{"$f":"'Waste Mngmt.'!P47+'Waste Mngmt.'!J158","v":0},"N/A",{"$f":"G16*21","v":0}]
[]
[null,null,"Direct emissions from make-up chemicals used in the pulp mill",null,null,{"$f":"'Direct - Make-up Carbonates'!F11","v":0},"N/A","N/A",{"$f":"F18","v":0}]
[]
[null,null,"Indirect Emissions**",null,null,"CO2\n(metric tonnes)","CH4\n(metric tonnes)","N2O\n(metric tonnes)","CO2-equiv\n(metric tonnes)"]
[null,null,"Indirect emissions from purchased power/steam/hot water",null,null,{"$f":"'Indirect - Energy Imports'!H31","v":0},{"$f":"'Indirect - Energy Imports'!I31","v":0},{"$f":"'Indirect - Energy Imports'!J31","v":0},{"$f":"F21+G21*21+H21*310","v":0}]
[]
[null,null,"Indirect emissions from transportation and mobile sources",null,null,{"$f":"'Mobile & Transportation'!M97","v":0},{"$f":"'Mobile & Transportation'!N97","v":0},{"$f":"'Mobile & Transportation'!O97","v":0},{"$f":"F23+G23*21+H23*310","v":0}]
[]
[null,null,"Indirect emissions from waste management activities",null,null,"N/A",{"$f":"'Waste Mngmt.'!Q47+'Waste Mngmt.'!K158","v":0},"N/A",{"$f":"G25*21","v":0}]
[]
[null,null,"Additional Information: Imports and Exports of Greenhouse Gases"]
[null,null,null,null,null,"CO2\n(metric tonnes)",null,null,"CO2-equiv\n(metric tonnes)"]
[null,null,"Fossil CO2 Imports to Mill",null,null,{"$f":"'CO2 Imports and Exports'!C9","v":0},"N/A","N/A",{"$f":"F29","v":0}]
[]
[null,null,"Fossil CO2 Exports to PCC Plants",null,null,{"$f":"'CO2 Imports and Exports'!E20","v":0},"N/A","N/A",{"$f":"F31","v":0}]
[]
[null,null,"*DOE's Instructions for Form EIA-1605 Voluntary Reporting of Greenhouse Gases, For Data Through 2002 states that \" 'CO2 Associated with Electricity Wholesaling' asks for emissions associated with your sale of electricity, steam, and hot water to other entities for resale.  This pertains to power wholesales and not to retail sales.\"  The Instructions for Form EIA-1605 request this result to be recorded under Part IIa. Indirect Emissions."]
[null,null,"**DOE's Instructions for Form EIA-1605 Voluntary Reporting of Greenhouse Gases, For Data Through 2002 states that \" 'Net CO2 from Power Transactions' is the difference between 'Indirect CO2 from Purchased Power' and 'CO2 Associated with Electricity Wholesaling.' \"  Therefore, in completing form EIA-1605 the user of these tools can compute \"Net CO2 from Power Transactions\" by subtracting the values in row 12 of this worksheet (\"GHGs associated with electricity/steam wholesaling\") from the values in row 21 (\"Indirect emissions from purchased power/steam/hot water\")."]

{"sheet":"Custom Emission Factors","index":12,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[9,3,9,4],[7,3,7,4],[8,3,8,4]]}
["The intellectual property rights of this calculation tool belong to WRI and WBCSD, unless stated otherwise in any of the tools."]
["Please cite the orginial reference when using this tool."]
[]
[null,null,"Custom Emission Factors"]
[null,null,"Calculating custom emission factors"]
[]
[null,"EXPLANATION OF CELL COLOR SCHEME"]
[null,null,null,"User entry: Source description"]
[null,null,null,"User entry: Fuel use / emission factor values"]
[null,null,null,"Auto calculated value:"]
[]
[]
[]
[null,null,null,"A","B","C"]
[null,null,null,"Higher Heating Value\n(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(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}]
[null,null,null,null,null,{"$f":"IF(D23=0,0,3.664*2000*E23/D23)","v":0}]
[null,null,null,null,null,{"$f":"IF(D24=0,0,3.664*2000*E24/D24)","v":0}]
[null,null,null,null,null,{"$f":"IF(D25=0,0,3.664*2000*E25/D25)","v":0}]

{"sheet":"Energy content","index":13,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,0,2,5],[35,1,35,5],[34,1,34,5]]}
[]
["Energy content (HHV)"]
["Default factors for fuel specific higher heating values"]
["Copied from the WRI/WBCSD Calculation tools (unless specifically noted otherwise for specific entries)"]
[]
[]
[]
[null,"Fuel type","Higher heating value‡","Heating Value Units","Carbon, % by weight*","Typical density*"]
[null,null,"(HHV)",null,null,"( lb / gal )"]
[]
[null,"Gasoline / petrol",{"$f":"18.355/152.717","v":0.12018963180261528},"MMBtu HHV/gallon",85.5,6.17]
[null,"Kerosene",{"$f":"21.537/159.535","v":0.13499858965117373},"MMBtu HHV/gallon",null,6.76]
[null,"Aviation Gasoline",{"$f":"18.355/152.717","v":0.12018963180261528},"MMBtu HHV/gallon"]
[null,"Jet Fuel",{"$f":"21.095/156.258","v":0.13500108794429724},"MMBtu HHV/gallon"]
[null,"Diesel",{"$f":"22.384/161.386","v":0.13869852403554211},"MMBtu HHV/gallon",null,7.1]
[null,"Distillate fuel oil No.1",{"$f":"22.384/161.386","v":0.13869852403554211},"MMBtu HHV/gallon",86.6,7.05]
[null,"Distillate fuel oil No.2",{"$f":"22.384/161.386","v":0.13869852403554211},"MMBtu HHV/gallon",87.3,7.05]
[null,"Distillate fuel oil No.4",{"$f":"22.384/161.386","v":0.13869852403554211},"MMBtu HHV/gallon",86.4,7.59]
[null,"Residual fuel oil No.5",{"$f":"26.033/173.906","v":0.14969581268041357},"MMBtu HHV/gallon",88.7,7.93]
[null,"Residual fuel oil No.6",{"$f":"26.033/173.906","v":0.14969581268041357},"MMBtu HHV/gallon",88.3,8.4499999999999993]
[null,"LPG",{"$f":"12.805/139.039","v":9.2096462143715085E-2},"MMBtu HHV/gallon",null,4.5199999999999996]
[null,"Propane",{"$f":"12.669/139.178","v":9.1027317535817442E-2},"MMBtu HHV/gallon",81.599999999999994,"4.24 (liquid)"]
[null,"Anthracite",{"$f":"3852.16/227.4","v":16.940017590149516},"MMBtu HHV/short ton",80.599999999999994]
[null,"Bituminous coal",{"$f":"4931.3/205.3","v":24.019970774476377},"MMBtu HHV/short ton",80.099999999999994]
[null,"Sub Bituminous coal",{"$f":"3715.9/212.7","v":17.470145745181007},"MMBtu HHV/short ton"]
[null,"Lignite",{"$f":"2791.6/215.4","v":12.960074280408541},"MMBtu HHV/short ton"]
[null,"Tire derived fuel",{"$f":"6160/189.538","v":32.500079139803098},"MMBtu HHV/short ton"]
[null,"Butane","0.0974*","MMBtu HHV/gallon",83.6,"4.84 (liquid)"]
[null,"Petroleum Coke",{"$f":"6768.667/225.13","v":30.065593212810377},"MMBtu HHV/short ton",85]
[null,"Natural gas",{"$f":"120.593/117.08","v":1.0300051247010591},"MMBtu HHV/1000 ft3","69.4 wt% C (92.5 wt% CH4)","0.04228 lb/ft3***"]
[null,"Methane",{"$f":"116.376/115.258","v":1.0096999774419131},"MMBtu HHV/1000 ft3"]
[null,"Wood (\"for as-fired dry wood\")",{"$f":"3120/195","v":16},"MMBtu HHV/short ton"]
[null,"Pulping Liqour information is in \"Supporting Info on Biomass\" worksheet"]
[]
[null,"‡ Calculated from data in Instructions for Form EIA-1605 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/1605INST02.pdf (31 October 2003), unless otherwise noted"]
[null,"*American Petroleum Institute (API), Compendium of Greenhouse Gas Emissions Estimation Methodologies for the Oil & Gas Industry (Pilot Test Version), 2001"]
[null,"*** From DOE Instructions for Form EIA-1605, March 2003"]

{"sheet":"Conversion Factors","index":14,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["The intellectual property rights of this calculation tool belong to WRI and WBCSD, unless stated otherwise in any of the tools."]
["Please cite the orginial reference when using this tool."]
[]
["Conversion Factors"]
[]
[]
[]
[null,null,"Mass"]
[null,null,"1 pound (lb)","453.6 grams (g)","0.4536 kilograms (kg)","0.0004536 metric tons (tonne)"]
[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 ton","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 (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 ton CH4","21 metric tons CO2 equivalent"]
[null,null,"1metric  ton N2O","310 metric tons CO2 equivalent"]
[null,null,"1 metric ton carbon","3.664 metric tons CO2"]

{"sheet":"Energy Factors","index":15,"n_rows":220,"n_cols":256,"rows_kept":220,"cut":false,"hidden":false,"merged":[]}
["This table presents a matrix of factors for converting fuel consumption input data into units of MMBtu (HHV)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disable Error Notification Save Box"]
["(Fuel consumption data in units listed can be converted to units of MMBtu HHV by multiplying by the factor)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
["Consumption Input Units (right)","Btu (HHV)","Btu (LHV)","Million Btu (HHV)","Million Btu (LHV)","GJ (HHV)","US gallon","Liter","bbl","std ft3","std m3","lb","US ton","Metric Tonne","GJ (LHV)","MWh"]
["Fuel type (below)"]
["Gasoline",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.1202,{"$f":"IF(G6=\"N/A\",\"N/A\",G6/3.785)","v":3.1756935270805808E-2},{"$f":"IF(G6=\"N/A\",\"N/A\",G6*42)","v":5.0484},"N/A","N/A",{"$f":"IF(G6=\"N/A\",\"N/A\",G6/6.17)","v":1.9481361426256078E-2},{"$f":"L6*2000","v":38.962722852512158},{"$f":"L6*2205","v":42.956401944894651},0.99780000000000002,3.4119999999999999]
["Gasoline / petrol",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.1202,{"$f":"IF(G7=\"N/A\",\"N/A\",G7/3.785)","v":3.1756935270805808E-2},5.0484,"N/A","N/A",{"$f":"IF(G7=\"N/A\",\"N/A\",G7/6.17)","v":1.9481361426256078E-2},{"$f":"L7*2000","v":38.962722852512158},42.956401944894651,0.99780000000000002,3.4119999999999999]
["Gasoline / petrol Mobile 4-stroke engines",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.1202,{"$f":"IF(G8=\"N/A\",\"N/A\",G8/3.785)","v":3.1756935270805808E-2},5.0484,"N/A","N/A",{"$f":"IF(G8=\"N/A\",\"N/A\",G8/6.17)","v":1.9481361426256078E-2},{"$f":"L8*2000","v":38.962722852512158},42.956401944894651,0.99780000000000002,3.4119999999999999]
["Gasoline / petrol Mobile 2-stroke engines, general",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.1202,{"$f":"IF(G9=\"N/A\",\"N/A\",G9/3.785)","v":3.1756935270805808E-2},5.0484,"N/A","N/A",{"$f":"IF(G9=\"N/A\",\"N/A\",G9/6.17)","v":1.9481361426256078E-2},{"$f":"L9*2000","v":38.962722852512158},42.956401944894651,0.99780000000000002,3.4119999999999999]
["Gasoline / petrol Mobile 2-stroke engines, forestry",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.1202,{"$f":"IF(G10=\"N/A\",\"N/A\",G10/3.785)","v":3.1756935270805808E-2},5.0484,"N/A","N/A",{"$f":"IF(G10=\"N/A\",\"N/A\",G10/6.17)","v":1.9481361426256078E-2},{"$f":"L10*2000","v":38.962722852512158},42.956401944894651,0.99780000000000002,3.4119999999999999]
["Kerosene, Mobile sources",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.13500000000000001,{"$f":"IF(G11=\"N/A\",\"N/A\",G11/3.785)","v":3.5667107001321002E-2},5.67,"N/A","N/A",{"$f":"IF(G11=\"N/A\",\"N/A\",G11/6.76)","v":1.9970414201183433E-2},{"$f":"L11*2000","v":39.940828402366868},44.034763313609467,0.99780000000000002,3.4119999999999999]
["Kerosene",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.13500000000000001,3.5667107001321002E-2,{"$f":"IF(G12=\"N/A\",\"N/A\",G12*42)","v":5.67},"N/A","N/A",{"$f":"IF(G12=\"N/A\",\"N/A\",G12/6.76)","v":1.9970414201183433E-2},39.940828402366868,44.034763313609467,0.99780000000000002,3.4119999999999999]
["Jet Fuel",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.13500000000000001,3.5667107001321002E-2,5.67,"N/A","N/A","N/A","N/A","N/A",0.99780000000000002,3.4119999999999999]
["Aviation gasoline",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.1202,3.1756935270805808E-2,5.0484,"N/A","N/A","N/A","N/A","N/A",0.99780000000000002,3.4119999999999999]
["Distillate fuel (#1, 2, 4 fuel oil/diesel) Stationary sources except kilns/calciners",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.13869999999999999,3.6644649933949801E-2,5.8253999999999992,"N/A","N/A",{"$f":"IF(G15=\"N/A\",\"N/A\",G15/7.1)","v":1.9535211267605632E-2},39.070422535211264,{"$f":"L15*2205","v":43.075140845070422},0.99780000000000002,3.4119999999999999]
["Distillate fuel (No.1, No.2, No.4 fuel oil and diesel) Lime kilns",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.13869999999999999,3.6644649933949801E-2,5.8253999999999992,"N/A","N/A",1.9535211267605632E-2,39.070422535211264,43.075140845070422,0.99780000000000002,3.4119999999999999]
["Distillate fuel (No.1, No.2, No.4 fuel oil and diesel) Calciners",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.13869999999999999,3.6644649933949801E-2,5.8253999999999992,"N/A","N/A",1.9535211267605632E-2,39.070422535211264,43.075140845070422,0.99780000000000002,3.4119999999999999]
["Diesel, Mobile sources",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.13869999999999999,3.6644649933949801E-2,{"$f":"IF(G18=\"N/A\",\"N/A\",G18*42)","v":5.8253999999999992},"N/A","N/A",1.9535211267605632E-2,39.070422535211264,43.075140845070422,0.99780000000000002,3.4119999999999999]
["Distillate fuel, No.1, Mobile sources",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.13869999999999999,3.6644649933949801E-2,5.8253999999999992,"N/A","N/A",1.9535211267605632E-2,39.070422535211264,43.075140845070422,0.99780000000000002,3.4119999999999999]
["Distillate fuel, No. 2, Mobile sources",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.13869999999999999,3.6644649933949801E-2,5.8253999999999992,"N/A","N/A",1.9535211267605632E-2,39.070422535211264,43.075140845070422,0.99780000000000002,3.4119999999999999]
["No. 4 fuel oil, Mobile sources",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.13869999999999999,3.6644649933949801E-2,5.8253999999999992,"N/A","N/A",1.9535211267605632E-2,39.070422535211264,43.075140845070422,0.99780000000000002,3.4119999999999999,"Fuel type","lb CO2/MMBtu HHV","lb CH4/MMBtu HHV","lb N2O/MMBtu HHV"]
["Diesel",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.13869999999999999,3.6644649933949801E-2,5.8253999999999992,"N/A","N/A",1.9535211267605632E-2,39.070422535211264,43.075140845070422,0.99780000000000002,3.4119999999999999,"Gasoline / petrol",156.42500000000001]
["Distillate fuel oil No. 1",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.13869999999999999,3.6644649933949801E-2,5.8253999999999992,"N/A","N/A",1.9535211267605632E-2,39.070422535211264,43.075140845070422,0.99780000000000002,3.4119999999999999,"Kerosene",159.535]
["Distillate fuel oil No. 2",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.13869999999999999,3.6644649933949801E-2,5.8253999999999992,"N/A","N/A",1.9535211267605632E-2,39.070422535211264,43.075140845070422,0.99780000000000002,3.4119999999999999,"Jet Fuel",156.25800000000001]
["Fuel oil #4",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.13869999999999999,3.6644649933949801E-2,5.8253999999999992,"N/A","N/A",1.9535211267605632E-2,39.070422535211264,43.075140845070422,0.99780000000000002,3.4119999999999999,"Aviation gasoline",152.71700000000001]
["Residual fuel oil (No.5, No.6 fuel oil)",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.1497,3.9550858652575953E-2,6.2873999999999999,"N/A","N/A",{"$f":"IF(G26=\"N/A\",\"N/A\",G26/8.19)","v":1.8278388278388281E-2},36.556776556776562,40.303846153846159,0.99780000000000002,3.4119999999999999,"Diesel",161.386]
["Residual fuel oil (No.5, No.6 fuel oil) Lime kilns",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.1497,3.9550858652575953E-2,6.2873999999999999,"N/A","N/A",{"$f":"IF(G27=\"N/A\",\"N/A\",G27/8.19)","v":1.8278388278388281E-2},36.556776556776562,40.303846153846159,0.99780000000000002,3.4119999999999999,"Distillate fuel oil No. 1",161.386]
["Residual fuel oil (No.5, No.6 fuel oil) Calciners",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.1497,3.9550858652575953E-2,6.2873999999999999,"N/A","N/A",{"$f":"IF(G28=\"N/A\",\"N/A\",G28/8.19)","v":1.8278388278388281E-2},36.556776556776562,40.303846153846159,0.99780000000000002,3.4119999999999999,"Distillate fuel oil No. 2",161.386]
["Residual Fuel oil#5",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.1497,3.9550858652575953E-2,{"$f":"IF(G29=\"N/A\",\"N/A\",G29*42)","v":6.2873999999999999},"N/A","N/A",{"$f":"IF(G29=\"N/A\",\"N/A\",G29/8.19)","v":1.8278388278388281E-2},36.556776556776562,40.303846153846159,0.99780000000000002,3.4119999999999999,"Fuel oil #4",161.386]
["Residual Fuel oil#6",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,0.1497,3.9550858652575953E-2,6.2873999999999999,"N/A","N/A",{"$f":"IF(G30=\"N/A\",\"N/A\",G30/8.19)","v":1.8278388278388281E-2},36.556776556776562,40.303846153846159,0.99780000000000002,3.4119999999999999,"Residual Fuel oil#5",173.90600000000001]
["Propane",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,9.0999999999999998E-2,{"$f":"IF(G31=\"N/A\",\"N/A\",G31/3.785)","v":2.404227212681638E-2},3.8220000000000001,"N/A","N/A",{"$f":"IF(G31=\"N/A\",\"N/A\",G31/4.24)","v":2.1462264150943395E-2},42.924528301886788,47.324292452830186,1.0529999999999999,3.4119999999999999,"Residual Fuel oil#6",173.90600000000001]
["Propane, Mobile sources",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,9.0999999999999998E-2,{"$f":"IF(G32=\"N/A\",\"N/A\",G32/3.785)","v":2.404227212681638E-2},3.8220000000000001,"N/A","N/A",{"$f":"IF(G32=\"N/A\",\"N/A\",G32/4.24)","v":2.1462264150943395E-2},42.924528301886788,47.324292452830186,1.0529999999999999,3.4119999999999999,"LPG",139.03899999999999]
["LPG",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,9.2100000000000001E-2,{"$f":"IF(G33=\"N/A\",\"N/A\",G33/3.785)","v":2.4332892998678995E-2},3.8681999999999999,"N/A","N/A",{"$f":"IF(G33=\"N/A\",\"N/A\",G33/4.52)","v":2.0376106194690269E-2},{"$f":"L33*2000","v":40.752212389380539},44.929314159292041,0.99780000000000002,3.4119999999999999,"Propane",139.178]
["LPG, Mobile sources",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,9.2100000000000001E-2,{"$f":"IF(G34=\"N/A\",\"N/A\",G34/3.785)","v":2.4332892998678995E-2},3.8681999999999999,"N/A","N/A",{"$f":"IF(G34=\"N/A\",\"N/A\",G34/4.52)","v":2.0376106194690269E-2},{"$f":"L34*2000","v":40.752212389380539},44.929314159292041,0.99780000000000002,3.4119999999999999,"Natural gas",117.08]
["Petroleum coke",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",{"$f":"IF(G35=\"N/A\",\"N/A\",G35/6.17)","v":"N/A"},{"$f":"IF(H35=\"N/A\",\"N/A\",H35/6.17)","v":"N/A"},{"$f":"IF(I35=\"N/A\",\"N/A\",I35/6.17)","v":"N/A"},0.99780000000000002,3.4119999999999999,"Methane",115.258]
["Natural gas (dry) - boilers and IR dryers",9.9999999999999995E-7,1.111E-6,1,1.111,0.94789999999999996,"N/A","N/A","N/A",1.0300000000000001E-3,{"$f":"J36*35.31","v":3.6369300000000007E-2},"N/A","N/A","N/A",1.0529999999999999,3.4119999999999999,"Anthracite",227.4]
["Natural gas (dry) - turbines",9.9999999999999995E-7,1.111E-6,1,1.111,0.94789999999999996,"N/A","N/A","N/A",1.0300000000000001E-3,{"$f":"J37*35.31","v":3.6369300000000007E-2},"N/A","N/A","N/A",1.0529999999999999,3.4119999999999999,"Bituminous coal",205.3]
["Natural gas (dry) - lime kiln",9.9999999999999995E-7,1.111E-6,1,1.111,0.94789999999999996,"N/A","N/A","N/A",1.0300000000000001E-3,3.6369300000000007E-2,"N/A","N/A","N/A",1.0529999999999999,3.4119999999999999,"Sub-bituminous coal",212.7]
["Natural gas (dry) - calciners",9.9999999999999995E-7,1.111E-6,1,1.111,0.94789999999999996,"N/A","N/A","N/A",1.0300000000000001E-3,3.6369300000000007E-2,"N/A","N/A","N/A",1.0529999999999999,3.4119999999999999,"Lignite",215.4]
["Natural gas (dry) - Int. Comb. Engine 2 - cycle lean burn",9.9999999999999995E-7,1.111E-6,1,1.111,0.94789999999999996,"N/A","N/A","N/A",1.0300000000000001E-3,3.6369300000000007E-2,"N/A","N/A","N/A",1.0529999999999999,3.4119999999999999]
["Natural gas (dry) - Int. Comb. Engine 4 - cycle lean burn",9.9999999999999995E-7,1.111E-6,1,1.111,0.94789999999999996,"N/A","N/A","N/A",1.0300000000000001E-3,3.6369300000000007E-2,"N/A","N/A","N/A",1.0529999999999999,3.4119999999999999]
["Natural gas (dry) - Int. Comb. Engine 4 - cycle rich burn",9.9999999999999995E-7,1.111E-6,1,1.111,0.94789999999999996,"N/A","N/A","N/A",1.0300000000000001E-3,3.6369300000000007E-2,"N/A","N/A","N/A",1.0529999999999999,3.4119999999999999]
["Natural gas",9.9999999999999995E-7,1.111E-6,1,1.111,0.94789999999999996,"N/A","N/A",{"$f":"IF(G43=\"N/A\",\"N/A\",G43*42)","v":"N/A"},1.0300000000000001E-3,3.6369300000000007E-2,{"$f":"IF(G43=\"N/A\",\"N/A\",G43/6.17)","v":"N/A"},"N/A","N/A",1.0529999999999999,3.4119999999999999]
["Natural gas (dry), Mobile sources",9.9999999999999995E-7,1.111E-6,1,1.111,0.94789999999999996,"N/A","N/A",{"$f":"IF(G44=\"N/A\",\"N/A\",G44*42)","v":"N/A"},1.0300000000000001E-3,3.6369300000000007E-2,{"$f":"IF(G44=\"N/A\",\"N/A\",G44/6.17)","v":"N/A"},"N/A","N/A",1.0529999999999999,3.4119999999999999]
["Methane",9.9999999999999995E-7,1.111E-6,1,1.111,0.94789999999999996,"N/A","N/A","N/A",1.01E-3,3.5663100000000003E-2,"N/A","N/A","N/A",1.0529999999999999,3.4119999999999999,"Fuel type","lb CO2/MMBtu HHV","lb CH4/MMBtu HHV","lb N2O/MMBtu HHV"]
["Anthracite",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",{"$f":"M46/2000","v":8.4700000000000001E-3},16.940000000000001,{"$f":"M46*1.1023","v":18.672962000000002},0.99780000000000002,3.4119999999999999,"Gasoline / petrol Mobile 4-stroke engines",156.42500000000001,0.1,4.0000000000000001E-3]
["Bituminous coal Overfeed stoker boiler",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",{"$f":"M47/2000","v":1.201E-2},24.02,{"$f":"M47*1.1023","v":26.477246000000001},0.99780000000000002,3.4119999999999999,"Gasoline / petrol Mobile 2-stroke engines, general",156.42500000000001,0.28999999999999998,8.9999999999999998E-4]
["Bituminous coal Underfeed stoker boiler",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",1.201E-2,24.02,26.477246000000001,0.99780000000000002,3.4119999999999999,"Gasoline / petrol Mobile 2-stroke engines, forestry",156.42500000000001,0.38,8.9999999999999998E-4]
["Bituminous coal - Pulverized Dry bottom, wall fired",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",1.201E-2,24.02,26.477246000000001,0.99780000000000002,3.4119999999999999,"Kerosene, Mobile sources",159.535]
["Bituminous coal - Pulverized Dry bottom, tangential firing",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",1.201E-2,24.02,26.477246000000001,0.99780000000000002,3.4119999999999999,"Diesel, Mobile sources",161.386,8.9999999999999993E-3,6.6000000000000003E-2]
["Bituminous coal - Pulverized Wet bottom",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",1.201E-2,24.02,26.477246000000001,0.99780000000000002,3.4119999999999999,"Distillate fuel, No.1, Mobile sources",161.386]
["Bituminous coal Spreader stoker boiler",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",1.201E-2,24.02,26.477246000000001,0.99780000000000002,3.4119999999999999,"Distillate fuel, No. 2, Mobile sources",161.386]
["Bituminous coal - fluidized bed Circulating or bubbling",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",1.201E-2,24.02,26.477246000000001,0.99780000000000002,3.4119999999999999,"No. 4 fuel oil, Mobile sources",161.386]
["Bituminous coal",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A",{"$f":"IF(G54=\"N/A\",\"N/A\",G54*42)","v":"N/A"},"N/A","N/A",1.251E-2,25.02,27.579546000000001,0.99780000000000002,3.4119999999999999,"LPG, Mobile sources",139.03899999999999]
["Sub-bituminous coal",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A",{"$f":"IF(G55=\"N/A\",\"N/A\",G55*42)","v":"N/A"},"N/A","N/A",8.2349999999999993E-3,16.47,18.154881,0.99780000000000002,3.4119999999999999,"Propane, Mobile sources",139.178]
["Sub-bituminous coal Overfeed stoker boiler",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",8.7349999999999997E-3,17.47,19.257180999999999,0.99780000000000002,3.4119999999999999,"Natural gas (dry), Mobile sources",117.08,0.01,2.0000000000000001E-4]
["Sub-bituminous coal Underfeed stoker boiler",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",8.7349999999999997E-3,17.47,19.257180999999999,0.99780000000000002,3.4119999999999999]
["Sub-bituminous coal - fluidized bed Circulating or bubbling",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",8.7349999999999997E-3,17.47,19.257180999999999,0.99780000000000002,3.4119999999999999]
["Lignite",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",6.4800000000000005E-3,12.96,14.285808000000001,0.99780000000000002,3.4119999999999999]
["Wood and wood waste",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",{"$f":"M60/2000","v":8.0000000000000002E-3},{"$f":"3120/195","v":16},{"$f":"M60*1.1023","v":17.636800000000001},0.99780000000000002,3.4119999999999999]
["Pulping liquors",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",{"$f":"M61/2000","v":6.0937499999999993E-3},{"$f":"AVERAGE(M65:M72)","v":12.187499999999998},{"$f":"M61*1.1023","v":13.434281249999998},0.99780000000000002,3.4119999999999999]
["Biogas used in boilers or kilns",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A",0.99780000000000002,3.4119999999999999]
["Tires and tire derived fuel",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",{"$f":"M63/2000","v":1.625003956990155E-2},{"$f":"6160/189.538","v":32.500079139803098},{"$f":"M63*1.1023","v":35.824837235804956},0.99780000000000002,3.4119999999999999]
["Municipal solid waste**",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",{"$f":"M64/2000","v":5.0011508401132821E-3},{"$f":"1999/199.854","v":10.002301680226564},{"$f":"M64*1.1023","v":11.025537142113743},0.99780000000000002,3.4119999999999999]
["Pulping Liquors: Scandinavian Softwood",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",{"$f":"M65/2000","v":6.0999999999999995E-3},12.2,{"$f":"M65*1.1023","v":13.44806},0.99780000000000002,3.4119999999999999]
["Pulping Liquors: Scandinavian Hardwood",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",{"$f":"M66/2000","v":5.7999999999999996E-3},11.6,{"$f":"M66*1.1023","v":12.78668},0.99780000000000002,3.4119999999999999]
["Pulping Liquors: North American Softwood",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",6.0999999999999995E-3,12.2,13.44806,0.99780000000000002,3.4119999999999999]
["Pulping Liquors: North American Hardwood",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",6.0000000000000001E-3,12,13.227600000000001,0.99780000000000002,3.4119999999999999]
["Pulping Liquors: Tropical Mixed Woods",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",6.0499999999999998E-3,12.1,13.33783,0.99780000000000002,3.4119999999999999]
["Pulping Liquors: Bagasse",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",6.3499999999999997E-3,12.7,13.99921,0.99780000000000002,3.4119999999999999]
["Pulping Liquors: Bamboo",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",6.0499999999999998E-3,12.1,13.33783,0.99780000000000002,3.4119999999999999]
["Pulping Liquors: Straw",9.9999999999999995E-7,1.0529999999999999E-6,1,1.0529999999999999,0.94789999999999996,"N/A","N/A","N/A","N/A","N/A",6.3E-3,12.6,13.88898,0.99780000000000002,3.4119999999999999]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Fuel type","lb CO2 / MMBtu  fuel\n[based on higher heating value, HHV]","lb CH4 / MMBtu fuel \n[based on higher heating value, HHV]","lb N2O / MMBtu fuel \n[based on higher heating value, HHV]"]
["Liquid fossil"]
["Gasoline",156.42500000000001]
["Kerosene",159.535]
["Jet Fuel",156.25800000000001]
["Aviation gasoline",152.71700000000001]
["Distillate fuel (#1, 2, 4 fuel oil/diesel) Stationary sources except kilns/calciners",161.386,4.0000000000000002E-4,8.9999999999999998E-4]
["Distillate fuel (No.1, No.2, No.4 fuel oil and diesel) Lime kilns",161.386,6.0000000000000001E-3,0]
["Distillate fuel (No.1, No.2, No.4 fuel oil and diesel) Calciners",161.386,6.0000000000000001E-3,1E-3]
["Residual fuel oil (No.5, No.6 fuel oil)",173.90600000000001,7.0000000000000001E-3,6.9999999999999999E-4]
["Residual fuel oil (No.5, No.6 fuel oil) Lime kilns",173.90600000000001,6.0000000000000001E-3,0]
["Residual fuel oil (No.5, No.6 fuel oil) Calciners",173.90600000000001,6.0000000000000001E-3,1E-3]
["LPG",139.03899999999999]
["Petroleum coke",225.13]
["Gaseous fossil"]
["Natural gas (dry) - boilers and IR dryers",117.08,2.8999999999999998E-3,2.0000000000000001E-4]
["Natural gas (dry) - turbines",117.08,1E-3,2.0000000000000001E-4]
["Natural gas (dry) - lime kiln",117.08,5.7000000000000002E-3,0]
["Natural gas (dry) - calciners",117.08,5.7000000000000002E-3,2.0000000000000001E-4]
["Natural gas (dry) - Int. Comb. Engine 2 - cycle lean burn",117.08,3.5999999999999997E-2,2.0000000000000001E-4]
["Natural gas (dry) - Int. Comb. Engine 4 - cycle lean burn",117.08,2.7E-2,2.0000000000000001E-4]
["Natural gas (dry) - Int. Comb. Engine 4 - cycle rich burn",117.08,6.1000000000000004E-3,2.0000000000000001E-4]
["Methane",115.258]
["Propane",139.178]
["Solid fossil"]
["Anthracite",227.4,0.02,3.0999999999999999E-3]
["Bituminous coal Overfeed stoker boiler",205.3,2E-3,3.5000000000000001E-3]
["Bituminous coal Underfeed stoker boiler",205.3,3.1E-2,3.5000000000000001E-3]
["Bituminous coal - Pulverized Dry bottom, wall fired",205.3,1.5E-3,3.5000000000000001E-3]
["Bituminous coal - Pulverized Dry bottom, tangential firing",205.3,1.5E-3,1E-3]
["Bituminous coal - Pulverized Wet bottom",205.3,2E-3,3.5000000000000001E-3]
["Bituminous coal Spreader stoker boiler",205.3,2E-3,3.5000000000000001E-3]
["Bituminous coal - fluidized bed Circulating or bubbling",205.3,2E-3,0.21]
["Sub-bituminous coal Overfeed stoker boiler",212.7,2E-3,3.5000000000000001E-3]
["Sub-bituminous coal Underfeed stoker boiler",212.7,3.1E-2,3.5000000000000001E-3]
["Sub-bituminous coal - fluidized bed Circulating or bubbling",212.7,2E-3,0.21]
["Lignite",215.4,0.02,3.0999999999999999E-3]
["Biofuels*"]
["Wood and wood waste",0,2.7E-2,8.9999999999999993E-3]
["Biogas used in boilers or kilns",0,6.0000000000000001E-3,0]
["Pulping Liquors: Scandinavian Softwood",0,5.4999999999999997E-3,4.4000000000000003E-3]
["Pulping Liquors: Scandinavian Hardwood",0,5.4999999999999997E-3,4.4000000000000003E-3]
["Pulping Liquors: North American Softwood",0,5.4999999999999997E-3,4.4000000000000003E-3]
["Pulping Liquors: North American Hardwood",0,5.4999999999999997E-3,4.4000000000000003E-3]
["Pulping Liquors: Tropical Mixed Woods",0,5.4999999999999997E-3,4.4000000000000003E-3]
["Pulping Liquors: Bagasse",0,5.4999999999999997E-3,4.4000000000000003E-3]
["Pulping Liquors: Bamboo",0,5.4999999999999997E-3,4.4000000000000003E-3]
["Pulping Liquors: Straw",0,5.4999999999999997E-3,4.4000000000000003E-3]
["Other fuels"]
["Tires and tire derived fuel",189.53800000000001]
["Municipal solid waste**",91.9]
[]
[]
["Default factors for pulping liquors:","lb CO2/MMBtu HHV"]
["Pulping Liquors: Scandinavian Softwood",208.27868852459017]
["Pulping Liquors: Scandinavian Hardwood",203.40517241379308]
["Pulping Liquors: North American Softwood",208.27868852459017]
["Pulping Liquors: North American Hardwood",205.7]
["Pulping Liquors: Tropical Mixed Woods",211.2]
["Pulping Liquors: Bagasse",210.94015748031498]
["Pulping Liquors: Bamboo",207]
["Pulping Liquors: Straw",210.30952380952382]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Carbon Dioxide","Methane","Nitrous Oxide"]
["Region/State","CO2 (lbs/MWh)","CH4 (lbs/MWh)","N2O (lbs/MWh)"]
["New England",980,2.07E-2,1.46E-2]
["Connecticut",940,1.7399999999999999E-2,1.2E-2]
["Maine",850,5.6500000000000002E-2,2.7E-2]
["Massachusetts",1280,1.7399999999999999E-2,1.5900000000000001E-2]
["New Hampshire",680,1.72E-2,1.41E-2]
["Rhode Island",1050,6.7999999999999996E-3,4.7000000000000002E-3]
["Vermont",30,9.5999999999999992E-3,3.8999999999999998E-3]
["Mid Atlantic",1040,9.2999999999999992E-3,1.4500000000000001E-2]
["New Jersey",710,7.7000000000000002E-3,7.9000000000000008E-3]
["New York",860,8.0999999999999996E-3,8.8999999999999999E-3]
["Pennsylvania",1260,1.0699999999999999E-2,2.0299999999999999E-2]
["East-North Central",1630,1.23E-2,2.5700000000000001E-2]
["Illinois",1160,8.2000000000000007E-3,1.7999999999999999E-2]
["Indiana",2080,1.43E-2,3.2300000000000002E-2]
["Michigan",1580,1.46E-2,2.5000000000000001E-2]
["Ohio",1800,1.2999999999999999E-2,2.8799999999999999E-2]
["Wisconsin",1640,1.38E-2,2.5999999999999999E-2]
["West-North Central",1730,1.2699999999999999E-2,2.69E-2]
["Iowa",1880,1.38E-2,2.98E-2]
["Kansas",1680,1.12E-2,2.5399999999999999E-2]
["Minnesota",1520,1.5699999999999999E-2,2.47E-2]
["Missouri",1840,1.26E-2,2.8799999999999999E-2]
["Nebraska",1400,9.4999999999999998E-3,2.1899999999999999E-2]
["North Dakota",2240,1.47E-2,3.39E-2]
["South Dakota",800,5.3E-3,1.21E-2]
["South Atlantic",1350,1.2699999999999999E-2,2.07E-2]
["Delaware",1830,1.23E-2,2.2700000000000001E-2]
["Florida",1390,1.4999999999999999E-2,1.7999999999999999E-2]
["Georgia",1370,1.29E-2,2.2599999999999999E-2]
["Maryland*",1370,1.18E-2,2.06E-2]
["North Carolina",1240,1.0500000000000001E-2,2.0299999999999999E-2]
["South Carolina",830,9.1000000000000004E-3,1.4500000000000001E-2]
["Virginia",1160,1.37E-2,1.9199999999999998E-2]
["West Virginia",1980,1.37E-2,3.1600000000000003E-2]
["East-South Central",1490,1.2800000000000001E-2,2.4E-2]
["Alabama",1310,1.37E-2,2.23E-2]
["Kentucky",2010,1.4E-2,3.2099999999999997E-2]
["Mississippi",1290,1.32E-2,1.6500000000000001E-2]
["Tennessee",1300,1.0500000000000001E-2,2.12E-2]
["West-South Central",1430,8.6999999999999994E-3,1.5299999999999999E-2]
["Arkansas",1290,1.2500000000000001E-2,2.0299999999999999E-2]
["Louisiana",1180,9.4000000000000004E-3,1.12E-2]
["Oklahoma",1720,1.0999999999999999E-2,2.23E-2]
["Texas",1460,7.7000000000000002E-3,1.46E-2]
["Mountain",1560,1.0800000000000001E-2,2.3599999999999999E-2]
["Arizona",1050,6.7999999999999996E-3,1.54E-2]
["Colorado",1930,1.2699999999999999E-2,2.8899999999999999E-2]
["Idaho",30,8.0000000000000002E-3,3.3E-3]
["Montana",1430,1.0800000000000001E-2,2.2700000000000001E-2]
["Nevada",1520,8.9999999999999993E-3,1.95E-2]
["New Mexico",2020,1.3100000000000001E-2,2.9600000000000001E-2]
["Utah",1930,1.34E-2,3.0800000000000001E-2]
["Wyoming",2150,1.47E-2,3.3799999999999997E-2]
["Pacific Contiguous",450,5.3E-3,3.7000000000000002E-3]
["California",610,6.7000000000000002E-3,3.7000000000000002E-3]
["Oregon",280,3.3E-3,3.3999999999999998E-3]
["Washington",250,3.7000000000000002E-3,4.0000000000000001E-3]
["Pacific Non-contiguous",1560,1.61E-2,1.49E-2]
["Alaska",1380,6.7999999999999996E-3,8.8999999999999999E-3]
["Hawaii",1660,2.1399999999999999E-2,1.83E-2]
["United States",1340,1.11E-2,1.9199999999999998E-2]

{"sheet":"Raw Data Log","index":16,"n_rows":210,"n_cols":14,"rows_kept":210,"cut":false,"hidden":false,"merged":[]}
["Stationary Sources",null,null,null,"CO2",null,"CH4",null,"N20"]
["Source Description","Fuel Type","Quantity Burned","Units","Emission Factor","Units","Emission Factor","Units","Emission Factor","Units"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Transportation Sources",null,null,null,null,"CO2",null,"CH4",null,"N20"]
["Source Description","Fuel Type","Fraction Direct","Quantity Burned","Units","Emission Factor","Units","Emission Factor","Units","Emission Factor","Units"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Mobile Sources Other - Fuel Based",null,null,null,null,"CO2",null,"CH4",null,"N20"]
["Source Description","Fuel Type","Fraction Direct","Quantity Burned","Units","Emission Factor","Units","Emission Factor","Units","Emission Factor","Units"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Landfills - Method 1"]
["Landfill Description","Waste Type","Fraction Direct","Quantity of Gas","Units","Efficiency of Gas Collection","Fraction of Gas Burned","Methane Content of Gas","Fraction of Uncollected Methane Oxidized in Landfill Cover "]
[]
[]
[]
[]
[]
["Landfills - Method 2"]
["Landfill Description","Waste Type","Fraction Direct","Annual Waste Deposited","Units","Ultimate Methane Potential","First Order Methane Generation Rate","Years Since Landfill opened","Years since landfill stopped accepting waste","Fraction of uncollected methane that is oxidized in landfill cover","Fraction of landfill gas that is collected","Fraction of landfill gas that is burned"]
["Blabla","Blb",1,1000,"Wet US Tons",100,0.03,1990,2020,0.1,0.5,1]
[]
[]
[]
[]
["Landfill Method 3"]
["Landfill Description","Waste Type","Fraction Direct","First Year Deposit","Last Year Deposit","Year of Interest","Year of data entry","Quantity Placed","units","ultimate methane potential","First order methane generation rate constant","Fraction of uncollected methane that oxidizes in landfill cover","Fraction of landfill gas that is collected","Fraction of landfill gas that is burned"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Anaerobic Wastewater Treatment Method 1"]
["System Description","Waste Type","Fraction Direct","Quantity of Gas Collected","Units","Efficiency of gas collection system","Fraction of Gas Burned","Methane content of gas"]
[]
[]
[]
[]
[]
["Anaerobic Wastewater Treatment Method 2"]
["System Description","Waste Type","Fraction Direct","Amount of Organic Matter sent to plant per year","units","Methane Emission factor","Amount of methane captured and burned","units"]
[]
[]
[]
[]
[]
["Make-up carbonates"]
["Amount of Sodium Carbonate Used","Units","Amount of Calcium Carbonate used","Units"]
[]
[]
["Energy Imports"]
["Source Description","Quantity Imported","Units","CO2 Emission Factor","Emission Factor Units","CH4 Emission Factor","Emission Factor Units","N2O Emission Factor","Emission Factor Units"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Energy Exports"]
["Source Description","Total Generated","Units","CO2 Emission Factor","Emission Factor Units","CH4 Emission Factor","Emission Factor Units","N2O Emission Factor","Emission Factor Units","Quantity Exported","Units","Grid Intensity"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CO2 Imports and Exports"]
["Total Fossil CO2 Imported","units","Total CO2 generated","units","Fraction of gas sent to PCC plant per year"]
[]
[]
["Biomass - Wood Fuel"]
["Source Description","Quantity Burned","units","Emission Factor","units","Amount of climate neutral biomass derived CO2 that is exported","units"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Biomass - Pulping Liquors"]
["Source Description","Quantity Burned","Unit","Emission Factor","units","Amount of climate neutral biomass derived CO2 that is exported","units"]

{"sheet":"Supporting Info. on Biomass","index":17,"n_rows":103,"n_cols":11,"rows_kept":103,"cut":false,"hidden":false,"merged":[[9,1,9,6],[58,6,58,7],[0,1,0,12],[4,1,4,6],[6,1,6,6],[8,1,8,6],[15,1,15,2],[13,1,13,2],[14,1,14,2],[43,1,43,7],[102,2,102,9],[20,6,20,7],[81,2,81,8],[42,4,42,7],[45,3,45,10],[80,3,80,8],[56,2,56,6]]}
[]
[]
[null,null,"Supporting Information on Biomass"]
[null,null,"Estimating Climate-Neutral CO2 Emissions from Biomass Combustion."]
[null,"Many pulp and paper mills generate more than half of their energy needs from climate-neutral biomass fuels recovered from the industry’s waste and process streams.  Energy-rich biomass – derived from wood chips, bark, sawdust and pulping liquors recovered from the harvesting and manufacturing processes – is the result of atmospheric carbon dioxide being sequestered by trees during growth and transformed into organic carbon substances.  When these biomass fuels are burned, the CO2 emitted during the manufacturing and combustion processes is the atmospheric carbon dioxide that was sequestered during growth of the tree; hence, there is no net contribution to the atmospheric CO2 level.  This carbon cycle is a closed-loop.  New tree growth keeps absorbing atmospheric carbon dioxide and maintains the cycle."]
[]
[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. The IPCC has stated that emissions from biomass do not add to atmospheric concentrations of carbon dioxide.  (See footnote 1) \n\nThe USDOE also accepts this convention, and recommends assigning an emission factor of 0 lb CO2/MMBtu for biomass based fuels (this zero CO2 emission factor is used in the \"Stationary Combustion\" sheet for biomass fuels)."]
[]
[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 climate-neutral biomass fuels are generated and used in the manufacture of pulp and paper.\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,"Footnote 1.\n\nIntergovernmental Panel on Climate Change (IPCC). Revised 1996 IPCC Guidelines for National Greenhouse Gas Inventories: Reporting Instructions (Volume 1). IPCC National Greenhouse Gas Inventory Program.  http://www.ipcc-nggip.iges.or.jp/public/gl/invs4.htm  (26 Nov. 2001)\n\nIntergovernmental Panel on Climate Change (IPCC). 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  (20 Nov. 2001)\n\n"]
[]
[]
[null,"EXPLANATION OF CELL COLOR SCHEME"]
[null,"User entry: Source / fuel description"]
[null,"User entry: Data and parameter values"]
[null,"Auto calculated value:"]
[]
[]
[]
[null,null,"Part I. Supporting Information on Biomass Carbon Emissions from Combustion of Wood or Bark"]
[null,null,null,null,"Step 1","Step 2","Step 3"]
[null,null,null,null,"A","B","C","D"]
[null,null,null,null,"Quantity of fuel burned","CO2 emission factor:\n[default value for \"Wood and Wood Waste\" is:  195*\nlb CO2/MMBtu HHV]","CO2 emissions in lb CO2/yr ","CO2 emissions in metric tons Carbon/yr"]
[null,null,null,null,"(Units of MMBtu HHV)","lb CO2 / MMBtu HHV","C = A * B","D = C*12/44 / 2205"]
[null,null,"Example: Bark Boiler","Bark",500000,195,{"$f":"E25*F25","v":97500000},{"$f":"G25*12/44/2205","v":12059.369202226344}]
[null,null,"Source description","Fuel type","Fuel Quant.","Em. Factor","Em. (lb CO2)","Em. (tonne carbon)"]
[null,null,null,null,null,null,{"$f":"IF(E27=\"\",\"\",E27*F27)","v":""},{"$f":"IF(ISERROR(G27*12/44/1000),\"\",G27*12/44/2205)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(E28=\"\",\"\",E28*F28)","v":""},{"$f":"IF(ISERROR(G28*12/44/1000),\"\",G28*12/44/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,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,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 climate-neutral CO2 from Combustion of Wood or Bark",null,null,null,{"$f":"SUM(H27:H41)","v":0},"Metric Tonnes Carbon /year"]
[null,"Amount of climate-neutral biomass-derived CO2 included in above number that is exported (e.g. to PCC plant) rather than being emitted - Optional information",null,null,null,null,null,null,null,"Metric Tonnes Carbon /year"]
[]
[null,null,"Note:  ","* Emission factor for \"Wood and Wood Waste\" from USDOE Instructions for Form EIA-1605 Voluntary Reporting of Greenhouse Gases For Data Through 2002, March 2003, Appendix B."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Part II. Supporting Information on Biomass Carbon Emissions from Combustion of Spent Pulping Liquors"]
[null,null,"Note that because the emission factors for spent pulping liquors are based on the carbon content of the liquors (assuming a one-percent correction for unoxidized carbon), the liquor emission factor will include any carbon exiting with smelt from a recovery furnace.  Therefore, for kraft mills, the liquor emission factors estimate biomass carbon emissions from both the recovery furnace and from the lime kiln.\n\nCompanies have the option of estimating the amounts of climate-neutral biomass-derived CO2 that is exported rather than being returned to the atmosphere.  If the exports are from a lime kiln or calciner where fossil fuels are being used, as a general approximation the exports of climate-neutral biomass-derived CO2 will be twice the exports of fossil fuel-derived CO2 (see \"CO2 Imports and Exports\" worksheet).  Where exports consist of gases from a lime kiln or calciner that is burning only biomass fuels, all of the exports are carbon-neutral biomass-derived CO2."]
[]
[null,null,null,null,"Step 1","Step 2","Step 3"]
[null,null,null,null,"A","B","C","D"]
[null,null,null,null,"Quantity of fuel burned","CO2 emission factor:\n[default values are listed in the table below;\nlb CO2/MMBtu HHV]","CO2 emissions in lb CO2/yr ","CO2 emissions in metric tonnes Carbon/yr"]
[null,null,null,null,"MMBtu HHV","lb CO2/MMBtu HHV","C = A * B","F = E*12/44 / 2205"]
[null,null,"Example: Recovery Furnace","Kraft Pulping Liquor",100000,208.3,{"$f":"E63*F63","v":20830000},{"$f":"G63*12/44/2205","v":2576.3760049474336}]
[null,null,"Source description","Fuel type","Fuel Quant.","Em. factor","Em. (kg CO2)","Em. (tonne Carbon)"]
[null,null,null,null,null,null,{"$f":"IF(E65=\"\",\"\",E65*F65)","v":""},{"$f":"IF(ISERROR(G65*12/44/1000),\"\",G65*12/44/2205)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(E66=\"\",\"\",E66*F66)","v":""},{"$f":"IF(ISERROR(G66*12/44/1000),\"\",G66*12/44/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,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,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 in Pulping Liquors Released as climate-neutral CO2 from the recovery furnace and lime kiln or calciner",null,null,null,null,null,{"$f":"SUM(H65:H79)","v":0},"Metric Tonnes Carbon /year"]
[null,null,"Amount of climate-neutral biomass-derived CO2 included in above number that is exported (e.g. to PCC plant) rather than being emitted - Optional information",null,null,null,null,null,null,null,"Metric Tonnes Carbon /year"]
[]
[]
[]
[]
[null,null,"Suggested pulping liquor default emission factors"]
[]
[null,null,"Type of Pulping Liquor","Wood Furnish","Typical Carbon Content\n[percent, dry basis]","Typical Energy Content\n[GJ HHV / metric tonne dry solids]","Calculated Energy Content\n[MMBtu HHV / short ton dry solids]","Calculated Emission Factor*\n[lb CO2 / MMBtu HHV]"]
[null,null,"Kraft black liquor*","Scandinavian Softwood",35,14.2,12.2,{"$f":"IF(F90=0,\"\",(E90/100)*0.99*(44/12)*2000/G90)","v":208.27868852459017}]
[null,null,"Kraft black liquor*","Scandinavian Hardwood",32.5,13.5,11.6,{"$f":"IF(F91=0,\"\",(E91/100)*0.99*(44/12)*2000/G91)","v":203.40517241379308}]
[null,null,"Kraft black liquor*","North American Softwood",35,14.2,12.2,208.27868852459017]
[null,null,"Kraft black liquor*","North American Hardwood",34,13.9,12,205.70000000000002]
[null,null,"Kraft black liquor*","Tropical Eucalyptus",34.799999999999997,null,{"$f":"IF(F94=0,\"\",0.95*F94)","v":""},""]
[null,null,"Kraft black liquor*","Tropical Mixed Woods",35.200000000000003,14.1,12.1,211.20000000000002]
[null,null,"Kraft black liquor*","Bagasse",36.9,14.8,12.7,210.94015748031498]
[null,null,"Kraft black liquor*","Bamboo",34.5,14.1,12.1,207]
[null,null,"Kraft black liquor*","Straw",36.5,14.7,12.6,210.30952380952382]
[null,null,"Semi-Chemical",null,null,null,null,"to be determined"]
[null,null,"Sulfite",null,null,null,null,"to be determined"]
[]
[]
[null,null,"* Kraft black liquor default emission factors are based on the carbon content of the liquors (assuming a one-percent correction for unoxidized carbon) and include any carbon exiting with smelt from a recovery furnace.  Therefore, for kraft mills, the liquor emission factors estimate biomass carbon emissions from both the recovery furnace and from the lime kiln.  Factors obtained from: Chapter 1- Chemical Recovery, by Esa Vakkilainen.  1999.  In: Papermaking Science and Technology, Book 6B:  Chemical Pulping.  Gullichsen, J., and Paulapuro, H. (eds.).  Helsinki, Finland: Fapet Oy.  Units were converted from GJ HHV/metric tonne solids to MMBtu HHV/short ton solids."]

{"sheet":"Revision Log","index":18,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[[4,0,4,11],[8,0,8,11]]}
["Revision Log"]
[]
["Revisions from Version 2.1 to Version 2.1a"]
[]
["Corrected an error in the visual basic forms that write data to the Energy Exports worksheet.  The visual basic code attempted to write entries of the optional element 'emissions intensity of the grid into which power is exported' to the wrong cell.  Data should have been written to column N, but rather was attempted to be written to column L which is electronically \"protected\" from revision.  This did not result in a calculation error (i.e., calculation results were not affected).  However, it did result in a \"run time\" error of the visual basic code, crashing the visual basic program.  The visual basic code was revised, and the formulas previously overwritten were replaced."]
[]
["Revisions from Version 2.1a to Version 2.1b"]
[]
["Waste quantities now need to be entered as wet mass rather than dry mass. Default Lo is on a wet mass basis."]