Ogee Spillway Designxls Install !free!

If Excel throws a circular reference error, go to File > Options > Formulas , and check the box for "Enable iterative calculation." This is often required for hydraulic routing equations.

Understanding what happens behind the user interface ensures you can audit the results for safety. The spreadsheet uses a sequence of mathematical calculations based on the profile: Phase 1: Effective Crest Length Calculation

Follow these steps to successfully use an ogee spillway design template in Excel. Step 1: Obtain the Spreadsheet ogee spillway designxls install

Q=C⋅L⋅Hd1.5cap Q equals cap C center dot cap L center dot cap H sub d to the 1.5 power = Discharge capacity.

Modern versions of Microsoft Excel automatically block macros in files downloaded from the internet to protect against security risks. If Excel throws a circular reference error, go

): The speed of the water approaching the structure, used to compute the approach velocity head (

This type of spreadsheet is particularly useful for sizing a spillway to accommodate the Probable Maximum Flood (PMF) and for evaluating peak water levels. Step 1: Obtain the Spreadsheet Q=C⋅L⋅Hd1

| Component | Requirement | |-----------|--------------| | | Windows 10, 11 (64-bit) or macOS with Parallels/VMware | | Excel Version | Microsoft Excel 2016 or later (Office 365 recommended) | | Memory | 4 GB RAM minimum | | Add-ins | Solver Add-in and Analysis ToolPak must be enabled | | Macros | Must allow signed macros (for .xlsm versions) |

For a vertical upstream face, the profile of the downstream quadrant is generally expressed using the standard power equation:

The spreadsheet will typically compute:

Prevents sub-atmospheric pressure on the crest, reducing the risk of cavitation.