New Simplified, Accurate, method for Colebrook
A New Simplified, Accurate, method for Colebrook equations
by (ragknot) Harrell Geron, NRCS Civil Engineer
This is the most simple and accurate solution for the Darcy Friction Factor with Excel. It works with the popular Colebrook-White equations. After learning this method, you can design your own procedures.
Here are four Colebrook-White equations written to work in Excel.
1/sqrt(f)=-2*Log(Rr/3.7+2.51/Re*1/sqrt(f))
1/sqrt(f)=1.14-2*Log(Rr+9.35/Re*1/sqrt(f))
1/sqrt(f)=1.14+2*Log(1/Rr)-2*Log(1+(9.3/(Re*Rr)*1/sqrt(f)))
1/sqrt(f)=1.74-2*Log(2*Rr+18.7/Re*1/sqrt(f))
Steps----------------
If you don't know values for Re and Rr, use these ...
Re=200000 and Rr=0.04... If you don't do Excel, just read last paragraph
1. Select one of these equations and paste it into an Excel workbook,
2. Edit the equation, remove the left side up to "="
3. Replace the Re with the Reynolds Number, Replace Rr with the relative roughness.
4. Replace the "1/sqrt(f)" near right end with the number 3.
5. The result of this will provide an initial value for 1/sqrt(f).
6. Copy that Excel cell to a cell just beneath that initial value.
7. Edit that 2nd cell. Replace that "3" with a point and click to 1st cell.
8. Copy that second cell down to about 20 rows. The result will begin repeating the same value.
9. That repeating number is the value of 1/sqrt(f), it usually is solved by step 7 on average.
10. Write one more equation that is 1 divided by the square of that repeating value.
The last step will give the Darcy f factor with at least 15 decimals of accuracy.
To check it, use it in the right side of the equation with your computed f inside the "1/sqrt(f).
That result will be the same as your repeating value that was 1/sqrt(f) if it does not equal it, then you made an error some where,
An average of 7 steps will achieve an accuracy of 15 digits (the maximum digit accuracy for Excel).