Using this template, you can draw a polygonal in Microstation, from a list of bearings and distances in Excel, or a list of coordinates x, y, z.
Case 1: List of Rumbos and Distances
Suppose we have this table of data coming from the field:
In the first columns you have the stations, then the distance to two decimal places and finally the bearing. We wish to draw this polygon, using Microstation.
For those who have done it with the AccuDraw tool they will understand that it is crazy, not only because the tool has its tools as a floating window but also because you must enter each of the coordinates; To err in a figure, to omit one or not to reset the command would force to re-enter data until verify what we have bad.
In this case we will do it using an Excel template, which allows you to enter the data in a box, and then order the polygonal drawing on Microstation.
|1||-||2||29.53||N||21 °||57 '||15.04 »||W|
|2||-||3||34.30||N||9 °||20 '||18.51 »||W|
|3||-||4||19.67||N||16 °||14 '||20.41 »||E|
|4||-||5||38.05||N||10 °||59 '||2.09 »||E|
|5||-||6||52.80||S||89 °||16 '||30.23 »||E|
|6||-||7||18.70||S||81 °||43 '||5.54 »||E|
|7||-||8||15.18||N||46 °||12 '||23.79 »||E|
|8||-||9||24.34||S||83 °||34 '||23.62 »||E|
|9||-||10||17.87||S||76 °||6 '||49.78 »||E|
|10||-||11||33.64||N||78 °||38 '||19.03 »||E|
|11||-||12||17.05||N||88 °||22 '||24.25 »||E|
|12||-||13||29.98||S||85 °||34 '||34.94 »||E|
|36||-||37||21.79||N||69 °||17 '||35.24 »||W|
How the Template Works:
By means of the template are entered:
- The data of stations, if they are consecutive, only write the first number and the template is filled in columns E and G.
- The distances in column H,
- The course or course data. It is not necessary to enter the symbols for degrees, minutes or seconds as the cell format already includes it.
The template has the option to choose how many decimals we expect to be truncated; Remember that if we used only two decimals, the polygon will surely not close because it will lose precision in the decimal of a second.
The template also allows choosing a coordinate for the first point, to achieve a georeference. Let us remember that these works in this format are usually raised with conventional theodolites, so at least one of all the points has a UTM coordinate of reference.
The draw button is pressed, and as a result in Microstation we will have the polygon drawn, as shown in the video.
2 Case: List of UTM Coordinates
The template also works if what we have is a list of coordinates in the form Name, East, North, Elevation. As well as the partial table shown below.
|Sweaters, Jerseys and Cardigans||X||Y||Z|
It works for both cases. The traverse will be drawn, adding the description or number as text at each vertex. It will use the text size, color, font type and alignment that is in use in Microstation. So if it does not seem to us, it is only generated again.
The template is available for download for a nominal fee. And we say symbolic, because for those who make a living from making cadastral or topography iguanas using Microstation, they will be saving a lot of work.
Acquire the Template with Paypal or Credit Card.
Learn how to make this and other templates in the Excel-CAD-GIS cheat course.