Because these tools use advanced formulas, lookup tables, and often Visual Basic for Applications (VBA) macros to automate coordinate generation, a simple double-click might not unlock full functionality. Follow these steps to correctly install and configure the file: Step 1: Secure the File Placement
The spreadsheet will generate a series of (x, y) coordinates defining the shape of the crest using standard USBR formulas.
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
An ogee spillway features an S-shaped (or ogee) profile that closely matches the underside of a nappe flowing over a sharp-crested weir. Designing this profile manually requires tedious, iterative calculations. Using an automated Excel spreadsheet accelerates the workflow while maintaining high mathematical precision. 1. System Requirements & Spreadsheet Installation ogee spillway designxls install
This occurs when text characters are typed into numerical input fields, or if there is a conflict between unit systems (mixing meters and feet). Check that your inputs match the designated units of the sheet.
, program the cell to display a red warning using conditional formatting.
If you use circular references (e.g., where Lₑ depends on Hₑ , and Hₑ depends on Lₑ ), Excel must be set to allow iteration: Because these tools use advanced formulas, lookup tables,
The spreadsheet automatically loops through incremental values of (horizontal distance from the crest origin) to solve for
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:
An ogee spillway is a critical hydraulic structure designed to safely release floodwaters from a dam. Designing one requires precise mathematical calculations to map the profile of the spillway crest, ensuring optimal discharge efficiency while preventing dangerous sub-atmospheric pressures. Hdcap H sub d Hmaxcap H sub m
Will your project require custom components like or an attached stilling basin ?
The (often referred to as “ogee spillway designxls”) is an indispensable tool for modern hydraulic engineers. It automates the iterative calculations, generates precise profile coordinates, and produces a complete rating table—all within a transparent, auditable Excel environment. There is no single “installer” to download; instead, the engineer either builds the template from the formulas presented in this article or adapts an example template from a reliable academic source.