Development of a Heat Transfer Analysis Software by Using Microsoft Excel


  • Jun Chun Soo Universiti Tun Hussein Onn Malaysia
  • Hj. Mohd Azwir bin Azlan Universiti Tun Hussein Onn Malaysia
  • Mohammad Kamil bin Abdullah Universiti Tun Hussein Onn Malaysia


Heat Transfer, Microsoft Excel, VBA Programming, Thermal Resistance Concept, Finned Surfaces, External Forced Convection, Internal Forced Convection, Natural Convection, Combined Forced and Natural Convection, Heat Exchangers


Heat Transfer is the study of three different modes which are conduction, convection, and radiation. However, in order to analyze the problem, it usually requires a lot of times going through lots of tables and figures to locate the data and determine the suitable formulas. Therefore, this project aims to develop a software that can analyze heat transfer problems which can help students, lectures or researchers to solve the problems in the simplest way possible. All the results should be able to obtained instantaneously after entering all the required inputs and can be dynamically updated by its own if certain input changes. The software was built by using Microsoft Excel with VBA coding and macros, while the formulas and equations used were mainly referred from the Cengel Heat Transfer textbook, 5th Ed. The developed software was able to solve most of the problems that are available in heat transfer with an accuracy up to 95%. Overall, the development process had been considered as successful and the main objective has been achieved.




How to Cite

Soo, J. C., Hj. Mohd Azwir bin Azlan, & Mohammad Kamil bin Abdullah. (2022). Development of a Heat Transfer Analysis Software by Using Microsoft Excel. Research Progress in Mechanical and Manufacturing Engineering, 3(1), 893–904. Retrieved from