ogee spillway
The design of an centers on creating a shape that mimics the "lower nappe" of a freely falling water jet to ensure hydraulic efficiency and prevent cavitation. To perform these complex calculations effectively in a spreadsheet (like a "design.xls"), the process is typically broken down into determining the design head, calculating the crest profile, and defining the downstream curve. 1. Define Design Parameters
ogee spillway
In a design spreadsheet, the is defined by the coordinates of its S-shaped profile, ensuring the water never loses contact with the concrete surface. The key governing equation for the downstream face is Hdcap H sub d is the design head and are constants based on the slope of the upstream face. Hdcap H sub d or a list of USBR constants for different upstream slopes?
- DesignXLS Better: A properly coded Ogee Spillway DesignXLS includes lookup logic (using VLOOKUP or INDEX-MATCH arrays) that automatically adjusts the discharge coefficient for the "non-design" operating range. This prevents catastrophic overtopping assumptions.
To make this "Better" than a standard download, implement these three features: