Ogee Spillway Designxls Better ((free)) -

If you change the design head by 0.5 meters, you risk breaking a hidden reference. If the spillway is broad-crested? Time to start a new sheet from scratch.

Spreadsheets like SPILLWAY.XLS allow engineers to see how discharge capacity ( ) changes with head (

Advanced XLS sheets generate a coordinate text string that can be pasted directly into AutoCAD or Civil 3D to draw the 3D structure instantly. Conclusion ogee spillway designxls better

If you are currently using graph paper, a calculator, and a PDF of USBR Monograph No. 25, you are leaving efficiency on the table.

Using the same spreadsheet, calculate discharge for heads from 0.2Hd to 1.5Hd, generating a complete rating curve. For this example, the rating shows that at the safety check flood level (head = 1.2Hd), the spillway passes 27,800 m³/s — well above the design discharge with adequate freeboard. If you change the design head by 0

Enter the tailwater elevation and channel characteristics. The spreadsheet computes Froude number at the spillway toe and recommends stilling basin Type III dimensions with floor blocks, end sill, and chute blocks.

The discharge coefficient ( Cdcap C sub d Spreadsheets like SPILLWAY

In a design spreadsheet, the is defined by the coordinates of its S-shaped profile, ensuring the water never loses contact with the concrete surface. The key governing equation for the downstream face is Hdcap H sub d is the design head and are constants based on the slope of the upstream face. Hdcap H sub d or a list of USBR constants for different upstream slopes?

The primary discharge equation for an uncontrolled ogee spillway serves as the mathematical core of any design spreadsheet:

If you are building or downloading an ogee spillway design XLS, ensure it includes the following modules: