Compressible Flow of an Ideal Gas (Updated: 3/14/2018)

This workbook implements the 1-D, compressible flow functions for a perfect gas in the form of extrinsic (user-written) VBA functions.
The four worksheets include:
- Isentropic flow (with area change),
- Normal shocks,
- Fanno Line flow (adiabatic flow at constant area with friction)
- 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 above. With the scrollbar 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 their own Excel calculations on a new worksheet.