Incompressible Annulus and Duct Flow Calculations

Title: Incompressible Annulus and Duct Flow Calculations

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 duct flow calculations by automating the iterative calculation of the friction factor and the iterative processes needed to calculate flow rate. Worksheets are included to calculate frictional pressure drop (for specified flow rate) and to calculate flow rate (for specified pressure drop) for each of three duct configurations: circular annulus, rectangular and other non-circular shapes. The worksheets for circular annulus and rectangular duct calculations can handle either laminar or turbulent flow. All of the worksheets include minor losses in the calculations. Also included is a worksheet to calculate density and viscosity at user specified temperature for more than 70 liquids, as well as a worksheet to calculate the sum of the minor loss coefficients.

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