Spreadsheet Solutions to Two-Dimensional Heat Transfer Problems

摘要

The ability to solve two-dimensional (2-D) heat transfer problems is a potent tool for both the student and the practicing engineer. Most of these problems, however, are difficult to solve without sophisticated numerical methods. This paper outlines an approach for solving 2-D problems using common spreadsheet applications. This method opens up a world of new situations for the student to explore and appreciate and uncovers the mystery behind commercial solvers without having to get into the fine details of programming advanced numerical methods.