{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Marking","Lookups"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":41,"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":"Marking","index":0,"n_rows":100,"n_cols":59,"rows_kept":100,"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","f400c587-d0f7-40ab-80c5-7d6bce721547_marking_type_desc","f400c587-d0f7-40ab-80c5-7d6bce721547_marking_type","0a58fce3-ef9a-4334-bda4-934c35a53b55_marking_material_desc","0a58fce3-ef9a-4334-bda4-934c35a53b55_marking_material","68858043-b6c5-46e1-9972-cbd744e4f9cc_marking_colour_desc","68858043-b6c5-46e1-9972-cbd744e4f9cc_marking_colour","699ec48d-3cb6-4daa-a983-a7968715e20d_reflectorised_desc","699ec48d-3cb6-4daa-a983-a7968715e20d_reflectorised","66f156c5-6a45-4deb-bdbf-a4633bda75bc_quantity","480522c2-0834-4c40-aa80-5d35c74460fa_application_rate","d90f94bc-8c24-4a2a-b56c-9d2efa9a2a41_marking_attach_desc","d90f94bc-8c24-4a2a-b56c-9d2efa9a2a41_marking_attach","d148ed0e-0e40-412c-904d-aad87e1ffaae_paint_make_desc","d148ed0e-0e40-412c-904d-aad87e1ffaae_paint_make","3145e7be-b1d3-41a5-a5fc-3f494de993c6_paint_brand_name_desc","3145e7be-b1d3-41a5-a5fc-3f494de993c6_paint_brand_name","9a305e21-fb58-453c-85f6-4acb8aed9862_paint_apply_type_desc","9a305e21-fb58-453c-85f6-4acb8aed9862_paint_apply_type","ce82bf0e-8485-4d23-911b-36c362e05657_individual_length","df41d7d0-417d-41e3-bd8b-9ab2f6d0d917_spacing","3fed5581-2ff4-4cd7-a612-3de72c46b039_thickness","be4ebe7e-60f8-479f-9704-6ce8e96c05a1_length_adjust_m","f1301eb0-2a4f-486e-95e5-e79d4a2f0b05_len_adjust_rsn_desc","f1301eb0-2a4f-486e-95e5-e79d4a2f0b05_len_adjust_rsn","68582855-b644-4b62-85cd-e6a420f9a7c9_length_m","8156a1c4-d142-4299-b5c1-d2da03157612_side_desc","8156a1c4-d142-4299-b5c1-d2da03157612_side","a55e5b67-f77d-4dc1-838e-039c12aa0ff9_offset","ddfe08b0-81ec-40de-a2d7-b592bc052755_painted_date","a0cb227a-b868-491e-8d63-d3c7d2ea7455_asset_owner_desc","a0cb227a-b868-491e-8d63-d3c7d2ea7455_asset_owner","791560f7-e074-40a9-87b0-ae52ed45474e_risk_likelihood_desc","791560f7-e074-40a9-87b0-ae52ed45474e_risk_likelihood","60193c8f-f186-47b7-8590-21c2983f4ef6_risk_consequence_desc","60193c8f-f186-47b7-8590-21c2983f4ef6_risk_consequence","06519e26-67ab-44a8-94a6-5a29df5ce30f_risk_desc","06519e26-67ab-44a8-94a6-5a29df5ce30f_risk","46621562-e7e3-468c-92d6-8271a43d28d6_rul_reset_desc","46621562-e7e3-468c-92d6-8271a43d28d6_rul_reset","350d01ca-5a12-4b19-9d0e-1d9c104eddf0_use_default_rc_desc","350d01ca-5a12-4b19-9d0e-1d9c104eddf0_use_default_rc","c40f401a-bb3f-4575-91cf-6962388c65a0_condition_desc","c40f401a-bb3f-4575-91cf-6962388c65a0_condition","e653f0e0-4762-4de6-a026-2c0b324d7af7_condition_date","54ba23a6-44ea-439d-90f6-105ca1d92a53_collect_name_desc","54ba23a6-44ea-439d-90f6-105ca1d92a53_collect_name","98770037-5440-4257-a5af-388e916fed1b_marking_id","44bba564-1df4-49fa-9176-835f774d8896_notes","22c4a04e-16ab-457e-86d6-87a2e17fa052_not_ramm_field_in_replace_reason_desc","22c4a04e-16ab-457e-86d6-87a2e17fa052_not_ramm_field_in_replace_reason","d602840f-0925-4d57-b9b2-4f86960ae08d_not_ramm_field_prior_id","eb00d1f7-3fd9-440d-8ca4-ea9f069b7032_not_ramm_field_replace_date","36101fae-76dc-4397-94cf-8751d5f9c090_not_ramm_field_rep_replace_reason_desc","36101fae-76dc-4397-94cf-8751d5f9c090_not_ramm_field_rep_replace_reason"]
["road_id","road_id","sh-rs-d","start_m","end_m","marking_type_desc","marking_type","marking_material_desc","marking_material","marking_colour_desc","marking_colour","reflectorised_desc","reflectorised","quantity","application_rate","marking_attach_desc","marking_attach","paint_make_desc","paint_make","paint_brand_name_desc","paint_brand_name","paint_apply_type_desc","paint_apply_type","individual_length","spacing","thickness","length_adjust_m","len_adjust_rsn_desc","len_adjust_rsn","length_m","side_desc","side","offset","painted_date","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","marking_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 and include leading 0","Start RP","End RP","Marking Type Description","Marking Type","Marking Material Description","Marking Material","Marking Colour Description","Marking Colour","Reflectorised Marking Description","Reflectorised Marking","Quantity","Application Rate","Marking Attach Description","Marking Attach","Paint Make Description","Paint Make","Paint Brand Description","Paint Brand","Application Type Description","Application Type","Individual Length","Spacing","Thickness","Extra Length (m) must default to 0 if no extra length","Extra Length Reason Description","Extra Length Reason","Total Length (m)","Side Description","Side","Offset","Paint 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","Marking 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,{"$f":"IF(J4=\"\",\"\",VLOOKUP(J4,colour[],2,FALSE))","v":""},null,{"$f":"IF(L4=\"\",\"\",VLOOKUP(L4,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P4=\"\",\"\",VLOOKUP(P4,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R4=\"\",\"\",VLOOKUP(R4,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T4=\"\",\"\",VLOOKUP(T4,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V4=\"\",\"\",VLOOKUP(V4,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB4=\"\",\"\",VLOOKUP(AB4,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE4=\"\",\"\",VLOOKUP(AE4,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI4=\"\",\"\",VLOOKUP(AI4,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK4=\"\",\"\",VLOOKUP(AK4,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM4=\"\",\"\",VLOOKUP(AM4,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO4=\"\",\"\",VLOOKUP(AO4,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ4=\"\",\"\",VLOOKUP(AQ4,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS4=\"\",\"\",VLOOKUP(AS4,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU4=\"\",\"\",VLOOKUP(AU4,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX4=\"\",\"\",VLOOKUP(AX4,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB4=\"\",\"\",VLOOKUP(BB4,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF4=\"\",\"\",VLOOKUP(BF4,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,{"$f":"IF(J5=\"\",\"\",VLOOKUP(J5,colour[],2,FALSE))","v":""},null,{"$f":"IF(L5=\"\",\"\",VLOOKUP(L5,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P5=\"\",\"\",VLOOKUP(P5,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R5=\"\",\"\",VLOOKUP(R5,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T5=\"\",\"\",VLOOKUP(T5,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V5=\"\",\"\",VLOOKUP(V5,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB5=\"\",\"\",VLOOKUP(AB5,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE5=\"\",\"\",VLOOKUP(AE5,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI5=\"\",\"\",VLOOKUP(AI5,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK5=\"\",\"\",VLOOKUP(AK5,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM5=\"\",\"\",VLOOKUP(AM5,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO5=\"\",\"\",VLOOKUP(AO5,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ5=\"\",\"\",VLOOKUP(AQ5,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS5=\"\",\"\",VLOOKUP(AS5,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU5=\"\",\"\",VLOOKUP(AU5,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX5=\"\",\"\",VLOOKUP(AX5,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB5=\"\",\"\",VLOOKUP(BB5,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF5=\"\",\"\",VLOOKUP(BF5,replace_reason[],2,FALSE))","v":""}]
["null","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,{"$f":"IF(J6=\"\",\"\",VLOOKUP(J6,colour[],2,FALSE))","v":""},null,{"$f":"IF(L6=\"\",\"\",VLOOKUP(L6,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P6=\"\",\"\",VLOOKUP(P6,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R6=\"\",\"\",VLOOKUP(R6,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T6=\"\",\"\",VLOOKUP(T6,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V6=\"\",\"\",VLOOKUP(V6,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB6=\"\",\"\",VLOOKUP(AB6,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE6=\"\",\"\",VLOOKUP(AE6,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI6=\"\",\"\",VLOOKUP(AI6,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK6=\"\",\"\",VLOOKUP(AK6,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM6=\"\",\"\",VLOOKUP(AM6,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO6=\"\",\"\",VLOOKUP(AO6,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ6=\"\",\"\",VLOOKUP(AQ6,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS6=\"\",\"\",VLOOKUP(AS6,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU6=\"\",\"\",VLOOKUP(AU6,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX6=\"\",\"\",VLOOKUP(AX6,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB6=\"\",\"\",VLOOKUP(BB6,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF6=\"\",\"\",VLOOKUP(BF6,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,{"$f":"IF(J7=\"\",\"\",VLOOKUP(J7,colour[],2,FALSE))","v":""},null,{"$f":"IF(L7=\"\",\"\",VLOOKUP(L7,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P7=\"\",\"\",VLOOKUP(P7,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R7=\"\",\"\",VLOOKUP(R7,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T7=\"\",\"\",VLOOKUP(T7,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V7=\"\",\"\",VLOOKUP(V7,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB7=\"\",\"\",VLOOKUP(AB7,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE7=\"\",\"\",VLOOKUP(AE7,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI7=\"\",\"\",VLOOKUP(AI7,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK7=\"\",\"\",VLOOKUP(AK7,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM7=\"\",\"\",VLOOKUP(AM7,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO7=\"\",\"\",VLOOKUP(AO7,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ7=\"\",\"\",VLOOKUP(AQ7,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS7=\"\",\"\",VLOOKUP(AS7,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU7=\"\",\"\",VLOOKUP(AU7,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX7=\"\",\"\",VLOOKUP(AX7,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB7=\"\",\"\",VLOOKUP(BB7,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF7=\"\",\"\",VLOOKUP(BF7,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,{"$f":"IF(J8=\"\",\"\",VLOOKUP(J8,colour[],2,FALSE))","v":""},null,{"$f":"IF(L8=\"\",\"\",VLOOKUP(L8,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P8=\"\",\"\",VLOOKUP(P8,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R8=\"\",\"\",VLOOKUP(R8,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T8=\"\",\"\",VLOOKUP(T8,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V8=\"\",\"\",VLOOKUP(V8,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB8=\"\",\"\",VLOOKUP(AB8,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE8=\"\",\"\",VLOOKUP(AE8,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI8=\"\",\"\",VLOOKUP(AI8,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK8=\"\",\"\",VLOOKUP(AK8,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM8=\"\",\"\",VLOOKUP(AM8,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO8=\"\",\"\",VLOOKUP(AO8,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ8=\"\",\"\",VLOOKUP(AQ8,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS8=\"\",\"\",VLOOKUP(AS8,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU8=\"\",\"\",VLOOKUP(AU8,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX8=\"\",\"\",VLOOKUP(AX8,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB8=\"\",\"\",VLOOKUP(BB8,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF8=\"\",\"\",VLOOKUP(BF8,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,{"$f":"IF(J9=\"\",\"\",VLOOKUP(J9,colour[],2,FALSE))","v":""},null,{"$f":"IF(L9=\"\",\"\",VLOOKUP(L9,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P9=\"\",\"\",VLOOKUP(P9,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R9=\"\",\"\",VLOOKUP(R9,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T9=\"\",\"\",VLOOKUP(T9,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V9=\"\",\"\",VLOOKUP(V9,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB9=\"\",\"\",VLOOKUP(AB9,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE9=\"\",\"\",VLOOKUP(AE9,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI9=\"\",\"\",VLOOKUP(AI9,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK9=\"\",\"\",VLOOKUP(AK9,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM9=\"\",\"\",VLOOKUP(AM9,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO9=\"\",\"\",VLOOKUP(AO9,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ9=\"\",\"\",VLOOKUP(AQ9,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS9=\"\",\"\",VLOOKUP(AS9,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU9=\"\",\"\",VLOOKUP(AU9,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX9=\"\",\"\",VLOOKUP(AX9,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB9=\"\",\"\",VLOOKUP(BB9,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF9=\"\",\"\",VLOOKUP(BF9,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,{"$f":"IF(J10=\"\",\"\",VLOOKUP(J10,colour[],2,FALSE))","v":""},null,{"$f":"IF(L10=\"\",\"\",VLOOKUP(L10,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P10=\"\",\"\",VLOOKUP(P10,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R10=\"\",\"\",VLOOKUP(R10,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T10=\"\",\"\",VLOOKUP(T10,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V10=\"\",\"\",VLOOKUP(V10,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB10=\"\",\"\",VLOOKUP(AB10,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE10=\"\",\"\",VLOOKUP(AE10,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI10=\"\",\"\",VLOOKUP(AI10,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK10=\"\",\"\",VLOOKUP(AK10,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM10=\"\",\"\",VLOOKUP(AM10,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO10=\"\",\"\",VLOOKUP(AO10,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ10=\"\",\"\",VLOOKUP(AQ10,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS10=\"\",\"\",VLOOKUP(AS10,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU10=\"\",\"\",VLOOKUP(AU10,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX10=\"\",\"\",VLOOKUP(AX10,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB10=\"\",\"\",VLOOKUP(BB10,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF10=\"\",\"\",VLOOKUP(BF10,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,{"$f":"IF(J11=\"\",\"\",VLOOKUP(J11,colour[],2,FALSE))","v":""},null,{"$f":"IF(L11=\"\",\"\",VLOOKUP(L11,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P11=\"\",\"\",VLOOKUP(P11,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R11=\"\",\"\",VLOOKUP(R11,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T11=\"\",\"\",VLOOKUP(T11,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V11=\"\",\"\",VLOOKUP(V11,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB11=\"\",\"\",VLOOKUP(AB11,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE11=\"\",\"\",VLOOKUP(AE11,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI11=\"\",\"\",VLOOKUP(AI11,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK11=\"\",\"\",VLOOKUP(AK11,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM11=\"\",\"\",VLOOKUP(AM11,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO11=\"\",\"\",VLOOKUP(AO11,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ11=\"\",\"\",VLOOKUP(AQ11,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS11=\"\",\"\",VLOOKUP(AS11,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU11=\"\",\"\",VLOOKUP(AU11,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX11=\"\",\"\",VLOOKUP(AX11,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB11=\"\",\"\",VLOOKUP(BB11,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF11=\"\",\"\",VLOOKUP(BF11,replace_reason[],2,FALSE))","v":""}]
[{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&C12&\"/\"&D12&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&C12&\"/\"&E12&\"&xml=true\"),\"/lrms/id_road\")","v":"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,{"$f":"IF(J12=\"\",\"\",VLOOKUP(J12,colour[],2,FALSE))","v":""},null,{"$f":"IF(L12=\"\",\"\",VLOOKUP(L12,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P12=\"\",\"\",VLOOKUP(P12,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R12=\"\",\"\",VLOOKUP(R12,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T12=\"\",\"\",VLOOKUP(T12,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V12=\"\",\"\",VLOOKUP(V12,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB12=\"\",\"\",VLOOKUP(AB12,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE12=\"\",\"\",VLOOKUP(AE12,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI12=\"\",\"\",VLOOKUP(AI12,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK12=\"\",\"\",VLOOKUP(AK12,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM12=\"\",\"\",VLOOKUP(AM12,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO12=\"\",\"\",VLOOKUP(AO12,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ12=\"\",\"\",VLOOKUP(AQ12,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS12=\"\",\"\",VLOOKUP(AS12,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU12=\"\",\"\",VLOOKUP(AU12,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX12=\"\",\"\",VLOOKUP(AX12,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB12=\"\",\"\",VLOOKUP(BB12,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF12=\"\",\"\",VLOOKUP(BF12,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,{"$f":"IF(J13=\"\",\"\",VLOOKUP(J13,colour[],2,FALSE))","v":""},null,{"$f":"IF(L13=\"\",\"\",VLOOKUP(L13,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P13=\"\",\"\",VLOOKUP(P13,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R13=\"\",\"\",VLOOKUP(R13,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T13=\"\",\"\",VLOOKUP(T13,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V13=\"\",\"\",VLOOKUP(V13,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB13=\"\",\"\",VLOOKUP(AB13,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE13=\"\",\"\",VLOOKUP(AE13,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI13=\"\",\"\",VLOOKUP(AI13,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK13=\"\",\"\",VLOOKUP(AK13,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM13=\"\",\"\",VLOOKUP(AM13,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO13=\"\",\"\",VLOOKUP(AO13,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ13=\"\",\"\",VLOOKUP(AQ13,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS13=\"\",\"\",VLOOKUP(AS13,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU13=\"\",\"\",VLOOKUP(AU13,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX13=\"\",\"\",VLOOKUP(AX13,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB13=\"\",\"\",VLOOKUP(BB13,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF13=\"\",\"\",VLOOKUP(BF13,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,{"$f":"IF(J14=\"\",\"\",VLOOKUP(J14,colour[],2,FALSE))","v":""},null,{"$f":"IF(L14=\"\",\"\",VLOOKUP(L14,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P14=\"\",\"\",VLOOKUP(P14,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R14=\"\",\"\",VLOOKUP(R14,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T14=\"\",\"\",VLOOKUP(T14,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V14=\"\",\"\",VLOOKUP(V14,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB14=\"\",\"\",VLOOKUP(AB14,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE14=\"\",\"\",VLOOKUP(AE14,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI14=\"\",\"\",VLOOKUP(AI14,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK14=\"\",\"\",VLOOKUP(AK14,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM14=\"\",\"\",VLOOKUP(AM14,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO14=\"\",\"\",VLOOKUP(AO14,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ14=\"\",\"\",VLOOKUP(AQ14,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS14=\"\",\"\",VLOOKUP(AS14,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU14=\"\",\"\",VLOOKUP(AU14,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX14=\"\",\"\",VLOOKUP(AX14,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB14=\"\",\"\",VLOOKUP(BB14,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF14=\"\",\"\",VLOOKUP(BF14,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,{"$f":"IF(J15=\"\",\"\",VLOOKUP(J15,colour[],2,FALSE))","v":""},null,{"$f":"IF(L15=\"\",\"\",VLOOKUP(L15,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P15=\"\",\"\",VLOOKUP(P15,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R15=\"\",\"\",VLOOKUP(R15,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T15=\"\",\"\",VLOOKUP(T15,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V15=\"\",\"\",VLOOKUP(V15,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB15=\"\",\"\",VLOOKUP(AB15,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE15=\"\",\"\",VLOOKUP(AE15,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI15=\"\",\"\",VLOOKUP(AI15,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK15=\"\",\"\",VLOOKUP(AK15,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM15=\"\",\"\",VLOOKUP(AM15,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO15=\"\",\"\",VLOOKUP(AO15,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ15=\"\",\"\",VLOOKUP(AQ15,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS15=\"\",\"\",VLOOKUP(AS15,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU15=\"\",\"\",VLOOKUP(AU15,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX15=\"\",\"\",VLOOKUP(AX15,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB15=\"\",\"\",VLOOKUP(BB15,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF15=\"\",\"\",VLOOKUP(BF15,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,{"$f":"IF(J16=\"\",\"\",VLOOKUP(J16,colour[],2,FALSE))","v":""},null,{"$f":"IF(L16=\"\",\"\",VLOOKUP(L16,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P16=\"\",\"\",VLOOKUP(P16,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R16=\"\",\"\",VLOOKUP(R16,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T16=\"\",\"\",VLOOKUP(T16,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V16=\"\",\"\",VLOOKUP(V16,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB16=\"\",\"\",VLOOKUP(AB16,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE16=\"\",\"\",VLOOKUP(AE16,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI16=\"\",\"\",VLOOKUP(AI16,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK16=\"\",\"\",VLOOKUP(AK16,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM16=\"\",\"\",VLOOKUP(AM16,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO16=\"\",\"\",VLOOKUP(AO16,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ16=\"\",\"\",VLOOKUP(AQ16,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS16=\"\",\"\",VLOOKUP(AS16,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU16=\"\",\"\",VLOOKUP(AU16,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX16=\"\",\"\",VLOOKUP(AX16,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB16=\"\",\"\",VLOOKUP(BB16,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF16=\"\",\"\",VLOOKUP(BF16,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,{"$f":"IF(J17=\"\",\"\",VLOOKUP(J17,colour[],2,FALSE))","v":""},null,{"$f":"IF(L17=\"\",\"\",VLOOKUP(L17,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P17=\"\",\"\",VLOOKUP(P17,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R17=\"\",\"\",VLOOKUP(R17,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T17=\"\",\"\",VLOOKUP(T17,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V17=\"\",\"\",VLOOKUP(V17,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB17=\"\",\"\",VLOOKUP(AB17,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE17=\"\",\"\",VLOOKUP(AE17,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI17=\"\",\"\",VLOOKUP(AI17,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK17=\"\",\"\",VLOOKUP(AK17,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM17=\"\",\"\",VLOOKUP(AM17,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO17=\"\",\"\",VLOOKUP(AO17,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ17=\"\",\"\",VLOOKUP(AQ17,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS17=\"\",\"\",VLOOKUP(AS17,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU17=\"\",\"\",VLOOKUP(AU17,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX17=\"\",\"\",VLOOKUP(AX17,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB17=\"\",\"\",VLOOKUP(BB17,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF17=\"\",\"\",VLOOKUP(BF17,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,{"$f":"IF(J18=\"\",\"\",VLOOKUP(J18,colour[],2,FALSE))","v":""},null,{"$f":"IF(L18=\"\",\"\",VLOOKUP(L18,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P18=\"\",\"\",VLOOKUP(P18,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R18=\"\",\"\",VLOOKUP(R18,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T18=\"\",\"\",VLOOKUP(T18,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V18=\"\",\"\",VLOOKUP(V18,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB18=\"\",\"\",VLOOKUP(AB18,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE18=\"\",\"\",VLOOKUP(AE18,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI18=\"\",\"\",VLOOKUP(AI18,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK18=\"\",\"\",VLOOKUP(AK18,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM18=\"\",\"\",VLOOKUP(AM18,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO18=\"\",\"\",VLOOKUP(AO18,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ18=\"\",\"\",VLOOKUP(AQ18,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS18=\"\",\"\",VLOOKUP(AS18,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU18=\"\",\"\",VLOOKUP(AU18,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX18=\"\",\"\",VLOOKUP(AX18,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB18=\"\",\"\",VLOOKUP(BB18,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF18=\"\",\"\",VLOOKUP(BF18,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,{"$f":"IF(J19=\"\",\"\",VLOOKUP(J19,colour[],2,FALSE))","v":""},null,{"$f":"IF(L19=\"\",\"\",VLOOKUP(L19,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P19=\"\",\"\",VLOOKUP(P19,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R19=\"\",\"\",VLOOKUP(R19,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T19=\"\",\"\",VLOOKUP(T19,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V19=\"\",\"\",VLOOKUP(V19,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB19=\"\",\"\",VLOOKUP(AB19,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE19=\"\",\"\",VLOOKUP(AE19,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI19=\"\",\"\",VLOOKUP(AI19,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK19=\"\",\"\",VLOOKUP(AK19,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM19=\"\",\"\",VLOOKUP(AM19,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO19=\"\",\"\",VLOOKUP(AO19,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ19=\"\",\"\",VLOOKUP(AQ19,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS19=\"\",\"\",VLOOKUP(AS19,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU19=\"\",\"\",VLOOKUP(AU19,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX19=\"\",\"\",VLOOKUP(AX19,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB19=\"\",\"\",VLOOKUP(BB19,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF19=\"\",\"\",VLOOKUP(BF19,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,{"$f":"IF(J20=\"\",\"\",VLOOKUP(J20,colour[],2,FALSE))","v":""},null,{"$f":"IF(L20=\"\",\"\",VLOOKUP(L20,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P20=\"\",\"\",VLOOKUP(P20,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R20=\"\",\"\",VLOOKUP(R20,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T20=\"\",\"\",VLOOKUP(T20,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V20=\"\",\"\",VLOOKUP(V20,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB20=\"\",\"\",VLOOKUP(AB20,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE20=\"\",\"\",VLOOKUP(AE20,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI20=\"\",\"\",VLOOKUP(AI20,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK20=\"\",\"\",VLOOKUP(AK20,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM20=\"\",\"\",VLOOKUP(AM20,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO20=\"\",\"\",VLOOKUP(AO20,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ20=\"\",\"\",VLOOKUP(AQ20,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS20=\"\",\"\",VLOOKUP(AS20,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU20=\"\",\"\",VLOOKUP(AU20,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX20=\"\",\"\",VLOOKUP(AX20,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB20=\"\",\"\",VLOOKUP(BB20,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF20=\"\",\"\",VLOOKUP(BF20,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,{"$f":"IF(J21=\"\",\"\",VLOOKUP(J21,colour[],2,FALSE))","v":""},null,{"$f":"IF(L21=\"\",\"\",VLOOKUP(L21,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P21=\"\",\"\",VLOOKUP(P21,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R21=\"\",\"\",VLOOKUP(R21,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T21=\"\",\"\",VLOOKUP(T21,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V21=\"\",\"\",VLOOKUP(V21,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB21=\"\",\"\",VLOOKUP(AB21,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE21=\"\",\"\",VLOOKUP(AE21,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI21=\"\",\"\",VLOOKUP(AI21,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK21=\"\",\"\",VLOOKUP(AK21,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM21=\"\",\"\",VLOOKUP(AM21,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO21=\"\",\"\",VLOOKUP(AO21,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ21=\"\",\"\",VLOOKUP(AQ21,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS21=\"\",\"\",VLOOKUP(AS21,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU21=\"\",\"\",VLOOKUP(AU21,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX21=\"\",\"\",VLOOKUP(AX21,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB21=\"\",\"\",VLOOKUP(BB21,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF21=\"\",\"\",VLOOKUP(BF21,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,{"$f":"IF(J22=\"\",\"\",VLOOKUP(J22,colour[],2,FALSE))","v":""},null,{"$f":"IF(L22=\"\",\"\",VLOOKUP(L22,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P22=\"\",\"\",VLOOKUP(P22,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R22=\"\",\"\",VLOOKUP(R22,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T22=\"\",\"\",VLOOKUP(T22,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V22=\"\",\"\",VLOOKUP(V22,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB22=\"\",\"\",VLOOKUP(AB22,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE22=\"\",\"\",VLOOKUP(AE22,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI22=\"\",\"\",VLOOKUP(AI22,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK22=\"\",\"\",VLOOKUP(AK22,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM22=\"\",\"\",VLOOKUP(AM22,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO22=\"\",\"\",VLOOKUP(AO22,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ22=\"\",\"\",VLOOKUP(AQ22,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS22=\"\",\"\",VLOOKUP(AS22,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU22=\"\",\"\",VLOOKUP(AU22,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX22=\"\",\"\",VLOOKUP(AX22,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB22=\"\",\"\",VLOOKUP(BB22,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF22=\"\",\"\",VLOOKUP(BF22,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,{"$f":"IF(J23=\"\",\"\",VLOOKUP(J23,colour[],2,FALSE))","v":""},null,{"$f":"IF(L23=\"\",\"\",VLOOKUP(L23,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P23=\"\",\"\",VLOOKUP(P23,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R23=\"\",\"\",VLOOKUP(R23,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T23=\"\",\"\",VLOOKUP(T23,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V23=\"\",\"\",VLOOKUP(V23,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB23=\"\",\"\",VLOOKUP(AB23,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE23=\"\",\"\",VLOOKUP(AE23,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI23=\"\",\"\",VLOOKUP(AI23,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK23=\"\",\"\",VLOOKUP(AK23,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM23=\"\",\"\",VLOOKUP(AM23,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO23=\"\",\"\",VLOOKUP(AO23,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ23=\"\",\"\",VLOOKUP(AQ23,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS23=\"\",\"\",VLOOKUP(AS23,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU23=\"\",\"\",VLOOKUP(AU23,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX23=\"\",\"\",VLOOKUP(AX23,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB23=\"\",\"\",VLOOKUP(BB23,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF23=\"\",\"\",VLOOKUP(BF23,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,{"$f":"IF(J24=\"\",\"\",VLOOKUP(J24,colour[],2,FALSE))","v":""},null,{"$f":"IF(L24=\"\",\"\",VLOOKUP(L24,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P24=\"\",\"\",VLOOKUP(P24,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R24=\"\",\"\",VLOOKUP(R24,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T24=\"\",\"\",VLOOKUP(T24,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V24=\"\",\"\",VLOOKUP(V24,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB24=\"\",\"\",VLOOKUP(AB24,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE24=\"\",\"\",VLOOKUP(AE24,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI24=\"\",\"\",VLOOKUP(AI24,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK24=\"\",\"\",VLOOKUP(AK24,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM24=\"\",\"\",VLOOKUP(AM24,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO24=\"\",\"\",VLOOKUP(AO24,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ24=\"\",\"\",VLOOKUP(AQ24,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS24=\"\",\"\",VLOOKUP(AS24,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU24=\"\",\"\",VLOOKUP(AU24,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX24=\"\",\"\",VLOOKUP(AX24,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB24=\"\",\"\",VLOOKUP(BB24,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF24=\"\",\"\",VLOOKUP(BF24,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,{"$f":"IF(J25=\"\",\"\",VLOOKUP(J25,colour[],2,FALSE))","v":""},null,{"$f":"IF(L25=\"\",\"\",VLOOKUP(L25,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P25=\"\",\"\",VLOOKUP(P25,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R25=\"\",\"\",VLOOKUP(R25,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T25=\"\",\"\",VLOOKUP(T25,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V25=\"\",\"\",VLOOKUP(V25,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB25=\"\",\"\",VLOOKUP(AB25,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE25=\"\",\"\",VLOOKUP(AE25,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI25=\"\",\"\",VLOOKUP(AI25,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK25=\"\",\"\",VLOOKUP(AK25,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM25=\"\",\"\",VLOOKUP(AM25,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO25=\"\",\"\",VLOOKUP(AO25,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ25=\"\",\"\",VLOOKUP(AQ25,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS25=\"\",\"\",VLOOKUP(AS25,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU25=\"\",\"\",VLOOKUP(AU25,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX25=\"\",\"\",VLOOKUP(AX25,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB25=\"\",\"\",VLOOKUP(BB25,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF25=\"\",\"\",VLOOKUP(BF25,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,{"$f":"IF(J26=\"\",\"\",VLOOKUP(J26,colour[],2,FALSE))","v":""},null,{"$f":"IF(L26=\"\",\"\",VLOOKUP(L26,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P26=\"\",\"\",VLOOKUP(P26,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R26=\"\",\"\",VLOOKUP(R26,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T26=\"\",\"\",VLOOKUP(T26,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V26=\"\",\"\",VLOOKUP(V26,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB26=\"\",\"\",VLOOKUP(AB26,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE26=\"\",\"\",VLOOKUP(AE26,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI26=\"\",\"\",VLOOKUP(AI26,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK26=\"\",\"\",VLOOKUP(AK26,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM26=\"\",\"\",VLOOKUP(AM26,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO26=\"\",\"\",VLOOKUP(AO26,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ26=\"\",\"\",VLOOKUP(AQ26,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS26=\"\",\"\",VLOOKUP(AS26,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU26=\"\",\"\",VLOOKUP(AU26,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX26=\"\",\"\",VLOOKUP(AX26,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB26=\"\",\"\",VLOOKUP(BB26,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF26=\"\",\"\",VLOOKUP(BF26,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,{"$f":"IF(J27=\"\",\"\",VLOOKUP(J27,colour[],2,FALSE))","v":""},null,{"$f":"IF(L27=\"\",\"\",VLOOKUP(L27,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P27=\"\",\"\",VLOOKUP(P27,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R27=\"\",\"\",VLOOKUP(R27,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T27=\"\",\"\",VLOOKUP(T27,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V27=\"\",\"\",VLOOKUP(V27,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB27=\"\",\"\",VLOOKUP(AB27,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE27=\"\",\"\",VLOOKUP(AE27,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI27=\"\",\"\",VLOOKUP(AI27,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK27=\"\",\"\",VLOOKUP(AK27,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM27=\"\",\"\",VLOOKUP(AM27,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO27=\"\",\"\",VLOOKUP(AO27,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ27=\"\",\"\",VLOOKUP(AQ27,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS27=\"\",\"\",VLOOKUP(AS27,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU27=\"\",\"\",VLOOKUP(AU27,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX27=\"\",\"\",VLOOKUP(AX27,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB27=\"\",\"\",VLOOKUP(BB27,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF27=\"\",\"\",VLOOKUP(BF27,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,{"$f":"IF(J28=\"\",\"\",VLOOKUP(J28,colour[],2,FALSE))","v":""},null,{"$f":"IF(L28=\"\",\"\",VLOOKUP(L28,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P28=\"\",\"\",VLOOKUP(P28,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R28=\"\",\"\",VLOOKUP(R28,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T28=\"\",\"\",VLOOKUP(T28,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V28=\"\",\"\",VLOOKUP(V28,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB28=\"\",\"\",VLOOKUP(AB28,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE28=\"\",\"\",VLOOKUP(AE28,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI28=\"\",\"\",VLOOKUP(AI28,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK28=\"\",\"\",VLOOKUP(AK28,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM28=\"\",\"\",VLOOKUP(AM28,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO28=\"\",\"\",VLOOKUP(AO28,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ28=\"\",\"\",VLOOKUP(AQ28,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS28=\"\",\"\",VLOOKUP(AS28,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU28=\"\",\"\",VLOOKUP(AU28,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX28=\"\",\"\",VLOOKUP(AX28,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB28=\"\",\"\",VLOOKUP(BB28,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF28=\"\",\"\",VLOOKUP(BF28,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,{"$f":"IF(J29=\"\",\"\",VLOOKUP(J29,colour[],2,FALSE))","v":""},null,{"$f":"IF(L29=\"\",\"\",VLOOKUP(L29,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P29=\"\",\"\",VLOOKUP(P29,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R29=\"\",\"\",VLOOKUP(R29,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T29=\"\",\"\",VLOOKUP(T29,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V29=\"\",\"\",VLOOKUP(V29,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB29=\"\",\"\",VLOOKUP(AB29,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE29=\"\",\"\",VLOOKUP(AE29,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI29=\"\",\"\",VLOOKUP(AI29,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK29=\"\",\"\",VLOOKUP(AK29,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM29=\"\",\"\",VLOOKUP(AM29,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO29=\"\",\"\",VLOOKUP(AO29,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ29=\"\",\"\",VLOOKUP(AQ29,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS29=\"\",\"\",VLOOKUP(AS29,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU29=\"\",\"\",VLOOKUP(AU29,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX29=\"\",\"\",VLOOKUP(AX29,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB29=\"\",\"\",VLOOKUP(BB29,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF29=\"\",\"\",VLOOKUP(BF29,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,{"$f":"IF(J30=\"\",\"\",VLOOKUP(J30,colour[],2,FALSE))","v":""},null,{"$f":"IF(L30=\"\",\"\",VLOOKUP(L30,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P30=\"\",\"\",VLOOKUP(P30,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R30=\"\",\"\",VLOOKUP(R30,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T30=\"\",\"\",VLOOKUP(T30,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V30=\"\",\"\",VLOOKUP(V30,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB30=\"\",\"\",VLOOKUP(AB30,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE30=\"\",\"\",VLOOKUP(AE30,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI30=\"\",\"\",VLOOKUP(AI30,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK30=\"\",\"\",VLOOKUP(AK30,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM30=\"\",\"\",VLOOKUP(AM30,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO30=\"\",\"\",VLOOKUP(AO30,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ30=\"\",\"\",VLOOKUP(AQ30,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS30=\"\",\"\",VLOOKUP(AS30,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU30=\"\",\"\",VLOOKUP(AU30,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX30=\"\",\"\",VLOOKUP(AX30,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB30=\"\",\"\",VLOOKUP(BB30,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF30=\"\",\"\",VLOOKUP(BF30,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,{"$f":"IF(J31=\"\",\"\",VLOOKUP(J31,colour[],2,FALSE))","v":""},null,{"$f":"IF(L31=\"\",\"\",VLOOKUP(L31,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P31=\"\",\"\",VLOOKUP(P31,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R31=\"\",\"\",VLOOKUP(R31,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T31=\"\",\"\",VLOOKUP(T31,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V31=\"\",\"\",VLOOKUP(V31,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB31=\"\",\"\",VLOOKUP(AB31,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE31=\"\",\"\",VLOOKUP(AE31,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI31=\"\",\"\",VLOOKUP(AI31,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK31=\"\",\"\",VLOOKUP(AK31,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM31=\"\",\"\",VLOOKUP(AM31,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO31=\"\",\"\",VLOOKUP(AO31,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ31=\"\",\"\",VLOOKUP(AQ31,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS31=\"\",\"\",VLOOKUP(AS31,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU31=\"\",\"\",VLOOKUP(AU31,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX31=\"\",\"\",VLOOKUP(AX31,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB31=\"\",\"\",VLOOKUP(BB31,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF31=\"\",\"\",VLOOKUP(BF31,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,{"$f":"IF(J32=\"\",\"\",VLOOKUP(J32,colour[],2,FALSE))","v":""},null,{"$f":"IF(L32=\"\",\"\",VLOOKUP(L32,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P32=\"\",\"\",VLOOKUP(P32,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R32=\"\",\"\",VLOOKUP(R32,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T32=\"\",\"\",VLOOKUP(T32,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V32=\"\",\"\",VLOOKUP(V32,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB32=\"\",\"\",VLOOKUP(AB32,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE32=\"\",\"\",VLOOKUP(AE32,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI32=\"\",\"\",VLOOKUP(AI32,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK32=\"\",\"\",VLOOKUP(AK32,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM32=\"\",\"\",VLOOKUP(AM32,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO32=\"\",\"\",VLOOKUP(AO32,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ32=\"\",\"\",VLOOKUP(AQ32,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS32=\"\",\"\",VLOOKUP(AS32,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU32=\"\",\"\",VLOOKUP(AU32,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX32=\"\",\"\",VLOOKUP(AX32,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB32=\"\",\"\",VLOOKUP(BB32,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF32=\"\",\"\",VLOOKUP(BF32,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,{"$f":"IF(J33=\"\",\"\",VLOOKUP(J33,colour[],2,FALSE))","v":""},null,{"$f":"IF(L33=\"\",\"\",VLOOKUP(L33,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P33=\"\",\"\",VLOOKUP(P33,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R33=\"\",\"\",VLOOKUP(R33,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T33=\"\",\"\",VLOOKUP(T33,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V33=\"\",\"\",VLOOKUP(V33,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB33=\"\",\"\",VLOOKUP(AB33,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE33=\"\",\"\",VLOOKUP(AE33,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI33=\"\",\"\",VLOOKUP(AI33,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK33=\"\",\"\",VLOOKUP(AK33,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM33=\"\",\"\",VLOOKUP(AM33,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO33=\"\",\"\",VLOOKUP(AO33,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ33=\"\",\"\",VLOOKUP(AQ33,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS33=\"\",\"\",VLOOKUP(AS33,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU33=\"\",\"\",VLOOKUP(AU33,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX33=\"\",\"\",VLOOKUP(AX33,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB33=\"\",\"\",VLOOKUP(BB33,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF33=\"\",\"\",VLOOKUP(BF33,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,{"$f":"IF(J34=\"\",\"\",VLOOKUP(J34,colour[],2,FALSE))","v":""},null,{"$f":"IF(L34=\"\",\"\",VLOOKUP(L34,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P34=\"\",\"\",VLOOKUP(P34,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R34=\"\",\"\",VLOOKUP(R34,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T34=\"\",\"\",VLOOKUP(T34,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V34=\"\",\"\",VLOOKUP(V34,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB34=\"\",\"\",VLOOKUP(AB34,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE34=\"\",\"\",VLOOKUP(AE34,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI34=\"\",\"\",VLOOKUP(AI34,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK34=\"\",\"\",VLOOKUP(AK34,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM34=\"\",\"\",VLOOKUP(AM34,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO34=\"\",\"\",VLOOKUP(AO34,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ34=\"\",\"\",VLOOKUP(AQ34,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS34=\"\",\"\",VLOOKUP(AS34,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU34=\"\",\"\",VLOOKUP(AU34,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX34=\"\",\"\",VLOOKUP(AX34,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB34=\"\",\"\",VLOOKUP(BB34,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF34=\"\",\"\",VLOOKUP(BF34,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,{"$f":"IF(J35=\"\",\"\",VLOOKUP(J35,colour[],2,FALSE))","v":""},null,{"$f":"IF(L35=\"\",\"\",VLOOKUP(L35,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P35=\"\",\"\",VLOOKUP(P35,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R35=\"\",\"\",VLOOKUP(R35,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T35=\"\",\"\",VLOOKUP(T35,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V35=\"\",\"\",VLOOKUP(V35,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB35=\"\",\"\",VLOOKUP(AB35,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE35=\"\",\"\",VLOOKUP(AE35,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI35=\"\",\"\",VLOOKUP(AI35,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK35=\"\",\"\",VLOOKUP(AK35,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM35=\"\",\"\",VLOOKUP(AM35,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO35=\"\",\"\",VLOOKUP(AO35,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ35=\"\",\"\",VLOOKUP(AQ35,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS35=\"\",\"\",VLOOKUP(AS35,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU35=\"\",\"\",VLOOKUP(AU35,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX35=\"\",\"\",VLOOKUP(AX35,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB35=\"\",\"\",VLOOKUP(BB35,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF35=\"\",\"\",VLOOKUP(BF35,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,{"$f":"IF(J36=\"\",\"\",VLOOKUP(J36,colour[],2,FALSE))","v":""},null,{"$f":"IF(L36=\"\",\"\",VLOOKUP(L36,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P36=\"\",\"\",VLOOKUP(P36,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R36=\"\",\"\",VLOOKUP(R36,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T36=\"\",\"\",VLOOKUP(T36,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V36=\"\",\"\",VLOOKUP(V36,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB36=\"\",\"\",VLOOKUP(AB36,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE36=\"\",\"\",VLOOKUP(AE36,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI36=\"\",\"\",VLOOKUP(AI36,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK36=\"\",\"\",VLOOKUP(AK36,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM36=\"\",\"\",VLOOKUP(AM36,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO36=\"\",\"\",VLOOKUP(AO36,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ36=\"\",\"\",VLOOKUP(AQ36,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS36=\"\",\"\",VLOOKUP(AS36,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU36=\"\",\"\",VLOOKUP(AU36,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX36=\"\",\"\",VLOOKUP(AX36,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB36=\"\",\"\",VLOOKUP(BB36,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF36=\"\",\"\",VLOOKUP(BF36,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,{"$f":"IF(J37=\"\",\"\",VLOOKUP(J37,colour[],2,FALSE))","v":""},null,{"$f":"IF(L37=\"\",\"\",VLOOKUP(L37,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P37=\"\",\"\",VLOOKUP(P37,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R37=\"\",\"\",VLOOKUP(R37,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T37=\"\",\"\",VLOOKUP(T37,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V37=\"\",\"\",VLOOKUP(V37,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB37=\"\",\"\",VLOOKUP(AB37,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE37=\"\",\"\",VLOOKUP(AE37,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI37=\"\",\"\",VLOOKUP(AI37,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK37=\"\",\"\",VLOOKUP(AK37,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM37=\"\",\"\",VLOOKUP(AM37,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO37=\"\",\"\",VLOOKUP(AO37,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ37=\"\",\"\",VLOOKUP(AQ37,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS37=\"\",\"\",VLOOKUP(AS37,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU37=\"\",\"\",VLOOKUP(AU37,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX37=\"\",\"\",VLOOKUP(AX37,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB37=\"\",\"\",VLOOKUP(BB37,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF37=\"\",\"\",VLOOKUP(BF37,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,{"$f":"IF(J38=\"\",\"\",VLOOKUP(J38,colour[],2,FALSE))","v":""},null,{"$f":"IF(L38=\"\",\"\",VLOOKUP(L38,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P38=\"\",\"\",VLOOKUP(P38,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R38=\"\",\"\",VLOOKUP(R38,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T38=\"\",\"\",VLOOKUP(T38,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V38=\"\",\"\",VLOOKUP(V38,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB38=\"\",\"\",VLOOKUP(AB38,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE38=\"\",\"\",VLOOKUP(AE38,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI38=\"\",\"\",VLOOKUP(AI38,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK38=\"\",\"\",VLOOKUP(AK38,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM38=\"\",\"\",VLOOKUP(AM38,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO38=\"\",\"\",VLOOKUP(AO38,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ38=\"\",\"\",VLOOKUP(AQ38,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS38=\"\",\"\",VLOOKUP(AS38,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU38=\"\",\"\",VLOOKUP(AU38,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX38=\"\",\"\",VLOOKUP(AX38,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB38=\"\",\"\",VLOOKUP(BB38,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF38=\"\",\"\",VLOOKUP(BF38,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,{"$f":"IF(J39=\"\",\"\",VLOOKUP(J39,colour[],2,FALSE))","v":""},null,{"$f":"IF(L39=\"\",\"\",VLOOKUP(L39,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P39=\"\",\"\",VLOOKUP(P39,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R39=\"\",\"\",VLOOKUP(R39,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T39=\"\",\"\",VLOOKUP(T39,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V39=\"\",\"\",VLOOKUP(V39,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB39=\"\",\"\",VLOOKUP(AB39,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE39=\"\",\"\",VLOOKUP(AE39,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI39=\"\",\"\",VLOOKUP(AI39,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK39=\"\",\"\",VLOOKUP(AK39,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM39=\"\",\"\",VLOOKUP(AM39,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO39=\"\",\"\",VLOOKUP(AO39,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ39=\"\",\"\",VLOOKUP(AQ39,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS39=\"\",\"\",VLOOKUP(AS39,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU39=\"\",\"\",VLOOKUP(AU39,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX39=\"\",\"\",VLOOKUP(AX39,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB39=\"\",\"\",VLOOKUP(BB39,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF39=\"\",\"\",VLOOKUP(BF39,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,{"$f":"IF(J40=\"\",\"\",VLOOKUP(J40,colour[],2,FALSE))","v":""},null,{"$f":"IF(L40=\"\",\"\",VLOOKUP(L40,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P40=\"\",\"\",VLOOKUP(P40,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R40=\"\",\"\",VLOOKUP(R40,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T40=\"\",\"\",VLOOKUP(T40,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V40=\"\",\"\",VLOOKUP(V40,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB40=\"\",\"\",VLOOKUP(AB40,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE40=\"\",\"\",VLOOKUP(AE40,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI40=\"\",\"\",VLOOKUP(AI40,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK40=\"\",\"\",VLOOKUP(AK40,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM40=\"\",\"\",VLOOKUP(AM40,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO40=\"\",\"\",VLOOKUP(AO40,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ40=\"\",\"\",VLOOKUP(AQ40,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS40=\"\",\"\",VLOOKUP(AS40,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU40=\"\",\"\",VLOOKUP(AU40,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX40=\"\",\"\",VLOOKUP(AX40,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB40=\"\",\"\",VLOOKUP(BB40,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF40=\"\",\"\",VLOOKUP(BF40,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,{"$f":"IF(J41=\"\",\"\",VLOOKUP(J41,colour[],2,FALSE))","v":""},null,{"$f":"IF(L41=\"\",\"\",VLOOKUP(L41,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P41=\"\",\"\",VLOOKUP(P41,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R41=\"\",\"\",VLOOKUP(R41,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T41=\"\",\"\",VLOOKUP(T41,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V41=\"\",\"\",VLOOKUP(V41,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB41=\"\",\"\",VLOOKUP(AB41,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE41=\"\",\"\",VLOOKUP(AE41,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI41=\"\",\"\",VLOOKUP(AI41,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK41=\"\",\"\",VLOOKUP(AK41,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM41=\"\",\"\",VLOOKUP(AM41,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO41=\"\",\"\",VLOOKUP(AO41,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ41=\"\",\"\",VLOOKUP(AQ41,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS41=\"\",\"\",VLOOKUP(AS41,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU41=\"\",\"\",VLOOKUP(AU41,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX41=\"\",\"\",VLOOKUP(AX41,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB41=\"\",\"\",VLOOKUP(BB41,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF41=\"\",\"\",VLOOKUP(BF41,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,{"$f":"IF(J42=\"\",\"\",VLOOKUP(J42,colour[],2,FALSE))","v":""},null,{"$f":"IF(L42=\"\",\"\",VLOOKUP(L42,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P42=\"\",\"\",VLOOKUP(P42,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R42=\"\",\"\",VLOOKUP(R42,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T42=\"\",\"\",VLOOKUP(T42,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V42=\"\",\"\",VLOOKUP(V42,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB42=\"\",\"\",VLOOKUP(AB42,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE42=\"\",\"\",VLOOKUP(AE42,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI42=\"\",\"\",VLOOKUP(AI42,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK42=\"\",\"\",VLOOKUP(AK42,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM42=\"\",\"\",VLOOKUP(AM42,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO42=\"\",\"\",VLOOKUP(AO42,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ42=\"\",\"\",VLOOKUP(AQ42,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS42=\"\",\"\",VLOOKUP(AS42,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU42=\"\",\"\",VLOOKUP(AU42,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX42=\"\",\"\",VLOOKUP(AX42,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB42=\"\",\"\",VLOOKUP(BB42,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF42=\"\",\"\",VLOOKUP(BF42,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,{"$f":"IF(J43=\"\",\"\",VLOOKUP(J43,colour[],2,FALSE))","v":""},null,{"$f":"IF(L43=\"\",\"\",VLOOKUP(L43,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P43=\"\",\"\",VLOOKUP(P43,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R43=\"\",\"\",VLOOKUP(R43,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T43=\"\",\"\",VLOOKUP(T43,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V43=\"\",\"\",VLOOKUP(V43,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB43=\"\",\"\",VLOOKUP(AB43,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE43=\"\",\"\",VLOOKUP(AE43,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI43=\"\",\"\",VLOOKUP(AI43,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK43=\"\",\"\",VLOOKUP(AK43,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM43=\"\",\"\",VLOOKUP(AM43,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO43=\"\",\"\",VLOOKUP(AO43,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ43=\"\",\"\",VLOOKUP(AQ43,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS43=\"\",\"\",VLOOKUP(AS43,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU43=\"\",\"\",VLOOKUP(AU43,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX43=\"\",\"\",VLOOKUP(AX43,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB43=\"\",\"\",VLOOKUP(BB43,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF43=\"\",\"\",VLOOKUP(BF43,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,{"$f":"IF(J44=\"\",\"\",VLOOKUP(J44,colour[],2,FALSE))","v":""},null,{"$f":"IF(L44=\"\",\"\",VLOOKUP(L44,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P44=\"\",\"\",VLOOKUP(P44,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R44=\"\",\"\",VLOOKUP(R44,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T44=\"\",\"\",VLOOKUP(T44,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V44=\"\",\"\",VLOOKUP(V44,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB44=\"\",\"\",VLOOKUP(AB44,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE44=\"\",\"\",VLOOKUP(AE44,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI44=\"\",\"\",VLOOKUP(AI44,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK44=\"\",\"\",VLOOKUP(AK44,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM44=\"\",\"\",VLOOKUP(AM44,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO44=\"\",\"\",VLOOKUP(AO44,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ44=\"\",\"\",VLOOKUP(AQ44,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS44=\"\",\"\",VLOOKUP(AS44,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU44=\"\",\"\",VLOOKUP(AU44,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX44=\"\",\"\",VLOOKUP(AX44,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB44=\"\",\"\",VLOOKUP(BB44,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF44=\"\",\"\",VLOOKUP(BF44,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,{"$f":"IF(J45=\"\",\"\",VLOOKUP(J45,colour[],2,FALSE))","v":""},null,{"$f":"IF(L45=\"\",\"\",VLOOKUP(L45,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P45=\"\",\"\",VLOOKUP(P45,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R45=\"\",\"\",VLOOKUP(R45,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T45=\"\",\"\",VLOOKUP(T45,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V45=\"\",\"\",VLOOKUP(V45,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB45=\"\",\"\",VLOOKUP(AB45,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE45=\"\",\"\",VLOOKUP(AE45,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI45=\"\",\"\",VLOOKUP(AI45,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK45=\"\",\"\",VLOOKUP(AK45,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM45=\"\",\"\",VLOOKUP(AM45,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO45=\"\",\"\",VLOOKUP(AO45,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ45=\"\",\"\",VLOOKUP(AQ45,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS45=\"\",\"\",VLOOKUP(AS45,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU45=\"\",\"\",VLOOKUP(AU45,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX45=\"\",\"\",VLOOKUP(AX45,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB45=\"\",\"\",VLOOKUP(BB45,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF45=\"\",\"\",VLOOKUP(BF45,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,{"$f":"IF(J46=\"\",\"\",VLOOKUP(J46,colour[],2,FALSE))","v":""},null,{"$f":"IF(L46=\"\",\"\",VLOOKUP(L46,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P46=\"\",\"\",VLOOKUP(P46,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R46=\"\",\"\",VLOOKUP(R46,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T46=\"\",\"\",VLOOKUP(T46,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V46=\"\",\"\",VLOOKUP(V46,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB46=\"\",\"\",VLOOKUP(AB46,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE46=\"\",\"\",VLOOKUP(AE46,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI46=\"\",\"\",VLOOKUP(AI46,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK46=\"\",\"\",VLOOKUP(AK46,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM46=\"\",\"\",VLOOKUP(AM46,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO46=\"\",\"\",VLOOKUP(AO46,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ46=\"\",\"\",VLOOKUP(AQ46,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS46=\"\",\"\",VLOOKUP(AS46,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU46=\"\",\"\",VLOOKUP(AU46,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX46=\"\",\"\",VLOOKUP(AX46,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB46=\"\",\"\",VLOOKUP(BB46,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF46=\"\",\"\",VLOOKUP(BF46,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,{"$f":"IF(J47=\"\",\"\",VLOOKUP(J47,colour[],2,FALSE))","v":""},null,{"$f":"IF(L47=\"\",\"\",VLOOKUP(L47,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P47=\"\",\"\",VLOOKUP(P47,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R47=\"\",\"\",VLOOKUP(R47,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T47=\"\",\"\",VLOOKUP(T47,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V47=\"\",\"\",VLOOKUP(V47,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB47=\"\",\"\",VLOOKUP(AB47,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE47=\"\",\"\",VLOOKUP(AE47,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI47=\"\",\"\",VLOOKUP(AI47,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK47=\"\",\"\",VLOOKUP(AK47,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM47=\"\",\"\",VLOOKUP(AM47,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO47=\"\",\"\",VLOOKUP(AO47,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ47=\"\",\"\",VLOOKUP(AQ47,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS47=\"\",\"\",VLOOKUP(AS47,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU47=\"\",\"\",VLOOKUP(AU47,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX47=\"\",\"\",VLOOKUP(AX47,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB47=\"\",\"\",VLOOKUP(BB47,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF47=\"\",\"\",VLOOKUP(BF47,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,{"$f":"IF(J48=\"\",\"\",VLOOKUP(J48,colour[],2,FALSE))","v":""},null,{"$f":"IF(L48=\"\",\"\",VLOOKUP(L48,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P48=\"\",\"\",VLOOKUP(P48,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R48=\"\",\"\",VLOOKUP(R48,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T48=\"\",\"\",VLOOKUP(T48,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V48=\"\",\"\",VLOOKUP(V48,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB48=\"\",\"\",VLOOKUP(AB48,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE48=\"\",\"\",VLOOKUP(AE48,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI48=\"\",\"\",VLOOKUP(AI48,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK48=\"\",\"\",VLOOKUP(AK48,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM48=\"\",\"\",VLOOKUP(AM48,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO48=\"\",\"\",VLOOKUP(AO48,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ48=\"\",\"\",VLOOKUP(AQ48,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS48=\"\",\"\",VLOOKUP(AS48,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU48=\"\",\"\",VLOOKUP(AU48,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX48=\"\",\"\",VLOOKUP(AX48,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB48=\"\",\"\",VLOOKUP(BB48,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF48=\"\",\"\",VLOOKUP(BF48,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F49=\"\",\"\",VLOOKUP(F49,type[],2,FALSE))","v":""},null,{"$f":"IF(H49=\"\",\"\",VLOOKUP(H49,material[],2,FALSE))","v":""},null,{"$f":"IF(J49=\"\",\"\",VLOOKUP(J49,colour[],2,FALSE))","v":""},null,{"$f":"IF(L49=\"\",\"\",VLOOKUP(L49,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P49=\"\",\"\",VLOOKUP(P49,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R49=\"\",\"\",VLOOKUP(R49,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T49=\"\",\"\",VLOOKUP(T49,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V49=\"\",\"\",VLOOKUP(V49,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB49=\"\",\"\",VLOOKUP(AB49,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE49=\"\",\"\",VLOOKUP(AE49,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI49=\"\",\"\",VLOOKUP(AI49,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK49=\"\",\"\",VLOOKUP(AK49,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM49=\"\",\"\",VLOOKUP(AM49,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO49=\"\",\"\",VLOOKUP(AO49,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ49=\"\",\"\",VLOOKUP(AQ49,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS49=\"\",\"\",VLOOKUP(AS49,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU49=\"\",\"\",VLOOKUP(AU49,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX49=\"\",\"\",VLOOKUP(AX49,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB49=\"\",\"\",VLOOKUP(BB49,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF49=\"\",\"\",VLOOKUP(BF49,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F50=\"\",\"\",VLOOKUP(F50,type[],2,FALSE))","v":""},null,{"$f":"IF(H50=\"\",\"\",VLOOKUP(H50,material[],2,FALSE))","v":""},null,{"$f":"IF(J50=\"\",\"\",VLOOKUP(J50,colour[],2,FALSE))","v":""},null,{"$f":"IF(L50=\"\",\"\",VLOOKUP(L50,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P50=\"\",\"\",VLOOKUP(P50,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R50=\"\",\"\",VLOOKUP(R50,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T50=\"\",\"\",VLOOKUP(T50,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V50=\"\",\"\",VLOOKUP(V50,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB50=\"\",\"\",VLOOKUP(AB50,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE50=\"\",\"\",VLOOKUP(AE50,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI50=\"\",\"\",VLOOKUP(AI50,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK50=\"\",\"\",VLOOKUP(AK50,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM50=\"\",\"\",VLOOKUP(AM50,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO50=\"\",\"\",VLOOKUP(AO50,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ50=\"\",\"\",VLOOKUP(AQ50,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS50=\"\",\"\",VLOOKUP(AS50,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU50=\"\",\"\",VLOOKUP(AU50,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX50=\"\",\"\",VLOOKUP(AX50,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB50=\"\",\"\",VLOOKUP(BB50,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF50=\"\",\"\",VLOOKUP(BF50,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F51=\"\",\"\",VLOOKUP(F51,type[],2,FALSE))","v":""},null,{"$f":"IF(H51=\"\",\"\",VLOOKUP(H51,material[],2,FALSE))","v":""},null,{"$f":"IF(J51=\"\",\"\",VLOOKUP(J51,colour[],2,FALSE))","v":""},null,{"$f":"IF(L51=\"\",\"\",VLOOKUP(L51,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P51=\"\",\"\",VLOOKUP(P51,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R51=\"\",\"\",VLOOKUP(R51,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T51=\"\",\"\",VLOOKUP(T51,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V51=\"\",\"\",VLOOKUP(V51,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB51=\"\",\"\",VLOOKUP(AB51,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE51=\"\",\"\",VLOOKUP(AE51,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI51=\"\",\"\",VLOOKUP(AI51,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK51=\"\",\"\",VLOOKUP(AK51,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM51=\"\",\"\",VLOOKUP(AM51,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO51=\"\",\"\",VLOOKUP(AO51,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ51=\"\",\"\",VLOOKUP(AQ51,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS51=\"\",\"\",VLOOKUP(AS51,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU51=\"\",\"\",VLOOKUP(AU51,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX51=\"\",\"\",VLOOKUP(AX51,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB51=\"\",\"\",VLOOKUP(BB51,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF51=\"\",\"\",VLOOKUP(BF51,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F52=\"\",\"\",VLOOKUP(F52,type[],2,FALSE))","v":""},null,{"$f":"IF(H52=\"\",\"\",VLOOKUP(H52,material[],2,FALSE))","v":""},null,{"$f":"IF(J52=\"\",\"\",VLOOKUP(J52,colour[],2,FALSE))","v":""},null,{"$f":"IF(L52=\"\",\"\",VLOOKUP(L52,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P52=\"\",\"\",VLOOKUP(P52,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R52=\"\",\"\",VLOOKUP(R52,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T52=\"\",\"\",VLOOKUP(T52,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V52=\"\",\"\",VLOOKUP(V52,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB52=\"\",\"\",VLOOKUP(AB52,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE52=\"\",\"\",VLOOKUP(AE52,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI52=\"\",\"\",VLOOKUP(AI52,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK52=\"\",\"\",VLOOKUP(AK52,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM52=\"\",\"\",VLOOKUP(AM52,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO52=\"\",\"\",VLOOKUP(AO52,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ52=\"\",\"\",VLOOKUP(AQ52,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS52=\"\",\"\",VLOOKUP(AS52,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU52=\"\",\"\",VLOOKUP(AU52,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX52=\"\",\"\",VLOOKUP(AX52,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB52=\"\",\"\",VLOOKUP(BB52,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF52=\"\",\"\",VLOOKUP(BF52,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F53=\"\",\"\",VLOOKUP(F53,type[],2,FALSE))","v":""},null,{"$f":"IF(H53=\"\",\"\",VLOOKUP(H53,material[],2,FALSE))","v":""},null,{"$f":"IF(J53=\"\",\"\",VLOOKUP(J53,colour[],2,FALSE))","v":""},null,{"$f":"IF(L53=\"\",\"\",VLOOKUP(L53,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P53=\"\",\"\",VLOOKUP(P53,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R53=\"\",\"\",VLOOKUP(R53,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T53=\"\",\"\",VLOOKUP(T53,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V53=\"\",\"\",VLOOKUP(V53,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB53=\"\",\"\",VLOOKUP(AB53,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE53=\"\",\"\",VLOOKUP(AE53,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI53=\"\",\"\",VLOOKUP(AI53,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK53=\"\",\"\",VLOOKUP(AK53,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM53=\"\",\"\",VLOOKUP(AM53,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO53=\"\",\"\",VLOOKUP(AO53,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ53=\"\",\"\",VLOOKUP(AQ53,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS53=\"\",\"\",VLOOKUP(AS53,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU53=\"\",\"\",VLOOKUP(AU53,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX53=\"\",\"\",VLOOKUP(AX53,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB53=\"\",\"\",VLOOKUP(BB53,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF53=\"\",\"\",VLOOKUP(BF53,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F54=\"\",\"\",VLOOKUP(F54,type[],2,FALSE))","v":""},null,{"$f":"IF(H54=\"\",\"\",VLOOKUP(H54,material[],2,FALSE))","v":""},null,{"$f":"IF(J54=\"\",\"\",VLOOKUP(J54,colour[],2,FALSE))","v":""},null,{"$f":"IF(L54=\"\",\"\",VLOOKUP(L54,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P54=\"\",\"\",VLOOKUP(P54,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R54=\"\",\"\",VLOOKUP(R54,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T54=\"\",\"\",VLOOKUP(T54,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V54=\"\",\"\",VLOOKUP(V54,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB54=\"\",\"\",VLOOKUP(AB54,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE54=\"\",\"\",VLOOKUP(AE54,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI54=\"\",\"\",VLOOKUP(AI54,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK54=\"\",\"\",VLOOKUP(AK54,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM54=\"\",\"\",VLOOKUP(AM54,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO54=\"\",\"\",VLOOKUP(AO54,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ54=\"\",\"\",VLOOKUP(AQ54,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS54=\"\",\"\",VLOOKUP(AS54,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU54=\"\",\"\",VLOOKUP(AU54,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX54=\"\",\"\",VLOOKUP(AX54,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB54=\"\",\"\",VLOOKUP(BB54,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF54=\"\",\"\",VLOOKUP(BF54,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F55=\"\",\"\",VLOOKUP(F55,type[],2,FALSE))","v":""},null,{"$f":"IF(H55=\"\",\"\",VLOOKUP(H55,material[],2,FALSE))","v":""},null,{"$f":"IF(J55=\"\",\"\",VLOOKUP(J55,colour[],2,FALSE))","v":""},null,{"$f":"IF(L55=\"\",\"\",VLOOKUP(L55,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P55=\"\",\"\",VLOOKUP(P55,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R55=\"\",\"\",VLOOKUP(R55,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T55=\"\",\"\",VLOOKUP(T55,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V55=\"\",\"\",VLOOKUP(V55,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB55=\"\",\"\",VLOOKUP(AB55,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE55=\"\",\"\",VLOOKUP(AE55,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI55=\"\",\"\",VLOOKUP(AI55,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK55=\"\",\"\",VLOOKUP(AK55,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM55=\"\",\"\",VLOOKUP(AM55,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO55=\"\",\"\",VLOOKUP(AO55,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ55=\"\",\"\",VLOOKUP(AQ55,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS55=\"\",\"\",VLOOKUP(AS55,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU55=\"\",\"\",VLOOKUP(AU55,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX55=\"\",\"\",VLOOKUP(AX55,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB55=\"\",\"\",VLOOKUP(BB55,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF55=\"\",\"\",VLOOKUP(BF55,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F56=\"\",\"\",VLOOKUP(F56,type[],2,FALSE))","v":""},null,{"$f":"IF(H56=\"\",\"\",VLOOKUP(H56,material[],2,FALSE))","v":""},null,{"$f":"IF(J56=\"\",\"\",VLOOKUP(J56,colour[],2,FALSE))","v":""},null,{"$f":"IF(L56=\"\",\"\",VLOOKUP(L56,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P56=\"\",\"\",VLOOKUP(P56,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R56=\"\",\"\",VLOOKUP(R56,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T56=\"\",\"\",VLOOKUP(T56,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V56=\"\",\"\",VLOOKUP(V56,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB56=\"\",\"\",VLOOKUP(AB56,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE56=\"\",\"\",VLOOKUP(AE56,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI56=\"\",\"\",VLOOKUP(AI56,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK56=\"\",\"\",VLOOKUP(AK56,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM56=\"\",\"\",VLOOKUP(AM56,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO56=\"\",\"\",VLOOKUP(AO56,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ56=\"\",\"\",VLOOKUP(AQ56,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS56=\"\",\"\",VLOOKUP(AS56,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU56=\"\",\"\",VLOOKUP(AU56,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX56=\"\",\"\",VLOOKUP(AX56,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB56=\"\",\"\",VLOOKUP(BB56,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF56=\"\",\"\",VLOOKUP(BF56,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F57=\"\",\"\",VLOOKUP(F57,type[],2,FALSE))","v":""},null,{"$f":"IF(H57=\"\",\"\",VLOOKUP(H57,material[],2,FALSE))","v":""},null,{"$f":"IF(J57=\"\",\"\",VLOOKUP(J57,colour[],2,FALSE))","v":""},null,{"$f":"IF(L57=\"\",\"\",VLOOKUP(L57,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P57=\"\",\"\",VLOOKUP(P57,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R57=\"\",\"\",VLOOKUP(R57,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T57=\"\",\"\",VLOOKUP(T57,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V57=\"\",\"\",VLOOKUP(V57,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB57=\"\",\"\",VLOOKUP(AB57,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE57=\"\",\"\",VLOOKUP(AE57,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI57=\"\",\"\",VLOOKUP(AI57,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK57=\"\",\"\",VLOOKUP(AK57,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM57=\"\",\"\",VLOOKUP(AM57,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO57=\"\",\"\",VLOOKUP(AO57,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ57=\"\",\"\",VLOOKUP(AQ57,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS57=\"\",\"\",VLOOKUP(AS57,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU57=\"\",\"\",VLOOKUP(AU57,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX57=\"\",\"\",VLOOKUP(AX57,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB57=\"\",\"\",VLOOKUP(BB57,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF57=\"\",\"\",VLOOKUP(BF57,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F58=\"\",\"\",VLOOKUP(F58,type[],2,FALSE))","v":""},null,{"$f":"IF(H58=\"\",\"\",VLOOKUP(H58,material[],2,FALSE))","v":""},null,{"$f":"IF(J58=\"\",\"\",VLOOKUP(J58,colour[],2,FALSE))","v":""},null,{"$f":"IF(L58=\"\",\"\",VLOOKUP(L58,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P58=\"\",\"\",VLOOKUP(P58,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R58=\"\",\"\",VLOOKUP(R58,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T58=\"\",\"\",VLOOKUP(T58,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V58=\"\",\"\",VLOOKUP(V58,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB58=\"\",\"\",VLOOKUP(AB58,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE58=\"\",\"\",VLOOKUP(AE58,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI58=\"\",\"\",VLOOKUP(AI58,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK58=\"\",\"\",VLOOKUP(AK58,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM58=\"\",\"\",VLOOKUP(AM58,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO58=\"\",\"\",VLOOKUP(AO58,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ58=\"\",\"\",VLOOKUP(AQ58,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS58=\"\",\"\",VLOOKUP(AS58,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU58=\"\",\"\",VLOOKUP(AU58,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX58=\"\",\"\",VLOOKUP(AX58,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB58=\"\",\"\",VLOOKUP(BB58,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF58=\"\",\"\",VLOOKUP(BF58,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F59=\"\",\"\",VLOOKUP(F59,type[],2,FALSE))","v":""},null,{"$f":"IF(H59=\"\",\"\",VLOOKUP(H59,material[],2,FALSE))","v":""},null,{"$f":"IF(J59=\"\",\"\",VLOOKUP(J59,colour[],2,FALSE))","v":""},null,{"$f":"IF(L59=\"\",\"\",VLOOKUP(L59,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P59=\"\",\"\",VLOOKUP(P59,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R59=\"\",\"\",VLOOKUP(R59,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T59=\"\",\"\",VLOOKUP(T59,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V59=\"\",\"\",VLOOKUP(V59,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB59=\"\",\"\",VLOOKUP(AB59,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE59=\"\",\"\",VLOOKUP(AE59,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI59=\"\",\"\",VLOOKUP(AI59,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK59=\"\",\"\",VLOOKUP(AK59,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM59=\"\",\"\",VLOOKUP(AM59,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO59=\"\",\"\",VLOOKUP(AO59,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ59=\"\",\"\",VLOOKUP(AQ59,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS59=\"\",\"\",VLOOKUP(AS59,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU59=\"\",\"\",VLOOKUP(AU59,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX59=\"\",\"\",VLOOKUP(AX59,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB59=\"\",\"\",VLOOKUP(BB59,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF59=\"\",\"\",VLOOKUP(BF59,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F60=\"\",\"\",VLOOKUP(F60,type[],2,FALSE))","v":""},null,{"$f":"IF(H60=\"\",\"\",VLOOKUP(H60,material[],2,FALSE))","v":""},null,{"$f":"IF(J60=\"\",\"\",VLOOKUP(J60,colour[],2,FALSE))","v":""},null,{"$f":"IF(L60=\"\",\"\",VLOOKUP(L60,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P60=\"\",\"\",VLOOKUP(P60,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R60=\"\",\"\",VLOOKUP(R60,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T60=\"\",\"\",VLOOKUP(T60,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V60=\"\",\"\",VLOOKUP(V60,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB60=\"\",\"\",VLOOKUP(AB60,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE60=\"\",\"\",VLOOKUP(AE60,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI60=\"\",\"\",VLOOKUP(AI60,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK60=\"\",\"\",VLOOKUP(AK60,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM60=\"\",\"\",VLOOKUP(AM60,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO60=\"\",\"\",VLOOKUP(AO60,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ60=\"\",\"\",VLOOKUP(AQ60,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS60=\"\",\"\",VLOOKUP(AS60,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU60=\"\",\"\",VLOOKUP(AU60,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX60=\"\",\"\",VLOOKUP(AX60,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB60=\"\",\"\",VLOOKUP(BB60,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF60=\"\",\"\",VLOOKUP(BF60,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F61=\"\",\"\",VLOOKUP(F61,type[],2,FALSE))","v":""},null,{"$f":"IF(H61=\"\",\"\",VLOOKUP(H61,material[],2,FALSE))","v":""},null,{"$f":"IF(J61=\"\",\"\",VLOOKUP(J61,colour[],2,FALSE))","v":""},null,{"$f":"IF(L61=\"\",\"\",VLOOKUP(L61,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P61=\"\",\"\",VLOOKUP(P61,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R61=\"\",\"\",VLOOKUP(R61,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T61=\"\",\"\",VLOOKUP(T61,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V61=\"\",\"\",VLOOKUP(V61,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB61=\"\",\"\",VLOOKUP(AB61,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE61=\"\",\"\",VLOOKUP(AE61,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI61=\"\",\"\",VLOOKUP(AI61,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK61=\"\",\"\",VLOOKUP(AK61,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM61=\"\",\"\",VLOOKUP(AM61,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO61=\"\",\"\",VLOOKUP(AO61,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ61=\"\",\"\",VLOOKUP(AQ61,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS61=\"\",\"\",VLOOKUP(AS61,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU61=\"\",\"\",VLOOKUP(AU61,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX61=\"\",\"\",VLOOKUP(AX61,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB61=\"\",\"\",VLOOKUP(BB61,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF61=\"\",\"\",VLOOKUP(BF61,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F62=\"\",\"\",VLOOKUP(F62,type[],2,FALSE))","v":""},null,{"$f":"IF(H62=\"\",\"\",VLOOKUP(H62,material[],2,FALSE))","v":""},null,{"$f":"IF(J62=\"\",\"\",VLOOKUP(J62,colour[],2,FALSE))","v":""},null,{"$f":"IF(L62=\"\",\"\",VLOOKUP(L62,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P62=\"\",\"\",VLOOKUP(P62,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R62=\"\",\"\",VLOOKUP(R62,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T62=\"\",\"\",VLOOKUP(T62,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V62=\"\",\"\",VLOOKUP(V62,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB62=\"\",\"\",VLOOKUP(AB62,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE62=\"\",\"\",VLOOKUP(AE62,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI62=\"\",\"\",VLOOKUP(AI62,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK62=\"\",\"\",VLOOKUP(AK62,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM62=\"\",\"\",VLOOKUP(AM62,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO62=\"\",\"\",VLOOKUP(AO62,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ62=\"\",\"\",VLOOKUP(AQ62,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS62=\"\",\"\",VLOOKUP(AS62,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU62=\"\",\"\",VLOOKUP(AU62,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX62=\"\",\"\",VLOOKUP(AX62,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB62=\"\",\"\",VLOOKUP(BB62,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF62=\"\",\"\",VLOOKUP(BF62,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F63=\"\",\"\",VLOOKUP(F63,type[],2,FALSE))","v":""},null,{"$f":"IF(H63=\"\",\"\",VLOOKUP(H63,material[],2,FALSE))","v":""},null,{"$f":"IF(J63=\"\",\"\",VLOOKUP(J63,colour[],2,FALSE))","v":""},null,{"$f":"IF(L63=\"\",\"\",VLOOKUP(L63,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P63=\"\",\"\",VLOOKUP(P63,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R63=\"\",\"\",VLOOKUP(R63,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T63=\"\",\"\",VLOOKUP(T63,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V63=\"\",\"\",VLOOKUP(V63,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB63=\"\",\"\",VLOOKUP(AB63,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE63=\"\",\"\",VLOOKUP(AE63,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI63=\"\",\"\",VLOOKUP(AI63,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK63=\"\",\"\",VLOOKUP(AK63,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM63=\"\",\"\",VLOOKUP(AM63,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO63=\"\",\"\",VLOOKUP(AO63,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ63=\"\",\"\",VLOOKUP(AQ63,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS63=\"\",\"\",VLOOKUP(AS63,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU63=\"\",\"\",VLOOKUP(AU63,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX63=\"\",\"\",VLOOKUP(AX63,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB63=\"\",\"\",VLOOKUP(BB63,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF63=\"\",\"\",VLOOKUP(BF63,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F64=\"\",\"\",VLOOKUP(F64,type[],2,FALSE))","v":""},null,{"$f":"IF(H64=\"\",\"\",VLOOKUP(H64,material[],2,FALSE))","v":""},null,{"$f":"IF(J64=\"\",\"\",VLOOKUP(J64,colour[],2,FALSE))","v":""},null,{"$f":"IF(L64=\"\",\"\",VLOOKUP(L64,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P64=\"\",\"\",VLOOKUP(P64,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R64=\"\",\"\",VLOOKUP(R64,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T64=\"\",\"\",VLOOKUP(T64,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V64=\"\",\"\",VLOOKUP(V64,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB64=\"\",\"\",VLOOKUP(AB64,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE64=\"\",\"\",VLOOKUP(AE64,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI64=\"\",\"\",VLOOKUP(AI64,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK64=\"\",\"\",VLOOKUP(AK64,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM64=\"\",\"\",VLOOKUP(AM64,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO64=\"\",\"\",VLOOKUP(AO64,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ64=\"\",\"\",VLOOKUP(AQ64,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS64=\"\",\"\",VLOOKUP(AS64,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU64=\"\",\"\",VLOOKUP(AU64,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX64=\"\",\"\",VLOOKUP(AX64,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB64=\"\",\"\",VLOOKUP(BB64,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF64=\"\",\"\",VLOOKUP(BF64,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F65=\"\",\"\",VLOOKUP(F65,type[],2,FALSE))","v":""},null,{"$f":"IF(H65=\"\",\"\",VLOOKUP(H65,material[],2,FALSE))","v":""},null,{"$f":"IF(J65=\"\",\"\",VLOOKUP(J65,colour[],2,FALSE))","v":""},null,{"$f":"IF(L65=\"\",\"\",VLOOKUP(L65,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P65=\"\",\"\",VLOOKUP(P65,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R65=\"\",\"\",VLOOKUP(R65,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T65=\"\",\"\",VLOOKUP(T65,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V65=\"\",\"\",VLOOKUP(V65,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB65=\"\",\"\",VLOOKUP(AB65,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE65=\"\",\"\",VLOOKUP(AE65,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI65=\"\",\"\",VLOOKUP(AI65,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK65=\"\",\"\",VLOOKUP(AK65,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM65=\"\",\"\",VLOOKUP(AM65,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO65=\"\",\"\",VLOOKUP(AO65,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ65=\"\",\"\",VLOOKUP(AQ65,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS65=\"\",\"\",VLOOKUP(AS65,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU65=\"\",\"\",VLOOKUP(AU65,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX65=\"\",\"\",VLOOKUP(AX65,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB65=\"\",\"\",VLOOKUP(BB65,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF65=\"\",\"\",VLOOKUP(BF65,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F66=\"\",\"\",VLOOKUP(F66,type[],2,FALSE))","v":""},null,{"$f":"IF(H66=\"\",\"\",VLOOKUP(H66,material[],2,FALSE))","v":""},null,{"$f":"IF(J66=\"\",\"\",VLOOKUP(J66,colour[],2,FALSE))","v":""},null,{"$f":"IF(L66=\"\",\"\",VLOOKUP(L66,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P66=\"\",\"\",VLOOKUP(P66,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R66=\"\",\"\",VLOOKUP(R66,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T66=\"\",\"\",VLOOKUP(T66,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V66=\"\",\"\",VLOOKUP(V66,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB66=\"\",\"\",VLOOKUP(AB66,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE66=\"\",\"\",VLOOKUP(AE66,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI66=\"\",\"\",VLOOKUP(AI66,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK66=\"\",\"\",VLOOKUP(AK66,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM66=\"\",\"\",VLOOKUP(AM66,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO66=\"\",\"\",VLOOKUP(AO66,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ66=\"\",\"\",VLOOKUP(AQ66,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS66=\"\",\"\",VLOOKUP(AS66,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU66=\"\",\"\",VLOOKUP(AU66,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX66=\"\",\"\",VLOOKUP(AX66,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB66=\"\",\"\",VLOOKUP(BB66,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF66=\"\",\"\",VLOOKUP(BF66,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F67=\"\",\"\",VLOOKUP(F67,type[],2,FALSE))","v":""},null,{"$f":"IF(H67=\"\",\"\",VLOOKUP(H67,material[],2,FALSE))","v":""},null,{"$f":"IF(J67=\"\",\"\",VLOOKUP(J67,colour[],2,FALSE))","v":""},null,{"$f":"IF(L67=\"\",\"\",VLOOKUP(L67,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P67=\"\",\"\",VLOOKUP(P67,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R67=\"\",\"\",VLOOKUP(R67,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T67=\"\",\"\",VLOOKUP(T67,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V67=\"\",\"\",VLOOKUP(V67,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB67=\"\",\"\",VLOOKUP(AB67,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE67=\"\",\"\",VLOOKUP(AE67,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI67=\"\",\"\",VLOOKUP(AI67,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK67=\"\",\"\",VLOOKUP(AK67,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM67=\"\",\"\",VLOOKUP(AM67,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO67=\"\",\"\",VLOOKUP(AO67,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ67=\"\",\"\",VLOOKUP(AQ67,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS67=\"\",\"\",VLOOKUP(AS67,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU67=\"\",\"\",VLOOKUP(AU67,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX67=\"\",\"\",VLOOKUP(AX67,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB67=\"\",\"\",VLOOKUP(BB67,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF67=\"\",\"\",VLOOKUP(BF67,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F68=\"\",\"\",VLOOKUP(F68,type[],2,FALSE))","v":""},null,{"$f":"IF(H68=\"\",\"\",VLOOKUP(H68,material[],2,FALSE))","v":""},null,{"$f":"IF(J68=\"\",\"\",VLOOKUP(J68,colour[],2,FALSE))","v":""},null,{"$f":"IF(L68=\"\",\"\",VLOOKUP(L68,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P68=\"\",\"\",VLOOKUP(P68,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R68=\"\",\"\",VLOOKUP(R68,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T68=\"\",\"\",VLOOKUP(T68,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V68=\"\",\"\",VLOOKUP(V68,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB68=\"\",\"\",VLOOKUP(AB68,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE68=\"\",\"\",VLOOKUP(AE68,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI68=\"\",\"\",VLOOKUP(AI68,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK68=\"\",\"\",VLOOKUP(AK68,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM68=\"\",\"\",VLOOKUP(AM68,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO68=\"\",\"\",VLOOKUP(AO68,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ68=\"\",\"\",VLOOKUP(AQ68,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS68=\"\",\"\",VLOOKUP(AS68,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU68=\"\",\"\",VLOOKUP(AU68,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX68=\"\",\"\",VLOOKUP(AX68,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB68=\"\",\"\",VLOOKUP(BB68,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF68=\"\",\"\",VLOOKUP(BF68,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F69=\"\",\"\",VLOOKUP(F69,type[],2,FALSE))","v":""},null,{"$f":"IF(H69=\"\",\"\",VLOOKUP(H69,material[],2,FALSE))","v":""},null,{"$f":"IF(J69=\"\",\"\",VLOOKUP(J69,colour[],2,FALSE))","v":""},null,{"$f":"IF(L69=\"\",\"\",VLOOKUP(L69,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P69=\"\",\"\",VLOOKUP(P69,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R69=\"\",\"\",VLOOKUP(R69,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T69=\"\",\"\",VLOOKUP(T69,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V69=\"\",\"\",VLOOKUP(V69,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB69=\"\",\"\",VLOOKUP(AB69,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE69=\"\",\"\",VLOOKUP(AE69,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI69=\"\",\"\",VLOOKUP(AI69,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK69=\"\",\"\",VLOOKUP(AK69,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM69=\"\",\"\",VLOOKUP(AM69,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO69=\"\",\"\",VLOOKUP(AO69,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ69=\"\",\"\",VLOOKUP(AQ69,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS69=\"\",\"\",VLOOKUP(AS69,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU69=\"\",\"\",VLOOKUP(AU69,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX69=\"\",\"\",VLOOKUP(AX69,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB69=\"\",\"\",VLOOKUP(BB69,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF69=\"\",\"\",VLOOKUP(BF69,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F70=\"\",\"\",VLOOKUP(F70,type[],2,FALSE))","v":""},null,{"$f":"IF(H70=\"\",\"\",VLOOKUP(H70,material[],2,FALSE))","v":""},null,{"$f":"IF(J70=\"\",\"\",VLOOKUP(J70,colour[],2,FALSE))","v":""},null,{"$f":"IF(L70=\"\",\"\",VLOOKUP(L70,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P70=\"\",\"\",VLOOKUP(P70,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R70=\"\",\"\",VLOOKUP(R70,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T70=\"\",\"\",VLOOKUP(T70,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V70=\"\",\"\",VLOOKUP(V70,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB70=\"\",\"\",VLOOKUP(AB70,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE70=\"\",\"\",VLOOKUP(AE70,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI70=\"\",\"\",VLOOKUP(AI70,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK70=\"\",\"\",VLOOKUP(AK70,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM70=\"\",\"\",VLOOKUP(AM70,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO70=\"\",\"\",VLOOKUP(AO70,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ70=\"\",\"\",VLOOKUP(AQ70,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS70=\"\",\"\",VLOOKUP(AS70,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU70=\"\",\"\",VLOOKUP(AU70,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX70=\"\",\"\",VLOOKUP(AX70,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB70=\"\",\"\",VLOOKUP(BB70,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF70=\"\",\"\",VLOOKUP(BF70,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F71=\"\",\"\",VLOOKUP(F71,type[],2,FALSE))","v":""},null,{"$f":"IF(H71=\"\",\"\",VLOOKUP(H71,material[],2,FALSE))","v":""},null,{"$f":"IF(J71=\"\",\"\",VLOOKUP(J71,colour[],2,FALSE))","v":""},null,{"$f":"IF(L71=\"\",\"\",VLOOKUP(L71,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P71=\"\",\"\",VLOOKUP(P71,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R71=\"\",\"\",VLOOKUP(R71,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T71=\"\",\"\",VLOOKUP(T71,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V71=\"\",\"\",VLOOKUP(V71,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB71=\"\",\"\",VLOOKUP(AB71,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE71=\"\",\"\",VLOOKUP(AE71,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI71=\"\",\"\",VLOOKUP(AI71,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK71=\"\",\"\",VLOOKUP(AK71,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM71=\"\",\"\",VLOOKUP(AM71,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO71=\"\",\"\",VLOOKUP(AO71,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ71=\"\",\"\",VLOOKUP(AQ71,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS71=\"\",\"\",VLOOKUP(AS71,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU71=\"\",\"\",VLOOKUP(AU71,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX71=\"\",\"\",VLOOKUP(AX71,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB71=\"\",\"\",VLOOKUP(BB71,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF71=\"\",\"\",VLOOKUP(BF71,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F72=\"\",\"\",VLOOKUP(F72,type[],2,FALSE))","v":""},null,{"$f":"IF(H72=\"\",\"\",VLOOKUP(H72,material[],2,FALSE))","v":""},null,{"$f":"IF(J72=\"\",\"\",VLOOKUP(J72,colour[],2,FALSE))","v":""},null,{"$f":"IF(L72=\"\",\"\",VLOOKUP(L72,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P72=\"\",\"\",VLOOKUP(P72,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R72=\"\",\"\",VLOOKUP(R72,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T72=\"\",\"\",VLOOKUP(T72,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V72=\"\",\"\",VLOOKUP(V72,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB72=\"\",\"\",VLOOKUP(AB72,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE72=\"\",\"\",VLOOKUP(AE72,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI72=\"\",\"\",VLOOKUP(AI72,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK72=\"\",\"\",VLOOKUP(AK72,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM72=\"\",\"\",VLOOKUP(AM72,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO72=\"\",\"\",VLOOKUP(AO72,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ72=\"\",\"\",VLOOKUP(AQ72,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS72=\"\",\"\",VLOOKUP(AS72,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU72=\"\",\"\",VLOOKUP(AU72,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX72=\"\",\"\",VLOOKUP(AX72,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB72=\"\",\"\",VLOOKUP(BB72,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF72=\"\",\"\",VLOOKUP(BF72,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F73=\"\",\"\",VLOOKUP(F73,type[],2,FALSE))","v":""},null,{"$f":"IF(H73=\"\",\"\",VLOOKUP(H73,material[],2,FALSE))","v":""},null,{"$f":"IF(J73=\"\",\"\",VLOOKUP(J73,colour[],2,FALSE))","v":""},null,{"$f":"IF(L73=\"\",\"\",VLOOKUP(L73,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P73=\"\",\"\",VLOOKUP(P73,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R73=\"\",\"\",VLOOKUP(R73,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T73=\"\",\"\",VLOOKUP(T73,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V73=\"\",\"\",VLOOKUP(V73,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB73=\"\",\"\",VLOOKUP(AB73,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE73=\"\",\"\",VLOOKUP(AE73,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI73=\"\",\"\",VLOOKUP(AI73,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK73=\"\",\"\",VLOOKUP(AK73,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM73=\"\",\"\",VLOOKUP(AM73,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO73=\"\",\"\",VLOOKUP(AO73,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ73=\"\",\"\",VLOOKUP(AQ73,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS73=\"\",\"\",VLOOKUP(AS73,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU73=\"\",\"\",VLOOKUP(AU73,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX73=\"\",\"\",VLOOKUP(AX73,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB73=\"\",\"\",VLOOKUP(BB73,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF73=\"\",\"\",VLOOKUP(BF73,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F74=\"\",\"\",VLOOKUP(F74,type[],2,FALSE))","v":""},null,{"$f":"IF(H74=\"\",\"\",VLOOKUP(H74,material[],2,FALSE))","v":""},null,{"$f":"IF(J74=\"\",\"\",VLOOKUP(J74,colour[],2,FALSE))","v":""},null,{"$f":"IF(L74=\"\",\"\",VLOOKUP(L74,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P74=\"\",\"\",VLOOKUP(P74,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R74=\"\",\"\",VLOOKUP(R74,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T74=\"\",\"\",VLOOKUP(T74,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V74=\"\",\"\",VLOOKUP(V74,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB74=\"\",\"\",VLOOKUP(AB74,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE74=\"\",\"\",VLOOKUP(AE74,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI74=\"\",\"\",VLOOKUP(AI74,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK74=\"\",\"\",VLOOKUP(AK74,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM74=\"\",\"\",VLOOKUP(AM74,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO74=\"\",\"\",VLOOKUP(AO74,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ74=\"\",\"\",VLOOKUP(AQ74,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS74=\"\",\"\",VLOOKUP(AS74,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU74=\"\",\"\",VLOOKUP(AU74,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX74=\"\",\"\",VLOOKUP(AX74,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB74=\"\",\"\",VLOOKUP(BB74,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF74=\"\",\"\",VLOOKUP(BF74,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F75=\"\",\"\",VLOOKUP(F75,type[],2,FALSE))","v":""},null,{"$f":"IF(H75=\"\",\"\",VLOOKUP(H75,material[],2,FALSE))","v":""},null,{"$f":"IF(J75=\"\",\"\",VLOOKUP(J75,colour[],2,FALSE))","v":""},null,{"$f":"IF(L75=\"\",\"\",VLOOKUP(L75,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P75=\"\",\"\",VLOOKUP(P75,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R75=\"\",\"\",VLOOKUP(R75,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T75=\"\",\"\",VLOOKUP(T75,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V75=\"\",\"\",VLOOKUP(V75,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB75=\"\",\"\",VLOOKUP(AB75,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE75=\"\",\"\",VLOOKUP(AE75,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI75=\"\",\"\",VLOOKUP(AI75,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK75=\"\",\"\",VLOOKUP(AK75,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM75=\"\",\"\",VLOOKUP(AM75,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO75=\"\",\"\",VLOOKUP(AO75,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ75=\"\",\"\",VLOOKUP(AQ75,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS75=\"\",\"\",VLOOKUP(AS75,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU75=\"\",\"\",VLOOKUP(AU75,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX75=\"\",\"\",VLOOKUP(AX75,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB75=\"\",\"\",VLOOKUP(BB75,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF75=\"\",\"\",VLOOKUP(BF75,replace_reason[],2,FALSE))","v":""}]
[{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&C76&\"/\"&D76&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&C76&\"/\"&E76&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,{"$f":"IF(F76=\"\",\"\",VLOOKUP(F76,type[],2,FALSE))","v":""},null,{"$f":"IF(H76=\"\",\"\",VLOOKUP(H76,material[],2,FALSE))","v":""},null,{"$f":"IF(J76=\"\",\"\",VLOOKUP(J76,colour[],2,FALSE))","v":""},null,{"$f":"IF(L76=\"\",\"\",VLOOKUP(L76,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P76=\"\",\"\",VLOOKUP(P76,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R76=\"\",\"\",VLOOKUP(R76,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T76=\"\",\"\",VLOOKUP(T76,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V76=\"\",\"\",VLOOKUP(V76,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB76=\"\",\"\",VLOOKUP(AB76,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE76=\"\",\"\",VLOOKUP(AE76,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI76=\"\",\"\",VLOOKUP(AI76,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK76=\"\",\"\",VLOOKUP(AK76,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM76=\"\",\"\",VLOOKUP(AM76,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO76=\"\",\"\",VLOOKUP(AO76,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ76=\"\",\"\",VLOOKUP(AQ76,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS76=\"\",\"\",VLOOKUP(AS76,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU76=\"\",\"\",VLOOKUP(AU76,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX76=\"\",\"\",VLOOKUP(AX76,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB76=\"\",\"\",VLOOKUP(BB76,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF76=\"\",\"\",VLOOKUP(BF76,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F77=\"\",\"\",VLOOKUP(F77,type[],2,FALSE))","v":""},null,{"$f":"IF(H77=\"\",\"\",VLOOKUP(H77,material[],2,FALSE))","v":""},null,{"$f":"IF(J77=\"\",\"\",VLOOKUP(J77,colour[],2,FALSE))","v":""},null,{"$f":"IF(L77=\"\",\"\",VLOOKUP(L77,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P77=\"\",\"\",VLOOKUP(P77,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R77=\"\",\"\",VLOOKUP(R77,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T77=\"\",\"\",VLOOKUP(T77,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V77=\"\",\"\",VLOOKUP(V77,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB77=\"\",\"\",VLOOKUP(AB77,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE77=\"\",\"\",VLOOKUP(AE77,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI77=\"\",\"\",VLOOKUP(AI77,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK77=\"\",\"\",VLOOKUP(AK77,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM77=\"\",\"\",VLOOKUP(AM77,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO77=\"\",\"\",VLOOKUP(AO77,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ77=\"\",\"\",VLOOKUP(AQ77,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS77=\"\",\"\",VLOOKUP(AS77,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU77=\"\",\"\",VLOOKUP(AU77,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX77=\"\",\"\",VLOOKUP(AX77,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB77=\"\",\"\",VLOOKUP(BB77,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF77=\"\",\"\",VLOOKUP(BF77,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F78=\"\",\"\",VLOOKUP(F78,type[],2,FALSE))","v":""},null,{"$f":"IF(H78=\"\",\"\",VLOOKUP(H78,material[],2,FALSE))","v":""},null,{"$f":"IF(J78=\"\",\"\",VLOOKUP(J78,colour[],2,FALSE))","v":""},null,{"$f":"IF(L78=\"\",\"\",VLOOKUP(L78,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P78=\"\",\"\",VLOOKUP(P78,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R78=\"\",\"\",VLOOKUP(R78,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T78=\"\",\"\",VLOOKUP(T78,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V78=\"\",\"\",VLOOKUP(V78,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB78=\"\",\"\",VLOOKUP(AB78,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE78=\"\",\"\",VLOOKUP(AE78,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI78=\"\",\"\",VLOOKUP(AI78,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK78=\"\",\"\",VLOOKUP(AK78,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM78=\"\",\"\",VLOOKUP(AM78,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO78=\"\",\"\",VLOOKUP(AO78,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ78=\"\",\"\",VLOOKUP(AQ78,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS78=\"\",\"\",VLOOKUP(AS78,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU78=\"\",\"\",VLOOKUP(AU78,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX78=\"\",\"\",VLOOKUP(AX78,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB78=\"\",\"\",VLOOKUP(BB78,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF78=\"\",\"\",VLOOKUP(BF78,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F79=\"\",\"\",VLOOKUP(F79,type[],2,FALSE))","v":""},null,{"$f":"IF(H79=\"\",\"\",VLOOKUP(H79,material[],2,FALSE))","v":""},null,{"$f":"IF(J79=\"\",\"\",VLOOKUP(J79,colour[],2,FALSE))","v":""},null,{"$f":"IF(L79=\"\",\"\",VLOOKUP(L79,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P79=\"\",\"\",VLOOKUP(P79,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R79=\"\",\"\",VLOOKUP(R79,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T79=\"\",\"\",VLOOKUP(T79,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V79=\"\",\"\",VLOOKUP(V79,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB79=\"\",\"\",VLOOKUP(AB79,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE79=\"\",\"\",VLOOKUP(AE79,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI79=\"\",\"\",VLOOKUP(AI79,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK79=\"\",\"\",VLOOKUP(AK79,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM79=\"\",\"\",VLOOKUP(AM79,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO79=\"\",\"\",VLOOKUP(AO79,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ79=\"\",\"\",VLOOKUP(AQ79,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS79=\"\",\"\",VLOOKUP(AS79,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU79=\"\",\"\",VLOOKUP(AU79,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX79=\"\",\"\",VLOOKUP(AX79,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB79=\"\",\"\",VLOOKUP(BB79,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF79=\"\",\"\",VLOOKUP(BF79,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F80=\"\",\"\",VLOOKUP(F80,type[],2,FALSE))","v":""},null,{"$f":"IF(H80=\"\",\"\",VLOOKUP(H80,material[],2,FALSE))","v":""},null,{"$f":"IF(J80=\"\",\"\",VLOOKUP(J80,colour[],2,FALSE))","v":""},null,{"$f":"IF(L80=\"\",\"\",VLOOKUP(L80,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P80=\"\",\"\",VLOOKUP(P80,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R80=\"\",\"\",VLOOKUP(R80,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T80=\"\",\"\",VLOOKUP(T80,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V80=\"\",\"\",VLOOKUP(V80,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB80=\"\",\"\",VLOOKUP(AB80,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE80=\"\",\"\",VLOOKUP(AE80,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI80=\"\",\"\",VLOOKUP(AI80,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK80=\"\",\"\",VLOOKUP(AK80,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM80=\"\",\"\",VLOOKUP(AM80,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO80=\"\",\"\",VLOOKUP(AO80,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ80=\"\",\"\",VLOOKUP(AQ80,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS80=\"\",\"\",VLOOKUP(AS80,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU80=\"\",\"\",VLOOKUP(AU80,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX80=\"\",\"\",VLOOKUP(AX80,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB80=\"\",\"\",VLOOKUP(BB80,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF80=\"\",\"\",VLOOKUP(BF80,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F81=\"\",\"\",VLOOKUP(F81,type[],2,FALSE))","v":""},null,{"$f":"IF(H81=\"\",\"\",VLOOKUP(H81,material[],2,FALSE))","v":""},null,{"$f":"IF(J81=\"\",\"\",VLOOKUP(J81,colour[],2,FALSE))","v":""},null,{"$f":"IF(L81=\"\",\"\",VLOOKUP(L81,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P81=\"\",\"\",VLOOKUP(P81,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R81=\"\",\"\",VLOOKUP(R81,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T81=\"\",\"\",VLOOKUP(T81,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V81=\"\",\"\",VLOOKUP(V81,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB81=\"\",\"\",VLOOKUP(AB81,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE81=\"\",\"\",VLOOKUP(AE81,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI81=\"\",\"\",VLOOKUP(AI81,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK81=\"\",\"\",VLOOKUP(AK81,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM81=\"\",\"\",VLOOKUP(AM81,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO81=\"\",\"\",VLOOKUP(AO81,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ81=\"\",\"\",VLOOKUP(AQ81,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS81=\"\",\"\",VLOOKUP(AS81,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU81=\"\",\"\",VLOOKUP(AU81,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX81=\"\",\"\",VLOOKUP(AX81,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB81=\"\",\"\",VLOOKUP(BB81,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF81=\"\",\"\",VLOOKUP(BF81,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F82=\"\",\"\",VLOOKUP(F82,type[],2,FALSE))","v":""},null,{"$f":"IF(H82=\"\",\"\",VLOOKUP(H82,material[],2,FALSE))","v":""},null,{"$f":"IF(J82=\"\",\"\",VLOOKUP(J82,colour[],2,FALSE))","v":""},null,{"$f":"IF(L82=\"\",\"\",VLOOKUP(L82,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P82=\"\",\"\",VLOOKUP(P82,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R82=\"\",\"\",VLOOKUP(R82,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T82=\"\",\"\",VLOOKUP(T82,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V82=\"\",\"\",VLOOKUP(V82,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB82=\"\",\"\",VLOOKUP(AB82,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE82=\"\",\"\",VLOOKUP(AE82,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI82=\"\",\"\",VLOOKUP(AI82,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK82=\"\",\"\",VLOOKUP(AK82,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM82=\"\",\"\",VLOOKUP(AM82,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO82=\"\",\"\",VLOOKUP(AO82,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ82=\"\",\"\",VLOOKUP(AQ82,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS82=\"\",\"\",VLOOKUP(AS82,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU82=\"\",\"\",VLOOKUP(AU82,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX82=\"\",\"\",VLOOKUP(AX82,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB82=\"\",\"\",VLOOKUP(BB82,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF82=\"\",\"\",VLOOKUP(BF82,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F83=\"\",\"\",VLOOKUP(F83,type[],2,FALSE))","v":""},null,{"$f":"IF(H83=\"\",\"\",VLOOKUP(H83,material[],2,FALSE))","v":""},null,{"$f":"IF(J83=\"\",\"\",VLOOKUP(J83,colour[],2,FALSE))","v":""},null,{"$f":"IF(L83=\"\",\"\",VLOOKUP(L83,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P83=\"\",\"\",VLOOKUP(P83,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R83=\"\",\"\",VLOOKUP(R83,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T83=\"\",\"\",VLOOKUP(T83,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V83=\"\",\"\",VLOOKUP(V83,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB83=\"\",\"\",VLOOKUP(AB83,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE83=\"\",\"\",VLOOKUP(AE83,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI83=\"\",\"\",VLOOKUP(AI83,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK83=\"\",\"\",VLOOKUP(AK83,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM83=\"\",\"\",VLOOKUP(AM83,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO83=\"\",\"\",VLOOKUP(AO83,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ83=\"\",\"\",VLOOKUP(AQ83,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS83=\"\",\"\",VLOOKUP(AS83,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU83=\"\",\"\",VLOOKUP(AU83,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX83=\"\",\"\",VLOOKUP(AX83,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB83=\"\",\"\",VLOOKUP(BB83,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF83=\"\",\"\",VLOOKUP(BF83,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F84=\"\",\"\",VLOOKUP(F84,type[],2,FALSE))","v":""},null,{"$f":"IF(H84=\"\",\"\",VLOOKUP(H84,material[],2,FALSE))","v":""},null,{"$f":"IF(J84=\"\",\"\",VLOOKUP(J84,colour[],2,FALSE))","v":""},null,{"$f":"IF(L84=\"\",\"\",VLOOKUP(L84,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P84=\"\",\"\",VLOOKUP(P84,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R84=\"\",\"\",VLOOKUP(R84,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T84=\"\",\"\",VLOOKUP(T84,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V84=\"\",\"\",VLOOKUP(V84,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB84=\"\",\"\",VLOOKUP(AB84,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE84=\"\",\"\",VLOOKUP(AE84,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI84=\"\",\"\",VLOOKUP(AI84,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK84=\"\",\"\",VLOOKUP(AK84,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM84=\"\",\"\",VLOOKUP(AM84,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO84=\"\",\"\",VLOOKUP(AO84,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ84=\"\",\"\",VLOOKUP(AQ84,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS84=\"\",\"\",VLOOKUP(AS84,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU84=\"\",\"\",VLOOKUP(AU84,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX84=\"\",\"\",VLOOKUP(AX84,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB84=\"\",\"\",VLOOKUP(BB84,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF84=\"\",\"\",VLOOKUP(BF84,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F85=\"\",\"\",VLOOKUP(F85,type[],2,FALSE))","v":""},null,{"$f":"IF(H85=\"\",\"\",VLOOKUP(H85,material[],2,FALSE))","v":""},null,{"$f":"IF(J85=\"\",\"\",VLOOKUP(J85,colour[],2,FALSE))","v":""},null,{"$f":"IF(L85=\"\",\"\",VLOOKUP(L85,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P85=\"\",\"\",VLOOKUP(P85,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R85=\"\",\"\",VLOOKUP(R85,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T85=\"\",\"\",VLOOKUP(T85,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V85=\"\",\"\",VLOOKUP(V85,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB85=\"\",\"\",VLOOKUP(AB85,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE85=\"\",\"\",VLOOKUP(AE85,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI85=\"\",\"\",VLOOKUP(AI85,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK85=\"\",\"\",VLOOKUP(AK85,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM85=\"\",\"\",VLOOKUP(AM85,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO85=\"\",\"\",VLOOKUP(AO85,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ85=\"\",\"\",VLOOKUP(AQ85,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS85=\"\",\"\",VLOOKUP(AS85,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU85=\"\",\"\",VLOOKUP(AU85,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX85=\"\",\"\",VLOOKUP(AX85,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB85=\"\",\"\",VLOOKUP(BB85,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF85=\"\",\"\",VLOOKUP(BF85,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F86=\"\",\"\",VLOOKUP(F86,type[],2,FALSE))","v":""},null,{"$f":"IF(H86=\"\",\"\",VLOOKUP(H86,material[],2,FALSE))","v":""},null,{"$f":"IF(J86=\"\",\"\",VLOOKUP(J86,colour[],2,FALSE))","v":""},null,{"$f":"IF(L86=\"\",\"\",VLOOKUP(L86,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P86=\"\",\"\",VLOOKUP(P86,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R86=\"\",\"\",VLOOKUP(R86,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T86=\"\",\"\",VLOOKUP(T86,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V86=\"\",\"\",VLOOKUP(V86,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB86=\"\",\"\",VLOOKUP(AB86,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE86=\"\",\"\",VLOOKUP(AE86,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI86=\"\",\"\",VLOOKUP(AI86,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK86=\"\",\"\",VLOOKUP(AK86,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM86=\"\",\"\",VLOOKUP(AM86,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO86=\"\",\"\",VLOOKUP(AO86,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ86=\"\",\"\",VLOOKUP(AQ86,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS86=\"\",\"\",VLOOKUP(AS86,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU86=\"\",\"\",VLOOKUP(AU86,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX86=\"\",\"\",VLOOKUP(AX86,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB86=\"\",\"\",VLOOKUP(BB86,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF86=\"\",\"\",VLOOKUP(BF86,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F87=\"\",\"\",VLOOKUP(F87,type[],2,FALSE))","v":""},null,{"$f":"IF(H87=\"\",\"\",VLOOKUP(H87,material[],2,FALSE))","v":""},null,{"$f":"IF(J87=\"\",\"\",VLOOKUP(J87,colour[],2,FALSE))","v":""},null,{"$f":"IF(L87=\"\",\"\",VLOOKUP(L87,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P87=\"\",\"\",VLOOKUP(P87,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R87=\"\",\"\",VLOOKUP(R87,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T87=\"\",\"\",VLOOKUP(T87,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V87=\"\",\"\",VLOOKUP(V87,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB87=\"\",\"\",VLOOKUP(AB87,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE87=\"\",\"\",VLOOKUP(AE87,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI87=\"\",\"\",VLOOKUP(AI87,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK87=\"\",\"\",VLOOKUP(AK87,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM87=\"\",\"\",VLOOKUP(AM87,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO87=\"\",\"\",VLOOKUP(AO87,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ87=\"\",\"\",VLOOKUP(AQ87,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS87=\"\",\"\",VLOOKUP(AS87,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU87=\"\",\"\",VLOOKUP(AU87,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX87=\"\",\"\",VLOOKUP(AX87,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB87=\"\",\"\",VLOOKUP(BB87,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF87=\"\",\"\",VLOOKUP(BF87,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F88=\"\",\"\",VLOOKUP(F88,type[],2,FALSE))","v":""},null,{"$f":"IF(H88=\"\",\"\",VLOOKUP(H88,material[],2,FALSE))","v":""},null,{"$f":"IF(J88=\"\",\"\",VLOOKUP(J88,colour[],2,FALSE))","v":""},null,{"$f":"IF(L88=\"\",\"\",VLOOKUP(L88,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P88=\"\",\"\",VLOOKUP(P88,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R88=\"\",\"\",VLOOKUP(R88,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T88=\"\",\"\",VLOOKUP(T88,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V88=\"\",\"\",VLOOKUP(V88,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB88=\"\",\"\",VLOOKUP(AB88,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE88=\"\",\"\",VLOOKUP(AE88,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI88=\"\",\"\",VLOOKUP(AI88,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK88=\"\",\"\",VLOOKUP(AK88,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM88=\"\",\"\",VLOOKUP(AM88,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO88=\"\",\"\",VLOOKUP(AO88,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ88=\"\",\"\",VLOOKUP(AQ88,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS88=\"\",\"\",VLOOKUP(AS88,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU88=\"\",\"\",VLOOKUP(AU88,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX88=\"\",\"\",VLOOKUP(AX88,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB88=\"\",\"\",VLOOKUP(BB88,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF88=\"\",\"\",VLOOKUP(BF88,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F89=\"\",\"\",VLOOKUP(F89,type[],2,FALSE))","v":""},null,{"$f":"IF(H89=\"\",\"\",VLOOKUP(H89,material[],2,FALSE))","v":""},null,{"$f":"IF(J89=\"\",\"\",VLOOKUP(J89,colour[],2,FALSE))","v":""},null,{"$f":"IF(L89=\"\",\"\",VLOOKUP(L89,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P89=\"\",\"\",VLOOKUP(P89,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R89=\"\",\"\",VLOOKUP(R89,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T89=\"\",\"\",VLOOKUP(T89,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V89=\"\",\"\",VLOOKUP(V89,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB89=\"\",\"\",VLOOKUP(AB89,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE89=\"\",\"\",VLOOKUP(AE89,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI89=\"\",\"\",VLOOKUP(AI89,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK89=\"\",\"\",VLOOKUP(AK89,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM89=\"\",\"\",VLOOKUP(AM89,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO89=\"\",\"\",VLOOKUP(AO89,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ89=\"\",\"\",VLOOKUP(AQ89,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS89=\"\",\"\",VLOOKUP(AS89,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU89=\"\",\"\",VLOOKUP(AU89,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX89=\"\",\"\",VLOOKUP(AX89,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB89=\"\",\"\",VLOOKUP(BB89,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF89=\"\",\"\",VLOOKUP(BF89,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F90=\"\",\"\",VLOOKUP(F90,type[],2,FALSE))","v":""},null,{"$f":"IF(H90=\"\",\"\",VLOOKUP(H90,material[],2,FALSE))","v":""},null,{"$f":"IF(J90=\"\",\"\",VLOOKUP(J90,colour[],2,FALSE))","v":""},null,{"$f":"IF(L90=\"\",\"\",VLOOKUP(L90,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P90=\"\",\"\",VLOOKUP(P90,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R90=\"\",\"\",VLOOKUP(R90,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T90=\"\",\"\",VLOOKUP(T90,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V90=\"\",\"\",VLOOKUP(V90,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB90=\"\",\"\",VLOOKUP(AB90,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE90=\"\",\"\",VLOOKUP(AE90,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI90=\"\",\"\",VLOOKUP(AI90,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK90=\"\",\"\",VLOOKUP(AK90,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM90=\"\",\"\",VLOOKUP(AM90,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO90=\"\",\"\",VLOOKUP(AO90,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ90=\"\",\"\",VLOOKUP(AQ90,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS90=\"\",\"\",VLOOKUP(AS90,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU90=\"\",\"\",VLOOKUP(AU90,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX90=\"\",\"\",VLOOKUP(AX90,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB90=\"\",\"\",VLOOKUP(BB90,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF90=\"\",\"\",VLOOKUP(BF90,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F91=\"\",\"\",VLOOKUP(F91,type[],2,FALSE))","v":""},null,{"$f":"IF(H91=\"\",\"\",VLOOKUP(H91,material[],2,FALSE))","v":""},null,{"$f":"IF(J91=\"\",\"\",VLOOKUP(J91,colour[],2,FALSE))","v":""},null,{"$f":"IF(L91=\"\",\"\",VLOOKUP(L91,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P91=\"\",\"\",VLOOKUP(P91,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R91=\"\",\"\",VLOOKUP(R91,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T91=\"\",\"\",VLOOKUP(T91,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V91=\"\",\"\",VLOOKUP(V91,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB91=\"\",\"\",VLOOKUP(AB91,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE91=\"\",\"\",VLOOKUP(AE91,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI91=\"\",\"\",VLOOKUP(AI91,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK91=\"\",\"\",VLOOKUP(AK91,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM91=\"\",\"\",VLOOKUP(AM91,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO91=\"\",\"\",VLOOKUP(AO91,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ91=\"\",\"\",VLOOKUP(AQ91,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS91=\"\",\"\",VLOOKUP(AS91,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU91=\"\",\"\",VLOOKUP(AU91,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX91=\"\",\"\",VLOOKUP(AX91,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB91=\"\",\"\",VLOOKUP(BB91,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF91=\"\",\"\",VLOOKUP(BF91,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F92=\"\",\"\",VLOOKUP(F92,type[],2,FALSE))","v":""},null,{"$f":"IF(H92=\"\",\"\",VLOOKUP(H92,material[],2,FALSE))","v":""},null,{"$f":"IF(J92=\"\",\"\",VLOOKUP(J92,colour[],2,FALSE))","v":""},null,{"$f":"IF(L92=\"\",\"\",VLOOKUP(L92,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P92=\"\",\"\",VLOOKUP(P92,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R92=\"\",\"\",VLOOKUP(R92,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T92=\"\",\"\",VLOOKUP(T92,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V92=\"\",\"\",VLOOKUP(V92,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB92=\"\",\"\",VLOOKUP(AB92,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE92=\"\",\"\",VLOOKUP(AE92,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI92=\"\",\"\",VLOOKUP(AI92,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK92=\"\",\"\",VLOOKUP(AK92,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM92=\"\",\"\",VLOOKUP(AM92,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO92=\"\",\"\",VLOOKUP(AO92,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ92=\"\",\"\",VLOOKUP(AQ92,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS92=\"\",\"\",VLOOKUP(AS92,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU92=\"\",\"\",VLOOKUP(AU92,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX92=\"\",\"\",VLOOKUP(AX92,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB92=\"\",\"\",VLOOKUP(BB92,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF92=\"\",\"\",VLOOKUP(BF92,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F93=\"\",\"\",VLOOKUP(F93,type[],2,FALSE))","v":""},null,{"$f":"IF(H93=\"\",\"\",VLOOKUP(H93,material[],2,FALSE))","v":""},null,{"$f":"IF(J93=\"\",\"\",VLOOKUP(J93,colour[],2,FALSE))","v":""},null,{"$f":"IF(L93=\"\",\"\",VLOOKUP(L93,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P93=\"\",\"\",VLOOKUP(P93,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R93=\"\",\"\",VLOOKUP(R93,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T93=\"\",\"\",VLOOKUP(T93,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V93=\"\",\"\",VLOOKUP(V93,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB93=\"\",\"\",VLOOKUP(AB93,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE93=\"\",\"\",VLOOKUP(AE93,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI93=\"\",\"\",VLOOKUP(AI93,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK93=\"\",\"\",VLOOKUP(AK93,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM93=\"\",\"\",VLOOKUP(AM93,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO93=\"\",\"\",VLOOKUP(AO93,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ93=\"\",\"\",VLOOKUP(AQ93,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS93=\"\",\"\",VLOOKUP(AS93,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU93=\"\",\"\",VLOOKUP(AU93,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX93=\"\",\"\",VLOOKUP(AX93,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB93=\"\",\"\",VLOOKUP(BB93,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF93=\"\",\"\",VLOOKUP(BF93,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F94=\"\",\"\",VLOOKUP(F94,type[],2,FALSE))","v":""},null,{"$f":"IF(H94=\"\",\"\",VLOOKUP(H94,material[],2,FALSE))","v":""},null,{"$f":"IF(J94=\"\",\"\",VLOOKUP(J94,colour[],2,FALSE))","v":""},null,{"$f":"IF(L94=\"\",\"\",VLOOKUP(L94,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P94=\"\",\"\",VLOOKUP(P94,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R94=\"\",\"\",VLOOKUP(R94,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T94=\"\",\"\",VLOOKUP(T94,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V94=\"\",\"\",VLOOKUP(V94,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB94=\"\",\"\",VLOOKUP(AB94,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE94=\"\",\"\",VLOOKUP(AE94,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI94=\"\",\"\",VLOOKUP(AI94,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK94=\"\",\"\",VLOOKUP(AK94,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM94=\"\",\"\",VLOOKUP(AM94,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO94=\"\",\"\",VLOOKUP(AO94,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ94=\"\",\"\",VLOOKUP(AQ94,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS94=\"\",\"\",VLOOKUP(AS94,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU94=\"\",\"\",VLOOKUP(AU94,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX94=\"\",\"\",VLOOKUP(AX94,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB94=\"\",\"\",VLOOKUP(BB94,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF94=\"\",\"\",VLOOKUP(BF94,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F95=\"\",\"\",VLOOKUP(F95,type[],2,FALSE))","v":""},null,{"$f":"IF(H95=\"\",\"\",VLOOKUP(H95,material[],2,FALSE))","v":""},null,{"$f":"IF(J95=\"\",\"\",VLOOKUP(J95,colour[],2,FALSE))","v":""},null,{"$f":"IF(L95=\"\",\"\",VLOOKUP(L95,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P95=\"\",\"\",VLOOKUP(P95,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R95=\"\",\"\",VLOOKUP(R95,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T95=\"\",\"\",VLOOKUP(T95,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V95=\"\",\"\",VLOOKUP(V95,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB95=\"\",\"\",VLOOKUP(AB95,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE95=\"\",\"\",VLOOKUP(AE95,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI95=\"\",\"\",VLOOKUP(AI95,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK95=\"\",\"\",VLOOKUP(AK95,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM95=\"\",\"\",VLOOKUP(AM95,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO95=\"\",\"\",VLOOKUP(AO95,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ95=\"\",\"\",VLOOKUP(AQ95,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS95=\"\",\"\",VLOOKUP(AS95,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU95=\"\",\"\",VLOOKUP(AU95,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX95=\"\",\"\",VLOOKUP(AX95,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB95=\"\",\"\",VLOOKUP(BB95,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF95=\"\",\"\",VLOOKUP(BF95,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F96=\"\",\"\",VLOOKUP(F96,type[],2,FALSE))","v":""},null,{"$f":"IF(H96=\"\",\"\",VLOOKUP(H96,material[],2,FALSE))","v":""},null,{"$f":"IF(J96=\"\",\"\",VLOOKUP(J96,colour[],2,FALSE))","v":""},null,{"$f":"IF(L96=\"\",\"\",VLOOKUP(L96,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P96=\"\",\"\",VLOOKUP(P96,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R96=\"\",\"\",VLOOKUP(R96,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T96=\"\",\"\",VLOOKUP(T96,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V96=\"\",\"\",VLOOKUP(V96,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB96=\"\",\"\",VLOOKUP(AB96,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE96=\"\",\"\",VLOOKUP(AE96,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI96=\"\",\"\",VLOOKUP(AI96,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK96=\"\",\"\",VLOOKUP(AK96,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM96=\"\",\"\",VLOOKUP(AM96,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO96=\"\",\"\",VLOOKUP(AO96,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ96=\"\",\"\",VLOOKUP(AQ96,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS96=\"\",\"\",VLOOKUP(AS96,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU96=\"\",\"\",VLOOKUP(AU96,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX96=\"\",\"\",VLOOKUP(AX96,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB96=\"\",\"\",VLOOKUP(BB96,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF96=\"\",\"\",VLOOKUP(BF96,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F97=\"\",\"\",VLOOKUP(F97,type[],2,FALSE))","v":""},null,{"$f":"IF(H97=\"\",\"\",VLOOKUP(H97,material[],2,FALSE))","v":""},null,{"$f":"IF(J97=\"\",\"\",VLOOKUP(J97,colour[],2,FALSE))","v":""},null,{"$f":"IF(L97=\"\",\"\",VLOOKUP(L97,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P97=\"\",\"\",VLOOKUP(P97,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R97=\"\",\"\",VLOOKUP(R97,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T97=\"\",\"\",VLOOKUP(T97,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V97=\"\",\"\",VLOOKUP(V97,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB97=\"\",\"\",VLOOKUP(AB97,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE97=\"\",\"\",VLOOKUP(AE97,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI97=\"\",\"\",VLOOKUP(AI97,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK97=\"\",\"\",VLOOKUP(AK97,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM97=\"\",\"\",VLOOKUP(AM97,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO97=\"\",\"\",VLOOKUP(AO97,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ97=\"\",\"\",VLOOKUP(AQ97,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS97=\"\",\"\",VLOOKUP(AS97,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU97=\"\",\"\",VLOOKUP(AU97,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX97=\"\",\"\",VLOOKUP(AX97,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB97=\"\",\"\",VLOOKUP(BB97,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF97=\"\",\"\",VLOOKUP(BF97,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F98=\"\",\"\",VLOOKUP(F98,type[],2,FALSE))","v":""},null,{"$f":"IF(H98=\"\",\"\",VLOOKUP(H98,material[],2,FALSE))","v":""},null,{"$f":"IF(J98=\"\",\"\",VLOOKUP(J98,colour[],2,FALSE))","v":""},null,{"$f":"IF(L98=\"\",\"\",VLOOKUP(L98,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P98=\"\",\"\",VLOOKUP(P98,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R98=\"\",\"\",VLOOKUP(R98,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T98=\"\",\"\",VLOOKUP(T98,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V98=\"\",\"\",VLOOKUP(V98,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB98=\"\",\"\",VLOOKUP(AB98,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE98=\"\",\"\",VLOOKUP(AE98,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI98=\"\",\"\",VLOOKUP(AI98,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK98=\"\",\"\",VLOOKUP(AK98,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM98=\"\",\"\",VLOOKUP(AM98,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO98=\"\",\"\",VLOOKUP(AO98,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ98=\"\",\"\",VLOOKUP(AQ98,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS98=\"\",\"\",VLOOKUP(AS98,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU98=\"\",\"\",VLOOKUP(AU98,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX98=\"\",\"\",VLOOKUP(AX98,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB98=\"\",\"\",VLOOKUP(BB98,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF98=\"\",\"\",VLOOKUP(BF98,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F99=\"\",\"\",VLOOKUP(F99,type[],2,FALSE))","v":""},null,{"$f":"IF(H99=\"\",\"\",VLOOKUP(H99,material[],2,FALSE))","v":""},null,{"$f":"IF(J99=\"\",\"\",VLOOKUP(J99,colour[],2,FALSE))","v":""},null,{"$f":"IF(L99=\"\",\"\",VLOOKUP(L99,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P99=\"\",\"\",VLOOKUP(P99,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R99=\"\",\"\",VLOOKUP(R99,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T99=\"\",\"\",VLOOKUP(T99,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V99=\"\",\"\",VLOOKUP(V99,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB99=\"\",\"\",VLOOKUP(AB99,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE99=\"\",\"\",VLOOKUP(AE99,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI99=\"\",\"\",VLOOKUP(AI99,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK99=\"\",\"\",VLOOKUP(AK99,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM99=\"\",\"\",VLOOKUP(AM99,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO99=\"\",\"\",VLOOKUP(AO99,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ99=\"\",\"\",VLOOKUP(AQ99,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS99=\"\",\"\",VLOOKUP(AS99,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU99=\"\",\"\",VLOOKUP(AU99,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX99=\"\",\"\",VLOOKUP(AX99,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB99=\"\",\"\",VLOOKUP(BB99,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF99=\"\",\"\",VLOOKUP(BF99,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F100=\"\",\"\",VLOOKUP(F100,type[],2,FALSE))","v":""},null,{"$f":"IF(H100=\"\",\"\",VLOOKUP(H100,material[],2,FALSE))","v":""},null,{"$f":"IF(J100=\"\",\"\",VLOOKUP(J100,colour[],2,FALSE))","v":""},null,{"$f":"IF(L100=\"\",\"\",VLOOKUP(L100,reflectorised[],2,FALSE))","v":""},null,null,null,{"$f":"IF(P100=\"\",\"\",VLOOKUP(P100,marking_attach[],2,FALSE))","v":""},null,{"$f":"IF(R100=\"\",\"\",VLOOKUP(R100,paint_make[],2,FALSE))","v":""},null,{"$f":"IF(T100=\"\",\"\",VLOOKUP(T100,paint_brand[],2,FALSE))","v":""},null,{"$f":"IF(V100=\"\",\"\",VLOOKUP(V100,application_type[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AB100=\"\",\"\",VLOOKUP(AB100,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(AE100=\"\",\"\",VLOOKUP(AE100,side[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AI100=\"\",\"\",VLOOKUP(AI100,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AK100=\"\",\"\",VLOOKUP(AK100,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AM100=\"\",\"\",VLOOKUP(AM100,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AO100=\"\",\"\",VLOOKUP(AO100,risk[],2,FALSE))","v":""},null,{"$f":"IF(AQ100=\"\",\"\",VLOOKUP(AQ100,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AS100=\"\",\"\",VLOOKUP(AS100,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AU100=\"\",\"\",VLOOKUP(AU100,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AX100=\"\",\"\",VLOOKUP(AX100,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BB100=\"\",\"\",VLOOKUP(BB100,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BF100=\"\",\"\",VLOOKUP(BF100,replace_reason[],2,FALSE))","v":""}]

{"sheet":"Lookups","index":1,"n_rows":156,"n_cols":59,"rows_kept":156,"cut":false,"hidden":false,"merged":[]}
["marking type description","marking type",null,"marking material description","marking material",null,"marking colour description","marking colour",null,"reflectorised description","reflectorised",null,"marking attach description","marking attach",null,"paint make description","paint make",null,"paint brand description","paint brand",null,"application type description","application type",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"]
["Centreline 100mm - Continuous","M01",null,"Cold Applied Plastic","CP",null,"Blacking out paint","BK",null,"Normal","N",null,"3M series 240 and 280","3MRPM",null,"Damar Industries","DI",null,"100S yellow","100SYE",null,"Drop-on/Intermix/Visibead","3A",null,"Ends away from the road","AWAY",null,"Centre","C",null,"Bylaw Update","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,"Bylaw Update","01"]
["Centreline 150mm - Continuous","M01A",null,"Epoxy resin (for coloured surfacings)","EP",null,"Blue","BU",null,"Reflectorised","R",null,"Apex Ceramic Dome - Matrix Dot on Base","AXCDMD",null,"Fulton Hogan Ltd","FH",null,"A100 white","A100WH",null,"Drop-on/Intermix","DI",null,"Ends beyond Road End","BYOND",null,"Left","L",null,"Crash reduction study","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 reduction study","02"]
["Centreline 200mm - Continuous","M01B",null,"High Performance Multi Dot","HP",null,"Green","GR",null,null,null,null,"Apex Ceramic Dome - Radial Pattern on Base","AXCDRP",null,"Bay of Plenty Industrial Paint","IP",null,"A100 yellow","A100YE",null,"Drop-on","DO",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"]
["Centreline 100mm (3x7)","M02",null,"Raised Pavement Marker","PM",null,"Red","RE",null,null,null,null,"Apex plastic body with filler","AXRPM",null,"Linaro NZ Ltd","LO",null,"A150 white","A150WH",null,"Drop-on/Visibead","DV",null,"Cul de sac","CUL",null,null,null,null,"New standard","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,"New standard","04"]
["Centreline 150mm (3x7)","M02A",null,"High intensity prismatic","PR",null,"White","WH",null,null,null,null,"Apex 921 plastic body with filler","AXRPM921",null,"Levene Paint Manufacturing Ltd","LV",null,"A200 white","A200WH",null,"Intermix","IM",null,"Dummy of No Length","DUMMY",null,null,null,null,"Non-functional","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,"Non-functional","05"]
["Centreline 200mm (3x7)","M02B",null,"Reflectorised Paint","RP",null,"Yellow","YE",null,null,null,null,"Apex 926 plastic body with filler","AXRPM926",null,"Resene Paints Ltd","RS",null,"Acrylic Road Marking - White","ACWH",null,"Intermix/Visibead","IV",null,"Starts or Ends at an Intersection","ISECT",null,null,null,null,"Projects","06",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",null,"Projects","06"]
["No Overtaking 100mm - Continuous","M03",null,"Thermoplastic - cold","TC",null,null,null,null,null,null,null,"Cataguide ABS plastic octagonal body with filler","CATRRPM",null,null,null,null,"Acrylic Road Marking - Yellow","ACYE",null,"Visibead","VB",null,"No adjustments made","NONE",null,null,null,null,"Removed","07",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",null,"Removed","07"]
["No Overtaking 150mm - Continuous","M03A",null,"Thermoplastic - hot","TH",null,null,null,null,null,null,null,"Highway Ceramics ceramic dome","HCCD",null,null,null,null,"Standard Alkyd Roadmarking Paint - White","AKWH",null,null,null,null,"Roundabout","RAB",null,null,null,null,"Rework","08",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",null,"Rework","08"]
["No Overtaking Advance 100mm (13x7)","M04",null,"Long Life Flat","TP",null,null,null,null,null,null,null,"Ray-o-lite acrylic plastic shell with filler (AA)","RORPMAA",null,null,null,null,"Alkyd Road Marking - White 100","AKWH100",null,null,null,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"]
["No Overtaking Advance 150mm","M04A",null,null,null,null,null,null,null,null,null,null,"Ray-o-lite ABS plastic body with filler","RORPMABS",null,null,null,null,"Alkyd Road Marking - White 102","AKWH102",null,null,null,null,null,null,null,null,null,null,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"]
["RPM Non-Reflective","M05",null,null,null,null,null,null,null,null,null,null,"RSE Swareflex ABS Plastic Body Model 3017/3018","RSERPM18",null,null,null,null,"Standard Alkyd Roadmarking Paint - Yellow","AKYE",null,null,null,null,null,null,null,null,null,null,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"]
["RPM Solar","M05A",null,null,null,null,null,null,null,null,null,null,"RSE Swareflex ABS Plastic Body with Anchor Stem 3027/3028","RSERPM28",null,null,null,null,"Alkyd Road Marking - Yellow 201","AKYE201",null,null,null,null,null,null,null,null,null,null,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"]
["RPM Inductive","M05B",null,null,null,null,null,null,null,null,null,null,"Stimsonite acrylic plastic body with filler type 88","SNRPM88",null,null,null,null,"Alkyd Road Marking - Yellow 204","AKYE204",null,null,null,null,null,null,null,null,null,null,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"]
["RRPM Yellow Mono-directional","M06",null,null,null,null,null,null,null,null,null,null,"Stimsonite acrylic plastic body with filler model 911","SNRPM911",null,null,null,null,"Alkyd Road Marking - Yellow 205","AKYE205",null,null,null,null,null,null,null,null,null,null,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"]
["RRPM White Mono-directional","M07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bascoplast cold applied plastic","BASC",null,null,null,null,null,null,null,null,null,null,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"]
["RRPM White Bi-directional","M08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chlorinated Rubber Bead Binder Roadmarking Paint -","CRBWH",null,null,null,null,null,null,null,null,null,null,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"]
["RRPM White/Yellow Bi-directional","M09",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chlorinated Rubber Bead Binder Roadmarking Paint -","CRBYE",null,null,null,null,null,null,null,null,null,null,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"]
["RRPM Yellow Bi-directional","M10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Highway aqua TNZ M7W","HATNZM7W",null,null,null,null,null,null,null,null,null,null,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"]
["RRPM Red Edge Line Mono-directional","M11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Highway aqua TNZ M7Y","HATNZM7Y",null,null,null,null,null,null,null,null,null,null,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"]
["Lane 100mm (3x7)","M12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Solids Alkyd Roadmarking Paint - White","HSAKWH",null,null,null,null,null,null,null,null,null,null,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&"]
["Lane Line 100mm 1m x 1m","M12A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High solids alkyd roadmarking paint yellow","HSAKYE",null,null,null,null,null,null,null,null,null,null,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"]
["Edge 150mm - Continuous","M13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Highway TNZ M7W","HTNZM7W",null,null,null,null,null,null,null,null,null,null,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"]
["Edge 75mm - Continuous","M14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Highway TNZ M7Y","HTNZM7Y",null,null,null,null,null,null,null,null,null,null,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"]
["Edge 100mm - Continuous","M15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LWR6 white","LWR6WH",null,null,null,null,null,null,null,null,null,null,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"]
["Edge 200mm - Continuous","M15A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LWR8 white","LWR8WH",null,null,null,null,null,null,null,null,null,null,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"]
["Painted Shoulder","M16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Linaro Linaqua QL90 Waterborne","QL90",null,null,null,null,null,null,null,null,null,null,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"]
["Painted Island","M17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tarmak modified chlorinated rubber white","TMCRWH",null,null,null,null,null,null,null,null,null,null,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"]
["Island (Prewarning)","M18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tarmark modified chlorinated rubber yellow","TMCRYE",null,null,null,null,null,null,null,null,null,null,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"]
["Right Turning Bay","M19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WB90 Yellow (Water based rapid dry)","WB90YE",null,null,null,null,null,null,null,null,null,null,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"]
["Pedestrian Crossing","M20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waterbased acrylic roadmarking paint white","WBACWH",null,null,null,null,null,null,null,null,null,null,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"]
["Pedestrian Crossing - Diamond","M21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XRM7-4","XRM7-4",null,null,null,null,null,null,null,null,null,null,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"]
["Pedestrian Symbol","M21A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Signalised Mid-Block Crosswalk","M22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Signalised Intersection Crosswalk","M23",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Railway Crossing","M24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Emerg exit sig sh white","M25",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Cross Roads","M26",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Passing Lane Taper","M27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Slow","M28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["One Lane Bridge","M29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Stop","M30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["No Left Turn","M32",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["No Right Turn","M33",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["One Way","M34",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["No Entry","M35",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["No Turns","M36",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["No Exit","M37",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Speed Circles","M38",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Speed Circle 50km/h","M3850",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Speed Circle 70km/h","M3870",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Speed Circle 80 km/h","M3880",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Straight Arrow","M40",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Right Turn Arrow","M41",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Left Turn Arrow","M42",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Combination Arrows","M43",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Turn Left","M44",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Turn Right","M45",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Keep Clear","M46",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Disabled Parking","M47",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["No Parking","M48",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Children","M49",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Stop Ahead","M50",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Pedestrian Crossing Ahead","M52",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["School Patrol","M53",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Destination Legend","M55",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["School","M56",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Speed Hump","M57",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Painted Speed Hump","M58",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Intersection Continuity Lines (150mm 1 x 3)","M59",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Intersection Continuity Lines (200mm 1 x 3)","M59A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Intersection Continuity Lines 100mm (1 x 3)","M59B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["No Stopping Line (Yellow) 100mm (1x1)","M60",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Loading Zone","M61",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Bus Stop","M62",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Taxi Stand","M63",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Other Zone","M64",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Park Limit Lines (Parallel)","M65",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Park Meter Bays","M66",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Park Angle Bays","M67",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Fire Hydrant","M70",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Caution","M71",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Cycle Lane","M72",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Cycle Symbol","M73",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Flush Median","M74",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Bus Lane","M75",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Bus Lane Ends","M76",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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("]
["Traffic Signal Limit Lines","M77",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Give Way Limit Lines","M78",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Stop Limit Lines","M79",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Convex Mirror","M80",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Give Way Triangle Symbol","M81",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["T2 Lanes","M82",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Coloured Surfacing","M83",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Centreline 100mm Continuous - Profiled","M84",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Centreline 150mm Continuous - Profiled","M84A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Centreline 200mm Continuous - Profiled","M84B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Centreline 100mm (3x7) - Profiled","M85",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Centreline 150mm (3x7) - Profiled","M85A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Centreline 200mm (3x7) - Profiled","M85B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Edge 100mm Continuous - Profiled","M86",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Edge 150mm Continuous - Profiled","M87",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["No Overtaking 100mm Continuous - Profiled","M88",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["No Overtaking 150mm Continuous - Profiled","M88A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["No Overtaking 200mm Continuous - Profiled","M88B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["No Overtaking Advance 100mm (13x7) - Profiled","M89",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["No Overtaking Advance 150mm (13x7) - Profiled","M89A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Painted Island 100mm Continuous - Profiled","M90",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WSP New Zealand Ltd","WNZ"]