Where to Find a Compressible Air Flow Rate Pressure Drop Calculator Spreadsheet
To obtain a compressible air flow rate pressure drop calculator spreadsheet, click here to visit our spreadsheet store. Why use online calculators or hand calculations when you can buy a compressible air flow rate pressure drop calculator spreadsheet for a very reasonable price. Read on for information about compressible air flow rate pressure drop calculator spreadsheets for compressible flow of air in a pipe.
Air Pipe Flow Conditions for a Compressible Air Flow Rate Pressure Drop Calculator Spreadsheet
Air Pipe Flow Conditions for a Compressible Air Flow Rate Pressure Drop Calculator Spreadsheet
For flow of air in a pipe with the frictional pressure drop less than 20% of the inlet air pressure, satisfactory results can be obtained using incompressible flow calculations with the Darcy-Weisbach equation. For background information on that type of calculation, see the article, "Pipe Flow-Friction Factor Calculations with Excel Spreadsheets." If the frictional pressure drop is more than 20% of the incoming air pressure, then Fanno Flow equations should be used, as discussed here using a compressible air flow rate pressure drop calculator spreadsheet.
Equations for Air Pipe Flow Calculations with a Compressible Air Flow Rate Pressure Drop Calculator Spreadsheet
Equations for Air Pipe Flow Calculations with a Compressible Air Flow Rate Pressure Drop Calculator Spreadsheet
Shown below are the primary equations used in the compressible air flow rate pressure drop calculator spreadsheet being discussed here for compressible flow of air in a pipe. These equations are for compressible pipe flow with negligible heat transfer with the surroundings, but including effects of friction in the flow.
The parameters in these fanno flow equations are as follows:
- f = Moody friction factor
- L = pipe length
- D = pipe diameter
- k = adiabatic constant for the flowing air
- M = mach number
- T = air temperature
- P = air pressure
- ρ = air density
Parameters with an asterisk refer to conditions at the "choke point" in the pipe, where the Mach number is 1.
A Compressible Air Flow Rate Pressure Drop Calculator Spreadsheet
The screenshot below shows part of a compressible air flow rate pressure drop calculator spreadsheet. These calculations are for air flow in a pipe, in S.I. units. This Excel spreadsheet and others for compressible pipe flow calculations in a fanno flow excel spreadsheet are available in either U.S. or S.I. units at a very reasonable cost in our spreadsheet store.
References
1. Bengtson, Harlan H., "Fanno Flow Excel Spreadsheet for Air Flow in a Pipe," an online blog article
Compressible Air Flow Rate Pressure Drop Calculator Spreadsheet
Where to Find a Compressible Air Flow Rate Pressure Drop Calculator Spreadsheet