Page 309 - Excel for Scientists and Engineers: Numerical Methods
P. 309
286 EXCEL: NUMERICAL METHODS
Problems
Data for, and answers to, the following problems are found in the folder "Ch. 12
(Partial Differential Equations) problems" in the "Problems & Solutions" folder on
the CD.
1. Repeat the example of temperature distribution in a metal plate, where two
adjacent edges are at 0°C and where the temperatures of the other two edges
increase from zero, in increments of 10°C, to 200°C at the corner diagonally
opposite the two edges at zero.
2. Revise the example of temperature distribution in a metal plate to model the
temperature in a conduit where the outside edges of the 20 x 20 matrix are at
0°C and the interior channel (a 10 x 10 matrix centered inside the 20 x 20
matrix) is at 200°C.
