**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.

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/sec^{2}[32.2 ft/sec^{2}]

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.

Figure 1. Moody Friction Factor Diagram

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/m^{3}[lb_{m}/ft^{3}]

µ = Fluid viscosity, kg/(m-s) [lb_{m}/(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’s^{1} 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.

Where:

f

_{n}= n^{th}iteration friction factor

f_{n+1}= (n+1)^{th}iteration friction factor

g(f_{n}) = Colebrook equation

g'(f_{n}) = 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 – m^{3}/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.

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 Chen^{3}. 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 Fogarasi^{4}, and found to give satisfactory values compared to the Colebrook equation. For those interested in this alternate approach, see Equation 6.

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 ME41, PL4, PL61, and G4 courses.

*By: Joe Honeywell
Instructor & Consultant*

References:

- “Elementary Numerical Analysis”, by S. D. Conte, McGraw-Hill Book Company, 1965, pp 30
- “Cameron Hydraulic Data Book”, by Ingersoll-Rand Company, Woodcliff, N. J., 15 ed., pp 3-49 to 3-85
- Chen, N.H., An Explicit Equation for Friction Factor in Pipe, Ind. Eng. Chem. Fund., 18, 296,1979
- 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

How can I get the spreadsheet?

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

I need the spreadsheet for quick calculation

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

310 GPM = 70.4 m^3/h

Please send the excel formula sheet. This would speed up my calcs. Thanks you very much.

Tony Gawrysiak

Technical Manager

ComfortPro Systems

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

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

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

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

Por favor hoja de calculo

enviarme a charleeinc@hotmail.es y muchas gracias

Could I please get the spreadsheet for calculations?

Jordan.a.whetsell-1@ou.edu

Where can I download the Friction Pressure Drop Calculation

Can you please send me the spreadsheet ?

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

Thank you!

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

Hey very interesting blog!

My webpage … 24 hour ac repair 19107

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

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)

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.

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!

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