Ogee Spillway Designxls Better
The gross crest length is based on the number of spans. The total length of the spillway is calculated by multiplying the number of spans by the length of each span. For example, for 5 spans each of 12.5 meters, the total length is 5 × 12.5 m = 62.5 m .
In dam engineering, an Ogee spillway is a crucial structure designed with an S-shaped profile to guide overflowing water smoothly, preventing damaging vacuum formation and cavitation Excel-based design tool (XLS)
) and allows for the rapid generation of precise coordinate tables for the upstream and downstream profiles. Why Spreadsheet Design is Better Iterative Accuracy : Determining the effective head ( cap H sub e
) to map out the downstream coordinates until it meets the tangent slope.
Formulas calculating the two or three radii ( ogee spillway designxls better
The downstream curve generally adheres to the standard USBR shape parameter equation:
If you must use Excel because your firm is slow to change, make it by:
To build a high-utility ogee design template, organize your Excel workbook into three distinct functional sections. Section 1: Input Parameters
Add a conditional formatting rule that turns the cell red if your crest pressure drops below -0.5 psi. That’s your cavitation warning. No expensive license required. The gross crest length is based on the number of spans
This section determines the actual head operating the spillway.
A or bucket is required at the toe to dissipate kinetic energy through a hydraulic jump. Pressure Checks Designers must ensure that at heads greater than Hdcap H sub d
| Upstream Slope | ( K ) | ( n ) | |---|---|---| | Vertical | 2.000 | 1.850 | | 1:3 (H:V) | 1.936 | 1.836 | | 2:3 (H:V) | 1.936 | 1.810 | | 3:3 (H:V) | 1.873 | 1.776 |
Adopt an industry-standard color schema. Use light yellow or blue fills exclusively for user inputs, and keep white or gray backgrounds for locked, formula-driven calculations. In dam engineering, an Ogee spillway is a
Sub ExportToCAD() Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("Geometry") ws.Range("B2:C100").Copy ' Copy X and Y columns ' Create a text file or simply message box that data is ready MsgBox "Coordinates copied! Paste into AutoCAD command line.", vbInformation End Sub
A 50-line Python script using numpy and scipy.optimize can solve the complete ogee profile, including the elliptical upstream quadrant, to micro-inch precision. It can then export the cut/fill coordinates directly to a CAD file (DXF). No VBA crashes. No manual file management.
Always have a real-time graph of the profile, ensuring the shape updates automatically when the inputs change.
Create a structured table that calculates individual points along the physical concrete surface. X-Coordinate ( Formula for X Y-Coordinate ( Formula for Y Manual Increment Upstream Curve Formula Upstream Face Manual Increment Upstream Curve Formula Upstream Slope Reference Zero Reference Zero Crest Origin Increment Step =-0.50*(X^1.85)/(Hd^0.85) Downstream Curve Increment Step =-0.50*(X^1.85)/(Hd^0.85) Downstream Curve Mitigating Cavitation Risks via Spreadsheet Analysis
This is the core value add. Instead of one equation, we generate a table of coordinates to export to CAD.