: Download the official toolkit archive and extract the file to a dedicated engineering project directory.

The (or overflow spillway) is a fundamental structure in hydraulic engineering, designed to safely pass floodwaters over a dam. Its shape—derived from the lower nappe of a sharp-crested weir—allows for high efficiency, optimizing discharge while minimizing cavitation risks.

SpillwayPro is available for free public download and can be obtained directly from the Bureau of Reclamation's website.

Have a unique installation error? Visit the "Hydraulic Structures" forum on Eng-Tips and post your VBA error code and Excel version for community support.

The spreadsheet automatically processes the inputs to draw the coordinates of the spillway crest. Below is an analytical visualization showcasing how the downstream profile behaves under standard design conditions where 5. Step-by-Step Design Execution Step 1: Calculate Effective Crest Length

The sheet modifies your total width based on contraction losses to find the effective width ( Lecap L sub e

Will your spillway design include , or is it an ungated free-overall crest ? Share public link

It allows for the highest possible discharge for a given head.

The ogee spillway design xls is a useful tool for designing and analyzing ogee spillways. By following the installation and usage steps outlined in this post, you can effectively use the spreadsheet to design and optimize your ogee spillway. Remember to always verify the results and consult with experts if you have any doubts or concerns.

Look for a tab labeled "Chart" or "Profile" to see the visual representation of the spillway.

Le=L−2(N⋅Kp+Ka)Hdcap 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 d is the number of piers, Kpcap K sub p is the pier contraction coefficient, and Kacap K sub a is the abutment contraction coefficient. Step 4: Generating the Crest Coordinates