{"text_format":"1","workbook":"xlsx","n_sheets":34,"sheets":["Introduction","Boundary Questions","Summary","Stationary Combustion","Mobile Sources","Refrigeration and AC","Fire Suppression","Purchased Gases","Waste Gases","Electricity","Steam","Business Travel","Commuting","Product Transport","RECs-Green Power","Offsets","Unit Conversions","Heat Content","Emission Factors","DropDown","Help - Data Management","Help - Stationary Combustion","Help - Mobile Sources","Help - Refrigeration and AC","Help - Fire Suppression","Help - Purchased Gases","Help - Waste Gases","Help - Electricity","Help - Market-Based Method","Help - Steam","Help - Business Travel","Help - Commuting","Help - Product Transport","Help - Offsets"],"not_rendered":{"charts":0,"images":120,"macros":1,"external_links":1,"defined_names":106,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":39,"n_cols":18,"rows_kept":39,"cut":false,"hidden":false,"merged":[[3,0,3,10],[9,1,9,10],[10,2,10,10],[20,0,20,10],[35,0,35,10],[5,0,5,10],[38,0,38,10],[37,1,37,10],[8,0,8,10],[6,3,6,10],[40,0,41,10],[36,0,36,10],[19,0,19,10],[24,4,24,5],[22,4,22,8],[11,1,11,10],[14,1,14,10],[17,0,17,10],[18,0,18,10]]}
[]
[]
["EPA Simplified GHG Emissions Calculator (SGEC)",null,null,null,null,null,"Version 4","January 2017"]
["The EPA Simplified GHG Emissions Calculator (\"the Calculator\") is designed as a simplified calculation tool to help organizations estimate and inventory their annual greenhouse gas (GHG) emissions for US-based operations. All methodologies and default values provided were based on the most current Center for Corporate Climate Leadership Greenhouse Gas Inventory Guidance Documents and the Emission Factors Hub. The Calculator will quantify the direct and indirect emissions from sources at an organization when activity data are entered into the various sections of the workbook for one annual period."]
[]
["Before entering data, please: 1) Enable Macros and 2) Familiarize yourself with the Guide to Greenhouse Gas Management for Small Business & Low Emitters. \n"]
[null,"Download the guide: ",null,"https://www.epa.gov/climateleadership/center-corporate-climate-leadership-small-business-and-low-emitters-guide"]
[]
["There are three primary steps in completing a GHG inventory.  Each emissions source also has these three steps."]
[null,"(1) DEFINE: The first step in completing a GHG inventory is to determine the boundaries and emissions sources included within those boundaries. After you have defined your organizational and operational boundaries, you can use the questions on the \"Boundary Questions\" worksheet to help you determine which emissions sources are relevant to your business.  "]
[null,null,"Go to Boundary Questions"]
[null,"(2) COLLECT: The second step is to collect data for the defined annual period. This step is typically the most time consuming, since the data can be difficult to gather. This Calculator has help sheets with suggestions and guidance for each emissions source and a general help sheet for data management. Click the drop down menu boxes below to navigate to these sheets. "]
[]
[null,null,null,"Help - Market-Based Method",null,null,null,null,null,null,null,null," "," "," "," "," "," "]
[null,"(3) QUANTIFY: The third step is to calculate emissions. This Calculator is designed to complete the emissions quantification step for you. Once the user enters data in this MS Excel spreadsheet, the emissions will be calculated and totaled on the \"Summary\" sheet. ",null,null,null,null,null,null,null,null,null," "," "]
[]
["Calculator Guidance - Important Information"]
["  (A) Navigate to the data entry sheets using the drop down menu in the dark grey cell below and then clicking on the \"Go To Data Entry Sheet\" \n         button. On the data entry sheets enter data in ORANGE cells only.  "]
["  (B) This Calculator has several \"Tool Sheets\" with useful reference data such as unit conversions, heat contents, and emission factors.  \n         Click on the buttons below to go to the appropriate Tool Sheet."]
["  (C) Data must be entered in the units specified on the data entry sheets. Use the \"Unit Conversions\" or \"Heat Content\" sheets if unit \n         conversion is necessary prior to entering data into the Calculator."]
["  (D) If more guidance is needed, you can reference the emission factor data sources found on the \"Emission Factors\" sheet."]
[]
[null,null,null,"Tool Sheets","Quick Data Entry Navigation"]
[]
[null,null,null,null,"Stationary Combustion"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Calculator Notes"]
["Emission sources of all seven major GHGs are accounted for in the inventory and in this Calculator: carbon dioxide (CO2), methane (CH4), nitrous oxide (N2O), hydroﬂuorocarbons (HFCs), perﬂuorocarbons (PFCs), sulfur hexaﬂuoride (SF6), and nitrogen trifluoride (NF3). The Calculator allows the user to estimate GHG emissions from scope 1 (direct), scope 2 (indirect), and some scope 3 (other indirect) sources.   "]
["The Calculator uses U.S.-specific cross-sector emission factors from the Emission Factors Hub. Many industrial sectors also have process-related emissions sources that are specific to their sector. EPA’s Greenhouse Gas Reporting Program provides guidance and tools that can aid in the calculation and reporting of these emissions:"]
[null,"https://www.epa.gov/ghgreporting"]
["The GHG Protocol also provides guidance on calculating emissions from industrial processes.  "]

{"sheet":"Boundary Questions","index":1,"n_rows":44,"n_cols":5,"rows_kept":44,"cut":false,"hidden":false,"merged":[[37,0,37,3],[39,0,39,3],[41,0,41,3],[13,0,13,5],[24,0,24,3],[8,0,8,5],[5,0,5,5],[35,0,35,5],[35,6,35,7],[33,0,33,3],[16,0,16,3],[18,0,18,3],[26,0,26,3],[27,0,27,3],[20,0,20,3],[22,0,22,3],[14,0,14,7]]}
[]
[]
["Operational Boundary Questions - Emissions Sources to Include"]
[]
["Guidance"]
["Use the questions below to help you determine which emissions sources should be included in the inventory."]
[]
["Emissions Source Questions"]
["A typical office-based organization will likely have the following (scope 1 and scope 2) emissions sources:"]
[null,"- Stationary Combustion"]
[null,"- Refrigeration and AC"]
[null,"- Electricity"]
[]
["If you answer \"yes\" to a question below, that emissions source should be included in your inventory. For each facility within the defined organizational boundary, collect the necessary data for the selected time period. Use the corresponding Excel sheet to quantify these emissions."]
["Tip: you may need to ask your landlord about heating sources, steam purchased and refrigerants"]
["Stationary Combustion",null,null,null,"Yes or No?"]
["Do you have facilities that burn fuels on-site (e.g., natural gas, propane, coal, fuel oil for heating, diesel fuel for backup generators, biomass fuels)?",null,null,null,"Y"]
["Mobile Sources"]
["Do any vehicles fall within your organizational boundary?  This can include cars, trucks, propane forklifts, aircraft, boats.  Only vehicles owned or leased by your organization should be included here.",null,null,null,"?"]
["Refrigeration and Air Conditioning"]
["Do your facilities use refrigeration or air conditioning equipment?",null,null,null,"?"]
["Fire Suppression"]
["Do your facilities use chemical fire suppressants?",null,null,null,"?"]
["Purchased Gases"]
["Do you purchase any industrial gases for use in your business?  These gases may be purchased for use in manufacturing, testing, or laboratories.",null,null,null,"?"]
["Waste Gases"]
["Are VOCs combusted in thermal oxidizers in your facilities? ",null,null,null,"?"]
["Do you flare any gases on-site?",null,null,null,"?"]
["Electricity"]
["Does your inventory include facilities that use electricity?",null,null,null,"?"]
["Steam"]
["Do you purchase steam for heating or cooling in your facilities?",null,null,null,"?"]
["Market-Based Emission Factors (entered on Electricity and or Steam tabs)"]
["Do you purchase renewable energy certificates (RECs) or green power products? Do you purchase electricity through a power purchase agreement (PPA)? Do you have supplier-specific emission factors? ",null,null,null,"?"]
[]
["The questions below refer to scope 3 emissions sources and offsets.  If you answer \"yes\" you may choose whether or not to include these emissions sources in your inventory. Use the corresponding sheet to enter data."]
["Business Travel",null,null,null,"Yes or No?"]
["Do your employees travel for business using transportation other than owned or leased vehicles (e.g., commercial airline flights, rental cars, trains)?",null,null,null,"?"]
["Employee Commuting"]
["Do your employees commute to work in personal vehicles or use public transportation?",null,null,null,"?"]
["Product Transport"]
["Do you hire another company to transport products or other materials to or from your facilities? ",null,null,null,"?"]
["Offsets"]
["Do you purchase greenhouse gas offsets?",null,null,null,"?"]

{"sheet":"Summary","index":2,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":false,"merged":[[5,0,5,8],[6,0,6,5],[13,0,13,8],[27,4,27,8],[18,4,18,8],[20,4,20,8],[17,4,17,8],[19,4,19,8],[22,4,22,8],[25,4,25,8],[26,4,26,8],[23,7,23,8],[7,0,8,8],[9,0,11,8]]}
[]
[]
["Emissions Summary"]
[]
["Guidance"]
["The total GHG emissions from each source category are provided below. You may also use this summary            sheet to fill out the Annual GHG Inventory Summary and Goal Tracking Form as this calculator only                     quantifies one year of emissions at a time. "]
["http://www.epa.gov/climateleadership/documents/summaryform.xls"]
["By entering the data below into the appropriate cell of the Annual GHG Inventory Summary and Goal Tracking Form, you will be able to compare multiple years of data."]
[]
[" If you have multiple Calculator files covering sub-sets of your inventory for a particular reporting period, sum each of the emission categories (e.g. Stationary Combustion) to an organizational total, which then can be entered into the Annual GHG Inventory Summary and Goal Tracking Form."]
[]
[]
[]
["    (A) Enter organization information into the orange cells. Other cells on this sheet will be automatically calculated from the data entered in the sheets in this workbook. Blue cells indicate required emission sources if applicable. Green cells indicate scope 3 emission sources and offsets, which organizations may optionally include in their inventory."]
["    (B) The \"Go To Sheet\" buttons can be used to navigate to the data entry sheets. "]
[]
["Organizational Information:"]
[null,"Organization Name:"]
[]
[null,"Organization Address:"]
[]
[]
[null,"Inventory Reporting Period:",null,null,"e.g., Calendar Year 2014, Fiscal Year 2014"]
[null,null,null,null,"Start: ","MM/DD/YY","End:","MM/DD/YY"]
[]
[null,"Name of Preparer:"]
[null,"Phone Number of Preparer:"]
[null,"Date Prepared:"]
[]
["Summary of Organization's Emissions:"]
[]
[null,"Scope 1 Emissions"]
[null,"Stationary Combustion",null,null,null,null,{"$f":"'Stationary Combustion'!E95+'Waste Gases'!E47","v":0},"CO2-e (metric tons)"]
[null,"Mobile Sources",null,null,null,null,{"$f":"'Mobile Sources'!E177","v":0},"CO2-e (metric tons)"]
[null,"Refrigeration / AC Equipment Use",null,null,null,null,{"$f":"'Refrigeration and AC'!F130","v":0},"CO2-e (metric tons)"]
[null,"Fire Suppression",null,null,null,null,{"$f":"'Fire Suppression'!F109","v":0},"CO2-e (metric tons)"]
[null,"Purchased Gases",null,null,null,null,{"$f":"'Purchased Gases'!E30","v":0},"CO2-e (metric tons)"]
[]
[null,"Location-Based Scope 2 Emissions"]
[null,"Purchased and Consumed Electricity",null,null,null,null,{"$f":"Electricity!E63","v":0},"CO2-e (metric tons)"]
[null,"Purchased and Consumed Steam",null,null,null,null,{"$f":"Steam!F113","v":0},"CO2-e (metric tons)"]
[]
[null,"Market-Based Scope 2 Emissions"]
[null,"Purchased and Consumed Electricity",null,null,null,null,{"$f":"Electricity!E64","v":0},"CO2-e (metric tons)"]
[null,"Purchased and Consumed Steam",null,null,null,null,{"$f":"Steam!F114","v":0},"CO2-e (metric tons)"]
[]
[null,"Total organization Emissions"]
[null,"Total Scope 1 & Location-Based Scope 2",null,null,null,null,{"$f":"SUM(G33:G37,G40:G41)","v":0},"CO2-e (metric tons)"]
[null,"Total Scope 1 & Market-Based Scope 2 ",null,null,null,null,{"$f":"SUM(G33:G37,G44:G45)","v":0},"CO2-e (metric tons)"]
[]
[null,"Reductions"]
[null,"Offsets",null,null,null,null,{"$f":"Offsets!C25","v":0},"CO2-e (metric tons)"]
[]
[null,"Net Scope 1 and 2 Location-Based Emissions",null,null,null,null,{"$f":"G48-G52","v":0},"CO2-e (metric tons)"]
[null,"Net Scope 1 and 2 Market-Based Emissions",null,null,null,null,{"$f":"G49-G51","v":0},"CO2-e (metric tons)"]
[]
[null,"Scope 3 Emissions"]
[null,"Employee Business Travel",null,null,null,null,{"$f":"'Business Travel'!D163","v":0},"CO2-e (metric tons)"]
[null,"Employee Commuting",null,null,null,null,{"$f":"Commuting!D121","v":0},"CO2-e (metric tons)"]
[null,"Product Transport",null,null,null,null,{"$f":"'Product Transport'!D112","v":0},"CO2-e (metric tons)"]
[]
[null,"Required Supplemental Information"]
[null,"Biomass CO2 Emissions from Stationary Sources",null,null,null,null,{"$f":"'Stationary Combustion'!E97","v":0},"CO2-e (metric tons)"]
[null,"Biomass CO2 Emissions from Mobile Sources",null,null,null,null,{"$f":"'Mobile Sources'!E179","v":0},"CO2-e (metric tons)"]

{"sheet":"Stationary Combustion","index":3,"n_rows":97,"n_cols":21,"rows_kept":97,"cut":false,"hidden":false,"merged":[[12,5,13,5],[8,0,8,6],[77,0,77,1],[7,0,7,4],[5,0,5,4],[62,0,63,1],[62,3,63,3]]}
[]
[]
["Scope 1 Emissions from Stationary Combustion Sources"]
[]
["Guidance"]
["   (A) Enter annual data for each combustion unit, facility, or site (by fuel type) in ORANGE cells on Table 1.  Example \n         entry is shown in first row (GREEN Italics)."]
["- Select \"Fuel Combusted\" from drop down box."]
["- Enter \"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. "]
["   (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. "]
["(C) Biomass CO2 emissions are not reported in the total emissions, but are reported separately at the bottom of the sheet."]
[]
["Table 1.  Stationary Source Fuel Combustion"]
["Source","Source","Source","Fuel","Quantity","Units"]
["ID","Description","Area (sq ft)","Combusted","Combusted"]
["BLR-012","East Power Plant",12517,"Natural Gas",10000,"MMBtu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,DropDown!$Q$2:$R$12,2,FALSE))","v":"Gas"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D16=\"\",\"\",VLOOKUP(D16,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D17=\"\",\"\",VLOOKUP(D17,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D18=\"\",\"\",VLOOKUP(D18,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D19=\"\",\"\",VLOOKUP(D19,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D20=\"\",\"\",VLOOKUP(D20,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D21=\"\",\"\",VLOOKUP(D21,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D22=\"\",\"\",VLOOKUP(D22,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D23=\"\",\"\",VLOOKUP(D23,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D24=\"\",\"\",VLOOKUP(D24,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D25=\"\",\"\",VLOOKUP(D25,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D26=\"\",\"\",VLOOKUP(D26,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D27=\"\",\"\",VLOOKUP(D27,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D28=\"\",\"\",VLOOKUP(D28,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D29=\"\",\"\",VLOOKUP(D29,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D31=\"\",\"\",VLOOKUP(D31,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D32=\"\",\"\",VLOOKUP(D32,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D33=\"\",\"\",VLOOKUP(D33,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D34=\"\",\"\",VLOOKUP(D34,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D35=\"\",\"\",VLOOKUP(D35,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D36=\"\",\"\",VLOOKUP(D36,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D37=\"\",\"\",VLOOKUP(D37,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D38=\"\",\"\",VLOOKUP(D38,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D39=\"\",\"\",VLOOKUP(D39,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D40=\"\",\"\",VLOOKUP(D40,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D41=\"\",\"\",VLOOKUP(D41,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D42=\"\",\"\",VLOOKUP(D42,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D43=\"\",\"\",VLOOKUP(D43,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D44=\"\",\"\",VLOOKUP(D44,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D46=\"\",\"\",VLOOKUP(D46,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D47=\"\",\"\",VLOOKUP(D47,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D48=\"\",\"\",VLOOKUP(D48,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D49=\"\",\"\",VLOOKUP(D49,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D50=\"\",\"\",VLOOKUP(D50,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D51=\"\",\"\",VLOOKUP(D51,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D52=\"\",\"\",VLOOKUP(D52,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D53=\"\",\"\",VLOOKUP(D53,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D54=\"\",\"\",VLOOKUP(D54,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D55=\"\",\"\",VLOOKUP(D55,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D56=\"\",\"\",VLOOKUP(D56,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D57=\"\",\"\",VLOOKUP(D57,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D58=\"\",\"\",VLOOKUP(D58,DropDown!$Q$2:$R$12,2,FALSE))","v":""}]
[]
["GHG Emissions"]
[]
["Total Organization-Wide Stationary Source Combustion by Fuel Type"]
["Fuel Type",null,"Quantity","Units"]
[null,null,"Combusted"]
["Anthracite Coal",null,{"$f":"SUMIFS($E$16:$E$58,$D$16:$D$58,$A65,$F$16:$F$58,\"short ton\")+(SUMIFS($E$16:$E$58,$D$16:$D$58,$A65,$F$16:$F$58,\"MMBtu\")*'Heat Content'!$D$14)","v":0},"short tons"]
["Bituminous Coal",null,{"$f":"SUMIFS($E$16:$E$58,$D$16:$D$58,$A66,$F$16:$F$58,\"short ton\")+(SUMIFS($E$16:$E$58,$D$16:$D$58,$A66,$F$16:$F$58,\"MMBtu\")*'Heat Content'!$D$15)","v":0},"short tons"]
["Sub-bituminous Coal",null,{"$f":"SUMIFS($E$16:$E$58,$D$16:$D$58,$A67,$F$16:$F$58,\"short ton\")+(SUMIFS($E$16:$E$58,$D$16:$D$58,$A67,$F$16:$F$58,\"MMBtu\")*'Heat Content'!$D$16)","v":0},"short tons"]
["Lignite Coal",null,{"$f":"SUMIFS($E$16:$E$58,$D$16:$D$58,$A68,$F$16:$F$58,\"short ton\")+(SUMIFS($E$16:$E$58,$D$16:$D$58,$A68,$F$16:$F$58,\"MMBtu\")*'Heat Content'!$D$18)","v":0},"short tons"]
["Natural Gas",null,{"$f":"SUMIFS($E$16:$E$58,$D$16:$D$58,$A69,$F$16:$F$58,\"scf\")+(SUMIFS($E$16:$E$58,$D$16:$D$58,$A69,$F$16:$F$58,\"MMBtu\")*'Heat Content'!$D$7)+(SUMIFS($E$16:$E$58,$D$16:$D$58,$A69,$F$16:$F$58,\"Therm\")*'Heat Content'!$D$9)","v":0},"scf"]
["Distillate Fuel Oil No. 2",null,{"$f":"SUMIFS($E$16:$E$58,$D$16:$D$58,$A70,$F$16:$F$58,\"gallons\")+(SUMIFS($E$16:$E$58,$D$16:$D$58,$A70,$F$16:$F$58,\"MMBtu\")*'Heat Content'!$D$21)","v":0},"gallons"]
["Residual Fuel Oil No. 6",null,{"$f":"SUMIFS($E$16:$E$58,$D$16:$D$58,$A71,$F$16:$F$58,\"gallons\")+(SUMIFS($E$16:$E$58,$D$16:$D$58,$A71,$F$16:$F$58,\"MMBtu\")*'Heat Content'!$D$22)","v":0},"gallons"]
["Kerosene",null,{"$f":"SUMIFS($E$16:$E$58,$D$16:$D$58,$A72,$F$16:$F$58,\"gallons\")+(SUMIFS($E$16:$E$58,$D$16:$D$58,$A72,$F$16:$F$58,\"MMBtu\")*'Heat Content'!$D$23)","v":0},"gallons"]
["Liquefied Petroleum Gases (LPG)",null,{"$f":"SUMIFS($E$16:$E$58,$D$16:$D$58,$A73,$F$16:$F$58,\"gallons\")+(SUMIFS($E$16:$E$58,$D$16:$D$58,$A73,$F$16:$F$58,\"MMBtu\")*'Heat Content'!$D$24)","v":0},"gallons"]
["Wood and Wood Residuals",null,{"$f":"SUMIFS($E$16:$E$58,$D$16:$D$58,$A74,$F$16:$F$58,\"short ton\")+(SUMIFS($E$16:$E$58,$D$16:$D$58,$A74,$F$16:$F$58,\"MMBtu\")*'Heat Content'!$D$20)","v":0},"short tons"]
["Landfill Gas",null,{"$f":"SUMIFS($E$16:$E$58,$D$16:$D$58,$A75,$F$16:$F$58,\"scf\")+(SUMIFS($E$16:$E$58,$D$16:$D$58,$A75,$F$16:$F$58,\"MMBtu\")*'Heat Content'!$D$26)+(SUMIFS($E$16:$E$58,$D$16:$D$58,$A75,$F$16:$F$58,\"Therm\")*'Heat Content'!$D$26/10)","v":0},"scf"]
[]
["Total Organization-Wide CO2, CH4 and N2O Emissions from Stationary Source Fuel Combustion"]
["Fuel Type",null,"CO2 (kg)","CH4 (g)","N2O (g)"]
["Anthracite Coal",null,{"$f":"$C65*VLOOKUP($A79,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"$C65*VLOOKUP($A79,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"$C65*VLOOKUP($A79,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
["Bituminous Coal",null,{"$f":"$C66*VLOOKUP($A80,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},0,0]
["Sub-bituminous Coal",null,0,0,0]
["Lignite Coal",null,0,0,0]
["Natural Gas",null,0,0,0]
["Distillate Fuel Oil No. 2",null,0,0,0]
["Residual Fuel Oil No. 6",null,0,{"$f":"$C71*VLOOKUP($A85,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"$C71*VLOOKUP($A85,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
["Kerosene",null,0,0,0]
["Liquefied Petroleum Gases (LPG)",null,0,0,0]
["Total Fossil Fuel Emissions",null,{"$f":"SUM(C79:C87)","v":0},{"$f":"SUM(D79:D87)","v":0},{"$f":"SUM(E79:E87)","v":0}]
["Wood and Wood Residuals",null,{"$f":"$C74*VLOOKUP($A89,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"$C74*VLOOKUP($A89,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"$C74*VLOOKUP($A89,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
["Landfill Gas",null,{"$f":"$C75*VLOOKUP(A90,Stationary_Fuel_Fctrs_unit,5,FALSE)","v":0},{"$f":"$C75*VLOOKUP($A90,Stationary_Fuel_Fctrs_unit,6,FALSE)","v":0},{"$f":"$C75*VLOOKUP($A90,Stationary_Fuel_Fctrs_unit,7,FALSE)","v":0}]
["Total Non-Fossil Fuel Emissions",null,{"$f":"SUM(C89:C90)","v":0},{"$f":"SUM(D89:D90)","v":0},{"$f":"SUM(E89:E90)","v":0}]
["Total Emissions for all Fuels",null,{"$f":"C88+C91","v":0},{"$f":"D88+D91","v":0},{"$f":"E88+E91","v":0}]
[]
[]
["Total CO2 Equivalent Emissions  (metric tons) - Stationary Combustion",null,null,null,{"$f":"(C88+(D88/1000*CH4_GWP)+(E88/1000*N2O_GWP)+(D91/1000*CH4_GWP)+(E91/1000*N2O_GWP))/1000","v":0}]
[]
["Total Biomass CO2 Equivalent Emissions  (metric tons)  - Stationary Combustion",null,null,null,{"$f":"(C91/1000)","v":0}]

{"sheet":"Mobile Sources","index":4,"n_rows":182,"n_cols":7,"rows_kept":182,"cut":false,"hidden":false,"merged":[[161,0,161,2],[162,0,162,2],[163,0,163,2],[67,3,68,3],[67,4,68,4],[56,3,56,4],[81,0,81,1],[67,0,68,2],[7,0,7,8],[13,0,13,6],[9,0,9,6],[5,0,5,6],[172,0,172,2],[173,0,173,2],[166,0,166,2],[167,0,167,2],[168,0,168,2],[169,0,169,2],[170,0,170,2],[171,0,171,2],[160,0,160,2],[164,0,164,2],[165,0,165,2],[6,0,6,8],[138,0,138,1],[159,0,159,2],[56,0,56,2]]}
[]
[]
["Scope 1 Emissions from Mobile Sources"]
[]
["Guidance"]
["(A) Enter annual data for each vehicle or group of vehicles (grouped by vehicle type, vehicle year, and fuel type) in ORANGE cells in \n     Table 1.  Example entry is shown in first row (GREEN Italics).  Only enter vehicles owned or leased by your organization on \n     this sheet.  All other vehicle use such as employee commuting or business travel is considered a scope 3 emissions source \n     and should be reported in the corresponding sheets. "]
["                  - Select \"Vehicle Type\" from drop down box (closest type available).  "]
["                  - Enter \"Fuel Usage\" in appropriate units (units appear when vehicle type is selected)."]
["                     "," - If mileage or fuel usage is unknown, estimate using approximate fuel economy values (see Reference Table below)."]
["(B) When using biofuels, typically the biofuel (biodiesel or ethanol) is mixed with a petroleum fuel (diesel or gasoline) for use in \n      vehicles.   Enter the biodiesel and ethanol percentages of the fuel if known, or leave default values."]
[]
[null,null,"Biodiesel Percent:",20,"%"]
[null,null,"Ethanol Percent:",85,"%"]
["(C) Biomass CO2 emissions from biodiesel and ethanol are not reported in the total emissions, but are reported \n      separately at the bottom of the sheet."]
[]
["Table 1.  Mobile Source Fuel Combustion and Miles Traveled"]
["Source","Source","Vehicle","Vehicle","Fuel","Units","Miles"]
["ID","Description","Type","Year","Usage",null,"Traveled"]
["Fleet-012","HQ Fleet","Diesel Heavy-Duty Vehicles",1990,500,{"$f":"IF($C19=\"\",\"\",IF($C19=\"CNG Buses\", \"scf\", IF($C19=\"CNG Heavy-Duty Vehicles\", \"scf\", IF($C19=\"CNG Light-Duty Vehicles\",\"scf\",\"gal\"))))","v":"gal"},{"$f":"E19*E60","v":3600}]
[null,null,null,null,null,{"$f":"IF($C20=\"\",\"\",IF($C20=\"CNG Buses\", \"scf\", IF($C20=\"CNG Heavy-Duty Vehicles\", \"scf\", IF($C20=\"CNG Light-Duty Vehicles\",\"scf\",\"gal\"))))","v":""}]
[null,null,null,null,null,{"$f":"IF($C21=\"\",\"\",IF($C21=\"CNG Buses\", \"scf\", IF($C21=\"CNG Heavy-Duty Vehicles\", \"scf\", IF($C21=\"CNG Light-Duty Vehicles\",\"scf\",\"gal\"))))","v":""}]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IF($C42=\"\",\"\",IF($C42=\"CNG Buses\", \"scf\", IF($C42=\"CNG Heavy-Duty Vehicles\", \"scf\", IF($C42=\"CNG Light-Duty Vehicles\",\"scf\",\"gal\"))))","v":""}]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[]
["Reference Table: Average Fuel Economy by Vehicle Type"]
["Vehicle Type",null,null,"Average Fuel Economy (mpg)"]
["Passenger Cars",null,null,null,23.3]
["Motorcycles",null,null,null,43.5]
["Diesel Buses (Diesel Heavy-Duty Vehicles)",null,null,null,7.2]
["Other 2-axle, 4-Tire Vehicles",null,null,null,17.100000000000001]
["Single unit 2-Axle 6-Tire or More Trucks",null,null,null,7.3]
["Combination Trucks",null,null,null,5.8]
[]
["GHG Emissions"]
[]
["Total Organization-Wide Mobile Source Fuel Usage and CO2 Emissions (Highway and Non-Highway Vehicles)"]
["Fuel Type",null,null,"Fuel Usage","Units","CO2"]
[null,null,null,null,null,"(kg)"]
["Motor Gasoline",null,null,{"$f":"SUMIF($C$20:$C$54,\"Gasoline*\",$E$20:$E$54)+SUMIF($C$20:$C$54,\"Other Gasoline*\",$E$20:$E$54)","v":0},"gallons",{"$f":"IF($D70=\"\",\"\",Mobile_gas_CO2fctr*$D70)","v":0}]
["Diesel Fuel",null,null,{"$f":"SUMIF($C$20:$C$54,\"Diesel*\",$E$20:$E$54)+SUMIF($C$20:$C$54,\"Other Diesel*\",$E$20:$E$54)","v":0},"gallons",{"$f":"IF($D71=\"\",\"\",Mobile_diesel_CO2fctr*$D71)","v":0}]
["Residual Fuel Oil",null,null,{"$f":"SUMIF($C$20:$C$54,\"*Residual*\",$E$20:$E$54)","v":0},"gallons",{"$f":"IF($D72=\"\",\"\",Mobile_FuelOil_CO2fctr*$D72)","v":0}]
["Aviation Gasoline ",null,null,{"$f":"SUMIF($C$20:$C$54,\"Aviation Gasoline*\",$E$20:$E$54)","v":0},"gallons",{"$f":"IF($D73=\"\",\"\",Mobile_Avgas_CO2fctr*$D73)","v":0}]
["Kerosene-Type Jet Fuel",null,null,{"$f":"SUMIF($C$20:$C$54,\"*Jet*\",$E$20:$E$54)","v":0},"gallons",{"$f":"IF($D74=\"\",\"\",Mobile_Jet_Fuel_CO2fctr*$D74)","v":0}]
["Liquefied Petroleum Gas (LPG)",null,null,{"$f":"SUMIF($C$20:$C$54,\"*LPG*\",$E$20:$E$54)","v":0},"gallons",{"$f":"IF($D75=\"\",\"\",Mobile_LPG_CO2fctr*$D75)","v":0}]
["Ethanol (100%)",null,null,{"$f":"SUMIF($C$20:$C$54,\"*Ethanol*\",$E$20:$E$54)","v":0},"gallons",{"$f":"IF(D76=\"\",\"\",Mobile_gas_CO2fctr*(100-$D$13)/100*$D76)","v":0}]
["Biodiesel (100%)",null,null,{"$f":"SUMIF($C$20:$C$54,\"Biodiesel*\",$E$20:$E$54)","v":0},"gallons",{"$f":"IF(D77=\"\",\"\",Mobile_diesel_CO2fctr*(100-$D$12)/100*$D77)","v":0}]
["Liquefied Natural Gas (LNG)",null,null,{"$f":"SUMIF($C$20:$C$54,\"*LNG*\",$E$20:$E$54)","v":0},"gallons",{"$f":"IF($D78=\"\",\"\",Mobile_LNG_CO2fctr*$D78)","v":0}]
["Compressed Natural Gas (CNG)",null,null,{"$f":"SUMIF($C$20:$C$54,\"*CNG*\",$E$20:$E$54)","v":0},"scf",{"$f":"IF($D79=\"\",\"\",Mobile_CNG_CO2fctr*$D79)","v":0}]
[]
["Total Organization-Wide Highway Gasoline Mobile Source Mileage and CH4/N2O Emissions"]
["Vehicle Type",null,"Vehicle Year","Mileage (miles)","CH4 (g)","N2O (g)"]
["Gasoline Passenger Cars",null,"1984-1993",{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$83),--($D$20:$D$54<=1993),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP(C83,Gas_Pass_Car_CH4_N2O, 2,FALSE)*D83","v":0},{"$f":"VLOOKUP(C83,Gas_Pass_Car_CH4_N2O, 3,FALSE)*D83","v":0}]
[null,null,1994,{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$83),--($D$20:$D$54=$C84),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP(C84,Gas_Pass_Car_CH4_N2O, 2,FALSE)*D84","v":0},0]
[null,null,1995,0,0,0]
[null,null,1996,0,0,0]
[null,null,1997,0,0,0]
[null,null,1998,0,0,0]
[null,null,1999,0,0,0]
[null,null,2000,0,0,0]
[null,null,2001,0,0,0]
[null,null,2002,0,0,0]
[null,null,2003,0,0,0]
[null,null,2004,0,0,0]
[null,null,2005,0,{"$f":"VLOOKUP(C95,Gas_Pass_Car_CH4_N2O, 2,FALSE)*D95","v":0},{"$f":"VLOOKUP(C95,Gas_Pass_Car_CH4_N2O, 3,FALSE)*D95","v":0}]
[null,null,2006,0,{"$f":"VLOOKUP(C96,Gas_Pass_Car_CH4_N2O, 2,FALSE)*D96","v":0},{"$f":"VLOOKUP(C96,Gas_Pass_Car_CH4_N2O, 3,FALSE)*D96","v":0}]
[null,null,2007,0,{"$f":"VLOOKUP(C97,Gas_Pass_Car_CH4_N2O, 2,FALSE)*D97","v":0},{"$f":"VLOOKUP(C97,Gas_Pass_Car_CH4_N2O, 3,FALSE)*D97","v":0}]
[null,null,2008,0,{"$f":"VLOOKUP(C98,Gas_Pass_Car_CH4_N2O, 2,FALSE)*D98","v":0},{"$f":"VLOOKUP(C98,Gas_Pass_Car_CH4_N2O, 3,FALSE)*D98","v":0}]
[null,null,"2009-present",{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$83),--($D$20:$D$54>=2009),--($G$20:$G$54))+SUMPRODUCT(--($C$20:$C$54=$A$83),--($D$20:$D$54=\"\"),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP(C99,Gas_Pass_Car_CH4_N2O, 2,FALSE)*D99","v":0},0]
["Gasoline Light-Duty Trucks",null,"1987-1993",{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$100),--($D$20:$D$54<=1993),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP(C100,Gas_Lt_Duty_Trucks_CH4_N2O, 2,FALSE)*D100","v":0},{"$f":"VLOOKUP(C100,Gas_Lt_Duty_Trucks_CH4_N2O, 3,FALSE)*D100","v":0}]
["(Vans, Pickup Trucks, SUVs)",null,1994,{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$100),--($D$20:$D$54=$C101),--($G$20:$G$54))","v":0},0,0]
[null,null,1995,0,0,0]
[null,null,1996,0,0,0]
[null,null,1997,0,0,0]
[null,null,1998,0,0,0]
[null,null,1999,0,0,0]
[null,null,2000,0,0,0]
[null,null,2001,0,0,0]
[null,null,2002,0,0,0]
[null,null,2003,0,0,0]
[null,null,2004,{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$100),--($D$20:$D$54=$C111),--($G$20:$G$54))","v":0},0,0]
[null,null,2005,{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$100),--($D$20:$D$54=$C112),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP(C112,Gas_Lt_Duty_Trucks_CH4_N2O, 2,FALSE)*D112","v":0},{"$f":"VLOOKUP(C112,Gas_Lt_Duty_Trucks_CH4_N2O, 3,FALSE)*D112","v":0}]
[null,null,2006,{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$100),--($D$20:$D$54=$C113),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP(C113,Gas_Lt_Duty_Trucks_CH4_N2O, 2,FALSE)*D113","v":0},{"$f":"VLOOKUP(C113,Gas_Lt_Duty_Trucks_CH4_N2O, 3,FALSE)*D113","v":0}]
[null,null,2007,{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$100),--($D$20:$D$54=$C114),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP(C114,Gas_Lt_Duty_Trucks_CH4_N2O, 2,FALSE)*D114","v":0},{"$f":"VLOOKUP(C114,Gas_Lt_Duty_Trucks_CH4_N2O, 3,FALSE)*D114","v":0}]
[null,null,2008,{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$100),--($D$20:$D$54=$C115),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP(C115,Gas_Lt_Duty_Trucks_CH4_N2O, 2,FALSE)*D115","v":0},{"$f":"VLOOKUP(C115,Gas_Lt_Duty_Trucks_CH4_N2O, 3,FALSE)*D115","v":0}]
[null,null,"2009-present",{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$100),--($D$20:$D$54>=2009),--($G$20:$G$54))+SUMPRODUCT(--($C$20:$C$54=$A$100),--($D$20:$D$54=\"\"),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP(C116,Gas_Lt_Duty_Trucks_CH4_N2O, 2,FALSE)*D116","v":0},0]
["Gasoline Heavy-Duty Vehicles",null,"1985-1986",{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$117),--($D$20:$D$54<=1986),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP(C117,Gas_Heavy_Duty_CH4_N2O, 2,FALSE)*D117","v":0},{"$f":"VLOOKUP(C117,Gas_Heavy_Duty_CH4_N2O, 3,FALSE)*D117","v":0}]
[null,null,1987,{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$117),--($D$20:$D$54=$C118),--($G$20:$G$54))","v":0},0,0]
[null,null,"1988-1989",{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$117),--($D$20:$D$54>=1988),--($D$20:$D$54<=1989),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP(C119,Gas_Heavy_Duty_CH4_N2O, 2,FALSE)*D119","v":0},0]
[null,null,"1990-1995",{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$117),--($D$20:$D$54>=1990),--($D$20:$D$54<=1995),--($G$20:$G$54))","v":0},0,0]
[null,null,1996,0,0,0]
[null,null,1997,0,0,0]
[null,null,1998,0,0,0]
[null,null,1999,0,0,0]
[null,null,2000,0,0,0]
[null,null,2001,0,0,0]
[null,null,2002,0,0,0]
[null,null,2003,0,0,0]
[null,null,2004,0,0,0]
[null,null,2005,0,{"$f":"VLOOKUP(C130,Gas_Heavy_Duty_CH4_N2O, 2,FALSE)*D130","v":0},{"$f":"VLOOKUP(C130,Gas_Heavy_Duty_CH4_N2O, 3,FALSE)*D130","v":0}]
[null,null,2006,0,{"$f":"VLOOKUP(C131,Gas_Heavy_Duty_CH4_N2O, 2,FALSE)*D131","v":0},{"$f":"VLOOKUP(C131,Gas_Heavy_Duty_CH4_N2O, 3,FALSE)*D131","v":0}]
[null,null,2007,0,{"$f":"VLOOKUP(C132,Gas_Heavy_Duty_CH4_N2O, 2,FALSE)*D132","v":0},{"$f":"VLOOKUP(C132,Gas_Heavy_Duty_CH4_N2O, 3,FALSE)*D132","v":0}]
[null,null,2008,0,{"$f":"VLOOKUP(C133,Gas_Heavy_Duty_CH4_N2O, 2,FALSE)*D133","v":0},{"$f":"VLOOKUP(C133,Gas_Heavy_Duty_CH4_N2O, 3,FALSE)*D133","v":0}]
[null,null,"2009-present",{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$117),--($D$20:$D$54>=2009),--($G$20:$G$54))+SUMPRODUCT(--($C$20:$C$54=$A$117),--($D$20:$D$54=\"\"),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP(C134,Gas_Heavy_Duty_CH4_N2O, 2,FALSE)*D134","v":0},{"$f":"VLOOKUP(C134,Gas_Heavy_Duty_CH4_N2O, 3,FALSE)*D134","v":0}]
["Gasoline Motorcycles",null,"1960-1995",{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$117),--($D$20:$D$54=$C135),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP(C135,Gas_Motorcycle_CH4_N2O, 2,FALSE)*D135","v":0},{"$f":"VLOOKUP(C135,Gas_Motorcycle_CH4_N2O, 3,FALSE)*D135","v":0}]
[null,null,"1996-present",{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$117),--($D$20:$D$54>=2009),--($G$20:$G$54))+SUMPRODUCT(--($C$20:$C$54=$A$117),--($D$20:$D$54=\"\"),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP(C136,Gas_Motorcycle_CH4_N2O, 2,FALSE)*D136","v":0},{"$f":"VLOOKUP(C136,Gas_Motorcycle_CH4_N2O, 3,FALSE)*D136","v":0}]
[]
["Total Organization-Wide Highway Non-Gasoline Mobile Source Mileage and CH4/N2O Emissions"]
["Vehicle Type",null,"Vehicle Year","Mileage (miles)","CH4 (g)","N2O (g)"]
["Diesel Passenger Cars",null,"1960-1982",{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$140),--($D$20:$D$54<=1982),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP($C140,Diesel_pass_CH4_N2O, 2,FALSE)*$D140","v":0},{"$f":"VLOOKUP($C140,Diesel_pass_CH4_N2O, 3,FALSE)*$D140","v":0}]
[null,null,"1983-present",{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$140),--($D$20:$D$54>=1983),--($G$20:$G$54))+SUMPRODUCT(--($C$20:$C$54=$A$140),--($D$20:$D$54=\"\"),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP($C141,Diesel_pass_CH4_N2O, 2,FALSE)*$D141","v":0},{"$f":"VLOOKUP($C141,Diesel_pass_CH4_N2O, 3,FALSE)*$D141","v":0}]
["Diesel Light-Duty Trucks",null,"1960-1982",{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$142),--($D$20:$D$54<=1982),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP($C142,Diesel_Lt_Trucks_CH4_N2O, 2,FALSE)*$D142","v":0},{"$f":"VLOOKUP($C142,Diesel_Lt_Trucks_CH4_N2O, 3,FALSE)*$D142","v":0}]
[null,null,"1983-1995",{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$142),--($D$20:$D$54>=1983),--($D$20:$D$54<=1995),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP($C143,Diesel_Lt_Trucks_CH4_N2O, 2,FALSE)*$D143","v":0},{"$f":"VLOOKUP($C143,Diesel_Lt_Trucks_CH4_N2O, 3,FALSE)*$D143","v":0}]
[null,null,"1996-present",{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$142),--($D$20:$D$54>=1996),--($G$20:$G$54))+SUMPRODUCT(--($C$20:$C$54=$A$142),--($D$20:$D$54=\"\"),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP($C144,Diesel_Lt_Trucks_CH4_N2O, 2,FALSE)*$D144","v":0},{"$f":"VLOOKUP($C144,Diesel_Lt_Trucks_CH4_N2O, 3,FALSE)*$D144","v":0}]
["Diesel Medium- and Heavy-Duty Vehicles",null,"1960-present",{"$f":"SUMPRODUCT(--($C$20:$C$54=$A$145),--($D$20:$D$54>=1960),--($G$20:$G$54))+SUMPRODUCT(--($C$20:$C$54=$A$145),--($D$20:$D$54=\"\"),--($G$20:$G$54))","v":0},{"$f":"VLOOKUP($C145,Diesel_Heavy_Trucks_CH4_N2O, 2,FALSE)*$D145","v":0},{"$f":"VLOOKUP($C145,Diesel_Heavy_Trucks_CH4_N2O, 3,FALSE)*$D145","v":0}]
["CNG Light-Duty Vehicles",null,null,{"$f":"SUMIF($C$20:$C$54,A146,$G$20:$G$54)","v":0},{"$f":"CNG_Lt_Duty_CH4*$D146","v":0},{"$f":"CNG_Lt_Duty_N2O*$D146","v":0}]
["CNG Heavy-Duty Vehicles",null,null,{"$f":"SUMIF($C$20:$C$54,A147,$G$20:$G$54)","v":0},{"$f":"CNG_Heavy_Duty_CH4*D147","v":0},{"$f":"CNG_Heavy_Duty_N2O*D147","v":0}]
["CNG Buses",null,null,{"$f":"SUMIF($C$20:$C$54,A148,$G$20:$G$54)","v":0},{"$f":"CNG_Buses_CH4*D148","v":0},{"$f":"CNG_Buses_N2O*D148","v":0}]
["LPG Light-Duty Vehicles",null,null,{"$f":"SUMIF($C$20:$C$54,\"LPG Light-Duty*\",$G$20:$G$54)","v":0},{"$f":"LPG_Lt_Duty_CH4*D149","v":0},{"$f":"LPG_Lt_Duty_N2O*D149","v":0}]
["LPG Medium- and Heavy-Duty Vehicles",null,null,0,{"$f":"LPG_Heavy_Duty_CH4*D150","v":0},{"$f":"LPG_Heavy_Duty_N2O*D150","v":0}]
["LNG Medium- and Heavy-Duty Vehicles",null,null,0,{"$f":"LNG_Heavy_Duty_CH4*D151","v":0},{"$f":"LNG_Heavy_Duty_N2O*D151","v":0}]
["Ethanol Light-Duty Vehicles",null,null,{"$f":"SUMIF($C$20:$C$54,A152,$G$20:$G$54)","v":0},{"$f":"Ethanol_Lt_Duty_CH4*D152*(($D$13/100))+(1-($D$13/100))*D152*Gas_Present_Lt_Duty_CH4","v":0},{"$f":"Ethanol_Lt_Duty_N2O*D152*(($D$13/100))+(1-($D$13/100))*D152*Gas_Present_Lt_Duty_N2O","v":0}]
["Ethanol Medium- and Heavy-Duty Vehicles",null,null,0,{"$f":"Ethanol_Heavy_Duty_CH4*D153*(($D$13/100))+(1-($D$13/100))*D153*Gas_Present_Heavy_Duty_CH4","v":0},{"$f":"Ethanol_Heavy_Duty_N2O*D153*(($D$13/100))+(1-($D$13/100))*D153*Gas_Present_Heavy_Duty_N2O","v":0}]
["Ethanol Buses",null,null,0,{"$f":"Ethanol_Buses_CH4*D154*(($D$13/100))+(1-($D$13/100))*D154*Gas_Present_Heavy_Duty_CH4","v":0},{"$f":"Ethanol_Buses_N2O*D154*(($D$13/100))+(1-($D$13/100))*D154*Gas_Present_Heavy_Duty_N2O","v":0}]
["Biodiesel Light-Duty Vehicles",null,null,{"$f":"SUMIF($C$20:$C$54,A155,$G$20:$G$54)","v":0},{"$f":"Biodiesel_Lt_Duty_CH4*D155*(($D$13/100))+(1-($D$13/100))*D155*Diesel_Present_Lt_Duty_CH4","v":0},{"$f":"Biodiesel_Lt_Duty_N2O*D155*(($D$13/100))+(1-($D$13/100))*D155*Diesel_Present_Lt_Duty_N2O","v":0}]
["Biodiesel Medium- and Heavy-Duty Vehicles",null,null,{"$f":"SUMIF($C$20:$C$54,A156,$G$20:$G$54)","v":0},{"$f":"Biodiesel_Heavy_Duty_CH4*D156*(($D$13/100))+(1-($D$13/100))*D156*Diesel_Present_Heavy_Duty_CH4","v":0},{"$f":"Biodiesel_Heavy_Duty_N2O*D156*(($D$13/100))+(1-($D$13/100))*D156*Diesel_Present_Heavy_Duty_N2O","v":0}]
["Biodiesel Buses",null,null,{"$f":"SUMIF($C$20:$C$54,A157,$G$20:$G$54)","v":0},{"$f":"Biodiesel_Buses_CH4*D157*(($D$13/100))+(1-($D$13/100))*D157*Diesel_Present_Heavy_Duty_CH4","v":0},{"$f":"Biodiesel_Buses_N2O*D157*(($D$13/100))+(1-($D$13/100))*D157*Diesel_Present_Heavy_Duty_N2O","v":0}]
[]
["Total Organization-Wide Non-Highway Mobile Source Fuel Usage and CH4/N2O Emissions"]
["Vehicle Type",null,null,"Fuel Usage (gallons)","CH4 (g) ","N2O (g)"]
["LPG Non-Road Vehicles",null,null,{"$f":"SUMIF($C$20:$C$54,A161,$E$20:$E$54)","v":0},{"$f":"VLOOKUP(A161,Non_Highway_Vehicles_Ch4_N2O,2,FALSE)*D161","v":0},{"$f":"VLOOKUP(A161,Non_Highway_Vehicles_Ch4_N2O,3,FALSE)*D161","v":0}]
["Residual Oil Ships and Boats",null,null,{"$f":"SUMIF($C$20:$C$54,A162,$E$20:$E$54)","v":0},0,0]
["Diesel Ships and Boats",null,null,{"$f":"SUMIF($C$20:$C$54,A163,$E$20:$E$54)","v":0},0,0]
["Gasoline Ships and Boats",null,null,{"$f":"SUMIF($C$20:$C$54,A164,$E$20:$E$54)","v":0},0,0]
["Diesel Locomotives",null,null,0,0,0]
["Gasoline Agricultural Equip.",null,null,0,0,0]
["Diesel Agricultural Equip.",null,null,0,0,0]
["Gasoline Construction Equip.",null,null,0,0,0]
["Diesel Construction Equip.",null,null,0,0,0]
["Jet Fuel Aircraft",null,null,{"$f":"SUMIF($C$20:$C$54,A170,$E$20:$E$54)","v":0},0,0]
["Aviation Gasoline Aircraft",null,null,0,0,0]
["Biodiesel Non-Road Vehicles",null,null,{"$f":"SUMIF($C$20:$C$54,A172,$E$20:$E$54)","v":0},{"$f":"VLOOKUP(A172,Non_Highway_Vehicles_Ch4_N2O,2,FALSE)*D172","v":0},{"$f":"VLOOKUP(A172,Non_Highway_Vehicles_Ch4_N2O,3,FALSE)*D172","v":0}]
["Other Diesel Non-Road Vehicles",null,null,{"$f":"SUMIF($C$20:$C$54,A173,$E$20:$E$54)","v":0},{"$f":"VLOOKUP(A173,Non_Highway_Vehicles_Ch4_N2O,2,FALSE)*D173","v":0},{"$f":"VLOOKUP(A173,Non_Highway_Vehicles_Ch4_N2O,3,FALSE)*D173","v":0}]
["Other Gasoline Non-Road Vehicles",null,null,{"$f":"SUMIF($C$20:$C$54,A174,$E$20:$E$54)","v":0},{"$f":"VLOOKUP(A174,Non_Highway_Vehicles_Ch4_N2O,2,FALSE)*D174","v":0},{"$f":"VLOOKUP(A174,Non_Highway_Vehicles_Ch4_N2O,3,FALSE)*D174","v":0}]
[]
[]
["Total CO2 Equivalent Emissions  (metric tons)  - Mobile Sources",null,null,null,{"$f":"((SUM($F$70:$F$79))+(SUM($E$83:$E$136)+SUM($E$140:$E$157)+SUM($E$161:$E$174))*CH4_GWP/1000+(SUM($F$83:$F$136)+SUM($F$140:$F$157)+SUM($F$161:$F$174))*N2O_GWP/1000)/1000","v":0}]
[]
["Total Biomass CO2 Equivalent Emissions  (metric tons) - Mobile Sources",null,null,null,{"$f":"((Mobile_Ethanol_CO2fctr*$D$13/100*$D$76)+(Mobile_Biodiesel_CO2fctr*$D$12/100*$D$77))/1000","v":0}]
[]
["Notes:"]
["1.  Average mpg values from the U.S. Department of Transportation, Federal Highway Administration, Highway Statistics 2012 (Jan 2014), Table VM-1."]

{"sheet":"Refrigeration and AC","index":5,"n_rows":135,"n_cols":25,"rows_kept":135,"cut":false,"hidden":false,"merged":[[5,0,5,7],[6,0,6,7],[128,0,129,4],[46,2,46,3],[46,5,46,6],[71,5,71,6],[65,0,65,7],[67,0,67,7],[71,0,74,0],[71,1,74,1],[71,2,74,2],[71,3,74,3]]}
[]
[]
["Scope 1 Emissions from Refrigeration and Air Conditioning Equipment"]
[]
["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) Select ONE of the three options with which to estimate emissions.  Options range from most preferred method \n         (Option 1) to least preferred method (Option 3).  If option 3, screening method, is used and emissions are determined to be \n         significant when compared to other emission sources, then one of the other methods should be applied to calculate emissions more \n         accurately."]
["  (C)  Enter annual data in ORANGE cells as appropriate for the selected option."]
[]
["Option 1.    Material Balance Method:  Enter organization-wide total gases stored and transferred (by gas) in Table 1."]
["                  - Choose the appropriate gas from the drop down menu."]
["                  - 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 new units minus capacity of retired units)."]
[]
["Table 1.  Organization-Wide Refrigeration Gas CO2 Equivalent Emissions - Material Balance"]
["Gas","Gas","Inventory","Transferred","Capacity","CO2 Equivalent"]
[null,"GWP","Change","Amount","Change","Emissions"]
[null,null,"(lb)","(lb)","(lb)","(lb)"]
[null,{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,GWP,2,FALSE))","v":""},null,null,null,{"$f":"IF(B26=\"\", \"\",IF(($C26+$D26+$E26)*$B26<0,0,($C26+$D26+$E26)*$B26))","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,""]
[]
["Option 2.     Material Balance Method (Simplified):  Enter organization-wide total gases in units (by gas) in Table 2."]
["                  - Choose the appropriate gas from the drop down menu."]
["                  - New units are those installed during reporting period (do not include any data for new units pre-charged by"]
["                    supplier), disposed units were disposed of during the reporting period, and existing units are all others."]
["                  - Charge/Recharge = gas added to units by organization or a contractor (do not include pre-charge by manufacturer)."]
["                  - Capacity = sum of the full capacity for all units (do not include new units pre-charged by manufacturer). "]
["                  - Amount recovered = total gas recovered from all retired units."]
[]
["Table 2.  Organization-Wide Refrigeration Gas CO2 Equivalent Emissions - Simplified Material Balance"]
["Gas","Gas","New Units",null,"Existing Units","Disposed Units",null,"CO2 Equivalent"]
[null,"GWP","Charge","Capacity","Recharge","Capacity","Recovered","Emissions"]
[null,null,"(lb)","(lb)","(lb)","(lb)","(lb)","(lb)"]
[null,{"$f":"IF(A50=\"\",\"\",VLOOKUP(A50,GWP,2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(B50=\"\",\"\",IF(($C50-$D50+$E50+$F50-$G50)*$B50<0,0,($C50-$D50+$E50+$F50-$G50)*$B50))","v":""}]
[null,{"$f":"IF(A51=\"\",\"\",VLOOKUP(A51,GWP,2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(B51=\"\",\"\",IF(($C51-$D51+$E51+$F51-$G51)*$B51<0,0,($C51-$D51+$E51+$F51-$G51)*$B51))","v":""}]
[null,"",null,null,null,null,null,""]
[null,"",null,null,null,null,null,""]
[null,"",null,null,null,null,null,""]
[null,"",null,null,null,null,null,""]
[null,"",null,null,null,null,null,""]
[null,"",null,null,null,null,null,""]
[null,"",null,null,null,null,null,""]
[null,"",null,null,null,null,null,""]
[null,"",null,null,null,null,null,""]
[]
["Option 3.     Screening Method:  Enter refrigerant information for each unit or group of units (by refrigerant) in Table 3."]
["                  - Select the \"Type of Equipment\" (closest available) and \"Gas\" from the drop down box."]
["                  - Enter amount of refrigerant added to new units by the organization (not pre-charged amount from manufacturer)."]
["                  - Enter refrigerant capacity (by equipment type and refrigerant) for all units operating and disposed during reporting period."]
["                      -- For each unit added or removed during reporting period, multiply its capacity by a usage factor (0.0 to 1.0). \n                         For example, if the equipment was installed in June, multiply by 0.5 or (6/12), if it was installed in  \n                         September you would multiply by 0.33 (4/12)."]
["                      -- If data entered for multiple units, sum the capacities or charge quantity for all like units."]
["                      -- If capacity of unit(s) is not known, use upper value of default capacity provided in the Reference Table below."]
["                  - See example entry in first row (GREEN Italics)."]
[]
["Table 3.  Source Level Refrigeration Gas CO2 Equivalent Emissions - Screening Method"]
["Source ID","Type of Equipment","Gas","Gas\nGWP","New Units","Capacity",null,"CO2"]
[null,null,null,null,"Charge","Operating","Disposed","Equivalent"]
[null,null,null,null,"(kg)","Units","Units","Emissions"]
[null,null,null,null,null,"(kg)","(kg)","(kg)",null,null,null,null,null,null,null,null,"Formula Selection for Type of Equipment"]
["Bldg-012","Domestic Refrigeration","CF4 ",{"$f":"IF(ISNA(VLOOKUP($C76,$A$50:$B$60,2,FALSE)),\"\", VLOOKUP($C76,$A$50:$B$60,2,FALSE))","v":""},0,{"$f":"0.5","v":0.5},0.25,213.85,null,null,null,null,null,null,null,null,"Domestic Refrigeration","Stand-Alone Commercial","Medium/Large Commercial","Transport Refrigeration","Industrial Refrigeration","Chillers","Residential/Commercial A/C","Car A/C Units","Light-Duty Truck A/C Units"]
[null,null,null,{"$f":"IF(ISNA(VLOOKUP($C77,GWP,2,FALSE)),\"\", VLOOKUP($C77,GWP,2,FALSE))","v":""},null,null,null,{"$f":"IF($D77=\"\",\"\",SUM($Q77:$Y77))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF($B77=Q76,(($E77*(1/100)+$F77*(0.5/100)+$G77*(80/100)*(1-70/100))*$D77),0)","v":0},{"$f":"IF($B77=\"Stand-Alone Commercial\",(($E77*(3/100)+$F77*(15/100)+$G77*(80/100)*(1-70/100))*$D77),0)","v":0},{"$f":"IF($B77=\"Medium/Large Commercial\",(($E77*(3/100)+$F77*(35/100)+$G77*(100/100)*(1-70/100))*$D77),0)","v":0},{"$f":"IF($B77=\"Transport Refrigeration\",(($E77*(1/100)+$F77*(50/100)+$G77*(50/100)*(1-70/100))*$D77),0)","v":0},{"$f":"IF($B77=\"Industrial Refrigeration\",(($E77*(3/100)+$F77*(25/100)+$G77*(100/100)*(1-90/100))*$D77),0)","v":0},{"$f":"IF($B77=\"Chillers\",(($E77*(1/100)+$F77*(15/100)+$G77*(100/100)*(1-95/100))*$D77),0)","v":0},{"$f":"IF($B77=\"Residential/Commercial A/C\",(($E77*(1/100)+$F77*(10/100)+$G77*(80/100)*(1-80/100))*$D77),0)","v":0},{"$f":"IF($B77=\"Car A/C Units\",(($E77*(0.5/100)+$F77*(20/100)+$G77*(50/100)*(1-50/100))*$D77),0)","v":0},{"$f":"IF($B77=\"Light-Duty Truck A/C Units\",(($E77*(0.5/100)+$F77*(20/100)+$G77*(50/100)*(1-50/100))*$D77),0)","v":0}]
[null,null,null,"",null,null,null,{"$f":"IF($D78=\"\",\"\",SUM($Q78:$Y78))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF($B78=\"Domestic Refrigeration\",(($E78*(1/100)+$F78*(0.5/100)+$G78*(80/100)*(1-70/100))*$D78),0)","v":0},{"$f":"IF($B78=\"Stand-Alone Commercial\",(($E78*(3/100)+$F78*(15/100)+$G78*(80/100)*(1-70/100))*$D78),0)","v":0},{"$f":"IF($B78=\"Medium/Large Commercial\",(($E78*(3/100)+$F78*(35/100)+$G78*(100/100)*(1-70/100))*$D78),0)","v":0},{"$f":"IF($B78=\"Transport Refrigeration\",(($E78*(1/100)+$F78*(50/100)+$G78*(50/100)*(1-70/100))*$D78),0)","v":0},{"$f":"IF($B78=\"Industrial Refrigeration\",(($E78*(3/100)+$F78*(25/100)+$G78*(100/100)*(1-90/100))*$D78),0)","v":0},{"$f":"IF($B78=\"Chillers\",(($E78*(1/100)+$F78*(15/100)+$G78*(100/100)*(1-95/100))*$D78),0)","v":0},{"$f":"IF($B78=\"Residential/Commercial A/C\",(($E78*(1/100)+$F78*(10/100)+$G78*(80/100)*(1-80/100))*$D78),0)","v":0},{"$f":"IF($B78=\"Car A/C Units\",(($E78*(0.5/100)+$F78*(20/100)+$G78*(50/100)*(1-50/100))*$D78),0)","v":0},{"$f":"IF($B78=\"Light-Duty Truck A/C Units\",(($E78*(0.5/100)+$F78*(20/100)+$G78*(50/100)*(1-50/100))*$D78),0)","v":0}]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF($B90=\"Domestic Refrigeration\",(($E90*(1/100)+$F90*(0.5/100)+$G90*(80/100)*(1-70/100))*$D90),0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"",null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[]
["Reference Table: Type of Equipment and Default Capacity Ranges (Lower to Upper Range) for Table 3"]
["Domestic Refrigeration",null,"Domestic refrigeration units (capacity 0.05 to 0.5 kg)"]
["Stand-Alone Commercial",null,"Stand alone commercial applications (capacity 0.2 to 6 kg)"]
["Medium/Large Commercial",null,"Medium and large commercial refrigeration units (capacity 50 to 2,000 kg)"]
["Transport Refrigeration",null,"Transportation refrigeration units (capacity 3 to 8 kg)"]
["Industrial Refrigeration",null,"Industrial, food processing and cold storage units (capacity 10 to 10,000 kg)"]
["Chillers",null,"Commercial chillers (default capacity 10 to 2,000 kg)"]
["Residential/Commercial A/C",null,"Residential and commercial units, including heat pumps (capacity 0.5 to 100 kg)"]
["Car A/C Units",null,"Passenger car A/C units (capacity 0.5 kg)"]
["Light-Duty Truck A/C Units",null,"Light-duty truck A/C units (capacity 1.5 kg)"]
[]
["GHG Emissions"]
[]
["Total CO2 Equivalent Emissions  (metric tons) - Refrigeration and AC Equipment"]
[null,null,null,null,null,{"$f":"(((SUM($F$26:$F$36)+SUM($H$50:$H$60))*kg_per_lb) +SUM($H$77:$H$114))/1000","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. (Nov 2014)."]
["2.  GWPs are from Intergovernmental Panel on Climate Change (IPCC) Fourth Assessment Report (2007).  "]

{"sheet":"Fire Suppression","index":6,"n_rows":115,"n_cols":8,"rows_kept":115,"cut":false,"hidden":false,"merged":[[44,2,44,3],[44,5,44,6],[5,0,5,7]]}
[]
[]
["Scope 1 Emissions from Fire Suppression Equipment"]
[]
["Guidance"]
["  (A)  HFC, PFC, and CO2 fire suppressants are required to be included in the GHG inventory.  Other fire suppressants such as \n         Halon compounds, HCFCs, aqueous solutions, or inert gases are typically excluded from a GHG inventory. "]
["  (B)  Select ONE of the three options from which to estimate emissions.  Options range from most preferred method"]
["         (Option 1) to least preferred method (Option 3).  If option 3, screening method, is used and emissions are determined"]
["         to be significant when compared to other emission sources, then one of the other methods should be applied to calculate"]
["         emissions more accurately."]
["  (C)  Enter annual data in ORANGE cells as appropriate for the selected option."]
[]
["Option 1.    Material Balance Method:  Enter organization-wide fire suppression gases stored and transferred (by gas) in Table 1."]
["                  - 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 new units minus capacity of retired units)."]
[]
["Table 1.  Organization-Wide Fire Suppression Gas CO2 Equivalent Emissions - Material Balance"]
["Gas","Gas","Inventory","Transferred","Capacity","CO2 Equivalent"]
[null,"GWP","Change","Amount","Change","Emissions"]
[null,null,"(lb)","(lb)","(lb)","(lb)"]
["CO2 ",{"$f":"VLOOKUP(A28,GWP,2,FALSE)","v":1},null,null,null,{"$f":"IF(($C28+$D28+$E28)*$B28=0,\"\",($C28+$D28+$E28)*$B28)","v":""}]
["HFC-23",14800,null,null,null,{"$f":"IF(($C29+$D29+$E29)*$B29=0,\"\",($C29+$D29+$E29)*$B29)","v":""}]
["HFC-125",3500,null,null,null,""]
["HFC-134a",1430,null,null,null,""]
["HFC-227ea",3220,null,null,null,""]
["HFC-236fa",9810,null,null,null,""]
["CF4",7390,null,null,null,""]
["C4F10",8860,null,null,null,""]
[]
["Option 2.     Material Balance Method (Simplified):  Enter organization-wide fire suppression gas in units (by gas) in Table 2."]
["                  - New units are those installed during reporting period (do not include any data for new units pre-charged by"]
["                    supplier), disposed units were disposed of during the reporting period, and existing units are all others."]
["                  - Charge/Recharge = gas added to units by organization or a contractor (do not include pre-charge by manufacturer)."]
["                  - Capacity = sum of the full capacity for all units (do not include new units pre-charged by manufacturer). "]
["                  - Amount recovered = total gas recovered from all retired units."]
[]
["Table 2.  Organization-Wide Fire Suppression Gas CO2 Equivalent Emissions - Simplified Material Balance"]
[null,null,"New Units",null,"Existing Units","Disposed Units",null,"CO2 Equivalent"]
["Gas","Gas","Charge","Capacity","Recharge","Capacity","Recovered","Emissions"]
[null,"GWP","(lb)","(lb)","(lb)","(lb)","(lb)","(lb)"]
["CO2 ",{"$f":"VLOOKUP(A48,GWP,2,FALSE)","v":1},null,null,null,null,null,{"$f":"IF(($C48-$D48+$E48+$F48-$G48)*$B48=0,\"\",($C48-$D48+$E48+$F48-$G48)*$B48)","v":""}]
["HFC-23",14800,null,null,null,null,null,{"$f":"IF(($C49-$D49+$E49+$F49-$G49)*$B49=0,\"\",($C49-$D49+$E49+$F49-$G49)*$B49)","v":""}]
["HFC-125",3500,null,null,null,null,null,""]
["HFC-134a",1430,null,null,null,null,null,""]
["HFC-227ea",3220,null,null,null,null,null,""]
["HFC-236fa",9810,null,null,null,null,null,""]
["CF4",7390,null,null,null,null,null,""]
["C4F10",8860,null,null,null,null,null,""]
[]
["Option 3.     Screening Method:  Enter fire suppression gas information for each unit or group of units (by gas) in Table 3."]
["                  - Enter \"Type of Equipment\" (Fixed or Portable) and select \"Gas Type\" from the drop down box."]
["                  - Enter capacity (by gas type) for all units that operated during reporting period."]
["                      -- For each unit added or removed during reporting period, multiply its capacity by a usage factor (0.0 to 1.0)."]
["                      -- If data entered for multiple units, sum the capacities for all units."]
["                  - See example entry in first row (Green Italics)."]
[]
["Table 3.  Source Level Fire Suppression Gas CO2 Equivalent Emissions - Screening Method"]
["Source","Type of ","Gas","Gas","Unit","CO2 Equivalent"]
["ID","Equipment","Type","GWP","Capacity","Emissions"]
[null,"(Fixed/Portable)",null,null,"(kg)","(kg)"]
["Bldg-012","Fixed","HFC-134a",{"$f":"IF($C68=\"\",\"\",VLOOKUP(C68,GWP,2,FALSE))","v":1430},1.3,{"$f":"IF($B68=\"Fixed\",$D68*Fixed_FireLeakRate*$E68,IF($B68=\"Portable\",$D68*Portable_FireLeakRate*$E68,\"\"))","v":65.065000000000012}]
[null,null,null,"",null,{"$f":"IF($B69=\"Fixed\",$D69*Fixed_FireLeakRate*$E69,IF($B69=\"Portable\",$D69*Portable_FireLeakRate*$E69,\"\"))","v":""}]
[null,null,null,"",null,{"$f":"IF($B70=\"Fixed\",$D70*0.015*$E70,IF($B70=\"Portable\",$D70*0.02*$E70,\"\"))","v":""}]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[null,null,null,"",null,""]
[]
["GHG Emissions"]
[]
[]
["Total CO2 Equivalent Emissions  (metric tons) - Fire Suppression Equipment",null,null,null,null,{"$f":"(((SUM($F$28:$F$35)+SUM($H$48:$H$55))*kg_per_lb)+SUM($F$69:$F$104))/1000","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. (Nov 2014)."]
["2..  Leak rates of fire extinguishers from Page A-248, US EPA - Inventory of U.S. Greenhouse Gas Emissions and Sinks:  1990 - 2014, April 15, 2016."]
["3.  GWPs are from Intergovernmental Panel on Climate Change (IPCC) Fourth Assessment Report (2007).  "]

{"sheet":"Purchased Gases","index":7,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[5,0,5,7],[6,0,6,7],[7,0,7,7]]}
[]
[]
["Scope 1 Emissions from Purchased Gases"]
[]
["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 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."]
["  (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."]
[]
["Table 1.  Purchased Gases"]
["Gas","Gas","Purchased","CO2 Equivalent"]
[null,"GWP","Amount","Emissions"]
[null,null,"(lb)","(lb)"]
[null,{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,GWP,2,FALSE))","v":""},null,{"$f":"IF(B15=\"\", \"\",B15*C15)","v":""}]
[null,{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,GWP,2,FALSE))","v":""},null,{"$f":"IF(B16=\"\", \"\",B16*C16)","v":""}]
[null,"",null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,""]
[null,"",null,""]
[]
["GHG Emissions"]
[]
[]
["Total CO2 Equivalent Emissions  (metric tons) - Purchased Gas",null,null,null,{"$f":"SUM(D15:D25)*kg_per_lb/1000","v":0}]
[]
["Notes:"]
["1.  GWPs are from Intergovernmental Panel on Climate Change (IPCC) Fourth Assessment Report (2007).  "]

{"sheet":"Waste Gases","index":8,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[5,0,5,6]]}
[]
[]
["Scope 1 Emissions from Combustion of Waste Gases"]
[]
["Guidance"]
["  (A)  Enter annual data in ORANGE cells as appropriate.  Data should be entered as an organization-wide value (all operations \n         combined prior to entry into this table)."]
["  (B)   Enter total amount waste stream gas combusted."]
["  (C)   Enter gas total number of moles per ft3."]
["- This number is based on specific temperature and pressure conditions."]
["- If no data are available use 0.00255 lb-mole/ft3 as a default value, based on conditions of 25oC and 1 atm."]
["  (D)   Enter molar fraction (as a percentage) for each gas component in Table 1."]
["                  - This number is based on either volume or molar mass percentage for each gas component."]
["                  - It is assumed that the remainder of the waste stream will be made up of compounds not containing carbon."]
[]
[null,null,null,"Waste Stream Gas Combusted:",null,"ft3"]
[null,null,null,"Gas total number of moles per unit volume:",2.5500000000000002E-3,"lb-mole/ft3"]
[]
["Table 1.  Determining Emission Factor for Gas Waste Stream"]
["Component","Chemical","Molar","Total","Molecular","Percent","Carbon"]
[null,"Formula","Fraction","Moles","Weight","Carbon","Content"]
[null,null,"(%)","(lb-mole/ft3)",null,"(%)","(lb/ft3)"]
["Carbon Monoxide","CO",null,{"$f":"IF(C22=0,\"\",(C22*$E$16))","v":""},{"$f":"(12.011*1)+(15.9994*1)","v":28.010399999999997},{"$f":"(C_AtomicMass*1)/E22","v":0.42880501528003884},{"$f":"IF(C22=0,\"\",(D22*E22*F22))","v":""}]
["Carbon Dioxide","CO2 ",null,{"$f":"IF(C23=0,\"\",(C23*$E$16))","v":""},{"$f":"(12.011*1)+(15.9994*2)","v":44.009799999999998},{"$f":"(C_AtomicMass*1)/E23","v":0.27291648678248936},{"$f":"IF(C23=0,\"\",(D23*E23*F23))","v":""}]
["Methane","CH4 ",null,"",{"$f":"(12.011*1)+(1.0079*4)","v":16.0426},{"$f":"(C_AtomicMass*1)/E24","v":0.74869410195354857},{"$f":"IF(C24=0,\"\",(D24*E24*F24))","v":""}]
["Acetylene","C2H2 ",null,"",{"$f":"(12.011*2)+(1.0079*2)","v":26.037799999999997},{"$f":"(C_AtomicMass*2)/E25","v":0.92258178494342846},""]
["Ethylene","C2H4 ",null,"",{"$f":"(12.011*2)+(1.0079*4)","v":28.053599999999999},{"$f":"(C_AtomicMass*2)/E26","v":0.85628938888413608},""]
["Ethane","C2H6 ",null,"",{"$f":"(12.011*2)+(1.0079*6)","v":30.069399999999998},{"$f":"(C_AtomicMass*2)/E27","v":0.79888524546548978},""]
["Propylene","C3H6 ",null,"",{"$f":"(12.011*3)+(1.0079*6)","v":42.080399999999997},{"$f":"(C_AtomicMass*3)/E28","v":0.85628938888413619},""]
["Propane","C3H8 ",null,"",{"$f":"(12.011*3)+(1.0079*8)","v":44.096200000000003},{"$f":"(C_AtomicMass*3)/E29","v":0.81714524154008727},""]
["n-Butane","C4H10 ",null,"",{"$f":"(12.011*4)+(1.0079*10)","v":58.122999999999998},{"$f":"(C_AtomicMass*4)/E30","v":0.82659188273144879},""]
["Benzene","C6H6 ",null,"",{"$f":"(12.011*6)+(1.0079*6)","v":78.113399999999999},{"$f":"(C_AtomicMass*6)/E31","v":0.92258178494342846},""]
["Hexane","C6H14 ",null,"",{"$f":"(12.011*6)+(1.0079*14)","v":86.176600000000008},{"$f":"(C_AtomicMass*6)/E32","v":0.83625949503693575},""]
["Toluene","C7H8 ",null,"",{"$f":"(12.011*7)+(1.0079*8)","v":92.140199999999993},{"$f":"(C_AtomicMass*7)/E33","v":0.91248987955311589},""]
["Octane","C8H18 ",null,"",{"$f":"(12.011*8)+(1.0079*18)","v":114.2302},{"$f":"(C_AtomicMass*8)/E34","v":0.84117860250616738},""]
["Ethanol","C2H5OH",null,"",{"$f":"(12.011*2)+(1.0079*6)+(15.9994*1)","v":46.068799999999996},{"$f":"(C_AtomicMass*2)/E35","v":0.52143750217066653},""]
["Acetone","CH3COCH3 ",null,"",{"$f":"(12.011*3)+(1.0079*6)+(15.9994*1)","v":58.079799999999999},{"$f":"(C_AtomicMass*3)/E36","v":0.62040502894293714},""]
["Tetrahydrofuran","C4H8O",null,"",{"$f":"(12.011*4)+(1.0079*8)+(15.9994*1)","v":72.1066},{"$f":"(C_AtomicMass*4)/E37","v":0.66629129649713059},""]
["Other non-carbon",null,{"$f":"1-SUM(C22:C37)","v":1},2.5500000000000002E-3,null,0,{"$f":"IF(C38=0,\"\",(D38*E38*F38))","v":0}]
["Total for all Components",null,{"$f":"SUM(C22:C38)","v":1},{"$f":"SUM(D22:D38)","v":2.5500000000000002E-3},null,null,{"$f":"SUM(G22:G38)","v":0}]
[]
["Step 4.     Enter Oxidation Factor",null,null,100,"%"]
["                  - If oxidation factor value is not known, use 100% as default value."]
[]
["GHG Emissions"]
[]
[]
["Total CO2 Equivalent Emissions  (metric tons) - Waste Gas Combustion",null,null,null,{"$f":"($G$39*$D$41/100*($E$23/12.011))*$E$15*kg_per_lb/1000","v":0}]
[]
["Notes:"]
["1.  This tool is designed to apply the CO2 emission factor calculation methodology for a gas waste stream as provided in the"]
["     Center for Corporate Climate Leadership Greenhouse Gas Inventory Guidance - Direct Emissions from Stationary Combustion Sources (January 2016)."]
["     This tool can also be used to approximate emissions for other combustion sources such as gas welding and gas metal cutting."]

{"sheet":"Electricity","index":9,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[11,0,11,6],[5,0,5,6],[9,1,9,6],[6,0,6,6],[7,0,7,6],[14,0,14,4],[14,11,14,13],[15,5,15,7],[15,8,15,10],[15,11,15,13],[14,5,14,10]]}
[]
[]
["Scope 2 Emissions from Purchase of Electricity"]
[]
["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 market-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 market-based method considers contractual arrangements under which the organization procures electricity from specific sources, such as renewable energy.  "]
["  (A)  Enter total annual electricity purchased in kWh and each eGRID subregion for each facility or site in ORANGE cells of Table 1.  "]
["  (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.\""]
[null," - 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:"]
[null,"https://oaspub.epa.gov/powpro/ept_pack.charts"]
["  (D) See the market-based emission factor hierarchy on the market-based method Help sheet. If any of the first four types of\n       emission factors are applicable, enter the factors in the yellow cells marked as \"<enter factor>\".  If not, leave the \n       yellow cells as is, and eGRID subregion factors will be used for market-based emissions. \n   Example entry is shown in first row (GREEN Italics) for a facility that purchases RECs for 100% of its consumption, and   \n       therefore has a market-based emission factor of 0."]
[]
["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,null,"Market-Based\nUse these cells to enter applicable market-based emission factors",null,null,null,null,null,"Location-Based"]
["Table 1.  Total Amount of Electricity Purchased by eGRID Subregion",null,null,null,null,"Emission Factors",null,null,"Emissions",null,null,"Emissions"]
["Source","Source","Source","eGRID Subregion","Electricity","CO2","CH4 ","N2O ","CO2","CH4 ","N2O ","CO2","CH4 ","N2O "]
["ID","Description","Area (sq ft)","where electricity is consumed","Purchased","Emissions","Emissions","Emissions","Emissions","Emissions","Emissions","Emissions","Emissions","Emissions"]
[null,null,null,null,"(kWh)","(lb/MWh)","(lb/MWh)","(lb/MWh)","(lb)","(lb)","(lb)","(lb)","(lb)","(lb)"]
["Bldg-012","East Power Plant",12517,"HIMS (HICC Miscellaneous)",200000,0,0,0,{"$f":"IFERROR(IF(ISBLANK(F20),L20,E20/1000*F20),\"Enter Factor\")","v":0},{"$f":"IFERROR(IF(ISBLANK(G20),M20,F20/1000*G20),\"Enter Factor\")","v":0},{"$f":"IFERROR(IF(ISBLANK(H20),N20,G20/1000*H20),\"Enter Factor\")","v":0},{"$f":"IF(ISNA(VLOOKUP($D20,eGRID_em_Fctrs,4,FALSE)),\"\",VLOOKUP($D20,eGRID_em_Fctrs,4,FALSE)*$E20/1000)","v":240019.99999999997},{"$f":"IF(ISNA(VLOOKUP($D20,eGRID_em_Fctrs,5,FALSE)),\"\",VLOOKUP($D20,eGRID_em_Fctrs,5,FALSE)*$E20/1000)","v":13.616},{"$f":"IF(ISNA(VLOOKUP($D20,eGRID_em_Fctrs,7,FALSE)),\"\",VLOOKUP($D20,eGRID_em_Fctrs,7,FALSE)*$E20/1000)","v":2.536}]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>",{"$f":"IFERROR(IF(OR(ISBLANK(F21),F21=\"<enter factor>\"),L21,$E21/1000*F21),\"\")","v":""},"","",{"$f":"IF(ISNA(VLOOKUP($D21,eGRID_em_Fctrs,4,FALSE)),\"\",VLOOKUP($D21,eGRID_em_Fctrs,4,FALSE)*$E21/1000)","v":""},"",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","",{"$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,"<enter factor>","<enter factor>","<enter factor>",{"$f":"IFERROR(IF(OR(ISBLANK(F23),F23=\"<enter factor>\"),L23,$E23/1000*F23),\"\")","v":""},{"$f":"IFERROR(IF(OR(ISBLANK(G23),G23=\"<enter factor>\"),M23,$E23/1000*G23),\"\")","v":""},{"$f":"IFERROR(IF(OR(ISBLANK(H23),H23=\"<enter factor>\"),N23,$E23/1000*H23),\"\")","v":""},"","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","",{"$f":"IFERROR(IF(OR(ISBLANK(G24),G24=\"<enter factor>\"),M24,$E24/1000*G24),\"\")","v":""},{"$f":"IFERROR(IF(OR(ISBLANK(H24),H24=\"<enter factor>\"),N24,$E24/1000*H24),\"\")","v":""},"","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
[null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>","","","","","",""]
["Total Emissions for All Sources",null,null,null,{"$f":"SUM($E$21:$E$57)","v":0},null,null,null,{"$f":"SUM($I$21:$I$57)","v":0},{"$f":"SUM($J$21:$J$57)","v":0},{"$f":"SUM($K$21:$K$57)","v":0},{"$f":"SUM($L$21:$L$57)","v":0},{"$f":"SUM($M$21:$M$57)","v":0},{"$f":"SUM($N$21:$N$57)","v":0}]
[]
["GHG Emissions"]
[]
["CO2 Equivalent Emissions  (metric tons)"]
["Location-Based Electricity Emissions",null,null,null,{"$f":"($L$58+$M$58*CH4_GWP+$N$58*N2O_GWP)*kg_per_lb/1000","v":0}]
["Market-Based Electricity Emissions",null,null,null,{"$f":"($I$58+$J$58*CH4_GWP+$K$58*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 eGRID2012, October 2015."]

{"sheet":"Steam","index":10,"n_rows":114,"n_cols":12,"rows_kept":114,"cut":false,"hidden":false,"merged":[[10,0,10,7],[21,3,23,3],[21,2,23,2],[67,4,67,6],[67,7,67,9],[20,9,20,11],[19,9,19,11],[19,6,19,8],[20,6,20,8],[70,2,70,3],[15,1,15,8],[68,2,68,3],[21,0,23,0],[21,1,23,1]]}
[]
[]
["Scope 2 Emissions from Purchase of Steam"]
[]
["Guidance"]
["(A)  Enter annual data for each facility or site in ORANGE 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 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-specific 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,null,null,null,null,null,"Location-Based\nUse these cells to enter supplier specific emission factors",null,null,"Market-Based\nUse these cells to enter market-based emission factors if different than the supplier-specific factors. "]
["Table 1.  Fuel, Boiler, Steam and Emission Factor Data for Steam Purchased",null,null,null,null,null,"Emissions",null,null,"Emission Factors"]
["Source\nID","Source\nDescription","Source\nArea (sq ft)","Fuel Type","Boiler","Steam","CO2 ","CH4 ","N2O","CO2 ","CH4 ","N2O"]
[null,null,null,null,"Efficiency","Purchased","Factor","Factor","Factor","Factor","Factor","Factor"]
[null,null,null,null,"(%)","(mmBtu)","(kg / mmBtu)","(g / mmBtu)","(g / mmBtu)","(kg / mmBtu)","(g / mmBtu)","(g / mmBtu)"]
["Bldg-011","Office ",5000,"Natural Gas",null,5000,72,1.5,0.6,"<enter factor>","<enter factor>","<enter factor>"]
["Bldg-012","Steam-Blr Room",2000,"Sub-bituminous Coal",80,10000,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[null,null,null,null,null,null,null,null,null,"<enter factor>","<enter factor>","<enter factor>"]
[]
["GHG Emissions"]
[]
["Emissions by Source and Fuel Type for Steam Purchased",null,null,null,"Location-Based",null,null,"Market-Based"]
["Source","Source","Fuel Type",null,"CO2 ","CH4 ","N2O","CO2 ","CH4 ","N2O"]
["ID","Description",null,null,"Emissions","Emissions","Emissions","Emissions","Emissions","Emissions"]
[null,null,null,null,"(kg)","(g)","(g)","(kg)","(g)","(g)"]
[{"$f":"IF(A27=\"\",\"\",A27)","v":""},"",{"$f":"IF(D27=\"\",\"\",D27)","v":""},null,{"$f":"IF($F27=\"\",\"\",IF(G27=\"\",(VLOOKUP($C72,Stationary_Fuel_Fctrs_mmBtu,2,FALSE))*$F27/(IF($E27=\"\", 0.8,$E27/100)),G27*$F27))","v":""},{"$f":"IF($F27=\"\",\"\",IF(H27=\"\",(VLOOKUP($C72,Stationary_Fuel_Fctrs_mmBtu,3,FALSE))*$F27/(IF($E27=\"\", 0.8,$E27/100)),H27*$F27))","v":""},{"$f":"IF($F27=\"\",\"\",IF(I27=\"\",(VLOOKUP($C72,Stationary_Fuel_Fctrs_mmBtu,4,FALSE))*$F27/(IF($E27=\"\", 0.8,$E27/100)),I27*$F27))","v":""},{"$f":"IF($F27=\"\",\"\",IF(OR(J27=\"\",J27=\"<enter factor>\"),E72,J27*$F27))","v":""},{"$f":"IF($F27=\"\",\"\",IF(OR(K27=\"\",K27=\"<enter factor>\"),F72,K27*$F27))","v":""},{"$f":"IF($F27=\"\",\"\",IF(OR(L27=\"\",L27=\"<enter factor>\"),G72,L27*$F27))","v":""}]
["","","",null,{"$f":"IF($F28=\"\",\"\",IF(G28=\"\",(VLOOKUP($C73,Stationary_Fuel_Fctrs_mmBtu,2,FALSE))*$F28/(IF($E28=\"\", 0.8,$E28/100)),G28*$F28))","v":""},"","",{"$f":"IF($F28=\"\",\"\",IF(OR(J28=\"\",J28=\"<enter factor>\"),E73,J28*$F28))","v":""},{"$f":"IF($F28=\"\",\"\",IF(OR(K28=\"\",K28=\"<enter factor>\"),F73,K28*$F28))","v":""},{"$f":"IF($F28=\"\",\"\",IF(OR(L28=\"\",L28=\"<enter factor>\"),G73,L28*$F28))","v":""}]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
[{"$f":"IF(A47=\"\",\"\",A47)","v":""},"","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
["","","",null,"","","","","",""]
[{"$f":"IF(A63=\"\",\"\",A63)","v":""},{"$f":"IF(B63=\"\",\"\",B63)","v":""},"",null,"","","","","",""]
[{"$f":"IF(A64=\"\",\"\",A64)","v":""},{"$f":"IF(B64=\"\",\"\",B64)","v":""},"",null,"","","","","",""]
["Total Emissions for All Sources",null,null,null,{"$f":"SUM(E72:E109)","v":0},0,0,0,0,0]
[]
["CO2 Equivalent Emissions  (metric tons)"]
["Location-Based Electricity Emissions",null,null,null,null,{"$f":"($E$110+$F$110*CH4_GWP/1000+$G$110*N2O_GWP/1000)/1000","v":0}]
["Market-Based Electricity Emissions",null,null,null,null,{"$f":"($H$110+$I$110*CH4_GWP/1000+$J$110*N2O_GWP/1000)/1000","v":0}]

{"sheet":"Business Travel","index":11,"n_rows":163,"n_cols":7,"rows_kept":163,"cut":false,"hidden":false,"merged":[[154,0,154,1],[149,0,149,1],[150,0,150,1],[151,0,151,1],[152,0,152,1],[153,0,153,1],[158,0,158,1],[159,0,159,1],[155,0,155,1],[156,0,156,1],[157,0,157,1]]}
[]
[]
["Scope 3 Emissions from Employee Business Travel"]
[]
["Guidance"]
["(A) Enter annual data in ORANGE cells in the table corresponding to the transport method.  Example entry is shown in first row (GREEN Italics)."]
["(B) Mileage data can be entered for individual trips or individual employees, or miles for multiple employees can be subtotaled by"]
["     vehicle type or flight length."]
["(C) For employees traveling by car, select \"Vehicle Type\" and enter miles traveled (vehicle-miles) in Table 1.  "]
["(D) For employees traveling by rail or bus, select \"Vehicle Type\" and enter passenger-miles in Table 2.  "]
["(E) For employees traveling by air, select \"Flight Length\" and enter passenger-miles in Table 3.  "]
["If the flight length is unknown, assume \"Medium Haul\". "]
[]
["Table 1.  Personal Vehicle, Rental Car or Taxi - Business Travel by Vehicle-Miles (CO2, CH4 and N2O)"]
["Source ID","Source Description","Vehicle Type"," Vehicle-Miles (miles)","CO2 Emissions (kg)","CH4 Emissions  (g)","N2O \nEmissions \n(g)"]
["JD-001","John Doe 1","Passenger Car",100,{"$f":"IF($C16=\"\",\"\",VLOOKUP($C16,Biz_Travel_Fctr,2,FALSE)*$D16)","v":35.5},{"$f":"IF($C16=\"\",\"\",VLOOKUP($C16,Biz_Travel_Fctr,3,FALSE)*$D16)","v":2.1},{"$f":"IF($C16=\"\",\"\",VLOOKUP($C16,Biz_Travel_Fctr,4,FALSE)*$D16)","v":1.5}]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[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 for all Personal Vehicle Business Travel",null,null,null,{"$f":"SUM(E17:E54)","v":0},{"$f":"SUM(F17:F54)","v":0},{"$f":"SUM(G17:G54)","v":0}]
[]
["Table 2.  Rail or Bus - Business Travel by Passenger-Miles (CO2, CH4 and N2O)"]
["Source ID","Source Description","Vehicle Type","Passenger-Miles (miles)","CO2 Emissions (kg)","CH4 Emissions \n(g)","N2O\n Emissions \n(g)"]
["JD-001","John Doe 1","Intercity Rail (i.e. Amtrak)",100,18.5,0.2,0.1]
[null,null,null,null,{"$f":"IF($C60=\"\",\"\",VLOOKUP($C60,Biz_Travel_Fctr,2,FALSE)*$D60)","v":""},{"$f":"IF($C60=\"\",\"\",VLOOKUP($C60,Biz_Travel_Fctr,3,FALSE)*$D60)","v":""},{"$f":"IF($C60=\"\",\"\",VLOOKUP($C60,Biz_Travel_Fctr,4,FALSE)*$D60)","v":""}]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
["Total for all Rail and Bus Business Travel",null,null,null,{"$f":"SUM(E60:E107)","v":0},{"$f":"SUM(F60:F107)","v":0},{"$f":"SUM(G60:G107)","v":0}]
[]
["Table 3.  Air - Business Travel by Passenger-Miles (CO2, CH4 and N2O)"]
["Source ID","Source Description","Flight Length","Passenger-Miles (miles)","CO2 Emissions (kg)","CH4 Emissions \n(g)","N2O\n Emissions \n(g)"]
["JD-001","John Doe 1","Medium Haul (>= 300 miles, < 2300 miles)",1000,229,10.4,8.5]
[null,null,null,null,{"$f":"IF($C113=\"\",\"\",VLOOKUP($C113,Biz_Travel_Fctr,2,FALSE)*$D113)","v":""},{"$f":"IF($C113=\"\",\"\",VLOOKUP($C113,Biz_Travel_Fctr,3,FALSE)*$D113)","v":""},{"$f":"IF($C113=\"\",\"\",VLOOKUP($C113,Biz_Travel_Fctr,4,FALSE)*$D113)","v":""}]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
["Total for all Air Business Travel",null,null,null,{"$f":"SUM(E113:E144)","v":0},{"$f":"SUM(F113:F144)","v":0},{"$f":"SUM(G113:G144)","v":0}]
[]
["GHG Emissions"]
[]
["Total CO2 Emissions by Travel Type"]
["Transport Type ",null,"CO2 (kg)","CH4 (g)","N2O (g)"]
["Passenger Car",null,{"$f":"SUMIF($C$17:$C$54,$A151,E$17:E$54)","v":0},{"$f":"SUMIF($C$17:$C$54,$A151,F$17:F$54)","v":0},0]
["Light-Duty Truck",null,0,0,0]
["Motorcycle",null,0,0,0]
["Intercity Rail (i.e. Amtrak)",null,{"$f":"SUMIF($C$60:$C$107,$A154,E$60:E$107)","v":0},0,0]
["Commuter Rail",null,0,0,0]
["Transit Rail (i.e. Subway, Tram)",null,0,0,0]
["Bus",null,0,0,0]
["Short Haul (< 300 miles)",null,{"$f":"SUMIF($C$113:$C$144,$A158,E$113:E$144)","v":0},{"$f":"SUMIF($C$113:$C$144,$A158,F$113:F$144)","v":0},{"$f":"SUMIF($C$113:$C$144,$A158,G$113:G$144)","v":0}]
["Medium Haul (>= 300 miles, < 2300 miles)",null,{"$f":"SUMIF($C$113:$C$144,$A159,E$113:E$144)","v":0},{"$f":"SUMIF($C$113:$C$144,$A159,F$113:F$144)","v":0},{"$f":"SUMIF($C$113:$C$144,$A159,G$113:G$144)","v":0}]
["Long Haul (>= 2300 miles)",null,0,0,0]
[]
[]
["Total CO2 Equivalent Emissions  (metric tons) - Employee Business Travel",null,null,{"$f":"(SUM(C151:C160)+SUM(D151:D160)/1000*CH4_GWP+SUM(E151:E160)/1000*N2O_GWP)/1000","v":0}]

{"sheet":"Commuting","index":12,"n_rows":121,"n_cols":7,"rows_kept":121,"cut":false,"hidden":false,"merged":[[116,0,116,1],[117,0,117,1],[110,0,110,1],[111,0,111,1],[112,0,112,1],[113,0,113,1],[114,0,114,1],[115,0,115,1]]}
[]
[]
["Scope 2 Emissions from Employee Commuting"]
[]
["Guidance"]
["(A) Enter annual data in ORANGE cells in the table corresponding to the transport method.  Example entry is shown in first row (GREEN Italics)."]
["(B) For employees commuting in a personal vehicle, select the \"Vehicle Type\" and enter miles traveled (vehicle-miles) in Table 1.  "]
["(C) For employees commuting using public transportation, select the \"Transport Type\" and enter passenger-miles in Table 2.  "]
[]
["Tip: If more than one employee travels by the same vehicle type or transport type, miles can be combined and entered in one row."]
[]
["Table 1.  Personal Vehicle - Employee Commuting by Vehicle-Miles (CO2, CH4 and N2O)"]
["Source ID","Source Description","Vehicle Type"," Vehicle-Miles (miles)","CO2 Emissions (kg)","CH4 Emissions  (g)","N2O \nEmissions \n(g)"]
["JD-001","John Doe 1","Passenger Car",100,{"$f":"IF($C14=\"\",\"\",VLOOKUP($C14,Biz_Travel_Fctr,2,FALSE)*$D14)","v":35.5},{"$f":"IF($C14=\"\",\"\",VLOOKUP($C14,Biz_Travel_Fctr,3,FALSE)*$D14)","v":2.1},{"$f":"IF($C14=\"\",\"\",VLOOKUP($C14,Biz_Travel_Fctr,4,FALSE)*$D14)","v":1.5}]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[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 for all Personal Vehicle Employee Commuting",null,null,null,{"$f":"SUM(E15:E52)","v":0},{"$f":"SUM(F15:F52)","v":0},{"$f":"SUM(G15:G52)","v":0}]
[]
["Table 2.  Public Transportation - Employee Commuting by Passenger-Miles (CO2, CH4 and N2O)"]
["Source ID","Source Description","Transport Type","Passenger-Miles (miles)","CO2 Emissions (kg)","CH4 Emissions \n(g)","N2O\n Emissions \n(g)"]
["JD-001","John Doe 1","Intercity Rail (i.e. Amtrak)",100,18.5,0.2,0.1]
[null,null,null,null,{"$f":"IF($C58=\"\",\"\",VLOOKUP($C58,Biz_Travel_Fctr,2,FALSE)*$D58)","v":""},{"$f":"IF($C58=\"\",\"\",VLOOKUP($C58,Biz_Travel_Fctr,3,FALSE)*$D58)","v":""},{"$f":"IF($C58=\"\",\"\",VLOOKUP($C58,Biz_Travel_Fctr,4,FALSE)*$D58)","v":""}]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
["Total for all Public Transportation Employee Commuting",null,null,null,{"$f":"SUM(E58:E105)","v":0},{"$f":"SUM(F58:F105)","v":0},{"$f":"SUM(G58:G105)","v":0}]
[]
["GHG Emissions"]
[]
["Total CO2 Emissions by Commuting Type"]
["Transport Type ",null,"CO2 (kg)","CH4 (g)","N2O (g)"]
["Passenger Car",null,{"$f":"SUMIF($C$15:$C$52,$A112,E$15:E$52)","v":0},0,0]
["Light-Duty Truck",null,0,0,0]
["Motorcycle",null,0,0,0]
["Intercity Rail (i.e. Amtrak)",null,{"$f":"SUMIF($C$58:$C$105,$A115,E$58:E$105)","v":0},{"$f":"SUMIF($C$58:$C$105,$A115,F$58:F$105)","v":0},{"$f":"SUMIF($C$58:$C$105,$A115,G$58:G$105)","v":0}]
["Commuter Rail",null,{"$f":"SUMIF($C$58:$C$105,$A116,E$58:E$105)","v":0},0,0]
["Transit Rail (i.e. Subway, Tram)",null,{"$f":"SUMIF($C$58:$C$105,$A117,E$58:E$105)","v":0},0,0]
["Bus",null,{"$f":"SUMIF($C$58:$C$105,$A118,E$58:E$105)","v":0},{"$f":"SUMIF($C$58:$C$105,$A118,F$58:F$105)","v":0},{"$f":"SUMIF($C$58:$C$105,$A118,G$58:G$105)","v":0}]
[]
[]
["Total CO2 Equivalent Emissions  (metric tons) - Commuting",null,null,{"$f":"(SUM(C112:C118)+SUM(D112:D118)/1000*CH4_GWP+SUM(E112:E118)/1000*N2O_GWP)/1000","v":0}]

{"sheet":"Product Transport","index":13,"n_rows":112,"n_cols":7,"rows_kept":112,"cut":false,"hidden":false,"merged":[[105,0,105,1],[106,0,106,1],[107,0,107,1],[108,0,108,1],[7,0,7,6],[8,0,8,6],[101,0,101,1],[102,0,102,1],[104,0,104,1],[103,0,103,1]]}
[]
[]
["Scope 2 Emissions from Product Transport"]
[]
["Guidance"]
["(A) Enter annual data in ORANGE cells in the table corresponding to the transport method.  Example entry is shown in first row (GREEN Italics)."]
["(B) For rail, water, or air shipments, enter ton-mile data in Table 2.  See Help sheet for details on calculating ton-miles."]
["(C) For road shipments, if your organization's product is the only product transported in the vehicle (i.e. full truckload shipment) then enter the vehicle type and miles for each leg of transport in Table 1.  Emissions are calculated using vehicle-miles."]
["(D) For road shipments, if your organization's product makes up only part of the truck load (i.e. less-than-load or LTL shipment), then enter the vehicle type and ton-miles (product weight x distance) for each leg of transport in Table 2.  Emissions are calculated using  \n     ton-miles.  See Help sheet for details on calculating ton-miles. "]
["Tip: Make sure all transport legs are accounted for from manufacturing facility to distribution to customer."]
[]
["Table 1.  On-Road Vehicle Product Transport by Vehicle-Miles  (CO2, CH4 and N2O)"]
["Source ID","Source Description","Vehicle Type"," Vehicle-Miles (miles)","CO2 Emissions (kg)","CH4 Emissions (g)","N2O Emissions (g)"]
["Bldg-012","East Power Plant Finished Goods","Medium- and Heavy-duty Truck",100,{"$f":"IF($C14=\"\",\"\",VLOOKUP($C14,Prod_Trans_Fctrs,2,FALSE)*$D14)","v":143},{"$f":"IF($C14=\"\",\"\",VLOOKUP($C14,Prod_Trans_Fctrs,3,FALSE)*$D14)","v":1.5},{"$f":"IF($C14=\"\",\"\",VLOOKUP($C14,Prod_Trans_Fctrs,4,FALSE)*$D14)","v":1.3}]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[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 for Product Transport by Vehicle-Miles",null,null,null,{"$f":"SUM(E15:E52)","v":0},{"$f":"SUM(F15:F52)","v":0},{"$f":"SUM(G15:G52)","v":0}]
[]
[]
["Table 2.  Product Transport by Ton-Miles (CO2, CH4 and N2O)"]
["Source ID","Source Description","Vehicle Type","Ton-Miles ","CO2 Emissions (kg)","CH4 Emissions (g)","N2O Emissions (g)"]
["Bldg-012","East Power Plant Finished Goods","Medium- and Heavy-Duty Truck",100,{"$f":"IF($D58=\"\",\"\",VLOOKUP(C58,Prod_Trans_Fctrs,2,FALSE)*$D58)","v":143},{"$f":"IF($D58=\"\",\"\",VLOOKUP(C58,Prod_Trans_Fctrs,3,FALSE)*$D58)","v":1.5},{"$f":"IF($D58=\"\",\"\",VLOOKUP(C58,Prod_Trans_Fctrs,4,FALSE)*$D58)","v":1.3}]
[null,null,null,null,{"$f":"IF($C59=\"\",\"\",VLOOKUP(C59,Prod_Trans_Fctrs,2,FALSE)*$D59)","v":""},{"$f":"IF($C59=\"\",\"\",VLOOKUP(C59,Prod_Trans_Fctrs,3,FALSE)*$D59)","v":""},{"$f":"IF($C59=\"\",\"\",VLOOKUP(C59,Prod_Trans_Fctrs,4,FALSE)*$D59)","v":""}]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
["Total for all Product Transport by Ton-Miles",null,null,null,{"$f":"SUM(E59:E96)","v":0},{"$f":"SUM(F59:F96)","v":0},{"$f":"SUM(G59:G96)","v":0}]
[]
["GHG Emissions"]
[]
[" Total Emissions by Product Transport Type"]
["Transport Type ",null,"CO2 (kg)","CH4 (g)","N2O (g)"]
["Medium- and Heavy-Duty Truck",null,{"$f":"SUMIF($C$15:$C$52,$A103,E$15:E$52)","v":0},0,0]
["Light-Duty Truck",null,0,0,0]
["Passenger Car",null,0,0,0]
["Truck",null,{"$f":"SUMIF($C$59:$C$96,$A106,E$59:E$96)","v":0},0,0]
["Rail",null,0,0,0]
["Aircraft",null,0,0,0]
["Waterborne Craft",null,0,0,0]
[]
[]
["Total CO2 Equivalent Emissions  (metric tons) - Product Transport",null,null,{"$f":"(SUM(C103:C109)+SUM(D103:D109)/1000*CH4_GWP+SUM(E103:E109)/1000*N2O_GWP)/1000","v":0}]

{"sheet":"RECs-Green Power","index":14,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,0,5,6],[2,0,2,4]]}
[]
[]
["Renewable Energy Certificates (RECs)/Green Power"]
[]
[]
["This section is no longer relevant as all REC or green power purchases should reported using the scope 2 market-based method.  See the Electricity Tab or Help sheet for more information"]

{"sheet":"Offsets","index":15,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[[23,0,24,1],[5,0,5,5]]}
[]
[]
["Purchased Offsets"]
[]
["Guidance"]
["  (A)  Enter quantity of offsets purchased for each offset project in terms of CO2 equivalent in ORANGE    \n         cells of Table 1.  Enter offsets purchased for the inventory reporting period.  Example entry is shown in \n         first row (GREEN Italics)."]
[]
["Table 1.  Total Amount of Purchased Offsets"]
[" ID","Project Description","Offsets Purchased\n(Metric Tons CO2e)"]
["Trees","Forestry Project",5000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["GHG Reductions"]
[]
["Total CO2 Equivalent Emission Reductions (metric tons) - Offsets"]
[null,null,{"$f":"SUM(C11:C20)","v":0}]

{"sheet":"Unit Conversions","index":16,"n_rows":62,"n_cols":4,"rows_kept":62,"cut":false,"hidden":false,"merged":[[5,0,5,3],[17,0,17,3],[35,0,35,3],[49,0,49,3]]}
[]
[]
["Tool Sheet: Unit Conversions"]
[]
[]
["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"]
["short ton","pounds (lb)",2000,"lb / short ton"]
["short ton","kilogram (kg)",907.2,"kg / short ton"]
["metric ton","pounds (lb)",2205,"lb / metric ton"]
["metric ton","kilogram (kg)",1000,"kg / metric ton"]
["metric ton","short ton",1.1020000000000001,"short ton / 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":17,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[6,5,25,5],[26,5,28,5]]}
[]
[]
["Tool Sheet: Heat Content for Specific Fuels"]
[]
[]
["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 November 2015.  Based on Federal Register (2009) EPA; 40 CFR Parts 86, 87, 89 et al; Mandatory Reporting of Greenhouse Gases. Memo: Table of Final 2013 Revisions to the Greenhouse Gas Reporting Rule (PDF) to 40 CFR part 98, subpart C: Table C–1 to Subpart C—Default CO2 Emission Factors and High Heat Values for Various Types of Fuel and Table C–2 to Subpart C—Default CH4 and N2O Emission Factors for  Various Types of Fuel. "]
["Natural Gas","Dth (Decatherm)","scf",{"$f":"D7","v":974.65886899999998},"scf / Dth"]
["Natural Gas","therm","scf",{"$f":"D8/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":"D7*('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"]
["Coal Coke","mmBtu","Short ton",{"$f":"1/24.8","v":4.0322580645161289E-2},"short ton / mmBtu"]
["Lignite Coal","mmBtu","Short ton",{"$f":"1/14.21","v":7.0372976776917659E-2},"short ton / mmBtu"]
["Mixed (Electric Power Sector)","mmBtu","Short ton",{"$f":"1/19.73","v":5.0684237202230108E-2},"short ton / mmBtu"]
["Wood and Wood Residuals","mmBtu","Short ton",{"$f":"1/17.48","v":5.7208237986270019E-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"]
["Petroleum Coke (Solid)","mmBtu","gallon",{"$f":"1/0.143","v":6.9930069930069934},"gallon / mmBtu"]
["Landfill Gas","mmBtu","scf",{"$f":"1/0.000485","v":2061.8556701030925},"scf / mmBtu"]
["Steam","Mlb (1,000 pounds)","mmBtu",{"$f":"D28*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":"D28*('Unit Conversions'!C12/'Unit Conversions'!B57)","v":2.3879999999999999E-3},"mmBtu / short ton"]

{"sheet":"Emission Factors","index":18,"n_rows":291,"n_cols":256,"rows_kept":291,"cut":false,"hidden":false,"merged":[[290,0,290,4],[24,0,24,7],[43,0,43,4],[58,4,58,7],[59,4,59,7],[60,4,60,7],[219,0,219,7],[211,2,211,4],[93,4,93,7],[94,4,94,7],[82,4,82,7],[83,4,83,7],[95,4,95,7],[96,4,96,7],[49,4,49,7],[50,4,50,7],[51,4,51,7],[52,4,52,7],[53,4,53,7],[54,4,54,7],[70,4,70,7],[65,4,65,7],[97,4,97,7],[199,2,199,4],[200,2,200,4],[201,2,201,4],[180,2,180,4],[202,2,202,4],[203,2,203,4],[204,2,204,4],[193,2,193,4],[100,0,100,4],[98,4,98,7],[99,4,99,7],[98,0,99,0],[196,2,196,4],[197,2,197,4],[198,2,198,4],[190,2,190,4],[191,2,191,4],[187,2,187,4],[188,2,188,4],[216,2,216,4],[205,2,205,4],[206,2,206,4],[207,2,207,4],[208,2,208,4],[209,2,209,4],[210,2,210,4],[212,2,212,4],[213,2,213,4],[214,2,214,4],[215,2,215,4],[42,0,42,4],[57,4,57,7],[62,4,62,7],[63,4,63,7],[64,4,64,7],[66,4,66,7],[61,4,61,7],[81,4,81,7],[45,4,45,7],[79,4,79,7],[46,4,46,7],[47,4,47,7],[48,4,48,7],[56,4,56,7],[55,4,55,7],[67,4,67,7],[68,4,68,7],[69,4,69,7],[75,4,75,7],[76,4,76,7],[77,4,77,7],[78,4,78,7],[84,4,84,7],[85,4,85,7],[71,4,71,7],[72,4,72,7],[73,4,73,7],[74,4,74,7],[80,4,80,7],[227,5,227,6],[227,0,227,2],[140,3,140,4],[189,2,189,4],[226,0,226,2],[101,0,101,4],[126,3,126,4],[127,3,127,4],[128,3,128,4],[129,3,129,4],[130,3,130,4],[131,3,131,4],[132,3,132,4],[133,3,133,4],[218,0,218,7],[134,3,134,4],[135,3,135,4],[284,0,284,4],[269,0,269,4],[91,4,91,7],[92,4,92,7],[86,4,86,7],[87,4,87,7],[88,4,88,7],[89,4,89,7],[90,4,90,7],[226,5,226,6],[136,3,136,4],[137,3,137,4],[138,3,138,4],[139,3,139,4],[192,2,192,4],[181,2,181,4],[182,2,182,4],[183,2,183,4],[184,2,184,4],[185,2,185,4],[186,2,186,4],[135,5,135,6],[194,2,194,4],[195,2,195,4]]}
[]
[]
["Tool Sheet: Emission Factors"]
[]
["All emission factors sourced from EPA's Emission Factors Hub, November 2015."]
["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.4439560000000005E-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.6773199999999999,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 (Electric Power Sector)",95.52,11,1.6]
["Coal Coke",113.67,11,1.6]
["Petroleum Coke",102.41,3,0.6]
["Wood and Wood Residuals",0,7.2,3.6,1639.624,125.85599999999999,62.927999999999997,"short tons"]
["Landfill Gas",0,3.2,0.63,2.5253950000000001E-2,1.5520000000000002E-3,3.0555000000000003E-4,"scf"]
["Source:"]
["Federal Register (2009) EPA; 40 CFR Parts 86, 87, 89 et al; Mandatory Reporting of Greenhouse Gases; Final Rule, 30Oct09, 261 pp. Tables C-1 and C-2 at FR pp. 56409-56410.  Revised emission factors for selected fuels: Federal Register (2010) EPA; 40 CFR Part 98; Mandatory Reporting of Greenhouse Gases; Final Rule, 17Dec10, 81 pp. With Amendments from Memo: Table of Final 2013 Revisions to the Greenhouse Gas Reporting Rule (PDF) to 40 CFR part 98, subpart C: Table C–1 to Subpart C—Default CO2 Emission Factors and High Heat Values for Various Types of Fuel and Table C–2 to Subpart C—Default CH4 and N2O Emission Factors for  Various Types of Fuel. "]
[]
[]
[]
["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.46,"gallon"]
["Compressed Natural Gas (CNG)",5.4440000000000002E-2,"scf"]
["Source:"]
["Federal Register (2009) EPA; 40 CFR Parts 86, 87, 89 et al; Mandatory Reporting of Greenhouse Gases; Final Rule, 30Oct09, 261 pp. Tables C-1 and C-2.  Table of Final 2013 Revisions to the Greenhouse Gas Reporting Rule,  September 24, 2013."]
["LNG sourced from: GREET™ Software, GREET1_2013 Model, Argonne National Laboratory. The GREET model provides carbon content and fuel density, which are used to develop the CO2 emission factor."]
["CH4 and N2O Emissions for Highway Vehicles"]
["Vehicle Type","Year","CH4 Factor \n(g / mile)","N2O Factor \n(g / mile)","Notes"]
["Gasoline Passenger Cars","1984-1993",7.0400000000000004E-2,6.4699999999999994E-2]
[null,1994,5.3100000000000001E-2,5.6000000000000001E-2]
[null,1995,3.5799999999999998E-2,4.7300000000000002E-2]
[null,1996,2.7199999999999998E-2,4.2599999999999999E-2]
[null,1997,2.6800000000000001E-2,4.2200000000000001E-2]
[null,1998,2.4899999999999999E-2,3.9300000000000002E-2]
[null,1999,2.1600000000000001E-2,3.3700000000000001E-2]
[null,2000,1.78E-2,2.7300000000000001E-2]
[null,2001,1.0999999999999999E-2,1.5800000000000002E-2]
[null,2002,1.0699999999999999E-2,1.5299999999999999E-2]
[null,2003,1.14E-2,1.35E-2]
[null,2004,1.4500000000000001E-2,8.3000000000000001E-3]
[null,2005,1.47E-2,7.9000000000000008E-3]
[null,2006,1.6076E-2,5.651999999999999E-3]
[null,2007,1.7027999999999998E-2,4.0559999999999997E-3]
[null,2008,1.7163999999999999E-2,3.8279999999999998E-3]
[null,"2009-present",1.7299999999999999E-2,3.5999999999999999E-3]
["Gasoline Light-Duty Trucks","1987-1993",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,3.9100000000000003E-2,7.2800000000000004E-2]
[null,1999,3.2099999999999997E-2,5.6399999999999999E-2]
[null,2000,3.4599999999999999E-2,6.2100000000000002E-2]
[null,2001,1.5100000000000001E-2,1.6400000000000001E-2]
[null,2002,1.78E-2,2.2800000000000001E-2]
[null,2003,1.55E-2,1.14E-2]
[null,2004,1.52E-2,1.32E-2]
[null,2005,1.5699999999999999E-2,1.01E-2]
[null,2006,1.5925000000000002E-2,8.8749999999999992E-3]
[null,2007,1.609E-2,7.8739999999999991E-3]
[null,2008,1.6299999999999999E-2,6.6E-3]
[null,"2009-present",1.6299999999999999E-2,6.6E-3,"Assumed these CH4 and N2O factors for ethanol light-duty vehicles"]
["Gasoline Heavy-Duty Vehicles","1985-1986",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.4100000000000004E-2,0.16930000000000001]
[null,1999,5.7799999999999997E-2,0.14349999999999999]
[null,2000,4.9299999999999997E-2,0.10920000000000001]
[null,2001,5.28E-2,0.1235]
[null,2002,5.4600000000000003E-2,0.13070000000000001]
[null,2003,5.33E-2,0.124]
[null,2004,3.4099999999999998E-2,2.8500000000000001E-2]
[null,2005,3.2599999999999997E-2,1.77E-2]
[null,2006,3.27E-2,1.7100000000000001E-2]
[null,2007,3.3000000000000002E-2,1.5299999999999999E-2]
[null,2008,3.3300000000000003E-2,1.34E-2]
[null,"2009-present",3.3300000000000003E-2,1.34E-2,"Assumed these CH4 and N2O factors for ethanol heavy-duty vehicles and buses"]
["Gasoline Motorcycles","1960-1995",8.9899999999999994E-2,8.6999999999999994E-3]
[null,"1996-present",6.7199999999999996E-2,6.8999999999999999E-3]
["Source:"]
["EPA (2015) Inventory of U.S. Greenhouse Gas Emissions and Sinks: 1990-2013. All values are calculated from Tables A-102 through A-106."]
[]
["Vehicle Type","Vehicle Year","CH4 Factor \n(g / mile)","N2O Factor \n(g / mile)"]
["Diesel Passenger Cars","1960-1982",5.9999999999999995E-4,1.1999999999999999E-3]
[null,"1983-present",5.0000000000000001E-4,1E-3]
["Diesel Light-Duty Trucks","1960-1982",1.1000000000000001E-3,1.6999999999999999E-3]
[null,"1983-1995",8.9999999999999998E-4,1.4E-3]
[null,"1996-present",1E-3,1.5E-3]
["Diesel Medium- and Heavy-Duty Vehicles","1960-present",5.1000000000000004E-3,4.7999999999999996E-3]
["CNG Light-Duty Vehicles",null,0.73699999999999999,0.05]
["CNG Heavy-Duty Vehicles",null,1.966,0.17499999999999999]
["CNG Buses",null,1.966,0.17499999999999999]
["LPG Light-Duty Vehicles",null,3.6999999999999998E-2,6.7000000000000004E-2]
["LPG Medium- and Heavy-Duty Vehicles",null,6.6000000000000003E-2,0.17499999999999999]
["LNG Medium- and Heavy-Duty Vehicles",null,1.966,0.17499999999999999]
["Ethanol Light-Duty Vehicles",null,5.5E-2,6.7000000000000004E-2]
["Ethanol Medium- and Heavy-Duty Vehicles",null,0.19700000000000001,0.17499999999999999]
["Ethanol Buses",null,0.19700000000000001,0.17499999999999999]
["Biodiesel Light-Duty Vehicles",null,5.0000000000000001E-4,1E-3]
["Biodiesel Medium- and Heavy-Duty Vehicles",null,5.0000000000000001E-3,5.0000000000000001E-3]
["Biodiesel Buses",null,5.0000000000000001E-3,5.0000000000000001E-3]
["Source: "]
["EPA (2015) Inventory of U.S. Greenhouse Gas Emissions and Sinks: 1990-2013. All values are calculated from Tables A-105 through A-107."]
[]
["CH4 and N2O Emissions for Non-Road Vehicles"]
["Vehicle Type","CH4 Factor \n(g / gallon) ","N2O Factor \n(g / gallon) ","Notes"]
["LPG Non-Road Vehicles",0.5,0.22,"equal to gasoline construction equipment (Table A-6)"]
["Residual Oil Ships and Boats",0.11,0.56999999999999995]
["Diesel Ships and Boats",0.06,0.45]
["Gasoline Ships and Boats",0.64,0.22]
["Diesel Locomotives",0.8,0.26]
["Gasoline Agricultural Equip.",1.26,0.22]
["Diesel Agricultural Equip.",1.44,0.26]
["Gasoline Construction Equip.",0.5,0.22]
["Diesel Construction Equip.",0.56999999999999995,0.26]
["Jet Fuel Aircraft",0,0.3]
["Aviation Gasoline Aircraft",7.06,0.11]
["Biodiesel Non-Road Vehicles",0.56999999999999995,0.26,"equal to diesel (Table A-6)"]
["Other Diesel Non-Road Vehicles",0.56999999999999995,0.26]
["Other Gasoline Non-Road Vehicles",0.5,0.22]
["Source:"]
[" EPA (2015) Inventory of U.S. Greenhouse Gas Emissions and Sinks: 1990-2013. All values are calculated from Table A-108."]
["Note: LPG non-road vehicles assumed equal to other gasoline sources.  Biodiesel vehicles assumed equal to other diesel sources."]
[]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B158:IU158)","v":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"]
[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"]
["Source:"]
["100-year GWPs from IPCC Fourth Assessment Report (AR4), 2007."]
["GWPs of blended refrigerants are based on their HFC and PFC constituents, which are based on data from http://www.epa.gov/ozone/snap/refrigerants/refblend.html."]
["Molecular Weights"]
["Element","Atomic Weight"]
["Carbon",12.010999999999999]
[]
["Electricity Emission Factors (System Average)"]
[" CO2, CH4 and N2O System Average Emission Factors by Subregion eGRID2012, October 2015."]
["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,1268.73,2.6339999999999999E-2,null,7.5900000000000004E-3]
["AKMS (ASCC Miscellaneous)",null,null,481.17,1.865E-2,null,3.5500000000000002E-3]
["AZNM (WECC Southwest)",null,null,1152.8900000000001,1.865E-2,null,1.511E-2]
["CAMX (WECC California)",null,null,650.30999999999995,3.1119999999999998E-2,null,5.6699999999999997E-3]
["ERCT (ERCOT All)",null,null,1143.04,1.67E-2,null,1.2330000000000001E-2]
["FRCC (FRCC All)",null,null,1125.3499999999999,4.0050000000000002E-2,null,1.1849999999999999E-2]
["HIMS (HICC Miscellaneous)",null,null,1200.0999999999999,6.8080000000000002E-2,null,1.268E-2]
["HIOA (HICC Oahu)",null,null,1576.38,9.0410000000000004E-2,null,2.155E-2]
["MROE (MRO East)",null,null,1522.57,2.4299999999999999E-2,null,2.555E-2]
["MROW (MRO West)",null,null,1425.15,2.76E-2,null,2.426E-2]
["NEWE (NPCC New England)",null,null,637.9,7.2840000000000002E-2,null,1.0710000000000001E-2]
["NWPP (WECC Northwest)",null,null,665.75,1.26E-2,null,1.038E-2]
["NYCW (NPCC NYC/Westchester)",null,null,696.7,2.5510000000000001E-2,null,2.9299999999999999E-3]
["NYLI (NPCC Long Island)",null,null,1201.2,7.8200000000000006E-2,null,9.8700000000000003E-3]
["NYUP (NPCC Upstate NY)",null,null,408.8,1.559E-2,null,3.8300000000000001E-3]
["RFCE (RFC East)",null,null,858.56,2.6440000000000002E-2,null,1.149E-2]
["RFCM (RFC Michigan)",null,null,1569.23,3.0360000000000002E-2,null,2.4119999999999999E-2]
["RFCW (RFC West)",null,null,1379.48,1.711E-2,null,2.1669999999999998E-2]
["RMPA (WECC Rockies)",null,null,1822.65,2.1659999999999999E-2,null,2.8129999999999999E-2]
["SPNO (SPP North)",null,null,1721.65,2.0219999999999998E-2,null,2.7140000000000001E-2]
["SPSO (SPP South)",null,null,1538.63,2.375E-2,null,1.9980000000000001E-2]
["SRMV (SERC Mississippi Valley)",null,null,1052.92,2.095E-2,null,1.061E-2]
["SRMW (SERC Midwest)",null,null,1710.75,1.958E-2,null,2.75E-2]
["SRSO (SERC South)",null,null,1149.05,2.266E-2,null,1.549E-2]
["SRTV (SERC Tennessee Valley)",null,null,1337.15,1.7389999999999999E-2,null,2.078E-2]
["SRVC (SERC Virginia/Carolina)",null,null,932.87,2.3949999999999999E-2,null,1.46E-2]
[]
[]
["Business Travel Emission Factors"]
["Vehicle Type","CO2 Factor \n(kg / unit)","CH4 Factor \n(g / unit)","N2O Factor \n(g / unit)","Units"]
["Passenger Car",0.35499999999999998,2.1000000000000001E-2,1.4999999999999999E-2,"vehicle-mile"]
["Light-Duty Truck",0.48499999999999999,0.02,2.1999999999999999E-2,"vehicle-mile"]
["Motorcycle",0.191,7.0000000000000007E-2,7.0000000000000001E-3,"vehicle-mile"]
["Intercity Rail (i.e. Amtrak)",0.13600000000000001,8.3000000000000001E-3,3.0000000000000001E-3,"passenger-mile"]
["Commuter Rail",0.16900000000000001,8.5000000000000006E-3,3.3999999999999998E-3,"passenger-mile"]
["Transit Rail (i.e. Subway, Tram)",0.12,2.5000000000000001E-3,1.6999999999999999E-3,"passenger-mile"]
["Bus",5.5E-2,5.9999999999999995E-4,5.0000000000000001E-4,"passenger-mile"]
["Short Haul (< 300 miles)",0.251,3.8999999999999998E-3,8.3000000000000001E-3,"passenger-mile"]
["Medium Haul (>= 300 miles, < 2300 miles)",0.14299999999999999,0,4.7000000000000002E-3,"passenger-mile"]
["Long Haul (>= 2300 miles)",0.16700000000000001,5.9999999999999995E-4,5.5999999999999999E-3,"passenger-mile"]
["Source:"]
["CO2, CH4, and N2O emissions data for on-road vehicles are from Table 2-13 of the Inventory of U.S. Greenhouse Gas Emissions and Sinks: 1990–2013.  Vehicle-miles and passenger-miles data for on-road vehicles are from Table VM-1 of the Federal Highway Administration Highway Statistics 2013.\nFuel consumption data and passenger-miles data for rail are from Tables A.14 to A.16 and 9.10 to 9.12 of the Transportation Energy Data Book: Edition 33. Fuel consumption was converted to emissions by using fuel and electricity emission factors presented in the tables above. \nAir Travel factors from 2015 Guidelines to Defra / DECC's GHG Conversion Factors for Company Reporting.  Version 1.0 July 2015."]
[]
[]
[]
["Product Transport 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.43,1.4999999999999999E-2,1.2999999999999999E-2,"vehicle-mile"]
["Passenger Car",0.35499999999999998,2.1000000000000001E-2,1.4999999999999999E-2,"vehicle-mile"]
["Light-Duty Truck",0.48499999999999999,0.02,2.1999999999999999E-2,"vehicle-mile"]
["Medium- and Heavy-Duty Truck",0.14599999999999999,1.5E-3,1.4E-3,"ton-mile"]
["Rail",2.4E-2,1.9E-3,5.9999999999999995E-4,"ton-mile"]
["Waterborne Craft",5.8999999999999997E-2,5.0000000000000001E-4,4.0000000000000001E-3,"ton-mile"]
["Aircraft",1.3069999999999999,0,4.02E-2,"ton-mile"]
[]
["Source:"]
["CO2, CH4, and N2O emissions data for on-road vehicles are from Table 2-13 of the U.S. Greenhouse Gas Emissions and Sinks: 1990–2013.  Vehicle-miles and passenger-miles data for on-road vehicles are from Table VM-1 of the Federal Highway Administration Highway Statistics 2013.  \nCO2e emissions data for non-road vehicles are based on Table A-117 of the U.S. Greenhouse Gas Emissions and Sinks: 1990–2013, which are distributed into CO2, CH4, and N2O emissions based on fuel/vehicle emission factors.  Freight ton-mile data for non-road vehicles are from Table 1-50 of the Bureau of Transportation Statistics, National Transportation Statistics for 2014 (Data based on 2011)."]
["Fire Suppresant Leak Rates"]
["Type of Equipment","Leak Rate"]
["Fixed",3.5000000000000003E-2]
["Portable",2.5000000000000001E-2]
["Source:"]
["US EPA - Inventory of U.S. Greenhouse Gas Emissions and Sinks:  1990 - 2014, April 15, 2016.    Page A-248"]

{"sheet":"DropDown","index":19,"n_rows":56,"n_cols":21,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
["Tab Navigation","Help Tab Navigation","Fuel Combusted","Vehicle Type","TYPE OF REFRIGERATION EQUIPMENT","CHOICES FOR REFRIGERANT","Fire Suppression Equipment","Fire Suppression Gas","GHGs","Electricity eGRID Subregions","Steam Fuel Type","Travel by Vehicle Miles","Travel by Passenger Miles","Travel by Air","Product Transport Vehicle Type","Product Transport Type","Fuel","Fuel Type","Gas","Liquid","Solid"]
["Stationary Combustion","Help - Data Management","Natural Gas","Aviation Gasoline Aircraft","Domestic Refrigeration","CO2 ","Fixed","CO2 ","CO2 ",{"$f":"'Emission Factors'!A229","v":"AKGD (ASCC Alaska Grid)"},"Natural Gas","Passenger Car","Intercity Rail (i.e. Amtrak)","Short Haul (< 300 miles)","Medium- and Heavy-duty Truck","Medium- and Heavy-Duty Truck","Natural Gas","Gas","SCF","Gallons","Short Ton"]
["Mobile Sources","Help - Stationary Combustion","Distillate Fuel Oil No. 2","Biodiesel Buses","Stand-Alone Commercial","HFC-23","Portable","HFC-23","CH4",{"$f":"'Emission Factors'!A230","v":"AKMS (ASCC Miscellaneous)"},"Distillate Fuel Oil No. 2","Light-Duty Truck","Commuter Rail","Medium Haul (>= 300 miles, < 2300 miles)","Light-Duty Truck","Rail","Distillate Fuel Oil No. 2","Liquid","Therm","MMBtu","MMBtu"]
["Refrigeration and AC","Help - Mobile Sources","Residual Fuel Oil No. 6","Biodiesel Light-Duty Vehicles","Medium/Large Commercial","HFC-32",null,"HFC-125","N2O",{"$f":"'Emission Factors'!A231","v":"AZNM (WECC Southwest)"},"Residual Fuel Oil No. 6","Motorcycle","Transit Rail (i.e. Subway, Tram)","Long Haul (>= 2300 miles)","Passenger Car","Aircraft","Residual Fuel Oil No. 6","Liquid","MMBtu"]
["Fire Suppression","Help - Refrigeration and AC","Kerosene","Biodiesel Medium- and Heavy-Duty Vehicles","Transport Refrigeration","HFC-125",null,"HFC-134a","SF6 ",{"$f":"'Emission Factors'!A232","v":"CAMX (WECC California)"},"Kerosene",null,"Bus",null,null,"Waterborne Craft","Kerosene","Liquid"]
["Purchased Gases","Help - Fire Suppression","Liquefied Petroleum Gases (LPG)","Biodiesel Non-Road Vehicles","Industrial Refrigeration","HFC-134a",null,"HFC-227ea","NF3",{"$f":"'Emission Factors'!A233","v":"ERCT (ERCOT All)"},"Liquefied Petroleum Gases (LPG)",null,null,null,null,null,"Liquefied Petroleum Gases (LPG)","Liquid"]
["Waste Gases","Help - Purchased Gases","Anthracite Coal","CNG Buses","Chillers","HFC-143a",null,"HFC-236fa","HFC-23",{"$f":"'Emission Factors'!A234","v":"FRCC (FRCC All)"},"Anthracite Coal",null,null,null,null,null,"Anthracite Coal","Solid"]
["Electricity","Help - Waste Gases","Bituminous Coal","CNG Heavy-Duty Vehicles","Residential/Commercial A/C","HFC-152a",null,"CF4","HFC-32",{"$f":"'Emission Factors'!A235","v":"HIMS (HICC Miscellaneous)"},"Bituminous Coal",null,null,null,null,null,"Bituminous Coal","Solid"]
["Steam","Help - Electricity","Sub-bituminous Coal","CNG Light-Duty Vehicles","Car A/C Units","HFC-236fa",null,"C4F10","HFC-125",{"$f":"'Emission Factors'!A236","v":"HIOA (HICC Oahu)"},"Sub-bituminous Coal",null,null,null,null,null,"Sub-bituminous Coal","Solid"]
["Business Travel","Help - Steam","Lignite Coal","Diesel Agricultural Equip.","Light-Duty Truck A/C Units","CF4",null,null,"HFC-134a",{"$f":"'Emission Factors'!A237","v":"MROE (MRO East)"},"Lignite Coal",null,null,null,null,null,"Lignite Coal","Solid"]
["Commuting","Help - Business Travel","Wood and Wood Residuals","Diesel Construction Equip.",null,"C2F6 ",null,null,"HFC-143a",{"$f":"'Emission Factors'!A238","v":"MROW (MRO West)"},"Mixed (Electric Power Sector)",null,null,null,null,null,"Wood and Wood Residuals","Solid"]
["Product Transport","Help - Commuting","Landfill Gas","Diesel Light-Duty Trucks",null,"SF6 ",null,null,"HFC-152a",{"$f":"'Emission Factors'!A239","v":"NEWE (NPCC New England)"},"Coal Coke",null,null,null,null,null,"Landfill Gas","Gas"]
["RECs-Green Power","Help - Product Transport",null,"Diesel Locomotives",null,"R-401A",null,null,"HFC-236fa",{"$f":"'Emission Factors'!A240","v":"NWPP (WECC Northwest)"},"Petroleum Coke"]
["Offsets","Help - Market-Based Method",null,"Diesel Medium- and Heavy-Duty Vehicles",null,"R-401B",null,null,"CF4",{"$f":"'Emission Factors'!A241","v":"NYCW (NPCC NYC/Westchester)"},"Wood and Wood Residuals"]
[null,"Help - Offsets",null,"Diesel Passenger Cars",null,"R-401C",null,null,"C2F6 ",{"$f":"'Emission Factors'!A242","v":"NYLI (NPCC Long Island)"},"Landfill Gas"]
[null,null,null,"Diesel Ships and Boats",null,"R-402A",null,null,"C3F8",{"$f":"'Emission Factors'!A243","v":"NYUP (NPCC Upstate NY)"}]
[null,null,null,"Ethanol Buses",null,"R-402B",null,null,"C4F10",{"$f":"'Emission Factors'!A244","v":"RFCE (RFC East)"}]
[null,null,null,"Ethanol Light-Duty Vehicles",null,"R-403B",null,null,"c-C4F8",{"$f":"'Emission Factors'!A245","v":"RFCM (RFC Michigan)"}]
[null,null,null,"Ethanol Medium- and Heavy-Duty Vehicles",null,"R-404A",null,null,"C5F12",{"$f":"'Emission Factors'!A246","v":"RFCW (RFC West)"}]
[null,null,null,"Gasoline Agricultural Equip.",null,"R-406A",null,null,"C6F14",{"$f":"'Emission Factors'!A247","v":"RMPA (WECC Rockies)"}]
[null,null,null,"Gasoline Construction Equip.",null,"R-407A",null,null,"R-401A",{"$f":"'Emission Factors'!A248","v":"SPNO (SPP North)"}]
[null,null,null,"Gasoline Heavy-Duty Vehicles",null,"R-407B",null,null,"R-401B",{"$f":"'Emission Factors'!A249","v":"SPSO (SPP South)"}]
[null,null,null,"Gasoline Light-Duty Trucks",null,"R-407C",null,null,"R-401C",{"$f":"'Emission Factors'!A250","v":"SRMV (SERC Mississippi Valley)"}]
[null,null,null,"Gasoline Motorcycles",null,"R-407D",null,null,"R-402A",{"$f":"'Emission Factors'!A251","v":"SRMW (SERC Midwest)"}]
[null,null,null,"Gasoline Passenger Cars",null,"R-407E",null,null,"R-402B",{"$f":"'Emission Factors'!A252","v":"SRSO (SERC South)"}]
[null,null,null,"Gasoline Ships and Boats",null,"R-408A",null,null,"R-403B",{"$f":"'Emission Factors'!A253","v":"SRTV (SERC Tennessee Valley)"}]
[null,null,null,"Jet Fuel Aircraft",null,"R-409A",null,null,"R-404A",{"$f":"'Emission Factors'!A254","v":"SRVC (SERC Virginia/Carolina)"}]
[null,null,null,"LNG Medium- and Heavy-Duty Vehicles",null,"R-410A",null,null,"R-406A"]
[null,null,null,"LPG Light-Duty Vehicles",null,"R-410B",null,null,"R-407A"]
[null,null,null,"LPG Medium- and Heavy-Duty Vehicles",null,"R-411A",null,null,"R-407B"]
[null,null,null,"LPG Non-Road Vehicles",null,"R-411B",null,null,"R-407C"]
[null,null,null,"Other Diesel Non-Road Vehicles",null,"R-413A",null,null,"R-407D"]
[null,null,null,"Other Gasoline Non-Road Vehicles",null,"R-414A",null,null,"R-407E"]
[null,null,null,"Residual Oil Ships and Boats",null,"R-414B",null,null,"R-408A"]
[null,null,null,null,null,"R-417A",null,null,"R-409A"]
[null,null,null,null,null,"R-422A",null,null,"R-410A"]
[null,null,null,null,null,"R-422D",null,null,"R-410B"]
[null,null,null,null,null,"R-423A",null,null,"R-411A"]
[null,null,null,null,null,"R-424A",null,null,"R-411B"]
[null,null,null,null,null,"R-426A",null,null,"R-413A"]
[null,null,null,null,null,"R-428A",null,null,"R-414A"]
[null,null,null,null,null,"R-434A",null,null,"R-414B"]
[null,null,null,null,null,"R-500",null,null,"R-417A"]
[null,null,null,null,null,"R-502",null,null,"R-422A"]
[null,null,null,null,null,"R-504",null,null,"R-422D"]
[null,null,null,null,null,"R-507",null,null,"R-423A"]
[null,null,null,null,null,"R-508A",null,null,"R-424A"]
[null,null,null,null,null,"R-508B",null,null,"R-426A"]
[null,null,null,null,null,null,null,null,"R-428A"]
[null,null,null,null,null,null,null,null,"R-434A"]
[null,null,null,null,null,null,null,null,"R-500"]
[null,null,null,null,null,null,null,null,"R-502"]
[null,null,null,null,null,null,null,null,"R-504"]
[null,null,null,null,null,null,null,null,"R-507"]
[null,null,null,null,null,null,null,null,"R-508A"]
[null,null,null,null,null,null,null,null,"R-508B"]

{"sheet":"Help - Data Management","index":20,"n_rows":131,"n_cols":6,"rows_kept":131,"cut":false,"hidden":false,"merged":[[29,4,29,5],[27,4,27,5],[130,2,130,4],[126,2,126,4],[43,1,43,5],[124,2,124,4],[125,2,125,4],[127,2,127,4],[128,2,128,4],[129,2,129,4],[120,2,120,4],[121,2,121,4],[116,2,116,4],[117,2,117,4],[40,0,40,5],[45,1,45,5],[30,4,30,5],[31,4,31,5],[35,1,35,3],[36,1,36,3],[97,1,97,5],[37,1,37,3],[102,1,102,5],[30,1,30,3],[31,1,31,3],[32,1,32,3],[1,2,1,3],[11,4,11,5],[12,4,12,5],[11,1,11,2],[12,1,12,2],[8,0,8,5],[18,1,18,3],[47,2,47,5],[28,1,28,2],[14,1,14,2],[15,1,15,2],[26,1,26,2],[122,2,122,4],[123,2,123,4],[5,0,5,4],[34,1,34,3],[104,1,104,5],[89,2,89,5],[68,2,68,5],[44,1,44,5],[25,1,25,3],[118,2,118,4],[119,2,119,4],[13,1,13,2],[19,4,19,5],[103,1,103,5],[110,1,110,5],[115,2,115,4],[14,4,14,5],[15,4,15,5],[21,4,21,5],[16,1,16,2],[27,1,27,2],[17,4,17,6],[18,4,18,6],[19,1,19,3],[23,1,23,3],[22,1,22,3],[20,1,20,3],[24,4,24,5],[20,4,20,5],[23,4,23,5],[26,4,26,5]]}
[]
[null,null,"Stationary Combustion"]
[]
["Data Management - HELP SHEET"]
[]
["On this sheet you will find general suggestions regarding GHG inventory data management."]
[]
["DATA MANAGEMENT"]
["This Calculator provides the calculations to quantify your organization's GHG emissions based on annual totals for activity data, which are entered in the ORANGE data entry cells in this workbook.  It is good practice to use a spreadsheet or database to track more detailed activity data, such as monthly energy consumption, and aggregate that detailed data into annual totals for entry into the Calculator.  This approach provides an \"audit trail\" that retraces the steps completed to arrive at the annual usage numbers you enter into the Calculator.   ENERGY STAR's Portfolio Manager is one database option if your business is already using this tool.  (More information on Portfolio Manager is available in the Guide to GHG Management). The bullets below suggest the type of data you may want to store in the data management spreadsheet or database.   "]
[]
[null,"A List of Facilities and Attributes",null,null,"Purchased Gas Data"]
[null,"* Facility Name or Site ID",null,null,"* Types of Gas Purchased"]
[null,"* Address (including zip code)",null,null,"* Amount of Gas Purchased"]
[null,"* Floor area (sq ft)",null,null,"Waste Gas Data"]
[null,"* Number of Employees",null,null,"* Type and Composition of Waste Gases Combusted"]
[null,"* Open and Close Date of Facility",null,null,"* Amount of each Waste Gas Combusted"]
[null,"* Type of Facility",null,null,"Steam Data"]
[null,"Electricity Data",null,null,"* Monthly Consumption Data by Meter or Facility"]
[null,"* Monthly Consumption Data by Meter or Facility",null,null,"* Monthly Cost Data by Meter or Facility"]
[null,"* Monthly Cost Data by Meter or Facility",null,null,"* Steam Provider Emission Factors"]
[null,"* Record of renewable energy purchased through \n   contractual instruments",null,null,"* Fuel Type Used to Generate Steam"]
[null,"Stationary Fuel Data (for each Fuel Type)",null,null,"* Boiler Efficiency"]
[null,"* Monthly Consumption Data by Meter or Facility",null,null,"Business Travel"]
[null,"* Monthly Cost Data by Meter or Facility",null,null,"* Mode of Transportation"]
[null,"Mobile Fuel Data",null,null,"* Mileage by Trip (i.e., for each leg of transport)"]
[null,"* List of Vehicles (Year, Make, Model, Fuel Type)",null,null,"Commuting"]
[null,"* Fuel Consumption by Vehicle",null,null,"* Mode of Transportation per Employee"]
[null,"* Fuel Cost by Vehicle",null,null,"* Mileage by Trip (i.e., for each leg of transport)"]
[null,"* Miles Traveled by Vehicle",null,null,"Product Transport"]
[null,"Refrigeration and AC Data",null,null,"* Mode of Transportation for each Shipment"]
[null,"* Inventory of Equipment by Facility",null,null,"* Weight of Product Transported for each Shipment"]
[null,"* Refrigerant Capacity of Equipment",null,null,"* Distance Product Transported for each Shipment"]
[null,"* Refrigerant Purchase, Inventory, and Disposal Data"]
[null,"Fire Suppression Data"]
[null,"* Inventory of Equipment by Facility"]
[null,"* Fire Suppressant Capacity of Equipment"]
[null,"* Fire Suppressant Purchase, Inventory, and Disposal Data"]
[null,"  Disposal Data"]
[]
["QUALITY ASSURANCE/QUALITY CONTROL (QA/QC) - Suggested Checks"]
["The accuracy of a GHG inventory depends on the accuracy of the activity data.  Here are a few quick checks to make sure your data are realistic.  If any of these checks lead to questions, it is best to review the data month by month to look for data points that are significantly higher or lower than other points. Checking data sources such as utility bills can confirm data entry accuracy."]
[]
[null,"Benchmarks"]
[null,"Compare your energy consumption data against typical benchmarks. "]
[null,"1. Compare your energy consumption data per square foot of floor area against the averages by building type and region in the tables below.  See below for building type definitions. "]
[null,"2. Does any facility look significantly higher or lower than these averages?  If so, can the difference be explained? "]
[]
[null,"Electricity Intensity","kWh electricity / sq ft / year"]
[null,"Principal Building Activity","Northeast","Midwest","South","West"]
[null,"Education",8.6999999999999993,10.3,12.6,10]
[null,"Food sales ",45,50.5,56.2,42.7]
[null,"Food service ",39.700000000000003,43.1,49.7,41.1]
[null,"Health care ",22,25.1,29.5,24.6]
[null,"Inpatient ",26.3,28.9,34.299999999999997,32.5]
[null,"Outpatient ",17.600000000000001,20.100000000000001,21.7,14.3]
[null,"Lodging ",14,15.4,16.600000000000001,14.1]
[null,"Mercantile ",16.3,17.5,19.7,17.600000000000001]
[null,"Retail (other than mall) ",12.8,14.1,16.3,15.8]
[null,"Enclosed and strip malls ",19.899999999999999,21.4,22.5,19.100000000000001]
[null,"Office ",17.100000000000001,15.3,16,14.9]
[null,"Public assembly ",14.1,13.2,16.3,13.2]
[null,"Public order and safety ",15.1,10.3,18.3,"insufficient data"]
[null,"Religious worship ",4.5,4.5,6.1,4.7]
[null,"Service ",6.6,7.3,9.8000000000000007,8.8000000000000007]
[null,"Warehouse and storage ",4.9000000000000004,6.6,8.4,4.8]
[null,"Other ",43.2,20.2,32,20.3]
[null,"Vacant ","insufficient data",5.3,4,5.6]
[]
[null,"Natural Gas Intensity","standard cubic feet (scf) natural gas / sq ft / year"]
[null,"Principal Building Activity","Northeast","Midwest","South","West"]
[null,"Education",46.6,38.799999999999997,16.5,27.9]
[null,"Food sales ","insufficient data","insufficient data",59.1,"insufficient data"]
[null,"Food service ",130.69999999999999,162.4,178,139.69999999999999]
[null,"Health care ",68.8,85.7,77,86]
[null,"Inpatient ",107.4,111.7,88.3,109]
[null,"Outpatient ",33.1,48,24.8,45.2]
[null,"Lodging ",43.9,49.3,33.1,56.3]
[null,"Mercantile ",40.4,43,26.1,31.4]
[null,"Retail (other than mall) ",25.1,33.9,15.1,15.2]
[null,"Enclosed and strip malls ",50.3,50.9,31.2,44.4]
[null,"Office ",34.299999999999997,33.200000000000003,17.2,22.2]
[null,"Public assembly ",42.6,40.5,26,26.7]
[null,"Public order and safety ","insufficient data","insufficient data",23.4,"insufficient data"]
[null,"Religious worship ",25.8,38.9,22.2,29.1]
[null,"Service ",64.8,38.1,44.6,35.299999999999997]
[null,"Warehouse and storage ",27.6,20.3,11.3,25.5]
[null,"Other ","insufficient data","insufficient data",41.6,74]
[null,"Vacant ","insufficient data","insufficient data","insufficient data","insufficient data"]
[]
[null,"Fuel Oil Intensity","gallons fuel oil / sq ft / year"]
[null,"Principal Building Activity","Northeast","Midwest","South","West"]
[null,"Education",0.15,0.02,0.09,"insufficient data"]
[null,"Health care ",0.15,0.02,0.02,0.02]
[null,"Office ",0.06,0.01,0.01,0.01]
[null,"All others",0.11,0.04,0.02,0.02]
[null,"See table at bottom of sheet for building type descriptions."]
[null,"Source:"]
[null,"1.  Source- EIA's 2012 Commercial Buildings Energy Consumption Survey, Table C15 (Electricity), Table C25 ( Natural Gas), Table C35 (Fuel Oil). \n     http://www.eia.gov/consumption/commercial/data/2012/index.cfm?view=consumption#c23-c32"]
[null,"2.  Building Type Definitions Source- http://www.eia.gov/consumption/commercial/building-type-definitions.cfm"]
[]
[null,"Calculated Unit Costs"]
[null,"Calculated unit costs that are out of expected ranges can indicate data entry errors.  "]
[null,"1. Use the cost and consumption data entered into your data management file to calculate the cost per unit of consumption for each month and each emissions source."]
[null,"2. Is the unit cost within expected ranges?  Is it fairly constant month to month?  Keep in mind that very low consumption (such as with heating fuel during the summer) can skew the unit cost due to fixed monthly fees.  "]
[null,"3. If the calculated unit cost is not reasonable, is there an error in either the consumption data or the cost data?"]
[]
[null,"Year Over Year Comparison"]
[null,"Compare usage data from one year to the next.  "]
[null,"1. Is there a significant change in consumption data year over year?  If so, hone in on the facilities causing the change.  "]
[null,"2. If there is a significant change, can it be explained? "]
[null,"3. If this amount is not reasonable, is there an error in either the consumption data or the data entry?  Check monthly data  \n    by facility."]
[]
[null,"Building Types"]
[]
[null,"Building Type","Description",null,null,"Examples"]
[null,"Education","Buildings used for academic or technical classroom instruction, such as elementary, middle, or high schools, and classroom buildings on college or university campuses. Buildings on education campuses for which the main use is not classroom are included in the category relating to their use. For example, administration buildings are part of \"Office,\" dormitories are \"Lodging,\" and libraries are \"Public Assembly.\"",null,null,"elementary or middle school, high school, college or university, preschool or daycare, adult education, career or vocational training, religious education"]
[null,"Food Sales","Buildings used for retail or wholesale of food.",null,null,"grocery store or food market, gas station with a convenience store, convenience store, "]
[null,"Food Service","Buildings used for preparation and sale of food and beverages for consumption.",null,null,"fast food, restaurant or cafeteria, bar, catering service or reception hall, coffee, bagel, or doughnut shop, ice cream or frozen yogurt shop"]
[null,"Health Care (Inpatient)","Buildings used as diagnostic and treatment facilities for inpatient care.",null,null,"hospital, inpatient rehabilitation"]
[null,"Health Care (Outpatient)","Buildings used as diagnostic and treatment facilities for outpatient care. Medical offices are included here if they use any type of diagnostic medical equipment (if they do not, they are categorized as an office building).",null,null,"medical office (see previous column), clinic or other outpatient health care, outpatient rehabilitation, veterinarian"]
[null,"Lodging","Buildings used to offer multiple accommodations for short-term or long-term residents, including skilled nursing and other residential care buildings.",null,null,"motel or inn, hotel, dormitory, fraternity, or sorority, retirement home, nursing home, assisted living, or other residential care, convent or monastery, shelter, orphanage, or children's home, halfway house"]
[null,"Mercantile (Retail Other Than Mall)","Buildings used for the sale and display of goods other than food.",null,null,"retail store, beer, wine, or liquor store, rental center, dealership or showroom for vehicles or boats, studio/gallery"]
[null,"Mercantile (Enclosed and Strip Malls)","Shopping malls comprised of multiple connected establishments.",null,null,"enclosed mall, strip shopping center"]
[null,"Office","Buildings used for general office space, professional office, or administrative offices. Medical offices are included here if they do not use any type of diagnostic medical equipment (if they do, they are categorized as an outpatient health care building).",null,null,"administrative or professional office, government office, mixed-use office, bank or other financial institution, medical office (see previous column), sales office, contractor's office (e.g. construction, plumbing, HVAC), non-profit or social services, city hall or city center, religious office, call center"]
[null,"Public Assembly","Buildings in which people gather for social or recreational activities, whether in private or non-private meeting halls.",null,null,"social or meeting (e.g. community center, lodge, meeting hall, convention center,senior center), recreation (e.g. gymnasium, health club, bowling alley, ice rink, field house, indoor racquet sports), entertainment or culture (e.g. museum, theater, cinema, sports arena, casino, night club), library, funeral home, student activities center, armory, exhibition hall, broadcasting studio, transportation terminal"]
[null,"Public Order and Safety","Buildings used for the preservation of law and order or public safety.",null,null,"police station, fire station, jail, reformatory, or penitentiary, courthouse or probation office"]
[null,"Religious Worship","Buildings in which people gather for religious activities, (such as chapels, churches, mosques, synagogues, and temples).",null,null,"No subcategories collected"]
[null,"Service","Buildings in which some type of service is provided, other than food service or retail sales of goods",null,null,"vehicle service or vehicle repair shop, vehicle storage/ maintenance (car barn), repair shop, dry cleaner or laundromat, post office or postal center, car wash, gas station, photo processing shop, beauty parlor or barber shop, tanning salon, copy center or printing shop, kennel"]
[null,"Warehouse and Storage","Buildings used to store goods, manufactured products, merchandise, raw materials, or personal belongings (such as self-storage).",null,null,"refrigerated warehouse, non-refrigerated warehouse, distribution or shipping center"]
[null,"Other","Buildings that are industrial or agricultural with some retail space; buildings having several different commercial activities that, together, comprise 50 percent or more of the floorspace, but whose largest single activity is agricultural, industrial/ manufacturing, or residential; and all other miscellaneous buildings that do not fit into any other category.",null,null,"airplane hangar, crematorium, laboratory, telephone switching, agricultural with some retail space, manufacturing or industrial with some retail space, data center or server farm"]
[null,"Vacant","Buildings in which more floorspace was vacant than was used for any single commercial activity at the time of interview. Therefore, a vacant building may have some occupied floorspace.",null,null,"No subcategories collected, but a question was asked to determine whether the building was completely vacant."]

{"sheet":"Help - Stationary Combustion","index":21,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[5,0,5,5],[8,0,8,5],[14,0,14,5],[18,1,18,5],[10,1,10,5],[43,1,43,5],[11,1,11,5],[21,1,21,5],[23,2,23,5],[19,1,19,5],[20,1,20,5]]}
[]
[]
["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 34.3 to get an estimation of 34,300 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",46.6,38.799999999999997,16.5,27.9]
[null,"Food sales ","insufficient data","insufficient data",59.1,"insufficient data"]
[null,"Food service ",130.69999999999999,162.4,178,139.69999999999999]
[null,"Health care ",68.8,85.7,77,86]
[null,"Inpatient ",107.4,111.7,88.3,109]
[null,"Outpatient ",33.1,48,24.8,45.2]
[null,"Lodging ",43.9,49.3,33.1,56.3]
[null,"Mercantile ",40.4,43,26.1,31.4]
[null,"Retail (other than mall) ",25.1,33.9,15.1,15.2]
[null,"Enclosed and strip malls ",50.3,50.9,31.2,44.4]
[null,"Office ",34.299999999999997,33.200000000000003,17.2,22.2]
[null,"Public assembly ",42.6,40.5,26,26.7]
[null,"Public order and safety ","insufficient data","insufficient data",23.4,"insufficient data"]
[null,"Religious worship ",25.8,38.9,22.2,29.1]
[null,"Service ",64.8,38.1,44.6,35.299999999999997]
[null,"Warehouse and storage ",27.6,20.3,11.3,25.5]
[null,"Other ","insufficient data","insufficient data",41.6,74]
[null,"Vacant ","insufficient data","insufficient data","insufficient data","insufficient data"]
[null,"Source: EIA's Commercial Buildings Energy Consumption Survey (CBECS) 2012, Released May 2016.  Table C25: Natural gas consumption and conditional energy intensity by Census region"]
[null,"http://www.eia.gov/consumption/commercial/data/2012/index.cfm?view=consumption#c23-c32"]

{"sheet":"Help - Mobile Sources","index":22,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,30,4],[28,1,28,4],[29,1,29,4],[5,0,5,4],[8,0,8,4],[17,0,17,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[24,1,24,4]]}
[]
[]
["Scope 1 Emissions from Mobile Sources - HELP SHEET"]
[]
["DEFINITION"]
["Mobile sources, like owned or leased cars and heavy duty vehicles generate emissions by burning fuel.  The fuel usage for any vehicle that is under the organization's operational control should be reported here as scope 1 emissions. "]
[]
["COLLECT"]
["Determine the types of vehicles, types and amount of fuel, and the miles driven for each vehicle or vehicle type.  Data sources vary but fuel usage is often determined from fuel receipts or purchase records and provided in gallons, and mileage from vehicle records.  Mileage or fuel use can also be estimated based on vehicle fuel economy from the manufacturer or www.fueleconomy.gov if the other data sources are not readily available. "]
["www.fueleconomy.gov"]
[]
["Data Collection Checklist (for all vehicles)"]
["-","Type and year of vehicle"]
["-","Amount of fuel consumed for the inventory reporting period"]
["-","Total miles driven for the inventory reporting period"]
[]
["QUANTIFY"]
["Enter the data into the appropriate orange colored boxes of the Calculator section titled “Mobile Sources.”  If the organization owns or leases biofuel or ethanol vehicles, the percentage of biologically-based fuel should be entered into the boxes provided; default values are available if needed.  Once the data are entered into the Calculator, the CO2 equivalent emissions are calculated and summarized in the blue colored box.  Biomass CO2 emissions are calculated and summarized in the green colored box, and are typically not summed into the organization’s total GHG emissions because they are considered to be a net zero emission source."]
[null,"Vehicle Classification Guidelines"]
[null,"Pickups, Vans, and SUVs should be classified as \"Light Trucks\""]
[null,"Trucks weighing more than 8,500 lb should be classified as \"Heavy- Duty Trucks\""]
[null,"Non-highway vehicles should be classified as \"Construction Equip.\""]
[]
["Items to Note"]
["-","Vehicle Classification Guidelines"]
[null,"Trucks weighing more than 8,500 lb should be classified as \"Heavy- Duty Vehicles\""]
[null,"Pickup trucks, vans, and SUVs should be classified as \"Light-Duty Trucks\""]
[null,"Non-highway vehicles should be classified as \"Construction Equip.\""]
["-","Fuel usage and mileage is reported the same for hybrid vehicles as for conventional vehicles.  If you are estimating mileage or fuel usage keep in mind the fuel efficiency."]
["-","If your organization owns a private jet or plane it should be included here.  Depending on the fuel it uses, pick the appropriate type from the drop down menu (i.e., Aviation Gasoline Aircraft, Jet Fuel Aircraft)."]
["-","If you are using biodiesel or ethanol, the percentage of biodiesel and ethanol should be filled out accordingly.  If you are using these fuels in pure form, then you would enter 100%.  If you are using a mixture of biodiesel and petroleum diesel, or a mixture of ethanol and gasoline then you would enter the biodiesel or ethanol percentage in that mixture.  For example,  B100 is 100% biodiesel, likewise B20 is 20% biodiesel.  This is similar for ethanol; E85 is 85% ethanol. "]

{"sheet":"Help - Refrigeration and AC","index":23,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,1,27,4],[25,1,25,4],[20,1,20,4],[13,1,13,4],[14,1,14,4],[23,1,23,4],[24,1,24,4],[5,0,5,4],[8,0,8,4],[17,0,17,4],[18,1,18,4],[19,1,19,4],[10,1,10,4],[11,1,11,4],[12,1,12,4]]}
[]
[]
["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":24,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,1,19,4],[5,0,5,4],[8,0,8,4],[16,0,16,4],[10,1,10,4],[13,1,13,4],[11,1,11,4],[12,1,12,4]]}
[]
[]
["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":25,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,1,19,4],[5,0,5,4],[8,0,8,4],[16,0,16,4],[11,1,11,4],[12,1,12,4],[13,1,13,4]]}
[]
[]
["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 - Waste Gases","index":26,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[[5,0,5,4],[8,0,8,4],[15,0,15,4],[10,1,10,4],[12,1,12,4],[11,1,11,4]]}
[]
[]
["Scope 1 Emissions from Combustion of Waste Gases - HELP SHEET"]
[]
["DEFINITION"]
["Some operations, such as printing operations or paint booths, emit organic compounds.  In some cases these waste gas streams are combusted with a flare or thermal oxidizer.  This combustion results in CO2 emissions that should be included in GHG inventories.  These are uncommon sources for most office-based organizations."]
[]
["COLLECT"]
["Collect information about the volume of waste gas that was combusted.  Because of the variable composition of waste gas streams, the user will also need to find out what chemicals are present in the waste gas stream, and the quantity of each chemical.   Please note that two other data needs, oxidation factor and gas density, should be also collected if practicable; however, default values can be used if needed.  The oxidation factor accounts for the amount of carbon in the fuel that is converted to CO2 during combustion. "]
["Data Collection Checklist (for all applicable facilities)"]
["-","Type of waste gases combusted"]
["-","Amount of each waste gas combusted"]
["-","Gas components"]
[]
["QUANTIFY"]
["Enter the data into the appropriate orange colored boxes of the Calculator section titled “Waste Gases.”  Once the data are entered into the Calculator, the CO2 equivalent emissions are calculated and summarized in the blue colored box. "]

{"sheet":"Help - Electricity","index":27,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":false,"merged":[[10,1,10,5],[5,0,5,5],[8,0,8,5],[15,0,15,5],[21,1,21,5],[46,1,46,5],[24,1,24,5],[26,2,26,5],[23,1,23,5],[11,1,11,5],[12,1,12,5],[16,0,16,5],[17,0,17,5],[22,1,22,5]]}
[]
[]
["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",8.6999999999999993,10.3,12.6,10]
[null,"Food sales ",45,50.5,56.2,42.7]
[null,"Food service ",39.700000000000003,43.1,49.7,41.1]
[null,"Health care ",22,25.1,29.5,24.6]
[null,"Inpatient ",26.3,28.9,34.299999999999997,32.5]
[null,"Outpatient ",17.600000000000001,20.100000000000001,21.7,14.3]
[null,"Lodging ",14,15.4,16.600000000000001,14.1]
[null,"Mercantile ",16.3,17.5,19.7,17.600000000000001]
[null,"Retail (other than mall) ",12.8,14.1,16.3,15.8]
[null,"Enclosed and strip malls ",19.899999999999999,21.4,22.5,19.100000000000001]
[null,"Office ",17.100000000000001,15.3,16,14.9]
[null,"Public assembly ",14.1,13.2,16.3,13.2]
[null,"Public order and safety ",15.1,10.3,18.3,"insufficient data"]
[null,"Religious worship ",4.5,4.5,6.1,4.7]
[null,"Service ",6.6,7.3,9.8000000000000007,8.8000000000000007]
[null,"Warehouse and storage ",4.9000000000000004,6.6,8.4,4.8]
[null,"Other ",43.2,20.2,32,20.3]
[null,"Vacant ","insufficient data",5.3,4,5.6]
[null,"Source: Commercial Buildings Energy Consumption Survey (CBECS) 2012, Released May 2016.  Table C15: Electricity consumption and conditional energy intensity by Census region"]
[null,"http://www.eia.gov/consumption/commercial/data/2012/index.cfm?view=consumption#c23-c32"]
[]
["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 - Market-Based Method","index":28,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[11,1,11,2],[16,9,16,10],[17,0,17,8],[11,3,11,8],[100,0,100,1],[18,0,18,8],[15,0,15,8],[15,9,15,10],[16,0,16,8],[19,0,19,8],[37,5,37,7],[36,5,36,7],[17,9,17,10],[2,0,2,7],[85,0,85,1],[86,0,86,1],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[23,1,23,8],[26,0,26,8],[5,0,5,8],[6,3,6,8],[7,3,7,8],[8,3,8,8],[9,3,9,8],[10,3,10,8],[10,1,10,2]]}
[]
[]
["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 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."]
[]
[null,null,null,null,null,"Market-Based\nUse these cells to enter contractual or supplier specific emission factors"]
["Table 1.  Total Amount of Electricity Purchased by eGRID Subregion",null,null,null,null,"Emission Factors"]
["Source","Source","Source","eGRID Subregion","Electricity","CO2","CH4 ","N2O "]
["ID","Description","Area (sq ft)","where electricity is consumed","Purchased","Emissions","Emissions","Emissions"]
[null,null,null,null,"(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":29,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[5,6,5,11],[10,1,10,4],[11,1,11,4],[12,1,12,4],[19,1,19,5],[18,1,18,4],[5,0,5,4],[8,0,8,4],[15,0,15,4]]}
[]
[]
["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 - Business Travel","index":30,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,0,5,4],[8,0,8,4],[14,0,14,4],[10,1,10,4],[11,1,11,4]]}
[]
[]
["Scope 3 Emissions from Employee Business Travel - HELP SHEET"]
[]
["DEFINITION"]
["Scope 3 employee business travel emissions differ from the scope 1 mobile source emission reporting in that they account for employee business travel in vehicles not owned or leased by the organization, such as taxis, trains, commercial airplanes, and personal vehicles used for sales. "]
[]
["COLLECT"]
["Collect information about employees’ business travel method. Travel by vehicle-miles is used when the employee is traveling in a personal vehicle.  Travel by passenger-mile is used when the employee is traveling in a vehicle shared with many other people (i.e., bus, train or plane).  For travelers that use a personal vehicle, choose the vehicle type from the Calculator and collect data for the vehicle miles during the reporting period.  For rail, bus, and air travel, the mode of travel should be selected from the Calculator options and an estimate of the passenger mileage data provided for each."]
["Data Collection Checklist (for all employee travel)"]
["-","Type of transport (personal vehicle, train, bus, plane)"]
["-","Miles traveled for each transport type.  For air travel, mileage should ideally be determined considering each flight segment individually.  If you use a travel agent, they may have these data in their records."]
[]
["QUANTIFY"]
["Enter the data into the appropriate orange colored boxes (Tables 1-3) of the Calculator section titled “Business Travel.”  Once the data are entered into the Calculator, the CO2 equivalent emissions are calculated and summarized in the green colored box.  "]

{"sheet":"Help - Commuting","index":31,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,1,18,4],[19,1,19,4],[20,1,20,4],[5,0,5,4],[8,0,8,4],[15,0,15,4],[10,1,10,4],[12,1,12,4],[11,1,11,4]]}
[]
[]
["Scope 3 Emissions from Employee Commuting - HELP SHEET"]
[]
["DEFINITION"]
["Employee commuting emissions differ from the required mobile source emission reporting in that they account for employee travel to and from work in vehicles not owned or leased by the organization, including personal vehicles, buses, and trains.  "]
[]
["COLLECT"]
["Collect information about each employee’s commuting method.  If not all employees can provide information on their commuting habits, you can calculate an average per employee and multiply by total employees to estimate. For commuters that use a personal vehicle, the appropriate vehicle type should be selected from the Calculator and data collected for the vehicle-miles during the reporting period.  For rail, bus, and air travel, the mode of transport should be selected from the Calculator options and an estimate of the passenger mileage data provided for each."]
["Data Collection Checklist (per Employee)"]
["-","Commuting days per year (consider vacation, sick time and business travel)"]
["-","Mode of transport (this may be multiple modes of transport)"]
["-","Round trip mileage"]
[]
["QUANTIFY"]
["After the data has been collected, enter the data into the appropriate orange colored boxes (Tables 1-2) of the Calculator section titled “Commuting.”  Once the data are entered into the Calculator, the CO2 equivalent emissions are calculated and summarized in the green colored box."]
[]
["Items to Note"]
["-","Commuting by vehicle-miles is used when the employee is traveling in their own vehicle.  Travel by passenger-mile is used when the employee is traveling in a vehicle shared with many other people (i.e., bus, train or plane).  "]
["-","If employees carpool, only their portion of the mileage should be included in the GHG inventory.  For example, if one of your employees drives 10 miles alone to meet two other people (not employees) to carpool and then drives 30 miles to work then the organization should include 20 miles (10 miles + 30 (1/3)) in the corporate inventory.  "]
["-","If collecting data from all your employees is not possible due to the size of your organization, you may collect data from as many employees as possible, and use that sample to estimate for the rest of the employees.  Make sure the sample size is adequate, and keep in mind this will calculate less accurate results. "]

{"sheet":"Help - Product Transport","index":32,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,1,18,4],[20,1,20,4],[5,0,5,4],[8,0,8,4],[15,0,15,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[19,1,19,4]]}
[]
[]
["Scope 3 Emissions from Product Transport - HELP SHEET"]
[]
["DEFINITION"]
["Scope 3 emissions from product transport include product and material shipments by vehicles not owned or leased by the organization.  For example, the organization could hire another company to transport product from the manufacturing location to distribution centers or final markets. (Note:  if an organization owns or leases the trucks or other transport vehicles, these would be part of its scope 1 mobile source emissions). Another example of product transport is paying a courier to transport documents from one office to another.  "]
[]
["COLLECT"]
["Collect information about shipment methods (on-road vehicle, waterborne craft, freight rail, or aircraft).  For road shipments the user may enter data based on vehicle mileage or ton-miles of product transported.  If the vehicle mileage option is chosen, then the organization should select the type of vehicle and enter the total mileage for that vehicle type.  The ton-miles option is only applicable for heavy-duty trucks and the organization need only enter the total ton-miles traveled.  For product transport via freight rail, waterborne, or air transport, the organization should enter the total ton-miles data."]
["Data Collection Checklist"]
["-","All product transport legs (origin and destination) and mileage"]
["-","Mode of transport per leg"]
["-","Weight transported per shipment for ton-mile calculation"]
[]
["QUANTIFY"]
["Enter the data into the appropriate orange colored boxes (Tables 1-2) of the Calculator section titled “Product Transport.”  Once the data are entered into the Calculator, the CO2 equivalent emissions are calculated and summarized in the green colored box. "]
[]
["Items to Note"]
["-","To calculate ton-miles, multiply the weight transported (short tons) by the distance (miles) for each shipment.  In Table 2, you can enter data either for individual shipments, or for the sum of ton-miles for multiple shipments."]
["-","If you do not have shipment-by-shipment data, you may multiply total tons transported by the average miles per shipment.  You may also multiply average tons transported per shipment times the total miles transported.  Do not multiply total tons by total miles, as this will give an incorrect result. "]
["-","Example: Every week a company ships 10 short tons of product 100 miles.  That equates to 52 shipments per year of 1,000 ton-miles each.  The sum of the individual shipments is 52,000 ton-miles per year.  Multiplying the total tons transported (520 tons) by the average miles per shipment (100 miles) provides the correct result of 52,000 ton-miles.  Multiplying the average tons transported per shipment (10 tons) times the total miles (5,200 miles) also gives the correct result.  Multiplying total tons (520 tons) by total miles (5,200 miles) gives an incorrect result. "]

{"sheet":"Help - Offsets","index":33,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,0,5,4],[8,0,8,4],[11,0,11,4]]}
[]
[]
["Purchased Offsets - HELP SHEET"]
[]
["DEFINITION"]
["Offsets are project-based emission reductions and/or removals that occur outside the organizational boundary of the reporting organization.  Offsets can be purchased by an organization to offset emissions from scope 1, scope 2, and scope 3 sources."]
[]
["COLLECT"]
["Quantity of offsets purchased in metric tons CO2 equivalent for each offset project."]
[]
["QUANTIFY"]
["Enter the data into the appropriate orange colored boxes (Table 1) of the Calculator section titled \"Offsets.”  Once the data are entered into the Calculator, the CO2 equivalent emissions are summarized in the green colored box."]