This spreadsheet is not a standalone application; it is a macro-enabled Excel workbook that requires a proper installation environment to function correctly.
: Use the standard power-law equation for the downstream quadrant:
The .xls extension indicates compatibility with . Modern Excel (2016, 2019, 365) will open it in Compatibility Mode .
Ensure the curve is smooth; any "steps" in the graph suggest an error in the input parameters or a broken formula in the coordinate columns.
Most design templates include an embedded Excel scatter plot. This chart automatically maps the
Do not download random .xlsm files from untrusted sources, as they can contain malware. Look for templates hosted by verified academic institutions, civil engineering repositories, or government bodies like the USBR. Step 2: Unblocking and Security Configuration
: Define the distinct compound curves (usually two to three separate radii) that smooth the flow from the reservoir face to the crest. 4. Visualizing the Design via Excel Charts
As he hit enter, the spreadsheet performed the heavy lifting. It calculated the Coefficient of Discharge ( cap C sub d
coordinates to show a visual cross-section of the concrete ogee profile, allowing for quick visual verification. 5. Troubleshooting Common Installation & Execution Issues
Ensure that the pressures along the profile remain positive to prevent catastrophic cavitation damage.
The ogee profile is shaped to match the lower nappe of a freely falling water jet over a sharp-crested weir. This specific geometry is vital for:
automate the complex mathematical iterations required for accurate modeling. ExcelCalcs 1. Installation and Setup
| 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) |