{"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!B24+ROUND((D10/100)*B5,0)*Constraints!C24+ROUND((D11/100)*B5,0)*Constraints!D24","v":{"v":17523,"d":"17523.0"}},{"$f":"B4/B3","v":796.5},{"$f":"Constraints!B26*Constraints!B24+Constraints!C26*Constraints!C24+Constraints!D26*Constraints!D24","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":{"v":15,"d":"15.0"}},"% "]

{"sheet":"Input Cost","index":1,"n_rows":23,"n_cols":9,"rows_kept":23}
["Fixed Cost per Vehicle "]
[]
["Currency ","Euro"]
[]
["Vehicle Type","Value","Unit","Value","Unit"]
[{"$f":"A20","v":"Self-Drive"},null,null,{"$f":"SUM(D10:D14)-D12","v":{"v":11.50834416666666,"d":"11.51"}},{"$f":"CONCATENATE($B$3,\"/day\")","v":"Euro/day"}]
[{"$f":"A21","v":"Core-Drive"},null,null,{"$f":"SUM(D10:D14)","v":{"v":59.02834416666666,"d":"59.03"}},{"$f":"CONCATENATE($B$3,\"/day\")","v":"Euro/day"}]
["Outsourced",null,null,{"v":40,"d":"40.00"},"Euro/day"]
[]
["Asset",{"v":1998.1666666666667,"d":"1998"},{"$f":"CONCATENATE($B$3,\"/year\")","v":"Euro/year"},{"$f":"B10/250","v":{"v":7.992666666666667,"d":"7.99"}},"Euro/day"]
["Technology",{"v":135.739375,"d":"136"},{"$f":"CONCATENATE($B$3,\"/year\")","v":"Euro/year"},{"$f":"B11/250","v":{"v":0.5429575,"d":"0.54"}},"Euro/day"]
["Labour (core drive)",11880,"Euro/year",{"$f":"B12/250","v":47.52},"Euro/day"]
["Insurance",680,"Euro/year",{"$f":"B13/250","v":2.72},"Euro/day"]
["Other",{"v":63.18,"d":"63"},"Euro/year",{"$f":"B14/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",0,"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 and ",15,"% off"]

{"sheet":"Constraints","index":2,"n_rows":26,"n_cols":8,"rows_kept":26,"merged":[[14,1,14,3]]}
["Max. Utilization per Vehicle per day "]
[null,{"$f":"'Input Cost'!A20","v":"Self-Drive"},{"$f":"'Input Cost'!A21","v":"Core-Drive"},{"$f":"'Input Cost'!A22","v":"Outsourced"},"Unit ","Taxi "]
["Distance travelled ",120,120,120,"km/day","-","per trip "]
["Max. possible missions",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,"per trip",3,"per trip "]
["Effective time (time budget)",8,8,8,"hours per day"]
[]
[]
[]
[]
["Trip duration","short trip ","middle trip","long trip "]
[{"$f":"'Input Cost'!A20","v":"Self-Drive"},3,4,8]
[{"$f":"'Input Cost'!A21","v":"Core-Drive"},1.5,2,8]
[{"$f":"'Input Cost'!A22","v":"Outsourced"},1.5,2,8]
[{"$f":"'Input Cost'!A23","v":"Taxi "},"not relevant to the model"]
[]
["Distance factor","short trip ","middle trip","long trip "]
[{"$f":"'Input Cost'!A20","v":"Self-Drive"},2,2,2]
[{"$f":"'Input Cost'!A21","v":"Core-Drive"},4,3,2]
[{"$f":"'Input Cost'!A22","v":"Outsourced"},4,3,2]
[{"$f":"'Input Cost'!A23","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":41,"n_cols":8,"rows_kept":41,"merged":[[31,4,33,4],[34,4,36,4]]}
[]
[null,"Excel Solver Sheet"]
[]
["Total Cost (per day)",{"$f":"B5+B9","v":{"v":408.6284741666666,"d":"408.63"}},{"$f":"'Input Cost'!$B$3","v":"Euro"}]
["Fix Costs (per day)",{"$f":"SUM(B6:B8)","v":{"v":149.60847416666658,"d":"149.61"}},{"$f":"'Input Cost'!$B$3","v":"Euro"}]
[{"$f":"'Input Cost'!A20","v":"Self-Drive"},{"$f":"B16*'Input Cost'!D6","v":{"v":149.60847416666658,"d":"149.61"}},{"$f":"'Input Cost'!$B$3","v":"Euro"}]
[{"$f":"'Input Cost'!A21","v":"Core-Drive"},{"$f":"B17*'Input Cost'!D7","v":{"v":0,"d":"0.00"}},{"$f":"'Input Cost'!$B$3","v":"Euro"}]
[{"$f":"'Input Cost'!A22","v":"Outsourced"},{"$f":"B18*'Input Cost'!D8","v":{"v":0,"d":"0.00"}},{"$f":"'Input Cost'!$B$3","v":"Euro"}]
["Variable Costs (per day)",{"$f":"SUM(B10:B13)","v":259.02},{"$f":"'Input Cost'!$B$3","v":"Euro"}]
[{"$f":"'Input Cost'!A20","v":"Self-Drive"},{"$f":"E21*'Input Cost'!B20","v":{"v":176.4,"d":"176.40"}},{"$f":"'Input Cost'!$B$3","v":"Euro"}]
[{"$f":"'Input Cost'!A21","v":"Core-Drive"},{"$f":"E22*'Input Cost'!B21","v":{"v":0,"d":"0.00"}},{"$f":"'Input Cost'!$B$3","v":"Euro"}]
[{"$f":"'Input Cost'!A22","v":"Outsourced"},{"$f":"E23*'Input Cost'!B22","v":{"v":0,"d":"0.00"}},{"$f":"'Input Cost'!$B$3","v":"Euro"}]
[{"$f":"'Input Cost'!A23","v":"Taxi "},{"$f":"((E24-'Input Cost'!F23*SUM(B24:D24))*'Input Cost'!B23+SUM(B24:D24)*'Input Cost'!D23)*(1-'Input Cost'!H23/100)","v":82.62},{"$f":"'Input Cost'!$B$3","v":"Euro"}]
[]
["Fleet Composition "]
[{"$f":"'Input Cost'!A20","v":"Self-Drive"},13,"vehicles "]
[{"$f":"'Input Cost'!A21","v":"Core-Drive"},0,"vehicles "]
[{"$f":"'Input Cost'!A22","v":"Outsourced"},0,"vehicles "]
["Taxi Trips ",{"$f":"SUM(B24:D24)","v":18},"trips"]
["Operational Mix (per day)","short missions","middle missions","long missions","total km ","no_missions","no_vehicles","max. "]
[{"$f":"'Input Cost'!A20","v":"Self-Drive"},1,13,6,{"$f":"SUMPRODUCT(B21:D21,DistanceFactorSelfDrive,DistancesTripTypes)","v":{"v":1470,"d":"1470.00"}},{"$f":"SUM(B21:D21)","v":{"v":20,"d":"20.00"}},{"$f":"B16","v":{"v":13,"d":"13.00"}},{"$f":"MAX(F21:G21)","v":{"v":20,"d":"20.00"}}]
[{"$f":"'Input Cost'!A21","v":"Core-Drive"},0,0,0,{"$f":"SUMPRODUCT(B22:D22,DistanceFactorCoreDrive,DistancesTripTypes)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B22:D22)","v":{"v":0,"d":"0.00"}},{"$f":"B17","v":{"v":0,"d":"0.00"}},{"$f":"MAX(F22:G22)","v":{"v":0,"d":"0.00"}}]
[{"$f":"'Input Cost'!A22","v":"Outsourced"},0,0,0,{"$f":"SUMPRODUCT(B23:D23,DistanceFactorOutsourced,DistancesTripTypes)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B23:D23)","v":{"v":0,"d":"0.00"}},{"$f":"B18","v":{"v":0,"d":"0.00"}},{"$f":"MAX(F23:G23)","v":{"v":0,"d":"0.00"}}]
[{"$f":"'Input Cost'!A23","v":"Taxi "},18,0,0,{"$f":"SUMPRODUCT(B24:D24,DistanceFactorTaxi,DistancesTripTypes)","v":{"v":144,"d":"144.00"}}]
[null,null,"total no. of missions:",{"$f":"SUM(B21:D24)","v":38}]
["Constraints ","Max. possible \nwith current solution ",null,"required "]
["Missions covered short",{"$f":"SUM(B21:B24)","v":19},"=",{"$f":"Constraints!B26","v":19}]
["Missions covered middle",{"$f":"SUM(C21:C24)","v":13},"=",{"$f":"Constraints!C26","v":13}]
["Missions covered long",{"$f":"SUM(D21:D24)","v":6},"=",{"$f":"Constraints!D26","v":6}]
["No concurrent trips ",{"$f":"SUM(B16:B18)+SUM(B24:D24)","v":31},">=",{"$f":"ROUNDUP('Input Demand'!D7/100*'Input Demand'!D5,0)","v":13}]
["Min number of vehicles (safety constraint)",{"$f":"SUM(B16:B17)","v":13},">=",{"$f":"'Input Demand'!D8","v":0}]
[{"$f":"'Input Cost'!A20","v":"Self-Drive"},{"$f":"B16*Constraints!B3","v":{"v":1560,"d":"1560.00"}},">=",{"$f":"E21","v":{"v":1470,"d":"1470.00"}},"Distance Constraints"]
[{"$f":"'Input Cost'!A21","v":"Core-Drive"},{"$f":"B17*Constraints!C3","v":{"v":0,"d":"0.00"}},">=",{"$f":"E22","v":{"v":0,"d":"0.00"}}]
[{"$f":"'Input Cost'!A22","v":"Outsourced"},{"$f":"B18*Constraints!D3","v":{"v":0,"d":"0.00"}},">=",{"$f":"E23","v":{"v":0,"d":"0.00"}}]
[{"$f":"'Input Cost'!A20","v":"Self-Drive"},{"$f":"B16*Constraints!B6","v":{"v":104,"d":"104.00"}},">=",{"$f":"SUMPRODUCT(B21:D21,Constraints!B12:D12)","v":{"v":103,"d":"103.00"}},"Time Constraints"]
[{"$f":"'Input Cost'!A21","v":"Core-Drive"},{"$f":"B17*Constraints!C6","v":{"v":0,"d":"0.00"}},">=",{"$f":"SUMPRODUCT(B22:D22,Constraints!B13:D13)","v":{"v":0,"d":"0.00"}}]
[{"$f":"'Input Cost'!A22","v":"Outsourced"},{"$f":"B18*Constraints!D6","v":{"v":0,"d":"0.00"}},">=",{"$f":"SUMPRODUCT(B23:D23,Constraints!B14:D14)","v":{"v":0,"d":"0.00"}}]
["Passengers self-drive",{"$f":"Constraints!B5*SUM(B21:D21)","v":80},">=",{"$f":"'Input Demand'!$D$6/'Input Demand'!$D$5*SUM(B21:D21)","v":{"v":21.578947368421055,"d":"22"}}]
["Passengers core-drive",{"$f":"Constraints!C5*SUM(B22:D22)","v":0},">=",{"$f":"'Input Demand'!$D$6/'Input Demand'!$D$5*SUM(B22:D22)","v":0}]
["Passengers outsourced",{"$f":"Constraints!D5*SUM(B23:D23)","v":0},">=",{"$f":"'Input Demand'!$D$6/'Input Demand'!$D$5*SUM(B23:D23)","v":0}]
["Passengers Taxi ",{"$f":"Constraints!F5*SUM(B24:D24)","v":54},">=",{"$f":"'Input Demand'!$D$6/'Input Demand'!$D$5*SUM(B24:D24)","v":{"v":19.42105263157895,"d":"19"}},null,null,"M"]

{"sheet":"Dashboard","index":4,"n_rows":29,"n_cols":15,"rows_kept":29,"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'!A20","v":"Self-Drive"},{"$f":"'Input Cost'!A21","v":"Core-Drive"},{"$f":"'Input Cost'!A22","v":"Outsourced"},{"$f":"'Input Cost'!A23","v":"Taxi "},null,"Utilization ","km",{"$f":"'Input Cost'!A20","v":"Self-Drive"},{"$f":"'Input Cost'!A21","v":"Core-Drive"},{"$f":"'Input Cost'!A22","v":"Outsourced"},{"$f":"'Input Cost'!A23","v":"Taxi "}]
[null,null,0.01,{"$f":"Constraints!$C$3*C7","v":1.2},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$20*D7)/D7","v":9.710286805555551},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$21*D7)/D7","v":49.310286805555556},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$22*D7)/D7","v":{"v":33.333333333333336,"d":"33.33"}},{"$f":"IF(D7<'Input Cost'!F23,'Input Cost'!D23,((('Input Cost'!$B$23*(D7-'Input Cost'!F23)+'Input Cost'!$D$23)/D7)*(1-'Input Cost'!$H$23/100)))","v":{"v":1.5,"d":"1.500"}},null,0.01,{"$f":"Constraints!$C$3*J7","v":1.2},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$20*K7)/K7","v":2.03805736111111},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$21*K7)/K7","v":9.958057361111111},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$22*K7)/K7","v":{"v":6.666666666666667,"d":"6.67"}},{"$f":"IF(K7<'Input Cost'!F23,'Input Cost'!D23,((('Input Cost'!$B$23*(K7-'Input Cost'!F23)+'Input Cost'!$D$23)/K7)*(1-'Input Cost'!$H$23/100)))","v":{"v":1.5,"d":"1.500"}}]
[null,null,0.02,{"$f":"Constraints!$C$3*C8","v":2.4},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$20*D8)/D8","v":4.915143402777775},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$21*D8)/D8","v":24.715143402777777},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$22*D8)/D8","v":{"v":16.666666666666668,"d":"16.67"}},{"$f":"IF(D8<'Input Cost'!F24,'Input Cost'!D24,((('Input Cost'!$B$23*(D8-'Input Cost'!F24)+'Input Cost'!$D$23)/D8)*(1-'Input Cost'!$H$23/100)))","v":{"v":1.04125,"d":"1.041"}},null,0.02,{"$f":"Constraints!$C$3*J8","v":2.4},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$20*K8)/K8","v":1.079028680555555},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$21*K8)/K8","v":5.039028680555555},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$22*K8)/K8","v":{"v":3.3333333333333335,"d":"3.33"}},{"$f":"IF(K8<'Input Cost'!F24,'Input Cost'!D24,((('Input Cost'!$B$23*(K8-'Input Cost'!F24)+'Input Cost'!$D$23)/K8)*(1-'Input Cost'!$H$23/100)))","v":{"v":1.04125,"d":"1.041"}}]
[null,null,0.05,{"$f":"Constraints!$C$3*C9","v":6},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$20*D9)/D9","v":2.03805736111111},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$21*D9)/D9","v":9.958057361111111},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$22*D9)/D9","v":{"v":6.666666666666667,"d":"6.67"}},{"$f":"IF(D9<'Input Cost'!F25,'Input Cost'!D25,((('Input Cost'!$B$23*(D9-'Input Cost'!F25)+'Input Cost'!$D$23)/D9)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.7224999999999999,"d":"0.723"}},null,0.05,{"$f":"Constraints!$C$3*J9","v":6},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$20*K9)/K9","v":0.503611472222222},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$21*K9)/K9","v":2.087611472222222},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$22*K9)/K9","v":{"v":1.3333333333333333,"d":"1.33"}},{"$f":"IF(K9<'Input Cost'!F25,'Input Cost'!D25,((('Input Cost'!$B$23*(K9-'Input Cost'!F25)+'Input Cost'!$D$23)/K9)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.7224999999999999,"d":"0.723"}}]
[null,null,0.1,{"$f":"Constraints!$C$3*C10","v":12},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$20*D10)/D10","v":1.079028680555555},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$21*D10)/D10","v":5.039028680555555},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$22*D10)/D10","v":{"v":3.3333333333333335,"d":"3.33"}},{"$f":"IF(D10<'Input Cost'!F26,'Input Cost'!D26,((('Input Cost'!$B$23*(D10-'Input Cost'!F26)+'Input Cost'!$D$23)/D10)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.61625,"d":"0.616"}},null,0.1,{"$f":"Constraints!$C$3*J10","v":12},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$20*K10)/K10","v":0.311805736111111},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$21*K10)/K10","v":1.1038057361111109},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$22*K10)/K10","v":{"v":0.6666666666666666,"d":"0.67"}},{"$f":"IF(K10<'Input Cost'!F26,'Input Cost'!D26,((('Input Cost'!$B$23*(K10-'Input Cost'!F26)+'Input Cost'!$D$23)/K10)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.61625,"d":"0.616"}}]
["Cost Analysis ",null,0.2,{"$f":"Constraints!$C$3*C11","v":24},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$20*D11)/D11","v":0.5995143402777775},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$21*D11)/D11","v":2.5795143402777776},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$22*D11)/D11","v":{"v":1.6666666666666667,"d":"1.67"}},{"$f":"IF(D11<'Input Cost'!F27,'Input Cost'!D27,((('Input Cost'!$B$23*(D11-'Input Cost'!F27)+'Input Cost'!$D$23)/D11)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.563125,"d":"0.563"}},null,0.2,{"$f":"Constraints!$C$3*J11","v":24},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$20*K11)/K11","v":0.21590286805555547},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$21*K11)/K11","v":0.6119028680555555},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$22*K11)/K11","v":{"v":0.3333333333333333,"d":"0.33"}},{"$f":"IF(K11<'Input Cost'!F27,'Input Cost'!D27,((('Input Cost'!$B$23*(K11-'Input Cost'!F27)+'Input Cost'!$D$23)/K11)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.563125,"d":"0.563"}}]
[null,null,0.3,{"$f":"Constraints!$C$3*C12","v":36},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$20*D12)/D12","v":0.4396762268518517},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$21*D12)/D12","v":1.7596762268518518},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$22*D12)/D12","v":{"v":1.1111111111111112,"d":"1.11"}},{"$f":"IF(D12<'Input Cost'!F28,'Input Cost'!D28,((('Input Cost'!$B$23*(D12-'Input Cost'!F28)+'Input Cost'!$D$23)/D12)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.5454166666666665,"d":"0.545"}},null,0.3,{"$f":"Constraints!$C$3*J12","v":36},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$20*K12)/K12","v":0.18393524537037034},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$21*K12)/K12","v":0.4479352453703703},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$22*K12)/K12","v":{"v":0.2222222222222222,"d":"0.22"}},{"$f":"IF(K12<'Input Cost'!F28,'Input Cost'!D28,((('Input Cost'!$B$23*(K12-'Input Cost'!F28)+'Input Cost'!$D$23)/K12)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.5454166666666665,"d":"0.545"}}]
[null,null,0.4,{"$f":"Constraints!$C$3*C13","v":48},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$20*D13)/D13","v":0.3597571701388887},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$21*D13)/D13","v":1.3497571701388889},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$22*D13)/D13","v":{"v":0.8333333333333334,"d":"0.83"}},{"$f":"IF(D13<'Input Cost'!F29,'Input Cost'!D29,((('Input Cost'!$B$23*(D13-'Input Cost'!F29)+'Input Cost'!$D$23)/D13)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.5365624999999999,"d":"0.537"}},null,0.4,{"$f":"Constraints!$C$3*J13","v":48},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$20*K13)/K13","v":0.16795143402777776},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$21*K13)/K13","v":0.3659514340277778},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$22*K13)/K13","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"IF(K13<'Input Cost'!F29,'Input Cost'!D29,((('Input Cost'!$B$23*(K13-'Input Cost'!F29)+'Input Cost'!$D$23)/K13)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.5365624999999999,"d":"0.537"}}]
[null,null,0.5,{"$f":"Constraints!$C$3*C14","v":60},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$20*D14)/D14","v":0.311805736111111},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$21*D14)/D14","v":1.1038057361111109},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$22*D14)/D14","v":{"v":0.6666666666666666,"d":"0.67"}},{"$f":"IF(D14<'Input Cost'!F30,'Input Cost'!D30,((('Input Cost'!$B$23*(D14-'Input Cost'!F30)+'Input Cost'!$D$23)/D14)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.53125,"d":"0.531"}},null,0.5,{"$f":"Constraints!$C$3*J14","v":60},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$20*K14)/K14","v":0.1583611472222222},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$21*K14)/K14","v":0.3167611472222222},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$22*K14)/K14","v":{"v":0.13333333333333333,"d":"0.13"}},{"$f":"IF(K14<'Input Cost'!F30,'Input Cost'!D30,((('Input Cost'!$B$23*(K14-'Input Cost'!F30)+'Input Cost'!$D$23)/K14)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.53125,"d":"0.531"}}]
[null,null,0.6,{"$f":"Constraints!$C$3*C15","v":72},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$20*D15)/D15","v":0.27983811342592585},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$21*D15)/D15","v":0.9398381134259258},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$22*D15)/D15","v":{"v":0.5555555555555556,"d":"0.56"}},{"$f":"IF(D15<'Input Cost'!F31,'Input Cost'!D31,((('Input Cost'!$B$23*(D15-'Input Cost'!F31)+'Input Cost'!$D$23)/D15)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.5277083333333332,"d":"0.528"}},null,0.6,{"$f":"Constraints!$C$3*J15","v":72},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$20*K15)/K15","v":0.15196762268518518},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$21*K15)/K15","v":0.28396762268518516},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$22*K15)/K15","v":{"v":0.1111111111111111,"d":"0.11"}},{"$f":"IF(K15<'Input Cost'!F31,'Input Cost'!D31,((('Input Cost'!$B$23*(K15-'Input Cost'!F31)+'Input Cost'!$D$23)/K15)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.5277083333333332,"d":"0.528"}}]
[null,null,0.7,{"$f":"Constraints!$C$3*C16","v":84},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$20*D16)/D16","v":0.2570040972222221},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$21*D16)/D16","v":0.822718382936508},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$22*D16)/D16","v":{"v":0.47619047619047616,"d":"0.48"}},{"$f":"IF(D16<'Input Cost'!F32,'Input Cost'!D32,((('Input Cost'!$B$23*(D16-'Input Cost'!F32)+'Input Cost'!$D$23)/D16)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.5251785714285714,"d":"0.525"}},null,0.7,{"$f":"Constraints!$C$3*J16","v":84},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$20*K16)/K16","v":0.14740081944444444},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$21*K16)/K16","v":0.2605436765873016},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$22*K16)/K16","v":{"v":0.09523809523809523,"d":"0.10"}},{"$f":"IF(K16<'Input Cost'!F32,'Input Cost'!D32,((('Input Cost'!$B$23*(K16-'Input Cost'!F32)+'Input Cost'!$D$23)/K16)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.5251785714285714,"d":"0.525"}}]
[null,null,0.8,{"$f":"Constraints!$C$3*C17","v":96},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$20*D17)/D17","v":0.23987858506944437},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$21*D17)/D17","v":0.7348785850694445},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$22*D17)/D17","v":{"v":0.4166666666666667,"d":"0.42"}},{"$f":"IF(D17<'Input Cost'!F33,'Input Cost'!D33,((('Input Cost'!$B$23*(D17-'Input Cost'!F33)+'Input Cost'!$D$23)/D17)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.5232812499999999,"d":"0.523"}},null,0.8,{"$f":"Constraints!$C$3*J17","v":96},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$20*K17)/K17","v":0.14397571701388887},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$21*K17)/K17","v":0.24297571701388887},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$22*K17)/K17","v":{"v":0.08333333333333333,"d":"0.08"}},{"$f":"IF(K17<'Input Cost'!F33,'Input Cost'!D33,((('Input Cost'!$B$23*(K17-'Input Cost'!F33)+'Input Cost'!$D$23)/K17)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.5232812499999999,"d":"0.523"}}]
[null,null,0.9,{"$f":"Constraints!$C$3*C18","v":108},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$20*D18)/D18","v":0.22655874228395056},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$21*D18)/D18","v":0.6665587422839506},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$22*D18)/D18","v":{"v":0.37037037037037035,"d":"0.37"}},{"$f":"IF(D18<'Input Cost'!F34,'Input Cost'!D34,((('Input Cost'!$B$23*(D18-'Input Cost'!F34)+'Input Cost'!$D$23)/D18)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.5218055555555555,"d":"0.522"}},null,0.9,{"$f":"Constraints!$C$3*J18","v":108},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$20*K18)/K18","v":0.1413117484567901},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$21*K18)/K18","v":0.2293117484567901},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$22*K18)/K18","v":{"v":0.07407407407407407,"d":"0.07"}},{"$f":"IF(K18<'Input Cost'!F34,'Input Cost'!D34,((('Input Cost'!$B$23*(K18-'Input Cost'!F34)+'Input Cost'!$D$23)/K18)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.5218055555555555,"d":"0.522"}}]
[null,null,1,{"$f":"Constraints!$C$3*C19","v":120},{"$f":"('Input Cost'!$D$6+'Input Cost'!$B$20*D19)/D19","v":0.2159028680555555},{"$f":"('Input Cost'!$D$7+'Input Cost'!$B$21*D19)/D19","v":0.6119028680555555},{"$f":"('Input Cost'!$D$8+'Input Cost'!$B$22*D19)/D19","v":{"v":0.3333333333333333,"d":"0.33"}},{"$f":"IF(D19<'Input Cost'!F35,'Input Cost'!D35,((('Input Cost'!$B$23*(D19-'Input Cost'!F35)+'Input Cost'!$D$23)/D19)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.520625,"d":"0.521"}},null,1,{"$f":"Constraints!$C$3*J19","v":120},{"$f":"('Input Cost'!$D$6/Constraints!$B$4+'Input Cost'!$B$20*K19)/K19","v":0.13918057361111108},{"$f":"('Input Cost'!$D$7/Constraints!$C$4+'Input Cost'!$B$21*K19)/K19","v":0.2183805736111111},{"$f":"('Input Cost'!$D$8/Constraints!$D$4+'Input Cost'!$B$22*K19)/K19","v":{"v":0.06666666666666667,"d":"0.07"}},{"$f":"IF(K19<'Input Cost'!F35,'Input Cost'!D35,((('Input Cost'!$B$23*(K19-'Input Cost'!F35)+'Input Cost'!$D$23)/K19)*(1-'Input Cost'!$H$23/100)))","v":{"v":0.520625,"d":"0.521"}}]
[]
[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'!A20","v":"Self-Drive"},{"$f":"Solver!B16","v":13},{"$f":"Solver!B21","v":1},{"$f":"Solver!C21","v":13},{"$f":"Solver!D21","v":6},{"$f":"SUM(D26:F26)","v":20},{"$f":"Solver!E21","v":{"v":1470,"d":"1470.00"}}]
[null,{"$f":"'Input Cost'!A21","v":"Core-Drive"},{"$f":"Solver!B17","v":0},{"$f":"Solver!B22","v":0},{"$f":"Solver!C22","v":0},{"$f":"Solver!D22","v":0},{"$f":"SUM(D27:F27)","v":0},{"$f":"Solver!E22","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"'Input Cost'!A22","v":"Outsourced"},{"$f":"Solver!B18","v":0},{"$f":"Solver!B23","v":0},{"$f":"Solver!C23","v":0},{"$f":"Solver!D23","v":0},{"$f":"SUM(D28:F28)","v":0},{"$f":"Solver!E23","v":{"v":0,"d":"0.00"}}]
["Trips",{"$f":"'Input Cost'!A23&\" \"&A29","v":"Taxi  Trips"},{"$f":"SUM(D29:F29)","v":18},{"$f":"Solver!B24","v":18},{"$f":"Solver!C24","v":0},{"$f":"Solver!D24","v":0},{"$f":"SUM(D29:F29)","v":18},{"$f":"Solver!E24","v":{"v":144,"d":"144.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 ",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":"$G$17*'Input Cost'!D10","v":{"v":103.90466666666667,"d":"103.90"}},{"$f":"G6*'Cost Savings Opportunity'!$B$2","v":{"v":25976.166666666668,"d":"25976.17"}},{"$f":"F6-H6","v":{"v":102717.16666666632,"d":"102717.17"}},{"$f":"IF(F6<>0,(F6-H6)/F6*100,0)","v":{"v":79.81545275590545,"d":"79.82"}}]
["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'!D11","v":{"v":7.0584475,"d":"7.06"}},{"$f":"G7*'Cost Savings Opportunity'!$B$2","v":{"v":1764.611875,"d":"1764.61"}},{"$f":"F7-H7","v":{"v":43726.75479166666,"d":"43726.75"}},{"$f":"IF(F7<>0,(F7-H7)/F7*100,0)","v":{"v":96.1209961267376,"d":"96.12"}}]
["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'!D12","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'!D13","v":35.36},{"$f":"G9*'Cost Savings Opportunity'!$B$2","v":{"v":8840,"d":"8840.00"}},{"v":24746.775,"d":"24746.78"},{"v":73.68011665305764,"d":"73.68"}]
["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'!D14","v":{"v":3.28536,"d":"3.29"}},{"$f":"G10*'Cost Savings Opportunity'!$B$2","v":{"v":821.3399999999999,"d":"821.34"}},{"v":2495.585,"d":"2495.59"},{"v":75.23790860510864,"d":"75.24"}]
[]
["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!B8+Solver!B12","v":{"v":0,"d":"0.00"}},{"$f":"G12*'Cost Savings Opportunity'!$B$2","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.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!B13","v":82.62},{"$f":"G13*'Cost Savings Opportunity'!$B$2","v":{"v":20655,"d":"20655.00"}},{"v":90426.47499999996,"d":"90426.48"},{"v":81.40554039276125,"d":"81.41"}]
["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!B10+Solver!B11","v":{"v":176.4,"d":"176.40"}},{"$f":"G14*'Cost Savings Opportunity'!$B$2","v":{"v":44100,"d":"44100.00"}},{"v":-16720.075,"d":"-16720.08"},{"v":-61.066913075912375,"d":"-61.07"}]
[]
["No drivers",20,null,null,{"$f":"B16","v":20},{"$f":"E16","v":20},{"$f":"Solver!B17","v":0},{"$f":"G16","v":0},20,100]
["No vehicles ",57,null,null,{"$f":"B17","v":57},{"$f":"E17","v":57},{"$f":"Solver!B16+Solver!B17","v":13},{"$f":"G17","v":13},44,77.19298245614034]
[]
[]
[]
[]
[]
[]
["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":25976.166666666668,"d":"25976.17"}}]
["Technology",{"$f":"F7","v":{"v":45491.36666666666,"d":"45491.37"}},{"$f":"H7","v":{"v":1764.611875,"d":"1764.61"}}]
["Salary (core drive)",{"v":156950,"d":"156950.00"},{"v":0,"d":"0.00"}]
["Insurance",{"v":33586.775,"d":"33586.78"},{"v":8840,"d":"8840.00"}]
["Other",{"v":3316.9249999999997,"d":"3316.93"},{"v":821.3399999999999,"d":"821.34"}]
[]
[{"$f":"'Input Cost'!A22","v":"Outsourced"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$f":"'Input Cost'!A23","v":"Taxi "},{"v":111081.47499999996,"d":"111081.48"},{"v":20655,"d":"20655.00"}]
["Fuel + M&R",{"v":27379.925,"d":"27379.93"},{"v":44100,"d":"44100.00"}]

{"sheet":"Triangle Analysis","index":6,"n_rows":11,"n_cols":13,"rows_kept":11,"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'!A20","v":"Self-Drive"},{"$f":"SUMPRODUCT(Constraints!B26:D26,DistanceFactorSelfDrive,DistancesTripTypes)","v":{"v":1614,"d":"1614.00"}},{"$f":"C6*'Input Cost'!B20","v":193.68},{"$f":"ROUNDUP((SUMPRODUCT(Constraints!B26:D26,Constraints!B12:D12))/Constraints!B6,0)","v":20},{"$f":"ROUNDUP((C6/Constraints!B3),0)","v":14},{"$f":"Solver!$D$30","v":13},{"$f":"Solver!$D$31","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'!A21","v":"Core-Drive"},{"$f":"SUMPRODUCT(Constraints!B26:D26,DistanceFactorCoreDrive,DistancesTripTypes)","v":{"v":1987,"d":"1987.00"}},{"$f":"C7*'Input Cost'!B21","v":238.44},{"$f":"ROUNDUP((SUMPRODUCT(Constraints!B26:D26,Constraints!B13:D13))/Constraints!C6,0)","v":13},{"$f":"ROUNDUP((C7/Constraints!C3),0)","v":17},{"$f":"Solver!$D$30","v":13},{"$f":"Solver!$D$31","v":0},{"$f":"MAX(E7:H7)","v":17},{"$f":"I7","v":17},{"$f":"I7*'Input Cost'!D7","v":{"v":1003.4818508333333,"d":"1003.48"}},{"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'!A22","v":"Outsourced"},{"$f":"SUMPRODUCT(Constraints!B26:D26,DistanceFactorOutsourced,DistancesTripTypes)","v":{"v":1987,"d":"1987.00"}},{"$f":"C8*'Input Cost'!B22","v":0},{"$f":"ROUNDUP((SUMPRODUCT(Constraints!B26:D26,Constraints!B14:D14))/Constraints!D6,0)","v":13},{"$f":"ROUNDUP((C8/Constraints!D3),0)","v":17},{"$f":"Solver!$D$30","v":13},{"$f":"Solver!$D$31","v":0},{"$f":"MAX(E8:H8)","v":17},0,{"$f":"I8*'Input Cost'!D8","v":{"v":680,"d":"680.00"}},{"v":680,"d":"680.00"},{"$f":"L8*'Cost Savings Opportunity'!$B$2","v":{"v":170000,"d":"170000.00"}}]
[null,{"$f":"'Input Cost'!A23","v":"Taxi "},{"$f":"SUMPRODUCT(Constraints!B26:D26,DistanceFactorTaxi,DistancesTripTypes)","v":{"v":1614,"d":"1614.00"}},{"$f":"((C9-'Input Cost'!F23*'Input Demand'!D5)*'Input Cost'!B23+'Input Cost'!D23*'Input Demand'!D5)*(1-'Input Cost'!H23/100)","v":842.5199999999999},"-","-","-","-","-","-",{"v":0,"d":"0.00"},{"$f":"D9+K9","v":{"v":842.5199999999999,"d":"842.52"}},{"$f":"L9*'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":"L10*'Cost Savings Opportunity'!$B$2","v":{"v":506499.7999999996,"d":"506499.80"}}]
[null,"Optimal Solution",{"$f":"SUM(Solver!E21:E24)","v":{"v":1614,"d":"1614.00"}},{"$f":"Solver!B9","v":259.02},{"$nulls":4},{"$f":"Solver!B16+Solver!B17","v":13},{"$f":"Solver!B17","v":0},{"$f":"Solver!B5","v":{"v":149.60847416666658,"d":"149.61"}},{"v":408.6284741666666,"d":"408.63"},{"$f":"L11*'Cost Savings Opportunity'!$B$2","v":{"v":102157.11854166664,"d":"102157.12"}}]