Because the effective length depends on the head, the solution for Hₑ requires iteration. Once a stable value is reached, the profile coordinates can be computed.
Education is seen as the primary vehicle for "improving one’s station in life".
Implementing this Microsoft Excel-based toolkit requires proper macro configurations and precise geometric mathematical inputs to prevent structural cavitation. ogee spillway designxls install
If you want to expand your spreadsheet to include downstream energy dissipation, tell me if your project requires a or a flip bucket design . Share public link
| Parameter | Input Value | Expected Output | Spreadsheet Output | Error (%) | |-----------|-------------|----------------|--------------------|------------| | Design Head (H_d) | 3.05 m | - | - | - | | Crest Length (L) | 10.0 m | - | - | - | | Discharge (Q) | 102.5 m³/s | 102.5 m³/s | 102.3 m³/s | 0.2% (acceptable) | Because the effective length depends on the head,
This type of spreadsheet is particularly useful for sizing a spillway to accommodate the Probable Maximum Flood (PMF) and for evaluating peak water levels.
The spreadsheet uses a formula that typically divides the curve into two parts. The standard USBR profile is [1]: The spreadsheet uses a formula that typically divides
Navigate to the input section (usually highlighted in a specific color like yellow or blue).