Related Resources: excel calculators

Compressible Flow of an Ideal Gas

NOTE:

  • Refunds are not awarded after excel files have been downloaded - review your membership agreement for details.
  • This excel spreadsheet may contain macros which will need to be enabled in your excel application, see web page: Enable macros in Downloaded excel files
  • Units utilized within calculators are either SI or Imperial (some enable both SI and Imperial) and member (you) are responsible for conversions. Ensure that you verify units utilized in excel application meet your requirements before downloading.

Engineering Calculators

Compressible Flow of an Ideal Gas

This workbook implements the 1-D, compressible flow functions for a perfect gas.  The four worksheets include:

1.  Isentropic flow (with area change),
2.  Normal shocks,
3.  Fanno Line flow (adiabatic flow at constant area with friction)
4.  Rayleigh Line flow (stagnation temperature change in the absence of friction and area change). 

User inputs are the Mach number and the ratio of specific heats.   Results are returned in both tabular and graphical form, as seen in the figure to the right.  With the slider provided the user can test the effect of different specific heat ratio immediately. A user form allows the user to input derived quantities, e.g., the Mach number downstream of a normal shock and have the program find the upstream Mach number. While results are returned in tabular and graphical form on the four sheets included in the Compressible.xls workbook, it is expected that the user will invoke any of the 16 VBA functions provided here in his or her own Excel calculations on a new worksheet.

Download: Compressible Flow of an Ideal Gas