Click . Only do this if you trust the source of the file. 3. Core Input Parameters Required

#CivilEngineering #Hydraulics #WaterResources #SpillwayDesign #EngineeringTools #ExcelForEngineers engineering forum

Key design parameters include:

Use the standard discharge formula to find the required effective length of the crest ( Lecap L sub e

The downstream ogee curve follows the power‑law form:

: ResearchGate hosts Ogee Spillway Profile Spreadsheets that calculate downstream profiles and water nappes based on standard USBR dimensionless values. Installation and Setup Procedures

are constants determined by the slope of the upstream face). Visual Chart/Plot

The XLS file calculates these constants and outputs a clean table of coordinates. 3. Discharge Coefficient ( Cdcap C sub d ) Correction

): The depth of water above the spillway crest during peak flow.

If a yellow warning bar appears at the top saying click Enable Content .

The spreadsheet will apply the standard equation for the downstream shape:

An Ogee spillway design XLS is a pre-configured computational tool that automates the hydraulic and geometric calculations required for spillway construction. These spreadsheets typically use formulas derived from the or the U.S. Army Corps of Engineers (USACE) standards. Key features usually include: Discharge Coefficient Calculation (

The primary formula used to evaluate the spillway length or head requirement is: