Construct polygon with AutoCAD and Excel

Bearing and distances pictureAt the request of an alumnus who missed the class, I answer a question regarding the construction of polygonal lines in AutoCAD.

In this case we have a table, in the first column we have the stations, in the second the distances in meters and the third column contains the bearings.

Well, we will proceed to build the traverse, then we will verify the closing error and finally we will talk about the box of bearings.

1 Enter the bearings and distances manually.

The nomenclature that AtuoCAD accepts to show the data is known as polar coordinate (distance and course) in the following format:
@ distance <N / S degree d minutes ' the 2nd »E / W

The values ​​@, d, ', »are only nomenclatures that the system requires to interpret the data

The N / S and E / W values ​​are for choosing one of each, such as Northeast, you would choose N and E

Bold values ​​are numeric data, the latter can carry decimal values.

If a value is zero it can be ignored

For the case, sequentially it would be of the following form:

  • Line command
  • Click on a point on the screen
  • @11.21<S68D (enter)
  • @160<N11d58'(Enter)
  • @81.61<N13d6'(Enter)
  • ...... enter the rest until the last station
  • @57.34<N17dE (enter)

Although this nomenclature is somewhat archaic, because now there are macros and special applications to import the data, the Autocad veterans prefer to enter them because of the acquired practice; so I ask for tolerance, for insisting on understanding the initial concepts, then taking shortcuts. Also, if they knew how we learned this before the 2.0 website existed, they would understand why I prefer to share it rather than keep it in the trunk of memories :).

2 Enter courses and distances from Excel.

Previously we had seen how Enter UTM coordinates from Excel, only using the function "concatenate", because this time we will try to use that same function, with the intention that it will help us to construct the picture of directions and distances.

The disadvantage of entering the data on foot in the AutoCAD command bar is to make a mistake in a value, and then verify if they were entered correctly. In this case we will see how to use Excel to enter them and then extract them to AutoCAD, without using lisp, or macros.

This is an Excel table in which the data has been concatenated.

Greater London

So if you enter the data in the columns marked in yellow, the process is simplified to:

  • Line command
  • Click on a pounto of the screen
  • Select the excel area marked in green, copy (ctrl + c)
  • Click on the command bar, paste (ctrl + v)

Ready, your polygon is built, if it is left open or some data seems strange, just check the values ​​entered in the table excel, and do the procedure again without typing each value.Directions and distances

3. Verify closing error

In this case, to verify the closing error, we do the following:

Approach the point where we started, and measure the opening distance between the end point and the starting point. This is done with the "dist" command, if in this case 0.20 generates me

Now we divide the perimeter (sum of all distances) between that differential. (1,017.66 / 0.20) = 5,088

Which means that the precision is one in 5,000, that is one meter of error for each 5,000 linear meters. To know if it is acceptable you must know the acceptable parameters in your locality, generally for urban walk up 1 in 3,000 and for rural above 1 in 1,000.

If the closing error is within the parameters, we must obbligate the polygon closure in one of the lines, preferably in the one of smaller length, this to make sure that the angular error we are applying in the side that will less affect the area of ​​the Polygon ... then we have to correct that course we have adjusted.

If the closing error is outside the parameters, verify that you have entered the data correctly, then verify the field record and finally ... send the surveyor back to the land

4 Build the box of bearings and distances

Box of bearings and distances autocadWell this topic we will see in another post when we do it with Civilcad, since in this case we have used Excel to enter the points, so to make matters worse, we just copy and paste the table that is to the right of the archive, Which has concatenated data to just do copy + paste.

It is preferable to use special paste, to choose between autocad entities, ole object, image or block.

Greetings and until next time.

Now comes the educational part of the 2.0 Web, which macros or applications use to enter a table like this?

69 Replies to "Build polygonal with AutoCAD and Excel"

  1. Send the excel file to editor (at) geofumadas.com to analyze the template.
    In theory it should be easy, with the concatenate command.

  2. Send the excel file to editor (at) geofumadas.com to analyze the template.
    In theory it should be easy, with the concatenate command.

  3. I have geological structures in an Excel table

    an xyz coordinate heading and dive data and structure length

    How do I get a line in autocad.

    The idea is to automate this process and not have to draw each structure.

  4. Hi, I have data of a geological structure in an Excel spreadsheet xyz, the length of the course and the bz I want to take it to AutoCAD and I don't know how to do it.
    I have to have a line in AutoCAD

  5. how to do to pass construction box from autocad
    2015 to exel,

  6. how to do to pass construction box from autocad
    2015 to exel,

  7. Hello Monica.
    We have not tested with curves. It would be necessary to prove how easy it is to enter the arc command from certain data.

  8. Do you know the way to draw a polygon WITH CURVES, taking only directions? Tale with Curve Length, Radius, Rope and Delta. First of all, Thanks!

  9. In the article we clarify that it is for drawing purposes in AutoCAD, without making the correction for each side. As long as it is within the accepted tolerance.

  10. Hello, I understood that if the closing error is within the parameters, we must obbligate the closure of the polygon not in one of the lines, but in all those that form the property or surface that was raised.

  11. Those segments need to be treated individually. Even in the course frames they are marked separately, with the name of the curve, radius and rope.

  12. My question sieria that happens when the polygon has curved lines as you draw a curve with data of RADIO ST. LC ,, ROPE ROPE OF STRING AND DEFLECTION

  13. Hello, I need help, I have autocad 2012 and it does not let me insert the coordinates correctly, Diastance @ 35.57 Accept it well but when I go here: <s78d47's gives me error someone could give me a hand that urges me to work, Thanks
    Hector.
    Msn; Codepjuniors_2@hotmail.com

  14. I'm interested in learning to concatenate heading and distance in Excel to draw polygon in autocad

  15. Fran, you must concatenate the cells to have the format x, y.
    Then activate the line command and paste the concatenated cells.

    Manuel.
    It is possible that it is working but it is not falling into your workspace.

    Try a known coordinate within your space.

  16. Convert the geographical coordinates to UTM, with the respective datum using an EXCEL spreadsheet, copy the UTM coordinates from excel and paste using the autocad _pline command and the traverse does not appear. What can I be failing?

  17. good I installed the civilcad in my machine and I want to draw a polygonal through a sheet created in excell but at the time of copying and paste cadno generates me the drawing but it hits me the cells of excell you can help me not to do thank you

  18. You must convert them to UTM, For that there are different programs and Excel Templates that transform geographic coordinates to UTM. You will need a reference Datum.

  19. Thank you very much if you help me with an answer
    I would thank you very much

  20. hello if you could help me I have the data in degrees if you could help me as I get to autocad I have every point as well as this one for example: latitude 0 ° 13΄28.95˝S and longitude 78 ° 19΄33.17˝O

  21. hello download the data of a total station to my pc and autocad but the details are very agglomerated and the names are large and I do not know how to do with the details one or as I do.

  22. Let's see, in steps:

    1 fill in the data marked in the columns before column «O»
    2 You select the data in column «O»
    3 You activate the copy (ctrl + C)
    4 In autoCAD you activate the command line
    5 You click on the screen to indicate the starting point
    6 You activate the paste (ctrl + v)
    7 You do esc to finish the command

    That should build your polygon, if you do not see it, you zoom in on extent

  23. Thank you very much I am from Honduras and I am presenting the continuation of this project on Monday

  24. Sorry to note that I already have the table as you have it but I do not know how it applies in the excell.
    I look at the drawing
    I write command line
    Click on the screen
    But I do not know what I'm going to select or how to do it

  25. Hi, I honestly don't know how to do it. It may help you to write the words azimuth and diving on Google images and there you will find some type of work that will take you to some page.

  26. hello a little while ago I asked you how to make a polygon in autocad, I sent you the exel data table but you could not help me because you were traveling ... look now I have the base of the polygonal a friend architect is helping me but there are two data that we do not know how to locate the azimuth of the layers 'scuba diving and the layers' scuba diving, he knows how to manage the program and made the polygon without this data but how do we include this data
    Look at the data table that I get
    From: tope1
    Up to: 2
    Distance: 20
    Inclination: 4
    Azimuth: 240
    Heading az: 340
    Layer dip az: 70
    Layer skimming: 42
    And so for other data

  27. Well, I suppose you can find out what method of survey they used, it seemed like a combination of theodolite with a stay or a survey of geological strata. Do you have that in an Excel file or only in a notebook?

    If you have it, send it to the mail and I take a look.

    Editor (at) geofumadas.com

  28. Look at the data table that I get
    From: tope1
    Up to: 2
    Distance: 20
    Inclination: 4
    Azimuth: 240
    Heading az: 340
    Layer dip az: 70
    Layer skimming: 42
    And so for other data I have no idea how to do the polygon as I start

  29. Hello I have to do a polygon with the following data and I do not know how it is done
    -Poligonal with the profile in jpg or pdf (with scale) and original drawing file (in autocad, corel or canvas)
    from to distance inclination az of the course az of the buza-buzami
    of the layers lie of the layers layers

    And I get the previous full columns

  30. Good I'm new in the forum
    This is my query
    I did a topographic survey for a route but before I did a traverse, there was a possible error, but the same compensates now as I rephrase that polygon that already compensates for it must be as cement and iron thanks

  31. I am a cartoonist. I use the 2000 autocad for the construction of polygons in cartography planes. It made me crazy when it was a rather complicated polygon. By this I mean the use of polar coordinates to enter complicated distances and angles, until I was fired. lamp; I only decided to enter a point of the coordinate sheet, since the polygon line is formed by 2 points of the space (to forgive the obviousness). Once the points are located, the only thing I have to do is join them with polyline and that's it! I hope it helps them ..
    By the doubts I leave my mail to exchange drawing styles:
    Markos_elgriego@hotmail.com

  32. Printing is one of the most complicated issues of AutoCAD, in principle I recommend you try to familiarize yourself with printing from the model and not from the layout.

    The drawing is built to scale 1: 1, suppose the unit is one meter. The scale is in paper size.

    Build a sheet the size of the paper to 1: 100, which implies that one centimeter will be equal to 100 centimeters. So if your sheet is 8.5 ″ x 11 ″ convert it to centimeters, it would imply that your frame should measure 21 meters by 28 meters, then remove about two on each side by the margins of the printer and you would have a sheet that is built 1: 100 .

    Then if your drawing on this sheet does not fit, take a factor, as applicable, for example double the size would be 1: 200 and half the size would be 1: 50

    Then try printing to familiarize yourself with the skills required to understand the printing scale.

    If you finally achieve it, then you can break your head with the layout, which requires other scale criteria.

  33. Hello, I want to make the following query, although I do not know if this forum can help me with respect.
    It is about giving the scales to the drawings for your printing. Both from the model, and from the layout (with viewports).
    Before I want to express some doubts or opinions on this topic.

    1. I have visited several sites, forums, pages, etc. Consulting on this subject and just as diverse and varied have been the explanations and answers that I have found in them; From easy and comprehensible solutions to well-worked and step-by-step answers, as well as answers that instead of helping confuse more, etc.
    In short variety of answers but in summary explain more or less the same: The procedure to follow to give the scales.
    If you want to give a scale 1: 100 proceed as follows:

    1 / 100xp if the units of measure of the drawing is in mm.
    100 / 100xp if they are in cm
    1000 / 100xp if they are in mt.
    It is written like this, or in its defect the data that is of the division for each one of the cases and of the scale in question is typed.
    Is this correct?
    The same process is followed for any other scaling you want to use: 1: 25,1: 200,1: 75, etc.

    2. I understand that for the printing of the drawing to come out on the scale or scales (if several drawings), which we have determined; The whole plane has to be drawn to scale 1: 1 (in the model), ie we have to define before making a drawing in which units of measure we will work either mm, cm or mts. This means that the unit of measurement that we determine to work must represent in the drawing the actual measurement of the object to be drawn. Ex. If we have a table with a surface of 1 mt. X 1 mt. The drawing to be made depending on the chosen unit of measurement should be done as follows:
    - Draw a square of 1 x 1 if we work in mts.
    - Draw a square of 100 x 100 if we work in cm.
    - Draw a square of 1000 x 1000 if we work in mm.
    Is this explanation correct? I ask because I know that Autcad works by default with mm, however you can change those units that you want to use.

    3-Then my question arises because if I want to work in mts. or in any other unit of measure, it is necessary to change the units to mts. or it works as defined by the program (mm); and it is assumed that when drawing «X» object the measures that one gives will be the units that one wants that drawing to have. (either mt. cm, etc.)
    Said in other words and taking as ej. The table of 1 mt x 1 mt
    If I know that Autocad works with mm. but I want my drawing in mt .:
    - Change the units of measure to mts.? or
    -I leave it this way and I draw my table giving measurements of 1 x 1 knowing that although Autocad is in mm. the drawing that I make will be in mts?
    Do you understand my doubt ?, I hope so.

    4-All of the above I expose it because, it turns out that I have several drawings that present this condition, when opening the file the units of the program is in mm. But the measurements of the drawings are in meters. And another that the program units are in meters. And the measurements of the drawing are also in meters. But at the time of giving the scale in the layout eg 1: 50, 1: 75 I do as I explained above (which is the way I found in the different sites I consulted), but it does not work.
    The size of the viewport is according to the size of the sheet and it is assumed that when the drawing is already with the required scale it has to fit in the viewport and it turns out that either it is too small or it leaves the window.
    What can happen in this case ?.

    Well, these are basically the doubts that I have regarding the subject, I hope not to have bored you, inconvenienced, and above all to have taken time since I extended too much I believe, but quite the opposite, I hope to have been quite clear.
    If you could clarify the doubts or know of some tuturial, or site that can answer them, would be infinitely grateful indeed.

  34. It is correct, the polygon, I also think that it must have the rest of the coordinates, the problem is that the information with which I tell or where I can get the rest of the data only contains the coordinates of two points, and the Distances of the segments. As I mentioned.
    Anyway I thank you very much, the answer, because the doubt was precisely whether or not you could draw the polygon with only that data.
    So thank you very much, and I hope not to bother you if at some point I consult you with something else.

    GREETINGS

  35. Let's see if I understood:

    You have a polygon, but you only have the coordinate of two stations (I guess the polygon has more)
    You have no bearing on the rest, only distances.

    No, it is not possible to construct it, you occupy either all the coordinates or have the bearings and distances.

  36. Hello, I want to make the following query, can you draw a polygon in autocad starting from just a couple of coordinates in any station? and if you could do what is the procedure to follow.
    Since the problem I have is the following: I have to draw a polygon of "x" number of stations; but the only information I have is a small drawing of that polygon which only has the co-chains "X" and "Y" in two of those stations, and the respective distances of the sections or segments thereof. There is no information of directions, azimuth or anything like that. Then the question is as I mentioned at the beginning if you can make the drawing only with that information.
    I will greatly appreciate the response.

  37. I hope you answer me, look at the construction table, the civilcad gives it to me directly, but I can not find a way to do it more, I hope your help thanks

  38. I do not understand naahh of your example you are missing onnnnnnn if you are going to do something you havelo good ....

  39. Excellent help, thank you very much, you have saved me, because I am drawing a polygon of 38 stations, angles or vertices and I really did not know how to close it.
    I had read everything about the different procedures, for example: the angular closure, the linear closure, etc. (With all its formulas), but what I needed was a much more practical solution. Like the one you've given me.
    So once again I thank you very much and maybe later you can explain it with an example so that it is registered, and I can serve others who may have the same doubt as me.

  40. Ok, I understand your doubt, I am tremendously on vacation and I am not riding my heavy equipment. I will explain it to you in the air.

    You have a polygon from point 1 to point 50. It happens that between the 1 point and the 50 you have 30 linear centimeters open, but the 50 point and the 1 should be the same.

    So you realize that the shortest line is between the 35 and 36 points, so you take all the lines from the 35 point to the 50, and move them.

    How much do you move them? then starting from the 50 point to the 1 point, move command, the 50 origin point, the 50 destination point. In this way, your polygon is closed at the end, but it opened at point 35

    So you take the end of that point and move it to the 35 point. It means that you have changed the course and distance of the 35-36 segment, but making sure that the area will affect you as little as possible because it is the shortest

  41. Hello how are you. I greatly appreciate your valuable help, however I would not like to appear insistent; but I have not fully understood the final part of your explanation where you say:
    1.- «you move the entire line segment (I suppose you mean the whole polygon) taking the end point as the origin and the starting point as the destination».
    According to this indication you say that the aperture would move to the shorter line segment. But I can not understand how this happens.
    The modification that you say you have to do in the vertex, I suppose you mean that there is to get the new course of that short segment?
    If it is a lot of annoyance I would thank you very much, you could clarify these doubts.
    Do you think it could be explained with a graphic example, please

  42. Hi heal
    When a closed polygonal (in 2D), in the end it does not close you, there is the possibility of finding two errors:

    An angular error and another linear error. That line segment between the starting point and the starting point is the result of those errors. In practice there will always be an error because the angles we take in the field are always rounded, I mean that although we are using seconds, that angle always had a series of decimals that our topographic team forces us to round and as a consequence, in the end there will always be a error.

    Low basic principles of the topography class, this error must be redistributed between all sides in proportion to its magnitude and for this there is a whole procedure that you should know by taking a topography book. Always starting from an accepted tolerance, when we did it with a pure calculator, we made so many itineraries until that error was acceptable and now surely there are some routines to do it or programs that execute it directly.

    The truth is that in the end, the entire polygon is modified in very small values ​​so that the error is distributed between all the segments of the polygon.

    What I have shown is a practical way of closing a polygon, considering first, that it is a "reconstruction" of a polygon that could have already been adjusted. It is more a cartoonist practice than a surveyor who presumes, that if you divide the perimeter of the polygon between the linear error it would give you a precision ratio, that is, every few linear meters a meter of error was made and if it is very insignificant (or within of a tolerance) you can close it to the brave.

    Assuming that the precision is within accepted parameters, what you do is to identify the shortest side, and you move the entire line segment by taking the end point of the survey and targeting the starting point (the opening segment), this would cause Now the aperture has moved to the shortest segment and then closes the brava by modifying one of the vertices of the short segment.

  43. I have a doubt: If a polygon drawn from a frame of bearings and distances does not close (as in the example you present); How is the correction of the "closing error" made? To make it close.
    I do the query because in the example you share, you explain what needs to be done but not how to do it. Maybe you could help me in that way, because I fully understand what has to be done but not how to do it.
    I have read in other forums (and by the way it has not been very clear how it is done) about an "angular compensation" (applied to the internal angles of the polygon) and a "linear compensation", in order to correct the closing errors, but I do not know if it is the same as you mean, since you mention about forcing the closure of the polygon in one of its lines and correcting the direction that is affected.
    In summary, I would like a fairly understandable explanation on how to make this correction, having as a formation the course and distance chart.
    I hope I have explained. And hope you can help me
    A very big greeting and happiness for such excellent contributions.

  44. That can only be done with AutocAD Map or Civil 3D. I think the normal version of AutoCAD doesn't have basic functionality like that.

    Someday I talked about doing that with AutoCAD 14 and Softdesk 8 There in the comments there is a lisp.

  45. Hello,
    My question is this:
    After having drawn a polygon with the bearing and the distances, I need to export the coordinates of all the points in AutoCad to excel or to any program, so that I can edit it and present it as a report in a table and not in an AutoCad graphic.

  46. Good morning, I want to know if you can help me with the following:

    I would like to pass the information contained in the cell in excel (eg abc), directly to the autoCAD command line. Eye without needing Ctrl + C and Ctrl + V ... that is to say that the association of that cell is automatic and that AutoCAD knows that this information goes directly to the command line of AutoCAD. Without more than to make reference and waiting for prompt help from his part he says goodbye

    Atte. Fulanito Detal

  47. I put into practice the exercise of building a polygonal from a table created in Excel, I just had to change the commas for the point and W for the O ..., and it came out perfect, also practice with the points or coordinates and take excel to autocad, it came out perfect ... very grateful for your contribution.
    Greetings from Paraguay

  48. They are the maximum .. they passed ... .. they have helped me a lot
    kisses to everyone

  49. Try first to make the polygon that is in the example, and tell me if you get the same

  50. You're right, there is no green column. You must copy the contents of the «O» column once you activate the point command, and assign the first point of origin with the mouse.

  51. hey I work with autocad 2006, and when I give copy and paste to the data of the excel table the polygon is formed but the lines are disordered, and nothing to see that looks like a polygon, I will be doing something wrong, to start with is what I have to copy and paste q I do not see anything in green on the excel sheet.

  52. Mmm, I think you're right, I'll update the table with more space for data

  53. No, for azimuth it would have to be adjusted because the angles should only rotate in one direction with respect to the north.

    Perhaps one of these days raise it adjusted for such purposes.

  54. Greetings to all, this magnificent picture can also be used with the data in azimuth ?????.

    Thank you

  55. Hello

    I'm a novice in autocad, it's really interesting how to make use of these tools since they simplify time.

    With respect to the example of the traverse, passing the data of exel (@ distance

  56. Hello Prudy, you talking about this polygon or another?

    there is a small segment that remains open, in the case of this, due to the error caused by the rounding of the seconds, and that is what I mean by the closing error

    In case you are working with another polygon, you might have a big closing error, or a data you are getting it wrong, and that gives you the impression that you are missing a side

  57. When I build the polygonal I always miss the last stretch

    regards

  58. Because I did not find an existing macro there, but it can be built with Excel ... it will take a while of the vacation but I think it will be interesting.

    If the kids bathe in the pool and then fall asleep tired, maybe give me the time in the afternoon.

    regards

  59. Hello Diego, greetings to the people of Paraguay.
    Well, there are as many ways as counting cows. Starting by counting the horns and dividing them by two, counting the legs and dividing it by four, or counting the cows directly.

    The easiest: it is to use AutoCAD Civil 3D or Softdesk because you just have to go to the option that already comes for that, in which you can choose the point of origin and automatically create the table.

    The other case is to do it with the competition (Microstation), with an application Visual Basic as shown in this post.

    In case you want to do it as you put it, the only thing I see a little complicated is to export the data to excel and to go in the order we want. But give me a while to return to my house, because today the Easter holiday begins in these places and they have me half tempted.

  60. A pleasure to greet Don Alvarez, some time ago for a search that had arrived without wanting to his web and I seemed interesting, both for the contest and for the pleasant way of communicating his science.
    I would like to ask you, if you know any script, or some excel framework that will help me do the following: I have digitized in CAD a polygon with its vertices points well identified, and with their respective UTM coordinates. I can perfectly export them to txt to read them in excel.
    my question: knowing the UTM data of the points 1 ... N, is it possible to obtain the data of the stations, routes and distances?
    That is to say, from the data I give you, the point 1 has from X ... from Y ..., and knowing that the point 2 has X ... Y ...; CAN YOU TELL ME THE DISTANCE THAT SEPARATES THEM AND THE ANGLE OF THE SAME? In order to be able to create the correspondent form automatically?
    Thank you teacher since now
    Best regards from Paraguay!

Leave an answer

Your email address will not be published.

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