{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Inputs","Trucks","Output","Calc2","Calc1","Performance","TBD - Li-Ion Chargers"," Maintenance","Devlogs","TBD - ECBTrucks","Sheet4","Sheet1","Sheet2"],"not_rendered":{"charts":5,"images":5,"macros":1,"external_links":0,"defined_names":27,"comments":1,"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":"Inputs","index":0,"n_rows":117,"n_cols":14,"rows_kept":117,"cut":false,"hidden":false,"merged":[[128,2,139,7],[24,1,24,14],[0,2,0,11],[1,1,1,14],[35,1,35,14],[53,1,53,14],[62,1,62,14],[81,1,81,14],[93,1,93,14],[116,1,116,14],[66,7,67,14],[17,9,18,13],[83,9,86,13]]}
[null,null,"\nNot for Further Distribution\n\nDo not use if training has not been received or the tutorial available in the Help Section has not been read, as improper use could lead to miscalculation.\n\n\nTotal Cost of Ownership (TCO) Comparison Tool\n1.5-5.5t Internal Combustion Engine (ICE) and Electric Counterbalance Trucks\n\n\n\n\n"]
[null,"Application and Daily Schedule"]
[]
[null,null,null,null,"Start Time","07:00:00",null,"select"]
[]
[null,null,null,"Break 1",null,"Break 2",null,"Break 3",null,"Break 4",null,"Break 5",null,"Break 6"]
[null,null,"Break Start Time","10:00:00",null,"12:30:00",null,"15:00:00",null,"19:00:00",null,"21:00:00",null,"No Break"]
[null,null,"Break Duration (mins)",20,null,40,null,20,null,40,null,20,null,0]
[]
[null,null,null,"Break 7",null,"Break 8",null,"Break 9",null,"Break 10",null,"Break 11",null,"Break 12"]
[null,null,"Break Start Time","No Break",null,"No Break",null,"No Break",null,"No Break",null,"No Break",null,"No Break"]
[null,null,"Break Duration (mins)",0,null,0,null,0,null,0,null,0,null,0]
[]
[null,null,null,"Break 13",null,"Break 14",null,"Break 15",null,"Break 16",null,"Break 17",null,"Break 18"]
[null,null,"Break Start Time","No Break",null,"No Break",null,"No Break",null,"No Break",null,"No Break",null,"No Break"]
[null,null,"Break Duration (mins)",0,null,0,null,0,null,0,null,0,null,0]
[]
[null,null,null,null,"End Time","23:00:00",null,"select",null,{"$f":"IF(Calc1!$P$57=1,\"Warning: please choose End Time after final break or check break patters\",\"\")","v":""}]
[]
[null,null,null,null,"Days per week",5]
[null,null,null,null,"Truck hours / Year",3000,null,{"$f":"\"input     Hours per year based on shift pattern: \"&TEXT((Calc1!D2),\"0\")&\" hours\"","v":"input     Hours per year based on shift pattern: 3280 hours"}]
[null,null,null,null,"% Working time that truck is idle (excl. scheduled breaks)",9,null,{"$f":"IF((AND(F21>0, F21<=Calc1!D2)), \"input     Suggested value based on truck hrs p.a. = \"&TEXT((Calc1!D3*100),\"0\") &\"%\",\"input      Suggested default value is  =  \"&TEXT(Calc2!C9,\"0\")& \"%\")","v":"input     Suggested value based on truck hrs p.a. = 9%"}]
[]
[]
[null,"Fleet size / Fuel & Power Costs"]
[]
[null,null,null,null,"Fleet size input number of trucks required",10,null,{"$f":"\"input\"","v":"input"}]
[]
[null,null,null,null,"Operator hourly cost (€)",30,null,{"$f":"\"input      Default  =  \"&TEXT(Calc2!$C$15,\"0.00\")&\" €/h\"","v":"input      Default  =  30.00 €/h"}]
[null,null,null,null,"Diesel cost (€/lt)",1.3,null,{"$f":"\"input      Default  =  \"&TEXT(Calc2!$C$12,\"0.00\")&\" €/L\"","v":"input      Default  =  1.00 €/L"}]
[null,null,null,null,"LPG cost (€/kg)",0.75,null,{"$f":"\"input      Default  =  \"&TEXT(Calc2!$C$13,\"0.00\")&\" €/kg\"","v":"input      Default  =  0.70 €/kg"}]
[null,null,null,null,"Electricity cost (€/kWh)",0.09,null,{"$f":"\"input      Default  =  \"&TEXT(Calc2!$C$11,\"0.00\")&\" €/kWh\"","v":"input      Default  =  0.12 €/kWh"}]
[null,null,null,null,"Hydrogen cost (€/kg)",3,null,{"$f":"\"input      Default  =  \"&TEXT(Calc2!$C$14,\"0.00\")&\" €/kg\"","v":"input      Default  =  3.00 €/kg"}]
[]
[]
[null,"Current - ICE Truck Information"]
[]
[null,null,null,null,"Model","H2.5FT",null,"select"]
[null,null,null,null,"Fuel","Diesel",null,"select"]
[null,null,null,null,"Engine","2.4L - Kubota ",null,"select"]
[null,null,null,null,"Transmision","1-Speed Basic ",null,"select"]
[null,null,null,null,"Energy consumption",2.6,null,{"$f":"\"input      Provide real value if possible (VDI value for selected truck is  =  \"&TEXT(Trucks!L5,\"0.00\")&IF(F39=\"Diesel\",\" L/h\",IF(F39=\"LPG\",\" kg/h\",\"\")) &\")\"","v":"input      Provide real value if possible (VDI value for selected truck is  =  2,6 L/h)"}]
[]
[null,null,null,null,"Refueling time (mins)",20,null,"input",null,"Include time to drive to the Refill area"]
[null,null,null,null,"LPG Bottle size (kg)",11,null,"input","Ensure LPG bottle is compatible with truck selected"]
[]
[null,null,null,null,"Truck purchase cost",36000,null,"input"]
[null,null,null,null,"Monthly service fee",250,null,"input"]
[null,null,null,null,"Infrastructure price",0,null,"input",null,"** EG Bulk storage of Dsl or LPG"]
[null,null,null,null,"Annual Infrastructure fees",0,null,"input",null,"Any bulk storage rental "]
[]
[null,null,null,"Truck in Hip",null,"No"]
[]
[null,"Electric Truck Information"]
[]
[null,null,null,null,"Model","J2.5XN",null,"select"]
[null,null,null,null,"Energy Consumption",7.9,null,{"$f":"\"input    Provide real value if possible (VDI value for selected truck is  =  \"&TEXT(Calc2!C8,\"0.00\") &\" kWh/h)\"","v":"input    Provide real value if possible (VDI value for selected truck is  =  7,9 kWh/h)"}]
[]
[null,null,null,null,"Truck purchase cost (ex battery)",33700,null,"input"]
[null,null,null,null,"Monthly service fee (EXCLUDING battery maintenance)",150,null,"input"]
[]
[]
[null,"Lead Acid Battery and Charger"]
[]
[null,null,null,null,"Battery capacity (Ah)",770,null,"select"]
[null,null,null,null,"Charger type","50 Hz",null,"select"]
[null,null,null,null,"# Batteries needed",{"$f":"Calc1!$D$51","v":2},null,{"$f":"IF((AND((F67-Calc1!D50)/1<1, (F67-Calc1!D50)/1>0.8)), \" Less than 20% of the last battery is used, consider changing the battery capacity and/or reviewing the truck energy consumption (row 57)\", \"\")","v":""}]
[]
[null,null,null,null,"Monthly battery & charger service fee",100,null,"input      Include maintenance, cleaning, topping. Do not include annual inspection"]
[null,null,null,null,"Battery changeover time (mins)",15,null,"input",null,"Include time to drive to the Battery room "]
[]
[null,null,null,null,"Lead Acid battery price (€)",7000,null,"input"]
[null,null,null,null,"Charger price (€)",1500,null,"input"]
[null,null,null,"Chargers/Truck",null,0.8,null,"input"]
[null,null,null,null,"Infrastructure price (€)",null,null,"input",null,"Charging rooms/Cranes - Exchange equipment"]
[null,null,null,null,"Incentives / Benefits (%)",0,null,"input",null,"To define which amounts are affected by this benefit"]
[]
[null,null,null,null,"Is there an existing charging room?","Yes",null,"select"]
[null,null,null,"Truck in Hip",null,"Yes"]
[]
[]
[null,"Li-ion Battery and Charger"]
[]
[null,null,null,null,"Battery capacity (Ah)",600,null,"select",null,{"$f":"IFERROR(IF(SUM(Calc1!$R$18:$R$56)>0,\"Maximum DOD has been exceeded. Please check energy consumption, choose a larger Lithium-ion battery or charger or change shift pattern\",\"\"),\"\")","v":""}]
[null,null,null,null,"Charger (A)",500,null,"select"]
[]
[null,null,null,null,"Lithium-ion battery price (€)",20000,null,"input"]
[null,null,null,null,"Charger price (€)",5000,null,"input"]
[null,null,null,"Chargers/Truck",null,0.75,null,"input"]
[null,null,null,null,"Infrastructure price (€)",null,null,"input",null,"E.g. upgrade to facility power supply/circuit breakers"]
[null,null,null,null,"Incentives / Benefits (%)",null,null,"input",null,"To define which amounts are affected by this benefit"]
[null,null,null,"Truck in Hip",null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 12/9/19"]
[null,"Fuel Cell "]
[]
[null,null,null,null,"Fuel Cell capacity (Ah)",312,null,"select"]
[]
[null,null,null,null,"Refueling time (mins)",3,null,"input"]
[]
[null,null,null,null,"Power Cell price (€)",20000,null,"input"]
[null,null,null,null,"Infrastructure price (€)",50000,null,"input",null,"Refuel station/H2 Generation"]
[null,null,null,null,"Annual Infrastructure fee (€)",null,null,"input",null,"Rental of MCP or Trailers"]
[null,null,null,null,"Incentives / Benefits (%)",null,null,"input",null,"To define which amounts are affected by this benefit"]
[null,null,null,"Truck in Hip",null,"Yes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"THE TCO COMPARISON TOOL USES GENERIC DATA AND TECHNICAL DATA FROM HYSTER-YALE GROUP (HYG) AND ITS SUPPLIERS TO MODEL THE PERFORMANCE OF FORKLIFT TRUCKS AND THE DIFFERENT POWER OPTIONS SUPPLIED BY HYG. BASED ON USER INPUTS IT CALCULATES THE PERFORMANCE OF THE EQUIPMENT IN TYPICAL MATERIALS HANDLING APPLICATIONS. WHILE HYG HAS ENDEAVOURED TO ENSURE ITS ACCURACY, HYG CANNOT GUARANTEE THAT THE RESULTS GENERATED WILL BE ACCURATE OR CORRECT FOR A SPECIFIC CUSTOMER OR APPLICATION. FURTHER, THE PERFORMANCE OF THE TOOL RELIES ON THE USER PROVIDING COMPLETE AND ACCURATE INPUTS. RESULTS GENERATED BY THE TOOL MAY BE COMPROMISED IF INCOMPLETE OR INACCURATE INPUTS ARE USED. THE TOOL PROVIDES ESTIMATES ONLY, AND SHOULD NOT BE RELIED UPON TO ACCURATELY FORECAST OR PREDICT RESULTS IN ACTUAL USE OF MATERIALS HANDLING EQUIPMENT. HYG  EXPRESSLY DISCLAIMS AND EXCLUDES ANY LIABILITY FOR LOSS OR DAMAGE HOWEVER CAUSED, WHETHER DIRECT OR INDIRECT, THAT MAY RESULT FROM USE OF THE TCO COMPARISON TOOL OR RELIANCE ON ITS RESULTS.  "]

{"sheet":"Trucks","index":1,"n_rows":293,"n_cols":18,"rows_kept":293,"cut":false,"hidden":true,"merged":[]}
["Table A: ICE Trucks"]
[]
[]
[null,"Truck Model                                       (write exactly as you wish the names to appear to the user) - write each truck model only once","Fuel","Engine","Transmision","VDI","Tank Size","ModelD","FuelD","EngineD","TransmisionD","VDI","Tank",null,"Selected model","Selected Fuel","Selected Engine","Selected transmision"]
[null,"Select","Select","Select","Select",0,0,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H4,ICTrucks),0)),\"\")","v":"Select"},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I4,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":"LPG"},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J4,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":"2.6L - Yanmar"},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K4,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":"1-Speed Basic "},{"$f":"IFERROR(INDEX(ICVDI,MATCH(0,COUNTIF($L$4:L4,ICVDI)+(ICTransmisions<>$R$5)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":"2,6"},{"$f":"IFERROR(INDEX(ICTank,MATCH(0,COUNTIF($M$4:M4,ICTank)+(ICTransmisions<>$R$5)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":52},null,{"$f":"Inputs!F38","v":"H2.5FT"},{"$f":"Inputs!F39","v":"Diesel"},{"$f":"Inputs!F40","v":"2.4L - Kubota "},{"$f":"Inputs!F41","v":"1-Speed Basic "}]
[null,"H1.6FT","LPG","2.0L PSI","1-Speed","2,35",0,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H5,ICTrucks),0)),\"\")","v":"H1.6FT"},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I5,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":"Diesel"},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J5,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":"3.3L - Yanmar"},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K5,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":"2-Speed Basic "}]
[null,"H1.8FT","LPG","2.0L PSI","1-Speed","2,42",0,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H6,ICTrucks),0)),\"\")","v":"H1.8FT"},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I6,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J6,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":"2.4L - Kubota "},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K6,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H2.0FT","LPG","2.4L PSI","1-Speed Basic","2,5",0,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H7,ICTrucks),0)),\"\")","v":"H2.0FT"},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I7,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J7,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K7,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H2.0FT","LPG","2.4L PSI","1-Speed Duramatch","2,5",0,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H8,ICTrucks),0)),\"\")","v":"H2.5FT"},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I8,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J8,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K8,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H2.0FT","LPG","2.5L Kubota","1-Speed Basic","2,6",0,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H9,ICTrucks),0)),\"\")","v":"H3.0FT"},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I9,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J9,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K9,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H2.0FT","LPG","2.5L Kubota","2-Speed Duramatch 2","2,7",0,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H10,ICTrucks),0)),\"\")","v":"H3.5FT"},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I10,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J10,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K10,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H2.5FT","LPG","2.4L - PSI","1-Speed Basic ","2,7",0,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H11,ICTrucks),0)),\"\")","v":"H2.0XT"},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I11,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J11,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K11,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H2.5FT","Diesel","2.6L - Yanmar","1-Speed Basic ",3,52,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H12,ICTrucks),0)),\"\")","v":"H2.5XT"},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I12,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J12,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K12,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H2.5FT","Diesel","3.3L - Yanmar","1-Speed Basic ","3,3",52,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H13,ICTrucks),0)),\"\")","v":"H3.0XT"},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I13,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J13,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K13,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H2.5FT","Diesel","2.4L - Kubota ","1-Speed Basic ","2,6",52,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H14,ICTrucks),0)),\"\")","v":"H4.0FT"},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I14,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J14,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K14,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H2.5FT","LPG","2.5L - Kubota","1-Speed Duramatch","2,8",0,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H15,ICTrucks),0)),\"\")","v":"H4.5FT"},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I15,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J15,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K15,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H2.5FT","LPG","2.4L - PSI","1-Speed Duramatch","2,7",0,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H16,ICTrucks),0)),\"\")","v":"H5.0FT"},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I16,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J16,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K16,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H2.5FT","Diesel","2.6L - Yanmar","1-Speed Duramatch",3,52,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H17,ICTrucks),0)),\"\")","v":"H5.5FT"},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I17,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J17,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K17,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H2.5FT","Diesel","2.4L - Kubota ","2-Speed Basic ","2,6",52,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H18,ICTrucks),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I18,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J18,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K18,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H2.5FT","LPG","2.5L - Kubota","2-Speed Duramatch 2","2,9",0,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H19,ICTrucks),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I19,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J19,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K19,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H3.0FT","LPG","2.4L - PSI","1-Speed Basic ","3,1",0,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H20,ICTrucks),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I20,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J20,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K20,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H3.0FT","Diesel","2.6L - Yanmar","1-Speed Basic ","3,3",52,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H21,ICTrucks),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I21,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J21,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K21,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H3.0FT","Diesel","3.3L - Yanmar","1-Speed Basic ","3,8",52,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H22,ICTrucks),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I22,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J22,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K22,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H3.0FT","Diesel","2.4L - Kubota ","1-Speed Basic ","3,2",52,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H23,ICTrucks),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I23,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J23,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K23,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H3.0FT","LPG","2.5L - Kubota","1-Speed Duramatch",3,0,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H24,ICTrucks),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I24,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J24,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K24,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H3.0FT","LPG","2.4L - PSI","1-Speed Duramatch","3,1",0,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H25,ICTrucks),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I25,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J25,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K25,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H3.0FT","Diesel","2.6L - Yanmar","1-Speed Duramatch","3,3",52,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H26,ICTrucks),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I26,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J26,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K26,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H3.0FT","Diesel","2.4L - Kubota ","2-Speed Basic ","3,1",52,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H27,ICTrucks),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I27,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J27,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K27,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H3.0FT","LPG","2.5L - Kubota","2-Speed Duramatch 2","3,2",0,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H28,ICTrucks),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I28,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J28,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K28,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H3.5FT","LPG","2.2L - Mazda","1-Speed Basic ","3,3",0,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H29,ICTrucks),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I29,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J29,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K29,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H3.5FT","LPG","2.4L - PSI","1-Speed Basic ","3,3",0,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H30,ICTrucks),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I30,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J30,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K30,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H3.5FT","Diesel","3.3L - Yanmar","1-Speed Basic ","4,3",52,{"$f":"IFERROR(INDEX(ICTrucks,MATCH(0,COUNTIF($H$4:H31,ICTrucks),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICFuels,MATCH(0,COUNTIF($I$4:I31,ICFuels)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICEngines,MATCH(0,COUNTIF($J$4:J31,ICEngines)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ICTransmisions,MATCH(0,COUNTIF($K$4:K31,ICTransmisions)+(ICEngines<>$Q$5)+(ICFuels<>$P$5)+(ICTrucks<>$O$5),0)),\"\")","v":""}]
[null,"H3.5FT","Diesel","2.4L - Kubota ","1-Speed Basic ","3,6",52]
[null,"H3.5FT","LPG","2.5L - Kubota","1-Speed Duramatch","3,2",0]
[null,"H3.5FT","LPG","2.4L - PSI","1-Speed Duramatch","3,3",0]
[null,"H3.5FT","Diesel","3.3L - Yanmar","1-Speed Duramatch","4,3",52]
[null,"H3.5FT","Diesel","2.4L - Kubota ","2-Speed Basic ","3,4",52]
[null,"H3.5FT","LPG","2.5L - Kubota","2-Speed Duramatch 2","3,4",0]
[null,"H2.0XT","LPG","2.4L - PSI","1-Speed Basic ","2,5",0]
[null,"H2.0XT","Diesel","2.6L - Yanmar","1-Speed Basic ","2,7",69]
[null,"H2.5XT","LPG","2.4L - PSI","1-Speed Basic ","2,8",0]
[null,"H2.5XT","Diesel","2.6L - Yanmar","1-Speed Basic ","3,1",69]
[null,"H2.5XT","Diesel","3.3L - Yanmar","1-Speed Basic ","3,3",69]
[null,"H3.0XT","LPG","2.4L - PSI","1-Speed Basic ","3,1",0]
[null,"H3.0XT","Diesel","2.6L - Yanmar","1-Speed Basic ","3,5",69]
[null,"H3.0XT","Diesel","3.3L - Yanmar","1-Speed Basic ","3,8",69]
[null,"H4.0FT","Diesel","3.8L - Kubota","1-Speed Duramatch","4,5",79]
[null,"H4.0FT","Diesel","3.8L - Kubota","2-Speed Duramatch 2","4,5",79]
[null,"H4.0FT","LPG","3.8L - Kubota","1-Speed Duramatch","4,3",0]
[null,"H4.0FT","LPG","3.8L - Kubota","2-Speed Duramatch 2","4,4",0]
[null,"H4.5FT","Diesel","3.8L - Kubota","1-Speed Duramatch","4,9",79]
[null,"H4.5FT","Diesel","3.8L - Kubota","2-Speed Duramatch 2","5,1",79]
[null,"H4.5FT","LPG","3.8L - Kubota","1-Speed Duramatch","4,6",0]
[null,"H4.5FT","LPG","3.8L - Kubota","2-Speed Duramatch 2","4,7",0]
[null,"H5.0FT","Diesel","3.8L - Kubota","1-Speed Duramatch","5,4",100.3]
[null,"H5.0FT","Diesel","3.8L - Kubota","2-Speed Duramatch 2","5,8",100.3]
[null,"H5.0FT","LPG","3.8L - Kubota","1-Speed Duramatch",5,0]
[null,"H5.0FT","LPG","3.8L - Kubota","2-Speed Duramatch 2","5,1",0]
[null,"H5.5FT","Diesel","3.8L - Kubota","1-Speed Duramatch","5,8",100.3]
[null,"H5.5FT","Diesel","3.8L - Kubota","2-Speed Duramatch 2","6,2",100.3]
[null,"H5.5FT","Diesel","3.8L - Kubota","1-Speed Duramatch","5,2",100.3]
[null,"H5.5FT","Diesel","3.8L - Kubota","2-Speed Duramatch 2","5,3",100.3]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"to add new truck options to the tool, insert rows above this entire row"]
[]
[]
["Table B: ECB Trucks"]
[]
[]
[null,"Truck Model                                       (write exactly as you wish the names to appear to the user) - write each truck model only once","Voltage (V)                      (keep similar voltages in the same section","VDI"]
[null,"Select","Select",0]
[null,"J1.5XNT_SWB 3-whl",48,"3,9"]
[null,"J1.6XNT_SWB 3-whl",48,"4,2"]
[null,"J1.6XNT_M/LWB 3-whl",48,"4,2"]
[null,"J1.6XN_M/LWB 4-whl",48,"4,4"]
[null,"J1.8XNT_M/LWB 3-whl",48,"4,7"]
[null,"J1.8XN_M/LWB 4-whl",48,5]
[null,"J2.0XNT_M/LWB 3-whl",48,"5,5"]
[null,"J2.0XN_LWB 4-whl",48,"5,5"]
[null,"J2.2XN",80,"6,7"]
[null,"J2.5XN",80,"7,9"]
[null,"J3.0XN",80,"8,7"]
[null,"J3.5XN",80,10]
[null,"J4.0XN",80,"12,5"]
[null,"J4.5XN",80,"12,7"]
[null,"J5.0XN",80,"12,9"]
[null,"J5.5XN",80,"13,5"]
[]
[]
[null,null,"to add new truck options to the tool, insert rows above this entire row"]
[]
[]
["Table C: Lead Acid Batteries by Truck model"]
[]
[]
[null,"Truck Model                                       (write exactly as you wish the names to appear to the user) - write each truck model only once","Battery Capacity (Ah)",null,null,null,null,"LABatD"]
[null,"Select","Select",null,null,null,null,{"$f":"IFERROR(INDEX(LABat,MATCH(0,COUNTIF($H$103:H103,LABat)+(LATrucks<>Inputs!$F$56),0)),\"\")","v":560}]
[null,"J1.5XNT_SWB 3-whl",420,null,null,null,null,{"$f":"IFERROR(INDEX(LABat,MATCH(0,COUNTIF($H$103:H104,LABat)+(LATrucks<>Inputs!$F$56),0)),\"\")","v":620}]
[null,"J1.6XNT_SWB 3-whl",420,null,null,null,null,{"$f":"IFERROR(INDEX(LABat,MATCH(0,COUNTIF($H$103:H105,LABat)+(LATrucks<>Inputs!$F$56),0)),\"\")","v":770}]
[null,"J1.6XNT_M/LWB 3-whl",575,null,null,null,null,{"$f":"IFERROR(INDEX(LABat,MATCH(0,COUNTIF($H$103:H106,LABat)+(LATrucks<>Inputs!$F$56),0)),\"\")","v":""}]
[null,"J1.6XNT_M/LWB 3-whl",625,null,null,null,null,{"$f":"IFERROR(INDEX(LABat,MATCH(0,COUNTIF($H$103:H107,LABat)+(LATrucks<>Inputs!$F$56),0)),\"\")","v":""}]
[null,"J1.6XN_M/LWB 4-whl",575,null,null,null,null,{"$f":"IFERROR(INDEX(LABat,MATCH(0,COUNTIF($H$103:H108,LABat)+(LATrucks<>Inputs!$F$56),0)),\"\")","v":""}]
[null,"J1.6XN_M/LWB 4-whl",625,null,null,null,null,{"$f":"IFERROR(INDEX(LABat,MATCH(0,COUNTIF($H$103:H109,LABat)+(LATrucks<>Inputs!$F$56),0)),\"\")","v":""}]
[null,"J1.8XNT_M/LWB 3-whl",575,null,null,null,null,{"$f":"IFERROR(INDEX(LABat,MATCH(0,COUNTIF($H$103:H110,LABat)+(LATrucks<>Inputs!$F$56),0)),\"\")","v":""}]
[null,"J1.8XNT_M/LWB 3-whl",625,null,null,null,null,{"$f":"IFERROR(INDEX(LABat,MATCH(0,COUNTIF($H$103:H111,LABat)+(LATrucks<>Inputs!$F$56),0)),\"\")","v":""}]
[null,"J1.8XN_M/LWB 4-whl",575,null,null,null,null,{"$f":"IFERROR(INDEX(LABat,MATCH(0,COUNTIF($H$103:H112,LABat)+(LATrucks<>Inputs!$F$56),0)),\"\")","v":""}]
[null,"J1.8XN_M/LWB 4-whl",625]
[null,"J2.0XNT_M/LWB 3-whl",575]
[null,"J2.0XNT_M/LWB 3-whl",625]
[null,"J2.0XN_LWB 4-whl",690]
[null,"J2.2XN",560]
[null,"J2.5XN",560]
[null,"J3.0XN",620]
[null,"J3.5XN",620]
[null,"J4.0XN",840]
[null,"J4.5XN",840]
[null,"J5.0XN",840]
[null,"J5.5XN6",840]
[null,"J1.5XNT_SWB 3-whl",500]
[null,"J1.6XNT_SWB 3-whl",500]
[null,"J1.6XNT_M/LWB 3-whl",690]
[null,"J1.6XNT_M/LWB 3-whl",750]
[null,"J1.6XN_M/LWB 4-whl",690]
[null,"J1.6XN_M/LWB 4-whl",750]
[null,"J1.8XNT_M/LWB 3-whl",690]
[null,"J1.8XNT_M/LWB 3-whl",750]
[null,"J1.8XN_M/LWB 4-whl",690]
[null,"J1.8XN_M/LWB 4-whl",750]
[null,"J2.0XNT_M/LWB 3-whl",690]
[null,"J2.0XNT_M/LWB 3-whl",750]
[null,"J2.0XN_LWB 4-whl",750]
[null,"J2.2XN",620]
[null,"J2.5XN",620]
[null,"J2.5XN",770]
[null,"J3.0XN",700]
[null,"J3.5XN",700]
[null,"J3.0XN",775]
[null,"J3.5XN",775]
[null,"J4.0XN",930]
[null,"J4.5XN",930]
[null,"J5.0XN",930]
[null,"J5.5XN",930]
[]
[]
[]
[null,null,"to add new truck options to the tool, insert rows above this entire row"]
[]
[]
["Table D: Li-Ion Batteries by Truck model"]
[]
[]
[null,"Truck Model                                       (write exactly as you wish the names to appear to the user) - write each truck model only once","Battery Capacity (Ah)",null,null,null,null,"LiBatD"]
[null,"Select","Select",null,null,null,null,{"$f":"IFERROR(INDEX(LiBat,MATCH(0,COUNTIF($H$159:H159,LiBat)+(LiTrucks<>Inputs!$F$56),0)),\"\")","v":450}]
[null,"J1.5XNT_SWB 3-whl",300,null,null,null,null,{"$f":"IFERROR(INDEX(LiBat,MATCH(0,COUNTIF($H$159:H160,LiBat)+(LiTrucks<>Inputs!$F$56),0)),\"\")","v":600}]
[null,"J1.6XNT_SWB 3-whl",300,null,null,null,null,{"$f":"IFERROR(INDEX(LiBat,MATCH(0,COUNTIF($H$159:H161,LiBat)+(LiTrucks<>Inputs!$F$56),0)),\"\")","v":""}]
[null,"J1.6XNT_M/LWB 3-whl",300,null,null,null,null,{"$f":"IFERROR(INDEX(LiBat,MATCH(0,COUNTIF($H$159:H162,LiBat)+(LiTrucks<>Inputs!$F$56),0)),\"\")","v":""}]
[null,"J1.6XNT_M/LWB 3-whl",450,null,null,null,null,{"$f":"IFERROR(INDEX(LiBat,MATCH(0,COUNTIF($H$159:H163,LiBat)+(LiTrucks<>Inputs!$F$56),0)),\"\")","v":""}]
[null,"J1.6XN_M/LWB 4-whl",300]
[null,"J1.6XN_M/LWB 4-whl",450,null,null,null,null,{"$f":"IFERROR(INDEX(LiBat,MATCH(0,COUNTIF($H$159:H164,LiBat)+(LiTrucks<>Inputs!$F$56),0)),\"\")","v":""}]
[null,"J1.8XNT_M/LWB 3-whl",300]
[null,"J1.8XNT_M/LWB 3-whl",450,null,null,null,null,{"$f":"IFERROR(INDEX(LiBat,MATCH(0,COUNTIF($H$159:H166,LiBat)+(LiTrucks<>Inputs!$F$56),0)),\"\")","v":""}]
[null,"J1.8XN_M/LWB 4-whl",300]
[null,"J1.8XN_M/LWB 4-whl",450]
[null,"J2.0XNT_M/LWB 3-whl",300]
[null,"J2.0XNT_M/LWB 3-whl",450]
[null,"J2.0XN_LWB 4-whl",300]
[null,"J2.0XN_LWB 4-whl",450]
[null,"J2.2XN",450]
[null,"J2.5XN",450]
[null,"J3.0XN",450]
[null,"J3.5XN",450]
[null,"J4.0XN",600]
[null,"J4.5XN",600]
[null,"J5.0XN",600]
[null,"J5.5XN",600]
[null,"J1.5XNT_SWB 3-whl",400]
[null,"J1.6XNT_SWB 3-whl",400]
[null,"J1.6XNT_M/LWB 3-whl",600]
[null,"J1.6XN_M/LWB 4-whl",600]
[null,"J1.8XNT_M/LWB 3-whl",600]
[null,"J1.8XN_M/LWB 4-whl",600]
[null,"J2.0XNT_M/LWB 3-whl",600]
[null,"J2.0XN_LWB 4-whl",600]
[null,"J2.2XN",600]
[null,"J2.5XN",600]
[null,"J3.0XN",600]
[null,"J3.5XN",600]
[]
[]
[]
[]
[]
[]
["Table E: Lead battery chemistry"]
[]
[]
[null,"Voltage (V) (keep similar voltages in the same section","Pb battery (Ah)","Cell type number","Cell Type (PzS/PzB)"]
[null,"Select","Select",0,"PzB"]
[null,48,420,4,"PzS"]
[null,48,465,3,"PzS"]
[null,48,500,4,"PzS"]
[null,48,560,4,"PzS"]
[null,48,575,5,"PzS"]
[null,48,620,4,"PzS"]
[null,48,625,5,"PzS"]
[null,48,690,6,"PzS"]
[null,48,700,5,"PzS"]
[null,48,750,6,"PzS"]
[null,48,775,5,"PzS"]
[null,48,840,6,"PzS"]
[null,48,930,6,"PzS"]
[null,"to add new truck options to the tool, insert rows above this entire row"]
[null,80,560,4,"PzS"]
[null,80,620,4,"PzS"]
[null,80,700,5,"PzS"]
[null,80,775,5,"PzS"]
[null,80,840,6,"PzS"]
[null,80,930,6,"PzS"]
[null,"to add new truck options to the tool, insert rows above this entire row"]
[]
[null,"to add new truck options to the tool, insert rows above this entire row"]
[]
[null,"to add new truck options to the tool, insert rows above this entire row"]
[]
[]
["Table F: voltages of batteries"]
[]
[]
[null,"Pb voltage equivalent (V)","Li voltage equivalent (V)"]
[null,"Select","Select"]
[null,24,25.6]
[null,48,51.2]
[null,80,76.8]
[null,350,350]
[]
[]
[]
[]
["Table G: Hidrogen sources / price factor or efficiency"]
[]
[]
[null,"H2 Source","Infrastructure","Annual fees","Efficiency (kWh/kg H2)","H2 (€/kg)","CO2 emissions (kg/kW)"]
[null,"Select",null,null,0,0,0]
[null,"MCP","Booster and dispenser","Bottles",67,{"$f":"Inputs!$F$32*E251","v":6.0299999999999994},10,"03/10/18: mail sent by Gianpaolo Sibila, was 31.8 €/kg"]
[null,"Tanker","Tanker hardstand","Trailer",125,{"$f":"Inputs!$F$32*E252","v":11.25},10]
[null,"McPhy Simole fuel","Hydrogen generator","Maintenance",75,{"$f":"Inputs!$F$32*E253","v":6.75},20]
[]
[]
[]
[]
[]
[]
["Table H: Lithion-Ion Chargers"]
[]
[]
[null,"Type","V","A","Phase Current A (±10%)","Max Input Power (kVA)","Power Check",null,null,"LiChargeAD",null,"Voltage","Power Check"]
[null,null,"Select","Select",null,null,{"$f":"IF(Inputs!$F$84<>\"Select\",IF((Inputs!$F$84/D264>1),1,0),1)","v":{"$error":"#VALUE!"}}]
[null,"HE Li-Ion 1-B M IP54* ",48,70,15.1,3.5,{"$f":"IF(Inputs!$F$84<>\"Select\",IF((Inputs!$F$84/D265>1),1,0),0)","v":1},null,null,{"$f":"IFERROR(INDEX(LiChargeA,MATCH(0,COUNTIF($J$263:J263,LiChargeA)+(LiChargeV<>$L$265)+(LiChargeTest<>$M$265),0)),\"\")","v":160},null,{"$f":"VLOOKUP(Inputs!F56,Trucks!B78:D97,2,FALSE)","v":80},1]
[null,"HE Li-Ion 3-A T IP54* ",48,150,14.4,10,{"$f":"IF(Inputs!$F$84<>\"Select\",IF((Inputs!$F$84/D266>1),1,0),0)","v":1},null,null,{"$f":"IFERROR(INDEX(LiChargeA,MATCH(0,COUNTIF($J$263:J265,LiChargeA)+(LiChargeV<>$L$265)+(LiChargeTest<>$M$265),0)),\"\")","v":250}]
[null,"HE Li-Ion 12/48-250 T IP54 ",48,250,23.3,16.100000000000001,{"$f":"IF(Inputs!$F$84<>\"Select\",IF((Inputs!$F$84/D267>1),1,0),0)","v":1},null,null,{"$f":"IFERROR(INDEX(LiChargeA,MATCH(0,COUNTIF($J$263:J266,LiChargeA)+(LiChargeV<>$L$265)+(LiChargeTest<>$M$265),0)),\"\")","v":320}]
[null,"HE Li-Ion 12/48-320 T IP54 ",48,320,29.9,20.7,{"$f":"IF(Inputs!$F$84<>\"Select\",IF((Inputs!$F$84/D268>1),1,0),0)","v":1},null,null,{"$f":"IFERROR(INDEX(LiChargeA,MATCH(0,COUNTIF($J$263:J267,LiChargeA)+(LiChargeV<>$L$265)+(LiChargeTest<>$M$265),0)),\"\")","v":500}]
[null,"HE Li-Ion 12/48-500 T IP54 ",48,500,46.7,32.299999999999997,{"$f":"IF(Inputs!$F$84<>\"Select\",IF((Inputs!$F$84/D269>1),1,0),0)","v":1},null,null,{"$f":"IFERROR(INDEX(LiChargeA,MATCH(0,COUNTIF($J$263:J268,LiChargeA)+(LiChargeV<>$L$265)+(LiChargeTest<>$M$265),0)),\"\")","v":""}]
[null,"HE Li-Ion 12/80-160 T IP54 ",80,160,24.6,17,{"$f":"IF(Inputs!$F$84<>\"Select\",IF((Inputs!$F$84/D270>1),1,0),0)","v":1},null,null,{"$f":"IFERROR(INDEX(LiChargeA,MATCH(0,COUNTIF($J$263:J269,LiChargeA)+(LiChargeV<>$L$265)+(LiChargeTest<>$M$265),0)),\"\")","v":""}]
[null,"HE Li-Ion 12/80-250 T IP54 ",80,250,38.5,26.6,{"$f":"IF(Inputs!$F$84<>\"Select\",IF((Inputs!$F$84/D271>1),1,0),0)","v":1},null,null,{"$f":"IFERROR(INDEX(LiChargeA,MATCH(0,COUNTIF($J$263:J270,LiChargeA)+(LiChargeV<>$L$265)+(LiChargeTest<>$M$265),0)),\"\")","v":""}]
[null,"HE Li-Ion 12/80-320 T IP54 ",80,320,49.2,34.1,{"$f":"IF(Inputs!$F$84<>\"Select\",IF((Inputs!$F$84/D272>1),1,0),0)","v":1},null,null,{"$f":"IFERROR(INDEX(LiChargeA,MATCH(0,COUNTIF($J$263:J271,LiChargeA)+(LiChargeV<>$L$265)+(LiChargeTest<>$M$265),0)),\"\")","v":""}]
[null,"HE Li-Ion 12/80-500 T IP54 ",80,500,76.900000000000006,53.2,{"$f":"IF(Inputs!$F$84<>\"Select\",IF((Inputs!$F$84/D273>1),1,0),0)","v":1},null,null,{"$f":"IFERROR(INDEX(LiChargeA,MATCH(0,COUNTIF($J$263:J272,LiChargeA)+(LiChargeV<>$L$265)+(LiChargeTest<>$M$265),0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(LiChargeA,MATCH(0,COUNTIF($J$263:J273,LiChargeA)+(LiChargeV<>$L$265)+(LiChargeTest<>$M$265),0)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(LiChargeA,MATCH(0,COUNTIF($J$263:J274,LiChargeA)+(LiChargeV<>$L$265)+(LiChargeTest<>$M$265),0)),\"\")","v":""}]
[]
[]
["Table H: LPG Bottles"]
[]
[null,"LPG Bottles"]
[null,"Select"]
[null,3.9]
[null,6]
[null,11]
[null,18]
[null,19]
[null,47]
[]
[]
[]
[null,"KG h2 Storage ","*** Needs updated I don’t have info on US Fuel cell H2 Capacity"]
[null,0.9,"48v "]
[null,1.5,"80v"]

{"sheet":"Output","index":2,"n_rows":251,"n_cols":8,"rows_kept":251,"cut":false,"hidden":false,"merged":[[240,1,250,5],[150,1,151,1],[150,3,150,5],[12,2,12,3],[25,2,25,3],[37,2,37,3],[58,2,58,3],[37,1,38,1],[66,2,66,3],[12,1,13,1],[25,1,26,1],[58,1,59,1],[66,1,67,1]]}
[]
[null,{"$f":"\"TCO Comparison Tool Counterbalance Output Page \"&TEXT(TODAY(),\"dd-mmm-yy\")","v":"TCO Comparison Tool Counterbalance Output Page 31-Mar-20"}]
[]
[]
[]
[null,"ICE Truck Model",{"$f":"Inputs!F38","v":"H2.5FT"}]
[null,"Electric Truck Model",{"$f":"Inputs!F56","v":"J2.5XN"}]
[null,"Fleet Size",{"$f":"Inputs!F27","v":10}]
[null,"Truck Hours per Year ",{"$f":"Inputs!F21","v":3000}]
[]
[null,"Initial Investment (Fleet)"]
[]
[null,"Initial Investment","Electric",null,"ER CB","ICE"]
[null,null,"Lead Acid","Li-Ion","Fuel Cell",{"$f":"Inputs!F39","v":"Diesel"}]
[null,"Truck/s",{"$f":"Calc1!D75","v":337000},{"$f":"Calc1!E75","v":337000},{"$f":"Calc1!F75","v":337000},{"$f":"Calc1!G75","v":360000}]
[null,"Batteries / Power Cells",{"$f":"Calc1!D76","v":140000},{"$f":"Calc1!E76","v":200000},{"$f":"Calc1!F76","v":200000},{"$f":"Calc1!G76","v":0}]
[null,"Infrastructure / Installation",{"$f":"Calc1!D77","v":0},{"$f":"Calc1!E77","v":0},{"$f":"Calc1!F77","v":50000},{"$f":"Calc1!G77","v":0}]
[null,"Charger",{"$f":"Calc1!D78","v":12000},{"$f":"Calc1!E78","v":37500},{"$f":"Calc1!F78","v":0},{"$f":"Calc1!G78","v":0}]
[null,"Charger room",{"$f":"Calc1!D79","v":0},{"$f":"Calc1!E79","v":0},{"$f":"Calc1!F79","v":0},{"$f":"Calc1!G79","v":0}]
[null,"Total Initial investment",{"$f":"SUM(C15:C19)","v":489000},{"$f":"SUM(D15:D18)","v":574500},{"$f":"SUM(E15:E18)","v":587000},{"$f":"SUM(F15:F18)","v":360000}]
[]
[]
[]
[null,"Annual Operational Costs (per Truck)"]
[]
[null,"Annual Operational Costs (per Truck)","Electric",null,"ER CB","ICE"]
[null,null,"Lead Acid","Li-Ion","Fuel Cell",{"$f":"Inputs!F39","v":"Diesel"}]
[null,"Fuel/Energy consumption",{"$f":"Calc1!D83","v":3821.6712417637791},{"$f":"Calc1!E83","v":2588.039654145437},{"$f":"IF( Inputs!F96>0, Calc1!F83, \"\")","v":4248.6342342342341},{"$f":"Calc1!G83","v":10088.623999999998}]
[null,{"$f":"Calc1!C86","v":"Lost productivity"},{"$f":"Calc1!D86","v":0},{"$f":"Calc1!E86","v":0},{"$f":"Calc1!F86","v":0},{"$f":"Calc1!G86","v":0}]
[null,"Refueling / Battery change costs",{"$f":"Calc1!D85","v":3588.6647727272721},{"$f":"IF(Inputs!F84<>\"Select\", Calc1!E85, \"\")","v":720},{"$f":"IF(Inputs!F96>0, Calc1!F85, \"\")","v":1490.7488541172752},{"$f":"Calc1!G85","v":1492.3999999999996}]
[null,"Truck & Batt maintenance & service costs  per year",{"$f":"Calc1!D87","v":2050},{"$f":"Calc1!E87","v":1850},{"$f":"Calc1!F87","v":2650},{"$f":"Calc1!G87","v":3397.5}]
[null,"Total Annual Operational Costs (per Truck)",{"$f":"SUM(C28:C31)","v":9460.3360144910512},{"$f":"SUM(D28:D31)","v":5158.0396541454375},{"$f":"SUM(E28:E31)","v":8389.3830883515093},{"$f":"SUM(F28:F31)","v":14978.523999999998}]
[]
[]
[]
[null,"Cumulative Investment & Operational Costs (Fleet)"]
[]
[null,"Year","Electric",null,"ER CB","ICE"]
[null,null,"Lead Acid","Li-Ion","Fuel Cell",{"$f":"Inputs!F39","v":"Diesel"}]
[null,0,{"$f":"Calc1!D126","v":489000},{"$f":"Calc1!E126","v":574500},{"$f":"Calc1!F126","v":587000},{"$f":"Calc1!G126","v":360000}]
[null,1,{"$f":"Calc1!D127","v":713071.06014491047},{"$f":"Calc1!E127","v":758493.09654145432},{"$f":"IF(Inputs!F96>0, Calc1!F127, \"\")","v":795281.53088351502},{"$f":"Calc1!G127","v":586825.24}]
[null,2,{"$f":"Calc1!D128","v":902307.53811982099},{"$f":"Calc1!E128","v":911857.26091290871},{"$f":"IF(Inputs!F96, Calc1!F128, \"\")","v":974651.47959703009},{"$f":"Calc1!G128","v":797163.91999999993}]
[null,3,{"$f":"Calc1!D129","v":1066242.3786480885},{"$f":"Calc1!E129","v":1041702.1265377201},{"$f":"IF(Inputs!F96, Calc1!F129, \"\")","v":1131851.9666639022},{"$f":"Calc1!G129","v":994544.16383999994}]
[null,4,{"$f":"Calc1!D130","v":1211754.2604358452},{"$f":"Calc1!E130","v":1153481.4896332207},{"$f":"IF(Inputs!F96, Calc1!F130, \"\")","v":1272047.9231620636},{"$f":"Calc1!G130","v":1181739.0768582399}]
[null,5,{"$f":"Calc1!D131","v":1343819.2911061745},{"$f":"Calc1!E131","v":1251380.190718502},{"$f":"IF(Inputs!F96, Calc1!F131, \"\")","v":1399197.1416110371},{"$f":"Calc1!G131","v":1360928.3198505763}]
[null,6,{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}},{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}},{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}},{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}}]
[null,7,{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}},{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}},{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}},{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}}]
[null,8,{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}},{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}},{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}},{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}}]
[null,9,{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}},{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}},{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}},{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}}]
[null,10,{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}},{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}},{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}},{"$f":"Calc1!#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Estimated Break-even Point (Years over ICE)",{"$f":"IF((Calc1!D139-Calc1!G139)/Inputs!F27/(F32-C32)<0,\"n.a.\",IF((Calc1!D139-Calc1!G139)/Inputs!F27/(F32-C32)>5,\"more than 5.\",IF((AND((Calc1!D139-Calc1!G139)/Inputs!F27/(F32-C32)>0,(Calc1!D139-Calc1!G139)/Inputs!F27/(F32-C32)<1)),\"less than 1 year\",(Calc1!D139-Calc1!G139)/Inputs!F27/(F32-C32))))","v":4.1452810550703969},{"$f":"IF((Calc1!E139-Calc1!G139)/Inputs!F27/(F32-D32)<0, \"n.a.\", IF((AND((Calc1!E139-Calc1!G139)/Inputs!F27/(F32-D32)>0, (Calc1!E139-Calc1!G139)/Inputs!F27/(F32-D32)<1)), \"less than 1 year\", (Calc1!E139-Calc1!G139)/Inputs!F27/(F32-D32)))","v":3.3985820595042333},{"$f":"IF((Calc1!F139-Calc1!G139)/Inputs!F27/(F32-E32)<0, \"n.a.\", IF((AND((Calc1!F139-Calc1!G139)/Inputs!F27/((F32-E32))>0, (Calc1!F139-Calc1!G139)/Inputs!F27/((F32-E32))<1)), \"less than 1 year\", (Calc1!F139-Calc1!G139)/Inputs!F27/((F32-E32))))","v":4.9784956191069085}]
[null,"Break even Point (Years over Lead Acid)",null,{"$f":"IF((D20-C20)/Inputs!F27/(C32-D32)<0, \"n.a.\", (D20-C20)/Inputs!F27/(C32-D32))","v":1.9873107949525723},{"$f":"IF((E20-D20)/Inputs!F27/(D32-E32)<0, \"n.a.\", (E20-D20)/Inputs!F27/(D32-E32))","v":"n.a."}]
[null,"Truck and power source depreciation start at year1, depreciating over 5 a year period based on predicted depreciation rates"]
[]
[]
[null,"Application Summary (Fleet)"]
[]
[null,"Annual information","Electric",null,"ER CB","ICE"]
[null,null,"Lead Acid","Li-Ion","Fuel Cell",{"$f":"Inputs!F39","v":"Diesel"}]
[null,"Max Power required when charging","n.a.",{"$f":"Calc1!E147","v":399},"n.a.","n.a."]
[null,"Fleet fuel/energy consumption",{"$f":"Calc1!D148","v":398309.45945945929},{"$f":"Calc1!E148","v":275788.53801169584},{"$f":"IF(Inputs!F96, Calc1!F148, \"\")","v":14162.114114114112},{"$f":"TEXT(Calc1!G148,\"0\")&IF(F39=\"Diesel\",\" L\",IF(F39=\"LPG\",\" kg\",\"\"))","v":"77605 L"}]
[]
[]
[null,"Carbon Emissions per Truck/Year"]
[]
[null,"Carbon Emissions (kg CO2)","Electric",null,"ER CB","ICE ***"]
[null,null,"Lead Acid *","Li-Ion*","Fuel Cell**",{"$f":"Inputs!F39","v":"Diesel"}]
[null,"Emissions @ energy source",{"$f":"Calc1!D92","v":21520.978742162155},{"$f":"Calc1!E92","v":14901.075339602339},{"$f":"Calc1!F92","v":53532.791351351341},{"$f":"Calc1!G92","v":6078.9803334939743}]
[null,"Emissions estimate @ truck",{"$f":"Calc1!D93","v":0},{"$f":"Calc1!E93","v":0},{"$f":"Calc1!F93","v":0},{"$f":"Calc1!G93","v":20480.682767999995}]
[null,"Total Carbon Emissions",{"$f":"SUM(C69:C70)","v":21520.978742162155},{"$f":"SUM(D69:D70)","v":14901.075339602339},{"$f":"SUM(E69:E70)","v":53532.791351351341},{"$f":"SUM(F69:F70)","v":26559.66310149397}]
[null,"* CO2 emission at power station based on ISO std value EN 16796"]
[null,"** Assume H2 generated using electrolizer"]
[]
[]
[]
[]
[null,"Li-ion Daily State of Charge Profile"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Page 1/2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Lost Productivity due to refuelling/change over",null,null,null,null,null,"** costs are included in the graph above"]
[]
[null,"Lost/hrs/fleet/year",{"$f":"Calc1!G154*Inputs!F27","v":497.46666666666658},{"$f":"Calc1!D154*Inputs!F27","v":1196.2215909090905},{"$f":"Calc1!E154*Inputs!F27","v":240},{"$f":"Calc1!F154*Inputs!F27","v":496.91628470575836}]
[null,"Cost of Lost productivity/truck/year",{"$f":"Calc1!G165","v":1492.3999999999996},{"$f":"Calc1!D165","v":3588.6647727272721},{"$f":"Calc1!E165","v":720},{"$f":"Calc1!F165","v":1490.7488541172752}]
[null,"cost of lost productivity/fleet/year",{"$f":"Calc1!G166","v":44771.999999999985},{"$f":"Calc1!D166","v":35886.647727272721},{"$f":"Calc1!E166","v":7200},{"$f":"Calc1!F166","v":14907.488541172752}]
[]
[null,"Pallets moved based on Performance mode"]
[null,{"$f":"Calc1!C160","v":"No of pallets moved/truck/year /FLEET (assume 20/hr)"},{"$f":"Calc1!G160","v":655999.99999999977},{"$f":"Calc1!D160","v":655999.99999999977},{"$f":"Calc1!E160","v":655999.99999999977},{"$f":"Calc1!F160","v":655999.99999999977}]
[]
[null,"Cumulative Costs"]
[]
[null,"Year","ICE Trucks","ECB Trucks"]
[null,null,{"$f":"Calc2!#REF!","v":{"$error":"#REF!"}},"Lead Acid","Li-Ion","Fuel Cell"]
[null,0,{"$f":"F40","v":360000},{"$f":"C40","v":489000},574500,587000]
[null,1,586825.24,713071.06014491047,758493.09654145432,795281.53088351502]
[null,2,797163.91999999993,902307.53811982099,911857.26091290871,974651.47959703009]
[null,3,994544.16383999994,1066242.3786480885,1041702.1265377201,1131851.9666639022]
[null,4,1181739.0768582399,1211754.2604358452,1153481.4896332207,1272047.9231620636]
[null,5,1360928.3198505763,1343819.2911061745,1251380.190718502,1399197.1416110371]
[]
[null,"Break even Point (Years)",null,{"$f":"(C232-F232)/Inputs!F88/(C140-D140)","v":{"$error":"#VALUE!"}},{"$f":"(D232-F232)/Inputs!F88/(C140-E140)","v":{"$error":"#VALUE!"}},{"$f":"(E20-F232)/Inputs!F88/(C140-F140)","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"C14","v":"Lead Acid"},{"$f":"D14","v":"Li-Ion"},{"$f":"E14","v":"Fuel Cell"},{"$f":"F14","v":"Diesel"}]
[null,{"$f":"B20","v":"Total Initial investment"},{"$f":"C20","v":489000},{"$f":"D20","v":574500},{"$f":"E20","v":587000},{"$f":"F20","v":360000}]
[null,{"$f":"B28","v":"Fuel/Energy consumption"},{"$f":"C28","v":3821.6712417637791},{"$f":"D28","v":2588.039654145437},{"$f":"E28","v":4248.6342342342341},{"$f":"F28","v":10088.623999999998}]
[null,{"$f":"B30","v":"Refueling / Battery change costs"},3588.6647727272721,720,1490.7488541172752,1492.3999999999996]
[null,"Truck & Batt maintenance & service costs  per year",2050,1850,2650,3397.5]
[]
[null,"Truck and power source depreciating starting at year1, depreciating over a 5 year period based on predicted rates"]
[]
[]
[null,"THE TCO COMPARISON TOOL USES GENERIC DATA AND TECHNICAL DATA FROM HYSTER-YALE GROUP (HYG) AND ITS SUPPLIERS TO MODEL THE PERFORMANCE OF FORKLIFT TRUCKS AND THE DIFFERENT POWER OPTIONS SUPPLIED BY HYG. BASED ON USER INPUTS IT CALCULATES THE PERFORMANCE OF THE EQUIPMENT IN TYPICAL MATERIALS HANDLING APPLICATIONS. WHILE HYG HAS ENDEAVOURED TO ENSURE ITS ACCURACY, HYG CANNOT GUARANTEE THAT THE RESULTS GENERATED WILL BE ACCURATE OR CORRECT FOR A SPECIFIC CUSTOMER OR APPLICATION. FURTHER, THE PERFORMANCE OF THE TOOL RELIES ON THE USER PROVIDING COMPLETE AND ACCURATE INPUTS. RESULTS GENERATED BY THE TOOL MAY BE COMPROMISED IF INCOMPLETE OR INACCURATE INPUTS ARE USED. THE TOOL PROVIDES ESTIMATES ONLY, AND SHOULD NOT BE RELIED UPON TO ACCURATELY FORECAST OR PREDICT RESULTS IN ACTUAL USE OF MATERIALS HANDLING EQUIPMENT. HYG  EXPRESSLY DISCLAIMS AND EXCLUDES ANY LIABILITY FOR LOSS OR DAMAGE HOWEVER CAUSED, WHETHER DIRECT OR INDIRECT, THAT MAY RESULT FROM USE OF THE COMPARISON TOOL OR RELIANCE ON ITS RESULTS.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Page 2/2"]

{"sheet":"Calc2","index":3,"n_rows":168,"n_cols":101,"rows_kept":168,"cut":false,"hidden":true,"merged":[]}
[null,"Calculation"]
[null,"Driven from input (Adjustable)"]
[null,"Adjustable  Only to selected users"]
[]
[null,"Application"]
[null,"Weeks per year",48]
[null,"Voltage of truck",{"$f":"VLOOKUP(Inputs!F56,Trucks!B78:D97,2,FALSE)","v":80}]
[null,"RecommendedVDI",{"$f":"VLOOKUP(Inputs!F56,Trucks!B78:D97,3,FALSE)","v":"7,9"}]
[null,"recommended idle time",20]
[null,"DEFAULT values ( Not used unless se;ection on input page not used)"]
[null,"Cost electricity (€/kWh)",0.12]
[null,"Dsl Default Value",1]
[null,"LPG Default value",0.7]
[null,"Cost H2 (€/kg)",{"$f":"Inputs!F33","v":3}]
[null,"Hourly Rate Driver",30]
[null,"ENTERED INFO @ INPUT page"]
[null,"Cost electricity",{"$f":"IF(Inputs!F32=0,Calc2!C11,Inputs!F32)","v":0.09}]
[null,"Fuel Cost (€/lt or €/kg)",{"$f":"IF(C19=\"Diesel\",IF(Inputs!F30=0,Calc2!C12,Inputs!F30),IF(C19=\"LPG\",IF(Inputs!F31=0,Calc2!C13,Inputs!F31)))","v":1.3}]
[null,"Selected Fuel",{"$f":"Inputs!F39","v":"Diesel"}]
[null,"Cost H2 (€/kg)",{"$f":"IF(Inputs!F33=0,Calc2!C14,Inputs!F33)","v":3}]
[null,"Hourly rate driver",{"$f":"IF(Inputs!F29=0,Calc2!C15,Inputs!F29)","v":30}]
[null,"ICE Trucks"]
[null,"Fuel",{"$f":"Inputs!F39","v":"Diesel"}]
[null,"Tank size lpg (kg) (Dsl L)",{"$f":"IF(C23=\"Diesel\",Trucks!M5,IF(C23=\"LPG\",Inputs!F45,0))","v":52}]
[null,null,"Cost (Euro)","Hrs"]
[null,"DPF Cleaning costs",530,4000]
[null,"Electric trucks"]
[null,"CO2 production per energy from grid (kg/kWh)",0.54030800000000001,"As per standard EN 16796.  - is German reference and based on the mix of the German different electricity generation systems."]
[null,"battery in-truck connection time (mins)",4,"** only used when 1 LA battery ( connection time us inclouded in the over all battery change time when there are 2 batteries )"]
[]
[null,"Diesel Carbon Emission"]
[]
[null,"Calorific value of Dsl Kwh/Kg",12.04]
[null,"Density L/Kg Dsl",0.83]
[null,"Carbon emission  KG/Litre Dsl At point of use ",2.6391,"https://www.gov.uk/government/uploads/system/uploads/attachment_data/file/715425/Conversion_Factors_2018_-_Condensed_set__for_most_users__v01-01.xls"]
[]
[null,"CO2 Well to Pump Calculation"]
[null,"Convert Mj/Kwh",3.6,"Mj/Kwh"]
[null,null,{"$f":"C33/C34","v":14.506024096385541},"Kwh/Liter"]
[null,null,{"$f":"C38*C39","v":52.221686746987949},"MJ/Liter Dsl"]
[null,"@",15,"grCO2eq/MJ "]
[null,null,{"$f":"C41*C40","v":783.3253012048192},"GCO2/Liter"]
[null,"Well to pump",{"$f":"C42/1000","v":0.78332530120481925},"KgCo2/Liter"]
[]
[]
[]
[null,"LPG"]
[null,"Calorific value of LPG  Kwh/Kg",13.69]
[null,"Carbon emission  KG/Litre LPG at point of use",1.5170300000000001,"KgCo2/Liter"]
[null,"Density L/Kg LPG",0.51]
[null,"Carbon emission KgCO2/Kg at point of use",{"$f":"C49*C50","v":0.77368530000000002},"KgCO2/Kg"]
[]
[null,"CO2 Well to Pump Calculation"]
[null,"Convert Mj/Kwh",3.6,"Mj/Kwh"]
[null,null,{"$f":"C48/C50","v":26.843137254901958},"Kwh/Liter"]
[null,null,{"$f":"C54*C55","v":96.635294117647049},"MJ/Liter Dsl"]
[null,"@",18,"grCO2eq/MJ "]
[null,null,{"$f":"C57*C56","v":1739.4352941176469},"GCO2/Liter"]
[null,"Well to pump",{"$f":"C58/1000","v":1.739435294117647},"KgCo2/Liter"]
[null,"Carbon emission KgCo2/Kg  Well to pump",{"$f":"C59*C50","v":0.88711200000000001},"KgCO2/Kg"]
[]
[]
[]
[null,"Lead acid"]
[null,"maximum DOD (%)",80]
[null,"Charger factor (new, flooded)",1,"(not used per direction battery Manf literature)"]
[]
[null,"Charger type","Select","50 Hz","High Frequency"]
[null,"Charger Efficiency (look up table)",0,0.8,0.9]
[null,"Charger efficiency",{"$f":"HLOOKUP(Inputs!F66,Calc2!C68:E69,2,FALSE)","v":0.8}]
[null,"Battery Efficiency",0.74]
[null,"existing facility?","Select","Yes","No"]
[null,"Lithium ion"]
[null,"Available energy from battery %",85]
[null,"Truck maximum DOD allowed AS PERCENTAGE OF USEABLE ENERGY ",4]
[null,"Useable energy as % of Nominal ",{"$f":"Calc2!C74/100*(100-Calc2!C75)","v":81.599999999999994}]
[null,"Charger voltage",{"$f":"VLOOKUP(Calc2!C7,Calc2!B122:D129,3,FALSE)","v":76.8}]
[null,"Phase Current ± 10% (A)",{"$f":"IF(Calc2!$C$7=48,VLOOKUP(Inputs!F85,Trucks!D265:F269,2,FALSE),IF(Calc2!$C$7=80,VLOOKUP(Inputs!F85,Trucks!D270:F274,2,FALSE),\"\"))","v":76.900000000000006}]
[null,"Max Input Power (kVA)",{"$f":"IF(Calc2!$C$7=48,VLOOKUP(Inputs!F85,Trucks!D265:F269,3,FALSE),IF(Calc2!$C$7=80,VLOOKUP(Inputs!F85,Trucks!D270:F274,3,FALSE),\"\"))","v":53.2}]
[null,"Li ion Battery efficiency",0.95,"supplied by midac via email 31/7/17 'efficiency generally recognised for LFP batteries\""]
[null,"Charger Efficiencies",0.9,"supplied by midac via email 31/7/17 "]
[null,"Charging connection time (mins)",1]
[null,"Charger Factor",1,"Not used per direction form battery manufacturer"]
[null,"Travel plus return time to charging point",0,"Not used -  travel time is included in break times"]
[null,"Fuel Cell"]
[null,"Maximum DOD (%)",0.95]
[null,"Cell effective capacity (Ah)",{"$f":"ROUND(C88*1000/C7,0)","v":624},"I=P/V"]
[null,"Cell effective capacity (kWh)",{"$f":"Calc2!C89*Calc2!C90","v":49.949999999999996}]
[null,"H2 per fill (kg)",{"$f":"IF(C7=48,Trucks!B292,IF(C7=80,Trucks!B293,0))","v":1.5}]
[null,"Conversion rate: kWh/kg H2",33.299999999999997]
[null,"Cell efficiency (kW per kg H2)",0.5]
[null,"kg CO2 / kg H2 generated",37.799999999999997,"per Giampaolo email =  electrolizers normally around 70kwh/KgH2      example elec from grid produce .54 Kg Co2/Kwh * 70 =  37.8KgCo2/KgH2"]
[null,"Annual service charge - Power cell",500]
[null,"Annual inspection cost per Fuel Cell",350]
[null,"Depreciation","Value lost after 5 years","CAGR","https://www.investopedia.com/calculator/cagr.aspx"]
[null,"ICE truck",0.7,0.214]
[null,"ER Truck",0.75,0.24210000000000001]
[null,"LA Battery/chrger",0.85,0.315]
[null,"LIB Battery/charger",0.7,0.214]
[null,"Fuel Cell",0.7,0.214]
[null,"Battery Degrogation","Over 5 years","Nominal Av ov 5 yrs"]
[null,"LA",0.15,3.2000000000000001E-2]
[null,"LIB",0.1,2.0899999999999998E-2]
[null,"Service PIB Battery"]
[null,"Annual inspection cost per battery EUR",100,"Estimated"]
[null,"Water usage for top up ",50,"Estimated based on # hrs"]
[null,"Monthly Battery & Charger Service charge/unit",0]
[null,"Service LIB Battery"]
[null,"Annual inspection cost per battery EUR",50,"Estimated"]
[null,"Charger Room Estimates"]
[null,"water topup system per truck (EUR)",100]
[null,"Protection cost per truck (EUR)",50]
[null,"Equipment cost per truck (EUR)",1200]
[null,"Ventilation cost per truck (EUR)",200]
[null,"charging space per truck (m2)",3.5]
[null,"price per m2 over 5 years (EUR/m2)",{"$f":"60*5","v":300}]
[]
[null,"price per truck charging area (EUR)",{"$f":"C115*C116+C111+C114+C112+C113","v":2600}]
[]
[null,"Addition Info / Look ups"]
[null,"Chager Voltage (V) per battery"]
[null,"Pb voltage equivalent (V)                  if you want to change figures in this row, do so on the 'Trucks' tab","Li voltage equivalent (V)                          if you want to change figures in this row, do so on the 'Trucks' tab","Li Charger Voltage"]
[null,{"$f":"Trucks!B237","v":"Select"},{"$f":"Trucks!C237","v":"Select"},"Select"]
[null,{"$f":"Trucks!B238","v":24},{"$f":"Trucks!C238","v":25.6},25.6]
[null,{"$f":"Trucks!B239","v":48},{"$f":"Trucks!C239","v":51.2},51.2]
[null,{"$f":"Trucks!B240","v":80},{"$f":"Trucks!C240","v":76.8},76.8]
[null,{"$f":"Trucks!B241","v":350},{"$f":"Trucks!C241","v":350},350]
[null,{"$f":"Trucks!B242","v":0},{"$f":"Trucks!C242","v":0},0]
[null,{"$f":"Trucks!B243","v":0},{"$f":"Trucks!C243","v":0},{"$f":"C129","v":0}]
[]
[null,"Schedule"]
[null,"Battery balancing time SOC cutoff (%) -default 80",80]
[null,"added minutes for balancing time -default 20",20]
[]
[null,"Period start time","00:00:00","01:00:00","02:00:00","03:00:00","04:00:00","05:00:00","06:00:00","07:00:00","08:00:00","09:00:00","10:00:00","11:00:00","12:00:00","13:00:00","14:00:00","15:00:00","16:00:00","17:00:00","18:00:00","19:00:00","20:00:00","21:00:00","22:00:00","23:00:00"]
[]
[null,"start time","break times"]
[null,"00:00:00","No Break","00:30:00","01:00:00","01:30:00","02:00:00","02:30:00","03:00:00","03:30:00","04:00:00","04:30:00","05:00:00","05:30:00","06:00:00","06:30:00","07:00:00","07:30:00","08:00:00","08:30:00","09:00:00","09:30:00","10:00:00","10:30:00","11:00:00","11:30:00","12:00:00","12:30:00","13:00:00","13:30:00","14:00:00","14:30:00","15:00:00","15:30:00","16:00:00","16:30:00","17:00:00","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00"]
[null,"01:00:00","No Break","01:30:00","02:00:00","02:30:00","03:00:00","03:30:00","04:00:00","04:30:00","05:00:00","05:30:00","06:00:00","06:30:00","07:00:00","07:30:00","08:00:00","08:30:00","09:00:00","09:30:00","10:00:00","10:30:00","11:00:00","11:30:00","12:00:00","12:30:00","13:00:00","13:30:00","14:00:00","14:30:00","15:00:00","15:30:00","16:00:00","16:30:00","17:00:00","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333299]
[null,"02:00:00","No Break","02:30:00","03:00:00","03:30:00","04:00:00","04:30:00","05:00:00","05:30:00","06:00:00","06:30:00","07:00:00","07:30:00","08:00:00","08:30:00","09:00:00","09:30:00","10:00:00","10:30:00","11:00:00","11:30:00","12:00:00","12:30:00","13:00:00","13:30:00","14:00:00","14:30:00","15:00:00","15:30:00","16:00:00","16:30:00","17:00:00","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333299,1.0416666666666701,1.0625]
[null,"03:00:00","No Break","03:30:00","04:00:00","04:30:00","05:00:00","05:30:00","06:00:00","06:30:00","07:00:00","07:30:00","08:00:00","08:30:00","09:00:00","09:30:00","10:00:00","10:30:00","11:00:00","11:30:00","12:00:00","12:30:00","13:00:00","13:30:00","14:00:00","14:30:00","15:00:00","15:30:00","16:00:00","16:30:00","17:00:00","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333299,1.0416666666666701,1.0625,1.0833333333333299,1.1041666666666701]
[null,"04:00:00","No Break","04:30:00","05:00:00","05:30:00","06:00:00","06:30:00","07:00:00","07:30:00","08:00:00","08:30:00","09:00:00","09:30:00","10:00:00","10:30:00","11:00:00","11:30:00","12:00:00","12:30:00","13:00:00","13:30:00","14:00:00","14:30:00","15:00:00","15:30:00","16:00:00","16:30:00","17:00:00","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333299,1.0416666666666701,1.0625,1.0833333333333299,1.1041666666666701,1.125,1.1458333333333299]
[null,"05:00:00","No Break","05:30:00","06:00:00","06:30:00","07:00:00","07:30:00","08:00:00","08:30:00","09:00:00","09:30:00","10:00:00","10:30:00","11:00:00","11:30:00","12:00:00","12:30:00","13:00:00","13:30:00","14:00:00","14:30:00","15:00:00","15:30:00","16:00:00","16:30:00","17:00:00","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333333,1.0416666666666667,1.0625,1.0833333333333333,1.1041666666666667,1.125,1.1458333333333333,1.1666666666666667,1.1875]
[null,"06:00:00","No Break","06:30:00","07:00:00","07:30:00","08:00:00","08:30:00","09:00:00","09:30:00","10:00:00","10:30:00","11:00:00","11:30:00","12:00:00","12:30:00","13:00:00","13:30:00","14:00:00","14:30:00","15:00:00","15:30:00","16:00:00","16:30:00","17:00:00","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333333,1.0416666666666667,1.0625,1.0833333333333333,1.1041666666666667,1.125,1.1458333333333333,1.1666666666666667,1.1875,1.2083333333333333,1.2291666666666667]
[null,"07:00:00","No Break","07:30:00","08:00:00","08:30:00","09:00:00","09:30:00","10:00:00","10:30:00","11:00:00","11:30:00","12:00:00","12:30:00","13:00:00","13:30:00","14:00:00","14:30:00","15:00:00","15:30:00","16:00:00","16:30:00","17:00:00","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333333,1.0416666666666667,1.0625,1.0833333333333333,1.1041666666666667,1.125,1.1458333333333333,1.1666666666666667,1.1875,1.2083333333333333,1.2291666666666667,1.25,1.2708333333333333]
[null,"08:00:00","No Break","08:30:00","09:00:00","09:30:00","10:00:00","10:30:00","11:00:00","11:30:00","12:00:00","12:30:00","13:00:00","13:30:00","14:00:00","14:30:00","15:00:00","15:30:00","16:00:00","16:30:00","17:00:00","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333333,1.0416666666666667,1.0625,1.0833333333333333,1.1041666666666667,1.125,1.1458333333333333,1.1666666666666667,1.1875,1.2083333333333333,1.2291666666666667,1.25,1.2708333333333333,1.2916666666666667,1.3125]
[null,"09:00:00","No Break","09:30:00","10:00:00","10:30:00","11:00:00","11:30:00","12:00:00","12:30:00","13:00:00","13:30:00","14:00:00","14:30:00","15:00:00","15:30:00","16:00:00","16:30:00","17:00:00","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333333,1.0416666666666667,1.0625,1.0833333333333333,1.1041666666666667,1.125,1.1458333333333333,1.1666666666666667,1.1875,1.2083333333333333,1.2291666666666667,1.25,1.2708333333333333,1.2916666666666667,1.3125,1.3333333333333333,1.3541666666666667]
[null,"10:00:00","No Break","10:30:00","11:00:00","11:30:00","12:00:00","12:30:00","13:00:00","13:30:00","14:00:00","14:30:00","15:00:00","15:30:00","16:00:00","16:30:00","17:00:00","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333299,1.0416666666666701,1.0625,1.0833333333333299,1.1041666666666701,1.125,1.1458333333333299,1.1666666666666701,1.1875,1.2083333333333299,1.2291666666666701,1.25,1.2708333333333299,1.2916666666666701,1.3125,1.3333333333333299,1.3541666666666701,1.375,1.3958333333333299]
[null,"11:00:00","No Break","11:30:00","12:00:00","12:30:00","13:00:00","13:30:00","14:00:00","14:30:00","15:00:00","15:30:00","16:00:00","16:30:00","17:00:00","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333299,1.0416666666666701,1.0625,1.0833333333333299,1.1041666666666701,1.125,1.1458333333333299,1.1666666666666701,1.1875,1.2083333333333299,1.2291666666666701,1.25,1.2708333333333299,1.2916666666666701,1.3125,1.3333333333333299,1.3541666666666701,1.375,1.3958333333333299,1.4166666666666701,1.4375]
[null,"12:00:00","No Break","12:30:00","13:00:00","13:30:00","14:00:00","14:30:00","15:00:00","15:30:00","16:00:00","16:30:00","17:00:00","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",0.999999999999999,1.0208333333333299,1.0416666666666701,1.0625,1.0833333333333299,1.1041666666666701,1.125,1.1458333333333299,1.1666666666666701,1.1875,1.2083333333333299,1.2291666666666701,1.25,1.2708333333333299,1.2916666666666701,1.3125,1.3333333333333299,1.3541666666666701,1.375,1.3958333333333299,1.4166666666666701,1.4375,1.4583333333333299,1.4791666666666701]
[null,"13:00:00","No Break","13:30:00","14:00:00","14:30:00","15:00:00","15:30:00","16:00:00","16:30:00","17:00:00","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333299,1.0416666666666701,1.0625,1.0833333333333299,1.1041666666666701,1.125,1.1458333333333299,1.1666666666666701,1.1875,1.2083333333333299,1.2291666666666701,1.25,1.2708333333333299,1.2916666666666701,1.3125,1.3333333333333299,1.3541666666666701,1.375,1.3958333333333299,1.4166666666666701,1.4375,1.4583333333333299,1.4791666666666701,1.5,1.5208333333333299]
[null,"14:00:00","No Break","14:30:00","15:00:00","15:30:00","16:00:00","16:30:00","17:00:00","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333299,1.0416666666666701,1.0625,1.0833333333333299,1.1041666666666701,1.125,1.1458333333333299,1.1666666666666701,1.1875,1.2083333333333299,1.2291666666666701,1.25,1.2708333333333299,1.2916666666666701,1.3125,1.3333333333333299,1.3541666666666701,1.375,1.3958333333333299,1.4166666666666701,1.4375,1.4583333333333299,1.4791666666666701,1.5,1.5208333333333299,1.5416666666666701,1.5625]
[null,"15:00:00","No Break","15:30:00","16:00:00","16:30:00","17:00:00","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",0.999999999999999,1.0208333333333299,1.0416666666666701,1.0625,1.0833333333333299,1.1041666666666701,1.125,1.1458333333333299,1.1666666666666701,1.1875,1.2083333333333299,1.2291666666666701,1.25,1.2708333333333299,1.2916666666666701,1.3125,1.3333333333333299,1.3541666666666701,1.375,1.3958333333333299,1.4166666666666701,1.4375,1.4583333333333299,1.4791666666666701,1.5,1.5208333333333299,1.5416666666666701,1.5625,1.5833333333333299,1.6041666666666701]
[null,"16:00:00","No Break","16:30:00","17:00:00","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333299,1.0416666666666701,1.0625,1.0833333333333299,1.1041666666666701,1.125,1.1458333333333299,1.1666666666666701,1.1875,1.2083333333333299,1.2291666666666701,1.25,1.2708333333333299,1.2916666666666701,1.3125,1.3333333333333299,1.3541666666666701,1.375,1.3958333333333299,1.4166666666666701,1.4375,1.4583333333333299,1.4791666666666701,1.5,1.5208333333333299,1.5416666666666701,1.5625,1.5833333333333299,1.6041666666666701,1.625,1.6458333333333299]
[null,"17:00:00","No Break","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333299,1.0416666666666701,1.0625,1.0833333333333299,1.1041666666666701,1.125,1.1458333333333299,1.1666666666666701,1.1875,1.2083333333333299,1.2291666666666701,1.25,1.2708333333333299,1.2916666666666701,1.3125,1.3333333333333299,1.3541666666666701,1.375,1.3958333333333299,1.4166666666666701,1.4375,1.4583333333333299,1.4791666666666701,1.5,1.5208333333333299,1.5416666666666601,1.5625,1.5833333333333299,1.6041666666666601,1.625,1.6458333333333299,1.6666666666666601,1.6875]
[null,"18:00:00","No Break","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333299,1.0416666666666701,1.0625,1.0833333333333299,1.1041666666666701,1.125,1.1458333333333299,1.1666666666666701,1.1875,1.2083333333333299,1.2291666666666701,1.25,1.2708333333333299,1.2916666666666701,1.3125,1.3333333333333299,1.3541666666666701,1.375,1.3958333333333299,1.4166666666666701,1.4375,1.4583333333333299,1.4791666666666701,1.5,1.5208333333333299,1.5416666666666701,1.5625,1.5833333333333299,1.6041666666666701,1.625,1.6458333333333299,1.6666666666666701,1.6875,1.7083333333333299,1.7291666666666701]
[null,"19:00:00","No Break","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333299,1.0416666666666701,1.0625,1.0833333333333299,1.1041666666666701,1.125,1.1458333333333299,1.1666666666666701,1.1875,1.2083333333333299,1.2291666666666701,1.25,1.2708333333333299,1.2916666666666701,1.3125,1.3333333333333299,1.3541666666666701,1.375,1.3958333333333299,1.4166666666666701,1.4375,1.4583333333333299,1.4791666666666701,1.5,1.5208333333333299,1.5416666666666701,1.5625,1.5833333333333299,1.6041666666666701,1.625,1.6458333333333299,1.6666666666666701,1.6875,1.7083333333333299,1.7291666666666701,1.75,1.7708333333333299]
[null,"20:00:00","No Break","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333299,1.0416666666666701,1.0625,1.0833333333333299,1.1041666666666701,1.125,1.1458333333333299,1.1666666666666701,1.1875,1.2083333333333299,1.2291666666666701,1.25,1.2708333333333299,1.2916666666666701,1.3125,1.3333333333333299,1.3541666666666701,1.375,1.3958333333333299,1.4166666666666701,1.4375,1.4583333333333299,1.4791666666666701,1.5,1.5208333333333299,1.5416666666666701,1.5625,1.5833333333333299,1.6041666666666701,1.625,1.6458333333333299,1.6666666666666601,1.6875,1.7083333333333299,1.7291666666666601,1.75,1.7708333333333299,1.7916666666666601,1.8125]
[null,"21:00:00","No Break","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333299,1.0416666666666701,1.0625,1.0833333333333299,1.1041666666666701,1.125,1.1458333333333299,1.1666666666666701,1.1875,1.2083333333333299,1.2291666666666701,1.25,1.2708333333333299,1.2916666666666701,1.3125,1.3333333333333299,1.3541666666666701,1.375,1.3958333333333299,1.4166666666666701,1.4375,1.4583333333333299,1.4791666666666701,1.5,1.5208333333333299,1.5416666666666701,1.5625,1.5833333333333299,1.6041666666666701,1.625,1.6458333333333299,1.6666666666666701,1.6875,1.7083333333333299,1.7291666666666701,1.75,1.7708333333333299,1.7916666666666701,1.8125,1.8333333333333299,1.8541666666666701]
[null,"22:00:00","No Break","22:30:00","23:00:00","23:30:00",1,1.0208333333333299,1.0416666666666701,1.0625,1.0833333333333299,1.1041666666666701,1.125,1.1458333333333299,1.1666666666666701,1.1875,1.2083333333333299,1.2291666666666701,1.25,1.2708333333333299,1.2916666666666701,1.3125,1.3333333333333299,1.3541666666666701,1.375,1.3958333333333299,1.4166666666666701,1.4375,1.4583333333333299,1.4791666666666701,1.5,1.5208333333333299,1.5416666666666701,1.5625,1.5833333333333299,1.6041666666666701,1.625,1.6458333333333299,1.6666666666666701,1.6875,1.7083333333333399,1.7291666666666701,1.75,1.7708333333333399,1.7916666666666701,1.8125,1.8333333333333399,1.8541666666666701,1.875,1.8958333333333399]
[null,"23:00:00","No Break","23:30:00",1,1.0208333333333299,1.0416666666666701,1.0625,1.0833333333333299,1.1041666666666701,1.125,1.1458333333333299,1.1666666666666701,1.1875,1.2083333333333299,1.2291666666666701,1.25,1.2708333333333299,1.2916666666666701,1.3125,1.3333333333333299,1.3541666666666701,1.375,1.3958333333333299,1.4166666666666701,1.4375,1.4583333333333299,1.4791666666666701,1.5,1.5208333333333299,1.5416666666666701,1.5625,1.5833333333333299,1.6041666666666701,1.625,1.6458333333333299,1.6666666666666701,1.6875,1.7083333333333299,1.7291666666666701,1.75,1.7708333333333299,1.7916666666666601,1.8125,1.8333333333333299,1.8541666666666601,1.875,1.8958333333333299,1.9166666666666601,1.9375]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101]
[null,"start time","break times"]
[null,{"$f":"Inputs!F4","v":"07:00:00"},{"$f":"VLOOKUP($B$164,$B$138:$AX$161,B162,FALSE)","v":"No Break"},{"$f":"VLOOKUP($B$164,$B$138:$AX$161,C162,FALSE)","v":"07:30:00"},"08:00:00","08:30:00","09:00:00","09:30:00","10:00:00","10:30:00","11:00:00","11:30:00","12:00:00","12:30:00","13:00:00","13:30:00","14:00:00","14:30:00","15:00:00","15:30:00","16:00:00","16:30:00","17:00:00","17:30:00","18:00:00","18:30:00","19:00:00","19:30:00","20:00:00","20:30:00","21:00:00","21:30:00","22:00:00","22:30:00","23:00:00","23:30:00",1,1.0208333333333333,1.0416666666666667,1.0625,1.0833333333333333,1.1041666666666667,1.125,1.1458333333333333,1.1666666666666667,1.1875,1.2083333333333333,1.2291666666666667,1.25,1.2708333333333333]
[]
[null,"Break duration (mins)",0,5,10,15,20,30,40,45,60,90,120]
[]
[null,"End Time",{"$f":"B164+1/24","v":"08:00:00"},{"$f":"C168+1/24","v":"09:00:00"},{"$f":"D168+1/24","v":"10:00:00"},"11:00:00","12:00:00","13:00:00","14:00:00","15:00:00","16:00:00","17:00:00","18:00:00","19:00:00","20:00:00","21:00:00","22:00:00","23:00:00",0.99999999999999967,1.0416666666666663,1.083333333333333,1.1249999999999998,1.1666666666666665,1.2083333333333333,1.25,1.2916666666666667]

{"sheet":"Calc1","index":4,"n_rows":166,"n_cols":37,"rows_kept":166,"cut":false,"hidden":true,"merged":[[10,32,10,36],[14,19,14,21],[11,2,11,6],[97,9,129,9],[14,23,14,25],[14,26,14,28],[11,35,11,36]]}
[]
[null,null,"Operating hours per annum (decimal)",{"$f":"(Calc1!D5*Inputs!F20*Calc2!C6)","v":3279.9999999999982},"(hrs/day)x(days/week)x(weeks/year)"]
[null,null,"Estimated idle time %",{"$f":"(1-Inputs!F21/(Calc1!D5*Inputs!F20*Calc2!C6))","v":8.5365853658536106E-2}]
[null,null,"Charging time per day",{"$f":"O60","v":"10:20:00"}]
[null,null,"Operating hours per day (decimal)",{"$f":"O59*24","v":13.666666666666661}]
[null,null,"Break Hours per day (decimal)",{"$f":"O62*24","v":2.3333333333333339}]
[null,null,"Number of breaks ",{"$f":"COUNT(M19,M22,M24,M26,M28,M30,M32,M34,M36,M38,M40,M42,M44,M47,M49,M51,M53,M55)","v":5}]
[]
[]
[null,null,null,"Lead Acid","Lithium ion","Fuel Cell","ICE",null,null,null,null,"LI-ion Energy useage based on shift patterns"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Graph"]
[null,null,"Energy Cost PA/Truck",null,null,null,null,null,null,null,null,null,"Availiable Capacity (kWh)",{"$f":"E22","v":39.167999999999999},null,null,null,null,"battery balancing time SOC threshold  (%)",{"$f":"Calc2!C132","v":80},null,null,null,null,null,null,null,null,null,null,null,null,"Period end","SOC (kWh)","SOC (%)","DOD line"]
[null,null,null,null,null,null,null,null,null,null,null,null,"consumption rate (kWh/h)",{"$f":"E28","v":7.1890000000000009},null,null,null,null,"battery balancing time SOC threshold (kWh))",{"$f":"T12/100*N12","v":31.334400000000002},null,{"$f":"Calc2!C133","v":20},"added mins for balancing",null,null,null,null,null,null,null,null,null,{"$f":"AB17","v":"07:00:00"},{"$f":"AC17","v":39.167999999999999},{"$f":"AH13/$N$12","v":1}]
[null,null,"Voltage",{"$f":"VLOOKUP(Inputs!F56,Trucks!B78:C97,2,FALSE)","v":80},{"$f":"VLOOKUP(D14,Trucks!B237:C243,2,FALSE)","v":76.8},null,null,null,null,null,null,null,"charge rate (kWh/h)",{"$f":"E19","v":38.4},null,null,null,null,"Charge rate during balancing (kWh/h)",{"$f":"(N12-T13)/(((N12-T13)/N14)+V13/60)","v":14.578660049627789},null,null,null,null,null,null,null,null,null,null,null,"discharge",{"$f":"AB18","v":"10:00:00"},{"$f":"AC18","v":17.600999999999996},0.44937193627450972,{"$f":"AG13","v":"07:00:00"},{"$f":"R61","v":0.04}]
[null,null,"Battery Capacity (Ah)",{"$f":"Inputs!F65","v":770},{"$f":"Inputs!F84","v":600},null,null,null,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":"U19","v":"10:20:00"},{"$f":"V19","v":30.401000000000003},0.77616932189542498,{"$f":"AG87","v":"23:48:57.772"},{"$f":"AK14","v":0.04}]
[null,null,"Charger (A)",null,{"$f":"Inputs!F85","v":500},null,null,null,null,null,null,"charge/discharge","start time","end time","duration ","[for Warning] check end time after finish time (1=warning)","Consumption (kWh) for total per day","[For warning] Max DOD been exceeded? (Yes=1)","[logic for table] is end SOC < threshold?","start","end","SOC","[logic for table] will it go over 100%?","start","end","SOC","start","end","SOC",null,null,null,{"$f":"Y19","v":"10:20:00"},{"$f":"Z19","v":30.401000000000003},0.77616932189542498]
[null,null,"Cells",{"$f":"D14/2","v":40},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Inputs!F4","v":"07:00:00"},{"$f":"N12","v":39.167999999999999},null,null,null,{"$f":"AB19","v":"10:20:00"},{"$f":"AC19","v":30.401000000000003},0.77616932189542498]
[null,null,"Hours to Charge",null,{"$f":"E15/E16","v":1.2},null,null,null,null,null,null,"discharge",{"$f":"Inputs!F4","v":"07:00:00"},{"$f":"IF(M19=\"No Break\",M21,M19)","v":"10:00:00"},{"$f":"N18-M18","v":"03:00:00"},null,{"$f":"O18*24*$N$13","v":21.567000000000004},{"$f":"IF(AC18<$R$61*$N$12,1,0)","v":0},null,{"$f":"Inputs!F4","v":"07:00:00"},null,null,null,null,null,null,null,{"$f":"N18","v":"10:00:00"},{"$f":"AC17-(AB18-T18)*24*$N$13","v":17.600999999999996},null,null,"discharge",{"$f":"AB20","v":"12:30:00"},{"$f":"AC20","v":14.824833333333332},0.37849349809368188]
[null,null,"Charge rate (kWh/hour)",null,{"$f":"E21/E18","v":38.4},null,null,null,null,null,null,"charge 1",{"$f":"IF(Inputs!D7=0,\"No Break\",Inputs!D7)","v":"10:00:00"},{"$f":"IF(M19=\"No Break\",\"No Break\",M19+O19)","v":"10:20:00"},{"$f":"Inputs!D8/60/24","v":"00:20:00"},{"$f":"IF(N19=\"No Break\",IF(P17=1,1,0),IF(Calc1!N19>Calc1!N21,1,\"\"))","v":""},null,null,{"$f":"IF(T19=\"No break\",\"\",IF((AB19-T19)*24*$N$14+AC18<$T$13,1,\"\"))","v":1},{"$f":"M19","v":"10:00:00"},{"$f":"IF(AND(AC18<$T$13,S19=1),AB19,IF(AC18<$T$13,T19+($T$13-AC18)/$N$14/24,T19))","v":"10:20:00"},{"$f":"IF(AND(AC18<$T$13,S19=1),AC18+(U19-T19)*24*$N$14,IF(AC18<=$T$13,$T$13,AC18))","v":30.401000000000003},{"$f":"IF(M19=\"No Break\",\"\",IF((AB19-X19)*24*$T$14+V19>$N$12,1,\"\"))","v":""},{"$f":"U19","v":"10:20:00"},{"$f":"IF(S19=1,X19,IF(W19=1,X19+($N$12-V19)/$T$14/24,AB19))","v":"10:20:00"},{"$f":"IF(S19=1,V19,V19+(Y19-X19)*24*$T$14)","v":30.401000000000003},{"$f":"Y19","v":"10:20:00"},{"$f":"IF(M19=\"No Break\",AA19,M19+O19)","v":"10:20:00"},{"$f":"Z19","v":30.401000000000003},null,null,null,{"$f":"U21","v":"12:55:47.772"},{"$f":"V21","v":31.334400000000002},0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21*24*$N$13","v":15.576166666666671},{"$f":"IF(AC20<$R$61*$N$12,1,0)","v":0},null,{"$f":"M21","v":"10:20:00"},null,null,null,null,null,null,null,{"$f":"IF(OR(M22=\"No Break\",M22=0), T22,T21)","v":"12:30:00"},{"$f":"AC19-(AB20-T20)*24*$N$13","v":14.824833333333332},null,null,null,{"$f":"Y21","v":"13:10:00"},{"$f":"Z21","v":34.785606699751845},0.88811291614971011]
[null,null,"Nominal Energy per battery  (kWh)",{"$f":"D15*D14/1000","v":61.6},{"$f":"E15*E14/1000","v":46.08},null,null,null,null,null,null,"discharge",{"$f":"IF(OR(M19=\"No Break\",M19=0),N21,N19)","v":"10:20:00"},{"$f":"IF(M22=\"No Break\",M23,M22)","v":"12:30:00"},{"$f":"IF(N21-M21<0,0,N21-M21)","v":"02:10:00"},{"$f":"IF(N22=\"No Break\",IF(P19=1,1,0),IF(Calc1!N22>Calc1!N23,1,\"\"))","v":""},null,null,{"$f":"IF(M22=\"No break\",\"\",IF((AB21-T21)*24*$N$14+AC20<$T$13,1,\"\"))","v":""},{"$f":"IF(M22=\"No Break\",AB20,M22)","v":"12:30:00"},{"$f":"IF(M22=\"No Break\",T21,IF(AND(AC20<$T$13,S21=1),AB21,IF(AC20<$T$13,T21+($T$13-AC20)/$N$14/24,T21)))","v":"12:55:47.772"},{"$f":"IF(M22=\"No Break\",AC20,IF(AND(AC20<$T$13,S21=1),AC20+(U21-T21)*24*$N$14,IF(AC20<=$T$13,$T$13,AC20)))","v":31.334400000000002},{"$f":"IF(M22=\"No Break\",\"\",IF((AB21-X21)*24*$T$14+V21>$N$12,1,\"\"))","v":""},{"$f":"U21","v":"12:55:47.772"},{"$f":"IF(M22=\"No Break\",X21,IF(S21=1,X21,IF(W21=1,X21+($N$12-V21)/$T$14/24,AB21)))","v":"13:10:00"},{"$f":"IF(S21=1,V21,V21+(Y21-X21)*24*$T$14)","v":34.785606699751845},{"$f":"Y21","v":"13:10:00"},{"$f":"IF(M22=\"No Break\",AA21,M22+O22)","v":"13:10:00"},{"$f":"Z21","v":34.785606699751845},null,null,null,{"$f":"AB21","v":"13:10:00"},{"$f":"AC21","v":34.785606699751845},0.88811291614971011]
[null,null,"Available Energy Per battery (kWh)",null,{"$f":"E21*Calc2!C74/100","v":39.167999999999999},null,null,null,null,null,null,"charge 2",{"$f":"IF(Inputs!F7=0,\"No Break\",Inputs!F7)","v":"12:30:00"},{"$f":"IF(M22=\"No Break\",\"No Break\",M22+O22)","v":"13:10:00"},{"$f":"IF(M22=\"No Break\",0,Inputs!F8/24/60)","v":"00:40:00"},null,{"$f":"O23*24*$N$13","v":13.179833333333326},{"$f":"IF(AC22<$R$61*$N$12,1,0)","v":0},null,{"$f":"M23","v":"13:10:00"},null,null,null,null,null,null,null,{"$f":"IF(OR(M24=\"No Break\",M24=0), T24,T23)","v":"15:00:00"},{"$f":"AC21-(AB22-T22)*24*$N$13","v":21.605773366418518},null,null,"discharge",{"$f":"AB22","v":"15:00:00"},{"$f":"AC22","v":21.605773366418518},0.55161798831746622]
[null,null,"Useable energy per battery (kWh) - tank capacity lt / kg ",{"$f":"(D21*Calc2!C65/100)","v":49.28},{"$f":"(E21*Calc2!C76/100)","v":37.601279999999996},{"$f":"Calc2!C88*Calc2!C86","v":47.452499999999993},{"$f":"Calc2!C24","v":52},null,null,null,null,"discharge",{"$f":"IF(OR(M22=\"No Break\",M22=0),N23,N22)","v":"13:10:00"},{"$f":"IF(M24=\"No Break\",M25,M24)","v":"15:00:00"},{"$f":"IF(N23-M23<0,0,N23-M23)","v":"01:50:00"},{"$f":"IF(N24=\"No Break\",IF(P21=1,1,0),IF(Calc1!N24>Calc1!N25,1,\"\"))","v":""},null,null,{"$f":"IF(M24=\"No break\",\"\",IF((AB23-T23)*24*$N$14+AC22<$T$13,1,\"\"))","v":""},{"$f":"IF(M24=\"No Break\",AB22,M24)","v":"15:00:00"},{"$f":"IF(M24=\"No Break\",T23,IF(AND(AC22<$T$13,S23=1),AB23,IF(AC22<$T$13,T23+($T$13-AC22)/$N$14/24,T23)))","v":"15:15:12.059"},{"$f":"IF(M24=\"No Break\",AC22,IF(AND(AC22<$T$13,S23=1),AC22+(U23-T23)*24*$N$14,IF(AC22<=$T$13,$T$13,AC22)))","v":31.334400000000002},{"$f":"IF(M24=\"No Break\",\"\",IF((AB23-X23)*24*$T$14+V23>$N$12,1,\"\"))","v":""},{"$f":"U23","v":"15:15:12.059"},{"$f":"IF(M24=\"No Break\",X23,IF(S23=1,X23,IF(W23=1,X23+($N$12-V23)/$T$14/24,AB23)))","v":"15:20:00"},{"$f":"IF(S23=1,V23,V23+(Y23-X23)*24*$T$14)","v":32.500454900898347},{"$f":"Y23","v":"15:20:00"},{"$f":"IF(M24=\"No Break\",AA23,M24+O24)","v":"15:20:00"},{"$f":"Z23","v":32.500454900898347},null,null,null,{"$f":"U23","v":"15:15:12.059"},{"$f":"V23","v":31.334400000000002},0.8]
[null,null,"Energy per charge (of useable range) (kWh)",{"$f":"(D15*D14*(Calc2!C65/100)/Calc2!C70/Calc2!C71)/1000","v":83.243243243243242},{"$f":"E15*E14/1000*Calc2!C76/100/Calc2!C80/Calc2!C81","v":43.978105263157893},null,null,null,null,null,null,"charge 3",{"$f":"IF(Inputs!H7=0,\"No Break\",Inputs!H7)","v":"15:00:00"},{"$f":"IF(M24=\"No Break\",\"No Break\",M24+O24)","v":"15:20:00"},{"$f":"IF(M24=\"No Break\",0,Inputs!H8/60/24)","v":"00:20:00"},null,{"$f":"O25*24*$N$13","v":26.359666666666673},{"$f":"IF(AC24<$R$61*$N$12,1,0)","v":0},null,{"$f":"M25","v":"15:20:00"},null,null,null,null,null,null,null,{"$f":"IF(OR(M26=\"No Break\",M26=0), T26,T25)","v":"19:00:00"},{"$f":"AC23-(AB24-T24)*24*$N$13","v":6.1407882342316746},null,null,null,{"$f":"Y23","v":"15:20:00"},{"$f":"Z23","v":32.500454900898347},0.82977060102375277]
[null,null,"Mains energy per kWh of battery use",{"$f":"D24/D23","v":1.689189189189189},{"$f":"E24/E23","v":1.169590643274854},null,null,null,null,null,null,"discharge",{"$f":"IF(OR(M24=\"No Break\",M24=0),N25,N24)","v":"15:20:00"},{"$f":"IF(M26=\"No Break\",M27,M26)","v":"19:00:00"},{"$f":"IF(N25-M25<0,0,N25-M25)","v":"03:40:00"},{"$f":"IF(N26=\"No Break\",IF(P23=1,1,0),IF(Calc1!N26>Calc1!N27,1,\"\"))","v":""},null,null,{"$f":"IF(M26=\"No break\",\"\",IF((AB25-T25)*24*$N$14+AC24<$T$13,1,\"\"))","v":""},{"$f":"IF(M26=\"No Break\",AB24,M26)","v":"19:00:00"},{"$f":"IF(M26=\"No Break\",T25,IF(AND(AC24<$T$13,S25=1),AB25,IF(AC24<$T$13,T25+($T$13-AC24)/$N$14/24,T25)))","v":"19:39:21.901"},{"$f":"IF(M26=\"No Break\",AC24,IF(AND(AC24<$T$13,S25=1),AC24+(U25-T25)*24*$N$14,IF(AC24<=$T$13,$T$13,AC24)))","v":31.334400000000002},{"$f":"IF(M26=\"No Break\",\"\",IF((AB25-X25)*24*$T$14+V25>$N$12,1,\"\"))","v":""},{"$f":"U25","v":"19:39:21.901"},{"$f":"IF(M26=\"No Break\",X25,IF(S25=1,X25,IF(W25=1,X25+($N$12-V25)/$T$14/24,AB25)))","v":"19:40:00"},{"$f":"IF(S25=1,V25,V25+(Y25-X25)*24*$T$14)","v":31.488686351953977},{"$f":"Y25","v":"19:40:00"},{"$f":"IF(M26=\"No Break\",AA25,M26+O26)","v":"19:40:00"},{"$f":"Z25","v":31.488686351953977},null,null,null,{"$f":"AB23","v":"15:20:00"},{"$f":"AC23","v":32.500454900898347},0.82977060102375277]
[null,null,null,null,null,null,null,null,null,null,null,"charge 4",{"$f":"IF(Inputs!J7=0,\"No Break\",Inputs!J7)","v":"19:00:00"},{"$f":"IF(M26=\"No Break\",\"No Break\",M26+O26)","v":"19:40:00"},{"$f":"IF(M26=\"No Break\",0,Inputs!J8/60/24)","v":"00:40:00"},null,{"$f":"O27*24*$N$13","v":9.5853333333333381},{"$f":"IF(AC26<$R$61*$N$12,1,0)","v":0},null,{"$f":"M27","v":"19:40:00"},null,null,null,null,null,null,null,{"$f":"IF(OR(M28=\"No Break\",M28=0), T28,T27)","v":"21:00:00"},{"$f":"AC25-(AB26-T26)*24*$N$13","v":21.903353018620638},null,null,"discharge",{"$f":"AB24","v":"19:00:00"},{"$f":"AC24","v":6.1407882342316746},0.15678074535926456]
[null,null,"Energy consumption rate during use (kWh/h) - lt/h - kg/h",{"$f":"IF(Inputs!F79=\"yes\",Performance!B11*Inputs!F57,Performance!C11*Inputs!F57)","v":7.9},{"$f":"IF(Inputs!F92=\"yes\",Performance!B11*Inputs!F57,Performance!C11*Inputs!F57)","v":7.9},{"$f":"IF(Inputs!F104=\"yes\",Performance!B11*Inputs!F57,Performance!C11*Inputs!F57)","v":7.9},{"$f":"IF(Inputs!F52=\"yes\",Performance!B11*Inputs!F42,Performance!C11*Inputs!F42)","v":2.6},null,null,null,null,"Discharge",{"$f":"IF(OR(M26=\"No Break\",M26=0),N27,N26)","v":"19:40:00"},{"$f":"IF(M28=\"No Break\",M29,M28)","v":"21:00:00"},{"$f":"IF(N27-M27<0,0,N27-M27)","v":"01:20:00"},{"$f":"IF(N28=\"No Break\",IF(P25=1,1,0),IF(Calc1!N28>Calc1!N29,1,\"\"))","v":""},null,null,{"$f":"IF(M28=\"No break\",\"\",IF((AB27-T27)*24*$N$14+AC26<$T$13,1,\"\"))","v":""},{"$f":"IF(M28=\"No Break\",AB26,M28)","v":"21:00:00"},{"$f":"IF(M28=\"No Break\",T27,IF(AND(AC26<$T$13,S27=1),AB27,IF(AC26<$T$13,T27+($T$13-AC26)/$N$14/24,T27)))","v":"21:14:44.161"},{"$f":"IF(M28=\"No Break\",AC26,IF(AND(AC26<$T$13,S27=1),AC26+(U27-T27)*24*$N$14,IF(AC26<=$T$13,$T$13,AC26)))","v":31.334400000000002},{"$f":"IF(M28=\"No Break\",\"\",IF((AB27-X27)*24*$T$14+V27>$N$12,1,\"\"))","v":""},{"$f":"U27","v":"21:14:44.161"},{"$f":"IF(M28=\"No Break\",X27,IF(S27=1,X27,IF(W27=1,X27+($N$12-V27)/$T$14/24,AB27)))","v":"21:20:00"},{"$f":"IF(S27=1,V27,V27+(Y27-X27)*24*$T$14)","v":32.613431791188482},{"$f":"Y27","v":"21:20:00"},{"$f":"IF(M28=\"No Break\",AA27,M28+O28)","v":"21:20:00"},{"$f":"Z27","v":32.613431791188482},null,null,null,{"$f":"U25","v":"19:39:21.901"},{"$f":"V25","v":31.334400000000002},0.8]
[null,null,"Energy consumption rate during use including idle time (kWh/h) inc 50% eff",{"$f":"D27*(1-Inputs!F22/100)","v":7.1890000000000009},{"$f":"E27*(1-Inputs!F22/100)","v":7.1890000000000009},{"$f":"F27*(1-Inputs!F22/100)/Calc2!C91","v":14.378000000000002},{"$f":"G27*(1-Inputs!F22/100)","v":2.3660000000000001},null,null,null,null,"charge 5",{"$f":"IF(Inputs!L7=0,\"No Break\",Inputs!L7)","v":"21:00:00"},{"$f":"IF(M28=\"No Break\",\"No Break\",M28+O28)","v":"21:20:00"},{"$f":"IF(M28=\"No Break\",0,Inputs!L8/60/24)","v":"00:20:00"},null,{"$f":"O29*24*$N$13","v":11.981666666666626},{"$f":"IF(AC28<$R$61*$N$12,1,0)","v":0},null,{"$f":"M29","v":"21:20:00"},null,null,null,null,null,null,null,{"$f":"IF(OR(M30=\"No Break\",M30=0), T30,T29)","v":"23:00:00"},{"$f":"AC27-(AB28-T28)*24*$N$13","v":20.631765124521856},null,null,null,{"$f":"Y25","v":"19:40:00"},{"$f":"Z25","v":31.488686351953977},0.80393909191058965]
[null,null,null,null,null,null,null,null,null,null,null,"discharge",{"$f":"IF(OR(M28=\"No Break\",M28=0),N29,N28)","v":"21:20:00"},{"$f":"IF(M30=\"No Break\",M31,M30)","v":"23:00:00"},{"$f":"IF(N29-M29<0,0,N29-M29)","v":"01:40:00"},{"$f":"IF(N30=\"No Break\",IF(P27=1,1,0),IF(Calc1!N30>Calc1!N31,1,\"\"))","v":0},null,null,{"$f":"IF(M30=\"No break\",\"\",IF((AB29-T29)*24*$N$14+AC28<$T$13,1,\"\"))","v":""},{"$f":"IF(M30=\"No Break\",AB28,M30)","v":"23:00:00"},{"$f":"IF(M30=\"No Break\",T29,IF(AND(AC28<$T$13,S29=1),AB29,IF(AC28<$T$13,T29+($T$13-AC28)/$N$14/24,T29)))","v":"23:00:00"},{"$f":"IF(M30=\"No Break\",AC28,IF(AND(AC28<$T$13,S29=1),AC28+(U29-T29)*24*$N$14,IF(AC28<=$T$13,$T$13,AC28)))","v":20.631765124521856},{"$f":"IF(M30=\"No Break\",\"\",IF((AB29-X29)*24*$T$14+V29>$N$12,1,\"\"))","v":""},{"$f":"U29","v":"23:00:00"},{"$f":"IF(M30=\"No Break\",X29,IF(S29=1,X29,IF(W29=1,X29+($N$12-V29)/$T$14/24,AB29)))","v":"23:00:00"},{"$f":"IF(S29=1,V29,V29+(Y29-X29)*24*$T$14)","v":20.631765124521856},{"$f":"Y29","v":"23:00:00"},{"$f":"IF(M30=\"No Break\",AA29,M30+O30)","v":"23:00:00"},{"$f":"Z29","v":20.631765124521856},null,null,null,{"$f":"AB25","v":"19:40:00"},{"$f":"AC25","v":31.488686351953977},{"$f":"AH29/$N$12","v":0.80393909191058965}]
[null,null,"Used Per Day Kg (LPG) or L (Dsl)",null,null,null,{"$f":"(G28*D5)","v":32.335333333333324},null,null,null,null,"charge 6",{"$f":"IF(Inputs!N7=0,\"No Break\",Inputs!N7)","v":"No Break"},{"$f":"IF(M30=\"No Break\",\"No Break\",M30+O30)","v":"No Break"},{"$f":"IF(M30=\"No Break\",0,Inputs!N8/60/24)","v":"00:00:00"},null,{"$f":"O31*24*$N$13","v":0},{"$f":"IF(AC30<$R$61*$N$12,1,0)","v":0},null,{"$f":"M31","v":"23:00:00"},null,null,null,null,null,null,null,{"$f":"IF(OR(M32=\"No Break\",M32=0), T32,T31)","v":"23:00:00"},{"$f":"AC29-(AB30-T30)*24*$N$13","v":20.631765124521856},null,null,"discharge",{"$f":"AB26","v":"21:00:00"},{"$f":"AC26","v":21.903353018620638},0.5592155080325939]
[null,null,"Used energy per day (Kg)",null,null,{"$f":"((F28*D5)/Calc2!C90)","v":5.9008808808808801},null,null,null,null,null,"discharge",{"$f":"IF(OR(M30=\"No Break\",M30=0),N31,N30)","v":"23:00:00"},{"$f":"IF(M32=\"No Break\",M33,M32)","v":"23:00:00"},{"$f":"IF(N31-M31<0,0,N31-M31)","v":"00:00:00"},{"$f":"IF(N32=\"No Break\",IF(P29=1,1,0),IF(Calc1!N32>Calc1!N33,1,\"\"))","v":0},null,null,{"$f":"IF(M32=\"No break\",\"\",IF((AB31-T31)*24*$N$14+AC30<$T$13,1,\"\"))","v":""},{"$f":"IF(M32=\"No Break\",AB30,M32)","v":"23:00:00"},{"$f":"IF(M32=\"No Break\",T31,IF(AND(AC30<$T$13,S31=1),AB31,IF(AC30<$T$13,T31+($T$13-AC30)/$N$14/24,T31)))","v":"23:00:00"},{"$f":"IF(M32=\"No Break\",AC30,IF(AND(AC30<$T$13,S31=1),AC30+(U31-T31)*24*$N$14,IF(AC30<=$T$13,$T$13,AC30)))","v":20.631765124521856},{"$f":"IF(M32=\"No Break\",\"\",IF((AB31-X31)*24*$T$14+V31>$N$12,1,\"\"))","v":""},{"$f":"U31","v":"23:00:00"},{"$f":"IF(M32=\"No Break\",X31,IF(S31=1,X31,IF(W31=1,X31+($N$12-V31)/$T$14/24,AB31)))","v":"23:00:00"},{"$f":"IF(S31=1,V31,V31+(Y31-X31)*24*$T$14)","v":20.631765124521856},{"$f":"Y31","v":"23:00:00"},{"$f":"IF(M32=\"No Break\",AA31,M32+O32)","v":"23:00:00"},{"$f":"Z31","v":20.631765124521856},null,null,null,{"$f":"U27","v":"21:14:44.161"},{"$f":"V27","v":31.334400000000002},0.8]
[null,null,"Used energy per day (kWh) ",{"$f":"($D$5*D28)","v":98.249666666666641},{"$f":"($D$5*E28)","v":98.249666666666641},{"$f":"($D$5*F28)","v":196.49933333333328},null,null,null,null,null,"charge 7",{"$f":"IF(Inputs!D11=0,\"No Break\",Inputs!D11)","v":"No Break"},{"$f":"IF(M32=\"No Break\",\"No Break\",M32+O32)","v":"No Break"},{"$f":"IF(M32=\"No Break\",0,Inputs!D12/60/24)","v":"00:00:00"},null,{"$f":"O33*24*$N$13","v":0},{"$f":"IF(AC32<$R$61*$N$12,1,0)","v":0},null,{"$f":"M33","v":"23:00:00"},null,null,null,null,null,null,null,{"$f":"IF(OR(M34=\"No Break\",M34=0), T34,T33)","v":"23:00:00"},{"$f":"AC31-(AB32-T32)*24*$N$13","v":20.631765124521856},null,null,null,{"$f":"Y27","v":"21:20:00"},{"$f":"Z27","v":32.613431791188482},0.8326550191786275]
[null,null,null,null,null,null,null,null,null,null,null,"discharge",{"$f":"IF(OR(M32=\"No Break\",M32=0),N33,N32)","v":"23:00:00"},{"$f":"IF(M34=\"No Break\",M35,M34)","v":"23:00:00"},{"$f":"IF(N33-M33<0,0,N33-M33)","v":"00:00:00"},{"$f":"IF(N34=\"No Break\",IF(P31=1,1,0),IF(Calc1!N34>Calc1!N35,1,\"\"))","v":0},null,null,{"$f":"IF(M34=\"No break\",\"\",IF((AB33-T33)*24*$N$14+AC32<$T$13,1,\"\"))","v":""},{"$f":"IF(M34=\"No Break\",AB32,M34)","v":"23:00:00"},{"$f":"IF(M34=\"No Break\",T33,IF(AND(AC32<$T$13,S33=1),AB33,IF(AC32<$T$13,T33+($T$13-AC32)/$N$14/24,T33)))","v":"23:00:00"},{"$f":"IF(M34=\"No Break\",AC32,IF(AND(AC32<$T$13,S33=1),AC32+(U33-T33)*24*$N$14,IF(AC32<=$T$13,$T$13,AC32)))","v":20.631765124521856},{"$f":"IF(M34=\"No Break\",\"\",IF((AB33-X33)*24*$T$14+V33>$N$12,1,\"\"))","v":""},{"$f":"U33","v":"23:00:00"},{"$f":"IF(M34=\"No Break\",X33,IF(S33=1,X33,IF(W33=1,X33+($N$12-V33)/$T$14/24,AB33)))","v":"23:00:00"},{"$f":"IF(S33=1,V33,V33+(Y33-X33)*24*$T$14)","v":20.631765124521856},{"$f":"Y33","v":"23:00:00"},{"$f":"IF(M34=\"No Break\",AA33,M34+O34)","v":"23:00:00"},{"$f":"Z33","v":20.631765124521856},null,null,null,{"$f":"AB27","v":"21:20:00"},{"$f":"AC27","v":32.613431791188482},0.8326550191786275]
[null,null,"Mains Energy per day (kWh)",{"$f":"$D$32*D25","v":165.96227477477473},{"$f":"$D$32*E25","v":114.91189083820662},null,null,null,null,null,null,"charge 8",{"$f":"IF(Inputs!F11=0,\"No Break\",Inputs!F11)","v":"No Break"},{"$f":"IF(M34=\"No Break\",\"No Break\",M34+O34)","v":"No Break"},{"$f":"IF(M34=\"No Break\",0,Inputs!F12/60/24)","v":"00:00:00"},null,{"$f":"O35*24*$N$13","v":0},{"$f":"IF(AC34<$R$61*$N$12,1,0)","v":0},null,{"$f":"M35","v":"23:00:00"},null,null,null,null,null,null,null,{"$f":"IF(OR(M36=\"No Break\",M36=0), T36,T35)","v":"23:00:00"},{"$f":"AC33-(AB34-T34)*24*$N$13","v":20.631765124521856},null,null,"discharge",{"$f":"AB28","v":"23:00:00"},{"$f":"AC28","v":20.631765124521856},0.52675053933113403]
[null,null," Energy Cost Per day  (€)  ",{"$f":"D34*Calc2!C17","v":14.936604729729725},{"$f":"E34*Calc2!C17","v":10.342070175438595},{"$f":"F31*Calc2!C14","v":17.70264264264264},{"$f":"G30*Calc2!C18","v":42.035933333333325},null,null,null,null,"discharge",{"$f":"IF(OR(M34=\"No Break\",M34=0),N35,N34)","v":"23:00:00"},{"$f":"IF(M36=\"No Break\",M37,M36)","v":"23:00:00"},{"$f":"IF(N35-M35<0,0,N35-M35)","v":"00:00:00"},{"$f":"IF(N36=\"No Break\",IF(P33=1,1,0),IF(Calc1!N36>Calc1!N37,1,\"\"))","v":0},null,null,{"$f":"IF(M36=\"No break\",\"\",IF((AB35-T35)*24*$N$14+AC34<$T$13,1,\"\"))","v":""},{"$f":"IF(M36=\"No Break\",AB34,M36)","v":"23:00:00"},{"$f":"IF(M36=\"No Break\",T35,IF(AND(AC34<$T$13,S35=1),AB35,IF(AC34<$T$13,T35+($T$13-AC34)/$N$14/24,T35)))","v":"23:00:00"},{"$f":"IF(M36=\"No Break\",AC34,IF(AND(AC34<$T$13,S35=1),AC34+(U35-T35)*24*$N$14,IF(AC34<=$T$13,$T$13,AC34)))","v":20.631765124521856},{"$f":"IF(M36=\"No Break\",\"\",IF((AB35-X35)*24*$T$14+V35>$N$12,1,\"\"))","v":""},{"$f":"U35","v":"23:00:00"},{"$f":"IF(M36=\"No Break\",X35,IF(S35=1,X35,IF(W35=1,X35+($N$12-V35)/$T$14/24,AB35)))","v":"23:00:00"},{"$f":"IF(S35=1,V35,V35+(Y35-X35)*24*$T$14)","v":20.631765124521856},{"$f":"Y35","v":"23:00:00"},{"$f":"IF(M36=\"No Break\",AA35,M36+O36)","v":"23:00:00"},{"$f":"Z35","v":20.631765124521856},null,null,null,{"$f":"U29","v":"23:00:00"},{"$f":"V29","v":20.631765124521856},0.52675053933113403]
[null,null,"Energy cost p.a./per truck",{"$f":"D35*Inputs!$F$20*Calc2!$C$6","v":3584.7851351351342},{"$f":"E35*Inputs!$F$20*Calc2!$C$6","v":2482.0968421052626},{"$f":"F35*Inputs!$F$20*Calc2!$C$6","v":4248.6342342342341},{"$f":"G35*Inputs!$F$20*Calc2!$C$6","v":10088.623999999998},null,null,null,null,"charge 9",{"$f":"IF(Inputs!H11=0,\"No Break\",Inputs!H11)","v":"No Break"},{"$f":"IF(M36=\"No Break\",\"No Break\",M36+O36)","v":"No Break"},{"$f":"IF(M36=\"No Break\",0,Inputs!H12/60/24)","v":"00:00:00"},null,{"$f":"O37*24*$N$13","v":0},{"$f":"IF(AC36<$R$61*$N$12,1,0)","v":0},null,{"$f":"M37","v":"23:00:00"},null,null,null,null,null,null,null,{"$f":"IF(OR(M38=\"No Break\",M38=0), T38,T37)","v":"23:00:00"},{"$f":"AC35-(AB36-T36)*24*$N$13","v":20.631765124521856},null,null,null,{"$f":"Y29","v":"23:00:00"},{"$f":"Z29","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,null,null,null,null,null,null,"discharge",{"$f":"IF(OR(M36=\"No Break\",M36=0),N37,N36)","v":"23:00:00"},{"$f":"IF(M38=\"No Break\",M39,M38)","v":"23:00:00"},{"$f":"IF(N37-M37<0,0,N37-M37)","v":"00:00:00"},{"$f":"IF(N38=\"No Break\",IF(P35=1,1,0),IF(Calc1!N38>Calc1!N39,1,\"\"))","v":0},null,null,{"$f":"IF(M38=\"No break\",\"\",IF((AB37-T37)*24*$N$14+AC36<$T$13,1,\"\"))","v":""},{"$f":"IF(M38=\"No Break\",AB36,M38)","v":"23:00:00"},{"$f":"IF(M38=\"No Break\",T37,IF(AND(AC36<$T$13,S37=1),AB37,IF(AC36<$T$13,T37+($T$13-AC36)/$N$14/24,T37)))","v":"23:00:00"},{"$f":"IF(M38=\"No Break\",AC36,IF(AND(AC36<$T$13,S37=1),AC36+(U37-T37)*24*$N$14,IF(AC36<=$T$13,$T$13,AC36)))","v":20.631765124521856},{"$f":"IF(M38=\"No Break\",\"\",IF((AB37-X37)*24*$T$14+V37>$N$12,1,\"\"))","v":""},{"$f":"U37","v":"23:00:00"},{"$f":"IF(OR(M38=\"No Break\",M38=0),X37,IF(S37=1,X37,IF(W37=1,X37+($N$12-V37)/$T$14/24,AB37)))","v":"23:00:00"},{"$f":"IF(S37=1,V37,V37+(Y37-X37)*24*$T$14)","v":20.631765124521856},{"$f":"Y37","v":"23:00:00"},{"$f":"IF(M38=\"No Break\",AA37,M38+O38)","v":"23:00:00"},{"$f":"Z37","v":20.631765124521856},null,null,null,{"$f":"AB29","v":"23:00:00"},{"$f":"AC29","v":20.631765124521856},0.52675053933113403]
[null,null,"Total refueling Costs (€) year 1 (inc Battery degorgation)",{"$f":"D36","v":3584.7851351351342},{"$f":"E36","v":2482.0968421052626},{"$f":"F36","v":4248.6342342342341},{"$f":"G36","v":10088.623999999998},null,null,null,null,"charge 10",{"$f":"IF(Inputs!J11=0,\"No Break\",Inputs!J11)","v":"No Break"},{"$f":"IF(M38=\"No Break\",\"No Break\",M38+O38)","v":"No Break"},{"$f":"IF(M38=\"No Break\",0,Inputs!J12/60/24)","v":"00:00:00"},null,{"$f":"O39*24*$N$13","v":0},{"$f":"IF(AC38<$R$61*$N$12,1,0)","v":0},null,{"$f":"M39","v":"23:00:00"},null,null,null,null,null,null,null,{"$f":"IF(OR(M40=\"No Break\",M40=0), T40,T39)","v":"23:00:00"},{"$f":"AC37-(AB38-T38)*24*$N$13","v":20.631765124521856},null,null,"discharge",{"$f":"AB30","v":"23:00:00"},{"$f":"AC30","v":20.631765124521856},0.52675053933113403]
[null,null,"Total refueling Costs (€) year2 (inc battery degrogation costs)",{"$f":"D38+D38*Calc2!$D$102","v":3699.4982594594585},{"$f":"E38+E38*Calc2!$D$103","v":2533.9726661052628},{"$f":"F38","v":4248.6342342342341},{"$f":"G38","v":10088.623999999998},null,null,null,null,"discharge",{"$f":"IF(OR(M38=\"No Break\",M38=0),N39,N38)","v":"23:00:00"},{"$f":"IF(M40=\"No Break\",M41,M40)","v":"23:00:00"},{"$f":"IF(N39-M39<0,0,N39-M39)","v":"00:00:00"},{"$f":"IF(N40=\"No Break\",IF(P37=1,1,0),IF(Calc1!N40>Calc1!N41,1,\"\"))","v":0},null,null,{"$f":"IF(M40=\"No break\",\"\",IF((AB39-T39)*24*$N$14+AC38<$T$13,1,\"\"))","v":""},{"$f":"IF(M40=\"No Break\",AB38,M40)","v":"23:00:00"},{"$f":"IF(M40=\"No Break\",T39,IF(AND(AC38<$T$13,S39=1),AB39,IF(AC38<$T$13,T39+($T$13-AC38)/$N$14/24,T39)))","v":"23:00:00"},{"$f":"IF(M40=\"No Break\",AC38,IF(AND(AC38<$T$13,S39=1),AC38+(U39-T39)*24*$N$14,IF(AC38<=$T$13,$T$13,AC38)))","v":20.631765124521856},{"$f":"IF(M40=\"No Break\",\"\",IF((AB39-X39)*24*$T$14+V39>$N$12,1,\"\"))","v":""},{"$f":"U39","v":"23:00:00"},{"$f":"IF(M40=\"No Break\",X39,IF(S39=1,X39,IF(W39=1,X39+($N$12-V39)/$T$14/24,AB39)))","v":"23:00:00"},{"$f":"IF(S39=1,V39,V39+(Y39-X39)*24*$T$14)","v":20.631765124521856},{"$f":"Y39","v":"23:00:00"},{"$f":"IF(M40=\"No Break\",AA39,M40+O40)","v":"23:00:00"},{"$f":"Z39","v":20.631765124521856},null,null,null,{"$f":"U31","v":"23:00:00"},{"$f":"V31","v":20.631765124521856},0.52675053933113403]
[null,null,"Total refueling Costs (€) year3 (inc battery degrogation costs)",{"$f":"D39+D39*Calc2!$D$102","v":3817.8822037621612},{"$f":"E39+E39*Calc2!$D$103","v":2586.9326948268626},{"$f":"F38","v":4248.6342342342341},{"$f":"G39","v":10088.623999999998},null,null,null,null,"charge 11",{"$f":"IF(Inputs!L11=0,\"No Break\",Inputs!L11)","v":"No Break"},{"$f":"IF(M40=\"No Break\",\"No Break\",M40+O40)","v":"No Break"},{"$f":"IF(M40=\"No Break\",0,Inputs!L12/60/24)","v":"00:00:00"},null,{"$f":"O41*24*$N$13","v":0},{"$f":"IF(AC40<$R$61*$N$12,1,0)","v":0},null,{"$f":"M41","v":"23:00:00"},null,null,null,null,null,null,null,{"$f":"IF(OR(M42=\"No Break\",M42=0), T42,T41)","v":"23:00:00"},{"$f":"AC39-(AB40-T40)*24*$N$13","v":20.631765124521856},null,null,null,{"$f":"Y31","v":"23:00:00"},{"$f":"Z31","v":20.631765124521856},0.52675053933113403]
[null,null,"Total refueling Costs (€) year4 (inc battery degrogation costs)",{"$f":"D40+D40*Calc2!$D$102","v":3940.0544342825506},{"$f":"E40+E40*Calc2!$D$103","v":2640.9995881487439},{"$f":"F39","v":4248.6342342342341},{"$f":"G40","v":10088.623999999998},null,null,null,null,"discharge",{"$f":"IF(OR(M40=\"No Break\",M40=0),N41,N40)","v":"23:00:00"},{"$f":"IF(M42=\"No Break\",M43,M42)","v":"23:00:00"},{"$f":"IF(N41-M41<0,0,N41-M41)","v":"00:00:00"},{"$f":"IF(N42=\"No Break\",IF(P39=1,1,0),IF(Calc1!N42>Calc1!N43,1,\"\"))","v":0},null,null,{"$f":"IF(M42=\"No break\",\"\",IF((AB41-T41)*24*$N$14+AC40<$T$13,1,\"\"))","v":""},{"$f":"IF(M42=\"No Break\",AB40,M42)","v":"23:00:00"},{"$f":"IF(M42=\"No Break\",T41,IF(AND(AC40<$T$13,S41=1),AB41,IF(AC40<$T$13,T41+($T$13-AC40)/$N$14/24,T41)))","v":"23:00:00"},{"$f":"IF(M42=\"No Break\",AC40,IF(AND(AC40<$T$13,S41=1),AC40+(U41-T41)*24*$N$14,IF(AC40<=$T$13,$T$13,AC40)))","v":20.631765124521856},{"$f":"IF(M42=\"No Break\",\"\",IF((AB41-X41)*24*$T$14+V41>$N$12,1,\"\"))","v":""},{"$f":"U41","v":"23:00:00"},{"$f":"IF(M42=\"No Break\",X41,IF(S41=1,X41,IF(W41=1,X41+($N$12-V41)/$T$14/24,AB41)))","v":"23:00:00"},{"$f":"IF(S41=1,V41,V41+(Y41-X41)*24*$T$14)","v":20.631765124521856},{"$f":"Y41","v":"23:00:00"},{"$f":"IF(M42=\"No Break\",AA41,M42+O42)","v":"23:00:00"},{"$f":"Z41","v":20.631765124521856},null,null,null,{"$f":"AB31","v":"23:00:00"},{"$f":"AC31","v":20.631765124521856},0.52675053933113403]
[null,null,"Total refueling Costs (€) year5 (inc battery degrogation costs)",{"$f":"D41+D41*Calc2!$D$102","v":4066.136176179592},{"$f":"E41+E41*Calc2!$D$103","v":2696.1964795410527},{"$f":"F40","v":4248.6342342342341},{"$f":"G41","v":10088.623999999998},null,null,null,null,"charge 12",{"$f":"IF(Inputs!N11=0,\"No Break\",Inputs!N11)","v":"No Break"},{"$f":"IF(M42=\"No Break\",\"No Break\",M42+O42)","v":"No Break"},{"$f":"IF(M42=\"No Break\",0,Inputs!N12/60/24)","v":"00:00:00"},null,{"$f":"O43*24*$N$13","v":0},{"$f":"IF(AC42<$R$61*$N$12,1,0)","v":0},null,{"$f":"M43","v":"23:00:00"},null,null,null,null,null,null,null,{"$f":"IF(OR(M44=\"No Break\",M44=0), T44,T43)","v":"23:00:00"},{"$f":"AC41-(AB42-T42)*24*$N$13","v":20.631765124521856},null,null,"discharge",{"$f":"AB32","v":"23:00:00"},{"$f":"AC32","v":20.631765124521856},0.52675053933113403]
[null,null,"average",{"$f":"AVERAGE(D38:D42)","v":3821.6712417637791},{"$f":"AVERAGE(E38:E42)","v":2588.039654145437},{"$f":"AVERAGE(F38:F42)","v":4248.6342342342341},{"$f":"AVERAGE(G38:G42)","v":10088.623999999998},null,null,null,null,"discharge",{"$f":"IF(OR(M42=\"No Break\",M42=0),N43,N42)","v":"23:00:00"},{"$f":"IF(M44=\"No Break\",M46,M44)","v":"23:00:00"},{"$f":"IF(N43-M43<0,0,N43-M43)","v":"00:00:00"},{"$f":"IF(N44=\"No Break\",IF(P41=1,1,0),IF(Calc1!N44>Calc1!N46,1,\"\"))","v":0},null,null,{"$f":"IF(M44=\"No break\",\"\",IF((AB43-T43)*24*$N$14+AC42<$T$13,1,\"\"))","v":""},{"$f":"IF(M44=\"No Break\",AB42,M44)","v":"23:00:00"},{"$f":"IF(M44=\"No Break\",T43,IF(AND(AC42<$T$13,S43=1),AB43,IF(AC42<$T$13,T43+($T$13-AC42)/$N$14/24,T43)))","v":"23:00:00"},{"$f":"IF(M44=\"No Break\",AC42,IF(AND(AC42<$T$13,S43=1),AC42+(U43-T43)*24*$N$14,IF(AC42<=$T$13,$T$13,AC42)))","v":20.631765124521856},{"$f":"IF(M44=\"No Break\",\"\",IF((AB43-X43)*24*$T$14+V43>$N$12,1,\"\"))","v":""},{"$f":"U43","v":"23:00:00"},{"$f":"IF(M44=\"No Break\",X43,IF(S43=1,X43,IF(W43=1,X43+($N$12-V43)/$T$14/24,AB43)))","v":"23:00:00"},{"$f":"IF(S43=1,V43,V43+(Y43-X43)*24*$T$14)","v":20.631765124521856},{"$f":"Y43","v":"23:00:00"},{"$f":"IF(M44=\"No Break\",AA43,M44+O44)","v":"23:00:00"},{"$f":"Z43","v":20.631765124521856},null,null,null,{"$f":"U33","v":"23:00:00"},{"$f":"V33","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,null,null,null,null,null,null,"charge 13",{"$f":"IF(Inputs!D15=0,\"No Break\",Inputs!D15)","v":"No Break"},{"$f":"IF(M44=\"No Break\",\"No Break\",M44+O44)","v":"No Break"},{"$f":"IF(M44=\"No Break\",0,Inputs!D16/60/24)","v":"00:00:00"},null,{"$f":"O46*24*$N$13","v":0},{"$f":"IF(AC44<$R$61*$N$12,1,0)","v":0},null,{"$f":"M46","v":"23:00:00"},null,null,null,null,null,null,null,{"$f":"IF(OR(M47=\"No Break\",M47=0), T47,T46)","v":"23:00:00"},{"$f":"AC43-(AB44-T44)*24*$N$13","v":20.631765124521856},null,null,null,{"$f":"Y33","v":"23:00:00"},{"$f":"Z33","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,null,null,null,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":"AB33","v":"23:00:00"},{"$f":"AC33","v":20.631765124521856},{"$f":"AH45/$N$12","v":0.52675053933113403}]
[null,null,null,null,null,null,null,null,null,null,null,"discharge",{"$f":"IF(OR(M44=\"No Break\",M44=0),N46,N44)","v":"23:00:00"},{"$f":"IF(M47=\"No Break\",M48,M47)","v":"23:00:00"},{"$f":"IF(N46-M46<0,0,N46-M46)","v":"00:00:00"},{"$f":"IF(N47=\"No Break\",IF(P43=1,1,0),IF(Calc1!N47>Calc1!N48,1,\"\"))","v":0},null,null,{"$f":"IF(M47=\"No break\",\"\",IF((AB46-T46)*24*$N$14+AC44<$T$13,1,\"\"))","v":""},{"$f":"IF(M47=\"No Break\",AB44,M47)","v":"23:00:00"},{"$f":"IF(M47=\"No Break\",T46,IF(AND(AC44<$T$13,S46=1),AB46,IF(AC44<$T$13,T46+($T$13-AC44)/$N$14/24,T46)))","v":"23:00:00"},{"$f":"IF(M47=\"No Break\",AC44,IF(AND(AC44<$T$13,S46=1),AC44+(U46-T46)*24*$N$14,IF(AC44<=$T$13,$T$13,AC44)))","v":20.631765124521856},{"$f":"IF(M47=\"No Break\",\"\",IF((AB46-X46)*24*$T$14+V46>$N$12,1,\"\"))","v":""},{"$f":"U46","v":"23:00:00"},{"$f":"IF(M47=\"No Break\",X46,IF(S46=1,X46,IF(W46=1,X46+($N$12-V46)/$T$14/24,AB46)))","v":"23:00:00"},{"$f":"IF(S46=1,V46,V46+(Y46-X46)*24*$T$14)","v":20.631765124521856},{"$f":"Y46","v":"23:00:00"},{"$f":"IF(M47=\"No Break\",AA46,M47+O47)","v":"23:00:00"},{"$f":"Z46","v":20.631765124521856},null,null,"discharge",{"$f":"AB34","v":"23:00:00"},{"$f":"AC34","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,null,null,null,null,null,null,"charge 14",{"$f":"IF(Inputs!F15=0,\"No Break\",Inputs!F15)","v":"No Break"},{"$f":"IF(M47=\"No Break\",\"No Break\",M47+O47)","v":"No Break"},{"$f":"IF(M47=\"No Break\",0,Inputs!F16/60/24)","v":"00:00:00"},null,{"$f":"O48*24*$N$13","v":0},{"$f":"IF(AC47<$R$61*$N$12,1,0)","v":0},null,{"$f":"M48","v":"23:00:00"},null,null,null,null,null,null,null,{"$f":"IF(OR(M49=\"No Break\",M49=0), T49,T48)","v":"23:00:00"},{"$f":"AC46-(AB47-T47)*24*$N$13","v":20.631765124521856},null,null,null,{"$f":"U35","v":"23:00:00"},{"$f":"V35","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,null,null,null,null,null,null,"discharge",{"$f":"IF(OR(M47=\"No Break\",M47=0),N48,N47)","v":"23:00:00"},{"$f":"IF(M49=\"No Break\",M50,M49)","v":"23:00:00"},{"$f":"IF(N48-M48<0,0,N48-M48)","v":"00:00:00"},{"$f":"IF(N49=\"No Break\",IF(P46=1,1,0),IF(Calc1!N49>Calc1!N50,1,\"\"))","v":0},null,null,{"$f":"IF(M49=\"No break\",\"\",IF((AB48-T48)*24*$N$14+AC47<$T$13,1,\"\"))","v":""},{"$f":"IF(M49=\"No Break\",AB47,M49)","v":"23:00:00"},{"$f":"IF(M49=\"No Break\",T48,IF(AND(AC47<$T$13,S48=1),AB48,IF(AC47<$T$13,T48+($T$13-AC47)/$N$14/24,T48)))","v":"23:00:00"},{"$f":"IF(M49=\"No Break\",AC47,IF(AND(AC47<$T$13,S48=1),AC47+(U48-T48)*24*$N$14,IF(AC47<=$T$13,$T$13,AC47)))","v":20.631765124521856},{"$f":"IF(M49=\"No Break\",\"\",IF((AB48-X48)*24*$T$14+V48>$N$12,1,\"\"))","v":""},{"$f":"U48","v":"23:00:00"},{"$f":"IF(M49=\"No Break\",X48,IF(S48=1,X48,IF(W48=1,X48+($N$12-V48)/$T$14/24,AB48)))","v":"23:00:00"},{"$f":"IF(S48=1,V48,V48+(Y48-X48)*24*$T$14)","v":20.631765124521856},{"$f":"Y48","v":"23:00:00"},{"$f":"IF(M49=\"No Break\",AA48,M49+O49)","v":"23:00:00"},{"$f":"Z48","v":20.631765124521856},null,null,null,{"$f":"Y35","v":"23:00:00"},{"$f":"Z35","v":20.631765124521856},0.52675053933113403]
[null,null,"Refueling Time / Batteries needed / Truck",null,null,null,null,null,null,null,null,"charge 15",{"$f":"IF(Inputs!H15=0,\"No Break\",Inputs!H15)","v":"No Break"},{"$f":"IF(M49=\"No Break\",\"No Break\",M49+O49)","v":"No Break"},{"$f":"IF(M49=\"No Break\",0,Inputs!H16/60/24)","v":"00:00:00"},null,{"$f":"O50*24*$N$13","v":0},{"$f":"IF(AC49<$R$61*$N$12,1,0)","v":0},null,{"$f":"M50","v":"23:00:00"},null,null,null,null,null,null,null,{"$f":"IF(OR(M51=\"No Break\",M51=0), T51,T50)","v":"23:00:00"},{"$f":"AC48-(AB49-T49)*24*$N$13","v":20.631765124521856},null,null,null,{"$f":"AB35","v":"23:00:00"},{"$f":"AC35","v":20.631765124521856},0.52675053933113403]
[null,null,"batteries per day per truck (fraction) / refueling per day",{"$f":"D5*D28/D23","v":1.993702651515151},{"$f":"COUNT(M19,M22,M24,M26,M28,M30,M32,M34,M36,M38,M40,M42)+1","v":6},{"$f":"D5*F28/F23","v":4.140969039214653},{"$f":"G30/G23","v":0.62183333333333313},null,null,null,null,"discharge",{"$f":"IF(OR(M49=\"No Break\",M49=0),N50,N49)","v":"23:00:00"},{"$f":"IF(M51=\"No Break\",M52,M51)","v":"23:00:00"},{"$f":"IF(N50-M50<0,0,N50-M50)","v":"00:00:00"},{"$f":"IF(N51=\"No Break\",IF(P48=1,1,0),IF(Calc1!N51>Calc1!N52,1,\"\"))","v":0},null,null,{"$f":"IF(M51=\"No break\",\"\",IF((AB50-T50)*24*$N$14+AC49<$T$13,1,\"\"))","v":""},{"$f":"IF(M51=\"No Break\",AB49,M51)","v":"23:00:00"},{"$f":"IF(M51=\"No Break\",T50,IF(AND(AC49<$T$13,S50=1),AB50,IF(AC49<$T$13,T50+($T$13-AC49)/$N$14/24,T50)))","v":"23:00:00"},{"$f":"IF(M51=\"No Break\",AC49,IF(AND(AC49<$T$13,S50=1),AC49+(U50-T50)*24*$N$14,IF(AC49<=$T$13,$T$13,AC49)))","v":20.631765124521856},{"$f":"IF(M51=\"No Break\",\"\",IF((AB50-X50)*24*$T$14+V50>$N$12,1,\"\"))","v":""},{"$f":"U50","v":"23:00:00"},{"$f":"IF(M51=\"No Break\",X50,IF(S50=1,X50,IF(W50=1,X50+($N$12-V50)/$T$14/24,AB50)))","v":"23:00:00"},{"$f":"IF(S50=1,V50,V50+(Y50-X50)*24*$T$14)","v":20.631765124521856},{"$f":"Y50","v":"23:00:00"},{"$f":"IF(M51=\"No Break\",AA50,M51+O51)","v":"23:00:00"},{"$f":"Z50","v":20.631765124521856},null,null,"discharge",{"$f":"AB36","v":"23:00:00"},{"$f":"AC36","v":20.631765124521856},0.52675053933113403]
[null,null,"Batteries per truck (integer)",{"$f":"IF((AND(ROUNDUP(D50,0)=1,(D5+D6)>16)), ROUNDUP(D50,0)+1, ROUNDUP(D50,0))","v":2},null,null,null,null,null,null,null,"charge 16",{"$f":"IF(Inputs!J15=0,\"No Break\",Inputs!J15)","v":"No Break"},{"$f":"IF(M51=\"No Break\",\"No Break\",M51+O51)","v":"No Break"},{"$f":"IF(M51=\"No Break\",0,Inputs!J16/60/24)","v":"00:00:00"},null,{"$f":"O52*24*$N$13","v":0},{"$f":"IF(AC51<$R$61*$N$12,1,0)","v":0},null,{"$f":"M52","v":"23:00:00"},null,null,null,null,null,null,null,{"$f":"IF(OR(M53=\"No Break\",M53=0), T53,T52)","v":"23:00:00"},{"$f":"AC50-(AB51-T51)*24*$N$13","v":20.631765124521856},null,null,null,{"$f":"U37","v":"23:00:00"},{"$f":"V37","v":20.631765124521856},0.52675053933113403]
[null,null,"Fuel / Energy consumption (annual)(kwh,L or KG)",{"$f":"D34*Inputs!F20*Calc2!C6","v":39830.945945945932},{"$f":"E34*Inputs!F20*Calc2!C6","v":27578.853801169585},{"$f":"F31*Inputs!F20*Calc2!C6","v":1416.2114114114113},{"$f":"G30*Inputs!F20*Calc2!C6","v":7760.4799999999977},null,null,null,null,"discharge",{"$f":"IF(OR(M51=\"No Break\",M51=0),N52,N51)","v":"23:00:00"},{"$f":"IF(M53=\"No Break\",M54,M53)","v":"23:00:00"},{"$f":"IF(N52-M52<0,0,N52-M52)","v":"00:00:00"},{"$f":"IF(N53=\"No Break\",IF(P50=1,1,0),IF(Calc1!N53>Calc1!N54,1,\"\"))","v":0},null,null,{"$f":"IF(M53=\"No break\",\"\",IF((AB52-T52)*24*$N$14+AC51<$T$13,1,\"\"))","v":""},{"$f":"IF(M53=\"No Break\",AB51,M53)","v":"23:00:00"},{"$f":"IF(M53=\"No Break\",T52,IF(AND(AC51<$T$13,S52=1),AB52,IF(AC51<$T$13,T52+($T$13-AC51)/$N$14/24,T52)))","v":"23:00:00"},{"$f":"IF(M53=\"No Break\",AC51,IF(AND(AC51<$T$13,S52=1),AC51+(U52-T52)*24*$N$14,IF(AC51<=$T$13,$T$13,AC51)))","v":20.631765124521856},{"$f":"IF(M53=\"No Break\",\"\",IF((AB52-X52)*24*$T$14+V52>$N$12,1,\"\"))","v":""},{"$f":"U52","v":"23:00:00"},{"$f":"IF(M53=\"No Break\",X52,IF(S52=1,X52,IF(W52=1,X52+($N$12-V52)/$T$14/24,AB52)))","v":"23:00:00"},{"$f":"IF(S52=1,V52,V52+(Y52-X52)*24*$T$14)","v":20.631765124521856},{"$f":"Y52","v":"23:00:00"},{"$f":"IF(M53=\"No Break\",AA52,M53+O53)","v":"23:00:00"},{"$f":"Z52","v":20.631765124521856},null,null,null,{"$f":"Y37","v":"23:00:00"},{"$f":"Z37","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,null,null,null,null,null,null,"charge 17",{"$f":"IF(Inputs!L15=0,\"No Break\",Inputs!L15)","v":"No Break"},{"$f":"IF(M53=\"No Break\",\"No Break\",M53+O53)","v":"No Break"},{"$f":"IF(M53=\"No Break\",0,Inputs!L16/60/24)","v":"00:00:00"},null,{"$f":"O54*24*$N$13","v":0},{"$f":"IF(AC53<$R$61*$N$12,1,0)","v":0},null,{"$f":"M54","v":"23:00:00"},null,null,null,null,null,null,null,{"$f":"IF(OR(M55=\"No Break\",M55=0), T55,T54)","v":"23:00:00"},{"$f":"AC52-(AB53-T53)*24*$N$13","v":20.631765124521856},null,null,null,{"$f":"AB37","v":"23:00:00"},{"$f":"AC37","v":20.631765124521856},0.52675053933113403]
[null,null,"Annual Battery change / Refueling time (hours)/truck",{"$f":"IF(D50>1,Inputs!F20*Calc2!C6*Inputs!F70/60*D50,Calc2!C6*Inputs!F20/60*Calc2!C29)","v":119.62215909090907},{"$f":"E50*Inputs!F20*Calc2!C6*Calc2!C82/60","v":24},{"$f":"F50*Inputs!F98/60*Inputs!$F$20*Calc2!$C$6","v":49.691628470575836},{"$f":"G50*Inputs!F44/60*Inputs!$F$20*Calc2!$C$6","v":49.746666666666655},null,null,null,null,"discharge",{"$f":"IF(OR(M53=\"No Break\",M53=0),N54,N53)","v":"23:00:00"},{"$f":"IF(M55=\"No Break\",M56,M55)","v":"23:00:00"},{"$f":"IF(N54-M54<0,0,N54-M54)","v":"00:00:00"},{"$f":"IF(N55=\"No Break\",IF(P52=1,1,0),IF(Calc1!N55>Calc1!N56,1,\"\"))","v":0},null,null,{"$f":"IF(M55=\"No break\",\"\",IF((AB54-T54)*24*$N$14+AC53<$T$13,1,\"\"))","v":""},{"$f":"IF(M55=\"No Break\",AB53,M55)","v":"23:00:00"},{"$f":"IF(M55=\"No Break\",T54,IF(AND(AC53<$T$13,S54=1),AB54,IF(AC53<$T$13,T54+($T$13-AC53)/$N$14/24,T54)))","v":"23:00:00"},{"$f":"IF(M55=\"No Break\",AC53,IF(AND(AC53<$T$13,S54=1),AC53+(U54-T54)*24*$N$14,IF(AC53<=$T$13,$T$13,AC53)))","v":20.631765124521856},{"$f":"IF(M55=\"No Break\",\"\",IF((AB54-X54)*24*$T$14+V54>$N$12,1,\"\"))","v":""},{"$f":"U54","v":"23:00:00"},{"$f":"IF(M55=\"No Break\",X54,IF(S54=1,X54,IF(W54=1,X54+($N$12-V54)/$T$14/24,AB54)))","v":"23:00:00"},{"$f":"IF(S54=1,V54,V54+(Y54-X54)*24*$T$14)","v":20.631765124521856},{"$f":"Y54","v":"23:00:00"},{"$f":"IF(M55=\"No Break\",AA54,M55+O55)","v":"23:00:00"},{"$f":"Z54","v":20.631765124521856},null,null,"discharge",{"$f":"AB38","v":"23:00:00"},{"$f":"AC38","v":20.631765124521856},0.52675053933113403]
[null,null,"Annual Refueling cost (€)",{"$f":"D54*Calc2!$C$21","v":3588.6647727272721},{"$f":"E54*Calc2!$C$21","v":720},{"$f":"F54*Calc2!$C$21","v":1490.7488541172752},{"$f":"G54*Calc2!$C$21","v":1492.3999999999996},null,null,null,null,"charge 18",{"$f":"IF(Inputs!N15=0,\"No Break\",Inputs!N15)","v":"No Break"},{"$f":"IF(M55=\"No Break\",\"No Break\",M55+O55)","v":"No Break"},{"$f":"IF(M55=\"No Break\",0,Inputs!N16/60/24)","v":"00:00:00"},null,{"$f":"O56*24*$N$13","v":0},{"$f":"IF(AC55<$R$61*$N$12,1,0)","v":0},null,{"$f":"M56","v":"23:00:00"},null,null,null,null,null,null,null,{"$f":"Inputs!F18","v":"23:00:00"},{"$f":"AC54-(AB55-T55)*24*$N$13","v":20.631765124521856},null,null,null,{"$f":"U39","v":"23:00:00"},{"$f":"V39","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,null,null,null,null,null,null,"discharge",{"$f":"IF(OR(M55=\"No Break\",M55=0),N56,N55)","v":"23:00:00"},{"$f":"Inputs!F18","v":"23:00:00"},{"$f":"IF(N56-M56<0,0,N56-M56)","v":"00:00:00"},null,null,null,{"$f":"IF(M57=\"No break\",\"\",IF((AB56-T56)*24*$N$14+AC55<$T$13,1,\"\"))","v":""},{"$f":"AB55","v":"23:00:00"},{"$f":"IF(M57=\"No Break\",T56,IF(AND(AC42<$T$13,S56=1),AB56,IF(AC42<$T$13,T56+($T$13-AC42)/$N$14/24,T56)))","v":"23:16:43.372"},{"$f":"IF(M57=\"No Break\",AC42,IF(AND(AC42<$T$13,S56=1),AC42+(U56-T56)*24*$N$14,IF(AC42<=$T$13,$T$13,AC42)))","v":31.334400000000002},{"$f":"IF(M57=\"No Break\",\"\",IF((AB56-X56)*24*$T$14+V56>$N$12,1,\"\"))","v":1},{"$f":"U56","v":"23:16:43.372"},{"$f":"IF(M57=\"No Break\",X56,IF(S56=1,X56,IF(W56=1,X56+($N$12-V56)/$T$14/24,AB56)))","v":"23:48:57.772"},{"$f":"IF(S56=1,V56,V56+(Y56-X56)*24*$T$14)","v":39.168000000000006},{"$f":"Y56","v":"23:48:57.772"},{"$f":"M18+1","v":1.2916666666666667},{"$f":"Z56","v":39.168000000000006},null,null,null,{"$f":"Y39","v":"23:00:00"},{"$f":"Z39","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,null,null,null,null,null,null,"charge",{"$f":"N56","v":"23:00:00"},{"$f":"M18+1","v":1.2916666666666667},{"$f":"N57-M57","v":"08:00:00"},{"$f":"IF(SUM(P18:P56)>0,1,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB39","v":"23:00:00"},{"$f":"AC39","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End time before end?",null,"minSOC exceeded?",{"$f":"IF(SUM(R18:R56)>0,\"EXCEEDED\",\"no\")","v":"no"},null,null,null,null,null,null,null,null,null,null,null,null,null,"discharge",{"$f":"AB40","v":"23:00:00"},{"$f":"AC40","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Operating hours per day",{"$f":"SUM(O18+O21+O23+O25+O27+O29+O31+O33+O35+O37+O39+O41+O43+O46+O48+O50+O52+O54+O56)","v":"13:40:00"},null,"Min SOC achieved",{"$f":"MIN(AC17:AC56)/N$12","v":0.15678074535926456},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U41","v":"23:00:00"},{"$f":"V41","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Break hours per day",{"$f":"O19+O22+O24+O26+O28+O30+O32+O34+O36+O38+O40+O42+O57+O44+O47+O49+O51+O53+O55","v":"10:20:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y41","v":"23:00:00"},{"$f":"Z41","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min SOD allowed",{"$f":"Calc2!C75/100","v":0.04},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB41","v":"23:00:00"},{"$f":"AC41","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"True break hours /day",{"$f":"O19+IF(M22=\"No Break\",0,O22)+IF(M24=\"No Break\",0,O24)+IF(M26=\"No Break\",0,O26)+IF(M28=\"No Break\",0,O28)+IF(M30=\"No Break\",0,O30)+IF(M32=\"No Break\",0,O32)+IF(M34=\"No Break\",0,O34)+IF(M36=\"No Break\",0,O36)+IF(M38=\"No Break\",0,O38)+IF(M40=\"No Break\",0,O40)+IF(M42=\"No Break\",0,O42)+IF(M44=\"No Break\",0,O44)+IF(M47=\"No Break\",0,O47)+IF(M49=\"No Break\",0,O49)+IF(M51=\"No Break\",0,O51)+IF(M53=\"No Break\",0,O53)+IF(M55=\"No Break\",0,O55)","v":"02:20:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"discharge",{"$f":"AB42","v":"23:00:00"},{"$f":"AC42","v":20.631765124521856},{"$f":"AH62/$N$12","v":0.52675053933113403}]
[null,null,null,null,null,null,null,null,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":"U43","v":"23:00:00"},{"$f":"V43","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,null,null,null,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":"Y43","v":"23:00:00"},{"$f":"Z43","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,null,null,null,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":"AB43","v":"23:00:00"},{"$f":"AC43","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"discharge",{"$f":"AB44","v":"23:00:00"},{"$f":"AC44","v":20.631765124521856},{"$f":"AH66/$N$12","v":0.52675053933113403}]
[null,null,"Battery / Power Cells maintenance & service / truck",null,null,null,null,null,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":"U46","v":"23:00:00"},{"$f":"V46","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,{"$f":"Calc2!C93","v":500},null,null,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":"Y46","v":"23:00:00"},{"$f":"Z46","v":20.631765124521856},0.52675053933113403]
[null,null,"Annual Battery inspection",{"$f":"Calc2!C105*D51","v":200},{"$f":"Calc2!C109","v":50},{"$f":"Calc2!C94","v":350},null,null,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":"AB46","v":"23:00:00"},{"$f":"AC46","v":20.631765124521856},0.52675053933113403]
[null,null,"Water top up",{"$f":"Calc2!C106","v":50},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"discharge",{"$f":"AB47","v":"23:00:00"},{"$f":"AC47","v":20.631765124521856},0.52675053933113403]
[null,null,"annual infrastructure fees (€)",null,null,{"$f":"Inputs!F102","v":0},{"$f":"Inputs!F50","v":0},null,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":"U48","v":"23:00:00"},{"$f":"V48","v":20.631765124521856},0.52675053933113403]
[null,null,"Total service Costs (€)",{"$f":"SUM(D68:D71)","v":250},{"$f":"SUM(E68:E71)","v":50},{"$f":"SUM(F68:F71)","v":850},{"$f":"SUM(G68:G71)","v":0},null,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":"Y48","v":"23:00:00"},{"$f":"Z48","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"discharge",{"$f":"AB49","v":"23:00:00"},{"$f":"AC49","v":20.631765124521856},0.52675053933113403]
[null,null,"Initial Investment / fleet",null,null,null,null,null,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":"U50","v":"23:00:00"},{"$f":"V50","v":20.631765124521856},0.52675053933113403]
[null,null,"Truck/s ",{"$f":"(IF(Inputs!F79=\"no\", (Inputs!F59*Inputs!F27), (Inputs!F59*Inputs!F27)/Performance!B12))","v":337000},{"$f":"IF(Inputs!F92=\"no\", (Inputs!F59*Inputs!F27), (Inputs!F59*Inputs!F27)/Performance!B12)","v":337000},{"$f":"IF(Inputs!F104=\"no\", (Inputs!F59*Inputs!F27), (Inputs!F59*Inputs!F27)/Performance!B12)","v":337000},{"$f":"IF(Inputs!F52=\"no\", (Inputs!F47*Inputs!F27), (Inputs!F47*Inputs!F27)/Performance!B12)","v":360000},null,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":"Y50","v":"23:00:00"},{"$f":"Z50","v":20.631765124521856},0.52675053933113403]
[null,null,"Batteries / Power Cells",{"$f":"(Inputs!F72*D51*Inputs!F27)","v":140000},{"$f":"(Inputs!F87*Inputs!F27)","v":200000},{"$f":"(Inputs!F100*Inputs!F27)","v":200000},null,null,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":"AB50","v":"23:00:00"},{"$f":"AC50","v":20.631765124521856},0.52675053933113403]
[null,null,"Infrastructure / Installation",{"$f":"Inputs!F75","v":0},{"$f":"Inputs!F90","v":0},{"$f":"Inputs!F101","v":50000},{"$f":"Inputs!F49","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"discharge",{"$f":"AB51","v":"23:00:00"},{"$f":"AC51","v":20.631765124521856},0.52675053933113403]
[null,null,"Charger",{"$f":"(Inputs!F73*Inputs!F27)*Inputs!F74","v":12000},{"$f":"(Inputs!F88*Inputs!F27)*Inputs!F89","v":37500},null,null,null,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":"U52","v":"23:00:00"},{"$f":"V52","v":20.631765124521856},0.52675053933113403]
[null,null,"Charge room",{"$f":"IF(Inputs!F78=Calc2!E72,Calc2!$C$118,0)*Inputs!F27","v":0},null,null,null,null,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":"Y52","v":"23:00:00"},{"$f":"Z52","v":20.631765124521856},0.52675053933113403]
[null,null,"Total initial investment",{"$f":"SUM(D75:D79)","v":489000},{"$f":"SUM(E75:E79)","v":574500},{"$f":"SUM(F75:F79)","v":587000},{"$f":"SUM(G75:G79)","v":360000},null,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":"AB52","v":"23:00:00"},{"$f":"AC52","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"discharge",{"$f":"AB53","v":"23:00:00"},{"$f":"AC53","v":20.631765124521856},0.52675053933113403]
[null,null,"Operational costs (annual) / truck",null,null,null,null,null,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":"U54","v":"23:00:00"},{"$f":"V54","v":20.631765124521856},0.52675053933113403]
[null,null,"Energy consumption",{"$f":"D43","v":3821.6712417637791},{"$f":"E43","v":2588.039654145437},{"$f":"F43","v":4248.6342342342341},{"$f":"G43","v":10088.623999999998},null,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":"Y54","v":"23:00:00"},{"$f":"Z54","v":20.631765124521856},0.52675053933113403]
[null,null,null,null,null,null,null,null,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":"AB54","v":"23:00:00"},{"$f":"AC54","v":20.631765124521856},0.52675053933113403]
[null,null,"Driver Refueling costs",{"$f":"D55","v":3588.6647727272721},{"$f":"E55","v":720},{"$f":"F55","v":1490.7488541172752},{"$f":"G55","v":1492.3999999999996},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"discharge",{"$f":"AB55","v":"23:00:00"},{"$f":"AC55","v":20.631765124521856},0.52675053933113403]
[null,null,"Lost productivity",{"$f":"IF(Inputs!F79=\"no\", (Inputs!F20*Inputs!F29*Calc2!C6*D5) -             ( Inputs!F20*Inputs!F29*Calc2!C6*D5/Performance!B12),0)","v":0},{"$f":"IF(Inputs!F92=\"no\", (Inputs!F20*Inputs!F29*Calc2!C6*D5) -             ( Inputs!F20*Inputs!F29*Calc2!C6*D5/Performance!B12),0)","v":0},{"$f":"IF(Inputs!F104=\"no\", (Inputs!F20*Inputs!F29*Calc2!C6*D5) -             ( Inputs!F20*Inputs!F29*Calc2!C6*D5/Performance!B12),0)","v":0},{"$f":"IF(Inputs!F52=\"no\", (Inputs!F20*Inputs!F29*Calc2!C6*D5) -             ( Inputs!F20*Inputs!F29*Calc2!C6*D5/Performance!B12),0)","v":0},null,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":"U56","v":"23:16:43.372"},{"$f":"V56","v":31.334400000000002},0.8]
[null,null,"Truck & Batt  service & Maintenance fee per year",{"$f":"12*Inputs!F60+(12*Calc2!C107)+D72","v":2050},{"$f":"12*Inputs!F60+E72","v":1850},{"$f":"12*Inputs!F60+F72","v":2650},{"$f":"12*Inputs!F48+G72+(Calc2!C26/Calc2!D26*Inputs!F21)","v":3397.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,{"$f":"Y56","v":"23:48:57.772"},{"$f":"Z56","v":39.168000000000006},1.0000000000000002]
[null,null,null,null,null,null,null,null,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":"AB55","v":"23:00:00"},{"$f":"AC56","v":39.168000000000006},{"$f":"AH88/N12","v":1.0000000000000002}]
[null,null,"Total",{"$f":"SUM(D83:D88)","v":9460.3360144910512},{"$f":"SUM(E83:E88)","v":5158.0396541454375},{"$f":"SUM(F83:F88)","v":8389.3830883515093},{"$f":"SUM(G83:G88)","v":14978.523999999998}]
[]
[null,null,"Carbon Emissions (kg of CO2) / truck/year"]
[null,null,"Carbon Emissions at source (used for chargers or H2)",{"$f":"D34*Calc2!$C$6*Inputs!F20*Calc2!$C$28","v":21520.978742162155},{"$f":"E34*Calc2!$C$6*Inputs!F20*Calc2!$C$28","v":14901.075339602339},{"$f":"F31*Calc2!$C$6*Inputs!F20*Calc2!C92","v":53532.791351351341},{"$f":"IF(Inputs!F39=\"diesel\",G52*Calc2!C43,IF(Inputs!F39=\"lpg\",G52*Calc2!C60,0))","v":6078.9803334939743}]
[null,null,"Truck emissions Kg/Co2/truck",0,0,0,{"$f":"IF(Inputs!F39=\"diesel\",G52*Calc2!C35,IF(Inputs!F39=\"lpg\",G52*Calc2!C51,0))","v":20480.682767999995}]
[null,null,"Total KgCO2/Truck",{"$f":"SUM(D92:D93)","v":21520.978742162155},{"$f":"SUM(E92:E93)","v":14901.075339602339},{"$f":"SUM(F92:F93)","v":53532.791351351341},{"$f":"SUM(G92:G93)","v":26559.66310149397}]
[]
[]
[null,null,"Depreciation/fleet/year"]
[null,null,"Truck Value / fleet/year ",{"$f":"D75","v":337000},{"$f":"E75","v":337000},{"$f":"F75","v":337000},{"$f":"G75","v":360000},null,null,"If this cell is Red - minimum SOC of the Li battery has been breached during the shift cycle"]
[null,null,1,{"$f":"D98*(1-Calc2!D97)","v":255412.30000000002},{"$f":"E98*(1-Calc2!D97)","v":255412.30000000002},{"$f":"F98*(1-Calc2!D97)","v":255412.30000000002},{"$f":"G98*(1-Calc2!D96)","v":282960}]
[null,null,2,{"$f":"D99*(1-Calc2!D97)","v":193576.98217000003},{"$f":"E99*(1-Calc2!D97)","v":193576.98217000003},{"$f":"F99*(1-Calc2!D97)","v":193576.98217000003},{"$f":"G99*(1-Calc2!D96)","v":222406.56}]
[null,null,3,{"$f":"D100*(1-Calc2!D97)","v":146711.99478664302},{"$f":"E100*(1-Calc2!D97)","v":146711.99478664302},{"$f":"F100*(1-Calc2!D97)","v":146711.99478664302},{"$f":"G100*(1-Calc2!D96)","v":174811.55616000001}]
[null,null,4,{"$f":"D101*(1-Calc2!D97)","v":111193.02084879675},{"$f":"E101*(1-Calc2!D97)","v":111193.02084879675},{"$f":"F101*(1-Calc2!D97)","v":111193.02084879675},{"$f":"G101*(1-Calc2!D96)","v":137401.88314176002}]
[null,null,5,{"$f":"D102*(1-Calc2!D97)","v":84273.190501303063},{"$f":"E102*(1-Calc2!D97)","v":84273.190501303063},{"$f":"F102*(1-Calc2!D97)","v":84273.190501303063},{"$f":"G102*(1-Calc2!D96)","v":107997.88014942338}]
[]
[null,null,"Power source Value / fleet /year",{"$f":"D76+D78","v":152000},{"$f":"E76+E78","v":237500},{"$f":"F76+F78","v":200000},{"$f":"G76+G78","v":0}]
[null,null,1,{"$f":"D105*(1-Calc2!D98)","v":104120.00000000001},{"$f":"E105*(1-Calc2!D99)","v":186675},{"$f":"F105*(1-Calc2!D100)","v":157200}]
[null,null,2,{"$f":"D106*(1-Calc2!D98)","v":71322.200000000012},{"$f":"E106*(1-Calc2!D99)","v":146726.55000000002},{"$f":"F106*(1-Calc2!D100)","v":123559.20000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,3,{"$f":"D107*(1-Calc2!D98)","v":48855.707000000009},{"$f":"E107*(1-Calc2!D99)","v":115327.06830000001},{"$f":"F107*(1-Calc2!D100)","v":97117.531200000012}]
[null,null,4,{"$f":"D108*(1-Calc2!D98)","v":33466.159295000012},{"$f":"E108*(1-Calc2!D99)","v":90647.075683800009},{"$f":"F108*(1-Calc2!D100)","v":76334.379523200012}]
[null,null,5,{"$f":"D109*(1-Calc2!D98)","v":22924.319117075011},{"$f":"E109*(1-Calc2!D99)","v":71248.601487466804},{"$f":"F109*(1-Calc2!D100)","v":59998.822305235211}]
[]
[null,null,"Total Depreciation / Fleet / year Truck and Power source"]
[null,null,1,{"$f":"(D98-D99)+(D105-D106)","v":129467.69999999997},{"$f":"(E98-E99)+(E105-E106)","v":132412.69999999998},{"$f":"(F98-F99)+(F105-F106)","v":124387.69999999998},{"$f":"(G98-G99)+(G105-G106)","v":77040}]
[null,null,2,{"$f":"(D99-D100)+(D106-D107)+D113","v":224100.81782999996},234196.46782999995,219863.81782999996,137593.44]
[null,null,3,293432.29821335699,312460.936913357,293170.47401335696,185188.44383999999]
[null,null,4,344340.81985620328,372659.90346740326,349472.5996280032,222598.11685823998]
[null,null,5,381802.49038162199,418978.20801123016,392727.98719346168,252002.11985057662]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Lead Acid","lithium ion"]
[null,null,null,null,null,"Fuel Cell","ICE"]
[null,null,"Cumulative Costs (per year)"]
[null,null,0,{"$f":"D80","v":489000},{"$f":"E80","v":574500},{"$f":"F80","v":587000},{"$f":"G80","v":360000}]
[null,null,1,{"$f":"D$80+(Inputs!$F$27*$C127*D$89)+D113","v":713071.06014491047},{"$f":"E$80+Inputs!$F$27*$C127*E$89+E113","v":758493.09654145432},{"$f":"F$80+Inputs!$F$27*$C127*F$89+F113","v":795281.53088351502},{"$f":"G$80+Inputs!$F$27*$C127*G$89+G113","v":586825.24}]
[null,null,2,{"$f":"D$80+(Inputs!$F$27*$C128*D$89)+D114","v":902307.53811982099},{"$f":"E$80+Inputs!$F$27*$C128*E$89+E114","v":911857.26091290871},{"$f":"F$80+Inputs!$F$27*$C128*F$89+F114","v":974651.47959703009},{"$f":"G$80+Inputs!$F$27*$C128*G$89+G114","v":797163.91999999993}]
[null,null,3,{"$f":"D$80+(Inputs!$F$27*$C129*D$89)+D115","v":1066242.3786480885},{"$f":"E$80+Inputs!$F$27*$C129*E$89+E115","v":1041702.1265377201},{"$f":"F$80+Inputs!$F$27*$C129*F$89+F115","v":1131851.9666639022},{"$f":"G$80+Inputs!$F$27*$C129*G$89+G115","v":994544.16383999994}]
[null,null,4,{"$f":"D$80+(Inputs!$F$27*$C130*D$89)+D116","v":1211754.2604358452},{"$f":"E$80+Inputs!$F$27*$C130*E$89+E116","v":1153481.4896332207},{"$f":"F$80+Inputs!$F$27*$C130*F$89+F116","v":1272047.9231620636},{"$f":"G$80+Inputs!$F$27*$C130*G$89+G116","v":1181739.0768582399}]
[null,null,5,{"$f":"D$80+(Inputs!$F$27*$C131*D$89)+D117","v":1343819.2911061745},{"$f":"E$80+Inputs!$F$27*$C131*E$89+E117","v":1251380.190718502},{"$f":"F$80+Inputs!$F$27*$C131*F$89+F117","v":1399197.1416110371},{"$f":"G$80+Inputs!$F$27*$C131*G$89+G117","v":1360928.3198505763}]
[]
[]
[]
[]
[null,null,"Table used for calulation paypack period (including depreciation)"]
[null,null,{"$f":"C80","v":"Total initial investment"},{"$f":"D80","v":489000},{"$f":"E80","v":574500},{"$f":"F80","v":587000},{"$f":"G80","v":360000}]
[null,null,"Averagae Depreciation",{"$f":"AVERAGE(D113:D117)","v":274628.82525623648},{"$f":"AVERAGE(E113:E117)","v":294141.64324439806},{"$f":"AVERAGE(F113:F117)","v":275924.51573296438},{"$f":"AVERAGE(G113:G117)","v":174884.42410976332}]
[null,null,"Yearly investment cost",{"$f":"D138+D137","v":763628.82525623648},{"$f":"E138+E137","v":868641.64324439806},{"$f":"F138+F137","v":862924.51573296438},{"$f":"G138+G137","v":534884.42410976335}]
[]
[]
[]
[]
[null,null,null,"Lead Acid","lithium ion","Fuel Cell","ICE"]
[]
[]
[null,null,"Max Power required when charging","n.a.",{"$f":"IF(D14=Trucks!$C$265,VLOOKUP(E16,Trucks!D265:G269,3,FALSE)*Inputs!F27*Inputs!F89,IF(D14=Trucks!C270,VLOOKUP(E16,Trucks!D270:F274,3,FALSE)*Inputs!F27*Inputs!F89))","v":399},"n.a.","n.a."]
[null,null,"Fuel / Energy consumption (annual)(kwh,L or KG)",{"$f":"Inputs!$F$27*Calc1!D52","v":398309.45945945929},{"$f":"Inputs!$F$27*Calc1!E52","v":275788.53801169584},{"$f":"Inputs!$F$27*Calc1!F52","v":14162.114114114112},{"$f":"Inputs!$F$27*Calc1!G52","v":77604.799999999974}]
[]
[]
[]
[null,null,"Productivity"]
[null,null,"Total Operation Hrs/truck/year",{"$f":"D5*Calc2!C6*Inputs!F20","v":3279.9999999999991},{"$f":"D5*Calc2!C6*Inputs!F20","v":3279.9999999999991},{"$f":"D5*Calc2!C6*Inputs!F20","v":3279.9999999999991},{"$f":"D5*Calc2!C6*Inputs!F20","v":3279.9999999999991}]
[null,null,"Refueling / Lost productivity (hours)/truck/year",{"$f":"D54","v":119.62215909090907},{"$f":"E54","v":24},{"$f":"F54","v":49.691628470575836},{"$f":"G54","v":49.746666666666655}]
[null,null,"%",{"$f":"D154/D153","v":3.647017045454546E-2},{"$f":"E154/E153","v":7.3170731707317095E-3},{"$f":"F154/F153","v":1.51498867288341E-2},{"$f":"G154/G153","v":1.5166666666666667E-2}]
[]
[null,null,"No of pallets moved/truck/year (assume 20/hr) (STD ECLO mode)",{"$f":"20*D5*Calc2!C6*Inputs!F20","v":65599.999999999971},{"$f":"20*D5*Calc2!C6*Inputs!F20","v":65599.999999999971},{"$f":"20*D5*Calc2!C6*Inputs!F20","v":65599.999999999971},{"$f":"20*D5*Calc2!C6*Inputs!F20","v":65599.999999999971}]
[null,null,"Pallets moved ",{"$f":"IF(Inputs!F79=\"yes\",Performance!B12*D157,Performance!C12*D157)","v":65599.999999999971},{"$f":"IF(Inputs!F92=\"yes\",Performance!B12*E157,Performance!C12*E157)","v":65599.999999999971},{"$f":"IF(Inputs!F104=\"yes\",Performance!B12*F157,Performance!C12*F157)","v":65599.999999999971},{"$f":"IF(Inputs!F52=\"yes\",Performance!B12*G157,Performance!C12*G157)","v":65599.999999999971}]
[]
[null,null,"No of pallets moved/truck/year /FLEET (assume 20/hr)",{"$f":"D158*Inputs!F27","v":655999.99999999977},{"$f":"E158*Inputs!F27","v":655999.99999999977},{"$f":"F158*Inputs!F27","v":655999.99999999977},{"$f":"G158*Inputs!F27","v":655999.99999999977}]
[]
[]
[]
[]
[null,null,"Cost of Lost productivity/truck",{"$f":"D154*Calc2!C21","v":3588.6647727272721},{"$f":"E154*Calc2!C21","v":720},{"$f":"F154*Calc2!C21","v":1490.7488541172752},{"$f":"G154*Calc2!C21","v":1492.3999999999996}]
[null,null,"Cost of Lost productivity/fleet",{"$f":"D165*Inputs!F27","v":35886.647727272721},{"$f":"E165*Inputs!F27","v":7200},{"$f":"F165*Inputs!F27","v":14907.488541172752},{"$f":"G165*Inputs!F29","v":44771.999999999985}]

{"sheet":"Performance","index":5,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Select Hip","Yes","No"]
[null,null,null,null,null,null,null,null,null,null,"Energency Increase ",1.1499999999999999,1]
[null,null,null,null,null,null,null,null,null,null,"Performance increase",1.05,1]
[]
[]
[]
["Select Hip","Yes","No"]
["Energency Increase ",1,1]
["Performance increase",1,1]

{"sheet":"TBD - Li-Ion Chargers","index":6,"n_rows":36,"n_cols":20,"rows_kept":36,"cut":false,"hidden":true,"merged":[[1,1,37,1],[1,2,4,2],[1,9,3,9],[1,10,3,10],[36,2,36,19],[37,2,37,19],[1,12,2,16],[1,17,2,18],[1,19,3,19],[3,3,3,5],[4,3,4,5]]}
[]
[null,"IP 54 MODELS","Type","Output",null,null,null,null,null,"Phase Current","Max Input Power","Input Protection","Housing Dimensions",null,null,null,null,"Mandatory Space",null,"Weight"]
[null,null,null,null,null,null,null,null,null,null,null,"Breaker Curve [D]"]
[null,null,null,"U Range",null,null,null,"I max","Pout max",null,null,"Input Fuse gG Type","L","W","H","D","E","M","S"]
[null,null,null,"V",null,null,"V","A","kW","A (±10%)","kVA","Rated AMP (1)","mm","mm","mm","mm","mm","mm","mm","kg"]
[null,null,"HE Li-Ion 0-A M*",6,null,33,24,60,"1,7",8.3000000000000007,2,15,171,111,420,425,70,null,100,5]
[null,null,"HE Li-Ion 1-A M IP54* ",6,"-",33,24,100,"2,9",13.7,3.2,25,410,234,716,582,243,150,150,26]
[null,null,"HE Li-Ion 1-B M IP54* ",18,"-",70,24,70,"3,2",15.1,3.5,40,410,234,716,582,243,150,150,26]
[null,null,"HE Li-Ion 1-B2 M IP54* ",18,"-",70,24,140,"5,8",30,7,25,410,234,716,582,243,150,150,46]
[null,null,"HE Li-Ion 3-A 24 T IP54*",6,"-",33,24,150,"4,3",7.2,5,10,410,234,716,582,243,150,150,42]
[null,null,"HE Li-Ion 12/24-200 T IP54 ",6,"-",33,24,200,"5,8",9.4,6.5,15,487,555,1001,582,243,150,150,165]
[null,null,"HE Li-Ion 12/24-250 T IP54 ",6,"-",33,24,250,"7,2",11.8,8.1999999999999993,20,487,555,1001,"-","-",150,460,185]
[null,null,"HE Li-Ion 12/24-320 T IP54 ",6,"-",33,24,320,"9,2",15.1,10.4,25,811,503,1801,"-","-",150,460,365]
[null,null,"HE Li-Ion 12/24-500 T IP54 ",6,"-",33,24,500,"14,4",23.6,16.3,40,811,503,1801,"-","-",150,460,400]
[null,null,"HE Li-Ion 0-B M*",30,null,70,48,40,"1,7",8.3000000000000007,2,15,171,111,420,425,70,null,100,5]
[null,null,"HE Li-Ion 1-B M IP54* ",18,"-",70,24,70,"3,2",15.1,3.5,40,410,234,716,582,243,150,150,26]
[null,null,"HE Li-Ion 1-B2 M IP54* ",18,"-",70,48,140,"5,8",30,7,25,410,234,716,582,243,150,150,46]
[null,null,"HE Li-Ion 3-S T IP54* ",18,"-",70,48,100,"5,8",9.6,6.7,15,410,234,716,582,243,150,150,44]
[null,null,"HE Li-Ion 3-A T IP54* ",18,"-",70,48,150,"8,6",14.4,10,20,410,234,716,582,243,150,150,44]
[null,null,"HE Li-Ion 12/48-200 T IP54 ",6,"-",70,48,200,"11,5",18.7,12.9,25,811,503,1801,"-","-",150,460,360]
[null,null,"HE Li-Ion 12/48-250 T IP54 ",6,"-",70,48,250,"14,4",23.3,16.100000000000001,40,811,503,1801,"-","-",150,460,380]
[null,null,"HE Li-Ion 12/48-320 T IP54 ",6,"-",70,48,320,"18,4",29.9,20.7,40,811,503,1801,"-","-",150,460,425]
[null,null,"HE Li-Ion 12/48-500 T IP54 ",6,"-",70,48,500,"28,8",46.7,32.299999999999997,70,1626,503,1801,"-","-",150,460,760]
[null,null,"HE Li-Ion 12/48-600 T IP54 ",6,"-",70,48,600,"34,6",56,38.799999999999997,80,1626,503,1801,"-","-",150,460,790]
[null,null,"HE Li-Ion 1-C M IP54* ",60,"-",130,80,35,"2,9",13.7,3.2,25,410,234,716,582,243,150,150,26]
[null,null,"HE Li-Ion 1-C2 M IP54* ",60,"-",130,80,70,"5,8",30,7,40,410,234,716,582,243,150,150,46]
[null,null,"HE Li-Ion 3-B T IP54* ",60,"-",130,80,90,"7,7",12.8,8.9,20,410,234,716,582,243,150,150,44]
[null,null,"HE Li-Ion 12/80-120 T IP54 ",6,"-",130,80,120,"11,5",18.5,12.8,25,487,555,1001,"-","-",150,460,190]
[null,null,"HE Li-Ion 12/80-160 T IP54 ",6,"-",130,80,160,"15,4",24.6,17,40,811,503,1801,"-","-",150,460,365]
[null,null,"HE Li-Ion 12/80-200 T IP54 ",6,"-",130,80,200,"19,2",30.8,21.3,50,811,503,1801,"-","-",150,460,440]
[null,null,"HE Li-Ion 12/80-250 T IP54 ",6,"-",130,80,250,24,38.5,26.6,60,811,503,1801,"-","-",150,460,455]
[null,null,"HE Li-Ion 12/80-320 T IP54 ",6,"-",130,80,320,"30,7",49.2,34.1,70,811,503,1801,"-","-",150,460,460]
[null,null,"HE Li-Ion 12/80-500 T IP54 ",6,"-",130,80,500,48,76.900000000000006,53.2,110,1626,503,1801,"-","-",150,460,930]
[null,null,"HE Li-Ion 12/120-100 T IP54 ",6,"-",150,120,100,"11,5",23.1,16,40,811,503,1801,"-","-",150,460,365]
[null,null,"HE Li-Ion 12/120-150 T IP54 ",6,"-",150,120,150,"17,3",34.6,24,55,811,503,1801,"-","-",150,460,440]
[null,null,"HE Li-Ion 12/120-200 T IP54 ",6,"-",150,120,200,23,46.2,32,70,811,503,1801,"-","-",150,460,455]

{"sheet":" Maintenance","index":7,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Euro/GBP",1.1299999999999999]
[null,"Battery Maintence"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Topping up charge per visit Pro rata £16/battery every 4 weeks = £192 (211 Euro )"]
[null,null,null,null,null,null,null,null,null,null,null,"Battery Cleaning Annual £150 (165Euro)"]
[null,null,null,null,null,null,null,null,null,null,null,"Charger Clean and service £244 (268Euro)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TRUCK Maintenance"]
[null,10000,"hr Maint Cost Grand Total",null,"H50XT  LPG (PSI)",null,null,5515.57,{"$f":"H34*P1","v":6232.5940999999993}]
[null,10000,"hr Maint Cost Grand Total",null,"JXN/ERPVL",null,null,2726.83,{"$f":"H35*P1","v":3081.3178999999996}]

{"sheet":"Devlogs","index":8,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Not included "]
[]
[null,null,null,"Incentives/benefits removed for EU version - note added to output page"]
[null,null,null,"Note we have not included productivity in this model (Hip/Eco disabled)"]
[null,null,null,"We have no EOL disposal costs"]
[null,null,null,"Fuel cell rebuild"]
[]
[]
[null,null,"We have included "]
[null,null,null,"Depreciation value added to the over all costs","Matt to confirm value"]
[null,null,null,"Battery degrogation","Nominal value added spread over 5 year"]
[null,null,null,"Payback time"]
[null,null,null,"Service rates"]
[null,null,null,"Carbon Emission"]
[null,null,null,"Options for Incentives/Benefits"]
[null,null,null,"Refuel time/Batt change over"]
[]
[]
[null,null,"·         Tidy up charger and Battery offering – IW"]
[null,null,"·         Remove incentives for Europe and add a note in the output tab for local incentives – IW"]
[null,null,"·         Check water top up and battery maintenance – IW ",null,"YES"]
[null,null,"·         Add 4-5 T Ice -  Student "]
[null,null,"·         Add in disclaimers IW"]
[null,null,"·         Note to convert liters to Kg IW"]
[null,null,"·         Note to “ensure LPG bottle size is compatible”  IW"]

{"sheet":"TBD - ECBTrucks","index":9,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["eModel","eVDI","Voltage","Hyster","Yale"]
["J1.5XNT_SWB",3.9,48,"J1.5XNT SWB","ERP15VT SWB"]
["J1.6XN_LWB",4.5,48,"J1.6XN LWB","ERP16VF LWB"]
["J1.6XN_MWB",4.4000000000000004,48,"J1.6XN MWB","ERP16VF MWB"]
["J1.6XNT_LWB",4.2,48,"J1.6XNT LWB","ERP16VT LWB"]
["J1.6XNT_MWB",4.2,48,"J1.6XNT MWB","ERP16VT MWB"]
["J1.6XNT_SWB",4.2,48,"J1.6XNT SWB","ERP16VT SWB"]
["J1.8XN_LWB",5,48,"J1.8XN LWB","ERP18VF LWB"]
["J1.8XN_MWB",5,48,"J1.8XN MWB","ERP18VF MWB"]
["J1.8XNT_LWB",4.7,48,"J1.8XNT LWB","ERP18VT LWB"]
["J1.8XNT_MWB",4.7,48,"J1.8XNT MWB","ERP18VT MWB"]
["J2.0XN_LWB",5.5,48,"J2.0XN LWB","ERP20VF LWB"]
["J2.0XN_MWB",5.5,48,"J2.0XN MWB","ERP20VF MWB"]
["J2.0XNT_LWB",5.2,48,"J2.0XNT LWB","ERP20VT LWB"]
["J2.0XNT_MWB",5.5,48,"J2.0XNT MWB","ERP20VT MWB"]
["J2.2XN_Adv",6.68,80,"J2.2XN Advance","ERP22VL Value"]
["J2.2XN_Adv_Plus",7.51,80,"J2.2XN Advance+","ERP22VL Prod"]
["J2.5XN_717_Adv",7,80,"J2.5XN-717 Adv.","ERP25VL MWB Val"]
["J2.5XN_717_Adv_Plus",7.87,80,"J2.5XN-717 Adv.+","ERP25VL MWB Prod"]
["J2.5XN_861_Adv",7.89,80,"J2.5XN-861 Adv.","ERP25VL LWB Val"]
["J2.5XN_861_Adv_Plus",8.86,80,"J2.5XN-861 Adv.+","ERP25VL LWB Prod"]
["J3.0XN_Adv",8.6999999999999993,80,"J3.0XN Advance","ERP30VL LWB Val"]
["J3.0XN_Adv_Plus",9.6999999999999993,80,"J3.0XN Advance+","ERP30VL LWB Prod"]
["J3.5XN_Adv",10,80,"J3.5XN Advance","ERP35VL LWB Val"]
["J3.5XN_Adv_Plus",11.3,80,"J3.5XN Advance+","ERP35VL LWB Prod"]
["J4.0XN",12.5,80,"J4.0XN","ERP40VM"]
["J4.5XN",12.7,80,"J4.5XN","ERP45VM"]
["J5.0XN",12.9,80,"J5.0XN","ERP50VM"]
["J5.0XN6",13.1,80,"J5.0XN6","ERP50VM6"]
["J5.5XN6",13.5,80,"J5.5XN6","ERP55VM6"]

{"sheet":"Sheet4","index":10,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["Select","Select","VDI"]
["J1.5XNT_SWB 3-whl",48,3.9]
["J1.6XNT_SWB 3-whl",48,4.2]
["J1.6XNT_MWB 3-whl",48,4.2]
["J1.6XNT_LWB 3-whl",48,4.2]
["J1.6XN_MWB 4-whl",48,4.4000000000000004]
["J1.6XN_LWB 4-whl",48,4.5]
["J1.8XNT_MWB 3-whl",48,4.7]
["J1.8XNT_LWB 3-whl",48,4.7]
["J1.8XN_MWB 4-whl",48,5]
["J1.8XN_LWB 4-whl",48,5]
["J2.0XNT_MWB 3-whl",48,5.5]
["J2.0XNT_LWB 3-whl",48,5.2]
["J2.0XN_LWB 4-whl",48,5.5]
[]
["J2.2XN_Adv",80,6.68]
["J2.2XN_Adv_Plus",80,7.51]
["J2.5XN_717_Adv",80,7]
["J2.5XN_717_Adv_Plus",80,7.87]
["J2.5XN_861_Adv",80,7.89]
["J2.5XN_861_Adv_Plus",80,8.86]
["J3.0XN_Adv",80,8.6999999999999993]
["J3.0XN_Adv_Plus",80,9.6999999999999993]
["J3.5XN_Adv",80,10]
["J3.5XN_Adv_Plus",80,11.3]
["J4.0XN",80,12.5]
["J4.5XN",80,12.7]
["J5.0XN",80,12.9]
["J5.0XN6",80,13.1]
["J5.5XN6",80,13.5]

{"sheet":"Sheet1","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet2","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}