Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations KootK on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculate d/D ratio in spreadsheet

Status
Not open for further replies.

KellyEnv

Civil/Environmental
Aug 6, 2008
1
Can anyone out there help me how to calculate a d/D ratio in a spreadsheet? I am trying to verify results obtained in InfoSewer using a spreadsheet.
 
Replies continue below

Recommended for you

First, how are you calculating "d"? Please give more information about your process. If you are computing flow depths based on a flow rate and pipe size then all you need to use is manning's eqn. and code into visual basic to compute "d".
Hopefully that helps.
 
Try using lookup tables. I found this much simpler to set up than trying to use a precise formula to find d/D. You can find all the values you should need from Appendix E: Area, Wetted Perimeter and Hydraulic Radius of Partially Filled Circular Pipes in the Civil Engineering Refernce Manual, 6th Edition, Lindeburg 1998 (or other reference text). If you need more precision, you can interpolate from the values in the table...


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor