Excelに対応した3重対角行列アルゴリズムを用いた汎用1次元熱伝導解析（平板・円筒・球の陰解法非定常熱伝導の統一解析）

抄録

An Excel program that uses tri-diagonal matrix algorithm (TDMA) is proposed to calculate one dimensional unsteady heat conduction using implicit method. The program is unified analysis method to calculate symmetric flat plate, solid cylinder, sphere, double-sided flat plate, hollow cylinder, and spherical shell geometries. Three different boundary conditions and arbitrary heat generation rates can be applied. The unsteady numerical analysis is compared with the exact solution to verify the accuracy. Furthermore, the effectiveness of the program is demonstrated by solving various engineering examples using this Excel program.