Last Updated: 5/18/2012
Excel/VBA
Spreadsheets for 1-D, Compressible Flow of an Ideal Gas
1.
1-D Isentropic with Area Change, Normal
Shocks, Fanno and Rayleigh Flows
2. Oblique, Planar Shocks
Compressible
Flow of an Ideal Gas (Updated:
9/10/07)
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
(New: 1/2/07)
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.
