With a final click, the spreadsheet produced a chart showing the finished profile. At the bottom of the curve, it suggested a reverse curve bucket
Once installed, opening the spreadsheet will present an input dashboard. To generate an accurate ogee profile, you must input data typically derived from hydrological routing and site-specific geotechnical constraints: Parameter Group Specific Variable Unit (SI / US) Engineering Significance Design Discharge ( Peak flood volume the spillway must safely pass. Design Head ( Hdcap H sub d Hecap H sub e Total energy head over the crest, including velocity head. Geometry Spillway Crest Height ( Height of the crest relative to the upstream riverbed. Spillway Clear Width ( Net length of the crest excluding pier widths. Upstream Face Slope Ratio (e.g., Vertical, 3:1) ogee spillway designxls install
Plot these coordinates in Excel to visualize the smooth, continuous curve of the spillway. ✅ Summary With a final click, the spreadsheet produced a
Before installation, you must acquire a reliable Excel template built on established hydraulic criteria, such as the Design of Small Dams or U.S. Army Corps of Engineers (USACE) EM 1110-2-1603 standards. Common Trusted Sources Design Head ( Hdcap H sub d Hecap
The spreadsheet will generate a table of x and y values, usually starting from a negative x (upstream part) to a positive x (downstream nappe). 5. Best Practices & Troubleshooting
4. The Engineering Workflow: How the XLS Tool Calculates the Ogee Shape
When using these spreadsheets, ensure they account for the following critical factors: Hydraulic Design of Stilling Basins and Energy Dissipators