An algorithm for the calculation of the Darcy friction factor, for the estimation of pressure losses in pipe flows, is presented. The algorithm includes the five correlations that generate the Moody chart. The codification of the algorithm in Visual Basic for Applications, for use in the MS Excel spreadsheet, is presented. The Prandtl and Colebrook correlations, which are not explicit in the friction factor, are solved through a Newton numerical method; the derivatives of the functions are obtained through a numerical central perturbation procedure. The algorithm also calculates the values of the friction factor for the critical flow zone, between the zones of laminar and turbulent flow, in order to avoid numeric discontinuities during optimization processes. The results are shown as an Excel-generated Moody chart.
Determination of the Darcy Pipe Flow Friction Factor as a Routine in Visual Basic for MS Excel
- Views Icon Views
- Share Icon Share
- Search Site
Marti´n-Domi´nguez, IR, Alarco´n-Herrera, MT, & Escobedo-Bretado, JA. "Determination of the Darcy Pipe Flow Friction Factor as a Routine in Visual Basic for MS Excel." Proceedings of the ANES/ASME Solar Joint 2006 XXXth Mexican National Solar Energy Week Conference. ANES/ASME 2006 Joint XXXth National Solar Energy Week. Puerto de Veracruz, Mexico. October 2–6, 2006. pp. 55-58. ASME. https://doi.org/10.1115/ANES/ASME2006-0016
Download citation file: