Ogee: Spillway Designxls Better

A standard .xls assumes you are building exactly to the WES profile for the design head. But if your actual operating head ($H_e$) exceeds the design head ($H_d$), negative pressures (cavitation risk) develop on the crest. Excel cannot simulate the dynamic pressure distribution along the curved profile. You need CFD or at least a numerical panel method—something that requires iterative matrix solving, which Excel handles poorly.

The best test of your XLS is simple: Plot the USACE (U.S. Army Corps of Engineers) standard crest profile as a scatter plot over your calculated curve. If they don’t overlap perfectly within 2mm (scaled), your coefficients are wrong.

A proper XLS passes this match test. Commercial CFD (Computational Fluid Dynamics) software often overshoots it because of mesh limitations.

You have used ogee_spillway_design_v3_final_actual.xls for 15 years. Here is how to pivot:

Is “Ogee Spillway Design.xls” better now? Absolutely.

The old spreadsheet was a rite of passage. The new one is a professional productivity tool. It reduces human error, speeds up iteration, and lets you focus on the engineering judgment—not the algebra.

So go ahead. Download or rebuild that spreadsheet. Just promise me you’ll still check your tangent point manually once. Old habits, right? ogee spillway designxls better

Have you built a better ogee spreadsheet? Share your favorite feature or a cautionary tale in the comments below.

About the author: [Your Name] is a water resources engineer with 10+ years of dam design and hydraulic modeling experience.

The design of an ogee spillway centers on creating a shape that mimics the "lower nappe" of a freely falling water jet to ensure hydraulic efficiency and prevent cavitation. To perform these complex calculations effectively in a spreadsheet (like a "design.xls"), the process is typically broken down into determining the design head, calculating the crest profile, and defining the downstream curve. 1. Define Design Parameters

The first step is gathering the hydraulic requirements for the dam. Design Discharge ( ): The peak flood flow the spillway must handle. Design Head ( Hdcap H sub d

): The head above the crest level excluding the velocity of approach. Crest Length ( ): The total width of the spillway opening. 2. Calculate Effective Crest Length

Spreadsheets use the standard weir equation to find the required length or discharge: A standard

Q=CLeHe3/2cap Q equals cap C cap L sub e cap H sub e raised to the 3 / 2 power : Discharge coefficient, typically around for ogee crests at design head. Lecap L sub e : Effective length, adjusted for contractions from piers ( Kpcap K sub p ) and abutments ( Kacap K sub a

Le=L−2(nKp+Ka)Hecap L sub e equals cap L minus 2 open paren n cap K sub p plus cap K sub a close paren cap H sub e 3. Map the Crest Profile (The "Ogee" Shape)

The upstream and downstream curves are defined by coordinates

relative to the crest. Most design spreadsheets follow the USBR (Bureau of Reclamation) standards.

Downstream Profile: Generally follows the power law equation:

y=xnK⋅Hdn−1y equals the fraction with numerator x to the n-th power and denominator cap K center dot cap H sub d raised to the n minus 1 power end-fraction For a vertical upstream face, are standard constants. Have you built a better ogee spreadsheet

Upstream Profile: This usually consists of two or three compound circular arcs to transition the flow smoothly from the reservoir to the crest. 4. Energy Dissipation at the Toe

Once the water reaches the bottom, its kinetic energy must be managed to prevent erosion.

Hydraulic Jump: A stilling basin is designed at the base (the "toe") to force a hydraulic jump, converting high-velocity flow into a deeper, slower-moving state.

Bucket Design: Alternatively, a "roller bucket" or "flip bucket" may be used to deflect the water away from the dam structure. Final Answer Summary

In a design spreadsheet, the ogee spillway is defined by the coordinates of its S-shaped profile, ensuring the water never loses contact with the concrete surface. The key governing equation for the downstream face is Hdcap H sub d is the design head and are constants based on the slope of the upstream face. Hdcap H sub d or a list of USBR constants for different upstream slopes?