Where to Find a Fanno Compressible Flow Calculator Spreadsheet
To obtain a Fanno Compressible Flow Calculator Spreadsheet, click 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.
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.
References
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.