{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Readme","Forklift_Tool_Calculations","Background Table"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Readme","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[[6,1,52,24]]}
[]
[]
[]
[]
[]
[]
[null,"Disclaimer - This tool is intended to provide educational guidance for total cost of ownership and emissions comparsions of Propane and Battery Electric Forklifts. This tool is for informational and educational purposes only. Data has been collected from the real world industry to represent costs and emissions as accurately as possible. Please reach out to satish.guda@propane.com for any inputs or suggestions.\n\nInstructions for Usage of the tool\n\n1) All the inputs are user defined inputs. Users can enter custom values in the value column.\n2) Please enter the costs of propane and electric forklift just by the truck price alone in USD. (S.No 1 & 2)\nNote - Cost of one battery and one charger will be automatically added in calculations.\n3) Enter cost of the propane gallon in USD. Typically, this is based on whole sale value with a marketer. (S.No 3)\nNote - Onroad autogas price is different than offroad price of propane.\n4) Enter forklift propane consumption in gallons per hour (S.No 4)\n5) Enter forklift electrical energy consumption in kWh per hour (S.No 5)\n5) Enter the cost of electricity based on your location in USD (S.No 6)\n6) Select the type of forklift battery - Lead Acid or Lithium Ion from the drop down list. \nNote - Costs and emissions will vary based on this selection. (S.No 7)\n7) Enter the annual hours of operation of the forklift. (S.No 8)\n8) Select the state of operation for the propane forklift only from the drop down list. (S.No 9)\nNote - Propane's carbon intensity varies by PADD region and the states that fall under that region. \n9) Select the Independent System Operator (ISO) for the location of operation of the electric forklift. (S.No 10)\nNote - Emissions from electric forklift operation will vary by ISO supplying the electricity. \n10) Enter the Carbon Intensity of Renewable Propane by the feedstock source. (S. No 11)\nNote - Carbon intensity of renewable propane varies by feedstock.\n11) Entering Blend percentages by Weight:\na) To choose conventional propane alone, enter 100 in S.No 12 Default Value Cell\nb) To choose renewable propane alone, enter 100 in S.No 13 Default Value Cell\nc) To choose  renewable Dimethyl ether (DME) alone, enter 100 in S.No 14 Default Value Cell\nd) To choose a combination of all conventional propane, renewable propane and renewable DME, enter values in S.No 12, 13 and 14 such that value totals up to 100. \nNote - Blend percentages are by weight basis and not volume basis.\n12) Units have been provided for each of the input values for guidance.\n13) The output cost and emissions tables update themselves automatically by the inputs and selection of states and ISOs"]

{"sheet":"Forklift_Tool_Calculations","index":1,"n_rows":96,"n_cols":6,"rows_kept":96,"cut":false,"hidden":false,"merged":[[43,4,43,5],[44,4,44,5],[22,4,22,5],[23,4,23,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[26,1,28,5],[42,4,42,5],[71,1,71,5],[95,1,95,5],[13,4,13,5],[14,4,14,5],[6,1,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[18,4,18,5],[37,1,39,5],[40,4,40,5],[41,4,41,5],[15,4,15,5],[16,4,16,5],[17,4,17,5]]}
[]
[]
[]
[]
[]
[]
[null,"User Defined Inputs"]
[]
[]
[null,"S.No","Parameter","Unit"," Value"]
[null,1,"Cost of Propane Forklift","$",30000]
[null,2,"Cost of Electric Forklift","$",40000]
[null,3,"Cost of Propane Gallon","$/gal",2.5]
[null,4,"Propane Consumption per hour","gal/hr",1.056]
[null,5,"Energy Consumption per hour","kWh/hr",7.35]
[null,6,"Cost of Electricity","$/kWh",0.11]
[null,7,"Type of Battery","-","Lithium Ion"]
[null,8,"Annual Hours of Operation","hr",1700]
[null,9,"State of Operation","-","Arizona"]
[null,10,"ISO for Electricity","-","Arizona Public Service Company"]
[null,11,"Carbon Intensity of Renewable Propane","gCO2eq/MJ",43.5]
[null,12,"Wt. percentage of Conventional Propane in blend","%",100]
[null,13,"Wt. percentage of Renewable Propane in blend","%",0]
[null,14,"Wt. percentage of Renewable DME in blend","%",0]
[]
[]
[null,"Output - Total Cost of Ownership of Forklift by Energy Source"]
[]
[]
[null,"S.No","Cost Category","Unit","Propane",{"$f":"'Background Table'!C308","v":"Lithium Ion Battery"}]
[null,1,"Acquisition Cost","$",{"$f":"'Background Table'!E99","v":30000},{"$f":"'Background Table'!F99","v":53500}]
[null,2,"Operating Cost","$",{"$f":"'Background Table'!E100","v":7147},{"$f":"'Background Table'!F100","v":2979.95}]
[null,3,"Maintenance Cost","$",{"$f":"'Background Table'!E101","v":1455},{"$f":"'Background Table'!F101","v":1700}]
[null,4,"Infrastructure Cost","$",{"$f":"'Background Table'!E102","v":3595},{"$f":"'Background Table'!F102","v":29000}]
[null,null,"Total Cost","$",{"$f":"'Background Table'!E103","v":42197},{"$f":"'Background Table'!F103","v":87179.95}]
[]
[]
[null,"Output - Carbon Footprint Emissions of Forklift by Energy Source"]
[]
[]
[null,"S.No","Energy Source of Forklift","Unit","Value "]
[null,1,"Conventional Propane","MT CO2eq",{"$f":"'Background Table'!E294","v":12.987768356352767}]
[null,2,"Renewable Propane","MT CO2eq",{"$f":"'Background Table'!E295","v":6.9991070800463993}]
[null,3,{"$f":"'Background Table'!C312","v":"100% Conventional Propane, 0% Renewable Propane, 0% Renewable DME Blend"},"MT CO2eq",{"$f":"'Background Table'!E296","v":12.987768356352767}]
[null,4,{"$f":"'Background Table'!C308","v":"Lithium Ion Battery"},"MT CO2eq",{"$f":"'Background Table'!E297","v":12.841602486089718}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Figure 1 - Total Cost of Ownership of Forklift by Energy Source (Annual Operation)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Figure 2 - Carbon Footprint Emissions of Forklift by Energy Source (Annual Operation)"]

{"sheet":"Background Table","index":2,"n_rows":312,"n_cols":13,"rows_kept":312,"cut":false,"hidden":true,"merged":[[304,9,315,9],[296,4,296,5],[271,1,273,6],[289,1,291,5],[292,4,292,5],[293,4,293,5],[294,4,294,5],[295,4,295,5],[84,12,89,12],[96,9,101,9],[108,1,110,5],[126,9,131,9],[187,9,195,9],[1,1,3,7],[64,1,66,7],[82,1,84,9],[282,9,293,9],[213,9,224,9],[180,1,182,6],[204,1,206,5],[94,1,96,5],[6,9,11,9],[33,9,38,9],[67,9,72,9],[166,1,168,5],[22,1,24,7]]}
[]
[null,"User Defined Inputs"]
[]
[]
[null,"S.No","Parameter","Unit","Value","Variable Using Entity","Type","Variable Code Name"]
[null,1,"Cost of Propane Forklift","$",{"$f":"Forklift_Tool_Calculations!E11","v":30000},"Propane Forklift","Numeric field entry","u1"]
[null,2,"Cost of Electric Forklift","$",{"$f":"Forklift_Tool_Calculations!E12","v":40000},"Electric Forklift","Numeric field entry","u2",null,"Selected Inputs Table"]
[null,3,"Cost of Propane Gallon","$/gal",{"$f":"Forklift_Tool_Calculations!E13","v":2.5},"Propane Forklift","Numeric field entry","u3"]
[null,4,"Propane Consumption per hour","gal/hr",{"$f":"Forklift_Tool_Calculations!E14","v":1.056},"Propane Forklift","Numeric field entry","u4"]
[null,5,"Energy Consumption per hour","kWh/hr",{"$f":"Forklift_Tool_Calculations!E15","v":7.35},"Electric Forklift","Numeric field entry","u5"]
[null,6,"Cost of Electricity","$/kWh",{"$f":"Forklift_Tool_Calculations!E16","v":0.11},"Electric Forklift","Numeric field entry","u6"]
[null,7,"Type of Battery","-",{"$f":"Forklift_Tool_Calculations!E17","v":"Lithium Ion"},"Electric Forklift","Drop down selection","u7"]
[null,8,"Annual Hours of operation","hr",{"$f":"Forklift_Tool_Calculations!E18","v":1700},"Both Propane & Electric Forklfits","Numeric field entry","u8"]
[null,9,"State of Operation","-",{"$f":"Forklift_Tool_Calculations!E19","v":"Arizona"},"Propane Forklift","Drop down selection","u9a"]
[null,10,"ISO for Electricity","-",{"$f":"Forklift_Tool_Calculations!E20","v":"Arizona Public Service Company"},"Both Propane & Electric Forklfits","Drop down selection","u9b"]
[null,11,"Carbon Intensity of Renewable Propane","gCO2eq/MJ",{"$f":"Forklift_Tool_Calculations!E21","v":43.5},"Propane Forklift","Numeric field entry","u10"]
[null,12,"Wt. percentage of Conventional Propane in blend","%",{"$f":"Forklift_Tool_Calculations!E22","v":100},"Propane Forklift","Numeric field entry","u11"]
[null,13,"Wt. percentage of Renewable Propane in blend","%",{"$f":"Forklift_Tool_Calculations!E23","v":0},"Propane Forklift","Numeric field entry","u12"]
[null,14,"Wt. percentage of Renewable DME in blend","%",{"$f":"Forklift_Tool_Calculations!E24","v":0},"Propane Forklift","Numeric field entry","u13"]
[]
[]
[]
[null,"Background Constants"]
[]
[]
[null,"S.No","Parameter","Unit","Default Value","Variable Using Entity","Type","Variable Code Name"]
[null,1,"Cost for Individual Propane Forklift Cylinder","$",275,"Propane Forklift","Hard code ","ibv1"]
[null,2,"Cost of Lead Acid Battery","$",4000,"Electric Forklift","Hard code ","ibv2"]
[null,3,"Cost of Lithium Ion Battery","$",10000,"Electric Forklift","Hard code ","ibv3"]
[null,4,"Industrial space rent per square foot","$",8,"Both Propane & Electric Forklfits","Hard code ","ibv4"]
[null,5,"Interior Space for Cylinder Storage","sqft",20,"Propane Forklift","Hard code ","ibv5"]
[null,6,"Interior Space for Battery Storage and charging","sqft",200,"Electric Forklift","Hard code ","ibv6"]
[null,7,"Exterior Space for Cylinder Storage","sqft",20,"Propane Forklift","Hard code ","ibv7"]
[null,8,"Exterior Space for Battery Storage and charging","sqft",0,"Electric Forklift","Hard code ","ibv8",null,"Background Cost Constants Table"]
[null,9,"Exchange Tanks","$",73,"Propane Forklift","Hard code ","ibv9"]
[null,10,"Cylinder or Tank Fixtures","$",0,"Propane Forklift","Hard code ","ibv10"]
[null,11,"Additional Battery - Lead Acid","$",4000,"Electric Forklift","Hard code ","ibv11"]
[null,12,"Additional Battery - Lithium Ion","$",10000,"Electric Forklift","Hard code ","ibv12"]
[null,13,"Battery Storage or Charging Fixtures","$",2500,"Electric Forklift","Hard code ","ibv13"]
[null,14,"Battery Extractor","$",1000,"Electric Forklift","Hard code ","ibv14"]
[null,15,"Emergency Wash Station and Watering Equipment for Propane Forklift","$",3000,"Propane Forklift","Hard code ","ibv15"]
[null,16,"Emergency Wash Station and Watering Equipment for Electric Forklift","$",3600,"Electric Forklift","Hard code ","ibv16"]
[null,17,"Fire or Acid Spill Containment","$",1000,"Electric Forklift","Hard code ","ibv17"]
[null,18,"Installation of Charge Room Equipment and Fixtures","$",1000,"Electric Forklift","Hard code ","ibv18"]
[null,19,"Installation of Cylinder Storage Room Equipment and Fixtures","$",0,"Propane Forklift","Hard code ","ibv19"]
[null,20,"Additional Electric Wiring","$",400,"Electric Forklift","Hard code ","ibv20"]
[null,21,"Electric Supply Upgrade Costs","$",800,"Electric Forklift","Hard code ","ibv21"]
[null,22,"Additional Charger","$",3500,"Electric Forklift","Hard code ","ibv22"]
[null,23,"Refueling or Charging Training","$",356,"Both Propane & Electric Forklfits","Hard code ","ibv23"]
[null,24,"On site maintenance for Propane Forklift","$",1335,"Propane Forklift","Hard code ","ibv24"]
[null,25,"On site maintenance for Electric Forklift","$",1700,"Electric Forklift","Hard code ","ibv25"]
[null,26,"Average Repair Cost for Propane Forklift","$",20,"Propane Forklift","Hard code ","ibv26"]
[null,27,"Repair Frequency for Propane Forklift in a year","-",6,"Propane Forklift","Hard code ","ibv27"]
[null,28,"Battery Degradation Cost due to temperature","$",0,"Electric Forklift","Hard code ","ibv28"]
[null,29,"Costs for Running out of propane","$",0,"Propane Forklift","Hard code ","ibv29"]
[null,30,"Costs of mischarging or power failures","$",0,"Electric Forklift","Hard code ","ibv30"]
[null,31,"Utility demand charge for recharging  per kW","$",0.1,"Electric Forklift","Hard code ","ibv31"]
[null,32,"CO and other safety costs per hour for Propane Forklift","$",1.1499999999999999,"Propane Forklift","Hard code ","ibv32"]
[null,33,"Safety costs per hour for Electric Forklift","$",0,"Electric Forklift","Hard code ","ibv33"]
[null,34,"HVAC cost for charging space","$",18,"Electric Forklift","Hard code ","ibv34"]
[null,35,"Additional Propane Forklift Cylinder","$",275,"Propane Forklift","Hard code ","ibv35"]
[]
[]
[]
[null,"Calculated Variables"]
[]
[]
[null,"S.No","Parameter","Unit","Value","Variable Using Entity","Formula","Variable Code Name",null,"Calculated Cost Variables Table"]
[null,1,"Individual Battery and Charger Cost for Lead Acid Battery","$",{"$f":"E28+E48","v":7500},"Lead Acid Electric Forklift only","ibv2 + ibv22","cv1"]
[null,2,"Individual Battery and Charger Cost for Lithium Ion Battery","$",{"$f":"E29+E48","v":13500},"Lithium Ion Electric Forklift only","ibv3 + ibv22","cv2"]
[null,3,"Cost of Interior Space for Cylinder Storage","$",{"$f":"E30*E31","v":160},"Propane Forklift","ibv4 * ibv5","cv3"]
[null,4,"Cost of Interior Space for Battery Storage and charging","$",{"$f":"E30*E32","v":1600},"Both Lead Acid & Lithium Ion Electric Forklifts","ibv4 * ibv6","cv4"]
[null,5,"Cost of Exterior Space for Cylinder Storage","$",{"$f":"E30*E33","v":160},"Propane Forklift","ibv4 * ibv7","cv5"]
[null,6,"Cost of Parts and Supplies for Propane Forklift","$",{"$f":"E52*E53","v":120},"Propane Forklift","ibv26 * ibv27","cv6"]
[null,7,"Total Fuel Cost for Propane","$",{"$f":"E8*E9*E13","v":4488},"Propane Forklift","u3 * u4 * u8","cv7"]
[null,8,"Cost of Utility demand for recharging","$",{"$f":"E10*E13*E57","v":1249.5},"Both Lead Acid & Lithium Ion Electric Forklifts","u5 * u8 * ibv31","cv8"]
[null,9,"Total Electricity Cost","$",{"$f":"E10*E11*E13","v":1374.45},"Both Lead Acid & Lithium Ion Electric Forklifts","u5 * u6 * u8","cv9"]
[null,10,"Total CO and other safety costs for Propane Forklift","$",{"$f":"E13*E58","v":1954.9999999999998},"Propane Forklift","u8 * ibv32","cv10"]
[null,11,"Total Charging Space HVAC Costs","$",{"$f":"E60*E32","v":3600},"Both Lead Acid & Lithium Ion Electric Forklifts","ibv6 * ibv34","cv11"]
[]
[]
[]
[null,"Calculated Costs of Forklift By Segment"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Calculated Segemented Costs Table"]
[null,"S.No","Cost Category","Unit","Propane","Formula","Lead Acid","Formula","Lithium Ion ","Formula"]
[null,1,"Acquisition Cost","$",{"$f":"E6","v":30000},"u1",{"$f":"E7+E69","v":47500},"u2 + cv1",{"$f":"E7+E70","v":53500},"u2 + cv2"]
[null,2,"Operating Cost","$",{"$f":"E27+E35+E36+E49+E55+E75+E78","v":7147},"ibv1 + ibv9 + ibv10 + ibv23 + ibv29 + cv7 + cv10",{"$f":"E49+E54+E56+E76+E77+E59","v":2979.95},"ibv23 + ibv28 + ibv30 + cv8 + cv9 + ibv 33",{"$f":"E49+E54+E56+E76+E77+E59","v":2979.95},"ibv23 + ibv28 + ibv30 + cv8 + cv9 + ibv 33"]
[null,3,"Maintenance Cost","$",{"$f":"E50+E74","v":1455},"ibv24 + cv6",{"$f":"E51","v":1700},"ibv25",{"$f":"E51","v":1700},"ibv25"]
[null,4,"Infrastructure Cost","$",{"$f":"E71+E73+E41+E45+E61","v":3595},"cv3 + cv5 + ibv15 + ibv19 + ibv35",{"$f":"E72+E37+E39+E40+E42+E43+E44+E46+E47+E48+E79","v":23000},"cv4 + ibv11 + ibv13 + ibv14 + ibv 16 + ibv 17 + ibv 18 + ibv20 + ibv21+ ibv22 + cv11",{"$f":"E72+E38+E39+E40+E42+E43+E44+E46+E47+E48+E79","v":29000},"cv4 + ibv12 + ibv13 + ibv14 + ibv 16 + ibv 17 + ibv 18 + ibv20 + ibv21+ ibv22 + cv11"]
[null,null,"Total","S",{"$f":"SUM(E87:E90)","v":42197},"Acquisition Cost + Operating Cost + Maintenance Cost + Infrastructure Cost",{"$f":"SUM(G87:G90)","v":75179.95},"Acquisition Cost + Operating Cost + Maintenance Cost + Infrastructure Cost",{"$f":"SUM(I87:I90)","v":87179.95},"Acquisition Cost + Operating Cost + Maintenance Cost + Infrastructure Cost"]
[]
[]
[]
[null,"Total Cost of Ownership Outputs"]
[]
[null,null,null,null,null,null,null,null,null,"Final Costs Output Table"]
[null,"S.No","Cost Category","Unit","Propane Forklfit","Electric Forklift"]
[null,1,"Acquisition Cost","$",{"$f":"E87","v":30000},{"$f":"IF(E12=\"Lead Acid\",G87,I87)","v":53500}]
[null,2,"Operating Cost","$",{"$f":"E88","v":7147},{"$f":"IF(E12=\"Lead Acid\",G88,I88)","v":2979.95}]
[null,3,"Maintenance Cost","$",{"$f":"E89","v":1455},{"$f":"IF(E12=\"Lead Acid\",G89,I89)","v":1700}]
[null,4,"Infrastructure Cost","$",{"$f":"E90","v":3595},{"$f":"IF(E12=\"Lead Acid\",G90,I90)","v":29000}]
[null,null,"Total Cost","$",{"$f":"E91","v":42197},{"$f":"IF(E12=\"Lead Acid\",G91,I91)","v":87179.95}]
[]
[]
[]
[]
[]
[null,"Background Constant Data for Carbon FootPrint Chart - Propane"]
[]
[]
[null,"S.No","State","Unit","Carbon Intensity","Variable Code Name"]
[null,1,"Alaska","gCO2eq/MJ",80.72,"C1_P1"]
[null,2,"Alabama","gCO2eq/MJ",77.72,"C1_P2"]
[null,3,"Arkansas","gCO2eq/MJ",77.72,"C1_P3"]
[null,4,"Arizona","gCO2eq/MJ",80.72,"C1_P4"]
[null,5,"California","gCO2eq/MJ",80.72,"C1_P5"]
[null,6,"Colorado","gCO2eq/MJ",77.430000000000007,"C1_P6"]
[null,7,"Connecticut","gCO2eq/MJ",77.180000000000007,"C1_P7"]
[null,8,"District of Columbia","gCO2eq/MJ",77.180000000000007,"C1_P8"]
[null,9,"Delaware","gCO2eq/MJ",77.180000000000007,"C1_P9"]
[null,10,"Florida","gCO2eq/MJ",77.180000000000007,"C1_P10"]
[null,11,"Georgia","gCO2eq/MJ",77.180000000000007,"C1_P11"]
[null,12,"Hawaii","gCO2eq/MJ",80.72,"C1_P12"]
[null,13,"Iowa","gCO2eq/MJ",77.64,"C1_P13"]
[null,14,"Idaho","gCO2eq/MJ",77.430000000000007,"C1_P14"]
[null,15,"Illinois","gCO2eq/MJ",77.64,"C1_P15",null,null,null,"Background Emissions Constants Tables for Propane Forklifts"]
[null,16,"Indiana","gCO2eq/MJ",77.64,"C1_P16"]
[null,17,"Kansas","gCO2eq/MJ",77.64,"C1_P17"]
[null,18,"Kentucky","gCO2eq/MJ",77.64,"C1_P18"]
[null,19,"Louisiana","gCO2eq/MJ",77.72,"C1_P19"]
[null,20,"Massachusetts","gCO2eq/MJ",77.180000000000007,"C1_P20"]
[null,21,"Maryland","gCO2eq/MJ",77.180000000000007,"C1_P21"]
[null,22,"Maine","gCO2eq/MJ",77.180000000000007,"C1_P22"]
[null,23,"Michigan","gCO2eq/MJ",77.64,"C1_P23"]
[null,24,"Minnesota","gCO2eq/MJ",77.64,"C1_P24"]
[null,25,"Missouri","gCO2eq/MJ",77.64,"C1_P25"]
[null,26,"Mississippi","gCO2eq/MJ",77.72,"C1_P26"]
[null,27,"Montana","gCO2eq/MJ",77.430000000000007,"C1_P27"]
[null,28,"North Carolina","gCO2eq/MJ",77.180000000000007,"C1_P28"]
[null,29,"North Dakota","gCO2eq/MJ",77.64,"C1_P29"]
[null,30,"Nebraska","gCO2eq/MJ",77.64,"C1_P30"]
[null,31,"New Hampshire","gCO2eq/MJ",77.180000000000007,"C1_P31"]
[null,32,"New Jersey","gCO2eq/MJ",77.180000000000007,"C1_P32"]
[null,33,"New Mexico","gCO2eq/MJ",77.72,"C1_P33"]
[null,34,"Nevada","gCO2eq/MJ",80.72,"C1_P34"]
[null,35,"New York","gCO2eq/MJ",77.180000000000007,"C1_P35"]
[null,36,"Ohio","gCO2eq/MJ",77.64,"C1_P36"]
[null,37,"Oklahoma","gCO2eq/MJ",77.64,"C1_P37"]
[null,38,"Oregon","gCO2eq/MJ",80.72,"C1_P38"]
[null,39,"Pennsylvania","gCO2eq/MJ",77.180000000000007,"C1_P39"]
[null,40,"Rhode Island","gCO2eq/MJ",77.180000000000007,"C1_P40"]
[null,41,"South Carolina","gCO2eq/MJ",77.180000000000007,"C1_P41"]
[null,42,"South Dakota","gCO2eq/MJ",77.64,"C1_P42"]
[null,43,"Tennessee","gCO2eq/MJ",77.64,"C1_P43"]
[null,44,"Texas","gCO2eq/MJ",77.72,"C1_P44"]
[null,45,"Utah","gCO2eq/MJ",77.430000000000007,"C1_P45"]
[null,46,"Virginia","gCO2eq/MJ",77.180000000000007,"C1_P46"]
[null,47,"Vermont","gCO2eq/MJ",77.180000000000007,"C1_P47"]
[null,48,"Washington","gCO2eq/MJ",80.72,"C1_P48"]
[null,49,"Wisconsin","gCO2eq/MJ",77.64,"C1_P49"]
[null,50,"West Virginia","gCO2eq/MJ",77.180000000000007,"C1_P50"]
[null,51,"Wyoming","gCO2eq/MJ",77.430000000000007,"C1_P51"]
[]
[]
[]
[null,"Background Constants Data for Carbon FootPrint Chart - Propane"]
[]
[]
[null,"S.No","Parameters","Unit","Propane","Variable Code Name"]
[null,6,"LHV of Conventional Propane","BTU/gallon",84950,"LHV1"]
[null,7,"LHV of Renewable Propane","BTU/gallon",84950,"LHV2"]
[null,8,"LHV of Renewable DME","BTU/gallon",68925,"LHV3"]
[null,9,"LHV of Conventional Propane diff unit","MJ/kg",46.6,"LHV4"]
[null,10,"LHV of Renewable Propane diff unit","MJ/kg",46.6,"LHV5"]
[null,11,"LHV of Renewable DME diff unit","MJ/kg",28.88,"LHV6"]
[null,12,"Carbon Intensity of Renewable DME","gCO2eq/MJ",-278,"CI_P6"]
[]
[]
[]
[null,"Background Calculations Data for Carbon FootPrint Chart - Propane"]
[]
[]
[null,"S.No","States","Unit","Propane","Formula","Variable Code Name"]
[null,1,"Carbon Intensity of Conventional Propane","gCO2eq/MJ",{"$f":"_xlfn.XLOOKUP(E14,C113:C163,E113:E163)","v":80.72},"-","CI_1"]
[null,2,"Carbon Intensity of Renewable Propane","gCO2eq/MJ",{"$f":"E16","v":43.5},"u10","CI_2"]
[null,3,"Carbon Intensity of Renewable DME","gCO2eq/MJ",{"$f":"E177","v":-278},"CI_P6","CI_3"]
[null,3,"LHV of blend","MJ/kg",{"$f":"(E17*0.01*E174)+(E18*0.01*E175)+(E19*0.01*E176)","v":46.6},"(u11*0.01*LHV4)+(u12*0.01*LHV5)+(u13*0.01*LHV6)","LB1",null,null,"Background Emissions Calculated Variables Tables for Propane Forklifts"]
[null,4,"Specific volume of conventional propane","gallon/kg",{"$f":"E174/(E171*0.00105506)","v":0.51993059662917396},"LHV4/(LHV1*0.00105506)","SV1"]
[null,5,"Specific volume of renewable propane","gallon/kg",{"$f":"E175/(E172*0.00105506)","v":0.51993059662917396},"LHV5/(LHV2*0.00105506)","SV2"]
[null,6,"Specific volume of renewable DME","gallon/kg",{"$f":"E176/(E173*0.00105506)","v":0.39713965662862494},"LHV6/(LHV3*0.00105506)","SV3"]
[null,7,"Specific volume of blend","gallon/kg",{"$f":"(E17*0.01*E189)+(E18*0.01*E190)+(E19*0.01*E191)","v":0.51993059662917396},"(u11*0.01*SV1)+(u12*0.01*SV2)+(u13*0.01*SV3)","SVB1"]
[null,8,"Vol. percentage of conventional propane in blend","%",{"$f":"E17*E189/E192","v":100},"(u11*SV1)/SVB1","VP1"]
[null,9,"Vol. percentage of renewable propane in blend","%",{"$f":"E18*E190/E192","v":0},"(u12*SV2)/SVB1","VP2"]
[null,10,"Vol. percentage of renewable DME in blend","%",{"$f":"E19*E191/E192","v":0},"(u13*SV3)/SVB1","VP3"]
[null,11,"Energy percentage of conventional propane in blend","%",{"$f":"E17*E174/E188","v":100},"(u11*LHV4)/LB1","EP1"]
[null,12,"Energy percentage of renewable propane in blend","%",{"$f":"E18*E175/E188","v":0},"(u12*LHV5)/LB1","EP2"]
[null,13,"Energy percentage of renewable DME in blend","%",{"$f":"E19*E176/E188","v":0},"(u13*LHV6)/LB1","EP3"]
[null,14,"LHV of blended fuel gallon basis","BTU/gallon",{"$f":"((E171*E193*0.01)+(E172*E194*0.01)+(E173*E195*0.01))","v":84950},"(LHV1*VP1*0.01)+(LHV2*VP2*0.01)+(LHV3*VP3*0.01)","LBF1"]
[null,15,"Carbon intensity of the blend","gCO2eq/MJ",{"$f":"(E185*E196*0.01)+(E186*E197*0.01)+(E177*E198*0.01)","v":80.72},"(CI_1*EP1*0.01)+(CI_2*EP2*0.01)+(CI_3*EP3*0.01)","CI_BL"]
[]
[]
[]
[]
[null,"Background Constant Data for Carbon FootPrint Chart - Electricity"]
[]
[]
[null,"S.No","ISO Data","Unit","Electricity","Variable Code Name"]
[null,1,"Arizona Public Service Company","kgCO2eq/MWh",834.12584922686813,"F1"]
[null,2,"Arlington Valley, LLC - AVBA","kgCO2eq/MWh",628.34115114513145,"F2"]
[null,3,"Associated Electric Cooperative, Inc.","kgCO2eq/MWh",795.99573565700553,"F3"]
[null,4,"Avista Corporation","kgCO2eq/MWh",235.16912893299443,"F4"]
[null,5,"Balancing Authority of Northern California","kgCO2eq/MWh",451.59507942836882,"F5"]
[null,6,"Bonneville Power Administration","kgCO2eq/MWh",128.61653672219165,"F6",null,null,null,"Background Emissions Constants Tables for Electric Forklifts"]
[null,7,"California Independent System Operator","kgCO2eq/MWh",396.43159507807781,"F7"]
[null,8,"City of Tacoma, Department of Public Utilities, Light Division","kgCO2eq/MWh",235.37648526504375,"F8"]
[null,9,"Duke Energy Carolinas","kgCO2eq/MWh",370.60710604333639,"F9"]
[null,10,"Duke Energy Florida, Inc.","kgCO2eq/MWh",765.63099021267772,"F10"]
[null,11,"Duke Energy Progress East","kgCO2eq/MWh",437.66217357263741,"F11"]
[null,12,"El Paso Electric Company","kgCO2eq/MWh",763.80241562440608,"F12"]
[null,13,"Electric Energy, Inc.","kgCO2eq/MWh",1147.2164104759825,"F13"]
[null,14,"Electric Reliability Council of Texas, Inc.","kgCO2eq/MWh",662.66154757715276,"F14"]
[null,15,"Florida Municipal Power Pool","kgCO2eq/MWh",739.85537102338867,"F15"]
[null,16,"Florida Power & Light Co.","kgCO2eq/MWh",478.63858290902687,"F16"]
[null,17,"Gainesville Regional Utilities","kgCO2eq/MWh",816.39686098991751,"F17"]
[null,18,"Gila River Power, LLC","kgCO2eq/MWh",610.55093996281437,"F18"]
[null,19,"Homestead, City of","kgCO2eq/MWh",1533.5195544117066,"F19"]
[null,20,"Idaho Power Company","kgCO2eq/MWh",119.2828908931892,"F20"]
[null,21,"Imperial Irrigation District","kgCO2eq/MWh",329.78693609099577,"F21"]
[null,22,"ISO-NE","kgCO2eq/MWh",399.80544736671345,"F22"]
[null,23,"JEA","kgCO2eq/MWh",855.19513276500754,"F23"]
[null,24,"LG&E and KU Services Company as agent for Louisville Gas and Electric Company and Kentucky Utilities Company","kgCO2eq/MWh",984.56384014369769,"F24"]
[null,25,"Los Angeles Department of Water and Power","kgCO2eq/MWh",583.49577169301097,"F25"]
[null,26,"Midcontinent Independent System Operator, Inc.","kgCO2eq/MWh",753.27665218749178,"F26"]
[null,27,"Nevada Power Company","kgCO2eq/MWh",552.7373076358075,"F27"]
[null,28,"New York Independent System Operator","kgCO2eq/MWh",323.18927911605527,"F28"]
[null,29,"NorthWestern Corporation","kgCO2eq/MWh",757.95191106928758,"F29"]
[null,30,"Ohio Valley Electric Corporation","kgCO2eq/MWh",1254.163114697353,"F30"]
[null,31,"PacifiCorp East","kgCO2eq/MWh",866.21272263399931,"F31"]
[null,32,"PacifiCorp West","kgCO2eq/MWh",224.58975379338278,"F32"]
[null,33,"PJM Interconnection, LLC","kgCO2eq/MWh",572.347025378289,"F33"]
[null,34,"Portland General Electric Company","kgCO2eq/MWh",273.25831109771326,"F34"]
[null,35,"PowerSouth Energy Cooperative","kgCO2eq/MWh",776.59991966303414,"F35"]
[null,36,"Public Service Company of Colorado","kgCO2eq/MWh",653.75947836342334,"F36"]
[null,37,"Public Service Company of New Mexico","kgCO2eq/MWh",919.88962441976241,"F37"]
[null,38,"Public Utility District No. 1 of Chelan County","kgCO2eq/MWh",38.385831836006098,"F38"]
[null,39,"Public Utility District No. 2 of Grant County, Washington","kgCO2eq/MWh",3.8454865845809283,"F39"]
[null,40,"PUD No. 1 of Douglas County","kgCO2eq/MWh",0.72575394481971089,"F40"]
[null,41,"Puget Sound Energy, Inc.","kgCO2eq/MWh",337.33359651990469,"F41"]
[null,42,"Salt River Project Agricultural Improvement and Power District","kgCO2eq/MWh",496.75878277048014,"F42"]
[null,43,"Seattle City Light","kgCO2eq/MWh",35.122715725357395,"F43"]
[null,44,"Seminole Electric Cooperative","kgCO2eq/MWh",909.85981266874285,"F44"]
[null,45,"South Carolina Electric & Gas Company","kgCO2eq/MWh",553.28621448150454,"F45"]
[null,46,"South Carolina Public Service Authority","kgCO2eq/MWh",912.49536483658721,"F46"]
[null,47,"Southern Company Services, Inc. - Trans","kgCO2eq/MWh",634.8085838119722,"F47"]
[null,48,"Southwest Power Pool","kgCO2eq/MWh",707.13862636907265,"F48"]
[null,49,"Southwestern Power Administration","kgCO2eq/MWh",302.12002893817419,"F49"]
[null,50,"Tallahassee, City of","kgCO2eq/MWh",611.62023283906797,"F50"]
[null,51,"Tampa Electric Company","kgCO2eq/MWh",796.56166793284717,"F51"]
[null,52,"Tennessee Valley Authority","kgCO2eq/MWh",528.08680547910194,"F52"]
[null,53,"Tucson Electric Power","kgCO2eq/MWh",892.12310842646059,"F53"]
[null,54,"Turlock Irrigation District","kgCO2eq/MWh",471.18742790087288,"F54"]
[null,55,"Western Area Power Administration - Desert Southwest Region","kgCO2eq/MWh",427.67007205805629,"F55"]
[null,56,"Western Area Power Administration - Rocky Mountain Region","kgCO2eq/MWh",991.33005323345924,"F56"]
[null,57,"Western Area Power Administration - Upper Great Plains West","kgCO2eq/MWh",181.20729442644082,"F57"]
[null,58,"Battery Capacity","kWh",43.2,"BC"]
[null,59,"Battery Manufacturing Emissions","kgCO2eq/kWh",140,"BME"]
[]
[]
[]
[]
[null,"Carbon Footprint Background Calculations Based on State Selected and ISO Selected"]
[]
[]
[null,"S.No","Sample State/ISO Selected","Unit","Calculated Value","Formula","Variable Name"]
[null,1,"Carbon Intensity of Selected ISO","kgCO2eq/MWh",{"$f":"_xlfn.XLOOKUP(E15,C209:C265,E209:E265)","v":834.12584922686813},"-","Res0"]
[null,2,"Selected State - Lead Acid Battery Electric Forklift emissions","MT CO2eq",{"$f":"E10*E13*E276*(10^-6)","v":10.422402486089718},"u5 * u8  * Res0 / 10^6","Res1"]
[null,3,"Battery Manufacturing Emissions for Lithium Ion Battery","MT CO2eq",{"$f":"E266*E267/(2.5*10^3)","v":2.4192},"BC * BME /(2.5* 1000)","Res2"]
[null,4,"Selected State - Lithium Ion Battery Electric Forklift emissions","MT CO2eq",{"$f":"E277+E278","v":12.841602486089718},"Res1+Res2","Res3"]
[null,5,"Selected State - Conventional Propane Forklift emissions","MT CO2eq",{"$f":"E9*E13*E171*0.00105506*E185/10^6","v":12.987768356352767},"u4 * u8 * LHV1* 0.00105506 * CI_1 / 10^6","Res4"]
[null,6,"Selected State - Renewable Propane Forklift emissions","MT CO2eq",{"$f":"E9*E13*E172*0.00105506*E186/10^6","v":6.9991070800463993},"u4 * u8 * LHV2* 0.00105506 * CI_2/ 10^6","Res5"]
[null,7,"Selected State -Conventional Propane, Renewable Propane and DME blend Forklift emissions","MT CO2eq",{"$f":"E9*E13*E199*0.00105506*E200/10^6","v":12.987768356352767},"u4 * u8 * LBF1* 0.00105506 * CI_BL/ 10^6","Res6"]
[null,null,null,null,null,null,null,null,null,"Emission Results Tables for Forklifts"]
[]
[]
[]
[]
[]
[]
[null,"Carbon Footprint Emission Outputs in Selected State and ISO "]
[]
[]
[null,"S.No","Cost Category","Unit","Value "]
[null,1,"Forklift Operated on Conventional Propane","MT CO2eq",{"$f":"E280","v":12.987768356352767}]
[null,2,"Forklift Operated on Renewable Propane","MT CO2eq",{"$f":"E281","v":6.9991070800463993}]
[null,3,"Forklift Operated on Conventional Propane, Renewable Propane and DME Blend","MT CO2eq",{"$f":"E282","v":12.987768356352767}]
[null,4,"Battery Electric Forklift","MT CO2eq",{"$f":"IF(E12=\"Lead Acid\",E277,E279)","v":12.841602486089718}]
[]
[]
[]
[]
[]
[]
[]
[null,"S.No","Parameter",null,null,null,null,null,null,"Labels for Charts"]
[null,1,"Lead Acid Battery"]
[null,2,"Lithium Ion Battery"]
[null,"Electric Selection",{"$f":"IF(E12=\"Lead Acid\",C306,C307)","v":"Lithium Ion Battery"}]
[null,3,"Conventional Propane"]
[null,4,"Renewable Propane"]
[null,5,"Renewable DME"]
[null,"Blend Selection",{"$f":"_xlfn.CONCAT(E17,\"%\",\" \",C309,\",\",\" \",E18,\"%\",\" \",C310,\",\",\" \",E19,\"%\",\" \",C311,\" \",\"Blend\")","v":"100% Conventional Propane, 0% Renewable Propane, 0% Renewable DME Blend"}]