{"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,"defined_names":117},"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!B22+ROUND((D10/100)*B5,0)*Constraints!C22+ROUND((D11/100)*B5,0)*Constraints!D22","v":{"v":17523,"d":"17523.0"}},{"$f":"B4/B3","v":796.5},{"$f":"Constraints!B24*Constraints!B22+Constraints!C24*Constraints!C22+Constraints!D24*Constraints!D22","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":21,"n_cols":9,"rows_kept":21}
["Fixed Cost per Vehicle "]
[]
["Currency ","Euro"]
[]
["Vehicle Type","Value","Unit","Value","Unit"]
[{"$f":"A19","v":"Core-Drive"},null,null,{"$f":"SUM(D9:D13)","v":{"v":59.02834416666666,"d":"59.03"}},{"$f":"CONCATENATE($B$3,\"/day\")","v":"Euro/day"}]
[{"$f":"A20","v":"Outsourced"},null,null,{"v":40,"d":"40.00"},{"$f":"CONCATENATE($B$3,\"/day\")","v":"Euro/day"}]
[]
["Asset",{"v":1998.1666666666667,"d":"1998"},{"$f":"CONCATENATE($B$3,\"/year\")","v":"Euro/year"},{"$f":"B9/250","v":{"v":7.992666666666667,"d":"7.99"}},{"$f":"CONCATENATE($B$3,\"/day\")","v":"Euro/day"}]
["Technology",{"v":135.739375,"d":"136"},{"$f":"CONCATENATE($B$3,\"/year\")","v":"Euro/year"},{"$f":"B10/250","v":{"v":0.5429575,"d":"0.54"}},{"$f":"CONCATENATE($B$3,\"/day\")","v":"Euro/day"}]
["Labour (core drive)",11880,"Euro/year",{"$f":"B11/250","v":47.52},"Euro/day"]
["Insurance",680,"Euro/year",{"$f":"B12/250","v":2.72},"Euro/day"]
["Other",{"v":63.18,"d":"63"},"Euro/year",{"$f":"B13/250","v":{"v":0.25272,"d":"0.25"}},"Euro/day"]
[]
[]
[]
["Variable Costs per Vehicle"]
["Transporation Mode","Value","Unit "]
["Core-Drive",0.12,{"$f":"CONCATENATE($B$3,\"/km\")","v":"Euro/km"}]
["Outsourced",0,{"$f":"CONCATENATE($B$3,\"/km\")","v":"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":24,"n_cols":7,"rows_kept":24,"merged":[[13,1,13,3]]}
["Max. Utilization per Vehicle per day "]
[null,{"$f":"'Input Cost'!A19","v":"Core-Drive"},{"$f":"'Input Cost'!A20","v":"Outsourced"},"Unit ","Taxi "]
["Distance travelled ",120,120,"km/day","-","per trip "]
["Max. possible missions",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",3,3,"per trip",3,"per trip "]
["Effective time (time budget)",8,8,"hours per day"]
[]
[]
[]
[]
["Trip duration","short trip ","middle trip","long trip "]
["Core-Drive",1.5,2,8]
["Outsourced",1.5,2,8]
["Taxi ","not relevant to the model"]
[]
["Distance factor","short trip ","middle trip","long trip "]
["Core-Drive",4,3,2]
["Outsourced",4,3,2]
["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":31,"n_cols":10,"rows_kept":31,"merged":[[27,4,28,4],[29,4,30,4]]}
[]
[null,"Excel Solver Sheet"]
[]
["Total Cost (per day)",{"$f":"B5+B8","v":685.24},{"$f":"'Input Cost'!$B$3","v":"Euro"}]
["Fix Costs (per day)",{"$f":"SUM(B6:B7)","v":{"v":520,"d":"520.00"}},{"$f":"'Input Cost'!$B$3","v":"Euro"}]
[{"$f":"'Input Cost'!A19","v":"Core-Drive"},{"$f":"B14*'Input Cost'!D6","v":{"v":0,"d":"0.00"}},{"$f":"'Input Cost'!$B$3","v":"Euro"}]
[{"$f":"'Input Cost'!A20","v":"Outsourced"},{"$f":"B15*'Input Cost'!D7","v":{"v":520,"d":"520.00"}},{"$f":"'Input Cost'!$B$3","v":"Euro"}]
["Variable Costs (per day)",{"$f":"SUM(B9:B11)","v":165.24},{"$f":"'Input Cost'!$B$3","v":"Euro"}]
[{"$f":"'Input Cost'!A19","v":"Core-Drive"},{"$f":"E18*'Input Cost'!B19","v":{"v":0,"d":"0.00"}},{"$f":"'Input Cost'!$B$3","v":"Euro"}]
[{"$f":"'Input Cost'!A20","v":"Outsourced"},{"$f":"E19*'Input Cost'!B20","v":{"v":0,"d":"0.00"}},{"$f":"'Input Cost'!$B$3","v":"Euro"}]
[{"$f":"'Input Cost'!A21","v":"Taxi "},{"$f":"((E20-'Input Cost'!F21*SUM(B20:D20))*'Input Cost'!B21+SUM(B20:D20)*'Input Cost'!D21)*(1-'Input Cost'!H21/100)","v":165.24},{"$f":"'Input Cost'!$B$3","v":"Euro"}]
[]
["Fleet Composition "]
[{"$f":"'Input Cost'!A19","v":"Core-Drive"},0,"vehicles ",{"$nulls":6},"s"]
[{"$f":"'Input Cost'!A20","v":"Outsourced"},13,"vehicles "]
["Taxi Trips ",{"$f":"SUM(B20:D20)","v":18},"trips"]
["Operational Mix (per day)","short missions","middle missions","long missions","total km ","no_missions","no_vehicles","max. "]
[{"$f":"'Input Cost'!A19","v":"Core-Drive"},0,0,0,{"$f":"SUMPRODUCT(B18:D18,DistanceFactorCoreDrive,DistancesTripTypes)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B18:D18)","v":0},{"$f":"B14","v":0},{"$f":"MAX(F18:G18)","v":0}]
[{"$f":"'Input Cost'!A20","v":"Outsourced"},2,13,5,{"$f":"SUMPRODUCT(B19:D19,DistanceFactorOutsourced,DistancesTripTypes)","v":{"v":1545,"d":"1545.00"}},{"$f":"SUM(B19:D19)","v":20},{"$f":"B15","v":13},{"$f":"MAX(F19:G19)","v":20}]
[{"$f":"'Input Cost'!A21","v":"Taxi "},17,0,1,{"$f":"SUMPRODUCT(B20:D20,DistanceFactorTaxi,DistancesTripTypes)","v":{"v":306,"d":"306.00"}}]
[null,null,"total no. of missions: ",{"$f":"SUM(B18:D20)","v":38}]
["Constraints ","Max. possible \nwith current solution ",null,"required "]
["Missions covered short",{"$f":"SUM(B18:B20)","v":19},"=",{"$f":"Constraints!B24","v":19}]
["Missions covered middle",{"$f":"SUM(C18:C20)","v":13},"=",{"$f":"Constraints!C24","v":13}]
["Missions covered long",{"$f":"SUM(D18:D20)","v":6},"=",{"$f":"Constraints!D24","v":6}]
["No concurrent trips ",{"$f":"SUM(B14:B15)+SUM(B20:D20)","v":31},">=",{"$f":"ROUNDUP('Input Demand'!D7/100*'Input Demand'!D5,0)","v":13}]
["Min number of vehicles (safety constraint)",{"$f":"SUM(B14:B14)","v":0},">=",{"$f":"'Input Demand'!D8","v":0}]
[{"$f":"'Input Cost'!A19","v":"Core-Drive"},{"$f":"B14*Constraints!B3","v":{"v":0,"d":"0.00"}},">=",{"$f":"E18","v":{"v":0,"d":"0.00"}},"Distance Constraints"]
[{"$f":"'Input Cost'!A20","v":"Outsourced"},{"$f":"B15*Constraints!C3","v":{"v":1560,"d":"1560.00"}},">=",{"$f":"E19","v":{"v":1545,"d":"1545.00"}}]
[{"$f":"'Input Cost'!A19","v":"Core-Drive"},{"$f":"B14*Constraints!B6","v":{"v":0,"d":"0.00"}},">=",{"$f":"SUMPRODUCT(B18:D18,Constraints!B12:D12)","v":{"v":0,"d":"0.00"}},"Time Constraints"]
[{"$f":"'Input Cost'!A20","v":"Outsourced"},{"$f":"B15*Constraints!C6","v":{"v":104,"d":"104.00"}},">=",{"$f":"SUMPRODUCT(B19:D19,Constraints!B13:D13)","v":{"v":69,"d":"69.00"}}]

{"sheet":"Dashboard","index":4,"n_rows":28,"n_cols":13,"rows_kept":28,"merged":[[4,4,4,6],[4,11,4,13],[20,4,20,6]]}
[]
[null,"Summary: Fleet Size and Composition"]
[]
[]
[null,null,"Cost per km single trip",null,"Cost per km ",{"$nulls":4},"Cost per km single trip",null,"Cost per km "]
[null,null,"Utilization ","km",{"$f":"'Input Cost'!A19","v":"Core-Drive"},{"$f":"'Input Cost'!A20","v":"Outsourced"},{"$f":"'Input Cost'!A21","v":"Taxi "},null,"Utilization ","km",{"$f":"'Input Cost'!A19","v":"Core-Drive"},{"$f":"'Input Cost'!A20","v":"Outsourced"},{"$f":"'Input Cost'!A21","v":"Taxi "}]
[null,null,0.01,{"$f":"Constraints!$B$3*C7","v":1.2},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$19*D7)/D7","v":{"v":49.310286805555556,"d":"49.31"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$20*D7)/D7","v":{"v":33.333333333333336,"d":"33.33"}},{"$f":"IF(D7<'Input Cost'!F21,'Input Cost'!D21,((('Input Cost'!$B$21*(D7-'Input Cost'!F21)+'Input Cost'!$D$21)/D7)))*(1-'Input Cost'!$H$21/100)","v":{"v":1.275,"d":"1.28"}},null,0.01,{"$f":"Constraints!$B$3*I7","v":1.2},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$19*J7)/J7","v":{"v":9.958057361111111,"d":"9.96"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$20*J7)/J7","v":{"v":6.666666666666667,"d":"6.67"}},{"$f":"IF(J7<'Input Cost'!F21,'Input Cost'!D21,((('Input Cost'!$B$21*(J7-'Input Cost'!F21)+'Input Cost'!$D$21)/J7)))*(1-'Input Cost'!$H$21/100)","v":{"v":1.275,"d":"1.28"}}]
[null,null,0.02,{"$f":"Constraints!$B$3*C8","v":2.4},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$19*D8)/D8","v":{"v":24.715143402777777,"d":"24.72"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$20*D8)/D8","v":{"v":16.666666666666668,"d":"16.67"}},{"$f":"IF(D8<'Input Cost'!F22,'Input Cost'!D22,((('Input Cost'!$B$21*(D8-'Input Cost'!F22)+'Input Cost'!$D$21)/D8)))*(1-'Input Cost'!$H$21/100)","v":{"v":1.04125,"d":"1.04"}},null,0.02,{"$f":"Constraints!$B$3*I8","v":2.4},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$19*J8)/J8","v":{"v":5.039028680555555,"d":"5.04"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$20*J8)/J8","v":{"v":3.3333333333333335,"d":"3.33"}},{"$f":"IF(J8<'Input Cost'!F22,'Input Cost'!D22,((('Input Cost'!$B$21*(J8-'Input Cost'!F22)+'Input Cost'!$D$21)/J8)))*(1-'Input Cost'!$H$21/100)","v":{"v":1.04125,"d":"1.04"}}]
[null,null,0.05,{"$f":"Constraints!$B$3*C9","v":6},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$19*D9)/D9","v":{"v":9.958057361111111,"d":"9.96"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$20*D9)/D9","v":{"v":6.666666666666667,"d":"6.67"}},{"$f":"IF(D9<'Input Cost'!F23,'Input Cost'!D23,((('Input Cost'!$B$21*(D9-'Input Cost'!F23)+'Input Cost'!$D$21)/D9)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.7224999999999999,"d":"0.72"}},null,0.05,{"$f":"Constraints!$B$3*I9","v":6},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$19*J9)/J9","v":{"v":2.087611472222222,"d":"2.09"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$20*J9)/J9","v":{"v":1.3333333333333333,"d":"1.33"}},{"$f":"IF(J9<'Input Cost'!F23,'Input Cost'!D23,((('Input Cost'!$B$21*(J9-'Input Cost'!F23)+'Input Cost'!$D$21)/J9)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.7224999999999999,"d":"0.72"}}]
[null,null,0.1,{"$f":"Constraints!$B$3*C10","v":12},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$19*D10)/D10","v":{"v":5.039028680555555,"d":"5.04"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$20*D10)/D10","v":{"v":3.3333333333333335,"d":"3.33"}},{"$f":"IF(D10<'Input Cost'!F24,'Input Cost'!D24,((('Input Cost'!$B$21*(D10-'Input Cost'!F24)+'Input Cost'!$D$21)/D10)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.61625,"d":"0.62"}},null,0.1,{"$f":"Constraints!$B$3*I10","v":12},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$19*J10)/J10","v":{"v":1.1038057361111109,"d":"1.10"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$20*J10)/J10","v":{"v":0.6666666666666666,"d":"0.67"}},{"$f":"IF(J10<'Input Cost'!F24,'Input Cost'!D24,((('Input Cost'!$B$21*(J10-'Input Cost'!F24)+'Input Cost'!$D$21)/J10)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.61625,"d":"0.62"}}]
["Cost Analysis ",null,0.2,{"$f":"Constraints!$B$3*C11","v":24},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$19*D11)/D11","v":{"v":2.5795143402777776,"d":"2.58"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$20*D11)/D11","v":{"v":1.6666666666666667,"d":"1.67"}},{"$f":"IF(D11<'Input Cost'!F25,'Input Cost'!D25,((('Input Cost'!$B$21*(D11-'Input Cost'!F25)+'Input Cost'!$D$21)/D11)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.563125,"d":"0.56"}},null,0.2,{"$f":"Constraints!$B$3*I11","v":24},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$19*J11)/J11","v":{"v":0.6119028680555555,"d":"0.61"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$20*J11)/J11","v":{"v":0.3333333333333333,"d":"0.33"}},{"$f":"IF(J11<'Input Cost'!F25,'Input Cost'!D25,((('Input Cost'!$B$21*(J11-'Input Cost'!F25)+'Input Cost'!$D$21)/J11)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.563125,"d":"0.56"}}]
[null,null,0.3,{"$f":"Constraints!$B$3*C12","v":36},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$19*D12)/D12","v":{"v":1.7596762268518518,"d":"1.76"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$20*D12)/D12","v":{"v":1.1111111111111112,"d":"1.11"}},{"$f":"IF(D12<'Input Cost'!F26,'Input Cost'!D26,((('Input Cost'!$B$21*(D12-'Input Cost'!F26)+'Input Cost'!$D$21)/D12)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.5454166666666665,"d":"0.55"}},null,0.3,{"$f":"Constraints!$B$3*I12","v":36},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$19*J12)/J12","v":{"v":0.4479352453703703,"d":"0.45"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$20*J12)/J12","v":{"v":0.2222222222222222,"d":"0.22"}},{"$f":"IF(J12<'Input Cost'!F26,'Input Cost'!D26,((('Input Cost'!$B$21*(J12-'Input Cost'!F26)+'Input Cost'!$D$21)/J12)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.5454166666666665,"d":"0.55"}}]
[null,null,0.4,{"$f":"Constraints!$B$3*C13","v":48},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$19*D13)/D13","v":{"v":1.3497571701388889,"d":"1.35"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$20*D13)/D13","v":{"v":0.8333333333333334,"d":"0.83"}},{"$f":"IF(D13<'Input Cost'!F27,'Input Cost'!D27,((('Input Cost'!$B$21*(D13-'Input Cost'!F27)+'Input Cost'!$D$21)/D13)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.5365624999999999,"d":"0.54"}},null,0.4,{"$f":"Constraints!$B$3*I13","v":48},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$19*J13)/J13","v":{"v":0.3659514340277778,"d":"0.37"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$20*J13)/J13","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"IF(J13<'Input Cost'!F27,'Input Cost'!D27,((('Input Cost'!$B$21*(J13-'Input Cost'!F27)+'Input Cost'!$D$21)/J13)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.5365624999999999,"d":"0.54"}}]
[null,null,0.5,{"$f":"Constraints!$B$3*C14","v":60},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$19*D14)/D14","v":{"v":1.1038057361111109,"d":"1.10"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$20*D14)/D14","v":{"v":0.6666666666666666,"d":"0.67"}},{"$f":"IF(D14<'Input Cost'!F28,'Input Cost'!D28,((('Input Cost'!$B$21*(D14-'Input Cost'!F28)+'Input Cost'!$D$21)/D14)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.53125,"d":"0.53"}},null,0.5,{"$f":"Constraints!$B$3*I14","v":60},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$19*J14)/J14","v":{"v":0.3167611472222222,"d":"0.32"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$20*J14)/J14","v":{"v":0.13333333333333333,"d":"0.13"}},{"$f":"IF(J14<'Input Cost'!F28,'Input Cost'!D28,((('Input Cost'!$B$21*(J14-'Input Cost'!F28)+'Input Cost'!$D$21)/J14)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.53125,"d":"0.53"}}]
[null,null,0.6,{"$f":"Constraints!$B$3*C15","v":72},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$19*D15)/D15","v":{"v":0.9398381134259258,"d":"0.94"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$20*D15)/D15","v":{"v":0.5555555555555556,"d":"0.56"}},{"$f":"IF(D15<'Input Cost'!F29,'Input Cost'!D29,((('Input Cost'!$B$21*(D15-'Input Cost'!F29)+'Input Cost'!$D$21)/D15)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.5277083333333332,"d":"0.53"}},null,0.6,{"$f":"Constraints!$B$3*I15","v":72},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$19*J15)/J15","v":{"v":0.28396762268518516,"d":"0.28"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$20*J15)/J15","v":{"v":0.1111111111111111,"d":"0.11"}},{"$f":"IF(J15<'Input Cost'!F29,'Input Cost'!D29,((('Input Cost'!$B$21*(J15-'Input Cost'!F29)+'Input Cost'!$D$21)/J15)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.5277083333333332,"d":"0.53"}}]
[null,null,0.7,{"$f":"Constraints!$B$3*C16","v":84},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$19*D16)/D16","v":{"v":0.822718382936508,"d":"0.82"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$20*D16)/D16","v":{"v":0.47619047619047616,"d":"0.48"}},{"$f":"IF(D16<'Input Cost'!F30,'Input Cost'!D30,((('Input Cost'!$B$21*(D16-'Input Cost'!F30)+'Input Cost'!$D$21)/D16)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.5251785714285714,"d":"0.53"}},null,0.7,{"$f":"Constraints!$B$3*I16","v":84},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$19*J16)/J16","v":{"v":0.2605436765873016,"d":"0.26"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$20*J16)/J16","v":{"v":0.09523809523809523,"d":"0.10"}},{"$f":"IF(J16<'Input Cost'!F30,'Input Cost'!D30,((('Input Cost'!$B$21*(J16-'Input Cost'!F30)+'Input Cost'!$D$21)/J16)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.5251785714285714,"d":"0.53"}}]
[null,null,0.8,{"$f":"Constraints!$B$3*C17","v":96},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$19*D17)/D17","v":{"v":0.7348785850694445,"d":"0.73"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$20*D17)/D17","v":{"v":0.4166666666666667,"d":"0.42"}},{"$f":"IF(D17<'Input Cost'!F31,'Input Cost'!D31,((('Input Cost'!$B$21*(D17-'Input Cost'!F31)+'Input Cost'!$D$21)/D17)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.5232812499999999,"d":"0.52"}},null,0.8,{"$f":"Constraints!$B$3*I17","v":96},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$19*J17)/J17","v":{"v":0.24297571701388887,"d":"0.24"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$20*J17)/J17","v":{"v":0.08333333333333333,"d":"0.08"}},{"$f":"IF(J17<'Input Cost'!F31,'Input Cost'!D31,((('Input Cost'!$B$21*(J17-'Input Cost'!F31)+'Input Cost'!$D$21)/J17)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.5232812499999999,"d":"0.52"}}]
[null,null,0.9,{"$f":"Constraints!$B$3*C18","v":108},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$19*D18)/D18","v":{"v":0.6665587422839506,"d":"0.67"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$20*D18)/D18","v":{"v":0.37037037037037035,"d":"0.37"}},{"$f":"IF(D18<'Input Cost'!F32,'Input Cost'!D32,((('Input Cost'!$B$21*(D18-'Input Cost'!F32)+'Input Cost'!$D$21)/D18)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.5218055555555555,"d":"0.52"}},null,0.9,{"$f":"Constraints!$B$3*I18","v":108},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$19*J18)/J18","v":{"v":0.2293117484567901,"d":"0.23"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$20*J18)/J18","v":{"v":0.07407407407407407,"d":"0.07"}},{"$f":"IF(J18<'Input Cost'!F32,'Input Cost'!D32,((('Input Cost'!$B$21*(J18-'Input Cost'!F32)+'Input Cost'!$D$21)/J18)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.5218055555555555,"d":"0.52"}}]
[null,null,1,{"$f":"Constraints!$B$3*C19","v":120},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$19*D19)/D19","v":{"v":0.6119028680555555,"d":"0.61"}},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$20*D19)/D19","v":{"v":0.3333333333333333,"d":"0.33"}},{"$f":"IF(D19<'Input Cost'!F33,'Input Cost'!D33,((('Input Cost'!$B$21*(D19-'Input Cost'!F33)+'Input Cost'!$D$21)/D19)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.520625,"d":"0.52"}},null,1,{"$f":"Constraints!$B$3*I19","v":120},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$19*J19)/J19","v":{"v":0.2183805736111111,"d":"0.22"}},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$20*J19)/J19","v":{"v":0.06666666666666667,"d":"0.07"}},{"$f":"IF(J19<'Input Cost'!F33,'Input Cost'!D33,((('Input Cost'!$B$21*(J19-'Input Cost'!F33)+'Input Cost'!$D$21)/J19)))*(1-'Input Cost'!$H$21/100)","v":{"v":0.520625,"d":"0.52"}}]
[]
[null,null,"Cost per Mission",null,"Cost per Mission "]
[{"$nulls":4},"Self-Drive","Core Drive","Outsourced","Taxi"]
[]
[]
[null,"Transportation Mode","Fleet","short Missions","middle Missions ","long Missions","Missions","Distance"]
["Operational Mix ",{"$f":"'Input Cost'!A19","v":"Core-Drive"},{"$f":"Solver!B14","v":0},{"$f":"Solver!B18","v":0},{"$f":"Solver!C18","v":0},{"$f":"Solver!D18","v":0},{"$f":"SUM(D26:F26)","v":0},{"$f":"Solver!E18","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"'Input Cost'!A20","v":"Outsourced"},{"$f":"Solver!B15","v":13},{"$f":"Solver!B19","v":2},{"$f":"Solver!C19","v":13},{"$f":"Solver!D19","v":5},{"$f":"SUM(D27:F27)","v":20},{"$f":"Solver!E19","v":{"v":1545,"d":"1545.00"}}]
["Trips",{"$f":"'Input Cost'!A21&\" \"&A28","v":"Taxi  Trips"},{"$f":"SUM(D28:F28)","v":18},{"$f":"Solver!B20","v":17},{"$f":"Solver!C20","v":0},{"$f":"Solver!D20","v":1},{"$f":"SUM(D28:F28)","v":18},{"$f":"Solver!E20","v":{"v":306,"d":"306.00"}}]

{"sheet":"Cost Savings Opportunity","index":5,"n_rows":33,"n_cols":10,"rows_kept":33}
[]
["Time period for savings plots",250,"days"]
[]
["Time period for cost input ",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 (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":"G17*'Input Cost'!D9","v":{"v":0,"d":"0.00"}},{"$f":"G6*'Cost Savings Opportunity'!$B$2","v":{"v":0,"d":"0.00"}},{"$f":"F6-H6","v":{"v":128693.333333333,"d":"128693.33"}},{"$f":"IF(F6<>0,(F6-H6)/F6*100,0)","v":{"v":100,"d":"100.00"}}]
["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":"G17*'Input Cost'!D10","v":{"v":0,"d":"0.00"}},{"$f":"G7*'Cost Savings Opportunity'!$B$2","v":{"v":0,"d":"0.00"}},{"$f":"F7-H7","v":{"v":45491.36666666666,"d":"45491.37"}},{"$f":"IF(F7<>0,(F7-H7)/F7*100,0)","v":{"v":100,"d":"100.00"}}]
["Salary (core drive)",{"v":15695,"d":"15695.00"},{"$f":"CONCATENATE('Input Cost'!$B$3,\"/period\")","v":"Euro/period"},null,{"v":627.8,"d":"627.80"},{"$f":"E8*'Cost Savings Opportunity'!$B$2","v":{"v":156950,"d":"156950.00"}},{"$f":"G16*'Input Cost'!D11","v":{"v":0,"d":"0.00"}},{"$f":"G8*'Cost Savings Opportunity'!$B$2","v":{"v":0,"d":"0.00"}},{"v":156950,"d":"156950.00"},{"v":100,"d":"100.00"}]
["Insurance",{"v":3358.6775000000002,"d":"3358.68"},{"$f":"CONCATENATE('Input Cost'!$B$3,\"/period\")","v":"Euro/period"},null,{"v":134.3471,"d":"134.35"},{"$f":"E9*'Cost Savings Opportunity'!$B$2","v":{"v":33586.775,"d":"33586.78"}},{"$f":"G17*'Input Cost'!D12","v":{"v":0,"d":"0.00"}},{"$f":"G9*'Cost Savings Opportunity'!$B$2","v":{"v":0,"d":"0.00"}},{"$f":"F9-H9","v":{"v":33586.775,"d":"33586.78"}},{"v":100,"d":"100.00"}]
["Other",{"v":331.6925,"d":"331.69"},{"$f":"CONCATENATE('Input Cost'!$B$3,\"/period\")","v":"Euro/period"},null,{"v":13.2677,"d":"13.27"},{"$f":"E10*'Cost Savings Opportunity'!$B$2","v":{"v":3316.9249999999997,"d":"3316.93"}},{"$f":"G17*'Input Cost'!D13","v":{"v":0,"d":"0.00"}},{"$f":"G10*'Cost Savings Opportunity'!$B$2","v":{"v":0,"d":"0.00"}},{"v":3316.9249999999997,"d":"3316.93"},{"v":100,"d":"100.00"}]
[]
["Cost for Outsourcing",{"v":0,"d":"0.00"},{"$f":"CONCATENATE('Input Cost'!$B$3,\"/period\")","v":"Euro/period"},null,{"v":0,"d":"0.00"},{"$f":"E12*'Cost Savings Opportunity'!$B$2","v":{"v":0,"d":"0.00"}},{"$f":"Solver!B7+Solver!B10","v":{"v":520,"d":"520.00"}},{"$f":"G12*'Cost Savings Opportunity'!$B$2","v":{"v":130000,"d":"130000.00"}},{"v":-130000,"d":"-130000.00"},{"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,{"v":444.3258999999999,"d":"444.33"},{"$f":"E13*'Cost Savings Opportunity'!$B$2","v":{"v":111081.47499999996,"d":"111081.48"}},{"$f":"Solver!B11","v":165.24},{"$f":"G13*'Cost Savings Opportunity'!$B$2","v":{"v":41310,"d":"41310.00"}},{"v":69771.47499999996,"d":"69771.48"},{"v":62.81108078552251,"d":"62.81"}]
["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,{"v":109.5197,"d":"109.52"},{"$f":"E14*'Cost Savings Opportunity'!$B$2","v":{"v":27379.925,"d":"27379.93"}},{"$f":"Solver!B9","v":{"v":0,"d":"0.00"}},{"$f":"G14*'Cost Savings Opportunity'!$B$2","v":{"v":0,"d":"0.00"}},{"v":27379.925,"d":"27379.93"},{"v":100,"d":"100.00"}]
[]
["No drivers",20,null,null,{"$f":"B16","v":20},{"$f":"B16","v":20},{"$f":"Solver!B14","v":0},{"$f":"G16","v":0},{"$f":"F16-H16","v":20},100]
["No vehicles ",57,null,null,{"$f":"B17","v":57},{"$f":"B17","v":57},{"$f":"Solver!B14","v":0},{"$f":"G17","v":0},{"$f":"F17-H17","v":57},100]
[]
[]
[]
[]
[]
[]
["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":0,"d":"0.00"}}]
["Technology",{"$f":"F7","v":{"v":45491.36666666666,"d":"45491.37"}},{"$f":"H7","v":{"v":0,"d":"0.00"}}]
["Salary (core drive)",{"v":156950,"d":"156950.00"},{"v":0,"d":"0.00"}]
["Insurance",{"v":33586.775,"d":"33586.78"},{"v":0,"d":"0.00"}]
["Other",{"v":3316.9249999999997,"d":"3316.93"},{"v":0,"d":"0.00"}]
[]
[{"$f":"'Input Cost'!A20","v":"Outsourced"},{"v":0,"d":"0.00"},{"v":130000,"d":"130000.00"}]
[{"$f":"'Input Cost'!A21","v":"Taxi "},{"v":111081.47499999996,"d":"111081.48"},{"v":41310,"d":"41310.00"}]
["Fuel + M&R",{"v":27379.925,"d":"27379.93"},{"v":0,"d":"0.00"}]

{"sheet":"Triangle Analysis","index":6,"n_rows":10,"n_cols":13,"rows_kept":10,"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'!A19","v":"Core-Drive"},{"$f":"SUMPRODUCT(Constraints!B24:D24,DistanceFactorCoreDrive,DistancesTripTypes)","v":{"v":1987,"d":"1987.00"}},{"$f":"C6*'Input Cost'!B19","v":238.44},{"$f":"ROUNDUP((SUMPRODUCT(Constraints!B24:D24,Constraints!B12:D12))/Constraints!B6,0)","v":13},{"$f":"ROUNDUP((C6/Constraints!B3),0)","v":17},{"$f":"Solver!$D$26","v":13},{"$f":"Solver!$D$27","v":0},{"$f":"MAX(E6:H6)","v":17},{"$f":"I6","v":17},{"$f":"I6*'Input Cost'!D6","v":{"v":1003.4818508333333,"d":"1003.48"}},{"$f":"D6+K6","v":{"v":1241.9218508333333,"d":"1241.92"}},{"$f":"L6*'Cost Savings Opportunity'!$B$2","v":{"v":310480.46270833333,"d":"310480.46"}}]
[{"v":1,"d":"100%"},{"$f":"'Input Cost'!A20","v":"Outsourced"},{"$f":"SUMPRODUCT(Constraints!B24:D24,DistanceFactorOutsourced,DistancesTripTypes)","v":{"v":1987,"d":"1987.00"}},{"$f":"C7*'Input Cost'!B20","v":0},{"$f":"ROUNDUP((SUMPRODUCT(Constraints!B24:D24,Constraints!B13:D13))/Constraints!C6,0)","v":13},{"$f":"ROUNDUP((C7/Constraints!C3),0)","v":17},{"$f":"Solver!$D$26","v":13},{"$f":"Solver!$D$27","v":0},{"$f":"MAX(E7:H7)","v":17},0,{"$f":"I7*'Input Cost'!D7","v":{"v":680,"d":"680.00"}},{"$f":"D7+K7","v":{"v":680,"d":"680.00"}},{"$f":"L7*'Cost Savings Opportunity'!$B$2","v":{"v":170000,"d":"170000.00"}}]
[{"v":1,"d":"100%"},{"$f":"'Input Cost'!A21","v":"Taxi "},{"$f":"SUMPRODUCT(Constraints!B24:D24,DistanceFactorTaxi,DistancesTripTypes)","v":{"v":1614,"d":"1614.00"}},{"$f":"((C8-'Input Cost'!F21*'Input Demand'!D5)*'Input Cost'!B21+'Input Cost'!D21*'Input Demand'!D5)*(1-'Input Cost'!H21/100)","v":842.5199999999999},"-","-","-","-","-","-",{"v":0,"d":"0.00"},{"$f":"D8+K8","v":{"v":842.5199999999999,"d":"842.52"}},{"$f":"L8*'Cost Savings Opportunity'!$B$2","v":{"v":210629.99999999997,"d":"210630.00"}}]
[null,"Status quo",{"$nulls":6},{"$f":"'Cost Savings Opportunity'!B17","v":57},{"$f":"'Cost Savings Opportunity'!B16","v":20},null,{"$f":"SUM('Cost Savings Opportunity'!B6:B14)/'Cost Savings Opportunity'!B4","v":{"v":2025.9991999999984,"d":"2026.00"}},{"$f":"L9*'Cost Savings Opportunity'!$B$2","v":{"v":506499.7999999996,"d":"506499.80"}}]
[null,"Optimal Solution",{"$f":"SUM(Solver!E18:E20)","v":{"v":1851,"d":"1851.00"}},{"$f":"Solver!B8","v":165.24},{"$nulls":4},{"$f":"Solver!B14","v":0},{"$f":"Solver!B14","v":0},{"$f":"Solver!B5","v":{"v":520,"d":"520.00"}},{"$f":"D10+K10","v":685.24},{"$f":"L10*'Cost Savings Opportunity'!$B$2","v":{"v":171310,"d":"171310.00"}}]