# Draw a polygon with bearings and distances from Excel to Microstation

A few years ago I published an article that showed how to concatenate data in Excel for Build a traverse with AutoCAD, Without having to do the whole protocol:

@distance

The other day we were in the AutoCAD course someone asked me if that could be done with the Microsation command line. The answer is YES, you just have to understand that Microstation's Keyin is not the same as the AutoCAD command line. Let's see how it can be built, in passing we learn little things little used in this program:

The table to the right is an example of a traverse based on directions and distances.

With Microstation you can draw this As I explained before, With the obvious disadvantage - and the same one of AutoCAD -, that it is tedious to be writing one by one, the possibility of being wrong and even that the previous course is not reset.

Well, the process of concatenating is just the same That I explained with AutoCAD, you just have to understand something in which Microstation differs.

The keyin was not built based on making commands on text lines but for calling commands with object orientation, so it only supports 56 characters. Additionally, it requires that a semicolon (;) be used to separate the commands because, unlike AutoCAD, which comes from a Basic programming logic, it brings a Clipper logic with what Microstation was made there when It was still called Ustation.

Given this, the easiest way is to call the orders from a text file with the @ command, which I think very few know but which is the procedure that Microstation has always used to process batch orders. Including the import points from a txt list It's a mdl that does this.

Using the Excel sheet I previously worked on to teach how to convert from bearings and distances to coordinates, I will show how it would concatenate for Microstation:

### Concatenate the points.

What interests us is finally that the Key in Final is:

Place point ;Xy =374037.736,1580735.145;

Place point is the command point, including the space, the semicolon is to indicate another order, the xy = is the order to enter coordinates and the two coordinates blue and green are the known points. At the end a new semicolon to indicate a enter Or step to new command.

So, assuming the cells of my interest are in U7 and V7 to concatenate would be:

= CONCATENATE («Place point ; »,»Xy =",U7, »,»,V7, »;»)

This way, I just copy the contents of column AA into a txt file, which I'm going to call Spikedpoints2.txt. I suggest they put it directly in C so the path is not so difficult.

In this case I am placing it in my documents, the path would be: C: \ Users \ User \ Documents \ pointsandfrom 2.txt

To run it, we activate the command line window (Key in), This is done from Utilities> key in And then enter the order:

@C: \ Users \ User \ Documents \ DottedPoints2.txt

We do Enter, and there you have it, the points drawn in their order. It is convenient to have a thick line thickness for them to be displayed.

### Concatenate the lines.

For this, the operation is similar, the command that we must execute is Place line, Additionally we indicate that the line has a point of origin and a point of destination.

Place line ;Xy =374032.234,1580716.255;Xy =374037.736,1580735.145;

= CONCATENATE («Place line ; »,»Xy =«, U6,», », V6,»; »,»Xy =«, U7,», », V7,»; »)

We copy and paste to the txt file, save and run again

@C: \ Users \ User \ Documents \ DottedPoints2.txt

And there they have it:

And an additional advantage is that building the box of bearings and distances only requires doing Copy In Excel, and Easter in Microstation. With paste special you can choose between being an image, an embedded or linked spreadsheet

To complete the article, I'm arranging the example file in Excel, in which they only have to change the point of origin, directions and distances and the template can be useful for any iguana with more than half a pound of ribs.  Also here the sample txt.

It requires a symbolic contribution for the download, which you can do with Credit card or Paypal.

## 14 Replies to "Draw a polygon with bearings and distances from Excel to Microstation"

1. Mihkel says:

Kas teie Trimble ja PowerDraft vaheline expot / import ja koodide mkm programmi teete?

2. Nacho Vergara Galiano says:

he does not let me do it, in Microstation he tells me command of acquaintance input

3. sergio says:

Hello!!! Friends wanted to ask them, I am needing the autocad program 2015.el mdt 6 or if you can facilitate me to intarlar.grasias.

4. Migafia says:

Can anyone tell me if the exell template to draw polygons with autocad, is compatible with any version of autocad or civil 3d?

5. Eduardo Henriquez says:

Dear friend, I received the file that I requested, thank you very much !!

6. Eduardo Henriquez says:

Messrs senvie the money by Pay Pal but I can not find the way to let me download the Excel file for microstation

7. There are lisp routines that do this in AutoCAD.

8. Jaime says:

How can I do it so that you can at least make some exclusion, send it to me by email, there are people who find it very difficult to get it by paying… .thanks and I am very grateful…

9. In the page of downloads of this web there is a sheet that allows you to draw points from coordinates in Excel

10. CARLOS GOMEZ says:

HELLO HOW AND COMBIERTO THE CORDENADA OF A SHEET OF EXCEL TO THE MEGUSTARY AUTOCAD TO DO IT THE AUTOCAD MIO IS 2007 THANKS

11. Victor rivas says:

also in autocad you can in mdl ………… ..

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