By: Senior Hydraulic Engineer, Water Resources Group
Typing these into an XLS with a 0.1m step size gives you instant coordinates for formwork fabrication. No manual table lookups, no rounding errors. ogee spillway designxls better
cap L sub e equals cap L minus 2 open paren cap N center dot cap K sub p plus cap K sub a close paren cap H sub e : Number of piers. cap K sub p : Pier contraction coefficient (e.g., for rounded nose). cap K sub a : Abutment contraction coefficient (e.g., for rounded abutments). Iterate for Convergence Re-calculate cap H sub e cap L sub e until the value stabilizes. Define the Downstream Profile Use the WES-standard equation for a vertical upstream face: Why "Ogee Spillway Design
Use a Data Table to show how Crest Length ($L$) changes with varying Head ($H$). cap K sub p : Pier contraction coefficient (e
Deriving the tangency point between the crest curve and the downstream slope requires iterative solving. Doing this by hand takes 45 minutes per iteration. Using the Ogee Spillway DesignXLS, it takes 2 seconds.