A Computer Program for Pipe Friction Factor Calculation

Full Text PDF PDF
Author(s) Tonye K. Jack
Pages 266-269
Volume 2
Issue 2
Date February, 2012
Keywords friction factor, fluid friction factor, Colebrook friction factor, Colebrook-White friction factor, Swamee-Jain friction factor, fluid mechanics programs, Microsoft Excel engineering programs

The iterative nature of the Colebrook pipe friction factor equation can be overcome by using the Visual Basic for Applications (VBA) solver options provided in Microsoft Excel TM. A Friction Factor Calculator that spans the entire fluid flow regime is presented together with the program guide to develop one. The results are validated by comparison to results from Moody Friction factor Chart. A solution method for the explicit turbulent equation of Swamee-Jain through the use of Microsoft Excel Functions is also presented.

< Back to Feb Issue