Numerical Methods in Fins with Excel and MATLAB
Downloads
In this paper, numerical methods are applied through the implementation of finite difference routines using Excel and MATLAB to calculate the heating and cooling times of a square plate supporting fins using aluminum and steel as materials.
Four cases are analyzed for the same fin model: the first one is heating with hot air, the second one is heating with hot air, the third case is heating with air and then with air but reducing the fin thickness by half, and the fourth case is cold air cooling, but in all cases the plate area remains unchanged.
Numerical methods are used as the mathematical tool to solve the system of equations derived from applying an energy balance to the nodes in the fin. These solutions provide temperature as a function of time for each material, based on the fin design. MATLAB was used to develop the simulation code, and Excel was employed to implement the equations in each cell.
The results obtained in this study align with findings from existing literature. This approach serves as a valuable tool for mechanical engineering students interested in simulating thermodynamic effects in materials and extending the analysis to estimate heating or cooling times, as well as the efficiency of fins made from other materials.
Cengel, Yunus A. 2016. “Transferencia de calor y masa” McGraw-Hill Interamericana editores.
Chapra, S.C.; Canale, R.P. (1999). Métodos Numéricos para Ingenieros. México, Mc Graw-Hill Interamericana editores.
Arboleda, Dairon Quintero. Álvarez, Rafael. (2006). Matlab aplicaciones a las matemáticas básicas. Universidad de Medellín.
Caro, Jorge David. (2024). Fenómenos de transporte con aplicaciones numéricas. Universidad de EAFIT.
Holman, J. P. (1998). Transferencia de calor. Mc Graw-Hill Interamericana editores.
Frank P. Incropera, David P. DeWitt. (1999). Fundamentos de transferencia de calor. Pearson Prentice Hall
P. E. Moreira Galván, O. Ortega Ruíz. (2025). Ley de enfriamiento de Newton con temperatura variable. Revista Mexicana de Física E.
Theodore L. Bergman, Adrienne S. Lavine, Frank P. Incropera, David P. DeWitt. (2011). Introduction to Heat Transfer. John Wiley & Sons, INC.
Garza E. Benito Benito S., Daniel Ramírez Villarreal, Landín Raúl A. (2013). Aplicación de MATLAB en transferencia de calor. Memorias arbitradas del VIII Congreso de ingeniería industrial y de sistemas San Nicolas de los Garza Nuevo León México.
Blanes Pérez, Elena. (2016). Diseño y optimización de aletas rectas rectangulares "composites", bajo condiciones de convección. Universidad Politécnica de Cartagena.
Copyright (c) 2025 Germán Melo Mondragón, Susana Melo Londoño, Darío Alfonso Perdomo Fontalvo
This work is licensed under a Creative Commons Attribution 4.0 International License.
All Content should be original and unpublished.
