The spillway doesn't end at the crest. The chute slope changes, boundary layers develop, and air entrainment occurs. An .xls file uses averaged energy equations. It assumes uniform flow velocity immediately after the control section. In reality, the boundary layer grows, and the velocity distribution changes. By the time you reach the stilling basin, your .xls may be off by 15% in conjugate depth calculations.
I’ve seen too many barebones spreadsheets that just copy a table from a textbook. A better XLS for spillway design includes:
| Feature | Why It Matters | | :--- | :--- | | Parametric Crest Shape | Change H_d (design head) and the entire X-Y curve rebuilds automatically. | | Rating Curve Generator | Outputs Q vs. H_w (headwater) for every 0.1m increment. | | Energy Dissipator Sizer | Links the spillway discharge directly to a stilling basin Type III or bucket radius. | | Hydraulic Jump Check | Auto-computes sequent depth and tailwater curve to see if your jump is submerged. | | Unit Conversion Lock | Because mixing meters and feet at 10,000 cfs is a lawsuit waiting to happen. | ogee spillway designxls better
When you submit a hand calculation pack to a senior engineer for review, they must re-enter your numbers into their own calculator to verify you.
Standard references (e.g., USBR Design of Small Dams, EM 1110-2-1603) provide ( C ) vs. ( H/H_d ) tables. Instead of guessing a value, an Excel sheet can interpolate between table points using INDEX and MATCH or FORECAST functions. This eliminates reading errors from printed charts. The spillway doesn't end at the crest
A “better” ogee design .xls goes beyond simple formulas. It includes:
| Module | Purpose | |------------|--------------| | Hydrology Input | Design head, maximum head, upstream slope (vertical, 3:1, etc.), crest length | | Crest Coordinate Generator | Automatically computes x, y from 0 to 4×( H_d ) using WES equation | | Discharge Table | Interpolates ( C ) from H/H_d ratio; checks against maximum expected head | | Pressure Check | Estimates piezometric head at each x; flags potential negative pressures | | Energy Dissipator Sizing | Computes tailwater required for hydraulic jump or flip bucket trajectory | | Plot | Instant scatter plot of crest profile; compares with original nappe curve | It assumes uniform flow velocity immediately after the
If you want to move beyond the default templates, ensure your Ogee Spillway DesignXLS includes these modules: