- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hey everyone. So I have been working on a massive Excel sheet for my company that helps our engineers convert our GCP points from our EMLID units from LAT/LONG to UTM coordinates, in order to overlay on our aerial maps. Once converted the excel sheet then converts everything to feet, you know cause we are in the US and the engineers here cannot do anything in M, and creates a formula to draw a ton of circle points in AutoCAD similar to the formula below:
C 1664227.8168781,-30727025.6231642,791.624894540797 3
C 1664235.39326967,-30727069.0852844,788.227787496847 3
C 1664240.6242518,-30727096.8635664,785.816058996201 3
C 1664246.99403913,-30727130.2328622,782.995833330201 3
My next step has been to try and label everything for them with a text box to the right of the circles, but I cannot for the life of me figure out how to do this. I'm trying to build it into my excel code so they can just copy a long string and it will do it all for them. Any help would be grateful.
here is an example line from the excel sheet now
Decimal Degrees | Meters | UTM (Feet) | |||||||
Latitude | Longitude | Height | Label | East (X) | North (Y) | Height (Z) | Import Formula for AutoCAD | ||
-84.3355687 | 33.65853235 | 241.2872679 | Label 1 | 1664227.8168781 | -30727025.6231642 | 791.6248945 | C 1664227.8168781,-30727025.6231642,791.624894540797 3 | ||
-84.3356871 | 33.65875565 | 240.2518296 | Label 2 | 1664235.3932697 | -30727069.0852844 | 788.2277875 | C 1664235.39326967,-30727069.0852844,788.227787496847 3 | ||
-84.3357627 | 33.65890913 | 239.5167348 | Label 3 | 1664240.6242518 | -30727096.8635664 | 785.8160590 | C 1664240.6242518,-30727096.8635664,785.816058996201 3 | ||
-84.3358536 | 33.65909587 | 238.65713 | Label 4 | 1664246.9940391 | -30727130.2328622 | 782.9958333 | C 1664246.99403913,-30727130.2328622,782.995833330201 3 |
Solved! Go to Solution.