{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Simple Beta v6.2","LoS Targets","Data validation"],"not_rendered":{"charts":1,"images":15,"macros":1,"external_links":0,"defined_names":1,"comments":4,"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":"Simple Beta v6.2","index":0,"n_rows":50,"n_cols":42,"rows_kept":50,"cut":false,"hidden":false,"merged":[[46,1,46,3],[47,1,47,3],[7,2,7,3],[6,2,6,3],[5,2,5,3],[15,2,15,3],[14,2,14,3],[11,2,11,3],[9,2,9,3],[8,2,8,3],[32,2,32,12],[40,4,40,10],[42,4,42,10],[37,4,37,11],[43,4,43,10],[38,4,38,10],[20,41,20,42],[45,1,45,3],[1,0,1,10],[0,0,0,10],[37,1,37,3],[5,0,9,0],[12,0,19,0],[12,2,12,3],[13,2,13,3],[19,2,19,3],[18,2,18,3],[17,2,17,3],[16,2,16,3],[39,4,39,10],[41,4,41,10],[22,0,28,0],[2,0,2,3],[3,0,3,3],[31,2,31,12],[39,28,40,28],[43,1,43,3],[41,1,42,3],[41,26,42,26],[38,26,40,26],[38,1,40,3],[22,6,24,7],[25,6,26,7],[22,8,24,12],[25,8,26,12]]}
["Auckland Network Operating Plan - Simple Assessment Tool Beta v6.2"]
["This assessment tool is designed to provide an indicative evaluation of whether a project or option is well aligned with AT's strategic direction (including the Auckland Network Operating Plan, Future Connect and the Roads and Streets Framework).\nThis is not intended to be used to rank projects or options, nor provide an indication of value for money, but it will show whether the project is taking us in the right direction and will show what modes the project it is addressing.\nThe evaluation of project impacts should be carried out in consultation with relevant subject matter experts.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Graph axis headings"]
["Click here for more information about the Auckland Network Operating Plan"]
["Click here for more information on Future Connect - Auckland Transport's Network Plan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Walk"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cycle"]
["Project information","Project Name","Test",null,{"$f":"CONCATENATE(D6,\", \",D7,\", \",D8,\", ANOP Fit Assessment\")","v":", , , ANOP Fit Assessment"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PT"]
[null,"Location",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Freight"]
[null,"Option Ref.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gnrl Trfc"]
[null,"Date of assessment"]
[null,"Assessor name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loading"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parking"]
[null,null,"Network Hierarchy\n(Future Connect First Decade)",null,null,"Acceptable Target LoS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acceptable Target LoS (base)","Acceptable Target LoS (adjusted)","Acceptable Target LoS Score (adjusted)","Observed LoS Score","Observed LoS Deficit to Acceptable Target LoS","Assessed LoS Score","Adjusted Assessed LoS Score","Assessed LoS Deficit to Acceptable Target LoS","Change in deficit to Acceptable target LoS","Mode is improved","Mode deteriorates"]
["Strategic Networks & Land Use","Walking","Primary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Walking",{"$f":"IF($D$50=\"Yes\",F13,_xlfn.XLOOKUP(C13,'Data validation'!Y4:Y7,'Data validation'!AB4:AB7))","v":"B"},{"$f":"_xlfn.XLOOKUP(AD13,'Data validation'!$J$23:$J$30,'Data validation'!$I$23:$I$30)","v":"B"},{"$f":"_xlfn.XLOOKUP(AB13,'Data validation'!$I$23:$I$30,'Data validation'!$J$23:$J$30)","v":5},{"$f":"IF(C23=\"\",0,_xlfn.XLOOKUP(C23,'Data validation'!$I$23:$I$30,'Data validation'!$J$23:$J$30,0))","v":2},{"$f":"IF(AE13<$AD13,$AD13-AE13,0)","v":3},{"$f":"IF(LEN($D23)=1,_xlfn.XLOOKUP(D23,'Data validation'!$I$23:$I$30,'Data validation'!$J$23:$J$30),IF(D23=\"\",0,_xlfn.XLOOKUP(D23,'Data validation'!$A$23:$A$28,'Data validation'!$B$23:$B$28,0))*2+AE13)","v":3},{"$f":"IF(AG13<0,0,IF(AG13>6,6,AG13))","v":3},{"$f":"IF(AH13<$AD13,$AD13-AG13,0)","v":2},{"$f":"AF13-AI13","v":1},{"$f":"IF(AG13-AE13>0,1,0)","v":1},{"$f":"IF(AG13-AE13<0,1,0)","v":0}]
[null,"Cycle & Micro-Mobility","None",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cycle & Micro-Mobility",{"$f":"IF($D$50=\"Yes\",F14,_xlfn.XLOOKUP(C14,'Data validation'!A4:A10,'Data validation'!E4:E10))","v":"E"},{"$f":"_xlfn.XLOOKUP(AD14,'Data validation'!$J$23:$J$30,'Data validation'!$I$23:$I$30)","v":"E"},{"$f":"_xlfn.XLOOKUP(AB14,'Data validation'!$I$23:$I$30,'Data validation'!$J$23:$J$30)","v":2},{"$f":"IF(C24=\"\",0,_xlfn.XLOOKUP(C24,'Data validation'!$I$24:$I$30,'Data validation'!$J$24:$J$30,0))","v":2},{"$f":"IF(AE14<$AD14,$AD14-AE14,0)","v":0},{"$f":"IF(LEN($D24)=1,_xlfn.XLOOKUP(D24,'Data validation'!$I$23:$I$30,'Data validation'!$J$23:$J$30),IF(D24=\"\",0,_xlfn.XLOOKUP(D24,'Data validation'!$A$23:$A$28,'Data validation'!$B$23:$B$28,0))*2+AE14)","v":3},{"$f":"IF(AG14<0,0,IF(AG14>6,6,AG14))","v":3},{"$f":"IF(AH14<$AD14,$AD14-AG14,0)","v":0},{"$f":"AF14-AI14","v":0},{"$f":"IF(AG14-AE14>0,1,0)","v":1},{"$f":"IF(AG14-AE14<0,1,0)","v":0}]
[null,"Public Transport","None",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Public Transport",{"$f":"IF($D$50=\"Yes\",F15,_xlfn.XLOOKUP(C15,'Data validation'!G4:G11,'Data validation'!K4:K11))","v":"F"},{"$f":"_xlfn.XLOOKUP(AD15,'Data validation'!$J$23:$J$30,'Data validation'!$I$23:$I$30)","v":"F"},{"$f":"_xlfn.XLOOKUP(AB15,'Data validation'!$I$23:$I$30,'Data validation'!$J$23:$J$30)","v":1},{"$f":"IF(C25=\"\",0,_xlfn.XLOOKUP(C25,'Data validation'!$I$24:$I$30,'Data validation'!$J$24:$J$30,0))","v":2},0,{"$f":"IF(LEN($D25)=1,_xlfn.XLOOKUP(D25,'Data validation'!$I$23:$I$30,'Data validation'!$J$23:$J$30),IF(D25=\"\",0,_xlfn.XLOOKUP(D25,'Data validation'!$A$23:$A$28,'Data validation'!$B$23:$B$28,0))*2+AE15)","v":1},{"$f":"IF(AG15<0,0,IF(AG15>6,6,AG15))","v":1},{"$f":"IF(AH15<$AD15,$AD15-AG15,0)","v":0},{"$f":"AF15-AI15","v":0},{"$f":"IF(AG15-AE15>0,1,0)","v":0},{"$f":"IF(AG15-AE15<0,1,0)","v":1}]
[null,"Freight","None",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Freight",{"$f":"IF($D$50=\"Yes\",F16,_xlfn.XLOOKUP(C16,'Data validation'!M4:M11,'Data validation'!Q4:Q11))","v":"E"},{"$f":"_xlfn.XLOOKUP(AD16,'Data validation'!$J$23:$J$30,'Data validation'!$I$23:$I$30)","v":"F-"},{"$f":"IF($D$50=\"Yes\",_xlfn.XLOOKUP(AB16,'Data validation'!$I$23:$I$30,'Data validation'!$J$23:$J$30),_xlfn.XLOOKUP(AB16,'Data validation'!$I$23:$I$30,'Data validation'!$J$23:$J$30)+_xlfn.XLOOKUP($C$18,'Data validation'!$AD$4:$AD$15,'Data validation'!$AF$4:$AF$15))","v":0},{"$f":"IF(C26=\"\",0,_xlfn.XLOOKUP(C26,'Data validation'!$I$24:$I$30,'Data validation'!$J$24:$J$30,0))","v":2},0,{"$f":"IF(LEN($D26)=1,_xlfn.XLOOKUP(D26,'Data validation'!$I$23:$I$30,'Data validation'!$J$23:$J$30),IF(D26=\"\",0,_xlfn.XLOOKUP(D26,'Data validation'!$A$23:$A$28,'Data validation'!$B$23:$B$28,0))*2+AE16)","v":1},{"$f":"IF(AG16<0,0,IF(AG16>6,6,AG16))","v":1},{"$f":"IF(AH16<$AD16,$AD16-AG16,0)","v":0},{"$f":"AF16-AI16","v":0},{"$f":"IF(AG16-AE16>0,1,0)","v":0},{"$f":"IF(AG16-AE16<0,1,0)","v":1}]
[null,"General Traffic","Local Roads and Others",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Traffic",{"$f":"IF($D$50=\"Yes\",F17,_xlfn.XLOOKUP(C17,'Data validation'!S4:S9,'Data validation'!W4:W9))","v":"E"},{"$f":"_xlfn.XLOOKUP(AD17,'Data validation'!$J$23:$J$30,'Data validation'!$I$23:$I$30)","v":"F-"},{"$f":"IF($D$50=\"Yes\",_xlfn.XLOOKUP(AB17,'Data validation'!$I$23:$I$30,'Data validation'!$J$23:$J$30),_xlfn.XLOOKUP(AB17,'Data validation'!$I$23:$I$30,'Data validation'!$J$23:$J$30)+_xlfn.XLOOKUP($C$18,'Data validation'!$AD$4:$AD$15,'Data validation'!$AF$4:$AF$15))","v":0},{"$f":"IF(C27=\"\",0,_xlfn.XLOOKUP(C27,'Data validation'!$I$24:$I$30,'Data validation'!$J$24:$J$30,0))","v":2},0,{"$f":"IF(LEN($D27)=1,_xlfn.XLOOKUP(D27,'Data validation'!$I$23:$I$30,'Data validation'!$J$23:$J$30),IF(D27=\"\",0,_xlfn.XLOOKUP(D27,'Data validation'!$A$23:$A$28,'Data validation'!$B$23:$B$28,0))*2+AE17)","v":1},{"$f":"IF(AG17<0,0,IF(AG17>6,6,AG17))","v":1},{"$f":"IF(AH17<$AD17,$AD17-AG17,0)","v":0},{"$f":"AF17-AI17","v":0},{"$f":"IF(AG17-AE17>0,1,0)","v":0},{"$f":"IF(AG17-AE17<0,1,0)","v":1}]
[null,"Land Use (AUP)","Centre - City Centre & Metropolitan Centre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loading",{"$f":"_xlfn.XLOOKUP(C18,'Data validation'!Y9:Y12,'Data validation'!AB9:AB12)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(C28=\"\",0,_xlfn.XLOOKUP(C28,'Data validation'!$I$24:$I$30,'Data validation'!$J$24:$J$30,0))","v":0},null,null,{"$f":"IF(D28=\"\",0,_xlfn.XLOOKUP(D28,'Data validation'!$I$23:$I$30,'Data validation'!$J$23:$J$30,0))","v":0}]
[null,"Loading","N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parking",{"$f":"_xlfn.XLOOKUP(C19,'Data validation'!Y10:Y13,'Data validation'!AB10:AB13)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(C29=\"\",0,_xlfn.XLOOKUP(C29,'Data validation'!$I$24:$I$30,'Data validation'!$J$24:$J$30,0))","v":0},null,null,{"$f":"IF(D29=\"\",0,_xlfn.XLOOKUP(D29,'Data validation'!$I$23:$I$30,'Data validation'!$J$23:$J$30,0))","v":0}]
[null,"Parking","N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Land Use"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals",null,null,null,null,{"$f":"SUM(AF13:AF20)","v":3},null,null,{"$f":"SUM(AI13:AI20)","v":2},{"$f":"SUM(AJ13:AJ20)","v":1},{"$f":"SUM(AK13:AK20)","v":2},{"$f":"SUM(AL13:AL20)","v":3},null,null,null,"Difference - Base to Assessed"]
[null,null,"Observed LoS*","Assessed Project Impact\n(Impact or LoS*)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Negative","Positive"]
["Observed and Assessed Levels of Service","Walking","E","Moderately positive",null,null,"Fit Assessment Result",null,{"$f":"_xlfn.XLOOKUP(AC45,'Data validation'!$D$23:$D$25,'Data validation'!$C$23:$C$25,\"\")","v":"High likelihood of supporting the intent of the Auckland Network Operating Plan (ANOP) and Future Connect"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH13-AE13<0,AE13-AH13,0)","v":0},{"$f":"IF(AH13-AE13>0,AH13-AE13,0)","v":1}]
[null,"Cycle & Micro-Mobility","E","Moderately positive",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH14-AE14<0,AE14-AH14,0)","v":0},{"$f":"IF(AH14-AE14>0,AH14-AE14,0)","v":1}]
[null,"Public Transport","E","F",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH15-AE15<0,AE15-AH15,0)","v":1},{"$f":"IF(AH15-AE15>0,AH15-AE15,0)","v":0}]
[null,"Freight","E","F",null,null,"Likely Emissions Outcomes",null,"Functionality to be added",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH16-AE16<0,AE16-AH16,0)","v":1},{"$f":"IF(AH16-AE16>0,AH16-AE16,0)","v":0}]
[null,"General Traffic","E","F",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH17-AE17<0,AE17-AH17,0)","v":1},{"$f":"IF(AH17-AE17>0,AH17-AE17,0)","v":0}]
[null,"Loading    * placeholder *",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AN28-AE18<0,AE18-AN28,0)","v":0},{"$f":"IF(AN28-AE18>0,AN28-AE18,0)","v":0}]
[null,"Parking    * placeholder *",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[]
[]
[null,"Notes"]
[null,"Conclusions"]
[]
[]
[]
[]
[null,"Simple Assessment Result",null,null,"Criteria"]
[null,{"$f":"'Data validation'!C22","v":"Future Connect Fit Assessment Result"},null,null,"a. At least one mode LoS is improved and no mode LoS deteriorates,            OR",null,null,null,null,null,null,{"$f":"IF(AB39=1,\"ü\",\"û\")","v":"û"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High likelihood",{"$f":"IF(AK21>0,IF(AL21=0,1,0),0)","v":0},{"$f":"IF(AB39=1,\"True\",\"False\")","v":"False"}]
[null,null,null,null,"b. Sum of LoS deficits to acceptable targets is reduced,                                       AND",null,null,null,null,null,null,"ü",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ21>0,1,0)","v":1},{"$f":"IF(AB40+AB41=2,\"True\",\"False\")","v":"True"}]
[null,null,null,null,"c. No single mode LoS deteriorates and is below acceptable target LoS",null,null,null,null,null,null,"ü",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MIN(AJ13:AJ17)<0,0,1)","v":1}]
[null,{"$f":"'Data validation'!$C$24","v":"Moderate likelihood of supporting the Auckland Network Operating Plan (ANOP) and Future Connect"},null,null,"a. Sum of LoS deficits to acceptable targets is reduced,                                         OR",null,null,null,null,null,null,"ü",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Med likelihood",{"$f":"AB40","v":1},{"$f":"IF(AB42=1,\"True\",\"False\")","v":"True"}]
[null,null,null,null,"b. No change to overall LoS deficit to acceptable targets and at least one mode LoS is improved",null,null,null,null,null,null,"û",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ21=0,IF(AK21>0,1,0),0)","v":0},{"$f":"IF(AB43=1,\"True\",\"False\")","v":"False"}]
[null,"Low likelihood of supporting the Auckland Network Operating Plan (ANOP) and Future Connect",null,null,"Any other result",null,null,null,null,null,null,"û",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low Likelihood",{"$f":"IF(AC39=\"True\",0,IF(AC40=\"True\",0,IF(AC42=\"True\",0,IF(AC43=\"True\",0,1))))","v":0},{"$f":"IF(AB44=1,\"True\",\"False\")","v":"False"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outcome",{"$f":"IF(AC39=\"True\",\"H\",IF(AC40=\"True\",\"H\",IF(AC42=\"True\",\"M\",IF(AC43=\"True\",\"M\",\"L\"))))","v":"H"}]
[null,"Additional notes"]
[null,"* For Level of Service Definitions for each mode please refer to pages 10 and 11 of"]
[null,"Application of the Auckland Network Operating Plan, August 2022"]
[]
[null,null,"Manually enter Acceptable Target LoS?","No"]

{"sheet":"LoS Targets","index":1,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":true,"merged":[[29,0,31,0],[0,13,0,15],[1,2,1,4],[1,13,1,15],[3,0,6,0],[14,0,20,0],[21,0,28,0],[7,0,13,0]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Not used"]
[null,null,"LoS Targets\n(from ANOP 2021/24)",null,null,null,null,null,null,null,null,null,null,"DRAFT Minimum Acceptable LoS"]
["Mode","Strategic network type","LOS AM peak","LOS Off Peak","LOS PM Peak",null,null,null,null,null,null,null,null,"LOS AM peak","LOS Off Peak","LOS PM Peak"]
["PEDESTRIANS","Primary ^","B","B","B",null,null,null,null,null,null,null,null,"C","C","C"]
[null,"Secondary ^","C","C","C",null,null,null,null,null,null,null,null,"D","D","D"]
[null,"Tertiary","D","D","D"]
[null,"Private Roads","D","D","D"]
["CYCLE","Regional ^","B","B","B",null,null,null,null,null,null,null,null,"C","C","C"]
[null,"Major ^","B","B","B",null,null,null,null,null,null,null,null,"C","C","C"]
[null,"Connector","C","C","C"]
[null,"Leisure","D","D","D"]
[null,"Local","D","D","D"]
[null,"Sports","D","D","D"]
[null,"None *","E","E","E"]
["PUBLIC TRANSPORT","Rapid Transit ^","B","B","B",null,null,null,null,null,null,null,null,"C","C","C"]
[null,"Frequent Transit 1 ^","C","C","C",null,null,null,null,null,null,null,null,"D","D","D"]
[null,"Frequent Transit 2 ^","D","C","D",null,null,null,null,null,null,null,null,"E","D","E"]
[null,"Other Strategic PT Corridor","D","C","D"]
[null,"Connector Transit Network","D","D","D"]
[null,"Local Transit Network","E","E","E"]
[null,"Peak Transit Network","D","NA","D"]
["FREIGHT","Level 1A * ^","C","B","C",null,null,null,null,null,null,null,null,"D","C","D"]
[null,"Level 1B * ^","C","D","C",null,null,null,null,null,null,null,null,"D","E","D"]
[null,"Level 2 *","D","D","D"]
[null,"Level 3 *","D","D","D"]
[null,"Overweight & Overdimension only *","D","D","D"]
[null,"Overdimension only *","D","D","D"]
[null,"Overweight only *","D","D","D"]
[null,"None *","E","E","E"]
["GENERAL TRAFFIC","Motorway ^","C","C","C",null,null,null,null,null,null,null,null,"D","D","D"]
[null,"Strategic and Primary Arterial * ^","C","C","C",null,null,null,null,null,null,null,null,"D","D","D"]
[null,"Secondary Arterial * ^","C","D","C",null,null,null,null,null,null,null,null,"D","E","D"]
[null,"Collector *","D","E","D"]
[null,"Local Roads and Others *","E","E","E"]
["* General and Freight traffic routes within activity centres, or where provision for PT and/or active modes demand higher priority, lower LOS for general traffic will apply. "]
["^ from ANOP 2021/24"]

{"sheet":"Data validation","index":2,"n_rows":35,"n_cols":34,"rows_kept":35,"cut":false,"hidden":true,"merged":[[21,2,21,3],[1,0,1,5],[1,6,1,11],[1,12,1,17],[1,18,1,23],[21,5,21,6],[2,1,2,2],[2,7,2,8],[2,13,2,14],[2,19,2,20],[21,8,21,9],[1,29,1,33],[1,24,1,28],[2,25,2,26],[21,10,21,11],[21,12,21,13]]}
["Modal Factors"]
["Cycle & Micro-Mobility",null,null,null,null,null,"Public Transport",null,null,null,null,null,"Freight",null,null,null,null,null,"General Traffic",null,null,null,null,null,"Walking",null,null,null,null,"Land Use"]
["Heirarchy","Typical peak volumes (/h)",null,"RPF","LoS Target","Pass/Fail","Heirarchy","Typical peak volumes (/h)",null,"RPF","LoS Target","Pass/Fail","Heirarchy","Typical peak volumes (/h)",null,"RPF","LoS Target","Pass/Fail","Heirarchy","Typical peak volumes (/h)",null,"RPF","LoS Target","Pass/Fail","Heirarchy","Typical peak volumes (/h)",null,"LoS Target","RPF","Heirarchy","Walking Volume multiplier","Impact on LoS for Freight and GT","RPF","Pass/Fail"]
["Regional","200-500",350,2,{"$f":"'LoS Targets'!C8","v":"B"},1,"Rapid Transit Network","60-120",100,2,{"$f":"'LoS Targets'!C15","v":"B"},1,"Level 1A","100-200",150,2,{"$f":"'LoS Targets'!C22","v":"C"},1,"Motorway","4000-8000",{"$f":"3*2000","v":6000},2,{"$f":"'LoS Targets'!C30","v":"C"},1,"Primary","200-400",300,{"$f":"'LoS Targets'!C4","v":"B"},2,"Centre - City Centre & Metropolitan Centre",null,-2,1.5,1]
["Major","100-300",200,2,{"$f":"'LoS Targets'!C9","v":"B"},1,"Frequent Transit Network 1","20-60",30,2,{"$f":"'LoS Targets'!C16","v":"C"},1,"Level 1B","50-100",75,2,{"$f":"'LoS Targets'!C23","v":"C"},1,"Strategic Arterial","2000-4000",3000,2,{"$f":"'LoS Targets'!C31","v":"C"},1,"Secondary","100-200",150,{"$f":"'LoS Targets'!C5","v":"C"},1,"Centre - Town & Local Centre Zone",null,-1,1,0]
["Connector","50-100",75,1,{"$f":"'LoS Targets'!C10","v":"C"},1,"Frequent Transit Network 2","10-20",15,2,{"$f":"'LoS Targets'!C17","v":"D"},1,"Level 2","30-50",40,1,{"$f":"'LoS Targets'!C24","v":"D"},0,"Primary Arterial","1000-2000",1500,1.5,{"$f":"'LoS Targets'!C31","v":"C"},0,"Tertiary","50-100",75,{"$f":"'LoS Targets'!C6","v":"D"},1,"Centre - Neighbourhood Centre Zone",null,0,1,0]
["Leisure","20-50",35,0.5,{"$f":"'LoS Targets'!C11","v":"D"},0,"Other Strategic PT Corridor","10-20",15,2,{"$f":"'LoS Targets'!C18","v":"D"},0,"Level 3","20-30",25,1,{"$f":"'LoS Targets'!C25","v":"D"},0,"Secondary Arterial","500-1000",750,1,{"$f":"'LoS Targets'!C32","v":"C"},0,"Private Roads","0-50",25,{"$f":"'LoS Targets'!C7","v":"D"},0.5,"Healthcare facility, hospital",null,-1,1.5,1]
["Local","20-50",35,0.5,{"$f":"'LoS Targets'!C12","v":"D"},0,"Connector Transit Network","4-10",6,1,{"$f":"'LoS Targets'!C19","v":"D"},0,"Overweight & Overdimension only","10-20",15,0.5,{"$f":"'LoS Targets'!C26","v":"D"},0,"Collector","250-500",375,0.5,{"$f":"'LoS Targets'!C33","v":"D"},0,null,null,null,null,null,"Arena / Stadium, Major Recreational Facility, ",null,-1,1.5,1]
["Sports","20-50",35,0.5,{"$f":"'LoS Targets'!C13","v":"D"},0,"Local Transit Network","2-6",4,0.5,{"$f":"'LoS Targets'!C20","v":"E"},0,"Overdimension only","10-20",15,0.5,{"$f":"'LoS Targets'!C27","v":"D"},0,"Local Roads and Others","0-250",125,0.5,{"$f":"'LoS Targets'!C34","v":"E"},0,null,null,null,null,null,"RTN Station, Bus Interchange, Ferry Terminals",null,-1,1.5,1]
["None","0-20",10,0.5,"E",0,"Peak Transit Network","2-6",4,0.5,{"$f":"'LoS Targets'!C21","v":"D"},0,"Overweight only","10-20",15,0.5,{"$f":"'LoS Targets'!C28","v":"D"},0,null,null,null,null,null,null,null,null,null,null,null,"Education - Tertiary Institures, Primary and Secondary School",null,-1,1.5,1]
[null,null,null,null,null,null,"None",0,0,0.5,"F",0,"None","0-10",5,0.5,{"$f":"'LoS Targets'!C29","v":"E"},0,null,null,null,null,null,null,null,null,null,null,null,"Residential - Terraced Housing and Apartment Blocks",null,-1,1,0]
["Yellow = values to be reviewed & confirmed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential - Single House, Mixed Housing Suburban, Mixed Housing Urban",null,0,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential - Large Lot, Rural and Coastal Settlement",null,0,1,0]
["Default Values","Occupancy (people or people equivalent for freight)","Value of time ($/hr) from MBCM tables 13 & 15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Business - Mixed Use Zone, General Business, Business Park, Heavy Industry, Light Industry, Freight Areas",null,0,1,0]
["Walking",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Others",null,0,1,0]
["Cycle & Micro-Mobility",1]
["Public Transport",50]
["Freight",{"$f":"C18/C19","v":3.8974358974358978},{"$f":"7.8+(17.1+28.1)/2","v":30.400000000000002}]
["General Traffic",1.2,{"$f":"7.8","v":7.8}]
[]
["Other Lookup Values"]
["Project Impact",null,"Future Connect Fit Assessment Result",null,"Roads and Streets Framework Modal Priorities","Roads and Streets Framework Fit Assessment Result",null,"Evaluation Type","RASF Level of service",null,"FC Level of service",null,"Project impact"]
["Very Positive",2,"High likelihood of supporting the intent of the Auckland Network Operating Plan (ANOP) and Future Connect","H",0,"High likelihood of supporting the intent of the Auckland Network Operating Plan (ANOP) and Roads and Streets Framework Priorities","H","Simple","A +",7,"A",0,-3,"Negative",null,"Yes"]
["Positive",1,"Moderate likelihood of supporting the Auckland Network Operating Plan (ANOP) and Future Connect","M",1,"Moderate likelihood of supporting the Auckland Network Operating Plan (ANOP) and Roads and Streets Framework Priorities","M","Simple + Volumes","A",6,"B",0.5,-2.5,"Negative",null,"No"]
["Moderately positive",0.5,"Low likelihood of supporting the Auckland Network Operating Plan (ANOP) and Future Connect","L",2,"Low likelihood of supporting the Auckland Network Operating Plan (ANOP) and Roads and Streets Framework Priorities","L","LoS Evaluation","B",5,"C",1,-2,"Negative"]
["Neutral",0,null,null,3,null,null,"LoS Evaluation + Volumes","C",4,"D",1.5,-1.5,"Negative"]
["Moderately negative",-0.5,null,null,4,null,null,null,"D",3,"E",2,-1,"Negative"]
["Negative",-1,null,null,5,null,null,null,"E",2,"F",2.5,-0.5,"Moderately negative"]
["A",null,null,null,6,null,null,null,"F",1,"F-",3,0,"Neutral"]
["B",null,null,null,7,null,null,null,"F-",0,null,null,0.5,"Moderately positive"]
["C",null,null,null,null,null,null,null,null,null,null,null,1,"Positive"]
["D",null,null,null,null,null,null,null,null,null,null,null,1.5,"Positive"]
["E",null,null,null,null,null,null,null,null,null,null,null,2,"Positive"]
["F",null,null,null,null,null,null,null,null,null,null,null,2.5,"Positive"]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"Positive"]