Ogee Spillway Designxls Better
provide precision in maintaining atmospheric pressure on the spillway face, which prevents destructive cavitation vacuum formation Maryland Department of the Environment (.gov) 1. Define Design Parameters
If you change the design head by 0.5 meters, you risk breaking a hidden reference. If the spillway is broad-crested? Time to start a new sheet from scratch. ogee spillway designxls better
The following steps are typically automated in high-quality design spreadsheets: Determine Initial Design Head ( cap H sub e Assuming an initial discharge coefficient ( ) and using the net crest length ( ), calculate a trial cap H sub e using the formula Calculate Effective Crest Length ( cap L sub e Adjust the net length for pier and abutment contractions: provide precision in maintaining atmospheric pressure on the
But here is the uncomfortable truth:
Using an XLS tool for Ogee design is generally "better" than manual calculations but has specific trade-offs compared to 3D modeling software. Time to start a new sheet from scratch