xn=K⋅Hdn−1⋅yx to the n-th power equals cap K center dot cap H sub d raised to the n minus 1 power center dot y are coordinates, and
Before entering data, ensure the "Settings" or "Inputs" tab is set to your required unit system (SI/Metric or US Customary). Step-by-Step Design Procedure Using the XLS tool typically follows this logical flow: 1. Define Design Inputs You must provide the fundamental hydraulic parameters: Design Head ( Hdcap H sub d ): The maximum head for which the profile is shaped. Design Discharge ( ): The target flow rate. Crest Elevation: The vertical height of the spillway crest. Approach Depth ( ): The height from the upstream floor to the crest. 2. Calculate the Crest Profile ogee spillway designxls install
Open Excel and go to File > Options > Trust Center > Trust Center Settings > Macro Settings . xn=K⋅Hdn−1⋅yx to the n-th power equals cap K
Calculating parameters for the stilling basin. How to Install and Set Up Your Ogee Spillway XLS Design Discharge ( ): The target flow rate
The is a critical hydraulic structure designed to pass floodwater safely over a dam. Because the geometry of an Ogee profile is mathematically complex—governed by the lower nappe of a ventilated sheet of water falling from a sharp-crested weir—using an Ogee spillway design XLS (Excel spreadsheet) is the industry standard for ensuring accuracy and efficiency. What is an Ogee Spillway Design XLS?
"Installation" for an Excel-based design tool is generally straightforward, but requires specific settings to function correctly:
Some Ogee tools require Excel's "Solver" for optimization. Go to File > Options > Add-ins . At the bottom, select Excel Add-ins and click Go . Check Solver Add-in and click OK.