This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.
Using an spreadsheet streamlines the design process for dam engineers. By automating the application of USBR formulas, designers can instantly obtain accurate profiles, ensuring the hydraulic efficiency of the spillway while focusing on overall project optimization. Ensure you enable macros and verify the input parameters to achieve the best results.
A well-designed Excel sheet will immediately compute several tabs or tables of data: Hydraulic Calculations Calculated using the formula Actual Head ( Hecap H sub e ogee spillway designxls install
This comprehensive guide covers everything you need to know about setting up, verifying, and troubleshooting your Excel-based ogee spillway design tool. 1. What is an Ogee Spillway Design Spreadsheet?
The "requirements" for this design tool are minimal: This public link is valid for 7 days
It allows engineers to input specific parameters—such as design head, dam height, and spillway width—to automatically calculate the precise profile coordinates ( coordinates) of the spillway crest. Key Features of a High-Quality Design Spreadsheet: Calculation of coordinates for the upstream and downstream curves [1].
L=L′−2(N⋅Kp+Ka)Hdcap L equals cap L prime minus 2 open paren cap N center dot cap K sub p plus cap K sub a close paren cap H sub d L′cap L prime is the net crest length, is the number of piers, Kpcap K sub p is the pier contraction coefficient, and Kacap K sub a is the abutment contraction coefficient. Downstream Profile Coordinates Can’t copy the link right now
Using a dedicated spreadsheet ( .xls or .xlsx file) for is the standard industry approach for consulting engineers and hydraulic designers. This guide covers the installation, operation, and design principles of these tools. 1. What is an Ogee Spillway Design XLS?
The downstream ogee curve follows the power‑law form: