| 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. |
Some Ogee tools require Excel's "Solver" for optimization. Go to File > Options > Add-ins . At the bottom, select Excel Add-ins and click Go . Check Solver Add-in and click OK.
Click the macro button . The spreadsheet will: ogee spillway designxls install
A built-in scatter chart automatically plots the
Many textbooks state that the effect is negligible when P/Hₑ > 1.33. However, if the dam is low or the reservoir is wide, Vₐ²/(2g) can be significant. | Error Message | Likely Cause | Solution
For a vertical upstream face, the spreadsheet uses the following coordinates:
– Implement the compound circular arc formulas. The table below shows the key points for a vertical upstream face: | | "Solver: Not an available reference" |
Note: Always verify that the downloaded spreadsheet explicitly references standard equations like the USBR coordinates for the upstream and downstream quadrants. 2. Step-by-Step Installation and Setup Guide
To calculate the height of the spillway ( ) above the riverbed.
An energy dissipator—such as a stilling basin or a hydraulic jump—must be designed downstream. The spreadsheet should include auxiliary calculations for basin length, floor elevation, and the conjugate depth of the hydraulic jump.
ogee spillway designxls install, ogee crest spreadsheet, Wes spillway profile excel, hydraulic design xls, dam spillway template.