Spreadsheet: 5221db17-63fb-45c1-8114-05398473500b
Sheet: Sheet1

Spillway Capacity Spreadsheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33
User Input Data
Calculated Value
Reference Data
Designed By: |  | Date:
Checked By: |  | Date:
Company:
Project Name:
Project No.:
Pipe Flow |  |  |  |  | Inlet Control |  |  | Weir Flow |  |  | Orifice Flow |  |  |  |  | Primary |  | Emergency |  |  |  |  | Total Spillway
Full |  |  |  |  | Orifice |  |  | Riser |  |  | Riser |  |  |  |  | [NAME] |  | [NAME] |  |  |  |  | Capacity
Inlet Invert (ft) | 0 |  |  |  | Co | 0.6 |  | Crest Elevation (ft) | 0 |  | Crest Elevation (ft) | 0 |  |  |  |  |  | [NAME] (ft) |  |  | 0
Outlet [NAME] (ft) | 0
Material | Corrugated Metal (n=0.024) |  |  |  |  |  |  | Pipe Diameter (in) | 0 |  | Pipe Diameter (in) | 0 |  |  |  |  |  | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  | PIPE FRICTION COEFFICIENTS
Diameter (in) | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PIPE MATERIAL | COEFFICIENT
Ke | 1 |  |  |  |  |  |  | Box |  |  | Box |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smooth Cement (n=0.013) | 0.013 |  | 0.013
Manning's n | 0.024 | Manning's n |  |  |  |  |  | L (ft) |  |  | L (ft) |  |  |  |  |  |  | Weir Equation Q= C L H1.5 |  |  |  |  |  |  |  |  |  |  |  | Rough Cement (n=0.015) | 0.014 |  | 0.015
Length (ft) | 0 |  |  |  |  |  |  | W (ft) |  |  | W (ft) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Corrugated Metal (n=0.024) | 0.015 |  | 0.024
Kp | 0.01249132776952293 | Or use Table 8.07a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cw |  |  | 2.8 |  |  |  |  |  |  |  |  | Smooth Steel (n=0.013) | 0.016 |  | 0.013
Area  (ft2) | 19.6349375 |  |  |  |  |  |  | Cw | 3.1 |  | Co | 0.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Riveted Steel (n=0.016) | 0.024 |  | 0.016
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cast Iron (n=0.014) |  |  | 0.014
 |  |  |  |  | ` |  |  |  |  |  | Area  (ft2) | 0
Elevation | H | Q | Outlet |  | H | Q |  | H | Q |  | H | Q |  |  |  | Q [NAME] |  | Elevation | H | Head | Q |  | Q cfs
(ft) | (ft) | (cfs) | Velocity (ft/s) |  | (ft) | (cfs) |  | (ft) | (cfs) |  | (ft) | (cfs) |  |  |  | (cfs) |  | (ft) |  | (ft) | (cfs)
0 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
0 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
0 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
0 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
0 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
0 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0
 | -2.5 |  |  |  | -2.5 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0