{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Its","Lookups"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":42,"comments":0,"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":"Its","index":0,"n_rows":50,"n_cols":65,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["15f221f1-c15e-4d8e-a679-81fade5c4405_road_id","sh-rs-d","15f221f1-c15e-4d8e-a679-81fade5c4404_start_m","a5ad77f0-d7ed-4032-ac5f-c88af62bdbb1_street_address","a227936d-24b7-46ce-914b-4f2d0985727b_site_desc","b21d2f2a-7f5b-4f8a-9199-4a13d98c4a3d_location_general","c260a071-6a93-4cb5-af42-e5524aa73113_gps_by_desc","c260a071-6a93-4cb5-af42-e5524aa73113_gps_by","51861373-7274-4d79-9a8a-6718c53ad7d6_northing","f8fdbf84-8c7f-4869-9627-b6328d796045_easting","36ff67f5-95c0-4cc2-8657-e121c3de877f_gps_date","c8a76832-06c3-41da-acc2-e2c7a9f87f96_gps_method_id_desc","c8a76832-06c3-41da-acc2-e2c7a9f87f96_gps_method_id","675bedbc-fd38-435c-8a80-26f2a88f0fb3_nma_desc","675bedbc-fd38-435c-8a80-26f2a88f0fb3_nma","e06b9b1b-5593-4ccc-afe2-55e004a8b5b8_transit_region_desc","e06b9b1b-5593-4ccc-afe2-55e004a8b5b8_transit_region","762eb368-0ecf-40b9-9da8-6b0177266ba4_field_name","93090e08-d553-4e3e-b00d-f756e871feff_its_state_desc","93090e08-d553-4e3e-b00d-f756e871feff_its_state","336e3bd8-9957-4ce7-80ff-d56f0c133106_its_state_date","45bb3da3-0de9-41af-8c8a-4ef788593c95_asset_type_desc","45bb3da3-0de9-41af-8c8a-4ef788593c95_asset_type","62f5a5de-bcee-4e98-8cb3-3eec5b31f6bd_asset_sub_type_desc","62f5a5de-bcee-4e98-8cb3-3eec5b31f6bd_asset_sub_type","4a705cfd-43e7-42ca-ad97-c90f4f660ba1_asset_description",null,null,"be8c78ff-5ca9-4790-ac13-263d5d844175_model_desc","be8c78ff-5ca9-4790-ac13-263d5d844175_model","0d991b59-450a-452c-b1e9-9ad2fe39c256_serial_no","c46e5185-b55f-41bd-9ab4-2f502d2e8049_supplier_desc","c46e5185-b55f-41bd-9ab4-2f502d2e8049_supplier","3c838961-b4d4-4480-add4-740154ef53c2_support_type_desc","3c838961-b4d4-4480-add4-740154ef53c2_support_type","9b97e690-6e08-488a-99f0-21d530c7d175_control_system_desc","9b97e690-6e08-488a-99f0-21d530c7d175_control_system","def6fb4c-bc8c-4c10-bb81-adde85ff3424_comms_desc","def6fb4c-bc8c-4c10-bb81-adde85ff3424_comms","c4f410cb-a231-4970-93b5-6b8870194fb7_mtce_contract_no","95caada3-a3ef-4de7-bd8b-1b79c4762986_maintained_by_desc","95caada3-a3ef-4de7-bd8b-1b79c4762986_maintained_by","8094bee7-c4d2-46a9-a20a-78b0f4c49228_expected_replace","f17d9d89-2db4-4b3b-b3e8-2fbb26513c78_construct_contract","9c6cd679-fbd0-4617-8b85-19beeb3f0969_contract_mgd_by_desc","9c6cd679-fbd0-4617-8b85-19beeb3f0969_contract_mgd_by","5b302817-d6e7-4bad-be21-2b0f8f8765b0_ip_address","1a65869a-8f75-4403-9512-e99f68f9eab2_offset","3d89c929-dd03-4db4-af78-e03e4c8e6570_side_desc","3d89c929-dd03-4db4-af78-e03e4c8e6570_side","9843afef-e35f-41bf-bdf6-5259ca955830_installation_date","65794b0e-01e8-48ac-bdc5-a0cd3f9cd782_design_life","7ee95762-aec0-4900-8d20-a4357cac165b_owner_desc","7ee95762-aec0-4900-8d20-a4357cac165b_owner","47dba072-992c-4f09-87ca-2acf31df626b_condition_rating_desc","47dba072-992c-4f09-87ca-2acf31df626b_condition_rating","9559c293-1c55-4234-aed1-619ecccda977_condition_rat_date","20094460-f839-4aff-b412-d2cb4a7db392_purchase_cost","a9f4a3d0-5fde-4557-9ca1-9b6522239258_criticality_desc","a9f4a3d0-5fde-4557-9ca1-9b6522239258_criticality","18fbac87-9190-4d9a-b8e0-0aa9bbe99e3f_dlp_start_date","19f83d9d-4460-4781-986e-18e7b442463e_dlp_end_date","04a6fd12-4fdd-4083-8758-779c810188c8_system_id",null,"ab6aabbb-96f6-47e3-98b4-a9da2e92e728_notes"]
["road_id","sh-rs-d","start_m","street_address","site_desc","location_general","gps_by_desc","gps_by","northing","easting","gps_date","gps_method_id_desc","gps_method_id","nma_desc","nma","transit_region_desc","transit_region","field_name","its_state_desc","its_state","its_state_date","asset_type_desc","asset_type","asset_sub_type_desc","asset_sub_type","asset_description",null,null,"model_desc","model","serial_no","supplier_desc","supplier","support_type_desc","support_type","control_system_desc","control_system","comms_desc","comms","mtce_contract_no","maintained_by_desc","maintained_by","expected_replace","construct_contract","contract_mgd_by_desc","contract_mgd_by","ip_address","offset","side_desc","side","installation_date","design_life","owner_desc","owner","condition_rating_desc","condition_rating","condition_rat_date","purchase_cost","criticality_desc","criticality","dlp_start_date","dlp_end_date","system_id","nat_contract","notes"]
["Road Id","SH-RS-D  (e.g. 016-0000-B) letter must be uppercase and include leading 0","Location (RP)","Street Address","Site","Location General","GPS By Desc","GPS By","Northing","easting","GPS Date (dd/mm/yyyy) Must include leading 0","GPS Method Id Desc","GPD Method Id","NMA Desc","NMA","Transit Region Desc","Transit Region","Field Name","State Desc","State","State Date (dd/mm/yyyy) Must include leading 0","Asset Type Desc","Asset Type","Asset Sub Type Desc","Asset Sub Type","Asset Description","Make Desc","Make","Model Desc","Model","Serial No","Supplier Desc","Supplier","Support Type Desc","Support Type","Control System Desc","Control System","Communications Desc","Communications","Maintenance Contract Number","Maintained By Desc","Maintained By","Expected Replacement Date (dd/mm/yyyy) Must include leading 0","Construction Contract No","Contract Managed By Desc","Contract Managed By","IP Address","Offset","Side Desc","Side","Installation Date (dd/mm/yyyy) Must include leading 0","Design Life","Owner Desc","Owner","Condition Rating Desc","Condition Rating","Condition Date (dd/mm/yyyy) Must include leading 0","Purchase Cost","Criticality Desc","Criticality","DLP Start Date (dd/mm/yyyy) Must include leading 0","DLP End Date (dd/mm/yyyy) Must include leading 0","System Id","National Contract ","Notes"]
[{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&B4&\"/\"&C4&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,null,null,{"$f":"IF(G4=\"\", \"\", VLOOKUP(G4,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L4=\"\", \"\", VLOOKUP(L4,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N4=\"\", \"\", VLOOKUP(N4,nma[],2,FALSE))","v":""},null,{"$f":"IF(P4=\"\", \"\", VLOOKUP(P4,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S4=\"\", \"\", VLOOKUP(S4,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V4=\"\", \"\", VLOOKUP(V4,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X4=\"\", \"\", VLOOKUP(X4,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA4=\"\", \"\", VLOOKUP(AA4,make,2,FALSE))","v":""},null,{"$f":"IF(AC4=\"\", \"\", VLOOKUP(AC4,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF4=\"\", \"\", VLOOKUP(AF4,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH4=\"\", \"\", VLOOKUP(AH4,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ4=\"\", \"\", VLOOKUP(AJ4,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL4=\"\", \"\", VLOOKUP(AL4,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO4=\"\", \"\", VLOOKUP(AO4,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS4=\"\", \"\", VLOOKUP(AS4,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW4=\"\", \"\", VLOOKUP(AW4,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA4=\"\", \"\", VLOOKUP(BA4,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC4=\"\", \"\", VLOOKUP(BC4,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG4=\"\", \"\", VLOOKUP(BG4,criticality[],2,FALSE))","v":""}]
[{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&B5&\"/\"&C5&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,null,null,{"$f":"IF(G5=\"\", \"\", VLOOKUP(G5,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L5=\"\", \"\", VLOOKUP(L5,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N5=\"\", \"\", VLOOKUP(N5,nma[],2,FALSE))","v":""},null,{"$f":"IF(P5=\"\", \"\", VLOOKUP(P5,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S5=\"\", \"\", VLOOKUP(S5,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V5=\"\", \"\", VLOOKUP(V5,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X5=\"\", \"\", VLOOKUP(X5,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA5=\"\", \"\", VLOOKUP(AA5,model[],2,FALSE))","v":""},null,{"$f":"IF(AC5=\"\", \"\", VLOOKUP(AC5,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF5=\"\", \"\", VLOOKUP(AF5,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH5=\"\", \"\", VLOOKUP(AH5,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ5=\"\", \"\", VLOOKUP(AJ5,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL5=\"\", \"\", VLOOKUP(AL5,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO5=\"\", \"\", VLOOKUP(AO5,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS5=\"\", \"\", VLOOKUP(AS5,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW5=\"\", \"\", VLOOKUP(AW5,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA5=\"\", \"\", VLOOKUP(BA5,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC5=\"\", \"\", VLOOKUP(BC5,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG5=\"\", \"\", VLOOKUP(BG5,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G6=\"\", \"\", VLOOKUP(G6,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L6=\"\", \"\", VLOOKUP(L6,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N6=\"\", \"\", VLOOKUP(N6,nma[],2,FALSE))","v":""},null,{"$f":"IF(P6=\"\", \"\", VLOOKUP(P6,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S6=\"\", \"\", VLOOKUP(S6,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V6=\"\", \"\", VLOOKUP(V6,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X6=\"\", \"\", VLOOKUP(X6,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA6=\"\", \"\", VLOOKUP(AA6,model[],2,FALSE))","v":""},null,{"$f":"IF(AC6=\"\", \"\", VLOOKUP(AC6,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF6=\"\", \"\", VLOOKUP(AF6,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH6=\"\", \"\", VLOOKUP(AH6,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ6=\"\", \"\", VLOOKUP(AJ6,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL6=\"\", \"\", VLOOKUP(AL6,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO6=\"\", \"\", VLOOKUP(AO6,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS6=\"\", \"\", VLOOKUP(AS6,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW6=\"\", \"\", VLOOKUP(AW6,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA6=\"\", \"\", VLOOKUP(BA6,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC6=\"\", \"\", VLOOKUP(BC6,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG6=\"\", \"\", VLOOKUP(BG6,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G7=\"\", \"\", VLOOKUP(G7,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L7=\"\", \"\", VLOOKUP(L7,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N7=\"\", \"\", VLOOKUP(N7,nma[],2,FALSE))","v":""},null,{"$f":"IF(P7=\"\", \"\", VLOOKUP(P7,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S7=\"\", \"\", VLOOKUP(S7,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V7=\"\", \"\", VLOOKUP(V7,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X7=\"\", \"\", VLOOKUP(X7,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA7=\"\", \"\", VLOOKUP(AA7,model[],2,FALSE))","v":""},null,{"$f":"IF(AC7=\"\", \"\", VLOOKUP(AC7,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF7=\"\", \"\", VLOOKUP(AF7,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH7=\"\", \"\", VLOOKUP(AH7,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ7=\"\", \"\", VLOOKUP(AJ7,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL7=\"\", \"\", VLOOKUP(AL7,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO7=\"\", \"\", VLOOKUP(AO7,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS7=\"\", \"\", VLOOKUP(AS7,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW7=\"\", \"\", VLOOKUP(AW7,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA7=\"\", \"\", VLOOKUP(BA7,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC7=\"\", \"\", VLOOKUP(BC7,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG7=\"\", \"\", VLOOKUP(BG7,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G8=\"\", \"\", VLOOKUP(G8,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L8=\"\", \"\", VLOOKUP(L8,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N8=\"\", \"\", VLOOKUP(N8,nma[],2,FALSE))","v":""},null,{"$f":"IF(P8=\"\", \"\", VLOOKUP(P8,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S8=\"\", \"\", VLOOKUP(S8,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V8=\"\", \"\", VLOOKUP(V8,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X8=\"\", \"\", VLOOKUP(X8,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA8=\"\", \"\", VLOOKUP(AA8,model[],2,FALSE))","v":""},null,{"$f":"IF(AC8=\"\", \"\", VLOOKUP(AC8,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF8=\"\", \"\", VLOOKUP(AF8,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH8=\"\", \"\", VLOOKUP(AH8,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ8=\"\", \"\", VLOOKUP(AJ8,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL8=\"\", \"\", VLOOKUP(AL8,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO8=\"\", \"\", VLOOKUP(AO8,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS8=\"\", \"\", VLOOKUP(AS8,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW8=\"\", \"\", VLOOKUP(AW8,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA8=\"\", \"\", VLOOKUP(BA8,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC8=\"\", \"\", VLOOKUP(BC8,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG8=\"\", \"\", VLOOKUP(BG8,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G9=\"\", \"\", VLOOKUP(G9,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L9=\"\", \"\", VLOOKUP(L9,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N9=\"\", \"\", VLOOKUP(N9,nma[],2,FALSE))","v":""},null,{"$f":"IF(P9=\"\", \"\", VLOOKUP(P9,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S9=\"\", \"\", VLOOKUP(S9,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V9=\"\", \"\", VLOOKUP(V9,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X9=\"\", \"\", VLOOKUP(X9,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA9=\"\", \"\", VLOOKUP(AA9,model[],2,FALSE))","v":""},null,{"$f":"IF(AC9=\"\", \"\", VLOOKUP(AC9,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF9=\"\", \"\", VLOOKUP(AF9,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH9=\"\", \"\", VLOOKUP(AH9,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ9=\"\", \"\", VLOOKUP(AJ9,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL9=\"\", \"\", VLOOKUP(AL9,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO9=\"\", \"\", VLOOKUP(AO9,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS9=\"\", \"\", VLOOKUP(AS9,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW9=\"\", \"\", VLOOKUP(AW9,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA9=\"\", \"\", VLOOKUP(BA9,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC9=\"\", \"\", VLOOKUP(BC9,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG9=\"\", \"\", VLOOKUP(BG9,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G10=\"\", \"\", VLOOKUP(G10,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L10=\"\", \"\", VLOOKUP(L10,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N10=\"\", \"\", VLOOKUP(N10,nma[],2,FALSE))","v":""},null,{"$f":"IF(P10=\"\", \"\", VLOOKUP(P10,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S10=\"\", \"\", VLOOKUP(S10,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V10=\"\", \"\", VLOOKUP(V10,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X10=\"\", \"\", VLOOKUP(X10,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA10=\"\", \"\", VLOOKUP(AA10,model[],2,FALSE))","v":""},null,{"$f":"IF(AC10=\"\", \"\", VLOOKUP(AC10,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF10=\"\", \"\", VLOOKUP(AF10,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH10=\"\", \"\", VLOOKUP(AH10,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ10=\"\", \"\", VLOOKUP(AJ10,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL10=\"\", \"\", VLOOKUP(AL10,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO10=\"\", \"\", VLOOKUP(AO10,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS10=\"\", \"\", VLOOKUP(AS10,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW10=\"\", \"\", VLOOKUP(AW10,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA10=\"\", \"\", VLOOKUP(BA10,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC10=\"\", \"\", VLOOKUP(BC10,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG10=\"\", \"\", VLOOKUP(BG10,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G11=\"\", \"\", VLOOKUP(G11,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L11=\"\", \"\", VLOOKUP(L11,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N11=\"\", \"\", VLOOKUP(N11,nma[],2,FALSE))","v":""},null,{"$f":"IF(P11=\"\", \"\", VLOOKUP(P11,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S11=\"\", \"\", VLOOKUP(S11,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V11=\"\", \"\", VLOOKUP(V11,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X11=\"\", \"\", VLOOKUP(X11,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA11=\"\", \"\", VLOOKUP(AA11,model[],2,FALSE))","v":""},null,{"$f":"IF(AC11=\"\", \"\", VLOOKUP(AC11,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF11=\"\", \"\", VLOOKUP(AF11,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH11=\"\", \"\", VLOOKUP(AH11,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ11=\"\", \"\", VLOOKUP(AJ11,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL11=\"\", \"\", VLOOKUP(AL11,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO11=\"\", \"\", VLOOKUP(AO11,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS11=\"\", \"\", VLOOKUP(AS11,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW11=\"\", \"\", VLOOKUP(AW11,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA11=\"\", \"\", VLOOKUP(BA11,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC11=\"\", \"\", VLOOKUP(BC11,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG11=\"\", \"\", VLOOKUP(BG11,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G12=\"\", \"\", VLOOKUP(G12,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L12=\"\", \"\", VLOOKUP(L12,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N12=\"\", \"\", VLOOKUP(N12,nma[],2,FALSE))","v":""},null,{"$f":"IF(P12=\"\", \"\", VLOOKUP(P12,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S12=\"\", \"\", VLOOKUP(S12,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V12=\"\", \"\", VLOOKUP(V12,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X12=\"\", \"\", VLOOKUP(X12,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA12=\"\", \"\", VLOOKUP(AA12,model[],2,FALSE))","v":""},null,{"$f":"IF(AC12=\"\", \"\", VLOOKUP(AC12,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF12=\"\", \"\", VLOOKUP(AF12,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH12=\"\", \"\", VLOOKUP(AH12,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ12=\"\", \"\", VLOOKUP(AJ12,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL12=\"\", \"\", VLOOKUP(AL12,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO12=\"\", \"\", VLOOKUP(AO12,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS12=\"\", \"\", VLOOKUP(AS12,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW12=\"\", \"\", VLOOKUP(AW12,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA12=\"\", \"\", VLOOKUP(BA12,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC12=\"\", \"\", VLOOKUP(BC12,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG12=\"\", \"\", VLOOKUP(BG12,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G13=\"\", \"\", VLOOKUP(G13,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L13=\"\", \"\", VLOOKUP(L13,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N13=\"\", \"\", VLOOKUP(N13,nma[],2,FALSE))","v":""},null,{"$f":"IF(P13=\"\", \"\", VLOOKUP(P13,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S13=\"\", \"\", VLOOKUP(S13,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V13=\"\", \"\", VLOOKUP(V13,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X13=\"\", \"\", VLOOKUP(X13,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA13=\"\", \"\", VLOOKUP(AA13,model[],2,FALSE))","v":""},null,{"$f":"IF(AC13=\"\", \"\", VLOOKUP(AC13,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF13=\"\", \"\", VLOOKUP(AF13,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH13=\"\", \"\", VLOOKUP(AH13,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ13=\"\", \"\", VLOOKUP(AJ13,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL13=\"\", \"\", VLOOKUP(AL13,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO13=\"\", \"\", VLOOKUP(AO13,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS13=\"\", \"\", VLOOKUP(AS13,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW13=\"\", \"\", VLOOKUP(AW13,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA13=\"\", \"\", VLOOKUP(BA13,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC13=\"\", \"\", VLOOKUP(BC13,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG13=\"\", \"\", VLOOKUP(BG13,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G14=\"\", \"\", VLOOKUP(G14,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L14=\"\", \"\", VLOOKUP(L14,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N14=\"\", \"\", VLOOKUP(N14,nma[],2,FALSE))","v":""},null,{"$f":"IF(P14=\"\", \"\", VLOOKUP(P14,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S14=\"\", \"\", VLOOKUP(S14,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V14=\"\", \"\", VLOOKUP(V14,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X14=\"\", \"\", VLOOKUP(X14,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA14=\"\", \"\", VLOOKUP(AA14,model[],2,FALSE))","v":""},null,{"$f":"IF(AC14=\"\", \"\", VLOOKUP(AC14,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF14=\"\", \"\", VLOOKUP(AF14,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH14=\"\", \"\", VLOOKUP(AH14,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ14=\"\", \"\", VLOOKUP(AJ14,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL14=\"\", \"\", VLOOKUP(AL14,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO14=\"\", \"\", VLOOKUP(AO14,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS14=\"\", \"\", VLOOKUP(AS14,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW14=\"\", \"\", VLOOKUP(AW14,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA14=\"\", \"\", VLOOKUP(BA14,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC14=\"\", \"\", VLOOKUP(BC14,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG14=\"\", \"\", VLOOKUP(BG14,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G15=\"\", \"\", VLOOKUP(G15,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L15=\"\", \"\", VLOOKUP(L15,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N15=\"\", \"\", VLOOKUP(N15,nma[],2,FALSE))","v":""},null,{"$f":"IF(P15=\"\", \"\", VLOOKUP(P15,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S15=\"\", \"\", VLOOKUP(S15,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V15=\"\", \"\", VLOOKUP(V15,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X15=\"\", \"\", VLOOKUP(X15,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA15=\"\", \"\", VLOOKUP(AA15,model[],2,FALSE))","v":""},null,{"$f":"IF(AC15=\"\", \"\", VLOOKUP(AC15,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF15=\"\", \"\", VLOOKUP(AF15,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH15=\"\", \"\", VLOOKUP(AH15,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ15=\"\", \"\", VLOOKUP(AJ15,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL15=\"\", \"\", VLOOKUP(AL15,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO15=\"\", \"\", VLOOKUP(AO15,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS15=\"\", \"\", VLOOKUP(AS15,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW15=\"\", \"\", VLOOKUP(AW15,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA15=\"\", \"\", VLOOKUP(BA15,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC15=\"\", \"\", VLOOKUP(BC15,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG15=\"\", \"\", VLOOKUP(BG15,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G16=\"\", \"\", VLOOKUP(G16,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L16=\"\", \"\", VLOOKUP(L16,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N16=\"\", \"\", VLOOKUP(N16,nma[],2,FALSE))","v":""},null,{"$f":"IF(P16=\"\", \"\", VLOOKUP(P16,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S16=\"\", \"\", VLOOKUP(S16,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V16=\"\", \"\", VLOOKUP(V16,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X16=\"\", \"\", VLOOKUP(X16,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA16=\"\", \"\", VLOOKUP(AA16,model[],2,FALSE))","v":""},null,{"$f":"IF(AC16=\"\", \"\", VLOOKUP(AC16,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF16=\"\", \"\", VLOOKUP(AF16,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH16=\"\", \"\", VLOOKUP(AH16,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ16=\"\", \"\", VLOOKUP(AJ16,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL16=\"\", \"\", VLOOKUP(AL16,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO16=\"\", \"\", VLOOKUP(AO16,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS16=\"\", \"\", VLOOKUP(AS16,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW16=\"\", \"\", VLOOKUP(AW16,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA16=\"\", \"\", VLOOKUP(BA16,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC16=\"\", \"\", VLOOKUP(BC16,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG16=\"\", \"\", VLOOKUP(BG16,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G17=\"\", \"\", VLOOKUP(G17,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L17=\"\", \"\", VLOOKUP(L17,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N17=\"\", \"\", VLOOKUP(N17,nma[],2,FALSE))","v":""},null,{"$f":"IF(P17=\"\", \"\", VLOOKUP(P17,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S17=\"\", \"\", VLOOKUP(S17,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V17=\"\", \"\", VLOOKUP(V17,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X17=\"\", \"\", VLOOKUP(X17,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA17=\"\", \"\", VLOOKUP(AA17,model[],2,FALSE))","v":""},null,{"$f":"IF(AC17=\"\", \"\", VLOOKUP(AC17,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF17=\"\", \"\", VLOOKUP(AF17,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH17=\"\", \"\", VLOOKUP(AH17,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ17=\"\", \"\", VLOOKUP(AJ17,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL17=\"\", \"\", VLOOKUP(AL17,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO17=\"\", \"\", VLOOKUP(AO17,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS17=\"\", \"\", VLOOKUP(AS17,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW17=\"\", \"\", VLOOKUP(AW17,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA17=\"\", \"\", VLOOKUP(BA17,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC17=\"\", \"\", VLOOKUP(BC17,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG17=\"\", \"\", VLOOKUP(BG17,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G18=\"\", \"\", VLOOKUP(G18,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L18=\"\", \"\", VLOOKUP(L18,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N18=\"\", \"\", VLOOKUP(N18,nma[],2,FALSE))","v":""},null,{"$f":"IF(P18=\"\", \"\", VLOOKUP(P18,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S18=\"\", \"\", VLOOKUP(S18,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V18=\"\", \"\", VLOOKUP(V18,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X18=\"\", \"\", VLOOKUP(X18,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA18=\"\", \"\", VLOOKUP(AA18,model[],2,FALSE))","v":""},null,{"$f":"IF(AC18=\"\", \"\", VLOOKUP(AC18,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF18=\"\", \"\", VLOOKUP(AF18,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH18=\"\", \"\", VLOOKUP(AH18,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ18=\"\", \"\", VLOOKUP(AJ18,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL18=\"\", \"\", VLOOKUP(AL18,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO18=\"\", \"\", VLOOKUP(AO18,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS18=\"\", \"\", VLOOKUP(AS18,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW18=\"\", \"\", VLOOKUP(AW18,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA18=\"\", \"\", VLOOKUP(BA18,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC18=\"\", \"\", VLOOKUP(BC18,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG18=\"\", \"\", VLOOKUP(BG18,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G19=\"\", \"\", VLOOKUP(G19,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L19=\"\", \"\", VLOOKUP(L19,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N19=\"\", \"\", VLOOKUP(N19,nma[],2,FALSE))","v":""},null,{"$f":"IF(P19=\"\", \"\", VLOOKUP(P19,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S19=\"\", \"\", VLOOKUP(S19,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V19=\"\", \"\", VLOOKUP(V19,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X19=\"\", \"\", VLOOKUP(X19,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA19=\"\", \"\", VLOOKUP(AA19,model[],2,FALSE))","v":""},null,{"$f":"IF(AC19=\"\", \"\", VLOOKUP(AC19,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF19=\"\", \"\", VLOOKUP(AF19,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH19=\"\", \"\", VLOOKUP(AH19,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ19=\"\", \"\", VLOOKUP(AJ19,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL19=\"\", \"\", VLOOKUP(AL19,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO19=\"\", \"\", VLOOKUP(AO19,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS19=\"\", \"\", VLOOKUP(AS19,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW19=\"\", \"\", VLOOKUP(AW19,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA19=\"\", \"\", VLOOKUP(BA19,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC19=\"\", \"\", VLOOKUP(BC19,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG19=\"\", \"\", VLOOKUP(BG19,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G20=\"\", \"\", VLOOKUP(G20,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L20=\"\", \"\", VLOOKUP(L20,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N20=\"\", \"\", VLOOKUP(N20,nma[],2,FALSE))","v":""},null,{"$f":"IF(P20=\"\", \"\", VLOOKUP(P20,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S20=\"\", \"\", VLOOKUP(S20,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V20=\"\", \"\", VLOOKUP(V20,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X20=\"\", \"\", VLOOKUP(X20,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA20=\"\", \"\", VLOOKUP(AA20,model[],2,FALSE))","v":""},null,{"$f":"IF(AC20=\"\", \"\", VLOOKUP(AC20,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF20=\"\", \"\", VLOOKUP(AF20,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH20=\"\", \"\", VLOOKUP(AH20,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ20=\"\", \"\", VLOOKUP(AJ20,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL20=\"\", \"\", VLOOKUP(AL20,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO20=\"\", \"\", VLOOKUP(AO20,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS20=\"\", \"\", VLOOKUP(AS20,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW20=\"\", \"\", VLOOKUP(AW20,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA20=\"\", \"\", VLOOKUP(BA20,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC20=\"\", \"\", VLOOKUP(BC20,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG20=\"\", \"\", VLOOKUP(BG20,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G21=\"\", \"\", VLOOKUP(G21,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L21=\"\", \"\", VLOOKUP(L21,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N21=\"\", \"\", VLOOKUP(N21,nma[],2,FALSE))","v":""},null,{"$f":"IF(P21=\"\", \"\", VLOOKUP(P21,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S21=\"\", \"\", VLOOKUP(S21,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V21=\"\", \"\", VLOOKUP(V21,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X21=\"\", \"\", VLOOKUP(X21,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA21=\"\", \"\", VLOOKUP(AA21,model[],2,FALSE))","v":""},null,{"$f":"IF(AC21=\"\", \"\", VLOOKUP(AC21,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF21=\"\", \"\", VLOOKUP(AF21,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH21=\"\", \"\", VLOOKUP(AH21,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ21=\"\", \"\", VLOOKUP(AJ21,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL21=\"\", \"\", VLOOKUP(AL21,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO21=\"\", \"\", VLOOKUP(AO21,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS21=\"\", \"\", VLOOKUP(AS21,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW21=\"\", \"\", VLOOKUP(AW21,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA21=\"\", \"\", VLOOKUP(BA21,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC21=\"\", \"\", VLOOKUP(BC21,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG21=\"\", \"\", VLOOKUP(BG21,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G22=\"\", \"\", VLOOKUP(G22,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L22=\"\", \"\", VLOOKUP(L22,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N22=\"\", \"\", VLOOKUP(N22,nma[],2,FALSE))","v":""},null,{"$f":"IF(P22=\"\", \"\", VLOOKUP(P22,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S22=\"\", \"\", VLOOKUP(S22,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V22=\"\", \"\", VLOOKUP(V22,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X22=\"\", \"\", VLOOKUP(X22,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA22=\"\", \"\", VLOOKUP(AA22,model[],2,FALSE))","v":""},null,{"$f":"IF(AC22=\"\", \"\", VLOOKUP(AC22,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF22=\"\", \"\", VLOOKUP(AF22,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH22=\"\", \"\", VLOOKUP(AH22,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ22=\"\", \"\", VLOOKUP(AJ22,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL22=\"\", \"\", VLOOKUP(AL22,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO22=\"\", \"\", VLOOKUP(AO22,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS22=\"\", \"\", VLOOKUP(AS22,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW22=\"\", \"\", VLOOKUP(AW22,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA22=\"\", \"\", VLOOKUP(BA22,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC22=\"\", \"\", VLOOKUP(BC22,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG22=\"\", \"\", VLOOKUP(BG22,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G23=\"\", \"\", VLOOKUP(G23,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L23=\"\", \"\", VLOOKUP(L23,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N23=\"\", \"\", VLOOKUP(N23,nma[],2,FALSE))","v":""},null,{"$f":"IF(P23=\"\", \"\", VLOOKUP(P23,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S23=\"\", \"\", VLOOKUP(S23,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V23=\"\", \"\", VLOOKUP(V23,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X23=\"\", \"\", VLOOKUP(X23,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA23=\"\", \"\", VLOOKUP(AA23,model[],2,FALSE))","v":""},null,{"$f":"IF(AC23=\"\", \"\", VLOOKUP(AC23,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF23=\"\", \"\", VLOOKUP(AF23,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH23=\"\", \"\", VLOOKUP(AH23,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ23=\"\", \"\", VLOOKUP(AJ23,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL23=\"\", \"\", VLOOKUP(AL23,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO23=\"\", \"\", VLOOKUP(AO23,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS23=\"\", \"\", VLOOKUP(AS23,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW23=\"\", \"\", VLOOKUP(AW23,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA23=\"\", \"\", VLOOKUP(BA23,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC23=\"\", \"\", VLOOKUP(BC23,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG23=\"\", \"\", VLOOKUP(BG23,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G24=\"\", \"\", VLOOKUP(G24,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L24=\"\", \"\", VLOOKUP(L24,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N24=\"\", \"\", VLOOKUP(N24,nma[],2,FALSE))","v":""},null,{"$f":"IF(P24=\"\", \"\", VLOOKUP(P24,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S24=\"\", \"\", VLOOKUP(S24,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V24=\"\", \"\", VLOOKUP(V24,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X24=\"\", \"\", VLOOKUP(X24,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA24=\"\", \"\", VLOOKUP(AA24,model[],2,FALSE))","v":""},null,{"$f":"IF(AC24=\"\", \"\", VLOOKUP(AC24,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF24=\"\", \"\", VLOOKUP(AF24,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH24=\"\", \"\", VLOOKUP(AH24,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ24=\"\", \"\", VLOOKUP(AJ24,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL24=\"\", \"\", VLOOKUP(AL24,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO24=\"\", \"\", VLOOKUP(AO24,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS24=\"\", \"\", VLOOKUP(AS24,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW24=\"\", \"\", VLOOKUP(AW24,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA24=\"\", \"\", VLOOKUP(BA24,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC24=\"\", \"\", VLOOKUP(BC24,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG24=\"\", \"\", VLOOKUP(BG24,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G25=\"\", \"\", VLOOKUP(G25,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L25=\"\", \"\", VLOOKUP(L25,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N25=\"\", \"\", VLOOKUP(N25,nma[],2,FALSE))","v":""},null,{"$f":"IF(P25=\"\", \"\", VLOOKUP(P25,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S25=\"\", \"\", VLOOKUP(S25,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V25=\"\", \"\", VLOOKUP(V25,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X25=\"\", \"\", VLOOKUP(X25,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA25=\"\", \"\", VLOOKUP(AA25,model[],2,FALSE))","v":""},null,{"$f":"IF(AC25=\"\", \"\", VLOOKUP(AC25,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF25=\"\", \"\", VLOOKUP(AF25,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH25=\"\", \"\", VLOOKUP(AH25,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ25=\"\", \"\", VLOOKUP(AJ25,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL25=\"\", \"\", VLOOKUP(AL25,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO25=\"\", \"\", VLOOKUP(AO25,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS25=\"\", \"\", VLOOKUP(AS25,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW25=\"\", \"\", VLOOKUP(AW25,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA25=\"\", \"\", VLOOKUP(BA25,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC25=\"\", \"\", VLOOKUP(BC25,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG25=\"\", \"\", VLOOKUP(BG25,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G26=\"\", \"\", VLOOKUP(G26,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L26=\"\", \"\", VLOOKUP(L26,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N26=\"\", \"\", VLOOKUP(N26,nma[],2,FALSE))","v":""},null,{"$f":"IF(P26=\"\", \"\", VLOOKUP(P26,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S26=\"\", \"\", VLOOKUP(S26,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V26=\"\", \"\", VLOOKUP(V26,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X26=\"\", \"\", VLOOKUP(X26,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA26=\"\", \"\", VLOOKUP(AA26,model[],2,FALSE))","v":""},null,{"$f":"IF(AC26=\"\", \"\", VLOOKUP(AC26,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF26=\"\", \"\", VLOOKUP(AF26,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH26=\"\", \"\", VLOOKUP(AH26,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ26=\"\", \"\", VLOOKUP(AJ26,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL26=\"\", \"\", VLOOKUP(AL26,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO26=\"\", \"\", VLOOKUP(AO26,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS26=\"\", \"\", VLOOKUP(AS26,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW26=\"\", \"\", VLOOKUP(AW26,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA26=\"\", \"\", VLOOKUP(BA26,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC26=\"\", \"\", VLOOKUP(BC26,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG26=\"\", \"\", VLOOKUP(BG26,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G27=\"\", \"\", VLOOKUP(G27,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L27=\"\", \"\", VLOOKUP(L27,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N27=\"\", \"\", VLOOKUP(N27,nma[],2,FALSE))","v":""},null,{"$f":"IF(P27=\"\", \"\", VLOOKUP(P27,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S27=\"\", \"\", VLOOKUP(S27,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V27=\"\", \"\", VLOOKUP(V27,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X27=\"\", \"\", VLOOKUP(X27,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA27=\"\", \"\", VLOOKUP(AA27,model[],2,FALSE))","v":""},null,{"$f":"IF(AC27=\"\", \"\", VLOOKUP(AC27,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF27=\"\", \"\", VLOOKUP(AF27,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH27=\"\", \"\", VLOOKUP(AH27,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ27=\"\", \"\", VLOOKUP(AJ27,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL27=\"\", \"\", VLOOKUP(AL27,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO27=\"\", \"\", VLOOKUP(AO27,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS27=\"\", \"\", VLOOKUP(AS27,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW27=\"\", \"\", VLOOKUP(AW27,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA27=\"\", \"\", VLOOKUP(BA27,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC27=\"\", \"\", VLOOKUP(BC27,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG27=\"\", \"\", VLOOKUP(BG27,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G28=\"\", \"\", VLOOKUP(G28,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L28=\"\", \"\", VLOOKUP(L28,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N28=\"\", \"\", VLOOKUP(N28,nma[],2,FALSE))","v":""},null,{"$f":"IF(P28=\"\", \"\", VLOOKUP(P28,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S28=\"\", \"\", VLOOKUP(S28,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V28=\"\", \"\", VLOOKUP(V28,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X28=\"\", \"\", VLOOKUP(X28,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA28=\"\", \"\", VLOOKUP(AA28,model[],2,FALSE))","v":""},null,{"$f":"IF(AC28=\"\", \"\", VLOOKUP(AC28,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF28=\"\", \"\", VLOOKUP(AF28,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH28=\"\", \"\", VLOOKUP(AH28,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ28=\"\", \"\", VLOOKUP(AJ28,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL28=\"\", \"\", VLOOKUP(AL28,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO28=\"\", \"\", VLOOKUP(AO28,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS28=\"\", \"\", VLOOKUP(AS28,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW28=\"\", \"\", VLOOKUP(AW28,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA28=\"\", \"\", VLOOKUP(BA28,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC28=\"\", \"\", VLOOKUP(BC28,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG28=\"\", \"\", VLOOKUP(BG28,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G29=\"\", \"\", VLOOKUP(G29,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L29=\"\", \"\", VLOOKUP(L29,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N29=\"\", \"\", VLOOKUP(N29,nma[],2,FALSE))","v":""},null,{"$f":"IF(P29=\"\", \"\", VLOOKUP(P29,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S29=\"\", \"\", VLOOKUP(S29,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V29=\"\", \"\", VLOOKUP(V29,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X29=\"\", \"\", VLOOKUP(X29,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA29=\"\", \"\", VLOOKUP(AA29,model[],2,FALSE))","v":""},null,{"$f":"IF(AC29=\"\", \"\", VLOOKUP(AC29,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF29=\"\", \"\", VLOOKUP(AF29,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH29=\"\", \"\", VLOOKUP(AH29,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ29=\"\", \"\", VLOOKUP(AJ29,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL29=\"\", \"\", VLOOKUP(AL29,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO29=\"\", \"\", VLOOKUP(AO29,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS29=\"\", \"\", VLOOKUP(AS29,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW29=\"\", \"\", VLOOKUP(AW29,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA29=\"\", \"\", VLOOKUP(BA29,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC29=\"\", \"\", VLOOKUP(BC29,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG29=\"\", \"\", VLOOKUP(BG29,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G30=\"\", \"\", VLOOKUP(G30,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L30=\"\", \"\", VLOOKUP(L30,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N30=\"\", \"\", VLOOKUP(N30,nma[],2,FALSE))","v":""},null,{"$f":"IF(P30=\"\", \"\", VLOOKUP(P30,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S30=\"\", \"\", VLOOKUP(S30,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V30=\"\", \"\", VLOOKUP(V30,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X30=\"\", \"\", VLOOKUP(X30,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA30=\"\", \"\", VLOOKUP(AA30,model[],2,FALSE))","v":""},null,{"$f":"IF(AC30=\"\", \"\", VLOOKUP(AC30,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF30=\"\", \"\", VLOOKUP(AF30,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH30=\"\", \"\", VLOOKUP(AH30,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ30=\"\", \"\", VLOOKUP(AJ30,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL30=\"\", \"\", VLOOKUP(AL30,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO30=\"\", \"\", VLOOKUP(AO30,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS30=\"\", \"\", VLOOKUP(AS30,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW30=\"\", \"\", VLOOKUP(AW30,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA30=\"\", \"\", VLOOKUP(BA30,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC30=\"\", \"\", VLOOKUP(BC30,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG30=\"\", \"\", VLOOKUP(BG30,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G31=\"\", \"\", VLOOKUP(G31,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L31=\"\", \"\", VLOOKUP(L31,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N31=\"\", \"\", VLOOKUP(N31,nma[],2,FALSE))","v":""},null,{"$f":"IF(P31=\"\", \"\", VLOOKUP(P31,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S31=\"\", \"\", VLOOKUP(S31,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V31=\"\", \"\", VLOOKUP(V31,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X31=\"\", \"\", VLOOKUP(X31,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA31=\"\", \"\", VLOOKUP(AA31,model[],2,FALSE))","v":""},null,{"$f":"IF(AC31=\"\", \"\", VLOOKUP(AC31,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF31=\"\", \"\", VLOOKUP(AF31,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH31=\"\", \"\", VLOOKUP(AH31,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ31=\"\", \"\", VLOOKUP(AJ31,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL31=\"\", \"\", VLOOKUP(AL31,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO31=\"\", \"\", VLOOKUP(AO31,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS31=\"\", \"\", VLOOKUP(AS31,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW31=\"\", \"\", VLOOKUP(AW31,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA31=\"\", \"\", VLOOKUP(BA31,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC31=\"\", \"\", VLOOKUP(BC31,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG31=\"\", \"\", VLOOKUP(BG31,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G32=\"\", \"\", VLOOKUP(G32,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L32=\"\", \"\", VLOOKUP(L32,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N32=\"\", \"\", VLOOKUP(N32,nma[],2,FALSE))","v":""},null,{"$f":"IF(P32=\"\", \"\", VLOOKUP(P32,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S32=\"\", \"\", VLOOKUP(S32,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V32=\"\", \"\", VLOOKUP(V32,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X32=\"\", \"\", VLOOKUP(X32,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA32=\"\", \"\", VLOOKUP(AA32,model[],2,FALSE))","v":""},null,{"$f":"IF(AC32=\"\", \"\", VLOOKUP(AC32,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF32=\"\", \"\", VLOOKUP(AF32,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH32=\"\", \"\", VLOOKUP(AH32,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ32=\"\", \"\", VLOOKUP(AJ32,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL32=\"\", \"\", VLOOKUP(AL32,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO32=\"\", \"\", VLOOKUP(AO32,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS32=\"\", \"\", VLOOKUP(AS32,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW32=\"\", \"\", VLOOKUP(AW32,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA32=\"\", \"\", VLOOKUP(BA32,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC32=\"\", \"\", VLOOKUP(BC32,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG32=\"\", \"\", VLOOKUP(BG32,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G33=\"\", \"\", VLOOKUP(G33,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L33=\"\", \"\", VLOOKUP(L33,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N33=\"\", \"\", VLOOKUP(N33,nma[],2,FALSE))","v":""},null,{"$f":"IF(P33=\"\", \"\", VLOOKUP(P33,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S33=\"\", \"\", VLOOKUP(S33,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V33=\"\", \"\", VLOOKUP(V33,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X33=\"\", \"\", VLOOKUP(X33,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA33=\"\", \"\", VLOOKUP(AA33,model[],2,FALSE))","v":""},null,{"$f":"IF(AC33=\"\", \"\", VLOOKUP(AC33,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF33=\"\", \"\", VLOOKUP(AF33,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH33=\"\", \"\", VLOOKUP(AH33,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ33=\"\", \"\", VLOOKUP(AJ33,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL33=\"\", \"\", VLOOKUP(AL33,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO33=\"\", \"\", VLOOKUP(AO33,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS33=\"\", \"\", VLOOKUP(AS33,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW33=\"\", \"\", VLOOKUP(AW33,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA33=\"\", \"\", VLOOKUP(BA33,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC33=\"\", \"\", VLOOKUP(BC33,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG33=\"\", \"\", VLOOKUP(BG33,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G34=\"\", \"\", VLOOKUP(G34,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L34=\"\", \"\", VLOOKUP(L34,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N34=\"\", \"\", VLOOKUP(N34,nma[],2,FALSE))","v":""},null,{"$f":"IF(P34=\"\", \"\", VLOOKUP(P34,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S34=\"\", \"\", VLOOKUP(S34,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V34=\"\", \"\", VLOOKUP(V34,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X34=\"\", \"\", VLOOKUP(X34,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA34=\"\", \"\", VLOOKUP(AA34,model[],2,FALSE))","v":""},null,{"$f":"IF(AC34=\"\", \"\", VLOOKUP(AC34,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF34=\"\", \"\", VLOOKUP(AF34,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH34=\"\", \"\", VLOOKUP(AH34,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ34=\"\", \"\", VLOOKUP(AJ34,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL34=\"\", \"\", VLOOKUP(AL34,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO34=\"\", \"\", VLOOKUP(AO34,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS34=\"\", \"\", VLOOKUP(AS34,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW34=\"\", \"\", VLOOKUP(AW34,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA34=\"\", \"\", VLOOKUP(BA34,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC34=\"\", \"\", VLOOKUP(BC34,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG34=\"\", \"\", VLOOKUP(BG34,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G35=\"\", \"\", VLOOKUP(G35,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L35=\"\", \"\", VLOOKUP(L35,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N35=\"\", \"\", VLOOKUP(N35,nma[],2,FALSE))","v":""},null,{"$f":"IF(P35=\"\", \"\", VLOOKUP(P35,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S35=\"\", \"\", VLOOKUP(S35,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V35=\"\", \"\", VLOOKUP(V35,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X35=\"\", \"\", VLOOKUP(X35,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA35=\"\", \"\", VLOOKUP(AA35,model[],2,FALSE))","v":""},null,{"$f":"IF(AC35=\"\", \"\", VLOOKUP(AC35,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF35=\"\", \"\", VLOOKUP(AF35,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH35=\"\", \"\", VLOOKUP(AH35,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ35=\"\", \"\", VLOOKUP(AJ35,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL35=\"\", \"\", VLOOKUP(AL35,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO35=\"\", \"\", VLOOKUP(AO35,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS35=\"\", \"\", VLOOKUP(AS35,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW35=\"\", \"\", VLOOKUP(AW35,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA35=\"\", \"\", VLOOKUP(BA35,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC35=\"\", \"\", VLOOKUP(BC35,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG35=\"\", \"\", VLOOKUP(BG35,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G36=\"\", \"\", VLOOKUP(G36,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L36=\"\", \"\", VLOOKUP(L36,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N36=\"\", \"\", VLOOKUP(N36,nma[],2,FALSE))","v":""},null,{"$f":"IF(P36=\"\", \"\", VLOOKUP(P36,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S36=\"\", \"\", VLOOKUP(S36,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V36=\"\", \"\", VLOOKUP(V36,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X36=\"\", \"\", VLOOKUP(X36,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA36=\"\", \"\", VLOOKUP(AA36,model[],2,FALSE))","v":""},null,{"$f":"IF(AC36=\"\", \"\", VLOOKUP(AC36,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF36=\"\", \"\", VLOOKUP(AF36,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH36=\"\", \"\", VLOOKUP(AH36,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ36=\"\", \"\", VLOOKUP(AJ36,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL36=\"\", \"\", VLOOKUP(AL36,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO36=\"\", \"\", VLOOKUP(AO36,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS36=\"\", \"\", VLOOKUP(AS36,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW36=\"\", \"\", VLOOKUP(AW36,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA36=\"\", \"\", VLOOKUP(BA36,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC36=\"\", \"\", VLOOKUP(BC36,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG36=\"\", \"\", VLOOKUP(BG36,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G37=\"\", \"\", VLOOKUP(G37,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L37=\"\", \"\", VLOOKUP(L37,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N37=\"\", \"\", VLOOKUP(N37,nma[],2,FALSE))","v":""},null,{"$f":"IF(P37=\"\", \"\", VLOOKUP(P37,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S37=\"\", \"\", VLOOKUP(S37,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V37=\"\", \"\", VLOOKUP(V37,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X37=\"\", \"\", VLOOKUP(X37,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA37=\"\", \"\", VLOOKUP(AA37,model[],2,FALSE))","v":""},null,{"$f":"IF(AC37=\"\", \"\", VLOOKUP(AC37,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF37=\"\", \"\", VLOOKUP(AF37,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH37=\"\", \"\", VLOOKUP(AH37,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ37=\"\", \"\", VLOOKUP(AJ37,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL37=\"\", \"\", VLOOKUP(AL37,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO37=\"\", \"\", VLOOKUP(AO37,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS37=\"\", \"\", VLOOKUP(AS37,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW37=\"\", \"\", VLOOKUP(AW37,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA37=\"\", \"\", VLOOKUP(BA37,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC37=\"\", \"\", VLOOKUP(BC37,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG37=\"\", \"\", VLOOKUP(BG37,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G38=\"\", \"\", VLOOKUP(G38,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L38=\"\", \"\", VLOOKUP(L38,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N38=\"\", \"\", VLOOKUP(N38,nma[],2,FALSE))","v":""},null,{"$f":"IF(P38=\"\", \"\", VLOOKUP(P38,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S38=\"\", \"\", VLOOKUP(S38,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V38=\"\", \"\", VLOOKUP(V38,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X38=\"\", \"\", VLOOKUP(X38,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA38=\"\", \"\", VLOOKUP(AA38,model[],2,FALSE))","v":""},null,{"$f":"IF(AC38=\"\", \"\", VLOOKUP(AC38,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF38=\"\", \"\", VLOOKUP(AF38,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH38=\"\", \"\", VLOOKUP(AH38,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ38=\"\", \"\", VLOOKUP(AJ38,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL38=\"\", \"\", VLOOKUP(AL38,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO38=\"\", \"\", VLOOKUP(AO38,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS38=\"\", \"\", VLOOKUP(AS38,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW38=\"\", \"\", VLOOKUP(AW38,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA38=\"\", \"\", VLOOKUP(BA38,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC38=\"\", \"\", VLOOKUP(BC38,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG38=\"\", \"\", VLOOKUP(BG38,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G39=\"\", \"\", VLOOKUP(G39,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L39=\"\", \"\", VLOOKUP(L39,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N39=\"\", \"\", VLOOKUP(N39,nma[],2,FALSE))","v":""},null,{"$f":"IF(P39=\"\", \"\", VLOOKUP(P39,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S39=\"\", \"\", VLOOKUP(S39,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V39=\"\", \"\", VLOOKUP(V39,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X39=\"\", \"\", VLOOKUP(X39,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA39=\"\", \"\", VLOOKUP(AA39,model[],2,FALSE))","v":""},null,{"$f":"IF(AC39=\"\", \"\", VLOOKUP(AC39,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF39=\"\", \"\", VLOOKUP(AF39,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH39=\"\", \"\", VLOOKUP(AH39,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ39=\"\", \"\", VLOOKUP(AJ39,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL39=\"\", \"\", VLOOKUP(AL39,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO39=\"\", \"\", VLOOKUP(AO39,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS39=\"\", \"\", VLOOKUP(AS39,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW39=\"\", \"\", VLOOKUP(AW39,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA39=\"\", \"\", VLOOKUP(BA39,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC39=\"\", \"\", VLOOKUP(BC39,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG39=\"\", \"\", VLOOKUP(BG39,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G40=\"\", \"\", VLOOKUP(G40,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L40=\"\", \"\", VLOOKUP(L40,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N40=\"\", \"\", VLOOKUP(N40,nma[],2,FALSE))","v":""},null,{"$f":"IF(P40=\"\", \"\", VLOOKUP(P40,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S40=\"\", \"\", VLOOKUP(S40,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V40=\"\", \"\", VLOOKUP(V40,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X40=\"\", \"\", VLOOKUP(X40,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA40=\"\", \"\", VLOOKUP(AA40,model[],2,FALSE))","v":""},null,{"$f":"IF(AC40=\"\", \"\", VLOOKUP(AC40,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF40=\"\", \"\", VLOOKUP(AF40,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH40=\"\", \"\", VLOOKUP(AH40,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ40=\"\", \"\", VLOOKUP(AJ40,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL40=\"\", \"\", VLOOKUP(AL40,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO40=\"\", \"\", VLOOKUP(AO40,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS40=\"\", \"\", VLOOKUP(AS40,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW40=\"\", \"\", VLOOKUP(AW40,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA40=\"\", \"\", VLOOKUP(BA40,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC40=\"\", \"\", VLOOKUP(BC40,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG40=\"\", \"\", VLOOKUP(BG40,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G41=\"\", \"\", VLOOKUP(G41,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L41=\"\", \"\", VLOOKUP(L41,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N41=\"\", \"\", VLOOKUP(N41,nma[],2,FALSE))","v":""},null,{"$f":"IF(P41=\"\", \"\", VLOOKUP(P41,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S41=\"\", \"\", VLOOKUP(S41,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V41=\"\", \"\", VLOOKUP(V41,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X41=\"\", \"\", VLOOKUP(X41,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA41=\"\", \"\", VLOOKUP(AA41,model[],2,FALSE))","v":""},null,{"$f":"IF(AC41=\"\", \"\", VLOOKUP(AC41,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF41=\"\", \"\", VLOOKUP(AF41,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH41=\"\", \"\", VLOOKUP(AH41,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ41=\"\", \"\", VLOOKUP(AJ41,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL41=\"\", \"\", VLOOKUP(AL41,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO41=\"\", \"\", VLOOKUP(AO41,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS41=\"\", \"\", VLOOKUP(AS41,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW41=\"\", \"\", VLOOKUP(AW41,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA41=\"\", \"\", VLOOKUP(BA41,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC41=\"\", \"\", VLOOKUP(BC41,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG41=\"\", \"\", VLOOKUP(BG41,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G42=\"\", \"\", VLOOKUP(G42,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L42=\"\", \"\", VLOOKUP(L42,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N42=\"\", \"\", VLOOKUP(N42,nma[],2,FALSE))","v":""},null,{"$f":"IF(P42=\"\", \"\", VLOOKUP(P42,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S42=\"\", \"\", VLOOKUP(S42,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V42=\"\", \"\", VLOOKUP(V42,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X42=\"\", \"\", VLOOKUP(X42,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA42=\"\", \"\", VLOOKUP(AA42,model[],2,FALSE))","v":""},null,{"$f":"IF(AC42=\"\", \"\", VLOOKUP(AC42,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF42=\"\", \"\", VLOOKUP(AF42,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH42=\"\", \"\", VLOOKUP(AH42,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ42=\"\", \"\", VLOOKUP(AJ42,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL42=\"\", \"\", VLOOKUP(AL42,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO42=\"\", \"\", VLOOKUP(AO42,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS42=\"\", \"\", VLOOKUP(AS42,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW42=\"\", \"\", VLOOKUP(AW42,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA42=\"\", \"\", VLOOKUP(BA42,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC42=\"\", \"\", VLOOKUP(BC42,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG42=\"\", \"\", VLOOKUP(BG42,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G43=\"\", \"\", VLOOKUP(G43,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L43=\"\", \"\", VLOOKUP(L43,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N43=\"\", \"\", VLOOKUP(N43,nma[],2,FALSE))","v":""},null,{"$f":"IF(P43=\"\", \"\", VLOOKUP(P43,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S43=\"\", \"\", VLOOKUP(S43,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V43=\"\", \"\", VLOOKUP(V43,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X43=\"\", \"\", VLOOKUP(X43,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA43=\"\", \"\", VLOOKUP(AA43,model[],2,FALSE))","v":""},null,{"$f":"IF(AC43=\"\", \"\", VLOOKUP(AC43,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF43=\"\", \"\", VLOOKUP(AF43,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH43=\"\", \"\", VLOOKUP(AH43,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ43=\"\", \"\", VLOOKUP(AJ43,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL43=\"\", \"\", VLOOKUP(AL43,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO43=\"\", \"\", VLOOKUP(AO43,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS43=\"\", \"\", VLOOKUP(AS43,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW43=\"\", \"\", VLOOKUP(AW43,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA43=\"\", \"\", VLOOKUP(BA43,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC43=\"\", \"\", VLOOKUP(BC43,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG43=\"\", \"\", VLOOKUP(BG43,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G44=\"\", \"\", VLOOKUP(G44,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L44=\"\", \"\", VLOOKUP(L44,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N44=\"\", \"\", VLOOKUP(N44,nma[],2,FALSE))","v":""},null,{"$f":"IF(P44=\"\", \"\", VLOOKUP(P44,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S44=\"\", \"\", VLOOKUP(S44,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V44=\"\", \"\", VLOOKUP(V44,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X44=\"\", \"\", VLOOKUP(X44,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA44=\"\", \"\", VLOOKUP(AA44,model[],2,FALSE))","v":""},null,{"$f":"IF(AC44=\"\", \"\", VLOOKUP(AC44,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF44=\"\", \"\", VLOOKUP(AF44,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH44=\"\", \"\", VLOOKUP(AH44,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ44=\"\", \"\", VLOOKUP(AJ44,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL44=\"\", \"\", VLOOKUP(AL44,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO44=\"\", \"\", VLOOKUP(AO44,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS44=\"\", \"\", VLOOKUP(AS44,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW44=\"\", \"\", VLOOKUP(AW44,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA44=\"\", \"\", VLOOKUP(BA44,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC44=\"\", \"\", VLOOKUP(BC44,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG44=\"\", \"\", VLOOKUP(BG44,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G45=\"\", \"\", VLOOKUP(G45,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L45=\"\", \"\", VLOOKUP(L45,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N45=\"\", \"\", VLOOKUP(N45,nma[],2,FALSE))","v":""},null,{"$f":"IF(P45=\"\", \"\", VLOOKUP(P45,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S45=\"\", \"\", VLOOKUP(S45,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V45=\"\", \"\", VLOOKUP(V45,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X45=\"\", \"\", VLOOKUP(X45,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA45=\"\", \"\", VLOOKUP(AA45,model[],2,FALSE))","v":""},null,{"$f":"IF(AC45=\"\", \"\", VLOOKUP(AC45,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF45=\"\", \"\", VLOOKUP(AF45,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH45=\"\", \"\", VLOOKUP(AH45,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ45=\"\", \"\", VLOOKUP(AJ45,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL45=\"\", \"\", VLOOKUP(AL45,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO45=\"\", \"\", VLOOKUP(AO45,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS45=\"\", \"\", VLOOKUP(AS45,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW45=\"\", \"\", VLOOKUP(AW45,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA45=\"\", \"\", VLOOKUP(BA45,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC45=\"\", \"\", VLOOKUP(BC45,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG45=\"\", \"\", VLOOKUP(BG45,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G46=\"\", \"\", VLOOKUP(G46,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L46=\"\", \"\", VLOOKUP(L46,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N46=\"\", \"\", VLOOKUP(N46,nma[],2,FALSE))","v":""},null,{"$f":"IF(P46=\"\", \"\", VLOOKUP(P46,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S46=\"\", \"\", VLOOKUP(S46,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V46=\"\", \"\", VLOOKUP(V46,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X46=\"\", \"\", VLOOKUP(X46,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA46=\"\", \"\", VLOOKUP(AA46,model[],2,FALSE))","v":""},null,{"$f":"IF(AC46=\"\", \"\", VLOOKUP(AC46,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF46=\"\", \"\", VLOOKUP(AF46,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH46=\"\", \"\", VLOOKUP(AH46,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ46=\"\", \"\", VLOOKUP(AJ46,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL46=\"\", \"\", VLOOKUP(AL46,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO46=\"\", \"\", VLOOKUP(AO46,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS46=\"\", \"\", VLOOKUP(AS46,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW46=\"\", \"\", VLOOKUP(AW46,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA46=\"\", \"\", VLOOKUP(BA46,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC46=\"\", \"\", VLOOKUP(BC46,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG46=\"\", \"\", VLOOKUP(BG46,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G47=\"\", \"\", VLOOKUP(G47,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L47=\"\", \"\", VLOOKUP(L47,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N47=\"\", \"\", VLOOKUP(N47,nma[],2,FALSE))","v":""},null,{"$f":"IF(P47=\"\", \"\", VLOOKUP(P47,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S47=\"\", \"\", VLOOKUP(S47,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V47=\"\", \"\", VLOOKUP(V47,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X47=\"\", \"\", VLOOKUP(X47,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA47=\"\", \"\", VLOOKUP(AA47,model[],2,FALSE))","v":""},null,{"$f":"IF(AC47=\"\", \"\", VLOOKUP(AC47,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF47=\"\", \"\", VLOOKUP(AF47,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH47=\"\", \"\", VLOOKUP(AH47,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ47=\"\", \"\", VLOOKUP(AJ47,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL47=\"\", \"\", VLOOKUP(AL47,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO47=\"\", \"\", VLOOKUP(AO47,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS47=\"\", \"\", VLOOKUP(AS47,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW47=\"\", \"\", VLOOKUP(AW47,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA47=\"\", \"\", VLOOKUP(BA47,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC47=\"\", \"\", VLOOKUP(BC47,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG47=\"\", \"\", VLOOKUP(BG47,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G48=\"\", \"\", VLOOKUP(G48,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L48=\"\", \"\", VLOOKUP(L48,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N48=\"\", \"\", VLOOKUP(N48,nma[],2,FALSE))","v":""},null,{"$f":"IF(P48=\"\", \"\", VLOOKUP(P48,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S48=\"\", \"\", VLOOKUP(S48,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V48=\"\", \"\", VLOOKUP(V48,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X48=\"\", \"\", VLOOKUP(X48,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA48=\"\", \"\", VLOOKUP(AA48,model[],2,FALSE))","v":""},null,{"$f":"IF(AC48=\"\", \"\", VLOOKUP(AC48,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF48=\"\", \"\", VLOOKUP(AF48,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH48=\"\", \"\", VLOOKUP(AH48,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ48=\"\", \"\", VLOOKUP(AJ48,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL48=\"\", \"\", VLOOKUP(AL48,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO48=\"\", \"\", VLOOKUP(AO48,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS48=\"\", \"\", VLOOKUP(AS48,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW48=\"\", \"\", VLOOKUP(AW48,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA48=\"\", \"\", VLOOKUP(BA48,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC48=\"\", \"\", VLOOKUP(BC48,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG48=\"\", \"\", VLOOKUP(BG48,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G49=\"\", \"\", VLOOKUP(G49,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L49=\"\", \"\", VLOOKUP(L49,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N49=\"\", \"\", VLOOKUP(N49,nma[],2,FALSE))","v":""},null,{"$f":"IF(P49=\"\", \"\", VLOOKUP(P49,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S49=\"\", \"\", VLOOKUP(S49,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V49=\"\", \"\", VLOOKUP(V49,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X49=\"\", \"\", VLOOKUP(X49,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA49=\"\", \"\", VLOOKUP(AA49,model[],2,FALSE))","v":""},null,{"$f":"IF(AC49=\"\", \"\", VLOOKUP(AC49,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF49=\"\", \"\", VLOOKUP(AF49,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH49=\"\", \"\", VLOOKUP(AH49,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ49=\"\", \"\", VLOOKUP(AJ49,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL49=\"\", \"\", VLOOKUP(AL49,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO49=\"\", \"\", VLOOKUP(AO49,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS49=\"\", \"\", VLOOKUP(AS49,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW49=\"\", \"\", VLOOKUP(AW49,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA49=\"\", \"\", VLOOKUP(BA49,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC49=\"\", \"\", VLOOKUP(BC49,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG49=\"\", \"\", VLOOKUP(BG49,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,null,null,{"$f":"IF(G50=\"\", \"\", VLOOKUP(G50,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(L50=\"\", \"\", VLOOKUP(L50,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(N50=\"\", \"\", VLOOKUP(N50,nma[],2,FALSE))","v":""},null,{"$f":"IF(P50=\"\", \"\", VLOOKUP(P50,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(S50=\"\", \"\", VLOOKUP(S50,state[],2,FALSE))","v":""},null,null,{"$f":"IF(V50=\"\", \"\", VLOOKUP(V50,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(X50=\"\", \"\", VLOOKUP(X50,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AA50=\"\", \"\", VLOOKUP(AA50,model[],2,FALSE))","v":""},null,{"$f":"IF(AC50=\"\", \"\", VLOOKUP(AC50,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AF50=\"\", \"\", VLOOKUP(AF50,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AH50=\"\", \"\", VLOOKUP(AH50,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AJ50=\"\", \"\", VLOOKUP(AJ50,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AL50=\"\", \"\", VLOOKUP(AL50,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AO50=\"\", \"\", VLOOKUP(AO50,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AS50=\"\", \"\", VLOOKUP(AS50,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AW50=\"\", \"\", VLOOKUP(AW50,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA50=\"\", \"\", VLOOKUP(BA50,owner[],2,FALSE))","v":""},null,{"$f":"IF(BC50=\"\", \"\", VLOOKUP(BC50,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BG50=\"\", \"\", VLOOKUP(BG50,criticality[],2,FALSE))","v":""}]

{"sheet":"Lookups","index":1,"n_rows":184,"n_cols":59,"rows_kept":184,"cut":false,"hidden":false,"merged":[]}
[null,"gps by.description","gps by.code",null,"gps method id.description","gps method id.code",null,"nma.description","nma.code",null,"transit region.description","transit region.code",null,"state.description","state.code",null,"asset type.description","asset type.code",null,"asset sub type.description","asset sub type.code",null,"make.description","make.code",null,"model.description","model.code",null,"supplier.description","supplier.code",null,"support type.description","support type.code",null,"control system.description","control system.code",null,"communications.description","communications.code",null,"maintained by.description","maintained by.code",null,"contract managed by.description","contract managed by.code",null,"side.description","side.code",null,"owner.description","owner.code",null,"condition rating.description","condition rating.code",null,"criticality.description","criticality.code",null,"national.contract"]
[null,"3M","3M",null,"Generic GPS Device",1,null,"Northland","1",null,"Northland","1",null,"In Service","1",null,"Cameras","1",null,"Fixed CCTV",1,null,"3M",1,null,214,2,null,"3M","3M",null,"Single Post support - Frangible","1POSTF",null,"AGD 331 Radar","AGD",null,"CDMA-cellular (Telecom)","CDMA",null,"3M","3M",null,"NZTA National Office","0",null,"Both","B",null,"Local Authority","LA",null,"Excellent","1",null,"High","1",null,"Yes"]
[null,"Automobile Association","AA",null,"User clicked on Map",2,null,"Bay of Plenty West","10",null,"Nelson-Marlborough","10",null,"In Store","2",null,"Signals","10",null,"Automatic number plate recognition",4,null,"Aaxeon",2,null,5230,124,null,"Access Security Ltd","ACCESS",null,"Single Post support - Non Frangible","1POSTN",null,"Centralo","CENT",null,"DSL","DSL",null,"Automobile Association","AA",null,"NZTA Regional Office","1",null,"Centre","C",null,"NZTA","NZTA",null,"Good","2",null,"Medium","2",null,"No "]
[null,"Auckland Council","ACC",null,"Update RAMM from Map",3,null,"Rotorua District","11",null,"Canterbury","11",null,"Unavailable","3",null,"Device Controllers","11",null,"Pan Tilt Zoom",10,null,"Absolyte",3,null,8500,8,null,"Alarm Centre Installation Ltd","ACI",null,"Cantilever Arm off Mast","ARMC",null,"DVTel","DVT",null,"NZTA Fibre","FIBRE",null,"Auckland Council","ACC",null,"Marlborough District Council","11",null,"Left","L",null,"Other (police etc.)","OTH",null,"Average","3",null,"Low","3",null,"Not Applicable "]
[null,"Alarm Centre Installation Ltd","ACI",null,"Taken from Asset (RAMM Generated)",5,null,"Gisborne","12",null,"West Coast","12",null,"Disposed","4",null,"Power Supply","12",null,"Thermal camera",106,null,"Alarm Centre Installation Ltd",4,null,8624,9,null,"Advanced Portable Technologies Ltd","APT",null,"Arm on top of Mast","ARMT",null,"DYNAC","DYNAC",null,"GSM Cellular (Vodafone)","GSM",null,"Alarm Centre Installation Ltd","ACI",null,"Metservice","2",null,"Right","R",null,null,null,null,"Poor","4"]
[null,"Agfirst","AGF",null,"Taken from Asset ( Aerial Photograpgy)",6,null,"Hawkes Bay","13",null,"Otago","13",null,null,null,null,"Communications and Transmission","13",null,"Red light",107,null,"Alan Bradley",5,null,9752.125,10,null,"Armitage Systems","ARMITAGE",null,"Banded (onto structure / pole)","BAND",null,"HMI Tweaker 2 Controller","HMI",null,"None","NONE",null,"Agfirst","AGF",null,"Christchurch City Council","3",null,null,null,null,null,null,null,"Very Poor","5"]
[null,"Abley Ltd","AL",null,"Default",7,null,"West Wanganui","14",null,"Southland","14",null,null,null,null,"Electronic Signs","3",null,"Automatic Vehicle Incident Detection Camera",125,null,"Aldridge Signs",6,null,"1100 Mitto",1,null,"Alan Shaw Electrical","ASHAW",null,"Bracket","BRACKET",null,"Jam Logic","JAM",null,"OOL","OOL",null,"Abley Ltd","AL",null,"Waitomo DC","4"]
[null,"Auckland Motorway Alliance","AMA",null,"No GPS lock",8,null,"East Wanganui","15",null,"National Office","15",null,null,null,null,"Environmental Sensors","4",null,"Web Camera",126,null,"Allied Telesys",7,null,"32-16-98 VMS-Amber",3,null,"Aspect Solutions Ltd (ASL)","ASL",null,"Inside of Cabinet","CAB",null,"VMS MACA","MACA",null,"Plain Old Telephone Service","POTS",null,"Auckland Motorway Alliance","AMA",null,"Private","5"]
[null,"Asset Management Engineers Ltd","AME",null,"GPS but no differential correction",9,null,"Wellington","16",null,"Auckland","2",null,null,null,null,"Electronic Barriers & Gates","5",null,"Advanced Warning Sign",29,null,"Alloy Computer Services",8,null,"40-24-98-VMS-Amber",4,null,"Astute","ASTUTE",null,"Cantilever support - Fixed Frangible","CANTF",null,"Metconnect Website","MET",null,"RF","RF",null,"Asset Management Engineers Ltd","AME",null,"TDC","6"]
[null,"Asset Management Technicians Ltd","AMT",null,"GPS with differential correction",10,null,"Nelson","17",null,"Waikato","3",null,null,null,null,"Enclosures","6",null,"Changeable Message Sign",30,null,"Alplug",9,null,"7601E",7,null,"Aspect Technology & Equipement Ltd","ATE",null,"Cantilever support - Fixed Non Frangible","CANTN",null,"None","NONE",null,"Satellite","SAT",null,"Asset Management Technicians Ltd","AMT",null,"Rotorua Disctrict Council","7"]
[null,"Armitage Systems","ARM",null,"RTK GPS",11,null,"Marlborough Roads","18",null,"Bay of Plenty","4",null,null,null,null,"Vehicle Sensors & Detection processors","7",null,"Mobile VMS",33,null,"Altaroute (UK)",10,null,"Ablerex MP RT1000-24",140,null,"Braums Pty Ltd","BRAUMS",null,"Cantilever support - Rotating","CANTR",null,"SCATS","SCATS",null,"Sigfox","SIGF",null,"Armitage Systems","ARM",null,"Trust Power","8"]
[null,"Aspect Solutions Ltd","ASL",null,"Smart phone",12,null,"North Canterbury","19",null,"Gisborne","5",null,null,null,null,null,null,null,"School Zone Sign",35,null,"Adaptive Micro Systems",11,null,"AT8624T/2M",131,null,"Brian Ward","BWARD",null,"Combination Post support - Frangible / Rotating Flange","CPOST",null,"TIM","TIM",null,"Vodafone 3G","VODA",null,"Aspect Solutions Ltd","ASL",null,"Tauranga City Council","9"]
[null,"Auckland System Management","ASM",null,"External GPS (such as bluetooth/usb)",13,null,"PSMC 005","2",null,"Hawkes Bay","6",null,null,null,null,null,null,null,"Speed Indication Device",36,null,"Andrews",12,null,"AT8624T/2M-V2-40",13,null,"Cable Ways","CABLE",null,"Dual Post support - Frangible","DPOSTF",null,"TMS","TMS",null,"Wide Area Network (Ethernet)","WAN",null,"Auckland System Management","ASM"]
[null,"Auckland Transport","AT2",null,"CAD drawing",14,null,"South Canterbury","20",null,"Taranaki","7",null,null,null,null,null,null,null,"Variable Message Sign",37,null,"Aspect Solutions Ltd",13,null,"AT9924T",14,null,"Channel 10","CHNL10",null,"Dual Post support - Non Frangible","DPOSTN",null,"WWW(Internet)","WWW",null,"XT-cellular (Telecom)","XT",null,"Auckland Transport","AT2"]
[null,"Aspect Technology and Equipment Ltd","ATE",null,"Survey grade GPS without differential correction",15,null,"West Coast","21",null,"Manawatu-Whanganui","8",null,null,null,null,null,null,null,"Bend Warning Sign",102,null,"Astron",14,null,"AT-AR440S",12,null,"Computer Dynamics","COMP",null,"Emergency Phone Housing pole mount (banded)","EPHPOLE",null,null,null,null,null,null,null,"Aspect Technology and Equipment Ltd","ATE"]
[null,"ARRB Transport Research Ltd","ATR",null,"Survey grade GPS with differential correction",16,null,"Coastal Otago","22",null,"Wellington","9",null,null,null,null,null,null,null,"Environmental Stn",40,null,"Aspect Technology & Equipment Ltd",15,null,"AT-GS950/8",132,null,"Connector Systems","CONN",null,"Emergency Phone Housing Wall mounted","EPHWALL",null,null,null,null,null,null,null,"ARRB Transport Research Ltd","ATR"]
[null,"Auckland University","AUN",null,null,null,null,"Central Otago","23",null,null,null,null,null,null,null,null,null,null,"Humidity Device",41,null,"Axis",16,null,"AT-X210 9GT",142,null,"Cory's Electrical","CORY",null,"15m Folding CCTV Pole","FOLD",null,null,null,null,null,null,null,"Auckland University","AUN"]
[null,"Broadspectrum (NZ) Ltd","B(L",null,null,null,null,"Southland","24",null,null,null,null,null,null,null,null,null,null,"Rainfall Meter",42,null,"Beca",17,null,"AT-X510 28GTX",143,null,"Connect Security","CONNECT",null,"Integrated Support (Camera)","INTSUP",null,null,null,null,null,null,null,"Broadspectrum (NZ) Ltd","B(L"]
[null,"Bri-Ken and Associates Ltd","BAA",null,null,null,null,"National Office","25",null,null,null,null,null,null,null,null,null,null,"Sound Measuring Device",43,null,"Band Pass",18,null,"AT-x930-28GSTX",133,null,"Combined Road & Traffic Services","CRTS",null,"Mast","MAST",null,null,null,null,null,null,null,"Bri-Ken and Associates Ltd","BAA"]
[null,"Bartley Consultants Ltd","BAR",null,null,null,null,"Auckland","3",null,null,null,null,null,null,null,null,null,null,"Temperature Sensor",44,null,"Bosch",19,null,"AWS_A",145,null,"CSL","CSL",null,"Multiple Post support - Frangible","MPOSTF",null,null,null,null,null,null,null,"Bartley Consultants Ltd","BAR"]
[null,"Bloxam Burnett & Olliver Ltd","BB&",null,null,null,null,"West Waikato","4",null,null,null,null,null,null,null,null,null,null,"Wind Monitor",46,null,"BP Solar",20,null,"AWS_B",146,null,"CSP","CSP",null,"Multiple Post support - Non Frangible","MPOSTN",null,null,null,null,null,null,null,"Bloxam Burnett & Olliver Ltd","BB&"]
[null,"Beca Infrastructure","BCF",null,null,null,null,"PSMC 006","5",null,null,null,null,null,null,null,null,null,null,"Ice Detection System",82,null,"Cable Ways",21,null,"Axis P3343-VE",70,null,"Currie Electrical Ltd","CUR",null,"No Support","NONE",null,null,null,null,null,null,null,"Beca Infrastructure","BCF"]
[null,"Buller District Council","BDC",null,null,null,null,"East Waikato","6",null,null,null,null,null,null,null,null,null,null,"Flow detector",116,null,"Cisco",22,null,"Axis P5512-E",71,null,"Daktronics","DAK",null,"Emergency Phone Pedestal Mount (Mains) Frangible","PEDMF",null,null,null,null,null,null,null,"Buller District Council","BDC"]
[null,"Blacktop","BLA",null,null,null,null,"Central Waikato","7",null,null,null,null,null,null,null,null,null,null,"Hydrocarbon sensor",117,null,"Clearsonics",23,null,"Axis Q6115-E",185,null,"Direct Earth","DIREARTH",null,"Emergency Phone Pedestal Mount (Mains) Non Frangible","PEDMN",null,null,null,null,null,null,null,"Blacktop","BLA"]
[null,"Beca Ltd.","BLT",null,null,null,null,"Tauranga City","8",null,null,null,null,null,null,null,null,null,null,"Automated Barriers",47,null,"Cell Reach",24,null,"Axis Q6215",141,null,"Dove Electronics","DOVE",null,"Emergency Phone Pedestal Mount (Solar) Frangible","PEDSF",null,null,null,null,null,null,null,"Beca Ltd.","BLT"]
[null,"Civil Assist Ltd","CAL",null,null,null,null,"Bay of Plenty East","9",null,null,null,null,null,null,null,null,null,null,"Automatic Traffic Control Gates",48,null,"Clipsal",25,null,"Axis Q7401",128,null,"Egley Electrical","EGLEY",null,"Emergency Phone Pedestal Mount (Solar) Non Frangible","PEDSN",null,null,null,null,null,null,null,"Civil Assist Ltd","CAL"]
[null,"Christchurch City Council","CCC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flashing Beacons",104,null,"Campbell Scientific",26,null,"AXIS213",15,null,"Electricians HB","ELECHB",null,"Pole Mount (Camera)","POLE",null,null,null,null,null,null,null,"Christchurch City Council","CCC"]
[null,"City Care Ltd","CCL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full Advanced Traffic Management Systems",59,null,"Commander",27,null,"B31206",115,null,"Elite Doors","ELITE",null,"Rack Mount (equipment)","RACK",null,null,null,null,null,null,null,"City Care Ltd","CCL"]
[null,"Currie Electrical Ltd.","CEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mounted",62,null,"Commscope",28,null,"Bosch",153,null,"ELWC Australia","ELWC",null,"Standoff attached to structure","STAND",null,null,null,null,null,null,null,"Currie Electrical Ltd.","CEL"]
[null,"Company-X Ltd.","CL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mini ATMS",65,null,"Connection Technology Systems",29,null,"Bosch Auto Dome 300",157,null,"Engineering Computer Services","ENGCS",null,"U-Shape support - Frangible","UPOSTF",null,null,null,null,null,null,null,"Company-X Ltd.","CL"]
[null,"Critchlow Limited","CL2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regional VMS",70,null,"Combined Road & Traffic Services",30,null,"Bosch Fixed",156,null,"ETL Systems","ETL",null,"U-Shape support - Non Frangible","UPOSTN",null,null,null,null,null,null,null,"Critchlow Limited","CL2"]
[null,"Coastline Markers Ltd","CML",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signal Controller",73,null,"Ctek Inc",31,null,"Bosch G4",158,null,"Fulton Hogan","FH",null,"Walkway Bracket","WALK",null,null,null,null,null,null,null,"Coastline Markers Ltd","CML"]
[null,"CoreLogic NZ Ltd.","CNL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traffic Monitoring System",96,null,"Coaxial",32,null,"Bosch UPH",155,null,"Fusion Systems","FUSION",null,null,null,null,null,null,null,null,null,null,"CoreLogic NZ Ltd.","CNL"]
[null,"Central Otago District Council","COD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Node ATMS",128,null,"Daktronics",33,null,"Bosh 300 Series 18xD/N Envirodome",116,null,"Gate Drive Solutions ","GATE",null,null,null,null,null,null,null,null,null,null,"Central Otago District Council","COD"]
[null,"Other Contractor","CON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Inductive Loop Detector",81,null,"Digi",34,null,"BT55-12FT",16,null,"General Electric","GE",null,null,null,null,null,null,null,null,null,null,"Other Contractor","CON"]
[null,"CSL Traffic","CSL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inductive Loops",83,null,"Ditech",35,null,"CM6800E 48x8",17,null,"Geni","GENI",null,null,null,null,null,null,null,null,null,null,"CSL Traffic","CSL"]
[null,"Connell Wagner Ltd","CWL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vehicle Detection Processor/Aggregator",86,null,"Direct Logic",36,null,"CS Autodome 600",114,null,"Gilbert Sheet Metals","GILBERT",null,null,null,null,null,null,null,null,null,null,"Connell Wagner Ltd","CWL"]
[null,"Dunedin City Council","DCC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Radar",89,null,"DVTel",37,null,"CTV100BTFX/W2",18,null,"Hills Security","HILLS",null,null,null,null,null,null,null,null,null,null,"Dunedin City Council","DCC"]
[null,"D & L Crowe Ltd","DLC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wireless Vehicle Tracking Systems",99,null,"Ecocounter",38,null,"D1010",19,null,"HMI Technologies","HMI",null,null,null,null,null,null,null,null,null,null,"D & L Crowe Ltd","DLC"]
[null,"Spiire NZ Ltd","DWK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Magnetometers",108,null,"EIS",39,null,"D2125",20,null,"Harding Traffic Ltd","HTL",null,null,null,null,null,null,null,null,null,null,"Spiire NZ Ltd","DWK"]
[null,"Excell Corporation","ECL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Light Sensitive Detection",109,null,"Electrex",40,null,"D8030",21,null,"Hynds","HYNDS",null,null,null,null,null,null,null,null,null,null,"Excell Corporation","ECL"]
[null,"Ferguson Ind","FGI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Load Cell",110,null,"Emerson",41,null,"Dahua IR",160,null,"Integrated Automation Ltd","IAL",null,null,null,null,null,null,null,null,null,null,"Ferguson Ind","FGI"]
[null,"Fulton Hogan (NZ) Ltd.","FUL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tubes",111,null,"Enatel",42,null,"Datataker DT50",24,null,"Ingram Micro","INGRAM",null,null,null,null,null,null,null,null,null,null,"Fulton Hogan (NZ) Ltd.","FUL"]
[null,"Gisborne District Council","GDC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Piezo Detector",112,null,"Erico",43,null,"DEF",152,null,"Intek","INTEK",null,null,null,null,null,null,null,null,null,null,"Gisborne District Council","GDC"]
[null,"Geosolve Ltd","GEO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bluetooth Detector",113,null,"Electronic Transformer Engineering",44,null,"Dinion XF D/N IP",22,null,"Inzone","INZ",null,null,null,null,null,null,null,null,null,null,"Geosolve Ltd","GEO"]
[null,"GHD Ltd.","GHD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Distributed Acoustic Sensing",114,null,"Eaton",45,null,"DRD11A",23,null,"Metservice","MET",null,null,null,null,null,null,null,null,null,null,"GHD Ltd.","GHD"]
[null,"Hamilton City Council","HCC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Radio Frequency Identification",115,null,"Exicom",46,null,"DVT EZ201-0",25,null,"Motorola","MROLA",null,null,null,null,null,null,null,null,null,null,"Hamilton City Council","HCC"]
[null,"Hauraki District Council","HDC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lane Signal Units",32,null,"Fluidmesh",47,null,"DVT7401 E",26,null,"Nutech Security","NUT",null,null,null,null,null,null,null,null,null,null,"Hauraki District Council","HDC"]
[null,"HEB Construction Ltd","HEB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable Mandatory Speed Sign",38,null,"Flexicom",48,null,"DVT7601 E",27,null,"Local NZ Metalwork Shop","NZMETAL",null,null,null,null,null,null,null,null,null,null,"HEB Construction Ltd","HEB"]
[null,"Higgins Contractors Ltd.","HIG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable Speed Sign",39,null,"Formolite",49,null,"DVT7801 E",28,null,"Optimal Power","OPTIM",null,null,null,null,null,null,null,null,null,null,"Higgins Contractors Ltd.","HIG"]
[null,"HMI Technologies","HMI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traffic Signals",97,null,"Fuse",50,null,"DVT7801 PEA",29,null,"Philips","PHIL",null,null,null,null,null,null,null,null,null,null,"HMI Technologies","HMI"]
[null,"HERE New Zealand Ltd","HNZ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lane Lighting",103,null,"General Electric",51,null,"ECO-TWIN",30,null,"Power Electrical Contractors","POWER",null,null,null,null,null,null,null,null,null,null,"HERE New Zealand Ltd","HNZ"]
[null,"Horizon Services Ltd","HSL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Road Side Controller",54,null,"Generic",52,null,"ECPGNVANA 7040140",117,null,"Powertech Nelson","PTECH",null,null,null,null,null,null,null,null,null,null,"Horizon Services Ltd","HSL"]
[null,"HTS Group","HTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLC Controller",68,null,"Gilbert Sheet Metals",53,null,"ECX2-62G-8-16",123,null,"Rittal","RITTAL",null,null,null,null,null,null,null,null,null,null,"HTS Group","HTS"]
[null,"Inframix Construction Ltd","IMX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remote Reboot Unit",69,null,"GoldenLeaf",54,null,"EH2512-EH2500 Series Enclosure",31,null,"RTL","RTL",null,null,null,null,null,null,null,null,null,null,"Inframix Construction Ltd","IMX"]
[null,"Inzone","INZ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VMS Controller Cards",79,null,"Golden River",55,null,"EH2515",32,null,"SEKTOR","SEKTOR",null,null,null,null,null,null,null,null,null,null,"Inzone","INZ"]
[null,"Isaac Construction","ISC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signal Controller Device",105,null,"Guardian",56,null,"EH3515-2",33,null,"Signopsys Electronic Signs","SIGNOPS",null,null,null,null,null,null,null,null,null,null,"Isaac Construction","ISC"]
[null,"Island Asphalts","ISL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Battery",52,null,"Harvest Electronics",57,null,"EP1000LRT",34,null,"Sound Logic Systems","SOUND",null,null,null,null,null,null,null,null,null,null,"Island Asphalts","ISL"]
[null,"ITS","ITS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Isolating Transformer",61,null,"Haze",58,null,"ES31C22-2N-X",35,null,"Spunlite","SPUN",null,null,null,null,null,null,null,null,null,null,"ITS","ITS"]
[null,"Jacobs New Zealand Ltd","JAC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solar Panel",75,null,"Helios Technologies",59,null,"ES31CBW35",36,null,"Struthers Security","STS",null,null,null,null,null,null,null,null,null,null,"Jacobs New Zealand Ltd","JAC"]
[null,"JCW Consultant","JC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uninterrupted Power Supply",76,null,"Hi Tech",60,null,"ES41E36",125,null,"Traffic Control Systems","TCS",null,null,null,null,null,null,null,null,null,null,"JCW Consultant","JC"]
[null,"JCL Asphalt subcontractor","JCL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low Voltage Power",118,null,"HMI Technologies",61,null,"ES5230-12N",126,null,"Transfield Services","TFD",null,null,null,null,null,null,null,null,null,null,"JCL Asphalt subcontractor","JCL"]
[null,"JJ Walters","JJW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transformers",119,null,"Hengstier",62,null,"ES5230-15NP",164,null,"Traffic Systems","TRA",null,null,null,null,null,null,null,null,null,null,"JJ Walters","JJW"]
[null,"Johnstone & Masters Ltd","JM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inverters",120,null,"Harding Traffic Ltd",63,null,"ESMW03",118,null,"Traficon","TRAF",null,null,null,null,null,null,null,null,null,null,"Johnstone & Masters Ltd","JM"]
[null,"NZTA (JTOC)","JTO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gensets",121,null,"Hewlett Packard",64,null,"ESMW04",119,null,"Traffic Signs NZ Ltd","TS",null,null,null,null,null,null,null,null,null,null,"NZTA (JTOC)","JTO"]
[null,"Juno Services Ltd","JUN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuel Cell",122,null,"Innovative Battery Technology",65,null,"Esprite",37,null,"Tyco","TYCO",null,null,null,null,null,null,null,null,null,null,"Juno Services Ltd","JUN"]
[null,"Kapiti Coast District Council","KCD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cables",123,null,"International Fibre Systems",66,null,"F05302610",122,null,"Zone Technology","ZONE",null,null,null,null,null,null,null,null,null,null,"Kapiti Coast District Council","KCD"]
[null,"Kampung Consulting Ltd.","KCL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emergency Telephone System",25,null,"Ikigami",67,null,"FC-644-ID",161,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kampung Consulting Ltd.","KCL"]
[null,"Kelcroft Engineering","KEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ethernet Switches",58,null,"Jaycar",68,null,"FCHA1-DB1-M1T-MSE",39,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kelcroft Engineering","KEL"]
[null,"Local Authority","LA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wireless Device",60,null,"James Hardie",69,null,"FCHA1-M1T-WSE",38,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local Authority","LA"]
[null,"Lonrix Ltd","LL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analogue Video Matrix Switch",63,null,"KBC Networks",70,null,"FCU18025SC-S15",40,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lonrix Ltd","LL"]
[null,"McKays Consultants","MCC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Media Converter",64,null,"Kathrein",71,null,"FD12",41,null,null,null,null,null,null,null,null,null,null,null,null,null,"McKays Consultants","MCC"]
[null,"Matamata-Piako District Council","MD2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multiplexer",67,null,"LG",72,null,"Flexidome",159,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matamata-Piako District Council","MD2"]
[null,"Manawatu District Council","MDC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serial Server",72,null,"Li COR",73,null,"FLIR",154,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manawatu District Council","MDC"]
[null,"McKay Electrical Ltd","MEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modem",78,null,"CS Linin",74,null,"FM1200V-HW",127,null,null,null,null,null,null,null,null,null,null,null,null,null,"McKay Electrical Ltd","MEL"]
[null,"Aecom NZ Ltd","MER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cables - Copper",93,null,"MagDrive",75,null,"G4 Dome",42,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aecom NZ Ltd","MER"]
[null,"MetService","MET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fibre",124,null,"Match",76,null,"Generic Prism CMS",43,null,null,null,null,null,null,null,null,null,null,null,null,null,"MetService","MET"]
[null,"Marlborough NOC JV","MJV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fibre Joint",127,null,"McFarlanes",77,null,"GXT2-1500 RT0230",44,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marlborough NOC JV","MJV"]
[null,"McKay Ltd.","ML",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McVan Instruments",78,null,"GXT2-V8VBATT",45,null,null,null,null,null,null,null,null,null,null,null,null,null,"McKay Ltd.","ML"]
[null,"Marlborough Roads","MR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Micronet",79,null,"H6ZE-R",46,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marlborough Roads","MR"]
[null,"MWH NZ Ltd.","MWH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mitsubishi",80,null,"HD interceptor",139,null,null,null,null,null,null,null,null,null,null,null,null,null,"MWH NZ Ltd.","MWH"]
[null,"Napier City Council","NCC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOXA",81,null,"HD_S125 Smart Sensor",47,null,null,null,null,null,null,null,null,null,null,null,null,null,"Napier City Council","NCC"]
[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,"Motorola",82,null,"HIPath 3300/3500",48,null,null,null,null,null,null,null,null,null,null,null,null,null,"NZ Transport Agency - Highway Programme","NTA"]
[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,"Not Applicable",83,null,"HZC 10/200",49,null,null,null,null,null,null,null,null,null,null,null,null,null,"NZ Transport Agency - Funding","NTF"]
[null,"North Power","NTH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Narada",84,null,"Interceptor",162,null,null,null,null,null,null,null,null,null,null,null,null,null,"North Power","NTH"]
[null,"Nutech Security","NUT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local NZ Metalwork Shop",85,null,"KBD-300A",50,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nutech Security","NUT"]
[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,"O Gara",86,null,"LC903P-B",51,null,null,null,null,null,null,null,null,null,null,null,null,null,"Odyssey Energy (2009) Ltd.","OE("]
[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,"Optimal Power",87,null,"LCP903P-B",52,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opus International Consultants Ltd (NZ)","OI2"]
[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,"Optical Systems Design",88,null,"LTC0498/11",53,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opus International Consultants Ltd.","OIC"]
[null,"Oldfields","OLD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pacific Communications",89,null,"LTC3374/21 5-50mm 1:1.4",54,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oldfields","OLD"]
[null,"Porirua City Council","PCC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Panasonic",90,null,"LTC3674/20",55,null,null,null,null,null,null,null,null,null,null,null,null,null,"Porirua City Council","PCC"]
[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,"PAT",91,null,"LTC610",56,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pinnacles Civil Group Ltd.","PCG"]
[null,"Pope Electrical Ltd","PE2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pelco",92,null,"LTC9215/00",57,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pope Electrical Ltd","PE2"]
[null,"Pope Electrical Limited","PEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pelican",93,null,"LVC-C553HP (PAL)",58,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pope Electrical Limited","PEL"]
[null,"Pavement Management Services","PMS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pentax",94,null,"M3057",182,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pavement Management Services","PMS"]
[null,"Power Solutions Ltd","PSL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Philips",95,null,"M4200E Skyrouter (CDMA modems only)",5,null,null,null,null,null,null,null,null,null,null,null,null,null,"Power Solutions Ltd","PSL"]
[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,"Phoenix Contact",96,null,"M4400E Skyrouter (XT modems only)",6,null,null,null,null,null,null,null,null,null,null,null,null,null,"Queenstown-Lakes District Council","QDC"]
[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,"Projecta",97,null,"Marksman 720",59,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quality Roading and Services","QRS"]
[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,"Power Save",98,null,"MC103XL-40",60,null,null,null,null,null,null,null,null,null,null,null,null,null,"Read-only access for Tenderers","RAF"]
[null,"Rangitikei District Council","RDC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Powertech",99,null,"MS3 - Bespoke Full Size",61,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rangitikei District Council","RDC"]
[null,"Roadex","RDX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QTC",100,null,"MS3 - Bespoke Small",62,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadex","RDX"]
[null,"Rotorua Lakes Council","RLC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reid Technologies",101,null,"MX4016CS-X",63,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rotorua Lakes Council","RLC"]
[null,"Roading Logistics Ltd","RLL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rittal",102,null,"NDN-948V03-11PS",65,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roading Logistics Ltd","RLL"]
[null,"Rationale Ltd","RLT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RM Young",103,null,"Not Applicable",64,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rationale Ltd","RLT"]
[null,"Rotorua District Council","ROT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RTL",104,null,"NPort 5100 series",66,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rotorua District Council","ROT"]
[null,"RAMM Software Limited","RSL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scott Technical Instruments",105,null,"NTCIP VMSS",67,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAMM Software Limited","RSL"]
[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,"Seikou",106,null,"OSD 420 Tx/Rx",68,null,null,null,null,null,null,null,null,null,null,null,null,null,"Road Signs & Traffic Control Equipment Limited","RTL"]
[null,"Russell Roads","RUS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sensable Sensors",107,null,"OSD370 19\"\" 3RU",69,null,null,null,null,null,null,null,null,null,null,null,null,null,"Russell Roads","RUS"]
[null,"Salient Consultants","SAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sick",108,null,"P1435-LE",174,null,null,null,null,null,null,null,null,null,null,null,null,null,"Salient Consultants","SAL"]
[null,"Sealcoat Central Ltd.","SCL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Siemens",109,null,"P3225-LVE MK11",169,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sealcoat Central Ltd.","SCL"]
[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,"Signopsys Electronic Signs",110,null,"P3365",170,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shaw's Consulting Services Ltd","SCS"]
[null,"Southland District Council","SDC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Smart",111,null,"PDR-9LX 750GB",72,null,null,null,null,null,null,null,null,null,null,null,null,null,"Southland District Council","SDC"]
[null,"Signopsys Electronic Signs","SES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SMC",112,null,"Pedestal",130,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signopsys Electronic Signs","SES"]
[null,"Sicon Ltd.","SL2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solarex",113,null,"Pelco Dome",167,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sicon Ltd.","SL2"]
[null,"Stantec New Zealand","SN2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sony",114,null,"Pelco Esprit",168,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stantec New Zealand","SN2"]
[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,"Sound Logic Systems",115,null,"PIH-6032",73,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stantec New Zealand Ltd","SNZ"]
[null,"SouthRoads Ltd.","SOU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spunlite",116,null,"Q1765-LE",171,null,null,null,null,null,null,null,null,null,null,null,null,null,"SouthRoads Ltd.","SOU"]
[null,"Safe Roads Alliance","SRA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Still Air",117,null,"Q1785-LE",173,null,null,null,null,null,null,null,null,null,null,null,null,null,"Safe Roads Alliance","SRA"]
[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,"Suntech",118,null,"Q6032-E",178,null,null,null,null,null,null,null,null,null,null,null,null,null,"Services South East (NZ) Ltd.","SS2"]
[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,"SUNX",119,null,"Q6114",175,null,null,null,null,null,null,null,null,null,null,null,null,null,"Services South East Pty Ltd","SSE"]
[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,"Sixnet",120,null,"Q6114-E",180,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tonkin & Taylor Ltd","T&T"]
[null,"Tasman Howey","TAS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tait",121,null,"Q6115",176,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tasman Howey","TAS"]
[null,"NZTA and WDM","TAW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Termopto",122,null,"Q6124",177,null,null,null,null,null,null,null,null,null,null,null,null,null,"NZTA and WDM","TAW"]
[null,"Tauranga City Council","TC2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trace",123,null,"Q6124-E",129,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tauranga City Council","TC2"]
[null,"Taranaki Civil Construction","TCC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traficon",124,null,"Q6125",181,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taranaki Civil Construction","TCC"]
[null,"TC Nicholls","TCN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trans Pac",125,null,"Q6125-LE",179,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC Nicholls","TCN"]
[null,"Traffic Control Systems","TCS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trio Communications",126,null,"Q8612-LE",186,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traffic Control Systems","TCS"]
[null,"Taupo District Council","TD2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TriStar",127,null,"Quasar CP-3211-181",120,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taupo District Council","TD2"]
[null,"Tasman District Council","TDC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transition Networks",128,null,"REG-L1875",75,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tasman District Council","TDC"]
[null,"The Datastack Ltd","TDL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tyco",129,null,"Rimco 8020",74,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Datastack Ltd","TDL"]
[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,"Unidata",130,null,"RTMS K3 IP",76,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taupo East Traffic Services Contractor","TET"]
[null,"Broadspectrum (NZ) Ltd","TFD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown",131,null,"SDIII WV-CP484",77,null,null,null,null,null,null,null,null,null,null,null,null,null,"Broadspectrum (NZ) Ltd","TFD"]
[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,"Vaisala",132,null,"SMCFS5",78,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waka Kotahi NZ Transport Agency","TNZ"]
[null,"Top Energy","TOP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ver-Mac",133,null,"SP3105AS",79,null,null,null,null,null,null,null,null,null,null,null,null,null,"Top Energy","TOP"]
[null,"The Roading Company","TRC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Viasat",134,null,"SPE Modem",80,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Roading Company","TRC"]
[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,"Viasis",135,null,"SPEC IV",163,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transfield Services (NZ) Ltd","TS("]
[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,"VMSL",136,null,"Spectra IV SD435-F1-X",81,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tonkin and Taylor Ltd","TT"]
[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,"Wanco Inc Denver Colorado",137,null,"Spectra IV SD435-PG-E1-X",82,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tyco Traffic and Transportation","TYC"]
[null,"Urban Connection Ltd","UCL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wavetronics",138,null,"SSC DC83P",83,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urban Connection Ltd","UCL"]
[null,"Unknown","UKN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wema",139,null,"Swarco colour Motorway",138,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unknown","UKN"]
[null,"University of Canterbury","UOC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WTI",140,null,"TC450SR",84,null,null,null,null,null,null,null,null,null,null,null,null,null,"University of Canterbury","UOC"]
[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,"Hynds",141,null,"TXB-N-ADXFGE6",166,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ventia NZ Operations Limited","VNO"]
[null,"Ventia Pty Ltd","VPL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SWARCO",142,null,"UCL900DM / WYA904",85,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ventia Pty Ltd","VPL"]
[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,"DMV",143,null,"Unknown",86,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Bay of Plenty District Council","WBO"]
[null,"Wellington City Council","WCC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direct Earth",144,null,"UP80E",87,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wellington City Council","WCC"]
[null,"Waimakariri District Council","WD2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGD Systems Limited",145,null,"VDT14130",88,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waimakariri District Council","WD2"]
[null,"Whakatane District Council","WD3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FLIR Systems",146,null,"Vector W200P",112,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whakatane District Council","WD3"]
[null,"Wairoa District Council","WD4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indigovision",147,null,"Vextor A101M",11,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wairoa District Council","WD4"]
[null,"Waipa District Council","WD5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dahua Technology",148,null,"VF1000-18-90-18R",89,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waipa District Council","WD5"]
[null,"Waikato District Council","WD6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bob Panich",149,null,"VF1000-27x105-12-R",90,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waikato District Council","WD6"]
[null,"Whangarei District Council","WDC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CA Traffic",150,null,"VF1000-27x105-18-R",91,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whangarei District Council","WDC"]
[null,"WDM","WDM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Allen-Bradley",151,null,"VG4-513-ECSOP",92,null,null,null,null,null,null,null,null,null,null,null,null,null,"WDM","WDM"]
[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,"Rota Panel",152,null,"Vip X1 05500253",165,null,null,null,null,null,null,null,null,null,null,null,null,null,"WSP-Opus International Consultants Ltd","WIC"]
[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,"Humes",153,null,"VIPX1",93,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downer New Zealand Limited","WIL"]
[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,"Orion",154,null,"VIPX1 Integrated",94,null,null,null,null,null,null,null,null,null,null,null,null,null,"W J Ashton Service Ltd","WJA"]
[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,"IPS Group",155,null,"Vision SID",106,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waka Kotahi NZ Transport Agency - Highways","WK2"]
[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,"Sika",156,null,"VMS 18-400",121,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waka Kotahi NZ Transport Agency","WKN"]
[null,"WSP New Zealand Ltd","WNZ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vivotech",157,null,"VMS Type A",95,null,null,null,null,null,null,null,null,null,null,null,null,null,"WSP New Zealand Ltd","WNZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VMS Type B",96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VMS Type C",97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VMS Type D",98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VMS Type F",99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VMS_AC",147]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VMS_DUC",148]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VMS_MA",149]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VMS_MC",150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VMS_OC",151]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VMSS-21X30-9-R",100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VR100",101]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VR1530",102]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VR1810",103]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VR1910",104]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VR7830",105]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VT1010",107]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VT1530",108]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VT1910",109]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VT7230",110]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VT7430",111]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wall Style",144]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WS/WE45",113]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x210-9GT",134]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x510-28GT",135]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x510-28GTX",136]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x900-24XT",137]