Ogee Spillway Designxls Install -
YHd=−K(XHd)nthe fraction with numerator cap Y and denominator cap H sub d end-fraction equals negative cap K open paren the fraction with numerator cap X and denominator cap H sub d end-fraction close paren to the n-th power Where constants depend entirely on the slope of the upstream face.
Calculating the upper nappe, which defines the required training wall height. 3. Ogee Spillway DesignXLS Install & Usage Guide
Click the macro button . The spreadsheet will:
SpillwayPro is available for free public download and can be obtained directly from the Bureau of Reclamation's website. ogee spillway designxls install
In the field of hydraulic engineering, the design of a spillway is one of the most critical tasks for dam safety. Among the various types, the —characterized by its distinctive S-shaped profile that ideally matches the lower nappe of a flowing water jet—is preferred for its high discharge efficiency. However, its design involves solving complex weir equations, determining discharge coefficients, and shaping the crest profile to prevent cavitation. Traditionally, this required iterative manual calculations or expensive proprietary software. The emergence of specialized spreadsheet tools, such as the file “Ogee Spillway Design.xls” , has democratized this process. This essay provides a comprehensive guide to installing, verifying, and utilizing this essential spreadsheet tool, while also discussing its limitations and best practices for professional application.
However, designing one from scratch involves solving tedious polynomial equations, checking discharge coefficients, and iterating over crest shapes. Enter —a specialized, Excel-based spreadsheet tool that automates these complex calculations.
Once your spreadsheet is built, you would use it to follow a standard Ogee spillway design procedure: Ogee Spillway DesignXLS Install & Usage Guide Click
The discharge coefficient (C) is often derived from a lookup table. The user must verify that the table ranges match the input units. For example, if the spreadsheet expects H_d in meters but the user inputs feet, the coefficient will be incorrect. No software installation fixes this—it requires manual unit verification.
The sheet calculates the minimum radius (
In practical terms, it looks like a street vendor using an old iron to iron clothes while powered by a car battery, or a kid turning a broken plastic bottle into a watering can. For the average Indian, Jugaad isn’t about cutting corners; it is about resilience. It is the quiet confidence that no matter how broken something is, you can make it work . Among the various types, the —characterized by its
If your spreadsheet relies on custom add-ins (like Excel's native Solver add-in for optimization), go to , click Go... next to Excel Add-ins, and check Solver Add-in . Step 4: Verification with a Benchmark Problem
Understanding what happens behind the user interface ensures you can audit the results for safety. The spreadsheet uses a sequence of mathematical calculations based on the profile: Phase 1: Effective Crest Length Calculation
The downstream profile of an ogee crest is represented by the power equation:
The spreadsheet works by solving the USBR standard formula for the ogee shape. For a vertical upstream face, the profile is typically defined by:
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