Computing Critical and Normal Depths for Arch and Elliptical Cross-Sections Using Excel Spreadsheet
Michael A. Perez, Catherine G. Butler, and Xing Fang (2014)
Arch pipe: Zone 1 y < y1 |
Arch pipe: Zone 2 y1 < y < y2 |
Arch pipe: Zone 3 y > y2 |
Excel spreadsheets for free download (send an email to xing.fang@auburn.edu to obtain security information for free download, so I know who is interested in using the spreadsheets developed):
Description and File Names | Microsoft Excel 2010/2013 Version |
Spreadsheet for arch pipe and elliptical pipe cross section | Arch/Elliptical pipe and Corrections in Equations |
Horizontal installation of an elliptical pipe cross section |
Vertical
installation of an elliptical
pipe cross section
|
How to activate or enable Solver Add-In (function):
1. Before using the Solver function one has to enable it in Excel 2010/2013. For that click Microsoft Office Button, and then Excel Options. Click Add-Ins and then in the Manage box, select Excel Add-ins and then click Go. In the Add-Ins available box, select the Solver Add-in check box, and then click OK. (If Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in). If you get a prompt so that the Solver Add-in is not currently installed on your computer, click Yes to install it. After the Solver Add-in is loaded, the Solver function is available in the Analysis group on the Data tab.
Declaration: These spreadsheets are provided for free as part of the paper. It has been carefully tested and verified. Neither I nor any university in which I am in the employ accepts responsibility or liability for its use by third parties, especially if any user alternates settings and formulas in the spreadsheets.Contact information for further questions: Dr. Xing Fang (Auburn University), (334) 844-8778 or xing.fang@auburn.edu