Ogee: Spillway Designxls Install
are determined by the spreadsheet based on the ratio of approach velocity to the design head. The XLS automatically populates a dynamic data table translating this curve into precise
): The total head above the crest level, including the velocity head of the approaching flow. Spillway Crest Height (
: Many of these spreadsheets use VBA for complex iterations. You may need to "Enable Content" when opening the file. Developer Tab
Double-click your Ogee Spillway Design XLS file. When the yellow security warning bar appears at the top of the screen reading “Macros have been disabled” or “Protected View,” click and Enable Content . 3. Core Hydraulic Inputs Required ogee spillway designxls install
Designing and calculating these highly sensitive curves by hand is notoriously prone to mathematical errors. Utilizing automated simplifies this workflow. This article breaks down the mathematical foundations, provides a blueprint for structuring a custom engineering spreadsheet, and outlines the correct protocols for onsite physical installation. 1. Core Mathematical and Hydraulic Equations
Use the standard discharge formula to find the required effective length of the crest ( Lecap L sub e
: Verify that the downstream power curve transitions seamlessly into the straight slope of the spillway glacis without any abrupt geometric breaks. ✅ Summary of Ogee Spillway Design Steps are determined by the spreadsheet based on the
To design an using an Excel-based approach (e.g., spillway_design.xls ), you must determine the crest profile that matches the lower surface of a nappe (sheet of water) flowing over a sharp-crested weir. This shape ensures maximum discharge efficiency and prevents damaging negative pressures on the concrete surface. ⚙️ Core Design Steps The design typically follows these sequential calculations: Determine Design Head ( Hdcap H sub d
Manually solving for these coordinates is prone to rounding errors. The and Bureau of Reclamation provide standard profiles (WES standard shape), but translating those into precise X-Y coordinates for CAD requires a robust solver.
If the spreadsheet uses VBA (Visual Basic for Applications) for automated graphing, you must Enable Macros in Excel. You may need to "Enable Content" when opening the file
Check the box and click Apply . (This prevents Microsoft from completely disabling functions via "Protected View"). Step 3: Enabling Macros Open the file in Microsoft Excel.
Look for a tab labeled "Chart" or "Profile" to see the visual representation of the spillway.
YHd=−K(XHd)nthe fraction with numerator cap Y and denominator cap H sub d end-fraction equals negative cap K open paren the fraction with numerator cap X and denominator cap H sub d end-fraction close paren to the n-th power (Where