Use of multiple sheets for the solution of a three-dimensional transient heat conduction problem

✍ Scribed by A. Kharab

• Publisher: Elsevier Science
• Year: 1997
• Tongue: English
• Weight: 653 KB
• Volume: 34
• Category: Article
• ISSN: 0898-1221
• DOI: 10.1016/s0898-1221(97)00098-9

✦ Synopsis

The objective of this paper is to show how a single spreadsheet program can be used for solving a three-dimensional transient heat conduction problem. Multiple sheets are used to move from one time level to another, and a finite-difference method which fits well into the setup of spreadsheet is used to find the numerical solution. The program allows the use of any number of grid points and any initial temperature distribution. Because of their convenient features, 3-D spreadsheet programs are useful for modeling many physical phenomena.