{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","References","Inputs","Summary","Scope 1 - Process","Scope 1 - Combustion","Scope 2 - Electricity","Scope 3 - Electricity upstream","Scope 3 - Fuel upstream","Scope 3 - Biosolids","Scope 3 - Chemicals"],"not_rendered":{"charts":4,"images":2,"macros":1,"external_links":0,"defined_names":67,"comments":6,"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":"Instructions","index":0,"n_rows":59,"n_cols":4,"rows_kept":59,"cut":false,"hidden":false,"merged":[[14,1,14,11],[3,1,3,11],[13,1,13,11],[17,1,17,11],[18,1,18,11]]}
[null,"Greenhouse Gas Emissions Inventory"]
[]
[null,"About: "]
[null,"The Greenhouse Gas Emissions Inventory Tool (GHG Inventory Tool) was developed as a free and accessible tool to help utilities develop a GHG Inventory that is as accurate as possible.  The Tool is based on work done by University of Toronto under contract to City of Toronto, as revised by the OWWA/WEAO Climate Change Committee GHG Inventory Task Group.  The Tool was designed for use by Ontario water & wastewater utilities, but can be adapted for use in other jurisdictions."]
[]
[null,"Versions"]
[null,"Version #","Issue Date","Description"]
[null,"01","2023-03-10","First release for Beta Testing"]
[null,"02","2023-04-17","First official release on OWWA & WEAO websites"]
[null,"03","2023-09-14","Corrections & minor updates - changes summarized in User Guide"]
[]
[null,"Disclaimer:"]
[null,"Use of the GHG Inventory Tool and its accompanying user guide shall indicate agreement with the following conditions:"]
[null,"1) Anyone who downloads or uses this model in any way shall not sell it or profit in any manner from its sale, distribution or use."]
[null,"2) Neither OWWA nor WEAO may be held liable for any losses that may be incurred directly or indirectly from use of this model.  \nThose who use this model do so at their own risk."]
[]
[null,"User Guide"]
[null,"This tool has an accompanying User Guide at owwa.ca/committees/climate-change"]
[null,"For questions or comments regarding this tool, please email ghgtool@weaocommittee.org"]
[]
[null,"Spreadsheet Tab Legend: "]
[null,"This workbook is organized as follows: "]
[]
[null,"▪","Instructions"]
[null,"▪","References"]
[null,"▪","Inputs  (Red sheet)"]
[null,null,"Inputs"]
[]
[null,"▪"," Summary  (Grey sheet)"]
[null,null,"Summary "]
[]
[null,"▪","Scope 1 emissions (Green sheet)"]
[null,null,"Scope 1- Process"]
[null,null,"Scope 1- Combustion"]
[]
[null,"▪"," Scope 2 emissions  (Teal sheet)"]
[null,null,"Scope 2 - Electricity"]
[]
[null,"▪","Scope 3 emissions  (Blue sheet)"]
[null,null,"Scope 3 - Electricity upstream"]
[null,null,"Scope 3 - Fuel upstream"]
[null,null,"Scope 3 - Biosolids"]
[null,null,"Scope 3 - Chemicals"]
[]
[null,"Definitions and Accronyms:"]
[null,"CO2 = carbon dioxide"]
[null,"N2O - nitrous oxide"]
[null,"CH4 = methane"]
[null,"CO2e = CO2 equivalents"]
[null,"Tonnes = metric tonnes"]
[null,"GWP = Global Warming Potential"]
[null,"EF = Emissions Factor"]
[null,"HHV = Higher Heating Value"]
[null,"MSW = Municipal Solid Waste"]
[null,"IPCC = Intergovermental Panel on Climate Change"]
[null,"LCA = Life Cycle Analysis"]
[null,"CTCG = Cradle to Consumer"]
[null,"CTC = Cradle to Combustion"]
[null,"TWAS = Thickened Waste Activated Sludge"]

{"sheet":"References","index":1,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"REFERENCES"]
[]
[null,"The \"Short Names\" below are used throughout the spreadsheet to trace the origin of data from literature.  Links are included on this page only, for ease of future updating.  "]
[]
[null,"Short Name","Full Name","Link"]
[null,"BEAM 2011","Biosolids Emissions Assessment Model 2011","https://ccme.ca/en/res/beam_revised_version_1.1.xls"]
[null,"BEAM 2011 User Guide","Biosolids Emissions Assessment Model 2011 User Guide","https://ccme.ca/en/res/beam_user_guide_e.pdf"]
[null,"BEAM 2022","Biosolids Emissions Assessment Model 2022","https://www.biosolidsghgs.org/"]
[null,"Canada Fuel LCA Model","Canada Fuel LCA Model","https://www.canada.ca/en/environment-climate-change/services/managing-pollution/fuel-life-cycle-assessment-model.html"]
[null,"Canada Fuel LCA Methodology","Canada Fuel LCA Model Methodology","https://publications.gc.ca/collections/collection_2020/eccc/En4-418-2020-eng.pdf"]
[null,"ICLEI Community Protocol","U.S. Community Protocol for Accounting and Reporting of Greenhouse Gas Emissions","https://icleiusa.org/us-community-protocol/"]
[null,"IPCC 2006","2006 IPCC Guidelines for National Greenhouse Gas Inventories","https://www.ipcc-nggip.iges.or.jp/public/2006gl/vol5.html"]
[null,"IPCC 2007","Changes in Atmospheric Constituents and in Radiative Forcing. In: Climate Change 2007: The Physical Science Basis. Contribution of Working Group I to the Fourth Assessment Report of the Intergovernmental Panel on Climate Change","https://archive.ipcc.ch/pdf/assessment-report/ar4/wg1/ar4-wg1-chapter2.pdf"]
[null,"IPCC 2013","\"Chapter 8: Anthropogenic and Natural Radiative Forcing\" (PDF). Climate Change 2013: The Physical Science Basis. Contribution of Working Group I to the Fifth Assessment Report of the Intergovernmental Panel on Climate Change.","https://archive.ipcc.ch/pdf/assessment-report/ar5/wg1/WG1AR5_Chapter08_FINAL.pdf"]
[null,"IPCC 2019","2019 Refinement to the 2006 IPCC Guidelines for National Greenhouse Gas Inventories","https://www.ipcc-nggip.iges.or.jp/public/2019rf/pdf/5_Volume5/19R_V5_6_Ch06_Wastewater.pdf"]
[null,"IPCC 2021","Climate Change 2021: The Physical Science Basis. Contribution of Working Group I to the Sixth Assessment Report of the Intergovernmental Panel on Climate Change, 2021","https://www.ipcc.ch/assessment-report/ar6/"]
[null,"MECP ON.20","Ontario Ministry of the Environment and Climate Change- Guideline for Greenhouse Gas Reporting 2015, Appendix 10 - ON.20 General Stationary Combustion ","http://www.downloads.ene.gov.on.ca/envision/env_reg/er/documents/2015/012-4549_d_Guideline.pdf"]
[null,"NIR 2021","Canada National Inventory Report (NIR) 1990-2019","https://publications.gc.ca/site/eng/9.506002/publication.html"]
[null,"NIR 2022","Canada National Inventory Report (NIR) 1990-2020","https://publications.gc.ca/site/eng/9.506002/publication.html"]
[null,"US EPA AP-42","US EPA AP-42: Compilation of Air Emissions Factors","https://www3.epa.gov/ttnchie1/ap42/ch13/final/c13s05.pdf"]

{"sheet":"Inputs","index":2,"n_rows":284,"n_cols":32,"rows_kept":284,"cut":false,"hidden":false,"merged":[[281,6,281,11],[282,6,282,11],[283,6,283,11],[276,6,276,11],[277,6,277,11],[278,6,278,11],[279,6,279,11],[280,6,280,11],[271,6,271,11],[272,6,272,11],[273,6,273,11],[274,6,274,11],[275,6,275,11],[266,6,266,11],[267,6,267,11],[268,6,268,11],[269,6,269,11],[270,6,270,11],[11,3,11,5],[10,3,10,5],[9,3,9,5],[264,6,264,11],[265,6,265,11],[219,1,220,1],[219,2,220,2],[215,2,216,2],[15,9,15,12],[15,4,15,7],[215,1,216,1],[80,4,80,6],[194,5,194,7]]}
[null,"Greenhouse Gas Emissions Inventory - Inputs ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DO NOT DELETE OR ALTER CELLS IN COLUMNS \"S\" AND BEYOND. THESE ARE USED AS INTERNAL CALCULATIONS FOR FORMATTING AND LISTS."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COLUMNS \"S\" AND BEYOND DO NOT NEED TO BE PRINTED FOR AND OUTPUTS."]
[null,"LEGEND"]
[null,"Utility-Specific Data"]
[null,"Value Adopted by Utility"]
[null,"Default Input, Typical Range or Value Adapted from Literature"]
[null,"Output Calculated based on Utility-Specific data"]
[]
[null,"UTILITY-SPECIFIC DATA"]
[null,"Utility Name"]
[null,"Inventory Period"]
[null,"Population Served"]
[]
[]
[null,"GENERAL UTILITY INFO",null,"Units","Input Value"]
[null,"Type of Facility/System",null,null,"WASTEWATER  TREATMENT",null,null,null,"WASTE-WATER COLLECTION","WATER SUPPLY",null,null,null,"WATER DISTRIBU-TION","SUPPOR-TING SYSTEMS","GENERIC REFERENCE","UTILITY REFERENCE"]
[null,"Name of Facility/System",null,null,"WWTP1","WWTP2","WWTP3","WWTP4","Collection","WTP1","WTP2","WTP3","WTP4","Distribution","Supp. Facilities"]
[]
[null,"WATER FACILITIES INFO",null,null,null,null,null,null,null,{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"}]
[null,null,"Annual Average Daily Flow","m3/day",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[]
[null,"WASTEWATER FACILITIES INFO",null,null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,"F in","Annual Average Plant Influent Flow","m3/day",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,"F bypass","Annual Average Secondary Treatment Bypass Flow","m3/day",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,"FEff","Annual Average Secondary Treatment Effluent Flow","m3/day",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[]
[null,"SCOPE 1 - METHANE AND NITROUS OXIDE EMISSIONS FROM DOMESTIC WASTEWATER",null,null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},"Default Input"]
[null,"C BOD in","Plant Influent BOD5 Concentration","mgBOD/L",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,"C BOD eff,prim","Secondary Influent BOD5 Concentration","mgBOD/L",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,"C BOD eff","Secondary Effluent BOD5 Concentration","mgBOD/L",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,"C BOD bypass","Secondary Bypass BOD5 Concentration","mgBOD/L",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,null,"Primary Sludge to Digestion ","m3/day",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,null,"Thickened Waste Activated Sludge (TWAS) to Digestion","m3/day",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,null,"Total Solids Concentration in Primary Sludge","%",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,null,"Total Volatile Solids Concentration in Primary Sludge","%",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,null,"Total Solids Concentration in TWAS","%",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,null,"Total Volatile Solids Concentration in TWAS","%",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,"Smass_PS","Dry Mass of Primary Sludge to Digestion","kgDrySludge/year",{"$f":"+(E32*E34*1000)*365","v":0},{"$f":"+(F32*F34*1000)*365","v":0},0,0]
[null,null,"Dry Mass of Primary Volatile Solids to Digestion","kgDrySludge/year",{"$f":"+E38*E35","v":0},{"$f":"+F38*F35","v":0},{"$f":"+G38*G35","v":0},{"$f":"+H38*H35","v":0}]
[null,"Smass_WAS","Dry Mass of Secondary Sludge to Digestion","kgDrySludge/year",{"$f":"+(E33*E36*1000)*1*365","v":0},{"$f":"+(F33*F36*1000)*1*365","v":0},0,0]
[null,null,"Dry Mass of Secondary Volatile Solids to Digestion","kgDrySludge/year",{"$f":"+E40*E37","v":0},{"$f":"+F40*F37","v":0},0,0]
[]
[null,"C N in","Average Total Nitrogen Concentration in Wastewater Influent","mgN/L",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,"C N eff_treat","Average Total Nitrogen Concentration in Secondary Treatment Effluent","mgN/L",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,"C N eff_bypass","Average Total Nitrogen Concentration in Secondary Treatment Bypass","mgN/L",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,"erem,prim","Primary Treatment BOD5 Removal %","%BODremoved",{"$f":"I46","v":0.33},{"$f":"I46","v":0.33},{"$f":"I46","v":0.33},{"$f":"I46","v":0.33},0.33,null,null,null,null,null,null,"Metcalf & Eddy, Wastewater Engineering, Treatment and Reuse, 4th Edition, 2003","Utility-data source"]
[null,"erem,sec","Secondary Treatment BOD5 Removal %","%BODremoved",{"$f":"IF(ISNUMBER(E29),(E29-E30)/E29,$I$47)","v":0.95},{"$f":"IF(ISNUMBER(F29),(F29-F30)/F29,$I$47)","v":0.95},0.95,0.95,0.95,null,null,null,null,null,null,"NIR 2021, Part 2, Table A3.6–14","Utility-data source"]
[]
[null,"SCOPE 1 - DIGESTER GAS",null,null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,"VDG","Annual Average Daily Volume of Digester Gas (Measured)","m3/day",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,"dboiler","Digester Gas Combusted in Boilers (% of annual volume)","%",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,"dcogen","Digester Gas Combusted in Cogeneration Engines (% of annual volume)","%",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,"dflare","Digester Gas Flared  (% of annual volume)","%",{"$f":"1-E51-E52","v":1},{"$f":"1-F51-F52","v":1},1,1]
[null,"CCH4","CH4 Concentration in Digester Gas","%",0.65,0.65,0.65,0.65,"60%-70%",null,null,null,null,null,null,"Metcalf & Eddy, Wastewater Engineering, Treatment and Reuse, 4th Edition, 2003 and professional judgement","Utility-data source"]
[null,"CCH4","CH4 Concentration in Digester Gas","kgCH4/L",{"$f":"(E54*$E$203)/1000","v":4.2835000000000003E-4},{"$f":"(F54*$E$203)/1000","v":4.2835000000000003E-4},{"$f":"(G54*$E$203)/1000","v":4.2835000000000003E-4},{"$f":"(H54*$E$203)/1000","v":4.2835000000000003E-4}]
[null,"p","Percent Fugitive Emissions from Digester","%",2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,"0-10%",null,null,null,null,null,null,"NIR 2021, Part 2, section A3.6.2.2.1, page 176","Utility-data source"]
[]
[null,"SCOPE 1 - SLUDGE INCINERATION",null,null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,"Amount of Dry Biosolids Incinerated","tDrySludge/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,null,"Biosolids Cake Total Solids %","%",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,null,"Amount of Wet Biosolids Incinerated","tWetSludge/year",{"$f":"IF(OR(E60=\"\",E59=\"\"),\"\",E59/E60)","v":""},{"$f":"IF(OR(F60=\"\",F59=\"\"),\"\",F59/F60)","v":""},"",""]
[]
[null,"SCOPE 1 - FUEL COMBUSTION",null,null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"},null,"Source/Reference"]
[null,"VNG","Natural Gas Annual Consumption","m3/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,"VLFO","Light Weight Fuel Oil (No. 2) Annual Consumption","L/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,"Vfacility, diesel","Diesel Volume Delivered to Facility","L/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,"Vfacility, propane","Propane Volume Delivered to Facility","L/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[]
[null,"SCOPE 1 - FLEET VEHICLE COMBUSTION EMISSIONS"]
[null,"Vfleet, diesel","Diesel Annual Consumption by Vehicle Fleet ","L/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,"Vfleet, gasoline","Gasoline Annual Consumption by Vehicle Fleet ","L/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[null,"Vfleet, biodiesel","Biodiesel Annual Consumption by Vehicle Fleet ","L/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[]
[null,"SCOPE 2 - ON-SITE ELECTRICITY CONSUMPTION AT EACH FACILITY",null,null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"}]
[null,"Velec","Annual Electricity Consumption","kWh/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source"]
[]
[null,"SCOPE 3 - BIOSOLIDS MANAGEMENT (BEAM)"]
[null,"Note:  This tool has been set up to accept inputs from the widely adopted BEAM models (BEAM 2011 or BEAM 2022) for biosolids management emissions.  Please refer to the User Guide for more detailed information and guidance.  BEAM links are in the \"References\" tab."]
[null,"Only enter BEAM data in the input area corresponding to your chosen inventory approach. For example, if you choose BEAM.2022 from the dropdown below, only enter data in the BEAM.2022 input area below. The other input area can be ignored."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BEAM 2011"]
[null,null,"Choose inventory approach for biosolids",null,"BEAM 2022",null,null,"See important notes in the user guide on maintaining GWP consistency between BEAM and this inventory tool.",null,null,null,null,null,null,null,null,null,null,null,"BEAM 2022","Copy and paste as values from the \"WWT Inputs & CO2E Totals\" tab, column H labelled \"Total\", rows 25 to 30 for each BEAM scenario corresponding to each WWTP."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do Not Include","Copy and paste as values from the \"WRRF Info & Results\" tab, rows 26 to 38 for each BEAM scenario corresponding to each WWTP."]
[null,null,"BEAM 2011",null,{"$f":"U81","v":"Copy and paste as values from the \"WWT Inputs & CO2E Totals\" tab, column H labelled \"Total\", rows 25 to 30 for each BEAM scenario corresponding to each WWTP."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T80=E81,TRUE())","v":false}]
[null,null,"Unit Process",null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,"Alkaline Stabilization","MgCO2eq/year"]
[null,null,"Composting","MgCO2eq/year"]
[null,null,"Landfill Disposal","MgCO2eq/year"]
[null,null,"Combustion","MgCO2eq/year"]
[null,null,"Land Application","MgCO2eq/year"]
[null,null,"Transportation","MgCO2eq/year"]
[]
[null,null,"BEAM 2022",null,{"$f":"U82","v":"Copy and paste as values from the \"WRRF Info & Results\" tab, rows 26 to 38 for each BEAM scenario corresponding to each WWTP."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T81=E81,TRUE())","v":true}]
[null,null,"Unit Process",null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,"Alkaline Stabilization","MgCO2eq/year"]
[null,null,"Composting","MgCO2eq/year"]
[null,null,"Composting 2","MgCO2eq/year"]
[null,null,"Landfill Disposal - Typical","MgCO2eq/year"]
[null,null,"Landfill Disposal - Worst Case","MgCO2eq/year"]
[null,null,"Landfill Disposal - Aggressive","MgCO2eq/year"]
[null,null,"Landfill Disposal - CA Regulatory","MgCO2eq/year"]
[null,null,"Combustion","MgCO2eq/year"]
[null,null,"Pyrolysis","MgCO2eq/year"]
[null,null,"Land Application","MgCO2eq/year"]
[null,null,"Land Application 2","MgCO2eq/year"]
[null,null,"Miscellaneous Emissions","MgCO2eq/year"]
[null,null,"Transportation","MgCO2eq/year"]
[]
[null,"SCOPE 3 - CHEMICAL CONSUMPTION AT EACH FACILITY"]
[null,"Mchem","Annual Mass of Chemicals Consumed ",null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"},null,"Source/Reference"]
[null,null,"Chemical 1","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,{"$f":"IF(SUM(E110:O110)>0,TRUE())","v":false},null,{"$f":"IF(E110>0,TRUE())","v":false},false,false,false,false,false,false,false,false,false,false]
[null,null,"Chemical 2","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,{"$f":"IF(SUM(E111:O111)>0,TRUE())","v":false},null,{"$f":"IF(E111>0,TRUE())","v":false},{"$f":"IF(F111>0,TRUE())","v":false},{"$f":"IF(G111>0,TRUE())","v":false},{"$f":"IF(H111>0,TRUE())","v":false},{"$f":"IF(I111>0,TRUE())","v":false},{"$f":"IF(J111>0,TRUE())","v":false},{"$f":"IF(K111>0,TRUE())","v":false},{"$f":"IF(L111>0,TRUE())","v":false},{"$f":"IF(M111>0,TRUE())","v":false},{"$f":"IF(N111>0,TRUE())","v":false},{"$f":"IF(O111>0,TRUE())","v":false}]
[null,null,"Chemical 3","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,null,false,false,false,false,false,false,false,false,false,false,false]
[null,null,"Chemical 4","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,null,false,false,false,false,false,false,false,false,false,false,false]
[null,null,"Chemical 5","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,null,false,false,false,false,false,false,false,false,false,false,false]
[null,null,"Chemical 6","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,null,false,false,false,false,false,false,false,false,false,false,false]
[null,null,"Chemical 7","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,null,false,false,false,false,false,false,false,false,false,false,false]
[null,null,"Chemical 8","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,null,false,false,false,false,false,false,false,false,false,false,false]
[null,null,"Chemical 9","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,null,false,false,false,false,false,false,false,false,false,false,false]
[null,null,"Chemical 10","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,null,false,false,false,false,false,false,false,false,false,false,false]
[null,null,"Chemical 11","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,null,false,false,false,false,false,false,false,false,false,false,false]
[null,null,"Chemical 12","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,null,false,false,false,false,false,false,false,false,false,false,false]
[null,null,"Chemical 13","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,null,false,false,false,false,false,false,false,false,false,false,false]
[null,null,"Chemical 14","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,null,false,false,false,false,false,false,false,false,false,false,false]
[null,null,"Chemical 15","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,null,false,false,false,false,false,false,false,false,false,false,false]
[null,null,"Chemical 16","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,null,false,false,false,false,false,false,false,false,false,false,false]
[null,null,"Chemical 17","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,null,false,{"$f":"IF(F126>0,TRUE())","v":false},{"$f":"IF(G126>0,TRUE())","v":false},{"$f":"IF(H126>0,TRUE())","v":false},{"$f":"IF(I126>0,TRUE())","v":false},{"$f":"IF(J126>0,TRUE())","v":false},{"$f":"IF(K126>0,TRUE())","v":false},{"$f":"IF(L126>0,TRUE())","v":false},{"$f":"IF(M126>0,TRUE())","v":false},{"$f":"IF(N126>0,TRUE())","v":false},false]
[null,null,"Chemical 18","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,null,false,false,false,false,false,false,false,false,false,false,false]
[null,null,"Chemical 19","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,null,false,false,false,false,false,false,false,false,false,false,false]
[null,null,"Chemical 20","kg/year",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,null,false,false,false,false,false,false,false,false,false,false,false]
[null,"Dtruck","Truck Distance from Supplier to Site (ROUND TRIP)",null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"},null,"Source/Reference",null,null,{"$f":"TRUE","v":true},{"$f":"TRUE","v":true}]
[null,null,{"$f":"C110","v":"Chemical 1"},"km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,{"$f":"T110","v":false},{"$f":"IF(SUM(E131:O131)>0,TRUE())","v":false}]
[null,null,"Chemical 2","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,{"$f":"T111","v":false},false]
[null,null,"Chemical 3","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 4","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 5","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 6","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 7","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 8","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 9","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 10","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 11","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 12","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 13","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 14","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 15","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 16","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 17","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 18","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 19","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 20","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,"Dtrain","Train Distance from Supplier to Site (ROUND TRIP)",null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"},null,"Source/Reference",null,null,{"$f":"TRUE","v":true},{"$f":"TRUE","v":true}]
[null,null,{"$f":"C110","v":"Chemical 1"},"km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,{"$f":"T110","v":false},{"$f":"IF(SUM(E152:O152)>0,TRUE())","v":false}]
[null,null,"Chemical 2","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,{"$f":"T111","v":false},{"$f":"IF(SUM(E153:O153)>0,TRUE())","v":false}]
[null,null,"Chemical 3","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 4","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 5","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 6","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 7","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 8","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 9","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 10","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 11","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,{"$f":"IF(SUM(E162:O162)>0,TRUE())","v":false}]
[null,null,"Chemical 12","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 13","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 14","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 15","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 16","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 17","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 18","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 19","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 20","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,"Dsea","Sea Freight Distance from Supplier to Site (ROUND TRIP)",null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"},null,"Source/Reference",null,null,{"$f":"TRUE","v":true},{"$f":"TRUE","v":true}]
[null,null,{"$f":"C110","v":"Chemical 1"},"km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,{"$f":"T110","v":false},false]
[null,null,{"$f":"C111","v":"Chemical 2"},"km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,{"$f":"T111","v":false},false]
[null,null,"Chemical 3","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 4","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 5","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 6","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 7","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 8","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 9","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 10","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 11","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 12","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 13","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 14","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 15","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 16","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 17","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 18","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 19","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[null,null,"Chemical 20","km",null,null,null,null,null,null,null,null,null,null,null,null,"Utility-data source",null,null,false,false]
[]
[null,"GENERIC DATA (NOT FACILITY-SPECIFIC)"]
[null,"SCOPE 1 - GLOBAL WARMING POTENTIALS",null,"Units","Input Value","Default Input",null,null,"Reference"]
[null,null,"Global Warming Potentials"]
[null,null,"IPCC Assessment Report (AR) GWP values to use",null,"AR6","AR4","AR5","AR6"]
[null,null,"Biogenic CH4 Global Warming Potential (100-year horizon)","CO2 equivalent",{"$f":"LOOKUP($E$197,$F$197:$H$197,F198:H198)","v":27},25,28,27,"AR4: IPCC 2007, Table 2.14, AR5: IPCC 2013, Table 8.7, AR6: IPCC 2021, Table 7.15"]
[null,null,"Fossil CH4 Global Warming Potential (100-year horizon)","CO2 equivalent",{"$f":"LOOKUP($E$197,$F$197:$H$197,F199:H199)","v":29.8},25,28,29.8,"AR4: IPCC 2007, Table 2.14, AR5: IPCC 2013, Table 8.7, AR6: IPCC 2021, Table 7.16"]
[null,null,"N2O Global Warming Potential (100-year horizon)","CO2 equivalent",{"$f":"LOOKUP($E$197,$F$197:$H$197,F200:H200)","v":273},298,265,273,"AR4: IPCC 2007, Table 2.14, AR5: IPCC 2013, Table 8.7, AR6: IPCC 2021, Table 7.17"]
[]
[null,"SCOPE 1 - METHANE EMISSIONS FROM DOMESTIC WASTEWATER",null,null,"Input Value","Default Input","Reference"]
[null,null,"Density of Methane Gas @20oC, 101 kPa","kg/m3",{"$f":"F203","v":0.65900000000000003},0.65900000000000003,"engineeringtoolbox.com, at standard conditions"]
[null,"αt prim","Primary Treatment Factor for Amount of BOD5 Removed","BODSludge/BODwastewater",{"$f":"F204","v":1},1,"NIR 2022, Part 2, Table A3.6-13"]
[null,"αt,sec","Secondary Treatment Factor for Amount of BOD5 Removed","BODSludge/BODwastewater",0.46,0.46,"NIR 2022, Part 2, Table A3.6-13"]
[null,"EF aerobic,prim","Emission Factor for Primary Treatment","kgCH4/kgBOD ",3.5999999999999999E-3,3.5999999999999999E-3,"NIR 2022, Part 2, Table A6.7-1"]
[null,"EF aerobic,sec","Emission Factor for Secondary Treatment","kgCH4/kgBOD ",3.5999999999999999E-3,3.5999999999999999E-3,"NIR 2022, Part 2, Table A6.7-1"]
[null,"EF discharge","Emission Factor for Discharge After Treatment","kgCH4/kgBOD ",6.8000000000000005E-2,6.8000000000000005E-2,"IPCC 2019, Table 6.3"]
[null,"EF anaerobic","Emission Factor for Anaerobic Digestion","kgCH4/kgDrySludge",2,2,"IPCC 2006, Vol 5, Chap 4, Table 4.1"]
[]
[null,"SCOPE 1 - NITROUS OXIDE EMISSIONS FROM DOMESTIC WASTEWATER",null,null,"Input Value","Default Input","Reference"]
[null,"EFaerobic,centrN2O","Emission Factor for Centralised, Aerobic Treatment Plant ","kgN2O-N/kgN ",{"$f":"F212","v":1.61E-2},1.61E-2,"IPCC 2019 Vol 5 Chap 6 Table 6.8A"]
[null,"EF eff_dischargeN2O","Emission Factor for Treated Effluent Discharge ","kgN2O-N/kgN ",{"$f":"F213","v":5.0000000000000001E-3},5.0000000000000001E-3,"IPCC 2019 Vol 5 Chap 6 Table 6.8A"]
[]
[null,"SCOPE 1 - DIGESTER GAS COMBUSTION EMISSIONS",null,null,"Input Value","Default Input","Reference"]
[null,"HHVBG","Dry Biogas Higher Heating Value @25ºC, 101 kPa","MJ/m3",{"$f":"F216","v":27},27,"Pauls P. Argalis and Kristine Vegere, Perspective Biomethane Potential and Its Utilization in the Transport Sector in the Current Situation of Latvia, DOI:10.3390/su13147827 (https://www.researchgate.net/publication/353242140_Perspective_Biomethane_Potential_and_Its_Utilization_in_the_Transport_Sector_in_the_Current_Situation_of_Latvia)"]
[null,null,null,"BTU/ft3",{"$f":"E216*E218","v":724.65818381099996}]
[null,null,"Conversion from MJ/m3 to BTU/scf","-",26.839191993]
[null,null,"Conversion from m3 to ft3","-",35.314667]
[null,"EFN2O","N2O Emission Factor for Digester Gas Combustion","kgN2O/MMBTU",{"$f":"F220","v":6.3000000000000003E-4},6.3000000000000003E-4,"Default combustion emissions factor: https://www.epa.gov/sites/production/files/2016-03/documents/stationaryemissions_3_2016.pdf"]
[null,null,null,"kgN2O/m3 digester gas",{"$f":"+E220/10^6*E217*E219","v":1.6122369343569461E-5}]
[null,"εCH4,bl","Combustion Efficiency for Boilers - CH4 conversion rate to CO2","%",{"$f":"F222","v":0.99980000000000002},0.99980000000000002,"Derived from ICLEI Community Protocol"]
[null,"εCH4,cogen","Cogeneration Engine Combustion Efficiency - CH4 conversion rate to CO2","%",{"$f":"F223","v":0.98499999999999999},0.98499999999999999,"Willis, J. (2017) GHG Methodologies for Sewer CH4, Methanol-Use CO2, and Biogas-Combustion CH4 and their Significance for Centralized Wastewater Treatment. Queensland."]
[null,"εCH4,fl","Flare Combustion Efficiency  - CH4 conversion rate to CO2 ","%",{"$f":"F224","v":0.98},0.98,"US EPA AP-42"]
[]
[null,"SCOPE 1 - SLUDGE INCINERATION EMISSIONS",null,null,"Input Value","Default Input","Reference"]
[null,"EFCH4","CH4 Emission Factor, Continuous Incineration of Sewage Sludge ","gCH4/tWetSludge",{"$f":"F227","v":9.6999999999999993},9.6999999999999993,"IPCC 2006, Vol 5 Chap 5 Section 5.4.2"]
[null,"EFN2O,wet","N2O Emission Factor, Continuous Incineration of Sewage Sludge ","gN2O/tWetSludge",{"$f":"F228","v":900},900,"IPCC 2006, Vol 5 Chap 5 Table 5.5"]
[]
[null,"SCOPE 1&3 - FUEL COMBUSTION",null,"Units","Input Value","Default Input","Reference"]
[null,"NATURAL GAS"]
[null,"HHVNG","Natural Gas Higher Heating Value (HHV)","GJ/m3",{"$f":"F232","v":3.7999999999999999E-2},3.7999999999999999E-2,"MECP ON.20"]
[null,"CICTCG,natural gas","Natural Gas Carbon Intensity - Cradle to consumer (CTCG)","gCO2eq/MJ",15,15,"Canada Fuel LCA Methodology, Table 1 p.119 "]
[null,"CICTC,natural gas","Natural Gas Carbon Intensity - Cradle to combustion (CTC)","gCO2eq/MJ",65,65,"Canada Fuel LCA Methodology, Table 1 p.119 "]
[null,"LIGHT WEIGHT FUEL OIL (No. 2)"]
[null,"HHVLFO","Fuel Oil Higher Heating Value (HHV)","GJ/m3",{"$f":"F236","v":38.799999999999997},38.799999999999997,"MECP ON.20, Table20-1"]
[null,"CICTCG,LFO","Fuel Oil Carbon Intensity - Cradle to Consumer (CTCG)","gCO2eq/MJ",24,24,"Canada Fuel LCA Methodology, Table 1 p.119 "]
[null,"CICTC,LFO","Fuel Oil Carbon Intensity - Cradle to Combustion (CTC)","gCO2eq/MJ",95,95,"Canada Fuel LCA Methodology, Table 1 p.119 "]
[null,"DIESEL"]
[null,"HHVdiesel","Diesel Higher Heating Value (HHV)","GJ/m3",{"$f":"F240","v":38.299999999999997},38.299999999999997,"MECP ON.20, (Page 96) Table 20-1: Default High Heat Value by Fuel Type"]
[null,"CICTCG,diesel","Diesel Carbon Intensity - Cradle to Consumer (CTCG)","gCO2eq/MJ",25,25,"Canada Fuel LCA Methodology, Table 1 p.119 "]
[null,"CICTC,diesel","Diesel Carbon Intensity - Cradle to Combustion (CTC)","gCO2eq/MJ",96,96,"Canada Fuel LCA Methodology, Table 1 p.119 "]
[null,"PROPANE"]
[null,"HHVpropane","Propane Higher Heating Value (HHV)","GJ/m3",{"$f":"F244","v":25.48},25.48,"MECP ON.20 (Page 96) Table 20-2: Default LPG High Heat Value by Fuel Type"]
[null,"CICTCG,propane","Propane Carbon Intensity - Cradle to Consumer (CTCG)","gCO2eq/MJ",16,16,"Canada Fuel LCA Methodology, Table 1 p.119 "]
[null,"CICTC,propane","Propane Carbon Intensity - Cradle to Combustion (CTC)","gCO2eq/MJ",75,75,"Canada Fuel LCA Methodology, Table 1 p.119 "]
[null,"GASOLINE"]
[null,"HHVgasoline","Unleaded Gasoline Higher Heating Value (HHV)","GJ/kL",{"$f":"F248","v":38.799999999999997},38.799999999999997,"MECP ON.20 (Page 96) Table 20-1: Default High Heat Value by Fuel Type"]
[null,"CICTCG,gasoline","Gasoline Carbon Intensity - Cradle to Consumer (CTCG)","gCO2eq/MJ",24,24,"Canada Fuel LCA Methodology, Table 1 p.119 "]
[null,"CICTC,gasoline","Gasoline Carbon Intensity - Cradle to Combustion (CTC)","gCO2eq/MJ",96,96,"Canada Fuel LCA Methodology, Table 1 p.119 "]
[null,"BIODIESEL"]
[null,"HHVbiodiesel","B10 Biodiesel Higher Heating Value (HHV)","GJ/m3",{"$f":"F252","v":32.06},32.06,"MECP ON.20 (Page 96) Table 20-1: Default High Heat Value by Fuel Type"]
[null,"CICTCG,biodiesel","Biodiesel Carbon Intensity - Cradle to Combustion (CTC)","gCO2eq/MJ",{"$f":"F253","v":31},31,"Canada Fuel LCA Methodology - biodiesel from canola seeds, p.353"]
[]
[null,"SCOPE 2 - ON-SITE ELECTRICITY CONSUMPTION EMISSIONS"]
[null,"EFelec","Ontario Electricity Generation EF","gCO2eq/kWh",{"$f":"F256","v":28},28,"NIR 2022, Part 3, Table A13-7"]
[null,null,"Ontario LCA-based Grid Intensity Factor","gCO2eq/kWh",{"$f":"F257","v":50.36},50.36,"Canada Fuel LCA Methodology"]
[]
[null,"SCOPE 3 - CHEMICAL CONSUMPTION EMISSIONS",null,"Units","Input Value","Default Input","Reference"]
[null,"EFtransport,truck","Heavy-duty Transportation EF - 16-32 metric ton","kgCO2eq/t*km",0.128,0.128,"Government of Canada’s Fuel Life Cycle Assessment Model- https://data-donnees.ec.gc.ca/data/regulatee/climateoutreach/government-of-canadas-fuel-life-cycle-assessment-model/en/?lang=en"]
[null,"EFtransport,train","Diesel Freight Train EF","kgCO2eq/t*km",1.6469999999999999E-2,1.6469999999999999E-2,"Government of Canada’s Fuel Life Cycle Assessment Model- https://data-donnees.ec.gc.ca/data/regulatee/climateoutreach/government-of-canadas-fuel-life-cycle-assessment-model/en/?lang=en"]
[null,"EFtransport,ship","Freight Ship for Bulk Goods EF","kgCO2eq/t*km",1.0789999999999999E-2,1.0789999999999999E-2,"Government of Canada’s Fuel Life Cycle Assessment Model- https://data-donnees.ec.gc.ca/data/regulatee/climateoutreach/government-of-canadas-fuel-life-cycle-assessment-model/en/?lang=en"]
[]
[null,"EFchem","Chemicals Emission Factors",null,"Input Value",null,"Source"]
[null,null,{"$f":"C131","v":"Chemical 1"},"kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T110","v":false}]
[null,null,"Chemical 2","kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T111","v":false}]
[null,null,"Chemical 3","kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Chemical 4","kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Chemical 5","kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Chemical 6","kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Chemical 7","kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Chemical 8","kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Chemical 9","kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Chemical 10","kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Chemical 11","kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Chemical 12","kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Chemical 13","kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Chemical 14","kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Chemical 15","kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Chemical 16","kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Chemical 17","kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Chemical 18","kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Chemical 19","kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Chemical 20","kgCO2eq/kg",null,null,"Utility-data source",null,null,null,null,null,null,null,null,null,null,null,null,false]

{"sheet":"Summary","index":3,"n_rows":95,"n_cols":19,"rows_kept":95,"cut":false,"hidden":false,"merged":[[45,12,45,14],[51,12,51,14],[51,8,51,11],[50,4,50,7],[42,8,42,11],[50,8,50,11],[45,4,45,7],[45,8,45,11],[16,1,17,1],[3,1,15,1],[18,1,27,1],[42,4,42,7],[51,4,51,7],[30,1,30,2]]}
[null,"Greenhouse Gas Emissions Inventory - Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DO NOT DELETE OR ALTER CELLS IN COLUMNS \"R\" AND BEYOND. THESE ARE USED AS INTERNAL CALCULATIONS FOR FORMATTING AND LISTS."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COLUMNS \"R\" AND BEYOND DO NOT NEED TO BE PRINTED FOR AND OUTPUTS."]
[null,"Detailed Breakdown Emission Source",null,"Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"}]
[null,"Scope 1","Digester Biogas Combustion ","tCO2eq/year",{"$f":"SUM(F4:I4)","v":0},{"$f":"'Scope 1 - Combustion'!G47","v":0},{"$f":"'Scope 1 - Combustion'!H47","v":0},{"$f":"'Scope 1 - Combustion'!I47","v":0},{"$f":"'Scope 1 - Combustion'!J47","v":0}]
[null,null,"Biosolids Sludge Incineration","tCO2eq/year",{"$f":"SUM(F5:I5)","v":0},{"$f":"'Scope 1 - Combustion'!G68","v":""},{"$f":"'Scope 1 - Combustion'!H68","v":""},{"$f":"'Scope 1 - Combustion'!I68","v":""},{"$f":"'Scope 1 - Combustion'!J68","v":""}]
[null,null,"Process N2O from Aerobic Treatment ","tCO2eq/year",{"$f":"SUM(F6:I6)","v":0},{"$f":"'Scope 1 - Process'!G112","v":0},{"$f":"'Scope 1 - Process'!H112","v":0},{"$f":"'Scope 1 - Process'!I112","v":0},{"$f":"'Scope 1 - Process'!J112","v":0}]
[null,null,"Process CH4 from Aerobic Treatment ","tCO2eq/year",{"$f":"SUM(F7:I7)","v":0},{"$f":"'Scope 1 - Process'!G47","v":0},{"$f":"'Scope 1 - Process'!H47","v":0},{"$f":"'Scope 1 - Process'!I47","v":0},{"$f":"'Scope 1 - Process'!J47","v":0}]
[null,null,"Fugitive N2O from Effluent discharge ","tCO2eq/year",{"$f":"SUM(F8:I8)","v":0},{"$f":"'Scope 1 - Process'!G121","v":0},{"$f":"'Scope 1 - Process'!H121","v":0},{"$f":"'Scope 1 - Process'!I121","v":0},{"$f":"'Scope 1 - Process'!J121","v":0}]
[null,null,"Fugitive CH4 from Anaerobic Digester ","tCO2eq/year",0,{"$f":"'Scope 1 - Process'!G71","v":0},{"$f":"'Scope 1 - Process'!H71","v":0},{"$f":"'Scope 1 - Process'!I71","v":0},{"$f":"'Scope 1 - Process'!J71","v":0}]
[null,null,"Fugitive CH4 from Effluent discharge ","tCO2eq/year",0,{"$f":"'Scope 1 - Process'!G56","v":0},{"$f":"'Scope 1 - Process'!H56","v":0},{"$f":"'Scope 1 - Process'!I56","v":0},{"$f":"'Scope 1 - Process'!J56","v":0}]
[null,null,"Natural Gas Combustion ","tCO2eq/year",{"$f":"SUM(F11:P11)","v":0},{"$f":"'Scope 1 - Combustion'!G79","v":0},{"$f":"'Scope 1 - Combustion'!H79","v":0},{"$f":"'Scope 1 - Combustion'!I79","v":0},{"$f":"'Scope 1 - Combustion'!J79","v":0},{"$f":"'Scope 1 - Combustion'!K79","v":0},{"$f":"'Scope 1 - Combustion'!L79","v":0},{"$f":"'Scope 1 - Combustion'!M79","v":0},{"$f":"'Scope 1 - Combustion'!N79","v":0},{"$f":"'Scope 1 - Combustion'!O79","v":0},{"$f":"'Scope 1 - Combustion'!P79","v":0},{"$f":"'Scope 1 - Combustion'!Q79","v":0}]
[null,null,"Fuel Oil Combustion ","tCO2eq/year",{"$f":"SUM(F12:P12)","v":0},{"$f":"'Scope 1 - Combustion'!G90","v":0},{"$f":"'Scope 1 - Combustion'!H90","v":0},{"$f":"'Scope 1 - Combustion'!I90","v":0},{"$f":"'Scope 1 - Combustion'!J90","v":0},{"$f":"'Scope 1 - Combustion'!K90","v":0},{"$f":"'Scope 1 - Combustion'!L90","v":0},{"$f":"'Scope 1 - Combustion'!M90","v":0},{"$f":"'Scope 1 - Combustion'!N90","v":0},{"$f":"'Scope 1 - Combustion'!O90","v":0},{"$f":"'Scope 1 - Combustion'!P90","v":0},{"$f":"'Scope 1 - Combustion'!Q90","v":0}]
[null,null,"Diesel Combustion ","tCO2eq/year",{"$f":"SUM(F13:I13)","v":0},{"$f":"'Scope 1 - Combustion'!G101","v":0},{"$f":"'Scope 1 - Combustion'!H101","v":0},{"$f":"'Scope 1 - Combustion'!I101","v":0},{"$f":"'Scope 1 - Combustion'!J101","v":0},{"$f":"'Scope 1 - Combustion'!K101","v":0},{"$f":"'Scope 1 - Combustion'!L101","v":0},{"$f":"'Scope 1 - Combustion'!M101","v":0},{"$f":"'Scope 1 - Combustion'!N101","v":0},{"$f":"'Scope 1 - Combustion'!O101","v":0},{"$f":"'Scope 1 - Combustion'!P101","v":0},{"$f":"'Scope 1 - Combustion'!Q101","v":0}]
[null,null,"Propane Combustion ","tCO2eq/year",0,{"$f":"'Scope 1 - Combustion'!G112","v":0},{"$f":"'Scope 1 - Combustion'!H112","v":0},{"$f":"'Scope 1 - Combustion'!I112","v":0},{"$f":"'Scope 1 - Combustion'!J112","v":0},{"$f":"'Scope 1 - Combustion'!K112","v":0},{"$f":"'Scope 1 - Combustion'!L112","v":0},{"$f":"'Scope 1 - Combustion'!M112","v":0},{"$f":"'Scope 1 - Combustion'!N112","v":0},{"$f":"'Scope 1 - Combustion'!O112","v":0},{"$f":"'Scope 1 - Combustion'!P112","v":0},{"$f":"'Scope 1 - Combustion'!Q112","v":0}]
[null,null,"Fuel Combustion for Vehicle Fleet ","tCO2eq/year",{"$f":"SUM(F15:P15)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Scope 1 - Combustion'!Q128","v":0}]
[null,null,"Scope 1 Total Greenhouse Gas Emissions",null,{"$f":"+SUM(E4:E15)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Scope 2","Electricity Consumed  ","tCO2eq/year",{"$f":"SUM(F17:P17)","v":0},{"$f":"'Scope 2 - Electricity'!G9","v":0},{"$f":"'Scope 2 - Electricity'!H9","v":0},{"$f":"'Scope 2 - Electricity'!I9","v":0},{"$f":"'Scope 2 - Electricity'!J9","v":0},{"$f":"'Scope 2 - Electricity'!K9","v":0},{"$f":"'Scope 2 - Electricity'!L9","v":0},{"$f":"'Scope 2 - Electricity'!M9","v":0},{"$f":"'Scope 2 - Electricity'!N9","v":0},{"$f":"'Scope 2 - Electricity'!O9","v":0},{"$f":"'Scope 2 - Electricity'!P9","v":0},{"$f":"'Scope 2 - Electricity'!Q9","v":0}]
[null,null,"Scope 2 Total Greenhouse Gas Emissions",null,{"$f":"SUM(E17:E17)","v":0},0,0,0,0,{"$f":"SUM(J17:J17)","v":0},0,0,0,0,0,0]
[null,"Scope 3","Electricity upstream ","tCO2eq/year",{"$f":"SUM(F19:P19)","v":0},{"$f":"'Scope 3 - Electricity upstream'!G11","v":0},{"$f":"'Scope 3 - Electricity upstream'!H11","v":0},{"$f":"'Scope 3 - Electricity upstream'!I11","v":0},{"$f":"'Scope 3 - Electricity upstream'!J11","v":0},{"$f":"'Scope 3 - Electricity upstream'!K11","v":0},{"$f":"'Scope 3 - Electricity upstream'!L11","v":0},{"$f":"'Scope 3 - Electricity upstream'!M11","v":0},{"$f":"'Scope 3 - Electricity upstream'!N11","v":0},{"$f":"'Scope 3 - Electricity upstream'!O11","v":0},{"$f":"'Scope 3 - Electricity upstream'!P11","v":0},{"$f":"'Scope 3 - Electricity upstream'!Q11","v":0}]
[null,null,"Natural Gas upstream ","tCO2eq/year",0,{"$f":"'Scope 3 - Fuel upstream'!G10","v":0},{"$f":"'Scope 3 - Fuel upstream'!H10","v":0},{"$f":"'Scope 3 - Fuel upstream'!I10","v":0},{"$f":"'Scope 3 - Fuel upstream'!J10","v":0},{"$f":"'Scope 3 - Fuel upstream'!K10","v":0},{"$f":"'Scope 3 - Fuel upstream'!L10","v":0},{"$f":"'Scope 3 - Fuel upstream'!M10","v":0},{"$f":"'Scope 3 - Fuel upstream'!N10","v":0},{"$f":"'Scope 3 - Fuel upstream'!O10","v":0},{"$f":"'Scope 3 - Fuel upstream'!P10","v":0},{"$f":"'Scope 3 - Fuel upstream'!Q10","v":0}]
[null,null,"Fuel Oil upstream ","tCO2eq/year",0,{"$f":"'Scope 3 - Fuel upstream'!G19","v":0},{"$f":"'Scope 3 - Fuel upstream'!H19","v":0},{"$f":"'Scope 3 - Fuel upstream'!I19","v":0},{"$f":"'Scope 3 - Fuel upstream'!J19","v":0},{"$f":"'Scope 3 - Fuel upstream'!K19","v":0},{"$f":"'Scope 3 - Fuel upstream'!L19","v":0},{"$f":"'Scope 3 - Fuel upstream'!M19","v":0},{"$f":"'Scope 3 - Fuel upstream'!N19","v":0},{"$f":"'Scope 3 - Fuel upstream'!O19","v":0},{"$f":"'Scope 3 - Fuel upstream'!P19","v":0},{"$f":"'Scope 3 - Fuel upstream'!Q19","v":0}]
[null,null,"Diesel Upstream ","tCO2eq/year",0,{"$f":"'Scope 3 - Fuel upstream'!G28","v":0},{"$f":"'Scope 3 - Fuel upstream'!H28","v":0},{"$f":"'Scope 3 - Fuel upstream'!I28","v":0},{"$f":"'Scope 3 - Fuel upstream'!J28","v":0},{"$f":"'Scope 3 - Fuel upstream'!K28","v":0},{"$f":"'Scope 3 - Fuel upstream'!L28","v":0},{"$f":"'Scope 3 - Fuel upstream'!M28","v":0},{"$f":"'Scope 3 - Fuel upstream'!N28","v":0},{"$f":"'Scope 3 - Fuel upstream'!O28","v":0},{"$f":"'Scope 3 - Fuel upstream'!P28","v":0},{"$f":"'Scope 3 - Fuel upstream'!Q28","v":0}]
[null,null,"Propane Combustion ","tCO2eq/year",0,{"$f":"'Scope 3 - Fuel upstream'!G37","v":0},{"$f":"'Scope 3 - Fuel upstream'!H37","v":0},{"$f":"'Scope 3 - Fuel upstream'!I37","v":0},{"$f":"'Scope 3 - Fuel upstream'!J37","v":0},{"$f":"'Scope 3 - Fuel upstream'!K37","v":0},{"$f":"'Scope 3 - Fuel upstream'!L37","v":0},{"$f":"'Scope 3 - Fuel upstream'!M37","v":0},{"$f":"'Scope 3 - Fuel upstream'!N37","v":0},{"$f":"'Scope 3 - Fuel upstream'!O37","v":0},{"$f":"'Scope 3 - Fuel upstream'!P37","v":0},{"$f":"'Scope 3 - Fuel upstream'!Q37","v":0}]
[null,null,"Fleet Vehicle fuel upstream ","tCO2eq/year",0,null,null,null,null,null,null,null,null,null,null,{"$f":"'Scope 3 - Fuel upstream'!Q54","v":0}]
[null,null,"Chemical production ","tCO2eq/year",0,{"$f":"'Scope 3 - Chemicals'!G72","v":0},{"$f":"'Scope 3 - Chemicals'!H72","v":0},{"$f":"'Scope 3 - Chemicals'!I72","v":0},{"$f":"'Scope 3 - Chemicals'!J72","v":0},{"$f":"'Scope 3 - Chemicals'!K72","v":0},{"$f":"'Scope 3 - Chemicals'!L72","v":0},{"$f":"'Scope 3 - Chemicals'!M72","v":0},{"$f":"'Scope 3 - Chemicals'!N72","v":0},{"$f":"'Scope 3 - Chemicals'!O72","v":0},{"$f":"'Scope 3 - Chemicals'!P72","v":0},{"$f":"'Scope 3 - Chemicals'!Q72","v":0}]
[null,null,"Chemical transportation ","tCO2eq/year",0,{"$f":"'Scope 3 - Chemicals'!G166","v":0},{"$f":"'Scope 3 - Chemicals'!H166","v":0},{"$f":"'Scope 3 - Chemicals'!I166","v":0},{"$f":"'Scope 3 - Chemicals'!J166","v":0},{"$f":"'Scope 3 - Chemicals'!K166","v":0},{"$f":"'Scope 3 - Chemicals'!L166","v":0},{"$f":"'Scope 3 - Chemicals'!M166","v":0},{"$f":"'Scope 3 - Chemicals'!N166","v":0},{"$f":"'Scope 3 - Chemicals'!O166","v":0},{"$f":"'Scope 3 - Chemicals'!P166","v":0},{"$f":"'Scope 3 - Chemicals'!Q166","v":0}]
[null,null,"Biosolids Management","tCO2eq/year",{"$f":"SUM(F27:P27)","v":0},{"$f":"'Scope 3 - Biosolids'!G22","v":0},{"$f":"'Scope 3 - Biosolids'!H22","v":0},{"$f":"'Scope 3 - Biosolids'!I22","v":0},{"$f":"'Scope 3 - Biosolids'!J22","v":0}]
[null,null,"Scope 3 Greenhouse Gas Emissions",null,{"$f":"SUM(E19:E27)","v":0},{"$f":"SUM(F19:F27)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Total Greenhouse Gas Emissions",null,"tCO2eq/year",{"$f":"SUM(E28,E18,E16)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Breakdown by Emission Source",null,"Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"}]
[null,null,"Digester Biogas Combustion","tCO2eq/year",{"$f":"SUM(F32:P32)","v":0},{"$f":"F4","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Biosolids Sludge Incineration","tCO2eq/year",0,{"$f":"F5","v":""},"","","",0,0,0,0,0,0,0]
[null,null,"Process & Fugitive N2O","tCO2eq/year",0,{"$f":"F6+F8","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Process & Fugitive CH4","tCO2eq/year",0,{"$f":"F7+F9+F10","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Fossil Fuel Combustion (Scopes 1+3)","tCO2eq/year",{"$f":"SUM(F36:P36)","v":0},{"$f":"SUM(F11:F14)+SUM(F20:F23)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Fleet Vehicles (Scopes 1+3)","tCO2eq/year",0,{"$f":"F15+F24","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Electricity (Scopes 2+3)","tCO2eq/year",0,{"$f":"F17+F19","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Chemicals production and transportation","tCO2eq/year",0,{"$f":"F25+F26","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Biosolids Management","tCO2eq/year",0,{"$f":"SUM(F27:F27)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Total Greenhouse Gas Emissions",null,"tCO2eq/year",{"$f":"SUM(E32:E40)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"SUMMARY",null,"WASTEWATER  TREATMENT",null,null,null,"WATER SUPPLY",null,null,null,"WASTEWATER COLLECTION","WATER DISTRIBUTION","SUPPORTING SYSTEMS"]
[null,null,"Name of Facility/System",null,{"$f":"WWTP1","v":"WWTP1"},{"$f":"WWTP2","v":"WWTP2"},{"$f":"WWTP3","v":"WWTP3"},{"$f":"WWTP4","v":"WWTP4"},{"$f":"WTP1_","v":"WTP1"},{"$f":"WTP2_","v":"WTP2"},{"$f":"WTP3_","v":"WTP3"},{"$f":"WTP4_","v":"WTP4"},{"$f":"WWCollection","v":"Collection"},{"$f":"WDistr","v":"Distribution"},{"$f":"SuppFac","v":"Supp. Facilities"}]
[null,null,"Annual GHG Emissions per Facility","tCO2eq/year",{"$f":"+F29","v":0},{"$f":"+G29","v":0},{"$f":"+H29","v":0},{"$f":"+I29","v":0},{"$f":"+K29","v":0},{"$f":"+L29","v":0},{"$f":"+M29","v":0},{"$f":"+N29","v":0},{"$f":"+J29","v":0},{"$f":"+O29","v":0},{"$f":"P29","v":0},null,null,{"$f":"OR(E45,F45,G45,H45,I45,J45,K45,L45,M45,N45,O45)","v":false}]
[null,null,"Annual GHG Emissions per Type of System","tCO2eq/year",{"$f":"SUM(E45:H45)","v":0},null,null,null,{"$f":"SUM(I45:L45)","v":0},null,null,null,{"$f":"SUM(M45:O45)","v":0}]
[null,null,"Share of Emissions per System","%",null,null,null,{"$f":"IF(R45=TRUE,+E46/SUM(E45:O45),0)","v":0},null,null,null,{"$f":"IF(R45=TRUE,+I46/SUM(E45:O45),0)","v":0},null,null,{"$f":"IF(R45=TRUE,+M46/SUM(E45:O45),0)","v":0}]
[null,null,"Population",null,{"$f":"Inputs!$D$12","v":0}]
[null,null,"Annual Flow","m3/year",{"$f":"+(Inputs!E23)*365","v":0},{"$f":"+(Inputs!F23)*365","v":0},{"$f":"+(Inputs!G23)*365","v":0},{"$f":"+(Inputs!H23)*365","v":0},{"$f":"+Inputs!J20*365","v":0},{"$f":"+Inputs!K20*365","v":0},{"$f":"+Inputs!L20*365","v":0},{"$f":"+Inputs!M20*365","v":0}]
[null,null,"Emission Intensity per Facility","gCO2eq/m3",{"$f":"IF(E45=0,0,(IF(E49=0,0,+E45*10^6/E49)))","v":0},0,0,{"$f":"IF(H45=0,0,(IF(H49=0,0,+H45*10^6/H49)))","v":0},{"$f":"IF(I45=0,0,(IF(I49=0,0,+I45*10^6/I49)))","v":0},0,0,0,null,null,null,null,null,{"$f":"OR(E49,F49,G49,H49,E50,F50,G50,H50)","v":false},{"$f":"OR(I49,J49,K49,L49,I50,J50,K50,L50)","v":false}]
[null,null,"Emission Intensity per System","gCO2eq/m3",{"$f":"IF(R50=TRUE,(E50*E49+F50*F49+G50*G49+H50*H49)/SUM(E49:H49),0)","v":0},null,null,null,{"$f":"IF(S50=TRUE,(I50*I49+J50*J49+K50*K49+L50*L49)/SUM(I49:L49),0)","v":0}]
[null,null,"Emission Intensity per Population Served","gCO2eq/year/person",{"$f":"IF(E48=0,0,(IF(E46=0,0,E46/E48)))","v":0},null,null,null,{"$f":"IF(E48=0,0,(IF(I46=0,0,I46/E48)))","v":0},null,null,null,{"$f":"IF(E48=0,0,(IF(M46=0,0,M46/E48)))","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Emissions per Treatment Type or Supporting Service",null,"GHG Emissions","Share of emissions",null,null,"GHG Emissions","Share of emissions"]
[null,null,null,"Wastewater Treatment",{"$f":"+SUM(F29:I29)","v":0},{"$f":"+E93/SUM(E93:E95)","v":{"$error":"#DIV/0!"}},null,"Scope 1",{"$f":"E16","v":0},{"$f":"+I93/SUM(I93:I95)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Water Supply",{"$f":"+SUM(K29:N29)","v":0},{"$f":"+E94/SUM(E93:E95)","v":{"$error":"#DIV/0!"}},null,"Scope 2",{"$f":"E18","v":0},{"$f":"+I94/SUM(I93:I95)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Collection, Distribution, and Supporting Systems",{"$f":"+SUM(J29,O29,P29)","v":0},{"$f":"+E95/SUM(E93:E95)","v":{"$error":"#DIV/0!"}},null,"Scope 3",{"$f":"E28","v":0},{"$f":"+I95/SUM(I93:I95)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Scope 1 - Process","index":4,"n_rows":124,"n_cols":14,"rows_kept":124,"cut":false,"hidden":false,"merged":[[122,3,123,3],[119,3,120,3],[110,3,111,3],[99,2,99,3],[106,2,106,3],[114,2,114,3],[110,2,111,2],[119,2,120,2],[93,2,93,3],[63,1,70,1],[69,3,70,3],[78,3,79,3],[72,2,72,3],[87,2,87,3],[78,2,79,2],[73,1,79,1],[63,2,63,3],[11,2,11,3],[17,2,17,3],[23,2,23,3],[29,2,29,3],[61,6,61,8],[45,2,46,2],[49,2,49,3],[35,2,35,3],[54,3,55,3],[54,2,55,2],[45,3,46,3]]}
[null,"Scope 1 - GHG Emissions Associated with Treatment Processes",null,null,null,null,null,null,null,null,null,null,"DO NOT DELETE OR ALTER CELLS IN COLUMNS \"M\" AND BEYOND. THESE ARE USED AS INTERNAL CALCULATIONS FOR FORMATTING AND LISTS."]
[null,null,null,null,null,null,null,null,null,null,null,null,"COLUMNS \"M\" AND BEYOND DO NOT NEED TO BE PRINTED FOR AND OUTPUTS."]
[null,"WARMING GLOBAL POTENTIAL"]
[null,null,null,"Biogenic CH4 Global Warming Potential (100-year horizon)","-",null,{"$f":"Inputs!$E$198","v":27},{"$f":"Inputs!$E$198","v":27},{"$f":"Inputs!$E$198","v":27},{"$f":"Inputs!$E$198","v":27},{"$f":"Inputs!$I$198","v":"AR4: IPCC 2007, Table 2.14, AR5: IPCC 2013, Table 8.7, AR6: IPCC 2021, Table 7.15"}]
[null,null,null,"N2O Global Warming Potential (100-year horizon)","-",null,{"$f":"Inputs!$E$200","v":273},{"$f":"Inputs!$E$200","v":273},{"$f":"Inputs!$E$200","v":273},{"$f":"Inputs!$E$200","v":273},{"$f":"Inputs!$I$200","v":"AR4: IPCC 2007, Table 2.14, AR5: IPCC 2013, Table 8.7, AR6: IPCC 2021, Table 7.17"}]
[]
[null,"METHANE EMISSIONS FROM DOMESTIC WASTEWATER"]
[null,"Methodology: The following five steps were adapted from the 2019 Refinement of the IPCC Guidelines, Volume 5, Chapters 4 and 6."]
[]
[null,"Step 1 -","Estimate the amount of organic material in kgBOD/year in the wastewater influent, and the bypass and effluent discharged to the aquatic environment"]
[null,null,"Total Plant Influent Organics"]
[null,null,"TOWin = Fin*C BOD in",null,"Unit",null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},"Reference/Source"]
[null,null,"F in","Annual Average Plant Influent Flow","m3/day",null,{"$f":"+Inputs!$E$23","v":0},{"$f":"+Inputs!$F$23","v":0},{"$f":"+Inputs!$G$23","v":0},{"$f":"+Inputs!$H$23","v":0},{"$f":"Inputs!$Q$23","v":"Utility-data source"}]
[null,null,"C BOD in","Plant Influent BOD5 Concentration","mgBOD/L",null,{"$f":"+Inputs!$E$28","v":0},{"$f":"+Inputs!$F$28","v":0},{"$f":"+Inputs!$G$28","v":0},{"$f":"+Inputs!$H$28","v":0},{"$f":"Inputs!$Q$28","v":"Utility-data source"}]
[null,null,"TOWin","Total Influent Organic Material","kgBOD/year",null,{"$f":"+G13*G14*365/1000","v":0},{"$f":"+H13*H14*365/1000","v":0},0,0]
[]
[null,null,"Total Secondary Treatment Influent Organics"]
[null,null,"TOWin = Fin,sec*C BOD eff,prim",null,null,null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,"F in,sec","Annual Average Secondary Influent Flow","m3/day",null,{"$f":"+Inputs!$E$23","v":0},{"$f":"+Inputs!$F$23","v":0},{"$f":"+Inputs!$G$23","v":0},{"$f":"+Inputs!$H$23","v":0},{"$f":"Inputs!$Q$23","v":"Utility-data source"}]
[null,null,"C BOD eff,prim","Secondary Influent BOD5 Concentration","mgBOD/L",null,{"$f":"+Inputs!$E$29","v":0},{"$f":"+Inputs!$F$29","v":0},{"$f":"+Inputs!$G$29","v":0},{"$f":"+Inputs!$H$29","v":0},{"$f":"Inputs!$Q$29","v":"Utility-data source"}]
[null,null,"TOWin,sec","Total Secondary Influent Organic Material","kgBOD/year",null,{"$f":"+G19*G20*365/1000","v":0},{"$f":"+H19*H20*365/1000","v":0},0,0]
[]
[null,null,"Total Wastewater Secondary Effluent Organics"]
[null,null,"TOWeff = Feff*C BOD eff",null,null,null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,"FEff","Annual Average Secondary Treatment Effluent Flow","m3/day",null,{"$f":"+Inputs!$E$25","v":0},{"$f":"+Inputs!$F$25","v":0},{"$f":"+Inputs!$G$25","v":0},{"$f":"+Inputs!$H$25","v":0},{"$f":"Inputs!$Q$25","v":"Utility-data source"}]
[null,null,"C BOD eff","Secondary Effluent BOD5 Concentration","mgBOD/L",null,{"$f":"+Inputs!$E$30","v":0},{"$f":"+Inputs!$F$30","v":0},{"$f":"+Inputs!$G$30","v":0},{"$f":"+Inputs!$H$30","v":0},{"$f":"Inputs!$Q$30","v":"Utility-data source"}]
[null,null,"TOWeff","Total Secondary Effluent Organic Material","kgBOD/year",null,{"$f":"+G25*G26*365/1000","v":0},{"$f":"+H25*H26*365/1000","v":0},0,0]
[]
[null,null,"Total Wastewater Bypass Organics"]
[null,null,"TOWbypass = Fbypass*C BOD bypass",null,null,null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,"F bypass","Annual Average Secondary Treatment Bypass Flow","m3/day",null,{"$f":"+Inputs!$E$24","v":0},{"$f":"+Inputs!$F$24","v":0},{"$f":"+Inputs!$G$24","v":0},{"$f":"+Inputs!$H$24","v":0},{"$f":"Inputs!$Q$24","v":"Utility-data source"}]
[null,null,"C BOD bypass","Secondary Bypass BOD5 Concentration","mgBOD/L",null,{"$f":"+Inputs!$E$31","v":0},{"$f":"+Inputs!$F$31","v":0},{"$f":"+Inputs!$G$31","v":0},{"$f":"+Inputs!$H$31","v":0},{"$f":"Inputs!$Q$31","v":"Utility-data source"}]
[null,null,"TOWbypass","Total Secondary Bypass Organic Material","kgBOD/year",null,{"$f":"+G31*G32*365/1000","v":0},{"$f":"+H31*H32*365/1000","v":0},0,0]
[]
[null,"Step 2 -","Estimate emissions from the aerobic treatment"]
[null,null,"Q CH4_aerobic =ΣtTOWt,in(1 - et,rem*αt) *EF aerobic ",null,null,null,null,null,null,null,"Canada's National Inventory Report, 2021 Edition Part 2"]
[null,null,null,null,null,"TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,"TOWprim,in","Total Influent Organic Material","kgBOD/year",null,{"$f":"+G15","v":0},{"$f":"+H15","v":0},{"$f":"+I15","v":0},{"$f":"+J15","v":0}]
[null,null,"TOWsec,in","Total Secondary Influent Organic Material","kgBOD/year",null,{"$f":"+G21","v":0},{"$f":"+H21","v":0},{"$f":"+I21","v":0},{"$f":"+J21","v":0}]
[null,null,"erem,prim","Primary Treatment BOD5 Removal %","%BODremoved",null,{"$f":"Inputs!E$46","v":0.33},{"$f":"Inputs!F$46","v":0.33},{"$f":"Inputs!G$46","v":0.33},{"$f":"Inputs!H$46","v":0.33},{"$f":"Inputs!$P$46","v":"Metcalf & Eddy, Wastewater Engineering, Treatment and Reuse, 4th Edition, 2003"}]
[null,null,"erem,sec","Secondary Treatment BOD5 Removal %","%BODremoved",null,{"$f":"Inputs!E$47","v":0.95},{"$f":"Inputs!F$47","v":0.95},{"$f":"Inputs!G$47","v":0.95},{"$f":"Inputs!H$47","v":0.95},{"$f":"Inputs!$P$46","v":"Metcalf & Eddy, Wastewater Engineering, Treatment and Reuse, 4th Edition, 2003"}]
[null,null,"αt prim","Primary Treatment Factor for Amount of BOD5 Removed","SludgeBOD/WWBOD",null,{"$f":"Inputs!$E$204","v":1},{"$f":"Inputs!$E$204","v":1},{"$f":"Inputs!$E$204","v":1},{"$f":"Inputs!$E$204","v":1},{"$f":"Inputs!$P$46","v":"Metcalf & Eddy, Wastewater Engineering, Treatment and Reuse, 4th Edition, 2003"}]
[null,null,"αt,sec","Secondary Treatment Factor for Amount of BOD5 Removed","SludgeBOD/WWBOD",null,{"$f":"Inputs!$E$205","v":0.46},{"$f":"Inputs!$E$205","v":0.46},{"$f":"Inputs!$E$205","v":0.46},{"$f":"Inputs!$E$205","v":0.46},{"$f":"Inputs!$P$46","v":"Metcalf & Eddy, Wastewater Engineering, Treatment and Reuse, 4th Edition, 2003"}]
[null,null,"EF aerobic,prim","Emission Factor for Primary Treatment","kgCH4/kgBOD ",null,{"$f":"+Inputs!$E$206","v":3.5999999999999999E-3},{"$f":"+Inputs!$E$206","v":3.5999999999999999E-3},{"$f":"+Inputs!$E$206","v":3.5999999999999999E-3},{"$f":"+Inputs!$E$206","v":3.5999999999999999E-3},{"$f":"Inputs!G206","v":"NIR 2022, Part 2, Table A6.7-1"}]
[null,null,"EF aerobic,sec","Emission Factor for Secondary Treatment","kgCH4/kgBOD ",null,{"$f":"+Inputs!$E$207","v":3.5999999999999999E-3},{"$f":"+Inputs!$E$207","v":3.5999999999999999E-3},{"$f":"+Inputs!$E$207","v":3.5999999999999999E-3},{"$f":"+Inputs!$E$207","v":3.5999999999999999E-3},{"$f":"Inputs!G207","v":"NIR 2022, Part 2, Table A6.7-1"}]
[null,null,"Q CH4_aerobic","CH4 Emissions from Aerobic Treatment","kgCH4/year",{"$f":"SUM(G46:J46)","v":0},{"$f":"+G38*(1-G40*G42)*G44+G39*(1-G41*G43)*G45","v":0},{"$f":"+H38*(1-H40*H42)*H44+H39*(1-H41*H43)*H45","v":0},0,0]
[null,null,null,null,"tCO2eq/year",{"$f":"SUM(G47:J47)","v":0},{"$f":"G46*G4/1000","v":0},{"$f":"H46*H4/1000","v":0},{"$f":"I46*I4/1000","v":0},{"$f":"J46*J4/1000","v":0}]
[]
[null,"Step 3 -","Estimate emissions from the treated effluent and bypass (untreated wastewater) discharge to the aquatic environment"]
[null,null,"Q CH4 _discharge   =(TOWeff + TOWbyp) * EF discharge",null,null,null,null,null,null,null,"2019 Refinement IPCC Guidelines, Volume 5, Chapter 6, adapted from Equation 6.1"]
[null,null,null,null,null,"TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,"TOWeff","Total Secondary Effluent Organic Material","kgBOD/year",null,{"$f":"+G27","v":0},{"$f":"+H27","v":0},{"$f":"+I27","v":0},{"$f":"+J27","v":0}]
[null,null,"TOWbypass","Total Secondary Bypass Organic Material","kgBOD/year",null,{"$f":"+G33","v":0},{"$f":"+H33","v":0},{"$f":"+I33","v":0},{"$f":"+J33","v":0}]
[null,null,"EF discharge","Emission Factor for Effluent Discharge","kgCH4/kgBOD ",null,{"$f":"+Inputs!$E$208","v":6.8000000000000005E-2},{"$f":"+Inputs!$E$208","v":6.8000000000000005E-2},{"$f":"+Inputs!$E$208","v":6.8000000000000005E-2},{"$f":"+Inputs!$E$208","v":6.8000000000000005E-2},{"$f":"Inputs!G208","v":"IPCC 2019, Table 6.3"}]
[null,null,"Q CH4_discharge","CH4 Emissions from Effluent Discharge","kgCH4/year",{"$f":"SUM(G55:J55)","v":0},{"$f":"(G53+G52)*G54","v":0},{"$f":"(H53+H52)*H54","v":0},0,0]
[null,null,null,null,"tCO2eq/year",{"$f":"SUM(G56:J56)","v":0},{"$f":"G55*G4/1000","v":0},{"$f":"H55*H4/1000","v":0},{"$f":"I55*I4/1000","v":0},{"$f":"J55*J4/1000","v":0}]
[]
[null,"Step 4 -","Estimate emissions from the anaerobic digestion of sludge"]
[null,null,"Note: Two methods are offered for calculation of this emission- one uses mass of organic waste and the other uses volume of digester gas produced & assumes 2.1% fugitive emissions as per NIR (IPCC default is 5% but range in IPCC is 0-10%). "]
[null,null," IPCC is global whereas NIR should in theory provide more accurate estimates for Canadian facilities.  Both are included, to give users a choice based on the data they have available.  "]
[]
[null,null,"Choose inventory approach for Fugitive Emissions from Anaerobic Digester",null,null,null,"Method 1 - IPCC",null,null,null,null,null,null,"Method 1 - IPCC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Method 2 - Canada's National Inventory Report"]
[null,"Method 1 - IPCC","Q CH4 fugitive = (Mslud_org x EF anaerobic) x 10-3",null,null,null,null,null,null,null,"2006 IPCC Guidelines, Volume 5, Chapter 4, adapted from Equation 4.1"]
[null,null,null,null,null,"TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,null,"Dry Mass of Primary Volatile Solids to Digestion","kgDrySludge/year",null,{"$f":"+Inputs!E39","v":0},{"$f":"+Inputs!F39","v":0},{"$f":"+Inputs!G39","v":0},{"$f":"+Inputs!H39","v":0}]
[null,null,null,"Dry Mass of Secondary Volatile Solids to Digestion","kgDrySludge/year",null,{"$f":"Inputs!E41","v":0},{"$f":"Inputs!F41","v":0},{"$f":"Inputs!G41","v":0},{"$f":"Inputs!H41","v":0}]
[null,null,"M slud_org","Dry Mass of Primary and Secondary Volatile Solids to Digestion","kgDrySludge/year",null,{"$f":"G66+G67","v":0},{"$f":"H66+H67","v":0},0,0]
[null,null,"EF anaerobic","Emission Factor for Anaerobic Digestion","kgCH4/kgWasteTreated",null,{"$f":"+Inputs!$E$209","v":2},{"$f":"+Inputs!$E$209","v":2},{"$f":"+Inputs!$E$209","v":2},{"$f":"+Inputs!$E$209","v":2},{"$f":"Inputs!$G$209","v":"IPCC 2006, Vol 5, Chap 4, Table 4.1"}]
[null,null,"Q CH4 fugitive","CH4 Fugitive Emissions from Anaerobic Digester (Method 1)","kgCH4/year",{"$f":"SUM(G70:J70)","v":0},{"$f":"+G68*G69*10^-3","v":0},{"$f":"+H68*H69*10^-3","v":0},0,0]
[null,null,null,null,"tCO2eq/year",{"$f":"SUM(G71:J71)","v":0},{"$f":"G70*G4/1000","v":0},{"$f":"H70*H4/1000","v":0},{"$f":"I70*I4/1000","v":0},{"$f":"J70*J4/1000","v":0}]
[]
[null,null,"Q CH4 fugitive  = p * Vcap / (1-p) * CCH4  ",null,null,null,null,null,null,null,"Canada's National Inventory Report, 2021"]
[null,"Method 2 - Canada's National Inventory Report",null,null,null,"TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,"p","Percent Fugitive Emissions from Digester","%",null,{"$f":"+Inputs!E$56","v":2.1000000000000001E-2},{"$f":"+Inputs!F$56","v":2.1000000000000001E-2},{"$f":"+Inputs!G$56","v":2.1000000000000001E-2},{"$f":"+Inputs!H$56","v":2.1000000000000001E-2},{"$f":"Inputs!$P$56","v":"NIR 2021, Part 2, section A3.6.2.2.1, page 176"}]
[null,null,"Vcap","Average Daily Volume of Digester Gas Measured or Captured","m3/day",null,{"$f":"+Inputs!E$50","v":0},{"$f":"+Inputs!F$50","v":0},{"$f":"+Inputs!G$50","v":0},{"$f":"+Inputs!H$50","v":0},{"$f":"Inputs!$Q$50","v":"Utility-data source"}]
[null,null,"VDG","Annual Total Volume of Digester Gas Produced (prior to fugitive loss)","m3/year",null,{"$f":"+G76/(1-G75)*365","v":0},{"$f":"+H76/(1-H75)*365","v":0},{"$f":"+I76/(1-I75)*365","v":0},{"$f":"+J76/(1-J75)*365","v":0}]
[null,null,"CCH4","CH4 Concentration in Digester Gas","kgCH4/L",null,{"$f":"+Inputs!E$55","v":4.2835000000000003E-4},{"$f":"+Inputs!F$55","v":4.2835000000000003E-4},{"$f":"+Inputs!G$55","v":4.2835000000000003E-4},{"$f":"+Inputs!H$55","v":4.2835000000000003E-4},{"$f":"Inputs!$P$54","v":"Metcalf & Eddy, Wastewater Engineering, Treatment and Reuse, 4th Edition, 2003 and professional judgement"}]
[null,null,"Q CH4 fugitive","CH4 Fugitive Emissions from Anaerobic Digester (Method 2)","kgCH4/year",{"$f":"SUM(G79:J79)","v":0},{"$f":"+(G77*1000)*G78*G75","v":0},{"$f":"+(H77*1000)*H78*H75","v":0},0,0]
[null,null,null,null,"tCO2eq/year",{"$f":"SUM(G80:J80)","v":0},{"$f":"G79*G4/1000","v":0},{"$f":"H79*H4/1000","v":0},{"$f":"I79*I4/1000","v":0},{"$f":"J79*J4/1000","v":0}]
[]
[null,null,null,"Total Methane Emissions (as methane)","kgCH4/year",{"$f":"SUM(G82:J82)","v":0},{"$f":"+G55+(IF($G$62=$K$64,G70,G79))+G46","v":0},0,0,0]
[null,null,null,"Total Methane Emissions (as CO2-e)","tCO2eq/year",{"$f":"SUM(G83:J83)","v":0},0,0,0,0,{"$f":"\"Using \"&G62&\" for emissions from anaerobic digestion.\"","v":"Using Method 1 - IPCC for emissions from anaerobic digestion."}]
[]
[null,"NITROUS OXIDE EMISSIONS FROM DOMESTIC WASTEWATER"]
[null,"Step 1 -","Estimate the total amount of nitrogen in kgN/year in the wastewater influent and the effluent discharged to the aquatic environment"]
[null,null,"Total Nitrogen in wastewater influent"]
[null,null,"TNin = Fin*C N in",null,"Unit",null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},"Reference/Source"]
[null,null,"F in","Annual Average Plant Influent Flow","m3/day",null,{"$f":"+Inputs!$E$23","v":0},{"$f":"+Inputs!$F$23","v":0},{"$f":"+Inputs!$G$23","v":0},{"$f":"+Inputs!$H$23","v":0},{"$f":"Inputs!$Q$23","v":"Utility-data source"}]
[null,null,"C N in","Average Total Nitrogen Concentration in Wastewater Influent","mgN/L",null,{"$f":"+Inputs!E$43","v":0},{"$f":"+Inputs!F$43","v":0},{"$f":"+Inputs!G$43","v":0},{"$f":"+Inputs!H$43","v":0},{"$f":"Inputs!$Q$43","v":"Utility-data source"}]
[null,null,"TNin","Total Influent Nitrogen","kgN/year",null,{"$f":"+G89*G90*365/1000","v":0},{"$f":"+H89*H90*365/1000","v":0},0,0]
[]
[null,null,"Total Nitrogen in treated wastewater effluent discharged to the aquatic environment"]
[null,null,"TNeff = Feff*C N eff",null,null,null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,"FEff","Annual Average Secondary Treatment Effluent Flow","m3/day",null,{"$f":"+Inputs!$E$25","v":0},{"$f":"+Inputs!$F$25","v":0},{"$f":"+Inputs!$G$25","v":0},{"$f":"+Inputs!$H$25","v":0},{"$f":"Inputs!$Q$25","v":"Utility-data source"}]
[null,null,"C N eff_treat","Average Total Nitrogen Concentration in Secondary Treatment Effluent","mgN/L",null,{"$f":"+Inputs!E$44","v":0},{"$f":"+Inputs!F$44","v":0},{"$f":"+Inputs!G$44","v":0},{"$f":"+Inputs!H$44","v":0},{"$f":"Inputs!$Q$44","v":"Utility-data source"}]
[null,null,"TN eff_treat","Total Secondary Treatment Nitrogen","kgN/year",null,{"$f":"+G95*G96*365/1000","v":0},{"$f":"+H95*H96*365/1000","v":0},0,0]
[]
[null,null,"Total Nitrogen in untreated wastewater effluent (or bypass) discharged to the aquatic environment"]
[null,null,"TN eff_bypass = Fbypass* CN eff_bypass",null,null,null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,"F bypass","Annual Average Secondary Treatment Bypass Flow","m3/day",null,{"$f":"+Inputs!$E$24","v":0},{"$f":"+Inputs!$F$24","v":0},{"$f":"+Inputs!$G$24","v":0},{"$f":"+Inputs!$H$24","v":0},{"$f":"Inputs!$Q$24","v":"Utility-data source"}]
[null,null,"C N eff_bypass","Average Total Nitrogen Concentration in Secondary Treatment Bypass","mgN/L",null,{"$f":"+Inputs!E$45","v":0},{"$f":"+Inputs!F$45","v":0},{"$f":"+Inputs!G$45","v":0},{"$f":"+Inputs!H$45","v":0},{"$f":"Inputs!$Q$45","v":"Utility-data source"}]
[null,null,"TN eff_bypass","Total Secondary Bypass Nitrogen","kgN/year",null,{"$f":"+G101*G102*365/1000","v":0},{"$f":"+H101*H102*365/1000","v":0},0,0]
[]
[null,"Step 2 -","Estimate emissions from the aerobic treatment "]
[null,null,"N2O Emissions From Domestic Wastewater Treatment Plants"]
[null,null,"QN2O aerobic =  TNin* EFaerobic*(kg N2O/kg N2O-N)",null,null,null,null,null,null,null,"2019 Refinement IPCC Guidelines, Volume 5, Chapter 6"]
[null,null,null,null,null,"TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,"TNin","Total Influent Nitrogen","kgN/year",null,{"$f":"+G91","v":0},{"$f":"+H91","v":0},{"$f":"+I91","v":0},{"$f":"+J91","v":0}]
[null,null,"EFaerobic ","Emission Factor for Centralised, Aerobic Treatment Plant ","kgN2O-N/kgN ",null,{"$f":"+Inputs!$E$212","v":1.61E-2},{"$f":"+Inputs!$E$212","v":1.61E-2},{"$f":"+Inputs!$E$212","v":1.61E-2},{"$f":"+Inputs!$E$212","v":1.61E-2},{"$f":"Inputs!$G$212","v":"IPCC 2019 Vol 5 Chap 6 Table 6.8A"}]
[null,null,"QN2O aerobic","N2O Emissions from Aerobic Treatment","kgN2O/year",{"$f":"SUM(G111:J111)","v":0},{"$f":"+G109*G110*44/28","v":0},{"$f":"+H109*H110*44/28","v":0},{"$f":"+I109*I110*44/28","v":0},{"$f":"+J109*J110*44/28","v":0}]
[null,null,null,null,"tCO2eq/year",{"$f":"SUM(G112:J112)","v":0},{"$f":"G111*G5/1000","v":0},{"$f":"H111*H5/1000","v":0},{"$f":"I111*I5/1000","v":0},{"$f":"J111*J5/1000","v":0}]
[]
[null,"Step 3 -","Estimate N2O emissions from the treated effluent and bypass (untreated wastewater) discharge to the aquatic environment"]
[null,null,"Q N2O_discharge= ( TNeff_treat + TNeff_bypass) * EFeff_dischargeN2O *(kg N2O/kg N2O-N)",null,null,null,null,null,null,null,"2019 Refinement IPCC Guidelines, Volume 5, Chapter 6, adapted from Equation 6.7 "]
[null,null,null,null,null,"TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,"TN eff_treat","Total Secondary Treatment Nitrogen",null,null,{"$f":"+G97","v":0},{"$f":"+H97","v":0},{"$f":"+I97","v":0},{"$f":"+J97","v":0}]
[null,null,"TN eff_bypass","Total Secondary Bypass Nitrogen","kgN/year",null,{"$f":"+G103","v":0},{"$f":"+H103","v":0},{"$f":"+I103","v":0},{"$f":"+J103","v":0}]
[null,null,"EF eff_dischargeN2O","Emission Factor for Treated Effluent Discharge","kgN2O-N/kgN ",null,{"$f":"+Inputs!$E$213","v":5.0000000000000001E-3},{"$f":"+Inputs!$E$213","v":5.0000000000000001E-3},{"$f":"+Inputs!$E$213","v":5.0000000000000001E-3},{"$f":"+Inputs!$E$213","v":5.0000000000000001E-3},{"$f":"Inputs!$G$213","v":"IPCC 2019 Vol 5 Chap 6 Table 6.8A"}]
[null,null,"Q N2O_discharge","N2O Emissions from Effluent Discharge","kgN2O/year",{"$f":"SUM(G120:J120)","v":0},{"$f":"(G117+G118)*G119*44/28","v":0},{"$f":"(H117+H118)*H119*44/28","v":0},0,0]
[null,null,null,null,"tCO2eq/year",{"$f":"SUM(G121:J121)","v":0},{"$f":"G120*G5/1000","v":0},{"$f":"H120*H5/1000","v":0},{"$f":"I120*I5/1000","v":0},{"$f":"J120*J5/1000","v":0}]
[]
[null,null,null,"Total Nitrous Oxide Emissions ","kgN2O/year",{"$f":"SUM(G123:J123)","v":0},{"$f":"G120+G111","v":0},0,0,0]
[null,null,null,null,"tCO2eq/year",{"$f":"SUM(G124:J124)","v":0},0,0,0,0]

{"sheet":"Scope 1 - Combustion","index":5,"n_rows":128,"n_cols":18,"rows_kept":128,"cut":false,"hidden":false,"merged":[[115,2,115,3],[116,5,116,7],[104,2,104,3],[71,2,71,3],[8,2,8,4],[21,2,21,4],[33,2,33,4],[93,2,93,3],[82,2,82,3],[50,2,50,3],[59,2,59,3],[120,8,120,17],[13,10,13,17],[23,10,23,17],[39,10,39,17],[118,8,118,17]]}
[null,"Scope 1 - GHG Emissions associated with Combustion"]
[]
[null,"WARMING GLOBAL POTENTIAL"]
[null,null,null,"Biogenic CH4 Global Warming Potential (100-year horizon)","-",null,{"$f":"Inputs!$E$198","v":27},{"$f":"Inputs!$E$198","v":27},{"$f":"Inputs!$E$198","v":27},{"$f":"Inputs!$E$198","v":27},{"$f":"Inputs!$I$198","v":"AR4: IPCC 2007, Table 2.14, AR5: IPCC 2013, Table 8.7, AR6: IPCC 2021, Table 7.15"}]
[null,null,null,"N2O Global Warming Potential (100-year horizon)","-",null,{"$f":"Inputs!$E$200","v":273},{"$f":"Inputs!$E$200","v":273},{"$f":"Inputs!$E$200","v":273},{"$f":"Inputs!$E$200","v":273},{"$f":"Inputs!$I$200","v":"AR4: IPCC 2007, Table 2.14, AR5: IPCC 2013, Table 8.7, AR6: IPCC 2021, Table 7.17"}]
[]
[null,"DIGESTER BIOGAS COMBUSTION EMISSIONS"]
[null,"Step 1 -","Estimate the emission from digester gas combustion in boilers",null,null,null,null,null,null,null,"Reference/Source"]
[null,null,"EDG,boiler  = ((1-εCH4 )* fCH4 * dboiler * VDG)*GWPCH4 + (EFN2O * dboiler * VDG)*GWPN2O",null,null,null,null,null,null,null,"Adapted from the Canadian Clean Fuel Standard – Fuel LCA Methodology report (Appendix D page 152) "]
[null,null,null,null,"Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,"εCH4,boiler","Combustion Efficiency for Boilers - CH4 conversion rate to CO2","%",null,{"$f":"Inputs!$E$222","v":0.99980000000000002},{"$f":"Inputs!$E$222","v":0.99980000000000002},{"$f":"Inputs!$E$222","v":0.99980000000000002},{"$f":"Inputs!$E$222","v":0.99980000000000002},{"$f":"Inputs!G222","v":"Derived from ICLEI Community Protocol"}]
[null,null,"CCH4","CH4 Concentration in Digester Gas","kgCH4/L",null,{"$f":"Inputs!E55","v":4.2835000000000003E-4},{"$f":"Inputs!F55","v":4.2835000000000003E-4},{"$f":"Inputs!G55","v":4.2835000000000003E-4},{"$f":"Inputs!H55","v":4.2835000000000003E-4},{"$f":"Inputs!$P$54","v":"Metcalf & Eddy, Wastewater Engineering, Treatment and Reuse, 4th Edition, 2003 and professional judgement"}]
[null,null,"fCH4","CH4 Fraction in Digester Gas ","g/m3",null,{"$f":"G12*1000000","v":428.35},{"$f":"H12*1000000","v":428.35},428.35,428.35]
[null,null,"EFN2O","N2O Emission Factor for Digester Gas Combustion","kgN2O/m3 digester gas",null,{"$f":"Inputs!$E$221","v":1.6122369343569461E-5},{"$f":"Inputs!$E$221","v":1.6122369343569461E-5},{"$f":"Inputs!$E$221","v":1.6122369343569461E-5},{"$f":"Inputs!$E$221","v":1.6122369343569461E-5},{"$f":"Inputs!$G$220","v":"Default combustion emissions factor: https://www.epa.gov/sites/production/files/2016-03/documents/stationaryemissions_3_2016.pdf"}]
[null,null,"dboiler","Digester Gas Combusted in Boilers %","%",null,{"$f":"Inputs!E51","v":0},{"$f":"Inputs!F51","v":0},{"$f":"Inputs!G51","v":0},{"$f":"Inputs!H51","v":0},{"$f":"Inputs!Q51","v":"Utility-data source"}]
[null,null,"VDG","Annual Average Volume of Digester Gas Produced","m3/day",null,{"$f":"Inputs!E50","v":0},{"$f":"Inputs!F50","v":0},{"$f":"Inputs!G50","v":0},{"$f":"Inputs!H50","v":0},{"$f":"Inputs!Q50","v":"Utility-data source"}]
[null,null,null,"CH4 Emissions from Digester Gas Combustion in Boilers","tCH4/year",null,{"$f":"+(1-G11)*G13/(1*10^6)*(G15*365)*G16","v":0},{"$f":"+(1-H11)*H13/(1*10^6)*(H15*365)*H16","v":0},{"$f":"+(1-I11)*I13/(1*10^6)*(I15*365)*I16","v":0},{"$f":"+(1-J11)*J13/(1*10^6)*(J15*365)*J16","v":0}]
[null,null,null,"N2O Emissions from Digester Gas Combustion in Boilers","tN2O/year",null,{"$f":"+G14*G15*(G16*365)/1000","v":0},{"$f":"+H14*H15*(H16*365)/1000","v":0},{"$f":"+I14*I15*(I16*365)/1000","v":0},{"$f":"+J14*J15*(J16*365)/1000","v":0}]
[null,null,"EDG,boiler","Digester Gas Combustion Emissions in Boiler","tCO2eq/year",{"$f":"SUM(G19:Q19)","v":0},{"$f":"+(G17*G4)+(G18*G5)","v":0},{"$f":"+(H17*H4)+(H18*H5)","v":0},{"$f":"+(I17*I4)+(I18*I5)","v":0},{"$f":"+(J17*J4)+(J18*J5)","v":0}]
[]
[null,"Step 2 -","Estimate the emission from digester gas combustion in cogeneration engines ",null,null,null,null,null,null,null,"Reference/Source"]
[null,null,"EDG,cogen  = ((1-εCH4) * fCH4 * dcogen * VDG)*GWPCH4 + (EFN2O * dcogen * VDG)*GWPN2O",null,null,null,null,null,null,null,"Adapted from the Canadian Clean Fuel Standard – Fuel LCA Methodology report (Appendix D page 152) "]
[null,null,null,null,"Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,"εCH4,cogen","Combustion efficiency for Co-Generation Engines","%",null,{"$f":"Inputs!$E$223","v":0.98499999999999999},{"$f":"Inputs!$E$223","v":0.98499999999999999},{"$f":"Inputs!$E$223","v":0.98499999999999999},{"$f":"Inputs!$E$223","v":0.98499999999999999},{"$f":"Inputs!G223","v":"Willis, J. (2017) GHG Methodologies for Sewer CH4, Methanol-Use CO2, and Biogas-Combustion CH4 and their Significance for Centralized Wastewater Treatment. Queensland."}]
[null,null,"fCH4","CH4 Fraction in Digester Gas","g/m3",null,{"$f":"G13","v":428.35},{"$f":"H13","v":428.35},{"$f":"I13","v":428.35},{"$f":"J13","v":428.35}]
[null,null,"dcogen","Digester Gas Combusted in Cogeneration Engines %","%",null,{"$f":"Inputs!E52","v":0},{"$f":"Inputs!F52","v":0},{"$f":"Inputs!G52","v":0},{"$f":"Inputs!H52","v":0},{"$f":"Inputs!Q52","v":"Utility-data source"}]
[null,null,"VDG","Annual Average Volume of Digester Gas Produced","m3/day",null,{"$f":"Inputs!E50","v":0},{"$f":"Inputs!F50","v":0},{"$f":"Inputs!G50","v":0},{"$f":"Inputs!H50","v":0}]
[null,null,"EFN2O","N2O Emission Factor for Digester Gas Combustion","kgN2O/m3 digester gas",null,{"$f":"Inputs!$E$221","v":1.6122369343569461E-5},{"$f":"Inputs!$E$221","v":1.6122369343569461E-5},{"$f":"Inputs!$E$221","v":1.6122369343569461E-5},{"$f":"Inputs!$E$221","v":1.6122369343569461E-5},{"$f":"Inputs!$G$220","v":"Default combustion emissions factor: https://www.epa.gov/sites/production/files/2016-03/documents/stationaryemissions_3_2016.pdf"}]
[null,null,null,"CH4 Emissions from Digester Gas Combustion in Co-Generation Engines","tCH4/year",null,{"$f":"+(1-G24)*G25/(1*10^6)*(G26*365)*G27","v":0},{"$f":"+(1-H24)*H25/(1*10^6)*(H26*365)*H27","v":0},0,0]
[null,null,null,"N2O Emissions from Digester Gas Combustion in Co-Generation Engines","tN2O/year",null,{"$f":"+G28*G26*(G27*365)/1000","v":0},{"$f":"+H28*H26*(H27*365)/1000","v":0},0,0]
[null,null,"EDG,cogen","Digester Gas Combustion Emissions in Co-Generation Engines","tCO2eq/year",{"$f":"SUM(G31:Q31)","v":0},{"$f":"+(G29*G4)+(G30*G5)","v":0},{"$f":"+(H29*H4)+(H30*H5)","v":0},{"$f":"+(I29*I4)+(I30*I5)","v":0},{"$f":"+(J29*J4)+(J30*J5)","v":0}]
[]
[null,"Step 3 -","Estimate the emission from digester gas combustion in flares",null,null,null,null,null,null,null,"Reference/Source"]
[null,null,"EDG,flare  = ((1-εCH4)  * fCH4 * dflare * VDG)*GWPCH4 + (EFN2O * dflare * VDG)*GWPN2O",null,null,null,null,null,null,null,"Adapted from the Canadian Clean Fuel Standard – Fuel LCA Methodology report (Appendix D page 152) "]
[null,null,null,null,"Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,"εCH4,fl","Combustion Efficiency for Flaring","%",null,{"$f":"Inputs!$E$224","v":0.98},{"$f":"Inputs!$E$224","v":0.98},{"$f":"Inputs!$E$224","v":0.98},{"$f":"Inputs!$E$224","v":0.98},{"$f":"Inputs!G224","v":"US EPA AP-42"}]
[null,null,"fCH4","CH4 Fraction in Digester Gas ","g/m3",null,{"$f":"G13","v":428.35},{"$f":"H13","v":428.35},{"$f":"I13","v":428.35},{"$f":"J13","v":428.35}]
[null,null,"dflare","Digester Gas Flared  %","%",null,{"$f":"Inputs!E53","v":1},{"$f":"Inputs!F53","v":1},{"$f":"Inputs!G53","v":1},{"$f":"Inputs!H53","v":1},{"$f":"Inputs!Q53","v":0}]
[null,null,"VDG","Annual Average Volume of Digester Gas Produced","m3/day",null,{"$f":"+Inputs!E50","v":0},{"$f":"+Inputs!F50","v":0},{"$f":"+Inputs!G50","v":0},{"$f":"+Inputs!H50","v":0}]
[null,null,"EFN2O","N2O Emission Factor for Digester Gas Combustion","kgN2O/m3 digester gas",null,{"$f":"Inputs!$E$221","v":1.6122369343569461E-5},{"$f":"Inputs!$E$221","v":1.6122369343569461E-5},{"$f":"Inputs!$E$221","v":1.6122369343569461E-5},{"$f":"Inputs!$E$221","v":1.6122369343569461E-5},{"$f":"Inputs!$G$220","v":"Default combustion emissions factor: https://www.epa.gov/sites/production/files/2016-03/documents/stationaryemissions_3_2016.pdf"}]
[null,null,null,"CH4 Emissions from Digester Gas Combustion Flared","tCH4/year",null,{"$f":"+(1-G36)*G37/(1*10^6)*(G38*365)*G39","v":0},{"$f":"+(1-H36)*H37/(1*10^6)*(H38*365)*H39","v":0},0,0]
[null,null,null,"N2O Emissions from Digester Gas Combustion Flared","tN2O/year",null,{"$f":"+G40*(G38*365)*G39/1000","v":0},{"$f":"+H40*(H38*365)*H39/1000","v":0},0,0]
[null,null,"EDG,flare","Flared Digester Gas Combustion Emissions","tCO2eq/year",{"$f":"SUM(G43:Q43)","v":0},{"$f":"(G41*G4)+(G5*G42)","v":0},{"$f":"(H41*H4)+(H5*H42)","v":0},{"$f":"(I41*I4)+(I5*I42)","v":0},{"$f":"(J41*J4)+(J5*J42)","v":0}]
[]
[null,"Step 4 - ","Estimate the emission from digester gas combustion"]
[null,null,null,null,"Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,null,"Total Digester Gas Combustion Emissions","tCO2eq/year",{"$f":"SUM(G47:Q47)","v":0},{"$f":"+G19+G31+G43","v":0},{"$f":"+H19+H31+H43","v":0},{"$f":"+I19+I31+I43","v":0},{"$f":"+J19+J31+J43","v":0}]
[]
[null,"SLUDGE INCINERATION"]
[null,"Step 1 -","Estimate the methane emissions for biosolid sludge incineration",null,null,null,null,null,null,null,"Reference/Source"]
[null,null,"QCH4,inc = EFCH4 * Wwet,sludge",null,null,null,null,null,null,null,"IPCC 2006 Volume 5, Chapter 5 "]
[null,null,null,null,"Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,"EFCH4","CH4 Emissions Factor, Continuous Incineration of MSW sludge ","gCH4/tWetSludge",null,{"$f":"Inputs!$E$227","v":9.6999999999999993},{"$f":"Inputs!$E$227","v":9.6999999999999993},{"$f":"Inputs!$E$227","v":9.6999999999999993},{"$f":"Inputs!$E$227","v":9.6999999999999993},{"$f":"Inputs!G227","v":"IPCC 2006, Vol 5 Chap 5 Section 5.4.2"}]
[null,null,null,"Amount of Dry Biosolids Incinerated","tDrySludge/year",null,{"$f":"IF(Inputs!E59=\"\",\"\",Inputs!E59)","v":""},{"$f":"IF(Inputs!F59=\"\",\"\",Inputs!F59)","v":""},{"$f":"IF(Inputs!G59=\"\",\"\",Inputs!G59)","v":""},{"$f":"IF(Inputs!H59=\"\",\"\",Inputs!H59)","v":""},{"$f":"Inputs!Q59","v":"Utility-data source"}]
[null,null,null,"Biosolids Cake Total Solids %","%",null,{"$f":"IF(Inputs!E60=\"\",\"\",Inputs!E60)","v":""},{"$f":"IF(Inputs!F60=\"\",\"\",Inputs!F60)","v":""},{"$f":"IF(Inputs!G60=\"\",\"\",Inputs!G60)","v":""},{"$f":"IF(Inputs!H60=\"\",\"\",Inputs!H60)","v":""},{"$f":"Inputs!Q60","v":"Utility-data source"}]
[null,null,"Wwet,sludge","Wet Weight of Biosolids Incinerated","tWetSludge/year",null,{"$f":"IF(OR(G55=\"\",G54=\"\"),\"\",G54/G55)","v":""},{"$f":"IF(OR(H55=\"\",H54=\"\"),\"\",H54/H55)","v":""},"",""]
[null,null,"QCH4,inc","CH4 Emissions from Sludge Incineration","tCH4/year",{"$f":"SUM(G57:P57)","v":0},{"$f":"IF(G56=\"\",\"\",G56*G53/1000000)","v":""},{"$f":"IF(H56=\"\",\"\",H56*H53/1000000)","v":""},"",""]
[]
[null,"Step 2 -","Estimate the nitrous oxide emissions for biosolid sludge incineration",null,null,null,null,null,null,null,"Reference/Source"]
[null,null,"QN2O,inc = EFN2O * Wwet, sludge",null,null,null,null,null,null,null,"IPCC 2006 Volume 5, Chapter 5 "]
[null,null,null,null,"Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,"EFN2O,wet","N2O Emission Factor, Continuous Incineration of MSW Sludge ","gN2O/tWetSludge",null,{"$f":"Inputs!$E$228","v":900},{"$f":"Inputs!$E$228","v":900},{"$f":"Inputs!$E$228","v":900},{"$f":"Inputs!$E$228","v":900},{"$f":"Inputs!G228","v":"IPCC 2006, Vol 5 Chap 5 Table 5.5"}]
[null,null,"Wwet,sludge","Wet Weight of Biosolids Incinerated","tWetSludge/year",null,{"$f":"G56","v":""},{"$f":"H56","v":""},{"$f":"I56","v":""},""]
[null,null,"QN2O,inc","N2O Emissions from Sludge Incineration","tN2O/year",{"$f":"SUM(G64:P64)","v":0},{"$f":"IF(G63=\"\",\"\",G63*G62/1000000)","v":""},{"$f":"IF(H63=\"\",\"\",H63*H62/1000000)","v":""},{"$f":"IF(I63=\"\",\"\",I63*I62/1000000)","v":""},""]
[]
[null,"Step 3 - ","Estimate the emissions for biosolid sludge incineration"]
[null,null,null,null,"Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,null,"Total Biosolids Sludge Incineration Emissions","tCO2eq/year",{"$f":"SUM(G68:Q68)","v":0},{"$f":"IF(OR(G64=\"\",G57=\"\"),\"\",(G57*G4)+(G5*G64))","v":""},{"$f":"IF(OR(H64=\"\",H57=\"\"),\"\",(H57*H4)+(H5*H64))","v":""},{"$f":"IF(OR(I64=\"\",I57=\"\"),\"\",(I57*I4)+(I5*I64))","v":""},{"$f":"IF(OR(J64=\"\",J57=\"\"),\"\",(J57*J4)+(J5*J64))","v":""}]
[]
[null,"NATURAL GAS COMBUSTION EMISSIONS"]
[null,"Step 1 -","Estimate the natural gas combustion emissions on-site",null,null,"Reference"]
[null,null,"C NG = EFc * HHV * VNG",null,null,"Guideline for Greenhouse Gas Emissions Reporting, Ministry of the Environment and Climate Change, 2015"]
[null,null,null,null,"Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"},"Reference/Source"]
[null,null,"HHVNG","Natural Gas Higher Heating Value (HHV)","GJ/m3",null,{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!G232","v":"MECP ON.20"}]
[null,null,"CICTCG,natural gas","Natural Gas Carbon Intensity - Cradle to consumer (CTCG)","gCO2eq/MJ",null,{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!G233","v":"Canada Fuel LCA Methodology, Table 1 p.119 "}]
[null,null,"CICTC,natural gas","Natural Gas Carbon Intensity - Cradle to combustion (CTC)","gCO2eq/MJ",null,{"$f":"Inputs!$E$234","v":65},{"$f":"Inputs!$E$234","v":65},{"$f":"Inputs!$E$234","v":65},{"$f":"Inputs!$E$234","v":65},{"$f":"Inputs!$E$234","v":65},{"$f":"Inputs!$E$234","v":65},{"$f":"Inputs!$E$234","v":65},{"$f":"Inputs!$E$234","v":65},{"$f":"Inputs!$E$234","v":65},{"$f":"Inputs!$E$234","v":65},{"$f":"Inputs!$E$234","v":65},{"$f":"Inputs!G234","v":"Canada Fuel LCA Methodology, Table 1 p.119 "}]
[null,null,"EFc","Natural Gas Combustion Emission Factor","gCO2eq/MJ",null,{"$f":"G76-G75","v":50},50,50,50,50,50,50,50,50,50,50]
[null,null,"VNG","Natural Gas Annual Consumption","m3/year",null,{"$f":"Inputs!E64","v":0},{"$f":"Inputs!F64","v":0},{"$f":"Inputs!G64","v":0},{"$f":"Inputs!H64","v":0},{"$f":"Inputs!I64","v":0},{"$f":"Inputs!J64","v":0},{"$f":"Inputs!K64","v":0},{"$f":"Inputs!L64","v":0},{"$f":"Inputs!M64","v":0},{"$f":"Inputs!N64","v":0},{"$f":"Inputs!O64","v":0},{"$f":"Inputs!Q64","v":"Utility-data source"}]
[null,null,"CNG","Natural Gas Combustion Emissions","tCO2eq/year",{"$f":"SUM(G79:Q79)","v":0},{"$f":"G74*G78*G77/1000","v":0},{"$f":"H74*H78*H77/1000","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"FUEL OIL -No. 2 (LFO) COMBUSTION EMISSIONS"]
[null,"Step 1 -","Estimate the fuel oil combustion emissions on-site",null,null,"Reference"]
[null,null,"C LFO = EFc * HHV * VFO",null,null,"Guideline for Greenhouse Gas Emissions Reporting, Ministry of the Environment and Climate Change, 2015"]
[null,null,null,null,"Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"},"Reference/Source"]
[null,null,"HHVLFO","Fuel Oil Higher Heating Value (HHV)","GJ/m3",null,{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!G236","v":"MECP ON.20, Table20-1"}]
[null,null,"CICTCG,LFO","Fuel Oil Carbon Intensity - Cradle to Consumer (CTCG)","gCO2eq/MJ",null,{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!G237","v":"Canada Fuel LCA Methodology, Table 1 p.119 "}]
[null,null,"CICTC,LFO","Fuel Oil Carbon Intensity - Cradle to Combustion (CTC)","gCO2eq/MJ",null,{"$f":"Inputs!$E$238","v":95},{"$f":"Inputs!$E$238","v":95},{"$f":"Inputs!$E$238","v":95},{"$f":"Inputs!$E$238","v":95},{"$f":"Inputs!$E$238","v":95},{"$f":"Inputs!$E$238","v":95},{"$f":"Inputs!$E$238","v":95},{"$f":"Inputs!$E$238","v":95},{"$f":"Inputs!$E$238","v":95},{"$f":"Inputs!$E$238","v":95},{"$f":"Inputs!$E$238","v":95},{"$f":"Inputs!G238","v":"Canada Fuel LCA Methodology, Table 1 p.119 "}]
[null,null,"EFc","Fuel Oil Combustion Emission Factor","gCO2eq/MJ",null,{"$f":"G87-G86","v":71},71,71,71,71,71,71,71,71,71,71]
[null,null,"VLFO","Light Weight Fuel Oil (No. 2) Annual Consumption","L/year",null,{"$f":"Inputs!E65","v":0},{"$f":"Inputs!F65","v":0},{"$f":"Inputs!G65","v":0},{"$f":"Inputs!H65","v":0},{"$f":"Inputs!I65","v":0},{"$f":"Inputs!J65","v":0},{"$f":"Inputs!K65","v":0},{"$f":"Inputs!L65","v":0},{"$f":"Inputs!M65","v":0},{"$f":"Inputs!N65","v":0},{"$f":"Inputs!O65","v":0},{"$f":"Inputs!Q65","v":"Utility-data source"}]
[null,null,"CLFO","Light Weight Fuel Oil Combustion Emissions","tCO2eq/year",{"$f":"SUM(G90:Q90)","v":0},{"$f":"G85*G89*G88/1000000","v":0},0,0,{"$f":"J85*J89*J88/1000000","v":0},{"$f":"K85*K89*K88/1000000","v":0},{"$f":"L85*L89*L88/1000000","v":0},{"$f":"M85*M89*M88/1000000","v":0},0,{"$f":"O85*O89*O88/1000000","v":0},{"$f":"P85*P89*P88/1000000","v":0},{"$f":"Q85*Q89*Q88/1000000","v":0}]
[]
[null,"DIESEL COMBUSTION EMISSIONS"]
[null,"Step 1 -","Estimate the diesel combustion emissions on-site",null,null,"Reference",null,null,null,null,null,null,null,null,null,null,null,"Reference/Source"]
[null,null,"C fleet = EFc * HHV * Vfacility, diesel",null,null,"Guideline for Greenhouse Gas Emissions Reporting, Ministry of the Environment and Climate Change, 2015"]
[null,null,null,null,"Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"}]
[null,null,"HHVdiesel","Diesel Higher Heating Value (HHV)","GJ/m3",null,{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!G240","v":"MECP ON.20, (Page 96) Table 20-1: Default High Heat Value by Fuel Type"}]
[null,null,"CICTCG","Diesel Carbon Intensity - Cradle to Consumer (CTCG)","gCO2eq/MJ",null,{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!G241","v":"Canada Fuel LCA Methodology, Table 1 p.119 "}]
[null,null,"CICTC","Diesel Carbon Intensity - Cradle to Combustion (CTC)","gCO2eq/MJ",null,{"$f":"Inputs!$E$242","v":96},{"$f":"Inputs!$E$242","v":96},{"$f":"Inputs!$E$242","v":96},{"$f":"Inputs!$E$242","v":96},{"$f":"Inputs!$E$242","v":96},{"$f":"Inputs!$E$242","v":96},{"$f":"Inputs!$E$242","v":96},{"$f":"Inputs!$E$242","v":96},{"$f":"Inputs!$E$242","v":96},{"$f":"Inputs!$E$242","v":96},{"$f":"Inputs!$E$242","v":96},{"$f":"Inputs!G242","v":"Canada Fuel LCA Methodology, Table 1 p.119 "}]
[null,null,"EFc","Diesel Combustion Emission Factor ","gCO2eq/MJ",null,{"$f":"G98-G97","v":71},{"$f":"H98-H97","v":71},71,71,71,71,71,71,71,71,71]
[null,null,"Vfacility, diesel","Diesel Volume Delivered to Facility","L/year",null,{"$f":"Inputs!E66","v":0},{"$f":"Inputs!F66","v":0},{"$f":"Inputs!G66","v":0},{"$f":"Inputs!H66","v":0},{"$f":"Inputs!I66","v":0},{"$f":"Inputs!J66","v":0},{"$f":"Inputs!K66","v":0},{"$f":"Inputs!L66","v":0},{"$f":"Inputs!M66","v":0},{"$f":"Inputs!N66","v":0},{"$f":"Inputs!O66","v":0},{"$f":"Inputs!Q66","v":"Utility-data source"}]
[null,null,"Cdiesel","Diesel Combustion Emissions","tCO2eq/year",{"$f":"SUM(G101:Q101)","v":0},{"$f":"G96*G100*G99/1000000","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"PROPANE COMBUSTION EMISSIONS"]
[null,"Step 1 -","Estimate the propane combustion emissions on-site",null,null,"Reference"]
[null,null,"C fleet = EFc * HHV * Vfacility, propane",null,null,"Guideline for Greenhouse Gas Emissions Reporting, Ministry of the Environment and Climate Change, 2015"]
[null,null,null,null,"Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"},"Reference/Source"]
[null,null,"HHVpropane","Propane Higher Heating Value (HHV)","GJ/m3",null,{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!G244","v":"MECP ON.20 (Page 96) Table 20-2: Default LPG High Heat Value by Fuel Type"}]
[null,null,"CICTCG","Propane Carbon Intensity - Cradle to Consumer (CTCG)","gCO2eq/MJ",null,{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!G245","v":"Canada Fuel LCA Methodology, Table 1 p.119 "}]
[null,null,"CICTC","Propane Carbon Intensity - Cradle to Combustion (CTC)","gCO2eq/MJ",null,{"$f":"Inputs!$E$246","v":75},{"$f":"Inputs!$E$246","v":75},{"$f":"Inputs!$E$246","v":75},{"$f":"Inputs!$E$246","v":75},{"$f":"Inputs!$E$246","v":75},{"$f":"Inputs!$E$246","v":75},{"$f":"Inputs!$E$246","v":75},{"$f":"Inputs!$E$246","v":75},{"$f":"Inputs!$E$246","v":75},{"$f":"Inputs!$E$246","v":75},{"$f":"Inputs!$E$246","v":75},{"$f":"Inputs!G246","v":"Canada Fuel LCA Methodology, Table 1 p.119 "}]
[null,null,"EFc","Propane Combustion Emission Factor ","gCO2eq/MJ",null,{"$f":"G109-G108","v":59},{"$f":"H109-H108","v":59},59,59,59,59,59,59,59,59,59]
[null,null,"Vfacility, propane","Propane Volume Delivered to Facility","L/year",null,{"$f":"Inputs!E67","v":0},{"$f":"Inputs!F67","v":0},{"$f":"Inputs!G67","v":0},{"$f":"Inputs!H67","v":0},{"$f":"Inputs!I67","v":0},{"$f":"Inputs!J67","v":0},{"$f":"Inputs!K67","v":0},{"$f":"Inputs!L67","v":0},{"$f":"Inputs!M67","v":0},{"$f":"Inputs!N67","v":0},{"$f":"Inputs!O67","v":0},{"$f":"Inputs!Q67","v":"Utility-data source"}]
[null,null,"Cpropane","Propane Combustion Emissions","tCO2eq/year",{"$f":"SUM(G112:Q112)","v":0},{"$f":"G107*G111*G110/1000000","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"FLEET VEHICLE COMBUSTION EMISSIONS"]
[null,"Step 1 -","Estimate the fuel combustion emissions for fleet vehicles",null,null,null,null,null,"Reference/Source"]
[null,null,"C fleet = EFc * HHV * Vfleet",null,null,null,null,null,"Guideline for Greenhouse Gas Emissions Reporting, Ministry of the Environment and Climate Change, 2015"]
[null,null,null,null,"Unit","Input Value"]
[null,null,null,null,null,"DIESEL","GASOLINE","BIODIESEL"]
[null,null,"HHV","Fuel Higher Heating Value","GJ/m3",{"$f":"Inputs!E240","v":38.299999999999997},{"$f":"Inputs!E248","v":38.799999999999997},{"$f":"Inputs!E252","v":32.06},{"$f":"CONCATENATE(Inputs!G240,\"; \",Inputs!G248,\"; \",Inputs!G252)","v":"MECP ON.20, (Page 96) Table 20-1: Default High Heat Value by Fuel Type; MECP ON.20 (Page 96) Table 20-1: Default High Heat Value by Fuel Type; MECP ON.20 (Page 96) Table 20-1: Default High Heat Value by Fuel Type"}]
[null,null,"CICTCG","Fuel Carbon Intensity - Cradle to Consumer (CTCG)","gCO2eq/MJ",{"$f":"Inputs!E241","v":25},{"$f":"Inputs!E249","v":24},null,{"$f":"CONCATENATE(Inputs!G241,\"; \",Inputs!G249)","v":"Canada Fuel LCA Methodology, Table 1 p.119 ; Canada Fuel LCA Methodology, Table 1 p.119 "}]
[null,null,"CICTC","Fuel Carbon Intensity - Cradle to Combustion (CTC)","gCO2eq/MJ",{"$f":"Inputs!E242","v":96},{"$f":"Inputs!E250","v":96},{"$f":"Inputs!E253","v":31},{"$f":"CONCATENATE(Inputs!G242,\"; \",Inputs!G250,\"; \",Inputs!G253)","v":"Canada Fuel LCA Methodology, Table 1 p.119 ; Canada Fuel LCA Methodology, Table 1 p.119 ; Canada Fuel LCA Methodology - biodiesel from canola seeds, p.353"}]
[null,null,"EFc","Fuel Combustion Emission Factor","gCO2eq/MJ",{"$f":"F121-F120","v":71},{"$f":"G121-G120","v":72},{"$f":"H121-H120","v":31}]
[]
[null,null,null,"Annual Volume Fleet Fuel Consumed","Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"},"Reference/Source"]
[null,null,"Vfleet, diesel","Diesel Annual Consumption by Vehicle Fleet ","L/year",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!O70","v":0},{"$f":"Inputs!Q70","v":"Utility-data source"}]
[null,null,"Vfleet, gasoline","Gasoline Annual Consumption by Vehicle Fleet ","L/year",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!O71","v":0},{"$f":"Inputs!Q71","v":"Utility-data source"}]
[null,null,"Vfleet, biodiesel","Biodiesel Annual Consumption by Vehicle Fleet ","L/year",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!O72","v":0},{"$f":"Inputs!Q72","v":"Utility-data source"}]
[null,null,"Cfleet","Fleet Fuel Combustion Emissions","tCO2eq/year",{"$f":"SUM(G128:Q128)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"((Q125)/1000000*$F$119*$F$122)+(Q126/1000000*$G$119*$G$122)+(Q127/1000000*$H$119*$H$122)","v":0}]

{"sheet":"Scope 2 - Electricity","index":6,"n_rows":9,"n_cols":18,"rows_kept":9,"cut":false,"hidden":false,"merged":[[4,2,4,3]]}
[null,"Scope 2 - GHG Emissions associate with Electricity Consumption"]
[]
[null,"ELECTRICITY COMSUMPTION EMISSIONS"]
[null,"Step 1 -","Estimate the emissions associated with electricity consumption on-site"]
[null,null,"Eelec = EFelec * Velec"]
[null,null,null,null,"Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"},"Reference/Source"]
[null,null,"EFelec","Ontario Electricity Generation EF","gCO2eq/kWh",null,{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!G256","v":"NIR 2022, Part 3, Table A13-7"}]
[null,null,"Velec","Annual Electricity Consumption","kWh/year",null,{"$f":"Inputs!E75","v":0},{"$f":"Inputs!F75","v":0},{"$f":"Inputs!G75","v":0},{"$f":"Inputs!H75","v":0},{"$f":"Inputs!I75","v":0},{"$f":"Inputs!J75","v":0},{"$f":"Inputs!K75","v":0},{"$f":"Inputs!L75","v":0},{"$f":"Inputs!M75","v":0},{"$f":"Inputs!N75","v":0},{"$f":"Inputs!O75","v":0},{"$f":"Inputs!Q75","v":"Utility-data source"}]
[null,null,"Eelec","Electricity Consumption Emissions","tCO2eq/year",{"$f":"SUM(G9:Q9)","v":0},{"$f":"G8*G7/1000000","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"Scope 3 - Electricity upstream","index":7,"n_rows":11,"n_cols":18,"rows_kept":11,"cut":false,"hidden":false,"merged":[[4,2,4,3]]}
[null,"Scope 3 - GHG Upstream Emissions associated with Electricity"]
[]
[null,"ELECTRICITY UPSTREAM EMISSIONS-Using the Fuel LCA Model electricity patch - National Inventory "]
[null,"Step 1 -","Estimate the emissions associated with upstream electricity "]
[null,null,"Eup-elec = EFup-elec * Velec"]
[null,null,null,null,"Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"},"Reference/Source"]
[null,null,"EFelec","Ontario Electricity Generation EF","gCO2eq/kWh",null,{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!$E$256","v":28},{"$f":"Inputs!G256","v":"NIR 2022, Part 3, Table A13-7"}]
[null,null,null,"Ontario LCA-based Grid Intensity Factor","gCO2eq/kWh",null,{"$f":"Inputs!$E$257","v":50.36},{"$f":"Inputs!$E$257","v":50.36},{"$f":"Inputs!$E$257","v":50.36},{"$f":"Inputs!$E$257","v":50.36},{"$f":"Inputs!$E$257","v":50.36},{"$f":"Inputs!$E$257","v":50.36},{"$f":"Inputs!$E$257","v":50.36},{"$f":"Inputs!$E$257","v":50.36},{"$f":"Inputs!$E$257","v":50.36},{"$f":"Inputs!$E$257","v":50.36},{"$f":"Inputs!$E$257","v":50.36},{"$f":"Inputs!G257","v":"Canada Fuel LCA Methodology"}]
[null,null,"EFup-elec","Ontario Upstream Electricity Emission Factor ","gCO2eq/kWh",null,{"$f":"G8-G7","v":22.36},22.36,22.36,22.36,22.36,22.36,22.36,22.36,22.36,22.36,22.36]
[null,null,"Velec","Annual Electricity Consumption","kWh/year",null,{"$f":"Inputs!E75","v":0},{"$f":"Inputs!F75","v":0},{"$f":"Inputs!G75","v":0},{"$f":"Inputs!H75","v":0},{"$f":"Inputs!I75","v":0},{"$f":"Inputs!J75","v":0},{"$f":"Inputs!K75","v":0},{"$f":"Inputs!L75","v":0},{"$f":"Inputs!M75","v":0},{"$f":"Inputs!N75","v":0},{"$f":"Inputs!O75","v":0},{"$f":"Inputs!Q75","v":"Utility-data source"}]
[null,null,"Eup-elec","Upstream Emissions from Electricity Consumption","tCO2eq/year",{"$f":"SUM(G11:Q11)","v":0},{"$f":"G10*G9/1000000","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"Scope 3 - Fuel upstream","index":8,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[[4,2,4,3],[13,2,13,3],[31,2,31,3],[46,8,46,17],[47,8,47,17],[43,2,43,3],[44,5,44,7],[22,2,22,3]]}
[null,"Scope 3 - GHG Upstream Emissions associated with Fuel"]
[]
[null,"NATURAL GAS UPSTREAM EMISSIONS"]
[null,"Step 1 -","Estimate the natural gas upstream emissions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference/Source"]
[null,null,"U NG = EFu * HHV * VNG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adapted from MECP ON.20"]
[null,null,null,null,"Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"}]
[null,null,"HHVNG","Natural Gas Higher Heating Value (HHV)","GJ/m3",null,{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!$E$232","v":3.7999999999999999E-2},{"$f":"Inputs!G232","v":"MECP ON.20"}]
[null,null,"EFu","Natural Gas Carbon Intensity - Cradle to consumer (CTCG)","gCO2eq/MJ",null,{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!$E$233","v":15},{"$f":"Inputs!G233","v":"Canada Fuel LCA Methodology, Table 1 p.119 "}]
[null,null,"VNG","Natural Gas Annual Consumption","m3/year",null,{"$f":"Inputs!E64","v":0},{"$f":"Inputs!F64","v":0},{"$f":"Inputs!G64","v":0},{"$f":"Inputs!H64","v":0},{"$f":"Inputs!I64","v":0},{"$f":"Inputs!J64","v":0},{"$f":"Inputs!K64","v":0},{"$f":"Inputs!L64","v":0},{"$f":"Inputs!M64","v":0},{"$f":"Inputs!N64","v":0},{"$f":"Inputs!O64","v":0},{"$f":"Inputs!Q64","v":"Utility-data source"}]
[null,null,"UNG","Natural Gas Upstream Emissions","tCO2eq/year",{"$f":"SUM(G10:Q10)","v":0},{"$f":"G7*G9*G8/1000","v":0},{"$f":"H7*H9*H8/1000","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"FUEL OIL No.2 (LFO) UPSTREAM EMISSIONS"]
[null,"Step 1 -","Estimate the LFO upstream emissions "]
[null,null,"U LFO = EFu * HHV * Vfleet"]
[null,null,null,null,"Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"},"Reference/Source"]
[null,null,"HHVLFO","Fuel Oil Higher Heating Value (HHV)","GJ/m3",null,{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!$E$236","v":38.799999999999997},{"$f":"Inputs!G236","v":"MECP ON.20, Table20-1"}]
[null,null,"EFu","Fuel Oil Carbon Intensity - Cradle to Consumer (CTCG)","gCO2eq/MJ",null,{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!$E$237","v":24},{"$f":"Inputs!G237","v":"Canada Fuel LCA Methodology, Table 1 p.119 "}]
[null,null,"VLFO","Light Weight Fuel Oil (No. 2) Annual Consumption","L/year",null,{"$f":"Inputs!E65","v":0},{"$f":"Inputs!F65","v":0},{"$f":"Inputs!G65","v":0},{"$f":"Inputs!H65","v":0},{"$f":"Inputs!I65","v":0},{"$f":"Inputs!J65","v":0},{"$f":"Inputs!K65","v":0},{"$f":"Inputs!L65","v":0},{"$f":"Inputs!M65","v":0},{"$f":"Inputs!N65","v":0},{"$f":"Inputs!O65","v":0},{"$f":"Inputs!Q65","v":"Utility-data source"}]
[null,null,"ULFO","Light Weight Fuel Oil Combustion Upstream Emissions","tCO2eq/year",{"$f":"SUM(G19:Q19)","v":0},{"$f":"G18/1000000*G16*G17","v":0},{"$f":"H18/1000000*H16*H17","v":0},{"$f":"I18/1000000*I16*I17","v":0},{"$f":"J18/1000000*J16*J17","v":0},{"$f":"K18/1000000*K16*K17","v":0},0,0,0,0,0,0]
[]
[null,"DIESEL GENERATOR UPSTREAM EMISSIONS"]
[null,"Step 1 -","Estimate diesel upstream emissions"]
[null,null,"U fleet = EFu * HHV * Vfacility, diesel"]
[null,null,null,null,"Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"},"Reference/Source"]
[null,null,"HHVdiesel","Diesel Higher Heating Value (HHV)","GJ/m3",null,{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!$E$240","v":38.299999999999997},{"$f":"Inputs!G240","v":"MECP ON.20, (Page 96) Table 20-1: Default High Heat Value by Fuel Type"}]
[null,null,"EFu","Diesel Carbon Intensity - Cradle to Consumer (CTCG)","gCO2eq/MJ",null,{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!$E$241","v":25},{"$f":"Inputs!G241","v":"Canada Fuel LCA Methodology, Table 1 p.119 "}]
[null,null,"Vfacility, diesel","Diesel Volume Delivered to Facility","L/year",null,{"$f":"Inputs!E66","v":0},{"$f":"Inputs!F66","v":0},{"$f":"Inputs!G66","v":0},{"$f":"Inputs!H66","v":0},{"$f":"Inputs!I66","v":0},{"$f":"Inputs!J66","v":0},{"$f":"Inputs!K66","v":0},{"$f":"Inputs!L66","v":0},{"$f":"Inputs!M66","v":0},{"$f":"Inputs!N66","v":0},{"$f":"Inputs!O66","v":0},{"$f":"Inputs!Q66","v":"Utility-data source"}]
[null,null,"Cdiesel","Diesel Combustion Upstream Emissions","tCO2eq/year",{"$f":"SUM(G28:Q28)","v":0},{"$f":"((G27)/1000000*G25*G26)","v":0},{"$f":"((H27)/1000000*H25*H26)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"PROPANE UPSTREAM EMISSIONS"]
[null,"Step 1 -","Estimate propane upstream emissions"]
[null,null,"U fleet = EFu * HHV * Vfacility, propane"]
[null,null,null,null,"Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"},"Reference/Source"]
[null,null,"HHVpropane","Propane Higher Heating Value (HHV)","GJ/m3",null,{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!$E$244","v":25.48},{"$f":"Inputs!G244","v":"MECP ON.20 (Page 96) Table 20-2: Default LPG High Heat Value by Fuel Type"}]
[null,null,"EFu","Propane Carbon Intensity - Cradle to Consumer (CTCG)","gCO2eq/MJ",null,{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!$E$245","v":16},{"$f":"Inputs!G245","v":"Canada Fuel LCA Methodology, Table 1 p.119 "}]
[null,null,"Vfacility, propane","Propane Volume Delivered to Facility","L/year",null,{"$f":"Inputs!E67","v":0},{"$f":"Inputs!F67","v":0},{"$f":"Inputs!G67","v":0},{"$f":"Inputs!H67","v":0},{"$f":"Inputs!I67","v":0},{"$f":"Inputs!J67","v":0},{"$f":"Inputs!K67","v":0},{"$f":"Inputs!L67","v":0},{"$f":"Inputs!M67","v":0},{"$f":"Inputs!N67","v":0},{"$f":"Inputs!O67","v":0},{"$f":"Inputs!Q67","v":"Utility-data source"}]
[null,null,"Cpropane","Propane Combustion Upstream Emissions","tCO2eq/year",{"$f":"SUM(G37:Q37)","v":0},{"$f":"((G36)/1000000*G34*G35)","v":0},{"$f":"((H36)/1000000*H34*H35)","v":0},{"$f":"((I36)/1000000*I34*I35)","v":0},{"$f":"((J36)/1000000*J34*J35)","v":0},{"$f":"((K36)/1000000*K34*K35)","v":0},{"$f":"((L36)/1000000*L34*L35)","v":0},{"$f":"((M36)/1000000*M34*M35)","v":0},{"$f":"((N36)/1000000*N34*N35)","v":0},{"$f":"((O36)/1000000*O34*O35)","v":0},{"$f":"((P36)/1000000*P34*P35)","v":0},{"$f":"((Q36)/1000000*Q34*Q35)","v":0}]
[]
[null,"FLEET VEHICLE UPSTREAM EMISSIONS"]
[null,"Note: A generic emissions factor for biodiesel has been provided and is appropriate to use where a small proportion of the fuel being combusted is biodiesel.  "]
[null,null,"It is important to note that if using a significant amount of biodiesel, an emissions factor should be researched based on the type of biodiesel being combusted, as lifecycle emissions can vary significantly between different biodiesel feedstocks."]
[]
[null,"Step 1 -","Estimate the fleet vehicle upstream emissions"]
[null,null,"U fleet = EFu * HHV * Vfleet"]
[null,null,null,null,null,"Input Value",null,null,"Reference/Source"]
[null,null,null,null,null,"DIESEL","GASOLINE","BIODIESEL"]
[null,null,"HHV","Fuel Higher Heating Value","GJ/m3",{"$f":"'Scope 1 - Combustion'!F119","v":38.299999999999997},{"$f":"'Scope 1 - Combustion'!G119","v":38.799999999999997},{"$f":"'Scope 1 - Combustion'!H119","v":32.06},{"$f":"CONCATENATE(Inputs!G240,\"; \",Inputs!G248,\"; \",Inputs!G252)","v":"MECP ON.20, (Page 96) Table 20-1: Default High Heat Value by Fuel Type; MECP ON.20 (Page 96) Table 20-1: Default High Heat Value by Fuel Type; MECP ON.20 (Page 96) Table 20-1: Default High Heat Value by Fuel Type"}]
[null,null,"EFu","Fuel Upstream Emission Factor ","gCO2eq/MJ",{"$f":"'Scope 1 - Combustion'!F120","v":25},{"$f":"'Scope 1 - Combustion'!G120","v":24},null,{"$f":"CONCATENATE(Inputs!G241,\"; \",Inputs!G249)","v":"Canada Fuel LCA Methodology, Table 1 p.119 ; Canada Fuel LCA Methodology, Table 1 p.119 "}]
[]
[null,null,null,"Annual Volume Fleet Fuel Consumed","Unit","TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"},"Reference/Source"]
[null,null,"Vfleet, diesel","Diesel Annual Consumption by Vehicle Fleet ","L/year",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!O70","v":0},{"$f":"Inputs!Q70","v":"Utility-data source"}]
[null,null,"Vfleet, gasoline","Gasoline Annual Consumption by Vehicle Fleet ","L/year",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!O71","v":0},{"$f":"Inputs!Q71","v":"Utility-data source"}]
[null,null,"Vfleet, biodiesel","Biodiesel Annual Consumption by Vehicle Fleet ","L/year",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!O72","v":0},{"$f":"Inputs!Q72","v":"Utility-data source"}]
[null,null,"Cfleet","Fleet Fuel Combustion Upstream Emissions","tCO2eq/year",{"$f":"SUM(G54:Q54)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"((Q51)/1000000*$F$48*$F$47)+(Q52/1000000*$G$47*$G$48)+(Q53/1000000*$H$47*$H$48)","v":0}]

{"sheet":"Scope 3 - Biosolids","index":9,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[4,6,4,8]]}
[null,"Scope 3 - GHG Emissions associated with Biosolids Management"]
[]
[null,"OFF-SITE BIOSOLIDS MANAGEMENT EMISSIONS"]
[null,"Step 1 -","Choose inventory approach for biosolids"]
[null,null,"Inventory approach for biosolids",null,null,null,{"$f":"Inputs!$E$81","v":"BEAM 2022"}]
[]
[null,"Step 2-","Estimate the emissions associated with biosolids management (BEAM)"]
[null,null,null,"Unit Process",null,null,{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"}]
[null,null,null,"Alkaline Stabilization","tCO2eq/year",null,{"$f":"IF($G$5=Inputs!$T$80,Inputs!E85,IF($G$5=Inputs!$T$81,Inputs!E94,\"\"))","v":0},{"$f":"IF($G$5=Inputs!$T$80,Inputs!F85,IF($G$5=Inputs!$T$81,Inputs!F94,\"\"))","v":0},{"$f":"IF($G$5=Inputs!$T$80,Inputs!G85,IF($G$5=Inputs!$T$81,Inputs!G94,\"\"))","v":0},{"$f":"IF($G$5=Inputs!$T$80,Inputs!H85,IF($G$5=Inputs!$T$81,Inputs!H94,\"\"))","v":0}]
[null,null,null,"Composting","tCO2eq/year",null,{"$f":"IF($G$5=Inputs!$T$80,Inputs!E86,IF($G$5=Inputs!$T$81,Inputs!E95,\"\"))","v":0},{"$f":"IF($G$5=Inputs!$T$80,Inputs!F86,IF($G$5=Inputs!$T$81,Inputs!F95,\"\"))","v":0},{"$f":"IF($G$5=Inputs!$T$80,Inputs!G86,IF($G$5=Inputs!$T$81,Inputs!G95,\"\"))","v":0},{"$f":"IF($G$5=Inputs!$T$80,Inputs!H86,IF($G$5=Inputs!$T$81,Inputs!H95,\"\"))","v":0}]
[null,null,null,"Composting 2","tCO2eq/year",null,{"$f":"IF($G$5=Inputs!$T$81,Inputs!E96,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!F96,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!G96,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!H96,\"\")","v":0}]
[null,null,null,"Landfill Disposal - Typical","tCO2eq/year",null,{"$f":"IF($G$5=Inputs!$T$80,Inputs!E87,IF($G$5=Inputs!$T$81,Inputs!E97,\"\"))","v":0},{"$f":"IF($G$5=Inputs!$T$80,Inputs!F87,IF($G$5=Inputs!$T$81,Inputs!F97,\"\"))","v":0},{"$f":"IF($G$5=Inputs!$T$80,Inputs!G87,IF($G$5=Inputs!$T$81,Inputs!G97,\"\"))","v":0},{"$f":"IF($G$5=Inputs!$T$80,Inputs!H87,IF($G$5=Inputs!$T$81,Inputs!H97,\"\"))","v":0}]
[null,null,null,"Landfill Disposal - Worst Case","tCO2eq/year",null,{"$f":"IF($G$5=Inputs!$T$81,Inputs!E98,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!F98,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!G98,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!H98,\"\")","v":0}]
[null,null,null,"Landfill Disposal - Aggressive","tCO2eq/year",null,{"$f":"IF($G$5=Inputs!$T$81,Inputs!E99,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!F99,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!G99,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!H99,\"\")","v":0}]
[null,null,null,"Landfill Disposal - CA Regulatory","tCO2eq/year",null,{"$f":"IF($G$5=Inputs!$T$81,Inputs!E100,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!F100,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!G100,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!H100,\"\")","v":0}]
[null,null,null,"Combustion","tCO2eq/year",null,{"$f":"IF($G$5=Inputs!$T$80,Inputs!E88,IF($G$5=Inputs!$T$81,Inputs!E101,\"\"))","v":0},{"$f":"IF($G$5=Inputs!$T$80,Inputs!F88,IF($G$5=Inputs!$T$81,Inputs!F101,\"\"))","v":0},{"$f":"IF($G$5=Inputs!$T$80,Inputs!G88,IF($G$5=Inputs!$T$81,Inputs!G101,\"\"))","v":0},{"$f":"IF($G$5=Inputs!$T$80,Inputs!H88,IF($G$5=Inputs!$T$81,Inputs!H101,\"\"))","v":0}]
[null,null,null,"Pyrolysis","tCO2eq/year",null,{"$f":"IF($G$5=Inputs!$T$81,Inputs!E102,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!F102,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!G102,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!H102,\"\")","v":0}]
[null,null,null,"Land Application","tCO2eq/year",null,{"$f":"IF($G$5=Inputs!$T$80,Inputs!E89,IF($G$5=Inputs!$T$81,Inputs!E103,\"\"))","v":0},{"$f":"IF($G$5=Inputs!$T$80,Inputs!F89,IF($G$5=Inputs!$T$81,Inputs!F103,\"\"))","v":0},{"$f":"IF($G$5=Inputs!$T$80,Inputs!G89,IF($G$5=Inputs!$T$81,Inputs!G103,\"\"))","v":0},{"$f":"IF($G$5=Inputs!$T$80,Inputs!H89,IF($G$5=Inputs!$T$81,Inputs!H103,\"\"))","v":0}]
[null,null,null,"Land Application 2","tCO2eq/year",null,{"$f":"IF($G$5=Inputs!$T$81,Inputs!E104,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!F104,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!G104,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!H104,\"\")","v":0}]
[null,null,null,"Miscellaneous Emissions","tCO2eq/year",null,{"$f":"IF($G$5=Inputs!$T$81,Inputs!E105,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!F105,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!G105,\"\")","v":0},{"$f":"IF($G$5=Inputs!$T$81,Inputs!H105,\"\")","v":0}]
[null,null,null,"Transportation","tCO2eq/year",null,{"$f":"IF($G$5=Inputs!$T$80,Inputs!E90,IF($G$5=Inputs!$T$81,Inputs!E106,\"\"))","v":0},{"$f":"IF($G$5=Inputs!$T$80,Inputs!F90,IF($G$5=Inputs!$T$81,Inputs!F106,\"\"))","v":0},{"$f":"IF($G$5=Inputs!$T$80,Inputs!G90,IF($G$5=Inputs!$T$81,Inputs!G106,\"\"))","v":0},{"$f":"IF($G$5=Inputs!$T$80,Inputs!H90,IF($G$5=Inputs!$T$81,Inputs!H106,\"\"))","v":0}]
[null,null,null,"Total Biosolids Management Emissions","tCO2eq/year",{"$f":"SUM(G22:J22)","v":0},{"$f":"SUM(G9:G21)","v":0},{"$f":"SUM(H9:H21)","v":0},0,0]

{"sheet":"Scope 3 - Chemicals","index":10,"n_rows":166,"n_cols":19,"rows_kept":166,"cut":false,"hidden":false,"merged":[[5,2,5,3],[74,2,74,3]]}
[null,"Scope 3 - GHG Emissions associated with Chemical Consumption",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DO NOT DELETE OR ALTER CELLS IN COLUMNS \"S\" AND BEYOND. THESE ARE USED AS INTERNAL CALCULATIONS FOR FORMATTING AND LISTS."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COLUMNS \"S\" AND BEYOND DO NOT NEED TO BE PRINTED FOR AND OUTPUTS."]
[null,"Note:","Please refer to the User Guide for guidance on approaches for estimating emissions from chemicals"]
[null,"CHEMICAL CONSUMPTION EMISSIONS"]
[null,"Step 1 -","Estimate the emissions associated with chemical production",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true}]
[null,null,"Echem = EFchem * Mchem",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true}]
[null,null,null,null,"Unit","Input Value","Reference/Source",null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true}]
[null,null,"EFchem","Chemicals Emission Factors"]
[null,null,null,{"$f":"Inputs!C110","v":"Chemical 1"},"kgCO2eq/kg",{"$f":"Inputs!E265","v":0},{"$f":"Inputs!G265","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T110","v":false}]
[null,null,null,{"$f":"Inputs!C111","v":"Chemical 2"},"kgCO2eq/kg",{"$f":"Inputs!E266","v":0},{"$f":"Inputs!G266","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T111","v":false}]
[null,null,null,{"$f":"Inputs!C112","v":"Chemical 3"},"kgCO2eq/kg",{"$f":"Inputs!E267","v":0},{"$f":"Inputs!G267","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T112","v":false}]
[null,null,null,{"$f":"Inputs!C113","v":"Chemical 4"},"kgCO2eq/kg",{"$f":"Inputs!E268","v":0},{"$f":"Inputs!G268","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T113","v":false}]
[null,null,null,{"$f":"Inputs!C114","v":"Chemical 5"},"kgCO2eq/kg",{"$f":"Inputs!E269","v":0},{"$f":"Inputs!G269","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T114","v":false}]
[null,null,null,{"$f":"Inputs!C115","v":"Chemical 6"},"kgCO2eq/kg",{"$f":"Inputs!E270","v":0},{"$f":"Inputs!G270","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T115","v":false}]
[null,null,null,{"$f":"Inputs!C116","v":"Chemical 7"},"kgCO2eq/kg",{"$f":"Inputs!E271","v":0},{"$f":"Inputs!G271","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T116","v":false}]
[null,null,null,{"$f":"Inputs!C117","v":"Chemical 8"},"kgCO2eq/kg",{"$f":"Inputs!E272","v":0},{"$f":"Inputs!G272","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T117","v":false}]
[null,null,null,{"$f":"Inputs!C118","v":"Chemical 9"},"kgCO2eq/kg",{"$f":"Inputs!E273","v":0},{"$f":"Inputs!G273","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T118","v":false}]
[null,null,null,{"$f":"Inputs!C119","v":"Chemical 10"},"kgCO2eq/kg",{"$f":"Inputs!E274","v":0},{"$f":"Inputs!G274","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T119","v":false}]
[null,null,null,{"$f":"Inputs!C120","v":"Chemical 11"},"kgCO2eq/kg",{"$f":"Inputs!E275","v":0},{"$f":"Inputs!G275","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T120","v":false}]
[null,null,null,{"$f":"Inputs!C121","v":"Chemical 12"},"kgCO2eq/kg",{"$f":"Inputs!E276","v":0},{"$f":"Inputs!G276","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T121","v":false}]
[null,null,null,{"$f":"Inputs!C122","v":"Chemical 13"},"kgCO2eq/kg",{"$f":"Inputs!E277","v":0},{"$f":"Inputs!G277","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T122","v":false}]
[null,null,null,{"$f":"Inputs!C123","v":"Chemical 14"},"kgCO2eq/kg",{"$f":"Inputs!E278","v":0},{"$f":"Inputs!G278","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T123","v":false}]
[null,null,null,{"$f":"Inputs!C124","v":"Chemical 15"},"kgCO2eq/kg",{"$f":"Inputs!E279","v":0},{"$f":"Inputs!G279","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T124","v":false}]
[null,null,null,{"$f":"Inputs!C125","v":"Chemical 16"},"kgCO2eq/kg",{"$f":"Inputs!E280","v":0},{"$f":"Inputs!G280","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T125","v":false}]
[null,null,null,{"$f":"Inputs!C126","v":"Chemical 17"},"kgCO2eq/kg",{"$f":"Inputs!E281","v":0},{"$f":"Inputs!G281","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T126","v":false}]
[null,null,null,{"$f":"Inputs!C127","v":"Chemical 18"},"kgCO2eq/kg",{"$f":"Inputs!E282","v":0},{"$f":"Inputs!G282","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T127","v":false}]
[null,null,null,{"$f":"Inputs!C128","v":"Chemical 19"},"kgCO2eq/kg",{"$f":"Inputs!E283","v":0},{"$f":"Inputs!G283","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T128","v":false}]
[null,null,null,{"$f":"Inputs!C129","v":"Chemical 20"},"kgCO2eq/kg",{"$f":"Inputs!E284","v":0},{"$f":"Inputs!G284","v":"Utility-data source"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!T129","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true}]
[null,null,"Mchem","Annual Mass of Chemicals Consumed ",null,"TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"},null,{"$f":"TRUE","v":true}]
[null,null,null,{"$f":"Inputs!C110","v":"Chemical 1"},"kg/year",null,{"$f":"IF(Inputs!E110=\"\",\"\",Inputs!E110)","v":""},{"$f":"IF(Inputs!F110=\"\",\"\",Inputs!F110)","v":""},{"$f":"IF(Inputs!G110=\"\",\"\",Inputs!G110)","v":""},{"$f":"IF(Inputs!H110=\"\",\"\",Inputs!H110)","v":""},{"$f":"IF(Inputs!I110=\"\",\"\",Inputs!I110)","v":""},{"$f":"IF(Inputs!J110=\"\",\"\",Inputs!J110)","v":""},{"$f":"IF(Inputs!K110=\"\",\"\",Inputs!K110)","v":""},{"$f":"IF(Inputs!L110=\"\",\"\",Inputs!L110)","v":""},{"$f":"IF(Inputs!M110=\"\",\"\",Inputs!M110)","v":""},{"$f":"IF(Inputs!N110=\"\",\"\",Inputs!N110)","v":""},{"$f":"IF(Inputs!O110=\"\",\"\",Inputs!O110)","v":""},null,{"$f":"Inputs!T110","v":false}]
[null,null,null,{"$f":"Inputs!C111","v":"Chemical 2"},"kg/year",null,{"$f":"IF(Inputs!E111=\"\",\"\",Inputs!E111)","v":""},{"$f":"IF(Inputs!F111=\"\",\"\",Inputs!F111)","v":""},{"$f":"IF(Inputs!G111=\"\",\"\",Inputs!G111)","v":""},{"$f":"IF(Inputs!H111=\"\",\"\",Inputs!H111)","v":""},{"$f":"IF(Inputs!I111=\"\",\"\",Inputs!I111)","v":""},{"$f":"IF(Inputs!J111=\"\",\"\",Inputs!J111)","v":""},{"$f":"IF(Inputs!K111=\"\",\"\",Inputs!K111)","v":""},{"$f":"IF(Inputs!L111=\"\",\"\",Inputs!L111)","v":""},{"$f":"IF(Inputs!M111=\"\",\"\",Inputs!M111)","v":""},{"$f":"IF(Inputs!N111=\"\",\"\",Inputs!N111)","v":""},{"$f":"IF(Inputs!O111=\"\",\"\",Inputs!O111)","v":""},null,{"$f":"Inputs!T111","v":false}]
[null,null,null,{"$f":"Inputs!C112","v":"Chemical 3"},"kg/year",null,{"$f":"IF(Inputs!E112=\"\",\"\",Inputs!E112)","v":""},{"$f":"IF(Inputs!F112=\"\",\"\",Inputs!F112)","v":""},{"$f":"IF(Inputs!G112=\"\",\"\",Inputs!G112)","v":""},{"$f":"IF(Inputs!H112=\"\",\"\",Inputs!H112)","v":""},{"$f":"IF(Inputs!I112=\"\",\"\",Inputs!I112)","v":""},{"$f":"IF(Inputs!J112=\"\",\"\",Inputs!J112)","v":""},{"$f":"IF(Inputs!K112=\"\",\"\",Inputs!K112)","v":""},{"$f":"IF(Inputs!L112=\"\",\"\",Inputs!L112)","v":""},{"$f":"IF(Inputs!M112=\"\",\"\",Inputs!M112)","v":""},{"$f":"IF(Inputs!N112=\"\",\"\",Inputs!N112)","v":""},{"$f":"IF(Inputs!O112=\"\",\"\",Inputs!O112)","v":""},null,{"$f":"Inputs!T112","v":false}]
[null,null,null,{"$f":"Inputs!C113","v":"Chemical 4"},"kg/year",null,{"$f":"IF(Inputs!E113=\"\",\"\",Inputs!E113)","v":""},{"$f":"IF(Inputs!F113=\"\",\"\",Inputs!F113)","v":""},{"$f":"IF(Inputs!G113=\"\",\"\",Inputs!G113)","v":""},{"$f":"IF(Inputs!H113=\"\",\"\",Inputs!H113)","v":""},{"$f":"IF(Inputs!I113=\"\",\"\",Inputs!I113)","v":""},{"$f":"IF(Inputs!J113=\"\",\"\",Inputs!J113)","v":""},{"$f":"IF(Inputs!K113=\"\",\"\",Inputs!K113)","v":""},{"$f":"IF(Inputs!L113=\"\",\"\",Inputs!L113)","v":""},{"$f":"IF(Inputs!M113=\"\",\"\",Inputs!M113)","v":""},{"$f":"IF(Inputs!N113=\"\",\"\",Inputs!N113)","v":""},{"$f":"IF(Inputs!O113=\"\",\"\",Inputs!O113)","v":""},null,{"$f":"Inputs!T113","v":false}]
[null,null,null,{"$f":"Inputs!C114","v":"Chemical 5"},"kg/year",null,{"$f":"IF(Inputs!E114=\"\",\"\",Inputs!E114)","v":""},{"$f":"IF(Inputs!F114=\"\",\"\",Inputs!F114)","v":""},{"$f":"IF(Inputs!G114=\"\",\"\",Inputs!G114)","v":""},{"$f":"IF(Inputs!H114=\"\",\"\",Inputs!H114)","v":""},{"$f":"IF(Inputs!I114=\"\",\"\",Inputs!I114)","v":""},{"$f":"IF(Inputs!J114=\"\",\"\",Inputs!J114)","v":""},{"$f":"IF(Inputs!K114=\"\",\"\",Inputs!K114)","v":""},{"$f":"IF(Inputs!L114=\"\",\"\",Inputs!L114)","v":""},{"$f":"IF(Inputs!M114=\"\",\"\",Inputs!M114)","v":""},{"$f":"IF(Inputs!N114=\"\",\"\",Inputs!N114)","v":""},{"$f":"IF(Inputs!O114=\"\",\"\",Inputs!O114)","v":""},null,{"$f":"Inputs!T114","v":false}]
[null,null,null,{"$f":"Inputs!C115","v":"Chemical 6"},"kg/year",null,{"$f":"IF(Inputs!E115=\"\",\"\",Inputs!E115)","v":""},{"$f":"IF(Inputs!F115=\"\",\"\",Inputs!F115)","v":""},{"$f":"IF(Inputs!G115=\"\",\"\",Inputs!G115)","v":""},{"$f":"IF(Inputs!H115=\"\",\"\",Inputs!H115)","v":""},{"$f":"IF(Inputs!I115=\"\",\"\",Inputs!I115)","v":""},{"$f":"IF(Inputs!J115=\"\",\"\",Inputs!J115)","v":""},{"$f":"IF(Inputs!K115=\"\",\"\",Inputs!K115)","v":""},{"$f":"IF(Inputs!L115=\"\",\"\",Inputs!L115)","v":""},{"$f":"IF(Inputs!M115=\"\",\"\",Inputs!M115)","v":""},{"$f":"IF(Inputs!N115=\"\",\"\",Inputs!N115)","v":""},{"$f":"IF(Inputs!O115=\"\",\"\",Inputs!O115)","v":""},null,{"$f":"Inputs!T115","v":false}]
[null,null,null,{"$f":"Inputs!C116","v":"Chemical 7"},"kg/year",null,{"$f":"IF(Inputs!E116=\"\",\"\",Inputs!E116)","v":""},{"$f":"IF(Inputs!F116=\"\",\"\",Inputs!F116)","v":""},{"$f":"IF(Inputs!G116=\"\",\"\",Inputs!G116)","v":""},{"$f":"IF(Inputs!H116=\"\",\"\",Inputs!H116)","v":""},{"$f":"IF(Inputs!I116=\"\",\"\",Inputs!I116)","v":""},{"$f":"IF(Inputs!J116=\"\",\"\",Inputs!J116)","v":""},{"$f":"IF(Inputs!K116=\"\",\"\",Inputs!K116)","v":""},{"$f":"IF(Inputs!L116=\"\",\"\",Inputs!L116)","v":""},{"$f":"IF(Inputs!M116=\"\",\"\",Inputs!M116)","v":""},{"$f":"IF(Inputs!N116=\"\",\"\",Inputs!N116)","v":""},{"$f":"IF(Inputs!O116=\"\",\"\",Inputs!O116)","v":""},null,{"$f":"Inputs!T116","v":false}]
[null,null,null,{"$f":"Inputs!C117","v":"Chemical 8"},"kg/year",null,{"$f":"IF(Inputs!E117=\"\",\"\",Inputs!E117)","v":""},{"$f":"IF(Inputs!F117=\"\",\"\",Inputs!F117)","v":""},{"$f":"IF(Inputs!G117=\"\",\"\",Inputs!G117)","v":""},{"$f":"IF(Inputs!H117=\"\",\"\",Inputs!H117)","v":""},{"$f":"IF(Inputs!I117=\"\",\"\",Inputs!I117)","v":""},{"$f":"IF(Inputs!J117=\"\",\"\",Inputs!J117)","v":""},{"$f":"IF(Inputs!K117=\"\",\"\",Inputs!K117)","v":""},{"$f":"IF(Inputs!L117=\"\",\"\",Inputs!L117)","v":""},{"$f":"IF(Inputs!M117=\"\",\"\",Inputs!M117)","v":""},{"$f":"IF(Inputs!N117=\"\",\"\",Inputs!N117)","v":""},{"$f":"IF(Inputs!O117=\"\",\"\",Inputs!O117)","v":""},null,{"$f":"Inputs!T117","v":false}]
[null,null,null,{"$f":"Inputs!C118","v":"Chemical 9"},"kg/year",null,{"$f":"IF(Inputs!E118=\"\",\"\",Inputs!E118)","v":""},{"$f":"IF(Inputs!F118=\"\",\"\",Inputs!F118)","v":""},{"$f":"IF(Inputs!G118=\"\",\"\",Inputs!G118)","v":""},{"$f":"IF(Inputs!H118=\"\",\"\",Inputs!H118)","v":""},{"$f":"IF(Inputs!I118=\"\",\"\",Inputs!I118)","v":""},{"$f":"IF(Inputs!J118=\"\",\"\",Inputs!J118)","v":""},{"$f":"IF(Inputs!K118=\"\",\"\",Inputs!K118)","v":""},{"$f":"IF(Inputs!L118=\"\",\"\",Inputs!L118)","v":""},{"$f":"IF(Inputs!M118=\"\",\"\",Inputs!M118)","v":""},{"$f":"IF(Inputs!N118=\"\",\"\",Inputs!N118)","v":""},{"$f":"IF(Inputs!O118=\"\",\"\",Inputs!O118)","v":""},null,{"$f":"Inputs!T118","v":false}]
[null,null,null,{"$f":"Inputs!C119","v":"Chemical 10"},"kg/year",null,{"$f":"IF(Inputs!E119=\"\",\"\",Inputs!E119)","v":""},{"$f":"IF(Inputs!F119=\"\",\"\",Inputs!F119)","v":""},{"$f":"IF(Inputs!G119=\"\",\"\",Inputs!G119)","v":""},{"$f":"IF(Inputs!H119=\"\",\"\",Inputs!H119)","v":""},{"$f":"IF(Inputs!I119=\"\",\"\",Inputs!I119)","v":""},{"$f":"IF(Inputs!J119=\"\",\"\",Inputs!J119)","v":""},{"$f":"IF(Inputs!K119=\"\",\"\",Inputs!K119)","v":""},{"$f":"IF(Inputs!L119=\"\",\"\",Inputs!L119)","v":""},{"$f":"IF(Inputs!M119=\"\",\"\",Inputs!M119)","v":""},{"$f":"IF(Inputs!N119=\"\",\"\",Inputs!N119)","v":""},{"$f":"IF(Inputs!O119=\"\",\"\",Inputs!O119)","v":""},null,{"$f":"Inputs!T119","v":false}]
[null,null,null,{"$f":"Inputs!C120","v":"Chemical 11"},"kg/year",null,{"$f":"IF(Inputs!E120=\"\",\"\",Inputs!E120)","v":""},{"$f":"IF(Inputs!F120=\"\",\"\",Inputs!F120)","v":""},{"$f":"IF(Inputs!G120=\"\",\"\",Inputs!G120)","v":""},{"$f":"IF(Inputs!H120=\"\",\"\",Inputs!H120)","v":""},{"$f":"IF(Inputs!I120=\"\",\"\",Inputs!I120)","v":""},{"$f":"IF(Inputs!J120=\"\",\"\",Inputs!J120)","v":""},{"$f":"IF(Inputs!K120=\"\",\"\",Inputs!K120)","v":""},{"$f":"IF(Inputs!L120=\"\",\"\",Inputs!L120)","v":""},{"$f":"IF(Inputs!M120=\"\",\"\",Inputs!M120)","v":""},{"$f":"IF(Inputs!N120=\"\",\"\",Inputs!N120)","v":""},{"$f":"IF(Inputs!O120=\"\",\"\",Inputs!O120)","v":""},null,{"$f":"Inputs!T120","v":false}]
[null,null,null,{"$f":"Inputs!C121","v":"Chemical 12"},"kg/year",null,{"$f":"IF(Inputs!E121=\"\",\"\",Inputs!E121)","v":""},{"$f":"IF(Inputs!F121=\"\",\"\",Inputs!F121)","v":""},{"$f":"IF(Inputs!G121=\"\",\"\",Inputs!G121)","v":""},{"$f":"IF(Inputs!H121=\"\",\"\",Inputs!H121)","v":""},{"$f":"IF(Inputs!I121=\"\",\"\",Inputs!I121)","v":""},{"$f":"IF(Inputs!J121=\"\",\"\",Inputs!J121)","v":""},{"$f":"IF(Inputs!K121=\"\",\"\",Inputs!K121)","v":""},{"$f":"IF(Inputs!L121=\"\",\"\",Inputs!L121)","v":""},{"$f":"IF(Inputs!M121=\"\",\"\",Inputs!M121)","v":""},{"$f":"IF(Inputs!N121=\"\",\"\",Inputs!N121)","v":""},{"$f":"IF(Inputs!O121=\"\",\"\",Inputs!O121)","v":""},null,{"$f":"Inputs!T121","v":false}]
[null,null,null,{"$f":"Inputs!C122","v":"Chemical 13"},"kg/year",null,{"$f":"IF(Inputs!E122=\"\",\"\",Inputs!E122)","v":""},{"$f":"IF(Inputs!F122=\"\",\"\",Inputs!F122)","v":""},{"$f":"IF(Inputs!G122=\"\",\"\",Inputs!G122)","v":""},{"$f":"IF(Inputs!H122=\"\",\"\",Inputs!H122)","v":""},{"$f":"IF(Inputs!I122=\"\",\"\",Inputs!I122)","v":""},{"$f":"IF(Inputs!J122=\"\",\"\",Inputs!J122)","v":""},{"$f":"IF(Inputs!K122=\"\",\"\",Inputs!K122)","v":""},{"$f":"IF(Inputs!L122=\"\",\"\",Inputs!L122)","v":""},{"$f":"IF(Inputs!M122=\"\",\"\",Inputs!M122)","v":""},{"$f":"IF(Inputs!N122=\"\",\"\",Inputs!N122)","v":""},{"$f":"IF(Inputs!O122=\"\",\"\",Inputs!O122)","v":""},null,{"$f":"Inputs!T122","v":false}]
[null,null,null,{"$f":"Inputs!C123","v":"Chemical 14"},"kg/year",null,{"$f":"IF(Inputs!E123=\"\",\"\",Inputs!E123)","v":""},{"$f":"IF(Inputs!F123=\"\",\"\",Inputs!F123)","v":""},{"$f":"IF(Inputs!G123=\"\",\"\",Inputs!G123)","v":""},{"$f":"IF(Inputs!H123=\"\",\"\",Inputs!H123)","v":""},{"$f":"IF(Inputs!I123=\"\",\"\",Inputs!I123)","v":""},{"$f":"IF(Inputs!J123=\"\",\"\",Inputs!J123)","v":""},{"$f":"IF(Inputs!K123=\"\",\"\",Inputs!K123)","v":""},{"$f":"IF(Inputs!L123=\"\",\"\",Inputs!L123)","v":""},{"$f":"IF(Inputs!M123=\"\",\"\",Inputs!M123)","v":""},{"$f":"IF(Inputs!N123=\"\",\"\",Inputs!N123)","v":""},{"$f":"IF(Inputs!O123=\"\",\"\",Inputs!O123)","v":""},null,{"$f":"Inputs!T123","v":false}]
[null,null,null,{"$f":"Inputs!C124","v":"Chemical 15"},"kg/year",null,{"$f":"IF(Inputs!E124=\"\",\"\",Inputs!E124)","v":""},{"$f":"IF(Inputs!F124=\"\",\"\",Inputs!F124)","v":""},{"$f":"IF(Inputs!G124=\"\",\"\",Inputs!G124)","v":""},{"$f":"IF(Inputs!H124=\"\",\"\",Inputs!H124)","v":""},{"$f":"IF(Inputs!I124=\"\",\"\",Inputs!I124)","v":""},{"$f":"IF(Inputs!J124=\"\",\"\",Inputs!J124)","v":""},{"$f":"IF(Inputs!K124=\"\",\"\",Inputs!K124)","v":""},{"$f":"IF(Inputs!L124=\"\",\"\",Inputs!L124)","v":""},{"$f":"IF(Inputs!M124=\"\",\"\",Inputs!M124)","v":""},{"$f":"IF(Inputs!N124=\"\",\"\",Inputs!N124)","v":""},{"$f":"IF(Inputs!O124=\"\",\"\",Inputs!O124)","v":""},null,{"$f":"Inputs!T124","v":false}]
[null,null,null,{"$f":"Inputs!C125","v":"Chemical 16"},"kg/year",null,{"$f":"IF(Inputs!E125=\"\",\"\",Inputs!E125)","v":""},{"$f":"IF(Inputs!F125=\"\",\"\",Inputs!F125)","v":""},{"$f":"IF(Inputs!G125=\"\",\"\",Inputs!G125)","v":""},{"$f":"IF(Inputs!H125=\"\",\"\",Inputs!H125)","v":""},{"$f":"IF(Inputs!I125=\"\",\"\",Inputs!I125)","v":""},{"$f":"IF(Inputs!J125=\"\",\"\",Inputs!J125)","v":""},{"$f":"IF(Inputs!K125=\"\",\"\",Inputs!K125)","v":""},{"$f":"IF(Inputs!L125=\"\",\"\",Inputs!L125)","v":""},{"$f":"IF(Inputs!M125=\"\",\"\",Inputs!M125)","v":""},{"$f":"IF(Inputs!N125=\"\",\"\",Inputs!N125)","v":""},{"$f":"IF(Inputs!O125=\"\",\"\",Inputs!O125)","v":""},null,{"$f":"Inputs!T125","v":false}]
[null,null,null,{"$f":"Inputs!C126","v":"Chemical 17"},"kg/year",null,{"$f":"IF(Inputs!E126=\"\",\"\",Inputs!E126)","v":""},{"$f":"IF(Inputs!F126=\"\",\"\",Inputs!F126)","v":""},{"$f":"IF(Inputs!G126=\"\",\"\",Inputs!G126)","v":""},{"$f":"IF(Inputs!H126=\"\",\"\",Inputs!H126)","v":""},{"$f":"IF(Inputs!I126=\"\",\"\",Inputs!I126)","v":""},{"$f":"IF(Inputs!J126=\"\",\"\",Inputs!J126)","v":""},{"$f":"IF(Inputs!K126=\"\",\"\",Inputs!K126)","v":""},{"$f":"IF(Inputs!L126=\"\",\"\",Inputs!L126)","v":""},{"$f":"IF(Inputs!M126=\"\",\"\",Inputs!M126)","v":""},{"$f":"IF(Inputs!N126=\"\",\"\",Inputs!N126)","v":""},{"$f":"IF(Inputs!O126=\"\",\"\",Inputs!O126)","v":""},null,{"$f":"Inputs!T126","v":false}]
[null,null,null,{"$f":"Inputs!C127","v":"Chemical 18"},"kg/year",null,{"$f":"IF(Inputs!E127=\"\",\"\",Inputs!E127)","v":""},{"$f":"IF(Inputs!F127=\"\",\"\",Inputs!F127)","v":""},{"$f":"IF(Inputs!G127=\"\",\"\",Inputs!G127)","v":""},{"$f":"IF(Inputs!H127=\"\",\"\",Inputs!H127)","v":""},{"$f":"IF(Inputs!I127=\"\",\"\",Inputs!I127)","v":""},{"$f":"IF(Inputs!J127=\"\",\"\",Inputs!J127)","v":""},{"$f":"IF(Inputs!K127=\"\",\"\",Inputs!K127)","v":""},{"$f":"IF(Inputs!L127=\"\",\"\",Inputs!L127)","v":""},{"$f":"IF(Inputs!M127=\"\",\"\",Inputs!M127)","v":""},{"$f":"IF(Inputs!N127=\"\",\"\",Inputs!N127)","v":""},{"$f":"IF(Inputs!O127=\"\",\"\",Inputs!O127)","v":""},null,{"$f":"Inputs!T127","v":false}]
[null,null,null,{"$f":"Inputs!C128","v":"Chemical 19"},"kg/year",null,{"$f":"IF(Inputs!E128=\"\",\"\",Inputs!E128)","v":""},{"$f":"IF(Inputs!F128=\"\",\"\",Inputs!F128)","v":""},{"$f":"IF(Inputs!G128=\"\",\"\",Inputs!G128)","v":""},{"$f":"IF(Inputs!H128=\"\",\"\",Inputs!H128)","v":""},{"$f":"IF(Inputs!I128=\"\",\"\",Inputs!I128)","v":""},{"$f":"IF(Inputs!J128=\"\",\"\",Inputs!J128)","v":""},{"$f":"IF(Inputs!K128=\"\",\"\",Inputs!K128)","v":""},{"$f":"IF(Inputs!L128=\"\",\"\",Inputs!L128)","v":""},{"$f":"IF(Inputs!M128=\"\",\"\",Inputs!M128)","v":""},{"$f":"IF(Inputs!N128=\"\",\"\",Inputs!N128)","v":""},{"$f":"IF(Inputs!O128=\"\",\"\",Inputs!O128)","v":""},null,{"$f":"Inputs!T128","v":false}]
[null,null,null,{"$f":"Inputs!C129","v":"Chemical 20"},"kg/year",null,{"$f":"IF(Inputs!E129=\"\",\"\",Inputs!E129)","v":""},{"$f":"IF(Inputs!F129=\"\",\"\",Inputs!F129)","v":""},{"$f":"IF(Inputs!G129=\"\",\"\",Inputs!G129)","v":""},{"$f":"IF(Inputs!H129=\"\",\"\",Inputs!H129)","v":""},{"$f":"IF(Inputs!I129=\"\",\"\",Inputs!I129)","v":""},{"$f":"IF(Inputs!J129=\"\",\"\",Inputs!J129)","v":""},{"$f":"IF(Inputs!K129=\"\",\"\",Inputs!K129)","v":""},{"$f":"IF(Inputs!L129=\"\",\"\",Inputs!L129)","v":""},{"$f":"IF(Inputs!M129=\"\",\"\",Inputs!M129)","v":""},{"$f":"IF(Inputs!N129=\"\",\"\",Inputs!N129)","v":""},{"$f":"IF(Inputs!O129=\"\",\"\",Inputs!O129)","v":""},null,{"$f":"Inputs!T129","v":false}]
[null,null," Echem","Chemical Consumption Emissions",null,null,"\n",null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true}]
[null,null,null,{"$f":"D31","v":"Chemical 1"},"tCO2eq/year",null,{"$f":"IF(G31=\"\",\"\",G31*$F9/1000)","v":""},{"$f":"IF(H31=\"\",\"\",H31*$F9/1000)","v":""},"","","","","","","","","",null,{"$f":"Inputs!T110","v":false}]
[null,null,null,{"$f":"D32","v":"Chemical 2"},"tCO2eq/year",null,{"$f":"IF(G32=\"\",\"\",G32*$F10/1000)","v":""},"","","","","","","","","","",null,{"$f":"Inputs!T111","v":false}]
[null,null,null,"Chemical 3","tCO2eq/year",null,"","","","","","","","","","","",null,{"$f":"Inputs!T112","v":false}]
[null,null,null,"Chemical 4","tCO2eq/year",null,"","","","","","","","","","","",null,{"$f":"Inputs!T113","v":false}]
[null,null,null,"Chemical 5","tCO2eq/year",null,"","","","","","","","","","","",null,{"$f":"Inputs!T114","v":false}]
[null,null,null,"Chemical 6","tCO2eq/year",null,"","","","","","","","","","","",null,{"$f":"Inputs!T115","v":false}]
[null,null,null,"Chemical 7","tCO2eq/year",null,"","","","","","","","","","","",null,{"$f":"Inputs!T116","v":false}]
[null,null,null,"Chemical 8","tCO2eq/year",null,"","","","","","","","","","","",null,{"$f":"Inputs!T117","v":false}]
[null,null,null,"Chemical 9","tCO2eq/year",null,"","","","","","","","","","","",null,{"$f":"Inputs!T118","v":false}]
[null,null,null,"Chemical 10","tCO2eq/year",null,"","","","","","","","","","","",null,{"$f":"Inputs!T119","v":false}]
[null,null,null,"Chemical 11","tCO2eq/year",null,"","","","","","","","","","","",null,{"$f":"Inputs!T120","v":false}]
[null,null,null,"Chemical 12","tCO2eq/year",null,"","","","","","","","","","","",null,{"$f":"Inputs!T121","v":false}]
[null,null,null,"Chemical 13","tCO2eq/year",null,"","","","","","","","","","","",null,{"$f":"Inputs!T122","v":false}]
[null,null,null,"Chemical 14","tCO2eq/year",null,"","","","","","","","","","","",null,{"$f":"Inputs!T123","v":false}]
[null,null,null,"Chemical 15","tCO2eq/year",null,"","","","","","","","","","","",null,{"$f":"Inputs!T124","v":false}]
[null,null,null,"Chemical 16","tCO2eq/year",null,"","","","","","","","","","","",null,{"$f":"Inputs!T125","v":false}]
[null,null,null,"Chemical 17","tCO2eq/year",null,"","","","","","","","","","","",null,{"$f":"Inputs!T126","v":false}]
[null,null,null,"Chemical 18","tCO2eq/year",null,"","","","","","","","","","","",null,{"$f":"Inputs!T127","v":false}]
[null,null,null,"Chemical 19","tCO2eq/year",null,"","","","","","","","","","","",null,{"$f":"Inputs!T128","v":false}]
[null,null,null,"Chemical 20","tCO2eq/year",null,"","","","","","","","","","","",null,{"$f":"Inputs!T129","v":false}]
[null,null,null,"Total Chemical Consumption Emissions ","tCO2eq/year",{"$f":"SUM(G72:Q72)","v":0},{"$f":"SUM(G52:G71)","v":0},{"$f":"SUM(H52:H71)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"TRUE","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true}]
[null,"Step 2 -","Estimate the emissions associated with transporting the chemicals to site",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true}]
[null,null,"Echem,t = EFtransport * Mchem * D",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true}]
[null,null,null,null,"Unit","Input Value","Reference/Source",null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true}]
[null,null,"EFtransport,truck","Heavy-duty Transportation Emission Factor - 16-32 metric ton","kgCO2eq/t*km",{"$f":"Inputs!E260","v":0.128},{"$f":"Inputs!G260","v":"Government of Canada’s Fuel Life Cycle Assessment Model- https://data-donnees.ec.gc.ca/data/regulatee/climateoutreach/government-of-canadas-fuel-life-cycle-assessment-model/en/?lang=en"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true}]
[null,null,"EFtransport,train","Diesel freight train Emission Factor","kgCO2eq/t*km",{"$f":"Inputs!E261","v":1.6469999999999999E-2},{"$f":"Inputs!G262","v":"Government of Canada’s Fuel Life Cycle Assessment Model- https://data-donnees.ec.gc.ca/data/regulatee/climateoutreach/government-of-canadas-fuel-life-cycle-assessment-model/en/?lang=en"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true}]
[null,null,"EFtransport,ship","Sea freight ship for bulk goods","kgCO2eq/t*km",{"$f":"Inputs!E262","v":1.0789999999999999E-2},{"$f":"Inputs!G261","v":"Government of Canada’s Fuel Life Cycle Assessment Model- https://data-donnees.ec.gc.ca/data/regulatee/climateoutreach/government-of-canadas-fuel-life-cycle-assessment-model/en/?lang=en"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true}]
[null,null,null,null,null,"TOTAL",{"$f":"IF(WWTP1=\"\",\"\",WWTP1)","v":"WWTP1"},{"$f":"IF(WWTP2=\"\",\"\",WWTP2)","v":"WWTP2"},{"$f":"IF(WWTP3=\"\",\"\",WWTP3)","v":"WWTP3"},{"$f":"IF(WWTP4=\"\",\"\",WWTP4)","v":"WWTP4"},{"$f":"IF(WWCollection=\"\",\"\",WWCollection)","v":"Collection"},{"$f":"IF(WTP1_=\"\",\"\",WTP1_)","v":"WTP1"},{"$f":"IF(WTP2_=\"\",\"\",WTP2_)","v":"WTP2"},{"$f":"IF(WTP3_=\"\",\"\",WTP3_)","v":"WTP3"},{"$f":"IF(WTP4_=\"\",\"\",WTP4_)","v":"WTP4"},{"$f":"IF(WDistr=\"\",\"\",WDistr)","v":"Distribution"},{"$f":"IF(SuppFac=\"\",\"\",SuppFac)","v":"Supp. Facilities"},null,{"$f":"TRUE","v":true}]
[null,null,"Dtruck","Truck Distance from Supplier to Site (ROUND TRIP)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true}]
[null,null,null,{"$f":"Inputs!C110","v":"Chemical 1"},"km",null,{"$f":"IF(Inputs!E131=\"\",\"\",Inputs!E131)","v":""},{"$f":"IF(Inputs!F131=\"\",\"\",Inputs!F131)","v":""},{"$f":"IF(Inputs!G131=\"\",\"\",Inputs!G131)","v":""},{"$f":"IF(Inputs!H131=\"\",\"\",Inputs!H131)","v":""},{"$f":"IF(Inputs!I131=\"\",\"\",Inputs!I131)","v":""},{"$f":"IF(Inputs!J131=\"\",\"\",Inputs!J131)","v":""},{"$f":"IF(Inputs!K131=\"\",\"\",Inputs!K131)","v":""},{"$f":"IF(Inputs!L131=\"\",\"\",Inputs!L131)","v":""},{"$f":"IF(Inputs!M131=\"\",\"\",Inputs!M131)","v":""},{"$f":"IF(Inputs!N131=\"\",\"\",Inputs!N131)","v":""},{"$f":"IF(Inputs!O131=\"\",\"\",Inputs!O131)","v":""},null,{"$f":"Inputs!U131","v":false}]
[null,null,null,{"$f":"Inputs!C111","v":"Chemical 2"},"km",null,{"$f":"IF(Inputs!E132=\"\",\"\",Inputs!E132)","v":""},{"$f":"IF(Inputs!F132=\"\",\"\",Inputs!F132)","v":""},{"$f":"IF(Inputs!G132=\"\",\"\",Inputs!G132)","v":""},{"$f":"IF(Inputs!H132=\"\",\"\",Inputs!H132)","v":""},{"$f":"IF(Inputs!I132=\"\",\"\",Inputs!I132)","v":""},{"$f":"IF(Inputs!J132=\"\",\"\",Inputs!J132)","v":""},{"$f":"IF(Inputs!K132=\"\",\"\",Inputs!K132)","v":""},{"$f":"IF(Inputs!L132=\"\",\"\",Inputs!L132)","v":""},{"$f":"IF(Inputs!M132=\"\",\"\",Inputs!M132)","v":""},{"$f":"IF(Inputs!N132=\"\",\"\",Inputs!N132)","v":""},{"$f":"IF(Inputs!O132=\"\",\"\",Inputs!O132)","v":""},null,{"$f":"Inputs!U132","v":false}]
[null,null,null,{"$f":"Inputs!C112","v":"Chemical 3"},"km",null,{"$f":"IF(Inputs!E133=\"\",\"\",Inputs!E133)","v":""},{"$f":"IF(Inputs!F133=\"\",\"\",Inputs!F133)","v":""},{"$f":"IF(Inputs!G133=\"\",\"\",Inputs!G133)","v":""},{"$f":"IF(Inputs!H133=\"\",\"\",Inputs!H133)","v":""},{"$f":"IF(Inputs!I133=\"\",\"\",Inputs!I133)","v":""},{"$f":"IF(Inputs!J133=\"\",\"\",Inputs!J133)","v":""},{"$f":"IF(Inputs!K133=\"\",\"\",Inputs!K133)","v":""},{"$f":"IF(Inputs!L133=\"\",\"\",Inputs!L133)","v":""},{"$f":"IF(Inputs!M133=\"\",\"\",Inputs!M133)","v":""},{"$f":"IF(Inputs!N133=\"\",\"\",Inputs!N133)","v":""},{"$f":"IF(Inputs!O133=\"\",\"\",Inputs!O133)","v":""},null,{"$f":"Inputs!U133","v":false}]
[null,null,null,{"$f":"Inputs!C113","v":"Chemical 4"},"km",null,{"$f":"IF(Inputs!E134=\"\",\"\",Inputs!E134)","v":""},{"$f":"IF(Inputs!F134=\"\",\"\",Inputs!F134)","v":""},{"$f":"IF(Inputs!G134=\"\",\"\",Inputs!G134)","v":""},{"$f":"IF(Inputs!H134=\"\",\"\",Inputs!H134)","v":""},{"$f":"IF(Inputs!I134=\"\",\"\",Inputs!I134)","v":""},{"$f":"IF(Inputs!J134=\"\",\"\",Inputs!J134)","v":""},{"$f":"IF(Inputs!K134=\"\",\"\",Inputs!K134)","v":""},{"$f":"IF(Inputs!L134=\"\",\"\",Inputs!L134)","v":""},{"$f":"IF(Inputs!M134=\"\",\"\",Inputs!M134)","v":""},{"$f":"IF(Inputs!N134=\"\",\"\",Inputs!N134)","v":""},{"$f":"IF(Inputs!O134=\"\",\"\",Inputs!O134)","v":""},null,{"$f":"Inputs!U134","v":false}]
[null,null,null,{"$f":"Inputs!C114","v":"Chemical 5"},"km",null,{"$f":"IF(Inputs!E135=\"\",\"\",Inputs!E135)","v":""},{"$f":"IF(Inputs!F135=\"\",\"\",Inputs!F135)","v":""},{"$f":"IF(Inputs!G135=\"\",\"\",Inputs!G135)","v":""},{"$f":"IF(Inputs!H135=\"\",\"\",Inputs!H135)","v":""},{"$f":"IF(Inputs!I135=\"\",\"\",Inputs!I135)","v":""},{"$f":"IF(Inputs!J135=\"\",\"\",Inputs!J135)","v":""},{"$f":"IF(Inputs!K135=\"\",\"\",Inputs!K135)","v":""},{"$f":"IF(Inputs!L135=\"\",\"\",Inputs!L135)","v":""},{"$f":"IF(Inputs!M135=\"\",\"\",Inputs!M135)","v":""},{"$f":"IF(Inputs!N135=\"\",\"\",Inputs!N135)","v":""},{"$f":"IF(Inputs!O135=\"\",\"\",Inputs!O135)","v":""},null,{"$f":"Inputs!U135","v":false}]
[null,null,null,{"$f":"Inputs!C115","v":"Chemical 6"},"km",null,{"$f":"IF(Inputs!E136=\"\",\"\",Inputs!E136)","v":""},{"$f":"IF(Inputs!F136=\"\",\"\",Inputs!F136)","v":""},{"$f":"IF(Inputs!G136=\"\",\"\",Inputs!G136)","v":""},{"$f":"IF(Inputs!H136=\"\",\"\",Inputs!H136)","v":""},{"$f":"IF(Inputs!I136=\"\",\"\",Inputs!I136)","v":""},{"$f":"IF(Inputs!J136=\"\",\"\",Inputs!J136)","v":""},{"$f":"IF(Inputs!K136=\"\",\"\",Inputs!K136)","v":""},{"$f":"IF(Inputs!L136=\"\",\"\",Inputs!L136)","v":""},{"$f":"IF(Inputs!M136=\"\",\"\",Inputs!M136)","v":""},{"$f":"IF(Inputs!N136=\"\",\"\",Inputs!N136)","v":""},{"$f":"IF(Inputs!O136=\"\",\"\",Inputs!O136)","v":""},null,{"$f":"Inputs!U136","v":false}]
[null,null,null,{"$f":"Inputs!C116","v":"Chemical 7"},"km",null,{"$f":"IF(Inputs!E137=\"\",\"\",Inputs!E137)","v":""},{"$f":"IF(Inputs!F137=\"\",\"\",Inputs!F137)","v":""},{"$f":"IF(Inputs!G137=\"\",\"\",Inputs!G137)","v":""},{"$f":"IF(Inputs!H137=\"\",\"\",Inputs!H137)","v":""},{"$f":"IF(Inputs!I137=\"\",\"\",Inputs!I137)","v":""},{"$f":"IF(Inputs!J137=\"\",\"\",Inputs!J137)","v":""},{"$f":"IF(Inputs!K137=\"\",\"\",Inputs!K137)","v":""},{"$f":"IF(Inputs!L137=\"\",\"\",Inputs!L137)","v":""},{"$f":"IF(Inputs!M137=\"\",\"\",Inputs!M137)","v":""},{"$f":"IF(Inputs!N137=\"\",\"\",Inputs!N137)","v":""},{"$f":"IF(Inputs!O137=\"\",\"\",Inputs!O137)","v":""},null,{"$f":"Inputs!U137","v":false}]
[null,null,null,{"$f":"Inputs!C117","v":"Chemical 8"},"km",null,{"$f":"IF(Inputs!E138=\"\",\"\",Inputs!E138)","v":""},{"$f":"IF(Inputs!F138=\"\",\"\",Inputs!F138)","v":""},{"$f":"IF(Inputs!G138=\"\",\"\",Inputs!G138)","v":""},{"$f":"IF(Inputs!H138=\"\",\"\",Inputs!H138)","v":""},{"$f":"IF(Inputs!I138=\"\",\"\",Inputs!I138)","v":""},{"$f":"IF(Inputs!J138=\"\",\"\",Inputs!J138)","v":""},{"$f":"IF(Inputs!K138=\"\",\"\",Inputs!K138)","v":""},{"$f":"IF(Inputs!L138=\"\",\"\",Inputs!L138)","v":""},{"$f":"IF(Inputs!M138=\"\",\"\",Inputs!M138)","v":""},{"$f":"IF(Inputs!N138=\"\",\"\",Inputs!N138)","v":""},{"$f":"IF(Inputs!O138=\"\",\"\",Inputs!O138)","v":""},null,{"$f":"Inputs!U138","v":false}]
[null,null,null,{"$f":"Inputs!C118","v":"Chemical 9"},"km",null,{"$f":"IF(Inputs!E139=\"\",\"\",Inputs!E139)","v":""},{"$f":"IF(Inputs!F139=\"\",\"\",Inputs!F139)","v":""},{"$f":"IF(Inputs!G139=\"\",\"\",Inputs!G139)","v":""},{"$f":"IF(Inputs!H139=\"\",\"\",Inputs!H139)","v":""},{"$f":"IF(Inputs!I139=\"\",\"\",Inputs!I139)","v":""},{"$f":"IF(Inputs!J139=\"\",\"\",Inputs!J139)","v":""},{"$f":"IF(Inputs!K139=\"\",\"\",Inputs!K139)","v":""},{"$f":"IF(Inputs!L139=\"\",\"\",Inputs!L139)","v":""},{"$f":"IF(Inputs!M139=\"\",\"\",Inputs!M139)","v":""},{"$f":"IF(Inputs!N139=\"\",\"\",Inputs!N139)","v":""},{"$f":"IF(Inputs!O139=\"\",\"\",Inputs!O139)","v":""},null,{"$f":"Inputs!U139","v":false}]
[null,null,null,{"$f":"Inputs!C119","v":"Chemical 10"},"km",null,{"$f":"IF(Inputs!E140=\"\",\"\",Inputs!E140)","v":""},{"$f":"IF(Inputs!F140=\"\",\"\",Inputs!F140)","v":""},{"$f":"IF(Inputs!G140=\"\",\"\",Inputs!G140)","v":""},{"$f":"IF(Inputs!H140=\"\",\"\",Inputs!H140)","v":""},{"$f":"IF(Inputs!I140=\"\",\"\",Inputs!I140)","v":""},{"$f":"IF(Inputs!J140=\"\",\"\",Inputs!J140)","v":""},{"$f":"IF(Inputs!K140=\"\",\"\",Inputs!K140)","v":""},{"$f":"IF(Inputs!L140=\"\",\"\",Inputs!L140)","v":""},{"$f":"IF(Inputs!M140=\"\",\"\",Inputs!M140)","v":""},{"$f":"IF(Inputs!N140=\"\",\"\",Inputs!N140)","v":""},{"$f":"IF(Inputs!O140=\"\",\"\",Inputs!O140)","v":""},null,{"$f":"Inputs!U140","v":false}]
[null,null,null,{"$f":"Inputs!C120","v":"Chemical 11"},"km",null,{"$f":"IF(Inputs!E141=\"\",\"\",Inputs!E141)","v":""},{"$f":"IF(Inputs!F141=\"\",\"\",Inputs!F141)","v":""},{"$f":"IF(Inputs!G141=\"\",\"\",Inputs!G141)","v":""},{"$f":"IF(Inputs!H141=\"\",\"\",Inputs!H141)","v":""},{"$f":"IF(Inputs!I141=\"\",\"\",Inputs!I141)","v":""},{"$f":"IF(Inputs!J141=\"\",\"\",Inputs!J141)","v":""},{"$f":"IF(Inputs!K141=\"\",\"\",Inputs!K141)","v":""},{"$f":"IF(Inputs!L141=\"\",\"\",Inputs!L141)","v":""},{"$f":"IF(Inputs!M141=\"\",\"\",Inputs!M141)","v":""},{"$f":"IF(Inputs!N141=\"\",\"\",Inputs!N141)","v":""},{"$f":"IF(Inputs!O141=\"\",\"\",Inputs!O141)","v":""},null,{"$f":"Inputs!U141","v":false}]
[null,null,null,{"$f":"Inputs!C121","v":"Chemical 12"},"km",null,{"$f":"IF(Inputs!E142=\"\",\"\",Inputs!E142)","v":""},{"$f":"IF(Inputs!F142=\"\",\"\",Inputs!F142)","v":""},{"$f":"IF(Inputs!G142=\"\",\"\",Inputs!G142)","v":""},{"$f":"IF(Inputs!H142=\"\",\"\",Inputs!H142)","v":""},{"$f":"IF(Inputs!I142=\"\",\"\",Inputs!I142)","v":""},{"$f":"IF(Inputs!J142=\"\",\"\",Inputs!J142)","v":""},{"$f":"IF(Inputs!K142=\"\",\"\",Inputs!K142)","v":""},{"$f":"IF(Inputs!L142=\"\",\"\",Inputs!L142)","v":""},{"$f":"IF(Inputs!M142=\"\",\"\",Inputs!M142)","v":""},{"$f":"IF(Inputs!N142=\"\",\"\",Inputs!N142)","v":""},{"$f":"IF(Inputs!O142=\"\",\"\",Inputs!O142)","v":""},null,{"$f":"Inputs!U142","v":false}]
[null,null,null,{"$f":"Inputs!C122","v":"Chemical 13"},"km",null,{"$f":"IF(Inputs!E143=\"\",\"\",Inputs!E143)","v":""},{"$f":"IF(Inputs!F143=\"\",\"\",Inputs!F143)","v":""},{"$f":"IF(Inputs!G143=\"\",\"\",Inputs!G143)","v":""},{"$f":"IF(Inputs!H143=\"\",\"\",Inputs!H143)","v":""},{"$f":"IF(Inputs!I143=\"\",\"\",Inputs!I143)","v":""},{"$f":"IF(Inputs!J143=\"\",\"\",Inputs!J143)","v":""},{"$f":"IF(Inputs!K143=\"\",\"\",Inputs!K143)","v":""},{"$f":"IF(Inputs!L143=\"\",\"\",Inputs!L143)","v":""},{"$f":"IF(Inputs!M143=\"\",\"\",Inputs!M143)","v":""},{"$f":"IF(Inputs!N143=\"\",\"\",Inputs!N143)","v":""},{"$f":"IF(Inputs!O143=\"\",\"\",Inputs!O143)","v":""},null,{"$f":"Inputs!U143","v":false}]
[null,null,null,{"$f":"Inputs!C123","v":"Chemical 14"},"km",null,{"$f":"IF(Inputs!E144=\"\",\"\",Inputs!E144)","v":""},{"$f":"IF(Inputs!F144=\"\",\"\",Inputs!F144)","v":""},{"$f":"IF(Inputs!G144=\"\",\"\",Inputs!G144)","v":""},{"$f":"IF(Inputs!H144=\"\",\"\",Inputs!H144)","v":""},{"$f":"IF(Inputs!I144=\"\",\"\",Inputs!I144)","v":""},{"$f":"IF(Inputs!J144=\"\",\"\",Inputs!J144)","v":""},{"$f":"IF(Inputs!K144=\"\",\"\",Inputs!K144)","v":""},{"$f":"IF(Inputs!L144=\"\",\"\",Inputs!L144)","v":""},{"$f":"IF(Inputs!M144=\"\",\"\",Inputs!M144)","v":""},{"$f":"IF(Inputs!N144=\"\",\"\",Inputs!N144)","v":""},{"$f":"IF(Inputs!O144=\"\",\"\",Inputs!O144)","v":""},null,{"$f":"Inputs!U144","v":false}]
[null,null,null,{"$f":"Inputs!C124","v":"Chemical 15"},"km",null,{"$f":"IF(Inputs!E145=\"\",\"\",Inputs!E145)","v":""},{"$f":"IF(Inputs!F145=\"\",\"\",Inputs!F145)","v":""},{"$f":"IF(Inputs!G145=\"\",\"\",Inputs!G145)","v":""},{"$f":"IF(Inputs!H145=\"\",\"\",Inputs!H145)","v":""},{"$f":"IF(Inputs!I145=\"\",\"\",Inputs!I145)","v":""},{"$f":"IF(Inputs!J145=\"\",\"\",Inputs!J145)","v":""},{"$f":"IF(Inputs!K145=\"\",\"\",Inputs!K145)","v":""},{"$f":"IF(Inputs!L145=\"\",\"\",Inputs!L145)","v":""},{"$f":"IF(Inputs!M145=\"\",\"\",Inputs!M145)","v":""},{"$f":"IF(Inputs!N145=\"\",\"\",Inputs!N145)","v":""},{"$f":"IF(Inputs!O145=\"\",\"\",Inputs!O145)","v":""},null,{"$f":"Inputs!U145","v":false}]
[null,null,null,{"$f":"Inputs!C125","v":"Chemical 16"},"km",null,{"$f":"IF(Inputs!E146=\"\",\"\",Inputs!E146)","v":""},{"$f":"IF(Inputs!F146=\"\",\"\",Inputs!F146)","v":""},{"$f":"IF(Inputs!G146=\"\",\"\",Inputs!G146)","v":""},{"$f":"IF(Inputs!H146=\"\",\"\",Inputs!H146)","v":""},{"$f":"IF(Inputs!I146=\"\",\"\",Inputs!I146)","v":""},{"$f":"IF(Inputs!J146=\"\",\"\",Inputs!J146)","v":""},{"$f":"IF(Inputs!K146=\"\",\"\",Inputs!K146)","v":""},{"$f":"IF(Inputs!L146=\"\",\"\",Inputs!L146)","v":""},{"$f":"IF(Inputs!M146=\"\",\"\",Inputs!M146)","v":""},{"$f":"IF(Inputs!N146=\"\",\"\",Inputs!N146)","v":""},{"$f":"IF(Inputs!O146=\"\",\"\",Inputs!O146)","v":""},null,{"$f":"Inputs!U146","v":false}]
[null,null,null,{"$f":"Inputs!C126","v":"Chemical 17"},"km",null,{"$f":"IF(Inputs!E147=\"\",\"\",Inputs!E147)","v":""},{"$f":"IF(Inputs!F147=\"\",\"\",Inputs!F147)","v":""},{"$f":"IF(Inputs!G147=\"\",\"\",Inputs!G147)","v":""},{"$f":"IF(Inputs!H147=\"\",\"\",Inputs!H147)","v":""},{"$f":"IF(Inputs!I147=\"\",\"\",Inputs!I147)","v":""},{"$f":"IF(Inputs!J147=\"\",\"\",Inputs!J147)","v":""},{"$f":"IF(Inputs!K147=\"\",\"\",Inputs!K147)","v":""},{"$f":"IF(Inputs!L147=\"\",\"\",Inputs!L147)","v":""},{"$f":"IF(Inputs!M147=\"\",\"\",Inputs!M147)","v":""},{"$f":"IF(Inputs!N147=\"\",\"\",Inputs!N147)","v":""},{"$f":"IF(Inputs!O147=\"\",\"\",Inputs!O147)","v":""},null,{"$f":"Inputs!U147","v":false}]
[null,null,null,{"$f":"Inputs!C127","v":"Chemical 18"},"km",null,{"$f":"IF(Inputs!E148=\"\",\"\",Inputs!E148)","v":""},{"$f":"IF(Inputs!F148=\"\",\"\",Inputs!F148)","v":""},{"$f":"IF(Inputs!G148=\"\",\"\",Inputs!G148)","v":""},{"$f":"IF(Inputs!H148=\"\",\"\",Inputs!H148)","v":""},{"$f":"IF(Inputs!I148=\"\",\"\",Inputs!I148)","v":""},{"$f":"IF(Inputs!J148=\"\",\"\",Inputs!J148)","v":""},{"$f":"IF(Inputs!K148=\"\",\"\",Inputs!K148)","v":""},{"$f":"IF(Inputs!L148=\"\",\"\",Inputs!L148)","v":""},{"$f":"IF(Inputs!M148=\"\",\"\",Inputs!M148)","v":""},{"$f":"IF(Inputs!N148=\"\",\"\",Inputs!N148)","v":""},{"$f":"IF(Inputs!O148=\"\",\"\",Inputs!O148)","v":""},null,{"$f":"Inputs!U148","v":false}]
[null,null,null,{"$f":"Inputs!C128","v":"Chemical 19"},"km",null,{"$f":"IF(Inputs!E149=\"\",\"\",Inputs!E149)","v":""},{"$f":"IF(Inputs!F149=\"\",\"\",Inputs!F149)","v":""},{"$f":"IF(Inputs!G149=\"\",\"\",Inputs!G149)","v":""},{"$f":"IF(Inputs!H149=\"\",\"\",Inputs!H149)","v":""},{"$f":"IF(Inputs!I149=\"\",\"\",Inputs!I149)","v":""},{"$f":"IF(Inputs!J149=\"\",\"\",Inputs!J149)","v":""},{"$f":"IF(Inputs!K149=\"\",\"\",Inputs!K149)","v":""},{"$f":"IF(Inputs!L149=\"\",\"\",Inputs!L149)","v":""},{"$f":"IF(Inputs!M149=\"\",\"\",Inputs!M149)","v":""},{"$f":"IF(Inputs!N149=\"\",\"\",Inputs!N149)","v":""},{"$f":"IF(Inputs!O149=\"\",\"\",Inputs!O149)","v":""},null,{"$f":"Inputs!U149","v":false}]
[null,null,null,{"$f":"Inputs!C129","v":"Chemical 20"},"km",null,{"$f":"IF(Inputs!E150=\"\",\"\",Inputs!E150)","v":""},{"$f":"IF(Inputs!F150=\"\",\"\",Inputs!F150)","v":""},{"$f":"IF(Inputs!G150=\"\",\"\",Inputs!G150)","v":""},{"$f":"IF(Inputs!H150=\"\",\"\",Inputs!H150)","v":""},{"$f":"IF(Inputs!I150=\"\",\"\",Inputs!I150)","v":""},{"$f":"IF(Inputs!J150=\"\",\"\",Inputs!J150)","v":""},{"$f":"IF(Inputs!K150=\"\",\"\",Inputs!K150)","v":""},{"$f":"IF(Inputs!L150=\"\",\"\",Inputs!L150)","v":""},{"$f":"IF(Inputs!M150=\"\",\"\",Inputs!M150)","v":""},{"$f":"IF(Inputs!N150=\"\",\"\",Inputs!N150)","v":""},{"$f":"IF(Inputs!O150=\"\",\"\",Inputs!O150)","v":""},null,{"$f":"Inputs!U150","v":false}]
[null,null,"Dtrain","Train Distance from Supplier to Site (ROUND TRIP)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true}]
[null,null,null,{"$f":"Inputs!C110","v":"Chemical 1"},"km",null,{"$f":"IF(Inputs!E152=\"\",\"\",Inputs!E152)","v":""},{"$f":"IF(Inputs!F152=\"\",\"\",Inputs!F152)","v":""},{"$f":"IF(Inputs!G152=\"\",\"\",Inputs!G152)","v":""},{"$f":"IF(Inputs!H152=\"\",\"\",Inputs!H152)","v":""},{"$f":"IF(Inputs!I152=\"\",\"\",Inputs!I152)","v":""},{"$f":"IF(Inputs!J152=\"\",\"\",Inputs!J152)","v":""},{"$f":"IF(Inputs!K152=\"\",\"\",Inputs!K152)","v":""},{"$f":"IF(Inputs!L152=\"\",\"\",Inputs!L152)","v":""},{"$f":"IF(Inputs!M152=\"\",\"\",Inputs!M152)","v":""},{"$f":"IF(Inputs!N152=\"\",\"\",Inputs!N152)","v":""},{"$f":"IF(Inputs!O152=\"\",\"\",Inputs!O152)","v":""},null,{"$f":"Inputs!U152","v":false}]
[null,null,null,{"$f":"Inputs!C111","v":"Chemical 2"},"km",null,{"$f":"IF(Inputs!E153=\"\",\"\",Inputs!E153)","v":""},{"$f":"IF(Inputs!F153=\"\",\"\",Inputs!F153)","v":""},{"$f":"IF(Inputs!G153=\"\",\"\",Inputs!G153)","v":""},{"$f":"IF(Inputs!H153=\"\",\"\",Inputs!H153)","v":""},{"$f":"IF(Inputs!I153=\"\",\"\",Inputs!I153)","v":""},{"$f":"IF(Inputs!J153=\"\",\"\",Inputs!J153)","v":""},{"$f":"IF(Inputs!K153=\"\",\"\",Inputs!K153)","v":""},{"$f":"IF(Inputs!L153=\"\",\"\",Inputs!L153)","v":""},{"$f":"IF(Inputs!M153=\"\",\"\",Inputs!M153)","v":""},{"$f":"IF(Inputs!N153=\"\",\"\",Inputs!N153)","v":""},{"$f":"IF(Inputs!O153=\"\",\"\",Inputs!O153)","v":""},null,{"$f":"Inputs!U153","v":false}]
[null,null,null,{"$f":"Inputs!C112","v":"Chemical 3"},"km",null,{"$f":"IF(Inputs!E154=\"\",\"\",Inputs!E154)","v":""},{"$f":"IF(Inputs!F154=\"\",\"\",Inputs!F154)","v":""},{"$f":"IF(Inputs!G154=\"\",\"\",Inputs!G154)","v":""},{"$f":"IF(Inputs!H154=\"\",\"\",Inputs!H154)","v":""},{"$f":"IF(Inputs!I154=\"\",\"\",Inputs!I154)","v":""},{"$f":"IF(Inputs!J154=\"\",\"\",Inputs!J154)","v":""},{"$f":"IF(Inputs!K154=\"\",\"\",Inputs!K154)","v":""},{"$f":"IF(Inputs!L154=\"\",\"\",Inputs!L154)","v":""},{"$f":"IF(Inputs!M154=\"\",\"\",Inputs!M154)","v":""},{"$f":"IF(Inputs!N154=\"\",\"\",Inputs!N154)","v":""},{"$f":"IF(Inputs!O154=\"\",\"\",Inputs!O154)","v":""},null,{"$f":"Inputs!U154","v":false}]
[null,null,null,{"$f":"Inputs!C113","v":"Chemical 4"},"km",null,{"$f":"IF(Inputs!E155=\"\",\"\",Inputs!E155)","v":""},{"$f":"IF(Inputs!F155=\"\",\"\",Inputs!F155)","v":""},{"$f":"IF(Inputs!G155=\"\",\"\",Inputs!G155)","v":""},{"$f":"IF(Inputs!H155=\"\",\"\",Inputs!H155)","v":""},{"$f":"IF(Inputs!I155=\"\",\"\",Inputs!I155)","v":""},{"$f":"IF(Inputs!J155=\"\",\"\",Inputs!J155)","v":""},{"$f":"IF(Inputs!K155=\"\",\"\",Inputs!K155)","v":""},{"$f":"IF(Inputs!L155=\"\",\"\",Inputs!L155)","v":""},{"$f":"IF(Inputs!M155=\"\",\"\",Inputs!M155)","v":""},{"$f":"IF(Inputs!N155=\"\",\"\",Inputs!N155)","v":""},{"$f":"IF(Inputs!O155=\"\",\"\",Inputs!O155)","v":""},null,{"$f":"Inputs!U155","v":false}]
[null,null,null,{"$f":"Inputs!C114","v":"Chemical 5"},"km",null,{"$f":"IF(Inputs!E156=\"\",\"\",Inputs!E156)","v":""},{"$f":"IF(Inputs!F156=\"\",\"\",Inputs!F156)","v":""},{"$f":"IF(Inputs!G156=\"\",\"\",Inputs!G156)","v":""},{"$f":"IF(Inputs!H156=\"\",\"\",Inputs!H156)","v":""},{"$f":"IF(Inputs!I156=\"\",\"\",Inputs!I156)","v":""},{"$f":"IF(Inputs!J156=\"\",\"\",Inputs!J156)","v":""},{"$f":"IF(Inputs!K156=\"\",\"\",Inputs!K156)","v":""},{"$f":"IF(Inputs!L156=\"\",\"\",Inputs!L156)","v":""},{"$f":"IF(Inputs!M156=\"\",\"\",Inputs!M156)","v":""},{"$f":"IF(Inputs!N156=\"\",\"\",Inputs!N156)","v":""},{"$f":"IF(Inputs!O156=\"\",\"\",Inputs!O156)","v":""},null,{"$f":"Inputs!U156","v":false}]
[null,null,null,{"$f":"Inputs!C115","v":"Chemical 6"},"km",null,{"$f":"IF(Inputs!E157=\"\",\"\",Inputs!E157)","v":""},{"$f":"IF(Inputs!F157=\"\",\"\",Inputs!F157)","v":""},{"$f":"IF(Inputs!G157=\"\",\"\",Inputs!G157)","v":""},{"$f":"IF(Inputs!H157=\"\",\"\",Inputs!H157)","v":""},{"$f":"IF(Inputs!I157=\"\",\"\",Inputs!I157)","v":""},{"$f":"IF(Inputs!J157=\"\",\"\",Inputs!J157)","v":""},{"$f":"IF(Inputs!K157=\"\",\"\",Inputs!K157)","v":""},{"$f":"IF(Inputs!L157=\"\",\"\",Inputs!L157)","v":""},{"$f":"IF(Inputs!M157=\"\",\"\",Inputs!M157)","v":""},{"$f":"IF(Inputs!N157=\"\",\"\",Inputs!N157)","v":""},{"$f":"IF(Inputs!O157=\"\",\"\",Inputs!O157)","v":""},null,{"$f":"Inputs!U157","v":false}]
[null,null,null,{"$f":"Inputs!C116","v":"Chemical 7"},"km",null,{"$f":"IF(Inputs!E158=\"\",\"\",Inputs!E158)","v":""},{"$f":"IF(Inputs!F158=\"\",\"\",Inputs!F158)","v":""},{"$f":"IF(Inputs!G158=\"\",\"\",Inputs!G158)","v":""},{"$f":"IF(Inputs!H158=\"\",\"\",Inputs!H158)","v":""},{"$f":"IF(Inputs!I158=\"\",\"\",Inputs!I158)","v":""},{"$f":"IF(Inputs!J158=\"\",\"\",Inputs!J158)","v":""},{"$f":"IF(Inputs!K158=\"\",\"\",Inputs!K158)","v":""},{"$f":"IF(Inputs!L158=\"\",\"\",Inputs!L158)","v":""},{"$f":"IF(Inputs!M158=\"\",\"\",Inputs!M158)","v":""},{"$f":"IF(Inputs!N158=\"\",\"\",Inputs!N158)","v":""},{"$f":"IF(Inputs!O158=\"\",\"\",Inputs!O158)","v":""},null,{"$f":"Inputs!U158","v":false}]
[null,null,null,{"$f":"Inputs!C117","v":"Chemical 8"},"km",null,{"$f":"IF(Inputs!E159=\"\",\"\",Inputs!E159)","v":""},{"$f":"IF(Inputs!F159=\"\",\"\",Inputs!F159)","v":""},{"$f":"IF(Inputs!G159=\"\",\"\",Inputs!G159)","v":""},{"$f":"IF(Inputs!H159=\"\",\"\",Inputs!H159)","v":""},{"$f":"IF(Inputs!I159=\"\",\"\",Inputs!I159)","v":""},{"$f":"IF(Inputs!J159=\"\",\"\",Inputs!J159)","v":""},{"$f":"IF(Inputs!K159=\"\",\"\",Inputs!K159)","v":""},{"$f":"IF(Inputs!L159=\"\",\"\",Inputs!L159)","v":""},{"$f":"IF(Inputs!M159=\"\",\"\",Inputs!M159)","v":""},{"$f":"IF(Inputs!N159=\"\",\"\",Inputs!N159)","v":""},{"$f":"IF(Inputs!O159=\"\",\"\",Inputs!O159)","v":""},null,{"$f":"Inputs!U159","v":false}]
[null,null,null,{"$f":"Inputs!C118","v":"Chemical 9"},"km",null,{"$f":"IF(Inputs!E160=\"\",\"\",Inputs!E160)","v":""},{"$f":"IF(Inputs!F160=\"\",\"\",Inputs!F160)","v":""},{"$f":"IF(Inputs!G160=\"\",\"\",Inputs!G160)","v":""},{"$f":"IF(Inputs!H160=\"\",\"\",Inputs!H160)","v":""},{"$f":"IF(Inputs!I160=\"\",\"\",Inputs!I160)","v":""},{"$f":"IF(Inputs!J160=\"\",\"\",Inputs!J160)","v":""},{"$f":"IF(Inputs!K160=\"\",\"\",Inputs!K160)","v":""},{"$f":"IF(Inputs!L160=\"\",\"\",Inputs!L160)","v":""},{"$f":"IF(Inputs!M160=\"\",\"\",Inputs!M160)","v":""},{"$f":"IF(Inputs!N160=\"\",\"\",Inputs!N160)","v":""},{"$f":"IF(Inputs!O160=\"\",\"\",Inputs!O160)","v":""},null,{"$f":"Inputs!U160","v":false}]
[null,null,null,{"$f":"Inputs!C119","v":"Chemical 10"},"km",null,{"$f":"IF(Inputs!E161=\"\",\"\",Inputs!E161)","v":""},{"$f":"IF(Inputs!F161=\"\",\"\",Inputs!F161)","v":""},{"$f":"IF(Inputs!G161=\"\",\"\",Inputs!G161)","v":""},{"$f":"IF(Inputs!H161=\"\",\"\",Inputs!H161)","v":""},{"$f":"IF(Inputs!I161=\"\",\"\",Inputs!I161)","v":""},{"$f":"IF(Inputs!J161=\"\",\"\",Inputs!J161)","v":""},{"$f":"IF(Inputs!K161=\"\",\"\",Inputs!K161)","v":""},{"$f":"IF(Inputs!L161=\"\",\"\",Inputs!L161)","v":""},{"$f":"IF(Inputs!M161=\"\",\"\",Inputs!M161)","v":""},{"$f":"IF(Inputs!N161=\"\",\"\",Inputs!N161)","v":""},{"$f":"IF(Inputs!O161=\"\",\"\",Inputs!O161)","v":""},null,{"$f":"Inputs!U161","v":false}]
[null,null,null,{"$f":"Inputs!C120","v":"Chemical 11"},"km",null,{"$f":"IF(Inputs!E162=\"\",\"\",Inputs!E162)","v":""},{"$f":"IF(Inputs!F162=\"\",\"\",Inputs!F162)","v":""},{"$f":"IF(Inputs!G162=\"\",\"\",Inputs!G162)","v":""},{"$f":"IF(Inputs!H162=\"\",\"\",Inputs!H162)","v":""},{"$f":"IF(Inputs!I162=\"\",\"\",Inputs!I162)","v":""},{"$f":"IF(Inputs!J162=\"\",\"\",Inputs!J162)","v":""},{"$f":"IF(Inputs!K162=\"\",\"\",Inputs!K162)","v":""},{"$f":"IF(Inputs!L162=\"\",\"\",Inputs!L162)","v":""},{"$f":"IF(Inputs!M162=\"\",\"\",Inputs!M162)","v":""},{"$f":"IF(Inputs!N162=\"\",\"\",Inputs!N162)","v":""},{"$f":"IF(Inputs!O162=\"\",\"\",Inputs!O162)","v":""},null,{"$f":"Inputs!U162","v":false}]
[null,null,null,{"$f":"Inputs!C121","v":"Chemical 12"},"km",null,{"$f":"IF(Inputs!E163=\"\",\"\",Inputs!E163)","v":""},{"$f":"IF(Inputs!F163=\"\",\"\",Inputs!F163)","v":""},{"$f":"IF(Inputs!G163=\"\",\"\",Inputs!G163)","v":""},{"$f":"IF(Inputs!H163=\"\",\"\",Inputs!H163)","v":""},{"$f":"IF(Inputs!I163=\"\",\"\",Inputs!I163)","v":""},{"$f":"IF(Inputs!J163=\"\",\"\",Inputs!J163)","v":""},{"$f":"IF(Inputs!K163=\"\",\"\",Inputs!K163)","v":""},{"$f":"IF(Inputs!L163=\"\",\"\",Inputs!L163)","v":""},{"$f":"IF(Inputs!M163=\"\",\"\",Inputs!M163)","v":""},{"$f":"IF(Inputs!N163=\"\",\"\",Inputs!N163)","v":""},{"$f":"IF(Inputs!O163=\"\",\"\",Inputs!O163)","v":""},null,{"$f":"Inputs!U163","v":false}]
[null,null,null,{"$f":"Inputs!C122","v":"Chemical 13"},"km",null,{"$f":"IF(Inputs!E164=\"\",\"\",Inputs!E164)","v":""},{"$f":"IF(Inputs!F164=\"\",\"\",Inputs!F164)","v":""},{"$f":"IF(Inputs!G164=\"\",\"\",Inputs!G164)","v":""},{"$f":"IF(Inputs!H164=\"\",\"\",Inputs!H164)","v":""},{"$f":"IF(Inputs!I164=\"\",\"\",Inputs!I164)","v":""},{"$f":"IF(Inputs!J164=\"\",\"\",Inputs!J164)","v":""},{"$f":"IF(Inputs!K164=\"\",\"\",Inputs!K164)","v":""},{"$f":"IF(Inputs!L164=\"\",\"\",Inputs!L164)","v":""},{"$f":"IF(Inputs!M164=\"\",\"\",Inputs!M164)","v":""},{"$f":"IF(Inputs!N164=\"\",\"\",Inputs!N164)","v":""},{"$f":"IF(Inputs!O164=\"\",\"\",Inputs!O164)","v":""},null,{"$f":"Inputs!U164","v":false}]
[null,null,null,{"$f":"Inputs!C123","v":"Chemical 14"},"km",null,{"$f":"IF(Inputs!E165=\"\",\"\",Inputs!E165)","v":""},{"$f":"IF(Inputs!F165=\"\",\"\",Inputs!F165)","v":""},{"$f":"IF(Inputs!G165=\"\",\"\",Inputs!G165)","v":""},{"$f":"IF(Inputs!H165=\"\",\"\",Inputs!H165)","v":""},{"$f":"IF(Inputs!I165=\"\",\"\",Inputs!I165)","v":""},{"$f":"IF(Inputs!J165=\"\",\"\",Inputs!J165)","v":""},{"$f":"IF(Inputs!K165=\"\",\"\",Inputs!K165)","v":""},{"$f":"IF(Inputs!L165=\"\",\"\",Inputs!L165)","v":""},{"$f":"IF(Inputs!M165=\"\",\"\",Inputs!M165)","v":""},{"$f":"IF(Inputs!N165=\"\",\"\",Inputs!N165)","v":""},{"$f":"IF(Inputs!O165=\"\",\"\",Inputs!O165)","v":""},null,{"$f":"Inputs!U165","v":false}]
[null,null,null,{"$f":"Inputs!C124","v":"Chemical 15"},"km",null,{"$f":"IF(Inputs!E166=\"\",\"\",Inputs!E166)","v":""},{"$f":"IF(Inputs!F166=\"\",\"\",Inputs!F166)","v":""},{"$f":"IF(Inputs!G166=\"\",\"\",Inputs!G166)","v":""},{"$f":"IF(Inputs!H166=\"\",\"\",Inputs!H166)","v":""},{"$f":"IF(Inputs!I166=\"\",\"\",Inputs!I166)","v":""},{"$f":"IF(Inputs!J166=\"\",\"\",Inputs!J166)","v":""},{"$f":"IF(Inputs!K166=\"\",\"\",Inputs!K166)","v":""},{"$f":"IF(Inputs!L166=\"\",\"\",Inputs!L166)","v":""},{"$f":"IF(Inputs!M166=\"\",\"\",Inputs!M166)","v":""},{"$f":"IF(Inputs!N166=\"\",\"\",Inputs!N166)","v":""},{"$f":"IF(Inputs!O166=\"\",\"\",Inputs!O166)","v":""},null,{"$f":"Inputs!U166","v":false}]
[null,null,null,{"$f":"Inputs!C125","v":"Chemical 16"},"km",null,{"$f":"IF(Inputs!E167=\"\",\"\",Inputs!E167)","v":""},{"$f":"IF(Inputs!F167=\"\",\"\",Inputs!F167)","v":""},{"$f":"IF(Inputs!G167=\"\",\"\",Inputs!G167)","v":""},{"$f":"IF(Inputs!H167=\"\",\"\",Inputs!H167)","v":""},{"$f":"IF(Inputs!I167=\"\",\"\",Inputs!I167)","v":""},{"$f":"IF(Inputs!J167=\"\",\"\",Inputs!J167)","v":""},{"$f":"IF(Inputs!K167=\"\",\"\",Inputs!K167)","v":""},{"$f":"IF(Inputs!L167=\"\",\"\",Inputs!L167)","v":""},{"$f":"IF(Inputs!M167=\"\",\"\",Inputs!M167)","v":""},{"$f":"IF(Inputs!N167=\"\",\"\",Inputs!N167)","v":""},{"$f":"IF(Inputs!O167=\"\",\"\",Inputs!O167)","v":""},null,{"$f":"Inputs!U167","v":false}]
[null,null,null,{"$f":"Inputs!C126","v":"Chemical 17"},"km",null,{"$f":"IF(Inputs!E168=\"\",\"\",Inputs!E168)","v":""},{"$f":"IF(Inputs!F168=\"\",\"\",Inputs!F168)","v":""},{"$f":"IF(Inputs!G168=\"\",\"\",Inputs!G168)","v":""},{"$f":"IF(Inputs!H168=\"\",\"\",Inputs!H168)","v":""},{"$f":"IF(Inputs!I168=\"\",\"\",Inputs!I168)","v":""},{"$f":"IF(Inputs!J168=\"\",\"\",Inputs!J168)","v":""},{"$f":"IF(Inputs!K168=\"\",\"\",Inputs!K168)","v":""},{"$f":"IF(Inputs!L168=\"\",\"\",Inputs!L168)","v":""},{"$f":"IF(Inputs!M168=\"\",\"\",Inputs!M168)","v":""},{"$f":"IF(Inputs!N168=\"\",\"\",Inputs!N168)","v":""},{"$f":"IF(Inputs!O168=\"\",\"\",Inputs!O168)","v":""},null,{"$f":"Inputs!U168","v":false}]
[null,null,null,{"$f":"Inputs!C127","v":"Chemical 18"},"km",null,{"$f":"IF(Inputs!E169=\"\",\"\",Inputs!E169)","v":""},{"$f":"IF(Inputs!F169=\"\",\"\",Inputs!F169)","v":""},{"$f":"IF(Inputs!G169=\"\",\"\",Inputs!G169)","v":""},{"$f":"IF(Inputs!H169=\"\",\"\",Inputs!H169)","v":""},{"$f":"IF(Inputs!I169=\"\",\"\",Inputs!I169)","v":""},{"$f":"IF(Inputs!J169=\"\",\"\",Inputs!J169)","v":""},{"$f":"IF(Inputs!K169=\"\",\"\",Inputs!K169)","v":""},{"$f":"IF(Inputs!L169=\"\",\"\",Inputs!L169)","v":""},{"$f":"IF(Inputs!M169=\"\",\"\",Inputs!M169)","v":""},{"$f":"IF(Inputs!N169=\"\",\"\",Inputs!N169)","v":""},{"$f":"IF(Inputs!O169=\"\",\"\",Inputs!O169)","v":""},null,{"$f":"Inputs!U169","v":false}]
[null,null,null,{"$f":"Inputs!C128","v":"Chemical 19"},"km",null,{"$f":"IF(Inputs!E170=\"\",\"\",Inputs!E170)","v":""},{"$f":"IF(Inputs!F170=\"\",\"\",Inputs!F170)","v":""},{"$f":"IF(Inputs!G170=\"\",\"\",Inputs!G170)","v":""},{"$f":"IF(Inputs!H170=\"\",\"\",Inputs!H170)","v":""},{"$f":"IF(Inputs!I170=\"\",\"\",Inputs!I170)","v":""},{"$f":"IF(Inputs!J170=\"\",\"\",Inputs!J170)","v":""},{"$f":"IF(Inputs!K170=\"\",\"\",Inputs!K170)","v":""},{"$f":"IF(Inputs!L170=\"\",\"\",Inputs!L170)","v":""},{"$f":"IF(Inputs!M170=\"\",\"\",Inputs!M170)","v":""},{"$f":"IF(Inputs!N170=\"\",\"\",Inputs!N170)","v":""},{"$f":"IF(Inputs!O170=\"\",\"\",Inputs!O170)","v":""},null,{"$f":"Inputs!U170","v":false}]
[null,null,null,{"$f":"Inputs!C129","v":"Chemical 20"},"km",null,{"$f":"IF(Inputs!E171=\"\",\"\",Inputs!E171)","v":""},{"$f":"IF(Inputs!F171=\"\",\"\",Inputs!F171)","v":""},{"$f":"IF(Inputs!G171=\"\",\"\",Inputs!G171)","v":""},{"$f":"IF(Inputs!H171=\"\",\"\",Inputs!H171)","v":""},{"$f":"IF(Inputs!I171=\"\",\"\",Inputs!I171)","v":""},{"$f":"IF(Inputs!J171=\"\",\"\",Inputs!J171)","v":""},{"$f":"IF(Inputs!K171=\"\",\"\",Inputs!K171)","v":""},{"$f":"IF(Inputs!L171=\"\",\"\",Inputs!L171)","v":""},{"$f":"IF(Inputs!M171=\"\",\"\",Inputs!M171)","v":""},{"$f":"IF(Inputs!N171=\"\",\"\",Inputs!N171)","v":""},{"$f":"IF(Inputs!O171=\"\",\"\",Inputs!O171)","v":""},null,{"$f":"Inputs!U171","v":false}]
[null,null,"Dsea","Sea Freight Distance from Supplier to Site (ROUND TRIP)",null,null,"\n",null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true}]
[null,null,null,{"$f":"Inputs!C110","v":"Chemical 1"},"km",null,{"$f":"IF(Inputs!E173=\"\",\"\",Inputs!E173)","v":""},{"$f":"IF(Inputs!F173=\"\",\"\",Inputs!F173)","v":""},{"$f":"IF(Inputs!G173=\"\",\"\",Inputs!G173)","v":""},{"$f":"IF(Inputs!H173=\"\",\"\",Inputs!H173)","v":""},{"$f":"IF(Inputs!I173=\"\",\"\",Inputs!I173)","v":""},{"$f":"IF(Inputs!J173=\"\",\"\",Inputs!J173)","v":""},{"$f":"IF(Inputs!K173=\"\",\"\",Inputs!K173)","v":""},{"$f":"IF(Inputs!L173=\"\",\"\",Inputs!L173)","v":""},{"$f":"IF(Inputs!M173=\"\",\"\",Inputs!M173)","v":""},{"$f":"IF(Inputs!N173=\"\",\"\",Inputs!N173)","v":""},{"$f":"IF(Inputs!O173=\"\",\"\",Inputs!O173)","v":""},null,{"$f":"Inputs!U173","v":false}]
[null,null,null,{"$f":"Inputs!C111","v":"Chemical 2"},"km",null,{"$f":"IF(Inputs!E174=\"\",\"\",Inputs!E174)","v":""},{"$f":"IF(Inputs!F174=\"\",\"\",Inputs!F174)","v":""},{"$f":"IF(Inputs!G174=\"\",\"\",Inputs!G174)","v":""},{"$f":"IF(Inputs!H174=\"\",\"\",Inputs!H174)","v":""},{"$f":"IF(Inputs!I174=\"\",\"\",Inputs!I174)","v":""},{"$f":"IF(Inputs!J174=\"\",\"\",Inputs!J174)","v":""},{"$f":"IF(Inputs!K174=\"\",\"\",Inputs!K174)","v":""},{"$f":"IF(Inputs!L174=\"\",\"\",Inputs!L174)","v":""},{"$f":"IF(Inputs!M174=\"\",\"\",Inputs!M174)","v":""},{"$f":"IF(Inputs!N174=\"\",\"\",Inputs!N174)","v":""},{"$f":"IF(Inputs!O174=\"\",\"\",Inputs!O174)","v":""},null,{"$f":"Inputs!U174","v":false}]
[null,null,null,{"$f":"Inputs!C112","v":"Chemical 3"},"km",null,{"$f":"IF(Inputs!E175=\"\",\"\",Inputs!E175)","v":""},{"$f":"IF(Inputs!F175=\"\",\"\",Inputs!F175)","v":""},{"$f":"IF(Inputs!G175=\"\",\"\",Inputs!G175)","v":""},{"$f":"IF(Inputs!H175=\"\",\"\",Inputs!H175)","v":""},{"$f":"IF(Inputs!I175=\"\",\"\",Inputs!I175)","v":""},{"$f":"IF(Inputs!J175=\"\",\"\",Inputs!J175)","v":""},{"$f":"IF(Inputs!K175=\"\",\"\",Inputs!K175)","v":""},{"$f":"IF(Inputs!L175=\"\",\"\",Inputs!L175)","v":""},{"$f":"IF(Inputs!M175=\"\",\"\",Inputs!M175)","v":""},{"$f":"IF(Inputs!N175=\"\",\"\",Inputs!N175)","v":""},{"$f":"IF(Inputs!O175=\"\",\"\",Inputs!O175)","v":""},null,{"$f":"Inputs!U175","v":false}]
[null,null,null,{"$f":"Inputs!C113","v":"Chemical 4"},"km",null,{"$f":"IF(Inputs!E176=\"\",\"\",Inputs!E176)","v":""},{"$f":"IF(Inputs!F176=\"\",\"\",Inputs!F176)","v":""},{"$f":"IF(Inputs!G176=\"\",\"\",Inputs!G176)","v":""},{"$f":"IF(Inputs!H176=\"\",\"\",Inputs!H176)","v":""},{"$f":"IF(Inputs!I176=\"\",\"\",Inputs!I176)","v":""},{"$f":"IF(Inputs!J176=\"\",\"\",Inputs!J176)","v":""},{"$f":"IF(Inputs!K176=\"\",\"\",Inputs!K176)","v":""},{"$f":"IF(Inputs!L176=\"\",\"\",Inputs!L176)","v":""},{"$f":"IF(Inputs!M176=\"\",\"\",Inputs!M176)","v":""},{"$f":"IF(Inputs!N176=\"\",\"\",Inputs!N176)","v":""},{"$f":"IF(Inputs!O176=\"\",\"\",Inputs!O176)","v":""},null,{"$f":"Inputs!U176","v":false}]
[null,null,null,{"$f":"Inputs!C114","v":"Chemical 5"},"km",null,{"$f":"IF(Inputs!E177=\"\",\"\",Inputs!E177)","v":""},{"$f":"IF(Inputs!F177=\"\",\"\",Inputs!F177)","v":""},{"$f":"IF(Inputs!G177=\"\",\"\",Inputs!G177)","v":""},{"$f":"IF(Inputs!H177=\"\",\"\",Inputs!H177)","v":""},{"$f":"IF(Inputs!I177=\"\",\"\",Inputs!I177)","v":""},{"$f":"IF(Inputs!J177=\"\",\"\",Inputs!J177)","v":""},{"$f":"IF(Inputs!K177=\"\",\"\",Inputs!K177)","v":""},{"$f":"IF(Inputs!L177=\"\",\"\",Inputs!L177)","v":""},{"$f":"IF(Inputs!M177=\"\",\"\",Inputs!M177)","v":""},{"$f":"IF(Inputs!N177=\"\",\"\",Inputs!N177)","v":""},{"$f":"IF(Inputs!O177=\"\",\"\",Inputs!O177)","v":""},null,{"$f":"Inputs!U177","v":false}]
[null,null,null,{"$f":"Inputs!C115","v":"Chemical 6"},"km",null,{"$f":"IF(Inputs!E178=\"\",\"\",Inputs!E178)","v":""},{"$f":"IF(Inputs!F178=\"\",\"\",Inputs!F178)","v":""},{"$f":"IF(Inputs!G178=\"\",\"\",Inputs!G178)","v":""},{"$f":"IF(Inputs!H178=\"\",\"\",Inputs!H178)","v":""},{"$f":"IF(Inputs!I178=\"\",\"\",Inputs!I178)","v":""},{"$f":"IF(Inputs!J178=\"\",\"\",Inputs!J178)","v":""},{"$f":"IF(Inputs!K178=\"\",\"\",Inputs!K178)","v":""},{"$f":"IF(Inputs!L178=\"\",\"\",Inputs!L178)","v":""},{"$f":"IF(Inputs!M178=\"\",\"\",Inputs!M178)","v":""},{"$f":"IF(Inputs!N178=\"\",\"\",Inputs!N178)","v":""},{"$f":"IF(Inputs!O178=\"\",\"\",Inputs!O178)","v":""},null,{"$f":"Inputs!U178","v":false}]
[null,null,null,{"$f":"Inputs!C116","v":"Chemical 7"},"km",null,{"$f":"IF(Inputs!E179=\"\",\"\",Inputs!E179)","v":""},{"$f":"IF(Inputs!F179=\"\",\"\",Inputs!F179)","v":""},{"$f":"IF(Inputs!G179=\"\",\"\",Inputs!G179)","v":""},{"$f":"IF(Inputs!H179=\"\",\"\",Inputs!H179)","v":""},{"$f":"IF(Inputs!I179=\"\",\"\",Inputs!I179)","v":""},{"$f":"IF(Inputs!J179=\"\",\"\",Inputs!J179)","v":""},{"$f":"IF(Inputs!K179=\"\",\"\",Inputs!K179)","v":""},{"$f":"IF(Inputs!L179=\"\",\"\",Inputs!L179)","v":""},{"$f":"IF(Inputs!M179=\"\",\"\",Inputs!M179)","v":""},{"$f":"IF(Inputs!N179=\"\",\"\",Inputs!N179)","v":""},{"$f":"IF(Inputs!O179=\"\",\"\",Inputs!O179)","v":""},null,{"$f":"Inputs!U179","v":false}]
[null,null,null,{"$f":"Inputs!C117","v":"Chemical 8"},null,null,{"$f":"IF(Inputs!E180=\"\",\"\",Inputs!E180)","v":""},{"$f":"IF(Inputs!F180=\"\",\"\",Inputs!F180)","v":""},{"$f":"IF(Inputs!G180=\"\",\"\",Inputs!G180)","v":""},{"$f":"IF(Inputs!H180=\"\",\"\",Inputs!H180)","v":""},{"$f":"IF(Inputs!I180=\"\",\"\",Inputs!I180)","v":""},{"$f":"IF(Inputs!J180=\"\",\"\",Inputs!J180)","v":""},{"$f":"IF(Inputs!K180=\"\",\"\",Inputs!K180)","v":""},{"$f":"IF(Inputs!L180=\"\",\"\",Inputs!L180)","v":""},{"$f":"IF(Inputs!M180=\"\",\"\",Inputs!M180)","v":""},{"$f":"IF(Inputs!N180=\"\",\"\",Inputs!N180)","v":""},{"$f":"IF(Inputs!O180=\"\",\"\",Inputs!O180)","v":""},null,{"$f":"Inputs!U180","v":false}]
[null,null,null,{"$f":"Inputs!C118","v":"Chemical 9"},"km",null,{"$f":"IF(Inputs!E181=\"\",\"\",Inputs!E181)","v":""},{"$f":"IF(Inputs!F181=\"\",\"\",Inputs!F181)","v":""},{"$f":"IF(Inputs!G181=\"\",\"\",Inputs!G181)","v":""},{"$f":"IF(Inputs!H181=\"\",\"\",Inputs!H181)","v":""},{"$f":"IF(Inputs!I181=\"\",\"\",Inputs!I181)","v":""},{"$f":"IF(Inputs!J181=\"\",\"\",Inputs!J181)","v":""},{"$f":"IF(Inputs!K181=\"\",\"\",Inputs!K181)","v":""},{"$f":"IF(Inputs!L181=\"\",\"\",Inputs!L181)","v":""},{"$f":"IF(Inputs!M181=\"\",\"\",Inputs!M181)","v":""},{"$f":"IF(Inputs!N181=\"\",\"\",Inputs!N181)","v":""},{"$f":"IF(Inputs!O181=\"\",\"\",Inputs!O181)","v":""},null,{"$f":"Inputs!U181","v":false}]
[null,null,null,{"$f":"Inputs!C119","v":"Chemical 10"},"km",null,{"$f":"IF(Inputs!E182=\"\",\"\",Inputs!E182)","v":""},{"$f":"IF(Inputs!F182=\"\",\"\",Inputs!F182)","v":""},{"$f":"IF(Inputs!G182=\"\",\"\",Inputs!G182)","v":""},{"$f":"IF(Inputs!H182=\"\",\"\",Inputs!H182)","v":""},{"$f":"IF(Inputs!I182=\"\",\"\",Inputs!I182)","v":""},{"$f":"IF(Inputs!J182=\"\",\"\",Inputs!J182)","v":""},{"$f":"IF(Inputs!K182=\"\",\"\",Inputs!K182)","v":""},{"$f":"IF(Inputs!L182=\"\",\"\",Inputs!L182)","v":""},{"$f":"IF(Inputs!M182=\"\",\"\",Inputs!M182)","v":""},{"$f":"IF(Inputs!N182=\"\",\"\",Inputs!N182)","v":""},{"$f":"IF(Inputs!O182=\"\",\"\",Inputs!O182)","v":""},null,{"$f":"Inputs!U182","v":false}]
[null,null,null,{"$f":"Inputs!C120","v":"Chemical 11"},"km",null,{"$f":"IF(Inputs!E183=\"\",\"\",Inputs!E183)","v":""},{"$f":"IF(Inputs!F183=\"\",\"\",Inputs!F183)","v":""},{"$f":"IF(Inputs!G183=\"\",\"\",Inputs!G183)","v":""},{"$f":"IF(Inputs!H183=\"\",\"\",Inputs!H183)","v":""},{"$f":"IF(Inputs!I183=\"\",\"\",Inputs!I183)","v":""},{"$f":"IF(Inputs!J183=\"\",\"\",Inputs!J183)","v":""},{"$f":"IF(Inputs!K183=\"\",\"\",Inputs!K183)","v":""},{"$f":"IF(Inputs!L183=\"\",\"\",Inputs!L183)","v":""},{"$f":"IF(Inputs!M183=\"\",\"\",Inputs!M183)","v":""},{"$f":"IF(Inputs!N183=\"\",\"\",Inputs!N183)","v":""},{"$f":"IF(Inputs!O183=\"\",\"\",Inputs!O183)","v":""},null,{"$f":"Inputs!U183","v":false}]
[null,null,null,{"$f":"Inputs!C121","v":"Chemical 12"},"km",null,{"$f":"IF(Inputs!E184=\"\",\"\",Inputs!E184)","v":""},{"$f":"IF(Inputs!F184=\"\",\"\",Inputs!F184)","v":""},{"$f":"IF(Inputs!G184=\"\",\"\",Inputs!G184)","v":""},{"$f":"IF(Inputs!H184=\"\",\"\",Inputs!H184)","v":""},{"$f":"IF(Inputs!I184=\"\",\"\",Inputs!I184)","v":""},{"$f":"IF(Inputs!J184=\"\",\"\",Inputs!J184)","v":""},{"$f":"IF(Inputs!K184=\"\",\"\",Inputs!K184)","v":""},{"$f":"IF(Inputs!L184=\"\",\"\",Inputs!L184)","v":""},{"$f":"IF(Inputs!M184=\"\",\"\",Inputs!M184)","v":""},{"$f":"IF(Inputs!N184=\"\",\"\",Inputs!N184)","v":""},{"$f":"IF(Inputs!O184=\"\",\"\",Inputs!O184)","v":""},null,{"$f":"Inputs!U184","v":false}]
[null,null,null,{"$f":"Inputs!C122","v":"Chemical 13"},"km",null,{"$f":"IF(Inputs!E185=\"\",\"\",Inputs!E185)","v":""},{"$f":"IF(Inputs!F185=\"\",\"\",Inputs!F185)","v":""},{"$f":"IF(Inputs!G185=\"\",\"\",Inputs!G185)","v":""},{"$f":"IF(Inputs!H185=\"\",\"\",Inputs!H185)","v":""},{"$f":"IF(Inputs!I185=\"\",\"\",Inputs!I185)","v":""},{"$f":"IF(Inputs!J185=\"\",\"\",Inputs!J185)","v":""},{"$f":"IF(Inputs!K185=\"\",\"\",Inputs!K185)","v":""},{"$f":"IF(Inputs!L185=\"\",\"\",Inputs!L185)","v":""},{"$f":"IF(Inputs!M185=\"\",\"\",Inputs!M185)","v":""},{"$f":"IF(Inputs!N185=\"\",\"\",Inputs!N185)","v":""},{"$f":"IF(Inputs!O185=\"\",\"\",Inputs!O185)","v":""},null,{"$f":"Inputs!U185","v":false}]
[null,null,null,{"$f":"Inputs!C123","v":"Chemical 14"},"km",null,{"$f":"IF(Inputs!E186=\"\",\"\",Inputs!E186)","v":""},{"$f":"IF(Inputs!F186=\"\",\"\",Inputs!F186)","v":""},{"$f":"IF(Inputs!G186=\"\",\"\",Inputs!G186)","v":""},{"$f":"IF(Inputs!H186=\"\",\"\",Inputs!H186)","v":""},{"$f":"IF(Inputs!I186=\"\",\"\",Inputs!I186)","v":""},{"$f":"IF(Inputs!J186=\"\",\"\",Inputs!J186)","v":""},{"$f":"IF(Inputs!K186=\"\",\"\",Inputs!K186)","v":""},{"$f":"IF(Inputs!L186=\"\",\"\",Inputs!L186)","v":""},{"$f":"IF(Inputs!M186=\"\",\"\",Inputs!M186)","v":""},{"$f":"IF(Inputs!N186=\"\",\"\",Inputs!N186)","v":""},{"$f":"IF(Inputs!O186=\"\",\"\",Inputs!O186)","v":""},null,{"$f":"Inputs!U186","v":false}]
[null,null,null,{"$f":"Inputs!C124","v":"Chemical 15"},"km",null,{"$f":"IF(Inputs!E187=\"\",\"\",Inputs!E187)","v":""},{"$f":"IF(Inputs!F187=\"\",\"\",Inputs!F187)","v":""},{"$f":"IF(Inputs!G187=\"\",\"\",Inputs!G187)","v":""},{"$f":"IF(Inputs!H187=\"\",\"\",Inputs!H187)","v":""},{"$f":"IF(Inputs!I187=\"\",\"\",Inputs!I187)","v":""},{"$f":"IF(Inputs!J187=\"\",\"\",Inputs!J187)","v":""},{"$f":"IF(Inputs!K187=\"\",\"\",Inputs!K187)","v":""},{"$f":"IF(Inputs!L187=\"\",\"\",Inputs!L187)","v":""},{"$f":"IF(Inputs!M187=\"\",\"\",Inputs!M187)","v":""},{"$f":"IF(Inputs!N187=\"\",\"\",Inputs!N187)","v":""},{"$f":"IF(Inputs!O187=\"\",\"\",Inputs!O187)","v":""},null,{"$f":"Inputs!U187","v":false}]
[null,null,null,{"$f":"Inputs!C125","v":"Chemical 16"},"km",null,{"$f":"IF(Inputs!E188=\"\",\"\",Inputs!E188)","v":""},{"$f":"IF(Inputs!F188=\"\",\"\",Inputs!F188)","v":""},{"$f":"IF(Inputs!G188=\"\",\"\",Inputs!G188)","v":""},{"$f":"IF(Inputs!H188=\"\",\"\",Inputs!H188)","v":""},{"$f":"IF(Inputs!I188=\"\",\"\",Inputs!I188)","v":""},{"$f":"IF(Inputs!J188=\"\",\"\",Inputs!J188)","v":""},{"$f":"IF(Inputs!K188=\"\",\"\",Inputs!K188)","v":""},{"$f":"IF(Inputs!L188=\"\",\"\",Inputs!L188)","v":""},{"$f":"IF(Inputs!M188=\"\",\"\",Inputs!M188)","v":""},{"$f":"IF(Inputs!N188=\"\",\"\",Inputs!N188)","v":""},{"$f":"IF(Inputs!O188=\"\",\"\",Inputs!O188)","v":""},null,{"$f":"Inputs!U188","v":false}]
[null,null,null,{"$f":"Inputs!C126","v":"Chemical 17"},"km",null,{"$f":"IF(Inputs!E189=\"\",\"\",Inputs!E189)","v":""},{"$f":"IF(Inputs!F189=\"\",\"\",Inputs!F189)","v":""},{"$f":"IF(Inputs!G189=\"\",\"\",Inputs!G189)","v":""},{"$f":"IF(Inputs!H189=\"\",\"\",Inputs!H189)","v":""},{"$f":"IF(Inputs!I189=\"\",\"\",Inputs!I189)","v":""},{"$f":"IF(Inputs!J189=\"\",\"\",Inputs!J189)","v":""},{"$f":"IF(Inputs!K189=\"\",\"\",Inputs!K189)","v":""},{"$f":"IF(Inputs!L189=\"\",\"\",Inputs!L189)","v":""},{"$f":"IF(Inputs!M189=\"\",\"\",Inputs!M189)","v":""},{"$f":"IF(Inputs!N189=\"\",\"\",Inputs!N189)","v":""},{"$f":"IF(Inputs!O189=\"\",\"\",Inputs!O189)","v":""},null,{"$f":"Inputs!U189","v":false}]
[null,null,null,{"$f":"Inputs!C127","v":"Chemical 18"},"km",null,{"$f":"IF(Inputs!E190=\"\",\"\",Inputs!E190)","v":""},{"$f":"IF(Inputs!F190=\"\",\"\",Inputs!F190)","v":""},{"$f":"IF(Inputs!G190=\"\",\"\",Inputs!G190)","v":""},{"$f":"IF(Inputs!H190=\"\",\"\",Inputs!H190)","v":""},{"$f":"IF(Inputs!I190=\"\",\"\",Inputs!I190)","v":""},{"$f":"IF(Inputs!J190=\"\",\"\",Inputs!J190)","v":""},{"$f":"IF(Inputs!K190=\"\",\"\",Inputs!K190)","v":""},{"$f":"IF(Inputs!L190=\"\",\"\",Inputs!L190)","v":""},{"$f":"IF(Inputs!M190=\"\",\"\",Inputs!M190)","v":""},{"$f":"IF(Inputs!N190=\"\",\"\",Inputs!N190)","v":""},{"$f":"IF(Inputs!O190=\"\",\"\",Inputs!O190)","v":""},null,{"$f":"Inputs!U190","v":false}]
[null,null,null,{"$f":"Inputs!C128","v":"Chemical 19"},"km",null,{"$f":"IF(Inputs!E191=\"\",\"\",Inputs!E191)","v":""},{"$f":"IF(Inputs!F191=\"\",\"\",Inputs!F191)","v":""},{"$f":"IF(Inputs!G191=\"\",\"\",Inputs!G191)","v":""},{"$f":"IF(Inputs!H191=\"\",\"\",Inputs!H191)","v":""},{"$f":"IF(Inputs!I191=\"\",\"\",Inputs!I191)","v":""},{"$f":"IF(Inputs!J191=\"\",\"\",Inputs!J191)","v":""},{"$f":"IF(Inputs!K191=\"\",\"\",Inputs!K191)","v":""},{"$f":"IF(Inputs!L191=\"\",\"\",Inputs!L191)","v":""},{"$f":"IF(Inputs!M191=\"\",\"\",Inputs!M191)","v":""},{"$f":"IF(Inputs!N191=\"\",\"\",Inputs!N191)","v":""},{"$f":"IF(Inputs!O191=\"\",\"\",Inputs!O191)","v":""},null,{"$f":"Inputs!U191","v":false}]
[null,null,null,{"$f":"Inputs!C129","v":"Chemical 20"},"km",null,{"$f":"IF(Inputs!E192=\"\",\"\",Inputs!E192)","v":""},{"$f":"IF(Inputs!F192=\"\",\"\",Inputs!F192)","v":""},{"$f":"IF(Inputs!G192=\"\",\"\",Inputs!G192)","v":""},{"$f":"IF(Inputs!H192=\"\",\"\",Inputs!H192)","v":""},{"$f":"IF(Inputs!I192=\"\",\"\",Inputs!I192)","v":""},{"$f":"IF(Inputs!J192=\"\",\"\",Inputs!J192)","v":""},{"$f":"IF(Inputs!K192=\"\",\"\",Inputs!K192)","v":""},{"$f":"IF(Inputs!L192=\"\",\"\",Inputs!L192)","v":""},{"$f":"IF(Inputs!M192=\"\",\"\",Inputs!M192)","v":""},{"$f":"IF(Inputs!N192=\"\",\"\",Inputs!N192)","v":""},{"$f":"IF(Inputs!O192=\"\",\"\",Inputs!O192)","v":""},null,{"$f":"Inputs!U192","v":false}]
[null,null," Echem,t","Chemical Transportation Emissions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true}]
[null,null,null,{"$f":"Inputs!C110","v":"Chemical 1"},"tCO2eq/year",null,{"$f":"IF(G83=\"\",0,(G83*$F$77*G31/1000000))+IF(G125=\"\",0,(G125*$F$79*G31/1000000))+IF(G104=\"\",0,(G104*$F$78*G31/1000000))","v":0},{"$f":"IF(H83=\"\",0,(H83*$F$77*H31/1000000))+IF(H125=\"\",0,(H125*$F$79*H31/1000000))+IF(H104=\"\",0,(H104*$F$78*H31/1000000))","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T110","v":false}]
[null,null,null,{"$f":"Inputs!C111","v":"Chemical 2"},"tCO2eq/year",null,{"$f":"IF(G84=\"\",0,(G84*$F$77*G32/1000000))+IF(G126=\"\",0,(G126*$F$79*G32/1000000))+IF(G105=\"\",0,(G105*$F$78*G32/1000000))","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T111","v":false}]
[null,null,null,{"$f":"Inputs!C112","v":"Chemical 3"},"tCO2eq/year",null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T112","v":false}]
[null,null,null,{"$f":"Inputs!C113","v":"Chemical 4"},"tCO2eq/year",null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T113","v":false}]
[null,null,null,{"$f":"Inputs!C114","v":"Chemical 5"},"tCO2eq/year",null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T114","v":false}]
[null,null,null,{"$f":"Inputs!C115","v":"Chemical 6"},"tCO2eq/year",null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T115","v":false}]
[null,null,null,{"$f":"Inputs!C116","v":"Chemical 7"},"tCO2eq/year",null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T116","v":false}]
[null,null,null,{"$f":"Inputs!C117","v":"Chemical 8"},"tCO2eq/year",null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T117","v":false}]
[null,null,null,{"$f":"Inputs!C118","v":"Chemical 9"},"tCO2eq/year",null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T118","v":false}]
[null,null,null,{"$f":"Inputs!C119","v":"Chemical 10"},"tCO2eq/year",null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T119","v":false}]
[null,null,null,{"$f":"Inputs!C120","v":"Chemical 11"},"tCO2eq/year",null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T120","v":false}]
[null,null,null,{"$f":"Inputs!C121","v":"Chemical 12"},"tCO2eq/year",null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T121","v":false}]
[null,null,null,{"$f":"Inputs!C122","v":"Chemical 13"},"tCO2eq/year",null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T122","v":false}]
[null,null,null,{"$f":"Inputs!C123","v":"Chemical 14"},"tCO2eq/year",null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T123","v":false}]
[null,null,null,{"$f":"Inputs!C124","v":"Chemical 15"},"tCO2eq/year",null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T124","v":false}]
[null,null,null,{"$f":"Inputs!C125","v":"Chemical 16"},"tCO2eq/year",null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T125","v":false}]
[null,null,null,{"$f":"Inputs!C126","v":"Chemical 17"},"tCO2eq/year",null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T126","v":false}]
[null,null,null,{"$f":"Inputs!C127","v":"Chemical 18"},"tCO2eq/year",null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T127","v":false}]
[null,null,null,{"$f":"Inputs!C128","v":"Chemical 19"},"tCO2eq/year",null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T128","v":false}]
[null,null,null,{"$f":"Inputs!C129","v":"Chemical 20"},"tCO2eq/year",null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!T129","v":false}]
[null,null,null,"Total Chemical Transportation Emissions","tCO2eq/year",{"$f":"SUM(G166:Q166)","v":0},{"$f":"SUM(G146:G165)","v":0},{"$f":"SUM(H146:H165)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"TRUE","v":true}]