×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Relation between pipe velocity, pressure loss, pipe roughness

Relation between pipe velocity, pressure loss, pipe roughness

Relation between pipe velocity, pressure loss, pipe roughness

(OP)
Don't you hate it when you have an excel calculation sheet, done by others, and there's no way for you to tell how the values were calculated?

Case in point, I have a calculation that uses VBA functions. I want to back engineer the calculations, so that I can validate the results. Unfortunately, the owner of the calculation locked the VBA developer, and I have no way to look at the code without a password.

So here's what I'm trying to figure out:

Function calculates the velocity in a pipe with certain diameter. Here's the thing: flow is not considered!
Here's a copy of the table, for thermoplastic pipe:

Size fps psid/100ft GPM
2 4.17 1.2 51.4
3 5.30 1.2 133
4 6.06 1.2 227

Size and pressure loss are input values. fps and GPM are calculated values.
When I look at the in-cell formula (function) for the velocity (fps), I can see the following parameters are used:

Pipe roughness
inside diameter
fluid density
dynamic viscosity
psid/100ft
max velocity (if calculated velocity is higher than max, then max velocity overrides result).

The flow GPM is then calculated based on the fps values, in effect giving us the capacity of the pipe.

So my question is, how can the velocity in a pipe, based on its diameter, be calculated, when the flow is not known, and using the parameters given?

I've looked inside Crane TP, Nayyar handbook, and several other sources. Also did a search in this forum. I must be missing something.




I design aqueducts in a parallel universe.

RE: Relation between pipe velocity, pressure loss, pipe roughness

If you have all that information then you can calculate the flow rate, and if you know the flow rate then you can calculate the velocity.

Katmar Software - AioFlo Pipe Hydraulics
http://katmarsoftware.com

"An undefined problem has an infinite number of solutions"

RE: Relation between pipe velocity, pressure loss, pipe roughness

(OP)
it appears the velocity is calculated first. Then the flow.

I design aqueducts in a parallel universe.

RE: Relation between pipe velocity, pressure loss, pipe roughness

its not uncommon to calculate the velocity first. For instance a standard form of both Manning and Chezy equation is written to solve for velocity. there is no flow rate in the equations.

https://i.ytimg.com/vi/uM9nPHS7GSQ/maxresdefault.j...

If this spreadsheet was given to you for your use or review, than ask for an explanation of the calculation procedure. If you are pirating this spreadsheet, than you may have to generate your own code.

RE: Relation between pipe velocity, pressure loss, pipe roughness

I think they are using the maximum velocity value to check friction factor and then calculating velocity based on pressure drop using D-W Equation.

RE: Relation between pipe velocity, pressure loss, pipe roughness

(OP)
Manning's for open channel flows. Not applicable here.

Fyi, I have this spreadsheet from a company I used to work for. Since I don't want to use it in my current firm, I'm just trying to figure out the engineering formulas behind the calcs. I'm not interested in the code itself as that would be proprietary. It's more of an intellectual exercise I'm keeping myself busy with during my downtime. wink

What I also hope to understand, eventually, is what this velocity means, compared to max or design velocity that is used everywhere to calculate the capacity of a pipe.

RE: Relation between pipe velocity, pressure loss, pipe roughness

Quote ( )

What I also hope to understand, eventually, is what this velocity means, compared to max or design velocity that is used everywhere to calculate the capacity of a pipe.

velocity is related to the available head and to the head losses through the pipe or channel.
these would include friction, elevation change, entrance and exit losses, momentum losses etc.

by the way mannings, chezy and Darcy Weisbach all can be used for pipes as well as open channels.

RE: Relation between pipe velocity, pressure loss, pipe roughness

(OP)
I think I was able to crack it, thanks to Crane TP410. Sometimes it helps to sleep over it and take a fresh look at the formulas.

Step 1: calculate Reynolds # based on the given maximum velocity )(Equation 6-3)
Step 2: calculate friction factor using Colebrook equation 6-5
Step 3: Calculate the velocity in the pipe using Darcy equation 6-8 for delta_p

Voila.

I'm making an assumption they used maximum velocity to calculate the Reynolds # in Step 1. My manual calculation results are very similar to the function values. I'm guessing they used a function just to calculate the pesky Colebrook equation.

I design aqueducts in a parallel universe.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources