: Right-click the chart axes and manually set the aspect ratio so that on the X-axis equals
Typical discharge coefficients (C d ) range from 2.1 to 2.5. Because Lₑ itself depends on Hₑ , this is an —exactly the kind of repetitive work a spreadsheet handles perfectly.
In Excel, calculate the required discharge coefficient by rearranging the formula, or use a lookup table ( VLOOKUPcap V cap L cap O cap O cap K cap U cap P ) based on the ratio to find the precise Cocap C sub o ogee spillway designxls install
is the design total head over the crest (including velocity head).
Excel is widely used in civil engineering for several reasons: most engineers have Excel installed; the formulas are visible and verifiable (no “black box”); the iterative design loop can be implemented with simple circular references or manual iteration; and the output (coordinates, rating table) can be directly imported into CAD software. This transparency and accessibility make for ogee spillway design outside of large commercial packages. : Right-click the chart axes and manually set
The splash screen loads with input fields for H_d (design head) , P (crest height) , and Upstream slope (vertical:horizontal) .
The "ogee spillway design.xls" (or similar .xls files) is a spreadsheet tool used by civil and hydraulic engineers to automate the complex geometric and hydraulic calculations for an . These tools typically require only a few primary inputs, such as the design head ( Hdcap H sub d ) and spillway height ( Excel is widely used in civil engineering for
While a dedicated “ogee spillway designxls” executable file is not distributed as a standard software package, several spreadsheet‑based and online tools are available that perform the same functions. They fall into two categories: and online calculators .
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):
Once the spreadsheet is open, you will need to enter your specific site data into the designated input cells (usually highlighted in a specific color). Design Head ( Hdcap H sub d