Ogee Spillway — Designxls Install //top\\

With a final click, the spreadsheet produced a chart showing the finished profile. At the bottom of the curve, it suggested a reverse curve bucket

– Implement the power law ( x^n = K H_d^,n-1 y ). For a vertical upstream face, this becomes ( x^1.85 = 2.0 \cdot H_d^0.85 \cdot y ). Solve for y at incremental x values. ogee spillway designxls install

: Go to File > Options > Add-ins , select Excel Add-ins from the Manage dropdown, click Go , and check the box for Solver Add-in . With a final click, the spreadsheet produced a

= Variable discharge coefficient (dependent on approach depth, upstream face slope, and downstream submergence effects). Solve for y at incremental x values

| H (m) | H/H d | C/C d | C | Q (m³/s) | |-------|----------------|-----------------|-----|----------| | 5.0 | 0.30 | 0.85 | 1.96| 2 410 | | 10.0 | 0.60 | 0.97 | 2.23| 9 000 | | 16.70 | 1.00 | 1.00 | 2.30| 12 000 | | 20.0 | 1.20 | 0.99 | 2.28| 16 450 |

A comprehensive ogee spillway design spreadsheet typically features modules broken down into specific engineering stages. 1. Hydraulic Input Parameter Sheet