{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["1a. READ ME (Start here)","1b. Basic info","2. Scoping","3. Data","4. Examples","5. Calculations","6. Summary","Automation Reference"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":12,"comments":0,"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":"1a. READ ME (Start here)","index":0,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,1,3,6]]}
[]
[null,"Purpose"]
[]
[null,"***Please read through the entirety of this sheet (1a) then proceed to the next sheet (1b).***\n\nThe Greenhouse Gas (GHG) Emission Accounting Template is primarily intended to be used by applicants to satisfy the Critical Mineral Infrastructure Fund (CMIF) program requirements, including demonstrating GHG emission reductions and displacements.\n\nUse of the template ensures a consistent methodology and approach to GHG emission reduction or displacement quantification for all types of projects.\n\nThis template is designed to align with the general specifications of the CSA ISO 14064-2:20 Greenhouse gasses - Part 2 (CSA ISO 14064-2:20), including standardized requirements and processes for project-level GHG quantification, monitoring, and reporting. Please note that use of this template does not ensure that all requirements of CSA ISO 14064-2:20 are met, and may NOT be used to satisfy the requirements of other programs and/or carbon markets.\n\nPlease fill in all REQUIRED fields and pay attention to units. Fields that are not highlighted should NOT be edited."]
[]
[null,"Legend:"]
[]
[null,"REQUIRED Field"]
[null,"OPTIONAL Field"]
[]
[null,"Core tenets:"]
[]
[null,"Completeness","Include all relevant GHG emissions and removals. Include all relevant information to satisfy criteria and procedures."]
[null,"Consistency","Enable meaningful comparisons in GHG-related information."]
[null,"Accuracy","Reduce biases and uncertainties as far as is practical."]
[null,"Transparency","Disclose sufficient and appropriate GHG-related information to allow intended users to make decisions with reasonable confidence."]
[null,"Conservativeness","Use conservative assumptions, values, and procedures to ensure that GHG emission reductions or removal enhancements are not over-estimated."]
[]
[]
[null,"Relevant Definitions"]
[]
[null,"Term","Definition"]
[null,"Greenhouse gas (GHG)","Gaseous constituent of the atmosphere, both natural and anthropogenic, that absorbs and emits radiation at specific wavelengths within the spectrum of infrared radiation emitted by the Earth's surface, the atmosphere, and clouds.\n\nNOTE: GHGs include carbon dioxide (CO2), methane (CH4), nitrous oxide (N2O), hydrofluorocarbons (HFCs), perfluorocarbons (PFCs), and sulfur hexafluoride (SF6), among other gases."]
[null,"GHG emission","Total mass of a GHG (or GHGs) released to the atmosphere over a specified period of time."]
[null,"GHG reduction","Calculated decrease (delta) of GHG emissions between a baseline scenario and the project."]
[null,"GHG displacement","Calculated difference (delta) in GHG emissions between a hypothetical baseline scenario (most-likely alternative) and the project."]
[null,"Baseline scenario","A reference case consisting of events or conditions most likely to persist or occur in the absence of a proposed project. A baseline scenario may also consist of a hypothetical reference case that best represents the conditions most likely to occur in the absence of a proposed project. A baseline scenario determined using a project-specific approach represents what would occur in the absence of the project, whereas a GHG programme can prescribe another approach to determine the baseline scenario, such as a performance standard."]
[null,"Carbon dioxide equivalent (CO2e)","Unit for comparing the radiative forcing of a GHG to that of carbon dioxide.\n\nNOTE: The carbon dioxide equivalent is calculated using the mass of a given GHG multiplied by its global warming potential."]

{"sheet":"1b. Basic info","index":1,"n_rows":65,"n_cols":8,"rows_kept":65,"cut":false,"hidden":false,"merged":[[10,1,10,2],[11,1,11,2],[54,1,54,4],[45,1,45,2],[50,1,50,2],[48,1,48,2],[47,1,47,3],[30,1,30,2],[39,1,39,2],[3,1,3,4],[20,1,20,4],[32,1,32,4],[41,1,41,4],[36,1,36,2],[28,1,28,2],[29,1,29,2],[37,1,37,2],[38,1,38,2],[16,1,16,2],[17,1,17,2],[26,1,26,2],[27,1,27,2],[18,1,18,2],[15,1,15,2],[9,1,9,2],[56,2,56,3],[63,4,63,7],[55,1,55,4],[49,1,49,3],[46,1,46,2]]}
[]
[null,"How this template works"]
[]
[null,"This sheet collects basic information about your energy project for both Stream 1: Preconstruction and Stream 2: Shovel Ready to the Critical Mineral Infrastructure Fund (CMIF). \n\nThis workbook will estimate the annual average GHG reductions and/or displacements of your energy project for the following types/technologies: grid connection (transmission and distribution), renewable energy generation (solar PV and onshore wind), and/or energy storage projects based on the information provided by the applicant. The results will be shown in the Review table at the bottom of this sheet. The results will also be used to prepopulate sheet 6. The methodology for the estimation is also included below. It is the responsibility of the applicant to verify the review table and edit the highlighted cells of sheet 6, as needed.\n\nIf the project includes other technologies (i.e. hydroelectric or biomass generation, etc.), more detailed information is required to estimate the project's GHG displacements and/or reductions. Proceed to and complete sheets 2, 5, and 6. Your answers to the screening questions below will also trigger this result in row 21 and/or in subsequent rows. For further guidance, please send an email to cmif-fimc@nrcan-rncan.gc.ca or consult sheet 4 for examples.\n\nPlease prompts carefully and ensure your inputs are expressed in the correct units for each field."]
[]
[null,"Basic project screening"]
[]
[null,"Project timeline and location"]
[]
[null,"Estimated or known calendar year project is commissioned and achieves actual emission reductions or displacements):"]
[null,"Expected life of funded technology, product, or service (years) (e.g., 10):"]
[null,"Province or territory in which the project is located:"]
[]
[null,"Technologies"]
[]
[null,"Does the project include a new grid connection (transmission or distribution line) to meet loads otherwise met by other energy sources (e.g., diesel, natural gas)?"]
[null,"Does the project include new solar PV panels or onshore wind turbines?"]
[null,"Does the project include new energy storage assets (e.g., battery energy storage system (BESS))?"]
[null,"Does the project include other energy technologies that impact GHG displacements or reductions?"]
[]
[null,{"$f":"IF(OR(D10=\"\",D11=\"\",D12=\"\",D16=\"\",D17=\"\",D18=\"\",D19=\"\"),\"Please complete the fields above. Otherwise, more detailed information about your project's GHG impacts is needed. Please complete sheets 2, 5 and 6.\",IF(AND(D16=\"No\",D17=\"No\",D18=\"No\"),\"Based on the information above, we need more detailed information about your project's GHG impacts. Please proceed to Sheets 2, 5, and 6. Do not complete the fields below.\",IF(D19=\"Yes\",\"Based on the information above, we need more detailed information about your project's GHG impacts. Please complete sheets 2, 5, and 6. Do not complete the fields below.\",\"Please complete the fields below if applicable.\")))","v":"Please complete the fields above. Otherwise, more detailed information about your project's GHG impacts is needed. Please complete sheets 2, 5 and 6."}]
[]
[null,"Energy project information"]
[]
[null,"Grid connection projects"]
[]
[null,"Expected power rating (MW/MVA):"]
[null,"Expected voltage (kV):"]
[null,"Expected distance (km):"]
[null,"Annual energy demand of future and existing mining projects that would be served by the infrastructure (MWh)*:\n\n*Include the sum of all expected or known annual electricity demand of the mining projects that would be served by the infrastructure project."]
[null,"Would this energy demand otherwise be met by diesel (emission factor: light fuel oil - industrial) generation?"]
[]
[null,{"$f":"IF(D31=\"Yes\",\"Please complete the fields below if applicable.\",IF(D31=\"No\",\"Based on the information above, more detailed information about your project's GHG impacts is needed. Please proceed to Sheets 2, 5, and 6. Do not complete the fields below.\",\"Please complete the fields above. Otherwise, more detailed information about your project's GHG impacts is needed. Please complete sheets 2, 5 and 6.\"))","v":"Please complete the fields above. Otherwise, more detailed information about your project's GHG impacts is needed. Please complete sheets 2, 5 and 6."}]
[]
[null,"Generation projects"]
[]
[null,"Indicate the generation technology type:"]
[null,"Indicate the energy capacity of the new electricity generation infrastructure (MW):"]
[null,"Indicate the expected annual energy production (P50 energy yield* for Stream 2 projects) of the new electricity generation infrastructure (MWh):\n\nThe P50 energy yield is a statistical measure used in the renewable energy industry to estimate the expected energy production of a project, such as a solar or wind farm. For Stream 1 projects, use the best estimate available."]
[null,"Would this energy production displace electricity from the provincial grid, or from diesel (emission factor: light fuel oil - industrial)? \n\nPlease note: if you select the provincial grid, this calculation assumes that new electricity generation will displace equivalent volume of natural gas generation as the marginal resource."]
[]
[null,{"$f":"IF(OR(D37=\"\",D38=\"\",D39=\"\",D40=\"\"),\"Please complete the fields above. Otherwise, more detailed information about your project's GHG impacts is needed. Please complete sheets 2, 5, and 6.\",IF(D40=\"Other\",\"Based on the information above, more detailed information about the project's GHG impacts is needed. Please complete sheets 2, 5, and 6. Do not complete the fields below.\",\"Please input the information requested below.\"))","v":"Please complete the fields above. Otherwise, more detailed information about your project's GHG impacts is needed. Please complete sheets 2, 5, and 6."}]
[]
[null,"Storage projects"]
[]
[null,"Power rating (MW):"]
[null,"Energy capacity (MWh):"]
[null,"Before proceeding, please note that out of the following common use cases for energy storage, this sheet can only account for clipped energy:\n\n1) Energy Arbitrage. Battery is charged at off-peak times (via the provincial or territorial grid) and discharged at peak times (e.g., displacing GHGs produced by natural gas and/or diesel, depending on the mine specific context).\n\n2) Behind the Meter. Energy storage units are connected behind-the-meter. Power injections into the grid are possible with appropriate incentives; however, the storage unit’s main function is providing behind the meter value such as peak reduction or back up power. \n\n3) Clipped Energy. Energy storage units may be coupled with a renewable energy generation asset for the purpose of capturing clipped or curtailed energy."]
[null,"Select the use case that best describes how the storage system will be used:",null,"N/A (no storage)"]
[null,{"$f":"IF(OR(D49=\"N/A (no storage)\",D49=\"Clipped energy\"),\"Please complete the fields below if applicable.\",\"Please complete the fields above. Otherwise, more detailed information about your project's GHG impacts is needed. Please complete sheets 2, 5, and 6.\")","v":"Please complete the fields below if applicable."}]
[null,"Annual electricity output from the addition of storage (MWh) (for clipped energy projects):"]
[]
[null,"Review Table"]
[]
[null,"Please review the table below and sheet 6 (6. Summary), and edit the highlighted cells if needed. \n\nIf the table below does not accurately reflect GHG displacements, please explain why in the field below and complete Sheets 2, 5, and 6."]
[null,"Methodology:\nNet annual emission displacement = Baseline Emissions − Project Emissions\nWhere:\nBaseline Emissions = ∑ (Energy × Baseline Emission Factor)\nProject Emissions = ∑ (Energy × Project Emission Factor)"]
[null,"If applicable, reason(s) your project is not accurately reflected in the table below:"]
[]
[null,null,"Project emission factor (EF) (tCO2e/MWh)","Baseline emission factor (EF) (tCO2e/MWh)","Energy (MWh)","Project emissions (annual) (tCO2e)","Baseline emissions (annual) (tCO2e)","Annual net emission displacement  (tCO2e)"]
[null,"Interconnection",{"$f":"IF(D16=\"Yes\",AVERAGE(IF(D10+D11-1<=2050,INDEX('3. Data'!$C$32:$AB$44,MATCH(D12,'3. Data'!$B$32:$B$44,0),MATCH(TEXT(D10,\"0\"),'3. Data'!$C$31:$AB$31,0)):INDEX('3. Data'!$C$32:$AB$44,MATCH(D12,'3. Data'!$B$32:$B$44,0),MATCH(TEXT(D10+D11-1,\"0\"),'3. Data'!$C$31:$AB$31,0))),\nINDEX('3. Data'!$C$32:$AB$44,MATCH(D12,'3. Data'!$B$32:$B$44,0),MATCH(TEXT(D10,\"0\"),'3. Data'!$C$31:$AB$31,0)):INDEX('3. Data'!$C$32:$AB$44,MATCH(D12,'3. Data'!$B$32:$B$44,0),MATCH(\"2050\",'3. Data'!$C$31:$AB$31,0))+(D10+D11-2051)*INDEX('3. Data'!$C$32:$AB$44,MATCH(D12,'3. Data'!$B$32:$B$44,0),MATCH(\"2050\",'3. Data'!$C$31:$AB$31,0))),\"0\")","v":"0"},{"$f":"IF(D31=\"Yes\",('3. Data'!C96)/1000,0)","v":0},{"$f":"D30","v":0},{"$f":"E60*C60","v":0},{"$f":"E60*D60","v":0},{"$f":"G60-F60","v":0}]
[null,"Generation",{"$f":"IF(D37=\"Onshore wind\",'3. Data'!C52,IF(D37=\"Solar PV\",'3. Data'!C54))","v":false},{"$f":"IF(D40=\"Diesel\",('3. Data'!C97)/1000,IF(D40=\"Grid\",'3. Data'!C74))","v":false},{"$f":"D39","v":0},{"$f":"E61*C61","v":0},{"$f":"E61*D61","v":0},{"$f":"G61-F61","v":0}]
[null,"Storage",{"$f":"IF(D37=\"Onshore wind\",'3. Data'!C52,IF(D37=\"Solar PV\",'3. Data'!C54))","v":false},{"$f":"IF(D40=\"Diesel\",('3. Data'!C97)/1000,IF(D40=\"Grid\",'3. Data'!C74))","v":false},{"$f":"D51","v":0},0,0,0]
[null,"TOTAL","-","-","-",{"$f":"SUM(F60:F62)","v":0},0,0]
[null,null,null,null,"Please note that emissions calculated here will display as 'Direct' in sheet 6."]
[null,null,null,null,null,null,"Average annual percentage  reduction:",{"$f":"(H63/G63)","v":{"$error":"#DIV/0!"}}]

{"sheet":"2. Scoping","index":2,"n_rows":109,"n_cols":7,"rows_kept":109,"cut":false,"hidden":false,"merged":[[42,1,42,6],[94,1,94,6],[29,1,29,6],[33,2,33,5],[34,2,34,5],[35,2,35,5]]}
[]
[null,"Quantification Approach"]
[]
[]
[null,"Index"]
[null,"1. Overview of process"]
[null,"2. Scoping emissions"]
[null,"3. Define the project scenario"]
[null,"4. Identify components of the project that may yield GHG emissions"]
[null,"5. Define the baseline scenario"]
[null,"6. Identify components of the baseline that may yield GHG emissions"]
[]
[]
[null,"Overview of Process"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Scoping Emissions"]
[]
[null,"CMIF recognizes that some projects may not be able to quantify direct emission reductions or displacements owing to the nature of their project. As a result, the program offers the following guidance when filling out this template:\n\n1. Generation and energy storage projects must only report Scope 1 emission reductions or displacements to CMIF but applicants are invited to quantify Scope 2 and Scope 3 emissions reductions or displacements as well.\n\n2. Because transmission and distribution infrastructure projects, and projects deploying other technology types often lead to indirect emission reductions or displacements as opposed to direct reductions or displacements, applicants looking to deploy these types of projects are required to quantify Scope 2 and, if applicable, Scope 3 emission reductions or displacements to be considered by the program."]
[]
[null,"The GHG Protocol classifies emission reductions and displacements by scope: "]
[]
[null,"Scope 1 emissions","Emissions from sources that an organization owns or controls directly. E.g., emissions attributable to the operation and maintenance of wind turbines owned by the applicant.",null,null,null,"Direct"]
[null,"Scope 2 emissions","Emissions that a company causes indirectly from where the energy it purchases and uses is produced. E.g., emissions attributable to the combustion of fossil fuels to heat a building.",null,null,null,"Indirect"]
[null,"Scope 3 emissions","Emissions that are not produced by the company itself and are not the result of activities from assets owned or controlled by the company, but by those that it's indirectly responsible for up and down its value chain. E.g., emissions attributable to the extraction of minerals needed for the manufacturing of a wind turbine blade. Scope 3 emissions include all sources not within Scope 1 and Scope 2 boundaries.",null,null,null,"Indirect"]
[]
[null,"Source:","What are scope 1, 2, and 3 carbon emissions?"]
[]
[]
[null,"1. Define the project scenario"]
[]
[null,"Describe the project and how it will achieve GHG emission reductions or displacements.\nIdentify risks that may substantially affect the project's estimated GHG emission reductions or displacements."]
[]
[null,"2. Identify components of the project that may yield GHG emissions"]
[]
[null,"Please identify all project components that will contribute to project-related emissions by selecting a characterization from the dropdown."]
[null,"If a component is expected to contribute to project-related emissions, please describe the component, the type of GHG emission reduction/displacement [DROPDOWN], and state all assumptions."]
[]
[null,"Component Index","Component Category","Characterization [DROPDOWN]","Description","Type of GHG Emission [Dropdown]","Assumptions"]
[null,"P.1.","NEW bulk generation","Non-emitting component",null,"Direct"]
[null,"P.2.","NEW transmission infrastructure"]
[null,"P.3.","NEW distribution infrastructure"]
[null,"P.4.","NEW distributed energy resources (DERs) in front of meter"]
[null,"P.5.","NEW customer premise"]
[null,"P.6.","NEW energy storage"]
[null,"P.7.","Retrofits to existing bulk generation"]
[null,"P.8.","Other"]
[null,null,null,"*A characterization must be selected for every component before progressing to the next step."]
[null,"Variable electricity generation for projects deploying new bulk generation"]
[]
[null,"If your project is looking to deploy new bulk generation and you expect that annual electricity generation will be variable, please enter the expected annual generation in megawatt-hours per year (MWh/year) for each year of operation."]
[null,"For years during which the project will not be in operation, please leave the field blank."]
[]
[null,"Year","Annual Electricity Generation [MWh/year]"]
[null,2025]
[null,2026]
[null,2027]
[null,2028]
[null,2029]
[null,2030]
[null,2031]
[null,2032]
[null,2033]
[null,2034]
[null,2035]
[null,2036]
[null,2037]
[null,2038]
[null,2039]
[null,2040]
[null,2041]
[null,2042]
[null,2043]
[null,2044]
[null,2045]
[null,2046]
[null,2047]
[null,2048]
[null,2049]
[null,2050]
[]
[null,"3. Define the baseline scenario"]
[]
[null,"Describe the baseline and all GHG emissions associated with this baseline.\nPlease note, it is important to ensure that there is functional equivalence between the baseline and the project. 'Functional equivalence' means that the same functionality is provided.\n\n*In developing the baseline, the project proponent shall select and justify the assumptions, values and procedures that ensure GHG emission reductions/displacements or removal enhancements are not over-estimated."]
[]
[null,"4. Identify components of the baseline that may yield GHG emissions"]
[]
[null,"Please identify all components of the baseline that will release GHG emissions by selecting a characterization from the dropdown. If a component is expected to contribute to baseline emissions, please describe the component, the type of GHG emission reduction/displacement [DROPDOWN], and state all assumptions."]
[]
[null,"Component Index","Component Category","Characterization [Dropdown]","Description","Type of GHG Emission Reduction/Displacement [Dropdown]","Assumptions"]
[null,"B.1.","EXISTING bulk generation"]
[null,"B.2.","EXISTING transmission infrastructure"]
[null,"B.3.","EXISTING distribution infrastructure"]
[null,"B.4.","EXISTING distributed energy resources (DERs) in front of meter"]
[null,"B.5.","EXISTING customer premise"]
[null,"B.6.","EXISTING energy storage"]
[null,"B.7.","Other"]
[null,null,null,"*A characterization must be selected for every component before progressing to the next step."]

{"sheet":"3. Data","index":3,"n_rows":393,"n_cols":28,"rows_kept":393,"cut":false,"hidden":false,"merged":[[293,1,293,2],[303,1,303,2],[309,1,309,2],[375,1,375,2],[224,1,224,5],[231,1,231,2],[241,1,241,2],[257,1,257,2],[267,1,267,2]]}
[]
[null,"Emission Factor Repository"]
[]
[]
[null,"Index"]
[null,"1. Grid Electricity Emission Factors by Province and Territory (without Biomass and RNG CO2 emissions)"]
[null,"2. Technology-specific Life-cycle Emission Factors (NREL)"]
[null,"3. Natural Gas Liquids Combustion Emission Factors"]
[null,"4. Other Combustion Emission Factors"]
[null,"5. Mobile Combustion and Freigth Emission Factors"]
[null,"6. Biomass Emission Factors"]
[null,"7. Common Conversion Factors"]
[null,"7.1 Prefixes and Equivalents"]
[null,"7.2 Distance"]
[null,"7.3 Area"]
[null,"7.4 Volume"]
[null,"7.5 Weight & Mass"]
[null,"7.6 Vehicle Mileage"]
[null,"7.7 Energy Terms"]
[null,"7.8 Liquified Natural Gas (LNG)"]
[]
[]
[null,"Grid Electricity Emission Factors by Province and Territory (without Biomass and RNG CO2 emissions)"]
[]
[null,"- The grid emission intensity corresponds to the ratio of GHG emissions from electricity over the regional sale of electricity. Grid emission intensity = (Combustion emissions from electricity generation by electric utilities + Process emissions from electricity transmission and distribution + (Emissions from electricity generation by industry * Electricity sold by industry to the electric utilities / Electricity generated by industry (own-use and sold to the electric utilities))) / Electricity sold by electric utilities to consumers (including generated by industry)."]
[null,"- These factors correspond to the 'Additional Measures' modelling scenario, which is based on the reference scenario but also accounts for policies and measures that are under development and for which there is enough information for the policies and measures to be modelled. (This scenario was selected as the most conservative estimate)."]
[null,"- Electricity flows between regions are indirectly considered by the calculation method but power generation emissions are attributed to the region where the electricity was generated. Thus, all electricity imports contribute to decrease the electricity grid emission intensities in the importing region since the imported electricity comes without emissions. On the contrary, regions using fossil fuels to generate electricity tend to increase their electricity grid emission intensities when they export electricity since the emissions of exported electricity are allocated to the exporting region."]
[]
[null,"Envrionment and Climate Change Canada Data Catalogue; Electricity Grid Intensities"]
[]
[null,"Average Grid Intensity Factor (tCO2e/MWh) by Province and Territory","2025","2026","2027","2028","2029","2030","2031","2032","2033","2034","2035","2036","2037","2038","2039","2040","2041","2042","2043","2044","2045","2046","2047","2048","2049","2050"]
[null,"Alberta",0.17980000000000002,0.19009999999999999,0.1555,0.14349999999999999,0.14859999999999998,0.14849999999999999,0.10920000000000001,0.10340000000000001,9.7099999999999992E-2,8.8900000000000007E-2,5.91E-2,5.6500000000000002E-2,5.33E-2,4.9299999999999997E-2,4.7100000000000003E-2,4.5399999999999996E-2,4.2700000000000002E-2,3.9799999999999995E-2,3.4700000000000002E-2,2.7399999999999997E-2,2.64E-2,2.5700000000000001E-2,2.5000000000000001E-2,2.4500000000000001E-2,2.4E-2,4.1799999999999997E-2]
[null,"British Columbia",4.5600000000000002E-2,4.2900000000000001E-2,4.07E-2,3.9700000000000006E-2,3.6799999999999999E-2,3.1899999999999998E-2,3.0499999999999999E-2,2.92E-2,2.7399999999999997E-2,2.6499999999999999E-2,1.9100000000000002E-2,1.8800000000000001E-2,1.8499999999999999E-2,1.83E-2,1.8200000000000001E-2,1.8100000000000002E-2,1.7999999999999999E-2,1.77E-2,1.7500000000000002E-2,1.72E-2,1.6899999999999998E-2,1.67E-2,1.66E-2,1.6500000000000001E-2,1.6399999999999998E-2,1.61E-2]
[null,"Manitoba",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"New Brunswick",0.27139999999999997,0.25540000000000002,0.25180000000000002,0.25019999999999998,0.1293,8.5000000000000006E-2,7.2400000000000006E-2,6.3799999999999996E-2,5.3800000000000001E-2,4.8799999999999996E-2,3.8399999999999997E-2,3.5900000000000001E-2,3.3500000000000002E-2,3.3299999999999996E-2,3.7999999999999999E-2,3.8899999999999997E-2,3.6999999999999998E-2,2.3300000000000001E-2,2.3300000000000001E-2,2.3399999999999997E-2,2.3399999999999997E-2,2.24E-2,2.2499999999999999E-2,2.2600000000000002E-2,2.2600000000000002E-2,2.2600000000000002E-2]
[null,"Newfoundland and Labrador",9.1999999999999998E-3,9.300000000000001E-3,9.1999999999999998E-3,1.77E-2,1.0500000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Northwest Territories",0,0,0,0,0,0,0,0,0,0,0,0,0,4.0999999999999995E-3,2.9700000000000001E-2,6.2399999999999997E-2,2.8500000000000001E-2,1.6300000000000002E-2,7.7000000000000002E-3,7.4999999999999997E-3,2.1000000000000001E-2,2.7E-2,2.6100000000000002E-2,2.1399999999999999E-2,2.0199999999999999E-2,4.9299999999999997E-2]
[null,"Nova Scotia",0.47910000000000003,0.45350000000000001,0.41949999999999998,0.39450000000000002,0.1653,0.11550000000000001,9.1600000000000001E-2,9.2999999999999999E-2,7.6499999999999999E-2,6.54E-2,1.1999999999999999E-3,-4.0000000000000002E-4,1.2999999999999999E-3,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Nunavut",0.51139999999999997,0.52349999999999997,0.53370000000000006,0.54370000000000007,0.53859999999999997,0.53870000000000007,0.52960000000000007,0.53770000000000007,0.53859999999999997,0.55270000000000008,0.56100000000000005,0.5645,0.56120000000000003,0.53920000000000001,0.54089999999999994,0.54849999999999999,0.5544,0.5605,0.55149999999999999,0.53239999999999998,0.52360000000000007,0.51279999999999992,0.50190000000000001,0.49010000000000004,0.48669999999999997,0.47720000000000001]
[null,"Ontario",0.1178,0.10590000000000001,0.1157,0.1033,9.6599999999999991E-2,7.4999999999999997E-2,5.0999999999999997E-2,4.6700000000000005E-2,3.9299999999999995E-2,3.15E-2,2.29E-2,2.1999999999999999E-2,2.1299999999999999E-2,2.0899999999999998E-2,2.0500000000000001E-2,2.0199999999999999E-2,0.02,1.9800000000000002E-2,1.9600000000000003E-2,1.9300000000000001E-2,1.9100000000000002E-2,1.8800000000000001E-2,1.8600000000000002E-2,1.84E-2,1.8100000000000002E-2,4.9100000000000005E-2]
[null,"Prince Edward Island",0,0,0,1E-4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Québec",1.2800000000000001E-2,1.32E-2,1.44E-2,1.6800000000000002E-2,1.9E-2,2.1499999999999998E-2,2.1399999999999999E-2,2.12E-2,2.1100000000000001E-2,2.0899999999999998E-2,1.8800000000000001E-2,1.8699999999999998E-2,1.8600000000000002E-2,1.8600000000000002E-2,1.8499999999999999E-2,1.8499999999999999E-2,1.8600000000000002E-2,1.8699999999999998E-2,1.67E-2,1.6E-2,1.6E-2,1.6E-2,1.5900000000000001E-2,1.5900000000000001E-2,1.5900000000000001E-2,1.5699999999999999E-2]
[null,"Saskatchewan",0.52549999999999997,0.52410000000000001,0.51060000000000005,0.40029999999999999,0.37380000000000002,0.16269999999999998,0.15209999999999999,0.1205,0.10859999999999999,9.7200000000000009E-2,5.2899999999999996E-2,5.0299999999999997E-2,4.7600000000000003E-2,4.4200000000000003E-2,4.0299999999999996E-2,2.4E-2,1.9899999999999998E-2,1.7100000000000001E-2,1.7000000000000001E-2,4.0999999999999995E-3,2.3999999999999998E-3,2.2000000000000001E-3,1.8E-3,2.2000000000000001E-3,3.3999999999999998E-3,3.2399999999999998E-2]
[null,"Yukon",4.4600000000000001E-2,7.7599999999999988E-2,0.11320000000000001,0.13390000000000002,0.13240000000000002,0.12570000000000001,9.2200000000000004E-2,6.2299999999999994E-2,6.1600000000000002E-2,6.1899999999999997E-2,6.3E-2,6.1200000000000004E-2,6.4200000000000007E-2,6.4799999999999996E-2,6.4899999999999999E-2,6.2600000000000003E-2,5.4100000000000002E-2,4.7E-2,4.5100000000000001E-2,4.1700000000000001E-2,3.78E-2,3.56E-2,3.3000000000000002E-2,3.2199999999999999E-2,3.0600000000000002E-2,0.03]
[]
[]
[null,"Technology-specific Life-cycle Emission Factors (NREL)"]
[]
[null,"National Renewable Energy Laboratory; Life Cycle Emissions Factors for Electricity Generation Technologies"]
[]
[null,"Generation Technology","Life Cycle Emission Factor [tCO2e/MWh]"]
[null,"Onshore Wind",1.2E-2]
[null,"Offshore Wind",1.9E-2]
[null,"Solar PV",4.8890000000000003E-2]
[null,"Concentrating Solar Power (Parabolic Through)",2.5999999999999999E-2]
[null,"Concentrating Solar Power (Power Tower)",3.7999999999999999E-2]
[null,"Concentrating Solar Power (Parabolic Dish)",1.5000000000000001E-2]
[null,"Hydropower (Reservoir)",1.2999999999999999E-2]
[null,"Hydropower (Run-of-River)",2.3E-2]
[null,"Geothermal (EGS Binary)",3.2000000000000001E-2]
[null,"Geothermal (HT Flash)",4.7E-2]
[null,"Geothermal (HT Binary)",1.0999999999999999E-2]
[null,"Ocean",8.0000000000000002E-3]
[null,"Biopower (Co-firing)",0.17]
[null,"Biopower (Direct Combustion)",4.1999999999999996E-2]
[null,"Biopower (Gasification)",0.04]
[null,"Biopower (Gasification Engine)",9.5000000000000001E-2]
[null,"Pumped-storage Hydropower",7.4000000000000003E-3]
[null,"Natural Gas-fired Combined Cycle (NGCC)",0.45]
[null,"Natural Gas-fired Combustion Turbine (NGCT)",0.60450000000000004]
[null,"Natural Gas-fired Combined Cycle with Carbon Capture and Storage (NGCC-CCS)",0.111]
[null,"Liquified Natural Gas-fired Combined Cycle (LNGCC)",0.501]
[null,"Liquified Natural Gas-fired Combustion Turbine (LNGCT)",0.65100000000000002]
[null,"Natural Gas (Unspecified)",0.39850000000000002]
[]
[]
[null,"Natural Gas Liquids Combustion Emission Factors"]
[]
[null,"NATIONAL INVENTORY REPORT 1990 - 2022: GREENHOUSE GAS SOURCES AND SINKS IN CANADA [PART 2]"]
[]
[null,"Liquid","CO2e Emission Factor (gCO2e/L)"]
[null,"Propane"]
[null,"Residential",1544.376]
[null,"All Other Uses",1544.2919999999999]
[null,"Ethane",1015.292]
[null,"Butane",1776.2919999999999]
[]
[]
[null,"Other Combustion Emission Factors"]
[]
[null,"NATIONAL INVENTORY REPORT 1990 - 2022: GREENHOUSE GAS SOURCES AND SINKS IN CANADA [PART 2]"]
[]
[null,"Liquid","CO2e Emission Factor (gCO2e/L)"]
[null,"Light Fuel Oil"]
[null,"Electric Utilities",2766.2550000000001]
[null,"Industrial",2761.3830000000003]
[null,"Producer Consumption",2678.3830000000003]
[null,"Residential",2755.3180000000002]
[null,"Forestry, Construction, Commercial/Institutional, Other",2761.9430000000002]
[null,"Heavy Fuel Oil"]
[null,"Electric Utilities",3173.9120000000003]
[null,"Industrial",3176.32]
[null,"Producer Consumption",3210.32]
[null,"Forestry, Construction, Commercial/Institutional, Other",3174.556]
[null,"Kerosene"]
[null,"Electric Utilities",2568.3830000000003]
[null,"Industrial",2568.3830000000003]
[null,"Producer Consumption",2568.3830000000003]
[null,"Residential",2562.3180000000002]
[null,"Forestry, Construction, Commercial/Institutional, Other",2568.9430000000002]
[null,"Diesel - Refineries and Others",2689.0140000000001]
[null,"Diesel - Upgrades",2689.0140000000001]
[null,"Petroleum Coke - Upgrading Facilities",3503.7200000000003]
[null,"Petroleum Coke - Refineries and Others",3836.6475]
[null,"Still Gas - Refineries and Others",2.9963000000000002]
[null,"Still Gas - Upgrades",2.1463920000000001]
[null,"Motor Gasoline",2315.1000000000004]
[]
[]
[null,"Mobile Combustion and Freight Emission Factors"]
[]
[null,"NATIONAL INVENTORY REPORT 1990 - 2022: GREENHOUSE GAS SOURCES AND SINKS IN CANADA [PART 2]"]
[]
[null,"Mode of Transportation","CO2e Emission Factor (g/L)"]
[null,"Road Transport"]
[null,"Gasoline Vehicles"]
[null,"Light Duty Gasoline Vehicles (LDGVs)"]
[null,"Tier 3",2312.2630000000004,"*Tier 3: Model years 2017 and later. Standards are designed to reduce both tailpipe and evaporative emissions and aims to reduce hydrocarbons (HC),  carbon monoxide (CO), nitrogen oxides (NOx), and particulate matter (PM) emissions significantly. "]
[null,"Tier 2",2317.0410083979327,"*Tier 2: Model years 2004-2016. Standards required the use of cleaner fuels and aimed to reduce hydrocarbons (HC), carbon monoxide (CO), nitrogen oxides (NOx), and particulate matter (PM) emissions."]
[null,"Tier 1",2439.0841364313173,"*Tier 1: Model years 1994-2003. Standards focused on reducing pollutants including hydrocarbons (HC), carbon monoxide (CO), nitorgen oxides (NOx), and particulate matter (PM)."]
[null,"Tier 0",2491.1600000000003,"*Tier 0: Model years 1981-1993. Standards focused on reducing emissions of hydrocarbons (HC), carbon monoxide (CO), and nitrogen oxides (NOx), setting the foundation for subsequent, more stringent tiers."]
[null,"Oxidation Catalyst",2374.86]
[null,"Non-catalytic Controlled",2327.6000000000004]
[null,"Light Duty Gasoline Trucks (LDGTs)"]
[null,"Tier 3",2312.2630000000004,"*Tier 3: Model years 2017 and later. Standards are designed to reduce both tailpipe and evaporative emissions and aims to reduce hydrocarbons (HC),  carbon monoxide (CO), nitrogen oxides (NOx), and particulate matter (PM) emissions significantly. "]
[null,"Tier 2",2317.0410083979327,"*Tier 2: Model years 2004-2016. Standards required the use of cleaner fuels and aimed to reduce hydrocarbons (HC), carbon monoxide (CO), nitrogen oxides (Nox), and particulate matter (PM) emissions."]
[null,"Tier 1",2468.6735829894842,"*Tier 1: Model years 1994-2003. Standards focused on reducing pollutants including hydrocarbons (HC), carbon monoxide (CO), nitorgen oxides (NOx), and particulate matter (PM)."]
[null,"Tier 0",2488.0800000000004,"*Tier 0: Model years 1981-1993. Standards focused on reducing emissions of hydrocarbons (HC), carbon monoxide (CO), and nitrogen oxides (NOx), setting the foundation for subsequent, more stringent tiers."]
[null,"Oxidation Catalyst",2372.34]
[null,"Non-catalytic Controlled",2330.4]
[null,"Heavy Duty Gasoline Vehicles"]
[null,"Three-way Catalyst",2362.2040000000002]
[null,"Non-catalytic Controlled",2327.875]
[null,"Uncontrolled",2343.2800000000002]
[null,"Motorcycles"]
[null,"Non-catalytic Controlled",2339.7530000000002]
[null,"Uncontrolled",2384.42]
[null,"Diesel Vehicles"]
[null,"Light Duty Diesel Vehicles (LDDVs)"]
[null,"Advanced Control",2740.2280000000001]
[null,"Moderate Control",2738.0540000000001]
[null,"Uncontrolled",2725.7000000000003]
[null,"Light Duty Diesel Trucks (LDDTs)"]
[null,"Advanced Control",2740.7040000000002]
[null,"Moderate Control",2738.0540000000001]
[null,"Uncontrolled",2725.28]
[null,"Heavy Duty Diesel Vehicles (HDDVs)"]
[null,"Advanced Control",2723.5949999999998]
[null,"Moderate Control",2706.15]
[null,"Uncontrolled",2704.5749999999998]
[null,"Natural Gas Vehicles",2.1622999999999997]
[null,"Propane Vehicles",1540.3400000000001]
[null,"Off-road Transport"]
[null,"Off-road Gasoline 2-stroke",2606.3825999999999]
[null,"Off-road Gasoline 4-stroke",2466.623]
[null,"Off-road Diesel < 19kW",2688.4201148893244]
[null,"Off-road Diesel ≥ 19kW, Tier 1 - 3",2688.4201148893244]
[null,"Off-road Diesel ≥ 19kW, Tier 4",2742.5974439891165]
[null,"Off-road Lubricating Oil 2-stroke",3064.56]
[null,"Off-road Natural Gas",2.1622999999999997]
[null,"Off-road Propane",1556.0218403848453]
[null,"Diesel Locomotive",2957.357]
[null,"Marine"]
[null,"Gasoline",2330.04558]
[null,"Diesel",2706.6287400000001]
[null,"Light Fuel Oil",2779.4989999999998]
[null,"Heavy Fuel Oil",3185.6207999999997]
[null,"Kerosene",2585.3277999999996]
[null,"Aviation"]
[null,"Gasoline",2447.67]
[null,"Turbo Fuel",2579.0454999999997]
[null,"Renewable Fuels"]
[null,"Ethanol",1517.79]
[null,"Biodiesel",2515.2949999999996]
[]
[]
[null,"GHGenius v5.0d"]
[]
[null,"These emission factors may be used where the volume of fuel consumed is unknown but distance travelled is known."]
[]
[null,"Mode of Transportation","CO2e Emission Factor (g-CO2e/km)"]
[null,"Light Duty Vehicles"]
[null,"Gasoline",170.58588350432836]
[null,"Gasoline Hybrid",105.42493070066966]
[null,"Natural Gas",143.65727802988593]
[null,"Propane",149.2313455165808]
[null,"Diesel",163.53400340767394]
[null,"E10",164.97270678774672]
[null,"Heavy Duty Vehicles"]
[null,"Diesel",1105.8957085583488]
[null,"Gasoline",1340.86804178634]
[null,"Natural Gas",975.27812494802185]
[null,"LNG / Diesel (95/5)",856.61172713366523]
[]
[]
[null,"Biomass Emission Factors"]
[]
[null,"NATIONAL INVENTORY REPORT 1990 - 2022: GREENHOUSE GAS SOURCES AND SINKS IN CANADA [PART 2]"]
[]
[null,"Source","Description","Emission Factor (CO2) [g/kg fuel]","Emission Factor (CH4) [g/kg fuel]","Emission Factor (N2O) [g/kg fuel]"]
[null,"Wood Fuel / Wood Waste","Industrial Combustion",1715,0.1,7.0000000000000007E-2]
[null,"Forest Wildfires","Open Combustion","N/A","N/A","N/A"]
[null,"Controlled Burning","Open Combustion","N/A","N/A","N/A"]
[null,"Spent Pulping Liquor","Industrial Combustion",1250,0.03,5.0000000000000001E-3]
[null,"Stoves and Fireplaces","Residential Combustion"]
[null,"Conventional Stoves",null,1539,12.9,0.12]
[null,"Conventional Fireplaces and Inserts",null,1539,12.9,0.12]
[null,"Stove / Fireplaces with Advanced Technology or Catalytic Control",null,1539,5.9,0.12]
[null,"Pellet Stove",null,1652,4.12,5.8999999999999997E-2]
[null,"Other Wood-burning Equipment",null,1539,4.12,5.8999999999999997E-2]
[]
[null,"Notes:"]
[]
[null,"- N/A = Not applicable"]
[null,"- CO2 emissions from biomass combusted for energy or agricultural purposes are not included in inventory totals, whereas CH4 and N2O emisisons from these sources are inventoried under the Energy Sector. All greenhouse gas (GHG) emissions, including CO2 emissions from biomass burned in managed forests (wildfires and controlled burning), are reported under Land-Use, Land-use Change and Forestry (LULUCF) and excluded from national inventory totals."]
[]
[]
[null,"Common Conversion Factors"]
[]
[null,"Energy conversion tables - Canada Energy Regulator"]
[]
[null,"Prefixes and Equivalents"]
[]
[null,"Prefixes","Equivalents"]
[null,"k (kilo)","103"]
[null,"M (mega)","106"]
[null,"G (giga)","109"]
[null,"T (tera)","1012"]
[null,"P (peta)","1015"]
[null,"E (exa)","1018"]
[]
[null,"Distance"]
[]
[null,"Unit","Equivalents"]
[null,"1.0 Metres (m)","3.2808 Feet (ft)"]
[null,"1.0 Metres (m)","1 x 10-3 Kilometres (km)"]
[null,"1.0 Metres (m)","6.2137 x 10-4 Miles (mi)"]
[null,"1.0 Feet (ft)","0.3048 Metres (m)"]
[null,"1.0 Feet (ft)","3.048 x 10-4 Kilometres (km)"]
[null,"1.0 Feet (ft)","1.8939 x 10-4 Miles (mi)"]
[null,"1.0 Kilometres (km)","3,280.8399 Feet (ft)"]
[null,"1.0 Kilometres (km)","1,000 Metres (m)"]
[null,"1.0 Kilometres (km)","0.6214 Miles (mi)"]
[null,"1.0 Miles (mi)","5,280 Feet (ft)"]
[null,"1.0 Miles (mi)","1.6094 Kilometres (km)"]
[null,"1.0 Miles (mi)","1,609.344 Metres (m)"]
[]
[null,"Area"]
[]
[null,"Unit","Equivalents"]
[null,"1.0 Hectares","2.4711 Acres"]
[null,"1.0 Hectares","3.861 x 10-3 Square miles (sq mi)"]
[null,"1.0 Acres","0.4047 Hectares"]
[null,"1.0 Acres","1.5625 x 10-3 Square miles (sq mi)"]
[null,"1.0 Square miles (sq mi)","640 Acres"]
[null,"1.0 Square miles (sq mi)","258.9988 Hectares"]
[]
[null,"Volume"]
[]
[null,"Unit","Equivalents"]
[null,"1.0 Cubic metres (m³)","6.2898 Barrels (bbl)"]
[null,"1.0 Cubic metres (m³)","1,000 Litres (l)"]
[null,"1.0 Cubic metres (m³)","219.9692 Imperial gallons"]
[null,"1.0 Cubic metres (m³)","264.1721 US Gallons"]
[null,"1.0 Cubic metres (m³) (@ 101.325 kPa and 15° C)","35.3147 Cubic feet (cf) natural gas (@ 14.73 psia and 60° F)"]
[null,"1.0 Cubic feet (cf) natural gas (@ 14.73 psia and 60° F)","0.028317 Cubic metres (m³) (@ 101.325 kPa and 15° C)"]
[null,"1.0 US Gallons","0.0238 Barrels (bbl)"]
[null,"1.0 US Gallons","0.8327 Imperial gallons"]
[null,"1.0 US Gallons","3.7854 Litres (l)"]
[null,"1.0 US Gallons","3.7854 x 10-3 Cubic metres (m³)"]
[null,"1.0 Litres (l)","0.22 Imperial gallons"]
[null,"1.0 Litres (l)","6.2898 x 10-3 Barrels (bbl)"]
[null,"1.0 Litres (l)","0.2642 US Gallons"]
[null,"1.0 Litres (l)","1 x 10-3 Cubic metres (m³)"]
[null,"1.0 Imperial gallons","4.5461 Litres (l)"]
[null,"1.0 Imperial gallons","0.0286 Barrels (bbl)"]
[null,"1.0 Imperial gallons","1.201 US Gallons"]
[null,"1.0 Imperial gallons","4.5461 x 10-3 Cubic metres (m³)"]
[null,"1.0 Barrels (bbl)","0.159 Cubic metres (m³)"]
[null,"1.0 Barrels (bbl)","158.9873 Litres (l)"]
[null,"1.0 Barrels (bbl)","34.9723 Imperial gallons"]
[null,"1.0 Barrels (bbl)","42 US Gallons"]
[]
[null,"Weight & Mass"]
[]
[null,"Unit","Equivalents"]
[null,"1.0 Kilograms (kg)","1 x 10-3 Tonnes (t)"]
[null,"1.0 Kilograms (kg)","2.2046 Pounds (lb)"]
[null,"1.0 Tonnes (t)","1,000 Kilograms (kg)"]
[null,"1.0 Tonnes (t)","2,204.6226 Pounds (lb)"]
[null,"1.0 Pounds (lb)","0.4536 Kilograms (kg)"]
[null,"1.0 Pounds (lb)","4.5359 x 10-4 Tonnes (t)"]
[]
[null,"Vehicle Mileage"]
[]
[null,"Unit","Equivalents"]
[null,"1.0 Kilometres/Litre (km/l)","2.3522 Miles/Gallon (mi/gal)"]
[null,"1.0 Miles/Gallon (mi/gal)","0.4252 Kilometres/Litre (km/l)"]
[]
[null,"Energy Terms"]
[]
[null,"Unit","Equivalents"]
[null,"1.0 Watts (w)","1 Joules (J) per second"]
[null,"1.0 Gigajoules (GJ)","1 x 109 Joules (J)"]
[null,"1.0 Gigajoules (GJ)","0.9478 Million British thermal units (MMBtu)"]
[null,"1.0 Gigajoules (GJ)","2.7778 x 105 Watt-hours (W.h)"]
[null,"1.0 Gigajoules (GJ)","277.7778 Kilowatt-hours (kW.h)"]
[null,"1.0 Gigajoules (GJ)","0.2778 Megawatt-hours (MW.h)"]
[null,"1.0 Gigajoules (GJ)","2.7778 x 10-4 Gigawatt-hours (GW.h)"]
[null,"1.0 Gigajoules (GJ)","2.7778 x 10-7 Terawatt-hours (TW.h)"]
[null,"1.0 Gigajoules (GJ)","947.8171 Cubic feet (cf) natural gas"]
[null,"1.0 Gigajoules (GJ)","26.853 Cubic metres (m³) natural gas"]
[null,"1.0 Million British thermal units (MMBtu)","1.0551 x 109 Joules (J)"]
[null,"1.0 Million British thermal units (MMBtu)","1.0551 Gigajoules (GJ)"]
[null,"1.0 Million British thermal units (MMBtu)","2.9307 x 105 Watt-hours (W.h)"]
[null,"1.0 Million British thermal units (MMBtu)","293.0711 Kilowatt-hours (kW.h)"]
[null,"1.0 Million British thermal units (MMBtu)","0.2931 Megawatt-hours (MW.h)"]
[null,"1.0 Million British thermal units (MMBtu)","2.9307 x 10-4 Gigawatt-hours (GW.h)"]
[null,"1.0 Million British thermal units (MMBtu)","2.9307 x 10-7 Terawatt-hours (TW.h)"]
[null,"1.0 Million British thermal units (MMBtu)","1,000 Cubic feet (cf) natural gas"]
[null,"1.0 Million British thermal units (MMBtu)","28.3278 Cubic metres (m³)"]
[null,"1.0 Watt-hours (W.h)","3,600 Joules (J)"]
[null,"1.0 Watt-hours (W.h)","3.6 x 10-6 Gigajoules (GJ)"]
[null,"1.0 Watt-hours (W.h)","3.4121 x 10-6 Million British thermal units (MMBtu)"]
[null,"1.0 Watt-hours (W.h)","1 x 10-3 Kilowatt-hours (kW.h)"]
[null,"1.0 Watt-hours (W.h)","1 x 10-6 Megawatt-hours (MW.h)"]
[null,"1.0 Watt-hours (W.h)","1 x 10-9 Gigawatt-hours (GW.h)"]
[null,"1.0 Watt-hours (W.h)","1 x 10-12 Terawatt-hours (TW.h)"]
[null,"1.0 Kilowatt-hours (kW.h)","3.6 x 106 Joules (J)"]
[null,"1.0 Kilowatt-hours (kW.h)","3.6 x 10-3 Gigajoules (GJ)"]
[null,"1.0 Kilowatt-hours (kW.h)","3.4121 x 10-3 Million British thermal units (MMBtu)"]
[null,"1.0 Kilowatt-hours (kW.h)","1,000 Watt-hours (W.h)"]
[null,"1.0 Kilowatt-hours (kW.h)","1 x 10-3 Megawatt-hours (MW.h)"]
[null,"1.0 Kilowatt-hours (kW.h)","1 x 10-6 Gigawatt-hours (GW.h)"]
[null,"1.0 Kilowatt-hours (kW.h)","1 x 10-9 Terawatt-hours (TW.h)"]
[null,"1.0 Megawatt-hours (MW.h)","3.6 x 109 Joules (J)"]
[null,"1.0 Megawatt-hours (MW.h)","3.60 Gigajoules (GJ)"]
[null,"1.0 Megawatt-hours (MW.h)","3.4122 Million British thermal units (MMBtu)"]
[null,"1.0 Megawatt-hours (MW.h)","1 x 106 Watt-hours (W.h)"]
[null,"1.0 Megawatt-hours (MW.h)","1,000 Kilowatt-hours (kW.h)"]
[null,"1.0 Megawatt-hours (MW.h)","1 x 10-3 Gigawatt-hours (GW.h)"]
[null,"1.0 Megawatt-hours (MW.h)","1 x 10-6 Terawatt-hours (TW.h)"]
[null,"1.0 Gigawatt-hours (GW.h)","3.6 x 1012 Joules (J)"]
[null,"1.0 Gigawatt-hours (GW.h)","3,600 Gigajoules (GJ)"]
[null,"1.0 Gigawatt-hours (GW.h)","3,412.1416 Million British thermal units (MMBtu)"]
[null,"1.0 Gigawatt-hours (GW.h)","1 x 109 Watt-hours (W.h)"]
[null,"1.0 Gigawatt-hours (GW.h)","1 x 106 Kilowatt-hours (kW.h)"]
[null,"1.0 Gigawatt-hours (GW.h)","1,000 Megawatt-hours (MW.h)"]
[null,"1.0 Gigawatt-hours (GW.h)","1 x 10-3 Terawatt-hours (TW.h)"]
[null,"1.0 Terawatt-hours (TW.h)","3.6 x 1015 Joules (J)"]
[null,"1.0 Terawatt-hours (TW.h)","3.6 x 106 Gigajoules (GJ)"]
[null,"1.0 Terawatt-hours (TW.h)","3.4121 x 106 Million British thermal units (MMBtu)"]
[null,"1.0 Terawatt-hours (TW.h)","1 x 1012 Watt-hours (W.h)"]
[null,"1.0 Terawatt-hours (TW.h)","1 x 109 Kilowatt-hours (kW.h)"]
[null,"1.0 Terawatt-hours (TW.h)","1 x 106 Megawatt-hours (MW.h)"]
[null,"1.0 Terawatt-hours (TW.h)","1,000 Gigawatt-hours (GW.h)"]
[null,"1.0 Cubic feet (cf) natural gas","1.0551 x 10-3 Gigajoules (GJ)"]
[null,"1.0 Cubic feet (cf) natural gas","1 x 10-3 Million British thermal units (MMBtu)"]
[null,"1.0 Cubic metres (m³) natural gas","0.0373 Gigajoules (GJ)"]
[null,"1.0 Cubic metres (m³) natural gas","0.0353 Million British thermal units (MMBtu)"]
[null,"1.0 Therms (thm)","1 x 105 British thermal units (Btu)"]
[null,"1.0 Therms (thm)","0.10 Million British thermal units (MMBtu)"]
[null,"1.0 Dekatherms (dth)","10 Therms (thm)"]
[null,"1.0 Dekatherms (dth)","1 Million British thermal units (MMBtu)"]
[]
[null,"Liquified Natural Gas (LNG)"]
[]
[null,"Unit","Equivalents"]
[null,"1.0 Cubic metres (m³) natural gas","35.301 Cubic feet (cf) natural gas"]
[null,"1.0 Cubic metres (m³) natural gas","1.7111 x 10-3 Cubic metres (m³) LNG"]
[null,"1.0 Cubic metres (m³) natural gas","7.2487 x 10-4 Tonnes (t) LNG"]
[null,"1.0 Cubic metres (m³) LNG","2.0631 x 104 Cubic feet (cf) natural gas"]
[null,"1.0 Cubic metres (m³) LNG","584.431 Cubic metres (m³) natural gas"]
[null,"1.0 Cubic metres (m³) LNG","0.4049 Tonnes (t) LNG"]
[null,"1.0 Cubic metres (m³) LNG","2.0631 x 10-5 Billion cubic feet (Bcf) natural gas"]
[null,"1.0 Tonnes (t) LNG","1,379.549 Cubic metres (m³) natural gas"]
[null,"1.0 Tonnes (t) LNG","2.4697 Cubic metres (m³) LNG"]
[null,"1.0 Tonnes (t) LNG","4.8699 x 104 Cubic feet (cf) natural gas"]
[null,"1.0 Cubic feet (cf) natural gas","2.0531 x 10-5 Tonnes (t) LNG"]
[null,"1.0 Tonnes LNG per year","133.4232 Cubic feet natural gas per day (cf/d)"]
[null,"1.0 Million Tonnes LNG per year","0.1334 Billion cubic feet natural gas per day (Bcf/d)"]
[null,"1.0 Billion cubic feet (Bcf) natural gas","4.8471 x 104 Cubic metres (m³) LNG"]
[null,"1.0 Billion cubic feet natural gas per day (Bcf/d)","7.495 Million tonnes LNG per year"]

{"sheet":"4. Examples","index":4,"n_rows":157,"n_cols":39,"rows_kept":157,"cut":false,"hidden":false,"merged":[[34,1,34,4],[34,7,34,10],[31,1,31,10],[31,29,31,38],[34,29,34,32],[34,35,34,38],[31,15,31,24],[34,15,34,18],[34,21,34,24],[67,1,67,10],[70,1,70,4],[70,7,70,10],[67,15,67,24],[70,15,70,18],[70,21,70,24],[103,1,103,10],[106,1,106,4],[106,7,106,10],[103,15,103,24],[106,15,106,18],[106,21,106,24]]}
[]
[null,"Example Calculations"]
[]
[]
[null,"Index"]
[null,"1. Generation Projects"]
[null,"1.1 Example #1: Wind"]
[null,"1.2 Example #2: Solar PV"]
[null,"1.3 Example #3: Solar PV + Energy Storage"]
[null,"2. Energy Storage Projects"]
[null,"2.1 Example #1: Energy Arbitrage in Nova Scotia"]
[null,"2.2 Example #2: Peak Shaving in Ontario"]
[null,"2.3 Example #3: Storage for fast frequency regulation in Alberta"]
[null,"4. Transmisson Projects"]
[null,"4.1 Example #1: Transmission line upgrade at existing facility"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Generation Projects",null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Storage Projects",null,null,null,null,null,null,null,null,null,null,null,null,null,"Transmission Infrastructure Project"]
[]
[]
[]
[null,"Example #1: Alberta wind farm",null,null,null,null,null,null,null,null,null,null,null,null,null,"Example #1: Energy Arbitrage in Nova Scotia",null,null,null,null,null,null,null,null,null,null,null,null,null,"Example #1: Existing facility transmission line upgrade"]
[]
[null,"Description:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Description:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Description:"]
[null,"This example quantifies the expected annual GHG reductions of a new wind farm in Alberta.",null,null,null,null,null,null,null,null,null,null,null,null,null,"In this example, a BESS is used for energy arbitrage in Nova Scotia.",null,null,null,null,null,null,null,null,null,null,null,null,null,"In this example, an existing industrial facility currently uses a distribution line to provide 40,000 MWh per year. Its annual energy demand is expected to increase by 500,000 MWh in 2028, for a total of 540,000 MWh. Its operations will end in 2043.\n\nThe project proposes to decommission the existing distribution line and build a new transmission line to replace it and meet current and anticipated energy demand. Without this proposed transmission line, the facility would use diesel generators to meet increased demand."]
[]
[]
[null,"Project",null,null,null,null,null,"Baseline",null,null,null,null,null,null,null,"Project",null,null,null,null,null,"Baseline",null,null,null,null,null,null,null,"Project",null,null,null,null,null,"Baseline"]
[]
[]
[null,"Please select component from dropdown below:",null,null,null,null,null,"Please select component from dropdown below:",null,null,null,null,null,null,null,"Please select component from dropdown below:",null,null,null,null,null,"Please select component from dropdown below:",null,null,null,null,null,null,null,"Please select component from dropdown below:",null,null,null,null,null,"Please select component from dropdown below:"]
[null,"NEW bulk generation",null,"Reduction/displacement type:","Direct",null,null,"EXISTING bulk generation",null,"Reduction/displacement type:","Direct",null,null,null,null,"NEW energy storage",null,"Reduction/displacement type:","Direct",null,null,"EXISTING bulk generation",null,"Reduction/displacement type:","Direct",null,null,null,null,"NEW transmission infrastructure",null,"Reduction/displacement type:","Indirect",null,null,"EXISTING distribution infrastructure",null,"Reduction/displacement type:","Indirect"]
[null,"P.1.",null,null,null,null,null,"B.1.",null,null,null,null,null,null,null,"P.6.",null,null,null,null,null,"B.1.",null,null,null,null,null,null,null,"P.2.",null,null,null,null,null,"B.7."]
[]
[null,"Parameter","Value","Unit","Notes",null,null,"Parameter","Value","Unit","Notes",null,null,null,null,"Parameter","Value","Unit","Notes",null,null,"Parameter","Value","Unit","Notes",null,null,null,null,"Parameter","Value","Unit","Notes",null,null,"Parameter","Value","Unit","Notes"]
[null,"Amount of electricity generated by new wind turbine",84000000,"kWh/year","Capacity factor of 37.5%",null,null,"Amount of electricity generated by new wind turbine",84000000,"kWh/year","*Assuming new electricity generation will displace equivalent volume of natural gas generation as the marginal resource.",null,null,null,null,"Battery energy capacity",250,"MWh",null,null,null,"Round trip efficiency",90,"%",null,null,null,null,null,"Amount of electricity consumed from the Yukon grid via a new transmission line",540000000,"kWh/year",null,null,null,"Amount of electricity consumed from the Yukon grid via existing distribution line",40000000,"kWh/year"]
[null,"Unit conversion",{"$f":"C43/1000","v":84000},"MWh/year",null,null,null,"Unit conversion",{"$f":"I43/1000","v":84000},"MWh/year",null,null,null,null,null,"Battery storage duration",4,"hours",null,null,null,"Electricity displaced by battery discharging",{"$f":"Q46*W43/100","v":22500},"MWh/year",null,null,null,null,null,"Unit conversion",{"$f":"AE43/1000","v":540000},"MWh/year","Convert kWh to MWh",null,null,"Unit conversion",{"$f":"AK43/1000","v":40000},"MWh/year","Convert kWh to MWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planned cycles per year",100,"cycles/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity used for charging",{"$f":"Q43*Q45","v":25000},"MWh/year"]
[]
[]
[null,"*Add parameter(s) as required",null,null,null,null,null,"*Add parameter(s) as required",null,null,null,null,null,null,null,"*Add parameter(s) as required",null,null,null,null,null,"*Add parameter(s) as required",null,null,null,null,null,null,null,"*Add parameter(s) as required",null,null,null,null,null,"*Add parameter(s) as required"]
[null,null,null,null,"EF Description",null,null,null,null,null,"EF Description",null,null,null,null,null,null,null,"EF Description",null,null,null,null,null,"EF Description",null,null,null,null,null,null,null,"EF Description",null,null,null,null,null,"EF Description"]
[null,"Emission factor (EF)",1.2E-2,"tCO2e/MWh","Life cycle emission factor for onshore wind projects per NREL.",null,null,"Emission factor (EF)",0.39850000000000002,"tCO2e/MWh","Life cycle emission factor for natural gas (unspecified) per NREL, assuming new electricity generation will displace equivalent volume of natural gas generation as the marginal resource.",null,null,null,null,"Emission factor (EF)",{"$f":"AVERAGE('3. Data'!D38:N38)","v":0.17050909090909092},"tCO2e/MWh","Average grid intensity factor for Nova Scotia over the lifespan of the BESS (2026-2036). This is a conservative estimate as the battery is charged during periods of low demand when actual grid emission intensity is likely to be lower.",null,null,"Emission factor (EF)",0.39850000000000002,"tCO2e/MWh","Life cycle emission factor for natural gas (unspecified), assuming electricity in battery will displace an equivalent amount of electricity generated by natural gas, as the marginal resource during peak periods.",null,null,null,null,"Emission factor (EF)",{"$f":"AVERAGE('3. Data'!F44:U44)","v":7.4806249999999991E-2},"tCO2e/MWh","Yukon grid average EF from 2028 to 2043 ('3. Data'!F44:U44) ",null,null,"Emission factor (EF)",{"$f":"AVERAGE('3. Data'!F44:U44)","v":7.4806249999999991E-2},"tCO2e/MWh","Yukon grid average EF from 2028 to 2043 ('3. Data'!F44:U44) "]
[]
[null,"Emissions (annual)",{"$f":"C44*C51","v":1008},"tCO2e/year",null,null,null,"Emissions (annual)",{"$f":"I44*I51","v":33474},"tCO2e/year",null,null,null,null,null,"Emissions (annual)",{"$f":"Q46*Q51","v":4262.727272727273},"tCO2e/year",null,null,null,"Emissions (annual)",{"$f":"W44*W51","v":8966.25},"tCO2e/year",null,null,null,null,null,"Emissions (annual)",{"$f":"AE44*AE51","v":40395.374999999993},"tCO2e/year",null,null,null,"Emissions (annual)",{"$f":"AK44*AK51","v":2992.2499999999995},"tCO2e/year"]
[]
[]
[null,"DIRECT:",null,null,null,null,null,"DIRECT:",null,null,null,null,null,null,null,"DIRECT:",null,null,null,null,null,"DIRECT:",null,null,null,null,null,null,null,"Please select component from dropdown below:",null,null,null,null,null,"Please select component from dropdown below:"]
[null,"Total project emissions (annual):",{"$f":"SUMIF(E39,\"Direct\",C53)","v":1008},"tCO2e/year",null,null,null,"Total baseline emissions (annual):",{"$f":"SUMIF(K39,\"Direct\",I53)","v":33474},"tCO2e/year",null,null,null,null,null,"Total project emissions (annual):",{"$f":"SUMIF(S39,\"Direct\",Q53)","v":4262.727272727273},"tCO2e/year",null,null,null,"Total baseline emissions (annual):",{"$f":"SUMIF(Y39,\"Direct\",W53)","v":8966.25},"tCO2e/year",null,null,null,null,null,"Other",null,"Reduction/displacement type:","Indirect",null,null,"EXISTING bulk generation",null,"Reduction/displacement type:","Direct"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P.2.",null,null,null,null,null,"B.7."]
[null,"INDIRECT:",null,null,null,null,null,"INDIRECT:",null,null,null,null,null,null,null,"INDIRECT:",null,null,null,null,null,"INDIRECT:"]
[null,"Total project emissions (annual):",{"$f":"SUMIF(E39,\"Indirect\",C53)","v":0},"tCO2e/year",null,null,null,"Total baseline emissions (annual):",{"$f":"SUMIF(K39,\"Indirect\",I53)","v":0},"tCO2e/year",null,null,null,null,null,"Total project emissions (annual):",{"$f":"SUMIF(S39,\"Indirect\",Q53)","v":0},"tCO2e/year",null,null,null,"Total baseline emissions (annual):",{"$f":"SUMIF(Y39,\"Indirect\",W53)","v":0},"tCO2e/year",null,null,null,null,null,"Parameter","Value","Unit","Notes",null,null,"Parameter","Value","Unit","Notes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amount of electricity generated by diesel generators",500000,"MWh/year","Increased electricity demand starting in 2028"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unit conversion",{"$f":"AK61*1000","v":500000000},"kWh/year","Converts to kWh/year. 1 MWh = 1000 kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unit conversion",{"$f":"AK62*0.4","v":200000000},"L/year","Converts to L/year. Assume 1 kWh per 0.4 L diesel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emission factor for light fuel oil",{"$f":"'3. Data'!C96","v":2761.3830000000003},"gCO2e/L","From Other Combustion Emission Factors, light fuel oil - industrial ('3. Data'!C96). "]
[null,"Example #2: Alberta Solar PV",null,null,null,null,null,null,null,null,null,null,null,null,null,"Example #2: Peak Shaving in Ontario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unit conversion",{"$f":"AK64*10^-6","v":2.7613830000000001E-3},"tCO2e/L","This EF is giving in gCO2e/L, so it is divided by 10^6 to convert to tCO2e/L"]
[]
[null,"Description:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Description:",null,null,null,null,null,null,null,null,null,null,null,null,null,"*Add parameter(s) as required",null,null,null,null,null,"*Add parameter(s) as required"]
[null,"This example quantifies the expected annual GHG reductions of a new solar PV farm in Alberta.",null,null,null,null,null,null,null,null,null,null,null,null,null,"This example involves a utility-scale BESS for peak shaving in Ontario from 2026-2036.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EF Description",null,null,null,null,null,"EF Description"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emission factor (EF)",null,"tCO2e/MWh",null,null,null,"Emission factor (EF)",{"$f":"AK65","v":2.7613830000000001E-3},"tCO2e/L","Described above"]
[]
[null,"Project",null,null,null,null,null,"Baseline",null,null,null,null,null,null,null,"Project",null,null,null,null,null,"Baseline",null,null,null,null,null,null,null,"Emissions (annual)",{"$f":"AE66*AE69","v":0},"tCO2e/year",null,null,null,"Emissions (annual)",{"$f":"AK63*AK69","v":552276.6},"tCO2e/year"]
[]
[]
[null,"Please select component from dropdown below:",null,null,null,null,null,"Please select component from dropdown below:",null,null,null,null,null,null,null,"Please select component from dropdown below:",null,null,null,null,null,"Please select component from dropdown below:",null,null,null,null,null,null,null,"DIRECT:",null,null,null,null,null,"DIRECT:"]
[null,"NEW bulk generation",null,"Reduction/displacement type:","Direct",null,null,"EXISTING bulk generation",null,"Reduction/displacement type:","Direct",null,null,null,null,"NEW energy storage",null,"Reduction/displacement type:","Direct",null,null,"EXISTING bulk generation",null,"Reduction/displacement type:","Direct",null,null,null,null,"Total project emissions (annual):",{"$f":"SUMIF(AG39,\"Direct\",AE53)","v":0},"tCO2e/year",null,null,null,"Total baseline emissions (annual):",{"$f":"SUMIF(AM57,\"Direct\",AK71)","v":552276.6},"tCO2e/year"]
[null,"P.1.",null,null,null,null,null,"B.1.",null,null,null,null,null,null,null,"P.6.",null,null,null,null,null,"B.1."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDIRECT:",null,null,null,null,null,"INDIRECT:"]
[null,"Parameter","Value","Unit","Notes",null,null,"Parameter","Value","Unit","Notes",null,null,null,null,"Parameter","Value","Unit","Notes",null,null,"Parameter","Value","Unit","Notes",null,null,null,null,"Total project emissions (annual):",{"$f":"SUMIF(AG39,\"Indirect\",AE53)","v":40395.374999999993},"tCO2e/year",null,null,null,"Total baseline emissions (annual):",{"$f":"SUMIF(AM39,\"Indirect\",AK53)","v":2992.2499999999995},"tCO2e/year"]
[null,"Amount of electricity generated by new solar farm",25000000,"kWh/year","Capacity factor of  20%",null,null,"Amount of electricity generated by new wind turbine",25000000,"kWh/year",null,null,null,null,null,"Battery energy capacity",800,"MWh",null,null,null,"Round trip efficiency",86,"%"]
[null,"Unit conversion",{"$f":"C79/1000","v":25000},"MWh/year",null,null,null,"Unit conversion",{"$f":"I79/1000","v":25000},"MWh/year",null,null,null,null,null,"Storage duration",4,"hours",null,null,null,"Electricity displaced by battery discharging",{"$f":"Q84*W79/100","v":184946.2365591398},"MWh/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planned cycles per year",250,"cycles/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capacity per year",200000,"MWh/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charging efficiency ",93,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity consumed for charging",{"$f":"Q82/Q83*100","v":215053.7634408602},"MWh/year"]
[null,"*Add parameter(s) as required",null,null,null,null,null,"*Add parameter(s) as required",null,null,null,null,null,null,null,"*Add parameter(s) as required",null,null,null,null,null,"*Add parameter(s) as required"]
[null,null,null,null,"EF Description",null,null,null,null,null,"EF Description",null,null,null,null,null,null,null,"EF Description",null,null,null,null,null,"EF Description"]
[null,"Emission factor (EF)",{"$f":"'3. Data'!C54","v":4.8890000000000003E-2},"tCO2e/MWh","Life cycle emission factor for solar PV per NREL",null,null,"Emission factor (EF)",0.39850000000000002,"tCO2e/MWh","Life cycle emission factor for natural gas (unspecified), assuming new electricity generation will displace equivalent volume of natural gas generation as the marginal resource.",null,null,null,null,"Emission factor (EF)",{"$f":"AVERAGE('3. Data'!D40:N40)","v":6.4536363636363628E-2},"tCO2e/MWh","Average grid intensity factor for Ontario over the lifespan of the BESS (2026-2036). This is a conservative estimate as the battery is charged during periods of low demand when actual grid emission intensity is likely to be lower.",null,null,"Emission factor (EF)",0.39850000000000002,"tCO2e/MWh","Life cycle emission factor for natural gas (unspecified), assuming electricity in battery will displace an equivalent amount of electricity generated by natural gas, as the marginal resource during peak periods."]
[]
[null,"Emissions (annual)",{"$f":"C80*C87","v":1222.25},"tCO2e/year",null,null,null,"Emissions (annual)",{"$f":"I80*I87","v":9962.5},"tCO2e/year",null,null,null,null,null,"Emissions (annual)",{"$f":"Q84*Q87","v":13878.787878787876},"tCO2e/year",null,null,null,"Emissions (annual)",{"$f":"W80*W87","v":73701.075268817207},"tCO2e/year"]
[]
[]
[null,"DIRECT:",null,null,null,null,null,"DIRECT:",null,null,null,null,null,null,null,"DIRECT:",null,null,null,null,null,"DIRECT:"]
[null,"Total project emissions (annual):",{"$f":"SUMIF(E75,\"Direct\",C89)","v":1222.25},"tCO2e/year",null,null,null,"Total baseline emissions (annual):",{"$f":"SUMIF(K75,\"Direct\",I89)","v":9962.5},"tCO2e/year",null,null,null,null,null,"Total project emissions (annual):",{"$f":"SUMIF(S75,\"Direct\",Q89)","v":13878.787878787876},"tCO2e/year",null,null,null,"Total baseline emissions (annual):",{"$f":"SUMIF(Y75,\"Direct\",W89)","v":73701.075268817207},"tCO2e/year"]
[]
[null,"INDIRECT:",null,null,null,null,null,"INDIRECT:",null,null,null,null,null,null,null,"INDIRECT:",null,null,null,null,null,"INDIRECT:"]
[null,"Total project emissions (annual):",{"$f":"SUMIF(E75,\"Indirect\",C89)","v":0},"tCO2e/year",null,null,null,"Total baseline emissions (annual):",{"$f":"SUMIF(K75,\"Indirect\",I89)","v":0},"tCO2e/year",null,null,null,null,null,"Total project emissions (annual):",{"$f":"SUMIF(S75,\"Indirect\",Q89)","v":0},"tCO2e/year",null,null,null,"Total baseline emissions (annual):",{"$f":"SUMIF(Y75,\"Indirect\",W89)","v":0},"tCO2e/year"]
[]
[]
[]
[]
[null,"Example #3: Solar PV + Energy Storage",null,null,null,null,null,null,null,null,null,null,null,null,null,"Example #3: BESS for Grid Frequency Regulation"]
[]
[null,"Description:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Description:"]
[null,"This example quantifies the annual GHG emission reductions of a solar farm + BESS in Alberta.",null,null,null,null,null,null,null,null,null,null,null,null,null,"A battery in Alberta is used for fast-response grid frequency regulation."]
[]
[]
[null,"Project",null,null,null,null,null,"Baseline",null,null,null,null,null,null,null,"Project",null,null,null,null,null,"Baseline"]
[]
[]
[null,"Please select component from dropdown below:",null,null,null,null,null,"Please select component from dropdown below:",null,null,null,null,null,null,null,"Please select component from dropdown below:",null,null,null,null,null,"Please select component from dropdown below:"]
[null,"NEW bulk generation",null,"Reduction/displacement type:","Direct",null,null,"EXISTING bulk generation",null,"Reduction/displacement type:","Direct",null,null,null,null,"NEW energy storage",null,"Reduction/displacement type:","Direct",null,null,"EXISTING bulk generation",null,"Reduction/displacement type:","Direct"]
[null,"P.1.",null,null,null,null,null,"B.1.",null,null,null,null,null,null,null,"P.6.",null,null,null,null,null,"B.1."]
[]
[null,"Parameter","Value","Unit","Notes",null,null,"Parameter","Value","Unit","Notes",null,null,null,null,"Parameter","Value","Unit","Notes",null,null,"Parameter","Value","Unit","Notes"]
[null,"Amount of electricity generated by the solar",25000000,"kWh/year","Capacity factor of 37.5%",null,null,"Amount of electricity generated by the solar",25000000,"kWh/year",null,null,null,null,null,"Energy capacity",120,"MWh",null,null,null,"Round trip efficiency",88,"%"]
[null,"Unit conversion",{"$f":"C115/1000","v":25000},"MWh/year",null,null,null,"Unit conversion",{"$f":"I115/1000","v":25000},"MWh/year",null,null,null,null,null,"Storage duration",4,"hours",null,null,null,"Electricity displaced by battery discharging",{"$f":"Q120*W115/100","v":56774.193548387091}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planned cycles per year",500,"cycles/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capacity per year",60000,"MWh/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charging efficiency",93,"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity consumed for charging",{"$f":"Q118/Q119*100","v":64516.129032258061},"MWh/year"]
[null,"*Add parameter(s) as required",null,null,null,null,null,"*Add parameter(s) as required",null,null,null,null,null,null,null,"*Add parameter(s) as required",null,null,null,null,null,"*Add parameter(s) as required"]
[null,null,null,null,"EF Description",null,null,null,null,null,"EF Description",null,null,null,null,null,null,null,"EF Description",null,null,null,null,null,"EF Description"]
[null,"Emission factor (EF)",{"$f":"'3. Data'!C54","v":4.8890000000000003E-2},"tCO2e/MWh","Life cycle emission factor for solar PV per NREL",null,null,"Emission factor (EF)",0.39850000000000002,"tCO2e/MWh","Life cycle emission factor for natural gas (unspecified), assuming new electricity generation will displace equivalent volume of natural gas generation as the marginal resource.",null,null,null,null,"Emission factor (EF)",{"$f":"AVERAGE('3. Data'!H32:R32)","v":7.798181818181818E-2},"tCO2e/MWh","AB average grid emission factor from 2030 to 2040.",null,null,"Emission factor (EF)",0.39850000000000002,"tCO2e/MWh","Life cycle emission factor for natural gas (unspecified), assuming electricity in battery will displace an equivalent amount of electricity generated by natural gas, as the FFR resource. This number may become lower as more low-carbon energy resources capable of FFR come online - this evolution is reflected in tab 6."]
[]
[null,"Emissions (annual)",{"$f":"C116*C123","v":1222.25},"tCO2e/year",null,null,null,"Emissions (annual)",{"$f":"I116*I123","v":9962.5},"tCO2e/year",null,null,null,null,null,"Emissions (annual)",{"$f":"Q120*Q123","v":5031.0850439882697},"tCO2e/year",null,null,null,"Emissions (annual)",{"$f":"W116*W123","v":22624.516129032258},"tCO2e/year"]
[]
[]
[null,"Please select component from dropdown below:",null,null,null,null,null,"Please select component from dropdown below:",null,null,null,null,null,null,null,"DIRECT:",null,null,null,null,null,"DIRECT:"]
[null,"NEW energy storage",null,"Reduction/displacement type:","Direct",null,null,"EXISTING bulk generation",null,"Reduction/displacement type:","Direct",null,null,null,null,"Total project emissions (annual):",{"$f":"SUMIF(S111,\"Direct\",Q125)","v":5031.0850439882697},"tCO2e/year",null,null,null,"Total baseline emissions (annual):",{"$f":"SUMIF(Y111,\"Direct\",W125)","v":22624.516129032258},"tCO2e/year"]
[null,"P.1.",null,null,null,null,null,"B.1."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDIRECT:",null,null,null,null,null,"INDIRECT:"]
[null,"Parameter","Value","Unit","Notes",null,null,"Parameter","Value","Unit","Notes",null,null,null,null,"Total project emissions (annual):",{"$f":"SUMIF(S111,\"Indirect\",Q125)","v":0},"tCO2e/year",null,null,null,"Total baseline emissions (annual):",{"$f":"SUMIF(Y111,\"Indirect\",W125)","v":0},"tCO2e/year"]
[null,"Clipped generation per year",1000000,"kWh/year","From project economic model",null,null,"Electricity consumed for charging",{"$f":"SUM(C133:C135)","v":4500000},"kWh/year"]
[null,"Solar arbitrage per year",2000000,"kWh/year","From project economic model",null,null,"Unit conversion",{"$f":"I133/1000","v":4500},"MWh/year"]
[null,"Grid arbitrage per year",1500000,"kWh/year","From project economic model",null,null,"Round trip efficiency",90,"%"]
[null,"Clipped generation emission factor",{"$f":"'3. Data'!C54","v":4.8890000000000003E-2},"tCO2e/MWh","Life cycle emission factor for solar PV per NREL",null,null,"Generation displaced by the BESS",{"$f":"I134*I135/100","v":4050},"MWh/year"]
[null,"Solar arbitrage emission factor",{"$f":"'3. Data'!C69","v":0.45},"tCO2e/MWh","Solar energy is stored during periods of low prices. It displaces grid energy that would otherwise be stored for grid arbitrage. Emission intensity during these periods varies but is largely based on natural gas-fired combined cycle generation, which is the EF used here. "]
[null,"Grid arbitrage emission factor",{"$f":"'3. Data'!C69","v":0.45},"tCO2e/MWh","Similar to the above, emission intensity during low-price periods varies but is largely based on natural gas-fired combined cycle generation at the margin, which is the EF used here. This is a conservative assumption as it does not take into account wind generation that can also be part of the marginal resource mix during periods of low demand. "]
[null,"Weighted average emission factor",{"$f":"(C136*C133+C137*C134+C138*C135)/(C133+C134+C135)","v":0.36086444444444443},"tCO2e/MWh"]
[null,"Electricity consumed for charging",{"$f":"C133+C134+C135","v":4500000},"kWh/year"]
[null,"Unit conversion",{"$f":"C140/1000","v":4500},"MWh/year"]
[]
[]
[]
[]
[null,"*Add parameter(s) as required",null,null,null,null,null,"*Add parameter(s) as required"]
[null,null,null,null,"EF Description",null,null,null,null,null,"EF Description"]
[null,"Emission factor (EF)",{"$f":"C139","v":0.36086444444444443},"tCO2e/MWh","Weighted average emission factor as calculated above",null,null,"Emission factor (EF)",0.7,"tCO2e/MWh","The BESS releases stored energy during peak demand periods, when emission intensity is driven by coal plants converted to use gas for its boilers per the most recent AESO Long Term Outlook. Converted coal-to-gas plants operate with lower efficiency than typical gas plants. Coal-to-gas planned retirements are reflected in tab 6. The emission factor used here yields a conservative estimate of baseline emissions as line losses are not taken into account. "]
[]
[null,"Emissions (annual)",{"$f":"C148*C141","v":1623.8899999999999},"tCO2e/year",null,null,null,"Emissions (annual)",{"$f":"I148*I136","v":2835},"tCO2e/year"]
[]
[]
[null,"DIRECT:",null,null,null,null,null,"DIRECT:"]
[null,"Total project emissions (annual):",{"$f":"SUMIF(E111,\"Direct\",C125)+SUMIF(E129,\"Direct\",C150)","v":2846.14},"tCO2e/year",null,null,null,"Total baseline emissions (annual):",{"$f":"SUMIF(K111,\"Direct\",I125)+SUMIF(K129,\"Direct\",I150)","v":12797.5},"tCO2e/year"]
[]
[null,"INDIRECT:",null,null,null,null,null,"INDIRECT:"]
[null,"Total project emissions (annual):",0,"tCO2e/year",null,null,null,"Total baseline emissions (annual):",{"$f":"SUMIF(K129,\"Indirect\",I150)","v":0},"tCO2e/year"]

{"sheet":"5. Calculations","index":5,"n_rows":91,"n_cols":45,"rows_kept":91,"cut":false,"hidden":false,"merged":[[26,1,26,4],[26,7,26,10],[6,2,6,3],[7,2,7,3],[12,1,14,4],[19,1,21,4]]}
[]
[null,"GHG Balance"]
[]
[]
[null,"REFERENCE DOCUMENTS"]
[]
[null,"1. CSA ISO 14064-2:20","Specification with guidance at the project level for quantification, monitoring and reporting of greenhouse gas emission reductions or removal enhancements."]
[null,"2. The GHG Protocol for Project Accounting","The Project Protocol provides specific principles, concepts, and methods for quantifying and reporting GHG reductions from climate change mitigation projects."]
[]
[]
[null,"Instructions:"]
[]
[null,"STEP 1. In the project template, select a component from the dropdown.\n\nSTEP 2. Fill in the table by specifying the parameter, value, unit, and inserting notes, where applicable. Please refer to the examples in the '4. Examples' sheet for guidance on how to fill out the table.\n\n*Please note that if you would like to use 'Variable Electricity Generation Estimates' (recorded in the '2. Scoping' sheet), please proceed to STEP 3.\n\nSTEP 3. Select an emission factor from the '3. Data' sheet and specify its units. Please describe the emission factor in the 'EF Description' field.\n\n*Please note that if you would like to use 'Average Grid Intensity Factors' (recorded in cells C32 - AB44 in the '3. Data' sheet), please click on Button 1. ('1. Use Average Grid Intensity Factors'). Note that the outputs from this calculation will be displayed on the '6. Summary' sheet.\n\n*If you entered 'Variable Electricity Generation Estimates' in the '2. Scoping' sheet and would like to use these values in your calculation, please ensure that you have selected an emission factor and then click on Button 2. ('2. Use Variable Electricity Generation Estimates'). Note that the outputs from this calculation will be displayed on the '6. Summary' sheet.\n\n*If you would like to use 'Average Grid Intensity Factors' AND 'Variable Electricity Generation Estimates', please click on Button 3. ('3. Use Both'). This button will use 'Average Grid Intensity Factors' from the '3. Data' sheet and the values you entered in cells C66 - C91 of the '2. Scoping' sheet to calculate annual emissions [reductions/displacements] for every year of operation. Note that the outputs from this calculation will be displayed on the '6. Summary' sheet.\n\nSTEP 4. Write a formula to calculate annual project-related emissions using the selected emission factor and values recorded in the table. The ouput MUST be in units of tCO2e/year.\n\nSTEP 5. Repeat STEPS 1. - 4. for the baseline in the baseline template.\n\nSTEP 6. Where the project has more than one component, please repeat STEPS 1. - 5. using the template tables."]
[]
[]
[]
[]
[null,"Notes:"]
[]
[null,"- Should you need additional tables, please email the program: cmif-fimc@nrcan-rncan.gc.ca\n\n- Please review the example calculations found in the previous sheet before filling in the tables below."]
[]
[]
[]
[]
[]
[]
[null,"Project",null,null,null,null,null,"Baseline"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average Grid Intensity Facotrs OR Variable Electricity Generation Estimates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"Please select component from dropdown below:",null,null,null,null,null,"Please select component from dropdown below:"]
[null,"NEW bulk generation",null,"Reduction/displacement type:",{"$f":"IF(VLOOKUP(B31,Table5[[Component Category]:[Type of GHG Emission '[Dropdown']]],4,FALSE)=0,\"\",VLOOKUP(B31,Table5[[Component Category]:[Type of GHG Emission '[Dropdown']]],4,FALSE))","v":"Direct"},null,null,"EXISTING bulk generation",null,"Reduction/displacement type:",{"$f":"IF(VLOOKUP(H31,Table12[[Component Category]:[Type of GHG Emission Reduction/Displacement '[Dropdown']]],4,FALSE)=0,\"\",VLOOKUP(H31,Table12[[Component Category]:[Type of GHG Emission Reduction/Displacement '[Dropdown']]],4,FALSE))","v":""},null,null,null,null,{"$f":"B31","v":"NEW bulk generation"},{"$f":"B32","v":"P.1."},null,null,{"$f":"$H$31","v":"EXISTING bulk generation"},{"$f":"$H$32","v":"B.1."},null,null,{"$f":"$B$49","v":"NEW bulk generation"},{"$f":"$B$50","v":"P.1."},null,null,{"$f":"$H$49","v":"EXISTING bulk generation"},{"$f":"$H$50","v":"B.1."},null,null,{"$f":"$B$67","v":"NEW bulk generation"},{"$f":"$B$68","v":"P.1."},null,null,{"$f":"$H$67","v":"EXISTING bulk generation"},{"$f":"$H$68","v":"B.1."},null,null,"Total - Direct",null,null,null,"Total - Direct"]
[null,{"$f":"INDEX(Table5[Component Index],MATCH(B31,Table5[Component Category],0))","v":"P.1."},null,null,null,null,null,{"$f":"INDEX(Table12[Component Index],MATCH(H31,Table12[Component Category],0))","v":"B.1."},null,null,null,null,null,null,null,{"$f":"E31","v":"Direct"},null,null,null,{"$f":"$K$31","v":""},null,null,null,{"$f":"$E$49","v":"Direct"},null,null,null,{"$f":"$K$49","v":""},null,null,null,{"$f":"$E$67","v":"Direct"},null,null,null,{"$f":"$K$67","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Emissions Array",null,null,null,"Baseline Emissions Array",null,null,null,"Project Emissions Array",null,null,null,"Baseline Emissions Array",null,null,null,"Project Emissions Array",null,null,null,"Baseline Emissions Array",null,null,null,"Project Emissions Array",null,null,null,"Baseline Emissions Array"]
[null,"Parameter","Value","Unit","Notes",null,null,"Parameter","Value","Unit","Notes",null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,{"$f":"IF($P$32=\"Direct\",P34,0)+IF($X$32=\"Direct\",X34,0)+IF($AF$32=\"Direct\",AF34)","v":0},"tCO2e/year",null,null,{"$f":"IF($T$32=\"Direct\",T34,0)+IF($AB$32=\"Direct\",AB34,0)+IF($AJ$32=\"Direct\",AJ34,0)","v":0},"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,"*Add parameter as required",null,null,null,null,null,"*Add parameter as required",null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,"EF Description",null,null,null,null,null,"EF Description",null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,"Emission factor (EF)",null,"Please enter unit here",null,null,null,"Emission factor (EF)",null,"Please enter unit here",null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,"Emissions (annual)",{"$f":"C38*C43","v":0},"tCO2e/year",null,null,null,"Emissions (annual)",{"$f":"I38*I43","v":0},"tCO2e/year",null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,"Please select component from dropdown below:",null,null,null,null,null,"Please select component from dropdown below:",null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,"NEW bulk generation",null,"Reduction/displacement type:",{"$f":"IF(VLOOKUP(B49,Table5[[Component Category]:[Type of GHG Emission '[Dropdown']]],4,FALSE)=0,\"\",VLOOKUP(B49,Table5[[Component Category]:[Type of GHG Emission '[Dropdown']]],4,FALSE))","v":"Direct"},null,null,"EXISTING bulk generation",null,"Reduction/displacement type:",{"$f":"IF(VLOOKUP(H49,Table12[[Component Category]:[Type of GHG Emission Reduction/Displacement '[Dropdown']]],4,FALSE)=0,\"\",VLOOKUP(H49,Table12[[Component Category]:[Type of GHG Emission Reduction/Displacement '[Dropdown']]],4,FALSE))","v":""},null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,{"$f":"INDEX(Table5[Component Index],MATCH(B49,Table5[Component Category],0))","v":"P.1."},null,null,null,null,null,{"$f":"INDEX(Table12[Component Index],MATCH(H49,Table12[Component Category],0))","v":"B.1."},null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,"Parameter","Value","Unit","Notes",null,null,"Parameter","Value","Unit","Notes",null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,"*Add parameter as required",null,null,null,null,null,"*Add parameter as required",null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,"EF Description",null,null,null,null,null,"EF Description",null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,"Emission factor (EF)",null,"Please enter unit here",null,null,null,"Emission factor (EF)",null,"Please enter unit here",null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0]
[null,"Emissions (annual)",null,"tCO2e/year",null,null,null,"Emissions (annual)",null,"tCO2e/year",null,null,null,null,null,0,{"$f":"$B$32","v":"P.1."},null,null,{"$f":"$H$31","v":"EXISTING bulk generation"},{"$f":"$H$32","v":"B.1."},null,null,0,{"$f":"$B$50","v":"P.1."},null,null,{"$f":"$H$49","v":"EXISTING bulk generation"},{"$f":"$H$50","v":"B.1."},null,null,{"$f":"$B$67","v":"NEW bulk generation"},{"$f":"$B$68","v":"P.1."},null,null,{"$f":"$H$67","v":"EXISTING bulk generation"},{"$f":"$H$68","v":"B.1."},null,null,"Total - Direct",null,null,null,"Total - Direct"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"$K$31","v":""},null,null,null,0,null,null,null,{"$f":"$K$49","v":""},null,null,null,{"$f":"$E$67","v":"Direct"},null,null,null,{"$f":"$K$67","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"Baseline Emissions Array",null,null,null,0,null,null,null,"Baseline Emissions Array",null,null,null,"Project Emissions Array",null,null,null,"Baseline Emissions Array",null,null,null,"Project Emissions Array",null,null,null,"Baseline Emissions Array"]
[null,"Please select component from dropdown below:",null,null,null,null,null,"Please select component from dropdown below:",null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,{"$f":"IF($P$64=\"Direct\",P66,0)+IF($X$64=\"Direct\",X66,0)+IF($AF$64=\"Direct\",AF66,0)","v":0},"tCO2e/year",null,null,{"$f":"IF($T$64=\"Direct\",T66,0)+IF($AB$64=\"Direct\",AB66,0)+IF($AJ$64=\"Direct\",AJ66,0)","v":0},"tCO2e/year"]
[null,"NEW bulk generation",null,"Reduction/displacement type:",{"$f":"IF(VLOOKUP(B67,Table5[[Component Category]:[Type of GHG Emission '[Dropdown']]],4,FALSE)=0,\"\",VLOOKUP(B67,Table5[[Component Category]:[Type of GHG Emission '[Dropdown']]],4,FALSE))","v":"Direct"},null,null,"EXISTING bulk generation",null,"Reduction/displacement type:",{"$f":"IF(VLOOKUP(H67,Table12[[Component Category]:[Type of GHG Emission Reduction/Displacement '[Dropdown']]],4,FALSE)=0,\"\",VLOOKUP(H67,Table12[[Component Category]:[Type of GHG Emission Reduction/Displacement '[Dropdown']]],4,FALSE))","v":""},null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,{"$f":"INDEX(Table5[Component Index],MATCH(B67,Table5[Component Category],0))","v":"P.1."},null,null,null,null,null,{"$f":"INDEX(Table12[Component Index],MATCH(H67,Table12[Component Category],0))","v":"B.1."},null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,"Parameter","Value","Unit","Notes",null,null,"Parameter","Value","Unit","Notes",null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,"*Add parameter as required",null,null,null,null,null,"*Add parameter as required",null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,"EF Description",null,null,null,null,null,"EF Description",null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,"Emission factor (EF)",null,"Please enter unit here",null,null,null,"Emission factor (EF)",null,"Please enter unit here",null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,"Emissions (annual)",null,"tCO2e/year",null,null,null,"Emissions (annual)",null,"tCO2e/year",null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,"DIRECT:",null,null,null,null,null,"DIRECT:",null,null,null,null,null,null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,"Total project emissions (annual):",{"$f":"SUMIF(E31,\"Direct\",C45)+SUMIF(E49,\"Direct\",C63)+SUMIF(E67,\"Direct\",C81)","v":0},"tCO2e/year",null,null,null,"Total baseline emissions (annual):",{"$f":"SUMIF(K31,\"Direct\",I45)+SUMIF(K49,\"Direct\",I63)+SUMIF(K67,\"Direct\",I81)","v":0},"tCO2e/year",null,null,null,null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,"INDIRECT:",null,null,null,null,null,"INDIRECT:",null,null,null,null,null,null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,"Total project emissions (annual):",{"$f":"SUMIF(E31,\"Indirect\",C45)+SUMIF(E49,\"Indirect\",C63)+SUMIF(E67,\"Indirect\",C81)","v":0},"tCO2e/year",null,null,null,"Total baseline emissions (annual):",{"$f":"SUMIF(K31,\"Indirect\",I45)+SUMIF(K49,\"Indirect\",I63)+SUMIF(K67,\"Indirect\",I81)","v":0},"tCO2e/year",null,null,null,null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,null,"tCO2e/year",null,null,0,"tCO2e/year",null,null,0,"tCO2e/year"]

{"sheet":"6. Summary","index":6,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[16,1,16,2],[17,1,17,2],[6,5,6,7],[6,1,6,3],[33,3,33,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[43,3,43,4],[44,3,44,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[63,3,63,4],[64,3,64,4],[3,1,4,8],[20,1,20,8],[58,3,58,4],[59,3,59,4],[60,3,60,4],[61,3,61,4],[62,3,62,4],[53,3,53,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[48,3,48,4],[49,3,49,4]]}
[]
[null,"Summary"]
[]
[null,"GHG Balance"]
[]
[]
[null,"Direct",null,null,null,"Indirect"]
[]
[null,"Total project emissions (annual):",{"$f":"IF('1b. Basic info'!F63=\"\",'5. Calculations'!C85,'1b. Basic info'!F63)","v":0},"tCO2e/year",null,"Total project emissions (annual):",{"$f":"'5. Calculations'!C88","v":0},"tCO2e/year"]
[null,"Total baseline emissions (annual):",{"$f":"IF('1b. Basic info'!G63=\"\",'5. Calculations'!I85,'1b. Basic info'!G63)","v":0},"tCO2e/year",null,"Total baseline emisisons (annual):",{"$f":"'5. Calculations'!I88","v":0},"tCO2e/year"]
[]
[null,"Net emissions (annual) [DIRECT]:",{"$f":"C10-C9","v":0},"tCO2e/year",null,"Net emissions (annual) [INDIRECT]:",{"$f":"G10-G9","v":0},"tCO2e/year"]
[null,null,{"$f":"IF(OR(SUM('5. Calculations'!AN34:AN59)<>0,SUM('5. Calculations'!AR34:AR59)<>0,SUM('5. Calculations'!AN66:AN91)<>0,SUM('5. Calculations'!AR66:AR91)<>0),\"*Baseline emissions and/or Project emissions vary from year to year. Please consult summary table below.\",\"\")","v":""}]
[null,"Average annual percentage reduction:",{"$f":"(C12+'1b. Basic info'!D3G12)/(C10+G10)","v":{"$error":"#NAME?"}}]
[null,"Quantification of future GHG emission reductions/displacements [DIRECT]"]
[]
[null,"Calendar year project is commissioned and achieves actual emission reductions or displacements:"]
[null,"Life of funded technology, product, or service (years):"]
[]
[null,"Description of variability:"]
[null,"If applicable, please describe any expected change in the anticipated volume of greenhouse gas emission reductions or displacements over time and the reason for this variability."]
[]
[]
[null,"Year","Baseline emissions (tCO2e/year)","Change in baseline emissions (%)",null,"Project emissions (tCO2e/year)","Change in project emissions (%)","Total annual emission reductions/displacements (tCO2e/year)","Cumulative emission reductions/displacements (tCO2e)"]
[null,{"$f":"D17","v":0},{"$f":"IF(B25<>\"\",IF('5. Calculations'!AR66=0,IF('5. Calculations'!AR34=0,C10,'5. Calculations'!AR34),'5. Calculations'!AR66),0)","v":0},0,null,{"$f":"IF(B25<>\"\",IF('5. Calculations'!AN66=0,IF('5. Calculations'!AN34=0,C9,'5. Calculations'!AN34),'5. Calculations'!AN66),0)","v":0},0,{"$f":"C25-F25","v":0},{"$f":"H25","v":0}]
[null,{"$f":"IFERROR(IF((B25+1)>($D$17+$D$18),\"\",(B25+1)),\"\")","v":""},{"$f":"IF(B26<>\"\",IF(B26>2050,(C25+(D26*C25)),IF('5. Calculations'!AR67=0,IF('5. Calculations'!AR35=0,(C25+(D26*C25)),'5. Calculations'!AR35),'5. Calculations'!AR67)),0)","v":0},null,null,{"$f":"IF(B26<>\"\",IF(B26>2050,(F25+(G26*F25)),IF('5. Calculations'!AN67=0,IF('5. Calculations'!AN35=0,(F25+(G26*F25)),'5. Calculations'!AN35),'5. Calculations'!AN67)),0)","v":0},null,{"$f":"C26-F26","v":0},{"$f":"I25+H26","v":0}]
[null,{"$f":"IFERROR(IF((B26+1)>($D$17+$D$18),\"\",(B26+1)),\"\")","v":""},{"$f":"IF(B27<>\"\",IF(B27>2050,(C26+(D27*C26)),IF('5. Calculations'!AR68=0,IF('5. Calculations'!AR36=0,(C26+(D27*C26)),'5. Calculations'!AR36),'5. Calculations'!AR68)),0)","v":0},null,null,{"$f":"IF(B27<>\"\",IF(B27>2050,(F26+(G27*F26)),IF('5. Calculations'!AN68=0,IF('5. Calculations'!AN36=0,(F26+(G27*F26)),'5. Calculations'!AN36),'5. Calculations'!AN68)),0)","v":0},null,{"$f":"C27-F27","v":0},{"$f":"I26+H27","v":0}]
[null,"",{"$f":"IF(B28<>\"\",IF(B28>2050,(C27+(D28*C27)),IF('5. Calculations'!AR69=0,IF('5. Calculations'!AR37=0,(C27+(D28*C27)),'5. Calculations'!AR37),'5. Calculations'!AR69)),0)","v":0},null,null,{"$f":"IF(B28<>\"\",IF(B28>2050,(F27+(G28*F27)),IF('5. Calculations'!AN69=0,IF('5. Calculations'!AN37=0,(F27+(G28*F27)),'5. Calculations'!AN37),'5. Calculations'!AN69)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B29<>\"\",IF(B29>2050,(C28+(D29*C28)),IF('5. Calculations'!AR70=0,IF('5. Calculations'!AR38=0,(C28+(D29*C28)),'5. Calculations'!AR38),'5. Calculations'!AR70)),0)","v":0},null,null,{"$f":"IF(B29<>\"\",IF(B29>2050,(F28+(G29*F28)),IF('5. Calculations'!AN70=0,IF('5. Calculations'!AN38=0,(F28+(G29*F28)),'5. Calculations'!AN38),'5. Calculations'!AN70)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B30<>\"\",IF(B30>2050,(C29+(D30*C29)),IF('5. Calculations'!AR71=0,IF('5. Calculations'!AR39=0,(C29+(D30*C29)),'5. Calculations'!AR39),'5. Calculations'!AR71)),0)","v":0},null,null,{"$f":"IF(B30<>\"\",IF(B30>2050,(F29+(G30*F29)),IF('5. Calculations'!AN71=0,IF('5. Calculations'!AN39=0,(F29+(G30*F29)),'5. Calculations'!AN39),'5. Calculations'!AN71)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B31<>\"\",IF(B31>2050,(C30+(D31*C30)),IF('5. Calculations'!AR72=0,IF('5. Calculations'!AR40=0,(C30+(D31*C30)),'5. Calculations'!AR40),'5. Calculations'!AR72)),0)","v":0},null,null,{"$f":"IF(B31<>\"\",IF(B31>2050,(F30+(G31*F30)),IF('5. Calculations'!AN72=0,IF('5. Calculations'!AN40=0,(F30+(G31*F30)),'5. Calculations'!AN40),'5. Calculations'!AN72)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B32<>\"\",IF(B32>2050,(C31+(D32*C31)),IF('5. Calculations'!AR73=0,IF('5. Calculations'!AR41=0,(C31+(D32*C31)),'5. Calculations'!AR41),'5. Calculations'!AR73)),0)","v":0},null,null,{"$f":"IF(B32<>\"\",IF(B32>2050,(F31+(G32*F31)),IF('5. Calculations'!AN73=0,IF('5. Calculations'!AN41=0,(F31+(G32*F31)),'5. Calculations'!AN41),'5. Calculations'!AN73)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B33<>\"\",IF(B33>2050,(C32+(D33*C32)),IF('5. Calculations'!AR74=0,IF('5. Calculations'!AR42=0,(C32+(D33*C32)),'5. Calculations'!AR42),'5. Calculations'!AR74)),0)","v":0},null,null,{"$f":"IF(B33<>\"\",IF(B33>2050,(F32+(G33*F32)),IF('5. Calculations'!AN74=0,IF('5. Calculations'!AN42=0,(F32+(G33*F32)),'5. Calculations'!AN42),'5. Calculations'!AN74)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B34<>\"\",IF(B34>2050,(C33+(D34*C33)),IF('5. Calculations'!AR75=0,IF('5. Calculations'!AR43=0,(C33+(D34*C33)),'5. Calculations'!AR43),'5. Calculations'!AR75)),0)","v":0},null,null,{"$f":"IF(B34<>\"\",IF(B34>2050,(F33+(G34*F33)),IF('5. Calculations'!AN75=0,IF('5. Calculations'!AN43=0,(F33+(G34*F33)),'5. Calculations'!AN43),'5. Calculations'!AN75)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B35<>\"\",IF(B35>2050,(C34+(D35*C34)),IF('5. Calculations'!AR76=0,IF('5. Calculations'!AR44=0,(C34+(D35*C34)),'5. Calculations'!AR44),'5. Calculations'!AR76)),0)","v":0},null,null,{"$f":"IF(B35<>\"\",IF(B35>2050,(F34+(G35*F34)),IF('5. Calculations'!AN76=0,IF('5. Calculations'!AN44=0,(F34+(G35*F34)),'5. Calculations'!AN44),'5. Calculations'!AN76)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B36<>\"\",IF(B36>2050,(C35+(D36*C35)),IF('5. Calculations'!AR77=0,IF('5. Calculations'!AR45=0,(C35+(D36*C35)),'5. Calculations'!AR45),'5. Calculations'!AR77)),0)","v":0},null,null,{"$f":"IF(B36<>\"\",IF(B36>2050,(F35+(G36*F35)),IF('5. Calculations'!AN77=0,IF('5. Calculations'!AN45=0,(F35+(G36*F35)),'5. Calculations'!AN45),'5. Calculations'!AN77)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B37<>\"\",IF(B37>2050,(C36+(D37*C36)),IF('5. Calculations'!AR78=0,IF('5. Calculations'!AR46=0,(C36+(D37*C36)),'5. Calculations'!AR46),'5. Calculations'!AR78)),0)","v":0},null,null,{"$f":"IF(B37<>\"\",IF(B37>2050,(F36+(G37*F36)),IF('5. Calculations'!AN78=0,IF('5. Calculations'!AN46=0,(F36+(G37*F36)),'5. Calculations'!AN46),'5. Calculations'!AN78)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B38<>\"\",IF(B38>2050,(C37+(D38*C37)),IF('5. Calculations'!AR79=0,IF('5. Calculations'!AR47=0,(C37+(D38*C37)),'5. Calculations'!AR47),'5. Calculations'!AR79)),0)","v":0},null,null,{"$f":"IF(B38<>\"\",IF(B38>2050,(F37+(G38*F37)),IF('5. Calculations'!AN79=0,IF('5. Calculations'!AN47=0,(F37+(G38*F37)),'5. Calculations'!AN47),'5. Calculations'!AN79)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B39<>\"\",IF(B39>2050,(C38+(D39*C38)),IF('5. Calculations'!AR80=0,IF('5. Calculations'!AR48=0,(C38+(D39*C38)),'5. Calculations'!AR48),'5. Calculations'!AR80)),0)","v":0},null,null,{"$f":"IF(B39<>\"\",IF(B39>2050,(F38+(G39*F38)),IF('5. Calculations'!AN80=0,IF('5. Calculations'!AN48=0,(F38+(G39*F38)),'5. Calculations'!AN48),'5. Calculations'!AN80)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B40<>\"\",IF(B40>2050,(C39+(D40*C39)),IF('5. Calculations'!AR81=0,IF('5. Calculations'!AR49=0,(C39+(D40*C39)),'5. Calculations'!AR49),'5. Calculations'!AR81)),0)","v":0},null,null,{"$f":"IF(B40<>\"\",IF(B40>2050,(F39+(G40*F39)),IF('5. Calculations'!AN81=0,IF('5. Calculations'!AN49=0,(F39+(G40*F39)),'5. Calculations'!AN49),'5. Calculations'!AN81)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B41<>\"\",IF(B41>2050,(C40+(D41*C40)),IF('5. Calculations'!AR82=0,IF('5. Calculations'!AR50=0,(C40+(D41*C40)),'5. Calculations'!AR50),'5. Calculations'!AR82)),0)","v":0},null,null,{"$f":"IF(B41<>\"\",IF(B41>2050,(F40+(G41*F40)),IF('5. Calculations'!AN82=0,IF('5. Calculations'!AN50=0,(F40+(G41*F40)),'5. Calculations'!AN50),'5. Calculations'!AN82)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B42<>\"\",IF(B42>2050,(C41+(D42*C41)),IF('5. Calculations'!AR83=0,IF('5. Calculations'!AR51=0,(C41+(D42*C41)),'5. Calculations'!AR51),'5. Calculations'!AR83)),0)","v":0},null,null,{"$f":"IF(B42<>\"\",IF(B42>2050,(F41+(G42*F41)),IF('5. Calculations'!AN83=0,IF('5. Calculations'!AN51=0,(F41+(G42*F41)),'5. Calculations'!AN51),'5. Calculations'!AN83)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B43<>\"\",IF(B43>2050,(C42+(D43*C42)),IF('5. Calculations'!AR84=0,IF('5. Calculations'!AR52=0,(C42+(D43*C42)),'5. Calculations'!AR52),'5. Calculations'!AR84)),0)","v":0},null,null,{"$f":"IF(B43<>\"\",IF(B43>2050,(F42+(G43*F42)),IF('5. Calculations'!AN84=0,IF('5. Calculations'!AN52=0,(F42+(G43*F42)),'5. Calculations'!AN52),'5. Calculations'!AN84)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B44<>\"\",IF(B44>2050,(C43+(D44*C43)),IF('5. Calculations'!AR85=0,IF('5. Calculations'!AR53=0,(C43+(D44*C43)),'5. Calculations'!AR53),'5. Calculations'!AR85)),0)","v":0},null,null,{"$f":"IF(B44<>\"\",IF(B44>2050,(F43+(G44*F43)),IF('5. Calculations'!AN85=0,IF('5. Calculations'!AN53=0,(F43+(G44*F43)),'5. Calculations'!AN53),'5. Calculations'!AN85)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B45<>\"\",IF(B45>2050,(C44+(D45*C44)),IF('5. Calculations'!AR86=0,IF('5. Calculations'!AR54=0,(C44+(D45*C44)),'5. Calculations'!AR54),'5. Calculations'!AR86)),0)","v":0},null,null,{"$f":"IF(B45<>\"\",IF(B45>2050,(F44+(G45*F44)),IF('5. Calculations'!AN86=0,IF('5. Calculations'!AN54=0,(F44+(G45*F44)),'5. Calculations'!AN54),'5. Calculations'!AN86)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B46<>\"\",IF(B46>2050,(C45+(D46*C45)),IF('5. Calculations'!AR87=0,IF('5. Calculations'!AR55=0,(C45+(D46*C45)),'5. Calculations'!AR55),'5. Calculations'!AR87)),0)","v":0},null,null,{"$f":"IF(B46<>\"\",IF(B46>2050,(F45+(G46*F45)),IF('5. Calculations'!AN87=0,IF('5. Calculations'!AN55=0,(F45+(G46*F45)),'5. Calculations'!AN55),'5. Calculations'!AN87)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B47<>\"\",IF(B47>2050,(C46+(D47*C46)),IF('5. Calculations'!AR88=0,IF('5. Calculations'!AR56=0,(C46+(D47*C46)),'5. Calculations'!AR56),'5. Calculations'!AR88)),0)","v":0},null,null,{"$f":"IF(B47<>\"\",IF(B47>2050,(F46+(G47*F46)),IF('5. Calculations'!AN88=0,IF('5. Calculations'!AN56=0,(F46+(G47*F46)),'5. Calculations'!AN56),'5. Calculations'!AN88)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B48<>\"\",IF(B48>2050,(C47+(D48*C47)),IF('5. Calculations'!AR89=0,IF('5. Calculations'!AR57=0,(C47+(D48*C47)),'5. Calculations'!AR57),'5. Calculations'!AR89)),0)","v":0},null,null,{"$f":"IF(B48<>\"\",IF(B48>2050,(F47+(G48*F47)),IF('5. Calculations'!AN89=0,IF('5. Calculations'!AN57=0,(F47+(G48*F47)),'5. Calculations'!AN57),'5. Calculations'!AN89)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B49<>\"\",IF(B49>2050,(C48+(D49*C48)),IF('5. Calculations'!AR90=0,IF('5. Calculations'!AR58=0,(C48+(D49*C48)),'5. Calculations'!AR58),'5. Calculations'!AR90)),0)","v":0},null,null,{"$f":"IF(B49<>\"\",IF(B49>2050,(F48+(G49*F48)),IF('5. Calculations'!AN90=0,IF('5. Calculations'!AN58=0,(F48+(G49*F48)),'5. Calculations'!AN58),'5. Calculations'!AN90)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B50<>\"\",IF(B50>2050,(C49+(D50*C49)),IF('5. Calculations'!AR91=0,IF('5. Calculations'!AR59=0,(C49+(D50*C49)),'5. Calculations'!AR59),'5. Calculations'!AR91)),0)","v":0},null,null,{"$f":"IF(B50<>\"\",IF(B50>2050,(F49+(G50*F49)),IF('5. Calculations'!AN91=0,IF('5. Calculations'!AN59=0,(F49+(G50*F49)),'5. Calculations'!AN59),'5. Calculations'!AN91)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B51<>\"\",IF(B51>2050,(C50+(D51*C50)),IF('5. Calculations'!AR92=0,IF('5. Calculations'!AR60=0,(C50+(D51*C50)),'5. Calculations'!AR60),'5. Calculations'!AR92)),0)","v":0},null,null,{"$f":"IF(B51<>\"\",IF(B51>2050,(F50+(G51*F50)),IF('5. Calculations'!AN92=0,IF('5. Calculations'!AN60=0,(F50+(G51*F50)),'5. Calculations'!AN60),'5. Calculations'!AN92)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B52<>\"\",IF(B52>2050,(C51+(D52*C51)),IF('5. Calculations'!AR93=0,IF('5. Calculations'!AR61=0,(C51+(D52*C51)),'5. Calculations'!AR61),'5. Calculations'!AR93)),0)","v":0},null,null,{"$f":"IF(B52<>\"\",IF(B52>2050,(F51+(G52*F51)),IF('5. Calculations'!AN93=0,IF('5. Calculations'!AN61=0,(F51+(G52*F51)),'5. Calculations'!AN61),'5. Calculations'!AN93)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B53<>\"\",IF(B53>2050,(C52+(D53*C52)),IF('5. Calculations'!AR94=0,IF('5. Calculations'!AR62=0,(C52+(D53*C52)),'5. Calculations'!AR62),'5. Calculations'!AR94)),0)","v":0},null,null,{"$f":"IF(B53<>\"\",IF(B53>2050,(F52+(G53*F52)),IF('5. Calculations'!AN94=0,IF('5. Calculations'!AN62=0,(F52+(G53*F52)),'5. Calculations'!AN62),'5. Calculations'!AN94)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B54<>\"\",IF(B54>2050,(C53+(D54*C53)),IF('5. Calculations'!AR95=0,IF('5. Calculations'!AR63=0,(C53+(D54*C53)),'5. Calculations'!AR63),'5. Calculations'!AR95)),0)","v":0},null,null,{"$f":"IF(B54<>\"\",IF(B54>2050,(F53+(G54*F53)),IF('5. Calculations'!AN95=0,IF('5. Calculations'!AN63=0,(F53+(G54*F53)),'5. Calculations'!AN63),'5. Calculations'!AN95)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B55<>\"\",IF(B55>2050,(C54+(D55*C54)),IF('5. Calculations'!AR96=0,IF('5. Calculations'!AR64=0,(C54+(D55*C54)),'5. Calculations'!AR64),'5. Calculations'!AR96)),0)","v":0},null,null,{"$f":"IF(B55<>\"\",IF(B55>2050,(F54+(G55*F54)),IF('5. Calculations'!AN96=0,IF('5. Calculations'!AN64=0,(F54+(G55*F54)),'5. Calculations'!AN64),'5. Calculations'!AN96)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B56<>\"\",IF(B56>2050,(C55+(D56*C55)),IF('5. Calculations'!AR97=0,IF('5. Calculations'!AR65=0,(C55+(D56*C55)),'5. Calculations'!AR65),'5. Calculations'!AR97)),0)","v":0},null,null,{"$f":"IF(B56<>\"\",IF(B56>2050,(F55+(G56*F55)),IF('5. Calculations'!AN97=0,IF('5. Calculations'!AN65=0,(F55+(G56*F55)),'5. Calculations'!AN65),'5. Calculations'!AN97)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B57<>\"\",IF(B57>2050,(C56+(D57*C56)),IF('5. Calculations'!AR98=0,IF('5. Calculations'!AR66=0,(C56+(D57*C56)),'5. Calculations'!AR66),'5. Calculations'!AR98)),0)","v":0},null,null,{"$f":"IF(B57<>\"\",IF(B57>2050,(F56+(G57*F56)),IF('5. Calculations'!AN98=0,IF('5. Calculations'!AN66=0,(F56+(G57*F56)),'5. Calculations'!AN66),'5. Calculations'!AN98)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B58<>\"\",IF(B58>2050,(C57+(D58*C57)),IF('5. Calculations'!AR99=0,IF('5. Calculations'!AR67=0,(C57+(D58*C57)),'5. Calculations'!AR67),'5. Calculations'!AR99)),0)","v":0},null,null,{"$f":"IF(B58<>\"\",IF(B58>2050,(F57+(G58*F57)),IF('5. Calculations'!AN99=0,IF('5. Calculations'!AN67=0,(F57+(G58*F57)),'5. Calculations'!AN67),'5. Calculations'!AN99)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B59<>\"\",IF(B59>2050,(C58+(D59*C58)),IF('5. Calculations'!AR100=0,IF('5. Calculations'!AR68=0,(C58+(D59*C58)),'5. Calculations'!AR68),'5. Calculations'!AR100)),0)","v":0},null,null,{"$f":"IF(B59<>\"\",IF(B59>2050,(F58+(G59*F58)),IF('5. Calculations'!AN100=0,IF('5. Calculations'!AN68=0,(F58+(G59*F58)),'5. Calculations'!AN68),'5. Calculations'!AN100)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B60<>\"\",IF(B60>2050,(C59+(D60*C59)),IF('5. Calculations'!AR101=0,IF('5. Calculations'!AR69=0,(C59+(D60*C59)),'5. Calculations'!AR69),'5. Calculations'!AR101)),0)","v":0},null,null,{"$f":"IF(B60<>\"\",IF(B60>2050,(F59+(G60*F59)),IF('5. Calculations'!AN101=0,IF('5. Calculations'!AN69=0,(F59+(G60*F59)),'5. Calculations'!AN69),'5. Calculations'!AN101)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B61<>\"\",IF(B61>2050,(C60+(D61*C60)),IF('5. Calculations'!AR102=0,IF('5. Calculations'!AR70=0,(C60+(D61*C60)),'5. Calculations'!AR70),'5. Calculations'!AR102)),0)","v":0},null,null,{"$f":"IF(B61<>\"\",IF(B61>2050,(F60+(G61*F60)),IF('5. Calculations'!AN102=0,IF('5. Calculations'!AN70=0,(F60+(G61*F60)),'5. Calculations'!AN70),'5. Calculations'!AN102)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B62<>\"\",IF(B62>2050,(C61+(D62*C61)),IF('5. Calculations'!AR103=0,IF('5. Calculations'!AR71=0,(C61+(D62*C61)),'5. Calculations'!AR71),'5. Calculations'!AR103)),0)","v":0},null,null,{"$f":"IF(B62<>\"\",IF(B62>2050,(F61+(G62*F61)),IF('5. Calculations'!AN103=0,IF('5. Calculations'!AN71=0,(F61+(G62*F61)),'5. Calculations'!AN71),'5. Calculations'!AN103)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B63<>\"\",IF(B63>2050,(C62+(D63*C62)),IF('5. Calculations'!AR104=0,IF('5. Calculations'!AR72=0,(C62+(D63*C62)),'5. Calculations'!AR72),'5. Calculations'!AR104)),0)","v":0},null,null,{"$f":"IF(B63<>\"\",IF(B63>2050,(F62+(G63*F62)),IF('5. Calculations'!AN104=0,IF('5. Calculations'!AN72=0,(F62+(G63*F62)),'5. Calculations'!AN72),'5. Calculations'!AN104)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B64<>\"\",IF(B64>2050,(C63+(D64*C63)),IF('5. Calculations'!AR105=0,IF('5. Calculations'!AR73=0,(C63+(D64*C63)),'5. Calculations'!AR73),'5. Calculations'!AR105)),0)","v":0},null,null,{"$f":"IF(B64<>\"\",IF(B64>2050,(F63+(G64*F63)),IF('5. Calculations'!AN105=0,IF('5. Calculations'!AN73=0,(F63+(G64*F63)),'5. Calculations'!AN73),'5. Calculations'!AN105)),0)","v":0},null,0,0]
[null,"",{"$f":"IF(B65<>\"\",IF(B65>2050,(C64+(D65*C64)),IF('5. Calculations'!AR106=0,IF('5. Calculations'!AR74=0,(C64+(D65*C64)),'5. Calculations'!AR74),'5. Calculations'!AR106)),0)","v":0},null,null,{"$f":"IF(B65<>\"\",IF(B65>2050,(F64+(G65*F64)),IF('5. Calculations'!AN106=0,IF('5. Calculations'!AN74=0,(F64+(G65*F64)),'5. Calculations'!AN74),'5. Calculations'!AN106)),0)","v":0},null,0,0]

{"sheet":"Automation Reference","index":7,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Characterization Dropdown",null,"Type of GHG Reduction",null,"Count of 'Not within project scope' - Project Components",null,"Count of 'Not within project scope' - Baseline Components"]
[null,"Emitting component",null,"Direct",null,{"$f":"COUNTIF(Table5[Characterization '[DROPDOWN']],\"Not within project scope\")","v":0},null,{"$f":"COUNTIF(Table12[Characterization '[Dropdown']],\"Not within project scope\")","v":0}]
[null,"Non-emitting component",null,"Indirect"]
[null,"Not within project scope",null,null,null,"Count of project components",null,"Count of baseline components"]
[null,null,null,null,null,{"$f":"COUNTIF(Table5[Characterization '[DROPDOWN']],\"Emitting component\")+COUNTIF(Table5[Characterization '[DROPDOWN']],\"Non-emitting component\")","v":1},null,{"$f":"COUNTIF(Table12[Characterization '[Dropdown']],\"Emitting component\")+COUNTIF(Table12[Characterization '[Dropdown']],\"Non-emitting component\")","v":0}]