Ogee Spillway — Designxls Install Hot!
If you are building or installing a design spreadsheet, organize it into these functional tabs: Functionality Key Inputs Defines project constraints. Peak Flow ( ), Crest Width ( ), Crest Elev. Hydraulics Solves for Hdcap H sub d Cdcap C sub d Iterative solver for Profile Gen Calculates coordinates. Standard USACE/USBR nappe equations. Energy Diss. Designs the Stilling Basin. Conjugate depth, Jump length, Froude Number. 🛠️ "Install" and Setup Guide
xn=K⋅Hdn−1⋅yx to the n-th power equals cap K center dot cap H sub d raised to the n minus 1 power center dot y : Coordinates from the crest origin.
Elias noticed the spreadsheet flagged a potential issue with the bridge piers. The "Piers & Abutments" section allowed him to adjust the Pier Coefficient ( cap K sub p Abutment Coefficient ( cap K sub a ogee spillway designxls install
The design of an ogee crest is dictated by a specific "design head" ( cap H sub d
yHd=−KHdn(x)1.85the fraction with numerator y and denominator cap H sub d end-fraction equals negative the fraction with numerator cap K and denominator cap H sub d to the n-th power end-fraction open paren x close paren to the 1.85 power x, y: Coordinates from the apex of the crest. K, n: Constants depending on upstream slope/friction. If you are building or installing a design
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
automate the complex mathematical iterations required for accurate modeling. ExcelCalcs 1. Installation and Setup Standard USACE/USBR nappe equations
Worth downloading for preliminary hydraulic sizing. It acts as a great independent check against HEC-RAS or HEC-HMS outputs. However, never use the output for final construction drawings without manually verifying the coordinate calculations against standard USBR design charts.
Below is a story about the journey of an engineer, Elias, who uses an "ogee spillway design.xls" tool to tackle a high-stakes project. The Curve of the Nappe
: If you need to modify the underlying calculations, ensure the Developer Tab is visible in Excel (found under File > Options > Customize Ribbon Input Parameters : Standard inputs typically include: Design Discharge ( The peak flow rate the spillway must handle. Design Head ( cap H sub e The depth of water above the crest level. Crest Height ( Height of the spillway crest above the river bed. 3. Key Design Components
The discharge coefficient (C) is often derived from a lookup table. The user must verify that the table ranges match the input units. For example, if the spreadsheet expects H_d in meters but the user inputs feet, the coefficient will be incorrect. No software installation fixes this—it requires manual unit verification.
Any misuse, unauthorised use or copyright infringement of these images whatsoever will be met by criminal and civil litigations WITHOUT FAIL. Comments and problems to Webmaster.