{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Carriageway","Lookups"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":26,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Carriageway","index":0,"n_rows":59,"n_cols":50,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[null,"carr_way_no","road_id","road_id",null,"carrway_start_m","carrway_end_m","length_m","start_name","end_name","cway_area","cway_sub_area",null,"pavement_type",null,"pavement_use","road_class","urban_rural","cway_heirarchy","lanes","lane_width","cway_width","irr_width","res_width","misc_area","bus_bays","islands","intersection","owner_type",null,"traff_manage_level",null,"cway_use_category","cway_group_1",null,"cway_group 2",null,"left_lanes","right_lanes",null,"travel_direction","asset_owner","notes",null,"controlled_by","collect_date","added_on","added_by","chgd_on","chged_by"]
[]
["Action","Carriageway No","Start Road ID","End Road ID","SH-RS-D  (e.g. 016-0000-B) letter must be uppercase and must include leading 0","Cway Start","Cway End","Length","Start Name","End Name","Cway Area","Cway Sub Area","Pavement Type Description","Pavement Type Code","Pavement Use Description","Pavement Use Code","Road Class","Urban/Rural","Cway Hierarchy","Lanes","Lane Width (m)","Cway Width (m)","Width Indicator","Reserved Width (m)","Miscellaneous Area (m2)","Bus Bay (m2)","Islands (m2)","Intersection (m2)","Owner Type","Traffic Management Level Desc","Traffic Management Level","Carriageway Use Desc","Carriageway Use","Declared Motorway Desc","Declared Motorway","Seasonal Zones Desc","Seasonal Zones ","Left Lanes","Right Lanes","Travel Direction Desc","Travel Direction","Asset Owner","Comments (if required)","Collect_name_desc","Collect_on","Collected On","Added On","Added By","Changed On","Changed By"]
[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,{"$f":"IF(G4=\"\",\"\",G4-F4)","v":""},null,null,null,null,null,{"$f":"IF(M4=\"\",\"\",VLOOKUP(M4,PavementType,2,FALSE))","v":""},null,{"$f":"IF(O4=\"\",\"\",VLOOKUP(O4,PavementUse,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD4=\"\",\"\",VLOOKUP(AD4,TrafficManagementLevel,2,FALSE))","v":""},null,{"$f":"IF(AF4=\"\",\"\",VLOOKUP(AF4,UseCategory,2,FALSE))","v":""},null,{"$f":"IF(AH4=\"\",\"\",VLOOKUP(AH4,DeclaredMotorway,2,FALSE))","v":""},null,{"$f":"IF(AJ4=\"\",\"\",VLOOKUP(AJ4,SeasonalZones,2,FALSE))","v":""},null,null,null,{"$f":"IF(AN4=\"\",\"\",VLOOKUP(AN4,TravelDirection,2,FALSE))","v":""},null,null,null,{"$f":"IF(AR4=\"\",\"\",VLOOKUP(AR4,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,{"$f":"IF(M5=\"\",\"\",VLOOKUP(M5,PavementType,2,FALSE))","v":""},null,{"$f":"IF(O5=\"\",\"\",VLOOKUP(O5,PavementUse,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD5=\"\",\"\",VLOOKUP(AD5,TrafficManagementLevel,2,FALSE))","v":""},null,{"$f":"IF(AF5=\"\",\"\",VLOOKUP(AF5,UseCategory,2,FALSE))","v":""},null,{"$f":"IF(AH5=\"\",\"\",VLOOKUP(AH5,DeclaredMotorway,2,FALSE))","v":""},null,{"$f":"IF(AJ5=\"\",\"\",VLOOKUP(AJ5,SeasonalZones,2,FALSE))","v":""},null,null,null,{"$f":"IF(AN5=\"\",\"\",VLOOKUP(AN5,TravelDirection,2,FALSE))","v":""},null,null,null,{"$f":"IF(AR5=\"\",\"\",VLOOKUP(AR5,Controlledby,2,FALSE))","v":""}]
[null,"",{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&E6&\"/\"&F6&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&E6&\"/\"&G6&\"&xml=true\"),\"/lrms/id_road\")","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,{"$f":"IF(A35=\"add\",0,\"\")","v":""},"null","null",null,null,null,{"$f":"IF(G35=\"\",\"\",G35-F35)","v":""},null,null,null,null,null,{"$f":"IF(M35=\"\",\"\",VLOOKUP(M35,PavementType,2,FALSE))","v":""},null,{"$f":"IF(O35=\"\",\"\",VLOOKUP(O35,PavementUse,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD35=\"\",\"\",VLOOKUP(AD35,TrafficManagementLevel,2,FALSE))","v":""},null,{"$f":"IF(AF35=\"\",\"\",VLOOKUP(AF35,UseCategory,2,FALSE))","v":""},null,{"$f":"IF(AH35=\"\",\"\",VLOOKUP(AH35,DeclaredMotorway,2,FALSE))","v":""},null,{"$f":"IF(AJ35=\"\",\"\",VLOOKUP(AJ35,SeasonalZones,2,FALSE))","v":""},null,null,null,{"$f":"IF(AN35=\"\",\"\",VLOOKUP(AN35,TravelDirection,2,FALSE))","v":""},null,null,null,{"$f":"IF(AR35=\"\",\"\",VLOOKUP(AR35,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,""]
["xxx",null,null,"null","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx","xxx"]

{"sheet":"Lookups","index":1,"n_rows":139,"n_cols":38,"rows_kept":139,"cut":false,"hidden":false,"merged":[]}
["Action",null,"Pavement Type Desc","Pavement Type",null,"Pavement Use Desc","Pavement Use",null,"Cway Area","Cway Sub-Area",null,"Urban/Rural",null,"Hierarchy Desc",null,"Asset Owner",null,"organisation description","organisation",null,"Travel Direction Desc","Travel Direction",null,"Traffic Management Level Desc","Traffic Management Level",null,"Use Category Desc","Use Category",null,"Width Indicator",null,"Declared Motorway Desc","Declared Motorway",null,"Seasonal Zones Desc","Seasonal Zone",null,"road class "]
["ADD",null,"Thin Surfaced Flexible","T",null,"ADT < 100",1,null,"AUCK ALLIANCE","AUCKLAND NORTH",null,"U",null,"NSHS MOTORWAY",null,"Crown",null,"3M","3M",null,"Both","B",null,"<500 vpd (Low Volume)","L",null,"Urban Arterial A","1A",null,"Regular",null,"Declared Motorway","M",null,"Seasonal Zone D","D",null,1]
["UPDATE",null,"Structural Asphaltic Concrete","S",null,"ADT 100-500",2,null,"BOP EAST","AUCK. CENTRAL",null,"R",null,"NSHS R1",null,"Local Authority",null,"Automobile Association","AA",null,"Decreasing","D",null,"<10,000 vpd",1,null,"Urban Arterial B","1B",null,"Irregular",null,"Expressway","E",null,"Seasonal Zone E","E",null,"C"]
["DELETE",null,"Concrete","C",null,"ADT 500-2000",3,null,"BOP WEST","AUCKLAND SOUTH",null,null,null,"NSHS R2",null,"Private",null,"Auckland Council","ACC",null,"Increasing","I",null,">=10,000 vpd",2,null,"Urban Commercial",2,null,null,null,"Neither Declared Motorway Nor Expressway","N"]
[null,null,"Unsealed","U",null,"ADT 2000-4000",4,null,"BULLER","EAST BOP",null,null,null,"NSHS R3",null,null,null,"Alarm Centre Installation Ltd","ACI",null,null,null,null,">=10,000 vpd & high speed",3,null,"Urban Industrial",3]
[null,null,"Bridge","B",null,"ADT 4000-10000",5,null,"CENTRAL WAIKATO","GROUP 1",null,null,null,"NSHS R4",null,null,null,"Agfirst","AGF",null,null,null,null,"Unknown","U",null,"Urban Other",4]
[null,null,null,null,null,"ADT 10000-20000",6,null,"COASTAL OTAGO","GROUP 2",null,null,null,"NSHS URBAN",null,null,null,"Auckland Motorway Alliance","AMA",null,null,null,null,null,null,null,"Rural Urban Fringe",5]
[null,null,null,null,null,"ADT > 20000",7,null,"EAST WAIKATO","SOUTH WAIKATO",null,null,null,null,null,null,null,"Asset Management Engineers Ltd","AME",null,null,null,null,null,null,null,"Rural Strategic",6]
[null,null,null,null,null,null,null,null,"EAST WANGANUI","TAUPO EAST",null,null,null,null,null,null,null,"Asset Management Technicians Ltd","AMT",null,null,null,null,null,null,null,"Rural Summer Recreational","7A"]
[null,null,null,null,null,null,null,null,"GISBORNE","TAUPO WEST",null,null,null,null,null,null,null,"Armitage Systems","ARM",null,null,null,null,null,null,null,"Rural Winter Recreational","7B"]
[null,null,null,null,null,null,null,null,"GREY/WESTLAND","WAITAKI",null,null,null,null,null,null,null,"Aspect Solutions Ltd","ASL",null,null,null,null,null,null,null,"Rural Feeder",8]
[null,null,null,null,null,null,null,null,"HARBOUR BRIDGE","DUNEDIN",null,null,null,null,null,null,null,"Auckland System Management","ASM",null,null,null,null,null,null,null,"Urban Residential",9]
[null,null,null,null,null,null,null,null,"MARLBOROUGH","CLUTHA",null,null,null,null,null,null,null,"Auckland Transport","AT2",null,null,null,null,null,null,null,"Unknown","UN"]
[null,null,null,null,null,null,null,null,"NAPIER","COROMANDEL",null,null,null,null,null,null,null,"Aspect Technology and Equipment Ltd","ATE"]
[null,null,null,null,null,null,null,null,"NELSON","HAURAKI MATAMAT",null,null,null,null,null,null,null,"ARRB Transport Research Ltd","ATR"]
[null,null,null,null,null,null,null,null,"NORTHLAND","MATAMATA PIAKO",null,null,null,null,null,null,null,"Auckland University","AUN"]
[null,null,null,null,null,null,null,null,"NTH CANTERBURY","RANGITIKEI",null,null,null,null,null,null,null,"Broadspectrum (NZ) Ltd","B(L"]
[null,null,null,null,null,null,null,null,"OTAGO CENTRAL","MANAWATU",null,null,null,null,null,null,null,"Bri-Ken and Associates Ltd","BAA"]
[null,null,null,null,null,null,null,null,"PSMC 005","PALMERSTON NTH",null,null,null,null,null,null,null,"Bartley Consultants Ltd","BAR"]
[null,null,null,null,null,null,null,null,"PSMC 006","TARARUA",null,null,null,null,null,null,null,"Beca Infrastructure","BCF"]
[null,null,null,null,null,null,null,null,"ROTORUA DIST","HOROWHENUA",null,null,null,null,null,null,null,"Buller District Council","BDC"]
[null,null,null,null,null,null,null,null,"SOUTHLAND","EAST COAST",null,null,null,null,null,null,null,"Blacktop","BLA"]
[null,null,null,null,null,null,null,null,"STH CANTERBURY","GISBORNE",null,null,null,null,null,null,null,"Beca Ltd.","BLT"]
[null,null,null,null,null,null,null,null,"TAURANGA CITY","WAIROA",null,null,null,null,null,null,null,"Civil Assist Ltd","CA2"]
[null,null,null,null,null,null,null,null,"WELLINGTON","NORTH AREA",null,null,null,null,null,null,null,"Civil Assist Ltd","CAL"]
[null,null,null,null,null,null,null,null,"WEST COAST","SOUTH AREA",null,null,null,null,null,null,null,"Christchurch City Council","CCC"]
[null,null,null,null,null,null,null,null,"WEST WAIKATO","WAIROA",null,null,null,null,null,null,null,"City Care Ltd","CCL"]
[null,null,null,null,null,null,null,null,"WEST WANGANUI","STATE HIGHWAY 5",null,null,null,null,null,null,null,"Company-X Ltd.","CL"]
[null,null,null,null,null,null,null,null,null,"NAPIER SOUTH",null,null,null,null,null,null,null,"Critchlow Limited","CL2"]
[null,null,null,null,null,null,null,null,null,"NELSON WAIMEA",null,null,null,null,null,null,null,"Coastline Markers Ltd","CML"]
[null,null,null,null,null,null,null,null,null,"GOLDEN BAY",null,null,null,null,null,null,null,"CoreLogic NZ Ltd.","CNL"]
[null,null,null,null,null,null,null,null,null,"MURCHISON",null,null,null,null,null,null,null,"Central Otago District Council","COD"]
[null,null,null,null,null,null,null,null,null,"NETWORK 1",null,null,null,null,null,null,null,"Other Contractor","CON"]
[null,null,null,null,null,null,null,null,null,"NETWORK 2",null,null,null,null,null,null,null,"CSL Traffic","CSL"]
[null,null,null,null,null,null,null,null,null,"NETWORK 3",null,null,null,null,null,null,null,"Connell Wagner Ltd","CWL"]
[null,null,null,null,null,null,null,null,null,"NETWORK 4",null,null,null,null,null,null,null,"Dunedin City Council","DCC"]
[null,null,null,null,null,null,null,null,null,"NETWORK 5",null,null,null,null,null,null,null,"D & L Crowe Ltd","DLC"]
[null,null,null,null,null,null,null,null,null,"NETWORK 6",null,null,null,null,null,null,null,"Spiire NZ Ltd","DWK"]
[null,null,null,null,null,null,null,null,null,"HURUNUI/KAIKOUR",null,null,null,null,null,null,null,"Excell Corporation","ECL"]
[null,null,null,null,null,null,null,null,null,"SELWYN/BANKS",null,null,null,null,null,null,null,"Ferguson Ind","FGI"]
[null,null,null,null,null,null,null,null,null,"CH/WAIMAKARIRI",null,null,null,null,null,null,null,"Fulton Hogan (NZ) Ltd.","FUL"]
[null,null,null,null,null,null,null,null,null,"KAIKOURA",null,null,null,null,null,null,null,"Gisborne District Council","GDC"]
[null,null,null,null,null,null,null,null,null,"QUEENSTN/LAKES",null,null,null,null,null,null,null,"Geosolve Ltd","GEO"]
[null,null,null,null,null,null,null,null,null,"CENTRAL OTAGO",null,null,null,null,null,null,null,"GHD Ltd.","GHD"]
[null,null,null,null,null,null,null,null,null,"NETWORK1 ALPURT",null,null,null,null,null,null,null,"HEB Construction Ltd","HEB"]
[null,null,null,null,null,null,null,null,null,"NETWORK2 WAIWER",null,null,null,null,null,null,null,"Higgins Contractors Ltd.","HIG"]
[null,null,null,null,null,null,null,null,null,"NETWORK3 WELLSF",null,null,null,null,null,null,null,"HMI Technologies","HMI"]
[null,null,null,null,null,null,null,null,null,"NETWORK4 KAIPAR",null,null,null,null,null,null,null,"HERE New Zealand Ltd","HNZ"]
[null,null,null,null,null,null,null,null,null,"NETWORK5 SH17",null,null,null,null,null,null,null,"HTS Group","HTS"]
[null,null,null,null,null,null,null,null,null,"PSMC SUB-AREA 1",null,null,null,null,null,null,null,"Inframix Construction Ltd","IMX"]
[null,null,null,null,null,null,null,null,null,"PSMC SUB-AREA 2",null,null,null,null,null,null,null,"Inzone","INZ"]
[null,null,null,null,null,null,null,null,null,"PSMC SUB-AREA 3",null,null,null,null,null,null,null,"Isaac Construction","ISC"]
[null,null,null,null,null,null,null,null,null,"NOT PSMC 006",null,null,null,null,null,null,null,"Island Asphalts","ISL"]
[null,null,null,null,null,null,null,null,null,"ROTORUA",null,null,null,null,null,null,null,"ITS","ITS"]
[null,null,null,null,null,null,null,null,null,"EAST BOP",null,null,null,null,null,null,null,"Jacobs New Zealand Ltd","JAC"]
[null,null,null,null,null,null,null,null,null,"WINTON",null,null,null,null,null,null,null,"JCL Asphalt subcontractor","JCL"]
[null,null,null,null,null,null,null,null,null,"NORTHERN STH",null,null,null,null,null,null,null,"JJ Walters","JJW"]
[null,null,null,null,null,null,null,null,null,"INVERCARGILL",null,null,null,null,null,null,null,"Johnstone & Masters Ltd","JM"]
[null,null,null,null,null,null,null,null,null,"TE ANAU",null,null,null,null,null,null,null,"NZTA (JTOC)","JTO"]
[null,null,null,null,null,null,null,null,null,"TIMARU NORTH",null,null,null,null,null,null,null,"Juno Services Ltd","JUN"]
[null,null,null,null,null,null,null,null,null,"TIMARU SOUTH",null,null,null,null,null,null,null,"Kapiti Coast District Council","KCD"]
[null,null,null,null,null,null,null,null,null,"TAURANGA",null,null,null,null,null,null,null,"Kelcroft Engineering","KEL"]
[null,null,null,null,null,null,null,null,null,"RURAL HIGH TRAF",null,null,null,null,null,null,null,"Local Authority","LA"]
[null,null,null,null,null,null,null,null,null,"WAIRARAPA",null,null,null,null,null,null,null,"Lonrix Ltd","LL"]
[null,null,null,null,null,null,null,null,null,"WCC URBAN",null,null,null,null,null,null,null,"McKays Consultants","MCC"]
[null,null,null,null,null,null,null,null,null,"RIMUTAKA",null,null,null,null,null,null,null,"Manawatu District Council","MDC"]
[null,null,null,null,null,null,null,null,null,"OTHER URBAN",null,null,null,null,null,null,null,"McKay Electrical Ltd","MEL"]
[null,null,null,null,null,null,null,null,null,"MOTORWAY",null,null,null,null,null,null,null,"Aecom NZ Ltd","MER"]
[null,null,null,null,null,null,null,null,null,"KAPITI RURAL",null,null,null,null,null,null,null,"MetService","MET"]
[null,null,null,null,null,null,null,null,null,"SH2_58 RURAL",null,null,null,null,null,null,null,"McKay Ltd.","ML"]
[null,null,null,null,null,null,null,null,null,"WAIRARAPA URBAN",null,null,null,null,null,null,null,"Marlborough Roads","MR"]
[null,null,null,null,null,null,null,null,null,"NTH WEST COAST",null,null,null,null,null,null,null,"MWH NZ Ltd.","MWH"]
[null,null,null,null,null,null,null,null,null,"CENT WEST COAST",null,null,null,null,null,null,null,"Napier City Council","NCC"]
[null,null,null,null,null,null,null,null,null,"STHN WEST COAST",null,null,null,null,null,null,null,"NZ Transport Agency - Highway Programme","NTA"]
[null,null,null,null,null,null,null,null,null,"HAMLTN/WAIKATO",null,null,null,null,null,null,null,"NZ Transport Agency - Funding","NTF"]
[null,null,null,null,null,null,null,null,null,"WAIPA/OTOROHGA",null,null,null,null,null,null,null,"North Power","NTH"]
[null,null,null,null,null,null,null,null,null,"WAITOMO",null,null,null,null,null,null,null,"Nutech Security","NUT"]
[null,null,null,null,null,null,null,null,null,"NEW PLYM/STRAT",null,null,null,null,null,null,null,"Odyssey Energy (2009) Ltd.","OE("]
[null,null,null,null,null,null,null,null,null,"STH TARANAKI",null,null,null,null,null,null,null,"Opus International Consultants Ltd (NZ)","OI2"]
[null,null,null,null,null,null,null,null,null,"WANGANUI",null,null,null,null,null,null,null,"Opus International Consultants Ltd.","OIC"]
[null,null,null,null,null,null,null,null,null,"RUAPEHU DIST.",null,null,null,null,null,null,null,"Oldields","OLD"]
[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,"Pinnacles Civil Group Ltd.","PCG"]
[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,"Pavement Management Services","PMS"]
[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,"Queenstown-Lakes District Council","QDC"]
[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,"Read-only access for Tenderers","RAF"]
[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,"Roadex","RDX"]
[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,"Rationale Ltd","RLT"]
[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,"RAMM Software Limited","RSL"]
[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,"Russell Roads","RUS"]
[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,"Southland District Council","SDC"]
[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,"Sicon Ltd.","SL2"]
[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,"Stantec New Zealand Ltd","SNZ"]
[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,"Services South East (NZ) Ltd.","SS2"]
[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,"Tonkin & Taylor Ltd","T&T"]
[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,"NZTA and WDM","TAW"]
[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,"Taranaki Civil Construction","TCC"]
[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,"Traffic Control Systems","TCS"]
[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,"Tasman District Council","TDC"]
[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,"Taupo East Traffic Services Contractor","TET"]
[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,"NZ Transport Agency","TNZ"]
[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,"The Roading Company","TRC"]
[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,"Tonkin and Taylor Ltd","TT"]
[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,"Urban Connection Ltd","UCL"]
[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,"Ventia Pty Ltd","VPL"]
[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,"Wellington City Council","WCC"]
[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,"Whakatane District Council","WD3"]
[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,"Waipa District Council","WD5"]
[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,"Whangarei District Council","WDC"]
[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,"WSP-Opus International Consultants Ltd","WIC"]
[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,"W J Ashton Service Ltd","WJA"]