Most junior engineers forget this until the shop drawing phase. A good XLS template automatically calculates velocity head at each station and flags you when H_v > 12m . That’s when you know you need aeration slots.
— Perhaps one of the most practical advantages: Excel can feed coordinates directly into CAD software. Engineers can import coordinate data from spreadsheets into AutoCAD and use the SPLINE command to rapidly generate accurate ogee profiles. This combination eliminates the tedious manual plotting that historically consumed hours of drafting time.
Spreadsheets like SPILLWAY.XLS allow engineers to see how discharge capacity ( ) changes with head (
: Sites like ExcelCalcs host user-submitted tools for gravity dam and spillway design. Ogee Spillway Design and Calculations | PDF - Scribd ogee spillway designxls better
Some engineers might ask: with CFD, FEM, and ANN models available for spillway analysis, why rely on Excel? The answer lies in complementarity, not replacement.
If you build the spreadsheet according to this specification, your "Deep Content" includes:
results in an under-designed crest profile, risking cavitation. Ensure your Excel tool computes Hecap H sub e rather than relying purely on Hdcap H sub d Never hardcode empirical factors like Most junior engineers forget this until the shop
is negligible. For shallow channels or high-velocity channels, failing to add the velocity head (
) to ensure the spillway functions safely during smaller, everyday flow events. Conclusion
) starting from negative values (upstream) to positive values (downstream). — Perhaps one of the most practical advantages:
The use of Excel for ogee spillway design offers several benefits, including:
An advanced Excel sheet automates the standard equations defined by the United States Bureau of Reclamation (USBR) and the U.S. Army Corps of Engineers (USACE). 1. Discharge Capacity Equation The total flow rate ( ) passing over the crest is calculated using: