{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tra01_02 - AI calculator","Schedule of changes"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":24,"comments":1,"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":"Tra01_02 - AI calculator","index":0,"n_rows":287,"n_cols":222,"rows_kept":287,"cut":false,"hidden":false,"merged":[[5,9,5,10],[286,1,286,3],[284,1,284,3]]}
[]
[null,"BREEAM-NOR v6.1 Tra 01 Accessibility Index Calculator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please select",null,null,null,null,null,"no.","Pattern type","selection made"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Offices/Industrial",null,null,null,null,null,"Offices/Industrial",null,null,null,null,null,2,1,{"$f":"IF(scope=AC3,AD3,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential",null,null,null,null,null,"Residential",null,null,null,null,null,3,1,1]
[null,"Using the drop down boxes make the relevant selections and press the 'Select' button",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multi-residential",null,null,null,null,null,"Multi-residential",null,null,null,null,null,4,1,0]
[null,"Building type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other building type 1",null,null,null,null,null,"Pre-school",null,null,null,null,null,5,1,0]
[null,"No. nodes required",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre-school",null,null,null,null,null,"School",null,null,null,null,null,6,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"School",null,null,null,null,null,"Sixth Form",null,null,null,null,null,7,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection>=1,0,1)","v":0},null,"Sixth Form",null,null,null,null,null,"Further Education College",null,null,null,null,null,8,2,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=1,0,1))","v":0},null,"Retail",null,null,null,null,null,"Higher Education type 1",null,null,null,null,null,9,2,0]
[null,"NODE 1",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Law Court",null,null,null,null,null,"Higher education type 2",null,null,null,null,null,10,3,0]
[null,"Public transport type","Bus",null,null,null,null,null,null,null,null,null,null,null,0,"Bus","Further Education College",null,null,null,null,null,"Healthcare Hospitals(Acute, Specialist, Teaching, Mental health)",null,null,null,null,null,11,2,0]
[null,"Distance to node (m)",999,null,null,null,null,null,null,null,null,null,null,null,0,"Tram","Higher Education type 1",null,null,null,null,null,"Healthcare  GP surgery, Health centre, Community hospital",null,null,null,null,null,12,3,0]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,0,"Metro","Other building type 2",null,null,null,null,null,"Rural location sensitive buildings",null,null,null,null,null,13,4,0,null,null,null,null,null,null,null,null,null,null,null,null,"Prison",{"$f":"AC15","v":14}]
[null,"Average frequency per hour",10,null,null,null,null,null,null,null,null,null,null,null,0,"Rail","Higher education type 2",null,null,null,null,null,"Prison site",null,null,null,null,null,14,4,0,null,null,null,null,null,null,"Samsvarende kollektivknutepunkt",null,null,null,null,null,"MOD",{"$f":"AC16","v":15}]
[null,"Reliability factor",{"$f":"IF(OR($C12=$P$12,$C12=$P$13,$C12=$P$14),2,+IF($C12=$P$15,0.75))","v":2},{"$f":"IF(OR($C12=$P$12,$C12=$P$13,$C12=$P$14),2,+IF($C12=$P$15,0.75))","v":2},2,2,2,2,2,2,2,2,null,null,1,null,"Healthcare Hospitals(Acute, Specialist, Teaching, Mental health)",null,null,null,null,null,"MOD site",null,null,null,null,null,15,4,0,null,null,null,null,null,null,null,"Alle boliger","Fengsel, militær område",null,null,null,"Valg",{"$f":"scope","v":3}]
[null,"Walk time",{"$f":"$C$13/80","v":12.487500000000001},{"$f":"$C$13/80","v":12.487500000000001},12.487500000000001,12.487500000000001,12.487500000000001,12.487500000000001,12.487500000000001,12.487500000000001,12.487500000000001,{"$f":"$C$13/80","v":12.487500000000001},null,null,1,null,"Healthcare  GP surgery, Health centre, Community hospital",null,null,null,null,null,"Transport hub",null,null,null,null,null,16,5,0,null,null,null,null,null,null,null,"avstand mindre enn","avstand mindre enn","Valgt"]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C15)),\"\",0.5*(60/C15))","v":3},{"$f":"IF(ISERROR(0.5*(60/D15)),\"\",0.5*(60/D15))","v":""},"","","","","","","","",null,null,1,null,"Rural location sensitive buildings",null,null,null,null,null,"Retail",null,null,null,null,null,17,2,0,null,null,null,null,null,null,"Buss, trikk T bane",650,1000,{"$f":"IF(OR(AS16=AS14,AS16=AS15),AN18,AM18)","v":650},"m"]
[null,"Average waiting time",{"$f":"IF(ISERROR(C18+C16),\"\",(C18+C16))","v":5},{"$f":"IF(ISERROR(D18+D16),\"\",(D18+D16))","v":""},"","","","","","","","",null,null,1,null,"Other building type 3",null,null,null,null,null,"Law Court",null,null,null,null,null,18,2,0,null,null,null,null,null,null,"Tog",1000,1000,{"$f":"IF(OR(AS16=AS14,AS16=AS15),AN19,AM19)","v":1000},"m"]
[null,"Total access time",{"$f":"IFERROR(IF($C13>=VLOOKUP($C12,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C17+C19),\"\",(C17+C19))),\"\")","v":0},{"$f":"IFERROR(IF($C13>=VLOOKUP($C12,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D17+D19),\"\",(D17+D19))),\"\")","v":0},0,0,0,0,0,0,0,0,null,null,1,null,"Prison site",null,null,null,null,null,"Other building type 1",null,null,null,null,null,19,1,0]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$13=\"\",0,IF(ISERROR(30/C20),0,(30/C20)))","v":0},{"$f":"IF($C$13=\"\",0,IF(ISERROR(30/D20),0,(30/D20)))","v":0},0,0,0,0,0,0,0,0,null,null,1,null,"MOD site",null,null,null,null,null,"Other building type 2",null,null,null,null,null,20,2,0,null,null,null,null,null,null,1,2,3,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=1,0,1))","v":0},null,"Transport hub",null,null,null,null,null,"Other building type 3",null,null,null,null,null,21,4,0,null,null,null,null,null,null,"Bus",null,null,{"$f":"AO18","v":650},"m"]
[null,"NODE 2",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=2,0,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE3:AE22)","v":1},null,null,null,null,null,null,"Tram",null,null,{"$f":"AO22","v":650},"m"]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=2,0,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Metro",null,null,{"$f":"AO23","v":650},"m"]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=2,0,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rail",null,null,{"$f":"AO19","v":1000},"m"]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=2,0,1))","v":1}]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=2,0,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C13>=VLOOKUP($C12,$AL$22:$AP$25,$AO$21,FALSE),0,1)","v":0}]
[null,"Reliability factor",{"$f":"IF(OR($C24=$P$12,$C24=$P$13,$C24=$P$14),2,+IF($C24=$P$15,0.75))","v":false},{"$f":"IF(OR($C24=$P$12,$C24=$P$13,$C24=$P$14),2,+IF($C24=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,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,{"$f":"VLOOKUP($C12,$AL$22:$AP$25,$AO$21,FALSE)","v":650}]
[null,"Walk time",{"$f":"$C$25/80","v":0},{"$f":"$C$25/80","v":0},0,0,0,0,0,0,0,{"$f":"$C$25/80","v":0},null,null,1]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C27)),\"\",0.5*(60/C27))","v":""},{"$f":"IF(ISERROR(0.5*(60/D27)),\"\",0.5*(60/D27))","v":""},"","","","","","","","",null,null,1,null,"Number of nodes required (select):"]
[null,"Average waiting time",{"$f":"IF(ISERROR(C30+C28),\"\",C30+C28)","v":""},{"$f":"IF(ISERROR(D30+D28),\"\",D30+D28)","v":""},"","","","","","","","",null,null,1,1]
[null,"Total access time",{"$f":"IFERROR(IF($C25>=VLOOKUP($C24,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C29+C31),\"\",(C29+C31))),\"\")","v":""},{"$f":"IFERROR(IF($C25>=VLOOKUP($C24,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D29+D31),\"\",(D29+D31))),\"\")","v":""},{"$f":"IFERROR(IF($C25>=VLOOKUP($C24,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(E29+E31),\"\",(E29+E31))),\"\")","v":""},{"$f":"IFERROR(IF($C25>=VLOOKUP($C24,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(F29+F31),\"\",(F29+F31))),\"\")","v":""},{"$f":"IFERROR(IF($C25>=VLOOKUP($C24,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(G29+G31),\"\",(G29+G31))),\"\")","v":""},{"$f":"IFERROR(IF($C25>=VLOOKUP($C24,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(H29+H31),\"\",(H29+H31))),\"\")","v":""},{"$f":"IFERROR(IF($C25>=VLOOKUP($C24,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(I29+I31),\"\",(I29+I31))),\"\")","v":""},{"$f":"IFERROR(IF($C25>=VLOOKUP($C24,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(J29+J31),\"\",(J29+J31))),\"\")","v":""},{"$f":"IFERROR(IF($C25>=VLOOKUP($C24,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(K29+K31),\"\",(K29+K31))),\"\")","v":""},{"$f":"IFERROR(IF($C25>=VLOOKUP($C24,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(L29+L31),\"\",(L29+L31))),\"\")","v":""},null,null,1,2]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$25=\"\",0,IF(ISERROR(30/C32),0,(30/C32)))","v":0},{"$f":"IF($C$25=\"\",0,IF(ISERROR(30/D32),0,(30/D32)))","v":0},0,0,0,0,0,0,0,0,null,null,1,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=2,0,1))","v":1},4]
[null,"NODE 3",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=3,0,1))","v":1},5]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=3,0,1))","v":1},6]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=3,0,1))","v":1},7]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=3,0,1))","v":1},8]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=3,0,1))","v":1},9]
[null,"Reliability factor",{"$f":"IF(OR($C36=$P$12,$C36=$P$13,$C36=$P$14),2,+IF($C36=$P$15,0.75))","v":false},{"$f":"IF(OR($C36=$P$12,$C36=$P$13,$C36=$P$14),2,+IF($C36=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,null,null,1,10]
[null,"Walk time",{"$f":"$C$37/80","v":0},{"$f":"$C$37/80","v":0},0,0,0,0,0,0,0,{"$f":"$C$37/80","v":0},null,null,1,11]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C39)),\"\",0.5*(60/C39))","v":""},{"$f":"IF(ISERROR(0.5*(60/D39)),\"\",0.5*(60/D39))","v":""},"","","","","","","","",null,null,1,12]
[null,"Average waiting time",{"$f":"IF(ISERROR(C42+C40),\"\",C42+C40)","v":""},{"$f":"IF(ISERROR(D42+D40),\"\",D42+D40)","v":""},"","","","","","","","",null,null,1,13]
[null,"Total access time",{"$f":"IFERROR(IF($C37>=VLOOKUP($C36,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C41+C43),\"\",(C41+C43))),\"\")","v":""},{"$f":"IFERROR(IF($C37>=VLOOKUP($C36,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D41+D43),\"\",(D41+D43))),\"\")","v":""},{"$f":"IFERROR(IF($C37>=VLOOKUP($C36,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(E41+E43),\"\",(E41+E43))),\"\")","v":""},{"$f":"IFERROR(IF($C37>=VLOOKUP($C36,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(F41+F43),\"\",(F41+F43))),\"\")","v":""},{"$f":"IFERROR(IF($C37>=VLOOKUP($C36,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(G41+G43),\"\",(G41+G43))),\"\")","v":""},{"$f":"IFERROR(IF($C37>=VLOOKUP($C36,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(H41+H43),\"\",(H41+H43))),\"\")","v":""},{"$f":"IFERROR(IF($C37>=VLOOKUP($C36,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(I41+I43),\"\",(I41+I43))),\"\")","v":""},{"$f":"IFERROR(IF($C37>=VLOOKUP($C36,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(J41+J43),\"\",(J41+J43))),\"\")","v":""},{"$f":"IFERROR(IF($C37>=VLOOKUP($C36,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(K41+K43),\"\",(K41+K43))),\"\")","v":""},{"$f":"IFERROR(IF($C37>=VLOOKUP($C36,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(L41+L43),\"\",(L41+L43))),\"\")","v":""},null,null,1,14]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$37=\"\",0,IF(ISERROR(30/C44),0,(30/C44)))","v":0},{"$f":"IF($C$37=\"\",0,IF(ISERROR(30/D44),0,(30/D44)))","v":0},0,0,0,0,0,0,0,0,null,null,1,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=3,0,1))","v":1},16]
[null,"NODE 4",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=4,0,1))","v":1},17]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=4,0,1))","v":1},18]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=4,0,1))","v":1},19]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=4,0,1))","v":1},20]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=4,0,1))","v":1},"Building in Greater London"]
[null,"Reliability factor",{"$f":"IF(OR($C48=$P$12,$C48=$P$13,$C48=$P$14),2,+IF($C48=$P$15,0.75))","v":false},{"$f":"IF(OR($C48=$P$12,$C48=$P$13,$C48=$P$14),2,+IF($C48=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,null,null,1,"Is a bus service available:"]
[null,"Walk time",{"$f":"$C$49/80","v":0},{"$f":"$C$49/80","v":0},0,0,0,0,0,0,0,{"$f":"$C$49/80","v":0},null,null,1,"Yes"]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C51)),\"\",0.5*(60/C51))","v":""},{"$f":"IF(ISERROR(0.5*(60/D51)),\"\",0.5*(60/D51))","v":""},"","","","","","","","",null,null,1,"No"]
[null,"Average waiting time",{"$f":"IF(ISERROR(C54+C52),\"\",C54+C52)","v":""},{"$f":"IF(ISERROR(D54+D52),\"\",D54+D52)","v":""},"","","","","","","","",null,null,1]
[null,"Total access time",{"$f":"IFERROR(IF($C49>=VLOOKUP($C48,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C53+C55),\"\",(C53+C55))),\"\")","v":""},{"$f":"IFERROR(IF($C49>=VLOOKUP($C48,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D53+D55),\"\",(D53+D55))),\"\")","v":""},{"$f":"IFERROR(IF($C49>=VLOOKUP($C48,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(E53+E55),\"\",(E53+E55))),\"\")","v":""},{"$f":"IFERROR(IF($C49>=VLOOKUP($C48,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(F53+F55),\"\",(F53+F55))),\"\")","v":""},{"$f":"IFERROR(IF($C49>=VLOOKUP($C48,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(G53+G55),\"\",(G53+G55))),\"\")","v":""},{"$f":"IFERROR(IF($C49>=VLOOKUP($C48,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(H53+H55),\"\",(H53+H55))),\"\")","v":""},{"$f":"IFERROR(IF($C49>=VLOOKUP($C48,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(I53+I55),\"\",(I53+I55))),\"\")","v":""},{"$f":"IFERROR(IF($C49>=VLOOKUP($C48,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(J53+J55),\"\",(J53+J55))),\"\")","v":""},{"$f":"IFERROR(IF($C49>=VLOOKUP($C48,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(K53+K55),\"\",(K53+K55))),\"\")","v":""},{"$f":"IFERROR(IF($C49>=VLOOKUP($C48,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(L53+L55),\"\",(L53+L55))),\"\")","v":""},null,null,1,"Is there a taxi drop off point:"]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$49=\"\",0,IF(ISERROR(30/C56),0,(30/C56)))","v":0},{"$f":"IF($C$49=\"\",0,IF(ISERROR(30/D56),0,(30/D56)))","v":0},0,0,0,0,0,0,0,0,null,null,1,"Yes "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=4,0,1))","v":1},"No"]
[null,"NODE 5",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=5,0,1))","v":1}]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=5,0,1))","v":1}]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=5,0,1))","v":1}]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=5,0,1))","v":1}]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=5,0,1))","v":1}]
[null,"Reliability factor",{"$f":"IF(OR($C60=$P$12,$C60=$P$13,$C60=$P$14),2,+IF($C60=$P$15,0.75))","v":false},{"$f":"IF(OR($C60=$P$12,$C60=$P$13,$C60=$P$14),2,+IF($C60=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,null,null,1]
[null,"Walk time",{"$f":"$C$61/80","v":0},{"$f":"$C$61/80","v":0},0,0,0,0,0,0,0,{"$f":"$C$61/80","v":0},null,null,1]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C63)),\"\",0.5*(60/C63))","v":""},{"$f":"IF(ISERROR(0.5*(60/D63)),\"\",0.5*(60/D63))","v":""},"","","","","","","","",null,null,1]
[null,"Average waiting time",{"$f":"IF(ISERROR(C66+C64),\"\",C66+C64)","v":""},"","","","","","","","","",null,null,1]
[null,"Total access time",{"$f":"IFERROR(IF($C61>=VLOOKUP($C60,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C65+C67),\"\",(C65+C67))),\"\")","v":""},{"$f":"IFERROR(IF($C61>=VLOOKUP($C60,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D65+D67),\"\",(D65+D67))),\"\")","v":""},{"$f":"IFERROR(IF($C61>=VLOOKUP($C60,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(E65+E67),\"\",(E65+E67))),\"\")","v":""},{"$f":"IFERROR(IF($C61>=VLOOKUP($C60,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(F65+F67),\"\",(F65+F67))),\"\")","v":""},{"$f":"IFERROR(IF($C61>=VLOOKUP($C60,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(G65+G67),\"\",(G65+G67))),\"\")","v":""},{"$f":"IFERROR(IF($C61>=VLOOKUP($C60,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(H65+H67),\"\",(H65+H67))),\"\")","v":""},{"$f":"IFERROR(IF($C61>=VLOOKUP($C60,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(I65+I67),\"\",(I65+I67))),\"\")","v":""},{"$f":"IFERROR(IF($C61>=VLOOKUP($C60,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(J65+J67),\"\",(J65+J67))),\"\")","v":""},{"$f":"IFERROR(IF($C61>=VLOOKUP($C60,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(K65+K67),\"\",(K65+K67))),\"\")","v":""},{"$f":"IFERROR(IF($C61>=VLOOKUP($C60,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(L65+L67),\"\",(L65+L67))),\"\")","v":""},null,null,1]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$61=\"\",0,IF(ISERROR(30/C68),0,(30/C68)))","v":0},{"$f":"IF($C$61=\"\",0,IF(ISERROR(30/D68),0,(30/D68)))","v":0},0,0,0,0,0,0,0,0,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=5,0,1))","v":1}]
[null,"NODE 6",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=6,0,1))","v":1}]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=6,0,1))","v":1}]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=6,0,1))","v":1}]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=6,0,1))","v":1}]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=6,0,1))","v":1}]
[null,"Reliability factor",{"$f":"IF(OR($C72=$P$12,$C72=$P$13,$C72=$P$14),2,+IF($C72=$P$15,0.75))","v":false},{"$f":"IF(OR($C72=$P$12,$C72=$P$13,$C72=$P$14),2,+IF($C72=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,null,null,1]
[null,"Walk time",{"$f":"$C$73/80","v":0},{"$f":"$C$73/80","v":0},0,0,0,0,0,0,0,{"$f":"$C$73/80","v":0},null,null,1]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C75)),\"\",0.5*(60/C75))","v":""},{"$f":"IF(ISERROR(0.5*(60/D75)),\"\",0.5*(60/D75))","v":""},"","","","","","","","",null,null,1]
[null,"Average waiting time",{"$f":"IF(ISERROR(C78+C76),\"\",C78+C76)","v":""},"","","","","","","","","",null,null,1]
[null,"Total access time",{"$f":"IFERROR(IF($C73>=VLOOKUP($C72,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C77+C79),\"\",(C77+C79))),\"\")","v":""},{"$f":"IFERROR(IF($C73>=VLOOKUP($C72,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D77+D79),\"\",(D77+D79))),\"\")","v":""},{"$f":"IFERROR(IF($C73>=VLOOKUP($C72,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(E77+E79),\"\",(E77+E79))),\"\")","v":""},{"$f":"IFERROR(IF($C73>=VLOOKUP($C72,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(F77+F79),\"\",(F77+F79))),\"\")","v":""},{"$f":"IFERROR(IF($C73>=VLOOKUP($C72,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(G77+G79),\"\",(G77+G79))),\"\")","v":""},{"$f":"IFERROR(IF($C73>=VLOOKUP($C72,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(H77+H79),\"\",(H77+H79))),\"\")","v":""},{"$f":"IFERROR(IF($C73>=VLOOKUP($C72,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(I77+I79),\"\",(I77+I79))),\"\")","v":""},{"$f":"IFERROR(IF($C73>=VLOOKUP($C72,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(J77+J79),\"\",(J77+J79))),\"\")","v":""},{"$f":"IFERROR(IF($C73>=VLOOKUP($C72,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(K77+K79),\"\",(K77+K79))),\"\")","v":""},{"$f":"IFERROR(IF($C73>=VLOOKUP($C72,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(L77+L79),\"\",(L77+L79))),\"\")","v":""},null,null,1]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$73=\"\",0,IF(ISERROR(30/C80),0,(30/C80)))","v":0},{"$f":"IF($C$73=\"\",0,IF(ISERROR(30/D80),0,(30/D80)))","v":0},0,0,0,0,0,0,0,0,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=6,0,1))","v":1}]
[null,"NODE 7",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=7,0,1))","v":1}]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=7,0,1))","v":1}]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=7,0,1))","v":1}]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=7,0,1))","v":1}]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=7,0,1))","v":1}]
[null,"Reliability factor",{"$f":"IF(OR($C84=$P$12,$C84=$P$13,$C84=$P$14),2,+IF($C84=$P$15,0.75))","v":false},{"$f":"IF(OR($C84=$P$12,$C84=$P$13,$C84=$P$14),2,+IF($C84=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,null,null,1]
[null,"Walk time",{"$f":"$C$85/80","v":0},{"$f":"$C$85/80","v":0},0,0,0,0,0,0,0,{"$f":"$C$85/80","v":0},null,null,1]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C87)),\"\",0.5*(60/C87))","v":""},{"$f":"IF(ISERROR(0.5*(60/D87)),\"\",0.5*(60/D87))","v":""},"","","","","","","","",null,null,1]
[null,"Average waiting time",{"$f":"IF(ISERROR(C90+C88),\"\",C90+C88)","v":""},"","","","","","","","","",null,null,1]
[null,"Total access time",{"$f":"IFERROR(IF($C85>=VLOOKUP($C84,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C89+C91),\"\",(C89+C91))),\"\")","v":""},{"$f":"IFERROR(IF($C85>=VLOOKUP($C84,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D89+D91),\"\",(D89+D91))),\"\")","v":""},{"$f":"IFERROR(IF($C85>=VLOOKUP($C84,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(E89+E91),\"\",(E89+E91))),\"\")","v":""},{"$f":"IFERROR(IF($C85>=VLOOKUP($C84,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(F89+F91),\"\",(F89+F91))),\"\")","v":""},{"$f":"IFERROR(IF($C85>=VLOOKUP($C84,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(G89+G91),\"\",(G89+G91))),\"\")","v":""},{"$f":"IFERROR(IF($C85>=VLOOKUP($C84,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(H89+H91),\"\",(H89+H91))),\"\")","v":""},{"$f":"IFERROR(IF($C85>=VLOOKUP($C84,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(I89+I91),\"\",(I89+I91))),\"\")","v":""},{"$f":"IFERROR(IF($C85>=VLOOKUP($C84,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(J89+J91),\"\",(J89+J91))),\"\")","v":""},{"$f":"IFERROR(IF($C85>=VLOOKUP($C84,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(K89+K91),\"\",(K89+K91))),\"\")","v":""},{"$f":"IFERROR(IF($C85>=VLOOKUP($C84,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(L89+L91),\"\",(L89+L91))),\"\")","v":""},null,null,1]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$85=\"\",0,IF(ISERROR(30/C92),0,(30/C92)))","v":0},{"$f":"IF($C$85=\"\",0,IF(ISERROR(30/D92),0,(30/D92)))","v":0},0,0,0,0,0,0,0,0,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=7,0,1))","v":1}]
[null,"NODE 8",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=8,0,1))","v":1}]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=8,0,1))","v":1}]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=8,0,1))","v":1}]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=8,0,1))","v":1}]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=8,0,1))","v":1}]
[null,"Reliability factor",{"$f":"IF(OR($C96=$P$12,$C96=$P$13,$C96=$P$14),2,+IF($C96=$P$15,0.75))","v":false},{"$f":"IF(OR($C96=$P$12,$C96=$P$13,$C96=$P$14),2,+IF($C96=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,null,null,1]
[null,"Walk time",{"$f":"$C$97/80","v":0},{"$f":"$C$97/80","v":0},0,0,0,0,0,0,0,{"$f":"$C$97/80","v":0},null,null,1]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C99)),\"\",0.5*(60/C99))","v":""},{"$f":"IF(ISERROR(0.5*(60/D99)),\"\",0.5*(60/D99))","v":""},"","","","","","","","",null,null,1]
[null,"Average waiting time",{"$f":"IF(ISERROR(C102+C100),\"\",C102+C100)","v":""},"","","","","","","","","",null,null,1]
[null,"Total access time",{"$f":"IFERROR(IF($C97>=VLOOKUP($C96,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C101+C103),\"\",(C101+C103))),\"\")","v":""},{"$f":"IFERROR(IF($C97>=VLOOKUP($C96,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D101+D103),\"\",(D101+D103))),\"\")","v":""},{"$f":"IFERROR(IF($C97>=VLOOKUP($C96,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(E101+E103),\"\",(E101+E103))),\"\")","v":""},{"$f":"IFERROR(IF($C97>=VLOOKUP($C96,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(F101+F103),\"\",(F101+F103))),\"\")","v":""},{"$f":"IFERROR(IF($C97>=VLOOKUP($C96,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(G101+G103),\"\",(G101+G103))),\"\")","v":""},{"$f":"IFERROR(IF($C97>=VLOOKUP($C96,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(H101+H103),\"\",(H101+H103))),\"\")","v":""},{"$f":"IFERROR(IF($C97>=VLOOKUP($C96,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(I101+I103),\"\",(I101+I103))),\"\")","v":""},{"$f":"IFERROR(IF($C97>=VLOOKUP($C96,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(J101+J103),\"\",(J101+J103))),\"\")","v":""},{"$f":"IFERROR(IF($C97>=VLOOKUP($C96,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(K101+K103),\"\",(K101+K103))),\"\")","v":""},{"$f":"IFERROR(IF($C97>=VLOOKUP($C96,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(L101+L103),\"\",(L101+L103))),\"\")","v":""},null,null,1]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$97=\"\",0,IF(ISERROR(30/C104),0,(30/C104)))","v":0},{"$f":"IF($C$97=\"\",0,IF(ISERROR(30/D104),0,(30/D104)))","v":0},0,0,0,0,0,0,0,0,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=8,0,1))","v":1}]
[null,"NODE 9",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=9,0,1))","v":1}]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=9,0,1))","v":1}]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=9,0,1))","v":1}]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=9,0,1))","v":1}]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=9,0,1))","v":1}]
[null,"Reliability factor",{"$f":"IF(OR($C108=$P$12,$C108=$P$13,$C108=$P$14),2,+IF($C108=$P$15,0.75))","v":false},{"$f":"IF(OR($C108=$P$12,$C108=$P$13,$C108=$P$14),2,+IF($C108=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,null,null,1]
[null,"Walk time",{"$f":"$C$109/80","v":0},{"$f":"$C$109/80","v":0},0,0,0,0,0,0,0,{"$f":"$C$109/80","v":0},null,null,1]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C111)),\"\",0.5*(60/C111))","v":""},{"$f":"IF(ISERROR(0.5*(60/D111)),\"\",0.5*(60/D111))","v":""},"","","","","","","","",null,null,1]
[null,"Average waiting time",{"$f":"IF(ISERROR(C114+C112),\"\",C114+C112)","v":""},"","","","","","","","","",null,null,1]
[null,"Total access time",{"$f":"IFERROR(IF($C109>=VLOOKUP($C108,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C113+C115),\"\",(C113+C115))),\"\")","v":""},{"$f":"IFERROR(IF($C109>=VLOOKUP($C108,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D113+D115),\"\",(D113+D115))),\"\")","v":""},{"$f":"IFERROR(IF($C109>=VLOOKUP($C108,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(E113+E115),\"\",(E113+E115))),\"\")","v":""},{"$f":"IFERROR(IF($C109>=VLOOKUP($C108,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(F113+F115),\"\",(F113+F115))),\"\")","v":""},{"$f":"IFERROR(IF($C109>=VLOOKUP($C108,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(G113+G115),\"\",(G113+G115))),\"\")","v":""},{"$f":"IFERROR(IF($C109>=VLOOKUP($C108,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(H113+H115),\"\",(H113+H115))),\"\")","v":""},{"$f":"IFERROR(IF($C109>=VLOOKUP($C108,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(I113+I115),\"\",(I113+I115))),\"\")","v":""},{"$f":"IFERROR(IF($C109>=VLOOKUP($C108,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(J113+J115),\"\",(J113+J115))),\"\")","v":""},{"$f":"IFERROR(IF($C109>=VLOOKUP($C108,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(K113+K115),\"\",(K113+K115))),\"\")","v":""},{"$f":"IFERROR(IF($C109>=VLOOKUP($C108,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(L113+L115),\"\",(L113+L115))),\"\")","v":""},null,null,1]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$109=\"\",0,IF(ISERROR(30/C116),0,(30/C116)))","v":0},{"$f":"IF($C$109=\"\",0,IF(ISERROR(30/D116),0,(30/D116)))","v":0},0,0,0,0,0,0,0,0,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=9,0,1))","v":1}]
[null,"NODE 10",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=10,0,1))","v":1}]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=10,0,1))","v":1}]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=10,0,1))","v":1}]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=10,0,1))","v":1}]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=10,0,1))","v":1}]
[null,"Reliability factor",{"$f":"IF(OR($C120=$P$12,$C120=$P$13,$C120=$P$14),2,+IF($C120=$P$15,0.75))","v":false},{"$f":"IF(OR($C120=$P$12,$C120=$P$13,$C120=$P$14),2,+IF($C120=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,null,null,1]
[null,"Walk time",{"$f":"$C$121/80","v":0},{"$f":"$C$121/80","v":0},0,0,0,0,0,0,0,{"$f":"$C$121/80","v":0},null,null,1]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C123)),\"\",0.5*(60/C123))","v":""},{"$f":"IF(ISERROR(0.5*(60/D123)),\"\",0.5*(60/D123))","v":""},"","","","","","","","",null,null,1]
[null,"Average waiting time",{"$f":"IF(ISERROR(C126+C124),\"\",C126+C124)","v":""},"","","","","","","","","",null,null,1]
[null,"Total access time",{"$f":"IFERROR(IF($C121>=VLOOKUP($C120,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C125+C127),\"\",(C125+C127))),\"\")","v":""},{"$f":"IFERROR(IF($C121>=VLOOKUP($C120,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D125+D127),\"\",(D125+D127))),\"\")","v":""},{"$f":"IFERROR(IF($C121>=VLOOKUP($C120,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(E125+E127),\"\",(E125+E127))),\"\")","v":""},{"$f":"IFERROR(IF($C121>=VLOOKUP($C120,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(F125+F127),\"\",(F125+F127))),\"\")","v":""},{"$f":"IFERROR(IF($C121>=VLOOKUP($C120,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(G125+G127),\"\",(G125+G127))),\"\")","v":""},{"$f":"IFERROR(IF($C121>=VLOOKUP($C120,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(H125+H127),\"\",(H125+H127))),\"\")","v":""},{"$f":"IFERROR(IF($C121>=VLOOKUP($C120,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(I125+I127),\"\",(I125+I127))),\"\")","v":""},{"$f":"IFERROR(IF($C121>=VLOOKUP($C120,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(J125+J127),\"\",(J125+J127))),\"\")","v":""},{"$f":"IFERROR(IF($C121>=VLOOKUP($C120,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(K125+K127),\"\",(K125+K127))),\"\")","v":""},{"$f":"IFERROR(IF($C121>=VLOOKUP($C120,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(L125+L127),\"\",(L125+L127))),\"\")","v":""},null,null,1]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$121=\"\",0,IF(ISERROR(30/C128),0,(30/C128)))","v":0},{"$f":"IF($C$121=\"\",0,IF(ISERROR(30/D128),0,(30/D128)))","v":0},0,0,0,0,0,0,0,0,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=10,0,1))","v":1}]
[null,"NODE 11",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=11,0,1))","v":1}]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=11,0,1))","v":1}]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=11,0,1))","v":1}]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=11,0,1))","v":1}]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=11,0,1))","v":1}]
[null,"Reliability factor",{"$f":"IF(OR($C132=$P$12,$C132=$P$13,$C132=$P$14),2,+IF($C132=$P$15,0.75))","v":false},{"$f":"IF(OR($C132=$P$12,$C132=$P$13,$C132=$P$14),2,+IF($C132=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,null,null,1]
[null,"Walk time",{"$f":"$C$133/80","v":0},{"$f":"$C$133/80","v":0},0,0,0,0,0,0,0,{"$f":"$C$133/80","v":0},null,null,1]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C135)),\"\",0.5*(60/C135))","v":""},{"$f":"IF(ISERROR(0.5*(60/D135)),\"\",0.5*(60/D135))","v":""},"","","","","","","","",null,null,1]
[null,"Average waiting time",{"$f":"IF(ISERROR(C138+C136),\"\",C138+C136)","v":""},"","","","","","","","","",null,null,1]
[null,"Total access time",{"$f":"IFERROR(IF($C133>=VLOOKUP($C132,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C137+C139),\"\",(C137+C139))),\"\")","v":""},{"$f":"IFERROR(IF($C133>=VLOOKUP($C132,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D137+D139),\"\",(D137+D139))),\"\")","v":""},{"$f":"IFERROR(IF($C133>=VLOOKUP($C132,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(E137+E139),\"\",(E137+E139))),\"\")","v":""},{"$f":"IFERROR(IF($C133>=VLOOKUP($C132,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(F137+F139),\"\",(F137+F139))),\"\")","v":""},{"$f":"IFERROR(IF($C133>=VLOOKUP($C132,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(G137+G139),\"\",(G137+G139))),\"\")","v":""},{"$f":"IFERROR(IF($C133>=VLOOKUP($C132,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(H137+H139),\"\",(H137+H139))),\"\")","v":""},{"$f":"IFERROR(IF($C133>=VLOOKUP($C132,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(I137+I139),\"\",(I137+I139))),\"\")","v":""},{"$f":"IFERROR(IF($C133>=VLOOKUP($C132,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(J137+J139),\"\",(J137+J139))),\"\")","v":""},{"$f":"IFERROR(IF($C133>=VLOOKUP($C132,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(K137+K139),\"\",(K137+K139))),\"\")","v":""},{"$f":"IFERROR(IF($C133>=VLOOKUP($C132,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(L137+L139),\"\",(L137+L139))),\"\")","v":""},null,null,1]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$133=\"\",0,IF(ISERROR(30/C140),0,(30/C140)))","v":0},{"$f":"IF($C$133=\"\",0,IF(ISERROR(30/D140),0,(30/D140)))","v":0},0,0,0,0,0,0,0,0,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=11,0,1))","v":1}]
[null,"NODE 12",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=12,0,1))","v":1}]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=12,0,1))","v":1}]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=12,0,1))","v":1}]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=12,0,1))","v":1}]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=12,0,1))","v":1}]
[null,"Reliability factor",{"$f":"IF(OR($C144=$P$12,$C144=$P$13,$C144=$P$14),2,+IF($C144=$P$15,0.75))","v":false},{"$f":"IF(OR($C144=$P$12,$C144=$P$13,$C144=$P$14),2,+IF($C144=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,null,null,1]
[null,"Walk time",{"$f":"$C$145/80","v":0},{"$f":"$C$145/80","v":0},0,0,0,0,0,0,0,{"$f":"$C$145/80","v":0},null,null,1]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C147)),\"\",0.5*(60/C147))","v":""},{"$f":"IF(ISERROR(0.5*(60/D147)),\"\",0.5*(60/D147))","v":""},"","","","","","","","",null,null,1]
[null,"Average waiting time",{"$f":"IF(ISERROR(C150+C148),\"\",C150+C148)","v":""},"","","","","","","","","",null,null,1]
[null,"Total access time",{"$f":"IFERROR(IF($C145>=VLOOKUP($C144,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C149+C151),\"\",(C149+C151))),\"\")","v":""},{"$f":"IFERROR(IF($C145>=VLOOKUP($C144,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D149+D151),\"\",(D149+D151))),\"\")","v":""},{"$f":"IFERROR(IF($C145>=VLOOKUP($C144,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(E149+E151),\"\",(E149+E151))),\"\")","v":""},{"$f":"IFERROR(IF($C145>=VLOOKUP($C144,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(F149+F151),\"\",(F149+F151))),\"\")","v":""},{"$f":"IFERROR(IF($C145>=VLOOKUP($C144,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(G149+G151),\"\",(G149+G151))),\"\")","v":""},{"$f":"IFERROR(IF($C145>=VLOOKUP($C144,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(H149+H151),\"\",(H149+H151))),\"\")","v":""},{"$f":"IFERROR(IF($C145>=VLOOKUP($C144,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(I149+I151),\"\",(I149+I151))),\"\")","v":""},{"$f":"IFERROR(IF($C145>=VLOOKUP($C144,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(J149+J151),\"\",(J149+J151))),\"\")","v":""},{"$f":"IFERROR(IF($C145>=VLOOKUP($C144,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(K149+K151),\"\",(K149+K151))),\"\")","v":""},{"$f":"IFERROR(IF($C145>=VLOOKUP($C144,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(L149+L151),\"\",(L149+L151))),\"\")","v":""},null,null,1]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$145=\"\",0,IF(ISERROR(30/C152),0,(30/C152)))","v":0},{"$f":"IF($C$145=\"\",0,IF(ISERROR(30/D152),0,(30/D152)))","v":0},0,0,0,0,0,0,0,0,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=12,0,1))","v":1}]
[null,"NODE 13",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=13,0,1))","v":1}]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=13,0,1))","v":1}]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=13,0,1))","v":1}]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=13,0,1))","v":1}]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=13,0,1))","v":1}]
[null,"Reliability factor",{"$f":"IF(OR($C156=$P$12,$C156=$P$13,$C156=$P$14),2,+IF($C156=$P$15,0.75))","v":false},{"$f":"IF(OR($C156=$P$12,$C156=$P$13,$C156=$P$14),2,+IF($C156=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,null,null,1]
[null,"Walk time",{"$f":"$C$157/80","v":0},{"$f":"$C$157/80","v":0},0,0,0,0,0,0,0,{"$f":"$C$157/80","v":0},null,null,1]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C159)),\"\",0.5*(60/C159))","v":""},{"$f":"IF(ISERROR(0.5*(60/D159)),\"\",0.5*(60/D159))","v":""},"","","","","","","","",null,null,1]
[null,"Average waiting time",{"$f":"IF(ISERROR(C162+C160),\"\",C162+C160)","v":""},"","","","","","","","","",null,null,1]
[null,"Total access time",{"$f":"IFERROR(IF($C157>=VLOOKUP($C156,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C161+C163),\"\",(C161+C163))),\"\")","v":""},{"$f":"IFERROR(IF($C157>=VLOOKUP($C156,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D161+D163),\"\",(D161+D163))),\"\")","v":""},{"$f":"IFERROR(IF($C157>=VLOOKUP($C156,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(E161+E163),\"\",(E161+E163))),\"\")","v":""},{"$f":"IFERROR(IF($C157>=VLOOKUP($C156,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(F161+F163),\"\",(F161+F163))),\"\")","v":""},{"$f":"IFERROR(IF($C157>=VLOOKUP($C156,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(G161+G163),\"\",(G161+G163))),\"\")","v":""},{"$f":"IFERROR(IF($C157>=VLOOKUP($C156,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(H161+H163),\"\",(H161+H163))),\"\")","v":""},{"$f":"IFERROR(IF($C157>=VLOOKUP($C156,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(I161+I163),\"\",(I161+I163))),\"\")","v":""},{"$f":"IFERROR(IF($C157>=VLOOKUP($C156,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(J161+J163),\"\",(J161+J163))),\"\")","v":""},{"$f":"IFERROR(IF($C157>=VLOOKUP($C156,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(K161+K163),\"\",(K161+K163))),\"\")","v":""},{"$f":"IFERROR(IF($C157>=VLOOKUP($C156,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(L161+L163),\"\",(L161+L163))),\"\")","v":""},null,null,1]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$157=\"\",0,IF(ISERROR(30/C164),0,(30/C164)))","v":0},{"$f":"IF($C$157=\"\",0,IF(ISERROR(30/D164),0,(30/D164)))","v":0},0,0,0,0,0,0,0,0,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=13,0,1))","v":1}]
[null,"NODE 14",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=14,0,1))","v":1}]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=14,0,1))","v":1}]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=14,0,1))","v":1}]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=14,0,1))","v":1}]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=14,0,1))","v":1}]
[null,"Reliability factor",{"$f":"IF(OR($C168=$P$12,$C168=$P$13,$C168=$P$14),2,+IF($C168=$P$15,0.75))","v":false},{"$f":"IF(OR($C168=$P$12,$C168=$P$13,$C168=$P$14),2,+IF($C168=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,null,null,1]
[null,"Walk time",{"$f":"$C$169/80","v":0},{"$f":"$C$169/80","v":0},0,0,0,0,0,0,0,{"$f":"$C$169/80","v":0},null,null,1]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C171)),\"\",0.5*(60/C171))","v":""},{"$f":"IF(ISERROR(0.5*(60/D171)),\"\",0.5*(60/D171))","v":""},"","","","","","","","",null,null,1]
[null,"Average waiting time",{"$f":"IF(ISERROR(C174+C172),\"\",C174+C172)","v":""},"","","","","","","","","",null,null,1]
[null,"Total access time",{"$f":"IFERROR(IF($C169>=VLOOKUP($C168,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C173+C175),\"\",(C173+C175))),\"\")","v":""},{"$f":"IFERROR(IF($C169>=VLOOKUP($C168,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D173+D175),\"\",(D173+D175))),\"\")","v":""},{"$f":"IFERROR(IF($C169>=VLOOKUP($C168,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(E173+E175),\"\",(E173+E175))),\"\")","v":""},{"$f":"IFERROR(IF($C169>=VLOOKUP($C168,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(F173+F175),\"\",(F173+F175))),\"\")","v":""},{"$f":"IFERROR(IF($C169>=VLOOKUP($C168,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(G173+G175),\"\",(G173+G175))),\"\")","v":""},{"$f":"IFERROR(IF($C169>=VLOOKUP($C168,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(H173+H175),\"\",(H173+H175))),\"\")","v":""},{"$f":"IFERROR(IF($C169>=VLOOKUP($C168,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(I173+I175),\"\",(I173+I175))),\"\")","v":""},{"$f":"IFERROR(IF($C169>=VLOOKUP($C168,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(J173+J175),\"\",(J173+J175))),\"\")","v":""},{"$f":"IFERROR(IF($C169>=VLOOKUP($C168,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(K173+K175),\"\",(K173+K175))),\"\")","v":""},{"$f":"IFERROR(IF($C169>=VLOOKUP($C168,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(L173+L175),\"\",(L173+L175))),\"\")","v":""},null,null,1]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$169=\"\",0,IF(ISERROR(30/C176),0,(30/C176)))","v":0},{"$f":"IF($C$169=\"\",0,IF(ISERROR(30/D176),0,(30/D176)))","v":0},0,0,0,0,0,0,0,0,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=14,0,1))","v":1}]
[null,"NODE 15",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=15,0,1))","v":1}]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=15,0,1))","v":1}]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=15,0,1))","v":1}]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=15,0,1))","v":1}]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=15,0,1))","v":1}]
[null,"Reliability factor",{"$f":"IF(OR($C180=$P$12,$C180=$P$13,$C180=$P$14),2,+IF($C180=$P$15,0.75))","v":false},{"$f":"IF(OR($C180=$P$12,$C180=$P$13,$C180=$P$14),2,+IF($C180=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,null,null,1]
[null,"Walk time",{"$f":"$C$181/80","v":0},{"$f":"$C$181/80","v":0},0,0,0,0,0,0,0,{"$f":"$C$181/80","v":0},null,null,1]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C183)),\"\",0.5*(60/C183))","v":""},{"$f":"IF(ISERROR(0.5*(60/D183)),\"\",0.5*(60/D183))","v":""},"","","","","","","","",null,null,1]
[null,"Average waiting time",{"$f":"IF(ISERROR(C186+C184),\"\",C186+C184)","v":""},"","","","","","","","","",null,null,1]
[null,"Total access time",{"$f":"IFERROR(IF($C181>=VLOOKUP($C180,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C185+C187),\"\",(C185+C187))),\"\")","v":""},{"$f":"IFERROR(IF($C181>=VLOOKUP($C180,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D185+D187),\"\",(D185+D187))),\"\")","v":""},{"$f":"IFERROR(IF($C181>=VLOOKUP($C180,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(E185+E187),\"\",(E185+E187))),\"\")","v":""},{"$f":"IFERROR(IF($C181>=VLOOKUP($C180,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(F185+F187),\"\",(F185+F187))),\"\")","v":""},{"$f":"IFERROR(IF($C181>=VLOOKUP($C180,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(G185+G187),\"\",(G185+G187))),\"\")","v":""},{"$f":"IFERROR(IF($C181>=VLOOKUP($C180,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(H185+H187),\"\",(H185+H187))),\"\")","v":""},{"$f":"IFERROR(IF($C181>=VLOOKUP($C180,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(I185+I187),\"\",(I185+I187))),\"\")","v":""},{"$f":"IFERROR(IF($C181>=VLOOKUP($C180,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(J185+J187),\"\",(J185+J187))),\"\")","v":""},{"$f":"IFERROR(IF($C181>=VLOOKUP($C180,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(K185+K187),\"\",(K185+K187))),\"\")","v":""},{"$f":"IFERROR(IF($C181>=VLOOKUP($C180,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(L185+L187),\"\",(L185+L187))),\"\")","v":""},null,null,1]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$181=\"\",0,IF(ISERROR(30/C188),0,(30/C188)))","v":0},{"$f":"IF($C$181=\"\",0,IF(ISERROR(30/D188),0,(30/D188)))","v":0},0,0,0,0,0,0,0,0,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=15,0,1))","v":1}]
[null,"NODE 16",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=16,0,1))","v":1}]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=16,0,1))","v":1}]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=16,0,1))","v":1}]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=16,0,1))","v":1},null,"Business: Offices/Industrial, Multi Res, Other building type 1/Pre school, school,6th form",null,null,null,null,null,null,null,null,null,"Retail;Law court, FE, HE T1, HE T2/Health Care-Hospitals(Acute,spec,teaching,Mental health)",null,null,null,null,null,null,null,null,"Healthcare GP surgery, Health centre, Community hospital, HE T2"]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=16,0,1))","v":1}]
[null,"Reliability factor",{"$f":"IF(OR($C192=$P$12,$C192=$P$13,$C192=$P$14),2,+IF($C192=$P$15,0.75))","v":false},{"$f":"IF(OR($C192=$P$12,$C192=$P$13,$C192=$P$14),2,+IF($C192=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,null,null,1,null,2,1,null,null,null,null,null,null,null,null,2,1,null,null,null,null,null,null,null,null,2,1]
[null,"Walk time",{"$f":"$C$193/80","v":0},{"$f":"$C$193/80","v":0},0,0,0,0,0,0,0,{"$f":"$C$193/80","v":0},null,null,1,null,4,2,null,null,null,null,null,null,null,null,4,2,null,null,null,null,null,null,null,null,4,2]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C195)),\"\",0.5*(60/C195))","v":""},{"$f":"IF(ISERROR(0.5*(60/D195)),\"\",0.5*(60/D195))","v":""},"","","","","","","","",null,null,1,null,8,3,null,null,null,null,null,null,null,null,8,3,null,null,null,null,null,null,null,null,8,3]
[null,"Average waiting time",{"$f":"IF(ISERROR(C198+C196),\"\",C198+C196)","v":""},"","","","","","","","","",null,null,1,null,100,3,null,null,null,null,null,null,null,null,10,3,null,null,null,null,null,null,null,null,10,4]
[null,"Total access time",{"$f":"IFERROR(IF($C193>=VLOOKUP($C192,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C197+C199),\"\",(C197+C199))),\"\")","v":""},{"$f":"IFERROR(IF($C193>=VLOOKUP($C192,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D197+D199),\"\",(D197+D199))),\"\")","v":""},{"$f":"IFERROR(IF($C193>=VLOOKUP($C192,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(E197+E199),\"\",(E197+E199))),\"\")","v":""},{"$f":"IFERROR(IF($C193>=VLOOKUP($C192,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(F197+F199),\"\",(F197+F199))),\"\")","v":""},{"$f":"IFERROR(IF($C193>=VLOOKUP($C192,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(G197+G199),\"\",(G197+G199))),\"\")","v":""},{"$f":"IFERROR(IF($C193>=VLOOKUP($C192,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(H197+H199),\"\",(H197+H199))),\"\")","v":""},{"$f":"IFERROR(IF($C193>=VLOOKUP($C192,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(I197+I199),\"\",(I197+I199))),\"\")","v":""},{"$f":"IFERROR(IF($C193>=VLOOKUP($C192,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(J197+J199),\"\",(J197+J199))),\"\")","v":""},{"$f":"IFERROR(IF($C193>=VLOOKUP($C192,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(K197+K199),\"\",(K197+K199))),\"\")","v":""},{"$f":"IFERROR(IF($C193>=VLOOKUP($C192,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(L197+L199),\"\",(L197+L199))),\"\")","v":""},null,null,1,null,null,null,null,null,null,null,null,null,null,null,12,4,null,null,null,null,null,null,null,null,12,5]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$193=\"\",0,IF(ISERROR(30/C200),0,(30/C200)))","v":0},{"$f":"IF($C$193=\"\",0,IF(ISERROR(30/D200),0,(30/D200)))","v":0},0,0,0,0,0,0,0,0,null,null,1,null,null,null,null,null,null,null,null,null,null,null,18,5,null,null,null,null,null,null,null,null,100,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=16,0,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,100,5]
[null,"NODE 17",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=17,0,1))","v":1}]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=17,0,1))","v":1}]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=17,0,1))","v":1}]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=17,0,1))","v":1}]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=17,0,1))","v":1}]
[null,"Reliability factor",{"$f":"IF(OR($C204=$P$12,$C204=$P$13,$C204=$P$14),2,+IF($C204=$P$15,0.75))","v":false},{"$f":"IF(OR($C204=$P$12,$C204=$P$13,$C204=$P$14),2,+IF($C204=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,null,null,1]
[null,"Walk time",{"$f":"$C$205/80","v":0},{"$f":"$C$205/80","v":0},0,0,0,0,0,0,0,{"$f":"$C$205/80","v":0},null,null,1]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C207)),\"\",0.5*(60/C207))","v":""},{"$f":"IF(ISERROR(0.5*(60/D207)),\"\",0.5*(60/D207))","v":""},"","","","","","","","",null,null,1]
[null,"Average waiting time",{"$f":"IF(ISERROR(C210+C208),\"\",C210+C208)","v":""},"","","","","","","","","",null,null,1]
[null,"Total access time",{"$f":"IFERROR(IF($C205>=VLOOKUP($C204,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C209+C211),\"\",(C209+C211))),\"\")","v":""},{"$f":"IFERROR(IF($C205>=VLOOKUP($C204,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D209+D211),\"\",(D209+D211))),\"\")","v":""},{"$f":"IFERROR(IF($C205>=VLOOKUP($C204,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(E209+E211),\"\",(E209+E211))),\"\")","v":""},{"$f":"IFERROR(IF($C205>=VLOOKUP($C204,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(F209+F211),\"\",(F209+F211))),\"\")","v":""},{"$f":"IFERROR(IF($C205>=VLOOKUP($C204,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(G209+G211),\"\",(G209+G211))),\"\")","v":""},{"$f":"IFERROR(IF($C205>=VLOOKUP($C204,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(H209+H211),\"\",(H209+H211))),\"\")","v":""},{"$f":"IFERROR(IF($C205>=VLOOKUP($C204,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(I209+I211),\"\",(I209+I211))),\"\")","v":""},{"$f":"IFERROR(IF($C205>=VLOOKUP($C204,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(J209+J211),\"\",(J209+J211))),\"\")","v":""},{"$f":"IFERROR(IF($C205>=VLOOKUP($C204,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(K209+K211),\"\",(K209+K211))),\"\")","v":""},{"$f":"IFERROR(IF($C205>=VLOOKUP($C204,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(L209+L211),\"\",(L209+L211))),\"\")","v":""},null,null,1]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$205=\"\",0,IF(ISERROR(30/C212),0,(30/C212)))","v":0},{"$f":"IF($C$205=\"\",0,IF(ISERROR(30/D212),0,(30/D212)))","v":0},0,0,0,0,0,0,0,0,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=17,0,1))","v":1}]
[null,"NODE 18",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=18,0,1))","v":1}]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=18,0,1))","v":1}]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=18,0,1))","v":1}]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=18,0,1))","v":1}]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=18,0,1))","v":1}]
[null,"Reliability factor",{"$f":"IF(OR($C216=$P$12,$C216=$P$13,$C216=$P$14),2,+IF($C216=$P$15,0.75))","v":false},{"$f":"IF(OR($C216=$P$12,$C216=$P$13,$C216=$P$14),2,+IF($C216=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,null,null,1]
[null,"Walk time",{"$f":"$C$217/80","v":0},{"$f":"$C$217/80","v":0},0,0,0,0,0,0,0,0,null,null,1]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C219)),\"\",0.5*(60/C219))","v":""},{"$f":"IF(ISERROR(0.5*(60/D219)),\"\",0.5*(60/D219))","v":""},"","","","","","","","",null,null,1]
[null,"Average waiting time",{"$f":"IF(ISERROR(C222+C220),\"\",C222+C220)","v":""},"","","","","","","","","",null,null,1]
[null,"Total access time",{"$f":"IFERROR(IF($C217>=VLOOKUP($C216,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C221+C223),\"\",(C221+C223))),\"\")","v":""},{"$f":"IFERROR(IF($C217>=VLOOKUP($C216,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D221+D223),\"\",(D221+D223))),\"\")","v":""},{"$f":"IFERROR(IF($C217>=VLOOKUP($C216,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(E221+E223),\"\",(E221+E223))),\"\")","v":""},{"$f":"IFERROR(IF($C217>=VLOOKUP($C216,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(F221+F223),\"\",(F221+F223))),\"\")","v":""},{"$f":"IFERROR(IF($C217>=VLOOKUP($C216,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(G221+G223),\"\",(G221+G223))),\"\")","v":""},{"$f":"IFERROR(IF($C217>=VLOOKUP($C216,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(H221+H223),\"\",(H221+H223))),\"\")","v":""},{"$f":"IFERROR(IF($C217>=VLOOKUP($C216,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(I221+I223),\"\",(I221+I223))),\"\")","v":""},{"$f":"IFERROR(IF($C217>=VLOOKUP($C216,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(J221+J223),\"\",(J221+J223))),\"\")","v":""},{"$f":"IFERROR(IF($C217>=VLOOKUP($C216,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(K221+K223),\"\",(K221+K223))),\"\")","v":""},{"$f":"IFERROR(IF($C217>=VLOOKUP($C216,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(L221+L223),\"\",(L221+L223))),\"\")","v":""},null,null,1]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$217=\"\",0,IF(ISERROR(30/C224),0,(30/C224)))","v":0},{"$f":"IF($C$217=\"\",0,IF(ISERROR(30/D224),0,(30/D224)))","v":0},0,0,0,0,0,0,0,0,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=18,0,1))","v":1}]
[null,"NODE 19",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=19,0,1))","v":1}]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,1]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Reliability factor",{"$f":"IF(OR($C228=$P$12,$C228=$P$13,$C228=$P$14),2,+IF($C228=$P$15,0.75))","v":false},{"$f":"IF(OR($C228=$P$12,$C228=$P$13,$C228=$P$14),2,+IF($C228=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,null,null,1]
[null,"Walk time",{"$f":"$C$229/80","v":0},{"$f":"$C$229/80","v":0},0,0,0,0,0,0,0,{"$f":"$C$229/80","v":0},null,null,1]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C231)),\"\",0.5*(60/C231))","v":""},{"$f":"IF(ISERROR(0.5*(60/D231)),\"\",0.5*(60/D231))","v":""},"","","","","","","","",null,null,1]
[null,"Average waiting time",{"$f":"IF(ISERROR(C234+C232),\"\",C234+C232)","v":""},"","","","","","","","","",null,null,1]
[null,"Total access time",{"$f":"IFERROR(IF($C229>=VLOOKUP($C228,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C233+C235),\"\",(C233+C235))),\"\")","v":""},{"$f":"IFERROR(IF($C229>=VLOOKUP($C228,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D233+D235),\"\",(D233+D235))),\"\")","v":""},{"$f":"IFERROR(IF($C229>=VLOOKUP($C228,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(E233+E235),\"\",(E233+E235))),\"\")","v":""},{"$f":"IFERROR(IF($C229>=VLOOKUP($C228,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(F233+F235),\"\",(F233+F235))),\"\")","v":""},{"$f":"IFERROR(IF($C229>=VLOOKUP($C228,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(G233+G235),\"\",(G233+G235))),\"\")","v":""},{"$f":"IFERROR(IF($C229>=VLOOKUP($C228,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(H233+H235),\"\",(H233+H235))),\"\")","v":""},{"$f":"IFERROR(IF($C229>=VLOOKUP($C228,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(I233+I235),\"\",(I233+I235))),\"\")","v":""},{"$f":"IFERROR(IF($C229>=VLOOKUP($C228,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(J233+J235),\"\",(J233+J235))),\"\")","v":""},{"$f":"IFERROR(IF($C229>=VLOOKUP($C228,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(K233+K235),\"\",(K233+K235))),\"\")","v":""},{"$f":"IFERROR(IF($C229>=VLOOKUP($C228,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(L233+L235),\"\",(L233+L235))),\"\")","v":""},null,null,1]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$229=\"\",0,IF(ISERROR(30/C236),0,(30/C236)))","v":0},{"$f":"IF($C$229=\"\",0,IF(ISERROR(30/D236),0,(30/D236)))","v":0},0,0,0,0,0,0,0,0,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"NODE 20",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=20,0,1))","v":1}]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=20,0,1))","v":1}]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=20,0,1))","v":1}]
[null,null,"Service 1","Service 2","Service 3","Service 4","Service 5","Service 6","Service 7","Service 8","Service 9","Service 10",null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=20,0,1))","v":1}]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=20,0,1))","v":1}]
[null,"Reliability factor",{"$f":"IF(OR($C240=$P$12,$C240=$P$13,$C240=$P$14),2,+IF($C240=$P$15,0.75))","v":false},{"$f":"IF(OR($C240=$P$12,$C240=$P$13,$C240=$P$14),2,+IF($C240=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,null,null,1]
[null,"Walk time",{"$f":"$C$241/80","v":0},{"$f":"$C$241/80","v":0},0,0,0,0,0,0,0,{"$f":"$C$241/80","v":0},null,null,1]
[null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C243)),\"\",0.5*(60/C243))","v":""},{"$f":"IF(ISERROR(0.5*(60/D243)),\"\",0.5*(60/D243))","v":""},"","","","","","","","",null,null,1]
[null,"Average waiting time",{"$f":"IF(ISERROR(C246+C244),\"\",C246+C244)","v":""},"","","","","","","","","",null,null,1]
[null,"Total access time",{"$f":"IFERROR(IF($C241>=VLOOKUP($C240,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(C245+C247),\"\",(C245+C247))),\"\")","v":""},{"$f":"IFERROR(IF($C241>=VLOOKUP($C240,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(D245+D247),\"\",(D245+D247))),\"\")","v":""},{"$f":"IFERROR(IF($C241>=VLOOKUP($C240,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(E245+E247),\"\",(E245+E247))),\"\")","v":""},{"$f":"IFERROR(IF($C241>=VLOOKUP($C240,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(F245+F247),\"\",(F245+F247))),\"\")","v":""},{"$f":"IFERROR(IF($C241>=VLOOKUP($C240,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(G245+G247),\"\",(G245+G247))),\"\")","v":""},{"$f":"IFERROR(IF($C241>=VLOOKUP($C240,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(H245+H247),\"\",(H245+H247))),\"\")","v":""},{"$f":"IFERROR(IF($C241>=VLOOKUP($C240,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(I245+I247),\"\",(I245+I247))),\"\")","v":""},{"$f":"IFERROR(IF($C241>=VLOOKUP($C240,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(J245+J247),\"\",(J245+J247))),\"\")","v":""},{"$f":"IFERROR(IF($C241>=VLOOKUP($C240,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(K245+K247),\"\",(K245+K247))),\"\")","v":""},{"$f":"IFERROR(IF($C241>=VLOOKUP($C240,$AL$22:$AP$25,$AO$21,FALSE),0,IF(ISERROR(L245+L247),\"\",(L245+L247))),\"\")","v":""},null,null,1]
[null,"Equivalent doorstep frequency",{"$f":"IF($C$240=\"\",0,IF(ISERROR(30/C248),0,(30/C248)))","v":0},{"$f":"IF($C$240=\"\",0,IF(ISERROR(30/D248),0,(30/D248)))","v":0},0,0,0,0,0,0,0,0,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=20,0,1))","v":1}]
[]
[null,"RANK AND SUMMATION FOR BUS SERVICES ONLY",{"$f":"IF($C$12<>\"Rail\",C21,0)","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF($C$24<>\"Rail\",C33,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF($C$36<>\"Rail\",C45,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF($C$48<>\"Rail\",C57,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF($C$60<>\"Rail\",C69,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF($C$72<>\"Rail\",C81,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF($C$84<>\"Rail\",C93,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF($C$96<>\"Rail\",C105,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF($C$108<>\"Rail\",C117,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF($C$120<>\"Rail\",C129,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF($C$132<>\"Rail\",C141,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF($C$144<>\"Rail\",C153,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF($C$156<>\"Rail\",C165,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF($C$168<>\"Rail\",C177,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF($C$180<>\"Rail\",C189,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF($C$192<>\"Rail\",C201,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF($C$204<>\"Rail\",C213,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF($C$216<>\"Rail\",C225,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF($C$228<>\"Rail\",C237,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"IF($C$240<>\"Rail\",C249,0)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"RANK(C252,$C$252:$HN$252,0)","v":1},{"$f":"RANK(D252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1,1,1,null,null,{"$f":"RANK(O252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(Z252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(AK252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(AV252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(BG252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(BR252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(CC252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(CN252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(CY252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(DJ252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(DU252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(EF252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(EQ252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(FB252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(FM252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(FX252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(GI252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(GT252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(HE252,$C$252:$HN$252,0)","v":1},{"$f":"RANK(HF252,$C$252:$HN$252,0)","v":1},{"$f":"RANK(HG252,$C$252:$HN$252,0)","v":1},{"$f":"RANK(HH252,$C$252:$HN$252,0)","v":1},1,1,1,1,1,1]
[null,null,{"$f":"IF(C253=1,C252,C252/2)","v":0},{"$f":"IF(D253=1,D252,D252/2)","v":0},{"$f":"IF(E253=1,E252,E252/2)","v":0},0,0,0,0,0,0,0,null,null,{"$f":"IF(O253=1,O252,O252/2)","v":0},0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,{"$f":"IF(BW253=1,BW252,BW252/2)","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(CN253=1,CN252,CN252/2)","v":0},0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,{"$f":"IF(EO253=1,EO252,EO252/2)","v":0},null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,{"$f":"IF(HH253=1,HH252,HH252/2)","v":0},0,0,0,0,0,0]
[]
[null,"RANK 1 ELEMENTS",{"$f":"IF(C253=1,C254,0)","v":0},{"$f":"IF(D253=1,D254,0)","v":0},0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,{"$f":"IF(BW253=1,BW254,0)","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,{"$f":"IF(EO253=1,EO254,0)","v":0},null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,{"$f":"IF(HH253=1,HH254,0)","v":0},0,0,0,0,0,0]
[null,"RANK 1 ELEMENTS(O'S OMITTED)",{"$f":"IF(C253=1,C254,\"\")","v":0},{"$f":"IF(D253=1,D254,\"\")","v":0},0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,{"$f":"IF(BW253=1,BW254,\"\")","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,{"$f":"IF(EO253=1,EO254,\"\")","v":0},null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,{"$f":"IF(HH253=1,HH254,\"\")","v":0},0,0,0,0,0,0]
[null,"NON RANK 1 ELEMENTS",{"$f":"IF(NOT(C253=1),C254,0)","v":0},{"$f":"IF(NOT(D253=1),D254,0)","v":0},{"$f":"IF(NOT(E253=1),E254,0)","v":0},0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,{"$f":"IF(NOT(BW253=1),BW254,0)","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,{"$f":"IF(NOT(EO253=1),EO254,0)","v":0},null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,{"$f":"IF(NOT(HH253=1),HH254,0)","v":0},0,0,0,0,0,0]
[null,"COUNT OF RANK 1 ELEMENTS",{"$f":"COUNT(C257:HN257)","v":200}]
[null,"SUM ALL RANK1*0.5",{"$f":"(0.5*SUM(C256:HN256))","v":0}]
[null,"(SUM ALL RANK 1*0.5)/COUNT",{"$f":"C260/C259","v":0}]
[null,"A262+A263",{"$f":"C260+C261","v":0}]
[null,"Total EDF for selected transport mode",{"$f":"C262+SUM(C258:HN258)","v":0}]
[]
[null,"RANK AND SUMMATION FOR RAIL SERVICES ONLY",{"$f":"IF($C$12=\"Rail\",C21,0)","v":0},{"$f":"IF($C$12=\"Rail\",D21,0)","v":0},0,0,0,0,0,0,0,0,null,null,{"$f":"IF($C$24=\"Rail\",C33,0)","v":0},{"$f":"IF($C$24=\"Rail\",D33,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($C$36=\"Rail\",C45,0)","v":0},{"$f":"IF($C$36=\"Rail\",D45,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($C$48=\"Rail\",C57,0)","v":0},{"$f":"IF($C$48=\"Rail\",D57,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($C$60=\"Rail\",C69,0)","v":0},{"$f":"IF($C$60=\"Rail\",D69,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($C$72=\"Rail\",C81,0)","v":0},{"$f":"IF($C$72=\"Rail\",D81,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($C$84=\"Rail\",C93,0)","v":0},{"$f":"IF($C$84=\"Rail\",D93,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($C$96=\"Rail\",C105,0)","v":0},{"$f":"IF($C$96=\"Rail\",D105,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($C$108=\"Rail\",C117,0)","v":0},{"$f":"IF($C$108=\"Rail\",D117,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($C$120=\"Rail\",C129,0)","v":0},{"$f":"IF($C$120=\"Rail\",D129,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($C$132=\"Rail\",C141,0)","v":0},{"$f":"IF($C$132=\"Rail\",D141,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($C$144=\"Rail\",C153,0)","v":0},{"$f":"IF($C$144=\"Rail\",D153,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($C$156=\"Rail\",C165,0)","v":0},{"$f":"IF($C$156=\"Rail\",D165,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($C$168=\"Rail\",C177,0)","v":0},{"$f":"IF($C$168=\"Rail\",D177,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($C$180=\"Rail\",C189,0)","v":0},{"$f":"IF($C$180=\"Rail\",D189,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($C$192=\"Rail\",C201,0)","v":0},{"$f":"IF($C$192=\"Rail\",D201,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($C$204=\"Rail\",C213,0)","v":0},{"$f":"IF($C$204=\"Rail\",D213,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($C$216=\"Rail\",C225,0)","v":0},{"$f":"IF($C$216=\"Rail\",D225,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($C$228=\"Rail\",C237,0)","v":0},{"$f":"IF($C$228=\"Rail\",D237,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($C$240=\"Rail\",C249,0)","v":0},{"$f":"IF($C$240=\"Rail\",D249,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,{"$f":"RANK(C265,$C$265:$HN$265,0)","v":1},1,1,1,1,1,1,1,1,1,null,null,{"$f":"RANK(O265,$C$265:$HN$265,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(Z265,$C$265:$HN$265,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(AK265,$C$265:$HN$265,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(AV265,$C$265:$HN$265,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(BG265,$C$265:$HN$265,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(BR265,$C$265:$HN$265,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(CC265,$C$265:$HN$265,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(CN265,$C$265:$HN$265,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(CY265,$C$265:$HN$265,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(DJ265,$C$265:$HN$265,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(DU265,$C$265:$HN$265,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(EF265,$C$265:$HN$265,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(EQ265,$C$265:$HN$265,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(FB265,$C$265:$HN$265,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(FM265,$C$265:$HN$265,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(FX265,$C$265:$HN$265,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(GI265,$C$265:$HN$265,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(GT265,$C$265:$HN$265,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(HE265,$C$265:$HN$265,0)","v":1},{"$f":"RANK(HF265,$C$265:$HN$265,0)","v":1},{"$f":"RANK(HG265,$C$265:$HN$265,0)","v":1},{"$f":"RANK(HH265,$C$265:$HN$265,0)","v":1},{"$f":"RANK(HI265,$C$265:$HN$265,0)","v":1},1,1,1,1,1]
[null,null,{"$f":"IF(C266=1,C265,C265/2)","v":0},0,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,{"$f":"IF(AM266=1,AM265,AM265/2)","v":0},0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,{"$f":"IF(BV266=1,BV265,BV265/2)","v":0},0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,{"$f":"IF(DE266=1,DE265,DE265/2)","v":0},0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,{"$f":"IF(EN266=1,EN265,EN265/2)","v":0},0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(FX266=1,FX265,FX265/2)","v":0},0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,{"$f":"IF(HG266=1,HG265,HG265/2)","v":0},0,0,0,0,0,0,0]
[]
[null,"RANK 1 ELEMENTS",{"$f":"IF(C266=1,C267,0)","v":0},{"$f":"IF(D266=1,D267,0)","v":0},0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,{"$f":"IF(BW266=1,BW267,0)","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,{"$f":"IF(EO266=1,EO267,0)","v":0},null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,{"$f":"IF(HH266=1,HH267,0)","v":0},0,0,0,0,0,0]
[null,"RANK 1 ELEMENTS (O'S OMITTED)",{"$f":"IF(C266=1,C267,\"\")","v":0},{"$f":"IF(D266=1,D267,\"\")","v":0},0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,{"$f":"IF(BW266=1,BW267,\"\")","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,{"$f":"IF(EO266=1,EO267,\"\")","v":0},null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,{"$f":"IF(HH266=1,HH267,\"\")","v":0},0,0,0,0,0,0]
[null,"NON RANK 1 ELEMENTS",{"$f":"IF(NOT(C266=1),C267,0)","v":0},{"$f":"IF(NOT(D266=1),D267,0)","v":0},0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,{"$f":"IF(NOT(BW266=1),BW267,0)","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,{"$f":"IF(NOT(EO266=1),EO267,0)","v":0},null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,{"$f":"IF(NOT(HH266=1),HH267,0)","v":0},0,0,0,0,0,0]
[null,"COUNT OF RANK 1 ELEMENTS",{"$f":"COUNT(C270:HN270)","v":200}]
[null,"SUM ALL RANK 1 * 0.5",{"$f":"(0.5*SUM(C269:HN269))","v":0}]
[null,"(SUM ALL RANK 1 * 0.5)/COUNT",{"$f":"C273/C272","v":0}]
[null,"A275+A276",{"$f":"C273+C274","v":0}]
[null,"Total EDF for selected transport mode",{"$f":"C275+SUM(C271:HN271)","v":0}]
[]
[null,null,3]
[null,null,2,{"$f":"IF(scope1=1,+IF(Credits=0,1))","v":false}]
[null,null,1,{"$f":"IF(scope=7,IF(scope2=2,+IF(Credits=5,0,1),0))","v":false}]
[null,null,{"$f":"IF(nodeselection=21,credit(AIGreaterLondon,selectionvalue),credit(AINDX,selectionvalue))","v":0},"vlookup this cell"]
[null,null,1]
[]
[]
[null,"Accessibility Index",null,null,{"$f":"SUM(C263+C276)","v":0}]
[]
[null,"Tra01 total credits achieved  ",null,null,{"$f":"IF(scope1a=1,Credits+1,Credits)","v":0}]

{"sheet":"Schedule of changes","index":1,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,5,5,13]]}
[]
[null,"BREEAM-NOR v6.0 Tra 01 Accessibility Index Calculator"]
[]
[null,"Current Version",null,"Release date",null,"Description of changes/additions to previous version resulting in current version"]
[]
[null,44927,null,"2023-11-21",null,"Initial Release Version of BREEAM-NOR v6.1 New Construction Tra 01 Accessibility Index Calculator"]