{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["MinorStructure","Lookups"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":32,"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":"MinorStructure","index":0,"n_rows":48,"n_cols":49,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["15f221f1-c15e-4d8e-a679-81fade5c4405_road_id","ba4adf1f-d64b-4d2c-a600-a59acebf3405_road_id","sh-rs-d","15f221f1-c15e-4d8e-a679-81fade5c4404_start_m","ba4adf1f-d64b-4d2c-a600-a59acebf3404_end_m","bc26d81d-792d-4558-88db-173f93a09a73_ms_type_desc","bc26d81d-792d-4558-88db-173f93a09a73_ms_type","92c6335e-7f0d-40ec-a3ba-aea16c3a0f9b_ms_subtype_desc","92c6335e-7f0d-40ec-a3ba-aea16c3a0f9b_ms_subtype","6175fa91-9f0f-4d42-8efc-d1837853efe0_ms_material_desc","6175fa91-9f0f-4d42-8efc-d1837853efe0_ms_material","3b1c5d2f-261d-466e-ace4-ebcc2bb34b26_ms_style_desc","3b1c5d2f-261d-466e-ace4-ebcc2bb34b26_ms_style","7194c768-d5cf-4e21-8fff-d2d3685b6ab5_length_adjust_m","f04c33f1-6079-4733-b958-c5f7ea3faae5_len_adjust_rsn_desc","f04c33f1-6079-4733-b958-c5f7ea3faae5_len_adjust_rsn","22e46440-f222-46c6-a8fa-43a12eb62955_length_m","191121f1-cebe-46a1-b808-671c0faf87b0_side_desc","191121f1-cebe-46a1-b808-671c0faf87b0_side","19f2fea0-4a66-43e5-bbdf-687c15f481f4_offset","c44da4d7-f5c0-4369-8506-52354463c5a4_width","49bf6242-f42c-4f12-9e67-1ce7d735331b_heigth_m","463cbde3-9d5e-46b2-8c1f-52e459ff515f_clearance","ed39cc04-50ce-4463-97af-3544819a1606_constructed","6fd25a3f-829d-4243-9151-2a05004b5c16_asset_owner_desc","6fd25a3f-829d-4243-9151-2a05004b5c16_asset_owner","1f3f7b75-a698-40f8-873c-15309616f08d_risk_likelihood_desc","1f3f7b75-a698-40f8-873c-15309616f08d_risk_likelihood","73712ef6-326d-45a2-a26d-389670f24abe_risk_consequence_desc","73712ef6-326d-45a2-a26d-389670f24abe_risk_consequence","6b59688a-3d5c-4ab6-88c8-8450bed19fb3_risk_desc","6b59688a-3d5c-4ab6-88c8-8450bed19fb3_risk","70e037f0-2e88-4769-b546-7823b5c4e015_rul_reset_desc","70e037f0-2e88-4769-b546-7823b5c4e015_rul_reset","bc6b1891-dfa0-44ed-a47d-656184d2b659_use_default_rc_desc","bc6b1891-dfa0-44ed-a47d-656184d2b659_use_default_rc","13104a97-3f54-4380-90d7-10c7a3e4cada_condition_desc","13104a97-3f54-4380-90d7-10c7a3e4cada_condition","68ffad55-c5c0-4cc6-8a5b-40285bb77128_condition_date","f67765d8-f1ee-4456-94eb-bd2aaeaa1922_collect_name_desc","f67765d8-f1ee-4456-94eb-bd2aaeaa1922_collect_name","c4f87619-0645-41fe-83a4-e363ade66eb5_minor_structure_id","3d8adf88-d219-4b55-aebd-369946ae5077_notes","0f06841e-7950-4e17-8e2f-2c988df28449_not_ramm_field_in_replace_reason_desc","0f06841e-7950-4e17-8e2f-2c988df28449_not_ramm_field_in_replace_reason_desc","b850165d-66dc-490d-9b5c-537017b071b8_not_ramm_field_prior_id","ddc46be0-4f21-4b9d-b366-ad9f92de32c2_not_ramm_field_replace_date","46090593-77fc-4def-94d5-9e11d7fc4d02_not_ramm_field_rep_replace_reason_desc","46090593-77fc-4def-94d5-9e11d7fc4d02_not_ramm_field_rep_replace_reason"]
["road_id","road_id","sh-rs-d","start_m","end_m","ms_type_desc","ms_type","ms_subtype_desc","ms_subtype","ms_material_desc","ms_material","ms_style_desc","ms_style","length_adjust_m","len_adjust_rsn_desc","len_adjust_rsn","length_m","side_desc","side","offset","width","heigth_m","clearance","constructed","asset_owner_desc","asset_owner","risk_likelihood_desc","risk_likelihood","risk_consequence_desc","risk_consequence","risk_desc","risk","rul_reset_desc","rul_reset","use_default_rc_desc","use_default_rc","condition_desc","condition","condition_date","collect_name_desc","collect_name","minor_structure_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","RP Start (m)","RP End (m)","Type Description","Type","Subtype Description","Subtype","Material Description","Material","Style Description","Style","Extra Lenth - must set to 0 if no extra length","Extra Length Reason Description","Extra Length Reason","Total Length (m)","Side Description","Side","Offset","Width (m)","Height (m)","Clearance (m)","Construction date (dd/mm/yyyy) Must include leading 0","Asset Owner Description","Asset Owner","Risk Likelihood Description","Risk Likelihood","Risk Consequence Description","Risk Consequence","Risk Description","Risk","RUL Reset Description","RUL Reset","Use Default RC Description","Use Default RC","Condition Description","Condition","Condition Date (dd/mm/yyyy) Must include leading 0","Organisation Description","Organisation","Minor structure 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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J4=\"\",\"\",VLOOKUP(J4,material[],2,FALSE))","v":""},null,{"$f":"IF(L4=\"\",\"\",VLOOKUP(L4,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O4=\"\",\"\",VLOOKUP(O4,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R4=\"\",\"\",VLOOKUP(R4,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y4=\"\",\"\",VLOOKUP(Y4,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA4=\"\",\"\",VLOOKUP(AA4,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC4=\"\",\"\",VLOOKUP(AC4,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE4=\"\",\"\",VLOOKUP(AE4,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG4=\"\",\"\",VLOOKUP(AG4,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI4=\"\",\"\",VLOOKUP(AI4,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK4=\"\",\"\",VLOOKUP(AK4,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN4=\"\",\"\",VLOOKUP(AN4,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR4=\"\",\"\",VLOOKUP(AR4,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV4=\"\",\"\",VLOOKUP(AV4,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J5=\"\",\"\",VLOOKUP(J5,material[],2,FALSE))","v":""},null,{"$f":"IF(L5=\"\",\"\",VLOOKUP(L5,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O5=\"\",\"\",VLOOKUP(O5,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R5=\"\",\"\",VLOOKUP(R5,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y5=\"\",\"\",VLOOKUP(Y5,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA5=\"\",\"\",VLOOKUP(AA5,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC5=\"\",\"\",VLOOKUP(AC5,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE5=\"\",\"\",VLOOKUP(AE5,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG5=\"\",\"\",VLOOKUP(AG5,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI5=\"\",\"\",VLOOKUP(AI5,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK5=\"\",\"\",VLOOKUP(AK5,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN5=\"\",\"\",VLOOKUP(AN5,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR5=\"\",\"\",VLOOKUP(AR5,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV5=\"\",\"\",VLOOKUP(AV5,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J6=\"\",\"\",VLOOKUP(J6,material[],2,FALSE))","v":""},null,{"$f":"IF(L6=\"\",\"\",VLOOKUP(L6,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O6=\"\",\"\",VLOOKUP(O6,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R6=\"\",\"\",VLOOKUP(R6,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y6=\"\",\"\",VLOOKUP(Y6,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA6=\"\",\"\",VLOOKUP(AA6,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC6=\"\",\"\",VLOOKUP(AC6,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE6=\"\",\"\",VLOOKUP(AE6,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG6=\"\",\"\",VLOOKUP(AG6,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI6=\"\",\"\",VLOOKUP(AI6,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK6=\"\",\"\",VLOOKUP(AK6,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN6=\"\",\"\",VLOOKUP(AN6,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR6=\"\",\"\",VLOOKUP(AR6,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV6=\"\",\"\",VLOOKUP(AV6,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J7=\"\",\"\",VLOOKUP(J7,material[],2,FALSE))","v":""},null,{"$f":"IF(L7=\"\",\"\",VLOOKUP(L7,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O7=\"\",\"\",VLOOKUP(O7,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R7=\"\",\"\",VLOOKUP(R7,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y7=\"\",\"\",VLOOKUP(Y7,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA7=\"\",\"\",VLOOKUP(AA7,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC7=\"\",\"\",VLOOKUP(AC7,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE7=\"\",\"\",VLOOKUP(AE7,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG7=\"\",\"\",VLOOKUP(AG7,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI7=\"\",\"\",VLOOKUP(AI7,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK7=\"\",\"\",VLOOKUP(AK7,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN7=\"\",\"\",VLOOKUP(AN7,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR7=\"\",\"\",VLOOKUP(AR7,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV7=\"\",\"\",VLOOKUP(AV7,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J8=\"\",\"\",VLOOKUP(J8,material[],2,FALSE))","v":""},null,{"$f":"IF(L8=\"\",\"\",VLOOKUP(L8,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O8=\"\",\"\",VLOOKUP(O8,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R8=\"\",\"\",VLOOKUP(R8,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y8=\"\",\"\",VLOOKUP(Y8,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA8=\"\",\"\",VLOOKUP(AA8,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC8=\"\",\"\",VLOOKUP(AC8,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE8=\"\",\"\",VLOOKUP(AE8,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG8=\"\",\"\",VLOOKUP(AG8,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI8=\"\",\"\",VLOOKUP(AI8,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK8=\"\",\"\",VLOOKUP(AK8,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN8=\"\",\"\",VLOOKUP(AN8,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR8=\"\",\"\",VLOOKUP(AR8,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV8=\"\",\"\",VLOOKUP(AV8,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J9=\"\",\"\",VLOOKUP(J9,material[],2,FALSE))","v":""},null,{"$f":"IF(L9=\"\",\"\",VLOOKUP(L9,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O9=\"\",\"\",VLOOKUP(O9,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R9=\"\",\"\",VLOOKUP(R9,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y9=\"\",\"\",VLOOKUP(Y9,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA9=\"\",\"\",VLOOKUP(AA9,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC9=\"\",\"\",VLOOKUP(AC9,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE9=\"\",\"\",VLOOKUP(AE9,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG9=\"\",\"\",VLOOKUP(AG9,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI9=\"\",\"\",VLOOKUP(AI9,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK9=\"\",\"\",VLOOKUP(AK9,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN9=\"\",\"\",VLOOKUP(AN9,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR9=\"\",\"\",VLOOKUP(AR9,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV9=\"\",\"\",VLOOKUP(AV9,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J10=\"\",\"\",VLOOKUP(J10,material[],2,FALSE))","v":""},null,{"$f":"IF(L10=\"\",\"\",VLOOKUP(L10,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O10=\"\",\"\",VLOOKUP(O10,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R10=\"\",\"\",VLOOKUP(R10,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y10=\"\",\"\",VLOOKUP(Y10,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA10=\"\",\"\",VLOOKUP(AA10,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC10=\"\",\"\",VLOOKUP(AC10,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE10=\"\",\"\",VLOOKUP(AE10,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG10=\"\",\"\",VLOOKUP(AG10,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI10=\"\",\"\",VLOOKUP(AI10,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK10=\"\",\"\",VLOOKUP(AK10,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN10=\"\",\"\",VLOOKUP(AN10,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR10=\"\",\"\",VLOOKUP(AR10,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV10=\"\",\"\",VLOOKUP(AV10,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J11=\"\",\"\",VLOOKUP(J11,material[],2,FALSE))","v":""},null,{"$f":"IF(L11=\"\",\"\",VLOOKUP(L11,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O11=\"\",\"\",VLOOKUP(O11,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R11=\"\",\"\",VLOOKUP(R11,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y11=\"\",\"\",VLOOKUP(Y11,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA11=\"\",\"\",VLOOKUP(AA11,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC11=\"\",\"\",VLOOKUP(AC11,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE11=\"\",\"\",VLOOKUP(AE11,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG11=\"\",\"\",VLOOKUP(AG11,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI11=\"\",\"\",VLOOKUP(AI11,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK11=\"\",\"\",VLOOKUP(AK11,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN11=\"\",\"\",VLOOKUP(AN11,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR11=\"\",\"\",VLOOKUP(AR11,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV11=\"\",\"\",VLOOKUP(AV11,replace_reason[],2,FALSE))","v":""}]
["null","null",null,null,null,null,{"$f":"IF(F12=\"\",\"\",VLOOKUP(F12,type[],2,FALSE))","v":""},null,{"$f":"IF(H12=\"\",\"\",VLOOKUP(H12,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J12=\"\",\"\",VLOOKUP(J12,material[],2,FALSE))","v":""},null,{"$f":"IF(L12=\"\",\"\",VLOOKUP(L12,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O12=\"\",\"\",VLOOKUP(O12,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R12=\"\",\"\",VLOOKUP(R12,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y12=\"\",\"\",VLOOKUP(Y12,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA12=\"\",\"\",VLOOKUP(AA12,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC12=\"\",\"\",VLOOKUP(AC12,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE12=\"\",\"\",VLOOKUP(AE12,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG12=\"\",\"\",VLOOKUP(AG12,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI12=\"\",\"\",VLOOKUP(AI12,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK12=\"\",\"\",VLOOKUP(AK12,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN12=\"\",\"\",VLOOKUP(AN12,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR12=\"\",\"\",VLOOKUP(AR12,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV12=\"\",\"\",VLOOKUP(AV12,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J13=\"\",\"\",VLOOKUP(J13,material[],2,FALSE))","v":""},null,{"$f":"IF(L13=\"\",\"\",VLOOKUP(L13,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O13=\"\",\"\",VLOOKUP(O13,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R13=\"\",\"\",VLOOKUP(R13,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y13=\"\",\"\",VLOOKUP(Y13,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA13=\"\",\"\",VLOOKUP(AA13,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC13=\"\",\"\",VLOOKUP(AC13,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE13=\"\",\"\",VLOOKUP(AE13,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG13=\"\",\"\",VLOOKUP(AG13,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI13=\"\",\"\",VLOOKUP(AI13,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK13=\"\",\"\",VLOOKUP(AK13,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN13=\"\",\"\",VLOOKUP(AN13,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR13=\"\",\"\",VLOOKUP(AR13,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV13=\"\",\"\",VLOOKUP(AV13,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J14=\"\",\"\",VLOOKUP(J14,material[],2,FALSE))","v":""},null,{"$f":"IF(L14=\"\",\"\",VLOOKUP(L14,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O14=\"\",\"\",VLOOKUP(O14,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R14=\"\",\"\",VLOOKUP(R14,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y14=\"\",\"\",VLOOKUP(Y14,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA14=\"\",\"\",VLOOKUP(AA14,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC14=\"\",\"\",VLOOKUP(AC14,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE14=\"\",\"\",VLOOKUP(AE14,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG14=\"\",\"\",VLOOKUP(AG14,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI14=\"\",\"\",VLOOKUP(AI14,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK14=\"\",\"\",VLOOKUP(AK14,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN14=\"\",\"\",VLOOKUP(AN14,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR14=\"\",\"\",VLOOKUP(AR14,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV14=\"\",\"\",VLOOKUP(AV14,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J15=\"\",\"\",VLOOKUP(J15,material[],2,FALSE))","v":""},null,{"$f":"IF(L15=\"\",\"\",VLOOKUP(L15,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O15=\"\",\"\",VLOOKUP(O15,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R15=\"\",\"\",VLOOKUP(R15,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y15=\"\",\"\",VLOOKUP(Y15,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA15=\"\",\"\",VLOOKUP(AA15,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC15=\"\",\"\",VLOOKUP(AC15,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE15=\"\",\"\",VLOOKUP(AE15,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG15=\"\",\"\",VLOOKUP(AG15,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI15=\"\",\"\",VLOOKUP(AI15,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK15=\"\",\"\",VLOOKUP(AK15,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN15=\"\",\"\",VLOOKUP(AN15,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR15=\"\",\"\",VLOOKUP(AR15,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV15=\"\",\"\",VLOOKUP(AV15,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J16=\"\",\"\",VLOOKUP(J16,material[],2,FALSE))","v":""},null,{"$f":"IF(L16=\"\",\"\",VLOOKUP(L16,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O16=\"\",\"\",VLOOKUP(O16,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R16=\"\",\"\",VLOOKUP(R16,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y16=\"\",\"\",VLOOKUP(Y16,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA16=\"\",\"\",VLOOKUP(AA16,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC16=\"\",\"\",VLOOKUP(AC16,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE16=\"\",\"\",VLOOKUP(AE16,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG16=\"\",\"\",VLOOKUP(AG16,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI16=\"\",\"\",VLOOKUP(AI16,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK16=\"\",\"\",VLOOKUP(AK16,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN16=\"\",\"\",VLOOKUP(AN16,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR16=\"\",\"\",VLOOKUP(AR16,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV16=\"\",\"\",VLOOKUP(AV16,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J17=\"\",\"\",VLOOKUP(J17,material[],2,FALSE))","v":""},null,{"$f":"IF(L17=\"\",\"\",VLOOKUP(L17,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O17=\"\",\"\",VLOOKUP(O17,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R17=\"\",\"\",VLOOKUP(R17,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y17=\"\",\"\",VLOOKUP(Y17,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA17=\"\",\"\",VLOOKUP(AA17,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC17=\"\",\"\",VLOOKUP(AC17,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE17=\"\",\"\",VLOOKUP(AE17,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG17=\"\",\"\",VLOOKUP(AG17,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI17=\"\",\"\",VLOOKUP(AI17,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK17=\"\",\"\",VLOOKUP(AK17,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN17=\"\",\"\",VLOOKUP(AN17,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR17=\"\",\"\",VLOOKUP(AR17,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV17=\"\",\"\",VLOOKUP(AV17,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J18=\"\",\"\",VLOOKUP(J18,material[],2,FALSE))","v":""},null,{"$f":"IF(L18=\"\",\"\",VLOOKUP(L18,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O18=\"\",\"\",VLOOKUP(O18,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R18=\"\",\"\",VLOOKUP(R18,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y18=\"\",\"\",VLOOKUP(Y18,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA18=\"\",\"\",VLOOKUP(AA18,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC18=\"\",\"\",VLOOKUP(AC18,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE18=\"\",\"\",VLOOKUP(AE18,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG18=\"\",\"\",VLOOKUP(AG18,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI18=\"\",\"\",VLOOKUP(AI18,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK18=\"\",\"\",VLOOKUP(AK18,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN18=\"\",\"\",VLOOKUP(AN18,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR18=\"\",\"\",VLOOKUP(AR18,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV18=\"\",\"\",VLOOKUP(AV18,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J19=\"\",\"\",VLOOKUP(J19,material[],2,FALSE))","v":""},null,{"$f":"IF(L19=\"\",\"\",VLOOKUP(L19,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O19=\"\",\"\",VLOOKUP(O19,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R19=\"\",\"\",VLOOKUP(R19,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y19=\"\",\"\",VLOOKUP(Y19,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA19=\"\",\"\",VLOOKUP(AA19,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC19=\"\",\"\",VLOOKUP(AC19,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE19=\"\",\"\",VLOOKUP(AE19,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG19=\"\",\"\",VLOOKUP(AG19,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI19=\"\",\"\",VLOOKUP(AI19,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK19=\"\",\"\",VLOOKUP(AK19,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN19=\"\",\"\",VLOOKUP(AN19,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR19=\"\",\"\",VLOOKUP(AR19,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV19=\"\",\"\",VLOOKUP(AV19,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J20=\"\",\"\",VLOOKUP(J20,material[],2,FALSE))","v":""},null,{"$f":"IF(L20=\"\",\"\",VLOOKUP(L20,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O20=\"\",\"\",VLOOKUP(O20,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R20=\"\",\"\",VLOOKUP(R20,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y20=\"\",\"\",VLOOKUP(Y20,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA20=\"\",\"\",VLOOKUP(AA20,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC20=\"\",\"\",VLOOKUP(AC20,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE20=\"\",\"\",VLOOKUP(AE20,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG20=\"\",\"\",VLOOKUP(AG20,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI20=\"\",\"\",VLOOKUP(AI20,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK20=\"\",\"\",VLOOKUP(AK20,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN20=\"\",\"\",VLOOKUP(AN20,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR20=\"\",\"\",VLOOKUP(AR20,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV20=\"\",\"\",VLOOKUP(AV20,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J21=\"\",\"\",VLOOKUP(J21,material[],2,FALSE))","v":""},null,{"$f":"IF(L21=\"\",\"\",VLOOKUP(L21,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O21=\"\",\"\",VLOOKUP(O21,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R21=\"\",\"\",VLOOKUP(R21,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y21=\"\",\"\",VLOOKUP(Y21,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA21=\"\",\"\",VLOOKUP(AA21,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC21=\"\",\"\",VLOOKUP(AC21,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE21=\"\",\"\",VLOOKUP(AE21,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG21=\"\",\"\",VLOOKUP(AG21,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI21=\"\",\"\",VLOOKUP(AI21,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK21=\"\",\"\",VLOOKUP(AK21,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN21=\"\",\"\",VLOOKUP(AN21,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR21=\"\",\"\",VLOOKUP(AR21,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV21=\"\",\"\",VLOOKUP(AV21,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J22=\"\",\"\",VLOOKUP(J22,material[],2,FALSE))","v":""},null,{"$f":"IF(L22=\"\",\"\",VLOOKUP(L22,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O22=\"\",\"\",VLOOKUP(O22,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R22=\"\",\"\",VLOOKUP(R22,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y22=\"\",\"\",VLOOKUP(Y22,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA22=\"\",\"\",VLOOKUP(AA22,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC22=\"\",\"\",VLOOKUP(AC22,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE22=\"\",\"\",VLOOKUP(AE22,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG22=\"\",\"\",VLOOKUP(AG22,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI22=\"\",\"\",VLOOKUP(AI22,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK22=\"\",\"\",VLOOKUP(AK22,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN22=\"\",\"\",VLOOKUP(AN22,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR22=\"\",\"\",VLOOKUP(AR22,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV22=\"\",\"\",VLOOKUP(AV22,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J23=\"\",\"\",VLOOKUP(J23,material[],2,FALSE))","v":""},null,{"$f":"IF(L23=\"\",\"\",VLOOKUP(L23,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O23=\"\",\"\",VLOOKUP(O23,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R23=\"\",\"\",VLOOKUP(R23,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y23=\"\",\"\",VLOOKUP(Y23,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA23=\"\",\"\",VLOOKUP(AA23,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC23=\"\",\"\",VLOOKUP(AC23,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE23=\"\",\"\",VLOOKUP(AE23,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG23=\"\",\"\",VLOOKUP(AG23,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI23=\"\",\"\",VLOOKUP(AI23,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK23=\"\",\"\",VLOOKUP(AK23,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN23=\"\",\"\",VLOOKUP(AN23,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR23=\"\",\"\",VLOOKUP(AR23,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV23=\"\",\"\",VLOOKUP(AV23,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J24=\"\",\"\",VLOOKUP(J24,material[],2,FALSE))","v":""},null,{"$f":"IF(L24=\"\",\"\",VLOOKUP(L24,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O24=\"\",\"\",VLOOKUP(O24,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R24=\"\",\"\",VLOOKUP(R24,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y24=\"\",\"\",VLOOKUP(Y24,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA24=\"\",\"\",VLOOKUP(AA24,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC24=\"\",\"\",VLOOKUP(AC24,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE24=\"\",\"\",VLOOKUP(AE24,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG24=\"\",\"\",VLOOKUP(AG24,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI24=\"\",\"\",VLOOKUP(AI24,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK24=\"\",\"\",VLOOKUP(AK24,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN24=\"\",\"\",VLOOKUP(AN24,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR24=\"\",\"\",VLOOKUP(AR24,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV24=\"\",\"\",VLOOKUP(AV24,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J25=\"\",\"\",VLOOKUP(J25,material[],2,FALSE))","v":""},null,{"$f":"IF(L25=\"\",\"\",VLOOKUP(L25,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O25=\"\",\"\",VLOOKUP(O25,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R25=\"\",\"\",VLOOKUP(R25,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y25=\"\",\"\",VLOOKUP(Y25,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA25=\"\",\"\",VLOOKUP(AA25,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC25=\"\",\"\",VLOOKUP(AC25,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE25=\"\",\"\",VLOOKUP(AE25,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG25=\"\",\"\",VLOOKUP(AG25,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI25=\"\",\"\",VLOOKUP(AI25,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK25=\"\",\"\",VLOOKUP(AK25,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN25=\"\",\"\",VLOOKUP(AN25,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR25=\"\",\"\",VLOOKUP(AR25,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV25=\"\",\"\",VLOOKUP(AV25,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J26=\"\",\"\",VLOOKUP(J26,material[],2,FALSE))","v":""},null,{"$f":"IF(L26=\"\",\"\",VLOOKUP(L26,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O26=\"\",\"\",VLOOKUP(O26,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R26=\"\",\"\",VLOOKUP(R26,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y26=\"\",\"\",VLOOKUP(Y26,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA26=\"\",\"\",VLOOKUP(AA26,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC26=\"\",\"\",VLOOKUP(AC26,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE26=\"\",\"\",VLOOKUP(AE26,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG26=\"\",\"\",VLOOKUP(AG26,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI26=\"\",\"\",VLOOKUP(AI26,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK26=\"\",\"\",VLOOKUP(AK26,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN26=\"\",\"\",VLOOKUP(AN26,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR26=\"\",\"\",VLOOKUP(AR26,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV26=\"\",\"\",VLOOKUP(AV26,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J27=\"\",\"\",VLOOKUP(J27,material[],2,FALSE))","v":""},null,{"$f":"IF(L27=\"\",\"\",VLOOKUP(L27,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O27=\"\",\"\",VLOOKUP(O27,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R27=\"\",\"\",VLOOKUP(R27,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y27=\"\",\"\",VLOOKUP(Y27,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA27=\"\",\"\",VLOOKUP(AA27,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC27=\"\",\"\",VLOOKUP(AC27,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE27=\"\",\"\",VLOOKUP(AE27,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG27=\"\",\"\",VLOOKUP(AG27,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI27=\"\",\"\",VLOOKUP(AI27,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK27=\"\",\"\",VLOOKUP(AK27,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN27=\"\",\"\",VLOOKUP(AN27,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR27=\"\",\"\",VLOOKUP(AR27,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV27=\"\",\"\",VLOOKUP(AV27,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J28=\"\",\"\",VLOOKUP(J28,material[],2,FALSE))","v":""},null,{"$f":"IF(L28=\"\",\"\",VLOOKUP(L28,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O28=\"\",\"\",VLOOKUP(O28,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R28=\"\",\"\",VLOOKUP(R28,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y28=\"\",\"\",VLOOKUP(Y28,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA28=\"\",\"\",VLOOKUP(AA28,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC28=\"\",\"\",VLOOKUP(AC28,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE28=\"\",\"\",VLOOKUP(AE28,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG28=\"\",\"\",VLOOKUP(AG28,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI28=\"\",\"\",VLOOKUP(AI28,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK28=\"\",\"\",VLOOKUP(AK28,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN28=\"\",\"\",VLOOKUP(AN28,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR28=\"\",\"\",VLOOKUP(AR28,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV28=\"\",\"\",VLOOKUP(AV28,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J29=\"\",\"\",VLOOKUP(J29,material[],2,FALSE))","v":""},null,{"$f":"IF(L29=\"\",\"\",VLOOKUP(L29,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O29=\"\",\"\",VLOOKUP(O29,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R29=\"\",\"\",VLOOKUP(R29,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y29=\"\",\"\",VLOOKUP(Y29,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA29=\"\",\"\",VLOOKUP(AA29,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC29=\"\",\"\",VLOOKUP(AC29,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE29=\"\",\"\",VLOOKUP(AE29,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG29=\"\",\"\",VLOOKUP(AG29,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI29=\"\",\"\",VLOOKUP(AI29,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK29=\"\",\"\",VLOOKUP(AK29,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN29=\"\",\"\",VLOOKUP(AN29,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR29=\"\",\"\",VLOOKUP(AR29,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV29=\"\",\"\",VLOOKUP(AV29,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J30=\"\",\"\",VLOOKUP(J30,material[],2,FALSE))","v":""},null,{"$f":"IF(L30=\"\",\"\",VLOOKUP(L30,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O30=\"\",\"\",VLOOKUP(O30,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R30=\"\",\"\",VLOOKUP(R30,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y30=\"\",\"\",VLOOKUP(Y30,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA30=\"\",\"\",VLOOKUP(AA30,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC30=\"\",\"\",VLOOKUP(AC30,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE30=\"\",\"\",VLOOKUP(AE30,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG30=\"\",\"\",VLOOKUP(AG30,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI30=\"\",\"\",VLOOKUP(AI30,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK30=\"\",\"\",VLOOKUP(AK30,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN30=\"\",\"\",VLOOKUP(AN30,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR30=\"\",\"\",VLOOKUP(AR30,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV30=\"\",\"\",VLOOKUP(AV30,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J31=\"\",\"\",VLOOKUP(J31,material[],2,FALSE))","v":""},null,{"$f":"IF(L31=\"\",\"\",VLOOKUP(L31,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O31=\"\",\"\",VLOOKUP(O31,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R31=\"\",\"\",VLOOKUP(R31,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y31=\"\",\"\",VLOOKUP(Y31,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA31=\"\",\"\",VLOOKUP(AA31,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC31=\"\",\"\",VLOOKUP(AC31,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE31=\"\",\"\",VLOOKUP(AE31,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG31=\"\",\"\",VLOOKUP(AG31,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI31=\"\",\"\",VLOOKUP(AI31,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK31=\"\",\"\",VLOOKUP(AK31,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN31=\"\",\"\",VLOOKUP(AN31,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR31=\"\",\"\",VLOOKUP(AR31,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV31=\"\",\"\",VLOOKUP(AV31,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J32=\"\",\"\",VLOOKUP(J32,material[],2,FALSE))","v":""},null,{"$f":"IF(L32=\"\",\"\",VLOOKUP(L32,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O32=\"\",\"\",VLOOKUP(O32,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R32=\"\",\"\",VLOOKUP(R32,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y32=\"\",\"\",VLOOKUP(Y32,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA32=\"\",\"\",VLOOKUP(AA32,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC32=\"\",\"\",VLOOKUP(AC32,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE32=\"\",\"\",VLOOKUP(AE32,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG32=\"\",\"\",VLOOKUP(AG32,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI32=\"\",\"\",VLOOKUP(AI32,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK32=\"\",\"\",VLOOKUP(AK32,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN32=\"\",\"\",VLOOKUP(AN32,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR32=\"\",\"\",VLOOKUP(AR32,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV32=\"\",\"\",VLOOKUP(AV32,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J33=\"\",\"\",VLOOKUP(J33,material[],2,FALSE))","v":""},null,{"$f":"IF(L33=\"\",\"\",VLOOKUP(L33,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O33=\"\",\"\",VLOOKUP(O33,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R33=\"\",\"\",VLOOKUP(R33,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y33=\"\",\"\",VLOOKUP(Y33,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA33=\"\",\"\",VLOOKUP(AA33,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC33=\"\",\"\",VLOOKUP(AC33,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE33=\"\",\"\",VLOOKUP(AE33,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG33=\"\",\"\",VLOOKUP(AG33,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI33=\"\",\"\",VLOOKUP(AI33,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK33=\"\",\"\",VLOOKUP(AK33,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN33=\"\",\"\",VLOOKUP(AN33,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR33=\"\",\"\",VLOOKUP(AR33,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV33=\"\",\"\",VLOOKUP(AV33,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J34=\"\",\"\",VLOOKUP(J34,material[],2,FALSE))","v":""},null,{"$f":"IF(L34=\"\",\"\",VLOOKUP(L34,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O34=\"\",\"\",VLOOKUP(O34,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R34=\"\",\"\",VLOOKUP(R34,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y34=\"\",\"\",VLOOKUP(Y34,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA34=\"\",\"\",VLOOKUP(AA34,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC34=\"\",\"\",VLOOKUP(AC34,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE34=\"\",\"\",VLOOKUP(AE34,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG34=\"\",\"\",VLOOKUP(AG34,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI34=\"\",\"\",VLOOKUP(AI34,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK34=\"\",\"\",VLOOKUP(AK34,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN34=\"\",\"\",VLOOKUP(AN34,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR34=\"\",\"\",VLOOKUP(AR34,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV34=\"\",\"\",VLOOKUP(AV34,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J35=\"\",\"\",VLOOKUP(J35,material[],2,FALSE))","v":""},null,{"$f":"IF(L35=\"\",\"\",VLOOKUP(L35,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O35=\"\",\"\",VLOOKUP(O35,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R35=\"\",\"\",VLOOKUP(R35,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y35=\"\",\"\",VLOOKUP(Y35,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA35=\"\",\"\",VLOOKUP(AA35,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC35=\"\",\"\",VLOOKUP(AC35,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE35=\"\",\"\",VLOOKUP(AE35,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG35=\"\",\"\",VLOOKUP(AG35,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI35=\"\",\"\",VLOOKUP(AI35,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK35=\"\",\"\",VLOOKUP(AK35,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN35=\"\",\"\",VLOOKUP(AN35,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR35=\"\",\"\",VLOOKUP(AR35,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV35=\"\",\"\",VLOOKUP(AV35,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J36=\"\",\"\",VLOOKUP(J36,material[],2,FALSE))","v":""},null,{"$f":"IF(L36=\"\",\"\",VLOOKUP(L36,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O36=\"\",\"\",VLOOKUP(O36,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R36=\"\",\"\",VLOOKUP(R36,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y36=\"\",\"\",VLOOKUP(Y36,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA36=\"\",\"\",VLOOKUP(AA36,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC36=\"\",\"\",VLOOKUP(AC36,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE36=\"\",\"\",VLOOKUP(AE36,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG36=\"\",\"\",VLOOKUP(AG36,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI36=\"\",\"\",VLOOKUP(AI36,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK36=\"\",\"\",VLOOKUP(AK36,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN36=\"\",\"\",VLOOKUP(AN36,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR36=\"\",\"\",VLOOKUP(AR36,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV36=\"\",\"\",VLOOKUP(AV36,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J37=\"\",\"\",VLOOKUP(J37,material[],2,FALSE))","v":""},null,{"$f":"IF(L37=\"\",\"\",VLOOKUP(L37,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O37=\"\",\"\",VLOOKUP(O37,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R37=\"\",\"\",VLOOKUP(R37,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y37=\"\",\"\",VLOOKUP(Y37,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA37=\"\",\"\",VLOOKUP(AA37,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC37=\"\",\"\",VLOOKUP(AC37,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE37=\"\",\"\",VLOOKUP(AE37,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG37=\"\",\"\",VLOOKUP(AG37,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI37=\"\",\"\",VLOOKUP(AI37,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK37=\"\",\"\",VLOOKUP(AK37,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN37=\"\",\"\",VLOOKUP(AN37,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR37=\"\",\"\",VLOOKUP(AR37,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV37=\"\",\"\",VLOOKUP(AV37,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J38=\"\",\"\",VLOOKUP(J38,material[],2,FALSE))","v":""},null,{"$f":"IF(L38=\"\",\"\",VLOOKUP(L38,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O38=\"\",\"\",VLOOKUP(O38,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R38=\"\",\"\",VLOOKUP(R38,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y38=\"\",\"\",VLOOKUP(Y38,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA38=\"\",\"\",VLOOKUP(AA38,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC38=\"\",\"\",VLOOKUP(AC38,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE38=\"\",\"\",VLOOKUP(AE38,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG38=\"\",\"\",VLOOKUP(AG38,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI38=\"\",\"\",VLOOKUP(AI38,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK38=\"\",\"\",VLOOKUP(AK38,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN38=\"\",\"\",VLOOKUP(AN38,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR38=\"\",\"\",VLOOKUP(AR38,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV38=\"\",\"\",VLOOKUP(AV38,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J39=\"\",\"\",VLOOKUP(J39,material[],2,FALSE))","v":""},null,{"$f":"IF(L39=\"\",\"\",VLOOKUP(L39,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O39=\"\",\"\",VLOOKUP(O39,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R39=\"\",\"\",VLOOKUP(R39,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y39=\"\",\"\",VLOOKUP(Y39,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA39=\"\",\"\",VLOOKUP(AA39,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC39=\"\",\"\",VLOOKUP(AC39,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE39=\"\",\"\",VLOOKUP(AE39,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG39=\"\",\"\",VLOOKUP(AG39,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI39=\"\",\"\",VLOOKUP(AI39,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK39=\"\",\"\",VLOOKUP(AK39,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN39=\"\",\"\",VLOOKUP(AN39,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR39=\"\",\"\",VLOOKUP(AR39,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV39=\"\",\"\",VLOOKUP(AV39,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J40=\"\",\"\",VLOOKUP(J40,material[],2,FALSE))","v":""},null,{"$f":"IF(L40=\"\",\"\",VLOOKUP(L40,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O40=\"\",\"\",VLOOKUP(O40,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R40=\"\",\"\",VLOOKUP(R40,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y40=\"\",\"\",VLOOKUP(Y40,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA40=\"\",\"\",VLOOKUP(AA40,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC40=\"\",\"\",VLOOKUP(AC40,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE40=\"\",\"\",VLOOKUP(AE40,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG40=\"\",\"\",VLOOKUP(AG40,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI40=\"\",\"\",VLOOKUP(AI40,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK40=\"\",\"\",VLOOKUP(AK40,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN40=\"\",\"\",VLOOKUP(AN40,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR40=\"\",\"\",VLOOKUP(AR40,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV40=\"\",\"\",VLOOKUP(AV40,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J41=\"\",\"\",VLOOKUP(J41,material[],2,FALSE))","v":""},null,{"$f":"IF(L41=\"\",\"\",VLOOKUP(L41,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O41=\"\",\"\",VLOOKUP(O41,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R41=\"\",\"\",VLOOKUP(R41,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y41=\"\",\"\",VLOOKUP(Y41,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA41=\"\",\"\",VLOOKUP(AA41,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC41=\"\",\"\",VLOOKUP(AC41,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE41=\"\",\"\",VLOOKUP(AE41,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG41=\"\",\"\",VLOOKUP(AG41,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI41=\"\",\"\",VLOOKUP(AI41,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK41=\"\",\"\",VLOOKUP(AK41,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN41=\"\",\"\",VLOOKUP(AN41,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR41=\"\",\"\",VLOOKUP(AR41,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV41=\"\",\"\",VLOOKUP(AV41,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J42=\"\",\"\",VLOOKUP(J42,material[],2,FALSE))","v":""},null,{"$f":"IF(L42=\"\",\"\",VLOOKUP(L42,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O42=\"\",\"\",VLOOKUP(O42,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R42=\"\",\"\",VLOOKUP(R42,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y42=\"\",\"\",VLOOKUP(Y42,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA42=\"\",\"\",VLOOKUP(AA42,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC42=\"\",\"\",VLOOKUP(AC42,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE42=\"\",\"\",VLOOKUP(AE42,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG42=\"\",\"\",VLOOKUP(AG42,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI42=\"\",\"\",VLOOKUP(AI42,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK42=\"\",\"\",VLOOKUP(AK42,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN42=\"\",\"\",VLOOKUP(AN42,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR42=\"\",\"\",VLOOKUP(AR42,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV42=\"\",\"\",VLOOKUP(AV42,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J43=\"\",\"\",VLOOKUP(J43,material[],2,FALSE))","v":""},null,{"$f":"IF(L43=\"\",\"\",VLOOKUP(L43,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O43=\"\",\"\",VLOOKUP(O43,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R43=\"\",\"\",VLOOKUP(R43,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y43=\"\",\"\",VLOOKUP(Y43,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA43=\"\",\"\",VLOOKUP(AA43,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC43=\"\",\"\",VLOOKUP(AC43,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE43=\"\",\"\",VLOOKUP(AE43,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG43=\"\",\"\",VLOOKUP(AG43,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI43=\"\",\"\",VLOOKUP(AI43,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK43=\"\",\"\",VLOOKUP(AK43,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN43=\"\",\"\",VLOOKUP(AN43,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR43=\"\",\"\",VLOOKUP(AR43,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV43=\"\",\"\",VLOOKUP(AV43,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J44=\"\",\"\",VLOOKUP(J44,material[],2,FALSE))","v":""},null,{"$f":"IF(L44=\"\",\"\",VLOOKUP(L44,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O44=\"\",\"\",VLOOKUP(O44,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R44=\"\",\"\",VLOOKUP(R44,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y44=\"\",\"\",VLOOKUP(Y44,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA44=\"\",\"\",VLOOKUP(AA44,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC44=\"\",\"\",VLOOKUP(AC44,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE44=\"\",\"\",VLOOKUP(AE44,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG44=\"\",\"\",VLOOKUP(AG44,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI44=\"\",\"\",VLOOKUP(AI44,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK44=\"\",\"\",VLOOKUP(AK44,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN44=\"\",\"\",VLOOKUP(AN44,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR44=\"\",\"\",VLOOKUP(AR44,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV44=\"\",\"\",VLOOKUP(AV44,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J45=\"\",\"\",VLOOKUP(J45,material[],2,FALSE))","v":""},null,{"$f":"IF(L45=\"\",\"\",VLOOKUP(L45,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O45=\"\",\"\",VLOOKUP(O45,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R45=\"\",\"\",VLOOKUP(R45,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y45=\"\",\"\",VLOOKUP(Y45,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA45=\"\",\"\",VLOOKUP(AA45,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC45=\"\",\"\",VLOOKUP(AC45,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE45=\"\",\"\",VLOOKUP(AE45,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG45=\"\",\"\",VLOOKUP(AG45,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI45=\"\",\"\",VLOOKUP(AI45,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK45=\"\",\"\",VLOOKUP(AK45,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN45=\"\",\"\",VLOOKUP(AN45,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR45=\"\",\"\",VLOOKUP(AR45,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV45=\"\",\"\",VLOOKUP(AV45,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J46=\"\",\"\",VLOOKUP(J46,material[],2,FALSE))","v":""},null,{"$f":"IF(L46=\"\",\"\",VLOOKUP(L46,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O46=\"\",\"\",VLOOKUP(O46,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R46=\"\",\"\",VLOOKUP(R46,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y46=\"\",\"\",VLOOKUP(Y46,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA46=\"\",\"\",VLOOKUP(AA46,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC46=\"\",\"\",VLOOKUP(AC46,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE46=\"\",\"\",VLOOKUP(AE46,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG46=\"\",\"\",VLOOKUP(AG46,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI46=\"\",\"\",VLOOKUP(AI46,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK46=\"\",\"\",VLOOKUP(AK46,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN46=\"\",\"\",VLOOKUP(AN46,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR46=\"\",\"\",VLOOKUP(AR46,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV46=\"\",\"\",VLOOKUP(AV46,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J47=\"\",\"\",VLOOKUP(J47,material[],2,FALSE))","v":""},null,{"$f":"IF(L47=\"\",\"\",VLOOKUP(L47,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O47=\"\",\"\",VLOOKUP(O47,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R47=\"\",\"\",VLOOKUP(R47,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y47=\"\",\"\",VLOOKUP(Y47,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA47=\"\",\"\",VLOOKUP(AA47,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC47=\"\",\"\",VLOOKUP(AC47,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE47=\"\",\"\",VLOOKUP(AE47,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG47=\"\",\"\",VLOOKUP(AG47,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI47=\"\",\"\",VLOOKUP(AI47,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK47=\"\",\"\",VLOOKUP(AK47,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN47=\"\",\"\",VLOOKUP(AN47,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR47=\"\",\"\",VLOOKUP(AR47,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV47=\"\",\"\",VLOOKUP(AV47,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,subtype[],2,FALSE))","v":""},null,{"$f":"IF(J48=\"\",\"\",VLOOKUP(J48,material[],2,FALSE))","v":""},null,{"$f":"IF(L48=\"\",\"\",VLOOKUP(L48,style[],2,FALSE))","v":""},null,null,{"$f":"IF(O48=\"\",\"\",VLOOKUP(O48,extra_length_reason[],2,FALSE))","v":""},null,null,{"$f":"IF(R48=\"\",\"\",VLOOKUP(R48,side[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(Y48=\"\",\"\",VLOOKUP(Y48,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AA48=\"\",\"\",VLOOKUP(AA48,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AC48=\"\",\"\",VLOOKUP(AC48,consequence[],2,FALSE))","v":""},null,{"$f":"IF(AE48=\"\",\"\",VLOOKUP(AE48,risk[],2,FALSE))","v":""},null,{"$f":"IF(AG48=\"\",\"\",VLOOKUP(AG48,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AI48=\"\",\"\",VLOOKUP(AI48,use_default[],2,FALSE))","v":""},null,{"$f":"IF(AK48=\"\",\"\",VLOOKUP(AK48,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AN48=\"\",\"\",VLOOKUP(AN48,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AR48=\"\",\"\",VLOOKUP(AR48,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AV48=\"\",\"\",VLOOKUP(AV48,replace_reason[],2,FALSE))","v":""}]

{"sheet":"Lookups","index":1,"n_rows":151,"n_cols":47,"rows_kept":151,"cut":false,"hidden":false,"merged":[]}
["type description","type",null,"subtype description","subtype",null,"material description","material",null,"style description","style",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"]
["Cycle Holding Rail","CYCLER",null,"Advertising Standard","ADSTD",null,"Armco","ARMCO",null,"Angled","A",null,"Ends away from the road","AWAY",null,"Centre","C",null,"Asset Renewal - end of life","01",null,"Crown","C",null,"Rare","1",null,"Insignificant","1",null,"Very Low","1",null,"Not Reset","N",null,"Default","D",null,"Excellent","1",null,"3M","3M",null,"Asset Renewal - end of life","01"]
["Dam","DAM",null,"Bagged Concrete","BCON",null,"Steel Composite","COMP",null,"Horizontal","H",null,"Ends beyond Road End","BYOND",null,"Left","L",null,"Crash Damage","02",null,"Local Authority","L",null,"Unlikely","2",null,"Minor","2",null,"Low","2",null,"Reset to Zero","R",null,"User","U",null,"Good","2",null,"Automobile Association","AA",null,"Crash Damage","02"]
["Ducting Pit","DUCT",null,"Cantilever","CANT",null,"Concrete","CON",null,"Lattice","L",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"]
["Fencing","FENCE",null,"Rock fall catch fence","CATCH",null,"Steel Drum","DRUM",null,"None","NONE",null,"Cul de sac","CUL",null,null,null,null,"Projects","04",null,null,null,null,"Likely","4",null,"Major","4",null,"High","4",null,null,null,null,null,null,null,"Poor","4",null,"Alarm Centre Installation Ltd","ACI",null,"Projects","04"]
["FORD","FORD",null,"Compacted Earth","COM",null,"Earth","EARTH",null,"Other","OTHER",null,"Dummy of No Length","DUMMY",null,null,null,null,"Vandalism","05",null,null,null,null,"Almost Certain","5",null,"Extreme","5",null,"Extreme","5",null,null,null,null,null,null,null,"Very poor","5",null,"Agfirst","AGF",null,"Vandalism","05"]
["Foundation","FOUND",null,"Concrete","CON",null,"Galvanised Steel","GALV",null,"Vertical","V",null,"Starts or Ends at an Intersection","ISECT",null,null,null,null,null,null,null,null,null,null,"Unknown","U",null,"Unknown","U",null,"Unknown","U",null,null,null,null,null,null,null,null,null,null,"Auckland Motorway Alliance","AMA"]
["Sign and Signal Support","GANTRY",null,"Concrete","CONC",null,"Geotextile","GEOTX",null,null,null,null,"No adjustments made","NONE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asset Management Engineers Ltd","AME"]
["Groyne","GROYNE",null,"Double","DBLE",null,"Other","OTHER",null,null,null,null,"Roundabout","RAB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asset Management Technicians Ltd","AMT"]
["Overbridge","OBR",null,"Draped mesh rockfall","DMESH",null,"Plastic","PLAST",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,"Armitage Systems","ARM"]
["Sea Protection Work","SEAPRO",null,"Footpath","FTP",null,"Rock","ROCK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aspect Solutions Ltd","ASL"]
["Tank","TANK",null,"Gabion","GABN",null,"Steel","STEEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auckland System Management","ASM"]
["Traffic Barrier","TBAR",null,"Moveable Traffic Barrier","GATE",null,"Stone","STONE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auckland Transport","AT2"]
["Tunnel","TUNNEL",null,"Long glass","GLASS",null,"Steel and wood","STW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aspect Technology and Equipment Ltd","ATE"]
["Underpass","UPASS",null,"ITS Minor","ITSMI",null,"Timber","TIM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ARRB Transport Research Ltd","ATR"]
["Non Retaining Wall","WALL",null,"ITS Mast","ITSMS",null,"Wood","WOOD",null,null,null,null,null,null,null,null,null,null,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"]
["Weigh Bridge","WBRD",null,"Joint Pit","JOINT",null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Weigh in Motion Station","WIM",null,"Median","MED",null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["Weigh Station","WSTAT",null,"Not applicable","N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bartley Consultants Ltd","BAR"]
[null,null,null,"Very new","NEW",null,null,null,null,null,null,null,null,null,null,null,null,null,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&"]
[null,null,null,"Noise reduction fencing","NOISE",null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,"Old small sides, narrow window","OLD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Buller District Council","BDC"]
[null,null,null,"Pedestrian fence","PED",null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,"Pre-historic","PREHS",null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,"Pull Pit","PULL",null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,"Railway","RAIL",null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,"Rock","ROCK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City Care Ltd","CCL"]
[null,null,null,"Single","SNGLE",null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,"Special","SPECL",null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,"Standard with sides","STD",null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,"Stock","STOCK",null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,"Vehicle","VEH",null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ferguson Ind","FGI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fulton Hogan (NZ) Ltd.","FUL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gisborne District Council","GDC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geosolve Ltd","GEO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GHD Ltd.","GHD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEB Construction Ltd","HEB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Higgins Contractors Ltd.","HIG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HMI Technologies","HMI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HERE New Zealand Ltd","HNZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HTS Group","HTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inframix Construction Ltd","IMX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inzone","INZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Isaac Construction","ISC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Island Asphalts","ISL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITS","ITS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jacobs New Zealand Ltd","JAC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JCW Consultant","JC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JCL Asphalt subcontractor","JCL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JJ Walters","JJW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Johnstone & Masters Ltd","JM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NZTA (JTOC)","JTO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Juno Services Ltd","JUN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kapiti Coast District Council","KCD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kampung Consulting Ltd.","KCL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kelcroft Engineering","KEL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local Authority","LA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lonrix Ltd","LL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McKays Consultants","MCC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matamata-Piako District Council","MD2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manawatu District Council","MDC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McKay Electrical Ltd","MEL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aecom NZ Ltd","MER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MetService","MET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marlborough NOC JV","MJV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McKay Ltd.","ML"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marlborough Roads","MR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MWH NZ Ltd.","MWH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Napier City Council","NCC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NZ Transport Agency - Highway Programme","NTA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NZ Transport Agency - Funding","NTF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"North Power","NTH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nutech Security","NUT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Odyssey Energy (2009) Ltd.","OE("]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opus International Consultants Ltd (NZ)","OI2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opus International Consultants Ltd.","OIC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oldfields","OLD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Porirua City Council","PCC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pinnacles Civil Group Ltd.","PCG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pope Electrical Ltd","PE2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pope Electrical Limited","PEL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pavement Management Services","PMS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Power Solutions Ltd","PSL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Queenstown-Lakes District Council","QDC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quality Roading and Services","QRS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Read-only access for Tenderers","RAF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rangitikei District Council","RDC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadex","RDX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roading Logistics Ltd","RLL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rationale Ltd","RLT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rotorua District Council","ROT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAMM Software Limited","RSL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Road Signs & Traffic Control Equipment Limited","RTL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"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,"WSP New Zealand Ltd","WNZ"]