You have used ogee_spillway_design_v3_final_actual.xls for 15 years. Here is how to pivot:
The biggest risk of the "better XLS" is cell reference corruption. A junior engineer copies the template from a previous dam project with a different crest shape (e.g., vertical vs. 3:1 upstream slope). They paste values, but forget to update the $K$ coefficient lookup. The spillway looks fine on paper, but during the first flood test, the profile creates a vacuum that collapses the concrete lining. This is not hyperbole; this has happened.
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.
Hydrology inputs (inflow hydrographs, tailwater curves) are often already in Excel tables. An ogee design sheet can link directly to those ranges, creating a dynamic model where a change in probable maximum flood (PMF) automatically redesigns the spillway crest.
If you’ve ever designed an ogee spillway, you know the drill.
You pull out your copy of USBR’s Design of Small Dams or EM 1110-2-1603, flip to the discharge coefficient tables, and start punching numbers into a generic Excel sheet. You spend hours debugging lookup tables for the upstream face slope, fiddling with unit conversions, and praying you didn’t mis-type the design head (H(_d)) relationship.
For years, the industry standard has been some version of “Ogee Spillway Design.xls” — a valiant, useful, but often clunky tool.
Today, I want to show you why that classic spreadsheet just got significantly better.
Remember the two equations?
Typing these into an XLS with a 0.1m step size gives you instant coordinates for formwork fabrication. No manual table lookups, no rounding errors.
In manual methods, adjusting ( H_d ) requires re-tabulating the entire crest profile and recomputing discharge. In Excel, change one cell and all downstream calculations—ordinates, velocities, Froude numbers, and energy balance—update instantly. This allows rapid optimization for site-specific hydrology.
If you build the spreadsheet according to this specification, your "Deep Content" includes:
This approach moves the tool from a "calculator" to a "Design Optimization Tool."
You have used ogee_spillway_design_v3_final_actual.xls for 15 years. Here is how to pivot:
The biggest risk of the "better XLS" is cell reference corruption. A junior engineer copies the template from a previous dam project with a different crest shape (e.g., vertical vs. 3:1 upstream slope). They paste values, but forget to update the $K$ coefficient lookup. The spillway looks fine on paper, but during the first flood test, the profile creates a vacuum that collapses the concrete lining. This is not hyperbole; this has happened.
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. ogee spillway designxls better
Hydrology inputs (inflow hydrographs, tailwater curves) are often already in Excel tables. An ogee design sheet can link directly to those ranges, creating a dynamic model where a change in probable maximum flood (PMF) automatically redesigns the spillway crest.
If you’ve ever designed an ogee spillway, you know the drill.
You pull out your copy of USBR’s Design of Small Dams or EM 1110-2-1603, flip to the discharge coefficient tables, and start punching numbers into a generic Excel sheet. You spend hours debugging lookup tables for the upstream face slope, fiddling with unit conversions, and praying you didn’t mis-type the design head (H(_d)) relationship. You have used ogee_spillway_design_v3_final_actual
For years, the industry standard has been some version of “Ogee Spillway Design.xls” — a valiant, useful, but often clunky tool.
Today, I want to show you why that classic spreadsheet just got significantly better.
Remember the two equations?
Typing these into an XLS with a 0.1m step size gives you instant coordinates for formwork fabrication. No manual table lookups, no rounding errors.
In manual methods, adjusting ( H_d ) requires re-tabulating the entire crest profile and recomputing discharge. In Excel, change one cell and all downstream calculations—ordinates, velocities, Froude numbers, and energy balance—update instantly. This allows rapid optimization for site-specific hydrology.
If you build the spreadsheet according to this specification, your "Deep Content" includes: The senior reviewer simply inspected the formulas and
This approach moves the tool from a "calculator" to a "Design Optimization Tool."