{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["RetainingWall","Lookups"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":28,"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":"RetainingWall","index":0,"n_rows":48,"n_cols":43,"rows_kept":48,"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","c22a2b68-2a19-4b7d-980c-ee3c45dfc76b_ret_wall_type_desc","c22a2b68-2a19-4b7d-980c-ee3c45dfc76b_ret_wall_type","06f91608-aad0-451d-aae0-fcbc3f9f4770_ms_material_desc","06f91608-aad0-451d-aae0-fcbc3f9f4770_ms_material","12232993-358a-4ac1-864a-3872d5d94cdd_length_adjust_m","b20f491b-149d-4a4f-ab54-191331f4911a_len_adjust_rsn_desc","b20f491b-149d-4a4f-ab54-191331f4911a_len_adjust_rsn","b27d50bf-d31d-4784-84c5-77b5fa7fb7b0_length_m","9c82976b-fefc-4ee4-b957-6ef6af5abf9e_side_desc","9c82976b-fefc-4ee4-b957-6ef6af5abf9e_side","dc018159-a9c2-4d04-bc77-ba357e039841_offset","d6b3477e-3381-401c-a795-a9e73d01ffc8_height_m_avg","6309c739-6358-45c0-a7cc-e1ac32626c57_constructed","2f2d6900-03be-410f-8477-aff6f84cd71e_asset_owner_desc","2f2d6900-03be-410f-8477-aff6f84cd71e_asset_owner","36c2c68d-008d-47c8-92ed-3ef2df5ed4e8_risk_likelihood_desc","36c2c68d-008d-47c8-92ed-3ef2df5ed4e8_risk_likelihood","dfc17509-c70e-4807-bc2f-b750ec5dc27c_risk_consequence_desc","dfc17509-c70e-4807-bc2f-b750ec5dc27c_risk_consequence","c1596592-c257-43dc-ad9a-3c9cb6794bc5_risk_desc","c1596592-c257-43dc-ad9a-3c9cb6794bc5_risk","5582dc0b-e348-46f0-be38-1cdc3d4cd657_rul_reset_desc","5582dc0b-e348-46f0-be38-1cdc3d4cd657_rul_reset","cd18eeea-4a09-4657-936a-d7da8d914b6b_use_default_rc_desc","cd18eeea-4a09-4657-936a-d7da8d914b6b_use_default_rc","29b59ca2-2400-4086-9308-c1d5cd37febe_condition_desc","29b59ca2-2400-4086-9308-c1d5cd37febe_condition","0fe8f557-a8a6-4e1c-a391-d4c891cc176f_condition_date","321d9ef0-f6a5-4685-a7f8-6da0dcaf7367_collect_name_desc","321d9ef0-f6a5-4685-a7f8-6da0dcaf7367_collect_name","e3a76ade-c2a4-409d-80cd-9139fecb4104_retaining_wall_id","20cc5794-7905-49ee-9fff-4d90c0d12721_notes","3d4063dc-3232-442d-97e0-02b1ff393b9d_not_ramm_field_in_replace_reason_desc","3d4063dc-3232-442d-97e0-02b1ff393b9d_not_ramm_field_in_replace_reason","854ba16e-caa7-48a5-9c2f-275b80a29410_not_ramm_field_prior_id","56c36f87-5b20-4091-a896-9326d8958303_not_ramm_field_replace_date","14106791-fbdb-4c63-b245-4fe6dfd51129_not_ramm_field_rep_replace_reason_desc","14106791-fbdb-4c63-b245-4fe6dfd51129_not_ramm_field_rep_replace_reason"]
["road_id","road_id","sh-rs-d","start_m","end_m","ret_wall_type_desc","ret_wall_type","ms_material_desc","ms_material","length_adjust_m","len_adjust_rsn_desc","len_adjust_rsn","length_m","side_desc","side","offset","height_m_avg","constructed","asset_owner_desc","asset_owner","risk_likelihood_desc","risk_likelihood","risk_consequence_desc","risk_consequence","risk_desc","risk","rul_reset_desc","rul_reset","use_default_rc_desc","use_default_rc","condition_desc","condition","condition_date","collect_name_desc","collect_name","retaining_wall_id","notes","not_ramm_field_in_replace_reason_desc","not_ramm_field_in_replace_reason","not_ramm_field_prior_id","not_ramm_field_replace_date","not_ramm_field_rep_replace_reason_desc","not_ramm_field_rep_replace_reason"]
["Start Road Id ","End Road  Id","SH-RS-D  (e.g. 016-0000-B) letter must be uppercase","Start RP","End RP","Type Description","Type","Material Description","Material","Extra Length (m) - must set 0 if no extra length","Extra Length Reason Description","Extra Length Reason","Length","Side Description","Side","Offset","Height (m)","Construction date (dd/mm/yyyy) Must include leading 0","Asset Owner Description","Asset Owner","Risk Likelihood Description","Risk Likelihood","Risk Consequence Description","Risk Consequence","Risk Description","Risk","RUL Reset Description","RUL Reset","Use Default RC Description","Use Default RC","Condition Description","Condition","Condition Date (dd/mm/yyyy) Must include leading 0","Organisation Description","Organisation","Retaining Wall ID","Comments (if required)","Install Reason Description","Install Reason","Prior Id","Existing Asset - Replace Date (dd/mm/yyyy) Must include leading 0","Existing Asset - Replace Reason Description","Existing Asset - Replace Reason"]
[{"$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,type[],2,FALSE))","v":""},null,{"$f":"IF(H4=\"\",\"\",VLOOKUP(H4,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K4=\"\",\"\",VLOOKUP(K4,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N4=\"\",\"\",VLOOKUP(N4,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S4=\"\",\"\",VLOOKUP(S4,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U4=\"\",\"\",VLOOKUP(U4,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W4=\"\",\"\",VLOOKUP(W4,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y4=\"\",\"\",VLOOKUP(Y4,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA4=\"\",\"\",VLOOKUP(AA4,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC4=\"\",\"\",VLOOKUP(AC4,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE4=\"\",\"\",VLOOKUP(AE4,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH4=\"\",\"\",VLOOKUP(AH4,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL4=\"\",\"\",VLOOKUP(AL4,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP4=\"\",\"\",VLOOKUP(AP4,replace_reason[],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,type[],2,FALSE))","v":""},null,{"$f":"IF(H5=\"\",\"\",VLOOKUP(H5,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K5=\"\",\"\",VLOOKUP(K5,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N5=\"\",\"\",VLOOKUP(N5,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S5=\"\",\"\",VLOOKUP(S5,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U5=\"\",\"\",VLOOKUP(U5,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W5=\"\",\"\",VLOOKUP(W5,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y5=\"\",\"\",VLOOKUP(Y5,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA5=\"\",\"\",VLOOKUP(AA5,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC5=\"\",\"\",VLOOKUP(AC5,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE5=\"\",\"\",VLOOKUP(AE5,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH5=\"\",\"\",VLOOKUP(AH5,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL5=\"\",\"\",VLOOKUP(AL5,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP5=\"\",\"\",VLOOKUP(AP5,replace_reason[],2,FALSE))","v":""}]
["null",{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&C6&\"/\"&E6&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,{"$f":"IF(F6=\"\",\"\",VLOOKUP(F6,type[],2,FALSE))","v":""},null,{"$f":"IF(H6=\"\",\"\",VLOOKUP(H6,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K6=\"\",\"\",VLOOKUP(K6,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N6=\"\",\"\",VLOOKUP(N6,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S6=\"\",\"\",VLOOKUP(S6,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U6=\"\",\"\",VLOOKUP(U6,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W6=\"\",\"\",VLOOKUP(W6,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y6=\"\",\"\",VLOOKUP(Y6,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA6=\"\",\"\",VLOOKUP(AA6,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE6=\"\",\"\",VLOOKUP(AE6,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH6=\"\",\"\",VLOOKUP(AH6,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL6=\"\",\"\",VLOOKUP(AL6,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP6=\"\",\"\",VLOOKUP(AP6,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F7=\"\",\"\",VLOOKUP(F7,type[],2,FALSE))","v":""},null,{"$f":"IF(H7=\"\",\"\",VLOOKUP(H7,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K7=\"\",\"\",VLOOKUP(K7,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N7=\"\",\"\",VLOOKUP(N7,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S7=\"\",\"\",VLOOKUP(S7,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U7=\"\",\"\",VLOOKUP(U7,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W7=\"\",\"\",VLOOKUP(W7,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y7=\"\",\"\",VLOOKUP(Y7,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA7=\"\",\"\",VLOOKUP(AA7,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC7=\"\",\"\",VLOOKUP(AC7,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE7=\"\",\"\",VLOOKUP(AE7,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH7=\"\",\"\",VLOOKUP(AH7,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL7=\"\",\"\",VLOOKUP(AL7,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP7=\"\",\"\",VLOOKUP(AP7,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F8=\"\",\"\",VLOOKUP(F8,type[],2,FALSE))","v":""},null,{"$f":"IF(H8=\"\",\"\",VLOOKUP(H8,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K8=\"\",\"\",VLOOKUP(K8,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N8=\"\",\"\",VLOOKUP(N8,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S8=\"\",\"\",VLOOKUP(S8,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U8=\"\",\"\",VLOOKUP(U8,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W8=\"\",\"\",VLOOKUP(W8,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y8=\"\",\"\",VLOOKUP(Y8,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA8=\"\",\"\",VLOOKUP(AA8,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC8=\"\",\"\",VLOOKUP(AC8,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE8=\"\",\"\",VLOOKUP(AE8,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH8=\"\",\"\",VLOOKUP(AH8,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL8=\"\",\"\",VLOOKUP(AL8,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP8=\"\",\"\",VLOOKUP(AP8,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F9=\"\",\"\",VLOOKUP(F9,type[],2,FALSE))","v":""},null,{"$f":"IF(H9=\"\",\"\",VLOOKUP(H9,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K9=\"\",\"\",VLOOKUP(K9,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N9=\"\",\"\",VLOOKUP(N9,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S9=\"\",\"\",VLOOKUP(S9,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U9=\"\",\"\",VLOOKUP(U9,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W9=\"\",\"\",VLOOKUP(W9,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y9=\"\",\"\",VLOOKUP(Y9,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA9=\"\",\"\",VLOOKUP(AA9,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC9=\"\",\"\",VLOOKUP(AC9,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE9=\"\",\"\",VLOOKUP(AE9,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH9=\"\",\"\",VLOOKUP(AH9,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL9=\"\",\"\",VLOOKUP(AL9,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP9=\"\",\"\",VLOOKUP(AP9,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F10=\"\",\"\",VLOOKUP(F10,type[],2,FALSE))","v":""},null,{"$f":"IF(H10=\"\",\"\",VLOOKUP(H10,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K10=\"\",\"\",VLOOKUP(K10,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N10=\"\",\"\",VLOOKUP(N10,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S10=\"\",\"\",VLOOKUP(S10,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U10=\"\",\"\",VLOOKUP(U10,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W10=\"\",\"\",VLOOKUP(W10,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y10=\"\",\"\",VLOOKUP(Y10,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA10=\"\",\"\",VLOOKUP(AA10,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC10=\"\",\"\",VLOOKUP(AC10,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE10=\"\",\"\",VLOOKUP(AE10,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH10=\"\",\"\",VLOOKUP(AH10,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL10=\"\",\"\",VLOOKUP(AL10,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP10=\"\",\"\",VLOOKUP(AP10,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F11=\"\",\"\",VLOOKUP(F11,type[],2,FALSE))","v":""},null,{"$f":"IF(H11=\"\",\"\",VLOOKUP(H11,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K11=\"\",\"\",VLOOKUP(K11,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N11=\"\",\"\",VLOOKUP(N11,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S11=\"\",\"\",VLOOKUP(S11,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U11=\"\",\"\",VLOOKUP(U11,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W11=\"\",\"\",VLOOKUP(W11,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y11=\"\",\"\",VLOOKUP(Y11,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA11=\"\",\"\",VLOOKUP(AA11,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC11=\"\",\"\",VLOOKUP(AC11,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE11=\"\",\"\",VLOOKUP(AE11,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH11=\"\",\"\",VLOOKUP(AH11,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL11=\"\",\"\",VLOOKUP(AL11,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP11=\"\",\"\",VLOOKUP(AP11,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F12=\"\",\"\",VLOOKUP(F12,type[],2,FALSE))","v":""},null,{"$f":"IF(H12=\"\",\"\",VLOOKUP(H12,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K12=\"\",\"\",VLOOKUP(K12,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N12=\"\",\"\",VLOOKUP(N12,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S12=\"\",\"\",VLOOKUP(S12,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U12=\"\",\"\",VLOOKUP(U12,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W12=\"\",\"\",VLOOKUP(W12,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y12=\"\",\"\",VLOOKUP(Y12,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA12=\"\",\"\",VLOOKUP(AA12,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC12=\"\",\"\",VLOOKUP(AC12,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE12=\"\",\"\",VLOOKUP(AE12,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH12=\"\",\"\",VLOOKUP(AH12,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL12=\"\",\"\",VLOOKUP(AL12,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP12=\"\",\"\",VLOOKUP(AP12,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F13=\"\",\"\",VLOOKUP(F13,type[],2,FALSE))","v":""},null,{"$f":"IF(H13=\"\",\"\",VLOOKUP(H13,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K13=\"\",\"\",VLOOKUP(K13,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N13=\"\",\"\",VLOOKUP(N13,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S13=\"\",\"\",VLOOKUP(S13,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U13=\"\",\"\",VLOOKUP(U13,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W13=\"\",\"\",VLOOKUP(W13,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y13=\"\",\"\",VLOOKUP(Y13,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA13=\"\",\"\",VLOOKUP(AA13,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC13=\"\",\"\",VLOOKUP(AC13,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE13=\"\",\"\",VLOOKUP(AE13,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH13=\"\",\"\",VLOOKUP(AH13,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL13=\"\",\"\",VLOOKUP(AL13,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP13=\"\",\"\",VLOOKUP(AP13,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F14=\"\",\"\",VLOOKUP(F14,type[],2,FALSE))","v":""},null,{"$f":"IF(H14=\"\",\"\",VLOOKUP(H14,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K14=\"\",\"\",VLOOKUP(K14,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N14=\"\",\"\",VLOOKUP(N14,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S14=\"\",\"\",VLOOKUP(S14,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U14=\"\",\"\",VLOOKUP(U14,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W14=\"\",\"\",VLOOKUP(W14,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y14=\"\",\"\",VLOOKUP(Y14,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA14=\"\",\"\",VLOOKUP(AA14,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC14=\"\",\"\",VLOOKUP(AC14,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE14=\"\",\"\",VLOOKUP(AE14,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH14=\"\",\"\",VLOOKUP(AH14,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL14=\"\",\"\",VLOOKUP(AL14,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP14=\"\",\"\",VLOOKUP(AP14,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F15=\"\",\"\",VLOOKUP(F15,type[],2,FALSE))","v":""},null,{"$f":"IF(H15=\"\",\"\",VLOOKUP(H15,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K15=\"\",\"\",VLOOKUP(K15,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N15=\"\",\"\",VLOOKUP(N15,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S15=\"\",\"\",VLOOKUP(S15,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U15=\"\",\"\",VLOOKUP(U15,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W15=\"\",\"\",VLOOKUP(W15,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y15=\"\",\"\",VLOOKUP(Y15,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA15=\"\",\"\",VLOOKUP(AA15,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC15=\"\",\"\",VLOOKUP(AC15,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE15=\"\",\"\",VLOOKUP(AE15,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH15=\"\",\"\",VLOOKUP(AH15,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL15=\"\",\"\",VLOOKUP(AL15,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP15=\"\",\"\",VLOOKUP(AP15,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F16=\"\",\"\",VLOOKUP(F16,type[],2,FALSE))","v":""},null,{"$f":"IF(H16=\"\",\"\",VLOOKUP(H16,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K16=\"\",\"\",VLOOKUP(K16,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N16=\"\",\"\",VLOOKUP(N16,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S16=\"\",\"\",VLOOKUP(S16,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U16=\"\",\"\",VLOOKUP(U16,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W16=\"\",\"\",VLOOKUP(W16,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y16=\"\",\"\",VLOOKUP(Y16,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA16=\"\",\"\",VLOOKUP(AA16,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC16=\"\",\"\",VLOOKUP(AC16,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE16=\"\",\"\",VLOOKUP(AE16,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH16=\"\",\"\",VLOOKUP(AH16,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL16=\"\",\"\",VLOOKUP(AL16,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP16=\"\",\"\",VLOOKUP(AP16,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F17=\"\",\"\",VLOOKUP(F17,type[],2,FALSE))","v":""},null,{"$f":"IF(H17=\"\",\"\",VLOOKUP(H17,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K17=\"\",\"\",VLOOKUP(K17,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N17=\"\",\"\",VLOOKUP(N17,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S17=\"\",\"\",VLOOKUP(S17,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U17=\"\",\"\",VLOOKUP(U17,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W17=\"\",\"\",VLOOKUP(W17,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y17=\"\",\"\",VLOOKUP(Y17,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA17=\"\",\"\",VLOOKUP(AA17,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC17=\"\",\"\",VLOOKUP(AC17,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE17=\"\",\"\",VLOOKUP(AE17,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH17=\"\",\"\",VLOOKUP(AH17,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL17=\"\",\"\",VLOOKUP(AL17,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP17=\"\",\"\",VLOOKUP(AP17,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F18=\"\",\"\",VLOOKUP(F18,type[],2,FALSE))","v":""},null,{"$f":"IF(H18=\"\",\"\",VLOOKUP(H18,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K18=\"\",\"\",VLOOKUP(K18,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N18=\"\",\"\",VLOOKUP(N18,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S18=\"\",\"\",VLOOKUP(S18,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U18=\"\",\"\",VLOOKUP(U18,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W18=\"\",\"\",VLOOKUP(W18,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y18=\"\",\"\",VLOOKUP(Y18,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA18=\"\",\"\",VLOOKUP(AA18,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC18=\"\",\"\",VLOOKUP(AC18,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE18=\"\",\"\",VLOOKUP(AE18,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH18=\"\",\"\",VLOOKUP(AH18,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL18=\"\",\"\",VLOOKUP(AL18,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP18=\"\",\"\",VLOOKUP(AP18,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F19=\"\",\"\",VLOOKUP(F19,type[],2,FALSE))","v":""},null,{"$f":"IF(H19=\"\",\"\",VLOOKUP(H19,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K19=\"\",\"\",VLOOKUP(K19,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N19=\"\",\"\",VLOOKUP(N19,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S19=\"\",\"\",VLOOKUP(S19,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U19=\"\",\"\",VLOOKUP(U19,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W19=\"\",\"\",VLOOKUP(W19,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y19=\"\",\"\",VLOOKUP(Y19,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA19=\"\",\"\",VLOOKUP(AA19,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC19=\"\",\"\",VLOOKUP(AC19,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE19=\"\",\"\",VLOOKUP(AE19,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH19=\"\",\"\",VLOOKUP(AH19,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL19=\"\",\"\",VLOOKUP(AL19,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP19=\"\",\"\",VLOOKUP(AP19,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F20=\"\",\"\",VLOOKUP(F20,type[],2,FALSE))","v":""},null,{"$f":"IF(H20=\"\",\"\",VLOOKUP(H20,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K20=\"\",\"\",VLOOKUP(K20,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N20=\"\",\"\",VLOOKUP(N20,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S20=\"\",\"\",VLOOKUP(S20,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U20=\"\",\"\",VLOOKUP(U20,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W20=\"\",\"\",VLOOKUP(W20,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y20=\"\",\"\",VLOOKUP(Y20,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA20=\"\",\"\",VLOOKUP(AA20,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC20=\"\",\"\",VLOOKUP(AC20,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE20=\"\",\"\",VLOOKUP(AE20,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH20=\"\",\"\",VLOOKUP(AH20,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL20=\"\",\"\",VLOOKUP(AL20,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP20=\"\",\"\",VLOOKUP(AP20,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F21=\"\",\"\",VLOOKUP(F21,type[],2,FALSE))","v":""},null,{"$f":"IF(H21=\"\",\"\",VLOOKUP(H21,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K21=\"\",\"\",VLOOKUP(K21,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N21=\"\",\"\",VLOOKUP(N21,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S21=\"\",\"\",VLOOKUP(S21,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U21=\"\",\"\",VLOOKUP(U21,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W21=\"\",\"\",VLOOKUP(W21,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y21=\"\",\"\",VLOOKUP(Y21,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA21=\"\",\"\",VLOOKUP(AA21,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC21=\"\",\"\",VLOOKUP(AC21,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE21=\"\",\"\",VLOOKUP(AE21,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH21=\"\",\"\",VLOOKUP(AH21,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL21=\"\",\"\",VLOOKUP(AL21,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP21=\"\",\"\",VLOOKUP(AP21,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F22=\"\",\"\",VLOOKUP(F22,type[],2,FALSE))","v":""},null,{"$f":"IF(H22=\"\",\"\",VLOOKUP(H22,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K22=\"\",\"\",VLOOKUP(K22,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N22=\"\",\"\",VLOOKUP(N22,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S22=\"\",\"\",VLOOKUP(S22,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U22=\"\",\"\",VLOOKUP(U22,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W22=\"\",\"\",VLOOKUP(W22,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y22=\"\",\"\",VLOOKUP(Y22,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA22=\"\",\"\",VLOOKUP(AA22,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC22=\"\",\"\",VLOOKUP(AC22,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE22=\"\",\"\",VLOOKUP(AE22,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH22=\"\",\"\",VLOOKUP(AH22,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL22=\"\",\"\",VLOOKUP(AL22,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP22=\"\",\"\",VLOOKUP(AP22,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F23=\"\",\"\",VLOOKUP(F23,type[],2,FALSE))","v":""},null,{"$f":"IF(H23=\"\",\"\",VLOOKUP(H23,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K23=\"\",\"\",VLOOKUP(K23,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N23=\"\",\"\",VLOOKUP(N23,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S23=\"\",\"\",VLOOKUP(S23,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U23=\"\",\"\",VLOOKUP(U23,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W23=\"\",\"\",VLOOKUP(W23,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y23=\"\",\"\",VLOOKUP(Y23,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA23=\"\",\"\",VLOOKUP(AA23,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC23=\"\",\"\",VLOOKUP(AC23,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE23=\"\",\"\",VLOOKUP(AE23,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH23=\"\",\"\",VLOOKUP(AH23,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL23=\"\",\"\",VLOOKUP(AL23,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP23=\"\",\"\",VLOOKUP(AP23,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F24=\"\",\"\",VLOOKUP(F24,type[],2,FALSE))","v":""},null,{"$f":"IF(H24=\"\",\"\",VLOOKUP(H24,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K24=\"\",\"\",VLOOKUP(K24,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N24=\"\",\"\",VLOOKUP(N24,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S24=\"\",\"\",VLOOKUP(S24,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U24=\"\",\"\",VLOOKUP(U24,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W24=\"\",\"\",VLOOKUP(W24,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y24=\"\",\"\",VLOOKUP(Y24,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA24=\"\",\"\",VLOOKUP(AA24,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC24=\"\",\"\",VLOOKUP(AC24,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE24=\"\",\"\",VLOOKUP(AE24,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH24=\"\",\"\",VLOOKUP(AH24,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL24=\"\",\"\",VLOOKUP(AL24,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP24=\"\",\"\",VLOOKUP(AP24,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F25=\"\",\"\",VLOOKUP(F25,type[],2,FALSE))","v":""},null,{"$f":"IF(H25=\"\",\"\",VLOOKUP(H25,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K25=\"\",\"\",VLOOKUP(K25,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N25=\"\",\"\",VLOOKUP(N25,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S25=\"\",\"\",VLOOKUP(S25,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U25=\"\",\"\",VLOOKUP(U25,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W25=\"\",\"\",VLOOKUP(W25,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y25=\"\",\"\",VLOOKUP(Y25,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA25=\"\",\"\",VLOOKUP(AA25,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC25=\"\",\"\",VLOOKUP(AC25,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE25=\"\",\"\",VLOOKUP(AE25,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH25=\"\",\"\",VLOOKUP(AH25,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL25=\"\",\"\",VLOOKUP(AL25,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP25=\"\",\"\",VLOOKUP(AP25,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F26=\"\",\"\",VLOOKUP(F26,type[],2,FALSE))","v":""},null,{"$f":"IF(H26=\"\",\"\",VLOOKUP(H26,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K26=\"\",\"\",VLOOKUP(K26,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N26=\"\",\"\",VLOOKUP(N26,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S26=\"\",\"\",VLOOKUP(S26,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U26=\"\",\"\",VLOOKUP(U26,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W26=\"\",\"\",VLOOKUP(W26,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y26=\"\",\"\",VLOOKUP(Y26,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA26=\"\",\"\",VLOOKUP(AA26,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC26=\"\",\"\",VLOOKUP(AC26,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE26=\"\",\"\",VLOOKUP(AE26,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH26=\"\",\"\",VLOOKUP(AH26,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL26=\"\",\"\",VLOOKUP(AL26,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP26=\"\",\"\",VLOOKUP(AP26,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F27=\"\",\"\",VLOOKUP(F27,type[],2,FALSE))","v":""},null,{"$f":"IF(H27=\"\",\"\",VLOOKUP(H27,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K27=\"\",\"\",VLOOKUP(K27,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N27=\"\",\"\",VLOOKUP(N27,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S27=\"\",\"\",VLOOKUP(S27,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U27=\"\",\"\",VLOOKUP(U27,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W27=\"\",\"\",VLOOKUP(W27,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y27=\"\",\"\",VLOOKUP(Y27,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA27=\"\",\"\",VLOOKUP(AA27,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC27=\"\",\"\",VLOOKUP(AC27,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE27=\"\",\"\",VLOOKUP(AE27,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH27=\"\",\"\",VLOOKUP(AH27,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL27=\"\",\"\",VLOOKUP(AL27,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP27=\"\",\"\",VLOOKUP(AP27,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F28=\"\",\"\",VLOOKUP(F28,type[],2,FALSE))","v":""},null,{"$f":"IF(H28=\"\",\"\",VLOOKUP(H28,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K28=\"\",\"\",VLOOKUP(K28,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N28=\"\",\"\",VLOOKUP(N28,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S28=\"\",\"\",VLOOKUP(S28,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U28=\"\",\"\",VLOOKUP(U28,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W28=\"\",\"\",VLOOKUP(W28,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y28=\"\",\"\",VLOOKUP(Y28,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA28=\"\",\"\",VLOOKUP(AA28,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC28=\"\",\"\",VLOOKUP(AC28,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE28=\"\",\"\",VLOOKUP(AE28,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH28=\"\",\"\",VLOOKUP(AH28,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL28=\"\",\"\",VLOOKUP(AL28,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP28=\"\",\"\",VLOOKUP(AP28,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F29=\"\",\"\",VLOOKUP(F29,type[],2,FALSE))","v":""},null,{"$f":"IF(H29=\"\",\"\",VLOOKUP(H29,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K29=\"\",\"\",VLOOKUP(K29,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N29=\"\",\"\",VLOOKUP(N29,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S29=\"\",\"\",VLOOKUP(S29,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U29=\"\",\"\",VLOOKUP(U29,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W29=\"\",\"\",VLOOKUP(W29,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y29=\"\",\"\",VLOOKUP(Y29,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA29=\"\",\"\",VLOOKUP(AA29,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC29=\"\",\"\",VLOOKUP(AC29,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE29=\"\",\"\",VLOOKUP(AE29,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH29=\"\",\"\",VLOOKUP(AH29,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL29=\"\",\"\",VLOOKUP(AL29,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP29=\"\",\"\",VLOOKUP(AP29,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F30=\"\",\"\",VLOOKUP(F30,type[],2,FALSE))","v":""},null,{"$f":"IF(H30=\"\",\"\",VLOOKUP(H30,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K30=\"\",\"\",VLOOKUP(K30,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N30=\"\",\"\",VLOOKUP(N30,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S30=\"\",\"\",VLOOKUP(S30,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U30=\"\",\"\",VLOOKUP(U30,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W30=\"\",\"\",VLOOKUP(W30,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y30=\"\",\"\",VLOOKUP(Y30,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA30=\"\",\"\",VLOOKUP(AA30,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC30=\"\",\"\",VLOOKUP(AC30,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE30=\"\",\"\",VLOOKUP(AE30,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH30=\"\",\"\",VLOOKUP(AH30,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL30=\"\",\"\",VLOOKUP(AL30,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP30=\"\",\"\",VLOOKUP(AP30,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F31=\"\",\"\",VLOOKUP(F31,type[],2,FALSE))","v":""},null,{"$f":"IF(H31=\"\",\"\",VLOOKUP(H31,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K31=\"\",\"\",VLOOKUP(K31,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N31=\"\",\"\",VLOOKUP(N31,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S31=\"\",\"\",VLOOKUP(S31,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U31=\"\",\"\",VLOOKUP(U31,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W31=\"\",\"\",VLOOKUP(W31,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y31=\"\",\"\",VLOOKUP(Y31,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA31=\"\",\"\",VLOOKUP(AA31,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC31=\"\",\"\",VLOOKUP(AC31,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE31=\"\",\"\",VLOOKUP(AE31,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH31=\"\",\"\",VLOOKUP(AH31,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL31=\"\",\"\",VLOOKUP(AL31,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP31=\"\",\"\",VLOOKUP(AP31,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F32=\"\",\"\",VLOOKUP(F32,type[],2,FALSE))","v":""},null,{"$f":"IF(H32=\"\",\"\",VLOOKUP(H32,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K32=\"\",\"\",VLOOKUP(K32,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N32=\"\",\"\",VLOOKUP(N32,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S32=\"\",\"\",VLOOKUP(S32,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U32=\"\",\"\",VLOOKUP(U32,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W32=\"\",\"\",VLOOKUP(W32,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y32=\"\",\"\",VLOOKUP(Y32,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA32=\"\",\"\",VLOOKUP(AA32,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC32=\"\",\"\",VLOOKUP(AC32,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE32=\"\",\"\",VLOOKUP(AE32,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH32=\"\",\"\",VLOOKUP(AH32,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL32=\"\",\"\",VLOOKUP(AL32,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP32=\"\",\"\",VLOOKUP(AP32,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F33=\"\",\"\",VLOOKUP(F33,type[],2,FALSE))","v":""},null,{"$f":"IF(H33=\"\",\"\",VLOOKUP(H33,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K33=\"\",\"\",VLOOKUP(K33,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N33=\"\",\"\",VLOOKUP(N33,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S33=\"\",\"\",VLOOKUP(S33,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U33=\"\",\"\",VLOOKUP(U33,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W33=\"\",\"\",VLOOKUP(W33,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y33=\"\",\"\",VLOOKUP(Y33,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA33=\"\",\"\",VLOOKUP(AA33,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC33=\"\",\"\",VLOOKUP(AC33,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE33=\"\",\"\",VLOOKUP(AE33,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH33=\"\",\"\",VLOOKUP(AH33,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL33=\"\",\"\",VLOOKUP(AL33,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP33=\"\",\"\",VLOOKUP(AP33,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F34=\"\",\"\",VLOOKUP(F34,type[],2,FALSE))","v":""},null,{"$f":"IF(H34=\"\",\"\",VLOOKUP(H34,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K34=\"\",\"\",VLOOKUP(K34,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N34=\"\",\"\",VLOOKUP(N34,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S34=\"\",\"\",VLOOKUP(S34,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U34=\"\",\"\",VLOOKUP(U34,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W34=\"\",\"\",VLOOKUP(W34,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y34=\"\",\"\",VLOOKUP(Y34,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA34=\"\",\"\",VLOOKUP(AA34,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC34=\"\",\"\",VLOOKUP(AC34,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE34=\"\",\"\",VLOOKUP(AE34,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH34=\"\",\"\",VLOOKUP(AH34,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL34=\"\",\"\",VLOOKUP(AL34,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP34=\"\",\"\",VLOOKUP(AP34,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F35=\"\",\"\",VLOOKUP(F35,type[],2,FALSE))","v":""},null,{"$f":"IF(H35=\"\",\"\",VLOOKUP(H35,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K35=\"\",\"\",VLOOKUP(K35,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N35=\"\",\"\",VLOOKUP(N35,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S35=\"\",\"\",VLOOKUP(S35,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U35=\"\",\"\",VLOOKUP(U35,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W35=\"\",\"\",VLOOKUP(W35,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y35=\"\",\"\",VLOOKUP(Y35,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA35=\"\",\"\",VLOOKUP(AA35,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC35=\"\",\"\",VLOOKUP(AC35,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE35=\"\",\"\",VLOOKUP(AE35,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH35=\"\",\"\",VLOOKUP(AH35,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL35=\"\",\"\",VLOOKUP(AL35,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP35=\"\",\"\",VLOOKUP(AP35,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F36=\"\",\"\",VLOOKUP(F36,type[],2,FALSE))","v":""},null,{"$f":"IF(H36=\"\",\"\",VLOOKUP(H36,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K36=\"\",\"\",VLOOKUP(K36,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N36=\"\",\"\",VLOOKUP(N36,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S36=\"\",\"\",VLOOKUP(S36,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U36=\"\",\"\",VLOOKUP(U36,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W36=\"\",\"\",VLOOKUP(W36,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y36=\"\",\"\",VLOOKUP(Y36,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA36=\"\",\"\",VLOOKUP(AA36,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC36=\"\",\"\",VLOOKUP(AC36,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE36=\"\",\"\",VLOOKUP(AE36,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH36=\"\",\"\",VLOOKUP(AH36,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL36=\"\",\"\",VLOOKUP(AL36,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP36=\"\",\"\",VLOOKUP(AP36,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F37=\"\",\"\",VLOOKUP(F37,type[],2,FALSE))","v":""},null,{"$f":"IF(H37=\"\",\"\",VLOOKUP(H37,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K37=\"\",\"\",VLOOKUP(K37,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N37=\"\",\"\",VLOOKUP(N37,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S37=\"\",\"\",VLOOKUP(S37,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U37=\"\",\"\",VLOOKUP(U37,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W37=\"\",\"\",VLOOKUP(W37,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y37=\"\",\"\",VLOOKUP(Y37,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA37=\"\",\"\",VLOOKUP(AA37,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC37=\"\",\"\",VLOOKUP(AC37,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE37=\"\",\"\",VLOOKUP(AE37,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH37=\"\",\"\",VLOOKUP(AH37,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL37=\"\",\"\",VLOOKUP(AL37,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP37=\"\",\"\",VLOOKUP(AP37,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F38=\"\",\"\",VLOOKUP(F38,type[],2,FALSE))","v":""},null,{"$f":"IF(H38=\"\",\"\",VLOOKUP(H38,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K38=\"\",\"\",VLOOKUP(K38,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N38=\"\",\"\",VLOOKUP(N38,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S38=\"\",\"\",VLOOKUP(S38,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U38=\"\",\"\",VLOOKUP(U38,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W38=\"\",\"\",VLOOKUP(W38,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y38=\"\",\"\",VLOOKUP(Y38,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA38=\"\",\"\",VLOOKUP(AA38,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC38=\"\",\"\",VLOOKUP(AC38,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE38=\"\",\"\",VLOOKUP(AE38,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH38=\"\",\"\",VLOOKUP(AH38,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL38=\"\",\"\",VLOOKUP(AL38,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP38=\"\",\"\",VLOOKUP(AP38,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F39=\"\",\"\",VLOOKUP(F39,type[],2,FALSE))","v":""},null,{"$f":"IF(H39=\"\",\"\",VLOOKUP(H39,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K39=\"\",\"\",VLOOKUP(K39,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N39=\"\",\"\",VLOOKUP(N39,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S39=\"\",\"\",VLOOKUP(S39,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U39=\"\",\"\",VLOOKUP(U39,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W39=\"\",\"\",VLOOKUP(W39,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y39=\"\",\"\",VLOOKUP(Y39,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA39=\"\",\"\",VLOOKUP(AA39,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC39=\"\",\"\",VLOOKUP(AC39,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE39=\"\",\"\",VLOOKUP(AE39,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH39=\"\",\"\",VLOOKUP(AH39,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL39=\"\",\"\",VLOOKUP(AL39,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP39=\"\",\"\",VLOOKUP(AP39,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F40=\"\",\"\",VLOOKUP(F40,type[],2,FALSE))","v":""},null,{"$f":"IF(H40=\"\",\"\",VLOOKUP(H40,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K40=\"\",\"\",VLOOKUP(K40,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N40=\"\",\"\",VLOOKUP(N40,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S40=\"\",\"\",VLOOKUP(S40,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U40=\"\",\"\",VLOOKUP(U40,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W40=\"\",\"\",VLOOKUP(W40,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y40=\"\",\"\",VLOOKUP(Y40,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA40=\"\",\"\",VLOOKUP(AA40,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC40=\"\",\"\",VLOOKUP(AC40,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE40=\"\",\"\",VLOOKUP(AE40,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH40=\"\",\"\",VLOOKUP(AH40,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL40=\"\",\"\",VLOOKUP(AL40,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP40=\"\",\"\",VLOOKUP(AP40,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F41=\"\",\"\",VLOOKUP(F41,type[],2,FALSE))","v":""},null,{"$f":"IF(H41=\"\",\"\",VLOOKUP(H41,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K41=\"\",\"\",VLOOKUP(K41,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N41=\"\",\"\",VLOOKUP(N41,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S41=\"\",\"\",VLOOKUP(S41,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U41=\"\",\"\",VLOOKUP(U41,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W41=\"\",\"\",VLOOKUP(W41,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y41=\"\",\"\",VLOOKUP(Y41,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA41=\"\",\"\",VLOOKUP(AA41,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC41=\"\",\"\",VLOOKUP(AC41,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE41=\"\",\"\",VLOOKUP(AE41,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH41=\"\",\"\",VLOOKUP(AH41,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL41=\"\",\"\",VLOOKUP(AL41,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP41=\"\",\"\",VLOOKUP(AP41,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F42=\"\",\"\",VLOOKUP(F42,type[],2,FALSE))","v":""},null,{"$f":"IF(H42=\"\",\"\",VLOOKUP(H42,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K42=\"\",\"\",VLOOKUP(K42,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N42=\"\",\"\",VLOOKUP(N42,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S42=\"\",\"\",VLOOKUP(S42,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U42=\"\",\"\",VLOOKUP(U42,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W42=\"\",\"\",VLOOKUP(W42,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y42=\"\",\"\",VLOOKUP(Y42,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA42=\"\",\"\",VLOOKUP(AA42,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC42=\"\",\"\",VLOOKUP(AC42,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE42=\"\",\"\",VLOOKUP(AE42,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH42=\"\",\"\",VLOOKUP(AH42,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL42=\"\",\"\",VLOOKUP(AL42,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP42=\"\",\"\",VLOOKUP(AP42,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F43=\"\",\"\",VLOOKUP(F43,type[],2,FALSE))","v":""},null,{"$f":"IF(H43=\"\",\"\",VLOOKUP(H43,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K43=\"\",\"\",VLOOKUP(K43,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N43=\"\",\"\",VLOOKUP(N43,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S43=\"\",\"\",VLOOKUP(S43,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U43=\"\",\"\",VLOOKUP(U43,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W43=\"\",\"\",VLOOKUP(W43,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y43=\"\",\"\",VLOOKUP(Y43,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA43=\"\",\"\",VLOOKUP(AA43,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC43=\"\",\"\",VLOOKUP(AC43,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE43=\"\",\"\",VLOOKUP(AE43,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH43=\"\",\"\",VLOOKUP(AH43,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL43=\"\",\"\",VLOOKUP(AL43,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP43=\"\",\"\",VLOOKUP(AP43,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F44=\"\",\"\",VLOOKUP(F44,type[],2,FALSE))","v":""},null,{"$f":"IF(H44=\"\",\"\",VLOOKUP(H44,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K44=\"\",\"\",VLOOKUP(K44,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N44=\"\",\"\",VLOOKUP(N44,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S44=\"\",\"\",VLOOKUP(S44,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U44=\"\",\"\",VLOOKUP(U44,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W44=\"\",\"\",VLOOKUP(W44,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y44=\"\",\"\",VLOOKUP(Y44,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA44=\"\",\"\",VLOOKUP(AA44,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC44=\"\",\"\",VLOOKUP(AC44,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE44=\"\",\"\",VLOOKUP(AE44,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH44=\"\",\"\",VLOOKUP(AH44,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL44=\"\",\"\",VLOOKUP(AL44,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP44=\"\",\"\",VLOOKUP(AP44,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F45=\"\",\"\",VLOOKUP(F45,type[],2,FALSE))","v":""},null,{"$f":"IF(H45=\"\",\"\",VLOOKUP(H45,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K45=\"\",\"\",VLOOKUP(K45,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N45=\"\",\"\",VLOOKUP(N45,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S45=\"\",\"\",VLOOKUP(S45,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U45=\"\",\"\",VLOOKUP(U45,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W45=\"\",\"\",VLOOKUP(W45,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y45=\"\",\"\",VLOOKUP(Y45,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA45=\"\",\"\",VLOOKUP(AA45,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC45=\"\",\"\",VLOOKUP(AC45,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE45=\"\",\"\",VLOOKUP(AE45,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH45=\"\",\"\",VLOOKUP(AH45,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL45=\"\",\"\",VLOOKUP(AL45,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP45=\"\",\"\",VLOOKUP(AP45,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F46=\"\",\"\",VLOOKUP(F46,type[],2,FALSE))","v":""},null,{"$f":"IF(H46=\"\",\"\",VLOOKUP(H46,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K46=\"\",\"\",VLOOKUP(K46,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N46=\"\",\"\",VLOOKUP(N46,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S46=\"\",\"\",VLOOKUP(S46,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U46=\"\",\"\",VLOOKUP(U46,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W46=\"\",\"\",VLOOKUP(W46,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y46=\"\",\"\",VLOOKUP(Y46,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA46=\"\",\"\",VLOOKUP(AA46,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC46=\"\",\"\",VLOOKUP(AC46,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE46=\"\",\"\",VLOOKUP(AE46,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH46=\"\",\"\",VLOOKUP(AH46,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL46=\"\",\"\",VLOOKUP(AL46,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP46=\"\",\"\",VLOOKUP(AP46,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F47=\"\",\"\",VLOOKUP(F47,type[],2,FALSE))","v":""},null,{"$f":"IF(H47=\"\",\"\",VLOOKUP(H47,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K47=\"\",\"\",VLOOKUP(K47,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N47=\"\",\"\",VLOOKUP(N47,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S47=\"\",\"\",VLOOKUP(S47,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U47=\"\",\"\",VLOOKUP(U47,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W47=\"\",\"\",VLOOKUP(W47,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y47=\"\",\"\",VLOOKUP(Y47,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA47=\"\",\"\",VLOOKUP(AA47,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC47=\"\",\"\",VLOOKUP(AC47,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE47=\"\",\"\",VLOOKUP(AE47,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH47=\"\",\"\",VLOOKUP(AH47,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL47=\"\",\"\",VLOOKUP(AL47,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP47=\"\",\"\",VLOOKUP(AP47,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F48=\"\",\"\",VLOOKUP(F48,type[],2,FALSE))","v":""},null,{"$f":"IF(H48=\"\",\"\",VLOOKUP(H48,material[],2,FALSE))","v":""},null,null,{"$f":"IF(K48=\"\",\"\",VLOOKUP(K48,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(N48=\"\",\"\",VLOOKUP(N48,side[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(S48=\"\",\"\",VLOOKUP(S48,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(U48=\"\",\"\",VLOOKUP(U48,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(W48=\"\",\"\",VLOOKUP(W48,consequence[],2,FALSE))","v":""},null,{"$f":"IF(Y48=\"\",\"\",VLOOKUP(Y48,risk[],2,FALSE))","v":""},null,{"$f":"IF(AA48=\"\",\"\",VLOOKUP(AA48,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AC48=\"\",\"\",VLOOKUP(AC48,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AE48=\"\",\"\",VLOOKUP(AE48,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AH48=\"\",\"\",VLOOKUP(AH48,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AL48=\"\",\"\",VLOOKUP(AL48,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AP48=\"\",\"\",VLOOKUP(AP48,replace_reason[],2,FALSE))","v":""}]

{"sheet":"Lookups","index":1,"n_rows":156,"n_cols":41,"rows_kept":156,"cut":false,"hidden":false,"merged":[]}
["type description","type",null,"material description","material",null,"extra length reason description","extra length reason",null,"side description","side",null,"install reason description","install reason",null,"asset owner description","asset owner",null,"likelihood description","likelihood",null,"consequence description","consequence",null,"risk description","risk",null,"rul reset description","rul reset",null,"use default description","use default",null,"condition description","condition",null,"organisation description","organisation",null,"replace reason description","replace reason"]
["Anchored","ANCH",null,"Armco","ARMCO",null,"Ends away from the road","AWAY",null,"Centre","C",null,"Asset Renewal - end of life","01",null,"Crown","C",null,"Rare","1",null,"Insignificant","1",null,"Very Low","1",null,"Not Reset","N",null,"Default","D",null,"Excellent","1",null,"3M","3M",null,"Asset Renewal - end of life","01"]
["Bin","BIN",null,"Steel Composite","COMP",null,"Ends beyond Road End","BYOND",null,"Left","L",null,"Crash Damage","02",null,"Local Authority","L",null,"Unlikely","2",null,"Minor","2",null,"Low","2",null,"Reset to Zero","R",null,"User","U",null,"Good","2",null,"Automobile Association","AA",null,"Crash Damage","02"]
["Bored Pile","BPILE",null,"Concrete","CON",null,"Common Section","COM",null,"Right","R",null,"Missing","03",null,"Private","P",null,"Possible","3",null,"Moderate","3",null,"Medium","3",null,null,null,null,null,null,null,"Average","3",null,"Auckland Council","ACC",null,"Missing","03"]
["Blue Stone","BSTNE",null,"Steel Drum","DRUM",null,"Cul de sac","CUL",null,null,null,null,"Projects","04",null,null,null,null,"Likely","4",null,"Major","4",null,"High","4",null,null,null,null,null,null,null,"Poor","4",null,"Alarm Centre Installation Ltd","ACI",null,"Projects","04"]
["Cantilever","CANT",null,"Earth","EARTH",null,"Dummy of No Length","DUMMY",null,null,null,null,"Vandalism","05",null,null,null,null,"Almost Certain","5",null,"Extreme","5",null,"Extreme","5",null,null,null,null,null,null,null,"Very poor","5",null,"Agfirst","AGF",null,"Vandalism","05"]
["Concrete","CONC",null,"Galvanised Steel","GALV",null,"Starts or Ends at an Intersection","ISECT",null,null,null,null,null,null,null,null,null,null,"Unknown","U",null,"Unknown","U",null,"Unknown","U",null,null,null,null,null,null,null,null,null,null,"Abley Ltd","AL"]
["Counterfort","COUNT",null,"Geotextile","GEOTX",null,"No adjustments made","NONE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auckland Motorway Alliance","AMA"]
["Single Crib","CRIB1",null,"Other","OTHER",null,"Roundabout","RAB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asset Management Engineers Ltd","AME"]
["Double Crib","CRIB2",null,"Rock","ROCK",null,"Widening","WIDEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asset Management Technicians Ltd","AMT"]
["Triple Crib","CRIB3",null,"Steel","STEEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Armitage Systems","ARM"]
["Crib Block","CRIBB",null,"Stone","STONE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aspect Solutions Ltd","ASL"]
["Crib Wall","CRIBW",null,"Steel and wood","STW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auckland System Management","ASM"]
["Reinforced Earth","EARTH",null,"Timber","TIM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auckland Transport","AT2"]
["Gabion","GABN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aspect Technology and Equipment Ltd","ATE"]
["Gravity","GRAV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ARRB Transport Research Ltd","ATR"]
["Stone or Boulder Wall","GSBOW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auckland University","AUN"]
["Concrete Block Wall","GSCBW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Broadspectrum (NZ) Ltd","B(L"]
["Gabion Wall (Geotechnical)","GSGAW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bri-Ken and Associates Ltd","BAA"]
["H-Pile Wall","GSHPW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bartley Consultants Ltd","BAR"]
["MSE Other","GSMOO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bloxam Burnett & Olliver Ltd","BB&"]
["MSE Slope (Geosynthetic)","GSMSG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beca Infrastructure","BCF"]
["MSE Slope (Steel Strap)","GSMSS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Buller District Council","BDC"]
["MSE Wall (Geosynthetic)","GSMWG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blacktop","BLA"]
["MSE Wall (Steel Strap)","GSMWS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beca Ltd.","BLT"]
["Timber Pole and Panel Wall","GSPPW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Civil Assist Ltd","CAL"]
["Railway Iron Wall","GSRRW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Christchurch City Council","CCC"]
["Sandbag Wall","GSSBW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City Care Ltd","CCL"]
["Crib Wall (Geotechnical)","GSTCW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Currie Electrical Ltd.","CEL"]
["Geotechnical Wall (Other)","GSWOW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company-X Ltd.","CL"]
["Keystone Block","KBLK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critchlow Limited","CL2"]
["Keystone","KEY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coastline Markers Ltd","CML"]
["Mass Block","MBLK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CoreLogic NZ Ltd.","CNL"]
["Mini Crib","MCRIB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Central Otago District Council","COD"]
["Sheet Pile","PILED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Contractor","CON"]
["Pile and Panels","PILEP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CSL Traffic","CSL"]
["Piles","PILES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Connell Wagner Ltd","CWL"]
["Rock","ROCK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dunedin City Council","DCC"]
["Rock Anchor","ROCKA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D & L Crowe Ltd","DLC"]
["Soil Nails","SOILN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spiire NZ Ltd","DWK"]
["Special Design","SPEC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excell Corporation","ECL"]
["Timber","TIMB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ferguson Ind","FGI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fulton Hogan (NZ) Ltd.","FUL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gisborne District Council","GDC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geosolve Ltd","GEO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GHD Ltd.","GHD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hamilton City Council","HCC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauraki District Council","HDC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEB Construction Ltd","HEB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Higgins Contractors Ltd.","HIG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HMI Technologies","HMI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HERE New Zealand Ltd","HNZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Horizon Services Ltd","HSL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HTS Group","HTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inframix Construction Ltd","IMX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inzone","INZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Isaac Construction","ISC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Island Asphalts","ISL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITS","ITS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jacobs New Zealand Ltd","JAC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JCW Consultant","JC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JCL Asphalt subcontractor","JCL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JJ Walters","JJW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Johnstone & Masters Ltd","JM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NZTA (JTOC)","JTO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Juno Services Ltd","JUN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kapiti Coast District Council","KCD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kampung Consulting Ltd.","KCL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kelcroft Engineering","KEL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local Authority","LA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lonrix Ltd","LL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McKays Consultants","MCC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matamata-Piako District Council","MD2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manawatu District Council","MDC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McKay Electrical Ltd","MEL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aecom NZ Ltd","MER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MetService","MET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marlborough NOC JV","MJV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McKay Ltd.","ML"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marlborough Roads","MR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MWH NZ Ltd.","MWH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Napier City Council","NCC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NZ Transport Agency - Highway Programme","NTA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NZ Transport Agency - Funding","NTF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"North Power","NTH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nutech Security","NUT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Odyssey Energy (2009) Ltd.","OE("]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opus International Consultants Ltd (NZ)","OI2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opus International Consultants Ltd.","OIC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oldfields","OLD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Porirua City Council","PCC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pinnacles Civil Group Ltd.","PCG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pope Electrical Ltd","PE2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pope Electrical Limited","PEL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pavement Management Services","PMS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Power Solutions Ltd","PSL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Queenstown-Lakes District Council","QDC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quality Roading and Services","QRS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Read-only access for Tenderers","RAF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rangitikei District Council","RDC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadex","RDX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rotorua Lakes Council","RLC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roading Logistics Ltd","RLL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rationale Ltd","RLT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rotorua District Council","ROT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAMM Software Limited","RSL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Road Signs & Traffic Control Equipment Limited","RTL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Russell Roads","RUS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Salient Consultants","SAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sealcoat Central Ltd.","SCL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shaw's Consulting Services Ltd","SCS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Southland District Council","SDC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signopsys Electronic Signs","SES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sicon Ltd.","SL2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stantec New Zealand","SN2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stantec New Zealand Ltd","SNZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SouthRoads Ltd.","SOU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Safe Roads Alliance","SRA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Services South East (NZ) Ltd.","SS2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Services South East Pty Ltd","SSE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tonkin & Taylor Ltd","T&T"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tasman Howey","TAS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NZTA and WDM","TAW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tauranga City Council","TC2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taranaki Civil Construction","TCC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC Nicholls","TCN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traffic Control Systems","TCS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taupo District Council","TD2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tasman District Council","TDC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Datastack Ltd","TDL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taupo East Traffic Services Contractor","TET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Broadspectrum (NZ) Ltd","TFD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waka Kotahi NZ Transport Agency","TNZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Top Energy","TOP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Roading Company","TRC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transfield Services (NZ) Ltd","TS("]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tonkin and Taylor Ltd","TT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tyco Traffic and Transportation","TYC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urban Connection Ltd","UCL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"University of Canterbury","UOC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ventia Pty Ltd","VPL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Bay of Plenty District Council","WBO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wellington City Council","WCC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waimakariri District Council","WD2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whakatane District Council","WD3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wairoa District Council","WD4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waipa District Council","WD5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waikato District Council","WD6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whangarei District Council","WDC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WDM","WDM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WSP-Opus International Consultants Ltd","WIC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downer New Zealand Limited","WIL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W J Ashton Service Ltd","WJA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waka Kotahi NZ Transport Agency - Highways","WK2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waka Kotahi NZ Transport Agency","WKN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WSP New Zealand Ltd","WNZ"]