{"text_format":"2","workbook":"xlsx","n_sheets":26,"sheets":["Introduction","AOI 1&2 Overview","AOI 2a Summary","AOI 2b Summary","Scope 1 - Stationary Combustion","Scope 1 - Process Emissions","Scope 1 - Purchased Gases","Scope 1 - Refrigerants","Scope 2 - Electricity","Scope 2 - Steam","Scope 2 - Hydrogen","Scope 3 - Indirect","Optional - RECs","Unit Conversions","Heat Content","Emission Factors","DropDown","Help - Stationary Combustion","Help - Refrigeration and AC","Help - Fire Suppression","Help - Purchased Gases","Help - Electricity","Help - Market-Based Method","Help - Steam","Help - Hydrogen","Sector List"],"not_rendered":{"charts":0,"images":26,"macros":0,"external_links":1,"defined_names":307,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[9,1,9,8],[10,1,10,8],[11,1,11,8],[13,1,13,8],[0,0,1,8],[2,1,6,8],[7,1,7,8],[8,1,8,8]]}
["Introduction:  40209 Application Data Sheet and Workbook"]
[]
[null,"The 40209 Application Data Sheet and Workbook is intended to allow applicants to provide required information in a consistent and complete manner. Please read the instructions on every tab to ensure that all neccesary information is included for the corresponding Area of Interest. Check that all inputs are accurate, and that the workbook formulas have produced an accurate and sensible result. \n\nApplicants also have the option to submit a Life-Cycle Assessment (LCA) as a supplement to their application.  Please see Section IV.D.xxvi of the FOA for more information and view the resources below."]
[]
[]
[]
[]
[null,"National Energy Technology Laboratory CO2U LCA Guidance Toolkit"]
[null,"Other useful documents:"]
[null,"United States Department of Energy Pathways to Commercial Liftoff: The Pathway to Industrial Decarbonization "]
[null,"United States Department of Energy Better Plants Energy Intensity Baselining and Tracking Guidance"]
[null,"Carbon Leadership Forum: 2023 North American Material Baselines Report"]
[null,"Environmentally Extended Input-Output for Industrial Decarbonization Analysis (EEIO-IDA) Tool | Department of Energy"]
[null,"International Energy Agency: Energy End-uses and Efficiency Indicators Data Explorer (subscription required for access to full dataset)"]
[]
[null,"Tabs in this Workbook"]
[null,"Data Sheets",null,"Help Tabs",null,null,"Unit / Factor References"]
[null,"AOI 1&2 Overview",null,"Help - Stationary Combustion",null,null,"Unit Conversions"]
[null,"AOI 2a Summary",null,"Help - Purchased Gases",null,null,"Heat Content"]
[null,"AOI 2b Summary",null,"Help - Refrigeration and AC",null,null,"Emission Factors"]
[null,"Scope 1 - Stationary Combustion",null,"Help - Electricity"]
[null,"Scope 1 - Process Emissions",null,"Help - Market-Based Method"]
[null,"Scope 1 - Purchased Gases",null,"Help - Steam"]
[null,"Scope 1 - Refrigerants",null,"Help - Hydrogen"]
[null,"Scope 2 - Electricity"]
[null,"Scope 2 - Steam"]
[null,"Scope 2 - Hydrogen"]
[null,"Scope 3 - Indirect"]
[null,"Optional - RECs"]

{"sheet":"AOI 1&2 Overview","index":1,"n_rows":96,"n_cols":11,"rows_kept":96,"cut":false,"hidden":false,"merged":[[69,0,83,0],[81,4,81,5],[81,6,81,8],[83,4,83,5],[83,6,83,8],[77,4,77,5],[77,6,77,8],[79,4,79,5],[79,6,79,8],[80,4,80,5],[80,6,80,8],[82,4,82,5],[82,6,82,8],[73,6,73,8],[78,4,78,5],[74,4,74,5],[75,4,75,5],[76,4,76,5],[73,4,73,5],[78,6,78,8],[76,6,76,8],[75,6,75,8],[74,6,74,8],[66,4,66,5],[67,4,67,5],[66,6,66,8],[67,6,67,8],[70,6,70,8],[71,4,71,5],[71,6,71,8],[72,4,72,5],[72,6,72,8],[69,4,69,5],[70,4,70,5],[69,6,69,8],[56,0,68,0],[44,4,44,8],[43,4,43,8],[48,4,48,8],[49,4,49,8],[68,4,68,5],[65,4,65,5],[64,4,64,5],[63,4,63,5],[62,4,62,5],[61,4,61,5],[60,4,60,5],[57,6,57,8],[56,4,56,5],[59,4,59,5],[58,4,58,5],[57,4,57,5],[56,6,56,8],[68,6,68,8],[65,6,65,8],[64,6,64,8],[63,6,63,8],[62,6,62,8],[61,6,61,8],[1,1,1,8],[2,3,2,8],[3,1,3,8],[5,4,5,8],[43,0,55,0],[32,0,42,0],[6,0,13,0],[6,4,6,8],[7,4,7,8],[8,4,8,8],[9,4,9,8],[13,4,13,8],[11,4,11,8],[34,4,34,8],[35,4,35,8],[37,4,37,8],[26,4,26,8],[27,4,27,8],[31,4,31,8],[28,4,28,8],[29,4,29,8],[30,4,30,8],[55,4,55,8],[32,4,32,8],[89,0,95,0],[92,4,92,8],[93,4,93,8],[94,4,94,8],[14,0,18,0],[14,4,14,8],[15,4,15,8],[16,4,16,8],[18,4,18,8],[19,0,31,0],[19,4,19,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[95,4,95,8],[85,4,85,8],[86,4,86,8],[88,4,88,8],[89,4,89,8],[90,4,90,8],[91,4,91,8],[41,4,41,8],[60,6,60,8],[59,6,59,8],[58,6,58,8],[39,4,39,8],[33,4,33,8],[50,4,50,8],[51,4,51,8],[52,4,52,8],[53,4,53,8],[54,4,54,8],[45,4,45,8],[46,4,46,8],[47,4,47,8]]}
[{"$nulls":10},"Back to Introduction Tab"]
[null,"Proposed Project Overview (AOI 1 or 2)"]
[null,"User Input","Calculated or from other tab","Instructions are in yellow boxes next to the corresponding inputs"]
[null,"This worksheet is used to capture information on all Proposed Projects under this FOA (Both AOI 1 and AOI 2 Proposed Projects).\n\nInput data and assumptions should be substantiated in and show clear correspondence to the applicant's project narrative.\n\nAll Applicants should fill out the relevant user input (green) cells in this Overview tab. Proposed Projects under AOI 2a and AOI 2b are required to complete the additional Scope 1, Scope 2, and Scope 3 (AOI 2b only) tabs of this workbook, with the summary of their inputs reflected in their corresponding summary tabs.\n\nData will be extracted from this workbook. Therefore, no cells, rows, or columns should be added. \n\nCash flow statement instructions: In the appendix materials, applicants should provide an investment bank quality financial model for the project. The model should quantify the projected financial parameters including operating costs, operating revenues, financing cash flows, EBITDA, tax credits/liabilities, and ROI over the project lifespan. The model should also include a list of key economic/financial assumptions as a separate tab. The model should be dynamic and not hardcoded. [Please use nominal dollars, note inflation estimator used, and the start year]\n"]
[]
[null,"Applicant Information","Input","Units","Notes"]
["Applicant Overview","Applicant Control Number",null,null,"The control number used to track the application in the DOE S3 Exchange application portal."]
[null,"Company Name"]
[null,"City (HQ)"]
[null,"State (HQ)"]
[null,"Zip Code (HQ)"]
[null,"Net Income ",null,"$","Net income of the applicant for the most recently completed fiscal year. (if applicable)"]
[null,"Projected cash on hand at the start of the federal award",null,"$"]
[null,"Debt to capital ratio",null,"%","Leverage ratio for total interest-bearing debt and liabilities by total available capital for most recently completed fiscal year."]
["Project Site Overview","City (Facility)"]
[null,"State (Facility)"]
[null,"Zip Code (Facility)"]
[null,"Census Tract (Facility)"]
[null,"EPA GHGRP ID (if applicable)",null,null,"Applicants subject to EPA GHGRP reporting should provide their GHGRP ID."]
["Proposed Project Overview","Area of Interest"]
[null,"Project Type"]
[null,"Overall Project Cost",null,"$","Total project cost, including the DOE Award Share and Applicant's Cost Share"]
[null,"Applicant's Proposed Cost Share",null,"$","The Applicant's cost share for the proposed project"]
[null,"Proposed Project Cost Share (%)",{"$f":"C23/(C22)","v":{"$error":"#DIV/0!"}},"%","Automatically calculated based on the Applicant's cost share and total project cost"]
[null,"Technology Readiness Level of the Proposed Project",null,null,"Submit the Technology Readiness Level (1-9) of the technology, equipment, or process used in the proposed project.  (See Appendix D of the FOA)"]
[null,"Facility Output Product and Units",null,null,"Brief description of the facility output product in 5 words or less (e.g., \"rebar\").\n\nIn column D, enter the unit of output for the facility, to be used in the facility production rate and calculating the facility's carbon intensity (e.g. unit of mass, volume, or other measurement of product)"]
[null,"Facility Current production rate",null,{"$f":"CONCATENATE($D$26,IF(COUNTBLANK($D$26)=1,\"[unit of output]\",\"\"),\"/year\")","v":"[unit of output]/year"},"Current annual production in the existing facility being re-equipped or expanded, if applicable.\n\nOtherwise, \"N/A\""]
[null,"Facility Future production rate",null,{"$f":"CONCATENATE($D$26,IF(COUNTBLANK($D$26)=1,\"[unit of output]\",\"\"),\"/year\")","v":"[unit of output]/year"},"Future annual production in the facility covered by the project (new facility, re-equipped, or expanded) If the project will alter annual production of an existing facility (e.g., increase or decrease output), that should be reflected here and described in the narrative."]
[null,"Current Overall Production Rate of Applicant",null,{"$f":"CONCATENATE($D$26,IF(COUNTBLANK($D$26)=1,\"[unit of output]\",\"\"),\"/year\")","v":"[unit of output]/year"},"Current annual production across all applicant facilities of the proposed project output product. "]
[null,"Number of Jobs to be Created ",null,"FTE equivalent","Quantify the number of direct, permanent jobs to be created under the proposed project.\n\n"]
[null,"Date to Begin Construction",null,"mm/dd/yyyy"]
[null,"Date to Begin Operation",null,"mm/dd/yyyy"]
["Project Finance","Project Return on Investment ",null,"$","See instructions above on the cash flow statement to be submitted"]
[null,"Weighted Average Cost of Capital ",null,"$","See instructions above on the cash flow statement to be submitted"]
[null,"Projected payback period",null,"months","See instructions above on the cash flow statement to be submitted"]
[null,"Net present value (with DOE funding)",null,"$","See instructions above on the cash flow statement to be submitted"]
[null,"Net present value (without DOE funding)",null,"$"]
[null,"Unlevered Project IRR (with DOE funding)",null,"%","See instructions above on the cash flow statement to be submitted"]
[null,"Unlevered Project IRR (without DOE funding)",null,"%"]
[null,"Break-even point (with DOE funding) ",null,"$","See instructions above on the cash flow statement to be submitted"]
[null,"Break-even point (without DOE funding) ",null,"$"]
[null,"Break-even point (with DOE funding)",null,{"$f":"CONCATENATE($D$26,IF(COUNTBLANK($D$26)=1,\"[unit of output]\",\"\"),\" sold\")","v":"[unit of output] sold"},"See instructions above on the cash flow statement to be submitted"]
[null,"Break-even point (without DOE funding) ",null,{"$f":"CONCATENATE($D$26,IF(COUNTBLANK($D$26)=1,\"[unit of output]\",\"\"),\" sold\")","v":"[unit of output] sold"}]
["Product Competitiveness ","Expected sale price",null,{"$f":"CONCATENATE(\"$/\",$D$26,IF(COUNTBLANK($D$26)=1,\"[unit of output]\",\"\"))","v":"$/[unit of output]"},"Estimated sale price per unit for the primary technology product as covered by application. "]
[null,"Unit production cost ",null,{"$f":"CONCATENATE(\"$/\",$D$26,IF(COUNTBLANK($D$26)=1,\"[unit of output]\",\"\"))","v":"$/[unit of output]"},"Estimated unit production cost for the primary technology product as covered by the application."]
[null,"Gross margin",null,"%","Estimated gross margin for the primary technology product as covered by the application."]
[null,"Unit production cost stack ",null,{"$f":"CONCATENATE(\"$/\",$D$26,IF(COUNTBLANK($D$26)=1,\"[unit of output]\",\"\"))","v":"$/[unit of output]"},"Unit cost build up for the primary technology product as covered in the application."]
[null,"Raw Materials",null,{"$f":"CONCATENATE(\"$/\",$D$26,IF(COUNTBLANK($D$26)=1,\"[unit of output]\",\"\"))","v":"$/[unit of output]"},"Cost of raw material per unit of production."]
[null,"Freight and logistics",null,"$/[unit of output]","Freight and logistics cost per unit of production."]
[null,"Labor",null,"$/[unit of output]","Labor cost per unit of production."]
[null,"Utilities",null,"$/[unit of output]","Utilities cost per unit of production. "]
[null,"Maintenance & Sustaining Capital",null,"$/[unit of output]","Maintenance and sustaining capital per unit of production. "]
[null,"SGA & Overhead",null,"$/[unit of output]","Selling, general, and administrative and overhead costs per unit of production."]
[null,"Depreciated capital",null,{"$f":"CONCATENATE(\"$/\",$D$26,IF(COUNTBLANK($D$26)=1,\"[unit of output]\",\"\"))","v":"$/[unit of output]"},"Depreciated capital per unit of production."]
[null,"Waste Disposal",null,"$/[unit of output]","Waste disposal of material scrap from production processes per unit of production."]
[null,"Other",null,"$/[unit of output]","Other categories per unit of production not captured above. "]
["Commercial Agreements related to the Proposed Project","Type ","Annual Volume (include units)","Annual Value ($)","Status",null,"Comments (for supply agreements, specify what is being supplied)\n\nIf unable to include all information in the available rows, aggregate similar commercial agreements, provide details in this comments column, and ensure that all commercial agreements are accurately reflected in the project budget"]
{"$rows_empty":10}
[null,"Total Supplier Agreements (all status)",null,{"$f":"SUMIF(B58:B67,\"Supplier\",D58:D67)","v":0}]
[null,"Total Offtake Agreements (all status)",null,{"$f":"SUMIF(B58:B67,\"Offtake\",D58:D67)","v":0}]
["Project Capital","Funding Source","Funding Type ","Funding Amount ($)","Status",null,"Comments\n\nIf unable to include all information in the available rows, aggregate similar funding sources, provide details in this comments column, and ensure that all funding sources are accurately reflected in the project budget"]
{"$rows_empty":9}
[null,"Total Equity Financing (all status)","Equity",{"$f":"SUMIF(C71:C79,C80,D71:D79)","v":0}]
[null,"Total Debt Financing (all status)","Debt",{"$f":"SUMIF(C71:C79,C81,D71:D79)","v":0}]
[null,"Total Grant Financing (all status)","Grant",{"$f":"SUMIF(C71:C79,C82,D71:D79)","v":0}]
[null,"Total Other Financing (all status)","Other",{"$f":"SUMIF(C71:C79,C83,D71:D79)","v":0}]
[null,"Total Financing (all status)","Total",{"$f":"SUM(D80:D83)","v":0}]
[null,"AOI 1 Only"]
[null,"Applicant Information","Input","Units","Notes"]
["Overview","AOI 1 Only - Eligible SAEP Category",null,null,"Select the Eligible SAEP category from the FOA Appendix I that matches the product being manufactured or recycled in the proposed project.  For AOI 2, \"N/A\""]
[null,"AOI 2 Only"]
[null,"Applicant Information","Input","Units","Notes"]
["Overview","Appropriate Industry Benchmark Carbon Intensity",null,{"$f":"CONCATENATE(\"MT CO2-e/\",IF(COUNTBLANK($D$26)=1,\"[unit of output]\",$D$26))","v":"MT CO2-e/[unit of output]"},"A “benchmark” is an assessment relative to an industry-standard best practice representing commercially available off-the-shelf technology, referred to as “state-of-the-art.” The benchmark should be justified and documented using widely recognized U.S. and/or international reference documents.\n\n“Carbon intensity” is the amount of GHG in CO2e emitted per “functional unit” or unit output (e.g., mass, volume, or other measurement of product) in an industrial process for normalized emissions and calculated on a life cycle basis. "]
[null,"Sector/Industry",null,null,"Select the sector or industry that most closely matches the facility."]
[null,"If other Sector",null,null,"If the facility's sector/industry is not listed above and \"Other\" was selected, type a freeform answer here.  Otherwise, \"N/A\""]
[null,"AOI 2a ONLY Decarbonization Approach",null,null,"Select the process change that most closely describes the greenhouse gas reduction technique.  For AOI 2b, \"N/A\""]
[null,"AOI 2a ONLY If other (or multiple) Decarbonization Approach",null,null,"If selected Other above, type a freeform answer. If secondary or multiple equipment types are used, use freeform answer to describe. Otherwise, \"N/A\""]
[null,"AOI 2b Only - Low Carbon Material",null,null,"Select the low carbon material being produced in the proposed project.  For AOI 2a, \"N/A\""]
[null,"AOI 2b ONLY If other Low Carbon Material",null,null,"If selected Other above, type a freeform answer.  Otherwise, \"N/A\""]

{"sheet":"AOI 2a Summary","index":2,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[12,7,12,8],[14,7,14,8],[11,7,11,8],[2,1,2,9],[4,4,4,5],[14,1,14,5],[4,8,4,9],[19,7,19,8],[7,1,7,5],[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,5],[12,1,12,5],[19,1,19,5],[18,1,18,5],[17,1,17,5],[16,1,16,5],[15,1,15,5]]}
[null,"AOI 2a Emissions Summary",{"$nulls":8},"Back to Introduction Tab"]
[null,"Guidance"]
[null,"This Summary Tab estimates baseline and future annual GHG emissions at the proposed project facility for AOI 2a. Columns G and J below automatically sum the baseline and proposed final project emissions from the required Scope 1, Scope 2 tabs.\n\nApplicants have the option to include information on RECs, though these will not count in the calculation of the applicants' total reductions and are merely an opportunity for the applicant to showcase additional efforts underway.\n\nThe methodology for estimating baseline and future emissions in this data sheet is based on EPA's Simplified Greenhouse Gas Calculator. While this simplified calculator may not calculate all possible emissions at a facility, it is designed to capture the major industrial Scope 1 and Scope 2 sources. Applicants have the option to submit a Life-Cycle Assessment (LCA) as a supplement to their application.  Please see Section IV.D.xxvi of the FOA for more information and view the 'Introduction' tab for a list of available resources.\n\nApplicants should complete each tab with in the most recent year-long reporting period.  If the applicant does not have a full year of data, they should annualize the available data."]
[]
[{"$nulls":7},"Project Type:",{"$f":"'AOI 1&2 Overview'!C21","v":0}]
[]
[{"$nulls":6},"Baseline",null,null,"Proposed Project"]
[null,"Total Facility Scope 1 Emissions",{"$nulls":4},{"$f":"'Scope 1 - Stationary Combustion'!F146+'Scope 1 - Process Emissions'!C53+'Scope 1 - Refrigerants'!F38+'Scope 1 - Purchased Gases'!D28","v":0},"MT CO2-e/yr",null,{"$f":"'Scope 1 - Stationary Combustion'!L146+'Scope 1 - Process Emissions'!F53+'Scope 1 - Refrigerants'!J38+'Scope 1 - Purchased Gases'!F28","v":0},"MT CO2-e/yr"]
[null,"Total Facility Scope 2 Emissions",{"$nulls":4},{"$f":"'Scope 2 - Electricity'!E61+'Scope 2 - Steam'!F84+'Scope 2 - Hydrogen'!C81","v":0},"MT CO2-e/yr",null,{"$f":"'Scope 2 - Electricity'!G61+'Scope 2 - Steam'!K84+'Scope 2 - Hydrogen'!G81","v":0},"MT CO2-e/yr"]
[null,"Total GHG Emissions",{"$nulls":4},{"$f":"SUM(G8:G9)","v":0},"MT CO2-e/yr",null,{"$f":"SUM(J8:J9)","v":0},"MT CO2-e/yr"]
[null,"RECs (Optional) - DO NOT count as emissions reductions",{"$nulls":4},{"$f":"'Optional - RECs'!C26","v":0},"MT CO2-e/yr",null,{"$f":"'Optional - RECs'!F26","v":0},"MT CO2-e/yr"]
[null,"Facility Output",{"$nulls":4},{"$f":"'AOI 1&2 Overview'!C27","v":0},{"$f":"CONCATENATE('AOI 1&2 Overview'!$D$26,IF(COUNTBLANK('AOI 1&2 Overview'!$D$26)=1,\"[unit of output]\",\"\"),\"/year\")","v":"[unit of output]/year"},null,{"$f":"'AOI 1&2 Overview'!C28","v":0},{"$f":"CONCATENATE('AOI 1&2 Overview'!$D$26,IF(COUNTBLANK('AOI 1&2 Overview'!$D$26)=1,\"[unit of output]\",\"\"),\"/year\")","v":"[unit of output]/year"}]
[null,"Carbon Intensity of Product(s)",{"$nulls":4},{"$f":"G10/G12","v":{"$error":"#DIV/0!"}},{"$f":"CONCATENATE(\"MT CO2-e/\",IF(COUNTBLANK('AOI 1&2 Overview'!$D$26)=1,\"[unit of output]\",'AOI 1&2 Overview'!$D$26))","v":"MT CO2-e/[unit of output]"},null,{"$f":"J10/J12","v":{"$error":"#DIV/0!"}},{"$f":"CONCATENATE(\"MT CO2-e/\",IF(COUNTBLANK('AOI 1&2 Overview'!$D$26)=1,\"[unit of output]\",'AOI 1&2 Overview'!$D$26))","v":"MT CO2-e/[unit of output]"}]
[]
[null,"Appropriate Industry Benchmark for carbon intensity",{"$nulls":4},{"$f":"'AOI 1&2 Overview'!C90","v":0},{"$f":"CONCATENATE(\"MT CO2-e/\",IF(COUNTBLANK('AOI 1&2 Overview'!$D$26)=1,\"[unit of output]\",'AOI 1&2 Overview'!$D$26))","v":"MT CO2-e/[unit of output]"}]
[null,"Projected reduction in total annual GHG emissions at the facility",{"$nulls":4},{"$f":"G10-J10","v":0},"MT CO2-e/yr"]
[null,"Percent reduction in total annual GHG emissions at the facility",{"$nulls":4},{"$f":"(G10-J10)/G10 * 100","v":{"$error":"#DIV/0!"}},"%"]
[null,"Percent reduction in the carbon intensity of the proposed project compared to industry benchmark",{"$nulls":4},{"$f":"(G15-J13)/G15 * 100","v":{"$error":"#DIV/0!"}},"%"]
[null,"Percent reduction in the carbon intensity of the proposed project compared to current facility",{"$nulls":4},{"$f":"(G13-J13)/G13 * 100","v":{"$error":"#DIV/0!"}},"%"]
[null,"Project cost benefit",{"$nulls":4},{"$f":"'AOI 1&2 Overview'!C22/'AOI 2a Summary'!G16","v":{"$error":"#DIV/0!"}},"$/MT CO2-e/yr"]

{"sheet":"AOI 2b Summary","index":3,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[6,7,6,8],[14,7,14,8],[19,7,19,8],[1,1,1,9],[3,4,3,5],[3,8,3,9],[17,1,17,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,5],[12,1,12,5],[12,7,12,8],[10,7,10,8],[9,7,9,8],[8,7,8,8],[18,1,18,5],[7,7,7,8],[19,1,19,5],[14,1,14,5],[15,1,15,5],[16,1,16,5],[11,7,11,8]]}
[null,"AOI 2b Emissions Summary",{"$nulls":8},"Back to Introduction Tab"]
[null,"This Summary Tab estimates baseline and future annual GHG emissions at the proposed project facility for AOI 2b. Columns G and J below automatically sum the baseline and proposed final project emissions from the required Scope 1, Scope 2, and Scope 3 tabs.\n\nApplicants have the option to include information on RECs, though these will not count in the calculation of the applicants' total reductions and are merely an opportunity for the applicant to showcase additional efforts underway.\n\nThe methodology for estimating baseline and future emissions in this data sheet is based on EPA's Simplified Greenhouse Gas Calculator. While this simplified calculator may not calculate all possible emissions at a facility, it is designed to capture the major industrial Scope 1 and Scope 2 sources. Applicants have the option to submit a Life-Cycle Assessment (LCA) as a supplement to their application.  Please see Section IV.D.xxvi of the FOA for more information and view the 'Introduction' tab for a list of available resources.\n\nFor proposed projects that are establishing a new facility, or re-equipping or expanding an existing facility that is not yet operational by the applicant, as indicated on the 'AOI 1&2 Overview' tab, baseline information will not be utilized and cells on this summary tab that rely on baseline data will automatically be marked \"N/A\" below\n\nFor proposed projects that are re-equipping or expanding an existing facility that is already owned and operated by the applicant, baseline information on the Scope 1, Scope 2, and Scope 3 tabs is required and will be considered when assessing the GHG emission reductions and carbon intensity of the proposed project.\n\nApplicants should complete each tab with in the most recent year-long reporting period.  If the applicant does not have a full year of data, they should annualize the available data.\n\nApplicants may calculate relative to sites/portions of the facility that are relevant to the specific product addressed."]
[]
[{"$nulls":7},"Project Type:",{"$f":"'AOI 1&2 Overview'!C21","v":0}]
[]
[{"$nulls":6},"Baseline",null,null,"Proposed Project"]
[null,"Total Product Scope 1 Emissions",{"$nulls":4},{"$f":"IF(OR(I4='Sector List'!B3,I4='Sector List'!B5),'Scope 1 - Stationary Combustion'!F146+'Scope 1 - Process Emissions'!C53+'Scope 1 - Refrigerants'!F38+'Scope 1 - Purchased Gases'!D28,\"N/A\")","v":"N/A"},"MT CO2-e/yr",null,{"$f":"'Scope 1 - Stationary Combustion'!L146+'Scope 1 - Process Emissions'!F53+'Scope 1 - Refrigerants'!J38+'Scope 1 - Purchased Gases'!F28","v":0},"MT CO2-e/yr"]
[null,"Total Product Scope 2 Emissions",{"$nulls":4},{"$f":"IF(OR(I4='Sector List'!B3,I4='Sector List'!B5),'Scope 2 - Electricity'!E61+'Scope 2 - Steam'!F84+'Scope 2 - Hydrogen'!C81,\"N/A\")","v":"N/A"},"MT CO2-e/yr",null,{"$f":"'Scope 2 - Electricity'!G61+'Scope 2 - Steam'!K84+'Scope 2 - Hydrogen'!G81","v":0},"MT CO2-e/yr"]
[null,"Total Product Scope 3 Emissions (if applicable)",{"$nulls":4},{"$f":"IF(OR(I4='Sector List'!B3,I4='Sector List'!B5),'Scope 3 - Indirect'!B16,\"N/A\")","v":"N/A"},"MT CO2-e/yr",null,{"$f":"'Scope 3 - Indirect'!D16","v":0},"MT CO2-e/yr"]
[null,"Total GHG Emissions",{"$nulls":4},{"$f":"IF(OR(I4='Sector List'!B3,I4='Sector List'!B5),SUM(G7:G8),\"N/A\")","v":"N/A"},"MT CO2-e/yr",null,{"$f":"SUM(J7:J8)","v":0},"MT CO2-e/yr"]
[null,"RECs (Optional) - DO NOT count as emissions reductions",{"$nulls":4},{"$f":"'Optional - RECs'!C26","v":0},"MT CO2-e/yr",null,{"$f":"'Optional - RECs'!F26","v":0},"MT CO2-e/yr"]
[null,"Facility Output",{"$nulls":4},{"$f":"IF(OR(I4='Sector List'!B3,I4='Sector List'!B5),'AOI 1&2 Overview'!C27,\"N/A\")","v":"N/A"},{"$f":"CONCATENATE('AOI 1&2 Overview'!$D$26,IF(COUNTBLANK('AOI 1&2 Overview'!$D$26)=1,\"[unit of output]\",\"\"),\"/year\")","v":"[unit of output]/year"},null,{"$f":"'AOI 1&2 Overview'!C28","v":0},{"$f":"CONCATENATE('AOI 1&2 Overview'!$D$26,IF(COUNTBLANK('AOI 1&2 Overview'!$D$26)=1,\"[unit of output]\",\"\"),\"/year\")","v":"[unit of output]/year"}]
[null,"Carbon Intensity of Product",{"$nulls":4},{"$f":"IF(OR(I4='Sector List'!B3,I4='Sector List'!B5),G10/G12,\"N/A\")","v":"N/A"},{"$f":"CONCATENATE(\"MT CO2-e/\",IF(COUNTBLANK('AOI 1&2 Overview'!$D$26)=1,\"[unit of output]\",'AOI 1&2 Overview'!$D$26))","v":"MT CO2-e/[unit of output]"},null,{"$f":"J10/J12","v":{"$error":"#DIV/0!"}},{"$f":"CONCATENATE(\"MT CO2-e/\",IF(COUNTBLANK('AOI 1&2 Overview'!$D$26)=1,\"[unit of output]\",'AOI 1&2 Overview'!$D$26))","v":"MT CO2-e/[unit of output]"}]
[]
[null,"Appropriate Industry Benchmark for carbon intensity",{"$nulls":4},{"$f":"'AOI 1&2 Overview'!C90","v":0},{"$f":"CONCATENATE(\"MT CO2-e/\",IF(COUNTBLANK('AOI 1&2 Overview'!$D$26)=1,\"[unit of output]\",'AOI 1&2 Overview'!$D$26))","v":"MT CO2-e/[unit of output]"}]
[null,"Projected reduction in total annual GHG emissions at the facility",{"$nulls":4},{"$f":"IF(OR(I4='Sector List'!B3,I4='Sector List'!B5),G10-J10,\"N/A\")","v":"N/A"},"MT CO2-e/yr"]
[null,"Percent reduction in total annual GHG emissions at the facility",{"$nulls":4},{"$f":"IF(OR(I4='Sector List'!B3,I4='Sector List'!B5),(G10-J10)/G10,\"N/A\")","v":"N/A"},"%"]
[null,"Percent reduction in the product carbon intensity of the proposed project compared to industry benchmark",{"$nulls":4},{"$f":"(G15-J13)/G15","v":{"$error":"#DIV/0!"}},"%"]
[null,"Percent reduction in the product carbon intensity of the proposed project compared to current facility",{"$nulls":4},{"$f":"IF(OR(I4='Sector List'!B3,I4='Sector List'!B5),(G13-J13)/G13,\"N/A\")","v":"N/A"},"%"]
[null,"Project cost benefit",{"$nulls":4},{"$f":"'AOI 1&2 Overview'!C22/G16","v":{"$error":"#VALUE!"}},{"$f":"CONCATENATE(\"$/MT CO2-e/\",IF(COUNTBLANK('AOI 1&2 Overview'!$D$26)=1,\"[unit of output]\",'AOI 1&2 Overview'!$D$26))","v":"$/MT CO2-e/[unit of output]"}]

{"sheet":"Scope 1 - Stationary Combustion","index":4,"n_rows":148,"n_cols":12,"rows_kept":148,"cut":false,"hidden":false,"merged":[[128,7,128,11],[133,7,133,11],[103,7,103,11],[102,7,102,8],[6,1,6,5],[7,1,7,5],[8,1,8,5],[16,8,17,8],[133,1,133,5],[122,1,122,5],[128,1,128,5],[122,7,122,11],[13,1,13,7],[3,1,3,7],[102,1,102,2],[103,1,103,5],[113,1,113,5],[118,1,118,5],[5,1,5,5],[9,1,9,7],[16,6,17,6],[65,1,66,2],[65,4,66,4],[113,7,113,11],[118,7,118,11]]}
[null,"Scope 1 Emissions from Stationary Combustion Sources",{"$nulls":8},"Back to Introduction Tab"]
[]
[null,"Guidance"]
[null,"   (A) Enter annual data for each combustion unit, facility, or site (by fuel type) in GREEN cells on Table 1. Assign a particular source ID and Source description of your choosing.  Example entry is shown in first row (Italics)."]
[null,"- Select \"Fuel Combusted\" from drop down box."]
[null,"- Enter \" Current Quantity Combusted\" and choose the appropriate units from the drop down box in the unit column.  If it's necessary to convert units, common heat contents can be found on the \"Heat Content\" sheet and unit conversions on the \"Unit Conversion\" sheet. "]
[null,"- Enter \"Future Quantity Combusted\" and choose the appropriate units from the drop down box in the unit column.  If it's necessary to convert units, common heat contents can be found on the \"Heat Content\" sheet and unit conversions on the \"Unit Conversion\" sheet. "]
[null,"- If switching fuels during the project, there should be rows for both the current and the future fuel, showing a reduction in the current fuel and an increase in the future fuel."]
[null,"- If the project involves a retrofit that impacts fuel demand (e.g., installation of CCS equipment), the stationary combustion associated with that retrofit should be incorporated here."]
[null,"   (B) If fuel is consumed in a facility but stationary fuel consumption data are not available, an estimate should be made \n         for completeness.  See the \"Items to Note\" section of the Help sheet for suggested estimation approaches. "]
[null,"(C) Biomass CO2 emissions are not reported in the total emissions, but are reported separately at the bottom of the sheet. \n      "]
[null,"    For categories that are not explicitly listed, please select the closest biomass category. \n      "]
[]
[null,"For proposed projects that are establishing a new facility, or re-equipping or expanding an existing facility that is not yet operational by the applicant, baseline or \"current\" information on all tabs may be omitted."]
[]
[null,"Table 1.  Stationary Source Fuel Combustion"]
[null,"Source","Source","Fuel","Fuel State","Current Annual Quantity","Units","Future Annual Quantity","Units"]
[null,"Name/ID","Description","Combusted","(solid, liquid, gas)","Combusted",null,"Combusted"]
[null,"Example: Boiler 1","Natural gas boiler","Natural Gas",{"$f":"IF(D19=\"\",\"\",VLOOKUP(D19,DropDown!$S$2:$T$28,2,FALSE))","v":"Gas"},10000,"MMBtu",5000,"MMBtu"]
[{"$nulls":4},{"$f":"IF(D20=\"\",\"\",VLOOKUP(D20,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[]
[{"$nulls":4},{"$f":"IF(D22=\"\",\"\",VLOOKUP(D22,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D23=\"\",\"\",VLOOKUP(D23,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D24=\"\",\"\",VLOOKUP(D24,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D25=\"\",\"\",VLOOKUP(D25,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D26=\"\",\"\",VLOOKUP(D26,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D27=\"\",\"\",VLOOKUP(D27,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D28=\"\",\"\",VLOOKUP(D28,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D29=\"\",\"\",VLOOKUP(D29,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D31=\"\",\"\",VLOOKUP(D31,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D32=\"\",\"\",VLOOKUP(D32,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D33=\"\",\"\",VLOOKUP(D33,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D34=\"\",\"\",VLOOKUP(D34,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D35=\"\",\"\",VLOOKUP(D35,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D36=\"\",\"\",VLOOKUP(D36,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D37=\"\",\"\",VLOOKUP(D37,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D38=\"\",\"\",VLOOKUP(D38,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D39=\"\",\"\",VLOOKUP(D39,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D40=\"\",\"\",VLOOKUP(D40,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D41=\"\",\"\",VLOOKUP(D41,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D42=\"\",\"\",VLOOKUP(D42,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D43=\"\",\"\",VLOOKUP(D43,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D44=\"\",\"\",VLOOKUP(D44,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D46=\"\",\"\",VLOOKUP(D46,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D47=\"\",\"\",VLOOKUP(D47,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D48=\"\",\"\",VLOOKUP(D48,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D49=\"\",\"\",VLOOKUP(D49,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D50=\"\",\"\",VLOOKUP(D50,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D51=\"\",\"\",VLOOKUP(D51,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D52=\"\",\"\",VLOOKUP(D52,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D53=\"\",\"\",VLOOKUP(D53,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D54=\"\",\"\",VLOOKUP(D54,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D55=\"\",\"\",VLOOKUP(D55,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D56=\"\",\"\",VLOOKUP(D56,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D57=\"\",\"\",VLOOKUP(D57,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D58=\"\",\"\",VLOOKUP(D58,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D59=\"\",\"\",VLOOKUP(D59,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D60=\"\",\"\",VLOOKUP(D60,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D61=\"\",\"\",VLOOKUP(D61,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(D62=\"\",\"\",VLOOKUP(D62,DropDown!$S$2:$T$28,2,FALSE))","v":""}]
[]
[]
[null,"Current Organization-Wide Stationary Source Combustion by Fuel Type",{"$nulls":5},"Future Organization-Wide Stationary Source Combustion by Fuel Type"]
[null,"Fuel Type",null,"Quantity","Units",null,null,"Fuel Type",null,"Quantity","Units"]
[null,null,null,"Combusted",{"$nulls":5},"Combusted"]
[null,"Coal and Coke - Solid",{"$nulls":5},"Coal and Coke - Solid"]
[null,"Anthracite Coal",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B69,$G$20:$G$62,E69)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B69,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B69,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton",null,null,"Anthracite Coal",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B69,$I$20:$I$62,K69)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B69,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H69,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton"]
[null,"Bituminous Coal",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B70,$G$20:$G$62,E70)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B70,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B70,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton",null,null,"Bituminous Coal",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B70,$I$20:$I$62,K70)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B70,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H70,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton"]
[null,"Sub-bituminous Coal",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B71,$G$20:$G$62,E71)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B71,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B71,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton",null,null,"Sub-bituminous Coal",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B71,$I$20:$I$62,K71)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B71,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H71,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton"]
[null,"Lignite Coal",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B72,$G$20:$G$62,E72)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B72,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B72,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton",null,null,"Lignite Coal",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B72,$I$20:$I$62,K72)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B72,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H72,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton"]
[null,"Mixed (Commercial Sector)",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B73,$G$20:$G$62,E73)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B73,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B73,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton",null,null,"Mixed (Commercial Sector)",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B73,$I$20:$I$62,K73)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B73,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H73,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton"]
[null,"Mixed (Electric Power Sector)",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B74,$G$20:$G$62,E74)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B74,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B74,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton",null,null,"Mixed (Electric Power Sector)",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B74,$I$20:$I$62,K74)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B74,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H74,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton"]
[null,"Mixed (Industrial Coking)",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B75,$G$20:$G$62,E75)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B75,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B75,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton",null,null,"Mixed (Industrial Coking)",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B75,$I$20:$I$62,K75)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B75,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H75,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton"]
[null,"Mixed (Industrial Sector)",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B76,$G$20:$G$62,E76)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B76,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B76,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton",null,null,"Mixed (Industrial Sector)",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B76,$I$20:$I$62,K76)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B76,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H76,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton"]
[null,"Coal Coke",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B77,$G$20:$G$62,E77)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B77,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B77,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton",null,null,"Coal Coke",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B77,$I$20:$I$62,K77)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B77,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H77,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton"]
[null,"Other Fuels - Solid",{"$nulls":5},"Other Fuels - Solid"]
[null,"Municipal Solid Waste",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B79,$G$20:$G$62,E79)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B79,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B79,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton",null,null,"Municipal Solid Waste",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B79,$I$20:$I$62,K79)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B79,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H79,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton"]
[null,"Petroleum Coke (Solid)",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B80,$G$20:$G$62,E80)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B80,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B80,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton",null,null,"Petroleum Coke (Solid)",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B80,$I$20:$I$62,K80)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B80,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H80,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton"]
[null,"Plastics",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B81,$G$20:$G$62,E81)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B81,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B81,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton",null,null,"Plastics",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B81,$I$20:$I$62,K81)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B81,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H81,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton"]
[null,"Tires",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B82,$G$20:$G$62,E82)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B82,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B82,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton",null,null,"Tires",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B82,$I$20:$I$62,K82)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B82,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H82,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton"]
[null,"Biomass Fuels - Solid",{"$nulls":5},"Biomass Fuels - Solid"]
[null,"Agricultural Byproducts",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B84,$G$20:$G$62,E84)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B84,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B84,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton",null,null,"Agricultural Byproducts",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B84,$I$20:$I$62,K84)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B84,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H84,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton"]
[null,"Peat",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B85,$G$20:$G$62,E85)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B85,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B85,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton",null,null,"Peat",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B85,$I$20:$I$62,K85)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B85,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H85,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton"]
[null,"Solid Byproducts",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B86,$G$20:$G$62,E86)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B86,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B86,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton",null,null,"Solid Byproducts",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B86,$I$20:$I$62,K86)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B86,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H86,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton"]
[null,"Wood and Wood Residuals",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B87,$G$20:$G$62,E87)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B87,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B87,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton",null,null,"Wood and Wood Residuals",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B87,$I$20:$I$62,K87)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B87,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H87,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"short ton"]
[null,"Gaseous Fuels",{"$nulls":5},"Gaseous Fuels"]
[null,"Natural Gas",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B89,$G$20:$G$62,E89)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B89,$G$20:$G$62,\"MMBtu\")*Natural_Gas_scf_per_mmBtu)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B89,$G$20:$G$62,\"Therm\")*Natural_Gas_scf_per_therm)","v":0},"scf",null,null,"Natural Gas",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B89,$I$20:$I$62,K89)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B89,$I$20:$I$62,\"MMBtu\")*Natural_Gas_scf_per_mmBtu)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B89,$I$20:$I$62,\"Therm\")*Natural_Gas_scf_per_therm)","v":0},"scf"]
[null,"Propane Gas",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B90,$G$20:$G$62,E90)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B90,$G$20:$G$62,\"MMBtu\")*Propane_Gas_scf_per_mmBtu)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B90,$G$20:$G$62,\"Therm\")*Propane_Gas_scf_per_therm)","v":0},"scf",null,null,"Propane Gas",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B90,$G$20:$G$62,K90)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B90,$I$20:$I$62,\"MMBtu\")*Propane_Gas_scf_per_mmBtu)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B90,$I$20:$I$62,\"Therm\")*Propane_Gas_scf_per_therm)","v":0},"scf"]
[null,"Landfill Gas",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B91,$G$20:$G$62,E91)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B91,$G$20:$G$62,\"MMBtu\")*Landfill_Gas_scf_per_mmBtu)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B91,$G$20:$G$62,\"Therm\")*Landfill_Gas_scf_per_therm)","v":0},"scf",null,null,"Landfill Gas",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B91,$I$20:$I$62,K91)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B91,$I$20:$I$62,\"MMBtu\")*Landfill_Gas_scf_per_mmBtu)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B91,$I$20:$I$62,\"Therm\")*Landfill_Gas_scf_per_therm)","v":0},"scf"]
[null,"Petroleum Products",{"$nulls":5},"Petroleum Products"]
[null,"Distillate Fuel Oil No. 2",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B93,$G$20:$G$62,E93)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B93,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B93,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"gallons",null,null,"Distillate Fuel Oil No. 2",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B93,$I$20:$I$62,K93)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B93,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H93,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"gallons"]
[null,"Residual Fuel Oil No. 6",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B94,$G$20:$G$62,E94)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B94,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B94,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"gallons",null,null,"Residual Fuel Oil No. 6",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B94,$I$20:$I$62,K94)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B94,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H94,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"gallons"]
[null,"Kerosene",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B95,$G$20:$G$62,E95)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B95,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B95,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"gallons",null,null,"Kerosene",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B95,$I$20:$I$62,K95)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B95,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H95,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"gallons"]
[null,"Liquefied Petroleum Gases (LPG)",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B96,$G$20:$G$62,E96)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B96,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B96,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"gallons",null,null,"Liquefied Petroleum Gases (LPG)",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B96,$I$20:$I$62,K96)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B96,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H96,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"gallons"]
[null,"Biomass Fuels - Liquid",{"$nulls":5},"Biomass Fuels - Liquid"]
[null,"Biodiesel (100%)",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B98,$G$20:$G$62,E98)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B98,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B98,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"gallons",null,null,"Biodiesel (100%)",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B98,$I$20:$I$62,K98)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B98,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H98,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"gallons"]
[null,"Ethanol (100%)",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B99,$G$20:$G$62,E99)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B99,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B99,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"gallons",null,null,"Ethanol (100%)",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B99,$I$20:$I$62,K99)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B99,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H99,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"gallons"]
[null,"Vegetable Oil",null,{"$f":"SUMIFS($F$20:$F$62,$D$20:$D$62,$B100,$G$20:$G$62,E100)+(SUMIFS($F$20:$F$62,$D$20:$D$62,$B100,$G$20:$G$62,\"MMBtu\")*(VLOOKUP(B100,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"gallons",null,null,"Vegetable Oil",null,{"$f":"SUMIFS($H$20:$H$62,$D$20:$D$62,$B100,$I$20:$I$62,K100)+(SUMIFS($H$20:$H$62,$D$20:$D$62,$B100,$I$20:$I$62,\"MMBtu\")*(VLOOKUP(H100,'Heat Content'!$A$12:$E$38,4,0)))","v":0},"gallons"]
[]
[null,"Current Organization-Wide CO2, CH4 and N2O Emissions from Stationary Source Fuel Combustion",{"$nulls":5},"Future Organization-Wide CO2, CH4 and N2O Emissions from Stationary Source Fuel Combustion"]
[null,"Fuel Type",null,"CO2 (kg)","CH4 (g)","N2O (g)",null,"Fuel Type",null,"CO2 (kg)","CH4 (g)","N2O (g)"]
[null,"Coal and Coke - Solid",{"$nulls":5},"Coal and Coke - Solid"]
[null,"Anthracite Coal",null,{"$f":"_xlfn.XLOOKUP($B105,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B105,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B105,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B105,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B105,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B105,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0},null,"Anthracite Coal",null,{"$f":"_xlfn.XLOOKUP($H105,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B105,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H105,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B105,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H105,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B105,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
[null,"Bituminous Coal",null,0,0,0,null,"Bituminous Coal",null,0,0,0]
[null,"Sub-bituminous Coal",null,0,0,0,null,"Sub-bituminous Coal",null,0,0,0]
[null,"Lignite Coal",null,0,0,0,null,"Lignite Coal",null,0,0,0]
[null,"Mixed (Commercial Sector)",null,0,0,0,null,"Mixed (Commercial Sector)",null,0,0,0]
[null,"Mixed (Electric Power Sector)",null,0,0,0,null,"Mixed (Electric Power Sector)",null,0,0,0]
[null,"Mixed (Industrial Coking)",null,0,0,0,null,"Mixed (Industrial Coking)",null,0,0,0]
[null,"Mixed (Industrial Sector)",null,0,0,0,null,"Mixed (Industrial Sector)",null,0,0,0]
[null,"Coal Coke",null,0,0,0,null,"Coal Coke",null,0,0,0]
[null,"Other Fuels - Solid",{"$nulls":5},"Other Fuels - Solid"]
[null,"Municipal Solid Waste",null,{"$f":"_xlfn.XLOOKUP($B115,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B115,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B115,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B115,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B115,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B115,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0},null,"Municipal Solid Waste",null,{"$f":"_xlfn.XLOOKUP($H115,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B115,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H115,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B115,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H115,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B115,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
[null,"Petroleum Coke (Solid)",null,{"$f":"_xlfn.XLOOKUP($B116,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B116,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B116,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B116,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B116,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B116,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0},null,"Petroleum Coke (Solid)",null,{"$f":"_xlfn.XLOOKUP($H116,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B116,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H116,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B116,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H116,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B116,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
[null,"Plastics",null,{"$f":"_xlfn.XLOOKUP($B117,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B117,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B117,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B117,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B117,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B117,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0},null,"Plastics",null,{"$f":"_xlfn.XLOOKUP($H117,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B117,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H117,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B117,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H117,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B117,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
[null,"Tires",null,{"$f":"_xlfn.XLOOKUP($B118,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B118,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B118,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B118,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B118,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B118,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0},null,"Tires",null,{"$f":"_xlfn.XLOOKUP($H118,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B118,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H118,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B118,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H118,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B118,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
[null,"Gaseous Fuels",{"$nulls":5},"Gaseous Fuels"]
[null,"Natural Gas",null,{"$f":"_xlfn.XLOOKUP($B120,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B120,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B120,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B120,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B120,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B120,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0},null,"Natural Gas",null,{"$f":"_xlfn.XLOOKUP($H120,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B120,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H120,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B120,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H120,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B120,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
[null,"Propane Gas",null,{"$f":"_xlfn.XLOOKUP($B121,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B121,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B121,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B121,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B121,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B121,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0},null,"Propane Gas",null,{"$f":"_xlfn.XLOOKUP($H121,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B121,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H121,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B121,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H121,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B121,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
[null,"Landfill Gas",null,{"$f":"_xlfn.XLOOKUP($B122,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B122,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B122,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B122,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B122,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B122,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0},null,"Landfill Gas",null,{"$f":"_xlfn.XLOOKUP($H122,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B122,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H122,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B122,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H122,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B122,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
[null,"Petroleum Products",{"$nulls":5},"Petroleum Products"]
[null,"Distillate Fuel Oil No. 2",null,{"$f":"_xlfn.XLOOKUP($B124,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B124,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B124,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B124,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B124,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B124,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0},null,"Distillate Fuel Oil No. 2",null,{"$f":"_xlfn.XLOOKUP($H124,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B124,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H124,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B124,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H124,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B124,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
[null,"Residual Fuel Oil No. 6",null,{"$f":"_xlfn.XLOOKUP($B125,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B125,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B125,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B125,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B125,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B125,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0},null,"Residual Fuel Oil No. 6",null,{"$f":"_xlfn.XLOOKUP($H125,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B125,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H125,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B125,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H125,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B125,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
[null,"Kerosene",null,{"$f":"_xlfn.XLOOKUP($B126,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B126,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B126,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B126,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B126,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B126,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0},null,"Kerosene",null,{"$f":"_xlfn.XLOOKUP($H126,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B126,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H126,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B126,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H126,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B126,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
[null,"Liquefied Petroleum Gases (LPG)",null,{"$f":"_xlfn.XLOOKUP($B127,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B127,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B127,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B127,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B127,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B127,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0},null,"Liquefied Petroleum Gases (LPG)",null,{"$f":"_xlfn.XLOOKUP($H127,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B127,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H127,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B127,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H127,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B127,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
[null,"Total Fossil Fuel Emissions",null,{"$f":"SUM(D104:D127)","v":0},{"$f":"SUM(E104:E127)","v":0},0,null,"Total Fossil Fuel Emissions",null,{"$f":"SUM(J104:J127)","v":0},{"$f":"SUM(K104:K127)","v":0},0]
[null,"Biomass Fuels - Solid",{"$nulls":5},"Biomass Fuels - Solid"]
[null,"Agricultural Byproducts",null,{"$f":"_xlfn.XLOOKUP($B130,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B130,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B130,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B130,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B130,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B130,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0},null,"Agricultural Byproducts",null,{"$f":"_xlfn.XLOOKUP($H130,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B130,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H130,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B130,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H130,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B130,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
[null,"Peat",null,{"$f":"_xlfn.XLOOKUP($B131,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B131,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B131,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B131,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B131,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B131,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0},null,"Peat",null,{"$f":"_xlfn.XLOOKUP($H131,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B131,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H131,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B131,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H131,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B131,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
[null,"Solid Byproducts",null,{"$f":"_xlfn.XLOOKUP($B132,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B132,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B132,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B132,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B132,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B132,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0},null,"Solid Byproducts",null,{"$f":"_xlfn.XLOOKUP($H132,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B132,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H132,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B132,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H132,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B132,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
[null,"Wood and Wood Residuals",null,{"$f":"_xlfn.XLOOKUP($B133,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B133,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B133,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B133,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($B133,$B$69:$B$100,$D$69:$D$100)*VLOOKUP($B133,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0},null,"Wood and Wood Residuals",null,{"$f":"_xlfn.XLOOKUP($H133,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B133,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H133,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B133,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"_xlfn.XLOOKUP($H133,$H$69:$H$100,$J$69:$J$100)*VLOOKUP($B133,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
[null,"Biomass Fuels - Liquid",{"$nulls":5},"Biomass Fuels - Liquid"]
[null,"Biodiesel (100%)",null,{"$f":"$D98*VLOOKUP($B135,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"$D98*VLOOKUP($B135,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"$D98*VLOOKUP($B135,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0},null,"Biodiesel (100%)",null,{"$f":"$J98*VLOOKUP($H135,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"$J98*VLOOKUP($H135,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"$J98*VLOOKUP($H135,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
[null,"Ethanol (100%)",null,{"$f":"$D99*VLOOKUP($B136,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"$D99*VLOOKUP($B136,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"$D99*VLOOKUP($B136,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0},null,"Ethanol (100%)",null,{"$f":"$J99*VLOOKUP($H136,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"$J99*VLOOKUP($H136,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"$J99*VLOOKUP($H136,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
[null,"Vegetable Oil",null,{"$f":"$D100*VLOOKUP($B137,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"$D100*VLOOKUP($B137,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"$D100*VLOOKUP($B137,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0},null,"Vegetable Oil",null,{"$f":"$J100*VLOOKUP($H137,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"$J100*VLOOKUP($H137,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"$J100*VLOOKUP($H137,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
[null,"Total Non-Fossil Fuel Emissions",null,{"$f":"SUM(D130:D137)","v":0},{"$f":"SUM(E130:E137)","v":0},{"$f":"SUM(F130:F137)","v":0},null,"Total Non-Fossil Fuel Emissions",null,{"$f":"SUM(J130:J137)","v":0},{"$f":"SUM(K130:K137)","v":0},{"$f":"SUM(L130:L137)","v":0}]
[null,"Total Emissions for all Fuels",null,{"$f":"D128+D138","v":0},{"$f":"E128+E138","v":0},{"$f":"F128+F138","v":0},null,"Total Emissions for all Fuels",null,{"$f":"J128+J138","v":0},{"$f":"K128+K138","v":0},{"$f":"L128+L138","v":0}]
[]
[]
[]
[]
[{"$nulls":5},"Current Emissions",{"$nulls":5},"Future Emissions"]
[]
[null,"Total CO2 Equivalent Emissions  (metric tons) - Stationary Combustion",null,null,null,{"$f":"(D128+(E128/1000*CH4_GWP)+(F128/1000*N2O_GWP)+(E138/1000*CH4_GWP)+(F138/1000*N2O_GWP))/1000","v":0},null,"Total CO2 Equivalent Emissions  (metric tons) - Stationary Combustion",null,null,null,{"$f":"(J128+(K128/1000*CH4_GWP)+(L128/1000*N2O_GWP)+(K138/1000*CH4_GWP)+(L138/1000*N2O_GWP))/1000","v":0}]
[]
[null,"Total Biomass CO2 Equivalent Emissions  (metric tons)  - Stationary Combustion",null,null,null,{"$f":"(D138/1000)","v":0},null,"Total Biomass CO2 Equivalent Emissions  (metric tons)  - Stationary Combustion",null,null,null,{"$f":"(J138/1000)","v":0}]

{"sheet":"Scope 1 - Process Emissions","index":5,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[[3,0,3,4],[4,0,4,4],[8,2,8,4],[52,2,52,4],[8,5,8,7],[52,5,52,7],[6,0,6,4]]}
["Scope 1 Process Emissions",{"$nulls":9},"Back to Introduction Tab"]
[]
["Guidance"]
["  (A)  Any release of CO2, CH4, or N2O due to the production process (not associated with combustion) is required to be included in the GHG inventory. For instance, cement manufacturers should report on annual greenhouse gases from clinker production. Assign a particular source ID of your choosing (this can be referenced in the 'Project' tab)."]
["  (B) Describe the process emissions source and input the associated annual GHG emissions in lbs. These are converted to CO2-equivalent emissions at the bottom of the sheet."]
[]
["For proposed projects that are establishing a new facility, or re-equipping or expanding an existing facility that is not yet operational by the applicant, baseline or \"current\" information on all tabs may be omitted."]
[]
["Table 1.  Total Emissions from Production Processes",null,"Current Annual Emissions",null,null,"Future Annual Emissions"]
["Source","Source","CO2","CH4 ","N2O ","CO2","CH4 ","N2O "]
["Name/ID","Description","Emissions","Emissions","Emissions","Emissions","Emissions","Emissions"]
[null,null,"(lb)","(lb)","(lb)","(lb)","(lb)","(lb)"]
["Kiln 1","Cement kiln",50000,0,0,10000,0,0]
{"$rows_empty":37}
["Total Emissions for All Sources",null,{"$f":"SUM(C14:C50)","v":0},{"$f":"SUM(D14:D50)","v":0},{"$f":"SUM(E14:E50)","v":0},0,0,0]
[]
["Total GHG Emissions (metric tons CO2-e)",null,{"$f":"($C$51+$D$51*CH4_GWP+$E$51*N2O_GWP)*kg_per_lb/1000","v":0},null,null,{"$f":"($F$51+$G$51*CH4_GWP+$H$51*N2O_GWP)*kg_per_lb/1000","v":0}]

{"sheet":"Scope 1 - Purchased Gases","index":6,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,0,3,7],[4,0,4,7],[5,0,5,7],[10,2,10,3],[10,4,10,5],[8,0,8,7]]}
["Scope 1 Emissions from Purchased Gases",{"$nulls":9},"Back to Introduction Tab"]
[]
["Guidance"]
["  (A)  Any use and release of the seven major greenhouse gases (CO2, CH4, N2O, PFCs, HFCs, SF6, and NF3) is required to be included in the  \n        GHG inventory. Ozone depleting substances, such as CFCs and HCFCs, are regulated internationally and are typically excluded from a \n        GHG inventory or reported as a memo item."]
["  (B) Select the gas you purchase from the drop down menu and the amount purchased for the annual inventory reporting period in the \n        ORANGE cells. "]
["  (C) It is assumed that all gas purchased in the reporting period used and released during the reporting period.  If your business makes  \n        bulk purchases and plans on using the gas for several years, divide the bulk amount by the years of usage and report that amount.   "]
["Tip: If you purchase bulk gas, remember to report it for future years as well."]
[]
["For proposed projects that are establishing a new facility, or re-equipping or expanding an existing facility that is not yet operational by the applicant, baseline or \"current\" information on all tabs may be omitted."]
[]
["Table 1.  Purchased Gases",null,"Current Annual Purchases",null,"Future Annual Purchases"]
["Gas","Gas","Purchased","CO2 Equivalent","Purchased","CO2 Equivalent"]
[null,"GWP","Amount","Emissions","Amount","Emissions"]
[null,null,"(lb)","(lb)","(lb)","(lb)"]
[null,{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,GWP,2,FALSE))","v":""},null,{"$f":"IF(B15=\"\", \"\",B15*C15)","v":""},null,{"$f":"IF(D15=\"\", \"\",D15*E15)","v":""}]
[null,"",null,{"$f":"IF(B16=\"\", \"\",B16*C16)","v":""},null,{"$f":"IF(D16=\"\", \"\",D16*E16)","v":""}]
[null,"",null,"",null,""]
[null,"",null,"",null,""]
[null,"",null,"",null,""]
[null,"",null,"",null,""]
[null,"",null,"",null,""]
[null,"",null,"",null,""]
[null,"",null,"",null,""]
[null,"",null,"",null,""]
[null,"",null,"",null,""]
[]
[null,null,null,"Current",null,"Future"]
["Total CO2 Equivalent Emissions  (metric tons) - Purchased Gas",null,null,{"$f":"SUM(D15:D25)*kg_per_lb/1000","v":0},null,{"$f":"SUM(F15:F25)*kg_per_lb/1000","v":0}]
[]
["Notes:"]
["1.  GWPs are from Intergovernmental Panel on Climate Change (IPCC) Fourth Assessment Report (2007).  "]

{"sheet":"Scope 1 - Refrigerants","index":7,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[36,0,37,4],[3,0,3,7],[4,0,4,7],[19,2,19,5],[19,6,19,9],[36,6,37,8],[15,0,15,7]]}
["Scope 1 Emissions from Refrigeration and Air Conditioning Equipment",{"$nulls":9},"Back to Introduction Tab"]
[]
["Guidance"]
["  (A)  HFC, PFC, CO2, and SF6 refrigerants from facilities and vehicles are required to be included in the GHG inventory.  Ozone depleting \n         substances, such as CFCs and HCFCs, are regulated internationally and are typically excluded from a GHG inventory or reported \n         as a memo item. "]
["  (B) Enter annual data in GREEN cells as appropriate."]
["                  - Inventory Change = difference of gas stored in inventory from beginning to end of reporting period."]
["                    (Includes only gas stored on-site (i.e. cylinders) and not gas contained within equipment)."]
["                  - Transferred Amount = gas purchased minus gas sold/disposed during reporting period."]
["                      -- Gas purchased includes:  Purchases for inventory, as part of equipment servicing (not from inventory),"]
["                         within purchased equipment, and gas returned to the site after off-site recycling."]
["                      -- Gas sold/disposed includes:  Returns to supplier, sales or disposals (including within equipment), "]
["                         and gas sent off-site for recycling, reclamation, or destruction."]
["                  - Capacity Change = capacity of all units at beginning minus capacity of all units at end of reporting period."]
["                    (can be assumed to be capacity of retired units minus capacity of new units)."]
[]
["For proposed projects that are establishing a new facility, or re-equipping or expanding an existing facility that is not yet operational by the applicant, baseline or \"current\" information on all tabs may be omitted."]
[]
[]
["Table 1.  Organization-Wide Refrigeration Gas CO2 Equivalent Emissions - Material Balance"]
[null,null,"Current Annual Inventory",null,null,null,"Future Annual Inventory"]
["Gas","Gas","Inventory","Transferred","Capacity","CO2 Equivalent","Inventory","Transferred","Capacity","CO2 Equivalent"]
[null,"GWP","Change","Amount","Change","Emissions","Change","Amount","Change","Emissions"]
[null,null,"(lb)","(lb)","(lb)","(lb)","(lb)","(lb)","(lb)","(lb)"]
["CF4",{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,GWP,2,FALSE))","v":7390},null,null,null,{"$f":"IF(B24=\"\", \"\",IF(($C24+$D24+$E24)*$B24<0,0,($C24+$D24+$E24)*$B24))","v":0},null,null,null,{"$f":"IF(B24=\"\", \"\",IF(($G24+$H24+$I24)*$B24<0,0,($G24+$H24+$I24)*$B24))","v":0}]
[null,{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,GWP,2,FALSE))","v":""},null,null,null,"",null,null,null,{"$f":"IF(F25=\"\", \"\",IF(($C25+$D25+$E25)*$B25<0,0,($C25+$D25+$E25)*$B25))","v":""}]
[null,"",null,null,null,"",null,null,null,""]
[null,"",null,null,null,{"$f":"IF(B27=\"\", \"\",IF(($C27+$D27+$E27)*$B27<0,0,($C27+$D27+$E27)*$B27))","v":""},null,null,null,{"$f":"IF(F27=\"\", \"\",IF(($C27+$D27+$E27)*$B27<0,0,($C27+$D27+$E27)*$B27))","v":""}]
[null,"",null,null,null,"",null,null,null,{"$f":"IF(F28=\"\", \"\",IF(($C28+$D28+$E28)*$B28<0,0,($C28+$D28+$E28)*$B28))","v":""}]
[null,"",null,null,null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,null,""]
[null,"",null,null,null,"",null,null,null,""]
[]
[]
["Total CO2 Equivalent Emissions  (metric tons) - Refrigeration and AC Equipment",{"$nulls":4},"Current",null,null,null,"Future"]
[{"$nulls":5},{"$f":"SUM($F$24:$F$34)","v":0},null,null,null,{"$f":"SUM($F$24:$F$34)","v":0}]
[]
["Notes:"]
["1.  CO2 emissions estimated using emission factors provided in Table 3 of the Center for Corporate Climate Leadership Greenhouse Gas Inventory Guidance"]
["    Direct Fugitive Emissions from Refrigeration, Air Conditioning, Fire Suppression and Industrial Gases. (Dec 2020)."]
["2.  GWPs are from Intergovernmental Panel on Climate Change (IPCC) Fourth Assessment Report (2007).  "]

{"sheet":"Scope 2 - Electricity","index":8,"n_rows":68,"n_cols":24,"rows_kept":68,"cut":false,"hidden":false,"merged":[[10,0,10,3],[13,15,13,17],[13,18,13,23],[14,15,14,17],[14,18,14,20],[14,21,14,23],[12,0,12,3],[13,0,13,3],[13,5,13,7],[13,8,13,13],[14,5,14,7],[14,8,14,10],[14,11,14,13],[9,0,9,3],[3,0,3,3],[4,0,4,3],[5,0,5,3],[6,0,6,3],[7,0,7,3]]}
["Scope 2 Emissions from Purchase of Electricity",{"$nulls":9},"Back to Introduction Tab"]
[]
["Guidance"]
["The Indirect Emissions from Purchased Electricity Guidance document provides guidance for quantifying two scope 2 emissions totals, using a location-based method and a procurement-based method.  The organization should quantify and report both totals in its GHG inventory.  The location-based method considers average emission factors for the electricity grids that provide electricity.  The procurement-based method considers contractual arrangements under which the organization procures electricity from specific sources, such as renewable energy.  \n\nApplicants who wish to demonstrate emissions savings on the basis of marginal grid emissions factors are welcome to submit an alternative accounting in their supplementary materials."]
["(A)  Enter total annual electricity purchased in kWh and each eGRID subregion for each facility or site in GREEN cells of Table 1.  Enter a source ID (this can be referenced in the 'Project' tab). "]
["(B)  If electricity consumption data are not available for a facility, an estimate should be made for completeness.  \n        See the \"Items to Note\" section of the Help sheet for suggested estimation approaches. "]
["(C)  Select \"eGRID subregion\" from drop box and enter \"Electricity Purchased.\""]
[" - Use map (Figure 1) at bottom of sheet to determine appropriate eGRID subregion.  If subregion cannot be determined from the map, find the correct subregion by entering the location's zip code into EPA’s Power Profiler:"]
["https://www.epa.gov/egrid/power-profiler#/"]
["(D) If the facility procures electricity directly, provide the emissions factors in the GREEN cells marked as \"<enter factor>\".  If not, leave the yellow cells as is, and eGRID subregion factors will be used for procuremnet-based emissions. \n"]
["For proposed projects that are establishing a new facility, or re-equipping or expanding an existing facility that is not yet operational by the applicant, baseline or \"current\" information on all tabs may be omitted."]
[]
["Tips: Enter electricity usage by location and then look up the eGRID subregion for each location."]
["         If you purchase renewable energy that is less than 100% of your site's electricity, see the \n         example in the market-based method Help sheet. ",null,null,null,"CURRENT","CURRENT Location-Based",null,null,"CURRENT Procurement-Based\nUse these cells to enter procurement-based emission factors",{"$nulls":5},"FUTURE","FUTURE Location-Based",null,null,"FUTURE Procurement-Based\nUse these cells to enter procurement-based emission factors"]
["Table 1.  Total Amount of Electricity Purchased by eGRID Subregion",{"$nulls":4},"Emissions",null,null,"Emission Factors",null,null,"Emissions",null,null,null,"Emissions",null,null,"Emission Factors",null,null,"Emissions"]
["Source","Source","Source","eGRID Subregion","Current Electricity","CO2","CH4 ","N2O ","CO2","CH4 ","N2O ","CO2","CH4 ","N2O ","Future","CO2","CH4 ","N2O ","CO2","CH4 ","N2O ","CO2","CH4 ","N2O "]
["ID","Description","Area (sq ft)","where electricity is consumed","Purchased",null,"Emissions","Emissions","Emissions","Emissions","Emissions","Emissions","Emissions","Emissions","Purchased","Emissions","Emissions","Emissions","Emissions","Emissions","Emissions","Emissions","Emissions","Emissions"]
[{"$nulls":4},"(kWh)","(lb)","(lb)","(lb)","(lb/MWh)","(lb/MWh)","(lb/MWh)","(lb)","(lb)","(lb)","(kWh)","(lb)","(lb)","(lb)","(lb/MWh)","(lb/MWh)","(lb/MWh)","(lb)","(lb)","(lb)"]
["Bldg-012","East Power Plant",12517,"HIMS (HICC Miscellaneous)",200000,{"$f":"IF(ISNA(VLOOKUP($D19,eGRID_em_Fctrs,4,FALSE)),\"\",VLOOKUP($D19,eGRID_em_Fctrs,4,FALSE)*$E19/1000)","v":226880.00000000003},{"$f":"IF(ISNA(VLOOKUP($D19,eGRID_em_Fctrs,5,FALSE)),\"\",VLOOKUP($D19,eGRID_em_Fctrs,5,FALSE)*$E19/1000)","v":27},{"$f":"IF(ISNA(VLOOKUP($D19,eGRID_em_Fctrs,7,FALSE)),\"\",VLOOKUP($D19,eGRID_em_Fctrs,7,FALSE)*$E19/1000)","v":4.2},200000,27,4.2,{"$f":"IFERROR(IF(ISBLANK(I19),F19,E19/1000*I19),\"Enter Factor\")","v":40000000},{"$f":"IFERROR(IF(ISBLANK(J19),G19,E19/1000*J19),\"Enter Factor\")","v":5400},{"$f":"IFERROR(IF(ISBLANK(K19),H19,E19/1000*K19),\"Enter Factor\")","v":840},200000,{"$f":"IF(ISNA(VLOOKUP($D19,eGRID_em_Fctrs,4,FALSE)),\"\",VLOOKUP($D19,eGRID_em_Fctrs,4,FALSE)*$O19/1000)","v":226880.00000000003},{"$f":"IF(ISNA(VLOOKUP($D19,eGRID_em_Fctrs,5,FALSE)),\"\",VLOOKUP($D19,eGRID_em_Fctrs,5,FALSE)*$O19/1000)","v":27},{"$f":"IF(ISNA(VLOOKUP($D19,eGRID_em_Fctrs,7,FALSE)),\"\",VLOOKUP($D19,eGRID_em_Fctrs,7,FALSE)*$O19/1000)","v":4.2},200000,27,4.2,{"$f":"IFERROR(IF(ISBLANK(S19),P19,O19/1000*S19),\"Enter Factor\")","v":40000000},{"$f":"IFERROR(IF(ISBLANK(T19),Q19,O19/1000*T19),\"Enter Factor\")","v":5400},{"$f":"IFERROR(IF(ISBLANK(U19),R19,O19/1000*U19),\"Enter Factor\")","v":840}]
[{"$nulls":5},{"$f":"IF(ISNA(VLOOKUP($D20,eGRID_em_Fctrs,4,FALSE)),\"\",VLOOKUP($D20,eGRID_em_Fctrs,4,FALSE)*$E20/1000)","v":""},"",{"$f":"IF(ISNA(VLOOKUP($D20,eGRID_em_Fctrs,7,FALSE)),\"\",VLOOKUP($D20,eGRID_em_Fctrs,7,FALSE)*$E20/1000)","v":""},null,null,null,{"$f":"IFERROR(IF(ISBLANK(I20),F20,E20/1000*I20),\"Enter Factor\")","v":""},{"$f":"IFERROR(IF(ISBLANK(J20),G20,E20/1000*J20),\"Enter Factor\")","v":""},{"$f":"IFERROR(IF(ISBLANK(K20),H20,E20/1000*K20),\"Enter Factor\")","v":""},null,"","","",null,null,null,{"$f":"IFERROR(IF(ISBLANK(S20),P20,O20/1000*S20),\"Enter Factor\")","v":""},{"$f":"IFERROR(IF(ISBLANK(T20),Q20,O20/1000*T20),\"Enter Factor\")","v":""},{"$f":"IFERROR(IF(ISBLANK(U20),R20,O20/1000*U20),\"Enter Factor\")","v":""}]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},{"$f":"IF(ISNA(VLOOKUP($D22,eGRID_em_Fctrs,4,FALSE)),\"\",VLOOKUP($D22,eGRID_em_Fctrs,4,FALSE)*$E22/1000)","v":""},"","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"",{"$f":"IF(ISNA(VLOOKUP($D33,eGRID_em_Fctrs,5,FALSE)),\"\",VLOOKUP($D33,eGRID_em_Fctrs,5,FALSE)*$E33/1000)","v":""},"",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
[{"$nulls":5},"","","",null,null,null,"","","",null,"","","",null,null,null,"","",""]
["Total Emissions for All Sources",null,null,null,{"$f":"SUM($E$20:$E$56)","v":0},{"$f":"SUM($F$20:$F$56)","v":0},{"$f":"SUM($G$20:$G$56)","v":0},{"$f":"SUM($H$20:$H$56)","v":0},null,null,null,{"$f":"SUM($L$20:$L$56)","v":0},{"$f":"SUM($M$20:$M$56)","v":0},{"$f":"SUM($N$20:$N$56)","v":0},{"$f":"SUM(O$20:O$56)","v":0},{"$f":"SUM(P$20:P$56)","v":0},{"$f":"SUM(Q$20:Q$56)","v":0},{"$f":"SUM(R$20:R$56)","v":0},null,null,null,{"$f":"SUM(V$20:V$56)","v":0},0,0]
[]
["CO2 Equivalent Emissions  (metric tons)",null,null,null,"Current",null,"Future"]
["Location-Based Electricity Emissions",null,null,null,{"$f":"($F$57+$G$57*CH4_GWP+$H$57*N2O_GWP)*kg_per_lb/1000","v":0},null,{"$f":"($P$57+$Q$57*CH4_GWP+$R$57*N2O_GWP)*kg_per_lb/1000","v":0}]
["Procurement-Based Electricity Emissions (final value)",null,null,null,{"$f":"($L$57+$M$57*CH4_GWP+$N$57*N2O_GWP)*kg_per_lb/1000","v":0},null,{"$f":"($V$57+$W$57*CH4_GWP+$X$57*N2O_GWP)*kg_per_lb/1000","v":0}]
[]
["Notes:"]
["1.  CO2, CH4 and N2O emissions are estimated using methodology provided in EPA's Center for Corporate Climate Leadership Greenhouse Gas Inventory Guidance"]
["     - Indirect Emissions from Purchased Electricity (January 2016)."]
[]
[]
["Figure 1.  EPA eGRID2021, January 2023."]

{"sheet":"Scope 2 - Steam","index":9,"n_rows":84,"n_cols":16,"rows_kept":84,"cut":false,"hidden":false,"merged":[[66,6,66,7],[20,0,22,0],[20,1,22,1],[20,2,22,2],[20,3,22,3],[64,0,64,1],[66,0,66,1],[8,0,8,7],[13,1,13,8],[19,5,19,7],[19,12,19,15],[64,6,64,7],[19,8,19,11],[17,1,17,8]]}
["Scope 2 Emissions from Purchase of Steam",{"$nulls":9},"Back to Introduction Tab"]
[]
["Guidance"]
["(A)  Enter annual data for each facility or site in GREEN cells in Table 1.  "]
["- Enter amount of steam purchased in mmBtu. Heat Content conversions can be found on the \"Heat Content\" sheet."]
["- Select \"Fuel Type\" from drop box to indicate the fuel used to generate the steam."]
[" -- If \"Fuel Type\" is not known, select \"Natural Gas\" from drop box as default value."]
[" -- If more than one fuel type is used, enter multiple rows, apportioning the steam using the same percentages as the fuel mix."]
["   (B) If steam is purchased at a facility but steam consumption data are not available, an estimate should be made for completeness.  \n         See the \"Items to Note\" section of the Help sheet for suggested estimation approaches. "]
["(C)  Preferred Method (steam emission factors ARE available from your supplier). Example entry is shown in first data row (GREEN Italics)."]
["                  - Enter supplier emission factors for CO2, CH4, and N2O in the purple cells marked as \"<enter factor>\" if available, otherwise leave factor cells blank."]
["- These should be expressed in lb / mmBtu of Steam.  Heat Content conversions can be found on the \"Heat Content\" sheet."]
["- Boiler Efficiency is not necessary if emission factors are available."]
[null,"- Typically supplier emission factors for steam will apply to both location-based and market-based emissions, and no \n  market-based emission factors need to be entered.  However, if there are different applicable market-based emission factors, \n  enter the factors in the yellow cells marked as \"<enter factor>\". If needed, see the market-based method Help Sheet for guidance. "]
["(D)  Alternative Method (supplier-specific emission factors are NOT available). Example entry is shown in second data row (BLUE Italics)."]
["                  - Enter boiler efficiency.  If boiler efficiency is not known, use 80% as default value. Do not enter market-based emission factors. "]
[]
[null,"For proposed projects that are establishing a new facility, or re-equipping or expanding an existing facility that is not yet operational by the applicant, baseline or \"current\" information on all tabs may be omitted."]
[]
["Table 1.  Fuel, Boiler, Steam and Emission Factor Data for Steam Purchased",{"$nulls":4},"Emission Factors",null,null,"Current Annual Emissions",null,null,null,"Future Annual Emissions"]
["Source\nID","Source\nDescription","Source\nArea (sq ft)","Fuel Type","Boiler","CO2 ","CH4 ","N2O","Steam","CO2","CH4 ","N2O ","Steam","CO2","CH4 ","N2O "]
[{"$nulls":4},"Efficiency","Factor","Factor","Factor","Purchased","Emissions","Emissions","Emissions","Purchased","Emissions","Emissions","Emissions"]
[{"$nulls":4},"(%)","(kg / mmBtu)","(g / mmBtu)","(g / mmBtu)","(mmBtu)","(kg)","(g)","(g)","(mmBtu)","(kg)","(g)","(g)"]
["Bldg-011","Office ",5000,"Natural Gas",80,72,1.5,0.6,5000,{"$f":"IF($I24=\"\",\"\",\nIF(OR(F24=\"<enter factor>\",F24=\"\"),(VLOOKUP($D24,Stationary_Fuel_Fctrs_mmBtu,2,FALSE))*$I24/(IF($E24=\"\",0.8,$E24/100)),\nF24*$I24/(IF($E24=\"\",0.8,$E24/100))))","v":450000},{"$f":"IF($I24=\"\",\"\",\nIF(OR(G24=\"<enter factor>\",G24=\"\"),(VLOOKUP($D24,Stationary_Fuel_Fctrs_mmBtu,3,FALSE))*$I24/(IF($E24=\"\",0.8,$E24/100)),\nG24*$I24/(IF($E24=\"\",0.8,$E24/100))))","v":9375},{"$f":"IF($I24=\"\",\"\",\nIF(OR(H24=\"<enter factor>\",H24=\"\"),(VLOOKUP($D24,Stationary_Fuel_Fctrs_mmBtu,4,FALSE))*$I24/(IF($E24=\"\",0.8,$E24/100)),\nH24*$I24/(IF($E24=\"\",0.8,$E24/100))))","v":3750},5000,{"$f":"IF($I24=\"\",\"\",\nIF(OR(J24=\"<enter factor>\",J24=\"\"),(VLOOKUP($D24,Stationary_Fuel_Fctrs_mmBtu,2,FALSE))*$I24/(IF($E24=\"\",0.8,$E24/100)),\nJ24*$I24/(IF($E24=\"\",0.8,$E24/100))))","v":2812500000},{"$f":"IF($I24=\"\",\"\",\nIF(OR(K24=\"<enter factor>\",K24=\"\"),(VLOOKUP($D24,Stationary_Fuel_Fctrs_mmBtu,3,FALSE))*$I24/(IF($E24=\"\",0.8,$E24/100)),\nK24*$I24/(IF($E24=\"\",0.8,$E24/100))))","v":58593750},{"$f":"IF($I24=\"\",\"\",\nIF(OR(L24=\"<enter factor>\",L24=\"\"),(VLOOKUP($D24,Stationary_Fuel_Fctrs_mmBtu,4,FALSE))*$I24/(IF($E24=\"\",0.8,$E24/100)),\nL24*$I24/(IF($E24=\"\",0.8,$E24/100))))","v":23437500}]
["Bldg-012","Steam-Blr Room",2000,"Sub-bituminous Coal",80,null,null,null,1000,121462.5,13750,2000,1000,151828125,17187500,2500000]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[{"$nulls":9},"","","",null,"","",""]
[]
["Current Annual Emissions by Source and Fuel Type for Steam Purchased",{"$nulls":5},"Future Annual Emissions by Source and Fuel Type for Steam Purchased"]
["Fuel Type",null,"CO2 ","CH4 ","N2O",null,"Fuel Type",null,"CO2 ","CH4 ","N2O"]
[null,null,"Emissions","Emissions","Emissions",null,null,null,"Emissions","Emissions","Emissions"]
[null,null,"(kg)","(g)","(g)",null,null,null,"(kg)","(g)","(g)"]
["Natural Gas",null,{"$f":"SUMIF($D$26:$D$62,$A68,$J$26:$J$62)","v":0},{"$f":"SUMIF($D$26:$D$62,$A68,$K$26:$K$62)","v":0},{"$f":"SUMIF($D$26:$D$62,$A68,$L$26:$L$62)","v":0},null,"Natural Gas",null,{"$f":"SUMIF($D$26:$D$62,$A68,$N$26:$N$62)","v":0},{"$f":"SUMIF($D$26:$D$62,$A68,$O$26:$O$62)","v":0},{"$f":"SUMIF($D$26:$D$62,$A68,$P$26:$P$62)","v":0}]
["Distillate Fuel Oil No. 2",null,{"$f":"SUMIF($D$26:$D$62,$A69,$J$26:$J$62)","v":0},0,0,null,"Distillate Fuel Oil No. 2",null,{"$f":"SUMIF($D$26:$D$62,$A69,$N$26:$N$62)","v":0},{"$f":"SUMIF($D$26:$D$62,$A69,$O$26:$O$62)","v":0},{"$f":"SUMIF($D$26:$D$62,$A69,$P$26:$P$62)","v":0}]
["Residual Fuel Oil No. 6",null,0,0,0,null,"Residual Fuel Oil No. 6",null,0,0,0]
["Kerosene",null,0,0,0,null,"Kerosene",null,0,0,0]
["Liquefied Petroleum Gases (LPG)",null,0,0,0,null,"Liquefied Petroleum Gases (LPG)",null,0,0,0]
["Anthracite Coal",null,0,0,0,null,"Anthracite Coal",null,0,0,0]
["Bituminous Coal",null,0,0,0,null,"Bituminous Coal",null,0,0,0]
["Sub-bituminous Coal",null,0,0,0,null,"Sub-bituminous Coal",null,0,0,0]
["Lignite Coal",null,0,0,0,null,"Lignite Coal",null,0,0,0]
["Mixed (Electric Power Sector)",null,0,0,0,null,"Mixed (Electric Power Sector)",null,0,0,0]
["Coal Coke",null,0,0,0,null,"Coal Coke",null,0,0,0]
["Wood and Wood Residuals",null,0,0,0,null,"Wood and Wood Residuals",null,0,0,0]
["Landfill Gas",null,0,0,0,null,"Landfill Gas",null,0,0,0]
["Total Emissions for All Sources",null,{"$f":"SUM(C68:C80)","v":0},0,0,null,"Total Emissions for All Sources",null,{"$f":"SUM(I68:I80)","v":0},0,0]
[]
["CO2 Equivalent Emissions  (metric tons)",{"$nulls":4},"Current",{"$nulls":4},"Future"]
[{"$nulls":5},{"$f":"($C$81+$D$81*CH4_GWP/1000+$E$81*N2O_GWP/1000)/1000","v":0},{"$nulls":4},{"$f":"($I$81+$J$81*CH4_GWP/1000+$K$81*N2O_GWP/1000)/1000","v":0}]

{"sheet":"Scope 2 - Hydrogen","index":10,"n_rows":81,"n_cols":11,"rows_kept":81,"cut":false,"hidden":false,"merged":[[14,0,14,9],[63,4,63,5],[17,3,17,5],[17,6,17,8],[61,4,61,5],[61,0,61,1],[63,0,63,1],[18,0,20,0],[18,1,20,1],[18,2,20,2]]}
["Scope 2 Emissions from Purchase of Hydrogen",{"$nulls":9},"Back to Introduction Tab"]
[]
["Guidance"]
["(A)  Enter annual data for each facility or site in GREEN cells in Table 1.  "]
["- Enter amount of hydrogen purchased in kg. "]
["- Select \"Production Process\" from drop box to indicate the process used to produce the hydrogen."]
[" -- If \"Production Process\" is not known, select \"Steam Methane Reformation\" from drop box as default value."]
[" -- If more than one production process type is used, enter multiple rows, apportioning the hydrogen."]
["(B)  Download and complete the GREET Hydrogen module in Excel (https://greet.anl.gov/greet_hydrogen)"]
["                  - Enable macros in Excel"]
["                  - Enter requested inputs and outputs"]
["- \"Calculate\" for each hydrogen source"]
["(C)  Enter the CO2e factor generated by the GREET model in Column E"]
[]
["For proposed projects that are establishing a new facility, or re-equipping or expanding an existing facility that is not yet operational by the applicant, baseline or \"current\" information on all tabs may be omitted."]
[]
["Table 1.  Emission Factor Data for Hydrogen Purchased"]
[null,null,null,"Current Annual Purchases",null,null,"Future Annual Purchases"]
["Source\nName/ID","Source\nDescription","Production Process","Hydrogen","CO2e factor","CO2e","Hydrogen","CO2e factor","CO2e"]
[null,null,null,"Purchased"," from GREET","Emissions","Purchased"," from GREET","Emissions"]
[null,null,null,"(kg)","(kg CO2 / kgH2)","(kg)","(kg)","(kg CO2 / kgH2)","(kg)"]
["H2 1.1","Hydrogen source","Steam methane reforming",5000,8,{"$f":"D22*E22","v":40000},5000,8,{"$f":"G22*H22","v":40000}]
{"$rows_empty":38}
["Current Annual Emissions by Production Process",null,null,null,"Future Annual Emissions by Production Process"]
["Production Process",null,"CO2e",null,"Production Process",null,"CO2e"]
[null,null,"Emissions",null,null,null,"Emissions"]
[null,null,"(kg)",null,null,null,"(kg)"]
["Steam methane reforming",null,{"$f":"SUMIF($C$23:$C$59,$A65,$F$23:$F$59)","v":0},null,"Steam methane reforming",null,{"$f":"SUMIF($C$23:$C$59,$A65,$I$23:$I$59)","v":0}]
["Nuclear (LWR) high-termperature electrolysis",null,0,null,"Nuclear (LWR) high-termperature electrolysis",null,{"$f":"SUMIF($C$23:$C$59,$A66,$I$23:$I$59)","v":0}]
["Low-temperature electrolysis (PEM)",null,0,null,"Low-temperature electrolysis (PEM)",null,0]
["Coal gasification",null,0,null,"Coal gasification",null,0]
["Biomass gasification",null,0,null,"Biomass gasification",null,0]
["Auto-thermal reforming",null,0,null,"Auto-thermal reforming",null,0]
["Other",null,0,null,"Other",null,{"$f":"SUMIF($C$23:$C$59,$A71,$I$23:$I$59)","v":0}]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
[null,null,0,null,null,null,0]
["Total Emissions for All Sources",null,{"$f":"SUM(C65:C77)","v":0},null,"Total Emissions for All Sources",null,{"$f":"SUM(G65:G77)","v":0}]
[]
["CO2 Equivalent Emissions  (metric tons)",null,"Current",null,null,null,"Future"]
[null,null,{"$f":"$C$78/1000","v":0},null,null,null,{"$f":"$G$78/1000","v":0}]

{"sheet":"Scope 3 - Indirect","index":11,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[13,0,13,6],[8,0,8,4],[9,0,9,6],[3,0,7,6],[19,0,33,10]]}
["Scope 3 Value Chain Emissions ",{"$nulls":9},"Back to Introduction Tab"]
[]
["Guidance"]
["Enter annual data for Scope 3 emissions below. For the purposes of this FOA, Scope 3 should encompass emissions that are not produced by the applicant itself, and are not the result of activities from assets controlled by the applicant. Scope 3 emissions should include all sources not within the Scope 1 and Scope 2 boundaries. "]
[]
[]
[]
[]
[]
[]
["Further guidance on calculating Scope 3 emissions can be found here. "]
[]
[]
["For proposed projects that are establishing a new facility, or re-equipping or expanding an existing facility that is not yet operational by the applicant, baseline or \"current\" information on all tabs may be omitted."]
[null,"Current ",null,"Future"]
["CO2 Equivalent Emissions ",null,"MT CO2-e/yr",null,"MT CO2-e/yr"]
[]
[]
["Work/justification here:"]

{"sheet":"Optional - RECs","index":12,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[9,7,9,11],[24,3,25,4],[3,0,3,5],[4,0,4,5],[5,0,5,3],[24,0,25,1],[9,2,9,6]]}
["Purchased Renewable/Clean Energy Credits",{"$nulls":9},"Back to Introduction Tab"]
[]
["Guidance"]
["(A)  Enter quantity of RECs purchased annually in GREEN cells of Table 1.       "]
["(B)  Select \"eGRID subregion\" from drop box, selecting the location of the facility (not the location of the purchased RECs). This is used to calculate displaced emissions."]
[" - Use map (Figure 1) at bottom of sheet to determine appropriate eGRID subregion.  If subregion cannot be determined from the map, find the correct subregion by entering the location's zip code into EPA’s Power Profiler:"]
["https://www.epa.gov/egrid/power-profiler#/"]
[]
["Table 1.  Total Amount of Purchased RECs"]
[null,null,"Current Year RECs",{"$nulls":4},"Future Year RECs"]
[" ID","Project Description","RECs Purchased\n(kWh)","eGRID subregion (where electricity is consumed, should be same as Electricity tab)","Displaced CO2 Emissions\n(lb)","Displaced CH4 Emissions\n(lb)","Displaced N2O Emissions\n(lb)","RECs Purchased\n(kWh)","eGRID subregion (where electricity is consumed, should be same as Electricity tab)","Displaced CO2 Emissions\n(lb)","Displaced CH4 Emissions\n(lb)","Displaced N2O Emissions\n(lb)"]
["Project 1","Renewable Energy Credits",200000,"NEWE (NPCC New England)",{"$f":"IF(ISNA(VLOOKUP($D12,eGRID_em_Fctrs,4,FALSE)),\"\",VLOOKUP($D12,eGRID_em_Fctrs,4,FALSE)*$C12/1000)","v":107880},{"$f":"IF(ISNA(VLOOKUP($D12,eGRID_em_Fctrs,5,FALSE)),\"\",VLOOKUP($D12,eGRID_em_Fctrs,5,FALSE)*$C12/1000)","v":14.399999999999999},{"$f":"IF(ISNA(VLOOKUP($D12,eGRID_em_Fctrs,7,FALSE)),\"\",VLOOKUP($D12,eGRID_em_Fctrs,7,FALSE)*$C12/1000)","v":1.7999999999999998},200000,"NEWE (NPCC New England)",{"$f":"IF(ISNA(VLOOKUP($D12,eGRID_em_Fctrs,4,FALSE)),\"\",VLOOKUP($D12,eGRID_em_Fctrs,4,FALSE)*$C12/1000)","v":107880},{"$f":"IF(ISNA(VLOOKUP($D12,eGRID_em_Fctrs,5,FALSE)),\"\",VLOOKUP($D12,eGRID_em_Fctrs,5,FALSE)*$C12/1000)","v":14.399999999999999},{"$f":"IF(ISNA(VLOOKUP($D12,eGRID_em_Fctrs,7,FALSE)),\"\",VLOOKUP($D12,eGRID_em_Fctrs,7,FALSE)*$C12/1000)","v":1.7999999999999998}]
{"$rows_empty":10}
["Total Emissions for All Sources",null,null,null,{"$f":"SUM(E$13:E$22)","v":0},{"$f":"SUM(F$13:F$22)","v":0},{"$f":"SUM(G$13:G$22)","v":0},null,null,{"$f":"SUM(J$13:J$22)","v":0},{"$f":"SUM(K$13:K$22)","v":0},{"$f":"SUM(L$13:L$22)","v":0}]
[]
["Total CO2 Equivalent Emission Reductions (metric tons) - RECs",null,"Current",null,null,"Future"]
[null,null,{"$f":"($E$23+$F$23*CH4_GWP+$G$23*N2O_GWP)*kg_per_lb/1000","v":0},null,null,{"$f":"($J$23+$K$23*CH4_GWP+$L$23*N2O_GWP)*kg_per_lb/1000","v":0}]

{"sheet":"Unit Conversions","index":13,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[3,0,3,3],[17,0,17,3],[35,0,35,3],[49,0,49,3]]}
["Tool Sheet: Unit Conversions",{"$nulls":9},"Back to Introduction Tab"]
[]
[]
["Mass"]
["Convert From ","Convert To","Multiply By","Units"]
["pounds (lb)","gram (g)",453.6,"g /  lb"]
["pounds (lb)","kilogram (kg)",0.4536,"kg / lb"]
["pounds (lb)","metric ton",4.5360000000000002E-4,"metric ton / lb"]
["kilogram (kg)","pounds (lb)",2.2050000000000001,"lb / kg"]
["gram (g)","short ton",{"$f":"C11/1000","v":1.1020000000000002E-6},"short ton / g"]
["kilogram (kg)","short ton",{"$f":"C12/1000","v":1.1020000000000001E-3},"short ton / kg"]
["metric ton","short ton",1.1020000000000001,"short ton / metric ton"]
["pounds (lb)","short ton",{"$f":"1/2000","v":5.0000000000000001E-4},"short ton / lb"]
["short ton","short ton",1,"short ton / short ton"]
["metric ton","pounds (lb)",2205,"lb / metric ton"]
["metric ton","kilogram (kg)",1000,"kg / metric ton"]
[]
["Volume"]
["Convert From ","Convert To","Multiply By","Units"]
["standard cubic foot (scf)","US gallon (gal)",7.4805000000000001,"gal / scf"]
["standard cubic foot (scf)","barrel (bbl)",0.17810000000000001,"bbl / scf"]
["standard cubic foot (scf)","liters (L)",28.32,"L / scf"]
["standard cubic foot (scf)","cubic meters (m3)",2.8320000000000001E-2,"m3 / scf"]
["US gallon (gal)","barrel (bbl)",2.3800000000000002E-2,"bbl / gal"]
["US gallon (gal)","liters (L)",3.7850000000000001,"L / gal"]
["US gallon (gal)","cubic meters (m3)",3.7850000000000002E-3,"m3 / gal"]
["barrel (bbl)","US gallons (gal)",42,"gal / bbl"]
["barrel (bbl)","liters (L)",158.99,"L / bbl"]
["barrel (bbl)","cubic meters (m3)",0.15890000000000001,"m3 / bbl"]
["liters (L)","cubic meters (m3)",1E-3,"m3 / L"]
["liters (L)","US gallon (gal)",0.26419999999999999,"gal / L"]
["cubic meters (m3)","barrel (bbl)",6.2896999999999998,"bbl / m3"]
["cubic meters (m3)","US gallon (gal)",264.2,"gal / m3"]
["cubic meters (m3)","liters (L)",1000,"L / m3"]
[]
["Energy"]
["Convert From ","Convert To","Multiply By","Units"]
["kilowatt hour (kWh)","Btu",3412,"Btu / kWh"]
["kilowatt hour (kWh)","kilojoules (KJ) ",3600,"KJ / kWh"]
["megajoule (MJ)","gigajoules (GJ) ",1E-3,"GJ / MJ"]
["gigajoule (GJ)","million Btu (mmBtu)",0.94779999999999998,"mmBtu / GJ"]
["gigajoule (GJ)","kilowatt hours (kWh)",277.8,"kWh / GJ"]
["Btu","joules (J) ",1055,"J / Btu"]
["million Btu (mmBtu)","gigajoules (GJ) ",1.0549999999999999,"GJ / mmBtu"]
["million Btu (mmBtu)","kilowatt hours (kWh)",293,"kWh / mmBtu"]
["therm","Btu",100000,"Btu / therm"]
["therm","gigajoules (GJ) ",0.1055,"GJ / therm"]
["therm","kilowatt hours (kWh)",29.3,"kWh / therm"]
[]
["Distance"]
["Convert From ","Convert To","Multiply By","Units"]
["mile","kilometers (km)",1.609,"km / mile"]
["nautical mile","miles",1.1499999999999999,"mile / nautical mile"]
["kilometer (km)","miles",{"$f":"ROUND(1/C52,3)","v":0.622},"mile / km"]
[]
["Other"]
["Kilo",1000]
["Mega",1000000]
["Giga",1000000000]
["Tera",1000000000000]
["Molecular Weigh of C",12]
["Molecular Weight of CO2 ",44]

{"sheet":"Heat Content","index":14,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,5,38,5],[39,5,41,5]]}
["Tool Sheet: Heat Content for Specific Fuels",{"$nulls":9},"Back to Introduction Tab"]
["Additional heat contents can be found in the EF Hub."]
[]
["Fuel Type","Convert From ","Convert To","Multiply By","Units","Source"]
["Natural Gas","mmBtu","scf",{"$f":"ROUND(1/0.001026,6)","v":974.65886899999998},"scf / mmBtu","EPA, Emission Factors Hub March 2023,  Based on Federal Register EPA; 40 CFR Part 98; e-CFR, (see link below).\n \nTable C-1, Table C-2 (as amended at 81 FR 89252, Dec. 9, 2016), Table AA-1 (78 FR 71965, Nov. 29, 2013).   https://www.ecfr.gov/cgi-bin/text-idx?SID=ae265d7d6f98ec86fcd8640b9793a3f6&mc=true&node=pt40.23.98&rgn=div5#ap40.23.98_19.1"]
["Natural Gas","Dth (Decatherm)","scf",{"$f":"D5","v":974.65886899999998},"scf / Dth"]
["Natural Gas","therm","scf",{"$f":"D6/10","v":97.465886900000001},"scf / therm"]
["Natural Gas","ccf","scf",100,"scf / ccf"]
["Natural Gas","Mcf","scf",1000,"scf / Mcf"]
["Natural Gas","cubic meter","scf",{"$f":"1/'Unit Conversions'!C23","v":35.310734463276837},"scf / cubic meter"]
["Natural Gas","kWh","scf",{"$f":"D5*('Unit Conversions'!C38/1000000)","v":3.325536061028},"scf / kWh"]
["Anthracite Coal","mmBtu","Short ton",{"$f":"1/25.09","v":3.9856516540454363E-2},"short ton / mmBtu"]
["Bituminous Coal","mmBtu","Short ton",{"$f":"1/24.93","v":4.011231448054553E-2},"short ton / mmBtu"]
["Sub-bituminous Coal","mmBtu","Short ton",{"$f":"1/17.25","v":5.7971014492753624E-2},"short ton / mmBtu"]
["Lignite Coal","mmBtu","Short ton",{"$f":"1/14.21","v":7.0372976776917659E-2},"short ton / mmBtu"]
["Mixed (Commercial Sector)","mmBtu","Short ton",{"$f":"1/21.39","v":4.6750818139317439E-2},"short ton / mmBtu"]
["Mixed (Electric Power Sector)","mmBtu","Short ton",{"$f":"1/19.73","v":5.0684237202230108E-2},"short ton / mmBtu"]
["Mixed (Industrial Coking)","mmBtu","Short ton",{"$f":"1/26.28","v":3.8051750380517502E-2},"short ton / mmBtu"]
["Mixed (Industrial Sector)","mmBtu","Short ton",{"$f":"1/22.35","v":4.4742729306487691E-2},"short ton / mmBtu"]
["Coal Coke","mmBtu","Short ton",{"$f":"1/24.8","v":4.0322580645161289E-2},"short ton / mmBtu"]
["Agricultural Byproducts","mmBtu","Short ton",{"$f":"1/8.25","v":0.12121212121212122},"short ton / mmBtu"]
["Peat","mmBtu","Short ton",{"$f":"1/8","v":0.125},"short ton / mmBtu"]
["Solid Byproducts","mmBtu","Short ton",{"$f":"1/10.39","v":9.6246390760346481E-2},"short ton / mmBtu"]
["Wood and Wood Residuals","mmBtu","Short ton",{"$f":"1/17.48","v":5.7208237986270019E-2},"short ton / mmBtu"]
["Municipal Solid Waste","mmBtu","Short ton",{"$f":"1/9.95","v":0.10050251256281408},"short ton / mmBtu"]
["Petroleum Coke (Solid)","mmBtu","Short ton",{"$f":"1/30","v":3.3333333333333333E-2},"short ton / mmBtu"]
["Plastics","mmBtu","Short ton",{"$f":"1/38","v":2.6315789473684209E-2},"short ton / mmBtu"]
["Tires","mmBtu","Short ton",{"$f":"1/28","v":3.5714285714285712E-2},"short ton / mmBtu"]
["Distillate Fuel Oil No. 2","mmBtu","gallon",{"$f":"1/0.138","v":7.2463768115942022},"gallon / mmBtu"]
["Residual Fuel Oil No. 6","mmBtu","gallon",{"$f":"1/0.15","v":6.666666666666667},"gallon / mmBtu"]
["Kerosene","mmBtu","gallon",{"$f":"1/0.135","v":7.4074074074074066},"gallon / mmBtu"]
["Liquefied Petroleum Gases (LPG)","mmBtu","gallon",{"$f":"1/0.092","v":10.869565217391305},"gallon / mmBtu"]
["Biodiesel (100%)","mmBtu","gallon",{"$f":"1/0.128","v":7.8125},"gallon / mmBtu"]
["Ethanol (100%)","mmBtu","gallon",{"$f":"1/0.084","v":11.904761904761903},"gallon / mmBtu"]
["Vegetable Oil","mmBtu","gallon",{"$f":"1/0.12","v":8.3333333333333339},"gallon / mmBtu"]
["Propane Gas","mmBtu","scf",{"$f":"1/0.002516","v":397.45627980922097},"scf / mmBtu"]
["Propane Gas","therm","scf",{"$f":"D36/10","v":39.745627980922094},"scf / therm"]
["Landfill Gas","mmBtu","scf",{"$f":"1/0.000485","v":2061.8556701030925},"scf / mmBtu"]
["Landfill Gas","therm","scf",{"$f":"D38/10","v":206.18556701030926},"scf / therm"]
["Steam","Mlb (1,000 pounds)","mmBtu",{"$f":"D41*1000","v":1.194},"mmBtu / Mlb","EPA, ENERGY STAR, https://www.energystar.gov/buildings/tools-and-resources/portfolio-manager-technical-reference-thermal-conversion-factors"]
["Steam","lb","mmBtu",{"$f":"1.194/1000","v":1.194E-3},"mmBtu / lb"]
["Steam","short ton","mmBtu",{"$f":"D41/'Unit Conversions'!C13","v":2.3879999999999999},"mmBtu / short ton"]

{"sheet":"Emission Factors","index":15,"n_rows":454,"n_cols":256,"rows_kept":454,"cut":false,"hidden":false,"merged":[[2,0,2,7],[64,0,64,4],[67,4,67,7],[68,4,68,7],[69,4,69,7],[70,4,70,7],[83,4,83,7],[84,4,84,7],[85,4,85,7],[77,4,77,7],[78,4,78,7],[79,4,79,7],[71,4,71,7],[72,4,72,7],[73,4,73,7],[74,4,74,7],[75,4,75,7],[76,4,76,7],[86,4,86,7],[87,4,87,7],[88,4,88,7],[80,4,80,7],[81,4,81,7],[82,4,82,7],[95,4,95,7],[96,4,96,7],[97,4,97,7],[98,4,98,7],[99,4,99,7],[100,4,100,7],[89,4,89,7],[90,4,90,7],[91,4,91,7],[92,4,92,7],[93,4,93,7],[94,4,94,7],[107,4,107,7],[108,4,108,7],[109,4,109,7],[110,4,110,7],[111,4,111,7],[112,4,112,7],[101,4,101,7],[102,4,102,7],[103,4,103,7],[104,4,104,7],[105,4,105,7],[106,4,106,7],[119,4,119,7],[120,4,120,7],[121,4,121,7],[122,4,122,7],[123,4,123,7],[124,4,124,7],[113,4,113,7],[114,4,114,7],[115,4,115,7],[116,4,116,7],[117,4,117,7],[118,4,118,7],[131,4,131,7],[132,4,132,7],[133,4,133,7],[134,4,134,7],[135,4,135,7],[136,4,136,7],[125,4,125,7],[126,4,126,7],[127,4,127,7],[128,4,128,7],[129,4,129,7],[130,4,130,7],[143,4,143,7],[144,4,144,7],[145,4,145,7],[146,4,146,7],[147,4,147,7],[148,4,148,7],[137,4,137,7],[138,4,138,7],[139,4,139,7],[140,4,140,7],[141,4,141,7],[142,4,142,7],[155,4,155,7],[156,4,156,7],[157,4,157,7],[158,4,158,7],[159,4,159,7],[160,4,160,7],[149,4,149,7],[150,4,150,7],[151,4,151,7],[152,4,152,7],[153,4,153,7],[154,4,154,7],[167,0,169,0],[167,1,169,1],[170,0,172,0],[170,1,172,1],[161,4,161,7],[162,0,164,0],[162,4,162,7],[163,4,163,7],[164,4,164,7],[195,0,200,0],[230,0,233,0],[234,0,236,0],[185,0,188,0],[189,0,194,0],[180,0,184,0],[173,0,174,0],[173,1,174,1],[175,0,179,0],[237,0,239,0],[240,0,243,0],[279,0,280,1],[283,2,283,4],[204,0,207,0],[209,0,210,0],[211,0,216,0],[217,0,222,0],[223,0,226,0],[227,0,229,0],[290,2,290,4],[291,2,291,4],[292,2,292,4],[293,2,293,4],[294,2,294,4],[295,2,295,4],[284,2,284,4],[285,2,285,4],[286,2,286,4],[287,2,287,4],[288,2,288,4],[289,2,289,4],[302,2,302,4],[303,2,303,4],[304,2,304,4],[305,2,305,4],[306,2,306,4],[307,2,307,4],[296,2,296,4],[297,2,297,4],[298,2,298,4],[299,2,299,4],[300,2,300,4],[301,2,301,4],[314,2,314,4],[315,2,315,4],[316,2,316,4],[317,2,317,4],[318,2,318,4],[319,2,319,4],[308,2,308,4],[309,2,309,4],[310,2,310,4],[311,2,311,4],[312,2,312,4],[313,2,313,4],[330,0,330,2],[331,0,331,2],[332,0,332,2],[333,0,333,2],[334,0,334,2],[335,0,335,2],[320,0,320,7],[327,0,327,2],[327,5,327,6],[328,0,328,2],[328,5,328,6],[329,0,329,2],[342,0,342,2],[343,0,343,2],[345,0,345,2],[346,0,346,2],[347,0,347,2],[348,0,348,2],[336,0,336,2],[337,0,337,2],[338,0,338,2],[339,0,339,2],[340,0,340,2],[341,0,341,2],[355,0,355,2],[388,0,388,4],[391,2,391,7],[349,0,349,2],[350,0,350,2],[351,0,351,2],[352,0,352,2],[353,0,353,2],[354,0,354,2]]}
["Tool Sheet: Emission Factors",{"$nulls":9},"Back to Introduction Tab"]
[]
["All emission factors are sourced from EPA's Emission Factors Hub, March 2023 unless otherwise noted. Fuel emission factors presented represent the combustion-only (tank-to-wheel) emissions and do not represent upstream (well-to-wheel) emissions. "]
["Reference the below link to the EPA's Emission Factors Hub for source data information and links to the methodology and technical documents associated with each table. "]
["https://www.epa.gov/climateleadership/center-corporate-climate-leadership-ghg-emission-factors-hub"]
[]
["Stationary Combustion Emission Factors (Used for Steam and Stationary Combustion)"]
[]
["Fuel Type","CO2 Factor \n(kg / mmBtu)","CH4 Factor \n(g / mmBtu)","N2O Factor \n(g / mmBtu)","CO2 Factor \n(kg / Unit)","CH4 Factor \n(g / unit)","N2O Factor \n(g / unit)","Unit"]
["Natural Gas",53.06,1,0.1,5.4440000000000002E-2,1.0300000000000001E-3,1E-4,"scf"]
["Distillate Fuel Oil No. 2",73.959999999999994,3,0.6,10.210000000000001,0.41,0.08,"gallons"]
["Residual Fuel Oil No. 6",75.099999999999994,3,0.6,11.27,0.45,0.09,"gallons"]
["Kerosene",75.2,3,0.6,10.15,0.41,0.08,"gallons"]
["Liquefied Petroleum Gases (LPG)",61.71,3,0.6,5.68,0.28000000000000003,0.06,"gallons"]
["Anthracite Coal",103.69,11,1.6,2602,276,40,"short tons"]
["Bituminous Coal",93.28,11,1.6,2325,274,40,"short tons"]
["Sub-bituminous Coal",97.17,11,1.6,1676,190,28,"short tons"]
["Lignite Coal",97.72,11,1.6,1389,156,23,"short tons"]
["Mixed (Commercial Sector)",94.27,11,1.6,2016,235,34,"short tons"]
["Mixed (Electric Power Sector)",95.52,11,1.6,1885,217,32,"short tons"]
["Mixed (Industrial Coking)",93.9,11,1.6,2468,289,42,"short tons"]
["Mixed (Industrial Sector)",94.67,11,1.6,2116,246,36,"short tons"]
["Coal Coke",113.67,11,1.6,2819,273,40,"short tons"]
["Municipal Solid Waste",90.7,32,4.2,902,318,42,"short tons"]
["Petroleum Coke (Solid)",102.41,32,4.2,3072,960,126,"short tons"]
["Plastics",75,32,4.2,2850,1216,160,"short tons"]
["Tires",85.97,32,4.2,2407,896,118,"short tons"]
["Agricultural Byproducts",118.17,32,4.2,975,264,35,"short tons"]
["Peat",111.84,32,4.2,895,256,34,"short tons"]
["Solid Byproducts",105.51,32,4.2,1096,332,44,"short tons"]
["Wood and Wood Residuals",0,7.2,3.6,1640,126,63,"short tons"]
["Propane Gas",61.46,3,0.6,0.15462999999999999,7.548E-3,1.5100000000000001E-3,"scf"]
["Landfill Gas",0,3.2,0.63,2.5253999999999999E-2,1.5520000000000002E-3,3.0600000000000001E-4,"scf"]
["Biodiesel (100%)",73.84,1.1000000000000001,0.11,9.4499999999999993,0.14000000000000001,0.01,"gallons"]
["Ethanol (100%)",68.44,1.1000000000000001,0.11,5.75,0.09,0.01,"gallons"]
["Rendered Animal Fat",71.06,1.1000000000000001,0.11,8.8800000000000008,0.14000000000000001,0.01,"gallons"]
["Vegetable Oil",81.55,1.1000000000000001,0.11,9.7899999999999991,0.13,0.01,"gallons"]
[]
["Hydrogen Production Emission Factors (Used for Estimating LCA of Hydrogen Consumption)"]
[]
["Fuel Type","CO2 Factor \n(kg / mmBtu)","CH4 Factor \n(g / mmBtu)","N2O Factor \n(g / mmBtu)","CO2 Factor \n(kg / Unit)","CH4 Factor \n(g / unit)","N2O Factor \n(g / unit)","Unit"]
["Natural gas reforming",{"$nulls":6},"kg"]
["Electrolysis",{"$nulls":6},"kg"]
["Biomass gasification",{"$nulls":6},"kg"]
["Biomass-derived liquid refomring",{"$nulls":6},"kg"]
["Solar thermochemical hydrogen",{"$nulls":6},"kg"]
["Direct solar water splitting",{"$nulls":6},"kg"]
["Microbial biomass conversion",{"$nulls":6},"kg"]
["Photobiological",{"$nulls":6},"kg"]
[]
[]
["Mobile Combustion Emission Factors"]
["CO2 Emissions for Road Vehicles"]
["Fuel Type","CO2 Emission Factor \n(kg CO2 / unit)","Unit"]
["Motor Gasoline",8.7799999999999994,"gallon"]
["Diesel Fuel",10.210000000000001,"gallon"]
["Residual Fuel Oil",11.27,"gallon"]
["Aviation Gasoline",8.31,"gallon"]
["Kerosene-Type Jet Fuel",9.75,"gallon"]
["Liquefied Petroleum Gases (LPG)",5.68,"gallon"]
["Ethanol (100%)",5.75,"gallon"]
["Biodiesel (100%)",9.4499999999999993,"gallon"]
["Liquefied Natural Gas (LNG)",4.5,"gallon"]
["Compressed Natural Gas (CNG)",5.4440000000000002E-2,"scf"]
[]
["CH4 and N2O Emissions for Highway Vehicles"]
["Note: As of the v9 Simplified GHG Calculation tool update, the latest mobile combustion factors reflect year 2020 data. Therefore, for all vehicle model years 2021 onward, the 2020 year factor is used. "]
["Vehicle Type","Year","CH4 Factor \n(g / mile)","N2O Factor \n(g / mile)","Notes"]
["Gasoline Passenger Cars","1984-93",7.0400000000000004E-2,6.4699999999999994E-2]
[null,1994,6.1699999999999998E-2,6.0299999999999999E-2]
[null,1995,5.3100000000000001E-2,5.6000000000000001E-2]
[null,1996,4.3400000000000001E-2,5.0299999999999997E-2]
[null,1997,3.3700000000000001E-2,4.4600000000000001E-2]
[null,1998,2.4E-2,3.8899999999999997E-2]
[null,1999,2.1499999999999998E-2,3.5499999999999997E-2]
[null,2000,1.7500000000000002E-2,3.04E-2]
[null,2001,1.0500000000000001E-2,2.12E-2]
[null,2002,1.0200000000000001E-2,2.07E-2]
[null,2003,9.4999999999999998E-3,1.8100000000000002E-2]
[null,2004,7.7999999999999996E-3,8.5000000000000006E-3]
[null,2005,7.4999999999999997E-3,6.7000000000000002E-3]
[null,2006,7.6E-3,7.4999999999999997E-3]
[null,2007,7.1999999999999998E-3,5.1999999999999998E-3]
[null,2008,7.1999999999999998E-3,4.8999999999999998E-3]
[null,2009,7.1000000000000004E-3,4.5999999999999999E-3]
[null,2010,7.1000000000000004E-3,4.5999999999999999E-3]
[null,2011,7.1000000000000004E-3,4.5999999999999999E-3]
[null,2012,7.1000000000000004E-3,4.5999999999999999E-3]
[null,2013,7.1000000000000004E-3,4.5999999999999999E-3]
[null,2014,7.1000000000000004E-3,4.5999999999999999E-3]
[null,2015,6.7999999999999996E-3,4.1999999999999997E-3]
[null,2016,6.4999999999999997E-3,3.8E-3]
[null,2017,5.4000000000000003E-3,1.8E-3]
[null,2018,5.1999999999999998E-3,1.6000000000000001E-3]
[null,2019,5.1000000000000004E-3,1.5E-3]
[null,2020,5.0000000000000001E-3,1.4E-3]
[null,2021,{"$f":"$C$96","v":5.0000000000000001E-3},{"$f":"D96","v":1.4E-3},"Held constant from most updated data (year 2020 factor)."]
[null,2022,{"$f":"$C$96","v":5.0000000000000001E-3},{"$f":"D97","v":1.4E-3},"Held constant from most updated data (year 2020 factor)."]
[null,2023,5.0000000000000001E-3,1.4E-3,"Held constant from most updated data (year 2020 factor)."]
["Gasoline Light-Duty Trucks","1987-93",8.1299999999999997E-2,0.10349999999999999]
["(Vans, Pickup Trucks, SUVs)",1994,6.4600000000000005E-2,9.8199999999999996E-2]
[null,1995,5.1700000000000003E-2,9.0800000000000006E-2]
[null,1996,4.5199999999999997E-2,8.7099999999999997E-2]
[null,1997,4.5199999999999997E-2,8.7099999999999997E-2]
[null,1998,4.1200000000000001E-2,7.8700000000000006E-2]
[null,1999,3.3300000000000003E-2,6.1800000000000001E-2]
[null,2000,3.4000000000000002E-2,6.3100000000000003E-2]
[null,2001,2.2100000000000002E-2,3.7900000000000003E-2]
[null,2002,2.4199999999999999E-2,4.24E-2]
[null,2003,2.2100000000000002E-2,3.73E-2]
[null,2004,1.15E-2,8.8000000000000005E-3]
[null,2005,1.0500000000000001E-2,6.4000000000000003E-3]
[null,2006,1.0800000000000001E-2,8.0000000000000002E-3]
[null,2007,1.03E-2,6.1000000000000004E-3]
[null,2008,9.4999999999999998E-3,3.5999999999999999E-3]
[null,2009,9.4999999999999998E-3,3.5999999999999999E-3]
[null,2010,9.4999999999999998E-3,3.5000000000000001E-3]
[null,2011,9.5999999999999992E-3,3.3999999999999998E-3]
[null,2012,9.5999999999999992E-3,3.3E-3]
[null,2013,9.4999999999999998E-3,3.5000000000000001E-3]
[null,2014,9.4999999999999998E-3,3.3E-3]
[null,2015,9.4000000000000004E-3,3.0999999999999999E-3]
[null,2016,9.1000000000000004E-3,2.8999999999999998E-3]
[null,2017,8.3999999999999995E-3,1.8E-3]
[null,2018,8.0999999999999996E-3,1.5E-3]
[null,2019,8.0000000000000002E-3,1.2999999999999999E-3]
[null,2020,7.9000000000000008E-3,1.1999999999999999E-3,"Assume these CH4 and N2O factors for ethanol light-duty vehicles"]
[null,2021,{"$f":"$C$127","v":7.9000000000000008E-3},{"$f":"$D$127","v":1.1999999999999999E-3},"Held constant from most updated data (year 2020 factor)."]
[null,2022,{"$f":"$C$127","v":7.9000000000000008E-3},{"$f":"$D$127","v":1.1999999999999999E-3},"Held constant from most updated data (year 2020 factor)."]
[null,2023,{"$f":"$C$127","v":7.9000000000000008E-3},{"$f":"$D$127","v":1.1999999999999999E-3},"Held constant from most updated data (year 2020 factor)."]
["Gasoline Heavy-Duty Vehicles","1985-86",0.40899999999999997,5.1499999999999997E-2]
[null,1987,0.36749999999999999,8.4900000000000003E-2]
[null,"1988-1989",0.34920000000000001,9.3299999999999994E-2]
[null,"1990-1995",0.3246,0.1142]
[null,1996,0.1278,0.16800000000000001]
[null,1997,9.2399999999999996E-2,0.1726]
[null,1998,6.5500000000000003E-2,0.17499999999999999]
[null,1999,6.4799999999999996E-2,0.1724]
[null,2000,6.3E-2,0.16600000000000001]
[null,2001,5.7700000000000001E-2,0.14680000000000001]
[null,2002,6.3399999999999998E-2,0.1673]
[null,2003,6.0199999999999997E-2,0.15529999999999999]
[null,2004,2.98E-2,1.6400000000000001E-2]
[null,2005,2.9700000000000001E-2,8.3000000000000001E-3]
[null,2006,2.9899999999999999E-2,2.41E-2]
[null,2007,3.2199999999999999E-2,1.5E-3]
[null,2008,3.4000000000000002E-2,1.5E-3]
[null,2009,3.39E-2,1.5E-3]
[null,2010,3.2000000000000001E-2,1.5E-3]
[null,2011,3.04E-2,1.5E-3]
[null,2012,3.1300000000000001E-2,1.5E-3]
[null,2013,3.1300000000000001E-2,1.5E-3]
[null,2014,3.15E-2,1.5E-3]
[null,2015,3.32E-2,2.0999999999999999E-3]
[null,2016,3.2099999999999997E-2,6.1000000000000004E-3]
[null,2017,3.2899999999999999E-2,8.3999999999999995E-3]
[null,2018,3.2599999999999997E-2,8.2000000000000007E-3]
[null,2019,3.3000000000000002E-2,9.1000000000000004E-3]
[null,2020,3.2800000000000003E-2,9.7999999999999997E-3,"Assumed these CH4 and N2O factors for ethanol heavy-duty vehicles and buses"]
[null,2021,{"$f":"$C$159","v":3.2800000000000003E-2},{"$f":"$D$159","v":9.7999999999999997E-3},"Held constant from most updated data (year 2020 factor)."]
[null,2022,{"$f":"$C$159","v":3.2800000000000003E-2},{"$f":"$D$159","v":9.7999999999999997E-3},"Held constant from most updated data (year 2020 factor)."]
[null,2023,3.2800000000000003E-2,9.7999999999999997E-3,"Held constant from most updated data (year 2020 factor)."]
["Gasoline Motorcycles","1960-1995",7.0000000000000001E-3,8.3000000000000001E-3]
[null,"1996-2005",0,0]
[null,"2006-2023",7.0000000000000001E-3,8.3000000000000001E-3,"Held constant for 2021 onwards from most recent data year (year 2020 data)."]
[]
["Vehicle Type","Fuel Type","Vehicle Year","CH4 Factor \n(g / mile)","N2O Factor \n(g / mile)","Notes"]
["Passenger Cars","Diesel","1960-1982",5.9999999999999995E-4,1.1999999999999999E-3]
[null,null,"1983-2006",5.0000000000000001E-4,1E-3]
[null,null,"2007-2023",3.0200000000000001E-2,1.9199999999999998E-2,"Held constant for 2021 onwards from most recent data year (year 2020 data)."]
["Light-Duty Trucks","Diesel","1960-1982",1.1000000000000001E-3,1.6999999999999999E-3]
[null,null,"1983-2006",8.9999999999999998E-4,1.4E-3]
[null,null,"2007-2023",2.9000000000000001E-2,2.1399999999999999E-2,"Held constant for 2021 onwards from most recent data year (year 2020 data)."]
["Medium- and Heavy-Duty Vehicles","Diesel","1960-2006",5.1000000000000004E-3,4.7999999999999996E-3]
[null,null,"2007-2023",9.4999999999999998E-3,4.3099999999999999E-2,"Held constant for 2021 onwards from most recent data year (year 2020 data)."]
["Light-Duty Cars","Methanol",null,1.4999999999999999E-2,4.0000000000000001E-3]
[null,"Ethanol",null,1.4999999999999999E-2,4.0000000000000001E-3]
[null,"CNG",null,0.14599999999999999,4.0000000000000001E-3]
[null,"LPG",null,1.4999999999999999E-2,4.0000000000000001E-3]
[null,"Biodiesel",null,0.03,1.9E-2]
["Light-Duty Trucks","Ethanol",null,1.6E-2,5.0000000000000001E-3]
[null,"CNG",null,0.158,5.0000000000000001E-3]
[null,"LPG",null,1.6E-2,5.0000000000000001E-3]
[null,"LNG",null,0.158,5.0000000000000001E-3]
[null,"Biodiesel",null,2.9000000000000001E-2,2.1000000000000001E-2]
["Medium-Duty Trucks","CNG",null,1.829,1E-3]
[null,"LPG",null,8.9999999999999993E-3,1.7999999999999999E-2]
[null,"LNG",null,1.829,1E-3]
[null,"Biodiesel",null,8.9999999999999993E-3,4.2999999999999997E-2]
["Heavy-Duty Trucks","Methanol",null,7.4999999999999997E-2,2.8000000000000001E-2]
[null,"Ethanol",null,7.4999999999999997E-2,2.8000000000000001E-2]
[null,"CNG",null,0.92100000000000004,0]
[null,"LPG",null,3.0000000000000001E-3,7.0000000000000001E-3]
[null,"LNG",null,0.92100000000000004,0]
[null,"Biodiesel",null,8.9999999999999993E-3,4.2999999999999997E-2]
["Buses","Methanol",null,0.10199999999999999,4.7E-2]
[null,"Ethanol",null,0.10199999999999999,4.7E-2]
[null,"CNG",null,2.7869999999999999,1E-3]
[null,"LPG",null,0.01,1.0999999999999999E-2]
[null,"LNG",null,2.7869999999999999,1E-3]
[null,"Biodiesel",null,8.9999999999999993E-3,4.2999999999999997E-2]
[]
["CH4 and N2O Emissions for Non-Road Vehicles"]
["Vehicle Type\n(superscript from EF Hub removed)","Fuel Type","CH4 Factor \n(g / gallon) ","N2O Factor \n(g / gallon) "]
["Ships and Boats","Residual Fuel Oil",1.1100000000000001,0.32]
[null,"Gasoline (2 stroke)",4.6100000000000003,0.08]
[null,"Gasoline (4 stroke)",2.25,0.01]
[null,"Diesel",6.41,0.17]
["Locomotives","Diesel",0.8,0.26]
["Aircraft","Jet Fuel",0,0.3]
[null,"Aviation Gasoline",7.06,0.11]
["Agricultural Equipment","Gasoline (2 stroke)",6.92,0.47]
[null,"Gasoline (4 stroke)",1.93,1.2]
[null,"Gasoline Off-Road Trucks",1.93,1.2]
[null,"Diesel Equipment",1.27,1.07]
[null,"Diesel Off-Road Trucks",0.91,0.56000000000000005]
[null,"LPG",0.33,0.94]
["Construction/Mining Equipment","Gasoline (2 stroke)",7.98,0.12]
[null,"Gasoline (4 stroke)",2.85,1.47]
[null,"Gasoline Off-Road Trucks",2.85,1.48]
[null,"Diesel Equipment",1.01,0.94]
[null,"Diesel Off-Road Trucks",0.91,0.56000000000000005]
[null,"LPG",0.59,0.5]
["Lawn and Garden Equipment","Gasoline (2 stroke)",7.28,0.31]
[null,"Gasoline (4 stroke)",2.99,1.49]
[null,"Diesel",0.67,0.49]
[null,"LPG",0.41,0.63]
["Airport Equipment","Gasoline",1.03,1.07]
[null,"Diesel",1.88,1.1599999999999999]
[null,"LPG",0.35,0.89]
["Industrial/Commercial Equipment","Gasoline (2 stroke)",7.12,0.5]
[null,"Gasoline (4 stroke)",2.74,1.54]
[null,"Diesel",0.41,0.6]
[null,"LPG",0.45,0.64]
["Logging Equipment","Gasoline (2 stroke)",9.68,0]
[null,"Gasoline (4 stroke)",3.24,2.0499999999999998]
[null,"Diesel",0.48,1.27]
["Railroad Equipment","Gasoline",3.24,1.81]
[null,"Diesel",0.38,0.95]
[null,"LPG",1.99,0.01]
["Recreational Equipment","Gasoline (2 stroke)",17.61,0.11]
[null,"Gasoline (4 stroke)",2.87,1.5]
[null,"Diesel",0.73,0.66,{"$nulls":251},{"$f":"SUM(B243:IU243)","v":1.3900000000000001}]
[null,"LPG",0.43,0.6]
[]
["Refrigerants and Global Warming Potentials (GWPs)"]
["Gas","GWP"]
["CO2 ",1]
["CH4",25]
["N2O",298]
["HFC-23",14800]
["HFC-32",675]
["HFC-41",92]
["HFC-125",3500]
["HFC-134",1100]
["HFC-134a",1430]
["HFC-143",353]
["HFC-143a",4470]
["HFC-152",53]
["HFC-152a",124]
["HFC-161",12]
["HFC-227ea",3220]
["HFC-236cb",1340]
["HFC-236ea",1370]
["HFC-236fa",9810]
["HFC-245ca",693]
["HFC-245fa",1030]
["HFC-365mfc",794]
["HFC-43-10mee",1640]
["SF6 ",22800]
["NF3",17200]
["CF4",7390]
["C2F6 ",12200]
["C3F8",8830]
["c-C4F8",10300]
["C4F10",8860]
["C5F12",9160]
["C6F14",9300]
["C10F18",">7,500"]
["Note: Global Warming Potential (GWP) factors in the 2023 Emission Factors update associated with the Simplified GHG Calculator Tool v9 release are based on AR4 GWPs, but EPA recognizes that Fifth Assessment Report (AR5) GWPs have been published and used in the Draft Inventory of U.S. Greenhouse Gas Emissions and Sinks: 1990-2021 report (published February 2023). However, this 2023 Emission Factors Hub and the GHG Reporting Program continue to use AR4 GWPs. EPA plans to incorporate AR5 GWPs into the 2024 Emission Factors Hub update."]
[]
[]
[null,"Blended Refrigerants (ASHRAE #)"]
["ASHRAE #","Blend GWP HFC/PFC","Blend Make-up"]
["R-401A",16,"53% HCFC-22 , 34% HCFC-124 , 13% HFC-152a"]
["R-401B",14,"61% HCFC-22 , 28% HCFC-124 , 11% HFC-152a"]
["R-401C",19,"33% HCFC-22 , 52% HCFC-124 , 15% HFC-152a"]
["R-402A",2100,"38% HCFC-22 , 6% HFC-125 , 2% propane"]
["R-402B",1330,"6% HCFC-22 , 38% HFC-125 , 2% propane"]
["R-403B",3444,"56% HCFC-22 , 39% PFC-218 , 5% propane"]
["R-404A",3922,"44% HFC-125 , 4% HFC-134a , 52% HFC 143a"]
["R-406A",0,"55% HCFC-22 , 41% HCFC-142b , 4% isobutane"]
["R-407A",2107,"20% HFC-32 , 40% HFC-125 , 40% HFC-134a"]
["R-407B",2804,"10% HFC-32 , 70% HFC-125 , 20% HFC-134a"]
["R-407C",1774,"23% HFC-32 , 25% HFC-125 , 52% HFC-134a"]
["R-407D",1627,"15% HFC-32 , 15% HFC-125 , 70% HFC-134a"]
["R-407E",1552,"25% HFC-32 , 15% HFC-125 , 60% HFC-134a"]
["R-408A",2301,"47% HCFC-22 , 7% HFC-125 , 46% HFC 143a"]
["R-409A",0,"60% HCFC-22 , 25% HCFC-124 , 15% HCFC-142b"]
["R-410A",2088,"50% HFC-32 , 50% HFC-125"]
["R-410B",2229,"45% HFC-32 , 55% HFC-125 "]
["R-411A",14,"87.5% HCFC-22 , 11 HFC-152a , 1.5% propylene"]
["R-411B",4,"94% HCFC-22 , 3% HFC-152a , 3% propylene"]
["R-413A",2053,"88% HFC-134a , 9% PFC-218 , 3% isobutane"]
["R-414A",0,"51% HCFC-22 , 28.5% HCFC-124 , 16.5% HCFC-142b"]
["R-414B",0,"5% HCFC-22 , 39% HCFC-124 , 9.5% HCFC-142b"]
["R-417A",2346,"46.6% HFC-125 , 5% HFC-134a , 3.4% butane"]
["R-422A",3143,"85.1% HFC-125 , 11.5% HFC-134a , 3.4% isobutane"]
["R-422D",2729,"65.1% HFC-125 , 31.5% HFC-134a , 3.4% isobutane"]
["R-423A",2280,"47.5% HFC-227ea , 52.5% HFC-134a ,  "]
["R-424A",2440,"50.5% HFC-125, 47% HFC-134a, 2.5% butane/pentane"]
["R-426A",1508,"5.1% HFC-125, 93% HFC-134a, 1.9% butane/pentane"]
["R-428A",3607,"77.5% HFC-125 , 2% HFC-143a , 1.9% isobutane"]
["R-434A",3245,"63.2% HFC-125, 16% HFC-134a, 18% HFC-143a, 2.8% isobutane"]
["R-500",32,"73.8% CFC-12 , 26.2% HFC-152a , 48.8% HCFC-22"]
["R-502",0,"48.8% HCFC-22 , 51.2% CFC-115 "]
["R-504",325,"48.2% HFC-32 , 51.8% CFC-115"]
["R-507",3985,"5% HFC-125 , 5% HFC143a"]
["R-508A",13214,"39% HFC-23 , 61% PFC-116"]
["R-508B",13396,"46% HFC-23 , 54% PFC-116"]
[]
["Molecular Weights"]
["Element","Atomic Weight"]
["Carbon",12.010999999999999]
[]
["Electricity Emission Factors (System Average)"]
[" CO2, CH4 and N2O Total Output Emission Factors by Subregion eGRID2021, January 2023."]
["Subregion",null,null,"CO2 Factor","CH4 Factor","N2O Factor"]
[null,null,null,"(lb CO2/MWh)","(lb CH4/MWh)","(lb N2O/MWh)"]
["AKGD (ASCC Alaska Grid)",null,null,1067.7,9.0999999999999998E-2,null,1.2E-2]
["AKMS (ASCC Miscellaneous)",null,null,485.2,2.5000000000000001E-2,null,4.0000000000000001E-3]
["AZNM (WECC Southwest)",null,null,819.7,5.1999999999999998E-2,null,7.0000000000000001E-3]
["CAMX (WECC California)",null,null,531.70000000000005,3.1E-2,null,4.0000000000000001E-3]
["ERCT (ERCOT All)",null,null,813.6,5.3999999999999999E-2,null,8.0000000000000002E-3]
["FRCC (FRCC All)",null,null,832.9,5.2999999999999999E-2,null,7.0000000000000001E-3]
["HIMS (HICC Miscellaneous)",null,null,1134.4000000000001,0.13500000000000001,null,2.1000000000000001E-2]
["HIOA (HICC Oahu)",null,null,1633.1,0.17599999999999999,null,2.7E-2]
["MROE (MRO East)",null,null,1582.1,0.14799999999999999,null,2.1999999999999999E-2]
["MROW (MRO West)",null,null,995.8,0.107,null,1.4999999999999999E-2]
["NEWE (NPCC New England)",null,null,539.4,7.1999999999999995E-2,null,8.9999999999999993E-3]
["NWPP (WECC Northwest)",null,null,634.6,5.8000000000000003E-2,null,8.0000000000000002E-3]
["NYCW (NPCC NYC/Westchester)",null,null,816.8,1.9E-2,null,2E-3]
["NYLI (NPCC Long Island)",null,null,1210.9000000000001,0.126,null,1.6E-2]
["NYUP (NPCC Upstate NY)",null,null,233.1,1.4999999999999999E-2,null,2E-3]
["PRMS (Puerto Rico Miscellaneous)",null,null,1558,8.1000000000000003E-2,null,1.2999999999999999E-2]
["RFCE (RFC East)",null,null,672.8,4.9000000000000002E-2,null,7.0000000000000001E-3]
["RFCM (RFC Michigan)",null,null,1214.0999999999999,0.115,null,1.6E-2]
["RFCW (RFC West)",null,null,1046.0999999999999,9.5000000000000001E-2,null,1.4E-2]
["RMPA (WECC Rockies)",null,null,1158.9000000000001,0.109,null,1.6E-2]
["SPNO (SPP North)",null,null,991.7,0.108,null,1.6E-2]
["SPSO (SPP South)",null,null,1031.5999999999999,0.08,null,1.2E-2]
["SRMV (SERC Mississippi Valley)",null,null,772.7,0.04,null,6.0000000000000001E-3]
["SRMW (SERC Midwest)",null,null,1543,0.17100000000000001,null,2.5000000000000001E-2]
["SRSO (SERC South)",null,null,891.9,6.7000000000000004E-2,null,0.01]
["SRTV (SERC Tennessee Valley)",null,null,931.6,8.6999999999999994E-2,null,1.2999999999999999E-2]
["SRVC (SERC Virginia/Carolina)",null,null,639.70000000000005,5.1999999999999998E-2,null,7.0000000000000001E-3]
["Note: These factors do not include upstream transmission and distribution emissions associated with delivered electricity. "]
[]
["Business Travel and Employee Commuting Emission Factors"]
["Vehicle Type","CO2 Factor \n(kg / unit)","CH4 Factor \n(g / unit)","N2O Factor \n(g / unit)","Units"]
["Passenger Car",0.313,8.0000000000000002E-3,7.0000000000000001E-3,"vehicle-mile"]
["Light-Duty Truck",0.46700000000000003,1.2999999999999999E-2,1.2E-2,"vehicle-mile"]
["Motorcycle",0.17799999999999999,0.111,1.9E-2,"vehicle-mile"]
["Intercity Rail - Northeast Corridor",5.8000000000000003E-2,5.4999999999999997E-3,6.9999999999999999E-4,"passenger-mile"]
["Intercity Rail - Other Routes",0.15,1.17E-2,3.8E-3,"passenger-mile"]
["Intercity Rail - National Average",0.113,9.1999999999999998E-3,2.5999999999999999E-3,"passenger-mile"]
["Commuter Rail",0.13500000000000001,1.09E-2,2.7000000000000001E-3,"passenger-mile"]
["Transit Rail (i.e. Subway, Tram)",9.6000000000000002E-2,8.0000000000000002E-3,1.1000000000000001E-3,"passenger-mile"]
["Bus",5.5E-2,6.3E-3,1.1000000000000001E-3,"passenger-mile"]
["Air Short Haul (< 300 miles)",0.20699999999999999,6.4000000000000003E-3,6.6E-3,"passenger-mile"]
["Air Medium Haul (>= 300 miles, < 2300 miles)",0.129,5.9999999999999995E-4,4.1000000000000003E-3,"passenger-mile"]
["Air Long Haul (>= 2300 miles)",0.16300000000000001,5.9999999999999995E-4,5.1999999999999998E-3,"passenger-mile"]
[]
["Upstream Transportation and Distribution Emission Factors"]
["Vehicle Type","CO2 Factor \n(kg / unit)","CH4 Factor \n(g / unit)","N2O Factor \n(g / unit)","Units"]
["Medium- and Heavy-Duty Truck",1.387,1.2999999999999999E-2,3.7999999999999999E-2,"vehicle-mile"]
["Passenger Car",0.313,8.0000000000000002E-3,7.0000000000000001E-3,"vehicle-mile"]
["Light-Duty Truck",0.46700000000000003,1.2999999999999999E-2,1.2E-2,"vehicle-mile"]
["Medium- and Heavy-Duty Truck",0.17,1.6000000000000001E-3,4.7000000000000002E-3,"ton-mile"]
["Rail",2.1000000000000001E-2,1.6000000000000001E-3,5.0000000000000001E-4,"ton-mile"]
["Waterborne Craft",4.3999999999999997E-2,2.5399999999999999E-2,1.1000000000000001E-3,"ton-mile"]
["Aircraft",0.69799999999999995,0,2.1499999999999998E-2,"ton-mile",null,null,null,"No update needed for v9 -- WARM not yet updated. "]
[]
["Fire Suppressant Leak Rates"]
["Type of Equipment","Leak Rate"]
["Fixed",3.5000000000000003E-2]
["Portable",2.5000000000000001E-2]
["Source:"]
["EPA (2021) Inventory of U.S. Greenhouse Gas Emissions and Sinks: 1990-2019. Page A-275."]
[]
["Waste Emission Factors"]
[null,null,"Metric Tons CO2e / Short Ton Material"]
["WARM Material","Material for SGEC Lookup \n(red text indicates different name from WARM)","Recycled","Landfilled","Combusted","Composted","Anaerobically Digested (Dry Digestate with Curing)","Anaerobically Digested (Wet  Digestate with Curing)"]
["Aluminum Cans","Aluminum Cans",0.06,0.02,0.01,"NA","NA","NA"]
["Aluminum Ingot","Aluminum Ingot",0.04,0.02,0.01,"NA","NA","NA"]
["Steel Cans","Steel Cans",0.32,0.02,0.01,"NA","NA","NA"]
["Copper Wire","Copper Wire",0.18,0.02,0.01,"NA","NA","NA"]
["Glass","Glass",0.05,0.02,0.01,"NA","NA","NA"]
["HDPE","HDPE",0.21,0.02,2.8,"NA","NA","NA"]
["LDPE","LDPE","NA",0.02,2.8,"NA","NA","NA"]
["PET","PET",0.23,0.02,2.0499999999999998,"NA","NA","NA"]
["LLDPE","LLDPE","NA",0.02,2.8,"NA","NA","NA"]
["PP","PP","NA",0.02,2.8,"NA","NA","NA"]
["PS","PS","NA",0.02,3.02,"NA","NA","NA"]
["PVC","PVC","NA",0.02,1.26,"NA","NA","NA"]
["PLA","PLA","NA",0.02,0.01,0.17,"NA","NA"]
["Corrugated Containers","Corrugated Containers",0.11,0.9,0.05,"NA","NA","NA"]
["Magazines/Third-class mail","Magazines and Third class mail",0.02,0.42,0.05,"NA","NA","NA"]
["Newspaper","Newspaper",0.02,0.35,0.05,"NA","NA","NA"]
["Office Paper","Office Paper",0.02,1.25,0.05,"NA","NA","NA"]
["Phonebooks","Phonebooks",0.04,0.35,0.05,"NA","NA","NA"]
["Textbooks","Textbooks",0.04,1.25,0.05,"NA","NA","NA"]
["Dimensional Lumber","Dimensional Lumber",0.09,0.17,0.05,"NA","NA","NA"]
["Medium-density Fiberboard","Medium density Fiberboard",0.15,7.0000000000000007E-2,0.05,"NA","NA","NA"]
["Food Waste (non-meat)","Food Waste non meat","NA",0.57999999999999996,0.05,0.15,0.14000000000000001,0.11]
["Food Waste (meat only)","Food Waste meat only","NA",0.57999999999999996,0.05,"NA",0.14000000000000001,0.11]
["Beef","Beef","NA",0.57999999999999996,0.05,0.15,0.14000000000000001,0.11]
["Poultry","Poultry","NA",0.57999999999999996,0.05,0.15,0.14000000000000001,0.11]
["Grains","Grains","NA",0.57999999999999996,0.05,0.15,0.14000000000000001,0.11]
["Bread","Bread","NA",0.57999999999999996,0.05,0.15,0.14000000000000001,0.11]
["Fruits and Vegetables","Fruits and Vegetables","NA",0.57999999999999996,0.05,0.15,0.14000000000000001,0.11]
["Dairy Products","Dairy Products","NA",0.57999999999999996,0.05,0.15,0.14000000000000001,0.11]
["Yard Trimmings","Yard Trimmings","NA",0.33,0.05,0.19,0.11,"NA"]
["Grass","Grass","NA",0.26,0.05,0.19,0.09,"NA"]
["Leaves","Leaves","NA",0.26,0.05,0.19,0.13,"NA"]
["Branches","Branches","NA",0.53,0.05,0.19,0.16,"NA"]
["Mixed Paper (general)","Mixed Paper general",7.0000000000000007E-2,0.8,0.05,"NA","NA","NA"]
["Mixed Paper (primarily residential)","Mixed Paper primarily residential",7.0000000000000007E-2,0.77,0.05,"NA","NA","NA"]
["Mixed Paper (primarily from offices)","Mixed Paper primarily from offices",0.03,0.75,0.05,"NA","NA","NA"]
["Mixed Metals","Mixed Metals",0.23,0.02,0.01,"NA","NA","NA"]
["Mixed Plastics","Mixed Plastics",0.22,0.02,2.34,"NA","NA","NA"]
["Mixed Recyclables","Mixed Recyclables",0.09,0.68,0.11,"NA","NA","NA"]
["Food Waste","Food Waste","NA",0.57999999999999996,0.05,0.15,"NA","NA"]
["Mixed Organics","Mixed Organics","NA",0.48,0.05,0.17,"NA","NA"]
["Mixed MSW","Mixed MSW municipal solid waste","NA",0.52,0.43,"NA","NA","NA"]
["Carpet","Carpet","NA",0.02,1.68,"NA","NA","NA"]
["Desktop CPUs","Desktop CPUs","NA",0.02,0.4,"NA","NA","NA"]
["Portable Electronic Devices","Portable Electronic Devices","NA",0.02,0.89,"NA","NA","NA"]
["Flat-panel Displays","Flat panel Displays","NA",0.02,0.74,"NA","NA","NA"]
["CRT Displays","CRT Displays","NA",0.02,0.64,"NA","NA","NA"]
["Electronic Peripherals","Electronic Peripherals","NA",0.02,2.23,"NA","NA","NA"]
["Hard-copy Devices","Hard copy Devices","NA",0.02,1.92,"NA","NA","NA"]
["Mixed Electronics","Mixed Electronics","NA",0.02,0.87,"NA","NA","NA"]
["Clay Bricks","Clay Bricks","NA",0.02,"NA","NA","NA","NA"]
["Concrete","Concrete",0.01,0.02,"NA","NA","NA","NA"]
["Fly Ash","Fly Ash",0.01,0.02,"NA","NA","NA","NA"]
["Tires","Tires",0.1,0.02,2.21,"NA","NA","NA"]
["Asphalt Concrete","Asphalt Concrete",0,0.02,"NA","NA","NA","NA"]
["Asphalt Shingles","Asphalt Shingles",0.03,0.02,0.7,"NA","NA","NA"]
["Drywall","Drywall","NA",0.02,"NA","NA","NA","NA"]
["Fiberglass Insulation","Fiberglass Insulation",0.05,0.02,"NA","NA","NA","NA"]
["Vinyl Flooring","Vinyl Flooring","NA",0.02,0.28999999999999998,"NA","NA","NA"]
["Wood Flooring","Wood Flooring","NA",0.18,0.08,"NA","NA","NA"]
["Notes: These factors do not include any avoided emissions impact from any of the disposal methods. All the factors presented here include transportation emissions, which are optional in the Scope 3 Calculation Guidance, with an assumed average distance traveled to the processing facility. AR4 GWPs are used to convert all waste emission factors into CO2e.   \n\nRecycling emissions include transport to recycling facility and sorting of recycled materials at material recovery facility.  \nLandfilling emissions include transport to landfill, equipment use at landfill and fugitive landfill CH4 emissions.  Landfill CH4 is based on typical landfill gas collection practices and average landfill moisture conditions.\nCombustion emissions include transport to combustion facility and combustion-related non-biogenic CO2 and N2O  \nComposting emissions include transport to composting facility, equipment use at composting facility and CH4 and N2O emissions during composting. "]

{"sheet":"DropDown","index":16,"n_rows":56,"n_cols":86,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
["Tab Navigation","Help Tab Navigation","Fuel Combusted","OnRoad","NonRoad","TYPE OF REFRIGERATION EQUIPMENT","CHOICES FOR REFRIGERANT","Fire Suppression Equipment","Fire Suppression Gas","GHGs","Electricity eGRID Subregions","Steam Fuel Type","Hydrogen Production Process","Travel by Vehicle Miles","Travel by Passenger Miles","Travel by Air","Product Transport Vehicle Type","Product Transport Type","Fuel","Fuel State","Gas","Liquid","Solid","Mass",null,"Aluminum Cans","Aluminum Ingot","Steel Cans","Copper Wire","Glass","HDPE","LDPE","PET","LLDPE","PP","PS","PVC","PLA","Corrugated Containers","Magazines and Third class mail","Newspaper","Office Paper","Phonebooks","Textbooks","Dimensional Lumber","Medium density Fiberboard","Food Waste non meat","Food Waste meat only","Beef","Poultry","Grains","Bread","Fruits and Vegetables","Dairy Products","Yard Trimmings","Grass","Leaves","Branches","Mixed Paper general","Mixed Paper primarily residential","Mixed Paper primarily from offices","Mixed Metals","Mixed Plastics","Mixed Recyclables","Food Waste","Mixed Organics","Mixed MSW municipal solid waste","Carpet","Desktop CPUs","Portable Electronic Devices","Flat panel Displays","CRT Displays","Electronic Peripherals","Hard copy Devices","Mixed Electronics","Clay Bricks","Concrete","Fly Ash","Tires","Asphalt Concrete","Asphalt Shingles","Drywall","Fiberglass Insulation","Vinyl Flooring","Wood Flooring","Facility Improvement Type"]
["Stationary Combustion","Help - Data Management","Anthracite Coal","Passenger Cars - Gasoline","Ships and Boats - Residual Fuel Oil","Domestic Refrigeration","CO2 ","Fixed","CO2 ","CO2 ",{"$f":"'Emission Factors'!A330","v":"AKGD (ASCC Alaska Grid)"},"Natural Gas","Steam methane reforming","Passenger Car",{"$f":"'Emission Factors'!A364","v":"Intercity Rail - Northeast Corridor"},"Air Short Haul (< 300 miles)","Medium- and Heavy-duty Truck","Medium- and Heavy-Duty Truck","Anthracite Coal","Solid","SCF","Gallons","Short Ton",{"$f":"'Unit Conversions'!A10","v":"gram (g)"},null,"Recycled","Recycled","Recycled","Recycled","Recycled","Recycled","Landfilled","Recycled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Recycled","Recycled","Recycled","Recycled","Recycled","Recycled","Recycled","Recycled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Recycled","Recycled","Recycled","Recycled","Recycled","Recycled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Recycled","Recycled","Recycled","Recycled","Recycled","Landfilled","Recycled","Landfilled","Landfilled"]
["Mobile Sources","Help - Stationary Combustion","Bituminous Coal","Light-Duty Trucks - Gasoline","Ships and Boats - Gasoline (2 stroke)","Stand-Alone Commercial","HFC-23","Portable","HFC-23","CH4",{"$f":"'Emission Factors'!A331","v":"AKMS (ASCC Miscellaneous)"},"Distillate Fuel Oil No. 2","Nuclear (LWR) high-termperature electrolysis","Light-Duty Truck",{"$f":"'Emission Factors'!A365","v":"Intercity Rail - Other Routes"},"Air Medium Haul (>= 300 miles, < 2300 miles)","Light-Duty Truck","Rail","Bituminous Coal","Solid","Therm","MMBtu","MMBtu",{"$f":"'Unit Conversions'!A11","v":"kilogram (kg)"},null,"Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Combusted","Landfilled","Combusted","Combusted","Combusted","Combusted","Combusted","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Combusted","Combusted","Combusted","Combusted","Combusted","Combusted","Combusted","Combusted","Combusted","Combusted","Combusted","Combusted","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Landfilled","Combusted","Combusted","Combusted","Combusted","Combusted","Combusted","Combusted","Combusted","Combusted","Combusted","Combusted",null,"Landfilled","Landfilled","Landfilled","Landfilled","Landfilled",null,"Landfilled","Combusted","Combusted"]
["Refrigeration and AC","Help - Mobile Sources","Sub-bituminous Coal","Heavy-Duty Vehicles - Gasoline","Ships and Boats - Gasoline (4 stroke)","Medium/Large Commercial","HFC-32",null,"HFC-125","N2O",{"$f":"'Emission Factors'!A332","v":"AZNM (WECC Southwest)"},"Residual Fuel Oil No. 6","Low-temperature electrolysis (PEM)","Motorcycle",{"$f":"'Emission Factors'!A366","v":"Intercity Rail - National Average"},"Air Long Haul (>= 2300 miles)","Passenger Car","Aircraft","Sub-bituminous Coal","Solid","MMBtu",null,null,{"$f":"'Unit Conversions'!A12","v":"metric ton"},null,"Combusted","Combusted","Combusted","Combusted","Combusted","Combusted",null,"Combusted",{"$nulls":4},"Composted","Combusted","Combusted","Combusted","Combusted","Combusted","Combusted","Combusted","Combusted","Composted","Anaerobically Digested (Dry Digestate with Curing)","Composted","Composted","Composted","Composted","Composted","Composted","Composted","Composted","Composted","Composted","Combusted","Combusted","Combusted","Combusted","Combusted","Combusted","Composted","Composted",{"$nulls":12},"Combusted",null,"Combusted"]
["Fire Suppression","Help - Refrigeration and AC","Lignite Coal","Motorcycles - Gasoline","Ships and Boats - Diesel","Transport Refrigeration","HFC-125",null,"HFC-134a","SF6 ",{"$f":"'Emission Factors'!A333","v":"CAMX (WECC California)"},"Kerosene","Coal gasification",null,{"$f":"'Emission Factors'!A367","v":"Commuter Rail"},null,null,"Waterborne Craft","Lignite Coal","Solid",null,null,null,{"$f":"'Unit Conversions'!A13","v":"pounds (lb)"},{"$nulls":22},"Anaerobically Digested (Dry Digestate with Curing)","Anaerobically Digested (Wet  Digestate with Curing)","Anaerobically Digested (Dry Digestate with Curing)","Anaerobically Digested (Dry Digestate with Curing)","Anaerobically Digested (Dry Digestate with Curing)","Anaerobically Digested (Dry Digestate with Curing)","Anaerobically Digested (Dry Digestate with Curing)","Anaerobically Digested (Dry Digestate with Curing)","Anaerobically Digested (Dry Digestate with Curing)","Anaerobically Digested (Dry Digestate with Curing)","Anaerobically Digested (Dry Digestate with Curing)","Anaerobically Digested (Dry Digestate with Curing)"]
["Purchased Gases","Help - Fire Suppression","Mixed (Commercial Sector)","Passenger Cars - Diesel","Locomotives - Diesel","Industrial Refrigeration","HFC-134a",null,"HFC-227ea","NF3",{"$f":"'Emission Factors'!A334","v":"ERCT (ERCOT All)"},"Liquefied Petroleum Gases (LPG)","Biomass gasification",null,{"$f":"'Emission Factors'!A368","v":"Transit Rail (i.e. Subway, Tram)"},null,null,null,"Mixed (Commercial Sector)","Solid",null,null,null,{"$f":"'Unit Conversions'!A14","v":"short ton"},{"$nulls":22},"Anaerobically Digested (Wet  Digestate with Curing)",null,"Anaerobically Digested (Wet  Digestate with Curing)","Anaerobically Digested (Wet  Digestate with Curing)","Anaerobically Digested (Wet  Digestate with Curing)","Anaerobically Digested (Wet  Digestate with Curing)","Anaerobically Digested (Wet  Digestate with Curing)","Anaerobically Digested (Wet  Digestate with Curing)"]
["Electricity","Help - Purchased Gases","Mixed (Electric Power Sector)","Light-Duty Trucks - Diesel","Aircraft - Jet Fuel","Chillers","HFC-143a",null,"HFC-236fa","HFC-23",{"$f":"'Emission Factors'!A335","v":"FRCC (FRCC All)"},"Anthracite Coal","Auto-thermal reforming",null,{"$f":"'Emission Factors'!A369","v":"Bus"},null,null,null,"Mixed (Electric Power Sector)","Solid"]
["Steam","Help - Electricity","Mixed (Industrial Coking)","Medium- and Heavy-Duty Vehicles - Diesel","Aircraft - Aviation Gasoline","Residential/Commercial A/C","HFC-152a",null,"CF4","HFC-32",{"$f":"'Emission Factors'!A336","v":"HIMS (HICC Miscellaneous)"},"Bituminous Coal","Other",{"$nulls":5},"Mixed (Industrial Coking)","Solid"]
["Business Travel","Help - Steam","Mixed (Industrial Sector)","Light-Duty Cars - Methanol","Agricultural Equipment - Gasoline (2 stroke)","Car A/C Units","HFC-236fa",null,"C4F10","HFC-125",{"$f":"'Emission Factors'!A337","v":"HIOA (HICC Oahu)"},"Sub-bituminous Coal",{"$nulls":6},"Mixed (Industrial Sector)","Solid"]
["Commuting","Help - Business Travel","Coal Coke","Light-Duty Cars - Ethanol","Agricultural Equipment - Gasoline (4 stroke)","Light-Duty Truck A/C Units","CF4",null,null,"HFC-134a",{"$f":"'Emission Factors'!A338","v":"MROE (MRO East)"},"Lignite Coal",{"$nulls":6},"Coal Coke","Solid"]
["Upstream Trans and Dist","Help - Commuting","Municipal Solid Waste","Light-Duty Cars - CNG","Agricultural Equipment - Gasoline Off-Road Trucks",null,"C2F6 ",null,null,"HFC-143a",{"$f":"'Emission Factors'!A339","v":"MROW (MRO West)"},"Mixed (Electric Power Sector)",{"$nulls":6},"Municipal Solid Waste","Solid"]
["Waste","Help - Upstream Trans and Dist","Petroleum Coke (Solid)","Light-Duty Cars - LPG","Agricultural Equipment - Diesel Equipment",null,"SF6 ",null,null,"HFC-152a",{"$f":"'Emission Factors'!A340","v":"NEWE (NPCC New England)"},"Coal Coke",{"$nulls":6},"Petroleum Coke (Solid)","Solid"]
["Offsets","Help - Market-Based Method","Plastics","Light-Duty Cars - Biodiesel","Agricultural Equipment - Diesel Off-Road Trucks",null,"R-401A",null,null,"HFC-236fa",{"$f":"'Emission Factors'!A341","v":"NWPP (WECC Northwest)"},"Wood and Wood Residuals",{"$nulls":6},"Plastics","Solid"]
[null,"Help - Offsets","Tires","Light-Duty Trucks - Ethanol","Agricultural Equipment - LPG",null,"R-401B",null,null,"CF4",{"$f":"'Emission Factors'!A342","v":"NYCW (NPCC NYC/Westchester)"},"Landfill Gas",{"$nulls":6},"Tires","Solid"]
[null,null,"Agricultural Byproducts","Light-Duty Trucks - CNG","Construction/Mining Equipment - Gasoline (2 stroke)",null,"R-401C",null,null,"C2F6 ",{"$f":"'Emission Factors'!A343","v":"NYLI (NPCC Long Island)"},{"$nulls":7},"Agricultural Byproducts","Solid"]
[null,null,"Peat","Light-Duty Trucks - LPG","Construction/Mining Equipment - Gasoline (4 stroke)",null,"R-402A",null,null,"C3F8",{"$f":"'Emission Factors'!A344","v":"NYUP (NPCC Upstate NY)"},{"$nulls":7},"Peat","Solid"]
[null,null,"Solid Byproducts","Light-Duty Trucks - LNG","Construction/Mining Equipment - Gasoline Off-Road Trucks",null,"R-402B",null,null,"C4F10","PRMS (Puerto Rico Miscellaneous)",{"$nulls":7},"Solid Byproducts","Solid"]
[null,null,"Wood and Wood Residuals","Light-Duty Trucks - Biodiesel","Construction/Mining Equipment - Diesel Equipment",null,"R-403B",null,null,"c-C4F8",{"$f":"'Emission Factors'!A346","v":"RFCE (RFC East)"},{"$nulls":7},"Wood and Wood Residuals","Solid"]
[null,null,"Natural Gas","Medium-Duty Trucks - CNG","Construction/Mining Equipment - Diesel Off-Road Trucks",null,"R-404A",null,null,"C5F12",{"$f":"'Emission Factors'!A347","v":"RFCM (RFC Michigan)"},{"$nulls":7},"Natural Gas","Gas"]
[null,null,"Propane Gas","Medium-Duty Trucks - LPG","Construction/Mining Equipment - LPG",null,"R-406A",null,null,"C6F14",{"$f":"'Emission Factors'!A348","v":"RFCW (RFC West)"},{"$nulls":7},"Propane Gas","Gas"]
[null,null,"Landfill Gas","Medium-Duty Trucks - LNG","Lawn and Garden Equipment - Gasoline (2 stroke)",null,"R-407A",null,null,"R-401A",{"$f":"'Emission Factors'!A349","v":"RMPA (WECC Rockies)"},{"$nulls":7},"Landfill Gas","Gas"]
[null,null,null,"Medium-Duty Trucks - Biodiesel","Lawn and Garden Equipment - Gasoline (4 stroke)",null,"R-407B",null,null,"R-401B",{"$f":"'Emission Factors'!A350","v":"SPNO (SPP North)"},{"$nulls":7},"Distillate Fuel Oil No. 2","Liquid"]
[null,null,"Distillate Fuel Oil No. 2","Heavy-Duty Trucks - Methanol","Lawn and Garden Equipment - Diesel",null,"R-407C",null,null,"R-401C",{"$f":"'Emission Factors'!A351","v":"SPSO (SPP South)"},{"$nulls":7},"Residual Fuel Oil No. 6","Liquid"]
[null,null,"Residual Fuel Oil No. 6","Heavy-Duty Trucks - Ethanol","Lawn and Garden Equipment - LPG",null,"R-407D",null,null,"R-402A",{"$f":"'Emission Factors'!A352","v":"SRMV (SERC Mississippi Valley)"},{"$nulls":7},"Kerosene","Liquid"]
[null,null,"Kerosene","Heavy-Duty Trucks - CNG","Airport Equipment - Gasoline",null,"R-407E",null,null,"R-402B",{"$f":"'Emission Factors'!A353","v":"SRMW (SERC Midwest)"},{"$nulls":7},"Liquefied Petroleum Gases (LPG)","Liquid"]
[null,null,"Liquefied Petroleum Gases (LPG)","Heavy-Duty Trucks - LPG","Airport Equipment - Diesel",null,"R-408A",null,null,"R-403B",{"$f":"'Emission Factors'!A354","v":"SRSO (SERC South)"},{"$nulls":7},"Biodiesel (100%)","Liquid"]
[null,null,"Biodiesel (100%)","Heavy-Duty Trucks - LNG","Airport Equipment - LPG",null,"R-409A",null,null,"R-404A",{"$f":"'Emission Factors'!A355","v":"SRTV (SERC Tennessee Valley)"},{"$nulls":7},"Ethanol (100%)","Liquid"]
[null,null,"Ethanol (100%)","Heavy-Duty Trucks - Biodiesel","Industrial/Commercial Equipment - Gasoline (2 stroke)",null,"R-410A",null,null,"R-406A",{"$f":"'Emission Factors'!A356","v":"SRVC (SERC Virginia/Carolina)"},{"$nulls":7},"Vegetable Oil","Liquid"]
[null,null,"Vegetable Oil","Buses - Methanol","Industrial/Commercial Equipment - Gasoline (4 stroke)",null,"R-410B",null,null,"R-407A"]
[null,null,null,"Buses - Ethanol","Industrial/Commercial Equipment - Diesel",null,"R-411A",null,null,"R-407B"]
[null,null,null,"Buses - CNG","Industrial/Commercial Equipment - LPG",null,"R-411B",null,null,"R-407C"]
[null,null,null,"Buses - LPG","Logging Equipment - Gasoline (2 stroke)",null,"R-413A",null,null,"R-407D"]
[null,null,null,"Buses - LNG","Logging Equipment - Gasoline (4 stroke)",null,"R-414A",null,null,"R-407E"]
[null,null,null,"Buses - Biodiesel","Logging Equipment - Diesel",null,"R-414B",null,null,"R-408A"]
[{"$nulls":4},"Railroad Equipment - Gasoline",null,"R-417A",null,null,"R-409A"]
[{"$nulls":4},"Railroad Equipment - Diesel",null,"R-422A",null,null,"R-410A"]
[{"$nulls":4},"Railroad Equipment - LPG",null,"R-422D",null,null,"R-410B"]
[{"$nulls":4},"Recreational Equipment - Gasoline (2 stroke)",null,"R-423A",null,null,"R-411A"]
[{"$nulls":4},"Recreational Equipment - Gasoline (4 stroke)",null,"R-424A",null,null,"R-411B"]
[{"$nulls":4},"Recreational Equipment - Diesel",null,"R-426A",null,null,"R-413A"]
[{"$nulls":4},"Recreational Equipment - LPG",null,"R-428A",null,null,"R-414A"]
[{"$nulls":6},"R-434A",null,null,"R-414B"]
[{"$nulls":6},"R-500",null,null,"R-417A"]
[{"$nulls":6},"R-502",null,null,"R-422A"]
[{"$nulls":6},"R-504",null,null,"R-422D"]
[{"$nulls":6},"R-507",null,null,"R-423A"]
[{"$nulls":6},"R-508A",null,null,"R-424A"]
[{"$nulls":6},"R-508B",null,null,"R-426A"]
[{"$nulls":9},"R-428A"]
[{"$nulls":9},"R-434A"]
[{"$nulls":9},"R-500"]
[{"$nulls":9},"R-502"]
[{"$nulls":9},"R-504"]
[{"$nulls":9},"R-507"]
[{"$nulls":9},"R-508A"]
[{"$nulls":9},"R-508B"]

{"sheet":"Help - Stationary Combustion","index":17,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":false,"merged":[[18,1,18,5],[5,0,5,5],[8,0,8,5],[10,1,10,5],[11,1,11,5],[14,0,14,5],[19,1,19,5],[20,1,20,5],[21,1,21,5],[23,2,23,5],[43,1,43,5]]}
[{"$nulls":10},"Back to Introduction Tab"]
[]
["Scope 1 Emissions from Stationary Combustion Sources - HELP SHEET"]
[]
["DEFINITION"]
["Combustion emission sources are stationary sources that combust fuel, like a natural gas hot water heater for an office building or an oil burning boiler.  Emissions result from the actual combustion of the fuels to produce useful products, like heat and hot water. "]
[]
["COLLECT"]
["To account for these sources, collect information about the type of fuel used and the quantity of fuel combusted at each facility.  Sources of data can vary, but the data are often provided by the utility organization that supplies the fuel to the organization.  A monthly natural gas bill, for example, can be used to provide information regarding how much natural gas was purchased for the previous billing cycle. "]
["Data Collection Checklist (for all facilities)"]
["-","Type of fuel consumed"]
["-","Amount of fuel consumed"]
[]
["QUANTIFY"]
["After the data has been collected, it should be entered into the appropriate orange colored boxes of the Calculator section titled “Stationary Combustion.”  The fuel type can be selected from the form.  After the data are entered into the Calculator, the CO2 equivalent emissions are displayed in the blue colored box.  "]
[]
[]
["Items to Note"]
["-","Use the heat content sheet to convert units provided on the invoice into the units the Calculator requires. "]
["-","If you are one of many tenants in a facility and you do not have the actual amount of fuel used in your space, you may estimate your fuel usage by multiplying the fuel usage of the entire facility by the percentage of the floor area that your organization occupies."]
["-","Companies with home offices can optionally include these spaces in their inventory if the energy use associated with business activities can be reasonably estimated.  "]
["-","The Energy Information Administration conducts a Commercial Building Energy Consumption Survey and provides average energy consumption by building type per square foot.  Use the numbers below to compare against your data or to estimate for natural gas if no data are available. For example, if you have a 1,000 sq ft office suite in the Northeast multiply by 20.6 to get an estimation of 20,600 scf natural gas for a year.  "]
[]
[null,"Natural Gas Intensity","standard cubic feet (scf) natural gas / sq ft / year"]
[null,"Principal Building Activity","Northeast","Midwest","South","West"]
[null,"Education",41.5,38.700000000000003,21.2,21.9]
[null,"Food sales ","Insufficient Data",75.400000000000006,"Insufficient Data","Insufficient Data"]
[null,"Food service ","Insufficient Data",212,152.19999999999999,106.4]
[null,"Health care ",58.2,59.4,63.5,54.2]
[null,"Inpatient ",89.5,71.099999999999994,76,84]
[null,"Outpatient ",30.9,34,22.8,22.4]
[null,"Lodging ",45.7,44.1,27.1,38.6]
[null,"Mercantile ",41.9,41.4,28.9,37.1]
[null,"Retail (other than mall) ",25,26.4,20,22.5]
[null,"Enclosed and strip malls ",49.2,58.9,34.200000000000003,43.9]
[null,"Office ",20.6,26.3,18.7,18.600000000000001]
[null,"Public assembly ",52.6,48.5,28.7,33.5]
[null,"Public order and safety ","Insufficient Data","Insufficient Data",40.200000000000003,34.799999999999997]
[null,"Religious worship ",33.799999999999997,28.6,16.7,17.399999999999999]
[null,"Service ",38.200000000000003,38.299999999999997,51.3,39.1]
[null,"Warehouse and storage ",19.3,27.7,13.5,10.4]
[null,"Other ",38.700000000000003,"Insufficient Data",21.2,"Insufficient Data"]
[null,"Vacant ","Insufficient Data","Insufficient Data","Insufficient Data","Insufficient Data"]
[null,"Source: EIA's Commercial Buildings Energy Consumption Survey (CBECS) 2018, Released September 2022.  Table C25: Natural gas consumption and conditional energy intensity by Census region, 2018"]
[null,"https://www.eia.gov/consumption/commercial/data/2018/index.php?view=characteristics"]

{"sheet":"Help - Refrigeration and AC","index":18,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[13,1,13,4],[5,0,5,4],[8,0,8,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[24,1,24,4],[25,1,25,4],[27,1,27,4],[14,1,14,4],[17,0,17,4],[18,1,18,4],[19,1,19,4],[20,1,20,4],[23,1,23,4]]}
[{"$nulls":10},"Back to Introduction Tab"]
[]
["Scope 1 Emissions from Refrigeration and Air Conditioning Equipment - HELP SHEET"]
[]
["DEFINITION"]
["Refrigeration and Air Conditioning (AC) equipment sources can vary in size based on the type of organization.  Emissions from refrigeration and AC devices, in facilities or vehicles, are caused by the leakage of chemicals with global warming impact during use, maintenance and/or disposal of the device.  They are often small sources for office-based organizations.  For example, a small office building may have one rooftop AC unit while a grocery store chain may have several \nrooftop AC units per store as well as a multitude of other refrigeration equipment.  "]
[]
["COLLECT"]
["Choose one of three different calculation methods available in the “Refrigeration and AC” section of the Calculator.  The types of refrigerants along with the data needs for each method are listed in the Calculator.  Data for these sources is often collected from maintenance and inspection records, work orders, or invoices from contractors that service this equipment.  Refrigerants not included on the list may be chemicals that do not need to be included in the inventory.  For example, ozone depleting substances, such as chlorofluorocarbons (CFCs) or “freon” and hydrochlorofluorocarbons (HCFCs), are regulated internationally and are typically excluded from a GHG inventory or reported as a memo item.  A reason to track these sources is to provide explanation for the increase of HFCs and PFCs when they replace the phased out CFCs and HCFCs. "]
["Data Collection Checklist (by equipment)"]
["-","Refrigerant purchase, inventory, and disposal data"]
["-","Inventory of equipment by facility"]
["-","Refrigerant capacity of equipment"]
["-","Amount of refrigerant (HFC and PFC) emitted over the inventory reporting period"]
["-","Optional: Track HCFC and CFCs, such as R-22"]
[]
["QUANTIFY"]
["Determine which of the three options is suitable for your business and enter the data into the appropriate orange colored boxes of the Calculator section titled “Refrigeration and AC.”  Once the data are entered into the Calculator, the CO2 equivalent emissions are calculated and summarized in the blue colored box."]
[null,"Option 1: The Detailed Material Balance Method is recommended for companies who maintain their own equipment. This method requires data from inventories, purchase and service records, and the full and proper charges of equipment. It includes emissions from equipment operation, servicing, and disposal. "]
[null,"Option 2: The Simplified Material Balance Method is recommended for companies who have contractors service their HFC/PFC containing equipment. This method tracks emissions from equipment operation, servicing, and disposal. The method requires data on the quantity of refrigerant: (a) used to fill new equipment during installation, (b) used to service equipment, and (c) recovered from retiring equipment, as well as the full and proper charges of new and retiring equipment. If notified in advance of the need for this information, the contractor should be able to provide it."]
[null,"Option 3: It is recommended that the Screening Method be used only as a screening tool because the emission factors used in the approach are highly uncertain. Emission factors vary between individual pieces of equipment and over time. Even if the amount of refrigerant added to a piece of equipment has been tracked carefully, permitting the previous leak rate of that equipment to be established, that leak rate can change after a leak is repaired or as the equipment ages. "]
[]
["Items to Note"]
["-","If you are one of many tenants in a facility and you cannot quantify the refrigerant emissions specific to your space, you may estimate them based on the percentage of the floor area that your organization occupies."]
["-","Emissions from refrigerants in an office-based organization are typically less than 2 percent of emissions.  Consider this as you decide which Option is most appropriate.  "]
["-","If your organization uses a refrigerant that is not listed, the user may need to determine the constituent blend.  This website lists common refrigerant compositions:"]
[null,"http://www.epa.gov/ozone/snap/refrigerants/refblend.html"]
["-"," R-134a is the predominantly used refrigerant in vehicle AC systems.  If you are uncertain of which refrigerant \n your vehicles use, you can assume R-134a."]

{"sheet":"Help - Fire Suppression","index":19,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[16,0,16,4],[19,1,19,4],[5,0,5,4],[8,0,8,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4]]}
[{"$nulls":10},"Back to Introduction Tab"]
[]
["Scope 1 Emissions from Fire Suppression Equipment - HELP SHEET"]
[]
["DEFINITION"]
["Fire suppression emission sources can range in scale from a small portable fire extinguisher to a large scale fire suppression system for an office building or warehouse.  The emissions are caused by chemicals (e.g., HFCs or CO2) emitted from fire suppression devices during use, maintenance, and disposal."]
[]
["COLLECT"]
["Choose one of three different calculation methods available in the “Fire Suppression” section of the Calculator.  In each method, choose the types of fire suppression gases used and then gather the corresponding emissions data.  Data for these sources is often collected from maintenance and inspection records, work orders, or invoices from contractors that service this equipment. "]
["Data Collection Checklist (by equipment and/or facility)"]
["-","Fire suppressant purchase, inventory, and disposal data"]
["-","Inventory of equipment by facility"]
["-","Fire suppressant capacity of equipment"]
["-","Amount of fire suppressant (HFC and PFC) emitted over the inventory reporting period"]
[]
["QUANTIFY"]
["Enter the data into the appropriate orange colored boxes of the Calculator section titled “Fire Suppression.”  Once the data are entered into the Calculator, the CO2 equivalent emissions are calculated and summarized in the blue colored box. "]
[]
["Items to Note"]
["-","Contact the manufacturer if you cannot find the list of propellants or chemicals used in the fire extinguisher.   "]

{"sheet":"Help - Purchased Gases","index":20,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,1,19,4],[5,0,5,4],[8,0,8,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[16,0,16,4]]}
[{"$nulls":10},"Back to Introduction Tab"]
[]
["Scope 1 Emissions from Purchased Gases - HELP SHEET"]
[]
["DEFINITION"]
["Industrial gases are sometimes used in processes such as manufacturing, testing, or laboratory uses.  For example, CO2 gas is often used in welding operations.  These gases are typically released to the atmosphere after use.  Any releases of the seven major greenhouse gases (CO2, CH4, N2O, PFCs, HFCs, SF6, and NF3) must be included in the GHG inventory.  Ozone depleting substances, such as CFCs and HCFCs, are regulated internationally and are typically excluded from a GHG inventory or reported as a memo item."]
[]
["COLLECT"]
["Determine if CO2, CH4, N2O, PFCs, HFCs,  SF6 or NF3 are used in processes such as those mentioned above.  If so, collect the mass of gas purchased.  If data are not available in mass units, the user may need to convert from volume to mass using the density of the specific gas."]
[]
["Data Collection Checklist (for all applicable facilities)"]
["-","Type of gas purchased"]
["-","Amount of gas purchased"]
["-","Purpose for the gas"]
[]
["QUANTIFY"]
["Enter the data into the appropriate orange colored boxes of the Calculator section titled “Gas.”  Once the data are entered into the Calculator, the CO2 equivalent emissions are calculated and summarized in the blue colored box. "]
[]
["Items to Note"]
["-","If your business makes bulk purchases and plans on using the gas for several years, you should divide the bulk amount by the years of usage and report that amount."]

{"sheet":"Help - Electricity","index":21,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[15,0,15,5],[5,0,5,5],[8,0,8,5],[10,1,10,5],[11,1,11,5],[12,1,12,5],[26,2,26,5],[46,1,46,5],[16,0,16,5],[17,0,17,5],[21,1,21,5],[22,1,22,5],[23,1,23,5],[24,1,24,5]]}
[{"$nulls":10},"Back to Introduction Tab"]
[]
["Scope 2 Emissions from Purchase of Electricity - HELP SHEET"]
[]
["DEFINITION"]
["GHGs are emitted when fossil fuels are combusted to generate electricity.  Companies account for their responsibility for these emissions by reporting them as scope 2 indirect emissions. This Calculator quantifies emissions from both the location-based method and the market-based method, and both totals should be reported.  The location-based method considers average emission factors for the electricity grids that provide electricity.  The market-based method considers contractual arrangements under which the organization procures power from specific sources, such as renewable energy.  Market-based emission factors reflect these arrangements. Examples of market-based emission factors are: renewable energy certificates (RECs), power purchase agreements (PPAs), and supplier-specific factors.  For detailed information on the location-based method and the market-based method review EPA's Indirect Emissions from Purchased Electricity Guidance (link at the bottom of this sheet)."]
[]
["COLLECT"]
["Collect electricity purchase information in units of kWh for each facility.  The best data source is typically its electricity bill or invoice.  In the Calculator, there is a map at the bottom of the “Electricity” section which divides the United States into subregions based on the electric grid.  Select the subregion(s) in which the organization’s facilities are located to determine the correct CO2, CH4, and N2O emission factors to use, since different parts of the country use different fuels to generate electricity. Multiple facility locations can be entered as separate line items in the Calculator.  If a facility is on the border of a subregion, enter the zip code into EPA's Power Profiler (https://oaspub.epa.gov/powpro/ept_pack.charts) to find the correct subregion.  "]
["Data Collection Checklist (for all facilities)"]
["-","Amount of electricity purchased"]
["-","Amount of electricity purchased using contractual arrangements "]
["-","Emission factors (CO2, CH4 and N2O) for contractual arrangements"]
[]
["QUANTIFY"]
["There are two methods to quantify emissions from electricity: location-based and market-based.  Both must be quantified to be in accordance with the Center for Corporate Climate Leadership Greenhouse Gas Inventory Guidance.  "]
["Location-based: Enter the data into the appropriate orange colored boxes (Table 1) of the Calculator section titled \"Electricity.”  Once the data are entered into the Calculator, the CO2 equivalent emissions are calculated and summarized in the blue colored box for the location based method. "]
["Market-based: Enter applicable market-based emission factors (lb/MWh) for the purchased electricity in the yellow cells (Table 1) of the Calculator section titled \"Electricity.”  See the market-based method Help sheet for additional guidance. Once the data are entered into the Calculator, the CO2 equivalent emissions are calculated and summarized in the blue colored box for the market-based method. "]
[]
[]
["Items to Note"]
["-","If you are one of many tenants in a facility and you do not have the actual amount of electricity used in your space, you may estimate your usage by multiplying the electricity usage of the entire facility by the percentage of the floor area that your organization occupies."]
["-","The number off the utility bill to use is the total usage amount (i.e., the difference between the meter reading at the beginning of the month and the end of the month)."]
["-","Companies with home offices can optionally include these spaces in their inventory if the energy use associated with business activities can be reasonably estimated.  "]
["-","The Energy Information Administration conducts a Commercial Building Energy Consumption Survey and provides average energy consumption by building type per square foot.  Use the numbers below to compare against your data or to estimate if no data are available. For example, if you have a 1,000 sq ft office suite in the Northeast multiply by 17.1 to get an estimation of 17,100 kWh electricity for a year.  "]
[]
[null,"Electricity Intensity","kWh electricity / sq ft / year"]
[null,"Principal Building Activity","Northeast","Midwest","South","West"]
[null,"Education",7.9,8.1,11.4,9]
[null,"Food sales ","Insufficient Data",67.3,53.7,"Insufficient Data"]
[null,"Food service ",29.7,43,52.7,36.9]
[null,"Health care ",19,25,27.3,22.2]
[null,"Inpatient ",22.4,28.3,32.200000000000003,29.5]
[null,"Outpatient ",15.9,18.600000000000001,19.600000000000001,15.9]
[null,"Lodging ",13.7,14.8,15.2,13.2]
[null,"Mercantile ",15.1,15.4,17.8,17.2]
[null,"Retail (other than mall) ",11.3,12.7,15.3,13]
[null,"Enclosed and strip malls ",17.899999999999999,18.899999999999999,20.2,20.100000000000001]
[null,"Office ",13.8,12,15.4,12.5]
[null,"Public assembly ",9.6,11.6,15.1,9.4]
[null,"Public order and safety ","Insufficient Data","Insufficient Data",16.7,11.6]
[null,"Religious worship ",5.0999999999999996,4.2,5.4,4.2]
[null,"Service ",7.3,5.7,9,7.6]
[null,"Warehouse and storage ",6,5.2,6.5,5.5]
[null,"Other ",31.4,24,25.3,45.5]
[null,"Vacant ","Insufficient Data",4.2,4.9000000000000004,"Insufficient Data"]
[null,"Source: Commercial Buildings Energy Consumption Survey (CBECS) 2012, Released September 2022.  Table C15: Electricity consumption and conditional energy intensity by Census region, 2018"]
[null,"https://www.eia.gov/consumption/commercial/data/2018/index.php?view=characteristics"]
[]
["Refer to the Greenhouse Gas Inventory Guidance: Indirect Emissions from Purchased Electricity Guidance for more information. "]
[null,"https://www.epa.gov/climateleadership/scope-1-and-scope-2-inventory-guidance"]

{"sheet":"Help - Market-Based Method","index":22,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,0,2,7],[5,0,5,8],[6,1,6,2],[6,3,6,8],[7,1,7,2],[7,3,7,8],[8,1,8,2],[8,3,8,8],[9,1,9,2],[9,3,9,8],[10,1,10,2],[10,3,10,8],[26,0,26,8],[11,1,11,2],[11,3,11,8],[15,0,15,8],[15,9,15,10],[16,0,16,8],[16,9,16,10],[17,0,17,8],[17,9,17,10],[18,0,18,8],[19,0,19,8],[23,1,23,8],[36,5,36,7],[37,5,37,7],[85,0,85,1],[86,0,86,1],[100,0,100,1]]}
[{"$nulls":10},"Back to Introduction Tab"]
[]
["Market-Based Method - HELP SHEET"]
[]
["Market-Based Electricity Emission Factors"]
["The market-based method considers contractual arrangements under which the organization procures electricity from specific sources, such as fossil, renewable, or other generation facilities. Market-based emission factors reflect these arrangements. The following are the types of market-based emission factors available, listed in order of preference based on the precision of the factors.  If any of the first four types of emission factors are applicable, enter the factors in the yellow cells marked as \"<enter factor>\".  If not, leave the yellow cells as is, and eGRID subregion factors will be used for market-based emissions. "]
["(1)","Energy Attribute Certificates",null,"If an energy attribute certificate carries with it an emission factor, that factor can be used to quantify emissions in the market-based method.  Examples are renewable energy certificates (RECs) or Guarantees of Origin (GOs).  The emission factor is based on the specific source that the certificate represents, regardless of the energy resource used.  Typically these certificates represent renewable energy and may have an emission factor of zero, but they may in some cases have a non-zero emission factor (e.g., if there is a fossil-fuel or biomass generation component). "]
["(2)","Contracts",null,"An organization may have a contract, such as a power purchase agreement (PPA), to purchase electricity from a specified generating facility, which may be located at the organization's facility, at a nearby location with a direct line connection to the organization, or located remotely.  If there are no certificates available, the contract itself carries the emission factor associated with the generation facility, regardless of the energy resource used.  If certificates are used, see Energy Attribute Certificates above.  "]
["(3)","Supplier-Specific Emission Factor",null,"An electricity supplier, such as a regulated utility or a deregulated supplier, may provide information to its customers on the emission factor associated with its electricity product.  To be used in the market-based method, the emission factor must include all the electricity delivered by the supplier, including electricity it generates as well as electricity it purchases from others.  "]
["(4)","Residual Mix Factor",null,"A residual mix emission factor represents the emissions and generation that remain after certificates, contracts, and supplier-specific factors have been claimed and removed from the calculation.  Residual mix emission factors are currently not widely available.  Organizations are encouraged to check for available residual mix factors each year when their GHG inventory is completed, if the options above are not available or relevant."]
["(5)","Regional Emission Factor",null,"If residual mix factors are not available, organizations can use a regional grid average emission factor as the default.  This calculator will use eGRID subregion emission factors in this case."]
["(6)","National Emission Factor",null,"This should not be applicable for any companies reporting US based emissions, due to the availability of regional emission factors. "]
[]
["Quality Criteria for Contractual Instruments"]
["All contractual instruments used in the market-based method must meet the following criteria:"]
["  (1)  Convey the direct GHG emission rate attribute associated with the unit of electricity produced."]
["  (2)  Be the only instruments that carry the GHG emission rate attribute claim associated with that quantity of electricity generation.\n        See the \"Items to Note\" section of the Help sheet for suggested estimation approaches. "]
["  (3)  Be tracked and redeemed, retired, or canceled by or on behalf of the reporting entity.  This can be done through a tracking \n       system, an audit of contracts, third-party certification, or other means. "]
["  (4)  Have a vintage that matches as closely as possible to the date of the reporting period to which the instruments are \n        applied.  The vintage of the instrument is based on the date of the energy generation that the instrument represents.  "]
["  (5)  Be sourced from the same market in which the reporting entity’s electricity-consuming operations are located and \n         to which the instrument is applied. A market is defined as a geographical area which has a common system for \n         trading and retiring contractual instruments. For this purpose the U.S. constitutes a single market, despite regional \n        grid boundaries."]
["The Indirect Emissions from Purchased Electricity Guidance defines EPA best-practice quality recommendations that go beyond these minimum requirements. "]
[]
["Items to Note"]
["-","EPA encourages organizations to use renewable energy as a way to reduce the environmental impacts associated with the electricity they purchase. Organizations can reduce their market-based scope 2 emissions by purchasing renewable energy, or “green power.” They can do this by choosing a differentiated electricity product from their utility or electricity supplier, by contracting directly with a renewable energy generator (if the regulatory rules allow), or by purchasing unbundled renewable energy certificates (RECs). In any case, the RECs must be acquired and retired."]
[]
["An Example"]
["In a situation where an organization has procured electricity from a specific source that is relevant to report for the market-based method, but the source supplies less than 100% of the kWh consumed by the facility, it is important to enter the data correctly.  Consider the following scenario: "]
[null,"- 100,000 kWh total facility consumption"]
[null,"- 25,000 kWh purchased with energy attribute certificates such as renewable energy certificates (RECs)."]
[null,"- Emission factors for RECs from many RE sources are zero."]
[null,"- No other market-based emission factors are available. "]
[]
["The table below shows how to enter the data for this example site. There are two rows entered for the facility in order to allocate the market-based emissions to the appropriate kWh."]
["The total Electricity Purchased (kWh) of the two rows adds up to facility's total consumption.  Be careful not to double count kWh."]
["The REC emission factors are entered in the first row.  In the second row, there is no need to enter market-based emission factors, because none are available."]
[]
[{"$nulls":5},"Market-Based\nUse these cells to enter contractual or supplier specific emission factors"]
["Table 1.  Total Amount of Electricity Purchased by eGRID Subregion",{"$nulls":4},"Emission Factors"]
["Source","Source","Source","eGRID Subregion","Electricity","CO2","CH4 ","N2O "]
["ID","Description","Area (sq ft)","where electricity is consumed","Purchased","Emissions","Emissions","Emissions"]
[{"$nulls":4},"(kWh)","(lb/MWh)","(lb/MWh)","(lb/MWh)"]
["Building A","Wind Farm RECs",6000,"RFCW (RFC West)",25000,0,0,0]
["Building A","Local Utility ",6000,"RFCW (RFC West)",{"$f":"100000-E42","v":75000},"<enter factor>","<enter factor>","<enter factor>"]
[]
[]
["Refer to the Greenhouse Gas Inventory Guidance: Indirect Emissions from Purchased Electricity Guidance for more information. "]
[null,"https://www.epa.gov/climateleadership/center-corporate-climate-leadership-greenhouse-gas-inventory-guidance"]

{"sheet":"Help - Steam","index":23,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[15,0,15,4],[18,1,18,4],[19,1,19,5],[5,0,5,4],[5,6,5,11],[8,0,8,4],[10,1,10,4],[11,1,11,4],[12,1,12,4]]}
[{"$nulls":10},"Back to Introduction Tab"]
[]
["Scope 2 Emissions from Purchase of Steam - HELP SHEET"]
[]
["DEFINITION"]
["Similar to electricity production, GHGs are emitted when fossil fuels are combusted to generate heat or steam.  If the organization purchases heat or steam, the emissions are accounted for as scope 2 indirect emissions. Also similar to electricity, both the location-based method and the market-based method should be calculated and reported as done in this Calculator. Typically supplier-specific emission factors for steam will apply to both location-based and market-based emissions, and no market-based emission factors need to be entered.  If needed, see the market-based method Help Sheet for more information.  "]
[]
["COLLECT"]
["Determine the amount of steam purchased, the types of fuel that the steam supplier uses to generate the steam, and either the emission factors provided by the steam supplier or the boiler efficiency.  If values for boiler efficiency are unavailable, a default of 80% is provided in the Calculator.  "]
["Data Collection Checklist (for all facilities)"]
["-","Amount of steam purchased "]
["-","Fuel type used to generate steam"]
["-","Boiler efficiency or supplier-specific emission factors"]
[]
["QUANTIFY"]
["Enter the data into the appropriate orange colored boxes (Table 1) of the Calculator section titled “Steam.”  Once the data are entered into the Calculator, the CO2 equivalent emissions are calculated and summarized in the blue colored box.  Enter the market-based emission factors in the yellow cells if applicable."]
[]
["Items to Note"]
["-","Use the heat content sheet to convert units provided on the invoice into the units the Calculator requires. "]
["-","If you are one of many tenants in a facility and you do not have the actual amount of steam used in your space, you may estimate your usage by multiplying the steam usage of the entire facility by the percentage of the floor area that your organization occupies."]

{"sheet":"Help - Hydrogen","index":24,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[13,0,13,4],[16,1,16,4],[3,0,3,4],[3,6,3,11],[6,0,6,4],[8,1,8,4],[9,1,9,4],[10,1,10,4]]}
["Scope 2 Emissions from Purchase of Hydrogen - HELP SHEET",{"$nulls":9},"Back to Introduction Tab"]
[]
["DEFINITION"]
["Similar to electricity production, GHGs may be emitted when hydrogen is produced.  If the organization purchases hydrogen, the emissions are accounted for as scope 2 indirect emissions. Typically, a supplier of hydrogen will understand the greenhouse gas emissions associated with their production process (as is necessary to claim certain incentives)."]
[]
["COLLECT"]
["Determine the amount of hydrogen purchased, the process and types of fuel that the hydrogen supplier uses to produce the hydrogen, and the emission factors provided by the hydrogen producer.  If values are unavailable, use the assumptions provided below."]
["Data Collection Checklist (for all facilities)"]
["-","Amount of steam purchased "]
["-","Fuel type used to generate steam"]
["-","Boiler efficiency or supplier-specific emission factors"]
[]
["QUANTIFY"]
["Enter the data into the appropriate orange colored boxes (Table 1) of the Calculator section titled “Hydrogen.”  Once the data are entered into the Calculator, the CO2 equivalent emissions are calculated and summarized in the blue colored box. "]
[]
["Items to Note"]
["-","Use the heat content sheet to convert units provided on the invoice into the units the Calculator requires. "]

{"sheet":"Sector List","index":25,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Sector","Facility Improvement Types","AOI 2B","Eligible SAEP"]
["Aluminum","Establish New Facility","Ammonia","1.  Property designed to be used to produce energy from the sun, water, wind, geothermal deposits, or other renewable resources."]
["Cement and Concrete","Re-Equip Existing Facility, already operational by the applicant","Organic chemicals","2.  Fuel cells, microturbines, or energy storage systems and components. "]
["Chemicals","Re-Equip Existing Facility, not yet operational by the applicant","Cement, concrete or components such as supplementary cementitious materials","3.  Electric grid modernization equipment or components."]
["Food and Beverage","Expand Existing Facility, already operational by the applicant","Iron","4.  Property designed to capture, transport, remove, use, or sequester carbon oxide emissions."]
["Glass","Expand Existing Facility, not yet operational by the applicant","Steel","5.  Equipment designed to refine, electrolyze, or blend any fuel, chemical, or product which is renewable, or low-carbon and low-emission."]
["Iron and Steel",null,"Aluminum","6.  Property designed to produce energy conservation technologies (including for residential, commercial, and industrial applications). "]
["Pulp and Paper",null,"Glass","7.  Light-, medium-, or heavy-duty electric or fuel cell vehicles, as well as technologies, components, or materials for such vehicles, and associated charging or refueling infrastructure."]
["Refining",null,"Other","8.  Hybrid vehicles with a gross vehicle weight rating of not less than 14,000 pounds as well as technologies, components, or materials for such vehicles."]
["Other",null,"N/A","9.A  Specialized components and equipment for nuclear power reactors or their fuels"]
["N/A",null,null,"9.B  Equipment used to reduce the emissions of industrial processes not otherwise defined. "]
[null,null,null,"N/A"]
["Process Changes"]
["low- or zero carbon process heat systems"]
["carbon capture, transport, utliziation and storage systems"]
["energy efficiency"]
["reduction in waste from industrial processes"]
["electrification"]
["use of alternative feedstocks"]
["fuel switching"]
["material efficiency "]
["changes to process unit operations and/or chemistry"]
["other"]
["N/A"]