Design an ogee spillway with vertical upstream face for a concrete dam. Design discharge = 12,000 m³/s, height of spillway above river bed = 100 m, with 6 spans.
The structural safety of the dam depends on the precise geometry of the ogee curve. Engineers use the general equation for the downstream profile: ogee spillway designxls better
Manual hydraulic design involves tedious coordinate computations. A minor math error can miscalculate the entire downstream profile shape. Excel automation removes human calculation risk by executing complex formulas instantly. 2. Rapid Iterative Testing Design an ogee spillway with vertical upstream face
For a vertical upstream face, the downstream profile equation generally follows: Engineers use the general equation for the downstream
): The depth of water above the crest apex during maximum design flow.
I can provide the specific Excel formula syntax or coordinate tables tailored to your design parameters. Share public link
: The Ogee shape is optimized to maintain atmospheric pressure at the design head, preventing cavitation. Excel allows you to quickly iterate through different design heads to find the point where discharge efficiency is maximized.