×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel.....again!

Excel.....again!

Excel.....again!

(OP)
I have a number of Excel spreadsheets with northing and easting coordinates in the first 2 columns. In the 3rd column I have a station # (these spreadsheats are location and names for GPS monuments). Is there away to use the northing and easting to place a point in my drawing and have the point # automatically label the corresponding point.  

RE: Excel.....again!

Can I think of Northing and Easting as x and y coordinates from the origin?

If so, a VBA routine could be written to pull in the datapoints.  Once they were in the drawpoint method could be used to plot and label the points.

If you can confirm the question above and don't know how to use VBA, let me know and I'll slap some skeleton code up here.

RE: Excel.....again!

(OP)
blutfort,

Actually the columns are easting, northing, station # (I switched the northing/easting on my previous post)  But to answer you question YES they are considered X & Y in their appropriate coordinate system.  Also I am a beginner with .lsp and no nothing about VBA.  Any help would be greatly appreciated.

RE: Excel.....again!

You can do a litle manipulation of the data in Excel and avoid the need for lisp or VBA.  For dispay of the station # I suggest you create a simple block, using a point and one attribute. This block will be inserted at each x,y coordinate, and the attribute will be the sta #. All the information for placing the point and sta# can be entered (pasted in one operation) into AutoCAD's command line. Now in Excel write a formula to concatenate info in the syntax needed for AutoCAD. the syntax will be something like:

-insert blockname xcoord,ycoord 1 1 0 Sta#

Cut and paste this column of data (commands) into AutoCAD's text window and you should be on your way.

RE: Excel.....again!

(OP)
CarlB

You lost me at "concatenate".  I understand pasting in a comma delimited excel file into CAD to place my blocks in known locations.  But I don't understand what or where to write a formula within Excel telling it to label the sta#'s?

RE: Excel.....again!

Concatenate is an Excel function to string together items into one item.  An example from something I did similar to what you're doing (in row 2):
=CONCATENATE("TestBoring"," ",C2,",",B2," 1"," 0","z1992-",A2)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources