{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Its","Lookups"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":39,"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":63,"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","a227936d-24b7-46ce-914b-4f2d0985727b_site","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","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","ab6aabbb-96f6-47e3-98b4-a9da2e92e728_notes"]
["road_id","sh-rs-d","start_m","street_address","site_desc","site","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","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","notes"]
["Road Id","SH-RS-D  (e.g. 016-0000-B) letter must be uppercase and include leading 0","Location (RP)","Street Address","Site Desc","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","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","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,{"$f":"IF(E4=\"\", \"\", VLOOKUP(E4,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H4=\"\", \"\", VLOOKUP(H4,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M4=\"\", \"\", VLOOKUP(M4,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O4=\"\", \"\", VLOOKUP(O4,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q4=\"\", \"\", VLOOKUP(Q4,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T4=\"\", \"\", VLOOKUP(T4,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W4=\"\", \"\", VLOOKUP(W4,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y4=\"\", \"\", VLOOKUP(Y4,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB4=\"\", \"\", VLOOKUP(AB4,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE4=\"\", \"\", VLOOKUP(AE4,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG4=\"\", \"\", VLOOKUP(AG4,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI4=\"\", \"\", VLOOKUP(AI4,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK4=\"\", \"\", VLOOKUP(AK4,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN4=\"\", \"\", VLOOKUP(AN4,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR4=\"\", \"\", VLOOKUP(AR4,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV4=\"\", \"\", VLOOKUP(AV4,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ4=\"\", \"\", VLOOKUP(AZ4,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB4=\"\", \"\", VLOOKUP(BB4,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF4=\"\", \"\", VLOOKUP(BF4,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,{"$f":"IF(E5=\"\", \"\", VLOOKUP(E5,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H5=\"\", \"\", VLOOKUP(H5,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M5=\"\", \"\", VLOOKUP(M5,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O5=\"\", \"\", VLOOKUP(O5,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q5=\"\", \"\", VLOOKUP(Q5,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T5=\"\", \"\", VLOOKUP(T5,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W5=\"\", \"\", VLOOKUP(W5,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y5=\"\", \"\", VLOOKUP(Y5,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB5=\"\", \"\", VLOOKUP(AB5,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE5=\"\", \"\", VLOOKUP(AE5,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG5=\"\", \"\", VLOOKUP(AG5,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI5=\"\", \"\", VLOOKUP(AI5,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK5=\"\", \"\", VLOOKUP(AK5,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN5=\"\", \"\", VLOOKUP(AN5,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR5=\"\", \"\", VLOOKUP(AR5,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV5=\"\", \"\", VLOOKUP(AV5,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ5=\"\", \"\", VLOOKUP(AZ5,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB5=\"\", \"\", VLOOKUP(BB5,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF5=\"\", \"\", VLOOKUP(BF5,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E6=\"\", \"\", VLOOKUP(E6,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H6=\"\", \"\", VLOOKUP(H6,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M6=\"\", \"\", VLOOKUP(M6,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O6=\"\", \"\", VLOOKUP(O6,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q6=\"\", \"\", VLOOKUP(Q6,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T6=\"\", \"\", VLOOKUP(T6,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W6=\"\", \"\", VLOOKUP(W6,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y6=\"\", \"\", VLOOKUP(Y6,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB6=\"\", \"\", VLOOKUP(AB6,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE6=\"\", \"\", VLOOKUP(AE6,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG6=\"\", \"\", VLOOKUP(AG6,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI6=\"\", \"\", VLOOKUP(AI6,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK6=\"\", \"\", VLOOKUP(AK6,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN6=\"\", \"\", VLOOKUP(AN6,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR6=\"\", \"\", VLOOKUP(AR6,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV6=\"\", \"\", VLOOKUP(AV6,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ6=\"\", \"\", VLOOKUP(AZ6,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB6=\"\", \"\", VLOOKUP(BB6,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF6=\"\", \"\", VLOOKUP(BF6,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E7=\"\", \"\", VLOOKUP(E7,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H7=\"\", \"\", VLOOKUP(H7,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M7=\"\", \"\", VLOOKUP(M7,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O7=\"\", \"\", VLOOKUP(O7,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q7=\"\", \"\", VLOOKUP(Q7,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T7=\"\", \"\", VLOOKUP(T7,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W7=\"\", \"\", VLOOKUP(W7,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y7=\"\", \"\", VLOOKUP(Y7,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB7=\"\", \"\", VLOOKUP(AB7,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE7=\"\", \"\", VLOOKUP(AE7,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG7=\"\", \"\", VLOOKUP(AG7,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI7=\"\", \"\", VLOOKUP(AI7,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK7=\"\", \"\", VLOOKUP(AK7,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN7=\"\", \"\", VLOOKUP(AN7,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR7=\"\", \"\", VLOOKUP(AR7,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV7=\"\", \"\", VLOOKUP(AV7,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ7=\"\", \"\", VLOOKUP(AZ7,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB7=\"\", \"\", VLOOKUP(BB7,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF7=\"\", \"\", VLOOKUP(BF7,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E8=\"\", \"\", VLOOKUP(E8,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H8=\"\", \"\", VLOOKUP(H8,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M8=\"\", \"\", VLOOKUP(M8,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O8=\"\", \"\", VLOOKUP(O8,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q8=\"\", \"\", VLOOKUP(Q8,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T8=\"\", \"\", VLOOKUP(T8,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W8=\"\", \"\", VLOOKUP(W8,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y8=\"\", \"\", VLOOKUP(Y8,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB8=\"\", \"\", VLOOKUP(AB8,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE8=\"\", \"\", VLOOKUP(AE8,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG8=\"\", \"\", VLOOKUP(AG8,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI8=\"\", \"\", VLOOKUP(AI8,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK8=\"\", \"\", VLOOKUP(AK8,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN8=\"\", \"\", VLOOKUP(AN8,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR8=\"\", \"\", VLOOKUP(AR8,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV8=\"\", \"\", VLOOKUP(AV8,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ8=\"\", \"\", VLOOKUP(AZ8,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB8=\"\", \"\", VLOOKUP(BB8,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF8=\"\", \"\", VLOOKUP(BF8,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E9=\"\", \"\", VLOOKUP(E9,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H9=\"\", \"\", VLOOKUP(H9,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M9=\"\", \"\", VLOOKUP(M9,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O9=\"\", \"\", VLOOKUP(O9,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q9=\"\", \"\", VLOOKUP(Q9,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T9=\"\", \"\", VLOOKUP(T9,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W9=\"\", \"\", VLOOKUP(W9,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y9=\"\", \"\", VLOOKUP(Y9,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB9=\"\", \"\", VLOOKUP(AB9,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE9=\"\", \"\", VLOOKUP(AE9,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG9=\"\", \"\", VLOOKUP(AG9,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI9=\"\", \"\", VLOOKUP(AI9,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK9=\"\", \"\", VLOOKUP(AK9,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN9=\"\", \"\", VLOOKUP(AN9,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR9=\"\", \"\", VLOOKUP(AR9,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV9=\"\", \"\", VLOOKUP(AV9,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ9=\"\", \"\", VLOOKUP(AZ9,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB9=\"\", \"\", VLOOKUP(BB9,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF9=\"\", \"\", VLOOKUP(BF9,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E10=\"\", \"\", VLOOKUP(E10,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H10=\"\", \"\", VLOOKUP(H10,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M10=\"\", \"\", VLOOKUP(M10,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O10=\"\", \"\", VLOOKUP(O10,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q10=\"\", \"\", VLOOKUP(Q10,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T10=\"\", \"\", VLOOKUP(T10,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W10=\"\", \"\", VLOOKUP(W10,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y10=\"\", \"\", VLOOKUP(Y10,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB10=\"\", \"\", VLOOKUP(AB10,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE10=\"\", \"\", VLOOKUP(AE10,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG10=\"\", \"\", VLOOKUP(AG10,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI10=\"\", \"\", VLOOKUP(AI10,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK10=\"\", \"\", VLOOKUP(AK10,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN10=\"\", \"\", VLOOKUP(AN10,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR10=\"\", \"\", VLOOKUP(AR10,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV10=\"\", \"\", VLOOKUP(AV10,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ10=\"\", \"\", VLOOKUP(AZ10,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB10=\"\", \"\", VLOOKUP(BB10,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF10=\"\", \"\", VLOOKUP(BF10,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E11=\"\", \"\", VLOOKUP(E11,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H11=\"\", \"\", VLOOKUP(H11,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M11=\"\", \"\", VLOOKUP(M11,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O11=\"\", \"\", VLOOKUP(O11,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q11=\"\", \"\", VLOOKUP(Q11,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T11=\"\", \"\", VLOOKUP(T11,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W11=\"\", \"\", VLOOKUP(W11,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y11=\"\", \"\", VLOOKUP(Y11,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB11=\"\", \"\", VLOOKUP(AB11,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE11=\"\", \"\", VLOOKUP(AE11,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG11=\"\", \"\", VLOOKUP(AG11,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI11=\"\", \"\", VLOOKUP(AI11,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK11=\"\", \"\", VLOOKUP(AK11,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN11=\"\", \"\", VLOOKUP(AN11,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR11=\"\", \"\", VLOOKUP(AR11,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV11=\"\", \"\", VLOOKUP(AV11,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ11=\"\", \"\", VLOOKUP(AZ11,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB11=\"\", \"\", VLOOKUP(BB11,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF11=\"\", \"\", VLOOKUP(BF11,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E12=\"\", \"\", VLOOKUP(E12,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H12=\"\", \"\", VLOOKUP(H12,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M12=\"\", \"\", VLOOKUP(M12,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O12=\"\", \"\", VLOOKUP(O12,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q12=\"\", \"\", VLOOKUP(Q12,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T12=\"\", \"\", VLOOKUP(T12,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W12=\"\", \"\", VLOOKUP(W12,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y12=\"\", \"\", VLOOKUP(Y12,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB12=\"\", \"\", VLOOKUP(AB12,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE12=\"\", \"\", VLOOKUP(AE12,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG12=\"\", \"\", VLOOKUP(AG12,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI12=\"\", \"\", VLOOKUP(AI12,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK12=\"\", \"\", VLOOKUP(AK12,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN12=\"\", \"\", VLOOKUP(AN12,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR12=\"\", \"\", VLOOKUP(AR12,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV12=\"\", \"\", VLOOKUP(AV12,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ12=\"\", \"\", VLOOKUP(AZ12,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB12=\"\", \"\", VLOOKUP(BB12,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF12=\"\", \"\", VLOOKUP(BF12,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E13=\"\", \"\", VLOOKUP(E13,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H13=\"\", \"\", VLOOKUP(H13,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M13=\"\", \"\", VLOOKUP(M13,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O13=\"\", \"\", VLOOKUP(O13,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q13=\"\", \"\", VLOOKUP(Q13,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T13=\"\", \"\", VLOOKUP(T13,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W13=\"\", \"\", VLOOKUP(W13,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y13=\"\", \"\", VLOOKUP(Y13,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB13=\"\", \"\", VLOOKUP(AB13,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE13=\"\", \"\", VLOOKUP(AE13,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG13=\"\", \"\", VLOOKUP(AG13,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI13=\"\", \"\", VLOOKUP(AI13,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK13=\"\", \"\", VLOOKUP(AK13,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN13=\"\", \"\", VLOOKUP(AN13,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR13=\"\", \"\", VLOOKUP(AR13,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV13=\"\", \"\", VLOOKUP(AV13,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ13=\"\", \"\", VLOOKUP(AZ13,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB13=\"\", \"\", VLOOKUP(BB13,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF13=\"\", \"\", VLOOKUP(BF13,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E14=\"\", \"\", VLOOKUP(E14,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H14=\"\", \"\", VLOOKUP(H14,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M14=\"\", \"\", VLOOKUP(M14,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O14=\"\", \"\", VLOOKUP(O14,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q14=\"\", \"\", VLOOKUP(Q14,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T14=\"\", \"\", VLOOKUP(T14,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W14=\"\", \"\", VLOOKUP(W14,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y14=\"\", \"\", VLOOKUP(Y14,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB14=\"\", \"\", VLOOKUP(AB14,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE14=\"\", \"\", VLOOKUP(AE14,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG14=\"\", \"\", VLOOKUP(AG14,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI14=\"\", \"\", VLOOKUP(AI14,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK14=\"\", \"\", VLOOKUP(AK14,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN14=\"\", \"\", VLOOKUP(AN14,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR14=\"\", \"\", VLOOKUP(AR14,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV14=\"\", \"\", VLOOKUP(AV14,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ14=\"\", \"\", VLOOKUP(AZ14,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB14=\"\", \"\", VLOOKUP(BB14,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF14=\"\", \"\", VLOOKUP(BF14,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E15=\"\", \"\", VLOOKUP(E15,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H15=\"\", \"\", VLOOKUP(H15,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M15=\"\", \"\", VLOOKUP(M15,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O15=\"\", \"\", VLOOKUP(O15,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q15=\"\", \"\", VLOOKUP(Q15,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T15=\"\", \"\", VLOOKUP(T15,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W15=\"\", \"\", VLOOKUP(W15,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y15=\"\", \"\", VLOOKUP(Y15,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB15=\"\", \"\", VLOOKUP(AB15,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE15=\"\", \"\", VLOOKUP(AE15,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG15=\"\", \"\", VLOOKUP(AG15,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI15=\"\", \"\", VLOOKUP(AI15,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK15=\"\", \"\", VLOOKUP(AK15,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN15=\"\", \"\", VLOOKUP(AN15,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR15=\"\", \"\", VLOOKUP(AR15,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV15=\"\", \"\", VLOOKUP(AV15,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ15=\"\", \"\", VLOOKUP(AZ15,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB15=\"\", \"\", VLOOKUP(BB15,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF15=\"\", \"\", VLOOKUP(BF15,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E16=\"\", \"\", VLOOKUP(E16,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H16=\"\", \"\", VLOOKUP(H16,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M16=\"\", \"\", VLOOKUP(M16,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O16=\"\", \"\", VLOOKUP(O16,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q16=\"\", \"\", VLOOKUP(Q16,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T16=\"\", \"\", VLOOKUP(T16,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W16=\"\", \"\", VLOOKUP(W16,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y16=\"\", \"\", VLOOKUP(Y16,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB16=\"\", \"\", VLOOKUP(AB16,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE16=\"\", \"\", VLOOKUP(AE16,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG16=\"\", \"\", VLOOKUP(AG16,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI16=\"\", \"\", VLOOKUP(AI16,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK16=\"\", \"\", VLOOKUP(AK16,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN16=\"\", \"\", VLOOKUP(AN16,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR16=\"\", \"\", VLOOKUP(AR16,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV16=\"\", \"\", VLOOKUP(AV16,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ16=\"\", \"\", VLOOKUP(AZ16,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB16=\"\", \"\", VLOOKUP(BB16,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF16=\"\", \"\", VLOOKUP(BF16,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E17=\"\", \"\", VLOOKUP(E17,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H17=\"\", \"\", VLOOKUP(H17,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M17=\"\", \"\", VLOOKUP(M17,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O17=\"\", \"\", VLOOKUP(O17,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q17=\"\", \"\", VLOOKUP(Q17,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T17=\"\", \"\", VLOOKUP(T17,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W17=\"\", \"\", VLOOKUP(W17,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y17=\"\", \"\", VLOOKUP(Y17,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB17=\"\", \"\", VLOOKUP(AB17,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE17=\"\", \"\", VLOOKUP(AE17,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG17=\"\", \"\", VLOOKUP(AG17,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI17=\"\", \"\", VLOOKUP(AI17,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK17=\"\", \"\", VLOOKUP(AK17,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN17=\"\", \"\", VLOOKUP(AN17,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR17=\"\", \"\", VLOOKUP(AR17,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV17=\"\", \"\", VLOOKUP(AV17,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ17=\"\", \"\", VLOOKUP(AZ17,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB17=\"\", \"\", VLOOKUP(BB17,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF17=\"\", \"\", VLOOKUP(BF17,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E18=\"\", \"\", VLOOKUP(E18,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H18=\"\", \"\", VLOOKUP(H18,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M18=\"\", \"\", VLOOKUP(M18,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O18=\"\", \"\", VLOOKUP(O18,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q18=\"\", \"\", VLOOKUP(Q18,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T18=\"\", \"\", VLOOKUP(T18,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W18=\"\", \"\", VLOOKUP(W18,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y18=\"\", \"\", VLOOKUP(Y18,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB18=\"\", \"\", VLOOKUP(AB18,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE18=\"\", \"\", VLOOKUP(AE18,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG18=\"\", \"\", VLOOKUP(AG18,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI18=\"\", \"\", VLOOKUP(AI18,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK18=\"\", \"\", VLOOKUP(AK18,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN18=\"\", \"\", VLOOKUP(AN18,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR18=\"\", \"\", VLOOKUP(AR18,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV18=\"\", \"\", VLOOKUP(AV18,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ18=\"\", \"\", VLOOKUP(AZ18,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB18=\"\", \"\", VLOOKUP(BB18,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF18=\"\", \"\", VLOOKUP(BF18,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E19=\"\", \"\", VLOOKUP(E19,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H19=\"\", \"\", VLOOKUP(H19,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M19=\"\", \"\", VLOOKUP(M19,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O19=\"\", \"\", VLOOKUP(O19,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q19=\"\", \"\", VLOOKUP(Q19,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T19=\"\", \"\", VLOOKUP(T19,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W19=\"\", \"\", VLOOKUP(W19,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y19=\"\", \"\", VLOOKUP(Y19,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB19=\"\", \"\", VLOOKUP(AB19,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE19=\"\", \"\", VLOOKUP(AE19,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG19=\"\", \"\", VLOOKUP(AG19,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI19=\"\", \"\", VLOOKUP(AI19,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK19=\"\", \"\", VLOOKUP(AK19,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN19=\"\", \"\", VLOOKUP(AN19,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR19=\"\", \"\", VLOOKUP(AR19,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV19=\"\", \"\", VLOOKUP(AV19,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ19=\"\", \"\", VLOOKUP(AZ19,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB19=\"\", \"\", VLOOKUP(BB19,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF19=\"\", \"\", VLOOKUP(BF19,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E20=\"\", \"\", VLOOKUP(E20,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H20=\"\", \"\", VLOOKUP(H20,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M20=\"\", \"\", VLOOKUP(M20,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O20=\"\", \"\", VLOOKUP(O20,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q20=\"\", \"\", VLOOKUP(Q20,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T20=\"\", \"\", VLOOKUP(T20,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W20=\"\", \"\", VLOOKUP(W20,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y20=\"\", \"\", VLOOKUP(Y20,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB20=\"\", \"\", VLOOKUP(AB20,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE20=\"\", \"\", VLOOKUP(AE20,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG20=\"\", \"\", VLOOKUP(AG20,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI20=\"\", \"\", VLOOKUP(AI20,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK20=\"\", \"\", VLOOKUP(AK20,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN20=\"\", \"\", VLOOKUP(AN20,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR20=\"\", \"\", VLOOKUP(AR20,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV20=\"\", \"\", VLOOKUP(AV20,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ20=\"\", \"\", VLOOKUP(AZ20,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB20=\"\", \"\", VLOOKUP(BB20,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF20=\"\", \"\", VLOOKUP(BF20,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E21=\"\", \"\", VLOOKUP(E21,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H21=\"\", \"\", VLOOKUP(H21,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M21=\"\", \"\", VLOOKUP(M21,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O21=\"\", \"\", VLOOKUP(O21,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q21=\"\", \"\", VLOOKUP(Q21,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T21=\"\", \"\", VLOOKUP(T21,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W21=\"\", \"\", VLOOKUP(W21,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y21=\"\", \"\", VLOOKUP(Y21,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB21=\"\", \"\", VLOOKUP(AB21,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE21=\"\", \"\", VLOOKUP(AE21,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG21=\"\", \"\", VLOOKUP(AG21,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI21=\"\", \"\", VLOOKUP(AI21,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK21=\"\", \"\", VLOOKUP(AK21,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN21=\"\", \"\", VLOOKUP(AN21,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR21=\"\", \"\", VLOOKUP(AR21,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV21=\"\", \"\", VLOOKUP(AV21,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ21=\"\", \"\", VLOOKUP(AZ21,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB21=\"\", \"\", VLOOKUP(BB21,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF21=\"\", \"\", VLOOKUP(BF21,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E22=\"\", \"\", VLOOKUP(E22,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H22=\"\", \"\", VLOOKUP(H22,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M22=\"\", \"\", VLOOKUP(M22,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O22=\"\", \"\", VLOOKUP(O22,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q22=\"\", \"\", VLOOKUP(Q22,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T22=\"\", \"\", VLOOKUP(T22,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W22=\"\", \"\", VLOOKUP(W22,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y22=\"\", \"\", VLOOKUP(Y22,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB22=\"\", \"\", VLOOKUP(AB22,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE22=\"\", \"\", VLOOKUP(AE22,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG22=\"\", \"\", VLOOKUP(AG22,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI22=\"\", \"\", VLOOKUP(AI22,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK22=\"\", \"\", VLOOKUP(AK22,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN22=\"\", \"\", VLOOKUP(AN22,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR22=\"\", \"\", VLOOKUP(AR22,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV22=\"\", \"\", VLOOKUP(AV22,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ22=\"\", \"\", VLOOKUP(AZ22,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB22=\"\", \"\", VLOOKUP(BB22,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF22=\"\", \"\", VLOOKUP(BF22,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E23=\"\", \"\", VLOOKUP(E23,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H23=\"\", \"\", VLOOKUP(H23,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M23=\"\", \"\", VLOOKUP(M23,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O23=\"\", \"\", VLOOKUP(O23,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q23=\"\", \"\", VLOOKUP(Q23,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T23=\"\", \"\", VLOOKUP(T23,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W23=\"\", \"\", VLOOKUP(W23,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y23=\"\", \"\", VLOOKUP(Y23,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB23=\"\", \"\", VLOOKUP(AB23,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE23=\"\", \"\", VLOOKUP(AE23,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG23=\"\", \"\", VLOOKUP(AG23,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI23=\"\", \"\", VLOOKUP(AI23,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK23=\"\", \"\", VLOOKUP(AK23,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN23=\"\", \"\", VLOOKUP(AN23,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR23=\"\", \"\", VLOOKUP(AR23,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV23=\"\", \"\", VLOOKUP(AV23,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ23=\"\", \"\", VLOOKUP(AZ23,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB23=\"\", \"\", VLOOKUP(BB23,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF23=\"\", \"\", VLOOKUP(BF23,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E24=\"\", \"\", VLOOKUP(E24,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H24=\"\", \"\", VLOOKUP(H24,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M24=\"\", \"\", VLOOKUP(M24,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O24=\"\", \"\", VLOOKUP(O24,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q24=\"\", \"\", VLOOKUP(Q24,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T24=\"\", \"\", VLOOKUP(T24,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W24=\"\", \"\", VLOOKUP(W24,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y24=\"\", \"\", VLOOKUP(Y24,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB24=\"\", \"\", VLOOKUP(AB24,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE24=\"\", \"\", VLOOKUP(AE24,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG24=\"\", \"\", VLOOKUP(AG24,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI24=\"\", \"\", VLOOKUP(AI24,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK24=\"\", \"\", VLOOKUP(AK24,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN24=\"\", \"\", VLOOKUP(AN24,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR24=\"\", \"\", VLOOKUP(AR24,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV24=\"\", \"\", VLOOKUP(AV24,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ24=\"\", \"\", VLOOKUP(AZ24,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB24=\"\", \"\", VLOOKUP(BB24,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF24=\"\", \"\", VLOOKUP(BF24,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E25=\"\", \"\", VLOOKUP(E25,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H25=\"\", \"\", VLOOKUP(H25,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M25=\"\", \"\", VLOOKUP(M25,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O25=\"\", \"\", VLOOKUP(O25,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q25=\"\", \"\", VLOOKUP(Q25,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T25=\"\", \"\", VLOOKUP(T25,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W25=\"\", \"\", VLOOKUP(W25,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y25=\"\", \"\", VLOOKUP(Y25,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB25=\"\", \"\", VLOOKUP(AB25,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE25=\"\", \"\", VLOOKUP(AE25,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG25=\"\", \"\", VLOOKUP(AG25,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI25=\"\", \"\", VLOOKUP(AI25,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK25=\"\", \"\", VLOOKUP(AK25,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN25=\"\", \"\", VLOOKUP(AN25,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR25=\"\", \"\", VLOOKUP(AR25,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV25=\"\", \"\", VLOOKUP(AV25,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ25=\"\", \"\", VLOOKUP(AZ25,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB25=\"\", \"\", VLOOKUP(BB25,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF25=\"\", \"\", VLOOKUP(BF25,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E26=\"\", \"\", VLOOKUP(E26,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H26=\"\", \"\", VLOOKUP(H26,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M26=\"\", \"\", VLOOKUP(M26,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O26=\"\", \"\", VLOOKUP(O26,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q26=\"\", \"\", VLOOKUP(Q26,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T26=\"\", \"\", VLOOKUP(T26,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W26=\"\", \"\", VLOOKUP(W26,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y26=\"\", \"\", VLOOKUP(Y26,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB26=\"\", \"\", VLOOKUP(AB26,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE26=\"\", \"\", VLOOKUP(AE26,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG26=\"\", \"\", VLOOKUP(AG26,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI26=\"\", \"\", VLOOKUP(AI26,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK26=\"\", \"\", VLOOKUP(AK26,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN26=\"\", \"\", VLOOKUP(AN26,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR26=\"\", \"\", VLOOKUP(AR26,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV26=\"\", \"\", VLOOKUP(AV26,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ26=\"\", \"\", VLOOKUP(AZ26,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB26=\"\", \"\", VLOOKUP(BB26,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF26=\"\", \"\", VLOOKUP(BF26,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E27=\"\", \"\", VLOOKUP(E27,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H27=\"\", \"\", VLOOKUP(H27,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M27=\"\", \"\", VLOOKUP(M27,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O27=\"\", \"\", VLOOKUP(O27,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q27=\"\", \"\", VLOOKUP(Q27,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T27=\"\", \"\", VLOOKUP(T27,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W27=\"\", \"\", VLOOKUP(W27,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y27=\"\", \"\", VLOOKUP(Y27,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB27=\"\", \"\", VLOOKUP(AB27,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE27=\"\", \"\", VLOOKUP(AE27,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG27=\"\", \"\", VLOOKUP(AG27,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI27=\"\", \"\", VLOOKUP(AI27,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK27=\"\", \"\", VLOOKUP(AK27,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN27=\"\", \"\", VLOOKUP(AN27,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR27=\"\", \"\", VLOOKUP(AR27,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV27=\"\", \"\", VLOOKUP(AV27,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ27=\"\", \"\", VLOOKUP(AZ27,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB27=\"\", \"\", VLOOKUP(BB27,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF27=\"\", \"\", VLOOKUP(BF27,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E28=\"\", \"\", VLOOKUP(E28,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H28=\"\", \"\", VLOOKUP(H28,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M28=\"\", \"\", VLOOKUP(M28,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O28=\"\", \"\", VLOOKUP(O28,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q28=\"\", \"\", VLOOKUP(Q28,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T28=\"\", \"\", VLOOKUP(T28,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W28=\"\", \"\", VLOOKUP(W28,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y28=\"\", \"\", VLOOKUP(Y28,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB28=\"\", \"\", VLOOKUP(AB28,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE28=\"\", \"\", VLOOKUP(AE28,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG28=\"\", \"\", VLOOKUP(AG28,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI28=\"\", \"\", VLOOKUP(AI28,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK28=\"\", \"\", VLOOKUP(AK28,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN28=\"\", \"\", VLOOKUP(AN28,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR28=\"\", \"\", VLOOKUP(AR28,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV28=\"\", \"\", VLOOKUP(AV28,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ28=\"\", \"\", VLOOKUP(AZ28,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB28=\"\", \"\", VLOOKUP(BB28,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF28=\"\", \"\", VLOOKUP(BF28,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E29=\"\", \"\", VLOOKUP(E29,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H29=\"\", \"\", VLOOKUP(H29,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M29=\"\", \"\", VLOOKUP(M29,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O29=\"\", \"\", VLOOKUP(O29,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q29=\"\", \"\", VLOOKUP(Q29,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T29=\"\", \"\", VLOOKUP(T29,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W29=\"\", \"\", VLOOKUP(W29,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y29=\"\", \"\", VLOOKUP(Y29,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB29=\"\", \"\", VLOOKUP(AB29,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE29=\"\", \"\", VLOOKUP(AE29,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG29=\"\", \"\", VLOOKUP(AG29,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI29=\"\", \"\", VLOOKUP(AI29,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK29=\"\", \"\", VLOOKUP(AK29,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN29=\"\", \"\", VLOOKUP(AN29,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR29=\"\", \"\", VLOOKUP(AR29,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV29=\"\", \"\", VLOOKUP(AV29,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ29=\"\", \"\", VLOOKUP(AZ29,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB29=\"\", \"\", VLOOKUP(BB29,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF29=\"\", \"\", VLOOKUP(BF29,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E30=\"\", \"\", VLOOKUP(E30,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H30=\"\", \"\", VLOOKUP(H30,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M30=\"\", \"\", VLOOKUP(M30,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O30=\"\", \"\", VLOOKUP(O30,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q30=\"\", \"\", VLOOKUP(Q30,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T30=\"\", \"\", VLOOKUP(T30,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W30=\"\", \"\", VLOOKUP(W30,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y30=\"\", \"\", VLOOKUP(Y30,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB30=\"\", \"\", VLOOKUP(AB30,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE30=\"\", \"\", VLOOKUP(AE30,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG30=\"\", \"\", VLOOKUP(AG30,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI30=\"\", \"\", VLOOKUP(AI30,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK30=\"\", \"\", VLOOKUP(AK30,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN30=\"\", \"\", VLOOKUP(AN30,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR30=\"\", \"\", VLOOKUP(AR30,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV30=\"\", \"\", VLOOKUP(AV30,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ30=\"\", \"\", VLOOKUP(AZ30,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB30=\"\", \"\", VLOOKUP(BB30,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF30=\"\", \"\", VLOOKUP(BF30,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E31=\"\", \"\", VLOOKUP(E31,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H31=\"\", \"\", VLOOKUP(H31,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M31=\"\", \"\", VLOOKUP(M31,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O31=\"\", \"\", VLOOKUP(O31,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q31=\"\", \"\", VLOOKUP(Q31,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T31=\"\", \"\", VLOOKUP(T31,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W31=\"\", \"\", VLOOKUP(W31,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y31=\"\", \"\", VLOOKUP(Y31,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB31=\"\", \"\", VLOOKUP(AB31,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE31=\"\", \"\", VLOOKUP(AE31,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG31=\"\", \"\", VLOOKUP(AG31,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI31=\"\", \"\", VLOOKUP(AI31,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK31=\"\", \"\", VLOOKUP(AK31,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN31=\"\", \"\", VLOOKUP(AN31,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR31=\"\", \"\", VLOOKUP(AR31,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV31=\"\", \"\", VLOOKUP(AV31,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ31=\"\", \"\", VLOOKUP(AZ31,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB31=\"\", \"\", VLOOKUP(BB31,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF31=\"\", \"\", VLOOKUP(BF31,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E32=\"\", \"\", VLOOKUP(E32,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H32=\"\", \"\", VLOOKUP(H32,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M32=\"\", \"\", VLOOKUP(M32,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O32=\"\", \"\", VLOOKUP(O32,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q32=\"\", \"\", VLOOKUP(Q32,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T32=\"\", \"\", VLOOKUP(T32,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W32=\"\", \"\", VLOOKUP(W32,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y32=\"\", \"\", VLOOKUP(Y32,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB32=\"\", \"\", VLOOKUP(AB32,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE32=\"\", \"\", VLOOKUP(AE32,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG32=\"\", \"\", VLOOKUP(AG32,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI32=\"\", \"\", VLOOKUP(AI32,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK32=\"\", \"\", VLOOKUP(AK32,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN32=\"\", \"\", VLOOKUP(AN32,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR32=\"\", \"\", VLOOKUP(AR32,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV32=\"\", \"\", VLOOKUP(AV32,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ32=\"\", \"\", VLOOKUP(AZ32,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB32=\"\", \"\", VLOOKUP(BB32,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF32=\"\", \"\", VLOOKUP(BF32,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E33=\"\", \"\", VLOOKUP(E33,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H33=\"\", \"\", VLOOKUP(H33,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M33=\"\", \"\", VLOOKUP(M33,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O33=\"\", \"\", VLOOKUP(O33,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q33=\"\", \"\", VLOOKUP(Q33,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T33=\"\", \"\", VLOOKUP(T33,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W33=\"\", \"\", VLOOKUP(W33,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y33=\"\", \"\", VLOOKUP(Y33,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB33=\"\", \"\", VLOOKUP(AB33,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE33=\"\", \"\", VLOOKUP(AE33,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG33=\"\", \"\", VLOOKUP(AG33,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI33=\"\", \"\", VLOOKUP(AI33,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK33=\"\", \"\", VLOOKUP(AK33,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN33=\"\", \"\", VLOOKUP(AN33,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR33=\"\", \"\", VLOOKUP(AR33,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV33=\"\", \"\", VLOOKUP(AV33,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ33=\"\", \"\", VLOOKUP(AZ33,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB33=\"\", \"\", VLOOKUP(BB33,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF33=\"\", \"\", VLOOKUP(BF33,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E34=\"\", \"\", VLOOKUP(E34,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H34=\"\", \"\", VLOOKUP(H34,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M34=\"\", \"\", VLOOKUP(M34,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O34=\"\", \"\", VLOOKUP(O34,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q34=\"\", \"\", VLOOKUP(Q34,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T34=\"\", \"\", VLOOKUP(T34,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W34=\"\", \"\", VLOOKUP(W34,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y34=\"\", \"\", VLOOKUP(Y34,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB34=\"\", \"\", VLOOKUP(AB34,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE34=\"\", \"\", VLOOKUP(AE34,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG34=\"\", \"\", VLOOKUP(AG34,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI34=\"\", \"\", VLOOKUP(AI34,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK34=\"\", \"\", VLOOKUP(AK34,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN34=\"\", \"\", VLOOKUP(AN34,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR34=\"\", \"\", VLOOKUP(AR34,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV34=\"\", \"\", VLOOKUP(AV34,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ34=\"\", \"\", VLOOKUP(AZ34,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB34=\"\", \"\", VLOOKUP(BB34,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF34=\"\", \"\", VLOOKUP(BF34,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E35=\"\", \"\", VLOOKUP(E35,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H35=\"\", \"\", VLOOKUP(H35,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M35=\"\", \"\", VLOOKUP(M35,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O35=\"\", \"\", VLOOKUP(O35,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q35=\"\", \"\", VLOOKUP(Q35,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T35=\"\", \"\", VLOOKUP(T35,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W35=\"\", \"\", VLOOKUP(W35,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y35=\"\", \"\", VLOOKUP(Y35,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB35=\"\", \"\", VLOOKUP(AB35,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE35=\"\", \"\", VLOOKUP(AE35,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG35=\"\", \"\", VLOOKUP(AG35,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI35=\"\", \"\", VLOOKUP(AI35,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK35=\"\", \"\", VLOOKUP(AK35,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN35=\"\", \"\", VLOOKUP(AN35,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR35=\"\", \"\", VLOOKUP(AR35,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV35=\"\", \"\", VLOOKUP(AV35,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ35=\"\", \"\", VLOOKUP(AZ35,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB35=\"\", \"\", VLOOKUP(BB35,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF35=\"\", \"\", VLOOKUP(BF35,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E36=\"\", \"\", VLOOKUP(E36,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H36=\"\", \"\", VLOOKUP(H36,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M36=\"\", \"\", VLOOKUP(M36,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O36=\"\", \"\", VLOOKUP(O36,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q36=\"\", \"\", VLOOKUP(Q36,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T36=\"\", \"\", VLOOKUP(T36,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W36=\"\", \"\", VLOOKUP(W36,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y36=\"\", \"\", VLOOKUP(Y36,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB36=\"\", \"\", VLOOKUP(AB36,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE36=\"\", \"\", VLOOKUP(AE36,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG36=\"\", \"\", VLOOKUP(AG36,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI36=\"\", \"\", VLOOKUP(AI36,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK36=\"\", \"\", VLOOKUP(AK36,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN36=\"\", \"\", VLOOKUP(AN36,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR36=\"\", \"\", VLOOKUP(AR36,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV36=\"\", \"\", VLOOKUP(AV36,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ36=\"\", \"\", VLOOKUP(AZ36,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB36=\"\", \"\", VLOOKUP(BB36,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF36=\"\", \"\", VLOOKUP(BF36,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E37=\"\", \"\", VLOOKUP(E37,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H37=\"\", \"\", VLOOKUP(H37,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M37=\"\", \"\", VLOOKUP(M37,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O37=\"\", \"\", VLOOKUP(O37,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q37=\"\", \"\", VLOOKUP(Q37,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T37=\"\", \"\", VLOOKUP(T37,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W37=\"\", \"\", VLOOKUP(W37,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y37=\"\", \"\", VLOOKUP(Y37,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB37=\"\", \"\", VLOOKUP(AB37,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE37=\"\", \"\", VLOOKUP(AE37,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG37=\"\", \"\", VLOOKUP(AG37,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI37=\"\", \"\", VLOOKUP(AI37,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK37=\"\", \"\", VLOOKUP(AK37,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN37=\"\", \"\", VLOOKUP(AN37,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR37=\"\", \"\", VLOOKUP(AR37,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV37=\"\", \"\", VLOOKUP(AV37,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ37=\"\", \"\", VLOOKUP(AZ37,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB37=\"\", \"\", VLOOKUP(BB37,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF37=\"\", \"\", VLOOKUP(BF37,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E38=\"\", \"\", VLOOKUP(E38,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H38=\"\", \"\", VLOOKUP(H38,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M38=\"\", \"\", VLOOKUP(M38,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O38=\"\", \"\", VLOOKUP(O38,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q38=\"\", \"\", VLOOKUP(Q38,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T38=\"\", \"\", VLOOKUP(T38,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W38=\"\", \"\", VLOOKUP(W38,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y38=\"\", \"\", VLOOKUP(Y38,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB38=\"\", \"\", VLOOKUP(AB38,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE38=\"\", \"\", VLOOKUP(AE38,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG38=\"\", \"\", VLOOKUP(AG38,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI38=\"\", \"\", VLOOKUP(AI38,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK38=\"\", \"\", VLOOKUP(AK38,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN38=\"\", \"\", VLOOKUP(AN38,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR38=\"\", \"\", VLOOKUP(AR38,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV38=\"\", \"\", VLOOKUP(AV38,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ38=\"\", \"\", VLOOKUP(AZ38,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB38=\"\", \"\", VLOOKUP(BB38,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF38=\"\", \"\", VLOOKUP(BF38,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E39=\"\", \"\", VLOOKUP(E39,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H39=\"\", \"\", VLOOKUP(H39,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M39=\"\", \"\", VLOOKUP(M39,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O39=\"\", \"\", VLOOKUP(O39,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q39=\"\", \"\", VLOOKUP(Q39,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T39=\"\", \"\", VLOOKUP(T39,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W39=\"\", \"\", VLOOKUP(W39,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y39=\"\", \"\", VLOOKUP(Y39,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB39=\"\", \"\", VLOOKUP(AB39,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE39=\"\", \"\", VLOOKUP(AE39,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG39=\"\", \"\", VLOOKUP(AG39,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI39=\"\", \"\", VLOOKUP(AI39,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK39=\"\", \"\", VLOOKUP(AK39,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN39=\"\", \"\", VLOOKUP(AN39,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR39=\"\", \"\", VLOOKUP(AR39,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV39=\"\", \"\", VLOOKUP(AV39,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ39=\"\", \"\", VLOOKUP(AZ39,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB39=\"\", \"\", VLOOKUP(BB39,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF39=\"\", \"\", VLOOKUP(BF39,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E40=\"\", \"\", VLOOKUP(E40,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H40=\"\", \"\", VLOOKUP(H40,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M40=\"\", \"\", VLOOKUP(M40,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O40=\"\", \"\", VLOOKUP(O40,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q40=\"\", \"\", VLOOKUP(Q40,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T40=\"\", \"\", VLOOKUP(T40,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W40=\"\", \"\", VLOOKUP(W40,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y40=\"\", \"\", VLOOKUP(Y40,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB40=\"\", \"\", VLOOKUP(AB40,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE40=\"\", \"\", VLOOKUP(AE40,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG40=\"\", \"\", VLOOKUP(AG40,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI40=\"\", \"\", VLOOKUP(AI40,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK40=\"\", \"\", VLOOKUP(AK40,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN40=\"\", \"\", VLOOKUP(AN40,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR40=\"\", \"\", VLOOKUP(AR40,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV40=\"\", \"\", VLOOKUP(AV40,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ40=\"\", \"\", VLOOKUP(AZ40,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB40=\"\", \"\", VLOOKUP(BB40,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF40=\"\", \"\", VLOOKUP(BF40,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E41=\"\", \"\", VLOOKUP(E41,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H41=\"\", \"\", VLOOKUP(H41,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M41=\"\", \"\", VLOOKUP(M41,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O41=\"\", \"\", VLOOKUP(O41,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q41=\"\", \"\", VLOOKUP(Q41,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T41=\"\", \"\", VLOOKUP(T41,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W41=\"\", \"\", VLOOKUP(W41,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y41=\"\", \"\", VLOOKUP(Y41,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB41=\"\", \"\", VLOOKUP(AB41,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE41=\"\", \"\", VLOOKUP(AE41,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG41=\"\", \"\", VLOOKUP(AG41,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI41=\"\", \"\", VLOOKUP(AI41,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK41=\"\", \"\", VLOOKUP(AK41,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN41=\"\", \"\", VLOOKUP(AN41,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR41=\"\", \"\", VLOOKUP(AR41,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV41=\"\", \"\", VLOOKUP(AV41,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ41=\"\", \"\", VLOOKUP(AZ41,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB41=\"\", \"\", VLOOKUP(BB41,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF41=\"\", \"\", VLOOKUP(BF41,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E42=\"\", \"\", VLOOKUP(E42,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H42=\"\", \"\", VLOOKUP(H42,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M42=\"\", \"\", VLOOKUP(M42,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O42=\"\", \"\", VLOOKUP(O42,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q42=\"\", \"\", VLOOKUP(Q42,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T42=\"\", \"\", VLOOKUP(T42,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W42=\"\", \"\", VLOOKUP(W42,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y42=\"\", \"\", VLOOKUP(Y42,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB42=\"\", \"\", VLOOKUP(AB42,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE42=\"\", \"\", VLOOKUP(AE42,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG42=\"\", \"\", VLOOKUP(AG42,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI42=\"\", \"\", VLOOKUP(AI42,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK42=\"\", \"\", VLOOKUP(AK42,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN42=\"\", \"\", VLOOKUP(AN42,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR42=\"\", \"\", VLOOKUP(AR42,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV42=\"\", \"\", VLOOKUP(AV42,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ42=\"\", \"\", VLOOKUP(AZ42,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB42=\"\", \"\", VLOOKUP(BB42,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF42=\"\", \"\", VLOOKUP(BF42,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E43=\"\", \"\", VLOOKUP(E43,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H43=\"\", \"\", VLOOKUP(H43,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M43=\"\", \"\", VLOOKUP(M43,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O43=\"\", \"\", VLOOKUP(O43,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q43=\"\", \"\", VLOOKUP(Q43,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T43=\"\", \"\", VLOOKUP(T43,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W43=\"\", \"\", VLOOKUP(W43,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y43=\"\", \"\", VLOOKUP(Y43,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB43=\"\", \"\", VLOOKUP(AB43,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE43=\"\", \"\", VLOOKUP(AE43,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG43=\"\", \"\", VLOOKUP(AG43,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI43=\"\", \"\", VLOOKUP(AI43,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK43=\"\", \"\", VLOOKUP(AK43,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN43=\"\", \"\", VLOOKUP(AN43,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR43=\"\", \"\", VLOOKUP(AR43,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV43=\"\", \"\", VLOOKUP(AV43,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ43=\"\", \"\", VLOOKUP(AZ43,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB43=\"\", \"\", VLOOKUP(BB43,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF43=\"\", \"\", VLOOKUP(BF43,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E44=\"\", \"\", VLOOKUP(E44,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H44=\"\", \"\", VLOOKUP(H44,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M44=\"\", \"\", VLOOKUP(M44,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O44=\"\", \"\", VLOOKUP(O44,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q44=\"\", \"\", VLOOKUP(Q44,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T44=\"\", \"\", VLOOKUP(T44,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W44=\"\", \"\", VLOOKUP(W44,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y44=\"\", \"\", VLOOKUP(Y44,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB44=\"\", \"\", VLOOKUP(AB44,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE44=\"\", \"\", VLOOKUP(AE44,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG44=\"\", \"\", VLOOKUP(AG44,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI44=\"\", \"\", VLOOKUP(AI44,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK44=\"\", \"\", VLOOKUP(AK44,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN44=\"\", \"\", VLOOKUP(AN44,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR44=\"\", \"\", VLOOKUP(AR44,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV44=\"\", \"\", VLOOKUP(AV44,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ44=\"\", \"\", VLOOKUP(AZ44,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB44=\"\", \"\", VLOOKUP(BB44,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF44=\"\", \"\", VLOOKUP(BF44,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E45=\"\", \"\", VLOOKUP(E45,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H45=\"\", \"\", VLOOKUP(H45,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M45=\"\", \"\", VLOOKUP(M45,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O45=\"\", \"\", VLOOKUP(O45,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q45=\"\", \"\", VLOOKUP(Q45,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T45=\"\", \"\", VLOOKUP(T45,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W45=\"\", \"\", VLOOKUP(W45,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y45=\"\", \"\", VLOOKUP(Y45,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB45=\"\", \"\", VLOOKUP(AB45,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE45=\"\", \"\", VLOOKUP(AE45,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG45=\"\", \"\", VLOOKUP(AG45,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI45=\"\", \"\", VLOOKUP(AI45,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK45=\"\", \"\", VLOOKUP(AK45,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN45=\"\", \"\", VLOOKUP(AN45,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR45=\"\", \"\", VLOOKUP(AR45,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV45=\"\", \"\", VLOOKUP(AV45,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ45=\"\", \"\", VLOOKUP(AZ45,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB45=\"\", \"\", VLOOKUP(BB45,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF45=\"\", \"\", VLOOKUP(BF45,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E46=\"\", \"\", VLOOKUP(E46,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H46=\"\", \"\", VLOOKUP(H46,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M46=\"\", \"\", VLOOKUP(M46,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O46=\"\", \"\", VLOOKUP(O46,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q46=\"\", \"\", VLOOKUP(Q46,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T46=\"\", \"\", VLOOKUP(T46,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W46=\"\", \"\", VLOOKUP(W46,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y46=\"\", \"\", VLOOKUP(Y46,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB46=\"\", \"\", VLOOKUP(AB46,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE46=\"\", \"\", VLOOKUP(AE46,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG46=\"\", \"\", VLOOKUP(AG46,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI46=\"\", \"\", VLOOKUP(AI46,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK46=\"\", \"\", VLOOKUP(AK46,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN46=\"\", \"\", VLOOKUP(AN46,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR46=\"\", \"\", VLOOKUP(AR46,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV46=\"\", \"\", VLOOKUP(AV46,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ46=\"\", \"\", VLOOKUP(AZ46,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB46=\"\", \"\", VLOOKUP(BB46,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF46=\"\", \"\", VLOOKUP(BF46,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E47=\"\", \"\", VLOOKUP(E47,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H47=\"\", \"\", VLOOKUP(H47,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M47=\"\", \"\", VLOOKUP(M47,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O47=\"\", \"\", VLOOKUP(O47,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q47=\"\", \"\", VLOOKUP(Q47,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T47=\"\", \"\", VLOOKUP(T47,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W47=\"\", \"\", VLOOKUP(W47,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y47=\"\", \"\", VLOOKUP(Y47,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB47=\"\", \"\", VLOOKUP(AB47,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE47=\"\", \"\", VLOOKUP(AE47,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG47=\"\", \"\", VLOOKUP(AG47,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI47=\"\", \"\", VLOOKUP(AI47,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK47=\"\", \"\", VLOOKUP(AK47,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN47=\"\", \"\", VLOOKUP(AN47,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR47=\"\", \"\", VLOOKUP(AR47,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV47=\"\", \"\", VLOOKUP(AV47,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ47=\"\", \"\", VLOOKUP(AZ47,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB47=\"\", \"\", VLOOKUP(BB47,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF47=\"\", \"\", VLOOKUP(BF47,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E48=\"\", \"\", VLOOKUP(E48,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H48=\"\", \"\", VLOOKUP(H48,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M48=\"\", \"\", VLOOKUP(M48,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O48=\"\", \"\", VLOOKUP(O48,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q48=\"\", \"\", VLOOKUP(Q48,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T48=\"\", \"\", VLOOKUP(T48,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W48=\"\", \"\", VLOOKUP(W48,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y48=\"\", \"\", VLOOKUP(Y48,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB48=\"\", \"\", VLOOKUP(AB48,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE48=\"\", \"\", VLOOKUP(AE48,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG48=\"\", \"\", VLOOKUP(AG48,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI48=\"\", \"\", VLOOKUP(AI48,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK48=\"\", \"\", VLOOKUP(AK48,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN48=\"\", \"\", VLOOKUP(AN48,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR48=\"\", \"\", VLOOKUP(AR48,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV48=\"\", \"\", VLOOKUP(AV48,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ48=\"\", \"\", VLOOKUP(AZ48,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB48=\"\", \"\", VLOOKUP(BB48,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF48=\"\", \"\", VLOOKUP(BF48,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E49=\"\", \"\", VLOOKUP(E49,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H49=\"\", \"\", VLOOKUP(H49,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M49=\"\", \"\", VLOOKUP(M49,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O49=\"\", \"\", VLOOKUP(O49,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q49=\"\", \"\", VLOOKUP(Q49,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T49=\"\", \"\", VLOOKUP(T49,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W49=\"\", \"\", VLOOKUP(W49,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y49=\"\", \"\", VLOOKUP(Y49,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB49=\"\", \"\", VLOOKUP(AB49,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE49=\"\", \"\", VLOOKUP(AE49,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG49=\"\", \"\", VLOOKUP(AG49,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI49=\"\", \"\", VLOOKUP(AI49,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK49=\"\", \"\", VLOOKUP(AK49,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN49=\"\", \"\", VLOOKUP(AN49,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR49=\"\", \"\", VLOOKUP(AR49,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV49=\"\", \"\", VLOOKUP(AV49,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ49=\"\", \"\", VLOOKUP(AZ49,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB49=\"\", \"\", VLOOKUP(BB49,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF49=\"\", \"\", VLOOKUP(BF49,criticality[],2,FALSE))","v":""}]
["null",null,null,null,null,{"$f":"IF(E50=\"\", \"\", VLOOKUP(E50,site[],2,FALSE))","v":""},null,null,{"$f":"IF(H50=\"\", \"\", VLOOKUP(H50,gps_by[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(M50=\"\", \"\", VLOOKUP(M50,gps_method_id[],2,FALSE))","v":""},null,{"$f":"IF(O50=\"\", \"\", VLOOKUP(O50,nma[],2,FALSE))","v":""},null,{"$f":"IF(Q50=\"\", \"\", VLOOKUP(Q50,transit_region[],2,FALSE))","v":""},null,null,{"$f":"IF(T50=\"\", \"\", VLOOKUP(T50,state[],2,FALSE))","v":""},null,null,{"$f":"IF(W50=\"\", \"\", VLOOKUP(W50,asset_type[],2,FALSE))","v":""},null,{"$f":"IF(Y50=\"\", \"\", VLOOKUP(Y50,asset_sub_type[],2,FALSE))","v":""},null,null,{"$f":"IF(AB50=\"\", \"\", VLOOKUP(AB50,model[],2,FALSE))","v":""},null,null,{"$f":"IF(AE50=\"\", \"\", VLOOKUP(AE50,supplier[],2,FALSE))","v":""},null,{"$f":"IF(AG50=\"\", \"\", VLOOKUP(AG50,support_type[],2,FALSE))","v":""},null,{"$f":"IF(AI50=\"\", \"\", VLOOKUP(AI50,control_system[],2,FALSE))","v":""},null,{"$f":"IF(AK50=\"\", \"\", VLOOKUP(AK50,communications[],2,FALSE))","v":""},null,null,{"$f":"IF(AN50=\"\", \"\", VLOOKUP(AN50,maintained_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR50=\"\", \"\", VLOOKUP(AR50,contract_managed_by[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV50=\"\", \"\", VLOOKUP(AV50,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AZ50=\"\", \"\", VLOOKUP(AZ50,owner[],2,FALSE))","v":""},null,{"$f":"IF(BB50=\"\", \"\", VLOOKUP(BB50,condition_rating[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF50=\"\", \"\", VLOOKUP(BF50,criticality[],2,FALSE))","v":""}]

{"sheet":"Lookups","index":1,"n_rows":181,"n_cols":56,"rows_kept":181,"cut":false,"hidden":false,"merged":[]}
["site.description","site.code",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,"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"]
["Northwestern Motorway","0",null,"3M","3M",null,"Aerial photography","A",null,"Northland","1",null,"Northland","1",null,"In Service","1",null,"Cameras","CAM",null,"Analogue Video Matrix Switch","ANLGV",null,"1100 Mitto","1100M",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"]
["Esmonde Rd","1",null,"Automobile Association","AA",null,"Default","D",null,"Bay of Plenty West","10",null,"Nelson-Marlborough","10",null,"In Store","2",null,"Communications and Transmission","COMS",null,"Automatic number plate recognition","ANPR",null,"214","214",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"]
["TMC (Opposite)","2",null,"Auckland Council","ACC",null,"GPS device","G",null,"Rotorua District","11",null,"Canterbury","11",null,"Unavailable","3",null,"Device Controllers","DCON",null,"Full Advanced Traffic Management Systems","ATMS",null,"32-16-98 VMS-Amber","32_16",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"]
["Harbour bridge","3",null,"Alarm Centre Installation Ltd","ACI",null,"Click on Map","M",null,"Gisborne","12",null,"West Coast","12",null,"Disposed","4",null,"Electronic Barriers & Gates","EGTE",null,"Automated Barriers","AUTOBAR",null,"40-24-98-VMS-Amber","40_24",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"]
["Grafton Gully","4",null,"Agfirst","AGF",null,"Other","O",null,"Hawkes Bay","13",null,"Otago","13",null,null,null,null,"Enclosures","ENCL",null,"Automatic Traffic Control Gates","AUTOCG",null,"M4200E Skyrouter (CDMA modems only)","4200",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,null,null,"Auckland Motorway Alliance","AMA",null,"RAMM Generated","R",null,"West Wanganui","14",null,"Southland","14",null,null,null,null,"Environmental Sensors","ENVIRO",null,"Advanced Warning Sign","AWS",null,"M4400E Skyrouter (XT modems only)","4400",null,"Alan Shaw Electrical","ASHAW",null,"Bracket","BRACKET",null,"Jam Logic","JAM",null,"OOL","OOL",null,"Auckland Motorway Alliance","AMA",null,"Waitomo DC","4"]
[null,null,null,"Asset Management Engineers Ltd","AME",null,null,null,null,"East Wanganui","15",null,"National Office","15",null,null,null,null,"Electronic Signs","ESIGN",null,"Battery","BATT",null,"5230","5230",null,"Aspect Solutions Ltd (ASL)","ASL",null,"Inside of Cabinet","CAB",null,"VMS MACA","MACA",null,"Plain Old Telephone Service","POTS",null,"Asset Management Engineers Ltd","AME",null,"Private","5"]
[null,null,null,"Asset Management Technicians Ltd","AMT",null,null,null,null,"Wellington","16",null,"Auckland","2",null,null,null,null,"Power Supply","PWR",null,"Bend Warning Sign","BEND",null,"7601E","7601",null,"Astute","ASTUTE",null,"Cantilever support - Fixed Frangible","CANTF",null,"Metconnect Website","MET",null,"RF","RF",null,"Asset Management Technicians Ltd","AMT",null,"TDC","6"]
[null,null,null,"Armitage Systems","ARM",null,null,null,null,"Nelson","17",null,"Waikato","3",null,null,null,null,"Signals","SIGL",null,"Bluetooth Detector","BLUTOTH",null,"8500","8500",null,"Aspect Technology & Equipement Ltd","ATE",null,"Cantilever support - Fixed Non Frangible","CANTN",null,"None","NONE",null,"Satellite","SAT",null,"Armitage Systems","ARM",null,"Rotorua Disctrict Council","7"]
[null,null,null,"Aspect Solutions Ltd","ASL",null,null,null,null,"Marlborough Roads","18",null,"Bay of Plenty","4",null,null,null,null,"Vehicle Sensors & Detection processors","VSDP",null,"Cables - Copper","CABCOP",null,"8624","8624",null,"Braums Pty Ltd","BRAUMS",null,"Cantilever support - Rotating","CANTR",null,"SCATS","SCATS",null,"Sigfox","SIGF",null,"Aspect Solutions Ltd","ASL",null,"Trust Power","8"]
[null,null,null,"Auckland System Management","ASM",null,null,null,null,"North Canterbury","19",null,"Gisborne","5",null,null,null,null,null,null,null,"Cables","CABLE",null,"9752.125","9752",null,"Brian Ward","BWARD",null,"Combination Post support - Frangible / Rotating Flange","CPOST",null,"TIM","TIM",null,"Vodafone 3G","VODA",null,"Auckland System Management","ASM",null,"Tauranga City Council","9"]
[null,null,null,"Auckland Transport","AT2",null,null,null,null,"PSMC 005","2",null,"Hawkes Bay","6",null,null,null,null,null,null,null,"Fixed CCTV","CCTV",null,"Vextor A101M","A101M",null,"Cable Ways","CABLE",null,"Dual Post support - Frangible","DPOSTF",null,"TMS","TMS",null,"Wide Area Network (Ethernet)","WAN",null,"Auckland Transport","AT2"]
[null,null,null,"Aspect Technology and Equipment Ltd","ATE",null,null,null,null,"South Canterbury","20",null,"Taranaki","7",null,null,null,null,null,null,null,"Changeable Message Sign","CMS",null,"Ablerex MP RT1000-24","ABLEREX",null,"Channel 10","CHNL10",null,"Dual Post support - Non Frangible","DPOSTN",null,"WWW(Internet)","WWW",null,"XT-cellular (Telecom)","XT",null,"Aspect Technology and Equipment Ltd","ATE"]
[null,null,null,"ARRB Transport Research Ltd","ATR",null,null,null,null,"West Coast","21",null,"Manawatu-Whanganui","8",null,null,null,null,null,null,null,"Distributed Acoustic Sensing","DAS",null,"AT-AR440S","AR440S",null,"Computer Dynamics","COMP",null,"Emergency Phone Housing pole mount (banded)","EPHPOLE",null,null,null,null,null,null,null,"ARRB Transport Research Ltd","ATR"]
[null,null,null,"Auckland University","AUN",null,null,null,null,"Coastal Otago","22",null,"Wellington","9",null,null,null,null,null,null,null,"Environmental Stn","ENVIRO",null,"AT8624T/2M-V2-40","AT8624",null,"Connector Systems","CONN",null,"Emergency Phone Housing Wall mounted","EPHWALL",null,null,null,null,null,null,null,"Auckland University","AUN"]
[null,null,null,"Broadspectrum (NZ) Ltd","B(L",null,null,null,null,"Central Otago","23",null,null,null,null,null,null,null,null,null,null,"Ethernet Switches","ESWCH",null,"AT8624T/2M","AT8624T/2M",null,"Connect Security","CONNECT",null,"15m Folding CCTV Pole","FOLD",null,null,null,null,null,null,null,"Broadspectrum (NZ) Ltd","B(L"]
[null,null,null,"Bri-Ken and Associates Ltd","BAA",null,null,null,null,"Southland","24",null,null,null,null,null,null,null,null,null,null,"Fibre","FIBRE",null,"AT9924T","AT9924",null,"Combined Road & Traffic Services","CRTS",null,"Integrated Support (Camera)","INTSUP",null,null,null,null,null,null,null,"Bri-Ken and Associates Ltd","BAA"]
[null,null,null,"Bartley Consultants Ltd","BAR",null,null,null,null,"National Office","25",null,null,null,null,null,null,null,null,null,null,"Flashing Beacons","FLASH",null,"AT-GS950/8","AT-GS950/8",null,"CSL","CSL",null,"Mast","MAST",null,null,null,null,null,null,null,"Bartley Consultants Ltd","BAR"]
[null,null,null,"Bloxam Burnett & Olliver Ltd","BB&",null,null,null,null,"Auckland","3",null,null,null,null,null,null,null,null,null,null,"Flow detector","FLOW",null,"AT-X210 9GT","AT-X210 9G",null,"CSP","CSP",null,"Multiple Post support - Frangible","MPOSTF",null,null,null,null,null,null,null,"Bloxam Burnett & Olliver Ltd","BB&"]
[null,null,null,"Beca Infrastructure","BCF",null,null,null,null,"West Waikato","4",null,null,null,null,null,null,null,null,null,null,"Fuel Cell","FULC",null,"AT-X510 28GTX","AT-X510 28",null,"Currie Electrical Ltd","CUR",null,"Multiple Post support - Non Frangible","MPOSTN",null,null,null,null,null,null,null,"Beca Infrastructure","BCF"]
[null,null,null,"Buller District Council","BDC",null,null,null,null,"PSMC 006","5",null,null,null,null,null,null,null,null,null,null,"Gantry mounted","GANM",null,"AT-x930-28GSTX","AT-X930-28",null,"Daktronics","DAK",null,"No Support","NONE",null,null,null,null,null,null,null,"Buller District Council","BDC"]
[null,null,null,"Blacktop","BLA",null,null,null,null,"East Waikato","6",null,null,null,null,null,null,null,null,null,null,"Gensets","GENSETS",null,"CS Autodome 600","AUTO600",null,"Direct Earth","DIREARTH",null,"Emergency Phone Pedestal Mount (Mains) Frangible","PEDMF",null,null,null,null,null,null,null,"Blacktop","BLA"]
[null,null,null,"Beca Ltd.","BLT",null,null,null,null,"Central Waikato","7",null,null,null,null,null,null,null,null,null,null,"Wireless Device","HUB",null,"AWS_A","AWS_A",null,"Dove Electronics","DOVE",null,"Emergency Phone Pedestal Mount (Mains) Non Frangible","PEDMN",null,null,null,null,null,null,null,"Beca Ltd.","BLT"]
[null,null,null,"Civil Assist Ltd","CAL",null,null,null,null,"Tauranga City","8",null,null,null,null,null,null,null,null,null,null,"Humidity Device","HUMID",null,"AWS_B","AWS_B",null,"Egley Electrical","EGLEY",null,"Emergency Phone Pedestal Mount (Solar) Frangible","PEDSF",null,null,null,null,null,null,null,"Civil Assist Ltd","CAL"]
[null,null,null,"Christchurch City Council","CCC",null,null,null,null,"Bay of Plenty East","9",null,null,null,null,null,null,null,null,null,null,"Hydrocarbon sensor","HYDR",null,"AXIS213","AX213",null,"Electricians HB","ELECHB",null,"Emergency Phone Pedestal Mount (Solar) Non Frangible","PEDSN",null,null,null,null,null,null,null,"Christchurch City Council","CCC"]
[null,null,null,"City Care Ltd","CCL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ice Detection System","ICE",null,"Axis Q6215","AXIS Q6215",null,"Elite Doors","ELITE",null,"Pole Mount (Camera)","POLE",null,null,null,null,null,null,null,"City Care Ltd","CCL"]
[null,null,null,"Currie Electrical Ltd.","CEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inductive Loop Detector","INDLP",null,"Axis Q7401","AXIS Q7401",null,"ELWC Australia","ELWC",null,"Rack Mount (equipment)","RACK",null,null,null,null,null,null,null,"Currie Electrical Ltd.","CEL"]
[null,null,null,"Company-X Ltd.","CL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inverters","INVR",null,"B31206","B31206",null,"Engineering Computer Services","ENGCS",null,"Standoff attached to structure","STAND",null,null,null,null,null,null,null,"Company-X Ltd.","CL"]
[null,null,null,"Critchlow Limited","CL2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Isolating Transformer","ISTRN",null,"Bosch","BOSCH",null,"ETL Systems","ETL",null,"U-Shape support - Frangible","UPOSTF",null,null,null,null,null,null,null,"Critchlow Limited","CL2"]
[null,null,null,"Coastline Markers Ltd","CML",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lane Lighting","LANE",null,"Bosch Auto Dome 300","BOSCH AUTO",null,"Fulton Hogan","FH",null,"U-Shape support - Non Frangible","UPOSTN",null,null,null,null,null,null,null,"Coastline Markers Ltd","CML"]
[null,null,null,"CoreLogic NZ Ltd.","CNL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Light Sensitive Detection","LGHT",null,"Bosch Fixed","BOSCH FIXE",null,"Fusion Systems","FUSION",null,"Walkway Bracket","WALK",null,null,null,null,null,null,null,"CoreLogic NZ Ltd.","CNL"]
[null,null,null,"Central Otago District Council","COD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inductive Loops","LOOP",null,"Bosch G4","BOSCH G4",null,"Gate Drive Solutions ","GATE",null,null,null,null,null,null,null,null,null,null,"Central Otago District Council","COD"]
[null,null,null,"Other Contractor","CON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lane Signal Units","LSU",null,"Bosch UPH","BOSCH UPH",null,"General Electric","GE",null,null,null,null,null,null,null,null,null,null,"Other Contractor","CON"]
[null,null,null,"CSL Traffic","CSL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low Voltage Power","LVP",null,"Bosh 300 Series 18xD/N Envirodome","BOSCH300",null,"Geni","GENI",null,null,null,null,null,null,null,null,null,null,"CSL Traffic","CSL"]
[null,null,null,"Connell Wagner Ltd","CWL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Magnetometers","MAGM",null,"BT55-12FT","BT55",null,"Gilbert Sheet Metals","GILBERT",null,null,null,null,null,null,null,null,null,null,"Connell Wagner Ltd","CWL"]
[null,null,null,"Dunedin City Council","DCC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Media Converter","MEDCON",null,"CM6800E 48x8","CM6800",null,"Hills Security","HILLS",null,null,null,null,null,null,null,null,null,null,"Dunedin City Council","DCC"]
[null,null,null,"D & L Crowe Ltd","DLC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emergency Telephone System","METS",null,"CTV100BTFX/W2","CTV100",null,"HMI Technologies","HMI",null,null,null,null,null,null,null,null,null,null,"D & L Crowe Ltd","DLC"]
[null,null,null,"Spiire NZ Ltd","DWK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mini ATMS","MINI",null,"D1010","D1010",null,"Harding Traffic Ltd","HTL",null,null,null,null,null,null,null,null,null,null,"Spiire NZ Ltd","DWK"]
[null,null,null,"Excell Corporation","ECL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modem","MODEM",null,"D2125","D2125",null,"Hynds","HYNDS",null,null,null,null,null,null,null,null,null,null,"Excell Corporation","ECL"]
[null,null,null,"Ferguson Ind","FGI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multiplexer","MULTPLX",null,"D8030","D8030",null,"Integrated Automation Ltd","IAL",null,null,null,null,null,null,null,null,null,null,"Ferguson Ind","FGI"]
[null,null,null,"Fulton Hogan (NZ) Ltd.","FUL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mobile VMS","MVMS",null,"Dahua IR","DAHUA IR",null,"Ingram Micro","INGRAM",null,null,null,null,null,null,null,null,null,null,"Fulton Hogan (NZ) Ltd.","FUL"]
[null,null,null,"Gisborne District Council","GDC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLC Controller","PLC",null,"DEF","DEF",null,"Intek","INTEK",null,null,null,null,null,null,null,null,null,null,"Gisborne District Council","GDC"]
[null,null,null,"Geosolve Ltd","GEO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pan Tilt Zoom","PTZ",null,"Dinion XF D/N IP","DINIONIP",null,"Inzone","INZ",null,null,null,null,null,null,null,null,null,null,"Geosolve Ltd","GEO"]
[null,null,null,"GHD Ltd.","GHD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Piezo Detector","PZOD",null,"DRD11A","DRD11A",null,"ITS","ITS",null,null,null,null,null,null,null,null,null,null,"GHD Ltd.","GHD"]
[null,null,null,"HEB Construction Ltd","HEB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Radar","RADAR",null,"Datataker DT50","DT50",null,"Metservice","MET",null,null,null,null,null,null,null,null,null,null,"HEB Construction Ltd","HEB"]
[null,null,null,"Higgins Contractors Ltd.","HIG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rainfall Meter","RAIN",null,"DVT EZ201-0","DVT201",null,"Motorola","MROLA",null,null,null,null,null,null,null,null,null,null,"Higgins Contractors Ltd.","HIG"]
[null,null,null,"HMI Technologies","HMI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Road Side Controller","RDSC",null,"DVT7401 E","DVT74",null,"Nutech Security","NUT",null,null,null,null,null,null,null,null,null,null,"HMI Technologies","HMI"]
[null,null,null,"HERE New Zealand Ltd","HNZ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remote Reboot Unit","REBOT",null,"DVT7601 E","DVT76",null,"Local NZ Metalwork Shop","NZMETAL",null,null,null,null,null,null,null,null,null,null,"HERE New Zealand Ltd","HNZ"]
[null,null,null,"HTS Group","HTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red light","REDLT",null,"DVT7801 E","DVT78A",null,"Optimal Power","OPTIM",null,null,null,null,null,null,null,null,null,null,"HTS Group","HTS"]
[null,null,null,"Inframix Construction Ltd","IMX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regional VMS","REGVMS",null,"DVT7801 PEA","DVT78B",null,"Philips","PHIL",null,null,null,null,null,null,null,null,null,null,"Inframix Construction Ltd","IMX"]
[null,null,null,"Inzone","INZ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Radio Frequency Identification","RFID",null,"ECO-TWIN","ECO",null,"Power Electrical Contractors","POWER",null,null,null,null,null,null,null,null,null,null,"Inzone","INZ"]
[null,null,null,"Isaac Construction","ISC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"School Zone Sign","SCHOL",null,"ECPGNVANA 7040140","ECPGN",null,"Powertech Nelson","PTECH",null,null,null,null,null,null,null,null,null,null,"Isaac Construction","ISC"]
[null,null,null,"Island Asphalts","ISL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serial Server","SERIAL",null,"ECX2-62G-8-16","ECX2-62G-8",null,"Rittal","RITTAL",null,null,null,null,null,null,null,null,null,null,"Island Asphalts","ISL"]
[null,null,null,"ITS","ITS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Speed Indication Device","SID",null,"EH2512-EH2500 Series Enclosure","EH2512",null,"RTL","RTL",null,null,null,null,null,null,null,null,null,null,"ITS","ITS"]
[null,null,null,"Jacobs New Zealand Ltd","JAC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signal Controller Device","SIGCN",null,"EH2515","EH2515",null,"SEKTOR","SEKTOR",null,null,null,null,null,null,null,null,null,null,"Jacobs New Zealand Ltd","JAC"]
[null,null,null,"JCW Consultant","JC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signal Controller","SIGCON",null,"EH3515-2","EH3515",null,"Signopsys Electronic Signs","SIGNOPS",null,null,null,null,null,null,null,null,null,null,"JCW Consultant","JC"]
[null,null,null,"JCL Asphalt subcontractor","JCL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solar Panel","SOLAR",null,"EP1000LRT","EP1000",null,"Sound Logic Systems","SOUND",null,null,null,null,null,null,null,null,null,null,"JCL Asphalt subcontractor","JCL"]
[null,null,null,"JJ Walters","JJW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sound Measuring Device","SOUND",null,"ES31C22-2N-X","ES31",null,"Spunlite","SPUN",null,null,null,null,null,null,null,null,null,null,"JJ Walters","JJW"]
[null,null,null,"Johnstone & Masters Ltd","JM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temperature Sensor","TEMP",null,"ES31CBW35","ES31CB",null,"Struthers Security","STS",null,null,null,null,null,null,null,null,null,null,"Johnstone & Masters Ltd","JM"]
[null,null,null,"NZTA (JTOC)","JTO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thermal camera","THRM",null,"ES41E36","ES41E36",null,"Traffic Control Systems","TCS",null,null,null,null,null,null,null,null,null,null,"NZTA (JTOC)","JTO"]
[null,null,null,"Juno Services Ltd","JUN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traffic Monitoring System","TMS",null,"ES5230-12N","ES5230-12N",null,"Transfield Services","TFD",null,null,null,null,null,null,null,null,null,null,"Juno Services Ltd","JUN"]
[null,null,null,"Kapiti Coast District Council","KCD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traffic Signals","TRAFSIG",null,"ES5230-15NP","ES5230-15N",null,"Traffic Systems","TRA",null,null,null,null,null,null,null,null,null,null,"Kapiti Coast District Council","KCD"]
[null,null,null,"Kampung Consulting Ltd.","KCL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transformers","TRNF",null,"ESMW03","ESMW03",null,"Traficon","TRAF",null,null,null,null,null,null,null,null,null,null,"Kampung Consulting Ltd.","KCL"]
[null,null,null,"Kelcroft Engineering","KEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tubes","TUBES",null,"ESMW04","ESMW04",null,"Traffic Signs NZ Ltd","TS",null,null,null,null,null,null,null,null,null,null,"Kelcroft Engineering","KEL"]
[null,null,null,"Local Authority","LA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uninterrupted Power Supply","UPS",null,"Esprite","ESP",null,"Tyco","TYCO",null,null,null,null,null,null,null,null,null,null,"Local Authority","LA"]
[null,null,null,"Lonrix Ltd","LL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vehicle Detection Processor/Aggregator","VDPA",null,"F05302610","F05302610",null,"Zone Technology","ZONE",null,null,null,null,null,null,null,null,null,null,"Lonrix Ltd","LL"]
[null,null,null,"McKays Consultants","MCC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable Message Sign","VMS",null,"FC-644-ID","FC-644-ID",null,null,null,null,null,null,null,null,null,null,null,null,null,"McKays Consultants","MCC"]
[null,null,null,"Matamata-Piako District Council","MD2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VMS Controller Cards","VMSC",null,"FCHA1-M1T-WSE","FCH1",null,null,null,null,null,null,null,null,null,null,null,null,null,"Matamata-Piako District Council","MD2"]
[null,null,null,"Manawatu District Council","MDC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable Mandatory Speed Sign","VMSS",null,"FCHA1-DB1-M1T-MSE","FCH2",null,null,null,null,null,null,null,null,null,null,null,null,null,"Manawatu District Council","MDC"]
[null,null,null,"McKay Electrical Ltd","MEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable Speed Sign","VSS",null,"FCU18025SC-S15","FCU_S15",null,null,null,null,null,null,null,null,null,null,null,null,null,"McKay Electrical Ltd","MEL"]
[null,null,null,"Aecom NZ Ltd","MER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Load Cell","WIM",null,"FD12","FD12",null,null,null,null,null,null,null,null,null,null,null,null,null,"Aecom NZ Ltd","MER"]
[null,null,null,"MetService","MET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wind Monitor","WIND",null,"Flexidome","FLEXIDOME",null,null,null,null,null,null,null,null,null,null,null,null,null,"MetService","MET"]
[null,null,null,"Marlborough NOC JV","MJV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wireless Vehicle Tracking Systems","WIREVEH",null,"FLIR","FLIR",null,null,null,null,null,null,null,null,null,null,null,null,null,"Marlborough NOC JV","MJV"]
[null,null,null,"McKay Ltd.","ML",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FM1200V-HW","FM1200V-HW",null,null,null,null,null,null,null,null,null,null,null,null,null,"McKay Ltd.","ML"]
[null,null,null,"Marlborough Roads","MR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G4 Dome","G4",null,null,null,null,null,null,null,null,null,null,null,null,null,"Marlborough Roads","MR"]
[null,null,null,"MWH NZ Ltd.","MWH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Generic Prism CMS","GEN",null,null,null,null,null,null,null,null,null,null,null,null,null,"MWH NZ Ltd.","MWH"]
[null,null,null,"Napier City Council","NCC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GXT2-1500 RT0230","GXT2",null,null,null,null,null,null,null,null,null,null,null,null,null,"Napier City Council","NCC"]
[null,null,null,"NZ Transport Agency - Highway Programme","NTA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GXT2-V8VBATT","GXT2_B",null,null,null,null,null,null,null,null,null,null,null,null,null,"NZ Transport Agency - Highway Programme","NTA"]
[null,null,null,"NZ Transport Agency - Funding","NTF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H6ZE-R","H6ZE",null,null,null,null,null,null,null,null,null,null,null,null,null,"NZ Transport Agency - Funding","NTF"]
[null,null,null,"North Power","NTH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HD_S125 Smart Sensor","HD_S125",null,null,null,null,null,null,null,null,null,null,null,null,null,"North Power","NTH"]
[null,null,null,"Nutech Security","NUT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HD interceptor","HDINTERCEP",null,null,null,null,null,null,null,null,null,null,null,null,null,"Nutech Security","NUT"]
[null,null,null,"Odyssey Energy (2009) Ltd.","OE(",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIPath 3300/3500","HIPATH",null,null,null,null,null,null,null,null,null,null,null,null,null,"Odyssey Energy (2009) Ltd.","OE("]
[null,null,null,"Opus International Consultants Ltd (NZ)","OI2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HZC 10/200","HZC",null,null,null,null,null,null,null,null,null,null,null,null,null,"Opus International Consultants Ltd (NZ)","OI2"]
[null,null,null,"Opus International Consultants Ltd.","OIC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interceptor","INTERCEPTO",null,null,null,null,null,null,null,null,null,null,null,null,null,"Opus International Consultants Ltd.","OIC"]
[null,null,null,"Oldfields","OLD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KBD-300A","KBD",null,null,null,null,null,null,null,null,null,null,null,null,null,"Oldfields","OLD"]
[null,null,null,"Porirua City Council","PCC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LC903P-B","LC903",null,null,null,null,null,null,null,null,null,null,null,null,null,"Porirua City Council","PCC"]
[null,null,null,"Pinnacles Civil Group Ltd.","PCG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LCP903P-B","LCP903",null,null,null,null,null,null,null,null,null,null,null,null,null,"Pinnacles Civil Group Ltd.","PCG"]
[null,null,null,"Pope Electrical Ltd","PE2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTC0498/11","LTC04",null,null,null,null,null,null,null,null,null,null,null,null,null,"Pope Electrical Ltd","PE2"]
[null,null,null,"Pope Electrical Limited","PEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTC3374/21 5-50mm 1:1.4","LTC3374",null,null,null,null,null,null,null,null,null,null,null,null,null,"Pope Electrical Limited","PEL"]
[null,null,null,"Pavement Management Services","PMS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTC3674/20","LTC36",null,null,null,null,null,null,null,null,null,null,null,null,null,"Pavement Management Services","PMS"]
[null,null,null,"Power Solutions Ltd","PSL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTC610","LTC610",null,null,null,null,null,null,null,null,null,null,null,null,null,"Power Solutions Ltd","PSL"]
[null,null,null,"Queenstown-Lakes District Council","QDC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LTC9215/00","LTC921",null,null,null,null,null,null,null,null,null,null,null,null,null,"Queenstown-Lakes District Council","QDC"]
[null,null,null,"Quality Roading and Services","QRS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LVC-C553HP (PAL)","LVC_C553",null,null,null,null,null,null,null,null,null,null,null,null,null,"Quality Roading and Services","QRS"]
[null,null,null,"Read-only access for Tenderers","RAF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M3057","M3057",null,null,null,null,null,null,null,null,null,null,null,null,null,"Read-only access for Tenderers","RAF"]
[null,null,null,"Rangitikei District Council","RDC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marksman 720","MARKS",null,null,null,null,null,null,null,null,null,null,null,null,null,"Rangitikei District Council","RDC"]
[null,null,null,"Roadex","RDX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MC103XL-40","MC103",null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadex","RDX"]
[null,null,null,"Roading Logistics Ltd","RLL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MS3 - Bespoke Full Size","MS3A",null,null,null,null,null,null,null,null,null,null,null,null,null,"Roading Logistics Ltd","RLL"]
[null,null,null,"Rationale Ltd","RLT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MS3 - Bespoke Small","MS3B",null,null,null,null,null,null,null,null,null,null,null,null,null,"Rationale Ltd","RLT"]
[null,null,null,"Rotorua District Council","ROT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MX4016CS-X","MX4016",null,null,null,null,null,null,null,null,null,null,null,null,null,"Rotorua District Council","ROT"]
[null,null,null,"RAMM Software Limited","RSL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Applicable","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,"RAMM Software Limited","RSL"]
[null,null,null,"Road Signs & Traffic Control Equipment Limited","RTL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NDN-948V03-11PS","NDN_11PS",null,null,null,null,null,null,null,null,null,null,null,null,null,"Road Signs & Traffic Control Equipment Limited","RTL"]
[null,null,null,"Russell Roads","RUS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NPort 5100 series","NPort",null,null,null,null,null,null,null,null,null,null,null,null,null,"Russell Roads","RUS"]
[null,null,null,"Salient Consultants","SAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NTCIP VMSS","NTCIP",null,null,null,null,null,null,null,null,null,null,null,null,null,"Salient Consultants","SAL"]
[null,null,null,"Sealcoat Central Ltd.","SCL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OSD 420 Tx/Rx","OSD370",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sealcoat Central Ltd.","SCL"]
[null,null,null,"Shaw's Consulting Services Ltd","SCS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OSD370 19\"\" 3RU","OSD420",null,null,null,null,null,null,null,null,null,null,null,null,null,"Shaw's Consulting Services Ltd","SCS"]
[null,null,null,"Southland District Council","SDC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P1435-LE","P1435-LE",null,null,null,null,null,null,null,null,null,null,null,null,null,"Southland District Council","SDC"]
[null,null,null,"Signopsys Electronic Signs","SES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P3225-LVE MK11","P3225-LVE",null,null,null,null,null,null,null,null,null,null,null,null,null,"Signopsys Electronic Signs","SES"]
[null,null,null,"Sicon Ltd.","SL2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Axis P3343-VE","P3343-VE",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sicon Ltd.","SL2"]
[null,null,null,"Stantec New Zealand","SN2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P3365","P3365",null,null,null,null,null,null,null,null,null,null,null,null,null,"Stantec New Zealand","SN2"]
[null,null,null,"Stantec New Zealand Ltd","SNZ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Axis P5512-E","P5512-E",null,null,null,null,null,null,null,null,null,null,null,null,null,"Stantec New Zealand Ltd","SNZ"]
[null,null,null,"SouthRoads Ltd.","SOU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PDR-9LX 750GB","PDR-9LX",null,null,null,null,null,null,null,null,null,null,null,null,null,"SouthRoads Ltd.","SOU"]
[null,null,null,"Safe Roads Alliance","SRA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pedestal","PEDESTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,"Safe Roads Alliance","SRA"]
[null,null,null,"Services South East (NZ) Ltd.","SS2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pelco Dome","PELCO DOME",null,null,null,null,null,null,null,null,null,null,null,null,null,"Services South East (NZ) Ltd.","SS2"]
[null,null,null,"Services South East Pty Ltd","SSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pelco Esprit","PELCO ESPR",null,null,null,null,null,null,null,null,null,null,null,null,null,"Services South East Pty Ltd","SSE"]
[null,null,null,"Tonkin & Taylor Ltd","T&T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PIH-6032","PIH",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tonkin & Taylor Ltd","T&T"]
[null,null,null,"Tasman Howey","TAS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1765-LE","Q1765-LE",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tasman Howey","TAS"]
[null,null,null,"NZTA and WDM","TAW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1785-LE","Q1785-LE",null,null,null,null,null,null,null,null,null,null,null,null,null,"NZTA and WDM","TAW"]
[null,null,null,"Tauranga City Council","TC2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q6032-E","Q6032-E",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tauranga City Council","TC2"]
[null,null,null,"Taranaki Civil Construction","TCC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q6114","Q6114",null,null,null,null,null,null,null,null,null,null,null,null,null,"Taranaki Civil Construction","TCC"]
[null,null,null,"TC Nicholls","TCN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q6114-E","Q6114-E",null,null,null,null,null,null,null,null,null,null,null,null,null,"TC Nicholls","TCN"]
[null,null,null,"Traffic Control Systems","TCS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q6115","Q6115",null,null,null,null,null,null,null,null,null,null,null,null,null,"Traffic Control Systems","TCS"]
[null,null,null,"Taupo District Council","TD2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q6124","Q6124",null,null,null,null,null,null,null,null,null,null,null,null,null,"Taupo District Council","TD2"]
[null,null,null,"Tasman District Council","TDC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q6124-E","Q6124-E",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tasman District Council","TDC"]
[null,null,null,"The Datastack Ltd","TDL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q6125","Q6125",null,null,null,null,null,null,null,null,null,null,null,null,null,"The Datastack Ltd","TDL"]
[null,null,null,"Taupo East Traffic Services Contractor","TET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q6125-LE","Q6125-LE",null,null,null,null,null,null,null,null,null,null,null,null,null,"Taupo East Traffic Services Contractor","TET"]
[null,null,null,"Broadspectrum (NZ) Ltd","TFD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quasar CP-3211-181","QUASAR3211",null,null,null,null,null,null,null,null,null,null,null,null,null,"Broadspectrum (NZ) Ltd","TFD"]
[null,null,null,"Waka Kotahi NZ Transport Agency","TNZ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rimco 8020","R8020",null,null,null,null,null,null,null,null,null,null,null,null,null,"Waka Kotahi NZ Transport Agency","TNZ"]
[null,null,null,"Top Energy","TOP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REG-L1875","RG-L1",null,null,null,null,null,null,null,null,null,null,null,null,null,"Top Energy","TOP"]
[null,null,null,"The Roading Company","TRC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RTMS K3 IP","RTMS",null,null,null,null,null,null,null,null,null,null,null,null,null,"The Roading Company","TRC"]
[null,null,null,"Transfield Services (NZ) Ltd","TS(",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SDIII WV-CP484","SDIII",null,null,null,null,null,null,null,null,null,null,null,null,null,"Transfield Services (NZ) Ltd","TS("]
[null,null,null,"Tonkin and Taylor Ltd","TT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SMCFS5","SMCFS5",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tonkin and Taylor Ltd","TT"]
[null,null,null,"Tyco Traffic and Transportation","TYC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SP3105AS","SP310",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tyco Traffic and Transportation","TYC"]
[null,null,null,"Urban Connection Ltd","UCL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPE Modem","SPE",null,null,null,null,null,null,null,null,null,null,null,null,null,"Urban Connection Ltd","UCL"]
[null,null,null,"University of Canterbury","UOC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPEC IV","SPEC IV",null,null,null,null,null,null,null,null,null,null,null,null,null,"University of Canterbury","UOC"]
[null,null,null,"Ventia Pty Ltd","VPL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spectra IV SD435-F1-X","SPEC4_E1",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ventia Pty Ltd","VPL"]
[null,null,null,"Western Bay of Plenty District Council","WBO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spectra IV SD435-PG-E1-X","SPEC4_F1",null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Bay of Plenty District Council","WBO"]
[null,null,null,"Wellington City Council","WCC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SSC DC83P","SSC",null,null,null,null,null,null,null,null,null,null,null,null,null,"Wellington City Council","WCC"]
[null,null,null,"Waimakariri District Council","WD2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Swarco colour Motorway","SWARCO",null,null,null,null,null,null,null,null,null,null,null,null,null,"Waimakariri District Council","WD2"]
[null,null,null,"Whakatane District Council","WD3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC450SR","TC450",null,null,null,null,null,null,null,null,null,null,null,null,null,"Whakatane District Council","WD3"]
[null,null,null,"Wairoa District Council","WD4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TXB-N-ADXFGE6","TXB-N-ADXF",null,null,null,null,null,null,null,null,null,null,null,null,null,"Wairoa District Council","WD4"]
[null,null,null,"Waipa District Council","WD5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UCL900DM / WYA904","UCL900",null,null,null,null,null,null,null,null,null,null,null,null,null,"Waipa District Council","WD5"]
[null,null,null,"Waikato District Council","WD6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UP80E","UP80E",null,null,null,null,null,null,null,null,null,null,null,null,null,"Waikato District Council","WD6"]
[null,null,null,"Whangarei District Council","WDC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VDT14130","VDT14",null,null,null,null,null,null,null,null,null,null,null,null,null,"Whangarei District Council","WDC"]
[null,null,null,"WDM","WDM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VF1000-18-90-18R","VF1000A",null,null,null,null,null,null,null,null,null,null,null,null,null,"WDM","WDM"]
[null,null,null,"WSP-Opus International Consultants Ltd","WIC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VF1000-27x105-12-R","VF1000B",null,null,null,null,null,null,null,null,null,null,null,null,null,"WSP-Opus International Consultants Ltd","WIC"]
[null,null,null,"Downer New Zealand Limited","WIL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VF1000-27x105-18-R","VF1000C",null,null,null,null,null,null,null,null,null,null,null,null,null,"Downer New Zealand Limited","WIL"]
[null,null,null,"W J Ashton Service Ltd","WJA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VG4-513-ECSOP","VG4",null,null,null,null,null,null,null,null,null,null,null,null,null,"W J Ashton Service Ltd","WJA"]
[null,null,null,"Waka Kotahi NZ Transport Agency - Highways","WK2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vip X1 05500253","VIP X1 055",null,null,null,null,null,null,null,null,null,null,null,null,null,"Waka Kotahi NZ Transport Agency - Highways","WK2"]
[null,null,null,"Waka Kotahi NZ Transport Agency","WKN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VIPX1","VIPX",null,null,null,null,null,null,null,null,null,null,null,null,null,"Waka Kotahi NZ Transport Agency","WKN"]
[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,"VIPX1 Integrated","VIPX1 I",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,"VMS Type A","VMS_A"]
[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","VMS_AC"]
[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","VMS_B"]
[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","VMS_C"]
[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","VMS_D"]
[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","VMS_DUC"]
[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","VMS_F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VMS_MA","VMS_MA"]
[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","VMS_MC"]
[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","VMS_OC"]
[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 18-400","VMS18-400"]
[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","VMSS"]
[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","VR11"]
[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","VR15"]
[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","VR18"]
[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","VR19"]
[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","VR78"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vision SID","VSID"]
[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","VT10"]
[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","VT15"]
[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","VT19"]
[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","VT72"]
[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","VT74"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vector W200P","W200P"]
[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","WALL STYLE"]
[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","WS_WE"]
[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","X210-9GT"]
[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","X510-28GT"]
[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","X510-28GTX"]
[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","X900-24XT"]