ME215: Thermodynamics I  and  ME305: Thermodynamics II
ME215 is sophomore-level course covers the basic concepts of properties of a pure substance, the ideal gas relationships; heat, work and the first law of thermodynamics; heat engines, refrigerators and heat pumps, the second law of thermodynamics and the Carnot Cycle; and the concept of entropy, isentropic processes and isentropic efficiency.
ME 305 is taken during the junior year and this is the applied thermodynamics course. Power and refrigeration cycles are covered in depth in the first one-third of the course. The remainder of the course is divided into four approximately equal sections: gas mixtures and gas-vapor mixtures including psychrometrics and air conditioning processes, chemical reactions, chemical and phase equilibrium, and compressible fluid flow.

Excel Tools Developed for Thermodynamics:
The following are excel addins and modules developed for use in the ME215 course. Right click the links and select "Save Link Target As" to download the files. Visit our Tutorials section to learn how to utilize them.

"All-in-one" Add-in for thermodynamics, which includes XSteam, R134a, R22.
thermo.msi - this is the Microsoft Installer kit that puts the Add-in in the right directory
These are the self-install modules contained in the above .msi package
thermotables.xlam (2007 version)
thermotables.xla (2003 version)
thermotableshelp.chm (compiled help file)

Below are the individual components of the thermotables add-in.  You won't need them if you got the entire package above.

XSteam_2007.xlam (2007 Version)
XSteam.xla (2003 Version)
This addin contains functions that can be used to find various properties of steam. The original functions were written by Magnus Holmgren who runs the X-eng Website. We have editted the X-gen functions to make them more user friendly while increasing the range of properties that can be found.

Refrigerant 134A.xlam (2007 Version)
Refrigerant 134A.xla (2003 Version)
This addin contains functions that can be used to find enthalpy, entropy, internal energy, and specific heats of Refrigerant 134A.

Refrigerant 22.xlam (2007 Version)
Refrigerant 22.xla (2003 Version)
This addin contains functions that can be used to find enthalpy, entropy, internal energy, and specific heats of Refrigerant 134A.

"All-in-one" Add-in for ideal gas properties and gas dynamics functions
idealgas.msi - this Microsoft Installer kit that puts the Add-in in the right directory
These are the self-install modules contained in the above .msi package
IdealGas.xlam (2007 version)
IdealGas.xla (2003 version)
GasDynamics.chm (compiled help file)

Below are the individual components of the ideal gas add-in.  You won't need them if you got the entire package above.

Ideal Gas Properties_2007.xlam (2007 Version)
Ideal Gas Properties.xla (2003 Version)
This addin contains functions that can be used to find enthalpy, entropy, internal energy, and specific heats of various ideal gases.

GasDymanics.xlam (2007 version)
GasDynamics.xla (2003 version)
GasDynamicsHelp.chm (compiled help file)
This addin contains functions for flow of an ideal gas, including isentropic flow, normal shock, oblique shock, Prandtl Meyer expansion, Fanno flow, and Rayleigh flow.
The Compiled Help File must reside in the same folder as the add-in in order for it to be found when requested.