What is the Colebrook equation used for?

The Colebrook equation is generic and can be used to calculate friction coefficients for different kinds of fluid flows – like air ventilation ducts, pipes and tubes with water or oil, compressed air and much more.

What is the Haaland equation?

The Haaland equation is used to solve directly for the darcy-weisbach friction factor f for a full-flowing circular pipe. It is an approximation of the implicit Colebrook -white equation, but the discrepancy from experimental data is well within the accuracy of the data.

Which is the correct form of the Colebrook equation?

The Colebrook–White equation, sometimes referred to simply as the Colebrook equation is a relationship between the friction factor and the Reynolds number, pipe roughness, and inside diameter of pipe. The following form of the Colebrook equation is used to calculate the friction factor in gas pipelines in turbulent flow.

What’s the maximum iteration for Colebrook and White equation?

Furthermore, in every sheet, there is also a chart which depicts the results of your loops. This file can be opened with Excel 2007 or newer. For best results, go to File -> Options -> Formulas tab and put Maximum Iteration = 30,000 (max value is 32,767) and Maximum Change = 0.00001 (or even smaller).

How is Colebrook White equation used in petroleum industry?

Although the Moody diagram and the Colebrook-White equation are in popular use for pressure drop calculations, the water industry has traditionally used the Hazen-Williams equation. Recently, the Hazen-Williams equation has also found use in pressure drop calculations in refined petroleum products, such as gasoline and diesel.

How to solve the Colebrook-White equation in Excel?

I use 1e-6 for the Colebrook-White equation. Apparently Excel will repeat the iteration every time any cell value in the spreadsheet is changed, including cells that have nothing to do with the equation. So I guess this could slow down Excel if you have many references or complicated implicit formulas.