{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Overview","Summary","Open Pit","UG Mine","Tailings","Rock Pile","Bldgs & Equip","Chemicals","Water","Mobilization","Monitor","PostClosure","Ongoing Water","Unit_Costs","Title","Conditions","Limitations"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":277,"comments":3,"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":"Overview","index":0,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[25,0,27,0],[19,0,23,0],[29,1,29,2]]}
["Project Name:",null,"Reclaim Model - Overview of Program"]
[null,"Lupin Mine Site 2011     ","All Users are urged to read the Guide for Using the Reclaim Model Spreadsheet."]
[null,null,"Note the WorkSheet tabs at the bottom of your Window."]
[null,null,"Please scroll down for more information"]
[null,null,"Information covered on this worksheet:  "]
[null,null,"The reclaim menu"]
[null,null,"What's on the various worksheets"]
[null,null,"Assumptions made by the Reclaim program"]
[]
["Reclaim Menu",null,"The default menu bar has been replaced with a menu bar specific to the Reclaim Model."]
["Menu","Dflt Menu","This restores the default Excel menu bar, but with an option to return to the Reclaim menu"]
["Menu","Clear","This option deletes all data input, deletes any duplicated elements and blanks out the project name"]
["Menu","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 Cost Codes are carried over from the original Open Pit.  The new Open Pit subtotal is added to the Summary page."]
["Menu","Unit Costs","This option works like a toggle to show either 1 or 2 windows.  If there is only 1 window open, this option splits the screen into 2 windows and selects the Unit Costs worksheet in the bottom window.  If the Unit Costs are already showing, then this option closes the active window, and maximizes the other window.  Be sure to select the window you want to close before selecting this option the second time."]
["Menu","Print All ","This option prints the Summary Worksheet, Unit Cost Worksheet, and all the component worksheets.  Individual worksheets can be printed directly using regular printing methods, such as Ctl - P."]
["Menu","Quit","You can press Quit from the menu, or you can exit using regular windows methods, such as alt - F4"]
["Menu","Help","Displays this page."]
[]
[null,"WorkSheets","The reclaim model makes use of separate worksheets to organize the information."]
["WorkSheets",null,"There are 3 overview type worksheets, followed by 1 worksheet for each component of reclamation.  After the component worksheets, there is a Summary Worksheet, a list of the Unit Costs, and finally the asssumptions of the reclaim model."]
[]
[null,"Title","Authors, and history of revisions"]
[null,"Conditions","Conditions of use and Limitations"]
[null,"Overview","This overview page"]
["WorkSheets","Components","This is where the component cost information is entered.         Optionally, you can edit, add, or delete activities from the components.      This should be done with care as it requires that protection be disabled."]
["WorkSheets",null,"Any worksheet can be printed individually.  Use the Print All function on the menu to print all component worksheets."]
[null,null,"Please do not change the column width, or the contents of the first column on the  component worksheets."]
[null,null,"The component worksheets are layed out in the following sequence.  You can navigate between the worksheets by selecting the worksheet's tab, at the bottom of your screen."]
[]
[null,"Open Pit,  UG Mine,   Tailings,   Rock Pile,   Bldgs & Equip,   Chemicals,    Water,   Mobilization,   Monitor,   Post Closure,  Ongoing Water"]
[]
["WorkSheets","Summary ","This contains the cost for each component, and the ongoing Post Closure costs.     The model sums all the reclamation costs and presents the totals according to component type in the Reclamation Cost Summary table.     Capital costs are presented separately from ongoing costs, such as monitoring, maintenance and water treatment.\nNOTE: The Summary sheet will show \"#Div/0!\" until values are entered on the work sheets.  This is normal."]
[null,"Unit Costs","This contains the look up table with costs for typical work"]
[null,"Limitations","The last Worksheet lists the assumptions of the Reclaim program.  To quickly access this sheet, press the >| tab navigator button."]

{"sheet":"Summary","index":1,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"SUMMARY OF COSTS"]
["Capital Costs"]
["COMPONENT TYPE","COMPONENT NAME",null,null,"TOTAL COST"]
["OPEN PIT",{"$f":"'Open Pit'!Pit1Name","v":0},null,null,{"$f":"Pit1Total","v":0}]
["UNDERGROUND MINE",{"$f":"UG1Name","v":0},null,null,{"$f":"UG1Total","v":404115.77745000011}]
["TAILINGS",{"$f":"Tailings1Name","v":0},null,null,{"$f":"Tailings1Total","v":2563155.0000000005}]
["ROCK PILE",{"$f":"RP1Name","v":0},null,null,{"$f":"RP1Total","v":0}]
["BUILDINGS AND EQUIPMENT",{"$f":"Bldg1Name","v":0},null,null,{"$f":"Bldg1Total","v":5960318.5558349993}]
["CHEMICALS AND SOIL MANAGEMENT",{"$f":"Chem1Name","v":0},null,null,{"$f":"Chem1Total","v":501545.625}]
["WATER MANAGEMENT",{"$f":"Water1Name","v":0},null,null,{"$f":"Water1Total","v":0}]
["POST-CLOSURE SITE MAINTENANCE",null,null,null,{"$f":"PC1Total","v":0}]
[]
["SUBTOTAL",null,null,null,{"$f":"SUM(E4:E12)","v":9429134.9582850002}]
[null,null,null,null,"Percentages"]
["MOBILIZATION/DEMOBILIZATION/FUEL",{"$f":"Mob1Name","v":0},null,null,{"$f":"Mob1Total","v":5533533.0013300003}]
["MONITORING AND MAINTENANCE",{"$f":"Mon1Name","v":0},null,null,{"$f":"Mon1Total","v":1260000.01}]
[]
[]
["PROJECT MANAGEMENT",4,"%",null,{"$f":"B19/100*E13","v":377165.39833140001}]
[]
["ENGINEERING ",4,"%",null,{"$f":"B21/100*E13","v":377165.39833140001}]
[]
["CONTINGENCY ",10,"%",null,{"$f":"B23/100*E13","v":942913.49582850002}]
[]
["GRAND TOTAL - CAPITAL COSTS",null,null,null,{"$f":"E13+E15+E16+E19+E21+E23","v":17919912.262106299}]

{"sheet":"Open Pit","index":2,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[1,"Open Pit Name: ",null,null,"Pit #","1"]
[]
[null,"ACTIVITY/MATERIAL","Units","Quantity","Cost Code","Unit Cost","Cost"]
["A","OBJECTIVE: CONTROL ACCESS"]
[null,"Fence","m",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E5),0,INDEX(IF(UPPER(RIGHT(E5,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E5,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E5,LEN(E5)-1)),CostCode,0)))","v":0},{"$f":"F5*D5","v":0}]
[".","Signs","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Berm","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Block roads","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},null,0]
["B","OBJECTIVE: STABILIZE SLOPES"]
[".","Off-load crest, soil A","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Off-load crest, soil B","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Doze/trimoverburden at crest","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Drill & blast pit crest","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","buttress slope","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["C","OBJECTIVE: COVER/CONTOUR SLOPES"]
[".","Place fill, soil A","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Place fill, soil B","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Rip rap","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Vegetate slopes","ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Vegetate pit floor","ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","OBJECTIVE: SPILLWAY"]
[".","Excavate channel, soil A","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Excavate channel, soil B","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Concrete","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Rip rap","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["E","OBJECTIVE: FLOOD PIT"]
[".","Embankment, soil A","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F31*D31","v":0}]
[".","Embankment, soil B","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Remove pipes etc.","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Remove power lines","each",null,{"$f":"NA()","v":{"$error":"#N/A"}}]
[".","LIme addition,  kg/m3 of water","tonne",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Lime, purchase and shipping","tonne",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Other","tonne",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["F","RECLAIM QUARRIES"]
[".","Contour slopes","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F39*D39","v":0}]
[".","Berm at crest","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F40*D40","v":0}]
[null,"Place overburder","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F41*D41","v":0}]
[".","Vegetate","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F42*D42","v":0}]
["H","OTHER ITEMS"]
[".",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Subtotal",null,null,null,null,{"$f":"SUM(G5:G44)","v":0}]
[null,null,null,null,null,null,"Total Pits"]

{"sheet":"UG Mine","index":3,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[1,"Underground Mine Name",null,null,"UG Mine #",1]
[]
[null,"ACTIVITY/MATERIAL","Units","Quantity","Cost Code","Unit Cost","Cost"]
["A","OBJECTIVE: CONTROL ACCESS"]
[null,"Fence","m",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E5),0,INDEX(IF(UPPER(RIGHT(E5,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E5,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E5,LEN(E5)-1)),CostCode,0)))","v":0},{"$f":"F5*D5","v":0}]
[".","Signs","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Ditch, mat'l A","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E7),0,INDEX(IF(UPPER(RIGHT(E7,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E7,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E7,LEN(E7)-1)),CostCode,0)))","v":0},{"$f":"F7*D7","v":0}]
[".","     , mat'l B","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E8),0,INDEX(IF(UPPER(RIGHT(E8,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E8,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E8,LEN(E8)-1)),CostCode,0)))","v":0},{"$f":"F8*D8","v":0}]
[".","Berm","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Block adits","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Cap shaft - 5 ","each",5,"SRS",{"$f":"(IF(ISNA(E11),0,INDEX(IF(UPPER(RIGHT(E11,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E11,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E11,LEN(E11)-1)),CostCode,0)))*1.05)*1.03","v":80823.155490000019},{"$f":"F11*D11","v":404115.77745000011}]
[".","Cap raise #1","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Cap raise #2","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Backfill adits","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Backfill shaft","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Backfill raise #1","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Backfill raise #2","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Backfill open stopes","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["B","OBJECTIVE: STABILIZE GROUND SURFACE"]
[".","Backfill mine","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Collapse crown pillar","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Contour, mat'l A","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","       , mat'l B","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Maintain dewatering (see \"MONITORING/MAINTENANCE\" costing component)",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["C","OBJECTIVE: FLOOD MINE"]
[".","Plug adits","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Plug drillholes to surface","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Grouting","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F30*D30","v":0}]
[".","LIme addition,  kg/m3 of water","tonne",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Lime, purchase and shipping","tonne",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["D","OBJECTIVE: HAZARDOUS MATERIALS"]
[".","remove hazardous materials","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0]
[".","remove/decontam. equipment","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["E","SPECIALIZED ITEMS"]
[".",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Subtotal",null,null,null,null,{"$f":"SUM(G5:G38)","v":404115.77745000011}]
[null,null,null,null,null,null,"Total U/G"]

{"sheet":"Tailings","index":4,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[1,"Tailings Impoundment Name:",null,null,"Impoundment #",1]
[]
[null,"ACTIVITY/MATERIAL","Units","Quantity","Cost Code","Unit Cost","Cost"]
["A","OBJECTIVE: CONTROL ACCESS"]
[null,"Fence","m",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E5),0,INDEX(IF(UPPER(RIGHT(E5,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E5,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E5,LEN(E5)-1)),CostCode,0)))","v":0},{"$f":"F5*D5","v":0}]
[".","Signs","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Ditch, mat'l A","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","     , mat'l B","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Berm","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Block roads","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F11*D11","v":0}]
["B","OBJECTIVE: STABILIZE EMBANKMENT"]
[".","Toe buttress, drain mat'l","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","            , fill mat'l A","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","            , fill mat'l B","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Rip rap","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Vegetate","ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Raise crest","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Flatten slopes","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["C","OBJECTIVE: COVER TAILINGS"]
[".","Soil cover","m3",375000,"SB2S",{"$f":"(IF(ISNA(E22),0,INDEX(IF(UPPER(RIGHT(E22,1))=Low,UnitCostLow,IF(UPPER(RIGHT(E22,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E22,LEN(E22)-1)),CostCode,0)))*1.05)*1.03","v":6.8350800000000014},2563155.0000000005]
[".","Rip rap","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Vegetate","ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["D","OBJECTIVE: FLOOD TAILINGS"]
[".","Ditch, mat'l A","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","     , mat'l B","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Raise crest","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F30*D30","v":0}]
["E","OBJECTIVE: TREAT SUPERNATANT"]
[".","Pump water","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Supply reagents","tonne",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Operate treatment plant","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["F","OBJECTIVE: UPGRADE SPILLWAY"]
[".","Excavate channel, mat'l A","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","                , mat'l B","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Concrete","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F39*D39","v":0}]
[".","Rip rap","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["G","OBJECTIVE: STABILIZE DECANT SYSTEM"]
[".","Remove","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Plug/backfill","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["H","OBJECTIVE: REMOVE TAILINGS DISCHARGE"]
[".","Cyclones","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F47*D47","v":0}]
[".","Pipe","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F48*D48","v":0}]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F49*D49","v":0}]
["I","SPECIALIZED ITEMS"]
[".",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F51*D51","v":0}]
[null,"Subtotal",null,null,null,null,{"$f":"SUM(G5:G51)","v":2563155.0000000005}]
[null,null,null,null,null,null,"Total Tailings"]

{"sheet":"Rock Pile","index":5,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[1,"Rock Pile Name:",null,null,"Rock Pile #:",1]
[]
[null,"ACTIVITY/MATERIAL","Units","Quantity","Cost Code","Unit Cost","Cost"]
["A","OBJECTIVE: STABILIZE SLOPES"]
[null,"Flatten slopes with dozer","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E5),0,INDEX(IF(UPPER(RIGHT(E5,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E5,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E5,LEN(E5)-1)),CostCode,0)))","v":0},{"$f":"F5*D5","v":0}]
[".","Divert runon, ditch mat'l A","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E6),0,INDEX(IF(UPPER(RIGHT(E6,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E6,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E6,LEN(E6)-1)),CostCode,0)))","v":0},0]
[".","            , ditch mat'l B","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Toe buttress, drain mat'l","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","            , fill mat'l A","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","            , fill mat'l B","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F11*D11","v":0}]
["B","OBJECTIVE: COVER DUMP"]
[".","Mat'l A","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Mat'l B","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Rip rap","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Vegetate","ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["C","OBJECTIVE: RELOCATE DUMPS"]
[".","Load, haul, dump or doze","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Add lime","tonne",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Contour reclaimed area","ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["D","OBJECTIVE: COLLECT AND TREAT"]
[".","See \"ONGOING TREATMENT\" costing component",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["E","OBJECTIVE: DEVELOP WETLAND"]
[".","Earthworks, mat'l A","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","          , mat'l B","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Vegetate","ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["F","SPECIALIZED ITEMS"]
[".",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Subtotal",null,null,null,null,{"$f":"SUM(G5:G32)","v":0}]
[null,null,null,null,null,null,"Total for Rock Pile"]

{"sheet":"Bldgs & Equip","index":6,"n_rows":75,"n_cols":7,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[1,"Building / Equip Name:",null,null,"Bldg / Equip #:",1]
[]
[null,"ACTIVITY/MATERIAL","Units","Quantity","Cost Code","Unit Cost","Cost"]
["A","OBJECTIVE: DISPOSE MOBILE EQUIPMENT"]
[null,"Decontaminate and ship off-site","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E5),0,INDEX(IF(UPPER(RIGHT(E5,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E5,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E5,LEN(E5)-1)),CostCode,0)))","v":0},{"$f":"F5*D5","v":0}]
[".","Decontaminate, dispose on-site","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E6),0,INDEX(IF(UPPER(RIGHT(E6,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E6,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E6,LEN(E6)-1)),CostCode,0)))","v":0},0]
[".","Other","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E7),0,INDEX(IF(UPPER(RIGHT(E7,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E7,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E7,LEN(E7)-1)),CostCode,0)))","v":0},0]
["B","OBJECTIVE: DISPOSE STATIONARY EQUIPMENT"]
[".","Decontaminate and ship off-site","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E9),0,INDEX(IF(UPPER(RIGHT(E9,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E9,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E9,LEN(E9)-1)),CostCode,0)))","v":0},0]
[".","Decontaminate, dispose on-site","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E10),0,INDEX(IF(UPPER(RIGHT(E10,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E10,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E10,LEN(E10)-1)),CostCode,0)))","v":0},0]
[".","Other","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E11),0,INDEX(IF(UPPER(RIGHT(E11,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E11,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E11,LEN(E11)-1)),CostCode,0)))","v":0},0]
["C","OBJECTIVE: DISPOSE ORE CONCENTRATION EQUIPMENT"]
[".","Decontaminate crushing plant","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E13),0,INDEX(IF(UPPER(RIGHT(E13,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E13,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E13,LEN(E13)-1)),CostCode,0)))","v":0},0]
[".","Decontaminate tanks & plumb.","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E14),0,INDEX(IF(UPPER(RIGHT(E14,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E14,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E14,LEN(E14)-1)),CostCode,0)))","v":0},0]
[".","Remove tanks & plumbing","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E15),0,INDEX(IF(UPPER(RIGHT(E15,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E15,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E15,LEN(E15)-1)),CostCode,0)))","v":0},0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E16),0,INDEX(IF(UPPER(RIGHT(E16,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E16,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E16,LEN(E16)-1)),CostCode,0)))","v":0},0]
["D","OBJECTIVE: DISPOSE WATER TREATMENT EQUIPMENT"]
[".","Decontaminate tanks & plumb.","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E18),0,INDEX(IF(UPPER(RIGHT(E18,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E18,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E18,LEN(E18)-1)),CostCode,0)))","v":0},0]
[".","Remove tanks & plumbing","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E19),0,INDEX(IF(UPPER(RIGHT(E19,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E19,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E19,LEN(E19)-1)),CostCode,0)))","v":0},0]
[".","Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E20),0,INDEX(IF(UPPER(RIGHT(E20,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E20,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E20,LEN(E20)-1)),CostCode,0)))","v":0},0]
["E","OBJECTIVE: DECONTAMINATE BUILDINGS & TANKS"]
[".","Process plant, chemicals","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E22),0,INDEX(IF(UPPER(RIGHT(E22,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E22,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E22,LEN(E22)-1)),CostCode,0)))","v":0},0]
[".","Maintenance plant, chemicals","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Camp","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Bulk fuel storage","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Power plant","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Explosives plant","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["F","OBJECTIVE: MOTHBALL BUILDINGS"]
[".","Sleepers and Offices","m2",7329,"BRS1S",{"$f":"(IF(ISNA(E29),0,INDEX(IF(UPPER(RIGHT(E29,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E29,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E29,LEN(E29)-1)),CostCode,0)))*1.05)*1.03","v":135.79313999999999},995227.92305999994]
[".","Hoist Room and Travel Ways","m2",463,"BRS1S",135.79313999999999,62872.223819999999]
[".","Shaft House","m2",1253,"BRS1S",135.79313999999999,170148.80442]
[".","Warehouse","m2",4671,"BRS1S",135.79313999999999,634289.75693999999]
[".","Mill","m2",2864,"BRS1S",135.79313999999999,388911.55296]
[".","Powerhouse","m2",1645,"BRS1S",135.79313999999999,223379.71529999998]
[".","Headframe ","m2",413,"BRS1S",135.79313999999999,56082.56682]
[".","Airlock Building and Freshair Intake","m2",366,"BRS1S",135.79313999999999,49700.289239999998]
[".","Pastefill Plant","m2",316,"BRS1S",135.79313999999999,42910.632239999999]
[".","Cold Storage 2 buildings","m2",1855,"BRS1S",135.79313999999999,251896.27469999998]
[".","Surface Mobile Shop","m2",1008,"BRS1S",135.79313999999999,136879.48512]
[".","Carpenter Shop","m2",482,"BRS1S",135.79313999999999,65452.29348]
[".","As Treatment Plant Building","m2",177,"BRS1S",135.79313999999999,24035.385780000001]
[".","Pumphouse","m2",74,"BRS1S",135.79313999999999,10048.692359999999]
[".","Explosives Storage","m2",412,"BRS1S",135.79313999999999,55946.773679999998]
[".","Fire house","m2",31,"BRS1S",135.79313999999999,4209.58734]
[".","Emergency Power House","m2",117,"BRS1S",135.79313999999999,15887.79738]
[".","Weather Station and Storage Buildings","m2",566,"BRS1S",135.79313999999999,76858.917239999995]
[".","Shop ","m2",379,"BRS1S",135.79313999999999,51465.600059999997]
[".","Batch Plant","m2",118,"BRS1S",135.79313999999999,16023.59052]
[".","ATV Building","m2",172,"BRS1S",135.79313999999999,23356.42008]
["I","OBJECTIVE:REMOVE TANKS /PIPES"]
[".","3 - 360,000 gallon tanks","m3",4098,"BRS2S",{"$f":"(IF(ISNA(E51),0,INDEX(IF(UPPER(RIGHT(E51,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E51,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E51,LEN(E51)-1)),CostCode,0)))*1.05)*1.03","v":24.074190000000002},98656.030620000005]
[".","7 - 350,000 gallon tanks","m3",9275,"BRS2S",24.074190000000002,223288.11225000001]
[".","3 - 187,000 gallon tanks","m3",2124,"BRS2S",24.074190000000002,{"$f":"F53*D53","v":51133.579560000006}]
[".","6- 14,000 gallon tanks","m3",318,"BRS2S",24.074190000000002,{"$f":"F54*D54","v":7655.5924200000009}]
[".","11 - 20,000 gallon tank","m3",825,"BRS2S",24.074190000000002,19861.206750000001]
[".","2- 5,000 gallon tanks","m3",19,"BRS2S",24.074190000000002,457.40961000000004]
[".","Piping","m",1000,"PPLS",54.096630000000012,54096.630000000012]
["J","OBJECTIVE: LANDFILL FOR DEMOLITION WASTE"]
[".","Isolate Buildings (waste,water,glycol,sewer)","m2",24562,"BDCS",{"$f":"(IF(ISNA(E59),0,INDEX(IF(UPPER(RIGHT(E59,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E59,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E59,LEN(E59)-1)),CostCode,0)))*1.05)*1.03","v":11.91813},292733.10905999999]
[".","Bone Yard Clean Up",null,1,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"(252048*1.05)*1.03","v":272589.91200000001},272589.91200000001]
[".","Operation of Landfill",null,1,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"(262336*1.05)*1.03","v":283716.38400000002},283716.38400000002]
["K","OBJECTIVE: GRADE AND CONTOUR"]
[".","Grade/Contour Entire Mine Site Area","m2",230000,"SB2L",{"$f":"(IF(ISNA(E63),0,INDEX(IF(UPPER(RIGHT(E63,1))=Low,UnitCostLow,IF(UPPER(RIGHT(E63,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E63,LEN(E63)-1)),CostCode,0)))*1.05)*1.03","v":4.6551761550000013},1070690.5156500002]
[".","Place soil cover","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E64),0,INDEX(IF(UPPER(RIGHT(E64,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E64,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E64,LEN(E64)-1)),CostCode,0)))","v":0},0]
[".","Rip rap on ditches","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E65),0,INDEX(IF(UPPER(RIGHT(E65,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E65,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E65,LEN(E65)-1)),CostCode,0)))","v":0},0]
[".","Vegetate","ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E66),0,INDEX(IF(UPPER(RIGHT(E66,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E66,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E66,LEN(E66)-1)),CostCode,0)))","v":0},0]
[".","Concrete Slab Removal","m2",25000,"BRCS",{"$f":"(IF(ISNA(E67),0,INDEX(IF(UPPER(RIGHT(E67,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E67,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E67,LEN(E67)-1)),CostCode,0)))*1.05)*1.03","v":6.8783400000000015},171958.50000000003]
["L","OBJECTIVE: RECLAIM ROADS"]
[".","Scarify and install water breaks","km",10,"SCFYH",{"$f":"(IF(ISNA(E69),0,INDEX(IF(UPPER(RIGHT(E69,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E69,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E69,LEN(E69)-1)),CostCode,0)))*1.05)*1.03","v":5789.7291375000004},{"$f":"F69*D69","v":57897.291375000001}]
[".","Vegetate","ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E70),0,INDEX(IF(UPPER(RIGHT(E70,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E70,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E70,LEN(E70)-1)),CostCode,0)))","v":0},{"$f":"F70*D70","v":0}]
[".",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E71),0,INDEX(IF(UPPER(RIGHT(E71,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E71,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E71,LEN(E71)-1)),CostCode,0)))","v":0},{"$f":"F71*D71","v":0}]
["K","SPECIALIZED ITEMS"]
[".",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E73),0,INDEX(IF(UPPER(RIGHT(E73,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E73,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E73,LEN(E73)-1)),CostCode,0)))","v":0},{"$f":"F73*D73","v":0}]
[null,"Subtotal",null,null,null,null,{"$f":"SUM(G5:G73)","v":5960318.5558349993}]
[null,null,null,null,null,null,"Total Buildings"]

{"sheet":"Chemicals","index":7,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,1,3,6]]}
[1,"Chemicals and Soil Contamination:",null,null,null,"1"]
[]
[null,"ACTIVITY/MATERIAL","Units","Quantity","Cost Code","Unit Cost","Cost"]
[".","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."]
["A","LABORATORY CHEMICALS"]
[".",null,"pallet",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E6),0,INDEX(IF(UPPER(RIGHT(E6,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E6,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E6,LEN(E6)-1)),CostCode,0)))","v":0},{"$f":"F6*D6","v":0}]
["B","PCB, hauling","litre",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E7),0,INDEX(IF(UPPER(RIGHT(E7,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E7,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E7,LEN(E7)-1)),CostCode,0)))","v":0},0]
[".","PCB, disposal","litre",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["C","FUEL",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},null,0]
[".","Type 1","kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Type 2","kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Type 3","kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F12*D12","v":0}]
["D","WASTE OIL"]
[".","Oils/lubricants - burn on-site","litre",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Oils/lubricants - ship off-site","litre",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Oils/lubricants - disposal fee","litre",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["E","PROCESS OR TREATMENT CHEMICALS"]
[".","Type 1","kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Type 2","kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Type 3","kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Type 4","kg",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["F","EXPLOSIVES","kg"]
[".",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},null,0]
["G","CONTAMINATED SOILS"]
[".","Type 1, light fuel","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Type 2, heavy fuel and oil","m3",7500,"CSRS",{"$f":"(IF(ISNA(E26),0,INDEX(IF(UPPER(RIGHT(E26,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E26,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E26,LEN(E26)-1)),CostCode,0)))*1.05)*1.03","v":56.778750000000002},425840.625]
[".","Type 3, metals","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["H","Haz. Mat. testing & assessment"]
[".","Technician and analyses","each",1,{"$f":"NA()","v":{"$error":"#N/A"}},0,37852.5]
[".","Drilling","each",1,{"$f":"NA()","v":{"$error":"#N/A"}},0,21630]
[".","Report ","each",1,{"$f":"NA()","v":{"$error":"#N/A"}},0,16222.5]
[".","OTHER"]
[".",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Subtotal",null,null,null,null,{"$f":"SUM(G6:G33)","v":501545.625}]
[null,null,null,null,null,null,"Total Chemical"]

{"sheet":"Water","index":8,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[1,"Water Management Project:",null,null,"Project #","1"]
[]
[null,"ACTIVITY/MATERIAL","Units","Quantity","Cost Code","Unit Cost","Cost"]
["A","OBJECTIVE: STABILIZE EMBANKMENT"]
[null,"Toe buttress, drain mat'l","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E5),0,INDEX(IF(UPPER(RIGHT(E5,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E5,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E5,LEN(E5)-1)),CostCode,0)))","v":0},{"$f":"F5*D5","v":0}]
[null,"            , fill mat'l A","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E6),0,INDEX(IF(UPPER(RIGHT(E6,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E6,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E6,LEN(E6)-1)),CostCode,0)))","v":0},0]
[null,"            , fill mat'l B","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E7),0,INDEX(IF(UPPER(RIGHT(E7,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E7,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E7,LEN(E7)-1)),CostCode,0)))","v":0},0]
[null,"Rip rap","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Vegetate","ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Raise crest","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["B","OBJECTIVE: UPGRADE SPILLWAY"]
[null,"Excavate channel, mat'l A","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"                , mat'l B","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Concrete","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Rip rap","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["C","OBJECTIVE: STABILIZE SEDIMENT CONTAINMENT PONDS"]
[null,"Place soil cover","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Place geotextile","m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Vegetate","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["D","OBJECTIVE: BREACH EMBANKMENT"]
[null,"Remove Fill","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["E","OBJECTIVE: STABILIZE DITCHES"]
[null,"Flatten side slopes","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Rip rap","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Vegetate","ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["F","OBJECTIVE: BREACH DITCHES"]
[null,"Excavate","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Backfill/recontour","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Vegetate","ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["G","OBJECTIVE: REMOVE PIPELINES"]
[null,"Remove pipes","m",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Concrete plug deep pipes","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["H","OBJECTIVE: REMOVE STORAGE TANKS"]
[null,"Remove tanks & plumbing","m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Excavate & backfill","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Other",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[" I","OBJECTIVE: COLLECT DRAINAGE FOR TREATMENT"]
[null,"Excavate collection ditches","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Rip rap ditches","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Pipes","m",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Pumps","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Collect'n pond, exc. mat'l A","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"              , exc. mat'l B","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Collect'n pond, fill mat'l A","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"              , fill mat'l B","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Collect'n pond, liner","m2",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["J","OBJECTIVE: TREAT DRAINAGE (see \"ONGOING TREATMENT\" for operating costs)"]
[null,"Build treatment plant    lump sum",null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[null,"Subtotal",null,null,null,null,{"$f":"SUM(G5:G56)","v":0}]
[null,null,null,null,null,null,"Total Water"]

{"sheet":"Mobilization","index":9,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[1,"Mobilization Name:",null,null,"Mob #","1"]
[]
[null,"ACTIVITY/MATERIAL","Units","Quantity","Cost Code","Unit Cost","Cost"]
["A","MOBILIZE HEAVY EQUIPMENT"]
["Equipment to regional centre"]
[".","Mobilization - ICE ROAD","ea",1,"MHERS",{"$f":"(IF(ISNA(E6),0,INDEX(IF(UPPER(RIGHT(E6,1))=Low,UnitCostLow,IF(UPPER(RIGHT(E6,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E6,LEN(E6)-1)),CostCode,0)))*1.05)*1.03","v":1959290.0226900002},{"$f":"F6*D6","v":1959290.0226900002}]
[".","Demobilization - ICE ROAD","ea",1,"MHEAS",{"$f":"(IF(ISNA(E7),0,INDEX(IF(UPPER(RIGHT(E7,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E7,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E7,LEN(E7)-1)),CostCode,0)))*1.05)*1.03","v":783873.96864000009},783873.96864000009]
[".",null,"km",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E8),0,INDEX(IF(UPPER(RIGHT(E8,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E8,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E8,LEN(E8)-1)),CostCode,0)))","v":0},0]
[".",null,"km",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["Equipment, regional centre to site"]
[".","Excavators","km",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Dump trucks","km",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F12*D12","v":0}]
[".","Dozers","km",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Demolition shears","km",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["B","MOBILIZE CAMP"]
[".",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},null,0]
["C","MOBILIZE WORKERS","manday"]
[".",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["D","MOBILIZE MISC. SUPPLIES"]
[".","Fuel","litre",2790369,{"$f":"NA()","v":{"$error":"#N/A"}},1,2790369]
[".","Minor tools and equipment","allowance",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Truck tires ","allowance",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["E","MOBILIZE & HOUSE WORKERS  person days"]
[".",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},null,0]
[".","WINTER ROAD"]
[".","Full winter use","km",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".","Limited winter use","km",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
[".",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},0,0]
["F","BONDING                   lump sum"]
[".",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},null,0]
["G","TAXES                         lump sum"]
[".",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},null,0]
["H","INSURANCE                lump sum"]
[".",null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},null,0.01]
[null,"Subtotal",null,null,null,null,{"$f":"SUM(G6:G34)","v":5533533.0013300003}]
[null,null,null,null,null,null,"Total Mob."]

{"sheet":"Monitor","index":10,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[1,"Monitoring & Maintenance",null,null,"Mon / Mtce #","1"]
[]
[null,"ACTIVITY/MATERIAL","Units","Quantity","Cost Code","Unit Cost","Cost"]
["A","OBJECTIVE: INSPECTIONS"]
[null,"Annual geotechnical insp.","each",5,{"$f":"NA()","v":{"$error":"#N/A"}},20000,{"$f":"F5*D5","v":100000}]
[".","Monitoring years 1-5","year",3,{"$f":"NA()","v":{"$error":"#N/A"}},350000,{"$f":"F6*D6","v":1050000}]
[".","EEM","each",1,{"$f":"NA()","v":{"$error":"#N/A"}},110000,{"$f":"F7*D7","v":110000}]
[".",null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E8),0,INDEX(IF(UPPER(RIGHT(E8,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E8,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E8,LEN(E8)-1)),CostCode,0)))","v":0},{"$f":"F8*D8","v":0}]
[".",null,"each",0,{"$f":"NA()","v":{"$error":"#N/A"}},null,0]
["B","OBJECTIVE: MAINTENANCE"]
[".","Security guard","month",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F11*D11","v":0}]
[".","Accomodation","month",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F12*D12","v":0}]
[".","Maintain pumping","month",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F13*D13","v":0}]
[".","Clear spillway","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},0,{"$f":"F14*D14","v":0}]
[".","Other"]
[null,null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}},null,0.01]
[null,"Subtotal",null,null,null,null,{"$f":"SUM(G5:G16)","v":1260000.01}]
[null,null,null,null,null,null,"Total Pits"]

{"sheet":"PostClosure","index":11,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[1,"Post-Closure Site Maintenance"]
[]
[null,"ACTIVITY/MATERIAL","Units","Quantity","Cost Code","Unit Cost","Cost","% Land","Land Cost","Water Cost"]
["A","WATER TREATMENT"]
[null,"Total annual cost, unit cost from Ongoing Water Treatment",null,null,null,{"$f":"+OWTotal","v":0},{"$f":"F5*D5","v":0},null,{"$f":"G5*H5","v":0},{"$f":"G5*(1-H5)","v":0}]
["B","Cover Maintenance"]
[null,"Repair erosion, remove trees","ha",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E7),0,INDEX(IF(UPPER(RIGHT(E7,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E7,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E7,LEN(E7)-1)),CostCode,0)))","v":0},{"$f":"F7*D7","v":0},null,0,{"$f":"G7*(1-H7)","v":0}]
["C","Spillway Maintenance"]
[null,"Repair erosion","m3",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E9),0,INDEX(IF(UPPER(RIGHT(E9,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E9,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E9,LEN(E9)-1)),CostCode,0)))","v":0},{"$f":"F9*D9","v":0},null,0,0]
[null,"Clear spillway","each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E10),0,INDEX(IF(UPPER(RIGHT(E10,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E10,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E10,LEN(E10)-1)),CostCode,0)))","v":0},{"$f":"F10*D10","v":0},null,0,0]
[null,null,"each",null,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(E11),0,INDEX(IF(UPPER(RIGHT(E11,1))=Low,UnitCostLow, IF(UPPER(RIGHT(E11,1))=High,UnitCostHigh,UnitCostSpecified)),MATCH(UPPER(LEFT(E11,LEN(E11)-1)),CostCode,0)))","v":0},null,null,null,0]
["D","Other"]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0]
[null,"Subtotal, Annual post-closure costs",null,null,null,null,{"$f":"SUM(G5:G14)","v":0},null,{"$f":"SUM(I5:I14)","v":0},{"$f":"SUM(J5:J14)","v":0}]
[null,"Discount rate for calculation of net present value of post-closure cost, %",null,null,0.03,null,null,null,0]
[null,"Number of years of post-closure activity",null,null,5,"years",null,null,0]
[null,"Present Value of payment stream",null,null,null,null,{"$f":"PV(DiscountRate,PCYears, PCAnnualTotal)*-1","v":0},{"$f":"+I18/G18","v":{"$error":"#DIV/0!"}},{"$f":"PV(DiscountRate,PCYears, I15)*-1","v":0},{"$f":"PV(DiscountRate,PCYears, J15)*-1","v":0}]
[null,null,null,null,null,null,"Total Post closure","Percent Land","Total Land","Total Water"]

{"sheet":"Ongoing Water","index":12,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[null,"WATER TREATMENT COSTS"]
[null,null,null,"ANNUAL VOLUME OF WATER (m3)"]
[]
[null,"Reagent addition rates"]
[null,"Reagent",null,"kg reagent/m3 water",null,"cost in $/kg, FOB site","Annual reagent cost"]
[null,"H2O2",null,0.1,"kg/m3",1.5,{"$f":"WaterVol*D6*F6","v":0}]
[null,"lime",null,null,"kg/m3",0.45,{"$f":"WaterVol*D7*F7","v":0}]
[null,"ferric sulphate",null,null,"kg/m3",null,{"$f":"WaterVol*D8*F8","v":0}]
[null,"ferrous sulphate",null,null,"kg/m3",null,{"$f":"WaterVol*D9*F9","v":0}]
[null,"flocculents",null,null,"kg/m3",null,{"$f":"WaterVol*D10*F10","v":0}]
[]
[null,null,null,null,null,"TOTAL",{"$f":"SUM(G6:G11)","v":0}]
[]
[null,"Supplies and Labour"]
[null,"power, kW-hr",null,0,"rate, $/kW-hr",0.08,{"$f":"D15*F15","v":0}]
[null,"misc. supplies, hoses, tools",null,null,null,null,0]
[null,"sampling equip.",null,null,null,null,0]
[null,"equip. maintenance and parts",null,null,null,null,0]
[null,"water analysis",null,null,null,null,0]
[null,"reporting",null,null,null,null,0]
[null,"truck rental",null,null,null,null,0]
[null,"annual mileage",null,null,null,null,0]
[null,"road maintenace & snow plowing",null,null,null,null,0]
[null,"electrician/mechanic for treatment plant & power supply",null,null,null,null,0]
[null,null,null,null,"Annual cost",null,{"$f":"SUM(G15:G24)","v":0}]
[]
[null,"labor, hourly rate",null,35]
[null,null,"men per day for water treatment work",null,null,null,1]
[null,null,"on site, days per year",null,null,null,0]
[null,null,"spring/fall maintenance, extra work",null,null,null,0]
[null,null,"hours worked per year",null,null,null,0]
[null,null,"annual labor cost",null,null,null,{"$f":"G31*D27","v":0}]
[]
[null,null,null,null,"Total, labour and supplies",null,{"$f":"G25+G32","v":0}]
[]
[]
[null,"TOTAL ANNUAL COSTS, reagents plus labour and supplies",null,null,null,null,{"$f":"G12+G34+D49+D50+D51","v":0}]
[null,"Average treatment cost, $/m3",null,null,null,null,{"$f":"IF(WaterVol=0,0,OWTotal/WaterVol)","v":0}]
[]
[null,"Water analyses"]
[null,"samples per month",null,10]
[null,"analysis cost/sample",null,100]
[null,"shipping",null,200]
[null,"Total Water Sampling",null,{"$f":"D41*D42+D43","v":1200}]
[]
[]
[null,"Site Access"]
[null,"annual site access cost"]
[null,"road",null,0]
[null,"air",null,0]
[null,"winter road",null,0]

{"sheet":"Unit_Costs","index":13,"n_rows":185,"n_cols":11,"rows_kept":185,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Unit Cost Table"]
[]
[null,"ITEM","Detail",null,"COST CODE","UNITS","LOW $","HIGH $","SPECIFIED $"]
[]
[1,"excavate Rock, Bulk",null,null,null,null,null,null,null,null,"COMMENTS"]
[null,null,"drill, blast, load                                           short haul (<500m)    Dump",null,"RB1","m3",10.11,15.141000000000002,{"$f":"NA()","v":{"$error":"#N/A"}},null,"quarry operations for bulk fill"]
[null,null,"RB1 + long haul, up to 1500 m",null,"RB2","m3",10.71,15.789900000000001,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"RB1 + spread and compact",null,"RB3","m3",10.71,15.789900000000001,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"RB1 + long haul + spread and compact",null,"RB4","m3",11.3,27.307875000000003,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"RB1 + Specified activity",null,"RBS","m3",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}}]
[2,"excavate Rock, Controlled"]
[null,null,"drill, blast, load                                           short haul (<500m)    Dump",null,"RC1","m3",23.792999999999999,35.689500000000002,{"$f":"NA()","v":{"$error":"#N/A"}},null,"spillway excavation"]
[null,null,"RC1 + long haul, up to 1500 m",null,"RC2","m3",11.3,16.330650000000002,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"RC1 + spread and compact",null,"RC3","m3",11.3,15.789900000000001,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"RC1 + long haul                                    + spread and compact",null,"RC4","m3",11.99,17.011995000000002,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"RC1 + Specified activity",null,"RCS","m3",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},145,null,"$145/M3-drift excavation"]
[3,"excavate Soil, Bulk"]
[null,null,"excavate, load                             short haul (<500m)   dump",null,"SB1","m3",3.4608000000000003,5.2452750000000004,{"$f":"NA()","v":{"$error":"#N/A"}},null,"LOW cost: excavation of loose soil,                 high volume"]
[null,null,"SB1 + long haul, up to 1500 m",null,"SB2","m3",4.3043700000000005,6.4565550000000007,6.32,null,"LOW cost: excavation of loose soil, 1.5 km haul, high volume SPECIFIED: Adjusted high cost at 2% per year from 2005"]
[null,null,"SB1 + spread and compact",null,"SB3","m3",4.0015499999999999,5.7427650000000003,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"SB1 + long haul                                    + spread and compact",null,"SB4","m3",4.8667500000000006,9.6794250000000002,{"$f":"NA()","v":{"$error":"#N/A"}},null,"LOW cost: excavation of loose soil, 1.5 km haul, high volume, const. of simple soil cover"]
[]
[null,null,"SB1 + Specified activity",null,"SBS","m3",2.498265,6.8999699999999997,10.95,null,"LOW cost: rehandle waste rock dump into pit, >500,000 m3, 2 km haul"]
[null,null,null,null,null,null,null,null,null,null,"SPECIFIED cost: rehandle waste rock, haul 3 km, place & compact on dam"]
[]
[null,null,"Soil, tailings ",null,"SBT","m3",3.276945,7.7327250000000003,null,null,"LOW cost:  doze tailings,                                      HIGH cost:  excavate & short haul"]
[4,"excavate Soil, Controlled"]
[null,null,"excavate, load                             short haul (<500 m), dump",null,"SC1","m3",6.067215,8.2734750000000012,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"SC1 + long haul, up to 1500 m",null,"SC2","m3",7.5164250000000008,10.425660000000002,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"SC1 + spread and compact",null,"SC3","m3",6.067215,12.610290000000001,{"$f":"NA()","v":{"$error":"#N/A"}},null,"HIGH cost: for simple soil covers"]
[null,null,"SC1 + long haul                                    + spread and compact",null,"SC4","m3",6.8134500000000005,20.602575000000002,{"$f":"NA()","v":{"$error":"#N/A"}},null,"HIGH cost: for complex covers & dam construction, spillway repair, LOW volume"]
[null,null,"SC1 + Specified activity",null,"SCS","m3",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},15.75,null,"SPECIFIED cost: backfill adit with waste rock"]
[null,"Geo-synthetics"]
[null,null,"geotextile, filter cloth",null,"GST","M2",1.0706850000000001,2.1413700000000002,{"$f":"NA()","v":{"$error":"#N/A"}},null,"FOB Edmonton, add shipping & installation"]
[null,null,"geogrid",null,"GSG","M2",5.115495000000001,null,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"liner, HDPE",null,"GSHDPE","M2",6.3700349999999997,null,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"liner, PVC",null,"GSPVC","M2",null,null,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"geosynthetic installation",null,"GSI","m2",0.89764499999999992,1.03,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"bentonite soil ammendment",null,"GSBA","tonne",273.61950000000002,309.30900000000003,{"$f":"NA()","v":{"$error":"#N/A"}},null,"FOB Edmonton, add shipping & mixing"]
[null,"Shaft, Raise & Portal Closures"]
[null,null,"Cap Shafts",null,"SR","ea",573.19500000000005,1892.625,74732.460000000006,null,"SPECIFIED: QUOTED COSTS 2005 Plus 6%"]
[null,null,"Portals",null,"POR","m3",0,221.70750000000001,1000,null,"HIGH cost: for excavate & backfill collapsed portal                                                                                  SPECIFIED cost: installed pressure plug"]
[]
[]
[]
[]
[]
[]
[5,"Concrete work"]
[null,null,"Small pour, no forms",null,"CS","m3",321.20550000000003,643.49250000000006,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"Large pour, no forms",null,"CL","m3",254.1525,378.52500000000003,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"Small pour, Formed",null,"CSF","m3",378.52500000000003,1892.625,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"Large pour, Formed",null,"CLF","m3",313.63499999999999,443.41500000000002,{"$f":"NA()","v":{"$error":"#N/A"}}]
[6,"Vegetation"]
[null,null,"Hydroseed, Flat",null,"VHF","ha",1724.9925000000001,5353.4250000000002,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"Hydroseed, Sloped",null,"VHS","ha",1998.6120000000001,6007.7325000000001,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"veg. Blanket/erosion mat",null,"VB","ha",11896.5,14275.800000000001,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"Tree planting",null,"VT","ha",11896.5,14275.800000000001,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"Wetland species",null,"VW","ha",59482.5,89223.75,{"$f":"NA()","v":{"$error":"#N/A"}}]
[7,"Pumps"]
[null,null,"Small, <",null,"PS","each",3244.5,6489,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"Large, >",null,"PL","each",5407.5,108150,{"$f":"NA()","v":{"$error":"#N/A"}},null,"large - 250 hp Gould w/diesel motor"]
[8,"PiPes"]
[null,null,"Pipes >6 inches ",null,"PPS","m",0.54075000000000006,5.4074999999999998,10.89,null,"LOW cost:  pipe removal,                                     HIGH cost: supply new pipe                     SPECIFIED: steel covered heat traced & insulated pipe"]
[null,null,"Fuel Contaminated ",null,"PPL","m",1.0815000000000001,194.67000000000002,50.02,null,"LOW cost: pipe removal,                                    HIGH cost: supply 24\" 100 psi HDPE pipe, FOB Edm.        SPECIFIED: 2005 Quoted Cost plus 6%. "]
[]
[9,"pump sand BackFill",null,null,"BF","m3",5.9482500000000007,17.844750000000001,{"$f":"NA()","v":{"$error":"#N/A"}}]
[10,"Fence",null,null,"F","m",11.896500000000001,178.44749999999999,{"$f":"NA()","v":{"$error":"#N/A"}}]
[11,"Signs",null,null,"S","each",11.896500000000001,35.689500000000002,{"$f":"NA()","v":{"$error":"#N/A"}}]
[12,"rock, Drill and Blast only",null,null,"DB","m3",11.896500000000001,23.793000000000003,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,"(flatten slope, collapse drift)"]
[13,"excavate Rip Rap"]
[null,null,"drill, blast, load                             short haul (<500 m)                           dump and spread",null,"RR1","m3",11.842425,17.682525000000005,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"RR1 + long haul",null,"RR2","m3",12.00465,18.331424999999999,{"$f":"NA()","v":{"$error":"#N/A"}},null,"HIGH cost: quarry & place rip rap in channel"]
[null,null,"excavate rock from waste dump, short haul, spread",null,"RR3","m3",4.5423,6.2510700000000012,{"$f":"NA()","v":{"$error":"#N/A"}},null,"LOW cost: removal of 18 in minus from dump, long haul and spread"]
[null,null,null,null,null,null,null,null,null,null,"HIGH cost: removal of coarse rock from dump, long haul,  armour spillway"]
[null,null,"RR3 + long haul",null,"RR4","m3",5.06142,6.7593750000000004,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"specified rip rap source",null,"RR5","m3",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}}]
[14,"Import LimeStone",null,null,"ILS","tonne",9.5172000000000025,14.2758,{"$f":"NA()","v":{"$error":"#N/A"}}]
[15,"Import LiMe",null,null,"ILM","tonne",178.44749999999999,535.34249999999997,{"$f":"NA()","v":{"$error":"#N/A"}},null,"LOW cost:  bulk shipping, high volume, FOB Vancouver/Edmonton"]
[null,null,null,null,null,null,null,null,null,null,"HIGH cost: bags delivered to central Yukon, small volume"]
[16,"Grouting",null,null,"G","m3",214.137,259.56,{"$f":"NA()","v":{"$error":"#N/A"}},null,"HIGH cost: cement, FOB Yellowknife"]
[17,"Dozing"]
[null,null,"doze Rock piles",null,"DR","m3",0.91927499999999995,2.1089249999999997,{"$f":"NA()","v":{"$error":"#N/A"}},null,"LOW cost: doze crest off dump"]
[null,null,"doze overburden/Soil piles",null,"DS","m3",0.84357000000000004,3.3634650000000001,{"$f":"NA()","v":{"$error":"#N/A"}},null,"HIGH cost: push up to 300 m"]
[18]
[null,null,null,null,null,null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}}]
[19]
[null,null,null,null,null,null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}}]
[20]
[null,null,null,null,null,"each",0,0,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"each",null,null,{"$f":"NA()","v":{"$error":"#N/A"}}]
[21,"Buildings - Decontaminate"]
[null,null,"Isolate (glycol, water,sewer,power)",null,"BDC","m2",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},11.02,null,"SPECIFIED: Quoted 2005 cost plus 6%"]
[null,null,"Asbestos",null,"BDA","m2",22.711500000000001,45.423000000000002,{"$f":"NA()","v":{"$error":"#N/A"}},null,"LOW cost: removal of asbestos siding & flooring                        HIGH cost: removal of insulated pipes, friable asbestos"]
[]
[22,"Buildings - Remove"]
[null,null,"areas are per floor on 3 m average height",null,null,null,null,null,null,null,"LOW cost:  removal and on-site disposal - small wooden structures"]
[null,null,"Wood - teardown",null,"BRW1","m2",23.25225,35.689500000000002,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"Wood - burn",null,"BRW2","m2",5.9482500000000007,11.896500000000001,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"Masonry",null,"BRM","m2",25.577475,35.689500000000002,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"Concrete",null,"BRC","m",35.689500000000002,53.53425,6.36,null,"LOW cost: removal of building perimeter walls, HIGH cost: per m3 for bulk concrete              SPECIFIED cost: $/m2 to break floor slab "]
[null,null,"Steel - teardown",null,"BRS1","m2",38.06880000000001,57.103200000000001,125.56,null,"SPECIFIED cost: quoted 2005 cost demolition  $/m2 plus 6%"]
[null,null,"Tanks",null,"BRS2","m3",59.482500000000002,89.223749999999995,22.26,null,"SPECIFIED cost: quoted 2005 costs plus 6% $/m3 storage tank includes decontamination"]
[23,"Power & Pipe Lines"]
[null,null,"Power lines, remove",null,"POWR","each",22.603350000000002,4996.53,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,{"$f":"NA()","v":{"$error":"#N/A"}}]
[24,"Laboratory Chemicals"]
[null,null,"Remove from site",null,"LCR","pallet",1892.625,2509.08,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"Dispose on site",null,"LCD","each",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}}]
[25,"PCB - Remove from site",null,null,"PCBR","litre",35.689500000000002,41.637750000000004,{"$f":"NA()","v":{"$error":"#N/A"}},null,"LOW cost: shipping, handling & disposal from Yellowknife"]
[]
[26,"Fuel"]
[null,null,"Remove from site",null,"FR","kg",0,1.1031300000000002,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"Burn on site",null,"FB","kg",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}}]
[27,"Oil"]
[null,null,"Remove from site",null,"OR","litre",0.378525,1.1031300000000002,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"Burn on site",null,"OB","litre",0.378525,0.59482500000000016,{"$f":"NA()","v":{"$error":"#N/A"}}]
[28,"Process Chemicals"]
[null,null,"Remove from site",null,"PCR","kg",0.378525,2.2170749999999999,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"Dispose on site",null,"PCD","kg",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}}]
[29,"Explosives"]
[null,null,"Remove from site",null,"ER","kg",0,2.3793000000000006,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"Dispose on site",null,"ED","kg",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}}]
[30,"Contaminated Soils"]
[null,null,"Remediate on site",null,"CSR","m3",41.637750000000004,129.78,{"$f":"50*1.05","v":52.5},null,"LOW cost: bio-remediate on-site.      HIGH cost: ship off-site to landfil as haz. waste"]
[null,null,"consolidate & cover       ",null,"Use cost code items 1 - 4"]
[null,null,"cover in place            ",null,"Use cost code items 1 - 4"]
[31,"Mobilize Heavy Equipment"]
[null,null,"Mobilize",null,"MHER","each",3.0390150000000005,9.1062300000000018,1811641.26,null,"SPECIFIED cost:  quoted 2005 cost plus 6%"]
[null,null,"Demobilize ",null,"MHEA","each",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},724802.56000000006,null,"SPECIFIED cost:  quoted 2005 cost plus 6%"]
[32,"Mobilize Camp"]
[null,null,"<20 persons Road access",null,"MC<R","each",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"<20 persons Air access",null,"MC<A","each",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}}]
[33,"Mobilize Workers"]
[null,null,"mobilize",null,"MM<","person",208.7295,1070.6849999999999,{"$f":"NA()","v":{"$error":"#N/A"}},null,"LOW cost:  road access.                                       HIGH cost: transport by Twin Otter aircraft"]
[null,null,">20 persons",null,"MM>","person",1070.6849999999999,1427.58,{"$f":"NA()","v":{"$error":"#N/A"}}]
[34,"ACCoModation",null,null,"ACCM","month",1427.58,2141.37,{"$f":"NA()","v":{"$error":"#N/A"}},null,"LOW cost, accom in existing camp,  per man, HIGH cost: - supply new camp"]
[35,"Mobilize Misc. Supplies",null,null,"MMS","each",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},null,"LOW cost:  winter road - limited use, LOW snowfall"]
[36,"Winter Road",null,null,"WR","km",1427.58,2833.53,{"$f":"NA()","v":{"$error":"#N/A"}}]
[37,"Visual site Inspection",null,null,"VI","each",3806.88,7678.6500000000005,10000]
[38,"Survey site Inspection",null,null,"SI","each",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}}]
[39,"Water Sampling",null,null,"WS","each",5948.25,9733.5,{"$f":"NA()","v":{"$error":"#N/A"}}]
[40,"site inspection RePorT",null,null,"RPT","each",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"11000*1.05","v":11550},{"$f":"NA()","v":{"$error":"#N/A"}}]
[41,"Security Guard",null,null,"SG","pers/mon",5665,8327.5500000000011,{"$f":"NA()","v":{"$error":"#N/A"}}]
[42,"Maintain Pumping",null,null,"MP","month",3568.9500000000003,{"$error":"#N/A"},{"$f":"NA()","v":{"$error":"#N/A"}}]
[43,"Clear SpillWay",null,null,"CSW","each",2022.405,5710.32,{"$f":"NA()","v":{"$error":"#N/A"}}]
[44,"Build Treatment Plant"]
[null,null,"Small (< 1000 m3/d)",null,"BTPS","lump sum",1081500,2163000,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"Large (> 1000 m3/d)",null,"BTPL","lump sum",2163000,3785250,{"$f":"NA()","v":{"$error":"#N/A"}}]
[45,"Operate Treatment Plant",null,null,"OTP","m3",0.313635,1.784475,{"$f":"NA()","v":{"$error":"#N/A"}}]
[46,"SCariFY road and ",null,null,"SCFY","km",3812.2874999999999,5353.4250000000002,{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,"install water breaks"]
[]
[]
[null,"water treatment chemicals"]
[null,"ferric sulphate",null,null,"ferric","kg",0.72460500000000017]
[null,"ferrous sulphate",null,null,"ferrous","kg",0.47586000000000006]
[null,"lime",null,null,"lime","kg",0.32445000000000002,""]
[null,"hydrogen peroxide, 50%",null,null,"hperox","kg",1.5465450000000001]
[null,"Sodium Metabisulfate",null,null,"Nametab","kg",1.0706850000000001]
[null,"Caustic soda, 50%",null,null,"caustic","kg",0.67053000000000007]
[null,"Sulfuric acid, 93%",null,null,"sulfuric","kg",0.28119000000000005]
[null,"flocculant",null,null,"flocc","kg",5.8292849999999996]
[null,"copper sulphate",null,null,"copper","kg",0]
[null,"typical shipping, to Whitehorse or Yellowknife",null,null,null,"kg",7.7868000000000007E-2]
[]
[null,"Typical Labour & Equipment Rates"]
[null,null,"Site manager",null,null,"$/hr",75.704999999999998,{"$f":"80*1.05","v":84}]
[null,null,"Mine superintendent",null,null,"$/hr",0,{"$f":"60*1.05","v":63}]
[null,null,"Environmental coordinator",null,null,"$/hr",0,{"$f":"60*1.05","v":63}]
[null,null,"Journeyman (mech, elec, weld)",null,null,"$/hr",54.075000000000003,{"$f":"60*1.05","v":63}]
[null,null,"Equipment operator",null,null,"$/hr",48.667500000000004,{"$f":"55*1.05","v":57.75}]
[null,null,"labour - skilled ",null,null,"$/hr",37.852499999999999,{"$f":"38*1.05","v":39.9}]
[null,null,"labour - unskilled",null,null,"$/hr",34.608000000000004,{"$f":"35*1.05","v":36.75}]
[null,null,"Security / first aid",null,null,"$/hr",41.097000000000001,{"$f":"48*1.05","v":50.400000000000006}]
[null,null,"Admin.",null,null,"$/hr",45.423000000000002,{"$f":"49*1.05","v":51.45}]
[null,null,null,null,null,null,0]
[null,null,"Front end loader, ?, Cat992",null,null,"$/hr",0,{"$f":"330*1.05","v":346.5}]
[null,null,"excavator, Cat235",null,null,"$/hr",0,{"$f":"175*1.05","v":183.75}]
[null,null,"dump truck - tandem",null,null,"$/hr",0]
[null,null,"dump truck off road, Cat 777",null,null,"$/hr",286.59750000000003]
[null,null,"dozer, D8, D10",null,null,"$/hr",183.85500000000002,{"$f":"300*1.05","v":315}]

{"sheet":"Title","index":14,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"RECLAMATION COST ESTIMATING MODEL (Version 4.2)"]
[]
[]
[null,null,null,"Prepared for:"]
["                                     Water Resources Division"]
[null,null,"Department of Indian Affairs and Northern Development (DIAND)"]
[]
[null,null,null,"Prepared by:"]
["Steffen Robertson and Kirsten (Canada) Inc. (SRK)"]
[null,null,"M. John Brodie and Patrick J. Bryan",null,null,"Version 1.1","Lotus 123",null," April 1992"]
[null,null,"R .C. Olauson and R.W. Chambers",null,null,"Version 2.1","Lotus 123",null,"April 1994"]
[]
["Brodie Consulting Ltd."]
[null,null,"M. John Brodie and Kitty Brodie ",null,null,"Version 3.1","Quattro Pro",null,"November 1997"]
[]
["Brodie Consulting Ltd."]
[null,null,"M. John Brodie and Kitty Brodie ",null,null,"Version 4.0","Excel",null,"March 2001"]
[null,null,null,null,null,"Version 4.2","Excel",null,"October 2001"]
[]
["Brodie Consulting Ltd."]
[null,null,"M. John Brodie and Kitty Brodie ",null,null,"Version 5.1","Excel",null,"2005-08-01"]

{"sheet":"Conditions","index":15,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
["CONDITIONS OF USE"]
[]
["This 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.  It is recognized that one model can not cover the full range of possibilities encountered during reclamation.  It is expected, however, that this model is sufficiently comprehensive and flexible to provide the user with a forecasting tool to meet most reclamation situations.  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."]
[]
["DIAND and Brodie Consulting 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."]
[]
[]
["For program limitations, please see the worksheet titled \"Limitations\", which is the last worksheet in the program."]

{"sheet":"Limitations","index":16,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Certain Limitations must be followed in using the Reclaim Program as described below."]
[null,"The Reclaim Program will NOT work if the worksheets are changed such that these assumptions are no longer true."]
[]
["WorkSheet Names","The names of the worksheets must not be changed.  New worksheets can be inserted only if Workbook Protection is turned off using the default menu."]
["Defined Names","Certain ranges have defined names, which must not be changed.  These names appear in the \"Name Box\" to the left of the formula bar."]
["First line of data","The first line of data for any component starts on line 4.  Do not change the first 4 lines of a component worksheet, ie the name and column titles."]
["Cell A1","Cell A1 on the component sheet MUST always contain the count of that component.  This is programmatically controlled.  DO NOT CHANGE."]
["Column A","This must have an entry in every row until the subtotal, for the calculation of where the subtotal is"]
["L,H, Spec","The 3 fields to the right of this cell must not be touched.  They are required, ","L"]
[null,"to make the lookup function work in Unit Costs.","H"]
[null,null,"SPEC"]
["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."]