作者：SATORU YAMAMOTO;
作者單位：Graduate School of Information Sciences, Tohoku University 6-6-1, Aramaki-Aza-Aoba, Aoba-ku, Sendai-shi, Miyagi 980-8579
刊名：Journal of the Technical Association of Refractories
ISSN：0285-0028
出版年：2008-01-05
卷：28
期：4
起頁：239
止頁：244
分類號：TQ175
語種：英文
關鍵詞：
內(nèi)容簡介This review introduced briefly the numerical method of a heat conduction equation using the Excel Macro-program. Although this calculation is not yet practical for real purposes because of the limitation of the Excel calculation sheet, the largest advantage of using Excel may be the easy and visual understanding of the characteristics of a partial differential equation such as a heat conduction equation. The calculation of a three dimensional heat conduction equation using the Excel Macro-program is not impossible, but it is not practical because it requires a wide working range in the Excel sheet. Certainly, there is no particular problem using software on the market for three dimensional calculations. By the way. the above mentioned Excel Macro-program and the Fortran 90 program that is able to cany out a three dimensional heat conduction equation using the Crank-Nicolson implicit method and the successive Over-relaxation method are open to the public on http://www.caero.mech.tohoku.ac.jp/ as free software. Please download them and use practically. Finally, the author is now using Excel for calculating various mathematical models governed by multiple partial differential equations. Fig 11 shows results of one of them, which will be presented later.
所需耐材幣：0
