Title: Pipe Flow/Friction Factor Calculations Using Excel Spreadsheets
Contributor: Harlan Bengtson Ph.D., P.E. , Former Dean of Engineering, Southern Illinois University Edwardsville
Published Date: June 2015
Content Type: Tutorial
This tutorial provides discussion and illustration by examples for use of an Excel spreadsheet as a pipe flow calculator, as a pipe head loss calculator, as a friction factor calculator, and to calculate the minimum required pipe diameter. Both the Fanning equation and the Darcy-Weisbach (Moody friction factor) equation are illustrated. The spreadsheet is usable for either laminar or turbulent flow and minor losses may be included in the calculations.