Select a range containing the first cell that contains the same number of cells as unknowns
Benefits of Matrix Method • Coefficients and Constants can be changed and the solutions are immediately calculated • Applies easily to large systems of equations. • Shortfalls: • Cannot be used for non-linear equations
Benefits of Solver Method • Can be used for all non-linear equations • Shortfalls: • Tedious for large systems of equations. • Initial guesses must be given, and solution may not converge if the guesses are not close to the actual solution. • Any change in the problem requires that Solver be rerun again.
Temperature Distribution in a Square Plate 100 oC 50 oC 75 oC 25 oC
j i Solution
100 oC T11 T12 T13 T21 T22 T23 50 oC 75 oC T31 T33 T32 25 oC