However, designing an Ogee spillway manually involves solving tedious equations: the U.S. Army Corps of Engineers’ crested spillway profiles, upstream/downstream tangent adjustments, and discharge coefficient iterations.
Introduction In the world of dam design and hydraulic structures, few elements are as critical—or as mathematically complex—as the Ogee spillway . Named for its characteristic "S" shape (ogee curve), this spillway type is the gold standard for concrete gravity dams because it efficiently passes floodwater with minimal energy loss. ogee spillway designxls install
ogee spillway designxls install, ogee crest spreadsheet, Wes spillway profile excel, hydraulic design xls, dam spillway template. Named for its characteristic "S" shape (ogee curve),
Enter —a specialized Microsoft Excel workbook that automates these calculations. But a powerful tool is useless if you cannot install it correctly. But a powerful tool is useless if you
Download the latest Ogee Spillway DesignXLS v3.2 from the link below (ensure you have Excel 2016 or later and Windows 10+).
Remember: this spreadsheet is a design aid—always verify critical outputs against standard texts (e.g., USBR’s Design of Small Dams ) or a licensed professional engineer.
| Error Message | Likely Cause | Solution | |---------------|--------------|----------| | "Cannot run the macro... macros may be disabled" | Excel security settings | Re-enable macros per Part 2. | | "Compile error: Can't find project or library" | Missing VBA reference | Open VBA editor > Tools > References > uncheck "MISSING" items. | | "Solver: Not an available reference" | Solver add-in not loaded | Reinstall Solver via Excel Add-ins (Part 3, Step 5). | | "Run-time error 1004: Application-defined error" | Data validation conflict | Clear all input cells, then re-enter values as numbers (not text). | | "File is corrupt and cannot be opened" | Downloaded incorrectly or OneDrive conflict | Re-download the zip, extract to local drive C: only. | If you cannot complete the ogee spillway designxls install due to IT restrictions (locked Excel macros, no local admin rights), consider these options: