Ogee Spillway Designxls Install 【2026】

– Headings and input cells for: design discharge (Q), number of spans, clear span width, pier thickness, downstream face slope (H:V), height of spillway crest above river bed (P), freeboard, and desired discharge coefficients.

To allow the spreadsheet to run iterative hydraulic calculations via macros: Open Microsoft Excel. ogee spillway designxls install

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. – Headings and input cells for: design discharge

| Worksheet | Purpose | |-----------|---------| | | Enter design discharge, number of spans, pier dimensions, slope, etc. | | Effective Length | Calculates L' , then iterates Hₑ using the weir equation. | | Upstream Profile | Computes the coordinates of the upstream quadrant. | | Downstream Profile | Computes x and y coordinates for the ogee curve. | | Rating Curve | Generates a table of discharge versus reservoir water level. | | Energy Dissipator | Sizes the stilling basin (e.g., USBR Type III). | | Output | Summary table of all key parameters and profile coordinates. | K, n: Constants depending on upstream slope/friction

The factor N is the number of intermediate piers (not including the abutments). For N spans, there are N‑1 intermediate piers. Use that value in the equation. The abutment contraction coefficient Kₐ is applied only once per side (hence the factor 2). Always double‑check the notation in the reference manual you are following.

Keep in mind that a spreadsheet is only as good as the inputs and assumptions used. It's essential to verify the calculations and outputs with a qualified engineer or expert in hydraulic design.

However, designing one from scratch involves solving tedious polynomial equations, checking discharge coefficients, and iterating over crest shapes. Enter —a specialized, Excel-based spreadsheet tool that automates these complex calculations.