An energy dissipator—such as a stilling basin or a hydraulic jump—must be designed downstream. The spreadsheet should include auxiliary calculations for basin length, floor elevation, and the conjugate depth of the hydraulic jump.
Contrary to what the name might imply, is not a standalone software package. It is a Microsoft Excel-based engineering workbook (a .xls or .xlsm file) developed by hydraulic engineering groups or academic institutions (e.g., IIT Roorkee, USBR, or private engineering GitHub repositories).
and HEC‑HMS – While these are full hydraulic modeling packages, they are often used in conjunction with spreadsheet pre‑design. As described in a US Bureau of Reclamation case study, initial spreadsheet calculations size the ogee weir; those dimensions are then verified in HEC‑HMS and HEC‑RAS simulations.
) matching USBR standards. Use conditional IF statements in Excel to map these coordinates for negative -values stretching from the apex back to the dam face. Step 5: Plotting the Profile and Automating Output ogee spillway designxls install
The spreadsheet handles all the arithmetic, so the user may stop thinking about the hydraulics.
: For the tool to calculate correctly, you must input initial geometric data such as the Spillway Approach Height (crest elevation minus mean ground elevation upstream) and the Design Energy Head ( HDcap H sub cap D
Visual verification eliminates data entry bugs before they reach design software. Highlight your calculated An energy dissipator—such as a stilling basin or
Living the Indian lifestyle requires a specific kind of patience. It is loud. The traffic is a nightmare. The bureaucracy is slow. But the heart is fast.
– Create a table of heads H from 0.2 H d to 1.4 H d . For each, compute H/H d , look up C/C d (from an embedded lookup table or a fitted curve), then compute discharge Q = C·Lₑ·H³/² .
Beichley and A. J. Peterka; Hyd-445 dated April 28, 1961, by A. J. Peterka; Hyd-446 dated April 18, 1960, by G. L. Beichley and A. Bureau of Reclamation (.gov) (PDF) Ogee Spillway Profile: Spreadsheet - ResearchGate It is a Microsoft Excel-based engineering workbook (a
The connecting arcs are drawn with radii R₁ = 0.50·H d = 8.35 m and R₂ = 0.20·H d = 3.34 m.
The spreadsheet appears to produce plausible numbers, so testing is skipped.