: Some versions include calculations for the downstream bucket radius and trajectory flow to prevent toe erosion. 2. Installation & Setup Guide
is the design total head over the crest (including velocity head).
The XLS file calculates these constants and outputs a clean table of coordinates. 3. Discharge Coefficient ( Cdcap C sub d ) Correction
To ensure correct installation, a standard test case from literature (USBR Small Dams, Example 8-1) was entered: ogee spillway designxls install
Q=Co⋅L⋅Hd1.5cap Q equals cap C sub o center dot cap L center dot cap H sub d to the 1.5 power
If the spillway is gated or bridged, pier contraction coefficients ( Kpcap K sub p ) and abutment contraction coefficients ( Kacap K sub a ) are required. Approach Velocity: Optional, to account for velocity head. 4. Understanding the Automated Outputs
Comprehensive Guide to Ogee Spillway Design and Excel Toolkit Installation : Some versions include calculations for the downstream
[ L_e = L' - 2 \left( N K_p + K_a \right) H_e ]
Do not download random .xls files from untrusted forums. Start here:
A comprehensive ogee spillway design spreadsheet typically features modules broken down into specific engineering stages. 1. Hydraulic Input Parameter Sheet The XLS file calculates these constants and outputs
Elias stood at the edge of the gorge, looking down at the massive concrete gravity dam. The rains were coming early this year, and his team needed a spillway design that could handle a massive discharge of 8,000 cumecs without triggering the dreaded cavitation
Which would you like?
The "ogee spillway design.xls" (or similar .xls files) is a spreadsheet tool used by civil and hydraulic engineers to automate the complex geometric and hydraulic calculations for an . These tools typically require only a few primary inputs, such as the design head ( Hdcap H sub d ) and spillway height (