where K and n depend on the upstream slope:
A built-in scatter chart automatically plots the
If you use circular references (e.g., where Lₑ depends on Hₑ , and Hₑ depends on Lₑ ), Excel must be set to allow iteration:
India is the birthplace of four major world religions——and hosts significant populations of Muslims and Christians. ogee spillway designxls install
The downstream ogee curve follows the power‑law form:
It allows engineers to input specific parameters—such as design head, dam height, and spillway width—to automatically calculate the precise profile coordinates ( coordinates) of the spillway crest. Key Features of a High-Quality Design Spreadsheet: Calculation of coordinates for the upstream and downstream curves [1].
An energy dissipator—such as a stilling basin or a hydraulic jump—must be designed downstream. The spreadsheet should include auxiliary calculations for basin length, floor elevation, and the conjugate depth of the hydraulic jump. where K and n depend on the upstream
Indian culture has a deep respect for ritualistic cleaning. The day often starts with Jharu-Pocha (sweeping and mopping). Many households draw Rangoli (colored powder art) at the entrance every morning.
This usually indicates that the sheet is utilizing a custom VBA function that Excel cannot read. Ensure macros are completely enabled, or that your Excel version supports the required functions.
If Excel throws a circular reference error, go to File > Options > Formulas , and check the box for "Enable iterative calculation." This is often required for hydraulic routing equations. An energy dissipator—such as a stilling basin or
A curve defined by the standard power equation:
OSD-2026-001 Date: April 19, 2026 Prepared by: [Your Name/Organization] Subject: Documentation of installation procedure and functionality check for the Ogee Spillway Hydraulic Design Spreadsheet ( Ogee_Spillway_Design.xls )
By following the step‑by‑step methodology described above—from entering input data and iterating for the design head to generating the upstream and downstream profiles and verifying the design with HEC‑HMS or CFD—you can confidently design an ogee spillway that meets both hydraulic and structural requirements. The spreadsheet not only saves time but also reduces the risk of manual calculation errors, allowing you to focus on the more creative aspects of hydraulic design: optimizing the crest length, selecting the most efficient energy dissipator, and ensuring the long‑term safety of the dam.
Go to and ensure "Disable all macros with notification" is selected so you can approve the script. 3. Input Design Parameters
Determination of the discharge coefficient ( ) based on head ratio [2].