Ogee Spillway Designxls Install Verified
To install and use an Ogee Spillway Design Excel (.xls) spreadsheet, you typically need to download the template from a technical repository and enable macros to allow the hydraulic calculations to run. 1. Download the Design Template
Since "Ogee Spillway Design.xls" is a common tool used by civil and hydraulic engineers, you must first source the file from a reputable engineering resource.
Locate the file on platforms such as CivilEngineeringBible, ExcelCalcs, or academic repositories providing hydraulic design aids.
Ensure the file extension is .xls (Excel 97-2003) or .xlsm (Macro-Enabled Workbook), as these tools often use VBA scripts for iterative calculations like discharge coefficients ( Cdcap C sub d 2. Enable Macros and Content
Most ogee spillway spreadsheets rely on custom functions to calculate the profile coordinates based on the relationship. Open the file in Microsoft Excel. If a yellow bar appears at the top, click Enable Content. ogee spillway designxls install
Go to File > Options > Trust Center > Trust Center Settings > Macro Settings and ensure "Disable all macros with notification" is selected so you can approve the script. 3. Input Design Parameters
Once the spreadsheet is open, you will need to enter your specific site data into the designated input cells (usually highlighted in a specific color). Design Head ( Hdcap H sub d
): The maximum head over the crest for which the profile is designed. Spillway Height ( ): The vertical distance from the floor to the crest. Design Discharge ( ): The flow rate the spillway must handle.
Slope of Upstream Face: Usually vertical or inclined (e.g., 3H:1V). 4. Verify Profile Coordinates The spreadsheet will automatically generate a table of coordinates for the downstream profile. To install and use an Ogee Spillway Design Excel (
Check the "Calculations" tab to see the derived Discharge Coefficient ( The standard discharge equation used is:
Q=C⋅L⋅He3/2cap Q equals cap C center dot cap L center dot cap H sub e raised to the 3 / 2 power is the effective length and Hecap H sub e is the total energy head. 5. Generate the Ogee Curve Most templates include a built-in chart.
Look for a tab labeled "Chart" or "Profile" to see the visual representation of the spillway.
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. Ogee Spillway Design: Utilizing Excel Spreadsheet Tools 7
Ogee Spillway Design: Utilizing Excel Spreadsheet Tools
7. Gates and Control
- For gated ogee spillways, types include radial (tainter), vertical lift, or roller gates.
- Gate sill and lip geometry must match the ogee profile when gates are fully open.
- Design operations consider:
- Gate opening schedule for flood routing.
- Sealing and mechanical capacity.
- Cavitation risk at high velocities—design energy dissipation accordingly.
Section A: Input Parameters
| Variable | Description |
|----------|-------------|
| H_d | Design head including approach velocity |
| P/H_d | Ratio to determine flow regime (low/high overflow) |
| Upstream slope | Affects the ellipticity of the upstream quadrant |
Step 2: Extract the Archive
- Right-click the
.zipfile > Extract All. - Choose a permanent location:
C:\Users\[YourName]\Documents\Engineering_Tools\Ogee_Spillway\ - Important: Do not run the spreadsheet from a temporary folder or cloud-synced folder (OneDrive/Dropbox) while installing—macros may be blocked.
16. References and Standards (for detailed formulae and tables)
- Use standard references for detailed ogee coordinates, discharge coefficients, and stilling basin designs: USACE hydraulics manuals, USBR design manuals, ICOLD bulletins, and national dam design codes.
Step 1: Download the Correct Package
Do not download random .exe files. Legitimate sources include:
- University repositories (e.g., Utah State Univ. Hydraulics Lab)
- GitHub (search
ogee-spillway-spreadsheet) - Professional forums (EngineersEdge, CivilEngineeringX)
Look for a .zip folder named Ogee_DesignXLS_Package.zip.