{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["MaintenanceActivity","Lookups"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":12,"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":"MaintenanceActivity","index":0,"n_rows":50,"n_cols":29,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["15f221f1-c15e-4d8e-a679-81fade5c4405_road_id","ba4adf1f-d64b-4d2c-a600-a59acebf3405_road_id","sh-rs-d","15f221f1-c15e-4d8e-a679-81fade5c4404_start_m","ba4adf1f-d64b-4d2c-a600-a59acebf3404_end_m","76ac9329-73ad-4812-a97a-116a68d4af3c_work_position_desc","76ac9329-73ad-4812-a97a-116a68d4af3c_work_position","be6a2e4f-3f46-4313-ac8c-90564376b4aa_gps_by_desc","be6a2e4f-3f46-4313-ac8c-90564376b4aa_gps_by","bcebafba-2aaf-4987-9dbd-00c297b053b6_gps_method_id_desc","bcebafba-2aaf-4987-9dbd-00c297b053b6_gps_method_id","a87249b0-3371-4dc6-970c-c358905b13e6_northing","7de77c4d-8b62-4959-a86e-61662b674dcc_easting","acd48b27-89b6-4f43-ab3c-23d4bec12d15_external_id","c87c37b7-e680-4311-a62b-32c3de5f7c74_transaction_date","d848840a-c0a4-4ffa-bac9-dd7d8b9c428b_cost_group_desc","d848840a-c0a4-4ffa-bac9-dd7d8b9c428b_cost_group","80d258e7-21b3-47b9-8e3c-4a2c95d9974b_activity_desc","80d258e7-21b3-47b9-8e3c-4a2c95d9974b_activity","eca4fc6d-9fc3-4bd7-b2a6-87f3d9da825c_fault_desc","eca4fc6d-9fc3-4bd7-b2a6-87f3d9da825c_fault","d5ef3c45-0f09-4a3d-9e71-901e6baf4ebf_failure_desc","d5ef3c45-0f09-4a3d-9e71-901e6baf4ebf_failure","324cfbbc-3ed6-4e11-a32e-2927daf85f2d_qty_unit","324cfbbc-3ed6-4e11-a32e-2927daf85f2d_qty_unit_desc","76fe89a5-47f3-40a6-a7e1-d21e7d584ae0_quantity","7ea418a0-5b6b-4e7f-a4f1-64d4fe55c3a6_cost_amount","4d3d7ac2-7bdf-4362-866c-65d0affe08ff_analysis_code","0d391d31-deca-4408-877e-8da34c73fa3d_adj_quantity"]
["road_id","road_id","sh-rs-d","start_m","end_m","work_position_desc","work_position","gps_by_desc","gps_by","gps_method_id_desc","gps_method_id","northing","easting","external_id","transaction_date","cost_group_desc","cost_group","activity_desc","activity","fault_desc","fault","failure_desc","failure","qty_unit","qty_unit_desc","quantity","cost_amount","analysis_code","adj_quantity"]
["Start Road Id","End Road Id","SH-RS-D  (e.g. 016-0000-B) letter must be uppercase","RP Start (m)","RP End (m)","Work Position Desc","Work Position","GPS By Desc","GPS By","GPS Method Id Desc","GPS Method Id","Northing","Easting","External Id","Transaction date (dd/mm/yyyy) must include leading 0","Cost Group Desc","Cost Group","Activity Desc","Activity","Fault Desc","Fault","Failure Desc","Failure","Quantity Unit","Quantity Unit Desc","Quantity","Cost Amount","Analysis Code","Adjust Quantity"]
[{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&C4&\"/\"&D4&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&C4&\"/\"&E4&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,{"$f":"IF(F4=\"\", \"\", VLOOKUP(F4, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H4=\"\", \"\", VLOOKUP(H4, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J4=\"\", \"\", VLOOKUP(J4, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P4=\"\", \"\", VLOOKUP(P4, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R4=\"\", \"\", VLOOKUP(R4, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T4=\"\", \"\", VLOOKUP(T4, fault[], 2, FALSE))","v":""}]
[{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&C5&\"/\"&D5&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&C5&\"/\"&E5&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,{"$f":"IF(F5=\"\", \"\", VLOOKUP(F5, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H5=\"\", \"\", VLOOKUP(H5, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J5=\"\", \"\", VLOOKUP(J5, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P5=\"\", \"\", VLOOKUP(P5, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R5=\"\", \"\", VLOOKUP(R5, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T5=\"\", \"\", VLOOKUP(T5, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F6=\"\", \"\", VLOOKUP(F6, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H6=\"\", \"\", VLOOKUP(H6, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J6=\"\", \"\", VLOOKUP(J6, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P6=\"\", \"\", VLOOKUP(P6, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R6=\"\", \"\", VLOOKUP(R6, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T6=\"\", \"\", VLOOKUP(T6, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F7=\"\", \"\", VLOOKUP(F7, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H7=\"\", \"\", VLOOKUP(H7, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J7=\"\", \"\", VLOOKUP(J7, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P7=\"\", \"\", VLOOKUP(P7, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R7=\"\", \"\", VLOOKUP(R7, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T7=\"\", \"\", VLOOKUP(T7, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F8=\"\", \"\", VLOOKUP(F8, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H8=\"\", \"\", VLOOKUP(H8, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J8=\"\", \"\", VLOOKUP(J8, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P8=\"\", \"\", VLOOKUP(P8, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R8=\"\", \"\", VLOOKUP(R8, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T8=\"\", \"\", VLOOKUP(T8, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F9=\"\", \"\", VLOOKUP(F9, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H9=\"\", \"\", VLOOKUP(H9, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J9=\"\", \"\", VLOOKUP(J9, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P9=\"\", \"\", VLOOKUP(P9, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R9=\"\", \"\", VLOOKUP(R9, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T9=\"\", \"\", VLOOKUP(T9, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F10=\"\", \"\", VLOOKUP(F10, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H10=\"\", \"\", VLOOKUP(H10, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J10=\"\", \"\", VLOOKUP(J10, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P10=\"\", \"\", VLOOKUP(P10, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R10=\"\", \"\", VLOOKUP(R10, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T10=\"\", \"\", VLOOKUP(T10, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F11=\"\", \"\", VLOOKUP(F11, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H11=\"\", \"\", VLOOKUP(H11, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J11=\"\", \"\", VLOOKUP(J11, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P11=\"\", \"\", VLOOKUP(P11, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R11=\"\", \"\", VLOOKUP(R11, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T11=\"\", \"\", VLOOKUP(T11, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F12=\"\", \"\", VLOOKUP(F12, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H12=\"\", \"\", VLOOKUP(H12, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J12=\"\", \"\", VLOOKUP(J12, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P12=\"\", \"\", VLOOKUP(P12, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R12=\"\", \"\", VLOOKUP(R12, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T12=\"\", \"\", VLOOKUP(T12, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F13=\"\", \"\", VLOOKUP(F13, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H13=\"\", \"\", VLOOKUP(H13, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J13=\"\", \"\", VLOOKUP(J13, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P13=\"\", \"\", VLOOKUP(P13, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R13=\"\", \"\", VLOOKUP(R13, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T13=\"\", \"\", VLOOKUP(T13, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F14=\"\", \"\", VLOOKUP(F14, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H14=\"\", \"\", VLOOKUP(H14, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J14=\"\", \"\", VLOOKUP(J14, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P14=\"\", \"\", VLOOKUP(P14, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R14=\"\", \"\", VLOOKUP(R14, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T14=\"\", \"\", VLOOKUP(T14, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F15=\"\", \"\", VLOOKUP(F15, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H15=\"\", \"\", VLOOKUP(H15, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J15=\"\", \"\", VLOOKUP(J15, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P15=\"\", \"\", VLOOKUP(P15, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R15=\"\", \"\", VLOOKUP(R15, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T15=\"\", \"\", VLOOKUP(T15, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F16=\"\", \"\", VLOOKUP(F16, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H16=\"\", \"\", VLOOKUP(H16, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J16=\"\", \"\", VLOOKUP(J16, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P16=\"\", \"\", VLOOKUP(P16, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R16=\"\", \"\", VLOOKUP(R16, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T16=\"\", \"\", VLOOKUP(T16, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F17=\"\", \"\", VLOOKUP(F17, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H17=\"\", \"\", VLOOKUP(H17, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J17=\"\", \"\", VLOOKUP(J17, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P17=\"\", \"\", VLOOKUP(P17, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R17=\"\", \"\", VLOOKUP(R17, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T17=\"\", \"\", VLOOKUP(T17, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F18=\"\", \"\", VLOOKUP(F18, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H18=\"\", \"\", VLOOKUP(H18, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J18=\"\", \"\", VLOOKUP(J18, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P18=\"\", \"\", VLOOKUP(P18, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R18=\"\", \"\", VLOOKUP(R18, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T18=\"\", \"\", VLOOKUP(T18, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F19=\"\", \"\", VLOOKUP(F19, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H19=\"\", \"\", VLOOKUP(H19, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J19=\"\", \"\", VLOOKUP(J19, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P19=\"\", \"\", VLOOKUP(P19, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R19=\"\", \"\", VLOOKUP(R19, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T19=\"\", \"\", VLOOKUP(T19, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F20=\"\", \"\", VLOOKUP(F20, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H20=\"\", \"\", VLOOKUP(H20, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J20=\"\", \"\", VLOOKUP(J20, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P20=\"\", \"\", VLOOKUP(P20, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R20=\"\", \"\", VLOOKUP(R20, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T20=\"\", \"\", VLOOKUP(T20, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F21=\"\", \"\", VLOOKUP(F21, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H21=\"\", \"\", VLOOKUP(H21, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J21=\"\", \"\", VLOOKUP(J21, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P21=\"\", \"\", VLOOKUP(P21, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R21=\"\", \"\", VLOOKUP(R21, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T21=\"\", \"\", VLOOKUP(T21, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F22=\"\", \"\", VLOOKUP(F22, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H22=\"\", \"\", VLOOKUP(H22, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J22=\"\", \"\", VLOOKUP(J22, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P22=\"\", \"\", VLOOKUP(P22, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R22=\"\", \"\", VLOOKUP(R22, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T22=\"\", \"\", VLOOKUP(T22, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F23=\"\", \"\", VLOOKUP(F23, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H23=\"\", \"\", VLOOKUP(H23, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J23=\"\", \"\", VLOOKUP(J23, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P23=\"\", \"\", VLOOKUP(P23, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R23=\"\", \"\", VLOOKUP(R23, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T23=\"\", \"\", VLOOKUP(T23, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F24=\"\", \"\", VLOOKUP(F24, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H24=\"\", \"\", VLOOKUP(H24, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J24=\"\", \"\", VLOOKUP(J24, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P24=\"\", \"\", VLOOKUP(P24, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R24=\"\", \"\", VLOOKUP(R24, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T24=\"\", \"\", VLOOKUP(T24, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F25=\"\", \"\", VLOOKUP(F25, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H25=\"\", \"\", VLOOKUP(H25, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J25=\"\", \"\", VLOOKUP(J25, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P25=\"\", \"\", VLOOKUP(P25, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R25=\"\", \"\", VLOOKUP(R25, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T25=\"\", \"\", VLOOKUP(T25, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F26=\"\", \"\", VLOOKUP(F26, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H26=\"\", \"\", VLOOKUP(H26, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J26=\"\", \"\", VLOOKUP(J26, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P26=\"\", \"\", VLOOKUP(P26, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R26=\"\", \"\", VLOOKUP(R26, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T26=\"\", \"\", VLOOKUP(T26, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F27=\"\", \"\", VLOOKUP(F27, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H27=\"\", \"\", VLOOKUP(H27, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J27=\"\", \"\", VLOOKUP(J27, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P27=\"\", \"\", VLOOKUP(P27, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R27=\"\", \"\", VLOOKUP(R27, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T27=\"\", \"\", VLOOKUP(T27, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F28=\"\", \"\", VLOOKUP(F28, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H28=\"\", \"\", VLOOKUP(H28, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J28=\"\", \"\", VLOOKUP(J28, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P28=\"\", \"\", VLOOKUP(P28, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R28=\"\", \"\", VLOOKUP(R28, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T28=\"\", \"\", VLOOKUP(T28, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F29=\"\", \"\", VLOOKUP(F29, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H29=\"\", \"\", VLOOKUP(H29, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J29=\"\", \"\", VLOOKUP(J29, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P29=\"\", \"\", VLOOKUP(P29, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R29=\"\", \"\", VLOOKUP(R29, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T29=\"\", \"\", VLOOKUP(T29, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F30=\"\", \"\", VLOOKUP(F30, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H30=\"\", \"\", VLOOKUP(H30, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J30=\"\", \"\", VLOOKUP(J30, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P30=\"\", \"\", VLOOKUP(P30, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R30=\"\", \"\", VLOOKUP(R30, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T30=\"\", \"\", VLOOKUP(T30, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F31=\"\", \"\", VLOOKUP(F31, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H31=\"\", \"\", VLOOKUP(H31, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J31=\"\", \"\", VLOOKUP(J31, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P31=\"\", \"\", VLOOKUP(P31, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R31=\"\", \"\", VLOOKUP(R31, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T31=\"\", \"\", VLOOKUP(T31, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F32=\"\", \"\", VLOOKUP(F32, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H32=\"\", \"\", VLOOKUP(H32, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J32=\"\", \"\", VLOOKUP(J32, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P32=\"\", \"\", VLOOKUP(P32, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R32=\"\", \"\", VLOOKUP(R32, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T32=\"\", \"\", VLOOKUP(T32, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F33=\"\", \"\", VLOOKUP(F33, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H33=\"\", \"\", VLOOKUP(H33, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J33=\"\", \"\", VLOOKUP(J33, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P33=\"\", \"\", VLOOKUP(P33, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R33=\"\", \"\", VLOOKUP(R33, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T33=\"\", \"\", VLOOKUP(T33, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F34=\"\", \"\", VLOOKUP(F34, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H34=\"\", \"\", VLOOKUP(H34, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J34=\"\", \"\", VLOOKUP(J34, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P34=\"\", \"\", VLOOKUP(P34, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R34=\"\", \"\", VLOOKUP(R34, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T34=\"\", \"\", VLOOKUP(T34, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F35=\"\", \"\", VLOOKUP(F35, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H35=\"\", \"\", VLOOKUP(H35, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J35=\"\", \"\", VLOOKUP(J35, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P35=\"\", \"\", VLOOKUP(P35, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R35=\"\", \"\", VLOOKUP(R35, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T35=\"\", \"\", VLOOKUP(T35, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F36=\"\", \"\", VLOOKUP(F36, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H36=\"\", \"\", VLOOKUP(H36, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J36=\"\", \"\", VLOOKUP(J36, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P36=\"\", \"\", VLOOKUP(P36, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R36=\"\", \"\", VLOOKUP(R36, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T36=\"\", \"\", VLOOKUP(T36, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F37=\"\", \"\", VLOOKUP(F37, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H37=\"\", \"\", VLOOKUP(H37, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J37=\"\", \"\", VLOOKUP(J37, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P37=\"\", \"\", VLOOKUP(P37, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R37=\"\", \"\", VLOOKUP(R37, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T37=\"\", \"\", VLOOKUP(T37, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F38=\"\", \"\", VLOOKUP(F38, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H38=\"\", \"\", VLOOKUP(H38, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J38=\"\", \"\", VLOOKUP(J38, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P38=\"\", \"\", VLOOKUP(P38, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R38=\"\", \"\", VLOOKUP(R38, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T38=\"\", \"\", VLOOKUP(T38, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F39=\"\", \"\", VLOOKUP(F39, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H39=\"\", \"\", VLOOKUP(H39, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J39=\"\", \"\", VLOOKUP(J39, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P39=\"\", \"\", VLOOKUP(P39, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R39=\"\", \"\", VLOOKUP(R39, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T39=\"\", \"\", VLOOKUP(T39, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F40=\"\", \"\", VLOOKUP(F40, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H40=\"\", \"\", VLOOKUP(H40, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J40=\"\", \"\", VLOOKUP(J40, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P40=\"\", \"\", VLOOKUP(P40, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R40=\"\", \"\", VLOOKUP(R40, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T40=\"\", \"\", VLOOKUP(T40, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F41=\"\", \"\", VLOOKUP(F41, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H41=\"\", \"\", VLOOKUP(H41, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J41=\"\", \"\", VLOOKUP(J41, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P41=\"\", \"\", VLOOKUP(P41, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R41=\"\", \"\", VLOOKUP(R41, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T41=\"\", \"\", VLOOKUP(T41, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F42=\"\", \"\", VLOOKUP(F42, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H42=\"\", \"\", VLOOKUP(H42, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J42=\"\", \"\", VLOOKUP(J42, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P42=\"\", \"\", VLOOKUP(P42, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R42=\"\", \"\", VLOOKUP(R42, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T42=\"\", \"\", VLOOKUP(T42, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F43=\"\", \"\", VLOOKUP(F43, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H43=\"\", \"\", VLOOKUP(H43, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J43=\"\", \"\", VLOOKUP(J43, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P43=\"\", \"\", VLOOKUP(P43, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R43=\"\", \"\", VLOOKUP(R43, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T43=\"\", \"\", VLOOKUP(T43, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F44=\"\", \"\", VLOOKUP(F44, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H44=\"\", \"\", VLOOKUP(H44, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J44=\"\", \"\", VLOOKUP(J44, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P44=\"\", \"\", VLOOKUP(P44, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R44=\"\", \"\", VLOOKUP(R44, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T44=\"\", \"\", VLOOKUP(T44, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F45=\"\", \"\", VLOOKUP(F45, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H45=\"\", \"\", VLOOKUP(H45, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J45=\"\", \"\", VLOOKUP(J45, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P45=\"\", \"\", VLOOKUP(P45, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R45=\"\", \"\", VLOOKUP(R45, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T45=\"\", \"\", VLOOKUP(T45, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F46=\"\", \"\", VLOOKUP(F46, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H46=\"\", \"\", VLOOKUP(H46, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J46=\"\", \"\", VLOOKUP(J46, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P46=\"\", \"\", VLOOKUP(P46, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R46=\"\", \"\", VLOOKUP(R46, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T46=\"\", \"\", VLOOKUP(T46, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F47=\"\", \"\", VLOOKUP(F47, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H47=\"\", \"\", VLOOKUP(H47, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J47=\"\", \"\", VLOOKUP(J47, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P47=\"\", \"\", VLOOKUP(P47, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R47=\"\", \"\", VLOOKUP(R47, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T47=\"\", \"\", VLOOKUP(T47, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F48=\"\", \"\", VLOOKUP(F48, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H48=\"\", \"\", VLOOKUP(H48, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J48=\"\", \"\", VLOOKUP(J48, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P48=\"\", \"\", VLOOKUP(P48, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R48=\"\", \"\", VLOOKUP(R48, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T48=\"\", \"\", VLOOKUP(T48, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F49=\"\", \"\", VLOOKUP(F49, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H49=\"\", \"\", VLOOKUP(H49, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J49=\"\", \"\", VLOOKUP(J49, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P49=\"\", \"\", VLOOKUP(P49, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R49=\"\", \"\", VLOOKUP(R49, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T49=\"\", \"\", VLOOKUP(T49, fault[], 2, FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F50=\"\", \"\", VLOOKUP(F50, work_position[], 2, FALSE))","v":""},null,{"$f":"IF(H50=\"\", \"\", VLOOKUP(H50, gps_by[], 2, FALSE))","v":""},null,{"$f":"IF(J50=\"\", \"\", VLOOKUP(J50, gps_method_id[], 2, FALSE))","v":""},null,null,null,null,null,{"$f":"IF(P50=\"\", \"\", VLOOKUP(P50, cost_group[], 2, FALSE))","v":""},null,{"$f":"IF(R50=\"\", \"\", VLOOKUP(R50, activity[], 2, FALSE))","v":""},null,{"$f":"IF(T50=\"\", \"\", VLOOKUP(T50, fault[], 2, FALSE))","v":""}]

{"sheet":"Lookups","index":1,"n_rows":151,"n_cols":17,"rows_kept":151,"cut":false,"hidden":false,"merged":[]}
["work_position.description","work_position.code",null,"gps_method_id.description","gps_method_id.code",null,"cost_group.description","cost_group.code",null,"fault.description","fault.code",null,"activity.description","activity.code",null,"gps_by.description","gps_by.code"]
["Both sides","B",null,"Aerial photography","A",null,"Bridge Maint","BR",null,"Abandoned Vehicles","ABANVEH",null,"Audio tactile profiled marking maintenance","ATP",null,"3M","3M"]
["Centre","C",null,"Default","D",null,"Drainage","DR",null,"Uneven Abutment Join","ABUT",null,"Avalanches","AVALANCHES",null,"Automobile Association","AA"]
["Full width","F",null,"GPS device","G",null,"Environment","EN",null,"Aggregate Loss","AGGLOSS",null,"Guardrail, barrier and handrail maintenance.","BARRIER",null,"Auckland Council","ACC"]
["Left","L",null,"Click on Map","M",null,"ITS","IT",null,"Alligator Cracking","ALLIGCRK",null,"Bridge maintenance","BRIDGE",null,"Alarm Centre Installation Ltd","ACI"]
["Not Applicable","N",null,"Other","O",null,"Lighting","LI",null,"Bleeding","BLEED",null,"Camera","CAMERA",null,"Agfirst","AGF"]
["Right","R",null,"RAMM Generated","R",null,"Minor Struct","MS",null,"Blocked","BLOCKED",null,"Culvert marker post maintenance","CMPMAINT",null,"Auckland Motorway Alliance","AMA"]
[null,null,null,null,null,null,"Pavement","PA",null,"Vehicle Breakdown","BREAKDOWN",null,"Special coloured marking maintenance","COLMARK",null,"Asset Management Engineers Ltd","AME"]
[null,null,null,null,null,null,"Shoulder","SH",null,"Broken","BROKEN",null,"Communications and Transmissions","COMS",null,"Asset Management Technicians Ltd","AMT"]
[null,null,null,null,null,null,"Surfacing","SU",null,"Fault in Cable Power Supply","CABLE",null,"Concrete pavement repairs","CONCPAVE",null,"Armitage Systems","ARM"]
[null,null,null,null,null,null,"Traff Facil","TF",null,"Clean","CLEAN",null,"Crash Cushion Maintenance","CUSHION",null,"Aspect Solutions Ltd","ASL"]
[null,null,null,null,null,null,"Verge","VG",null,"CMA Dry Application (Ice/Frost)","CMADRY",null,"Device Controllers","DCON",null,"Auckland System Management","ASM"]
[null,null,null,null,null,null,null,null,null,"CMA Wet/Liquid Application (Ice/Frost)","CMAWET",null,"Digouts (all pavements)","DIGOUTS",null,"Auckland Transport","AT2"]
[null,null,null,null,null,null,null,null,null,"Collapse","COLLAPSE",null,"Electronic Barriers and Gates","EBARRIER",null,"Aspect Technology and Equipment Ltd","ATE"]
[null,null,null,null,null,null,null,null,null,"Avalanche Control","CONTROL",null,"Edge marker post maintenance","EDGEPOST",null,"ARRB Transport Research Ltd","ATR"]
[null,null,null,null,null,null,null,null,null,"Corrective Maintenance","CORRECTIVE",null,"Emergency work","EMERGENCY",null,"Auckland University","AUN"]
[null,null,null,null,null,null,null,null,null,"Corroded","CORRODE",null,"Enclosures","ENCLOSURES",null,"Broadspectrum (NZ) Ltd","B(L"]
[null,null,null,null,null,null,null,null,null,"Corrugation","CORRUG",null,"Environmental cleanup","ENVCLEAN",null,"Bri-Ken and Associates Ltd","BAA"]
[null,null,null,null,null,null,null,null,null,"Concrete Cracking","CRACK",null,"Environmental Sensors","ESENSORS",null,"Bartley Consultants Ltd","BAR"]
[null,null,null,null,null,null,null,null,null,"Vehicle Crash","CRASH",null,"Electronic Sign","ESIGN",null,"Bloxam Burnett & Olliver Ltd","BB&"]
[null,null,null,null,null,null,null,null,null,"Crash Damage","CRASHDMG",null,"Fencing repairs","FENCE",null,"Beca Infrastructure","BCF"]
[null,null,null,null,null,null,null,null,null,"Blocked Culvert","CULBLOCK",null,"Fill cracks","FILLCRK",null,"Buller District Council","BDC"]
[null,null,null,null,null,null,null,null,null,"Corroded Culvert","CULCORR",null,"Gantry Maintenance","GANTRY",null,"Blacktop","BLA"]
[null,null,null,null,null,null,null,null,null,"Culvert Defect Repair","CULREPAIR",null,"Minor levelling","LEVEL",null,"Beca Ltd.","BLT"]
[null,null,null,null,null,null,null,null,null,"Dead Tree/Limb","DEAD",null,"Maintain highway lighting","LIGHTMAINT",null,"Civil Assist Ltd","CAL"]
[null,null,null,null,null,null,null,null,null,"Remove Debris","DEBRIS",null,"LRMS sign maintenance.","LRMSMAINT",null,"Christchurch City Council","CCC"]
[null,null,null,null,null,null,null,null,null,"Minor Deck Defect Repair","DECKREP",null,"Road marking maintenance","MARKING",null,"City Care Ltd","CCL"]
[null,null,null,null,null,null,null,null,null,"Deformation","DEFORM",null,"Milling","MILLFILL",null,"Currie Electrical Ltd.","CEL"]
[null,null,null,null,null,null,null,null,null,"Depression","DEPRESS",null,"Mirror maintenance","MIRROR",null,"Company-X Ltd.","CL"]
[null,null,null,null,null,null,null,null,null,"Clear Detritus","DETRITUS",null,"Overlay","OVERLAY",null,"Critchlow Limited","CL2"]
[null,null,null,null,null,null,null,null,null,"Tunnel Drainage","DRAINAGE",null,"Positive drainage","POSDRAIN",null,"Coastline Markers Ltd","CML"]
[null,null,null,null,null,null,null,null,null,"Drainage Repairs - Rest Area","DRAINFIX",null,"Signpost and fitting maintenance.","POSTMAINT",null,"CoreLogic NZ Ltd.","CNL"]
[null,null,null,null,null,null,null,null,null,"Dropout","DROPOUT",null,"Pot-hole repairs","POTFILL",null,"Central Otago District Council","COD"]
[null,null,null,null,null,null,null,null,null,"Edge Break","EDGEBRK",null,"Power Supply","POWER",null,"Other Contractor","CON"]
[null,null,null,null,null,null,null,null,null,"Edge Rutting","EDGERUT",null,"Re-chip surfacing","RECHIP",null,"CSL Traffic","CSL"]
[null,null,null,null,null,null,null,null,null,"Culvert Entrance Repair","ENTREPAIR",null,"Rest Area maintenance","RESTAREA",null,"Connell Wagner Ltd","CWL"]
[null,null,null,null,null,null,null,null,null,"Avalanche Equipment","EQUIPMENT",null,"Rip and Remake","RIPREMAKE",null,"Dunedin City Council","DCC"]
[null,null,null,null,null,null,null,null,null,"Furniture/Facility Maintenance","FACILITIES",null,"Raised pavement marker maintenance","RPM",null,"D & L Crowe Ltd","DLC"]
[null,null,null,null,null,null,null,null,null,"Failure","FAILURE",null,"Safety Crossing maintenance","SAFETYX",null,"Spiire NZ Ltd","DWK"]
[null,null,null,null,null,null,null,null,null,"Fatigue Cracking","FATIGCK",null,"Seal cracks","SEALCRK",null,"Excell Corporation","ECL"]
[null,null,null,null,null,null,null,null,null,"Sand Filter Cleaning","FILTER",null,"Service cover adjustment","SERVCOVER",null,"Ferguson Ind","FGI"]
[null,null,null,null,null,null,null,null,null,"Flood","FLOOD",null,"Shoulder maintenance","SHLDMAINT",null,"Fulton Hogan (NZ) Ltd.","FUL"]
[null,null,null,null,null,null,null,null,null,"Flushing","FLUSH",null,"Traffic signal maintenance","SIGNALS",null,"Gisborne District Council","GDC"]
[null,null,null,null,null,null,null,null,null,"Foundation Damage","FOUNDAT",null,"Sign maintenance","SIGNMAINT",null,"Geosolve Ltd","GEO"]
[null,null,null,null,null,null,null,null,null,"Blown Fuse","FUSE",null,"Sight rail maintenance","SRAILMAINT",null,"GHD Ltd.","GHD"]
[null,null,null,null,null,null,null,null,null,"Graffiti","GRAFFITI",null,"In situ stabilisation","STAB",null,"HEB Construction Ltd","HEB"]
[null,null,null,null,null,null,null,null,null,"High Shoulder","HIGHSHLD",null,"Surface openings","SURFOPEN",null,"Higgins Contractors Ltd.","HIG"]
[null,null,null,null,null,null,null,null,null,"Potholes","HOLES",null,"Surfacing defect repairs","SURFREP",null,"HMI Technologies","HMI"]
[null,null,null,null,null,null,null,null,null,"Ice/Frost Grit Application","ICE/FROST",null,"Surface Water Channel & Side Drain Maintenance","SWCMAINT",null,"HERE New Zealand Ltd","HNZ"]
[null,null,null,null,null,null,null,null,null,"Faulty Ignitor","IGNITOR",null,"Stormwater structure maint.","SWSTRUCT",null,"HTS Group","HTS"]
[null,null,null,null,null,null,null,null,null,"Illegal Dumping","ILLEGAL",null,"Terminal end maintenance","TERMINAL",null,"Inframix Construction Ltd","IMX"]
[null,null,null,null,null,null,null,null,null,"Illegible","ILLEGIBLE",null,"Tunnels","TUNNELS",null,"Inzone","INZ"]
[null,null,null,null,null,null,null,null,null,"Inadequate","INAD",null,"Maintain unsealed pavements","UNSEALED",null,"Isaac Construction","ISC"]
[null,null,null,null,null,null,null,null,null,"Incident TTM","INCIDENT",null,"Vegetation control and maint.","VEGETATION",null,"Island Asphalts","ISL"]
[null,null,null,null,null,null,null,null,null,"Isolated Crack","ISOCRK",null,"Vehicle Sensors and Detection Processors","VEHSEN",null,"ITS","ITS"]
[null,null,null,null,null,null,null,null,null,"Joint Cracking","JOINT",null,"Retaining wall maint.","WALLS",null,"Jacobs New Zealand Ltd","JAC"]
[null,null,null,null,null,null,null,null,null,"Defective Joint","JOINTREP",null,"Waterblasting","WATERBLAST",null,"JCW Consultant","JC"]
[null,null,null,null,null,null,null,null,null,"Direct Light or Glare","LIGHTSPILL",null,"Winter maintenance","WINTER",null,"JCL Asphalt subcontractor","JCL"]
[null,null,null,null,null,null,null,null,null,"Clear Litter","LITTER",null,"Weigh Pit and HCV Facility Maintenance","WPMAINT",null,"JJ Walters","JJW"]
[null,null,null,null,null,null,null,null,null,"Livestock (Wandering on Road)","LIVESTOCK",null,null,null,null,"Johnstone & Masters Ltd","JM"]
[null,null,null,null,null,null,null,null,null,"Low Shoulder","LOWSHLD",null,null,null,null,"NZTA (JTOC)","JTO"]
[null,null,null,null,null,null,null,null,null,"Missing","MISSING",null,null,null,null,"Juno Services Ltd","JUN"]
[null,null,null,null,null,null,null,null,null,"Replace Non-Functional Asset","NONFUNCT",null,null,null,null,"Kapiti Coast District Council","KCD"]
[null,null,null,null,null,null,null,null,null,"Non-functional","NONFUNCTIO",null,null,null,null,"Kampung Consulting Ltd.","KCL"]
[null,null,null,null,null,null,null,null,null,"Remove Non-Standard Sign","NONSTD",null,null,null,null,"Kelcroft Engineering","KEL"]
[null,null,null,null,null,null,null,null,null,"Paint","PAINT",null,null,null,null,"Local Authority","LA"]
[null,null,null,null,null,null,null,null,null,"Loss of Paint Corrosion Protection","PAINTPRO",null,null,null,null,"Lonrix Ltd","LL"]
[null,null,null,null,null,null,null,null,null,"Pest Control","PEST",null,null,null,null,"McKays Consultants","MCC"]
[null,null,null,null,null,null,null,null,null,"Polished Surface","POLISHED",null,null,null,null,"Matamata-Piako District Council","MD2"]
[null,null,null,null,null,null,null,null,null,"Post Maintenance","POST",null,null,null,null,"Manawatu District Council","MDC"]
[null,null,null,null,null,null,null,null,null,"Side Rail Defective","RAILS",null,null,null,null,"McKay Electrical Ltd","MEL"]
[null,null,null,null,null,null,null,null,null,"Realign","REALIGN",null,null,null,null,"Aecom NZ Ltd","MER"]
[null,null,null,null,null,null,null,null,null,"Re-instatement","REINSTATE",null,null,null,null,"MetService","MET"]
[null,null,null,null,null,null,null,null,null,"Relocation","RELOCATE",null,null,null,null,"Marlborough NOC JV","MJV"]
[null,null,null,null,null,null,null,null,null,"Remove","REMOVE",null,null,null,null,"McKay Ltd.","ML"]
[null,null,null,null,null,null,null,null,null,"Avalanche Research","RESEARCH",null,null,null,null,"Marlborough Roads","MR"]
[null,null,null,null,null,null,null,null,null,"Rework on Previous Maintenance","REWORK",null,null,null,null,"MWH NZ Ltd.","MWH"]
[null,null,null,null,null,null,null,null,null,"Rock Fall Damage","ROCK",null,null,null,null,"Napier City Council","NCC"]
[null,null,null,null,null,null,null,null,null,"Wheelpath Rutting","RUTTING",null,null,null,null,"NZ Transport Agency - Highway Programme","NTA"]
[null,null,null,null,null,null,null,null,null,"Saturated Pavement","SATPAVE",null,null,null,null,"NZ Transport Agency - Funding","NTF"]
[null,null,null,null,null,null,null,null,null,"Scabbing or Ravelling","SCAB",null,null,null,null,"North Power","NTH"]
[null,null,null,null,null,null,null,null,null,"Scouring","SCOUR",null,null,null,null,"Nutech Security","NUT"]
[null,null,null,null,null,null,null,null,null,"2nd Coat","SECONDCOAT",null,null,null,null,"Odyssey Energy (2009) Ltd.","OE("]
[null,null,null,null,null,null,null,null,null,"Poor Cross-Section Shape","SHAPE",null,null,null,null,"Opus International Consultants Ltd (NZ)","OI2"]
[null,null,null,null,null,null,null,null,null,"Clear and Regrade Side Drain","SIDEGRADE",null,null,null,null,"Opus International Consultants Ltd.","OIC"]
[null,null,null,null,null,null,null,null,null,"Remove Landslip Debris","SLIP",null,null,null,null,"Oldfields","OLD"]
[null,null,null,null,null,null,null,null,null,"Slippage Crack","SLIPCRK",null,null,null,null,"Porirua City Council","PCC"]
[null,null,null,null,null,null,null,null,null,"Snow Removal (Mechanical)","SNOW",null,null,null,null,"Pinnacles Civil Group Ltd.","PCG"]
[null,null,null,null,null,null,null,null,null,"Soft Shoulder","SOFTSHLD",null,null,null,null,"Pope Electrical Ltd","PE2"]
[null,null,null,null,null,null,null,null,null,"Selfsown Trees","SOWN",null,null,null,null,"Pope Electrical Limited","PEL"]
[null,null,null,null,null,null,null,null,null,"Spalling","SPALL",null,null,null,null,"Pavement Management Services","PMS"]
[null,null,null,null,null,null,null,null,null,"Spillage","SPILLAGE",null,null,null,null,"Power Solutions Ltd","PSL"]
[null,null,null,null,null,null,null,null,null,"Stripping","STRIP",null,null,null,null,"Queenstown-Lakes District Council","QDC"]
[null,null,null,null,null,null,null,null,null,"Maintain Structural Members","STRUCTMEM",null,null,null,null,"Quality Roading and Services","QRS"]
[null,null,null,null,null,null,null,null,null,"Inadequate Sub-Surface Drain","SUBINAD",null,null,null,null,"Read-only access for Tenderers","RAF"]
[null,null,null,null,null,null,null,null,null,"Subsidence","SUBSIDE",null,null,null,null,"Rangitikei District Council","RDC"]
[null,null,null,null,null,null,null,null,null,"Loss of Texture","TEXTURE",null,null,null,null,"Roadex","RDX"]
[null,null,null,null,null,null,null,null,null,"Theft","THEFT",null,null,null,null,"Roading Logistics Ltd","RLL"]
[null,null,null,null,null,null,null,null,null,"Cable/Bolt Tightening","TIGHT",null,null,null,null,"Rationale Ltd","RLT"]
[null,null,null,null,null,null,null,null,null,"Defective Timber Deck","TIMBERDECK",null,null,null,null,"Rotorua District Council","ROT"]
[null,null,null,null,null,null,null,null,null,"Torque setting","TORQUE",null,null,null,null,"RAMM Software Limited","RSL"]
[null,null,null,null,null,null,null,null,null,"Removal of Fallen Trees","TREEFALL",null,null,null,null,"Road Signs & Traffic Control Equipment Limited","RTL"]
[null,null,null,null,null,null,null,null,null,"Trench Settlement","TRENCH",null,null,null,null,"Russell Roads","RUS"]
[null,null,null,null,null,null,null,null,null,"Uneven Surface","UNEVEN",null,null,null,null,"Salient Consultants","SAL"]
[null,null,null,null,null,null,null,null,null,"Pot hole repair (unsealed road)","UNSL-HOLES",null,null,null,null,"Sealcoat Central Ltd.","SCL"]
[null,null,null,null,null,null,null,null,null,"Repair or Replace (Due to Vandalism)","VANDALISM",null,null,null,null,"Shaw's Consulting Services Ltd","SCS"]
[null,null,null,null,null,null,null,null,null,"Vegetation Control Type 1","VEGCNTRL1",null,null,null,null,"Southland District Council","SDC"]
[null,null,null,null,null,null,null,null,null,"Vegetation Control Type 2","VEGCNTRL2",null,null,null,null,"Signopsys Electronic Signs","SES"]
[null,null,null,null,null,null,null,null,null,"Vegetation Control Type 3","VEGCNTRL3",null,null,null,null,"Sicon Ltd.","SL2"]
[null,null,null,null,null,null,null,null,null,"Vegetation Control Type 4","VEGCNTRL4",null,null,null,null,"Stantec New Zealand","SN2"]
[null,null,null,null,null,null,null,null,null,"Vegetation Control Type 4A","VEGCNTRL4A",null,null,null,null,"Stantec New Zealand Ltd","SNZ"]
[null,null,null,null,null,null,null,null,null,"Vegetation Control Type 5","VEGCNTRL5",null,null,null,null,"SouthRoads Ltd.","SOU"]
[null,null,null,null,null,null,null,null,null,"Vegetation Control Type 6","VEGCNTRL6",null,null,null,null,"Safe Roads Alliance","SRA"]
[null,null,null,null,null,null,null,null,null,"Vegetation Control Type 7","VEGCNTRL7",null,null,null,null,"Services South East (NZ) Ltd.","SS2"]
[null,null,null,null,null,null,null,null,null,"Vegetation Control Type 8","VEGCNTRL8",null,null,null,null,"Services South East Pty Ltd","SSE"]
[null,null,null,null,null,null,null,null,null,"Waterway Restriction","WATERWAY",null,null,null,null,"Tonkin & Taylor Ltd","T&T"]
[null,null,null,null,null,null,null,null,null,"Weigh Pit Equipment","WEIGHPIT",null,null,null,null,"Tasman Howey","TAS"]
[null,null,null,null,null,null,null,null,null,"Rewiring of column","WIRE",null,null,null,null,"NZTA and WDM","TAW"]
[null,null,null,null,null,null,null,null,null,"Worn or degraded","WORN",null,null,null,null,"Tauranga City Council","TC2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taranaki Civil Construction","TCC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC Nicholls","TCN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traffic Control Systems","TCS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taupo District Council","TD2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tasman District Council","TDC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Datastack Ltd","TDL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taupo East Traffic Services Contractor","TET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Broadspectrum (NZ) Ltd","TFD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waka Kotahi NZ Transport Agency","TNZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Top Energy","TOP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Roading Company","TRC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transfield Services (NZ) Ltd","TS("]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tonkin and Taylor Ltd","TT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tyco Traffic and Transportation","TYC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urban Connection Ltd","UCL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"University of Canterbury","UOC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ventia Pty Ltd","VPL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Bay of Plenty District Council","WBO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wellington City Council","WCC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waimakariri District Council","WD2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whakatane District Council","WD3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wairoa District Council","WD4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waipa District Council","WD5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waikato District Council","WD6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whangarei District Council","WDC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WDM","WDM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WSP-Opus International Consultants Ltd","WIC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downer New Zealand Limited","WIL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W J Ashton Service Ltd","WJA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waka Kotahi NZ Transport Agency - Highways","WK2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waka Kotahi NZ Transport Agency","WKN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WSP New Zealand Ltd","WNZ"]