Ogee Spillway Designxls Better < Desktop >

When you submit a hand calculation pack to a senior engineer for review, they must re-enter your numbers into their own calculator to verify you.

To be transparent, not all spreadsheets are created equal. Why is your Ogee Spillway DesignXLS better than a generic one downloaded from a forum?

The Danger: Many free XLS files floating online use the simplified "WES Standard Shape" (P/H_d = Infinity). They fail when you have a submerged crest (low P/H_d ratio < 1.0).

The Solution: A truly better DesignXLS incorporates the U.S. Army Corps of Engineers' revised coefficients (CSCW 1977 data). It includes conditionals:

Furthermore, the best spreadsheets now integrate a Stability Check Tab, verifying that the ogee's concrete block will not slide or tip over its foundation due to hydrodynamic uplift. ogee spillway designxls better

Is “Ogee Spillway Design.xls” better now? Absolutely.

The old spreadsheet was a rite of passage. The new one is a professional productivity tool. It reduces human error, speeds up iteration, and lets you focus on the engineering judgment—not the algebra.

So go ahead. Download or rebuild that spreadsheet. Just promise me you’ll still check your tangent point manually once. Old habits, right?

Have you built a better ogee spreadsheet? Share your favorite feature or a cautionary tale in the comments below. When you submit a hand calculation pack to

About the author: [Your Name] is a water resources engineer with 10+ years of dam design and hydraulic modeling experience.

An ogee spillway is a overflow structure shaped like an inverted “S” (an ogee curve). Its profile ideally matches the lower nappe of a water jet flowing over a sharp-crested weir. When designed correctly, it discharges water efficiently with minimal negative pressure, reducing cavitation risk and structural stress.

Designing one requires solving the crest profile equation (typically the USACE or WES standard form):

[ y = \fracx^1.852 \cdot H_d^0.85 ]

Where ( H_d ) is the design head. The complexity arises from:

A state dam safety office required a 50‑year‑old spillway to be evaluated for a new PMF that was 15% higher. Using a manually prepared ogee sheet, a junior engineer completed the redesign in 2 hours, generating:

The senior reviewer simply inspected the formulas and checked three input values. With dedicated software, the same task would have required exporting data, learning the software’s ogee module, and trusting its hidden interpolation methods.

When you submit a hand calculation pack to a senior engineer for review, they must re-enter your numbers into their own calculator to verify you.

To be transparent, not all spreadsheets are created equal. Why is your Ogee Spillway DesignXLS better than a generic one downloaded from a forum?

The Danger: Many free XLS files floating online use the simplified "WES Standard Shape" (P/H_d = Infinity). They fail when you have a submerged crest (low P/H_d ratio < 1.0).

The Solution: A truly better DesignXLS incorporates the U.S. Army Corps of Engineers' revised coefficients (CSCW 1977 data). It includes conditionals:

Furthermore, the best spreadsheets now integrate a Stability Check Tab, verifying that the ogee's concrete block will not slide or tip over its foundation due to hydrodynamic uplift.

Is “Ogee Spillway Design.xls” better now? Absolutely.

The old spreadsheet was a rite of passage. The new one is a professional productivity tool. It reduces human error, speeds up iteration, and lets you focus on the engineering judgment—not the algebra.

So go ahead. Download or rebuild that spreadsheet. Just promise me you’ll still check your tangent point manually once. Old habits, right?

Have you built a better ogee spreadsheet? Share your favorite feature or a cautionary tale in the comments below.

About the author: [Your Name] is a water resources engineer with 10+ years of dam design and hydraulic modeling experience.

An ogee spillway is a overflow structure shaped like an inverted “S” (an ogee curve). Its profile ideally matches the lower nappe of a water jet flowing over a sharp-crested weir. When designed correctly, it discharges water efficiently with minimal negative pressure, reducing cavitation risk and structural stress.

Designing one requires solving the crest profile equation (typically the USACE or WES standard form):

[ y = \fracx^1.852 \cdot H_d^0.85 ]

Where ( H_d ) is the design head. The complexity arises from:

A state dam safety office required a 50‑year‑old spillway to be evaluated for a new PMF that was 15% higher. Using a manually prepared ogee sheet, a junior engineer completed the redesign in 2 hours, generating:

The senior reviewer simply inspected the formulas and checked three input values. With dedicated software, the same task would have required exporting data, learning the software’s ogee module, and trusting its hidden interpolation methods.