Solving the Colebrook-White Equation with Excel The Colebrook-White describes the relationship between the Reynolds Number Re, the pipe relative roughness e, and the friction factor f in turbulent pipe flow.
Colebrook Equation Solver in Excel. The Colebrook (or Colebrook-White) equation is the best way to dynamically determine the Darcy-Weisbach friction factor for turbulent pipe flow. The equations were developed via a curve fit to many experimental data points. In the post below, I demonstrate how to create a Colebrook equation solver in Excel.
Colebrook Equation Solver in Excel. The Colebrook (or Colebrook-White) equation is the best way to dynamically determine the Darcy-Weisbach friction factor for turbulent pipe flow. The equations were developed via a curve fit to many experimental data points.
17.01.2010 · How to solve the Colebrook equation in Excel/VBA. I see that a lot of people have been searching for a quick and easy way to solve the Colebrook equation for the Darcy friction factor in Excel/VBA. Well, here you go.
Jan 17, 2010 · The returned result is of course the Darcy friction factor, which is meant to be used with the Darcy-Weisbach equation to calculate pressure drop. Function Colebrook(R As Double, K As Double) As Double Dim X1 As Double, X2 As Double, F As Double, E As Double X1 = K * R * 0. X2 = Log(R) - 0. F = X2 - 0.
Solving the Colebrook-White Equation with Excel. The Colebrook-White describes the relationship between the Reynolds Number Re, the pipe relative roughness e, and the friction factor f in turbulent pipe flow. Usually, we fix a value for Re and e, and compute f. However, this equation cannot be solved explicitly, so numerical iteration is needed. There's several ways we can do this in Excel.
Solving Colebrook Equation for Pipe Design, Sizing and Optimisation Calculations: Solve Within Excel Worksheet - No VBA, MACRO, UDF of SOLVER [Kumar, ...
The Colebrook-White describes the relationship between the Reynolds Number Re, the pipe relative roughness e, and the friction factor f in turbulent pipe flow.
Jul 13, 2009 · If you try to just add sqrt (A3), you get a division by zero error because the initial value of the cell is zero. One way to get around this is to add a tiny little number to A3 like this: "=1/ (-2*LOG (A2/3.7 + 2.51/ (A1*SQRT (A3+1E-300))))^2". This equation now agrees with Colebrook-White to many decimal places.
xls - A simple application of Newton's iteration to solve the Colebrook equation for friction factor f as a function of Reynolds number and nondimensional ...
To implement this procedure in Excel in order to solve the implicit Colebrook-White equation the ‘Office button’ at the upper left corner of the screen need to be pressed (Figure 3) where in ‘Excel options’, ‘Formulas’ needs to be selected (this procedure can be slightly different in …