Heat Transfer Today

Educational Software for
Heat and Mass Transfer

Excel Workbooks

One-Dimensional Compressible Flows (isentropic flow with area change, normal shocks, Fanno line, Rayleigh line)

UPDATED: 03/14/2018

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

Compressible Flow Functions for an Ideal gas as a function of Mach number. Static Temperature/Total Temperature, Static Pressure/Stagnation Pressure, Density/Stagnation Density and Area/Critical Area Ratio.

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:

  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 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.


© 2021 Heat Transfer Today – All Rights Reserved.