{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Examples","Description","Sim_template","Inputs and assumptions","Base model"],"not_rendered":{"charts":22,"images":15,"macros":1,"external_links":0,"defined_names":69,"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 - 2014 reviews"]
[]
[]
[]
[]
[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":"Sim_template","index":2,"n_rows":195,"n_cols":23,"rows_kept":195,"cut":false,"hidden":false,"merged":[[2,15,3,16],[14,10,14,12],[13,15,14,18],[16,15,17,17],[6,9,7,11],[24,11,25,11],[24,13,25,13],[2,1,3,2],[2,9,3,10],[19,11,20,11],[19,13,20,13],[15,1,16,7],[4,1,5,7],[4,9,5,10],[18,3,19,3],[18,5,19,5],[6,5,7,5],[6,6,7,7],[140,9,140,15],[140,16,140,22],[182,1,182,2],[183,1,183,2],[31,1,32,4]]}
[]
[]
[null,"step 1",null,null,null,null,null,null,null,"step 2",null,null,null,null,null,"step 3"]
[]
[null,"Forecasts (annual % change)",null,null,null,null,null,null,null,"Refine fares",null,null,null,null,null,"Number of years after 2012/13",null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"do not use this cell",null,"Simulation year",null,null,{"$f":"INDEX(B21:B30,S5*2-1, 1)","v":"2014/15"}]
[null,null,null,null,null,"Annual",{"$f":"\"Cumulative for \"&S5&\" years\"","v":"Cumulative for 2 years"},null,null,{"$f":"\"Actual average fare increase over \"&S5&\" years\"","v":"Actual average fare increase over 2 years"},null,null,"nominal",{"$f":"SUMPRODUCT(D161:Q165,Sim_template!D191:Q195)/C155-1","v":3.861900462969059E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"GST inclusive"]
[null,"Change in demand",null,null,"%",2.5000000000000001E-2,null,{"$f":"(1+F9)^$S$5-1","v":5.062499999999992E-2},null,"Flagfall",null,null,"$/trip",3.6]
[]
[null,"CPI",null,null,"%",2.5000000000000001E-2,null,{"$f":"(1+F11)^$S$5-1","v":5.062499999999992E-2},null,"Standard kilometre charge",null,null,"$/km",2.1886719620660888]
[]
[null,"Real change in costs (more than CPI)",null,null,"%",0,null,{"$f":"(1+F13)^$S$5-1","v":0},null,"Waiting time",null,null,"$/hr",56.68,null,"Check on model",null,{"$f":"IF(AND(SUM(ABS(J121:W123))<0.1, H31-N7<0.005), \"MODEL SIMULATION CORRECT\",\"ERROR IN MODEL SIMULATION\")","v":"MODEL SIMULATION CORRECT"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"$/min",{"$f":"N13/60","v":0.94466666666666665},null,"Summary of model outputs"]
[null,null,null,null,null,null,null,null,null,null,"Charged when the taxi speed falls below (km/h)",null,null,{"$f":"N13/N11","v":25.896982728510185},null,null,null,null,null,"See outputs for each shift"]
[null,"Number of licences and fare change"]
[null,null,null,null,null,null,null,null,null,"Booking fee ",null,null,"($/booking)",2.5,null,null,null,null,"Difference ",null,"In equilibrium","2012/13"]
[null,"Note: Do not include replacement licences here"]
[null,null,null,"Unrestricted licences",null,"Peak availabiliity licences",null,"Fare change",null,"Surcharges",null,null,null,null,null,"Plate lease costs ",null,null,{"$f":"U19/V19-1","v":3.172979119550412E-2},"$2012/13 (ex GST)",{"$f":"J67","v":29222.659738898488},{"$f":"'Base model'!B153","v":28323.946820452955}]
[null,null,null,null,null,null,null,null,null,null,null,"Flag fall surcharge",null,"Distance surcharge",null,"Total trips ",null,null,{"$f":"U20/V20-1","v":6.5062768465805831E-2},"000,000",{"$f":"SUM(J58:W58)*365/7/1000000/7","v":45.855441868485904},{"$f":"SUM('Base model'!J122:W122)*365/7/1000000/7","v":43.054215419190207}]
[null,"2013/14",null,0,null,250,null,1.4E-2,null,null,null,null,null,null,null,"Average occupancy",null,null,{"$f":"U21/V21-1","v":2.9121860523677379E-2},"%",{"$f":"SUMPRODUCT(J54:W54,J62:W62)/SUM(J62:W62)","v":0.30719032459381973},{"$f":"'Base model'!B148","v":0.2984975214086924}]
[null,null,null,null,null,null,null,null,null,"Level ","$ per trip",2.5,"% per km",0.2,null,"Average waiting time",null,null,{"$f":"U22/V22-1","v":-2.1776622526774148E-2},"mins",{"$f":"AVERAGE(J56:W56)","v":8.0906004495768862},{"$f":"AVERAGE('Base model'!J123:W123)","v":8.2707085476479811}]
[null,"2014/15",null,0,null,95,null,2.5000000000000001E-2,null,null,null,null,null,null,null,"Average waiting time Fri and Sat nights ",null,null,{"$f":"U23/V23-1","v":-7.1047586618946945E-2},"mins",{"$f":"AVERAGE(U56:V56)","v":8.1331898119993653},{"$f":"AVERAGE('Base model'!U123:V123)","v":8.7552276035297396}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((N11*(1+N22)),2)","v":2.63},"per kilometre"]
[null,"2015/16",null,null,null,null,null,null,null,"Hours of operation",null,"10 pm until 6 am",null,"10 pm until 6 am",null,"Average annual revenue per taxi",null,null,{"$f":"U25/V25-1","v":1.7120976414545463E-2},"$2012/13 (ex GST)",{"$f":"U26+U19","v":162124.0197466102},{"$f":"'Base model'!B151","v":159395.02134555695}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average cost per taxi per year (excluding plate lease costs)",null,null,{"$f":"U26/V26-1","v":1.3964068649312766E-2},"$2012/13",{"$f":"SUMPRODUCT(J61:W61,J62:W62)/100*365/7","v":132901.36000771172},{"$f":"'Base model'!B152","v":131071.07452510398}]
[null,"2017/18",null,null,null,null,null,null,null,"Shifts that it applies",null,null,null,null,null,"Occupied kilometres per taxi per year",null,null,{"$f":"U27/V27-1","v":3.1692582504785127E-2},"km",{"$f":"SUMPRODUCT(J69:W69,J62:W62)/100*365/7","v":56356.61526029888},{"$f":"'Base model'!B150","v":54625.395409429038}]
[null,null,null,null,null,null,null,null,null,"(only applies during the hours specified above)",null,null,null,null,null,"Peak plate costs",null,null,{"$f":"U28/V28-1","v":-2.4423033711255759E-2},"$2012/13 (ex GST)",{"$f":"(SUM($Q$55:$W$55)+'Inputs and assumptions'!$C$63*SUM($Q$60:$W$60))*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":20876.334857982409},{"$f":"'Base model'!B154","v":21398.962439016403}]
[null,"2017/18",null,null,null,null,null,null,null,"Monday ","3 am - 3 pm","No",null,"Yes",null,"Kilometres per year",null,null,{"$f":"U29/V29-1","v":3.1692582504785127E-2},"km",{"$f":"'Inputs and assumptions'!C53*U27","v":112405.69238239845},{"$f":"'Base model'!B149","v":108952.69995011047}]
[null,null,null,null,null,null,null,null,null,"Tuesday","3 am - 3 pm","No",null,"Yes"]
[null,{"$f":"\"Cumulatiave for \"&S5&\" years\"","v":"Cumulatiave for 2 years"},null,{"$f":"SUM(D21:OFFSET(D21,$S$5-1+2, 0))","v":0},null,{"$f":"SUM(F21:OFFSET(F21,($S$5-1)*2, 0))","v":345},null,{"$f":"PRODUCT(1+H21:OFFSET(H21,($S$5-1)*2, 0))-1","v":3.9349999999999996E-2},null,"Wednesday","3 am - 3 pm","No",null,"Yes"]
[null,null,null,null,null,null,null,null,null,"Thursday","3 am - 3 pm","No",null,"Yes"]
[null,null,null,null,null,null,null,null,null,"Friday","3 am - 3 pm","No",null,"Yes",null,"Fare schedule"]
[null,null,null,null,null,null,null,null,null,"Saturday","3 am - 3 pm","Yes",null,"Yes",null,null,null,null,"Dfiference",null,{"$f":"S6","v":"2014/15"},"2012/13"]
[null,null,null,null,null,null,null,null,null,"Sunday","3 am - 3 pm","Yes",null,"Yes"]
[null,null,null,null,null,null,null,null,null,"Monday","3 pm - 3 am","No",null,"Yes",null,"Flagfall ($)",null,null,{"$f":"N9/V36-1","v":2.8571428571428692E-2},null,{"$f":"N9","v":3.6},{"$f":"'Inputs and assumptions'!C15","v":3.5}]
[null,null,null,null,null,null,null,null,null,"Tuesday","3 pm - 3 am","No",null,"Yes",null,"Flagfall surcharge ($)",null,null,null,null,{"$f":"L22","v":2.5}]
[null,null,null,null,null,null,null,null,null,"Wednesday","3 pm - 3 am","No",null,"Yes",null,"Standard kilometre charge ($/km)",null,null,{"$f":"N11/V38-1","v":2.274390750751798E-2},null,{"$f":"N11","v":2.1886719620660888},{"$f":"'Inputs and assumptions'!C16","v":2.14}]
[null,null,null,null,null,null,null,null,null,"Thursday","3 pm - 3 am","No",null,"Yes",null,"Night kilometre charge ($/km)",null,null,{"$f":"M24/V39-1","v":2.3346303501945442E-2},null,{"$f":"M24","v":2.63},{"$f":"'Inputs and assumptions'!C17","v":2.57}]
[null,null,null,null,null,null,null,null,null,"Friday","3 pm - 3 am","Yes",null,"Yes",null,"Waiting time ($/hour when vehicle slower than 26km/hour)",null,null,{"$f":"N13/V40-1","v":2.4954792043399676E-2},null,{"$f":"N13","v":56.68},{"$f":"'Inputs and assumptions'!C18","v":55.3}]
[null,null,null,null,null,null,null,null,null,"Saturday","3 pm - 3 am","Yes",null,"Yes",null,"Booking fee ($/booking)",null,null,{"$f":"N17/V41-1","v":4.1666666666666741E-2},null,{"$f":"N17","v":2.5},{"$f":"'Inputs and assumptions'!C19","v":2.4}]
[null,null,null,null,null,null,null,null,null,"Sunday","3 pm - 3 am","No",null,"Yes"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Nominal surplus",{"$f":"J55*(1+$H$11)","v":44.10382235923835},41.670669399930794,44.786579821457302,48.716387124563049,56.46747574771549,17.695123381484553,15.306953836076811,17.695434744679538,31.64201468981403,47.152590816383267,69.381608287129978,129.61458795149849,133.53332315075284,11.951321160593194]
[null,"MODEL OUTPUTS FOR EACH SHIFT",null,null,null,null,null,null,"Basear surplus",{"$f":"'Base model'!J136","v":36.461166429609968},{"$f":"'Base model'!K136","v":34.343249481653025},{"$f":"'Base model'!L136","v":37.038633553030515},{"$f":"'Base model'!M136","v":40.43136729854929},{"$f":"'Base model'!N136","v":47.282069551731894},{"$f":"'Base model'!O136","v":15.950806531038362},{"$f":"'Base model'!P136","v":13.194853238496282},{"$f":"'Base model'!Q136","v":17.192514766145258},{"$f":"'Base model'!R136","v":33.57692812411819},{"$f":"'Base model'!S136","v":49.326272955847678},{"$f":"'Base model'!T136","v":71.514122164211713},{"$f":"'Base model'!U136","v":123.43806803679196},{"$f":"'Base model'!V136","v":124.17190935671084},{"$f":"'Base model'!W136","v":12.082107327488385}]
[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,"Occupancy rate of taxis (time)",null,null,null,null,null,null,null,{"$f":"J58*J111/J57","v":0.28903043623890579},0.28539569304415946,0.29105039307437891,0.29934955949322095,0.30942459912803072,0.25469837214399177,0.25054651625381563,0.24557767090423513,0.27874412546657146,0.30739248353167542,0.34307824568089945,0.42346134852217815,0.40438617364505164,0.26463281650431991]
[null,"Average surplus accruing to shift (adjusted for distribution)",null,null,null,null,null,null,null,{"$f":"J65*J64+_xlfn.NORM.DIST(-1*(J63-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$64","v":41.978653048650429},{"$f":"K65*K64+_xlfn.NORM.DIST(-1*(K63-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$64","v":39.662743033842517},{"$f":"L65*L64+_xlfn.NORM.DIST(-1*(L63-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$64","v":42.628511430298445},{"$f":"M65*M64+_xlfn.NORM.DIST(-1*(M63-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$64","v":46.368958595657872},{"$f":"N65*N64+_xlfn.NORM.DIST(-1*(N63-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$64","v":53.746556333340152},{"$f":"O65*O64+_xlfn.NORM.DIST(-1*(O63-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$64","v":16.842473176903798},{"$f":"P65*P64+_xlfn.NORM.DIST(-1*(P63-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$64","v":14.569379023035633},{"$f":"Q65*Q64+_xlfn.NORM.DIST(-1*(Q63-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$64","v":16.842769536875231},{"$f":"R65*R64+_xlfn.NORM.DIST(-1*(R63-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$64","v":30.117325106307227},{"$f":"S65*S64+_xlfn.NORM.DIST(-1*(S63-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$64","v":44.880514756819295},{"$f":"T65*T64+_xlfn.NORM.DIST(-1*(T63-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$64","v":66.038413598695996},{"$f":"U65*U64+_xlfn.NORM.DIST(-1*(U63-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$64","v":123.36903076882665},{"$f":"V65*V64+_xlfn.NORM.DIST(-1*(V63-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$64","v":127.09893934634418},{"$f":"W65*W64+_xlfn.NORM.DIST(-1*(W63-100)/'Inputs and assumptions'!$C$59,0,1,FALSE)*'Inputs and assumptions'!$C$59/$H$64","v":11.375439534175557}]
[null,"W",null,"Equilibrium waiting time",null,null,null,"Minutes, average",null,{"$f":"IF(J57=J$126,J125,IF('Inputs and assumptions'!$C$61=\"Flat\",J128,J119))","v":7.84020161274334},{"$f":"IF(K57=K$126,K125,IF('Inputs and assumptions'!$C$61=\"Flat\",K128,K119))","v":7.7415526083819586},{"$f":"IF(L57=L$126,L125,IF('Inputs and assumptions'!$C$61=\"Flat\",L128,L119))","v":7.7383531003304258},{"$f":"IF(M57=M$126,M125,IF('Inputs and assumptions'!$C$61=\"Flat\",M128,M119))","v":7.5687939165027602},{"$f":"IF(N57=N$126,N125,IF('Inputs and assumptions'!$C$61=\"Flat\",N128,N119))","v":7.9318026248980331},{"$f":"IF(O57=O$126,O125,IF('Inputs and assumptions'!$C$61=\"Flat\",O128,O119))","v":8.7535058640356791},{"$f":"IF(P57=P$126,P125,IF('Inputs and assumptions'!$C$61=\"Flat\",P128,P119))","v":9.5536956545817375},{"$f":"IF(Q57=Q$126,Q125,IF('Inputs and assumptions'!$C$61=\"Flat\",Q128,Q119))","v":7.736883493094453},{"$f":"IF(R57=R$126,R125,IF('Inputs and assumptions'!$C$61=\"Flat\",R128,R119))","v":7.4748864626289331},{"$f":"IF(S57=S$126,S125,IF('Inputs and assumptions'!$C$61=\"Flat\",S128,S119))","v":7.5034715052370924},{"$f":"IF(T57=T$126,T125,IF('Inputs and assumptions'!$C$61=\"Flat\",T128,T119))","v":7.5289285907088033},{"$f":"IF(U57=U$126,U125,IF('Inputs and assumptions'!$C$61=\"Flat\",U128,U119))","v":8.0526063392678928},{"$f":"IF(V57=V$126,V125,IF('Inputs and assumptions'!$C$61=\"Flat\",V128,V119))","v":8.2137732847308378},{"$f":"IF(W57=W$126,W125,IF('Inputs and assumptions'!$C$61=\"Flat\",W128,W119))","v":9.6299512369344811}]
[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(J129,J126),MIN(J120,J126))","v":4441.6922853847236},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(K129,K126),MIN(K120,K126))","v":4475.411867058142},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(L129,L126),MIN(L120,L126))","v":4512.9736647141899},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(M129,M126),MIN(M120,M126))","v":4668.7285961140406},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(N129,N126),MIN(N120,N126))","v":4520.0548513604335},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(O129,O126),MIN(O120,O126))","v":3795.0072605831306},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(P129,P126),MIN(P120,P126))","v":3457.8856160511964},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(Q129,Q126),MIN(Q120,Q126))","v":4241.7602397208893},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(R129,R126),MIN(R120,R126))","v":4592.3263577271609},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(S129,S126),MIN(S120,S126))","v":4764.0605203603418},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(T129,T126),MIN(T120,T126))","v":5005.8736757287752},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(U129,U126),MIN(U120,U126))","v":5332.88},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(V129,V126),MIN(V120,V126))","v":5060.800597266968},{"$f":"IF('Inputs and assumptions'!$C$61=\"Flat\",MIN(W129,W126),MIN(W120,W126))","v":3496.2169566768634}]
[null,"Q",null,"Equilibrium demand",null,null,null,"Occupied kilometres",null,{"$f":"IF(J57=J$126,J124,IF('Inputs and assumptions'!$C$61=\"Flat\",J127,J118))","v":410810.96284279326},{"$f":"IF(K57=K$126,K124,IF('Inputs and assumptions'!$C$61=\"Flat\",K127,K118))","v":408724.24686627649},{"$f":"IF(L57=L$126,L124,IF('Inputs and assumptions'!$C$61=\"Flat\",L127,L118))","v":420320.88289580325},{"$f":"IF(M57=M$126,M124,IF('Inputs and assumptions'!$C$61=\"Flat\",M127,M118))","v":447226.19156484539},{"$f":"IF(N57=N$126,N124,IF('Inputs and assumptions'!$C$61=\"Flat\",N127,N118))","v":447557.17133405199},{"$f":"IF(O57=O$126,O124,IF('Inputs and assumptions'!$C$61=\"Flat\",O127,O118))","v":309306.29489444895},{"$f":"IF(P57=P$126,P124,IF('Inputs and assumptions'!$C$61=\"Flat\",P127,P118))","v":277235.58230585803},{"$f":"IF(Q57=Q$126,Q124,IF('Inputs and assumptions'!$C$61=\"Flat\",Q127,Q118))","v":333338.11206555075},{"$f":"IF(R57=R$126,R124,IF('Inputs and assumptions'!$C$61=\"Flat\",R127,R118))","v":409626.87822135765},{"$f":"IF(S57=S$126,S124,IF('Inputs and assumptions'!$C$61=\"Flat\",S127,S118))","v":468619.64641560684},{"$f":"IF(T57=T$126,T124,IF('Inputs and assumptions'!$C$61=\"Flat\",T127,T118))","v":549570.03480615164},{"$f":"IF(U57=U$126,U124,IF('Inputs and assumptions'!$C$61=\"Flat\",U127,U118))","v":722645.93801822513},{"$f":"IF(V57=V$126,V124,IF('Inputs and assumptions'!$C$61=\"Flat\",V127,V118))","v":654885.69251500198},{"$f":"IF(W57=W$126,W124,IF('Inputs and assumptions'!$C$61=\"Flat\",W127,W118))","v":296068.39691377926}]
[null,null,null,null,null,null,null,null,"Differnce in surplus (nominal)",{"$f":"J50-J51","v":7.6426559296283827},{"$f":"K50-K51","v":7.3274199182777693},7.7479462684267872,8.2850198260137589,9.185406195983596,1.7443168504461912,2.1121005975805289,0.50291997853427972,-1.9349134343041605,-2.173682139464411,-2.1325138770817347,6.1765199147065317,9.3614137940419937,-0.13078616689519151]
[null,"Revenue per taxi (excluding GST)",null,null,null,null,null,null,null,{"$f":"J58*J106/J57","v":253.01566570166901},249.83383135563778,254.78392488594884,262.04896985338127,270.86860453733902,225.48027155159761,221.804701952626,218.75887132536047,248.3033170365907,273.82307399401719,305.6117012800612,400.4874661485108,398.7476717900214,235.73306172738808]
[null,"Cost per taxi",null,null,null,null,null,null,null,{"$f":"J108+J109*J57+J107*J58/J57","v":215.86484869790974},215.60674567321996,216.81847079844005,219.5025125048046,219.72107412516783,225.48027155145496,221.80470195245726,218.75887132526421,227.03828797036616,233.01015689278998,240.7000378229406,276.80253704346887,271.40664788324216,235.73306172717537]
[null,"Share of taxis on the road",null,null,null,null,null,"%",null,{"$f":"J57/('Base model'!J6+$D$31)*100","v":82.851935933309534},{"$f":"K57/('Base model'!K6+$D$31)*100","v":83.480915259431868},{"$f":"L57/('Base model'!L6+$D$31)*100","v":84.181564348334078},{"$f":"M57/('Base model'!M6+$D$31)*100","v":87.08689789431152},{"$f":"N57/('Base model'!N6+$D$31)*100","v":84.313651396389361},{"$f":"O57/('Base model'!O6+$D$31)*100","v":70.78916733040721},{"$f":"P57/('Base model'!P6+$D$31)*100","v":64.50075762080202},{"$f":"Q57/('Base model'!Q6+$D$31+$F$31)*100","v":70.790391183592945},{"$f":"R57/('Base model'!R6+$D$31+$F$31)*100","v":76.640960576220976},{"$f":"S57/('Base model'!S6+$D$31+$F$31)*100","v":79.507018030045757},{"$f":"T57/('Base model'!T6+$D$31+$F$31)*100","v":83.542618086261271},{"$f":"U57/('Base model'!U6+$D$31+$F$31)*100","v":89},{"$f":"V57/('Base model'!V6+$D$31+$F$31)*100","v":84.459289006458079},{"$f":"W57/('Base model'!W6+$D$31+$F$31)*100","v":58.348080051349527}]
[null,"Free market taxis on the road as a proportion of maximum",null,null,null,null,null,"%",null,{"$f":"J120/J126*100","v":120.09869933916583},118.46973169843646,120.34240751517974,122.29568276181169,127.19060482799736,93.143641224220005,84.869417922107928,93.145251557359146,110.91816355170174,120.30632404312311,131.03729794091609,152.01162233999057,154.52669481774473,76.773789541249371]
[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*(J63-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.78884071353020091},{"$f":"(1-_xlfn.NORM.DIST(-1*(K63-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.76955179521935957},{"$f":"(1-_xlfn.NORM.DIST(-1*(L63-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.79164287907622422},{"$f":"(1-_xlfn.NORM.DIST(-1*(M63-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.8132981880874347},{"$f":"(1-_xlfn.NORM.DIST(-1*(N63-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.86115808455864362},{"$f":"(1-_xlfn.NORM.DIST(-1*(O63-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.39214679945947628},{"$f":"(1-_xlfn.NORM.DIST(-1*(P63-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.27290124289792517},{"$f":"(1-_xlfn.NORM.DIST(-1*(Q63-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.39217150448032911},{"$f":"(1-_xlfn.NORM.DIST(-1*(R63-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.66854118407738194},{"$f":"(1-_xlfn.NORM.DIST(-1*(S63-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.79122937878286492},{"$f":"(1-_xlfn.NORM.DIST(-1*(T63-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.8923475414821167},{"$f":"(1-_xlfn.NORM.DIST(-1*(U63-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.98107487032246166},{"$f":"(1-_xlfn.NORM.DIST(-1*(V63-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.98525533175740698},{"$f":"(1-_xlfn.NORM.DIST(-1*(W63-100)/'Inputs and assumptions'!$C$59,0,1,TRUE))","v":0.17689431382367005}]
[null,"Surplus per taxi",null,null,null,null,null,null,null,{"$f":"J60-J61","v":37.150817003759272},34.227085682417822,37.965454087508789,42.546457348576666,51.147530412171193,1.4264855963119771E-10,1.6873968888830859E-10,9.6264329840778373E-11,21.265029066224542,40.812917101227214,64.911663457120596,123.68492910504193,127.34102390677924,2.1270807337714359E-10]
[null,"Surplus (basic)",null,null,null,null,null,"$/taxi",null,{"$f":"SUMPRODUCT(J62:W62,J65:W65)*365/7/100","v":25659.321584042955}]
[null,"Surplus accounting for shift variation",null,null,null,null,null,"$/taxi",null,{"$f":"SUMPRODUCT(J62:W62,J55:W55)*365/7/100","v":29222.659738898488}]
[null,"Revenue per taxi (including GST)",null,null,null,null,null,null,null,{"$f":"J60*$D$113","v":278.31723227183591},274.81721449120158,280.26231737454373,288.25386683871943,297.95546499107297,248.0282987067574,243.98517214788862,240.63475845789654,273.13364874024978,301.20538139341892,336.17287140806735,440.5362127633619,438.62243896902356,259.30636790012693]
[null,"Occupied kms per shift",null,null,null,null,null,null,null,{"$f":"J60/J106","v":92.489739596449837},91.326621774131027,93.136125783801248,95.79185903783069,99.015871720969827,81.503479086077377,80.174885201221002,78.58485468935524,89.198120149302838,98.365594730136138,109.78503861788782,135.507631527097,129.40357556641652,84.682501281382372]
[]
[null,"Difference in revenue per taxi per shift (nominal)",null,null,null,null,null,null,null,{"$f":"J68-'Base model'!J141","v":10.896008382010336},{"$f":"K68-'Base model'!K141","v":10.780462221204687},{"$f":"L68-'Base model'!L141","v":10.967583441176714},{"$f":"M68-'Base model'!M141","v":11.249209925999025},{"$f":"N68-'Base model'!N141","v":11.569557714427162},{"$f":"O68-'Base model'!O141","v":2.6062836078254179},{"$f":"P68-'Base model'!P141","v":2.4900527303760498},{"$f":"Q68-'Base model'!Q141","v":2.9978237061113191},{"$f":"R68-'Base model'!R141","v":-1.9257890302008605},{"$f":"S68-'Base model'!S141","v":-2.1564926707732752},{"$f":"T68-'Base model'!T141","v":-2.463239578167304},{"$f":"U68-'Base model'!U141","v":2.1340679878877609},{"$f":"V68-'Base model'!V141","v":4.2749583667825846},{"$f":"W68-'Base model'!W141","v":2.8694033386129831}]
[null,"Difference in costs per taxi per shift (nominal)",null,null,null,null,null,null,null,{"$f":"J61-'Base model'!J132","v":2.8085175183364868},{"$f":"K61-'Base model'!K132","v":2.7765596293454564},{"$f":"L61-'Base model'!L132","v":2.8274296963124357},{"$f":"M61-'Base model'!M132","v":2.9031844163725111},{"$f":"N61-'Base model'!N132","v":2.9917783197624033},{"$f":"O61-'Base model'!O132","v":2.3693487342567892},{"$f":"P61-'Base model'!P132","v":2.26368430018087},{"$f":"Q61-'Base model'!Q132","v":2.7252942781879881},{"$f":"R61-'Base model'!R132","v":3.1454231082392141},{"$f":"S61-'Base model'!S132","v":3.3080715294645131},{"$f":"T61-'Base model'!T132","v":3.5221488909492109},{"$f":"U61-'Base model'!U132","v":1.9102886797747374},{"$f":"V61-'Base model'!V132","v":0.8856057074239061},{"$f":"W61-'Base model'!W132","v":2.6085484894355773}]
[]
[null,"Difference in surplus per taxi (accruing to the licence owner)",null,null,null,null,null,null,null,{"$f":"J65-'Base model'!J133","v":7.096944647127458},{"$f":"K65-'Base model'!K133","v":7.0238605717497364},{"$f":"L65-'Base model'!L133","v":7.1431007047573019},{"$f":"M65-'Base model'!M133","v":7.3233700618083901},{"$f":"N65-'Base model'!N133","v":7.5260014206259314},{"$f":"O65-'Base model'!O133","v":1.2994405551580712E-10},{"$f":"P65-'Base model'!P133","v":1.610089839232387E-10},{"$f":"Q65-'Base model'!Q133","v":9.5042196335271001E-11},{"$f":"R65-'Base model'!R133","v":-4.8961404084217861},{"$f":"S65-'Base model'!S133","v":-5.2685194119856362},{"$f":"T65-'Base model'!T133","v":-5.7614575983740224},{"$f":"U65-'Base model'!U133","v":2.9773127395969823E-2},{"$f":"V65-'Base model'!V133","v":3.0007200805602565},{"$f":"W65-'Base model'!W133","v":2.1270807337714359E-10}]
[null,"Difference in the number of taxis on the road",null,null,null,null,null,null,null,{"$f":"J57-'Base model'!J124","v":0},{"$f":"K57-'Base model'!K124","v":0},{"$f":"L57-'Base model'!L124","v":0},{"$f":"M57-'Base model'!M124","v":0},{"$f":"N57-'Base model'!N124","v":0},{"$f":"O57-'Base model'!O124","v":158.07575675223052},{"$f":"P57-'Base model'!P124","v":149.33213350540836},{"$f":"Q57-'Base model'!Q124","v":147.63603060139985},{"$f":"R57-'Base model'!R124","v":264.41131398796279},{"$f":"S57-'Base model'!S124","v":274.29921220365759},{"$f":"T57-'Base model'!T124","v":288.22203239760165},{"$f":"U57-'Base model'!U124","v":307.05000000000018},{"$f":"V57-'Base model'!V124","v":291.38454707227993},{"$f":"W57-'Base model'!W124","v":128.79297971888491}]
[null,"Additional taxis on the road",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W75/('Base model'!W6+$D$31+$F$31)","v":2.1494155493805893E-2}]
[null,null,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+$H$9)","v":788761.59552924929},{"$f":"'Base model'!K10*(1+$H$9)","v":783214.43846569443},{"$f":"'Base model'!L10*(1+$H$9)","v":805385.11427607841},{"$f":"'Base model'!M10*(1+$H$9)","v":854057.1660199404},{"$f":"'Base model'!N10*(1+$H$9)","v":862568.98937273084},{"$f":"'Base model'!O10*(1+$H$9)","v":611505.72594142123},{"$f":"'Base model'!P10*(1+$H$9)","v":557385.57285864733},{"$f":"'Base model'!Q10*(1+$H$9)","v":643153.98888229497},{"$f":"'Base model'!R10*(1+$H$9)","v":786249.18855235341},{"$f":"'Base model'!S10*(1+$H$9)","v":899990.7995531779},{"$f":"'Base model'!T10*(1+$H$9)","v":1055989.6329322585},{"$f":"'Base model'!U10*(1+$H$9)","v":1420425.6107208689},{"$f":"'Base model'!V10*(1+$H$9)","v":1310054.7463646447},{"$f":"'Base model'!W10*(1+$H$9)","v":576804.25402592134}]
[null,null,null,"Impact of price on demand kilometres",null,null,null,"Change in Q per extra dollar",null,{"$f":"'Base model'!J11*(1+$H$9)","v":114682.62864203741},{"$f":"'Base model'!K11*(1+$H$9)","v":113876.09526472223},{"$f":"'Base model'!L11*(1+$H$9)","v":117099.6185639255},{"$f":"'Base model'!M11*(1+$H$9)","v":124176.33080121691},{"$f":"'Base model'!N11*(1+$H$9)","v":125678.69397153234},{"$f":"'Base model'!O11*(1+$H$9)","v":89098.080199150296},{"$f":"'Base model'!P11*(1+$H$9)","v":81228.374823548627},{"$f":"'Base model'!Q11*(1+$H$9)","v":92860.37131941301},{"$f":"'Base model'!R11*(1+$H$9)","v":113520.85637444547},{"$f":"'Base model'!S11*(1+$H$9)","v":129943.18821811504},{"$f":"'Base model'!T11*(1+$H$9)","v":152466.73598954582},{"$f":"'Base model'!U11*(1+$H$9)","v":197635.08458492946},{"$f":"'Base model'!V11*(1+$H$9)","v":178611.42607232538},{"$f":"'Base model'!W11*(1+$H$9)","v":80866.842078311558}]
[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+$H$9)","v":8191.6163315741005},{"$f":"'Base model'!K12*(1+$H$9)","v":8134.0068046230153},{"$f":"'Base model'!L12*(1+$H$9)","v":8364.25846885182},{"$f":"'Base model'!M12*(1+$H$9)","v":8869.7379143726375},{"$f":"'Base model'!N12*(1+$H$9)","v":8977.0495693951671},{"$f":"'Base model'!O12*(1+$H$9)","v":6364.1485856535928},{"$f":"'Base model'!P12*(1+$H$9)","v":5802.026773110616},{"$f":"'Base model'!Q12*(1+$H$9)","v":6632.8836656723579},{"$f":"'Base model'!R12*(1+$H$9)","v":8108.6325981746768},{"$f":"'Base model'!S12*(1+$H$9)","v":9281.6563012939314},{"$f":"'Base model'!T12*(1+$H$9)","v":10890.481142110417},{"$f":"'Base model'!U12*(1+$H$9)","v":14116.791756066388},{"$f":"'Base model'!V12*(1+$H$9)","v":12757.959005166098},{"$f":"'Base model'!W12*(1+$H$9)","v":5776.2030055936821}]
[null,"P",null,"Price per kilometre of demand (excluding GST)",null,null,null,"$/km occupied (real 2012/13)",null,{"$f":"SUMPRODUCT(Sim_template!D161:D165,Sim_template!D191:D195)/Sim_template!D174/'Base model'!$B$20/(1+$H$11)","v":2.735607936681669},{"$f":"SUMPRODUCT(Sim_template!E161:E165,Sim_template!E191:E195)/Sim_template!E174/'Base model'!$B$20/(1+$H$11)","v":2.735607936681669},{"$f":"SUMPRODUCT(Sim_template!F161:F165,Sim_template!F191:F195)/Sim_template!F174/'Base model'!$B$20/(1+$H$11)","v":2.7356079366816681},{"$f":"SUMPRODUCT(Sim_template!G161:G165,Sim_template!G191:G195)/Sim_template!G174/'Base model'!$B$20/(1+$H$11)","v":2.7356079366816686},{"$f":"SUMPRODUCT(Sim_template!H161:H165,Sim_template!H191:H195)/Sim_template!H174/'Base model'!$B$20/(1+$H$11)","v":2.7356079366816686},{"$f":"SUMPRODUCT(Sim_template!I161:I165,Sim_template!I191:I195)/Sim_template!I174/'Base model'!$B$20/(1+$H$11)","v":2.7665110014931216},{"$f":"SUMPRODUCT(Sim_template!J161:J165,Sim_template!J191:J195)/Sim_template!J174/'Base model'!$B$20/(1+$H$11)","v":2.766511001493122},{"$f":"SUMPRODUCT(Sim_template!K161:K165,Sim_template!K191:K195)/Sim_template!K174/'Base model'!$B$20/(1+$H$11)","v":2.7837281393483648},{"$f":"SUMPRODUCT(Sim_template!L161:L165,Sim_template!L191:L195)/Sim_template!L174/'Base model'!$B$20/(1+$H$11)","v":2.7837281393483648},{"$f":"SUMPRODUCT(Sim_template!M161:M165,Sim_template!M191:M195)/Sim_template!M174/'Base model'!$B$20/(1+$H$11)","v":2.7837281393483648},{"$f":"SUMPRODUCT(Sim_template!N161:N165,Sim_template!N191:N195)/Sim_template!N174/'Base model'!$B$20/(1+$H$11)","v":2.7837281393483644},{"$f":"SUMPRODUCT(Sim_template!O161:O165,Sim_template!O191:O195)/Sim_template!O174/'Base model'!$B$20/(1+$H$11)","v":2.9554606012608717},{"$f":"SUMPRODUCT(Sim_template!P161:P165,Sim_template!P191:P195)/Sim_template!P174/'Base model'!$B$20/(1+$H$11)","v":3.0814270011060376},{"$f":"SUMPRODUCT(Sim_template!Q161:Q165,Sim_template!Q191:Q195)/Sim_template!Q174/'Base model'!$B$20/(1+$H$11)","v":2.7837281393483648}]
[null,"c",null,"Variable cost",null,null,null,"$/km occupied",null,{"$f":"'Base model'!J14*(1+$H$13)","v":0.48282233233340882},{"$f":"'Base model'!K14*(1+$H$13)","v":0.48282233233340882},{"$f":"'Base model'!L14*(1+$H$13)","v":0.48282233233340882},{"$f":"'Base model'!M14*(1+$H$13)","v":0.48282233233340882},{"$f":"'Base model'!N14*(1+$H$13)","v":0.48282233233340882},{"$f":"'Base model'!O14*(1+$H$13)","v":0.48282233233340882},{"$f":"'Base model'!P14*(1+$H$13)","v":0.48282233233340882},{"$f":"'Base model'!Q14*(1+$H$13)","v":0.48282233233340882},{"$f":"'Base model'!R14*(1+$H$13)","v":0.48282233233340882},{"$f":"'Base model'!S14*(1+$H$13)","v":0.48282233233340882},{"$f":"'Base model'!T14*(1+$H$13)","v":0.48282233233340882},{"$f":"'Base model'!U14*(1+$H$13)","v":0.48282233233340882},{"$f":"'Base model'!V14*(1+$H$13)","v":0.48282233233340882},{"$f":"'Base model'!W14*(1+$H$13)","v":0.48282233233340882}]
[null,null,null,"Fixed component of shift costs",null,null,null,"$/taxi/shift",null,{"$f":"'Base model'!J15*(1+$H$13)","v":131.23350634057968},{"$f":"'Base model'!K15*(1+$H$13)","v":131.23350634057968},{"$f":"'Base model'!L15*(1+$H$13)","v":131.23350634057968},{"$f":"'Base model'!M15*(1+$H$13)","v":131.23350634057968},{"$f":"'Base model'!N15*(1+$H$13)","v":131.23350634057968},{"$f":"'Base model'!O15*(1+$H$13)","v":151.97350634057969},{"$f":"'Base model'!P15*(1+$H$13)","v":151.97350634057969},{"$f":"'Base model'!Q15*(1+$H$13)","v":142.64050634057969},{"$f":"'Base model'!R15*(1+$H$13)","v":142.64050634057969},{"$f":"'Base model'!S15*(1+$H$13)","v":142.64050634057969},{"$f":"'Base model'!T15*(1+$H$13)","v":142.64050634057969},{"$f":"'Base model'!U15*(1+$H$13)","v":163.3805063405797},{"$f":"'Base model'!V15*(1+$H$13)","v":163.3805063405797},{"$f":"'Base model'!W15*(1+$H$13)","v":163.3805063405797}]
[null,null,null,"Variable component of fixed costs",null,null,null,"$/additional taxi per shift",null,{"$f":"'Base model'!J16*(1+$H$13)","v":8.9999999999999993E-3},{"$f":"'Base model'!K16*(1+$H$13)","v":8.9999999999999993E-3},{"$f":"'Base model'!L16*(1+$H$13)","v":8.9999999999999993E-3},{"$f":"'Base model'!M16*(1+$H$13)","v":8.9999999999999993E-3},{"$f":"'Base model'!N16*(1+$H$13)","v":8.9999999999999993E-3},{"$f":"'Base model'!O16*(1+$H$13)","v":8.9999999999999993E-3},{"$f":"'Base model'!P16*(1+$H$13)","v":8.9999999999999993E-3},{"$f":"'Base model'!Q16*(1+$H$13)","v":8.9999999999999993E-3},{"$f":"'Base model'!R16*(1+$H$13)","v":8.9999999999999993E-3},{"$f":"'Base model'!S16*(1+$H$13)","v":8.9999999999999993E-3},{"$f":"'Base model'!T16*(1+$H$13)","v":8.9999999999999993E-3},{"$f":"'Base model'!U16*(1+$H$13)","v":8.9999999999999993E-3},{"$f":"'Base model'!V16*(1+$H$13)","v":8.9999999999999993E-3},{"$f":"'Base model'!W16*(1+$H$13)","v":8.9999999999999993E-3}]
[null,null,null,"Waiting time constant",null,null,null,"Unit",null,24758.635602268234,{"$f":"'Base model'!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,24758.635602268234]
[null,null,null,"Constant to link occupied taxi kms to occupied taxis",null,null,null,"Unit",null,3.1250000000000002E-3,{"$f":"'Base model'!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,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,424433.53549321165,421168.70593762264,434216.13898881205,462848.81154026027,466950.96515896049,309306.29489444895,277235.58230585803,333338.11206555075,417264.19196043129,483803.61896857194,574951.75169971434,774845.35701127909,703490.89363523689,296068.39691377926]
[null,"W*",null,"Free entry waiting time",null,null,null,"Minutes, average",null,6.1772120269271671,6.211622849253831,6.0770873533713869,5.807454390326563,5.7714275846362302,8.7535058640356791,9.5536956545817375,7.736883493094453,6.5330120286103286,5.8675595451221669,5.1982953925646402,4.3549234737096771,4.4039788575382302,9.6299512369344811]
[null,"T*",null,"Free entry number of taxis on the road",null,null,null,"Taxis on the road",null,5334.4146633951232,5302.0084313037669,5431.0211586430923,5709.6535129136118,5749.0851040025718,3795.0072605831306,3457.8856160511964,4241.7602397208893,5093.72406029172,5731.4660872352097,6559.561603010603,8106.5974054448898,7820.2878942733296,3496.2169566768634]
[null,"Q* zero condition",null,"Zero condition to solve for free entry",null,null,null,"Occupied kilometres",null,{"$f":"J103-J104*J106-J105*J119-J118","v":-8.9639797806739807E-9},{"$f":"K103-K104*K106-K105*K119-K118","v":-2.6193447411060333E-9},6.8685039877891541E-9,-6.5192580223083496E-9,5.8789737522602081E-9,-6.5192580223083496E-9,1.3387762010097504E-9,0,-2.9103830456733704E-9,-2.2700987756252289E-9,2.7939677238464355E-9,6.28642737865448E-9,-1.3969838619232178E-9,4.2491592466831207E-9]
[null,"W* zero condition",null,"Zero condition to solve for free entry",null,null,null,"Minutes, average",null,{"$f":"J110/(J120-J118*J111)-J119","v":-8.0615514264081867E-11},-8.2088114083944674E-11,-7.8127726510501816E-11,-7.1551653491042089E-11,-6.9181993467282155E-11,-2.1614177114770428E-10,-2.6303759170787089E-10,-1.2737011445551616E-10,-8.8021145927541511E-11,-7.0192740508900897E-11,-5.3955062639943208E-11,-2.9837465831406007E-11,-1.7407408847702754E-11,-3.5302427647820878E-10]
[null,"T* zero condition",null,"Zero condition to solve for free entry",null,null,null,"Taxis on the road",null,{"$f":"(-J108+SQRT(J108^2+4*J109*(J106-J107)*J118))/(2*J109)-J120","v":1.7353158909827471E-9},1.7917045624926686E-9,1.7789716366678476E-9,1.6962076188065112E-9,1.7034835764206946E-9,2.4569999368395656E-9,2.7230271371081471E-9,1.8653736333362758E-9,1.7171259969472885E-9,1.6334524843841791E-9,1.6007106751203537E-9,1.1095835361629725E-9,6.9303496275097132E-10,3.2850948628038168E-9]
[null,"Qbar",null,"Fixed taxi numbers demand",null,null,null,"Occupied kilometres",null,{"$f":"((J111*(J103-J104*J106)+J126)-SQRT((J111*(J103-J104*J106)+J126)^2-4*J111*(J126*(J103-J104*J106)-J105*J110)))/(2*J111)","v":410810.96284279326},408724.24686627649,420320.88289580325,447226.19156484539,447557.17133405199,314069.82193138247,287438.09854705789,337716.27437728399,409626.87822135765,468619.64641560684,549570.03480615164,722645.93801822513,654885.69251500198,311742.69096682884]
[null,"Wbar",null,"Fixed taxi numbers waiting time",null,null,null,"Minutes, average",null,{"$f":"J110/(J126-J124*J111)","v":7.84020161274334},7.7415526083819586,7.7383531003304258,7.5687939165027602,7.9318026248980331,8.0050118631762022,7.7952556059280536,7.0768142784945258,7.4748864626289331,7.5034715052370924,7.5289285907088033,8.0526063392678928,8.2137732847308378,6.9163530413955909]
[null,"Tbar",null,"Fixed taxi numbers",null,null,null,"Taxis on the road",null,{"$f":"'Base model'!J8/'Base model'!J6*('Base model'!J6+$D$31)","v":4441.6922853847236},{"$f":"'Base model'!K8/'Base model'!K6*('Base model'!K6+$D$31)","v":4475.411867058142},{"$f":"'Base model'!L8/'Base model'!L6*('Base model'!L6+$D$31)","v":4512.9736647141899},{"$f":"'Base model'!M8/'Base model'!M6*('Base model'!M6+$D$31)","v":4668.7285961140406},{"$f":"'Base model'!N8/'Base model'!N6*('Base model'!N6+$D$31)","v":4520.0548513604335},{"$f":"'Base model'!O8/'Base model'!O6*('Base model'!O6+$D$31)","v":4074.36},{"$f":"'Base model'!P8/'Base model'!P6*('Base model'!P6+$D$31)","v":4074.36},{"$f":"'Base model'!Q8/'Base model'!Q6*('Base model'!Q6+$D$31+$F$31)","v":4553.92},{"$f":"'Base model'!R8/'Base model'!R6*('Base model'!R6+$D$31+$F$31)","v":4592.3263577271609},{"$f":"'Base model'!S8/'Base model'!S6*('Base model'!S6+$D$31+$F$31)","v":4764.0605203603418},{"$f":"'Base model'!T8/'Base model'!T6*('Base model'!T6+$D$31+$F$31)","v":5005.8736757287752},{"$f":"'Base model'!U8/'Base model'!U6*('Base model'!U6+$D$31+$F$31)","v":5332.88},{"$f":"'Base model'!V8/'Base model'!V6*('Base model'!V6+$D$31+$F$31)","v":5060.800597266968},{"$f":"'Base model'!W8/'Base model'!W6*('Base model'!W6+$D$31+$F$31)","v":4553.92}]
[null,"Q*_flat",null,"Free entry demand, flat cost curve",null,null,null,"Occupied kilometres",null,{"$f":"(J103-J104*J106+SQRT((J103-J104*J106)^2-4*J105*J110/((J106-J107)/J108-J111)))/2","v":442384.2822468573},439025.03495398664,452449.3844722237,481905.24481719092,486205.02315607405,324176.40484635928,291221.91179406946,348415.42838150967,434730.75420735555,503147.07292990503,596827.02234621765,799940.63665897469,725615.25061837584,309530.03130350937]
[null,"W*_flat",null,"Free entry waiting time, flat cost curve",null,null,null,"Minutes, average",null,{"$f":"J110/((J106-J107)/J108-J111)/J127","v":3.9858561299884303},4.0163543370345023,3.8971875390238675,3.6589767846852608,3.6266184412458191,6.4169623732947709,7.1431019025795113,5.4637671419077849,4.3789420253820364,3.7835075900159763,3.1896356868042579,2.5772334658574878,2.6698176978902324,7.2994177746081732]
[null,"T*_flat",null,"Free entry number of taxis on the road, flat cost curve",null,null,null,"Taxis on the road",null,{"$f":"(J106-J107)*J127/J108","v":7594.0738796483156},7536.408241094201,7766.8538200147132,8272.5001294002323,8346.3111477432594,4871.3621234577258,4376.1586883750324,5620.220391692148,7012.5558476030774,8116.1659586568958,9627.298701681515,12106.486112547333,11541.078065083699,4359.1457905457164]
[]
[]
[]
[null,"Difference between free entry and actual (for info)",null,null,null,null,null,null,null,{"$f":"J120-J126","v":892.72237801039955},{"$f":"K120-K126","v":826.5965642456249},918.04749392890244,1040.9249167995713,1229.0302526421383,-279.35273941686955,{"$f":"P120-P126","v":-616.47438394880373},-312.15976027911074,501.39770256455904,967.40556687486787,1553.6879272818278,2773.7174054448897,2759.4872970063616,-1057.7030433231366]
[]
[]
[]
[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,"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":"J68","v":278.31723227183591},274.81721449120158,280.26231737454373,288.25386683871943,297.95546499107297,248.0282987067574,243.98517214788862,240.63475845789654,273.13364874024978,301.20538139341892,336.17287140806735,440.5362127633619,438.62243896902356,259.30636790012693]
[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,"Additional taxis on the road",null,null,null,null,null,"No.",{"$f":"B143","v":"Additional taxis on the road"},{"$f":"J57-J138","v":0},0,0,0,0,158.07575675223052,149.33213350540836,147.63603060139985,264.41131398796279,274.29921220365759,288.22203239760165,307.05000000000018,291.38454707227993,128.79297971888491]
[null,"Proportion of taxis on the road 2011/12",null,null,null,null,null,"%","Proportion of taxis on the road 2011/12",{"$f":"'Base model'!J134/100","v":0.82851935933309528},{"$f":"'Base model'!K134/100","v":0.83480915259431865},{"$f":"'Base model'!L134/100","v":0.84181564348334081},{"$f":"'Base model'!M134/100","v":0.87086897894311521},{"$f":"'Base model'!N134/100","v":0.84313651396389355},{"$f":"'Base model'!O134/100","v":0.67840542880636079},{"$f":"'Base model'!P134/100","v":0.61715230041891211},{"$f":"'Base model'!Q134/100","v":0.72500871420568258},{"$f":"'Base model'!R134/100","v":0.76640960576220973},{"$f":"'Base model'!S134/100","v":0.79507018030045762},{"$f":"'Base model'!T134/100","v":0.83542618086261267},{"$f":"'Base model'!U134/100","v":0.89},{"$f":"'Base model'!V134/100","v":0.84459289006458083},{"$f":"'Base model'!W134/100","v":0.59632087426208225}]
[null,"Proportion of taxis on the road 2017/18",null,null,null,null,null,"%","Proportion of taxis on the road 2017/18",{"$f":"J62/100","v":0.82851935933309528},0.83480915259431865,0.84181564348334081,0.87086897894311521,0.84313651396389355,0.7078916733040721,0.64500757620802018,0.70790391183592949,0.76640960576220973,0.79507018030045762,0.83542618086261267,0.89,0.84459289006458083,0.58348080051349527]
[]
[]
[null,"Revenue","2012/13"]
[null,null,"Revenue","Revenue share"]
[null,"Flagfall ($)",{"$f":"V36*R175","v":2901869.333552856},{"$f":"C150/$C$155","v":0.15945031493076578}]
[null,"Standard kilometre charge ($/km)",{"$f":"V38*R176","v":7921310.3097745432},0.43525578803766179]
[null,"Night kilometre charge ($/km)",{"$f":"V39*R177","v":2998114.0121276174},0.16473871442267782]
[null,"Waiting time ($/hour when vehicle slower than 26km/hour)",{"$f":"V40*R178","v":3979942.9810296609},0.21868771084696095]
[null,"Booking fee ($/booking)",{"$f":"V41*R179","v":397970.65145867749},2.1867471761933599E-2]
[null,"Weighted average",{"$f":"SUM(C150:C154)","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(L29=\"Yes\", $L$25=\"5 pm until 5 am\"), $N$9+(1-'Inputs and assumptions'!D10)*Sim_template!$L$22, IF(AND(L29=\"Yes\", $L$25=\"10 pm until 6 am\"), $N$9+(1-'Inputs and assumptions'!D9)*Sim_template!$L$22,  IF(AND(L29=\"Yes\", $L$25=\"12 am until 5 am\"), $N$9+(1-'Inputs and assumptions'!D11)*Sim_template!$L$22, $N$9)))","v":3.6},{"$f":"IF(AND(L30=\"Yes\", $L$25=\"5 pm until 5 am\"), $N$9+(1-'Inputs and assumptions'!E10)*Sim_template!$L$22, IF(AND(L30=\"Yes\", $L$25=\"10 pm until 6 am\"), $N$9+(1-'Inputs and assumptions'!E9)*Sim_template!$L$22,  IF(AND(L30=\"Yes\", $L$25=\"12 am until 5 am\"), $N$9+(1-'Inputs and assumptions'!E11)*Sim_template!$L$22, $N$9)))","v":3.6},{"$f":"IF(AND(L31=\"Yes\", $L$25=\"5 pm until 5 am\"), $N$9+(1-'Inputs and assumptions'!F10)*Sim_template!$L$22, IF(AND(L31=\"Yes\", $L$25=\"10 pm until 6 am\"), $N$9+(1-'Inputs and assumptions'!F9)*Sim_template!$L$22,  IF(AND(L31=\"Yes\", $L$25=\"12 am until 5 am\"), $N$9+(1-'Inputs and assumptions'!F11)*Sim_template!$L$22, $N$9)))","v":3.6},{"$f":"IF(AND(L32=\"Yes\", $L$25=\"5 pm until 5 am\"), $N$9+(1-'Inputs and assumptions'!G10)*Sim_template!$L$22, IF(AND(L32=\"Yes\", $L$25=\"10 pm until 6 am\"), $N$9+(1-'Inputs and assumptions'!G9)*Sim_template!$L$22,  IF(AND(L32=\"Yes\", $L$25=\"12 am until 5 am\"), $N$9+(1-'Inputs and assumptions'!G11)*Sim_template!$L$22, $N$9)))","v":3.6},{"$f":"IF(AND(L33=\"Yes\", $L$25=\"5 pm until 5 am\"), $N$9+(1-'Inputs and assumptions'!H10)*Sim_template!$L$22, IF(AND(L33=\"Yes\", $L$25=\"10 pm until 6 am\"), $N$9+(1-'Inputs and assumptions'!H9)*Sim_template!$L$22,  IF(AND(L33=\"Yes\", $L$25=\"12 am until 5 am\"), $N$9+(1-'Inputs and assumptions'!H11)*Sim_template!$L$22, $N$9)))","v":3.6},{"$f":"IF(AND(L34=\"Yes\", $L$25=\"5 pm until 5 am\"), $N$9+(1-'Inputs and assumptions'!I10)*Sim_template!$L$22, IF(AND(L34=\"Yes\", $L$25=\"10 pm until 6 am\"), $N$9+(1-'Inputs and assumptions'!I9)*Sim_template!$L$22,  IF(AND(L34=\"Yes\", $L$25=\"12 am until 5 am\"), $N$9+(1-'Inputs and assumptions'!I11)*Sim_template!$L$22, $N$9)))","v":3.85},{"$f":"IF(AND(L35=\"Yes\", $L$25=\"5 pm until 5 am\"), $N$9+(1-'Inputs and assumptions'!J10)*Sim_template!$L$22, IF(AND(L35=\"Yes\", $L$25=\"10 pm until 6 am\"), $N$9+(1-'Inputs and assumptions'!J9)*Sim_template!$L$22,  IF(AND(L35=\"Yes\", $L$25=\"12 am until 5 am\"), $N$9+(1-'Inputs and assumptions'!J11)*Sim_template!$L$22, $N$9)))","v":3.85},{"$f":"IF(AND(L36=\"Yes\", $L$25=\"5 pm until 5 am\"), $N$9+(1-'Inputs and assumptions'!K10)*Sim_template!$L$22, IF(AND(L36=\"Yes\", $L$25=\"10 pm until 6 am\"), $N$9+(1-'Inputs and assumptions'!K9)*Sim_template!$L$22,  IF(AND(L36=\"Yes\", $L$25=\"12 am until 5 am\"), $N$9+(1-'Inputs and assumptions'!K11)*Sim_template!$L$22, $N$9)))","v":3.6},{"$f":"IF(AND(L37=\"Yes\", $L$25=\"5 pm until 5 am\"), $N$9+(1-'Inputs and assumptions'!L10)*Sim_template!$L$22, IF(AND(L37=\"Yes\", $L$25=\"10 pm until 6 am\"), $N$9+(1-'Inputs and assumptions'!L9)*Sim_template!$L$22,  IF(AND(L37=\"Yes\", $L$25=\"12 am until 5 am\"), $N$9+(1-'Inputs and assumptions'!L11)*Sim_template!$L$22, $N$9)))","v":3.6},{"$f":"IF(AND(L38=\"Yes\", $L$25=\"5 pm until 5 am\"), $N$9+(1-'Inputs and assumptions'!M10)*Sim_template!$L$22, IF(AND(L38=\"Yes\", $L$25=\"10 pm until 6 am\"), $N$9+(1-'Inputs and assumptions'!M9)*Sim_template!$L$22,  IF(AND(L38=\"Yes\", $L$25=\"12 am until 5 am\"), $N$9+(1-'Inputs and assumptions'!M11)*Sim_template!$L$22, $N$9)))","v":3.6},{"$f":"IF(AND(L39=\"Yes\", $L$25=\"5 pm until 5 am\"), $N$9+(1-'Inputs and assumptions'!N10)*Sim_template!$L$22, IF(AND(L39=\"Yes\", $L$25=\"10 pm until 6 am\"), $N$9+(1-'Inputs and assumptions'!N9)*Sim_template!$L$22,  IF(AND(L39=\"Yes\", $L$25=\"12 am until 5 am\"), $N$9+(1-'Inputs and assumptions'!N11)*Sim_template!$L$22, $N$9)))","v":3.6},{"$f":"IF(AND(L40=\"Yes\", $L$25=\"5 pm until 5 am\"), $N$9+(1-'Inputs and assumptions'!O10)*Sim_template!$L$22, IF(AND(L40=\"Yes\", $L$25=\"10 pm until 6 am\"), $N$9+(1-'Inputs and assumptions'!O9)*Sim_template!$L$22,  IF(AND(L40=\"Yes\", $L$25=\"12 am until 5 am\"), $N$9+(1-'Inputs and assumptions'!O11)*Sim_template!$L$22, $N$9)))","v":4.5999999999999996},{"$f":"IF(AND(L41=\"Yes\", $L$25=\"5 pm until 5 am\"), $N$9+(1-'Inputs and assumptions'!P10)*Sim_template!$L$22, IF(AND(L41=\"Yes\", $L$25=\"10 pm until 6 am\"), $N$9+(1-'Inputs and assumptions'!P9)*Sim_template!$L$22,  IF(AND(L41=\"Yes\", $L$25=\"12 am until 5 am\"), $N$9+(1-'Inputs and assumptions'!P11)*Sim_template!$L$22, $N$9)))","v":5.0999999999999996},{"$f":"IF(AND(L42=\"Yes\", $L$25=\"5 pm until 5 am\"), $N$9+(1-'Inputs and assumptions'!Q10)*Sim_template!$L$22, IF(AND(L42=\"Yes\", $L$25=\"10 pm until 6 am\"), $N$9+(1-'Inputs and assumptions'!Q9)*Sim_template!$L$22,  IF(AND(L42=\"Yes\", $L$25=\"12 am until 5 am\"), $N$9+(1-'Inputs and assumptions'!Q11)*Sim_template!$L$22, $N$9)))","v":3.6}]
[null,"Standard kilometre charge ($/km)",null,{"$f":"$N$11","v":2.1886719620660888},2.1886719620660888,2.1886719620660888,2.1886719620660888,2.1886719620660888,2.1886719620660888,2.1886719620660888,2.1886719620660888,2.1886719620660888,2.1886719620660888,2.1886719620660888,2.1886719620660888,2.1886719620660888,2.1886719620660888,null,null,"DO NOT DELETE"]
[null,"Night kilometre charge ($/km)",null,{"$f":"IF(N29=\"No\",N11,IF(N29=\"Yes\",$M$24,\"na\"))","v":2.63},{"$f":"IF(N30=\"No\",D162,IF(N30=\"Yes\",$M$24,\"na\"))","v":2.63},{"$f":"IF(N31=\"No\",E162,IF(N31=\"Yes\",$M$24,\"na\"))","v":2.63},{"$f":"IF(N32=\"No\",F162,IF(N32=\"Yes\",$M$24,\"na\"))","v":2.63},{"$f":"IF(N33=\"No\",G162,IF(N33=\"Yes\",$M$24,\"na\"))","v":2.63},{"$f":"IF(N34=\"No\",H162,IF(N34=\"Yes\",$M$24,\"na\"))","v":2.63},{"$f":"IF(N35=\"No\",I162,IF(N35=\"Yes\",$M$24,\"na\"))","v":2.63},{"$f":"IF(N36=\"No\",J162,IF(N36=\"Yes\",$M$24,\"na\"))","v":2.63},{"$f":"IF(N37=\"No\",K162,IF(N37=\"Yes\",$M$24,\"na\"))","v":2.63},{"$f":"IF(N38=\"No\",L162,IF(N38=\"Yes\",$M$24,\"na\"))","v":2.63},{"$f":"IF(N39=\"No\",M162,IF(N39=\"Yes\",$M$24,\"na\"))","v":2.63},{"$f":"IF(N40=\"No\",N162,IF(N40=\"Yes\",$M$24,\"na\"))","v":2.63},{"$f":"IF(N41=\"No\",O162,IF(N41=\"Yes\",$M$24,\"na\"))","v":2.63},{"$f":"IF(N42=\"No\",P162,IF(N42=\"Yes\",$M$24,\"na\"))","v":2.63},null,null,"10 pm until 6 am"]
[null,"Waiting time ($/hour when vehicle slower than 26km/hour)",null,{"$f":"$N$13","v":56.68},56.68,56.68,56.68,56.68,56.68,56.68,56.68,56.68,56.68,56.68,56.68,56.68,56.68,null,null,"5 pm until 5 am"]
[null,"Booking fee ($/booking)",null,{"$f":"$N$17","v":2.5},2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,2.5,null,null,"12 am until 5 am"]
[]
[null,null,null,null,null,"Km threshold for waiting"]
[null,"For fare goal seek",null,{"$f":"N7-H31","v":-7.3099537030940631E-4},null,"2012/13"]
[null,null,null,null,null,{"$f":"ROUND(V40/V38,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":"D174/'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(D175:Q175)","v":829105.52387224464}]
[null,"Standard kilometre charge (kms)",null,{"$f":"D174*'Inputs and assumptions'!D9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":288919.34981445211},{"$f":"E174*'Inputs and assumptions'!E9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":286887.45447217755},{"$f":"F174*'Inputs and assumptions'!F9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":295008.45995265496},{"$f":"G174*'Inputs and assumptions'!G9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":312836.78428243723},{"$f":"H174*'Inputs and assumptions'!H9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":316621.68000284804},{"$f":"I174*'Inputs and assumptions'!I9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":224464.33000070346},{"$f":"J174*'Inputs and assumptions'!J9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":204638.22218234208},{"$f":"K174*'Inputs and assumptions'!K9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":198370.65930112268},{"$f":"L174*'Inputs and assumptions'!L9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":242506.10678657747},{"$f":"M174*'Inputs and assumptions'!M9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":277587.90485396801},{"$f":"N174*'Inputs and assumptions'!N9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":325703.27374314022},{"$f":"O174*'Inputs and assumptions'!O9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":343574.8294821062},{"$f":"P174*'Inputs and assumptions'!P9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":211678.03817854199},{"$f":"Q174*'Inputs and assumptions'!Q9*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":172749.78067334997},{"$f":"SUM(D176:Q176)","v":3701546.873726422}]
[null,"Night kilometre charge (kms)",null,{"$f":"D174*(1-'Inputs and assumptions'!D9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":32102.149979383561},{"$f":"E174*(1-'Inputs and assumptions'!E9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":31876.383830241943},{"$f":"F174*(1-'Inputs and assumptions'!F9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":32778.717772517215},{"$f":"G174*(1-'Inputs and assumptions'!G9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":34759.64269804857},{"$f":"H174*(1-'Inputs and assumptions'!H9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":35180.186666983107},{"$f":"I174*(1-'Inputs and assumptions'!I9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":24940.48111118927},{"$f":"J174*(1-'Inputs and assumptions'!J9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":22737.580242482447},{"$f":"K174*(1-'Inputs and assumptions'!K9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":66123.553100374222},{"$f":"L174*(1-'Inputs and assumptions'!L9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":80835.368928859156},{"$f":"M174*(1-'Inputs and assumptions'!M9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":92529.301617989331},{"$f":"N174*(1-'Inputs and assumptions'!N9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":108567.75791438007},{"$f":"O174*(1-'Inputs and assumptions'!O9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":229049.88632140416},{"$f":"P174*(1-'Inputs and assumptions'!P9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":317517.05726781295},{"$f":"Q174*(1-'Inputs and assumptions'!Q9)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":57583.260224449979},{"$f":"SUM(D177:Q177)","v":1166581.3276761158}]
[null,"Waiting time (hours)",null,{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!D175","v":4745.9573545253506},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!E175","v":4712.5802593273766},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!F175","v":4845.9806207464535},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!G175","v":5138.8390500144569},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!H175","v":5201.0119494479186},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!I175","v":3687.1816944056973},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!J175","v":3361.5065110972996},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!K175","v":3910.2622515390121},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!L175","v":4780.2557015037146},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!M175","v":5471.7845353661678},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!N175","v":6420.2297910761172},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!O175","v":8465.6400991708397},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!P175","v":7823.5799060976169},{"$f":"'Inputs and assumptions'!$C$51/60*Sim_template!Q175","v":3405.226099003145},{"$f":"SUM(D178:Q178)","v":71970.035823321174}]
[null,"Booking fee (number)",null,{"$f":"D175*'Inputs and assumptions'!$C$47","v":10934.82701150472},{"$f":"E175*'Inputs and assumptions'!$C$47","v":10857.92519067644},{"$f":"F175*'Inputs and assumptions'!$C$47","v":11165.283594139317},{"$f":"G175*'Inputs and assumptions'!$C$47","v":11840.038132304964},{"$f":"H175*'Inputs and assumptions'!$C$47","v":11983.286343218688},{"$f":"I175*'Inputs and assumptions'!$C$47","v":8495.3763754047668},{"$f":"J175*'Inputs and assumptions'!$C$47","v":7745.0110591168404},{"$f":"K175*'Inputs and assumptions'!$C$47","v":9009.3606191858307},{"$f":"L175*'Inputs and assumptions'!$C$47","v":11013.851423856711},{"$f":"M175*'Inputs and assumptions'!$C$47","v":12607.154440906213},{"$f":"N175*'Inputs and assumptions'!$C$47","v":14792.400541185993},{"$f":"O175*'Inputs and assumptions'!$C$47","v":19505.086774078034},{"$f":"P175*'Inputs and assumptions'!$C$47","v":18025.760977874972},{"$f":"Q175*'Inputs and assumptions'!$C$47","v":7845.7422909954521},{"$f":"SUM(D179:Q179)","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!N25","v":"10 pm until 6 am"},null,{"$f":"IF($B$184=\"5 pm until 5 am\", 'Inputs and assumptions'!D10, IF($B$184=\"12 am until 5 am\",  'Inputs and assumptions'!D11,'Inputs and assumptions'!D9))","v":0.9},{"$f":"IF($B$184=\"5 pm until 5 am\", 'Inputs and assumptions'!E10, IF($B$184=\"12 am until 5 am\",  'Inputs and assumptions'!E11,'Inputs and assumptions'!E9))","v":0.9},{"$f":"IF($B$184=\"5 pm until 5 am\", 'Inputs and assumptions'!F10, IF($B$184=\"12 am until 5 am\",  'Inputs and assumptions'!F11,'Inputs and assumptions'!F9))","v":0.9},{"$f":"IF($B$184=\"5 pm until 5 am\", 'Inputs and assumptions'!G10, IF($B$184=\"12 am until 5 am\",  'Inputs and assumptions'!G11,'Inputs and assumptions'!G9))","v":0.9},{"$f":"IF($B$184=\"5 pm until 5 am\", 'Inputs and assumptions'!H10, IF($B$184=\"12 am until 5 am\",  'Inputs and assumptions'!H11,'Inputs and assumptions'!H9))","v":0.9},{"$f":"IF($B$184=\"5 pm until 5 am\", 'Inputs and assumptions'!I10, IF($B$184=\"12 am until 5 am\",  'Inputs and assumptions'!I11,'Inputs and assumptions'!I9))","v":0.9},{"$f":"IF($B$184=\"5 pm until 5 am\", 'Inputs and assumptions'!J10, IF($B$184=\"12 am until 5 am\",  'Inputs and assumptions'!J11,'Inputs and assumptions'!J9))","v":0.9},{"$f":"IF($B$184=\"5 pm until 5 am\", 'Inputs and assumptions'!K10, IF($B$184=\"12 am until 5 am\",  'Inputs and assumptions'!K11,'Inputs and assumptions'!K9))","v":0.75},{"$f":"IF($B$184=\"5 pm until 5 am\", 'Inputs and assumptions'!L10, IF($B$184=\"12 am until 5 am\",  'Inputs and assumptions'!L11,'Inputs and assumptions'!L9))","v":0.75},{"$f":"IF($B$184=\"5 pm until 5 am\", 'Inputs and assumptions'!M10, IF($B$184=\"12 am until 5 am\",  'Inputs and assumptions'!M11,'Inputs and assumptions'!M9))","v":0.75},{"$f":"IF($B$184=\"5 pm until 5 am\", 'Inputs and assumptions'!N10, IF($B$184=\"12 am until 5 am\",  'Inputs and assumptions'!N11,'Inputs and assumptions'!N9))","v":0.75},{"$f":"IF($B$184=\"5 pm until 5 am\", 'Inputs and assumptions'!O10, IF($B$184=\"12 am until 5 am\",  'Inputs and assumptions'!O11,'Inputs and assumptions'!O9))","v":0.6},{"$f":"IF($B$184=\"5 pm until 5 am\", 'Inputs and assumptions'!P10, IF($B$184=\"12 am until 5 am\",  'Inputs and assumptions'!P11,'Inputs and assumptions'!P9))","v":0.4},{"$f":"IF($B$184=\"5 pm until 5 am\", 'Inputs and assumptions'!Q10, IF($B$184=\"12 am until 5 am\",  'Inputs and assumptions'!Q11,'Inputs and assumptions'!Q9))","v":0.75}]
[null,null,null,{"$f":"Sim_template!D172","v":"Monday"},{"$f":"Sim_template!E172","v":"Tuesday"},{"$f":"Sim_template!F172","v":"Wednesday"},{"$f":"Sim_template!G172","v":"Thursday"},{"$f":"Sim_template!H172","v":"Friday"},{"$f":"Sim_template!I172","v":"Saturday"},{"$f":"Sim_template!J172","v":"Sunday"},{"$f":"Sim_template!K172","v":"Monday"},{"$f":"Sim_template!L172","v":"Tuesday"},{"$f":"Sim_template!M172","v":"Wednesday"},{"$f":"Sim_template!N172","v":"Thursday"},{"$f":"Sim_template!O172","v":"Friday"},{"$f":"Sim_template!P172","v":"Saturday"},{"$f":"Sim_template!Q172","v":"Sunday"},{"$f":"Sim_template!R172","v":"Total"}]
[null,null,null,{"$f":"Sim_template!D173","v":"Day"},{"$f":"Sim_template!E173","v":"Day"},{"$f":"Sim_template!F173","v":"Day"},{"$f":"Sim_template!G173","v":"Day"},{"$f":"Sim_template!H173","v":"Day"},{"$f":"Sim_template!I173","v":"Day"},{"$f":"Sim_template!J173","v":"Day"},{"$f":"Sim_template!K173","v":"Night"},{"$f":"Sim_template!L173","v":"Night"},{"$f":"Sim_template!M173","v":"Night"},{"$f":"Sim_template!N173","v":"Night"},{"$f":"Sim_template!O173","v":"Night"},{"$f":"Sim_template!P173","v":"Night"},{"$f":"Sim_template!Q173","v":"Night"}]
[null,{"$f":"Sim_template!B176","v":"Standard kilometre charge (kms)"},null,{"$f":"D174*D184*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":288919.34981445211},{"$f":"E174*E184*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":286887.45447217755},{"$f":"F174*F184*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":295008.45995265496},{"$f":"G174*G184*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":312836.78428243723},{"$f":"H174*H184*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":316621.68000284804},{"$f":"I174*I184*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":224464.33000070346},{"$f":"J174*J184*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":204638.22218234208},{"$f":"K174*K184*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":198370.65930112268},{"$f":"L174*L184*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":242506.10678657747},{"$f":"M174*M184*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":277587.90485396801},{"$f":"N174*N184*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":325703.27374314022},{"$f":"O174*O184*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":343574.8294821062},{"$f":"P174*P184*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":211678.03817854199},{"$f":"Q174*Q184*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":172749.78067334997},{"$f":"SUM(D187:Q187)","v":3701546.873726422}]
[null,{"$f":"Sim_template!B177","v":"Night kilometre charge (kms)"},null,{"$f":"D174*(1-D184)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":32102.149979383561},{"$f":"E174*(1-E184)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":31876.383830241943},{"$f":"F174*(1-F184)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":32778.717772517215},{"$f":"G174*(1-G184)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":34759.64269804857},{"$f":"H174*(1-H184)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":35180.186666983107},{"$f":"I174*(1-I184)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":24940.48111118927},{"$f":"J174*(1-J184)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":22737.580242482447},{"$f":"K174*(1-K184)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":66123.553100374222},{"$f":"L174*(1-L184)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":80835.368928859156},{"$f":"M174*(1-M184)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":92529.301617989331},{"$f":"N174*(1-N184)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":108567.75791438007},{"$f":"O174*(1-O184)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":229049.88632140416},{"$f":"P174*(1-P184)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":317517.05726781295},{"$f":"Q174*(1-Q184)*('Inputs and assumptions'!$C$52/'Inputs and assumptions'!$C$44)","v":57583.260224449979},{"$f":"SUM(D188:Q188)","v":1166581.3276761158}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R188/SUM(R187:R188)","v":0.23963652545962463}]
[null,"Waiting time threshold adjustment"]
[null,"Flagfall (no of trips)",null,{"$f":"D175","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(D191:Q191)","v":829105.52387224464}]
[null,"Standard kilometre charge (kms)",null,{"$f":"(D178-D194)*AVERAGE(Sim_template!$F$169:$G$169)*D184+D187","v":289359.37383399531},{"$f":"(E178-E194)*AVERAGE(Sim_template!$F$169:$G$169)*E184+E187","v":287324.38391617098},{"$f":"(F178-F194)*AVERAGE(Sim_template!$F$169:$G$169)*F184+F187","v":295457.75768377259},{"$f":"(G178-G194)*AVERAGE(Sim_template!$F$169:$G$169)*G184+G187","v":313313.23454223928},{"$f":"(H178-H194)*AVERAGE(Sim_template!$F$169:$G$169)*H184+H187","v":317103.89465686429},{"$f":"(I178-I194)*AVERAGE(Sim_template!$F$169:$G$169)*I184+I187","v":224806.18905858384},{"$f":"(J178-J194)*AVERAGE(Sim_template!$F$169:$G$169)*J184+J187","v":204949.88608832372},{"$f":"(K178-K194)*AVERAGE(Sim_template!$F$169:$G$169)*K184+K187","v":198672.77771209506},{"$f":"(L178-L194)*AVERAGE(Sim_template!$F$169:$G$169)*L184+L187","v":242875.44346112187},{"$f":"(M178-M194)*AVERAGE(Sim_template!$F$169:$G$169)*M184+M187","v":278010.67108872818},{"$f":"(N178-N194)*AVERAGE(Sim_template!$F$169:$G$169)*N184+N187","v":326199.31965970091},{"$f":"(O178-O194)*AVERAGE(Sim_template!$F$169:$G$169)*O184+O187","v":344098.09376876499},{"$f":"(P178-P194)*AVERAGE(Sim_template!$F$169:$G$169)*P184+P187","v":212000.42372062546},{"$f":"(Q178-Q194)*AVERAGE(Sim_template!$F$169:$G$169)*Q184+Q187","v":173012.87849949388},{"$f":"SUM(D192:Q192)","v":3707184.3276904803}]
[null,"Night kilometre charge (kms)",null,{"$f":"(D178-D194)*AVERAGE(Sim_template!$F$169:$G$169)*(1-D184)+D188","v":32151.041537110585},{"$f":"(E178-E194)*AVERAGE(Sim_template!$F$169:$G$169)*(1-E184)+E188","v":31924.931546241209},{"$f":"(F178-F194)*AVERAGE(Sim_template!$F$169:$G$169)*(1-F184)+F188","v":32828.639742641397},{"$f":"(G178-G194)*AVERAGE(Sim_template!$F$169:$G$169)*(1-G184)+G188","v":34812.581615804353},{"$f":"(H178-H194)*AVERAGE(Sim_template!$F$169:$G$169)*(1-H184)+H188","v":35233.766072984909},{"$f":"(I178-I194)*AVERAGE(Sim_template!$F$169:$G$169)*(1-I184)+I188","v":24978.465450953758},{"$f":"(J178-J194)*AVERAGE(Sim_template!$F$169:$G$169)*(1-J184)+J188","v":22772.209565369296},{"$f":"(K178-K194)*AVERAGE(Sim_template!$F$169:$G$169)*(1-K184)+K188","v":66224.259237365011},{"$f":"(L178-L194)*AVERAGE(Sim_template!$F$169:$G$169)*(1-L184)+L188","v":80958.481153707296},{"$f":"(M178-M194)*AVERAGE(Sim_template!$F$169:$G$169)*(1-M184)+M188","v":92670.223696242727},{"$f":"(N178-N194)*AVERAGE(Sim_template!$F$169:$G$169)*(1-N184)+N188","v":108733.10655323364},{"$f":"(O178-O194)*AVERAGE(Sim_template!$F$169:$G$169)*(1-O184)+O188","v":229398.72917917671},{"$f":"(P178-P194)*AVERAGE(Sim_template!$F$169:$G$169)*(1-P184)+P188","v":318000.63558093819},{"$f":"(Q178-Q194)*AVERAGE(Sim_template!$F$169:$G$169)*(1-Q184)+Q188","v":57670.959499831282},1168358.0304316003]
[null,"Waiting time hours",null,{"$f":"D178*(1+(Sim_template!$N$15-Sim_template!$F$169)/Sim_template!$F$169)","v":4727.1529092457267},{"$f":"E178*(1+(Sim_template!$N$15-Sim_template!$F$169)/Sim_template!$F$169)","v":4693.9080608661197},{"$f":"F178*(1+(Sim_template!$N$15-Sim_template!$F$169)/Sim_template!$F$169)","v":4826.7798630063835},{"$f":"G178*(1+(Sim_template!$N$15-Sim_template!$F$169)/Sim_template!$F$169)","v":5118.4779278006954},{"$f":"H178*(1+(Sim_template!$N$15-Sim_template!$F$169)/Sim_template!$F$169)","v":5180.4044856010705},{"$f":"I178*(1+(Sim_template!$N$15-Sim_template!$F$169)/Sim_template!$F$169)","v":3672.5723329578177},{"$f":"J178*(1+(Sim_template!$N$15-Sim_template!$F$169)/Sim_template!$F$169)","v":3348.1875407562038},{"$f":"K178*(1+(Sim_template!$N$15-Sim_template!$F$169)/Sim_template!$F$169)","v":3894.768999694275},{"$f":"L178*(1+(Sim_template!$N$15-Sim_template!$F$169)/Sim_template!$F$169)","v":4761.3153592193858},{"$f":"M178*(1+(Sim_template!$N$15-Sim_template!$F$169)/Sim_template!$F$169)","v":5450.1042156348758},{"$f":"N178*(1+(Sim_template!$N$15-Sim_template!$F$169)/Sim_template!$F$169)","v":6394.791538944799},{"$f":"O178*(1+(Sim_template!$N$15-Sim_template!$F$169)/Sim_template!$F$169)","v":8432.097516692711},{"$f":"P178*(1+(Sim_template!$N$15-Sim_template!$F$169)/Sim_template!$F$169)","v":7792.5812962818973},{"$f":"Q178*(1+(Sim_template!$N$15-Sim_template!$F$169)/Sim_template!$F$169)","v":3391.7339027906369},71684.875949492605]
[null,"Booking fee (number)",null,{"$f":"D179","v":10934.82701150472},{"$f":"E179","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]

{"sheet":"Inputs and assumptions","index":3,"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!T165","v":"12 am 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!T164","v":"5 pm 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,{"$f":"C45/150000","v":0.71333333333333337}]
[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":4,"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,"Day",null,null,null,null,null,null,"Night"]
[null,null,null,null,null,null,null,null,null,"M","T","W","T","F","S","S","M","T","W","T","F","S","S"]
[null,null,"Average number of trips by day 2011/12",null,null,null,null,null,null,{"$f":"J122/'Inputs and assumptions'!$C$44","v":54996.312954594534},{"$f":"K122/'Inputs and assumptions'!$C$44","v":54712.508353822035},{"$f":"L122/'Inputs and assumptions'!$C$44","v":56270.386053599192},{"$f":"M122/'Inputs and assumptions'!$C$44","v":59879.054359797716},{"$f":"N122/'Inputs and assumptions'!$C$44","v":59935.562108214195},{"$f":"O122/'Inputs and assumptions'!$C$44","v":41327.380061285614},{"$f":"P122/'Inputs and assumptions'!$C$44","v":36994.37990877284},{"$f":"Q122/'Inputs and assumptions'!$C$44","v":44270.549636370772},{"$f":"R122/'Inputs and assumptions'!$C$44","v":54168.303710482905},{"$f":"S122/'Inputs and assumptions'!$C$44","v":61976.095096943041},{"$f":"T122/'Inputs and assumptions'!$C$44","v":72694.088379643596},{"$f":"U122/'Inputs and assumptions'!$C$44","v":98559.872827655417},{"$f":"V122/'Inputs and assumptions'!$C$44","v":90619.499315377325},{"$f":"W122/'Inputs and assumptions'!$C$44","v":39293.28924530802},{"$f":"X122","v":"ok"}]
[null,null,"Average number of trips by day 2011/12 without a restriction on the number of taxis",null,null,null,null,null,null,{"$f":"J110/'Inputs and assumptions'!$C$44","v":56495.973182574227},{"$f":"K110/'Inputs and assumptions'!$C$44","v":56059.180882742992},{"$f":"L110/'Inputs and assumptions'!$C$44","v":57804.729247199022},{"$f":"M110/'Inputs and assumptions'!$C$44","v":61635.076208389459},{"$f":"N110/'Inputs and assumptions'!$C$44","v":62178.253360196439},{"$f":"O110/'Inputs and assumptions'!$C$44","v":41327.380061285614},{"$f":"P110/'Inputs and assumptions'!$C$44","v":36994.37990877284},{"$f":"Q110/'Inputs and assumptions'!$C$44","v":44270.549636370772},{"$f":"R110/'Inputs and assumptions'!$C$44","v":55501.466993448979},{"$f":"S110/'Inputs and assumptions'!$C$44","v":64401.866951533717},{"$f":"T110/'Inputs and assumptions'!$C$44","v":76591.264030449631},{"$f":"U110/'Inputs and assumptions'!$C$44","v":106330.29421501198},{"$f":"V110/'Inputs and assumptions'!$C$44","v":97869.691326999819},{"$f":"W110/'Inputs and assumptions'!$C$44","v":39293.28924530802}]
[null,null,"Proportion of taxis on the road",null,null,null,null,null,null,{"$f":"J134/100","v":0.82851935933309528},{"$f":"K134/100","v":0.83480915259431865},0.84181564348334081,0.87086897894311521,0.84313651396389355,0.67840542880636079,0.61715230041891211,0.72500871420568258,0.76640960576220973,0.79507018030045762,0.83542618086261267,0.89,0.84459289006458083,0.59632087426208225,{"$f":"X134","v":"ok"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Occupancy",null,null,null,null,null,null,{"$f":"J140","v":0.27085269950832536},{"$f":"K140","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]
[]
[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,{"$f":"200000/B151-1","v":0.25474433462017854}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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]