# 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 <angle ....

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 the Microstation Keyin is not the same as the AutoCAD command line. Let's see how it can be built, in passing we learn little things 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 in order to make commands in line of text but for order calling with object orientation, so it only supports 56 characters. Additionally, it requires that a semicolon (;) be used to separate the commands; unlike AutoCAD, which comes from a Basic programming logic, this brings a Clipper logic with what Microstation was done when It was still called Ustation.

Given this, the simplest way, is to call the commands from a text file with the @ command that I think very few know but that is the procedure that Microstation has always used to process batch orders. Even 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 that you place it directly in C so that the route 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 they have it, the points drawn in their order. It is convenient to have a thick line thickness 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,»; »)

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 the special paste 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.

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

1. Nacho Vergara Galiano says:

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

2. 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.

3. 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?

4. Eduardo Henriquez says:

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

5. 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

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

7. Jaime says:

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

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

9. 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

10. Victor rivas says:

Also in autocad you can in mdl ............ ..

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