Calculate d/D ratio in spreadsheet

[KellyEnv]

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.

 

[gbam]

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.

 

[bltseattle]

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...