At the University of Alabama, the mechanical engineering students wrap up their thermal-science experience with one of the following two courses:


ME415: Energy Systems Design
This is a classic thermal systems design course. It is application intensive and covers flow in pipes and piping systems, pumps and pumping systems, heat exchangers and heat exchanger design, and thermal system simulation.

Excel Tools Developed for ME415:
The following are excel addins and modules developed for use in the ME415 course. Several functions including Swamee-Jain and Churchill friction, Hardy Cross, and Viscous Pump. 

Right click the links and select "Save Link Target As" to download the files. Visit our Tutorials section to learn how to utilize them.

ME 415 Add-in.xla      (2003 version)
ME 415 Add-in.xlam  (2007 version)
Excel2007: to allow the help descriptions in these add-ins to load properly, you will need to go to Icon->Excel Options->Trust Center->Trust Center Settings...->Macro Settings and check the "Trust access to the VBA object model" and click "OK" (don't you love MS security?)

This compiled help file should also be downloaded and stored in the same directory as the add-in:
415 Help.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.





ME407: Heating, Ventalation, and Air Conditioning
This course covers refrigeration and refrigeration systems, psychrometrics and moisture control, building cooling load calculation and equipment selection, and piping and duct system design.

Excel Tools Developed for ME407:
The following are excel addins and modules developed for use in the ME305 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.