Visualization of Calculation Process in Numerical Analysis Using Spreadsheet of Excel
Toshio Tomimura, Shigeki Hirasawa, Mitsuaki Haneda · Journal of the Visualization Society of Japan · 2003
A visual-oriented numerical method which applies the spreadsheet of Excel has been proposed. In the present study, a programming process on two-dimensional unsteadystate heat conduction problem in cylindrical coordinate system is explained by way of a specific example, where a short round bar is put under sudden heating on its end and is cooled by forced convection around its side surface. The present unsteady-state numerical calculation has been realized by introducing one to one correspondence of each time to each sheet. Through calculations on sudden heating of a round bar model, the proposed method is shown one of useful numerical methods.