|Forum Topic||Post Reply Login|
Rate this:(3.5/5 from 2 votes)
|The Colebrook equation calculates the friction coefficient to determine pressure loss in ducts, tubes and pipes. The Colebrook friction coefficient is present on both sides of the equation requiring an iterative process to solve for it's value.|
The equation is:
1/f1/2 = -2*Log(0.269541779*k/d+2.51*1/R/f1/2)/Log(10)
f = adjustment factor
k = roughness of surface
d = diameter
R = Reynolds number (ratio ratio of dynamic pressure and shearing stress)
We can calculate the Colebrook equation in Excel by setting up the following spreadsheet.
The formula is in cell C5. In order to solve the equation for the adjustment factor f in cell C5, we can employ the Solver Add-in. The Solver Add-in can be activated by choosing Add-ins from the Excel menu (Tools > Add-ins for Excel prior to 2007 and Excel Options under the Office Button in Excel 2007 and higher).
To solve the equation the following parameters need to be set in the Solver dialogue:
|Excel Business Forums Administrator|
|Posted by Excel Helper on|
|There are currently no replies to the "Colebrook Equation" topic of the Excel Help Forum for Analyzing Manufacturing and Engineering Processes.|
|Find relevant Excel templates and add-ins for Colebrook Equation in the Excel Business Solutions Directory|