Friction Pressure Drop Calculation

Introduction

Engineers are frequently asked to calculate the fluid pressure drop in a piping system. Many software programs are available for solving complicated hydraulic problems; however’ they can be complex and difficult to use. In addition, there are many tables or shortcut methods that give adequate answers but they usually apply to predefined conditions which are sometimes misleading or less accurate. This “Tip of the Month” discusses a method of calculating friction pressure losses for liquid lines. A spreadsheet is presented that gives friction losses based on this method.

Background Information

Equation 1 is known as the Darcy-Weisbach (sometimes called the Darcy) equation and has been used by engineers for over 100 years to calculate fluid flow pressure loss in pipe. This equation is derived by dimensional analysis and relates the various parameters that contribute to the friction loss. A correction factor, called the Moody friction factor, is included which compensate theoretical results with the experimental results.

Equation 1

Where:

hL = Head loss due to friction, m [ft]
f = Moody friction factor
L = Pipe length, m [ft]
V = Velocity, m/s [ft/sec]
g = Gravitational acceleration, 9.81 m/sec2 [32.2 ft/sec2]
D = Inside diameter, m [ft]

The task of determining the friction factor can be difficult due to the many variables that influence flow behavior. For example, the friction factor is significantly different if the fluid flow exhibits Newtonian or non-Newtonian behavior, or if the flow is laminar or turbulent. Other variables that influence the friction factor are properties of the pipe represented by absolute roughness and inside diameter, and fluid parameters such as flow rate, viscosity and density.

The Moody diagram given in Figure 1 is a classical representation of the fluid behavior of Newtonian fluids and is used throughout industry to predict fluid flow losses. It graphically represents the various factors used to determine the friction factor. For example, fluids with a Reynolds number of 2000 and less, the flow behavior is considered a stable laminar fluid, and the friction factor is only dependent on the Reynolds number. The friction factor for the Laminar Zone is represented by Equation 2. Fluids with a Reynolds number between 2000 and 4000 are considered unstable and can exhibit either laminar or turbulent behavior. This region commonly referred to as the Critical Zone, and the friction factor can be difficult to accurately predict. Judgment should be used if accurate predictions of fluid loss are required in this region. Either Equation 2 or 3 are commonly used in the Critical Zone. Beyond 4000, the fluid is considered turbulent and the friction factor is dependent on the Reynolds number and relative roughness. For Reynolds numbers beyond 4000, the Moody diagram identifies two regions, Transition Zone and Completely Turbulent Zone. The friction factor represented in this region is given by Equation 3.

Graph 1

Figure 1. Moody Friction Factor Diagram

Equations

Where:

Re = Reynolds Number
V = Fluid velocity, m/s [ft/sec]
D = Inside diameter, m [ft]
e = absolute pipe roughness, m [ft]
? = Fluid density, kg/m3 [lbm/ft3]
µ = Fluid viscosity, kg/(m-s) [lbm/(ft-sec)]

The Method

The Colebrook formula, Equation 3, is used throughout industry and accurately represents the Transition and Turbulent flow regions of the Moody Diagram. However, this implicit equation is difficult to solve by manual methods. Typically an iterative method is used to solve the Colebrook equation. One method of solving this equation is with numerical analysis technique called Newton-Raphson’s1 Method. This successive approximation approach is represented by Equation 5, and involves 1) the Colebrook formula, 2) the first derivative of the Colebrook formula and 3) an initial guess. Since the Colebrook formula is a convergent equation, the solution is usually determined with less than four iterations.

Equation 5

Where:

fn = nth iteration friction factor
fn+1 = (n+1)th iteration friction factor
g(fn) = Colebrook equation
g'(fn) = First derivative of Colebrook equation

A macro that solves the Colebrook formula is given in this spreadsheet. It is easily adapted to programmable calculators. The iterative method assumes that the following input variables are available:

Pipe inside diameter – mm [in]
Pipe length – m [ft]
Absolute roughness – m [ft]
Absolute viscosity – cP
Fluid relative density
Fluid flowrate – m3/h [gpm]

Example Problem

The macro begins with inputting the variables needed to solve for the Moody friction factor. Next, the macro determines the Reynolds Number. If the Reynolds value is below 2000 the flow is considered laminar and a simplified friction formula shown in Equation 2 is used. Above 2000 the flow is considered turbulent and the Colebrook formula is used. Finally, the Moody friction factor is determined and combined with the Darcy formula, Equation 1, to determine the fluid friction losses.

Results

Numerous results were checked against values given in “Cameron Hydraulic Data Book”2 and found to vary by less than one percent. A term called “Delta-F” is also given in the spreadsheet which gives an indication of the variance in the Colebrook equation and the calculated value. Values of Delta-F less then 0.05 indicates an accuracy of three or more decimal places.

Alternate Method:

An alternate method of determining the friction factor is given by Chen3. His method of calculating the friction factor is explicit and does not require iterations to solve. This method has been by studied by Gregory and Fogarasi4, and found to give satisfactory values compared to the Colebrook equation. For those interested in this alternate approach, see Equation 6.

Equations 6 and 7

Where:

f = Fanning friction factor (1/4 of Moody friction factor)
D = Inside diameter, m [ft]
e = absolute pipe roughness, m [ft]
Re = Reynolds Number

To learn more about friction factor and its impact on piping and pipeline calculation, design and surveillance, refer to JMC books and enroll in our ME41PL4PL61, and G4 courses.

By: Joe Honeywell
Instructor & Consultant

References:

  1. “Elementary Numerical Analysis”, by S. D. Conte, McGraw-Hill Book Company, 1965, pp 30
  2. “Cameron Hydraulic Data Book”, by Ingersoll-Rand Company, Woodcliff, N. J., 15 ed., pp 3-49 to 3-85
  3. Chen, N.H., An Explicit Equation for Friction Factor in Pipe, Ind. Eng. Chem. Fund., 18, 296,1979
  4. Gregory, G.A. and Fogarasi, F., Alternate to Standard Friction Factor Equation, Oil & Gas Jour. Apr. 1 1985, pp 127.

Excel Program Input and Output

ResultsResults

Did you enjoy this post? Do you have a question?
Leave us a Comment below!

Want to read more articles like this?
Subscribe to our RSS Feed or visit the Tip of the Month Archives for past articles.

Comments

33 responses to “Friction Pressure Drop Calculation”

  1. Aranzazu Camacho

    How can I get the spreadsheet?

  2. Roberto Abarilla

    Hello, I also want to know, how could I get a spreadsheet? Thanks very much!

  3. Antonio Francisco

    I need the spreadsheet for quick calculation

  4. Martin Schmid

    how did you arrive at 526.76 m^3/h = 310 GPM?
    310 GPM = 70.4 m^3/h

  5. Please send the excel formula sheet. This would speed up my calcs. Thanks you very much.
    Tony Gawrysiak
    Technical Manager
    ComfortPro Systems

  6. Paul Gerber

    Can you please send me the spreadsheet for friction pressure drop calculation? Thank you.

  7. Ken Juran

    Can you please send me the spreadsheet for friction pressure drop calculation? Thank you.

  8. Rom Ramones

    Can you please send me the spreadsheet for friction pressure drop calculation? Thank you.

  9. vamsi krishna prasad

    please send me the spread sheet to :sarada.vasireddy@gmail.com

  10. Juan Carlos

    Por favor hoja de calculo

  11. Juan Carlos

    enviarme a charleeinc@hotmail.es y muchas gracias

  12. Jordan Whetsell

    Could I please get the spreadsheet for calculations?

  13. Where can I download the Friction Pressure Drop Calculation

  14. reza

    Can you please send me the spreadsheet ?

  15. SteWe

    Can you please send me the spreadsheet for friction pressure drop calculations? Thank you very much.

  16. SteWe

    Thank you!

  17. Gary S.

    Can you please send me a copy of the spreadsheet that you referred to? Thanks!

  18. Hey very interesting blog!

    My webpage … 24 hour ac repair 19107

  19. Fastidious respond in return of this question with genuine arguments and describing the whole thing regarding
    that.

    Also visit my site; sky broadband help telephone number

  20. It’s going to be finish of mine day, but before end I am reading this great article to increase my knowledge.

    Look into my webpage; you could try here (crawfordmwel.centerblog.net)

  21. Magnificent goods from you, man. I’ve understand your stuff previous to and you’re just extremely wonderful.
    I actually like what you have acquired here, certainly like what you are saying and the way in which you say it.
    You make it enjoyable and you still care for to keep it sensible.
    I can not wait to read much more from you. This is actually
    a great site.

  22. This will be a excellent web site, might you be interested in doing an interview regarding how you created it? If so e-mail me!

  23. Jon

    Hi Sr. very good note, please can i get the spread sheet jony_cosacurio@yahoo.com

  24. Interesting article and comparisons. I also would like the spread sheet calculator; but, wonder if there is one for gas flow or what are the factors that need to be changed for gas production considerations.

  25. this program very important to me please send this program

  26. DreamProxies.com — cheapest high level private proxies with 50% low cost! Elite quality, Limitless proxies, Extremely speed and Cheapest price ranges : just $0.25 every proxy! Finest non-public proxies simply from DreamProxies.com

  27. Rene Groenewege

    Will you please send me a copy of your spreadsheet?

    It will greatly help me with my calculations.

    Thanks a lot for your help!!

  28. Will you please send me a copy of your spreadsheet?

  29. Glen Millar

    Will you please send me a copy of your spreadsheet?

  30. ” I am unsure where you’re getting your information, nevertheless great topic. I must spend some time learning or understanding more. Thank you for fantastic information. I was trying to find this information. “

  31. Diana

    Hello Joe, is it possible for you to send me the spreadsheet for a quick calculation? I would appreciate it. My email is tati_3217@hotmail.com

  32. Will there be a part 2 some time in the future? I simply have to tell you that your pages are really awesome. I was walking on the beach on Monday when I discovered your blog. Some really excellent information here. Try to make the guest blog as awesome as possible by promoting and dropping links. Wow, that is unbelievable.