{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tra01 - Public transport access","Schedule of changes"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":26,"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 - Public transport access","index":0,"n_rows":286,"n_cols":223,"rows_kept":286,"cut":false,"hidden":false,"merged":[[4,10,4,11],[285,2,285,4],[283,2,283,4],[204,27,204,28]]}
[]
[null,null,"BREEAM International 2016 Tra 01 Public transport accessibility 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,null,"Offices/Industrial",null,null,null,null,null,"Offices, Industrial, Long term residential institutions, Other building - Staffed, Pre-school, School",null,null,null,null,null,2,1,{"$f":"IF(scope=AD3,AE3,0)","v":0}]
[null,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,"Higher education - On campus",null,null,null,null,null,3,3,0]
[null,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,"Retail, Higher education - Off campus, Hotels and short term residential institutions, Other building - Visitors",null,null,null,null,null,4,2,0]
[null,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,"Residential dwellings",null,null,null,null,null,5,5,0]
[null,null,"Dedicated bus service:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"School",null,null,null,null,null,"Rural location sensitive buildings, Other buildings - Rural",null,null,null,null,null,6,4,0]
[null,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,null,null,null,null,null,null,7,2,0]
[null,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,8,2,0]
[null,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,9,3,0]
[null,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,10,2,0]
[{"$f":"IF(D11=$Q$11,650,1000)","v":1000},null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,0,"Rail","Higher Education type 1",null,null,null,null,null,"Healthcare  GP surgery, Health centre, Community hospital",null,null,null,null,null,11,3,0]
[null,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,"Other building type 2",null,null,null,null,null,"Type 4 & 5",null,null,null,null,null,12,4,0]
[null,null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Higher education type 2",null,null,null,null,null,"Prison site",null,null,null,null,null,13,4,0]
[null,null,"Reliability factor",{"$f":"IF($D$11=\"Bus\",2,+IF($D$11=\"rail\",0.75))","v":false},{"$f":"IF($D$11=\"Bus\",2,+IF($D$11=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,{"$f":"IF($D$11=\"Bus\",2,+IF($D$11=\"rail\",0.75))","v":false},null,null,1,null,"Healthcare Hospitals(Acute, Specialist, Teaching, Mental health)",null,null,null,null,null,"MOD site",null,null,null,null,null,14,4,0]
[null,null,"Walk time",{"$f":"$D$12/80","v":0},{"$f":"$D$12/80","v":0},0,0,0,0,0,0,0,{"$f":"$D$12/80","v":0},null,null,1,null,"Healthcare  GP surgery, Health centre, Community hospital",null,null,null,null,null,"Type 7",null,null,null,null,null,15,5,0]
[null,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D14)),\"\",0.5*(60/D14))","v":""},"","","","","","","","","",null,null,1,null,"Rural location sensitive buildings",null,null,null,null,null,"Type 3",null,null,null,null,null,16,2,0]
[null,null,"Average waiting time",{"$f":"IF(ISERROR(D17+D15),\"\",(D17+D15))","v":""},"","","","","","","","","",null,null,1,null,"Other building type 3",null,null,null,null,null,"Law Court",null,null,null,null,null,17,2,0]
[null,null,"Total access time",{"$f":"IF(ISERROR(D16+D18),\"\",(D16+D18))","v":""},{"$f":"IF(ISERROR(E16+E18),\"\",(E16+E18))","v":""},"","","","","","","","",null,null,1,null,"Prison site",null,null,null,null,null,"Other building type 1",null,null,null,null,null,18,1,0]
[null,null,"Equivalent doorstep frequency",{"$f":"IF($D$12=\"\",0,IF(ISERROR(30/D19),0,(30/D19)))","v":0},{"$f":"IF($D$12=\"\",0,IF(ISERROR(30/E19),0,(30/E19)))","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,19,2,0]
[null,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,20,4,0]
[null,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(AF3:AF21)","v":0}]
[null,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}]
[{"$f":"IF(D23=$Q$11,650,1000)","v":1000},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,"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,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,"Reliability factor",{"$f":"IF($D$23=\"Bus\",2,+IF($D$23=\"rail\",0.75))","v":false},{"$f":"IF($D$23=\"Bus\",2,+IF($D$23=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,{"$f":"IF($D$23=\"Bus\",2,+IF($D$23=\"rail\",0.75))","v":false},null,null,1]
[null,null,"Walk time",{"$f":"$D$24/80","v":0},{"$f":"$D$24/80","v":0},0,0,0,0,0,0,0,{"$f":"$D$24/80","v":0},null,null,1]
[null,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D26)),\"\",0.5*(60/D26))","v":""},{"$f":"IF(ISERROR(0.5*(60/E26)),\"\",0.5*(60/E26))","v":""},"","","","","","","","",null,null,1,null,"Number of nodes required (select):"]
[null,null,"Average waiting time",{"$f":"IF(ISERROR(D29+D27),\"\",D29+D27)","v":""},{"$f":"IF(ISERROR(E29+E27),\"\",E29+E27)","v":""},"","","","","","","","",null,null,1,1]
[null,null,"Total access time",{"$f":"IF(ISERROR(D28+D30),\"\",D28+D30)","v":""},{"$f":"IF(ISERROR(E28+E30),\"\",E28+E30)","v":""},"","","","","","","","",null,null,1,2]
[null,null,"Equivalent doorstep frequency",{"$f":"IF($D$24=\"\",0,IF(ISERROR(30/D31),0,(30/D31)))","v":0},{"$f":"IF($D$24=\"\",0,IF(ISERROR(30/E31),0,(30/E31)))","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,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=2,0,1))","v":1},4]
[null,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,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]
[{"$f":"IF(D35=$Q$11,650,1000)","v":1000},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,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,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,null,"Reliability factor",{"$f":"IF($D$35=\"Bus\",2,+IF($D$35=\"rail\",0.75))","v":false},{"$f":"IF($D$35=\"Bus\",2,+IF($D$35=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,{"$f":"IF($D$35=\"Bus\",2,+IF($D$35=\"rail\",0.75))","v":false},null,null,1,10]
[null,null,"Walk time",{"$f":"$D$36/80","v":0},{"$f":"$D$36/80","v":0},0,0,0,0,0,0,0,{"$f":"$D$36/80","v":0},null,null,1,11]
[null,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D38)),\"\",0.5*(60/D38))","v":""},{"$f":"IF(ISERROR(0.5*(60/E38)),\"\",0.5*(60/E38))","v":""},"","","","","","","","",null,null,1,12]
[null,null,"Average waiting time",{"$f":"IF(ISERROR(D41+D39),\"\",D41+D39)","v":""},{"$f":"IF(ISERROR(E41+E39),\"\",E41+E39)","v":""},"","","","","","","","",null,null,1,13]
[null,null,"Total access time",{"$f":"IF(ISERROR(D40+D42),\"\",D40+D42)","v":""},{"$f":"IF(ISERROR(E40+E42),\"\",E40+E42)","v":""},"","","","","","","","",null,null,1,14]
[null,null,"Equivalent doorstep frequency",{"$f":"IF($D$36=\"\",0,IF(ISERROR(30/D43),0,(30/D43)))","v":0},{"$f":"IF($D$36=\"\",0,IF(ISERROR(30/E43),0,(30/E43)))","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,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=3,0,1))","v":1},16]
[null,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,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]
[{"$f":"IF(D47=$Q$11,650,1000)","v":1000},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,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,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,null,"Reliability factor",{"$f":"IF($D$47=\"Bus\",2,+IF($D$47=\"rail\",0.75))","v":false},{"$f":"IF($D$47=\"Bus\",2,+IF($D$47=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,{"$f":"IF($D$47=\"Bus\",2,+IF($D$47=\"rail\",0.75))","v":false},null,null,1,"Is a bus service available:"]
[null,null,"Walk time",{"$f":"$D$48/80","v":0},{"$f":"$D$48/80","v":0},0,0,0,0,0,0,0,{"$f":"$D$48/80","v":0},null,null,1,"Yes"]
[null,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D50)),\"\",0.5*(60/D50))","v":""},{"$f":"IF(ISERROR(0.5*(60/E50)),\"\",0.5*(60/E50))","v":""},"","","","","","","","",null,null,1,"No"]
[null,null,"Average waiting time",{"$f":"IF(ISERROR(D53+D51),\"\",D53+D51)","v":""},{"$f":"IF(ISERROR(E53+E51),\"\",E53+E51)","v":""},"","","","","","","","",null,null,1]
[null,null,"Total access time",{"$f":"IF(ISERROR(D52+D54),\"\",D52+D54)","v":""},{"$f":"IF(ISERROR(E52+E54),\"\",E52+E54)","v":""},"","","","","","","","",null,null,1,"Is there a taxi drop off point:"]
[null,null,"Equivalent doorstep frequency",{"$f":"IF($D$48=\"\",0,IF(ISERROR(30/D55),0,(30/D55)))","v":0},{"$f":"IF($D$48=\"\",0,IF(ISERROR(30/E55),0,(30/E55)))","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,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=4,0,1))","v":1},"No"]
[null,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,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}]
[{"$f":"IF(D59=$Q$11,650,1000)","v":1000},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,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,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,null,"Reliability factor",{"$f":"IF($D$59=\"Bus\",2,+IF($D$59=\"rail\",0.75))","v":false},{"$f":"IF($D$59=\"Bus\",2,+IF($D$59=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,{"$f":"IF($D$59=\"Bus\",2,+IF($D$59=\"rail\",0.75))","v":false},null,null,1]
[null,null,"Walk time",{"$f":"$D$60/80","v":0},{"$f":"$D$60/80","v":0},0,0,0,0,0,0,0,{"$f":"$D$60/80","v":0},null,null,1]
[null,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D62)),\"\",0.5*(60/D62))","v":""},{"$f":"IF(ISERROR(0.5*(60/E62)),\"\",0.5*(60/E62))","v":""},"","","","","","","","",null,null,1]
[null,null,"Average waiting time",{"$f":"IF(ISERROR(D65+D63),\"\",D65+D63)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Total access time",{"$f":"IF(ISERROR(D64+D66),\"\",D64+D66)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Equivalent doorstep frequency",{"$f":"IF($D$60=\"\",0,IF(ISERROR(30/D67),0,(30/D67)))","v":0},{"$f":"IF($D$60=\"\",0,IF(ISERROR(30/E67),0,(30/E67)))","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,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=5,0,1))","v":1}]
[null,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,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}]
[{"$f":"IF(D71=$Q$11,650,1000)","v":1000},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,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,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,null,"Reliability factor",{"$f":"IF($D$71=\"Bus\",2,+IF($D$71=\"rail\",0.75))","v":false},{"$f":"IF($D$71=\"Bus\",2,+IF($D$71=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,{"$f":"IF($D$71=\"Bus\",2,+IF($D$71=\"rail\",0.75))","v":false},null,null,1]
[null,null,"Walk time",{"$f":"$D$72/80","v":0},{"$f":"$D$72/80","v":0},0,0,0,0,0,0,0,{"$f":"$D$72/80","v":0},null,null,1]
[null,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D74)),\"\",0.5*(60/D74))","v":""},{"$f":"IF(ISERROR(0.5*(60/E74)),\"\",0.5*(60/E74))","v":""},"","","","","","","","",null,null,1]
[null,null,"Average waiting time",{"$f":"IF(ISERROR(D77+D75),\"\",D77+D75)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Total access time",{"$f":"IF(ISERROR(D76+D78),\"\",D76+D78)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Equivalent doorstep frequency",{"$f":"IF($D$72=\"\",0,IF(ISERROR(30/D79),0,(30/D79)))","v":0},{"$f":"IF($D$72=\"\",0,IF(ISERROR(30/E79),0,(30/E79)))","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,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=6,0,1))","v":1}]
[null,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,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}]
[{"$f":"IF(D83=$Q$11,650,1000)","v":1000},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,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,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,null,"Reliability factor",{"$f":"IF($D$83=\"Bus\",2,+IF($D$83=\"rail\",0.75))","v":false},{"$f":"IF($D$83=\"Bus\",2,+IF($D$83=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,{"$f":"IF($D$83=\"Bus\",2,+IF($D$83=\"rail\",0.75))","v":false},null,null,1]
[null,null,"Walk time",{"$f":"$D$84/80","v":0},{"$f":"$D$84/80","v":0},0,0,0,0,0,0,0,{"$f":"$D$84/80","v":0},null,null,1]
[null,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D86)),\"\",0.5*(60/D86))","v":""},{"$f":"IF(ISERROR(0.5*(60/E86)),\"\",0.5*(60/E86))","v":""},"","","","","","","","",null,null,1]
[null,null,"Average waiting time",{"$f":"IF(ISERROR(D89+D87),\"\",D89+D87)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Total access time",{"$f":"IF(ISERROR(D88+D90),\"\",D88+D90)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Equivalent doorstep frequency",{"$f":"IF($D$84=\"\",0,IF(ISERROR(30/D91),0,(30/D91)))","v":0},{"$f":"IF($D$84=\"\",0,IF(ISERROR(30/E91),0,(30/E91)))","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,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=7,0,1))","v":1}]
[null,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,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}]
[{"$f":"IF(D95=$Q$11,650,1000)","v":1000},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,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,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,null,"Reliability factor",{"$f":"IF($D$95=\"Bus\",2,+IF($D$95=\"rail\",0.75))","v":false},{"$f":"IF($D$95=\"Bus\",2,+IF($D$95=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,{"$f":"IF($D$95=\"Bus\",2,+IF($D$95=\"rail\",0.75))","v":false},null,null,1]
[null,null,"Walk time",{"$f":"$D$96/80","v":0},{"$f":"$D$96/80","v":0},0,0,0,0,0,0,0,{"$f":"$D$96/80","v":0},null,null,1]
[null,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D98)),\"\",0.5*(60/D98))","v":""},{"$f":"IF(ISERROR(0.5*(60/E98)),\"\",0.5*(60/E98))","v":""},"","","","","","","","",null,null,1]
[null,null,"Average waiting time",{"$f":"IF(ISERROR(D101+D99),\"\",D101+D99)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Total access time",{"$f":"IF(ISERROR(D100+D102),\"\",D100+D102)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Equivalent doorstep frequency",{"$f":"IF($D$96=\"\",0,IF(ISERROR(30/D103),0,(30/D103)))","v":0},{"$f":"IF($D$96=\"\",0,IF(ISERROR(30/E103),0,(30/E103)))","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,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=8,0,1))","v":1}]
[null,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,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}]
[{"$f":"IF(D107=$Q$11,650,1000)","v":1000},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,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,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,null,"Reliability factor",{"$f":"IF($D$107=\"Bus\",2,+IF($D$107=\"rail\",0.75))","v":false},{"$f":"IF($D$107=\"Bus\",2,+IF($D$107=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,{"$f":"IF($D$107=\"Bus\",2,+IF($D$107=\"rail\",0.75))","v":false},null,null,1]
[null,null,"Walk time",{"$f":"$D$108/80","v":0},{"$f":"$D$108/80","v":0},0,0,0,0,0,0,0,{"$f":"$D$108/80","v":0},null,null,1]
[null,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D110)),\"\",0.5*(60/D110))","v":""},{"$f":"IF(ISERROR(0.5*(60/E110)),\"\",0.5*(60/E110))","v":""},"","","","","","","","",null,null,1]
[null,null,"Average waiting time",{"$f":"IF(ISERROR(D113+D111),\"\",D113+D111)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Total access time",{"$f":"IF(ISERROR(D112+D114),\"\",D112+D114)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Equivalent doorstep frequency",{"$f":"IF($D$108=\"\",0,IF(ISERROR(30/D115),0,(30/D115)))","v":0},{"$f":"IF($D$108=\"\",0,IF(ISERROR(30/E115),0,(30/E115)))","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,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=9,0,1))","v":1}]
[null,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,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}]
[{"$f":"IF(D119=$Q$11,650,1000)","v":1000},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,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,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,null,"Reliability factor",{"$f":"IF($D$119=\"Bus\",2,+IF($D$119=\"rail\",0.75))","v":false},{"$f":"IF($D$119=\"Bus\",2,+IF($D$119=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,{"$f":"IF($D$119=\"Bus\",2,+IF($D$119=\"rail\",0.75))","v":false},null,null,1]
[null,null,"Walk time",{"$f":"$D$120/80","v":0},{"$f":"$D$120/80","v":0},0,0,0,0,0,0,0,{"$f":"$D$120/80","v":0},null,null,1]
[null,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D122)),\"\",0.5*(60/D122))","v":""},{"$f":"IF(ISERROR(0.5*(60/E122)),\"\",0.5*(60/E122))","v":""},"","","","","","","","",null,null,1]
[null,null,"Average waiting time",{"$f":"IF(ISERROR(D125+D123),\"\",D125+D123)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Total access time",{"$f":"IF(ISERROR(D124+D126),\"\",D124+D126)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Equivalent doorstep frequency",{"$f":"IF($D$120=\"\",0,IF(ISERROR(30/D127),0,(30/D127)))","v":0},{"$f":"IF($D$120=\"\",0,IF(ISERROR(30/E127),0,(30/E127)))","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,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=10,0,1))","v":1}]
[null,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,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}]
[{"$f":"IF(D131=$Q$11,650,1000)","v":1000},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,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,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,null,"Reliability factor",{"$f":"IF($D$131=\"Bus\",2,+IF($D$131=\"rail\",0.75))","v":false},{"$f":"IF($D$131=\"Bus\",2,+IF($D$131=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,{"$f":"IF($D$131=\"Bus\",2,+IF($D$131=\"rail\",0.75))","v":false},null,null,1]
[null,null,"Walk time",{"$f":"$D$132/80","v":0},{"$f":"$D$132/80","v":0},0,0,0,0,0,0,0,{"$f":"$D$132/80","v":0},null,null,1]
[null,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D134)),\"\",0.5*(60/D134))","v":""},{"$f":"IF(ISERROR(0.5*(60/E134)),\"\",0.5*(60/E134))","v":""},"","","","","","","","",null,null,1]
[null,null,"Average waiting time",{"$f":"IF(ISERROR(D137+D135),\"\",D137+D135)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Total access time",{"$f":"IF(ISERROR(D136+D138),\"\",D136+D138)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Equivalent doorstep frequency",{"$f":"IF($D$132=\"\",0,IF(ISERROR(30/D139),0,(30/D139)))","v":0},{"$f":"IF($D$132=\"\",0,IF(ISERROR(30/E139),0,(30/E139)))","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,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=11,0,1))","v":1}]
[null,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,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}]
[{"$f":"IF(D143=$Q$11,650,1000)","v":1000},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,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,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,null,"Reliability factor",{"$f":"IF($D$143=\"Bus\",2,+IF($D$143=\"rail\",0.75))","v":false},{"$f":"IF($D$143=\"Bus\",2,+IF($D$143=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,{"$f":"IF($D$143=\"Bus\",2,+IF($D$143=\"rail\",0.75))","v":false},null,null,1]
[null,null,"Walk time",{"$f":"$D$144/80","v":0},{"$f":"$D$144/80","v":0},0,0,0,0,0,0,0,{"$f":"$D$144/80","v":0},null,null,1]
[null,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D146)),\"\",0.5*(60/D146))","v":""},{"$f":"IF(ISERROR(0.5*(60/E146)),\"\",0.5*(60/E146))","v":""},"","","","","","","","",null,null,1]
[null,null,"Average waiting time",{"$f":"IF(ISERROR(D149+D147),\"\",D149+D147)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Total access time",{"$f":"IF(ISERROR(D148+D150),\"\",D148+D150)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Equivalent doorstep frequency",{"$f":"IF($D$144=\"\",0,IF(ISERROR(30/D151),0,(30/D151)))","v":0},{"$f":"IF($D$144=\"\",0,IF(ISERROR(30/E151),0,(30/E151)))","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,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=12,0,1))","v":1}]
[null,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,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}]
[{"$f":"IF(D155=$Q$11,650,1000)","v":1000},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,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,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,null,"Reliability factor",{"$f":"IF($D$155=\"Bus\",2,+IF($D$155=\"rail\",0.75))","v":false},{"$f":"IF($D$155=\"Bus\",2,+IF($D$155=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,{"$f":"IF($D$155=\"Bus\",2,+IF($D$155=\"rail\",0.75))","v":false},null,null,1]
[null,null,"Walk time",{"$f":"$D$156/80","v":0},{"$f":"$D$156/80","v":0},0,0,0,0,0,0,0,{"$f":"$D$156/80","v":0},null,null,1]
[null,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D158)),\"\",0.5*(60/D158))","v":""},{"$f":"IF(ISERROR(0.5*(60/E158)),\"\",0.5*(60/E158))","v":""},"","","","","","","","",null,null,1]
[null,null,"Average waiting time",{"$f":"IF(ISERROR(D161+D159),\"\",D161+D159)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Total access time",{"$f":"IF(ISERROR(D160+D162),\"\",D160+D162)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Equivalent doorstep frequency",{"$f":"IF($D$156=\"\",0,IF(ISERROR(30/D163),0,(30/D163)))","v":0},{"$f":"IF($D$156=\"\",0,IF(ISERROR(30/E163),0,(30/E163)))","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,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=13,0,1))","v":1}]
[null,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,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}]
[{"$f":"IF(D167=$Q$11,650,1000)","v":1000},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,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,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,null,"Reliability factor",{"$f":"IF($D$167=\"Bus\",2,+IF($D$167=\"rail\",0.75))","v":false},{"$f":"IF($D$167=\"Bus\",2,+IF($D$167=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,{"$f":"IF($D$167=\"Bus\",2,+IF($D$167=\"rail\",0.75))","v":false},null,null,1]
[null,null,"Walk time",{"$f":"$D$168/80","v":0},{"$f":"$D$168/80","v":0},0,0,0,0,0,0,0,{"$f":"$D$168/80","v":0},null,null,1]
[null,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D170)),\"\",0.5*(60/D170))","v":""},{"$f":"IF(ISERROR(0.5*(60/E170)),\"\",0.5*(60/E170))","v":""},"","","","","","","","",null,null,1]
[null,null,"Average waiting time",{"$f":"IF(ISERROR(D173+D171),\"\",D173+D171)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Total access time",{"$f":"IF(ISERROR(D172+D174),\"\",D172+D174)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Equivalent doorstep frequency",{"$f":"IF($D$168=\"\",0,IF(ISERROR(30/D175),0,(30/D175)))","v":0},{"$f":"IF($D$168=\"\",0,IF(ISERROR(30/E175),0,(30/E175)))","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,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=14,0,1))","v":1}]
[null,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,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}]
[{"$f":"IF(D179=$Q$11,650,1000)","v":1000},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,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,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,null,"Reliability factor",{"$f":"IF($D$179=\"Bus\",2,+IF($D$179=\"rail\",0.75))","v":false},{"$f":"IF($D$179=\"Bus\",2,+IF($D$179=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,{"$f":"IF($D$179=\"Bus\",2,+IF($D$179=\"rail\",0.75))","v":false},null,null,1]
[null,null,"Walk time",{"$f":"$D$180/80","v":0},{"$f":"$D$180/80","v":0},0,0,0,0,0,0,0,{"$f":"$D$180/80","v":0},null,null,1]
[null,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D182)),\"\",0.5*(60/D182))","v":""},{"$f":"IF(ISERROR(0.5*(60/E182)),\"\",0.5*(60/E182))","v":""},"","","","","","","","",null,null,1]
[null,null,"Average waiting time",{"$f":"IF(ISERROR(D185+D183),\"\",D185+D183)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Total access time",{"$f":"IF(ISERROR(D184+D186),\"\",D184+D186)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Equivalent doorstep frequency",{"$f":"IF($D$180=\"\",0,IF(ISERROR(30/D187),0,(30/D187)))","v":0},{"$f":"IF($D$180=\"\",0,IF(ISERROR(30/E187),0,(30/E187)))","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,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=15,0,1))","v":1}]
[null,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,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}]
[{"$f":"IF(D191=$Q$11,650,1000)","v":1000},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,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,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,null,"Reliability factor",{"$f":"IF($D$191=\"Bus\",2,+IF($D$191=\"rail\",0.75))","v":false},{"$f":"IF($D$191=\"Bus\",2,+IF($D$191=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,{"$f":"IF($D$191=\"Bus\",2,+IF($D$191=\"rail\",0.75))","v":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,null,"Walk time",{"$f":"$D$192/80","v":0},{"$f":"$D$192/80","v":0},0,0,0,0,0,0,0,{"$f":"$D$192/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,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D194)),\"\",0.5*(60/D194))","v":""},{"$f":"IF(ISERROR(0.5*(60/E194)),\"\",0.5*(60/E194))","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,null,"Average waiting time",{"$f":"IF(ISERROR(D197+D195),\"\",D197+D195)","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,null,"Total access time",{"$f":"IF(ISERROR(D196+D198),\"\",D196+D198)","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,null,"Equivalent doorstep frequency",{"$f":"IF($D$192=\"\",0,IF(ISERROR(30/D199),0,(30/D199)))","v":0},{"$f":"IF($D$192=\"\",0,IF(ISERROR(30/E199),0,(30/E199)))","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,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,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,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}]
[{"$f":"IF(D203=$Q$11,650,1000)","v":1000},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,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,null,null,null,null,null,null,null,null,null,null,"Type 6"]
[null,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,null,null,null,null,null,null,null,null,null,null,0.5,1]
[null,null,"Reliability factor",{"$f":"IF($D$203=\"Bus\",2,+IF($D$203=\"rail\",0.75))","v":false},{"$f":"IF($D$203=\"Bus\",2,+IF($D$203=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,{"$f":"IF($D$203=\"Bus\",2,+IF($D$203=\"rail\",0.75))","v":false},null,null,1,null,null,null,null,null,null,null,null,null,null,null,1,2]
[null,null,"Walk time",{"$f":"$D$204/80","v":0},{"$f":"$D$204/80","v":0},0,0,0,0,0,0,0,{"$f":"$D$204/80","v":0},null,null,1,null,null,null,null,null,null,null,null,null,null,null,2,3]
[null,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D206)),\"\",0.5*(60/D206))","v":""},{"$f":"IF(ISERROR(0.5*(60/E206)),\"\",0.5*(60/E206))","v":""},"","","","","","","","",null,null,1,null,null,null,null,null,null,null,null,null,null,null,4,4]
[null,null,"Average waiting time",{"$f":"IF(ISERROR(D209+D207),\"\",D209+D207)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Total access time",{"$f":"IF(ISERROR(D208+D210),\"\",D208+D210)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Equivalent doorstep frequency",{"$f":"IF($D$204=\"\",0,IF(ISERROR(30/D211),0,(30/D211)))","v":0},{"$f":"IF($D$204=\"\",0,IF(ISERROR(30/E211),0,(30/E211)))","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,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=17,0,1))","v":1}]
[null,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,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}]
[{"$f":"IF(D215=$Q$11,650,1000)","v":1000},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,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,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,null,"Reliability factor",{"$f":"IF($D$215=\"Bus\",2,+IF($D$215=\"rail\",0.75))","v":false},{"$f":"IF($D$215=\"Bus\",2,+IF($D$215=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,false,null,null,1]
[null,null,"Walk time",{"$f":"$D$216/80","v":0},{"$f":"$D$216/80","v":0},0,0,0,0,0,0,0,0,null,null,1]
[null,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D218)),\"\",0.5*(60/D218))","v":""},{"$f":"IF(ISERROR(0.5*(60/E218)),\"\",0.5*(60/E218))","v":""},"","","","","","","","",null,null,1]
[null,null,"Average waiting time",{"$f":"IF(ISERROR(D221+D219),\"\",D221+D219)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Total access time",{"$f":"IF(ISERROR(D220+D222),\"\",D220+D222)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Equivalent doorstep frequency",{"$f":"IF($D$216=\"\",0,IF(ISERROR(30/D223),0,(30/D223)))","v":0},{"$f":"IF($D$216=\"\",0,IF(ISERROR(30/E223),0,(30/E223)))","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,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=18,0,1))","v":1}]
[null,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,null,"Public transport type",null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"IF(D227=$Q$11,650,1000)","v":1000},null,"Distance to node (m)",null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,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,null,"Average frequency per hour",null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Reliability factor",{"$f":"IF($D$227=\"Bus\",2,+IF($D$239=\"rail\",0.75))","v":false},{"$f":"IF($D$227=\"Bus\",2,+IF($D$239=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,{"$f":"IF($D$227=\"Bus\",2,+IF($D$239=\"rail\",0.75))","v":false},null,null,1]
[null,null,"Walk time",{"$f":"$D$228/80","v":0},{"$f":"$D$228/80","v":0},0,0,0,0,0,0,0,{"$f":"$D$228/80","v":0},null,null,1]
[null,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D230)),\"\",0.5*(60/D230))","v":""},{"$f":"IF(ISERROR(0.5*(60/E230)),\"\",0.5*(60/E230))","v":""},"","","","","","","","",null,null,1]
[null,null,"Average waiting time",{"$f":"IF(ISERROR(D233+D231),\"\",D233+D231)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Total access time",{"$f":"IF(ISERROR(D232+D234),\"\",D232+D234)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Equivalent doorstep frequency",{"$f":"IF($D$228=\"\",0,IF(ISERROR(30/D235),0,(30/D235)))","v":0},{"$f":"IF($D$228=\"\",0,IF(ISERROR(30/E235),0,(30/E235)))","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,null,1]
[null,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,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}]
[{"$f":"IF(D239=$Q$11,650,1000)","v":1000},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,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,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,null,"Reliability factor",{"$f":"IF($D$239=\"Bus\",2,+IF($D$239=\"rail\",0.75))","v":false},{"$f":"IF($D$239=\"Bus\",2,+IF($D$239=\"rail\",0.75))","v":false},false,false,false,false,false,false,false,{"$f":"IF($D$239=\"Bus\",2,+IF($D$239=\"rail\",0.75))","v":false},null,null,1]
[null,null,"Walk time",{"$f":"$D$240/80","v":0},{"$f":"$D$240/80","v":0},0,0,0,0,0,0,0,{"$f":"$D$240/80","v":0},null,null,1]
[null,null,"Scheduled waiting time",{"$f":"IF(ISERROR(0.5*(60/D242)),\"\",0.5*(60/D242))","v":""},{"$f":"IF(ISERROR(0.5*(60/E242)),\"\",0.5*(60/E242))","v":""},"","","","","","","","",null,null,1]
[null,null,"Average waiting time",{"$f":"IF(ISERROR(D245+D243),\"\",D245+D243)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Total access time",{"$f":"IF(ISERROR(D244+D246),\"\",D244+D246)","v":""},"","","","","","","","","",null,null,1]
[null,null,"Equivalent doorstep frequency",{"$f":"IF($D$239=\"\",0,IF(ISERROR(30/D247),0,(30/D247)))","v":0},{"$f":"IF($D$239=\"\",0,IF(ISERROR(30/E247),0,(30/E247)))","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,null,{"$f":"IF(nodeselection=21,1,IF(nodeselection>=20,0,1))","v":1}]
[]
[null,null,"RANK AND SUMMATION FOR BUS SERVICES ONLY",{"$f":"IF($D$11=\"Bus\",D20,0)","v":0},{"$f":"IF($D$11=\"Bus\",E20,0)","v":0},0,0,0,0,0,0,0,0,null,null,{"$f":"IF($D$23=\"Bus\",D32,0)","v":0},{"$f":"IF($D$23=\"Bus\",E32,0)","v":0},0,0,0,0,0,0,0,{"$f":"IF($D$23=\"Bus\",M32,0)","v":0},null,{"$f":"IF($D$35=\"Bus\",D44,0)","v":0},{"$f":"IF($D$35=\"Bus\",E44,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$47=\"Bus\",D56,0)","v":0},{"$f":"IF($D$47=\"Bus\",E56,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$59=\"Bus\",D68,0)","v":0},{"$f":"IF($D$59=\"Bus\",E68,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$71=\"Bus\",D80,0)","v":0},{"$f":"IF($D$71=\"Bus\",E80,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$83=\"Bus\",D92,0)","v":0},{"$f":"IF($D$83=\"Bus\",E92,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$95=\"Bus\",D104,0)","v":0},{"$f":"IF($D$95=\"Bus\",E104,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$107=\"Bus\",D116,0)","v":0},{"$f":"IF($D$107=\"Bus\",E116,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$119=\"Bus\",D128,0)","v":0},{"$f":"IF($D$119=\"Bus\",E128,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$131=\"Bus\",D140,0)","v":0},{"$f":"IF($D$131=\"Bus\",E140,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$143=\"Bus\",D152,0)","v":0},{"$f":"IF($D$143=\"Bus\",E152,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$155=\"Bus\",D164,0)","v":0},{"$f":"IF($D$155=\"Bus\",E164,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$167=\"Bus\",D176,0)","v":0},{"$f":"IF($D$167=\"Bus\",E176,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$179=\"Bus\",D188,0)","v":0},{"$f":"IF($D$179=\"Bus\",E188,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$191=\"Bus\",D200,0)","v":0},{"$f":"IF($D$191=\"Bus\",E200,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$203=\"Bus\",D212,0)","v":0},{"$f":"IF($D$203=\"Bus\",E212,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$215=\"Bus\",D224,0)","v":0},{"$f":"IF($D$215=\"Bus\",E224,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$227=\"Bus\",D236,0)","v":0},{"$f":"IF($D$227=\"Bus\",E236,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$239=\"Bus\",D248,0)","v":0},{"$f":"IF($D$239=\"Bus\",E248,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"RANK(D251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1,1,1,1,null,null,{"$f":"RANK(P251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(AA251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(AL251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(AW251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(BH251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(BS251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(CD251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(CO251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(CZ251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(DK251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(DV251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(EG251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(ER251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(FC251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(FN251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(FY251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(GJ251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(GU251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(HF251,$D$251:$HO$251,0)","v":1},{"$f":"RANK(HG251,$D$251:$HO$251,0)","v":1},{"$f":"RANK(HH251,$D$251:$HO$251,0)","v":1},{"$f":"RANK(HI251,$D$251:$HO$251,0)","v":1},1,1,1,1,1,1]
[null,null,null,{"$f":"IF(D252=1,D251,D251/2)","v":0},{"$f":"IF(E252=1,E251,E251/2)","v":0},{"$f":"IF(F252=1,F251,F251/2)","v":0},0,0,0,0,0,0,0,null,null,{"$f":"IF(P252=1,P251,P251/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(BX252=1,BX251,BX251/2)","v":0},0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,{"$f":"IF(CO252=1,CO251,CO251/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(EP252=1,EP251,EP251/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(HI252=1,HI251,HI251/2)","v":0},0,0,0,0,0,0]
[]
[null,null,"RANK 1 ELEMENTS",{"$f":"IF(D252=1,D253,0)","v":0},{"$f":"IF(E252=1,E253,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(BX252=1,BX253,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(EP252=1,EP253,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(HI252=1,HI253,0)","v":0},0,0,0,0,0,0]
[null,null,"RANK 1 ELEMENTS(O'S OMITTED)",{"$f":"IF(D252=1,D253,\"\")","v":0},{"$f":"IF(E252=1,E253,\"\")","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(BX252=1,BX253,\"\")","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(EP252=1,EP253,\"\")","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(HI252=1,HI253,\"\")","v":0},0,0,0,0,0,0]
[null,null,"NON RANK 1 ELEMENTS",{"$f":"IF(NOT(D252=1),D253,0)","v":0},{"$f":"IF(NOT(E252=1),E253,0)","v":0},{"$f":"IF(NOT(F252=1),F253,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(BX252=1),BX253,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(EP252=1),EP253,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(HI252=1),HI253,0)","v":0},0,0,0,0,0,0]
[null,null,"COUNT OF RANK 1 ELEMENTS",{"$f":"COUNT(D256:HO256)","v":200}]
[null,null,"SUM ALL RANK1*0.5",{"$f":"(0.5*SUM(D255:HO255))","v":0}]
[null,null,"(SUM ALL RANK 1*0.5)/COUNT",{"$f":"D259/D258","v":0}]
[null,null,"A262+A263",{"$f":"D259+D260","v":0}]
[null,null,"Total EDF for selected transport mode",{"$f":"D261+SUM(D257:HO257)","v":0}]
[]
[null,null,"RANK AND SUMMATION FOR RAIL SERVICES ONLY",{"$f":"IF($D$11=\"Rail\",D20,0)","v":0},{"$f":"IF($D$11=\"Rail\",E20,0)","v":0},0,0,0,0,0,0,0,0,null,null,{"$f":"IF($D$23=\"Rail\",D32,0)","v":0},{"$f":"IF($D$23=\"Rail\",E32,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$35=\"Rail\",D44,0)","v":0},{"$f":"IF($D$35=\"Rail\",E44,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$47=\"Rail\",D56,0)","v":0},{"$f":"IF($D$47=\"Rail\",E56,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$59=\"Rail\",D68,0)","v":0},{"$f":"IF($D$59=\"Rail\",E68,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$71=\"Rail\",D80,0)","v":0},{"$f":"IF($D$71=\"Rail\",E80,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$83=\"Rail\",D92,0)","v":0},{"$f":"IF($D$83=\"Rail\",E92,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$95=\"Rail\",D104,0)","v":0},{"$f":"IF($D$95=\"Rail\",E104,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$107=\"Rail\",D116,0)","v":0},{"$f":"IF($D$107=\"Rail\",E116,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$119=\"Rail\",D128,0)","v":0},{"$f":"IF($D$119=\"Rail\",E128,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$131=\"Rail\",D140,0)","v":0},{"$f":"IF($D$131=\"Rail\",E140,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$143=\"Rail\",D152,0)","v":0},{"$f":"IF($D$143=\"Rail\",E152,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$155=\"Rail\",D164,0)","v":0},{"$f":"IF($D$155=\"Rail\",E164,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$167=\"Rail\",D176,0)","v":0},{"$f":"IF($D$167=\"Rail\",E176,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$179=\"Rail\",D188,0)","v":0},{"$f":"IF($D$179=\"Rail\",E188,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$191=\"Rail\",D200,0)","v":0},{"$f":"IF($D$191=\"Rail\",E200,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$203=\"Rail\",D212,0)","v":0},{"$f":"IF($D$203=\"Rail\",E212,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$215=\"Rail\",D224,0)","v":0},{"$f":"IF($D$215=\"Rail\",E224,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$227=\"Rail\",D236,0)","v":0},{"$f":"IF($D$227=\"Rail\",E236,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF($D$239=\"Rail\",D248,0)","v":0},{"$f":"IF($D$239=\"Rail\",E248,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"RANK(D264,$D$264:$HO$264,0)","v":1},1,1,1,1,1,1,1,1,1,null,null,{"$f":"RANK(P264,$D$264:$HO$264,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(AA264,$D$264:$HO$264,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(AL264,$D$264:$HO$264,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(AW264,$D$264:$HO$264,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(BH264,$D$264:$HO$264,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(BS264,$D$264:$HO$264,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(CD264,$D$264:$HO$264,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(CO264,$D$264:$HO$264,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(CZ264,$D$264:$HO$264,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(DK264,$D$264:$HO$264,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(DV264,$D$264:$HO$264,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(EG264,$D$264:$HO$264,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(ER264,$D$264:$HO$264,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(FC264,$D$264:$HO$264,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(FN264,$D$264:$HO$264,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(FY264,$D$264:$HO$264,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(GJ264,$D$264:$HO$264,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(GU264,$D$264:$HO$264,0)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"RANK(HF264,$D$264:$HO$264,0)","v":1},{"$f":"RANK(HG264,$D$264:$HO$264,0)","v":1},{"$f":"RANK(HH264,$D$264:$HO$264,0)","v":1},{"$f":"RANK(HI264,$D$264:$HO$264,0)","v":1},{"$f":"RANK(HJ264,$D$264:$HO$264,0)","v":1},1,1,1,1,1]
[null,null,null,{"$f":"IF(D265=1,D264,D264/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(AN265=1,AN264,AN264/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(BW265=1,BW264,BW264/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(DF265=1,DF264,DF264/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(EO265=1,EO264,EO264/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(FY265=1,FY264,FY264/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(HH265=1,HH264,HH264/2)","v":0},0,0,0,0,0,0,0]
[]
[null,null,"RANK 1 ELEMENTS",{"$f":"IF(D265=1,D266,0)","v":0},{"$f":"IF(E265=1,E266,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(BX265=1,BX266,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(EP265=1,EP266,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(HI265=1,HI266,0)","v":0},0,0,0,0,0,0]
[null,null,"RANK 1 ELEMENTS (O'S OMITTED)",{"$f":"IF(D265=1,D266,\"\")","v":0},{"$f":"IF(E265=1,E266,\"\")","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(BX265=1,BX266,\"\")","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(EP265=1,EP266,\"\")","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(HI265=1,HI266,\"\")","v":0},0,0,0,0,0,0]
[null,null,"NON RANK 1 ELEMENTS",{"$f":"IF(NOT(D265=1),D266,0)","v":0},{"$f":"IF(NOT(E265=1),E266,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(BX265=1),BX266,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(EP265=1),EP266,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(HI265=1),HI266,0)","v":0},0,0,0,0,0,0]
[null,null,"COUNT OF RANK 1 ELEMENTS",{"$f":"COUNT(D269:HO269)","v":200}]
[null,null,"SUM ALL RANK 1 * 0.5",{"$f":"(0.5*SUM(D268:HO268))","v":0}]
[null,null,"(SUM ALL RANK 1 * 0.5)/COUNT",{"$f":"D272/D271","v":0}]
[null,null,"A275+A276",{"$f":"D272+D273","v":0}]
[null,null,"Total EDF for selected transport mode",{"$f":"D274+SUM(D270:HO270)","v":0}]
[]
[null,null,null,1]
[null,null,null,2,{"$f":"IF(scope1=1,+IF(Credits=0,1))","v":false}]
[null,null,null,1,{"$f":"IF(scope=7,IF(scope2=2,+IF(Credits=5,0,1),0))","v":false}]
[null,null,null,{"$f":"credit(AINDX,selectionvalue)","v":0},"vlookup this cell"]
[null,null,null,1]
[]
[]
[null,null,"Accessibility Index",null,null,{"$f":"SUM(D262+D275)","v":0}]
[]
[null,null,"Tra01 total credits achieved  ",null,null,{"$f":"IF(AF6=1,(VLOOKUP(AINDX,Type6Credits,2,TRUE)),IF(scope1a=1,Credits+1,Credits))","v":0}]

{"sheet":"Schedule of changes","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,5,9,13],[5,5,5,13]]}
[]
[null,{"$f":"'Tra01 - Public transport access'!C2","v":"BREEAM International 2016 Tra 01 Public transport accessibility calculator"}]
[]
[null,"Current Version",null,"Release date",null,"Description of changes/additions to previous version resulting in current version"]
[]
[null,1,null,"2016-03-21",null,"BREEAM International New Construction 2016 go live version."]
[]
[null,"Previous Versions",null,"Release date",null,"Description of changes/additions"]
[]
[null,"N/A",null,"N/A",null,"N/A"]