Page 225 - Excel for Scientists and Engineers: Numerical Methods
P. 225
202 EXCEL: NUMERICAL METHODS
Figure 9-9. Data table for use with the Jacobi method.
(folder 'Chapter 09 Simultaneous Equations', workbook 'Simult Eqns II', sheet 'Jacobi Method')
Figure 9-10 illustrates the portion of the spreadsheet where the Jacobi
method is implemented. Row 9 contains suitable initial values.
Figure 9-10. Satisfactory convergence is reached with the Jacobi method
after 23 iteration cycles.
(folder 'Chapter 09 Simultaneous Equations', workbook 'Simult Eqns II', sheet 'Jacobi Method')
