{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Crash Cushion","Gantry","CCTV Masts","High Mast light Towers","Noise Wall","Features","Lookups"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":26,"comments":5,"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":"Crash Cushion","index":0,"n_rows":49,"n_cols":28,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[null,"system_id","road_id",null,"location","side","offset","cc_location_desc","easting","northing","gps_date",null,"gps_by","feature","type","make","material","number_bays","cc_width","construct_date","condition",null,"condition_date","external_id",null,"collect_name","collect_date","notes"]
["Action","Crash Cushion  ID","Road ID","SH-RS-D  (e.g. 016-0000-B) letter must be uppercase","Location (m)","Side","Offset","Location Description ","easting","northing","GPS Date","GPS organisation ","gps_by","Crash Cushion Feature","Cushion Type","Cushion make","Crash Cushion Material","No. of Bays","Width (m)","Construction date","Condition ","condition code","condition date ","External id","Collected By Desc","Collected by","Collected On","Notes"]
[null,{"$f":"IF(A4=\"ADD\",\"0\",\"\")","v":""},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&D4&\"/\"&E4&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,null,null,null,null,null,{"$f":"IF(L4=\"\",\"\",VLOOKUP(L4,Controlledby,2,FALSE))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(U4=\"\",\"\",(VLOOKUP(U4,condition_Desc,2,FALSE)))","v":""},null,null,null,{"$f":"IF(Y4=\"\",\"\",VLOOKUP(Y4,Controlledby,2,FALSE))","v":""}]
[null,{"$f":"IF(A5=\"ADD\",\"0\",\"\")","v":""},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&D5&\"/\"&E5&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,null,null,null,null,null,{"$f":"IF(L5=\"\",\"\",VLOOKUP(L5,Controlledby,2,FALSE))","v":""},null,null,null,null,null,null,null,null,"",null,null,null,{"$f":"IF(Y5=\"\",\"\",VLOOKUP(Y5,Controlledby,2,FALSE))","v":""}]
[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,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,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,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,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,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,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",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,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,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,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,""]
[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,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,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,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,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,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,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",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,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,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,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,""]
[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,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,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(Y48=\"\",\"\",VLOOKUP(Y48,Controlledby,2,FALSE))","v":""}]
["xx","xx",null,"xx","xx","xx","xx",null,null,null,null,"xx","xx","xx",null,"xx","xx","xx","xx","xx",null,"",null,null,"xx","xx","xx","xx"]

{"sheet":"Gantry","index":1,"n_rows":49,"n_cols":30,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[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,"controlled_by","collect_date"]
[null,"system_id","road_id",null,"location","side","offset","gantry_location","easting","northing","gps_date",null,"gps_by","feature","type","material","sign_notes",null,"length","height","clearance","construct_date","condition",null,"condition_date","external_id",null,"collect_name","collect_date","notes"]
["Action","Gantry ID","Road ID","SH-RS-D  (e.g. 016-0000-B) letter must be uppercase","Location (m)","Side","Offset","Location Description ","easting","northing","GPS Date","GPS organisation ","gps_by","Gantry Feature","Gantry Type","Gantry Material","Sign Notes","Gantry Notes","Length","Height","Clearance","Construction date","Condition ","condition code","condition date ","External id","Collected By Desc","Collected by","Collected On","Notes"]
[null,{"$f":"IF(A4=\"ADD\",\"0\",\"\")","v":""},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&D4&\"/\"&E4&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,null,null,null,null,null,{"$f":"IF(L4=\"\",\"\",VLOOKUP(L4,Controlledby,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W4=\"\",\"\",(VLOOKUP(W4,condition_Desc,2,FALSE)))","v":""},null,null,null,{"$f":"IF(AA4=\"\",\"\",VLOOKUP(AA4,Controlledby,2,FALSE))","v":""}]
[null,{"$f":"IF(A5=\"ADD\",\"0\",\"\")","v":""},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&D5&\"/\"&E5&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,null,null,null,null,null,{"$f":"IF(L5=\"\",\"\",VLOOKUP(L5,Controlledby,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,"",null,null,null,{"$f":"IF(AA5=\"\",\"\",VLOOKUP(AA5,Controlledby,2,FALSE))","v":""}]
[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,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,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,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,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,"",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,"",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,"","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,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,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,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,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,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,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,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,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,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,"",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,"",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,"","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,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,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,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,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,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,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,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,null,null,null,null,"",null,null,null,""]
["xx","xx",null,"xx","xx","xx","xx",null,null,null,null,"xx","xx","xx","xx","xx","xx","xx","xx","xx","xx","xx",null,"",null,null,"xx","xx","xx","xx"]

{"sheet":"CCTV Masts","index":2,"n_rows":49,"n_cols":27,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"controlled_by","collect_date"]
[null,"system_id","road_id",null,"location","cctv_location_desc","side","offset","easting","northing","gps_date",null,"gps_by",null,"pole_type",null,"cctv_material","cctv_no","construct_date","condition",null,"condition_date","external_id",null,"collect_name","collect_date","notes"]
["Action","CCTV Mast ID","Road ID","SH-RS-D  (e.g. 016-0000-B) letter must be uppercase","Location (m)","Location Description ","Side","Offset","easting","northing","GPS Date","GPS organisation ","gps_by","CCTV Mast Type Desc","Mast Type Code","Pole Material Desc","Pole Material Code","CCTV NO","Construction date","Condition ","condition code","condition date ","External id","Collected By Desc","Collected by","Collected On","Notes"]
[null,{"$f":"IF(A4=\"ADD\",\"0\",\"\")","v":""},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&D4&\"/\"&E4&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,null,null,null,null,null,{"$f":"IF(L4=\"\",\"\",VLOOKUP(L4,Controlledby,2,FALSE))","v":""},null,{"$f":"IF(N4=\"\",\"\",VLOOKUP(N4,cctvpoletypedesc,2,FALSE))","v":""},null,{"$f":"IF(P4=\"\",\"\",VLOOKUP(P4,cctvpolematdesc,2,FALSE))","v":""},null,null,null,{"$f":"IF(T4=\"\",\"\",(VLOOKUP(T4,condition_Desc,2,FALSE)))","v":""},null,null,null,{"$f":"IF(X4=\"\",\"\",VLOOKUP(X4,Controlledby,2,FALSE))","v":""}]
[null,{"$f":"IF(A5=\"ADD\",\"0\",\"\")","v":""},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&D5&\"/\"&E5&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,null,null,null,null,null,{"$f":"IF(L5=\"\",\"\",VLOOKUP(L5,Controlledby,2,FALSE))","v":""},null,"",null,"",null,null,null,"",null,null,null,{"$f":"IF(X5=\"\",\"\",VLOOKUP(X5,Controlledby,2,FALSE))","v":""}]
[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,""]
[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,""]
[null,"","null",null,null,null,null,null,null,null,null,null,"",null,"",null,{"$f":"IF(P10=\"\",\"\",VLOOKUP(P10,cctvpolematdesc,2,FALSE))","v":""},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,"",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,"",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,"",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,"",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,"",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,"",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,"",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,"",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,"",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,"",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,"",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,"",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(N36=\"\",\"\",VLOOKUP(N36,cctvpoletypedesc,2,FALSE))","v":""},null,{"$f":"IF(P36=\"\",\"\",VLOOKUP(P36,cctvpolematdesc,2,FALSE))","v":""},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,"",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,"",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,"",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,"",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,"",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,"",null,null,null,"",null,null,null,""]
["xx","xx",null,"xx","xx",null,"xx","xx",null,null,null,"xx","xx","xx","xx","xx","xx","xx","xx",null,"",null,null,"xxx","xxx","xxx","xx"]

{"sheet":"High Mast light Towers","index":3,"n_rows":49,"n_cols":26,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"controlled_by","collect_date"]
[null,"system_id","road_id",null,"location","side","offset","loc_desc","easting","northing","gps_date",null,"gps_by",null,"pole_type",null,"material","construct_date","condition",null,"condition_date","external_id",null,"collect_name","collect_date","notes"]
["Action","High Mast Light Towers ID","Road ID","SH-RS-D  (e.g. 016-0000-B) letter must be uppercase","Location (m)","Side","Offset","Location  Description","easting","northing","GPS Date","GPS organisation ","gps_by","Pole Type Description","Pole Type Code","Material Description","Material Code","Construction date","Condition ","condition code","condition date ","External id","Collected By Desc","Collected by","Collected On","notes"]
[null,{"$f":"IF(A4=\"ADD\",\"0\",\"\")","v":""},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&D4&\"/\"&E4&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,null,null,null,null,null,{"$f":"IF(L4=\"\",\"\",VLOOKUP(L4,Controlledby,2,FALSE))","v":""},null,{"$f":"IF(N4=\"\",\"\",VLOOKUP(N4,HML_poletypecode,2,FALSE))","v":""},null,{"$f":"IF(P4=\"\",\"\",VLOOKUP(P4,HMLTmaterialcode,2,FALSE))","v":""},null,null,{"$f":"IF(S4=\"\",\"\",(VLOOKUP(S4,condition_Desc,2,FALSE)))","v":""},null,null,null,{"$f":"IF(W4=\"\",\"\",VLOOKUP(W4,Controlledby,2,FALSE))","v":""}]
[null,"",{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&D5&\"/\"&E5&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,null,null,null,null,null,{"$f":"IF(L5=\"\",\"\",VLOOKUP(L5,Controlledby,2,FALSE))","v":""},null,"",null,"",null,null,"",null,null,null,{"$f":"IF(W5=\"\",\"\",VLOOKUP(W5,Controlledby,2,FALSE))","v":""}]
[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",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,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,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,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,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,"",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,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,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,""]
[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",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,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,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,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,null,"",null,"",null,"",null,null,"",null,null,null,""]
[null,"","null",null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(N36=\"\",\"\",VLOOKUP(N36,HML_poletypecode,2,FALSE))","v":""},null,{"$f":"IF(P36=\"\",\"\",VLOOKUP(P36,HMLTmaterialcode,2,FALSE))","v":""},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,"",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,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,"","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,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,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,""]
["xx","xx","null","xx","xx","xx","xx","xx",null,null,null,"xx","xx","xx","xx","xx","xx","xx",null,"",null,null,"xx","xx","xx","xx"]

{"sheet":"Noise Wall","index":4,"n_rows":49,"n_cols":30,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[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,"controlled_by","collect_date"]
[null,"system_id","road_id",null,null,"start_m","end_m","side","offset","location","offset","noise_location","easting","northing","gps_date",null,"gps_by","feature","wall_mat","max_height","min_height","construct_date","condition",null,"condition_date","external_id",null,"collect_name","collect_date","notes"]
["Action","Noise Wall ID","id_start","id_end","SH-RS-D  (e.g. 016-0000-B) letter must be uppercase","Start (m)","End (m)","Side","Offset","Location (m)","Offset","Location  Description","easting","northing","GPS Date","GPS organisation ","gps_by","Noise wall Feature","Noise Wall Material","Max Height","Min Height","Construction date","Condition ","condition code","condition date ","External id","Collected By Desc","Collected by","Collected On","notes"]
[null,{"$f":"IF(A4=\"ADD\",\"0\",\"\")","v":""},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&E4&\"/\"&F4&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&E4&\"/\"&G4&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P4=\"\",\"\",VLOOKUP(P4,Controlledby,2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(W4=\"\",\"\",(VLOOKUP(W4,condition_Desc,2,FALSE)))","v":""},null,null,null,{"$f":"IF(AA4=\"\",\"\",VLOOKUP(AA4,Controlledby,2,FALSE))","v":""}]
[null,{"$f":"IF(A5=\"ADD\",\"0\",\"\")","v":""},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&E5&\"/\"&F5&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&E5&\"/\"&G5&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P5=\"\",\"\",VLOOKUP(P5,Controlledby,2,FALSE))","v":""},null,null,null,null,null,null,"",null,null,null,{"$f":"IF(AA5=\"\",\"\",VLOOKUP(AA5,Controlledby,2,FALSE))","v":""}]
[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,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,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,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,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,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(A15=\"ADD\",\"0\",\"\")","v":""},"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,"",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,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,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,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,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,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",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,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,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,"",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,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,"","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,"",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,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,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,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,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,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",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,""]
[null,{"$f":"IF(A46=\"ADD\",\"0\",\"\")","v":""},"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(AA46=\"\",\"\",VLOOKUP(AA46,Controlledby,2,FALSE))","v":""}]
[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,null,"",null,null,null,null,null,null,"",null,null,null,""]
["xx","xx","null","null","xx","xx","xx","xx","xx",null,null,null,null,null,"xx","xx","xx","xx","xx",null,null,"xx",null,"",null,null,"xx","xx","xx","xx"]

{"sheet":"Features","index":5,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,"feature_id",null,null,"location","carrway_start_m","side",null,"feature_type",null,null,"controlled_by","collect_date","notes"]
[null,null,null,null,null,null,null,null,null,"construct_date",null,"collect_name","collect_date","notes"]
["Action","Feature ID","Road ID","SH-RS-D  (e.g. 016-0000-B) letter must be uppercase","Location","Carriageway Start","Side","Feature Desc","Feature Type","Construction date","Collected By Desc","Collected by","Collected On","notes"]
[null,{"$f":"IF(A4=\"add\",0,\"\")","v":""},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&D4&\"/\"&E4&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,null,{"$f":"IF(H4=\"\",\"\",VLOOKUP(H4,FeatureTypeDesc,2,FALSE))","v":""},null,null,{"$f":"IF(K4=\"\",\"\",VLOOKUP(K4,Controlledby,2,FALSE))","v":""}]
[null,"",{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&D5&\"/\"&E5&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,null,"",null,null,{"$f":"IF(K5=\"\",\"\",VLOOKUP(K5,Controlledby,2,FALSE))","v":""}]
[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",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,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,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,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,"","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,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,null,null,"",null,null,""]
[null,{"$f":"IF(A36=\"add\",0,\"\")","v":""},"null",null,null,null,null,null,{"$f":"IF(H36=\"\",\"\",VLOOKUP(H36,FeatureTypeDesc,2,FALSE))","v":""},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,""]
[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",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,""]
["xxx","xxx",null,"xxx","xxx","xxx","xxx","xxx","xxx","xx","xx","xx","xx","xxx"]

{"sheet":"Lookups","index":6,"n_rows":159,"n_cols":50,"rows_kept":159,"cut":false,"hidden":false,"merged":[]}
["Action","Side",null,"High Mast light towers",null,null,null,null,null,"Gantry",null,null,null,null,null,null,null,null,"CCTV Masts",null,null,null,null,null,"Noise Wall",null,null,null,null,null,"Crash Cushion",null,null,null,null,null,null,null,null,null,null,null,"Feature "]
["ADD","L",null,"Material Description","Material",null,"Pole Type description","Pole Type",null,"Type","Type Description",null,"Material","Material Description",null,"Feature","Feature Description",null,"Pole type Description","Pole type",null,"Pole Material Description","Pole Material",null,"Feature","Feature Description",null,"Material description","Material",null,"Feature","Feature Description",null,"Cushion Type","Cushion Type Description",null,"Cushion make description"," make",null,"Material ","Material Description",null,"Feature Type Description","Feature Type",null,"Organisation Description","Organisation",null,"condition Desc","condition "]
["UPDATE","R",null,"Aluminium","ALU",null,"Hinged","HIN",null,"PIPE","Pipe Gantry",null,"COMP","Steel Composite",null,"BUSWY","Busway",null,"Attached","ATT",null,"Alimiumn","AL",null,"BUS","Busway",null,"Concrete panels with steel posts","CONSP",null,"BUS","Busway",null,"Tau II","Universal TAU II",null,"Armorflex","ARM",null,"GALV","Galvanised Steel",null,"Cycle path","CYCLE",null,"3M","3M",null,"Excellent ",1]
["DELETE","C",null,"Others","OTH",null,"Sectional","SEC",null,"PIPEC","Pipe central",null,"DRUM","Steel Drum",null,"CYCLW","Cycleway",null,"Fixed","FIX",null,"Concrete","CON",null,"CYCLE","Cycleway",null,"Other","OTHER",null,"CYCLE","Cycleway",null,"TRACC","TR Crash Attenuating",null,"Brifen","BRF",null,"STEEL","Steel",null,"DOSLI Benchmark","DOSLI",null,"Automobile Association","AA",null,"Good ",2]
[null,null,null,"Steel","STE",null,null,null,null,"PIPEM","Pipe Mast Shoulders",null,"GALV","Galvanised Steel",null,"MAIN","Main Carriageway",null,"Hinged","HIN",null,"Fibreglass","FIBR",null,"MAIN","Main carriageway",null,"Plastic between toprailing and barrier","PLAS",null,"MAIN","Main Carriageway",null,"Quadguard","Quad Guard",null,"CSP Pacific","CSP",null,null,null,null,"Drain not maintained by TNZ","DRNOTH",null,"Auckland Council","ACC",null,"Average ",3]
[null,null,null,null,null,null,null,null,null,"PIPES","Pipe Shoulder",null,"STEEL","Steel",null,"OFFRAMP","Off Ramp",null,"Others","OTH",null,"High Steel (wind resistant)","HSTE",null,"OFF","Off Ramp",null,"Plywood","PLY",null,"OFF","Off Ramp",null,"Great","Great System Crash Units",null,"Ingal Civil","IGL",null,null,null,null,"Emergency Gates","EG",null,"Alarm Centre Installation Ltd","ACI",null,"Poor",4]
[null,null,null,null,null,null,null,null,null,"PIPEV","Pipe VMS",null,"CON","Concrete",null,"ONRAMP","On Ramp",null,"Portable","POR",null,"Not Applicable (no pole)","NA",null,"ON","On Ramp",null,"Timber","TIM",null,"ON","On Ramp",null,"CAT350","CAT350",null,"Public Domain","PUB",null,null,null,null,"High Mast Light Towers","HMLT",null,"Agfirst","AGF",null,"Very Poor",5]
[null,null,null,null,null,null,null,null,null,"PIPSV","Pipe Shoulder VMS",null,null,null,null,null,null,null,null,null,null,"Spun Concrete","SPC",null,null,null,null,"Timber panels with steel posts","TIMSP",null,null,null,null,"XTEN","X- Tenuator",null,"Safence","SAF",null,null,null,null,"Historic Building","BUILD",null,"Abley Ltd","AL",null,"Unkown ","U"]
[null,null,null,null,null,null,null,null,null,"TRUSL","Truss Lane",null,null,null,null,null,null,null,null,null,null,"Steel (Standard Steel)","STEE",null,null,null,null,"Vertical boards, timber posts","VBTP",null,null,null,null,"SCI","SCI- 100 Smart Cushion",null,"Steelgal","STEEL",null,null,null,null,"Intersection","INT",null,"Auckland Motorway Alliance","AMA"]
[null,null,null,null,null,null,null,null,null,"TRUSS","Truss Gantry",null,null,null,null,null,null,null,null,null,null,"Steel powder coated","ST",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tauren Barriers Ltd","TAURN",null,null,null,null,"Intersection T - Left","INTL",null,"Asset Management Engineers Ltd","AME"]
[null,null,null,null,null,null,null,null,null,"TRUSV","Truss VMS",null,null,null,null,null,null,null,null,null,null,"Wood","WOOD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intersection T - Right","INTR",null,"Asset Management Technicians Ltd","AMT"]
[null,null,null,null,null,null,null,null,null,"CANT","Cantilever",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,"Intersection Cross Roads","INTX",null,"Armitage Systems","ARM"]
[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,null,null,null,null,"LTPP Calibration site","CALIB",null,"Aspect Solutions Ltd","ASL"]
[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,null,null,null,null,"Local Feature","LOCAL",null,"Auckland System Management","ASM"]
[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,null,null,null,null,"Major Access","MAC",null,"Auckland Transport","AT2"]
[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,null,null,null,null,"Monument","MON",null,"Aspect Technology and Equipment Ltd","ATE"]
[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,null,null,null,null,"Permanent traffic monitoring (site do not use)","TRAF",null,"ARRB Transport Research Ltd","ATR"]
[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,null,null,null,null,"Plaque/Historic Location","PLAQUE",null,"Auckland University","AUN"]
[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,null,null,null,null,"Rail Crossing","XING",null,"Broadspectrum (NZ) Ltd","B(L"]
[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,null,null,null,null,"Rest Area","REST",null,"Bri-Ken and Associates Ltd","BAA"]
[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,null,null,null,null,"Signal Controlled Intersection","SIGINT",null,"Bartley Consultants Ltd","BAR"]
[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,null,null,null,null,"Significant Tree","TREE",null,"Bloxam Burnett & Olliver Ltd","BB&"]
[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,null,null,null,null,"Stockpile Site","PILE",null,"Beca Infrastructure","BCF"]
[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,null,null,null,null,"NZTA Reseal Test Site","RES",null,"Buller District Council","BDC"]
[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,null,null,null,null,"Trial Site","TRIAL",null,"Blacktop","BLA"]
[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,null,null,null,null,"Undefined","UNDEFI",null,"Beca Ltd.","BLT"]
[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,null,null,null,null,"BEWARE of SERVICE","SRVICE",null,"Civil Assist Ltd","CAL"]
[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,null,null,null,null,"Urban Design Feature","URBD",null,"Christchurch City Council","CCC"]
[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,null,null,null,null,null,null,null,"City Care Ltd","CCL"]
[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,null,null,null,null,null,null,null,"Currie Electrical Ltd.","CEL"]
[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,null,null,null,null,null,null,null,"Company-X Ltd.","CL"]
[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,null,null,null,null,null,null,null,"Critchlow Limited","CL2"]
[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,null,null,null,null,null,null,null,"Coastline Markers Ltd","CML"]
[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,null,null,null,null,null,null,null,"CoreLogic NZ Ltd.","CNL"]
[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,null,null,null,null,null,null,null,"Central Otago District Council","COD"]
[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,null,null,null,null,null,null,null,"Other Contractor","CON"]
[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,null,null,null,null,null,null,null,"CSL Traffic","CSL"]
[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,null,null,null,null,null,null,null,"Connell Wagner Ltd","CWL"]
[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,null,null,null,null,null,null,null,"Dunedin City Council","DCC"]
[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,null,null,null,null,null,null,null,"D & L Crowe Ltd","DLC"]
[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,null,null,null,null,null,null,null,"Spiire NZ Ltd","DWK"]
[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,null,null,null,null,null,null,null,"Excell Corporation","ECL"]
[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,null,null,null,null,null,null,null,"Ferguson Ind","FGI"]
[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,null,null,null,null,null,null,null,"Fulton Hogan (NZ) Ltd.","FUL"]
[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,null,null,null,null,null,null,null,"Gisborne District Council","GDC"]
[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,null,null,null,null,null,null,null,"Geosolve Ltd","GEO"]
[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,null,null,null,null,null,null,null,"GHD Ltd.","GHD"]
[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,null,null,null,null,null,null,null,"Hamilton City Council","HCC"]
[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,null,null,null,null,null,null,null,"Hauraki District Council","HDC"]
[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,null,null,null,null,null,null,null,"HEB Construction Ltd","HEB"]
[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,null,null,null,null,null,null,null,"Higgins Contractors Ltd.","HIG"]
[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,null,null,null,null,null,null,null,"HMI Technologies","HMI"]
[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,null,null,null,null,null,null,null,"HERE New Zealand Ltd","HNZ"]
[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,null,null,null,null,null,null,null,"Horizon Services Ltd","HSL"]
[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,null,null,null,null,null,null,null,"HTS Group","HTS"]
[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,null,null,null,null,null,null,null,"Inframix Construction Ltd","IMX"]
[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,null,null,null,null,null,null,null,"Inzone","INZ"]
[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,null,null,null,null,null,null,null,"Isaac Construction","ISC"]
[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,null,null,null,null,null,null,null,"Island Asphalts","ISL"]
[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,null,null,null,null,null,null,null,"ITS","ITS"]
[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,null,null,null,null,null,null,null,"Jacobs New Zealand Ltd","JAC"]
[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,null,null,null,null,null,null,null,"JCW Consultant","JC"]
[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,null,null,null,null,null,null,null,"JCL Asphalt subcontractor","JCL"]
[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,null,null,null,null,null,null,null,"JJ Walters","JJW"]
[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,null,null,null,null,null,null,null,"Johnstone & Masters Ltd","JM"]
[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,null,null,null,null,null,null,null,"NZTA (JTOC)","JTO"]
[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,null,null,null,null,null,null,null,"Juno Services Ltd","JUN"]
[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,null,null,null,null,null,null,null,"Kapiti Coast District Council","KCD"]
[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,null,null,null,null,null,null,null,"Kampung Consulting Ltd.","KCL"]
[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,null,null,null,null,null,null,null,"Kelcroft Engineering","KEL"]
[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,null,null,null,null,null,null,null,"Local Authority","LA"]
[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,null,null,null,null,null,null,null,"Lonrix Ltd","LL"]
[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,null,null,null,null,null,null,null,"McKays Consultants","MCC"]
[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,null,null,null,null,null,null,null,"Matamata-Piako District Council","MD2"]
[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,null,null,null,null,null,null,null,"Manawatu District Council","MDC"]
[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,null,null,null,null,null,null,null,"McKay Electrical Ltd","MEL"]
[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,null,null,null,null,null,null,null,"Aecom NZ Ltd","MER"]
[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,null,null,null,null,null,null,null,"MetService","MET"]
[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,null,null,null,null,null,null,null,"Marlborough NOC JV","MJV"]
[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,null,null,null,null,null,null,null,"McKay Ltd.","ML"]
[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,null,null,null,null,null,null,null,"Marlborough Roads","MR"]
[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,null,null,null,null,null,null,null,"MWH NZ Ltd.","MWH"]
[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,null,null,null,null,null,null,null,"Napier City Council","NCC"]
[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,null,null,null,null,null,null,null,"NZ Transport Agency - Highway Programme","NTA"]
[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,null,null,null,null,null,null,null,"NZ Transport Agency - Funding","NTF"]
[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,null,null,null,null,null,null,null,"North Power","NTH"]
[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,null,null,null,null,null,null,null,"Nutech Security","NUT"]
[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,null,null,null,null,null,null,null,"Odyssey Energy (2009) Ltd.","OE("]
[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,null,null,null,null,null,null,null,"Opus International Consultants Ltd (NZ)","OI2"]
[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,null,null,null,null,null,null,null,"Opus International Consultants Ltd.","OIC"]
[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,null,null,null,null,null,null,null,"Oldfields","OLD"]
[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,null,null,null,null,null,null,null,"Porirua City Council","PCC"]
[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,null,null,null,null,null,null,null,"Pinnacles Civil Group Ltd.","PCG"]
[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,null,null,null,null,null,null,null,"Pope Electrical Ltd","PE2"]
[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,null,null,null,null,null,null,null,"Pope Electrical Limited","PEL"]
[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,null,null,null,null,null,null,null,"Pavement Management Services","PMS"]
[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,null,null,null,null,null,null,null,"Power Solutions Ltd","PSL"]
[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,null,null,null,null,null,null,null,"Queenstown-Lakes District Council","QDC"]
[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,null,null,null,null,null,null,null,"Quality Roading and Services","QRS"]
[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,null,null,null,null,null,null,null,"Read-only access for Tenderers","RAF"]
[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,null,null,null,null,null,null,null,"Rangitikei District Council","RDC"]
[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,null,null,null,null,null,null,null,"Roadex","RDX"]
[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,null,null,null,null,null,null,null,"Rotorua Lakes Council","RLC"]
[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,null,null,null,null,null,null,null,"Roading Logistics Ltd","RLL"]
[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,null,null,null,null,null,null,null,"Rationale Ltd","RLT"]
[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,null,null,null,null,null,null,null,"Rotorua District Council","ROT"]
[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,null,null,null,null,null,null,null,"RAMM Software Limited","RSL"]
[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,null,null,null,null,null,null,null,"Road Signs & Traffic Control Equipment Limited","RTL"]
[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,null,null,null,null,null,null,null,"Russell Roads","RUS"]
[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,null,null,null,null,null,null,null,"Salient Consultants","SAL"]
[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,null,null,null,null,null,null,null,"Sealcoat Central Ltd.","SCL"]
[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,null,null,null,null,null,null,null,"Shaw's Consulting Services Ltd","SCS"]
[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,null,null,null,null,null,null,null,"Southland District Council","SDC"]
[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,null,null,null,null,null,null,null,"Signopsys Electronic Signs","SES"]
[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,null,null,null,null,null,null,null,"Sicon Ltd.","SL2"]
[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,null,null,null,null,null,null,null,"Stantec New Zealand","SN2"]
[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,null,null,null,null,null,null,null,"Stantec New Zealand Ltd","SNZ"]
[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,null,null,null,null,null,null,null,"SouthRoads Ltd.","SOU"]
[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,null,null,null,null,null,null,null,"Safe Roads Alliance","SRA"]
[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,null,null,null,null,null,null,null,"Services South East (NZ) Ltd.","SS2"]
[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,null,null,null,null,null,null,null,"Services South East Pty Ltd","SSE"]
[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,null,null,null,null,null,null,null,"Tonkin & Taylor Ltd","T&T"]
[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,null,null,null,null,null,null,null,"Tasman Howey","TAS"]
[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,null,null,null,null,null,null,null,"NZTA and WDM","TAW"]
[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,null,null,null,null,null,null,null,"Tauranga City Council","TC2"]
[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,null,null,null,null,null,null,null,"Taranaki Civil Construction","TCC"]
[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,null,null,null,null,null,null,null,"TC Nicholls","TCN"]
[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,null,null,null,null,null,null,null,"Traffic Control Systems","TCS"]
[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,null,null,null,null,null,null,null,"Taupo District Council","TD2"]
[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,null,null,null,null,null,null,null,"Tasman District Council","TDC"]
[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,null,null,null,null,null,null,null,"The Datastack Ltd","TDL"]
[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,null,null,null,null,null,null,null,"Taupo East Traffic Services Contractor","TET"]
[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,null,null,null,null,null,null,null,"Broadspectrum (NZ) Ltd","TFD"]
[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,null,null,null,null,null,null,null,"Waka Kotahi NZ Transport Agency","TNZ"]
[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,null,null,null,null,null,null,null,"Top Energy","TOP"]
[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,null,null,null,null,null,null,null,"The Roading Company","TRC"]
[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,null,null,null,null,null,null,null,"Transfield Services (NZ) Ltd","TS("]
[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,null,null,null,null,null,null,null,"Tonkin and Taylor Ltd","TT"]
[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,null,null,null,null,null,null,null,"Tyco Traffic and Transportation","TYC"]
[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,null,null,null,null,null,null,null,"Urban Connection Ltd","UCL"]
[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,null,null,null,null,null,null,null,"Unknown","UKN"]
[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,null,null,null,null,null,null,null,"University of Canterbury","UOC"]
[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,null,null,null,null,null,null,null,"Ventia NZ Operations Limited","VNO"]
[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,null,null,null,null,null,null,null,"Ventia Pty Ltd","VPL"]
[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,null,null,null,null,null,null,null,"Western Bay of Plenty District Council","WBO"]
[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,null,null,null,null,null,null,null,"Wellington City Council","WCC"]
[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,null,null,null,null,null,null,null,"Waimakariri District Council","WD2"]
[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,null,null,null,null,null,null,null,"Whakatane District Council","WD3"]
[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,null,null,null,null,null,null,null,"Wairoa District Council","WD4"]
[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,null,null,null,null,null,null,null,"Waipa District Council","WD5"]
[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,null,null,null,null,null,null,null,"Waikato District Council","WD6"]
[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,null,null,null,null,null,null,null,"Whangarei District Council","WDC"]
[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,null,null,null,null,null,null,null,"WDM","WDM"]
[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,null,null,null,null,null,null,null,"WSP-Opus International Consultants Ltd","WIC"]
[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,null,null,null,null,null,null,null,"Downer New Zealand Limited","WIL"]
[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,null,null,null,null,null,null,null,"W J Ashton Service Ltd","WJA"]
[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,null,null,null,null,null,null,null,"Waka Kotahi NZ Transport Agency - Highways","WK2"]
[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,null,null,null,null,null,null,null,"Waka Kotahi NZ Transport Agency","WKN"]
[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,null,null,null,null,null,null,null,"WSP New Zealand Ltd","WNZ"]