The XLS Steam Tables category contains Excel files for automated lookup of water-and-steam thermodynamic properties (saturated liquid, saturated vapor, and superheated vapor). Browse the files offered and determine which will work the best for you to get started, and then use “Save As…” to extend the work to apply to your own project.
Steam Tables (Moran and Shapiro) — Download this file for tabular access to Moran’s thermodynamic properties of saturated liquid, saturated vapor, and superheated vapor in both SI and English units. This file is in the traditional .xlsx format.
Steam Tables Example Problem for Closed System — Worked out example problem for a simple closed system starting with the basic steam tables tool, above.
Steam Tables Example Problem (English Units) — Worked out example problem for an open system starting with the basic steam tables tool, above.
Steam Tables Example Problem (SI Units) — Worked out example problem for an open system starting with basic steam tables tool, above.
Steam Tables Starter Kit (macro-enabled tool) — Download this file for access to begin using Excel custom formulas for evaluating thermodynamic properties of water and steam. Link to the PPT file for background and tips for getting started. The source data is from Moran and Shapiro textbook tables.
Steam Turbine Analysis Example — Started with Steam Tables Starter Kit (xlsm) file, used Save As… in order to preserve the custom Excel functions and then perform an analysis on real equipment.