{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Input Demand","Input Cost","Constraints","Solver","Dashboard","Cost Savings Opportunity","Triangle Analysis"],"not_rendered":{"charts":13,"external_links":1,"defined_names":118},"read":"whole","date_system":"1900"}

{"sheet":"Input Demand","index":0,"n_rows":11,"n_cols":5,"rows_kept":11}
["Demand Charateristics "]
["Parameter","Input Data (full time period)","Input Data (single day)","Input to Model (single day, correction)","Unit "]
["No of days",22,1,1]
["Total Distance ",{"$f":"ROUND((D9/100)*B5,0)*Constraints!B26+ROUND((D10/100)*B5,0)*Constraints!C26+ROUND((D11/100)*B5,0)*Constraints!D26","v":{"v":17523,"d":"17523.0"}},{"$f":"B4/B3","v":796.5},{"$f":"Constraints!B28*Constraints!B26+Constraints!C28*Constraints!C26+Constraints!D28*Constraints!D26","v":{"v":807,"d":"807.0"}},"km "]
["No of Missions",847,{"$f":"B5/B3","v":{"v":38.5,"d":"39"}},{"$f":"ROUND(D9/100*C5,0)+ROUND(D10/100*C5,0)+ROUND(D11/100*C5,0)","v":38}]
["No of Passengers",900,null,{"$f":"ROUNDUP(B6/B3,0)","v":41}]
["Concurrency ",34,null,{"$f":"B7","v":34},"% "]
["Min number of vehicles",null,null,0]
["Short Trips",null,null,50,"% "]
["Middle Trips",null,null,35,"% "]
["Long Trips",null,null,{"$f":"100-D9-D10","v":15},"% "]

{"sheet":"Input Cost","index":1,"n_rows":25,"n_cols":9,"rows_kept":25}
["Fixed Cost per Vehicle "]
[]
["Currency ","Euro"]
[]
["Vehicle Type","Value","Unit","Value","Unit"]
[{"$f":"A21","v":"Self-Drive"},null,null,{"$f":"SUM(D11:D15)-D13","v":{"v":11.50834416666666,"d":"11.51"}},{"$f":"CONCATENATE($B$3,\"/day\")","v":"Euro/day"}]
[{"$f":"A22","v":"Core-Drive"},null,null,{"$f":"SUM(D11:D15)","v":{"v":59.02834416666666,"d":"59.03"}},{"$f":"CONCATENATE($B$3,\"/day\")","v":"Euro/day"}]
[{"$f":"A23","v":"Outsourced (external driver)"},null,null,{"v":40,"d":"40.00"},"Euro/day"]
[{"$f":"A24","v":"Vehicle rental (own driver)"},null,null,{"v":20,"d":"20.00"},"Euro/day"]
[]
["Asset",{"v":1998.1666666666667,"d":"1998.17"},{"$f":"CONCATENATE($B$3,\"/year\")","v":"Euro/year"},{"$f":"B11/250","v":{"v":7.992666666666667,"d":"7.99"}},{"$f":"CONCATENATE($B$3,\"/day\")","v":"Euro/day"}]
["Technology",{"v":135.739375,"d":"135.74"},{"$f":"CONCATENATE($B$3,\"/year\")","v":"Euro/year"},{"$f":"B12/250","v":{"v":0.5429575,"d":"0.54"}},{"$f":"CONCATENATE($B$3,\"/day\")","v":"Euro/day"}]
["Labour (core drive)",{"v":11880,"d":"11880.00"},"Euro/year",{"$f":"B13/250","v":47.52},"Euro/day"]
["Insurance",{"v":680,"d":"680.00"},"Euro/year",{"$f":"B14/250","v":2.72},"Euro/day"]
["Other",63.18,"Euro/year",{"$f":"B15/250","v":{"v":0.25272,"d":"0.25"}},"Euro/day"]
[]
[]
[]
["Variable Costs per Vehicle"]
["Transporation Mode","Value","Unit "]
["Self-Drive",0.12,{"$f":"CONCATENATE($B$3,\"/km\")","v":"Euro/km"}]
["Core-Drive",0.12,{"$f":"CONCATENATE($B$3,\"/km\")","v":"Euro/km"}]
["Outsourced (external driver)",0,"Euro/km"]
["Vehicle rental (own driver)",0.05,"Euro/km"]
["Taxi ",0.6,"Euro/km",1.5,{"$f":"CONCATENATE($B$3,\" for Call-out and first\")","v":"Euro for Call-out and first"},1.5,"km free and ",15,"% off"]

{"sheet":"Constraints","index":2,"n_rows":28,"n_cols":9,"rows_kept":28,"merged":[[15,1,15,3]]}
["Max. Utilization per Vehicle per day "]
[null,{"$f":"'Input Cost'!A21","v":"Self-Drive"},{"$f":"'Input Cost'!A22","v":"Core-Drive"},{"$f":"'Input Cost'!A23","v":"Outsourced (external driver)"},{"$f":"'Input Cost'!A24","v":"Vehicle rental (own driver)"},"Unit ",{"$f":"'Input Cost'!A25","v":"Taxi "}]
["Distance travelled ",120,120,120,120,"km/day","-","per trip "]
["Max. possible missions",5,5,5,5,"missions per day","-","per trip ","Missions per vehicle per day not part of the optimization (just for the plots)"]
["No of Passengers per trip",4,3,3,3,"per trip",3,"per trip "]
["Effective time (time budget)",8,8,8,8,"hours per day"]
[]
[]
[]
[]
["Trip duration","short trip ","middle trip","long trip "]
[{"$f":"'Input Cost'!A21","v":"Self-Drive"},3,4,8]
[{"$f":"'Input Cost'!A22","v":"Core-Drive"},1.5,2,8]
[{"$f":"'Input Cost'!A23","v":"Outsourced (external driver)"},1.5,2,8]
[{"$f":"'Input Cost'!A24","v":"Vehicle rental (own driver)"},1.5,2,8]
[{"$f":"'Input Cost'!A25","v":"Taxi "},"not relevant to the model"]
[]
["Distance factor","short trip ","middle trip","long trip "]
[{"$f":"'Input Cost'!A21","v":"Self-Drive"},2,2,2]
[{"$f":"'Input Cost'!A22","v":"Core-Drive"},4,3,2]
[{"$f":"'Input Cost'!A23","v":"Outsourced (external driver)"},4,3,2]
[{"$f":"'Input Cost'!A24","v":"Vehicle rental (own driver)"},4,3,2]
[{"$f":"'Input Cost'!A25","v":"Taxi "},2,2,2]
[]
["Trips","short ","middle ","long"]
["Avg. distance single leg [km]",4,17,85]
["Bounds [km]","[0-10]","[10-40]","[40…]","only additional information (not for the model)"]
["No. missions ",{"$f":"ROUND('Input Demand'!D9/100*'Input Demand'!D5,0)","v":19},{"$f":"ROUND('Input Demand'!D10/100*'Input Demand'!D5,0)","v":13},{"$f":"ROUND('Input Demand'!D11/100*'Input Demand'!D5,0)","v":6}]

{"sheet":"Solver","index":3,"n_rows":43,"n_cols":8,"rows_kept":43,"merged":[[35,4,38,4],[39,4,42,4]]}
[]
[null,"Excel Solver Sheet"]
[]
["Total Cost (per day)",{"$f":"B5+B10","v":{"v":404.69178583333326,"d":"404.69"}},{"$f":"'[1]Input Cost'!$B$3","v":"Dollar"}]
["Fix Costs (per day)",{"$f":"SUM(B6:B9)","v":{"v":226.59178583333326,"d":"226.59"}},{"$f":"'[1]Input Cost'!$B$3","v":"Dollar"}]
[{"$f":"'Input Cost'!A21","v":"Self-Drive"},{"$f":"B18*'Input Cost'!D6","v":{"v":126.59178583333326,"d":"126.59"}},{"$f":"'[1]Input Cost'!$B$3","v":"Dollar"}]
[{"$f":"'Input Cost'!A22","v":"Core-Drive"},{"$f":"B19*'Input Cost'!D7","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Input Cost'!$B$3","v":"Dollar"}]
[{"$f":"'Input Cost'!A23","v":"Outsourced (external driver)"},{"$f":"B20*'Input Cost'!D8","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Input Cost'!$B$3","v":"Dollar"}]
[{"$f":"'Input Cost'!A24","v":"Vehicle rental (own driver)"},{"$f":"B21*'Input Cost'!D9","v":{"v":100,"d":"100.00"}},{"$f":"'[1]Input Cost'!$B$3","v":"Dollar"}]
["Variable Costs (per day)",{"$f":"SUM(B11:B15)","v":{"v":178.1,"d":"178.10"}},{"$f":"'[1]Input Cost'!$B$3","v":"Dollar"}]
[{"$f":"'Input Cost'!A21","v":"Self-Drive"},{"$f":"E24*'Input Cost'!B21","v":143.76},{"$f":"'[1]Input Cost'!$B$3","v":"Dollar"}]
[{"$f":"'Input Cost'!A22","v":"Core-Drive"},{"$f":"E25*'Input Cost'!B22","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Input Cost'!$B$3","v":"Dollar"}]
[{"$f":"'Input Cost'!A23","v":"Outsourced (external driver)"},{"$f":"E26*'Input Cost'!B23","v":{"v":0,"d":"0.00"}},{"$f":"'[1]Input Cost'!$B$3","v":"Dollar"}]
[{"$f":"'Input Cost'!A24","v":"Vehicle rental (own driver)"},{"$f":"E27*'Input Cost'!B24","v":29.75},{"$f":"'[1]Input Cost'!$B$3","v":"Dollar"}]
[{"$f":"'Input Cost'!A25","v":"Taxi "},{"$f":"((E28-'Input Cost'!F25*SUM(B28:D28))*'Input Cost'!B25+SUM(B28:D28)*'Input Cost'!D25)*(1-'Input Cost'!H25/100)","v":4.59},{"$f":"'[1]Input Cost'!$B$3","v":"Dollar"}]
[]
["Fleet Composition "]
[{"$f":"'Input Cost'!A21","v":"Self-Drive"},11,"vehicles "]
[{"$f":"'Input Cost'!A22","v":"Core-Drive"},0,"vehicles "]
[{"$f":"'Input Cost'!A23","v":"Outsourced (external driver)"},0,"vehicles "]
[{"$f":"'Input Cost'!A24","v":"Vehicle rental (own driver)"},5,"vehicles "]
["Taxi Trips ",{"$f":"SUM(B28:D28)","v":1},"trips"]
["Operational Mix (per day)","short missions","middle missions","long missions","total km ","no_missions","no_vehicles","max. "]
[{"$f":"'Input Cost'!A21","v":"Self-Drive"},1,10,5,{"$f":"SUMPRODUCT(B24:D24,DistanceFactorSelfDrive,DistancesTripTypes)","v":{"v":1198,"d":"1198.00"}},{"$f":"SUM(B24:D24)","v":16},{"$f":"B18","v":11},{"$f":"MAX(F24:G24)","v":16}]
[{"$f":"'Input Cost'!A22","v":"Core-Drive"},0,0,0,{"$f":"SUMPRODUCT(B25:D25,DistanceFactorCoreDrive,DistancesTripTypes)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B25:D25)","v":0},{"$f":"B19","v":0},{"$f":"MAX(F25:G25)","v":0}]
[{"$f":"'Input Cost'!A23","v":"Outsourced (external driver)"},0,0,0,{"$f":"SUMPRODUCT(B26:D26,DistanceFactorOutsourced,DistancesTripTypes)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B26:D26)","v":0},{"$f":"B20","v":0},{"$f":"MAX(F26:G26)","v":0}]
[{"$f":"'Input Cost'!A24","v":"Vehicle rental (own driver)"},17,3,1,{"$f":"SUMPRODUCT(B27:D27,DistanceFactorType5,DistancesTripTypes)","v":{"v":595,"d":"595.00"}},21,{"$f":"B21","v":5},{"$f":"MAX(F27:G27)","v":21}]
[{"$f":"'Input Cost'!A25","v":"Taxi "},1,0,0,{"$f":"SUMPRODUCT(B28:D28,DistanceFactorTaxi,DistancesTripTypes)","v":{"v":8,"d":"8.00"}}]
[null,null,"total no. of missions:",{"$f":"SUM(B24:D28)","v":38}]
["Constraints ","Max. possible \nwith current solution ",null,"required "]
["Missions covered short",{"$f":"SUM(B24:B28)","v":19},"=",{"$f":"Constraints!B28","v":19}]
["Missions covered middle",{"$f":"SUM(C24:C28)","v":13},"=",{"$f":"Constraints!C28","v":13}]
["Missions covered long",{"$f":"SUM(D24:D28)","v":6},"=",{"$f":"Constraints!D28","v":6}]
["No concurrent trips ",{"$f":"SUM(B18:B21)+SUM(B28:D28)","v":17},">=",{"$f":"ROUNDUP('Input Demand'!D7/100*'Input Demand'!D5,0)","v":13}]
["Min number of vehicles (safety constraint)",{"$f":"SUM(B18:B19)","v":11},">=",{"$f":"'Input Demand'!D8","v":0}]
[{"$f":"'Input Cost'!A21","v":"Self-Drive"},{"$f":"B18*Constraints!B3","v":{"v":1320,"d":"1320.00"}},">=",{"$f":"E24","v":{"v":1198,"d":"1198.00"}},"Distance Constraints"]
[{"$f":"'Input Cost'!A22","v":"Core-Drive"},{"$f":"B19*Constraints!C3","v":{"v":0,"d":"0.00"}},">=",{"$f":"E25","v":{"v":0,"d":"0.00"}}]
[{"$f":"'Input Cost'!A23","v":"Outsourced (external driver)"},{"$f":"B20*Constraints!D3","v":{"v":0,"d":"0.00"}},">=",{"$f":"E26","v":{"v":0,"d":"0.00"}}]
[{"$f":"'Input Cost'!A24","v":"Vehicle rental (own driver)"},{"$f":"B21*Constraints!E3","v":{"v":600,"d":"600.00"}},">=",{"$f":"E27","v":{"v":595,"d":"595.00"}}]
[{"$f":"'Input Cost'!A21","v":"Self-Drive"},{"$f":"B18*Constraints!B6","v":{"v":88,"d":"88.00"}},">=",{"$f":"SUMPRODUCT(B24:D24,Constraints!B12:D12)","v":{"v":83,"d":"83.00"}},"Time Constraints"]
[{"$f":"'Input Cost'!A22","v":"Core-Drive"},{"$f":"B19*Constraints!C6","v":{"v":0,"d":"0.00"}},">=",{"$f":"SUMPRODUCT(B25:D25,Constraints!B13:D13)","v":{"v":0,"d":"0.00"}}]
[{"$f":"'Input Cost'!A23","v":"Outsourced (external driver)"},{"$f":"B20*Constraints!D6","v":{"v":0,"d":"0.00"}},">=",{"$f":"SUMPRODUCT(B26:D26,Constraints!B14:D14)","v":{"v":0,"d":"0.00"}}]
[{"$f":"'Input Cost'!A24","v":"Vehicle rental (own driver)"},{"$f":"B21*Constraints!E6","v":{"v":40,"d":"40.00"}},">=",{"$f":"SUMPRODUCT(B27:D27,Constraints!B15:D15)","v":{"v":39.5,"d":"39.50"}}]

{"sheet":"Dashboard","index":4,"n_rows":30,"n_cols":17,"rows_kept":30,"merged":[[4,4,4,6],[4,12,4,14],[20,4,20,6]]}
[]
[null,"Summary: Fleet Size and Composition"]
[]
[]
[null,null,"Cost per km single trip",null,"Cost per km ",{"$nulls":5},"Cost per km single trip",null,"Cost per km "]
[null,null,"Utilization ","km",{"$f":"'Input Cost'!A21","v":"Self-Drive"},{"$f":"'Input Cost'!A22","v":"Core-Drive"},{"$f":"'Input Cost'!A23","v":"Outsourced (external driver)"},{"$f":"'Input Cost'!A24","v":"Vehicle rental (own driver)"},{"$f":"'Input Cost'!A25","v":"Taxi "},null,"Utilization ","km",{"$f":"E6","v":"Self-Drive"},{"$f":"F6","v":"Core-Drive"},{"$f":"G6","v":"Outsourced (external driver)"},{"$f":"H6","v":"Vehicle rental (own driver)"},{"$f":"I6","v":"Taxi "}]
[null,null,0.01,{"$f":"Constraints!$C$3*C7","v":1.2},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$21*D7)/D7","v":{"v":9.710286805555551,"d":"9.71"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$22*D7)/D7","v":{"v":49.310286805555556,"d":"49.31"}},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$23*D7)/D7","v":{"v":33.333333333333336,"d":"33.33"}},{"$f":"('Input Cost'!$D$9+'Input Cost'!$B$24*D7)/D7","v":{"v":16.716666666666665,"d":"16.72"}},{"$f":"IF(D7<'Input Cost'!F25,'Input Cost'!D25,((('Input Cost'!$B$25*(D7-'Input Cost'!F25)+'Input Cost'!$D$25)/D7)))*(1-'Input Cost'!$H$25/100)","v":{"v":1.275,"d":"1.28"}},null,0.01,{"$f":"Constraints!$C$3*K7","v":1.2},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$21*L7)/L7","v":{"v":2.03805736111111,"d":"2.04"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$22*L7)/L7","v":{"v":9.958057361111111,"d":"9.96"}},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$23*L7)/L7","v":{"v":6.666666666666667,"d":"6.67"}},{"$f":"('Input Cost'!$D$9/Constraints!$E$4+'Input Cost'!$B$24*L7)/L7","v":{"v":3.3833333333333333,"d":"3.38"}},{"$f":"IF(L7<'Input Cost'!F25,'Input Cost'!D25,((('Input Cost'!$B$25*(L7-'Input Cost'!F25)+'Input Cost'!$D$25)/L7)))*(1-'Input Cost'!$H$25/100)","v":{"v":1.275,"d":"1.28"}}]
[null,null,0.02,{"$f":"Constraints!$C$3*C8","v":2.4},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$21*D8)/D8","v":{"v":4.915143402777775,"d":"4.92"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$22*D8)/D8","v":{"v":24.715143402777777,"d":"24.72"}},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$23*D8)/D8","v":{"v":16.666666666666668,"d":"16.67"}},{"$f":"('Input Cost'!$D$9+'Input Cost'!$B$24*D8)/D8","v":{"v":8.383333333333335,"d":"8.38"}},{"$f":"IF(D8<'Input Cost'!F26,'Input Cost'!D26,((('Input Cost'!$B$25*(D8-'Input Cost'!F26)+'Input Cost'!$D$25)/D8)))*(1-'Input Cost'!$H$25/100)","v":{"v":1.04125,"d":"1.04"}},null,0.02,{"$f":"Constraints!$C$3*K8","v":2.4},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$21*L8)/L8","v":{"v":1.079028680555555,"d":"1.08"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$22*L8)/L8","v":{"v":5.039028680555555,"d":"5.04"}},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$23*L8)/L8","v":{"v":3.3333333333333335,"d":"3.33"}},{"$f":"('Input Cost'!$D$9/Constraints!$E$4+'Input Cost'!$B$24*L8)/L8","v":{"v":1.7166666666666668,"d":"1.72"}},{"$f":"IF(L8<'Input Cost'!F26,'Input Cost'!D26,((('Input Cost'!$B$25*(L8-'Input Cost'!F26)+'Input Cost'!$D$25)/L8)))*(1-'Input Cost'!$H$25/100)","v":{"v":1.04125,"d":"1.04"}}]
[null,null,0.05,{"$f":"Constraints!$C$3*C9","v":6},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$21*D9)/D9","v":{"v":2.03805736111111,"d":"2.04"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$22*D9)/D9","v":{"v":9.958057361111111,"d":"9.96"}},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$23*D9)/D9","v":{"v":6.666666666666667,"d":"6.67"}},{"$f":"('Input Cost'!$D$9+'Input Cost'!$B$24*D9)/D9","v":{"v":3.3833333333333333,"d":"3.38"}},{"$f":"IF(D9<'Input Cost'!F27,'Input Cost'!D27,((('Input Cost'!$B$25*(D9-'Input Cost'!F27)+'Input Cost'!$D$25)/D9)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.7224999999999999,"d":"0.72"}},null,0.05,{"$f":"Constraints!$C$3*K9","v":6},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$21*L9)/L9","v":{"v":0.503611472222222,"d":"0.50"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$22*L9)/L9","v":{"v":2.087611472222222,"d":"2.09"}},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$23*L9)/L9","v":{"v":1.3333333333333333,"d":"1.33"}},{"$f":"('Input Cost'!$D$9/Constraints!$E$4+'Input Cost'!$B$24*L9)/L9","v":{"v":0.7166666666666667,"d":"0.72"}},{"$f":"IF(L9<'Input Cost'!F27,'Input Cost'!D27,((('Input Cost'!$B$25*(L9-'Input Cost'!F27)+'Input Cost'!$D$25)/L9)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.7224999999999999,"d":"0.72"}}]
[null,null,0.1,{"$f":"Constraints!$C$3*C10","v":12},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$21*D10)/D10","v":{"v":1.079028680555555,"d":"1.08"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$22*D10)/D10","v":{"v":5.039028680555555,"d":"5.04"}},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$23*D10)/D10","v":{"v":3.3333333333333335,"d":"3.33"}},{"$f":"('Input Cost'!$D$9+'Input Cost'!$B$24*D10)/D10","v":{"v":1.7166666666666668,"d":"1.72"}},{"$f":"IF(D10<'Input Cost'!F28,'Input Cost'!D28,((('Input Cost'!$B$25*(D10-'Input Cost'!F28)+'Input Cost'!$D$25)/D10)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.61625,"d":"0.62"}},null,0.1,{"$f":"Constraints!$C$3*K10","v":12},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$21*L10)/L10","v":{"v":0.311805736111111,"d":"0.31"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$22*L10)/L10","v":{"v":1.1038057361111109,"d":"1.10"}},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$23*L10)/L10","v":{"v":0.6666666666666666,"d":"0.67"}},{"$f":"('Input Cost'!$D$9/Constraints!$E$4+'Input Cost'!$B$24*L10)/L10","v":{"v":0.3833333333333333,"d":"0.38"}},{"$f":"IF(L10<'Input Cost'!F28,'Input Cost'!D28,((('Input Cost'!$B$25*(L10-'Input Cost'!F28)+'Input Cost'!$D$25)/L10)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.61625,"d":"0.62"}}]
["Cost Analysis ",null,0.2,{"$f":"Constraints!$C$3*C11","v":24},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$21*D11)/D11","v":{"v":0.5995143402777775,"d":"0.60"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$22*D11)/D11","v":{"v":2.5795143402777776,"d":"2.58"}},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$23*D11)/D11","v":{"v":1.6666666666666667,"d":"1.67"}},{"$f":"('Input Cost'!$D$9+'Input Cost'!$B$24*D11)/D11","v":{"v":0.8833333333333333,"d":"0.88"}},{"$f":"IF(D11<'Input Cost'!F29,'Input Cost'!D29,((('Input Cost'!$B$25*(D11-'Input Cost'!F29)+'Input Cost'!$D$25)/D11)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.563125,"d":"0.56"}},null,0.2,{"$f":"Constraints!$C$3*K11","v":24},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$21*L11)/L11","v":{"v":0.21590286805555547,"d":"0.22"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$22*L11)/L11","v":{"v":0.6119028680555555,"d":"0.61"}},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$23*L11)/L11","v":{"v":0.3333333333333333,"d":"0.33"}},{"$f":"('Input Cost'!$D$9/Constraints!$E$4+'Input Cost'!$B$24*L11)/L11","v":{"v":0.21666666666666667,"d":"0.22"}},{"$f":"IF(L11<'Input Cost'!F29,'Input Cost'!D29,((('Input Cost'!$B$25*(L11-'Input Cost'!F29)+'Input Cost'!$D$25)/L11)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.563125,"d":"0.56"}}]
[null,null,0.3,{"$f":"Constraints!$C$3*C12","v":36},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$21*D12)/D12","v":{"v":0.4396762268518517,"d":"0.44"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$22*D12)/D12","v":{"v":1.7596762268518518,"d":"1.76"}},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$23*D12)/D12","v":{"v":1.1111111111111112,"d":"1.11"}},{"$f":"('Input Cost'!$D$9+'Input Cost'!$B$24*D12)/D12","v":{"v":0.6055555555555556,"d":"0.61"}},{"$f":"IF(D12<'Input Cost'!F30,'Input Cost'!D30,((('Input Cost'!$B$25*(D12-'Input Cost'!F30)+'Input Cost'!$D$25)/D12)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.5454166666666665,"d":"0.55"}},null,0.3,{"$f":"Constraints!$C$3*K12","v":36},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$21*L12)/L12","v":{"v":0.18393524537037034,"d":"0.18"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$22*L12)/L12","v":{"v":0.4479352453703703,"d":"0.45"}},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$23*L12)/L12","v":{"v":0.2222222222222222,"d":"0.22"}},{"$f":"('Input Cost'!$D$9/Constraints!$E$4+'Input Cost'!$B$24*L12)/L12","v":{"v":0.1611111111111111,"d":"0.16"}},{"$f":"IF(L12<'Input Cost'!F30,'Input Cost'!D30,((('Input Cost'!$B$25*(L12-'Input Cost'!F30)+'Input Cost'!$D$25)/L12)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.5454166666666665,"d":"0.55"}}]
[null,null,0.4,{"$f":"Constraints!$C$3*C13","v":48},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$21*D13)/D13","v":{"v":0.3597571701388887,"d":"0.36"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$22*D13)/D13","v":{"v":1.3497571701388889,"d":"1.35"}},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$23*D13)/D13","v":{"v":0.8333333333333334,"d":"0.83"}},{"$f":"('Input Cost'!$D$9+'Input Cost'!$B$24*D13)/D13","v":{"v":0.4666666666666666,"d":"0.47"}},{"$f":"IF(D13<'Input Cost'!F31,'Input Cost'!D31,((('Input Cost'!$B$25*(D13-'Input Cost'!F31)+'Input Cost'!$D$25)/D13)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.5365624999999999,"d":"0.54"}},null,0.4,{"$f":"Constraints!$C$3*K13","v":48},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$21*L13)/L13","v":{"v":0.16795143402777776,"d":"0.17"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$22*L13)/L13","v":{"v":0.3659514340277778,"d":"0.37"}},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$23*L13)/L13","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"('Input Cost'!$D$9/Constraints!$E$4+'Input Cost'!$B$24*L13)/L13","v":{"v":0.13333333333333333,"d":"0.13"}},{"$f":"IF(L13<'Input Cost'!F31,'Input Cost'!D31,((('Input Cost'!$B$25*(L13-'Input Cost'!F31)+'Input Cost'!$D$25)/L13)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.5365624999999999,"d":"0.54"}}]
[null,null,0.5,{"$f":"Constraints!$C$3*C14","v":60},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$21*D14)/D14","v":{"v":0.311805736111111,"d":"0.31"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$22*D14)/D14","v":{"v":1.1038057361111109,"d":"1.10"}},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$23*D14)/D14","v":{"v":0.6666666666666666,"d":"0.67"}},{"$f":"('Input Cost'!$D$9+'Input Cost'!$B$24*D14)/D14","v":{"v":0.38333333333333336,"d":"0.38"}},{"$f":"IF(D14<'Input Cost'!F32,'Input Cost'!D32,((('Input Cost'!$B$25*(D14-'Input Cost'!F32)+'Input Cost'!$D$25)/D14)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.53125,"d":"0.53"}},null,0.5,{"$f":"Constraints!$C$3*K14","v":60},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$21*L14)/L14","v":{"v":0.1583611472222222,"d":"0.16"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$22*L14)/L14","v":{"v":0.3167611472222222,"d":"0.32"}},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$23*L14)/L14","v":{"v":0.13333333333333333,"d":"0.13"}},{"$f":"('Input Cost'!$D$9/Constraints!$E$4+'Input Cost'!$B$24*L14)/L14","v":{"v":0.11666666666666667,"d":"0.12"}},{"$f":"IF(L14<'Input Cost'!F32,'Input Cost'!D32,((('Input Cost'!$B$25*(L14-'Input Cost'!F32)+'Input Cost'!$D$25)/L14)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.53125,"d":"0.53"}}]
[null,null,0.6,{"$f":"Constraints!$C$3*C15","v":72},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$21*D15)/D15","v":{"v":0.27983811342592585,"d":"0.28"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$22*D15)/D15","v":{"v":0.9398381134259258,"d":"0.94"}},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$23*D15)/D15","v":{"v":0.5555555555555556,"d":"0.56"}},{"$f":"('Input Cost'!$D$9+'Input Cost'!$B$24*D15)/D15","v":{"v":0.3277777777777778,"d":"0.33"}},{"$f":"IF(D15<'Input Cost'!F33,'Input Cost'!D33,((('Input Cost'!$B$25*(D15-'Input Cost'!F33)+'Input Cost'!$D$25)/D15)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.5277083333333332,"d":"0.53"}},null,0.6,{"$f":"Constraints!$C$3*K15","v":72},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$21*L15)/L15","v":{"v":0.15196762268518518,"d":"0.15"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$22*L15)/L15","v":{"v":0.28396762268518516,"d":"0.28"}},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$23*L15)/L15","v":{"v":0.1111111111111111,"d":"0.11"}},{"$f":"('Input Cost'!$D$9/Constraints!$E$4+'Input Cost'!$B$24*L15)/L15","v":{"v":0.10555555555555556,"d":"0.11"}},{"$f":"IF(L15<'Input Cost'!F33,'Input Cost'!D33,((('Input Cost'!$B$25*(L15-'Input Cost'!F33)+'Input Cost'!$D$25)/L15)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.5277083333333332,"d":"0.53"}}]
[null,null,0.7,{"$f":"Constraints!$C$3*C16","v":84},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$21*D16)/D16","v":{"v":0.2570040972222221,"d":"0.26"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$22*D16)/D16","v":{"v":0.822718382936508,"d":"0.82"}},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$23*D16)/D16","v":{"v":0.47619047619047616,"d":"0.48"}},{"$f":"('Input Cost'!$D$9+'Input Cost'!$B$24*D16)/D16","v":{"v":0.28809523809523807,"d":"0.29"}},{"$f":"IF(D16<'Input Cost'!F34,'Input Cost'!D34,((('Input Cost'!$B$25*(D16-'Input Cost'!F34)+'Input Cost'!$D$25)/D16)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.5251785714285714,"d":"0.53"}},null,0.7,{"$f":"Constraints!$C$3*K16","v":84},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$21*L16)/L16","v":{"v":0.14740081944444444,"d":"0.15"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$22*L16)/L16","v":{"v":0.2605436765873016,"d":"0.26"}},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$23*L16)/L16","v":{"v":0.09523809523809523,"d":"0.10"}},{"$f":"('Input Cost'!$D$9/Constraints!$E$4+'Input Cost'!$B$24*L16)/L16","v":{"v":0.0976190476190476,"d":"0.10"}},{"$f":"IF(L16<'Input Cost'!F34,'Input Cost'!D34,((('Input Cost'!$B$25*(L16-'Input Cost'!F34)+'Input Cost'!$D$25)/L16)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.5251785714285714,"d":"0.53"}}]
[null,null,0.8,{"$f":"Constraints!$C$3*C17","v":96},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$21*D17)/D17","v":{"v":0.23987858506944437,"d":"0.24"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$22*D17)/D17","v":{"v":0.7348785850694445,"d":"0.73"}},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$23*D17)/D17","v":{"v":0.4166666666666667,"d":"0.42"}},{"$f":"('Input Cost'!$D$9+'Input Cost'!$B$24*D17)/D17","v":{"v":0.25833333333333336,"d":"0.26"}},{"$f":"IF(D17<'Input Cost'!F35,'Input Cost'!D35,((('Input Cost'!$B$25*(D17-'Input Cost'!F35)+'Input Cost'!$D$25)/D17)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.5232812499999999,"d":"0.52"}},null,0.8,{"$f":"Constraints!$C$3*K17","v":96},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$21*L17)/L17","v":{"v":0.14397571701388887,"d":"0.14"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$22*L17)/L17","v":{"v":0.24297571701388887,"d":"0.24"}},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$23*L17)/L17","v":{"v":0.08333333333333333,"d":"0.08"}},{"$f":"('Input Cost'!$D$9/Constraints!$E$4+'Input Cost'!$B$24*L17)/L17","v":{"v":0.09166666666666667,"d":"0.09"}},{"$f":"IF(L17<'Input Cost'!F35,'Input Cost'!D35,((('Input Cost'!$B$25*(L17-'Input Cost'!F35)+'Input Cost'!$D$25)/L17)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.5232812499999999,"d":"0.52"}}]
[null,null,0.9,{"$f":"Constraints!$C$3*C18","v":108},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$21*D18)/D18","v":{"v":0.22655874228395056,"d":"0.23"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$22*D18)/D18","v":{"v":0.6665587422839506,"d":"0.67"}},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$23*D18)/D18","v":{"v":0.37037037037037035,"d":"0.37"}},{"$f":"('Input Cost'!$D$9+'Input Cost'!$B$24*D18)/D18","v":{"v":0.23518518518518516,"d":"0.24"}},{"$f":"IF(D18<'Input Cost'!F36,'Input Cost'!D36,((('Input Cost'!$B$25*(D18-'Input Cost'!F36)+'Input Cost'!$D$25)/D18)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.5218055555555555,"d":"0.52"}},null,0.9,{"$f":"Constraints!$C$3*K18","v":108},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$21*L18)/L18","v":{"v":0.1413117484567901,"d":"0.14"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$22*L18)/L18","v":{"v":0.2293117484567901,"d":"0.23"}},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$23*L18)/L18","v":{"v":0.07407407407407407,"d":"0.07"}},{"$f":"('Input Cost'!$D$9/Constraints!$E$4+'Input Cost'!$B$24*L18)/L18","v":{"v":0.08703703703703704,"d":"0.09"}},{"$f":"IF(L18<'Input Cost'!F36,'Input Cost'!D36,((('Input Cost'!$B$25*(L18-'Input Cost'!F36)+'Input Cost'!$D$25)/L18)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.5218055555555555,"d":"0.52"}}]
[null,null,1,{"$f":"Constraints!$C$3*C19","v":120},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$21*D19)/D19","v":{"v":0.2159028680555555,"d":"0.22"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$22*D19)/D19","v":{"v":0.6119028680555555,"d":"0.61"}},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$23*D19)/D19","v":{"v":0.3333333333333333,"d":"0.33"}},{"$f":"('Input Cost'!$D$9+'Input Cost'!$B$24*D19)/D19","v":{"v":0.21666666666666667,"d":"0.22"}},{"$f":"IF(D19<'Input Cost'!F37,'Input Cost'!D37,((('Input Cost'!$B$25*(D19-'Input Cost'!F37)+'Input Cost'!$D$25)/D19)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.520625,"d":"0.52"}},null,1,{"$f":"Constraints!$C$3*K19","v":120},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$21*L19)/L19","v":{"v":0.13918057361111108,"d":"0.14"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$22*L19)/L19","v":{"v":0.2183805736111111,"d":"0.22"}},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$23*L19)/L19","v":{"v":0.06666666666666667,"d":"0.07"}},{"$f":"('Input Cost'!$D$9/Constraints!$E$4+'Input Cost'!$B$24*L19)/L19","v":{"v":0.08333333333333333,"d":"0.08"}},{"$f":"IF(L19<'Input Cost'!F37,'Input Cost'!D37,((('Input Cost'!$B$25*(L19-'Input Cost'!F37)+'Input Cost'!$D$25)/L19)))*(1-'Input Cost'!$H$25/100)","v":{"v":0.520625,"d":"0.52"}}]
[]
[null,null,"Cost per Mission"]
[]
[]
[]
[null,"Transportation Mode","Fleet","short Missions","middle Missions ","long Missions","Missions","Distance"]
["Operational Mix ",{"$f":"'Input Cost'!A21","v":"Self-Drive"},{"$f":"Solver!B18","v":11},{"$f":"Solver!B24","v":1},{"$f":"Solver!C24","v":10},{"$f":"Solver!D24","v":5},{"$f":"SUM(D26:F26)","v":16},{"$f":"Solver!E24","v":{"v":1198,"d":"1198.00"}}]
[null,{"$f":"'Input Cost'!A22","v":"Core-Drive"},{"$f":"Solver!B19","v":0},{"$f":"Solver!B25","v":0},{"$f":"Solver!C25","v":0},{"$f":"Solver!D25","v":0},{"$f":"SUM(D27:F27)","v":0},{"$f":"Solver!E25","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"'Input Cost'!A23","v":"Outsourced (external driver)"},{"$f":"Solver!B20","v":0},{"$f":"Solver!B26","v":0},{"$f":"Solver!C26","v":0},{"$f":"Solver!D26","v":0},{"$f":"SUM(D28:F28)","v":0},{"$f":"Solver!E26","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"'Input Cost'!A24","v":"Vehicle rental (own driver)"},{"$f":"Solver!B21","v":5},{"$f":"Solver!B27","v":17},{"$f":"Solver!C27","v":3},{"$f":"Solver!D27","v":1},{"$f":"SUM(D29:F29)","v":21},{"$f":"Solver!E27","v":{"v":595,"d":"595.00"}}]
["Trips",{"$f":"'Input Cost'!A25&\" \"&A30","v":"Taxi  Trips"},{"$f":"SUM(D30:F30)","v":1},{"$f":"Solver!B28","v":1},{"$f":"Solver!C28","v":0},{"$f":"Solver!D28","v":0},{"$f":"SUM(D30:F30)","v":1},{"$f":"Solver!E28","v":{"v":8,"d":"8.00"}}]

{"sheet":"Cost Savings Opportunity","index":5,"n_rows":35,"n_cols":10,"rows_kept":35}
[]
["Time period for savings plots",250,"days"]
[]
["Time period ",25,"days"]
["Type","Status quo ",null,null,"Status quo (per day)","Status quo (per plot period)","Min. to meet demand (per day)","Min. to meet demand (per plot period)","Savings potential (per plot period)","Savings [%]"]
["Vehicles (Buy - Resale Value)",{"$f":"12869.3333333333","v":{"v":12869.3333333333,"d":"12869.33"}},{"$f":"CONCATENATE('Input Cost'!$B$3,\"/period\")","v":"Euro/period"},null,{"$f":"B6/$B$4","v":{"v":514.773333333332,"d":"514.77"}},{"$f":"E6*'Cost Savings Opportunity'!$B$2","v":{"v":128693.333333333,"d":"128693.33"}},{"$f":"$G$18*'Input Cost'!D11","v":{"v":87.91933333333333,"d":"87.92"}},{"$f":"G6*'Cost Savings Opportunity'!B2","v":{"v":21979.833333333332,"d":"21979.83"}},{"$f":"F6-H6","v":{"v":106713.49999999967,"d":"106713.50"}},{"$f":"IF(F6<>0,(F6-H6)/F6*100,0)","v":{"v":82.9207677165354,"d":"82.92"}}]
["Technology",{"v":4549.136666666666,"d":"4549.14"},{"$f":"CONCATENATE('Input Cost'!$B$3,\"/period\")","v":"Euro/period"},null,{"$f":"B7/$B$4","v":{"v":181.96546666666666,"d":"181.97"}},{"$f":"E7*'Cost Savings Opportunity'!$B$2","v":{"v":45491.36666666666,"d":"45491.37"}},{"$f":"$G$18*'Input Cost'!D12","v":{"v":5.9725325,"d":"5.97"}},{"$f":"G7*'Cost Savings Opportunity'!B2","v":{"v":1493.1331249999998,"d":"1493.13"}},{"$f":"F7-H7","v":{"v":43998.23354166666,"d":"43998.23"}},{"$f":"IF(F7<>0,(F7-H7)/F7*100,0)","v":{"v":96.71776595339335,"d":"96.72"}}]
["Salary (core drive)",{"v":15695,"d":"15695.00"},{"$f":"CONCATENATE('Input Cost'!$B$3,\"/period\")","v":"Euro/period"},null,{"$f":"B8/$B$4","v":{"v":627.8,"d":"627.80"}},{"$f":"E8*'Cost Savings Opportunity'!$B$2","v":{"v":156950,"d":"156950.00"}},{"$f":"$G$17*'Input Cost'!D13","v":{"v":0,"d":"0.00"}},{"$f":"G8*'Cost Savings Opportunity'!$B$2","v":{"v":0,"d":"0.00"}},{"$f":"F8-H8","v":{"v":156950,"d":"156950.00"}},{"$f":"IF(F8<>0,(F8-H8)/F8*100,0)","v":{"v":100,"d":"100.00"}}]
["Insurance",{"v":3358.6775000000002,"d":"3358.68"},{"$f":"CONCATENATE('Input Cost'!$B$3,\"/period\")","v":"Euro/period"},null,{"$f":"B9/$B$4","v":{"v":134.3471,"d":"134.35"}},{"$f":"E9*'Cost Savings Opportunity'!$B$2","v":{"v":33586.775,"d":"33586.78"}},{"$f":"$G$18*'Input Cost'!D14","v":29.92},{"$f":"G9*'Cost Savings Opportunity'!$B$2","v":{"v":7480,"d":"7480.00"}},{"$f":"F9-H9","v":{"v":26106.775,"d":"26106.78"}},{"$f":"IF(F9<>0,(F9-H9)/F9*100,0)","v":{"v":77.72932947566416,"d":"77.73"}}]
["Other",{"v":331.6925,"d":"331.69"},{"$f":"CONCATENATE('Input Cost'!$B$3,\"/period\")","v":"Euro/period"},null,{"$f":"B10/$B$4","v":{"v":13.2677,"d":"13.27"}},{"$f":"E10*'Cost Savings Opportunity'!$B$2","v":{"v":3316.9249999999997,"d":"3316.93"}},{"$f":"$G$18*'Input Cost'!D15","v":{"v":2.77992,"d":"2.78"}},{"$f":"G10*'Cost Savings Opportunity'!$B$2","v":694.98},{"$f":"F10-H10","v":{"v":2621.9449999999997,"d":"2621.95"}},{"v":79.04746112739961,"d":"79.05"}]
[{"$nulls":9},{"v":0,"d":"0.00"}]
["Cost for Outsourcing",{"v":0,"d":"0.00"},{"$f":"CONCATENATE('Input Cost'!$B$3,\"/period\")","v":"Euro/period"},null,{"$f":"B12/$B$4","v":{"v":0,"d":"0.00"}},{"$f":"E12*'Cost Savings Opportunity'!$B$2","v":{"v":0,"d":"0.00"}},{"$f":"Solver!B8+Solver!B13","v":{"v":0,"d":"0.00"}},{"$f":"G12*'Cost Savings Opportunity'!$B$2","v":{"v":0,"d":"0.00"}},{"$f":"F12-H12","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
["Cost for Type 5 ",{"v":0,"d":"0.00"},{"$f":"CONCATENATE('Input Cost'!$B$3,\"/period\")","v":"Euro/period"},null,{"$f":"B13/$B$4","v":{"v":0,"d":"0.00"}},{"$f":"E13*'Cost Savings Opportunity'!$B$2","v":{"v":0,"d":"0.00"}},{"$f":"Solver!B9+Solver!B14","v":129.75},{"$f":"G13*'Cost Savings Opportunity'!$B$2","v":{"v":32437.5,"d":"32437.50"}},{"$f":"F13-H13","v":{"v":-32437.5,"d":"-32437.50"}},{"v":0,"d":"0.00"}]
["Cost for Taxi Services",{"v":11108.147499999997,"d":"11108.15"},{"$f":"CONCATENATE('Input Cost'!$B$3,\"/period\")","v":"Euro/period"},null,{"$f":"B14/$B$4","v":{"v":444.3258999999999,"d":"444.33"}},{"$f":"E14*'Cost Savings Opportunity'!$B$2","v":{"v":111081.47499999996,"d":"111081.48"}},{"$f":"Solver!B15","v":4.59},{"$f":"G14*'Cost Savings Opportunity'!$B$2","v":{"v":1147.5,"d":"1147.50"}},{"$f":"F14-H14","v":{"v":109933.97499999996,"d":"109933.98"}},{"v":98.96697446626452,"d":"98.97"}]
["Cost for Fuel + M&R",{"$f":"1418.6825+1319.31","v":{"v":2737.9925,"d":"2737.99"}},{"$f":"CONCATENATE('Input Cost'!$B$3,\"/period\")","v":"Euro/period"},null,{"$f":"B15/$B$4","v":{"v":109.5197,"d":"109.52"}},{"$f":"E15*'Cost Savings Opportunity'!$B$2","v":{"v":27379.925,"d":"27379.93"}},{"$f":"Solver!B11+Solver!B12","v":143.76},{"$f":"G15*'Cost Savings Opportunity'!$B$2","v":{"v":35940,"d":"35940.00"}},{"$f":"F15-H15","v":{"v":-8560.075,"d":"-8560.08"}},{"v":-31.26405569043743,"d":"-31.26"}]
[{"$nulls":9},0]
["No drivers",20,null,null,{"$f":"B17","v":20},{"$f":"E17","v":20},{"$f":"Solver!B19","v":0},{"$f":"G17","v":0},{"$f":"F17-H17","v":20},100]
["No vehicles ",57,null,null,{"$f":"B18","v":57},{"$f":"E18","v":57},{"$f":"Solver!B19+Solver!B18","v":11},{"$f":"G18","v":11},{"$f":"F18-H18","v":46},80.7017543859649]
[]
[]
[]
[]
[]
[]
["Type",{"$f":"F5","v":"Status quo (per plot period)"},{"$f":"H5","v":"Min. to meet demand (per plot period)"}]
["Vehicles (Buy - Resale Value)",{"$f":"F6","v":{"v":128693.333333333,"d":"128693.33"}},{"$f":"H6","v":{"v":21979.833333333332,"d":"21979.83"}}]
["Technology",{"$f":"F7","v":{"v":45491.36666666666,"d":"45491.37"}},{"$f":"H7","v":{"v":1493.1331249999998,"d":"1493.13"}}]
["Salary (core drive)",{"v":156950,"d":"156950.00"},{"v":0,"d":"0.00"}]
["Insurance",{"v":33586.775,"d":"33586.78"},{"v":7480,"d":"7480.00"}]
["Other",{"v":3316.9249999999997,"d":"3316.93"},694.98]
[]
[{"$f":"'Input Cost'!A23","v":"Outsourced (external driver)"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$f":"'Input Cost'!A24","v":"Vehicle rental (own driver)"},{"v":0,"d":"0.00"},{"v":32437.5,"d":"32437.50"}]
[{"$f":"'Input Cost'!A25","v":"Taxi "},{"v":111081.47499999996,"d":"111081.48"},{"v":1147.5,"d":"1147.50"}]
["Fuel + M&R",{"v":27379.925,"d":"27379.93"},{"v":35940,"d":"35940.00"}]

{"sheet":"Triangle Analysis","index":6,"n_rows":12,"n_cols":13,"rows_kept":12,"merged":[[3,4,3,7]]}
[]
[null,null,"Triangle Analysis"]
[]
[null,null,"Distance","variable cost","Calculation of number of vehicles ",{"$nulls":3},"number of vehicles ","number of drivers","fix cost","total cost (per day)","total cost (per plot period)"]
[null,"Extremes",null,null,"hours ","distance","concurrency","min no. Vehicles"]
[{"v":1,"d":"100%"},{"$f":"'Input Cost'!A21","v":"Self-Drive"},{"$f":"SUMPRODUCT(Constraints!B28:D28,DistanceFactorSelfDrive,DistancesTripTypes)","v":{"v":1614,"d":"1614.00"}},{"$f":"C6*'Input Cost'!B21","v":193.68},{"$f":"ROUNDUP((SUMPRODUCT(Constraints!B28:D28,Constraints!B12:D12))/Constraints!B6,0)","v":20},{"$f":"ROUNDUP((C6/Constraints!B3),0)","v":14},{"$f":"Solver!$D$34","v":13},{"$f":"Solver!$D$35","v":0},{"$f":"MAX(E6:H6)","v":20},0,{"$f":"I6*'Input Cost'!D6","v":{"v":230.1668833333332,"d":"230.17"}},{"$f":"D6+K6","v":{"v":423.8468833333332,"d":"423.85"}},{"$f":"L6*'Cost Savings Opportunity'!$B$2","v":{"v":105961.7208333333,"d":"105961.72"}}]
[{"v":1,"d":"100%"},{"$f":"'Input Cost'!A22","v":"Core-Drive"},{"$f":"SUMPRODUCT(Constraints!B28:D28,DistanceFactorCoreDrive,DistancesTripTypes)","v":{"v":1987,"d":"1987.00"}},{"$f":"C7*'Input Cost'!B22","v":238.44},{"$f":"ROUNDUP((SUMPRODUCT(Constraints!B28:D28,Constraints!B13:D13))/Constraints!C6,0)","v":13},{"$f":"ROUNDUP((C7/Constraints!C3),0)","v":17},{"$f":"Solver!$D$34","v":13},{"$f":"Solver!$D$35","v":0},{"$f":"MAX(E7:H7)","v":17},{"$f":"I7","v":17},{"$f":"I7*'Input Cost'!D7","v":{"v":1003.4818508333333,"d":"1003.48"}},{"$f":"D7+K7","v":{"v":1241.9218508333333,"d":"1241.92"}},{"$f":"L7*'Cost Savings Opportunity'!$B$2","v":{"v":310480.46270833333,"d":"310480.46"}}]
[{"v":1,"d":"100%"},{"$f":"'Input Cost'!A23","v":"Outsourced (external driver)"},{"$f":"SUMPRODUCT(Constraints!B28:D28,DistanceFactorOutsourced,DistancesTripTypes)","v":{"v":1987,"d":"1987.00"}},{"$f":"C8*'Input Cost'!B23","v":0},{"$f":"ROUNDUP((SUMPRODUCT(Constraints!B28:D28,Constraints!B14:D14))/Constraints!D6,0)","v":13},{"$f":"ROUNDUP((C8/Constraints!D3),0)","v":17},{"$f":"Solver!$D$34","v":13},{"$f":"Solver!$D$35","v":0},{"$f":"MAX(E8:H8)","v":17},0,{"$f":"I8*'Input Cost'!D8","v":{"v":680,"d":"680.00"}},{"$f":"D8+K8","v":{"v":680,"d":"680.00"}},{"$f":"L8*'Cost Savings Opportunity'!$B$2","v":{"v":170000,"d":"170000.00"}}]
[{"v":1,"d":"100%"},{"$f":"'Input Cost'!A24","v":"Vehicle rental (own driver)"},{"$f":"SUMPRODUCT(Constraints!B28:D28,DistanceFactorType5,DistancesTripTypes)","v":{"v":1987,"d":"1987.00"}},{"$f":"C9*'Input Cost'!B24","v":99.35000000000001},{"$f":"ROUNDUP((SUMPRODUCT(Constraints!B28:D28,Constraints!B15:D15))/Constraints!E6,0)","v":13},{"$f":"ROUNDUP((C9/Constraints!E3),0)","v":17},{"$f":"Solver!$D$34","v":13},{"$f":"Solver!$D$35","v":0},{"$f":"MAX(E9:H9)","v":17},0,{"$f":"I9*'Input Cost'!D9","v":{"v":340,"d":"340.00"}},{"$f":"D9+K9","v":439.35},{"$f":"L9*'Cost Savings Opportunity'!$B$2","v":{"v":109837.5,"d":"109837.50"}}]
[{"v":1,"d":"100%"},{"$f":"'Input Cost'!A25","v":"Taxi "},{"$f":"SUMPRODUCT(Constraints!B28:D28,DistanceFactorTaxi,DistancesTripTypes)","v":{"v":1614,"d":"1614.00"}},{"$f":"((C10-'Input Cost'!F25*'Input Demand'!D5)*'Input Cost'!B25+'Input Cost'!D25*'Input Demand'!D5)*(1-'Input Cost'!H25/100)","v":842.5199999999999},"-","-","-","-","-","-",{"v":0,"d":"0.00"},{"$f":"D10+K10","v":{"v":842.5199999999999,"d":"842.52"}},{"$f":"L10*'Cost Savings Opportunity'!$B$2","v":{"v":210629.99999999997,"d":"210630.00"}}]
[null,"Status quo",{"$nulls":6},{"$f":"'Cost Savings Opportunity'!B18","v":57},{"$f":"'Cost Savings Opportunity'!B17","v":20},null,{"$f":"SUM('Cost Savings Opportunity'!B6:B15)/'Cost Savings Opportunity'!B4","v":{"v":2025.9991999999984,"d":"2026.00"}},{"$f":"L11*'Cost Savings Opportunity'!$B$2","v":{"v":506499.7999999996,"d":"506499.80"}}]
[null,"Optimal Solution",{"$f":"SUM(Solver!E24:E28)","v":{"v":1801,"d":"1801.00"}},{"$f":"Solver!B10","v":178.1},{"$nulls":4},{"$f":"Solver!B18+Solver!B19","v":11},{"$f":"Solver!B19","v":0},{"$f":"Solver!B5","v":{"v":226.59178583333326,"d":"226.59"}},{"$f":"D12+K12","v":{"v":404.69178583333326,"d":"404.69"}},{"$f":"L12*'Cost Savings Opportunity'!$B$2","v":{"v":101172.94645833332,"d":"101172.95"}}]