A Spreadsheet-Based Analysis for Two-Dimensional Transient Laser Heating of a Cylindrical Solid

摘要

A two-dimensional transient conduction model was developed for cylindrical coordinates using a spreadsheet software package and an explicit finite difference scheme. The governing equations were derived using an energy balance approach in terms of thermal resistance and capacitance. An iterative macro was created to solve the governing temperature equations subjected to specific stability criteria. The model was used to predict the thermal behavior inside a cylindrical solid aluminum pellet subjected to Gaussian or uniform laser heating. This paper demonstrates the application of a common software tool to solve a variety of complicated heat transport problems associated with cylindrical geometries and provides such accuracy that the technique can readily be used for design purposes.