{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Examples","Description","Inputs and assumptions","Base model","Sim_template"],"not_rendered":{"charts":19,"images":17,"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":74,"n_cols":6,"rows_kept":74,"cut":false,"hidden":false,"merged":[[53,1,53,2],[7,1,8,2],[7,5,8,5],[32,1,33,1],[41,1,42,2],[51,1,52,2],[30,1,30,2],[9,5,10,5],[27,1,27,2],[28,1,28,2],[29,1,29,2],[2,1,4,3],[12,2,13,2],[14,2,15,2],[16,2,18,2],[22,1,23,2]]}
[]
[]
[null,"Taxi model - 2013 fare review"]
[]
[]
[]
[]
[null,"Contents",null,null,null,"Installing solver and enabling macros"]
[]
[null,null,null,null,null,"For Microsoft 2010:"]
[null,"Worksheet","Purpose"]
[null,null,null,null,null,"Install Solver"]
[null,"Sim_Template","This worksheet should be copied and used to undertake a simulation, to model industry outcomes with different fares and licence numbers",null,null,"1. Go to the File menu and scroll down to Options."]
[null,null,null,null,null,"2. Choose Add-ins"]
[null,"Inputs and assumptions","This worksheet sets out the assumptions and input data that underpin the taxi model",null,null,"3. Choose Manage: Excel Add-ins and select Go…"]
[null,null,null,null,null,"4. Check if Solver Add-in is ticked. If not tick it. Select OK."]
[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,null,null,null,"Enable macros"]
[null,null,null,null,null,"1.  Go to the File menu and scroll down to Options"]
[null,null,null,null,null,"2. Choose Trust Center"]
[null,null,null,null,null,"3. Select Trust Center Settings"]
[null,null,null,null,null,"4. Select Macro Settings"]
[null,"Steps to use the model",null,null,null,"5. Choose Enable all macros. Select OK."]
[]
[]
[null,"1. Make sure solver is installed and macros are enabled",null,null,null,"For Microsoft 2007"]
[null,"2. Copy Sim_Template to a new worksheet, such as Sim_1",null,null,null,"1. Select the Office button              and choose Excel options."]
[null,"3. Change the green cells to create a new simulation",null,null,null,"2. Then proceed from ‘Choose Add-ins’ step onwards above."]
[null,"4. Run the macro \"RUN MODEL\" from the simulation sheet"]
[null,"5. Check that Solver has found an appropriate solution through comparison of Q* and Q* flat. There are multiple solutions."]
[null,"6. Extract results as required"]
[]
[null,"Colour coding"]
[]
[null,"Simulation inputs"]
[null,"Key outputs"]
[null,"Input data"]
[null,"Assumptions"]
[]
[]
[]
[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 tax 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":73,"n_cols":21,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source/Notes"]
["Assumptions 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","$",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,null,null,null,"CIE survey undertaken in October 2011 (including GST)"]
["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,null,null,null,"Sourced from CIE Survey 2012, based on network data provided by Combined Communications Networks and adjusted by the CIE."]
["Share of current trips at standard distance rate (10 pm - 6 am)","The proportion of trips in each shift for which the standard distance rate currently 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]
["If the surcharge hours of operation changed to ",{"$f":"Sim_template!T154","v":"5 pm until 5 am"},"Per cent",0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.2,0.2,0.2,0.2,0.15,0.05,0.2]
[{"$f":"A10","v":"If the surcharge hours of operation changed to "},{"$f":"Sim_template!T155","v":"12 am until 5 am"},"Per cent",0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.85,0.85,0.85,0.85,0.7,0.5,0.85]
["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,null,null,"IPART 2012 Survey (Taverner)"]
["Maximum proportion of taxis on the road for each shift",null,null,{"$f":"$C$55+MAX(D8-PERCENTILE($D$8:$Q$8,$C$57),0)/(MAX($D$8:$Q$8)-PERCENTILE($D$8:$Q$8,$C$57))*$C$56","v":0.82851935933309517},{"$f":"$C$55+MAX(E8-PERCENTILE($D$8:$Q$8,$C$57),0)/(MAX($D$8:$Q$8)-PERCENTILE($D$8:$Q$8,$C$57))*$C$56","v":0.83480915259431854},0.84181564348334081,0.87086897894311521,0.84313651396389366,0.76,0.76,0.76,0.76640960576220962,0.79507018030045762,0.83542618086261267,0.89,0.84459289006458083,0.76]
[null,"2012/13 Regulated Fares (including GST)"]
[null,"Flagfall ($)",3.5,null,null,"Colour coding"]
[null,"Standard kilometre charge ($/km)",2.14,null,null,"Input data"]
[null,"Night kilometre charge ($/km)",{"$f":"ROUND(2.568,2)","v":2.57},null,null,"Assumptions"]
[null,"Waiting time ($/hour when vehicle slower than 26km/hour)",55.3]
[null,"Booking fee ($/booking)",2.4]
[null,"GST",0.1]
[]
[null,"Costs of a standard taxi (excluding GST) ($2011/12)"]
[null,"Labour cost ($/hour)",{"$f":"H31","v":10},null,null,"Operator costs (/taxi/yr)",null,"Amount ($2011/12)","% Variable",null,null,null,null,null,null,null,null,null,null,null,"From CIE Survey 2012, for a weekday."]
[null,"Weekend labour cost premium ($ per hour)",{"$f":"H32","v":2},null,null,"Operator administration",null,9223]
[null,"Operator variable costs ($/km)",{"$f":"SUMPRODUCT(H25:H26,I25:I26)/C45","v":9.684579439252336E-2},null,null,"Maintenance",null,7562,0.5]
[null,"Operator costs (fixed, non plate, $/year)",{"$f":"SUM(H24:H28) - SUMPRODUCT(H25:H26,I25:I26)","v":32621.5},null,null,"Insurance",null,13163,0.5]
[null,"Fuel cost ($/km)",{"$f":"H33/C45","v":0.13658878504672897},null,null,"Vehicle lease",null,5805]
[null,"Cleaning ($/night shift)",11,null,null,"Network fees",null,7231]
[null,"For calculation of peak licence value:"]
[null,"Annual fixed costs to be apportioned over fewer shifts",{"$f":"H25+H26+H28-SUMPRODUCT(H25:H26,I25:I26)","v":17593.5},null,null,"Driver costs",null,"($2011/12)"]
[null,"Cost escalation from 2011/12 to 2012/13",3.6999999999999998E-2,null,null,"Labour ($/hr)",null,10,null,null,null,null,null,null,null,null,null,null,null,null,"Urban taxi cost index"]
[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,null,null,null,null,null,null,null,null,null,null,null,"From Transport for NSW Nov 2012"]
[null,"Fringe",14,null,null,"Cleaning ($/night shift)",null,11]
[null,"Unrestricted",4729]
[null,"WAT",618]
[null,"PAL",286]
[null,"Unrestricted + fringe",{"$f":"SUM(C34:C35)","v":4743}]
[null,"Total non-PAL",{"$f":"SUM(C34:C36)","v":5361}]
[null,"Total",{"$f":"SUM(C34:C37)","v":5647}]
[]
[null,"Other assumptions"]
[null,"Hours per shift (no.)",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CIE survey"]
[null,"Average trip length (kms)",7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BTS survey, provided by IPART"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Based on IPART assumption for standard fare, confirmed by figures from CIE survey 2012."]
[null,"Speed when on waiting time (km/hour)",{"$f":"26/2","v":13},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waiting time covers all speeds from 0 to 26 kilometres per hour. Based on half of maximum speed for waiting time."]
[null,"Average speed (km/hour)",32,null,null,"Meter data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calibrated to match occupancy figures from meter data."]
[null,"Revenue at waiting time rate/revenue at dist. rate",{"$f":"H52/H53","v":0.38203316814821564},null,null,"Total km",null,5141146]
[null,"Minutes on waiting time rate (/trip)",{"$f":"((C44*C16)*C50/(C18+C50*C48*C16))*60","v":5.2082660470425886},null,null,"Occupied km",null,2577606,null,null,null,null,null,null,null,null,null,null,null,null,"Calculation of waiting time minutes based on meter data showing waiting revenue against distance revenue."]
[null,"Kms on distance rate (/trip)",{"$f":"C44-C51/60*C48","v":5.8715423564741061},null,null,"Revenue at time rate ($2011/12)",null,1990899]
[null,"Multiplier for occupied to total kms for a trip",{"$f":"H50/H51","v":1.9945429984256708},null,null,"Revenue at distance rate ($2010/11)",null,5211325,null,null,null,null,null,null,null,null,null,null,null,null,"Based on meter data records provided by the Australian Taxi Drive Association. Measures total kilometres versus occupied kms."]
[null,"Value of time ($/hour)",30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard values of time used in economic appraisals are lower (around $15). However, taxi users are likely to have a higher value of time."]
[null,"Share of cabs at which constraint on number of cabs becomes binding",0.76,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Key assumption - based on share of trips at which revenue per cab begins to increase and hence licence constraint becomes important."]
[null,"Increase in constraint for highest demand shift (%)",0.13]
[null,"Per cent of shifts to which higher constraint not applied",0.3]
[null,"Slope of the supply curve",45]
[null,"Standard deviation of expected shift revenue",{"$f":"12.5240326851699*2","v":25.048065370339799}]
[null,"Calibration constant to account for rising marginal costs",{"$f":"C58*3/4","v":33.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Required because we have average cost data, therefore need to reduce the fixed component so that fixed + variable = average"]
[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?",8.5000000000000006E-2,null,null,null,null,null,null,null,null,"Flat",null,null,null,null,null,null,null,null,"This is set to align the peak licence value to that observed."]
[null,"Of shifts available, what per cent do peak licences do (%)",0.9,null,null,null,null,null,null,null,null,"Upward sloping"]
[]
[null,"Increase in demand per taxi 2012",0]
[]
[]
[null,"For fare change calculations"]
[null,"Fuel cost 2012/13 inc GST",{"$f":"'Inputs and assumptions'!C27*1.1*(1+'Inputs and assumptions'!C31)","v":0.15580682710280372},"Source"]
[null,"Night speed waiting rate",0,"Assumption"]
[null,"Night - Revenue at waiting time rate/revenue at dist. rate",0.1,"Assumption"]
[null,"Night Speed when on waiting time (km/hour)",45,"Assumption"]

{"sheet":"Base model","index":3,"n_rows":200,"n_cols":29,"rows_kept":200,"cut":false,"hidden":false,"merged":[]}
[]
["CALIBRATION OF MODEL PARAMETERS"]
["Day","Description","Unit",null,null,null,null,null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
["Shift",null,null,null,null,null,null,null,null,"Day","Day","Day","Day","Day","Day","Day","Night","Night","Night","Night","Night","Night","Night"]
["Revenue adjustment for fare increases and demand","Revenue adjustment for price increase from July 2012","Per cent",null,null,null,null,null,null,{"$f":"(1+'Inputs and assumptions'!$C$31)*(1+'Inputs and assumptions'!$C$66)","v":1.0369999999999999},{"$f":"(1+'Inputs and assumptions'!$C$31)*(1+'Inputs and assumptions'!$C$66)","v":1.0369999999999999},{"$f":"(1+'Inputs and assumptions'!$C$31)*(1+'Inputs and assumptions'!$C$66)","v":1.0369999999999999},{"$f":"(1+'Inputs and assumptions'!$C$31)*(1+'Inputs and assumptions'!$C$66)","v":1.0369999999999999},{"$f":"(1+'Inputs and assumptions'!$C$31)*(1+'Inputs and assumptions'!$C$66)","v":1.0369999999999999},{"$f":"(1+'Inputs and assumptions'!$C$31)*(1+'Inputs and assumptions'!$C$66)","v":1.0369999999999999},{"$f":"(1+'Inputs and assumptions'!$C$31)*(1+'Inputs and assumptions'!$C$66)","v":1.0369999999999999},{"$f":"(1+'Inputs and assumptions'!$C$31)*(1+'Inputs and assumptions'!$C$66)","v":1.0369999999999999},{"$f":"(1+'Inputs and assumptions'!$C$31)*(1+'Inputs and assumptions'!$C$66)","v":1.0369999999999999},{"$f":"(1+'Inputs and assumptions'!$C$31)*(1+'Inputs and assumptions'!$C$66)","v":1.0369999999999999},{"$f":"(1+'Inputs and assumptions'!$C$31)*(1+'Inputs and assumptions'!$C$66)","v":1.0369999999999999},{"$f":"(1+'Inputs and assumptions'!$C$31)*(1+'Inputs and assumptions'!$C$66)","v":1.0369999999999999},{"$f":"(1+'Inputs and assumptions'!$C$31)*(1+'Inputs and assumptions'!$C$66)","v":1.0369999999999999},{"$f":"(1+'Inputs and assumptions'!$C$31)*(1+'Inputs and assumptions'!$C$66)","v":1.0369999999999999},"now multiplicate"]
["T_max","The maximum number of taxis, based on the number of taxi plates","No.",null,null,null,null,null,null,{"$f":"'Inputs and assumptions'!$C$39","v":5361},{"$f":"'Inputs and assumptions'!$C$39","v":5361},{"$f":"'Inputs and assumptions'!$C$39","v":5361},{"$f":"'Inputs and assumptions'!$C$39","v":5361},{"$f":"'Inputs and assumptions'!$C$39","v":5361},{"$f":"'Inputs and assumptions'!$C$39","v":5361},{"$f":"'Inputs and assumptions'!$C$39","v":5361},{"$f":"'Inputs and assumptions'!$C$40","v":5647},{"$f":"'Inputs and assumptions'!$C$40","v":5647},{"$f":"'Inputs and assumptions'!$C$40","v":5647},{"$f":"'Inputs and assumptions'!$C$40","v":5647},{"$f":"'Inputs and assumptions'!$C$40","v":5647},{"$f":"'Inputs and assumptions'!$C$40","v":5647},{"$f":"'Inputs and assumptions'!$C$40","v":5647},"ok"]
["T_base","The number of taxis actually on the road, based on network data","No.",null,null,null,null,null,null,{"$f":"'Inputs and assumptions'!D8/100*J6","v":4316.5734878638923},{"$f":"'Inputs and assumptions'!E8/100*K6","v":4357.2401441442989},{"$f":"'Inputs and assumptions'!F8/100*L6","v":4402.5406087036454},{"$f":"'Inputs and assumptions'!G8/100*M6","v":4590.3849396494588},{"$f":"'Inputs and assumptions'!H8/100*N6","v":4411.0806963651485},{"$f":"'Inputs and assumptions'!I8/100*O6","v":3203.0296838428258},{"$f":"'Inputs and assumptions'!J8/100*P6","v":2890.8120226649721},{"$f":"'Inputs and assumptions'!K8/100*Q6","v":3687.3402202861457},{"$f":"'Inputs and assumptions'!L8/100*R6","v":4123.8614728485882},{"$f":"'Inputs and assumptions'!M8/100*S6","v":4319.0521032982588},{"$f":"'Inputs and assumptions'!N8/100*T6","v":4593.8935298594097},{"$f":"'Inputs and assumptions'!O8/100*U6","v":4965.5643122876272},{"$f":"'Inputs and assumptions'!P8/100*V6","v":4656.322695258491},{"$f":"'Inputs and assumptions'!Q8/100*W6","v":3023.1008478425142},"ok"]
["T_max_effective","The maximum effective number of taxis on the road","No.",null,null,null,null,null,null,{"$f":"('Inputs and assumptions'!$C$55+MAX('Inputs and assumptions'!D8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57))*'Inputs and assumptions'!$C$56)*J6","v":4441.6922853847236},{"$f":"('Inputs and assumptions'!$C$55+MAX('Inputs and assumptions'!E8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57))*'Inputs and assumptions'!$C$56)*K6","v":4475.411867058142},{"$f":"('Inputs and assumptions'!$C$55+MAX('Inputs and assumptions'!F8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57))*'Inputs and assumptions'!$C$56)*L6","v":4512.9736647141899},{"$f":"('Inputs and assumptions'!$C$55+MAX('Inputs and assumptions'!G8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57))*'Inputs and assumptions'!$C$56)*M6","v":4668.7285961140406},{"$f":"('Inputs and assumptions'!$C$55+MAX('Inputs and assumptions'!H8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57))*'Inputs and assumptions'!$C$56)*N6","v":4520.0548513604335},{"$f":"('Inputs and assumptions'!$C$55+MAX('Inputs and assumptions'!I8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57))*'Inputs and assumptions'!$C$56)*O6","v":4074.36},{"$f":"('Inputs and assumptions'!$C$55+MAX('Inputs and assumptions'!J8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57))*'Inputs and assumptions'!$C$56)*P6","v":4074.36},{"$f":"('Inputs and assumptions'!$C$55+MAX('Inputs and assumptions'!K8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57))*'Inputs and assumptions'!$C$56)*Q6","v":4291.72},{"$f":"('Inputs and assumptions'!$C$55+MAX('Inputs and assumptions'!L8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57))*'Inputs and assumptions'!$C$56)*R6","v":4327.9150437391982},{"$f":"('Inputs and assumptions'!$C$55+MAX('Inputs and assumptions'!M8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57))*'Inputs and assumptions'!$C$56)*S6","v":4489.7613081566842},{"$f":"('Inputs and assumptions'!$C$55+MAX('Inputs and assumptions'!N8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57))*'Inputs and assumptions'!$C$56)*T6","v":4717.6516433311735},{"$f":"('Inputs and assumptions'!$C$55+MAX('Inputs and assumptions'!O8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57))*'Inputs and assumptions'!$C$56)*U6","v":5025.83},{"$f":"('Inputs and assumptions'!$C$55+MAX('Inputs and assumptions'!P8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57))*'Inputs and assumptions'!$C$56)*V6","v":4769.4160501946881},{"$f":"('Inputs and assumptions'!$C$55+MAX('Inputs and assumptions'!Q8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57))*'Inputs and assumptions'!$C$56)*W6","v":4291.72},{"$f":"('Inputs and assumptions'!$C$55+MAX('Inputs and assumptions'!R8-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57),0)/(MAX('Inputs and assumptions'!$D$8:$Q$8)-PERCENTILE('Inputs and assumptions'!$D$8:$Q$8,'Inputs and assumptions'!$C$57))*'Inputs and assumptions'!$C$56)*X6","v":{"$error":"#VALUE!"}}]
["Q_base","Baseline quantity of taxis demanded per shift","Kms occupied",null,null,null,null,null,null,{"$f":"J7*'Inputs and assumptions'!D7/J13/$B$20*J5","v":382718.94540266518},{"$f":"K7*'Inputs and assumptions'!E7/K13/$B$20*K5","v":380027.38167367538},{"$f":"L7*'Inputs and assumptions'!F7/L13/$B$20*L5","v":390784.92579487606},{"$f":"M7*'Inputs and assumptions'!G7/M13/$B$20*M5","v":414401.33463067369},{"$f":"N7*'Inputs and assumptions'!H7/N13/$B$20*N5","v":419415.02201265405},{"$f":"O7*'Inputs and assumptions'!I7/O13/$B$20*O5","v":297338.17313916679},{"$f":"P7*'Inputs and assumptions'!J7/P13/$B$20*P5","v":271075.3870690894},{"$f":"Q7*'Inputs and assumptions'!K7/Q13/$B$20*Q5","v":315327.62167150405},{"$f":"R7*'Inputs and assumptions'!L7/R13/$B$20*R5","v":385484.79983498488},{"$f":"S7*'Inputs and assumptions'!M7/S13/$B$20*S5","v":441250.40543171746},{"$f":"T7*'Inputs and assumptions'!N7/T13/$B$20*T5","v":517734.01894150977},{"$f":"U7*'Inputs and assumptions'!O7/U13/$B$20*U5","v":682678.03709273122},{"$f":"V7*'Inputs and assumptions'!P7/V13/$B$20*V5","v":630901.63422562391},{"$f":"W7*'Inputs and assumptions'!Q7/W13/$B$20*W5","v":274600.9801848408},"ok - see check below. Forumula simplified, GST adjustment no longer hard-coded"]
[null,"Demand intercept with y axis","Kms occupied",null,null,null,null,null,null,{"$f":"J9+J11*J13+'Inputs and assumptions'!D12*J12","v":750754.64178869664},{"$f":"K9+K11*K13+'Inputs and assumptions'!E12*K12","v":745474.77783766284},{"$f":"L9+L11*L13+'Inputs and assumptions'!F12*L12","v":766577.14624730847},{"$f":"M9+M11*M13+'Inputs and assumptions'!G12*M12","v":812903.90578935435},{"$f":"N9+N11*N13+'Inputs and assumptions'!H12*N12","v":821005.58179438987},{"$f":"O9+O11*O13+'Inputs and assumptions'!I12*O12","v":582039.95330533851},{"$f":"P9+P11*P13+'Inputs and assumptions'!J12*P12","v":530527.61247699929},{"$f":"Q9+Q11*Q13+'Inputs and assumptions'!K12*Q12","v":612163.22558695544},{"$f":"R9+R11*R13+'Inputs and assumptions'!L12*R12","v":748363.29665899195},{"$f":"S9+S11*S13+'Inputs and assumptions'!M12*S12","v":856624.19945573155},{"$f":"T9+T11*T13+'Inputs and assumptions'!N12*T12","v":1005106.1348552133},{"$f":"U9+U11*U13+'Inputs and assumptions'!O12*U12","v":1351981.5450049913},{"$f":"V9+V11*V13+'Inputs and assumptions'!P12*V12","v":1246928.9673905007},{"$f":"W9+W11*W13+'Inputs and assumptions'!Q12*W12","v":549010.59276708763},"ok"]
[null,"Impact of price on demand kilometres","Change in Q per extra dollar",null,null,null,null,null,null,{"$f":"'Inputs and assumptions'!D$5*J9/J13","v":109156.57693471735},{"$f":"'Inputs and assumptions'!E$5*K9/K13","v":108388.90685517881},{"$f":"'Inputs and assumptions'!F$5*L9/L13","v":111457.10273782321},{"$f":"'Inputs and assumptions'!G$5*M9/M13","v":118192.81932299053},{"$f":"'Inputs and assumptions'!H$5*N9/N13","v":119622.79021680652},{"$f":"'Inputs and assumptions'!I$5*O9/O13","v":84804.835406686791},{"$f":"'Inputs and assumptions'!J$5*P9/P13","v":77314.336536393705},{"$f":"'Inputs and assumptions'!K$5*Q9/Q13","v":88385.838257620955},{"$f":"'Inputs and assumptions'!L$5*R9/R13","v":108050.78536532586},{"$f":"'Inputs and assumptions'!M$5*S9/S13","v":123681.79723318506},{"$f":"'Inputs and assumptions'!N$5*T9/T13","v":145120.03425536785},{"$f":"'Inputs and assumptions'!O$5*U9/U13","v":188111.91870070621},{"$f":"'Inputs and assumptions'!P$5*V9/V13","v":170004.92666015503},{"$f":"'Inputs and assumptions'!Q$5*W9/W13","v":76970.224464781975},"ok"]
[null,"Impact of waiting time on demand kilometres","Change in Q per extra minute ",null,null,null,null,null,null,{"$f":"('Inputs and assumptions'!$C$54/'Inputs and assumptions'!$C$44)/60*J11","v":7796.8983524798105},{"$f":"('Inputs and assumptions'!$C$54/'Inputs and assumptions'!$C$44)/60*K11","v":7742.0647753699141},{"$f":"('Inputs and assumptions'!$C$54/'Inputs and assumptions'!$C$44)/60*L11","v":7961.2216241302285},{"$f":"('Inputs and assumptions'!$C$54/'Inputs and assumptions'!$C$44)/60*M11","v":8442.3442373564667},{"$f":"('Inputs and assumptions'!$C$54/'Inputs and assumptions'!$C$44)/60*N11","v":8544.4850154861797},{"$f":"('Inputs and assumptions'!$C$54/'Inputs and assumptions'!$C$44)/60*O11","v":6057.4882433347702},{"$f":"('Inputs and assumptions'!$C$54/'Inputs and assumptions'!$C$44)/60*P11","v":5522.4526097424068},{"$f":"('Inputs and assumptions'!$C$54/'Inputs and assumptions'!$C$44)/60*Q11","v":6313.2741612586397},{"$f":"('Inputs and assumptions'!$C$54/'Inputs and assumptions'!$C$44)/60*R11","v":7717.9132403804188},{"$f":"('Inputs and assumptions'!$C$54/'Inputs and assumptions'!$C$44)/60*S11","v":8834.4140880846462},{"$f":"('Inputs and assumptions'!$C$54/'Inputs and assumptions'!$C$44)/60*T11","v":10365.716732526274},{"$f":"('Inputs and assumptions'!$C$54/'Inputs and assumptions'!$C$44)/60*U11","v":13436.565621479014},{"$f":"('Inputs and assumptions'!$C$54/'Inputs and assumptions'!$C$44)/60*V11","v":12143.20904715393},{"$f":"('Inputs and assumptions'!$C$54/'Inputs and assumptions'!$C$44)/60*W11","v":5497.8731760558549},"ok"]
["P","Price per kilometre of demand (excluding GST)","$/km occupied",null,null,null,null,null,null,{"$f":"(('Inputs and assumptions'!$C$15+'Inputs and assumptions'!$C$47*'Inputs and assumptions'!$C$19)/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$16*'Inputs and assumptions'!D9+'Inputs and assumptions'!$C$17*(1-'Inputs and assumptions'!D9))*'Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$51/60*'Inputs and assumptions'!$C$18)/'Inputs and assumptions'!$C$44)/$B$20","v":2.8049171650485576},{"$f":"(('Inputs and assumptions'!$C$15+'Inputs and assumptions'!$C$47*'Inputs and assumptions'!$C$19)/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$16*'Inputs and assumptions'!E9+'Inputs and assumptions'!$C$17*(1-'Inputs and assumptions'!E9))*'Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$51/60*'Inputs and assumptions'!$C$18)/'Inputs and assumptions'!$C$44)/$B$20","v":2.8049171650485576},{"$f":"(('Inputs and assumptions'!$C$15+'Inputs and assumptions'!$C$47*'Inputs and assumptions'!$C$19)/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$16*'Inputs and assumptions'!F9+'Inputs and assumptions'!$C$17*(1-'Inputs and assumptions'!F9))*'Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$51/60*'Inputs and assumptions'!$C$18)/'Inputs and assumptions'!$C$44)/$B$20","v":2.8049171650485576},{"$f":"(('Inputs and assumptions'!$C$15+'Inputs and assumptions'!$C$47*'Inputs and assumptions'!$C$19)/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$16*'Inputs and assumptions'!G9+'Inputs and assumptions'!$C$17*(1-'Inputs and assumptions'!G9))*'Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$51/60*'Inputs and assumptions'!$C$18)/'Inputs and assumptions'!$C$44)/$B$20","v":2.8049171650485576},{"$f":"(('Inputs and assumptions'!$C$15+'Inputs and assumptions'!$C$47*'Inputs and assumptions'!$C$19)/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$16*'Inputs and assumptions'!H9+'Inputs and assumptions'!$C$17*(1-'Inputs and assumptions'!H9))*'Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$51/60*'Inputs and assumptions'!$C$18)/'Inputs and assumptions'!$C$44)/$B$20","v":2.8049171650485576},{"$f":"(('Inputs and assumptions'!$C$15+'Inputs and assumptions'!$C$47*'Inputs and assumptions'!$C$19)/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$16*'Inputs and assumptions'!I9+'Inputs and assumptions'!$C$17*(1-'Inputs and assumptions'!I9))*'Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$51/60*'Inputs and assumptions'!$C$18)/'Inputs and assumptions'!$C$44)/$B$20","v":2.8049171650485576},{"$f":"(('Inputs and assumptions'!$C$15+'Inputs and assumptions'!$C$47*'Inputs and assumptions'!$C$19)/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$16*'Inputs and assumptions'!J9+'Inputs and assumptions'!$C$17*(1-'Inputs and assumptions'!J9))*'Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$51/60*'Inputs and assumptions'!$C$18)/'Inputs and assumptions'!$C$44)/$B$20","v":2.8049171650485576},{"$f":"(('Inputs and assumptions'!$C$15+'Inputs and assumptions'!$C$47*'Inputs and assumptions'!$C$19)/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$16*'Inputs and assumptions'!K9+'Inputs and assumptions'!$C$17*(1-'Inputs and assumptions'!K9))*'Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$51/60*'Inputs and assumptions'!$C$18)/'Inputs and assumptions'!$C$44)/$B$20","v":2.8541008640086329},{"$f":"(('Inputs and assumptions'!$C$15+'Inputs and assumptions'!$C$47*'Inputs and assumptions'!$C$19)/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$16*'Inputs and assumptions'!L9+'Inputs and assumptions'!$C$17*(1-'Inputs and assumptions'!L9))*'Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$51/60*'Inputs and assumptions'!$C$18)/'Inputs and assumptions'!$C$44)/$B$20","v":2.8541008640086329},{"$f":"(('Inputs and assumptions'!$C$15+'Inputs and assumptions'!$C$47*'Inputs and assumptions'!$C$19)/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$16*'Inputs and assumptions'!M9+'Inputs and assumptions'!$C$17*(1-'Inputs and assumptions'!M9))*'Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$51/60*'Inputs and assumptions'!$C$18)/'Inputs and assumptions'!$C$44)/$B$20","v":2.8541008640086329},{"$f":"(('Inputs and assumptions'!$C$15+'Inputs and assumptions'!$C$47*'Inputs and assumptions'!$C$19)/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$16*'Inputs and assumptions'!N9+'Inputs and assumptions'!$C$17*(1-'Inputs and assumptions'!N9))*'Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$51/60*'Inputs and assumptions'!$C$18)/'Inputs and assumptions'!$C$44)/$B$20","v":2.8541008640086329},{"$f":"(('Inputs and assumptions'!$C$15+'Inputs and assumptions'!$C$47*'Inputs and assumptions'!$C$19)/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$16*'Inputs and assumptions'!O9+'Inputs and assumptions'!$C$17*(1-'Inputs and assumptions'!O9))*'Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$51/60*'Inputs and assumptions'!$C$18)/'Inputs and assumptions'!$C$44)/$B$20","v":2.9032845629687083},{"$f":"(('Inputs and assumptions'!$C$15+'Inputs and assumptions'!$C$47*'Inputs and assumptions'!$C$19)/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$16*'Inputs and assumptions'!P9+'Inputs and assumptions'!$C$17*(1-'Inputs and assumptions'!P9))*'Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$51/60*'Inputs and assumptions'!$C$18)/'Inputs and assumptions'!$C$44)/$B$20","v":2.9688628282488083},{"$f":"(('Inputs and assumptions'!$C$15+'Inputs and assumptions'!$C$47*'Inputs and assumptions'!$C$19)/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$16*'Inputs and assumptions'!Q9+'Inputs and assumptions'!$C$17*(1-'Inputs and assumptions'!Q9))*'Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44+('Inputs and assumptions'!$C$51/60*'Inputs and assumptions'!$C$18)/'Inputs and assumptions'!$C$44)/$B$20","v":2.8541008640086329},"ok  - see check below. Very long formula!! GST adjustment no longer hard-coded"]
["c","Variable cost","$/km occupied",null,null,null,null,null,null,{"$f":"('Inputs and assumptions'!C25+'Inputs and assumptions'!C27)*'Inputs and assumptions'!C53*(1+'Inputs and assumptions'!$C$31)","v":0.48282233233340882},{"$f":"J14","v":0.48282233233340882},{"$f":"K14","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,"ok"]
[null,"Fixed component of shift costs","$/taxi/shift",null,null,null,null,null,null,{"$f":"(('Inputs and assumptions'!$C$23+IF('Inputs and assumptions'!D6=\"Yes\",'Inputs and assumptions'!$C$24,0))*'Inputs and assumptions'!$C$43+'Inputs and assumptions'!$C$26/'Inputs and assumptions'!$C$46)*(1+'Inputs and assumptions'!$C$31)-IF('Inputs and assumptions'!$C$61=\"Flat\",0,'Inputs and assumptions'!$C$60)","v":131.23350634057968},{"$f":"(('Inputs and assumptions'!$C$23+IF('Inputs and assumptions'!E6=\"Yes\",'Inputs and assumptions'!$C$24,0))*'Inputs and assumptions'!$C$43+'Inputs and assumptions'!$C$26/'Inputs and assumptions'!$C$46)*(1+'Inputs and assumptions'!$C$31)-IF('Inputs and assumptions'!$C$61=\"Flat\",0,'Inputs and assumptions'!$C$60)","v":131.23350634057968},{"$f":"(('Inputs and assumptions'!$C$23+IF('Inputs and assumptions'!F6=\"Yes\",'Inputs and assumptions'!$C$24,0))*'Inputs and assumptions'!$C$43+'Inputs and assumptions'!$C$26/'Inputs and assumptions'!$C$46)*(1+'Inputs and assumptions'!$C$31)-IF('Inputs and assumptions'!$C$61=\"Flat\",0,'Inputs and assumptions'!$C$60)","v":131.23350634057968},{"$f":"(('Inputs and assumptions'!$C$23+IF('Inputs and assumptions'!G6=\"Yes\",'Inputs and assumptions'!$C$24,0))*'Inputs and assumptions'!$C$43+'Inputs and assumptions'!$C$26/'Inputs and assumptions'!$C$46)*(1+'Inputs and assumptions'!$C$31)-IF('Inputs and assumptions'!$C$61=\"Flat\",0,'Inputs and assumptions'!$C$60)","v":131.23350634057968},{"$f":"(('Inputs and assumptions'!$C$23+IF('Inputs and assumptions'!H6=\"Yes\",'Inputs and assumptions'!$C$24,0))*'Inputs and assumptions'!$C$43+'Inputs and assumptions'!$C$26/'Inputs and assumptions'!$C$46)*(1+'Inputs and assumptions'!$C$31)-IF('Inputs and assumptions'!$C$61=\"Flat\",0,'Inputs and assumptions'!$C$60)","v":131.23350634057968},{"$f":"(('Inputs and assumptions'!$C$23+IF('Inputs and assumptions'!I6=\"Yes\",'Inputs and assumptions'!$C$24,0))*'Inputs and assumptions'!$C$43+'Inputs and assumptions'!$C$26/'Inputs and assumptions'!$C$46)*(1+'Inputs and assumptions'!$C$31)-IF('Inputs and assumptions'!$C$61=\"Flat\",0,'Inputs and assumptions'!$C$60)","v":151.97350634057969},{"$f":"(('Inputs and assumptions'!$C$23+IF('Inputs and assumptions'!J6=\"Yes\",'Inputs and assumptions'!$C$24,0))*'Inputs and assumptions'!$C$43+'Inputs and assumptions'!$C$26/'Inputs and assumptions'!$C$46)*(1+'Inputs and assumptions'!$C$31)-IF('Inputs and assumptions'!$C$61=\"Flat\",0,'Inputs and assumptions'!$C$60)","v":151.97350634057969},{"$f":"(('Inputs and assumptions'!$C$23+IF('Inputs and assumptions'!K6=\"Yes\",'Inputs and assumptions'!$C$24,0))*'Inputs and assumptions'!$C$43+'Inputs and assumptions'!$C$28+'Inputs and assumptions'!$C$26/'Inputs and assumptions'!$C$46)*(1+'Inputs and assumptions'!$C$31)-IF('Inputs and assumptions'!$C$61=\"Flat\",0,'Inputs and assumptions'!$C$60)","v":142.64050634057969},{"$f":"(('Inputs and assumptions'!$C$23+IF('Inputs and assumptions'!L6=\"Yes\",'Inputs and assumptions'!$C$24,0))*'Inputs and assumptions'!$C$43+'Inputs and assumptions'!$C$28+'Inputs and assumptions'!$C$26/'Inputs and assumptions'!$C$46)*(1+'Inputs and assumptions'!$C$31)-IF('Inputs and assumptions'!$C$61=\"Flat\",0,'Inputs and assumptions'!$C$60)","v":142.64050634057969},{"$f":"(('Inputs and assumptions'!$C$23+IF('Inputs and assumptions'!M6=\"Yes\",'Inputs and assumptions'!$C$24,0))*'Inputs and assumptions'!$C$43+'Inputs and assumptions'!$C$28+'Inputs and assumptions'!$C$26/'Inputs and assumptions'!$C$46)*(1+'Inputs and assumptions'!$C$31)-IF('Inputs and assumptions'!$C$61=\"Flat\",0,'Inputs and assumptions'!$C$60)","v":142.64050634057969},{"$f":"(('Inputs and assumptions'!$C$23+IF('Inputs and assumptions'!N6=\"Yes\",'Inputs and assumptions'!$C$24,0))*'Inputs and assumptions'!$C$43+'Inputs and assumptions'!$C$28+'Inputs and assumptions'!$C$26/'Inputs and assumptions'!$C$46)*(1+'Inputs and assumptions'!$C$31)-IF('Inputs and assumptions'!$C$61=\"Flat\",0,'Inputs and assumptions'!$C$60)","v":142.64050634057969},{"$f":"(('Inputs and assumptions'!$C$23+IF('Inputs and assumptions'!O6=\"Yes\",'Inputs and assumptions'!$C$24,0))*'Inputs and assumptions'!$C$43+'Inputs and assumptions'!$C$28+'Inputs and assumptions'!$C$26/'Inputs and assumptions'!$C$46)*(1+'Inputs and assumptions'!$C$31)-IF('Inputs and assumptions'!$C$61=\"Flat\",0,'Inputs and assumptions'!$C$60)","v":163.3805063405797},{"$f":"(('Inputs and assumptions'!$C$23+IF('Inputs and assumptions'!P6=\"Yes\",'Inputs and assumptions'!$C$24,0))*'Inputs and assumptions'!$C$43+'Inputs and assumptions'!$C$28+'Inputs and assumptions'!$C$26/'Inputs and assumptions'!$C$46)*(1+'Inputs and assumptions'!$C$31)-IF('Inputs and assumptions'!$C$61=\"Flat\",0,'Inputs and assumptions'!$C$60)","v":163.3805063405797},{"$f":"(('Inputs and assumptions'!$C$23+IF('Inputs and assumptions'!Q6=\"Yes\",'Inputs and assumptions'!$C$24,0))*'Inputs and assumptions'!$C$43+'Inputs and assumptions'!$C$28+'Inputs and assumptions'!$C$26/'Inputs and assumptions'!$C$46)*(1+'Inputs and assumptions'!$C$31)-IF('Inputs and assumptions'!$C$61=\"Flat\",0,'Inputs and assumptions'!$C$60)","v":163.3805063405797},"ok  - see check below. Very long formula!! "]
[null,"Variable component of fixed costs","$/additional taxi per shift",null,null,null,null,null,null,{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$58/5000)","v":8.9999999999999993E-3},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$58/5000)","v":8.9999999999999993E-3},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$58/5000)","v":8.9999999999999993E-3},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$58/5000)","v":8.9999999999999993E-3},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$58/5000)","v":8.9999999999999993E-3},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$58/5000)","v":8.9999999999999993E-3},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$58/5000)","v":8.9999999999999993E-3},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$58/5000)","v":8.9999999999999993E-3},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$58/5000)","v":8.9999999999999993E-3},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$58/5000)","v":8.9999999999999993E-3},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$58/5000)","v":8.9999999999999993E-3},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$58/5000)","v":8.9999999999999993E-3},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$58/5000)","v":8.9999999999999993E-3},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",0.0000000000000001,'Inputs and assumptions'!$C$58/5000)","v":8.9999999999999993E-3},"flat demand curve gives Div0 error"]
[null,"Waiting time constant","Unit",null,null,null,null,null,null,{"$f":"'Inputs and assumptions'!D12*(J7-J9*J18)","v":24758.635602268234},{"$f":"J17","v":24758.635602268234},{"$f":"K17","v":24758.635602268234},24758.635602268234,24758.635602268234,24758.635602268234,24758.635602268234,24758.635602268234,24758.635602268234,24758.635602268234,24758.635602268234,24758.635602268234,24758.635602268234,24758.635602268234,"formula correct (as per Description, with estimated base waiting time).  Uses waiting time for Monday day. Stricktly speaking, shouldn't it use a weighted average waiting time?"]
[null,"Constant to link occupied taxi kms to occupied taxis","Unit (inverse of km per shift)",null,null,null,null,null,null,{"$f":"1/'Inputs and assumptions'!C49/'Inputs and assumptions'!C43","v":3.1250000000000002E-3},{"$f":"J18","v":3.1250000000000002E-3},{"$f":"K18","v":3.1250000000000002E-3},3.1250000000000002E-3,3.1250000000000002E-3,3.1250000000000002E-3,3.1250000000000002E-3,3.1250000000000002E-3,3.1250000000000002E-3,3.1250000000000002E-3,3.1250000000000002E-3,3.1250000000000002E-3,3.1250000000000002E-3,3.1250000000000002E-3,"assume this is correct - looks ok"]
[null,null,null,null,null,null,null,null,null,{"$f":"RANK(J9,$J$9:$W$9,1)","v":6},5,8,9,10,3,1,4,7,11,12,14,13,2]
["GST adjustor",{"$f":"(1+'Inputs and assumptions'!$C$20)","v":1.1000000000000001}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
["BASELINE MODEL",null,null,null,null,null,null,null,null,"Day","Day","Day","Day","Day","Day","Day","Night","Night","Night","Night","Night","Night","Night"]
["Q*","Free entry demand","Occupied kilometres",null,null,null,null,null,null,395471.81227801961,392414.26617920096,404633.10473039316,431445.53345872619,435247.77352137509,289291.66042899928,258960.65936140987,309893.84745459538,388510.26895414287,450813.06866073603,536138.84821314737,744312.05950508383,685087.83928899874,275053.02471715614]
["W*","Free entry waiting time","Minutes, average",null,null,null,null,null,null,6.2983600617203974,6.334047536715155,6.1945393821897454,5.9150993162682362,5.8781530509869562,9.0594900329174788,9.9062223483469563,7.9209740489374187,6.6682775815091677,5.9778504746398067,5.2847355279316757,4.579076049564943,4.7038489166412738,9.8723237448332704]
["T*","Free entry number of taxis on the road","Taxis on the road",null,null,null,null,null,null,5166.8150345092536,5135.1120415517798,5261.326978830255,5533.9342231708406,5572.124616406265,3636.9315038309001,3308.553482545788,4094.1242091194895,4926.9927564105246,5550.5196612102991,6360.3676067062524,7732.8815867866606,7404.3839423451982,3367.4239769579785]
["Q* zero condition","Zero condition to solve for free entry","Occupied kilometres",null,null,null,null,null,null,{"$f":"J10-J11*J13-J12*J111-J110","v":-7.5669959187507629E-9},5.8207660913467407E-10,-8.7311491370201111E-10,8.7311491370201111E-10,-8.7311491370201111E-10,0,6.4028427004814148E-10,0,0,0,0,0,0,6.9849193096160889E-10,"ok"]
["W* zero condition","Zero condition to solve for free entry","Minutes, average",null,null,null,null,null,null,{"$f":"J17/(J112-J110*J18)-J111","v":-3.2305513819608223E-7},-2.0045298754212126E-11,-1.9771739800944488E-11,-1.9309887022700423E-11,-1.8382628752533492E-11,-7.5193185011812602E-12,-5.3752557960251579E-12,-7.5495165674510645E-13,-5.7847060475069156E-12,-8.3728579625130806E-12,-1.000000082740371E-11,-4.9560355819266988E-12,-1.269295779593449E-11,4.2685854850788019E-12,"formula correct (as per Description) and check below"]
["T* zero condition","Zero condition to solve for free entry","Taxis on the road",null,null,null,null,null,null,{"$f":"(-J15+SQRT(J15^2+4*J16*(J13-J14)*J110))/(2*J16)-J112","v":-9.9923818197567016E-7},1.0995790944434702E-9,1.0913936421275139E-9,1.1468728189356625E-9,1.1268639354966581E-9,2.1236701286397874E-10,1.2187229003757238E-10,2.2737367544323206E-11,2.7921487344428897E-10,4.6748027671128511E-10,6.730260793119669E-10,3.3378455555066466E-10,9.4769347924739122E-10,0,"formula correct (as per Description) and check below"]
["Qbar","Fixed taxi numbers demand","Occupied kilometres",null,null,null,null,null,null,{"$f":"((J18*(J10-J11*J13)+J118)-SQRT((J18*(J10-J11*J13)+J118)^2-4*J18*(J118*(J10-J11*J13)-J12*J17)))/(2*J18)","v":384974.19068216172},382987.55847675423,393892.70237519435,419153.38051858399,419548.93475749937,296523.818021568,271291.58171090833,312740.9078453072,379178.12597338035,433832.6656786013,508858.61865750514,689919.10979358794,634336.49520764127,289154.10560110561,"formula correct (as per Description) and check below"]
["Wbar","Fixed taxi numbers waiting time","Minutes, average",null,null,null,null,null,null,{"$f":"J17/(J118-J116*J18)","v":7.6447443701052347},7.551643614241768,7.5436291151829957,7.3711111294032055,7.7154596569932883,7.865569830013774,7.6733516981318051,7.4700098870794172,7.8774312335528176,7.8999250811535466,7.9165100843442824,8.6272049571889546,8.8832502498705264,7.3074990512842621,"formula correct (as per Description) and check below"]
["Tbar","Fixed taxi numbers","Taxis on the road",null,null,null,null,null,null,{"$f":"J8","v":4441.6922853847236},4475.411867058142,4512.9736647141899,4668.7285961140406,4520.0548513604335,4074.36,4074.36,4291.72,4327.9150437391982,4489.7613081566842,4717.6516433311735,5025.83,4769.4160501946881,4291.72,"ok"]
["Q*_flat","Free entry demand, flat cost curve","Occupied kilometres",null,null,null,null,null,null,{"$f":"(J10-J11*J13+SQRT((J10-J11*J13)^2-4*J12*J17/((J13-J14)/J15-J18)))/2","v":412455.40791372454},409309.55379364768,421880.92941722443,449463.45680222492,453452.17264531238,303516.0118009852,272365.85587117157,324183.39755917632,405026.30494022439,469081.73792799504,556772.80452481704,768824.09164581425,707039.90523915482,287800.98189635447,"formula correct (as per Description) and check below"]
["W*_flat","Free entry waiting time, flat cost curve","Minutes, average",null,null,null,null,null,null,{"$f":"J17/((J13-J14)/J15-J18)/J119","v":4.1201098309333304},4.1517759974488211,4.0280597260331445,3.7808670654947476,3.7476093036523701,6.7112640355104203,7.4788232456163417,5.6575605269540672,4.5283162381152913,3.9099522433469569,3.29413933047605,2.7547979690451316,2.8960841104097836,7.5536167155920255,"formula correct (as per Description) and check below"]
["T*_flat","Free entry number of taxis on the road, flat cost curve","Taxis on the road",null,null,null,null,null,null,{"$f":"(J13-J14)*J119/J15","v":7298.1405294184569},{"$f":"(K13-K14)*K119/K15","v":7242.4766079063083},7464.919238524355,7952.9748128965884,8023.55264554525,4637.6041431188942,4161.6421293137482,5389.2765153408172,6733.2219038489538,7798.0896400752208,9255.8799198170254,11390.034940594263,10758.504034677169,4177.0974093031673,"formula correct (as per Description) and check below. But answer is correct only if 'flat' option is selected"]
["Q","Equilibrium demand","Occupied kilometres",null,null,null,null,null,null,{"$f":"IF(J124=J$118,J116,IF('Inputs and assumptions'!$C$61=\"Flat\",J119,J110))","v":384974.19068216172},{"$f":"IF(K124=K$118,K116,IF('Inputs and assumptions'!$C$61=\"Flat\",K119,K110))","v":382987.55847675423},{"$f":"IF(L124=L$118,L116,IF('Inputs and assumptions'!$C$61=\"Flat\",L119,L110))","v":393892.70237519435},{"$f":"IF(M124=M$118,M116,IF('Inputs and assumptions'!$C$61=\"Flat\",M119,M110))","v":419153.38051858399},{"$f":"IF(N124=N$118,N116,IF('Inputs and assumptions'!$C$61=\"Flat\",N119,N110))","v":419548.93475749937},{"$f":"IF(O124=O$118,O116,IF('Inputs and assumptions'!$C$61=\"Flat\",O119,O110))","v":289291.66042899928},{"$f":"IF(P124=P$118,P116,IF('Inputs and assumptions'!$C$61=\"Flat\",P119,P110))","v":258960.65936140987},{"$f":"IF(Q124=Q$118,Q116,IF('Inputs and assumptions'!$C$61=\"Flat\",Q119,Q110))","v":309893.84745459538},{"$f":"IF(R124=R$118,R116,IF('Inputs and assumptions'!$C$61=\"Flat\",R119,R110))","v":379178.12597338035},{"$f":"IF(S124=S$118,S116,IF('Inputs and assumptions'!$C$61=\"Flat\",S119,S110))","v":433832.6656786013},{"$f":"IF(T124=T$118,T116,IF('Inputs and assumptions'!$C$61=\"Flat\",T119,T110))","v":508858.61865750514},{"$f":"IF(U124=U$118,U116,IF('Inputs and assumptions'!$C$61=\"Flat\",U119,U110))","v":689919.10979358794},{"$f":"IF(V124=V$118,V116,IF('Inputs and assumptions'!$C$61=\"Flat\",V119,V110))","v":634336.49520764127},{"$f":"IF(W124=W$118,W116,IF('Inputs and assumptions'!$C$61=\"Flat\",W119,W110))","v":275053.02471715614},"ok"]
["W","Equilibrium waiting time","Minutes, average",null,null,null,null,null,null,{"$f":"IF(J124=J$118,J117,IF('Inputs and assumptions'!$C$61=\"Flat\",J120,J111))","v":7.6447443701052347},{"$f":"IF(K124=K$118,K117,IF('Inputs and assumptions'!$C$61=\"Flat\",K120,K111))","v":7.551643614241768},{"$f":"IF(L124=L$118,L117,IF('Inputs and assumptions'!$C$61=\"Flat\",L120,L111))","v":7.5436291151829957},{"$f":"IF(M124=M$118,M117,IF('Inputs and assumptions'!$C$61=\"Flat\",M120,M111))","v":7.3711111294032055},{"$f":"IF(N124=N$118,N117,IF('Inputs and assumptions'!$C$61=\"Flat\",N120,N111))","v":7.7154596569932883},{"$f":"IF(O124=O$118,O117,IF('Inputs and assumptions'!$C$61=\"Flat\",O120,O111))","v":9.0594900329174788},{"$f":"IF(P124=P$118,P117,IF('Inputs and assumptions'!$C$61=\"Flat\",P120,P111))","v":9.9062223483469563},{"$f":"IF(Q124=Q$118,Q117,IF('Inputs and assumptions'!$C$61=\"Flat\",Q120,Q111))","v":7.9209740489374187},{"$f":"IF(R124=R$118,R117,IF('Inputs and assumptions'!$C$61=\"Flat\",R120,R111))","v":7.8774312335528176},{"$f":"IF(S124=S$118,S117,IF('Inputs and assumptions'!$C$61=\"Flat\",S120,S111))","v":7.8999250811535466},{"$f":"IF(T124=T$118,T117,IF('Inputs and assumptions'!$C$61=\"Flat\",T120,T111))","v":7.9165100843442824},{"$f":"IF(U124=U$118,U117,IF('Inputs and assumptions'!$C$61=\"Flat\",U120,U111))","v":8.6272049571889546},{"$f":"IF(V124=V$118,V117,IF('Inputs and assumptions'!$C$61=\"Flat\",V120,V111))","v":8.8832502498705264},{"$f":"IF(W124=W$118,W117,IF('Inputs and assumptions'!$C$61=\"Flat\",W120,W111))","v":9.8723237448332704},"ok"]
["T","Equilibrium number of taxis on the road","Taxis on the road",null,null,null,null,null,null,{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(J121,J118),MIN(J112,J118))","v":4441.6922853847236},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(K121,K118),MIN(K112,K118))","v":4475.411867058142},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(L121,L118),MIN(L112,L118))","v":4512.9736647141899},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(M121,M118),MIN(M112,M118))","v":4668.7285961140406},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(N121,N118),MIN(N112,N118))","v":4520.0548513604335},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(O121,O118),MIN(O112,O118))","v":3636.9315038309001},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(P121,P118),MIN(P112,P118))","v":3308.553482545788},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(Q121,Q118),MIN(Q112,Q118))","v":4094.1242091194895},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(R121,R118),MIN(R112,R118))","v":4327.9150437391982},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(S121,S118),MIN(S112,S118))","v":4489.7613081566842},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(T121,T118),MIN(T112,T118))","v":4717.6516433311735},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(U121,U118),MIN(U112,U118))","v":5025.83},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(V121,V118),MIN(V112,V118))","v":4769.4160501946881},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(W121,W118),MIN(W112,W118))","v":3367.4239769579785},"ok"]
["Difference between max effective and free entry (for info)",null,null,null,null,null,null,null,null,{"$f":"J112-J118","v":725.12274912452995},{"$f":"K112-K118","v":659.70017449363786},748.35331411606512,865.20562705680004,1052.0697650458314,-437.42849616910007,-765.8065174542121,-197.59579088051078,599.07771267132648,1060.7583530536149,1642.7159633750789,2707.0515867866607,2634.9678921505101,-924.29602304202172]
[]
[]
["MODEL OUTPUTS"]
[null,null,null,null,null,null,null,null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
[null,null,null,null,null,null,null,null,null,"Day","Day","Day","Day","Day","Day","Day","Night","Night","Night","Night","Night","Night","Night"]
["Revenue per taxi (excluding GST)",null,null,null,null,null,null,null,null,{"$f":"J122*J13/J124","v":243.11020353620506},{"$f":"K122*K13/K124","v":240.03341115454259},{"$f":"L122*L13/L124","v":244.8133944848791},251.82241537520036,260.35082479695069,223.11092281721088,{"$f":"P122*P13/P124","v":219.54101765228413},216.03357704707744,250.05403433677327,275.78352187653832,307.85100998748601,398.5474043413401,394.86134600203724,233.12451323773993,"ok"]
["Cost per taxi",null,null,null,null,null,null,null,null,{"$f":"J15+J16*J124+J14*J122/J124","v":213.05633117957325},{"$f":"K15+K16*K124+K14*K122/K124","v":212.83018604387451},213.99104110212761,216.59932808843209,216.72929580540543,223.11092281719817,219.54101765227639,216.03357704707622,223.89286486212694,229.70208536332547,237.17788893199139,274.89224836369414,270.52104217581825,{"$f":"W15+W16*W124+W14*W122/W124","v":233.12451323773979},"ok"]
["Surplus per taxi for average shift",null,null,null,null,null,null,null,null,{"$f":"J131-J132","v":30.053872356631814},27.203225110668086,{"$f":"L131-L132","v":30.822353382751487},35.223087286768276,43.621528991545262,1.2704504115390591E-11,7.73070496506989E-12,1.2221335055073723E-12,26.161169474646329,46.08143651321285,70.673121055494619,123.65515597764596,124.34030382621899,{"$f":"W131-W132","v":0},"ok"]
["Share of taxis on the road",null,null,null,null,null,null,null,null,{"$f":"J124/J6*100","v":82.851935933309534},{"$f":"K124/K6*100","v":83.480915259431868},{"$f":"L124/L6*100","v":84.181564348334078},87.08689789431152,84.313651396389361,67.840542880636079,61.715230041891211,72.500871420568259,76.640960576220976,79.507018030045757,83.542618086261271,89,84.459289006458079,59.632087426208223,"ok"]
["Free market taxis on the road as a proportion of maximum",null,null,null,null,null,null,null,null,{"$f":"J112/J118*100","v":116.32537110935235},{"$f":"K112/K118*100","v":114.74054666006157},{"$f":"L112/L118*100","v":116.5822663661269},118.5319323932632,123.27559730230226,89.263872211363264,81.204250055120013,95.395883448116123,113.84217819936086,123.6261636253692,134.82062872737131,153.86277663165407,155.2471804602358,78.463272929221347,"ok"]
["Average surplus accruing to shift (adjusted for distribution)",null,null,null,null,null,null,null,null,{"$f":"J133*J137+_xlfn.NORM.DIST(-1*(J135-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$C$137","v":36.461166429609968},{"$f":"K133*K137+_xlfn.NORM.DIST(-1*(K135-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$C$137","v":34.343249481653025},{"$f":"L133*L137+_xlfn.NORM.DIST(-1*(L135-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$C$137","v":37.038633553030515},{"$f":"M133*M137+_xlfn.NORM.DIST(-1*(M135-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$C$137","v":40.43136729854929},{"$f":"N133*N137+_xlfn.NORM.DIST(-1*(N135-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$C$137","v":47.282069551731894},{"$f":"O133*O137+_xlfn.NORM.DIST(-1*(O135-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$C$137","v":15.950806531038362},{"$f":"P133*P137+_xlfn.NORM.DIST(-1*(P135-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$C$137","v":13.194853238496282},{"$f":"Q133*Q137+_xlfn.NORM.DIST(-1*(Q135-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$C$137","v":17.192514766145258},{"$f":"R133*R137+_xlfn.NORM.DIST(-1*(R135-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$C$137","v":33.57692812411819},{"$f":"S133*S137+_xlfn.NORM.DIST(-1*(S135-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$C$137","v":49.326272955847678},{"$f":"T133*T137+_xlfn.NORM.DIST(-1*(T135-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$C$137","v":71.514122164211713},{"$f":"U133*U137+_xlfn.NORM.DIST(-1*(U135-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$C$137","v":123.43806803679196},{"$f":"V133*V137+_xlfn.NORM.DIST(-1*(V135-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$C$137","v":124.17190935671084},{"$f":"W133*W137+_xlfn.NORM.DIST(-1*(W135-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$C$137","v":12.082107327488385},"can't check"]
["Percentage of shifts where surplus accrues",null,{"$f":"STDEV(J135:W135)/STDEV(J133:W133)","v":0.57148940730586595},null,null,null,null,null,null,{"$f":"(1-_xlfn.NORM.DIST(-1*(J135-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.74272256222955624},{"$f":"(1-_xlfn.NORM.DIST(-1*(K135-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.72189842089169864},{"$f":"(1-_xlfn.NORM.DIST(-1*(L135-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.7460201087558026},{"$f":"(1-_xlfn.NORM.DIST(-1*(M135-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.77030596043765664},{"$f":"(1-_xlfn.NORM.DIST(-1*(N135-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.82361694644038463},{"$f":"(1-_xlfn.NORM.DIST(-1*(O135-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.3340995162556859},{"$f":"(1-_xlfn.NORM.DIST(-1*(P135-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.22651074117666092},{"$f":"(1-_xlfn.NORM.DIST(-1*(Q135-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.42708075972587878},{"$f":"(1-_xlfn.NORM.DIST(-1*(R135-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.70973976822721974},{"$f":"(1-_xlfn.NORM.DIST(-1*(S135-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.82721914944554498},{"$f":"(1-_xlfn.NORM.DIST(-1*(T135-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.91775870114258584},{"$f":"(1-_xlfn.NORM.DIST(-1*(U135-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.98423728583369285},{"$f":"(1-_xlfn.NORM.DIST(-1*(V135-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.98629562355630018},{"$f":"(1-_xlfn.NORM.DIST(-1*(W135-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.19494524236383648},"can't check"]
["Surplus (basic)",null,"$/taxi",null,null,null,null,null,null,{"$f":"SUMPRODUCT(J134:W134,J133:W133)*365/7/100","v":24601.542399461199}]
["Surplus accounting for shift variation",null,"$/taxi",null,null,null,null,null,null,{"$f":"SUMPRODUCT(J134:W134,J136:W136)*365/7/100","v":28323.946820452955}]
["Occupancy rate of taxis (time)",null,null,null,null,null,null,null,null,{"$f":"J122*J18/J124","v":0.27085269950832536},{"$f":"K122*K18/K124","v":0.26742479927921869},0.27275024991763097,0.28055910450884131,0.29006073249809727,0.24857120291882634,0.24459391839170805,0.23653856693905367,0.27378810158968964,0.30195972284375988,0.33707092077317136,0.42898331581151022,0.41562772604897014,0.25525170222776467,"ok - see check in previous version"]
["Revenue per taxi (including GST)",null,{"$f":"(U141-(U142*1.99)*'Inputs and assumptions'!C27)/10/60","v":0.66848214703917541},null,null,null,null,null,null,{"$f":"J131*$B$20","v":267.42122388982557},{"$f":"K131*$B$20","v":264.0367522699969},269.29473393336701,277.00465691272041,286.38590727664581,245.42201509893198,241.49511941751257,237.63693475178522,275.05943777045064,303.36187406419219,338.63611098623466,438.40214477547414,434.34748060224098,256.43696456151395,"ok - GST no longer hard-coded"]
["Occupied kms per shift",null,null,null,null,null,null,null,null,{"$f":"J131/J13","v":86.672863842664114},{"$f":"K131/K13","v":85.575935769349982},87.280079973641932,89.778913442829221,92.819434399391113,79.542784934024411,78.27005388534657,75.692341420497186,87.612192508700673,96.627111310003144,107.86269464741483,137.27466105968327,133.00087233567044,81.680544712884682,"ok - formula simplified"]
[]
["MODEL VALIDATION"]
[]
["Model validation",null,null,null,null,null,null,null,null,null,null,null,"Source/Notes"]
[null,"Model","Data",null,null,null,null,null,null,"Difference (per cent)"]
["Average occupancy",{"$f":"SUMPRODUCT(J140:W140,J134:W134)/SUM(J134:W134)","v":0.2984975214086924},0.3,null,null,null,null,null,null,{"$f":"B148/C148*100-100","v":-0.50082619710252629}]
["Kilometres per year",{"$f":"'Inputs and assumptions'!C53*B150","v":108952.69995011047},107000,null,null,null,null,null,null,{"$f":"B149/C149*100-100","v":1.8249532244023072},null,null,"Average kilometres from CIE 2012 survey"]
["Occupied kilometres per taxi per year",{"$f":"SUMPRODUCT(J142:W142,J134:W134)/100*365/7","v":54625.395409429038},"NA"]
["Average revenue per taxi per year (excluding GST)",{"$f":"B152+B153","v":159395.02134555695},{"$f":"152556*(1+'Inputs and assumptions'!C31)","v":158200.57199999999},null,null,null,null,null,null,{"$f":"B151/C151*100-100","v":0.75502214085354069},null,null,"Average revenue from CIE 2012 survey, escalated by IPART 2012 price increase."]
["Average cost per taxi per year (excluding plate lease costs)",{"$f":"SUMPRODUCT(J132:W132,J134:W134)/100*365/7","v":131071.07452510398},{"$f":"(C151)-C153","v":130045.57199999999},null,null,null,null,null,null,{"$f":"B152/C152*100-100","v":0.78857165940566176},null,null,"From CIE survey, escalated by IPART 2012 price increase."]
["Plate lease costs",{"$f":"J139","v":28323.946820452955},28155,null,null,null,null,null,null,{"$f":"B153/C153*100-100","v":0.60005974232979042}]
[{"$f":"\"Peak plate lease costs driving \"&'Inputs and assumptions'!C64*100&\"% of peak days\"","v":"Peak plate lease costs driving 90% of peak days"},{"$f":"(SUM($Q$136:$W$136)+'Inputs and assumptions'!$C$63*SUM('Base model'!$Q$131:$W$131))*365/7*'Inputs and assumptions'!$C$64-('Inputs and assumptions'!$C$30*(1-'Inputs and assumptions'!$C$64*365/'Inputs and assumptions'!$C$46))","v":21398.962439016403},{"$f":"26786.36/34651.92*C153","v":21764.160998871059},null,null,null,null,null,null,{"$f":"B154/C154*100-100","v":-1.6779813376385135}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Sim_template","index":4,"n_rows":185,"n_cols":23,"rows_kept":185,"cut":false,"hidden":false,"merged":[[133,9,133,15],[133,16,133,22],[172,1,172,2],[173,1,173,2],[30,9,31,9],[30,11,31,11],[3,1,4,2],[3,7,4,8],[3,13,4,14],[6,1,7,5],[6,7,7,8],[13,13,14,16],[14,1,15,5],[16,13,17,15],[17,8,18,10],[23,9,24,9],[23,11,24,11],[24,1,25,5]]}
[]
[]
[]
[null,"step 1",null,null,null,null,null,"step 2",null,null,null,null,null,"step 3"]
[]
[]
[null,"Number of licences",null,null,null,null,null,"Refine fares"]
[null,null,null,null,null,null,null,null,null,null,null,"do not use this cell"]
[null,"Change in unrestricted licences",null,null,"No.",null,null,"Actual average fare increase",null,null,"nominal",{"$f":"SUMPRODUCT(D151:Q155,Sim_template!D181:Q185)/C145*100-100","v":1.3975713438449304},"%"]
[]
[null,"Change in peak availability licences",null,null,"No.",250,null,null,null,null,null,"GST inclusive"]
[null,null,null,null,null,null,null,"Flagfall",null,null,"$/trip",{"$f":"R36","v":3.5}]
[null,"Note: Do not include replacement licences here"]
[null,null,null,null,null,null,null,"Standard kilometre charge",null,null,"$/km",2.14,null,"Summary of model outputs"]
[null,"Forecasts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"See outputs for each shift"]
[null,null,null,null,null,null,null,"Waiting time",null,null,"$/hr",{"$f":"R40","v":55.3}]
[null,"Change in demand",null,null,"%",2.5000000000000001E-2,null,null,null,null,"$/min",{"$f":"L16/60","v":0.92166666666666663},null,null,null,null,"Difference ",null,"2013/14","2012/13"]
[null,null,null,null,null,null,null,null,"Charged when the taxi speed falls below (km/h)",null,null,{"$f":"L16/L14","v":25.841121495327101}]
[null,"CPI",null,null,"%",2.5000000000000001E-2,null,null,null,null,null,null,null,"Plate lease costs ",null,null,{"$f":"S19/T19-1","v":-1.5418202863484609E-2},"$2012/13 (ex GST)",{"$f":"J62","v":27887.242462480663},{"$f":"'Base model'!B153","v":28323.946820452955},null,{"$f":"\"Note: Nominal reduction is: \"& ROUND((1+Q19/100)*(1+$F$19)*100-100,1) & \"%\"","v":"Note: Nominal reduction is: 2.5%"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total trips ",null,null,{"$f":"S20/T20-1","v":3.753318629987068E-2},"000,000",{"$f":"SUM(J122:W122)*365/7/1000000/7","v":44.670177307513434},{"$f":"SUM('Base model'!J122:W122)*365/7/1000000/7","v":43.054215419190207}]
[null,"Real change in costs",null,null,"%",0,null,"Booking fee ",null,null,"($/booking)",{"$f":"R41","v":2.4},null,"Average occupancy",null,null,{"$f":"S21/T21-1","v":1.5116990441735867E-2},"%",{"$f":"SUMPRODUCT(J63:W63,J57:W57)/SUM(J57:W57)","v":0.30300990558670948},{"$f":"'Base model'!B148","v":0.2984975214086924}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Average annual revenue per taxi",null,null,{"$f":"S22/T22-1","v":1.5059005159447914E-3},"$2012/13 (ex GST)",{"$f":"S25+S19","v":159635.05439044026},{"$f":"'Base model'!B151","v":159395.02134555695}]
[null,null,null,null,null,null,null,"Surcharges",null,null,null,null,null,"Average waiting time Fri and Sat nights ",null,null,{"$f":"S23/T23-1","v":-6.3517714362816946E-2},"mins",{"$f":"AVERAGE(U123:V123)","v":8.1991155574272874},{"$f":"AVERAGE('Base model'!U123:V123)","v":8.7552276035297396}]
[null,null,null,null,null,null,null,null,null,"Flag fall surcharge",null,"Distance surcharge"]
[null,"Average fare change target",null,null,null,null,null,null,null,null,null,null,null,"Average cost per taxi per year (excluding plate lease costs)",null,null,{"$f":"S25/T25-1","v":5.1631330963568534E-3},"$2012/13",{"$f":"SUMPRODUCT(J55:W55,J57:W57)/100*365/7","v":131747.81192795958},{"$f":"'Base model'!B152","v":131071.07452510398}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Average waiting time",null,null,{"$f":"S26/T26-1","v":-1.46011293578866E-2},"mins",{"$f":"AVERAGE(J123:W123)","v":8.1499468622623947},{"$f":"AVERAGE('Base model'!J123:W123)","v":8.2707085476479811}]
[null,"Nominal fare increase sought",null,null,null,1.4,"%","Level ","$ per trip",2.5,"% per km",0.2,null,"Occupied kilometres per taxi per year",null,null,{"$f":"S27/T27-1","v":1.3672356243608963E-2},"km",{"$f":"SUMPRODUCT(J65:W65,J57:W57)/100*365/7","v":55372.253275414754},{"$f":"'Base model'!B150","v":54625.395409429038},null,{"$f":"\"Note: Nominal reduction is: \"& ROUND((1+Q28/100)*(1+$F$19)*100-100,1) & \"%\"","v":"Note: Nominal reduction is: 2.5%"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Peak plate costs",null,null,{"$f":"S28/T28-1","v":-4.7964367874716807E-2},"$2012/13 (ex GST)",{"$f":"(SUM($Q$59:$W$59)+'Inputs and assumptions'!$C$63*SUM($Q$54:$W$54))*365/7*'Inputs and assumptions'!$C$64-('Inputs and assumptions'!$C$30*(1-'Inputs and assumptions'!$C$64*365/'Inputs and assumptions'!$C$46))","v":20372.574732454173},{"$f":"'Base model'!B154","v":21398.962439016403}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((L14*(1+L27)),2)","v":2.57},"per kilometre",null,"Kilometres per year",null,null,{"$f":"S29/T29-1","v":1.3672356243608963E-2},"km",{"$f":"'Inputs and assumptions'!C53*S27","v":110442.34007753142},{"$f":"'Base model'!B149","v":108952.69995011047}]
[]
[null,null,null,null,null,null,null,"Hours of operation",null,"10 pm until 6 am",null,"10 pm until 6 am"]
[]
[null,null,null,null,null,null,null,"Shifts that it applies",null,null,null,null,null,"Fare schedule"]
[null,null,null,null,null,null,null,"(only applies during the hours specified above)",null,null,null,null,null,null,null,null,"Dfiference","2012/13","2013/14"]
[null,null,null,null,null,null,null,"Monday ","3 am - 3 pm","No",null,"Yes"]
[null,null,null,null,null,null,null,"Tuesday","3 am - 3 pm","No",null,"Yes",null,"Flagfall ($)",null,null,{"$f":"L12/R36-1","v":0},{"$f":"'Inputs and assumptions'!C15","v":3.5},{"$f":"L12","v":3.5}]
[null,null,null,null,null,null,null,"Wednesday","3 am - 3 pm","No",null,"Yes",null,"Flagfall surcharge ($)",null,null,null,null,{"$f":"J27","v":2.5}]
[null,null,null,null,null,null,null,"Thursday","3 am - 3 pm","No",null,"Yes",null,"Standard kilometre charge ($/km)",null,null,{"$f":"L14/R38-1","v":0},{"$f":"'Inputs and assumptions'!C16","v":2.14},{"$f":"L14","v":2.14}]
[null,null,null,null,null,null,null,"Friday","3 am - 3 pm","No",null,"Yes",null,"Night kilometre charge ($/km)",null,null,{"$f":"K29/R39-1","v":0},{"$f":"'Inputs and assumptions'!C17","v":2.57},{"$f":"K29","v":2.57}]
[null,null,null,null,null,null,null,"Saturday","3 am - 3 pm","Yes",null,"Yes",null,"Waiting time ($/hour when vehicle slower than 26km/hour)",null,null,{"$f":"L16/R40-1","v":0},{"$f":"'Inputs and assumptions'!C18","v":55.3},{"$f":"L16","v":55.3}]
[null,null,null,null,null,null,null,"Sunday","3 am - 3 pm","Yes",null,"Yes",null,"Booking fee ($/booking)",null,null,{"$f":"L21/R41-1","v":0},{"$f":"'Inputs and assumptions'!C19","v":2.4},{"$f":"L21","v":2.4}]
[null,null,null,null,null,null,null,"Monday","3 pm - 3 am","No",null,"Yes"]
[null,null,null,null,null,null,null,"Tuesday","3 pm - 3 am","No",null,"Yes"]
[null,null,null,null,null,null,null,"Wednesday","3 pm - 3 am","No",null,"Yes"]
[null,null,null,null,null,null,null,"Thursday","3 pm - 3 am","No",null,"Yes"]
[null,null,null,null,null,null,null,"Friday","3 pm - 3 am","Yes",null,"Yes"]
[null,null,null,null,null,null,null,"Saturday","3 pm - 3 am","Yes",null,"Yes"]
[null,null,null,null,null,null,null,"Sunday","3 pm - 3 am","No",null,"Yes"]
[]
[]
[null,"MODEL OUTPUTS FOR EACH SHIFT"]
[null,null,null,null,null,null,null,null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
[null,null,null,null,null,null,null,null,null,"Day","Day","Day","Day","Day","Day","Day","Night","Night","Night","Night","Night","Night","Night"]
[null,"Revenue per taxi (excluding GST)",null,null,null,null,null,null,null,{"$f":"J122*J98/J124","v":247.22695468671893},244.10736383871449,248.95304731800641,256.05699020456746,264.71468346026057,224.46355047532091,220.84531576142624,217.69063537494668,245.73467734878255,271.01180266305425,302.50730189349503,396.61956034108988,394.87907492698145,234.77584702457793]
[null,"Cost per taxi",null,null,null,null,null,null,null,{"$f":"J100+J101*J124+J99*J122/J124","v":214.82730888940733},214.58039166868414,215.77337806303936,218.42853029464166,218.61795463189068,224.46355053428249,220.84531582436517,217.69063542733443,225.92262652200509,231.82637848307564,239.42900838010129,275.3212930023389,269.96707773914778,234.77584709040678]
[null,"Surplus per taxi",null,null,null,null,null,null,null,{"$f":"J54-J55","v":32.399645797311592},29.526972170030348,33.179669254967052,37.628459909925795,46.096728828369891,-5.8961575177818304E-8,-6.2938937617218471E-8,-5.2387747473403579E-8,19.812050826777465,39.185424179978611,63.078293513393731,121.29826733875097,124.91199718783366,{"$f":"W54-W55","v":-6.5828857032101951E-8}]
[null,"Share of taxis on the road",null,null,null,null,null,"%",null,{"$f":"J124/('Base model'!J6+$F$9)*100","v":82.851935933309534},{"$f":"K124/('Base model'!K6+$F$9)*100","v":83.480915259431868},{"$f":"L124/('Base model'!L6+$F$9)*100","v":84.181564348334078},{"$f":"M124/('Base model'!M6+$F$9)*100","v":87.08689789431152},{"$f":"N124/('Base model'!N6+$F$9)*100","v":84.313651396389361},{"$f":"O124/('Base model'!O6+$F$9)*100","v":69.101523475431193},{"$f":"P124/('Base model'!P6+$F$9)*100","v":62.910370644101299},{"$f":"Q124/('Base model'!Q6+$F$9+$F$11)*100","v":70.291964463644078},{"$f":"R124/('Base model'!R6+$F$9+$F$11)*100","v":76.640960576220976},{"$f":"S124/('Base model'!S6+$F$9+$F$11)*100","v":79.507018030045757},{"$f":"T124/('Base model'!T6+$F$9+$F$11)*100","v":83.542618086261271},{"$f":"U124/('Base model'!U6+$F$9+$F$11)*100","v":89},{"$f":"V124/('Base model'!V6+$F$9+$F$11)*100","v":84.459289006458079},{"$f":"W124/('Base model'!W6+$F$9+$F$11)*100","v":57.824060248477963}]
[null,"Free market taxis on the road as a proportion of maximum",null,null,null,null,null,"%",null,{"$f":"J112/J118*100","v":117.57943545884109},114.13024421243752,117.83039433458143,119.77708333336183,124.57502092047137,90.92305720451472,82.776803479080655,92.489426925847468,110.27212735700942,119.6891084663344,130.46051589536819,151.48799946953923,153.98881895602409,76.084289800628895]
[null,"Average surplus accruing to shift (adjusted for distribution)",null,null,null,null,null,null,null,{"$f":"J56*J60+_xlfn.NORM.DIST(-1*(J58-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$60","v":38.246984551430437},{"$f":"K56*K60+_xlfn.NORM.DIST(-1*(K58-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$60","v":35.9856128432479},{"$f":"L56*L60+_xlfn.NORM.DIST(-1*(L58-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$60","v":38.845564152526087},{"$f":"M56*M60+_xlfn.NORM.DIST(-1*(M58-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$60","v":42.345207751852264},{"$f":"N56*N60+_xlfn.NORM.DIST(-1*(N58-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$60","v":49.376310171113801},{"$f":"O56*O60+_xlfn.NORM.DIST(-1*(O58-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$60","v":16.374207742112311},{"$f":"P56*P60+_xlfn.NORM.DIST(-1*(P58-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$60","v":13.80411148132778},{"$f":"Q56*Q60+_xlfn.NORM.DIST(-1*(Q58-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$60","v":16.716787404494447},{"$f":"R56*R60+_xlfn.NORM.DIST(-1*(R58-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$60","v":29.133966866862181},{"$f":"S56*S60+_xlfn.NORM.DIST(-1*(S58-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$60","v":43.562811042983796},{"$f":"T56*T60+_xlfn.NORM.DIST(-1*(T58-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$60","v":64.362299276189049},{"$f":"U56*U60+_xlfn.NORM.DIST(-1*(U58-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$60","v":120.99718875717355},{"$f":"V56*V60+_xlfn.NORM.DIST(-1*(V58-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$60","v":124.68114068968859},{"$f":"W56*W60+_xlfn.NORM.DIST(-1*(W58-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$60","v":11.084556480594477}]
[null,"Percentage of shifts where surplus accrues",null,null,null,null,null,{"$f":"'Base model'!C137","v":0.57148940730586595},null,{"$f":"(1-_xlfn.NORM.DIST(-1*(J58-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.7586068054672277},{"$f":"(1-_xlfn.NORM.DIST(-1*(K58-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.71366552631927926},{"$f":"(1-_xlfn.NORM.DIST(-1*(L58-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.76172028883712273},{"$f":"(1-_xlfn.NORM.DIST(-1*(M58-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.78510916098853567},{"$f":"(1-_xlfn.NORM.DIST(-1*(N58-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.83673186739341832},{"$f":"(1-_xlfn.NORM.DIST(-1*(O58-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.35853367062577768},{"$f":"(1-_xlfn.NORM.DIST(-1*(P58-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.24585050861322899},{"$f":"(1-_xlfn.NORM.DIST(-1*(Q58-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.38214714744866396},{"$f":"(1-_xlfn.NORM.DIST(-1*(R58-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.65913246998938135},{"$f":"(1-_xlfn.NORM.DIST(-1*(S58-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.78408179914882215},{"$f":"(1-_xlfn.NORM.DIST(-1*(T58-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.88802326663590303},{"$f":"(1-_xlfn.NORM.DIST(-1*(U58-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.98008790837242676},{"$f":"(1-_xlfn.NORM.DIST(-1*(V58-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.98443506838380823},{"$f":"(1-_xlfn.NORM.DIST(-1*(W58-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.169841267514381}]
[null,"Surplus (basic)",null,null,null,null,null,"$/taxi",null,{"$f":"SUMPRODUCT(J57:W57,J56:W56)*365/7/100","v":24170.89377109929}]
[null,"Surplus accounting for shift variation",null,null,null,null,null,"$/taxi",null,{"$f":"SUMPRODUCT(J57:W57,J59:W59)*365/7/100","v":27887.242462480663}]
[null,"Occupancy rate of taxis (time)",null,null,null,null,null,null,null,{"$f":"J122*J103/J124","v":0.28231510497843898},{"$f":"K122*K103/K124","v":0.27875276033499125},{"$f":"L122*L103/L124","v":0.28428617655120481},0.29239835988623675,0.3022848125323464,0.25338804456573788,0.24930356217653837,0.24429324372638148,0.27576437232677886,0.30413045672203037,0.33947482354118114,0.41879934610888309,0.39974262275270106,0.26346633202414538]
[null,"Revenue per taxi (including GST)",null,null,null,null,null,null,null,{"$f":"J54*$D$105","v":271.94965015539083},268.51810022258599,273.84835204980709,281.66268922502422,291.18615180628666,246.90990552285302,242.92984733756887,239.45969891244135,270.3081450836608,298.1129829293597,332.75803208284458,436.28151637519892,434.36698241967963,258.25343172703572]
[null,"Occupied kms per shift",null,null,null,null,null,null,null,{"$f":"J54/J98","v":90.340833593100484},89.200883307197188,90.971576496385524,93.567475163595745,96.731140010350842,81.084174261036125,79.777139896492272,78.17383799244206,88.244599144569221,97.321746151049709,108.63194353317797,134.01579075484258,127.91763928086434,84.309226247726514]
[]
[null,"Difference in revenue per taxi per shift (nominal)",null,null,null,null,null,null,null,{"$f":"J64-'Base model'!J141","v":4.5284262655652583},{"$f":"K64-'Base model'!K141","v":4.4813479525890898},{"$f":"L64-'Base model'!L141","v":4.5536181164400773},{"$f":"M64-'Base model'!M141","v":4.658032312303817},{"$f":"N64-'Base model'!N141","v":4.8002445296408496},{"$f":"O64-'Base model'!O141","v":1.4878904239210442},{"$f":"P64-'Base model'!P141","v":1.4347279200563037},{"$f":"Q64-'Base model'!Q141","v":1.8227641606561349},{"$f":"R64-'Base model'!R141","v":-4.7512926867898386},{"$f":"S64-'Base model'!S141","v":-5.2488911348324905},{"$f":"T64-'Base model'!T141","v":-5.878078903390076},{"$f":"U64-'Base model'!U141","v":-2.1206284002752227},{"$f":"V64-'Base model'!V141","v":1.9501817438651869E-2},{"$f":"W64-'Base model'!W141","v":1.8164671655217717}]
[null,"Difference in costs per taxi per shift (nominal)",null,null,null,null,null,null,null,{"$f":"J55-'Base model'!J132","v":1.7709777098340851},{"$f":"K55-'Base model'!K132","v":1.750205624809638},{"$f":"L55-'Base model'!L132","v":1.7823369609117492},{"$f":"M55-'Base model'!M132","v":1.8292022062095725},{"$f":"N55-'Base model'!N132","v":1.8886588264852548},{"$f":"O55-'Base model'!O132","v":1.3526277170843173},{"$f":"P55-'Base model'!P132","v":1.3042981720887781},{"$f":"Q55-'Base model'!Q132","v":1.6570583802582064},{"$f":"R55-'Base model'!R132","v":2.0297616598781474},{"$f":"S55-'Base model'!S132","v":2.1242931197501775},{"$f":"T55-'Base model'!T132","v":2.2511194481099039},{"$f":"U55-'Base model'!U132","v":0.42904463864476838},{"$f":"V55-'Base model'!V132","v":-0.55396443667046924},{"$f":"W55-'Base model'!W132","v":1.6513338526669941}]
[]
[null,"Difference in surplus per taxi (accruing to the licence owner)",null,null,null,null,null,null,null,{"$f":"J56-'Base model'!J133","v":2.3457734406797783},{"$f":"K56-'Base model'!K133","v":2.3237470593622618},{"$f":"L56-'Base model'!L133","v":2.3573158722155654},{"$f":"M56-'Base model'!M133","v":2.4053726231575183},{"$f":"N56-'Base model'!N133","v":2.4751998368246291},{"$f":"O56-'Base model'!O133","v":-5.8974279681933695E-8},{"$f":"P56-'Base model'!P133","v":-6.2946668322183541E-8},{"$f":"Q56-'Base model'!Q133","v":-5.2388969606909086E-8},{"$f":"R56-'Base model'!R133","v":-6.3491186478688633},{"$f":"S56-'Base model'!S133","v":-6.8960123332342391},{"$f":"T56-'Base model'!T133","v":-7.5948275421008873},{"$f":"U56-'Base model'!U133","v":-2.3568886388949863},{"$f":"V56-'Base model'!V133","v":0.57169336161467754},{"$f":"W56-'Base model'!W133","v":-6.5828857032101951E-8}]
[null,"Difference in the number of taxis on the road",null,null,null,null,null,null,null,{"$f":"J124-'Base model'!J124","v":0},{"$f":"K124-'Base model'!K124","v":0},{"$f":"L124-'Base model'!L124","v":0},{"$f":"M124-'Base model'!M124","v":0},{"$f":"N124-'Base model'!N124","v":0},{"$f":"O124-'Base model'!O124","v":67.601169686965932},{"$f":"P124-'Base model'!P124","v":64.07148768448269},{"$f":"Q124-'Base model'!Q124","v":50.992935301601847},{"$f":"R124-'Base model'!R124","v":191.60240144055297},{"$f":"S124-'Base model'!S124","v":198.76754507511396},{"$f":"T124-'Base model'!T124","v":208.85654521565357},{"$f":"U124-'Base model'!U124","v":222.5},{"$f":"V124-'Base model'!V124","v":211.14822251614532},{"$f":"W124-'Base model'!W124","v":42.460855894767064}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W71/('Base model'!W6+$F$9+$F$11)","v":7.200416465112271E-3}]
[null,"Additional taxis on the road",null,null,null,null,null,null,null,null,"Revenue per taxi"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CALIBRATION OF MODEL PARAMETERS"]
[null,"Day",null,"Description",null,null,null,"Unit",null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
[null,"Shift",null,null,null,null,null,null,null,"Day","Day","Day","Day","Day","Day","Day","Night","Night","Night","Night","Night","Night","Night"]
[]
[null,null,null,"Demand intercept with y axis",null,null,null,"Kms occupied",null,{"$f":"'Base model'!J10*(1+$F$17)","v":769523.50783341401},{"$f":"'Base model'!K10*(1+$F$17)","v":764111.64728360437},{"$f":"'Base model'!L10*(1+$F$17)","v":785741.57490349107},{"$f":"'Base model'!M10*(1+$F$17)","v":833226.50343408808},{"$f":"'Base model'!N10*(1+$F$17)","v":841530.72133924952},{"$f":"'Base model'!O10*(1+$F$17)","v":596590.95213797188},{"$f":"'Base model'!P10*(1+$F$17)","v":543790.80278892419},{"$f":"'Base model'!Q10*(1+$F$17)","v":627467.3062266293},{"$f":"'Base model'!R10*(1+$F$17)","v":767072.37907546666},{"$f":"'Base model'!S10*(1+$F$17)","v":878039.80444212479},{"$f":"'Base model'!T10*(1+$F$17)","v":1030233.7882265936},{"$f":"'Base model'!U10*(1+$F$17)","v":1385781.083630116},{"$f":"'Base model'!V10*(1+$F$17)","v":1278102.1915752632},{"$f":"'Base model'!W10*(1+$F$17)","v":562735.85758626473}]
[null,null,null,"Impact of price on demand kilometres",null,null,null,"Change in Q per extra dollar",null,{"$f":"'Base model'!J11*(1+$F$17)","v":111885.49135808527},{"$f":"'Base model'!K11*(1+$F$17)","v":111098.62952655827},{"$f":"'Base model'!L11*(1+$F$17)","v":114243.53030626877},{"$f":"'Base model'!M11*(1+$F$17)","v":121147.63980606529},{"$f":"'Base model'!N11*(1+$F$17)","v":122613.35997222667},{"$f":"'Base model'!O11*(1+$F$17)","v":86924.95629185396},{"$f":"'Base model'!P11*(1+$F$17)","v":79247.194949803539},{"$f":"'Base model'!Q11*(1+$F$17)","v":90595.484214061478},{"$f":"'Base model'!R11*(1+$F$17)","v":110752.054999459},{"$f":"'Base model'!S11*(1+$F$17)","v":126773.84216401467},{"$f":"'Base model'!T11*(1+$F$17)","v":148748.03511175202},{"$f":"'Base model'!U11*(1+$F$17)","v":192814.71666822385},{"$f":"'Base model'!V11*(1+$F$17)","v":174255.04982665888},{"$f":"'Base model'!W11*(1+$F$17)","v":78894.480076401524}]
[null,null,null,"Impact of waiting time on demand kilometres",null,null,null,"Change in Q per extra minute",null,{"$f":"'Base model'!J12*(1+$F$17)","v":7991.8208112918046},{"$f":"'Base model'!K12*(1+$F$17)","v":7935.6163947541609},{"$f":"'Base model'!L12*(1+$F$17)","v":8160.2521647334834},{"$f":"'Base model'!M12*(1+$F$17)","v":8653.4028432903779},{"$f":"'Base model'!N12*(1+$F$17)","v":8758.097140873333},{"$f":"'Base model'!O12*(1+$F$17)","v":6208.9254494181387},{"$f":"'Base model'!P12*(1+$F$17)","v":5660.5139249859667},{"$f":"'Base model'!Q12*(1+$F$17)","v":6471.1060152901055},{"$f":"'Base model'!R12*(1+$F$17)","v":7910.8610713899288},{"$f":"'Base model'!S12*(1+$F$17)","v":9055.2744402867611},{"$f":"'Base model'!T12*(1+$F$17)","v":10624.859650839431},{"$f":"'Base model'!U12*(1+$F$17)","v":13772.479762015988},{"$f":"'Base model'!V12*(1+$F$17)","v":12446.789273332777},{"$f":"'Base model'!W12*(1+$F$17)","v":5635.3200054572508}]
[null,"P",null,"Price per kilometre of demand (excluding GST)",null,null,null,"$/km occupied (real 2012/13)",null,{"$f":"SUMPRODUCT(Sim_template!D151:D155,Sim_template!D181:D185)/Sim_template!D164/'Base model'!$B$20/(1+$F$19)","v":2.7366025401120515},{"$f":"SUMPRODUCT(Sim_template!E151:E155,Sim_template!E181:E185)/Sim_template!E164/'Base model'!$B$20/(1+$F$19)","v":2.7366025401120511},{"$f":"SUMPRODUCT(Sim_template!F151:F155,Sim_template!F181:F185)/Sim_template!F164/'Base model'!$B$20/(1+$F$19)","v":2.7366025401120515},{"$f":"SUMPRODUCT(Sim_template!G151:G155,Sim_template!G181:G185)/Sim_template!G164/'Base model'!$B$20/(1+$F$19)","v":2.736602540112052},{"$f":"SUMPRODUCT(Sim_template!H151:H155,Sim_template!H181:H185)/Sim_template!H164/'Base model'!$B$20/(1+$F$19)","v":2.7366025401120511},{"$f":"SUMPRODUCT(Sim_template!I151:I155,Sim_template!I181:I185)/Sim_template!I164/'Base model'!$B$20/(1+$F$19)","v":2.7682781815437907},{"$f":"SUMPRODUCT(Sim_template!J151:J155,Sim_template!J181:J185)/Sim_template!J164/'Base model'!$B$20/(1+$F$19)","v":2.7682781815437907},{"$f":"SUMPRODUCT(Sim_template!K151:K155,Sim_template!K181:K185)/Sim_template!K164/'Base model'!$B$20/(1+$F$19)","v":2.7846993439927212},{"$f":"SUMPRODUCT(Sim_template!L151:L155,Sim_template!L181:L185)/Sim_template!L164/'Base model'!$B$20/(1+$F$19)","v":2.7846993439927212},{"$f":"SUMPRODUCT(Sim_template!M151:M155,Sim_template!M181:M185)/Sim_template!M164/'Base model'!$B$20/(1+$F$19)","v":2.7846993439927212},{"$f":"SUMPRODUCT(Sim_template!N151:N155,Sim_template!N181:N185)/Sim_template!N164/'Base model'!$B$20/(1+$F$19)","v":2.7846993439927212},{"$f":"SUMPRODUCT(Sim_template!O151:O155,Sim_template!O181:O185)/Sim_template!O164/'Base model'!$B$20/(1+$F$19)","v":2.9594987136003468},{"$f":"SUMPRODUCT(Sim_template!P151:P155,Sim_template!P181:P185)/Sim_template!P164/'Base model'!$B$20/(1+$F$19)","v":3.0869790683047169},{"$f":"SUMPRODUCT(Sim_template!Q151:Q155,Sim_template!Q181:Q185)/Sim_template!Q164/'Base model'!$B$20/(1+$F$19)","v":2.7846993439927212}]
[null,"c",null,"Variable cost",null,null,null,"$/km occupied",null,{"$f":"'Base model'!J14*(1+$F$21)","v":0.48282233233340882},{"$f":"'Base model'!K14*(1+$F$21)","v":0.48282233233340882},{"$f":"'Base model'!L14*(1+$F$21)","v":0.48282233233340882},{"$f":"'Base model'!M14*(1+$F$21)","v":0.48282233233340882},{"$f":"'Base model'!N14*(1+$F$21)","v":0.48282233233340882},{"$f":"'Base model'!O14*(1+$F$21)","v":0.48282233233340882},{"$f":"'Base model'!P14*(1+$F$21)","v":0.48282233233340882},{"$f":"'Base model'!Q14*(1+$F$21)","v":0.48282233233340882},{"$f":"'Base model'!R14*(1+$F$21)","v":0.48282233233340882},{"$f":"'Base model'!S14*(1+$F$21)","v":0.48282233233340882},{"$f":"'Base model'!T14*(1+$F$21)","v":0.48282233233340882},{"$f":"'Base model'!U14*(1+$F$21)","v":0.48282233233340882},{"$f":"'Base model'!V14*(1+$F$21)","v":0.48282233233340882},{"$f":"'Base model'!W14*(1+$F$21)","v":0.48282233233340882}]
[null,null,null,"Fixed component of shift costs",null,null,null,"$/taxi/shift",null,{"$f":"'Base model'!J15*(1+$F$21)","v":131.23350634057968},{"$f":"'Base model'!K15*(1+$F$21)","v":131.23350634057968},{"$f":"'Base model'!L15*(1+$F$21)","v":131.23350634057968},{"$f":"'Base model'!M15*(1+$F$21)","v":131.23350634057968},{"$f":"'Base model'!N15*(1+$F$21)","v":131.23350634057968},{"$f":"'Base model'!O15*(1+$F$21)","v":151.97350634057969},{"$f":"'Base model'!P15*(1+$F$21)","v":151.97350634057969},{"$f":"'Base model'!Q15*(1+$F$21)","v":142.64050634057969},{"$f":"'Base model'!R15*(1+$F$21)","v":142.64050634057969},{"$f":"'Base model'!S15*(1+$F$21)","v":142.64050634057969},{"$f":"'Base model'!T15*(1+$F$21)","v":142.64050634057969},{"$f":"'Base model'!U15*(1+$F$21)","v":163.3805063405797},{"$f":"'Base model'!V15*(1+$F$21)","v":163.3805063405797},{"$f":"'Base model'!W15*(1+$F$21)","v":163.3805063405797}]
[null,null,null,"Variable component of fixed costs",null,null,null,"$/additional taxi per shift",null,{"$f":"'Base model'!J16*(1+$F$21)","v":8.9999999999999993E-3},{"$f":"'Base model'!K16*(1+$F$21)","v":8.9999999999999993E-3},{"$f":"'Base model'!L16*(1+$F$21)","v":8.9999999999999993E-3},{"$f":"'Base model'!M16*(1+$F$21)","v":8.9999999999999993E-3},{"$f":"'Base model'!N16*(1+$F$21)","v":8.9999999999999993E-3},{"$f":"'Base model'!O16*(1+$F$21)","v":8.9999999999999993E-3},{"$f":"'Base model'!P16*(1+$F$21)","v":8.9999999999999993E-3},{"$f":"'Base model'!Q16*(1+$F$21)","v":8.9999999999999993E-3},{"$f":"'Base model'!R16*(1+$F$21)","v":8.9999999999999993E-3},{"$f":"'Base model'!S16*(1+$F$21)","v":8.9999999999999993E-3},{"$f":"'Base model'!T16*(1+$F$21)","v":8.9999999999999993E-3},{"$f":"'Base model'!U16*(1+$F$21)","v":8.9999999999999993E-3},{"$f":"'Base model'!V16*(1+$F$21)","v":8.9999999999999993E-3},{"$f":"'Base model'!W16*(1+$F$21)","v":8.9999999999999993E-3}]
[null,null,null,"Waiting time constant",null,null,null,"Unit",null,{"$f":"'Base model'!J17","v":24758.635602268234},{"$f":"'Base model'!K17","v":24758.635602268234},{"$f":"'Base model'!L17","v":24758.635602268234},{"$f":"'Base model'!M17","v":24758.635602268234},{"$f":"'Base model'!N17","v":24758.635602268234},{"$f":"'Base model'!O17","v":24758.635602268234},{"$f":"'Base model'!P17","v":24758.635602268234},{"$f":"'Base model'!Q17","v":24758.635602268234},{"$f":"'Base model'!R17","v":24758.635602268234},{"$f":"'Base model'!S17","v":24758.635602268234},{"$f":"'Base model'!T17","v":24758.635602268234},{"$f":"'Base model'!U17","v":24758.635602268234},{"$f":"'Base model'!V17","v":24758.635602268234},{"$f":"'Base model'!W17","v":24758.635602268234}]
[null,null,null,"Constant to link occupied taxi kms to occupied taxis",null,null,null,"Unit",null,{"$f":"'Base model'!J18","v":3.1250000000000002E-3},{"$f":"'Base model'!K18","v":3.1250000000000002E-3},{"$f":"'Base model'!L18","v":3.1250000000000002E-3},{"$f":"'Base model'!M18","v":3.1250000000000002E-3},{"$f":"'Base model'!N18","v":3.1250000000000002E-3},{"$f":"'Base model'!O18","v":3.1250000000000002E-3},{"$f":"'Base model'!P18","v":3.1250000000000002E-3},{"$f":"'Base model'!Q18","v":3.1250000000000002E-3},{"$f":"'Base model'!R18","v":3.1250000000000002E-3},{"$f":"'Base model'!S18","v":3.1250000000000002E-3},{"$f":"'Base model'!T18","v":3.1250000000000002E-3},{"$f":"'Base model'!U18","v":3.1250000000000002E-3},{"$f":"'Base model'!V18","v":3.1250000000000002E-3},{"$f":"'Base model'!W18","v":3.1250000000000002E-3}]
[]
[null,"GST adjustor",null,{"$f":"(1+'Inputs and assumptions'!$C$20)","v":1.1000000000000001}]
[]
[]
[null,null,null,null,null,null,null,null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
[null,"SIMULATION MODEL",null,null,null,null,null,null,null,"Day","Day","Day","Day","Day","Day","Day","Night","Night","Night","Night","Night","Night","Night"]
[null,"Q*",null,"Free entry demand",null,null,null,"Occupied kilometres",null,413013.34734791319,418468.86143999832,422557.4101067505,450490.89657482953,454488.23662264354,300378.97285522468,269058.3740684634,324039.71610766847,405942.05743629823,470861.89926317037,559780.44047309726,754187.50869120273,684460.15125902335,287484.75185167324]
[null,"W*",null,"Free entry waiting time",null,null,null,"Minutes, average",null,6.2969430648614644,6.515287598557733,6.1940524078018138,5.9170558639947739,5.8800960455893989,8.9515520521460061,9.7789968765969792,7.9038118891130296,6.6641477154731925,5.9800363231918183,5.2927562156692982,4.4261215154740254,4.4766845273366238,9.8581267376814772]
[null,"T*",null,"Free entry number of taxis on the road",null,null,null,"Taxis on the road",null,5222.5167139742543,5107.798493385867,5317.6546653485402,5592.0669411760082,5630.8592766990414,3704.532673517866,3372.6249702302707,4145.1171444210913,4983.7680330708736,5611.6583846199919,6427.1479984057478,7950.5901225596681,7669.5121008931028,3409.8848328527456]
[null,"Q* zero condition",null,"Zero condition to solve for free entry",null,null,null,"Occupied kilometres",null,{"$f":"J95-J96*J98-J97*J111-J110","v":0},-10092.829005394247,0,0,0,0,9.3132257461547852E-10,0,0,6.4028427004814148E-10,0,0,0,0]
[null,"W* zero condition",null,"Zero condition to solve for free entry",null,null,null,"Minutes, average",null,{"$f":"J102/(J112-J110*J103)-J111","v":-2.3964137341181413E-9},-1.2466738752436868E-9,-2.0103039233276832E-9,-1.1826912782453292E-9,-1.1301528601848077E-9,-6.1316086430451833E-8,-1.2784434133550349E-7,-2.0218419827244816E-8,-4.413960752458479E-9,-4.3741834154786829E-8,-4.795492003495383E-9,-5.0563064846187444E-9,-4.4790446906972647E-9,-9.7278613608864362E-8]
[null,"T* zero condition",null,"Zero condition to solve for free entry",null,null,null,"Taxis on the road",null,{"$f":"(-J100+SQRT(J100^2+4*J101*(J98-J99)*J110))/(2*J101)-J112","v":2.4127621145453304E-7},169.18852596683246,2.0990864868508652E-7,1.3668704923475161E-7,1.3261978892842308E-7,-9.9894759841845371E-7,-9.9806629805243574E-7,-9.9954377219546586E-7,3.8710368244210258E-7,-9.993946150643751E-7,5.512683856068179E-7,7.1569684223504737E-7,6.1140235629864037E-7,-9.9871158454334363E-7]
[null,"Qbar",null,"Fixed taxi numbers demand",null,null,null,"Occupied kilometres",null,{"$f":"((J103*(J95-J96*J98)+J118)-SQRT((J103*(J95-J96*J98)+J118)^2-4*J103*(J118*(J95-J96*J98)-J97*J102)))/(2*J103)","v":401266.18362569949},399210.69170509884,410552.32896572025,436841.14696246979,437230.05868141167,306626.95033457817,280582.98986349173,328803.36475152732,398823.00527677475,456295.81487609725,535176.15935395774,703359.09509236296,637102.02405178477,303548.59077588288]
[null,"Wbar",null,"Fixed taxi numbers waiting time",null,null,null,"Minutes, average",null,{"$f":"J102/(J118-J116*J103)","v":7.7668413520723441},7.6702502723538126,7.6652178691968667,7.4944410683532281,7.8506357260285897,7.945262392163154,7.7430305407212128,7.1676705505840195,7.5640563468192887,7.5886109150638719,7.6084838513934772,8.1166997175943596,8.2815313972602169,7.0075629882132269]
[null,"Tbar",null,"Fixed taxi numbers",null,null,null,"Taxis on the road",null,{"$f":"'Base model'!J8/'Base model'!J6*('Base model'!J6+$F$9)","v":4441.6922853847236},{"$f":"'Base model'!K8/'Base model'!K6*('Base model'!K6+$F$9)","v":4475.411867058142},{"$f":"'Base model'!L8/'Base model'!L6*('Base model'!L6+$F$9)","v":4512.9736647141899},{"$f":"'Base model'!M8/'Base model'!M6*('Base model'!M6+$F$9)","v":4668.7285961140406},{"$f":"'Base model'!N8/'Base model'!N6*('Base model'!N6+$F$9)","v":4520.0548513604335},{"$f":"'Base model'!O8/'Base model'!O6*('Base model'!O6+$F$9)","v":4074.36},{"$f":"'Base model'!P8/'Base model'!P6*('Base model'!P6+$F$9)","v":4074.36},{"$f":"'Base model'!Q8/'Base model'!Q6*('Base model'!Q6+$F$9+$F$11)","v":4481.72},{"$f":"'Base model'!R8/'Base model'!R6*('Base model'!R6+$F$9+$F$11)","v":4519.5174451797511},{"$f":"'Base model'!S8/'Base model'!S6*('Base model'!S6+$F$9+$F$11)","v":4688.5288532317982},{"$f":"'Base model'!T8/'Base model'!T6*('Base model'!T6+$F$9+$F$11)","v":4926.5081885468271},{"$f":"'Base model'!U8/'Base model'!U6*('Base model'!U6+$F$9+$F$11)","v":5248.33},{"$f":"'Base model'!V8/'Base model'!V6*('Base model'!V6+$F$9+$F$11)","v":4980.5642727108334},{"$f":"'Base model'!W8/'Base model'!W6*('Base model'!W6+$F$9+$F$11)","v":4481.72}]
[null,"Q*_flat",null,"Free entry demand, flat cost curve",null,null,null,"Occupied kilometres",null,{"$f":"(J95-J96*J98+SQRT((J95-J96*J98)^2-4*J97*J102/((J98-J99)/J100-J103)))/2","v":430631.42223822238},427353.82775591314,440451.76330565114,469190.47132544289,473381.60397279373,314994.71760803822,282818.05937801569,338850.49448057183,423085.1091519912,489839.73249569885,581234.89583800489,778760.81769829791,706123.08477392746,300722.04161407775]
[null,"W*_flat",null,"Free entry waiting time, flat cost curve",null,null,null,"Minutes, average",null,{"$f":"J102/((J98-J99)/J100-J103)/J119","v":4.0924298123350757},4.1238167439616928,4.0011847319430265,3.7561054160316845,3.7228503509765467,6.5975626425641014,7.3481777863346949,5.6150565607490739,4.4971204398089082,3.884259617839207,3.2734866845924739,2.641888796913956,2.7362410250659752,7.5091403891536963]
[null,"T*_flat",null,"Free entry number of taxis on the road, flat cost curve",null,null,null,"Taxis on the road",null,{"$f":"(J98-J99)*J119/J100","v":7395.5851927730037},7339.2963852928287,7564.2379320663294,8057.7912412649885,8129.7689859139764,4737.0527742797449,4253.1636180011128,5468.2374848827885,6827.5829336093593,7904.8430810878317,9379.7426791878352,11805.19369813246,11255.046448476674,4236.8895163521047]
[null,"Q",null,"Equilibrium demand",null,null,null,"Occupied kilometres",null,{"$f":"IF(J124=J$118,J116,IF('Inputs and assumptions'!$C$61=\"Flat\",J119,J110))","v":401266.18362569949},{"$f":"IF(K124=K$118,K116,IF('Inputs and assumptions'!$C$61=\"Flat\",K119,K110))","v":399210.69170509884},{"$f":"IF(L124=L$118,L116,IF('Inputs and assumptions'!$C$61=\"Flat\",L119,L110))","v":410552.32896572025},{"$f":"IF(M124=M$118,M116,IF('Inputs and assumptions'!$C$61=\"Flat\",M119,M110))","v":436841.14696246979},{"$f":"IF(N124=N$118,N116,IF('Inputs and assumptions'!$C$61=\"Flat\",N119,N110))","v":437230.05868141167},{"$f":"IF(O124=O$118,O116,IF('Inputs and assumptions'!$C$61=\"Flat\",O119,O110))","v":300378.97285522468},{"$f":"IF(P124=P$118,P116,IF('Inputs and assumptions'!$C$61=\"Flat\",P119,P110))","v":269058.3740684634},{"$f":"IF(Q124=Q$118,Q116,IF('Inputs and assumptions'!$C$61=\"Flat\",Q119,Q110))","v":324039.71610766847},{"$f":"IF(R124=R$118,R116,IF('Inputs and assumptions'!$C$61=\"Flat\",R119,R110))","v":398823.00527677475},{"$f":"IF(S124=S$118,S116,IF('Inputs and assumptions'!$C$61=\"Flat\",S119,S110))","v":456295.81487609725},{"$f":"IF(T124=T$118,T116,IF('Inputs and assumptions'!$C$61=\"Flat\",T119,T110))","v":535176.15935395774},{"$f":"IF(U124=U$118,U116,IF('Inputs and assumptions'!$C$61=\"Flat\",U119,U110))","v":703359.09509236296},{"$f":"IF(V124=V$118,V116,IF('Inputs and assumptions'!$C$61=\"Flat\",V119,V110))","v":637102.02405178477},{"$f":"IF(W124=W$118,W116,IF('Inputs and assumptions'!$C$61=\"Flat\",W119,W110))","v":287484.75185167324}]
[null,"W",null,"Equilibrium waiting time",null,null,null,"Minutes, average",null,{"$f":"IF(J124=J$118,J117,IF('Inputs and assumptions'!$C$61=\"Flat\",J120,J111))","v":7.7668413520723441},{"$f":"IF(K124=K$118,K117,IF('Inputs and assumptions'!$C$61=\"Flat\",K120,K111))","v":7.6702502723538126},{"$f":"IF(L124=L$118,L117,IF('Inputs and assumptions'!$C$61=\"Flat\",L120,L111))","v":7.6652178691968667},{"$f":"IF(M124=M$118,M117,IF('Inputs and assumptions'!$C$61=\"Flat\",M120,M111))","v":7.4944410683532281},{"$f":"IF(N124=N$118,N117,IF('Inputs and assumptions'!$C$61=\"Flat\",N120,N111))","v":7.8506357260285897},{"$f":"IF(O124=O$118,O117,IF('Inputs and assumptions'!$C$61=\"Flat\",O120,O111))","v":8.9515520521460061},{"$f":"IF(P124=P$118,P117,IF('Inputs and assumptions'!$C$61=\"Flat\",P120,P111))","v":9.7789968765969792},{"$f":"IF(Q124=Q$118,Q117,IF('Inputs and assumptions'!$C$61=\"Flat\",Q120,Q111))","v":7.9038118891130296},{"$f":"IF(R124=R$118,R117,IF('Inputs and assumptions'!$C$61=\"Flat\",R120,R111))","v":7.5640563468192887},{"$f":"IF(S124=S$118,S117,IF('Inputs and assumptions'!$C$61=\"Flat\",S120,S111))","v":7.5886109150638719},{"$f":"IF(T124=T$118,T117,IF('Inputs and assumptions'!$C$61=\"Flat\",T120,T111))","v":7.6084838513934772},{"$f":"IF(U124=U$118,U117,IF('Inputs and assumptions'!$C$61=\"Flat\",U120,U111))","v":8.1166997175943596},{"$f":"IF(V124=V$118,V117,IF('Inputs and assumptions'!$C$61=\"Flat\",V120,V111))","v":8.2815313972602169},{"$f":"IF(W124=W$118,W117,IF('Inputs and assumptions'!$C$61=\"Flat\",W120,W111))","v":9.8581267376814772}]
[null,"T",null,"Equilibrium number of taxis on the road",null,null,null,"Taxis on the road",null,{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(J121,J118),MIN(J112,J118))","v":4441.6922853847236},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(K121,K118),MIN(K112,K118))","v":4475.411867058142},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(L121,L118),MIN(L112,L118))","v":4512.9736647141899},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(M121,M118),MIN(M112,M118))","v":4668.7285961140406},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(N121,N118),MIN(N112,N118))","v":4520.0548513604335},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(O121,O118),MIN(O112,O118))","v":3704.532673517866},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(P121,P118),MIN(P112,P118))","v":3372.6249702302707},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(Q121,Q118),MIN(Q112,Q118))","v":4145.1171444210913},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(R121,R118),MIN(R112,R118))","v":4519.5174451797511},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(S121,S118),MIN(S112,S118))","v":4688.5288532317982},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(T121,T118),MIN(T112,T118))","v":4926.5081885468271},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(U121,U118),MIN(U112,U118))","v":5248.33},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(V121,V118),MIN(V112,V118))","v":4980.5642727108334},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(W121,W118),MIN(W112,W118))","v":3409.8848328527456}]
[null,"Difference between free entry and actual (for info)",null,null,null,null,null,null,null,{"$f":"J112-J118","v":780.82442858953073},{"$f":"K112-K118","v":632.38662632772503},804.68100063435031,923.33834506196763,1110.8044253386079,-369.82732648213414,{"$f":"P112-P118","v":-701.73502976972941},-336.60285557890893,464.25058789112245,923.12953138819375,1500.6398098589207,2702.2601225596682,2688.9478281822694,-1071.8351671472547]
[]
[]
[]
[null,"Baseline data"]
[null,"Baseline taxis on the road",null,null,null,null,null,"No.",null,{"$f":"'Base model'!J124","v":4441.6922853847236},{"$f":"'Base model'!K124","v":4475.411867058142},{"$f":"'Base model'!L124","v":4512.9736647141899},{"$f":"'Base model'!M124","v":4668.7285961140406},{"$f":"'Base model'!N124","v":4520.0548513604335},{"$f":"'Base model'!O124","v":3636.9315038309001},{"$f":"'Base model'!P124","v":3308.553482545788},{"$f":"'Base model'!Q124","v":4094.1242091194895},{"$f":"'Base model'!R124","v":4327.9150437391982},{"$f":"'Base model'!S124","v":4489.7613081566842},{"$f":"'Base model'!T124","v":4717.6516433311735},{"$f":"'Base model'!U124","v":5025.83},{"$f":"'Base model'!V124","v":4769.4160501946881},{"$f":"'Base model'!W124","v":3367.4239769579785}]
[null,"Additional taxis on the road",null,null,null,null,null,"No.",null,{"$f":"J124-J130","v":0},0,0,0,0,67.601169686965932,64.07148768448269,50.992935301601847,191.60240144055297,198.76754507511396,208.85654521565357,222.5,211.14822251614532,42.460855894767064]
[null,"Baseline revenue per taxi",null,null,null,null,null,"$/taxi",null,{"$f":"'Base model'!J141","v":267.42122388982557},{"$f":"'Base model'!K141","v":264.0367522699969},{"$f":"'Base model'!L141","v":269.29473393336701},{"$f":"'Base model'!M141","v":277.00465691272041},{"$f":"'Base model'!N141","v":286.38590727664581},{"$f":"'Base model'!O141","v":245.42201509893198},{"$f":"'Base model'!P141","v":241.49511941751257},{"$f":"'Base model'!Q141","v":237.63693475178522},{"$f":"'Base model'!R141","v":275.05943777045064},{"$f":"'Base model'!S141","v":303.36187406419219},{"$f":"'Base model'!T141","v":338.63611098623466},{"$f":"'Base model'!U141","v":438.40214477547414},{"$f":"'Base model'!V141","v":434.34748060224098},{"$f":"'Base model'!W141","v":256.43696456151395}]
[null,"Simulation revenue per taxi",null,null,null,null,null,"$/taxi",null,{"$f":"J64","v":271.94965015539083},268.51810022258599,273.84835204980709,281.66268922502422,291.18615180628666,246.90990552285302,242.92984733756887,239.45969891244135,270.3081450836608,298.1129829293597,332.75803208284458,436.28151637519892,434.36698241967963,258.25343172703572]
[null,"Headings for charts",null,null,null,null,null,null,null,"Day",null,null,null,null,null,null,"Night"]
[null,null,null,null,null,null,null,null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
[]
[]
[null,"Revenue","2012/13"]
[null,null,"Revenue","Revenue share"]
[null,"Flagfall ($)",{"$f":"R36*R165","v":2901869.333552856},{"$f":"C140/$C$145","v":0.15945031493076578}]
[null,"Standard kilometre charge ($/km)",{"$f":"R38*R166","v":7921310.3097745432},0.43525578803766179]
[null,"Night kilometre charge ($/km)",{"$f":"R39*R167","v":2998114.0121276174},0.16473871442267782]
[null,"Waiting time ($/hour when vehicle slower than 26km/hour)",{"$f":"R40*R168","v":3979942.9810296609},0.21868771084696095]
[null,"Booking fee ($/booking)",{"$f":"R41*R169","v":397970.65145867749},2.1867471761933599E-2]
[null,"Weighted average",{"$f":"SUM(C140:C144)","v":18199207.287943356},1]
[]
[]
[null,"Fare setting for 2013/14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DO NOT DELETE"]
[null,"Fares",null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday",null,null,"Yes"]
[null,null,null,"Day","Day","Day","Day","Day","Day","Day","Night","Night","Night","Night","Night","Night","Night",null,null,"No"]
[null,"Average flagfall ($)",null,{"$f":"IF(AND(J35=\"Yes\", $J$31=\"5 pm until 5 am\"), $L$12+(1-'Inputs and assumptions'!D10)*Sim_template!$J$27, IF(AND(J35=\"Yes\", $J$31=\"10 pm until 6 am\"), $L$12+(1-'Inputs and assumptions'!D9)*Sim_template!$J$27,  IF(AND(J35=\"Yes\", $J$31=\"12 am until 5 am\"), $L$12+(1-'Inputs and assumptions'!D11)*Sim_template!$J$27, $L$12)))","v":3.5},{"$f":"IF(AND(J36=\"Yes\", $J$31=\"5 pm until 5 am\"), $L$12+(1-'Inputs and assumptions'!E10)*Sim_template!$J$27, IF(AND(J36=\"Yes\", $J$31=\"10 pm until 6 am\"), $L$12+(1-'Inputs and assumptions'!E9)*Sim_template!$J$27,  IF(AND(J36=\"Yes\", $J$31=\"12 am until 5 am\"), $L$12+(1-'Inputs and assumptions'!E11)*Sim_template!$J$27, $L$12)))","v":3.5},{"$f":"IF(AND(J37=\"Yes\", $J$31=\"5 pm until 5 am\"), $L$12+(1-'Inputs and assumptions'!F10)*Sim_template!$J$27, IF(AND(J37=\"Yes\", $J$31=\"10 pm until 6 am\"), $L$12+(1-'Inputs and assumptions'!F9)*Sim_template!$J$27,  IF(AND(J37=\"Yes\", $J$31=\"12 am until 5 am\"), $L$12+(1-'Inputs and assumptions'!F11)*Sim_template!$J$27, $L$12)))","v":3.5},{"$f":"IF(AND(J38=\"Yes\", $J$31=\"5 pm until 5 am\"), $L$12+(1-'Inputs and assumptions'!G10)*Sim_template!$J$27, IF(AND(J38=\"Yes\", $J$31=\"10 pm until 6 am\"), $L$12+(1-'Inputs and assumptions'!G9)*Sim_template!$J$27,  IF(AND(J38=\"Yes\", $J$31=\"12 am until 5 am\"), $L$12+(1-'Inputs and assumptions'!G11)*Sim_template!$J$27, $L$12)))","v":3.5},{"$f":"IF(AND(J39=\"Yes\", $J$31=\"5 pm until 5 am\"), $L$12+(1-'Inputs and assumptions'!H10)*Sim_template!$J$27, IF(AND(J39=\"Yes\", $J$31=\"10 pm until 6 am\"), $L$12+(1-'Inputs and assumptions'!H9)*Sim_template!$J$27,  IF(AND(J39=\"Yes\", $J$31=\"12 am until 5 am\"), $L$12+(1-'Inputs and assumptions'!H11)*Sim_template!$J$27, $L$12)))","v":3.5},{"$f":"IF(AND(J40=\"Yes\", $J$31=\"5 pm until 5 am\"), $L$12+(1-'Inputs and assumptions'!I10)*Sim_template!$J$27, IF(AND(J40=\"Yes\", $J$31=\"10 pm until 6 am\"), $L$12+(1-'Inputs and assumptions'!I9)*Sim_template!$J$27,  IF(AND(J40=\"Yes\", $J$31=\"12 am until 5 am\"), $L$12+(1-'Inputs and assumptions'!I11)*Sim_template!$J$27, $L$12)))","v":3.75},{"$f":"IF(AND(J41=\"Yes\", $J$31=\"5 pm until 5 am\"), $L$12+(1-'Inputs and assumptions'!J10)*Sim_template!$J$27, IF(AND(J41=\"Yes\", $J$31=\"10 pm until 6 am\"), $L$12+(1-'Inputs and assumptions'!J9)*Sim_template!$J$27,  IF(AND(J41=\"Yes\", $J$31=\"12 am until 5 am\"), $L$12+(1-'Inputs and assumptions'!J11)*Sim_template!$J$27, $L$12)))","v":3.75},{"$f":"IF(AND(J42=\"Yes\", $J$31=\"5 pm until 5 am\"), $L$12+(1-'Inputs and assumptions'!K10)*Sim_template!$J$27, IF(AND(J42=\"Yes\", $J$31=\"10 pm until 6 am\"), $L$12+(1-'Inputs and assumptions'!K9)*Sim_template!$J$27,  IF(AND(J42=\"Yes\", $J$31=\"12 am until 5 am\"), $L$12+(1-'Inputs and assumptions'!K11)*Sim_template!$J$27, $L$12)))","v":3.5},{"$f":"IF(AND(J43=\"Yes\", $J$31=\"5 pm until 5 am\"), $L$12+(1-'Inputs and assumptions'!L10)*Sim_template!$J$27, IF(AND(J43=\"Yes\", $J$31=\"10 pm until 6 am\"), $L$12+(1-'Inputs and assumptions'!L9)*Sim_template!$J$27,  IF(AND(J43=\"Yes\", $J$31=\"12 am until 5 am\"), $L$12+(1-'Inputs and assumptions'!L11)*Sim_template!$J$27, $L$12)))","v":3.5},{"$f":"IF(AND(J44=\"Yes\", $J$31=\"5 pm until 5 am\"), $L$12+(1-'Inputs and assumptions'!M10)*Sim_template!$J$27, IF(AND(J44=\"Yes\", $J$31=\"10 pm until 6 am\"), $L$12+(1-'Inputs and assumptions'!M9)*Sim_template!$J$27,  IF(AND(J44=\"Yes\", $J$31=\"12 am until 5 am\"), $L$12+(1-'Inputs and assumptions'!M11)*Sim_template!$J$27, $L$12)))","v":3.5},{"$f":"IF(AND(J45=\"Yes\", $J$31=\"5 pm until 5 am\"), $L$12+(1-'Inputs and assumptions'!N10)*Sim_template!$J$27, IF(AND(J45=\"Yes\", $J$31=\"10 pm until 6 am\"), $L$12+(1-'Inputs and assumptions'!N9)*Sim_template!$J$27,  IF(AND(J45=\"Yes\", $J$31=\"12 am until 5 am\"), $L$12+(1-'Inputs and assumptions'!N11)*Sim_template!$J$27, $L$12)))","v":3.5},{"$f":"IF(AND(J46=\"Yes\", $J$31=\"5 pm until 5 am\"), $L$12+(1-'Inputs and assumptions'!O10)*Sim_template!$J$27, IF(AND(J46=\"Yes\", $J$31=\"10 pm until 6 am\"), $L$12+(1-'Inputs and assumptions'!O9)*Sim_template!$J$27,  IF(AND(J46=\"Yes\", $J$31=\"12 am until 5 am\"), $L$12+(1-'Inputs and assumptions'!O11)*Sim_template!$J$27, $L$12)))","v":4.5},{"$f":"IF(AND(J47=\"Yes\", $J$31=\"5 pm until 5 am\"), $L$12+(1-'Inputs and assumptions'!P10)*Sim_template!$J$27, IF(AND(J47=\"Yes\", $J$31=\"10 pm until 6 am\"), $L$12+(1-'Inputs and assumptions'!P9)*Sim_template!$J$27,  IF(AND(J47=\"Yes\", $J$31=\"12 am until 5 am\"), $L$12+(1-'Inputs and assumptions'!P11)*Sim_template!$J$27, $L$12)))","v":5},{"$f":"IF(AND(J48=\"Yes\", $J$31=\"5 pm until 5 am\"), $L$12+(1-'Inputs and assumptions'!Q10)*Sim_template!$J$27, IF(AND(J48=\"Yes\", $J$31=\"10 pm until 6 am\"), $L$12+(1-'Inputs and assumptions'!Q9)*Sim_template!$J$27,  IF(AND(J48=\"Yes\", $J$31=\"12 am until 5 am\"), $L$12+(1-'Inputs and assumptions'!Q11)*Sim_template!$J$27, $L$12)))","v":3.5}]
[null,"Standard kilometre charge ($/km)",null,{"$f":"$L$14","v":2.14},2.14,2.14,2.14,2.14,2.14,2.14,2.14,2.14,2.14,2.14,2.14,2.14,2.14,null,null,"DO NOT DELETE"]
[null,"Night kilometre charge ($/km)",null,{"$f":"IF(L35=\"No\",L14,IF(L35=\"Yes\",$K$29,\"na\"))","v":2.57},{"$f":"IF(L36=\"No\",D152,IF(L36=\"Yes\",$K$29,\"na\"))","v":2.57},{"$f":"IF(L37=\"No\",E152,IF(L37=\"Yes\",$K$29,\"na\"))","v":2.57},{"$f":"IF(L38=\"No\",F152,IF(L38=\"Yes\",$K$29,\"na\"))","v":2.57},{"$f":"IF(L39=\"No\",G152,IF(L39=\"Yes\",$K$29,\"na\"))","v":2.57},{"$f":"IF(L40=\"No\",H152,IF(L40=\"Yes\",$K$29,\"na\"))","v":2.57},{"$f":"IF(L41=\"No\",I152,IF(L41=\"Yes\",$K$29,\"na\"))","v":2.57},{"$f":"IF(L42=\"No\",J152,IF(L42=\"Yes\",$K$29,\"na\"))","v":2.57},{"$f":"IF(L43=\"No\",K152,IF(L43=\"Yes\",$K$29,\"na\"))","v":2.57},{"$f":"IF(L44=\"No\",L152,IF(L44=\"Yes\",$K$29,\"na\"))","v":2.57},{"$f":"IF(L45=\"No\",M152,IF(L45=\"Yes\",$K$29,\"na\"))","v":2.57},{"$f":"IF(L46=\"No\",N152,IF(L46=\"Yes\",$K$29,\"na\"))","v":2.57},{"$f":"IF(L47=\"No\",O152,IF(L47=\"Yes\",$K$29,\"na\"))","v":2.57},{"$f":"IF(L48=\"No\",P152,IF(L48=\"Yes\",$K$29,\"na\"))","v":2.57},null,null,"10 pm until 6 am"]
[null,"Waiting time ($/hour when vehicle slower than 26km/hour)",null,{"$f":"$L$16","v":55.3},55.3,55.3,55.3,55.3,55.3,55.3,55.3,55.3,55.3,55.3,55.3,55.3,55.3,null,null,"5 pm until 5 am"]
[null,"Booking fee ($/booking)",null,{"$f":"$L$21","v":2.4},2.4,2.4,2.4,2.4,2.4,2.4,2.4,2.4,2.4,2.4,2.4,2.4,2.4,null,null,"12 am until 5 am"]
[]
[null,null,null,null,null,"Km threshold for waiting"]
[null,"For fare goal seek",null,{"$f":"L9-F27","v":-2.4286561550694863E-3},null,"2012/13"]
[null,null,null,null,null,{"$f":"ROUND(R40/R38,0)","v":26}]
[]
[null,"Weights 2012/13"]
[null,null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Total"]
[null,null,null,"Day","Day","Day","Day","Day","Day","Day","Night","Night","Night","Night","Night","Night","Night"]
[null,"Occupied kms",null,{"$f":"'Base model'!J9","v":382718.94540266518},{"$f":"'Base model'!K9","v":380027.38167367538},{"$f":"'Base model'!L9","v":390784.92579487606},{"$f":"'Base model'!M9","v":414401.33463067369},{"$f":"'Base model'!N9","v":419415.02201265405},{"$f":"'Base model'!O9","v":297338.17313916679},{"$f":"'Base model'!P9","v":271075.3870690894},{"$f":"'Base model'!Q9","v":315327.62167150405},{"$f":"'Base model'!R9","v":385484.79983498488},{"$f":"'Base model'!S9","v":441250.40543171746},{"$f":"'Base model'!T9","v":517734.01894150977},{"$f":"'Base model'!U9","v":682678.03709273122},{"$f":"'Base model'!V9","v":630901.63422562391},{"$f":"'Base model'!W9","v":274600.9801848408}]
[null,"Flagfall (no of trips)",null,{"$f":"D164/'Inputs and assumptions'!$C$44","v":54674.135057523599},{"$f":"'Base model'!K9/'Inputs and assumptions'!$C$44","v":54289.625953382194},{"$f":"'Base model'!L9/'Inputs and assumptions'!$C$44","v":55826.417970696581},{"$f":"'Base model'!M9/'Inputs and assumptions'!$C$44","v":59200.190661524815},{"$f":"'Base model'!N9/'Inputs and assumptions'!$C$44","v":59916.431716093437},{"$f":"'Base model'!O9/'Inputs and assumptions'!$C$44","v":42476.881877023829},{"$f":"'Base model'!P9/'Inputs and assumptions'!$C$44","v":38725.055295584199},{"$f":"'Base model'!Q9/'Inputs and assumptions'!$C$44","v":45046.80309592915},{"$f":"'Base model'!R9/'Inputs and assumptions'!$C$44","v":55069.257119283553},{"$f":"'Base model'!S9/'Inputs and assumptions'!$C$44","v":63035.772204531066},{"$f":"'Base model'!T9/'Inputs and assumptions'!$C$44","v":73962.002705929961},{"$f":"'Base model'!U9/'Inputs and assumptions'!$C$44","v":97525.433870390174},{"$f":"'Base model'!V9/'Inputs and assumptions'!$C$44","v":90128.804889374849},{"$f":"'Base model'!W9/'Inputs and assumptions'!$C$44","v":39228.71145497726},{"$f":"SUM(D165:Q165)","v":829105.52387224464}]
[null,"Standard kilometre charge (kms)",null,{"$f":"D164*'Inputs and assumptions'!D9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":288919.34981445211},{"$f":"E164*'Inputs and assumptions'!E9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":286887.45447217755},{"$f":"F164*'Inputs and assumptions'!F9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":295008.45995265496},{"$f":"G164*'Inputs and assumptions'!G9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":312836.78428243723},{"$f":"H164*'Inputs and assumptions'!H9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":316621.68000284804},{"$f":"I164*'Inputs and assumptions'!I9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":224464.33000070346},{"$f":"J164*'Inputs and assumptions'!J9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":204638.22218234208},{"$f":"K164*'Inputs and assumptions'!K9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":198370.65930112268},{"$f":"L164*'Inputs and assumptions'!L9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":242506.10678657747},{"$f":"M164*'Inputs and assumptions'!M9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":277587.90485396801},{"$f":"N164*'Inputs and assumptions'!N9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":325703.27374314022},{"$f":"O164*'Inputs and assumptions'!O9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":343574.8294821062},{"$f":"P164*'Inputs and assumptions'!P9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":211678.03817854199},{"$f":"Q164*'Inputs and assumptions'!Q9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":172749.78067334997},{"$f":"SUM(D166:Q166)","v":3701546.873726422}]
[null,"Night kilometre charge (kms)",null,{"$f":"D164*(1-'Inputs and assumptions'!D9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":32102.149979383561},{"$f":"E164*(1-'Inputs and assumptions'!E9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":31876.383830241943},{"$f":"F164*(1-'Inputs and assumptions'!F9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":32778.717772517215},{"$f":"G164*(1-'Inputs and assumptions'!G9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":34759.64269804857},{"$f":"H164*(1-'Inputs and assumptions'!H9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":35180.186666983107},{"$f":"I164*(1-'Inputs and assumptions'!I9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":24940.48111118927},{"$f":"J164*(1-'Inputs and assumptions'!J9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":22737.580242482447},{"$f":"K164*(1-'Inputs and assumptions'!K9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":66123.553100374222},{"$f":"L164*(1-'Inputs and assumptions'!L9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":80835.368928859156},{"$f":"M164*(1-'Inputs and assumptions'!M9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":92529.301617989331},{"$f":"N164*(1-'Inputs and assumptions'!N9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":108567.75791438007},{"$f":"O164*(1-'Inputs and assumptions'!O9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":229049.88632140416},{"$f":"P164*(1-'Inputs and assumptions'!P9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":317517.05726781295},{"$f":"Q164*(1-'Inputs and assumptions'!Q9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":57583.260224449979},{"$f":"SUM(D167:Q167)","v":1166581.3276761158}]
[null,"Waiting time (hours)",null,{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!D165","v":4745.9573545253506},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!E165","v":4712.5802593273766},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!F165","v":4845.9806207464535},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!G165","v":5138.8390500144569},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!H165","v":5201.0119494479186},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!I165","v":3687.1816944056973},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!J165","v":3361.5065110972996},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!K165","v":3910.2622515390121},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!L165","v":4780.2557015037146},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!M165","v":5471.7845353661678},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!N165","v":6420.2297910761172},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!O165","v":8465.6400991708397},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!P165","v":7823.5799060976169},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!Q165","v":3405.226099003145},{"$f":"SUM(D168:Q168)","v":71970.035823321174}]
[null,"Booking fee (number)",null,{"$f":"D165*'Inputs and assumptions'!$C$47","v":10934.82701150472},{"$f":"E165*'Inputs and assumptions'!$C$47","v":10857.92519067644},{"$f":"F165*'Inputs and assumptions'!$C$47","v":11165.283594139317},{"$f":"G165*'Inputs and assumptions'!$C$47","v":11840.038132304964},{"$f":"H165*'Inputs and assumptions'!$C$47","v":11983.286343218688},{"$f":"I165*'Inputs and assumptions'!$C$47","v":8495.3763754047668},{"$f":"J165*'Inputs and assumptions'!$C$47","v":7745.0110591168404},{"$f":"K165*'Inputs and assumptions'!$C$47","v":9009.3606191858307},{"$f":"L165*'Inputs and assumptions'!$C$47","v":11013.851423856711},{"$f":"M165*'Inputs and assumptions'!$C$47","v":12607.154440906213},{"$f":"N165*'Inputs and assumptions'!$C$47","v":14792.400541185993},{"$f":"O165*'Inputs and assumptions'!$C$47","v":19505.086774078034},{"$f":"P165*'Inputs and assumptions'!$C$47","v":18025.760977874972},{"$f":"Q165*'Inputs and assumptions'!$C$47","v":7845.7422909954521},{"$f":"SUM(D169:Q169)","v":165821.10477444896}]
[]
[null,"Weights 2013/14"]
[null,"Different distance rate night hours adjustment"]
[null,"Distance surcharge hours:",null,{"$f":"'Inputs and assumptions'!B9","v":"The proportion of trips in each shift for which the standard distance rate currently applies (rather than the night time distance rate)"}]
[null,{"$f":"Sim_template!L31","v":"10 pm until 6 am"},null,{"$f":"IF($B$174=\"5 pm until 5 am\", 'Inputs and assumptions'!D10, IF($B$174=\"12 am until 5 am\",  'Inputs and assumptions'!D11,'Inputs and assumptions'!D9))","v":0.9},{"$f":"IF($B$174=\"5 pm until 5 am\", 'Inputs and assumptions'!E10, IF($B$174=\"12 am until 5 am\",  'Inputs and assumptions'!E11,'Inputs and assumptions'!E9))","v":0.9},{"$f":"IF($B$174=\"5 pm until 5 am\", 'Inputs and assumptions'!F10, IF($B$174=\"12 am until 5 am\",  'Inputs and assumptions'!F11,'Inputs and assumptions'!F9))","v":0.9},{"$f":"IF($B$174=\"5 pm until 5 am\", 'Inputs and assumptions'!G10, IF($B$174=\"12 am until 5 am\",  'Inputs and assumptions'!G11,'Inputs and assumptions'!G9))","v":0.9},{"$f":"IF($B$174=\"5 pm until 5 am\", 'Inputs and assumptions'!H10, IF($B$174=\"12 am until 5 am\",  'Inputs and assumptions'!H11,'Inputs and assumptions'!H9))","v":0.9},{"$f":"IF($B$174=\"5 pm until 5 am\", 'Inputs and assumptions'!I10, IF($B$174=\"12 am until 5 am\",  'Inputs and assumptions'!I11,'Inputs and assumptions'!I9))","v":0.9},{"$f":"IF($B$174=\"5 pm until 5 am\", 'Inputs and assumptions'!J10, IF($B$174=\"12 am until 5 am\",  'Inputs and assumptions'!J11,'Inputs and assumptions'!J9))","v":0.9},{"$f":"IF($B$174=\"5 pm until 5 am\", 'Inputs and assumptions'!K10, IF($B$174=\"12 am until 5 am\",  'Inputs and assumptions'!K11,'Inputs and assumptions'!K9))","v":0.75},{"$f":"IF($B$174=\"5 pm until 5 am\", 'Inputs and assumptions'!L10, IF($B$174=\"12 am until 5 am\",  'Inputs and assumptions'!L11,'Inputs and assumptions'!L9))","v":0.75},{"$f":"IF($B$174=\"5 pm until 5 am\", 'Inputs and assumptions'!M10, IF($B$174=\"12 am until 5 am\",  'Inputs and assumptions'!M11,'Inputs and assumptions'!M9))","v":0.75},{"$f":"IF($B$174=\"5 pm until 5 am\", 'Inputs and assumptions'!N10, IF($B$174=\"12 am until 5 am\",  'Inputs and assumptions'!N11,'Inputs and assumptions'!N9))","v":0.75},{"$f":"IF($B$174=\"5 pm until 5 am\", 'Inputs and assumptions'!O10, IF($B$174=\"12 am until 5 am\",  'Inputs and assumptions'!O11,'Inputs and assumptions'!O9))","v":0.6},{"$f":"IF($B$174=\"5 pm until 5 am\", 'Inputs and assumptions'!P10, IF($B$174=\"12 am until 5 am\",  'Inputs and assumptions'!P11,'Inputs and assumptions'!P9))","v":0.4},{"$f":"IF($B$174=\"5 pm until 5 am\", 'Inputs and assumptions'!Q10, IF($B$174=\"12 am until 5 am\",  'Inputs and assumptions'!Q11,'Inputs and assumptions'!Q9))","v":0.75}]
[null,null,null,{"$f":"Sim_template!D162","v":"Monday"},{"$f":"Sim_template!E162","v":"Tuesday"},{"$f":"Sim_template!F162","v":"Wednesday"},{"$f":"Sim_template!G162","v":"Thursday"},{"$f":"Sim_template!H162","v":"Friday"},{"$f":"Sim_template!I162","v":"Saturday"},{"$f":"Sim_template!J162","v":"Sunday"},{"$f":"Sim_template!K162","v":"Monday"},{"$f":"Sim_template!L162","v":"Tuesday"},{"$f":"Sim_template!M162","v":"Wednesday"},{"$f":"Sim_template!N162","v":"Thursday"},{"$f":"Sim_template!O162","v":"Friday"},{"$f":"Sim_template!P162","v":"Saturday"},{"$f":"Sim_template!Q162","v":"Sunday"},{"$f":"Sim_template!R162","v":"Total"}]
[null,null,null,{"$f":"Sim_template!D163","v":"Day"},{"$f":"Sim_template!E163","v":"Day"},{"$f":"Sim_template!F163","v":"Day"},{"$f":"Sim_template!G163","v":"Day"},{"$f":"Sim_template!H163","v":"Day"},{"$f":"Sim_template!I163","v":"Day"},{"$f":"Sim_template!J163","v":"Day"},{"$f":"Sim_template!K163","v":"Night"},{"$f":"Sim_template!L163","v":"Night"},{"$f":"Sim_template!M163","v":"Night"},{"$f":"Sim_template!N163","v":"Night"},{"$f":"Sim_template!O163","v":"Night"},{"$f":"Sim_template!P163","v":"Night"},{"$f":"Sim_template!Q163","v":"Night"}]
[null,{"$f":"Sim_template!B166","v":"Standard kilometre charge (kms)"},null,{"$f":"D164*D174*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":288919.34981445211},{"$f":"E164*E174*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":286887.45447217755},{"$f":"F164*F174*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":295008.45995265496},{"$f":"G164*G174*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":312836.78428243723},{"$f":"H164*H174*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":316621.68000284804},{"$f":"I164*I174*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":224464.33000070346},{"$f":"J164*J174*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":204638.22218234208},{"$f":"K164*K174*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":198370.65930112268},{"$f":"L164*L174*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":242506.10678657747},{"$f":"M164*M174*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":277587.90485396801},{"$f":"N164*N174*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":325703.27374314022},{"$f":"O164*O174*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":343574.8294821062},{"$f":"P164*P174*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":211678.03817854199},{"$f":"Q164*Q174*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":172749.78067334997},{"$f":"SUM(D177:Q177)","v":3701546.873726422}]
[null,{"$f":"Sim_template!B167","v":"Night kilometre charge (kms)"},null,{"$f":"D164*(1-D174)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":32102.149979383561},{"$f":"E164*(1-E174)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":31876.383830241943},{"$f":"F164*(1-F174)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":32778.717772517215},{"$f":"G164*(1-G174)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":34759.64269804857},{"$f":"H164*(1-H174)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":35180.186666983107},{"$f":"I164*(1-I174)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":24940.48111118927},{"$f":"J164*(1-J174)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":22737.580242482447},{"$f":"K164*(1-K174)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":66123.553100374222},{"$f":"L164*(1-L174)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":80835.368928859156},{"$f":"M164*(1-M174)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":92529.301617989331},{"$f":"N164*(1-N174)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":108567.75791438007},{"$f":"O164*(1-O174)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":229049.88632140416},{"$f":"P164*(1-P174)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":317517.05726781295},{"$f":"Q164*(1-Q174)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":57583.260224449979},{"$f":"SUM(D178:Q178)","v":1166581.3276761158}]
[]
[null,"Waiting time threshold adjustment"]
[null,"Flagfall (no of trips)",null,{"$f":"D165","v":54674.135057523599},54289.625953382194,55826.417970696581,59200.190661524815,59916.431716093437,42476.881877023829,38725.055295584199,45046.80309592915,55069.257119283553,63035.772204531066,73962.002705929961,97525.433870390174,90128.804889374849,39228.71145497726,{"$f":"SUM(D181:Q181)","v":829105.52387224464}]
[null,"Standard kilometre charge (kms)",null,{"$f":"(D168-D184)*AVERAGE(Sim_template!$F$159:$G$159)*D174+D177","v":289597.9773614076},{"$f":"(E168-E184)*AVERAGE(Sim_template!$F$159:$G$159)*E174+E177","v":287561.3094064552},{"$f":"(F168-F184)*AVERAGE(Sim_template!$F$159:$G$159)*F174+F177","v":295701.38989188318},{"$f":"(G168-G184)*AVERAGE(Sim_template!$F$159:$G$159)*G174+G177","v":313571.5902400561},{"$f":"(H168-H184)*AVERAGE(Sim_template!$F$159:$G$159)*H174+H177","v":317365.37610403076},{"$f":"(I168-I184)*AVERAGE(Sim_template!$F$159:$G$159)*I174+I177","v":224991.56252336147},{"$f":"(J168-J184)*AVERAGE(Sim_template!$F$159:$G$159)*J174+J177","v":205118.88619748031},{"$f":"(K168-K184)*AVERAGE(Sim_template!$F$159:$G$159)*K174+K177","v":198836.60176567524},{"$f":"(L168-L184)*AVERAGE(Sim_template!$F$159:$G$159)*L174+L177","v":243075.71669493424},{"$f":"(M168-M184)*AVERAGE(Sim_template!$F$159:$G$159)*M174+M177","v":278239.91656262148},{"$f":"(N168-N184)*AVERAGE(Sim_template!$F$159:$G$159)*N174+N177","v":326468.30112478713},{"$f":"(O168-O184)*AVERAGE(Sim_template!$F$159:$G$159)*O174+O177","v":344381.83442613931},{"$f":"(P168-P184)*AVERAGE(Sim_template!$F$159:$G$159)*P174+P177","v":212175.23764920988},{"$f":"(Q168-Q184)*AVERAGE(Sim_template!$F$159:$G$159)*Q174+Q177","v":173155.54359636203},{"$f":"SUM(D182:Q182)","v":3710241.2435444039}]
[null,"Night kilometre charge (kms)",null,{"$f":"(D168-D184)*AVERAGE(Sim_template!$F$159:$G$159)*(1-D174)+D178","v":32177.553040156396},{"$f":"(E168-E184)*AVERAGE(Sim_template!$F$159:$G$159)*(1-E174)+E178","v":31951.256600717239},{"$f":"(F168-F184)*AVERAGE(Sim_template!$F$159:$G$159)*(1-F174)+F178","v":32855.709987987022},{"$f":"(G168-G184)*AVERAGE(Sim_template!$F$159:$G$159)*(1-G174)+G178","v":34841.287804450672},{"$f":"(H168-H184)*AVERAGE(Sim_template!$F$159:$G$159)*(1-H174)+H178","v":35262.819567114522},{"$f":"(I168-I184)*AVERAGE(Sim_template!$F$159:$G$159)*(1-I174)+I178","v":24999.062502595716},{"$f":"(J168-J184)*AVERAGE(Sim_template!$F$159:$G$159)*(1-J174)+J178","v":22790.987355275582},{"$f":"(K168-K184)*AVERAGE(Sim_template!$F$159:$G$159)*(1-K174)+K178","v":66278.867255225079},{"$f":"(L168-L184)*AVERAGE(Sim_template!$F$159:$G$159)*(1-L174)+L178","v":81025.238898311407},{"$f":"(M168-M184)*AVERAGE(Sim_template!$F$159:$G$159)*(1-M174)+M178","v":92746.638854207151},{"$f":"(N168-N184)*AVERAGE(Sim_template!$F$159:$G$159)*(1-N174)+N178","v":108822.76704159571},{"$f":"(O168-O184)*AVERAGE(Sim_template!$F$159:$G$159)*(1-O174)+O178","v":229587.88961742623},{"$f":"(P168-P184)*AVERAGE(Sim_template!$F$159:$G$159)*(1-P174)+P178","v":318262.85647381481},{"$f":"(Q168-Q184)*AVERAGE(Sim_template!$F$159:$G$159)*(1-Q174)+Q178","v":57718.514532120666},1169321.4495309982]
[null,"Waiting time hours",null,{"$f":"D168*(1+(Sim_template!$L$18-Sim_template!$F$159)/Sim_template!$F$159)","v":4716.95617730503},{"$f":"E168*(1+(Sim_template!$L$18-Sim_template!$F$159)/Sim_template!$F$159)","v":4683.7830399138011},{"$f":"F168*(1+(Sim_template!$L$18-Sim_template!$F$159)/Sim_template!$F$159)","v":4816.3682301811441},{"$f":"G168*(1+(Sim_template!$L$18-Sim_template!$F$159)/Sim_template!$F$159)","v":5107.4370860136496},{"$f":"H168*(1+(Sim_template!$L$18-Sim_template!$F$159)/Sim_template!$F$159)","v":5169.2300647819893},{"$f":"I168*(1+(Sim_template!$L$18-Sim_template!$F$159)/Sim_template!$F$159)","v":3664.6503900186026},{"$f":"J168*(1+(Sim_template!$L$18-Sim_template!$F$159)/Sim_template!$F$159)","v":3340.9653138691706},{"$f":"K168*(1+(Sim_template!$L$18-Sim_template!$F$159)/Sim_template!$F$159)","v":3886.3677661773427},{"$f":"L168*(1+(Sim_template!$L$18-Sim_template!$F$159)/Sim_template!$F$159)","v":4751.0449369725984},{"$f":"M168*(1+(Sim_template!$L$18-Sim_template!$F$159)/Sim_template!$F$159)","v":5438.348037486503},{"$f":"N168*(1+(Sim_template!$L$18-Sim_template!$F$159)/Sim_template!$F$159)","v":6380.9976176583259},{"$f":"O168*(1+(Sim_template!$L$18-Sim_template!$F$159)/Sim_template!$F$159)","v":8413.9090130148707},{"$f":"P168*(1+(Sim_template!$L$18-Sim_template!$F$159)/Sim_template!$F$159)","v":7775.7722646872426},{"$f":"Q168*(1+(Sim_template!$L$18-Sim_template!$F$159)/Sim_template!$F$159)","v":3384.4177439768855},71530.247682057146]
[null,"Booking fee (number)",null,{"$f":"D169","v":10934.82701150472},{"$f":"E169","v":10857.92519067644},11165.283594139317,11840.038132304964,11983.286343218688,8495.3763754047668,7745.0110591168404,9009.3606191858307,11013.851423856711,12607.154440906213,14792.400541185993,19505.086774078034,18025.760977874972,7845.7422909954521,165821.10477444896]