Last Updated: 3/14/2018


Text Box:  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


Usage, Disclaimer, Notes

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. 



Text Box:  
Gas Problems?  Call us!








Back to Spreadsheets

Back to Heat Transfer Today Main Page

R. J. Ribando Home