Scribd
Upload
122 views1 page

Colebrook White Equation

The document describes using two different methods to calculate the friction factor for fluid flow in a pipe based on the Colebrook-White equation. Method 1 uses VBA and goal seek to determine a friction factor of 0.039083915. Method 2 uses worksheet iteration to calculate a friction factor of 0.039083923, which closely matches the first method. The document tests fluid flow parameters like pipe roughness, diameter, viscosity, density and velocity to solve for the friction factor using two techniques.

Uploaded by

Rendi Kurniawan
Copyright
© Attribution Non-Commercial (BY-NC)
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
122 views1 page

Colebrook White Equation

The document describes using two different methods to calculate the friction factor for fluid flow in a pipe based on the Colebrook-White equation. Method 1 uses VBA and goal seek to determine a friction factor of 0.039083915. Method 2 uses worksheet iteration to calculate a friction factor of 0.039083923, which closely matches the first method. The document tests fluid flow parameters like pipe roughness, diameter, viscosity, density and velocity to solve for the friction factor using two techniques.

Uploaded by

Rendi Kurniawan
Copyright
© Attribution Non-Commercial (BY-NC)
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

The Colebrook-White Equation

[Link] Parameters Pipe roughness (m) Pipe Diameter (m) Viscosity (Pa s) Density (kg m-3) Velocity (m s ) Reynolds Number
-1

0.0005 0.05 0.001 998 1 49900

Cell Name e D mu rho u Re

Method 1 - Using VBA and Goalseek Turb Friction Factor Check 5.28548E-07 Friction Factor 0.039083915 Method 2 - Using Worksheet Iteration Friction Factor 0.039083923

fCheck f

You might also like