Let's see what the point is:
I have the data of a traverse with bearings and distances, and I want to build it in AutoCAD.
The table has the following structure of the topographic survey:
|N 21° 57′ 15.04″ W
|N 21° 18.51″ W
|N 16° 14′ 20.41″ E
|N 10° 59′ 2.09″ E
|N 89° 16′ 30.23″ E
Previously we saw that AutoCAD Has its shape to feed this type of data in the format @vdistancia < angle.
Well, here is the table:
1. The input data
These are entered under the yellow zone, here enter the stations, distances and heading as the example.
2. The initial coordinate
This is in the heading of the zone in green, assuming that we know the coordinate of the first point. If you do not have it, place any value, preferably high so that negative coordinates do not appear, such as 5,000 (five thousand)
3. The output data
This is the area marked in orange, where what you have is the xy coordinates concatenated with a separating comma.
4 How to send it to AutoCAD.
Simple, "copy" is made in the orange area of the excel file, then in AutoCAD the polyline command (pline) is activated and "paste" is made in the command bar. The result is the traverse drawn just to give the closing point
Here you can download the template to build polygons based on directions and distances in an Excel table.
It requires a symbolic contribution for the download, which you can do with Credit card or Paypal.
It is symbolic if one considers the utility it provides and the ease with which it can be acquired.
5 How to send it to Microstation
To do it in Microstation I have created a template that does almost the same thing, but in the logic of the Microstation Key-in command.
Learn how to make this and other templates in the Excel-CAD-GIS cheat course.