“colebrook-white”

Excel Calculations

Excel Calculations Sunday, April 24, 2011 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. I'll outline the two most convenient methods