ME309: Heat Transfer
This course is the first in heat transfer for the mechanical engineering students. It contains both fundamental concepts and applications. The course is divided into three approximately equal sections—1) one- and two-dimensional steady conduction and one-dimensional transient conduction; 2) convection concepts, boundary-layer concepts, external flow and heat transfer over flat plates, cylinders, and banks of tubes, and thermally developed flow in pipes and ducts; and 3) radiation concepts, black body enclosures, and diffuse-gray enclosures. In addition a brief introduction to heat exchangers is included.

Excel Tools Developed for ME309:
The following are excel addins and modules developed for use in the ME309 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 heat transfer which includes 1-D conduction, fin efficiencies, Nusselt correlations, effectiveness-NTU relations, and radiation functions.
heattransfer.msi - this is the Microsoft Installer kit that puts the Add-in in the right directory

Here are the self-install modules containing the files in the .msi package above
Heat Transfer.xla    (Excel 2003)
Heat Transfer.xlam (Excel 2007)
Heat Transfer.chm
Note: after downloading the file, you need to right-click on the file and check "Unblock" to allow Windows XP to open the .chm file.

Curve fit properties of air and water useful for convection calculations..
AirWaterProperties.xlam