[go: up one dir, main page]
Scribd
Upload
133 views4 pages

Friction Factor Formulas For Cheresources

This document compares solutions to the Colebrook equation for friction factor (f) using three different formulas across a range of relative roughness and Reynolds number inputs. It also evaluates some explicit equations and a user-defined function solution. For each test case, the iterative solutions from the three formulas are compared to a "check value" and each other, with percent deviations calculated. Maximum reported errors for some of the explicit equations are also stated.

Uploaded by

psaayo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
133 views4 pages

Friction Factor Formulas For Cheresources

This document compares solutions to the Colebrook equation for friction factor (f) using three different formulas across a range of relative roughness and Reynolds number inputs. It also evaluates some explicit equations and a user-defined function solution. For each test case, the iterative solutions from the three formulas are compared to a "check value" and each other, with percent deviations calculated. Maximum reported errors for some of the explicit equations are also stated.

Uploaded by

psaayo
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 4

Colebrook Equation Solution Comparisons

Relative Roughness =
Reynolds Number =

INPUT
0.0000000
1,000,000

Formula*

Iterative Solution
using Goal Seek

Check Value
against Eq 1

0.0116451

Check Value
to given
equation
1.000000

1/f^.5 = -2log(e/3.7D + 2.51/(R*f^.5))


1/f^.5 = 1.74-2log(2*e/D + 18.7/(R*f^.5))

0.0116550

1.000000

1.000468

1/f^.5 = 1.14+2log(D/e)-2log[1+9.3/Re*(e/D)*f^.5]

0.0116396

1.000000

0.999743

1.000000

Using the formula stated as Eq 1


f
0.0116451

1/f^.5
9.266784352

-2log(e/3.7D + 2.51/(R*f^.5))
9.266784351

Diff x 1000
0.0000011

1/f^.5
9.262820283

1.74-2log(2*e/D + 18.7/(R*f^.5))
9.26282028

Diff x 1000
0.0000009

1/f^.5
9.268961839

1.14+2log(D/e)-2log[1+9.3/Re*(e/D)*f^.5]
9.268961838

Diff x 1000
0.0000009

Using the formula stated as Eq 2


f
0.0116550

Using the formula stated as Eq 3


f
0.0116396

Colebrook Equation Solution Comparisons


Relative Roughness =
Reynolds Number =

INPUT
0.0001500
1,000,000

Formula*
1/f^.5 = -2log(e/3.7D + 2.51/(R*f^.5))

Iterative Solution
using Goal Seek
0.0141058

Check
Value
1.000000

1/f^.5 = 1.74-2log(2*e/D + 18.7/(R*f^.5))

0.0141073

1.000000

=fEq2()

#VALUE!

#VALUE!

1/f^.5 = 1.14+2log(D/e)-2log[1+9.3/Re*(e/D)*f^.5]

0.0140955

1.000000

=fEq3()

#VALUE!

#VALUE!

1/f^.5
8.419792667

-2log(e/3.7D + 2.51/(R*f^.5))
8.419792667

Diff x 1000
0.0000001

1/f^.5
8.419328968

1.74-2log(2*e/D + 18.7/(R*f^.5))
8.41932897

Diff x 1000
0.0000001

1/f^.5
8.422864022

1.14+2log(D/e)-2log[1+9.3/Re*(e/D)*f^.5]
8.422864021

Diff x 1000
0.0000001

#VALUE!

User Defined UDF Solution


Function
=fEq1()
#VALUE!

Check
Value
#VALUE!

Using the formula stated as Eq 1


f
0.0141058

Using the formula stated as Eq 2


f
0.0141073

Using the formula stated as Eq 3


f
0.0140955

Colebrook Equation Solution Comparisons


Relative Roughness =
Reynolds Number =

INPUT
0.0000000
64,500

Formula*

Iterative Solution
using Goal Seek

Check Value
against Eq 1

% Deviation
to Eq1

1/f^.5 = -2log(e/3.7D + 2.51/(R*f^.5))

0.0197517

1.000000

1/f^.5 = 1.74-2log(2*e/D + 18.7/(R*f^.5))

0.0197732

1.000610

0.108697%

1/f^.5 = 1.14+2log(D/e)-2log[1+9.3/Re*(e/D)*f^.5]

0.0197399

0.999665

-0.059633%

Explicit Equations:

Max Error or Limits

Serghide's implementation of Steffenson


UDF "fSerg"

0.0197511
#VALUE!

0.999983
#VALUE!

Zigrang and Sylvester

0.0197293

0.999363

Swamee and Jain Eq

0.0196191

0.996228

Altshul-Tsal Eq

0.0198212

1.001973

-0.002978%
#VALUE!

-0.113527%
Smooth Pipe w/ Reynolds# of ~64,500
% Deviation to Eq 2 = -0.221983%
-0.671401%
10^-6 <e/D <10^-2 and 5000 < Reynolds# < 10^8
0.351932%

Serghide's implementation of Steffenson


A=
7.46
B=
7.07
C=
7.12
f=
0.0197511
Colebrook Ratio:
1.000017
Error to Goal Seek:
-0.002978%
Serghide's Max Error found is in Smooth Pipe at Rey of ~170,000

Smooth Pipe w/ Reynolds# of ~170,000

User Define Func "fSerg"


fSerg =
#VALUE!
#VALUE!
#VALUE!

Zigrang and Sylvester maximum error is in Smooth Pipe at Reynolds of ~64,500


Swamee and Jain has stated limits of 10^-6 <e/D < .01 and 5000 < Reynolds# < 3x10^8

Altshul-Tsal Eq
f ' = 0.11(12e/D + 68/Re)^.25 =
0.0198212
0.85*f ' + 0.0028 =
0.0196480
Selected f based on 0.018:
0.0198212
Error to fCalc:
0.352%
Note: Units for "D" are normally in inches but formula in C56 is modified for consistence with RelRoughness in C3
I have not found any stated limits for Altshul-Tsal but large errors are found at high e/D's

e/D = .05 independent of Reynolds#

Colebrook Equation Solution Comparisons


Relative Roughness =
Reynolds Number =

Determine if Input Point is in the Laminar Flow, Critical Zone,

INPUT
0.0000000
100,000

Transition Zone or Comp Turbulence, Rough Pipes Zone*


e/D * R * f^.5 =
#VALUE!
#VALUE!
* Terminlogy is from the original Moody Diagram

Formula*

Iterative Solution
using Goal Seek

Check
Value

% Error
to Eq1

1/f^.5 = -2log(e/3.7D + 2.51/(R*f^.5))

0.0179898

1.000000

1/f^.5 = 1.74-2log(2*e/D + 18.7/(R*f^.5))

0.0180085

1.000000

0.104250%

1/f^.5 = 1.14+2log(D/e)-2log[1+9.3/Re*(e/D)*f^.5]

0.0179795

1.000000

-0.057194%

User Defined UDF Solution


Function
=fEq1()

% Error

Special Cases

to UDF "fEq1"

Comp Turb Form of Eq1; 1/f^.5 = 2log(3.7/e/D)

Smooth Pipe Case

0.0022384
#VALUE!

0.309920

#VALUE!

0.0176342
0.988916
#VALUE!
for Reynolds Number < 10^5;
f = 0.3164/Reynolds# ^ 0.25
for 10^5 < Reynolds Number < 3x10^6; f = 0.0032 + 0.221/Reynolds# ^ 0.237
Deviation between the two Smooth Pipe Cases:
0.897656%

0.0177925
0.0176342

#VALUE!

Check
Value
#VALUE!

You might also like