{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Examples","Description","Inputs and assumptions","Base model","Sim_Template"],"not_rendered":{"charts":19,"images":12,"macros":1,"external_links":0,"defined_names":66,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Examples","index":0,"n_rows":11,"n_cols":27,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[null,"Black","CIE red","CIE grey 40%","CIE grey 70%","CIE grey","CIE grey 25%","CIE red 50%","CIE red 30%",null,null,"Black solid","CIE red  solid","CIE grey 70%","Black dashes","CIE red  dashes","CIE grey 70% dashes",null,"X value","1st Y value","2nd Y value",null,null,"Black","CIE red","CIE red 70%","CIE grey 40%"]
["2003-04",36.19,36.880000000000003,21.56,5.36,3.01,10,3.01,10,null,"2003-04",33.19,36.880000000000003,21.56,5.36,3.01,10,null,1.8,10,17,null,"2003-04",33.19,36.880000000000003,21.56,5.36]
["2004-05",39.39,32.020000000000003,21.6,7.01,3.36,12,3.36,12,null,"2004-05",39.39,32.020000000000003,21.6,7.01,3.36,12,null,2.2999999999999998,12,9,null,"2004-05",39.39,32.020000000000003,21.6,7.01]
["2005-06",42.78,29.91,18.350000000000001,6.33,2.63,14,2.63,14,null,"2005-06",42.78,29.91,18.350000000000001,6.33,2.63,14,null,3.7,16,14,null,"2005-06",42.78,29.91,18.350000000000001,6.33]
["2006-07",42.13,26.53,21.6,7.01,2.72,16,2.72,16,null,"2006-07",42.13,26.53,21.6,7.01,2.72,16,null,4.0999999999999996,8,23,null,"2006-07",42.13,26.53,21.6,7.01]
["2007-08",41.69,24.76,23.98,7,2.57,18,2.57,18,null,"2007-08",41.69,24.76,23.98,7,2.57,18,null,5.5,14,27,null,"2007-08",41.69,24.76,23.98,7]
["2008-09",39.39,32.020000000000003,21.6,7.01,3.36,12,3.36,12,null,"2008-09",39.39,32.020000000000003,21.6,7.01,3.36,12,null,null,null,null,null,"2008-09",39.39,32.020000000000003,21.6,7.01]
["2009-10",42.13,26.53,21.6,7.01,2.72,16,2.72,16,null,"2009-10",42.13,26.53,21.6,7.01,2.72,16,null,null,null,null,null,"2009-10",42.13,26.53,21.6,7.01]
["2010-11",45,22,26,8,2,20,2,20,null,"2010-11",45,22,26,8,2,20,null,null,null,null,null,"2010-11",45,22,26,8]
[]
["–  en rule for when needed"]

{"sheet":"Description","index":1,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[24,1,24,2]]}
[]
[null,"TAXI MODEL",null,null,null,"STEPS TO USE THE MODEL"]
[]
[null,"CONTENTS",null,null,null,"1. On the Sim_Template worksheet, change the inputs in any of the green cells to create a new simulation"]
[null,"Worksheet","Purpose",null,null,"2. Click on the 'Run Model' button"]
[null,"Inputs and assumptions","This worksheet sets out the assumptions and input data that underpin the taxi model",null,null,"3. Results appear in the  'Detailed model outputs' section of Sim_Template and are compared with the base case below the 'detailed model outputs' section."]
[null,"Base model","This worksheet characterises the Sydney taxi industry for the year 2012/13. This is the baseline for the model. Calibration is undertaken of the model against input data.",null,null,"4. If any of the inputs and assumptions are changed on the 'inputs and assumptions' worksheet, the Base model must be run (by clicking on the 'run model' button on the Base model worksheet) before a simulation is run."]
[null,"Sim_Template","This worksheet is used to undertake a simulation."]
[]
[null,"Colour coding"]
[null,"Input data"]
[null,"Assumptions"]
[null,"Simulation inputs"]
[]
[null,"MODEL STRUCTURE"]
[]
[null,"The taxi model is a combination of 3 equations."]
[null,null,"1. A demand equation, linking demand for taxi services to the (real) price of services and waiting time "]
[null,null,"2. A waiting time equation, linking the average waiting time to the number of taxi on the road and the share taken up by demand"]
[null,null,"3. A taxi entry condition, linking the decision of a taxi to drive a shift to the returns available. This is capped by the number of licences available."]
[null,"The model is broken into 14 shifts, for each weekday and weeknight"]
[]
[null,"MODEL EQUATIONS"]
[]
[null,"The model allows for solution of quantity of taxi services (Q), waiting time (W) and number of taxis (T) using 3 options for taxi entry."]
[null,"1. Fixed taxi numbers based on the number of licences available"]
[null,"2. Free entry of taxis but an upward sloping cost curve for additional taxis that enter"]
[null,"3. Free entry of taxis and a flat cost curve."]
[null,"Solutions are obtained for each case and appropriate values then selected by the model."]
[null,"Demand equation"]
[]
[]
[null,"Waiting time equation"]
[]
[]
[]
[null,"Taxi numbers equation"]
[]
[null,"Free entry, upward sloping supply"]
[]
[]
[null,"Free entry, flat supply"]
[]
[]
[null,"Fixed entry"]

{"sheet":"Inputs and assumptions","index":2,"n_rows":62,"n_cols":19,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
["Assumptions and inputs by shift"]
["Day","Description","Unit","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
["Shift",null,null,"Day","Day","Day","Day","Day","Day","Day","Night","Night","Night","Night","Night","Night","Night",null,"DO NOT DELETE"]
["Price elasticity of demand","Impact of a 1% price decrease on demand","Unit",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,"Yes"]
["Weekend labour cost premium applied","Yes if the shift is a weekend","Yes/No","No","No","No","No","No","Yes","Yes","No","No","No","No","Yes","Yes","Yes",null,"No"]
["Revenue per taxi","Revenue per taxi from the CIE survey undertaken in October 2011 (including GST)","$",263.8,259.5,264.10000000000002,268.60000000000002,282.89999999999998,276.2,279,258.89999999999998,283,309.3,341.2,423.4,426.7,275]
["Share of standard taxis on the road","The proportion of non-WAT taxis on the road","Per cent",80.518065433014215,81.276630183628029,82.121630455206969,85.625535154811772,82.280930728691445,59.746869685559147,53.922999863177992,65.297329914753774,73.027474284550891,76.484011037688319,81.351045331315916,87.932783996593372,82.456573317841162,53.534635166327504]
["Share of trips at standard distance rate","The proportion of trips in each shift for which the standard distance rate applies (rather than the night time distance rate)","Per cent",0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.75,0.75,0.75,0.75,0.6,0.4,0.75]
["W_base","Baseline waiting time","Minutes",7.9339933993399336,7.9339933993399336,7.9339933993399336,7.9339933993399336,7.7311320754716979,7.7311320754716979,7.7125000000000004,7.0602836879432624,7.0602836879432624,7.0602836879432624,7.0602836879432624,9.1661129568106308,9.1661129568106308,9.954545454545455]
[]
[null,"Fares (including GST)"]
[null,"Flagfall ($)",3.5,null,null,"Colour coding"]
[null,"Standard distance rate ($/km)",2.14,null,null,"Input data"]
[null,"Night time distance rate ($/km)",2.5680000000000001,null,null,"Assumptions"]
[null,"Waiting time ($/hour when vehicle slower than 26km/hour)",55.3]
[null,"Booking fee ($/booking)",2.4]
[null,"Taxi fare increase July 2012",3.6999999999999998E-2]
[null,"GST",0.1]
[]
[null,"Costs (excluding GST)",null,null,null,"Operator costs (/taxi/yr)",null,"Amount ($)","% Variable"]
[null,"Labour cost ($/hour)",{"$f":"H29","v":10},null,null,"Operator administration",null,9223]
[null,"Weekend labour cost premium ($ per hour)",{"$f":"H30","v":2},null,null,"Maintenance",null,7562,0.5]
[null,"Operator variable costs ($/km)",{"$f":"SUMPRODUCT(H23:H24,I23:I24)/C43","v":9.684579439252336E-2},null,null,"Insurance",null,13163,0.5]
[null,"Operator costs (fixed, non plate, $/year)",{"$f":"SUM(H22:H26) - SUMPRODUCT(H23:H24,I23:I24)","v":32621.5},null,null,"Vehicle lease",null,5805]
[null,"Fuel cost ($/km)",{"$f":"H31/C43","v":0.13658878504672897},null,null,"Network fees",null,7231]
[null,"Cleaning ($/night shift)",{"$f":"H32","v":11}]
[null,"For calculation of peak licence value:",null,null,null,"Driver costs"]
[null,"Annual fixed costs to be apportioned over fewer shifts",{"$f":"H23+H24+H26-SUMPRODUCT(H23:H24,I23:I24)","v":17593.5},null,null,"Labour ($/hr)",null,10]
[null,null,null,null,null,"Weekend labour premium ($/hr)",null,2]
[null,"Current taxi licence numbers",null,null,null,"Fuel ($/taxi/yr)",null,14615]
[null,"Fringe",14,null,null,"Cleaning ($/night shift)",null,11]
[null,"Unrestricted",4729]
[null,"WAT",618]
[null,"PAL",286]
[null,"Unrestricted + fringe",{"$f":"SUM(C32:C33)","v":4743}]
[null,"Total non-PAL",{"$f":"SUM(C32:C34)","v":5361}]
[null,"Total",{"$f":"SUM(C32:C35)","v":5647}]
[]
[null,"Other inputs and assumptions"]
[null,"Hours per shift (no.)",10]
[null,"Average trip length (kms)",7]
[null,"Total km travelled /taxi/year",107000]
[null,"Number of shifts operated per year",552]
[null,"Share of trips with booking fee (per cent)",0.2]
[null,"Speed when on waiting time (km/hour)",{"$f":"26/2","v":13}]
[null,"Average speed (km/hour)",33,null,null,"Meter data"]
[null,"Revenue at waiting time rate/revenue at dist. rate",{"$f":"H50/H51","v":0.38203316814821564},null,null,"Total km",null,5141146]
[null,"Minutes on waiting time rate (/trip)",{"$f":"((C42*C14)*C48/(C16+C48*C46*C14))*60","v":5.2082660470425886},null,null,"Occupied km",null,2577606]
[null,"Kms on distance rate (/trip)",{"$f":"C42-C49/60*C46","v":5.8715423564741061},null,null,"Revenue at time rate ($)",null,1990899]
[null,"Multiplier for occupied to total kms for a trip",{"$f":"H48/H49","v":1.9945429984256708},null,null,"Revenue at distance rate ($)",null,5211325]
[null,"Value of time ($/hour)",30]
[null,"Share of cabs at which constraint on number of cabs becomes binding",0.7]
[null,"Increase in constraint for highest demand shift (%)",0.17]
[null,"Per cent of shifts to which higher constraint not applied",0.25]
[null,"Slope of the supply curve",40]
[null,"Standard deviation of expected shift revenue",{"$f":"12.5240326851699*2","v":25.048065370339799}]
[null,"Calibration constant to account for rising marginal costs",{"$f":"C56*3/4","v":30}]
[null,"Flat or upward sloping cost curve","Upward sloping"]
[null,"For calculation of peak licence value:",null,null,null,null,null,null,null,null,null,"DO NOT DELETE"]
[null,"What revenue premium can peak licences obtain by working across best part of shifts?",7.0000000000000007E-2,null,null,null,null,null,null,null,null,"Flat"]
[null,"Of shifts available, what per cent do peak licences do (%)",0.9,null,null,null,null,null,null,null,null,"Upward sloping"]

{"sheet":"Base model","index":3,"n_rows":69,"n_cols":17,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[]
["CALIBRATION OF MODEL PARAMETERS"]
["Day","Description","Unit","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
["Shift",null,null,"Day","Day","Day","Day","Day","Day","Day","Night","Night","Night","Night","Night","Night","Night"]
["Revenue adjustment for fare increases","Revenue adjustment for price increase from July 2012","Per cent",{"$f":"1+'Inputs and assumptions'!$C$18","v":1.0369999999999999},{"$f":"1+'Inputs and assumptions'!$C$18","v":1.0369999999999999},{"$f":"1+'Inputs and assumptions'!$C$18","v":1.0369999999999999},{"$f":"1+'Inputs and assumptions'!$C$18","v":1.0369999999999999},{"$f":"1+'Inputs and assumptions'!$C$18","v":1.0369999999999999},{"$f":"1+'Inputs and assumptions'!$C$18","v":1.0369999999999999},{"$f":"1+'Inputs and assumptions'!$C$18","v":1.0369999999999999},{"$f":"1+'Inputs and assumptions'!$C$18","v":1.0369999999999999},{"$f":"1+'Inputs and assumptions'!$C$18","v":1.0369999999999999},{"$f":"1+'Inputs and assumptions'!$C$18","v":1.0369999999999999},{"$f":"1+'Inputs and assumptions'!$C$18","v":1.0369999999999999},{"$f":"1+'Inputs and assumptions'!$C$18","v":1.0369999999999999},{"$f":"1+'Inputs and assumptions'!$C$18","v":1.0369999999999999},{"$f":"1+'Inputs and assumptions'!$C$18","v":1.0369999999999999}]
["T_max","The maximum number of taxis, based on the number of taxi plates","No.",{"$f":"'Inputs and assumptions'!$C$37","v":5361},{"$f":"'Inputs and assumptions'!$C$37","v":5361},{"$f":"'Inputs and assumptions'!$C$37","v":5361},{"$f":"'Inputs and assumptions'!$C$37","v":5361},{"$f":"'Inputs and assumptions'!$C$37","v":5361},{"$f":"'Inputs and assumptions'!$C$37","v":5361},{"$f":"'Inputs and assumptions'!$C$37","v":5361},{"$f":"'Inputs and assumptions'!$C$38","v":5647},{"$f":"'Inputs and assumptions'!$C$38","v":5647},{"$f":"'Inputs and assumptions'!$C$38","v":5647},{"$f":"'Inputs and assumptions'!$C$38","v":5647},{"$f":"'Inputs and assumptions'!$C$38","v":5647},{"$f":"'Inputs and assumptions'!$C$38","v":5647},{"$f":"'Inputs and assumptions'!$C$38","v":5647}]
["T_base","The number of taxis actually on the road, based on network data","No.",{"$f":"'Inputs and assumptions'!D8/100*D6","v":4316.5734878638923},{"$f":"'Inputs and assumptions'!E8/100*E6","v":4357.2401441442989},{"$f":"'Inputs and assumptions'!F8/100*F6","v":4402.5406087036454},{"$f":"'Inputs and assumptions'!G8/100*G6","v":4590.3849396494588},{"$f":"'Inputs and assumptions'!H8/100*H6","v":4411.0806963651485},{"$f":"'Inputs and assumptions'!I8/100*I6","v":3203.0296838428258},{"$f":"'Inputs and assumptions'!J8/100*J6","v":2890.8120226649721},{"$f":"'Inputs and assumptions'!K8/100*K6","v":3687.3402202861457},{"$f":"'Inputs and assumptions'!L8/100*L6","v":4123.8614728485882},{"$f":"'Inputs and assumptions'!M8/100*M6","v":4319.0521032982588},{"$f":"'Inputs and assumptions'!N8/100*N6","v":4593.8935298594097},{"$f":"'Inputs and assumptions'!O8/100*O6","v":4965.5643122876272},{"$f":"'Inputs and assumptions'!P8/100*P6","v":4656.322695258491},{"$f":"'Inputs and assumptions'!Q8/100*Q6","v":3023.1008478425142}]
["T_max_effective","The maximum effective number of taxis on the road","No.",{"$f":"('Inputs and assumptions'!$C$53+MAX('Inputs and assumptions'!D8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55))*'Inputs and assumptions'!$C$54)*D6","v":4337.6642218023462},{"$f":"('Inputs and assumptions'!$C$53+MAX('Inputs and assumptions'!E8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55))*'Inputs and assumptions'!$C$54)*E6","v":4371.0572515733766},{"$f":"('Inputs and assumptions'!$C$53+MAX('Inputs and assumptions'!F8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55))*'Inputs and assumptions'!$C$54)*F6","v":4408.2552880001049},{"$f":"('Inputs and assumptions'!$C$53+MAX('Inputs and assumptions'!G8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55))*'Inputs and assumptions'!$C$54)*G6","v":4562.5018356469318},{"$f":"('Inputs and assumptions'!$C$53+MAX('Inputs and assumptions'!H8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55))*'Inputs and assumptions'!$C$54)*H6","v":4415.2678980254141},{"$f":"('Inputs and assumptions'!$C$53+MAX('Inputs and assumptions'!I8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55))*'Inputs and assumptions'!$C$54)*I6","v":3752.7},{"$f":"('Inputs and assumptions'!$C$53+MAX('Inputs and assumptions'!J8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55))*'Inputs and assumptions'!$C$54)*J6","v":3752.7},{"$f":"('Inputs and assumptions'!$C$53+MAX('Inputs and assumptions'!K8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55))*'Inputs and assumptions'!$C$54)*K6","v":3952.8999999999996},{"$f":"('Inputs and assumptions'!$C$53+MAX('Inputs and assumptions'!L8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55))*'Inputs and assumptions'!$C$54)*L6","v":4221.7338896489564},{"$f":"('Inputs and assumptions'!$C$53+MAX('Inputs and assumptions'!M8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55))*'Inputs and assumptions'!$C$54)*M6","v":4382.0127797718314},{"$f":"('Inputs and assumptions'!$C$53+MAX('Inputs and assumptions'!N8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55))*'Inputs and assumptions'!$C$54)*N6","v":4607.6961473982692},{"$f":"('Inputs and assumptions'!$C$53+MAX('Inputs and assumptions'!O8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55))*'Inputs and assumptions'!$C$54)*O6","v":4912.8900000000003},{"$f":"('Inputs and assumptions'!$C$53+MAX('Inputs and assumptions'!P8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55))*'Inputs and assumptions'!$C$54)*P6","v":4658.9592501323023},{"$f":"('Inputs and assumptions'!$C$53+MAX('Inputs and assumptions'!Q8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$55))*'Inputs and assumptions'!$C$54)*Q6","v":3952.8999999999996}]
["Q_base","Baseline quantity of taxis demanded per shift","Kms occupied",{"$f":"D7*'Inputs and assumptions'!D7/D13/$B$20*D5","v":382739.75554274663},{"$f":"E7*'Inputs and assumptions'!E7/E13/$B$20*E5","v":380048.04546140367},{"$f":"F7*'Inputs and assumptions'!F7/F13/$B$20*F5","v":390806.17451837193},{"$f":"G7*'Inputs and assumptions'!G7/G13/$B$20*G5","v":414423.86748389981},{"$f":"H7*'Inputs and assumptions'!H7/H13/$B$20*H5","v":419437.8274824777},{"$f":"I7*'Inputs and assumptions'!I7/I13/$B$20*I5","v":297354.34074494877},{"$f":"J7*'Inputs and assumptions'!J7/J13/$B$20*J5","v":271090.12664977985},{"$f":"K7*'Inputs and assumptions'!K7/K13/$B$20*K5","v":315369.75077283924},{"$f":"L7*'Inputs and assumptions'!L7/L13/$B$20*L5","v":385536.30223147431},{"$f":"M7*'Inputs and assumptions'!M7/M13/$B$20*M5","v":441309.35834851576},{"$f":"N7*'Inputs and assumptions'!N7/N13/$B$20*N5","v":517803.19039193011},{"$f":"O7*'Inputs and assumptions'!O7/O13/$B$20*O5","v":682821.50971912802},{"$f":"P7*'Inputs and assumptions'!P7/P13/$B$20*P5","v":631096.14699429704},{"$f":"Q7*'Inputs and assumptions'!Q7/Q13/$B$20*Q5","v":274637.66803495557}]
[null,"Demand intercept with y axis","Kms occupied",{"$f":"D9+D11*D13+'Inputs and assumptions'!D10*D12","v":750798.82749198494},{"$f":"E9+E11*E13+'Inputs and assumptions'!E10*E12","v":745518.65279428498},{"$f":"F9+F11*F13+'Inputs and assumptions'!F10*F12","v":766622.2631849153},{"$f":"G9+G11*G13+'Inputs and assumptions'!G10*G12","v":812951.74929079122},{"$f":"H9+H11*H13+'Inputs and assumptions'!H10*H12","v":821053.81563191093},{"$f":"I9+I11*I13+'Inputs and assumptions'!I10*I12","v":582074.14798216044},{"$f":"J9+J11*J13+'Inputs and assumptions'!J10*J12","v":530558.77567391854},{"$f":"K9+K11*K13+'Inputs and assumptions'!K10*K12","v":612250.96918227011},{"$f":"L9+L11*L13+'Inputs and assumptions'!L10*L12","v":748470.56230891298},{"$f":"M9+M11*M13+'Inputs and assumptions'!M10*M12","v":856746.98253702791},{"$f":"N9+N11*N13+'Inputs and assumptions'!N10*N12","v":1005250.200395675},{"$f":"O9+O11*O13+'Inputs and assumptions'!O10*O12","v":1352291.5686011398},{"$f":"P9+P11*P13+'Inputs and assumptions'!P10*P12","v":1247347.7342944508},{"$f":"Q9+Q11*Q13+'Inputs and assumptions'!Q10*Q12","v":549091.25587921543}]
[null,"Impact of price on demand kilometres","Change in Q per extra dollar",{"$f":"'Inputs and assumptions'!D$5*D9/D13","v":109168.44791963536},{"$f":"'Inputs and assumptions'!E$5*E9/E13","v":108400.69435451864},{"$f":"'Inputs and assumptions'!F$5*F9/F13","v":111469.22390928862},{"$f":"'Inputs and assumptions'!G$5*G9/G13","v":118205.67301641882},{"$f":"'Inputs and assumptions'!H$5*H9/H13","v":119635.79942228354},{"$f":"'Inputs and assumptions'!I$5*I9/I13","v":84814.058093494634},{"$f":"'Inputs and assumptions'!J$5*J9/J13","v":77322.744617232631},{"$f":"'Inputs and assumptions'!K$5*K9/K13","v":88409.457277497553},{"$f":"'Inputs and assumptions'!L$5*L9/L13","v":108079.65937611237},{"$f":"'Inputs and assumptions'!M$5*M9/M13","v":123714.84826132271},{"$f":"'Inputs and assumptions'!N$5*N9/N13","v":145158.81414410498},{"$f":"'Inputs and assumptions'!O$5*O9/O13","v":188190.99476755087},{"$f":"'Inputs and assumptions'!P$5*P9/P13","v":170109.77098067192},{"$f":"'Inputs and assumptions'!Q$5*Q9/Q13","v":76990.792932506854}]
[null,"Impact of waiting time on demand kilometres","Change in Q per extra minute ",{"$f":"('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$42)/60*D11","v":7797.7462799739542},{"$f":"('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$42)/60*E11","v":7742.9067396084738},{"$f":"('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$42)/60*F11","v":7962.0874220920432},{"$f":"('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$42)/60*G11","v":8443.2623583156292},{"$f":"('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$42)/60*H11","v":8545.4142444488243},{"$f":"('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$42)/60*I11","v":6058.1470066781876},{"$f":"('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$42)/60*J11","v":5523.0531869451879},{"$f":"('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$42)/60*K11","v":6314.9612341069678},{"$f":"('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$42)/60*L11","v":7719.9756697223111},{"$f":"('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$42)/60*M11","v":8836.7748758087637},{"$f":"('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$42)/60*N11","v":10368.486724578926},{"$f":"('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$42)/60*O11","v":13442.21391196792},{"$f":"('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$42)/60*P11","v":12150.697927190851},{"$f":"('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$42)/60*Q11","v":5499.342352321918}]
["P","Price per kilometre of demand (excluding GST)","$/km occupied",{"$f":"(('Inputs and assumptions'!$C$13+'Inputs and assumptions'!$C$45*'Inputs and assumptions'!$C$17)/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$14*'Inputs and assumptions'!D9+'Inputs and assumptions'!$C$15*(1-'Inputs and assumptions'!D9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*'Inputs and assumptions'!$C$16)/'Inputs and assumptions'!$C$42)/$B$20","v":2.804764657454883},{"$f":"(('Inputs and assumptions'!$C$13+'Inputs and assumptions'!$C$45*'Inputs and assumptions'!$C$17)/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$14*'Inputs and assumptions'!E9+'Inputs and assumptions'!$C$15*(1-'Inputs and assumptions'!E9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*'Inputs and assumptions'!$C$16)/'Inputs and assumptions'!$C$42)/$B$20","v":2.804764657454883},{"$f":"(('Inputs and assumptions'!$C$13+'Inputs and assumptions'!$C$45*'Inputs and assumptions'!$C$17)/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$14*'Inputs and assumptions'!F9+'Inputs and assumptions'!$C$15*(1-'Inputs and assumptions'!F9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*'Inputs and assumptions'!$C$16)/'Inputs and assumptions'!$C$42)/$B$20","v":2.804764657454883},{"$f":"(('Inputs and assumptions'!$C$13+'Inputs and assumptions'!$C$45*'Inputs and assumptions'!$C$17)/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$14*'Inputs and assumptions'!G9+'Inputs and assumptions'!$C$15*(1-'Inputs and assumptions'!G9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*'Inputs and assumptions'!$C$16)/'Inputs and assumptions'!$C$42)/$B$20","v":2.804764657454883},{"$f":"(('Inputs and assumptions'!$C$13+'Inputs and assumptions'!$C$45*'Inputs and assumptions'!$C$17)/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$14*'Inputs and assumptions'!H9+'Inputs and assumptions'!$C$15*(1-'Inputs and assumptions'!H9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*'Inputs and assumptions'!$C$16)/'Inputs and assumptions'!$C$42)/$B$20","v":2.804764657454883},{"$f":"(('Inputs and assumptions'!$C$13+'Inputs and assumptions'!$C$45*'Inputs and assumptions'!$C$17)/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$14*'Inputs and assumptions'!I9+'Inputs and assumptions'!$C$15*(1-'Inputs and assumptions'!I9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*'Inputs and assumptions'!$C$16)/'Inputs and assumptions'!$C$42)/$B$20","v":2.804764657454883},{"$f":"(('Inputs and assumptions'!$C$13+'Inputs and assumptions'!$C$45*'Inputs and assumptions'!$C$17)/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$14*'Inputs and assumptions'!J9+'Inputs and assumptions'!$C$15*(1-'Inputs and assumptions'!J9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*'Inputs and assumptions'!$C$16)/'Inputs and assumptions'!$C$42)/$B$20","v":2.804764657454883},{"$f":"(('Inputs and assumptions'!$C$13+'Inputs and assumptions'!$C$45*'Inputs and assumptions'!$C$17)/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$14*'Inputs and assumptions'!K9+'Inputs and assumptions'!$C$15*(1-'Inputs and assumptions'!K9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*'Inputs and assumptions'!$C$16)/'Inputs and assumptions'!$C$42)/$B$20","v":2.8537195950244461},{"$f":"(('Inputs and assumptions'!$C$13+'Inputs and assumptions'!$C$45*'Inputs and assumptions'!$C$17)/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$14*'Inputs and assumptions'!L9+'Inputs and assumptions'!$C$15*(1-'Inputs and assumptions'!L9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*'Inputs and assumptions'!$C$16)/'Inputs and assumptions'!$C$42)/$B$20","v":2.8537195950244461},{"$f":"(('Inputs and assumptions'!$C$13+'Inputs and assumptions'!$C$45*'Inputs and assumptions'!$C$17)/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$14*'Inputs and assumptions'!M9+'Inputs and assumptions'!$C$15*(1-'Inputs and assumptions'!M9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*'Inputs and assumptions'!$C$16)/'Inputs and assumptions'!$C$42)/$B$20","v":2.8537195950244461},{"$f":"(('Inputs and assumptions'!$C$13+'Inputs and assumptions'!$C$45*'Inputs and assumptions'!$C$17)/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$14*'Inputs and assumptions'!N9+'Inputs and assumptions'!$C$15*(1-'Inputs and assumptions'!N9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*'Inputs and assumptions'!$C$16)/'Inputs and assumptions'!$C$42)/$B$20","v":2.8537195950244461},{"$f":"(('Inputs and assumptions'!$C$13+'Inputs and assumptions'!$C$45*'Inputs and assumptions'!$C$17)/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$14*'Inputs and assumptions'!O9+'Inputs and assumptions'!$C$15*(1-'Inputs and assumptions'!O9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*'Inputs and assumptions'!$C$16)/'Inputs and assumptions'!$C$42)/$B$20","v":2.9026745325940095},{"$f":"(('Inputs and assumptions'!$C$13+'Inputs and assumptions'!$C$45*'Inputs and assumptions'!$C$17)/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$14*'Inputs and assumptions'!P9+'Inputs and assumptions'!$C$15*(1-'Inputs and assumptions'!P9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*'Inputs and assumptions'!$C$16)/'Inputs and assumptions'!$C$42)/$B$20","v":2.9679477826867595},{"$f":"(('Inputs and assumptions'!$C$13+'Inputs and assumptions'!$C$45*'Inputs and assumptions'!$C$17)/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$14*'Inputs and assumptions'!Q9+'Inputs and assumptions'!$C$15*(1-'Inputs and assumptions'!Q9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*'Inputs and assumptions'!$C$16)/'Inputs and assumptions'!$C$42)/$B$20","v":2.8537195950244461}]
["c","Variable cost","$/km occupied",{"$f":"('Inputs and assumptions'!C24+'Inputs and assumptions'!C26)*'Inputs and assumptions'!C51*(1+'Inputs and assumptions'!$C$18)","v":0.48282233233340882},{"$f":"D14","v":0.48282233233340882},{"$f":"E14","v":0.48282233233340882},0.48282233233340882,0.48282233233340882,0.48282233233340882,0.48282233233340882,0.48282233233340882,0.48282233233340882,0.48282233233340882,0.48282233233340882,0.48282233233340882,0.48282233233340882,0.48282233233340882]
[null,"Fixed component of shift costs","$/taxi/shift",{"$f":"(('Inputs and assumptions'!$C$22+IF('Inputs and assumptions'!D6=\"Yes\",'Inputs and assumptions'!$C$23,0))*'Inputs and assumptions'!$C$41+'Inputs and assumptions'!$C$27+'Inputs and assumptions'!$C$25/'Inputs and assumptions'!$C$44)*(1+'Inputs and assumptions'!$C$18)-IF('Inputs and assumptions'!$C$59=\"Flat\",0,'Inputs and assumptions'!$C$58)","v":146.39050634057969},{"$f":"(('Inputs and assumptions'!$C$22+IF('Inputs and assumptions'!E6=\"Yes\",'Inputs and assumptions'!$C$23,0))*'Inputs and assumptions'!$C$41+'Inputs and assumptions'!$C$27+'Inputs and assumptions'!$C$25/'Inputs and assumptions'!$C$44)*(1+'Inputs and assumptions'!$C$18)-IF('Inputs and assumptions'!$C$59=\"Flat\",0,'Inputs and assumptions'!$C$58)","v":146.39050634057969},{"$f":"(('Inputs and assumptions'!$C$22+IF('Inputs and assumptions'!F6=\"Yes\",'Inputs and assumptions'!$C$23,0))*'Inputs and assumptions'!$C$41+'Inputs and assumptions'!$C$27+'Inputs and assumptions'!$C$25/'Inputs and assumptions'!$C$44)*(1+'Inputs and assumptions'!$C$18)-IF('Inputs and assumptions'!$C$59=\"Flat\",0,'Inputs and assumptions'!$C$58)","v":146.39050634057969},{"$f":"(('Inputs and assumptions'!$C$22+IF('Inputs and assumptions'!G6=\"Yes\",'Inputs and assumptions'!$C$23,0))*'Inputs and assumptions'!$C$41+'Inputs and assumptions'!$C$27+'Inputs and assumptions'!$C$25/'Inputs and assumptions'!$C$44)*(1+'Inputs and assumptions'!$C$18)-IF('Inputs and assumptions'!$C$59=\"Flat\",0,'Inputs and assumptions'!$C$58)","v":146.39050634057969},{"$f":"(('Inputs and assumptions'!$C$22+IF('Inputs and assumptions'!H6=\"Yes\",'Inputs and assumptions'!$C$23,0))*'Inputs and assumptions'!$C$41+'Inputs and assumptions'!$C$27+'Inputs and assumptions'!$C$25/'Inputs and assumptions'!$C$44)*(1+'Inputs and assumptions'!$C$18)-IF('Inputs and assumptions'!$C$59=\"Flat\",0,'Inputs and assumptions'!$C$58)","v":146.39050634057969},{"$f":"(('Inputs and assumptions'!$C$22+IF('Inputs and assumptions'!I6=\"Yes\",'Inputs and assumptions'!$C$23,0))*'Inputs and assumptions'!$C$41+'Inputs and assumptions'!$C$27+'Inputs and assumptions'!$C$25/'Inputs and assumptions'!$C$44)*(1+'Inputs and assumptions'!$C$18)-IF('Inputs and assumptions'!$C$59=\"Flat\",0,'Inputs and assumptions'!$C$58)","v":167.1305063405797},{"$f":"(('Inputs and assumptions'!$C$22+IF('Inputs and assumptions'!J6=\"Yes\",'Inputs and assumptions'!$C$23,0))*'Inputs and assumptions'!$C$41+'Inputs and assumptions'!$C$27+'Inputs and assumptions'!$C$25/'Inputs and assumptions'!$C$44)*(1+'Inputs and assumptions'!$C$18)-IF('Inputs and assumptions'!$C$59=\"Flat\",0,'Inputs and assumptions'!$C$58)","v":167.1305063405797},{"$f":"(('Inputs and assumptions'!$C$22+IF('Inputs and assumptions'!K6=\"Yes\",'Inputs and assumptions'!$C$23,0))*'Inputs and assumptions'!$C$41+'Inputs and assumptions'!$C$27+'Inputs and assumptions'!$C$25/'Inputs and assumptions'!$C$44)*(1+'Inputs and assumptions'!$C$18)-IF('Inputs and assumptions'!$C$59=\"Flat\",0,'Inputs and assumptions'!$C$58)","v":146.39050634057969},{"$f":"(('Inputs and assumptions'!$C$22+IF('Inputs and assumptions'!L6=\"Yes\",'Inputs and assumptions'!$C$23,0))*'Inputs and assumptions'!$C$41+'Inputs and assumptions'!$C$27+'Inputs and assumptions'!$C$25/'Inputs and assumptions'!$C$44)*(1+'Inputs and assumptions'!$C$18)-IF('Inputs and assumptions'!$C$59=\"Flat\",0,'Inputs and assumptions'!$C$58)","v":146.39050634057969},{"$f":"(('Inputs and assumptions'!$C$22+IF('Inputs and assumptions'!M6=\"Yes\",'Inputs and assumptions'!$C$23,0))*'Inputs and assumptions'!$C$41+'Inputs and assumptions'!$C$27+'Inputs and assumptions'!$C$25/'Inputs and assumptions'!$C$44)*(1+'Inputs and assumptions'!$C$18)-IF('Inputs and assumptions'!$C$59=\"Flat\",0,'Inputs and assumptions'!$C$58)","v":146.39050634057969},{"$f":"(('Inputs and assumptions'!$C$22+IF('Inputs and assumptions'!N6=\"Yes\",'Inputs and assumptions'!$C$23,0))*'Inputs and assumptions'!$C$41+'Inputs and assumptions'!$C$27+'Inputs and assumptions'!$C$25/'Inputs and assumptions'!$C$44)*(1+'Inputs and assumptions'!$C$18)-IF('Inputs and assumptions'!$C$59=\"Flat\",0,'Inputs and assumptions'!$C$58)","v":146.39050634057969},{"$f":"(('Inputs and assumptions'!$C$22+IF('Inputs and assumptions'!O6=\"Yes\",'Inputs and assumptions'!$C$23,0))*'Inputs and assumptions'!$C$41+'Inputs and assumptions'!$C$27+'Inputs and assumptions'!$C$25/'Inputs and assumptions'!$C$44)*(1+'Inputs and assumptions'!$C$18)-IF('Inputs and assumptions'!$C$59=\"Flat\",0,'Inputs and assumptions'!$C$58)","v":167.1305063405797},{"$f":"(('Inputs and assumptions'!$C$22+IF('Inputs and assumptions'!P6=\"Yes\",'Inputs and assumptions'!$C$23,0))*'Inputs and assumptions'!$C$41+'Inputs and assumptions'!$C$27+'Inputs and assumptions'!$C$25/'Inputs and assumptions'!$C$44)*(1+'Inputs and assumptions'!$C$18)-IF('Inputs and assumptions'!$C$59=\"Flat\",0,'Inputs and assumptions'!$C$58)","v":167.1305063405797},{"$f":"(('Inputs and assumptions'!$C$22+IF('Inputs and assumptions'!Q6=\"Yes\",'Inputs and assumptions'!$C$23,0))*'Inputs and assumptions'!$C$41+'Inputs and assumptions'!$C$27+'Inputs and assumptions'!$C$25/'Inputs and assumptions'!$C$44)*(1+'Inputs and assumptions'!$C$18)-IF('Inputs and assumptions'!$C$59=\"Flat\",0,'Inputs and assumptions'!$C$58)","v":167.1305063405797}]
[null,"Variable component of fixed costs","$/additional taxi per shift",{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$56/5000)","v":8.0000000000000002E-3},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$56/5000)","v":8.0000000000000002E-3},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$56/5000)","v":8.0000000000000002E-3},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$56/5000)","v":8.0000000000000002E-3},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$56/5000)","v":8.0000000000000002E-3},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$56/5000)","v":8.0000000000000002E-3},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$56/5000)","v":8.0000000000000002E-3},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$56/5000)","v":8.0000000000000002E-3},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$56/5000)","v":8.0000000000000002E-3},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$56/5000)","v":8.0000000000000002E-3},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$56/5000)","v":8.0000000000000002E-3},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$56/5000)","v":8.0000000000000002E-3},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$56/5000)","v":8.0000000000000002E-3},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$56/5000)","v":8.0000000000000002E-3}]
[null,"Waiting time constant","Unit",{"$f":"'Inputs and assumptions'!D10*(D7-D9*D18)","v":25045.681638838083},{"$f":"D17","v":25045.681638838083},{"$f":"E17","v":25045.681638838083},25045.681638838083,25045.681638838083,25045.681638838083,25045.681638838083,25045.681638838083,25045.681638838083,25045.681638838083,25045.681638838083,25045.681638838083,25045.681638838083,25045.681638838083]
[null,"Constant to link occupied taxi kms to occupied taxis","Unit (inverse of km per shift)",{"$f":"1/'Inputs and assumptions'!C47/'Inputs and assumptions'!C41","v":3.0303030303030303E-3},{"$f":"D18","v":3.0303030303030303E-3},{"$f":"E18","v":3.0303030303030303E-3},3.0303030303030303E-3,3.0303030303030303E-3,3.0303030303030303E-3,3.0303030303030303E-3,3.0303030303030303E-3,3.0303030303030303E-3,3.0303030303030303E-3,3.0303030303030303E-3,3.0303030303030303E-3,3.0303030303030303E-3,3.0303030303030303E-3]
[]
["GST adjustor",{"$f":"(1+'Inputs and assumptions'!$C$19)","v":1.1000000000000001}]
[]
[]
[null,null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
["BASELINE MODEL",null,null,"Day","Day","Day","Day","Day","Day","Day","Night","Night","Night","Night","Night","Night","Night"]
["Q*","Free entry demand","Occupied kilometres",392051.8601625163,388977.21065067238,401263.35979794833,428214.74344505777,432021.50252395455,284367.050695393,253632.7683603047,309925.96209219657,388853.97738140164,451378.35391096631,536986.80225652596,745798.7759505416,686406.35872861755,274856.72346887056]
["W*","Free entry waiting time","Minutes, average",6.7397887810537211,6.7807875698563169,6.6206210730627468,6.3006347074146181,6.2585674131268103,9.8749047563318388,10.873316616930154,7.9223299426750398,6.630531666454762,5.920841334377914,5.2100993385612959,4.4810762029034237,4.6140936353069018,9.9147124309074535]
["T*","Free entry number of taxis on the road","Taxis on the road",4904.1291296922655,4872.343349414251,4998.930332457162,5272.7250975108418,5310.9795331860832,3398.0144405213027,3071.9920133652759,4100.5733059272015,4955.6720690362954,5597.9017452004064,6434.3736844899631,7849.2085709627336,7508.1028811418519,3359.0119276120749]
["Q* zero condition","Zero condition to solve for free entry","Occupied kilometres",{"$f":"D10-D11*D13-D12*D26-D25","v":-5.2386894822120667E-10},-4.1909515857696533E-9,-9.8953023552894592E-10,2.7357600629329681E-9,-2.9103830456733704E-9,4.4819898903369904E-9,-1.0186340659856796E-8,4.4237822294235229E-9,-2.223532646894455E-8,-3.1839590519666672E-8,-5.2386894822120667E-9,3.8999132812023163E-8,7.4505805969238281E-9,-1.57160684466362E-9]
["W* zero condition","Zero condition to solve for free entry","Minutes, average",{"$f":"D17/(D27-D25*D18)-D26","v":-4.1741836387387821E-7},-4.4858085512800017E-7,-1.2741585120323862E-7,-1.9254513006217167E-7,-7.2934132511193184E-8,-3.2830922869209189E-7,-6.0562938131170085E-7,-5.5144548660734927E-7,-6.744321199292358E-7,-3.5581863677691672E-7,-5.1403509004899206E-8,-8.0565153925959976E-7,-8.121536554384079E-7,6.552980380547524E-12]
["T* zero condition","Zero condition to solve for free entry","Taxis on the road",{"$f":"(-D15+SQRT(D15^2+4*D16*(D13-D14)*D25))/(2*D16)-D27","v":5.0394119170960039E-6},5.4153770179254934E-6,1.57056547323009E-6,2.5804638426052406E-6,9.9412045528879389E-7,-9.9892531579826027E-7,-9.9811086329282261E-7,5.2908817451680079E-6,8.283294846478384E-6,5.1257311497465707E-6,8.8620890892343596E-7,1.5625840205757413E-5,1.4579022717953194E-5,-7.2759576141834259E-12]
["Qbar","Fixed taxi numbers demand","Occupied kilometres",{"$f":"((D18*(D10-D11*D13)+D33)-SQRT((D18*(D10-D11*D13)+D33)^2-4*D18*(D33*(D10-D11*D13)-D12*D17)))/(2*D18)","v":383127.61781136639},381179.14358595869,392051.17605632736,417292.40596341959,417557.62307447387,291321.24447013834,266707.93200902198,307597.12968368549,377236.20707218861,431697.33577939006,506497.99073923728,687101.96362832503,631606.51785709127,284804.67556107201]
["Wbar","Fixed taxi numbers waiting time","Minutes, average",{"$f":"D17/(D33-D31*D18)","v":7.8842530955786101},7.7879115514508195,7.7776271762687212,7.5942504945497404,7.9511570332114969,8.7269970269428221,8.5059369799508637,8.2911101017578019,8.1354289363717704,8.1480133975049789,8.1506259869687607,8.8476792570325049,9.1241095372661221,8.1057775701776524]
["Tbar","Fixed taxi numbers","Taxis on the road",{"$f":"D8","v":4337.6642218023462},4371.0572515733766,4408.2552880001049,4562.5018356469318,4415.2678980254141,3752.7,3752.7,3952.8999999999996,4221.7338896489564,4382.0127797718314,4607.6961473982692,4912.8900000000003,4658.9592501323023,3952.8999999999996]
["Q*_flat","Free entry demand, flat cost curve","Occupied kilometres",{"$f":"(D10-D11*D13+SQRT((D10-D11*D13)^2-4*D12*D17/((D13-D14)/D15-D18)))/2","v":407230.2456590134},404076.64625370409,416678.17025240127,444320.0672428353,448295.07317855232,297190.3677992326,265772.3927498564,322730.63427719008,403658.32930932305,467760.22363437561,555499.28540738602,767730.20732226118,706064.90135901538,286248.31514017994]
["W*_flat","Free entry waiting time, flat cost curve","Minutes, average",{"$f":"D17/((D13-D14)/D15-D18)/D34","v":4.7932795011251752},4.8306884519377862,4.6845947978823093,4.3931582943533911,4.354204419235419,7.7581985935894453,8.6753250389645,5.8946576086262912,4.7128634559180123,4.0670123126284166,3.4246427292587347,2.8495420288969742,2.9961995235293002,7.8432662576207175]
["T*_flat","Free entry number of taxis on the road, flat cost curve","Taxis on the road",{"$f":"(D13-D14)*D34/D15","v":6459.1971645033273},{"$f":"(E13-E14)*E34/E15","v":6409.177008697392},6609.053439656207,7047.4895935650839,7110.5383168427888,4128.8625800322143,3692.3729909436875,5226.8497221682755,6537.530690653949,7575.7059766591483,8996.7018225560678,11115.826021668816,10498.740740920508,4060.6910232940063]
["Q","Equilibrium demand","Occupied kilometres",{"$f":"IF(D39=D$33,D31,IF('Inputs and assumptions'!$C$59=\"Flat\",D34,D25))","v":383127.61781136639},{"$f":"IF(E39=E$33,E31,IF('Inputs and assumptions'!$C$59=\"Flat\",E34,E25))","v":381179.14358595869},{"$f":"IF(F39=F$33,F31,IF('Inputs and assumptions'!$C$59=\"Flat\",F34,F25))","v":392051.17605632736},{"$f":"IF(G39=G$33,G31,IF('Inputs and assumptions'!$C$59=\"Flat\",G34,G25))","v":417292.40596341959},{"$f":"IF(H39=H$33,H31,IF('Inputs and assumptions'!$C$59=\"Flat\",H34,H25))","v":417557.62307447387},{"$f":"IF(I39=I$33,I31,IF('Inputs and assumptions'!$C$59=\"Flat\",I34,I25))","v":284367.050695393},{"$f":"IF(J39=J$33,J31,IF('Inputs and assumptions'!$C$59=\"Flat\",J34,J25))","v":253632.7683603047},{"$f":"IF(K39=K$33,K31,IF('Inputs and assumptions'!$C$59=\"Flat\",K34,K25))","v":307597.12968368549},{"$f":"IF(L39=L$33,L31,IF('Inputs and assumptions'!$C$59=\"Flat\",L34,L25))","v":377236.20707218861},{"$f":"IF(M39=M$33,M31,IF('Inputs and assumptions'!$C$59=\"Flat\",M34,M25))","v":431697.33577939006},{"$f":"IF(N39=N$33,N31,IF('Inputs and assumptions'!$C$59=\"Flat\",N34,N25))","v":506497.99073923728},{"$f":"IF(O39=O$33,O31,IF('Inputs and assumptions'!$C$59=\"Flat\",O34,O25))","v":687101.96362832503},{"$f":"IF(P39=P$33,P31,IF('Inputs and assumptions'!$C$59=\"Flat\",P34,P25))","v":631606.51785709127},{"$f":"IF(Q39=Q$33,Q31,IF('Inputs and assumptions'!$C$59=\"Flat\",Q34,Q25))","v":274856.72346887056}]
["W","Equilibrium waiting time","Minutes, average",{"$f":"IF(D39=D$33,D32,IF('Inputs and assumptions'!$C$59=\"Flat\",D35,D26))","v":7.8842530955786101},{"$f":"IF(E39=E$33,E32,IF('Inputs and assumptions'!$C$59=\"Flat\",E35,E26))","v":7.7879115514508195},{"$f":"IF(F39=F$33,F32,IF('Inputs and assumptions'!$C$59=\"Flat\",F35,F26))","v":7.7776271762687212},{"$f":"IF(G39=G$33,G32,IF('Inputs and assumptions'!$C$59=\"Flat\",G35,G26))","v":7.5942504945497404},{"$f":"IF(H39=H$33,H32,IF('Inputs and assumptions'!$C$59=\"Flat\",H35,H26))","v":7.9511570332114969},{"$f":"IF(I39=I$33,I32,IF('Inputs and assumptions'!$C$59=\"Flat\",I35,I26))","v":9.8749047563318388},{"$f":"IF(J39=J$33,J32,IF('Inputs and assumptions'!$C$59=\"Flat\",J35,J26))","v":10.873316616930154},{"$f":"IF(K39=K$33,K32,IF('Inputs and assumptions'!$C$59=\"Flat\",K35,K26))","v":8.2911101017578019},{"$f":"IF(L39=L$33,L32,IF('Inputs and assumptions'!$C$59=\"Flat\",L35,L26))","v":8.1354289363717704},{"$f":"IF(M39=M$33,M32,IF('Inputs and assumptions'!$C$59=\"Flat\",M35,M26))","v":8.1480133975049789},{"$f":"IF(N39=N$33,N32,IF('Inputs and assumptions'!$C$59=\"Flat\",N35,N26))","v":8.1506259869687607},{"$f":"IF(O39=O$33,O32,IF('Inputs and assumptions'!$C$59=\"Flat\",O35,O26))","v":8.8476792570325049},{"$f":"IF(P39=P$33,P32,IF('Inputs and assumptions'!$C$59=\"Flat\",P35,P26))","v":9.1241095372661221},{"$f":"IF(Q39=Q$33,Q32,IF('Inputs and assumptions'!$C$59=\"Flat\",Q35,Q26))","v":9.9147124309074535}]
["T","Equilibrium number of taxis on the road","Taxis on the road",{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(D36,D33),MIN(D27,D33))","v":4337.6642218023462},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(E36,E33),MIN(E27,E33))","v":4371.0572515733766},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(F36,F33),MIN(F27,F33))","v":4408.2552880001049},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(G36,G33),MIN(G27,G33))","v":4562.5018356469318},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(H36,H33),MIN(H27,H33))","v":4415.2678980254141},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(I36,I33),MIN(I27,I33))","v":3398.0144405213027},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(J36,J33),MIN(J27,J33))","v":3071.9920133652759},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(K36,K33),MIN(K27,K33))","v":3952.8999999999996},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(L36,L33),MIN(L27,L33))","v":4221.7338896489564},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(M36,M33),MIN(M27,M33))","v":4382.0127797718314},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(N36,N33),MIN(N27,N33))","v":4607.6961473982692},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(O36,O33),MIN(O27,O33))","v":4912.8900000000003},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(P36,P33),MIN(P27,P33))","v":4658.9592501323023},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(Q36,Q33),MIN(Q27,Q33))","v":3359.0119276120749}]
[]
[]
[]
["MODEL OUTPUTS"]
[null,null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
[null,null,null,"Day","Day","Day","Day","Day","Day","Day","Night","Night","Night","Night","Night","Night","Night"]
["Revenue per taxi (excluding GST)",null,null,{"$f":"D37*D13/D39","v":247.7330532711685},{"$f":"E37*E13/E39","v":244.59020519669116},{"$f":"F37*F13/F39","v":249.44364849052789},256.52745669625767,265.25023864891892,234.72020719628225,{"$f":"J37*J13/J39","v":231.56968558981632},222.06379021771588,254.99626082877504,281.13636544383598,313.69326335227584,405.95929709789442,402.35921019296876,233.51034009127102]
["Cost per taxi",null,null,{"$f":"D15+D16*D39+D14*D37/D39","v":223.73748389949594},{"$f":"E15+E16*E39+E14*E37/E39","v":223.46360690315331},224.5966804769744,227.05008522321475,227.37378495590229,234.72020726139687,231.56968566008783,215.5847968242598,223.30733011657759,229.01221940610952,236.32600517742955,273.95970012401324,269.85751396793751,{"$f":"Q15+Q16*Q39+Q14*Q37/Q39","v":233.5103400912715}]
["Surplus per taxi for average shift",null,null,{"$f":"D46-D47","v":23.995569371672559},21.126598293537853,{"$f":"F46-F47","v":24.846968013553493},29.477371473042922,37.876453693016629,-6.5114619474115898E-8,-7.0271511276587262E-8,6.4789933934560793,31.688930712197447,52.124146037726462,77.367258174846285,131.99959697388118,132.50169622503125,{"$f":"Q46-Q47","v":-4.8316906031686813E-13}]
["Share of taxis on the road",null,null,{"$f":"D39/D6*100","v":80.911475877678527},{"$f":"E39/E6*100","v":81.534363953989484},{"$f":"F39/F6*100","v":82.228227718711153},85.105425026057304,82.35903559084899,63.383966433898578,57.302593049156428,70,74.760649719301512,77.598951297535535,81.595469229648828,87.000000000000014,82.503262796746995,59.483122500656535]
["Free market taxis on the road as a proportion of maximum",null,null,{"$f":"D27/D33*100","v":113.05921525789626},{"$f":"E27/E33*100","v":111.46830318135126},{"$f":"F27/F33*100","v":113.3992930505853},115.56653098339422,120.28668827912452,90.548523476997971,81.860847213080618,103.73582195166084,117.38475703518031,127.74727109517663,139.64405374523503,159.76764330084191,161.15407922764385,84.975889286652205]
["Average surplus accruing to shift (adjusted for distribution)",null,null,{"$f":"D48*D52+_xlfn.NORM.DIST(-1*(D50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":32.73666328841211},{"$f":"E48*E52+_xlfn.NORM.DIST(-1*(E50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":30.760892078712985},{"$f":"F48*F52+_xlfn.NORM.DIST(-1*(F50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":33.334732029277632},{"$f":"G48*G52+_xlfn.NORM.DIST(-1*(G50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":36.680137980452457},{"$f":"H48*H52+_xlfn.NORM.DIST(-1*(H50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":43.13566900265662},{"$f":"I48*I52+_xlfn.NORM.DIST(-1*(I50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":17.032548784335383},{"$f":"J48*J52+_xlfn.NORM.DIST(-1*(J50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":14.070812538608701},{"$f":"K48*K52+_xlfn.NORM.DIST(-1*(K50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":21.710590185529778},{"$f":"L48*L52+_xlfn.NORM.DIST(-1*(L50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":38.336977916694991},{"$f":"M48*M52+_xlfn.NORM.DIST(-1*(M50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":55.042545161161136},{"$f":"N48*N52+_xlfn.NORM.DIST(-1*(N50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":78.204117853815774},{"$f":"O48*O52+_xlfn.NORM.DIST(-1*(O50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":131.93714450142573},{"$f":"P48*P52+_xlfn.NORM.DIST(-1*(P50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":132.46121011006159},{"$f":"Q48*Q52+_xlfn.NORM.DIST(-1*(Q50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":15.27824190154937}]
["Percentage of shifts where surplus accrues",null,{"$f":"STDEV(D50:Q50)/STDEV(D48:Q48)","v":0.54637025569584585},{"$f":"(1-_xlfn.NORM.DIST(-1*(D50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.6989441620155602},{"$f":"(1-_xlfn.NORM.DIST(-1*(E50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.67647056074724132},{"$f":"(1-_xlfn.NORM.DIST(-1*(F50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.70365544383695577},{"$f":"(1-_xlfn.NORM.DIST(-1*(G50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.73285360196562488},{"$f":"(1-_xlfn.NORM.DIST(-1*(H50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.79100415876230123},{"$f":"(1-_xlfn.NORM.DIST(-1*(I50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.35296285496262025},{"$f":"(1-_xlfn.NORM.DIST(-1*(J50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.23447951935505895},{"$f":"(1-_xlfn.NORM.DIST(-1*(K50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.55928083579155985},{"$f":"(1-_xlfn.NORM.DIST(-1*(L50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.75617641685134751},{"$f":"(1-_xlfn.NORM.DIST(-1*(M50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.86601748631243392},{"$f":"(1-_xlfn.NORM.DIST(-1*(N50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.94325725884373557},{"$f":"(1-_xlfn.NORM.DIST(-1*(O50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.99148636004845614},{"$f":"(1-_xlfn.NORM.DIST(-1*(P50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.99268618126216157},{"$f":"(1-_xlfn.NORM.DIST(-1*(Q50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.27431602658917942}]
["Surplus (basic)",null,"$/taxi",{"$f":"SUMPRODUCT(D49:Q49,D48:Q48)*365/7/100","v":24471.338359249163}]
["Surplus accounting for shift variation",null,"$/taxi",{"$f":"SUMPRODUCT(D49:Q49,D51:Q51)*365/7/100","v":28580.578378451421}]
["Occupancy rate of taxis (time)",null,null,{"$f":"D37*D18/D39","v":0.2676539081589307},0.26425833555052763,0.26950205675958744,0.27715549228575642,0.28657969567250607,0.25359466550953952,0.25019080232061436,0.23580472923498857,0.27077500650471564,0.29853261743662607,0.33310408218783139,0.42380903348336224,0.41081259617523747,0.24795957262914198]
["Revenue per taxi (including GST)",null,null,{"$f":"D46*$B$20","v":272.50635859828537},{"$f":"E46*$B$20","v":269.0492257163603},274.38801333958071,282.18020236588347,291.77526251381084,258.19222791591051,254.72665414879796,244.27016923948747,280.49588691165258,309.25000198821959,345.06258968750342,446.55522680768388,442.5951312122657,256.86137410039817]
["Occupied kms per shift",null,null,{"$f":"D46/D13","v":88.325789692447131},{"$f":"E46/E13","v":87.205250731674127},88.935678730663838,91.461312454299616,94.571299571926986,83.686239618148036,82.562964765802747,77.815560647546235,89.355752146556171,98.515763754086592,109.92434712198435,139.85698104950956,135.56815673782836,81.826658967616851]
[]
["MODEL VALIDATION"]
[]
["Model validation"]
[null,"Model","Data","Difference (per cent)"]
["Average occupancy",{"$f":"SUMPRODUCT(D55:Q55,D49:Q49)/SUM(D49:Q49)","v":0.29609935768025997},0.3,{"$f":"B63/C63*100-100","v":-1.3002141065800146}]
["Kilometres per year",{"$f":"'Inputs and assumptions'!C51*B65","v":108305.80022746009},107000,{"$f":"B64/C64*100-100","v":1.2203740443552249}]
["Occupied kilometres per taxi per year",{"$f":"SUMPRODUCT(D57:Q57,D49:Q49)/100*365/7","v":54301.060600321893},"NA"]
["Average revenue per taxi per year (excluding GST)",{"$f":"B67+B68","v":158841.73697790367},{"$f":"152556*(1+'Inputs and assumptions'!C18)","v":158200.57199999999},{"$f":"B66/C66*100-100","v":0.40528613126863888}]
["Average cost per taxi per year (excluding plate lease costs)",{"$f":"SUMPRODUCT(D47:Q47,D49:Q49)/100*365/7","v":130261.15859945225},{"$f":"(C66)-C68","v":130045.57199999999},{"$f":"B67/C67*100-100","v":0.16577773171104582}]
["Plate lease costs",{"$f":"D54","v":28580.578378451421},28155,{"$f":"B68/C68*100-100","v":1.5115552422355591}]
[{"$f":"\"Peak plate lease costs driving \"&'Inputs and assumptions'!C62*100&\"% of peak days\"","v":"Peak plate lease costs driving 90% of peak days"},{"$f":"(SUM($K$51:$Q$51)+'Inputs and assumptions'!$C$61*SUM('Base model'!$K$46:$Q$46))*365/7*'Inputs and assumptions'!$C$62-('Inputs and assumptions'!C29*(1-'Inputs and assumptions'!$C$62*365/'Inputs and assumptions'!C44))","v":22015.955466965977},{"$f":"26786.36/34651.92*C68","v":21764.160998871059},{"$f":"B69/C69*100-100","v":1.1569224658280177}]

{"sheet":"Sim_Template","index":4,"n_rows":96,"n_cols":17,"rows_kept":96,"cut":false,"hidden":false,"merged":[[94,3,94,9],[94,10,94,16]]}
["Flagfall ($)",3.5,"Change in unrestricted licences (No.)",0,"Change in costs (% real)",null,0]
["Standard distance rate ($/km)",2.14,"Change in peak availability licences (No.)",250,"Change in value of time (% nominal)",null,0]
["Night time distance rate ($/km)",2.5680000000000001,"Change in demand (%)",2.5000000000000001E-2]
["Waiting time ($/hour when vehicle slower than 26km/hour)",55.3]
["Booking fee ($/booking)",2.4,"CPI (%)",2.5000000000000001E-2]
["CALIBRATION OF MODEL PARAMETERS"]
["Day","Description","Unit","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
["Shift",null,null,"Day","Day","Day","Day","Day","Day","Day","Night","Night","Night","Night","Night","Night","Night"]
["Additional peak flagfall (nominal, including GST)",null,"$/trip"]
[null,"Demand intercept with y axis","Kms occupied",{"$f":"'Base model'!D10*(1+$D$3)","v":769568.79817928444},{"$f":"'Base model'!E10*(1+$D$3)","v":764156.61911414203},{"$f":"'Base model'!F10*(1+$D$3)","v":785787.81976453809},{"$f":"'Base model'!G10*(1+$D$3)","v":833275.54302306089},{"$f":"'Base model'!H10*(1+$D$3)","v":841580.16102270863},{"$f":"'Base model'!I10*(1+$D$3)","v":596626.00168171444},{"$f":"'Base model'!J10*(1+$D$3)","v":543822.7450657665},{"$f":"'Base model'!K10*(1+$D$3)","v":627557.24341182678},{"$f":"'Base model'!L10*(1+$D$3)","v":767182.32636663574},{"$f":"'Base model'!M10*(1+$D$3)","v":878165.65710045351},{"$f":"'Base model'!N10*(1+$D$3)","v":1030381.4554055668},{"$f":"'Base model'!O10*(1+$D$3)","v":1386098.8578161681},{"$f":"'Base model'!P10*(1+$D$3)","v":1278531.4276518121},{"$f":"'Base model'!Q10*(1+$D$3)","v":562818.53727619571}]
[null,"Impact of price on demand kilometres","Change in Q per extra dollar",{"$f":"'Base model'!D11*(1+$D$3)","v":111897.65911762624},{"$f":"'Base model'!E11*(1+$D$3)","v":111110.71171338159},{"$f":"'Base model'!F11*(1+$D$3)","v":114255.95450702083},{"$f":"'Base model'!G11*(1+$D$3)","v":121160.81484182928},{"$f":"'Base model'!H11*(1+$D$3)","v":122626.69440784062},{"$f":"'Base model'!I11*(1+$D$3)","v":86934.409545831993},{"$f":"'Base model'!J11*(1+$D$3)","v":79255.813232663437},{"$f":"'Base model'!K11*(1+$D$3)","v":90619.693709434985},{"$f":"'Base model'!L11*(1+$D$3)","v":110781.65086051516},{"$f":"'Base model'!M11*(1+$D$3)","v":126807.71946785577},{"$f":"'Base model'!N11*(1+$D$3)","v":148787.78449770759},{"$f":"'Base model'!O11*(1+$D$3)","v":192895.76963673963},{"$f":"'Base model'!P11*(1+$D$3)","v":174362.51525518871},{"$f":"'Base model'!Q11*(1+$D$3)","v":78915.562755819512}]
[null,"Impact of waiting time on demand kilometres","Change in Q per extra minute",{"$f":"'Base model'!D12*(1+$G$2)/(1+$D$5)*(1+$D$3)","v":7797.7462799739542},{"$f":"'Base model'!E12*(1+$G$2)/(1+$D$5)*(1+$D$3)","v":7742.9067396084738},{"$f":"'Base model'!F12*(1+$G$2)/(1+$D$5)*(1+$D$3)","v":7962.0874220920432},{"$f":"'Base model'!G12*(1+$G$2)/(1+$D$5)*(1+$D$3)","v":8443.2623583156292},{"$f":"'Base model'!H12*(1+$G$2)/(1+$D$5)*(1+$D$3)","v":8545.4142444488243},{"$f":"'Base model'!I12*(1+$G$2)/(1+$D$5)*(1+$D$3)","v":6058.1470066781876},{"$f":"'Base model'!J12*(1+$G$2)/(1+$D$5)*(1+$D$3)","v":5523.0531869451879},{"$f":"'Base model'!K12*(1+$G$2)/(1+$D$5)*(1+$D$3)","v":6314.9612341069678},{"$f":"'Base model'!L12*(1+$G$2)/(1+$D$5)*(1+$D$3)","v":7719.9756697223111},{"$f":"'Base model'!M12*(1+$G$2)/(1+$D$5)*(1+$D$3)","v":8836.7748758087637},{"$f":"'Base model'!N12*(1+$G$2)/(1+$D$5)*(1+$D$3)","v":10368.486724578926},{"$f":"'Base model'!O12*(1+$G$2)/(1+$D$5)*(1+$D$3)","v":13442.21391196792},{"$f":"'Base model'!P12*(1+$G$2)/(1+$D$5)*(1+$D$3)","v":12150.697927190851},{"$f":"'Base model'!Q12*(1+$G$2)/(1+$D$5)*(1+$D$3)","v":5499.342352321918}]
["P","Price per kilometre of demand (excluding GST)","$/km occupied",{"$f":"(($B$1+D9+'Inputs and assumptions'!$C$45*$B$5)/'Inputs and assumptions'!$C$42+($B$2*'Inputs and assumptions'!D9+$B$3*(1-'Inputs and assumptions'!D9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*$B$4)/'Inputs and assumptions'!$C$42)/$B$20/(1+$D$5)","v":2.7363557633706179},{"$f":"(($B$1+E9+'Inputs and assumptions'!$C$45*$B$5)/'Inputs and assumptions'!$C$42+($B$2*'Inputs and assumptions'!E9+$B$3*(1-'Inputs and assumptions'!E9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*$B$4)/'Inputs and assumptions'!$C$42)/$B$20/(1+$D$5)","v":2.7363557633706179},{"$f":"(($B$1+F9+'Inputs and assumptions'!$C$45*$B$5)/'Inputs and assumptions'!$C$42+($B$2*'Inputs and assumptions'!F9+$B$3*(1-'Inputs and assumptions'!F9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*$B$4)/'Inputs and assumptions'!$C$42)/$B$20/(1+$D$5)","v":2.7363557633706179},{"$f":"(($B$1+G9+'Inputs and assumptions'!$C$45*$B$5)/'Inputs and assumptions'!$C$42+($B$2*'Inputs and assumptions'!G9+$B$3*(1-'Inputs and assumptions'!G9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*$B$4)/'Inputs and assumptions'!$C$42)/$B$20/(1+$D$5)","v":2.7363557633706179},{"$f":"(($B$1+H9+'Inputs and assumptions'!$C$45*$B$5)/'Inputs and assumptions'!$C$42+($B$2*'Inputs and assumptions'!H9+$B$3*(1-'Inputs and assumptions'!H9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*$B$4)/'Inputs and assumptions'!$C$42)/$B$20/(1+$D$5)","v":2.7363557633706179},{"$f":"(($B$1+I9+'Inputs and assumptions'!$C$45*$B$5)/'Inputs and assumptions'!$C$42+($B$2*'Inputs and assumptions'!I9+$B$3*(1-'Inputs and assumptions'!I9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*$B$4)/'Inputs and assumptions'!$C$42)/$B$20/(1+$D$5)","v":2.7363557633706179},{"$f":"(($B$1+J9+'Inputs and assumptions'!$C$45*$B$5)/'Inputs and assumptions'!$C$42+($B$2*'Inputs and assumptions'!J9+$B$3*(1-'Inputs and assumptions'!J9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*$B$4)/'Inputs and assumptions'!$C$42)/$B$20/(1+$D$5)","v":2.7363557633706179},{"$f":"(($B$1+K9+'Inputs and assumptions'!$C$45*$B$5)/'Inputs and assumptions'!$C$42+($B$2*'Inputs and assumptions'!K9+$B$3*(1-'Inputs and assumptions'!K9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*$B$4)/'Inputs and assumptions'!$C$42)/$B$20/(1+$D$5)","v":2.7841166780726305},{"$f":"(($B$1+L9+'Inputs and assumptions'!$C$45*$B$5)/'Inputs and assumptions'!$C$42+($B$2*'Inputs and assumptions'!L9+$B$3*(1-'Inputs and assumptions'!L9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*$B$4)/'Inputs and assumptions'!$C$42)/$B$20/(1+$D$5)","v":2.7841166780726305},{"$f":"(($B$1+M9+'Inputs and assumptions'!$C$45*$B$5)/'Inputs and assumptions'!$C$42+($B$2*'Inputs and assumptions'!M9+$B$3*(1-'Inputs and assumptions'!M9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*$B$4)/'Inputs and assumptions'!$C$42)/$B$20/(1+$D$5)","v":2.7841166780726305},{"$f":"(($B$1+N9+'Inputs and assumptions'!$C$45*$B$5)/'Inputs and assumptions'!$C$42+($B$2*'Inputs and assumptions'!N9+$B$3*(1-'Inputs and assumptions'!N9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*$B$4)/'Inputs and assumptions'!$C$42)/$B$20/(1+$D$5)","v":2.7841166780726305},{"$f":"(($B$1+O9+'Inputs and assumptions'!$C$45*$B$5)/'Inputs and assumptions'!$C$42+($B$2*'Inputs and assumptions'!O9+$B$3*(1-'Inputs and assumptions'!O9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*$B$4)/'Inputs and assumptions'!$C$42)/$B$20/(1+$D$5)","v":2.8318775927746436},{"$f":"(($B$1+P9+'Inputs and assumptions'!$C$45*$B$5)/'Inputs and assumptions'!$C$42+($B$2*'Inputs and assumptions'!P9+$B$3*(1-'Inputs and assumptions'!P9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*$B$4)/'Inputs and assumptions'!$C$42)/$B$20/(1+$D$5)","v":2.8955588123773266},{"$f":"(($B$1+Q9+'Inputs and assumptions'!$C$45*$B$5)/'Inputs and assumptions'!$C$42+($B$2*'Inputs and assumptions'!Q9+$B$3*(1-'Inputs and assumptions'!Q9))*'Inputs and assumptions'!$C$50/'Inputs and assumptions'!$C$42+('Inputs and assumptions'!$C$49/60*$B$4)/'Inputs and assumptions'!$C$42)/$B$20/(1+$D$5)","v":2.7841166780726305}]
["c","Variable cost","$/km occupied",{"$f":"'Base model'!D14*(1+$G$1)","v":0.48282233233340882},{"$f":"'Base model'!E14*(1+$G$1)","v":0.48282233233340882},{"$f":"'Base model'!F14*(1+$G$1)","v":0.48282233233340882},{"$f":"'Base model'!G14*(1+$G$1)","v":0.48282233233340882},{"$f":"'Base model'!H14*(1+$G$1)","v":0.48282233233340882},{"$f":"'Base model'!I14*(1+$G$1)","v":0.48282233233340882},{"$f":"'Base model'!J14*(1+$G$1)","v":0.48282233233340882},{"$f":"'Base model'!K14*(1+$G$1)","v":0.48282233233340882},{"$f":"'Base model'!L14*(1+$G$1)","v":0.48282233233340882},{"$f":"'Base model'!M14*(1+$G$1)","v":0.48282233233340882},{"$f":"'Base model'!N14*(1+$G$1)","v":0.48282233233340882},{"$f":"'Base model'!O14*(1+$G$1)","v":0.48282233233340882},{"$f":"'Base model'!P14*(1+$G$1)","v":0.48282233233340882},{"$f":"'Base model'!Q14*(1+$G$1)","v":0.48282233233340882}]
[null,"Fixed component of shift costs","$/taxi/shift",{"$f":"'Base model'!D15*(1+$G$1)","v":146.39050634057969},{"$f":"'Base model'!E15*(1+$G$1)","v":146.39050634057969},{"$f":"'Base model'!F15*(1+$G$1)","v":146.39050634057969},{"$f":"'Base model'!G15*(1+$G$1)","v":146.39050634057969},{"$f":"'Base model'!H15*(1+$G$1)","v":146.39050634057969},{"$f":"'Base model'!I15*(1+$G$1)","v":167.1305063405797},{"$f":"'Base model'!J15*(1+$G$1)","v":167.1305063405797},{"$f":"'Base model'!K15*(1+$G$1)","v":146.39050634057969},{"$f":"'Base model'!L15*(1+$G$1)","v":146.39050634057969},{"$f":"'Base model'!M15*(1+$G$1)","v":146.39050634057969},{"$f":"'Base model'!N15*(1+$G$1)","v":146.39050634057969},{"$f":"'Base model'!O15*(1+$G$1)","v":167.1305063405797},{"$f":"'Base model'!P15*(1+$G$1)","v":167.1305063405797},{"$f":"'Base model'!Q15*(1+$G$1)","v":167.1305063405797}]
[null,"Variable component of fixed costs","$/additional taxi per shift",{"$f":"'Base model'!D16*(1+$G$1)","v":8.0000000000000002E-3},{"$f":"'Base model'!E16*(1+$G$1)","v":8.0000000000000002E-3},{"$f":"'Base model'!F16*(1+$G$1)","v":8.0000000000000002E-3},{"$f":"'Base model'!G16*(1+$G$1)","v":8.0000000000000002E-3},{"$f":"'Base model'!H16*(1+$G$1)","v":8.0000000000000002E-3},{"$f":"'Base model'!I16*(1+$G$1)","v":8.0000000000000002E-3},{"$f":"'Base model'!J16*(1+$G$1)","v":8.0000000000000002E-3},{"$f":"'Base model'!K16*(1+$G$1)","v":8.0000000000000002E-3},{"$f":"'Base model'!L16*(1+$G$1)","v":8.0000000000000002E-3},{"$f":"'Base model'!M16*(1+$G$1)","v":8.0000000000000002E-3},{"$f":"'Base model'!N16*(1+$G$1)","v":8.0000000000000002E-3},{"$f":"'Base model'!O16*(1+$G$1)","v":8.0000000000000002E-3},{"$f":"'Base model'!P16*(1+$G$1)","v":8.0000000000000002E-3},{"$f":"'Base model'!Q16*(1+$G$1)","v":8.0000000000000002E-3}]
[null,"Waiting time constant","Unit",{"$f":"'Base model'!D17","v":25045.681638838083},{"$f":"'Base model'!E17","v":25045.681638838083},{"$f":"'Base model'!F17","v":25045.681638838083},{"$f":"'Base model'!G17","v":25045.681638838083},{"$f":"'Base model'!H17","v":25045.681638838083},{"$f":"'Base model'!I17","v":25045.681638838083},{"$f":"'Base model'!J17","v":25045.681638838083},{"$f":"'Base model'!K17","v":25045.681638838083},{"$f":"'Base model'!L17","v":25045.681638838083},{"$f":"'Base model'!M17","v":25045.681638838083},{"$f":"'Base model'!N17","v":25045.681638838083},{"$f":"'Base model'!O17","v":25045.681638838083},{"$f":"'Base model'!P17","v":25045.681638838083},{"$f":"'Base model'!Q17","v":25045.681638838083}]
[null,"Constant to link occupied taxi kms to occupied taxis","Unit",{"$f":"'Base model'!D18","v":3.0303030303030303E-3},{"$f":"'Base model'!E18","v":3.0303030303030303E-3},{"$f":"'Base model'!F18","v":3.0303030303030303E-3},{"$f":"'Base model'!G18","v":3.0303030303030303E-3},{"$f":"'Base model'!H18","v":3.0303030303030303E-3},{"$f":"'Base model'!I18","v":3.0303030303030303E-3},{"$f":"'Base model'!J18","v":3.0303030303030303E-3},{"$f":"'Base model'!K18","v":3.0303030303030303E-3},{"$f":"'Base model'!L18","v":3.0303030303030303E-3},{"$f":"'Base model'!M18","v":3.0303030303030303E-3},{"$f":"'Base model'!N18","v":3.0303030303030303E-3},{"$f":"'Base model'!O18","v":3.0303030303030303E-3},{"$f":"'Base model'!P18","v":3.0303030303030303E-3},{"$f":"'Base model'!Q18","v":3.0303030303030303E-3}]
[]
["GST adjustor",{"$f":"(1+'Inputs and assumptions'!$C$19)","v":1.1000000000000001}]
[]
[]
[null,null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
["SIMULATION MODEL",null,null,"Day","Day","Day","Day","Day","Day","Day","Night","Night","Night","Night","Night","Night","Night"]
["Q*","Free entry demand","Occupied kilometres",411006.0511403532,407803.13101414515,420602.19320063456,448681.70665956184,452691.35483743605,299368.06333007826,267459.66557953798,325552.16272296623,407774.74312762846,472940.1793509681,562186.53369835217,779472.00752627791,717526.89024411002,288957.95332558139]
["W*","Free entry waiting time","Minutes, average",6.7161639689702595,6.7565132178677416,6.5988583349916361,6.2836780529649374,6.2417739706344424,9.8007634496521518,10.771393313217439,7.8716682854863764,6.6034588235512111,5.9046418862060683,5.2034950544701548,4.4910490868487871,4.61929184221,9.8467136710957242]
["T*","Free entry number of taxis on the road","Taxis on the road",4974.6376234583786,4942.661708506681,5070.0089494257445,5345.4733125398498,5384.3825895482669,3462.6586768937136,3135.6873592956799,4168.2718631307853,5028.493614811232,5674.8458456110739,6516.8382162327516,7938.8366822107355,7596.2987743695276,3419.1875931367445]
["Q* zero condition","Zero condition to solve for free entry","Occupied kilometres",{"$f":"D10-D11*D13-D12*D26-D25","v":9.3132257461547852E-10},-7.9162418842315674E-9,1.8044374883174896E-9,6.28642737865448E-9,9.3132257461547852E-10,5.9953890740871429E-9,-1.0477378964424133E-9,-6.5192580223083496E-9,-6.4028427004814148E-10,-1.1059455573558807E-9,-1.5366822481155396E-8,1.8277205526828766E-8,3.3644028007984161E-8,5.9371814131736755E-9]
["W* zero condition","Zero condition to solve for free entry","Minutes, average",{"$f":"D17/(D27-D25*D18)-D26","v":-6.1800332851191797E-8},-2.768305682465666E-7,-1.1147118961218894E-7,-5.0740051094066985E-7,-4.8733208490858715E-7,-2.8239591998158176E-8,-2.3080083622062375E-8,-5.3907683650322724E-8,-6.8084897719700166E-9,-2.7446005468334533E-7,-5.6847431029183326E-7,-4.0112723009855245E-7,-4.8351277115443736E-7,-3.7571030730987331E-8]
["T* zero condition","Zero condition to solve for free entry","Taxis on the road",{"$f":"(-D15+SQRT(D15^2+4*D16*(D13-D14)*D25))/(2*D16)-D27","v":7.3714454629225656E-7},3.2182551876758225E-6,1.3601065802504309E-6,6.5487884057802148E-6,6.3957586462493055E-6,1.9776371118496172E-7,1.4130046110949479E-7,5.1100960263283923E-7,8.2471160567365587E-8,3.7857807910768315E-6,9.3528478828375228E-6,7.6787773650721647E-6,8.5696938185719773E-6,2.4199789550038986E-7]
["Qbar","Fixed taxi numbers demand","Occupied kilometres",{"$f":"((D18*(D10-D11*D13)+D33)-SQRT((D18*(D10-D11*D13)+D33)^2-4*D18*(D33*(D10-D11*D13)-D12*D17)))/(2*D18)","v":400840.90799758874},398799.04891471687,410144.12318330724,436466.29214926227,436802.30639065464,305092.95864420495,279352.5038630378,324942.89094857126,398358.84217339824,455839.50515621348,534763.06466562278,725063.82289012801,666685.45669539156,300305.49101274874]
["Wbar","Fixed taxi numbers waiting time","Minutes, average",{"$f":"D17/(D33-D31*D18)","v":8.0197641090352452},7.9193946010775349,7.9123417800881617,7.7304428213574701,8.1011394726759676,8.8557722984288656,8.6180846484354436,7.968148968708582,7.8231389568913663,7.8398133073506431,7.8483814068542328,8.53861037344066,8.8035316162051043,7.7832782709755008]
["Tbar","Fixed taxi numbers","Taxis on the road",{"$f":"'Base model'!D8/'Base model'!D6*('Base model'!D6+$D$1)","v":4337.6642218023462},{"$f":"'Base model'!E8/'Base model'!E6*('Base model'!E6+$D$1)","v":4371.0572515733766},{"$f":"'Base model'!F8/'Base model'!F6*('Base model'!F6+$D$1)","v":4408.2552880001049},{"$f":"'Base model'!G8/'Base model'!G6*('Base model'!G6+$D$1)","v":4562.5018356469318},{"$f":"'Base model'!H8/'Base model'!H6*('Base model'!H6+$D$1)","v":4415.2678980254141},{"$f":"'Base model'!I8/'Base model'!I6*('Base model'!I6+$D$1)","v":3752.7},{"$f":"'Base model'!J8/'Base model'!J6*('Base model'!J6+$D$1)","v":3752.7},{"$f":"'Base model'!K8/'Base model'!K6*('Base model'!K6+$D$1+$D$2)","v":4127.8999999999996},{"$f":"'Base model'!L8/'Base model'!L6*('Base model'!L6+$D$1+$D$2)","v":4408.6355139472098},{"$f":"'Base model'!M8/'Base model'!M6*('Base model'!M6+$D$1+$D$2)","v":4576.0101580156706},{"$f":"'Base model'!N8/'Base model'!N6*('Base model'!N6+$D$1+$D$2)","v":4811.6848204723919},{"$f":"'Base model'!O8/'Base model'!O6*('Base model'!O6+$D$1+$D$2)","v":5130.3900000000003},{"$f":"'Base model'!P8/'Base model'!P6*('Base model'!P6+$D$1+$D$2)","v":4865.2174071241698},{"$f":"'Base model'!Q8/'Base model'!Q6*('Base model'!Q6+$D$1+$D$2)","v":4127.8999999999996}]
["Q*_flat","Free entry demand, flat cost curve","Occupied kilometres",{"$f":"(D10-D11*D13+SQRT((D10-D11*D13)^2-4*D12*D17/((D13-D14)/D15-D18)))/2","v":426324.840531767},423041.01589518157,436163.22231645847,464949.89386697899,469130.02530866617,312258.72315753857,279627.21025989123,338434.15000904805,422707.97360626841,489487.36935668899,580911.66767806374,801753.70536819135,737475.60950109747,300415.95835571282]
["W*_flat","Free entry waiting time, flat cost curve","Minutes, average",{"$f":"D17/((D13-D14)/D15-D18)/D34","v":4.7516489871537404},4.78853331142051,4.6444676970986549,4.3569124833283892,4.3180906943195589,7.6729412272392015,8.5683465076725245,5.8317527882204532,4.6690964476167078,4.0321046496831618,3.3975291042666282,2.8334577118106865,2.9775162523228964,7.7631908976339563]
["T*_flat","Free entry number of taxis on the road, flat cost curve","Taxis on the road",{"$f":"(D13-D14)*D34/D15","v":6562.8387020178361},6512.2875509548558,6714.2906152145042,7157.4322391423611,7221.7811247733453,4210.3951407562345,3770.4024258995137,5320.2671080931095,6645.0721011635351,7694.8604357621462,9132.0726297050387,11268.820997499224,10646.376566106854,4136.5610711727441]
["Q","Equilibrium demand","Occupied kilometres",{"$f":"IF(D39=D$33,D31,IF('Inputs and assumptions'!$C$59=\"Flat\",D34,D25))","v":400840.90799758874},{"$f":"IF(E39=E$33,E31,IF('Inputs and assumptions'!$C$59=\"Flat\",E34,E25))","v":398799.04891471687},{"$f":"IF(F39=F$33,F31,IF('Inputs and assumptions'!$C$59=\"Flat\",F34,F25))","v":410144.12318330724},{"$f":"IF(G39=G$33,G31,IF('Inputs and assumptions'!$C$59=\"Flat\",G34,G25))","v":436466.29214926227},{"$f":"IF(H39=H$33,H31,IF('Inputs and assumptions'!$C$59=\"Flat\",H34,H25))","v":436802.30639065464},{"$f":"IF(I39=I$33,I31,IF('Inputs and assumptions'!$C$59=\"Flat\",I34,I25))","v":299368.06333007826},{"$f":"IF(J39=J$33,J31,IF('Inputs and assumptions'!$C$59=\"Flat\",J34,J25))","v":267459.66557953798},{"$f":"IF(K39=K$33,K31,IF('Inputs and assumptions'!$C$59=\"Flat\",K34,K25))","v":324942.89094857126},{"$f":"IF(L39=L$33,L31,IF('Inputs and assumptions'!$C$59=\"Flat\",L34,L25))","v":398358.84217339824},{"$f":"IF(M39=M$33,M31,IF('Inputs and assumptions'!$C$59=\"Flat\",M34,M25))","v":455839.50515621348},{"$f":"IF(N39=N$33,N31,IF('Inputs and assumptions'!$C$59=\"Flat\",N34,N25))","v":534763.06466562278},{"$f":"IF(O39=O$33,O31,IF('Inputs and assumptions'!$C$59=\"Flat\",O34,O25))","v":725063.82289012801},{"$f":"IF(P39=P$33,P31,IF('Inputs and assumptions'!$C$59=\"Flat\",P34,P25))","v":666685.45669539156},{"$f":"IF(Q39=Q$33,Q31,IF('Inputs and assumptions'!$C$59=\"Flat\",Q34,Q25))","v":288957.95332558139}]
["W","Equilibrium waiting time","Minutes, average",{"$f":"IF(D39=D$33,D32,IF('Inputs and assumptions'!$C$59=\"Flat\",D35,D26))","v":8.0197641090352452},{"$f":"IF(E39=E$33,E32,IF('Inputs and assumptions'!$C$59=\"Flat\",E35,E26))","v":7.9193946010775349},{"$f":"IF(F39=F$33,F32,IF('Inputs and assumptions'!$C$59=\"Flat\",F35,F26))","v":7.9123417800881617},{"$f":"IF(G39=G$33,G32,IF('Inputs and assumptions'!$C$59=\"Flat\",G35,G26))","v":7.7304428213574701},{"$f":"IF(H39=H$33,H32,IF('Inputs and assumptions'!$C$59=\"Flat\",H35,H26))","v":8.1011394726759676},{"$f":"IF(I39=I$33,I32,IF('Inputs and assumptions'!$C$59=\"Flat\",I35,I26))","v":9.8007634496521518},{"$f":"IF(J39=J$33,J32,IF('Inputs and assumptions'!$C$59=\"Flat\",J35,J26))","v":10.771393313217439},{"$f":"IF(K39=K$33,K32,IF('Inputs and assumptions'!$C$59=\"Flat\",K35,K26))","v":7.968148968708582},{"$f":"IF(L39=L$33,L32,IF('Inputs and assumptions'!$C$59=\"Flat\",L35,L26))","v":7.8231389568913663},{"$f":"IF(M39=M$33,M32,IF('Inputs and assumptions'!$C$59=\"Flat\",M35,M26))","v":7.8398133073506431},{"$f":"IF(N39=N$33,N32,IF('Inputs and assumptions'!$C$59=\"Flat\",N35,N26))","v":7.8483814068542328},{"$f":"IF(O39=O$33,O32,IF('Inputs and assumptions'!$C$59=\"Flat\",O35,O26))","v":8.53861037344066},{"$f":"IF(P39=P$33,P32,IF('Inputs and assumptions'!$C$59=\"Flat\",P35,P26))","v":8.8035316162051043},{"$f":"IF(Q39=Q$33,Q32,IF('Inputs and assumptions'!$C$59=\"Flat\",Q35,Q26))","v":9.8467136710957242}]
["T","Equilibrium number of taxis on the road","Taxis on the road",{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(D36,D33),MIN(D27,D33))","v":4337.6642218023462},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(E36,E33),MIN(E27,E33))","v":4371.0572515733766},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(F36,F33),MIN(F27,F33))","v":4408.2552880001049},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(G36,G33),MIN(G27,G33))","v":4562.5018356469318},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(H36,H33),MIN(H27,H33))","v":4415.2678980254141},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(I36,I33),MIN(I27,I33))","v":3462.6586768937136},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(J36,J33),MIN(J27,J33))","v":3135.6873592956799},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(K36,K33),MIN(K27,K33))","v":4127.8999999999996},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(L36,L33),MIN(L27,L33))","v":4408.6355139472098},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(M36,M33),MIN(M27,M33))","v":4576.0101580156706},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(N36,N33),MIN(N27,N33))","v":4811.6848204723919},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(O36,O33),MIN(O27,O33))","v":5130.3900000000003},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(P36,P33),MIN(P27,P33))","v":4865.2174071241698},{"$f":"IF('Inputs and assumptions'!$C$59=\"Flat\",MIN(Q36,Q33),MIN(Q27,Q33))","v":3419.1875931367445}]
[]
[]
[]
["DETAILED MODEL OUTPUTS"]
[null,null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
[null,null,null,"Day","Day","Day","Day","Day","Day","Day","Night","Night","Night","Night","Night","Night","Night"]
["Revenue per taxi (excluding GST)",null,null,{"$f":"D37*D13/D39","v":252.86496895745503},{"$f":"E37*E13/E39","v":249.65494916171716},{"$f":"F37*F13/F39","v":254.59057199801734},261.77020789522385,270.70758471534236,236.57472534868168,{"$f":"J37*J13/J39","v":233.39852272202739},219.1620247852548,251.56933315171338,277.339936976915,309.4223380588391,400.22142437009194,396.78123045260156,235.28766269809918]
["Cost per taxi",null,null,{"$f":"D15+D16*D39+D14*D37/D39","v":225.70913768450393},{"$f":"E15+E16*E39+E14*E37/E39","v":225.40988289467975},226.57834405131712,229.07914313521695,229.47824681378677,236.57472533597206,233.39852271223535,217.4208490724651,225.2868181227866,231.09496096255376,238.54409768420399,276.40957059791475,272.21385775144847,{"$f":"Q15+Q16*Q39+Q14*Q37/Q39","v":235.28766268239826}]
["Surplus per taxi",null,null,{"$f":"D46-D47","v":27.155831272951104},24.245066267037402,28.012227946700222,32.691064760006896,41.229337901555596,1.2709620023088064E-8,9.7920462849288015E-9,1.7411757127896976,26.282515028926781,46.244976014361242,70.878240374635112,123.81185377217719,124.56737270115309,{"$f":"Q46-Q47","v":1.5700919675509795E-8}]
["Share of taxis on the road",null,null,{"$f":"D39/('Base model'!D6+$D$1)*100","v":80.911475877678527},{"$f":"E39/('Base model'!E6+$D$1)*100","v":81.534363953989484},{"$f":"F39/('Base model'!F6+$D$1)*100","v":82.228227718711153},{"$f":"G39/('Base model'!G6+$D$1)*100","v":85.105425026057304},{"$f":"H39/('Base model'!H6+$D$1)*100","v":82.35903559084899},{"$f":"I39/('Base model'!I6+$D$1)*100","v":64.589790652746018},{"$f":"J39/('Base model'!J6+$D$1)*100","v":58.490717390331646},{"$f":"K39/('Base model'!K6+$D$1+$D$2)*100","v":70},{"$f":"L39/('Base model'!L6+$D$1+$D$2)*100","v":74.760649719301512},{"$f":"M39/('Base model'!M6+$D$1+$D$2)*100","v":77.598951297535535},{"$f":"N39/('Base model'!N6+$D$1+$D$2)*100","v":81.595469229648842},{"$f":"O39/('Base model'!O6+$D$1+$D$2)*100","v":87.000000000000014},{"$f":"P39/('Base model'!P6+$D$1+$D$2)*100","v":82.503262796746995},{"$f":"Q39/('Base model'!Q6+$D$1+$D$2)*100","v":57.981814365554428}]
["Free market taxis on the road as a proportion of maximum",null,null,{"$f":"D27/D33*100","v":114.68470976740019},{"$f":"E27/E33*100","v":113.07702974440687},{"$f":"F27/F33*100","v":115.01169097958157},117.1610117671744,121.94917078431997,92.271129503922879,83.558167700473803,100.9780242527868,114.06008954251337,124.01296434341613,135.43776160286728,154.7413877348649,156.13482684753649,82.831163379363474]
["Average surplus accruing to shift (adjusted for distribution)",null,null,{"$f":"D48*D52+_xlfn.NORM.DIST(-1*(D50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":34.984934881813217},{"$f":"E48*E52+_xlfn.NORM.DIST(-1*(E50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":32.911128660952407},{"$f":"F48*F52+_xlfn.NORM.DIST(-1*(F50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":35.6061799245538},{"$f":"G48*G52+_xlfn.NORM.DIST(-1*(G50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":39.091741118893992},{"$f":"H48*H52+_xlfn.NORM.DIST(-1*(H50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":45.835919221187694},{"$f":"I48*I52+_xlfn.NORM.DIST(-1*(I50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":17.439039584202014},{"$f":"J48*J52+_xlfn.NORM.DIST(-1*(J50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":14.744624782240827},{"$f":"K48*K52+_xlfn.NORM.DIST(-1*(K50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":19.173072029009642},{"$f":"L48*L52+_xlfn.NORM.DIST(-1*(L50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":34.355323101995886},{"$f":"M48*M52+_xlfn.NORM.DIST(-1*(M50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":49.987171824986149},{"$f":"N48*N52+_xlfn.NORM.DIST(-1*(N50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":72.032464566816003},{"$f":"O48*O52+_xlfn.NORM.DIST(-1*(O50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":123.70454506766001},{"$f":"P48*P52+_xlfn.NORM.DIST(-1*(P50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":124.49351000053173},{"$f":"Q48*Q52+_xlfn.NORM.DIST(-1*(Q50-100)/'Inputs and assumptions'!$C$57,0,1,FALSE)*'Inputs and assumptions'!$C$57/$C$52","v":14.460278322976999}]
["Percentage of shifts where surplus accrues",null,{"$f":"'Base model'!C52","v":0.54637025569584585},{"$f":"(1-_xlfn.NORM.DIST(-1*(D50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.72115001187477556},{"$f":"(1-_xlfn.NORM.DIST(-1*(E50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.69919179191187253},{"$f":"(1-_xlfn.NORM.DIST(-1*(F50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.72551870535975038},{"$f":"(1-_xlfn.NORM.DIST(-1*(G50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.75336692268161454},{"$f":"(1-_xlfn.NORM.DIST(-1*(H50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.80956164733779679},{"$f":"(1-_xlfn.NORM.DIST(-1*(I50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.37882752712283896},{"$f":"(1-_xlfn.NORM.DIST(-1*(J50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.25577977182312506},{"$f":"(1-_xlfn.NORM.DIST(-1*(K50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.51557310316074823},{"$f":"(1-_xlfn.NORM.DIST(-1*(L50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.71271178477298625},{"$f":"(1-_xlfn.NORM.DIST(-1*(M50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.83113885508189678},{"$f":"(1-_xlfn.NORM.DIST(-1*(N50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.92143501536461947},{"$f":"(1-_xlfn.NORM.DIST(-1*(O50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.9855722022715111},{"$f":"(1-_xlfn.NORM.DIST(-1*(P50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.98748969354951388},{"$f":"(1-_xlfn.NORM.DIST(-1*(Q50-100)/'Inputs and assumptions'!$C$57,0,1,TRUE))","v":0.24653453153913596}]
["Surplus (basic)",null,"$/taxi",{"$f":"SUMPRODUCT(D49:Q49,D48:Q48)*365/7/100","v":23549.146577139323}]
["Surplus accounting for shift variation",null,"$/taxi",{"$f":"SUMPRODUCT(D49:Q49,D51:Q51)*365/7/100","v":27672.995497053787}]
["Occupancy rate of taxis (time)",null,null,{"$f":"D37*D18/D39","v":0.28002845680613864},{"$f":"E37*E18/E39","v":0.27647360738028215},0.28193942912666575,0.28989032232082335,0.29978777806232559,0.26198826801459285,0.25847086849613582,0.23854149255478152,0.27381442688267332,0.30186380407986346,0.33678310109914439,0.42826434241199102,0.41524536122984479,0.25609304483623624]
["Revenue per taxi (including GST)",null,null,{"$f":"D46*$B$20","v":278.15146585320053},{"$f":"E46*$B$20","v":274.62044407788892},280.04962919781912,287.94722868474628,297.77834318687661,260.23219788354987,256.73837499423013,241.07822726378029,276.72626646688474,305.07393067460652,340.36457186472302,440.24356680710116,436.45935349786174,258.81642896790913]
["Occupied kms per shift",null,null,{"$f":"D46/D13","v":92.409390746025764},{"$f":"E46/E13","v":91.236290435493103},93.040011611799699,95.663806365871707,98.929966760567439,86.456128444815633,85.295386603724822,78.718692543077907,90.3587608712822,99.615055346354964,111.13842336271765,141.32723299595702,137.03096920584881,84.510704795957949]
[]
["Comparison of simulation to baseline"]
[]
[]
[null,"Simulation","Baseline","Difference (per cent)"]
["Average occupancy",{"$f":"SUMPRODUCT(D55:Q55,D49:Q49)/SUM(D49:Q49)","v":0.3039620887030236},{"$f":"'Base model'!B63","v":0.29609935768025997},{"$f":"B63/C63*100-100","v":2.6554367035318336}]
["Kilometres per year",{"$f":"'Inputs and assumptions'!C51*B65","v":111274.91330756094},{"$f":"'Base model'!B64","v":108305.80022746009},2.7414165020388737]
["Occupied kilometres per taxi per year",{"$f":"SUMPRODUCT(D57:Q57,D49:Q49)/100*365/7","v":55789.678836401254},{"$f":"'Base model'!B65","v":54301.060600321893},2.7414165020389021]
["Average revenue per taxi per year (excluding GST, real)",{"$f":"B67+B68","v":159181.01083481501},{"$f":"'Base model'!B66","v":158841.73697790367},0.21359238658951085]
["Average cost per taxi per year (excluding plate lease costs)",{"$f":"SUMPRODUCT(D47:Q47,D49:Q49)/100*365/7","v":131508.01533776123},{"$f":"'Base model'!B67","v":130261.15859945225},0.95719764181050948]
["Plate lease costs",{"$f":"D54","v":27672.995497053787},{"$f":"'Base model'!B68","v":28580.578378451421},-3.1755231450526225]
["Average waiting time",{"$f":"AVERAGE(D38:Q38)","v":8.4945412748321623},{"$f":"AVERAGE('Base model'!D38:Q38)","v":8.5967928837236265},-1.1894157539267667]
["Total occupied kms (million)",{"$f":"SUM(D37:Q37)*365/7/1000000","v":315.17707990585996},{"$f":"SUM('Base model'!D37:Q37)*365/7/1000000","v":299.60251480403593},5.1984093364540058]
["Ave waiting time Fri and Sat nights",{"$f":"AVERAGE(O38:P38)","v":8.6710709948228821},{"$f":"AVERAGE('Base model'!O38:P38)","v":8.9858943971493126},-3.5035288465698642]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Baseline data"]
["Baseline taxis on the road",null,"No.",{"$f":"'Base model'!D39","v":4337.6642218023462},{"$f":"'Base model'!E39","v":4371.0572515733766},{"$f":"'Base model'!F39","v":4408.2552880001049},{"$f":"'Base model'!G39","v":4562.5018356469318},{"$f":"'Base model'!H39","v":4415.2678980254141},{"$f":"'Base model'!I39","v":3398.0144405213027},{"$f":"'Base model'!J39","v":3071.9920133652759},{"$f":"'Base model'!K39","v":3952.8999999999996},{"$f":"'Base model'!L39","v":4221.7338896489564},{"$f":"'Base model'!M39","v":4382.0127797718314},{"$f":"'Base model'!N39","v":4607.6961473982692},{"$f":"'Base model'!O39","v":4912.8900000000003},{"$f":"'Base model'!P39","v":4658.9592501323023},{"$f":"'Base model'!Q39","v":3359.0119276120749}]
["Additional taxis on the road",null,"No.",{"$f":"D39-D91","v":0},{"$f":"E39-E91","v":0},0,0,0,64.644236372410887,63.695345930404073,175,186.90162429825341,193.99737824383919,203.98867307412274,217.5,206.25815699186751,60.175665524669512]
["Baseline revenue per taxi",null,"$/taxi",{"$f":"'Base model'!D56","v":272.50635859828537},{"$f":"'Base model'!E56","v":269.0492257163603},{"$f":"'Base model'!F56","v":274.38801333958071},{"$f":"'Base model'!G56","v":282.18020236588347},{"$f":"'Base model'!H56","v":291.77526251381084},{"$f":"'Base model'!I56","v":258.19222791591051},{"$f":"'Base model'!J56","v":254.72665414879796},{"$f":"'Base model'!K56","v":244.27016923948747},{"$f":"'Base model'!L56","v":280.49588691165258},{"$f":"'Base model'!M56","v":309.25000198821959},{"$f":"'Base model'!N56","v":345.06258968750342},{"$f":"'Base model'!O56","v":446.55522680768388},{"$f":"'Base model'!P56","v":442.5951312122657},{"$f":"'Base model'!Q56","v":256.86137410039817}]
["Simulation revenue per taxi",null,"$/taxi",{"$f":"D56","v":278.15146585320053},{"$f":"E56","v":274.62044407788892},280.04962919781912,287.94722868474628,297.77834318687661,260.23219788354987,256.73837499423013,241.07822726378029,276.72626646688474,305.07393067460652,340.36457186472302,440.24356680710116,436.45935349786174,258.81642896790913]
["Headings for charts",null,null,"Day",null,null,null,null,null,null,"Night"]
[null,null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]