If the spillway is gated, the discharge equations become more complex because partial gate openings generate orifice flow. The spreadsheet can be expanded to include a gate sub‑model. For a gated ogee spillway, the discharge is given by:
Dimensions of chute blocks, baffle piers, and end sills (matching USBR Basin types). How to Download, Install, and Set Up the XLS Tool
, or overflow spillway, is a critical hydraulic structure used primarily with gravity dams to release excess floodwater safely. Its characteristic S-shaped profile is designed to mimic the lower nappe of a freely falling water jet, ensuring the water maintains contact with the structure to prevent cavitation and sub-atmospheric pressure. Modern engineering relies on Excel-based tools (XLS) to automate the complex iterative calculations required for these profiles. 2. Core Design Principles ogee spillway designxls install
Utilizing an method is essential for modern hydraulic engineering. It ensures that the spillway crest is optimized for flow efficiency while maintaining structural integrity. By adhering to established USBR standards, these tools provide a reliable foundation for designing safe and efficient dam spillways.
Elias began entering the project's critical parameters into the spreadsheet. The tool was built around the USBR (U.S. Bureau of Reclamation) standards. He typed in: Design Head ( cap H sub d 10 metres. Spillway Height ( 100 metres above the river bed. Discharge ( Step 2: The Calculation If the spillway is gated, the discharge equations
Before using the spreadsheet for any real project, run it with the example data from a trusted source. The 12000 m³/s problem mentioned earlier is ideal. If the spreadsheet’s final head differs from the manual solution by more than 2%, debug the formulas.
xn=K⋅Hdn−1⋅yx to the n-th power equals cap K center dot cap H sub d raised to the n minus 1 power center dot y : Coordinates from the crest origin. How to Download, Install, and Set Up the
to safely turn the high-velocity water and create a hydraulic jump, dissipating energy before it reached the riverbed. Key Features of a Spillway XLS Tool
[Name], Project Manager
The spreadsheet produces a table of head vs. discharge. For example: