{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Product Transport","Prod Transport Emission Factor","DropDown","Help - Product Transport"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":88,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Product Transport","index":0,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[10,0,10,1],[11,0,11,1],[12,0,12,1],[9,0,9,1]]}
["Table 2.  Product Transport by Ton-Miles (CO2, CH4 and N2O)"]
["Vehicle Type","Ton-Miles ","CO2 Emissions (kg)","CH4 Emissions (g)","N2O Emissions (g)"]
["Medium- and Heavy-Duty Truck",100,{"$f":"IF($A3=\"\",\"\",VLOOKUP(A3,'Prod Transport Emission Factor'!A7:E9,2,FALSE)*$B3)","v":20.233797801439316},{"$f":"IF($A3=\"\",\"\",VLOOKUP(A3,'Prod Transport Emission Factor'!A7:E9,3,FALSE)*$B3)","v":0.20038423175478401},{"$f":"IF($A3=\"\",\"\",VLOOKUP(A3,'Prod Transport Emission Factor'!A7:E9,4,FALSE)*$B3)","v":0.15129681927794095}]
["Rail",100,{"$f":"IF($A4=\"\",\"\",VLOOKUP(A4,'Prod Transport Emission Factor'!A8:E10,2,FALSE)*$B4)","v":2.2999999999999998},{"$f":"IF($A4=\"\",\"\",VLOOKUP(A4,'Prod Transport Emission Factor'!A8:E10,3,FALSE)*$B4)","v":0.18},{"$f":"IF($A4=\"\",\"\",VLOOKUP(A4,'Prod Transport Emission Factor'!A8:E10,4,FALSE)*$B4)","v":0.06}]
["Waterborne Craft",100,{"$f":"IF($A5=\"\",\"\",VLOOKUP(A5,'Prod Transport Emission Factor'!A9:E11,2,FALSE)*$B5)","v":5.8999999999999995},{"$f":"IF($A5=\"\",\"\",VLOOKUP(A5,'Prod Transport Emission Factor'!A9:E11,3,FALSE)*$B5)","v":0.05},{"$f":"IF($A5=\"\",\"\",VLOOKUP(A5,'Prod Transport Emission Factor'!A9:E11,4,FALSE)*$B5)","v":0.4}]
[]
["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($A$3:$A$5,$A11,C$3:C$5)","v":20.233797801439316},0.20038423175478401,0.15129681927794095]
["Rail",null,2.2999999999999998,0.18,0.06]
["Waterborne Craft",null,5.8999999999999995,0.05,0.4]
[]
[]
["Total CO2 Equivalent Emissions  (metric tons) - Product Transport",null,null,{"$f":"(SUM(C11:C13)+SUM(D11:D13)/1000*'Prod Transport Emission Factor'!B17+SUM(E11:E13)/1000*'Prod Transport Emission Factor'!B18)/1000","v":2.8626723859378009E-2}]

{"sheet":"Prod Transport Emission Factor","index":1,"n_rows":49,"n_cols":256,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,0,48,9],[10,0,10,9],[12,0,12,9]]}
["Tool Sheet: Emission Factors"]
[]
["All emission factors sourced from EPA's Emission Factors Hub, March 2018."]
["https://www.epa.gov/climateleadership/center-corporate-climate-leadership-ghg-emission-factors-hub"]
["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",0.20233797801439316,2.0038423175478401E-3,1.5129681927794096E-3,"ton-mile"]
["Rail",2.3E-2,1.8E-3,5.9999999999999995E-4,"ton-mile"]
["Waterborne Craft",5.8999999999999997E-2,5.0000000000000001E-4,4.0000000000000001E-3,"ton-mile"]
["Source:"]
["CO2, CH4, and N2O emissions data for road vehicles are from Table 2-13 of the U.S. Greenhouse Gas Emissions and Sinks: 1990–2015 (April 15, 2017).  Vehicle-miles and passenger-miles data for road vehicles are from Table VM-1 of the Federal Highway Administration Highway Statistics 2015.  \nCO2e emissions data for non-road vehicles are based on Table A-117 of the U.S. Greenhouse Gas Emissions and Sinks: 1990–2015, 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 2015 (Data based on 2014)."]
["Notes:"]
["Vehicle-mile factors are appropriate to use when the entire vehicle is dedicated to transporting the reporting organization's product.  Ton-mile factors are appropriate when the vehicle is shared with products from other organizations.  \nPassenger car: includes passenger cars, minivans, SUVs, and small pickup trucks (vehicles with wheelbase less than 121 inches).  \nLight-duty truck: includes full-size pickup trucks, full-size vans, and extended-length SUVs (vehicles with wheelbase greater than 121 inches).\nMedium- and Heavy-Duty Truck: updates due to a methodology change.\n"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(B23:IU23)","v":1100}]
["HFC-134a",1430]
["HFC-143",353]
["HFC-143a",4470]
["HFC-152",53]
["HFC-152a",124]
["HFC-161",12]
["HFC-227ea",3220]
["HFC-236cb",1340]
["HFC-236ea",1370]
["HFC-236fa",9810]
["HFC-245ca",693]
["HFC-245fa",1030]
["HFC-365mfc",794]
["HFC-43-10mee",1640]
["SF6 ",22800]
["NF3",17200]
["CF4",7390]
["C2F6 ",12200]
["C3F8",8830]
["c-C4F8",10300]
["C4F10",8860]
["C5F12",9160]
["C6F14",9300]
["C10F18",">7,500"]
["Source:"]
["100-year GWPs from IPCC Fourth Assessment Report (AR4), 2007.  IPCC AR4 was published in 2007 and is among the most current and comprehensive peer-reviewed assessments of climate change. AR4 provides revised GWPs of several GHGs relative to the values provided in previous assessment reports, following advances in scientific knowledge on the radiative efficiencies and atmospheric lifetimes of these GHGs and of CO2. Because the GWPs provided in AR4 reflect an improved scientific understanding of the radiative effects of these gases in the atmosphere, the values provided are more appropriate for supporting the overall goal of organizational GHG reporting than the Second Assessment Report (SAR) GWP values previously used in the Emission Factors Hub. \nWhile EPA recognizes that Fifth Assessment Report (AR5) GWPs have been published, in an effort to ensure consistency and comparability of GHG data between EPA’s voluntary and non-voluntary GHG reporting programs (e.g. GHG Reporting Program and National Inventory), EPA recommends the use of AR4 GWPs. The United States and other developed countries to the UNFCCC have agreed to submit annual inventories in 2015 and future years to the UNFCCC using GWP values from AR4, which will replace the current use of SAR GWP values.  Utilizing AR4 GWPs improves EPA’s ability to analyze corporate, national, and sub-national GHG data consistently, enhances communication of GHG information between programs, and gives outside stakeholders a consistent, predictable set of GWPs to avoid confusion and additional burden."]

{"sheet":"DropDown","index":2,"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":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}},"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":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}},"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":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}},"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":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}},"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":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}},"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":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}},"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":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}},"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":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}},"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":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}},"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":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}},"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":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}},"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":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}},"Petroleum Coke"]
["Offsets","Help - Market-Based Method",null,"Diesel Medium- and Heavy-Duty Vehicles",null,"R-401B",null,null,"CF4",{"$f":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}},"Wood and Wood Residuals"]
[null,"Help - Offsets",null,"Diesel Passenger Cars",null,"R-401C",null,null,"C2F6 ",{"$f":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}},"Landfill Gas"]
[null,null,null,"Diesel Ships and Boats",null,"R-402A",null,null,"C3F8",{"$f":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"Ethanol Buses",null,"R-402B",null,null,"C4F10",{"$f":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"Ethanol Light-Duty Vehicles",null,"R-403B",null,null,"c-C4F8",{"$f":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"Ethanol Medium- and Heavy-Duty Vehicles",null,"R-404A",null,null,"C5F12",{"$f":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"Gasoline Agricultural Equip.",null,"R-406A",null,null,"C6F14",{"$f":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"Gasoline Construction Equip.",null,"R-407A",null,null,"R-401A",{"$f":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"Gasoline Heavy-Duty Vehicles",null,"R-407B",null,null,"R-401B",{"$f":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"Gasoline Light-Duty Trucks",null,"R-407C",null,null,"R-401C",{"$f":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"Gasoline Motorcycles",null,"R-407D",null,null,"R-402A",{"$f":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"Gasoline Passenger Cars",null,"R-407E",null,null,"R-402B",{"$f":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"Gasoline Ships and Boats",null,"R-408A",null,null,"R-403B",{"$f":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"Jet Fuel Aircraft",null,"R-409A",null,null,"R-404A",{"$f":"'Prod Transport Emission Factor'!#REF!","v":{"$error":"#REF!"}}]
[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 - Product Transport","index":3,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,1,16,4],[17,1,17,4],[18,1,18,4],[3,0,3,4],[6,0,6,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[13,0,13,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).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. "]