ogee spillway designxls better
  About   Help   FAQ
ogee spillway designxls better

Engineers who skip the spreadsheet and go straight to 3D modeling often end up with a spillway that looks good but has negative pressure zones (cavitation risk) because their curve didn't perfectly match the nappe. The XLS fixes this first.

One of the most tedious parts of the design is the iteration required to find the correct head ( H ) and effective crest length ( L_e ) for a given design discharge ( Q ). A user might start by assuming an initial crest length, then calculate the required head for a given Q. If the resulting head exceeds the allowed surcharge limit (e.g., 10 meters), the crest length must be adjusted upward, and the calculation is performed again. An advanced Excel sheet automates this entire process, providing an optimal solution in seconds.

Since I cannot attach an .xlsx file directly, I will provide a comprehensive and the exact Formulas/Logic you need to build a professional-grade spreadsheet. This guide transforms a basic calculator into an engineering tool.

What goes into a superior Excel design workbook? A comprehensive "ogee spillway designxls better" tool will guide you through the following steps, acting as a digital assistant that prevents common errors.

A “better” ogee design .xls goes beyond simple formulas. It includes:

To build a high-utility ogee design template, organize your Excel workbook into three distinct functional sections. Section 1: Input Parameters


Contributing Projects:
Mouse Genome Database (MGD), Gene Expression Database (GXD), Mouse Models of Human Cancer database (MMHCdb) (formerly Mouse Tumor Biology (MTB)), Gene Ontology (GO)
Citing These Resources
Funding Information
Warranty Disclaimer, Privacy Notice, Licensing, & Copyright
Send questions and comments to User Support.
last database update
10/07/2025
MGI 6.24
The Jackson Laboratory