Title: Compressible Fanno Flow Through a Pipe
Contributor: Harlan Bengtson, Ph.D., P.E. , Former Dean of Engineering, Southern Illinois University Edwardsville
Published Date: September/2018
Content Type: Spreadsheet
Fanno Flow calculations for adiabatic compressible gas flow in a pipe are very time-consuming as they require multiple levels of difficult calculations using tables and iterative solutions. This Excel workbook streamlines these calculations by automating the iterative calculation of the friction factor and the overlaying iterative solution of the Fanno Flow equation.
Incompressible flow calculations are made first to check whether the incompressible flow calculations are adequate. If compressible flow calculations are required, worksheets using a Fanno Flow Calculator are provided to calculate the frictional pressure drop, flow rate or required diameter based on input of the other pipe flow parameters and inlet gas temperature and pressure. The calculations can be made for either turbulent or laminar flow and can include the effect of minor losses.
There is also a worksheet that allows the user to obtain the density and viscosity for any of 21 listed gases at the user specified temperature and pressure