Typical discharge coefficients (C d ) range from 2.1 to 2.5. Because Lₑ itself depends on Hₑ , this is an —exactly the kind of repetitive work a spreadsheet handles perfectly.
For a vertical upstream face, the upstream quadrant is typically defined by a compound circular arc. The standard geometry uses dimensionless ratios:
If the spreadsheet generates a table of X-Y coordinates (usually 20-50 rows), your "install" is successful. If cells show #NUM! or #VALUE! , you missed a macro or solver step.
Since Excel files downloaded from the internet may have macros, you may need to right-click the file, select Properties , and click Unblock . ogee spillway designxls install
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 .
To allow the spreadsheet to run iterative hydraulic calculations via macros: Open Microsoft Excel.
A comprehensive ogee spillway design spreadsheet typically features modules broken down into specific engineering stages. 1. Hydraulic Input Parameter Sheet Typical discharge coefficients (C d ) range from 2
Under the tab, look for the security notice at the bottom: "This file came from another computer and might be blocked..." Check the Unblock box and click Apply , then OK . Step 3: Configure Excel Trust Center Settings
Once water rushes down the ogee face, it develops high kinetic energy. The spreadsheet calculates the required parameters for a hydraulic jump, including: Post-jump water depth ( Y2cap Y sub 2 Length of the stilling basin.
Enter —a specialized Microsoft Excel workbook that automates these calculations. But a powerful tool is useless if you cannot install it correctly. The standard geometry uses dimensionless ratios: If the
Do not download random .xls files from untrusted forums. Start here:
Right-click the downloaded Excel file and select . Go to the General tab. At the bottom, look for the Security section. Check the Unblock box and click Apply , then OK . Step 3: Enable Macros and Advanced Excel Settings Launch Microsoft Excel and open the file.