{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Instructions","Summary","UG Mine","Tailings","Rock Pile","Chemicals","Bldgs & Equip","Water Management","Water Treatment","ICM","Mobilization","PostClosure","Open Pit","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 - Doris Madrid  ","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":30,"n_cols":8,"rows_kept":30,"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":"Doris -Madrid"},null,{"$f":"UG1Total","v":312867.6201},null,{"$f":"UG1LandTotal","v":306350.5},null,{"$f":"UG1WaterTotal","v":6517.12}]
["TAILINGS FACILITY",{"$f":"IF(ISBLANK(Tailings!$C$1),\"\",Tailings!$C$1)","v":"Doris-Madrid Mines"},null,{"$f":"Tailings1Total","v":18850157.950100005},null,{"$f":"Tailings1LandTotal","v":9548828.9750000015},null,{"$f":"Tailings1WaterTotal","v":9301328.9750000015}]
["ROCK PILE",{"$f":"IF(ISBLANK('Rock Pile'!$C$1),\"\",'Rock Pile'!$C$1)","v":"Doris - Madrid"},null,{"$f":"RP1Total","v":290125.5001},null,{"$f":"RP1LandTotal","v":145062.75},null,{"$f":"RP1WaterTotal","v":145062.75}]
["BUILDINGS AND EQUIPMENT",{"$f":"IF(ISBLANK('Bldgs & Equip'!$C$1),\"\",'Bldgs & Equip'!$C$1)","v":"Doris - Madrid "},null,{"$f":"Bldg1Total","v":13677653.157899993},null,{"$f":"Bldg1LandTotal","v":6760409.5325499959},null,{"$f":"Bldg1WaterTotal","v":6917243.6252499959}]
["CHEMICALS AND CONTAMINATED SOIL MANAGEMENT",{"$f":"IF(ISBLANK(Chemicals!$C$1),\"\",Chemicals!$C$1)","v":""},null,{"$f":"Chem1Total","v":3181811.1416999996},null,{"$f":"Chem1LandTotal","v":1513075.5707999999},null,{"$f":"Chem1WaterTotal","v":1668735.5707999999}]
["SURFACE AND GROUNDWATER MANAGEMENT",{"$f":"IF(ISBLANK('Water Treatment'!$C$1),\"\",'Water Treatment'!$C$1)","v":""},null,{"$f":"Water1Total","v":660058.54209999985},null,"-",null,{"$f":"Water1Total","v":660058.54209999985}]
["INTERIM CARE AND MAINTENANCE",{"$f":"IF(ISBLANK(ICM!$C$1),\"\",ICM!$C$1)","v":""},null,{"$f":"ICMTotal","v":7119300.0002999995},null,"-",null,{"$f":"ICMTotal","v":7119300.0002999995}]
[null,"SUBTOTAL: Capital Costs",null,{"$f":"SUM(D4:D11)","v":44091973.912399992},null,{"$f":"SUM(F4:F11)","v":18273727.328349996},null,{"$f":"SUM(H4:H11)","v":25818246.583449997}]
[null,"PERCENT OF SUBTOTAL ",null,null,null,{"$f":"IF(F12<0.01,0,F12/D12)","v":0.41444566225715906},null,{"$f":"IF(H12<0.01,0,H12/D12)","v":0.58555433772923304}]
[]
["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":9615305.7142857146},null,{"$f":"D16*$F$13","v":3985021.7445621886},null,{"$f":"D16*$H$13","v":5630283.9695926821}]
["POST-CLOSURE MONITORING AND MAINTENANCE",{"$f":"IF(ISBLANK(PostClosure!$C$1),\"\",PostClosure!$C$1)","v":""},null,{"$f":"PC1Total","v":4350876.5019999994},null,{"$f":"D17*$F$13","v":1803201.8932705014},null,{"$f":"D17*$H$13","v":2547674.608670292}]
["ENGINEERING ",0.05,null,{"$f":"B18*$D$12","v":2204598.6956199999},null,{"$f":"+$F$13*D18","v":913686.36641749984},null,{"$f":"+$H$13*D18","v":1290912.3291724999}]
["PROJECT MANAGEMENT",0.05,null,2204598.6956199999,null,913686.36641749984,null,1290912.3291724999]
["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,8818394.7824799996,null,3654745.4656699994,null,5163649.3166899998]
["MARKET PRICE FACTOR ADJUSTMENT",0,null,0,null,0,null,0]
[null,"SUBTOTAL: Indirect Costs",null,{"$f":"SUM(D16:D23)","v":27193774.390005715},null,{"$f":"SUM(F16:F23)","v":11270341.836337689},null,{"$f":"SUM(H16:H23)","v":15923432.553297972}]
[]
["TOTAL COSTS",null,null,{"$f":"D12+D24","v":71285748.302405715},null,{"$f":"F12+F24","v":29544069.164687686},null,{"$f":"H12+H24","v":41741679.136747971}]
[]
[]
[null,null,null,61174597]
[null,null,null,{"$f":"D26-D29","v":10111151.302405715}]

{"sheet":"UG Mine","index":2,"n_rows":49,"n_cols":13,"rows_kept":49,"cut":false,"hidden":false,"merged":[[22,1,25,1],[28,1,30,1]]}
[1,"Underground Mine Name","Doris -Madrid",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","Doris/Madrid South/Madrid North","each",6,"SH",37.08,222.48,1,{"$f":"H6*I6","v":222.48},{"$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 Doris","DM-012","m3",710,"TMAC",24.53,17416.3,1,17416.3,0,null,"rounded qty"]
[null,"Backfill Portal Madrid North","MN-012","m3",710,"TMAC",24.53,{"$f":"G11*E11","v":17416.3},1,{"$f":"H11*I11","v":17416.3},{"$f":"H11*(1-I11)","v":0},null,"rounded qty"]
[null,"Backfill Portal Madrid South","MS-016","m3",710,"TMAC",24.53,17416.3,1,17416.3,0,null,"rounded qty"]
[null,"Cap Vent Raises ","DM-030, DM-033 & DM-034","each",3,"TMAC",14300,42900,1,42900,0,null,"rounded unit rate up"]
[null,"Cap Vent Raises ","MN-018","each",3,"TMAC",14300,{"$f":"G14*E14","v":42900},1,{"$f":"H14*I14","v":42900},{"$f":"H14*(1-I14)","v":0},null,"rounded unit rate up"]
[null,"Cap Vent Raises ","MS-015","each",2,"TMAC",14300,28600,1,28600,0,null,"rounded unit rate up"]
[null,"Cap shaft #2",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Backfill adits",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H17*I17","v":0},{"$f":"H17*(1-I17)","v":0}]
[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":"G22*E22","v":0},null,{"$f":"H22*I22","v":0},{"$f":"H22*(1-I22)","v":0}]
[null,"Remove/decontam. stationary & elect. equip","DM-012, DM-030, DM-033 & DM-034","lm",{"$f":"100*4","v":400},"TMAC",119.02,{"$f":"G23*E23","v":47608},1,{"$f":"H23*I23","v":47608},{"$f":"H23*(1-I23)","v":0}]
[null,null,"Doris remove equipment from underground Mech Shop","each",3,"TMAC",680,{"$f":"G24*E24","v":2040},1,{"$f":"H24*I24","v":2040},{"$f":"H24*(1-I24)","v":0}]
[null,null,"MN-012 & MN-018","lm",{"$f":"100*4","v":400},"TMAC",119.02,{"$f":"G25*E25","v":47608},1,{"$f":"H25*I25","v":47608},{"$f":"H25*(1-I25)","v":0},null,"no quantity given in latest estimate so kept earlier number"]
[null,null,"MS-015 & MS-016","lm",300,"TMAC",119.02,35706,1,35706,0,null,"N/C"]
[null,"Remove/decontam. mobile equipment",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,"Remove misc. haz. mat & explosives","Remove explosives from AWR storage","m3",2176,"TMAC",5.99,{"$f":"G28*E28","v":13034.24},0.5,{"$f":"H28*I28","v":6517.12},{"$f":"H28*(1-I28)","v":6517.12},null,"changed rate to the waste haulage rate from RB to Quarry 3 to reflect minimal containerization required however need specialists to manage the explosives."]
[null,"Other","Cargo dock controller removal","each",0,"TMAC",679.52,{"$f":"G29*E29","v":0},0.5,{"$f":"H29*I29","v":0},{"$f":"H29*(1-I29)","v":0},null,"already accounted for in Chemicals tab."]
[null,null,"Relocate debris from Raise MN"]
[null,null,"Relocate debris from Raise MS"]
[null,"INSTALL BULKHEADS"]
[null,"Bulkheads to control water flow",null,"each",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,{"$f":"H33*I33","v":0},{"$f":"H33*(1-I33)","v":0}]
[null,"Grout bulkhead",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,"FLOOD MINE"]
[null,"Supply/install pump",null,"each",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,0,0]
[null,"Supply/install piping system",null,"each",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,"Operate pumps to flood workings",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,0,0]
[null,"Other",null,null,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,0,0]
[null,"INSTALL GROUNDWATER COLLECTION SYSTEM"]
[null,"Excavate/install sumps",null,"m2",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"}},{"$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,"Install pumps/pipelines/power supply",null,"LS",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,"SPECIALIZED ITEMS"]
[null,"Install water quality monitoring pipes",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$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":0},{"$f":"G45*E45","v":0},null,{"$f":"H45*I45","v":0},0]
[null,"Install permanent pumping system",null,"each",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},0]
[null,"Other",null,null,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},0]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H47)+0.0001","v":312867.6201},null,{"$f":"SUM(J5:J47)","v":306350.5},{"$f":"SUM(K5:K47)","v":6517.12}]
[null,null,null,null,null,null,"% of Total",null,null,{"$f":"J48/H48","v":0.97916972009466186},{"$f":"K48/H48","v":2.0830279585714151E-2}]

{"sheet":"Tailings","index":3,"n_rows":86,"n_cols":13,"rows_kept":86,"cut":false,"hidden":false,"merged":[[24,1,29,1]]}
[1,"Tailings Impoundment Name:","Doris-Madrid Mines",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"}},{"$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":0},{"$f":"G6*E6","v":0},null,{"$f":"H6*I6","v":0},{"$f":"+H6*(1-I6)","v":0}]
[null,"Berm",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$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":0},{"$f":"G7*E7","v":0},null,0,0]
[null,"Block roads",null,"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},{"$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,0,0]
[null,"STABILIZE EMBANKMENT(S)"]
[null,"Toe buttress, drainage layer",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,0,0]
[null,"Toe buttress, bulk fill",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},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"}},{"$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},0,null,0,0]
[null,"Raise crest",null,"m3",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},0,null,0,0]
[null,"Flatten slopes",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F16),0,INDEX(IF(UPPER(RIGHT(F16,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F16,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F16,LEN(F16)-1)),CostCode,0)))","v":0},0,null,0,0]
[null,"Other",null,null,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,0,0]
[null,"COVER TAILINGS"]
[null,"Grade/shape tailings surface","Windy Development Area Layout work for regrading","day",1,"TMAC",7190,{"$f":"G19*E19","v":7190},0.5,{"$f":"H19*I19","v":3595},{"$f":"+H19*(1-I19)","v":3595}]
[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","TIA-005 placement of NWG for erosion prevention","m2",54340,"TMAC",30.02,{"$f":"G23*E23","v":1631286.8},0.5,{"$f":"H23*I23","v":815643.4},{"$f":"+H23*(1-I23)","v":815643.4}]
[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","Prepare rock cover aggregate (drill and blast) TIA-001","m3",510000,"TMAC",23.16,{"$f":"G25*E25","v":11811600},0.5,{"$f":"H25*I25","v":5905800},{"$f":"+H25*(1-I25)","v":5905800}]
[null,null,"Place 300 mm cover for TIA-001","m3",510000,"TMAC",8.94,4559400,0.5,2279700,2279700]
[null,null,"Install nonwoven geotextile at TIA-005","m2",0,"TMAC",30.02,0,0.5,0,0,null,"had double counted this item in earlier estimate."]
[null,null,"Place Rip Rap over NWG at TIA-005","m3",24700,"TMAC",8.82,217854,0.5,108927,108927]
[null,null,"Produce and Place Rip Rap in channel","m3",18150,"TMAC",{"$f":"8.94+23.16","v":32.1},582615,0.5,291307.5,291307.5]
[null,null,"Windy Development Area cover","m3",665,"TMAC",12.69,8438.85,0.5,4219.4250000000002,4219.4250000000002]
[null,"Vegetate",null,"ha",null,"VHF",4000,0,null,0,0]
[null,"Other",null,"m3",null,"TMAC",24.71,{"$f":"G32*E32","v":0},0.5,{"$f":"H32*I32","v":0},{"$f":"+H32*(1-I32)","v":0}]
[null,"BURY PAG ROCK"]
[null,"Relocate PAG rock",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,0,0]
[null,"Place cover over PAG rock",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,0,0]
[null,"Raise crest of dam",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,0,0]
[null,"Other",null,null,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,0,0]
[null,"STABILIZE DECANT SYSTEM"]
[null,"Excavate and replace",null,"m3",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},{"$f":"+H39*(1-I39)","v":0}]
[null,"Plug/backfill with concrete or clay",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,{"$f":"H40*I40","v":0},{"$f":"+H40*(1-I40)","v":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},{"$f":"+H41*(1-I41)","v":0}]
[null,"REMOVE TAILINGS DISCHARGE"]
[null,"Cyclones",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,"Pipe","SR-002 tailings pipeline from Doris to TIA","m",2170,"TMAC",{"$f":"10.23+3.26","v":13.49},{"$f":"G44*E44","v":29273.3},0.5,{"$f":"H44*I44","v":14636.65},{"$f":"+H44*(1-I44)","v":14636.65},null,"Added unit rate for haulage to landfill"]
[null,"Remove reclaim barge",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$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":0},{"$f":"G45*E45","v":0},null,{"$f":"H45*I45","v":0},{"$f":"+H45*(1-I45)","v":0}]
[null,"CONSTRUCT DIVERSION DITCHES"]
[null,"Excavate ditches -soil",null,"m3",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,"Excavate ditches -rock",null,"m3",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,"Rip rap in channel base",null,"m3",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,"FLOOD TAILINGS"]
[null,"Doze tailings to final contour",null,"m3",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,0,0]
[null,"Raise crest of dam",null,"m3",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,0,0]
[null,"Other",null,null,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,0,0]
[null,"UPGRADE SPILLWAY"]
[null,"Excavate channel, rock",null,"m3",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,0,0]
[null,"Excavate channel, soil",null,"m3",null,"SC3H",{"$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":14.2},{"$f":"G56*E56","v":0},null,0,0]
[null,"Concrete",null,"m3",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,0,0]
[null,"Rip rap",null,"m3",null,"RB4H",{"$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":30.75},{"$f":"G58*E58","v":0},null,0,0]
[null,"Geotextile",null,"m2",null,"GSTL",{"$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":3.44},{"$f":"G59*E59","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(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,{"$f":"H61*I61","v":0},{"$f":"+H61*(1-I61)","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,"Install Silt Fencing","Patch Lake Devleopment Area","LS",1,"TMAC",2500,{"$f":"G67*E67","v":2500},50,{"$f":"H67*I67","v":125000},{"$f":"+H67*(1-I67)","v":-122500}]
[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(F70),0,INDEX(IF(UPPER(RIGHT(F70,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F70,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F70,LEN(F70)-1)),CostCode,0)))","v":0},{"$f":"G70*E70","v":0},null,{"$f":"H70*I70","v":0},{"$f":"+H70*(1-I70)","v":0}]
[null,"Install pumping wells",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F71),0,INDEX(IF(UPPER(RIGHT(F71,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F71,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F71,LEN(F71)-1)),CostCode,0)))","v":0},{"$f":"G71*E71","v":0},null,{"$f":"H71*I71","v":0},{"$f":"+H71*(1-I71)","v":0}]
[null,"Install pumps/pipelines/power supply",null,"LS",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,"SPECIALIZED ITEMS"]
[null,"Install permanent instrumentation, supply & technican",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},30000,{"$f":"G74*E74","v":0},null,{"$f":"H74*I74","v":0},{"$f":"+H74*(1-I74)","v":0}]
[null,"Install permanent instrumentation, drilling",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},30000,{"$f":"G75*E75","v":0},null,null,{"$f":"+H75*(1-I75)","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(F78),0,INDEX(IF(UPPER(RIGHT(F78,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F78,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F78,LEN(F78)-1)),CostCode,0)))","v":0},{"$f":"G78*E78","v":0},null,{"$f":"H78*I78","v":0},{"$f":"+H78*(1-I78)","v":0}]
[null,"Equipment maintenance and parts",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},100000,{"$f":"G79*E79","v":0},null,{"$f":"H79*I79","v":0},{"$f":"+H79*(1-I79)","v":0}]
[null,"Supply reagents",null,"tonne",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F80),0,INDEX(IF(UPPER(RIGHT(F80,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F80,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F80,LEN(F80)-1)),CostCode,0)))","v":0},{"$f":"G80*E80","v":0},null,{"$f":"H80*I80","v":0},{"$f":"+H80*(1-I80)","v":0}]
[null,null,null,null,null,null,"Annual treatment costs",{"$f":"SUM(H78:H80)+0.0001","v":1E-4}]
[null,"Number of years of treatment",null,"years"]
[null,null,null,null,null,null,"Total treatment costs",{"$f":"H81*E82","v":0},null,null,{"$f":"H83","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H75)+H83+0.0001","v":18850157.950100005},null,{"$f":"SUM(J5:J75)+J83","v":9548828.9750000015},{"$f":"SUM(K5:K75)+K83","v":9301328.9750000015}]
[null,null,null,null,null,null,"% of Total",null,null,{"$f":"J84/H84","v":0.50656493172511285},{"$f":"K84/H84","v":0.49343506826958211}]
[null,"* for construction of passive treatment system refer to \"Water Management\""]

{"sheet":"Rock Pile","index":4,"n_rows":83,"n_cols":14,"rows_kept":83,"cut":false,"hidden":false,"merged":[[45,1,46,1]]}
[1,"Rock Pile Name:","Doris - Madrid"]
[]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost","% Land","Land Cost","Water Cost"]
[null,"STABILIZE SLOPES"]
[null,"Grade Waste Rock Pile",null,"m3",null,"TMAC",1.23,{"$f":"G5*E5","v":0},0.5,{"$f":"H5*I5","v":0},{"$f":"+H5*(1-I5)","v":0}]
[null,"Grade Overburden ","Roberts Bay Overburden Pile RB-007","m2",14205,"DSl",{"$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":0.95},13494.75,0.5,6747.375,6747.375]
[null,null,"Quarry 2 Overburden Pile Q2-002 (slopes to 3:1)","m2",8785,"TMAC",3.27,{"$f":"G7*E7","v":28726.95},0.5,{"$f":"H7*I7","v":14363.475},{"$f":"+H7*(1-I7)","v":14363.475}]
[null,null,"Quarry 2 Overburden Pile Q2-002 (top)","m2",18440,"DSl",{"$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.95},{"$f":"G8*E8","v":17518},0.5,{"$f":"H8*I8","v":8759},{"$f":"+H8*(1-I8)","v":8759},null,"Don’t agree with SRK rate of $0.01","assume a dozer being used."]
[null,null,"Patch Lake Tank Farm  PLA-001 regrade (dozer)","m2",200,"TMAC",1.23,246,0.5,123,123]
[null,null,"Patch Lake Tank Farm  PLA-001 regrade (excavator)","m2",3630,"TMAC",5.5,19965,0.5,9982.5,9982.5]
[null,null,"Doris Windy AWR Explosive facility regrade (DM-010)","m2",2805,"DSl",{"$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.95},2664.75,0.5,1332.375,1332.375,null,"Don’t agree with SRK rate of $0.01","assume a dozer being used."]
[null,null,"Windy camp Regrading Bldg foot prints (WC-002)","m2",1248,"DSl",0.95,1185.5999999999999,0.5,592.79999999999995,592.79999999999995]
[null,"Grade Laydown Areas","Roberts bay Laydown Area RB-006","m2",63300,"DSl",0.95,60135,0.5,30067.5,30067.5,null,"Don’t agree with SRK rate of $0.01","assume a dozer being used."]
[null,null,"Reagent Pad - Equipment (RP-001)","m2",35244,"DSl",0.95,33481.799999999996,0.5,16740.899999999998,16740.899999999998,null,"Don’t agree with SRK rate of $0.01","assume a dozer being used."]
[null,null,"Reagent Pad - Material (RP-002)","m2",25421,"DSl",0.95,{"$f":"G15*E15","v":24149.949999999997},0.5,{"$f":"H15*I15","v":12074.974999999999},{"$f":"+H15*(1-I15)","v":12074.974999999999},null,"Don’t agree with SRK rate of $0.01","assume a dozer being used."]
[null,null,"Reagent Pad - ANFO Storage Area (RP-003)","m2",2481,"DSl",0.95,2356.9499999999998,0.5,1178.4749999999999,1178.4749999999999,null,"Don’t agree with SRK rate of $0.01","assume a dozer being used."]
[null,null,"Waste Management Landfarm (WM-001)","m2",4385,"DSl",0.95,4165.75,0.5,2082.875,2082.875,null,"Don’t agree with SRK rate of $0.01","assume a dozer being used."]
[null,null,"Waste Management Batch Plant Pad (WM-002)","m2",740,"DSl",0.95,{"$f":"G18*E18","v":703},0.5,{"$f":"H18*I18","v":351.5},{"$f":"+H18*(1-I18)","v":351.5},null,"Don’t agree with SRK rate of $0.01","assume a dozer being used."]
[null,null,"Waste Management Burn Pan Pad (WM-003)","m2",400,"DSl",0.95,380,0.5,190,190,null,"Don’t agree with SRK rate of $0.01","assume a dozer being used."]
[null,"Grade Old Camp Ore Pile",null,"m3",null,"TMAC",1.23,0,0.5,0,0]
[null,"Grade Ore Stockpile",null,"m3",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},0,null,0,0]
[null,"Buttress","Windy Tank Farm (WC-001)","m3",600,"TMAC",12.27,7362,0.5,3681,3681]
[null,"Toe buttress, fill mat'l A",null,"m3",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},0,null,0,0]
[null,"Toe buttress, fill mat'l B",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},0,null,0,0]
[null,"Other",null,null,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,0,0]
[null,"ROCK COVER"]
[null,"Subgrade preparation - doze surface",null,"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,"Soil cover - excavate,haul,spread&compact",null,"m3",null,"SB1L",4.3,0,null,0,0]
[null,"Prepare debris for capping",null,"m3",null,"TMAC",86.72,{"$f":"G29*E29","v":0},null,{"$f":"H29*I29","v":0},{"$f":"+H29*(1-I29)","v":0}]
[null,"Prepare aggregate",null,"m3",null,"TMAC",24.71,{"$f":"G30*E30","v":0},null,{"$f":"H30*I30","v":0},{"$f":"+H30*(1-I30)","v":0}]
[null,"Rock cover - excavate,haul & spread",null,"m3",null,"TMAC",16.350000000000001,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","Patch Lake Tank Farm  PLA-001 cover 1m","m3",3000,"TMAC",24.53,73590,0.5,36795,36795]
[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(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,"Supply geomembrame",null,"m2",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,0,0]
[null,"Install geomembrane",null,"m2",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,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(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,"Excavate ditches -rock",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$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":0},{"$f":"G45*E45","v":0},null,{"$f":"H45*I45","v":0},{"$f":"+H45*(1-I45)","v":0}]
[null,"Rip rap  in channel base"]
[]
[null,"CONSTRUCT SEEPAGE COLLECTION POND"]
[null,"Excavate seepage collection pond",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H49*I49","v":0},{"$f":"+H49*(1-I49)","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(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,"Install pumping wells",null,"m3",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,"Install pumps/pipelines/power supply",null,"allow",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,{"$f":"H59*I59","v":0},{"$f":"+H59*(1-I59)","v":0}]
[null,"RELOCATE DUMPS"]
[null,"Load, haul, dump or doze",null,"m3",null,"SC3L",{"$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":8.9},{"$f":"G61*E61","v":0},null,{"$f":"H61*I61","v":0},{"$f":"+H61*(1-I61)","v":0}]
[null,"Add lime",null,"tonne",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,{"$f":"H62*I62","v":0},{"$f":"+H62*(1-I62)","v":0}]
[null,"Contour reclaimed area",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F63),0,INDEX(IF(UPPER(RIGHT(F63,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F63,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F63,LEN(F63)-1)),CostCode,0)))","v":0},{"$f":"G63*E63","v":0},null,{"$f":"H63*I63","v":0},{"$f":"+H63*(1-I63)","v":0}]
[null,"Other",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},20000,{"$f":"G64*E64","v":0},null,{"$f":"H64*I64","v":0},{"$f":"+H64*(1-I64)","v":0}]
[null,"SPECIALIZED ITEMS"]
[null,"Install permanent instrumentation",null,"allow",null,"Ea",50000,{"$f":"G66*E66","v":0},null,{"$f":"H66*I66","v":0},{"$f":"+H66*(1-I66)","v":0}]
[null,"Install permanent instrumentation, drilling",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F67),0,INDEX(IF(UPPER(RIGHT(F67,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F67,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F67,LEN(F67)-1)),CostCode,0)))","v":0},{"$f":"G67*E67","v":0},null,{"$f":"H67*I67","v":0},{"$f":"+H67*(1-I67)","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(F70),0,INDEX(IF(UPPER(RIGHT(F70,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F70,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F70,LEN(F70)-1)),CostCode,0)))","v":0},{"$f":"G70*E70","v":0},null,{"$f":"H70*I70","v":0},{"$f":"+H70*(1-I70)","v":0}]
[null,"Reagents",null,"tonnes",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F71),0,INDEX(IF(UPPER(RIGHT(F71,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F71,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F71,LEN(F71)-1)),CostCode,0)))","v":0},{"$f":"G71*E71","v":0},null,{"$f":"H71*I71","v":0},{"$f":"+H71*(1-I71)","v":0}]
[null,"Electrician/mechanic to maintain treatment plant",null,"allow",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"}},{"$f":"IF(ISNA(F73),0,INDEX(IF(UPPER(RIGHT(F73,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F73,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F73,LEN(F73)-1)),CostCode,0)))","v":0},{"$f":"G73*E73","v":0},null,{"$f":"H73*I73","v":0},{"$f":"+H73*(1-I73)","v":0}]
[null,null,null,null,null,null,"Annual treatment costs",{"$f":"SUM(H70:H73)+0.0001","v":1E-4}]
[null,"Number of years of treatment",null,"years"]
[null,null,null,null,null,null,"Total treatment costs",{"$f":"H74*E75","v":0},null,null,{"$f":"H76","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(F78),0,INDEX(IF(UPPER(RIGHT(F78,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F78,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F78,LEN(F78)-1)),CostCode,0)))","v":0},{"$f":"G78*E78","v":0},null,null,{"$f":"H78","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H67)+H76+H78+0.0001","v":290125.5001},null,{"$f":"SUM(J5:J67)+J76+J78","v":145062.75},{"$f":"SUM(K5:K67)+K76+K78","v":145062.75}]
[null,null,null,null,null,null,"% of Total",null,null,{"$f":"J79/H79","v":0.4999999998276608},{"$f":"K79/H79","v":0.4999999998276608}]
[]
[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":107,"n_cols":15,"rows_kept":107,"cut":false,"hidden":false,"merged":[[20,12,22,12],[20,1,22,1],[37,1,40,1],[79,1,84,1],[71,1,78,1],[63,1,70,1],[27,1,28,1],[2,1,2,7],[23,1,26,1],[10,1,12,1],[13,1,15,1],[29,1,33,1]]}
[1,"Chemicals/Soil Area Name: Doris - Madrid"]
[]
[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","RB-013, RB-002, RB-003, & DM-020","each",{"$f":"2+4+1+5","v":12},"TMAC",265,3180,0.5,1590,1590]
[null,"Drain, clean and crush empty drums","RB-003","each",150,"TMAC",{"$f":"21.04+18.4","v":39.44},{"$f":"G10*E10","v":5916},0.5,{"$f":"H10*I10","v":2958},{"$f":"+H10*(1-I10)","v":2958}]
[null,"Removal of Doris fresh water pipeline","DM-006 decommission","each",4,"TMAC",680,2720,0.5,1360,1360]
[null,null,"DM-006 dismantle","lm",830,"TMAC",11.08,9196.4,0.5,4598.2,4598.2]
[null,null,"DM-006 load, haul & tip debris to Q3 landfill","m3",28.2,"TMAC",{"$f":"10.23+5.99","v":16.22},457.40399999999994,0.5,228.70199999999997,228.70199999999997]
[null,"Removal of Secondary Road Tailings and Reclaim water pipeline","SR-002 decommission","each",4,"TMAC",680,{"$f":"G14*E14","v":2720},0.5,{"$f":"H14*I14","v":1360},{"$f":"+H14*(1-I14)","v":1360}]
[null,null,"SR-002 dismantle","lm",8125,"TMAC",11.08,90025,0.5,45012.5,45012.5]
[null,null,"SR-002 load, haul & tip debris to Q3 landfill","m3",255.3,"TMAC",{"$f":"10.23+5.23","v":15.46},3946.9380000000006,0.5,1973.4690000000003,1973.4690000000003]
[null,"Drain residual fuel from tank at vent raise","DM-030 drain tank","each",1,"TMAC",265,{"$f":"G17*E17","v":265},0.5,{"$f":"H17*I17","v":132.5},{"$f":"+H17*(1-I17)","v":132.5}]
[null,"Drain chemicals and reagent from containers","Doris DM-021","m3",8.3000000000000007,"TMAC",2700,{"$f":"G18*E18","v":22410.000000000004},0.5,{"$f":"H18*I18","v":11205.000000000002},{"$f":"+H18*(1-I18)","v":11205.000000000002}]
[null,null,"Madrid North Concentrator","m3",4.2,"TMAC",2700,{"$f":"G19*E19","v":11340},0.5,{"$f":"H19*I19","v":5670},{"$f":"+H19*(1-I19)","v":5670}]
[null,"Decontaminate sewage treatment plant",null,"LS",null,"TMAC",667.63,0,null,0,0]
[null,"Decontaminate bulk fuel storage","Roberts Bay and Doris Tank Farms RB-013, RB-002, RB-003, & DM-020","each",{"$f":"4+4+1+5","v":14},"TMAC",{"$f":"476.06+1186.71+32.8","v":1695.57},23737.98,0.5,11868.99,11868.99,null,"include a 1 m3 of sludge to manage in O/W separator"]
[null,null,"Madrid North Fuel Storage Facility MN-011","each",3,"TMAC",{"$f":"476.06+1186.71+32.8","v":1695.57},{"$f":"G22*E22","v":5086.71},0.5,{"$f":"H22*I22","v":2543.355},{"$f":"+H22*(1-I22)","v":2543.355}]
[null,null,"Madrid South Fuel Storage Facility MS-017","each",1,"TMAC",{"$f":"476.06+1186.71+32.8","v":1695.57},{"$f":"G23*E23","v":1695.57},0.5,{"$f":"H23*I23","v":847.78499999999997},{"$f":"+H23*(1-I23)","v":847.78499999999997}]
[null,"CDR-004 Cargo Dock Access Road Fuel Transfer Lines","Decommission Pipeline","LS",1,"TMAC",680,{"$f":"G24*E24","v":680},0.5,{"$f":"H24*I24","v":340},{"$f":"+H24*(1-I24)","v":340}]
[null,null,"Dismantle pipeline","lm",3250,"TMAC",11.08,36010,0.5,18005,18005]
[null,null,"Remove electrical equipment","LS",2,"TMAC",680,1360,0.5,680,680]
[null,null,"Load, haul and tip debris at Q3 landfill","m3",159.5,"TMAC",{"$f":"10.23+5.23","v":15.46},{"$f":"G27*E27","v":2465.8700000000003},0.5,{"$f":"H27*I27","v":1232.9350000000002},{"$f":"+H27*(1-I27)","v":1232.9350000000002}]
[null,"Drain Reclaim Pond","CM-001 labour","mandays",0,"TMAC",1890,0,0.5,0,0,null,"already accounted for under Water Treatment"]
[null,null,"CM-001 equipment","LS",0,"TMAC",70000,0,0.5,0,0,null,"already accounted for under Water Treatment"]
[null,"Liner cleaning","Doris (DM-020, RP-004& WM-001)","m2",{"$f":"5500+2485+4385","v":12370},"TMAC",0.41,{"$f":"G30*E30","v":5071.7},0.5,{"$f":"H30*I30","v":2535.85},{"$f":"+H30*(1-I30)","v":2535.85}]
[null,null,"Roberts Bay Q1 Tank farm","m2",9933,"TMAC",0.41,{"$f":"G31*E31","v":4072.5299999999997},0.5,{"$f":"H31*I31","v":2036.2649999999999},{"$f":"+H31*(1-I31)","v":2036.2649999999999}]
[null,null,"Roberts Bay Tank Farm","m2",{"$f":"8600+13200","v":21800},"TMAC",0.41,{"$f":"G32*E32","v":8938},0.5,{"$f":"H32*I32","v":4469},{"$f":"+H32*(1-I32)","v":4469}]
[null,null,"Madrid North liners (MN-011, -13, -14, & -15)","m2",{"$f":"20+145+20+25","v":210},"TMAC",0.41,86.1,0.5,43.05,43.05]
[null,null,"Madrid South liners (MS-017, -018 & -019)","m2",{"$f":"375+25+145","v":545},"TMAC",0.41,223.45,0.5,111.72499999999999,111.72499999999999]
[null,"Decontaminate offices/warehouse/accom",null,"m2",null,"BDAL",{"$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":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","Load and Transport drums from Doris Process Plant to Roberts Bay","m3",8.32,"TMAC",{"$f":"10.23+2.3","v":12.530000000000001},104.24960000000002,0.5,52.124800000000008,52.124800000000008,null,"added containerization cost of $10.23"]
[null,null,"Madrid North drums from Concentrator to RB","m3",4,"TMAC",{"$f":"10.23+5.02","v":15.25},{"$f":"G39*E39","v":61},0.5,{"$f":"H39*I39","v":30.5},{"$f":"+H39*(1-I39)","v":30.5},null,"added containerization cost of $10.23"]
[]
[]
[null,"HAZARDOUS MATERIALS REMOVAL"]
[null,"Waste oils",null,"litre",null,"orl",{"$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.43},{"$f":"G43*E43","v":0},null,{"$f":"H43*I43","v":0},{"$f":"+H43*(1-I43)","v":0}]
[null,"Waste fuel","RB-002, RB-013&DM-020","litre",{"$f":"80000+160000+75000","v":315000},"orl",{"$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.43},135450,null,0,135450,null,"TMAC is now stating 75000 L only does not match earlier numbers"]
[null,null,"Madrid South MS-017","litre",2000,"orl",{"$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":0.43},{"$f":"G45*E45","v":860},null,{"$f":"H45*I45","v":0},{"$f":"+H45*(1-I45)","v":860},null,"Using a different rate."]
[null,null,"Madrid North MN-011","litre",45000,"orl",{"$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.43},19350,null,0,19350,null,"No quanity provided in latest estimate does not match earlier email."]
[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,0,0]
[null,"Process reagents",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},2.5,{"$f":"G51*E51","v":0},null,0,0]
[null,"Nuclear sources",null,"allow",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},0,null,0,0]
[null,"Other hazardous materials",null,"allow",null,"AE",20000,{"$f":"G53*E53","v":0},null,0,0]
[null,"HAZARDOUS MATERIALS "]
[null,"Transportation to Roberts Bay","Windy Development Area","m3",2.8,"TMAC",6.9,{"$f":"G55*E55","v":19.32},0.5,{"$f":"H55*I55","v":9.66},{"$f":"+H55*(1-I55)","v":9.66}]
[null,"Disposal fees","Windy Development Area","m3",2.8,"TMAC",11275,{"$f":"G56*E56","v":31569.999999999996},0.5,{"$f":"H56*I56","v":15784.999999999998},{"$f":"+H56*(1-I56)","v":15784.999999999998}]
[null,"Waste Ship Off-site","Hazardous waste liquid and solid","m3",{"$f":"120+40","v":160},"TMAC",232.32,{"$f":"G57*E57","v":37171.199999999997},0.5,{"$f":"H57*I57","v":18585.599999999999},{"$f":"+H57*(1-I57)","v":18585.599999999999}]
[null,"Waste Disposal","Hazardous Waste allowance","allow",1,"TMAC",50000,{"$f":"G58*E58","v":50000},0.5,{"$f":"H58*I58","v":25000},{"$f":"+H58*(1-I58)","v":25000}]
[null,"Other",null,"allow",null,"ea",40000,{"$f":"G59*E59","v":0},0.5,{"$f":"H59*I59","v":0},{"$f":"+H59*(1-I59)","v":0}]
[null,"CONTAMINATED SOILS "]
[null,"Contam. soil investigation - Phase 1","a report for each site","each",3,"CS1L",{"$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":7500},{"$f":"G61*E61","v":22500},0.5,{"$f":"H61*I61","v":11250},{"$f":"+H61*(1-I61)","v":11250}]
[null,"Contam. soil investigation - Phase 2","aggregate cost for Doris and Madrid sites","allow",1,"EA",175000,175000,0.5,87500,87500]
[null,"CONTAMINATED SOIL REMOVAL"]
[null,"Excavate and transport Impacted Soil to Portal","Doris RB-013, RB-002, RB-003, DM-020 & WM-001 (PHC)","m3",12389,"TMAC",{"$f":"72.73+2.3","v":75.03},{"$f":"G64*E64","v":929546.67},0.5,{"$f":"H64*I64","v":464773.33500000002},{"$f":"+H64*(1-I64)","v":464773.33500000002},null,"updated the quantity and amended double count under buildings for the haulage of material to the underground",null,{"$f":"5157+3962+1490+1680+100","v":12389}]
[null,null,"Patch Lake Development Area","m3",245,"TMAC",{"$f":"72.73+2.3","v":75.03},{"$f":"G65*E65","v":18382.349999999999},0.5,{"$f":"H65*I65","v":9191.1749999999993},{"$f":"+H65*(1-I65)","v":9191.1749999999993}]
[null,null,"Windy Development Area","m3",720,"TMAC",75.03,{"$f":"G66*E66","v":54021.599999999999},0.5,{"$f":"H66*I66","v":27010.799999999999},{"$f":"+H66*(1-I66)","v":27010.799999999999}]
[null,null,"Waste Management Area Landfarm","m3",100,"TMAC",75.03,7503,0.5,3751.5,3751.5]
[null,null,"Madrid North MN-011 (PHC)","m3",1220,"TMAC",75.03,{"$f":"G68*E68","v":91536.6},0.5,{"$f":"H68*I68","v":45768.3},{"$f":"+H68*(1-I68)","v":45768.3}]
[null,null,"Madrid North Portal Pad","m3",7635,"TMAC",{"$f":"72.73","v":72.73},{"$f":"G69*E69","v":555293.55000000005},0.5,{"$f":"H69*I69","v":277646.77500000002},{"$f":"+H69*(1-I69)","v":277646.77500000002}]
[null,null,"Madrid North MN-014 & -015 Madrid South MS-018 & -019(brine)","m3",{"$f":"6+8+6+6","v":26},"TMAC",75.03,{"$f":"G70*E70","v":1950.78},0.5,{"$f":"H70*I70","v":975.39},{"$f":"+H70*(1-I70)","v":975.39}]
[null,null,"Madrid South  MS-017 (PHC)","m3",225,"TMAC",75.03,16881.75,0.5,8440.875,8440.875]
[null,"Place hydrocarbon and other impacted soil underground","Doris RB-013, RB-002, RB-003, DM-020 & WM-001 (PHC)","m3",{"$f":"5160+3960+1490+1680","v":12290},"TMAC",15.37,188897.3,0.5,94448.65,94448.65]
[null,null,"Patch Lake Development Area","m3",245,"TMAC",15.37,3765.6499999999996,0.5,1882.8249999999998,1882.8249999999998]
[null,null,"Madrid North MN-011 & MN-013(PHC)","m3",1220,"TMAC",15.37,{"$f":"G74*E74","v":18751.399999999998},0.5,{"$f":"H74*I74","v":9375.6999999999989},{"$f":"+H74*(1-I74)","v":9375.6999999999989}]
[null,null,"Madrid North MN-014 & -015 Madrid South MS-018 & -019(brine)","m3",{"$f":"6+8+6+6","v":26},"TMAC",15.37,{"$f":"G75*E75","v":399.62},0.5,{"$f":"H75*I75","v":199.81},{"$f":"+H75*(1-I75)","v":199.81}]
[null,null,"Madrid North Portal Pad","m3",7635,"TMAC",15.37,117349.95,0.5,58674.974999999999,58674.974999999999]
[null,null,"Waste Management Area Landfarm","m3",100,"TMAC",15.37,1537,0.5,768.5,768.5]
[null,null,"Windy Development Area","m3",720,"TMAC",15.37,11066.4,0.5,5533.2,5533.2]
[null,null,"Madrid South  MS-017 (PHC)","m3",225,"TMAC",15.37,3458.25,0.5,1729.125,1729.125]
[null,"Fuel/Reagent/Brine Containment areas remove soil cover from liner","Doris RB-013, RB-002, RB-003 & DM-020 excavation of cover soil from liners","m3",{"$f":"10315+7925+2980+3360","v":24580},"TMAC",2.75,{"$f":"G80*E80","v":67595},0.5,33797.5,33797.5]
[null,null,"Reagent Pad RP-003","m3",1390,"TMAC",2.75,{"$f":"G81*E81","v":3822.5},0.5,{"$f":"H81*I81","v":1911.25},{"$f":"+H81*(1-I81)","v":1911.25},null,"volume corrected here and removed from Buildings "]
[null,null,"Waste Management Area Landfarm","m3",2590,"TMAC",2.75,{"$f":"G82*E82","v":7122.5},0.5,{"$f":"H82*I82","v":3561.25},{"$f":"+H82*(1-I82)","v":3561.25}]
[null,null,"Madrid North MN-011","m3",2435,"TMAC",2.75,{"$f":"G83*E83","v":6696.25},0.5,{"$f":"H83*I83","v":3348.125},{"$f":"+H83*(1-I83)","v":3348.125}]
[null,null,"Madrid North Water Storage Tank  MN-013","m3",260,"TMAC",2.75,{"$f":"G84*E84","v":715},0.5,{"$f":"H84*I84","v":357.5},{"$f":"+H84*(1-I84)","v":357.5}]
[null,null,"Madrid South  MS-017 and -020","m3",{"$f":"450+260","v":710},"TMAC",2.75,1952.5,0.5,976.25,976.25]
[null,"Waste haulage to Landfill","Waste Management Area Landfarm","m3",120,"TMAC",4.7,{"$f":"G86*E86","v":564},0.5,{"$f":"H86*I86","v":282},{"$f":"+H86*(1-I86)","v":282}]
[null,"Remove Sumps","MN-023, DM-018","each",3,"TMAC",680,{"$f":"G87*E87","v":2040},0.5,{"$f":"H87*I87","v":1020},{"$f":"+H87*(1-I87)","v":1020},null,"TMAC has in Water Mgmt"]
[null,"Place Mega Bags into Containers (Transport)","Windy Development Area","m3",720,"TMAC",20.91,{"$f":"G88*E88","v":15055.2},0.5,{"$f":"H88*I88","v":7527.6},{"$f":"+H88*(1-I88)","v":7527.6}]
[null,"Place soil in Mega Bags and Empty into Containers","Windy Development Area","m3",60,"TMAC",{"$f":"72.73+16.35+34.3","v":123.38000000000001},{"$f":"G89*E89","v":7402.8},0.5,{"$f":"H89*I89","v":3701.4},{"$f":"+H89*(1-I89)","v":3701.4}]
[null,"Disposal of PHC impacted soil to Madrid Portal from Demolition ","Windy Development Area","m3",4265,"TMAC",2.77,{"$f":"G90*E90","v":11814.05},0.5,{"$f":"H90*I90","v":5907.0249999999996},{"$f":"+H90*(1-I90)","v":5907.0249999999996}]
[null,"Disposal of PHC impacted soil to Madrid Portal from Demolition ","Patch Lake Development Area","m3",245,"TMAC",2.77,{"$f":"G91*E91","v":678.65},0.5,{"$f":"H91*I91","v":339.32499999999999},{"$f":"+H91*(1-I91)","v":339.32499999999999}]
[null,"Survey for Soil Remediation","PHC and Metal Impacted Area","LS",0,"TMAC",25000,{"$f":"G92*E92","v":0},0.5,{"$f":"H92*I92","v":0},{"$f":"+H92*(1-I92)","v":0},null,"This is a $50K allowance that could be covered under Engineering."]
[null,"In-situ Bio-remediation","Patch Lake Development Area","m3",39,"TMAC",260,10140,0.5,5070,5070]
[null,"Transport PHC impacted soil to offsite facility","W-001 relates to soil that cannot go underground","m3",280,"TMAC",1114.93,312180.40000000002,0.5,156090.20000000001,156090.20000000001,null,"Need to keep this allowance in the event not all the material goes undergrond."]
[null,"Contour decontaminated area",null,"m3",null,"dsl",{"$f":"IF(ISNA(F95),0,INDEX(IF(UPPER(RIGHT(F95,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F95,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F95,LEN(F95)-1)),CostCode,0)))","v":0.95},0,0.5,{"$f":"H95*I95","v":0},{"$f":"+H95*(1-I95)","v":0}]
[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(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},{"$f":"G97*E97","v":0},null,{"$f":"H97*I97","v":0},{"$f":"+H97*(1-I97)","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,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"OTHER"]
[null,null,null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F105),0,INDEX(IF(UPPER(RIGHT(F105,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F105,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F105,LEN(F105)-1)),CostCode,0)))","v":0},{"$f":"G105*E105","v":0},null,{"$f":"H105*I105","v":0},{"$f":"+H105*(1-I105)","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H6:H105)+0.0001","v":3181811.1416999996},null,{"$f":"SUM(J6:J105)","v":1513075.5707999999},{"$f":"SUM(K6:K105)","v":1668735.5707999999}]
[null,null,null,null,null,null,"% of Total",null,null,{"$f":"J106/H106","v":0.47553908871900663},{"$f":"K106/H106","v":0.52446091124956473}]

{"sheet":"Bldgs & Equip","index":6,"n_rows":348,"n_cols":14,"rows_kept":348,"cut":false,"hidden":false,"merged":[[246,13,247,13],[320,13,323,13],[236,1,237,1],[22,1,25,1],[89,1,90,1],[96,1,97,1],[46,1,54,1],[134,1,138,1],[94,1,95,1],[76,1,78,1],[91,1,93,1],[115,1,116,1],[111,1,114,1],[23,12,25,12],[112,12,114,12],[238,1,243,1],[32,1,39,1],[98,1,110,1],[192,1,198,1],[55,1,60,1],[61,1,75,1],[26,1,31,1],[199,1,201,1],[79,1,88,1],[148,1,156,1],[141,1,147,1],[40,1,45,1],[117,1,131,1],[176,1,186,1],[4,1,5,1],[285,1,287,1],[17,1,21,1],[202,1,205,1],[187,1,191,1],[272,1,274,1],[157,1,160,1],[161,1,167,1],[168,1,175,1],[221,1,225,1],[228,1,235,1],[208,1,212,1],[12,1,16,1],[269,1,271,1],[278,1,281,1],[213,1,218,1],[246,12,247,12],[320,12,323,12],[329,12,331,12],[336,1,339,1],[314,1,315,1],[300,1,313,1],[328,1,331,1],[320,1,327,1],[289,1,299,1],[316,1,318,1],[333,1,334,1],[246,1,247,1]]}
[1,"Building / Equip Name:","Doris - Madrid ",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 prepare for off-site","Madrid North Concentrator","allow",1,"TMAC",50000,{"$f":"G5*E5","v":50000},0.5,{"$f":"H5*I5","v":25000},{"$f":"+H5*(1-I5)","v":25000}]
[null,null,"Doris Water Intake Generator","each",1,"TMAC",1370,{"$f":"G6*E6","v":1370},0.5,{"$f":"H6*I6","v":685},{"$f":"+H6*(1-I6)","v":685}]
[null,"Consolidate Electrical Equipment from Pipelines","Madrid South, Madrid North, Doris freshwater and Tialings/Reclaim water pipelines","m2",{"$f":"2860+2680+1600+4065","v":11205},"TMAC",0.56999999999999995,{"$f":"G7*E7","v":6386.8499999999995},0.5,{"$f":"H7*I7","v":3193.4249999999997},{"$f":"+H7*(1-I7)","v":3193.4249999999997},null,"added cost to remove cabling as well ie C3.20","The added cost for the cabling was not necessarily appropriate.  Waste debris clean up rate as used elsewhere has been applied."]
[null,"Relocate Containers to Quarry 3 Landfill","current a large inventor of containers that will no longer go off site","ea",250,"TMAC",204.56,{"$f":"G8*E8","v":51140},0.5,{"$f":"H8*I8","v":25570},{"$f":"+H8*(1-I8)","v":25570},null,"use units C1.08+C4.15 for the haulage and demolition of contianers at landfill","Understand containers are not to remain as is with no breakdown."]
[null,"Relocate Trailers to Quarry 3 Landfill",null,"m3",null,"TMAC",19.149999999999999,{"$f":"G9*E9","v":0},0.5,{"$f":"H9*I9","v":0},{"$f":"+H9*(1-I9)","v":0}]
[null,"Relocate Camp","Windy Accommodation Camp (relocate to Doris)","m3",32,"TMAC",{"$f":"2.77+10.23","v":13},{"$f":"G10*E10","v":416},0.5,{"$f":"H10*I10","v":208},{"$f":"+H10*(1-I10)","v":208},null,"added cost to collapse and containerize"]
[null,"Other",null,null,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,0,{"$f":"+H11*(1-I11)","v":0}]
[null,"REMOVE BUILDINGS "]
[null,"Accomodation Complex","DM-001 Decommission ","each",103,"TMAC",679.52,{"$f":"G13*E13","v":69990.559999999998},0.5,{"$f":"H13*I13","v":34995.279999999999},{"$f":"+H13*(1-I13)","v":34995.279999999999}]
[null,null,"DM-001 Demolition cabins/cribs/stairs/Arctic corridor etc.","m3",{"$f":"320+225+135","v":680},"TMAC",13.12,8921.6,0.5,4460.8,4460.8]
[null,null,"DM-001 Demolition Trailers","m3",11185,"TMAC",13.32,{"$f":"G15*E15","v":148984.20000000001},0.5,{"$f":"H15*I15","v":74492.100000000006},{"$f":"+H15*(1-I15)","v":74492.100000000006}]
[null,null,"DM-001 Consolidate and laod waste","m3",7450,"TMAC",{"$f":"10.23","v":10.23},76213.5,0.5,38106.75,38106.75]
[null,null,"DM-001 Haul waste to landfill","m3",7450,"TMAC",4.7,35015,0.5,17507.5,17507.5]
[null,"Windy Accommodation Camp","Dismantle comm equipment","LS",1,"TMAC",375,{"$f":"G18*E18","v":375},0.5,{"$f":"H18*I18","v":187.5},{"$f":"+H18*(1-I18)","v":187.5}]
[null,null,"Equipment decommissioning","each",1,"TMAC",679.52,679.52,0.5,339.76,339.76]
[null,null,"manual demolition","m2",890,"TMAC",155,137950,0.5,68975,68975]
[null,null,"mechanical demolition","m3",3480,"TMAC",11.23,39080.400000000001,0.5,19540.2,19540.2]
[null,null,"laod and haul waste","m3",1895,"TMAC",{"$f":"10.23+4.92","v":15.15},28709.25,0.5,14354.625,14354.625]
[null,"Roberts Bay Mechanical Shop Complex","decommissioing elec/mech/HVAC","each",7,"TMAC",679.52,{"$f":"G23*E23","v":4756.6399999999994},0.5,{"$f":"H23*I23","v":2378.3199999999997},{"$f":"+H23*(1-I23)","v":2378.3199999999997}]
[null,null,"Demo of steel frame","m3",0,"TMAC",{"$f":"13.12+10.23+5.99","v":29.340000000000003},{"$f":"G24*E24","v":0},0.5,{"$f":"H24*I24","v":0},0,null,null,"Double count with line 101 remove 2400"]
[null,null,"Demoo of wood frame","m3",0,"TMAC",{"$f":"13.12+10.23+5.99","v":29.340000000000003},{"$f":"G25*E25","v":0},0.5,{"$f":"H25*I25","v":0},{"$f":"+H25*(1-I25)","v":0},null,null,"Double count with line 101 remove 285"]
[null,null,"demo of tent structure","m3",0,"TMAC",29.340000000000003,0,0.5,0,0,null,null,"Double count with line 101remove 460"]
[null,"Process Facilities","DM-021 dismantle & prep for off-site disposal","LS",1,"TMAC",{"$f":"250000+100000","v":350000},{"$f":"G27*E27","v":350000},0.5,175000,{"$f":"+H27*(1-I27)","v":175000}]
[null,null,"DM-021 demolish Mill, crusher and process plant","m3",123540,"TMAC",13.12,{"$f":"G28*E28","v":1620844.7999999998},0.5,{"$f":"H28*I28","v":810422.39999999991},810422.39999999991]
[null,null,"DM-021 haul waste to landfill","m3",{"$f":"8522.2","v":8522.2000000000007},"TMAC",{"$f":"10.23+4.92","v":15.15},{"$f":"G29*E29","v":129111.33000000002},0.5,{"$f":"H29*I29","v":64555.665000000008},{"$f":"+H29*(1-I29)","v":64555.665000000008},null,"added cost for haulage to landfill"]
[null,null,"MN-008 Concentrator - disconnection","ea",1,"TMAC",{"$f":"200000+100000","v":300000},{"$f":"G30*E30","v":300000},0.5,{"$f":"H30*I30","v":150000},{"$f":"+H30*(1-I30)","v":150000}]
[null,null,"MN-008 Concentrator - demolition","m3",23075,"TMAC",13.32,307359,0.5,153679.5,153679.5]
[null,null,"MN-008 Concentrator -  consolidate and haul","m3",3695,"TMAC",{"$f":"10.23+4.92","v":15.15},55979.25,0.5,27989.625,27989.625]
[null,"Office & Dry Complex","DM-009 MN-005 and MS-006 Decommission facilities","each",{"$f":"3+3+3","v":9},"TMAC",679.52,{"$f":"G33*E33","v":6115.68},0.5,{"$f":"H33*I33","v":3057.84},3057.84]
[null,null,"DM-009 Disconnect assemblies for disposal","each",17,"TMAC",1370,23290,0.5,11645,11645]
[null,null,"DM-009 demolition","m3",{"$f":"219.5+45.9","v":265.39999999999998},"TMAC",13.12,3482.0479999999993,0.5,1741.0239999999997,1741.0239999999997]
[null,null,"DM-009 Haul assemblies for disposal","m3",145670.5,"TMAC",4.7,684651.35,0.5,342325.67499999999,342325.67499999999]
[null,null,"DM-009 Consolidate and dispose of waste at landfill","m3",{"$f":"219.5+45.9","v":265.39999999999998},"TMAC",{"$f":"10.23+4.92","v":15.15},4020.81,0.5,2010.405,2010.405]
[null,null,"Madrid North Office Trailer - haul and disposal of at landfill","m3",50,"TMAC",{"$f":"10.23+4.92","v":15.15},{"$f":"G38*E38","v":757.5},0.5,{"$f":"H38*I38","v":378.75},{"$f":"+H38*(1-I38)","v":378.75},null,"TMAC estimate is inconsistent so volume of haulage used"]
[null,null,"Madrid South Office Trailer - demolition","m3",75,"TMAC",13.12,983.99999999999989,0.5,491.99999999999994,491.99999999999994]
[null,null,"Madrid South Office Trailer - haul and dispose of at landfill","m3",50,"TMAC",{"$f":"10.23+3.26","v":13.49},674.5,0.5,337.25,337.25,null,"TMAC estimate is inconsistent so volume of haulage used"]
[null,"Laydown Area","RB-006 decommission vehicle plugs","ea",8,"TMAC",{"$f":"(680/8)+412","v":497},{"$f":"G41*E41","v":3976},0.5,{"$f":"H41*I41","v":1988},{"$f":"+H41*(1-I41)","v":1988},null,null,"rate changed to reflect correction in work effort (only one disconnect of system required"]
[null,null,"MN-010 decom vehicle plugs","ea",5,"TMAC",{"$f":"411.17+680","v":1091.17},{"$f":"G42*E42","v":5455.85},0.5,{"$f":"H42*I42","v":2727.9250000000002},{"$f":"+H42*(1-I42)","v":2727.9250000000002}]
[null,null,"MS-009 decom vehicle plugs and posts","ea",5,"TMAC",{"$f":"411.17+680","v":1091.17},{"$f":"G43*E43","v":5455.85},0.5,{"$f":"H43*I43","v":2727.9250000000002},{"$f":"+H43*(1-I43)","v":2727.9250000000002}]
[null,null,"MN-010 consolidate and relocate waste to landfill","m2",1475,"TMAC",0.56999999999999995,840.74999999999989,0.5,420.37499999999994,420.37499999999994]
[null,null,"MS-009 consolidate and relocate waste to landfill","m2",5970,"TMAC",0.56999999999999995,{"$f":"G45*E45","v":3402.8999999999996},0.5,{"$f":"H45*I45","v":1701.4499999999998},{"$f":"+H45*(1-I45)","v":1701.4499999999998}]
[null,null,"RB-006 consolidate and relocate waste to landfill","m2",63291.6,"TMAC",0.56999999999999995,36076.212,0.5,18038.106,18038.106]
[null,"Water StorageTank","DM-005 dismantle and haul to Q3 landfill","ea",1,"TMAC",100000,100000,0.5,50000,50000]
[null,null,"Madrid North Water Storage Tank - cleanout & disconnect piping","ea",1,"TMAC",{"$f":"1190+475","v":1665},{"$f":"G48*E48","v":1665},0.5,{"$f":"H48*I48","v":832.5},{"$f":"+H48*(1-I48)","v":832.5}]
[null,null,"Madrid North Water Storage Tank - dismantle tank","ea",1,"TMAC",100000,100000,0.5,50000,50000]
[null,null,"Madrid North Water Storage Tank - prepare, containerize and haul tank pieces to landfill","m3",3,"TMAC",{"$f":"10.23+10.23+4.92","v":25.380000000000003},76.140000000000015,0.5,38.070000000000007,38.070000000000007]
[null,null,"Madrid South Water Storage Tank - cleanout & disconnect piping","ea",1,"TMAC",{"$f":"1190+475","v":1665},{"$f":"G51*E51","v":1665},0.5,{"$f":"H51*I51","v":832.5},{"$f":"+H51*(1-I51)","v":832.5}]
[null,null,"Madrid South Water Storage Tank - dismantle tank","ea",1,"TMAC",100000,100000,0.5,50000,50000]
[null,null,"Madrid South Water Storage Tank - prepare, containerize and haul tank pieces to landfill","m3",3,"TMAC",{"$f":"10.23+10.23+3.26","v":23.72},71.16,0.5,35.58,35.58]
[null,null,"MN-013 recover cover soil from containment","m3",0,"TMAC",2.75,{"$f":"G54*E54","v":0},0.5,0,{"$f":"+H54*(1-I54)","v":0},null,null,"Clarification provided by SRK work under Chemicals (259.2 reduced to 0)"]
[null,null,"MN-013 cut liner/load and transport to landfill","m3",{"$f":"2.4+1.3","v":3.7},"TMAC",{"$f":"10.23+14.08","v":24.310000000000002},{"$f":"G55*E55","v":89.947000000000017},0.5,44.973500000000008,44.973500000000008]
[null,"Compressor Building","MN-008 dismantle and haul to Q3 landfill","m3",62.5,"TMAC",{"$f":"13.12+4.92+10.23","v":28.27},{"$f":"G56*E56","v":1766.875},0.5,{"$f":"H56*I56","v":883.4375},883.4375,null,"added cost to containerize and haul to landfill"]
[null,null,"MN-008 includes disconnection and off-site transfer of plant","each",2,"TMAC",{"$f":"680+785","v":1465},{"$f":"G57*E57","v":2930},0.5,{"$f":"H57*I57","v":1465},{"$f":"+H57*(1-I57)","v":1465}]
[null,null,"MN-008 haul units to Roberts Bay for off-site transfer","m3",{"$f":"40+6","v":46},"TMAC",{"$f":"5.02+10.23","v":15.25},{"$f":"G58*E58","v":701.5},0.5,{"$f":"H58*I58","v":350.75},350.75,null,"added cost to containerize the units for transfer"]
[null,null,"MS-008 dismantle and haul to Q3 landfill","m3",62.5,"TMAC",{"$f":"13.12+10.23","v":23.35},{"$f":"G59*E59","v":1459.375},0.5,{"$f":"H59*I59","v":729.6875},{"$f":"+H59*(1-I59)","v":729.6875},null,"added containizeation cost to cover laoding and haulage"]
[null,null,"MS-008 includes disconnection and off-site transfer of plant","each",2,"TMAC",{"$f":"785+680","v":1465},{"$f":"G60*E60","v":2930},0.5,{"$f":"H60*I60","v":1465},1465]
[null,null,"MS-008 haul units to Roberts Bay for off-site transfer","m3",40,"TMAC",{"$f":"5.02+10.23","v":15.25},610,0.5,305,305]
[null,"Power Plant/Generator","DM-011 Decommission and dismantle","each",8,"TMAC",{"$f":"785+1370","v":2155},17240,0.5,8620,8620]
[null,null,"DM-011 dismantle stacks and prep for off-site disposal","m",40,"TMAC",{"$f":"627.24+136.3","v":763.54},{"$f":"G63*E63","v":30541.599999999999},0.5,{"$f":"H63*I63","v":15270.8},{"$f":"+H63*(1-I63)","v":15270.8}]
[null,null,"DM-011 Haulage to staging point for off-site shipping","m3",{"$f":"264.8+166","v":430.8},"TMAC",2.2999999999999998,{"$f":"G64*E64","v":990.83999999999992},0.5,{"$f":"H64*I64","v":495.41999999999996},{"$f":"+H64*(1-I64)","v":495.41999999999996},null,"166 in chemical of TMAC"]
[null,null,"DM-011 Load, haul and dispose of waste","m3",90,"TMAC",{"$f":"10.23+4.92","v":15.15},{"$f":"G65*E65","v":1363.5},0.5,{"$f":"H65*I65","v":681.75},{"$f":"+H65*(1-I65)","v":681.75}]
[null,null,"Madrid North Power Plant MN-009 stack haulage to landfill","m3",166,"TMAC",4.92,{"$f":"G66*E66","v":816.72},0.5,{"$f":"H66*I66","v":408.36},{"$f":"+H66*(1-I66)","v":408.36}]
[null,null,"Madrid North Diesel Generator MN-009 disconnection","each",1,"TMAC",{"$f":"785+1370","v":2155},2155,0.5,1077.5,1077.5]
[null,null,"Madrid North Diesel generator haulage to Roberts Bay","m3",50,"TMAC",{"$f":"5.02+10.23","v":15.25},762.5,0.5,381.25,381.25]
[null,null,"Madrid North Diesel generator tent demolition and haulage to landfill","m3",50,"TMAC",{"$f":"13.12+10.23","v":23.35},{"$f":"G69*E69","v":1167.5},0.5,{"$f":"H69*I69","v":583.75},{"$f":"+H69*(1-I69)","v":583.75},null,"added containizeation cost to cover laoding and haulage"]
[null,null,"Madrid North dismantle stacks and prep for offsite transfer","m",40,"TMAC",{"$f":"627.24+136.3","v":763.54},30541.599999999999,0.5,15270.8,15270.8]
[null,null,"Madrid North Power Plan disconnection","each",4,"TMAC",785,3140,0.5,1570,1570]
[null,null,"Madrid North Power Plant Demo","m3",2375,"TMAC",13.32,{"$f":"G72*E72","v":31635},0.5,{"$f":"H72*I72","v":15817.5},{"$f":"+H72*(1-I72)","v":15817.5}]
[null,null,"Madrid North Power Plant debris clean up","m2",950,"TMAC",0.37,351.5,0.5,175.75,175.75]
[null,null,"Madrid North Power Plan waste debris load and haul to landfill","m3",740,"TMAC",{"$f":"13.12+10.23","v":23.35},17279,0.5,8639.5,8639.5,null,"Added demolition cost to cover demo and haulage"]
[null,null,"Madrid South Diesel Generator disconnection","each",1,"TMAC",785,{"$f":"G75*E75","v":785},0.5,{"$f":"H75*I75","v":392.5},{"$f":"+H75*(1-I75)","v":392.5}]
[null,null,"Madrid South Demolition of tent and haulage to landfill","m3",50,"TMAC",{"$f":"13.12+10.23","v":23.35},1167.5,0.5,583.75,583.75,null,"Added demolition cost to cover demo and haulage"]
[null,"Sewage Treatment Plant","DM-017 Decontaminate, decommission and dismantle","each",9,"TMAC",{"$f":"667.63+659.46+1344.8","v":2671.8900000000003},24047.010000000002,0.5,12023.505000000001,12023.505000000001,null,"Not clear why TMAC dropped the costs for dismantling and system flushing removed.  Still in the ACI estimate"]
[null,null,"DM-017 Haulage to staging point for off-site shipping","m3",671.4,"TMAC",2.2999999999999998,1544.2199999999998,0.5,772.1099999999999,772.1099999999999]
[null,null,"DM-017 Load, haul and dispose of waste to landfill","m3",24,"TMAC",{"$f":"10.23+4.92","v":15.15},{"$f":"G79*E79","v":363.6},0.5,{"$f":"H79*I79","v":181.8},{"$f":"+H79*(1-I79)","v":181.8},null,"added haulage to landfill"]
[null,"Vent Raises","DM-030, DM-033 & DM-034 Remove heating and ventilation system","each",{"$f":"4+2+2","v":8},"TMAC",680,{"$f":"G80*E80","v":5440},0.5,{"$f":"H80*I80","v":2720},{"$f":"+H80*(1-I80)","v":2720}]
[null,null,"DM-030, DM-033 & DM-034 Prepare heating and ventilation system for off-site disposal","each",3,"TMAC",1370,4110,0.5,2055,2055]
[null,null,"DM-030 Haul enviro-tank and HVAC equipmen tfor off-site disposal","m3",{"$f":"33.2*6","v":199.20000000000002},"TMAC",4.7,936.24000000000012,0.5,468.12000000000006,468.12000000000006]
[null,null,"DM-030, DM-033 & DM-034 Consolidate and dispose of waste at landfill","m3",{"$f":"11.1","v":11.1},"TMAC",{"$f":"10.23+4.7","v":14.93},165.72299999999998,0.5,82.861499999999992,82.861499999999992]
[null,null,"Madrid North Vent Raise decommission and dismantle","ea",4,"TMAC",680,{"$f":"G84*E84","v":2720},0.5,{"$f":"H84*I84","v":1360},{"$f":"+H84*(1-I84)","v":1360}]
[null,null,"Madrid North HVAC Unit preparation for shipping","ea",1,"TMAC",1370,1370,0.5,685,685,null,null,"reduce 4 to 1 per SRK update"]
[null,null,"Madrid North Haulage of HVAC units","m3",40,"TMAC",5.0199999999999996,200.79999999999998,0.5,100.39999999999999,100.39999999999999]
[null,null,"Madrid South Haulage of HVAC units","m3",80,"TMAC",6.29,503.2,0.5,251.6,251.6]
[null,null,"Madrid South Heating Unit preparation for shipping","ea",1,"TMAC",1370,{"$f":"G88*E88","v":1370},0.5,{"$f":"H88*I88","v":685},{"$f":"+H88*(1-I88)","v":685},null,null,"reduce 8 to 1 per SRK update"]
[null,null,"Madrid South Vent Raise and Air Heating Facility Decom/Dismantle","ea",{"$f":"4+4","v":8},"TMAC",680,{"$f":"G89*E89","v":5440},0.5,{"$f":"H89*I89","v":2720},{"$f":"+H89*(1-I89)","v":2720}]
[null,"Mixing Facility & CaCl Laydown Area","MN-014 & MN-015 dismantle and haul to Q3 landfill","m3",5,"TMAC",{"$f":"13.12+10.23+4.92","v":28.270000000000003},{"$f":"G90*E90","v":141.35000000000002},0.5,{"$f":"H90*I90","v":70.675000000000011},70.675000000000011]
[null,null,"MS-018 & MS-019 demolition and haul to landfill","m3",5,"TMAC",{"$f":"13.12+10.23+3.26","v":26.61},{"$f":"G91*E91","v":133.05000000000001},0.5,{"$f":"H91*I91","v":66.525000000000006},{"$f":"+H91*(1-I91)","v":66.525000000000006}]
[null,"Doris Swick Shop","DM-019 Demolition","m3",859.2,"TMAC",13.12,{"$f":"G92*E92","v":11272.704},0.5,{"$f":"H92*I92","v":5636.3519999999999},{"$f":"+H92*(1-I92)","v":5636.3519999999999}]
[null,null,"DM-019 Collect debris","m2",230,"TMAC",0.37,85.1,0.5,42.55,42.55]
[null,null,"DM-019 Load and haul to landfill","m3",18.3,"TMAC",{"$f":"10.23+4.92","v":15.15},277.245,0.5,138.6225,138.6225]
[null,"Muster Station","DM-008 Demolition","m3",{"$f":"227.3+27.3","v":254.60000000000002},"TMAC",13.01,3312.3460000000005,0.5,1656.1730000000002,1656.1730000000002]
[null,null,"DM-008 Load and haul to landfill","m3",48.2,"TMAC",{"$f":"10.23+4.92","v":15.15},{"$f":"G96*E96","v":730.23},0.5,{"$f":"H96*I96","v":365.11500000000001},{"$f":"+H96*(1-I96)","v":365.11500000000001},null,"haulage rate added"]
[null,"Doris Windy AWR Explosives Storage Facility","DW-010 collect surface debris","m2",2805,"TMAC",0.56999999999999995,1598.85,0.5,799.42499999999995,799.42499999999995]
[null,null,"DW-010 demolition, load and haul to landfill","m3",5,"TMAC",{"$f":"10.23+3.41","v":13.64},68.2,0.5,{"$f":"H98*I98","v":34.1},34.1]
[null,"Warehouse, Shops and Other","RB-004 and DM-022 Remove heating and ventilation system","each",3,"TMAC",680,{"$f":"G99*E99","v":2040},0.5,{"$f":"H99*I99","v":1020},{"$f":"+H99*(1-I99)","v":1020},null,null,"reduce 10 to 3 per SRK update"]
[null,null,"RB-004 Prep HVAC for off-site disposal","each",1,"TMAC",1344.8,1344.8,0.5,672.4,672.4,null,"Not clear why this work was removed from update"]
[null,null,"RB-004 & DM-022 demolition","m3",{"$f":"2402.4+283.2+460.3+2281.6","v":5427.5},"TMAC",13.12,71208.800000000003,0.5,35604.400000000001,35604.400000000001]
[null,null,"RB-004 Haul HVAC equipmentfor off-site disposal","m3",{"$f":"33.2*7","v":232.40000000000003},"TMAC",2.2999999999999998,{"$f":"G102*E102","v":534.52},0.5,{"$f":"H102*I102","v":267.26},{"$f":"+H102*(1-I102)","v":267.26},null,"Not clear why this work was removed from update"]
[null,null,"RB-004 & DM-022 Consolidate and dispose of waste at landfill","m3",{"$f":"780+550","v":1330},"TMAC",{"$f":"10.23+4.92","v":15.15},20149.5,0.5,10074.75,10074.75,null,"add haulage rate."]
[null,null,"Madrid North MN-007 Mine Equipment Tent demo ","m3",2250,"TMAC",{"$f":"13.12","v":13.12},{"$f":"G104*E104","v":29520},0.5,{"$f":"H104*I104","v":14760},{"$f":"+H104*(1-I104)","v":14760}]
[null,null,"Madrid North MN-007 Mine Equipment Tent debris haul to landfill","m3",225,"TMAC",{"$f":"10.23+4.92","v":15.15},{"$f":"G105*E105","v":3408.75},0.5,{"$f":"H105*I105","v":1704.375},{"$f":"+H105*(1-I105)","v":1704.375},null,"Not in the estimate but should have been"]
[null,null,"Madrid North MN-007 equipment disconnection","ea",2,"TMAC",680,{"$f":"G106*E106","v":1360},0.5,{"$f":"H106*I106","v":680},{"$f":"+H106*(1-I106)","v":680}]
[null,null,"Madrid North MN-007 Mine Equipment Shop demo ","m3",0,"TMAC",{"$f":"13.12","v":13.12},0,0.5,0,0,null,null,"volume is included in line 104 according to SRK reduce from 1125 to 0"]
[null,null,"Madrid North MN-007 Mine Equipment Shop debris haul to landfill","m3",485,"TMAC",{"$f":"10.23+4.92","v":15.15},{"$f":"G108*E108","v":7347.75},0.5,{"$f":"H108*I108","v":3673.875},{"$f":"+H108*(1-I108)","v":3673.875}]
[null,null,"Madrid South MS-004 Mine Equipment Tent demo ","m3",2250,"TMAC",{"$f":"13.12","v":13.12},{"$f":"G109*E109","v":29520},0.5,{"$f":"H109*I109","v":14760},{"$f":"+H109*(1-I109)","v":14760},null,"Not in the estimate but should have been"]
[null,null,"Madrid South MS-004 Mine Equipment disconnections","ea",4,"TMAC",680,2720,0.5,1360,1360]
[null,null,"Madrid South MS-004 Mine Equipment Tent debris haul to landfil","m3",225,"TMAC",{"$f":"10.23+3.26","v":13.49},3035.25,0.5,1517.625,1517.625,null,"Not in the estimate but should have been"]
[null,"Core Shack/Warehouse","DM-024 Demolition","m3",3610,"TMAC",13.12,{"$f":"G112*E112","v":47363.199999999997},0.5,{"$f":"H112*I112","v":23681.599999999999},{"$f":"+H112*(1-I112)","v":23681.599999999999}]
[null,null,"DM-024 Load Debris","m3",350,"TMAC",{"$f":"10.23","v":10.23},3580.5,0.5,1790.25,1790.25]
[null,null,"Load and haul core boxes","m3",3300,"TMAC",{"$f":"10.23+3.26","v":13.49},{"$f":"G114*E114","v":44517},0.5,{"$f":"H114*I114","v":22258.5},{"$f":"+H114*(1-I114)","v":22258.5},null,null,"increased from 1665 to 3300 per SRK Line 188 set to 0"]
[null,null,"DM-024 haul debris and containers to landfill for disposal","m3",350,"TMAC",4.92,1722,0.5,861,861]
[null,"Underground Wash Bay","DM-023 Demolition of tent structure","m3",776.9,"TMAC",13.12,10192.928,0.5,5096.4639999999999,5096.4639999999999]
[null,null,"DM-023 Load and haul to landfill","m3",13.5,"TMAC",{"$f":"10.23+4.92","v":15.15},204.52500000000001,0.5,102.2625,102.2625]
[null,"Fuel tanks","Roberts Bay RB-013, RB-002, RB-003 & DM-020 decommissioning and dismantling","ea",9,"TMAC",{"$f":"100000","v":100000},900000,0.5,450000,450000]
[null,null,"Roberts Bay Tank Farm - cutting tanks and haul to landfill","m3",0,"TMAC",{"$f":"10.23+5.99","v":16.22},{"$f":"G119*E119","v":0},0.5,{"$f":"H119*I119","v":0},{"$f":"+H119*(1-I119)","v":0},null,null,"volume is included in line 120 reduce from 129 to 0"]
[null,null,"Roberts Bay Tank Farm - Waste Consolidation and transfer to landfill","m3",435.5,"TMAC",{"$f":"10.23+5.99","v":16.22},{"$f":"G120*E120","v":7063.8099999999995},0.5,{"$f":"H120*I120","v":3531.9049999999997},{"$f":"+H120*(1-I120)","v":3531.9049999999997},null,null,"Clarification from SRK that 435.5 includes 129 for cutting"]
[null,null,"Doris Tank Farm DM-020 decommissioning and dismantling","ea",5,"TMAC",75000,{"$f":"G121*E121","v":375000},0.5,{"$f":"H121*I121","v":187500},{"$f":"+H121*(1-I121)","v":187500}]
[null,null,"Doris Mine Tank Farm - cutting tanks and haul to landfill","m3",25,"TMAC",{"$f":"10.23+4.7","v":14.93},{"$f":"G122*E122","v":373.25},0.5,186.625,186.625]
[null,null,"Doris Mine Tank Farm - Waste Consolidation and transfer to landfill","m3",{"$f":"85","v":85},"TMAC",{"$f":"10.23+4.7","v":14.93},{"$f":"G123*E123","v":1269.05},0.5,634.52499999999998,634.52499999999998]
[null,null,"Madrid North Tank Farm MN-011 decommissioning and dismantling","ea",3,"TMAC",75000,{"$f":"G124*E124","v":225000},0.5,{"$f":"H124*I124","v":112500},{"$f":"+H124*(1-I124)","v":112500}]
[null,null,"Madrid North Tank Farm - cutting tanks and haul to landfill","m3",20,"TMAC",{"$f":"10.23+4.92","v":15.15},{"$f":"G125*E125","v":303},0.5,151.5,151.5]
[null,null,"Madrid North Tank Farm - Waste Consolidation and transfer to landfill","m3",35,"TMAC",{"$f":"10.23+4.92","v":15.15},{"$f":"G126*E126","v":530.25},0.5,265.125,265.125]
[null,null,"Madrid South Tank Farm MS-017 decommissioning and dismantling","ea",1,"TMAC",75000,{"$f":"G127*E127","v":75000},0.5,37500,37500]
[null,null,"Madrid South Tank Farm - cutting tanks and haul to landfill","m3",1,"TMAC",{"$f":"10.23+3.26","v":13.49},{"$f":"G128*E128","v":13.49},0.5,6.7450000000000001,6.7450000000000001]
[null,null,"Madrid South Tank Farm - Waste Consolidation and transfer to landfill","m3",4,"TMAC",{"$f":"10.23+3.26","v":13.49},{"$f":"G129*E129","v":53.96},0.5,26.98,26.98]
[null,null,"Patch Lake tank farm - sump removal","each",1,"TMAC",7190,{"$f":"G130*E130","v":7190},0.5,{"$f":"H130*I130","v":3595},{"$f":"+H130*(1-I130)","v":3595}]
[null,null,"Windy Tank Farm Haul reusable material to Doris and unload containers","m3",11,"TMAC",{"$f":"2.77+34.08","v":36.85},{"$f":"G131*E131","v":405.35},0.5,{"$f":"H131*I131","v":202.67500000000001},{"$f":"+H131*(1-I131)","v":202.67500000000001}]
[null,null,"Windy Tank Farm load debris into seacans and transport to landfill","m3",12,"TMAC",{"$f":"10.23+3.26","v":13.49},161.88,0.5,80.94,80.94]
[null,"Fuel Containment areas","RB-013, RB-002, RB-003 & DM-020 excavation of cover soil","m3",0,"TMAC",2.75,{"$f":"G133*E133","v":0},0.5,0,0,null,null,"double counted already in Chemicals tab reduce from 17334 to 0"]
[null,"Fuel tank piping and containment structure","RB-013, RB-002, RB-003 & DM-020 includes load and transport to landfill","m3",0,"TMAC",{"$f":"10.23+14.08","v":24.310000000000002},{"$f":"G134*E134","v":0},0.5,0,0,null,null,"double count already in line 120 reduce from 435.5 to 0"]
[null,"Backup Generator","DM-002 Decommission","each",4,"TMAC",680,{"$f":"G135*E135","v":2720},0.5,1360,1360,null,null,0]
[null,null,"DM-002 disconnect generator and prep for off-site removal","each",2,"TMAC",785,1570,0.5,785,785]
[null,null,"DM-002 demolition","m3",1296.5999999999999,"TMAC",{"$f":"13.12","v":13.12},17011.391999999996,0.5,{"$f":"H137*I137","v":8505.6959999999981},{"$f":"+H137*(1-I137)","v":8505.6959999999981},null,"added cost to containerize and haul to landfill","Double count on load and haulage so rate reduced to demo only"]
[null,null,"DM-002 Haulage to laydown or landfill","m3",{"$f":"0.1*E137","v":129.66},"TMAC",4.7,609.40200000000004,0.5,304.70100000000002,304.70100000000002,null,null,"amended volume to 10% of demolition volume"]
[null,null,"DM-002 Consolidate and dispose of waste at landfill","m3",{"$f":"0.05*E137","v":64.83},"TMAC",{"$f":"10.23+4.7","v":14.93},967.91189999999995,0.5,483.95594999999997,483.95594999999997,null,"added haulage cost","amended volume to 5% of demolition volume"]
[]
[null,"Fire Protection pumping station",null,"m",null,"brs1h",{"$f":"IF(ISNA(F141),0,INDEX(IF(UPPER(RIGHT(F141,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F141,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F141,LEN(F141)-1)),CostCode,0)))","v":65},0,0.5,0,0]
[null,"Fire Water Storage Tank","Doris Fire Water Storage Tank pad regrade (DM-005)","m2",75,"TMAC",4.7,352.5,0.5,176.25,176.25]
[null,null,"Doris Fire Water Storage Tank (DM-005) decom equipment elec/mech","each",3,"TMAC",1330,3990,0.5,{"$f":"H143*I143","v":1995},{"$f":"+H143*(1-I143)","v":1995}]
[null,null,"Remove insulation","each",1,"TMAC",750,{"$f":"G144*E144","v":750},0.5,{"$f":"H144*I144","v":375},{"$f":"+H144*(1-I144)","v":375}]
[null,null,"Doris Fire Water Storage Tank (DM-005) disconnect pumps and pipe","each",1,"TMAC",1370,1370,0.5,685,685]
[null,null,"Doris Fire Water Storage Tank (DM-005) dismantle tank","LS",0,"TMAC",{"$f":"100000","v":100000},{"$f":"G146*E146","v":0},0.5,{"$f":"H146*I146","v":0},{"$f":"+H146*(1-I146)","v":0},null,null,"Double count reduce from 1 to 0"]
[null,null,"Doris Fire Water Storage Tank demo","m3",2,"TMAC",{"$f":"10.23","v":10.23},20.46,0.5,10.23,10.23]
[null,null,"Doris Fire Water Storage Tank haul to landfill","m3",2,"TMAC",4.92,9.84,0.5,4.92,4.92]
[null,"Freshwater intake","DM-026 Remove water line","lm",25,"TMAC",11.08,277,0.5,138.5,138.5]
[null,null,"DM-026 Decommission Structure","each",2,"TMAC",1330,{"$f":"G150*E150","v":2660},0.5,{"$f":"H150*I150","v":1330},{"$f":"+H150*(1-I150)","v":1330}]
[null,null,"DM-026 Disconnect equipment/clean and run O/W separator","each",1,"TMAC",{"$f":"94.44+24.05+31.89","v":150.38},{"$f":"G151*E151","v":150.38},0.5,{"$f":"H151*I151","v":75.19},{"$f":"+H151*(1-I151)","v":75.19}]
[null,null,"DM-026 Prep Equipment for off-site removal","each",2,"TMAC",1370,2740,0.5,1370,1370]
[null,null,"DM-026 haul containers and debris to landfill","m3",{"$f":"66.4+21.3","v":87.7},"TMAC",4.7,{"$f":"G153*E153","v":412.19000000000005},0.5,{"$f":"H153*I153","v":206.09500000000003},{"$f":"+H153*(1-I153)","v":206.09500000000003}]
[null,null,"DM-026 Consolidate and load debris","m3",{"$f":"66.4+21.3","v":87.7},"TMAC",{"$f":"10.23","v":10.23},897.17100000000005,0.5,448.58550000000002,448.58550000000002]
[null,null,"Windy Potable Water Supply Decommission and Dismantle","each",1,"TMAC",{"$f":"1330+535","v":1865},{"$f":"G155*E155","v":1865},0.5,{"$f":"H155*I155","v":932.5},{"$f":"+H155*(1-I155)","v":932.5}]
[null,null,"Windy Potable Water Supply unit prep","m3",4,"TMAC",805,{"$f":"G156*E156","v":3220},0.5,{"$f":"H156*I156","v":1610},{"$f":"+H156*(1-I156)","v":1610}]
[null,null,"Windy Potable Water Supply relocate","m3",35,"TMAC",{"$f":"10.23+2.77","v":13},{"$f":"G157*E157","v":455},0.5,{"$f":"H157*I157","v":227.5},{"$f":"+H157*(1-I157)","v":227.5},null,"added containerization/loading cost"]
[null,"Roberts Bay Waste Management Facility","RB-005 Prep containers for off-site disposal","each",11,"TMAC",1370,15070,0.5,7535,7535]
[null,null,"RB-005 Dismantle facility","each",2,"TMAC",535,{"$f":"G159*E159","v":1070},0.5,{"$f":"H159*I159","v":535},{"$f":"+H159*(1-I159)","v":535}]
[null,null,"RB-005 demolition","m3",321.60000000000002,"TMAC",13.12,4219.3919999999998,0.5,2109.6959999999999,2109.6959999999999]
[null,null,"RB-005 Consolidate and dispose of waste at landfill","m3",{"$f":"189.8","v":189.8},"TMAC",{"$f":"10.23+5.23","v":15.46},{"$f":"G161*E161","v":2934.3080000000004},0.5,{"$f":"H161*I161","v":1467.1540000000002},{"$f":"+H161*(1-I161)","v":1467.1540000000002}]
[null,"Communications Towers","RB-009 & DM-004 Decommission and dismantle","each",{"$f":"1+2","v":3},"TMAC",{"$f":"679.52+15749.71","v":16429.23},{"$f":"G162*E162","v":49287.69},0.5,{"$f":"H162*I162","v":24643.845000000001},{"$f":"+H162*(1-I162)","v":24643.845000000001},null,"includes decon and dismantle"]
[null,null,"RB-009 & DM-004 Remove equipment","each",{"$f":"4+12","v":16},"TMAC",375,{"$f":"G163*E163","v":6000},0.5,{"$f":"H163*I163","v":3000},{"$f":"+H163*(1-I163)","v":3000},null,"TMAC update does not include for 4 units at RB-009 so added back in"]
[null,null,"DM-004 Relocate tower equipment for off-site transfer","m3",37.200000000000003,"TMAC",2.2999999999999998,{"$f":"G164*E164","v":85.56},0.5,{"$f":"H164*I164","v":42.78},{"$f":"+H164*(1-I164)","v":42.78}]
[null,null,"DM-004 Remove equipment from Doris Mt.","m3",9,"TMAC",2509.33,{"$f":"G165*E165","v":22583.97},0.5,{"$f":"H165*I165","v":11291.985000000001},{"$f":"+H165*(1-I165)","v":11291.985000000001}]
[null,null,"DM-004 demolish housing shack","m3",24,"TMAC",13.12,314.88,0.5,157.44,157.44]
[null,null,"DM-004 remove fibre optics and elec.","m",12,"TMAC",680,{"$f":"G167*E167","v":8160},0.5,{"$f":"H167*I167","v":4080},{"$f":"+H167*(1-I167)","v":4080}]
[null,null,"RB-009 & DM-004 Load and haul for disposal","m3",{"$f":"23.9+9","v":32.9},"TMAC",{"$f":"10.23+4.7","v":14.93},491.19699999999995,0.5,245.59849999999997,245.59849999999997]
[null,"Reagent Pad Exploration Drilling Support Shop & Laydown Pads","RP-004 Prep containers for off-site disposal","each",13,"TMAC",1370,17810,0.5,8905,8905]
[null,null,"RP-004 Decommission facility","each",2,"TMAC",680,1360,0.5,680,680]
[null,null,"RP-004 demolition","m3",708.7,"TMAC",{"$f":"13.12","v":13.12},9298.1440000000002,0.5,4649.0720000000001,4649.0720000000001,null,"Added cost for containerization and haulage to landfill","Double count on load and haulage so rate reduced to demo only"]
[null,null,"RP-004 load and haulage","m3",{"$f":"0.1*E171","v":70.87},"TMAC",{"$f":"10.23+5.23","v":15.46},{"$f":"G172*E172","v":1095.6502},0.5,{"$f":"H172*I172","v":547.82510000000002},{"$f":"+H172*(1-I172)","v":547.82510000000002},null,null,"Added task for loading and haulage = 10% of demo volume"]
[null,null,"RP-002 Consolidate Debris","m2",{"$f":"35245+25420","v":60665},"TMAC",0.37,22446.05,0.5,{"$f":"H173*I173","v":11223.025},{"$f":"+H173*(1-I173)","v":11223.025}]
[null,null,"RP-003 Remove Liner Cover Soil","m3",0,"TMAC",2.75,0,0.5,0,0,null,null,"Double count included in Chemicals reduce from 1390 to 0"]
[null,null,"RP-001, RP-002, RP-003 & RP-004 Load waste for disposal","m3",{"$f":"12.4+20+20+25.2","v":77.599999999999994},"TMAC",10.23,793.84799999999996,0.5,396.92399999999998,396.92399999999998]
[null,null,"RP-001, RP-002, RP-003 & RP-004 Haul and dispose of demo waste & containers to landfill","m3",{"$f":"12.4+483.7+25.2+20+20","v":561.29999999999995},"TMAC",5.23,2935.5990000000002,0.5,1467.7995000000001,1467.7995000000001]
[null,"Waste Management Area Landfarm, Batch Plant, and Burn Pan Area","WM-001 Treat Contaminated Water","LS",1,"TMAC",5000,5000,null,0,5000]
[null,null,"WM-001 Remove Cover Soil from Containment","m3",0,"TMAC",2.75,0,0.5,0,0,null,null,"Double count included in Chemicals reduce from 2591 to 0"]
[null,null,"WM-001 & WM-002 load and haul debris to landfill","m3",{"$f":"118.4+55.9","v":174.3},"TMAC",{"$f":"10.23+4.7","v":14.93},{"$f":"G179*E179","v":2602.299},0.5,{"$f":"H179*I179","v":1301.1495},{"$f":"+H179*(1-I179)","v":1301.1495}]
[null,null,"WM-002 Demolish Structure & collect debris","m3",3700,"TMAC",13.12,48544,0.5,24272,24272]
[null,null,"WM-003 Consolidate ash from burn pan","m3",0.1,"TMAC",765,{"$f":"G181*E181","v":76.5},0.5,{"$f":"H181*I181","v":38.25},{"$f":"+H181*(1-I181)","v":38.25}]
[null,null,"WM-003 Dismantle Burn Pan ","each",1,"TMAC",535,535,0.5,267.5,267.5]
[null,null,"WM-003 load and haul waste","m3",1,"TMAC",{"$f":"10.23+4.7","v":14.93},14.93,0.5,7.4649999999999999,7.4649999999999999]
[null,null,"Windy Waste Incinerator dismantling","each",1,"TMAC",535,535,0.5,267.5,267.5]
[null,null,"Windy Waste Incinerator load into containers","m3",7,"TMAC",{"$f":"805+2.77","v":807.77},5654.3899999999994,0.5,2827.1949999999997,2827.1949999999997]
[null,null,"Windy Waste incinerator - decommissioning mechanical ","each",1,"TMAC",1325,{"$f":"G186*E186","v":1325},0.5,{"$f":"H186*I186","v":662.5},{"$f":"+H186*(1-I186)","v":662.5}]
[null,null,"Windy Waste Incinerator consolidate waste and transfer to landfill","m3",1,"TMAC",{"$f":"763.55+3.26","v":766.81},{"$f":"G187*E187","v":766.81},0.5,{"$f":"H187*I187","v":383.40499999999997},{"$f":"+H187*(1-I187)","v":383.40499999999997}]
[null,"Doris/Windy AWR and Waste Management  Core Storage Areas","DW-008 Load and haul core boxes/containers to Q3 landfill","m3",0,"TMAC",{"$f":"10.23+3.26","v":13.49},{"$f":"G188*E188","v":0},0.5,{"$f":"H188*I188","v":0},{"$f":"+H188*(1-I188)","v":0},null,null,"Reduce from 3300 to 0 as already in Line 114"]
[null,null,"Relocate crusher and hopper","each",2,"TMAC",3300,{"$f":"G189*E189","v":6600},0.5,{"$f":"H189*I189","v":3300},{"$f":"+H189*(1-I189)","v":3300}]
[null,null,"Load and haul equipment to Roberts Bay","m3",35,"TMAC",{"$f":"10.23+4.04","v":14.27},499.45,0.5,249.72499999999999,249.72499999999999,null,"added a high unit rate for haulage and loading cost"]
[null,null,"DW-008 Collect Debris","m2",{"$f":"10000+10000","v":20000},"TMAC",0.18,3600,0.5,1800,1800]
[null,null,"DW-008 laod and haul waste to Boston Landfill","m3",{"$f":"6+6","v":12},"TMAC",{"$f":"10.23+3.26","v":13.49},161.88,0.5,80.94,80.94]
[null,"Madrid Boston & Doris Windry AWR Turbine Pad ","Waste removal from Pads 1 to 6 and ship to landfill","m3",{"$f":"580*6","v":3480},"TMAC",3.21,11170.8,0.5,5585.4,5585.4]
[null,null,"Collect debris from Pads 1 to 6","m2",{"$f":"5080*6","v":30480},"TMAC",0.56999999999999995,{"$f":"G194*E194","v":17373.599999999999},0.5,{"$f":"H194*I194","v":8686.7999999999993},{"$f":"+H194*(1-I194)","v":8686.7999999999993}]
[null,null,"Load and haul debris from Pads 1 to 6 to landfill","m3",{"$f":"580*6","v":3480},"TMAC",{"$f":"10.23+3.26","v":13.49},46945.200000000004,0.5,23472.600000000002,23472.600000000002,null,"added unit rate for haulage to landfill"]
[null,null,"Doris Windy AWR turbines dismantling","each",6,"TMAC",500000,3000000,0.5,1500000,1500000]
[null,null,"Doris Windy AWR turbines transport parts to Roberts Bay","each",6,"TMAC",15000,90000,0.5,45000,45000,null,"average the cost between the six turbines"]
[null,null,"Doris Windy demolition and containerization of sheds demo debris","m3",{"$f":"290*6","v":1740},"TMAC",{"$f":"13.12","v":13.12},{"$f":"G198*E198","v":22828.799999999999},0.5,{"$f":"H198*I198","v":11414.4},{"$f":"+H198*(1-I198)","v":11414.4},null,"added cost for containerization to demo cost","According to SRK no containerization will be required so rate reduces from $23.35 to 13.12"]
[null,null,"Doris Windy AWR turbine wiring removal (fibre optic and elec)","lm",{"$f":"11950+11950+3385+1695+405+4260","v":33645},"TMAC",14.04,{"$f":"G199*E199","v":472375.8},0.5,{"$f":"H199*I199","v":236187.9},{"$f":"+H199*(1-I199)","v":236187.9}]
[null,"Roberts Bay Jetty","RB-001 Remove mooring points ","LS",1,"TMAC",1200,1200,0.5,600,600]
[null,null,"RB-01 Remove rock fill and grade","m3",1220,"TMAC",2.75,3355,0.5,1677.5,1677.5]
[null,null,"RB-001 Remove mooring buoy","LS",1,"TMAC",2500,2500,0.5,1250,1250]
[null,"Roberts Bay Cargo Dock","RB-012 Remove rock fill, sheet piling and mooring points, and grade","LS",1,"TMAC",50000,{"$f":"G203*E203","v":50000},0.5,{"$f":"H203*I203","v":25000},{"$f":"+H203*(1-I203)","v":25000}]
[null,null,"RB-012 Remove rock fill and grade","m3",24870,"TMAC",2.75,68392.5,0.5,34196.25,34196.25,null,"TMAC has in Water Management"]
[null,null,"RB-012 Remove on-shore mooring points","LS",2,"TMAC",1200,{"$f":"G205*E205","v":2400},0.5,{"$f":"H205*I205","v":1200},{"$f":"+H205*(1-I205)","v":1200}]
[null,null,"Load and Haul waste from Cargo Dock demo","m3",110,"TMAC",{"$f":"10.23+5.99","v":16.22},1784.1999999999998,0.5,892.09999999999991,892.09999999999991]
[null,"All weather road clear span crossing","DW-004","m3",138,"TMAC",{"$f":"10.23+4.92","v":15.15},2090.7000000000003,0.5,1045.3500000000001,1045.3500000000001]
[null,"Waste on Secondary Road","SR-001 Waste clean up","m3",2170,"TMAC",4.17,{"$f":"G208*E208","v":9048.9},0.5,{"$f":"H208*I208","v":4524.45},4524.45]
[null,"Roberts Bay Pipeline Discharge System","PL-001 Decommission","each",11,"TMAC",680,{"$f":"G209*E209","v":7480},0.5,{"$f":"H209*I209","v":3740},{"$f":"+H209*(1-I209)","v":3740}]
[null,null,"PL-001 Dismantle","lm",5470,"TMAC",11.08,60607.6,0.5,30303.8,30303.8]
[null,null,"PL-001 load, haul and tip waste at Q3 landfill","m3",1160,"TMAC",{"$f":"10.23+5.99","v":16.22},18815.199999999997,0.5,9407.5999999999985,9407.5999999999985]
[null,null,"PL-001 remove rock cover ","m3",485,"TMAC",1.23,596.54999999999995,0.5,298.27499999999998,298.27499999999998]
[null,null,"Pl-001 Conduct Survey of submergered section","LS",1,"TMAC",50000,50000,0.5,25000,25000]
[null,"Pipleines Madrid ","PL002 Madrid North - haul debris to landfill","m3",3135,"TMAC",{"$f":"5.02+10.23","v":15.25},{"$f":"G214*E214","v":47808.75},0.5,{"$f":"H214*I214","v":23904.375},{"$f":"+H214*(1-I214)","v":23904.375},null,null,"volume corrected to 3135"]
[null,null,"MN - cut into pieces","lm",13395,"TMAC",11.08,{"$f":"G215*E215","v":148416.6},0.5,{"$f":"H215*I215","v":74208.3},{"$f":"+H215*(1-I215)","v":74208.3}]
[null,null,"Decom heat trace","each",25,"TMAC",680,{"$f":"G216*E216","v":17000},0.5,{"$f":"H216*I216","v":8500},{"$f":"+H216*(1-I216)","v":8500}]
[null,null,"PL-003 Madrid South","m3",3135,"TMAC",{"$f":"5.02+10.23","v":15.25},{"$f":"G217*E217","v":47808.75},0.5,{"$f":"H217*I217","v":23904.375},{"$f":"+H217*(1-I217)","v":23904.375}]
[null,null,"MS - cut into pieces","lm",14310,"TMAC",11.08,158554.79999999999,0.5,79277.399999999994,79277.399999999994]
[null,null,"Decom heat trace","each",25,"TMAC",680,17000,0.5,8500,8500]
[null,"Contact Water Berms Debris","Madrid North","m3",2,"TMAC",{"$f":"10.23+4.92","v":15.15},{"$f":"G220*E220","v":30.3},0.5,{"$f":"H220*I220","v":15.15},{"$f":"+H220*(1-I220)","v":15.15}]
[null,null,"Madrid South","m3",4,"TMAC",{"$f":"10.23+3.26","v":13.49},53.96,0.5,26.98,26.98]
[null,"Remove Doris Sewage Lines","DM-016 decontaminate","LS",1,"TMAC",667.63,{"$f":"G222*E222","v":667.63},0.5,{"$f":"H222*I222","v":333.815},333.815]
[null,null,"DM-016 disconnet electrical","each",1,"TMAC",680,{"$f":"G223*E223","v":680},0.5,{"$f":"H223*I223","v":340},{"$f":"+H223*(1-I223)","v":340}]
[null,null,"DM-016 decommission","each",2,"TMAC",680,{"$f":"G224*E224","v":1360},0.5,{"$f":"H224*I224","v":680},{"$f":"+H224*(1-I224)","v":680},null,null,"reduce from 9 to 2 to reflect SRK updated number rate reduced to reflect change in work task classification"]
[null,null,"DM-016 Dismantle pipeline","lm",1190,"TMAC",11.08,13185.2,0.5,6592.6,6592.6]
[null,null,"DM-016 load, haul and tip debris at Q3 landfill","m3",90.8,"TMAC",{"$f":"10.23+4.7","v":14.93},1355.644,0.5,677.822,677.822]
[null,"Water Pond Pump Assembles (sump pumps etc.)","DM-015, DM-018 & DM-026 dismantle sump pump assemblies","each",5,"TMAC",680,{"$f":"G227*E227","v":3400},0.5,{"$f":"H227*I227","v":1700},1700]
[null,"Water Pond Pump Waste Debris Management","DM-015, DM-018 & DM-026 dismantle sump pump assemblies","m3",{"$f":"70+35+2","v":107},"TMAC",{"$f":"10.23+4.7","v":14.93},1597.51,0.5,798.755,798.755]
[null,"Airstrip/Apron and Helipad","DM-007, DM-027 & DM-028 Demolition","m3",{"$f":"19.3+70.8+30.5","v":120.6},"TMAC",13.12,1582.2719999999999,0.5,791.13599999999997,791.13599999999997]
[null,null,"DM-007, DM-027 & DM-028 Collect Debris","m2",{"$f":"15500+67722+180.2","v":83402.2},"TMAC",0.37,30858.813999999998,0.5,15429.406999999999,15429.406999999999,null,null,"reduced 91500to 67722 for DM-027"]
[null,null,"DM-029 Decom elec/HVAC from tower","each",1,"TMAC",375,375,0.5,187.5,{"$f":"+H231*(1-I231)","v":187.5}]
[null,null,"DM-029 Airstrip lighting removal","each",70,{"$f":"NA()","v":{"$error":"#N/A"}},42.47,{"$f":"G232*E232","v":2972.9},0.5,{"$f":"H232*I232","v":1486.45},{"$f":"+H232*(1-I232)","v":1486.45}]
[null,null,"DM-007 Dismantle helipad","m3",15,"TMAC",4.18,{"$f":"G233*E233","v":62.699999999999996},0.5,{"$f":"H233*I233","v":31.349999999999998},{"$f":"+H233*(1-I233)","v":31.349999999999998}]
[null,null,"DM-027 Decommission Airstrip","each",2,"TMAC",325,650,0.5,325,325]
[null,null,"DM-028 Decommission and Dismantle apron equipment","each",5,"TMAC",1370,6850,0.5,3425,3425]
[null,null,"DM-007, DM-027 & DM-028 Load and Haul Debris to Landfill","m3",{"$f":"213.3+54.9+31.7+41+235","v":575.9},"TMAC",{"$f":"10.23+4.7","v":14.93},8598.1869999999999,0.5,4299.0934999999999,4299.0934999999999]
[null,"Windy Development Area","Windry Development debris clean up","m2",40000,"TMAC",0.37,{"$f":"G237*E237","v":14800},0.5,{"$f":"H237*I237","v":7400},{"$f":"+H237*(1-I237)","v":7400}]
[null,null,"Windy Disposal of demolition waste","m3",2580,"TMAC",{"$f":"10.23+3.41","v":13.64},{"$f":"G238*E238","v":35191.200000000004},0.5,{"$f":"H238*I238","v":17595.600000000002},{"$f":"+H238*(1-I238)","v":17595.600000000002},null,null,"No change in rate as SRK rate did not include for any loading costs"]
[null,"Emergency Shelters","Madrid North - decommission","each",2,"TMAC",679.52,{"$f":"G239*E239","v":1359.04},0.5,{"$f":"H239*I239","v":679.52},{"$f":"+H239*(1-I239)","v":679.52},null,null,"reduce from 5 to 2 per SRK clarification"]
[null,null,"Madrid North Demolish trailers","each",75,"TMAC",13.12,{"$f":"G240*E240","v":983.99999999999989},0.5,{"$f":"H240*I240","v":491.99999999999994},{"$f":"+H240*(1-I240)","v":491.99999999999994}]
[null,null,"Madrid North - containerize and haul to landfill for disposal","m3",4,"TMAC",{"$f":"13.12+10.23+4.92","v":28.270000000000003},113.08000000000001,0.5,56.540000000000006,56.540000000000006]
[null,null,"Madrid South - decommission","each",3,"TMAC",679.52,{"$f":"G242*E242","v":2038.56},0.5,{"$f":"H242*I242","v":1019.28},{"$f":"+H242*(1-I242)","v":1019.28}]
[null,null,"Madrid South Demolish trailers","m3",75,"TMAC",13.12,983.99999999999989,0.5,491.99999999999994,491.99999999999994]
[null,null,"Madrid South - containerize and haul to landfill for disposal","m3",4,"TMAC",{"$f":"13.12+10.23+3.26","v":26.61},106.44,0.5,53.22,53.22]
[null,"Roberts Bay Overburden Pile","Debris clean up","m2",14205,"TMAC",0.56999999999999995,{"$f":"G245*E245","v":8096.8499999999995},0.5,{"$f":"H245*I245","v":4048.4249999999997},{"$f":"+H245*(1-I245)","v":4048.4249999999997}]
[null,null,"Load and haul to landfill","m3",9,"TMAC",{"$f":"10.23+5.99","v":16.22},145.97999999999999,0.5,72.989999999999995,72.989999999999995]
[null,"Other ","Decommission elec and mech from WTP at TIA","LS",1,"TMAC",1370,1370,0.5,685,685,null,"Cost not carried in TMAC estimate for the WTP at the TIA"]
[null,null,"Remove WTP at TIA for treatment of water (incl demo, containerization and haul)","m3",150,"TMAC",{"$f":"11.23+10.95+1.86","v":24.04},3606,0.5,1803,1803]
[null,"LANDFILL FOR DEMOLITION WASTE"]
[null,"Prepare debris for capping","Q3-003 Main Landfill","m3",27081,"TMAC",3.27,{"$f":"G250*E250","v":88554.87},0.5,{"$f":"H250*I250","v":44277.434999999998},{"$f":"+H250*(1-I250)","v":44277.434999999998},null,"used regrading slope rate to account for slower production","There will still need to be grading work done prior to the placement of any NWG"]
[null,"Empty seacans","dump, grade, place and compact","m3",5280,"TMAC",86.72,{"$f":"G251*E251","v":457881.59999999998},0.5,{"$f":"H251*I251","v":228940.79999999999},{"$f":"+H251*(1-I251)","v":228940.79999999999}]
[null,"Place rock cover","Q3-003 Prepare Rock Cover for 300 mm cap","m3",8125,"TMAC",16.350000000000001,{"$f":"G252*E252","v":132843.75},0.5,{"$f":"H252*I252","v":66421.875},{"$f":"+H252*(1-I252)","v":66421.875}]
[null,"Generate rock cover","Q3-003 Prepare Rock Cover for 300 mm cap","m3",8125,"TMAC",24.76,{"$f":"G253*E253","v":201175},0.5,{"$f":"H253*I253","v":100587.5},{"$f":"+H253*(1-I253)","v":100587.5}]
[null,"Final grading of landfill cover","Q3-003 regrade cover","m2",27081,"TMAC",1.23,{"$f":"G254*E254","v":33309.629999999997},0.5,{"$f":"H254*I254","v":16654.814999999999},{"$f":"+H254*(1-I254)","v":16654.814999999999}]
[null,"Place soil cover",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},null,{"$f":"G255*E255","v":0},null,0,{"$f":"+H255*(1-I255)","v":0}]
[null,"Vegetate",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F256),0,INDEX(IF(UPPER(RIGHT(F256,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F256,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F256,LEN(F256)-1)),CostCode,0)))","v":0},{"$f":"G256*E256","v":0},null,0,0]
[null,"GRADE AND CONTOUR PADS & QUARRIES"]
[null,"Accomodation Complex","Windy Accommodation Camp Bldgs","m3",150,"TMAC",12.27,{"$f":"G258*E258","v":1840.5},0.5,920.25,920.25]
[null,"Process Facilities",null,"m2",null,"AE",8.4700000000000006,0,0.5,0,0]
[]
[null,"Landfarm",null,"m2",null,"AE",8.4700000000000006,0,0.5,0,0]
[null,"Q2 Sewage Discharge Area",null,"m3",552,"TMAC",16.350000000000001,{"$f":"G262*E262","v":9025.2000000000007},0.5,{"$f":"H262*I262","v":4512.6000000000004},{"$f":"+H262*(1-I262)","v":4512.6000000000004}]
[null,"Storage Pad",null,"m2",null,"AE",8.4700000000000006,0,0.5,0,0]
[null,"Power Plant",null,"m2",null,"AE",8.4700000000000006,{"$f":"G264*E264","v":0},0.5,{"$f":"H264*I264","v":0},{"$f":"+H264*(1-I264)","v":0}]
[null,"Communication Tower",null,"m2",null,"AE",8.4700000000000006,{"$f":"G265*E265","v":0},0.5,{"$f":"H265*I265","v":0},{"$f":"+H265*(1-I265)","v":0}]
[null,"U/G Heating Plant",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F266),0,INDEX(IF(UPPER(RIGHT(F266,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F266,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F266,LEN(F266)-1)),CostCode,0)))","v":0},0,0.5,0,0]
[null,"Reagent Equipment and Material Laydown",null,"m2",null,"DRl",{"$f":"IF(ISNA(F267),0,INDEX(IF(UPPER(RIGHT(F267,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F267,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F267,LEN(F267)-1)),CostCode,0)))","v":1.05},0,0.5,0,0]
[null,"Waste Management & Land Farm",null,"m3",null,"DRl",{"$f":"IF(ISNA(F268),0,INDEX(IF(UPPER(RIGHT(F268,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F268,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F268,LEN(F268)-1)),CostCode,0)))","v":1.05},0,0.5,0,0]
[null,"Fuel tanks on site for bulk fuel storage",null,"m3",null,"TMAC",2.75,0,0.5,0,0]
[null,"Vent Raise ","Doris Vent Raises DM-030, DM-033 & DM-034","m2",4150,"DSl",{"$f":"IF(ISNA(F270),0,INDEX(IF(UPPER(RIGHT(F270,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F270,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F270,LEN(F270)-1)),CostCode,0)))","v":0.95},3942.5,0.5,1971.25,1971.25]
[null,null,"Madrid North Vent Raises","m2",11435,"DSl",{"$f":"IF(ISNA(F271),0,INDEX(IF(UPPER(RIGHT(F271,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F271,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F271,LEN(F271)-1)),CostCode,0)))","v":0.95},{"$f":"G271*E271","v":10863.25},0.5,{"$f":"H271*I271","v":5431.625},{"$f":"+H271*(1-I271)","v":5431.625}]
[null,null,"Madrid South Vent Raises","m2",11435,"DSl",{"$f":"IF(ISNA(F272),0,INDEX(IF(UPPER(RIGHT(F272,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F272,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F272,LEN(F272)-1)),CostCode,0)))","v":0.95},10863.25,0.5,5431.625,5431.625,null,"Not in TMAC estimate so area from Madrid North used"]
[null,"Tailings Line","SR-001 Remove tailings line","m",5750,"TMAC",11.08,63710,0.5,31855,31855]
[null,null,"SR-001 cut pieces of tailings line","m3",2168,"TMAC",10.23,22178.639999999999,0.5,11089.32,11089.32,null,null,"amended to reflect SRK estimate"]
[null,null,"SR-001 Haulage of pipe to landfill","m3",{"$f":"0.1*E274","v":216.8},"TMAC",4.17,{"$f":"G275*E275","v":904.05600000000004},0.5,{"$f":"H275*I275","v":452.02800000000002},{"$f":"+H275*(1-I275)","v":452.02800000000002},null,"added cost for containerization","still required to relocate waste to landfill"]
[null,"WTP & Fresh Water Pumping Station",null,"m2",null,"AE",8.4700000000000006,0,0.5,0,0]
[null,"General Site Grading","RB-011 & DM-032","ha",{"$f":"(460000)/10000","v":46},"ACI",1230,56580,0.5,28290,28290,null,null,"reduce to 46 ha to remove double count (59.75 to 46)"]
[null,"Grade Quarries",null,"m2",null,"TMAC",1.23,{"$f":"G278*E278","v":0},0.5,{"$f":"H278*I278","v":0},{"$f":"+H278*(1-I278)","v":0}]
[null,"Other","Drill Holes at Windy Reclaim backfill","m3",100,"TMAC",16.350000000000001,1635.0000000000002,0.5,817.50000000000011,817.50000000000011]
[null,null,"Drill Holes at Windy cut tops of drill rods","each",889,"TMAC",13.11,{"$f":"G280*E280","v":11654.789999999999},0.5,{"$f":"H280*I280","v":5827.3949999999995},{"$f":"+H280*(1-I280)","v":5827.3949999999995}]
[null,null,"Windy Winter Road to Patch lake","m3",225,"TMAC",12.27,2760.75,0.5,1380.375,1380.375]
[null,null,"Patch Lake Roads and Trails","m3",120,"TMAC",12.27,{"$f":"G282*E282","v":1472.3999999999999},0.5,{"$f":"H282*I282","v":736.19999999999993},{"$f":"+H282*(1-I282)","v":736.19999999999993}]
[]
[]
[null,"REMOVE LINED CONTAINMENT STRUCTURES"]
[null,"Cut Liner as part of removal - load and haul carried above under Remove Bldgs","Madrid North Diversion Berm and Contact Water Pond Berm, CaCl Laydown Area plus Fuel Storage Area","m2",{"$f":"550+210+25+20","v":805},"TMAC",0.56999999999999995,{"$f":"G286*E286","v":458.84999999999997},null,{"$f":"H286*I286","v":0},{"$f":"+H286*(1-I286)","v":458.84999999999997},null,"Used 550 m2 for the diversion berm as cubic metres stated did  not make sense"]
[null,null,"Doris Run-off berm, Sedimentation/Pollution Control Pond, Reagent Pads Storage Areas, Waste Management Landfarm and Primary Vent Raise plus Tanks Farms at Doris and Roberts Bay","m2",{"$f":"300+14110+210+2485+1230+5500+8600+13200+9935","v":55570},"TMAC",0.56999999999999995,31674.899999999998,null,0,31674.899999999998,null,"Used 300 m2 for the diversion berm as cubic metres stated did  not make sense"]
[null,null,"Madrid South CaCl laydown plus Fuel Storage Area","m2",{"$f":"20+375","v":395},"TMAC",0.56999999999999995,225.14999999999998,null,0,225.14999999999998]
[null,"RECLAIM ROADS"]
[null,"Remove culverts","Q2 Quarry Overburden Pile culvert","lm",15,"TMAC",96.57,{"$f":"G290*E290","v":1448.55},0.5,724.27499999999998,724.27499999999998]
[null,null,"RB Fuel Storage Facility Road","lm",40,"TMAC",96.57,{"$f":"G291*E291","v":3862.7999999999997},0.5,{"$f":"H291*I291","v":1931.3999999999999},{"$f":"+H291*(1-I291)","v":1931.3999999999999}]
[null,null,"Madrid North TIA Road Culvert","lm",60,"TMAC",96.57,5794.2,0.5,2897.1,2897.1]
[null,null,"Cargo Dock Road Culvert","lm",30,"TMAC",96.57,2897.1,0.5,1448.55,1448.55]
[null,null,"Secondary Road Culvert","lm",20,"TMAC",96.57,1931.3999999999999,0.5,965.69999999999993,965.69999999999993]
[null,null,"Madrid North Vent Raise Road","lm",10,"TMAC",96.57,965.69999999999993,0.5,482.84999999999997,482.84999999999997]
[null,null,"Madrid North Site Access Culverts","lm",48,"TMAC",96.57,4635.3599999999997,0.5,2317.6799999999998,2317.6799999999998]
[null,null,"Madrid South AWR Culvert","lm",30,"TMAC",96.57,2897.1,0.5,1448.55,1448.55,null,"Assumes two culverts at 15m each"]
[null,null,"Doris Connector Vent Raise Culvert","lm",15,"TMAC",96.57,1448.55,0.5,724.27499999999998,724.27499999999998,null,"assumes a 15 m culvert"]
[null,null,"Madrid Boston AWR Crossings -10,-11,-13,-14,-17,-18,-20","lm",{"$f":"34+34+36+34+50+34+40","v":262},"TMAC",96.57,{"$f":"G299*E299","v":25301.339999999997},0.5,{"$f":"H299*I299","v":12650.669999999998},{"$f":"+H299*(1-I299)","v":12650.669999999998}]
[null,null,"Doris Central Vent Raise Culvert","lm",15,"TMAC",96.57,1448.55,0.5,724.27499999999998,724.27499999999998,null,"assumes a 15 m culvert"]
[null,"Remove bridges","CDR-003 Remove Bridge","each",1,"TMAC",50000,50000,0.5,25000,25000]
[null,null,"CDR-003 Cut Bridge Piles ","each",8,"TMAC",{"$f":"535","v":535},{"$f":"G302*E302","v":4280},0.5,{"$f":"H302*I302","v":2140},{"$f":"+H302*(1-I302)","v":2140}]
[null,null,"CDR-003 Regrade abutements","m2",225,"TMAC",3.27,{"$f":"G303*E303","v":735.75},0.5,{"$f":"H303*I303","v":367.875},{"$f":"+H303*(1-I303)","v":367.875}]
[null,null,"SR-002 Remove Bridge from Secondary Road","each",1,"TMAC",50000,50000,0.5,25000,25000]
[null,null,"Madrid Boston AWR Regrade Crossings MBR-22,-23,-24,-27,-30,-31 and -34","m2",{"$f":"225*7","v":1575},"TMAC",3.27,{"$f":"G305*E305","v":5150.25},0.5,{"$f":"H305*I305","v":2575.125},{"$f":"+H305*(1-I305)","v":2575.125}]
[null,null,"MNT-003 Madrid North to TIA Regrade bridge abutment","m2",225,"TMAC",3.27,{"$f":"G306*E306","v":735.75},0.5,{"$f":"H306*I306","v":367.875},{"$f":"+H306*(1-I306)","v":367.875}]
[null,null,"MNT-003 Madrid North to TIA remove bridge","each",1,"TMAC",50000,50000,0.5,25000,25000]
[null,null,"MNT-003 Cut Piles at ground surface","each",8,"TMAC",535,4280,0.5,2140,2140]
[null,null,"MNT-003 load and haul waste frrom demolition","m3",95,"TMAC",{"$f":"10.23+4.92","v":15.15},1439.25,0.5,719.625,719.625,null,"added haulage to landfillC4.59"]
[null,null,"Doris-Windy AWR remove bridges","each",3,"TMAC",50000,150000,0.5,75000,75000]
[null,null,"Doris-Windy AWR Load and Haul Waste to landfill","m3",140,"TMAC",{"$f":"10.23+4.92","v":15.15},{"$f":"G311*E311","v":2121},0.5,{"$f":"H311*I311","v":1060.5},{"$f":"+H311*(1-I311)","v":1060.5}]
[null,null,"Madrid-Boston AWR Bridge Removal -7,-8,-9,-12,-15,16 &-19","each",7,"TMAC",50000,350000,0.5,175000,175000]
[null,null,"Madrid-Boston AWR Bridge -7,-8,-9,-12,-15,16 &-19 Pile Removal","each",{"$f":"8*7","v":56},"TMAC",{"$f":"13.11*4","v":52.44},2936.64,0.5,1468.32,1468.32,null,null,"Reduce rate from 535 to 52.44 (4x13.11) to reflect cutting of pile at grade per SRK where the cutting of a drill casing is much easier than a pile"]
[null,null,"Madrid-Boston AWR Bridge -7,-8,-9,-12,-15,16 &-19 Waste Load and Haul","m2",{"$f":"135+126+180+180+108+90+108","v":927},"TMAC",{"$f":"10.23+4.92","v":15.15},14044.050000000001,0.5,7022.0250000000005,7022.0250000000005,null,"used an average haulage cost of $4.92/m3"]
[null,"Remove Arch Culverts","DW-005","each",1,"TMAC",100000,{"$f":"G315*E315","v":100000},null,{"$f":"H315*I315","v":0},{"$f":"+H315*(1-I315)","v":100000}]
[null,null,"DW-005 load and haul waste to landfill","m3",180,"TMAC",{"$f":"10.23+3.26","v":13.49},2428.1999999999998,0.5,1214.0999999999999,1214.0999999999999]
[null,"Remove Traffic Boulders","Madrid North -TIA Road Bridge Crossing","m3",24,"TMAC",2.75,{"$f":"G317*E317","v":66},0.5,{"$f":"H317*I317","v":33},{"$f":"+H317*(1-I317)","v":33}]
[null,null,"Cargo Dock Access Road Bridge Crossing","m3",24,"TMAC",2.75,66,0.5,33,33]
[null,null,"Madrid Boston AWR Crossings -7,-8,-9,-12,-15,-16 & -19","m3",{"$f":"24*7","v":168},"TMAC",2.75,462,0.5,231,231]
[null,"Doris Sump Removal","Remove pumps and culverts","each",2,"TMAC",2500,{"$f":"G320*E320","v":5000},0.5,{"$f":"H320*I320","v":2500},{"$f":"+H320*(1-I320)","v":2500}]
[null,"Scarify Roads","Madrid North - Fuel storage access & bypass roads, TIA AWR, Vent raise access","ha",{"$f":"((579+116+5405+1128)*10/10000)","v":7.2279999999999998},"ACI",1230,8890.44,0.5,4445.22,4445.22,null,"increased cost from 0.087 to 0.123/m2","Given this work will stil be done using a dozer the rate is not unreasonable"]
[null,null,"Madrid South - AWR, Vent Raise pad,","ha",{"$f":"((486+4943)*10/10000)","v":5.4290000000000003},"ACI",1230,{"$f":"G322*E322","v":6677.67},0.5,{"$f":"H322*I322","v":3338.835},{"$f":"+H322*(1-I322)","v":3338.835}]
[null,null,"Madrid-Boston AWR","ha",{"$f":"((52948)*10/10000)","v":52.948},"ACI",1230,65126.04,0.5,32563.02,32563.02]
[null,null,"Doris-Windy AWR","ha",{"$f":"((7318)*10/10000)","v":7.3179999999999996},"ACI",1230,{"$f":"G324*E324","v":9001.14},0.5,{"$f":"H324*I324","v":4500.57},{"$f":"+H324*(1-I324)","v":4500.57}]
[null,null,"Roberts Bay Jetty","m2",1045,"TMAC",1.23,1285.3499999999999,0.5,642.67499999999995,642.67499999999995]
[null,null,"Madrid-Boston AWR Quarry Roads (L,M,N,O,S,S,W,X,Z,AB)","ha",{"$f":"((270+748+259+88+1167+453+1183+40+49+1183)*10/10000)","v":5.44},"ACI",1230,{"$f":"G326*E326","v":6691.2000000000007},0.5,{"$f":"H326*I326","v":3345.6000000000004},{"$f":"+H326*(1-I326)","v":3345.6000000000004},null,"increased cost from 0.087 to 0.123/m2"]
[null,null,"Roberts Bay Access Roads","ha",{"$f":"((184+2800+336)*10/10000)","v":3.32},"ACI",1230,{"$f":"G327*E327","v":4083.6},0.5,{"$f":"H327*I327","v":2041.8},{"$f":"+H327*(1-I327)","v":2041.8}]
[null,null,"Doris Access Roads","ha",{"$f":"((3480+300+230+2420)*10/10000)","v":6.43},"ACI",1230,{"$f":"G328*E328","v":7908.9},0.5,{"$f":"H328*I328","v":3954.45},{"$f":"+H328*(1-I328)","v":3954.45}]
[null,"Scarify Laydown Area","Patch Lake Development Area","m2",291,"TMAC",1.23,357.93,0.5,178.965,178.965]
[null,null,"Roberts Bay Development Area","ha",{"$f":"((137500)/10000)","v":13.75},"ACI",1230,16912.5,0.5,8456.25,8456.25,null,"increased cost from 0.01 to 0.123/m2"]
[null,null,"Madrid North Development Area","ha",{"$f":"((95000)/10000)","v":9.5},"ACI",1230,11685,0.5,5842.5,5842.5]
[null,null,"Madrid South Development Area","ha",{"$f":"((108340)/10000)","v":10.834},"ACI",1230,13325.82,0.5,6662.91,6662.91]
[null,"Grade Fuel Storage Roads","RB-014 & RB-008","ha",{"$f":"(3000+4000)/10000","v":0.7},"ACI",1230,{"$f":"G333*E333","v":861},0.5,{"$f":"H333*I333","v":430.5},{"$f":"+H333*(1-I333)","v":430.5}]
[null,"Grade Helipad, Airstrip and Aprons","DM-007, DM-027 & DM-028","m2",{"$f":"15500+67722","v":83222},"DSL",0.95,{"$f":"G334*E334","v":79060.899999999994},0.5,{"$f":"H334*I334","v":39530.449999999997},{"$f":"+H334*(1-I334)","v":39530.449999999997},null,null,"updated aread reduced 91500 to 83222 plus 15500"]
[null,null,"Place X on airstrip each end","each",2,"TMAC",325,{"$f":"G335*E335","v":650},0.5,{"$f":"H335*I335","v":325},{"$f":"+H335*(1-I335)","v":325}]
[null,"Scarify ore piles laydown area",null,"ha",null,"scfyl",{"$f":"IF(ISNA(F336),0,INDEX(IF(UPPER(RIGHT(F336,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F336,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F336,LEN(F336)-1)),CostCode,0)))","v":4300},0,null,0,0]
[null,"Vegetate","Windy Tank Farm","m2",1400,"TMAC",0.92,1288,0.5,{"$f":"H337*I337","v":644},644]
[null,null,"Windy Accommodation Bldg","m2",1250,"TMAC",0.92,1150,0.5,575,575]
[null,null,"Windy Reclaim Drill Holes","m2",100,"TMAC",0.92,92,0.5,46,46]
[null,null,"Windy Development Area (apply nutrient for soil bioremediation)","m3",115,"TMAC",260,{"$f":"G340*E340","v":29900},0.5,{"$f":"H340*I340","v":14950},{"$f":"+H340*(1-I340)","v":14950}]
[null,"Other","DW-001, DM-31, CDR-001, SR-003 & Q3-002","ha",{"$f":"(((2400+2800+300+200)*10)+101334.9)/10000","v":15.833489999999999},"ACI",1230,19475.1927,null,{"$f":"H341*I341","v":0},19475.1927]
[null,"SPECIALIZED ITEMS"]
[null,"Remove Thermosyphons","TIA-003","each",12,"TMAC",535,{"$f":"G343*E343","v":6420},0.5,{"$f":"H343*I343","v":3210},{"$f":"+H343*(1-I343)","v":3210}]
[null,"Dispose of misc. debris and laydown area refuse",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F344),0,INDEX(IF(UPPER(RIGHT(F344,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F344,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F344,LEN(F344)-1)),CostCode,0)))","v":0},{"$f":"G344*E344","v":0},null,{"$f":"H344*I344","v":0},0]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H344)+0.0001","v":13677653.157899993},null,{"$f":"SUM(J5:J344)","v":6760409.5325499959},{"$f":"SUM(K5:K344)","v":6917243.6252499959}]
[null,null,null,null,null,null,"% of Total",null,null,{"$f":"J345/H345","v":0.49426677621557408},{"$f":"K345/H345","v":0.5057332237771146}]
[]
[null,"Note:  "]

{"sheet":"Water Management","index":7,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[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 WATER PONDS & CONTAINMENT BERMS"]
[null,"Remove/Level Berms (excavation)","MN-022, RB-013, RB-002, RB-003, RP-003, WM-001,DM-013, DM-014, DM-020","m3",{"$f":"45+154+77.8+90+90+76+453.6+28.8+76","v":1091.1999999999998},"TMAC",2.75,{"$f":"G5*E5","v":3000.7999999999993}]
[null,"Remove/Level Berms (grading)","DM-015, DM-035, MN-003, MS-003 & MS-012","m3",{"$f":"3130+1008+1008+1008+1008","v":7162},"TMAC",1.23,{"$f":"G6*E6","v":8809.26}]
[null,"Contour water intake area",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$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":0},{"$f":"G7*E7","v":0}]
[null,"STABILIZE SEDIMENT PONDS/WATER MANAGEMENT PONDS/SEWAGE DISCHARGE AREA"]
[null,"Place soil cover","Q2-003","m3",552,"TMAC",16.350000000000001,{"$f":"G9*E9","v":9025.2000000000007}]
[null,"Place erosion control blanket","Q2-002, Q2-003, PLA-001, WC-002","m2",{"$f":"2635+380+460+500+100","v":4075},"TMAC",4.84,19723]
[null,"place ROQ ","PLA-003","m3",552,"TMAC",12.69,{"$f":"G11*E11","v":7004.88}]
[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},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},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},0]
[null,"Remove sediment from WRSF Pond",null,"allow",null,"AE",10000,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 & TAILINGS IMPOUNDMENT AREA"]
[null,"Excavate breaches","TIA-003, RB-013, RB-002","m3",31021.1,"TMAC",8.82,{"$f":"G22*E22","v":273606.10200000001}]
[null,"Drill and Blast Ice Core","TIA-003","m3",7028,"TMAC",24.76,{"$f":"G23*E23","v":174013.28}]
[null,"Place borrow for core protection","TIA-003","m3",614.20000000000005,"TMAC",16.350000000000001,{"$f":"G24*E24","v":10042.170000000002}]
[null,"Install flow dissipation",null,"m3",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,"Vegetate remainder of ditch",null,"m2",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,"DECOMISSION FRESH WATER SUPPLY"]
[null,"Breach embankment",null,"m",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,"Remove pump","Madrid North sump and Doris two sumps","each",3,"TMAC",2500,{"$f":"G29*E29","v":7500}]
[null,"Remove pipeline",null,"LS",null,"AE",40000,{"$f":"G30*E30","v":0}]
[null,"Backfill Sumps","DM-018, MN-023","m3",{"$f":"34+17","v":51},"TMAC",16.350000000000001,{"$f":"G31*E31","v":833.85}]
[null,"WATER CONTROL IN RECLAMATION QUARRY"]
[null,"Install  pumping system",null,"LS",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,"Remove pumping system",null,"LS",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,"REMOVE PIPELINES"]
[null,"Remove pipes","Process water pipeline from Madrid North to Water Treatment Plant at TIA","m",9000,"TMAC",{"$f":"11.08+4.92","v":16},{"$f":"G36*E36","v":144000},"Not included in TMAC security but required to address movement of water from concentrator to WTP"]
[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","Remove pumps and cables","LS",1,"TMAC",2500,{"$f":"G38*E38","v":2500}]
[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,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,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":660058.54209999985}]
[null," For cost of long-term/post-closure water treatment see \"WATER TREATMENT\" Worksheet\""]

{"sheet":"Water Treatment","index":8,"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","Closure Dam Reclaim Pond","days",170,"TMAC",1190,202300]
[null,"Equipment maintenance and parts",null,"allow",1,"TMAC",50000,50000]
[null,"Misc. supplies, hoses, tools",null,"allow",1,"TMAC",20000,20000]
[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 FROM LANDFARM"]
[null,"Water Treatment (reagents, equip Op. labour)",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,"Water pumping from sumps and ponds to treatment plant",null,"allow",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,"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,{"$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,"Other",null,"allow",1,"TMAC",5000,{"$f":"G24*E24","v":5000}]
[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,{"$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,"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":277300.0001}]
[null,"Number of years of water treatment",null,"years",2]
[null,null,null,null,null,null,"Total",{"$f":"AnnualTreat1Cost*E38","v":554600.00020000001}]

{"sheet":"ICM","index":9,"n_rows":23,"n_cols":8,"rows_kept":23,"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","hrs",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","incrmental cost to the overall ICM for Hope Bay","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","incrmental cost to the overall ICM for Hope Bay","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,"ACI",20000,0]
[null,"small dozer",null,"allow",null,"dozersl",205,0]
[null,"small excavator",null,"allow",null,"exc-sl",190,0]
[null,"Operation and Maintenance","includes camp operations","allow",1,"TMAC",1570000,1570000]
[null,"Mobilization of ICM Equipment Fleet",null,"allow",0.33,"TMAC",260000,85800]
[null,"SNP/AEMP water sampling & reporting",null,"each",3,"TMAC",60000,180000]
[null,"Compliance Monitoring",null,"each",1,"TMAC",95000,{"$f":"G17*E17","v":95000}]
[null,"Regulatory reporting",null,"each",3,"TMAC",20000,{"$f":"G18*E18","v":60000}]
[null,"geotechnical assessment",null,"each",3,"TMAC",35000,105000]
[null,"interim water treatment",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},null,{"$f":"AnnualTreat1Cost","v":277300.0001}]
[null,"other",null,"allow",null,null,null,0]
[null,null,null,null,null,null,"Annual  Interim C&M Cost",{"$f":"SUM(H5:H21)","v":2373100.0000999998}]
[null,"Number of years of ICM",null,"years",3,null,"Total",{"$f":"H22*E23","v":7119300.0002999995}]

{"sheet":"Mobilization","index":10,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":false,"merged":[[50,2,51,2]]}
[1,"Mobilization/Demobilization:"]
[]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost"]
[null,"MOBILIZE HEAVY EQUIPMENT"]
[null,"Excavators","assume two excavators","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","assume four dump trucks","km",null,"mherl",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",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","assume three trucks","km",null,"mherl",{"$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":3.4},0]
[null,"MOBILIZE MISC. EQUIPMENT"]
[null,"Other","Mobilize eqipment and materials","allow",1,{"$f":"NA()","v":{"$error":"#N/A"}},1090000,1090000]
[null,"MOBILIZE CAMP"]
[null,"Maintain Camp Accomodations","Food","mandays",19021,"TMAC",100,{"$f":"G16*E16","v":1902100},null,"Change rate from $110 to $100"]
[null,"Camp Mobilization/Demobilization",null,"LS",1,"TMAC",208000,{"$f":"G17*E17","v":208000}]
[null,"Field Support Staff","mechanic","day",109,"TMAC",1160,{"$f":"G18*E18","v":126440}]
[null,"Camp Rental",null,"year",3,"TMAC",495000,{"$f":"G19*E19","v":1485000}]
[null,"Camp Operations",null,"year",3,"TMAC",816750,{"$f":"G20*E20","v":2450250}]
[null,"MOBILIZE WORKERS"]
[null,"Reclamation activities - transport",null,"flight",78,"TMAC",10625,{"$f":"G22*E22","v":828750}]
[null,"Reclamation activities - travel time",null,"manhours",{"$f":"E16*4/14","v":5434.5714285714284},"ACI",80,{"$f":"G23*E23","v":434765.71428571426}]
[null,"Long term reclamation activities (eg pump flooding) - transport",null,"each",null,"AE",3500,{"$f":"G24*E24","v":0}]
[null,"Long term reclamation activities (eg pump flooding) - travel time",null,"manhours",null,"AE",80,{"$f":"G25*E25","v":0}]
[null,"Monitoring Airfare",null,"each",null,"mwl",{"$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":4500},{"$f":"G26*E26","v":0}]
[null," WORKER ACCOMODATIONS"]
[null,"Reclamation activities",null,"manmonths",null,{"$f":"NA()","v":{"$error":"#N/A"}},2225,{"$f":"G28*E28","v":0}]
[null,"Long term reclamation activities (eg pump flooding)",null,"manmonths",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,"MOBILIZE FUEL"]
[null,"Fuel freight - reclamation activities","assumes sufficient fuel is on site to complete the work","litre",null,"fcdh",{"$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":1.39},{"$f":"G31*E31","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(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,"Fuel freight accomodations",null,"litre",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,"WINTER ROAD"]
[null,"Construction and operation",null,"km",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,"Limited winter use",null,"km",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,"Winter road tarriff",null,"km",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,"DEMOBILIZE EQUIPMENT & MATERIALs"]
[null,"Excavators","assume two excavators","km",null,"mherh",{"$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":10.25},{"$f":"G39*E39","v":0}]
[null,"Dump trucks","assume four dump trucks","km",null,"mherl",{"$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":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(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":10.25},{"$f":"G44*E44","v":0}]
[null,"Compactor",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$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":0},{"$f":"G45*E45","v":0}]
[null,"Light duty vehicles","assume three trucks","km",null,"mherl",3.4,0]
[null,"Other","Demobilize eqipment and materials","allow",1,{"$f":"NA()","v":{"$error":"#N/A"}},1090000,1090000]
[null,"DEMOBILIZE CAMP"]
[null,null,null,"allow",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,"DEMOBILIZE WORKERS"]
[null,"crew travel time","cost in mobilization of workers.","mandays",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,"crew transportation",null,"each",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,"WINTER ROAD"]
[null,"Construction and operation",null,"km",null,"wrcl",{"$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":2000},{"$f":"G54*E54","v":0}]
[null,"Limited winter use",null,"km",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,"Winter road tarriff",null,"tonnekm",null,"wrul",{"$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.28999999999999998},{"$f":"G56*E56","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H56)","v":9615305.7142857146}]

{"sheet":"PostClosure","index":11,"n_rows":41,"n_cols":9,"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,"Cover Monitoirng Inspections","Year 2, 4, 6, 8, 10, 15, 20 &25","each",1,"TMAC",28000,28000,"8 inspections @$35,000 each = $280,000"]
[null,"Surface water sampling","Year 1 - 5, 7, 10, 15, 20 & 25","each",1,"TMAC",60000,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"}},{"$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},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,{"$f":"G23*E23","v":0}]
[null,"Repair animal damage",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G24*E24","v":0}]
[null,"Repair/upgrade access controls",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G25*E25","v":0}]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G26*E26","v":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":277300.0001},{"$f":"G33*E33","v":277300.0001}]
[]
[null,"Subtotal, Annual post-closure costs ",null,null,null,null,null,{"$f":"SUM(H5:H34)+0.0001","v":435087.65019999997}]
[]
[null,"Discount rate for calculation of net present value of post-closure cost, %",null,null,null,0]
[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":4350876.5019999994}]
[]
[null,"*Regulatory costs - annual reporting, management plans, progress reports etc."]

{"sheet":"Open Pit","index":12,"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"}},{"$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":0},{"$f":"G7*E7","v":0},null,0,0]
[null,"Block roads",null,"m3",null,"RB1H",{"$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":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"}},{"$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,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"}},{"$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,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,{"$f":"H28*I28","v":0},{"$f":"H28*(1-I28)","v":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,{"$f":"H29*I29","v":0},{"$f":"H29*(1-I29)","v":0}]
[null,"CONSTRUCT SPILLWAY"]
[null,"Excavate channel",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},{"$f":"G31*E31","v":0},null,0,0]
[null,"Concrete",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,"Rip rap",null,"m3",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,"Other",null,null,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,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},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"}},0,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,0,null,{"$f":"H44*I44","v":0},{"$f":"+H44*(1-I44)","v":0}]
[null,"    -Ditch, mat'l B",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H45*I45","v":0},{"$f":"+H45*(1-I45)","v":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},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},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},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,{"$f":"G52*E52","v":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},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"}},0,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"}},0,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"}},0,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":"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"]