Fanno Compressible Flow Calculator Spreadsheet
Posted on Saturday, December 05, 2015 at 10:15 PM

 

Where to Find a Fanno Compressible Flow Calculator Spreadsheet

To obtain a Fanno Compressible Flow Calculator Spreadsheetclick here to visit our spreadsheet store.  Look in the Pipe Flow Calculations category on the Download page.  This Excel spreadsheet is intended to calculate the frictional pressure drop, gas flow rate, or minimum required diameter for adiabatic compressible pipe flow.  You can buy a convenient fanno compressible flow calculator spreadsheet  for a very reasonable price.  Calculations may be made in either U.S. or S.I. units.  Read on for information about using a fanno compressible flow calculator spreadsheet.

Background for Fanno Compressible Flow Calculator Spreadsheet

Compressible pipe flow calculations are needed for gas flow if the density of the gas changes during the flow through the pipe.  The fanno flow equations shown below can be used for calculations with a gas flow that has no heat transfer with surroundings.  Frictional losses are taken into account.  The fanno flow equations are shown below.

Compressible Pipe Flow Calculator Spreadsheet Fanno Flow Equations

Example Fanno Compressible Flow Calculator Spreadsheet

An example fanno compressible flow calculator spreadsheet is partially shown in the image below.  This Excel spreadsheet can be used to calculate the frictional pressure drop, or the gas flow rate, or the required minimum pipe diameter.  This Excel spreadsheet, as well as others for pipe flow calculations, is available for both U.S. or S.I. units for a very reasonable price in our spreadsheet store.

compressible pipe flow calculator spreadsheet screenshotReferences

1.  Munson, B. R., Young, D. F., & Okiishi, T. H., Fundamentals of Fluid Mechanics, 4th Ed., New York: John Wiley and Sons, Inc, 2002.

2. Darcy Weisbach equation history - http://biosystems.okstate.edu/darcy/DarcyWeisbach/Darcy-WeisbachHistory.htm

3. Bengtson, Harlan H.  Compressible Pipe Flow Calculatior Spreadsheet , An online blog article.

4. Bengtson, H.H., Pipe Flow/Friction Factor Calculations with Excel, an online continuing education course for Professional Engineers.