) due to side contractions. The formula to determine this is:
The XLS was not just "faster"—it was because it allowed the engineer to test three alternative spillway heights (( H_d )) in 45 minutes, optimizing concrete cost by $14,000. ogee spillway designxls better
The “better” version doesn’t stop at the crest shape. It integrates: ) due to side contractions
Ogee spillway design spreadsheets (often found as files) are widely used in civil engineering to automate the complex geometric and hydraulic calculations required for gravity dams. While specific proprietary files vary, a high-quality "better" design tool typically excels in several key areas of hydraulic efficiency and calculation accuracy. RGM College Of Engineering and Technology Core Strengths of a "Better" Design XLS Dynamic Discharge Coefficients Hdcap H sub d : Design head
xn=KHdn−1yx to the n-th power equals cap K cap H sub d raised to the n minus 1 power y Where: : Coordinates from the crest apex. Hdcap H sub d : Design head. : Constants determined by the slope of the upstream face. 3. Effective Crest Length ( Lecap L sub e ) Piers and abutments reduce the net crest length (
: XLS files can instantly adjust for pier and abutment contraction coefficients, which significantly impact effective crest length.