Symmetry of solids/Topic 2/Excel exercise

From WolfWikis

Excel is a wonderful medium to demonstrate translation matrices in. Excel has a full set of matrix functions like MMULT, TRANSPOSE, MINVERSE etc. They are array functions. This means you must

1. first select an appropriate range for the matrix to be,
2. then type the array function
3. and finally enter it using Ctrl+Shift+Enter

Let us calculate T²

1. open a blank sheet
2. write the elements of the T matrix in the range A1:D4
3. select the range A5:D9 and type =MMULT(a1:d4,a1:d4). Enter it with Ctrl+Shift+Enter.

To calculate the inverse of T

1. select A11:D14
2. type =MINVERSE(a1:d4) and do Ctrl+Shift+Enter

Back to Symmetry of solids/Topic 2