Ogee Spillway Designxls Install ((link)) -

If the spreadsheet generates a table of X-Y coordinates (usually 20-50 rows), your "install" is successful. If cells show #NUM! or #VALUE! , you missed a macro or solver step.

Before discussing the installation, let’s define the software.

: At the design head, the pressure along the spillway surface is atmospheric. If the head exceeds cap H sub d ogee spillway designxls install

To illustrate the entire workflow, we will design an ogee spillway for the following data:

If the spillway height ( P ) above the streambed is greater than 1.33· Hₑ , the influence of approach velocity on the discharge coefficient is negligible, and Hₑ can be used directly. If not, the velocity head Vₐ²/(2g) must be added to the static head. If the spreadsheet generates a table of X-Y

where K and n depend on the upstream slope:

Dimensions of chute blocks, baffle piers, and end sills (matching USBR Basin types). How to Download, Install, and Set Up the XLS Tool , you missed a macro or solver step

Before using the installed XLS for a real-world project, test it against a textbook problem. Input a known dataset (e.g., standard USBR design metrics) and verify that the generated discharge capacity and coordinates exactly match the textbook answers. Exporting XLS Coordinates to CAD Softwares