GLG410 Excel warm up exercise

Make little design in the spreadsheet by plotting the coordinates of the corners (label them as Easting (E) and Northing (N)):
```
1   1
2   0
1   -1
-1  -1
-2  0
-1  1
1   1
```
Plot it as a XY Scatter and connect the dots
Now we want to rotate the design.

The coordinates are transformed by a rotation about the origin so that one axis is the distance along the profile and the other is the deviation from the plane of the profile. The equations for such a coordinate transformation are as follows:

where E,N are the original coordinate system and E', N' are the rotated coordinate system, j is the rotation angle (should it be in radians or degrees? Note that Excel can only think in radians so you need to convert).
Make a pair of columns called Rotated_E and Rotated_N and use relative and absolute referencing to implement the equations.
Add the new series of rotated data to the original plot and rotate the figure by changing j. Which direction is the positive rotation direction?
Now let's displace the data as well. Make two cells that are the Delta_E and Delta_N cells
Make two new columns that use absolute referencing to add each E cell to the Delta_E and each N cell to the Delta_N. These are the displaced data. Do the same for the Rotated_E and Rotated_N cells (those would be the rotated and displaced data
Add the new series of displaced and rotated and displaced data to the original plot and displace the figure here and there by changing the Delta_E and Delta_N cells

Last modified: August 27, 2007