Plotting points as Geographical positions in Autocad LT.

[winston_dog]

I am plotting geographical positions as "Points" in Autocad LT 2007.

Using an Excel spreadsheet, I take a Lat and Long, convert to a UTM grid, then apply a "false origin" to make the numbers more manageable. (2 or 3 digits rather than 6).

Then copy and paste to Autocad and use the POINT command to plot them all at once.

This works fine but what I would really like to be able to do is to copy a text label across at the same time, to label each point with a description

 

Is it possible?

If not, can I assign a label to a point one by one?

[BIGAL]

In excell you need to make a script and then run it in autocad you can join all the columns together into 1 line and then save it as a txt script file .scr

 

something like

lat long x y .......point x,y text x,y x,y

lat long x y .......point x,y text x,y x,y

lat long x y .......point x,y text x,y x,y

 

copy the right hand side to notepad and save, carefull there are a couple of extra spaces between x,y & x,y to equal the questions asked by the text command just get 1 line to work first. I am pretty sure excell has a join string (multiple columns) to make 1 new column.

[afrazawan]

pls send me screen shoot

i 'cant understand like this pls im not expert in this so pls help me

[jwkilgore]

You are creating a script that quickly runs multiple commands.

 

You're invoking the POINT command, entering the coordinates, invoking the TEXT command, entering the insert coordinates, then entering the coordinates again as the value of the text. You'll need two SPACES (same as enter) between the text location start coordinates and the text value to accept the default value for rotation (unless, of course, you want to change it).

 

It'll go just like typing:

point[space=enter]x,y[space]text[space]x,y[space][space]x,y

 

The join string command in Excel is Concatenate. So if X is in cell A1 and Y is in cell B1:

=concatenate("point ",a1,",",b1," text ",a1,",",b1," ",a1,",",b1)

 

You'll get something like:

point 1234,4321 text 1234,4321 1234,4321

 

Save the values from this column of formula into a separate spreadsheet (copy->past special->values), then save as a comma-delimited text file. As you only have one column, you shouldn't get any extra commas. Then change the extension from ".csv" to ".scr" and run it in AutoCAD.

 

Also, for what it's worth, I usually find it better in the long run to use the entire coordinates instead of truncating. That way files from different disciplines are easier to merge together. Just move, copy, and insert everything with a 0,0 base point.