For some reason, most people still do not understand how my Colebrook-White solution works.
It has been tested, and re-tested over and over, and always gets the right answers if you don't make
a weird error.
This may help those who are questioning "Why does it work?"
In the Wikipedia you can read about the Lambert W function. Here's a quote near the beginning...
"The Lambert W relation cannot be expressed in terms of elementary functions. It is useful in combinatorics, for instance in the enumeration of trees. It can be used to solve various equations involving exponentials and also occurs in the solution of delay differential equations, such as y'(t) = a y(t − 1)."
The "a" represents the numbers that don't change as we move toward the answer, like the numbers for Re, Rr, 2,51, 3.7. We are computing "1/sqrt(f)" which is the y in that quote. y(t-1) should by y to the sub (t-1), the y value of y just before the y'(t). To appear simpler to show in Excel I write is like this y2=a*y1. In other words we assume an initial value for y1 and multiply by a, the result is y2, Then do another step where we use the y2 result as y1 and get another y2. The "funnel" that directs the solution is the value of "a".
Colebook-White Equation written for Excel is 1/sqrt(f)=-2*Log(Rr/3.7+2.51/Re*1/sqrt(f)). Above I said about the Lambert W function y2=a*y1. y1 is our initial guess, "a" is the complex part "-2*Log(Rr/3.7+2.51/Re*". .... y1 is part of that result like Lambert showed as "a*y1".
Some argue that this is not a solution, just like pi() is not 3.14159. They said pi() has an infinity of digits following the "3." I would not disagree about the math, but for engineering designs a specific number of decimals places works for specific designs. In Excel we can easily get 15 decimal places which exceeds the needs of all the designs engineers normally do.
The attached XLS version of Excel shows how simple my method is.to find the Darcy Friction Factor.
Please comment and ask questions. Your questions will help me know how to explain it,


FB

