The spreadsheet uses these parameters to calculate:
In the world of dam design and hydraulic engineering, few structures are as critical—or as mathematically demanding—as the . Named for its distinctive S-shaped curve that mimics the profile of a falling nappe (water jet), the Ogee spillway is the gold standard for controlling reservoir overflow while maintaining structural integrity.
: If downloaded as a .zip , extract the files to a dedicated project folder to maintain internal cell references if applicable. ogee spillway designxls install
Ensure the file extension is .xls (Excel 97-2003) or .xlsm (Macro-Enabled Workbook), as these tools often use VBA scripts for iterative calculations like discharge coefficients ( Cdcap C sub d 2. Enable Macros and Content
To avoid re-enabling macros every time:
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.
An ogee spillway is a commonly used overflow crest shape for dams and spillways, designed to match the lower nappe profile of a prismatic structure under free-flowing conditions. Its curved profile minimizes flow separation and energy losses, providing efficient discharge and predictable hydraulic performance for overtopping flows. The spreadsheet uses these parameters to calculate: In
Usually vertical or inclined (e.g., 3H:1V). 4. Verify Profile Coordinates The spreadsheet will automatically generate a table of coordinates for the downstream profile.
Installing these tools generally does not involve a standard software installer. Instead, it involves configuring a pre-built Excel environment. Ensure the file extension is
, 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