Spreadsheet: 50ea1dba-b057-4770-bf0d-fefdd80441e6
Sheet: Sheet1

Unnamed: 0 | [NAME] PLUNGE POOL FOR CANTILEVER OUTLET (Version 8.99) | 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
(Reference Design Note No. 6 (Second Edition), Jan. 23, 1986 |  |  |  |  |  |  |  |  | FORMULAS & COMPUTATIONS
 |  |  |  |  |  |  | g     = acceleration of gravity |  |  |  |  |  | 32.2
JOB: |  |  |  |  |  |  | Q/(g*d^5)^(1/2) = dimensionless parameter |  |  |  |  |  | 2.643402663188405
DESIGNER: |  |  | Date: | 2006-01-18 00:00:00 |  |  | Zd     = water depth above channel invert |  |  |  |  |  | 1.5
CHECKER: |  |  | Date: |  |  |  | Vo     = conduit discharge velocity |  |  |  |  |  | 19.09859317102744
 |  |  |  |  |  |  | Vh     = horiz. velocity component of jet impingement |  |  |  |  |  | 18.59555784682859
INPUT DATA: |  |  |  |  |  |  | Vv     = vert. velocity component of jet impingement |  |  |  |  |  | 10.71043313450044
Conduit Diameter |  |  | D = | 1 | ft |  | TAN,a  = jet impingement slope |  |  |  |  |  | 0.5759672940560407
Conduit Discharge: |  |  | Q = | 15 | cfs |  | Vp       = jet velocity at impingement |  |  |  |  |  | 21.45945361754006
Conduit Slope at Outlet: |  |  | S = | 0.228 | ft/ft |  | Xp        = horiz. distance from conduit exit to center of
Conduit Outlet [NAME]: |  |  | El, CO = | 102.5 | ft |  |  | jet at impingement with tailwater |  |  |  |  | 3.670574790722933
Tailwater Elevation: |  |  | El, TW = | 101.5 | ft |  | Fd        = densimetric Froude number |  |  |  |  |  | 2.953036400134784
Outlet Channel Invert Elevation: |  |  | El, CH = | 100 | ft |  | Zp/D |  |  |  |  |  | 1
 |  |  |  |  |  |  | Zma     = maximum pool depth when Zp/D<=1 |  |  |  |  |  | 3.266279401972632
Water Density: |  |  | RHO = | 1 |  |  | [NAME]= maximum pool depth when Zp/D > 1 |  |  |  |  |  | 2.978147000496895
Bed/Riprap Particle Density: (Default 2.64) |  |  | RHOS = | 2.64 |  |  | Zm       = pool depth to be used |  |  |  |  |  | 3.266279401972632
D, 50 [NAME]: |  |  | RS = | 1 | ft |  | 1+25*RS/D  = parameter used in beaching check |  |  |  |  |  | 26
[NAME]:  (2.5*D, 50 recommended) |  |  | RT = | 2.5 | ft |  | Xm       = horiz. distance from conduit exit to center
Bedding Thickness: (6 inch min. rec.)  (Enter 0 for geotextile) |  |  | BT = | 0 | ft |  |  | of plunge pool |  |  |  |  | 7.226252704344059
Side Slope Ratio: |  |  | Zw = | 2 | ft/ft |  | Le        = min. [NAME]. distance from center of pool to
Upstream End Slope Ratio: |  |  | Zlu = | 4 | ft/ft |  |  | water surface contour at upstream or
Downstream End Slope Ratio: |  |  | Zld = | 3 | ft/ft |  |  | downstream end of pool |  |  |  |  | 7.777449659589576
Combined End Slope Ratio: |  |  | Z1 = | 3.5 | ft/ft |  | We2       = one-half pool width at center at water
 |  |  |  |  |  |  |  | surface elevation |  |  |  |  | 6.19453285344273
OUTPUT---POOL LOCATION AND DIMENSIONS: |  |  |  |  |  |  | Lr2       = one-half pool length at bottom of pool |  |  |  |  |  | 1.555489931917915
Vert. Dist. from Tailwater to Conduit Invert: |  |  | Zp = | 1 | ft |  | Wr2      = one-half pool width at bottom of pool |  |  |  |  |  | 1.238906570688546
Submergence Check:  (If Zp < 0 , Use Zp = 0) |  |  | Use Zp = | 1 | ft |  | [NAME]= adjusted upstream horiz. length from center of
Beaching Check: [Q/(gD^5)^0.5 <= (1.0+25*D,50/D)] |  |  |  | [NAME] |  |  |  | pool to water surface contour at upstream
**Beaching Controlled** |  |  |  |  |  |  |  | end of pool |  |  |  |  | 12.00758401823034
Distance from Conduit Exit to C/L Pool: |  |  | Xm = | 7.226252704344059 | ft |  | Lrd       = adjusted downstream horiz. length from center
Pool depth at C/L Below Conduit Invert: |  |  | Zp+0.8Zm = | 3.613023521578105 | ft |  |  | of pool to water surface contour at
Pool Bottom Elev: |  |  | El,PB = | 98.8869764784219 | ft |  |  | downstream end of pool |  |  |  |  | 9.39456049665223
Pool Bottom Length: |  |  | 2Lr2 = | 3.11097986383583 | ft |  | [NAME] adjusted horiz. length from center of pool
Pool Bottom Width: |  |  | 2Wr2 = | 2.477813141377093 | ft |  |  | to water surface contour at upstream or
Upstream Pool Length at Tailwater Elev.: |  |  | Lru = | 12.00758401823034 | ft |  |  | downstream end of pool |  |  |  |  | 10.70107225744128
Downstream Pool Length at Tailwater Elev.: |  |  | Lrd = | 9.39456049665223 | ft |  | [NAME] adjusted horiz. width from center of pool
[NAME] at Tailwater Elev.: |  |  | 2Wr = | 12.92990722768951 | ft |  |  | to water surface contour |  |  |  |  | 6.464953613844757
Check Side Slope Ratio:   (Wr>=We) |  |  |  | [NAME] |  |  | A,2        = horiz. pool area at bottom of pool |  |  |  |  |  | 7.708426789171939
**Side Slope [NAME]** |  |  |  |  |  |  | A,1        = horiz. pool area at channel invert elev. |  |  |  |  |  | 75.55085007100027
Check Min. End Slope Ratio:  (Lru & Lrd >= Le) |  |  |  | [NAME] |  |  | V,p        = pool volume between bottom and outlet channel
**End Slope Ratios [NAME]** |  |  |  |  |  |  |  | invert elevation |  |  |  |  | 1.475673931321937
Check Upstream Length:   (Lru >= Xm) |  |  |  | [NAME] |  |  | A,2r      = horiz. pool area at bottom of riprap elev. |  |  |  |  |  | 13.94215251138757
**End Slope [NAME]** |  |  |  |  |  |  | A,1r      = horiz. pool area at channel invert elevation
Pool Bottom Elev. at Bottom of [NAME]: |  |  | El, BR = | 96.3869764784219 | ft |  |  | contour at bottom surface of riprap |  |  |  |  | 527.0520040515136
Pool Bottom Elev. at Bottom of Bedding: |  |  | El, BB = | 96.3869764784219 | ft |  | V,pr      = volume of pool measured from bottom surface of
OUTPUT---VOLUMES BELOW WATER SURFACE ELEVATION: |  |  |  |  |  |  |  | riprap |  |  |  |  | 27.95481178137442
Volume of Excavation (measured from bottom |  |  |  |  |  |  | A,2b     = horiz. pool area at bottom of bedding elev. |  |  |  |  |  | 13.94215251138757
surface of bedding): |  |  | V,pbs = | 68.43530892607669 | [NAME] |  | [NAME]     = horiz. pool area at channel invert elevation
Volume of [NAME]: |  |  | V,rs = | 57.7695904814295 | [NAME] |  |  | contour at bottom surface of bedding |  |  |  |  | 527.0520040515136
Area of Geotextile: |  |  | A,gt = | 121.005728109662 | sq yd |  | V,pb     = volume of pool measured from bottom surface of
 |  |  |  |  |  |  |  | bedding |  |  |  |  | 27.95481178137442
Spreadsheet developed by [NAME], Midwest NTC, 1/90
Spreadsheet modified by [NAME], [NAME], Wis., 3/98 |  |  |  |  |  |  | 2Lr2e     = excavation length at bottom of riprap |  |  |  |  |  | 3.811254587037125
Design Note No. 6 (Second Edition), Jan. 23, 1986 |  |  |  |  |  |  | 2Wr2e    = excavation width at bottom of riprap |  |  |  |  |  | 3.658153028876042
"[NAME] for Cantilever Outlet" |  |  |  |  |  |  | Wre        = adjusted horiz. width across pool
Natural Resources Conservation Service |  |  |  |  |  |  |  | from bottom of riprap at water surface contour |  |  |  |  | 24.11024711518846
Engineering Division |  |  |  |  |  |  | [NAME] adjusted upstream horiz. length from center of
 |  |  |  |  |  |  |  | pool to bottom of riprap at water surface contour
 |  |  |  |  |  |  |  | at upstream end of pool |  |  |  |  | 22.35772137983098
 |  |  |  |  |  |  | [NAME]= adjusted downstream horiz. length from center
 |  |  |  |  |  |  |  | of pool to bottom of riprap at outlet channel
 |  |  |  |  |  |  |  | invert elevation at downstream end of pool |  |  |  |  | 12.74469785825288
 |  |  |  |  |  |  | Lre        = adjusted horiz. length from center of pool
 |  |  |  |  |  |  |  | to bottom of riprap at water surface contour at
 |  |  |  |  |  |  |  | upstream or downstream end of pool |  |  |  |  | 19.80120961904193
 |  |  |  |  |  |  | A,2   = horiz. pool area at bottom of pool |  |  |  |  |  | 7.708426789171939
 |  |  |  |  |  |  | A,1s = horiz. pool area at water surface elev |  |  |  |  |  | 276.7277430510355
 |  |  |  |  |  |  | V,ps = pool volume between bottom and water
 |  |  |  |  |  |  |  | surface elevation |  |  |  |  | 10.66571844464718
 |  |  |  |  |  |  | A,2r  = horiz. pool area at bottom of riprap elev |  |  |  |  |  | 13.94215251138757
 |  |  |  |  |  |  | A,1rs  = horiz. pool area at water surface elevation
 |  |  |  |  |  |  |  | contour at bottom surface of riprap |  |  |  |  | 954.8241141894955
 |  |  |  |  |  |  | V,prs  = volume of pool measured from bottom surface of
 |  |  |  |  |  |  |  | riprap to water surface elevation |  |  |  |  | 68.43530892607669
 |  |  |  |  |  |  | 2Lr2b     = excavation length at bottom of bedding |  |  |  |  |  | 3.811254587037125
 |  |  |  |  |  |  | 2Wr2b    = excavation width at bottom of bedding |  |  |  |  |  | 3.658153028876042
 |  |  |  |  |  |  | Wrb        = adjusted horiz. width from center of pool
 |  |  |  |  |  |  |  | to bottom of bedding at water surface contour |  |  |  |  | 24.11024711518846
 |  |  |  |  |  |  | [NAME]= adjusted upstream horiz. length from center of
 |  |  |  |  |  |  |  | pool to bottom of bedding at water surface contour
 |  |  |  |  |  |  |  | at upstream end of pool |  |  |  |  | 22.35772137983098
 |  |  |  |  |  |  | Lrdb      = adjusted downstream horiz. length from center
 |  |  |  |  |  |  |  | of pool to bottom of bedding at outlet channel
 |  |  |  |  |  |  |  | invert elevation at downstream end of pool |  |  |  |  | 12.74469785825288
 |  |  |  |  |  |  | Lrb        = adjusted horiz. length from center of pool
 |  |  |  |  |  |  |  | to bottom of bedding at water surface contour at
 |  |  |  |  |  |  |  | upstream or downstream end of pool |  |  |  |  | 19.80120961904193
 |  |  |  |  |  |  | A,2b  = horiz. pool area at bottom of bedding elev |  |  |  |  |  | 13.94215251138757
 |  |  |  |  |  |  | A,1bs  = horiz. pool area at water surface elevation
 |  |  |  |  |  |  |  | contour at bottom surface of bedding |  |  |  |  | 954.8241141894955
 |  |  |  |  |  |  | V,pbs  = volume of pool measured from bottom surface of
 |  |  |  |  |  |  |  | bedding to water surface elevation |  |  |  |  | 68.43530892607669
 |  |  |  |  |  |  | Areas for geotextile:
 |  |  |  |  |  |  | A,b = bottom |  |  |  |  |  | 13.94215251138757
 |  |  |  |  |  |  | A,lr  = left & right sides |  |  |  |  |  | 496.3514921271757
 |  |  |  |  |  |  | A,us  = u.s. end |  |  |  |  |  | 292.700264284732
 |  |  |  |  |  |  | A,ds  = d.s. end |  |  |  |  |  | 158.6323113571182
 |  |  |  |  |  |  | A,p   = perimeter |  |  |  |  |  | 127.4253327065447
 |  |  |  |  |  |  | A,gt  = total area |  |  |  |  |  | 121.005728109662