{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["EZ ECell","E Cell Calculator","Unit Costs","Guide Notes","Revision Notes"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":45,"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":"EZ ECell","index":0,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,1,0,7],[50,1,50,7],[23,2,23,5],[29,1,29,7],[30,1,30,7],[31,1,31,7],[32,1,32,7],[33,1,33,7],[35,1,35,7],[36,1,36,7],[37,1,37,7],[38,1,38,7],[39,1,39,7],[40,1,40,7],[53,1,53,4],[54,1,54,4],[46,1,46,7],[47,1,47,7],[6,1,6,3],[51,1,51,4],[52,1,52,4],[41,1,41,7],[42,1,42,7],[43,1,43,7],[44,1,44,7],[45,1,45,7],[48,1,48,7],[49,1,49,7],[23,6,24,6]]}
[null,"2023 BLM AND NDEP ACCEPTED VERSION"]
[null,"Facility:"]
[null,"Location:"]
[null,"Operator:"]
[null,"Prepared By:"]
[null,"SubmittalDate:"]
[]
[null,"Fleet:"]
[]
[null,"Ex Pond Config:"]
[]
[null,"Pond Area (ac)"]
[null,"Pond Depth (ft)"]
[]
[null,"Slope to Material Source (%)"]
[null,"Distance to Material Source (ft)"]
[]
[null,"Labor",{"$f":"IF(C16=0,\"\",'E Cell Calculator'!C361)","v":""},{"$f":"IF(D16=0,\"\",'E Cell Calculator'!C381)","v":""},{"$f":"IF(E16=0,\"\",'E Cell Calculator'!C401)","v":""},{"$f":"IF(F16=0,\"\",'E Cell Calculator'!C422)","v":""},{"$f":"IF(G16=0,\"\",'E Cell Calculator'!C442)","v":""},{"$f":"IF(H16=0,\"\",'E Cell Calculator'!C462)","v":""}]
[null,"Equip",{"$f":"IF(C16=0,\"\",'E Cell Calculator'!D361)","v":""},{"$f":"IF(D16=0,\"\",'E Cell Calculator'!D381)","v":""},{"$f":"IF(E16=0,\"\",'E Cell Calculator'!D401)","v":""},{"$f":"IF(F16=0,\"\",'E Cell Calculator'!D422)","v":""},{"$f":"IF(G16=0,\"\",'E Cell Calculator'!D442)","v":""},{"$f":"IF(H16=0,\"\",'E Cell Calculator'!D462)","v":""}]
[null,"Material",{"$f":"IF(C16=0,\"\",'E Cell Calculator'!E361)","v":""},{"$f":"IF(D16=0,\"\",'E Cell Calculator'!E381)","v":""},{"$f":"IF(E16=0,\"\",'E Cell Calculator'!E401)","v":""},{"$f":"IF(F16=0,\"\",'E Cell Calculator'!E422)","v":""},{"$f":"IF(G16=0,\"\",'E Cell Calculator'!E442)","v":""},{"$f":"IF(H16=0,\"\",'E Cell Calculator'!E462)","v":""}]
[null,"Total",{"$f":"SUM(C18:C20)","v":0},{"$f":"SUM(D18:D20)","v":0},0,0,0,0]
[null,null,{"$f":"IF(C16=0,\"\",C21/C12)","v":""},"","","","",""]
[]
[null,null,"Summary"]
[null,null,"Labor","Equipment","Material","Total"]
[null,null,{"$f":"IF(SUM(C18:H18)=0,\"\",SUM(C18:H18))","v":""},{"$f":"IF(SUM(C19:H19)=0,\"\",SUM(C19:H19))","v":""},{"$f":"IF(SUM(C20:H20)=0,\"\",SUM(C20:H20))","v":""},{"$f":"IF(SUM(C21:H21)=0,\"\",SUM(C21:H21))","v":""}]
[]
[null,null,null,"Average Cost = ",{"$f":"IF(F26=\"\",\"\",F26/(C12+D12+E12+F12+G12+H12))","v":""}]
[null,"User Notes:"]
[]
[]
[]
[]
[]
[null,"Assumptions:"]
[null,"1) Labor, Equipment and Material Prices are based on 2023 SRCE Cost Data. Cost Basis is Northern Nevada, Mine Plan of Operations, Public/Public Private, Standardized Data."]
[null,"2) Small Fleet: 769D Truck, 325C Excavator, 966G Loader, D9R Dozer, D7R Dozer"]
[null,"3) Large Fleet: 777D Truck, 385BL Excavator, 988G Loader, D10R Dozer, D7R Dozer"]
[null,"4) Excavation, Backfill, Cover, Ripping, Growth Medium and Grading materials are based on Alluvium properties and are from the same source location. "]
[null,"5) Includes revegitation cost over stated pond area."]
[null,"6) Growth Medium/Cover is 24 inches over the stated pond area."]
[null,"7) Mix 2, \"Low Hills\" is used for revegitation seed mix."]
[null,"8) Includes installation costs for 10 foot high chain link perimiter fencing setback 20 feet. Perimiter is 4x square root of the area."]
[null,"9) Includes installation cost for new heap to pond double wall pipe."]
[null,"10) Includes installation cost for one 1500 gallon dosing tank."]
[null,"11) Includes installation costs for distributing piping."]
[null,"12) Includes costs for inspection, repair and removal of 1/2 foot of sludge on existing lined ponds."]
[null,"13) Includes excavation costs for new ponds."]
[null,"14) Includes  installation costs for double liners with geonetting on new and unlined ponds, a single liner, geonetting on single lined ponds, and no liner cost on existing double lined ponds."]
[null,"15) New liner installation includes cost for a key trench"]

{"sheet":"E Cell Calculator","index":1,"n_rows":747,"n_cols":27,"rows_kept":747,"cut":false,"hidden":false,"merged":[[30,3,30,7],[30,8,30,13],[137,0,137,1],[153,0,153,1],[98,9,98,12],[0,0,0,12],[732,12,732,13],[601,5,602,10],[512,1,512,11],[513,2,513,6],[513,7,513,11],[724,12,724,13],[282,0,282,1],[729,12,729,13],[622,4,622,5],[623,4,623,5],[719,12,719,13],[705,12,705,13],[714,12,714,13],[709,12,709,13],[628,4,628,5],[629,4,629,5],[10,9,10,12],[3,9,3,12],[4,9,4,12],[6,9,6,12],[9,9,9,12],[5,9,5,12],[31,0,31,1],[2,9,2,12],[7,9,7,12],[2,7,2,8],[311,0,311,1],[183,0,183,1],[77,0,77,1],[122,0,122,1],[240,0,240,1],[226,0,226,1],[8,9,8,12],[11,9,11,12],[226,8,227,8],[280,0,280,13],[266,0,266,9],[252,0,252,9],[253,0,253,9],[296,0,296,1],[294,0,294,6],[98,3,98,5],[677,7,677,8],[675,5,675,6],[665,5,665,6],[670,5,670,6],[665,7,665,8],[281,3,281,7],[281,8,281,13],[665,3,665,4],[670,3,670,4],[669,7,669,8],[673,7,673,8],[467,1,467,6],[476,0,476,8],[477,0,478,0],[477,1,477,6],[624,4,624,5],[634,4,634,5],[635,4,635,5],[490,1,490,6],[626,4,626,5],[490,0,491,0],[465,1,465,8],[466,0,466,8],[664,9,664,10],[664,7,664,8],[664,5,664,6],[664,3,664,4],[664,1,664,2],[633,4,633,5],[632,4,632,5],[636,4,636,5],[625,4,625,5],[627,4,627,5],[630,4,630,5],[631,4,631,5],[198,0,198,1],[212,0,212,1],[54,2,54,11],[55,0,55,1],[488,1,488,8],[328,0,328,1],[467,0,468,0],[618,1,618,3],[168,0,168,1],[340,0,340,5],[268,0,268,1],[500,0,501,0],[499,0,499,8],[489,0,489,8],[500,1,500,6],[210,0,210,1],[75,0,75,14],[76,2,76,8],[254,0,254,1],[99,0,99,1]]}
["2023 BLM AND NDEP ACCEPTED VERSION"]
[]
["Process Ponds - Cost Summary",null,null,null,"  ",null,null,"Facility Name:  ",null,{"$f":"IF('EZ ECell'!C2=\"\",\"\",'EZ ECell'!C2)","v":""}]
[null,null,"Labor","Equipment","Materials","Totals",null,"Location:",null,{"$f":"IF('EZ ECell'!C3=\"\",\"\",'EZ ECell'!C3)","v":""}]
[null,"Sludge Removal and Disposal","N/A",{"$f":"G131","v":0},"N/A",{"$f":"SUM(C5:E5)","v":0},null,"Operator:",null,{"$f":"IF('EZ ECell'!C4=\"\",\"\",'EZ ECell'!C4)","v":""}]
[null,"Existing Liner Inspect and Repair",{"$f":"E146","v":0},{"$f":"F146","v":0},{"$f":"G146","v":0},0,null,"Prepared By:",null,{"$f":"IF('EZ ECell'!C5=\"\",\"\",'EZ ECell'!C5)","v":""}]
[null,"New Pond Excavation",{"$f":"L162","v":0},{"$f":"M162","v":0},"N/A",0,null,"Date of Submittal:  ",null,{"$f":"IF('EZ ECell'!C6=\"\",\"\",'EZ ECell'!C6)","v":""}]
[null,"Secondary Liner Installation",{"$f":"E177","v":0},{"$f":"F177","v":0},{"$f":"G177","v":0},0,null,"File Name:",null,{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":"EZ_ECellCalculator_07_31_2023.xlsm"}]
[null,"Geonetting",{"$f":"E192","v":0},{"$f":"F192","v":0},{"$f":"G192","v":0},0,null,"Model Version: ",null,"1.0.0 NDEP version 08.01.2023"]
[null,"Primary Liner Installation",{"$f":"E207","v":0},{"$f":"F207","v":0},{"$f":"G207","v":0},0,null,"Cost Data File: ",null,"SRCE_Cost_Data_File_1_12_Std_2023.xlsm"]
[null,"Liner Key Trenching",{"$f":"F221","v":0},{"$f":"G221","v":0},"N/A",0,null,"Cost Data Date: ",null,"2023-08-01"]
[null,"Dosing Tank",{"$f":"F235","v":0},{"$f":"G235","v":0},{"$f":"H235","v":0},0,null,"Cost Basis Category:",null,"Northern Nevada"]
[null,"Piping Manifold",{"$f":"F249","v":0},{"$f":"G249","v":0},{"$f":"H249","v":0},0]
[null,"Screening for Backfill",{"$f":"G263","v":0},{"$f":"H263","v":0},"N/A",0]
[null,"Pond Backfill",{"$f":"H277","v":0},{"$f":"I277","v":0},"N/A",0]
[null,"HLP to Pond to Pond Piping",{"$f":"C305","v":0},{"$f":"D305","v":0},{"$f":"E305","v":0},0]
[null,"Fencing",{"$f":"F320","v":0},{"$f":"G320","v":0},{"$f":"H320","v":0},0]
[null,"Growth Media",{"$f":"H337","v":0},{"$f":"I337","v":0},"N/A",0]
[null,"Subtotal",{"$f":"SUM(C5:C18)","v":0},{"$f":"SUM(D5:D18)","v":0},{"$f":"SUM(E5:E18)","v":0},0]
[null,"Revegetation Costs",{"$f":"L337","v":0},{"$f":"M337","v":0},{"$f":"N337","v":0},0]
[null,"TOTALS",{"$f":"C19+C20","v":0},{"$f":"D19+D20","v":0},{"$f":"E19+E20","v":0},0]
[]
["Color Code Key"]
[null,null,"User Input - Direct Input","Direct Input"]
[null,null,"User Input - Pull Down List","Pull Down Selection"]
[null,null,"Program Constant (can override)","Alternate Input"]
[null,null,"Program Calculated Value","Locked Cell - Formula or Reference"]
[]
[]
["Evaporation Cell - User Input",null,null,null,"You must fill in ALL green cells and relevant blue cells in this section for each pond"]
[null,null,null,"Pond Physical Dimensions (1)",null,null,null,null,"New Pond Parameters"]
["Description\n(required)",null,"Operators  ID Code","Pond\nLength","Pond\nWidth","Pond Depth/Berm Height","Pond\nSide slope\nAngle","Feeboard","New Pond Ground Slope","New Pond Crest Width, Min 20'","New Pond Max Emb. Height","Excavating Material","Material Type","Excavating Equipment Fleet"]
[-1,null,null,"ft","ft","ft","_H:1V","ft","% grade","ft","ft","(select)","(select)","(select)"]
[1,{"$f":"IF('EZ ECell'!C2=\"\",\"\",'EZ ECell'!C2)","v":""},null,{"$f":"IF('EZ ECell'!C$12=\"\",\"\",SQRT('EZ ECell'!C$12*43560))","v":""},{"$f":"IF('EZ ECell'!C$12=\"\",\"\",SQRT('EZ ECell'!C$12*43560))","v":""},{"$f":"'EZ ECell'!C$13","v":0},3,0,0.02,20,{"$f":"F34","v":0},1,"Gravel",{"$f":"IF('EZ ECell'!$C$8=\"Small Fleet\",\"D7R\",IF('EZ ECell'!$C$8=\"Large Fleet\",\"D10R\"))","v":false}]
[{"$f":"A34+1","v":2},{"$f":"IF('EZ ECell'!D2=\"\",\"\",'EZ ECell'!D2)","v":""},null,{"$f":"IF('EZ ECell'!D$12=\"\",\"\",SQRT('EZ ECell'!D$12*43560))","v":""},{"$f":"IF('EZ ECell'!D$12=\"\",\"\",SQRT('EZ ECell'!D$12*43560))","v":""},{"$f":"'EZ ECell'!D$13","v":0},{"$f":"G34","v":3},0,0.02,20,0,1,"Gravel",{"$f":"IF('EZ ECell'!$D$8=\"Small Fleet\",\"D7R\",IF('EZ ECell'!$D$8=\"Large Fleet\",\"D10R\"))","v":false}]
[3,{"$f":"IF('EZ ECell'!E2=\"\",\"\",'EZ ECell'!E2)","v":""},null,{"$f":"IF('EZ ECell'!E$12=\"\",\"\",SQRT('EZ ECell'!E$12*43560))","v":""},{"$f":"IF('EZ ECell'!E$12=\"\",\"\",SQRT('EZ ECell'!E$12*43560))","v":""},{"$f":"'EZ ECell'!E$13","v":0},{"$f":"G34","v":3},0,0.02,20,0,1,"Gravel",{"$f":"IF('EZ ECell'!$E$8=\"Small Fleet\",\"D7R\",IF('EZ ECell'!$E$8=\"Large Fleet\",\"D10R\"))","v":false}]
[4,{"$f":"IF('EZ ECell'!F2=\"\",\"\",'EZ ECell'!F2)","v":""},null,{"$f":"IF('EZ ECell'!F$12=\"\",\"\",SQRT('EZ ECell'!F$12*43560))","v":""},{"$f":"IF('EZ ECell'!F$12=\"\",\"\",SQRT('EZ ECell'!F$12*43560))","v":""},{"$f":"'EZ ECell'!F$13","v":0},{"$f":"G34","v":3},0,0.02,20,0,1,"Gravel",{"$f":"IF('EZ ECell'!$F$8=\"Small Fleet\",\"D7R\",IF('EZ ECell'!$F$8=\"Large Fleet\",\"D10R\"))","v":false}]
[5,{"$f":"IF('EZ ECell'!G$2=\"\",\"\",'EZ ECell'!G$2)","v":""},null,{"$f":"IF('EZ ECell'!G$12=\"\",\"\",SQRT('EZ ECell'!G$12*43560))","v":""},{"$f":"IF('EZ ECell'!G$12=\"\",\"\",SQRT('EZ ECell'!G$12*43560))","v":""},{"$f":"'EZ ECell'!G$13","v":0},{"$f":"G34","v":3},0,0.02,20,0,1,"Gravel",{"$f":"IF('EZ ECell'!$G$8=\"Small Fleet\",\"D7R\",IF('EZ ECell'!$G$8=\"Large Fleet\",\"D10R\"))","v":false}]
[6,{"$f":"IF('EZ ECell'!H$2=\"\",\"\",'EZ ECell'!H$2)","v":""},null,{"$f":"IF('EZ ECell'!H$12=\"\",\"\",SQRT('EZ ECell'!H$12*43560))","v":""},{"$f":"IF('EZ ECell'!H$12=\"\",\"\",SQRT('EZ ECell'!H$12*43560))","v":""},{"$f":"'EZ ECell'!H$13","v":0},{"$f":"G34","v":3},0,0.02,20,0,1,"Gravel",{"$f":"IF('EZ ECell'!$H$8=\"Small Fleet\",\"D7R\",IF('EZ ECell'!$H$8=\"Large Fleet\",\"D10R\"))","v":false}]
[7]
[{"$f":"A40+1","v":8}]
[9]
[10]
[]
["(1)  Existing or Proposed Pond Dimensions"]
["(2) Max Berm Height at Center of Berm to Natural Ground, Assume Minimum Emb. Width 20 feet"]
[null,"Comments:"]
[]
[]
[]
[]
[]
[]
["Evaporation Cell - User Input",null,null,null,"You must fill in ALL green cells and relevant blue cells in this section for each pond"]
[null,null,"Pond Screening and Backfill (1)"]
["Description",null,"Backfill  Source\nMaterial","Backfill Material","Distance from Backfill Borrow","Slope from Facility to Borrow Area","Backfill\nEquipment Fleet","Fleet Override User Input","Dozing Material","Screen Material","Screening\nEquipment Fleet","Processing Material Losses(3)"]
[null,null,"(select)","(select)","ft","% grade","(select)",null,"(select)",null,"(select)","%"]
[{"$f":"A34","v":1},{"$f":"B34","v":""},"Gravel",1,{"$f":"'EZ ECell'!C$16","v":0},{"$f":"'EZ ECell'!$C$15","v":0},{"$f":"IF('EZ ECell'!$C$8=\"Small Fleet\",\"769D 988G D7R\",IF('EZ ECell'!$C$8=\"Large Fleet\",\"777D 992G D7R\"))","v":false},null,1,"Yes",{"$f":"IF('EZ ECell'!$C$8=\"Small Fleet\",\"988G\",IF('EZ ECell'!$C$8=\"Large Fleet\",\"992G\"))","v":false},0.55000000000000004]
[{"$f":"A35","v":2},"","Gravel",1,{"$f":"'EZ ECell'!D$16","v":0},{"$f":"'EZ ECell'!$D$15","v":0},{"$f":"IF('EZ ECell'!$D$8=\"Small Fleet\",\"769D 988G D7R\",IF('EZ ECell'!$D$8=\"Large Fleet\",\"777D 992G D7R\"))","v":false},null,1,"Yes",{"$f":"IF('EZ ECell'!$D$8=\"Small Fleet\",\"988G\",IF('EZ ECell'!$D$8=\"Large Fleet\",\"992G\"))","v":false},0.55000000000000004]
[3,"","Gravel",1,{"$f":"'EZ ECell'!E$16","v":0},{"$f":"'EZ ECell'!$E$15","v":0},{"$f":"IF('EZ ECell'!$E$8=\"Small Fleet\",\"769D 988G D7R\",IF('EZ ECell'!$E$8=\"Large Fleet\",\"777D 992G D7R\"))","v":false},null,1,"Yes",{"$f":"IF('EZ ECell'!$E$8=\"Small Fleet\",\"988G\",IF('EZ ECell'!$E$8=\"Large Fleet\",\"992G\"))","v":false},0.55000000000000004]
[4,"","Gravel",1,{"$f":"'EZ ECell'!F$16","v":0},{"$f":"'EZ ECell'!$F$15","v":0},{"$f":"IF('EZ ECell'!$F$8=\"Small Fleet\",\"769D 988G D7R\",IF('EZ ECell'!$F$8=\"Large Fleet\",\"777D 992G D7R\"))","v":false},null,1,"Yes",{"$f":"IF('EZ ECell'!$F$8=\"Small Fleet\",\"988G\",IF('EZ ECell'!$F$8=\"Large Fleet\",\"992G\"))","v":false},0.55000000000000004]
[5,"","Gravel",1,{"$f":"'EZ ECell'!G$16","v":0},{"$f":"'EZ ECell'!$G$15","v":0},{"$f":"IF('EZ ECell'!$G$8=\"Small Fleet\",\"769D 988G D7R\",IF('EZ ECell'!$G$8=\"Large Fleet\",\"777D 992G D7R\"))","v":false},null,1,"Yes",{"$f":"IF('EZ ECell'!$G$8=\"Small Fleet\",\"988G\",IF('EZ ECell'!$G$8=\"Large Fleet\",\"992G\"))","v":false},0.55000000000000004]
[6,"","Gravel",1,{"$f":"'EZ ECell'!H$16","v":0},{"$f":"'EZ ECell'!$H$15","v":0},{"$f":"IF('EZ ECell'!$H$8=\"Small Fleet\",\"769D 988G D7R\",IF('EZ ECell'!$H$8=\"Large Fleet\",\"777D 992G D7R\"))","v":false},null,1,"Yes",{"$f":"IF('EZ ECell'!$H$8=\"Small Fleet\",\"988G\",IF('EZ ECell'!$H$8=\"Large Fleet\",\"992G\"))","v":false},0.55000000000000004]
[7,0]
[8,0,null,null,null,null,"`"]
[9,0]
[10,0]
[null,""]
[]
[null,"Comments:"]
[]
[]
[]
[]
[]
["Evaporation Cell- User Input (cont.) Flat Areas Second Generation Considerations"]
[null,null,"Growth Media",null,null,null,null,null,null,"Revegetation "]
["Description",null,"Additional Disturbance (Not in SRCE)","Growth Media Thickness","Distance from Growth Media Stockpile","Slope from Facility to GM Stockpile","Growth Media \nMaterial","Growth Media Equipment Fleet","Fleet Override User Input","Average Long Dimension (rip dist.)","Scarify/Rip?","Seed Mix","Mulch","Fertilizer","Ripping Fleet"]
[null,null,"acres","in","ft","% grade","(select)","(select)",null,"(ft)","(select)","(select)","(select)","(select)","(select)"]
[{"$f":"A34","v":1},"",null,24,{"$f":"'EZ ECell'!$C$16","v":0},{"$f":"'EZ ECell'!$C$15","v":0},"Gravel",{"$f":"IF('EZ ECell'!$C$8=\"Small Fleet\",\"769D 988G D7R\",IF('EZ ECell'!$C$8=\"Large Fleet\",\"777D 992G D7R\"))","v":false},null,{"$f":"E34","v":""},null,"User Mix 1"]
[2,"",null,24,{"$f":"'EZ ECell'!$D$16","v":0},{"$f":"'EZ ECell'!$D$15","v":0},"Gravel",{"$f":"IF('EZ ECell'!$D$8=\"Small Fleet\",\"769D 988G D7R\",IF('EZ ECell'!$D$8=\"Large Fleet\",\"777D 992G D7R\"))","v":false},null,"",null,"User Mix 1"]
[3,"",null,24,{"$f":"'EZ ECell'!$E$16","v":0},{"$f":"'EZ ECell'!$E$15","v":0},"Gravel",{"$f":"IF('EZ ECell'!$E$8=\"Small Fleet\",\"769D 988G D7R\",IF('EZ ECell'!$E$8=\"Large Fleet\",\"777D 992G D7R\"))","v":false},null,"",null,"User Mix 1"]
[4,"",null,24,{"$f":"'EZ ECell'!$F$16","v":0},{"$f":"'EZ ECell'!$F$15","v":0},"Gravel",{"$f":"IF('EZ ECell'!$F$8=\"Small Fleet\",\"769D 988G D7R\",IF('EZ ECell'!$F$8=\"Large Fleet\",\"777D 992G D7R\"))","v":false},null,"",null,"User Mix 1"]
[5,"",null,24,{"$f":"'EZ ECell'!$G$16","v":0},{"$f":"'EZ ECell'!$G$15","v":0},"Gravel",{"$f":"IF('EZ ECell'!$G$8=\"Small Fleet\",\"769D 988G D7R\",IF('EZ ECell'!$G$8=\"Large Fleet\",\"777D 992G D7R\"))","v":false},null,"",null,"User Mix 1"]
[6,"",null,24,{"$f":"'EZ ECell'!$H$16","v":0},{"$f":"'EZ ECell'!$H$15","v":0},"Gravel",{"$f":"IF('EZ ECell'!$H$8=\"Small Fleet\",\"769D 988G D7R\",IF('EZ ECell'!$H$8=\"Large Fleet\",\"777D 992G D7R\"))","v":false},null,"",null,"User Mix 1"]
[]
[]
[]
[]
[null,""]
[]
[null,"Comments:"]
[]
[]
[]
[]
[]
["Evaporation Cell- User Input (cont.)"]
[null,null,"Fence","Liner",null,null,"Sludge Removal and Disposal",null,null,"HLP-Pond-Pond Piping"]
["Description",null,"Existing Fence Condition","Primary Liner ","Secondary Liner","Existing Pond","Distance to Disposal Area","Slope to Disposal Area","Number\nof\nTrucks","Piping Description","Distance from HLP to Pond","Slope from Source","Distance to Next Ponds"]
[null,null,null,"mil","mil","(select)","ft","% grade",null,null,"ft","% grade","ft"]
[{"$f":"A34","v":1},"",null,"60 mil HDPE ","60 mil HDPE ",{"$f":"'EZ ECell'!C$10","v":0},{"$f":"'EZ ECell'!$C$16","v":0},{"$f":"'EZ ECell'!$C$15","v":0},1,null,500,0]
[2,"",null,{"$f":"D102","v":"60 mil HDPE "},{"$f":"E102","v":"60 mil HDPE "},{"$f":"'EZ ECell'!D$10","v":0},{"$f":"'EZ ECell'!$D$16","v":0},{"$f":"'EZ ECell'!$D$15","v":0},1,null,500,0]
[3,"",null,{"$f":"D102","v":"60 mil HDPE "},{"$f":"E102","v":"60 mil HDPE "},{"$f":"'EZ ECell'!E$10","v":0},{"$f":"'EZ ECell'!$E$16","v":0},{"$f":"'EZ ECell'!$E$15","v":0},1,null,500,0]
[4,"",null,{"$f":"D102","v":"60 mil HDPE "},{"$f":"E102","v":"60 mil HDPE "},{"$f":"'EZ ECell'!F$10","v":0},{"$f":"'EZ ECell'!$F$16","v":0},{"$f":"'EZ ECell'!$F$15","v":0},1,null,500,0]
[5,"",null,{"$f":"D102","v":"60 mil HDPE "},{"$f":"E102","v":"60 mil HDPE "},{"$f":"'EZ ECell'!G$10","v":0},{"$f":"'EZ ECell'!$G$16","v":0},{"$f":"'EZ ECell'!$G$15","v":0},1,null,500,0]
[6,"",null,{"$f":"D102","v":"60 mil HDPE "},{"$f":"E102","v":"60 mil HDPE "},{"$f":"'EZ ECell'!H$10","v":0},{"$f":"'EZ ECell'!$H$16","v":0},{"$f":"'EZ ECell'!$H$15","v":0},1,null,500,0]
[7,0]
[8,0]
[9,0]
[10,0]
[null,""]
[]
[null,"Comments:"]
[]
[]
[]
[]
[]
[]
["Sludge Removal and Disposal, 5000 gal Vacuum Truck"]
[]
["Description\n(required)",null,"(2) Sludge Volume","Fleet Productivity","Number of Vacuum Trucks","Total Fleet Hours","Total Labor & Equipment Cost","Total Sludge Removal\nCost","Unit Cost"]
[null,null,"cy","cy/hr",null,"hrs",null,null,"$/cy"]
[{"$f":"A34","v":1},"",{"$f":"IF(B34=\"\",0,IF(F102=\"New Pond\",F102,((((E34-(2*F34*G34))+G34)/2/G34)*((E34-(2*F34*G34))+G34)/6*((2*((D34-(2*F34*G34))+G34))+(((D34-(2*F34*G34))+G34)-((E34-(2*F34*G34))+G34)))-(((((E34-(2*F34*G34))+G34)/2/G34)-0.5)*(((E34-(2*F34*G34))+G34)-(2*0.5*G34))*(2*(((D34-(2*F34*G34))+G34)-(2*0.5*G34))+(((D34-(2*F34*G34))+G34)-((E34-(2*F34*G34))+G34)))/6))/27))","v":0},{"$f":"IF(B34=\"\",0,IF(C125=\"New Pond\",0,(C125/((2*(G102/5280)/7)*(C125/24.75)+(0.75*C125/24.75))))*E125)","v":0},{"$f":"IF(D34=\"\",0,IF(C125=\"New Pond\",0,IF(I102=\"\",1,I102)))","v":0},{"$f":"IF(C125=\"New Pond\",0,(2*(G102/5280)/7)*(C125/24.75)+(0.75*C125/24.75))","v":0},{"$f":"F125*'Unit Costs'!$D$55","v":0},{"$f":"G125","v":0},{"$f":"IF(B125=\"\",0,IF(F102=\"New Pond\",0,H125/C125))","v":0}]
[2,"",0,{"$f":"IF(B35=\"\",0,IF(C126=\"New Pond\",0,(C126/((2*(G103/5280)/7)*(C126/24.75)+(0.75*C126/24.75))))*E126)","v":0},{"$f":"IF(D35=\"\",0,IF(C126=\"New Pond\",0,IF(I103=\"\",1,I103)))","v":0},{"$f":"IF(C126=\"New Pond\",0,(2*(G103/5280)/7)*(C126/24.75)+(0.75*C126/24.75))","v":0},{"$f":"F126*'Unit Costs'!$D$55","v":0},0,0]
[3,"",0,0,0,0,{"$f":"F127*'Unit Costs'!$D$55","v":0},0,0]
[4,"",0,0,0,0,{"$f":"F128*'Unit Costs'!$D$55","v":0},0,0]
[5,"",0,0,0,0,{"$f":"F129*'Unit Costs'!$D$55","v":0},0,0]
[6,"",0,0,0,0,{"$f":"F130*'Unit Costs'!$D$55","v":0},0,0]
[null,null,{"$f":"SUM(C125:C130)","v":0},null,null,{"$f":"SUM(F125:F130)","v":0},{"$f":"SUM(G125:G130)","v":0},{"$f":"SUM(H125:H130)","v":0}]
[]
[null,"(2) Sludge Volume assumes a 0.5 ft layer of sludge on all existing ponds."]
[]
[]
["Existing Liner Inspection and Repair"]
[]
["Description\n(required)",null,"Liner Area","Crew Hours","Total \nLabor \nCost","Total \nEquipment \nCost","Total \nMaterial\nCost","Total \nLiner Installation\nCost","Unit Cost"]
[null,null,"sf","hrs",null,null,null,null,"$/sf"]
[{"$f":"A34","v":1},"",{"$f":"IF(D34=\"\",0,(IF(F102=\"Single Liner\",((D34-(2*F34*G34))*(E34-(2*F34*G34))+SQRT((F34)^2+(2*F34*G34)^2)*((D34+(D34-(2*F34*G34)))+(E34+(E34-(2*F34*G34))))/2+8*(D34+4)+8*(E34+4)),IF(F102=\"Double Liner\",((D34-(2*F34*G34))*(E34-(2*F34*G34))+SQRT((F34)^2+(2*F34*G34)^2)*((D34+(D34-(2*F34*G34)))+(E34+(E34-(2*F34*G34))))/2+8*(D34+4)+8*(E34+4)),\"No Ex Liner\"))))","v":0},{"$f":"IF(D34=\"\",0,IF(C140=\"No Ex Liner\",0,C140/'Unit Costs'!F$70/8))","v":0},{"$f":"'Unit Costs'!$C$23*D140","v":0},{"$f":"'Unit Costs'!$B$23*D140","v":0},{"$f":"IF(C140=\"No Ex Liner\",0,'Unit Costs'!G$70*C140/100)","v":0},{"$f":"SUM(E140:G140)","v":0},{"$f":"IF(C140=0,0,IF(C140=\"No Ex Liner\",0,H140/C140))","v":0}]
[2,"",0,{"$f":"IF(D35=\"\",0,IF(C141=\"No Ex Liner\",0,C141/'Unit Costs'!F$70/8))","v":0},{"$f":"'Unit Costs'!$C$23*D141","v":0},{"$f":"'Unit Costs'!$B$23*D141","v":0},{"$f":"IF(C141=\"No Ex Liner\",0,'Unit Costs'!G$70*C141/100)","v":0},0,0]
[3,"",0,{"$f":"IF(D36=\"\",0,IF(C142=\"No Ex Liner\",0,C142/'Unit Costs'!F$70/8))","v":0},{"$f":"'Unit Costs'!$C$23*D142","v":0},{"$f":"'Unit Costs'!$B$23*D142","v":0},{"$f":"IF(C142=\"No Ex Liner\",0,'Unit Costs'!G$70*C142/100)","v":0},0,0]
[4,"",0,{"$f":"IF(D37=\"\",0,IF(C143=\"No Ex Liner\",0,C143/'Unit Costs'!F$70/8))","v":0},{"$f":"'Unit Costs'!$C$23*D143","v":0},{"$f":"'Unit Costs'!$B$23*D143","v":0},{"$f":"IF(C143=\"No Ex Liner\",0,'Unit Costs'!G$70*C143/100)","v":0},0,0]
[5,"",0,{"$f":"IF(D38=\"\",0,IF(C144=\"No Ex Liner\",0,C144/'Unit Costs'!F$70/8))","v":0},{"$f":"'Unit Costs'!$C$23*D144","v":0},{"$f":"'Unit Costs'!$B$23*D144","v":0},{"$f":"IF(C144=\"No Ex Liner\",0,'Unit Costs'!G$70*C144/100)","v":0},0,0]
[6,"",0,{"$f":"IF(D39=\"\",0,IF(C145=\"No Ex Liner\",0,C145/'Unit Costs'!F$70/8))","v":0},{"$f":"'Unit Costs'!$C$23*D145","v":0},{"$f":"'Unit Costs'!$B$23*D145","v":0},{"$f":"IF(C145=\"No Ex Liner\",0,'Unit Costs'!G$70*C145/100)","v":0},0,0]
[null,null,{"$f":"SUM(C140:C145)","v":0},{"$f":"SUM(D140:D145)","v":0},0,0,0,0]
[]
[]
[]
[]
["Evaporation Ponds - Construction/Grading Costs"]
[null,"Productivity = Excavator Productivity x Grade Correction x Density Correction x Operator (0.75) x Material x Visibility x Job Efficiency (0.83)",null,null,null,null,null,null,null,null,null,"Earthwork"]
[]
["Description\n(required)",null,"Regrading\nVolume","Dozing\nDistance\n(see above)","Excavation Fleet","Uncorrected\nDozer\nProductivity","Grade\nCorrection","Density\nCorrection","Excavating\nMaterial","Corrected\nProductivity","Total Dozer Hours","(BR)Total \nLabor \nCost","Total \nEquipment \nCost","Total Const./ Regrading Cost","Unit Cost"]
[null,null,"BCY","ft",null,"LCY/hr",null,null,null,"LCY/hr","hr","$","$","$","$/cy"]
[{"$f":"A34","v":1},"",{"$f":"IF(D34=\"\",0,IF(F102=\"New Pond\",(((J34+(J34+(2*K34*G34)))*(K34/2))*1.5*D34/27/1.25),\"Existing Pond\"))","v":0},{"$f":"IF(B156=\"\",0,IF(C156=\"Existing Pond\",0,IF(E34>400,400,E34)))","v":0},{"$f":"IF(B156=\"\",0,IF(D156=\"Existing Pond\",\"\",N34))","v":0},{"$f":"IF(C156=\"Existing Pond\",0,IF(D34=\"\",0,IF(N34=F$661,22719*D156^-0.7796,IF(N34=F$662,89889*D156^-0.9425,81639*D156^-0.8502))))","v":0},{"$f":"IF(C156=\"Existing Pond\",0,IF(D34=\"\",0,1))","v":0},{"$f":"IF(C156=\"Existing Pond\",0,IF(D34=\"\",0,IF(M34=\"alluvium\",0.79,IF(M34=\"Basalt\",0.7,IF(M34=\"Clay - Dry\",0.92,IF(M34=\"Granite - broken\",0.82,IF(M34=\"Gravel\",0.9,IF(M34=\"LS - broken\",0.88,IF(M34=\"Sandstone\",0.9,IF(M34=\"Shale\",1.1,IF(M34=\"Stone - crushed\",0.85,IF(M34=\"Tailings - Coarse (dry, loose sand)\",0.96,IF(M34=\"Tailings - Slimes (loose sand & clay)\",0.85,IF(M34=\"Topsoil\",1.44,\"Select Material\"))))))))))))))","v":0},{"$f":"IF(C156=\"Existing Pond\",0,L34)","v":1},{"$f":"IF(D34=\"\",0,F156*G156*H156*0.75*I156*0.83)","v":0},{"$f":"IF(F102=\"New Pond\",ROUND(C156/J156,0),0)","v":0},{"$f":"IF(B156=\"\",0,IF(B156=0,0,IF(C156=\"Existing Pond\",0,K156*(IF(N34=F$661,('Unit Costs'!B$35),IF(N34=F$662,('Unit Costs'!B$34),IF(N34=F$663,('Unit Costs'!B$33),\"Select Fleet\")))))))","v":0},{"$f":"IF(B156=\"\",0,IF(B156=0,0,IF(C156=\"Existing Pond\",0,K156*IF(N34=F$661,('Unit Costs'!C$35),IF(N34=F$662,('Unit Costs'!C$34),IF(N34=F$663,('Unit Costs'!C$33),\"Select Fleet\"))))))","v":0},{"$f":"SUM(L156:M156)","v":0},{"$f":"IF(B156=\"\",0,IF(C156=\"Existing Pond\",0,N156/C156))","v":0}]
[2,"",0,0,0,0,0,0,1,0,0,{"$f":"IF(B157=\"\",0,IF(B157=0,0,IF(C157=\"Existing Pond\",0,K157*(IF(N35=F$661,('Unit Costs'!B$35),IF(N35=F$662,('Unit Costs'!B$34),IF(N35=F$663,('Unit Costs'!B$33),\"Select Fleet\")))))))","v":0},{"$f":"IF(B157=\"\",0,IF(B157=0,0,IF(C157=\"Existing Pond\",0,K157*IF(N35=F$661,('Unit Costs'!C$35),IF(N35=F$662,('Unit Costs'!C$34),IF(N35=F$663,('Unit Costs'!C$33),\"Select Fleet\"))))))","v":0},0,{"$f":"IF(B157=\"\",0,IF(C157=\"Existing Pond\",0,N157/C157))","v":0}]
[3,"",0,0,0,0,0,0,1,0,0,{"$f":"IF(B158=\"\",0,IF(B158=0,0,IF(C158=\"Existing Pond\",0,K158*(IF(N36=F$661,('Unit Costs'!B$35),IF(N36=F$662,('Unit Costs'!B$34),IF(N36=F$663,('Unit Costs'!B$33),\"Select Fleet\")))))))","v":0},{"$f":"IF(B158=\"\",0,IF(B158=0,0,IF(C158=\"Existing Pond\",0,K158*IF(N36=F$661,('Unit Costs'!C$35),IF(N36=F$662,('Unit Costs'!C$34),IF(N36=F$663,('Unit Costs'!C$33),\"Select Fleet\"))))))","v":0},0,0]
[4,"",0,0,0,0,0,0,1,0,0,{"$f":"IF(B159=\"\",0,IF(B159=0,0,IF(C159=\"Existing Pond\",0,K159*(IF(N37=F$661,('Unit Costs'!B$35),IF(N37=F$662,('Unit Costs'!B$34),IF(N37=F$663,('Unit Costs'!B$33),\"Select Fleet\")))))))","v":0},{"$f":"IF(B159=\"\",0,IF(B159=0,0,IF(C159=\"Existing Pond\",0,K159*IF(N37=F$661,('Unit Costs'!C$35),IF(N37=F$662,('Unit Costs'!C$34),IF(N37=F$663,('Unit Costs'!C$33),\"Select Fleet\"))))))","v":0},0,0]
[5,"",0,0,0,0,0,0,1,0,0,{"$f":"IF(B160=\"\",0,IF(B160=0,0,IF(C160=\"Existing Pond\",0,K160*(IF(N38=F$661,('Unit Costs'!B$35),IF(N38=F$662,('Unit Costs'!B$34),IF(N38=F$663,('Unit Costs'!B$33),\"Select Fleet\")))))))","v":0},{"$f":"IF(B160=\"\",0,IF(B160=0,0,IF(C160=\"Existing Pond\",0,K160*IF(N38=F$661,('Unit Costs'!C$35),IF(N38=F$662,('Unit Costs'!C$34),IF(N38=F$663,('Unit Costs'!C$33),\"Select Fleet\"))))))","v":0},0,0]
[6,"",0,0,0,0,0,0,1,0,0,{"$f":"IF(B161=\"\",0,IF(B161=0,0,IF(C161=\"Existing Pond\",0,K161*(IF(N39=F$661,('Unit Costs'!B$35),IF(N39=F$662,('Unit Costs'!B$34),IF(N39=F$663,('Unit Costs'!B$33),\"Select Fleet\")))))))","v":0},{"$f":"IF(B161=\"\",0,IF(B161=0,0,IF(C161=\"Existing Pond\",0,K161*IF(N39=F$661,('Unit Costs'!C$35),IF(N39=F$662,('Unit Costs'!C$34),IF(N39=F$663,('Unit Costs'!C$33),\"Select Fleet\"))))))","v":0},0,0]
[null,null,{"$f":"SUM(C156:C161)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(K156:K161)","v":0},{"$f":"SUM(L156:L161)","v":0},{"$f":"SUM(M156:M161)","v":0},{"$f":"SUM(N156:N161)","v":0}]
[]
["Productivity = Dozer Productivity x Grade Correction x Density Correction x Operator (0.75) x Material x Visibility x Job Efficiency (0.83)"]
[]
[]
["Bottom (Secondary) Liner  Installation (New Pond or Unlined Only)",null,null,null,null,null,null,null,null,null,"`"]
[]
["Description\n(required)",null,"Liner Area","Crew Hours","Total \nLabor \nCost","Total \nEquipment \nCost","Total \nMaterial\nCost","Total \nLiner Installation\nCost","Unit Cost"]
[null,null,"sf","hrs",null,null,null,null,"$/sf"]
[{"$f":"A34","v":1},"",{"$f":"IF(D34=\"\",0,IF(OR(F102=\"New Pond\",F102=\"Unlined\"),(D34-(2*F34*G34))*(E34-(2*F34*G34))+SQRT((F34)^2+(2*F34*G34)^2)*((D34+(D34-(2*F34*G34)))+(E34+(E34-(2*F34*G34))))/2+8*(D34+4)+8*(E34+4),\"Ex Primary\"))","v":0},{"$f":"IF(B171=\"\",\"\",IF(C171=\"Ex Primary\",0,(8*C171/('Unit Costs'!F$63+'Unit Costs'!F$64+(IF(E102=M$643,'Unit Costs'!F$66,IF(E102=M$644,'Unit Costs'!F$67,IF(E102=M$645,'Unit Costs'!F$68,IF(E102=M$646,'Unit Costs'!F$69,IF(E102=M$647,'Unit Costs'!F$70,\"Select Liner\"))))))))))","v":""},{"$f":"IF(C171=\"Ex Primary\",0,((IF(E102=M$643,'Unit Costs'!H$66,IF(E102=M$644,'Unit Costs'!H$67,IF(E102=M$645,'Unit Costs'!H$68,IF(E102=M$646,'Unit Costs'!H$69,IF(E102=M$647,'Unit Costs'!H$70,\"Select Liner\"))))))+('Unit Costs'!H$63+'Unit Costs'!H$64))*C171)","v":0},{"$f":"IF(C171=\"Ex Primary\",0,((IF(E102=M$643,'Unit Costs'!I$66,IF(E102=M$644,'Unit Costs'!I$67,IF(E102=M$645,'Unit Costs'!I$68,IF(E102=M$646,'Unit Costs'!I$69,IF(E102=M$647,'Unit Costs'!I$70,\"Select Liner\"))))))+('Unit Costs'!I$63+'Unit Costs'!I$64))*C171)","v":0},{"$f":"IF(C171=\"Ex Primary\",0,(IF(E102=M$643,'Unit Costs'!G$66,IF(E102=M$644,'Unit Costs'!G$67,IF(E102=M$645,'Unit Costs'!G$68,IF(E102=M$646,'Unit Costs'!G$69,IF(E102=M$647,'Unit Costs'!G$70,\"Select Liner\"))))))*C171)","v":0},{"$f":"SUM(E171:G171)","v":0},{"$f":"IF(C171=0,0,IF(C171=\"Ex Primary\",0,H171/C171))","v":0}]
[2,"",0,{"$f":"IF(B172=\"\",\"\",IF(C172=\"Ex Primary\",0,(8*C172/('Unit Costs'!F$63+'Unit Costs'!F$64+(IF(E103=M$643,'Unit Costs'!F$66,IF(E103=M$644,'Unit Costs'!F$67,IF(E103=M$645,'Unit Costs'!F$68,IF(E103=M$646,'Unit Costs'!F$69,IF(E103=M$647,'Unit Costs'!F$70,\"Select Liner\"))))))))))","v":""},{"$f":"IF(C172=\"Ex Primary\",0,((IF(E103=M$643,'Unit Costs'!H$66,IF(E103=M$644,'Unit Costs'!H$67,IF(E103=M$645,'Unit Costs'!H$68,IF(E103=M$646,'Unit Costs'!H$69,IF(E103=M$647,'Unit Costs'!H$70,\"Select Liner\"))))))+('Unit Costs'!H$63+'Unit Costs'!H$64))*C172)","v":0},{"$f":"IF(C172=\"Ex Primary\",0,((IF(E103=M$643,'Unit Costs'!I$66,IF(E103=M$644,'Unit Costs'!I$67,IF(E103=M$645,'Unit Costs'!I$68,IF(E103=M$646,'Unit Costs'!I$69,IF(E103=M$647,'Unit Costs'!I$70,\"Select Liner\"))))))+('Unit Costs'!I$63+'Unit Costs'!I$64))*C172)","v":0},{"$f":"IF(C172=\"Ex Primary\",0,(IF(E103=M$643,'Unit Costs'!G$66,IF(E103=M$644,'Unit Costs'!G$67,IF(E103=M$645,'Unit Costs'!G$68,IF(E103=M$646,'Unit Costs'!G$69,IF(E103=M$647,'Unit Costs'!G$70,\"Select Liner\"))))))*C172)","v":0},0,{"$f":"IF(C172=0,0,IF(C172=\"Ex Primary\",0,H172/C172))","v":0}]
[3,"",0,{"$f":"IF(B173=\"\",\"\",IF(C173=\"Ex Primary\",0,(8*C173/('Unit Costs'!F$63+'Unit Costs'!F$64+(IF(E104=M$643,'Unit Costs'!F$66,IF(E104=M$644,'Unit Costs'!F$67,IF(E104=M$645,'Unit Costs'!F$68,IF(E104=M$646,'Unit Costs'!F$69,IF(E104=M$647,'Unit Costs'!F$70,\"Select Liner\"))))))))))","v":""},{"$f":"IF(C173=\"Ex Primary\",0,((IF(E104=M$643,'Unit Costs'!H$66,IF(E104=M$644,'Unit Costs'!H$67,IF(E104=M$645,'Unit Costs'!H$68,IF(E104=M$646,'Unit Costs'!H$69,IF(E104=M$647,'Unit Costs'!H$70,\"Select Liner\"))))))+('Unit Costs'!H$63+'Unit Costs'!H$64))*C173)","v":0},{"$f":"IF(C173=\"Ex Primary\",0,((IF(E104=M$643,'Unit Costs'!I$66,IF(E104=M$644,'Unit Costs'!I$67,IF(E104=M$645,'Unit Costs'!I$68,IF(E104=M$646,'Unit Costs'!I$69,IF(E104=M$647,'Unit Costs'!I$70,\"Select Liner\"))))))+('Unit Costs'!I$63+'Unit Costs'!I$64))*C173)","v":0},{"$f":"IF(C173=\"Ex Primary\",0,(IF(E104=M$643,'Unit Costs'!G$66,IF(E104=M$644,'Unit Costs'!G$67,IF(E104=M$645,'Unit Costs'!G$68,IF(E104=M$646,'Unit Costs'!G$69,IF(E104=M$647,'Unit Costs'!G$70,\"Select Liner\"))))))*C173)","v":0},0,0]
[4,"",0,{"$f":"IF(B174=\"\",\"\",IF(C174=\"Ex Primary\",0,(8*C174/('Unit Costs'!F$63+'Unit Costs'!F$64+(IF(E105=M$643,'Unit Costs'!F$66,IF(E105=M$644,'Unit Costs'!F$67,IF(E105=M$645,'Unit Costs'!F$68,IF(E105=M$646,'Unit Costs'!F$69,IF(E105=M$647,'Unit Costs'!F$70,\"Select Liner\"))))))))))","v":""},{"$f":"IF(C174=\"Ex Primary\",0,((IF(E105=M$643,'Unit Costs'!H$66,IF(E105=M$644,'Unit Costs'!H$67,IF(E105=M$645,'Unit Costs'!H$68,IF(E105=M$646,'Unit Costs'!H$69,IF(E105=M$647,'Unit Costs'!H$70,\"Select Liner\"))))))+('Unit Costs'!H$63+'Unit Costs'!H$64))*C174)","v":0},{"$f":"IF(C174=\"Ex Primary\",0,((IF(E105=M$643,'Unit Costs'!I$66,IF(E105=M$644,'Unit Costs'!I$67,IF(E105=M$645,'Unit Costs'!I$68,IF(E105=M$646,'Unit Costs'!I$69,IF(E105=M$647,'Unit Costs'!I$70,\"Select Liner\"))))))+('Unit Costs'!I$63+'Unit Costs'!I$64))*C174)","v":0},{"$f":"IF(C174=\"Ex Primary\",0,(IF(E105=M$643,'Unit Costs'!G$66,IF(E105=M$644,'Unit Costs'!G$67,IF(E105=M$645,'Unit Costs'!G$68,IF(E105=M$646,'Unit Costs'!G$69,IF(E105=M$647,'Unit Costs'!G$70,\"Select Liner\"))))))*C174)","v":0},0,0]
[5,"",0,{"$f":"IF(B175=\"\",\"\",IF(C175=\"Ex Primary\",0,(8*C175/('Unit Costs'!F$63+'Unit Costs'!F$64+(IF(E106=M$643,'Unit Costs'!F$66,IF(E106=M$644,'Unit Costs'!F$67,IF(E106=M$645,'Unit Costs'!F$68,IF(E106=M$646,'Unit Costs'!F$69,IF(E106=M$647,'Unit Costs'!F$70,\"Select Liner\"))))))))))","v":""},{"$f":"IF(C175=\"Ex Primary\",0,((IF(E106=M$643,'Unit Costs'!H$66,IF(E106=M$644,'Unit Costs'!H$67,IF(E106=M$645,'Unit Costs'!H$68,IF(E106=M$646,'Unit Costs'!H$69,IF(E106=M$647,'Unit Costs'!H$70,\"Select Liner\"))))))+('Unit Costs'!H$63+'Unit Costs'!H$64))*C175)","v":0},{"$f":"IF(C175=\"Ex Primary\",0,((IF(E106=M$643,'Unit Costs'!I$66,IF(E106=M$644,'Unit Costs'!I$67,IF(E106=M$645,'Unit Costs'!I$68,IF(E106=M$646,'Unit Costs'!I$69,IF(E106=M$647,'Unit Costs'!I$70,\"Select Liner\"))))))+('Unit Costs'!I$63+'Unit Costs'!I$64))*C175)","v":0},{"$f":"IF(C175=\"Ex Primary\",0,(IF(E106=M$643,'Unit Costs'!G$66,IF(E106=M$644,'Unit Costs'!G$67,IF(E106=M$645,'Unit Costs'!G$68,IF(E106=M$646,'Unit Costs'!G$69,IF(E106=M$647,'Unit Costs'!G$70,\"Select Liner\"))))))*C175)","v":0},0,0]
[6,"",0,{"$f":"IF(B176=\"\",\"\",IF(C176=\"Ex Primary\",0,(8*C176/('Unit Costs'!F$63+'Unit Costs'!F$64+(IF(E107=M$643,'Unit Costs'!F$66,IF(E107=M$644,'Unit Costs'!F$67,IF(E107=M$645,'Unit Costs'!F$68,IF(E107=M$646,'Unit Costs'!F$69,IF(E107=M$647,'Unit Costs'!F$70,\"Select Liner\"))))))))))","v":""},{"$f":"IF(C176=\"Ex Primary\",0,((IF(E107=M$643,'Unit Costs'!H$66,IF(E107=M$644,'Unit Costs'!H$67,IF(E107=M$645,'Unit Costs'!H$68,IF(E107=M$646,'Unit Costs'!H$69,IF(E107=M$647,'Unit Costs'!H$70,\"Select Liner\"))))))+('Unit Costs'!H$63+'Unit Costs'!H$64))*C176)","v":0},{"$f":"IF(C176=\"Ex Primary\",0,((IF(E107=M$643,'Unit Costs'!I$66,IF(E107=M$644,'Unit Costs'!I$67,IF(E107=M$645,'Unit Costs'!I$68,IF(E107=M$646,'Unit Costs'!I$69,IF(E107=M$647,'Unit Costs'!I$70,\"Select Liner\"))))))+('Unit Costs'!I$63+'Unit Costs'!I$64))*C176)","v":0},{"$f":"IF(C176=\"Ex Primary\",0,(IF(E107=M$643,'Unit Costs'!G$66,IF(E107=M$644,'Unit Costs'!G$67,IF(E107=M$645,'Unit Costs'!G$68,IF(E107=M$646,'Unit Costs'!G$69,IF(E107=M$647,'Unit Costs'!G$70,\"Select Liner\"))))))*C176)","v":0},0,0]
[null,null,{"$f":"SUM(C171:C176)","v":0},0,0,0,0,0]
[]
[null,"Liners and GeoNetting costs include additional 15% for Installation QA/QC"]
[]
[]
["Geonetting"]
[]
["Description\n(required)",null,"Geonetting Area","Crew Hours","Total \nLabor \nCost","Total \nEquipment \nCost","Total \nMaterial\nCost","Total Installation\nCost","Unit Cost"]
[null,null,"sf","hrs",null,null,null,null,"$/sf"]
[{"$f":"A34","v":1},"",{"$f":"IF(D34=\"\",0,IF(F102=\"Double Liner\",F102,IF(F102=\"Single Liner\",((D34-(2*F34*G34))*(E34-(2*F34*G34))+SQRT((F34)^2+(2*F34*G34)^2)*((D34+(D34-(2*F34*G34)))+(E34+(E34-(2*F34*G34))))/2+8*(D34+4)+8*(E34+4)),IF(E102=$M$645,\"Drain Liner\",((D34-(2*F34*G34))*(E34-(2*F34*G34))+SQRT((F34)^2+(2*F34*G34)^2)*((D34+(D34-(2*F34*G34)))+(E34+(E34-(2*F34*G34))))/2+8*(D34+4)+8*(E34+4))))))","v":0},{"$f":"IF(F102=\"Double Liner\",0,IF(F102=\"Single Liner\",C186/'Unit Costs'!F$67,IF(E102=$M$645,0,C186/'Unit Costs'!F$67)))","v":0},{"$f":"IF(F102=\"Double Liner\",0,IF(F102=\"Single Liner\",'Unit Costs'!H$67*C186*0.9,IF(E102=$M$645,0,'Unit Costs'!H$67*C186*0.9)))","v":0},{"$f":"IF(F102=\"Double Liner\",0,IF(F102=\"Single Liner\",'Unit Costs'!I$67*C186*0.9,IF(E102=$M$645,0,'Unit Costs'!I$67*C186*0.9)))","v":0},{"$f":"IF(F102=\"Double Liner\",0,IF(F102=\"Single Liner\",'Unit Costs'!G$67*C186*0.9,IF(E102=$M$645,0,'Unit Costs'!G$67*C186*0.9)))","v":0},{"$f":"SUM(E186:G186)","v":0},{"$f":"IF(C186=0,0,IF(C186=\"Double Liner\",0,IF(F102=\"Single Liner\",H186/C186,IF(E102=$M$645,0,H186/C186))))","v":0}]
[2,"",{"$f":"IF(D35=\"\",0,IF(F103=\"Double Liner\",F103,IF(F103=\"Single Liner\",((D35-(2*F35*G35))*(E35-(2*F35*G35))+SQRT((F35)^2+(2*F35*G35)^2)*((D35+(D35-(2*F35*G35)))+(E35+(E35-(2*F35*G35))))/2+8*(D35+4)+8*(E35+4)),IF(E103=$M$645,\"Drain Liner\",((D35-(2*F35*G35))*(E35-(2*F35*G35))+SQRT((F35)^2+(2*F35*G35)^2)*((D35+(D35-(2*F35*G35)))+(E35+(E35-(2*F35*G35))))/2+8*(D35+4)+8*(E35+4))))))","v":0},{"$f":"IF(F103=\"Double Liner\",0,IF(F103=\"Single Liner\",C187/'Unit Costs'!F$67,IF(E103=$M$645,0,C187/'Unit Costs'!F$67)))","v":0},{"$f":"IF(F103=\"Double Liner\",0,IF(F103=\"Single Liner\",'Unit Costs'!H$67*C187*0.9,IF(E103=$M$645,0,'Unit Costs'!H$67*C187*0.9)))","v":0},{"$f":"IF(F103=\"Double Liner\",0,IF(F103=\"Single Liner\",'Unit Costs'!I$67*C187*0.9,IF(E103=$M$645,0,'Unit Costs'!I$67*C187*0.9)))","v":0},{"$f":"IF(F103=\"Double Liner\",0,IF(F103=\"Single Liner\",'Unit Costs'!G$67*C187*0.9,IF(E103=$M$645,0,'Unit Costs'!G$67*C187*0.9)))","v":0},{"$f":"SUM(E187:G187)","v":0},{"$f":"IF(C187=0,0,IF(C187=\"Double Liner\",0,IF(F103=\"Single Liner\",H187/C187,IF(E103=$M$645,0,H187/C187))))","v":0}]
[3,"",0,{"$f":"IF(F104=\"Double Liner\",0,IF(F104=\"Single Liner\",C188/'Unit Costs'!F$67,IF(E104=$M$645,0,C188/'Unit Costs'!F$67)))","v":0},{"$f":"IF(F104=\"Double Liner\",0,IF(F104=\"Single Liner\",'Unit Costs'!H$67*C188*0.9,IF(E104=$M$645,0,'Unit Costs'!H$67*C188*0.9)))","v":0},{"$f":"IF(F104=\"Double Liner\",0,IF(F104=\"Single Liner\",'Unit Costs'!I$67*C188*0.9,IF(E104=$M$645,0,'Unit Costs'!I$67*C188*0.9)))","v":0},{"$f":"IF(F104=\"Double Liner\",0,IF(F104=\"Single Liner\",'Unit Costs'!G$67*C188*0.9,IF(E104=$M$645,0,'Unit Costs'!G$67*C188*0.9)))","v":0},0,0]
[4,"",0,{"$f":"IF(F105=\"Double Liner\",0,IF(F105=\"Single Liner\",C189/'Unit Costs'!F$67,IF(E105=$M$645,0,C189/'Unit Costs'!F$67)))","v":0},{"$f":"IF(F105=\"Double Liner\",0,IF(F105=\"Single Liner\",'Unit Costs'!H$67*C189*0.9,IF(E105=$M$645,0,'Unit Costs'!H$67*C189*0.9)))","v":0},{"$f":"IF(F105=\"Double Liner\",0,IF(F105=\"Single Liner\",'Unit Costs'!I$67*C189*0.9,IF(E105=$M$645,0,'Unit Costs'!I$67*C189*0.9)))","v":0},{"$f":"IF(F105=\"Double Liner\",0,IF(F105=\"Single Liner\",'Unit Costs'!G$67*C189*0.9,IF(E105=$M$645,0,'Unit Costs'!G$67*C189*0.9)))","v":0},0,0]
[5,"",0,{"$f":"IF(F106=\"Double Liner\",0,IF(F106=\"Single Liner\",C190/'Unit Costs'!F$67,IF(E106=$M$645,0,C190/'Unit Costs'!F$67)))","v":0},{"$f":"IF(F106=\"Double Liner\",0,IF(F106=\"Single Liner\",'Unit Costs'!H$67*C190*0.9,IF(E106=$M$645,0,'Unit Costs'!H$67*C190*0.9)))","v":0},{"$f":"IF(F106=\"Double Liner\",0,IF(F106=\"Single Liner\",'Unit Costs'!I$67*C190*0.9,IF(E106=$M$645,0,'Unit Costs'!I$67*C190*0.9)))","v":0},{"$f":"IF(F106=\"Double Liner\",0,IF(F106=\"Single Liner\",'Unit Costs'!G$67*C190*0.9,IF(E106=$M$645,0,'Unit Costs'!G$67*C190*0.9)))","v":0},0,0]
[6,"",0,{"$f":"IF(F107=\"Double Liner\",0,IF(F107=\"Single Liner\",C191/'Unit Costs'!F$67,IF(E107=$M$645,0,C191/'Unit Costs'!F$67)))","v":0},{"$f":"IF(F107=\"Double Liner\",0,IF(F107=\"Single Liner\",'Unit Costs'!H$67*C191*0.9,IF(E107=$M$645,0,'Unit Costs'!H$67*C191*0.9)))","v":0},{"$f":"IF(F107=\"Double Liner\",0,IF(F107=\"Single Liner\",'Unit Costs'!I$67*C191*0.9,IF(E107=$M$645,0,'Unit Costs'!I$67*C191*0.9)))","v":0},{"$f":"IF(F107=\"Double Liner\",0,IF(F107=\"Single Liner\",'Unit Costs'!G$67*C191*0.9,IF(E107=$M$645,0,'Unit Costs'!G$67*C191*0.9)))","v":0},0,0]
[null,null,{"$f":"SUM(C186:C191)","v":0},0,0,0,0,0]
[]
[null,"Geonetting; Labor, Equip and Material Cost Assumed to be 90% cost on 60 mil HDPE."]
[]
[]
["Top (Primary) Liner Installation"]
[]
["Description\n(required)",null,"Liner Area","Crew Hours","Total \nLabor \nCost","Total \nEquipment \nCost","Total \nMaterial\nCost","Total \nLiner Installation\nCost","Unit Cost"]
[null,null,"sf","hrs",null,null,null,null,"$/sf"]
[{"$f":"A34","v":1},"",{"$f":"IF(F102=\"Double Liner\",\"Double Liner\",IF(D34=\"\",0,((D34-(2*F34*G34))*(E34-(2*F34*G34))+SQRT((F34)^2+(2*F34*G34)^2)*((D34+(D34-(2*F34*G34)))+(E34+(E34-(2*F34*G34))))/2+8*(D34+4)+8*(E34+4))))","v":0},{"$f":"IF(C201=\"Double Liner\",0,IF(D102=M$645,\"Select Liner\",C201/(IF(D102=M$643,'Unit Costs'!F$66,IF(D102=M$644,'Unit Costs'!F$67,IF(D102=M$646,'Unit Costs'!F$69,IF(D102=M$647,'Unit Costs'!F$70,\"Liner Error\")))))))","v":0},{"$f":"IF(C201=\"Double Liner\",0,IF(D102=M$645,\"Select Liner\",(IF(D102=M$643,'Unit Costs'!H$66,IF(D102=M$644,'Unit Costs'!H$67,IF(D102=M$646,'Unit Costs'!H$69,IF(D102=M$647,'Unit Costs'!H$70,\"Liner Error\")))))*C201*1.15))","v":0},{"$f":"IF(C201=\"Double Liner\",0,IF(D102=M$645,\"Select Liner\",(IF(D102=M$643,'Unit Costs'!I$66,IF(D102=M$644,'Unit Costs'!I$67,IF(D102=M$646,'Unit Costs'!I$69,IF(D102=M$647,'Unit Costs'!I$70,\"Liner Error\")))))*C201*1.15))","v":0},{"$f":"IF(C201=\"Double Liner\",0,IF(D102=M$645,\"Select Liner\",(IF(D102=M$643,'Unit Costs'!G$66,IF(D102=M$644,'Unit Costs'!G$67,IF(D102=M$646,'Unit Costs'!G$69,IF(D102=M$647,'Unit Costs'!G$70,\"Liner Error\")))))*C201*1.15))","v":0},{"$f":"IF(D102=M$645,\"Select Liner\",SUM(E201:G201))","v":0},{"$f":"IF(C215=0,0,IF(C215=\"Double Liner\",0,H201/C201))","v":0}]
[2,"",0,{"$f":"IF(C202=\"Double Liner\",0,IF(D103=M$645,\"Select Liner\",C202/(IF(D103=M$643,'Unit Costs'!F$66,IF(D103=M$644,'Unit Costs'!F$67,IF(D103=M$646,'Unit Costs'!F$69,IF(D103=M$647,'Unit Costs'!F$70,\"Liner Error\")))))))","v":0},{"$f":"IF(C202=\"Double Liner\",0,IF(D103=M$645,\"Select Liner\",(IF(D103=M$643,'Unit Costs'!H$66,IF(D103=M$644,'Unit Costs'!H$67,IF(D103=M$646,'Unit Costs'!H$69,IF(D103=M$647,'Unit Costs'!H$70,\"Liner Error\")))))*C202*1.15))","v":0},{"$f":"IF(C202=\"Double Liner\",0,IF(D103=M$645,\"Select Liner\",(IF(D103=M$643,'Unit Costs'!I$66,IF(D103=M$644,'Unit Costs'!I$67,IF(D103=M$646,'Unit Costs'!I$69,IF(D103=M$647,'Unit Costs'!I$70,\"Liner Error\")))))*C202*1.15))","v":0},{"$f":"IF(C202=\"Double Liner\",0,IF(D103=M$645,\"Select Liner\",(IF(D103=M$643,'Unit Costs'!G$66,IF(D103=M$644,'Unit Costs'!G$67,IF(D103=M$646,'Unit Costs'!G$69,IF(D103=M$647,'Unit Costs'!G$70,\"Liner Error\")))))*C202*1.15))","v":0},0,0]
[3,"",0,{"$f":"IF(C203=\"Double Liner\",0,IF(D104=M$645,\"Select Liner\",C203/(IF(D104=M$643,'Unit Costs'!F$66,IF(D104=M$644,'Unit Costs'!F$67,IF(D104=M$646,'Unit Costs'!F$69,IF(D104=M$647,'Unit Costs'!F$70,\"Liner Error\")))))))","v":0},{"$f":"IF(C203=\"Double Liner\",0,IF(D104=M$645,\"Select Liner\",(IF(D104=M$643,'Unit Costs'!H$66,IF(D104=M$644,'Unit Costs'!H$67,IF(D104=M$646,'Unit Costs'!H$69,IF(D104=M$647,'Unit Costs'!H$70,\"Liner Error\")))))*C203*1.15))","v":0},{"$f":"IF(C203=\"Double Liner\",0,IF(D104=M$645,\"Select Liner\",(IF(D104=M$643,'Unit Costs'!I$66,IF(D104=M$644,'Unit Costs'!I$67,IF(D104=M$646,'Unit Costs'!I$69,IF(D104=M$647,'Unit Costs'!I$70,\"Liner Error\")))))*C203*1.15))","v":0},{"$f":"IF(C203=\"Double Liner\",0,IF(D104=M$645,\"Select Liner\",(IF(D104=M$643,'Unit Costs'!G$66,IF(D104=M$644,'Unit Costs'!G$67,IF(D104=M$646,'Unit Costs'!G$69,IF(D104=M$647,'Unit Costs'!G$70,\"Liner Error\")))))*C203*1.15))","v":0},0,0]
[4,"",0,{"$f":"IF(C204=\"Double Liner\",0,IF(D105=M$645,\"Select Liner\",C204/(IF(D105=M$643,'Unit Costs'!F$66,IF(D105=M$644,'Unit Costs'!F$67,IF(D105=M$646,'Unit Costs'!F$69,IF(D105=M$647,'Unit Costs'!F$70,\"Liner Error\")))))))","v":0},{"$f":"IF(C204=\"Double Liner\",0,IF(D105=M$645,\"Select Liner\",(IF(D105=M$643,'Unit Costs'!H$66,IF(D105=M$644,'Unit Costs'!H$67,IF(D105=M$646,'Unit Costs'!H$69,IF(D105=M$647,'Unit Costs'!H$70,\"Liner Error\")))))*C204*1.15))","v":0},{"$f":"IF(C204=\"Double Liner\",0,IF(D105=M$645,\"Select Liner\",(IF(D105=M$643,'Unit Costs'!I$66,IF(D105=M$644,'Unit Costs'!I$67,IF(D105=M$646,'Unit Costs'!I$69,IF(D105=M$647,'Unit Costs'!I$70,\"Liner Error\")))))*C204*1.15))","v":0},{"$f":"IF(C204=\"Double Liner\",0,IF(D105=M$645,\"Select Liner\",(IF(D105=M$643,'Unit Costs'!G$66,IF(D105=M$644,'Unit Costs'!G$67,IF(D105=M$646,'Unit Costs'!G$69,IF(D105=M$647,'Unit Costs'!G$70,\"Liner Error\")))))*C204*1.15))","v":0},0,0]
[5,"",0,{"$f":"IF(C205=\"Double Liner\",0,IF(D106=M$645,\"Select Liner\",C205/(IF(D106=M$643,'Unit Costs'!F$66,IF(D106=M$644,'Unit Costs'!F$67,IF(D106=M$646,'Unit Costs'!F$69,IF(D106=M$647,'Unit Costs'!F$70,\"Liner Error\")))))))","v":0},{"$f":"IF(C205=\"Double Liner\",0,IF(D106=M$645,\"Select Liner\",(IF(D106=M$643,'Unit Costs'!H$66,IF(D106=M$644,'Unit Costs'!H$67,IF(D106=M$646,'Unit Costs'!H$69,IF(D106=M$647,'Unit Costs'!H$70,\"Liner Error\")))))*C205*1.15))","v":0},{"$f":"IF(C205=\"Double Liner\",0,IF(D106=M$645,\"Select Liner\",(IF(D106=M$643,'Unit Costs'!I$66,IF(D106=M$644,'Unit Costs'!I$67,IF(D106=M$646,'Unit Costs'!I$69,IF(D106=M$647,'Unit Costs'!I$70,\"Liner Error\")))))*C205*1.15))","v":0},{"$f":"IF(C205=\"Double Liner\",0,IF(D106=M$645,\"Select Liner\",(IF(D106=M$643,'Unit Costs'!G$66,IF(D106=M$644,'Unit Costs'!G$67,IF(D106=M$646,'Unit Costs'!G$69,IF(D106=M$647,'Unit Costs'!G$70,\"Liner Error\")))))*C205*1.15))","v":0},0,0]
[6,"",0,{"$f":"IF(C206=\"Double Liner\",0,IF(D107=M$645,\"Select Liner\",C206/(IF(D107=M$643,'Unit Costs'!F$66,IF(D107=M$644,'Unit Costs'!F$67,IF(D107=M$646,'Unit Costs'!F$69,IF(D107=M$647,'Unit Costs'!F$70,\"Liner Error\")))))))","v":0},{"$f":"IF(C206=\"Double Liner\",0,IF(D107=M$645,\"Select Liner\",(IF(D107=M$643,'Unit Costs'!H$66,IF(D107=M$644,'Unit Costs'!H$67,IF(D107=M$646,'Unit Costs'!H$69,IF(D107=M$647,'Unit Costs'!H$70,\"Liner Error\")))))*C206*1.15))","v":0},{"$f":"IF(C206=\"Double Liner\",0,IF(D107=M$645,\"Select Liner\",(IF(D107=M$643,'Unit Costs'!I$66,IF(D107=M$644,'Unit Costs'!I$67,IF(D107=M$646,'Unit Costs'!I$69,IF(D107=M$647,'Unit Costs'!I$70,\"Liner Error\")))))*C206*1.15))","v":0},{"$f":"IF(C206=\"Double Liner\",0,IF(D107=M$645,\"Select Liner\",(IF(D107=M$643,'Unit Costs'!G$66,IF(D107=M$644,'Unit Costs'!G$67,IF(D107=M$646,'Unit Costs'!G$69,IF(D107=M$647,'Unit Costs'!G$70,\"Liner Error\")))))*C206*1.15))","v":0},0,0]
[null,null,{"$f":"SUM(C201:C206)","v":0},0,0,0,0,0]
[]
[null,"Liners and GeoNetting costs include additional 15% for Installation QA/QC"]
[]
["Liner Key Trench",null,"Key Trench 2' wide by 3'deep centered 4' from top of liner slope"]
[]
["Description\n(required)",null,"Trench Length","Trench Volume","Fleet Hours","Total \nLabor \nCost","Total \nEquipment \nCost","Total \nKey Trench Installation\nCost","Unit Cost","Unit Cost"]
[null,null,"lf","cy","hrs",null,null,null,"$/lf","$/cy"]
[{"$f":"A34","v":1},"",{"$f":"IF(D34=\"\",0,IF(F102=\"Double Liner\",F102,((D34+E34+16)*2)))","v":0},{"$f":"IF(F102=\"Double Liner\",0,C215*3*2/27)","v":0},{"$f":"D215/'Unit Costs'!F$73","v":0},{"$f":"D215*'Unit Costs'!H$73","v":0},{"$f":"D215*'Unit Costs'!I$73","v":0},{"$f":"SUM(F215:G215)","v":0},{"$f":"IF(C215=0,0,IF(C215=\"Double Liner\",0,H215/C215))","v":0},{"$f":"IF(D215=0,0,IF(D215=\"Double Liner\",0,H215/D215))","v":0}]
[2,"",0,0,{"$f":"D216/'Unit Costs'!F$73","v":0},{"$f":"D216*'Unit Costs'!H$73","v":0},{"$f":"D216*'Unit Costs'!I$73","v":0},0,0,0]
[3,"",0,0,{"$f":"D217/'Unit Costs'!F$73","v":0},{"$f":"D217*'Unit Costs'!H$73","v":0},{"$f":"D217*'Unit Costs'!I$73","v":0},0,0,0]
[4,"",0,0,{"$f":"D218/'Unit Costs'!F$73","v":0},{"$f":"D218*'Unit Costs'!H$73","v":0},{"$f":"D218*'Unit Costs'!I$73","v":0},0,0,0]
[5,"",0,0,{"$f":"D219/'Unit Costs'!F$73","v":0},{"$f":"D219*'Unit Costs'!H$73","v":0},{"$f":"D219*'Unit Costs'!I$73","v":0},0,0,0]
[6,"",0,0,{"$f":"D220/'Unit Costs'!F$73","v":0},{"$f":"D220*'Unit Costs'!H$73","v":0},{"$f":"D220*'Unit Costs'!I$73","v":0},0,0,0]
[null,null,{"$f":"SUM(C215:C220)","v":0},{"$f":"SUM(D215:D220)","v":0},0,0,0,0]
[]
[]
[]
["Dosing Tank Installation"]
[]
["Description\n(required)",null,"Number of Tanks","Concrete Volume","Productivity","Total \nLabor \nCost","Total \nEquipment \nCost","Total \nMaterial\nCost","Total \nDosing Tank Installation\nCost"]
[null,null,null,"cy","LCY/hr"]
[{"$f":"A$34","v":1},{"$f":"B34","v":""},1,{"$f":"IF(B34=\"\",0,C229*19)","v":0},{"$f":"IF(D34=\"\",0,'Unit Costs'!F$75)","v":0},{"$f":"'Unit Costs'!H$75*D229","v":0},{"$f":"'Unit Costs'!I$75*D229","v":0},{"$f":"'Unit Costs'!G$75*D229","v":0},{"$f":"SUM(F229:H229)","v":0}]
[{"$f":"A$35","v":2},"",1,0,{"$f":"IF(D35=\"\",0,'Unit Costs'!F$75)","v":0},{"$f":"'Unit Costs'!H$75*D230","v":0},{"$f":"'Unit Costs'!I$75*D230","v":0},{"$f":"'Unit Costs'!G$75*D230","v":0},0]
[{"$f":"A$36","v":3},"",1,0,{"$f":"IF(D36=\"\",0,'Unit Costs'!F$75)","v":0},{"$f":"'Unit Costs'!H$75*D231","v":0},{"$f":"'Unit Costs'!I$75*D231","v":0},{"$f":"'Unit Costs'!G$75*D231","v":0},0]
[{"$f":"A37","v":4},"",1,0,{"$f":"IF(D37=\"\",0,'Unit Costs'!F$75)","v":0},{"$f":"'Unit Costs'!H$75*D232","v":0},{"$f":"'Unit Costs'!I$75*D232","v":0},{"$f":"'Unit Costs'!G$75*D232","v":0},0]
[{"$f":"A38","v":5},"",1,0,{"$f":"IF(D38=\"\",0,'Unit Costs'!F$75)","v":0},{"$f":"'Unit Costs'!H$75*D233","v":0},{"$f":"'Unit Costs'!I$75*D233","v":0},{"$f":"'Unit Costs'!G$75*D233","v":0},0]
[{"$f":"A39","v":6},"",1,0,{"$f":"IF(D39=\"\",0,'Unit Costs'!F$75)","v":0},{"$f":"'Unit Costs'!H$75*D234","v":0},{"$f":"'Unit Costs'!I$75*D234","v":0},{"$f":"'Unit Costs'!G$75*D234","v":0},0]
[null,null,{"$f":"SUM(C229:C234)","v":6},{"$f":"SUM(D229:D234)","v":0},null,{"$f":"SUM(F229:F234)","v":0},{"$f":"SUM(G229:G234)","v":0},{"$f":"SUM(H229:H234)","v":0},{"$f":"SUM(I229:I234)","v":0}]
[]
[null,"Based on Mineral Ridge dosing tank at $5,457, 19 cy of RCC in SRCE approximates this value"]
[]
["Under Drain Pipe Manifold Installation 4\"Dia @ 10' oc"]
[]
["Description\n(required)",null,"Total Pipe Length","Productivity","Crew Hours","Labor                Cost","Equipment           Cost","Material \nCost","Total Piping Cost","Unit Cost"]
[null,null,"ft","lf/hr","hrs",null,null,null,null,"$/lf"]
[{"$f":"A$34","v":1},{"$f":"B34","v":""},{"$f":"IF(B34=\"\",0,((D34-(2*F34*G34))*((E34-(2*F34*G34))/10))+(D34-(2*F34*G34)))","v":0},{"$f":"IF(D34=\"\",0,'Unit Costs'!F$79)","v":0},{"$f":"IF(D34=\"\",0,C243/D243)","v":0},{"$f":"'Unit Costs'!H$79*C243","v":0},{"$f":"'Unit Costs'!I$79*C243","v":0},{"$f":"'Unit Costs'!G$79*C243","v":0},{"$f":"SUM(F243:H243)","v":0},{"$f":"IF(C243=0,0,I243/C243)","v":0}]
[{"$f":"A$35","v":2},"",0,{"$f":"IF(D35=\"\",0,'Unit Costs'!F$79)","v":0},0,{"$f":"'Unit Costs'!H$79*C244","v":0},{"$f":"'Unit Costs'!I$79*C244","v":0},{"$f":"'Unit Costs'!G$79*C244","v":0},0,0]
[{"$f":"A$36","v":3},"",0,{"$f":"IF(D36=\"\",0,'Unit Costs'!F$79)","v":0},0,{"$f":"'Unit Costs'!H$79*C245","v":0},{"$f":"'Unit Costs'!I$79*C245","v":0},{"$f":"'Unit Costs'!G$79*C245","v":0},0,0]
[{"$f":"A37","v":4},"",0,{"$f":"IF(D37=\"\",0,'Unit Costs'!F$79)","v":0},0,{"$f":"'Unit Costs'!H$79*C246","v":0},{"$f":"'Unit Costs'!I$79*C246","v":0},{"$f":"'Unit Costs'!G$79*C246","v":0},0,0]
[{"$f":"A38","v":5},"",0,{"$f":"IF(D38=\"\",0,'Unit Costs'!F$79)","v":0},0,{"$f":"'Unit Costs'!H$79*C247","v":0},{"$f":"'Unit Costs'!I$79*C247","v":0},{"$f":"'Unit Costs'!G$79*C247","v":0},0,0]
[{"$f":"A39","v":6},"",0,{"$f":"IF(D39=\"\",0,'Unit Costs'!F$79)","v":0},0,{"$f":"'Unit Costs'!H$79*C248","v":0},{"$f":"'Unit Costs'!I$79*C248","v":0},{"$f":"'Unit Costs'!G$79*C248","v":0},0,0]
[null,null,{"$f":"SUM(C243:C248)","v":0},null,{"$f":"SUM(E243:E248)","v":0},{"$f":"SUM(F243:F248)","v":0},{"$f":"SUM(G243:G248)","v":0},{"$f":"SUM(H243:H248)","v":0},{"$f":"SUM(I243:I248)","v":0}]
[]
[]
[]
["Material Screening for Backfill"]
["Backfill Material Screening"]
["Description\n(required)",null,"Volume to Screen","Screening\nFleet","Screening Productivity","Total Fleet Hours","Total \nLabor \nCost","Total \nEquipment \nCost","Total Screening\n Cost"," Screening Unit Cost"]
[null,null,"cy",null,"LCY/hr","hrs",null,null,null,"$/cy"]
[{"$f":"A34","v":1},{"$f":"B34","v":""},{"$f":"IF(B34=\"\",\"\",IF(J58=\"\",\"\",IF(J58=\"No\",\"\",C271/(1-L58))))","v":""},{"$f":"IF(B34=\"\",\"\",K58)","v":""},{"$f":"IF(C257=\"\",\"\",IF(D257=C$588,60*C$592/C$594,IF(D257=D$588,60*D$592/D$594,IF(D257=E$588,60*E$592/E$594,\"select fleet\"))))","v":""},{"$f":"IF(C257=\"\",\"\",IF(L58>0.5,(IF(D257=C$588,C257/60*(2+(2/3))*C$594/C$592,IF(D257=D$588,C257/60*(2+(2/3))*D$594/D$592,IF(D257=E$588,C257/60*(2+(2/3))*E$594/E$592,\"select fleet\")))),IF(D257=C$588,C257/60*(2)*C$594/C$592,IF(D257=D$588,C257/60*(2)*D$594/D$592,IF(D257=E$588,C257/60*(2)*E$594/E$592,\"select fleet\")))))","v":""},{"$f":"IF(C257=\"\",\"\",F257*IF(K58=J$661,'Unit Costs'!B$40,IF(K58=J$662,'Unit Costs'!B$39,IF(K58=J$663,'Unit Costs'!B$38,\"SelectFleet\"))))","v":""},{"$f":"IF(C257=\"\",\"\",F257*IF(K58=J$661,'Unit Costs'!C$40,IF(K58=J$662,'Unit Costs'!C$39,IF(K58=J$663,'Unit Costs'!C$38,\"Select Fleet\"))))","v":""},{"$f":"SUM(G257:H257)","v":0},{"$f":"IF(C257=\"\",\"\",IF(C257=0,0,I257/C257))","v":""}]
[{"$f":"A35","v":2},"",{"$f":"IF(B35=\"\",\"\",IF(J59=\"\",\"\",IF(J59=\"No\",\"\",C272/(1-L59))))","v":""},{"$f":"IF(B35=\"\",\"\",K59)","v":""},"","",{"$f":"IF(C258=\"\",\"\",F258*IF(K59=J$661,'Unit Costs'!B$40,IF(K59=J$662,'Unit Costs'!B$39,IF(K59=J$663,'Unit Costs'!B$38,\"SelectFleet\"))))","v":""},{"$f":"IF(C258=\"\",\"\",F258*IF(K59=J$661,'Unit Costs'!C$40,IF(K59=J$662,'Unit Costs'!C$39,IF(K59=J$663,'Unit Costs'!C$38,\"Select Fleet\"))))","v":""},{"$f":"SUM(G258:H258)","v":0},{"$f":"IF(C258=\"\",\"\",IF(C258=0,0,I258/C258))","v":""}]
[{"$f":"A36","v":3},"","","","","",{"$f":"IF(C259=\"\",\"\",F259*IF(K60=J$661,'Unit Costs'!B$40,IF(K60=J$662,'Unit Costs'!B$39,IF(K60=J$663,'Unit Costs'!B$38,\"SelectFleet\"))))","v":""},{"$f":"IF(C259=\"\",\"\",F259*IF(K60=J$661,'Unit Costs'!C$40,IF(K60=J$662,'Unit Costs'!C$39,IF(K60=J$663,'Unit Costs'!C$38,\"Select Fleet\"))))","v":""},0,""]
[{"$f":"A37","v":4},"","","","","",{"$f":"IF(C260=\"\",\"\",F260*IF(K61=J$661,'Unit Costs'!B$40,IF(K61=J$662,'Unit Costs'!B$39,IF(K61=J$663,'Unit Costs'!B$38,\"SelectFleet\"))))","v":""},{"$f":"IF(C260=\"\",\"\",F260*IF(K61=J$661,'Unit Costs'!C$40,IF(K61=J$662,'Unit Costs'!C$39,IF(K61=J$663,'Unit Costs'!C$38,\"Select Fleet\"))))","v":""},0,""]
[{"$f":"A38","v":5},"","","","","",{"$f":"IF(C261=\"\",\"\",F261*IF(K62=J$661,'Unit Costs'!B$40,IF(K62=J$662,'Unit Costs'!B$39,IF(K62=J$663,'Unit Costs'!B$38,\"SelectFleet\"))))","v":""},{"$f":"IF(C261=\"\",\"\",F261*IF(K62=J$661,'Unit Costs'!C$40,IF(K62=J$662,'Unit Costs'!C$39,IF(K62=J$663,'Unit Costs'!C$38,\"Select Fleet\"))))","v":""},0,""]
[{"$f":"A39","v":6},"","","","","",{"$f":"IF(C262=\"\",\"\",F262*IF(K63=J$661,'Unit Costs'!B$40,IF(K63=J$662,'Unit Costs'!B$39,IF(K63=J$663,'Unit Costs'!B$38,\"SelectFleet\"))))","v":""},{"$f":"IF(C262=\"\",\"\",F262*IF(K63=J$661,'Unit Costs'!C$40,IF(K63=J$662,'Unit Costs'!C$39,IF(K63=J$663,'Unit Costs'!C$38,\"Select Fleet\"))))","v":""},0,""]
[null,null,{"$f":"SUM(C257:C262)","v":0},null,null,{"$f":"SUM(F257:F262)","v":0},{"$f":"SUM(G257:G262)","v":0},{"$f":"SUM(H257:H262)","v":0},{"$f":"SUM(I257:I262)","v":0}]
[]
[]
[]
["Pond Backfill"]
[null,null,"Pond Backfill Haul and Place"]
["Description\n(required)",null,"Backfill Volume","Backfill \nFleet","Number of Trucks","Fleet Productivity","Total Fleet Hours","Total \nLabor \nCost","Total \nEquipment \nCost","Total Backfill\n Cost","Screen and BF Total \n Cost"," Total Unit Cost"]
[null,null,"cy",null,null,"LCY/hr","hrs",null,null,null,null,"$/cy"]
[{"$f":"A$34","v":1},{"$f":"B34","v":""},{"$f":"IF(B34=\"\",\"\",(E34*E34/2/G34*(D34-E34)/2+(E34*E34*(E34/2/G34))/3-((E34/2/G34)-F34)*(E34-(2*F34*G34))*(D34-E34)/2-(((E34-(2*F34*G34))*(E34-(2*F34*G34)))*((E34/2/G34)-F34))/3)/27-(E34*E34/2/G34*(D34-E34)/2+(E34*E34*(E34/2/G34))/3-((E34/2/G34)-H34)*(E34-(2*H34*G34))*(D34-E34)/2-(((E34-(2*H34*G34))*(E34-(2*H34*G34)))*((E34/2/G34)-H34))/3)/27)","v":""},{"$f":"IF(D34=\"\",\"\",G58)","v":""},{"$f":"IF(B34=\"\",\"\",IF(H58=0,ROUNDUP((N542-L542)/L542,0),H58))","v":""},{"$f":"IF(B34=\"\",\"\",ROUND(0.83*E271*((IF(D271=\"769D 988G D7R\",26.65,IF(D271=\"777D 992G D7R\",66.8,\"Select Fleet\"))*60)/N542),0))","v":""},{"$f":"IF(B34=\"\",\"\",ROUND(IF(B34=\"\",\"\",C271/F271),0))","v":""},{"$f":"IF(B34=\"\",\"\",G271*IF(G58=B$660,'Unit Costs'!B$30+'Unit Costs'!B$35+'Unit Costs'!B$39,IF(G58=B$661,'Unit Costs'!B$29+'Unit Costs'!B$35+'Unit Costs'!B$38,0)))","v":""},{"$f":"IF(B34=\"\",\"\",G271*IF(G58=B$660,'Unit Costs'!C$30+'Unit Costs'!C$35+'Unit Costs'!C$39,IF(G58=B$661,'Unit Costs'!C$29+'Unit Costs'!C$35+'Unit Costs'!C$38,0)))","v":""},{"$f":"SUM(H271:I271)","v":0},{"$f":"I257+J271","v":0},{"$f":"IF(C271=\"\",0,(J271+I257)/C271)","v":0}]
[{"$f":"A$35","v":2},"",{"$f":"IF(D35=\"\",\"\",(E35*E35/2/G35*(D35-E35)/2+(E35*E35*(E35/2/G35))/3-((E35/2/G35)-F35)*(E35-(2*F35*G35))*(D35-E35)/2-(((E35-(2*F35*G35))*(E35-(2*F35*G35)))*((E35/2/G35)-F35))/3)/27-(E35*E35/2/G35*(D35-E35)/2+(E35*E35*(E35/2/G35))/3-((E35/2/G35)-H35)*(E35-(2*H35*G35))*(D35-E35)/2-(((E35-(2*H35*G35))*(E35-(2*H35*G35)))*((E35/2/G35)-H35))/3)/27)","v":""},"","","",{"$f":"IF(B35=\"\",\"\",ROUND(IF(B35=\"\",\"\",C272/F272),0))","v":""},{"$f":"IF(D35=\"\",\"\",G272*IF(G59=B$660,'Unit Costs'!B$30+'Unit Costs'!B$35+'Unit Costs'!B$39,IF(G59=B$661,'Unit Costs'!B$29+'Unit Costs'!B$35+'Unit Costs'!B$38,0)))","v":""},{"$f":"IF(D35=\"\",\"\",G272*IF(G59=B$660,'Unit Costs'!C$30+'Unit Costs'!C$35+'Unit Costs'!C$39,IF(G59=B$661,'Unit Costs'!C$29+'Unit Costs'!C$35+'Unit Costs'!C$38,0)))","v":""},0,0,0]
[{"$f":"A$36","v":3},"",{"$f":"IF(D36=\"\",\"\",(E36*E36/2/G36*(D36-E36)/2+(E36*E36*(E36/2/G36))/3-((E36/2/G36)-F36)*(E36-(2*F36*G36))*(D36-E36)/2-(((E36-(2*F36*G36))*(E36-(2*F36*G36)))*((E36/2/G36)-F36))/3)/27-(E36*E36/2/G36*(D36-E36)/2+(E36*E36*(E36/2/G36))/3-((E36/2/G36)-H36)*(E36-(2*H36*G36))*(D36-E36)/2-(((E36-(2*H36*G36))*(E36-(2*H36*G36)))*((E36/2/G36)-H36))/3)/27)","v":""},"","","","",{"$f":"IF(D36=\"\",\"\",G273*IF(G60=B$660,'Unit Costs'!B$30+'Unit Costs'!B$35+'Unit Costs'!B$39,IF(G60=B$661,'Unit Costs'!B$29+'Unit Costs'!B$35+'Unit Costs'!B$38,0)))","v":""},{"$f":"IF(D36=\"\",\"\",G273*IF(G60=B$660,'Unit Costs'!C$30+'Unit Costs'!C$35+'Unit Costs'!C$39,IF(G60=B$661,'Unit Costs'!C$29+'Unit Costs'!C$35+'Unit Costs'!C$38,0)))","v":""},0,0,0]
[{"$f":"A37","v":4},"",{"$f":"IF(D37=\"\",\"\",(E37*E37/2/G37*(D37-E37)/2+(E37*E37*(E37/2/G37))/3-((E37/2/G37)-F37)*(E37-(2*F37*G37))*(D37-E37)/2-(((E37-(2*F37*G37))*(E37-(2*F37*G37)))*((E37/2/G37)-F37))/3)/27-(E37*E37/2/G37*(D37-E37)/2+(E37*E37*(E37/2/G37))/3-((E37/2/G37)-H37)*(E37-(2*H37*G37))*(D37-E37)/2-(((E37-(2*H37*G37))*(E37-(2*H37*G37)))*((E37/2/G37)-H37))/3)/27)","v":""},"","","","",{"$f":"IF(D37=\"\",\"\",G274*IF(G61=B$660,'Unit Costs'!B$30+'Unit Costs'!B$35+'Unit Costs'!B$39,IF(G61=B$661,'Unit Costs'!B$29+'Unit Costs'!B$35+'Unit Costs'!B$38,0)))","v":""},{"$f":"IF(D37=\"\",\"\",G274*IF(G61=B$660,'Unit Costs'!C$30+'Unit Costs'!C$35+'Unit Costs'!C$39,IF(G61=B$661,'Unit Costs'!C$29+'Unit Costs'!C$35+'Unit Costs'!C$38,0)))","v":""},0,0,0]
[{"$f":"A38","v":5},"",{"$f":"IF(D38=\"\",\"\",(E38*E38/2/G38*(D38-E38)/2+(E38*E38*(E38/2/G38))/3-((E38/2/G38)-F38)*(E38-(2*F38*G38))*(D38-E38)/2-(((E38-(2*F38*G38))*(E38-(2*F38*G38)))*((E38/2/G38)-F38))/3)/27-(E38*E38/2/G38*(D38-E38)/2+(E38*E38*(E38/2/G38))/3-((E38/2/G38)-H38)*(E38-(2*H38*G38))*(D38-E38)/2-(((E38-(2*H38*G38))*(E38-(2*H38*G38)))*((E38/2/G38)-H38))/3)/27)","v":""},"","","","",{"$f":"IF(D38=\"\",\"\",G275*IF(G62=B$660,'Unit Costs'!B$30+'Unit Costs'!B$35+'Unit Costs'!B$39,IF(G62=B$661,'Unit Costs'!B$29+'Unit Costs'!B$35+'Unit Costs'!B$38,0)))","v":""},{"$f":"IF(D38=\"\",\"\",G275*IF(G62=B$660,'Unit Costs'!C$30+'Unit Costs'!C$35+'Unit Costs'!C$39,IF(G62=B$661,'Unit Costs'!C$29+'Unit Costs'!C$35+'Unit Costs'!C$38,0)))","v":""},0,0,0]
[{"$f":"A39","v":6},"",{"$f":"IF(D39=\"\",\"\",(E39*E39/2/G39*(D39-E39)/2+(E39*E39*(E39/2/G39))/3-((E39/2/G39)-F39)*(E39-(2*F39*G39))*(D39-E39)/2-(((E39-(2*F39*G39))*(E39-(2*F39*G39)))*((E39/2/G39)-F39))/3)/27-(E39*E39/2/G39*(D39-E39)/2+(E39*E39*(E39/2/G39))/3-((E39/2/G39)-H39)*(E39-(2*H39*G39))*(D39-E39)/2-(((E39-(2*H39*G39))*(E39-(2*H39*G39)))*((E39/2/G39)-H39))/3)/27)","v":""},"","","","",{"$f":"IF(D39=\"\",\"\",G276*IF(G63=B$660,'Unit Costs'!B$30+'Unit Costs'!B$35+'Unit Costs'!B$39,IF(G63=B$661,'Unit Costs'!B$29+'Unit Costs'!B$35+'Unit Costs'!B$38,0)))","v":""},{"$f":"IF(D39=\"\",\"\",G276*IF(G63=B$660,'Unit Costs'!C$30+'Unit Costs'!C$35+'Unit Costs'!C$39,IF(G63=B$661,'Unit Costs'!C$29+'Unit Costs'!C$35+'Unit Costs'!C$38,0)))","v":""},0,0,0]
[null,null,{"$f":"SUM(C271:C276)","v":0},null,null,null,{"$f":"SUM(G271:G276)","v":0},{"$f":"SUM(H271:H276)","v":0},{"$f":"SUM(I271:I276)","v":0},{"$f":"SUM(J271:J276)","v":0},{"$f":"SUM(K271:K276)","v":0}]
[]
[]
[]
["HLP to Pond to Pond Double Wall Piping 4\" inside 6\"Dia Welded HDPE, Trench Excavation 2' Wide x 3' Deep"]
[null,null,null,"Trench Excavation",null,null,null,null,"HDPE Pipe installation"]
["Description\n(required)",null,"Total Pipe Length","Trench Volume","Crew Hours","Trench    Labor \nCost","Trench Equipment \nCost","Total \nTrench\nCost","Productivity","Crew Hours","(4)    Labor                Cost","(4) Equipment           Cost","(4) Material \nCost","Total Piping Cost"]
[null,null,"ft","cy","hrs",null,null,null,"lf/hr","hrs"]
[{"$f":"A$34","v":1},{"$f":"B34","v":""},{"$f":"IF(B34=\"\",0,K102+M102)","v":0},{"$f":"C285*3*2/27","v":0},{"$f":"D285/'Unit Costs'!F$73","v":0},{"$f":"D285*'Unit Costs'!H$73","v":0},{"$f":"D285*'Unit Costs'!I$73","v":0},{"$f":"SUM(F285:G285)","v":0},{"$f":"IF(C285=0,0,'Unit Costs'!F$78)","v":0},{"$f":"IF(C285=0,0,C285/I285)","v":0},{"$f":"('Unit Costs'!H$78+'Unit Costs'!H$77)*C285","v":0},{"$f":"('Unit Costs'!I$77+'Unit Costs'!I$78)*C285","v":0},{"$f":"IF(C285=0,0,('Unit Costs'!G$77+'Unit Costs'!G$78)*C285)","v":0},{"$f":"SUM(K285:M285)","v":0}]
[{"$f":"A$35","v":2},"",0,0,{"$f":"D286/'Unit Costs'!F$73","v":0},{"$f":"D286*'Unit Costs'!H$73","v":0},{"$f":"D286*'Unit Costs'!I$73","v":0},0,{"$f":"IF(C286=0,0,'Unit Costs'!F$78)","v":0},0,{"$f":"('Unit Costs'!H$78+'Unit Costs'!H$77)*C286","v":0},{"$f":"('Unit Costs'!I$77+'Unit Costs'!I$78)*C286","v":0},{"$f":"IF(C286=0,0,('Unit Costs'!G$77+'Unit Costs'!G$78)*C286)","v":0},0]
[{"$f":"A$36","v":3},"",0,0,{"$f":"D287/'Unit Costs'!F$73","v":0},{"$f":"D287*'Unit Costs'!H$73","v":0},{"$f":"D287*'Unit Costs'!I$73","v":0},0,{"$f":"IF(C287=0,0,'Unit Costs'!F$78)","v":0},0,{"$f":"('Unit Costs'!H$78+'Unit Costs'!H$77)*C287","v":0},{"$f":"('Unit Costs'!I$77+'Unit Costs'!I$78)*C287","v":0},{"$f":"IF(C287=0,0,('Unit Costs'!G$77+'Unit Costs'!G$78)*C287)","v":0},0]
[{"$f":"A37","v":4},"",0,0,{"$f":"D288/'Unit Costs'!F$73","v":0},{"$f":"D288*'Unit Costs'!H$73","v":0},{"$f":"D288*'Unit Costs'!I$73","v":0},0,{"$f":"IF(C288=0,0,'Unit Costs'!F$78)","v":0},0,{"$f":"('Unit Costs'!H$78+'Unit Costs'!H$77)*C288","v":0},{"$f":"('Unit Costs'!I$77+'Unit Costs'!I$78)*C288","v":0},{"$f":"IF(C288=0,0,('Unit Costs'!G$77+'Unit Costs'!G$78)*C288)","v":0},0]
[{"$f":"A38","v":5},"",0,0,{"$f":"D289/'Unit Costs'!F$73","v":0},{"$f":"D289*'Unit Costs'!H$73","v":0},{"$f":"D289*'Unit Costs'!I$73","v":0},0,{"$f":"IF(C289=0,0,'Unit Costs'!F$78)","v":0},0,{"$f":"('Unit Costs'!H$78+'Unit Costs'!H$77)*C289","v":0},{"$f":"('Unit Costs'!I$77+'Unit Costs'!I$78)*C289","v":0},{"$f":"IF(C289=0,0,('Unit Costs'!G$77+'Unit Costs'!G$78)*C289)","v":0},0]
[{"$f":"A39","v":6},"",0,0,{"$f":"D290/'Unit Costs'!F$73","v":0},{"$f":"D290*'Unit Costs'!H$73","v":0},{"$f":"D290*'Unit Costs'!I$73","v":0},0,{"$f":"IF(C290=0,0,'Unit Costs'!F$78)","v":0},0,{"$f":"('Unit Costs'!H$78+'Unit Costs'!H$77)*C290","v":0},{"$f":"('Unit Costs'!I$77+'Unit Costs'!I$78)*C290","v":0},{"$f":"IF(C290=0,0,('Unit Costs'!G$77+'Unit Costs'!G$78)*C290)","v":0},0]
[null,null,{"$f":"SUM(C285:C290)","v":0},0,0,0,0,0,null,{"$f":"SUM(J285:J290)","v":0},0,0,0,0]
[]
[]
[]
["HLP to Pond to Pond Piping  Total Cost (Continued)"]
[null,null,"HDPE Pipe installation"]
["Description\n(required)",null,"Total Labor Cost","Total Equipment Cost","Total    Material \nCost","Total Piping Cost","Unit Cost"]
[null,null,null,null,null,null,"$/lf"]
[{"$f":"A$34","v":1},{"$f":"B34","v":""},{"$f":"K285+F285","v":0},0,{"$f":"M285","v":0},{"$f":"SUM(C299:E299)","v":0},{"$f":"IF(C285=0,0,F299/C285)","v":0}]
[{"$f":"A$35","v":2},{"$f":"B35","v":""},0,0,0,0,0]
[{"$f":"A$36","v":3},"",0,0,0,0,0]
[{"$f":"A37","v":4},"",0,0,0,0,0]
[{"$f":"A38","v":5},"",0,0,0,0,0]
[{"$f":"A39","v":6},"",0,0,0,0,0]
[null,null,{"$f":"SUM(C299:C304)","v":0},{"$f":"SUM(D299:D304)","v":0},{"$f":"SUM(E299:E304)","v":0},{"$f":"SUM(F299:F304)","v":0}]
[]
[null,"(4) Labor, Equipment and Materials are included for both 6\" Welded HDPE and 4\" Welded HDPE Pipe"]
[]
[]
["Fencing, 10' Chain Link, 20' offset from top of slope, includes gates"]
[]
["Description\n(required)",null,"Fencing Length","Productivity","Crew Hours","Total \nLabor \nCost","Total \nEquipment \nCost","Total \nMaterial\nCost","Total \nFence Installation\nCost","Unit Cost"]
[null,null,"ft","lf/hr","hrs",null,null,null,null,"$/lf"]
[{"$f":"A$34","v":1},{"$f":"B34","v":""},{"$f":"IF(B34=\"\",0,IF(C102=\"\",(D34+E34+80)*2,IF(C102=\"Poor >10 yrs\",(D34+E34+80)*2,IF(C102=\"Fair 5 yrs -10 yrs\",D34+E34+80,IF(C102=\"New < 5 yrs\",(D34+E34+80)/2,IF(C102=\"No New Fence\",0,\"Select Fence\"))))))","v":0},{"$f":"IF(D34=\"\",0,'Unit Costs'!F$81)","v":0},{"$f":"IF(D34=\"\",0,C314/D314)","v":0},{"$f":"'Unit Costs'!H$81*C314","v":0},{"$f":"'Unit Costs'!I$81*C314","v":0},{"$f":"'Unit Costs'!G$81*C314","v":0},{"$f":"SUM(F314:H314)","v":0},{"$f":"IF(B314=\"\",0,IF(C314=0,0,I314/C314))","v":0}]
[{"$f":"A$35","v":2},"",{"$f":"IF(B35=\"\",0,IF(C103=\"\",(D35+E35+80)*2,IF(C103=\"Poor >10 yrs\",(D35+E35+80)*2,IF(C103=\"Fair 5 yrs -10 yrs\",D35+E35+80,IF(C103=\"New < 5 yrs\",(D35+E35+80)/2,IF(C103=\"No New Fence\",0,\"Select Fence\"))))))","v":0},{"$f":"IF(D35=\"\",0,'Unit Costs'!F$81)","v":0},0,{"$f":"'Unit Costs'!H$81*C315","v":0},{"$f":"'Unit Costs'!I$81*C315","v":0},{"$f":"'Unit Costs'!G$81*C315","v":0},0,{"$f":"IF(B315=\"\",0,IF(C315=0,0,I315/C315))","v":0}]
[{"$f":"A$36","v":3},"",0,{"$f":"IF(D36=\"\",0,'Unit Costs'!F$81)","v":0},0,{"$f":"'Unit Costs'!H$81*C316","v":0},{"$f":"'Unit Costs'!I$81*C316","v":0},{"$f":"'Unit Costs'!G$81*C316","v":0},0,0]
[{"$f":"A37","v":4},"",0,{"$f":"IF(D37=\"\",0,'Unit Costs'!F$81)","v":0},0,{"$f":"'Unit Costs'!H$81*C317","v":0},{"$f":"'Unit Costs'!I$81*C317","v":0},{"$f":"'Unit Costs'!G$81*C317","v":0},0,0]
[{"$f":"A38","v":5},"",0,{"$f":"IF(D38=\"\",0,'Unit Costs'!F$81)","v":0},0,{"$f":"'Unit Costs'!H$81*C318","v":0},{"$f":"'Unit Costs'!I$81*C318","v":0},{"$f":"'Unit Costs'!G$81*C318","v":0},0,0]
[{"$f":"A39","v":6},"",0,{"$f":"IF(D39=\"\",0,'Unit Costs'!F$81)","v":0},0,{"$f":"'Unit Costs'!H$81*C319","v":0},{"$f":"'Unit Costs'!I$81*C319","v":0},{"$f":"'Unit Costs'!G$81*C319","v":0},0,0]
[null,null,{"$f":"SUM(C314:C319)","v":0},null,{"$f":"SUM(E314:E319)","v":0},{"$f":"SUM(F314:F319)","v":0},{"$f":"SUM(G314:G319)","v":0},{"$f":"SUM(H314:H319)","v":0},{"$f":"SUM(I314:I319)","v":0}]
[]
[null,"Blank or Poor Condition Fence calculates cost for full fence installation."]
[null,"Fair Condition Fence Calculates 50% total fence length installation for repair and replacement"]
[null,"New Fence calculates 25% cost for fence installation or repair. Assumes some minor construction damage."]
[null,"No New Fence calculates no cost for fence installation.  Assumes wildlife fence not required. "]
[]
["Revegetation"]
[null,null,null,null,"Growth Media/Cover Costs",null,null,null,null,null,"Revegetation Costs"]
["Description\n(required)",null,"Cover Volume","Cover Replacement Fleet","Number of Trucks/ Scrapers","Fleet Productivity","Total Fleet Hours","Total \nLabor \nCost","Total \nEquipment \nCost","Total Growth Media Cost","Flat Area","Revegetation                Labor                Cost","Revegetation         Equipment           Cost","Revegetation\nMaterial \nCost","Total Revegetation Cost","Unit Cost"]
[null,null,"cy",null,null,"LCY/hr",null,null,null,null,"acres","$","$","$","$","$/ac"]
[{"$f":"A$34","v":1},{"$f":"$B34","v":""},{"$f":"C80*D80*43560/12/27","v":0},{"$f":"IF(D34=\"\",\"\",H80)","v":""},{"$f":"IF(B34=\"\",0,IF(I80=0,ROUNDUP((N567-L567)/L567,0),I80))","v":0},{"$f":"IF(B34=\"\",0,ROUND(0.83*E331*((IF(D331=\"769D 988G D7R\",26.65,IF(D331=\"777D 992G D7R\",66.8,\"Select Fleet\"))*60)/N567),0))","v":0},{"$f":"IF(B34=\"\",0,ROUND(IF(B34=\"\",\"\",C331/F331),0))","v":0},{"$f":"IF(D34=\"\",\"\",G331*IF(H80=D$662,'Unit Costs'!B$30+'Unit Costs'!B$35+'Unit Costs'!B$39,IF(H80=D$663,'Unit Costs'!B$29+'Unit Costs'!B$35+'Unit Costs'!B$38,\"Select Fleet\")))","v":""},{"$f":"IF(B34=\"\",\"\",G331*IF(H80=B$660,('Unit Costs'!C$30+'Unit Costs'!C$39+'Unit Costs'!C$35),IF(H80=B$661,('Unit Costs'!C$29+'Unit Costs'!C$38+'Unit Costs'!C$35),0)))","v":""},{"$f":"SUM(H331:I331)","v":0},{"$f":"C80","v":0},{"$f":"IF(B34=\"\",0,IF(K80=\"Yes\",(((J80*(C80*43560/J80)/IF(O80=H$660,9.75,IF(O80=H$661,11.54,IF(O80=H$662,13,IF(O80=H$663,9.75,\"Select Fleet\")))))/(IF(O80=H$660,5280,IF(O80=H$661,5280,IF(O80=H$662,5280,IF(O80=H$663,7920,\"Select Fleet\"))))))+((IF(O80=H$660,0.25,IF(O80=H$661,0.25,IF(O80=H$662,0.25,IF(O80=H$663,0.5,\"Select Fleet\")))))*((C80*43560/J80)/IF(O80=H$660,9.75,IF(O80=H$661,11.54,IF(O80=H$662,13,IF(O80=H$663,9.75,\"Select Fleet\")))))/60))*IF(O80=H$660,'Unit Costs'!B$35,IF(O80=H$661,'Unit Costs'!B$34,IF(O80=H$662,'Unit Costs'!B$33,IF(O80=H$663,'Unit Costs'!B$52,\"Select Fleet\")))),0)+'Unit Costs'!H$83*C80)","v":0},{"$f":"IF(B34=\"\",0,IF(K80=\"Yes\",(((J80*(C80*43560/J80)/IF(O80=H$660,9.75,IF(O80=H$661,11.54,IF(O80=H$662,13,IF(O80=H$663,9.75,\"Select Fleet\")))))/(IF(O80=H$660,5280,IF(O80=H$661,5280,IF(O80=H$662,5280,IF(O80=H$663,7920,\"Select Fleet\"))))))+((IF(O80=H$660,0.25,IF(O80=H$661,0.25,IF(O80=H$662,0.25,IF(O80=H$663,0.5,\"Select Fleet\")))))*((C80*43560/J80)/IF(O80=H$660,9.75,IF(O80=H$661,11.54,IF(O80=H$662,13,IF(O80=H$663,9.75,\"Select Fleet\")))))/60))*IF(O80=H$660,'Unit Costs'!C$35,IF(O80=H$661,'Unit Costs'!C$34,IF(O80=H$662,'Unit Costs'!C$33,IF(O80=H$663,'Unit Costs'!C$52,\"Select Fleet\")))),0)+'Unit Costs'!I$83*C80)","v":0},{"$f":"IF(O80=\"\",0,K331*(IF(L80=L$644,'Unit Costs'!D$89,IF(L80=L$645,'Unit Costs'!D$90,IF(L80=L$646,'Unit Costs'!D$91,IF(L80=L$647,'Unit Costs'!D$92,IF(L80=L$648,'Unit Costs'!D$93,IF(L80=L$649,'Unit Costs'!D$94,IF(L80=L$650,'Unit Costs'!D$95,IF(L80=L$651,'Unit Costs'!D$96))))))))+IF(M80=J$652,'Unit Costs'!D$100,IF(M80=J$653,'Unit Costs'!D$101,0))+IF(N80=K$652,'Unit Costs'!D$102,IF(N80=K$653,'Unit Costs'!D$103,0))))","v":0},{"$f":"SUM(L331:N331)","v":0},{"$f":"IF(K331=0,0,C331/(J331+O331))","v":0}]
[{"$f":"A$35","v":2},"",0,"",0,0,0,{"$f":"IF(D35=\"\",\"\",G332*IF(H81=D$662,'Unit Costs'!B$30+'Unit Costs'!B$35+'Unit Costs'!B$39,IF(H81=D$663,'Unit Costs'!B$29+'Unit Costs'!B$35+'Unit Costs'!B$38,\"Select Fleet\")))","v":""},{"$f":"IF(B35=\"\",\"\",G332*IF(H81=B$660,('Unit Costs'!C$30+'Unit Costs'!C$39+'Unit Costs'!C$35),IF(H81=B$661,('Unit Costs'!C$29+'Unit Costs'!C$38+'Unit Costs'!C$35),0)))","v":""},0,0,{"$f":"IF(B35=\"\",0,IF(K81=\"Yes\",(((J81*(C81*43560/J81)/IF(O81=H$660,9.75,IF(O81=H$661,11.54,IF(O81=H$662,13,IF(O81=H$663,9.75,\"Select Fleet\")))))/(IF(O81=H$660,5280,IF(O81=H$661,5280,IF(O81=H$662,5280,IF(O81=H$663,7920,\"Select Fleet\"))))))+((IF(O81=H$660,0.25,IF(O81=H$661,0.25,IF(O81=H$662,0.25,IF(O81=H$663,0.5,\"Select Fleet\")))))*((C81*43560/J81)/IF(O81=H$660,9.75,IF(O81=H$661,11.54,IF(O81=H$662,13,IF(O81=H$663,9.75,\"Select Fleet\")))))/60))*IF(O81=H$660,'Unit Costs'!B$35,IF(O81=H$661,'Unit Costs'!B$34,IF(O81=H$662,'Unit Costs'!B$33,IF(O81=H$663,'Unit Costs'!B$52,\"Select Fleet\")))),0)+'Unit Costs'!H$83*C81)","v":0},{"$f":"IF(B35=\"\",0,IF(K81=\"Yes\",(((J81*(C81*43560/J81)/IF(O81=H$660,9.75,IF(O81=H$661,11.54,IF(O81=H$662,13,IF(O81=H$663,9.75,\"Select Fleet\")))))/(IF(O81=H$660,5280,IF(O81=H$661,5280,IF(O81=H$662,5280,IF(O81=H$663,7920,\"Select Fleet\"))))))+((IF(O81=H$660,0.25,IF(O81=H$661,0.25,IF(O81=H$662,0.25,IF(O81=H$663,0.5,\"Select Fleet\")))))*((C81*43560/J81)/IF(O81=H$660,9.75,IF(O81=H$661,11.54,IF(O81=H$662,13,IF(O81=H$663,9.75,\"Select Fleet\")))))/60))*IF(O81=H$660,'Unit Costs'!C$35,IF(O81=H$661,'Unit Costs'!C$34,IF(O81=H$662,'Unit Costs'!C$33,IF(O81=H$663,'Unit Costs'!C$52,\"Select Fleet\")))),0)+'Unit Costs'!I$83*C81)","v":0},{"$f":"IF(O81=\"\",0,K332*(IF(L81=L$644,'Unit Costs'!D$89,IF(L81=L$645,'Unit Costs'!D$90,IF(L81=L$646,'Unit Costs'!D$91,IF(L81=L$647,'Unit Costs'!D$92,IF(L81=L$648,'Unit Costs'!D$93,IF(L81=L$649,'Unit Costs'!D$94,IF(L81=L$650,'Unit Costs'!D$95,IF(L81=L$651,'Unit Costs'!D$96))))))))+IF(M81=J$652,'Unit Costs'!D$100,IF(M81=J$653,'Unit Costs'!D$101,0))+IF(N81=K$652,'Unit Costs'!D$102,IF(N81=K$653,'Unit Costs'!D$103,0))))","v":0},0,{"$f":"IF(K332=0,0,C332/(J332+O332))","v":0}]
[{"$f":"A$36","v":3},"",0,"",0,0,0,{"$f":"IF(D36=\"\",\"\",G333*IF(H82=D$662,'Unit Costs'!B$30+'Unit Costs'!B$35+'Unit Costs'!B$39,IF(H82=D$663,'Unit Costs'!B$29+'Unit Costs'!B$35+'Unit Costs'!B$38,\"Select Fleet\")))","v":""},{"$f":"IF(B36=\"\",\"\",G333*IF(H82=B$660,('Unit Costs'!C$30+'Unit Costs'!C$39+'Unit Costs'!C$35),IF(H82=B$661,('Unit Costs'!C$29+'Unit Costs'!C$38+'Unit Costs'!C$35),0)))","v":""},0,0,{"$f":"IF(B36=\"\",0,IF(K82=\"Yes\",(((J82*(C82*43560/J82)/IF(O82=H$660,9.75,IF(O82=H$661,11.54,IF(O82=H$662,13,IF(O82=H$663,9.75,\"Select Fleet\")))))/(IF(O82=H$660,5280,IF(O82=H$661,5280,IF(O82=H$662,5280,IF(O82=H$663,7920,\"Select Fleet\"))))))+((IF(O82=H$660,0.25,IF(O82=H$661,0.25,IF(O82=H$662,0.25,IF(O82=H$663,0.5,\"Select Fleet\")))))*((C82*43560/J82)/IF(O82=H$660,9.75,IF(O82=H$661,11.54,IF(O82=H$662,13,IF(O82=H$663,9.75,\"Select Fleet\")))))/60))*IF(O82=H$660,'Unit Costs'!B$35,IF(O82=H$661,'Unit Costs'!B$34,IF(O82=H$662,'Unit Costs'!B$33,IF(O82=H$663,'Unit Costs'!B$52,\"Select Fleet\")))),0)+'Unit Costs'!H$83*C82)","v":0},{"$f":"IF(B36=\"\",0,IF(K82=\"Yes\",(((J82*(C82*43560/J82)/IF(O82=H$660,9.75,IF(O82=H$661,11.54,IF(O82=H$662,13,IF(O82=H$663,9.75,\"Select Fleet\")))))/(IF(O82=H$660,5280,IF(O82=H$661,5280,IF(O82=H$662,5280,IF(O82=H$663,7920,\"Select Fleet\"))))))+((IF(O82=H$660,0.25,IF(O82=H$661,0.25,IF(O82=H$662,0.25,IF(O82=H$663,0.5,\"Select Fleet\")))))*((C82*43560/J82)/IF(O82=H$660,9.75,IF(O82=H$661,11.54,IF(O82=H$662,13,IF(O82=H$663,9.75,\"Select Fleet\")))))/60))*IF(O82=H$660,'Unit Costs'!C$35,IF(O82=H$661,'Unit Costs'!C$34,IF(O82=H$662,'Unit Costs'!C$33,IF(O82=H$663,'Unit Costs'!C$52,\"Select Fleet\")))),0)+'Unit Costs'!I$83*C82)","v":0},{"$f":"IF(O82=\"\",0,K333*(IF(L82=L$644,'Unit Costs'!D$89,IF(L82=L$645,'Unit Costs'!D$90,IF(L82=L$646,'Unit Costs'!D$91,IF(L82=L$647,'Unit Costs'!D$92,IF(L82=L$648,'Unit Costs'!D$93,IF(L82=L$649,'Unit Costs'!D$94,IF(L82=L$650,'Unit Costs'!D$95,IF(L82=L$651,'Unit Costs'!D$96))))))))+IF(M82=J$652,'Unit Costs'!D$100,IF(M82=J$653,'Unit Costs'!D$101,0))+IF(N82=K$652,'Unit Costs'!D$102,IF(N82=K$653,'Unit Costs'!D$103,0))))","v":0},0,{"$f":"IF(K333=0,0,C333/(J333+O333))","v":0}]
[{"$f":"A37","v":4},"",0,"",0,0,0,{"$f":"IF(D37=\"\",\"\",G334*IF(H83=D$662,'Unit Costs'!B$30+'Unit Costs'!B$35+'Unit Costs'!B$39,IF(H83=D$663,'Unit Costs'!B$29+'Unit Costs'!B$35+'Unit Costs'!B$38,\"Select Fleet\")))","v":""},{"$f":"IF(B37=\"\",\"\",G334*IF(H83=B$660,('Unit Costs'!C$30+'Unit Costs'!C$39+'Unit Costs'!C$35),IF(H83=B$661,('Unit Costs'!C$29+'Unit Costs'!C$38+'Unit Costs'!C$35),0)))","v":""},0,0,{"$f":"IF(B37=\"\",0,IF(K83=\"Yes\",(((J83*(C83*43560/J83)/IF(O83=H$660,9.75,IF(O83=H$661,11.54,IF(O83=H$662,13,IF(O83=H$663,9.75,\"Select Fleet\")))))/(IF(O83=H$660,5280,IF(O83=H$661,5280,IF(O83=H$662,5280,IF(O83=H$663,7920,\"Select Fleet\"))))))+((IF(O83=H$660,0.25,IF(O83=H$661,0.25,IF(O83=H$662,0.25,IF(O83=H$663,0.5,\"Select Fleet\")))))*((C83*43560/J83)/IF(O83=H$660,9.75,IF(O83=H$661,11.54,IF(O83=H$662,13,IF(O83=H$663,9.75,\"Select Fleet\")))))/60))*IF(O83=H$660,'Unit Costs'!B$35,IF(O83=H$661,'Unit Costs'!B$34,IF(O83=H$662,'Unit Costs'!B$33,IF(O83=H$663,'Unit Costs'!B$52,\"Select Fleet\")))),0)+'Unit Costs'!H$83*C83)","v":0},{"$f":"IF(B37=\"\",0,IF(K83=\"Yes\",(((J83*(C83*43560/J83)/IF(O83=H$660,9.75,IF(O83=H$661,11.54,IF(O83=H$662,13,IF(O83=H$663,9.75,\"Select Fleet\")))))/(IF(O83=H$660,5280,IF(O83=H$661,5280,IF(O83=H$662,5280,IF(O83=H$663,7920,\"Select Fleet\"))))))+((IF(O83=H$660,0.25,IF(O83=H$661,0.25,IF(O83=H$662,0.25,IF(O83=H$663,0.5,\"Select Fleet\")))))*((C83*43560/J83)/IF(O83=H$660,9.75,IF(O83=H$661,11.54,IF(O83=H$662,13,IF(O83=H$663,9.75,\"Select Fleet\")))))/60))*IF(O83=H$660,'Unit Costs'!C$35,IF(O83=H$661,'Unit Costs'!C$34,IF(O83=H$662,'Unit Costs'!C$33,IF(O83=H$663,'Unit Costs'!C$52,\"Select Fleet\")))),0)+'Unit Costs'!I$83*C83)","v":0},{"$f":"IF(O83=\"\",0,K334*(IF(L83=L$644,'Unit Costs'!D$89,IF(L83=L$645,'Unit Costs'!D$90,IF(L83=L$646,'Unit Costs'!D$91,IF(L83=L$647,'Unit Costs'!D$92,IF(L83=L$648,'Unit Costs'!D$93,IF(L83=L$649,'Unit Costs'!D$94,IF(L83=L$650,'Unit Costs'!D$95,IF(L83=L$651,'Unit Costs'!D$96))))))))+IF(M83=J$652,'Unit Costs'!D$100,IF(M83=J$653,'Unit Costs'!D$101,0))+IF(N83=K$652,'Unit Costs'!D$102,IF(N83=K$653,'Unit Costs'!D$103,0))))","v":0},0,0]
[{"$f":"A38","v":5},"",0,"",0,0,0,{"$f":"IF(D38=\"\",\"\",G335*IF(H84=D$662,'Unit Costs'!B$30+'Unit Costs'!B$35+'Unit Costs'!B$39,IF(H84=D$663,'Unit Costs'!B$29+'Unit Costs'!B$35+'Unit Costs'!B$38,\"Select Fleet\")))","v":""},{"$f":"IF(B38=\"\",\"\",G335*IF(H84=B$660,('Unit Costs'!C$30+'Unit Costs'!C$39+'Unit Costs'!C$35),IF(H84=B$661,('Unit Costs'!C$29+'Unit Costs'!C$38+'Unit Costs'!C$35),0)))","v":""},0,0,{"$f":"IF(B38=\"\",0,IF(K84=\"Yes\",(((J84*(C84*43560/J84)/IF(O84=H$660,9.75,IF(O84=H$661,11.54,IF(O84=H$662,13,IF(O84=H$663,9.75,\"Select Fleet\")))))/(IF(O84=H$660,5280,IF(O84=H$661,5280,IF(O84=H$662,5280,IF(O84=H$663,7920,\"Select Fleet\"))))))+((IF(O84=H$660,0.25,IF(O84=H$661,0.25,IF(O84=H$662,0.25,IF(O84=H$663,0.5,\"Select Fleet\")))))*((C84*43560/J84)/IF(O84=H$660,9.75,IF(O84=H$661,11.54,IF(O84=H$662,13,IF(O84=H$663,9.75,\"Select Fleet\")))))/60))*IF(O84=H$660,'Unit Costs'!B$35,IF(O84=H$661,'Unit Costs'!B$34,IF(O84=H$662,'Unit Costs'!B$33,IF(O84=H$663,'Unit Costs'!B$52,\"Select Fleet\")))),0)+'Unit Costs'!H$83*C84)","v":0},{"$f":"IF(B38=\"\",0,IF(K84=\"Yes\",(((J84*(C84*43560/J84)/IF(O84=H$660,9.75,IF(O84=H$661,11.54,IF(O84=H$662,13,IF(O84=H$663,9.75,\"Select Fleet\")))))/(IF(O84=H$660,5280,IF(O84=H$661,5280,IF(O84=H$662,5280,IF(O84=H$663,7920,\"Select Fleet\"))))))+((IF(O84=H$660,0.25,IF(O84=H$661,0.25,IF(O84=H$662,0.25,IF(O84=H$663,0.5,\"Select Fleet\")))))*((C84*43560/J84)/IF(O84=H$660,9.75,IF(O84=H$661,11.54,IF(O84=H$662,13,IF(O84=H$663,9.75,\"Select Fleet\")))))/60))*IF(O84=H$660,'Unit Costs'!C$35,IF(O84=H$661,'Unit Costs'!C$34,IF(O84=H$662,'Unit Costs'!C$33,IF(O84=H$663,'Unit Costs'!C$52,\"Select Fleet\")))),0)+'Unit Costs'!I$83*C84)","v":0},{"$f":"IF(O84=\"\",0,K335*(IF(L84=L$644,'Unit Costs'!D$89,IF(L84=L$645,'Unit Costs'!D$90,IF(L84=L$646,'Unit Costs'!D$91,IF(L84=L$647,'Unit Costs'!D$92,IF(L84=L$648,'Unit Costs'!D$93,IF(L84=L$649,'Unit Costs'!D$94,IF(L84=L$650,'Unit Costs'!D$95,IF(L84=L$651,'Unit Costs'!D$96))))))))+IF(M84=J$652,'Unit Costs'!D$100,IF(M84=J$653,'Unit Costs'!D$101,0))+IF(N84=K$652,'Unit Costs'!D$102,IF(N84=K$653,'Unit Costs'!D$103,0))))","v":0},0,0]
[{"$f":"A39","v":6},"",0,"",0,0,0,{"$f":"IF(D39=\"\",\"\",G336*IF(H85=D$662,'Unit Costs'!B$30+'Unit Costs'!B$35+'Unit Costs'!B$39,IF(H85=D$663,'Unit Costs'!B$29+'Unit Costs'!B$35+'Unit Costs'!B$38,\"Select Fleet\")))","v":""},{"$f":"IF(B39=\"\",\"\",G336*IF(H85=B$660,('Unit Costs'!C$30+'Unit Costs'!C$39+'Unit Costs'!C$35),IF(H85=B$661,('Unit Costs'!C$29+'Unit Costs'!C$38+'Unit Costs'!C$35),0)))","v":""},0,0,{"$f":"IF(B39=\"\",0,IF(K85=\"Yes\",(((J85*(C85*43560/J85)/IF(O85=H$660,9.75,IF(O85=H$661,11.54,IF(O85=H$662,13,IF(O85=H$663,9.75,\"Select Fleet\")))))/(IF(O85=H$660,5280,IF(O85=H$661,5280,IF(O85=H$662,5280,IF(O85=H$663,7920,\"Select Fleet\"))))))+((IF(O85=H$660,0.25,IF(O85=H$661,0.25,IF(O85=H$662,0.25,IF(O85=H$663,0.5,\"Select Fleet\")))))*((C85*43560/J85)/IF(O85=H$660,9.75,IF(O85=H$661,11.54,IF(O85=H$662,13,IF(O85=H$663,9.75,\"Select Fleet\")))))/60))*IF(O85=H$660,'Unit Costs'!B$35,IF(O85=H$661,'Unit Costs'!B$34,IF(O85=H$662,'Unit Costs'!B$33,IF(O85=H$663,'Unit Costs'!B$52,\"Select Fleet\")))),0)+'Unit Costs'!H$83*C85)","v":0},{"$f":"IF(B39=\"\",0,IF(K85=\"Yes\",(((J85*(C85*43560/J85)/IF(O85=H$660,9.75,IF(O85=H$661,11.54,IF(O85=H$662,13,IF(O85=H$663,9.75,\"Select Fleet\")))))/(IF(O85=H$660,5280,IF(O85=H$661,5280,IF(O85=H$662,5280,IF(O85=H$663,7920,\"Select Fleet\"))))))+((IF(O85=H$660,0.25,IF(O85=H$661,0.25,IF(O85=H$662,0.25,IF(O85=H$663,0.5,\"Select Fleet\")))))*((C85*43560/J85)/IF(O85=H$660,9.75,IF(O85=H$661,11.54,IF(O85=H$662,13,IF(O85=H$663,9.75,\"Select Fleet\")))))/60))*IF(O85=H$660,'Unit Costs'!C$35,IF(O85=H$661,'Unit Costs'!C$34,IF(O85=H$662,'Unit Costs'!C$33,IF(O85=H$663,'Unit Costs'!C$52,\"Select Fleet\")))),0)+'Unit Costs'!I$83*C85)","v":0},{"$f":"IF(O85=\"\",0,K336*(IF(L85=L$644,'Unit Costs'!D$89,IF(L85=L$645,'Unit Costs'!D$90,IF(L85=L$646,'Unit Costs'!D$91,IF(L85=L$647,'Unit Costs'!D$92,IF(L85=L$648,'Unit Costs'!D$93,IF(L85=L$649,'Unit Costs'!D$94,IF(L85=L$650,'Unit Costs'!D$95,IF(L85=L$651,'Unit Costs'!D$96))))))))+IF(M85=J$652,'Unit Costs'!D$100,IF(M85=J$653,'Unit Costs'!D$101,0))+IF(N85=K$652,'Unit Costs'!D$102,IF(N85=K$653,'Unit Costs'!D$103,0))))","v":0},0,0]
[null,null,{"$f":"SUM(C331:C336)","v":0},null,null,null,{"$f":"SUM(G330:G336)","v":0},{"$f":"SUM(H331:H336)","v":0},0,0,0,0,0,0,0]
[]
[]
[]
["Individual Pond Summaries"]
[]
[{"$f":"B34","v":""},null,"Individual Pond Cost Summary"]
[null,null,"Labor","Equipment","Materials","Totals"]
[null,"Sludge Removal and Disposal","N/A",{"$f":"G125","v":0},"N/A",{"$f":"SUM(C345:E345)","v":0}]
[null,"Existing Liner Inspect and Repair",{"$f":"E140","v":0},{"$f":"F140","v":0},{"$f":"G140","v":0},0]
[null,"New Pond Excavation",{"$f":"L156","v":0},{"$f":"M156","v":0},"N/A",0]
[null,"Primary Liner Installation",{"$f":"E171","v":0},{"$f":"F171","v":0},{"$f":"G171","v":0},0]
[null,"Geonetting",{"$f":"E186","v":0},{"$f":"F186","v":0},{"$f":"G186","v":0},0]
[null,"Secondary Liner Installation",{"$f":"E201","v":0},{"$f":"F201","v":0},{"$f":"G201","v":0},0]
[null,"Liner Key Trenching",{"$f":"F215","v":0},{"$f":"G215","v":0},"N/A",0]
[null,"Dosing Tank",{"$f":"F229","v":0},{"$f":"G229","v":0},{"$f":"H229","v":0},0]
[null,"Piping Manifold",{"$f":"F243","v":0},{"$f":"G243","v":0},{"$f":"H243","v":0},0]
[null,"Screening for Backfill",{"$f":"IF(G257=\"\",0,G257)","v":0},{"$f":"IF(H257=\"\",0,H257)","v":0},"N/A",0]
[null,"Pond Backfill",{"$f":"IF(H271=\"\",0,H271)","v":0},{"$f":"IF(I271=\"\",0,I271)","v":0},"N/A",{"$f":"SUM(C355:E355)","v":0}]
[null,"HLP to Pond to Pond Piping",{"$f":"C299","v":0},{"$f":"D299","v":0},{"$f":"E299","v":0},0]
[null,"Fencing",{"$f":"F314","v":0},{"$f":"G314","v":0},{"$f":"H314","v":0},0]
[null,"Growth Media",{"$f":"H331","v":""},{"$f":"I331","v":""},"N/A",0]
[null,"Subtotal",{"$f":"SUM(C345:C358)","v":0},{"$f":"SUM(D345:D358)","v":0},{"$f":"SUM(E345:E358)","v":0},0]
[null,"Revegetation Costs",{"$f":"L331","v":0},{"$f":"M331","v":0},{"$f":"N331","v":0},0,{"$f":"(D34*E34/43560)","v":{"$error":"#VALUE!"}}]
[null,"TOTALS",{"$f":"C359+C360","v":0},{"$f":"D359+D360","v":0},{"$f":"E359+E360","v":0},0,{"$f":"IF(B34=\"\",\"\",F361/(D34*E34/43560))","v":""}]
[]
[{"$f":"B35","v":""},null,"Individual Pond Cost Summary"]
[null,null,"Labor","Equipment","Materials","Totals"]
[null,"Sludge Removal and Disposal","N/A",{"$f":"G126","v":0},"N/A",{"$f":"SUM(C365:E365)","v":0}]
[null,"Existing Liner Inspect and Repair",{"$f":"E141","v":0},{"$f":"F141","v":0},{"$f":"G141","v":0},0]
[null,"New Pond Excavation",{"$f":"L157","v":0},{"$f":"M157","v":0},"N/A",0]
[null,"Primary Liner Installation",{"$f":"E172","v":0},{"$f":"F172","v":0},{"$f":"G172","v":0},0]
[null,"Geonetting",{"$f":"E187","v":0},{"$f":"F187","v":0},{"$f":"G187","v":0},0]
[null,"Secondary Liner Installation",{"$f":"E202","v":0},{"$f":"F202","v":0},{"$f":"G202","v":0},0]
[null,"Liner Key Trenching",{"$f":"F216","v":0},{"$f":"G216","v":0},"N/A",0]
[null,"Dosing Tank",{"$f":"F230","v":0},{"$f":"G230","v":0},{"$f":"H230","v":0},0]
[null,"Piping Manifold",{"$f":"F244","v":0},{"$f":"G244","v":0},{"$f":"H244","v":0},0]
[null,"Screening for Backfill",{"$f":"IF(G258=\"\",0,G258)","v":0},{"$f":"IF(H258=\"\",0,H258)","v":0},"N/A",0]
[null,"Pond Backfill",{"$f":"IF(H272=\"\",0,H272)","v":0},{"$f":"IF(I272=\"\",0,I272)","v":0},"N/A",0]
[null,"HLP to Pond to Pond Piping",{"$f":"C300","v":0},{"$f":"D300","v":0},{"$f":"E300","v":0},0]
[null,"Fencing",{"$f":"F315","v":0},{"$f":"G315","v":0},{"$f":"H315","v":0},0]
[null,"Growth Media",{"$f":"H332","v":""},{"$f":"I332","v":""},"N/A",0]
[null,"Subtotal",{"$f":"SUM(C365:C378)","v":0},{"$f":"SUM(D365:D378)","v":0},{"$f":"SUM(E365:E378)","v":0},0]
[null,"Revegetation Costs",{"$f":"L332","v":0},{"$f":"M332","v":0},{"$f":"N332","v":0},0,{"$f":"(D35*E35/43560)","v":{"$error":"#VALUE!"}}]
[null,"TOTALS",{"$f":"C379+C380","v":0},{"$f":"D379+D380","v":0},{"$f":"E379+E380","v":0},0,{"$f":"IF(B35=\"\",\"\",F381/(D35*E35/43560))","v":""}]
[]
[{"$f":"B36","v":""},null,"Individual Pond Cost Summary"]
[null,null,"Labor","Equipment","Materials","Totals"]
[null,"Sludge Removal and Disposal","N/A",{"$f":"G127","v":0},"N/A",{"$f":"SUM(C385:E385)","v":0}]
[null,"Existing Liner Inspect and Repair",{"$f":"E142","v":0},{"$f":"F142","v":0},{"$f":"G142","v":0},0]
[null,"New Pond Excavation",{"$f":"L158","v":0},{"$f":"M158","v":0},"N/A",0]
[null,"Primary Liner Installation",{"$f":"E173","v":0},{"$f":"F173","v":0},{"$f":"G173","v":0},0]
[null,"Geonetting",{"$f":"E188","v":0},{"$f":"F188","v":0},{"$f":"G188","v":0},0]
[null,"Secondary Liner Installation",{"$f":"E203","v":0},{"$f":"F203","v":0},{"$f":"G203","v":0},0]
[null,"Liner Key Trenching",{"$f":"F217","v":0},{"$f":"G217","v":0},"N/A",0]
[null,"Dosing Tank",{"$f":"F231","v":0},{"$f":"G231","v":0},{"$f":"H231","v":0},0]
[null,"Piping Manifold",{"$f":"F245","v":0},{"$f":"G245","v":0},{"$f":"H245","v":0},0]
[null,"Screening for Backfill",{"$f":"IF(G259=\"\",0,G259)","v":0},{"$f":"IF(H259=\"\",0,H259)","v":0},"N/A",0]
[null,"Pond Backfill",{"$f":"IF(H273=\"\",0,H273)","v":0},{"$f":"IF(I273=\"\",0,I273)","v":0},"N/A",0]
[null,"HLP to Pond to Pond Piping",{"$f":"C301","v":0},{"$f":"D301","v":0},{"$f":"E301","v":0},0]
[null,"Fencing",{"$f":"F316","v":0},{"$f":"G316","v":0},{"$f":"H316","v":0},0]
[null,"Growth Media",{"$f":"H333","v":""},{"$f":"I333","v":""},"N/A",0]
[null,"Subtotal",{"$f":"SUM(C385:C398)","v":0},{"$f":"SUM(D385:D398)","v":0},{"$f":"SUM(E385:E398)","v":0},0]
[null,"Revegetation Costs",{"$f":"L333","v":0},{"$f":"M333","v":0},{"$f":"N333","v":0},0,{"$f":"(D36*E36/43560)","v":{"$error":"#VALUE!"}}]
[null,"TOTALS",{"$f":"C399+C400","v":0},{"$f":"D399+D400","v":0},{"$f":"E399+E400","v":0},0,{"$f":"IF(B36=\"\",\"\",F401/(D36*E36/43560))","v":""}]
[]
[]
[{"$f":"B37","v":""},null,"Individual Pond Cost Summary"]
[null,null,"Labor","Equipment","Materials","Totals"]
[null,"Sludge Removal and Disposal","N/A",{"$f":"G128","v":0},"N/A",{"$f":"SUM(C406:E406)","v":0}]
[null,"Existing Liner Inspect and Repair",{"$f":"E143","v":0},{"$f":"F143","v":0},{"$f":"G143","v":0},0]
[null,"New Pond Excavation",{"$f":"L159","v":0},{"$f":"M159","v":0},"N/A",0]
[null,"Primary Liner Installation",{"$f":"E174","v":0},{"$f":"F174","v":0},{"$f":"G174","v":0},0]
[null,"Geonetting",{"$f":"E189","v":0},{"$f":"F189","v":0},{"$f":"G189","v":0},0]
[null,"Secondary Liner Installation",{"$f":"E204","v":0},{"$f":"F204","v":0},{"$f":"G204","v":0},0]
[null,"Liner Key Trenching",{"$f":"F218","v":0},{"$f":"G218","v":0},"N/A",0]
[null,"Dosing Tank",{"$f":"F232","v":0},{"$f":"G232","v":0},{"$f":"H232","v":0},0]
[null,"Piping Manifold",{"$f":"F246","v":0},{"$f":"G245","v":0},{"$f":"H245","v":0},0]
[null,"Screening for Backfill",{"$f":"IF(G260=\"\",0,G260)","v":0},{"$f":"IF(H260=\"\",0,H260)","v":0},"N/A",0]
[null,"Pond Backfill",{"$f":"IF(H274=\"\",0,H274)","v":0},{"$f":"IF(I274=\"\",0,I274)","v":0},"N/A",0]
[null,"HLP to Pond to Pond Piping",{"$f":"C302","v":0},{"$f":"D302","v":0},{"$f":"E302","v":0},0]
[null,"Fencing",{"$f":"F317","v":0},{"$f":"G317","v":0},{"$f":"H317","v":0},0]
[null,"Growth Media",{"$f":"H334","v":""},{"$f":"I334","v":""},"N/A",0]
[null,"Subtotal",{"$f":"SUM(C406:C419)","v":0},{"$f":"SUM(D406:D419)","v":0},{"$f":"SUM(E406:E419)","v":0},0]
[null,"Revegetation Costs",{"$f":"L334","v":0},{"$f":"M334","v":0},{"$f":"N334","v":0},0,{"$f":"(D37*E37/43560)","v":{"$error":"#VALUE!"}}]
[null,"TOTALS",{"$f":"C420+C421","v":0},{"$f":"D420+D421","v":0},{"$f":"E420+E421","v":0},0,{"$f":"IF(B37=\"\",\"\",F422/(D37*E37/43560))","v":""}]
[]
[{"$f":"B38","v":""},null,"Individual Pond Cost Summary"]
[null,null,"Labor","Equipment","Materials","Totals"]
[null,"Sludge Removal and Disposal","N/A",{"$f":"G129","v":0},"N/A",{"$f":"SUM(C426:E426)","v":0}]
[null,"Existing Liner Inspect and Repair",{"$f":"E144","v":0},{"$f":"F144","v":0},{"$f":"G144","v":0},0]
[null,"New Pond Excavation",{"$f":"L160","v":0},{"$f":"M160","v":0},"N/A",0]
[null,"Primary Liner Installation",{"$f":"E175","v":0},{"$f":"F175","v":0},{"$f":"G175","v":0},0]
[null,"Geonetting",{"$f":"E190","v":0},{"$f":"F190","v":0},{"$f":"G190","v":0},0]
[null,"Secondary Liner Installation",{"$f":"E205","v":0},{"$f":"F205","v":0},{"$f":"G205","v":0},0]
[null,"Liner Key Trenching",{"$f":"F219","v":0},{"$f":"G219","v":0},"N/A",0]
[null,"Dosing Tank",{"$f":"F233","v":0},{"$f":"G233","v":0},{"$f":"H233","v":0},0]
[null,"Piping Manifold",{"$f":"F247","v":0},{"$f":"G247","v":0},{"$f":"H247","v":0},0]
[null,"Screening for Backfill",{"$f":"IF(G261=\"\",0,G261)","v":0},{"$f":"IF(H261=\"\",0,H261)","v":0},"N/A",0]
[null,"Pond Backfill",{"$f":"IF(H275=\"\",0,H275)","v":0},{"$f":"IF(I275=\"\",0,I275)","v":0},"N/A",0]
[null,"HLP to Pond to Pond Piping",{"$f":"C303","v":0},{"$f":"D303","v":0},{"$f":"E303","v":0},0]
[null,"Fencing",{"$f":"F318","v":0},{"$f":"G318","v":0},{"$f":"H318","v":0},0]
[null,"Growth Media",{"$f":"H335","v":""},{"$f":"I335","v":""},"N/A",0]
[null,"Subtotal",{"$f":"SUM(C426:C439)","v":0},{"$f":"SUM(D426:D439)","v":0},{"$f":"SUM(E426:E439)","v":0},0]
[null,"Revegetation Costs",{"$f":"L335","v":0},{"$f":"M335","v":0},{"$f":"N335","v":0},0,{"$f":"(D38*E38/43560)","v":{"$error":"#VALUE!"}}]
[null,"TOTALS",{"$f":"C440+C441","v":0},{"$f":"D440+D441","v":0},{"$f":"E440+E441","v":0},0,{"$f":"IF(B38=\"\",\"\",F442/(D38*E38/43560))","v":""}]
[]
[{"$f":"B39","v":""},null,"Individual Pond Cost Summary"]
[null,null,"Labor","Equipment","Materials","Totals"]
[null,"Sludge Removal and Disposal","N/A",{"$f":"G130","v":0},"N/A",{"$f":"SUM(C446:E446)","v":0}]
[null,"Existing Liner Inspect and Repair",{"$f":"E145","v":0},{"$f":"F145","v":0},{"$f":"G145","v":0},0]
[null,"New Pond Excavation",{"$f":"L161","v":0},{"$f":"M161","v":0},"N/A",0]
[null,"Primary Liner Installation",{"$f":"E176","v":0},{"$f":"F176","v":0},{"$f":"G176","v":0},0]
[null,"Geonetting",{"$f":"E191","v":0},{"$f":"F191","v":0},{"$f":"G191","v":0},0]
[null,"Secondary Liner Installation",{"$f":"E206","v":0},{"$f":"F206","v":0},{"$f":"G206","v":0},0]
[null,"Liner Key Trenching",{"$f":"F220","v":0},{"$f":"G220","v":0},"N/A",0]
[null,"Dosing Tank",{"$f":"F234","v":0},{"$f":"G234","v":0},{"$f":"H234","v":0},0]
[null,"Piping Manifold",{"$f":"F248","v":0},{"$f":"G248","v":0},{"$f":"H248","v":0},0]
[null,"Screening for Backfill",{"$f":"IF(G262=\"\",0,G262)","v":0},{"$f":"IF(H262=\"\",0,H262)","v":0},"N/A",0]
[null,"Pond Backfill",{"$f":"IF(H276=\"\",0,H276)","v":0},{"$f":"IF(I276=\"\",0,I276)","v":0},"N/A",0]
[null,"HLP to Pond to Pond Piping",{"$f":"C304","v":0},{"$f":"D304","v":0},{"$f":"E304","v":0},0]
[null,"Fencing",{"$f":"F319","v":0},{"$f":"G319","v":0},{"$f":"H319","v":0},0]
[null,"Growth Media",{"$f":"H336","v":""},{"$f":"I336","v":""},"N/A",0]
[null,"Subtotal",{"$f":"SUM(C446:C459)","v":0},{"$f":"SUM(D446:D459)","v":0},{"$f":"SUM(E446:E459)","v":0},0]
[null,"Revegetation Costs",{"$f":"L336","v":0},{"$f":"M336","v":0},{"$f":"N336","v":0},0,{"$f":"(D39*E39/43560)","v":{"$error":"#VALUE!"}}]
[null,"TOTALS",{"$f":"C460+C461","v":0},{"$f":"D460+D461","v":0},{"$f":"E460+E461","v":0},0,{"$f":"IF(B39=\"\",\"\",F462/(D39*E39/43560))","v":""}]
[]
[]
[]
[null,"Small Truck"]
["769D Haul Truck Travel Time - Uphill Empty"]
["Total Resistance (%)\n(rolling + grade)","Time (min)"]
[null,0.4,1,2,3,4,5,"k","p"]
[0,1427,3870,null,null,null,null,3870,1.0888]
[4,1246,3444,7183,null,null,null,3400.1,1.0894999999999999]
[6,1017,2755,5740,null,null,null,2734.5,1.0759000000000001]
[8,820,2230,4592,6954,null,null,2191.3000000000002,1.0613999999999999]
[10,722,1870,3870,5838,null,null,1872,1.0390999999999999]
[15,459,1246,2558,3903,5248,6560,1222.9000000000001,1.0523]
[]
["769D Haul Truck Travel Time - Uphill Loaded"]
["Total Resistance (%)\n(rolling + grade)","Time (min)"]
[null,0.4,1,2,3,4,5,"k","p"]
[0,1148,3428,7183,null,null,null,3316.3,1.1422000000000001]
[2,951,2821,5904,null,null,null,2733,1.1372]
[4,689,1984,4198,6330,null,null,1928.3,1.1032999999999999]
[6,508,1427,2952,4510,6002,null,1386.4,1.0725]
[8,394,1082,2263,3411,4592,5740,1061.8,1.06]
[10,328,869,1771,2690,3608,4510,857.82,1.0373000000000001]
[15,213,574,1181,1804,2394,3018,565,1.0482]
[]
[]
[null,"Large Truck"]
["777D Haul Truck Travel Time - Uphill Empty"]
["Total Resistance (%)\n(rolling + grade)","Time (min)"]
[null,0.4,1,2,3,4,5,"k","p"]
[0,968,3034,6560,null,null,null,2929.3,1.1919999999999999]
[4,754,2657,6068,null,null,null,2532.8000000000002,1.2999000000000001]
[6,656,2247,5182,null,null,null,2167.3000000000002,1.2873000000000001]
[8,607,1935,4248,6560,null,null,1846.2,1.1831]
[10,525,1607,3378,5215,7282,null,1528.4,1.1332]
[15,410,1197,2460,3706,4986,6232,1139.7,1.0720000000000001]
[]
["777D Haul Truck Travel Time - Uphill Loaded"]
["Total Resistance (%)\n(rolling + grade)","Time (min)"]
[null,0.4,1,2,3,4,5,"k","p"]
[0,656,2558,6068,null,null,null,2403.1,1.3875999999999999]
[4,459,1509,3313,5215,7085,null,1412,1.1862999999999999]
[6,394,1148,2460,3706,5018,6298,1111,1.0949]
[8,null,918,1886,2837,3772,4756,922.57,1.0197000000000001]
[10,null,722,1443,2165,2919,3608,721.44,1.0026999999999999]
[15,null,525,1017,1558,2034,2591,520.55999999999995,0.99050000000000005]
[]
[]
[]
[]
[null,"Downhill Haul Truck Speed - Grade Retarding vs. Effective Grade (Grade - Rolling Resistance)"]
[null,null,"769D",null,null,null,null,"777D"]
[null,"Material","Loaded Weight (lbs)",20,15,10,5,"Loaded Weight (lbs)",20,15,10,5]
[null,"Basalt",158651,11,11,11,20,368803,7,7,12,21]
[null,"Tailings - Slimes (loose sand & clay)",149006,11,11,15,26,327263,7,9,12,29]
[null,"Alluvium",147991,11,11,15,26,342083,7,9,12,29]
[null,"Granite - broken",145326,11,11,15,26,335403,7,9,12,29]
[null,"Stone - crushed",142661,11,11,15,26,328723,7,9,12,29]
[null,"Tailings - Coarse (dry, loose sand)",140306,11,11,15,26,318563,7,9,16,29]
[null,"LS - broken",139996,11,11,15,26,322043,7,9,12,29]
[null,"LS - crushed",139996,11,11,15,26,322043,7,9,12,29]
[null,"Gravel",138663.5,11,11,15,26,318703,7,9,16,29]
[null,"Sandstone",138663.5,11,11,15,26,318703,7,9,16,29]
[null,"Clay - Dry",137331,11,11,15,26,315363,7,9,16,29]
[null,"Shale",126671,11,11,15,26,288643,7,9,16,29]
[null,"Topsoil",113346,11,11,15,26,255243,9,12,16,29]
[]
[]
[null,null,"Empty",15,15,26,36,"Empty",16,16,29,39]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Source: Caterpillar Performance Handbook Edition 35  "]
[]
[]
[]
[null,"Screened Material Truck Time Calculations"]
[]
[]
[]
[null,"Haul Distance","abs slope","DH Slope","UH slope","DHE","DHL","UHE","UHL","Travel Time","Man Load","Load","Man Dump","Cycle Time","# Trucks","Truck Prod","Fleet Prod","Hrs"]
[null,{"$f":"E58","v":0},{"$f":"ABS(F58)","v":0},{"$f":"ABS(C542)-0.025","v":-2.5000000000000001E-2},{"$f":"ABS(C542)+0.025","v":2.5000000000000001E-2},{"$f":"ROUND(IF(D542=0,B554,IF(D542<0.0500001,C554,IF(D542<0.100000001,D554,IF(D542<0.15000001,E554,IF(D542<0.2,F554,IF(D542=0.2,F554,\"\")))))),2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((IF(D542=0,P554,IF(D542<0.0500001,Q554,IF(D542<0.1000001,R554,IF(D542<0.15000001,S554,IF(D542<0.2,T554,IF(D542=0.2,T554,\"\"))))))),2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(IF(E542=0,V554,IF(E542<0.04,V554,IF(E542<0.06,W554,IF(E542<0.08,X554,IF(E542<0.1,Y554,IF(E542<0.15,Z554,IF(E542=0.15,AA554,IF(E542>0.15,AA554,\"\")))))))),2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(IF(E542=0,H554,IF(E542<0.02,H554,IF(E542<0.04,I554,IF(E542<0.06,J554,IF(E542<0.08,K554,IF(E542<0.1,L554,IF(E542<0.15,M554,IF(E542=0.15,N554,IF(E542>0.15,N554,\"\"))))))))),2)","v":{"$error":"#VALUE!"}},{"$f":"IF(F58>0,(H542+G542),(I542+F542))","v":{"$error":"#VALUE!"}},{"$f":"IF(D271=\"769D 988G D7R\", C$613,IF(D271=\"777D 992G D7R\",D$613,\"Select Fleet\"))","v":"Select Fleet"},{"$f":"IF(D271=\"769D 988G D7R\", D$594*D$595,IF(D271=\"777D 992G D7R\",E$594*E$595,\"Select Fleet\"))","v":"Select Fleet"},{"$f":"IF(D271=\"769D 988G D7R\", C$614,IF(D271=\"777D 992G D7R\",D$614,\"Select Fleet\"))","v":"Select Fleet"},{"$f":"K542+L542+M542+J542","v":{"$error":"#VALUE!"}},{"$f":"IF(H58=0,ROUNDUP((N542-L542)/L542,0),H58)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(((IF(D271=\"769D 988G D7R\",26.65,IF(D271=\"777D 992G D7R\",66.8,\"Select Fleet\"))*60)/N542),0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(P542*O542*0.83,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ROUND(C271/Q542,0)<1,1,ROUND(C271/Q542,0))","v":{"$error":"#VALUE!"}}]
[null,0,0,{"$f":"ABS(C543)-0.025","v":-2.5000000000000001E-2},{"$f":"ABS(C543)+0.025","v":2.5000000000000001E-2},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"Select Fleet","Select Fleet","Select Fleet",{"$f":"K543+L543+M543+J543","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND(P543*O543*0.83,0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,0,0,-2.5000000000000001E-2,2.5000000000000001E-2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"Select Fleet","Select Fleet","Select Fleet",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0,0,-2.5000000000000001E-2,2.5000000000000001E-2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"Select Fleet","Select Fleet","Select Fleet",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0,0,-2.5000000000000001E-2,2.5000000000000001E-2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"Select Fleet","Select Fleet","Select Fleet",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0,0,-2.5000000000000001E-2,2.5000000000000001E-2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"Select Fleet","Select Fleet","Select Fleet",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"Screened Material Truck Speed Table"]
[]
[null,"Downhill Empty (-2.5%)",null,null,null,null,null,"Uphill Loaded (+2.5%) ",null,null,null,null,null,null,null,"Down Hill Loaded (-2.5%) Based on Gravel",null,null,null,null,null,"Uphill Empty (+2.5%)"]
[null,0,0.05,0.1,0.15,0.2,null,0,0.02,0.04,0.06,0.08,0.1,0.15,null,0,0.05,0.1,0.15,0.2,null,0,0.04,0.06,0.08,0.1,0.15]
[]
[null,{"$f":"60*B542/5280/IF(D271=\"769D 988G D7R\",G$531,IF(D271=\"777D 992G D7R\",L$531,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},{"$f":"60*B542/5280/IF(D271=\"769D 988G D7R\",G$531,IF(D271=\"777D 992G D7R\",L$531,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},{"$f":"60*B542/5280/IF(D271=\"769D 988G D7R\",F$531,IF(D271=\"777D 992G D7R\",K$531,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},{"$f":"60*B542/5280/IF(D271=\"769D 988G D7R\",E$531,IF(D271=\"777D 992G D7R\",J$531,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},{"$f":"60*B542/5280/IF(D271=\"769D 988G D7R\",D$531,IF(D271=\"777D 992G D7R\",I$531,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},null,{"$f":"(B542/IF(D271=\"769D 988G D7R\",$H$480,IF(D271=\"777D 992G D7R\",$H$503,\"Select Fleet\")))^(1/IF(D271=\"769D 988G D7R\",$I$480,IF(D271=\"777D 992G D7R\",$I$503,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B542/IF(D271=\"769D 988G D7R\",$H$481,IF(D271=\"777D 992G D7R\",$H$503,\"Select Fleet\")))^(1/IF(D271=\"769D 988G D7R\",$I$481,IF(D271=\"777D 992G D7R\",$I$503,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B542/IF(D271=\"769D 988G D7R\",$H$482,IF(D271=\"777D 992G D7R\",$H$504,\"Select Fleet\")))^(1/IF(D271=\"769D 988G D7R\",$I$482,IF(D271=\"777D 992G D7R\",$I$504,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B542/IF(D271=\"769D 988G D7R\",$H$483,IF(D271=\"777D 992G D7R\",$H$505,\"Select Fleet\")))^(1/IF(D271=\"769D 988G D7R\",$I$483,IF(D271=\"777D 992G D7R\",$I$505,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B542/IF(D271=\"769D 988G D7R\",$H$484,IF(D271=\"777D 992G D7R\",$H$506,\"Select Fleet\")))^(1/IF(D271=\"769D 988G D7R\",$I$484,IF(D271=\"777D 992G D7R\",$I$506,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B542/IF(D271=\"769D 988G D7R\",$H$485,IF(D271=\"777D 992G D7R\",$H$507,\"Select Fleet\")))^(1/IF(D271=\"769D 988G D7R\",$I$485,IF(D271=\"777D 992G D7R\",$I$507,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B542/IF(D271=\"769D 988G D7R\",$H$486,IF(D271=\"777D 992G D7R\",$H$508,\"Select Fleet\")))^(1/IF(D271=\"769D 988G D7R\",$I$486,IF(D271=\"777D 992G D7R\",$I$508,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},null,{"$f":"60*B542/5280/IF(D271=\"769D 988G D7R\",G$524,IF(D271=\"777D 992G D7R\",L$524,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},{"$f":"60*B542/5280/IF(D271=\"769D 988G D7R\",G$524,IF(D271=\"777D 992G D7R\",L$524,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},{"$f":"60*B542/5280/IF(D271=\"769D 988G D7R\",F$524,IF(D271=\"777D 992G D7R\",K$524,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},{"$f":"60*B542/5280/IF(D271=\"769D 988G D7R\",E$524,IF(D271=\"777D 992G D7R\",J$524,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},{"$f":"60*B542/5280/IF(D271=\"769D 988G D7R\",D$524,IF(D271=\"777D 992G D7R\",I$524,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},null,{"$f":"(B542/IF(D271=\"769D 988G D7R\",$H$470,IF(D271=\"777D 992G D7R\",$H$493,\"Select Fleet\")))^(1/IF(D271=\"769D 988G D7R\",$I$470,IF(D271=\"777D 992G D7R\",$I$493,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B542/IF(D271=\"769D 988G D7R\",$H$471,IF(D271=\"777D 992G D7R\",$H$494,\"Select Fleet\")))^(1/IF(D271=\"769D 988G D7R\",$I$471,IF(D271=\"777D 992G D7R\",$I$494,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B542/IF(D271=\"769D 988G D7R\",$H$472,IF(D271=\"777D 992G D7R\",$H$495,\"Select Fleet\")))^(1/IF(D271=\"769D 988G D7R\",$I$472,IF(D271=\"777D 992G D7R\",$I$495,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B542/IF(D271=\"769D 988G D7R\",$H$473,IF(D271=\"777D 992G D7R\",$H$496,\"Select Fleet\")))^(1/IF(D271=\"769D 988G D7R\",$I$473,IF(D271=\"777D 992G D7R\",$I$496,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B542/IF(D271=\"769D 988G D7R\",$H$474,IF(D271=\"777D 992G D7R\",$H$497,\"Select Fleet\")))^(1/IF(D271=\"769D 988G D7R\",$I$474,IF(D271=\"777D 992G D7R\",$I$497,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B542/IF(D271=\"769D 988G D7R\",$H$475,IF(D271=\"777D 992G D7R\",$H$498,\"Select Fleet\")))^(1/IF(D271=\"769D 988G D7R\",$I$475,IF(D271=\"777D 992G D7R\",$I$498,\"Select Fleet\")))","v":{"$error":"#VALUE!"}}]
[null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
[null,"Growth Media Truck Time Calculations"]
[]
[]
[]
[null,"Haul Distance","abs slope","DH Slope","UH slope","DHE","DHL","UHE","UHL","Travel Time","Man Load","Load","Man Dump","Cycle Time","# Trucks","Truck Prod","Fleet Prod","Hrs"]
[null,{"$f":"E80","v":0},{"$f":"ABS(F80)","v":0},{"$f":"ABS(C567)-0.025","v":-2.5000000000000001E-2},{"$f":"ABS(C567)+0.025","v":2.5000000000000001E-2},{"$f":"ROUND(IF(D567=0,B579,IF(D567<0.0500001,C579,IF(D567<0.100000001,D579,IF(D567<0.15000001,E579,IF(D567<0.2,F579,IF(D567=0.2,F579,\"\")))))),2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((IF(D567=0,P579,IF(D567<0.0500001,Q579,IF(D567<0.1000001,R579,IF(D567<0.15000001,S579,IF(D567<0.2,T579,IF(D567=0.2,T579,\"\"))))))),2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(IF(E567=0,V579,IF(E567<0.04,V579,IF(E567<0.06,W579,IF(E567<0.08,X579,IF(E567<0.1,Y579,IF(E567<0.15,Z579,IF(E567=0.15,AA579,IF(E567>0.15,AA579,\"\")))))))),2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(IF(E567=0,H579,IF(E567<0.02,H579,IF(E567<0.04,I579,IF(E567<0.06,J579,IF(E567<0.08,K579,IF(E567<0.1,L579,IF(E567<0.15,M579,IF(E567=0.15,N579,IF(E567>0.15,N579,\"\"))))))))),2)","v":{"$error":"#VALUE!"}},{"$f":"IF(F101>0,(H567+G567),(I567+F567))","v":{"$error":"#VALUE!"}},{"$f":"IF(D331=\"769D 988G D7R\",C$613,IF(D331=\"777D 992G D7R\",D$613,\"Select Fleet\"))","v":"Select Fleet"},{"$f":"IF(D331=\"769D 988G D7R\", D$594*D$595,IF(D331=\"777D 992G D7R\",E$594*E$595,\"Select Fleet\"))","v":"Select Fleet"},{"$f":"IF(D331=\"769D 988G D7R\", C$614,IF(D331=\"777D 992G D7R\",D$614,\"Select Fleet\"))","v":"Select Fleet"},{"$f":"K567+L567+M567+J567","v":{"$error":"#VALUE!"}},{"$f":"IF(I80=0,ROUNDUP((N567-L567)/L567,0),I80)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(((IF(D331=\"769D 988G D7R\",26.65,IF(D331=\"777D 992G D7R\",66.8,\"Select Fleet\"))*60)/N567),0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(P567*O567*0.83,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(ROUND(C331/Q567,0)<1,1,ROUND(C331/Q567,0))","v":{"$error":"#VALUE!"}}]
[null,0,0,{"$f":"ABS(C568)-0.025","v":-2.5000000000000001E-2},{"$f":"ABS(C568)+0.025","v":2.5000000000000001E-2},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"Select Fleet","Select Fleet","Select Fleet",{"$f":"K568+L568+M568+J568","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"ROUND(P568*O568*0.83,0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,0,0,-2.5000000000000001E-2,2.5000000000000001E-2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"Select Fleet","Select Fleet","Select Fleet",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0,0,-2.5000000000000001E-2,2.5000000000000001E-2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"Select Fleet","Select Fleet","Select Fleet",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0,0,-2.5000000000000001E-2,2.5000000000000001E-2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"Select Fleet","Select Fleet","Select Fleet",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0,0,-2.5000000000000001E-2,2.5000000000000001E-2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"Select Fleet","Select Fleet","Select Fleet",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[null,"Growth Media Truck Speed Table"]
[]
[null,"Downhill Empty (-2.5%)",null,null,null,null,null,"Uphill Loaded (+2.5%) ",null,null,null,null,null,null,null,"Down Hill Loaded (-2.5%) Based on Gravel",null,null,null,null,null,"Uphill Empty (+2.5%)"]
[null,0,0.05,0.1,0.15,0.2,null,0,0.02,0.04,0.06,0.08,0.1,0.15,null,0,0.05,0.1,0.15,0.2,null,0,0.04,0.06,0.08,0.1,0.15]
[]
[null,{"$f":"60*B567/5280/IF(D331=\"769D 988G D7R\",G$531,IF(D331=\"777D 992G D7R\",L$531,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},{"$f":"60*B567/5280/IF(D331=\"769D 988G D7R\",G$531,IF(D331=\"777D 992G D7R\",L$531,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},{"$f":"60*B567/5280/IF(D331=\"769D 988G D7R\",F$531,IF(D331=\"777D 992G D7R\",K$531,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},{"$f":"60*B567/5280/IF(D331=\"769D 988G D7R\",E$531,IF(D331=\"777D 992G D7R\",J$531,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},{"$f":"60*B567/5280/IF(D331=\"769D 988G D7R\",D$531,IF(D331=\"777D 992G D7R\",I$531,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},null,{"$f":"(B567/IF(D331=\"769D 988G D7R\",$H$480,IF(D331=\"777D 992G D7R\",$H$503,\"Select Fleet\")))^(1/IF(D331=\"769D 988G D7R\",$I$480,IF(D331=\"777D 992G D7R\",$I$503,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B567/IF(D331=\"769D 988G D7R\",$H$481,IF(D331=\"777D 992G D7R\",$H$503,\"Select Fleet\")))^(1/IF(D331=\"769D 988G D7R\",$I$481,IF(D331=\"777D 992G D7R\",$I$503,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B567/IF(D331=\"769D 988G D7R\",$H$482,IF(D331=\"777D 992G D7R\",$H$504,\"Select Fleet\")))^(1/IF(D331=\"769D 988G D7R\",$I$482,IF(D331=\"777D 992G D7R\",$I$504,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B567/IF(D331=\"769D 988G D7R\",$H$483,IF(D331=\"777D 992G D7R\",$H$505,\"Select Fleet\")))^(1/IF(D331=\"769D 988G D7R\",$I$483,IF(D331=\"777D 992G D7R\",$I$505,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B567/IF(D331=\"769D 988G D7R\",$H$484,IF(D331=\"777D 992G D7R\",$H$506,\"Select Fleet\")))^(1/IF(D331=\"769D 988G D7R\",$I$484,IF(D331=\"777D 992G D7R\",$I$506,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B567/IF(D331=\"769D 988G D7R\",$H$485,IF(D331=\"777D 992G D7R\",$H$507,\"Select Fleet\")))^(1/IF(D331=\"769D 988G D7R\",$I$485,IF(D331=\"777D 992G D7R\",$I$507,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B567/IF(D331=\"769D 988G D7R\",$H$486,IF(D331=\"777D 992G D7R\",$H$508,\"Select Fleet\")))^(1/IF(D331=\"769D 988G D7R\",$I$486,IF(D331=\"777D 992G D7R\",$I$508,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},null,{"$f":"60*B567/5280/IF(D331=\"769D 988G D7R\",G$524,IF(D331=\"777D 992G D7R\",L$524,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},{"$f":"60*B567/5280/IF(D331=\"769D 988G D7R\",G$524,IF(D331=\"777D 992G D7R\",L$524,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},{"$f":"60*B567/5280/IF(D331=\"769D 988G D7R\",F$524,IF(D331=\"777D 992G D7R\",K$524,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},{"$f":"60*B567/5280/IF(D331=\"769D 988G D7R\",E$524,IF(D331=\"777D 992G D7R\",J$524,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},{"$f":"60*B567/5280/IF(D331=\"769D 988G D7R\",D$524,IF(D331=\"777D 992G D7R\",I$524,\"Select Fleet\"))","v":{"$error":"#VALUE!"}},null,{"$f":"(B567/IF(D331=\"769D 988G D7R\",$H$470,IF(D331=\"777D 992G D7R\",$H$493,\"Select Fleet\")))^(1/IF(D331=\"769D 988G D7R\",$I$470,IF(D331=\"777D 992G D7R\",$I$493,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B567/IF(D331=\"769D 988G D7R\",$H$471,IF(D331=\"777D 992G D7R\",$H$494,\"Select Fleet\")))^(1/IF(D331=\"769D 988G D7R\",$I$471,IF(D331=\"777D 992G D7R\",$I$494,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B567/IF(D331=\"769D 988G D7R\",$H$472,IF(D331=\"777D 992G D7R\",$H$495,\"Select Fleet\")))^(1/IF(D331=\"769D 988G D7R\",$I$472,IF(D331=\"777D 992G D7R\",$I$495,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B567/IF(D331=\"769D 988G D7R\",$H$473,IF(D331=\"777D 992G D7R\",$H$496,\"Select Fleet\")))^(1/IF(D331=\"769D 988G D7R\",$I$473,IF(D331=\"777D 992G D7R\",$I$496,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B567/IF(D331=\"769D 988G D7R\",$H$474,IF(D331=\"777D 992G D7R\",$H$497,\"Select Fleet\")))^(1/IF(D331=\"769D 988G D7R\",$I$474,IF(D331=\"777D 992G D7R\",$I$497,\"Select Fleet\")))","v":{"$error":"#VALUE!"}},{"$f":"(B567/IF(D331=\"769D 988G D7R\",$H$475,IF(D331=\"777D 992G D7R\",$H$498,\"Select Fleet\")))^(1/IF(D331=\"769D 988G D7R\",$I$475,IF(D331=\"777D 992G D7R\",$I$498,\"Select Fleet\")))","v":{"$error":"#VALUE!"}}]
[null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
[null,"Wheel Loader Specifications"]
[null,"Description","966G","988G","992G"]
[null,"Payload Capacity"]
[null,"Struck",4.46,6.9,13.2]
[null,"Heaped",5.25,8.33,16]
[null,"Average",4.8550000000000004,{"$f":"D590+(D591-D590)/2","v":7.6150000000000002},{"$f":"E590+(E591-E590)/2","v":14.6}]
[null,"Matched Truck","725D","769D","777D"]
[null,"Average Cycle Time",0.5,0.55000000000000004,0.6]
[null,"Passes to Fill Truck",3,4.162836506894287,5.3835616438356162]
[null,"Time to Fill Truck",1.5,2.2895600787918582,3.2301369863013698]
[null,"Rolling Resistance**",2.5,2.5,2.5]
[]
[]
[]
[]
[null,"Haul Truck Specifications",null,null,null,"Weight of Materials"]
[null,"Description","769D","777D"]
[null,"Chassis Weight",53506,111575,null,"Material","lb/cy","Truck (769D) Load lb","Loaded Weight (lbs)","Truck (777D) Load lb","Loaded Weight (lbs)"]
[null,"Body Weight",17200,36788,null,"Basalt",3300,87945,{"$f":"H605+70706","v":158651},220440,{"$f":"J605+148363","v":368803}]
[null,"Standard Liner Weight",null,null,null,"Alluvium",2900,77285,147991,193720,342083]
[null,"Total Truck Weight",70706,148363,null,"Granite - broken",2800,74620,145326,187040,335403]
[null,"Payload Capacity",null,null,null,"Stone - crushed",2700,71955,142661,180360,328723]
[null,"Struck",21.6,55,null,"Tailings - Slimes (loose sand & clay)",2700,78300,149006,178900,327263]
[null,"Heaped",31.7,78.599999999999994,null,"LS - broken",2600,69290,139996,173680,322043]
[null,"Average",{"$f":"C609+(C610-C609)/2","v":26.65},{"$f":"D609+(D610-D609)/2","v":66.8},null,"LS - crushed",2600,69290,139996,173680,322043]
[null,"Top Speed (Loaded)",48,39.9,null,"Gravel",2550,67957.5,138663.5,170340,318703]
[null,"Maneuver to Load Time",0.7,0.7,null,"Sandstone",2550,67957.5,138663.5,170340,318703]
[null,"Maneuver and Dump Time",1.1000000000000001,1.1000000000000001,null,"Clay - Dry",2500,66625,137331,167000,315363]
[null,"Job Efficiency",{"$f":"50/60","v":0.83333333333333337},{"$f":"50/60","v":0.83333333333333337},null,"Tailings - Coarse (dry, loose sand)",2400,69600,140306,170200,318563]
[null,"Rolling Resistance**",2.5,2.5,null,"Shale",2100,55965,126671,140280,288643]
[null,null,null,null,null,"Topsoil",1600,42640,113346,106880,255243]
[]
[null,"**A firm, smooth, rolling roadway with dirt or light surfacing, flexing slightly under load or undulating, maintained fairly regularly, watered"]
[]
[null,null,null,"Source: Caterpillar Performance Handbook Edition 35  "]
[]
[null,"Material Correction Factors",null,null,"Material Correction",null,null,"Bulldozer Productivity Factors Table"]
[]
[null,"Normal",1,null,1,null,null,null,"D6R","D7R","D8R","D9R","D10R","D11R"]
[null,"Loose Stock Pile",1.2,null,1.2]
[null,"Alluvium",0.79,null,0.79,null,null,"k",101029,22719,115087,89889,81639,185082]
[null,"Heap Crushed",0.85,null,0.85,null,null,"p",-1.1506000000000001,-0.77959999999999996,-1.0809,-0.9425,-0.85019999999999996,-0.91900000000000004]
[null,"Heap Pit Run",0.82,null,0.82]
[null,"Basalt",0.7,null,0.7,null,null,50,{"$f":"I$627*$H630^I$628","v":1121.0143379114111},1076.1484789060548,1677.2955380494534,2251.2686307273439,2933.8194179549546,5081.7202092065745]
[null,"Granite - broken",0.81989999999999996,null,0.82,null,null,100,504.94729996495875,626.88692457318007,792.91433477307567,1171.4035854829865,1627.4126084304783,2687.5972240637434]
[null,"Gravel",0.9,null,0.9,null,null,200,227.44738146431439,365.17936316771682,374.83742609830597,609.51693696325822,902.73851957958504,1421.4042767858182]
[null,"LS - broken",0.88,null,0.88,null,null,300,142.64952787546761,266.21068403931389,241.82762191512822,415.92954063155599,639.51271784989069,979.24136534984711]
[null,"Sandstone",0.89990000000000003,null,0.9,null,null,400,102.45091188439537,212.72730704085978,177.19833006199019,317.15021282941746,500.75612694108827,751.74587173077612]
[null,"Shale",1.1000000000000001,null,1.1000000000000001,null,null,500,79.252170887001839,178.76076155260409,139.22255244683708,256.99656576778506,414.22220739445623,612.36554910076154]
[null,"Stone - crushed",0.84989999999999999,null,0.85,null,null,600,64.254748138364889,155.07525241830189,114.32009661432454,216.42079872391079,354.7427131714947,517.89674890691288]
[null,"Topsoil",1.44,null,1.44]
[]
[]
[]
[]
[null,"Productivity = Dozer Productivity x Grade Correction x Density Correction x Operator (0.75) x Material x Visibility x Job Efficiency (0.83)",null,null,null,null,null,null,null,"New Pond",null,"Seed Mixes","Secondary Liners"]
[null,null,null,null,null,null,null,null,null,"Unlined","No",null,"80 mil HDPE"]
[null,"Grading assumed on impoundment surface only, not embankment",null,null,null,null,null,null,null,"Single Liner","Yes","Mix 1","60 mil HDPE "]
[null,"Average push distance assumed to be 2/3 of the 600 feet maximum from Caterpillar Handbook or 400 feet",null,null,null,null,null,null,null,"Double Liner",null,"Mix 2","60 mil HDPE Drain Liner "]
[null,"Material assumed to be loose stockpile (1.2 productivity factor)",null,null,null,null,null,null,null,"Select Fleet",null,"Mix 3","40 mil HDPE"]
[null,"Dozing density correction based on dry sand = 2300/2400 = 0.96",null,null,null,null,null,null,null,null,null,"Mix 4","40 mil LLDPE "]
[null,"Slope assumed to be 0 to 5% (1.0 productivity factor)",null,null,null,null,null,null,null,"Small Fleet",null,"User Mix 1","Primary Liners"]
[null,null,null,null,null,null,null,null,null,"Large Fleet",null,"User Mix 2","80 mil HDPE"]
[null,"Dozer Productivity Corrections",null,null,null,null,null,null,null,"Mulches","Fertilizer","User Mix 3","60 mil HDPE "]
[null,"Operator",0.75,null,null,null,null,null,null,null,null,"User Mix 4","40 mil HDPE"]
[null,"Material",1.2,null,null,null,null,null,null,"Straw Mulch","Organic ","User Mix 5","40 mil LLDPE "]
[null,"Job Efficiency",0.83,null,null,null,null,null,null,"Hydro Mulch","Chemical"]
[null,"Grade",1]
[null,"Density",0.96]
[null,"Total Factor",{"$f":"C651*C652*C653*C654*C655","v":0.71711999999999987}]
[]
[]
[null,"Backfill Fleet",null,"Growth Media Fleet",null,"Pond Ex Fleet",null,"Ripping Fleets",null,"Screening Fleet",null,"Dozers",null,"Fencing Condition"]
[null,"769D 988G D7R",null,null,null,null,null,"D7R Dozer",null,null,null,null,null,"No New Fence"]
[null,"777D 992G D7R",null,null,null,"D7R",null,"D9R Dozer",null,"966G",null,"D7R",null,"Poor >10 yrs"]
[null,"631G D10R D7R",null,"769D 988G D7R",null,"D9R",null,"D10R Dozer",null,"988G",null,"D9R",null,"Fair 5 yrs -10 yrs"]
[null,"637G D7R",null,"777D 992G D7R",null,"D10R",null,"16G/H Grader",null,"992G",null,"D10R",null,"New < 5 yrs"]
[]
[null,"Backfill Fleet",null,"Growth Media Fleet",null,"Pond Excavating Fleet",null,"Ripping/Scarifying Fleet",null,"Backfill Screening Fleet"]
[null,"Small Truck/Loader Fleet",null,"Small Truck/Loader Fleet",null,"Small Excavator + Dozer",null,"Small Dozer w/multi-shank",null,"Small Loader Fleet"]
[null,"769D","Truck ","769D","Truck ","325C","Excavator","D7R","Dozer","966G","Loader"]
[null,"988G","Loader","988G","Loader","D7R","Dozer",null,null,"D7R","Dozer"]
[null,"D7R","Dozer","D7R","Dozer"]
[null,"Large Truck/Loader Fleet",null,null,null,null,null,"Medium Dozer w/multi-shank",null,"Medium Loader Fleet"]
[null,"777D","Truck ","Large Truck/Loader Fleet",null,"Medium Excavator + Dozer",null,"D9R","Dozer","988G","Loader"]
[null,"992G","Loader","777D","Truck ","345B","Excavator",null,null,"D9R","Dozer"]
[null,"D7R","Dozer","992G","Loader","D9R","Dozer"]
[null,"Scraper/Dozer Fleet",null,"D7R","Dozer",null,null,"Large Dozer w/multi-shank",null,"Large Loader Fleet"]
[null,"631G","Scraper",null,null,null,null,"D10R","Dozer","992G","Loader"]
[null,"D10R","Dozer",null,null,"Large Excavator + Dozer",null,null,null,"D10R","Dozer"]
[null,"D7R","Dozer",null,null,"385BL","Excavator"]
[null,"Tandem Scraper Fleet",null,null,null,"D10R","Dozer","Grader w/multi-shank"]
[null,"637G PP","Scraper",null,null,null,null,"16G/H","Grader"]
[null,"D7R","Dozer"]
[]
[]
[]
[]
[null,"Sludge Removal Productivity"]
[null,"=SV/[({2*Dist/5280/7}*SV/24.76)+(0.75*SV/24.76)]"]
[null,"SV=Sludge Volume (cy)"]
[null,"Dist=Distance to Disposal Site (ft)"]
[null,"5000 gallon Vacuum Truck = 24.76 cy"]
[null,"Assume average speed of Vacuum Truck for trip=7 mph "]
[null,"SV/24.76 = Total Number of Round Trips to Clear the Sludge"]
[null,"Assume 0.75 hrs for total Load, Unload and Maneuver time per trip (hrs) "]
[]
[null,"Example:"]
[null,"Sludge Volume = 2573 cy"]
[null,"Disposal Distance = 2000 feet"]
[null,"Productivity = 29.1 cy/hr"]
[null,"Fleet Hours = 2573cy/29.1cy/hr = 88.4hr"]
[null,"Cost from “SRCE”, “Misc. Unit Cost” Tab,  Cell  “G78”, Vacuum Truck Pickup (5000 gal) =$157.00/hr "]
[null,"Sludge Removal Cost Total = $13,878"]
[]
[]
[]
[null,"Mobilization/Demobilization "]
[]
[null,"Pond Backfill","Truck","Loader","Dozer","Dozer","Excavator","Scraper","Grader","Backhoe",null,null,"Trucks"]
[null,{"$f":"IF(B34=\"\",\"\",G58)","v":""},{"$f":"IF(B707=\"\",\"\",IF(B707=B$660,\"769D\",IF(B707=B$661,\"777D\",IF(B707=B$662,\"\",IF(B707=B$663,\"\",\"FleetEntryError\")))))","v":""},{"$f":"IF(B707=\"\",\"\",IF(B707=B$660,\"988G\",IF(B707=B$661,\"992G\",IF(B707=B$662,\"\",IF(B707=B$663,\"\",\"FleetEntryError\")))))","v":""},{"$f":"IF(B707=\"\",\"\",IF(B707=B$660,\"D7R\",IF(B707=B$661,\"D7R\",IF(B707=B$662,\"D7R\",IF(B707=B$663,\"D7R\",\"FleetEntryError\")))))","v":""},{"$f":"IF(B707=\"\",\"\",IF(B707=B$660,\"\",IF(B707=B$661,\"\",IF(B707=B$662,\"D10R\",IF(B707=B$663,\"\",\"FleetEntryError\")))))","v":""},null,{"$f":"IF(B707=\"\",\"\",IF(B707=B$660,\"\",IF(B707=B$661,\"\",IF(B707=B$662,\"631G\",IF(B707=B$663,\"637G\",\"FleetEntryError\")))))","v":""},null,null,null,null,"769D",{"$f":"COUNTIF(C707:I738,\"769D\")","v":0}]
[null,"","","","","",null,"",null,null,null,null,"777D",{"$f":"COUNTIF(C707:I738,\"769D\")","v":0}]
[null,"","","","","",null,""]
[null,"","","","","",null,"",null,null,null,null,"Loaders"]
[null,"","","","","",null,"",null,null,null,null,"966G",{"$f":"COUNTIF(C706:I737,\"966G\")","v":0}]
[null,"","","","","",null,"",null,null,null,null,"988G",{"$f":"COUNTIF(C707:I738,\"988G\")","v":0}]
[null,"Backfill Screening Fleet",null,null,null,null,null,null,null,null,null,null,"992G",{"$f":"COUNTIF(C708:I738,\"992G\")","v":0}]
[null,{"$f":"IF(B34=\"\",\"\",K58)","v":""},null,{"$f":"IF(B714=\"\",\"\",IF(B714=J$661,\"966G\",IF(B714=J$662,\"988G\",IF(B714=J$663,\"992G\",\"FleetEntryError\"))))","v":""}]
[null,"",null,"",null,null,null,null,null,null,null,null,"Dozers"]
[null,"",null,"",null,null,null,null,null,null,null,null,"D7R",{"$f":"COUNTIF(C707:I738,\"D7R\")","v":0}]
[null,"",null,"",null,null,null,null,null,null,null,null,"D9R",{"$f":"COUNTIF(C707:I738,\"D9R\")","v":0}]
[null,"",null,"",null,null,null,null,null,null,null,null,"D10R",{"$f":"COUNTIF(C707:I738,\"D10R\")","v":0}]
[null,"",null,""]
[null,"Growth Media Fleet",null,null,null,null,null,null,null,null,null,null,"Excavators"]
[null,{"$f":"IF(B34=\"\",\"\",H80)","v":""},{"$f":"IF(B721=\"\",\"\",IF(B721=D$662,\"769D\",IF(B721=D$663,\"777D\",\"FleetEntryError\")))","v":""},{"$f":"IF(B721=\"\",\"\",IF(B721=D$662,\"988G\",IF(B721=D$663,\"992G\",\"FleetEntryError\")))","v":""},{"$f":"IF(B721=\"\",\"\",IF(B721=D$662,\"D7R\",IF(B721=D$663,\"D7R\",\"FleetEntryError\")))","v":""},null,null,null,null,null,null,null,"325C",{"$f":"COUNTIF(C707:I738,\"325C\")","v":0}]
[null,"","","","",null,null,null,null,null,null,null,"345B",{"$f":"COUNTIF(C707:I738,\"345B\")","v":0}]
[null,"","","","",null,null,null,null,null,null,null,"385BL",{"$f":"COUNTIF(C707:I738,\"385BL\")","v":0}]
[null,"","","",""]
[null,"","","","",null,null,null,null,null,null,null,"Scrapers"]
[null,"","","","",null,null,null,null,null,null,null,"631G",{"$f":"COUNTIF(C707:I738,\"631G\")","v":0}]
[null,"Pond Excavating Fleet",null,null,null,null,null,null,null,null,null,null,"637G",{"$f":"COUNTIF(C707:I738,\"637G\")","v":0}]
[null,{"$f":"IF(F102=\"New Pond\",N34,\"\")","v":""},null,null,{"$f":"IF(B728=\"\",\"\",IF(B728=F$661,\"D7R\",IF(B728=F$662,\"D9R\",IF(B728=F$663,\"D10R\",\"FleetEntryError\"))))","v":""}]
[null,"",null,null,""]
[null,"",null,null,"",null,null,null,null,null,null,null,"Graders"]
[null,"",null,null,"",null,null,null,null,null,null,null,"16G/H",{"$f":"COUNTIF(C704:J747,\"16G/H\")","v":0}]
[null,"",null,null,""]
[null,"",null,null,"",null,null,null,null,null,null,null,"Backhoes"]
[null,"Ripping/Scarifying Fleet",null,null,null,null,null,null,null,null,null,null,"420C",{"$f":"COUNTIF(C707:J747,\"420D\")","v":0}]
[null,{"$f":"IF(B34=\"\",\"\",O80)","v":""},null,null,{"$f":"IF(B735=\"\",\"\",IF(B735=H$660,\"D7R\",IF(B735=H$661,\"D9R\",IF(B735=H$662,\"D10R\",IF(B735=H$663,\"\",\"FleetEntryError\")))))","v":""},null,null,null,{"$f":"IF(B735=\"\",\"\",IF(B735=H$660,\"\",IF(B735=H$661,\"\",IF(B735=H$662,\"\",IF(B735=H$663,\"16G/H\",\"FleetEntryError\")))))","v":""},{"$f":"IF(C735=\"\",\"\",IF(C735=\"Small Dozer\",\"\",IF(C735=\"Med Dozer\",\"\",IF(C735=\"Large Dozer\",\"\",IF(C735=\"Grader\",\"16G/H\",\"FleetEntryError\")))))","v":""}]
[null,"",null,null,"",null,null,null,"","",null,null,"Total",{"$f":"SUM(N707:N724)","v":0}]
[null,"",null,null,"",null,null,null,"",""]
[null,"",null,null,"",null,null,null,"",""]
[null,"",null,null,"",null,null,null,"",{"$f":"IF(C739=\"\",\"\",IF(C739=\"Small Dozer\",\"\",IF(C739=\"Med Dozer\",\"\",IF(C739=\"Large Dozer\",\"\",IF(C739=\"Grader\",\"16G/H\",\"FleetEntryError\")))))","v":""}]
[null,"",null,null,"",null,null,null,"",""]
[null,"Pond Lining Fleet"]
[null,{"$f":"IF(F102=\"\",\"\",F102)","v":0},null,null,null,null,null,null,null,{"$f":"IF(B742=\"\",\"\",IF(B742=\"Double Liner\",\"\",IF(B742=\"New Pond\",\"420D\",IF(B742=\"Unlined\",\"420D\",IF(B742=\"Single Liner\",\"420D\",\"FleetEntryError\")))))","v":"FleetEntryError"}]
[null,0,null,null,null,null,null,null,null,{"$f":"IF(B743=\"\",\"\",IF(B743=\"Double Liner\",\"\",IF(B743=\"New Pond\",\"420D\",IF(B743=\"Unlined\",\"420D\",IF(B743=\"Single Liner\",\"420D\",\"FleetEntryError\")))))","v":"FleetEntryError"}]
[null,0,null,null,null,null,null,null,null,"FleetEntryError"]
[null,0,null,null,null,null,null,null,null,"FleetEntryError"]
[null,0,null,null,null,null,null,null,null,"FleetEntryError"]
[null,0,null,null,null,null,null,null,null,"FleetEntryError"]

{"sheet":"Unit Costs","index":2,"n_rows":110,"n_cols":12,"rows_kept":110,"cut":false,"hidden":false,"merged":[[82,0,82,1],[2,0,2,10],[25,1,26,1],[25,2,26,2],[25,3,26,3],[78,0,78,1],[76,0,76,1],[77,0,77,1],[80,0,80,1],[62,0,62,1],[63,0,63,1],[69,0,69,1],[72,0,72,1],[74,0,74,1],[15,1,15,3],[25,5,25,11],[5,2,5,4],[0,0,0,12]]}
["2023 BLM AND NDEP ACCEPTED VERSION"]
[]
["Unit Costs"]
[]
["Project Name:  ",null,{"$f":"'E Cell Calculator'!J3","v":""}]
["Date of Submittal:  ",null,{"$f":"'E Cell Calculator'!J7","v":""}]
["File Name:",null,{"$f":"'E Cell Calculator'!J8","v":"EZ_ECellCalculator_07_31_2023.xlsm"}]
["Model Version: ",null,{"$f":"'E Cell Calculator'!J9","v":"1.0.0 NDEP version 08.01.2023"}]
["Cost Data File: ",null,{"$f":"'E Cell Calculator'!J10","v":"SRCE_Cost_Data_File_1_12_Std_2023.xlsm"}]
["Cost Data Date: ",null,{"$f":"'E Cell Calculator'!J11","v":"2023-08-01"}]
[]
[]
[]
["Labor:"]
["Poly Liner Instalation/Inspection/Repair"]
["Crew: 3 SKWK","Rates: ($/hr)"]
[null,"Equip","Labor","Total"]
["Skilled Laborer",0,56.575155000000002,{"$f":"SUM(B18:C18)","v":56.575155000000002}]
["Skilled Laborer",0,56.575155000000002,{"$f":"SUM(B19:C19)","v":56.575155000000002}]
["Skilled Laborer",0,56.575155000000002,56.575155000000002]
["HDEP Welder (pipe or liner)",50.72,0,50.72]
["420D 4WD Backhoe",37.350115606936413,78.425555000000003,115.77567060693642]
["Totals",{"$f":"SUM(B18:B22)","v":88.070115606936412},{"$f":"SUM(C18:C22)","v":248.15102000000002},336.2211356069364]
[]
["Equipment:"]
[null,"Labor ($/hr)","Equipment ($/hr)","Total ($/hr)",null,"Hourly Equipment Rate"]
[null,null,null,null,null,"Total","Equip","PM","GET","Tires","Fuel","Cons g/hr"]
["Trucks"]
["777D",43.267250000000004,{"$f":"F29","v":465.5459206046055},{"$f":"B29+C29","v":508.81317060460549},null,{"$f":"SUM(G29:K29)","v":465.5459206046055},357.95454545454544,12.91,5.2,19.687875150060023,{"$f":"B110*L29","v":69.793500000000009},17.850000000000001]
["769D",43.267250000000004,{"$f":"F30","v":237.9840909090909},{"$f":"B30+C30","v":281.25134090909091},null,{"$f":"SUM(G30:K30)","v":237.9840909090909},184.65909090909091,7.29,4.1500000000000004,6.6950000000000003,{"$f":"B$110*L30","v":35.19},9]
[]
["Dozers"]
["D10R",71.368665000000007,{"$f":"F33","v":363.70790909090914},{"$f":"B33+C33","v":435.07657409090916},null,{"$f":"SUM(G33:K33)","v":363.70790909090914},252.84090909090909,12.46,25.29,0,{"$f":"B$110*L33","v":73.117000000000004},18.7]
["D9R",71.368665000000007,257.58136363636362,328.95002863636364,null,257.58136363636362,176.13636363636363,10.59,18.07,0,{"$f":"B$110*L34","v":52.785000000000004},13.5]
["D7R",71.368665000000007,113.68595454545455,185.05461954545456,null,113.68595454545455,73.295454545454547,8.8000000000000007,5.98,0,{"$f":"B$110*L35","v":25.610500000000002},6.55]
[]
["Loaders"]
["992G",72.436355000000006,572.84747474747473,{"$f":"B38+C38","v":645.28382974747478},null,572.84747474747473,394.88636363636363,14.52,38.799999999999997,34.711111111111109,{"$f":"B$110*L38","v":89.93},23]
["988G",72.436355000000006,243.0743181818182,315.51067318181822,null,243.0743181818182,147.55681818181819,13.12,16.899999999999999,17.600000000000001,{"$f":"B$110*L39","v":47.897500000000001},12.25]
["966G",72.436355000000006,117.14717171717172,189.58352671717171,null,117.14717171717172,71.022727272727266,6.19,12.45,11.844444444444445,{"$f":"B$110*L40","v":15.64},4]
[]
["Excavators"]
["385BL",72.436355000000006,217.45945454545455,{"$f":"B43+C43","v":289.89580954545454},null,217.45945454545455,142.04545454545453,7.41,15.61,0,{"$f":"B$110*L43","v":52.394000000000005},13.4]
["345B",72.436355000000006,149.5155,221.95185500000002,null,149.5155,93.75,8.84,7.63,0,{"$f":"B$110*L44","v":39.295500000000004},10.050000000000001]
["325C",72.436355000000006,93.908272727272717,166.34462772727272,null,93.908272727272717,53.977272727272727,5.4,6.77,0,{"$f":"B$110*L45","v":27.760999999999999},7.1]
[]
["Scrapers"]
["637G",72.436355000000006,340.98225454545451,{"$f":"B48+C48","v":413.4186095454545},null,340.98225454545451,196.98245454545452,20.142499999999998,16.1553,20.9,{"$f":"B$110*L48","v":86.802000000000007},22.2]
["631G",71.368665000000007,239.32795454545453,310.69661954545455,null,239.32795454545453,142.04545454545453,8.93,9.7799999999999994,20.9,{"$f":"B$110*L49","v":57.672499999999999},14.75]
[]
["Grader"]
["16GH",72.436355000000006,177.22936986301369,{"$f":"B52+C52","v":249.66572486301368},null,177.22936986301369,93.75,6.97,24.55,17.551369863013697,{"$f":"B$110*L52","v":34.408000000000001},8.8000000000000007]
[]
["Misc."]
["Vacuume Truck",null,null,207]
[]
[]
[]
["Materials:"]
[]
[]
["80mil HDPE Liner",null,"Means No.","Unit","Crew","Output/Day","Material","Labor","Equip",null,"Total"]
["Finish grading large area",null,"2310-100-0100","S.F.","B-11L",2000,"",0.41,0.47,null,{"$f":"H63+I63","v":0.87999999999999989}]
["Compaction - riding, vibrating roller - 12\" lifts",null,"2315-310-5080","S.F.","B-10Y",3500,"",0.23,0.12,null,{"$f":"H64+I64","v":0.35}]
[]
["80 mil HDPE",null,"6/22 AGRU Quote","S.F.","3 Skwk",19000,0.625,{"$f":"$C$23/(F66/8)","v":0.10448464},{"$f":"$B$23/(F66/8)","v":3.7082153939762698E-2},null,{"$f":"G66+H66+I66","v":0.76656679393976268}]
["60 mil HDPE ",null,"6/22 AGRU Quote","S.F.","3 Skwk",16000,0.47399999999999998,{"$f":"$C$23/(F67/8)","v":0.12407551000000001},{"$f":"$B$23/(F67/8)","v":4.4035057803468204E-2},null,{"$f":"G67+H67+I67","v":0.6421105678034682}]
["60 mil HDPE Drain Liner ",null,"6/22 AGRU Quote","S.F.","3 Skwk",12000,0.67300000000000004,0.16543401333333335,5.8713410404624272E-2,null,{"$f":"G68+H68+I68","v":0.89714742373795775}]
["40 mil HDPE",null,"6/22 AGRU Quote","S.F.","3 Skwk",19000,0.34300000000000003,0.10448464,3.7082153939762698E-2,null,{"$f":"G69+H69+I69","v":0.48456679393976276}]
["40 mil LLDPE ",null,"6/22 AGRU Quote","S.F.","3 Skwk",20000,0.35299999999999998,9.9260408000000008E-2,3.5228046242774563E-2,null,{"$f":"G70+H70+I70","v":0.48748845424277454}]
[null,"TOTAL",null,null,null,null,{"$f":"G67","v":0.47399999999999998},{"$f":"H63+H64+H67","v":0.76407551000000007},{"$f":"I63+I64+I67","v":0.63403505780346814},null,{"$f":"G71+H71+I71","v":1.8721105678034682}]
["420D Backhoe",null,null,null,null,"Output/Day"]
["Backhoe work",null,"02210-700-0120","C.Y.","B-11M",28,"",{"$f":"8*C22/F73","v":22.407301428571429},{"$f":"8*B22/F73","v":10.671461601981832},"",{"$f":"H73+I73","v":33.078763030553262}]
["Dosing Tank"]
["Grade walls - 15 in (40 cm) thick, 8 ft ( 2.5 m) high",null,"03310-240-4300","C.Y.","C-14D",80.02,202,{"$f":"8*1228.66/F75","v":122.83529117720572},{"$f":"8*149.91/F75","v":14.987253186703324},"",{"$f":"H75+I75+G75","v":339.82254436390906}]
["Piping"]
["Water 4in (10cm ) 40ft (12m) length, welded HDPE",null,"02510-760-0100","L.F.","B-22A",400,1.1100000000000001,{"$f":"8*245.65/F77","v":4.9130000000000003},{"$f":"8*258.63/F77","v":5.1726000000000001},"",{"$f":"H77+I77+G77","v":11.195599999999999}]
["Water 6in (15cm) 40ft (12m) length, welded HDPE",null,"02510-760-0200","L.F.","B-22A",380,2.39,{"$f":"8*245.65/F78","v":5.1715789473684213},{"$f":"8*258.63/F78","v":5.4448421052631577},"",{"$f":"H78+I78+G78","v":13.00642105263158}]
["Drain 4in (10cm) corrugated, perf or plain",null,"02220-220-2960","L.F.","2 Clab",1200,1.76,{"$f":"8*80.58/F79","v":0.53720000000000001},{"$f":"8*31.14/F79","v":0.20760000000000001},"",{"$f":"H79+I79+G79","v":2.5047999999999999}]
["Fence",null,null,null,null,null,null,null,"."]
["Chain link 8-10ft (2.5-3m) Install",null,"02820-130-0920","L.F.","B-80C",180,43,{"$f":"8*120.87/F81","v":5.3719999999999999},{"$f":"8*31.14/F81","v":1.3840000000000001},"",{"$f":"H81+I81+G81","v":49.756}]
["Seed"]
["Seeding - Broadcast Mechanical (1)",null,null,"acres",null,null,null,175,100,null,{"$f":"H83+I83+G83","v":275}]
[]
[]
["Seed Mix","Description",null,"Cost/Acre"]
[]
["None",null,null,""]
["Mix 1","Basins",null,302.5]
["Mix 2","Low Hills",null,332.75]
["Mix 3","Uplands",null,363]
["Mix 4","Riparian or Custom",null,393.25]
["User Mix 1","Vender Quote Attached",null,217]
["User Mix 2"]
["User Mix 3"]
["User Mix 4"]
[]
["Ammenities"]
["Item","Cost/lb","lbs/Acre","Cost/Acre"]
["Straw Mulch",0.2376545925600039,1000,{"$f":"B100*C100","v":237.65459256000389}]
["Hydro Mulch",0.39,1000,{"$f":"B101*C101","v":390}]
["Organic Matter",0.8,1000,800]
["Chemical",0.73140000000000005,1000,731.40000000000009]
[]
[]
["Unemployment (%)",0.03]
["Retirement/SS/Medicare (%)",7.6499999999999999E-2]
["Workman's Compensation (%)",0.13500000000000001]
[]
["Fuel Price/ gal",3.91]

{"sheet":"Guide Notes","index":3,"n_rows":52,"n_cols":3,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Guide Notes and Assumptions:"]
[]
[]
["Guide Notes:"]
[1,"Sludge Removal and Disposal","Assumes 0.5 feet of accumulated sludge to be removed. Disposal on site in 2x liner at HLP or TSF."]
[2,"Existing Liner Inspect and Repair","Cost based on assumption that it is 1/2 liner installation cost."]
[3,"New Pond Excavation","Earthwork for Ring dike for Slope 0-10%, Earthwork for valley fill for slope over 10%"]
[4,"Secondary Liner Instalation","Source (SRCE)"]
[5,"Geonetting","Cost based on assumption that labor and equipment are same as liner. Materials are 1/2- 60mil liner cost."]
[6,"Primary Liner Instalation","Calculates cost for primary liner regardless of age or condition of existing primary liner."]
[7,"Liner Key Trenching","2'x2' trench"]
[8,"Dosing Tank","Cost based on Jan 2011 Quote from Jensen Precast, FOB Elko"]
[9,"Piping Manifold","4 in diam perf ploy pipe at 10 feet on center."]
[10,"Backfill and Coarse Rock Cover ","Screened HLP, WRD or alluvial material, source is on site."]
[11,"HLP to Pond to Pond Piping","4 in diam in 6 in diam welded pipe "]
[12,"Fencing","Ten foot tall chain link set back from crest of pond 20 feet. Assume any existing fence requires replacement. Cost includes gates."]
[13,"Growth Media","Use for any disturbed areas requiring revegetation that are not already included in a SRCE."]
[14,"Revegetation","Use for any disturbed areas requiring revegetation that are not already included in a SRCE."]
[15,"Leach Field","Failsafe overflow device, 100 lf 4 in dia perf poly pipe, 3 ft deep in 2 ft wide trench, backfilled with clean gravel. "]
[16,"Peizo Well","Minimum 12 inch dia. perforated poly pipe from bottom liner to 3ft above backfill. Includes locking lid assembly."]
[17,"Miscelaneous","Miscelaneous"]
[]
["Assumptions: "]
[null,"•New Construction:"]
[null,"•Quantify Earthwork to construct new pond – Layout"]
[null,"•Converting existing pond(s) to E-cells"]
[null,"•Unlined, Single, Double Liners"]
[null,"•Sludge removal and disposal:"]
[null,"•Assume minimum 0.5’ depth of sludge in existing ponds will need to be removed and disposed of on  double lined containment"]
[null,"•Inspect and repair existing liner systems"]
[null,"•Primary liner installation"]
[null,"•Secondary liner installation with geo-net and leak detection port"]
[null,"•Liner key in trenching around perimeter"]
[null,"•Dosing tank, assume 1 dosing tank required in each E-cell"]
[null,"•Drain/Distribution Manifold Piping"]
[null,"•Backfill and Coarse Rock Cover:"]
[null,"•2’ Freeboard Above Backfill"]
[null,"•All backfill will originate on-site from a leach pad or waste rock dump"]
[null,"•Entire backfill volume will need to be sized (screen or grizzly) at borrow site"]
[null,"•Piping:"]
[null,"•Heap to E-cell will be pipe-in-pipe HDPE, and buried to protect from UV."]
[null,"•Pond to Pond will be pipe-in-pipe HDPE, and buried to protect from UV."]
[null,"•Wildlife Fencing Around Perimeter:"]
[null,"•Any existing fencing will need full replacement"]
[null,"•Growth media:"]
[null,"•No Growth Media included in E-Cell Estimate"]
[null,"•Coverage sloped to drain if constructing an ET cell, Possible future addition"]
[null,"•Haul distances and slopes from site mapping for haulage activities."]
[null,"•SRCE cost data for labor, equipment, materials "]
[null,"•Caterpillar Equipment manual - equipment productivities"]
[null,"•Construction Management"]
[null,"•Long Term Water Chemistry Sampling , Monitoring and Reporting"]

{"sheet":"Revision Notes","index":4,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["Revisions/Additions Punch List:","Resolution:"]
["Red items need attention"]
[]
["Include Multiple Handeling for Backfill","Three times needed volume for backfill cost as loader manover to load and manover to dump."]
["Include Freeboad and Cover","Minimum 2 feet freeboard included as input item."]
["Leak Detection","Included as cost for geonetting"]
["Ballanced EW for New Ponds","Calculates same volume as SRCE for slopes > 10%"]
["Capillary vs Vados - Consider Both","Screen material not specific to size. Not able to include specificlly."]
["Look into Copper Basin Design","Done"]
["Golden Butte 2 cells","Done"]
["No Surface Exposure of Water","Screen material not specific to size. Not able to include specificlly."]
["Hard Wire 5000 Pumper Truck for Slugde Disposal","Included with cost from SRCE for 5000 gal vac per hour using hrs as travel time to  disposal location on site"]
["Hard Wire 0.5 feet of sludge in existing Ponds","Done"]
["Consider Existing Double Liner, 4 possible scenerios","Done"]
["Clark West, liner repair  estimates Sierra Geosynthetics Fernley","No usable information was derived for conversation with Sales Rep."]
["Dosing tank using Concrete Construction Mineral Ridge 2000,2500,900","Done"]
["Find cost of dosing tank, Local and Means","Cost based on Jan 2011 Quote from Jensen Precast, FOB Elko"]
["Revse dosing tank cost to reflect Means or Jensen Precast Quote","Done"]
["Piping Shoud include LE&M for Both 6&4 add excavation","Done"]
["Consider Radial Stacker for Load and Place in the Pond","Considered, not used, RS costs not in SRCE, Used dozer to push fill into pond"]
["Consider Demo and Removal of Pumps, Equipment and Structures in Preg Ponds","Considered, Not Used"]
["Haul Distance (Loads) Requiring Water Truck and Grader","Considered, Not Used, Captured in SRCE"]
["Pond to Pond Coffer Dam","Considered, Not Used, Minor cost assumed to be included "]
["Wrap Arround Pond","Not sure what this is"]
["Set as stand alone Calculator no direct tie to SRCE","Done"]
["Link to  SRCE cost data file only with internal productivities","Done"]
["Add leachfield cost","Considered, Not Used, Minor cost assumed to be included "]
["Revise to reflect new primary liner regardless of age of existing primary.","Done"]
["Add Construction Management","Considered, Not Used, Captured in SRCE"]
["Add Mob-Demob Equipment List","Done"]
["Add Sampling, Monitoring and Reporting","Considered, Not Used, Captured in SRCE"]
["Add drop downs for help with the inputs and explaine outputs.","Done"]
["Compile giuide notes as front page to E-Cell Calculator."]
["Add Scarify and Ripping Option"]