Before using the spreadsheet for any real project, run it with the example data from a trusted source. The 12000 m³/s problem mentioned earlier is ideal. If the spreadsheet’s final head differs from the manual solution by more than 2%, debug the formulas.
Unlike complex engineering software (HEC-RAS, ANSYS), “installation” here typically means extracting files and registering components. Follow these steps precisely. ogee spillway designxls install
Q=C⋅Le⋅He3/2cap Q equals cap C center dot cap L sub e center dot cap H sub e raised to the 3 / 2 power UNCONTROLLED OGEE CREST RESEARCH Before using the spreadsheet for any real project,
I can provide the specific coordinate formulas or VBA script snippets tailored to your exact design criteria. Share public link Share public link For the design head, the
For the design head, the coefficient is taken as the maximum value (typically ≈2.20). At other heads, a correction factor C/C d is applied, a relationship that is usually presented as a curve or a lookup table.