Using Matrices
in Excel
When you multply two matrices in excel, you
-
drag over the region for the product matrix
-
in the command bar type =
(
-
then drag over the 1st matrix,
-
type a comma,
-
then drag over the 2nd matrix, then type )
-
then press Ctrl-Shift-Enter
This document talks about a 1-D
rotation matrix, and how to build a spreadsheet which plots the appearance
of a constant vector (1,0) in the x,y frame as it is seen in a rotated
coordinate system.[ It does assume you know how to insert a scroll bar
to adjust the rotation angle.]
This spreadsheet
is one way of doing 1D rotation of a vector.