{"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.0 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":1}]
[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,0]
[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",null,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)",null,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,"Average frequency per hour",null,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,"Reliability factor",{"$f":"IF(OR($C12=$P$12,$C12=$P$13,$C12=$P$14),2,+IF($C12=$P$15,0.75))","v":false},{"$f":"IF(OR($C12=$P$12,$C12=$P$13,$C12=$P$14),2,+IF($C12=$P$15,0.75))","v":false},false,false,false,false,false,false,false,false,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,"Walk time",{"$f":"$C$13/80","v":0},{"$f":"$C$13/80","v":0},0,0,0,0,0,0,0,{"$f":"$C$13/80","v":0},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,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/C15)),\"\",0.5*(60/C15))","v":""},{"$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,"Average waiting time",{"$f":"IF(ISERROR(C18+C16),\"\",(C18+C16))","v":""},{"$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,"Total access time",{"$f":"IF(ISERROR(C17+C19),\"\",(C17+C19))","v":""},{"$f":"IF(ISERROR(D17+D19),\"\",(D17+D19))","v":""},"","","","","","","","",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,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,"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":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE3:AE22)","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>=2,0,1))","v":0}]
[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":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,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=2,0,1))","v":0}]
[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":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,"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":"IF(ISERROR(C29+C31),\"\",C29+C31)","v":""},{"$f":"IF(ISERROR(D29+D31),\"\",D29+D31)","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":0},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":0},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":0},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":0},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":0},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":0},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":"IF(ISERROR(C41+C43),\"\",C41+C43)","v":""},{"$f":"IF(ISERROR(D41+D43),\"\",D41+D43)","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":0},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":0},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":0},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":0},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":0},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":0},"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":"IF(ISERROR(C53+C55),\"\",C53+C55)","v":""},{"$f":"IF(ISERROR(D53+D55),\"\",D53+D55)","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":0},"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":0}]
[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":0}]
[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":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,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=5,0,1))","v":0}]
[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":0}]
[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":"IF(ISERROR(C65+C67),\"\",C65+C67)","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":0}]
[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":0}]
[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":0}]
[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":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,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=6,0,1))","v":0}]
[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":0}]
[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":"IF(ISERROR(C77+C79),\"\",C77+C79)","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":0}]
[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":0}]
[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":0}]
[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":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,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=7,0,1))","v":0}]
[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":0}]
[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":"IF(ISERROR(C89+C91),\"\",C89+C91)","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":0}]
[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":0}]
[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":0}]
[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":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,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=8,0,1))","v":0}]
[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":0}]
[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":"IF(ISERROR(C101+C103),\"\",C101+C103)","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":0}]
[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":0}]
[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":0}]
[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":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,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=9,0,1))","v":0}]
[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":0}]
[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":"IF(ISERROR(C113+C115),\"\",C113+C115)","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":0}]
[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":0}]
[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":0}]
[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":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,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=10,0,1))","v":0}]
[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":0}]
[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":"IF(ISERROR(C125+C127),\"\",C125+C127)","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":0}]
[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":0}]
[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":0}]
[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":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,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=11,0,1))","v":0}]
[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":0}]
[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":"IF(ISERROR(C137+C139),\"\",C137+C139)","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":0}]
[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":0}]
[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":0}]
[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":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,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=12,0,1))","v":0}]
[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":0}]
[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":"IF(ISERROR(C149+C151),\"\",C149+C151)","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":0}]
[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":0}]
[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":0}]
[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":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,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=13,0,1))","v":0}]
[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":0}]
[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":"IF(ISERROR(C161+C163),\"\",C161+C163)","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":0}]
[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":0}]
[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":0}]
[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":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,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=14,0,1))","v":0}]
[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":0}]
[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":"IF(ISERROR(C173+C175),\"\",C173+C175)","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":0}]
[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":0}]
[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":0}]
[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":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,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=15,0,1))","v":0}]
[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":0}]
[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":"IF(ISERROR(C185+C187),\"\",C185+C187)","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":0}]
[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":0}]
[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":0}]
[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":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,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=16,0,1))","v":0},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":0}]
[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":"IF(ISERROR(C197+C199),\"\",C197+C199)","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":0},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":0}]
[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":0}]
[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":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,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=17,0,1))","v":0}]
[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":0}]
[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":"IF(ISERROR(C209+C211),\"\",C209+C211)","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":0}]
[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":0}]
[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":0}]
[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":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,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=18,0,1))","v":0}]
[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":0}]
[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":"IF(ISERROR(C221+C223),\"\",C221+C223)","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":0}]
[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":0}]
[null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,0]
[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":"IF(ISERROR(C233+C235),\"\",C233+C235)","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,0]
[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":0}]
[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":0}]
[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":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,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=20,0,1))","v":0}]
[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":0}]
[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":"IF(ISERROR(C245+C247),\"\",C245+C247)","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":0}]
[]
[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},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,2]
[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,20]
[]
[]
[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":8,"n_cols":6,"rows_kept":8,"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,1,null,"2022-02-22",null,"Release version. Based on BREEAM_UK_NC_2018_Tra01_02_AI_v2.0 (14.09.2018)"]
[]
[null,"Previous Version",null,"Release date"]