Matrix Geometry in Excel

Summary: In the Excel spreadsheet, change the highlighted values and see the figure change. The first tab is 2D. The second tab is 3D.

Details: I've heard over the years how matrices are used in 2D and 3D graphics to rotate, translate, and scale figures. I've never, however, really understood how it works. I decided to figure it out with the help of Wikipedia and Excel.

So, here is my matrix geometry spreadsheet. You can change the highlighted values and match the figure move. A second tab generalizes this to 3D and adds perspective projection.

     - Carl (Twitter: @CarlKadie)

 

    Spreadsheet

 

Screenshots:

 

 

Reference:

Related: