{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Instructions","Summary","Wells & Facilities","Bldgs & Equip","Chemicals","Water Management","Water Treatment","ICM","PostClosure","Mobilization","Unit_Costs","Estimator","Tools"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":121,"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":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["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,"","",""]

{"sheet":"Summary","index":1,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"SUMMARY OF COSTS"]
[]
["CAPITAL COSTS","COMPONENT NAME",null,"COST",null,"LAND LIABILITY",null,"WATER LIABILITY"]
["WELLS AND FACILITIES",{"$f":"IF(ISBLANK('Wells & Facilities'!$C$1),\"\",'Wells & Facilities'!$C$1)","v":""},null,{"$f":"RP1Total","v":0},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":1500.0001},null,{"$f":"Bldg1LandTotal","v":1500},null,{"$f":"Bldg1WaterTotal","v":0}]
["CHEMICALS AND CONTAMINATED SOIL MANAGEMENT"," ",null,{"$f":"Chem1Total","v":121000.0001},null,{"$f":"Chem1LandTotal","v":90875},null,{"$f":"Chem1WaterTotal","v":30125}]
["SURFACE AND GROUNDWATER MANAGEMENT",{"$f":"IF(ISBLANK('Water Treatment'!$C$1),\"\",'Water Treatment'!$C$1)","v":""},null,{"$f":"Water1Total","v":15940.400199999998},null,"-",null,{"$f":"Water1Total","v":15940.400199999998}]
["INTERIM CARE AND MAINTENANCE",{"$f":"IF(ISBLANK(ICM!$C$1),\"\",ICM!$C$1)","v":""},null,{"$f":"ICMTotal","v":12350.000099999999},null,"-",null,{"$f":"ICMTotal","v":12350.000099999999}]
[null,"SUBTOTAL: Capital Costs",null,{"$f":"SUM(D4:D8)","v":150790.40050000002},null,{"$f":"SUM(F4:F8)","v":92375},null,{"$f":"SUM(H4:H8)","v":58415.400299999994}]
[null,"PERCENT OF SUBTOTAL ",null,null,null,{"$f":"IF(F9<0.01,0,F9/D9)","v":0.61260530971266958},null,{"$f":"IF(H9<0.01,0,H9/D9)","v":0.38739468896098589}]
[]
["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":"D13*$F$10","v":6.1260530971266961E-5},null,{"$f":"D13*$H$10","v":3.8739468896098588E-5}]
["POST-CLOSURE MONITORING AND MAINTENANCE",{"$f":"IF(ISBLANK(PostClosure!$C$1),\"\",PostClosure!$C$1)","v":""},null,{"$f":"PC1Total","v":0},null,{"$f":"D14*$F$10","v":0},null,{"$f":"D14*$H$10","v":0}]
["ENGINEERING ",0.05,null,{"$f":"B15*$D$9","v":7539.5200250000016},null,{"$f":"+$F$10*D15","v":4618.75},null,{"$f":"+$H$10*D15","v":2920.7700150000001}]
["PROJECT MANAGEMENT",0.05,null,7539.5200250000016,null,4618.75,null,2920.7700150000001]
["HEALTH AND SAFETY PLANS/MONITORING & QA/QC",null,null,0,null,0,null,0]
["BONDING/INSURANCE",null,null,0,null,0,null,0]
["CONTINGENCY ",0.2,null,30158.080100000006,null,18475,null,11683.08006]
["MARKET PRICE FACTOR ADJUSTMENT",null,null,0,null,0,null,0]
[null,"SUBTOTAL: Indirect Costs",null,{"$f":"SUM(D13:D20)","v":45237.120250000007},null,{"$f":"SUM(F13:F20)","v":27712.500061260529},null,{"$f":"SUM(H13:H20)","v":17524.620128739469}]
[]
["TOTAL COSTS",null,null,{"$f":"D9+D13+D14+D21","v":196027.52085000003},null,{"$f":"F9+F13+F14+F21","v":120087.50012252107},null,{"$f":"H9+H13+H14+H21","v":75940.020467478927}]

{"sheet":"Wells & Facilities","index":2,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[1,"Wells and Facilities"]
[]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost","% Land","Land Cost","Water Cost"]
[null,"OBJECTIVE: ABANDONMENT OF WELLS"]
[null,"All wells- Drilled / Cased",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,"Sweet Well - Completed / Active / Inactive",null,"m",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Sour Well (H2S>1%) - Completed / Active / Inactive",null,"m",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Vent Flow / Gas Migration",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Additional Completion Zones",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"OBJECTIVE: ABANDONMENT OF PRODUCTION FACILITIES"]
[null,"Oil / bitumen process or injection / disposal facility",null,"m3/day",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,"Gas processing facility",null,"m3/day",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Gas dehydration facility",null,"m3/day",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,{"$f":"H13*I13","v":0},{"$f":"+H13*(1-I13)","v":0}]
[null,"Compressor station",null,"KW",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Battery sites",null,"m3/day",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Battery sites w/ separation, compression, injection and/or disposal equipment",null,"m3/day",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Satellite batteries",null,"m3/day",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Other stations",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,null,null,null,null,null,"Total",0,null,{"$f":"SUM(J5:J18)","v":0},{"$f":"SUM(K5:K18)","v":0}]
[null,null,null,null,null,null,"% of Total",null,null,{"$f":"J19/H19*100","v":{"$error":"#DIV/0!"}},{"$f":"K19/H19*100","v":{"$error":"#DIV/0!"}}]

{"sheet":"Bldgs & Equip","index":3,"n_rows":79,"n_cols":11,"rows_kept":79,"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,"OBJECTIVE: DISPOSE MOBILE EQUIPMENT"]
[null,"Decontaminate and ship off-site",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,{"$f":"H5*I5","v":0},{"$f":"+H5*(1-I5)","v":0}]
[null,"Decontaminate, dispose on-site",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,"Other",null,"each",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,"OBJECTIVE:  BUILDING DECONTAMINATION & HAZ. MATERIAL REMOVAL"]
[null,"Decontaminate, oil, fuel and glycol systems",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},{"$f":"G9*E9","v":0},null,0,0]
[null,"Decontaminate, general ",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,"Mechanical",null,"mandays",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F11),0,INDEX(IF(UPPER(RIGHT(F11,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F11,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F11,LEN(F11)-1)),CostCode,0)))","v":0},0,null,0,0]
[null,"Electrical",null,"mandays",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F12),0,INDEX(IF(UPPER(RIGHT(F12,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F12,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F12,LEN(F12)-1)),CostCode,0)))","v":0},0,null,0,0]
[null,"Decontaminate maintenance shop",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,0,0]
[null,"Decontaminate power plant",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Decontaminate bulk fuel storage",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Deontaminate offices/warehouse/accom",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Removal of asbestos siding on buildings",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Removal of friable asbestos on equipment",null,"each",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,"OBJECTIVE: REMOVE BUILDINGS - ALL BUILDING AREAS SCALED TO ACCOUNT FOR HEIGHT"]
[null,"Accomodation Complex",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,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","relocate shed","m2",0,"BRWl",27.5,0,1,0,0]
[null,"Water and Wastewater Treatment Facilities","relocate ","alloc",1,{"$f":"NA()","v":{"$error":"#N/A"}},500,500,1,500,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(F28),0,INDEX(IF(UPPER(RIGHT(F28,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F28,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F28,LEN(F28)-1)),CostCode,0)))","v":0},0,null,{"$f":"H28*I28","v":0},{"$f":"+H28*(1-I28)","v":0}]
[null,"Warehouse, Shops and Other",null,"m2",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},0,null,{"$f":"H29*I29","v":0},{"$f":"+H29*(1-I29)","v":0}]
[null,"Storage Facility at Laydown/Airstrip",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F30),0,INDEX(IF(UPPER(RIGHT(F30,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F30,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F30,LEN(F30)-1)),CostCode,0)))","v":0},0,null,{"$f":"H30*I30","v":0},{"$f":"+H30*(1-I30)","v":0}]
[null,"Fuel tanks",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F31),0,INDEX(IF(UPPER(RIGHT(F31,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F31,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F31,LEN(F31)-1)),CostCode,0)))","v":0},0,null,{"$f":"H31*I31","v":0},{"$f":"+H31*(1-I31)","v":0}]
[null,"Fuel Tanks",null,"m2",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},0,null,{"$f":"H32*I32","v":0},{"$f":"+H32*(1-I32)","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(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},0,null,0,0]
[null,"Airstrip lighting, navigation, mechanical",null,"mandays",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,"Consolidate & dump boneyard debris",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"other - storage tanks","assumed 2 required - clean & relocate","alloc",2,{"$f":"NA()","v":{"$error":"#N/A"}},500,1000,1,1000,0]
[null,"OBJECTIVE: BREAK BASEMENT SLABS"]
[null,"Accomodation Complex",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F41),0,INDEX(IF(UPPER(RIGHT(F41,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F41,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F41,LEN(F41)-1)),CostCode,0)))","v":0},{"$f":"G41*E41","v":0},null,0,{"$f":"+H41*(1-I41)","v":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,{"$f":"H47*I47","v":0},{"$f":"+H47*(1-I47)","v":0}]
[null,"Warehouse, Shops and Other",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H48*I48","v":0},{"$f":"+H48*(1-I48)","v":0}]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"OBJECTIVE: LANDFILL FOR DEMOLITION WASTE"]
[null,"Place soil cover",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,"Vegetate",null,"ha",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,"Landfill disposal fee",null,"tonne",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,"OBJECTIVE: GRADE AND CONTOUR "]
[null,"Accomodation Complex",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F55),0,INDEX(IF(UPPER(RIGHT(F55,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F55,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F55,LEN(F55)-1)),CostCode,0)))","v":0},{"$f":"G55*E55","v":0},null,0,0]
[null,"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,"OBJECTIVE: LINED SUMPS"]
[null,"Puncture liner and place soil cover",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F67),0,INDEX(IF(UPPER(RIGHT(F67,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F67,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F67,LEN(F67)-1)),CostCode,0)))","v":0},{"$f":"G67*E67","v":0},null,{"$f":"H67*I67","v":0},{"$f":"+H67*(1-I67)","v":0}]
[null,"OBJECTIVE: RECLAIM ROADS"]
[null,"Remove culverts",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,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":"H74*I74","v":0},0]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H75*I75","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(F77),0,INDEX(IF(UPPER(RIGHT(F77,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F77,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F77,LEN(F77)-1)),CostCode,0)))","v":0},{"$f":"G77*E77","v":0},null,{"$f":"H77*I77","v":0},0]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H77)+0.0001","v":1500.0001},null,{"$f":"SUM(J5:J77)","v":1500},{"$f":"SUM(K5:K77)","v":0}]
[null,null,null,null,null,null,"% of Total",null,null,{"$f":"J78/H78*100","v":99.999993333333776},{"$f":"K78/H78*100","v":0}]

{"sheet":"Chemicals","index":4,"n_rows":44,"n_cols":11,"rows_kept":44,"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,"Phase 1 audit",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,"Phase 2 audit",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G7*E7","v":0},null,{"$f":"H7*I7","v":0},{"$f":"+H7*(1-I7)","v":0}]
[null,"CONSOLIDATE HAZARDOUS MATERIALS FOR REMOVAL"]
[null,"Waste oils",null,"litre",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G9*E9","v":0},null,{"$f":"H9*I9","v":0},{"$f":"+H9*(1-I9)","v":0}]
[null,"Fuel - Type 1, eg diesel dregs",null,"litre",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Fuel - Type 1, eg gasoline dregs",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,"Contaminated soils - hydrocarbon",null,"m3",2500,"CSRl",{"$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":47},117500,0.75,{"$f":"H15*I15","v":88125},{"$f":"+H15*(1-I15)","v":29375}]
[null,"Metal contam. soil at conc. load-out",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H16*I16","v":0},{"$f":"+H16*(1-I16)","v":0}]
[null,"Glycol",null,"litre",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H17*I17","v":0},{"$f":"+H17*(1-I17)","v":0}]
[null,"Nuclear sources",null,"each",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,"HAZARDOUS MATERIALS "]
[null,"Transportation to disposal facility","assumed reagants, untreatable soils, etc ","allow",1,{"$f":"NA()","v":{"$error":"#N/A"}},1500,{"$f":"G20*E20","v":1500},0.5,{"$f":"H20*I20","v":750},{"$f":"+H20*(1-I20)","v":750}]
[null,"Disposal fees",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,{"$f":"H21*I21","v":0},{"$f":"+H21*(1-I21)","v":0}]
[null,"Other",null,null,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,"CONTAMINATED SOILS "]
[null,"Contam. soil investigation - technical",null,"each",2,{"$f":"NA()","v":{"$error":"#N/A"}},1000,{"$f":"G24*E24","v":2000},1,{"$f":"H24*I24","v":2000},{"$f":"+H24*(1-I24)","v":0}]
[null,"Contam. soil investigation - drilling & sampling",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},0,null,0,0]
[null,"CONTAMINATED SOIL REMOVAL"]
[null,"Contaminated soils - hydrocarbon",null,"m2",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},0,null,0,0]
[null,"Metal contam. soil at conc. load-out",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Load, haul, dump or doze",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Reagents/stabilizing agent",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H30*I30","v":0},{"$f":"+H30*(1-I30)","v":0}]
[null,"Contour reclaimed area",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H31*I31","v":0},{"$f":"+H31*(1-I31)","v":0}]
[null,"Type 2, heavy fuel and oil",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,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(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,"Upper and lower bedding layers",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Install geomembrane, HDPE, ES3, GCL",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Erosion protection layer",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Vegetate",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,0,0]
[null,"Install infiltration/seepage instrumentation",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H39*I39","v":0},{"$f":"+H39*(1-I39)","v":0}]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0,null,{"$f":"H40*I40","v":0},{"$f":"+H40*(1-I40)","v":0}]
[null,"OTHER"]
[null,null,null,null,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,null,null,null,null,null,"Total",{"$f":"SUM(H9:H42)+0.0001","v":121000.0001},null,{"$f":"SUM(J5:J42)","v":90875},{"$f":"SUM(K9:K42)","v":30125}]
[null,null,null,null,null,null,"% of Total",null,null,{"$f":"J43/H43*100","v":75.103305723055115},{"$f":"K43/H43*100","v":24.896694194300252}]

{"sheet":"Water Management","index":5,"n_rows":55,"n_cols":8,"rows_kept":55,"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,"OBJECTIVE: STABILIZE SEDIMENT PONDS/WATER MANAGEMENT PONDS"]
[null,"Place soil cover",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,"Doze & spread excavated material","contour berms - 2000m2","m3",2000,"DSl",{"$f":"IF(ISNA(F6),0,INDEX(IF(UPPER(RIGHT(F6,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F6,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F6,LEN(F6)-1)),CostCode,0)))","v":0.95},{"$f":"G6*E6","v":1900}]
[null,"Vegetate spread material",null,"ha",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,"Rip rap in channel base",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},{"$f":"G8*E8","v":0}]
[null,"Puncture liner ","restore natural drainage - 2 people, 1 day","manhrs",24,"Lab-sl",{"$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":49.6},{"$f":"G9*E9","v":1190.4000000000001}]
[null,"OBJECTIVE: REDIRECT RUNOFF/CONSTRUCT DIVERSION DITCHES"]
[null,"Excavate ditches -soil",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,"Excavate ditches -rock",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F12),0,INDEX(IF(UPPER(RIGHT(F12,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F12,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F12,LEN(F12)-1)),CostCode,0)))","v":0},{"$f":"G12*E12","v":0}]
[null,"Stabilize side slopes",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,"Rip rap in channel base",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,"OBJECTIVE: BREACH DITCHES"]
[null,"Excavate breaches",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,"Backfill/recontour",null,"m3",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,"Install flow dissipation",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,"Vegetate remainder of ditch",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},{"$f":"G19*E19","v":0}]
[null,"OBJECTIVE: FRESH WATER SUPPLY"]
[null,"Breach embankment",null,"m",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,"Remove pump",null,"LS",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,"Remove pipeline",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,"OBJECTIVE: WATER CONTROL IN RECLAMATION QUARRY"]
[null,"Install  pumping system",null,"LS",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,"Remove pumping system","allocation","LS",1,{"$f":"NA()","v":{"$error":"#N/A"}},500,{"$f":"G26*E26","v":500}]
[null,"OBJECTIVE: REMOVE WATER PIPELINES"]
[null,"Remove pipes",null,"m",null,"PSRl",{"$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":1},{"$f":"G28*E28","v":0}]
[null,"Concrete plug deep pipes",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,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F30),0,INDEX(IF(UPPER(RIGHT(F30,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F30,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F30,LEN(F30)-1)),CostCode,0)))","v":0},{"$f":"G30*E30","v":0}]
[null,"OBJECTIVE: GROUNDWATER COLLECTION SYSTEM"]
[null,"Excavate/install sumps",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,"Install pumping wells",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F33),0,INDEX(IF(UPPER(RIGHT(F33,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F33,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F33,LEN(F33)-1)),CostCode,0)))","v":0},{"$f":"G33*E33","v":0}]
[null,"Install pumps/pipelines/power supply",null,"LS",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F34),0,INDEX(IF(UPPER(RIGHT(F34,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F34,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F34,LEN(F34)-1)),CostCode,0)))","v":0},{"$f":"G34*E34","v":0}]
[null,"OBJECTIVE: CONSTRUCT CONTAMINATED WATER STORAGE POND"]
[null,"Excavate pond",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,"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,"OBJECTIVE: CONSTRUCT PASSIVE TREATMENT SYSTEM (e.g. Constructed Wetland)"]
[null,"Construct access roads",null,"km",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G44*E44","v":0}]
[null,"install HDPE piping system from collection pond",null,"m",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G45*E45","v":0}]
[null,"Inter-cell flow structures",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Install liners",null,"m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G47*E47","v":0}]
[null,"Install growth media",null,"m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Wetland vegetation",null,"ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"OBJECTIVE: CONSTRUCT WATER TREATMENT PLANT"]
[null,"Build treatment plant ",null,"LS",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,"Build sludge containment facility",null,"LS",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,"OBJECTIVE: WATER TREATMENT "]
[null,"Water treatment - smapling and reporting","From Water Treatment Spreadsheet","alloc",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":"WaterTreatCost","v":12350.000099999999}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H4:H54)+0.0001","v":15940.400199999998}]

{"sheet":"Water Treatment","index":6,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[1,"Post Closure Water Treatment - Identified as long term/post-closure in 'Instructions' worksheet"]
[]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost"]
[null,"OBJECTIVE: ADDITION OF REAGENTS TO WTP"]
[null,"H2O2",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(F5),0,INDEX(IF(UPPER(RIGHT(F5,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F5,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F5,LEN(F5)-1)),CostCode,0)))","v":0},{"$f":"G5*E5","v":0}]
[null,"lime",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"ferric sulphate",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"ferrous sulphate",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"flocculents",null,"kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Other - WTP operation",null,"m3",175,"OTPh",2,350]
[null,"OBJECTIVE: 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,"OBJECTIVE: WTP 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",1,"WSl",{"$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":7000},{"$f":"G21*E21","v":7000}]
[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 (annual Reporting, O&M, Spill Contingency, etc)",null,"allow",1,null,5000,{"$f":"G23*E23","v":5000}]
[null,"Other - Misc sampling and shipping",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G24*E24","v":0}]
[null,"OBJECTIVE: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":12350.000099999999}]
[null,"Number of years of water treatment",null,"years",1]
[null,null,null,null,null,null,"Total water treatment costs",{"$f":"AnnualTreat1Cost*E32","v":12350.000099999999}]

{"sheet":"ICM","index":7,"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":12350.000099999999}]
[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":12350.000099999999}]
[null,"Number of years of ICM",null,"years",1,null,"Total Cost",{"$f":"H20*E21","v":12350.000099999999}]

{"sheet":"PostClosure","index":8,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[1,"Post-Closure Monitoring &  Maintenance:"]
[]
[null,"ACTIVITY/MATERIAL","Notes","Units","Quantity","Cost Code","Unit Cost","Cost"]
[null,"OBJECTIVE: 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,"Site water monitoring (AEMP and SNP)",null,"each",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},0]
[null,"   - During pit 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(F11),0,INDEX(IF(UPPER(RIGHT(F11,1))=Low,UnitCostLow, IF(UPPER(RIGHT(F11,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(F11,LEN(F11)-1)),CostCode,0)))","v":0},0]
[null,"Vegetation Monitoring",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Other",null,null,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,"OBJECTIVE: SITE MAINTENANCE"]
[null,"Repair erosion - infill gullies",null,"allow",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G15*E15","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":"G22*E22","v":0}]
[null,"Clear spillway",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G23*E23","v":0}]
[null,"Other",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"G24*E24","v":0}]
[null,"POST-CLOSURE WATER TREATMENT"]
[null,"Annual water treatment cost, from \"Water Treatment\"",null,null,null,null,null,{"$f":"AnnualTreat1Cost","v":12350.000099999999}]
[]
[null,"Subtotal, Annual post-closure costs",null,null,null,null,null,{"$f":"SUM(H5:H27)+0.0001","v":12350.000199999999}]
[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}]

{"sheet":"Mobilization","index":9,"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 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 OTHER INFRASTRUCTURE AND SITE 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,"Remaining camp facilities",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,"Mobilization/Demobilization Cost",{"$f":"SUM(H4:H36)+0.0001","v":1E-4}]

{"sheet":"Unit_Costs","index":10,"n_rows":213,"n_cols":12,"rows_kept":213,"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,"areas are per floor of 3 m average height",null,null,null,"","",""]
[null,"Wood",null,"BRW","m2",27.5,41]
[null,"Concrete",null,"BRC","m2",40,65]
[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,"Remediate on site",null,"CSR","m3",47,146]
[null,"Env. investigation Phase I/II",null,"CSEI","each",25000,null,null,null,"Low: small, \"clean\" site"]
["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.7,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",null,null,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",13.5,20.65]
[null,"source is waste dump/short haul",null,"RR3","m3",5.2,7]
[null,"source is waste dump/long haul",null,"RR4","m3",5.7,7.6]
[null,"specified rip rap source",null,"RR5","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.3,7.3]
[null,"SB1 + spread and compact",null,"SB3","m3",4.5,6.5,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,"",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,"Low:doze frost heaves; 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.5,14.2,null,null,"Low: non-engineered; High:engineered"]
[null,"SC2 + spread and compact",null,"SC4","m3",8.9,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 operating cost automative",null,"FOA","litre",1.05,null,null,null,null,null," "]
[null,"Fuel operating cost non-automative",null,"FONA","litre",0.99,1.31]
[null,"Fuel mobilization",null,"FM","litre",0.22,0.42,null,null,"High: winter road usage"]
[null,"Electricity",null,"FE","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,"Manager",null,"Sman","$/hr",125,null,""]
[null,"Superintendant",null,null,"$/hr",103.54,null,""]
[null,"Registered engineer",null,"Eng","$/hr",220]
[null,"Environmental coordinator",null,"Envco","$/hr",74.16]
[null,"Electrician",null,"Elec","$/hr",74]
[null,"Journeyman - various",null,"Jour","$/hr",71.790000000000006]
[null,"Labour - skilled ",null,"Lab-s","$/hr",49.6]
[null,"Labour - unskilled",null,"Lab-us","$/hr",43.98,50,""]
[null,"Equipment operator",null,"oper","$/hr",65,80,""]
[null,"Heavy duty mechanic",null,"mech","$/hr",72.849999999999994]
[null,"Water treatment plant operator",null,"oper-wt","$/hr",59.86]
[null,"Security / first aid",null,"safety","$/hr",66.97,null,""]
[null,"Administative staff",null,"admin","$/hr",57.89,null,""]
[]
[null,"Equipment rates include operator and fuel unless specified"]
[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",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","each",25.5]
["Process Chemicals",null,null,null,null,"","",""]
[null,"Remove from site",null,"PCR","kg",0.45,2.5]
["Pumps",null,null,null,null,"","",""]
[null,"Pump capital cost",null,"PCR","each",195000]
[null,"Pump shipping",null,"PS","each",2500]
[null,"Pump maintenance",null,"PM","each",20000]
["Pump sand BackFill",null,null,null,null,"","",""]
[null,null,null,"BF","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,"CSW","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,"BTPS","lump sum",1218600,2437300]
[null,"Large (> 1000 m3/d)",null,"BTPL","lump sum",2437300,42650200]
["Treatment Plant - Operate"]
[null,null,null,"OTP","m3",0.35,2]
["Vegetation",null,null,null,null,"","",""]
[null,"Hydroseed, Flat",null,"VHF","ha",4000]
[null,"Hydroseed, Sloped",null,"VHS","ha",6000]
[null,"veg. Blanket/erosion mat",null,"VB","ha"]
[null,"Tree planting",null,"VT","ha"]
[null,"Wetland species",null,"VW","ha",50000,null,47.72,null,"Specified= /m3, Wetland Growth Media Substrate mixed and installed (sand-local, biochar and fertilizer, woodchips-local)"]
["Water Sampling/Analysis/Reporting"]
[null,null,null,"WS","each",7000,10000]
["Water 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.51,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,"",""]
["Winter Road"]
[null,"Construction",null,"WRC","km",2000,11500]
[null,"Usage",null,"WRU","kmtonne",0.28999999999999998]
[]
["Well Abandonment"]
[null,"All wells - Drilled / Cased",null,null,"m",null,null,12500,null,"-"]
[null,"Sweet Well - Completed / Active / Inactive",null,null,"m",null,null,56600,null,"0 - 1000 m"]
[null,null,null,null,"m",null,null,71200,null,"1000 - 2000 m"]
[null,null,null,null,"m",null,null,88000,null,"2000 - 3000 m"]
[null,null,null,null,"m",null,null,104900,null,">3000 m"]
[null,"Sour Well (H2S > 1%) - Completed / Active / Inactive",null,null,"m",null,null,74700,null,"0 - 1000 m"]
[null,null,null,null,"m",null,null,94400,null,"1000 - 2000 m"]
[null,null,null,null,"m",null,null,116500,null,"2000 - 3000 m"]
[null,null,null,null,"m",null,null,138600,null,">3000 m"]
[null,"Source Water Well",null,null,"m",null,null,5000,null,"0 - 150 m"]
[null,null,null,null,"m",null,null,10000,null,"151 - 300 m"]
[null,null,null,null,"m",null,null,30000,null,">300 m"]
[null,"Vent Flow / Gas Migration",null,null,null,null,null,87200,null,"-"]
[null,"Additional Completion Zones",null,null,null,null,null,"Add 30% per zone",null,"-"]
["Facility Abandonment"]
[null,"Oil / bitumen processing or injection / disposal facility",null,null,"m3/day",null,null,50000,null,"0 - 50 m3/d"]
[null,null,null,null,"m3/day",null,null,100000,null,">50 m3 < 500 m3/d"]
[null,null,null,null,"m3/day",null,null,200000,null,">50 m3 < 3000 m3/d"]
[null,null,null,null,"m3/day",null,null,400000,null,">3000 m3/d"]
[null,"Gas processing facility",null,null,"m3/day",null,null,192900,null,"0 - 999 e3m3/d"]
[null,null,null,null,"m3/day",null,null,372200,null,"1000 - 2999 e3m3/d"]
[null,null,null,null,"m3/day",null,null,500700,null," 3000 - 4999 e3m3/d"]
[null,null,null,null,"m3/day",null,null,638700,null," >5000 e3m3/d"]
[null,"Gas dehydration facility",null,null,"m3/day",null,null,53000,null,"0 - 299 e3m3/d"]
[null,null,null,null,"m3/day",null,null,132500,null,"300 - 1499 e3m3/d"]
[null,null,null,null,"m3/day",null,null,238700,null," >1500 e3m3/d"]
[null,"Compressor stations",null,null,"KW",null,null,46600,null,"0 - 599 KW"]
[null,null,null,null,"KW",null,null,113600,null,"600 - 2999 KW"]
[null,null,null,null,"KW",null,null,210500,null,">3000 KW"]
[null,"Battery sites",null,null,"m3/day",null,null,46600,null,"0 - 49 m3/d"]
[null,null,null,null,"m3/day",null,null,136400,null,"50 - 499 m3/d"]
[null,null,null,null,"m3/day",null,null,244300,null,"500 - 1500 m3/d"]
[null,null,null,null,"m3/day",null,null,353100,null,">1500 m3/d"]
[null,"Battery sites w/ separation, compression, injection and/or disposal equipment",null,null,"m3/day",null,null,71900,null,"0 - 49 m3/d"]
[null,null,null,null,"m3/day",null,null,158800,null,"50 - 499 m3/d"]
[null,null,null,null,"m3/day",null,null,296900,null,"500 - 1500 m3/d"]
[null,null,null,null,"m3/day",null,null,406200,null,">1500 m3/d"]
[null,"Satellite batteries",null,null,"m3/day",null,null,49600,null,"0 - 99 m3/d"]
[null,null,null,null,"m3/day",null,null,74400,null,">100 m3/d"]
[null,"Other stations",null,null,null,null,null,39900]
[null,"H2S premium (>1%)",null,null,null,null,null,"Add 10%"]
[null,"Legacy premium (Pre 1990)",null,null,null,null,null,"Add 20%"]

{"sheet":"Estimator","index":11,"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 32 "]
[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 345 B",null,null,null,"Machine","769 rock truck",null,null,null,"Machine","Cat D8"]
[null,"bucket capacity",null,2.4,"m3",null,"truck capacity",null,24,"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":95.616},"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":84.118291347207034},"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,150,"$/hr",null,"Contractor  hourly rate",null,140,"$/hr",null,"Hourly rate - contractor supplied",null,190,"$/hr"]
[null,"Excavation cost - contractor rate",null,{"$f":"D21/D11","v":1.5687751004016064},"$/m3",null,"Haul and Dump - contractor rate",null,{"$f":"I21/I18","v":1.6643229166666662},"$/m3",null,"Dozing - contractor rate",null,{"$f":"N21/N16","v":0.63587684069611783},"$/m3"]
[]
[null," - Owner",null,null,null,null," - Owner",null,null,null,null," - Owner"]
[null,"ownership, daily",null,null,"$/day",null,"ownership, daily",null,null,"$/day",null,"ownership, daily",null,null,"$/day"]
[null,"maintenance",null,null,"$/hr",null,"maintenance",null,null,"$/hr",null,"maintenance",null,null,"$/hr"]
[null,"fuel",null,null,"$/hr",null,"fuel",null,null,"$/hr",null,"fuel",null,null,"$/hr"]
[null,"consumables (cutters, tires)",null,null,"$/hr",null,"consumables (cutters, tires)",null,null,"$/hr",null,"consumables (cutters, tires)",null,null,"$/hr"]
[null,"operator",null,null,"$/hr",null,"operator",null,null,"$/hr",null,"operator",null,null,"$/hr"]
[null,"Owner hourly rate",null,{"$f":"D25/10+SUM(D26:D29)","v":0},"$/hr",null,"Owner hourly rate",null,{"$f":"I25/10+SUM(I26:I29)","v":0},"$/hr",null,"Owner hourly rate",null,{"$f":"N25/10+SUM(N26:N29)","v":0}]
[null,"Excavation cost - owner rate",null,{"$f":"D30/D11","v":0},"$/m3",null,"Haul/Dumping Cost - owner rate",null,{"$f":"I30/I18","v":0},"$/m3",null,"Spreading/Dozing Cost - owner rate",null,{"$f":"N30/N16","v":0},"$/hr"]
[null,"Excavation cost - select contractor or owner rate (D22 or D31)",null,null,"$/m3",null,"Haul/Dumping Cost - select contractor or owner rate (I22 or I31",null,null,"$/m3",null,"Spreading/Dozing Cost - select contractor or owner rate (N22 or N31)",null,null,"$/m3"]
[]
[]
[]
[null,"Excavator",null,null,null,null,"Trucking",null,null,null,null,"Dozing"]
[null,null,"Cat 320","Cat 325B","Cat 375",null,null,"Cat 771 D","Cat 777D","Cat 789C"]
[null,"heaped bucket capacity, m3",1.5,2.2000000000000002,5.4,null,"Truck capacity - heaped, m3",27.5,60.5,137]
[null,null,null,"Typical Cycle Times (seconds)"]
[null,"easy digging, shallow digging, small swing angle",16,18,20]
[null,"med. to  hard digging, rocky soil, swing angle to 90 deg.",23,23,25]
[null,"tough digging, sandstone, caliche, at max.  machine depth, swing angle > 120 deg. ",27,29,35]
[]
[null,"Material","Fill Factor (% of heaped bucket capacity"]
[null,"Moist loam or sandy clay",null,"100 - 110"]
[null,"sand and gravel (not till)",null,"95 - 110"]
[null,"hard tough clay",null,"80 - 90"]
[null,"rock - will blasted",null,"60 - 75"]
[null,"rock - poorly blasted",null,"40 -60"]
[]
[null,"Operator Skill","poor","average","good"]
[null,"Correction factor",0.6,0.75,1]
[]
[null,"Machine availability","poor","average","good"]
[null,"Correction factor",0.9,0.95,1]

{"sheet":"Tools","index":12,"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"]