{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sch B.5 Roads","Instructions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":8,"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.5 Roads","index":0,"n_rows":131,"n_cols":23,"rows_kept":131,"cut":false,"hidden":false,"merged":[[31,3,35,12],[5,3,5,5],[4,10,4,12],[6,0,6,1],[6,3,6,5]]}
["2020 Coast Crown Tenure Management Cost Survey Template",null,null,null,null,null,null,"Use only this spreadsheet for your submission;  one sheet per CONTRACT.  "]
["Ministry of Forests, Lands,  Natural Resource Operations & Rural Development, Timber Pricing Branch ",null,null,null,null,null,null,"Red Carat notes have been provided for guidance. "]
["Schedule B.5",null,null,null,null,null,null,"Only information from \"Bank Height Method\" contracts are eligible."]
["Road Survey (RS)",null,null,null,null,null,null,"Fill in ALL columns"]
[null,null,null,null,"of",null,"SHEETS (eg 1 of 5 sheets)","Certification of Submitting Forest Professional "]
["CONTRACTOR: "]
["CONTRACT #:"]
[]
["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,"Formatting: Not all categories will have costs assigned. But, if there are costs, then the entire row must be populated. "]
["Line","District ","Point of Origin Area* ","Location                 TSB** or TFL/Block","Isolated or Accessible","EBM or Non-EBM","Company Operation or  BCTS Business Area","Bankheight  Construction Category","Rock Hardness","Cost\n($.$$)","Length\n (m)","$/Metre","Ballast Haul Distance (km)",null,null,null,null,"**TSB List",null,null,null,"*Point of Origin Area List"]
[1,null,null,null,null,null,null,"OM-LB","-",null,null,{"$f":"IF(ISBLANK(J11),\"\",(IF(ISBLANK(K11),\"\",J11/K11)))","v":""},null,{"$f":"COUNTBLANK($B11:$K11)","v":8},{"$f":"IF(N11=0,\"Entry Complete\",IF(AND(N11>0,N11<8),\"Entry in progress\",IF(N11=8,\"\")))","v":""},null,null,"25E",null,null,null,"BKCL","Barkley-Clayoquot"]
[2,null,null,null,null,null,null,"OM-PR","-",null,null,"",null,{"$f":"COUNTBLANK($B12:$K12)","v":8},{"$f":"IF(N12=0,\"Entry Complete\",IF(AND(N12>0,N12<8),\"Entry in progress\",IF(N12=8,\"\")))","v":""},null,null,"30E","Nahatlatch",null,null,"BUTE","Bute Inlet"]
[3,null,null,null,null,null,null,"OM-RB","S/M",null,null,"",null,8,"",null,null,"30G","Upper Pitt",null,null,"CHSH","Chilliwack-Silverhope"]
[4,null,null,null,null,null,null,"TOE","S/M",null,null,"",null,8,"",null,null,"30H","Maple Ridge",null,null,"COCO","Courtney-Comox"]
[5,null,null,null,null,null,null,"MRK","S/M",null,null,"",null,8,"",null,null,"30I","Chilliwack-Silverhope",null,null,"DEWD","Dewdney"]
[6,null,null,null,null,null,null,"HRK","S/M",null,null,null,null,8,"",null,null,"31B","Port Douglas",null,null,"DRSE","Drury-Seymour"]
[7,null,null,null,null,null,null,"XRK","S/M",null,null,null,null,8,"",null,null,"31D","Squamish-Pemberton",null,null,"ESPE","Esperanza"]
[8,null,null,null,null,null,null,"XXRK","S/M",null,null,"",null,8,"",null,null,"38A","Barkley",null,null,"GKIN","Gilford-Knight"]
[9,null,null,null,null,null,null,"XXXRK","S/M",null,null,"",null,8,"",null,null,"38B","Nanaimo",null,null,"GRIS","Graham Island"]
[10,null,null,null,null,null,null,"OM-RB","Hard",null,null,"",null,8,"",null,null,"38C","Cowichan",null,null,"HARR","Harrison"]
[11,null,null,null,null,null,null,"TOE","Hard",null,null,"",null,8,"",null,null,"39C","Powell River",null,null,"JEIS","Jervis-Sechelt"]
[12,null,null,null,null,null,null,"MRK","Hard",null,null,"",null,8,"",null,null,"46A",null,null,null,"JUDF","Juan de Fuca"]
[13,null,null,null,null,null,null,"HRK","Hard",null,null,"",null,8,"",null,null,"46B",null,null,null,"KEAD","Kelsey-Adam"]
[14,null,null,null,null,null,null,"XRK","Hard",null,null,"",null,8,"",null,null,"46C",null,null,null,"KOKI","Kokish"]
[15,null,null,null,null,null,null,"XXRK","Hard",null,null,"",null,8,"",null,null,"46D",null,null,null,"LOMD","Lower Mainland"]
[16,null,null,null,null,null,null,"XXXRK","Hard",null,null,"",null,8,"",null,null,"46E",null,null,null,"MESF","Menzies-Sayward Forest"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"46F",null,null,null,"NTHC","North Coast"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"46G","Stewart",null,null,"PIME","Pitt Meadows"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"46H","Alice Arm",null,null,"POMH","Port McNeill-Hardy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"46I","Skeena",null,null,"QUSO","Quatsino Sound"]
[null,null,null,"Space For Additional Comments:",null,null,null,null,null,null,null,null,null,null,null,null,null,"46J","Outer Coast",null,null,"SLOQ","Sloquet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"46K","Douglas",null,null,"SEVI","Southeast Vancouver Island"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"47A","Seymour",null,null,"SPLK","Sproat Lake"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"47B","Broughton",null,null,"SQPM","Squamish-Pemberton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"47C","Klinaklini",null,null,"SUCO","Sunshine Coast"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"47D","Loughborough",null,null,"THUR","Thurlow"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"48A","Brooks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"48B","Cape Scott"]
[null,null,null,null,null,null,null,null,null,null,"Note: This workbook / schedule is confidential once populated with data",null,null,null,null,null,null,"48C","Broughton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"48D","Sayward"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"48E","Kyuquot"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Dropdown Lists"]
[]
[]
[null,"District ",null,"Isolated or Accessible","EBM or Non-EBM",null,null,null,null,null,null,null,"Ballast Haul Distance List"]
[null,"DCK",null,{"$f":"R11 & \" \" &  S11","v":"25E "},"Accessible","EBM",null,null,null,null,null,null,"0- 1.0 km"]
[null,"DSC",null,"30E Nahatlatch","Isolated","Non-EBM",null,null,null,null,null,null,"1.001 km - 1.5 km"]
[null,"DHG",null,"30G Upper Pitt",null,null,null,null,null,null,null,null,"1.501 - 2.0 km"]
[null,"DNI",null,"30H Maple Ridge",null,null,null,null,null,null,null,null,"2.001 km - 3.2 km"]
[null,"DKM",null,"30I Chilliwack-Silverhope",null,null,null,null,null,null,null,null,"> 3.2 km"]
[null,"DSI",null,"31B Port Douglas"]
[null,"DCR",null,"31D Squamish-Pemberton"]
[null,"DSQ",null,"38A Barkley"]
[null,null,null,"38B Nanaimo"]
[null,null,null,"38C Cowichan"]
[null,null,null,"39C Powell River"]
[null,null,null,"46A "]
[null,null,null,"46B "]
[null,null,null,"46C "]
[null,null,null,"46D "]
[null,null,null,"46E "]
[null,null,null,"46F "]
[null,null,null,"46G Stewart"]
[null,null,null,"46H Alice Arm"]
[null,null,null,"46I Skeena"]
[null,null,null,"46J Outer Coast"]
[null,null,null,"46K Douglas"]
[null,null,null,"47A Seymour"]
[null,null,null,"47B Broughton"]
[null,null,null,"47C Klinaklini"]
[null,null,null,"47D Loughborough"]
[null,null,null,"48A Brooks"]
[null,null,null,"48B Cape Scott"]
[null,null,null,"48C Broughton"]
[null,null,null,"48D Sayward"]
[null,null,null,"48E Kyuquot"]

{"sheet":"Instructions","index":1,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"Schedule B.5 Bank Height Roads"]
[]
[null,"The Road Construction Costs - Bank Height Method is based primarily on:"]
[]
[null,"·       Height of the inside rock face;"]
[null,"·       Material type (i.e. OM, hardpan, rock);"]
[null,"·       Ballast type (i.e. local or trucked gravel or rock);"]
[null,"·       Ballast haul distance*;"]
[null,"·       Rock hardness* (as defined in the Coast Appraisal Manual);"]
[null,"·       Geographic location*;"]
[]
[null,"*to be segregated if significant (i.e. data supports)"]
[]
[null,"Complete a separate spreadsheet for each contract. Multiple workbook sheets can be established by duplicating the Schedule B.5 tab within the Excel workbook."]
[]
[null,"For each bank height method construction category, please complete the information requested on the survey template according to definitions below and using the relevant Coast Appraisal Manual."]
[]
[null,"Definitions:"]
[]
[null,"The Road Schedule B.5 is used for capturing costs for new bank height road construction contracts completed  from January 1st to December 31th of the cost base year.   "]
[]
[null,"Include:"]
[null,"a.     Road construction contracts that used bank height categories for payment."]
[null,"b.     Road contract information for roads measured up January 1- December 31 of the cost base year. "]
[null,"Do not Include:"]
[null,"a.     PARTIAL road costs ie incomplete roads in cost base year."]
[null,"b.     Road reconstruction or deactivation costs. "]
[]
[null,"Examples:"]
[null,"The Coast Cost Survey 2020 (based on costs from Jan 1-Dec 31 calendar year 2019) has been received by a Company.  "]
[]
[null,"1. Bank height Road Contract “A”  was signed in 2018 with some construction carried out in both 2018 and 2019. The contract was completed in 2019.  "]
[null,"Report:  Provide  the final 2019 measure up road construction costs. "]