Works with any scanner or MFD
If your scanner or multi-function device can save to a Windows folder then it will work with filestar.
Ogee Spillway Designxls Better -
The downstream profile is defined by the equation: $$X^n = K \cdot H_d \cdot Y$$ Where $n$ and $K$ depend on the upstream slope.
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.
When it comes to the complex, iterative task of designing an ogee spillway, Excel remains superior. It demystifies the engineering process, handles iterative loops effortlessly, provides absolute control over coefficients, and generates visual outputs instantly. While 3D CFD models can verify performance, the XLS sheet is the ideal tool for initial design and ensuring hydraulic safety. After all, building a better XLS means building a safer, more cost-effective dam. ogee spillway designxls better
Unlike hydraulic modeling suites (HEC-RAS, Fluent, etc.), Excel is universally available. An .xls or .xlsm file can be emailed, reviewed, and run by any engineer with Microsoft Excel or LibreOffice Calc. This is critical for small firms, international projects, or field offices.
Automated cells that compute the effective spillway length, discharge coefficients, and the total design head. The downstream profile is defined by the equation:
): Computes how incoming water speed affects the total energy head. Discharge Coefficient ( Cdcap C sub d
The biggest risk of the "better XLS" is . A junior engineer copies the template from a previous dam project with a different crest shape (e.g., vertical vs. 3:1 upstream slope). They paste values, but forget to update the $K$ coefficient lookup. The spillway looks fine on paper, but during the first flood test, the profile creates a vacuum that collapses the concrete lining. This is not hyperbole; this has happened. Instead of guessing a value, an Excel sheet
= Variable discharge coefficient (which changes based on approach depth, upstream face slope, and submergence effects).
[Input Data] -> [Hydraulic Parameters] -> [Coordinate Generation] -> [CAD String / Plot] Clearly marked fields for Design Discharge (
So go ahead. Download or rebuild that spreadsheet. Just promise me you’ll still check your tangent point manually once. Old habits, right?
