{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Instructions","Summary","UG Mine","Tailings","Rock Pile","Chemicals","Bldgs & Equip","ICM","PostClosure","Mobilization","Open Pit","Water Management","Water Treatment","Unit_Costs","Estimator","Tools"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":126,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":69,"n_cols":8,"rows_kept":69,"cut":false,"hidden":false,"merged":[[58,0,67,1],[32,0,32,1],[33,0,38,1],[39,0,46,1],[47,0,53,1],[54,0,57,1]]}
["Project Name:",null,"Reclaim Model - Overview of Program"]
[null,"Hope Bay - P2 Boston Mine","All users are urged to read the Reclaim Model User Manual - Scroll down for overview description of program.",null,null,"","",""]
[null,null,"Important!  Reclaim 7.0 works better with no other excel files open."]
[null,null,"If other excel files are open ignore run time error and proceed"]
["Reclaim Menu",null,"The default Excel menu bar has an additional tab labelled \"Add-Ins\" that provides options specific to the Reclaim Model.",null,null,"","",""]
[null,"Clear","This option deletes all input data, deletes any duplicated elements and blanks out the project name.  It also allows for segregation into land costs vs water costs if required.",null,null,"","",""]
[null,"Duplicate","This option Duplicates components of the project. E.g. if there is more than one Open Pit, use duplicate to add a second Open Pit.  Quantities for the new Open Pit are erased, but the Activities and Cost Codes are carried over from the original Open Pit.  The new Open Pit subtotal is added to the Summary page.",null,null,"","",""]
[null,"Unit Costs","This option opens a window of unit costs to provide easy reference.  NOTE:  the unit cost table has a filter in the 'UNITS' column.   You can select to only see a particular unit (eg km) or multiple units (km and m3) or all units.",null,null,"","",""]
[null,"Print All ","This option prints the Summary Worksheet, Unit Cost Worksheet, and the individual component worksheets having non-zero balances.  Individual worksheets can be printed directly using standard printing methods, such as Ctl - P.",null,null,"","",""]
[null,"Quit","Select Quit to exit the program",null,null,"","",""]
[null,"Help","Redirects user to Instructions worksheet.",null,null,"","",""]
[null,null,null,null,null,"","",""]
["WorkSheets",null,null,null,null,"","",""]
[null,"Summary ","This worksheet contains a cumulative summary of costs for each component of the project.     Associated costs such as engineering and project management are added as a percentage of the component costs.\n",null,null,"","",""]
[null,"Components","Costs are derived for individual closure and reclamation activities by multiplying a \"quantity\" of activity by a \"unit cost\".      \nAn activity can be edited, added, or deleted from worksheet.  However, care should be taken not to modify cells that are defined and used elsewhere in the program.",null,null,"","",""]
[null,null,"Do not change the content or column width of the first column of each component worksheet.",null,null,"","",""]
[null,"Unit Costs","This worksheet contains a look up table with costs for typical work associated with each closure and reclamation activity",null,null,"","",""]
[null,null,null,null,null,"","",""]
["Limitations",null,"The Reclaim Program will NOT work if the worksheets are changed such that the following requirements are not met.  Please review the following prior to modifiying worksheets.",null,null,"","",""]
[null,"WorkSheet Names","The names of the worksheets must not be changed.",null,null,"","",""]
[null,"Defined Names","Certain cells have defined names, which must not be changed.  Where the cell is named, the name will appear in the \"Name Box\" to the left of the formula bar.",null,null,"","",""]
[null,"First line of data","The first line of data for any component worksheet starts on line 4.  Do not change the first line of a component worksheet, ie the component name.",null,null,"","",""]
[null,"Cell A1","Cell A1 on the component sheet MUST always contain the count of that component for the duplicate function to operate.  DO NOT CHANGE.",null,null,"","",""]
[null,"Adding Lines","You can add lines to components and the unit cost table, as long as they are not the last lines.\nThe last line might fall outside the named ranges.  You can check the size of the named range by selecting the name from the drop down box at the top left of the sheet.  Usually this box has a cell reference, or a name.  ",null,null,"","",""]
[null,"Printing","A component will only be printed if its sub-total is greater than zero.  In addition, a component and the summary sheet cannot be printed if there is an error.  Printing has been set to print 1 page per component. ",null,null,"","",""]
[null,null,null,null,null,"","",""]
["Conditions of Use",null,"The Reclamation Cost Estimating Model was prepared to serve as a guide for Government Agencies, mining companies, and others to estimate the cost of mine reclamation.  This model is not intended to replace reclamation planning or to be used to determine the activities required to reclaim a site or to dictate how much should be spent on reclamation.",null,null,"","",""]
[null,null,null,null,null,"","",""]
[null,null,"Reclaim was prepared by Brodie Consulting Ltd. on behalf of AANDC.  AANDC and Brodie Consulting Ltd. are not responsible for the completeness or accuracy of any reclamation estimate made using this model.  The user agrees to check and take responsibility for all aspects of any cost estimate made using this model.",null,null,"","",""]
[null,null,null,null,null,"","",""]
["The following table provides guidance as to whether water management and treatment is considered short term or long term.  Short term closure activities",null,null,null,null,"","",""]
["may be costed within a component (eg 'Open Pit' or 'Rock Pile') or 'Water Management'.  Long term or post-closure water treatment is costed in 'Water Treatment'."]
[null,null,null,"Short Term/ Capital Ex.","Long term/ NPV","","",""]
["Open Pit",null,"flood pit - install/operate pumping system","x",null,"","",""]
[null,null,"construct diversion ditches","x",null,"","",""]
[null,null,"treat 1st filling","x",null,"","",""]
[null,null,"install pump/decant system","x",null,"","",""]
[null,null,"passive/biological treatment","x",null,"","",""]
[null,null,"overflow treatment",null,"x","","",""]
["Rock Pile/Heap Leach Facility",null,"construct diversion ditches","x",null,"","",""]
[null,null,"install groundwater collection system","x",null,"","",""]
[null,null,"install toe seepage collection system","x",null,"","",""]
[null,null,"collect and treat groundwater",null,"x"]
[null,null,"collect and treat seepage (ARD/ML)",null,"x"]
[null,null,"install passive treatment system","x",null,"","",""]
[null,null,"operate and maintain passive treatment system",null,"x","","",""]
[null,null,"operate pump and detoxify heap leach pile (cyanide destruction)","x",null,"","",""]
["Tailings Facility",null,"construct diversion ditches","x",null,"","",""]
[null,null,"pump supernatant (to pit, U/G)","x",null,"","",""]
[null,null,"treat supernatant","x",null,"","",""]
[null,null,"install toe seepage collection system","x",null,"","",""]
[null,null,"collect and treat seepage (ARD/ML)",null,"x","","",""]
[null,null,"install passive treatment system","x",null,"","",""]
[null,null,"operate and maintain passive treatment system",null,"x","","",""]
["U/G Mine",null,"accelerate flooding","x",null,"","",""]
[null,null,"install seepage collection system","x",null,"","",""]
[null,null,"install dewatering/pumping system","x",null,"","",""]
[null,null,"operate seepage/dewatering system (ARD/ML)",null,"x","","",""]
["Water Management",null,"refill lakes",null,null,"","",""]
[null,null,"redirect creeks/streams","x",null,"","",""]
[null,null,"stabilize water management ponds","x",null,"","",""]
[null,null,"stabilize/close sediment ponds","x"]
[null,null,"fresh water supply - breach embankment","x"]
[null,null,"fresh water supply - remove piping system","x"]
[null,null,"construct water treatment plant","x"]
[null,null,"construct sludge pond","x"]
[null,null,"water control in reclamation quarry","x"]
[null,null,"operate/maintain water treatment plant",null,"x","","",""]
[null,null,null,null,null,"","",""]

{"sheet":"Summary","index":1,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"SUMMARY OF COSTS"]
[]
["CAPITAL COSTS","COMPONENT NAME",null,"COST",null,"LAND LIABILITY",null,"WATER LIABILITY"]
["OPEN PIT",{"$f":"IF(ISBLANK('Open Pit'!$C$1),\"\",'Open Pit'!$C$1)","v":""},null,{"$f":"Pit1Total","v":1E-4},null,{"$f":"Pit1LandTotal","v":0},null,{"$f":"Pit1WaterTotal","v":0}]
["UNDERGROUND MINE",{"$f":"IF(ISBLANK('UG Mine'!$C$1),\"\",'UG Mine'!$C$1)","v":""},null,{"$f":"UG1Total","v":60846.550099999993},null,{"$f":"UG1LandTotal","v":60846.549999999996},null,{"$f":"UG1WaterTotal","v":0}]
["TAILINGS FACILITY",{"$f":"IF(ISBLANK(Tailings!$C$1),\"\",Tailings!$C$1)","v":""},null,{"$f":"Tailings1Total","v":15195574.058100002},null,{"$f":"Tailings1LandTotal","v":7597787.029000001},null,{"$f":"Tailings1WaterTotal","v":7597787.029000001}]
["ROCK PILE",{"$f":"IF(ISBLANK('Rock Pile'!$C$1),\"\",'Rock Pile'!$C$1)","v":"Waste Rock and Overburden Dump"},null,{"$f":"RP1Total","v":57142.500099999997},null,{"$f":"RP1LandTotal","v":57142.5},null,{"$f":"RP1WaterTotal","v":0}]
["BUILDINGS AND EQUIPMENT",{"$f":"IF(ISBLANK('Bldgs & Equip'!$C$1),\"\",'Bldgs & Equip'!$C$1)","v":"Boston Mine"},null,{"$f":"Bldg1Total","v":5313366.0975100007},null,{"$f":"Bldg1LandTotal","v":5070136.676260002},null,{"$f":"Bldg1WaterTotal","v":243229.42115000001}]
["CHEMICALS AND CONTAMINATED SOIL MANAGEMENT",{"$f":"IF(ISBLANK(Chemicals!$C$1),\"\",Chemicals!$C$1)","v":""},null,{"$f":"Chem1Total","v":636122.83969999989},null,{"$f":"Chem1LandTotal","v":318061.41979999997},null,{"$f":"Chem1WaterTotal","v":318061.41979999997}]
["SURFACE AND GROUNDWATER MANAGEMENT",{"$f":"IF(ISBLANK('Water Treatment'!$C$1),\"\",'Water Treatment'!$C$1)","v":""},null,{"$f":"Water1Total","v":46772.390099999997},null,"-",null,{"$f":"Water1Total","v":46772.390099999997}]
["INTERIM CARE AND MAINTENANCE",{"$f":"IF(ISBLANK(ICM!$C$1),\"\",ICM!$C$1)","v":""},null,{"$f":"ICMTotal","v":4786320.0003000004},null,"-",null,{"$f":"ICMTotal","v":4786320.0003000004}]
[null,"SUBTOTAL: Capital Costs",null,{"$f":"SUM(D4:D11)","v":26096144.436010003},null,{"$f":"SUM(F4:F11)","v":13103974.175060002},null,{"$f":"SUM(H4:H11)","v":12992170.260350002}]
[null,"PERCENT OF SUBTOTAL ",null,null,null,{"$f":"IF(F12<0.01,0,F12/D12)","v":0.50214215387993721},null,{"$f":"IF(H12<0.01,0,H12/D12)","v":0.49785784609707096}]
[]
["INDIRECT COSTS",null,null,"COST",null,"LAND LIABILITY",null,"WATER LIABILITY"]
["MOBILIZATION/DEMOBILIZATION",{"$f":"IF(ISBLANK(Mobilization!$C$1),\"\",Mobilization!$C$1)","v":""},null,{"$f":"MobTotal","v":5041005.0000999998},null,{"$f":"D16*$F$13","v":2531301.108469747},null,{"$f":"D16*$H$13","v":2509703.8915143507}]
["POST-CLOSURE MONITORING AND MAINTENANCE",{"$f":"IF(ISBLANK(PostClosure!$C$1),\"\",PostClosure!$C$1)","v":""},null,{"$f":"PC1Total","v":1577876.5020000001},null,{"$f":"D17*$F$13","v":792318.30527082109},null,{"$f":"D17*$H$13","v":785558.19669290073}]
["ENGINEERING ",0.05,null,{"$f":"B18*$D$12","v":1304807.2218005003},null,{"$f":"+$F$13*D18","v":655198.70875300013},null,{"$f":"+$H$13*D18","v":649608.51301750017}]
["PROJECT MANAGEMENT",0.05,null,1304807.2218005003,null,655198.70875300013,null,649608.51301750017]
["HEALTH AND SAFETY PLANS/MONITORING & QA/QC",0,null,0,null,0,null,0]
["BONDING/INSURANCE",0,null,0,null,0,null,0]
["CONTINGENCY ",0.2,null,5219228.8872020012,null,2620794.8350120005,null,2598434.0520700007]
["MARKET PRICE FACTOR ADJUSTMENT",0,null,0,null,0,null,0]
[null,"SUBTOTAL: Indirect Costs",null,{"$f":"SUM(D16:D23)","v":14447724.832903001},null,{"$f":"SUM(F16:F23)","v":7254811.6662585679},null,{"$f":"SUM(H16:H23)","v":7192913.1663122531}]
[]
["TOTAL COSTS",null,null,{"$f":"D12+D24","v":40543869.268913001},null,{"$f":"F12+F24","v":20358785.84131857},null,{"$f":"H12+H24","v":20185083.426662255}]

{"sheet":"UG Mine","index":2,"n_rows":43,"n_cols":13,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[1,"Underground Mine Name",null,null,null,null,"UG Mine #",1]
[]
[null,"ACTIVITY/MATERIAL","Notes","Unit","Qty","Cost Code","Unit Cost","Cost","% Land","Land Cost","Water Cost"]
[null,"CONTROL ACCESS"]
[null,"Fence",null,"m",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F5),0,INDEX(IF(UPPER(RIGHT(F5,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F5,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F5,LEN(F5)-1)),CostCode,0)))","v":0},{"$f":"G5*E5","v":0},null,{"$f":"H5*I5","v":0},{"$f":"H5*(1-I5)","v":0}]
[null,"Signs",null,"each",2,"SH",37.08,74.16,1,{"$f":"H6*I6","v":74.16},{"$f":"H6*(1-I6)","v":0}]
[null,"Block roads",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G7*E7","v":0},null,0,0]
[null,"Berm",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Concrete wall in  portals",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H9*I9","v":0},{"$f":"H9*(1-I9)","v":0}]
[null,"Backfill portal #1","BM-033","m3",710,"TMAC",24.53,17416.3,1,17416.3,0]
[null,"Backfill portal #2",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Cap Vent Raise ","BM-028","each",1,"TMAC",14293,14293,1,14293,0]
[null,"Cap raise #2",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Cap shaft #1",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Cap shaft #2",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Grading at Vent Raise",null,"m2",2270,"TMAC",0.24,544.79999999999995,1,{"$f":"H16*I16","v":544.79999999999995},{"$f":"H16*(1-I16)","v":0},null,"consider grading at the vent raise coincident with adjacent access road.  Reduction from $1.23 to 0.24/m2"]
[null,"Backfill open stope",null,"m3",null,"sc3h",14.2,0,null,0,0]
[null,"Concrete cap over open stope",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Other - crown pillar study",null,"LS",null,{"$f":"NA()","v":{"$error":"#N/A"}},25000,0,null,0,0]
[null,"REMOVE HAZARDOUS MATERIALS"]
[null,"Remove hazardous materials, U/G labor",null,"mandays",null,{"$f":"NA()","v":{"$error":"#N/A"}},500,{"$f":"G21*E21","v":0},null,{"$f":"H21*I21","v":0},{"$f":"H21*(1-I21)","v":0}]
[null,"Remove/decontam. stationary & elect. equip",null,"lm",200,"TMAC",119.02,{"$f":"G22*E22","v":23804},1,{"$f":"H22*I22","v":23804},{"$f":"H22*(1-I22)","v":0}]
[null,"Remove/decontam. mobile equipment",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F23),0,INDEX(IF(UPPER(RIGHT(F23,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F23,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F23,LEN(F23)-1)),CostCode,0)))","v":0},{"$f":"G23*E23","v":0},null,{"$f":"H23*I23","v":0},{"$f":"H23*(1-I23)","v":0}]
[null,"Remove misc. haz. mat & explosives",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F24),0,INDEX(IF(UPPER(RIGHT(F24,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F24,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F24,LEN(F24)-1)),CostCode,0)))","v":0},{"$f":"G24*E24","v":0},null,{"$f":"H24*I24","v":0},{"$f":"H24*(1-I24)","v":0}]
[null,"Other","BM-028 & BM-033 Relocate debris and equipment to Roberts Bay","LS",1,"TMAC",{"$f":"2637.83+1344.8+731.66","v":4714.29},{"$f":"G25*E25","v":4714.29},1,{"$f":"H25*I25","v":4714.29},{"$f":"H25*(1-I25)","v":0}]
[null,"INSTALL BULKHEADS"]
[null,"Bulkheads to control water flow",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F27),0,INDEX(IF(UPPER(RIGHT(F27,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F27,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F27,LEN(F27)-1)),CostCode,0)))","v":0},{"$f":"G27*E27","v":0},null,{"$f":"H27*I27","v":0},{"$f":"H27*(1-I27)","v":0}]
[null,"Grout bulkhead",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F28),0,INDEX(IF(UPPER(RIGHT(F28,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F28,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F28,LEN(F28)-1)),CostCode,0)))","v":0},{"$f":"G28*E28","v":0},null,{"$f":"H28*I28","v":0},{"$f":"H28*(1-I28)","v":0}]
[null,"FLOOD MINE"]
[null,"Supply/install pump",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F30),0,INDEX(IF(UPPER(RIGHT(F30,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F30,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F30,LEN(F30)-1)),CostCode,0)))","v":0},{"$f":"G30*E30","v":0},null,0,0]
[null,"Supply/install piping system",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F31),0,INDEX(IF(UPPER(RIGHT(F31,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F31,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F31,LEN(F31)-1)),CostCode,0)))","v":0},{"$f":"G31*E31","v":0},null,{"$f":"H31*I31","v":0},{"$f":"H31*(1-I31)","v":0}]
[null,"Operate pumps to flood workings",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F32),0,INDEX(IF(UPPER(RIGHT(F32,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F32,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F32,LEN(F32)-1)),CostCode,0)))","v":0},{"$f":"G32*E32","v":0},null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F33),0,INDEX(IF(UPPER(RIGHT(F33,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F33,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F33,LEN(F33)-1)),CostCode,0)))","v":0},{"$f":"G33*E33","v":0},null,0,0]
[null,"INSTALL GROUNDWATER COLLECTION SYSTEM"]
[null,"Excavate/install sumps",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F35),0,INDEX(IF(UPPER(RIGHT(F35,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F35,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F35,LEN(F35)-1)),CostCode,0)))","v":0},{"$f":"G35*E35","v":0},null,{"$f":"H35*I35","v":0},{"$f":"+H35*(1-I35)","v":0}]
[null,"Install pumping wells",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Install pumps/pipelines/power supply",null,"LS",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"SPECIALIZED ITEMS"]
[null,"Install water quality monitoring pipes",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F39),0,INDEX(IF(UPPER(RIGHT(F39,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F39,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F39,LEN(F39)-1)),CostCode,0)))","v":0},{"$f":"G39*E39","v":0},null,{"$f":"H39*I39","v":0},0]
[null,"Install permanent pumping system",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G40*E40","v":0},null,{"$f":"H40*I40","v":0},0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F41),0,INDEX(IF(UPPER(RIGHT(F41,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F41,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F41,LEN(F41)-1)),CostCode,0)))","v":0},{"$f":"G41*E41","v":0},null,{"$f":"H41*I41","v":0},0]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H41)+0.0001","v":60846.550099999993},null,{"$f":"SUM(J5:J41)","v":60846.549999999996},{"$f":"SUM(K5:K41)","v":0}]
[null,null,null,null,null,null,"% of Total",null,null,{"$f":"J42/H42","v":0.99999999835652154},{"$f":"K42/H42","v":0}]

{"sheet":"Tailings","index":3,"n_rows":80,"n_cols":13,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[1,"Tailings Impoundment Name:",null,null,null,null,"Pond #",1]
[]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost","% Land","Land Cost","Water Cost"]
[null,"CONTROL ACCESS"]
[null,"Fence",null,"m",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F5),0,INDEX(IF(UPPER(RIGHT(F5,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F5,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F5,LEN(F5)-1)),CostCode,0)))","v":0},{"$f":"G5*E5","v":0},null,{"$f":"H5*I5","v":0},{"$f":"+H5*(1-I5)","v":0}]
[null,"Signs",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H6*I6","v":0},{"$f":"+H6*(1-I6)","v":0}]
[null,"Berm",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Block roads",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"STABILIZE EMBANKMENT(S)"]
[null,"Toe buttress, drainage layer",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G11*E11","v":0},null,0,0]
[null,"Toe buttress, bulk fill",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Rip rap",null,"m3",null,"RB2",{"$f":"Unit_Costs!G27","v":17.8},0,null,0,0]
[null,"Vegetate",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Raise crest",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Flatten slopes",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"COVER TAILINGS"]
[null,"Grade/shape tailings surface","BM-031","m2",72900,"TMAC",0.24,{"$f":"G19*E19","v":17496},0.5,{"$f":"H19*I19","v":8748},{"$f":"+H19*(1-I19)","v":8748},null,"Given the nature of the grading work (ie tailings) we concur with the grader rate of $0.24/m2"]
[null,"Liner bedding",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F20),0,INDEX(IF(UPPER(RIGHT(F20,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F20,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F20,LEN(F20)-1)),CostCode,0)))","v":0},{"$f":"G20*E20","v":0},null,{"$f":"H20*I20","v":0},{"$f":"+H20*(1-I20)","v":0}]
[null,"Subgrade preparation - compact",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F21),0,INDEX(IF(UPPER(RIGHT(F21,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F21,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F21,LEN(F21)-1)),CostCode,0)))","v":0},{"$f":"G21*E21","v":0},null,{"$f":"H21*I21","v":0},{"$f":"+H21*(1-I21)","v":0}]
[null,"Supply geotextile/geosynthetic",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F22),0,INDEX(IF(UPPER(RIGHT(F22,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F22,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F22,LEN(F22)-1)),CostCode,0)))","v":0},0,null,0,0]
[null,"Supply & Install geotextile/geosynthetic","BM-031","m2",202826,"TMAC",33.85,{"$f":"G23*E23","v":6865660.1000000006},0.5,{"$f":"H23*I23","v":3432830.0500000003},{"$f":"+H23*(1-I23)","v":3432830.0500000003}]
[null,"Soil cover",null,"m3",null,"SC4L",{"$f":"IF(ISNA(F24),0,INDEX(IF(UPPER(RIGHT(F24,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F24,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F24,LEN(F24)-1)),CostCode,0)))","v":9.3000000000000007},0,null,0,0]
[null,"Rock cover","Based on 1000 mm cap","m3",202826,{"$f":"NA()","v":{"$error":"#N/A"}},16.350000000000001,{"$f":"G25*E25","v":3316205.1},0.5,{"$f":"H25*I25","v":1658102.55},{"$f":"+H25*(1-I25)","v":1658102.55}]
[null,"Other","Rock Crushing","m3",60847.8,"TMAC",4.91,298762.69800000003,0.5,149381.34900000002,149381.34900000002]
[null,"Other","Drill and Blast rock for cover BM-031","m3",202826,"TMAC",23.16,{"$f":"G27*E27","v":4697450.16},0.5,{"$f":"H27*I27","v":2348725.08},{"$f":"+H27*(1-I27)","v":2348725.08}]
[null,"BURY PAG ROCK"]
[null,"Relocate PAG rock",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G29*E29","v":0},null,0,0]
[null,"Place cover over PAG rock",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G30*E30","v":0},null,0,0]
[null,"Raise crest of dam",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G31*E31","v":0},null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G32*E32","v":0},null,0,0]
[null,"STABILIZE DECANT SYSTEM"]
[null,"Excavate and replace",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F34),0,INDEX(IF(UPPER(RIGHT(F34,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F34,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F34,LEN(F34)-1)),CostCode,0)))","v":0},{"$f":"G34*E34","v":0},null,{"$f":"H34*I34","v":0},{"$f":"+H34*(1-I34)","v":0}]
[null,"Plug/backfill with concrete or clay",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F35),0,INDEX(IF(UPPER(RIGHT(F35,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F35,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F35,LEN(F35)-1)),CostCode,0)))","v":0},{"$f":"G35*E35","v":0},null,{"$f":"H35*I35","v":0},{"$f":"+H35*(1-I35)","v":0}]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F36),0,INDEX(IF(UPPER(RIGHT(F36,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F36,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F36,LEN(F36)-1)),CostCode,0)))","v":0},{"$f":"G36*E36","v":0},null,{"$f":"H36*I36","v":0},{"$f":"+H36*(1-I36)","v":0}]
[null,"REMOVE TAILINGS DISCHARGE"]
[null,"Cyclones",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F38),0,INDEX(IF(UPPER(RIGHT(F38,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F38,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F38,LEN(F38)-1)),CostCode,0)))","v":0},{"$f":"G38*E38","v":0},null,{"$f":"H38*I38","v":0},{"$f":"+H38*(1-I38)","v":0}]
[null,"Pipe",null,"m",null,"ppls",57.33,{"$f":"G39*E39","v":0},null,{"$f":"H39*I39","v":0},{"$f":"+H39*(1-I39)","v":0}]
[null,"Remove reclaim barge",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F40),0,INDEX(IF(UPPER(RIGHT(F40,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F40,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F40,LEN(F40)-1)),CostCode,0)))","v":0},{"$f":"G40*E40","v":0},null,{"$f":"H40*I40","v":0},{"$f":"+H40*(1-I40)","v":0}]
[null,"CONSTRUCT DIVERSION DITCHES"]
[null,"Excavate ditches -soil",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F42),0,INDEX(IF(UPPER(RIGHT(F42,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F42,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F42,LEN(F42)-1)),CostCode,0)))","v":0},{"$f":"G42*E42","v":0},null,{"$f":"H42*I42","v":0},{"$f":"+H42*(1-I42)","v":0}]
[null,"Excavate ditches -rock",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F43),0,INDEX(IF(UPPER(RIGHT(F43,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F43,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F43,LEN(F43)-1)),CostCode,0)))","v":0},{"$f":"G43*E43","v":0},null,0,0]
[null,"Rip rap in channel base",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F44),0,INDEX(IF(UPPER(RIGHT(F44,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F44,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F44,LEN(F44)-1)),CostCode,0)))","v":0},{"$f":"G44*E44","v":0},null,0,0]
[null,"FLOOD TAILINGS"]
[null,"Doze tailings to final contour",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G46*E46","v":0},null,0,0]
[null,"Raise crest of dam",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G47*E47","v":0},null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G48*E48","v":0},null,0,0]
[null,"UPGRADE SPILLWAY"]
[null,"Excavate channel, rock",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G50*E50","v":0},null,0,0]
[null,"Excavate channel, soil",null,"m3",null,"SC3H",14.2,{"$f":"G51*E51","v":0},null,0,0]
[null,"Concrete",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G52*E52","v":0},null,0,0]
[null,"Rip rap",null,"m3",null,"RB4H",30.75,{"$f":"G53*E53","v":0},null,0,0]
[null,"Geotextile",null,"m2",null,"GSTL",3.44,{"$f":"G54*E54","v":0},null,0,0]
[null,"CONSTRUCT SEEPAGE COLLECTION POND"]
[null,"Excavate seepage collection pond",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F56),0,INDEX(IF(UPPER(RIGHT(F56,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F56,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F56,LEN(F56)-1)),CostCode,0)))","v":0},{"$f":"G56*E56","v":0},null,{"$f":"H56*I56","v":0},{"$f":"+H56*(1-I56)","v":0}]
[null,"Doze & spread excavated material",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Vegetate spread material",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Bedding layer",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Supply geomembrane",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Install geomembrane",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Erosion protection layer",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"INSTALL GROUNDWATER COLLECTION SYSTEM"]
[null,"Excavate/install sumps",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F64),0,INDEX(IF(UPPER(RIGHT(F64,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F64,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F64,LEN(F64)-1)),CostCode,0)))","v":0},{"$f":"G64*E64","v":0},null,{"$f":"H64*I64","v":0},{"$f":"+H64*(1-I64)","v":0}]
[null,"Install pumping wells",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Install pumps/pipelines/power supply",null,"LS",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"SPECIALIZED ITEMS"]
[null,"Install permanent instrumentation, supply & technican",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},30000,{"$f":"G68*E68","v":0},null,{"$f":"H68*I68","v":0},{"$f":"+H68*(1-I68)","v":0}]
[null,"Install permanent instrumentation, drilling",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},30000,{"$f":"G69*E69","v":0},null,null,{"$f":"+H69*(1-I69)","v":0}]
[null,"TREAT SEEPAGE - see \"Water Management\" and \"Water Treatment\""]
[null,"TREAT SUPERNATANT"]
[null,"Pump water (to pit, U/G)",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F72),0,INDEX(IF(UPPER(RIGHT(F72,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F72,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F72,LEN(F72)-1)),CostCode,0)))","v":0},{"$f":"G72*E72","v":0},null,{"$f":"H72*I72","v":0},{"$f":"+H72*(1-I72)","v":0}]
[null,"Equipment maintenance and parts",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},100000,{"$f":"G73*E73","v":0},null,{"$f":"H73*I73","v":0},{"$f":"+H73*(1-I73)","v":0}]
[null,"Supply reagents",null,"tonne",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F74),0,INDEX(IF(UPPER(RIGHT(F74,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F74,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F74,LEN(F74)-1)),CostCode,0)))","v":0},{"$f":"G74*E74","v":0},null,{"$f":"H74*I74","v":0},{"$f":"+H74*(1-I74)","v":0}]
[null,null,null,null,null,null,"Annual treatment costs",{"$f":"SUM(H72:H74)+0.0001","v":1E-4}]
[null,"Number of years of treatment",null,"years"]
[null,null,null,null,null,null,"Total treatment costs",{"$f":"H75*E76","v":0},null,null,{"$f":"H77","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H69)+H77+0.0001","v":15195574.058100002},null,{"$f":"SUM(J5:J69)+J77","v":7597787.029000001},{"$f":"SUM(K5:K69)+K77","v":7597787.029000001}]
[null,null,null,null,null,null,"% of Total",null,null,{"$f":"J78/H78","v":0.49999999999670958},{"$f":"K78/H78","v":0.49999999999670958}]
[null,"* for construction of passive treatment system refer to \"Water Management\""]

{"sheet":"Rock Pile","index":4,"n_rows":67,"n_cols":14,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[1,"Rock Pile Name:","Waste Rock and Overburden Dump"]
[]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost","% Land","Land Cost","Water Cost"]
[null,"STABILIZE SLOPES"]
[null,"Grade Waste Rock Pile","BM-024","m3",40778,"TMAC",0.95,{"$f":"G5*E5","v":38739.1},1,{"$f":"H5*I5","v":38739.1},{"$f":"+H5*(1-I5)","v":0}]
[null,"Grade Overburden Pile","BM-026","m3",17860,"TMAC",0.95,16967,1,16967,0]
[null,"Grade Old Camp Ore Pile","BM-040","m3",1512,"TMAC",0.95,1436.3999999999999,1,1436.3999999999999,0,null,null,{"$f":"SUM(E5:E7)","v":60150}]
[null,"Grade Ore Stockpile","BM-001 in BM-036 Bldg & Equip","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F8),0,INDEX(IF(UPPER(RIGHT(F8,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F8,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F8,LEN(F8)-1)),CostCode,0)))","v":0},0,null,0,0]
[null,"Toe buttress, drain mat'l",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Toe buttress, fill mat'l A",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Toe buttress, fill mat'l B",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"COVER ROCK PILE"]
[null,"Subgrade preparation - doze surface",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F14),0,INDEX(IF(UPPER(RIGHT(F14,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F14,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F14,LEN(F14)-1)),CostCode,0)))","v":0},{"$f":"G14*E14","v":0},null,{"$f":"H14*I14","v":0},{"$f":"+H14*(1-I14)","v":0}]
[null,"Soil cover - excavate,haul,spread&compact",null,"m3",null,"SB1L",4.3,0,null,0,0]
[null,"Rock cover - excavate,haul & spread",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Excavate downslope drainage channel & chute",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Rip rap drainage channel and chute",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Vegetate",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"VERY LOW PERMEABILITY COVER (in addition to above)"]
[null,"Liner subgrade preparation - compact",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F22),0,INDEX(IF(UPPER(RIGHT(F22,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F22,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F22,LEN(F22)-1)),CostCode,0)))","v":0},{"$f":"G22*E22","v":0},null,{"$f":"H22*I22","v":0},{"$f":"+H22*(1-I22)","v":0}]
[null,"Supply geomembrame",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F23),0,INDEX(IF(UPPER(RIGHT(F23,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F23,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F23,LEN(F23)-1)),CostCode,0)))","v":0},{"$f":"G23*E23","v":0},null,0,0]
[null,"Install geomembrane",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F24),0,INDEX(IF(UPPER(RIGHT(F24,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F24,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F24,LEN(F24)-1)),CostCode,0)))","v":0},{"$f":"G24*E24","v":0},null,0,0]
[null,"Protective cover - excavate,haul,spread&compact",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Vegetate",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Install infiltration/seepage instrumentation",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"CONSTRUCT DIVERSION DITCHES"]
[null,"Excavate ditches -soil",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F29),0,INDEX(IF(UPPER(RIGHT(F29,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F29,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F29,LEN(F29)-1)),CostCode,0)))","v":0},{"$f":"G29*E29","v":0},null,{"$f":"H29*I29","v":0},{"$f":"+H29*(1-I29)","v":0}]
[null,"Excavate ditches -rock",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F30),0,INDEX(IF(UPPER(RIGHT(F30,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F30,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F30,LEN(F30)-1)),CostCode,0)))","v":0},0,null,0,0]
[null,"Rip rap in channel base",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F31),0,INDEX(IF(UPPER(RIGHT(F31,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F31,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F31,LEN(F31)-1)),CostCode,0)))","v":0},0,null,0,0]
[null,"CONSTRUCT SEEPAGE COLLECTION POND"]
[null,"Excavate seepage collection pond",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H33*I33","v":0},{"$f":"+H33*(1-I33)","v":0}]
[null,"Doze & spread excavated material",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Vegetate spread material",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Bedding layer",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Supply geomembrane",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Install geomembrane",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Erosion protection layer",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"INSTALL GROUNDWATER COLLECTION SYSTEM"]
[null,"Excavate/install sumps",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F41),0,INDEX(IF(UPPER(RIGHT(F41,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F41,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F41,LEN(F41)-1)),CostCode,0)))","v":0},{"$f":"G41*E41","v":0},null,{"$f":"H41*I41","v":0},{"$f":"+H41*(1-I41)","v":0}]
[null,"Install pumping wells",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Install pumps/pipelines/power supply",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"RELOCATE DUMPS"]
[null,"Load, haul, dump or doze",null,"m3",null,"SC3L",{"$f":"IF(ISNA(F45),0,INDEX(IF(UPPER(RIGHT(F45,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F45,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F45,LEN(F45)-1)),CostCode,0)))","v":8.9},{"$f":"G45*E45","v":0},null,{"$f":"H45*I45","v":0},{"$f":"+H45*(1-I45)","v":0}]
[null,"Add lime",null,"tonne",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F46),0,INDEX(IF(UPPER(RIGHT(F46,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F46,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F46,LEN(F46)-1)),CostCode,0)))","v":0},{"$f":"G46*E46","v":0},null,{"$f":"H46*I46","v":0},{"$f":"+H46*(1-I46)","v":0}]
[null,"Contour reclaimed area",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F47),0,INDEX(IF(UPPER(RIGHT(F47,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F47,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F47,LEN(F47)-1)),CostCode,0)))","v":0},{"$f":"G47*E47","v":0},null,{"$f":"H47*I47","v":0},{"$f":"+H47*(1-I47)","v":0}]
[null,"Other",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},20000,{"$f":"G48*E48","v":0},null,{"$f":"H48*I48","v":0},{"$f":"+H48*(1-I48)","v":0}]
[null,"SPECIALIZED ITEMS"]
[null,"Install permanent instrumentation",null,"allow",null,"Ea",50000,{"$f":"G50*E50","v":0},null,{"$f":"H50*I50","v":0},{"$f":"+H50*(1-I50)","v":0}]
[null,"Install permanent instrumentation, drilling",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F51),0,INDEX(IF(UPPER(RIGHT(F51,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F51,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F51,LEN(F51)-1)),CostCode,0)))","v":0},{"$f":"G51*E51","v":0},null,{"$f":"H51*I51","v":0},{"$f":"+H51*(1-I51)","v":0}]
[null,"TREAT ROCK PILE SEEPAGE - see \"Water Management\""]
[null,"HEAP LEACH SEEPAGE TREATMENT - Cyanide Detox"]
[null,"Cyanide destruction water treatment pumping",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F54),0,INDEX(IF(UPPER(RIGHT(F54,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F54,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F54,LEN(F54)-1)),CostCode,0)))","v":0},{"$f":"G54*E54","v":0},null,{"$f":"H54*I54","v":0},{"$f":"+H54*(1-I54)","v":0}]
[null,"Reagents",null,"tonnes",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F55),0,INDEX(IF(UPPER(RIGHT(F55,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F55,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F55,LEN(F55)-1)),CostCode,0)))","v":0},{"$f":"G55*E55","v":0},null,{"$f":"H55*I55","v":0},{"$f":"+H55*(1-I55)","v":0}]
[null,"Electrician/mechanic to maintain treatment plant",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F56),0,INDEX(IF(UPPER(RIGHT(F56,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F56,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F56,LEN(F56)-1)),CostCode,0)))","v":0},{"$f":"G56*E56","v":0},null,{"$f":"H56*I56","v":0},{"$f":"+H56*(1-I56)","v":0}]
[null,"Equipment maintenance and parts",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F57),0,INDEX(IF(UPPER(RIGHT(F57,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F57,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F57,LEN(F57)-1)),CostCode,0)))","v":0},{"$f":"G57*E57","v":0},null,{"$f":"H57*I57","v":0},{"$f":"+H57*(1-I57)","v":0}]
[null,null,null,null,null,null,"Annual treatment costs",{"$f":"SUM(H54:H57)+0.0001","v":1E-4}]
[null,"Number of years of treatment",null,"years"]
[null,null,null,null,null,null,"Total treatment costs",{"$f":"H58*E59","v":0},null,null,{"$f":"H60","v":0}]
[null,"HEAP LEACH SEEPAGE TREATMENT - ARD/ML**"]
[null,"Upgrade/modify pumping system - report to WTP",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F62),0,INDEX(IF(UPPER(RIGHT(F62,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F62,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F62,LEN(F62)-1)),CostCode,0)))","v":0},{"$f":"G62*E62","v":0},null,null,{"$f":"H62","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H51)+H60+H62+0.0001","v":57142.500099999997},null,{"$f":"SUM(J5:J51)+J60+J62","v":57142.5},{"$f":"SUM(K5:K51)+K60+K62","v":0}]
[null,null,null,null,null,null,"% of Total",null,null,{"$f":"J63/H63","v":0.99999999824998909},{"$f":"K63/H63","v":0}]
[]
[null,"* For construction of passive treatment system refer to \"Water Management\".  ARD/ML seepage treatment becomes post-closure water treatment cost"]
[null,"**Heap leach ARD/ML seepage treatment becomes post-closure water treatment cost"]

{"sheet":"Chemicals","index":5,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[[2,1,2,7]]}
[1,"Chemicals/Soil Area Name:"]
[]
[null,"Note:         The procedures, equipment and packaging for clean up and removal of chemicals or contaminated soils are highly dependent on the nature of the chemicals and their existing state of containment. Government guidelines should be consulted on an individual chemical basis.  Any estimate made here should be considered very rough unless specific evaluations have been conducted."]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost","% Land","Land Cost","Water Cost"]
[null,"HAZARDOUS MATERIALS AUDIT"]
[null,"Hazardous materials audit","Not required","allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},25000,{"$f":"G6*E6","v":0},null,{"$f":"H6*I6","v":0},{"$f":"+H6*(1-I6)","v":0}]
[null,"BUILDING DECONTAMINATION & CONSOLIDATION OF HAZARDOUS MATERIALS"]
[null,"Environmental technician/coordinator",null,"mandays",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F8),0,INDEX(IF(UPPER(RIGHT(F8,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F8,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F8,LEN(F8)-1)),CostCode,0)))","v":0},{"$f":"G8*E8","v":0},null,{"$f":"H8*I8","v":0},{"$f":"+H8*(1-I8)","v":0}]
[null,"Drain residual fuel from tanks","BM-010","each",6,"TMAC",265,1590,0.5,795,795]
[null,"Clean containment liners","BM-010, BM -013 & BM -030","m2",{"$f":"4406+3800+2500","v":10706},"TMAC",0.41,{"$f":"G10*E10","v":4389.46},0.5,{"$f":"H10*I10","v":2194.73},{"$f":"+H10*(1-I10)","v":2194.73}]
[null,"Decontaminate maintenance shop",null,"mandays",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F11),0,INDEX(IF(UPPER(RIGHT(F11,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F11,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F11,LEN(F11)-1)),CostCode,0)))","v":0},0,null,0,0]
[null,"Decontaminate sewage treatment plant","BM-015","LS",1,"TMAC",667.63,667.63,0.5,333.815,333.815]
[null,"Decontaminate Water Discharge Line","BM-043","LS",1,"TMAC",667.63,{"$f":"G13*E13","v":667.63},0.5,{"$f":"H13*I13","v":333.815},{"$f":"+H13*(1-I13)","v":333.815}]
[null,"Decontaminate bulk fuel storage","BM-010","each",6,"TMAC",1186.71,7120.26,0.5,3560.13,3560.13]
[null,"Decontaminate Process Plant","BM-002","M3",4.16,"TMAC",2699.56,11230.169599999999,0.5,5615.0847999999996,5615.0847999999996]
[null,"Decontaminate offices/warehouse/accom",null,"m2",null,"BDAL",25.6,0,null,0,0]
[null,"Removal of asbestos siding on buildings",null,"m2",null,"BDAL",25.6,0,null,0,0]
[null,"Removal of friable asbestos on equipment",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"HAZARDOUS MATERIALS REMOVAL"]
[null,"Waste oils",null,"litre",null,"orl",{"$f":"IF(ISNA(F21),0,INDEX(IF(UPPER(RIGHT(F21,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F21,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F21,LEN(F21)-1)),CostCode,0)))","v":0.43},{"$f":"G21*E21","v":0},null,{"$f":"H21*I21","v":0},{"$f":"+H21*(1-I21)","v":0}]
[null,"Waste fuel","BM-010","litre",75000,"orl",0.43,32250,0.5,16125,16125]
[null,"Waste batteries",null,"allow",null,"AE",3000,0,null,0,0]
[null,"Assay & environmental lab reagents",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},25,0,null,0,0]
[null,"Machine shop paints, solvents etc",null,"litre",null,"AE",10000,0,null,0,0]
[null,"Glycol",null,"litre",null,"AE",20000,0,null,{"$f":"H26*I26","v":0},{"$f":"+H26*(1-I26)","v":0}]
[null,"Process reagents","BM-002","m3",5.4,"TMAC",{"$f":"72.73+15.37","v":88.100000000000009},{"$f":"G27*E27","v":475.74000000000007},0.5,{"$f":"H27*I27","v":237.87000000000003},{"$f":"+H27*(1-I27)","v":237.87000000000003}]
[null,"Nuclear sources",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F28),0,INDEX(IF(UPPER(RIGHT(F28,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F28,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F28,LEN(F28)-1)),CostCode,0)))","v":0},0,null,{"$f":"H28*I28","v":0},{"$f":"+H28*(1-I28)","v":0}]
[null,"Other hazardous materials",null,"allow",null,"AE",20000,{"$f":"G29*E29","v":0},null,{"$f":"H29*I29","v":0},{"$f":"+H29*(1-I29)","v":0}]
[null,"HAZARDOUS MATERIALS "]
[null,"Transportation to disposal facility",null,"allow",null,"ea",10000,{"$f":"G31*E31","v":0},0.5,{"$f":"H31*I31","v":0},{"$f":"+H31*(1-I31)","v":0}]
[null,"Disposal fees",null,"allow",null,"ea",20000,{"$f":"G32*E32","v":0},0.5,{"$f":"H32*I32","v":0},{"$f":"+H32*(1-I32)","v":0}]
[null,"Other",null,"allow",null,"ea",40000,{"$f":"G33*E33","v":0},0.5,{"$f":"H33*I33","v":0},{"$f":"+H33*(1-I33)","v":0}]
[null,"CONTAMINATED SOILS "]
[null,"Contam. soil investigation - Phase 1",null,"each",1,"CS1L",{"$f":"IF(ISNA(F35),0,INDEX(IF(UPPER(RIGHT(F35,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F35,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F35,LEN(F35)-1)),CostCode,0)))","v":7500},{"$f":"G35*E35","v":7500},0.5,{"$f":"H35*I35","v":3750},{"$f":"+H35*(1-I35)","v":3750}]
[null,"Contam. soil investigation - Phase 2","More money required for INAC to complete an ESA program","allow",1,"EA",100000,100000,0.5,50000,50000]
[null,"CONTAMINATED SOIL REMOVAL"]
[null,"Excavate and transport to Underground","BM-010 & BM-013","m3",{"$f":"1140+2643.6","v":3783.6},"TMAC",72.73,{"$f":"G38*E38","v":275181.228},0.5,{"$f":"H38*I38","v":137590.614},{"$f":"+H38*(1-I38)","v":137590.614}]
[null,"Place hydrocarbon underground","BM-010 & BM-013","m3",{"$f":"1140+2643.6","v":3783.6},"TMAC",15.37,58153.931999999993,0.5,29076.965999999997,29076.965999999997]
[null,"Reagents/stabilizing agent","BM-030 de-icier impacted soil to underground (consolidate liner cover, containerize and haul) ","m3",{"$f":"1500+5.4","v":1505.4},"TMAC",{"$f":"2.75+72.73+15.37","v":90.850000000000009},{"$f":"G40*E40","v":136765.59000000003},0.5,{"$f":"H40*I40","v":68382.795000000013},{"$f":"+H40*(1-I40)","v":68382.795000000013}]
[null,"Excavate and transport to offsite facility",null,"m3",null,"est.",1000,0,0.5,0,0]
[null,"Sludge from Oil/Water Separator",null,"m3",4,"TMAC",32.799999999999997,131.19999999999999,0.5,{"$f":"H42*I42","v":65.599999999999994},{"$f":"+H42*(1-I42)","v":65.599999999999994}]
[null,"CONTAMINATED SOIL VERY LOW PERMEABILITY COVER "]
[null,"Supply geomembrame, HDPE, ES3, GCL",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F44),0,INDEX(IF(UPPER(RIGHT(F44,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F44,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F44,LEN(F44)-1)),CostCode,0)))","v":0},{"$f":"G44*E44","v":0},null,{"$f":"H44*I44","v":0},{"$f":"+H44*(1-I44)","v":0}]
[null,"Upper and lower bedding layers",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Install geomembrane, HDPE, ES3, GCL",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Erosion protection layer",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Vegetate",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Install infiltration/seepage instrumentation",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H49*I49","v":0},{"$f":"+H49*(1-I49)","v":0}]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H50*I50","v":0},{"$f":"+H50*(1-I50)","v":0}]
[null,"OTHER"]
[null,null,null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F52),0,INDEX(IF(UPPER(RIGHT(F52,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F52,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F52,LEN(F52)-1)),CostCode,0)))","v":0},{"$f":"G52*E52","v":0},null,{"$f":"H52*I52","v":0},{"$f":"+H52*(1-I52)","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H6:H52)+0.0001","v":636122.83969999989},null,{"$f":"SUM(J6:J52)","v":318061.41979999997},{"$f":"SUM(K6:K52)","v":318061.41979999997}]
[null,null,null,null,null,null,"% of Total",null,null,{"$f":"J53/H53","v":0.49999999992139887},{"$f":"K53/H53","v":0.49999999992139887}]

{"sheet":"Bldgs & Equip","index":6,"n_rows":108,"n_cols":13,"rows_kept":108,"cut":false,"hidden":false,"merged":[[63,1,65,1],[55,1,56,1],[19,1,20,1],[22,1,23,1],[11,1,13,1],[14,1,18,1],[24,1,27,1],[53,1,54,1],[28,1,31,1],[59,1,62,1],[37,1,40,1]]}
[1,"Building / Equip Name:","Boston Mine",null,null,null,"Bldg / Equip #:",1]
[]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost","% Land","Land Cost","Water Cost"]
[null,"DISPOSE MOBILE EQUIPMENT"]
[null,"Decontaminate and ship off-site",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F5),0,INDEX(IF(UPPER(RIGHT(F5,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F5,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F5,LEN(F5)-1)),CostCode,0)))","v":0},{"$f":"G5*E5","v":0},null,{"$f":"H5*I5","v":0},{"$f":"+H5*(1-I5)","v":0}]
[null,"Decontaminate and dispose on-site",null,"manhours",null,"mechl",{"$f":"IF(ISNA(F6),0,INDEX(IF(UPPER(RIGHT(F6,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F6,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F6,LEN(F6)-1)),CostCode,0)))","v":49},{"$f":"G6*E6","v":0},1,{"$f":"H6*I6","v":0},{"$f":"+H6*(1-I6)","v":0}]
[null,"Relocate Containers to Roberts Bay","BM-034 (3)","ea",3,"TMAC",1345,{"$f":"G7*E7","v":4035},1,{"$f":"H7*I7","v":4035},{"$f":"+H7*(1-I7)","v":0}]
[null,"Relocate Trailers to Roberts Bay","BM-034","m3",112,"TMAC",19.149999999999999,2144.7999999999997,1,2144.7999999999997,0]
[]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F10),0,INDEX(IF(UPPER(RIGHT(F10,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F10,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F10,LEN(F10)-1)),CostCode,0)))","v":0},{"$f":"G10*E10","v":0},null,0,0]
[null,"REMOVE BUILDINGS "]
[null,"Accomodation Complex ","BM-018 Demolition","m3",{"$f":"13843+1000","v":14843},"TMAC",13.12,{"$f":"G12*E12","v":194740.15999999997},1,194740.15999999997,0]
[null,null,"BM-018 elec/mech discommissioning","each",300,"TMAC",679.52,203856,1,203856,0]
[null,null,"BM-018 - Containerization and disposal","m3",{"$f":"23330","v":23330},"TMAC",13.49,{"$f":"G14*E14","v":314721.7},1,{"$f":"H14*I14","v":314721.7},{"$f":"+H14*(1-I14)","v":0},null,"Quantity amended to SRK amount"]
[null,"Process Facilities","BM-002 includes Dismantling and Demolition of Mill, Crusher and Process Plant","LS",1,"TMAC",{"$f":"200000+100000","v":300000},300000,1,300000,0]
[null,null,"BM-020 demolition only","m3",198800,"TMAC",13.12,2608256,1,2608256,0]
[null,null,"BM-020 office decommissioning ","each",2,"TMAC",679.52,{"$f":"G17*E17","v":1359.04},1,{"$f":"H17*I17","v":1359.04},{"$f":"+H17*(1-I17)","v":0}]
[null,null,"Bm-020 Collect surface debris","m2",14000,"TMAC",0.37,{"$f":"G18*E18","v":5180},1,{"$f":"H18*I18","v":5180},{"$f":"+H18*(1-I18)","v":0}]
[null,null,"BM-020 transfer to landfill","m3",{"$f":"198800*0.05","v":9940},"TMAC",{"$f":"10.23+3.26","v":13.49},{"$f":"G19*E19","v":134090.6},1,{"$f":"H19*I19","v":134090.6},{"$f":"+H19*(1-I19)","v":0},null,"update unit rate to reflect containerization and transfer.  Quantity amended to 5% of total building volume where processing is done in a simple structure with only primary process equipment. Also includes some allowance for surface debris transfer."]
[null,"Offices, Repair, Lab, Warehouse","BM-004, BM-005,BM-006, BM-007 demo, load, haul and tip at landfill","m3",{"$f":"300+90+90+90","v":570},"TMAC",{"$f":"13.12+10.23+3.26","v":26.61},15167.699999999999,1,15167.699999999999,0]
[null,null,"decommission equipment","each",6,"TMAC",679.52,{"$f":"G21*E21","v":4077.12},1,{"$f":"H21*I21","v":4077.12},{"$f":"+H21*(1-I21)","v":0}]
[null,"Storage Facilites",null,"m2",null,null,null,{"$f":"F22*G22","v":0},1,0,0]
[null,"Water and Wastewater Treatment Facilities","BM-011 dismantle equipment","ea",1,"TMAC",1369,{"$f":"G23*E23","v":1369},1,1369,0]
[null,null,"BM-011 dismantle and haul to landfill","m3",150,"TMAC",59.95,8992.5,1,8992.5,0]
[null,"Fire Water Tank","BM-017 demolition","m3",74.42,"TMAC",13.12,{"$f":"G25*E25","v":976.3904},1,{"$f":"H25*I25","v":976.3904},{"$f":"+H25*(1-I25)","v":0}]
[null,null,"BM-017 dismantle into cut for haulage","each",1,"TMAC",74212,{"$f":"G26*E26","v":74212},1,{"$f":"H26*I26","v":74212},{"$f":"+H26*(1-I26)","v":0}]
[null,null,"BM-017 elec/mech discommissioning","each",2,"TMAC",1328,{"$f":"G27*E27","v":2656},1,{"$f":"H27*I27","v":2656},{"$f":"+H27*(1-I27)","v":0}]
[null,null,"BM-017 consolidate and haul to landfill","m3",{"$f":"37+2.2","v":39.200000000000003},"TMAC",{"$f":"10.23+3.26","v":13.49},{"$f":"G28*E28","v":528.80799999999999},1,{"$f":"H28*I28","v":528.80799999999999},{"$f":"+H28*(1-I28)","v":0}]
[null,"Power Plant","BM-003 includes dismantling/demolition and haulage to Landfill","m3",3151,"TMAC",{"$f":"13.12+10.23+3.26","v":26.61},83848.11,1,83848.11,0]
[null,null,"BM-003 dismantle equipment","ea",4,"TMAC",784.27,{"$f":"G30*E30","v":3137.08},1,{"$f":"H30*I30","v":3137.08},{"$f":"+H30*(1-I30)","v":0}]
[null,null,"BM-003 Prep equipment for offsite shipment","LS",1,"TMAC",50000,50000,1,{"$f":"H31*I31","v":50000},{"$f":"+H31*(1-I31)","v":0}]
[null,null,"Dismantle, prep and haul stacks for offsite disposal","lm",40,"TMAC",{"$f":"136.3+627.24+116","v":879.54},{"$f":"G32*E32","v":35181.599999999999},1,{"$f":"H32*I32","v":35181.599999999999},{"$f":"+H32*(1-I32)","v":0}]
[null,"Communication Tower",null,"m2",null,"brs1h",{"$f":"IF(ISNA(F33),0,INDEX(IF(UPPER(RIGHT(F33,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F33,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F33,LEN(F33)-1)),CostCode,0)))","v":65},{"$f":"G33*E33","v":0},1,{"$f":"H33*I33","v":0},{"$f":"+H33*(1-I33)","v":0}]
[null,"U/G Heating Plant",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,1,0,0]
[null,"Emulsion Plant",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F35),0,INDEX(IF(UPPER(RIGHT(F35,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F35,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F35,LEN(F35)-1)),CostCode,0)))","v":0},0,1,0,0]
[null,"AN Storage Facility",null,"m2",null,"brs1s",128,0,1,{"$f":"H36*I36","v":0},{"$f":"+H36*(1-I36)","v":0}]
[null,"Warehouse, Shops and Other","BM-009, BM-012 dismantle and transfer to  Landfill","m3",{"$f":"2250+150","v":2400},"TMAC",{"$f":"13.12+10.23+3.26","v":26.61},63864,1,63864,0]
[null,"Laydown area and Core Pad","BM-014 & BM-019 surface clean up","m2",{"$f":"10000+9300","v":19300},"TMAC",0.37,7141,1,7141,0]
[null,null,"Post removals","ea",10,"TMAC",411.17,{"$f":"G39*E39","v":4111.7},1,{"$f":"H39*I39","v":4111.7},{"$f":"+H39*(1-I39)","v":0}]
[null,null,"BM-019 consolidating core boxes","each",500,"TMAC",11.36,{"$f":"G40*E40","v":5680},1,{"$f":"H40*I40","v":5680},{"$f":"+H40*(1-I40)","v":0},null,"Amended to reflect correction in work type and quantity"]
[null,null,"BM-014 & BM-019 debris haul and dispose of at landfill","m3",{"$f":"6+5.6","v":11.6},"TMAC",{"$f":"10.23+2.36","v":12.59},{"$f":"G41*E41","v":146.04399999999998},1,{"$f":"H41*I41","v":146.04399999999998},{"$f":"+H41*(1-I41)","v":0},null,"Amended quantity to reflect change in item 40"]
[null,"Fuel tanks","BM-010","ea",6,"TMAC",74500,447000,0.5,223500,223500,null,"rounded to the nearest $500"]
[null,"Remove containment liner","BM-010, BM-030 & BM-013","m2",{"$f":"2500+3800+3*E44","v":29001.599999999999},"TMAC",0.56999999999999995,{"$f":"G43*E43","v":16530.911999999997},0.5,8265.4559999999983,8265.4559999999983]
[null,"Excavate containment area","BM-010 & BM-013","m3",{"$f":"2280+5287.2","v":7567.2},"TMAC",2.75,{"$f":"G44*E44","v":20809.8},0.5,10404.9,10404.9]
[null,"Fuel tank piping and containment structure","BM-010 includes load and transport to landfill","m3",{"$f":"23.74+63.39","v":87.13},"TMAC",{"$f":"10.23+14.08","v":24.310000000000002},{"$f":"G45*E45","v":2118.1303000000003},0.5,1059.0651500000001,1059.0651500000001]
[null,"Water Discharge Line","BM-043","m",282,"TMAC",10.79,3042.7799999999997,1,3042.7799999999997,0]
[null,"Water Discharge Line -electrical","BM-43","ea",2,"TMAC",679.52,1359.04,1,1359.04,0]
[null,"Water Discharge ","BM-043 demo and landfill","m3",13.8,"TMAC",{"$f":"10.23+3.26","v":13.49},186.16200000000001,1,186.16200000000001,0]
[null,"Contact Ponds decommissioning","BM-021, BM-025, BM-027 & BM-032","m3",{"$f":"180+1.2+1.2+1.6","v":183.99999999999997},"TMAC",{"$f":"10.23+3.26","v":13.49},{"$f":"G49*E49","v":2482.16},1,{"$f":"H49*I49","v":2482.16},{"$f":"+H49*(1-I49)","v":0}]
[null,"Airstrip lighting, navigation, electrician","Tower fixtures","ea",10,"TMAC",68.150000000000006,681.5,1,681.5,0]
[null,"Airstrip lighting, navigation, mechanical","Tower fixtures and equipment","ea",2,"TMAC",374.34,748.68,1,748.68,0]
[null,"Break foundation slabs",null,"m2",null,"brcs",{"$f":"IF(ISNA(F52),0,INDEX(IF(UPPER(RIGHT(F52,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F52,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F52,LEN(F52)-1)),CostCode,0)))","v":6},{"$f":"G52*E52","v":0},1,{"$f":"H52*I52","v":0},{"$f":"+H52*(1-I52)","v":0}]
[null,"Consolidate & dump boneyard debris",null,"allow",null,"brs1l",45,0,1,0,0]
[null,"Worker Dry","BM-008 Demo, prep and haul waste to landfill","m3",682,"TMAC",{"$f":"13.12+10.23+3.26","v":26.61},{"$f":"G54*E54","v":18148.02},1,{"$f":"H54*I54","v":18148.02},{"$f":"+H54*(1-I54)","v":0}]
[null,null,"BM-008 decommission equipment","ea",3,"TMAC",679.52,{"$f":"G55*E55","v":2038.56},1,{"$f":"H55*I55","v":2038.56},{"$f":"+H55*(1-I55)","v":0}]
[null,"Potable WTP & STP","BM-015 & BM-016 Decon electrical","ea",{"$f":"105+2","v":107},"TMAC",679.52,72708.639999999999,1,72708.639999999999,0]
[null,null,"BM-015 & BM -016 demo and landfill","m3",{"$f":"75+7.5","v":82.5},"TMAC",{"$f":"13.12+10.23+3.26","v":26.61},{"$f":"G57*E57","v":2195.3249999999998},1,{"$f":"H57*I57","v":2195.3249999999998},{"$f":"+H57*(1-I57)","v":0}]
[null,"WTP Mine Water",null,"m2",null,"brs1l",45,0,1,0,0]
[null,"Water Intake",null,"m2",null,"brcs",6,0,1,0,0]
[null,"Airstrip/Apron and Helipad","BM-029, BM-030 and BM-034 clean up","m2",{"$f":"1540+60960+6000","v":68500},"TMAC",0.37,{"$f":"G60*E60","v":25345},1,{"$f":"H60*I60","v":25345},{"$f":"+H60*(1-I60)","v":0}]
[null,null,"demo heli shack includes containerization and haul to landfill","m3",45,"TMAC",{"$f":"13.12+10.23+3.26","v":26.61},1197.45,1,1197.45,0]
[null,null,"Remove lighting","ea",70,"TMAC",42.47,{"$f":"G62*E62","v":2972.9},1,{"$f":"H62*I62","v":2972.9},{"$f":"+H62*(1-I62)","v":0}]
[null,null,"BM-029, BM-030 and BM-034 includes disposal in landfill","m3",{"$f":"51.519+25.984+36.576","v":114.07900000000001},"TMAC",{"$f":"10.23+3.26","v":13.49},{"$f":"G63*E63","v":1538.9257100000002},1,{"$f":"H63*I63","v":1538.9257100000002},{"$f":"+H63*(1-I63)","v":0}]
[null,"Other","clean up general areas","m2",1100,"TMAC",0.37,407,1,407,0]
[null,null,"General Area debris haulage and disposal in landfill","m2",1100,"TMAC",0.15,{"$f":"G65*E65","v":165},1,{"$f":"H65*I65","v":165},{"$f":"+H65*(1-I65)","v":0}]
[null,null,"Seacan landfill placement (double SRK volume)","m3",{"$f":"1129.5","v":1129.5},"TMAC",86.72,97950.24,1,97950.24,0,null,"understand that we are now not breaking down the seacans."]
[null,"LANDFILL FOR DEMOLITION WASTE"]
[null,"Place rock cover","BM-038","m3",8112,"TMAC",16.350000000000001,{"$f":"G68*E68","v":132631.20000000001},1,{"$f":"H68*I68","v":132631.20000000001},{"$f":"+H68*(1-I68)","v":0}]
[null,"Generate rock cover","BM-038 assumes 300 mm cover","m3",8112,"TMAC",24.76,{"$f":"G69*E69","v":200853.12000000002},1,{"$f":"H69*I69","v":200853.12000000002},{"$f":"+H69*(1-I69)","v":0}]
[null,"Final grading of landfill cover","BM-038","m2",27040,"TMAC",1.23,{"$f":"G70*E70","v":33259.199999999997},1,33259.199999999997,0]
[null,"Place soil cover",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},null,{"$f":"G71*E71","v":0},null,0,{"$f":"+H71*(1-I71)","v":0}]
[null,"Vegetate",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F72),0,INDEX(IF(UPPER(RIGHT(F72,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F72,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F72,LEN(F72)-1)),CostCode,0)))","v":0},{"$f":"G72*E72","v":0},null,0,0]
[null,"GRADE AND CONTOUR PADS"]
[null,"Accomodation Complex",null,"m2",null,"AE",8.4700000000000006,{"$f":"G74*E74","v":0},0.5,0,0]
[null,"Process Facilities",null,"m2",null,"AE",8.4700000000000006,0,0.5,0,0]
[null,"Offices, Repair, Lab, Warehouse",null,"m2",null,"AE",8.4700000000000006,0,0.5,0,0]
[null,"Storage Facilites",null,"m2",null,"AE",8.4700000000000006,0,0.5,0,0]
[null,"Water and Wastewater Treatment Facilities",null,"m2",null,"AE",8.4700000000000006,0,0.5,0,0]
[null,"Power Plant",null,"m2",null,"AE",8.4700000000000006,{"$f":"G79*E79","v":0},0.5,{"$f":"H79*I79","v":0},{"$f":"+H79*(1-I79)","v":0}]
[null,"Communication Tower",null,"m2",null,"AE",8.4700000000000006,0,0.5,0,0]
[null,"U/G Heating Plant",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F81),0,INDEX(IF(UPPER(RIGHT(F81,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F81,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F81,LEN(F81)-1)),CostCode,0)))","v":0},0,0.5,0,0]
[null,"Emulsion Plant",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,0.5,0,0]
[null,"Warehouse, Shops and Other",null,"m2",null,"AE",8.4700000000000006,0,0.5,0,0]
[null,"Fuel tanks on site for bulk fuel storage",null,"m2",null,"AE",8.4700000000000006,0,0.5,0,0]
[null,"Fire Protection pumping station",null,"m2",null,"AE",8.4700000000000006,0,0.5,0,0]
[null,"Worker Dry",null,"m2",null,"AE",8.4700000000000006,0,0.5,0,0]
[null,"WTP & Fresh Water Pumping Station",null,"m2",null,"AE",8.4700000000000006,0,0.5,0,0]
[null,"WRSF Pond and Attenuation Pond Pumphouses ",null,"m2",null,"AE",8.4700000000000006,0,0.5,0,0]
[null,"Other","BM-036 Developed Areas","m2",122000,"DSL",0.24,29280,1,29280,0,null,"reduced from 0.95 to 0.24 to reflect easier grading with grader"]
[]
[null,"REMOVE LINED CONTAINMENT STRUCTURES"]
[null,"Decontaminate/Remove/Dispose of Liner","see Chemicals or Water Treatment","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F92),0,INDEX(IF(UPPER(RIGHT(F92,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F92,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F92,LEN(F92)-1)),CostCode,0)))","v":0},{"$f":"G92*E92","v":0},null,{"$f":"H92*I92","v":0},{"$f":"+H92*(1-I92)","v":0}]
[]
[]
[null,"RECLAIM ROADS"]
[null,"Remove culverts",null,"lm",null,"TMAC",95.76,{"$f":"G96*E96","v":0},null,0,0]
[null,"Remove bridges",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F97),0,INDEX(IF(UPPER(RIGHT(F97,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F97,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F97,LEN(F97)-1)),CostCode,0)))","v":0},0,null,0,0]
[null,"Grade roads","BM-023, BM-037, BM-039 and BM-045 (assumes 4.1 km of road at 10 m width)","ha",{"$f":"(0.3+1+1.3+1.5)*1000*10/100000","v":0.41},"TMAC",9400,3853.9999999999995,1,3853.9999999999995,0,null,"Reduced to match cost associated with using a grader"]
[null,"Grade Helipad, Airstrip and Aprons","BM-029, BM-030 and BM-034","ha",{"$f":"(1540+60960+6000)/10000","v":6.85},"TMAC",9400,{"$f":"G99*E99","v":64390},1,{"$f":"H99*I99","v":64390},{"$f":"+H99*(1-I99)","v":0},null,"Reduced to match cost associated with using a grader"]
[null,"Scarify ore piles laydown area",null,"ha",null,"scfyl",4300,0,null,0,0]
[null,"Vegetate",null,"allow",null,"ea",20000,0,null,{"$f":"H101*I101","v":0},0]
[null,"Other",null,"ha",null,"scfyh",6030,0,null,{"$f":"H102*I102","v":0},0]
[null,"SPECIALIZED ITEMS"]
[null,"Dispose of misc. debris and laydown area refuse",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F104),0,INDEX(IF(UPPER(RIGHT(F104,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F104,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F104,LEN(F104)-1)),CostCode,0)))","v":0},{"$f":"G104*E104","v":0},null,{"$f":"H104*I104","v":0},0]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H104)+0.0001","v":5313366.0975100007},null,{"$f":"SUM(J5:J104)","v":5070136.676260002},{"$f":"SUM(K5:K104)","v":243229.42115000001}]
[null,null,null,null,null,null,"% of Total",null,null,{"$f":"J105/H105","v":0.95422310136619737},{"$f":"K105/H105","v":4.5776898614982402E-2}]
[]
[null,"Note:  "]

{"sheet":"ICM","index":7,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[1,"Interim Care and Maintenance"]
[]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost"]
[null,"INTERIM CARE & MAINTENANCE"]
[null,"on-site caretaker","supervisor","manmonths",null,"superh",{"$f":"IF(ISNA(F5),0,INDEX(IF(UPPER(RIGHT(F5,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F5,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F5,LEN(F5)-1)),CostCode,0)))","v":91.84},{"$f":"G5*E5","v":0}]
[null,"extra personnel","one skilled labourer","manmonths",null,"lab-sl",41,0]
[null,"    -electrician","assumes water treatment still required","manmonths",null,"elech",{"$f":"IF(ISNA(F7),0,INDEX(IF(UPPER(RIGHT(F7,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F7,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F7,LEN(F7)-1)),CostCode,0)))","v":95},{"$f":"G7*E7","v":0}]
[null,"    -mechanic","assumes water treatment still required","manmonths",null,"mechh",{"$f":"IF(ISNA(F8),0,INDEX(IF(UPPER(RIGHT(F8,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F8,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F8,LEN(F8)-1)),CostCode,0)))","v":72.849999999999994},{"$f":"G8*E8","v":0}]
[null,"annual fuel",null,"litre",null,"fcdh",1.39,0]
[null,"misc. supplies",null,"allow",null,"accmh",{"$f":"IF(ISNA(F10),0,INDEX(IF(UPPER(RIGHT(F10,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F10,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F10,LEN(F10)-1)),CostCode,0)))","v":175},{"$f":"G10*E10","v":0}]
[null,"pick-up truck",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"small dozer",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"small excavator",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"snow machine",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Operation and Maintenance ","includes camp operations","allow",1,"TMAC",1440000,1440000]
[null,"Mobilization of ICM equipment fleet",null,"allow",0.33,"TMAC",118000,38940]
[null,"communications",null,"allow",1,"ACI",1500,1500]
[null,"SNP/AEMP water sampling & reporting",null,"each",1,"TMAC",60000,60000]
[null,"Regulatory Reporting",null,"each",1,"TMAC",20000,{"$f":"G19*E19","v":20000}]
[null,"geotechnical assessment",null,"each",1,"TMAC",35000,35000]
[null,"interim water treatment",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},null,{"$f":"AnnualTreat1Cost","v":1E-4}]
[null,"other",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,null,null,null,null,null,"Annual  Interim C&M Cost",{"$f":"SUM(H5:H22)","v":1595440.0001000001}]
[null,"Number of years of ICM",null,"years",3,null,"Total",{"$f":"H23*E24","v":4786320.0003000004}]

{"sheet":"PostClosure","index":8,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[1,"Post-Closure Monitoring &  Maintenance:"]
[]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost"]
[null,"MONITORING & INSPECTIONS"]
[null,"Annual geotechnical inspection","Year 1, 2, 3, 6, 10, 15, 20, & 25","each",1,"TMAC",28000,{"$f":"G5*E5","v":28000},"8 inspections @$35,000 each = $280,000",null,{"$f":"8*35000","v":280000}]
[null,"Cover Monitoirng Inspections","Year 2, 4, 6, 8, 10, 15, 20 &25","each",1,"TMAC",28000,{"$f":"G6*E6","v":28000},"8 inspections @$35,000 each = $280,000"]
[null,"Surface water sampling","Year 1 - 5, 7, 10, 15, 20 & 25","each",1,"TMAC",60000,{"$f":"G7*E7","v":60000},"10 insepctions @$60,000 = $600,000"]
[null,"Groundwater sampling",null,"each",null,"wsh",{"$f":"IF(ISNA(F8),0,INDEX(IF(UPPER(RIGHT(F8,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F8,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F8,LEN(F8)-1)),CostCode,0)))","v":10000},0]
[null,"Receiving.downstream water sampling",null,"each",null,"wsh",10000,0]
[null,"Monitoring program","initial confirmatory program","each",1,"TMAC",10000,10000,"1 time event prorated for 10 years total = $100,000"]
[null,"Survey inspection",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F11),0,INDEX(IF(UPPER(RIGHT(F11,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F11,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F11,LEN(F11)-1)),CostCode,0)))","v":0},0]
[null,"Regulatory Monitoring*","Year 1 - 10, 15, 20 & 25","each",1,"TMAC",26000,26000,"13 insepctions @$20,000 = $260,000"]
[null,"Site water monitoring (AEMP and SNP)",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},25000,0]
[null,"   - Active closure and flooding",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"   - Post pit flooding",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Air Quality Monitoring Program (AQMP)",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Wildlife Effects Monitoring Program (WEMP)",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F17),0,INDEX(IF(UPPER(RIGHT(F17,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F17,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F17,LEN(F17)-1)),CostCode,0)))","v":0},0]
[null,"Vegetation Monitoring",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Other","Equipment mechanic for inspections","days",5,"TMAC",1157.53,{"$f":"G19*E19","v":5787.65},"approximately 50 days of mechanic time over ten years"]
[null,"COVER MAINTENANCE"]
[null,"Repair erosion - infill gullies",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Repair erosion - upgrade diversion ditches",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G22*E22","v":0}]
[null,"Remove problem vegetation",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Repair animal damage",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Repair/upgrade access controls",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"SPILLWAY MAINTENANCE"]
[null,"Repair erosion",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Clear spillway",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G29*E29","v":0}]
[null,"CWTS MAINTENANCE"]
[null,"Maintain flow, restore vegetation",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F31),0,INDEX(IF(UPPER(RIGHT(F31,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F31,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F31,LEN(F31)-1)),CostCode,0)))","v":0},{"$f":"G31*E31","v":0}]
[null,"POST-CLOSURE WATER TREATMENT"]
[null,"water treatment - refer to water treatment tab",null,null,1,"wt tab",{"$f":"AnnualTreat1Cost","v":1E-4},{"$f":"G33*E33","v":1E-4}]
[]
[null,"Subtotal, Annual post-closure costs ",null,null,null,null,null,{"$f":"SUM(H5:H34)+0.0001","v":157787.6502}]
[]
[null,"Discount rate for calculation of net present value of post-closure cost, %"]
[null,"Number of years of post-closure activity",null,null,null,10,"years"]
[null,"Present Value of payment stream",null,null,null,null,null,{"$f":"PV(DiscountRate,PCYears, PCAnnualTotal)*-1","v":1577876.5020000001}]
[]
[null,"*Regulatory costs - annual reporting, management plans, progress reports etc."]

{"sheet":"Mobilization","index":9,"n_rows":63,"n_cols":10,"rows_kept":63,"cut":false,"hidden":false,"merged":[[56,2,57,2]]}
[1,"Mobilization/Demobilization:"]
[]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost"]
[null,"MOBILIZE HEAVY EQUIPMENT"]
[null,"Excavators",null,"km",null,"mherh",{"$f":"IF(ISNA(F5),0,INDEX(IF(UPPER(RIGHT(F5,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F5,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F5,LEN(F5)-1)),CostCode,0)))","v":10.25},{"$f":"G5*E5","v":0}]
[null,"Dump trucks",null,"km",null,"mherl",3.4,0]
[null,"Dozers",null,"km",null,"mherh",10.25,0]
[null,"Demolition shears",null,"km",null,"mherh",10.25,0]
[null,"Crane",null,"km",null,"mherh",10.25,0]
[null,"Loader",null,"km",null,"mherh",10.25,{"$f":"G10*E10","v":0}]
[null,"Compactor",null,"km",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F11),0,INDEX(IF(UPPER(RIGHT(F11,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F11,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F11,LEN(F11)-1)),CostCode,0)))","v":0},{"$f":"G11*E11","v":0}]
[null,"Light duty vehicles",null,"km",null,"mherl",3.4,0]
[null,"MOBILIZE MISC. EQUIPMENT"]
[null,"Pump shipping",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F14),0,INDEX(IF(UPPER(RIGHT(F14,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F14,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F14,LEN(F14)-1)),CostCode,0)))","v":0},{"$f":"G14*E14","v":0}]
[null,"Pipe shipping",null,"m",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F15),0,INDEX(IF(UPPER(RIGHT(F15,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F15,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F15,LEN(F15)-1)),CostCode,0)))","v":0},{"$f":"G15*E15","v":0}]
[null,"Minor tools and equipment",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},100000,{"$f":"G16*E16","v":0}]
[null,"Truck tires ",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F17),0,INDEX(IF(UPPER(RIGHT(F17,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F17,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F17,LEN(F17)-1)),CostCode,0)))","v":0},{"$f":"G17*E17","v":0}]
[null,"Other","Mobilization of equipment and material ","allow",1,"TMAC",1071125,1071125]
[]
[null,"MOBILIZE CAMP"]
[null,"Maintain Camp Accomodations","Food ","mandays",9720,"TMAC",100,{"$f":"G21*E21","v":972000}]
[null,"Camp Mobilization/Demobilization",null,"LS",1,"TMAC",170450,170450]
[null,"Camp Rental",null,"year",1.3,"TMAC",668250,868725]
[null,"Camp Operations",null,"year",1.3,"TMAC",405000,526500]
[null,"Reclamation activities",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F25),0,INDEX(IF(UPPER(RIGHT(F25,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F25,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F25,LEN(F25)-1)),CostCode,0)))","v":0},0]
[null,"Long term reclamation activities (eg pump flooding)",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F26),0,INDEX(IF(UPPER(RIGHT(F26,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F26,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F26,LEN(F26)-1)),CostCode,0)))","v":0},0]
[null,"MOBILIZE WORKERS"]
[null,"Reclamation activities - transport","air charter only","flights",34,"TMAC",10620,{"$f":"G28*E28","v":361080}]
[null,"Reclamation activities - travel time","twenty workers three hours per shift","manhours",0,"ACI",80,{"$f":"G29*E29","v":0},null,"Removed time as cost is incorporated into hourly rates per SRK memo of 31 Aug 2018"]
[null,"Long term reclamation activities (eg pump flooding) - transport",null,"each",null,"AE",3500,{"$f":"G30*E30","v":0}]
[null,"Long term reclamation activities (eg pump flooding) - travel time",null,"manhours",null,"AE",80,{"$f":"G31*E31","v":0}]
[null,"Monitoring Airfare",null,"each",null,"mwl",{"$f":"IF(ISNA(F32),0,INDEX(IF(UPPER(RIGHT(F32,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F32,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F32,LEN(F32)-1)),CostCode,0)))","v":4500},{"$f":"G32*E32","v":0}]
[null," WORKER ACCOMODATIONS"]
[null,"Reclamation activities",null,"manmonths",null,{"$f":"NA()","v":{"$error":"#N/A"}},2225,{"$f":"G34*E34","v":0}]
[null,"Long term reclamation activities (eg pump flooding)",null,"manmonths",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F35),0,INDEX(IF(UPPER(RIGHT(F35,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F35,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F35,LEN(F35)-1)),CostCode,0)))","v":0},{"$f":"G35*E35","v":0}]
[null,"MOBILIZE FUEL"]
[null,"Fuel freight - reclamation activities","assumes sufficient fuel is on site to complete the work","litre",null,"fcdh",{"$f":"IF(ISNA(F37),0,INDEX(IF(UPPER(RIGHT(F37,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F37,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F37,LEN(F37)-1)),CostCode,0)))","v":1.39},{"$f":"G37*E37","v":0}]
[null,"Fuel freight - long term reclamation activities","assumes sufficient fuel is on site to complete the work","litre",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F38),0,INDEX(IF(UPPER(RIGHT(F38,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F38,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F38,LEN(F38)-1)),CostCode,0)))","v":0},{"$f":"G38*E38","v":0}]
[null,"Fuel freight accomodations",null,"litre",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F39),0,INDEX(IF(UPPER(RIGHT(F39,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F39,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F39,LEN(F39)-1)),CostCode,0)))","v":0},{"$f":"G39*E39","v":0}]
[null,"WINTER ROAD"]
[null,"Construction and operation",null,"km",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F41),0,INDEX(IF(UPPER(RIGHT(F41,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F41,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F41,LEN(F41)-1)),CostCode,0)))","v":0},{"$f":"G41*E41","v":0}]
[null,"Limited winter use",null,"km",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F42),0,INDEX(IF(UPPER(RIGHT(F42,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F42,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F42,LEN(F42)-1)),CostCode,0)))","v":0},{"$f":"G42*E42","v":0}]
[null,"Winter road tarriff",null,"km",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F43),0,INDEX(IF(UPPER(RIGHT(F43,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F43,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F43,LEN(F43)-1)),CostCode,0)))","v":0},{"$f":"G43*E43","v":0}]
[null,"DEMOBILIZE HEAVY EQUIPMENT"]
[null,"Excavators","assume two excavators","km",null,"mherh",{"$f":"IF(ISNA(F45),0,INDEX(IF(UPPER(RIGHT(F45,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F45,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F45,LEN(F45)-1)),CostCode,0)))","v":10.25},{"$f":"G45*E45","v":0}]
[null,"Dump trucks","assume four dump trucks","km",null,"mherl",{"$f":"IF(ISNA(F46),0,INDEX(IF(UPPER(RIGHT(F46,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F46,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F46,LEN(F46)-1)),CostCode,0)))","v":3.4},0]
[null,"Dozers","assume two dozers","km",null,"mherh",10.25,0]
[null,"Demolition shears","assume one set of shears","km",null,"mherh",10.25,0]
[null,"Crane","assume one crane ","km",null,"mherh",10.25,0]
[null,"Loader","assume one loader","km",null,"mherh",{"$f":"IF(ISNA(F50),0,INDEX(IF(UPPER(RIGHT(F50,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F50,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F50,LEN(F50)-1)),CostCode,0)))","v":10.25},{"$f":"G50*E50","v":0}]
[null,"Compactor",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F51),0,INDEX(IF(UPPER(RIGHT(F51,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F51,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F51,LEN(F51)-1)),CostCode,0)))","v":0},{"$f":"G51*E51","v":0}]
[null,"Light duty vehicles","assume three trucks","km",null,"mherl",3.4,0]
[null,"Other","Demobilization of equipment and material","allow",1,"TMAC",1071125,{"$f":"G53*E53","v":1071125}]
[null,"DEMOBILIZE CAMP"]
[null,null,null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F55),0,INDEX(IF(UPPER(RIGHT(F55,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F55,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F55,LEN(F55)-1)),CostCode,0)))","v":0},{"$f":"G55*E55","v":0}]
[null,"DEMOBILIZE WORKERS"]
[null,"crew travel time","cost in mobilization of workers.","mandays",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F57),0,INDEX(IF(UPPER(RIGHT(F57,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F57,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F57,LEN(F57)-1)),CostCode,0)))","v":0},{"$f":"G57*E57","v":0}]
[null,"crew transportation",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F58),0,INDEX(IF(UPPER(RIGHT(F58,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F58,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F58,LEN(F58)-1)),CostCode,0)))","v":0},{"$f":"G58*E58","v":0}]
[null,"WINTER ROAD"]
[null,"Construction and operation",null,"km",null,"wrcl",{"$f":"IF(ISNA(F60),0,INDEX(IF(UPPER(RIGHT(F60,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F60,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F60,LEN(F60)-1)),CostCode,0)))","v":2000},{"$f":"G60*E60","v":0}]
[null,"Limited winter use",null,"km",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F61),0,INDEX(IF(UPPER(RIGHT(F61,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F61,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F61,LEN(F61)-1)),CostCode,0)))","v":0},{"$f":"G61*E61","v":0}]
[null,"Winter road tarriff",null,"tonnekm",null,"wrul",{"$f":"IF(ISNA(F62),0,INDEX(IF(UPPER(RIGHT(F62,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F62,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F62,LEN(F62)-1)),CostCode,0)))","v":0.28999999999999998},{"$f":"G62*E62","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H62)+0.0001","v":5041005.0000999998}]

{"sheet":"Open Pit","index":10,"n_rows":64,"n_cols":11,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[1,"Open Pit Name: ",null,null,null,null,"Pit #",1]
[]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost","% Land","Land Cost","Water Cost"]
[null,"CONTROL ACCESS"]
[null,"Fence",null,"m",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F5),0,INDEX(IF(UPPER(RIGHT(F5,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F5,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F5,LEN(F5)-1)),CostCode,0)))","v":0},{"$f":"G5*E5","v":0},null,{"$f":"H5*I5","v":0},{"$f":"H5*(1-I5)","v":0}]
[null,"Signs",null,"each",null,"SH",37.08,{"$f":"G6*E6","v":0},null,{"$f":"H6*I6","v":0},{"$f":"H6*(1-I6)","v":0}]
[null,"Berm at crest",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G7*E7","v":0},null,0,0]
[null,"Block roads",null,"m3",null,"RB1H",17.05,{"$f":"G8*E8","v":0},null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F9),0,INDEX(IF(UPPER(RIGHT(F9,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F9,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F9,LEN(F9)-1)),CostCode,0)))","v":0},{"$f":"G9*E9","v":0},null,{"$f":"H9*I9","v":0},{"$f":"H9*(1-I9)","v":0}]
[null,"STABILITY STUDY"]
[null,"Conduct stability and setback study",null,"allow",null,"EA",20000,{"$f":"G11*E11","v":0},null,{"$f":"H11*I11","v":0},{"$f":"H11*(1-I11)","v":0}]
[null,"STABILIZE SLOPES"]
[null,"Off-load crest, soil A",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G13*E13","v":0},null,0,0]
[null,"Off-load crest, soil B",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Doze/trim overburden at crest",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Drill & blast pit crest",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Buttress slope",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"COVER/CONTOUR SLOPES"]
[null,"Place fill, soil A",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G20*E20","v":0},null,0,0]
[null,"Place fill, soil B",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Rip rap",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Vegetate slopes",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Vegetate pit floor",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"CONSTRUCT DIVERSION DITCHES"]
[null,"Excavate ditches -soil","covered under Surface Water Mgmt","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F27),0,INDEX(IF(UPPER(RIGHT(F27,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F27,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F27,LEN(F27)-1)),CostCode,0)))","v":0},{"$f":"G27*E27","v":0},null,{"$f":"H27*I27","v":0},{"$f":"H27*(1-I27)","v":0}]
[null,"Excavate ditches -rock",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F28),0,INDEX(IF(UPPER(RIGHT(F28,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F28,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F28,LEN(F28)-1)),CostCode,0)))","v":0},{"$f":"G28*E28","v":0},null,0,0]
[null,"Rip rap in channel base",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F29),0,INDEX(IF(UPPER(RIGHT(F29,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F29,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F29,LEN(F29)-1)),CostCode,0)))","v":0},{"$f":"G29*E29","v":0},null,0,0]
[null,"CONSTRUCT SPILLWAY"]
[null,"Excavate channel",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G31*E31","v":0},null,0,0]
[null,"Concrete",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G32*E32","v":0},null,0,0]
[null,"Rip rap",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G33*E33","v":0},null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G34*E34","v":0},null,0,0]
[null,"RECLAIM QUARRIES"]
[null,"Contour slopes",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F36),0,INDEX(IF(UPPER(RIGHT(F36,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F36,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F36,LEN(F36)-1)),CostCode,0)))","v":0},{"$f":"G36*E36","v":0},null,{"$f":"H36*I36","v":0},{"$f":"H36*(1-I36)","v":0}]
[null,"Place overburden",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F37),0,INDEX(IF(UPPER(RIGHT(F37,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F37,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F37,LEN(F37)-1)),CostCode,0)))","v":0},{"$f":"G37*E37","v":0},null,{"$f":"H37*I37","v":0},{"$f":"H37*(1-I37)","v":0}]
[null,"Vegetate",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F38),0,INDEX(IF(UPPER(RIGHT(F38,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F38,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F38,LEN(F38)-1)),CostCode,0)))","v":0},{"$f":"G38*E38","v":0},null,{"$f":"H38*I38","v":0},{"$f":"H38*(1-I38)","v":0}]
[null,"FLOOD PIT-Captital"]
[null,"Remove stationary equipment (sump pumps)",null,"Allow",null,null,10000,{"$f":"G40*E40","v":0},null,0,0]
[null,"Remove dewatering pipeline",null,"m",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F41),0,INDEX(IF(UPPER(RIGHT(F41,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F41,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F41,LEN(F41)-1)),CostCode,0)))","v":0},{"$f":"G41*E41","v":0},null,{"$f":"H41*I41","v":0},{"$f":"H41*(1-I41)","v":0}]
[null,"Remove power lines",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Construct diversion ditches",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F43),0,INDEX(IF(UPPER(RIGHT(F43,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F43,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F43,LEN(F43)-1)),CostCode,0)))","v":0},{"$f":"G43*E43","v":0},null,{"$f":"H43*I43","v":0},{"$f":"H43*(1-I43)","v":0}]
[null,"    -Ditch, mat'l A",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G44*E44","v":0},null,0,{"$f":"+H44*(1-I44)","v":0}]
[null,"    -Ditch, mat'l B",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G45*E45","v":0},null,0,0]
[null,"Construct embankment/dam",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Supply/install pump station",null,"Allow",null,null,500000,0,null,0,0]
[null,"Supply/install piping system",null,"m",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F48),0,INDEX(IF(UPPER(RIGHT(F48,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F48,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F48,LEN(F48)-1)),CostCode,0)))","v":0},{"$f":"G48*E48","v":0},null,{"$f":"H48*I48","v":0},{"$f":"H48*(1-I48)","v":0}]
[null,"Remove pump post-closure",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F49),0,INDEX(IF(UPPER(RIGHT(F49,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F49,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F49,LEN(F49)-1)),CostCode,0)))","v":0},{"$f":"G49*E49","v":0},null,{"$f":"H49*I49","v":0},{"$f":"H49*(1-I49)","v":0}]
[null,"Remove pipeline post-closure",null,"m",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F50),0,INDEX(IF(UPPER(RIGHT(F50,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F50,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F50,LEN(F50)-1)),CostCode,0)))","v":0},{"$f":"G50*E50","v":0},null,{"$f":"H50*I50","v":0},{"$f":"H50*(1-I50)","v":0}]
[null,"FLOOD PIT-Annual Cost"]
[null,"Operate pumps (power)",null,"each",null,null,439359.8,0,null,0,0]
[null,"Maintain pump/pipeline",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F53),0,INDEX(IF(UPPER(RIGHT(F53,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F53,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F53,LEN(F53)-1)),CostCode,0)))","v":0},{"$f":"G53*E53","v":0},null,{"$f":"H53*I53","v":0},{"$f":"H53*(1-I53)","v":0}]
[null,"Labour:fuel management, comissioning/decom",null,"$/h",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F54),0,INDEX(IF(UPPER(RIGHT(F54,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F54,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F54,LEN(F54)-1)),CostCode,0)))","v":0},{"$f":"G54*E54","v":0},null,{"$f":"H54*I54","v":0},{"$f":"H54*(1-I54)","v":0}]
[null,"Chemical addition,  _____ kg/m3 of water",null,"tonne",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Chemicals, purchase and shipping",null,"tonne",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Passive/biological additives",null,"$/ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F57),0,INDEX(IF(UPPER(RIGHT(F57,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F57,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F57,LEN(F57)-1)),CostCode,0)))","v":0},{"$f":"G57*E57","v":0},null,{"$f":"H57*I57","v":0},{"$f":"H57*(1-I57)","v":0}]
[null,"Passive additives purchase and shipping",null,"tonne",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F58),0,INDEX(IF(UPPER(RIGHT(F58,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F58,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F58,LEN(F58)-1)),CostCode,0)))","v":0},{"$f":"G58*E58","v":0},null,{"$f":"H58*I58","v":0},{"$f":"H58*(1-I58)","v":0}]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H59*I59","v":0},0]
[null,null,null,null,null,null,"Annual pumping costs",{"$f":"SUM(H52:H59)+0.0001","v":1E-4}]
[null,"Number of years of pump flooding",null,"years",0]
[null,null,null,null,null,null,"Total pumping costs",{"$f":"H60*E61","v":0},null,{"$f":"H62*I62","v":0},{"$f":"H62*(1-I62)","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H50)+H62+0.0001","v":1E-4},null,{"$f":"SUM(J5:J50)+J62","v":0},{"$f":"SUM(K5:K50)+K62","v":0}]
[null,null,null,null,null,null,"% of Total",null,null,{"$f":"J63/H63","v":0},{"$f":"K63/H63","v":0}]

{"sheet":"Water Management","index":11,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[[33,1,34,1]]}
[1,"Capital Expenditures and Short Term Water Treatment identified in 'Instructions' worksheet"]
[]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost"]
[null,"BREACH DYKE EMBANKMENT"]
[null,"breach contact ponds","TMA contact water BM-032","m3",{"$f":"180+1944","v":2124},"TMAC",3.26,{"$f":"G5*E5","v":6924.24}]
[null,"breach contact ponds","Berm 1 and 2 and Overburden pile","m3",{"$f":"3*648","v":1944},"TMAC",1.23,{"$f":"G6*E6","v":2391.12}]
[null,"Remove Liner ","all ponds (BM-021, BM-025, BM-027 and BM-032","m2",{"$f":"270+90+67+67","v":494},"TMAC",0.47,{"$f":"G7*E7","v":232.17999999999998}]
[null,"de-icing containment","BM-030 excavate containment sump","m3",17,"TMAC",16.350000000000001,{"$f":"G8*E8","v":277.95000000000005}]
[null,"Contour water intake area",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F9),0,INDEX(IF(UPPER(RIGHT(F9,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F9,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F9,LEN(F9)-1)),CostCode,0)))","v":0},{"$f":"G9*E9","v":0}]
[null,"STABILIZE SEDIMENT PONDS/WATER MANAGEMENT PONDS"]
[null,"Place soil cover",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F11),0,INDEX(IF(UPPER(RIGHT(F11,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F11,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F11,LEN(F11)-1)),CostCode,0)))","v":0},{"$f":"G11*E11","v":0}]
[null,"Doze & spread excavated material",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F12),0,INDEX(IF(UPPER(RIGHT(F12,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F12,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F12,LEN(F12)-1)),CostCode,0)))","v":0},{"$f":"G12*E12","v":0}]
[null,"Vegetate spread material",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F13),0,INDEX(IF(UPPER(RIGHT(F13,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F13,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F13,LEN(F13)-1)),CostCode,0)))","v":0},{"$f":"G13*E13","v":0}]
[null,"Rip rap in channel base",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F14),0,INDEX(IF(UPPER(RIGHT(F14,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F14,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F14,LEN(F14)-1)),CostCode,0)))","v":0},{"$f":"G14*E14","v":0}]
[null,"Remove sediment from WRSF Pond",null,"allow",null,"AE",10000,{"$f":"G15*E15","v":0}]
[null,"REDIRECT RUNOFF/CONSTRUCT DIVERSION DITCHES"]
[null,"Excavate ditches -soil",null,"m3",null,"sc3l",{"$f":"IF(ISNA(F17),0,INDEX(IF(UPPER(RIGHT(F17,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F17,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F17,LEN(F17)-1)),CostCode,0)))","v":8.9},{"$f":"G17*E17","v":0}]
[null,"Excavate ditches -rock",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F18),0,INDEX(IF(UPPER(RIGHT(F18,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F18,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F18,LEN(F18)-1)),CostCode,0)))","v":0},{"$f":"G18*E18","v":0}]
[null,"Stabilize side slopes",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F19),0,INDEX(IF(UPPER(RIGHT(F19,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F19,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F19,LEN(F19)-1)),CostCode,0)))","v":0},{"$f":"G19*E19","v":0}]
[null,"Rip rap in channel base",null,"m3",null,"rr2l",{"$f":"IF(ISNA(F20),0,INDEX(IF(UPPER(RIGHT(F20,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F20,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F20,LEN(F20)-1)),CostCode,0)))","v":14.2},{"$f":"G20*E20","v":0}]
[null,"BREACH DITCHES"]
[null,"Excavate breaches",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F22),0,INDEX(IF(UPPER(RIGHT(F22,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F22,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F22,LEN(F22)-1)),CostCode,0)))","v":0},{"$f":"G22*E22","v":0}]
[null,"Backfill/recontour",null,"m3",null,"SB3l",{"$f":"IF(ISNA(F23),0,INDEX(IF(UPPER(RIGHT(F23,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F23,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F23,LEN(F23)-1)),CostCode,0)))","v":5.0999999999999996},{"$f":"G23*E23","v":0}]
[null,"Install flow dissipation",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F24),0,INDEX(IF(UPPER(RIGHT(F24,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F24,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F24,LEN(F24)-1)),CostCode,0)))","v":0},{"$f":"G24*E24","v":0}]
[null,"Vegetate remainder of ditch",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F25),0,INDEX(IF(UPPER(RIGHT(F25,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F25,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F25,LEN(F25)-1)),CostCode,0)))","v":0},{"$f":"G25*E25","v":0}]
[null,"DECOMISSION FRESH WATER SUPPLY and OTHER EQUIPMENT"]
[null,"Breach embankment",null,"m",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F27),0,INDEX(IF(UPPER(RIGHT(F27,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F27,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F27,LEN(F27)-1)),CostCode,0)))","v":0},{"$f":"G27*E27","v":0}]
[null,"Remove pumps","De-icing sump and contact water area pumps","LS",{"$f":"1+4+4+4+6","v":19},"TMAC",679.52,{"$f":"G28*E28","v":12910.88}]
[null,"Remove pipeline",null,"LS",null,"AE",40000,{"$f":"G29*E29","v":0}]
[null,"WATER CONTROL IN RECLAMATION QUARRY"]
[null,"Install  pumping system",null,"LS",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F31),0,INDEX(IF(UPPER(RIGHT(F31,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F31,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F31,LEN(F31)-1)),CostCode,0)))","v":0},{"$f":"G31*E31","v":0}]
[null,"Remove pumping system",null,"LS",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F32),0,INDEX(IF(UPPER(RIGHT(F32,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F32,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F32,LEN(F32)-1)),CostCode,0)))","v":0},{"$f":"G32*E32","v":0}]
[null,"REMOVE PIPELINES"]
[null,"Remove pipes","Water discharge line decommission","m",2000,"TMAC",11.08,{"$f":"G34*E34","v":22160}]
[null,null,"Water discharge line load and haul to landfill","m3",98,"TMAC",{"$f":"10.23+3.26","v":13.49},{"$f":"G35*E35","v":1322.02}]
[null,"Decomission STP Pipe",null,"m",50,"TMAC",11.08,{"$f":"G36*E36","v":554}]
[null,"Concrete plug deep pipes",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F37),0,INDEX(IF(UPPER(RIGHT(F37,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F37,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F37,LEN(F37)-1)),CostCode,0)))","v":0},{"$f":"G37*E37","v":0}]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F38),0,INDEX(IF(UPPER(RIGHT(F38,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F38,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F38,LEN(F38)-1)),CostCode,0)))","v":0},{"$f":"G38*E38","v":0}]
[null,"GROUNDWATER COLLECTION SYSTEM"]
[null,"Excavate/install sumps",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F40),0,INDEX(IF(UPPER(RIGHT(F40,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F40,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F40,LEN(F40)-1)),CostCode,0)))","v":0},{"$f":"G40*E40","v":0}]
[null,"Install pumping wells",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F41),0,INDEX(IF(UPPER(RIGHT(F41,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F41,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F41,LEN(F41)-1)),CostCode,0)))","v":0},{"$f":"G41*E41","v":0}]
[null,"Install pumps/pipelines/power supply",null,"LS",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F42),0,INDEX(IF(UPPER(RIGHT(F42,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F42,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F42,LEN(F42)-1)),CostCode,0)))","v":0},{"$f":"G42*E42","v":0}]
[null,"CONSTRUCT CONTAMINATED WATER STORAGE POND"]
[null,"Excavate pond",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F44),0,INDEX(IF(UPPER(RIGHT(F44,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F44,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F44,LEN(F44)-1)),CostCode,0)))","v":0},{"$f":"G44*E44","v":0}]
[null,"Doze & spread excavated material",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Vegetate spread material",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Bedding layer",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Supply geomembrane",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Install geomembrane",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Erosion protection layer",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"CONSTRUCT PASSIVE TREATMENT SYSTEM (e.g. Constructed Wetland)"]
[null,"Construct access roads",null,"km",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G52*E52","v":0}]
[null,"Install HDPE piping system from collection pond",null,"m",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G53*E53","v":0}]
[null,"Inter-cell flow structures",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Install liners",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G55*E55","v":0}]
[null,"Install growth media",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Wetland vegetation",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"CONSTRUCT WATER TREATMENT PLANT"]
[null,"Build treatment plant ",null,"LS",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F59),0,INDEX(IF(UPPER(RIGHT(F59,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F59,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F59,LEN(F59)-1)),CostCode,0)))","v":0},{"$f":"G59*E59","v":0}]
[null,"Build sludge containment facility",null,"LS",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F60),0,INDEX(IF(UPPER(RIGHT(F60,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F60,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F60,LEN(F60)-1)),CostCode,0)))","v":0},{"$f":"G60*E60","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H60)+0.0001","v":46772.390099999997}]
[null," For cost of long-term/post-closure water treatment see \"WATER TREATMENT\" Worksheet\""]

{"sheet":"Water Treatment","index":12,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[1,"Post Closure Water Treatment - Identified as long term/post-closure in 'Instructions' worksheet"]
[]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost"]
[null,"ADDITION OF REAGENTS TO WTP"]
[null,"H2O2",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F5),0,INDEX(IF(UPPER(RIGHT(F5,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F5,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F5,LEN(F5)-1)),CostCode,0)))","v":0},{"$f":"G5*E5","v":0}]
[null,"lime",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"ferric sulphate",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"ferrous sulphate",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"flocculents",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"LABOUR AND SUPPLIES"]
[null,"Annual fuel",null,"litres",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F12),0,INDEX(IF(UPPER(RIGHT(F12,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F12,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F12,LEN(F12)-1)),CostCode,0)))","v":0},{"$f":"G12*E12","v":0}]
[null,"Annual power",null,"kW-h",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F13),0,INDEX(IF(UPPER(RIGHT(F13,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F13,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F13,LEN(F13)-1)),CostCode,0)))","v":0},{"$f":"G13*E13","v":0}]
[null,"Electrician/mechanic to maintain treatment plant",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Equipment maintenance and parts",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Misc. supplies, hoses, tools",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Communications",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"WATER MANAGEMENT"]
[null,"Water Treatment (reagents, equip Op. labour)",null,"m3",null,"AE",0.62,{"$f":"G20*E20","v":0}]
[null,"Water pumping from sumps and ponds to treatment plant",null,"allow",null,"AE",29367.83,{"$f":"G21*E21","v":0}]
[null,"Annual Treatment Plant Servicing",null,"manhours",null,"lab-ss",{"$f":"IF(ISNA(F22),0,INDEX(IF(UPPER(RIGHT(F22,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F22,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F22,LEN(F22)-1)),CostCode,0)))","v":120},{"$f":"G22*E22","v":0}]
[null,"Treatment Plant Servicing Travel Allowance",null,"visit",null,"AE",4000,{"$f":"G23*E23","v":0}]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F24),0,INDEX(IF(UPPER(RIGHT(F24,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F24,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F24,LEN(F24)-1)),CostCode,0)))","v":0},{"$f":"G24*E24","v":0}]
[null,"WTP WATER SAMPLING AND ANALYSES"]
[null,"Sampling equipment",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F26),0,INDEX(IF(UPPER(RIGHT(F26,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F26,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F26,LEN(F26)-1)),CostCode,0)))","v":0},{"$f":"G26*E26","v":0}]
[null,"Analyses",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F27),0,INDEX(IF(UPPER(RIGHT(F27,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F27,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F27,LEN(F27)-1)),CostCode,0)))","v":0},{"$f":"G27*E27","v":0}]
[null,"Shipping to laboratory",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F28),0,INDEX(IF(UPPER(RIGHT(F28,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F28,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F28,LEN(F28)-1)),CostCode,0)))","v":0},{"$f":"G28*E28","v":0}]
[null,"Reporting",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F29),0,INDEX(IF(UPPER(RIGHT(F29,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F29,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F29,LEN(F29)-1)),CostCode,0)))","v":0},{"$f":"G29*E29","v":0}]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F30),0,INDEX(IF(UPPER(RIGHT(F30,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F30,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F30,LEN(F30)-1)),CostCode,0)))","v":0},{"$f":"G30*E30","v":0}]
[null,"SITE ACCESS"]
[null,"Road maintenance (incl. snow removal)",null,"allow",null,"AE",50000,{"$f":"G32*E32","v":0}]
[null,"Winter road tariff",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F33),0,INDEX(IF(UPPER(RIGHT(F33,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F33,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F33,LEN(F33)-1)),CostCode,0)))","v":0},{"$f":"G33*E33","v":0}]
[null,"Truck rental",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F34),0,INDEX(IF(UPPER(RIGHT(F34,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F34,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F34,LEN(F34)-1)),CostCode,0)))","v":0},{"$f":"G34*E34","v":0}]
[null,"Air support",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F35),0,INDEX(IF(UPPER(RIGHT(F35,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F35,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F35,LEN(F35)-1)),CostCode,0)))","v":0},{"$f":"G35*E35","v":0}]
[]
[null,null,null,null,null,null,"Annual water treatment costs",{"$f":"SUM(H5:H36)+0.0001","v":1E-4}]
[null,"Number of years of water treatment",null,"years",25]
[null,null,null,null,null,null,"Total",{"$f":"AnnualTreat1Cost*E38","v":2.5000000000000001E-3}]

{"sheet":"Unit_Costs","index":13,"n_rows":172,"n_cols":12,"rows_kept":172,"cut":false,"hidden":false,"merged":[]}
["Unit Cost Table (for refining unit costs see \"Estimator\" worksheet)"]
[null,null,null,"Filter by unit",null,"",""]
[null,null,null,null,null,"","",""]
["ITEM","Detail",null,"COST CODE","UNITS","LOW $","HIGH $","SPECIFIED $",null,"COMMENTS"]
[null,null,null,null,null,"","",""]
["Accomodation"]
[null,null,null,"ACCM","manday",100,175]
["Buildings - Decontaminate",null,null,null,null,"","",""]
[null,"Asbestos",null,"BDA","m2",25.6,51.2,null,null,"Low: removal of asbestos siding & flooring; High: removal of insulated pipes, friable asbestos"]
["Buildings - Remove",null,null,null,null,"","","",null,"Unit costs are based on 3m high, single storey building.  Scale areas accordingly."]
[null,"Wood",null,"BRW","m2",27.5,41]
[null,"Concrete",null,"BRC","m2",40,65,6,null,"Specified: puncture concrete foundation slabs"]
[null,"Steel - teardown",null,"BRS1","m2",45,65]
[null,"Steel - for salvage",null,"BRS2","m2",67,100]
["Concrete work",null,null,null,null,"","",""]
[null,"Small pour",null,"CSF","m3",426.5,639.75,null,null,"Low: YK; High=1.5xLow"]
[null,"Large pour",null,"CLF","m3",353.5,530.25,2130,null,"Specified: concrete crown pillar"]
["Contaminated Soils",null,null,null,null,"","",""]
[null,"ESA Phase 1",null,"CS1","each",7500,null,null,null,"Low: small, \"clean\" site"]
[null,"ESA Phase 1",null,"CS2","each",50000,null,null,null,"Low: small, \"clean\" site"]
[null,"Remediate on site",null,"CSR","m3",47,146]
["Dozing",null,null,null,null,"","",""]
[null,"doze rock piles",null,"DR","m3",1.05,2.4,null,null,"Low cost: doze crest off dump"]
[null,"doze overburden/soil piles",null,"DS","m3",0.95,3.8,null,null,"High cost: push up to 300 m"]
["Excavate Rock; Low Spec's and QA/QC",null,null,null,null,"","",""]
[null,"drill/blast/load/short haul",null,"RB1","m3",11.4,17.05,null,null,"Low:quarry operations for bulk fill"]
[null,"drill/blast/load/long haul",null,"RB2","m3",12.05,17.8]
[null,"RB1 + spread and compact",null,"RB3","m3",12.05,17.8]
[null,"RB2 + spread and compact",null,"RB4","m3",12.5,30.75]
[null,"Specified activity",null,"RBS","m3"]
["Excavate Rock; High Spec's and QA/QC ",null,null,null,null,"","","",null,"(e.g. ditch/spillway excavation)"]
[null,"drill/blast/load/short haul",null,"RC1","m3",12.05,17.8,null,null,"Low:foundation excavation;High:spillway excavation"]
[null,"drill/blast/load/long haul",null,"RC2","m3",12.7,18.399999999999999]
[null,"RC1 + spread and compact",null,"RC3","m3",12.7,18.399999999999999,null,null,"e,g, cover construction"]
[null,"RC2 + spread and compact",null,"RC4","m3",13.5,19.2,null,null,"e,g, cover construction"]
[null,"Specified activity",null,"RCS","m3",null,null,175,null,"Specified-drift excavation"]
["Excavate Rip Rap",null,null,null,null,"","",""]
[null,"drill/blast/load/short haul/place",null,"RR1","m3",13.5,17.75,null,null,"High: quarry & place rip rap in channel"]
[null,"drill/blast/load/long haul/place",null,"RR2","m3",14.2,20.65]
[null,"source is waste dump/short haul",null,"RR3","m3",7,null,null,null,"cost includes sorting"]
[null,"source is waste dump/long haul",null,"RR4","m3",7.6]
[null,"Specified activity",null,"RRS","m3"]
["Excavate Soil; Low Spec's and QA/QC",null,null,null,null,"","",""]
[null,"clear & grub",null,"SBC","m2",3.4,5,""]
[null,"excavate/load/short haul",null,"SB1","m3",4.3,5.9]
[null,"excavate/load/long haul",null,"SB2","m3",4.5999999999999996,7.3]
[null,"SB1 + spread and compact",null,"SB3","m3",5.0999999999999996,8.9,null,null,"Low: non-engineered; High:engineered"]
[null,"SB2 + spread and compact",null,"SB4","m3",5.5,11,null,null,"Low: non-engineered; High:engineered"]
[null,"Specified activity",null,"SBS","m3",3.2,6.3,"",null,"Low: rehandle waste rock dump by dozing; High:rehandle waste rock by hauling"]
[null,"Tailings ",null,"SBT","m3",1.35,3.7,15.5,null,"High:contour surface - wet or frozen; Specified:haul/place wet infill"]
["Excavate Soil, High Spec's and QA/QC",null,null,null,null,"","",""]
[null,"excavate/load/short haul",null,"SC1","m3",6.8,9.3000000000000007]
[null,"excavate/load/long haul",null,"SC2","m3",7.1,11.75]
[null,"SC1 + spread and compact",null,"SC3","m3",8.9,14.2,null,null,"Low: non-engineered; High:engineered"]
[null,"SC2 + spread and compact",null,"SC4","m3",9.3000000000000007,23.2,null,null,"Low: non-engineered; High:engineered (e.g. complex covers, low volume dam construction)"]
[null,"Specified activity",null,"SCS","m3",null,null,18.8,null,"Backfill adit with waste rock"]
["Fence",null,null,null,null,"","",""]
[null,null,null,"FNC","m",13.55,203]
["Fuel and Electricity",null,null,null,null,"","",""]
[null,"Fuel cost - gas",null,"FCG","litre",1.05,1.4,null,null,null,null," "]
[null,"Fuel cost - diesel",null,"FCD","litre",0.99,1.39]
[null,"Fuel mobilization",null,"FCM","litre",0.22,0.42,null,null,"High: winter road usage"]
[null,"Electricity",null,"FCE","kW-h",0.17,0.19,0.49,null,"Low and High:Yellowknife; Specified:diesel generator"]
["Geo-Synthetics",null,null,null,null,"","",""]
[null,"geotextile",null,"GST","m2",3.44,null,null,null,"Supply and install"]
[null,"geogrid",null,"GSG","m2",5.75,""]
[null,"liner, HDPE",null,"GSHDPE","m2",7.95,"",null,null,"Supply and install; large quantity"]
[null,"liner, ES3",null,"GSES3","m2",20.2,"","",null,"FOB Yellowknife"]
[null,"geosynthetic installation",null,"GSI","m2",3.16,14,null,null,"Low:geotextile; High:ES3 or HDPE"]
[null,"bentonite soil ammendment",null,"GSBA","tonne",308.3,348.5,null,null,"FOB Edmonton, add shipping & mixing"]
["Grouting (/m3 of rock grouted)",null,null,null,null,"","",""]
[null,null,null,"grout","m3",236.55,286.75,null,null,"High: cement, FOB Yellowknife"]
["Labour & Equipment Rates",null,null,null,null,"","",""]
[null,"Site manager",null,"sman","$/hr",125,152]
[null,"Supervisor",null,"super","$/hr",52,91.84]
[null,"Registered engineer",null,"eng","$/hr",95,220]
[null,"Environmental coordinator",null,"envco","$/hr",74.16,130]
[null,"Evironmental technologist",null,"envtech","$/hr",36]
[null,"Electrician",null,"elec","$/hr",74,95]
[null,"Journeyman - various",null,"journey","$/hr",44,71.790000000000006]
[null,"Labour - skilled ",null,"lab-s","$/hr",41,49.6,120]
[null,"Labour - unskilled",null,"lab-us","$/hr",31,43.98]
[null,"Equipment operator",null,"oper","$/hr",41,65]
[null,"Heavy duty mechanic",null,"mech","$/hr",49,72.849999999999994]
[null,"Water treatment plant operator",null,"oper-wt","$/hr",41,59.86]
[null,"Security / first aid",null,"safety","$/hr",36,66.97]
[null,"Administative staff",null,"admin","$/hr",38,57.89]
[]
[null,"Equipment rates include operator and fuel"]
[null,"Loader - 4 cu.yd (3.06m3)",null,"load-s","$/hr",175,null,""]
[null,"Loader - 7 cu.yd (5.35m3)",null,"load-l","$/hr",315]
[null,"Excavator - 26.76-30.84 tonnes",null,"exc-s","$/hr",190]
[null,"Excavator - 68.95+tonnes",null,"exc-l","$/hr",420,null,""]
[null,"Grader",null,"grad","$/hr",190]
[null,"Dump truck off hwy 30-50 tonnes",null,"truck-s","$/hr",225,null,""]
[null,"Dump truck off hwy 55-75 tonnes",null,"truck-l","$/hr",300]
[null,"dozer, small",null,"dozers","$/hr",205,260,""]
[null,"dozer, large",null,"dozerl","$/hr",490,565,""]
[null,"smooth drum compactor",null,"comp","$/hr",155,null,""]
[null,"scooptram, 6 yd3 bucket",null,"scoop","$/hr",170,null,""]
[null,"flat bed truck with hiab",null,"hiab","$/hr",155,null,""]
[null,"fuel truck",null,"ftruck","$/hr",150]
[null,"water truck",null,"wtruck","$/hr",58,150]
["Mobilize Heavy Equipment",null,null,null,null,"","",""]
[null,"Road access",null,"MHER","kmtonne",3.4,10.25]
[null,"Air access",null,"MHEA","kmtonne",12,null,null,null,"cargo rate>500lb"]
["Mobilize Camp",null,null,null,null,"","",""]
[null,"Road access",null,"MCR","each",50000,null,null,null,"refurbish existing camp"]
["Mobilize Workers",null,null,null,null,"","",""]
[null,"flight",null,"MW","each",4500,9100,null,null,"Low:e.g. 8 passenger; High: Dash 7"]
["Oil Removal",null,null,null,null,"","",""]
[null,"oil removal",null,"OR","litre",0.43,1.2,null,null,"Low:waste oil heater; High: ship offsite"]
["PCB Removal"]
[null,"Remove from site",null,"PCBR","litre",40.200000000000003,46.9,null,null,"Low: shipping, handling & disposal from Yellowknife"]
["Pipes, small (<6in dia.)",null,null,null,null,"","",""]
[null,"remove/dispose on site",null,"PSR","m",1,24,null,null,"Low: remove/dispose on site; High: remove/re-use"]
[null,"supply",null,"PSS","m",6.1,11.1,null,null,"Low:supply; High:supply and ship"]
[null,"install",null,"PSI","m",25]
["Pipes, large (>6in dia.)",null,null,null,null,"","",""]
[null,"remove/dispose on site",null,"PLR","m",22,72,null,null,"Low: remove/dispose on site; High: remove/re-use"]
[null,"supply",null,"PLS","m",129,143,null,null,"Low:supply; High:supply and ship"]
[null,"install",null,"PLI","m",50]
["Power Lines",null,null,null,null,"","",""]
[null,"remove/dispose on site",null,"POWR","m",25.5]
["Process Chemicals",null,null,null,null,"","",""]
[null,"Remove from site",null,"PCR","kg",0.45,2.5,null,null,"Low: shipping, handling & disposal from Yellowknife"]
["Pumps",null,null,null,null,"","",""]
[null,"Pump capital cost",null,"PC","each",195000]
[null,"Pump shipping",null,"PS","each",2500]
[null,"Pump operating cost",null,"POC","m3",0.12,null,null,null,"pump operating costs should be calculated based on pump capacity, fuel costs, etc."]
[null,"Pump maintenance",null,"PM","allow",25000]
["Pump sand BackFill",null,null,null,null,"","",""]
[null,null,null,"PBF","m3",85,300]
["Scarify - road/mine site"]
[null,null,null,"SCFY","ha",4300,6030,2150]
["Shaft, Raise & Portal Closures",null,null,null,null,"","",""]
[null,"Shaft & Raises",null,"SR","m2",645,2132,null,null,"Low:pre-cast concrete slabs, little site prep. Area=shaft+>1m all around"]
[null,"Portals",null,"POR","m3",18.8,250,1200,null,"Low:unit cost code SCS;High:excavate & backfill collapsed portal;Spec: installed pressure plug"]
["Site Inspection Report"]
[null,null,null,"RPT","each",10000,20000]
["SpillWay - Clear"]
[null,null,null,"SW","each",3000,7000]
["Survey/Instrumentation"]
[null,null,null,"SI","each",1800,3600,null,null,"2 person crew"]
["Treatment Plant - Construct",null,null,null,null,"","",""]
[null,"Small (< 1000 m3/d)",null,"TPS","lump sum",9000000,15000000]
[null,"Large (> 1000 m3/d)",null,"TPL","lump sum",15000000,46000000]
[null,"Constructed Wetland",null,"CWTS","ha",200000,300000]
["Treatment Plant - Operate"]
[null,null,null,"TPO","m3",0.35,2]
["Treatment Chemicals",null,null,null,null,"","",""]
[null,"ferric sulphate",null,"ferric","kg",1.19,"",""]
[null,"ferrous sulphate",null,"ferrous","kg",1.32,"",""]
[null,"lime",null,"lime","kg",0.56000000000000005,null,""]
[null,"hydrogen peroxide, 35%",null,"hperox","kg",1.5,"",""]
[null,"Sodium Metabisulfate",null,"Nametab","kg",1.18,"",""]
[null,"Caustic soda, 50%",null,"caustic","kg",0.74,"",""]
[null,"Sulfuric acid, 93%",null,"sulfuric","kg",0.31,"",""]
[null,"flocculant",null,"flocc","kg",6,"",""]
[null,"copper sulphate",null,"copper","kg","","",""]
[null,"shipping",null,"shipping","kg",0.2,"",""]
["Vegetation",null,null,null,null,"","",""]
[null,"Hydroseed, Flat",null,"VHF","ha",4000]
[null,"Hydroseed, Sloped",null,"VHS","ha",4500]
[null,"Veg. blanket/erosion mat",null,"VB","ha",13000]
[null,"Tree planting",null,"VT","ha",2600,6000]
[null,"Wetland species",null,"VW","ha",null,null,47.72,null,"Specified= /m3, Wetland Growth Media Substrate mixed and installed (sand, biochar and fertilizer, woodchips)"]
["Water Sampling/Analysis/Reporting"]
[null,null,null,"WS","each",7000,10000]
["Winter Road"]
[null,"Construction",null,"WRC","km",2000,11500]
[null,"Usage",null,"WRU","kmtonne",0.28999999999999998]

{"sheet":"Estimator","index":14,"n_rows":55,"n_cols":15,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[null,"Unit Cost Estimator",null,1,"Equipment Productivity Figures and Graphs have been reproduced from Caterpillar Performance Handbook - Edition 42 "]
[null,"EXCAVATION",null,null,null,null,"HAUL AND DUMPING",null,null,null,null,"SPREADING/DOZING"]
[null,"Productivity",null,null,null,null,"Productivity",null,null,null,null,"Productivity"]
[null,"Machine","Cat 336EL",null,null,null,"Machine","Cat 770",null,null,null,"Machine","Cat D8"]
[null,"bucket capacity",null,3.16,"m3",null,"truck capacity",null,25.1,"m3",null,"Estimate production using example curves provided or ",null,600,"m3/hr"]
[null,"fill factor",null,0.75,"%",null,"fill factor",null,0.8,"%",null,"equivalent from other supplier"]
[null,"cycle time",null,45,"seconds",null,null,null,null,null,null,"Correction factors (see table provided)"]
[null,"operator skill",null,0.8,"%",null,"load time",null,6,"min.",null,"      operator skill",null,0.75]
[null,"machine availability",null,0.83,"%",null,"haul distance",null,1.5,"km",null,"      material type, see table",null,0.8]
[null,"altitude adjustment",null,1,"%",null,"average velocity",null,20,"km/hr",null,"      slot dozing",null,1]
[null,"Hourly productivity",null,{"$f":"D5*D6*(60*60/D7)*D8*D9*D10","v":125.89440000000002},"m3/hr",null,"haul time + return time",null,{"$f":"+I9/I10*60*2","v":9},"min.",null,"     side by side dozing",null,1]
[null,null,null,null,null,null,"wait time",null,0.5,"min.",null,"     visibility",null,1]
[null,null,null,null,null,null,"dump time",null,1,"min.",null,"     job efficiency",null,0.83]
[null,null,null,null,null,null,"cycle time",null,{"$f":"I8+SUM(I11:I13)","v":16.5},"min.",null,"     altitude adjustment",null,1]
[null,null,null,null,null,null,"machine availability",null,0.83,"%",null,"     slope adjustment",null,1]
[null,null,null,null,null,null,"altitude adjustment",null,1,"%",null,"Hourly productivity",null,{"$f":"+N5*N8*N9*N10*N11*N12*N13*N14*N15","v":298.8},"m3/hr"]
[null,null,null,null,null,null,null,null,{"$f":"I14*I15*I16","v":13.694999999999999},"ave. min/cycle"]
[null,null,null,null,null,null,"Hourly productivity",null,{"$f":"I5*I6*60/I17","v":87.973713033954027},"m3/hr"]
[null,"Operating Costs",null,null,null,null,"Operating Costs",null,null,null,null,"Operating Costs"]
[null," - Contractor",null,null,null,null," - Contractor",null,null,null,null," - Contractor"]
[null,"Contractor  hourly rate",null,180,"$/hr",null,"Contractor  hourly rate",null,225,"$/hr",null,"Hourly rate - contractor supplied",null,260,"$/hr"]
[null,"Excavation cost - contractor rate",null,{"$f":"D21/D11","v":1.4297697117584258},"$/m3",null,"Haul and Dump - contractor rate",null,{"$f":"I21/I18","v":2.5575821713147402},"$/m3",null,"Dozing - contractor rate",null,{"$f":"N21/N16","v":0.8701472556894243},"$/m3"]
[]
[null," - Owner",null,null,null,null," - Owner",null,null,null,null," - Owner"]
[null,"ownership, daily",null,null,"$/day",null,"ownership, daily",null,null,"$/day",null,"ownership, daily",null,null,"$/day"]
[null,"maintenance",null,null,"$/hr",null,"maintenance",null,null,"$/hr",null,"maintenance",null,null,"$/hr"]
[null,"fuel",null,null,"$/hr",null,"fuel",null,null,"$/hr",null,"fuel",null,null,"$/hr"]
[null,"consumables (cutters, tires)",null,null,"$/hr",null,"consumables (cutters, tires)",null,null,"$/hr",null,"consumables (cutters, tires)",null,null,"$/hr"]
[null,"operator",null,null,"$/hr",null,"operator",null,null,"$/hr",null,"operator",null,null,"$/hr"]
[null,"Owner hourly rate",null,{"$f":"D25/10+SUM(D26:D29)","v":0},"$/hr",null,"Owner hourly rate",null,{"$f":"I25/10+SUM(I26:I29)","v":0},"$/hr",null,"Owner hourly rate",null,{"$f":"N25/10+SUM(N26:N29)","v":0}]
[null,"Excavation cost - owner rate",null,{"$f":"D30/D11","v":0},"$/m3",null,"Haul/Dumping Cost - owner rate",null,{"$f":"I30/I18","v":0},"$/m3",null,"Spreading/Dozing Cost - owner rate",null,{"$f":"N30/N16","v":0},"$/hr"]
[null,"Excavation cost - select contractor or owner rate (D22 or D31)",null,null,"$/m3",null,"Haul/Dumping Cost - select contractor or owner rate (I22 or I31",null,null,"$/m3",null,"Spreading/Dozing Cost - select contractor or owner rate (N22 or N31)",null,null,"$/m3"]
[]
[]
[]
[null,"Excavator",null,null,null,null,"Trucking",null,null,null,null,"Dozing"]
[null,null,"Cat 320","Cat 325B","Cat 375",null,null,"Cat 771 D","Cat 777D","Cat 789C"]
[null,"heaped bucket capacity, m3",1.5,2.2000000000000002,5.4,null,"Truck capacity - heaped, m3",27.5,60.5,137]
[null,null,null,"Typical Cycle Times (seconds)"]
[null,"easy digging, shallow digging, small swing angle",16,18,20]
[null,"med. to  hard digging, rocky soil, swing angle to 90 deg.",23,23,25]
[null,"tough digging, sandstone, caliche, at max.  machine depth, swing angle > 120 deg. ",27,29,35]
[]
[null,"Material","Fill Factor (% of heaped bucket capacity"]
[null,"Moist loam or sandy clay",null,"100 - 110"]
[null,"sand and gravel (not till)",null,"95 - 110"]
[null,"hard tough clay",null,"80 - 90"]
[null,"rock - will blasted",null,"60 - 75"]
[null,"rock - poorly blasted",null,"40 -60"]
[]
[null,"Operator Skill","poor","average","good"]
[null,"Correction factor",0.6,0.75,1]
[]
[null,"Machine availability","poor","average","good"]
[null,"Correction factor",0.9,0.95,1]

{"sheet":"Tools","index":15,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["The functions in this worksheet serve as a back up in the event that the menu item \"Add-Ins\" is not shown in Excel menu bar"]
[]
[]
[null,null,"Save file before clearing all data"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"These functions duplicate components within worksheet"]
[]
[]
[null,null,"Shows both active worksheet as well as table of Unit Costs in a separate window"]
[]
[]
[null,null,"Prints all worksheets having non-zero sums"]