Page 291 - Excel for Scientists and Engineers: Numerical Methods
P. 291
268 EXCEL: NUMERICAL METHODS
Figure 12-2. Solving an elliptic PDE using intentional circular references.
The worksheet shows part of the 20 x 20 array of lattice points representing the
temperature distribution in a metal plate; the gray cells represent the temperature
at the edges of the plate.
(folder 'Chapter 12 (PDE) Examples, workbook 'Elliptic PDE', sheet 'Temp in a Plate')
To "turn on" iteration, choose Tools+Options-+Calculation and check the
iteration box. Unless you change the default settings for iteration, Microsoft
Excel stops calculating after 100 iterations or after all values in the circular
reference change by less than 0.00 1 between iterations, whichever comes first.
When you press OK the iterative circular reference calculations will begin.
