A Computer Program for Pipe Friction Factor Calculation

摘要

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.