{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["HOME","Hamilton_tripdata","Hamilton_unit costs","Wellington_tripdata","elasticities","Glaister Lewis","Parry Small","Report","timetable","capcost","STCC Data","Sheet1","EEM_Values","ONA"],"not_rendered":{"charts":6,"images":2,"macros":1,"external_links":0,"defined_names":118,"comments":3,"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":"HOME","index":0,"n_rows":73,"n_cols":32,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
[null,"NZTA PUBLIC TRANSPORT INVESTMENT MODEL"]
[]
[null,"1)  Select the region for analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OFFSET(AE2,$AC$3,0)","v":"Hamilton"},2,{"$f":"AE3&AF3","v":"Auckland (no data)"},"Auckland"," (no data)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE4&AF4","v":"Hamilton"},"Hamilton"]
[null,"Region",null,null,null,null,"or ",null,null,null,null,null,null,null,null,"copyright notice etc",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE5&AF5","v":"Wellington (no data)"},"Wellington"," (no data)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE6&AF6","v":"Christchurch (no data)"},"Christchurch"," (no data)"]
[null,"2)  Edit input data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE7&AF7","v":"Default values (STCC)"},"Default values"," (STCC)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"before you start"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bus",null,"train"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"peak","off-peak","peak","off-peak"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,4,5,"frequency changes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"frequency and density change"]
[null,"3) Run analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"frequency and size change"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"size change"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"density change"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,3,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1.2-Z17*0.2","v":0.39999999999999991},{"$f":"1.2-AA17*0.2","v":0.59999999999999987},null,null,0.8]
[null,"4) View results ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cost","freq","density","size","occupancy"]
[null,"Preface",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"peak",{"$f":"(AB25+AC25)*1+AD25*'Hamilton_unit costs'!D51/'Hamilton_unit costs'!D50+0.1*AE25","v":0.64000000000000012},{"$f":"IF(Z11=1,1-Z18,IF(Z11=2,(1-Z18)/2,IF(Z11=3,(1-Z18)/2,0)))","v":0.60000000000000009},{"$f":"IF(Z11=2,(1-Z18)/2,IF(Z11=5,(1-Z18),0))","v":0},{"$f":"IF(Z11=3,(1-Z18)/2,IF(Z11=4,(1-Z18),0))","v":0},{"$f":"1-SUM(AB25:AD25)","v":0.39999999999999991}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"interpeak",{"$f":"(AB26+AC26)*1+AD26*'Hamilton_unit costs'!E51/'Hamilton_unit costs'!E50+0.1*AE26","v":0.46000000000000013},{"$f":"IF(AA11=1,1-AA18,IF(AA11=2,(1-AA18)/2,IF(AA11=3,(1-AA18)/2,0)))","v":0.40000000000000013},{"$f":"IF(AA11=2,(1-AA18)/2,IF(AA11=5,(1-AA18),0))","v":0},{"$f":"IF(AA11=3,(1-AA18)/2,IF(AA11=4,(1-AA18),0))","v":0},{"$f":"1-SUM(AB26:AD26)","v":0.59999999999999987}]
[null,"This workbook models the interaction between public transport fares service levels and patronage and private travel costs."]
[null,"The model can be used to optimise fares or can be used to view the effect of incremental changes to fares on service levels, public and private costs"]
[null,"    by using either the  Glaister Lewis (optimise fare) or Parry Small (increment fare) sheets."]
[null,"Results are summarised on the Report sheet."]
[]
[null,"Optimisation can be undertaken in the context of different policy regimen and policy constraints."]
[]
[null,"The purpose of the model is to assist regional authorities and the New Zealand Transport Agency (NZTA) to make informed decisions about fare policies."]
[null,"The model has been developed initially for bus services Hamilton but is capable of being extended to apply to other cities and modes."]
[]
[null,"Detailed instruction for the use of the model can be found in NZTA research report RR 524."]
[]
[null,"This model is copyright ©  New Zealand Transport Agency 2013. Material in it may be reproduced for personal or in-house use without formal permission or charge, "]
[null,"provided suitable acknowledgement is made to this model and associated publication and NZTA as the source. "]
[]
[null,"Requests and enquiries about the reproduction of material in this model and the associated publication for any other purpose should be made to:"]
[null,"The Research Manager; Programmes, Funding and Assessment; National office, NZ Transport Agency, Private Bag 6995, Wellington, New Zealand."]
[]
[]
[]
[]
[]
[null,"Set-up instructions"]
[]
[null,"If your computer is not set up to run solver and visual basic, some features of the workbook will result in errors. "]
[null,"This section describes the preliminary steps necessary to get the workbook functioning on a windows PC."]
[]
[null,"First of all macros may need to be enabled."]
[null,"If you get a message saying 'Macros have been disabled   [options]'",null,null,null,null,null,null,"click [options] and select 'enable this content'."]
[]
[null,"From the HOME page select [optimise fare] or click the 'Glaister Lewis' tab."]
[null,"Click the blue-grey box [calculate optimum fare]   (this is on row 23)."]
[null,"if you get a message box headed 'solver results'  your computer is already set up to run VBA."]
[null,"If you get error messages and/or pages of code you need to continue with the set up.  Close the error messages."]
[]
[null,"For excel 2007, click the round windows button at the top left and then click [excel options];"]
[null,"For excel 2010, click 'File' and then 'Options'."]
[]
[null,"Click 'Add-ins'"]
[null,"You will see a list of active and inactive add-ins.  You need to have 'Analysis  ToolPak - VBA'  and 'Solver Add-in' active."]
[null,"To add an add-in to the active list, select 'Manage Add-ins' and click [Go]."]
[]
[null,"This gives a pop-up box to manage add-ins.  Select 'Analysis ToolPak - VBA'   and  'Solver Add-in'  and click [ok]."]
[]
[null,"If you are asked whether you want to install these now, click [yes]."]
[]
[null,"Once you have installed the Add-ins the workbook should run. "]

{"sheet":"Hamilton_tripdata","index":1,"n_rows":57,"n_cols":16,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["HAMILTON TRIP DATA"]
[null,null,"INPUT DATA ",null,null,null,null,"CHECK DATA",null,null,null,null,"SCRATCH"]
["Passenger Service Data "]
[null,"units","Bus","Train","source","comment",null,"Fare recovery",{"$f":"C7/C10","v":0.30016444171053652},null,null,null,"This area is for calculations that support the input data.  "]
["Annual passengers","(M)",4.5640000000000001,"This option","EW/NZTA",null,null,"Peak buses",{"$f":"N15","v":86.588860028860026},null,null,null,"The calculations are likely to be centre specific"]
["Passenger-km","(M)",29.501999999999999,"is not ","EW/NZTA",null,null,"average load",{"$f":"C6/C8","v":6.3719222462203025}]
["Fare revenue","($M)",5.1970000000000001,"functional","EW/NZTA","excl gst",null,"fare factor",{"$f":"C7/(C15*C5)*100","v":0.49508440345997029},null,null,null,"Reconcilliation of WRTM data and EW data.  WRTM data are for a typical am peak and interpeak"]
["service km","(M)",4.63,"yet","EW/NZTA",null,null,"GST",0.15]
["Contract payment","($M)",12.116842940169859,null,"EW/NZTA",null,null,null,null,null,null,null,null,500,800]
["Gross operating cost","($M)",{"$f":"C7+C9","v":17.313842940169859},null,"calculated",null,null,"KEY",null,null,null,null,null,"am","interpeak","annual"]
["Average trip length","km",{"$f":"IF(C5>0,C6/C5,0)","v":6.4640666082383866},null,"calculated",null,null,null,"input number",null,null,null,"Patronage",{"$f":"$F$27","v":4663},{"$f":"F37","v":2172},{"$f":"N11*N9+O11*O9","v":4069100}]
[null,null,null,null,null,null,null,null,"calibrated number",null,null,null,"pax km",{"$f":"F47","v":30003.040000000001},{"$f":"$F$55","v":20553.940000000002},{"$f":"N12*N9+O12*O9","v":31444672}]
["Fares",null,null,null,null,null,null,null,null,null,null,null,"km in service",{"$f":"N12/7.7","v":3896.4987012987012},{"$f":"O12/5.8","v":3543.7827586206899},{"$f":"N13*N9+O13*O9","v":4783275.5575459022}]
["Peak single","cents",310,null,"EW","incl gst",null,null,null,null,null,null,"Vehicle hours",{"$f":"N13/30","v":129.88329004329003},{"$f":"O13/25","v":141.7513103448276},{"$f":"N14*N9+O14*O9","v":178342.6932975071}]
["peak multitrip","cents",230,"This option","EW","incl gst",null,null,null,null,null,null,"peak buses",{"$f":"N14/1.5","v":86.588860028860026}]
["peak education","cents",160,"is not ","EW","incl gst"]
["Interpeak single","cents",310,"functional","EW","incl gst",null,null,null,null,null,null,"Public transport trip length"]
["interpeak multitrip","cents",230,"yet","EW","incl gst"]
["interpeak education","cents",{"$f":"C16","v":160},null,"EW","incl gst",null,null,null,null,null,null,"WRTM gives the average trip distance but not the public transport distance."]
[null,null,null,null,null,null,null,null,null,null,null,null,"We have applied a factor to the WRTM distances based on the EW data. (the average bus distance can be expected to be less than the average car distance)"]
["Transport model data ",null,"These data are from WRTM Technical Note 16.  Trips per period",null,null,null,null,null,null,null,null,null,"factor",0.8,null,"we changed N20"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Average from EW",{"$f":"C6/C5","v":6.4640666082383866},null,"until N21 equalled N22"]
["am peak trips",null,"HBW","HBE","Other","Total",null,null,null,null,null,null,"average calculated",{"$f":"F47/F27","v":6.4342783615698051}]
["Vehicle Driver","trips",76774,5540,125710,{"$f":"SUM(C24:E24)","v":208024}]
["Vehicle Passenger","trips",6142,38137,58477,{"$f":"SUM(C25:E25)","v":102756}]
["Rail passenger","trips","not functional yet",null,null,{"$f":"SUM(C26:E26)","v":0}]
["Bus Passenger","trips",1511,1953,1199,{"$f":"SUM(C27:E27)","v":4663}]
["Active","trips",6103,33191,14334,{"$f":"SUM(C28:E28)","v":53628}]
["Average trip length","km",11.2,5.9,7.5545454545454538]
["Average trip time","min",12.6,7.3,8.6]
["Headway peak","min",{"$f":"60/timetable!B23","v":14.285714285714285},{"$f":"C31","v":14.285714285714285},{"$f":"C31","v":14.285714285714285}]
[]
["interpeak trips",null,"HBW","OHB","NHB","Total"]
["Vehicle Driver","trips",28172,72710,90817,{"$f":"SUM(C34:E34)","v":191699}]
["Vehicle Passenger","trips",1525,33384,27915,{"$f":"SUM(C35:E35)","v":62824}]
["Rail passenger","trips",null,null,null,{"$f":"SUM(C36:E36)","v":0}]
["Bus Passenger","trips",306,1432,434,{"$f":"SUM(C37:E37)","v":2172}]
["Active","trips",2316,12979,18581,{"$f":"SUM(C38:E38)","v":33876}]
["Average trip length","km",10.5,8.5,11.91]
["Average trip time","min",11.6,11.2,9.8000000000000007]
["Headway interpeak","min",{"$f":"60/timetable!C23","v":16.216216216216214},{"$f":"C41","v":16.216216216216214},{"$f":"C41","v":16.216216216216214}]
[]
["am peak kilometres",null,"HBW","HBE","Other"]
["Vehicle Driver","p-km",{"$f":"C24*C$29","v":859868.79999999993},{"$f":"D24*D$29","v":32686.000000000004},{"$f":"E24*E$29","v":949681.90909090894},{"$f":"SUM(C44:E44)","v":1842236.709090909}]
["Vehicle Passenger","p-km",{"$f":"C25*C$29*N21","v":55032.32},{"$f":"D25*D$29","v":225008.30000000002},{"$f":"E25*E$29","v":441767.15454545448},{"$f":"SUM(C45:E45)","v":721807.77454545442}]
["Rail passenger","p-km",null,null,null,{"$f":"SUM(C46:E46)","v":0}]
["Bus Passenger","p-km",{"$f":"C27*C$29*N21","v":13538.560000000001},{"$f":"D27*D$29*N21","v":9218.1600000000017},{"$f":"E27*E$29*N21","v":7246.32},{"$f":"SUM(C47:E47)","v":30003.040000000001}]
["Active","km",{"$f":"C28*C$29","v":68353.599999999991},{"$f":"D28*D$29","v":195826.90000000002},{"$f":"E28*E$29","v":108286.85454545454},{"$f":"SUM(C48:E48)","v":372467.35454545455}]
[null,null,{"$f":"SUM(C44:C48)","v":996793.27999999991},{"$f":"SUM(D44:D48)","v":462739.36000000004},{"$f":"SUM(E44:E48)","v":1506982.238181818},{"$f":"SUM(F44:F48)","v":2966514.8781818179}]
[]
["interpeak kilometres",null,"HBW","OHB","NHB"]
["Vehicle Driver","p-km",{"$f":"C34*C$39","v":295806},618035,1081630.47,{"$f":"SUM(C52:E52)","v":1995471.47}]
["Vehicle Passenger","p-km",16012.5,283764,332467.65000000002,{"$f":"SUM(C53:E53)","v":632244.15}]
["Rail passenger","p-km"]
["Bus Passenger","p-km",{"$f":"C37*C$39","v":3213},12172,5168.9400000000005,{"$f":"SUM(C55:E55)","v":20553.940000000002}]
["Active","km",24318,110321.5,221299.71,{"$f":"SUM(C56:E56)","v":355939.20999999996}]
[null,null,{"$f":"SUM(C52:C56)","v":339349.5},{"$f":"SUM(D52:D56)","v":1024292.5},{"$f":"SUM(E52:E56)","v":1640566.77},{"$f":"SUM(F52:F56)","v":3004208.77}]

{"sheet":"Hamilton_unit costs","index":2,"n_rows":73,"n_cols":31,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["HAMILTON UNIT COSTS",null,null,null,null,null,"Unit costs are Hamilton specific where data exists or could be estimated"]
[null,"All costs in cents per kilometre",null,null,null,null,"Data is mostly entered per vehicle but is converted to per person"]
[null,"CAR",null,"BUS",null,"TRAIN",null,"COMMENT",null,null,"Key"]
[null,"Per vehicle km",null,"Per vehicle km",null,"Per train km",null,null,null,null,null,"Unit costs from the surface transport costs and charges study"]
["PER VEHICLE COSTS","Peak ","Off peak","Peak ","Off peak","Peak ","Off peak",null,null,null,null,"Region specific data"]
["A Private resource costs",null,null,null,null,null,null,null,null,null,null,"calculated"]
["Operations and vehicle costs",{"$f":"'STCC Data'!B8","v":15.4},{"$f":"'STCC Data'!C8","v":14.6}]
["Operations - time",{"$f":"'STCC Data'!B9","v":21.6},{"$f":"'STCC Data'!C9","v":17.8},null,null,null,null,null,null,null,"SCRATCH AREA"]
["Accidents internal",{"$f":"'STCC Data'!B10","v":-3.3},{"$f":"'STCC Data'!C10","v":5.2},{"$f":"'STCC Data'!D10","v":9.8000000000000007},{"$f":"'STCC Data'!E10","v":13.2}]
["Parking",{"$f":"'STCC Data'!B11","v":60},{"$f":"'STCC Data'!C11","v":30},null,null,null,null,null,null,null,"This area is for calculations that support the input data.  "]
["B Private charges",null,null,null,null,null,null,null,null,null,"The calculations are likely to be centre specific"]
["Fuel duty",{"$f":"'STCC Data'!B14","v":3.8},{"$f":"'STCC Data'!C14","v":3.3},{"$f":"'STCC Data'!D14","v":9.5},{"$f":"'STCC Data'!E14","v":8.25}]
["Fares",null,null,null,null,null,null,null,null,null,"Bus operating cost"]
["C. Provider costs"]
["Road infrastruction o&m",{"$f":"'STCC Data'!B18","v":0.1},{"$f":"'STCC Data'!C18","v":0.1},{"$f":"'STCC Data'!D18","v":5},{"$f":"'STCC Data'!E18","v":5},null,null,null,null,null,"Standard operating costs (source IPW/DRL)"]
["Operations and vehicle costs",null,null,{"$f":"Q20*N29","v":716.13622137344453},{"$f":"T20*N29","v":227.86152498245966},null,null,null,null,null,"Assume speed",30,"km/h"]
[null,{"$f":"B15+B16","v":0.1},{"$f":"C15+C16","v":0.1},{"$f":"D15+D16","v":721.13622137344453},{"$f":"E15+E16","v":232.86152498245966},null,null,null,null,null,null,"dollars per ","cent per","dollars  per year",null,null,"peak","peak","marginal ","intepeak","marginal "]
["D1. Congestion cost",null,null,null,null,null,null,null,null,null,null,"hour","km","bus op","bus cap","o/h","c /km","capacity","cost","c /km","cost"]
["HBW",{"$f":"M43","v":7.582858023767713},{"$f":"'Hamilton_unit costs'!O43","v":6.0792624531263044},{"$f":"B19*3","v":22.748574071303139},{"$f":"C19*3","v":18.237787359378913},null,null,null,null,null,"mini bus",20,30,2500,{"$f":"capcost!J3*1000","v":15800},0.15,{"$f":"((L19+(N19+O19)/400)/$L$16*100+M19)*(1+P19)","v":286.54166666666669},{"$f":"capcost!D3","v":19},null,{"$f":"(L19/$L$16*100+M19)*(1+P19)","v":111.16666666666664}]
["HBE",{"$f":"B19","v":7.582858023767713},null,{"$f":"D19","v":22.748574071303139},null,null,null,null,null,null,"medium bus",22,90,5000,{"$f":"capcost!J5*1000","v":37000},0.15,{"$f":"((L20+(N20+O20)/400)/$L$16*100+M20)*(1+P20)","v":590.33333333333314},{"$f":"capcost!D5","v":64},null,{"$f":"(L20/$L$16*100+M20)*(1+P20)","v":187.83333333333329}]
["NHB",null,{"$f":"C22","v":6.0792624531263044},null,{"$f":"C21*3","v":18.237787359378913},null,null,null,null,null,"large bus",22,110,6000,{"$f":"capcost!J7*1000","v":38900},0.15,{"$f":"((L21+(N21+O21)/400)/$L$16*100+M21)*(1+P21)","v":641.125},{"$f":"capcost!D7","v":81},{"$f":"LINEST(Q19:Q21,R19:R21)","v":5.9302127314063009},{"$f":"(L21/$L$16*100+M21)*(1+P21)","v":210.83333333333329},{"$f":"LINEST(T19:T21,R19:R21)","v":1.62720580274981}]
["Other",{"$f":"B19","v":7.582858023767713},{"$f":"'Hamilton_unit costs'!O43","v":6.0792624531263044},{"$f":"B22*3","v":22.748574071303139},{"$f":"C22*3","v":18.237787359378913},null,null,"pcu/bus=3"]
["D.2 Environmental",null,null,null,null,null,null,null,null,null,"Reconcilliation with Hamilton data"]
["HBW",{"$f":"EEM_Values!B20*EEM_Values!C20/10+EEM_Values!D21*100","v":9},{"$f":"B24","v":9},{"$f":"'STCC Data'!D26","v":38.200000000000003},{"$f":"'STCC Data'!E26","v":26.7},null,null,null,null,null,null,"peak","interpeak","std cost"]
["HBE",{"$f":"B24","v":9},null,{"$f":"D24","v":38.200000000000003},null,null,null,null,null,null,"Vehicle km",{"$f":"Hamilton_tripdata!N13","v":3896.4987012987012},{"$f":"Hamilton_tripdata!O13","v":3543.7827586206899},{"$f":"(L25*Hamilton_tripdata!N9+M25*Hamilton_tripdata!O9)*M20/100","v":4304948.0017913124}]
["NHB",null,{"$f":"C24","v":9},null,{"$f":"E24","v":26.7},null,null,null,null,null,"Vehicle hours",{"$f":"Hamilton_tripdata!N14","v":129.88329004329003},{"$f":"Hamilton_tripdata!O14","v":141.7513103448276},{"$f":"((L26*Hamilton_tripdata!N9+'Hamilton_unit costs'!M26*Hamilton_tripdata!O9)*L20)","v":3923539.2525451561}]
["Other",{"$f":"B24","v":9},{"$f":"C24","v":9},{"$f":"D25","v":38.200000000000003},{"$f":"E26","v":26.7},null,null,null,null,null,"peak buses",{"$f":"Hamilton_tripdata!N15*1.15","v":99.577189033189029},null,{"$f":"+L27*(N20+O20)","v":4182241.9393939395}]
["D1. Accidents",null,null,null,null,null,null,null,null,null,"Annual cost ",null,null,{"$f":"(N25+N26+N27)*(1+P20)","v":14272338.572789969}]
["accidents external",{"$f":"'STCC Data'!B25","v":-3},{"$f":"-'STCC Data'!C25","v":-2.2999999999999998},{"$f":"'STCC Data'!D25","v":-12.2},{"$f":"-'STCC Data'!E25","v":-5.9},null,null,null,null,null,"Hamilton factor",null,null,{"$f":"Hamilton_tripdata!C10/N28*10^6","v":1.2131048357540002}]
[]
["PER PERSON COSTS",{"$f":"B2","v":"All costs in cents per kilometre"},null,null,"Most of these are calculated",null,null,null,null,null,"Congestion cost"]
[null,"CAR",null,"BUS",null,"TRAIN",null,null,null,null,null,"These data are from special WRTM runs commissioned by the consultant"]
[null,"Per vehicle km",null,"Per vehicle km",null,"Per train km",null,null,null,null,null,"AM peak","minus 10%","Interpeak Base","minus 10%"]
[null,"Peak ","Off peak","Peak ","Off peak","Peak ","Off peak",null,null,null,"total trips",223276.64599999995,201762.80499999993,207286.10699999987,187459.39100000009]
["Occupancy",{"$f":"(Hamilton_tripdata!F24+Hamilton_tripdata!F25)/Hamilton_tripdata!F24","v":1.4939622351267161},{"$f":"(Hamilton_tripdata!F34+Hamilton_tripdata!F35)/Hamilton_tripdata!F34","v":1.3277221060099427},{"$f":"Hamilton_tripdata!N12/Hamilton_tripdata!N13","v":7.7},{"$f":"Hamilton_tripdata!O12/Hamilton_tripdata!O13","v":5.8},null,null,null,null,null,"total time",2834540.1409250009,2508217.615271999,2871839.8293439988,2568069.8354109996]
["A Private resource costs",null,null,null,null,null,null,null,null,null,"distance",2658623.0168439997,2408663.4452609993,2767237.9305920023,2515576.9411009997]
["Operations and vehicle costs",{"$f":"B7/B$35","v":10.308158826179291},10.996276957288732]
["Operations - time",14.458196795160566,13.406419852036947,{"$f":"'STCC Data'!D37","v":58},{"$f":"'STCC Data'!E37","v":58},null,null,null,null,null,"ave time",{"$f":"L35/$L$34","v":12.695193123444723},{"$f":"M35/$M$34","v":12.431516380197033},{"$f":"N35/$N$34","v":13.854473273232927},{"$f":"O35/$O$34","v":13.699339476734982}]
["Accidents internal",-2.2088911770384194,3.9164822039658498,{"$f":"D9/D$35","v":1.2727272727272727},{"$f":"E9/E$35","v":2.2758620689655173},null,null,null,null,null,"ave dist",{"$f":"L36/$L$34","v":11.907304523214668},{"$f":"M36/$M$34","v":11.93809456237982},{"$f":"N36/$N$34","v":13.349847564033821},{"$f":"O36/$O$34","v":13.419316726047608}]
["Parking",40.161657764334898,22.595089638264518,null,null,null,null,null,null,null,"ave speed",{"$f":"L39/L38*60","v":56.276282246821296},{"$f":"M39/M38*60","v":57.618527928242692},{"$f":"N39/N38*60","v":57.814601684609471},{"$f":"O39/O38*60","v":58.773563859062293}]
["B Private charges",null,null,null,null,null,null,null,null,null,null,null,"am peak",null,"interpeak"]
["Fuel duty",{"$f":"B12/B$35","v":2.5435716584078767},{"$f":"C12/C$35","v":2.4854598602090969},null,null,null,null,null,null,null,"Externality","minutes per km",{"$f":"($L35*M36/$L36-M35)/(L$36-M36)","v":0.23933270985063795},null,{"$f":"($N35*O36/$N36-O35)/(N$36-O36)","v":0.16926020751163723}]
["Fares  HBW",null,null,{"$f":"Hamilton_tripdata!C15/Hamilton_tripdata!C29/Hamilton_tripdata!$N$21","v":25.669642857142858},{"$f":"Hamilton_tripdata!C18/Hamilton_tripdata!C40/Hamilton_tripdata!N21","v":24.784482758620687},null,null,null,null,null,null,"cents per km",{"$f":"M42/60*EEM_Values!B17*100","v":7.582858023767713},null,{"$f":"O42/60*EEM_Values!C17*100","v":6.0792624531263044}]
["           HBE",null,null,{"$f":"Hamilton_tripdata!C16/Hamilton_tripdata!D29/Hamilton_tripdata!N21","v":33.898305084745758}]
["          NHB",null,null,null,{"$f":"Hamilton_tripdata!C17/(Hamilton_tripdata!D39+Hamilton_tripdata!E39)*2/Hamilton_tripdata!N21","v":37.971582557569818}]
["          Other",null,null,{"$f":"Hamilton_tripdata!C14/Hamilton_tripdata!E29/Hamilton_tripdata!N21","v":51.293622141997595},{"$f":"E45","v":37.971582557569818}]
["C. Provider costs"]
["Road infrastruction o&m",{"$f":"B15/B$35","v":6.6936096273891507E-2},{"$f":"C15/C$35","v":7.5316965460881735E-2},{"$f":"D15/D$35","v":0.64935064935064934},{"$f":"E15/E$35","v":0.86206896551724144}]
["Operations and vehicle costs",null,null,{"$f":"D16/D$35","v":93.00470407447331},{"$f":"E16/E35","v":39.286469824562012}]
[null,{"$f":"B48+B49","v":6.6936096273891507E-2},{"$f":"C48+C49","v":7.5316965460881735E-2},{"$f":"SUM(D48:D49)","v":93.654054723823961},{"$f":"SUM(E48:E49)","v":40.14853879007925}]
["Capacity expansion",null,null,{"$f":"S21+D48","v":6.5795633807569498},{"$f":"U21+E48","v":2.4892747682670513}]
["D. External costs"]
["D.1 Congestion"]
["HBW",{"$f":"B19/B$35","v":5.0756691471016628},{"$f":"C19/C$35","v":4.5787160020974902},{"$f":"D19/D$35","v":2.9543602690004076},{"$f":"E19/E$35","v":3.1444460964446401}]
["HBE",{"$f":"B20/B$35","v":5.0756691471016628},null,{"$f":"D20/D$35","v":2.9543602690004076}]
["NHB",null,{"$f":"C21/C$35","v":4.5787160020974902},null,{"$f":"E21/E$35","v":3.1444460964446401}]
["Other",{"$f":"B22/B$35","v":5.0756691471016628},{"$f":"C22/C$35","v":4.5787160020974902},{"$f":"D22/D$35","v":2.9543602690004076},{"$f":"E22/E$35","v":3.1444460964446401}]
["D.2 Environment"]
["HBW",{"$f":"B24/B$35","v":6.0242486646502353},{"$f":"C24/C$35","v":6.7785268914793555},{"$f":"D24/D$35","v":4.9610389610389616},{"$f":"E24/E$35","v":4.6034482758620694}]
["HBE",{"$f":"B25/B$35","v":6.0242486646502353},null,{"$f":"D25/D$35","v":4.9610389610389616}]
["NHB",null,{"$f":"C26/C$35","v":6.7785268914793555},null,{"$f":"E26/E$35","v":4.6034482758620694}]
["Other",{"$f":"B27/B$35","v":6.0242486646502353},{"$f":"C27/C$35","v":6.7785268914793555},{"$f":"D27/D$35","v":4.9610389610389616},{"$f":"E27/E$35","v":4.6034482758620694}]
["D.3 Accidents"]
["accidents external",{"$f":"B29/B$35","v":-2.008082888216745},{"$f":"C29/C$35","v":-1.7322902056002796},{"$f":"D29/D$35","v":-1.5844155844155843},{"$f":"E29/E$35","v":-1.017241379310345},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MC dwell"]
["D.Total"]
["HBW",{"$f":"B54+B59+B$64","v":9.0918349235351528},{"$f":"C54+C59+C$64","v":9.6249526879765668},{"$f":"D54+D59+D$64","v":6.3309836456237853},{"$f":"E54+E59+E$64","v":6.7306529929963643}]
["HBE",{"$f":"B55+B60+B$64","v":9.0918349235351528},null,{"$f":"D55+D60+D$64","v":6.3309836456237853}]
["NHB",null,{"$f":"C56+C61+C$64","v":9.6249526879765668},null,6.7306529929963643]
["Other",9.0918349235351528,9.6249526879765668,6.3309836456237853,6.7306529929963643]
["E. User Economies of Scale",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"travelling","waiting","walking","crowding"]
["Mohring effect (per km)",null,null,{"$f":"EEM_Values!C10*Hamilton_tripdata!C31*EEM_Values!B8*100/60/Hamilton_tripdata!C29/Hamilton_tripdata!N21","v":14.804421768707485},{"$f":"Hamilton_tripdata!C41*EEM_Values!C10*EEM_Values!C8/Hamilton_tripdata!C39/Hamilton_tripdata!N21*100/60","v":16.391248391248389},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"value of time",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},20,null,"cents/minute"]
["Density",null,null,{"$f":"5*EEM_Values!B7*100/60/Hamilton_tripdata!C29/Hamilton_tripdata!N21","v":32.38467261904762},{"$f":"5*EEM_Values!B7*100/60/Hamilton_tripdata!C39/Hamilton_tripdata!N21","v":34.543650793650791}]
["access ",null,null,{"$f":"IF(HOME!AB25+HOME!AC25>0,(D71*HOME!AB25+D72*HOME!AC25)/(HOME!AB25+HOME!AC25),D71)","v":14.804421768707483},{"$f":"IF(HOME!AB26+HOME!AC26>0,(E71*HOME!AB26+E72*HOME!AC26)/(HOME!AB26+HOME!AC26),E71)","v":16.391248391248389}]

{"sheet":"Wellington_tripdata","index":3,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["WELLINGTON TRIP DATA"]
[null,null,"INPUT DATA ",null,null,null,null,"CHECK DATA",null,null,null,null,"SCRATCH"]
["Passenger Service Data "]
[null,"units","Bus","Train","source","comment",null,"Fare recovery",null,null,null,null,"This area is for calculations that support the input data.  "]
["Annual passengers","(M)",null,null,"GW/NZTA",null,null,"Peak buses",null,null,null,null,"The calculations are likely to be centre specific"]
["Passenger-km","(M)",null,"This option","GW/NZTA",null,null,"average load"]
["Multitrip fare","$",null,"is not ","GW/NZTA",null,null,"fare factor"]
["Fare revenue","($M)",null,"functional","GW/NZTA","excl gst"]
["service km","(M)",null,"yet","GW/NZTA"]
["Contract payment","($M)",null,null,"GW/NZTA",null,null,"KEY"]
["Gross operating cost","($M)",null,null,"calculated",null,null,null,"input number"]
["Average trip length","km",null,null,"calculated"]
[]
[null,null,null,null,"THIS SHEET IS INCLUDED FOR DEMONSTRATION ONLY"]
["Transport model data "]
[]
["am peak trips",null,"HBW","HBE","Other","Total"]
["Vehicle Driver","trips",null,null,null,{"$f":"SUM(C18:E18)","v":0}]
["Vehicle Passenger","trips",null,null,null,{"$f":"SUM(C19:E19)","v":0}]
["Rail passenger","trips","not functional yet",null,null,{"$f":"SUM(C20:E20)","v":0}]
["Bus Passenger","trips",null,null,null,{"$f":"SUM(C21:E21)","v":0}]
["Active","trips",null,null,null,{"$f":"SUM(C22:E22)","v":0}]
["Average trip length","km"]
[]
["interpeak trips",null,"HBW","OHB","NHB","Total"]
["Vehicle Driver","trips",null,null,null,{"$f":"SUM(C26:E26)","v":0}]
["Vehicle Passenger","trips",null,null,null,{"$f":"SUM(C27:E27)","v":0}]
["Rail passenger","trips",null,null,null,{"$f":"SUM(C28:E28)","v":0}]
["Bus Passenger","trips",null,null,null,{"$f":"SUM(C29:E29)","v":0}]
["Active","trips",null,null,null,{"$f":"SUM(C30:E30)","v":0}]
["Average trip length","km"]
[]
["am peak kilometres",null,"HBW","HBE","Other"]
["Vehicle Driver","p-km",{"$f":"C18*C$23","v":0},{"$f":"D18*D$23","v":0},{"$f":"E18*E$23","v":0},{"$f":"SUM(C34:E34)","v":0}]
["Vehicle Passenger","p-km",null,null,null,{"$f":"SUM(C35:E35)","v":0}]
["Rail passenger","p-km",null,null,null,{"$f":"SUM(C36:E36)","v":0}]
["Bus Passenger","p-km",null,null,null,{"$f":"SUM(C37:E37)","v":0}]
["Active","km",null,null,null,{"$f":"SUM(C38:E38)","v":0}]
[null,null,{"$f":"SUM(C34:C38)","v":0},{"$f":"SUM(D34:D38)","v":0},{"$f":"SUM(E34:E38)","v":0},{"$f":"SUM(F34:F38)","v":0}]
[]
["interpeak kilometres",null,"HBW","OHB","NHB"]
["Vehicle Driver","p-km",{"$f":"C26*C$31","v":0},0,0,{"$f":"SUM(C42:E42)","v":0}]
["Vehicle Passenger","p-km",0,0,0,{"$f":"SUM(C43:E43)","v":0}]
["Rail passenger","p-km"]
["Bus Passenger","p-km",{"$f":"C29*C$31","v":0},0,0,{"$f":"SUM(C45:E45)","v":0}]
["Active","km",0,0,0,{"$f":"SUM(C46:E46)","v":0}]
[null,null,{"$f":"SUM(C42:C46)","v":0},{"$f":"SUM(D42:D46)","v":0},{"$f":"SUM(E42:E46)","v":0},{"$f":"SUM(F42:F46)","v":0}]

{"sheet":"elasticities","index":4,"n_rows":58,"n_cols":30,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["ELASTICITIES"]
["This sheet uses the properties of the logit model coeficients to calculate the elasticities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCRATCH AREA"]
["Input Data","Under normal circumstances, no user input is necessary"]
[null,null,{"$f":"\"Data for \"&HOME!AB3","v":"Data for Hamilton"},null,null,null,null,"Data for all five centres is collected here.  The Offset function is used to select the desired centre and place it in columns C-E"]
[null,null,"Trips","Share","Fare","gen cost",null,"Trips","(balance is active mode)",null,null,null,null,"Market share",null,"(balance is active mode)",null,null,null,"Fare / operating cost",null,"cents",null,null,null,"generalised cost",null,"cents"]
["Home based work",null,null,null,null,null,null,"Auckland","Hamilton","Wellington","Christchurch","Dunedin",null,"Auckland","Hamilton","Wellington","Christchurch","Dunedin",null,"Auckland","Hamilton","Wellington","Christchurch","Dunedin",null,"Auckland","Hamilton","Wellington","Christchurch","Dunedin"]
["car","peak",{"$f":"OFFSET(G7,0,HOME!$AC$3)","v":914901.11999999988},{"$f":"OFFSET(M7,0,HOME!$AC$3)","v":0.68473304926289391},{"$f":"OFFSET(S7,0,HOME!$AC$3)","v":190.39999999999998},{"$f":"OFFSET(Y7,0,HOME!$AC$3)","v":605.69599999999991},null,null,{"$f":"(Hamilton_tripdata!C44+Hamilton_tripdata!C45)","v":914901.11999999988},null,null,null,null,null,{"$f":"I7/$I$13","v":0.68473304926289391},null,null,null,null,null,{"$f":"EEM_Values!B5*Hamilton_tripdata!C29","v":190.39999999999998},null,null,null,null,null,{"$f":"U7+Hamilton_tripdata!C30*EEM_Values!B4","v":605.69599999999991}]
[null,"off peak",{"$f":"OFFSET(G8,0,HOME!$AC$3)","v":311818.5},{"$f":"OFFSET(M8,0,HOME!$AC$3)","v":0.23337214006425275},{"$f":"OFFSET(S8,0,HOME!$AC$3)","v":178.5},{"$f":"OFFSET(Y8,0,HOME!$AC$3)","v":627.53600000000006},null,null,{"$f":"(Hamilton_tripdata!C52+Hamilton_tripdata!C53)","v":311818.5},null,null,null,null,null,{"$f":"I8/$I$13","v":0.23337214006425275},null,null,null,null,null,{"$f":"EEM_Values!B5*Hamilton_tripdata!C39","v":178.5},null,null,null,null,null,{"$f":"U8+Hamilton_tripdata!C40*EEM_Values!C4","v":627.53600000000006}]
["bus","peak",{"$f":"OFFSET(G9,0,HOME!$AC$3)","v":13538.560000000001},{"$f":"OFFSET(M9,0,HOME!$AC$3)","v":1.0132569814133189E-2},{"$f":"OFFSET(S9,0,HOME!$AC$3)","v":230},{"$f":"OFFSET(Y9,0,HOME!$AC$3)","v":969.77577142857149},null,null,{"$f":"Hamilton_tripdata!C47","v":13538.560000000001},null,null,null,null,null,{"$f":"I9/$I$13","v":1.0132569814133189E-2},null,null,null,null,null,{"$f":"Hamilton_tripdata!C15","v":230},null,null,null,null,null,{"$f":"U9+5*EEM_Values!B$7+(EEM_Values!B$10+EEM_Values!C$10*Hamilton_tripdata!C$31)*EEM_Values!B$8+Hamilton_tripdata!C$29*Hamilton_tripdata!$N$21*60/30*EEM_Values!B$6","v":969.77577142857149}]
[null,"off peak",{"$f":"OFFSET(G10,0,HOME!$AC$3)","v":3213},{"$f":"OFFSET(M10,0,HOME!$AC$3)","v":2.4046831282507103E-3},{"$f":"OFFSET(S10,0,HOME!$AC$3)","v":230},{"$f":"OFFSET(Y10,0,HOME!$AC$3)","v":898.4678918918919},null,null,{"$f":"Hamilton_tripdata!C55","v":3213},null,null,null,null,null,{"$f":"I10/$I$13","v":2.4046831282507103E-3},null,null,null,null,null,{"$f":"Hamilton_tripdata!C18","v":230},null,null,null,null,null,{"$f":"U10+5*EEM_Values!C$7+(EEM_Values!B$10+EEM_Values!C$10*Hamilton_tripdata!$C$41)*EEM_Values!C$8+Hamilton_tripdata!C$39*Hamilton_tripdata!$N$21*60/30*EEM_Values!C$6","v":898.4678918918919}]
["train","peak",{"$f":"OFFSET(G11,0,HOME!$AC$3)","v":0},{"$f":"OFFSET(M11,0,HOME!$AC$3)","v":0},{"$f":"OFFSET(S11,0,HOME!$AC$3)","v":0},{"$f":"OFFSET(Y11,0,HOME!$AC$3)","v":0}]
[null,"off peak",{"$f":"OFFSET(G12,0,HOME!$AC$3)","v":0},{"$f":"OFFSET(M12,0,HOME!$AC$3)","v":0},{"$f":"OFFSET(S12,0,HOME!$AC$3)","v":0},{"$f":"OFFSET(Y12,0,HOME!$AC$3)","v":0}]
[null,null,{"$f":"OFFSET(G13,0,HOME!$AC$3)","v":1336142.7799999998},null,null,null,null,null,{"$f":"(Hamilton_tripdata!C49+Hamilton_tripdata!C57)","v":1336142.7799999998},null,null,null,null,{"$f":"IF(D9*D7=0,\"WARNING - Data for \"&HOME!AB3&\" is incomplete\",\"\")","v":""}]
["Education "]
["car","peak",{"$f":"OFFSET(G15,0,HOME!$AC$3)","v":257694.30000000002},{"$f":"OFFSET(M15,0,HOME!$AC$3)","v":0.55688865541932719},{"$f":"OFFSET(S15,0,HOME!$AC$3)","v":100.30000000000001},{"$f":"OFFSET(Y15,0,HOME!$AC$3)","v":340.90800000000002},null,null,{"$f":"(Hamilton_tripdata!D45+Hamilton_tripdata!D44)","v":257694.30000000002},null,null,null,null,null,{"$f":"I15/$I$18","v":0.55688865541932719},null,null,null,null,null,{"$f":"EEM_Values!C5*Hamilton_tripdata!D29","v":100.30000000000001},null,null,null,null,null,{"$f":"U15+Hamilton_tripdata!D30*EEM_Values!B4","v":340.90800000000002}]
["bus","peak",{"$f":"OFFSET(G16,0,HOME!$AC$3)","v":9218.1600000000017},{"$f":"OFFSET(M16,0,HOME!$AC$3)","v":1.9920847018503031E-2},{"$f":"OFFSET(S16,0,HOME!$AC$3)","v":160},{"$f":"OFFSET(Y16,0,HOME!$AC$3)","v":899.77577142857149},null,null,{"$f":"Hamilton_tripdata!D47","v":9218.1600000000017},null,null,null,null,null,{"$f":"I16/$I$18","v":1.9920847018503031E-2},null,null,null,null,null,{"$f":"Hamilton_tripdata!C16","v":160},null,null,null,null,null,{"$f":"U16+5*EEM_Values!B$7+(EEM_Values!B$10+EEM_Values!C$10*Hamilton_tripdata!C$31)*EEM_Values!B$8+Hamilton_tripdata!C$29*Hamilton_tripdata!$N$21*60/30*EEM_Values!B$6","v":899.77577142857149}]
["train","peak",{"$f":"OFFSET(G17,0,HOME!$AC$3)","v":0},{"$f":"OFFSET(M17,0,HOME!$AC$3)","v":0},{"$f":"OFFSET(S17,0,HOME!$AC$3)","v":0},{"$f":"OFFSET(Y17,0,HOME!$AC$3)","v":0}]
[null,null,{"$f":"OFFSET(G18,0,HOME!$AC$3)","v":462739.36000000004},null,null,null,null,null,{"$f":"Hamilton_tripdata!D49","v":462739.36000000004}]
["Irregular user"]
["car","peak",{"$f":"OFFSET(G20,0,HOME!$AC$3)","v":1391449.0636363635},{"$f":"OFFSET(M20,0,HOME!$AC$3)","v":0.33353353930331547},{"$f":"OFFSET(S20,0,HOME!$AC$3)","v":190.39999999999998},{"$f":"OFFSET(Y20,0,HOME!$AC$3)","v":473.85599999999999},null,null,{"$f":"(Hamilton_tripdata!E44+Hamilton_tripdata!E45)","v":1391449.0636363635},null,null,null,null,null,{"$f":"I20/$I$26","v":0.33353353930331547},null,null,null,null,null,{"$f":"U7","v":190.39999999999998},null,null,null,null,null,{"$f":"U20+Hamilton_tripdata!E30*EEM_Values!B4","v":473.85599999999999}]
[null,"off peak",{"$f":"OFFSET(G21,0,HOME!$AC$3)","v":2315897.12},{"$f":"OFFSET(M21,0,HOME!$AC$3)","v":0.55512586359238747},{"$f":"OFFSET(S21,0,HOME!$AC$3)","v":178.5},{"$f":"OFFSET(Y21,0,HOME!$AC$3)","v":557.85800000000006},null,null,{"$f":"(Hamilton_tripdata!D52+Hamilton_tripdata!E52+Hamilton_tripdata!D53+Hamilton_tripdata!E53)","v":2315897.12},null,null,null,null,null,{"$f":"I21/$I$26","v":0.55512586359238747},null,null,null,null,null,{"$f":"U8","v":178.5},null,null,null,null,null,{"$f":"U21+Hamilton_tripdata!E40*EEM_Values!C4","v":557.85800000000006}]
["bus","peak",{"$f":"OFFSET(G22,0,HOME!$AC$3)","v":7246.32},{"$f":"OFFSET(M22,0,HOME!$AC$3)","v":1.7369595622912597E-3},{"$f":"OFFSET(S22,0,HOME!$AC$3)","v":310},{"$f":"OFFSET(Y22,0,HOME!$AC$3)","v":1049.7757714285715},null,null,{"$f":"Hamilton_tripdata!E47","v":7246.32},null,null,null,null,null,{"$f":"I22/$I$26","v":1.7369595622912597E-3},null,null,null,null,null,{"$f":"Hamilton_tripdata!C14","v":310},null,null,null,null,null,{"$f":"U22+5*EEM_Values!B$7+(EEM_Values!B$10+EEM_Values!C$10*Hamilton_tripdata!C$31)*EEM_Values!B$8+Hamilton_tripdata!C$29*Hamilton_tripdata!$N$21*60/30*EEM_Values!B$6","v":1049.7757714285715}]
[null,"off peak",{"$f":"OFFSET(G23,0,HOME!$AC$3)","v":17340.940000000002},{"$f":"OFFSET(M23,0,HOME!$AC$3)","v":4.1566631824317725E-3},{"$f":"OFFSET(S23,0,HOME!$AC$3)","v":310},{"$f":"OFFSET(Y23,0,HOME!$AC$3)","v":978.4678918918919},null,null,{"$f":"(Hamilton_tripdata!D55+Hamilton_tripdata!E55)","v":17340.940000000002},null,null,null,null,null,{"$f":"I23/$I$26","v":4.1566631824317725E-3},null,null,null,null,null,{"$f":"U22","v":310},null,null,null,null,null,{"$f":"U23+5*EEM_Values!C$7+(EEM_Values!B$10+EEM_Values!C$10*Hamilton_tripdata!$C$41)*EEM_Values!C$8+Hamilton_tripdata!C$39*Hamilton_tripdata!$N$21*60/30*EEM_Values!C$6","v":978.4678918918919}]
["train","peak",{"$f":"OFFSET(G24,0,HOME!$AC$3)","v":0},{"$f":"OFFSET(M24,0,HOME!$AC$3)","v":0},{"$f":"OFFSET(S24,0,HOME!$AC$3)","v":0},{"$f":"OFFSET(Y24,0,HOME!$AC$3)","v":0}]
[null,"off peak",{"$f":"OFFSET(G25,0,HOME!$AC$3)","v":0},{"$f":"OFFSET(M25,0,HOME!$AC$3)","v":0},{"$f":"OFFSET(S25,0,HOME!$AC$3)","v":0},{"$f":"OFFSET(Y25,0,HOME!$AC$3)","v":0}]
[null,null,{"$f":"OFFSET(G26,0,HOME!$AC$3)","v":4171841.5081818183},null,null,null,null,null,{"$f":"(Hamilton_tripdata!E49+Hamilton_tripdata!D57+Hamilton_tripdata!E57)","v":4171841.5081818183}]
[]
["Elasticity calculation"]
["Fare elasticities",null,"Regular traveller/Home based work trips",null,null,null,null,null,null,"Education trips",null,null,null,null,null,null,"Infrequent user /Other trips"]
[null,null,null,null,null,"lambda",null,null,null,null,null,null,"lambda",null,null,null,null,null,null,"lambda"]
["Assumptions",null,"overall e",0,"peak",{"$f":"0.001","v":1E-3},null,null,null,"overall e",0,"peak",{"$f":"F31","v":1E-3},null,null,null,"overall e",0,"peak",{"$f":"F31","v":1E-3}]
[null,null,"factor",{"$f":"(E41-D31)/E41","v":1},"off peak",{"$f":"0.002","v":2E-3},null,null,null,"factor",{"$f":"(M41-K31)/M41","v":1},null,null,null,null,null,"factor",{"$f":"(U41-R31)/U41","v":1},"off peak",2E-3]
[]
["Select the row representing the change in cost, and the column for the change in trips",null,null,null,null,null,null,null,"Select the row representing the change in cost, and the column for the change in trips",null,null,null,null,null,null,null,"Select the row representing the change in cost, and the column for the change in trips"]
[null,null,null,null,null,null,null,null,"price elasticity",null,null,null,null,null,null,null,"price elasticity"]
[null,null,"change in number of trips  >",null,null,null,null,null,null,null,"change in number of trips  >",null,null,null,null,null,null,null,"change in number of trips  >"]
[null,null,"car",null,"bus",null,null,null,null,null,"car",null,"bus",null,null,null,null,null,"car",null,"bus"]
["change in prices ",null,"peak","off peak","peak","off peak",null,null,"change in prices ",null,"peak","off peak","peak","off peak",null,null,"change in prices ",null,"peak","off peak","peak","off peak"]
["car","peak",{"$f":"$D$31-$F$31*(1-$D7)*$E7*$D$32","v":-6.0026827420344993E-2},{"$f":"-D40/10","v":2.7368614599706177E-2},{"$f":"$F$31*$D7*$E7*D32","v":0.13037317257965497},0,null,null,"car","peak",{"$f":"K31-$M$31*(1-$D15)*$E15*K32","v":-4.4444067861441484E-2},null,{"$f":"$M$31*$D15*$E15*K32","v":5.5855932138558523E-2},null,null,null,"car","peak",{"$f":"R31-$T$31*(1-$D$20)*$E20*R32","v":-0.12689521411664872},{"$f":"-T40/10","v":1.5882006669751765E-2},{"$f":"$T$31*$D$20*$E20*R32","v":6.3504785883351261E-2},0]
[null,"off peak",{"$f":"-C39/10","v":6.0026827420344995E-3},{"$f":"$D$31-$F$32*(1-$D$8)*E8*D32","v":-0.27368614599706176},0,{"$f":"$F$32*$O8*$U8*D32","v":8.331385400293824E-2},null,null,null,null,null,null,null,null,null,null,null,"off peak",{"$f":"-S39/10","v":1.2689521411664873E-2},{"$f":"R31-$T$32*(1-$D$21)*E21*R32","v":-0.15882006669751766},0,{"$f":"$T$32*$D$21*$E21*R32","v":0.19817993330248232}]
["bus","peak",{"$f":"$F$31*$D9*$E9*$D$32","v":2.3304910572506336E-3},0,{"$f":"-$F$31*(1-$D9)*$E9","v":-0.22766950894274934},{"$f":"-F42/10","v":4.5889384576100464E-2},null,null,"bus","peak",{"$f":"$M$31*$D16*$E16*K32","v":3.1873355229604852E-3},null,{"$f":"-$M$31*(1-$D16)*$E16","v":-0.15681266447703954},null,null,null,"bus","peak",{"$f":"$T$31*$D$22*$E22*R32","v":5.3845746431029052E-4},0,{"$f":"-$T$31*(1-D22)*E22","v":-0.30946154253568975},{"$f":"-V42/10","v":6.1742286882689221E-2}]
[null,"off peak",0,{"$f":"$F$32*$D10*$E10*D32","v":1.1061542389953268E-3},{"$f":"-E41/10","v":2.2766950894274933E-2},{"$f":"D31-$F$32*(1-$D$10)*$E10*D32","v":-0.45889384576100467},null,null,null,null,null,null,null,null,null,null,null,"off peak",0,{"$f":"$T$32*$D$23*$E23*R32","v":2.577131173107699E-3},{"$f":"-U41/10","v":3.0946154253568975E-2},{"$f":"R31-$T$32*(1-$D$23)*$E23*R32","v":-0.61742286882689223}]
[]
[null,null,"Regular traveller",null,null,"lambda",null,null,null,"Education",null,null,"lambda",null,null,null,"Infrequent user",null,null,"lambda"]
["Assumptions",null,"overall e",0,"peak",{"$f":"0.001","v":1E-3},null,null,null,"overall e",0,"peak",{"$f":"F45","v":1E-3},null,null,null,"overall e",0,"peak",{"$f":"F45","v":1E-3}]
[null,null,"factor",{"$f":"(E52-D45)/E52","v":1},"off peak",{"$f":"0.002","v":2E-3},null,null,null,"factor",{"$f":"(M52-K45)/M52","v":1},null,null,null,null,null,"factor",{"$f":"(U52-R45)/U52","v":1},"off peak",2E-3]
[]
[]
["change in generalised cost",null,null,null,null,null,null,null,"change in generalised cost",null,null,null,null,null,null,null,"change in generalised cost"]
["car","peak",{"$f":"D45-$F$45*(1-D7)*$F7*D46","v":-0.19095593099366218},{"$f":"D45-SUM(D51:D53)","v":0.95785210026346346},{"$f":"$F$45*$D7*$F7*D46","v":0.4147400690063377},0,null,null,"car","peak",{"$f":"K45-$M$45*(1-$D15)*$F15*K46","v":-0.15106020225830802},null,{"$f":"$M$45*D15*$F15*K46","v":0.189847797741692},null,null,null,"car","peak",{"$f":"R45-$T$45*(1-$AF7)*$AA20*R46","v":-0.473856},{"$f":"R45-T51-T52-T53","v":0.48821886905331852},{"$f":"$T$45*$D20*$F20*R46","v":0.15804686880011187},0]
[null,"off peak",{"$f":"D45-C50-C52-C53","v":0.18112961028560731},{"$f":"D45-$F$46*(1-$D8)*$F8*D46","v":-0.96217316142527831},0,{"$f":"$F$46*D8*$F8*D46","v":0.29289883857472188},null,null,null,"off peak",null,null,null,null,null,null,null,"off peak",{"$f":"R46-S50-S52-S53","v":1.4720325819355555},{"$f":"R45-$T$46*(1-$D21)*$AA21*R46","v":-0.49635319197615585},0,{"$f":"$T$46*$D21*$F21*R46","v":0.61936280802384425}]
["bus","peak",{"$f":"$F$45*D9*$F9*D46","v":9.8263207080548694E-3},0,{"$f":"-$F$45*(1-D9)*$F9","v":-0.95994945072051652},{"$f":"D45-F50-F51-F53","v":1.4997158840472471},null,null,"bus","peak",{"$f":"$M$45*$D16*$F16*K46","v":1.7924295493584121E-2},null,{"$f":"-$M$45*(1-D16)*$F16","v":-0.88185147593498747},null,null,null,"bus","peak",{"$f":"$T$45*$D22*$F22*R46","v":1.8234180644445411E-3},0,{"$f":"-$T$45*(1-$D22)*$F22","v":-1.0479523533641271},{"$f":"R45-V50-V51-V53","v":1.3294386528371021}]
[null,"off peak",0,{"$f":"$F$46*D10*$F10*D46","v":4.3210611618148317E-3},{"$f":"D45-E50-E51-E52","v":0.54520938171417876},{"$f":"D45-$F$46*(1-D10)*$F10*D46","v":-1.7926147226219691},null,null,null,"off peak",null,null,null,null,null,null,null,"off peak",0,{"$f":"$T$46*$D23*$F23*R46","v":8.1343229228373181E-3},{"$f":"R46-U50-U51-U52","v":1.8899054845640153},{"$f":"R45-$T$46*(1-$D23)*$F23*R46","v":-1.9488014608609463}]
[]
["ei = lambda* (1 -mode share i)* fare i"]
["eij = lambda * mode share j * fare j"]
[]
["This sheet calculates six sets of figures for use in the output sheets.  It calculates price elasticities and generalised cost elasticities.  It does this for HBW travel, education travel and other travel. "]

{"sheet":"Glaister Lewis","index":5,"n_rows":340,"n_cols":39,"rows_kept":340,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"OPTIMISATION",null,"(Glaister Lewis analysis)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALCULATIONS"]
["INPUTS",null,null,null,null,null,null,null,null,"1)","Set the operating assumptions",null,null,null,"comment"]
["These data have been assembled here from  other sheets"]
["to make the calculations easier to follow",null,null,null,null,null,null,null,null,"1a","Determine the amount of the patronage change absorbed by a change in occupancy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Optimisation calculation"]
[null,null,null,null,null,null,null,null,null,null,"Am peak",null,null,null,"Zero means any new passengers will require extra services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"drop down list"]
["Fares /charges in cents per",null,null,"passenger-km per period",null,null,null,null,null,null,"Interpeak",null,null,null,"100% means the number of services will not change",null,null,null,null,null,null,null,null,null,null,null,"Optimisation works by solving the simultanious equations"]
[null,"Op cost","capacity","congestion","environment","safety","access","Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"except we rearrange them slightly",null,null,null,null,null,null,4,"direct costs only"]
["peak car",{"$f":"L30-'Hamilton_unit costs'!B42+'Hamilton_unit costs'!B48","v":14.523364437866014},null,{"$f":"'Hamilton_unit costs'!M43","v":7.582858023767713},{"$f":"'Hamilton_unit costs'!B59","v":6.0242486646502353},{"$f":"'Hamilton_unit costs'!B64","v":-2.008082888216745},null,{"$f":"(B8+IF($AL$7=5,0,IF($AL$7>2,D8+E8+F8,IF($AL$7=2,D8,0))))","v":26.122388238067217},null,"1b","Determine how the services will be modified",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    revenue = Eij*Qj*Pj",null,null,null,null,null,null,null,"include congestion only"]
["off peak car",{"$f":"L31-'Hamilton_unit costs'!C42+'Hamilton_unit costs'!C48","v":14.589857105251784},null,{"$f":"'Hamilton_unit costs'!O43","v":6.0792624531263044},{"$f":"'Hamilton_unit costs'!C59","v":6.7785268914793555},{"$f":"'Hamilton_unit costs'!C64","v":-1.7322902056002796},null,{"$f":"B9+IF($AL$7=5,0,IF($AL$7>2,D9+E9+F9,IF($AL$7=2,D9,0)))","v":25.715356244257165},null,null,"Am peak",null,null,null,"Choose between changing frequency, route density, vehicle size or a combination",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    cost  = Eij*Qj*MCj",null,null,null,null,null,null,null,"congestion, environment and safety"]
["peak bus",{"$f":"'Hamilton_unit costs'!D50","v":93.654054723823961},{"$f":"'Hamilton_unit costs'!D51","v":6.5795633807569498},{"$f":"D8*3/'Hamilton_unit costs'!D35","v":2.9543602690004076},{"$f":"'Hamilton_unit costs'!D59","v":4.9610389610389616},{"$f":"'Hamilton_unit costs'!D64","v":-1.5844155844155843},{"$f":"-'Hamilton_unit costs'!D73","v":-14.804421768707483},{"$f":"((B10+IF($AL$7=5,G10,IF($AL$7=2,D10,IF($AL$7=3,D10+E10+F10,IF($AL$7=4,D10+E10+F10+G10,0)))))*(HOME!AB$25+HOME!AC$25)+C10*HOME!AD$25)","v":51.108369960444165},null,null,"Interpeak",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All (includes mohring)"]
["off-peak bus",{"$f":"'Hamilton_unit costs'!E50","v":40.14853879007925},{"$f":"'Hamilton_unit costs'!E51","v":2.4892747682670513},{"$f":"D9*3/'Hamilton_unit costs'!E35","v":3.1444460964446401},{"$f":"'Hamilton_unit costs'!E59","v":4.6034482758620694},{"$f":"'Hamilton_unit costs'!E64","v":-1.017241379310345},{"$f":"-'Hamilton_unit costs'!E73","v":-16.391248391248389},{"$f":"((B11+IF($AL$7=5,G11,IF($AL$7=2,D11,IF($AL$7=3,D11+E11+F11,IF($AL$7=4,D11+E11+F11+G11,0)))))*(HOME!AB$26+HOME!AC$26)+C11*HOME!AD$26)","v":12.195177356730895},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Home based work ",null,null,null,null,"other trips",null,null,null,null,null,null,"only mohring"]
[null,null,null,null,null,null,null,null,null,"1c","Determine which impacts are included in the social marginal cost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"revenue","cost","Pi",null,"revenue","cost","target price"]
["Trips and elasticities",null,null,null,null,null,null,null,null,null,null,null,null,null,"Choose what impacts are important to you",null,null,null,null,null,null,null,null,null,null,null,"peak bus",{"$f":"SUMPRODUCT(E16:E19,M30:M33,B16:B19)","v":-119435.61992412353},{"$f":"SUMPRODUCT(E16:E19,B16:B19,H8:H11)","v":-100036.78146257081},{"$f":"(AC13-AB13+M32*B18*E18)/(B18*E18)","v":44.92787262802937},null,{"$f":"SUMPRODUCT(E29:E32,M38:M41,B29:B32)","v":-88865.291170558325},{"$f":"SUMPRODUCT(E29:E32,B29:B32,H8:H11)","v":-81979.501528264533},{"$f":"(AG13-AF13+M40*B31*E31)/(B31*E31)","v":52.536066150624372}]
["Home based work ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"op bus",{"$f":"SUMPRODUCT(F16:F19,M30:M33,B16:B19)","v":-331.36089082706894},{"$f":"SUMPRODUCT(F16:F19,B16:B19,H8:H11)","v":6642.059758022835},{"$f":"(AC14-AB14+M33*B19*F19)/(B19*F19)","v":10.179995346372666},null,{"$f":"SUMPRODUCT(F29:F32,M38:M41,B29:B32)","v":-117001.85741696227},{"$f":"SUMPRODUCT(F29:F32,B29:B32,H8:H11)","v":34369.592725548224},{"$f":"(AG14-AF14+M41*B32*F32)/(B32*F32)","v":7.4310785698011923}]
[null,"pax-km","Elasticity",null,null,null,null,null,null,"2)","Specify any constraints"]
["peak car",{"$f":"elasticities!C7","v":914901.11999999988},{"$f":"elasticities!C$39","v":-6.0026827420344993E-2},5.7696336363094361E-2,{"$f":"elasticities!C$41","v":2.3304910572506336E-3},{"$f":"elasticities!C$42","v":0},null,null,null,null,"Subsidy                 <=",null,12,"million",null,null,null,null,null,null,null,null,null,null,null,null,"School bus",{"$f":"M35*B22*E22+E24*M36*B24","v":-57442.388587301852},{"$f":"E22*B22*H8+E24*B24*H10","v":-52422.549503411145},{"$f":"(AC16-AB16+M36*B24*E24)/(B24*E24)","v":45.924957473140459},null,"Objective",{"$f":"(AD13-M32)^2+(AD14-M33)^2+(AD16-M36)^2+(AH13-M40)^2+(AH14-M41)^2","v":283.35020931664866}]
["off peak car",{"$f":"elasticities!C8","v":311818.5},{"$f":"elasticities!D$39","v":2.7368614599706177E-2},0,{"$f":"elasticities!D$41","v":0},{"$f":"elasticities!D$42","v":1.1061542389953268E-3},null,null,null,null,"max child fare   <=",null,1,"adult","0.5 would limit the child to no more than half the adult fare",null,null,null,{"$f":"M17*M40","v":55.606710770250707}]
["peak bus",{"$f":"elasticities!C9","v":13538.560000000001},{"$f":"elasticities!E$39","v":0.13037317257965497},{"$f":"elasticities!E$40","v":0},{"$f":"elasticities!E$41","v":-0.22766950894274934},{"$f":"elasticities!E$42","v":2.2766950894274933E-2},null,null,null,null,"off peak fare      >=",null,0,"peak","1.0 would prevent off-peak discounting",null,null,{"$f":"M18*M32","v":0},{"$f":"M18*M40","v":0},null,null,null,null,null,null,null,"Subsidy calculation"]
["off-peak bus",{"$f":"elasticities!C10","v":3213},{"$f":"elasticities!F$39","v":0},{"$f":"elasticities!F$40","v":8.331385400293824E-2},{"$f":"elasticities!F$41","v":4.5889384576100464E-2},{"$f":"elasticities!F$42","v":-0.45889384576100467},null,null,null,null,"fare recovery     >=",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"We do this calculation to see the effect on the subsidy"]
["Education","pax-km","Elasticity",null,null,null,null,null,null,"3)","Run the optimisation"]
["peak car",{"$f":"elasticities!C15","v":257694.30000000002},{"$f":"elasticities!K$39","v":-4.4444067861441484E-2},null,{"$f":"elasticities!K$41","v":3.1873355229604852E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pax-km","Cost","Revenue"]
["off peak car",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(per period)","(c per period)","(c per period)"]
["peak bus",{"$f":"elasticities!C16","v":9218.1600000000017},{"$f":"elasticities!M$39","v":5.5855932138558523E-2},null,{"$f":"elasticities!M$41","v":-0.15681266447703954},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K30","v":"peak car"},{"$f":"B16*(N30*C$16+N31*D$16+N32*E$16+N33*F$16)","v":2122.382192343221},{"$f":"B8*AB24","v":30824.130055837642},{"$f":"(B16+AB24)*M30-B16*L30","v":36080.497269835323}]
["off-peak bus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K31","v":"off peak car"},{"$f":"B17*(N30*C$17+N31*D$17+N32*E$17+N33*F$17)","v":-157.10257392953997},{"$f":"B9*AB25","v":-2292.1041044992426},{"$f":"(B17+AB25)*M31-B17*L31","v":-2670.7437568018213}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K32","v":"peak bus"},{"$f":"B18*(N30*C$18+N31*D$18+N32*E$18+N33*F$18)","v":-3208.5616580401088},{"$f":"AB26*(B$10*HOME!AA$25+C$10*HOME!AD$25)","v":-192316.67782838512},{"$f":"(B18+AB26)*M32-B18*L32","v":181587.61423912173}]
[null,null,null,null,null,null,null,null,null,"4) ","View  results",null,null,null,null,null,"current","revised",null,null,null,null,null,null,null,null,{"$f":"K33","v":"off-peak bus"},{"$f":"B19*(N30*C$19+N31*D$19+N32*E$19+N33*F$19)","v":818.33181788932598},{"$f":"AB27*(B$10*HOME!AA$25+C$10*HOME!AD$25)","v":49049.659427106104},{"$f":"(B19+AB27)*M33-B19*L33","v":-27869.540090219241}]
["Other","pax-km","Elasticity",null,null,null,null,null,null,null,null,"current fare","revised fare","change",null,"pt revenue",{"$f":"Hamilton_tripdata!$C$7","v":5.1970000000000001},{"$f":"Q28+AD42","v":5.1147069018008446}]
["peak car",{"$f":"elasticities!C20","v":1391449.0636363635},{"$f":"elasticities!S$39","v":-0.12689521411664872},{"$f":"elasticities!S$40","v":1.2689521411664873E-2},{"$f":"elasticities!S$41","v":5.3845746431029052E-4},{"$f":"elasticities!S$42","v":0},null,null,null,"home based work trips",null,null,"(cents/km)",null,null,"gross cost",{"$f":"Hamilton_tripdata!$C$10","v":17.313842940169859},{"$f":"Q29+AC42","v":17.114713170048677},null,null,null,null,null,null,null,null,{"$f":"K35","v":"peak car"},{"$f":"B22*(N35*C22+N36*E22)","v":375.54979195236132},{"$f":"B8*AB29","v":5454.2464930889046},{"$f":"(B22+AB29)*M35-B22*L35","v":6384.3464631894603}]
["off peak car",{"$f":"elasticities!C21","v":2315897.12},{"$f":"elasticities!T$39","v":1.5882006669751765E-2},{"$f":"elasticities!T$40","v":-0.15882006669751766},{"$f":"elasticities!T$41","v":0},{"$f":"elasticities!T$42","v":2.577131173107699E-3},null,null,null,null,"peak car",{"$f":"EEM_Values!B5","v":17},17,{"$f":"(M30-L30)/L30","v":0},null,"subsidy",{"$f":"Q29-Q28","v":12.11684294016986},{"$f":"R29-R28","v":12.000006268247834},{"$f":"IF(ABS(R30-M16)<0.1,\"Active constraint\",\"\")","v":"Active constraint"},null,null,null,null,null,null,null,{"$f":"K36","v":"peak bus"},{"$f":"B24*(N35*C24+N36*E24)","v":-660.9373676716375},{"$f":"AB30*(B$10*HOME!AA$25+C$10*HOME!AD$25)","v":-39615.657216601416},{"$f":"(B24+AB30)*M36-B24*L36","v":110226.55767037475}]
["peak bus",{"$f":"elasticities!C22","v":7246.32},{"$f":"elasticities!U$39","v":6.3504785883351261E-2},{"$f":"elasticities!U$40","v":0},{"$f":"elasticities!U$41","v":-0.30946154253568975},{"$f":"elasticities!U$42","v":3.0946154253568975E-2},null,null,null,null,"off peak car",{"$f":"EEM_Values!C5","v":17},17,{"$f":"(M31-L31)/L31","v":0},null,"fare recovery",{"$f":"Q28/Q29","v":0.30016444171053652},{"$f":"R28/R29","v":0.29884853172717807},{"$f":"IF(ABS(R31-M19)<0.01,\"Active constraint\",\"\")","v":""}]
["off-peak bus",{"$f":"elasticities!C23","v":17340.940000000002},{"$f":"elasticities!V$39","v":0},{"$f":"elasticities!V$40","v":0.19817993330248232},{"$f":"elasticities!V$41","v":6.1742286882689221E-2},{"$f":"elasticities!V$42","v":-0.61742286882689223},null,null,null,null,"peak bus",{"$f":"Hamilton_tripdata!C15/Hamilton_tripdata!C29/Hamilton_tripdata!N21","v":25.669642857142858},51.221461681157763,{"$f":"(M32-L32)/L32","v":0.99540998549205895},null,"bus-km",{"$f":"Hamilton_tripdata!C8","v":4.63},{"$f":"Q32+Q32*AB42/Q33*(HOME!AB25+HOME!AC25)","v":4.8654106985095744},null,null,null,null,null,null,null,null,{"$f":"K38","v":"peak car"},{"$f":"B29*(N38*C$29+N39*D$29+N40*E$29+N41*F$29)","v":175.40384087548782},{"$f":"B8*AB32","v":2547.4539048361689},{"$f":"(B29+AB32)*M38-B29*L38","v":2981.8652948848903}]
[null,null,null,null,null,null,null,null,null,null,"off-peak bus",{"$f":"Hamilton_tripdata!C18/Hamilton_tripdata!C39/Hamilton_tripdata!N21","v":27.38095238095238},14.909578924527731,{"$f":"(M33-L33)/L33","v":-0.45547624797376979},null,"pax-km",{"$f":"Hamilton_tripdata!C6","v":29.501999999999999},{"$f":"Q33+AB42","v":32.002031111385691},null,null,null,null,null,null,null,null,{"$f":"K39","v":"off peak car"},{"$f":"B30*(N38*C$30+N39*D$30+N40*E$30+N41*F$30)","v":-2712.6872071301295},{"$f":"B9*AB33","v":-39577.718723273138},{"$f":"(B30+AB33)*M39-B30*L39","v":-46115.682521209121}]
[null,null,null,null,null,null,null,null,null,"education ",null,null,null,null,null,"occupancy",{"$f":"Hamilton_tripdata!$I$6","v":6.3719222462203025},{"$f":"R33/R32","v":6.5774572989673619},{"$f":"IF(R34=M20,\"Active constraint\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"K40","v":"peak bus"},{"$f":"B31*(N38*C$31+N39*D$31+N40*E$31+N41*F$31)","v":-626.90424535556861},{"$f":"AB34*(B$10*HOME!AA$25+C$10*HOME!AD$25)","v":-37575.759680721916},{"$f":"(B31+AB34)*M40-B31*L40","v":41578.239662135078}]
[null,null,null,null,null,null,null,null,null,null,"peak car",{"$f":"L30","v":17},17,{"$f":"(M35-L35)/L35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K41","v":"off peak bus"},{"$f":"B32*(N38*C$32+N39*D$32+N40*E$32+N41*F$32)","v":5116.9591157598634},{"$f":"AB35*($B$11*HOME!AA$26+HOME!AD$26*C$11)","v":94501.67851131389},{"$f":"(B32+AB35)*M41-B32*L41","v":-201278.25972469855}]
[null,null,null,null,null,null,null,null,null,null,"peak bus",{"$f":"Hamilton_tripdata!C16/Hamilton_tripdata!D29/Hamilton_tripdata!N21","v":33.898305084745758},49.397634703744878,{"$f":"(M36-L36)/L36","v":0.45723022376047412},null,"Congestion ",{"$f":"((B16+B22+B29)*D8*AB43+(B17+B30)*D9*AB44)/10^8","v":225.01050967947276},{"$f":"Q36+((AB24+AB29+AB32)*D8*AB43+(AB25+AB33)*D9*AB44)/10^8","v":224.9722976674185}]
[null,null,null,null,null,null,null,null,null,"other ",null,null,null,null,null,"PT share",{"$f":"(B18+B24+B31)/(B16+B22+B29)","v":1.1701450654026592E-2},{"$f":"(B18+B24+B31+AB26+AB30+AB34)/(B16+B22+B29+AB24+AB29+AB32)","v":9.9374526235547246E-3},null,null,null,null,null,null,null,null,{"$f":"AA32","v":"peak car"},{"$f":"AB24+AB29+AB32","v":2673.3358251710702},{"$f":"AC24+AC29+AC32","v":38825.830453762719},{"$f":"AD24+AD29+AD32","v":45446.709027909674}]
[null,null,null,null,null,null,null,null,null,null,"peak car",{"$f":"L30","v":17},17,{"$f":"(M38-L38)/L38","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA33","v":"off peak car"},{"$f":"AB25+AB33","v":-2869.7897810596696},{"$f":"AC25+AC33","v":-41869.822827772383},{"$f":"AD25+AD33","v":-48786.426278010942}]
[null,null,null,null,null,null,null,null,null,null,"off peak car",{"$f":"L31","v":17},17,{"$f":"(M39-L39)/L39","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA34","v":"peak bus"},{"$f":"AB26+AB30+AB34","v":-4496.4032710673146},-269508.09472570848,333392.41157163156]
[null,null,null,null,null,null,null,null,null,null,"peak bus",{"$f":"Hamilton_tripdata!C14/Hamilton_tripdata!E30/Hamilton_tripdata!N21","v":45.058139534883722},55.606710770250707,{"$f":"(M40-L40)/L40","v":0.23411022612685439},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA35","v":"off peak bus"},5935.2909336491894,143551.33793842001,-229147.79981491779]
[null,null,null,null,null,null,null,null,null,null,"off peak bus",{"$f":"Hamilton_tripdata!C17/Hamilton_tripdata!E40/Hamilton_tripdata!N21","v":39.54081632653061},21.569099640525287,{"$f":"(M41-L41)/L41","v":-0.45451051231703787}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"annual bus",{"$f":"(AB39*AB43+AB40*AB44)/10^6","v":2.5000311113856943},{"$f":"(AC39*AB43+AC40*AB44)/10^8","v":-0.19912977012118235},{"$f":"(AD39*AB43+AD40*AB44)/10^8*Hamilton_tripdata!I7","v":-8.2293098199155562E-2}]
[null,null,null,null,null,null,null,null,null,"5)","Go back to 1) to review assumptions ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"peak factor",{"$f":"Hamilton_tripdata!N9","v":500},null,null,"these will depend on the region"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"off peak factor",{"$f":"Hamilton_tripdata!O9","v":800}]
[]
[]
[null,null,null,null,null,null,null,null,null,"6) ","View/print assumptions and results",null,null,null,"or 7)","View incremental analysis"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(MC - MR  + Pi *Ei *Qi) / (Ei * Qi)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Parry Small","index":6,"n_rows":42,"n_cols":34,"rows_kept":42,"cut":false,"hidden":false,"merged":[[15,20,15,22],[14,13,14,17],[15,13,15,14],[15,15,15,17],[15,18,15,19]]}
["INPUTS",null,null,null,null,null,null,null,null,null,"INCREMENTAL ANALYSIS",null,"(Effect of 1c reduction in price))",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALCULATIONS"]
["These data have been assembled here from  other"]
["sheets to make the calculations easier to follow",null,null,null,null,null,null,null,null,null,"1)","Set the operating assumptions",null,null,null,"comment",null,null,null,null,null,null,null,null,null,null,null,"Benefit calculation"]
[]
[null,null,"inc","op cost","fare","freq cost","externality",null,null,null,"1a","Determine the amount of the patronage change absorbed by a change in occupancy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The marginal benefit from a change in price is given by"]
[null,null,"(all cents per kilometre)",null,null,null,null,null,null,null,null,"Am peak",null,null,null,"Zero means any new passengers will require extra services"]
["Home based work",null,null,null,null,null,null,null,null,null,null,"Interpeak",null,null,null,"100% means the number of services will not change"]
["car","peak",0,{"$f":"'Glaister Lewis'!B8","v":14.523364437866014},{"$f":"'Glaister Lewis'!L30+C8","v":17},null,{"$f":"'Hamilton_unit costs'!B66","v":9.0918349235351528},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pj -MCj is the difference between the charge and the maginal social cost"]
[null,"off peak",0,{"$f":"'Glaister Lewis'!B9","v":14.589857105251784},{"$f":"'Glaister Lewis'!L31+C9","v":17},null,{"$f":"'Hamilton_unit costs'!C66","v":9.6249526879765668},null,null,null,"1b","Determine how the services will be modified",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(shown as \"cost/trip-km on the main table with MCj split by main impact type)"]
["bus","peak",0,{"$f":"'Hamilton_unit costs'!D50*D28","v":59.938595023247345},{"$f":"'Glaister Lewis'!L32+C10","v":25.669642857142858},{"$f":"-'Hamilton_unit costs'!D71*F28","v":-8.8826530612244916},{"$f":"'Hamilton_unit costs'!D66*F28","v":3.7985901873742716},null,null,null,null,"Am peak",null,null,null,"Chose between changing frequency, route density, vehicle size or a combination"]
[null,"off peak",0,{"$f":"'Hamilton_unit costs'!E50*D29","v":18.468327843436459},{"$f":"'Glaister Lewis'!L33+C11","v":27.38095238095238},{"$f":"-'Hamilton_unit costs'!E71*F29","v":-6.5564993564993577},{"$f":"'Hamilton_unit costs'!E66*F29","v":2.6922611971985466},null,null,null,null,"Interpeak",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The tables below calculate the Eij * Qj  /Pi          (ie the elasticity wrt mode j * base number of mode j trips/price of i)"]
[]
["Education",null,null,null,null,null,null,null,null,null,"2)","View the effect of a one cent reduction in price",null,null,null,"(scroll down)",null,"ALL VALUES IN CENTS"]
["car","peak",0,{"$f":"'Glaister Lewis'!B8","v":14.523364437866014},{"$f":"'Glaister Lewis'!L35+C14","v":17},null,{"$f":"'Hamilton_unit costs'!B67","v":9.0918349235351528}]
["bus","peak",0,{"$f":"'Glaister Lewis'!B10*D28","v":59.938595023247345},{"$f":"'Glaister Lewis'!L36+C15","v":33.898305084745758},{"$f":"F10","v":-8.8826530612244916},{"$f":"'Hamilton_unit costs'!D67*F28","v":3.7985901873742716},null,null,null,null,null,"Period  >","Peak",null,null,null,null,null,null,"Interpeak",null,null,"Total","Revenue",null,null,"Home based work"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mode   >","car",null,"bus",null,null,"car",null,"bus",null,null,"    benefit","loss",null,null,null,null,"EijQj/Pi   >"]
["Other",null,null,null,null,null,null,null,null,null,null,null,"Impact type>","resource","externality","resource","access","externality","resource","externality","resource","access","externality","         (cents/period)",null,null,null,null,null,null,"car",null,"bus"]
["car","peak",0,{"$f":"'Glaister Lewis'!B8","v":14.523364437866014},{"$f":"'Glaister Lewis'!L38+C18","v":17},null,{"$f":"'Hamilton_unit costs'!B69","v":9.0918349235351528},null,null,null,"Mode/period ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fare changed |",null,null,"peak","off peak","peak","off peak"]
[null,"off peak",0,{"$f":"'Glaister Lewis'!B9","v":14.589857105251784},{"$f":"'Glaister Lewis'!L39+C19","v":17},null,{"$f":"'Hamilton_unit costs'!C69","v":9.6249526879765668},null,null,null,"Home based work trips",null,"cents/trip-km>",{"$f":"($D$8-$E$8)","v":-2.4766355621339855},{"$f":"$G$8","v":9.0918349235351528},{"$f":"($D$10-$E$10)","v":34.268952166104484},{"$f":"F10","v":-8.8826530612244916},{"$f":"G10","v":3.7985901873742716},{"$f":"($D$9-$E$9)","v":-2.4101428947482155},{"$f":"$G$9","v":9.6249526879765668},{"$f":"($D$11-$E$11)","v":-8.9126245375159208},{"$f":"F11","v":-6.5564993564993577},{"$f":"G11","v":2.6922611971985466},null,null,null,null,null,null,"base",{"$f":"elasticities!C7","v":914901.11999999988},{"$f":"elasticities!C8","v":311818.5},{"$f":"elasticities!C9","v":13538.560000000001},{"$f":"elasticities!C10","v":3213}]
["bus","peak",0,{"$f":"'Glaister Lewis'!B10*D28","v":59.938595023247345},{"$f":"'Glaister Lewis'!L40+C20","v":45.058139534883722},{"$f":"F10","v":-8.8826530612244916},{"$f":"'Hamilton_unit costs'!D69*F28","v":3.7985901873742716},null,null,null,"car","peak",null,{"$f":"N$19*$AE20","v":8000.787447236602},{"$f":"$O$19*$AE20","v":-29371.232425448023},{"$f":"P$19*$AG20","v":3558.054630500741},{"$f":"Q$19*$AG20","v":-922.2623645575585},394.39756838932516,{"$f":"S$19*$AF20","v":-1209.8974539296021},4831.7490953548986,{"$f":"U$19*$AH20","v":0},0,0,{"$f":"SUM(N20:W20)","v":-14718.403502453617},{"$f":"AE19","v":914901.11999999988},null,null,"car","peak",{"$f":"E8","v":17},{"$f":"elasticities!C39*AE$19/$AD20","v":-3230.506566877667},{"$f":"elasticities!D39*AF$19/$AD20","v":502.00237362108709},{"$f":"elasticities!E39*AG$19/$AD20","v":103.82735408000082},{"$f":"elasticities!F39*AH$19/$AD20","v":0}]
[null,"off peak",0,{"$f":"'Glaister Lewis'!B11*D29","v":18.468327843436459},{"$f":"'Glaister Lewis'!L41+C21","v":39.54081632653061},{"$f":"F11","v":-6.5564993564993577},{"$f":"'Hamilton_unit costs'!E69*F29","v":2.6922611971985466},null,null,null,null,"off peak",null,{"$f":"N$19*$AE21","v":-800.07874472366029},{"$f":"$O$19*$AE21","v":2937.1232425448025},0,0,0,12098.974539296019,-48317.490953548979,-140.34102380580359,-103.24072649981399,42.393202044702157,{"$f":"SUM(N21:W21)","v":-34282.66046469273},{"$f":"AF19","v":311818.5},null,null,null,"off peak",{"$f":"E9","v":17},{"$f":"elasticities!C40*AE$19/$AD21","v":323.05065668776672},{"$f":"elasticities!D40*AF$19/$AD21","v":-5020.0237362108701},{"$f":"elasticities!E40*AG$19/$AD21","v":0},{"$f":"elasticities!F40*AH$19/$AD21","v":15.746318406555327}]
[null,null,null,null,null,null,null,null,null,null,"bus","peak",null,{"$f":"N$19*$AE22","v":-205.71401394944576},{"$f":"$O$19*$AE22","v":755.18493107424115},-4114.8910774452397,1066.596657187177,-456.12088730153488,0,0,-51.192783490534595,-37.65955253699606,15.463946000194275,{"$f":"SUM(N22:W22)","v":-3028.3327804621381},{"$f":"AG19","v":13538.560000000001},null,null,"bus","peak",{"$f":"E10","v":25.669642857142858},{"$f":"elasticities!C41*AE$19/$AD22","v":83.061883264000656},{"$f":"elasticities!D41*AF$19/$AD22","v":0},{"$f":"elasticities!E41*AG$19/$AD22","v":-120.07636117672983},{"$f":"elasticities!F41*AH$19/$AD22","v":5.7438505655712024}]
["Note the frequency cost and externality cost depend on the assumptions",null,null,null,null,null,null,null,null,null,null,"off peak",null,{"$f":"N$19*$AE23","v":0},{"$f":"$O$19*$AE23","v":0},385.77103851049128,-99.993436611297852,42.761333184518904,-30.360701940801896,121.24605573832768,479.93234522376196,353.05830503433816,-144.97449375182137,{"$f":"SUM(N23:W23)","v":1107.4404453875168},{"$f":"AH19","v":3213},null,null,null,"off peak",{"$f":"E11","v":27.38095238095238},{"$f":"elasticities!C42*AE$19/$AD23","v":0},{"$f":"elasticities!D42*AF$19/$AD23","v":12.597054725244263},{"$f":"elasticities!E42*AG$19/$AD23","v":11.257158860318423},{"$f":"elasticities!F42*AH$19/$AD23","v":-53.848599052230036}]
["The unit costs are multiplied by the following factors"]
["(you can see the effect by changing the assumptions in steps 1a and 1b)",null,null,null,null,null,null,null,null,null,"Education",null,"cents/trip-km>",{"$f":"($D$14-$E$14)","v":-2.4766355621339855},{"$f":"$G$14","v":9.0918349235351528},{"$f":"($D$15-$E$15)","v":26.040289938501587},{"$f":"F15","v":-8.8826530612244916},{"$f":"G15","v":3.7985901873742716},null,null,null,null,null,null,null,null,null,"Education",null,"EijQj/Pi   >"]
[null,null,null,null,null,null,null,null,null,null,"car","peak",null,{"$f":"N$25*$AE30","v":1668.5214637114211},{"$f":"O$25*$AE30","v":-6125.2135543787363},{"$f":"P$25*$AG30","v":788.69745572703619},{"$f":"Q$25*$AG30","v":-269.03409624235735},{"$f":"R$25*$AG30","v":115.05011746056489},null,null,null,null,null,{"$f":"SUM(N26:W26)","v":-3821.9786137220717},{"$f":"AE29","v":257694.30000000002}]
[null,null,null,"cost  factor",null,"access factor",null,null,null,null,"bus","peak",null,{"$f":"N$25*$AE32","v":-60.009045098384036},{"$f":"O$25*$AE32","v":220.2957674900606},{"$f":"P$25*$AG32","v":-1110.4351677418472},{"$f":"Q$25*$AG32","v":378.78266199523824},{"$f":"R$25*$AG32","v":-161.98314772459102},null,null,null,null,null,{"$f":"SUM(N27:W27)","v":-733.34893107952337},{"$f":"AG29","v":9218.1600000000017},null,null,null,null,null,"car",null,"bus"]
[null,null,"peak",{"$f":"HOME!AA25","v":0.64000000000000012},null,{"$f":"HOME!AB25+HOME!AC25","v":0.60000000000000009},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fare changed |",null,null,"peak",null,"peak"]
[null,null,"interpeak",{"$f":"HOME!AA26","v":0.46000000000000013},null,{"$f":"HOME!AB26+HOME!AC26","v":0.40000000000000013},null,null,null,null,"Other",null,"cents/trip-km>",{"$f":"($D$18-$E$18)","v":-2.4766355621339855},{"$f":"$G$18","v":9.0918349235351528},{"$f":"($D$20-$E$20)","v":14.880455488363623},{"$f":"F20","v":-8.8826530612244916},{"$f":"G20","v":3.7985901873742716},{"$f":"($D$19-$E$19)","v":-2.4101428947482155},{"$f":"$G$19","v":9.6249526879765668},{"$f":"($D$21-$E$21)","v":-21.072488483094151},{"$f":"F21","v":-6.5564993564993577},{"$f":"G21","v":2.6922611971985466},null,null,null,null,null,null,"base ",{"$f":"elasticities!C15","v":257694.30000000002},null,{"$f":"elasticities!C16","v":9218.1600000000017}]
[null,null,null,null,null,null,null,null,null,null,"car","peak",null,{"$f":"N$29*AE39","v":25723.244105336733},{"$f":"O$29*AE39","v":-94431.127727975298},{"$f":"P$29*AG39","v":402.80167561422684},{"$f":"Q$29*AG39","v":-240.44610326337042},{"$f":"R$29*AG39","v":102.82470813091868},{"$f":"S$29*AF39","v":-5214.5700691338852},{"$f":"T$29*AF39","v":20824.487341774657},{"$f":"U$29*AH39","v":0},{"$f":"V$29*AH39","v":0},{"$f":"W$29*AH39","v":0},{"$f":"SUM(N30:W30)","v":-52832.786069516005},{"$f":"AE38","v":1391449.0636363635},null,null,"car","peak",{"$f":"E14","v":17},{"$f":"elasticities!K39*AE$29/$AD30","v":-673.70487980627422},null,{"$f":"elasticities!M39*AG$29/$AD30","v":30.287583494257341}]
[null,null,null,null,null,null,null,null,null,null,null,"off peak",null,{"$f":"N$29*AE40","v":-2572.3244105336735},{"$f":"O$29*AE40","v":9443.112772797529},{"$f":"P$29*AG40","v":0},{"$f":"Q$29*AG40","v":0},{"$f":"R$29*AG40","v":0},{"$f":"S$29*AF40","v":52145.700691338847},{"$f":"T$29*AF40","v":-208244.87341774654},{"$f":"U$29*AH40","v":-4259.898165556534},{"$f":"V$29*AH40","v":-1325.4257846021203},{"$f":"W$29*AH40","v":544.25268967859108},{"$f":"SUM(N31:W31)","v":-154269.45562462389},{"$f":"AF38","v":2315897.12}]
[null,null,null,null,null,null,null,null,null,null,"bus","peak",null,{"$f":"N$29*AE41","v":-41.182012270120552},{"$f":"O$29*AE41","v":151.18092589138038},{"$f":"P$29*AG41","v":-740.57178897102847},{"$f":"Q$29*AG41","v":442.07264176181491},{"$f":"R$29*AG41","v":-189.04856325341646},{"$f":"S$29*AF41","v":0},{"$f":"T$29*AF41","v":0},{"$f":"U$29*AH41","v":-500.72343341278912},{"$f":"V$29*AH41","v":-155.79521476967238},{"$f":"W$29*AH41","v":63.973377960880448},{"$f":"SUM(N32:W32)","v":-970.09406706295113},{"$f":"AG38","v":7246.32},null,null,"bus","peak",{"$f":"E15","v":33.898305084745758},{"$f":"elasticities!K41*AE$29/$AD32","v":24.230066795405872},null,{"$f":"elasticities!M41*AG$29/$AD32","v":-42.642964819682184}]
[null,null,null,null,null,null,null,null,null,null,null,"off peak",null,{"$f":"N$29*AE42","v":0},{"$f":"O$29*AE42","v":0},{"$f":"P$29*AG42","v":84.390738743210207},{"$f":"Q$29*AG42","v":-50.375719642625413},{"$f":"R$29*AG42","v":21.542743254459083},{"$f":"S$29*AF42","v":-363.79183536930623},{"$f":"T$29*AF42","v":1452.8097945277755},{"$f":"U$29*AH42","v":5705.918194703876},{"$f":"V$29*AH42","v":1775.3408194683595},{"$f":"W$29*AH42","v":-728.99895815887021},{"$f":"SUM(N33:W33)","v":7896.8357775268778},{"$f":"AH38","v":17340.940000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"car",null,"bus"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fare changed |",null,null,"peak","off peak","peak","off peak"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"base ","patronage",null,{"$f":"elasticities!C20","v":1391449.0636363635},{"$f":"elasticities!C21","v":2315897.12},{"$f":"elasticities!C22","v":7246.32},{"$f":"elasticities!C23","v":17340.940000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"car","peak",{"$f":"E18","v":17},{"$f":"elasticities!S39*AE$38/$AD39","v":-10386.36628603216},{"$f":"elasticities!T39*AF$38/$AD39","v":2163.5937356646418},{"$f":"elasticities!U39*AG$38/$AD39","v":27.069176473073288},{"$f":"elasticities!V39*AH$38/$AD39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"off peak",{"$f":"E19","v":17},{"$f":"elasticities!S40*AE$38/$AD40","v":1038.636628603216},{"$f":"elasticities!T40*AF$38/$AD40","v":-21635.937356646416},{"$f":"elasticities!U40*AG$38/$AD40","v":0},{"$f":"elasticities!V40*AH$38/$AD40","v":202.15449015307931}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bus","peak",{"$f":"E20","v":45.058139534883722},{"$f":"elasticities!S41*AE$38/$AD41","v":16.628208404887879},{"$f":"elasticities!T41*AF$38/$AD41","v":0},{"$f":"elasticities!U41*AG$38/$AD41","v":-49.768086034069903},{"$f":"elasticities!V41*AH$38/$AD41","v":23.761950745138861}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"off peak",{"$f":"E21","v":39.54081632653061},{"$f":"elasticities!S42*AE$38/$AD42","v":0},{"$f":"elasticities!T42*AF$38/$AD42","v":150.94201931429924},{"$f":"elasticities!U42*AG$38/$AD42","v":5.6712470131847095},{"$f":"elasticities!V42*AH$38/$AD42","v":-270.77571779344282}]

{"sheet":"Report","index":7,"n_rows":111,"n_cols":17,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
["SUMMARY OF INPUTS AND RESULTS"]
["Assumptions",null,null,null,null,"Titles for graphs",null,null,null,null,null,"REPORT"]
[null,null,null,null,null,"Title","interpretation"]
["Operating assumptions:",null,null,null,null,"car direct","direct benefit of change in car travel",null,null,null,null,"This speadsheet can be used to print the results from an analysis"]
["Percent of increase absorbed by increased occupancy",null,null,null,null,"car ext","congestion safety and env.",null,null,null,null,"The first page shows the assumptions and constraints"]
[null,"Peak",{"$f":"HOME!Z18","v":0.39999999999999991},null,null,"bus direct","direct benefit of change in bus travel"]
[null,"Interpeak",{"$f":"HOME!AA18","v":0.59999999999999987},null,null,"bus access","benefit from extra services",null,null,null,null,"Undertake the analysis using the optimise (Glaister lewis) or Increment (Parry Small) sheet"]
[null,null,null,null,null,"bus ext ","congestion safety and env."]
["Operating change to accommodate increased patronage",null,null,null,null,"road direct",")",null,null,null,null,"Then view /print the results using this sheet"]
[null,"Peak",{"$f":"OFFSET(HOME!AD10,HOME!Z11,0)","v":"frequency changes"},null,null,"car ext",")","ditto interpeak"]
[null,"interpeak",{"$f":"OFFSET(HOME!AD10,HOME!AA11,0)","v":"frequency changes"},null,null,"bus direct",")",null,null,null,null,"Be sure to run macro  [calculate optimum fares]"]
[null,null,null,null,null,"bus access",")",null,null,null,null,"before printing "]
["Optimisation assumption",null,null,null,null,"bus ext ",")"]
["Impacts considered in optimisation"]
[]
[null,{"$f":"OFFSET('Glaister Lewis'!AM6,'Glaister Lewis'!AL7,0)","v":"All (includes mohring)"}]
[]
["Assumed constraints (Glaister Lewis analysis only)"]
["Maximum subsidy",null,null,{"$f":"'Glaister Lewis'!M16","v":12},{"$f":"'Glaister Lewis'!N16","v":"million"}]
["Child as % of adult",null,null,{"$f":"'Glaister Lewis'!M17","v":1},"(maximum)"]
["ratio off peak/peak fare ",null,null,0,"(minimum)"]
["target revenue recovery",null,null,{"$f":"'Glaister Lewis'!M19","v":0}]
[]
["Results"]
[]
[]
["Optimum fare"]
[{"$f":"'Glaister Lewis'!M29","v":"(cents/km)"}]
[null,null,{"$f":"'Glaister Lewis'!L28","v":"current fare"},{"$f":"'Glaister Lewis'!M28","v":"revised fare"},{"$f":"'Glaister Lewis'!N28","v":"change"}]
["Multi-ride tickets"]
[null,{"$f":"'Glaister Lewis'!K32","v":"peak bus"},{"$f":"'Glaister Lewis'!L32","v":25.669642857142858},{"$f":"'Glaister Lewis'!M32","v":51.221461681157763},{"$f":"'Glaister Lewis'!N32","v":0.99540998549205895}]
[null,{"$f":"'Glaister Lewis'!K33","v":"off-peak bus"},{"$f":"'Glaister Lewis'!L33","v":27.38095238095238},{"$f":"'Glaister Lewis'!M33","v":14.909578924527731},{"$f":"'Glaister Lewis'!N33","v":-0.45547624797376979}]
["School services"]
[null,{"$f":"'Glaister Lewis'!K36","v":"peak bus"},{"$f":"'Glaister Lewis'!L36","v":33.898305084745758},{"$f":"'Glaister Lewis'!M36","v":49.397634703744878},{"$f":"'Glaister Lewis'!N36","v":0.45723022376047412}]
["Occasional tickets"]
[null,{"$f":"'Glaister Lewis'!K40","v":"peak bus"},{"$f":"'Glaister Lewis'!L40","v":45.058139534883722},{"$f":"'Glaister Lewis'!M40","v":55.606710770250707},{"$f":"'Glaister Lewis'!N40","v":0.23411022612685439}]
[null,{"$f":"'Glaister Lewis'!K41","v":"off peak bus"},{"$f":"'Glaister Lewis'!L41","v":39.54081632653061},{"$f":"'Glaister Lewis'!M41","v":21.569099640525287},{"$f":"'Glaister Lewis'!N41","v":-0.45451051231703787}]
[]
["Outcomes"]
[]
[null,{"$f":"'Glaister Lewis'!P28","v":"pt revenue"},{"$f":"'Glaister Lewis'!R28","v":5.1147069018008446},"million"]
[null,{"$f":"'Glaister Lewis'!P29","v":"gross cost"},{"$f":"'Glaister Lewis'!R29","v":17.114713170048677},"million"]
[null,{"$f":"'Glaister Lewis'!P31","v":"fare recovery"},{"$f":"'Glaister Lewis'!R31","v":0.29884853172717807}]
[null,"occupancy",{"$f":"'Glaister Lewis'!R34","v":6.5774572989673619},"peak"]
[null,{"$f":"'Glaister Lewis'!P37","v":"PT share"},{"$f":"'Glaister Lewis'!R37","v":9.9374526235547246E-3},"peak"]
[]
[]
[]
[]
[]
[]
["Incremental analysis"]
["A one cent reduction in fare "]
["(graph scale dollars per year)"]
[]
["multiride fares"]
["am peak",null,"$ per year"]
["Revenue loss",null,{"$f":"Report!C106","v":67692.800000000003}]
["Net Benefit",null,{"$f":"Report!D106","v":-15141.663902310689}]
[]
["most benefit is from ",null,{"$f":"Report!Q106","v":"bus access"}]
[]
["multiride fares"]
["interpeak",null,"$ per year"]
["Revenue loss",null,{"$f":"Report!C107","v":25704.000000000004}]
["Net Benefit",null,{"$f":"Report!D107","v":8859.5235631001342}]
[]
["most benefit is from ",null,{"$f":"Report!Q107","v":"bus resource"}]
[]
[]
[]
[]
["school fares"]
["peak",null,"$ per year"]
["Revenue loss",null,{"$f":"Report!C108","v":46090.80000000001}]
["Net Benefit",null,{"$f":"Report!D108","v":-3666.7446553976165}]
[]
["most benefit is from ",null,{"$f":"Report!Q108","v":"bus access"}]
[]
[]
[]
[]
["occasionalfares"]
["peak",null,"$ per year"]
["Revenue loss",null,{"$f":"Report!C109","v":36231.599999999999}]
["Net Benefit",null,{"$f":"Report!D109","v":-4850.4703353147561}]
[]
["most benefit is from ",null,{"$f":"Report!Q109","v":"bus access"}]
[]
[]
[]
["occasionalfares"]
["interpeak",null,"$ per year"]
["Revenue loss",null,{"$f":"Report!C110","v":138727.52000000002}]
["Net Benefit",null,{"$f":"Report!D110","v":63174.686220215015}]
[]
[]
["most benefit is from ",null,{"$f":"Report!Q110","v":"bus resource"}]
[]
[]
[]
[]
[null,null,"CALCULATION"]
[]
[null,null,null," "]
[null,null,{"$f":"'Parry Small'!Y22/100*Hamilton_tripdata!$N9","v":67692.800000000003},{"$f":"'Parry Small'!X22/100*Hamilton_tripdata!$N9","v":-15141.663902310689},{"$f":"'Parry Small'!N22/100*Hamilton_tripdata!$N9","v":-1028.5700697472289},{"$f":"'Parry Small'!O22/100*Hamilton_tripdata!$N9","v":3775.9246553712055},{"$f":"'Parry Small'!P22/100*Hamilton_tripdata!$N9","v":-20574.455387226197},{"$f":"'Parry Small'!Q22/100*Hamilton_tripdata!$N9","v":5332.9832859358849},{"$f":"'Parry Small'!R22/100*Hamilton_tripdata!$N9","v":-2280.6044365076741},{"$f":"'Parry Small'!S22/100*Hamilton_tripdata!$N9","v":0},{"$f":"'Parry Small'!T22/100*Hamilton_tripdata!$N9","v":0},{"$f":"'Parry Small'!U22/100*Hamilton_tripdata!$N9","v":-255.963917452673},{"$f":"'Parry Small'!V22/100*Hamilton_tripdata!$N9","v":-188.29776268498031},{"$f":"'Parry Small'!W22/100*Hamilton_tripdata!$N9","v":77.319730000971376},null,6,{"$f":"HLOOKUP(MAX(E106:N106),E106:N$111,P106,)","v":"bus access"}]
[null,null,{"$f":"'Parry Small'!Y23/100*Hamilton_tripdata!$O9","v":25704.000000000004},{"$f":"'Parry Small'!X23/100*Hamilton_tripdata!$O9","v":8859.5235631001342},{"$f":"'Parry Small'!N23/100*Hamilton_tripdata!$O9","v":0},{"$f":"'Parry Small'!O23/100*Hamilton_tripdata!$O9","v":0},{"$f":"'Parry Small'!P23/100*Hamilton_tripdata!$O9","v":3086.1683080839302},{"$f":"'Parry Small'!Q23/100*Hamilton_tripdata!$O9","v":-799.94749289038282},{"$f":"'Parry Small'!R23/100*Hamilton_tripdata!$O9","v":342.09066547615123},{"$f":"'Parry Small'!S23/100*Hamilton_tripdata!$O9","v":-242.88561552641514},{"$f":"'Parry Small'!T23/100*Hamilton_tripdata!$O9","v":969.96844590662135},{"$f":"'Parry Small'!U23/100*Hamilton_tripdata!$O9","v":3839.4587617900952},{"$f":"'Parry Small'!V23/100*Hamilton_tripdata!$O9","v":2824.4664402747053},{"$f":"'Parry Small'!W23/100*Hamilton_tripdata!$O9","v":-1159.795950014571},null,5,{"$f":"HLOOKUP(MAX(E107:N107),E107:N$111,P107,)","v":"bus resource"}]
[null,null,{"$f":"'Parry Small'!Y27/100*Hamilton_tripdata!$N9","v":46090.80000000001},{"$f":"'Parry Small'!X27/100*Hamilton_tripdata!$N9","v":-3666.7446553976165},{"$f":"'Parry Small'!N27/100*Hamilton_tripdata!$N9","v":-300.04522549192018},{"$f":"'Parry Small'!O27/100*Hamilton_tripdata!$N9","v":1101.478837450303},{"$f":"'Parry Small'!P27/100*Hamilton_tripdata!$N9","v":-5552.1758387092359},{"$f":"'Parry Small'!Q27/100*Hamilton_tripdata!$N9","v":1893.9133099761912},{"$f":"'Parry Small'!R27/100*Hamilton_tripdata!$N9","v":-809.91573862295502},{"$f":"'Parry Small'!S27/100*Hamilton_tripdata!$N9","v":0},{"$f":"'Parry Small'!T27/100*Hamilton_tripdata!$N9","v":0},{"$f":"'Parry Small'!U27/100*Hamilton_tripdata!$N9","v":0},{"$f":"'Parry Small'!V27/100*Hamilton_tripdata!$N9","v":0},{"$f":"'Parry Small'!W27/100*Hamilton_tripdata!$N9","v":0},null,4,{"$f":"HLOOKUP(MAX(E108:N108),E108:N$111,P108,)","v":"bus access"}]
[null,null,{"$f":"'Parry Small'!Y32/100*Hamilton_tripdata!$N9","v":36231.599999999999},{"$f":"'Parry Small'!X32/100*Hamilton_tripdata!$N9","v":-4850.4703353147561},{"$f":"'Parry Small'!N32/100*Hamilton_tripdata!$N9","v":-205.91006135060275},{"$f":"'Parry Small'!O32/100*Hamilton_tripdata!$N9","v":755.90462945690194},{"$f":"'Parry Small'!P32/100*Hamilton_tripdata!$N9","v":-3702.8589448551425},{"$f":"'Parry Small'!Q32/100*Hamilton_tripdata!$N9","v":2210.3632088090744},{"$f":"'Parry Small'!R32/100*Hamilton_tripdata!$N9","v":-945.24281626708228},{"$f":"'Parry Small'!S32/100*Hamilton_tripdata!$N9","v":0},{"$f":"'Parry Small'!T32/100*Hamilton_tripdata!$N9","v":0},{"$f":"'Parry Small'!U32/100*Hamilton_tripdata!$N9","v":-2503.6171670639455},{"$f":"'Parry Small'!V32/100*Hamilton_tripdata!$N9","v":-778.97607384836192},{"$f":"'Parry Small'!W32/100*Hamilton_tripdata!$N9","v":319.86688980440226},null,3,{"$f":"HLOOKUP(MAX(E109:N109),E109:N$111,P109,)","v":"bus access"}]
[null,null,{"$f":"'Parry Small'!Y33/100*Hamilton_tripdata!$O9","v":138727.52000000002},{"$f":"'Parry Small'!X33/100*Hamilton_tripdata!$O9","v":63174.686220215015},{"$f":"'Parry Small'!N33/100*Hamilton_tripdata!$O9","v":0},{"$f":"'Parry Small'!O33/100*Hamilton_tripdata!$O9","v":0},{"$f":"'Parry Small'!P33/100*Hamilton_tripdata!$O9","v":675.12590994568166},{"$f":"'Parry Small'!Q33/100*Hamilton_tripdata!$O9","v":-403.0057571410033},{"$f":"'Parry Small'!R33/100*Hamilton_tripdata!$O9","v":172.34194603567266},{"$f":"'Parry Small'!S33/100*Hamilton_tripdata!$O9","v":-2910.3346829544498},{"$f":"'Parry Small'!T33/100*Hamilton_tripdata!$O9","v":11622.478356222204},{"$f":"'Parry Small'!U33/100*Hamilton_tripdata!$O9","v":45647.345557631008},{"$f":"'Parry Small'!V33/100*Hamilton_tripdata!$O9","v":14202.726555746875},{"$f":"'Parry Small'!W33/100*Hamilton_tripdata!$O9","v":-5831.9916652709617},null,2,{"$f":"HLOOKUP(MAX(E110:N110),E110:N$111,P110,)","v":"bus resource"}]
[null,null,null,null,{"$f":"'Parry Small'!N16&\" \"&'Parry Small'!N17","v":"car resource"},{"$f":"'Parry Small'!N16&\" \"&'Parry Small'!O17","v":"car externality"},{"$f":"'Parry Small'!P16&\" \"&'Parry Small'!P17","v":"bus resource"},{"$f":"'Parry Small'!P16&\" \"&'Parry Small'!Q17","v":"bus access"},{"$f":"'Parry Small'!P16&\" \"&'Parry Small'!R17","v":"bus externality"},{"$f":"'Parry Small'!S16&\" \"&'Parry Small'!S17","v":"car resource"},{"$f":"'Parry Small'!S16&\" \"&'Parry Small'!T17","v":"car externality"},{"$f":"'Parry Small'!U16&\" \"&'Parry Small'!U17","v":"bus resource"},{"$f":"'Parry Small'!U16&\" \"&'Parry Small'!V17","v":"bus access"},{"$f":"'Parry Small'!U16&\" \"&'Parry Small'!W17","v":"bus externality"}]

{"sheet":"timetable","index":8,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["bus route frequency"]
[null,"6:30-8:30","10:30-12:30",null,"buses"]
[1,6,4,null,{"$f":"B3/2","v":3}]
[2,5,3,null,{"$f":"B4/2","v":2.5}]
[3,5,4,null,2.5]
[4,4,3,null,2]
[5,4,3,null,2]
[6,4,4,null,2]
[7,4,4,null,2]
[8,5,6,null,2.5]
[9,4,4,null,2]
[10,4,3,null,2]
[11,4,4,null,2]
[12,4,4,null,2]
[13,4,4,null,2]
[14,4,3,null,2]
[15,3,3,null,1.5]
[16,4,4,null,2]
[17,4,4,null,2]
[18,5,4,null,2.5]
[26,4,4,null,2]
[30,3,2,null,1.5]
[null,{"$f":"AVERAGE(B3:B22)","v":4.2},{"$f":"AVERAGE(C3:C22)","v":3.7},null,{"$f":"SUM(E3:E22)","v":42}]

{"sheet":"capcost","index":9,"n_rows":18,"n_cols":17,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"annual*","cost/seat",null,"peak vehicle"]
[null,"length","seats","max capac","ave load","cost","cost/seat","age",null,"$(000)","$(000)",null,"$  /seat km"]
["mini",8,19,19,19,115,{"$f":"F3/E3","v":6.0526315789473681},10,null,15.8,{"$f":"J3/D3","v":0.83157894736842108},null,{"$f":"2/$B$17/2 *K3 /400*1000","v":6.9298245614035095E-2},null,null,"each peak trip requires 2t/p buses"]
["midi",10,29,40,34,280,{"$f":"F4/E4","v":8.235294117647058},20,null,27.2,{"$f":"J4/D4","v":0.67999999999999994},null,5.6666666666666664E-2,null,null,null,"where t = trip time and p = length of peak"]
["rigid",11.7,39,64,47,380,8.085106382978724,20,null,37,{"$f":"J5/D5","v":0.578125},null,4.8177083333333336E-2,null,null,"cost for 1 km = 2/speed /p * cost per bus / no of peaks"]
["rigid gas",11.7,39,64,47,430,9.1489361702127656,20,null,42.3,0.66093749999999996,null,5.5078124999999999E-2,null,null,"                            = 2/speed /p * cost per bus / 400"]
["long",14.5,47,81,57,400,7.0175438596491224,20,null,38.9,0.4802469135802469,null,4.002057613168724E-2]
["artic",18,67,101,80,600,{"$f":"F8/E8","v":7.5},20,null,58.4,0.57821782178217818,null,4.8184818481848177E-2]
[]
["lrt",30,58,190,130,4500,34.615384615384613,35,null,350.2,1.8431578947368421,null,{"$f":"2/$B$17/2 *K10 /400*1000","v":0.15359649122807018}]
[]
["emu 3-car",72,265,750,400,8000,20,35,null,627,0.83599999999999997,null,{"$f":"2/$B$18/2 *K12 /400*1000","v":4.1799999999999997E-2}]
["dmu 3-car",72,265,750,400,8800,22,35,null,687,0.91600000000000004,null,{"$f":"2/$B$18/2 *K13 /400*1000","v":4.58E-2}]
[]
["*Booz Allen and Hamilton/IPW"]
[]
["Assumes ",30,"km/h bus"]
[null,50,"km/h train"]

{"sheet":"STCC Data","index":10,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Unit costs","DATA FROM STCC"]
["all costs in cents","CAR",null,"BUS",null,"TRAIN"]
[null,"Per vehicle km",null,"Per vehicle km",null,"Per train km"]
[null,"Peak ","Off peak","Peak ","Off peak","Peak ","Off peak"]
["Per Vehicle "]
[]
["A Private resource costs"]
["Operations and vehicle costs",15.4,14.6]
["Operations - time",21.6,17.8]
["Accidents internal",-3.3,5.2,9.8000000000000007,13.2]
["Parking",60,30]
[]
["B Private charges"]
["Fuel duty",3.8,3.3,{"$f":"B14*30/12","v":9.5},{"$f":"C14*30/12","v":8.25}]
["Fares"]
[]
["C. Provider costs"]
["Road infrastruction o&m",0.1,0.1,5,5]
["Operations and vehicle costs",null,null,{"$f":"D47*D33","v":0},{"$f":"E47*E33","v":4.6537933925237205},{"$f":"F47*F33","v":5400},{"$f":"G47*G33","v":300}]
[null,{"$f":"B18+B19","v":0.1},0.1,5,9.6537933925237205,5400,300]
[]
["D. External costs"]
["Congestion",36,8,{"$f":"B23*3","v":108},{"$f":"C23*3","v":24}]
["User economies of scale"]
["accidents external",-3,2.2999999999999998,-12.2,5.9]
["Environmental",1.8,1.5,38.200000000000003,26.7]
[null,{"$f":"SUM(B23:B26)","v":34.799999999999997},{"$f":"SUM(C23:C26)","v":11.8},{"$f":"SUM(D23:D26)","v":134},{"$f":"SUM(E23:E26)","v":56.599999999999994}]
[]
["Per person costs"]
["cents","CAR",null,"BUS",null,"TRAIN"]
[null,"Per vehicle km",null,"Per vehicle km",null,"Per train km"]
[null,"Peak ","Off peak","Peak ","Off peak","Peak ","Off peak"]
["Occupancy",{"$f":"Hamilton_tripdata!#REF!","v":{"$error":"#REF!"}},{"$f":"Hamilton_tripdata!#REF!","v":{"$error":"#REF!"}},{"$f":"Hamilton_tripdata!Q8","v":0},{"$f":"Hamilton_tripdata!I7","v":0.49508440345997029},120,60]
[]
["A Private resource costs"]
["Operations and vehicle costs",{"$f":"B8/1.4","v":11.000000000000002},{"$f":"C8/1.6","v":9.125}]
["Operations - time",{"$f":"B9","v":21.6},{"$f":"C9","v":17.8},58,58,34.799999999999997,34.799999999999997]
["Accidents internal",{"$f":"B10/1.4","v":-2.3571428571428572},{"$f":"C10/1.6","v":3.25},-1.1000000000000001,0.7]
["Parking",{"$f":"B11/1.4","v":42.857142857142861},{"$f":"C11/1.6","v":18.75}]
[]
["B Private charges"]
["Fuel duty",{"$f":"B14/1.4","v":2.7142857142857144},{"$f":"C14/1.6","v":2.0624999999999996}]
["Fares",null,null,20.3,21,13,13]
[]
["C. Provider costs"]
["Road infrastruction o&m",{"$f":"B18/1.4","v":7.1428571428571438E-2},{"$f":"C18/1.6","v":6.25E-2},0.6,0.3]
["Operations and vehicle costs",null,null,45.3,9.4,{"$f":"22.5*2","v":45},5]
[null,{"$f":"B46+B47","v":7.1428571428571438E-2},6.25E-2,45.9,9.7000000000000011,45,5]
[]
["D. External costs"]
["Congestion",{"$f":"B23/1.4","v":25.714285714285715},{"$f":"C23/1.6","v":5},{"$f":"D23/D33","v":{"$error":"#DIV/0!"}},{"$f":"E23/E33","v":48.476582643832977}]
["User economies of scale",null,null,-13.9,-5.5,{"$f":"D52","v":-13.9},{"$f":"E52","v":-5.5}]
["accidents external",{"$f":"B25/1.4","v":-2.1428571428571428},{"$f":"C25/1.6","v":1.4374999999999998},-1.4,0.3]
["Environmental",{"$f":"B26/1.4","v":1.2857142857142858},{"$f":"C26/1.6","v":0.9375},3.6,1.5,0,0]
[null,{"$f":"SUM(B51:B54)","v":24.857142857142858},7.375,{"$error":"#DIV/0!"},44.776582643832974,-13.9,-5.5]

{"sheet":"Sheet1","index":11,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"fix fares"]
[null,14.285714285714285,15.987336745504946]
[null,16.216216216216214,11.901734434718586]
[]
[null,"fix headway"]
[null,17,17]
[null,17,17]
[null,20.535714285714288,73.684964297788994]
[null,21.904761904761905,20.75641079221322]
[]
[null,17,17]
[null,27.118644067796609,76.865090241008332]
[]
[null,17,17]
[null,17,17]
[null,41.034897713598077,71.511311897995]
[null,36.470588235294116,23.51301502717843]
[]
[null,"no fix"]

{"sheet":"EEM_Values","index":12,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Component","Am Peak","Inter peak","Comment"]
["Car in vehicle time ",32.96,38.71,"c/min","In car cost from TN15 Table5"]
["Car distance",17,17,"c/km","In car cost from TN15 Table1"]
["PT Ride Cost",17.41,15.92,"c/min","As per TN15 with no “Worktravel ”costs "]
["Walk cost",34.82,31.84,"c/min","Twice the ride cost"]
["Wait Cost",34.82,31.84,"c/min","Twice the ride cost"]
["active cost",{"$f":"60/15*B6","v":69.64},{"$f":"60/15*C6","v":63.68},"c/km","15 km/h * walk cost"]
["wait time coef",5,0.16]
[]
[]
[null,"am peak","interpeak"]
[null,"$/hour","$/hour"]
["Overall base ",15.13,17.95]
["Congestion",3.88,3.6]
["Total",{"$f":"B15+B16","v":19.010000000000002},{"$f":"C15+C16","v":21.55}]
[]
["Emissions","kg/car-km","$ per tonne","$ per car.km"]
["CO2",2,40]
["Other",null,null,0.01]

{"sheet":"ONA","index":13,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"THIS OPTION IS NOT AVAILABLE YET"]