×
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

friction loss formula into excel

friction loss formula into excel

friction loss formula into excel

(OP)
I am looking to figure pressure loss per foot for sprinkler piping. I have the formula and am trying to figure out how to place it into excel.

p=
4.52 Q to the power of 1.85 over C to the power of 1.85 D to the power of 4.87.

P = friction loss per foot
Q = gpm flowing
D = actual inside dia. of pipe
C = friction loss coefficient

any help in writting this into excel would be appreciated.

RE: friction loss formula into excel

= 4.52*(Q/C)^1.85/(D^4.87)

...but where did you come up with that formula?

RE: friction loss formula into excel

(OP)
Thanks.

I picked this formula up out of the fire protection design handbook. If there is an easier way then by all means share.

Thanks again.

RE: friction loss formula into excel

(OP)
I',m also finding out that it really does not work. I should get a number around .0217 for a 1" CPVC flowing 11 gpm.

RE: friction loss formula into excel

What are you using for C?

RE: friction loss formula into excel

You'll have to calculate the Reynolds number and determine if the flow is laminar or turbulent and then apply the correct friction factor calculation. You will need to know the absolute or kinematic viscosity and the specific gravity of the fluid. If the flow is turbulent you will probably use a Moody diagram. You will need to know the absolute roughness of the tubing or conductor.

The head loss calculation of the Bernoulli equation is difficult to put into a spreadsheet. There are multiple data types in the kinematic or absolute viscosity data. There is both SI and English units of measure. The turbulent friction factor can be arrived at by using the Moody diagram or a very extended formula. There are numerous formulae required but it can be done.

Then the real challenge begins because you are looking for some answer to come out the Bernoulli equation but sometimes its the pump horsepower, while other times you want some pressure at a second point in the hydraulic system. What I'm driving at sometimes the information is a given variable while the next time it is what you are looking for. Building a spread sheet to handle all cases is tough. I have built one but it is still incomplete and its been a real bear.

RE: friction loss formula into excel

Suppose if you put Q values in cellA2, C values in cellB2 and D values in cellC2 then the formula should be,
=4.52*(POWER((A2/B2),1.85)/POWER(C2,4.87))  

Here is a spreadsheet that calculates pressure drop in pipelines. This good spreadsheet was developed by a fellow member of eng-tips.
http://homepage.ntlworld.com/brian.doherty/pipesize.xls

Here is one more spreadsheet by another fellow member of eng-tips.
http://mysite.wanadoo-members.co.uk/pressure_drop2

You can get one spreadsheet for pressure drop calculation and another for solving colebrook's equation from,
http://me.queensu.ca/courses/mech451/losses.htm

Note that these are all good spreadsheets but they are based on Darcy's equation.

Regards,

RE: friction loss formula into excel

btrueblood's formula gives the same result.

RE: friction loss formula into excel

The equation given by the original poster is a modified form of the Hazen Williams equation that yields psi per foot of pipe.  It matches the formula in my Fire Protection Handbook (which I have used in the past).

Cheers,
CanuckMiner

RE: friction loss formula into excel

Water sprinkler, laminar flow? that is impossible. We are dealing with water, the Hazen Williams equation is applicable to turbulent flows.
What are the flow requirements of the area to be protected?
to give an idea:
for a 1/2" sprinkler with a nozzle pressure range 10 - 100 psi, the flow range would be 18 - 58 GPM

RE: friction loss formula into excel

You can also write such formula's in "MathCad" spreadsheets also.

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