Click . Only do this if you trust the source of the file. 3. Core Input Parameters Required
If you use circular references (e.g., where Lₑ depends on Hₑ , and Hₑ depends on Lₑ ), Excel must be set to allow iteration:
To avoid re-enabling macros every time:
– Implement the compound circular arc formulas. The table below shows the key points for a vertical upstream face: ogee spillway designxls install
Other available spreadsheets include:
Contrary to what the name might imply, is not a standalone software package. It is a Microsoft Excel-based engineering workbook (a .xls or .xlsm file) developed by hydraulic engineering groups or academic institutions (e.g., IIT Roorkee, USBR, or private engineering GitHub repositories).
Elias noticed the spreadsheet flagged a potential issue with the bridge piers. The "Piers & Abutments" section allowed him to adjust the Pier Coefficient ( cap K sub p Abutment Coefficient ( cap K sub a Core Input Parameters Required If you use circular
An ogee spillway is a type of controlled spillway that uses a curved, S-shaped profile to dissipate excess energy and reduce the risk of erosion downstream. The ogee shape allows for a smooth, gradual transition from the dam to the downstream channel, minimizing turbulence and promoting stable flow. Ogee spillways are widely used in dam construction due to their effectiveness in managing floodwaters and preventing damage to the dam and surrounding infrastructure.
Ogee spillway design, Ogee spillway designXLS install, hydraulic engineering spreadsheet, WES crest curve, USBR spillway design, Excel solver for hydraulics.
Many textbooks state that the effect is negligible when P/Hₑ > 1.33. However, if the dam is low or the reservoir is wide, Vₐ²/(2g) can be significant. Elias noticed the spreadsheet flagged a potential issue
Have a unique installation error? Visit the "Hydraulic Structures" forum on Eng-Tips and post your VBA error code and Excel version for community support.
Several spreadsheet tools are available to assist engineers with ogee spillway calculations. These range from simple discharge calculators to comprehensive hydraulic profiling tools.
Without a proper install, the export button would fail with "Run-time error 1004".
Ogee spillway design requires careful consideration of various factors, including hydraulic performance, structural integrity, and environmental impact. The XLS software provides a powerful tool for designers and engineers to analyze and optimize ogee spillway design. By following the steps outlined in this article, users can successfully install and apply XLS for ogee spillway design, ensuring safe and efficient flood management.