Use Excel’s power functions ( = -$K$ * ($x$ / $H_d$)^$n$ * $H_d$ ) to populate the downstream vertical drop (
The spreadsheet outputs X-Y coordinates for the spillway crest at intervals of 0.1Hd, creating a table that can be exported directly to CAD. The profile table follows standardized formats.
Le=L−2(nKp+Ka)Hecap L sub e equals cap L minus 2 open paren n cap K sub p plus cap K sub a close paren cap H sub e : Number of piers. Kpcap K sub p : Pier contraction coefficient (typically to ). Kacap K sub a : Abutment contraction coefficient (typically to ). 4. Key Design Considerations (PDF) Ogee Spillway Profile: Spreadsheet - ResearchGate ogee spillway designxls better
Almost every engineering firm uses Microsoft Excel, making XLS files highly portable. You can share a design spreadsheet with clients, reviewers, or field teams without worrying about software compatibility or expensive user licenses.
are the horizontal and vertical coordinates originating from the crest apex. Use Excel’s power functions ( = -$K$ *
) : Calculated by adjusting the net length for the presence of piers and abutments using the formula:
Engineers frequently choose Excel over black-box software for several distinct reasons: Instant Iteration on Design Head ( Hdcap H sub d Kpcap K sub p : Pier contraction coefficient (typically to )
If you’ve ever designed a concrete gravity dam, you know the Ogee spillway is both a thing of beauty and a hydraulic headache. Getting that perfect “S” curve—where the lower nappe of the waterfall just kisses the crest—requires iteration.
The first step is gathering the hydraulic requirements for the dam. The peak flood flow the spillway must handle. Design Head ( Hdcap H sub d
