Draw a polygon in Microstation from Excel

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 with two decimals and finally the course. We want 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.

Station Distance Course
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:

Exel a microstation

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 data of courses or courses. It is not necessary to enter the symbols of degrees, minutes or seconds since 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 you to choose a coordinate for the first point, to achieve a georeference. Recall that these works in this format are usually raised with conventional theodolites, so that at least one of all the points has a reference UTM coordinate.

Exel a microstation

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, Easte, North, Elevation. As well as the partial table shown below.

Point X Y Z
1 418,034.12 1590,646.87 514.25
2 418,028.56 1590,680.72 526.11
33 418,107.63 1590,609.31 446.07
34 418,090.65 1590,610.45 420.49
35 418,065.54 1590,611.78 343.22
36 418,045.16 1590,619.48 335.91

Exel a microstation

It works for both cases. The traverse will be drawn, adding the description or number as text in 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 like it, it is only generated again.

The template is available for download for a symbolic value. And we say symbolic, because for those who live to make iguanas from cadastre or topography using Microstation, they will be saving a lot of work.

Acquire the Template with Paypal or Credit Card.

5 Replies to "Draw a polygonal in Microstation from Excel"

  1. I have a 6 mobile mapper which I want to download some points, but I connect it to my computer which has windows 7 and does not recognize it

  2. Send me the excel file, with the data you have added. To test why it does not work for you.

    Editor (at) geofumadas. com

  3. I have the template, written the station, heading, distance, and an initial coordinate for the course, do not draw it, do not understand, x that.

Leave a comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.