Spillway Designxls Better: Ogee

: Comprehensive packages available on The Engineering Community include spreadsheets for both spillway design and energy dissipation.

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. ogee spillway designxls better

Q=CLeHe3/2cap Q equals cap C cap L sub e cap H sub e raised to the 3 / 2 power : Total discharge. Lecap L sub e flip to the discharge coefficient tables