Spreadsheet for pipe flow/capacity

[beastmodeactivated]

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://rapidshare.com/files/42529967/TrueMannings1.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.

 

[RossABQ]

Looks nice! Will try on my next project.

 

[Feric]

Hi there:

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

 

[beastmodeactivated]

Feric, thanks for the tip, I would really like to test against more calculators, when I went onto eFunda I could not find a flow calculator except for the pressure drop calc. Could you send me a direct link?

Thank you,

Daniel

 

[Feric]

Daniel:

Here is a URL:

http://www.efunda.com/formulae/fluids/calc_pipe_friction.cfm

You try with no pressure loss case ...

Thanks,

Gordan

http://engware.i-dentity.com

 

[katmar]

I can't get your file to download so I am not sure what it is calculating, but if you want something to check your numbers against have a look at

http://www.repwars.com/cispi_ch8.pdf

for some tables of calculated results

Katmar Software
Engineering & Risk Analysis Software

http://katmarsoftware.com

 

[beastmodeactivated]

Thanks again guys,
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

 

[Feric]

Daniel:

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

 

[beastmodeactivated]

Thanks for the encouragement Feric, I really appreciate it.

Daniel

 

[BigInch]

beastmodeactivated,

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

 

[BigInch]

Never mind. I chanced on a good guess.

http://virtualpipeline.spaces.msn.com

 

[russingram]

BigInch,

You're a better guesser than me! How about a hint on the password?

Thanks,

Russ

 

[BigInch]

Man you're not kidding about that. Can you drop me an e-mail? my address is in the contacts section of my webspace page.

http://virtualpipeline.spaces.msn.com

 

[jrfosterjr]

Improvement suggestion:

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