Kardi Teknomo
Kardi Teknomo Kardi Teknomo Kardi Teknomo
   
 
Research
Publications
Tutorials
Resume
Personal
Resources
Contact

 

Rotation of Points Simultaneously Using Microsoft Excel Matrix

by Kardi Teknomo

Share this: Google+

Using matrix notation we get advantage that we do not need to type the formula for each point one by one. All we need to do is to use matrix multiplication. This simplifies the job if we have many points.

As numerical example, we have ten points, each with their coordinate in 2 dimension and you want to rotate those 10 points simultaneously from the mean of these coordinate. Suppose we set the rotation angle is 90 degrees we wish get the result as the following figure.

 

Suppose the matrix coordinate data is called

Download the MS Excel worksheet companion of this tutorial here

The first column is the x- coordinate and the second column is the y- coordinate. Because we want to rotate those points about the center of all points, we need to calculate the mean coordinate.

 

,

 

Thus, we subtract the first column of with and subtract the second column of with to translate the coordinate to the center of all points. The results is

 

 

Our rotation matrix is given by

 

rotation matrix

 

Multiply this rotation matrix with the , we get the new coordinate of rotated points simultaneously.

 

 

The problem now is how to do that in Microsoft Excel using matrix function? You can simply use MMULT excel function. Note that if you define your own matrix or array, you need to select in it a range (by mouse drag), then press F2 then Ctrl-Shift-Enter.

Download the MS Excel worksheet to see how it works

See also:
MS Excel Tutorial index, Kardi Teknomo's Tutorial

Send your comments, questions and suggestions

 

 

This tutorial is copyrighted.

Preferable reference for this tutorial is

Teknomo, Kardi. Rotation of Points Simultaneously Using Microsoft Excel Matrix. http:\\people.revoledu.com\kardi\ tutorial\Excel\SimultaneousRotation.html

 

 
© 2006 Kardi Teknomo. All Rights Reserved.
Designed by CNV Media