Learn to export Postman collection through the UI, CLI, and API. Unlock powerful workflows for version control, automation, and documentation.
Many advanced spillway calculators use Visual Basic for Applications (VBA) to run iterative loops for water surface profiles. Open the file in Microsoft Excel.
YHd=−K⋅(XHd)nthe fraction with numerator cap Y and denominator cap H sub d end-fraction equals negative cap K center dot open paren the fraction with numerator cap X and denominator cap H sub d end-fraction close paren to the n-th power = Coordinates relative to the highest point of the crest. Hdcap H sub d = Design head over the crest (excluding velocity head).
Additional options include the Dolusavak Taşkın Öteleme (Spillway Flood Routing) tool, which calculates flood routing for ogee spillways using Microsoft Excel. Online calculators are also available for quick checks of discharge and crest length, but these lack the depth of a full spreadsheet tool.
): The depth of water above the spillway crest during peak flow. ogee spillway designxls install
If no bar appears but buttons or coordinate calculations do not work, navigate to .
are coefficients determined by the slope of the upstream face. Step 1: Preparing Your Excel Environment
Standard input data includes:
An ogee spillway is a commonly used overflow crest shape for dams and spillways, designed to match the lower nappe profile of a prismatic structure under free-flowing conditions. Its curved profile minimizes flow separation and energy losses, providing efficient discharge and predictable hydraulic performance for overtopping flows.
Do not download random .xls files from untrusted forums. Start here:
Because Excel files can contain malicious VBA macros, downloading engineering tools requires caution. Follow these steps to find and safely set up your file: Step 1: Sourcing the File Many advanced spillway calculators use Visual Basic for
Before writing formulas, format your Excel workbook to ensure clarity and eliminate manual calculation errors.
An ogee spillway design template is incomplete without a visual profile graph. Follow these steps to generate a geometric plot: Highlight your calculated coordinate columns. Insert an .
Use the standard discharge formula to find the required effective length of the crest ( Lecap L sub e Hdcap H sub d = Design head over
If your spreadsheet relies on custom add-ins (like Excel's native Solver add-in for optimization), go to , click Go... next to Excel Add-ins, and check Solver Add-in . Step 4: Verification with a Benchmark Problem