The spreadsheet uses a formula that typically divides the curve into two parts. The standard USBR profile is [1]:
In your XLS sheet, create a column that concatenates the X and Y coordinates into a single string format: =X_cell&","&Y_cell . Copy this column of data. Open AutoCAD, initiate the SPLINE or PLINE command.
Understanding what happens behind the user interface ensures you can audit the results for safety. The spreadsheet uses a sequence of mathematical calculations based on the profile: Phase 1: Effective Crest Length Calculation
= Constants determined by the upstream slope of the dam and velocity of approach.
Follow these steps to successfully use an ogee spillway design template in Excel. Step 1: Obtain the Spreadsheet ogee spillway designxls install
Key design parameters include:
The spreadsheet references built-in design curves to adjust the ideal discharge coefficient based on the ratio of the dam height to design head ( ). For a high standard ogee crest, C0cap C sub 0 typically approaches (SI units) or (English units). Phase 3: Generating Coordinate Geometry
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 constants depend entirely on the slope of the upstream face.
| Component | Requirement | |-----------|--------------| | | Windows 10, 11 (64-bit) or macOS with Parallels/VMware | | Excel Version | Microsoft Excel 2016 or later (Office 365 recommended) | | Memory | 4 GB RAM minimum | | Add-ins | Solver Add-in and Analysis ToolPak must be enabled | | Macros | Must allow signed macros (for .xlsm versions) | The spreadsheet uses a formula that typically divides
The use of XLS in ogee spillway design is expected to continue growing, driven by advances in computational methods and the increasing demand for efficient and sustainable flood management solutions. Future research directions may include:
yHd=−KHdn(x)1.85the fraction with numerator y and denominator cap H sub d end-fraction equals negative the fraction with numerator cap K and denominator cap H sub d to the n-th power end-fraction open paren x close paren to the 1.85 power x, y: Coordinates from the apex of the crest. K, n: Constants depending on upstream slope/friction.
To confirm your succeeded, run a benchmark test.
Since there is no "setup.exe" file to run, "installing" an ogee spillway design tool in Excel is about acquiring and building your spreadsheet. Here’s a conceptual guide on how to do it: Open AutoCAD, initiate the SPLINE or PLINE command
Ogee spillway design, Ogee spillway designXLS install, hydraulic engineering spreadsheet, WES crest curve, USBR spillway design, Excel solver for hydraulics.
| Item | Requirement | Status | |------|-------------|--------| | Operating System | Windows 10 / 11 (64-bit) | Satisfied | | Spreadsheet Software | Microsoft Excel 2016 or later (or LibreOffice Calc with partial compatibility) | Satisfied | | Memory | 4 GB RAM minimum | Satisfied | | Macro Security | Enable editing & enable macros (for iterative calculations if used) | Set as needed |
An ogee spillway design XLS is a pre-configured Microsoft Excel spreadsheet. It automates the geometric and hydraulic design of an ogee-profile spillway. Why Engineers Use Excel for Spillway Design