Excel Air Systems: This category of Excel (xlsx) files consists of various example problems for the ideal gas, air, along with thermodynamic properties for air using the variable specific heat model.
Air Compressor Power and Cost Calculations — basic analysis for often needed questions in industry and manufacturing. Uses basic ideal gas with constant specific heat model.
Air Properties (Moran) — Tabular data for air using variable specific heat model. Includes Excel scheme for looking up and interpolating values for any input variable (T, h, u, so, Pr, Vr) and returning the other variables. Example1: I have found h from the first law and need to find the corresponding temperature. Example2: I have an isentropic process so have determined Pr2 = Pr1 (P2/P1) and I need to find the corresponding temperature.
Air Tables (Variable Specific Heat) Starter Kit — Download this file for access to begin using Excel custom formulas for evaluating thermodynamic properties of the ideal gas air, modeled as having variable specific heat. Link to the PPT file for background and tips for getting started. The source data is from Moran and Shapiro textbook tables.
Thermodynamic Properties of Air Using Variable Specific Heat – Uses data from multiple sources. Uses Moran for basic air tables for determining h2-h1 = Integral Cp dT where T1 and T2 are known. Other tables have temperature-dependent values for thermal conductivity, viscosity, and Prandtl Number (from Holman heat transfer text).
Air Standard Cycle Analysis Demos — Basic air-standard cycle analyses, clearly explained, for Otto, Diesel, Dual, and Brayton cycles. Uses ideal gas model with constant specific heat. The user controls the key input parameters (like minimum and maximum temperatures and pressures) and has the ability to visualize the effects on T-s and/or P-v diagrams. Also gives ability to explore how thermal efficiency is affected by the key input parameter values.
Isobar Curves for Ideal Gases on Ts Diagrams — Download this file to see how to draw isobar curves (lines of constant pressure) on a T-s diagram for any ideal gas with constant specific heat. Also includes demonstration of isochor curves (lines of constant specific volume) on T-s diagram and isothermal (constant temperature) lines on a P-v diagram.
Variable Specific Heat Values for Various Ideal Gases — Table of coefficients for 4th order polynomial model for Cp as a function of temperature for the following ideal gases: CO, CO2, H2, O2, N2, Air, SO2 (sulfur dioxide), CH4 (methane), C2H2 (acetylene), Neon.
Pitot Probe Air Velocity Calculation: This simple file demonstrates how to calculate velocity in a duct or in the environment from a pitot probe and water manometer sensor arrangement.