This is a spreadsheet that's useful for calculating the angle difference between two bearings. This is particularly useful when redrawing parcels and rotating parcels from different plats/deeds to fit together.

Location[edit]

S:Technology Services/Chad/various spreadsheets soon available for download

A good and thorough workflow[edit]

1. Select and "start editing" the shape you want to rotate
2. Drag a box to select all the vertices (or open the vertex list, click the number area of a vertex, hit ctrl+a, then check one of the boxes)
3. Drag a vertex to its counterpart on the feature you're matching
4. Switch to the "create feature" tool for either a line or polygon class
5. Add a vertex on the matched corner
6. Bring the excel spreadsheet in to focus
7. In arcmap, mouse over a different shared vertex on the feature you'll rotate, which is still selected
8. Enter the bearing from the status bar in to the spreadsheet
9. Mouse over the counterpart to the second vertex
10. Enter the second bearing
11. Select the rotate tool in arcmap
12. Hit ctrl+z to undo adding the vertex
13. Hit 'a' to bring up the angle entry for the rotate tool
14. Enter the numbers from the highlighted row, with dashes between them
15. Hit enter
16. Edit and reselect all the vertices and move the vertex so it's coincident again
17. Adjust other vertices as needed, which is likely

Tips[edit]

• The negative sign is in the field in front of the first number, so don't miss it
• Choose an initial vertex that is part of a good long common line, if possible