{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Instructions","Tools","Summary","Open Pit","UG Mine","Tailings","Rock Pile","Chemicals","Bldgs & Equip","Water Management","Water Treatment","PostClosure","ICM","Mobilization","Unit_Costs","Estimator"],"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":70,"n_cols":8,"rows_kept":70,"cut":false,"hidden":false,"merged":[[59,0,68,1],[33,0,33,1],[34,0,39,1],[40,0,47,1],[48,0,54,1],[55,0,58,1]]}
["Project Name:",null,"Reclaim Model - Overview of Program"]
[null,"Blank                    ","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'."]
["and included in \"Post-closure Monitoring and Maintenance\"."]
[null,null,null,"Short Term/ Capital Ex.","Long term","","",""]
["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":"Tools","index":1,"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"]

{"sheet":"Summary","index":2,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"SUMMARY OF COSTS"]
[]
["CAPITAL COSTS","COMPONENT NAME",null,"COST",null,"LAND LIABILITY",null,"WATER LIABILITY"]
["OPEN PIT",{"$f":"IF(ISBLANK('Open Pit'!$C$1),\"\",'Open Pit'!$C$1)","v":""},null,{"$f":"Pit1Total","v":1E-4},null,{"$f":"Pit1LandTotal","v":0},null,{"$f":"Pit1WaterTotal","v":0}]
["UNDERGROUND MINE",{"$f":"IF(ISBLANK('UG Mine'!$C$1),\"\",'UG Mine'!$C$1)","v":""},null,{"$f":"UG1Total","v":1E-4},null,{"$f":"UG1LandTotal","v":0},null,{"$f":"UG1WaterTotal","v":0}]
["TAILINGS FACILITY",{"$f":"IF(ISBLANK(Tailings!$C$1),\"\",Tailings!$C$1)","v":""},null,{"$f":"Tailings1Total","v":1E-4},null,{"$f":"Tailings1LandTotal","v":0},null,{"$f":"Tailings1WaterTotal","v":0}]
["ROCK PILE",{"$f":"IF(ISBLANK('Rock Pile'!$C$1),\"\",'Rock Pile'!$C$1)","v":""},null,{"$f":"RP1Total","v":1E-4},null,{"$f":"RP1LandTotal","v":0},null,{"$f":"RP1WaterTotal","v":0}]
["BUILDINGS AND EQUIPMENT",{"$f":"IF(ISBLANK('Bldgs & Equip'!$C$1),\"\",'Bldgs & Equip'!$C$1)","v":""},null,{"$f":"Bldg1Total","v":1E-4},null,{"$f":"Bldg1LandTotal","v":0},null,{"$f":"Bldg1WaterTotal","v":0}]
["CHEMICALS AND CONTAMINATED SOIL MANAGEMENT",{"$f":"IF(ISBLANK(Chemicals!$C$1),\"\",Chemicals!$C$1)","v":""},null,{"$f":"Chem1Total","v":1E-4},null,{"$f":"Chem1LandTotal","v":0},null,{"$f":"Chem1WaterTotal","v":0}]
["SURFACE AND GROUNDWATER MANAGEMENT",{"$f":"IF(ISBLANK('Water Treatment'!$C$1),\"\",'Water Treatment'!$C$1)","v":""},null,{"$f":"Water1Total","v":1E-4},null,"-",null,{"$f":"Water1Total","v":1E-4}]
["INTERIM CARE AND MAINTENANCE",{"$f":"IF(ISBLANK(ICM!$C$1),\"\",ICM!$C$1)","v":""},null,{"$f":"ICMTotal","v":0},null,"-",null,{"$f":"ICMTotal","v":0}]
[null,"SUBTOTAL: Capital Costs",null,{"$f":"SUM(D4:D11)","v":7.000000000000001E-4},null,{"$f":"SUM(F4:F11)","v":0},null,{"$f":"SUM(H4:H11)","v":1E-4}]
[null,"PERCENT OF SUBTOTAL ",null,null,null,{"$f":"IF(F12<0.01,0,F12/D12)","v":0},null,{"$f":"IF(H12<0.01,0,H12/D12)","v":0}]
[]
["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":1E-4},null,{"$f":"D16*$F$13","v":0},null,{"$f":"D16*$H$13","v":0}]
["POST-CLOSURE MONITORING AND MAINTENANCE",{"$f":"IF(ISBLANK(PostClosure!$C$1),\"\",PostClosure!$C$1)","v":""},null,{"$f":"PC1Total","v":0},null,{"$f":"D17*$F$13","v":0},null,{"$f":"D17*$H$13","v":0}]
["ENGINEERING ",0.05,null,{"$f":"B18*$D$12","v":3.5000000000000004E-5},null,{"$f":"+$F$13*D18","v":0},null,{"$f":"+$H$13*D18","v":0}]
["PROJECT MANAGEMENT",0.05,null,3.5000000000000004E-5,null,0,null,0]
["HEALTH AND SAFETY PLANS/MONITORING & QA/QC",0.01,null,7.0000000000000007E-6,null,0,null,0]
["BONDING/INSURANCE",0.01,null,7.0000000000000007E-6,null,0,null,0]
["CONTINGENCY ",0.2,null,1.4000000000000001E-4,null,0,null,0]
["MARKET PRICE FACTOR ADJUSTMENT",0,null,0,null,0,null,0]
[null,"SUBTOTAL: Indirect Costs",null,{"$f":"SUM(D16:D23)","v":3.2400000000000007E-4},null,{"$f":"SUM(F16:F23)","v":0},null,{"$f":"SUM(H16:H23)","v":0}]
[]
["TOTAL COSTS",null,null,{"$f":"D12+D24","v":1.0240000000000002E-3},null,{"$f":"F12+F24","v":0},null,{"$f":"H12+H24","v":1E-4}]

{"sheet":"Open Pit","index":3,"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,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G6*E6","v":0},null,{"$f":"H6*I6","v":0},{"$f":"H6*(1-I6)","v":0}]
[null,"Berm at crest",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G7*E7","v":0},null,0,0]
[null,"Block roads",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},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,{"$f":"H9*I9","v":0},{"$f":"H9*(1-I9)","v":0}]
[null,"STABILITY STUDY"]
[null,"Conduct stability and setback study",null,"allow",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,{"$f":"H11*I11","v":0},{"$f":"H11*(1-I11)","v":0}]
[null,"STABILIZE SLOPES"]
[null,"Off-load crest, soil A",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G13*E13","v":0},null,0,0]
[null,"Off-load crest, soil B",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Doze/trim overburden at crest",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Drill & blast pit crest",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Buttress slope",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"COVER/CONTOUR SLOPES"]
[null,"Place fill, soil A",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G20*E20","v":0},null,0,0]
[null,"Place fill, soil B",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Rip rap",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Vegetate slopes",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Vegetate pit floor",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"CONSTRUCT DIVERSION DITCHES"]
[null,"Excavate ditches -soil",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,"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"}},0,{"$f":"G31*E31","v":0},null,0,0]
[null,"Concrete",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G32*E32","v":0},null,0,0]
[null,"Rip rap",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G33*E33","v":0},null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G34*E34","v":0},null,0,0]
[null,"RECLAIM QUARRIES"]
[null,"Contour slopes",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F36),0,INDEX(IF(UPPER(RIGHT(F36,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F36,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F36,LEN(F36)-1)),CostCode,0)))","v":0},{"$f":"G36*E36","v":0},null,{"$f":"H36*I36","v":0},{"$f":"H36*(1-I36)","v":0}]
[null,"Place overburden",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F37),0,INDEX(IF(UPPER(RIGHT(F37,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F37,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F37,LEN(F37)-1)),CostCode,0)))","v":0},{"$f":"G37*E37","v":0},null,{"$f":"H37*I37","v":0},{"$f":"H37*(1-I37)","v":0}]
[null,"Vegetate",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F38),0,INDEX(IF(UPPER(RIGHT(F38,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F38,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F38,LEN(F38)-1)),CostCode,0)))","v":0},{"$f":"G38*E38","v":0},null,{"$f":"H38*I38","v":0},{"$f":"H38*(1-I38)","v":0}]
[null,"FLOOD PIT-Captital"]
[null,"Remove stationary equipment (sump pumps)",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$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"}},{"$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},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"}},{"$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},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"}},{"$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},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,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,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,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$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"}},{"$f":"IF(ISNA(F54),0,INDEX(IF(UPPER(RIGHT(F54,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F54,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F54,LEN(F54)-1)),CostCode,0)))","v":0},0,null,{"$f":"H54*I54","v":0},{"$f":"H54*(1-I54)","v":0}]
[null,"Chemical addition,  _____ kg/m3 of water",null,"tonne",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Chemicals, purchase and shipping",null,"tonne",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Passive/biological additives",null,"$/ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F57),0,INDEX(IF(UPPER(RIGHT(F57,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F57,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F57,LEN(F57)-1)),CostCode,0)))","v":0},0,null,{"$f":"H57*I57","v":0},{"$f":"H57*(1-I57)","v":0}]
[null,"Passive additives purchase and shipping",null,"tonne",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F58),0,INDEX(IF(UPPER(RIGHT(F58,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F58,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F58,LEN(F58)-1)),CostCode,0)))","v":0},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"]
[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":"UG Mine","index":4,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[1,"Underground Mine Name",null,null,null,null,"UG Mine #",1]
[]
[null,"ACTIVITY/MATERIAL","Notes","Unit","Qty","Cost Code","Unit Cost","Cost","% Land","Land Cost","Water Cost"]
[null,"CONTROL ACCESS"]
[null,"Fence",null,"m",null,{"$error":"#N/A"},{"$f":"IF(ISNA(F5),0,INDEX(IF(UPPER(RIGHT(F5,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F5,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F5,LEN(F5)-1)),CostCode,0)))","v":0},{"$f":"G5*E5","v":0},null,{"$f":"H5*I5","v":0},{"$f":"H5*(1-I5)","v":0}]
[null,"Signs",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H6*I6","v":0},{"$f":"H6*(1-I6)","v":0}]
[null,"Block roads",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G7*E7","v":0},null,0,0]
[null,"Berm",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Concrete wall in  portals",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H9*I9","v":0},{"$f":"H9*(1-I9)","v":0}]
[null,"Backfill portal #1",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Backfill portal #2",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Cap raise # 1",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Cap raise #2",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Cap shaft #1",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Cap shaft #2",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Backfill adits",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H16*I16","v":0},{"$f":"H16*(1-I16)","v":0}]
[null,"Backfill open stope",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,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",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"REMOVE HAZARDOUS MATERIALS"]
[null,"Remove hazardous materials, U/G labor",null,"mandays",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,"Remove/decontam. stationary & elect. equip",null,"mandays",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F22),0,INDEX(IF(UPPER(RIGHT(F22,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F22,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F22,LEN(F22)-1)),CostCode,0)))","v":0},{"$f":"G22*E22","v":0},null,{"$f":"H22*I22","v":0},{"$f":"H22*(1-I22)","v":0}]
[null,"Remove/decontam. mobile equipment",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F23),0,INDEX(IF(UPPER(RIGHT(F23,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F23,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F23,LEN(F23)-1)),CostCode,0)))","v":0},{"$f":"G23*E23","v":0},null,{"$f":"H23*I23","v":0},{"$f":"H23*(1-I23)","v":0}]
[null,"Remove misc. haz. mat & explosives",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F24),0,INDEX(IF(UPPER(RIGHT(F24,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F24,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F24,LEN(F24)-1)),CostCode,0)))","v":0},{"$f":"G24*E24","v":0},null,{"$f":"H24*I24","v":0},{"$f":"H24*(1-I24)","v":0}]
[null,"Other",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},{"$f":"G25*E25","v":0},null,{"$f":"H25*I25","v":0},{"$f":"H25*(1-I25)","v":0}]
[null,"INSTALL BULKHEADS"]
[null,"Bulkheads to control water flow",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F27),0,INDEX(IF(UPPER(RIGHT(F27,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F27,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F27,LEN(F27)-1)),CostCode,0)))","v":0},{"$f":"G27*E27","v":0},null,{"$f":"H27*I27","v":0},{"$f":"H27*(1-I27)","v":0}]
[null,"Grout bulkhead",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F28),0,INDEX(IF(UPPER(RIGHT(F28,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F28,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F28,LEN(F28)-1)),CostCode,0)))","v":0},{"$f":"G28*E28","v":0},null,{"$f":"H28*I28","v":0},{"$f":"H28*(1-I28)","v":0}]
[null,"FLOOD MINE"]
[null,"Supply/install pump",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F30),0,INDEX(IF(UPPER(RIGHT(F30,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F30,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F30,LEN(F30)-1)),CostCode,0)))","v":0},{"$f":"G30*E30","v":0},null,0,0]
[null,"Supply/install piping system",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F31),0,INDEX(IF(UPPER(RIGHT(F31,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F31,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F31,LEN(F31)-1)),CostCode,0)))","v":0},{"$f":"G31*E31","v":0},null,{"$f":"H31*I31","v":0},{"$f":"H31*(1-I31)","v":0}]
[null,"Operate pumps to flood workings",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F32),0,INDEX(IF(UPPER(RIGHT(F32,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F32,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F32,LEN(F32)-1)),CostCode,0)))","v":0},{"$f":"G32*E32","v":0},null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F33),0,INDEX(IF(UPPER(RIGHT(F33,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F33,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F33,LEN(F33)-1)),CostCode,0)))","v":0},{"$f":"G33*E33","v":0},null,0,0]
[null,"INSTALL GROUNDWATER COLLECTION SYSTEM"]
[null,"Excavate/install sumps",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F35),0,INDEX(IF(UPPER(RIGHT(F35,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F35,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F35,LEN(F35)-1)),CostCode,0)))","v":0},{"$f":"G35*E35","v":0},null,{"$f":"H35*I35","v":0},{"$f":"+H35*(1-I35)","v":0}]
[null,"Install pumping wells",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$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,"Install pumps/pipelines/power supply",null,"LS",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,"SPECIALIZED ITEMS"]
[null,"Install water quality monitoring pipes",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F39),0,INDEX(IF(UPPER(RIGHT(F39,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F39,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F39,LEN(F39)-1)),CostCode,0)))","v":0},{"$f":"G39*E39","v":0},null,{"$f":"H39*I39","v":0},0]
[null,"Install permanent pumping system",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$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},0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F41),0,INDEX(IF(UPPER(RIGHT(F41,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F41,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F41,LEN(F41)-1)),CostCode,0)))","v":0},{"$f":"G41*E41","v":0},null,{"$f":"H41*I41","v":0},0]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H41)+0.0001","v":1E-4},null,{"$f":"SUM(J5:J41)","v":0},{"$f":"SUM(K5:K41)","v":0}]
[null,null,null,null,null,null,"% of Total",null,null,{"$f":"J42/H42","v":0},{"$f":"K42/H42","v":0}]

{"sheet":"Tailings","index":5,"n_rows":80,"n_cols":11,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[1,"Tailings Impoundment Name:",null,null,null,null,"Pond #",1]
[]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost","% Land","Land Cost","Water Cost"]
[null,"CONTROL ACCESS"]
[null,"Fence",null,"m",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F5),0,INDEX(IF(UPPER(RIGHT(F5,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F5,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F5,LEN(F5)-1)),CostCode,0)))","v":0},{"$f":"G5*E5","v":0},null,{"$f":"H5*I5","v":0},{"$f":"+H5*(1-I5)","v":0}]
[null,"Signs",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$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"}},0,0,null,0,0]
[null,"Rip rap",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,"Raise crest",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Flatten slopes",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"COVER TAILINGS"]
[null,"Grade/shape tailings surface",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,{"$f":"H19*I19","v":0},{"$f":"+H19*(1-I19)","v":0}]
[null,"Liner bedding",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},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"}},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"}},0,0,null,0,0]
[null,"Install geotextile/geosynthetic",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G23*E23","v":0},null,{"$f":"H23*I23","v":0},{"$f":"+H23*(1-I23)","v":0}]
[null,"Soil cover",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Rock cover",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G25*E25","v":0},null,{"$f":"H25*I25","v":0},{"$f":"+H25*(1-I25)","v":0}]
[null,"Vegetate",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G27*E27","v":0},null,{"$f":"H27*I27","v":0},{"$f":"+H27*(1-I27)","v":0}]
[null,"BURY PAG ROCK"]
[null,"Relocate PAG rock",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F29),0,INDEX(IF(UPPER(RIGHT(F29,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F29,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F29,LEN(F29)-1)),CostCode,0)))","v":0},{"$f":"G29*E29","v":0},null,0,0]
[null,"Place cover over PAG rock",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F30),0,INDEX(IF(UPPER(RIGHT(F30,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F30,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F30,LEN(F30)-1)),CostCode,0)))","v":0},{"$f":"G30*E30","v":0},null,0,0]
[null,"Raise crest of dam",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,"Other",null,null,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,"STABILIZE DECANT SYSTEM"]
[null,"Excavate and replace",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F34),0,INDEX(IF(UPPER(RIGHT(F34,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F34,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F34,LEN(F34)-1)),CostCode,0)))","v":0},{"$f":"G34*E34","v":0},null,{"$f":"H34*I34","v":0},{"$f":"+H34*(1-I34)","v":0}]
[null,"Plug/backfill with concrete or clay",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F35),0,INDEX(IF(UPPER(RIGHT(F35,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F35,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F35,LEN(F35)-1)),CostCode,0)))","v":0},{"$f":"G35*E35","v":0},null,{"$f":"H35*I35","v":0},{"$f":"+H35*(1-I35)","v":0}]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F36),0,INDEX(IF(UPPER(RIGHT(F36,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F36,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F36,LEN(F36)-1)),CostCode,0)))","v":0},{"$f":"G36*E36","v":0},null,{"$f":"H36*I36","v":0},{"$f":"+H36*(1-I36)","v":0}]
[null,"REMOVE TAILINGS DISCHARGE"]
[null,"Cyclones",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F38),0,INDEX(IF(UPPER(RIGHT(F38,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F38,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F38,LEN(F38)-1)),CostCode,0)))","v":0},{"$f":"G38*E38","v":0},null,{"$f":"H38*I38","v":0},{"$f":"+H38*(1-I38)","v":0}]
[null,"Pipe",null,"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,"Remove reclaim barge",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F40),0,INDEX(IF(UPPER(RIGHT(F40,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F40,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F40,LEN(F40)-1)),CostCode,0)))","v":0},{"$f":"G40*E40","v":0},null,{"$f":"H40*I40","v":0},{"$f":"+H40*(1-I40)","v":0}]
[null,"CONSTRUCT DIVERSION DITCHES"]
[null,"Excavate ditches -soil",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F42),0,INDEX(IF(UPPER(RIGHT(F42,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F42,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F42,LEN(F42)-1)),CostCode,0)))","v":0},{"$f":"G42*E42","v":0},null,{"$f":"H42*I42","v":0},{"$f":"+H42*(1-I42)","v":0}]
[null,"Excavate ditches -rock",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F43),0,INDEX(IF(UPPER(RIGHT(F43,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F43,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F43,LEN(F43)-1)),CostCode,0)))","v":0},{"$f":"G43*E43","v":0},null,{"$f":"H43*I43","v":0},{"$f":"+H43*(1-I43)","v":0}]
[null,"Rip rap in channel base",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F44),0,INDEX(IF(UPPER(RIGHT(F44,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F44,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F44,LEN(F44)-1)),CostCode,0)))","v":0},{"$f":"G44*E44","v":0},null,{"$f":"H44*I44","v":0},{"$f":"+H44*(1-I44)","v":0}]
[null,"FLOOD TAILINGS"]
[null,"Doze tailings to final contour",null,"m3",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,0,0]
[null,"Raise crest of dam",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,0,0]
[null,"Other",null,null,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,0,0]
[null,"UPGRADE SPILLWAY"]
[null,"Excavate channel, rock",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F50),0,INDEX(IF(UPPER(RIGHT(F50,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F50,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F50,LEN(F50)-1)),CostCode,0)))","v":0},{"$f":"G50*E50","v":0},null,0,0]
[null,"Excavate channel, soil",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,"Concrete",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,"Rip rap",null,"m3",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,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F54),0,INDEX(IF(UPPER(RIGHT(F54,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F54,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F54,LEN(F54)-1)),CostCode,0)))","v":0},{"$f":"G54*E54","v":0},null,0,0]
[null,"CONSTRUCT SEEPAGE COLLECTION POND"]
[null,"Excavate seepage collection pond",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F56),0,INDEX(IF(UPPER(RIGHT(F56,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F56,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F56,LEN(F56)-1)),CostCode,0)))","v":0},{"$f":"G56*E56","v":0},null,{"$f":"H56*I56","v":0},{"$f":"+H56*(1-I56)","v":0}]
[null,"Doze & spread excavated material",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Vegetate spread material",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Bedding layer",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Supply geomembrane",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Install geomembrane",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Erosion protection layer",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"INSTALL GROUNDWATER COLLECTION SYSTEM"]
[null,"Excavate/install sumps",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F64),0,INDEX(IF(UPPER(RIGHT(F64,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F64,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F64,LEN(F64)-1)),CostCode,0)))","v":0},{"$f":"G64*E64","v":0},null,{"$f":"H64*I64","v":0},{"$f":"+H64*(1-I64)","v":0}]
[null,"Install pumping wells",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F65),0,INDEX(IF(UPPER(RIGHT(F65,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F65,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F65,LEN(F65)-1)),CostCode,0)))","v":0},{"$f":"G65*E65","v":0},null,{"$f":"H65*I65","v":0},{"$f":"+H65*(1-I65)","v":0}]
[null,"Install pumps/pipelines/power supply",null,"LS",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F66),0,INDEX(IF(UPPER(RIGHT(F66,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F66,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F66,LEN(F66)-1)),CostCode,0)))","v":0},{"$f":"G66*E66","v":0},null,{"$f":"H66*I66","v":0},{"$f":"+H66*(1-I66)","v":0}]
[null,"SPECIALIZED ITEMS"]
[null,"Install permanent instrumentation, supply & technican",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F68),0,INDEX(IF(UPPER(RIGHT(F68,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F68,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F68,LEN(F68)-1)),CostCode,0)))","v":0},{"$f":"G68*E68","v":0},null,{"$f":"H68*I68","v":0},{"$f":"+H68*(1-I68)","v":0}]
[null,"Install permanent instrumentation, drilling",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F69),0,INDEX(IF(UPPER(RIGHT(F69,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F69,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F69,LEN(F69)-1)),CostCode,0)))","v":0},{"$f":"G69*E69","v":0},null,null,{"$f":"+H69*(1-I69)","v":0}]
[null,"TREAT SEEPAGE - see \"Water Management\" and \"Water Treatment\""]
[null,"TREAT SUPERNATANT"]
[null,"Pump water (to pit, U/G)",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F72),0,INDEX(IF(UPPER(RIGHT(F72,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F72,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F72,LEN(F72)-1)),CostCode,0)))","v":0},{"$f":"G72*E72","v":0},null,{"$f":"H72*I72","v":0},{"$f":"+H72*(1-I72)","v":0}]
[null,"Equipment maintenance and parts",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$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,"Supply reagents",null,"tonne",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F74),0,INDEX(IF(UPPER(RIGHT(F74,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F74,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F74,LEN(F74)-1)),CostCode,0)))","v":0},{"$f":"G74*E74","v":0},null,{"$f":"H74*I74","v":0},{"$f":"+H74*(1-I74)","v":0}]
[null,null,null,null,null,null,"Annual treatment costs",{"$f":"SUM(H72:H74)+0.0001","v":1E-4}]
[null,"Number of years of treatment",null,"years"]
[null,null,null,null,null,null,"Total treatment costs",{"$f":"H75*E76","v":0},null,null,{"$f":"H77","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H69)+H77+0.0001","v":1E-4},null,{"$f":"SUM(J5:J69)+J77","v":0},{"$f":"SUM(K5:K69)+K77","v":0}]
[null,null,null,null,null,null,"% of Total",null,null,{"$f":"J78/H78","v":0},{"$f":"K78/H78","v":0}]
[null,"* for construction of passive treatment system refer to \"Water Management\""]

{"sheet":"Rock Pile","index":6,"n_rows":67,"n_cols":11,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[1,"Rock Pile Name:"]
[]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost","% Land","Land Cost","Water Cost"]
[null,"STABILIZE SLOPES"]
[null,"Flatten slopes with dozer",null,"m3",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,"Flatten \"bubble dump\" areas",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Divert runon, ditch mat'l A",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Divert runon, ditch mat'l B",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Toe buttress, drain mat'l",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Toe buttress, fill mat'l A",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Toe buttress, fill mat'l B",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"COVER ROCK PILE"]
[null,"Subgrade preparation - doze surface",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F14),0,INDEX(IF(UPPER(RIGHT(F14,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F14,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F14,LEN(F14)-1)),CostCode,0)))","v":0},{"$f":"G14*E14","v":0},null,{"$f":"H14*I14","v":0},{"$f":"+H14*(1-I14)","v":0}]
[null,"Soil cover - excavate,haul,spread&compact",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Rock cover - excavate,haul & spread",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Excavate downslope drainage channel & chute",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Rip rap drainage channel and chute",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Vegetate",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"VERY LOW PERMEABILITY COVER (in addition to above)"]
[null,"Liner subgrade preparation - compact",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F22),0,INDEX(IF(UPPER(RIGHT(F22,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F22,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F22,LEN(F22)-1)),CostCode,0)))","v":0},{"$f":"G22*E22","v":0},null,{"$f":"H22*I22","v":0},{"$f":"+H22*(1-I22)","v":0}]
[null,"Supply geomembrame",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F23),0,INDEX(IF(UPPER(RIGHT(F23,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F23,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F23,LEN(F23)-1)),CostCode,0)))","v":0},{"$f":"G23*E23","v":0},null,0,0]
[null,"Install geomembrane",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F24),0,INDEX(IF(UPPER(RIGHT(F24,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F24,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F24,LEN(F24)-1)),CostCode,0)))","v":0},{"$f":"G24*E24","v":0},null,0,0]
[null,"Protective cover - excavate,haul,spread&compact",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Vegetate",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Install infiltration/seepage instrumentation",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"CONSTRUCT DIVERSION DITCHES"]
[null,"Excavate ditches -soil",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F29),0,INDEX(IF(UPPER(RIGHT(F29,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F29,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F29,LEN(F29)-1)),CostCode,0)))","v":0},{"$f":"G29*E29","v":0},null,{"$f":"H29*I29","v":0},{"$f":"+H29*(1-I29)","v":0}]
[null,"Excavate ditches -rock",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F30),0,INDEX(IF(UPPER(RIGHT(F30,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F30,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F30,LEN(F30)-1)),CostCode,0)))","v":0},{"$f":"G30*E30","v":0},null,{"$f":"H30*I30","v":0},{"$f":"+H30*(1-I30)","v":0}]
[null,"Rip rap in channel base",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F31),0,INDEX(IF(UPPER(RIGHT(F31,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F31,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F31,LEN(F31)-1)),CostCode,0)))","v":0},{"$f":"G31*E31","v":0},null,{"$f":"H31*I31","v":0},{"$f":"+H31*(1-I31)","v":0}]
[null,"CONSTRUCT SEEPAGE COLLECTION POND"]
[null,"Excavate seepage collection pond",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H33*I33","v":0},{"$f":"+H33*(1-I33)","v":0}]
[null,"Doze & spread excavated material",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Vegetate spread material",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Bedding layer",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Supply geomembrane",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Install geomembrane",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Erosion protection layer",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"INSTALL GROUNDWATER COLLECTION SYSTEM"]
[null,"Excavate/install sumps",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F41),0,INDEX(IF(UPPER(RIGHT(F41,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F41,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F41,LEN(F41)-1)),CostCode,0)))","v":0},{"$f":"G41*E41","v":0},null,{"$f":"H41*I41","v":0},{"$f":"+H41*(1-I41)","v":0}]
[null,"Install pumping wells",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$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,"allow",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,"RELOCATE DUMPS"]
[null,"Load, haul, dump or doze",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,"Add lime",null,"tonne",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F46),0,INDEX(IF(UPPER(RIGHT(F46,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F46,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F46,LEN(F46)-1)),CostCode,0)))","v":0},{"$f":"G46*E46","v":0},null,{"$f":"H46*I46","v":0},{"$f":"+H46*(1-I46)","v":0}]
[null,"Contour reclaimed area",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F47),0,INDEX(IF(UPPER(RIGHT(F47,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F47,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F47,LEN(F47)-1)),CostCode,0)))","v":0},{"$f":"G47*E47","v":0},null,{"$f":"H47*I47","v":0},{"$f":"+H47*(1-I47)","v":0}]
[null,"Other",null,null,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,"SPECIALIZED ITEMS"]
[null,"Install permanent instrumentation",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F50),0,INDEX(IF(UPPER(RIGHT(F50,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F50,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F50,LEN(F50)-1)),CostCode,0)))","v":0},{"$f":"G50*E50","v":0},null,{"$f":"H50*I50","v":0},{"$f":"+H50*(1-I50)","v":0}]
[null,"Install permanent instrumentation, drilling",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F51),0,INDEX(IF(UPPER(RIGHT(F51,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F51,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F51,LEN(F51)-1)),CostCode,0)))","v":0},{"$f":"G51*E51","v":0},null,{"$f":"H51*I51","v":0},{"$f":"+H51*(1-I51)","v":0}]
[null,"TREAT ROCK PILE SEEPAGE - see \"Water Treatment\""]
[null,"HEAP LEACH SEEPAGE TREATMENT - Cyanide Detox"]
[null,"Cyanide destruction water treatment pumping",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F54),0,INDEX(IF(UPPER(RIGHT(F54,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F54,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F54,LEN(F54)-1)),CostCode,0)))","v":0},{"$f":"G54*E54","v":0},null,{"$f":"H54*I54","v":0},{"$f":"+H54*(1-I54)","v":0}]
[null,"Reagents",null,"tonnes",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F55),0,INDEX(IF(UPPER(RIGHT(F55,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F55,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F55,LEN(F55)-1)),CostCode,0)))","v":0},{"$f":"G55*E55","v":0},null,{"$f":"H55*I55","v":0},{"$f":"+H55*(1-I55)","v":0}]
[null,"Electrician/mechanic to maintain treatment plant",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F56),0,INDEX(IF(UPPER(RIGHT(F56,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F56,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F56,LEN(F56)-1)),CostCode,0)))","v":0},{"$f":"G56*E56","v":0},null,{"$f":"H56*I56","v":0},{"$f":"+H56*(1-I56)","v":0}]
[null,"Equipment maintenance and parts",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F57),0,INDEX(IF(UPPER(RIGHT(F57,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F57,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F57,LEN(F57)-1)),CostCode,0)))","v":0},{"$f":"G57*E57","v":0},null,{"$f":"H57*I57","v":0},{"$f":"+H57*(1-I57)","v":0}]
[null,null,null,null,null,null,"Annual treatment costs",{"$f":"SUM(H54:H57)+0.0001","v":1E-4}]
[null,"Number of years of treatment",null,"years"]
[null,null,null,null,null,null,"Total treatment costs",{"$f":"H58*E59","v":0},null,null,{"$f":"H60","v":0}]
[null,"HEAP LEACH SEEPAGE TREATMENT - ARD/ML**"]
[null,"Upgrade/modify pumping system - report to WTP",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F62),0,INDEX(IF(UPPER(RIGHT(F62,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F62,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F62,LEN(F62)-1)),CostCode,0)))","v":0},{"$f":"G62*E62","v":0},null,null,{"$f":"H62","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H51)+H60+H62+0.0001","v":1E-4},null,{"$f":"SUM(J5:J51)+J60+J62","v":0},{"$f":"SUM(K5:K51)+K60+K62","v":0}]
[null,null,null,null,null,null,"% of Total",null,null,{"$f":"J63/H63","v":0},{"$f":"K63/H63","v":0}]
[]
[null,"* For construction of passive treatment system refer to \"Water Management\".  ARD/ML seepage treatment becomes post-closure water treatment cost"]
[null,"**Heap leach ARD/ML seepage treatment becomes post-closure water treatment cost"]

{"sheet":"Chemicals","index":7,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[[2,1,2,7]]}
[1,"Chemicals/Soil Area Name:"]
[]
[null,"Note:         The procedures, equipment and packaging for clean up and removal of chemicals or contaminated soils are highly dependent on the nature of the chemicals and their existing state of containment. Government guidelines should be consulted on an individual chemical basis.  Any estimate made here should be considered very rough unless specific evaluations have been conducted."]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost","% Land","Land Cost","Water Cost"]
[null,"HAZARDOUS MATERIALS AUDIT"]
[null,"Hazardous materials audit",null,"mandays",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,"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,"Decontaminate: oil, fuel",null,"mandays",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},0,null,0,0]
[null,"Decontaminate maintenance shop",null,"mandays",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F10),0,INDEX(IF(UPPER(RIGHT(F10,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F10,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F10,LEN(F10)-1)),CostCode,0)))","v":0},0,null,0,0]
[null,"Decontaminate power plant",null,"mandays",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Decontaminate bulk fuel storage",null,"mandays",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Decontaminate ANFO plant",null,"mandays",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Decontaminate offices/warehouse/accom",null,"mandays",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Removal of asbestos siding on buildings",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Removal of friable asbestos on equipment",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"HAZARDOUS MATERIALS REMOVAL"]
[null,"Waste oils",null,"litre",null,{"$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,{"$f":"H19*I19","v":0},{"$f":"+H19*(1-I19)","v":0}]
[null,"Waste fuel",null,"litre",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Waste batteries",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Assay & environmental lab reagents",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Machine shop paints, solvents etc",null,"litre",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Glycol",null,"litre",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Process reagents",null,"kg",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,0,0]
[null,"Nuclear sources",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F26),0,INDEX(IF(UPPER(RIGHT(F26,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F26,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F26,LEN(F26)-1)),CostCode,0)))","v":0},0,null,0,0]
[null,"Other hazardous materials",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,0,0]
[null,"HAZARDOUS MATERIALS "]
[null,"Transportation to disposal facility",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,{"$f":"H29*I29","v":0},{"$f":"+H29*(1-I29)","v":0}]
[null,"Disposal fees",null,"allow",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,{"$f":"H30*I30","v":0},{"$f":"+H30*(1-I30)","v":0}]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F31),0,INDEX(IF(UPPER(RIGHT(F31,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F31,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F31,LEN(F31)-1)),CostCode,0)))","v":0},{"$f":"G31*E31","v":0},null,{"$f":"H31*I31","v":0},{"$f":"+H31*(1-I31)","v":0}]
[null,"CONTAMINATED SOILS "]
[null,"Contam. soil investigation - Phase 1",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,"Contam. soil investigation - Phase 2",null,"each",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},0,null,0,0]
[null,"CONTAMINATED SOIL REMOVAL"]
[null,"Excavate and transport to onsite facility",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,"Manage hydrocarbon remediation at facility",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},0,null,0,0]
[null,"Reagents/stabilizing agent",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,{"$f":"H38*I38","v":0},{"$f":"+H38*(1-I38)","v":0}]
[null,"Excavate and transport to offsite facility",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},0,null,0,0]
[null,"Contour decontaminated area",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},0,null,{"$f":"H40*I40","v":0},{"$f":"+H40*(1-I40)","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(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,"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(F50),0,INDEX(IF(UPPER(RIGHT(F50,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F50,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F50,LEN(F50)-1)),CostCode,0)))","v":0},{"$f":"G50*E50","v":0},null,{"$f":"H50*I50","v":0},{"$f":"+H50*(1-I50)","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H6:H50)+0.0001","v":1E-4},null,{"$f":"SUM(J6:J50)","v":0},{"$f":"SUM(K6:K50)","v":0}]
[null,null,null,null,null,null,"% of Total",null,null,{"$f":"J51/H51","v":0},{"$f":"K51/H51","v":0}]

{"sheet":"Bldgs & Equip","index":8,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[1,"Building / Equip Name:",null,null,null,null,"Bldg / Equip #:",1]
[]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost","% Land","Land Cost","Water Cost"]
[null,"DISPOSE MOBILE EQUIPMENT"]
[null,"Decontaminate and ship off-site",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F5),0,INDEX(IF(UPPER(RIGHT(F5,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F5,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F5,LEN(F5)-1)),CostCode,0)))","v":0},{"$f":"G5*E5","v":0},null,{"$f":"H5*I5","v":0},{"$f":"+H5*(1-I5)","v":0}]
[null,"Decontaminate and dispose on-site",null,"allow",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,"Other",null,null,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,"REMOVE BUILDINGS - see note below"]
[null,"Accomodation Complex",null,"m2",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,"Process Facilities",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Offices, Repair, Lab, Warehouse",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Storage Facilites",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Water and Wastewater Treatment Facilities",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"U/G Heating Plant",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Emulsion Plant",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"AN Storage Facility",null,"m2",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,{"$f":"H16*I16","v":0},{"$f":"+H16*(1-I16)","v":0}]
[null,"Warehouse, Shops and Other",null,"m2",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,{"$f":"H17*I17","v":0},{"$f":"+H17*(1-I17)","v":0}]
[null,"Storage Facility at Laydown/Airstrip",null,"m2",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},0,null,{"$f":"H18*I18","v":0},{"$f":"+H18*(1-I18)","v":0}]
[null,"Fuel tanks",null,"m2",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},0,null,{"$f":"H19*I19","v":0},{"$f":"+H19*(1-I19)","v":0}]
[null,"Fuel Tanks",null,"m2",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},0,null,{"$f":"H20*I20","v":0},{"$f":"+H20*(1-I20)","v":0}]
[null,"Freshwater intake",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Reclaim pumps",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Outfall & Diffuser",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Airstrip lighting, navigation, electrician",null,"mandays",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,"Airstrip lighting, navigation, mechanical",null,"mandays",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,"Break foundation slabs","total of all buildings","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,{"$f":"H26*I26","v":0},{"$f":"+H26*(1-I26)","v":0}]
[null,"Consolidate & dump boneyard debris",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,"LANDFILL FOR DEMOLITION WASTE"]
[null,"Place rock cover","Blast rock fill","m3",null,{"$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,{"$f":"H30*I30","v":0},{"$f":"+H30*(1-I30)","v":0}]
[null,"Place soil cover","Soil Cap - Landfill and Septic Field","m3",null,{"$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,{"$f":"+H31*(1-I31)","v":0}]
[null,"Vegetate",null,"ha",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,"GRADE AND CONTOUR PADS"]
[null,"Accomodation Complex",null,"ha",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,"Process Facilities",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Offices, Repair, Lab, Warehouse",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Storage Facilites",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Water and Wastewater Treatment Facilities",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"U/G Heating Plant",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Emulsion Plant",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Warehouse, Shops and Other",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Place rock cover",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Vegetate",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"PUNCTURE LINED SUMPS"]
[null,"Puncture liner and place soil cover",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F46),0,INDEX(IF(UPPER(RIGHT(F46,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F46,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F46,LEN(F46)-1)),CostCode,0)))","v":0},{"$f":"G46*E46","v":0},null,{"$f":"H46*I46","v":0},{"$f":"+H46*(1-I46)","v":0}]
[null,"RECLAIM ROADS"]
[null,"Remove culverts",null,"each",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,0,0]
[null,"Remove bridges",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Scarify and install water breaks",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Scarify airstriip",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Scarify laydown areas",null,"ha",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,{"$f":"H53*I53","v":0},0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H54*I54","v":0},0]
[null,"SPECIALIZED ITEMS"]
[null,"Dispose of misc. debris and laydown area refuse",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F56),0,INDEX(IF(UPPER(RIGHT(F56,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F56,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F56,LEN(F56)-1)),CostCode,0)))","v":0},{"$f":"G56*E56","v":0},null,{"$f":"H56*I56","v":0},0]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H56)+0.0001","v":1E-4},null,{"$f":"SUM(J5:J56)","v":0},{"$f":"SUM(K5:K56)","v":0}]
[null,null,null,null,null,null,"% of Total",null,null,{"$f":"J57/H57","v":0},{"$f":"K57/H57","v":0}]
[]
[null,"Note:  Unit costs are based on 3m high, single storey building.  Scale larger building areas accordingly.  E.g.  10m high building multiply area by 3.3 (10/3)"]

{"sheet":"Water Management","index":9,"n_rows":58,"n_cols":8,"rows_kept":58,"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 DYKE EMBANKMENT"]
[null,"Remove fill",null,"m3",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,"Contour water intake area",null,"m3",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,"STABILIZE SEDIMENT PONDS/WATER MANAGEMENT PONDS"]
[null,"Place soil cover",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,"Doze & spread excavated material",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F9),0,INDEX(IF(UPPER(RIGHT(F9,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F9,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F9,LEN(F9)-1)),CostCode,0)))","v":0},{"$f":"G9*E9","v":0}]
[null,"Vegetate spread material",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F10),0,INDEX(IF(UPPER(RIGHT(F10,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F10,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F10,LEN(F10)-1)),CostCode,0)))","v":0},{"$f":"G10*E10","v":0}]
[null,"Rip rap in channel base",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},{"$f":"G11*E11","v":0}]
[null,"REDIRECT RUNOFF/CONSTRUCT DIVERSION DITCHES"]
[null,"Excavate ditches -soil",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,"Excavate ditches -rock",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F14),0,INDEX(IF(UPPER(RIGHT(F14,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F14,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F14,LEN(F14)-1)),CostCode,0)))","v":0},{"$f":"G14*E14","v":0}]
[null,"Stabilize side slopes",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},{"$f":"G15*E15","v":0}]
[null,"Rip rap in channel base",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},{"$f":"G16*E16","v":0}]
[null,"BREACH DITCHES"]
[null,"Excavate breaches",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,"Backfill/recontour",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,"Install flow dissipation",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,"Vegetate remainder of ditch",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,"DECOMISSION FRESH WATER SUPPLY"]
[null,"Breach embankment",null,"m",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,"Remove pump",null,"LS",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F24),0,INDEX(IF(UPPER(RIGHT(F24,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F24,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F24,LEN(F24)-1)),CostCode,0)))","v":0},{"$f":"G24*E24","v":0}]
[null,"Remove pipeline",null,"m",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,"WATER CONTROL IN RECLAMATION QUARRY"]
[null,"Install  pumping system",null,"LS",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F27),0,INDEX(IF(UPPER(RIGHT(F27,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F27,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F27,LEN(F27)-1)),CostCode,0)))","v":0},{"$f":"G27*E27","v":0}]
[null,"Remove pumping system",null,"LS",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 PIPELINES"]
[null,"Remove pipes",null,"m",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,"Concrete plug deep pipes",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,"Other",null,null,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,"GROUNDWATER COLLECTION SYSTEM"]
[null,"Excavate/install sumps",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,"Install pumping wells",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,"Install pumps/pipelines/power supply",null,"LS",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,"CONSTRUCT CONTAMINATED WATER STORAGE POND"]
[null,"Excavate pond",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,"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":"G46*E46","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(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,"Build sludge containment facility",null,"LS",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F54),0,INDEX(IF(UPPER(RIGHT(F54,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F54,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F54,LEN(F54)-1)),CostCode,0)))","v":0},{"$f":"G54*E54","v":0}]
[null,"SHORT TERM WATER TREATMENT*"]
[null,"Annual water treatment cost, from \"Water Treatment\"",null,null,null,null,null,0]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H56)+0.0001","v":1E-4}]
[null,"*Note: include water treatment cost from \"Water Treatment\" worksheet if treatment is considered short term and is not included in a particular component worksheet."]

{"sheet":"Water Treatment","index":10,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[1,"Water Treatment"]
[]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost"]
[null,"ADDITION OF REAGENTS"]
[null,"H2O2",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F5),0,INDEX(IF(UPPER(RIGHT(F5,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F5,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F5,LEN(F5)-1)),CostCode,0)))","v":0},{"$f":"G5*E5","v":0}]
[null,"lime",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"ferric sulphate",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"ferrous sulphate",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"flocculents",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"LABOUR AND SUPPLIES"]
[null,"Annual fuel",null,"litres",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F12),0,INDEX(IF(UPPER(RIGHT(F12,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F12,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F12,LEN(F12)-1)),CostCode,0)))","v":0},{"$f":"G12*E12","v":0}]
[null,"Annual power",null,"kW-h",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F13),0,INDEX(IF(UPPER(RIGHT(F13,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F13,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F13,LEN(F13)-1)),CostCode,0)))","v":0},{"$f":"G13*E13","v":0}]
[null,"Electrician/mechanic to maintain treatment plant",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Equipment maintenance and parts",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Misc. supplies, hoses, tools",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Communications",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"WATER SAMPLING AND ANALYSES"]
[null,"Sampling equipment",null,"allow",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,"Analyses",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,"Shipping to laboratory",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F22),0,INDEX(IF(UPPER(RIGHT(F22,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F22,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F22,LEN(F22)-1)),CostCode,0)))","v":0},{"$f":"G22*E22","v":0}]
[null,"Reporting",null,"allow",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,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F24),0,INDEX(IF(UPPER(RIGHT(F24,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F24,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F24,LEN(F24)-1)),CostCode,0)))","v":0},{"$f":"G24*E24","v":0}]
[null,"SITE ACCESS"]
[null,"Road maintenance (incl. snow removal)",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,"Winter road tariff",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,"Truck rental",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,"Air support",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,null,null,null,null,null,"Annual water treatment costs",{"$f":"SUM(H5:H30)+0.0001","v":1E-4}]
[null,"Number of years of water treatment",null,"years"]
[null,null,null,null,null,null,"Total",{"$f":"AnnualTreat1Cost*E32","v":0}]
[]
[null,"Note: Short term water treattment is intended to be included in \"Water Management\", whereas long term, or post-closure, water treatment is included in"]
[null,"\"Post-Closure Monitoring and Maintenance\""]

{"sheet":"PostClosure","index":11,"n_rows":36,"n_cols":8,"rows_kept":36,"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",null,"each",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,"Survey inspection",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Regulatory costs*",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G7*E7","v":0}]
[null,"Site water monitoring (AEMP and SNP)",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F8),0,INDEX(IF(UPPER(RIGHT(F8,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F8,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F8,LEN(F8)-1)),CostCode,0)))","v":0},0]
[null,"   - 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(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,"Vegetation Monitoring",null,"each",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,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F14),0,INDEX(IF(UPPER(RIGHT(F14,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F14,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F14,LEN(F14)-1)),CostCode,0)))","v":0},{"$f":"G14*E14","v":0}]
[null,"COVER MAINTENANCE"]
[null,"Repair erosion - infill gullies",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G16*E16","v":0}]
[null,"Repair erosion - upgrade diversion ditches",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Remove problem vegetation",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Repair animal damage",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Repair/upgrade access controls",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"SPILLWAY MAINTENANCE"]
[null,"Repair erosion",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G23*E23","v":0}]
[null,"Clear spillway",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G24*E24","v":0}]
[null,"CWTS MAINTENANCE"]
[null,"Maintain flow, restore vegetation",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,"POST-CLOSURE WATER TREATMENT**"]
[null,"Annual water treatment cost, from \"Water Treatment\"",null,null,null,null,null,0]
[]
[null,"Subtotal, Annual post-closure costs",null,null,null,null,null,{"$f":"SUM(H5:H29)+0.0001","v":1E-4}]
[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,null,"years"]
[null,"Present Value of payment stream",null,null,null,null,null,{"$f":"PV(DiscountRate,PCYears, PCAnnualTotal)*-1","v":0}]
[]
[null,"*Regulatory costs - annual reporting, management plans, progress reports etc."]
[null,"Include water treatment cost from \"Water Treatment\" worksheet if treatment is considered long term, such as ARD/ML."]

{"sheet":"ICM","index":12,"n_rows":21,"n_cols":8,"rows_kept":21,"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",null,"manmonths",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,"extra personnel",null,"manmonths",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"    -electrician",null,"manmonths",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,"    -mechanic",null,"manmonths",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,"annual fuel",null,"litre",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"misc. supplies",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F10),0,INDEX(IF(UPPER(RIGHT(F10,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F10,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F10,LEN(F10)-1)),CostCode,0)))","v":0},{"$f":"G10*E10","v":0}]
[null,"pick-up truck",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"small dozer",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"small excavator",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"snow machine",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"communications",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"SNP/AEMP water sampling & reporting",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"geotechnical assessment",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"interim water treatment",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},null,{"$f":"AnnualTreat1Cost","v":1E-4}]
[null,"other",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,null,null,null,null,null,"Annual  Interim C&M Cost",{"$f":"SUM(H5:H19)","v":1E-4}]
[null,"Number of years of ICM",null,"years",null,null,"Total",{"$f":"H20*E21","v":0}]

{"sheet":"Mobilization","index":13,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[1,"Mobilization/Demobilization:"]
[]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost"]
[null,"MOBILIZE HEAVY EQUIPMENT"]
[null,"Excavators",null,"each",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,"Dump trucks",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Dozers",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Demolition shears",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Crane",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Loader",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G10*E10","v":0}]
[null,"Compactor",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G11*E11","v":0}]
[null,"Light duty vehicles",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"MOBILIZE MISC. EQUIPMENT"]
[null,"Pump shipping",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F14),0,INDEX(IF(UPPER(RIGHT(F14,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F14,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F14,LEN(F14)-1)),CostCode,0)))","v":0},{"$f":"G14*E14","v":0}]
[null,"Pipe shipping",null,"m",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F15),0,INDEX(IF(UPPER(RIGHT(F15,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F15,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F15,LEN(F15)-1)),CostCode,0)))","v":0},{"$f":"G15*E15","v":0}]
[null,"Minor tools and equipment",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$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},{"$f":"G16*E16","v":0}]
[null,"Truck tires ",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F17),0,INDEX(IF(UPPER(RIGHT(F17,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F17,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F17,LEN(F17)-1)),CostCode,0)))","v":0},{"$f":"G17*E17","v":0}]
[null,"Other",null,null,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},0]
[null,"MOBILIZE CAMP"]
[null,"Reclamation activities",null,"allow",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,"Long term reclamation activities (eg pump flooding)",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,"MOBILIZE WORKERS"]
[null,"Reclamation activities - transport",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F23),0,INDEX(IF(UPPER(RIGHT(F23,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F23,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F23,LEN(F23)-1)),CostCode,0)))","v":0},{"$f":"G23*E23","v":0}]
[null,"Reclamation activities - travel time",null,"manhours",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F24),0,INDEX(IF(UPPER(RIGHT(F24,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F24,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F24,LEN(F24)-1)),CostCode,0)))","v":0},{"$f":"G24*E24","v":0}]
[null,"Long term reclamation activities (eg pump flooding) - transport",null,"each",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,"Long term reclamation activities (eg pump flooding) - travel time",null,"each",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,"Monitoring Airfare",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," WORKER ACCOMODATIONS"]
[null,"Reclamation activities",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,"Long term reclamation activities (eg pump flooding)",null,"manmonths",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,"MOBILIZE FUEL"]
[null,"Fuel freight - reclamation activities",null,"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 - long term reclamation activities",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,"Fuel freight accomodations",null,"litre",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,"WINTER ROAD"]
[null,"Construction and operation",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,"Limited winter use",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,"Winter road tarriff",null,"km",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,"DEMOBILIZE HEAVY EQUIPMENT"]
[null,"Excavators",null,"km",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,"Dump trucks",null,"km",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F41),0,INDEX(IF(UPPER(RIGHT(F41,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F41,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F41,LEN(F41)-1)),CostCode,0)))","v":0},0]
[null,"Dozers",null,"km",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Demolition shears",null,"km",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Crane",null,"km",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Loader",null,"km",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,"Compactor",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,"Light duty vehicles",null,"km",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Other",null,"km",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"DEMOBILIZE CAMP"]
[null,null,null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F50),0,INDEX(IF(UPPER(RIGHT(F50,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F50,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F50,LEN(F50)-1)),CostCode,0)))","v":0},{"$f":"G50*E50","v":0}]
[null,"DEMOBILIZE WORKERS"]
[null,"crew travel time",null,"mandays",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,"crew transportation",null,"each",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,"WINTER ROAD"]
[null,"Construction and operation",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,"Limited winter use",null,"km",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F56),0,INDEX(IF(UPPER(RIGHT(F56,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F56,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F56,LEN(F56)-1)),CostCode,0)))","v":0},{"$f":"G56*E56","v":0}]
[null,"Winter road tarriff",null,"km",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,null,null,null,null,null,"Total",{"$f":"SUM(H5:H57)+0.0001","v":1E-4}]

{"sheet":"Unit_Costs","index":14,"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]
[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":15,"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]