Incompressible Flow in Pipes and Channels

Title: Incompressible Flow in Pipes and Channels

Contributor: Harlan Bengtson Ph.D., P.E. , Former Dean of Engineering, Southern Illinois University Edwardsville

Published Date: May/2015

Content Type: Spreadsheet


This Excel workbook streamlines normally time-consuming incompressible pipe flow calculations by automating the iterative calculation of the friction factor and the iterative processes needed to calculate either flow rate or required diameter. The worksheets are useable for either turbulent or laminar flow and include minor losses in the calculations.

It includes worksheets to calculate:

1. Density and viscosity at a user specified temperature for more than 70 liquids

2. The sum of the minor loss coefficients

3. Frictional pressure drop

4. Flow rate

5. Minimum required diameter

The workbook is useable with either the Fanning Friction Factor or the Moody Friction Factor.

Equations used: Churchill Equation, Colebrook Equation, Darcy-Weisbach Equation, Fanning Friction Factor, Moody Friction Factor.