{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["StreetLightingLight","Lookups"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":40,"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":"StreetLightingLight","index":0,"n_rows":100,"n_cols":49,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["15f221f1-c15e-4d8e-a679-81fade5c4405_road_id","sh-rs-d","15f221f1-c15e-4d8e-a679-81fade5c4404_start_m","db2bf372-956f-4e0a-a7d2-d4e64a9dd71e_light_make_desc","db2bf372-956f-4e0a-a7d2-d4e64a9dd71e_light_make","b88b341b-a10e-4e9b-89c9-fe4f3ebd045f_light_model_desc","b88b341b-a10e-4e9b-89c9-fe4f3ebd045f_light_model","a35385ee-d4bb-4b81-a07d-9f40a3be91df_supply_point_desc","a35385ee-d4bb-4b81-a07d-9f40a3be91df_supply_point","e8204d7f-23fa-4860-a12e-3c7838eef862_gear_make_desc","e8204d7f-23fa-4860-a12e-3c7838eef862_gear_make","6221eaff-8ce0-4f30-abd2-1e085b4f6b7a_gear_model_desc","6221eaff-8ce0-4f30-abd2-1e085b4f6b7a_gear_model","c516ab5a-233f-42fd-8ea7-c6c42d27d556_lamp_make_desc","c516ab5a-233f-42fd-8ea7-c6c42d27d556_lamp_make","fbf9bc34-c54c-4ea9-a991-b8064c8a2353_lamp_model_desc","fbf9bc34-c54c-4ea9-a991-b8064c8a2353_lamp_model","42c624ea-f272-4b35-be0b-ee61e524a3ab_light_tilt","c1ace6ab-2f16-416d-b39e-7d92e1aac3be_light_install_date","6ab2aa78-e0db-47a4-bfec-c9c8cfced813_light_in_reason_desc","6ab2aa78-e0db-47a4-bfec-c9c8cfced813_light_in_reason","c80411ce-ef3f-4146-9a50-3b0c64b6875e_light_status_desc","c80411ce-ef3f-4146-9a50-3b0c64b6875e_light_status","ac8227b3-bb82-447c-bd84-ea5228e0ad2d_gear_install_date","cf6caebe-f4f9-4d03-a86a-92f067bbba13_gear_in_reason_desc","cf6caebe-f4f9-4d03-a86a-92f067bbba13_gear_in_reason","8e579a12-b778-4f3c-8c0c-5d76139df9f0_gear_status_desc","8e579a12-b778-4f3c-8c0c-5d76139df9f0_gear_status","084509ec-338b-45f4-8ffc-8c35bb6731bb_lamp_install_date","5f56796f-7e36-4a92-8ffa-bd6456397624_lamp_in_reason_desc","5f56796f-7e36-4a92-8ffa-bd6456397624_lamp_in_reason","3527c016-f065-42e0-a0e5-97cb867f9a45_owner_desc","3527c016-f065-42e0-a0e5-97cb867f9a45_owner","d6fd5061-1d0b-49fe-8f27-39a3b3b5149d_risk_likelihood_desc","d6fd5061-1d0b-49fe-8f27-39a3b3b5149d_risk_likelihood","383361dc-1535-4cdf-b43b-99b92a4d0b66_risk_consequence_desc","383361dc-1535-4cdf-b43b-99b92a4d0b66_risk_consequence","3a7e33d6-5434-4edc-bc27-55c53ca6718f_risk_desc","3a7e33d6-5434-4edc-bc27-55c53ca6718f_risk","9941ec9e-1ee3-4db7-8f74-c1419d71a0dc_rul_reset_desc","9941ec9e-1ee3-4db7-8f74-c1419d71a0dc_rul_reset","6ad3cecc-8e66-4dd2-93d7-0591a3122edc_use_default_rc_desc","6ad3cecc-8e66-4dd2-93d7-0591a3122edc_use_default_rc","d7906021-2bc9-4caa-9b52-82924fc689b2_condition_desc","d7906021-2bc9-4caa-9b52-82924fc689b2_condition","98fb9926-c15d-4dc8-88e9-bc2cfea04ea9_condition_date","6970f732-478c-4671-96cc-8e555d23e3a6_collect_name_desc","6970f732-478c-4671-96cc-8e555d23e3a6_collect_name","8319049e-07cc-4c0d-adcd-8ed753d9af37_light_notes"]
["road_id","sh-rs-d","start_m","light_make_desc","light_make","light_model_desc","light_model","supply_point_desc","supply_point","gear_make_desc","gear_make","gear_model_desc","gear_model","lamp_make_desc","lamp_make","lamp_model_desc","lamp_model","light_tilt","light_install_date","light_in_reason_desc","light_in_reason","light_status_desc","light_status","gear_install_date","gear_in_reason_desc","gear_in_reason","gear_status_desc","gear_status","lamp_install_date","lamp_in_reason_desc","lamp_in_reason","owner_desc","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","light_notes"]
["Road Id [location from Pole]","SH-RS-D (e.g. 016-0000-B) [location from Pole] letter must be uppercase and include leading 0","Start (m) [location from Pole]","Light Make Desc","Light Make","Light Model Desc","Light Model","Supply Point Desc","Supply Point","Gear Make Desc","Gear Make","Gear Model Desc","Gear Model","Lamp Make Desc","Lamp Make","Lamp Model Desc","Lamp Model","Tilt","Light Install Date (dd/mm/yyyy) Must include leading 0","Light Install Reason Desc","Light Install Reason","Light Status Desc","Light Status","Gear Install Date (dd/mm/yyyy) Must include leading 0","Gear Install Reason Desc","Gear Install Reason","Gear Status Desc","Gear Status","Lamp Install Date (dd/mm/yyyy) Must include leading 0","Lamp Install Reason Desc","Lamp Install Reason","Asset Owner Desc","Asset Owner","Likelihood Desc","Likelihood","Consequence Desc","Consequence","Risk Desc","Risk","RUL Reset Desc","RUL Reset","Use Default Desc","Use Default","Condition Desc","Condition","Condition Date (dd/mm/yyyy) Must include leading 0","Organisation Desc","Organisation","Notes"]
[{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&B4&\"/\"&C4&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,{"$f":"IF(D4=\"\",\"\",VLOOKUP(D4,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F4=\"\",\"\",VLOOKUP(F4,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H4=\"\",\"\",VLOOKUP(H4,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J4=\"\",\"\",VLOOKUP(J4,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L4=\"\",\"\",VLOOKUP(L4,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N4=\"\",\"\",VLOOKUP(N4,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P4=\"\",\"\",VLOOKUP(P4,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T4=\"\",\"\",VLOOKUP(T4,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V4=\"\",\"\",VLOOKUP(V4,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y4=\"\",\"\",VLOOKUP(Y4,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA4=\"\",\"\",VLOOKUP(AA4,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD4=\"\",\"\",VLOOKUP(AD4,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF4=\"\",\"\",VLOOKUP(AF4,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH4=\"\",\"\",VLOOKUP(AH4,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ4=\"\",\"\",VLOOKUP(AJ4,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL4=\"\",\"\",VLOOKUP(AL4,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN4=\"\",\"\",VLOOKUP(AN4,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP4=\"\",\"\",VLOOKUP(AP4,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR4=\"\",\"\",VLOOKUP(AR4,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU4=\"\",\"\",VLOOKUP(AU4,Organisation[],2,FALSE))","v":""}]
[{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&B5&\"/\"&C5&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,{"$f":"IF(D5=\"\",\"\",VLOOKUP(D5,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F5=\"\",\"\",VLOOKUP(F5,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H5=\"\",\"\",VLOOKUP(H5,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J5=\"\",\"\",VLOOKUP(J5,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L5=\"\",\"\",VLOOKUP(L5,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N5=\"\",\"\",VLOOKUP(N5,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P5=\"\",\"\",VLOOKUP(P5,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T5=\"\",\"\",VLOOKUP(T5,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V5=\"\",\"\",VLOOKUP(V5,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y5=\"\",\"\",VLOOKUP(Y5,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA5=\"\",\"\",VLOOKUP(AA5,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD5=\"\",\"\",VLOOKUP(AD5,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF5=\"\",\"\",VLOOKUP(AF5,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH5=\"\",\"\",VLOOKUP(AH5,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ5=\"\",\"\",VLOOKUP(AJ5,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL5=\"\",\"\",VLOOKUP(AL5,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN5=\"\",\"\",VLOOKUP(AN5,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP5=\"\",\"\",VLOOKUP(AP5,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR5=\"\",\"\",VLOOKUP(AR5,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU5=\"\",\"\",VLOOKUP(AU5,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D6=\"\",\"\",VLOOKUP(D6,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F6=\"\",\"\",VLOOKUP(F6,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H6=\"\",\"\",VLOOKUP(H6,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J6=\"\",\"\",VLOOKUP(J6,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L6=\"\",\"\",VLOOKUP(L6,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N6=\"\",\"\",VLOOKUP(N6,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P6=\"\",\"\",VLOOKUP(P6,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T6=\"\",\"\",VLOOKUP(T6,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V6=\"\",\"\",VLOOKUP(V6,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y6=\"\",\"\",VLOOKUP(Y6,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA6=\"\",\"\",VLOOKUP(AA6,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD6=\"\",\"\",VLOOKUP(AD6,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF6=\"\",\"\",VLOOKUP(AF6,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH6=\"\",\"\",VLOOKUP(AH6,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ6=\"\",\"\",VLOOKUP(AJ6,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL6=\"\",\"\",VLOOKUP(AL6,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN6=\"\",\"\",VLOOKUP(AN6,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP6=\"\",\"\",VLOOKUP(AP6,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR6=\"\",\"\",VLOOKUP(AR6,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU6=\"\",\"\",VLOOKUP(AU6,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D7=\"\",\"\",VLOOKUP(D7,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F7=\"\",\"\",VLOOKUP(F7,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H7=\"\",\"\",VLOOKUP(H7,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J7=\"\",\"\",VLOOKUP(J7,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L7=\"\",\"\",VLOOKUP(L7,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N7=\"\",\"\",VLOOKUP(N7,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P7=\"\",\"\",VLOOKUP(P7,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T7=\"\",\"\",VLOOKUP(T7,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V7=\"\",\"\",VLOOKUP(V7,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y7=\"\",\"\",VLOOKUP(Y7,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA7=\"\",\"\",VLOOKUP(AA7,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD7=\"\",\"\",VLOOKUP(AD7,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF7=\"\",\"\",VLOOKUP(AF7,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH7=\"\",\"\",VLOOKUP(AH7,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ7=\"\",\"\",VLOOKUP(AJ7,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL7=\"\",\"\",VLOOKUP(AL7,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN7=\"\",\"\",VLOOKUP(AN7,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP7=\"\",\"\",VLOOKUP(AP7,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR7=\"\",\"\",VLOOKUP(AR7,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU7=\"\",\"\",VLOOKUP(AU7,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D8=\"\",\"\",VLOOKUP(D8,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F8=\"\",\"\",VLOOKUP(F8,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H8=\"\",\"\",VLOOKUP(H8,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J8=\"\",\"\",VLOOKUP(J8,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L8=\"\",\"\",VLOOKUP(L8,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N8=\"\",\"\",VLOOKUP(N8,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P8=\"\",\"\",VLOOKUP(P8,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T8=\"\",\"\",VLOOKUP(T8,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V8=\"\",\"\",VLOOKUP(V8,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y8=\"\",\"\",VLOOKUP(Y8,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA8=\"\",\"\",VLOOKUP(AA8,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD8=\"\",\"\",VLOOKUP(AD8,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF8=\"\",\"\",VLOOKUP(AF8,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH8=\"\",\"\",VLOOKUP(AH8,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ8=\"\",\"\",VLOOKUP(AJ8,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL8=\"\",\"\",VLOOKUP(AL8,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN8=\"\",\"\",VLOOKUP(AN8,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP8=\"\",\"\",VLOOKUP(AP8,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR8=\"\",\"\",VLOOKUP(AR8,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU8=\"\",\"\",VLOOKUP(AU8,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D9=\"\",\"\",VLOOKUP(D9,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F9=\"\",\"\",VLOOKUP(F9,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H9=\"\",\"\",VLOOKUP(H9,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J9=\"\",\"\",VLOOKUP(J9,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L9=\"\",\"\",VLOOKUP(L9,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N9=\"\",\"\",VLOOKUP(N9,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P9=\"\",\"\",VLOOKUP(P9,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T9=\"\",\"\",VLOOKUP(T9,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V9=\"\",\"\",VLOOKUP(V9,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y9=\"\",\"\",VLOOKUP(Y9,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA9=\"\",\"\",VLOOKUP(AA9,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD9=\"\",\"\",VLOOKUP(AD9,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF9=\"\",\"\",VLOOKUP(AF9,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH9=\"\",\"\",VLOOKUP(AH9,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ9=\"\",\"\",VLOOKUP(AJ9,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL9=\"\",\"\",VLOOKUP(AL9,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN9=\"\",\"\",VLOOKUP(AN9,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP9=\"\",\"\",VLOOKUP(AP9,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR9=\"\",\"\",VLOOKUP(AR9,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU9=\"\",\"\",VLOOKUP(AU9,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D10=\"\",\"\",VLOOKUP(D10,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F10=\"\",\"\",VLOOKUP(F10,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H10=\"\",\"\",VLOOKUP(H10,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J10=\"\",\"\",VLOOKUP(J10,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L10=\"\",\"\",VLOOKUP(L10,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N10=\"\",\"\",VLOOKUP(N10,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P10=\"\",\"\",VLOOKUP(P10,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T10=\"\",\"\",VLOOKUP(T10,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V10=\"\",\"\",VLOOKUP(V10,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y10=\"\",\"\",VLOOKUP(Y10,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA10=\"\",\"\",VLOOKUP(AA10,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD10=\"\",\"\",VLOOKUP(AD10,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF10=\"\",\"\",VLOOKUP(AF10,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH10=\"\",\"\",VLOOKUP(AH10,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ10=\"\",\"\",VLOOKUP(AJ10,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL10=\"\",\"\",VLOOKUP(AL10,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN10=\"\",\"\",VLOOKUP(AN10,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP10=\"\",\"\",VLOOKUP(AP10,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR10=\"\",\"\",VLOOKUP(AR10,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU10=\"\",\"\",VLOOKUP(AU10,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D11=\"\",\"\",VLOOKUP(D11,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F11=\"\",\"\",VLOOKUP(F11,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H11=\"\",\"\",VLOOKUP(H11,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J11=\"\",\"\",VLOOKUP(J11,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L11=\"\",\"\",VLOOKUP(L11,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N11=\"\",\"\",VLOOKUP(N11,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P11=\"\",\"\",VLOOKUP(P11,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T11=\"\",\"\",VLOOKUP(T11,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V11=\"\",\"\",VLOOKUP(V11,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y11=\"\",\"\",VLOOKUP(Y11,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA11=\"\",\"\",VLOOKUP(AA11,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD11=\"\",\"\",VLOOKUP(AD11,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF11=\"\",\"\",VLOOKUP(AF11,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH11=\"\",\"\",VLOOKUP(AH11,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ11=\"\",\"\",VLOOKUP(AJ11,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL11=\"\",\"\",VLOOKUP(AL11,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN11=\"\",\"\",VLOOKUP(AN11,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP11=\"\",\"\",VLOOKUP(AP11,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR11=\"\",\"\",VLOOKUP(AR11,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU11=\"\",\"\",VLOOKUP(AU11,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D12=\"\",\"\",VLOOKUP(D12,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F12=\"\",\"\",VLOOKUP(F12,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H12=\"\",\"\",VLOOKUP(H12,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J12=\"\",\"\",VLOOKUP(J12,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L12=\"\",\"\",VLOOKUP(L12,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N12=\"\",\"\",VLOOKUP(N12,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P12=\"\",\"\",VLOOKUP(P12,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T12=\"\",\"\",VLOOKUP(T12,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V12=\"\",\"\",VLOOKUP(V12,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y12=\"\",\"\",VLOOKUP(Y12,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA12=\"\",\"\",VLOOKUP(AA12,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD12=\"\",\"\",VLOOKUP(AD12,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF12=\"\",\"\",VLOOKUP(AF12,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH12=\"\",\"\",VLOOKUP(AH12,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ12=\"\",\"\",VLOOKUP(AJ12,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL12=\"\",\"\",VLOOKUP(AL12,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN12=\"\",\"\",VLOOKUP(AN12,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP12=\"\",\"\",VLOOKUP(AP12,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR12=\"\",\"\",VLOOKUP(AR12,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU12=\"\",\"\",VLOOKUP(AU12,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D13=\"\",\"\",VLOOKUP(D13,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F13=\"\",\"\",VLOOKUP(F13,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H13=\"\",\"\",VLOOKUP(H13,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J13=\"\",\"\",VLOOKUP(J13,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L13=\"\",\"\",VLOOKUP(L13,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N13=\"\",\"\",VLOOKUP(N13,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P13=\"\",\"\",VLOOKUP(P13,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T13=\"\",\"\",VLOOKUP(T13,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V13=\"\",\"\",VLOOKUP(V13,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y13=\"\",\"\",VLOOKUP(Y13,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA13=\"\",\"\",VLOOKUP(AA13,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD13=\"\",\"\",VLOOKUP(AD13,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF13=\"\",\"\",VLOOKUP(AF13,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH13=\"\",\"\",VLOOKUP(AH13,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ13=\"\",\"\",VLOOKUP(AJ13,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL13=\"\",\"\",VLOOKUP(AL13,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN13=\"\",\"\",VLOOKUP(AN13,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP13=\"\",\"\",VLOOKUP(AP13,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR13=\"\",\"\",VLOOKUP(AR13,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU13=\"\",\"\",VLOOKUP(AU13,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D14=\"\",\"\",VLOOKUP(D14,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F14=\"\",\"\",VLOOKUP(F14,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H14=\"\",\"\",VLOOKUP(H14,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J14=\"\",\"\",VLOOKUP(J14,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L14=\"\",\"\",VLOOKUP(L14,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N14=\"\",\"\",VLOOKUP(N14,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P14=\"\",\"\",VLOOKUP(P14,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T14=\"\",\"\",VLOOKUP(T14,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V14=\"\",\"\",VLOOKUP(V14,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y14=\"\",\"\",VLOOKUP(Y14,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA14=\"\",\"\",VLOOKUP(AA14,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD14=\"\",\"\",VLOOKUP(AD14,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF14=\"\",\"\",VLOOKUP(AF14,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH14=\"\",\"\",VLOOKUP(AH14,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ14=\"\",\"\",VLOOKUP(AJ14,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL14=\"\",\"\",VLOOKUP(AL14,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN14=\"\",\"\",VLOOKUP(AN14,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP14=\"\",\"\",VLOOKUP(AP14,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR14=\"\",\"\",VLOOKUP(AR14,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU14=\"\",\"\",VLOOKUP(AU14,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F15=\"\",\"\",VLOOKUP(F15,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H15=\"\",\"\",VLOOKUP(H15,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J15=\"\",\"\",VLOOKUP(J15,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L15=\"\",\"\",VLOOKUP(L15,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N15=\"\",\"\",VLOOKUP(N15,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P15=\"\",\"\",VLOOKUP(P15,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T15=\"\",\"\",VLOOKUP(T15,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V15=\"\",\"\",VLOOKUP(V15,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y15=\"\",\"\",VLOOKUP(Y15,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA15=\"\",\"\",VLOOKUP(AA15,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD15=\"\",\"\",VLOOKUP(AD15,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF15=\"\",\"\",VLOOKUP(AF15,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH15=\"\",\"\",VLOOKUP(AH15,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ15=\"\",\"\",VLOOKUP(AJ15,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL15=\"\",\"\",VLOOKUP(AL15,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN15=\"\",\"\",VLOOKUP(AN15,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP15=\"\",\"\",VLOOKUP(AP15,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR15=\"\",\"\",VLOOKUP(AR15,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU15=\"\",\"\",VLOOKUP(AU15,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D16=\"\",\"\",VLOOKUP(D16,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F16=\"\",\"\",VLOOKUP(F16,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H16=\"\",\"\",VLOOKUP(H16,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J16=\"\",\"\",VLOOKUP(J16,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L16=\"\",\"\",VLOOKUP(L16,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N16=\"\",\"\",VLOOKUP(N16,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P16=\"\",\"\",VLOOKUP(P16,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T16=\"\",\"\",VLOOKUP(T16,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V16=\"\",\"\",VLOOKUP(V16,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y16=\"\",\"\",VLOOKUP(Y16,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA16=\"\",\"\",VLOOKUP(AA16,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD16=\"\",\"\",VLOOKUP(AD16,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF16=\"\",\"\",VLOOKUP(AF16,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH16=\"\",\"\",VLOOKUP(AH16,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ16=\"\",\"\",VLOOKUP(AJ16,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL16=\"\",\"\",VLOOKUP(AL16,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN16=\"\",\"\",VLOOKUP(AN16,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP16=\"\",\"\",VLOOKUP(AP16,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR16=\"\",\"\",VLOOKUP(AR16,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU16=\"\",\"\",VLOOKUP(AU16,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D17=\"\",\"\",VLOOKUP(D17,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F17=\"\",\"\",VLOOKUP(F17,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H17=\"\",\"\",VLOOKUP(H17,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J17=\"\",\"\",VLOOKUP(J17,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L17=\"\",\"\",VLOOKUP(L17,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N17=\"\",\"\",VLOOKUP(N17,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P17=\"\",\"\",VLOOKUP(P17,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T17=\"\",\"\",VLOOKUP(T17,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V17=\"\",\"\",VLOOKUP(V17,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y17=\"\",\"\",VLOOKUP(Y17,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA17=\"\",\"\",VLOOKUP(AA17,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD17=\"\",\"\",VLOOKUP(AD17,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF17=\"\",\"\",VLOOKUP(AF17,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH17=\"\",\"\",VLOOKUP(AH17,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ17=\"\",\"\",VLOOKUP(AJ17,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL17=\"\",\"\",VLOOKUP(AL17,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN17=\"\",\"\",VLOOKUP(AN17,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP17=\"\",\"\",VLOOKUP(AP17,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR17=\"\",\"\",VLOOKUP(AR17,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU17=\"\",\"\",VLOOKUP(AU17,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D18=\"\",\"\",VLOOKUP(D18,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F18=\"\",\"\",VLOOKUP(F18,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H18=\"\",\"\",VLOOKUP(H18,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J18=\"\",\"\",VLOOKUP(J18,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L18=\"\",\"\",VLOOKUP(L18,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N18=\"\",\"\",VLOOKUP(N18,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P18=\"\",\"\",VLOOKUP(P18,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T18=\"\",\"\",VLOOKUP(T18,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V18=\"\",\"\",VLOOKUP(V18,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y18=\"\",\"\",VLOOKUP(Y18,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA18=\"\",\"\",VLOOKUP(AA18,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD18=\"\",\"\",VLOOKUP(AD18,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF18=\"\",\"\",VLOOKUP(AF18,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH18=\"\",\"\",VLOOKUP(AH18,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ18=\"\",\"\",VLOOKUP(AJ18,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL18=\"\",\"\",VLOOKUP(AL18,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN18=\"\",\"\",VLOOKUP(AN18,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP18=\"\",\"\",VLOOKUP(AP18,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR18=\"\",\"\",VLOOKUP(AR18,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU18=\"\",\"\",VLOOKUP(AU18,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D19=\"\",\"\",VLOOKUP(D19,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F19=\"\",\"\",VLOOKUP(F19,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H19=\"\",\"\",VLOOKUP(H19,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J19=\"\",\"\",VLOOKUP(J19,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L19=\"\",\"\",VLOOKUP(L19,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N19=\"\",\"\",VLOOKUP(N19,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P19=\"\",\"\",VLOOKUP(P19,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T19=\"\",\"\",VLOOKUP(T19,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V19=\"\",\"\",VLOOKUP(V19,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y19=\"\",\"\",VLOOKUP(Y19,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA19=\"\",\"\",VLOOKUP(AA19,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD19=\"\",\"\",VLOOKUP(AD19,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF19=\"\",\"\",VLOOKUP(AF19,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH19=\"\",\"\",VLOOKUP(AH19,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ19=\"\",\"\",VLOOKUP(AJ19,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL19=\"\",\"\",VLOOKUP(AL19,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN19=\"\",\"\",VLOOKUP(AN19,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP19=\"\",\"\",VLOOKUP(AP19,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR19=\"\",\"\",VLOOKUP(AR19,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU19=\"\",\"\",VLOOKUP(AU19,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D20=\"\",\"\",VLOOKUP(D20,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F20=\"\",\"\",VLOOKUP(F20,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H20=\"\",\"\",VLOOKUP(H20,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J20=\"\",\"\",VLOOKUP(J20,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L20=\"\",\"\",VLOOKUP(L20,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N20=\"\",\"\",VLOOKUP(N20,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P20=\"\",\"\",VLOOKUP(P20,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T20=\"\",\"\",VLOOKUP(T20,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V20=\"\",\"\",VLOOKUP(V20,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y20=\"\",\"\",VLOOKUP(Y20,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA20=\"\",\"\",VLOOKUP(AA20,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD20=\"\",\"\",VLOOKUP(AD20,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF20=\"\",\"\",VLOOKUP(AF20,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH20=\"\",\"\",VLOOKUP(AH20,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ20=\"\",\"\",VLOOKUP(AJ20,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL20=\"\",\"\",VLOOKUP(AL20,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN20=\"\",\"\",VLOOKUP(AN20,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP20=\"\",\"\",VLOOKUP(AP20,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR20=\"\",\"\",VLOOKUP(AR20,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU20=\"\",\"\",VLOOKUP(AU20,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D21=\"\",\"\",VLOOKUP(D21,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F21=\"\",\"\",VLOOKUP(F21,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H21=\"\",\"\",VLOOKUP(H21,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J21=\"\",\"\",VLOOKUP(J21,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L21=\"\",\"\",VLOOKUP(L21,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N21=\"\",\"\",VLOOKUP(N21,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P21=\"\",\"\",VLOOKUP(P21,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T21=\"\",\"\",VLOOKUP(T21,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V21=\"\",\"\",VLOOKUP(V21,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y21=\"\",\"\",VLOOKUP(Y21,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA21=\"\",\"\",VLOOKUP(AA21,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD21=\"\",\"\",VLOOKUP(AD21,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF21=\"\",\"\",VLOOKUP(AF21,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH21=\"\",\"\",VLOOKUP(AH21,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ21=\"\",\"\",VLOOKUP(AJ21,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL21=\"\",\"\",VLOOKUP(AL21,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN21=\"\",\"\",VLOOKUP(AN21,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP21=\"\",\"\",VLOOKUP(AP21,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR21=\"\",\"\",VLOOKUP(AR21,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU21=\"\",\"\",VLOOKUP(AU21,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D22=\"\",\"\",VLOOKUP(D22,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F22=\"\",\"\",VLOOKUP(F22,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H22=\"\",\"\",VLOOKUP(H22,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J22=\"\",\"\",VLOOKUP(J22,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L22=\"\",\"\",VLOOKUP(L22,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N22=\"\",\"\",VLOOKUP(N22,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P22=\"\",\"\",VLOOKUP(P22,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T22=\"\",\"\",VLOOKUP(T22,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V22=\"\",\"\",VLOOKUP(V22,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y22=\"\",\"\",VLOOKUP(Y22,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA22=\"\",\"\",VLOOKUP(AA22,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD22=\"\",\"\",VLOOKUP(AD22,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF22=\"\",\"\",VLOOKUP(AF22,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH22=\"\",\"\",VLOOKUP(AH22,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ22=\"\",\"\",VLOOKUP(AJ22,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL22=\"\",\"\",VLOOKUP(AL22,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN22=\"\",\"\",VLOOKUP(AN22,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP22=\"\",\"\",VLOOKUP(AP22,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR22=\"\",\"\",VLOOKUP(AR22,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU22=\"\",\"\",VLOOKUP(AU22,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D23=\"\",\"\",VLOOKUP(D23,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F23=\"\",\"\",VLOOKUP(F23,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H23=\"\",\"\",VLOOKUP(H23,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J23=\"\",\"\",VLOOKUP(J23,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L23=\"\",\"\",VLOOKUP(L23,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N23=\"\",\"\",VLOOKUP(N23,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P23=\"\",\"\",VLOOKUP(P23,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T23=\"\",\"\",VLOOKUP(T23,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V23=\"\",\"\",VLOOKUP(V23,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y23=\"\",\"\",VLOOKUP(Y23,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA23=\"\",\"\",VLOOKUP(AA23,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD23=\"\",\"\",VLOOKUP(AD23,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF23=\"\",\"\",VLOOKUP(AF23,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH23=\"\",\"\",VLOOKUP(AH23,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ23=\"\",\"\",VLOOKUP(AJ23,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL23=\"\",\"\",VLOOKUP(AL23,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN23=\"\",\"\",VLOOKUP(AN23,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP23=\"\",\"\",VLOOKUP(AP23,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR23=\"\",\"\",VLOOKUP(AR23,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU23=\"\",\"\",VLOOKUP(AU23,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D24=\"\",\"\",VLOOKUP(D24,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F24=\"\",\"\",VLOOKUP(F24,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H24=\"\",\"\",VLOOKUP(H24,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J24=\"\",\"\",VLOOKUP(J24,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L24=\"\",\"\",VLOOKUP(L24,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N24=\"\",\"\",VLOOKUP(N24,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P24=\"\",\"\",VLOOKUP(P24,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T24=\"\",\"\",VLOOKUP(T24,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V24=\"\",\"\",VLOOKUP(V24,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y24=\"\",\"\",VLOOKUP(Y24,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA24=\"\",\"\",VLOOKUP(AA24,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD24=\"\",\"\",VLOOKUP(AD24,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF24=\"\",\"\",VLOOKUP(AF24,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH24=\"\",\"\",VLOOKUP(AH24,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ24=\"\",\"\",VLOOKUP(AJ24,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL24=\"\",\"\",VLOOKUP(AL24,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN24=\"\",\"\",VLOOKUP(AN24,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP24=\"\",\"\",VLOOKUP(AP24,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR24=\"\",\"\",VLOOKUP(AR24,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU24=\"\",\"\",VLOOKUP(AU24,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D25=\"\",\"\",VLOOKUP(D25,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F25=\"\",\"\",VLOOKUP(F25,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H25=\"\",\"\",VLOOKUP(H25,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J25=\"\",\"\",VLOOKUP(J25,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L25=\"\",\"\",VLOOKUP(L25,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N25=\"\",\"\",VLOOKUP(N25,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P25=\"\",\"\",VLOOKUP(P25,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T25=\"\",\"\",VLOOKUP(T25,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V25=\"\",\"\",VLOOKUP(V25,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y25=\"\",\"\",VLOOKUP(Y25,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA25=\"\",\"\",VLOOKUP(AA25,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD25=\"\",\"\",VLOOKUP(AD25,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF25=\"\",\"\",VLOOKUP(AF25,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH25=\"\",\"\",VLOOKUP(AH25,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ25=\"\",\"\",VLOOKUP(AJ25,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL25=\"\",\"\",VLOOKUP(AL25,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN25=\"\",\"\",VLOOKUP(AN25,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP25=\"\",\"\",VLOOKUP(AP25,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR25=\"\",\"\",VLOOKUP(AR25,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU25=\"\",\"\",VLOOKUP(AU25,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D26=\"\",\"\",VLOOKUP(D26,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F26=\"\",\"\",VLOOKUP(F26,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H26=\"\",\"\",VLOOKUP(H26,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J26=\"\",\"\",VLOOKUP(J26,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L26=\"\",\"\",VLOOKUP(L26,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N26=\"\",\"\",VLOOKUP(N26,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P26=\"\",\"\",VLOOKUP(P26,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T26=\"\",\"\",VLOOKUP(T26,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V26=\"\",\"\",VLOOKUP(V26,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y26=\"\",\"\",VLOOKUP(Y26,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA26=\"\",\"\",VLOOKUP(AA26,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD26=\"\",\"\",VLOOKUP(AD26,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF26=\"\",\"\",VLOOKUP(AF26,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH26=\"\",\"\",VLOOKUP(AH26,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ26=\"\",\"\",VLOOKUP(AJ26,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL26=\"\",\"\",VLOOKUP(AL26,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN26=\"\",\"\",VLOOKUP(AN26,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP26=\"\",\"\",VLOOKUP(AP26,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR26=\"\",\"\",VLOOKUP(AR26,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU26=\"\",\"\",VLOOKUP(AU26,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D27=\"\",\"\",VLOOKUP(D27,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F27=\"\",\"\",VLOOKUP(F27,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H27=\"\",\"\",VLOOKUP(H27,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J27=\"\",\"\",VLOOKUP(J27,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L27=\"\",\"\",VLOOKUP(L27,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N27=\"\",\"\",VLOOKUP(N27,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P27=\"\",\"\",VLOOKUP(P27,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T27=\"\",\"\",VLOOKUP(T27,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V27=\"\",\"\",VLOOKUP(V27,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y27=\"\",\"\",VLOOKUP(Y27,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA27=\"\",\"\",VLOOKUP(AA27,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD27=\"\",\"\",VLOOKUP(AD27,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF27=\"\",\"\",VLOOKUP(AF27,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH27=\"\",\"\",VLOOKUP(AH27,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ27=\"\",\"\",VLOOKUP(AJ27,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL27=\"\",\"\",VLOOKUP(AL27,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN27=\"\",\"\",VLOOKUP(AN27,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP27=\"\",\"\",VLOOKUP(AP27,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR27=\"\",\"\",VLOOKUP(AR27,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU27=\"\",\"\",VLOOKUP(AU27,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D28=\"\",\"\",VLOOKUP(D28,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F28=\"\",\"\",VLOOKUP(F28,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H28=\"\",\"\",VLOOKUP(H28,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J28=\"\",\"\",VLOOKUP(J28,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L28=\"\",\"\",VLOOKUP(L28,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N28=\"\",\"\",VLOOKUP(N28,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P28=\"\",\"\",VLOOKUP(P28,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T28=\"\",\"\",VLOOKUP(T28,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V28=\"\",\"\",VLOOKUP(V28,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y28=\"\",\"\",VLOOKUP(Y28,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA28=\"\",\"\",VLOOKUP(AA28,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD28=\"\",\"\",VLOOKUP(AD28,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF28=\"\",\"\",VLOOKUP(AF28,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH28=\"\",\"\",VLOOKUP(AH28,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ28=\"\",\"\",VLOOKUP(AJ28,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL28=\"\",\"\",VLOOKUP(AL28,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN28=\"\",\"\",VLOOKUP(AN28,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP28=\"\",\"\",VLOOKUP(AP28,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR28=\"\",\"\",VLOOKUP(AR28,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU28=\"\",\"\",VLOOKUP(AU28,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D29=\"\",\"\",VLOOKUP(D29,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F29=\"\",\"\",VLOOKUP(F29,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H29=\"\",\"\",VLOOKUP(H29,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J29=\"\",\"\",VLOOKUP(J29,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L29=\"\",\"\",VLOOKUP(L29,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N29=\"\",\"\",VLOOKUP(N29,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P29=\"\",\"\",VLOOKUP(P29,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T29=\"\",\"\",VLOOKUP(T29,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V29=\"\",\"\",VLOOKUP(V29,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y29=\"\",\"\",VLOOKUP(Y29,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA29=\"\",\"\",VLOOKUP(AA29,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD29=\"\",\"\",VLOOKUP(AD29,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF29=\"\",\"\",VLOOKUP(AF29,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH29=\"\",\"\",VLOOKUP(AH29,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ29=\"\",\"\",VLOOKUP(AJ29,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL29=\"\",\"\",VLOOKUP(AL29,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN29=\"\",\"\",VLOOKUP(AN29,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP29=\"\",\"\",VLOOKUP(AP29,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR29=\"\",\"\",VLOOKUP(AR29,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU29=\"\",\"\",VLOOKUP(AU29,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F30=\"\",\"\",VLOOKUP(F30,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H30=\"\",\"\",VLOOKUP(H30,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J30=\"\",\"\",VLOOKUP(J30,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L30=\"\",\"\",VLOOKUP(L30,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N30=\"\",\"\",VLOOKUP(N30,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P30=\"\",\"\",VLOOKUP(P30,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T30=\"\",\"\",VLOOKUP(T30,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V30=\"\",\"\",VLOOKUP(V30,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y30=\"\",\"\",VLOOKUP(Y30,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA30=\"\",\"\",VLOOKUP(AA30,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD30=\"\",\"\",VLOOKUP(AD30,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF30=\"\",\"\",VLOOKUP(AF30,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH30=\"\",\"\",VLOOKUP(AH30,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ30=\"\",\"\",VLOOKUP(AJ30,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL30=\"\",\"\",VLOOKUP(AL30,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN30=\"\",\"\",VLOOKUP(AN30,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP30=\"\",\"\",VLOOKUP(AP30,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR30=\"\",\"\",VLOOKUP(AR30,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU30=\"\",\"\",VLOOKUP(AU30,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D31=\"\",\"\",VLOOKUP(D31,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F31=\"\",\"\",VLOOKUP(F31,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H31=\"\",\"\",VLOOKUP(H31,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J31=\"\",\"\",VLOOKUP(J31,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L31=\"\",\"\",VLOOKUP(L31,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N31=\"\",\"\",VLOOKUP(N31,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P31=\"\",\"\",VLOOKUP(P31,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T31=\"\",\"\",VLOOKUP(T31,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V31=\"\",\"\",VLOOKUP(V31,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y31=\"\",\"\",VLOOKUP(Y31,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA31=\"\",\"\",VLOOKUP(AA31,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD31=\"\",\"\",VLOOKUP(AD31,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF31=\"\",\"\",VLOOKUP(AF31,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH31=\"\",\"\",VLOOKUP(AH31,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ31=\"\",\"\",VLOOKUP(AJ31,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL31=\"\",\"\",VLOOKUP(AL31,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN31=\"\",\"\",VLOOKUP(AN31,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP31=\"\",\"\",VLOOKUP(AP31,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR31=\"\",\"\",VLOOKUP(AR31,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU31=\"\",\"\",VLOOKUP(AU31,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D32=\"\",\"\",VLOOKUP(D32,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F32=\"\",\"\",VLOOKUP(F32,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H32=\"\",\"\",VLOOKUP(H32,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J32=\"\",\"\",VLOOKUP(J32,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L32=\"\",\"\",VLOOKUP(L32,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N32=\"\",\"\",VLOOKUP(N32,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P32=\"\",\"\",VLOOKUP(P32,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T32=\"\",\"\",VLOOKUP(T32,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V32=\"\",\"\",VLOOKUP(V32,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y32=\"\",\"\",VLOOKUP(Y32,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA32=\"\",\"\",VLOOKUP(AA32,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD32=\"\",\"\",VLOOKUP(AD32,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF32=\"\",\"\",VLOOKUP(AF32,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH32=\"\",\"\",VLOOKUP(AH32,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ32=\"\",\"\",VLOOKUP(AJ32,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL32=\"\",\"\",VLOOKUP(AL32,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN32=\"\",\"\",VLOOKUP(AN32,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP32=\"\",\"\",VLOOKUP(AP32,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR32=\"\",\"\",VLOOKUP(AR32,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU32=\"\",\"\",VLOOKUP(AU32,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D33=\"\",\"\",VLOOKUP(D33,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F33=\"\",\"\",VLOOKUP(F33,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H33=\"\",\"\",VLOOKUP(H33,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J33=\"\",\"\",VLOOKUP(J33,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L33=\"\",\"\",VLOOKUP(L33,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N33=\"\",\"\",VLOOKUP(N33,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P33=\"\",\"\",VLOOKUP(P33,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T33=\"\",\"\",VLOOKUP(T33,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V33=\"\",\"\",VLOOKUP(V33,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y33=\"\",\"\",VLOOKUP(Y33,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA33=\"\",\"\",VLOOKUP(AA33,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD33=\"\",\"\",VLOOKUP(AD33,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF33=\"\",\"\",VLOOKUP(AF33,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH33=\"\",\"\",VLOOKUP(AH33,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ33=\"\",\"\",VLOOKUP(AJ33,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL33=\"\",\"\",VLOOKUP(AL33,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN33=\"\",\"\",VLOOKUP(AN33,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP33=\"\",\"\",VLOOKUP(AP33,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR33=\"\",\"\",VLOOKUP(AR33,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU33=\"\",\"\",VLOOKUP(AU33,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D34=\"\",\"\",VLOOKUP(D34,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F34=\"\",\"\",VLOOKUP(F34,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H34=\"\",\"\",VLOOKUP(H34,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J34=\"\",\"\",VLOOKUP(J34,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L34=\"\",\"\",VLOOKUP(L34,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N34=\"\",\"\",VLOOKUP(N34,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P34=\"\",\"\",VLOOKUP(P34,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T34=\"\",\"\",VLOOKUP(T34,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V34=\"\",\"\",VLOOKUP(V34,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y34=\"\",\"\",VLOOKUP(Y34,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA34=\"\",\"\",VLOOKUP(AA34,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD34=\"\",\"\",VLOOKUP(AD34,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF34=\"\",\"\",VLOOKUP(AF34,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH34=\"\",\"\",VLOOKUP(AH34,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ34=\"\",\"\",VLOOKUP(AJ34,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL34=\"\",\"\",VLOOKUP(AL34,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN34=\"\",\"\",VLOOKUP(AN34,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP34=\"\",\"\",VLOOKUP(AP34,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR34=\"\",\"\",VLOOKUP(AR34,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU34=\"\",\"\",VLOOKUP(AU34,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D35=\"\",\"\",VLOOKUP(D35,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F35=\"\",\"\",VLOOKUP(F35,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H35=\"\",\"\",VLOOKUP(H35,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J35=\"\",\"\",VLOOKUP(J35,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L35=\"\",\"\",VLOOKUP(L35,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N35=\"\",\"\",VLOOKUP(N35,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P35=\"\",\"\",VLOOKUP(P35,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T35=\"\",\"\",VLOOKUP(T35,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V35=\"\",\"\",VLOOKUP(V35,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y35=\"\",\"\",VLOOKUP(Y35,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA35=\"\",\"\",VLOOKUP(AA35,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD35=\"\",\"\",VLOOKUP(AD35,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF35=\"\",\"\",VLOOKUP(AF35,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH35=\"\",\"\",VLOOKUP(AH35,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ35=\"\",\"\",VLOOKUP(AJ35,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL35=\"\",\"\",VLOOKUP(AL35,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN35=\"\",\"\",VLOOKUP(AN35,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP35=\"\",\"\",VLOOKUP(AP35,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR35=\"\",\"\",VLOOKUP(AR35,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU35=\"\",\"\",VLOOKUP(AU35,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D36=\"\",\"\",VLOOKUP(D36,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F36=\"\",\"\",VLOOKUP(F36,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H36=\"\",\"\",VLOOKUP(H36,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J36=\"\",\"\",VLOOKUP(J36,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L36=\"\",\"\",VLOOKUP(L36,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N36=\"\",\"\",VLOOKUP(N36,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P36=\"\",\"\",VLOOKUP(P36,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T36=\"\",\"\",VLOOKUP(T36,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V36=\"\",\"\",VLOOKUP(V36,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y36=\"\",\"\",VLOOKUP(Y36,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA36=\"\",\"\",VLOOKUP(AA36,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD36=\"\",\"\",VLOOKUP(AD36,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF36=\"\",\"\",VLOOKUP(AF36,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH36=\"\",\"\",VLOOKUP(AH36,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ36=\"\",\"\",VLOOKUP(AJ36,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL36=\"\",\"\",VLOOKUP(AL36,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN36=\"\",\"\",VLOOKUP(AN36,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP36=\"\",\"\",VLOOKUP(AP36,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR36=\"\",\"\",VLOOKUP(AR36,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU36=\"\",\"\",VLOOKUP(AU36,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D37=\"\",\"\",VLOOKUP(D37,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F37=\"\",\"\",VLOOKUP(F37,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H37=\"\",\"\",VLOOKUP(H37,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J37=\"\",\"\",VLOOKUP(J37,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L37=\"\",\"\",VLOOKUP(L37,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N37=\"\",\"\",VLOOKUP(N37,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P37=\"\",\"\",VLOOKUP(P37,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T37=\"\",\"\",VLOOKUP(T37,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V37=\"\",\"\",VLOOKUP(V37,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y37=\"\",\"\",VLOOKUP(Y37,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA37=\"\",\"\",VLOOKUP(AA37,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD37=\"\",\"\",VLOOKUP(AD37,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF37=\"\",\"\",VLOOKUP(AF37,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH37=\"\",\"\",VLOOKUP(AH37,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ37=\"\",\"\",VLOOKUP(AJ37,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL37=\"\",\"\",VLOOKUP(AL37,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN37=\"\",\"\",VLOOKUP(AN37,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP37=\"\",\"\",VLOOKUP(AP37,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR37=\"\",\"\",VLOOKUP(AR37,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU37=\"\",\"\",VLOOKUP(AU37,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D38=\"\",\"\",VLOOKUP(D38,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F38=\"\",\"\",VLOOKUP(F38,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H38=\"\",\"\",VLOOKUP(H38,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J38=\"\",\"\",VLOOKUP(J38,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L38=\"\",\"\",VLOOKUP(L38,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N38=\"\",\"\",VLOOKUP(N38,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P38=\"\",\"\",VLOOKUP(P38,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T38=\"\",\"\",VLOOKUP(T38,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V38=\"\",\"\",VLOOKUP(V38,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y38=\"\",\"\",VLOOKUP(Y38,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA38=\"\",\"\",VLOOKUP(AA38,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD38=\"\",\"\",VLOOKUP(AD38,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF38=\"\",\"\",VLOOKUP(AF38,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH38=\"\",\"\",VLOOKUP(AH38,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ38=\"\",\"\",VLOOKUP(AJ38,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL38=\"\",\"\",VLOOKUP(AL38,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN38=\"\",\"\",VLOOKUP(AN38,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP38=\"\",\"\",VLOOKUP(AP38,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR38=\"\",\"\",VLOOKUP(AR38,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU38=\"\",\"\",VLOOKUP(AU38,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D39=\"\",\"\",VLOOKUP(D39,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F39=\"\",\"\",VLOOKUP(F39,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H39=\"\",\"\",VLOOKUP(H39,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J39=\"\",\"\",VLOOKUP(J39,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L39=\"\",\"\",VLOOKUP(L39,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N39=\"\",\"\",VLOOKUP(N39,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P39=\"\",\"\",VLOOKUP(P39,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T39=\"\",\"\",VLOOKUP(T39,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V39=\"\",\"\",VLOOKUP(V39,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y39=\"\",\"\",VLOOKUP(Y39,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA39=\"\",\"\",VLOOKUP(AA39,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD39=\"\",\"\",VLOOKUP(AD39,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF39=\"\",\"\",VLOOKUP(AF39,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH39=\"\",\"\",VLOOKUP(AH39,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ39=\"\",\"\",VLOOKUP(AJ39,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL39=\"\",\"\",VLOOKUP(AL39,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN39=\"\",\"\",VLOOKUP(AN39,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP39=\"\",\"\",VLOOKUP(AP39,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR39=\"\",\"\",VLOOKUP(AR39,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU39=\"\",\"\",VLOOKUP(AU39,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D40=\"\",\"\",VLOOKUP(D40,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F40=\"\",\"\",VLOOKUP(F40,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H40=\"\",\"\",VLOOKUP(H40,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J40=\"\",\"\",VLOOKUP(J40,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L40=\"\",\"\",VLOOKUP(L40,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N40=\"\",\"\",VLOOKUP(N40,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P40=\"\",\"\",VLOOKUP(P40,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T40=\"\",\"\",VLOOKUP(T40,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V40=\"\",\"\",VLOOKUP(V40,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y40=\"\",\"\",VLOOKUP(Y40,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA40=\"\",\"\",VLOOKUP(AA40,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD40=\"\",\"\",VLOOKUP(AD40,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF40=\"\",\"\",VLOOKUP(AF40,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH40=\"\",\"\",VLOOKUP(AH40,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ40=\"\",\"\",VLOOKUP(AJ40,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL40=\"\",\"\",VLOOKUP(AL40,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN40=\"\",\"\",VLOOKUP(AN40,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP40=\"\",\"\",VLOOKUP(AP40,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR40=\"\",\"\",VLOOKUP(AR40,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU40=\"\",\"\",VLOOKUP(AU40,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D41=\"\",\"\",VLOOKUP(D41,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F41=\"\",\"\",VLOOKUP(F41,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H41=\"\",\"\",VLOOKUP(H41,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J41=\"\",\"\",VLOOKUP(J41,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L41=\"\",\"\",VLOOKUP(L41,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N41=\"\",\"\",VLOOKUP(N41,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P41=\"\",\"\",VLOOKUP(P41,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T41=\"\",\"\",VLOOKUP(T41,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V41=\"\",\"\",VLOOKUP(V41,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y41=\"\",\"\",VLOOKUP(Y41,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA41=\"\",\"\",VLOOKUP(AA41,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD41=\"\",\"\",VLOOKUP(AD41,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF41=\"\",\"\",VLOOKUP(AF41,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH41=\"\",\"\",VLOOKUP(AH41,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ41=\"\",\"\",VLOOKUP(AJ41,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL41=\"\",\"\",VLOOKUP(AL41,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN41=\"\",\"\",VLOOKUP(AN41,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP41=\"\",\"\",VLOOKUP(AP41,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR41=\"\",\"\",VLOOKUP(AR41,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU41=\"\",\"\",VLOOKUP(AU41,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D42=\"\",\"\",VLOOKUP(D42,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F42=\"\",\"\",VLOOKUP(F42,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H42=\"\",\"\",VLOOKUP(H42,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J42=\"\",\"\",VLOOKUP(J42,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L42=\"\",\"\",VLOOKUP(L42,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N42=\"\",\"\",VLOOKUP(N42,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P42=\"\",\"\",VLOOKUP(P42,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T42=\"\",\"\",VLOOKUP(T42,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V42=\"\",\"\",VLOOKUP(V42,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y42=\"\",\"\",VLOOKUP(Y42,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA42=\"\",\"\",VLOOKUP(AA42,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD42=\"\",\"\",VLOOKUP(AD42,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF42=\"\",\"\",VLOOKUP(AF42,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH42=\"\",\"\",VLOOKUP(AH42,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ42=\"\",\"\",VLOOKUP(AJ42,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL42=\"\",\"\",VLOOKUP(AL42,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN42=\"\",\"\",VLOOKUP(AN42,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP42=\"\",\"\",VLOOKUP(AP42,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR42=\"\",\"\",VLOOKUP(AR42,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU42=\"\",\"\",VLOOKUP(AU42,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D43=\"\",\"\",VLOOKUP(D43,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F43=\"\",\"\",VLOOKUP(F43,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H43=\"\",\"\",VLOOKUP(H43,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J43=\"\",\"\",VLOOKUP(J43,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L43=\"\",\"\",VLOOKUP(L43,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N43=\"\",\"\",VLOOKUP(N43,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P43=\"\",\"\",VLOOKUP(P43,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T43=\"\",\"\",VLOOKUP(T43,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V43=\"\",\"\",VLOOKUP(V43,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y43=\"\",\"\",VLOOKUP(Y43,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA43=\"\",\"\",VLOOKUP(AA43,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD43=\"\",\"\",VLOOKUP(AD43,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF43=\"\",\"\",VLOOKUP(AF43,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH43=\"\",\"\",VLOOKUP(AH43,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ43=\"\",\"\",VLOOKUP(AJ43,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL43=\"\",\"\",VLOOKUP(AL43,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN43=\"\",\"\",VLOOKUP(AN43,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP43=\"\",\"\",VLOOKUP(AP43,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR43=\"\",\"\",VLOOKUP(AR43,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU43=\"\",\"\",VLOOKUP(AU43,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D44=\"\",\"\",VLOOKUP(D44,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F44=\"\",\"\",VLOOKUP(F44,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H44=\"\",\"\",VLOOKUP(H44,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J44=\"\",\"\",VLOOKUP(J44,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L44=\"\",\"\",VLOOKUP(L44,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N44=\"\",\"\",VLOOKUP(N44,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P44=\"\",\"\",VLOOKUP(P44,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T44=\"\",\"\",VLOOKUP(T44,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V44=\"\",\"\",VLOOKUP(V44,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y44=\"\",\"\",VLOOKUP(Y44,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA44=\"\",\"\",VLOOKUP(AA44,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD44=\"\",\"\",VLOOKUP(AD44,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF44=\"\",\"\",VLOOKUP(AF44,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH44=\"\",\"\",VLOOKUP(AH44,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ44=\"\",\"\",VLOOKUP(AJ44,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL44=\"\",\"\",VLOOKUP(AL44,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN44=\"\",\"\",VLOOKUP(AN44,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP44=\"\",\"\",VLOOKUP(AP44,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR44=\"\",\"\",VLOOKUP(AR44,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU44=\"\",\"\",VLOOKUP(AU44,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F45=\"\",\"\",VLOOKUP(F45,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H45=\"\",\"\",VLOOKUP(H45,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J45=\"\",\"\",VLOOKUP(J45,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L45=\"\",\"\",VLOOKUP(L45,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N45=\"\",\"\",VLOOKUP(N45,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P45=\"\",\"\",VLOOKUP(P45,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T45=\"\",\"\",VLOOKUP(T45,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V45=\"\",\"\",VLOOKUP(V45,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y45=\"\",\"\",VLOOKUP(Y45,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA45=\"\",\"\",VLOOKUP(AA45,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD45=\"\",\"\",VLOOKUP(AD45,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF45=\"\",\"\",VLOOKUP(AF45,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH45=\"\",\"\",VLOOKUP(AH45,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ45=\"\",\"\",VLOOKUP(AJ45,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL45=\"\",\"\",VLOOKUP(AL45,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN45=\"\",\"\",VLOOKUP(AN45,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP45=\"\",\"\",VLOOKUP(AP45,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR45=\"\",\"\",VLOOKUP(AR45,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU45=\"\",\"\",VLOOKUP(AU45,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D46=\"\",\"\",VLOOKUP(D46,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F46=\"\",\"\",VLOOKUP(F46,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H46=\"\",\"\",VLOOKUP(H46,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J46=\"\",\"\",VLOOKUP(J46,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L46=\"\",\"\",VLOOKUP(L46,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N46=\"\",\"\",VLOOKUP(N46,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P46=\"\",\"\",VLOOKUP(P46,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T46=\"\",\"\",VLOOKUP(T46,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V46=\"\",\"\",VLOOKUP(V46,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y46=\"\",\"\",VLOOKUP(Y46,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA46=\"\",\"\",VLOOKUP(AA46,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD46=\"\",\"\",VLOOKUP(AD46,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF46=\"\",\"\",VLOOKUP(AF46,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH46=\"\",\"\",VLOOKUP(AH46,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ46=\"\",\"\",VLOOKUP(AJ46,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL46=\"\",\"\",VLOOKUP(AL46,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN46=\"\",\"\",VLOOKUP(AN46,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP46=\"\",\"\",VLOOKUP(AP46,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR46=\"\",\"\",VLOOKUP(AR46,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU46=\"\",\"\",VLOOKUP(AU46,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D47=\"\",\"\",VLOOKUP(D47,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F47=\"\",\"\",VLOOKUP(F47,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H47=\"\",\"\",VLOOKUP(H47,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J47=\"\",\"\",VLOOKUP(J47,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L47=\"\",\"\",VLOOKUP(L47,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N47=\"\",\"\",VLOOKUP(N47,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P47=\"\",\"\",VLOOKUP(P47,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T47=\"\",\"\",VLOOKUP(T47,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V47=\"\",\"\",VLOOKUP(V47,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y47=\"\",\"\",VLOOKUP(Y47,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA47=\"\",\"\",VLOOKUP(AA47,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD47=\"\",\"\",VLOOKUP(AD47,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF47=\"\",\"\",VLOOKUP(AF47,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH47=\"\",\"\",VLOOKUP(AH47,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ47=\"\",\"\",VLOOKUP(AJ47,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL47=\"\",\"\",VLOOKUP(AL47,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN47=\"\",\"\",VLOOKUP(AN47,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP47=\"\",\"\",VLOOKUP(AP47,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR47=\"\",\"\",VLOOKUP(AR47,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU47=\"\",\"\",VLOOKUP(AU47,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D48=\"\",\"\",VLOOKUP(D48,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F48=\"\",\"\",VLOOKUP(F48,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H48=\"\",\"\",VLOOKUP(H48,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J48=\"\",\"\",VLOOKUP(J48,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L48=\"\",\"\",VLOOKUP(L48,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N48=\"\",\"\",VLOOKUP(N48,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P48=\"\",\"\",VLOOKUP(P48,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T48=\"\",\"\",VLOOKUP(T48,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V48=\"\",\"\",VLOOKUP(V48,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y48=\"\",\"\",VLOOKUP(Y48,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA48=\"\",\"\",VLOOKUP(AA48,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD48=\"\",\"\",VLOOKUP(AD48,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF48=\"\",\"\",VLOOKUP(AF48,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH48=\"\",\"\",VLOOKUP(AH48,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ48=\"\",\"\",VLOOKUP(AJ48,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL48=\"\",\"\",VLOOKUP(AL48,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN48=\"\",\"\",VLOOKUP(AN48,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP48=\"\",\"\",VLOOKUP(AP48,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR48=\"\",\"\",VLOOKUP(AR48,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU48=\"\",\"\",VLOOKUP(AU48,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D49=\"\",\"\",VLOOKUP(D49,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F49=\"\",\"\",VLOOKUP(F49,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H49=\"\",\"\",VLOOKUP(H49,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J49=\"\",\"\",VLOOKUP(J49,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L49=\"\",\"\",VLOOKUP(L49,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N49=\"\",\"\",VLOOKUP(N49,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P49=\"\",\"\",VLOOKUP(P49,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T49=\"\",\"\",VLOOKUP(T49,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V49=\"\",\"\",VLOOKUP(V49,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y49=\"\",\"\",VLOOKUP(Y49,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA49=\"\",\"\",VLOOKUP(AA49,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD49=\"\",\"\",VLOOKUP(AD49,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF49=\"\",\"\",VLOOKUP(AF49,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH49=\"\",\"\",VLOOKUP(AH49,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ49=\"\",\"\",VLOOKUP(AJ49,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL49=\"\",\"\",VLOOKUP(AL49,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN49=\"\",\"\",VLOOKUP(AN49,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP49=\"\",\"\",VLOOKUP(AP49,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR49=\"\",\"\",VLOOKUP(AR49,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU49=\"\",\"\",VLOOKUP(AU49,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D50=\"\",\"\",VLOOKUP(D50,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F50=\"\",\"\",VLOOKUP(F50,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H50=\"\",\"\",VLOOKUP(H50,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J50=\"\",\"\",VLOOKUP(J50,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L50=\"\",\"\",VLOOKUP(L50,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N50=\"\",\"\",VLOOKUP(N50,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P50=\"\",\"\",VLOOKUP(P50,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T50=\"\",\"\",VLOOKUP(T50,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V50=\"\",\"\",VLOOKUP(V50,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y50=\"\",\"\",VLOOKUP(Y50,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA50=\"\",\"\",VLOOKUP(AA50,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD50=\"\",\"\",VLOOKUP(AD50,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF50=\"\",\"\",VLOOKUP(AF50,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH50=\"\",\"\",VLOOKUP(AH50,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ50=\"\",\"\",VLOOKUP(AJ50,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL50=\"\",\"\",VLOOKUP(AL50,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN50=\"\",\"\",VLOOKUP(AN50,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP50=\"\",\"\",VLOOKUP(AP50,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR50=\"\",\"\",VLOOKUP(AR50,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU50=\"\",\"\",VLOOKUP(AU50,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D51=\"\",\"\",VLOOKUP(D51,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F51=\"\",\"\",VLOOKUP(F51,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H51=\"\",\"\",VLOOKUP(H51,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J51=\"\",\"\",VLOOKUP(J51,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L51=\"\",\"\",VLOOKUP(L51,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N51=\"\",\"\",VLOOKUP(N51,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P51=\"\",\"\",VLOOKUP(P51,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T51=\"\",\"\",VLOOKUP(T51,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V51=\"\",\"\",VLOOKUP(V51,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y51=\"\",\"\",VLOOKUP(Y51,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA51=\"\",\"\",VLOOKUP(AA51,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD51=\"\",\"\",VLOOKUP(AD51,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF51=\"\",\"\",VLOOKUP(AF51,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH51=\"\",\"\",VLOOKUP(AH51,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ51=\"\",\"\",VLOOKUP(AJ51,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL51=\"\",\"\",VLOOKUP(AL51,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN51=\"\",\"\",VLOOKUP(AN51,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP51=\"\",\"\",VLOOKUP(AP51,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR51=\"\",\"\",VLOOKUP(AR51,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU51=\"\",\"\",VLOOKUP(AU51,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D52=\"\",\"\",VLOOKUP(D52,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F52=\"\",\"\",VLOOKUP(F52,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H52=\"\",\"\",VLOOKUP(H52,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J52=\"\",\"\",VLOOKUP(J52,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L52=\"\",\"\",VLOOKUP(L52,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N52=\"\",\"\",VLOOKUP(N52,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P52=\"\",\"\",VLOOKUP(P52,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T52=\"\",\"\",VLOOKUP(T52,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V52=\"\",\"\",VLOOKUP(V52,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y52=\"\",\"\",VLOOKUP(Y52,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA52=\"\",\"\",VLOOKUP(AA52,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD52=\"\",\"\",VLOOKUP(AD52,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF52=\"\",\"\",VLOOKUP(AF52,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH52=\"\",\"\",VLOOKUP(AH52,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ52=\"\",\"\",VLOOKUP(AJ52,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL52=\"\",\"\",VLOOKUP(AL52,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN52=\"\",\"\",VLOOKUP(AN52,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP52=\"\",\"\",VLOOKUP(AP52,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR52=\"\",\"\",VLOOKUP(AR52,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU52=\"\",\"\",VLOOKUP(AU52,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D53=\"\",\"\",VLOOKUP(D53,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F53=\"\",\"\",VLOOKUP(F53,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H53=\"\",\"\",VLOOKUP(H53,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J53=\"\",\"\",VLOOKUP(J53,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L53=\"\",\"\",VLOOKUP(L53,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N53=\"\",\"\",VLOOKUP(N53,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P53=\"\",\"\",VLOOKUP(P53,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T53=\"\",\"\",VLOOKUP(T53,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V53=\"\",\"\",VLOOKUP(V53,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y53=\"\",\"\",VLOOKUP(Y53,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA53=\"\",\"\",VLOOKUP(AA53,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD53=\"\",\"\",VLOOKUP(AD53,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF53=\"\",\"\",VLOOKUP(AF53,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH53=\"\",\"\",VLOOKUP(AH53,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ53=\"\",\"\",VLOOKUP(AJ53,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL53=\"\",\"\",VLOOKUP(AL53,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN53=\"\",\"\",VLOOKUP(AN53,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP53=\"\",\"\",VLOOKUP(AP53,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR53=\"\",\"\",VLOOKUP(AR53,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU53=\"\",\"\",VLOOKUP(AU53,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D54=\"\",\"\",VLOOKUP(D54,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F54=\"\",\"\",VLOOKUP(F54,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H54=\"\",\"\",VLOOKUP(H54,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J54=\"\",\"\",VLOOKUP(J54,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L54=\"\",\"\",VLOOKUP(L54,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N54=\"\",\"\",VLOOKUP(N54,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P54=\"\",\"\",VLOOKUP(P54,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T54=\"\",\"\",VLOOKUP(T54,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V54=\"\",\"\",VLOOKUP(V54,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y54=\"\",\"\",VLOOKUP(Y54,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA54=\"\",\"\",VLOOKUP(AA54,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD54=\"\",\"\",VLOOKUP(AD54,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF54=\"\",\"\",VLOOKUP(AF54,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH54=\"\",\"\",VLOOKUP(AH54,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ54=\"\",\"\",VLOOKUP(AJ54,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL54=\"\",\"\",VLOOKUP(AL54,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN54=\"\",\"\",VLOOKUP(AN54,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP54=\"\",\"\",VLOOKUP(AP54,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR54=\"\",\"\",VLOOKUP(AR54,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU54=\"\",\"\",VLOOKUP(AU54,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D55=\"\",\"\",VLOOKUP(D55,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F55=\"\",\"\",VLOOKUP(F55,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H55=\"\",\"\",VLOOKUP(H55,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J55=\"\",\"\",VLOOKUP(J55,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L55=\"\",\"\",VLOOKUP(L55,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N55=\"\",\"\",VLOOKUP(N55,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P55=\"\",\"\",VLOOKUP(P55,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T55=\"\",\"\",VLOOKUP(T55,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V55=\"\",\"\",VLOOKUP(V55,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y55=\"\",\"\",VLOOKUP(Y55,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA55=\"\",\"\",VLOOKUP(AA55,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD55=\"\",\"\",VLOOKUP(AD55,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF55=\"\",\"\",VLOOKUP(AF55,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH55=\"\",\"\",VLOOKUP(AH55,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ55=\"\",\"\",VLOOKUP(AJ55,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL55=\"\",\"\",VLOOKUP(AL55,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN55=\"\",\"\",VLOOKUP(AN55,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP55=\"\",\"\",VLOOKUP(AP55,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR55=\"\",\"\",VLOOKUP(AR55,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU55=\"\",\"\",VLOOKUP(AU55,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D56=\"\",\"\",VLOOKUP(D56,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F56=\"\",\"\",VLOOKUP(F56,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H56=\"\",\"\",VLOOKUP(H56,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J56=\"\",\"\",VLOOKUP(J56,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L56=\"\",\"\",VLOOKUP(L56,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N56=\"\",\"\",VLOOKUP(N56,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P56=\"\",\"\",VLOOKUP(P56,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T56=\"\",\"\",VLOOKUP(T56,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V56=\"\",\"\",VLOOKUP(V56,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y56=\"\",\"\",VLOOKUP(Y56,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA56=\"\",\"\",VLOOKUP(AA56,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD56=\"\",\"\",VLOOKUP(AD56,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF56=\"\",\"\",VLOOKUP(AF56,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH56=\"\",\"\",VLOOKUP(AH56,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ56=\"\",\"\",VLOOKUP(AJ56,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL56=\"\",\"\",VLOOKUP(AL56,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN56=\"\",\"\",VLOOKUP(AN56,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP56=\"\",\"\",VLOOKUP(AP56,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR56=\"\",\"\",VLOOKUP(AR56,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU56=\"\",\"\",VLOOKUP(AU56,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D57=\"\",\"\",VLOOKUP(D57,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F57=\"\",\"\",VLOOKUP(F57,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H57=\"\",\"\",VLOOKUP(H57,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J57=\"\",\"\",VLOOKUP(J57,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L57=\"\",\"\",VLOOKUP(L57,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N57=\"\",\"\",VLOOKUP(N57,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P57=\"\",\"\",VLOOKUP(P57,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T57=\"\",\"\",VLOOKUP(T57,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V57=\"\",\"\",VLOOKUP(V57,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y57=\"\",\"\",VLOOKUP(Y57,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA57=\"\",\"\",VLOOKUP(AA57,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD57=\"\",\"\",VLOOKUP(AD57,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF57=\"\",\"\",VLOOKUP(AF57,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH57=\"\",\"\",VLOOKUP(AH57,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ57=\"\",\"\",VLOOKUP(AJ57,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL57=\"\",\"\",VLOOKUP(AL57,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN57=\"\",\"\",VLOOKUP(AN57,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP57=\"\",\"\",VLOOKUP(AP57,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR57=\"\",\"\",VLOOKUP(AR57,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU57=\"\",\"\",VLOOKUP(AU57,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D58=\"\",\"\",VLOOKUP(D58,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F58=\"\",\"\",VLOOKUP(F58,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H58=\"\",\"\",VLOOKUP(H58,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J58=\"\",\"\",VLOOKUP(J58,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L58=\"\",\"\",VLOOKUP(L58,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N58=\"\",\"\",VLOOKUP(N58,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P58=\"\",\"\",VLOOKUP(P58,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T58=\"\",\"\",VLOOKUP(T58,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V58=\"\",\"\",VLOOKUP(V58,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y58=\"\",\"\",VLOOKUP(Y58,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA58=\"\",\"\",VLOOKUP(AA58,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD58=\"\",\"\",VLOOKUP(AD58,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF58=\"\",\"\",VLOOKUP(AF58,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH58=\"\",\"\",VLOOKUP(AH58,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ58=\"\",\"\",VLOOKUP(AJ58,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL58=\"\",\"\",VLOOKUP(AL58,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN58=\"\",\"\",VLOOKUP(AN58,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP58=\"\",\"\",VLOOKUP(AP58,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR58=\"\",\"\",VLOOKUP(AR58,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU58=\"\",\"\",VLOOKUP(AU58,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D59=\"\",\"\",VLOOKUP(D59,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F59=\"\",\"\",VLOOKUP(F59,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H59=\"\",\"\",VLOOKUP(H59,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J59=\"\",\"\",VLOOKUP(J59,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L59=\"\",\"\",VLOOKUP(L59,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N59=\"\",\"\",VLOOKUP(N59,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P59=\"\",\"\",VLOOKUP(P59,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T59=\"\",\"\",VLOOKUP(T59,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V59=\"\",\"\",VLOOKUP(V59,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y59=\"\",\"\",VLOOKUP(Y59,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA59=\"\",\"\",VLOOKUP(AA59,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD59=\"\",\"\",VLOOKUP(AD59,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF59=\"\",\"\",VLOOKUP(AF59,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH59=\"\",\"\",VLOOKUP(AH59,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ59=\"\",\"\",VLOOKUP(AJ59,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL59=\"\",\"\",VLOOKUP(AL59,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN59=\"\",\"\",VLOOKUP(AN59,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP59=\"\",\"\",VLOOKUP(AP59,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR59=\"\",\"\",VLOOKUP(AR59,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU59=\"\",\"\",VLOOKUP(AU59,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D60=\"\",\"\",VLOOKUP(D60,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F60=\"\",\"\",VLOOKUP(F60,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H60=\"\",\"\",VLOOKUP(H60,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J60=\"\",\"\",VLOOKUP(J60,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L60=\"\",\"\",VLOOKUP(L60,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N60=\"\",\"\",VLOOKUP(N60,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P60=\"\",\"\",VLOOKUP(P60,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T60=\"\",\"\",VLOOKUP(T60,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V60=\"\",\"\",VLOOKUP(V60,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y60=\"\",\"\",VLOOKUP(Y60,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA60=\"\",\"\",VLOOKUP(AA60,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD60=\"\",\"\",VLOOKUP(AD60,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF60=\"\",\"\",VLOOKUP(AF60,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH60=\"\",\"\",VLOOKUP(AH60,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ60=\"\",\"\",VLOOKUP(AJ60,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL60=\"\",\"\",VLOOKUP(AL60,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN60=\"\",\"\",VLOOKUP(AN60,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP60=\"\",\"\",VLOOKUP(AP60,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR60=\"\",\"\",VLOOKUP(AR60,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU60=\"\",\"\",VLOOKUP(AU60,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D61=\"\",\"\",VLOOKUP(D61,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F61=\"\",\"\",VLOOKUP(F61,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H61=\"\",\"\",VLOOKUP(H61,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J61=\"\",\"\",VLOOKUP(J61,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L61=\"\",\"\",VLOOKUP(L61,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N61=\"\",\"\",VLOOKUP(N61,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P61=\"\",\"\",VLOOKUP(P61,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T61=\"\",\"\",VLOOKUP(T61,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V61=\"\",\"\",VLOOKUP(V61,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y61=\"\",\"\",VLOOKUP(Y61,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA61=\"\",\"\",VLOOKUP(AA61,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD61=\"\",\"\",VLOOKUP(AD61,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF61=\"\",\"\",VLOOKUP(AF61,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH61=\"\",\"\",VLOOKUP(AH61,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ61=\"\",\"\",VLOOKUP(AJ61,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL61=\"\",\"\",VLOOKUP(AL61,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN61=\"\",\"\",VLOOKUP(AN61,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP61=\"\",\"\",VLOOKUP(AP61,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR61=\"\",\"\",VLOOKUP(AR61,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU61=\"\",\"\",VLOOKUP(AU61,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D62=\"\",\"\",VLOOKUP(D62,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F62=\"\",\"\",VLOOKUP(F62,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H62=\"\",\"\",VLOOKUP(H62,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J62=\"\",\"\",VLOOKUP(J62,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L62=\"\",\"\",VLOOKUP(L62,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N62=\"\",\"\",VLOOKUP(N62,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P62=\"\",\"\",VLOOKUP(P62,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T62=\"\",\"\",VLOOKUP(T62,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V62=\"\",\"\",VLOOKUP(V62,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y62=\"\",\"\",VLOOKUP(Y62,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA62=\"\",\"\",VLOOKUP(AA62,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD62=\"\",\"\",VLOOKUP(AD62,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF62=\"\",\"\",VLOOKUP(AF62,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH62=\"\",\"\",VLOOKUP(AH62,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ62=\"\",\"\",VLOOKUP(AJ62,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL62=\"\",\"\",VLOOKUP(AL62,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN62=\"\",\"\",VLOOKUP(AN62,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP62=\"\",\"\",VLOOKUP(AP62,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR62=\"\",\"\",VLOOKUP(AR62,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU62=\"\",\"\",VLOOKUP(AU62,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D63=\"\",\"\",VLOOKUP(D63,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F63=\"\",\"\",VLOOKUP(F63,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H63=\"\",\"\",VLOOKUP(H63,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J63=\"\",\"\",VLOOKUP(J63,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L63=\"\",\"\",VLOOKUP(L63,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N63=\"\",\"\",VLOOKUP(N63,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P63=\"\",\"\",VLOOKUP(P63,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T63=\"\",\"\",VLOOKUP(T63,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V63=\"\",\"\",VLOOKUP(V63,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y63=\"\",\"\",VLOOKUP(Y63,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA63=\"\",\"\",VLOOKUP(AA63,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD63=\"\",\"\",VLOOKUP(AD63,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF63=\"\",\"\",VLOOKUP(AF63,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH63=\"\",\"\",VLOOKUP(AH63,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ63=\"\",\"\",VLOOKUP(AJ63,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL63=\"\",\"\",VLOOKUP(AL63,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN63=\"\",\"\",VLOOKUP(AN63,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP63=\"\",\"\",VLOOKUP(AP63,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR63=\"\",\"\",VLOOKUP(AR63,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU63=\"\",\"\",VLOOKUP(AU63,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D64=\"\",\"\",VLOOKUP(D64,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F64=\"\",\"\",VLOOKUP(F64,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H64=\"\",\"\",VLOOKUP(H64,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J64=\"\",\"\",VLOOKUP(J64,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L64=\"\",\"\",VLOOKUP(L64,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N64=\"\",\"\",VLOOKUP(N64,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P64=\"\",\"\",VLOOKUP(P64,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T64=\"\",\"\",VLOOKUP(T64,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V64=\"\",\"\",VLOOKUP(V64,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y64=\"\",\"\",VLOOKUP(Y64,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA64=\"\",\"\",VLOOKUP(AA64,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD64=\"\",\"\",VLOOKUP(AD64,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF64=\"\",\"\",VLOOKUP(AF64,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH64=\"\",\"\",VLOOKUP(AH64,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ64=\"\",\"\",VLOOKUP(AJ64,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL64=\"\",\"\",VLOOKUP(AL64,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN64=\"\",\"\",VLOOKUP(AN64,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP64=\"\",\"\",VLOOKUP(AP64,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR64=\"\",\"\",VLOOKUP(AR64,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU64=\"\",\"\",VLOOKUP(AU64,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D65=\"\",\"\",VLOOKUP(D65,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F65=\"\",\"\",VLOOKUP(F65,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H65=\"\",\"\",VLOOKUP(H65,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J65=\"\",\"\",VLOOKUP(J65,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L65=\"\",\"\",VLOOKUP(L65,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N65=\"\",\"\",VLOOKUP(N65,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P65=\"\",\"\",VLOOKUP(P65,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T65=\"\",\"\",VLOOKUP(T65,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V65=\"\",\"\",VLOOKUP(V65,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y65=\"\",\"\",VLOOKUP(Y65,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA65=\"\",\"\",VLOOKUP(AA65,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD65=\"\",\"\",VLOOKUP(AD65,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF65=\"\",\"\",VLOOKUP(AF65,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH65=\"\",\"\",VLOOKUP(AH65,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ65=\"\",\"\",VLOOKUP(AJ65,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL65=\"\",\"\",VLOOKUP(AL65,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN65=\"\",\"\",VLOOKUP(AN65,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP65=\"\",\"\",VLOOKUP(AP65,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR65=\"\",\"\",VLOOKUP(AR65,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU65=\"\",\"\",VLOOKUP(AU65,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D66=\"\",\"\",VLOOKUP(D66,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F66=\"\",\"\",VLOOKUP(F66,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H66=\"\",\"\",VLOOKUP(H66,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J66=\"\",\"\",VLOOKUP(J66,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L66=\"\",\"\",VLOOKUP(L66,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N66=\"\",\"\",VLOOKUP(N66,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P66=\"\",\"\",VLOOKUP(P66,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T66=\"\",\"\",VLOOKUP(T66,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V66=\"\",\"\",VLOOKUP(V66,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y66=\"\",\"\",VLOOKUP(Y66,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA66=\"\",\"\",VLOOKUP(AA66,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD66=\"\",\"\",VLOOKUP(AD66,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF66=\"\",\"\",VLOOKUP(AF66,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH66=\"\",\"\",VLOOKUP(AH66,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ66=\"\",\"\",VLOOKUP(AJ66,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL66=\"\",\"\",VLOOKUP(AL66,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN66=\"\",\"\",VLOOKUP(AN66,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP66=\"\",\"\",VLOOKUP(AP66,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR66=\"\",\"\",VLOOKUP(AR66,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU66=\"\",\"\",VLOOKUP(AU66,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D67=\"\",\"\",VLOOKUP(D67,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F67=\"\",\"\",VLOOKUP(F67,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H67=\"\",\"\",VLOOKUP(H67,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J67=\"\",\"\",VLOOKUP(J67,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L67=\"\",\"\",VLOOKUP(L67,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N67=\"\",\"\",VLOOKUP(N67,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P67=\"\",\"\",VLOOKUP(P67,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T67=\"\",\"\",VLOOKUP(T67,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V67=\"\",\"\",VLOOKUP(V67,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y67=\"\",\"\",VLOOKUP(Y67,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA67=\"\",\"\",VLOOKUP(AA67,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD67=\"\",\"\",VLOOKUP(AD67,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF67=\"\",\"\",VLOOKUP(AF67,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH67=\"\",\"\",VLOOKUP(AH67,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ67=\"\",\"\",VLOOKUP(AJ67,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL67=\"\",\"\",VLOOKUP(AL67,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN67=\"\",\"\",VLOOKUP(AN67,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP67=\"\",\"\",VLOOKUP(AP67,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR67=\"\",\"\",VLOOKUP(AR67,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU67=\"\",\"\",VLOOKUP(AU67,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D68=\"\",\"\",VLOOKUP(D68,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F68=\"\",\"\",VLOOKUP(F68,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H68=\"\",\"\",VLOOKUP(H68,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J68=\"\",\"\",VLOOKUP(J68,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L68=\"\",\"\",VLOOKUP(L68,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N68=\"\",\"\",VLOOKUP(N68,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P68=\"\",\"\",VLOOKUP(P68,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T68=\"\",\"\",VLOOKUP(T68,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V68=\"\",\"\",VLOOKUP(V68,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y68=\"\",\"\",VLOOKUP(Y68,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA68=\"\",\"\",VLOOKUP(AA68,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD68=\"\",\"\",VLOOKUP(AD68,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF68=\"\",\"\",VLOOKUP(AF68,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH68=\"\",\"\",VLOOKUP(AH68,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ68=\"\",\"\",VLOOKUP(AJ68,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL68=\"\",\"\",VLOOKUP(AL68,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN68=\"\",\"\",VLOOKUP(AN68,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP68=\"\",\"\",VLOOKUP(AP68,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR68=\"\",\"\",VLOOKUP(AR68,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU68=\"\",\"\",VLOOKUP(AU68,Organisation[],2,FALSE))","v":""}]
[{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&B69&\"/\"&C69&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,{"$f":"IF(D69=\"\",\"\",VLOOKUP(D69,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F69=\"\",\"\",VLOOKUP(F69,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H69=\"\",\"\",VLOOKUP(H69,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J69=\"\",\"\",VLOOKUP(J69,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L69=\"\",\"\",VLOOKUP(L69,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N69=\"\",\"\",VLOOKUP(N69,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P69=\"\",\"\",VLOOKUP(P69,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T69=\"\",\"\",VLOOKUP(T69,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V69=\"\",\"\",VLOOKUP(V69,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y69=\"\",\"\",VLOOKUP(Y69,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA69=\"\",\"\",VLOOKUP(AA69,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD69=\"\",\"\",VLOOKUP(AD69,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF69=\"\",\"\",VLOOKUP(AF69,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH69=\"\",\"\",VLOOKUP(AH69,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ69=\"\",\"\",VLOOKUP(AJ69,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL69=\"\",\"\",VLOOKUP(AL69,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN69=\"\",\"\",VLOOKUP(AN69,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP69=\"\",\"\",VLOOKUP(AP69,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR69=\"\",\"\",VLOOKUP(AR69,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU69=\"\",\"\",VLOOKUP(AU69,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D70=\"\",\"\",VLOOKUP(D70,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F70=\"\",\"\",VLOOKUP(F70,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H70=\"\",\"\",VLOOKUP(H70,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J70=\"\",\"\",VLOOKUP(J70,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L70=\"\",\"\",VLOOKUP(L70,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N70=\"\",\"\",VLOOKUP(N70,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P70=\"\",\"\",VLOOKUP(P70,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T70=\"\",\"\",VLOOKUP(T70,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V70=\"\",\"\",VLOOKUP(V70,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y70=\"\",\"\",VLOOKUP(Y70,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA70=\"\",\"\",VLOOKUP(AA70,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD70=\"\",\"\",VLOOKUP(AD70,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF70=\"\",\"\",VLOOKUP(AF70,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH70=\"\",\"\",VLOOKUP(AH70,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ70=\"\",\"\",VLOOKUP(AJ70,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL70=\"\",\"\",VLOOKUP(AL70,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN70=\"\",\"\",VLOOKUP(AN70,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP70=\"\",\"\",VLOOKUP(AP70,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR70=\"\",\"\",VLOOKUP(AR70,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU70=\"\",\"\",VLOOKUP(AU70,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D71=\"\",\"\",VLOOKUP(D71,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F71=\"\",\"\",VLOOKUP(F71,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H71=\"\",\"\",VLOOKUP(H71,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J71=\"\",\"\",VLOOKUP(J71,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L71=\"\",\"\",VLOOKUP(L71,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N71=\"\",\"\",VLOOKUP(N71,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P71=\"\",\"\",VLOOKUP(P71,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T71=\"\",\"\",VLOOKUP(T71,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V71=\"\",\"\",VLOOKUP(V71,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y71=\"\",\"\",VLOOKUP(Y71,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA71=\"\",\"\",VLOOKUP(AA71,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD71=\"\",\"\",VLOOKUP(AD71,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF71=\"\",\"\",VLOOKUP(AF71,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH71=\"\",\"\",VLOOKUP(AH71,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ71=\"\",\"\",VLOOKUP(AJ71,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL71=\"\",\"\",VLOOKUP(AL71,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN71=\"\",\"\",VLOOKUP(AN71,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP71=\"\",\"\",VLOOKUP(AP71,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR71=\"\",\"\",VLOOKUP(AR71,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU71=\"\",\"\",VLOOKUP(AU71,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D72=\"\",\"\",VLOOKUP(D72,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F72=\"\",\"\",VLOOKUP(F72,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H72=\"\",\"\",VLOOKUP(H72,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J72=\"\",\"\",VLOOKUP(J72,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L72=\"\",\"\",VLOOKUP(L72,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N72=\"\",\"\",VLOOKUP(N72,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P72=\"\",\"\",VLOOKUP(P72,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T72=\"\",\"\",VLOOKUP(T72,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V72=\"\",\"\",VLOOKUP(V72,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y72=\"\",\"\",VLOOKUP(Y72,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA72=\"\",\"\",VLOOKUP(AA72,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD72=\"\",\"\",VLOOKUP(AD72,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF72=\"\",\"\",VLOOKUP(AF72,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH72=\"\",\"\",VLOOKUP(AH72,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ72=\"\",\"\",VLOOKUP(AJ72,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL72=\"\",\"\",VLOOKUP(AL72,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN72=\"\",\"\",VLOOKUP(AN72,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP72=\"\",\"\",VLOOKUP(AP72,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR72=\"\",\"\",VLOOKUP(AR72,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU72=\"\",\"\",VLOOKUP(AU72,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D73=\"\",\"\",VLOOKUP(D73,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F73=\"\",\"\",VLOOKUP(F73,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H73=\"\",\"\",VLOOKUP(H73,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J73=\"\",\"\",VLOOKUP(J73,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L73=\"\",\"\",VLOOKUP(L73,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N73=\"\",\"\",VLOOKUP(N73,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P73=\"\",\"\",VLOOKUP(P73,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T73=\"\",\"\",VLOOKUP(T73,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V73=\"\",\"\",VLOOKUP(V73,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y73=\"\",\"\",VLOOKUP(Y73,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA73=\"\",\"\",VLOOKUP(AA73,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD73=\"\",\"\",VLOOKUP(AD73,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF73=\"\",\"\",VLOOKUP(AF73,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH73=\"\",\"\",VLOOKUP(AH73,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ73=\"\",\"\",VLOOKUP(AJ73,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL73=\"\",\"\",VLOOKUP(AL73,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN73=\"\",\"\",VLOOKUP(AN73,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP73=\"\",\"\",VLOOKUP(AP73,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR73=\"\",\"\",VLOOKUP(AR73,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU73=\"\",\"\",VLOOKUP(AU73,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D74=\"\",\"\",VLOOKUP(D74,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F74=\"\",\"\",VLOOKUP(F74,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H74=\"\",\"\",VLOOKUP(H74,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J74=\"\",\"\",VLOOKUP(J74,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L74=\"\",\"\",VLOOKUP(L74,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N74=\"\",\"\",VLOOKUP(N74,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P74=\"\",\"\",VLOOKUP(P74,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T74=\"\",\"\",VLOOKUP(T74,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V74=\"\",\"\",VLOOKUP(V74,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y74=\"\",\"\",VLOOKUP(Y74,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA74=\"\",\"\",VLOOKUP(AA74,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD74=\"\",\"\",VLOOKUP(AD74,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF74=\"\",\"\",VLOOKUP(AF74,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH74=\"\",\"\",VLOOKUP(AH74,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ74=\"\",\"\",VLOOKUP(AJ74,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL74=\"\",\"\",VLOOKUP(AL74,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN74=\"\",\"\",VLOOKUP(AN74,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP74=\"\",\"\",VLOOKUP(AP74,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR74=\"\",\"\",VLOOKUP(AR74,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU74=\"\",\"\",VLOOKUP(AU74,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D75=\"\",\"\",VLOOKUP(D75,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F75=\"\",\"\",VLOOKUP(F75,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H75=\"\",\"\",VLOOKUP(H75,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J75=\"\",\"\",VLOOKUP(J75,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L75=\"\",\"\",VLOOKUP(L75,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N75=\"\",\"\",VLOOKUP(N75,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P75=\"\",\"\",VLOOKUP(P75,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T75=\"\",\"\",VLOOKUP(T75,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V75=\"\",\"\",VLOOKUP(V75,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y75=\"\",\"\",VLOOKUP(Y75,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA75=\"\",\"\",VLOOKUP(AA75,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD75=\"\",\"\",VLOOKUP(AD75,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF75=\"\",\"\",VLOOKUP(AF75,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH75=\"\",\"\",VLOOKUP(AH75,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ75=\"\",\"\",VLOOKUP(AJ75,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL75=\"\",\"\",VLOOKUP(AL75,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN75=\"\",\"\",VLOOKUP(AN75,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP75=\"\",\"\",VLOOKUP(AP75,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR75=\"\",\"\",VLOOKUP(AR75,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU75=\"\",\"\",VLOOKUP(AU75,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D76=\"\",\"\",VLOOKUP(D76,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F76=\"\",\"\",VLOOKUP(F76,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H76=\"\",\"\",VLOOKUP(H76,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J76=\"\",\"\",VLOOKUP(J76,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L76=\"\",\"\",VLOOKUP(L76,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N76=\"\",\"\",VLOOKUP(N76,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P76=\"\",\"\",VLOOKUP(P76,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T76=\"\",\"\",VLOOKUP(T76,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V76=\"\",\"\",VLOOKUP(V76,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y76=\"\",\"\",VLOOKUP(Y76,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA76=\"\",\"\",VLOOKUP(AA76,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD76=\"\",\"\",VLOOKUP(AD76,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF76=\"\",\"\",VLOOKUP(AF76,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH76=\"\",\"\",VLOOKUP(AH76,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ76=\"\",\"\",VLOOKUP(AJ76,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL76=\"\",\"\",VLOOKUP(AL76,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN76=\"\",\"\",VLOOKUP(AN76,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP76=\"\",\"\",VLOOKUP(AP76,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR76=\"\",\"\",VLOOKUP(AR76,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU76=\"\",\"\",VLOOKUP(AU76,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D77=\"\",\"\",VLOOKUP(D77,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F77=\"\",\"\",VLOOKUP(F77,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H77=\"\",\"\",VLOOKUP(H77,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J77=\"\",\"\",VLOOKUP(J77,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L77=\"\",\"\",VLOOKUP(L77,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N77=\"\",\"\",VLOOKUP(N77,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P77=\"\",\"\",VLOOKUP(P77,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T77=\"\",\"\",VLOOKUP(T77,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V77=\"\",\"\",VLOOKUP(V77,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y77=\"\",\"\",VLOOKUP(Y77,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA77=\"\",\"\",VLOOKUP(AA77,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD77=\"\",\"\",VLOOKUP(AD77,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF77=\"\",\"\",VLOOKUP(AF77,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH77=\"\",\"\",VLOOKUP(AH77,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ77=\"\",\"\",VLOOKUP(AJ77,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL77=\"\",\"\",VLOOKUP(AL77,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN77=\"\",\"\",VLOOKUP(AN77,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP77=\"\",\"\",VLOOKUP(AP77,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR77=\"\",\"\",VLOOKUP(AR77,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU77=\"\",\"\",VLOOKUP(AU77,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D78=\"\",\"\",VLOOKUP(D78,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F78=\"\",\"\",VLOOKUP(F78,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H78=\"\",\"\",VLOOKUP(H78,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J78=\"\",\"\",VLOOKUP(J78,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L78=\"\",\"\",VLOOKUP(L78,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N78=\"\",\"\",VLOOKUP(N78,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P78=\"\",\"\",VLOOKUP(P78,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T78=\"\",\"\",VLOOKUP(T78,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V78=\"\",\"\",VLOOKUP(V78,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y78=\"\",\"\",VLOOKUP(Y78,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA78=\"\",\"\",VLOOKUP(AA78,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD78=\"\",\"\",VLOOKUP(AD78,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF78=\"\",\"\",VLOOKUP(AF78,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH78=\"\",\"\",VLOOKUP(AH78,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ78=\"\",\"\",VLOOKUP(AJ78,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL78=\"\",\"\",VLOOKUP(AL78,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN78=\"\",\"\",VLOOKUP(AN78,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP78=\"\",\"\",VLOOKUP(AP78,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR78=\"\",\"\",VLOOKUP(AR78,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU78=\"\",\"\",VLOOKUP(AU78,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D79=\"\",\"\",VLOOKUP(D79,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F79=\"\",\"\",VLOOKUP(F79,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H79=\"\",\"\",VLOOKUP(H79,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J79=\"\",\"\",VLOOKUP(J79,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L79=\"\",\"\",VLOOKUP(L79,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N79=\"\",\"\",VLOOKUP(N79,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P79=\"\",\"\",VLOOKUP(P79,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T79=\"\",\"\",VLOOKUP(T79,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V79=\"\",\"\",VLOOKUP(V79,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y79=\"\",\"\",VLOOKUP(Y79,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA79=\"\",\"\",VLOOKUP(AA79,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD79=\"\",\"\",VLOOKUP(AD79,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF79=\"\",\"\",VLOOKUP(AF79,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH79=\"\",\"\",VLOOKUP(AH79,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ79=\"\",\"\",VLOOKUP(AJ79,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL79=\"\",\"\",VLOOKUP(AL79,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN79=\"\",\"\",VLOOKUP(AN79,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP79=\"\",\"\",VLOOKUP(AP79,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR79=\"\",\"\",VLOOKUP(AR79,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU79=\"\",\"\",VLOOKUP(AU79,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D80=\"\",\"\",VLOOKUP(D80,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F80=\"\",\"\",VLOOKUP(F80,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H80=\"\",\"\",VLOOKUP(H80,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J80=\"\",\"\",VLOOKUP(J80,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L80=\"\",\"\",VLOOKUP(L80,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N80=\"\",\"\",VLOOKUP(N80,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P80=\"\",\"\",VLOOKUP(P80,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T80=\"\",\"\",VLOOKUP(T80,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V80=\"\",\"\",VLOOKUP(V80,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y80=\"\",\"\",VLOOKUP(Y80,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA80=\"\",\"\",VLOOKUP(AA80,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD80=\"\",\"\",VLOOKUP(AD80,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF80=\"\",\"\",VLOOKUP(AF80,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH80=\"\",\"\",VLOOKUP(AH80,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ80=\"\",\"\",VLOOKUP(AJ80,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL80=\"\",\"\",VLOOKUP(AL80,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN80=\"\",\"\",VLOOKUP(AN80,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP80=\"\",\"\",VLOOKUP(AP80,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR80=\"\",\"\",VLOOKUP(AR80,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU80=\"\",\"\",VLOOKUP(AU80,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D81=\"\",\"\",VLOOKUP(D81,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F81=\"\",\"\",VLOOKUP(F81,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H81=\"\",\"\",VLOOKUP(H81,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J81=\"\",\"\",VLOOKUP(J81,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L81=\"\",\"\",VLOOKUP(L81,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N81=\"\",\"\",VLOOKUP(N81,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P81=\"\",\"\",VLOOKUP(P81,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T81=\"\",\"\",VLOOKUP(T81,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V81=\"\",\"\",VLOOKUP(V81,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y81=\"\",\"\",VLOOKUP(Y81,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA81=\"\",\"\",VLOOKUP(AA81,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD81=\"\",\"\",VLOOKUP(AD81,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF81=\"\",\"\",VLOOKUP(AF81,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH81=\"\",\"\",VLOOKUP(AH81,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ81=\"\",\"\",VLOOKUP(AJ81,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL81=\"\",\"\",VLOOKUP(AL81,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN81=\"\",\"\",VLOOKUP(AN81,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP81=\"\",\"\",VLOOKUP(AP81,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR81=\"\",\"\",VLOOKUP(AR81,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU81=\"\",\"\",VLOOKUP(AU81,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D82=\"\",\"\",VLOOKUP(D82,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F82=\"\",\"\",VLOOKUP(F82,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H82=\"\",\"\",VLOOKUP(H82,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J82=\"\",\"\",VLOOKUP(J82,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L82=\"\",\"\",VLOOKUP(L82,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N82=\"\",\"\",VLOOKUP(N82,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P82=\"\",\"\",VLOOKUP(P82,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T82=\"\",\"\",VLOOKUP(T82,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V82=\"\",\"\",VLOOKUP(V82,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y82=\"\",\"\",VLOOKUP(Y82,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA82=\"\",\"\",VLOOKUP(AA82,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD82=\"\",\"\",VLOOKUP(AD82,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF82=\"\",\"\",VLOOKUP(AF82,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH82=\"\",\"\",VLOOKUP(AH82,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ82=\"\",\"\",VLOOKUP(AJ82,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL82=\"\",\"\",VLOOKUP(AL82,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN82=\"\",\"\",VLOOKUP(AN82,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP82=\"\",\"\",VLOOKUP(AP82,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR82=\"\",\"\",VLOOKUP(AR82,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU82=\"\",\"\",VLOOKUP(AU82,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D83=\"\",\"\",VLOOKUP(D83,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F83=\"\",\"\",VLOOKUP(F83,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H83=\"\",\"\",VLOOKUP(H83,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J83=\"\",\"\",VLOOKUP(J83,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L83=\"\",\"\",VLOOKUP(L83,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N83=\"\",\"\",VLOOKUP(N83,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P83=\"\",\"\",VLOOKUP(P83,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T83=\"\",\"\",VLOOKUP(T83,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V83=\"\",\"\",VLOOKUP(V83,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y83=\"\",\"\",VLOOKUP(Y83,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA83=\"\",\"\",VLOOKUP(AA83,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD83=\"\",\"\",VLOOKUP(AD83,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF83=\"\",\"\",VLOOKUP(AF83,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH83=\"\",\"\",VLOOKUP(AH83,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ83=\"\",\"\",VLOOKUP(AJ83,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL83=\"\",\"\",VLOOKUP(AL83,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN83=\"\",\"\",VLOOKUP(AN83,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP83=\"\",\"\",VLOOKUP(AP83,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR83=\"\",\"\",VLOOKUP(AR83,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU83=\"\",\"\",VLOOKUP(AU83,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D84=\"\",\"\",VLOOKUP(D84,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F84=\"\",\"\",VLOOKUP(F84,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H84=\"\",\"\",VLOOKUP(H84,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J84=\"\",\"\",VLOOKUP(J84,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L84=\"\",\"\",VLOOKUP(L84,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N84=\"\",\"\",VLOOKUP(N84,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P84=\"\",\"\",VLOOKUP(P84,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T84=\"\",\"\",VLOOKUP(T84,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V84=\"\",\"\",VLOOKUP(V84,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y84=\"\",\"\",VLOOKUP(Y84,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA84=\"\",\"\",VLOOKUP(AA84,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD84=\"\",\"\",VLOOKUP(AD84,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF84=\"\",\"\",VLOOKUP(AF84,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH84=\"\",\"\",VLOOKUP(AH84,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ84=\"\",\"\",VLOOKUP(AJ84,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL84=\"\",\"\",VLOOKUP(AL84,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN84=\"\",\"\",VLOOKUP(AN84,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP84=\"\",\"\",VLOOKUP(AP84,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR84=\"\",\"\",VLOOKUP(AR84,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU84=\"\",\"\",VLOOKUP(AU84,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D85=\"\",\"\",VLOOKUP(D85,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F85=\"\",\"\",VLOOKUP(F85,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H85=\"\",\"\",VLOOKUP(H85,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J85=\"\",\"\",VLOOKUP(J85,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L85=\"\",\"\",VLOOKUP(L85,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N85=\"\",\"\",VLOOKUP(N85,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P85=\"\",\"\",VLOOKUP(P85,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T85=\"\",\"\",VLOOKUP(T85,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V85=\"\",\"\",VLOOKUP(V85,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y85=\"\",\"\",VLOOKUP(Y85,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA85=\"\",\"\",VLOOKUP(AA85,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD85=\"\",\"\",VLOOKUP(AD85,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF85=\"\",\"\",VLOOKUP(AF85,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH85=\"\",\"\",VLOOKUP(AH85,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ85=\"\",\"\",VLOOKUP(AJ85,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL85=\"\",\"\",VLOOKUP(AL85,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN85=\"\",\"\",VLOOKUP(AN85,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP85=\"\",\"\",VLOOKUP(AP85,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR85=\"\",\"\",VLOOKUP(AR85,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU85=\"\",\"\",VLOOKUP(AU85,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D86=\"\",\"\",VLOOKUP(D86,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F86=\"\",\"\",VLOOKUP(F86,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H86=\"\",\"\",VLOOKUP(H86,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J86=\"\",\"\",VLOOKUP(J86,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L86=\"\",\"\",VLOOKUP(L86,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N86=\"\",\"\",VLOOKUP(N86,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P86=\"\",\"\",VLOOKUP(P86,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T86=\"\",\"\",VLOOKUP(T86,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V86=\"\",\"\",VLOOKUP(V86,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y86=\"\",\"\",VLOOKUP(Y86,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA86=\"\",\"\",VLOOKUP(AA86,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD86=\"\",\"\",VLOOKUP(AD86,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF86=\"\",\"\",VLOOKUP(AF86,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH86=\"\",\"\",VLOOKUP(AH86,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ86=\"\",\"\",VLOOKUP(AJ86,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL86=\"\",\"\",VLOOKUP(AL86,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN86=\"\",\"\",VLOOKUP(AN86,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP86=\"\",\"\",VLOOKUP(AP86,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR86=\"\",\"\",VLOOKUP(AR86,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU86=\"\",\"\",VLOOKUP(AU86,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D87=\"\",\"\",VLOOKUP(D87,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F87=\"\",\"\",VLOOKUP(F87,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H87=\"\",\"\",VLOOKUP(H87,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J87=\"\",\"\",VLOOKUP(J87,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L87=\"\",\"\",VLOOKUP(L87,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N87=\"\",\"\",VLOOKUP(N87,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P87=\"\",\"\",VLOOKUP(P87,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T87=\"\",\"\",VLOOKUP(T87,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V87=\"\",\"\",VLOOKUP(V87,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y87=\"\",\"\",VLOOKUP(Y87,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA87=\"\",\"\",VLOOKUP(AA87,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD87=\"\",\"\",VLOOKUP(AD87,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF87=\"\",\"\",VLOOKUP(AF87,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH87=\"\",\"\",VLOOKUP(AH87,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ87=\"\",\"\",VLOOKUP(AJ87,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL87=\"\",\"\",VLOOKUP(AL87,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN87=\"\",\"\",VLOOKUP(AN87,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP87=\"\",\"\",VLOOKUP(AP87,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR87=\"\",\"\",VLOOKUP(AR87,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU87=\"\",\"\",VLOOKUP(AU87,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D88=\"\",\"\",VLOOKUP(D88,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F88=\"\",\"\",VLOOKUP(F88,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H88=\"\",\"\",VLOOKUP(H88,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J88=\"\",\"\",VLOOKUP(J88,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L88=\"\",\"\",VLOOKUP(L88,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N88=\"\",\"\",VLOOKUP(N88,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P88=\"\",\"\",VLOOKUP(P88,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T88=\"\",\"\",VLOOKUP(T88,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V88=\"\",\"\",VLOOKUP(V88,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y88=\"\",\"\",VLOOKUP(Y88,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA88=\"\",\"\",VLOOKUP(AA88,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD88=\"\",\"\",VLOOKUP(AD88,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF88=\"\",\"\",VLOOKUP(AF88,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH88=\"\",\"\",VLOOKUP(AH88,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ88=\"\",\"\",VLOOKUP(AJ88,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL88=\"\",\"\",VLOOKUP(AL88,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN88=\"\",\"\",VLOOKUP(AN88,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP88=\"\",\"\",VLOOKUP(AP88,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR88=\"\",\"\",VLOOKUP(AR88,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU88=\"\",\"\",VLOOKUP(AU88,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D89=\"\",\"\",VLOOKUP(D89,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F89=\"\",\"\",VLOOKUP(F89,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H89=\"\",\"\",VLOOKUP(H89,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J89=\"\",\"\",VLOOKUP(J89,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L89=\"\",\"\",VLOOKUP(L89,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N89=\"\",\"\",VLOOKUP(N89,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P89=\"\",\"\",VLOOKUP(P89,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T89=\"\",\"\",VLOOKUP(T89,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V89=\"\",\"\",VLOOKUP(V89,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y89=\"\",\"\",VLOOKUP(Y89,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA89=\"\",\"\",VLOOKUP(AA89,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD89=\"\",\"\",VLOOKUP(AD89,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF89=\"\",\"\",VLOOKUP(AF89,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH89=\"\",\"\",VLOOKUP(AH89,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ89=\"\",\"\",VLOOKUP(AJ89,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL89=\"\",\"\",VLOOKUP(AL89,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN89=\"\",\"\",VLOOKUP(AN89,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP89=\"\",\"\",VLOOKUP(AP89,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR89=\"\",\"\",VLOOKUP(AR89,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU89=\"\",\"\",VLOOKUP(AU89,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D90=\"\",\"\",VLOOKUP(D90,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F90=\"\",\"\",VLOOKUP(F90,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H90=\"\",\"\",VLOOKUP(H90,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J90=\"\",\"\",VLOOKUP(J90,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L90=\"\",\"\",VLOOKUP(L90,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N90=\"\",\"\",VLOOKUP(N90,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P90=\"\",\"\",VLOOKUP(P90,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T90=\"\",\"\",VLOOKUP(T90,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V90=\"\",\"\",VLOOKUP(V90,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y90=\"\",\"\",VLOOKUP(Y90,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA90=\"\",\"\",VLOOKUP(AA90,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD90=\"\",\"\",VLOOKUP(AD90,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF90=\"\",\"\",VLOOKUP(AF90,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH90=\"\",\"\",VLOOKUP(AH90,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ90=\"\",\"\",VLOOKUP(AJ90,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL90=\"\",\"\",VLOOKUP(AL90,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN90=\"\",\"\",VLOOKUP(AN90,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP90=\"\",\"\",VLOOKUP(AP90,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR90=\"\",\"\",VLOOKUP(AR90,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU90=\"\",\"\",VLOOKUP(AU90,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D91=\"\",\"\",VLOOKUP(D91,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F91=\"\",\"\",VLOOKUP(F91,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H91=\"\",\"\",VLOOKUP(H91,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J91=\"\",\"\",VLOOKUP(J91,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L91=\"\",\"\",VLOOKUP(L91,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N91=\"\",\"\",VLOOKUP(N91,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P91=\"\",\"\",VLOOKUP(P91,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T91=\"\",\"\",VLOOKUP(T91,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V91=\"\",\"\",VLOOKUP(V91,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y91=\"\",\"\",VLOOKUP(Y91,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA91=\"\",\"\",VLOOKUP(AA91,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD91=\"\",\"\",VLOOKUP(AD91,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF91=\"\",\"\",VLOOKUP(AF91,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH91=\"\",\"\",VLOOKUP(AH91,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ91=\"\",\"\",VLOOKUP(AJ91,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL91=\"\",\"\",VLOOKUP(AL91,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN91=\"\",\"\",VLOOKUP(AN91,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP91=\"\",\"\",VLOOKUP(AP91,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR91=\"\",\"\",VLOOKUP(AR91,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU91=\"\",\"\",VLOOKUP(AU91,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D92=\"\",\"\",VLOOKUP(D92,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F92=\"\",\"\",VLOOKUP(F92,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H92=\"\",\"\",VLOOKUP(H92,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J92=\"\",\"\",VLOOKUP(J92,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L92=\"\",\"\",VLOOKUP(L92,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N92=\"\",\"\",VLOOKUP(N92,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P92=\"\",\"\",VLOOKUP(P92,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T92=\"\",\"\",VLOOKUP(T92,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V92=\"\",\"\",VLOOKUP(V92,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y92=\"\",\"\",VLOOKUP(Y92,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA92=\"\",\"\",VLOOKUP(AA92,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD92=\"\",\"\",VLOOKUP(AD92,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF92=\"\",\"\",VLOOKUP(AF92,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH92=\"\",\"\",VLOOKUP(AH92,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ92=\"\",\"\",VLOOKUP(AJ92,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL92=\"\",\"\",VLOOKUP(AL92,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN92=\"\",\"\",VLOOKUP(AN92,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP92=\"\",\"\",VLOOKUP(AP92,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR92=\"\",\"\",VLOOKUP(AR92,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU92=\"\",\"\",VLOOKUP(AU92,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D93=\"\",\"\",VLOOKUP(D93,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F93=\"\",\"\",VLOOKUP(F93,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H93=\"\",\"\",VLOOKUP(H93,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J93=\"\",\"\",VLOOKUP(J93,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L93=\"\",\"\",VLOOKUP(L93,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N93=\"\",\"\",VLOOKUP(N93,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P93=\"\",\"\",VLOOKUP(P93,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T93=\"\",\"\",VLOOKUP(T93,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V93=\"\",\"\",VLOOKUP(V93,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y93=\"\",\"\",VLOOKUP(Y93,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA93=\"\",\"\",VLOOKUP(AA93,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD93=\"\",\"\",VLOOKUP(AD93,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF93=\"\",\"\",VLOOKUP(AF93,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH93=\"\",\"\",VLOOKUP(AH93,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ93=\"\",\"\",VLOOKUP(AJ93,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL93=\"\",\"\",VLOOKUP(AL93,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN93=\"\",\"\",VLOOKUP(AN93,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP93=\"\",\"\",VLOOKUP(AP93,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR93=\"\",\"\",VLOOKUP(AR93,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU93=\"\",\"\",VLOOKUP(AU93,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D94=\"\",\"\",VLOOKUP(D94,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F94=\"\",\"\",VLOOKUP(F94,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H94=\"\",\"\",VLOOKUP(H94,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J94=\"\",\"\",VLOOKUP(J94,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L94=\"\",\"\",VLOOKUP(L94,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N94=\"\",\"\",VLOOKUP(N94,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P94=\"\",\"\",VLOOKUP(P94,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T94=\"\",\"\",VLOOKUP(T94,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V94=\"\",\"\",VLOOKUP(V94,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y94=\"\",\"\",VLOOKUP(Y94,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA94=\"\",\"\",VLOOKUP(AA94,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD94=\"\",\"\",VLOOKUP(AD94,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF94=\"\",\"\",VLOOKUP(AF94,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH94=\"\",\"\",VLOOKUP(AH94,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ94=\"\",\"\",VLOOKUP(AJ94,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL94=\"\",\"\",VLOOKUP(AL94,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN94=\"\",\"\",VLOOKUP(AN94,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP94=\"\",\"\",VLOOKUP(AP94,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR94=\"\",\"\",VLOOKUP(AR94,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU94=\"\",\"\",VLOOKUP(AU94,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D95=\"\",\"\",VLOOKUP(D95,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F95=\"\",\"\",VLOOKUP(F95,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H95=\"\",\"\",VLOOKUP(H95,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J95=\"\",\"\",VLOOKUP(J95,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L95=\"\",\"\",VLOOKUP(L95,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N95=\"\",\"\",VLOOKUP(N95,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P95=\"\",\"\",VLOOKUP(P95,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T95=\"\",\"\",VLOOKUP(T95,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V95=\"\",\"\",VLOOKUP(V95,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y95=\"\",\"\",VLOOKUP(Y95,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA95=\"\",\"\",VLOOKUP(AA95,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD95=\"\",\"\",VLOOKUP(AD95,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF95=\"\",\"\",VLOOKUP(AF95,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH95=\"\",\"\",VLOOKUP(AH95,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ95=\"\",\"\",VLOOKUP(AJ95,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL95=\"\",\"\",VLOOKUP(AL95,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN95=\"\",\"\",VLOOKUP(AN95,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP95=\"\",\"\",VLOOKUP(AP95,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR95=\"\",\"\",VLOOKUP(AR95,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU95=\"\",\"\",VLOOKUP(AU95,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D96=\"\",\"\",VLOOKUP(D96,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F96=\"\",\"\",VLOOKUP(F96,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H96=\"\",\"\",VLOOKUP(H96,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J96=\"\",\"\",VLOOKUP(J96,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L96=\"\",\"\",VLOOKUP(L96,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N96=\"\",\"\",VLOOKUP(N96,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P96=\"\",\"\",VLOOKUP(P96,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T96=\"\",\"\",VLOOKUP(T96,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V96=\"\",\"\",VLOOKUP(V96,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y96=\"\",\"\",VLOOKUP(Y96,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA96=\"\",\"\",VLOOKUP(AA96,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD96=\"\",\"\",VLOOKUP(AD96,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF96=\"\",\"\",VLOOKUP(AF96,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH96=\"\",\"\",VLOOKUP(AH96,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ96=\"\",\"\",VLOOKUP(AJ96,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL96=\"\",\"\",VLOOKUP(AL96,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN96=\"\",\"\",VLOOKUP(AN96,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP96=\"\",\"\",VLOOKUP(AP96,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR96=\"\",\"\",VLOOKUP(AR96,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU96=\"\",\"\",VLOOKUP(AU96,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D97=\"\",\"\",VLOOKUP(D97,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F97=\"\",\"\",VLOOKUP(F97,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H97=\"\",\"\",VLOOKUP(H97,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J97=\"\",\"\",VLOOKUP(J97,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L97=\"\",\"\",VLOOKUP(L97,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N97=\"\",\"\",VLOOKUP(N97,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P97=\"\",\"\",VLOOKUP(P97,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T97=\"\",\"\",VLOOKUP(T97,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V97=\"\",\"\",VLOOKUP(V97,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y97=\"\",\"\",VLOOKUP(Y97,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA97=\"\",\"\",VLOOKUP(AA97,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD97=\"\",\"\",VLOOKUP(AD97,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF97=\"\",\"\",VLOOKUP(AF97,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH97=\"\",\"\",VLOOKUP(AH97,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ97=\"\",\"\",VLOOKUP(AJ97,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL97=\"\",\"\",VLOOKUP(AL97,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN97=\"\",\"\",VLOOKUP(AN97,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP97=\"\",\"\",VLOOKUP(AP97,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR97=\"\",\"\",VLOOKUP(AR97,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU97=\"\",\"\",VLOOKUP(AU97,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D98=\"\",\"\",VLOOKUP(D98,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F98=\"\",\"\",VLOOKUP(F98,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H98=\"\",\"\",VLOOKUP(H98,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J98=\"\",\"\",VLOOKUP(J98,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L98=\"\",\"\",VLOOKUP(L98,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N98=\"\",\"\",VLOOKUP(N98,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P98=\"\",\"\",VLOOKUP(P98,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T98=\"\",\"\",VLOOKUP(T98,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V98=\"\",\"\",VLOOKUP(V98,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y98=\"\",\"\",VLOOKUP(Y98,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA98=\"\",\"\",VLOOKUP(AA98,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD98=\"\",\"\",VLOOKUP(AD98,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF98=\"\",\"\",VLOOKUP(AF98,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH98=\"\",\"\",VLOOKUP(AH98,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ98=\"\",\"\",VLOOKUP(AJ98,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL98=\"\",\"\",VLOOKUP(AL98,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN98=\"\",\"\",VLOOKUP(AN98,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP98=\"\",\"\",VLOOKUP(AP98,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR98=\"\",\"\",VLOOKUP(AR98,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU98=\"\",\"\",VLOOKUP(AU98,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D99=\"\",\"\",VLOOKUP(D99,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F99=\"\",\"\",VLOOKUP(F99,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H99=\"\",\"\",VLOOKUP(H99,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J99=\"\",\"\",VLOOKUP(J99,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L99=\"\",\"\",VLOOKUP(L99,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N99=\"\",\"\",VLOOKUP(N99,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P99=\"\",\"\",VLOOKUP(P99,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T99=\"\",\"\",VLOOKUP(T99,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V99=\"\",\"\",VLOOKUP(V99,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y99=\"\",\"\",VLOOKUP(Y99,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA99=\"\",\"\",VLOOKUP(AA99,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD99=\"\",\"\",VLOOKUP(AD99,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF99=\"\",\"\",VLOOKUP(AF99,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH99=\"\",\"\",VLOOKUP(AH99,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ99=\"\",\"\",VLOOKUP(AJ99,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL99=\"\",\"\",VLOOKUP(AL99,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN99=\"\",\"\",VLOOKUP(AN99,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP99=\"\",\"\",VLOOKUP(AP99,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR99=\"\",\"\",VLOOKUP(AR99,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU99=\"\",\"\",VLOOKUP(AU99,Organisation[],2,FALSE))","v":""}]
["null",null,null,null,{"$f":"IF(D100=\"\",\"\",VLOOKUP(D100,light_make[],2,FALSE))","v":""},null,{"$f":"IF(F100=\"\",\"\",VLOOKUP(F100,light_model[],2,FALSE))","v":""},null,{"$f":"IF(H100=\"\",\"\",VLOOKUP(H100,supply_point[],2,FALSE))","v":""},null,{"$f":"IF(J100=\"\",\"\",VLOOKUP(J100,gear_make[],2,FALSE))","v":""},null,{"$f":"IF(L100=\"\",\"\",VLOOKUP(L100,gear_model[],2,FALSE))","v":""},null,{"$f":"IF(N100=\"\",\"\",VLOOKUP(N100,lamp_make[],2,FALSE))","v":""},null,{"$f":"IF(P100=\"\",\"\",VLOOKUP(P100,lamp_model[],2,FALSE))","v":""},null,null,null,{"$f":"IF(T100=\"\",\"\",VLOOKUP(T100,Light_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(V100=\"\",\"\",VLOOKUP(V100,light_status[],2,FALSE))","v":""},null,null,{"$f":"IF(Y100=\"\",\"\",VLOOKUP(Y100,Gear_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AA100=\"\",\"\",VLOOKUP(AA100,gear_status[],2,FALSE))","v":""},null,null,{"$f":"IF(AD100=\"\",\"\",VLOOKUP(AD100,Lamp_install_reason[],2,FALSE))","v":""},null,{"$f":"IF(AF100=\"\",\"\",VLOOKUP(AF100,Asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH100=\"\",\"\",VLOOKUP(AH100,risk_likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ100=\"\",\"\",VLOOKUP(AJ100,risk_consequence[],2,FALSE))","v":""},null,{"$f":"IF(AL100=\"\",\"\",VLOOKUP(AL100,risk[],2,FALSE))","v":""},null,{"$f":"IF(AN100=\"\",\"\",VLOOKUP(AN100,rul_reset[],2,FALSE))","v":""},null,{"$f":"IF(AP100=\"\",\"\",VLOOKUP(AP100,use_default_rc[],2,FALSE))","v":""},null,{"$f":"IF(AR100=\"\",\"\",VLOOKUP(AR100,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AU100=\"\",\"\",VLOOKUP(AU100,Organisation[],2,FALSE))","v":""}]

{"sheet":"Lookups","index":1,"n_rows":191,"n_cols":59,"rows_kept":191,"cut":false,"hidden":false,"merged":[]}
["light_make.description","light_make.code",null,"light_model.description","light_model.code",null,"supply_point.description","supply_point.code",null,"gear_make.description","gear_make.code",null,"gear_model.description","gear_model.code",null,"lamp_make.description","lamp_make.code",null,"lamp_model.description","lamp_model.code",null,"Light install reason.description","Light install reason.code",null,"light_status.description","light_status.code",null,"Gear install reason.description","Gear install reason.code",null,"gear_status.description","gear_status.code",null,"Lamp install reason.description","Lamp install reason.code",null,"Asset owner.description","Asset owner.code",null,"condition.description","condition.code",null,"Organisation.description","Organisation.code",null,"risk_likelihood.description","risk_likelihood.code",null,"risk_consequence.description","risk_consequence.code",null,"risk.description","risk.code",null,"rul_reset.code","Column1.code",null,"use_default_rc.description","use_default_rc.code"]
["AEC","AEC",null,"B2222","2222",null,"Montrose Box","MB",null,"AEC","AEC",null,"100w High Pressure Sodium","100S",null,"AEC","AEC",null,"100w High Pressure Sodium","100S",null,"Removed","99",null,"New","N",null,"Removed","99",null,"New","N",null,"Removed","99",null,"Local Authority","LA",null,"Excellent","1",null,"3M","3M",null,"Rare","1",null,"Insignificant","1",null,"Very Low","1",null,"Not Reset","N",null,"Default","D"]
["Corysal","COR",null,"B2224","2224",null,"Overhead","OH",null,"ARC","ARC",null,"135w Low Pressure Sodium","135L",null,"Betacom","BETA",null,"150w High Pressure Sodium","150S",null,"Accident Damage","AD",null,"Reconditioned","R",null,"Accident Damage","AD",null,"Reconditioned","R",null,"Accident Damage","AD",null,"NZTA","NZ",null,"Good","2",null,"Automobile Association","AA",null,"Unlikely","2",null,"Minor","2",null,"Low","2",null,"Reset to Zero","R",null,"User","U"]
["Cree","CREE",null,"B2229","2229",null,"Solar","SO",null,"Betacom","BT",null,"13w High Pressure Sodium","13S",null,"Cree","CREE",null,"250w HPS Coated","250C",null,"Aged - bulb blown","AG",null,null,null,null,"Aged - bulb blown","AG",null,"Not Applicable","X",null,"Aged - bulb blown","AG",null,"Power Board","PB",null,"Average","3",null,"Auckland Council","ACC",null,"Possible","3",null,"Moderate","3",null,"Medium","3"]
["DLEDS","DLED",null,"VC 450","450",null,"Underground","UG",null,"Corysal","COR",null,"150w Metal Halide","150M",null,"DLEDS","DLED",null,"250w High Pressure Sodium","250S",null,"Block Change","BC",null,null,null,null,"Block Change","BC",null,null,null,null,"Block Change","BC",null,null,null,null,"Poor","4",null,"Alarm Centre Installation Ltd","ACI",null,"Likely","4",null,"Major","4",null,"High","4"]
["ETI Solid State Lighting (Zuha","ETI",null,"A2 LED","A2",null,null,null,null,"GEC","GEC",null,"150w High Pressure Sodium","150S",null,"DW Windsor","DWW",null,"30w Sodium Vapour","30S",null,"Bulk Lamp Replacement","BL",null,null,null,null,"Bulk Lamp Replacement","BL",null,null,null,null,"Bulk Lamp Replacement","BL",null,null,null,null,"Very poor","5",null,"Agfirst","AGF",null,"Almost Certain","5",null,"Extreme","5",null,"Extreme","5"]
["GEC","GEC",null,"Architectural / decorative","ADEC",null,null,null,null,"Gough","GO",null,"250w Metal Halide","250M",null,"ETI Solid State Lighting (Zuhai)","ETI",null,"35w Low Pressure Sodium","35L",null,"Corrosion","CO",null,null,null,null,"Corrosion","CO",null,null,null,null,"Corrosion","CO",null,null,null,null,null,null,null,"Auckland Motorway Alliance","AMA",null,"Unknown","U",null,"Unknown","U",null,"Unknown","U"]
["Gerard","GERD",null,"Ambar 150 Curved","AMB1",null,null,null,null,"Kendelier","KE",null,"250w High Pressure Sodium","250S",null,"EYE","EYE",null,"400w High Pressure Sodium","400S",null,"Damaged","D",null,null,null,null,"Damaged","D",null,null,null,null,"Damaged","D",null,null,null,null,null,null,null,"Asset Management Engineers Ltd","AME"]
["Gough (Betacom)","GO",null,"Ambar 250 Curved","AMB2",null,null,null,null,"No Gear","NA",null,"36w High Pressure Sodium","36S",null,"Felicitty Smart Infrastructure","FELI",null,"55w Sodium Vapour","55S",null,"Deliberate damage","DM",null,null,null,null,"Deliberate damage","DM",null,null,null,null,"Deliberate damage","DM",null,null,null,null,null,null,null,"Asset Management Technicians Ltd","AMT"]
["iGuzzini","IGUZ",null,"Arialed","ARIA",null,null,null,null,"Phillips","PH",null,"400W High Pressure Sodium","400S",null,"GEC","GEC",null,"600w High Pressure Sodium","600S",null,"Fault","F",null,null,null,null,"Fault","F",null,null,null,null,"Fault","F",null,null,null,null,null,null,null,"Armitage Systems","ARM"]
["KIM Lighting","KIM",null,"Bollard","B",null,null,null,null,"Rudd","RU",null,"60w LED Italo 2","60I2",null,"Gerard","GERD",null,"NHT660 HPS SONT/T","660",null,"Lightning","LN",null,null,null,null,"Lightning","LN",null,null,null,null,"Lightning","LN",null,null,null,null,null,null,null,"Aspect Solutions Ltd","ASL"]
["Kendelier Lighting","KL",null,"B3000","B0",null,null,null,null,"Schreder","SCH",null,"70w High Pressure Sodium","70S",null,"GOUGH","GO",null,"660w High Pressure Sodium","660S",null,"Minor safety project","MS",null,null,null,null,"Minor safety project","MS",null,null,null,null,"Minor safety project","MS",null,null,null,null,null,null,null,"Auckland System Management","ASM"]
["KTL","KTL",null,"Shard-P B28-F","B28F",null,null,null,null,"Sylvania","SYL",null,"80w Mercury Vapour","80M",null,"HPS","HPS",null,"70w High Pressure Sodium","70S",null,"New Subdivision","NS",null,null,null,null,"New Subdivision","NS",null,null,null,null,"New Subdivision","NS",null,null,null,null,null,null,null,"Auckland Transport","AT2"]
["LED Roadway Lighting","LRL",null,"B2227","B7",null,null,null,null,"SYLVANIA","SYLV",null,"No Gear","NG",null,"iGuzzini","IGUZ",null,"940w High Pressure Sodium","940",null,"Removed","RM",null,null,null,null,"Removed","RM",null,null,null,null,"Removed","RM",null,null,null,null,null,null,null,"Aspect Technology and Equipment Ltd","ATE"]
["OrangeTek","OTEK",null,"Beta 79","B79",null,null,null,null,"Thorn","TH",null,"Typical for 0w","T0",null,"KIM Lighting","KIM",null,"NHT960 HPS SONT/T","960",null,"Safety Issues","SF",null,null,null,null,"Safety Issues","SF",null,null,null,null,"Safety Issues","SF",null,null,null,null,null,null,null,"ARRB Transport Research Ltd","ATR"]
["Panhost Ltd","PANH",null,"Belisha Beacon","BB",null,null,null,null,null,null,null,"Typical for 100W","T100",null,"KTL","KTL",null,"LED A2 LED","A2",null,"Upgrade","UG",null,null,null,null,"Upgrade","UG",null,null,null,null,"Upgrade","UG",null,null,null,null,null,null,null,"Auckland University","AUN"]
["Philips","PHIL",null,"Briteline Floodlight","BFL",null,null,null,null,null,null,null,"Typical for 125W (MV)","T125",null,"Ligman","LIGM",null,"LED Arialed","ARIA",null,"Vehicle Collision","VC",null,null,null,null,"Vehicle Collision","VC",null,null,null,null,"Vehicle Collision","VC",null,null,null,null,null,null,null,"Broadspectrum (NZ) Ltd","B(L"]
["CU Phosco Lighting","PHOS",null,"P862 (32 LED)","C862",null,null,null,null,null,null,null,"Typical for 13w","T13",null,"LED Roadway","LRL",null,"Atlantic","ATL",null,"Vandalised","VD",null,null,null,null,"Vandalised","VD",null,null,null,null,"Vandalised","VD",null,null,null,null,null,null,null,"Bri-Ken and Associates Ltd","BAA"]
["Ruud","RD",null,"P863 (32 LED)","C863",null,null,null,null,null,null,null,"Typical for 135W (SOX)","T135",null,"Neri S.P.A.","NERI",null,"LED Shard-P B28-F","B28F",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"]
["Schreder","SCH",null,"Corysal","COR",null,null,null,null,null,null,null,"Typical for 150W","T150",null,"NVC Lighting Technology Corporation","NVC",null,"Belisha Beacon 100W","BB",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&"]
["Sylvania","SYLV",null,"Coronet Pedestrian Flood Light","CPF",null,null,null,null,null,null,null,"Typical for 18w","T18",null,"OSRAM","OSRA",null,"LED P862 (32 LED)","C862",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"]
["Le Tehnika","TEHN",null,"Diadem","DM",null,null,null,null,null,null,null,"Typical for 250W","T250",null,"OrangeTek","OTEK",null,"LED P863 (32 LED)","C863",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"]
["Thorn","THN",null,"Goughlite EC","EC",null,null,null,null,null,null,null,"Typical for 250W (MV)","T25M",null,"Panhost Ltd","PANH",null,"LED COMPASS 1","COM1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blacktop","BLA"]
["VC","VC",null,"Goughlite EC (aeroscreen)","ECA",null,null,null,null,null,null,null,"Typical for 26W (Solar Light)","T26",null,"Philips","PHIL",null,"LED COMPASS 2","COM2",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"]
["Vizulo","VIZU",null,"Floodlight","FLDL",null,null,null,null,null,null,null,"62w LED Teceo 2","T262",null,"CU Phosco Lighting","PHOS",null,"CRUX PLUS [NB-SL-CRUX-P]","CRUX",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"]
["WE-EF","WE",null,"Floodlight e.g. like at ICB","FLOA",null,null,null,null,null,null,null,"Typical for 28w","T28",null,"Ruud","RUUD",null,"Kirium Pro 2","DWWK",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"]
["Hangzhou Technology Co. Ltd","ZGSM",null,"Floodlight (at weighstations)","FLOO",null,null,null,null,null,null,null,"Typical for 400W","T400",null,"Schreder","SCH",null,"Fluorescent compact PL11W","FC11",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,"Goughlite 500","G500",null,null,null,null,null,null,null,"Typical for 50W","T50",null,"Signify","SIGN",null,"Fluorescent 2 x 20W","FT20",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,"GL520","G520",null,null,null,null,null,null,null,"Typical for 70W","T70",null,"Simon Electric Co Ltd","SIM",null,"Fluorescent 2 x 30W","FT30",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,"Goughlite 600","G600",null,null,null,null,null,null,null,"Typical for 80W (MV)","T80",null,"Sylvania","SYLV",null,"Fluorescent Tube","FT58",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,"Goughlite 630","G630",null,null,null,null,null,null,null,"Typical for 90W (SOX)","T90",null,"Le Tehnika","TEHN",null,"LED - GL520","G520",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,"Goughlite 700","G700",null,null,null,null,null,null,null,"Typical for fluoresc (2x20,30)","TF",null,"THORN","TH",null,"GL520","GL5",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,"GL500","GL5",null,null,null,null,null,null,null,"Xitanium - DALI 2.0","XI-D",null,"Vizulo","VIZU",null,"LED Roadstar GPLM","GPLM",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,"GL600","GL6",null,null,null,null,null,null,null,"Xitanium - Lineswitch","XI-L",null,"Vulkan","VULK",null,"LED Roadstar GPLS","GPLS",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,"GL700","GL7",null,null,null,null,null,null,null,"Xitanium - 1-10V","XI-V",null,"WE-EF","WE",null,"LED GYRO","GYRO",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,"GLEC","GLEC",null,null,null,null,null,null,null,null,null,null,"Windsor Urban","WINU",null,"Halogen 400W","H400",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,"Roadstar GPLM","GPLM",null,null,null,null,null,null,null,null,null,null,"Hangzhou Technology Co. Ltd","ZGSM",null,"Halogen 50W","H50",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,"Roadstar GPLS","GPLS",null,null,null,null,null,null,null,null,null,null,null,null,null,"Halogen 500W","H500",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,"Heron (twin fluorescent)","HER",null,null,null,null,null,null,null,null,null,null,null,null,null,"Halswell","HALS",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,"Himast","HM",null,null,null,null,null,null,null,null,null,null,null,null,null,"Incandescent 100W","I100",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,"ITALO 1 - 7SS","IT17",null,null,null,null,null,null,null,null,null,null,null,null,null,"Incandescent 150W","I150",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,"ITALO 1-Peds Cross","IT1C",null,null,null,null,null,null,null,null,null,null,null,null,null,"Incandescent 60W","I60",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,"ITALO 1 - STA 1","IT1S",null,null,null,null,null,null,null,null,null,null,null,null,null,"Incandescent 75W","I75",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,"ITALO 1- Veh","IT1V",null,null,null,null,null,null,null,null,null,null,null,null,null,"ITALO 1 - 7SS","IT17",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,"ITALO 2-Peds Cross","IT2C",null,null,null,null,null,null,null,null,null,null,null,null,null,"ITALO 1-Peds Cross","IT1C",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,"ITALO 2-Veh","IT2V",null,null,null,null,null,null,null,null,null,null,null,null,null,"ITALO 1 - STA 1","IT1S",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,"ITALO 3","IT3V",null,null,null,null,null,null,null,null,null,null,null,null,null,"ITALO 1-- Veh","IT1V",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,"KAOS1","K1",null,null,null,null,null,null,null,null,null,null,null,null,null,"ITALO 2-Peds Cross","IT2C",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,"Kowhai (90W SOX Lamp)","K100",null,null,null,null,null,null,null,null,null,null,null,null,null,"ITALO 2-Veh","IT2V",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,"KAOS2","K2",null,null,null,null,null,null,null,null,null,null,null,null,null,"ITALO 3","IT3",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,"Kowhai (135W SOX Lamp)","K200",null,null,null,null,null,null,null,null,null,null,null,null,null,"LEDway XIL10","LED1",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,"Kowai","KO",null,null,null,null,null,null,null,null,null,null,null,null,null,"LEDway XIL02","LED2",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,"LEDway XIL10","LED1",null,null,null,null,null,null,null,null,null,null,null,null,null,"LEDway XIL04","LED4",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,"LEDway XIL02","LED2",null,null,null,null,null,null,null,null,null,null,null,null,null,"LEDway XIL07","LED7",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,"LEDway XIL04","LED4",null,null,null,null,null,null,null,null,null,null,null,null,null,"LEDway XSL0204D-4D","LEDD",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,"LEDway XIL07","LED7",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED-in (OC) 4.5","LO45",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,"LEDway XSL0204D-4D","LEDD",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED-in (OC) 4.7","LO47",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,"LED-in (OC) 4.5","LO45",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED-in (ST) 4.5","LS45",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,"LED-in (OC) 4.7","LO47",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED-in (ST) 4.7","LS47",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,"LED-in (ST) 4.5","LS45",null,null,null,null,null,null,null,null,null,null,null,null,null,"Light Antares","LTAN",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,"LED-in (ST) 4.7","LS47",null,null,null,null,null,null,null,null,null,null,null,null,null,"Luma 1 80","LUMA",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,"Luxtella S12XPL-20AT","LX12",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Luxtella S12XPL-20AT","LX12",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,"Mini Martin 12 LED","MARN",null,null,null,null,null,null,null,null,null,null,null,null,null,"Mercury vapour 100W","M100",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,"Maxi urban","MU",null,null,null,null,null,null,null,null,null,null,null,null,null,"Mercury vapour 125W","M125",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,"Terraled Mini MX1","MX1",null,null,null,null,null,null,null,null,null,null,null,null,null,"Mercury vapour 250W","M250",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,"Ignis 1-Peds Cross","NG1C",null,null,null,null,null,null,null,null,null,null,null,null,null,"Mercury vapour 400W","M400",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,"Ignis 1 -Veh","NG1V",null,null,null,null,null,null,null,null,null,null,null,null,null,"Mercury vapour 50W","M50",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,"Ignis 2","NG2V",null,null,null,null,null,null,null,null,null,null,null,null,null,"Mercury vapour 80W","M80",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,"NXT-12S","NX12",null,null,null,null,null,null,null,null,null,null,null,null,null,"Mini Martin 12 LED","MARN",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,"NXT-24S - 4AH","NX24",null,null,null,null,null,null,null,null,null,null,null,null,null,"Mercury blended 160W","MB",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,"NXT-36S","NX36",null,null,null,null,null,null,null,null,null,null,null,null,null,"1000w Metal Halide","MH10",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,"NXT-48M","NX48",null,null,null,null,null,null,null,null,null,null,null,null,null,"Metal Halide 150W","MH15",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,"NXT-60M","NX60",null,null,null,null,null,null,null,null,null,null,null,null,null,"Metal halide 175W","MH17",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,"NXT-72M","NX72",null,null,null,null,null,null,null,null,null,null,null,null,null,"Metal Halide 250W","MH25",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,"Optimum","OM",null,null,null,null,null,null,null,null,null,null,null,null,null,"Metal halide 400W","MH40",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,"Optispan","OP",null,null,null,null,null,null,null,null,null,null,null,null,null,"MOD 2.0 PRO","MO2P",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,"Optima (intermediate road)","OPTA",null,null,null,null,null,null,null,null,null,null,null,null,null,"MOD 2.0 URBAN","MO2U",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,"Optimum (minor road)","OPTM",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Terraled Mini MX1","MX1",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,"Optispan (main road)","OPTS",null,null,null,null,null,null,null,null,null,null,null,null,null,"Nath - S","NATH",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,"PFL 540-SE","P540",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Ignis 1-Peds Cross","NG1C",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,"P860","P860",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Ignis 1 -Veh","NG1V",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,"P861","P861",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Ignis 2","NG2V",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,"P863 (16 LED)","P863",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED NXT-12S","NX12",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,"CRUX PLUS [NB-SL-CRUX-P] Peds","PCRX",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED NXT-24S - 4AH","NX24",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,"Pedestrian GL700","PGL7",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED NXT-36S","NX36",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,"LED PIANO 1","PNO1",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED NXT-48M","NX48",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,"LED PIANO 2","PNO2",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED NXT-60M","NX60",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,"Pole Top Light","PTL",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED NXT-72M","NX72",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,"Terraled Mini PX1","PX1",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED NXT- C","NXTC",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,"Cobra","R47",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED NXT - M","NXTM",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,"Roadster","RD",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED NXT- S","NXTS",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,"Roadster Forward Throw","RDF",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED PFL 540-SE","P540",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,"EDGE Round","RND",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED P852","P852",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,"Rama / Radiata","RR",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED P860","P860",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,"SastaLED - Size 1 SL99234 (Small)","SAS1",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED P861","P861",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,"SastaLED - Size 2 SL99234 (Large)","SAS2",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED P863 (16 LED)","P863",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,"Pedestrian spot light","SL",null,null,null,null,null,null,null,null,null,null,null,null,null,"Palmerston","PALM",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,"EDGE Square","SQR",null,null,null,null,null,null,null,null,null,null,null,null,null,"CRUX PLUS [NB-SL-CRUX-P] Peds","PCRX",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,"Satellite SAT-24S","ST24",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED PIANO 1","PNO1",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,"Satellite SAT-48S","ST48",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED PIANO 2","PNO2",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,"Satellite SAT-72M","ST72",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Terraled Mini PX1","PX1",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,"Satellite SAT-96M","ST96",null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadcharm BRP471","R471",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,"Stela+ (gen2)","STEL",null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadcharm BRP472","R472",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,"StreetLED","STL",null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadcharm BRP711","R711",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,"Stratos N 6M","STRA",null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadcharm BRP712","R712",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,"Tango","TANG",null,null,null,null,null,null,null,null,null,null,null,null,null,"RAZO-M","RAZM",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,"Tasman- Peds","TASP",null,null,null,null,null,null,null,null,null,null,null,null,null,"RAZO-S","RAZS",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,"Tasman- Veh","TASV",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED EDGE Round","RND",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,"TECEO 1","TCO1",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium vapour SON 100W","S100",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,"TECEO 2","TCO2",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium vapour SON 100W,tubular","S10T",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,"StreetLED Aero TMC1 (aeroscreen only)","TMC1",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium vapour SON 150W","S150",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,"StreetLED Aero TMC2 (aeroscreen only)","TMC2",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium vapour SON 150W,tubular","S15T",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,"I-Tron 1","TON1",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium vapour SON 250W","S250",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,"I-Tron Zero OC6","TON6",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium vapour SON 250W,tubular","S25T",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,"I-Tron Zero OC8","TON8",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium vapour SON 400W","S400",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,"TransLEDer- Peds","TRN1",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium vapour SON 400W,tubular","S40T",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,"TransLEDer-Veh","TRN2",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium vapour SON 50W","S50",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,"WAC415 150 underbridge","UB15",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium vapour SON 50W,tubular","S50T",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,"PR525 250 underbridge","UB25",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium vapour SON 70W","S70",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,"Urban","UR",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium vapour SON 70W - E","S70E",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,"WE-EF VFL530","V530",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium vapour SON 70W - I","S70I",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,"WE-EF VFL540","V540",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium vapour SON 70W,tubular","S70T",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,"P862 (32/64 LED)","V862",null,null,null,null,null,null,null,null,null,null,null,null,null,"SastaLED Size 1 (Small)","SAS1",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,"P863 (16/32 LED)","V863",null,null,null,null,null,null,null,null,null,null,null,null,null,"SastaLED Size 2 (Large)","SAS2",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,"CRUX PLUS [NB-SL-CRUX-P] Veh","VCRX",null,null,null,null,null,null,null,null,null,null,null,null,null,"LPS 26W Solar Light Lamp","SL26",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,"Warp 9 LED","WARP",null,null,null,null,null,null,null,null,null,null,null,null,null,"HPS 65W Solar Light","SL65",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,"LED Woody Street","WOOD",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED EDGE Square","SQR",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,"Wow Large (807 x 505)","WOWL",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Satellite SAT-24S","ST24",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,"Wow Mini (620 x 307)","WOWM",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Satellite SAT-48S","ST48",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,"Wow Small (758 x 415)","WOWS",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Satellite SAT-72M","ST72",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,"(P1) XSP1 T2 Med 52","XSP1",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Satellite SAT-96M","ST96",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,"(P2) XSP2 T2 Med 102","XSP2",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Stela+ (gen2)","STEL",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,"XSP1 3M","XSP3",null,null,null,null,null,null,null,null,null,null,null,null,null,"LED StreetLED","STL",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,"Stela+ GEN2","STLA",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,"Mini Stork","STOR",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,"LED Stratos N 6M","STRA",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,"150w Twinarc","T150",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,"250w Twinarc","T250",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,"400w Twinarc","T400",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,"LED Tasman- Peds","TASP",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,"LED Tasman- Veh","TASV",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,"LED TECEO 1 XPG2","TEC1",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,"LED TECEO 2 XP - G2","TEC2",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,"LED TECEO 1 XP - G3","TECG",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,"LED TECEO 1 XPL","TECL",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,"LED TECEO 2 XP-G3","TEG3",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,"Tornado ES 24W","TES",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,"Tasman - L","TMAL",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,"Tasman - S","TMAS",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,"StreetLED Aero TMC1 (aeroscreen only)","TMC1",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,"StreetLED Aero TMC2 (aeroscreen only)","TMC2",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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Terraled Mini XPG2","TMG2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Terraled Mini XPG3","TMG3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tasman - LO","TMLO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Terraled Mini Nichia","TMN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Terraled Mini Osram","TMOS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tasman - SO","TMSO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I-Tron Zero OC6","TON0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED I-Tron 1 OC8","TON1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED I-Tron Zero OC6","TON6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED I-Tron Zero OC8","TON8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED TransLEDer-A-1","TRA1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED TransLEDer-A-3","TRA3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED TransLEDer-A-4","TRA4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED TransLEDer-B-1","TRB1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED TransLEDer-B-2","TRB2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED TransLEDer-B-3","TRB3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED TransLEDer-B-4","TRB4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED TransLEDer-C-4","TRC4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED TransLEDer- Peds","TRN1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED TransLEDer-Veh","TRN2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V3630-0.1Cu","V363"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED WE-EF VFL530","V530"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED WE-EF VFL540","V540"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED P862 (32/64 LED)","V862"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED P863 (16/32 LED)","V863"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CRUX PLUS [NB-SL-CRUX-P] Veh","VCRX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warp 9 LED","WARP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Woody Street","WOOD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Wow","WOW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wow Large (807 x 505)","WOWL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wow Mini (620 x 307)","WOWM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wow Small (758 x 415)","WOWS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium vapour SOX 135W","X135"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sodium vapour SOX 90W","X90"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XSP1 HO Series D","XP1H"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED XSP2 Series C","XP2C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XSP2 HO Series D","XP2H"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED XSP1","XSP1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED XSP2","XSP2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LED XSP1 3M","XSP3"]