To optimize the design of an ogee spillway, an Excel-based approach can be employed. The following steps outline the methodology:

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 : Net length of the crest. : Number of piers. Kpcap K sub p : Pier contraction coefficient (depends on pier shape). Kacap K sub a

The ogee spillway features an S-shaped profile specifically designed to match the lower nappe of a freely falling water jet. This unique geometry ensures that overflowing water maintains constant contact with the spillway surface, preventing the formation of vacuums and harmful cavitation that could otherwise erode the structure.