Pipe Flow/Friction Factor Calculations Using Excel Spreadsheets

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

Description:

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.