Ogee Spillway Designxls Better -
: Comprehensive packages available on The Engineering Community include spreadsheets for both spillway design and energy dissipation.
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.
What are you following? (e.g., USBR , USACE , or Indian Standards/IS codes )
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
An advanced XLS workbook automates these checks instantly using integrated lookup logic. Engineering Attribute Manual Calculation / Legacy Methods Spreadsheet Modeling (XLS) Dedicated Hydrology Software Very Slow (Hours per iteration) Instantaneous (Sub-second updates) Moderate (Requires re-running scripts) Error Vulnerability High math and interpolation risks Low (Locked formula framework) Low (Black box algorithm) Data Visibility Fragmented across design sheets Completely open math transparently Hidden behind user interfaces Cost & Portability Low software cost but high labor Free templates with basic software Expensive annual licensing 2. Math Behind Ogee Design Automation
When operating at the design head, the water glides smoothly over the concrete surface, exerting near-atmospheric pressure on the crest. If the profile is built incorrectly:
If you’ve ever designed a concrete gravity dam, you know the Ogee spillway is both a thing of beauty and a hydraulic headache. Getting that perfect “S” curve—where the lower nappe of the waterfall just kisses the crest—requires iteration. If you share with third parties, their policies apply
— A complete spillway design extends beyond the crest to include the stilling basin. Excel excels at simulating flow through rectangular open channel sections, calculating critical depths, Froude numbers, hydraulic jump properties, and basin lengths. When seasonal flow changes occur, these same spreadsheets can simulate performance under reduced discharge conditions — all while keeping channel dimensions constant.
A data table using the power equation ( xnx to the n-th power
First, I have written a suitable for an article or blog post discussing the subject as a whole. Second, I have provided a template for reviewing specific content creators or channels in this niche. What are you following
) : Typically ranges between (in metric units). A well-designed crest can achieve a coefficient of up to 3.90 (English units) at design head. Effective Length ( Lecap L sub e
across a wide spectrum of water surface elevations, outputting a precise rating curve essential for reservoir routing calculations. Feature Comparison: Excel vs. Commercial Software Feature Vector Excel Spreadsheet ( .xls ) Specialized Hydraulic Software Instantly accessible Long installation & license activation Formula Auditability Open-source, cell-by-cell verification Closed-source, hidden calculations Parametric Optimization Extremely fast using native Excel Solver Slow, manual geometry rebuilding Output Flexibility Native copying to Word/PDF reports Rigid, pre-formatted PDF exports Cost Profile Free (Leverages existing office suite) Expensive recurring annual licensing Best Practices for Building a Robust Design Sheet
— Include comparison tables to published example designs. If your spreadsheet outputs deviate from known results, you'll catch the error early.
Here is the definitive technical breakdown.
To map an ogee profile downstream of the crest, engineers generally use empirical equations established by organizations like the United States Bureau of Reclamation (USBR) or the U.S. Army Corps of Engineers (WES). A standard downstream profile equation takes the form:
