Ogee Spillway Designxls Better Jun 2026

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.

Using the same spreadsheet, calculate discharge for heads from 0.2Hd to 1.5Hd, generating a complete rating curve. For this example, the rating shows that at the safety check flood level (head = 1.2Hd), the spillway passes 27,800 m³/s — well above the design discharge with adequate freeboard. ogee spillway designxls better

Skeptics argue, "Why use a spreadsheet when we have ANSYS Fluent or OpenFOAM?" Standard references (e

Hydraulic engineering software suites can cost thousands of dollars per seat annually. This eliminates reading errors from printed charts

— Running the spreadsheet for 100 different Hd values, each with corresponding profile updates, generates data for comprehensive design charts — automatically.