An ogee spillway is one of the most critical hydraulic structures used in dam engineering. Its S-shaped, aerodynamic profile matches the underside of a flowing water sheet, maximizing discharge efficiency while preventing dangerous sub-atmospheric pressures that cause cavitation.
| x (m) | y (m) | |-------|-------| | 0.0 | 0.00 | | 5.0 | 0.64 | | 10.0 | 2.24 | | 15.0 | 4.68 | | 20.0 | 7.92 | | 25.0 | 11.92 | | 30.0 | 16.67 |
| Item | Requirement | Status | |------|-------------|--------| | Operating System | Windows 10 / 11 (64-bit) | Satisfied | | Spreadsheet Software | Microsoft Excel 2016 or later (or LibreOffice Calc with partial compatibility) | Satisfied | | Memory | 4 GB RAM minimum | Satisfied | | Macro Security | Enable editing & enable macros (for iterative calculations if used) | Set as needed | ogee spillway designxls install
A curve defined by the standard power equation:
The total reservoir width at crest = ( L' + (N-1) \times \textpier thickness = 90 + 5 \times 3 = 105 \text m ). The area at the approach = ( 105 \times 100 = 10,500 \text m^2 ). Approach velocity ( V_a = 12000 / 10500 \approx 1.14 \text m/s ). Velocity head = 0.066 m, which is negligible compared to 16.70 m, so no adjustment is needed. An ogee spillway is one of the most
Living the Indian lifestyle requires a specific kind of patience. It is loud. The traffic is a nightmare. The bureaucracy is slow. But the heart is fast.
Once the inputs are set, embed the standard hydraulic equations into your Excel cells. 1. Discharge Coefficient ( Cocap C sub o The discharge equation for an ogee spillway is: The area at the approach = ( 105
L=L0−2(N⋅Kp+Ka)Hecap L equals cap L sub 0 minus 2 open paren cap N center dot cap K sub p plus cap K sub a close paren cap H sub e L0cap L sub 0 is the gross clear span, is the number of piers, Kpcap K sub p is the pier contraction coefficient, and Kacap K sub a is the abutment contraction coefficient. Step 2: Determine Design Head Iterate the approach velocity head (