{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sch B.6","Instructions","LookUps"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":20,"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":"Sch B.6","index":0,"n_rows":144,"n_cols":23,"rows_kept":144,"cut":false,"hidden":false,"merged":[[8,13,9,14],[8,15,9,17],[4,8,4,10],[28,3,32,10],[8,9,8,12],[9,9,9,10],[9,11,9,12]]}
["2020 Coast Crown Tenure Management Cost Survey Template",null,null,null,null,"Use only this spreadsheet for your submission  "]
["Ministry of Forests, Lands & Natural Resource Operations & Rural Development, Timber Pricing Branch ",null,null,null,null,"Red Carats have been provided for guidance"]
["Schedule B.6",null,null,null,null,"Costs reflect NEW bridges at NEW locations "]
["Bridge Survey (BS)",null,null,null,null,"Fill in ALL columns "]
[null,null,"of",null,null,"Certification of Submitting Forest Professional",null,null,null,null,null,"(name of Forest Professional)"]
[null,null,null,"SHEETS (eg 1 of 5 sheets)"]
[]
[]
[null,"Please view message pane at end of row to ensure data has been entered correctly & Manually Save before closing file",null,null,null,null,null,null,null,"Superstructure",null,null,null,"Substructure",null,"Cost of Bridge ($)"]
[null,null,null,null,null,null,null,null,null,"Girder/Stringer",null,"Deck"]
["Line","Bridge Structure ID","District ","Company Operation Name \nor \nBCTS Business Area","EBM or Non-EBM","Road Name","Road Station","Bridge Type","Design Load Capacity \n(L60-L175)","Material","Length (m) ","Material ","Width (m)","Material  ","Height (m) ","Bridge Supply Cost ($)","Bridge Planning and Installation (Approach Works) ($)","Total Bridge Cost ($)"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table2[[#This Row],[Bridge Supply Cost ($)]]+Table2[[#This Row],[Bridge Planning and Installation (Approach Works) ($)]]","v":0},{"$f":"COUNTBLANK($B12:$R12)","v":16},{"$f":"_xlfn.IFS(AND(S12=0, U12=\"\"), \"Entry Complete\", AND(S12=0, U12<>\"\"), \"Entry Incomplete\", AND(S12>0, S12<16), \"Entry in progress\",S12=16, \"\")","v":""},{"$f":"IF(V12 <> \"\",V12, W12)","v":""},{"$f":"IF(AND(Table2[[#This Row],[Bridge Type]]=\"Log\", Table2[[#This Row],[Width (m)]] > 5.5),\"If Bridge Type is Log, Deck Width must be <= 5.5m\",\"\")","v":""},{"$f":"IF(AND(OR(Table2[[#This Row],[Bridge Type]]=(\"Permanent\"),Table2[[#This Row],[Bridge Type]]=(\"Portable\")), Table2[[#This Row],[Width (m)]] >4.9),\"If Bridge Type is Permanent/Portable, Deck Width must be <= 4.9m\",\"\")","v":""}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table2[[#This Row],[Bridge Supply Cost ($)]]+Table2[[#This Row],[Bridge Planning and Installation (Approach Works) ($)]]","v":0},{"$f":"COUNTBLANK($B13:$R13)","v":16},{"$f":"_xlfn.IFS(AND(S13=0, U13=\"\"), \"Entry Complete\", AND(S13=0, U13<>\"\"), \"Entry Incomplete\", AND(S13>0, S13<16), \"Entry in progress\",S13=16, \"\")","v":""},{"$f":"IF(V13 <> \"\",V13, W13)","v":""},{"$f":"IF(AND(Table2[[#This Row],[Bridge Type]]=\"Log\", Table2[[#This Row],[Width (m)]] > 5.5),\"If Bridge Type is Log, Deck Width must be <= 5.5m\",\"\")","v":""},{"$f":"IF(AND(OR(Table2[[#This Row],[Bridge Type]]=(\"Permanent\"),Table2[[#This Row],[Bridge Type]]=(\"Portable\")), Table2[[#This Row],[Width (m)]] >4.9),\"If Bridge Type is Permanent/Portable, Deck Width must be <= 4.9m\",\"\")","v":""}]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table2[[#This Row],[Bridge Supply Cost ($)]]+Table2[[#This Row],[Bridge Planning and Installation (Approach Works) ($)]]","v":0},16,"","",{"$f":"IF(AND(Table2[[#This Row],[Bridge Type]]=\"Log\", Table2[[#This Row],[Width (m)]] > 5.5),\"If Bridge Type is Log, Deck Width must be <= 5.5m\",\"\")","v":""},{"$f":"IF(AND(OR(Table2[[#This Row],[Bridge Type]]=(\"Permanent\"),Table2[[#This Row],[Bridge Type]]=(\"Portable\")), Table2[[#This Row],[Width (m)]] >4.9),\"If Bridge Type is Permanent/Portable, Deck Width must be <= 4.9m\",\"\")","v":""}]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table2[[#This Row],[Bridge Supply Cost ($)]]+Table2[[#This Row],[Bridge Planning and Installation (Approach Works) ($)]]","v":0},16,"","",{"$f":"IF(AND(Table2[[#This Row],[Bridge Type]]=\"Log\", Table2[[#This Row],[Width (m)]] > 5.5),\"If Bridge Type is Log, Deck Width must be <= 5.5m\",\"\")","v":""},{"$f":"IF(AND(OR(Table2[[#This Row],[Bridge Type]]=(\"Permanent\"),Table2[[#This Row],[Bridge Type]]=(\"Portable\")), Table2[[#This Row],[Width (m)]] >4.9),\"If Bridge Type is Permanent/Portable, Deck Width must be <= 4.9m\",\"\")","v":""}]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table2[[#This Row],[Bridge Supply Cost ($)]]+Table2[[#This Row],[Bridge Planning and Installation (Approach Works) ($)]]","v":0},16,"","",{"$f":"IF(AND(Table2[[#This Row],[Bridge Type]]=\"Log\", Table2[[#This Row],[Width (m)]] > 5.5),\"If Bridge Type is Log, Deck Width must be <= 5.5m\",\"\")","v":""},{"$f":"IF(AND(OR(Table2[[#This Row],[Bridge Type]]=(\"Permanent\"),Table2[[#This Row],[Bridge Type]]=(\"Portable\")), Table2[[#This Row],[Width (m)]] >4.9),\"If Bridge Type is Permanent/Portable, Deck Width must be <= 4.9m\",\"\")","v":""}]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table2[[#This Row],[Bridge Supply Cost ($)]]+Table2[[#This Row],[Bridge Planning and Installation (Approach Works) ($)]]","v":0},16,"","",{"$f":"IF(AND(Table2[[#This Row],[Bridge Type]]=\"Log\", Table2[[#This Row],[Width (m)]] > 5.5),\"If Bridge Type is Log, Deck Width must be <= 5.5m\",\"\")","v":""},{"$f":"IF(AND(OR(Table2[[#This Row],[Bridge Type]]=(\"Permanent\"),Table2[[#This Row],[Bridge Type]]=(\"Portable\")), Table2[[#This Row],[Width (m)]] >4.9),\"If Bridge Type is Permanent/Portable, Deck Width must be <= 4.9m\",\"\")","v":""}]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table2[[#This Row],[Bridge Supply Cost ($)]]+Table2[[#This Row],[Bridge Planning and Installation (Approach Works) ($)]]","v":0},16,"","",{"$f":"IF(AND(Table2[[#This Row],[Bridge Type]]=\"Log\", Table2[[#This Row],[Width (m)]] > 5.5),\"If Bridge Type is Log, Deck Width must be <= 5.5m\",\"\")","v":""},{"$f":"IF(AND(OR(Table2[[#This Row],[Bridge Type]]=(\"Permanent\"),Table2[[#This Row],[Bridge Type]]=(\"Portable\")), Table2[[#This Row],[Width (m)]] >4.9),\"If Bridge Type is Permanent/Portable, Deck Width must be <= 4.9m\",\"\")","v":""}]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table2[[#This Row],[Bridge Supply Cost ($)]]+Table2[[#This Row],[Bridge Planning and Installation (Approach Works) ($)]]","v":0},16,"","",{"$f":"IF(AND(Table2[[#This Row],[Bridge Type]]=\"Log\", Table2[[#This Row],[Width (m)]] > 5.5),\"If Bridge Type is Log, Deck Width must be <= 5.5m\",\"\")","v":""},{"$f":"IF(AND(OR(Table2[[#This Row],[Bridge Type]]=(\"Permanent\"),Table2[[#This Row],[Bridge Type]]=(\"Portable\")), Table2[[#This Row],[Width (m)]] >4.9),\"If Bridge Type is Permanent/Portable, Deck Width must be <= 4.9m\",\"\")","v":""}]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table2[[#This Row],[Bridge Supply Cost ($)]]+Table2[[#This Row],[Bridge Planning and Installation (Approach Works) ($)]]","v":0},16,"","",{"$f":"IF(AND(Table2[[#This Row],[Bridge Type]]=\"Log\", Table2[[#This Row],[Width (m)]] > 5.5),\"If Bridge Type is Log, Deck Width must be <= 5.5m\",\"\")","v":""},{"$f":"IF(AND(OR(Table2[[#This Row],[Bridge Type]]=(\"Permanent\"),Table2[[#This Row],[Bridge Type]]=(\"Portable\")), Table2[[#This Row],[Width (m)]] >4.9),\"If Bridge Type is Permanent/Portable, Deck Width must be <= 4.9m\",\"\")","v":""}]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table2[[#This Row],[Bridge Supply Cost ($)]]+Table2[[#This Row],[Bridge Planning and Installation (Approach Works) ($)]]","v":0},16,"","",{"$f":"IF(AND(Table2[[#This Row],[Bridge Type]]=\"Log\", Table2[[#This Row],[Width (m)]] > 5.5),\"If Bridge Type is Log, Deck Width must be <= 5.5m\",\"\")","v":""},{"$f":"IF(AND(OR(Table2[[#This Row],[Bridge Type]]=(\"Permanent\"),Table2[[#This Row],[Bridge Type]]=(\"Portable\")), Table2[[#This Row],[Width (m)]] >4.9),\"If Bridge Type is Permanent/Portable, Deck Width must be <= 4.9m\",\"\")","v":""}]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table2[[#This Row],[Bridge Supply Cost ($)]]+Table2[[#This Row],[Bridge Planning and Installation (Approach Works) ($)]]","v":0},16,"","",{"$f":"IF(AND(Table2[[#This Row],[Bridge Type]]=\"Log\", Table2[[#This Row],[Width (m)]] > 5.5),\"If Bridge Type is Log, Deck Width must be <= 5.5m\",\"\")","v":""},{"$f":"IF(AND(OR(Table2[[#This Row],[Bridge Type]]=(\"Permanent\"),Table2[[#This Row],[Bridge Type]]=(\"Portable\")), Table2[[#This Row],[Width (m)]] >4.9),\"If Bridge Type is Permanent/Portable, Deck Width must be <= 4.9m\",\"\")","v":""}]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table2[[#This Row],[Bridge Supply Cost ($)]]+Table2[[#This Row],[Bridge Planning and Installation (Approach Works) ($)]]","v":0},16,"","",{"$f":"IF(AND(Table2[[#This Row],[Bridge Type]]=\"Log\", Table2[[#This Row],[Width (m)]] > 5.5),\"If Bridge Type is Log, Deck Width must be <= 5.5m\",\"\")","v":""},{"$f":"IF(AND(OR(Table2[[#This Row],[Bridge Type]]=(\"Permanent\"),Table2[[#This Row],[Bridge Type]]=(\"Portable\")), Table2[[#This Row],[Width (m)]] >4.9),\"If Bridge Type is Permanent/Portable, Deck Width must be <= 4.9m\",\"\")","v":""}]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table2[[#This Row],[Bridge Supply Cost ($)]]+Table2[[#This Row],[Bridge Planning and Installation (Approach Works) ($)]]","v":0},16,"","",{"$f":"IF(AND(Table2[[#This Row],[Bridge Type]]=\"Log\", Table2[[#This Row],[Width (m)]] > 5.5),\"If Bridge Type is Log, Deck Width must be <= 5.5m\",\"\")","v":""},{"$f":"IF(AND(OR(Table2[[#This Row],[Bridge Type]]=(\"Permanent\"),Table2[[#This Row],[Bridge Type]]=(\"Portable\")), Table2[[#This Row],[Width (m)]] >4.9),\"If Bridge Type is Permanent/Portable, Deck Width must be <= 4.9m\",\"\")","v":""}]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table2[[#This Row],[Bridge Supply Cost ($)]]+Table2[[#This Row],[Bridge Planning and Installation (Approach Works) ($)]]","v":0},16,"","",{"$f":"IF(AND(Table2[[#This Row],[Bridge Type]]=\"Log\", Table2[[#This Row],[Width (m)]] > 5.5),\"If Bridge Type is Log, Deck Width must be <= 5.5m\",\"\")","v":""},{"$f":"IF(AND(OR(Table2[[#This Row],[Bridge Type]]=(\"Permanent\"),Table2[[#This Row],[Bridge Type]]=(\"Portable\")), Table2[[#This Row],[Width (m)]] >4.9),\"If Bridge Type is Permanent/Portable, Deck Width must be <= 4.9m\",\"\")","v":""}]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table2[[#This Row],[Bridge Supply Cost ($)]]+Table2[[#This Row],[Bridge Planning and Installation (Approach Works) ($)]]","v":0},16,"","",{"$f":"IF(AND(Table2[[#This Row],[Bridge Type]]=\"Log\", Table2[[#This Row],[Width (m)]] > 5.5),\"If Bridge Type is Log, Deck Width must be <= 5.5m\",\"\")","v":""},{"$f":"IF(AND(OR(Table2[[#This Row],[Bridge Type]]=(\"Permanent\"),Table2[[#This Row],[Bridge Type]]=(\"Portable\")), Table2[[#This Row],[Width (m)]] >4.9),\"If Bridge Type is Permanent/Portable, Deck Width must be <= 4.9m\",\"\")","v":""}]
[]
[null,null,null,"Space For Additional Comments:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"lists"]
[null,null,null,"New"]
[null,null,null,"Replacement"]
[]
[null,null,null,"Gravel"]
[null,null,null,"Concrete"]
[null,null,null,"Steel"]
[null,null,null,"Wood"]
[]
[null,null,null,"Permanent/Portable"]
[null,null,null,"Log"]

{"sheet":"Instructions","index":1,"n_rows":60,"n_cols":3,"rows_kept":60,"cut":false,"hidden":false,"merged":[[3,1,3,2],[28,1,28,2],[30,1,32,1],[34,1,50,1],[51,1,58,1],[25,1,27,1],[12,1,17,1],[19,1,19,2],[20,1,21,1],[20,2,21,2],[22,1,23,1]]}
[]
[null,"Schedule B.6 – Bridge Survey Instructions"]
[]
[null,"The Bridge Schedule B.6 is used for capturing costs for  NEWLY purchased  and installed bridges in NEW road construction locations that are completed from January 1st to December 31st of the Cost Base Year (replacement and movement of portables are not captured in this schedule).  \n\nThe goal is to provide FULL and FINAL bridge costs.  Some of these costs may have started in earlier years (i.e. bridge bought in a previous year prior to installation).  Double costing is not permitted. \n\nInclude:\na.\tBridge costs whereby the purchase/delivery is from Cost Base Year or earlier (i.e. from inventory)\nb.\tComplete,  unadjusted bridge installation costs that close in Cost Base Year (i.e. could be over more than one (1) calendar year if a bridge was bought in prior years and not yet installed at a site)\nDo not Include:\na.\tCosts for bridges moved from an existing location (e.g.  REPLACEMENT bridge)\nb.\tCosts for USED bridges moved to a NEW location \nc.\tPARTIAL bridge and installation costs\n\nExamples:\nThe Coast Cost Survey 2020 (based on costs from Jan 1-Dec 31 ie Cost Bae Year 2019) has been received by a Company.  \n\n1. Bridge “A”  was purchased in 2017 and was partially installed in 2018.  In May 2019, the guard rails were added and the bridge installation completed. \nReport:  Provide  the 2017 bridge purchase cost, the 2018 installation costs and the 2019 installation costs. \n\n2. Bridge “B” was purchased in Feb 2019 and is being held as inventory at a Company camp.\nReport:  Do not report any costs for Bridge “B” as it is not fully installed. "]
[]
[null,"COLUMN","INSTRUCTIONS"]
[null,"Bridge Structure id","Any or both of Corporate Asset # and Bridge Serial #"]
[null,"District","The Resource District where the bridge is installed"]
[null,"Company Operation Name or BCTS Business Area/Field Team","Either “Company Operation Name” or in the case of BCTS the “Business Area\"  ie \"SOG\""]
[null,"EBM or non-EBM","Bridge is in “EBM” area or “Non-EBM” area"]
[null,"Road Name","“Road Name” where the bridge is situated (best practise is to use specific road name in government data base, not a “colloquial” road name)"]
[null,"Road Station","“Road Station” where the bridge is situated"]
[null,"Bridge Type","a.       Log:  Bridges with timber decks and gravel surfaces. "]
[null,null,"b.      Permanent:  Bridges which are planned to be in a location for more than 15 years which include permanent substructures with composite* superstructures, concrete slab bridges, or possibly non-composite* superstructures. "]
[null,null,"c.       Portable:  Bridges which are typically designed with a life span in a location for 15 years or less, with temporary substructures which typically include all-steel superstructures, and non-composite superstructures."]
[]
[null,null,"*Composite means that the steel structure of a bridge is fixed using “shear connectors”, to the concrete structure of the deck so that the steel and concrete act together. This is achieved by grouting the deck panels together and to the I-Beams. This allows a “composite” system to be developed so the deck contributes to the capacity of the girders, so reducing deflections and increasing strength."]
[]
[null,"Design Vehicle Capacity (L60-L175)","Only bridges with Professional ratings between “L60” and “L165” to be provided."]
[null,"SUPERSTRUCTURE"]
[null,"Girder/Stringer Material","Select: Log, Concrete, Steel or Other (describe Other Material)"]
[]
[null,"Girder/Stringer Length (m)","a.       Log Bridges: Span length is the distance between the centres of the top sill logs along the centre line of the bridge measured to 0.1 metres. "]
[null,null,"b.      Permanent and Portable Bridges: Length is total span length measured to 0.1 metres."]
[null,"Deck Material","Select: Gravel, Concrete, Steel or Wood"]
[null,"Deck Width (m)","Measure the width between curb logs at mid-span to 0.1 metres.  Bridges measuring wider then provided below will be considered as an NDC project:"]
[null,null,"a.       Log Bridges: Width measured up to 5.4 metres."]
[null,null,"b.      Permanent and Portable Bridges: Width measured up to 4.9 metres."]
[null,"SUBSTRUCTURE"]
[null,"Substructure Material","Select: Concrete, Steel Posts on Concrete Pad, Wood, Driven Steel Piles < 13 metres long, Other (describe Other Material)"]
[null,"Substructure Height (m)","Measure the substructure height to 0.1 metres."]
[null,null,"a.       Log Bridges: Average crib height (distance from the bottom of the bottom sill log to the point where the stringer rests on the top sill log as measured along the centre line of the bridge). The average crib height is the numerical average of the crib heights on both banks of the water course. "]
[null,null,"b.      Permanent and Portable Bridges: Average substructure (abutment) height is the distance from the original ground surface interface to the bottom contact point with the girders.  Each bridge abutment must be measured at the mid-point, from the ground surface interface to the bottom contact point with the girders.  Each measured abutment height is then added together and averaged to get a resultant abutment height."]
[null,"Bridge Supply Cost ($)","Bridge purchase including 3rd party in-plant inspection, freight, substructure and signage."]
[null,"Bridge Planning and Installation (Approach Works) Costs ($) ","Include the following as appropriate:"]
[null,null,"a.       Planning costs:"]
[null,null,"·         Bridge design and certification including field surveys and general arrangement drawings. "]
[null,null,"·         Include all required travel, vehicle and accommodation (as well as camp costs) relating to field work."]
[null,null,"b.      Installation (Approach Works) Costs: "]
[null,null,"·         Delivery: of bridge to the installation site."]
[null,null,"·         Site excavation including blasting."]
[null,null,"·         Compaction: specialized compaction works and equipment."]
[null,null,"·         Rock ie (rip rap):  development and delivery to site."]
[null,null,"·         Substructure: deliver and install."]
[null,null,"·         Bank protection:  as required. "]
[null,null,"·         Placement of structure and any necessary works such as welding and grouting."]
[null,null,"·         Qualified Professional oversight: survey control and supervision including final record drawings (as-built survey/drawing)."]
[null,null,"·         Gravel fill:  including hauling, placing and surfacing."]
[null,null,"·         Professional assessments and works specific to bridge site/structure installation including in-stream works. "]
[null,null,"·         Include all required travel, vehicle and accommodation (as well as camp costs) relating to field work for planning and installation. "]
[null,null,"·         Include costs where company staff and crew are performing the works considering hourly rates and appropriate payroll loading. "]
[null,"Bridge Planning and Installation Costs ($) Not Included","Do not include the following:"]
[null,null,"a.       Any costs collected for Schedule B.2 Engineering and Forestry such as:"]
[null,null,"·         First Nations assessments and monitoring."]
[null,null,"·         Biologist (or other Qualified Professional) assessments required for FRPA compliance in the planning phase.  These costs relate to broader planning. "]
[null,null,"·         Biologist (or other Qualified Professional) assessments for Fish Habitat Conservation in the planning phase.  These costs relate to broader planning. "]
[null,null,"·         Company/BCTS staff oversight and supervision in the planning or installation phases."]
[null,null,"b.      Barging of bridge structure to location. "]
[null,null,"c.       GST"]
[null,"Total Bridge Cost ($)","Total of Bridge Supply Cost and Bridge Planning and Installation Costs"]

{"sheet":"LookUps","index":2,"n_rows":117,"n_cols":8,"rows_kept":117,"cut":false,"hidden":false,"merged":[]}
[null,"District ","EBM or Non-EBM","Bridge Type","Design Load Capacity \n(L60-L175)","Material","Material","Material"]
[null,"DCK ","EBM","Log","L60","Concrete","Concrete","Concrete"]
[null,"DCR ","Non-EBM","Permanent","L61","Log","Gravel","Steel posts on concrete pad"]
[null,"DHG ",null,"Portable","L62","Steel","Steel","Wood"]
[null,"DKM ",null,null,"L63","Other (describe)","Wood","Other (describe)"]
[null,"DNI ",null,null,"L64",null,null,"Driven steel piles < 13 m "]
[null,"DSC ",null,null,"L65"]
[null,"DSI ",null,null,"L66"]
[null,"DSQ ",null,null,"L67"]
[null,null,null,null,"L68"]
[null,null,null,null,"L69"]
[null,null,null,null,"L70"]
[null,null,null,null,"L71"]
[null,null,null,null,"L72"]
[null,null,null,null,"L73"]
[null,null,null,null,"L74"]
[null,null,null,null,"L75"]
[null,null,null,null,"L76"]
[null,null,null,null,"L77"]
[null,null,null,null,"L78"]
[null,null,null,null,"L79"]
[null,null,null,null,"L80"]
[null,null,null,null,"L81"]
[null,null,null,null,"L82"]
[null,null,null,null,"L83"]
[null,null,null,null,"L84"]
[null,null,null,null,"L85"]
[null,null,null,null,"L86"]
[null,null,null,null,"L87"]
[null,null,null,null,"L88"]
[null,null,null,null,"L89"]
[null,null,null,null,"L90"]
[null,null,null,null,"L91"]
[null,null,null,null,"L92"]
[null,null,null,null,"L93"]
[null,null,null,null,"L94"]
[null,null,null,null,"L95"]
[null,null,null,null,"L96"]
[null,null,null,null,"L97"]
[null,null,null,null,"L98"]
[null,null,null,null,"L99"]
[null,null,null,null,"L100"]
[null,null,null,null,"L101"]
[null,null,null,null,"L102"]
[null,null,null,null,"L103"]
[null,null,null,null,"L104"]
[null,null,null,null,"L105"]
[null,null,null,null,"L106"]
[null,null,null,null,"L107"]
[null,null,null,null,"L108"]
[null,null,null,null,"L109"]
[null,null,null,null,"L110"]
[null,null,null,null,"L111"]
[null,null,null,null,"L112"]
[null,null,null,null,"L113"]
[null,null,null,null,"L114"]
[null,null,null,null,"L115"]
[null,null,null,null,"L116"]
[null,null,null,null,"L117"]
[null,null,null,null,"L118"]
[null,null,null,null,"L119"]
[null,null,null,null,"L120"]
[null,null,null,null,"L121"]
[null,null,null,null,"L122"]
[null,null,null,null,"L123"]
[null,null,null,null,"L124"]
[null,null,null,null,"L125"]
[null,null,null,null,"L126"]
[null,null,null,null,"L127"]
[null,null,null,null,"L128"]
[null,null,null,null,"L129"]
[null,null,null,null,"L130"]
[null,null,null,null,"L131"]
[null,null,null,null,"L132"]
[null,null,null,null,"L133"]
[null,null,null,null,"L134"]
[null,null,null,null,"L135"]
[null,null,null,null,"L136"]
[null,null,null,null,"L137"]
[null,null,null,null,"L138"]
[null,null,null,null,"L139"]
[null,null,null,null,"L140"]
[null,null,null,null,"L141"]
[null,null,null,null,"L142"]
[null,null,null,null,"L143"]
[null,null,null,null,"L144"]
[null,null,null,null,"L145"]
[null,null,null,null,"L146"]
[null,null,null,null,"L147"]
[null,null,null,null,"L148"]
[null,null,null,null,"L149"]
[null,null,null,null,"L150"]
[null,null,null,null,"L151"]
[null,null,null,null,"L152"]
[null,null,null,null,"L153"]
[null,null,null,null,"L154"]
[null,null,null,null,"L155"]
[null,null,null,null,"L156"]
[null,null,null,null,"L157"]
[null,null,null,null,"L158"]
[null,null,null,null,"L159"]
[null,null,null,null,"L160"]
[null,null,null,null,"L161"]
[null,null,null,null,"L162"]
[null,null,null,null,"L163"]
[null,null,null,null,"L164"]
[null,null,null,null,"L165"]
[null,null,null,null,"L166"]
[null,null,null,null,"L167"]
[null,null,null,null,"L168"]
[null,null,null,null,"L169"]
[null,null,null,null,"L170"]
[null,null,null,null,"L171"]
[null,null,null,null,"L172"]
[null,null,null,null,"L173"]
[null,null,null,null,"L174"]
[null,null,null,null,"L175"]