Spreadsheet: 466746d1466428711-workbook-opens-slowly-after-protecting-all-worksheets-sediment-basin-designer
Sheet: Principle Spillway & Skimmer

 |  |  |  |  |  |  | SEDIMENT BASIN DESIGN
 |  |  |  |  |  |  | Project Information
 |  |  |  |  |  |  |  |  | Project Number: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 |  |  |  |  |  |  |  |  | PI Number: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Designer:
 |  |  |  |  |  |  |  |  | County: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Note:
 |  |  |  |  |  |  | POND DESIGN
 |  |  |  |  |  |  | Principle [NAME]
 |  |  |  |  |  |  |  |  | 1. Distance between outlet pipe and emergency spillway, H …………………………………………………
 |  |  |  |  |  |  |  |  | 2. Total Length of Pipe:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], T (See [NAME] D-22A) …………………………………………………..
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Upstream Side Slope, Zu ………………………………………………………………………………………………………….
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Downstream Side Slope, Zd ………………………………………………………………………………….
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Top of Dam Elevation, A       *Final height calculated on next sheet ………..
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Lowest Elevation of Pipe at Riser, B ……………………………………………………………
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Lowest Elevation of Pipe at Outlet, C ……………………………………………………………
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Extended Length of Pipe beyond Toe of Dam, E …………………………………………
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [ |  |  |  |  | (B+C) |  |  |  |  |  |  | ] |  |  |  | (Zu+Zd) |  |  |  |  |  |  |  |  |  | T |  |  |  | E
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Length of Pipe, L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L = |  |  |  |  |  |  | A- |  |  |  |  |  |  |  |  |  |  |  | * |  |  |  |  |  |  |  |  |  | + |  |  |  | + |  |  |  |  |  |  |  |  |  |  |  |  | L =
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 3. Maximum Principle Spillway Capacity …………………………………………………………………………….
 |  |  |  |  |  |  |  |  | 4. Diameter of Outlet Pipe ……………………………………………………………………………………………………
 |  |  |  |  |  |  |  |  | 5. Correction Factor for Pipe Lengths …………………………………………………………………………………….
 |  |  |  |  |  |  |  |  | 6. Actual Flow though [NAME], [NAME] …………………………………………………………………………..
 |  |  |  |  |  |  |  |  | 7. Minimum Riser Diameter, [NAME] ……………………………………………………………………………………………..
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 * Qps
 |  |  |  |  |  |  |  |  | 8. Calculate required Dr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dr =
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.1 * π * h3/2
 |  |  |  |  |  |  |  |  | 9. Final riser diameter, [NAME] …………………………………………………………………………………………………….
 |  |  |  |  |  |  |  |  | 10. Trash rack diameter ……………………………………………………………………………………………………….
 |  |  |  |  |  |  |  |  | 11. Minimum distance between riser crest and emergency spillway, h ……………………………….
 |  |  |  |  |  |  |  |  | 12. Anti-Seep Collar Design
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Is height of dam greater than 15 feet?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Is the principal spillway a smooth pipe with Dps > 8"?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Is the principal spillway a corrugated metal pipe with Dps > 12"?
 |  |  |  |  |  |  | Skimmer Design
 |  |  |  |  |  |  |  |  | 1. Select desired Orifice Diameter, D ……………………………………………………………………………………
 |  |  |  |  |  |  |  |  | 2. Compute Time of Basin Dewatering (td) for a 6" skimmer (between 24-48 hours), given:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Head (H) = 0.75 ft; Discharge Coefficient (C)= 0.62; g = 32.174 ft/sec2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Vfinal = Final Storage Volume; A = area of orifice opening = π*r2 = π*(D*0.5/12)2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | td = |  |  |  |  | Vfinal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C*A*(2*g*H)1/2
 |  |  |  |  |  |  |  |  | 3. Verify Orifice Diameter [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page 5 of 7