Two-dimensional modeling of steady state heat transfer in solids with use of spreadsheet (MS EXCEL)

In order to resolve both temperature distribution and heat flux in bodies whose geometries are not simple the analytical solutions are limited. In unsteady conditions are needed methods that would allow to calculate temperatures distribution within a three-dimensional heat conducting body of any shape. In this project, the study is focused on two-dimensional modeling steady state. The target is using the MS EXCEL program specifying iterative calculations in order to get a temperature distribution of a concrete shape of piece. The aim of the thesis is offering to the universities an alternative way of calculating heat transfer by numerical method. Nowadays programs like ANSYS, which costs use to be quite expensive, provide the students of a quick and accurate sort of solving this kind of problems, however, in the work done below is shown how MS EXCEL is successful in the same type of calculations. The advantage of the usage of this program is clear, most of the universities can afford provide their students MS EXCEL. The accomplishment of one of the tests done is compared with the results given by ANSYS, with sactisfactory conclusions.Outgoin