Request a custom version (ARM or MIPS) of USB Network Gate to integrate our technology in your product. Our developers will compile a customized package for your project.
Request custom version
– Implement the compound circular arc formulas. The table below shows the key points for a vertical upstream face:
): Iteratively solved to ensure the design discharge matches the spillway's capacity. Profile Coordinates Table The spreadsheet will generate a long table of coordinates based on the standard USBR equations:
An ogee spillway features an S-shaped curve that closely mimics the underside of a flowing water sheet (nappe) over a sharp-crested weir. The profile is split into two main zones relative to the highest point (the crest apex):
: Verify that the downstream power curve transitions seamlessly into the straight slope of the spillway glacis without any abrupt geometric breaks. ✅ Summary of Ogee Spillway Design Steps
| x (m) | y (m) | |-------|-------| | 0.0 | 0.00 | | 5.0 | 0.64 | | 10.0 | 2.24 | | 15.0 | 4.68 | | 20.0 | 7.92 | | 25.0 | 11.92 | | 30.0 | 16.67 |
Hydraulic engineering is often a balancing act between precision and efficiency. If you’ve ever spent hours manually calculating discharge coefficients or coordinates for a high-head spillway, you know the struggle. That’s why the Ogee Spillway Design XLS is a game-changer for civil and water resource engineers. Why use an Ogee profile?
Elias began entering the project's critical parameters into the spreadsheet. The tool was built around the USBR (U.S. Bureau of Reclamation) standards. He typed in: Design Head ( cap H sub d 10 metres. Spillway Height ( 100 metres above the river bed. Discharge ( Step 2: The Calculation
However, the effective length is reduced by end contractions and pier effects. A commonly used equation from USBR design manuals is:
Under the tab, look for the security warning at the bottom: "This file came from another computer and might be blocked..." Check the Unblock box and click Apply . Step 3: Enabling Macros and VBA Modules
Go to File > Options > Formulas and check "Enable iterative calculation" if your spreadsheet uses trial-and-error loops for tailwater depth.
YHd=−K⋅(XHd)nthe fraction with numerator cap Y and denominator cap H sub d end-fraction equals negative cap K center dot open paren the fraction with numerator cap X and denominator cap H sub d end-fraction close paren to the n-th power = Coordinates relative to the highest point of the crest. Hdcap H sub d = Design head over the crest (excluding velocity head).
Some advanced spillway sheets require Excel's iterative optimization engine to solve non-linear hydraulic equations. Go to . At the bottom, manage Excel Add-ins and click Go .
Many engineers and academics have developed Excel workbooks that implement the entire design procedure. These are not commercial products but are shared through academic repositories, engineering forums, or within consulting firms. A typical template includes the following worksheets:
Stop fighting the formulas and start designing. Whether you're working on a small diversion dam or a major reservoir, let the spreadsheet do the heavy lifting.
– Implement the compound circular arc formulas. The table below shows the key points for a vertical upstream face:
): Iteratively solved to ensure the design discharge matches the spillway's capacity. Profile Coordinates Table The spreadsheet will generate a long table of coordinates based on the standard USBR equations:
An ogee spillway features an S-shaped curve that closely mimics the underside of a flowing water sheet (nappe) over a sharp-crested weir. The profile is split into two main zones relative to the highest point (the crest apex):
: Verify that the downstream power curve transitions seamlessly into the straight slope of the spillway glacis without any abrupt geometric breaks. ✅ Summary of Ogee Spillway Design Steps
| x (m) | y (m) | |-------|-------| | 0.0 | 0.00 | | 5.0 | 0.64 | | 10.0 | 2.24 | | 15.0 | 4.68 | | 20.0 | 7.92 | | 25.0 | 11.92 | | 30.0 | 16.67 |
Hydraulic engineering is often a balancing act between precision and efficiency. If you’ve ever spent hours manually calculating discharge coefficients or coordinates for a high-head spillway, you know the struggle. That’s why the Ogee Spillway Design XLS is a game-changer for civil and water resource engineers. Why use an Ogee profile?
Elias began entering the project's critical parameters into the spreadsheet. The tool was built around the USBR (U.S. Bureau of Reclamation) standards. He typed in: Design Head ( cap H sub d 10 metres. Spillway Height ( 100 metres above the river bed. Discharge ( Step 2: The Calculation
However, the effective length is reduced by end contractions and pier effects. A commonly used equation from USBR design manuals is:
Under the tab, look for the security warning at the bottom: "This file came from another computer and might be blocked..." Check the Unblock box and click Apply . Step 3: Enabling Macros and VBA Modules
Go to File > Options > Formulas and check "Enable iterative calculation" if your spreadsheet uses trial-and-error loops for tailwater depth.
YHd=−K⋅(XHd)nthe fraction with numerator cap Y and denominator cap H sub d end-fraction equals negative cap K center dot open paren the fraction with numerator cap X and denominator cap H sub d end-fraction close paren to the n-th power = Coordinates relative to the highest point of the crest. Hdcap H sub d = Design head over the crest (excluding velocity head).
Some advanced spillway sheets require Excel's iterative optimization engine to solve non-linear hydraulic equations. Go to . At the bottom, manage Excel Add-ins and click Go .
Many engineers and academics have developed Excel workbooks that implement the entire design procedure. These are not commercial products but are shared through academic repositories, engineering forums, or within consulting firms. A typical template includes the following worksheets:
Stop fighting the formulas and start designing. Whether you're working on a small diversion dam or a major reservoir, let the spreadsheet do the heavy lifting.