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
||"All-in-one" Add-in for
heat transfer which includes 1-D
conduction, fin efficiencies, Nusselt
relations, and radiation functions.
heattransfer.msi - this is the Microsoft Installer
kit that puts the Add-in in the right directory.
For Excel versions 2016 or higher, see steps 3 - 10 under "Manual Install"
Here are the self-install modules containing the files in the .msi
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.
Properties of air and water useful for convection calculations. Copy the appropriate file
into the C:\Add-ins folder then activate the add-in from Excel.
Cubic spline interpolation
of data from Incropera and Dewitt in SI units
. Give temperature in degrees K.
Cubic spline interpolation of tabular data from Hodge and Taylor in English units
Give temperature in degrees F.