Page 307 - Excel for Scientists and Engineers: Numerical Methods
P. 307
2 84 EXCEL: NUMERICAL METHODS
The spreadsheet shown in Figure 12-14 illustrates the solution of the
vibrating string problem. Column B contains time in increments of At from zero
to 2.8 x seconds (only part of the spreadsheet is shown). The first row of
displacement values (row 12, values shown in bold on the spreadsheet) are the
initial conditions. The values in the second row (row 13, values in italics) are
calculated according to equation 12-36; the formula in cell D13 is
=( C 1 2+ E 1 2)/2
Values in subsequent rows (rows 14-27 in Figure 12-14; rows 14-44 on the
CD-ROM) are calculated according to equation 12-34; the formula in cell D14 is
=C 13+E13-D12
Figure 12-14. A spreadsheet layout for solving a hyperbolic PDE.
(folder 'Chapter 12 (PDE) Examples, workbook 'Hyperbolic PDE', sheet 'Sheetl')
