Ogee Spillway Designxls Better [updated] Jun 2026

) by accounting for pier and abutment contraction effects using the standard formula

): If the actual head is lower than the design head, the water exerts positive pressure on the masonry or concrete. This increases structural stability but lowers discharge efficiency. Over-designing (

Numerical And Physical Model Study Related to The Ogee Dam: A Review

Spillway design depends heavily on the Design Discharge Head ( Hdcap H sub d ogee spillway designxls better

In dam engineering, an Ogee spillway is a crucial structure designed with an S-shaped profile to guide overflowing water smoothly, preventing damaging vacuum formation and cavitation Excel-based design tool (XLS)

This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.

: Comprehensive packages available on The Engineering Community include spreadsheets for both spillway design and energy dissipation. ) by accounting for pier and abutment contraction

The sheet calculates the exact point where the ogee profile transitions into a straight tangent slope, followed by the bucket radius calculation required for energy dissipation. Key Features to Look For in a Premium Ogee XLS Template

Add DATA VALIDATION rules to input cells to prevent impossible inputs, such as negative design heads or zero lengths.

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 : Net length of the crest. : Number of piers. Kpcap K sub p : Pier contraction coefficient (depends on pier shape). Kacap K sub a This link or copies made by others cannot be deleted

are the horizontal and vertical coordinates originating from the crest apex.

A well-structured ogee spreadsheet reveals mistakes immediately. If the upstream face slope changes, and the crest shape suddenly looks unrealistic, a conditional formatting rule can flag it. Black-box software may simply produce wrong profiles without warning.