An ogee spillway is a type of overflow spillway that consists of a curved, smooth, and continuous surface, typically with a crest shape that follows an ogee curve. The ogee curve is a mathematical curve that provides a smooth, flowing shape, allowing water to flow freely over the spillway crest without separation or cavitation. The design of an ogee spillway involves determining the crest shape, spillway width, and other geometric parameters to ensure safe and efficient operation.
ratios to ensure the design remains within standard WES profiles. 2. Why a "Better" XLS Spreadsheet is Critical
Expensive proprietary hydraulic software operates as a "black box," hiding the underlying code. An Excel sheet keeps formulas completely visible. Engineers can audit the cell logic, check unit conversions, and verify compliance with international standards like or USACE EM 1110-2-1603 . 4. Seamless CAD Integration
): If the actual head exceeds the design head, the water sheet pulls away from the concrete surface. This creates low-pressure zones or vacuums, leading to , severe pitting, and structural failure. 2. The Downstream Profile ogee spillway designxls better
Your Excel sheet must use lookup tables or polynomial equations matching USBR curves to automatically adjust based on the height of the spillway ( ) relative to Hdcap H sub d Step 3: Generate the Coordinate Matrix
Typing these into an XLS with a 0.1m step size gives you instant coordinates for formwork fabrication. No manual table lookups, no rounding errors.
The spreadsheet outputs X-Y coordinates for the spillway crest at intervals of 0.1Hd, creating a table that can be exported directly to CAD. The profile table follows standardized formats. An ogee spillway is a type of overflow
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, Kpcap K sub p is the pier contraction coefficient, and Kacap K sub a is the abutment contraction coefficient). Moving Beyond the Spreadsheet: The Hybrid Workflow
: The smooth curve minimizes turbulence and vibrations, making it ideal for concrete gravity, arch, and buttress dams.
— The discharge coefficient C depends on H/Hd ratio, but many designers incorrectly use a constant value. Your spreadsheet should vary C with head, referencing standard tables. ratios to ensure the design remains within standard
Allowing designers to see how changing Hdcap H sub d affects the spillway profile and Cdcap C sub d 3. Key Design Equations Used in Excel An optimized spreadsheet automates these crucial equations: Discharge Equation: Hecap H sub e is the total head. Downstream Profile (WES):
Utilize IF statements or separate calculation lines to handle the compound radii of the upstream quadrant. Step 4: Automate the Energy Dissipator Connection