Related Resources: excel calculators

Interation Demonstrations Spreadsheet

NOTE:

• Refunds are not awarded after excel files have been downloaded - review your membership agreement for details.
• This excel spreadsheet may contain macros which will need to be enabled in your excel application, see web page: Enable macros in Downloaded excel files
• Units utilized within calculators are either SI or Imperial (some enable both SI and Imperial) and member (you) are responsible for conversions. Ensure that you verify units utilized in excel application meet your requirements before downloading.

Engineering Calculator Spreadsheets

This workbook includes three separate demonstrations of Gauss-Seidel (Liebmann) iteration for the solution of systems of linear equations. The first one, shown in the figure, demonstrates using G-S to solve the system of linear equations arising from the finite-difference discretization of Laplace's equation in 2-D. Another shows application of the Scarborough criterion to a set of two linear equations. The third shows the application of G-S in one-dimension and highlights the difficulty of applying pointwise iterative methods to large systems. The first and third demonstrations are animated

Download: Interation Demonstration Excel