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.
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
...but where did you come up with that formula?
RE: friction loss formula into excel
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
RE: friction loss formula into excel
RE: friction loss formula into excel
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
=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:
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
RE: friction loss formula into excel
Cheers,
CanuckMiner
RE: friction loss formula into excel
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