To build a reliable .xls design sheet, you must program the specific geometric equations standardized by the .
This usually indicates that the sheet is utilizing a custom VBA function that Excel cannot read. Ensure macros are completely enabled, or that your Excel version supports the required functions.
is the design total head over the crest (including velocity head).
[Name], P.E. / Hydraulic Engineer
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.
YHd=−K(XHd)nthe fraction with numerator cap Y and denominator cap H sub d end-fraction equals negative cap K open paren the fraction with numerator cap X and denominator cap H sub d end-fraction close paren to the n-th power (Where
The spreadsheet will apply the standard equation for the downstream shape: ogee spillway designxls install
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].
These spreadsheets function as automated design tools. Instead of manually solving complex hydraulic equations (such as the standard weir equation $Q = C L H^3/2$), engineers input specific site parameters, and the spreadsheet instantly calculates the required outputs.
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. To build a reliable
Because manual calculations for the downstream profile, discharge coefficients, and energy dissipation parameters are highly repetitive and iterative, hydraulic engineers heavily rely on Microsoft Excel-based design spreadsheets ( .xls or .xlsm formats).
The values of K and n are tabulated only for specific upstream slopes. If the slope does not exactly match one of the four cases, interpolation may be required, but many engineers simply choose the closest one.
Obtain the trusted ogee_spillway_design.xls file from a reputable engineering resource (e.g., USBR, specialized hydraulics websites, or university design portals). is the design total head over the crest
If the sheet uses automated calculation buttons or custom functions, a yellow message bar will appear: "Security Warning: Macros have been disabled."
When using the design tool, you will need to define the following key parameters [2]: Design Head ( Hdcap H sub d