Ogee Spillway Designxls Install Jun 2026
are constants determined by the slope of the upstream face). Visual Chart/Plot
An ogee spillway is a critical hydraulic structure designed to safely release floodwaters from a dam. Designing this S-shaped profile requires precise mathematical modeling to maintain atmospheric pressure along the crest and prevent cavitation. Engineers frequently use Excel spreadsheets (XLS format) to automate these complex hydrodynamic equations.
Ensure the spillway is properly ventilated to maintain atmospheric pressure below the nappe, especially at lower heads. Hdcap H sub d Hmaxcap H sub m a x end-sub : The ogee is designed for a specific design head ( Hdcap H sub d
This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.
Under the tab, look for the security warning at the bottom: "This file came from another computer and might be blocked..." Check the Unblock box and click Apply . Step 3: Enabling Macros and VBA Modules ogee spillway designxls install
ogee spillway designxls install, ogee crest spreadsheet, Wes spillway profile excel, hydraulic design xls, dam spillway template.
If the spillway is gated or bridged, pier contraction coefficients ( Kpcap K sub p ) and abutment contraction coefficients ( Kacap K sub a ) are required. Approach Velocity: Optional, to account for velocity head. 4. Understanding the Automated Outputs
An ogee spillway is a type of spillway used in dams to safely release excess water downstream. The ogee shape allows for a smooth, curved flow of water, reducing the risk of erosion and damage to the dam. Designing an ogee spillway requires careful calculation and analysis to ensure its stability and effectiveness. In this post, we will discuss the design of an ogee spillway using an Excel spreadsheet (xls) and provide a step-by-step guide on how to install and use it.
L=L0−2(N⋅Kp+Ka)Hecap L equals cap L sub 0 minus 2 open paren cap N center dot cap K sub p plus cap K sub a close paren cap H sub e L0cap L sub 0 is the gross clear span, is the number of piers, Kpcap K sub p is the pier contraction coefficient, and Kacap K sub a is the abutment contraction coefficient. Step 2: Determine Design Head Iterate the approach velocity head ( are constants determined by the slope of the upstream face)
The discharge coefficient is not static. The XLS template calculates corrections based on: The height of the spillway ( Submergence effects from downstream tailwater. The slope of the upstream face of the dam. 4. Energy Dissipation & Stilling Basin Design
= Effective length of the crest (accounting for pier and abutment contractions). 2. Downstream Profile Equation
While Excel spreadsheets are powerful tools, users should be aware of their limitations:
= Constants determined by the upstream slope of the dam and velocity of approach. Engineers frequently use Excel spreadsheets (XLS format) to
Are you designing in or Imperial/US Customary units? Share public link
Le=L−2(N⋅Kp+Ka)Hecap L sub e equals cap L minus 2 open paren cap N center dot cap K sub p plus cap K sub a close paren cap H sub e (Where is the number of piers). Phase 2: Determining the Discharge Coefficient ( C0cap C sub 0
The spreadsheet uses empirical formulas to plot the shape of the crest. The downstream profile is generally governed by the standard equation:
To install and run the $Ogee\_Spillway\_Design.xls$ template safely, follow these sequence steps:
Open the file. If prompted, click Enable Content or Enable Macros . The tool relies on VBA scripts to generate the profile coordinates and plots [2].