**Last Updated: 3/14/2018**

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

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.

**Oblique
Planar Shocks****
(3/14/2018) **

This
spreadsheet will compute two-dimensional, oblique shocks. The user must be willing to learn
Excel’s Solver Add-in in order to use it! It is set so that the user can easily
input the upstream Mach number and turn angle. Using the Solver constraints the user
can solve for either the strong (M2 <1) or weak (M2 >1) solution.