{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Pavement","Lookups"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":38,"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":"Pavement","index":0,"n_rows":100,"n_cols":54,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["15f221f1-c15e-4d8e-a679-81fade5c4405_road_id","ba4adf1f-d64b-4d2c-a600-a59acebf3405_road_id","sh-rs-d","15f221f1-c15e-4d8e-a679-81fade5c4404_start_m","ba4adf1f-d64b-4d2c-a600-a59acebf3404_end_m","60bd99b3-4d01-4b77-aa7d-508e40916011_not_ramm_field_contract_name","fb425834-bea9-4ad7-b90e-35dce0ca7068_layer_subgrade","1618a683-d71e-42f9-9e30-d0ba3dee3ca3_pave_material_desc","1618a683-d71e-42f9-9e30-d0ba3dee3ca3_pave_material","d8776724-e0b3-43fc-8119-d9907c7a9c11_pave_subgrade","64a50ef5-8ef6-474b-b3b5-f30b162b5fa5_pave_spec_desc","64a50ef5-8ef6-474b-b3b5-f30b162b5fa5_pave_spec","edf4b0b7-3722-4a2c-857d-99f0de26d5ff_pave_source","9279daf3-b181-4504-9a54-8aa2d32bf93d_estimate_status","c223a886-a599-475c-b883-a06b34d7fc83_cbr_ucs","ba3c3240-1ac4-453e-8313-ad4636b0434b_layer_strength","a2c90e22-b21b-4687-8b8e-1cd08c730411_thickness","cb422a04-3676-40e9-92b1-b9738f4d4ee9_plan_no","bfc80df2-b18b-44c0-be72-79cab0715396_full_width_flag","d936187c-e50d-4379-acf0-b3e513fe78b9_width","5e1dfae1-1a2e-4617-ab1b-9a544ddb11a2_offset","3cce07ef-d856-4346-bab3-01e5ba3287bd_lane_coverage","599bcec2-6423-4966-80b2-aa9a1b89ef46_layer_date","78713269-a154-4092-88d4-d6c36fb2a992_design_life","0b05b73a-dafd-470c-a3e2-8ec5b36ebba7_design_esa","ff76b0d3-d421-41b1-ae87-47d73e24fd2a_asset_owner_desc","ff76b0d3-d421-41b1-ae87-47d73e24fd2a_asset_owner","e14ceca6-d552-47a2-858e-5a07145e5197_work_origin_id","84e5f505-99d1-45b3-8b6c-9a18bd096d0b_work_category","bc278381-8d88-4024-b92a-9766a568f27d_RAMM_Note_field_site_name","85a2eeb4-8c8e-4b4e-bf09-63419e4dd7e9_recycling","c4e0c6a0-bf55-48de-8837-70f0500f62a6_pct_recycled","ecee3f8b-2bb6-4794-989f-faae3863dbcc_surf_recycled_cpnt_desc","ecee3f8b-2bb6-4794-989f-faae3863dbcc_surf_recycled_cpnt","72bdea78-14a3-4fe3-b3e1-7805e2da15df_reconstructed","06c105c8-b3c3-4326-864a-c01366916872_stab_percent","98857e01-eb0e-4b01-9563-4a5245a043ee_pave_st_agent","32fbcd12-d737-4b6f-b034-fc9eb043e129_stab_percent_2","ce0d91b2-0f9f-477d-9792-17fc9d88867a_pave_st_agent_2","ba43eef4-7ed5-421f-9970-b4e7579fa0b0_stab_percent_3","7de2911a-93ba-4fef-9488-35bbb8a58888_pave_st_agent_3","1916debc-79ab-499e-a3a6-2fa987ee36b9_notes","ac3ac0d8-8713-4862-bd6c-63ba5084c0a0_Not_RAMMfield_construction_process_pavement_treatment","780c1163-ac78-4a56-8c73-77df7edaaae6_Not_RAMMfield_construction_process_what_happened_to_the_existing_layer","f450c849-e9b2-4bf5-927f-7c666d566568_Not_RAMMfield_construction_process_existing_layer_reconstructed_removed_depth","c65e9cf9-3e3e-4c38-963b-ceec5af28b2a_Not_RAMMfield_construction_process_existing_layer_undisturbed_depth","3a20c5c5-f743-49e0-a375-995a708385f7_Not_RAMMfield_construction_process_existing_layer_become_composite_layer","7ea40d72-11cc-47d0-a5d4-0eecb464eb7c_Not_RAMMfield_construction_process_reconstructed_date","9ced64a4-169e-4a11-9af5-b385f576b39e_existing_layer_removed_date","28c72aea-d705-48cb-89b0-0393e975a188_Not_RAMMfield_construction_process_start","3982cf2c-44fe-4549-95c3-f2b11fdfe9ea_Not_RAMMfield_construction_process_end","4bf1dfea-dbfa-40f8-ac2a-33b9c7c19f89_Not_RAMMfield_construction_process_width","8dde3727-03f1-4252-b9b3-3e8d3ab78a47_Not_RAMMfield_construction_process_offset","969fad1a-b947-4499-9534-32f8935b158b_Not_RAMMfield_construction_process_notes"]
["road_id","road_id","sh-rs-d","start_m","end_m","not_ramm_field_contract_name","layer_subgrade","pave_material_desc","pave_material","pave_subgrade","pave_spec_desc","pave_spec","pave_source","estimate_status","cbr_ucs","layer_strength","thickness","plan_no","full_width_flag","width","offset","lane_coverage","layer_date","design_life","design_esa","asset_owner_desc","asset_owner","work_origin_id","work_category","RAMM_Note_field_site_name","recycling","pct_recycled","surf_recycled_cpnt_desc","surf_recycled_cpnt","reconstructed","stab_percent","pave_st_agent","stab_percent_2","pave_st_agent_2","stab_percent_3","pave_st_agent_3","notes","Not_RAMMfield_construction_process_pavement_treatment","Not_RAMMfield_construction_process_what_happened_to_the_existing_layer","Not_RAMMfield_construction_process_existing_layer_reconstructed_removed_depth","Not_RAMMfield_construction_process_existing_layer_undisturbed_depth","Not_RAMMfield_construction_process_existing_layer_become_composite_layer","Not_RAMMfield_construction_process_reconstructed_date","existing_layer_removed_date","Not_RAMMfield_construction_process_start","Not_RAMMfield_construction_process_end","Not_RAMMfield_construction_process_width","Not_RAMMfield_construction_process_offset","Not_RAMMfield_construction_process_notes"]
["Start Road Id ","End Road Id ","SH-RS-D  (e.g. 016-0000-B) must be uppercase and include leading 0","RP Start (m)","RP End (m)","Contract Name (must the be same for each row)","Layer or Subgrade (Layer Type)"," Pavement Material Description","Pavement Material","Pavement Subgrade","Pavement Specification Description","Pavement Specification","Pavement Source","Estimate Status (Accuracy)","Measure Type","Layer Strength","Thickness","Construction Plan No","Full Width (must populate with Y or N as uppercase)","Width","Offset","Lane coverage","Layer Date (dd/mm/yyyy) Must include leading 0","Design Life","Design ESA","Asset Owner Description","Asset Owner","Work Origin","Work Category","Site Name","Recycling (must populate with True or False , 1st letter must be uppercase)","Percentage Recycled","Recycled Component Description","Recycled Component","Reconstructed","Stab Percent","Pave Stabilising Agent","Stab Percent 2","Pave Stabilising Agent 2","Stab Percent 3","Pave Stabilising Agent 3","Comments","Construction Process - Pavement Treatment","Construction Process - What happened to the existing layer?","Construction Process - Existing layer: Reconstructed/Removed Depth","Construction Process - Existing Layer: Undisturbed Depth","Construction Process - Existing layer become composite layer?","Construction Process - Reconstructed Date (dd/mm/yyyy) Must include leading 0","Construction Process - Removed Date (dd/mm/yyyy) Must include leading 0","Construction Process - Start","Construction Process - End","Construction Process - Width","Construction Process - Offset","Construction Process - Notes"]
[{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&C4&\"/\"&D4&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&C4&\"/\"&E4&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,null,null,{"$f":"IF(H4=\"\",\"\",VLOOKUP(H4,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K4=\"\",\"\",VLOOKUP(K4,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z4=\"\",\"\",VLOOKUP(Z4,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG4=\"\",\"\",VLOOKUP(AG4,recycle_component[],2,FALSE))","v":""}]
[{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&C5&\"/\"&D5&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&C5&\"/\"&E5&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,null,null,{"$f":"IF(H5=\"\",\"\",VLOOKUP(H5,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K5=\"\",\"\",VLOOKUP(K5,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z5=\"\",\"\",VLOOKUP(Z5,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG5=\"\",\"\",VLOOKUP(AG5,recycle_component[],2,FALSE))","v":""}]
["null",{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&C6&\"/\"&E6&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,null,null,{"$f":"IF(H6=\"\",\"\",VLOOKUP(H6,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K6=\"\",\"\",VLOOKUP(K6,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z6=\"\",\"\",VLOOKUP(Z6,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG6=\"\",\"\",VLOOKUP(AG6,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H7=\"\",\"\",VLOOKUP(H7,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K7=\"\",\"\",VLOOKUP(K7,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z7=\"\",\"\",VLOOKUP(Z7,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG7=\"\",\"\",VLOOKUP(AG7,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H8=\"\",\"\",VLOOKUP(H8,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K8=\"\",\"\",VLOOKUP(K8,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z8=\"\",\"\",VLOOKUP(Z8,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG8=\"\",\"\",VLOOKUP(AG8,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H9=\"\",\"\",VLOOKUP(H9,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K9=\"\",\"\",VLOOKUP(K9,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z9=\"\",\"\",VLOOKUP(Z9,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG9=\"\",\"\",VLOOKUP(AG9,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H10=\"\",\"\",VLOOKUP(H10,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K10=\"\",\"\",VLOOKUP(K10,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z10=\"\",\"\",VLOOKUP(Z10,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG10=\"\",\"\",VLOOKUP(AG10,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H11=\"\",\"\",VLOOKUP(H11,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K11=\"\",\"\",VLOOKUP(K11,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z11=\"\",\"\",VLOOKUP(Z11,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG11=\"\",\"\",VLOOKUP(AG11,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H12=\"\",\"\",VLOOKUP(H12,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K12=\"\",\"\",VLOOKUP(K12,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z12=\"\",\"\",VLOOKUP(Z12,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG12=\"\",\"\",VLOOKUP(AG12,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H13=\"\",\"\",VLOOKUP(H13,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K13=\"\",\"\",VLOOKUP(K13,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z13=\"\",\"\",VLOOKUP(Z13,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG13=\"\",\"\",VLOOKUP(AG13,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H14=\"\",\"\",VLOOKUP(H14,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K14=\"\",\"\",VLOOKUP(K14,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z14=\"\",\"\",VLOOKUP(Z14,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG14=\"\",\"\",VLOOKUP(AG14,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H15=\"\",\"\",VLOOKUP(H15,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K15=\"\",\"\",VLOOKUP(K15,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z15=\"\",\"\",VLOOKUP(Z15,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG15=\"\",\"\",VLOOKUP(AG15,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H16=\"\",\"\",VLOOKUP(H16,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K16=\"\",\"\",VLOOKUP(K16,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z16=\"\",\"\",VLOOKUP(Z16,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG16=\"\",\"\",VLOOKUP(AG16,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H17=\"\",\"\",VLOOKUP(H17,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K17=\"\",\"\",VLOOKUP(K17,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z17=\"\",\"\",VLOOKUP(Z17,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG17=\"\",\"\",VLOOKUP(AG17,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H18=\"\",\"\",VLOOKUP(H18,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K18=\"\",\"\",VLOOKUP(K18,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z18=\"\",\"\",VLOOKUP(Z18,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG18=\"\",\"\",VLOOKUP(AG18,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H19=\"\",\"\",VLOOKUP(H19,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K19=\"\",\"\",VLOOKUP(K19,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z19=\"\",\"\",VLOOKUP(Z19,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG19=\"\",\"\",VLOOKUP(AG19,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H20=\"\",\"\",VLOOKUP(H20,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K20=\"\",\"\",VLOOKUP(K20,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z20=\"\",\"\",VLOOKUP(Z20,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG20=\"\",\"\",VLOOKUP(AG20,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H21=\"\",\"\",VLOOKUP(H21,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K21=\"\",\"\",VLOOKUP(K21,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z21=\"\",\"\",VLOOKUP(Z21,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG21=\"\",\"\",VLOOKUP(AG21,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H22=\"\",\"\",VLOOKUP(H22,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K22=\"\",\"\",VLOOKUP(K22,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z22=\"\",\"\",VLOOKUP(Z22,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG22=\"\",\"\",VLOOKUP(AG22,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H23=\"\",\"\",VLOOKUP(H23,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K23=\"\",\"\",VLOOKUP(K23,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z23=\"\",\"\",VLOOKUP(Z23,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG23=\"\",\"\",VLOOKUP(AG23,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H24=\"\",\"\",VLOOKUP(H24,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K24=\"\",\"\",VLOOKUP(K24,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z24=\"\",\"\",VLOOKUP(Z24,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG24=\"\",\"\",VLOOKUP(AG24,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H25=\"\",\"\",VLOOKUP(H25,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K25=\"\",\"\",VLOOKUP(K25,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z25=\"\",\"\",VLOOKUP(Z25,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG25=\"\",\"\",VLOOKUP(AG25,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H26=\"\",\"\",VLOOKUP(H26,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K26=\"\",\"\",VLOOKUP(K26,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z26=\"\",\"\",VLOOKUP(Z26,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG26=\"\",\"\",VLOOKUP(AG26,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H27=\"\",\"\",VLOOKUP(H27,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K27=\"\",\"\",VLOOKUP(K27,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z27=\"\",\"\",VLOOKUP(Z27,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG27=\"\",\"\",VLOOKUP(AG27,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H28=\"\",\"\",VLOOKUP(H28,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K28=\"\",\"\",VLOOKUP(K28,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z28=\"\",\"\",VLOOKUP(Z28,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG28=\"\",\"\",VLOOKUP(AG28,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H29=\"\",\"\",VLOOKUP(H29,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K29=\"\",\"\",VLOOKUP(K29,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z29=\"\",\"\",VLOOKUP(Z29,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG29=\"\",\"\",VLOOKUP(AG29,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H30=\"\",\"\",VLOOKUP(H30,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K30=\"\",\"\",VLOOKUP(K30,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z30=\"\",\"\",VLOOKUP(Z30,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG30=\"\",\"\",VLOOKUP(AG30,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H31=\"\",\"\",VLOOKUP(H31,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K31=\"\",\"\",VLOOKUP(K31,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z31=\"\",\"\",VLOOKUP(Z31,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG31=\"\",\"\",VLOOKUP(AG31,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H32=\"\",\"\",VLOOKUP(H32,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K32=\"\",\"\",VLOOKUP(K32,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z32=\"\",\"\",VLOOKUP(Z32,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG32=\"\",\"\",VLOOKUP(AG32,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H33=\"\",\"\",VLOOKUP(H33,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K33=\"\",\"\",VLOOKUP(K33,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z33=\"\",\"\",VLOOKUP(Z33,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG33=\"\",\"\",VLOOKUP(AG33,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H34=\"\",\"\",VLOOKUP(H34,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K34=\"\",\"\",VLOOKUP(K34,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z34=\"\",\"\",VLOOKUP(Z34,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG34=\"\",\"\",VLOOKUP(AG34,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H35=\"\",\"\",VLOOKUP(H35,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K35=\"\",\"\",VLOOKUP(K35,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z35=\"\",\"\",VLOOKUP(Z35,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG35=\"\",\"\",VLOOKUP(AG35,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H36=\"\",\"\",VLOOKUP(H36,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K36=\"\",\"\",VLOOKUP(K36,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z36=\"\",\"\",VLOOKUP(Z36,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG36=\"\",\"\",VLOOKUP(AG36,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H37=\"\",\"\",VLOOKUP(H37,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K37=\"\",\"\",VLOOKUP(K37,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z37=\"\",\"\",VLOOKUP(Z37,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG37=\"\",\"\",VLOOKUP(AG37,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H38=\"\",\"\",VLOOKUP(H38,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K38=\"\",\"\",VLOOKUP(K38,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z38=\"\",\"\",VLOOKUP(Z38,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG38=\"\",\"\",VLOOKUP(AG38,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H39=\"\",\"\",VLOOKUP(H39,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K39=\"\",\"\",VLOOKUP(K39,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z39=\"\",\"\",VLOOKUP(Z39,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG39=\"\",\"\",VLOOKUP(AG39,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H40=\"\",\"\",VLOOKUP(H40,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K40=\"\",\"\",VLOOKUP(K40,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z40=\"\",\"\",VLOOKUP(Z40,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG40=\"\",\"\",VLOOKUP(AG40,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H41=\"\",\"\",VLOOKUP(H41,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K41=\"\",\"\",VLOOKUP(K41,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z41=\"\",\"\",VLOOKUP(Z41,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG41=\"\",\"\",VLOOKUP(AG41,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H42=\"\",\"\",VLOOKUP(H42,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K42=\"\",\"\",VLOOKUP(K42,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z42=\"\",\"\",VLOOKUP(Z42,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG42=\"\",\"\",VLOOKUP(AG42,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H43=\"\",\"\",VLOOKUP(H43,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K43=\"\",\"\",VLOOKUP(K43,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z43=\"\",\"\",VLOOKUP(Z43,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG43=\"\",\"\",VLOOKUP(AG43,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H44=\"\",\"\",VLOOKUP(H44,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K44=\"\",\"\",VLOOKUP(K44,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z44=\"\",\"\",VLOOKUP(Z44,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG44=\"\",\"\",VLOOKUP(AG44,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H45=\"\",\"\",VLOOKUP(H45,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K45=\"\",\"\",VLOOKUP(K45,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z45=\"\",\"\",VLOOKUP(Z45,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG45=\"\",\"\",VLOOKUP(AG45,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H46=\"\",\"\",VLOOKUP(H46,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K46=\"\",\"\",VLOOKUP(K46,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z46=\"\",\"\",VLOOKUP(Z46,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG46=\"\",\"\",VLOOKUP(AG46,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H47=\"\",\"\",VLOOKUP(H47,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K47=\"\",\"\",VLOOKUP(K47,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z47=\"\",\"\",VLOOKUP(Z47,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG47=\"\",\"\",VLOOKUP(AG47,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H48=\"\",\"\",VLOOKUP(H48,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K48=\"\",\"\",VLOOKUP(K48,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z48=\"\",\"\",VLOOKUP(Z48,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG48=\"\",\"\",VLOOKUP(AG48,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H49=\"\",\"\",VLOOKUP(H49,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K49=\"\",\"\",VLOOKUP(K49,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z49=\"\",\"\",VLOOKUP(Z49,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG49=\"\",\"\",VLOOKUP(AG49,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H50=\"\",\"\",VLOOKUP(H50,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K50=\"\",\"\",VLOOKUP(K50,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z50=\"\",\"\",VLOOKUP(Z50,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG50=\"\",\"\",VLOOKUP(AG50,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H51=\"\",\"\",VLOOKUP(H51,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K51=\"\",\"\",VLOOKUP(K51,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z51=\"\",\"\",VLOOKUP(Z51,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG51=\"\",\"\",VLOOKUP(AG51,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H52=\"\",\"\",VLOOKUP(H52,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K52=\"\",\"\",VLOOKUP(K52,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z52=\"\",\"\",VLOOKUP(Z52,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG52=\"\",\"\",VLOOKUP(AG52,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H53=\"\",\"\",VLOOKUP(H53,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K53=\"\",\"\",VLOOKUP(K53,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z53=\"\",\"\",VLOOKUP(Z53,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG53=\"\",\"\",VLOOKUP(AG53,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H54=\"\",\"\",VLOOKUP(H54,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K54=\"\",\"\",VLOOKUP(K54,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z54=\"\",\"\",VLOOKUP(Z54,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG54=\"\",\"\",VLOOKUP(AG54,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H55=\"\",\"\",VLOOKUP(H55,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K55=\"\",\"\",VLOOKUP(K55,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z55=\"\",\"\",VLOOKUP(Z55,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG55=\"\",\"\",VLOOKUP(AG55,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H56=\"\",\"\",VLOOKUP(H56,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K56=\"\",\"\",VLOOKUP(K56,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z56=\"\",\"\",VLOOKUP(Z56,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG56=\"\",\"\",VLOOKUP(AG56,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H57=\"\",\"\",VLOOKUP(H57,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K57=\"\",\"\",VLOOKUP(K57,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z57=\"\",\"\",VLOOKUP(Z57,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG57=\"\",\"\",VLOOKUP(AG57,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H58=\"\",\"\",VLOOKUP(H58,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K58=\"\",\"\",VLOOKUP(K58,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z58=\"\",\"\",VLOOKUP(Z58,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG58=\"\",\"\",VLOOKUP(AG58,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H59=\"\",\"\",VLOOKUP(H59,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K59=\"\",\"\",VLOOKUP(K59,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z59=\"\",\"\",VLOOKUP(Z59,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG59=\"\",\"\",VLOOKUP(AG59,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H60=\"\",\"\",VLOOKUP(H60,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K60=\"\",\"\",VLOOKUP(K60,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z60=\"\",\"\",VLOOKUP(Z60,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG60=\"\",\"\",VLOOKUP(AG60,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H61=\"\",\"\",VLOOKUP(H61,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K61=\"\",\"\",VLOOKUP(K61,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z61=\"\",\"\",VLOOKUP(Z61,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG61=\"\",\"\",VLOOKUP(AG61,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H62=\"\",\"\",VLOOKUP(H62,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K62=\"\",\"\",VLOOKUP(K62,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z62=\"\",\"\",VLOOKUP(Z62,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG62=\"\",\"\",VLOOKUP(AG62,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H63=\"\",\"\",VLOOKUP(H63,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K63=\"\",\"\",VLOOKUP(K63,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z63=\"\",\"\",VLOOKUP(Z63,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG63=\"\",\"\",VLOOKUP(AG63,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H64=\"\",\"\",VLOOKUP(H64,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K64=\"\",\"\",VLOOKUP(K64,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z64=\"\",\"\",VLOOKUP(Z64,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG64=\"\",\"\",VLOOKUP(AG64,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H65=\"\",\"\",VLOOKUP(H65,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K65=\"\",\"\",VLOOKUP(K65,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z65=\"\",\"\",VLOOKUP(Z65,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG65=\"\",\"\",VLOOKUP(AG65,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H66=\"\",\"\",VLOOKUP(H66,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K66=\"\",\"\",VLOOKUP(K66,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z66=\"\",\"\",VLOOKUP(Z66,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG66=\"\",\"\",VLOOKUP(AG66,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H67=\"\",\"\",VLOOKUP(H67,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K67=\"\",\"\",VLOOKUP(K67,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z67=\"\",\"\",VLOOKUP(Z67,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG67=\"\",\"\",VLOOKUP(AG67,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H68=\"\",\"\",VLOOKUP(H68,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K68=\"\",\"\",VLOOKUP(K68,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z68=\"\",\"\",VLOOKUP(Z68,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG68=\"\",\"\",VLOOKUP(AG68,recycle_component[],2,FALSE))","v":""}]
[{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&C69&\"/\"&D69&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},{"$f":"_xlfn.FILTERXML(_xlfn.WEBSERVICE(\"https://nds-beta.mobileroad.org/xy_sh?rp=\"&C69&\"/\"&E69&\"&xml=true\"),\"/lrms/id_road\")","v":"null"},null,null,null,null,null,null,{"$f":"IF(H69=\"\",\"\",VLOOKUP(H69,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K69=\"\",\"\",VLOOKUP(K69,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z69=\"\",\"\",VLOOKUP(Z69,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG69=\"\",\"\",VLOOKUP(AG69,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H70=\"\",\"\",VLOOKUP(H70,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K70=\"\",\"\",VLOOKUP(K70,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z70=\"\",\"\",VLOOKUP(Z70,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG70=\"\",\"\",VLOOKUP(AG70,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H71=\"\",\"\",VLOOKUP(H71,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K71=\"\",\"\",VLOOKUP(K71,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z71=\"\",\"\",VLOOKUP(Z71,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG71=\"\",\"\",VLOOKUP(AG71,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H72=\"\",\"\",VLOOKUP(H72,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K72=\"\",\"\",VLOOKUP(K72,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z72=\"\",\"\",VLOOKUP(Z72,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG72=\"\",\"\",VLOOKUP(AG72,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H73=\"\",\"\",VLOOKUP(H73,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K73=\"\",\"\",VLOOKUP(K73,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z73=\"\",\"\",VLOOKUP(Z73,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG73=\"\",\"\",VLOOKUP(AG73,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H74=\"\",\"\",VLOOKUP(H74,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K74=\"\",\"\",VLOOKUP(K74,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z74=\"\",\"\",VLOOKUP(Z74,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG74=\"\",\"\",VLOOKUP(AG74,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H75=\"\",\"\",VLOOKUP(H75,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K75=\"\",\"\",VLOOKUP(K75,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z75=\"\",\"\",VLOOKUP(Z75,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG75=\"\",\"\",VLOOKUP(AG75,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H76=\"\",\"\",VLOOKUP(H76,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K76=\"\",\"\",VLOOKUP(K76,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z76=\"\",\"\",VLOOKUP(Z76,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG76=\"\",\"\",VLOOKUP(AG76,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H77=\"\",\"\",VLOOKUP(H77,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K77=\"\",\"\",VLOOKUP(K77,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z77=\"\",\"\",VLOOKUP(Z77,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG77=\"\",\"\",VLOOKUP(AG77,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H78=\"\",\"\",VLOOKUP(H78,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K78=\"\",\"\",VLOOKUP(K78,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z78=\"\",\"\",VLOOKUP(Z78,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG78=\"\",\"\",VLOOKUP(AG78,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H79=\"\",\"\",VLOOKUP(H79,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K79=\"\",\"\",VLOOKUP(K79,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z79=\"\",\"\",VLOOKUP(Z79,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG79=\"\",\"\",VLOOKUP(AG79,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H80=\"\",\"\",VLOOKUP(H80,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K80=\"\",\"\",VLOOKUP(K80,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z80=\"\",\"\",VLOOKUP(Z80,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG80=\"\",\"\",VLOOKUP(AG80,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H81=\"\",\"\",VLOOKUP(H81,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K81=\"\",\"\",VLOOKUP(K81,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z81=\"\",\"\",VLOOKUP(Z81,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG81=\"\",\"\",VLOOKUP(AG81,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H82=\"\",\"\",VLOOKUP(H82,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K82=\"\",\"\",VLOOKUP(K82,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z82=\"\",\"\",VLOOKUP(Z82,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG82=\"\",\"\",VLOOKUP(AG82,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H83=\"\",\"\",VLOOKUP(H83,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K83=\"\",\"\",VLOOKUP(K83,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z83=\"\",\"\",VLOOKUP(Z83,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG83=\"\",\"\",VLOOKUP(AG83,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H84=\"\",\"\",VLOOKUP(H84,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K84=\"\",\"\",VLOOKUP(K84,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z84=\"\",\"\",VLOOKUP(Z84,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG84=\"\",\"\",VLOOKUP(AG84,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H85=\"\",\"\",VLOOKUP(H85,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K85=\"\",\"\",VLOOKUP(K85,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z85=\"\",\"\",VLOOKUP(Z85,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG85=\"\",\"\",VLOOKUP(AG85,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H86=\"\",\"\",VLOOKUP(H86,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K86=\"\",\"\",VLOOKUP(K86,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z86=\"\",\"\",VLOOKUP(Z86,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG86=\"\",\"\",VLOOKUP(AG86,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H87=\"\",\"\",VLOOKUP(H87,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K87=\"\",\"\",VLOOKUP(K87,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z87=\"\",\"\",VLOOKUP(Z87,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG87=\"\",\"\",VLOOKUP(AG87,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H88=\"\",\"\",VLOOKUP(H88,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K88=\"\",\"\",VLOOKUP(K88,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z88=\"\",\"\",VLOOKUP(Z88,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG88=\"\",\"\",VLOOKUP(AG88,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H89=\"\",\"\",VLOOKUP(H89,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K89=\"\",\"\",VLOOKUP(K89,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z89=\"\",\"\",VLOOKUP(Z89,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG89=\"\",\"\",VLOOKUP(AG89,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H90=\"\",\"\",VLOOKUP(H90,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K90=\"\",\"\",VLOOKUP(K90,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z90=\"\",\"\",VLOOKUP(Z90,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG90=\"\",\"\",VLOOKUP(AG90,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H91=\"\",\"\",VLOOKUP(H91,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K91=\"\",\"\",VLOOKUP(K91,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z91=\"\",\"\",VLOOKUP(Z91,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG91=\"\",\"\",VLOOKUP(AG91,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H92=\"\",\"\",VLOOKUP(H92,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K92=\"\",\"\",VLOOKUP(K92,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z92=\"\",\"\",VLOOKUP(Z92,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG92=\"\",\"\",VLOOKUP(AG92,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H93=\"\",\"\",VLOOKUP(H93,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K93=\"\",\"\",VLOOKUP(K93,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z93=\"\",\"\",VLOOKUP(Z93,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG93=\"\",\"\",VLOOKUP(AG93,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H94=\"\",\"\",VLOOKUP(H94,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K94=\"\",\"\",VLOOKUP(K94,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z94=\"\",\"\",VLOOKUP(Z94,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG94=\"\",\"\",VLOOKUP(AG94,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H95=\"\",\"\",VLOOKUP(H95,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K95=\"\",\"\",VLOOKUP(K95,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z95=\"\",\"\",VLOOKUP(Z95,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG95=\"\",\"\",VLOOKUP(AG95,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H96=\"\",\"\",VLOOKUP(H96,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K96=\"\",\"\",VLOOKUP(K96,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z96=\"\",\"\",VLOOKUP(Z96,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG96=\"\",\"\",VLOOKUP(AG96,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H97=\"\",\"\",VLOOKUP(H97,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K97=\"\",\"\",VLOOKUP(K97,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z97=\"\",\"\",VLOOKUP(Z97,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG97=\"\",\"\",VLOOKUP(AG97,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H98=\"\",\"\",VLOOKUP(H98,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K98=\"\",\"\",VLOOKUP(K98,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z98=\"\",\"\",VLOOKUP(Z98,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG98=\"\",\"\",VLOOKUP(AG98,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H99=\"\",\"\",VLOOKUP(H99,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K99=\"\",\"\",VLOOKUP(K99,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z99=\"\",\"\",VLOOKUP(Z99,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG99=\"\",\"\",VLOOKUP(AG99,recycle_component[],2,FALSE))","v":""}]
["null","null",null,null,null,null,null,null,{"$f":"IF(H100=\"\",\"\",VLOOKUP(H100,pavement_material[],2,FALSE))","v":""},null,null,{"$f":"IF(K100=\"\",\"\",VLOOKUP(K100,pavement_specification[],2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z100=\"\",\"\",VLOOKUP(Z100,asset_owner[],2,FALSE))","v":""},null,null,null,null,null,null,{"$f":"IF(AG100=\"\",\"\",VLOOKUP(AG100,recycle_component[],2,FALSE))","v":""}]

{"sheet":"Lookups","index":1,"n_rows":256,"n_cols":41,"rows_kept":256,"cut":false,"hidden":false,"merged":[]}
["contract name",null,"layer type",null,"pavement material description","pavement material",null,"pavement subgrade",null,"pavement specification description","pavement specification",null,"pavement source",null,"messure type",null,"accuracy",null,"asset owner description","asset owner",null,"work origin",null,"work category",null,"recycle component description","recycle component",null,"reconstructed",null,"stabilising agent 1",null,"stabilising agent 2",null,"stabilising agent 3",null,"pavement treatment",null,"What happened to the existing layer?",null,"Existing layer become composite layer?"]
["(AMA) AUCK ALLIANCE",null,"L",null,"Dense graded asphalt AC10 (M/10)","ACM10",null,"ASH",null,"Unbound Granular Pavement","B2",null,"AHAURA",null,"CBR",null,"Estimate",null,"Crown","C",null,"AC Inlay",null,"111 - Sealed Pavement Maintenance",null,"Crumb Rubber","CRBR",null,"R",null,"BITUMEN",null,"BITUMEN",null,"BITUMEN",null,"Straight Overlay",null,"Undisturbed",null,"Yes"]
["(EC) Marlborough",null,"S",null,"Dense graded asphalt AC14 (M/10)","ACM14",null,"BOULDERS",null,"Performance Spec - Unbound Granular Pavements","B3",null,"ALEXANDRA",null,"UCS",null,"Known",null,"Local Authority","L",null,"Basecourse Overlay",null,"140 - Minor Events",null,"Glass","GLAS",null,"U",null,"BITUMEN/KILN DUST",null,"BITUMEN/KILN DUST",null,"BITUMEN/KILN DUST",null,"Insitu Stabilise",null,"Reconstructed (full or partial depth)",null,"No"]
["(EC) West Waikato North",null,null,null,"Dense graded asphalt AC20 (M/10)","ACM20",null,"CLAY",null,"Performance Spec - In-situ Stabilisation of Modified Pavement Layers","B5",null,"APARIMA - L",null,null,null,null,null,"Private","P",null,"Customer LoS roughness maintenance",null,"141 - Emergency Works",null,"Marginal Aggregate","MA",null,null,null,"CEMENT",null,"CEMENT",null,"CEMENT",null,"Overlay & Insitu Stabilise",null,"Removed (full or partial depth)"]
["(EC) West Waikato South",null,null,null,"Dense graded asphalt AC28 (M/10)","ACM28",null,"CLAY - CH",null,"Specification for Manufacture and Construction of Plant Mixed Modified Pave","B7",null,"APARIMA - U",null,null,null,null,null,null,null,null,"Customer LoS rutting maintenance",null,"212 - Sealed Road Resurfacing",null,"Reclaimed Asphaltic Pavement","RAP",null,null,null,"CEMENT/BITUMEN",null,"CEMENT/BITUMEN",null,"CEMENT/BITUMEN",null,"Insitu & Overlay"]
["(NOC) BOP East",null,null,null,"Aggregate","AGG",null,"CLAY - CL",null,"Specification for dense graded and stone mastic asphalts.","M10",null,"ARAPAE",null,null,null,null,null,null,null,null,"Cycling facilities",null,"214 - Sealed Road Pavement Rehabilitation",null,"Slag","SLAG",null,null,null,"CEMENT/KILN DUST",null,"CEMENT/KILN DUST",null,"CEMENT/KILN DUST",null,"Remove & Replace"]
["(NOC) BOP West",null,null,null,"All passing 100mm sieve","AP100",null,"GRAVEL",null,"No specification - layer laid prior to specifications","PAST",null,"ASHBURTON",null,null,null,null,null,null,null,null,"Efficiency",null,"322 - Replacement of Bridges and Other Structures",null,null,null,null,null,null,"CEMENT/LIME",null,"CEMENT/LIME",null,"CEMENT/LIME",null,"Structural AC"]
["(NOC) Central Waikato",null,null,null,"All passing 150mm sieve","AP150",null,"GRAVEL - GC",null,null,null,null,"ASHBURTON RIVER",null,null,null,null,null,null,null,null,"Emergency works",null,"323 - New Roads",null,null,null,null,null,null,"CEMENT/LIME/BITUMEN",null,"CEMENT/LIME/BITUMEN",null,"CEMENT/LIME/BITUMEN"]
["(NOC) Coastal Otago",null,null,null,"All passing 20mm sieve","AP20",null,"GRAVEL - GM",null,null,null,null,"ASHHURST",null,null,null,null,null,null,null,null,"Foam Bitumen Stabilisation",null,"324 - Road Improvements",null,null,null,null,null,null,"CEMENT/LIME/KILN D.",null,"CEMENT/LIME/KILN D.",null,"CEMENT/LIME/KILN D."]
["(NOC) East Waikato",null,null,null,"All passing 40mm sieve","AP40",null,"GRAVEL - GP",null,null,null,null,"AWAKERI",null,null,null,null,null,null,null,null,"Full Replacement",null,"325 - Seal Extension",null,null,null,null,null,null,"DURABIND",null,"DURABIND",null,"DURABIND"]
["(NOC) Hawkes Bay",null,null,null,"M/4 Spec AP 40 - Low Fines","AP40LF",null,"GRAVEL - GW",null,null,null,null,"AWAPUNI",null,null,null,null,null,null,null,null,"Granular Replacement",null,"341 - Low cost, low risk roading improvements",null,null,null,null,null,null,"DURATINE",null,"DURATINE",null,"DURATINE"]
["(NOC) Manawatu Wanganui",null,null,null,"All passing 50mm sieve","AP50",null,"ORGANIC",null,null,null,null,"AWATERE",null,null,null,null,null,null,null,null,"Heavy Duty Maintenance - NPV option",null,"357 - Resilience Improvements",null,null,null,null,null,null,"KILN DUST",null,"KILN DUST",null,"KILN DUST"]
["(NOC) Nelson-Tasman",null,null,null,"All passing 65mm sieve","AP65",null,"ORGANIC - OH",null,null,null,null,"AWATOTO",null,null,null,null,null,null,null,null,"Minor events",null,"451 - Walking Facilities",null,null,null,null,null,null,"LIME",null,"LIME",null,"LIME"]
["(NOC) NORTH CANTERBURY",null,null,null,"All passing 7mm sieve","AP7",null,"ORGANIC - OL",null,null,null,null,"BALCLUTHA",null,null,null,null,null,null,null,null,"New roads",null,"452 - Cycling Facilities",null,null,null,null,null,null,"LIME/BITUMEN",null,"LIME/BITUMEN",null,"LIME/BITUMEN"]
["(NOC) Northland",null,null,null,"All passing 75mm sieve","AP75",null,"PEAT",null,null,null,null,"BALDROCK",null,null,null,null,null,null,null,null,"Pavement Preservation",null,"998 - Unfunded Third Party Work",null,null,null,null,null,null,"LIME/BITUMEN/KILN D.",null,"LIME/BITUMEN/KILN D.",null,"LIME/BITUMEN/KILN D."]
["(NOC) Otago Central",null,null,null,"Boulders - Uncrushed Random","BOLDER",null,"PUMICE",null,null,null,null,"BARTLETTS",null,null,null,null,null,null,null,null,"Principal's Risk Non-routine maintenance",null,"999 - Unfunded Rework",null,null,null,null,null,null,"LIME/KILN DUST",null,"LIME/KILN DUST",null,"LIME/KILN DUST"]
["(NOC) South Canterbury",null,null,null,"Bridge Deck","BRIDGE",null,"PUMICE/ASH",null,null,null,null,"BEATSONS",null,null,null,null,null,null,null,null,"Recycle",null,null,null,null,null,null,null,null,"OTHER",null,"OTHER",null,"OTHER"]
["(NOC) Southland",null,null,null,"Composite of different recycle","COMP",null,"ROCK",null,null,null,null,"BELMONT",null,null,null,null,null,null,null,null,"Replacement of bridges and other structures"]
["(NOC) Tairawhiti Roads Northern",null,null,null,"Old Concrete Surface","CONC",null,"SAND",null,null,null,null,"BERRYS",null,null,null,null,null,null,null,null,"Resilience"]
["(NOC) Tairawhiti Roads Western",null,null,null,"Crusher Run","CR",null,"SAND - SC",null,null,null,null,"BLACK MARBLE",null,null,null,null,null,null,null,null,"Resilience improvements"]
["(NOC) Taranaki",null,null,null,"Dense graded asphalt DG10 (M/10)","DG10",null,"SAND - SM",null,null,null,null,"BLACKHEAD",null,null,null,null,null,null,null,null,"Road improvements"]
["(NOC) Wellington",null,null,null,"Dense graded asphalt DG14 (M/10)","DG14",null,"SAND - SP",null,null,null,null,"BLUEROCK",null,null,null,null,null,null,null,null,"Routine Maintenance"]
["(NOC) West Coast",null,null,null,"Dense graded asphalt DG20 (M/10)","DG20",null,"SAND - SW",null,null,null,null,"BOMBAY MILB",null,null,null,null,null,null,null,null,"Safety"]
["Milford",null,null,null,"Dense graded asphalt DG28 (M/10)","DG28",null,"SILT",null,null,null,null,"BOULDER CREEK",null,null,null,null,null,null,null,null,"Seal extension"]
[null,null,null,null,"Class 2 High Modulus Asphalt","EME2",null,"SILT - MH",null,null,null,null,"BOYLE RIVER",null,null,null,null,null,null,null,null,"Stabilisation Inlay (Rip & Remake)"]
[null,null,null,null,"Emulsion Treated Basecourse","ETB",null,"SILT - ML",null,null,null,null,"BRIXTON",null,null,null,null,null,null,null,null,"Unfunded rework"]
[null,null,null,null,"Fabric","FABRIC",null,"VOLCANIC",null,null,null,null,"BROOKBY",null,null,null,null,null,null,null,null,"Unfunded third party work"]
[null,null,null,null,"Foam Bitumen Stabilised","FBS",null,null,null,null,null,null,"BULLOCK",null,null,null,null,null,null,null,null,"Walking facilities"]
[null,null,null,null,"Granular fill","FILL",null,null,null,null,null,null,"BULLS_HIG"]
[null,null,null,null,"Filter cloth","FILTER",null,null,null,null,null,null,"CAMPION ROAD"]
[null,null,null,null,"Graded all passing 100mm sieve","GAP100",null,null,null,null,null,null,"CASS RIVER"]
[null,null,null,null,"Graded all passing 150mm sieve","GAP150",null,null,null,null,null,null,"COOKS ROAD"]
[null,null,null,null,"Graded all passing 20mm sieve","GAP20",null,null,null,null,null,null,"CORBETT ROAD"]
[null,null,null,null,"Graded all passing 40mm sieve","GAP40",null,null,null,null,null,null,"COUTTS ISL"]
[null,null,null,null,"Graded all passing 65mm sieve","GAP65",null,null,null,null,null,null,"CRAWFORD PIT"]
[null,null,null,null,"Graded all passing 7mm sieve","GAP7",null,null,null,null,null,null,"DANNEVIRKE"]
[null,null,null,null,"High Fatigue Dense Graded Asphalt AC10 (M/10)","HFAC10",null,null,null,null,null,null,"DAVIES"]
[null,null,null,null,"High Fatigue Dense Graded Asphalt AC14 (M/10)","HFAC14",null,null,null,null,null,null,"DESERT ROAD"]
[null,null,null,null,"High Fatigue Dense Graded Asphalt AC20 (M/10)","HFAC20",null,null,null,null,null,null,"DOUGHERTYS"]
[null,null,null,null,"High Fatigue Dense Graded Asphalt AC28 (M/10)","HFAC28",null,null,null,null,null,null,"DRURY/STEV"]
[null,null,null,null,"Hi-Lab all passing 40mm sieve","HLAB40",null,null,null,null,null,null,"EARNSCLEUGH"]
[null,null,null,null,"Hi-Lab all passing 50mm sieve","HLAB50",null,null,null,null,null,null,"EX TOKAANU"]
[null,null,null,null,"Hi-Lab all passing 65mm sieve","HLAB65",null,null,null,null,null,null,"EXPOSED EXISTING"]
[null,null,null,null,"Lime Rock","LIME",null,null,null,null,null,null,"FALCONERS"]
[null,null,null,null,"M3 Specification","M3",null,null,null,null,null,null,"FERNIEHURST"]
[null,null,null,null,"M4 Specification","M4",null,null,null,null,null,null,"FLAXMORE"]
[null,null,null,null,"M/4 Spec. All passing 20mm","M4AP20",null,null,null,null,null,null,"FRASER"]
[null,null,null,null,"M/4 Spec. All passing 40mm","M4AP40",null,null,null,null,null,null,"FRASR-ASHBRTN BLEND"]
[null,null,null,null,"M/5 Spec. AP40","M5AP40",null,null,null,null,null,null,"GLADSTONE"]
[null,null,null,null,"M/5 Spec. Gisborne 1","M5GIS1",null,null,null,null,null,null,"GLENBROOK"]
[null,null,null,null,"M/5 Spec. Gisborne 2","M5GIS2",null,null,null,null,null,null,"GORE"]
[null,null,null,null,"M/5 Spec. Rotorua 1","M5ROT1",null,null,null,null,null,null,"GREENHILLS"]
[null,null,null,null,"Subbase NRB B/2 Spec.","NRB B2",null,null,null,null,null,null,"HALLIWELLS"]
[null,null,null,null,"OGEM MIX 5 O/L","PM146",null,null,null,null,null,null,"HALLS_RD"]
[null,null,null,null,"PEACOCKS WHAP","PM148",null,null,null,null,null,null,"HAPUKU RIVER"]
[null,null,null,null,"PREMIX","PM155",null,null,null,null,null,null,"HARTSTONES"]
[null,null,null,null,"Pit Run","PR",null,null,null,null,null,null,"HILDERTHORPE"]
[null,null,null,null,"Rock","ROCK",null,null,null,null,null,null,"HOGGS_RD"]
[null,null,null,null,"Run of Pit - Graded Max 500mm","ROP500",null,null,null,null,null,null,"HONGEAKA Q"]
[null,null,null,null,"Run of River - Graded Max 300mm","ROR300",null,null,null,null,null,null,"HOROKIWI QUARRIES"]
[null,null,null,null,"Run of River - Graded Max 500mm","ROR500",null,null,null,null,null,null,"HOROMANGA RIVER"]
[null,null,null,null,"Rotten Rock","ROT",null,null,null,null,null,null,"HUANGARUA PONATAHI"]
[null,null,null,null,"River Run","RR",null,null,null,null,null,null,"HUNTLY QUA"]
[null,null,null,null,"Sand Filter/Drainage Layer","SAND",null,null,null,null,null,null,"HUNUA/WINST"]
[null,null,null,null,"Scoria all passing 100mm sieve","SAP100",null,null,null,null,null,null,"HURUNUI RIVER SH7"]
[null,null,null,null,"Scoria all passing 150mm sieve","SAP150",null,null,null,null,null,null,"HYNDMANS"]
[null,null,null,null,"Scoria all passing 20mm sieve","SAP20",null,null,null,null,null,null,"INGLEWOOD"]
[null,null,null,null,"Scoria all passing 40mm sieve","SAP40",null,null,null,null,null,null,"ISLAND BLOCK"]
[null,null,null,null,"Scoria all passing 65mm sieve","SAP65",null,null,null,null,null,null,"JOHNSONS"]
[null,null,null,null,"Scoria all passing 7mm sieve","SAP7",null,null,null,null,null,null,"KAIK RD"]
[null,null,null,null,"Old seals","SEALS",null,null,null,null,null,null,"KAIPARA"]
[null,null,null,null,"Shell","SHELL",null,null,null,null,null,null,"KAKANUI"]
[null,null,null,null,"Quarry Strippings - Ungraded","STRIP",null,null,null,null,null,null,"KAKARIKI_HIG"]
[null,null,null,null,"Topcourse","T/C",null,null,null,null,null,null,"KARAKATUWHERO RIVER"]
[null,null,null,null,"Works Hamilton Graded AP20","WHAP20",null,null,null,null,null,null,"KATIKATI"]
[null,null,null,null,"Works Hamilton Graded AP40","WHAP40",null,null,null,null,null,null,"KB QUARRIES"]
[null,null,null,null,"Works Hamilton Graded AP65","WHAP65",null,null,null,null,null,null,"KCEC"]
[null,null,null,null,null,null,null,null,null,null,null,null,"KIWI POINT QUARRY"]
[null,null,null,null,null,null,null,null,null,null,null,null,"KOWAI RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"KOWAI RIVER #2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"KOWHAI RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"KYEBURN"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LARMERS ROAD"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LAWS ROAD"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LEVELS PIT"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LINTON"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LOGAN PT"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LONGBURN"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LOWBURN"]
[null,null,null,null,null,null,null,null,null,null,null,null,"LWR GLENN RD"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MANGAMAIRE"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MANGATAWHIRI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MANUNUI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MATAKANA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MATAMATA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MATATOKI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MATAURA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MATAURA - G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MATAURA - R"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MATAWAI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MCARTHURS RD"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MCBETH"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MCCALLUMS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MCCLOUDS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MCGREGORS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MCGREGORS WHITESTONE"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MCLEANS ISLAND"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MEREMERE"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MILFORD - DWB"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MILLBROOK PAKIRI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MILLBROOK WAIPU"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MINERS RD"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MOHAKA - SH2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MOHAKA AGG"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MOHARA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MOTU"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MOTUEKA RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MOUTOHORA RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MT HERBERT"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MURCHISON"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MUTTONTOWN"]
[null,null,null,null,null,null,null,null,null,null,null,null,"NGARUAWAHIA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"NGARURONO"]
[null,null,null,null,null,null,null,null,null,null,null,null,"NGARURORO"]
[null,null,null,null,null,null,null,null,null,null,null,null,"NIREMU RD"]
[null,null,null,null,null,null,null,null,null,null,null,null,"OHAU A"]
[null,null,null,null,null,null,null,null,null,null,null,null,"OKETE"]
[null,null,null,null,null,null,null,null,null,null,null,null,"OMARAMA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"OPIHI RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ORARI RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ORETI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ORETI - LOW"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ORETI - LUMS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ORETI - MID"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ORETI - MOSS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ORETI - WINT"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ORETI-B"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ORINGI #1"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ORINGI #2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ORINGI #3"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ORUAKERETAKI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"OSTERNS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"OTAIKA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"OTAIO RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"OTAKI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"OTOROHANGA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"OTUREHUA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PACIFIC STEEL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PAHIATUA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PANGATOTARA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PAREORA SH1"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PARKBURN_DNZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PARKBURN_FUL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PATUTAHI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PEACOCKS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PELORUS RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PIOPIO"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PIROA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"POIHIPI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"POPLAR LANE"]
[null,null,null,null,null,null,null,null,null,null,null,null,"POUND RD"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PUHIPUHI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PUHUNUI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PUKEHOU"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PUKEKAWA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PUKEPOTO"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PUKETAPU"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PUKETONA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PUKINUI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"RAINBOW MOUNTAIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,"RAKAIA MCKAYS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"RAKAIA SOMERTON"]
[null,null,null,null,null,null,null,null,null,null,null,null,"RANGITIKEI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"RANGRRBULL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"RECYCLED EXISTING"]
[null,null,null,null,null,null,null,null,null,null,null,null,"REIDS ROAD"]
[null,null,null,null,null,null,null,null,null,null,null,null,"RENWICK"]
[null,null,null,null,null,null,null,null,null,null,null,null,"RIDGE ROAD"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ROXBURGH"]
[null,null,null,null,null,null,null,null,null,null,null,null,"RUAMAHANGA RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SADDLE HILL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SANDFORD"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SELWYN RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SIDDS RD"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SMYTHES"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SNEE ROAD"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SPIERS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"STAPLES"]
[null,null,null,null,null,null,null,null,null,null,null,null,"T NICHOLS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TAHUNA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TAIRUA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TAMAKI RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TAOTAOROA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TAPUWAE QUARRY"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TARAMAKAU RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TAUHARA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TAUHEI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TAUHERENIK"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TAUHERENIKAU SH53"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TAUMARANUI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TE KUITI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TE MATA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TE MATAI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TE MOANA RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TE RANGIITA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TE RANGITA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TE RIMU"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TEKUITIM/S"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TEMPLETONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TETLEYS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TIROHIA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TITOKI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TOETOE"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TURIWIRI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TWIZEL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAERENGA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAI BIT"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAIAPU RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAIAU"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAIAU RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAIAU RIVER LOCHIEL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAIAU-CLIF"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAIKANAE RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAIMAKARIRI RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAIMEA RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAINGAWA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAIOEKA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAIOHINE RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAIPA METAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAIPARA RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAIPAWA RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAIRATA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAIRAU_GIL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAIRAU-SH63"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAIROA RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAITAWHETA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAITOMO DC"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAIWHAKAIHO"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WAOTU"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WATTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WEDDINGS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WERI"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WEST EWEBURN"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WHANGAEHU RIVER"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WHANGAMATA METAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WHANGARIPO"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WHEATSHEAF"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WHITEHALL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WHITFORD QUARRY"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WHITIANGA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WINDY POINT"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WIREMU RD"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WIREMU ROAD NORTH"]
[null,null,null,null,null,null,null,null,null,null,null,null,"WIREMU ROAD SOUTH"]
[null,null,null,null,null,null,null,null,null,null,null,null,"YORK QUARRY"]
[null,null,null,null,null,null,null,null,null,null,null,null,"YORK ROAD"]