Kosky, Balmer, Keat and Wise: Exploring Engineering, Fourth Edition
Solve the equations using a spreadsheet:
Solution of the Equations for Exercise 8.6
0 0 0 0 0 1 0 0 0 1 0 0 0
1 0 0 0 0 0 0 0 0 0 1 0 0
0 1 0 0 0 0 0.707 0 0 0 0 0 0
-1 0 0 0 0 0 -0.707 0 0 0 0 0 0
0-1 1 0 0 0 0 0 0 0 0 0 0
[A] = 0 0 0 0 0 0 0 1 0 0 0 0 {b} = 0
0 0 -1 0 0 0 0 0 -0.707 0 0 0 0
0 0 0 -1 0 0 0 0 -0.707 0 0 0 0
0 0 0 0 -1 0 0 0 0 0 0 0 0
0 0 0 1 0 0 0 0 0 0 0 1 0
0 0 0 0 1 -1 -0.707 0 0.707 0 0 0 0
0 0 0 0 0 0 0.707 1 0.707 0 0 0 8
0 0 -0.5 -1 -0.5 0.5 -0.5 0 0 0 0 -0.5 -4
0 0 0.5 0 -0.5 0.5 -0.5 0 0 0 0 -0.5 -4
0 0 0.5 0 0.5 0.5 -0.5 0 0 0 0 -0.5 -4
0 0 0.5 0 0.5 0.5 0.5 -1 0 0 0 -0.5 -4
0 0 0 0 0 0 0 0 -1 0 0 0 0
inv[A] = 0 0 -1 0-1 0-1 0-1 0-1 0 {x} = 0
0 0 0.7072 0 0.7072 -0.707 0.7072 0 0 0 0 0.7072 5.66
0 0 0 0 0 1 0 0 0 0 0 0 0
0 0 -0.707 0 -0.707 -0.707 -0.7072 0 0 0 0 0.7072 5.66
1 0 1 0 1 0 1 0 1 0 1 0 0
0 1 0.5 1 0.5 -0.5 0.5 0 0 0 0 0.5 4
0 0 -0.5 0 -0.5 -0.5 -0.5 1 0 1 0 0.5 4