Spreadsheet for pipe flow/capacity
Spreadsheet for pipe flow/capacity
(OP)
I am working on an audit of a sewer system and I got some help and configured a spreadsheet to calculate any of the following to an aproximation (around 3% error or less)
d/D
Q
Manning's n
slope
Diameter
those are the input variables, just place a "?" in the cell of the unknown and it will be calculated along with... Wet. Area, Wet. Perimeter, Hyd. Rad. and Velocity.
Here's the file in Excel
http://ra pidshare.c om/files/4 2529967/Tr ueMannings 1.xls.html
I have one for Quattro Pro but it has bugs to work out, so it may be a while before I can post that.
d/D
Q
Manning's n
slope
Diameter
those are the input variables, just place a "?" in the cell of the unknown and it will be calculated along with... Wet. Area, Wet. Perimeter, Hyd. Rad. and Velocity.
Here's the file in Excel
http://ra
I have one for Quattro Pro but it has bugs to work out, so it may be a while before I can post that.





RE: Spreadsheet for pipe flow/capacity
RE: Spreadsheet for pipe flow/capacity
How about if you check it out against one of the eFunda flow calculators -- http://www.efunda.com.
Thanks,
Gordan
http://engware.i-dentity.com
RE: Spreadsheet for pipe flow/capacity
Thank you,
Daniel
RE: Spreadsheet for pipe flow/capacity
Here is a URL:
http://www
You try with no pressure loss case ...
Thanks,
Gordan
http://engware.i-dentity.com
RE: Spreadsheet for pipe flow/capacity
Katmar Software
Engineering & Risk Analysis Software
http://katmarsoftware.com
RE: Spreadsheet for pipe flow/capacity
I will check on the eFunda calc this weekend and post back on the results, since the pdf Katmar sent was a chart I did a quick test and on the 1/4 full numbers, with smaller pipes, my spreadsheet tested to have about a 3-5% error margin, always calculating a bit higher than the chart. From about 8" pipes and above it has a 1% error margin. I want to get the error margin down for the smaller pipes and flow rates, but I am still happy with it as an approximation, it completley serves my purposes here and more. Let me know if you still cannot download it, this is the first time I have used rapid share, if it isn't working I get it up another way.
Daniel
RE: Spreadsheet for pipe flow/capacity
I just had a chance to check out you spreadsheet.
Not bad. It is a good concept and set up.
My piece od advice is as follows: keep working, developing and improving such engineering tools.
Get more mileage under you belt and you will do just fine.
Good luck!
Thanks,
Gordan
http://engware.i-dentity.com
RE: Spreadsheet for pipe flow/capacity
Daniel
RE: Spreadsheet for pipe flow/capacity
Is there some reason you made it password protected?
I'd like to move some cells around and change the font.
http://virtualpipeline.spaces.msn.com
RE: Spreadsheet for pipe flow/capacity
http://virtualpipeline.spaces.msn.com
RE: Spreadsheet for pipe flow/capacity
You're a better guesser than me! How about a hint on the password?
Thanks,
Russ
RE: Spreadsheet for pipe flow/capacity
http://virtualpipeline.spaces.msn.com
RE: Spreadsheet for pipe flow/capacity
Additional conversions:
1. Maximum Gallons per day capacity based on user specified peaking factor
2. % of utilization based on #1 depending on project requirements
Jeff Foster, PE
Brooks Engineering Associates, PA
Asheville, NC