{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Drainage","Lookups"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":44,"comments":1,"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":"Drainage","index":0,"n_rows":48,"n_cols":58,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["15f221f1-c15e-4d8e-a679-81fade5c4405_road_id","sh-rs-d","15f221f1-c15e-4d8e-a679-81fade5c4404_location","03fd9489-d2cf-46fe-8a3d-df8d8684ffc2_drain_type_desc","03fd9489-d2cf-46fe-8a3d-df8d8684ffc2_drain_type","95030121-589c-4c9f-8caa-7521d16addaa_drain_material_desc","95030121-589c-4c9f-8caa-7521d16addaa_drain_material","b39e6e6b-35b0-4ebc-b62d-2448128df737_drain_shape_desc","b39e6e6b-35b0-4ebc-b62d-2448128df737_drain_shape","6bee2220-58e0-49b7-949f-7a5087e839f8_wway","50d682b0-ec20-428a-a413-863a444c981a_fish_passage","7d67dbe2-3cb8-41a3-b580-336dd9e7b5c2_inlet_desc","7d67dbe2-3cb8-41a3-b580-336dd9e7b5c2_inlet","65c126ef-7a28-45db-b4ca-995881798aaa_outlet_desc","65c126ef-7a28-45db-b4ca-995881798aaa_outlet","8907c8c0-e25e-4d39-9db0-e88cf811c9e8_culv_number","9548ef9f-60dc-4c7e-80d6-3ff38bc8d4f2_drain_culvert_desc","9548ef9f-60dc-4c7e-80d6-3ff38bc8d4f2_drain_culvert","351eab06-7f49-4622-ba52-25490f41cb1d_drain_lining_desc","351eab06-7f49-4622-ba52-25490f41cb1d_drain_lining","b4929fed-e46b-495c-aa4c-7ad1c49dde57_flow_direction_desc","b4929fed-e46b-495c-aa4c-7ad1c49dde57_flow_direction","9e7d61fb-3010-4218-b175-ccca9e3f7ca5_drain_size","ec4c549d-6ae9-4a57-9bb2-fa7f0ceee11f_cul_width","140996a5-fdf8-4ff5-83f8-99d0e6e36166_cul_area","80a09201-6c54-4833-9e2a-7c589b59fce4_offset_side_desc","80a09201-6c54-4833-9e2a-7c589b59fce4_offset_side","2590b789-2db9-40d7-92d4-7db519625824_offset","c6d64b78-32df-42aa-bd40-f56cb584a31d_drain_length","ac025d04-0d26-47f2-97c4-11ec755cc5cc_drain_size","f606afb6-adae-4c10-b94d-7393f328402a_construct_date","b304cf15-c35f-4c95-baed-3bc79f6fa858_asset_owner_desc","b304cf15-c35f-4c95-baed-3bc79f6fa858_asset_owner","f1953950-ba12-40cd-a4cc-1ae90861f9f7_risk_likelihood_desc","f1953950-ba12-40cd-a4cc-1ae90861f9f7_risk_likelihood","84c1a80d-7421-4174-b1a8-d018945701bf_risk_consequence_desc","84c1a80d-7421-4174-b1a8-d018945701bf_risk_consequence","74cfa49b-7f06-4c08-9a15-ff9650a2ff28_risk_desc","74cfa49b-7f06-4c08-9a15-ff9650a2ff28_risk","74a79bcf-56ae-442b-9e5e-719e69591e02_rul_reset_desc","74a79bcf-56ae-442b-9e5e-719e69591e02_rul_reset","a25d789a-1014-4498-8bb1-b54bb6862985_use_default_rc_desc","a25d789a-1014-4498-8bb1-b54bb6862985_use_default_rc",null,null,"17772289-5fde-412b-8cf0-d2fa31adbdf3_condition_desc","17772289-5fde-412b-8cf0-d2fa31adbdf3_condition","d517dc52-47dd-4cd7-ae0a-137fec701ec3_condition_date","cdd1315a-1ebe-447d-902c-641a3433c6b6_collect_name_desc","cdd1315a-1ebe-447d-902c-641a3433c6b6_collect_name","910a8970-7e16-4ed9-82e6-f2161c784cab_drain_id","05f3edc5-ef4a-4c2b-8c69-11aaee527be3_notes","f2228e44-7888-431a-ac26-01937f414a19_not_ramm_field_in_replace_reason_desc","f2228e44-7888-431a-ac26-01937f414a19_not_ramm_field_in_replace_reason","a132f9d2-2dc4-4903-baa0-332bee7a6125_not_ramm_field_prior_id","5eb92905-cbd4-439f-839e-6f17f73d36af_not_ramm_field_replace_date","b6158464-96a0-47f7-85fd-0e6000bd8193_not_ramm_field_rep_replace_reason_desc","b6158464-96a0-47f7-85fd-0e6000bd8193_not_ramm_field_rep_replace_reason"]
["road_id","sh-rs-d","location","drain_type_desc","drain_type","drain_material_desc","drain_material","drain_shape_desc","drain_shape","wway","fish_passage","inlet_desc","inlet","outlet_desc","outlet","culv_number","drain_culvert_desc","drain_culvert","drain_lining_desc","drain_lining","flow_direction_desc","flow_direction","drain_size","cul_width","cul_area","offset_side_desc","offset_side","offset","drain_length","drain_size","construct_date","asset_owner_desc","asset_owner","risk_likelihood_desc","risk_likelihood","risk_consequence_desc","risk_consequence","risk_desc","risk","rul_reset_desc","rul_reset","use_default_rc_desc","use_default_rc",null,null,"condition_desc","condition","condition_date","collect_name_desc","collect_name","drain_id","notes","not_ramm_field_in_replace_reason_desc","not_ramm_field_in_replace_reason","not_ramm_field_prior_id","not_ramm_field_replace_date","not_ramm_field_rep_replace_reason_desc","not_ramm_field_rep_replace_reason"]
["Road Id ","SH-RS-D (e.g. 016-0000-B) letter must be uppercase and include leading 0","Location (m)","Drain Type Description","Drain Type","Material Description","Drain Material","Drain Shape Description","Drain Shape","Waterway","Fish Passage (must populate with Y or N as uppercase)","Inlet Description","Inlet","Outlet Description","Outlet","Culv No.","Culvert - Type Description","Culvert - Type","Culvert - Drain Lining Description","Culvert - Drain Lining","Flow Direction Description","Flow Direction","Culvert - Drain Size","Cul Width","Cul Area","Side Description","Side","Offset","Length (m)","Depth","Construct Date (dd/mm/yyyy) Must include leading 0","Asset Owner Description","Asset Owner","Risk Likelihood Description","Risk Likelihood","Risk Consequence Description","Risk Consequence","Risk Description","Risk","RUL Reset Description","RUL Reset","Use Default RC Description","Use Default RC","Work origin","Work category","Condition Description","Condition","Condition date (dd/mm/yyyy) Must include leading 0","Organisation Description","Organisation","Drain ID","Comments (if required)","Install Reason Description","Install Reason","Prior ID","Existing Asset - Replace Date (dd/mm/yyyy) Must include leading 0","Existing Asset - Replace Reason Description","Existing Asset - Replace Reason"]
[{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&B4&\"/\"&C4&\"&xml=true\"),\"/lrms/id_road\")","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"IF(D4=\"\",\"\",VLOOKUP(D4,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F4=\"\",\"\",VLOOKUP(F4,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H4=\"\",\"\",VLOOKUP(H4,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L4=\"\",\"\",VLOOKUP(L4,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N4=\"\",\"\",VLOOKUP(N4,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q4=\"\",\"\",VLOOKUP(Q4,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S4=\"\",\"\",VLOOKUP(S4,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U4=\"\",\"\",VLOOKUP(U4,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z4=\"\",\"\",VLOOKUP(Z4,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF4=\"\",\"\",VLOOKUP(AF4,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH4=\"\",\"\",VLOOKUP(AH4,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ4=\"\",\"\",VLOOKUP(AJ4,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT4=\"\",\"\",VLOOKUP(AT4,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW4=\"\",\"\",VLOOKUP(AW4,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA4=\"\",\"\",VLOOKUP(BA4,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE4=\"\",\"\",VLOOKUP(BE4,replace_reason[],2,FALSE))","v":""}]
[{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&B5&\"/\"&C5&\"&xml=true\"),\"/lrms/id_road\")","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"IF(D5=\"\",\"\",VLOOKUP(D5,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F5=\"\",\"\",VLOOKUP(F5,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H5=\"\",\"\",VLOOKUP(H5,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L5=\"\",\"\",VLOOKUP(L5,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N5=\"\",\"\",VLOOKUP(N5,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q5=\"\",\"\",VLOOKUP(Q5,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S5=\"\",\"\",VLOOKUP(S5,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U5=\"\",\"\",VLOOKUP(U5,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z5=\"\",\"\",VLOOKUP(Z5,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF5=\"\",\"\",VLOOKUP(AF5,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH5=\"\",\"\",VLOOKUP(AH5,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ5=\"\",\"\",VLOOKUP(AJ5,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT5=\"\",\"\",VLOOKUP(AT5,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW5=\"\",\"\",VLOOKUP(AW5,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA5=\"\",\"\",VLOOKUP(BA5,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE5=\"\",\"\",VLOOKUP(BE5,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D6=\"\",\"\",VLOOKUP(D6,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F6=\"\",\"\",VLOOKUP(F6,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H6=\"\",\"\",VLOOKUP(H6,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L6=\"\",\"\",VLOOKUP(L6,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N6=\"\",\"\",VLOOKUP(N6,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q6=\"\",\"\",VLOOKUP(Q6,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S6=\"\",\"\",VLOOKUP(S6,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U6=\"\",\"\",VLOOKUP(U6,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z6=\"\",\"\",VLOOKUP(Z6,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF6=\"\",\"\",VLOOKUP(AF6,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH6=\"\",\"\",VLOOKUP(AH6,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ6=\"\",\"\",VLOOKUP(AJ6,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT6=\"\",\"\",VLOOKUP(AT6,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW6=\"\",\"\",VLOOKUP(AW6,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA6=\"\",\"\",VLOOKUP(BA6,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE6=\"\",\"\",VLOOKUP(BE6,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D7=\"\",\"\",VLOOKUP(D7,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F7=\"\",\"\",VLOOKUP(F7,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H7=\"\",\"\",VLOOKUP(H7,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L7=\"\",\"\",VLOOKUP(L7,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N7=\"\",\"\",VLOOKUP(N7,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q7=\"\",\"\",VLOOKUP(Q7,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S7=\"\",\"\",VLOOKUP(S7,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U7=\"\",\"\",VLOOKUP(U7,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z7=\"\",\"\",VLOOKUP(Z7,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF7=\"\",\"\",VLOOKUP(AF7,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH7=\"\",\"\",VLOOKUP(AH7,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ7=\"\",\"\",VLOOKUP(AJ7,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT7=\"\",\"\",VLOOKUP(AT7,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW7=\"\",\"\",VLOOKUP(AW7,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA7=\"\",\"\",VLOOKUP(BA7,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE7=\"\",\"\",VLOOKUP(BE7,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D8=\"\",\"\",VLOOKUP(D8,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F8=\"\",\"\",VLOOKUP(F8,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H8=\"\",\"\",VLOOKUP(H8,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L8=\"\",\"\",VLOOKUP(L8,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N8=\"\",\"\",VLOOKUP(N8,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q8=\"\",\"\",VLOOKUP(Q8,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S8=\"\",\"\",VLOOKUP(S8,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U8=\"\",\"\",VLOOKUP(U8,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z8=\"\",\"\",VLOOKUP(Z8,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF8=\"\",\"\",VLOOKUP(AF8,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH8=\"\",\"\",VLOOKUP(AH8,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ8=\"\",\"\",VLOOKUP(AJ8,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT8=\"\",\"\",VLOOKUP(AT8,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW8=\"\",\"\",VLOOKUP(AW8,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA8=\"\",\"\",VLOOKUP(BA8,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE8=\"\",\"\",VLOOKUP(BE8,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D9=\"\",\"\",VLOOKUP(D9,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F9=\"\",\"\",VLOOKUP(F9,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H9=\"\",\"\",VLOOKUP(H9,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L9=\"\",\"\",VLOOKUP(L9,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N9=\"\",\"\",VLOOKUP(N9,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q9=\"\",\"\",VLOOKUP(Q9,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S9=\"\",\"\",VLOOKUP(S9,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U9=\"\",\"\",VLOOKUP(U9,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z9=\"\",\"\",VLOOKUP(Z9,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF9=\"\",\"\",VLOOKUP(AF9,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH9=\"\",\"\",VLOOKUP(AH9,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ9=\"\",\"\",VLOOKUP(AJ9,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT9=\"\",\"\",VLOOKUP(AT9,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW9=\"\",\"\",VLOOKUP(AW9,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA9=\"\",\"\",VLOOKUP(BA9,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE9=\"\",\"\",VLOOKUP(BE9,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D10=\"\",\"\",VLOOKUP(D10,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F10=\"\",\"\",VLOOKUP(F10,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H10=\"\",\"\",VLOOKUP(H10,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L10=\"\",\"\",VLOOKUP(L10,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N10=\"\",\"\",VLOOKUP(N10,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q10=\"\",\"\",VLOOKUP(Q10,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S10=\"\",\"\",VLOOKUP(S10,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U10=\"\",\"\",VLOOKUP(U10,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z10=\"\",\"\",VLOOKUP(Z10,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF10=\"\",\"\",VLOOKUP(AF10,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH10=\"\",\"\",VLOOKUP(AH10,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ10=\"\",\"\",VLOOKUP(AJ10,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT10=\"\",\"\",VLOOKUP(AT10,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW10=\"\",\"\",VLOOKUP(AW10,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA10=\"\",\"\",VLOOKUP(BA10,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE10=\"\",\"\",VLOOKUP(BE10,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D11=\"\",\"\",VLOOKUP(D11,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F11=\"\",\"\",VLOOKUP(F11,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H11=\"\",\"\",VLOOKUP(H11,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L11=\"\",\"\",VLOOKUP(L11,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N11=\"\",\"\",VLOOKUP(N11,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q11=\"\",\"\",VLOOKUP(Q11,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S11=\"\",\"\",VLOOKUP(S11,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U11=\"\",\"\",VLOOKUP(U11,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z11=\"\",\"\",VLOOKUP(Z11,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF11=\"\",\"\",VLOOKUP(AF11,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH11=\"\",\"\",VLOOKUP(AH11,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ11=\"\",\"\",VLOOKUP(AJ11,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT11=\"\",\"\",VLOOKUP(AT11,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW11=\"\",\"\",VLOOKUP(AW11,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA11=\"\",\"\",VLOOKUP(BA11,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE11=\"\",\"\",VLOOKUP(BE11,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D12=\"\",\"\",VLOOKUP(D12,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F12=\"\",\"\",VLOOKUP(F12,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H12=\"\",\"\",VLOOKUP(H12,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L12=\"\",\"\",VLOOKUP(L12,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N12=\"\",\"\",VLOOKUP(N12,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q12=\"\",\"\",VLOOKUP(Q12,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S12=\"\",\"\",VLOOKUP(S12,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U12=\"\",\"\",VLOOKUP(U12,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z12=\"\",\"\",VLOOKUP(Z12,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF12=\"\",\"\",VLOOKUP(AF12,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH12=\"\",\"\",VLOOKUP(AH12,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ12=\"\",\"\",VLOOKUP(AJ12,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT12=\"\",\"\",VLOOKUP(AT12,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW12=\"\",\"\",VLOOKUP(AW12,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA12=\"\",\"\",VLOOKUP(BA12,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE12=\"\",\"\",VLOOKUP(BE12,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D13=\"\",\"\",VLOOKUP(D13,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F13=\"\",\"\",VLOOKUP(F13,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H13=\"\",\"\",VLOOKUP(H13,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L13=\"\",\"\",VLOOKUP(L13,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N13=\"\",\"\",VLOOKUP(N13,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q13=\"\",\"\",VLOOKUP(Q13,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S13=\"\",\"\",VLOOKUP(S13,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U13=\"\",\"\",VLOOKUP(U13,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z13=\"\",\"\",VLOOKUP(Z13,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF13=\"\",\"\",VLOOKUP(AF13,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH13=\"\",\"\",VLOOKUP(AH13,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ13=\"\",\"\",VLOOKUP(AJ13,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT13=\"\",\"\",VLOOKUP(AT13,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW13=\"\",\"\",VLOOKUP(AW13,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA13=\"\",\"\",VLOOKUP(BA13,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE13=\"\",\"\",VLOOKUP(BE13,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D14=\"\",\"\",VLOOKUP(D14,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F14=\"\",\"\",VLOOKUP(F14,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H14=\"\",\"\",VLOOKUP(H14,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L14=\"\",\"\",VLOOKUP(L14,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N14=\"\",\"\",VLOOKUP(N14,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q14=\"\",\"\",VLOOKUP(Q14,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S14=\"\",\"\",VLOOKUP(S14,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U14=\"\",\"\",VLOOKUP(U14,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z14=\"\",\"\",VLOOKUP(Z14,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF14=\"\",\"\",VLOOKUP(AF14,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH14=\"\",\"\",VLOOKUP(AH14,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ14=\"\",\"\",VLOOKUP(AJ14,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT14=\"\",\"\",VLOOKUP(AT14,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW14=\"\",\"\",VLOOKUP(AW14,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA14=\"\",\"\",VLOOKUP(BA14,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE14=\"\",\"\",VLOOKUP(BE14,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F15=\"\",\"\",VLOOKUP(F15,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H15=\"\",\"\",VLOOKUP(H15,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L15=\"\",\"\",VLOOKUP(L15,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N15=\"\",\"\",VLOOKUP(N15,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q15=\"\",\"\",VLOOKUP(Q15,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S15=\"\",\"\",VLOOKUP(S15,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U15=\"\",\"\",VLOOKUP(U15,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z15=\"\",\"\",VLOOKUP(Z15,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF15=\"\",\"\",VLOOKUP(AF15,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH15=\"\",\"\",VLOOKUP(AH15,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ15=\"\",\"\",VLOOKUP(AJ15,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT15=\"\",\"\",VLOOKUP(AT15,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW15=\"\",\"\",VLOOKUP(AW15,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA15=\"\",\"\",VLOOKUP(BA15,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE15=\"\",\"\",VLOOKUP(BE15,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D16=\"\",\"\",VLOOKUP(D16,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F16=\"\",\"\",VLOOKUP(F16,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H16=\"\",\"\",VLOOKUP(H16,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L16=\"\",\"\",VLOOKUP(L16,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N16=\"\",\"\",VLOOKUP(N16,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q16=\"\",\"\",VLOOKUP(Q16,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S16=\"\",\"\",VLOOKUP(S16,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U16=\"\",\"\",VLOOKUP(U16,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z16=\"\",\"\",VLOOKUP(Z16,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF16=\"\",\"\",VLOOKUP(AF16,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH16=\"\",\"\",VLOOKUP(AH16,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ16=\"\",\"\",VLOOKUP(AJ16,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT16=\"\",\"\",VLOOKUP(AT16,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW16=\"\",\"\",VLOOKUP(AW16,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA16=\"\",\"\",VLOOKUP(BA16,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE16=\"\",\"\",VLOOKUP(BE16,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D17=\"\",\"\",VLOOKUP(D17,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F17=\"\",\"\",VLOOKUP(F17,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H17=\"\",\"\",VLOOKUP(H17,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L17=\"\",\"\",VLOOKUP(L17,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N17=\"\",\"\",VLOOKUP(N17,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q17=\"\",\"\",VLOOKUP(Q17,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S17=\"\",\"\",VLOOKUP(S17,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U17=\"\",\"\",VLOOKUP(U17,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z17=\"\",\"\",VLOOKUP(Z17,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF17=\"\",\"\",VLOOKUP(AF17,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH17=\"\",\"\",VLOOKUP(AH17,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ17=\"\",\"\",VLOOKUP(AJ17,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT17=\"\",\"\",VLOOKUP(AT17,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW17=\"\",\"\",VLOOKUP(AW17,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA17=\"\",\"\",VLOOKUP(BA17,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE17=\"\",\"\",VLOOKUP(BE17,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D18=\"\",\"\",VLOOKUP(D18,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F18=\"\",\"\",VLOOKUP(F18,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H18=\"\",\"\",VLOOKUP(H18,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L18=\"\",\"\",VLOOKUP(L18,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N18=\"\",\"\",VLOOKUP(N18,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q18=\"\",\"\",VLOOKUP(Q18,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S18=\"\",\"\",VLOOKUP(S18,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U18=\"\",\"\",VLOOKUP(U18,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z18=\"\",\"\",VLOOKUP(Z18,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF18=\"\",\"\",VLOOKUP(AF18,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH18=\"\",\"\",VLOOKUP(AH18,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ18=\"\",\"\",VLOOKUP(AJ18,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT18=\"\",\"\",VLOOKUP(AT18,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW18=\"\",\"\",VLOOKUP(AW18,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA18=\"\",\"\",VLOOKUP(BA18,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE18=\"\",\"\",VLOOKUP(BE18,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D19=\"\",\"\",VLOOKUP(D19,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F19=\"\",\"\",VLOOKUP(F19,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H19=\"\",\"\",VLOOKUP(H19,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L19=\"\",\"\",VLOOKUP(L19,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N19=\"\",\"\",VLOOKUP(N19,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q19=\"\",\"\",VLOOKUP(Q19,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S19=\"\",\"\",VLOOKUP(S19,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U19=\"\",\"\",VLOOKUP(U19,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z19=\"\",\"\",VLOOKUP(Z19,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF19=\"\",\"\",VLOOKUP(AF19,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH19=\"\",\"\",VLOOKUP(AH19,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ19=\"\",\"\",VLOOKUP(AJ19,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT19=\"\",\"\",VLOOKUP(AT19,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW19=\"\",\"\",VLOOKUP(AW19,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA19=\"\",\"\",VLOOKUP(BA19,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE19=\"\",\"\",VLOOKUP(BE19,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D20=\"\",\"\",VLOOKUP(D20,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F20=\"\",\"\",VLOOKUP(F20,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H20=\"\",\"\",VLOOKUP(H20,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L20=\"\",\"\",VLOOKUP(L20,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N20=\"\",\"\",VLOOKUP(N20,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q20=\"\",\"\",VLOOKUP(Q20,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S20=\"\",\"\",VLOOKUP(S20,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U20=\"\",\"\",VLOOKUP(U20,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z20=\"\",\"\",VLOOKUP(Z20,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF20=\"\",\"\",VLOOKUP(AF20,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH20=\"\",\"\",VLOOKUP(AH20,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ20=\"\",\"\",VLOOKUP(AJ20,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT20=\"\",\"\",VLOOKUP(AT20,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW20=\"\",\"\",VLOOKUP(AW20,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA20=\"\",\"\",VLOOKUP(BA20,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE20=\"\",\"\",VLOOKUP(BE20,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D21=\"\",\"\",VLOOKUP(D21,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F21=\"\",\"\",VLOOKUP(F21,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H21=\"\",\"\",VLOOKUP(H21,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L21=\"\",\"\",VLOOKUP(L21,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N21=\"\",\"\",VLOOKUP(N21,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q21=\"\",\"\",VLOOKUP(Q21,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S21=\"\",\"\",VLOOKUP(S21,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U21=\"\",\"\",VLOOKUP(U21,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z21=\"\",\"\",VLOOKUP(Z21,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF21=\"\",\"\",VLOOKUP(AF21,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH21=\"\",\"\",VLOOKUP(AH21,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ21=\"\",\"\",VLOOKUP(AJ21,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT21=\"\",\"\",VLOOKUP(AT21,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW21=\"\",\"\",VLOOKUP(AW21,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA21=\"\",\"\",VLOOKUP(BA21,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE21=\"\",\"\",VLOOKUP(BE21,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D22=\"\",\"\",VLOOKUP(D22,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F22=\"\",\"\",VLOOKUP(F22,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H22=\"\",\"\",VLOOKUP(H22,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L22=\"\",\"\",VLOOKUP(L22,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N22=\"\",\"\",VLOOKUP(N22,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q22=\"\",\"\",VLOOKUP(Q22,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S22=\"\",\"\",VLOOKUP(S22,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U22=\"\",\"\",VLOOKUP(U22,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z22=\"\",\"\",VLOOKUP(Z22,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF22=\"\",\"\",VLOOKUP(AF22,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH22=\"\",\"\",VLOOKUP(AH22,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ22=\"\",\"\",VLOOKUP(AJ22,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT22=\"\",\"\",VLOOKUP(AT22,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW22=\"\",\"\",VLOOKUP(AW22,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA22=\"\",\"\",VLOOKUP(BA22,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE22=\"\",\"\",VLOOKUP(BE22,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D23=\"\",\"\",VLOOKUP(D23,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F23=\"\",\"\",VLOOKUP(F23,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H23=\"\",\"\",VLOOKUP(H23,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L23=\"\",\"\",VLOOKUP(L23,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N23=\"\",\"\",VLOOKUP(N23,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q23=\"\",\"\",VLOOKUP(Q23,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S23=\"\",\"\",VLOOKUP(S23,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U23=\"\",\"\",VLOOKUP(U23,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z23=\"\",\"\",VLOOKUP(Z23,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF23=\"\",\"\",VLOOKUP(AF23,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH23=\"\",\"\",VLOOKUP(AH23,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ23=\"\",\"\",VLOOKUP(AJ23,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT23=\"\",\"\",VLOOKUP(AT23,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW23=\"\",\"\",VLOOKUP(AW23,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA23=\"\",\"\",VLOOKUP(BA23,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE23=\"\",\"\",VLOOKUP(BE23,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D24=\"\",\"\",VLOOKUP(D24,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F24=\"\",\"\",VLOOKUP(F24,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H24=\"\",\"\",VLOOKUP(H24,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L24=\"\",\"\",VLOOKUP(L24,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N24=\"\",\"\",VLOOKUP(N24,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q24=\"\",\"\",VLOOKUP(Q24,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S24=\"\",\"\",VLOOKUP(S24,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U24=\"\",\"\",VLOOKUP(U24,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z24=\"\",\"\",VLOOKUP(Z24,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF24=\"\",\"\",VLOOKUP(AF24,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH24=\"\",\"\",VLOOKUP(AH24,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ24=\"\",\"\",VLOOKUP(AJ24,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT24=\"\",\"\",VLOOKUP(AT24,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW24=\"\",\"\",VLOOKUP(AW24,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA24=\"\",\"\",VLOOKUP(BA24,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE24=\"\",\"\",VLOOKUP(BE24,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D25=\"\",\"\",VLOOKUP(D25,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F25=\"\",\"\",VLOOKUP(F25,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H25=\"\",\"\",VLOOKUP(H25,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L25=\"\",\"\",VLOOKUP(L25,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N25=\"\",\"\",VLOOKUP(N25,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q25=\"\",\"\",VLOOKUP(Q25,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S25=\"\",\"\",VLOOKUP(S25,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U25=\"\",\"\",VLOOKUP(U25,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z25=\"\",\"\",VLOOKUP(Z25,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF25=\"\",\"\",VLOOKUP(AF25,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH25=\"\",\"\",VLOOKUP(AH25,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ25=\"\",\"\",VLOOKUP(AJ25,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT25=\"\",\"\",VLOOKUP(AT25,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW25=\"\",\"\",VLOOKUP(AW25,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA25=\"\",\"\",VLOOKUP(BA25,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE25=\"\",\"\",VLOOKUP(BE25,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D26=\"\",\"\",VLOOKUP(D26,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F26=\"\",\"\",VLOOKUP(F26,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H26=\"\",\"\",VLOOKUP(H26,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L26=\"\",\"\",VLOOKUP(L26,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N26=\"\",\"\",VLOOKUP(N26,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q26=\"\",\"\",VLOOKUP(Q26,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S26=\"\",\"\",VLOOKUP(S26,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U26=\"\",\"\",VLOOKUP(U26,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z26=\"\",\"\",VLOOKUP(Z26,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF26=\"\",\"\",VLOOKUP(AF26,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH26=\"\",\"\",VLOOKUP(AH26,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ26=\"\",\"\",VLOOKUP(AJ26,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT26=\"\",\"\",VLOOKUP(AT26,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW26=\"\",\"\",VLOOKUP(AW26,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA26=\"\",\"\",VLOOKUP(BA26,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE26=\"\",\"\",VLOOKUP(BE26,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D27=\"\",\"\",VLOOKUP(D27,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F27=\"\",\"\",VLOOKUP(F27,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H27=\"\",\"\",VLOOKUP(H27,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L27=\"\",\"\",VLOOKUP(L27,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N27=\"\",\"\",VLOOKUP(N27,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q27=\"\",\"\",VLOOKUP(Q27,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S27=\"\",\"\",VLOOKUP(S27,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U27=\"\",\"\",VLOOKUP(U27,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z27=\"\",\"\",VLOOKUP(Z27,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF27=\"\",\"\",VLOOKUP(AF27,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH27=\"\",\"\",VLOOKUP(AH27,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ27=\"\",\"\",VLOOKUP(AJ27,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT27=\"\",\"\",VLOOKUP(AT27,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW27=\"\",\"\",VLOOKUP(AW27,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA27=\"\",\"\",VLOOKUP(BA27,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE27=\"\",\"\",VLOOKUP(BE27,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D28=\"\",\"\",VLOOKUP(D28,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F28=\"\",\"\",VLOOKUP(F28,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H28=\"\",\"\",VLOOKUP(H28,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L28=\"\",\"\",VLOOKUP(L28,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N28=\"\",\"\",VLOOKUP(N28,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q28=\"\",\"\",VLOOKUP(Q28,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S28=\"\",\"\",VLOOKUP(S28,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U28=\"\",\"\",VLOOKUP(U28,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z28=\"\",\"\",VLOOKUP(Z28,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF28=\"\",\"\",VLOOKUP(AF28,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH28=\"\",\"\",VLOOKUP(AH28,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ28=\"\",\"\",VLOOKUP(AJ28,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT28=\"\",\"\",VLOOKUP(AT28,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW28=\"\",\"\",VLOOKUP(AW28,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA28=\"\",\"\",VLOOKUP(BA28,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE28=\"\",\"\",VLOOKUP(BE28,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D29=\"\",\"\",VLOOKUP(D29,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F29=\"\",\"\",VLOOKUP(F29,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H29=\"\",\"\",VLOOKUP(H29,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L29=\"\",\"\",VLOOKUP(L29,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N29=\"\",\"\",VLOOKUP(N29,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q29=\"\",\"\",VLOOKUP(Q29,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S29=\"\",\"\",VLOOKUP(S29,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U29=\"\",\"\",VLOOKUP(U29,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z29=\"\",\"\",VLOOKUP(Z29,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF29=\"\",\"\",VLOOKUP(AF29,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH29=\"\",\"\",VLOOKUP(AH29,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ29=\"\",\"\",VLOOKUP(AJ29,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT29=\"\",\"\",VLOOKUP(AT29,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW29=\"\",\"\",VLOOKUP(AW29,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA29=\"\",\"\",VLOOKUP(BA29,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE29=\"\",\"\",VLOOKUP(BE29,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F30=\"\",\"\",VLOOKUP(F30,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H30=\"\",\"\",VLOOKUP(H30,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L30=\"\",\"\",VLOOKUP(L30,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N30=\"\",\"\",VLOOKUP(N30,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q30=\"\",\"\",VLOOKUP(Q30,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S30=\"\",\"\",VLOOKUP(S30,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U30=\"\",\"\",VLOOKUP(U30,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z30=\"\",\"\",VLOOKUP(Z30,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF30=\"\",\"\",VLOOKUP(AF30,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH30=\"\",\"\",VLOOKUP(AH30,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ30=\"\",\"\",VLOOKUP(AJ30,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT30=\"\",\"\",VLOOKUP(AT30,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW30=\"\",\"\",VLOOKUP(AW30,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA30=\"\",\"\",VLOOKUP(BA30,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE30=\"\",\"\",VLOOKUP(BE30,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D31=\"\",\"\",VLOOKUP(D31,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F31=\"\",\"\",VLOOKUP(F31,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H31=\"\",\"\",VLOOKUP(H31,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L31=\"\",\"\",VLOOKUP(L31,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N31=\"\",\"\",VLOOKUP(N31,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q31=\"\",\"\",VLOOKUP(Q31,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S31=\"\",\"\",VLOOKUP(S31,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U31=\"\",\"\",VLOOKUP(U31,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z31=\"\",\"\",VLOOKUP(Z31,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF31=\"\",\"\",VLOOKUP(AF31,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH31=\"\",\"\",VLOOKUP(AH31,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ31=\"\",\"\",VLOOKUP(AJ31,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT31=\"\",\"\",VLOOKUP(AT31,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW31=\"\",\"\",VLOOKUP(AW31,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA31=\"\",\"\",VLOOKUP(BA31,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE31=\"\",\"\",VLOOKUP(BE31,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D32=\"\",\"\",VLOOKUP(D32,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F32=\"\",\"\",VLOOKUP(F32,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H32=\"\",\"\",VLOOKUP(H32,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L32=\"\",\"\",VLOOKUP(L32,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N32=\"\",\"\",VLOOKUP(N32,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q32=\"\",\"\",VLOOKUP(Q32,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S32=\"\",\"\",VLOOKUP(S32,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U32=\"\",\"\",VLOOKUP(U32,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z32=\"\",\"\",VLOOKUP(Z32,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF32=\"\",\"\",VLOOKUP(AF32,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH32=\"\",\"\",VLOOKUP(AH32,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ32=\"\",\"\",VLOOKUP(AJ32,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT32=\"\",\"\",VLOOKUP(AT32,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW32=\"\",\"\",VLOOKUP(AW32,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA32=\"\",\"\",VLOOKUP(BA32,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE32=\"\",\"\",VLOOKUP(BE32,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D33=\"\",\"\",VLOOKUP(D33,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F33=\"\",\"\",VLOOKUP(F33,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H33=\"\",\"\",VLOOKUP(H33,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L33=\"\",\"\",VLOOKUP(L33,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N33=\"\",\"\",VLOOKUP(N33,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q33=\"\",\"\",VLOOKUP(Q33,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S33=\"\",\"\",VLOOKUP(S33,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U33=\"\",\"\",VLOOKUP(U33,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z33=\"\",\"\",VLOOKUP(Z33,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF33=\"\",\"\",VLOOKUP(AF33,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH33=\"\",\"\",VLOOKUP(AH33,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ33=\"\",\"\",VLOOKUP(AJ33,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT33=\"\",\"\",VLOOKUP(AT33,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW33=\"\",\"\",VLOOKUP(AW33,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA33=\"\",\"\",VLOOKUP(BA33,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE33=\"\",\"\",VLOOKUP(BE33,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D34=\"\",\"\",VLOOKUP(D34,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F34=\"\",\"\",VLOOKUP(F34,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H34=\"\",\"\",VLOOKUP(H34,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L34=\"\",\"\",VLOOKUP(L34,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N34=\"\",\"\",VLOOKUP(N34,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q34=\"\",\"\",VLOOKUP(Q34,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S34=\"\",\"\",VLOOKUP(S34,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U34=\"\",\"\",VLOOKUP(U34,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z34=\"\",\"\",VLOOKUP(Z34,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF34=\"\",\"\",VLOOKUP(AF34,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH34=\"\",\"\",VLOOKUP(AH34,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ34=\"\",\"\",VLOOKUP(AJ34,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT34=\"\",\"\",VLOOKUP(AT34,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW34=\"\",\"\",VLOOKUP(AW34,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA34=\"\",\"\",VLOOKUP(BA34,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE34=\"\",\"\",VLOOKUP(BE34,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D35=\"\",\"\",VLOOKUP(D35,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F35=\"\",\"\",VLOOKUP(F35,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H35=\"\",\"\",VLOOKUP(H35,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L35=\"\",\"\",VLOOKUP(L35,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N35=\"\",\"\",VLOOKUP(N35,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q35=\"\",\"\",VLOOKUP(Q35,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S35=\"\",\"\",VLOOKUP(S35,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U35=\"\",\"\",VLOOKUP(U35,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z35=\"\",\"\",VLOOKUP(Z35,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF35=\"\",\"\",VLOOKUP(AF35,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH35=\"\",\"\",VLOOKUP(AH35,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ35=\"\",\"\",VLOOKUP(AJ35,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT35=\"\",\"\",VLOOKUP(AT35,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW35=\"\",\"\",VLOOKUP(AW35,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA35=\"\",\"\",VLOOKUP(BA35,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE35=\"\",\"\",VLOOKUP(BE35,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D36=\"\",\"\",VLOOKUP(D36,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F36=\"\",\"\",VLOOKUP(F36,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H36=\"\",\"\",VLOOKUP(H36,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L36=\"\",\"\",VLOOKUP(L36,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N36=\"\",\"\",VLOOKUP(N36,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q36=\"\",\"\",VLOOKUP(Q36,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S36=\"\",\"\",VLOOKUP(S36,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U36=\"\",\"\",VLOOKUP(U36,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z36=\"\",\"\",VLOOKUP(Z36,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF36=\"\",\"\",VLOOKUP(AF36,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH36=\"\",\"\",VLOOKUP(AH36,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ36=\"\",\"\",VLOOKUP(AJ36,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT36=\"\",\"\",VLOOKUP(AT36,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW36=\"\",\"\",VLOOKUP(AW36,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA36=\"\",\"\",VLOOKUP(BA36,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE36=\"\",\"\",VLOOKUP(BE36,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D37=\"\",\"\",VLOOKUP(D37,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F37=\"\",\"\",VLOOKUP(F37,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H37=\"\",\"\",VLOOKUP(H37,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L37=\"\",\"\",VLOOKUP(L37,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N37=\"\",\"\",VLOOKUP(N37,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q37=\"\",\"\",VLOOKUP(Q37,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S37=\"\",\"\",VLOOKUP(S37,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U37=\"\",\"\",VLOOKUP(U37,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z37=\"\",\"\",VLOOKUP(Z37,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF37=\"\",\"\",VLOOKUP(AF37,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH37=\"\",\"\",VLOOKUP(AH37,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ37=\"\",\"\",VLOOKUP(AJ37,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT37=\"\",\"\",VLOOKUP(AT37,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW37=\"\",\"\",VLOOKUP(AW37,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA37=\"\",\"\",VLOOKUP(BA37,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE37=\"\",\"\",VLOOKUP(BE37,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D38=\"\",\"\",VLOOKUP(D38,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F38=\"\",\"\",VLOOKUP(F38,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H38=\"\",\"\",VLOOKUP(H38,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L38=\"\",\"\",VLOOKUP(L38,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N38=\"\",\"\",VLOOKUP(N38,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q38=\"\",\"\",VLOOKUP(Q38,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S38=\"\",\"\",VLOOKUP(S38,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U38=\"\",\"\",VLOOKUP(U38,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z38=\"\",\"\",VLOOKUP(Z38,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF38=\"\",\"\",VLOOKUP(AF38,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH38=\"\",\"\",VLOOKUP(AH38,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ38=\"\",\"\",VLOOKUP(AJ38,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT38=\"\",\"\",VLOOKUP(AT38,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW38=\"\",\"\",VLOOKUP(AW38,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA38=\"\",\"\",VLOOKUP(BA38,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE38=\"\",\"\",VLOOKUP(BE38,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D39=\"\",\"\",VLOOKUP(D39,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F39=\"\",\"\",VLOOKUP(F39,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H39=\"\",\"\",VLOOKUP(H39,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L39=\"\",\"\",VLOOKUP(L39,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N39=\"\",\"\",VLOOKUP(N39,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q39=\"\",\"\",VLOOKUP(Q39,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S39=\"\",\"\",VLOOKUP(S39,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U39=\"\",\"\",VLOOKUP(U39,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z39=\"\",\"\",VLOOKUP(Z39,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF39=\"\",\"\",VLOOKUP(AF39,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH39=\"\",\"\",VLOOKUP(AH39,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ39=\"\",\"\",VLOOKUP(AJ39,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT39=\"\",\"\",VLOOKUP(AT39,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW39=\"\",\"\",VLOOKUP(AW39,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA39=\"\",\"\",VLOOKUP(BA39,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE39=\"\",\"\",VLOOKUP(BE39,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D40=\"\",\"\",VLOOKUP(D40,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F40=\"\",\"\",VLOOKUP(F40,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H40=\"\",\"\",VLOOKUP(H40,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L40=\"\",\"\",VLOOKUP(L40,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N40=\"\",\"\",VLOOKUP(N40,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q40=\"\",\"\",VLOOKUP(Q40,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S40=\"\",\"\",VLOOKUP(S40,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U40=\"\",\"\",VLOOKUP(U40,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z40=\"\",\"\",VLOOKUP(Z40,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF40=\"\",\"\",VLOOKUP(AF40,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH40=\"\",\"\",VLOOKUP(AH40,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ40=\"\",\"\",VLOOKUP(AJ40,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT40=\"\",\"\",VLOOKUP(AT40,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW40=\"\",\"\",VLOOKUP(AW40,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA40=\"\",\"\",VLOOKUP(BA40,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE40=\"\",\"\",VLOOKUP(BE40,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D41=\"\",\"\",VLOOKUP(D41,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F41=\"\",\"\",VLOOKUP(F41,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H41=\"\",\"\",VLOOKUP(H41,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L41=\"\",\"\",VLOOKUP(L41,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N41=\"\",\"\",VLOOKUP(N41,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q41=\"\",\"\",VLOOKUP(Q41,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S41=\"\",\"\",VLOOKUP(S41,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U41=\"\",\"\",VLOOKUP(U41,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z41=\"\",\"\",VLOOKUP(Z41,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF41=\"\",\"\",VLOOKUP(AF41,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH41=\"\",\"\",VLOOKUP(AH41,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ41=\"\",\"\",VLOOKUP(AJ41,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT41=\"\",\"\",VLOOKUP(AT41,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW41=\"\",\"\",VLOOKUP(AW41,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA41=\"\",\"\",VLOOKUP(BA41,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE41=\"\",\"\",VLOOKUP(BE41,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D42=\"\",\"\",VLOOKUP(D42,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F42=\"\",\"\",VLOOKUP(F42,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H42=\"\",\"\",VLOOKUP(H42,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L42=\"\",\"\",VLOOKUP(L42,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N42=\"\",\"\",VLOOKUP(N42,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q42=\"\",\"\",VLOOKUP(Q42,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S42=\"\",\"\",VLOOKUP(S42,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U42=\"\",\"\",VLOOKUP(U42,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z42=\"\",\"\",VLOOKUP(Z42,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF42=\"\",\"\",VLOOKUP(AF42,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH42=\"\",\"\",VLOOKUP(AH42,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ42=\"\",\"\",VLOOKUP(AJ42,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT42=\"\",\"\",VLOOKUP(AT42,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW42=\"\",\"\",VLOOKUP(AW42,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA42=\"\",\"\",VLOOKUP(BA42,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE42=\"\",\"\",VLOOKUP(BE42,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D43=\"\",\"\",VLOOKUP(D43,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F43=\"\",\"\",VLOOKUP(F43,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H43=\"\",\"\",VLOOKUP(H43,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L43=\"\",\"\",VLOOKUP(L43,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N43=\"\",\"\",VLOOKUP(N43,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q43=\"\",\"\",VLOOKUP(Q43,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S43=\"\",\"\",VLOOKUP(S43,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U43=\"\",\"\",VLOOKUP(U43,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z43=\"\",\"\",VLOOKUP(Z43,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF43=\"\",\"\",VLOOKUP(AF43,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH43=\"\",\"\",VLOOKUP(AH43,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ43=\"\",\"\",VLOOKUP(AJ43,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT43=\"\",\"\",VLOOKUP(AT43,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW43=\"\",\"\",VLOOKUP(AW43,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA43=\"\",\"\",VLOOKUP(BA43,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE43=\"\",\"\",VLOOKUP(BE43,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D44=\"\",\"\",VLOOKUP(D44,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F44=\"\",\"\",VLOOKUP(F44,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H44=\"\",\"\",VLOOKUP(H44,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L44=\"\",\"\",VLOOKUP(L44,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N44=\"\",\"\",VLOOKUP(N44,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q44=\"\",\"\",VLOOKUP(Q44,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S44=\"\",\"\",VLOOKUP(S44,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U44=\"\",\"\",VLOOKUP(U44,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z44=\"\",\"\",VLOOKUP(Z44,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF44=\"\",\"\",VLOOKUP(AF44,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH44=\"\",\"\",VLOOKUP(AH44,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ44=\"\",\"\",VLOOKUP(AJ44,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT44=\"\",\"\",VLOOKUP(AT44,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW44=\"\",\"\",VLOOKUP(AW44,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA44=\"\",\"\",VLOOKUP(BA44,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE44=\"\",\"\",VLOOKUP(BE44,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D45=\"\",\"\",VLOOKUP(D45,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F45=\"\",\"\",VLOOKUP(F45,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H45=\"\",\"\",VLOOKUP(H45,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L45=\"\",\"\",VLOOKUP(L45,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N45=\"\",\"\",VLOOKUP(N45,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q45=\"\",\"\",VLOOKUP(Q45,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S45=\"\",\"\",VLOOKUP(S45,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U45=\"\",\"\",VLOOKUP(U45,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z45=\"\",\"\",VLOOKUP(Z45,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF45=\"\",\"\",VLOOKUP(AF45,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH45=\"\",\"\",VLOOKUP(AH45,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ45=\"\",\"\",VLOOKUP(AJ45,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT45=\"\",\"\",VLOOKUP(AT45,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW45=\"\",\"\",VLOOKUP(AW45,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA45=\"\",\"\",VLOOKUP(BA45,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE45=\"\",\"\",VLOOKUP(BE45,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D46=\"\",\"\",VLOOKUP(D46,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F46=\"\",\"\",VLOOKUP(F46,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H46=\"\",\"\",VLOOKUP(H46,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L46=\"\",\"\",VLOOKUP(L46,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N46=\"\",\"\",VLOOKUP(N46,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q46=\"\",\"\",VLOOKUP(Q46,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S46=\"\",\"\",VLOOKUP(S46,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U46=\"\",\"\",VLOOKUP(U46,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z46=\"\",\"\",VLOOKUP(Z46,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF46=\"\",\"\",VLOOKUP(AF46,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH46=\"\",\"\",VLOOKUP(AH46,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ46=\"\",\"\",VLOOKUP(AJ46,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT46=\"\",\"\",VLOOKUP(AT46,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW46=\"\",\"\",VLOOKUP(AW46,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA46=\"\",\"\",VLOOKUP(BA46,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE46=\"\",\"\",VLOOKUP(BE46,replace_reason[],2,FALSE))","v":""}]
[{"$error":"#VALUE!"},null,null,null,{"$f":"IF(D47=\"\",\"\",VLOOKUP(D47,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F47=\"\",\"\",VLOOKUP(F47,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H47=\"\",\"\",VLOOKUP(H47,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L47=\"\",\"\",VLOOKUP(L47,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N47=\"\",\"\",VLOOKUP(N47,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q47=\"\",\"\",VLOOKUP(Q47,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S47=\"\",\"\",VLOOKUP(S47,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U47=\"\",\"\",VLOOKUP(U47,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z47=\"\",\"\",VLOOKUP(Z47,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF47=\"\",\"\",VLOOKUP(AF47,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH47=\"\",\"\",VLOOKUP(AH47,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ47=\"\",\"\",VLOOKUP(AJ47,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT47=\"\",\"\",VLOOKUP(AT47,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW47=\"\",\"\",VLOOKUP(AW47,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA47=\"\",\"\",VLOOKUP(BA47,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE47=\"\",\"\",VLOOKUP(BE47,replace_reason[],2,FALSE))","v":""}]
[{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&B48&\"/\"&C48&\"&xml=true\"),\"/lrms/id_road\")","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"IF(D48=\"\",\"\",VLOOKUP(D48,drain_type[],2,FALSE))","v":""},null,{"$f":"IF(F48=\"\",\"\",VLOOKUP(F48,drain_material[],2,FALSE))","v":""},null,{"$f":"IF(H48=\"\",\"\",VLOOKUP(H48,drain_shape[],2,FALSE))","v":""},null,null,null,{"$f":"IF(L48=\"\",\"\",VLOOKUP(L48,inlet[],2,FALSE))","v":""},null,{"$f":"IF(N48=\"\",\"\",VLOOKUP(N48,outlet[],2,FALSE))","v":""},null,null,{"$f":"IF(Q48=\"\",\"\",VLOOKUP(Q48,culvert_type[],2,FALSE))","v":""},null,{"$f":"IF(S48=\"\",\"\",VLOOKUP(S48,drain_lining[],2,FALSE))","v":""},null,{"$f":"IF(U48=\"\",\"\",VLOOKUP(U48,flow_direction[],2,FALSE))","v":""},null,null,null,null,{"$f":"IF(Z48=\"\",\"\",VLOOKUP(Z48,side[],2,FALSE))","v":""},null,null,null,null,null,{"$f":"IF(AF48=\"\",\"\",VLOOKUP(AF48,asset_owner[],2,FALSE))","v":""},null,{"$f":"IF(AH48=\"\",\"\",VLOOKUP(AH48,likelihood[],2,FALSE))","v":""},null,{"$f":"IF(AJ48=\"\",\"\",VLOOKUP(AJ48,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[],2,FALSE))","v":""},null,null,null,{"$f":"IF(AT48=\"\",\"\",VLOOKUP(AT48,condition[],2,FALSE))","v":""},null,null,{"$f":"IF(AW48=\"\",\"\",VLOOKUP(AW48,organisation[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BA48=\"\",\"\",VLOOKUP(BA48,install_reason[],2,FALSE))","v":""},null,null,null,{"$f":"IF(BE48=\"\",\"\",VLOOKUP(BE48,replace_reason[],2,FALSE))","v":""}]

{"sheet":"Lookups","index":1,"n_rows":265,"n_cols":62,"rows_kept":265,"cut":false,"hidden":false,"merged":[]}
["drain type description","drain type",null,"drain material description","drain material",null,"drain shape description","drain shape",null,"waterway",null,"inlet description","inlet",null,"outlet description","outlet",null,"culvert type description","culvert type",null,"drain lining description","drain lining",null,"flow direction description","flow direction",null,"side description","side",null,"install reason description","install reason",null,"asset owner description","asset owner",null,"likelihood description","likelihood",null,"consequence description","consequence",null,"risk description","risk",null,"rul reset description","rul reset",null,"use default description","use default",null,"condition description","condition",null,"organisation description","organisation",null,"replace reason description","replace reason",null,"work origin",null,"work category"]
["Bored Drains","BO",null,"Asbestos cement","AC",null,"Oval","O",null,"2.7",null,"Catchpit","CP",null,"Catchpit","CP",null,"Arched","ARCH",null,"Asphalt","ASP",null,"Decreasing","D",null,"Across","A",null,"Asset Renewal - end of life","01",null,"Crown","C",null,"Rare","1",null,"Insignificant","1",null,"Very Low","1",null,"Not Reset","N",null,"Default","D",null,"Excellent","1",null,"3M","3M",null,"Asset Renewal - end of life","01",null,"Base Preservation Drainage Length",null,"113 - Routine drainage maintenance"]
["Catchpit - Single","CP1",null,"Aluminium","ALUM",null,"Round","R",null,"200",null,"Drop Chamber","DC",null,"Drop Chamber","DC",null,"Box shaped","BOX",null,"Concrete","CON",null,"Increasing","I",null,"Both","B",null,"Crash Damage","02",null,"Local Authority","L",null,"Unlikely","2",null,"Minor","2",null,"Low","2",null,"Reset to Zero","R",null,"User","U",null,"Good","2",null,"Automobile Association","AA",null,"Crash Damage","02",null,"Cycling facilities",null,"141 - Emergency works"]
["Catchpit - Double","CP2",null,"Armco","ARMCO",null,"Square","S",null,"320",null,"Flume","FL",null,"Flume","FL",null,"Circular","CIRC",null,"None","NON",null,"Left to Right","L",null,"Centre","C",null,"Missing","03",null,"Private","P",null,"Possible","3",null,"Moderate","3",null,"Medium","3",null,null,null,null,null,null,null,"Average","3",null,"Auckland Council","ACC",null,"Missing","03",null,"Drainage renewals",null,"213 - Drainage renewals"]
["Catchpit -Triple","CP3",null,"Concrete","CON",null,null,null,null,"50",null,"Yes with a Grating","G",null,"Yes with a Grating","G",null,"Other","OTHER",null,null,null,null,"Not Applicable","N",null,"End","E",null,"Projects","04",null,null,null,null,"Likely","4",null,"Major","4",null,"High","4",null,null,null,null,null,null,null,"Poor","4",null,"Alarm Centre Installation Ltd","ACI",null,"Projects","04",null,"Efficiency",null,"341 - Minor improvements"]
["Culvert","CUL",null,"Earthenware","EW",null,null,null,null,"6.05",null,"Grid","GD",null,"Grid","GD",null,"Triple box","TRIP_BOX",null,null,null,null,"Right to Left","R",null,"Left","L",null,"Vandalism","05",null,null,null,null,"Almost Certain","5",null,"Extreme","5",null,"Extreme","5",null,null,null,null,null,null,null,"Very poor","5",null,"Agfirst","AGF",null,"Vandalism","05",null,"Emergency works",null,"451 - Walking facilities"]
["Dam","DAM",null,"Fabric","FAB",null,null,null,null,"78",null,"Headwalls - Concrete","HC",null,"Headwalls - Concrete","HC",null,"Triple circular","TRIP_CIRC",null,null,null,null,null,null,null,"Right","R",null,null,null,null,null,null,null,"Unknown","U",null,"Unknown","U",null,"Unknown","U",null,null,null,null,null,null,null,null,null,null,"Auckland Motorway Alliance","AMA",null,null,null,null,"Resilience",null,"452 - Cycling facilities"]
["Drop Chamber","DCHM",null,"H Density Polyethyl","HDPE",null,null,null,null,"AHUKARAMA STREAM",null,"Headwalls - Concrete with Grating","HG",null,"Headwalls - Concrete with Grating","HG",null,"Twin arched","TWIN_ARCH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asset Management Engineers Ltd","AME",null,null,null,null,"Routine Maintenance",null,"998 - Unfunded Third Party Work"]
["Dissipation Pad","DISS",null,"Cast Iron","IRON",null,null,null,null,"AHUKURAMU STREAM",null,"Headwalls - Timber","HT",null,"Headwalls - Timber","HT",null,"Twin boxes","TWIN_BOX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asset Management Technicians Ltd","AMT",null,null,null,null,"Safety",null,"999 - Unfunded Rework"]
["Deep well shaft","DWELL",null,"Natural Ground","NG",null,null,null,null,"AIRPORT MOTORWAY",null,"Standard Manhole","MH",null,"Standard Manhole","MH",null,"Twin circular","TWIN_CIRC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Armitage Systems","ARM",null,null,null,null,"Unfunded rework"]
["Flushing Eye","EYE",null,"Poly Vinyl Chloride","PVC",null,null,null,null,"ALEXANDRA STREAM",null,"No","N",null,"No","N",null,"Waterdrive (hand dug)","WATERDRV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aspect Solutions Ltd","ASL",null,null,null,null,"Unfunded third party work"]
["Flume down batter","FLUME",null,"Steel","STEEL",null,null,null,null,"AMBURYS CREEK",null,"Other Structure","OT",null,"Other Structure","OT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auckland System Management","ASM",null,null,null,null,"Walking facilities"]
["Fish Passage","FPASS",null,"Stone","STONE",null,null,null,null,"ANIWANIWA STREAM",null,"Rock Wall (Cemented)","RC",null,"Rock Wall (Cemented)","RC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auckland Transport","AT2"]
["Debris catching grid","GRID",null,"Willow saplings/logs","WILL",null,null,null,null,"ARAPARERA RIVER",null,"Rock Wall (Hand Placed)","RH",null,"Rock Wall (Hand Placed)","RH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aspect Technology and Equipment Ltd","ATE"]
["Manhole with grate inlet","MHGRA",null,"Timber construction","WOOD",null,null,null,null,"AUCKLAND MOTORWAY",null,"Sandbags - Concrete","SB",null,"Sandbags - Concrete","SB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ARRB Transport Research Ltd","ATR"]
["Standard Manhole","MHOLE",null,null,null,null,null,null,null,"AUCKLAND RAILWAY YARD",null,"Manhole with Scruffy Dome","SD",null,"Manhole with Scruffy Dome","SD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auckland University","AUN"]
["Outfall Culvert","OFCUL",null,null,null,null,null,null,null,"AUCKLAND URBAN MOTORWAY",null,"Traversable Grate","TR",null,"Traversable Grate","TR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Broadspectrum (NZ) Ltd","B(L"]
["Other","OTHER",null,null,null,null,null,null,null,"AWANOHI ROAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bri-Ken and Associates Ltd","BAA"]
["Permanent Silt Pond","POND",null,null,null,null,null,null,null,"AWAROA STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bartley Consultants Ltd","BAR"]
["Scour Protection","SCOUR",null,null,null,null,null,null,null,"AWATERE STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bloxam Burnett & Olliver Ltd","BB&"]
["Manhole with Scruffy Dome","SCRFD",null,null,null,null,null,null,null,"BARKERS CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beca Infrastructure","BCF"]
["Side Culvert","SDCUL",null,null,null,null,null,null,null,"BLACK CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Buller District Council","BDC"]
["Side drain","SIDE",null,null,null,null,null,null,null,"BRIGHAMS CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blacktop","BLA"]
["Soak pit","SP",null,null,null,null,null,null,null,"BROADWAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beca Ltd.","BLT"]
["Spillway","SPILL",null,null,null,null,null,null,null,"BROADWAY RAILWAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Civil Assist Ltd","CAL"]
["Subsoil drain","SUB",null,null,null,null,null,null,null,"BROADWAY,RAILWAY.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Christchurch City Council","CCC"]
["Weir","WEIR",null,null,null,null,null,null,null,"BUCKLAND FACTORY STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City Care Ltd","CCL"]
["Water Race","WR",null,null,null,null,null,null,null,"CANTLEYS CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Currie Electrical Ltd.","CEL"]
[null,null,null,null,null,null,null,null,null,"CATTLE ACCESS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company-X Ltd.","CL"]
[null,null,null,null,null,null,null,null,null,"CHAMPAGNE CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critchlow Limited","CL2"]
[null,null,null,null,null,null,null,null,null,"CHIMNEY CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coastline Markers Ltd","CML"]
[null,null,null,null,null,null,null,null,null,"CLIVE RIVER BRIDGE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CoreLogic NZ Ltd.","CNL"]
[null,null,null,null,null,null,null,null,null,"COOPERS CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Central Otago District Council","COD"]
[null,null,null,null,null,null,null,null,null,"CYCLEWAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Contractor","CON"]
[null,null,null,null,null,null,null,null,null,"DAIRY CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CSL Traffic","CSL"]
[null,null,null,null,null,null,null,null,null,"DAIRY STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Connell Wagner Ltd","CWL"]
[null,null,null,null,null,null,null,null,null,"ELBOW CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dunedin City Council","DCC"]
[null,null,null,null,null,null,null,null,null,"ESK RIVER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D & L Crowe Ltd","DLC"]
[null,null,null,null,null,null,null,null,null,"FANSHAWE BEAUMONT VICTORIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spiire NZ Ltd","DWK"]
[null,null,null,null,null,null,null,null,null,"FANSHAWE,BEAUMONT,VICTORIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excell Corporation","ECL"]
[null,null,null,null,null,null,null,null,null,"FIREWOOD CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ferguson Ind","FGI"]
[null,null,null,null,null,null,null,null,null,"FLAT BUSH STREET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fulton Hogan (NZ) Ltd.","FUL"]
[null,null,null,null,null,null,null,null,null,"GEORGE CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gisborne District Council","GDC"]
[null,null,null,null,null,null,null,null,null,"GIBBS STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geosolve Ltd","GEO"]
[null,null,null,null,null,null,null,null,null,"GILLIES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GHD Ltd.","GHD"]
[null,null,null,null,null,null,null,null,null,"GILLIES AVE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEB Construction Ltd","HEB"]
[null,null,null,null,null,null,null,null,null,"GOLD CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Higgins Contractors Ltd.","HIG"]
[null,null,null,null,null,null,null,null,null,"GREAT NORTH ROAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HMI Technologies","HMI"]
[null,null,null,null,null,null,null,null,null,"GREAT SOUTH ROAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HERE New Zealand Ltd","HNZ"]
[null,null,null,null,null,null,null,null,null,"GREVILLE ROAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HTS Group","HTS"]
[null,null,null,null,null,null,null,null,null,"GRIMMERS CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inframix Construction Ltd","IMX"]
[null,null,null,null,null,null,null,null,null,"HAMILTONS CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inzone","INZ"]
[null,null,null,null,null,null,null,null,null,"HENDERSON CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Isaac Construction","ISC"]
[null,null,null,null,null,null,null,null,null,"HIKAURE CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Island Asphalts","ISL"]
[null,null,null,null,null,null,null,null,null,"HILLCREST CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITS","ITS"]
[null,null,null,null,null,null,null,null,null,"HOTEO RIVER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jacobs New Zealand Ltd","JAC"]
[null,null,null,null,null,null,null,null,null,"HUAPAI CK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JCW Consultant","JC"]
[null,null,null,null,null,null,null,null,null,"HUAPAI CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JCL Asphalt subcontractor","JCL"]
[null,null,null,null,null,null,null,null,null,"HURU HURU STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JJ Walters","JJW"]
[null,null,null,null,null,null,null,null,null,"INTERCHANGE DRAIN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Johnstone & Masters Ltd","JM"]
[null,null,null,null,null,null,null,null,null,"IRONGATE STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NZTA (JTOC)","JTO"]
[null,null,null,null,null,null,null,null,null,"JOHNS CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Juno Services Ltd","JUN"]
[null,null,null,null,null,null,null,null,null,"KAIAWHA STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kapiti Coast District Council","KCD"]
[null,null,null,null,null,null,null,null,null,"KAIPARA RIVER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kampung Consulting Ltd.","KCL"]
[null,null,null,null,null,null,null,null,null,"KAKANUI STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kelcroft Engineering","KEL"]
[null,null,null,null,null,null,null,null,null,"KARAKATUWHERO RIVER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local Authority","LA"]
[null,null,null,null,null,null,null,null,null,"KARAMU CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lonrix Ltd","LL"]
[null,null,null,null,null,null,null,null,null,"KAREAARA STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McKays Consultants","MCC"]
[null,null,null,null,null,null,null,null,null,"KAUKAPAKAPA RIVER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Matamata-Piako District Council","MD2"]
[null,null,null,null,null,null,null,null,null,"KINGS CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manawatu District Council","MDC"]
[null,null,null,null,null,null,null,null,null,"KIWI CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McKay Electrical Ltd","MEL"]
[null,null,null,null,null,null,null,null,null,"KOPUAROA STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aecom NZ Ltd","MER"]
[null,null,null,null,null,null,null,null,null,"LEANING ROCK CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MetService","MET"]
[null,null,null,null,null,null,null,null,null,"LITTENS CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marlborough NOC JV","MJV"]
[null,null,null,null,null,null,null,null,null,"LONELY CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McKay Ltd.","ML"]
[null,null,null,null,null,null,null,null,null,"LUCAS CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marlborough Roads","MR"]
[null,null,null,null,null,null,null,null,null,"LUCKY HILL STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MWH NZ Ltd.","MWH"]
[null,null,null,null,null,null,null,null,null,"MAENEENE RIVER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Napier City Council","NCC"]
[null,null,null,null,null,null,null,null,null,"MAHARAKEKE STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NZ Transport Agency - Highway Programme","NTA"]
[null,null,null,null,null,null,null,null,null,"MAHIARUHE STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NZ Transport Agency - Funding","NTF"]
[null,null,null,null,null,null,null,null,null,"MAHURANGI RIVER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"North Power","NTH"]
[null,null,null,null,null,null,null,null,null,"MAINTRUNK RAILWAY LINE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nutech Security","NUT"]
[null,null,null,null,null,null,null,null,null,"MAKAPUA STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Odyssey Energy (2009) Ltd.","OE("]
[null,null,null,null,null,null,null,null,null,"MAKARAU RIVER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opus International Consultants Ltd (NZ)","OI2"]
[null,null,null,null,null,null,null,null,null,"MAKARETU RIVER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opus International Consultants Ltd.","OIC"]
[null,null,null,null,null,null,null,null,null,"MAKARIKA STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oldfields","OLD"]
[null,null,null,null,null,null,null,null,null,"MAKOAO STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Porirua City Council","PCC"]
[null,null,null,null,null,null,null,null,null,"MANGAHAUINI STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pinnacles Civil Group Ltd.","PCG"]
[null,null,null,null,null,null,null,null,null,"MANGAKINO STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pope Electrical Ltd","PE2"]
[null,null,null,null,null,null,null,null,null,"MANGAMATE STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pope Electrical Limited","PEL"]
[null,null,null,null,null,null,null,null,null,"MANGAMAUKU STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pavement Management Services","PMS"]
[null,null,null,null,null,null,null,null,null,"MANGAOMEKA STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Power Solutions Ltd","PSL"]
[null,null,null,null,null,null,null,null,null,"MANGAONE STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Queenstown-Lakes District Council","QDC"]
[null,null,null,null,null,null,null,null,null,"MANGAPOHO STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quality Roading and Services","QRS"]
[null,null,null,null,null,null,null,null,null,"MANGATEWAI STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Read-only access for Tenderers","RAF"]
[null,null,null,null,null,null,null,null,null,"MANUKAU HARBOUR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rangitikei District Council","RDC"]
[null,null,null,null,null,null,null,null,null,"MARAEHARA RIVER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadex","RDX"]
[null,null,null,null,null,null,null,null,null,"MARSHALLS STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roading Logistics Ltd","RLL"]
[null,null,null,null,null,null,null,null,null,"MAUNGAWHAU RD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rationale Ltd","RLT"]
[null,null,null,null,null,null,null,null,null,"MAUNGAWHAU ROAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rotorua District Council","ROT"]
[null,null,null,null,null,null,null,null,null,"MCNAB STREET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAMM Software Limited","RSL"]
[null,null,null,null,null,null,null,null,null,"MEEANEE DRAIN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Road Signs & Traffic Control Equipment Limited","RTL"]
[null,null,null,null,null,null,null,null,null,"MEOLA CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Russell Roads","RUS"]
[null,null,null,null,null,null,null,null,null,"MIEKLES CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Salient Consultants","SAL"]
[null,null,null,null,null,null,null,null,null,"MILL STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sealcoat Central Ltd.","SCL"]
[null,null,null,null,null,null,null,null,null,"MITCHELSON ST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shaw's Consulting Services Ltd","SCS"]
[null,null,null,null,null,null,null,null,null,"MITCHELSON STREET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Southland District Council","SDC"]
[null,null,null,null,null,null,null,null,null,"MOHAKA RIVER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signopsys Electronic Signs","SES"]
[null,null,null,null,null,null,null,null,null,"MOTORWAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sicon Ltd.","SL2"]
[null,null,null,null,null,null,null,null,null,"MOTORWAY 18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stantec New Zealand","SN2"]
[null,null,null,null,null,null,null,null,null,"MOTORWAY NORTH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stantec New Zealand Ltd","SNZ"]
[null,null,null,null,null,null,null,null,null,"MOTORWAY NORTH 1N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SouthRoads Ltd.","SOU"]
[null,null,null,null,null,null,null,null,null,"MOTORWAY NORTH WEST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Safe Roads Alliance","SRA"]
[null,null,null,null,null,null,null,null,null,"MOTORWAY S.H.NO 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Services South East (NZ) Ltd.","SS2"]
[null,null,null,null,null,null,null,null,null,"MOTORWAY SH1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Services South East Pty Ltd","SSE"]
[null,null,null,null,null,null,null,null,null,"MOTORWAY SH1 & 16 A.U.M.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tonkin & Taylor Ltd","T&T"]
[null,null,null,null,null,null,null,null,null,"MOTORWAY SH16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tasman Howey","TAS"]
[null,null,null,null,null,null,null,null,null,"MOTORWAY SH16 & SH1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NZTA and WDM","TAW"]
[null,null,null,null,null,null,null,null,null,"MOTORWAY SH20",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tauranga City Council","TC2"]
[null,null,null,null,null,null,null,null,null,"MOTORWAY SOUTH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taranaki Civil Construction","TCC"]
[null,null,null,null,null,null,null,null,null,"MOTU RIVER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC Nicholls","TCN"]
[null,null,null,null,null,null,null,null,null,"MOUNTAIN VIEW ROAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traffic Control Systems","TCS"]
[null,null,null,null,null,null,null,null,null,"MT WELLINGTON HIGHWAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taupo District Council","TD2"]
[null,null,null,null,null,null,null,null,null,"MUDDY CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tasman District Council","TDC"]
[null,null,null,null,null,null,null,null,null,"NEWCOMBES STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Datastack Ltd","TDL"]
[null,null,null,null,null,null,null,null,null,"NGAKAROA STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taupo East Traffic Services Contractor","TET"]
[null,null,null,null,null,null,null,null,null,"NGAMAHANGA STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Broadspectrum (NZ) Ltd","TFD"]
[null,null,null,null,null,null,null,null,null,"NGARURORO RIVER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waka Kotahi NZ Transport Agency","TNZ"]
[null,null,null,null,null,null,null,null,null,"NIL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Top Energy","TOP"]
[null,null,null,null,null,null,null,null,null,"NIMT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Roading Company","TRC"]
[null,null,null,null,null,null,null,null,null,"NIMT RAILWAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transfield Services (NZ) Ltd","TS("]
[null,null,null,null,null,null,null,null,null,"NINE MILE CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tonkin and Taylor Ltd","TT"]
[null,null,null,null,null,null,null,null,null,"NO.6 CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tyco Traffic and Transportation","TYC"]
[null,null,null,null,null,null,null,null,null,"NORTH AUCKLAND RAILWAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urban Connection Ltd","UCL"]
[null,null,null,null,null,null,null,null,null,"NORTH ISLAND MAIN TRUNK RLY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"University of Canterbury","UOC"]
[null,null,null,null,null,null,null,null,null,"NORTH ISLAND RAILWAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ventia Pty Ltd","VPL"]
[null,null,null,null,null,null,null,null,null,"NORTH MOTORWAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Western Bay of Plenty District Council","WBO"]
[null,null,null,null,null,null,null,null,null,"NORTH SHORE DRAINAGE ACCESS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wellington City Council","WCC"]
[null,null,null,null,null,null,null,null,null,"NORTH WEST MOTORWAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waimakariri District Council","WD2"]
[null,null,null,null,null,null,null,null,null,"NORTHERN BUSWAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whakatane District Council","WD3"]
[null,null,null,null,null,null,null,null,null,"NORTHERN MOTORWAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wairoa District Council","WD4"]
[null,null,null,null,null,null,null,null,null,"NUKUMEA STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waipa District Council","WD5"]
[null,null,null,null,null,null,null,null,null,"NUKUTAHARUA STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waikato District Council","WD6"]
[null,null,null,null,null,null,null,null,null,"OAKLEY CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Whangarei District Council","WDC"]
[null,null,null,null,null,null,null,null,null,"OHINEPAKA STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WDM","WDM"]
[null,null,null,null,null,null,null,null,null,"OHIRANGI STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WSP-Opus International Consultants Ltd","WIC"]
[null,null,null,null,null,null,null,null,null,"OKAHU CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downer New Zealand Limited","WIL"]
[null,null,null,null,null,null,null,null,null,"OKAHUPUPUNI STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W J Ashton Service Ltd","WJA"]
[null,null,null,null,null,null,null,null,null,"OKURA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waka Kotahi NZ Transport Agency - Highways","WK2"]
[null,null,null,null,null,null,null,null,null,"OKURA RIVER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waka Kotahi NZ Transport Agency","WKN"]
[null,null,null,null,null,null,null,null,null,"OMANA STREAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WSP New Zealand Ltd","WNZ"]
[null,null,null,null,null,null,null,null,null,"OMAUMAU STREAM"]
[null,null,null,null,null,null,null,null,null,"ONEPOTO STREAM"]
[null,null,null,null,null,null,null,null,null,"ONGA ONGA STREAM"]
[null,null,null,null,null,null,null,null,null,"OPOHO STREAM"]
[null,null,null,null,null,null,null,null,null,"OREWA RIVER"]
[null,null,null,null,null,null,null,null,null,"OTAHUHU CK (TIDAL)"]
[null,null,null,null,null,null,null,null,null,"OTANERUA STREAM"]
[null,null,null,null,null,null,null,null,null,"OTEHA CREEK"]
[null,null,null,null,null,null,null,null,null,"OTEHA VALLEY ROAD"]
[null,null,null,null,null,null,null,null,null,"OTOKO STREAM"]
[null,null,null,null,null,null,null,null,null,"OWEKA RIVER"]
[null,null,null,null,null,null,null,null,null,"PAERATA STREAM"]
[null,null,null,null,null,null,null,null,null,"PAHUREHURE INLET"]
[null,null,null,null,null,null,null,null,null,"PAKURATAHI STREAM"]
[null,null,null,null,null,null,null,null,null,"PAOARUKU STREAM"]
[null,null,null,null,null,null,null,null,null,"PAPAKURA STREAM"]
[null,null,null,null,null,null,null,null,null,"PEDESTRIAN ACCESS"]
[null,null,null,null,null,null,null,null,null,"POHUEHUE CREEK"]
[null,null,null,null,null,null,null,null,null,"POHUEHUE STREAM"]
[null,null,null,null,null,null,null,null,null,"POROPORO RIVER"]
[null,null,null,null,null,null,null,null,null,"PRYDES DRAIN"]
[null,null,null,null,null,null,null,null,null,"PUHINUI STREAM"]
[null,null,null,null,null,null,null,null,null,"PUHOI RIVER"]
[null,null,null,null,null,null,null,null,null,"PUNGANUI STREAM"]
[null,null,null,null,null,null,null,null,null,"RAILWAY"]
[null,null,null,null,null,null,null,null,null,"RAILWAY 7 CLEMO DRIVE"]
[null,null,null,null,null,null,null,null,null,"RAILWAY AND CLEMO DRIVE"]
[null,null,null,null,null,null,null,null,null,"RAILWAY KHYBER PASS"]
[null,null,null,null,null,null,null,null,null,"RAILWAY LINE"]
[null,null,null,null,null,null,null,null,null,"RAILWAY NIMT"]
[null,null,null,null,null,null,null,null,null,"RAILWAY,KHYBER PASS"]
[null,null,null,null,null,null,null,null,null,"RARAWARU STREAM"]
[null,null,null,null,null,null,null,null,null,"RAUPARE STREAM"]
[null,null,null,null,null,null,null,null,null,"REWITI CREEK"]
[null,null,null,null,null,null,null,null,null,"ROSEBANK CREEK"]
[null,null,null,null,null,null,null,null,null,"ROSEBANK INLET"]
[null,null,null,null,null,null,null,null,null,"ROSEDALE RD"]
[null,null,null,null,null,null,null,null,null,"ROSEDALE ROAD"]
[null,null,null,null,null,null,null,null,null,"SANDY CREEK"]
[null,null,null,null,null,null,null,null,null,"SEART"]
[null,null,null,null,null,null,null,null,null,"SERVICES"]
[null,null,null,null,null,null,null,null,null,"SERVICES DUCT"]
[null,null,null,null,null,null,null,null,null,"SH 20"]
[null,null,null,null,null,null,null,null,null,"SH 20A"]
[null,null,null,null,null,null,null,null,null,"SH1"]
[null,null,null,null,null,null,null,null,null,"SH20"]
[null,null,null,null,null,null,null,null,null,"SH20A"]
[null,null,null,null,null,null,null,null,null,"SH22"]
[null,null,null,null,null,null,null,null,null,"SHOAL BAY CREEK"]
[null,null,null,null,null,null,null,null,null,"SHOAL BAY INLET"]
[null,null,null,null,null,null,null,null,null,"SHOAL CREEK"]
[null,null,null,null,null,null,null,null,null,"SHOALBAY INLET"]
[null,null,null,null,null,null,null,null,null,"SLIPPERY CK."]
[null,null,null,null,null,null,null,null,null,"SLIPPERY CREEK"]
[null,null,null,null,null,null,null,null,null,"SNELGARS CREEK"]
[null,null,null,null,null,null,null,null,null,"SONORA CREEK"]
[null,null,null,null,null,null,null,null,null,"SOUTHERN MOTORWAY"]
[null,null,null,null,null,null,null,null,null,"STATE HIGHWAY NO 1"]
[null,null,null,null,null,null,null,null,null,"STATE HIGHWAY NO 22"]
[null,null,null,null,null,null,null,null,null,"STILLWATER"]
[null,null,null,null,null,null,null,null,null,"SUNNYNOOK CREEK"]
[null,null,null,null,null,null,null,null,null,"SUNNYNOOK ROAD"]
[null,null,null,null,null,null,null,null,null,"TAHAENUI RIVER"]
[null,null,null,null,null,null,null,null,null,"TAKAPAU STREAM"]
[null,null,null,null,null,null,null,null,null,"TAMAKI RIVER"]
[null,null,null,null,null,null,null,null,null,"TANK FARM CREEK"]
[null,null,null,null,null,null,null,null,null,"TANK FARM STREAM"]
[null,null,null,null,null,null,null,null,null,"TANNERY CREEK"]
[null,null,null,null,null,null,null,null,null,"TARATA (TARARATA) CREEK"]
[null,null,null,null,null,null,null,null,null,"TARATA CK"]
[null,null,null,null,null,null,null,null,null,"TE HANA RIVER."]
[null,null,null,null,null,null,null,null,null,"TE MATAI STREAM"]
[null,null,null,null,null,null,null,null,null,"TE NGARU STREAM"]
[null,null,null,null,null,null,null,null,null,"TE PAHI CREEK"]
[null,null,null,null,null,null,null,null,null,"TRENWITH ST"]
[null,null,null,null,null,null,null,null,null,"TRISTRAM AVE"]
[null,null,null,null,null,null,null,null,null,"TUKIPO STREAM"]
[null,null,null,null,null,null,null,null,null,"TUKITUKI RIVER"]
[null,null,null,null,null,null,null,null,null,"TUTAEKURI RIVER"]
[null,null,null,null,null,null,null,null,null,"TUTAEKURI WAIMATE STREAM"]
[null,null,null,null,null,null,null,null,null,"TWO MILE CREEK"]
[null,null,null,null,null,null,null,null,null,"UPPER WAIWERA ROAD"]
[null,null,null,null,null,null,null,null,null,"VERCOES CREEK"]
[null,null,null,null,null,null,null,null,null,"WAIAPU RIVER"]
[null,null,null,null,null,null,null,null,null,"WAIHUA RIVER"]
[null,null,null,null,null,null,null,null,null,"WAIKARE RIVER"]
[null,null,null,null,null,null,null,null,null,"WAIKATO RIVER"]
[null,null,null,null,null,null,null,null,null,"WAIKOAU RIVER"]
[null,null,null,null,null,null,null,null,null,"WAIKOKO DRAIN"]
[null,null,null,null,null,null,null,null,null,"WAIMAUKU STREAM"]
[null,null,null,null,null,null,null,null,null,"WAINUI STREAM"]
[null,null,null,null,null,null,null,null,null,"WAIOKAURI CREEK"]
[null,null,null,null,null,null,null,null,null,"WAIONE STREAM"]
[null,null,null,null,null,null,null,null,null,"WAIOTU STREAM"]
[null,null,null,null,null,null,null,null,null,"WAIPAOA RIVER"]
[null,null,null,null,null,null,null,null,null,"WAIPAWA RIVER"]
[null,null,null,null,null,null,null,null,null,"WAIPUNGA RIVER"]
[null,null,null,null,null,null,null,null,null,"WAIRAU ROAD"]
[null,null,null,null,null,null,null,null,null,"WAITANGI RIVER"]
[null,null,null,null,null,null,null,null,null,"WAITARAIRE CREEK"]
[null,null,null,null,null,null,null,null,null,"WAITARAIRE STREAM"]
[null,null,null,null,null,null,null,null,null,"WAITEMATA HARBOUR"]
[null,null,null,null,null,null,null,null,null,"WAIWERA RIVER"]
[null,null,null,null,null,null,null,null,null,"WALKWAY"]
[null,null,null,null,null,null,null,null,null,"WALPOLE STREET"]
[null,null,null,null,null,null,null,null,null,"WATARAIRE CREEK"]
[null,null,null,null,null,null,null,null,null,"WEITI RIVER"]
[null,null,null,null,null,null,null,null,null,"WEITI STREAM"]
[null,null,null,null,null,null,null,null,null,"WELLESLEY ST GRAFTON OFF RAMP"]
[null,null,null,null,null,null,null,null,null,"WELLESLEY ST,GRAFTON OFFRAMP"]
[null,null,null,null,null,null,null,null,null,"WELLESLEY STREET"]
[null,null,null,null,null,null,null,null,null,"WHAU RIVER"]
[null,null,null,null,null,null,null,null,null,"WHITES CREEK"]
[null,null,null,null,null,null,null,null,null,"WOODHILL CREEK"]