by Kardi Teknomo

Share this: Google+

Simultaneous Rotation using Excel

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.

Microsoft Excel Tutorials on Simultaneous Rotation

Suppose the matrix coordinate data is called

Microsoft Excel Tutorials on Simultaneous Rotation

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.

Microsoft Excel Tutorials on Simultaneous Rotation , Microsoft Excel Tutorials on Simultaneous Rotation

Thus, we subtract the first column of Microsoft Excel Tutorials on Simultaneous Rotation with Microsoft Excel Tutorials on Simultaneous Rotation and subtract the second column of Microsoft Excel Tutorials on Simultaneous Rotation with Microsoft Excel Tutorials on Simultaneous Rotation to translate the coordinate to the center of all points. The results is

Microsoft Excel Tutorials on Simultaneous Rotation

Our rotation matrix is given by

rotation matrix

Multiply this rotation matrix with the Microsoft Excel Tutorials on Simultaneous Rotation , we get the new coordinate of rotated points simultaneously.

Microsoft Excel Tutorials on Simultaneous Rotation

Microsoft Excel Tutorials on Simultaneous Rotation

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 (2015) Rotation of Points Simultaneously Using Microsoft Excel Matrix. http:\\people.revoledu.com\kardi\ tutorial\Excel\SimultaneousRotation.html