CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz] ARKANCE | CONTACT - CZ | SK | EN | DE
RSS channel - CAD tips RSS tips
RSS discussions

Discussion Discussion forum

?
CAD discussions, advices, exchange of experience

CAD Forum - Homepage CAD discussion forum - ask any CAD-related questions here, share your CAD knowledge on AutoCAD, Inventor, Revit and other Autodesk software with your peers from all over the world. To start a new topic, choose an appropriate forum.

Please abide by the rules of this forum.
This is a peer-to-peer forum. The forum doesn't replace the official direct technical support provided by ARKANCE for its customers.
How to post questions: register or login, go to the specific forum and click the NEW TOPIC button.
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Topic Closedextracting point coordinates to excel

 Post Reply Post Reply
Author
designengineer View Drop Down
Newbie
Newbie


Joined: 27.Jan.2013
Location: Canada
Using: AutoCAD , Solidworks , Inventor
Status: Offline
Points: 3
Direct Link To This Post Topic: extracting point coordinates to excel
    Posted: 27.Jan.2013 at 06:03
Hello,
At work I have to do beam deflection and has to calculate the center of gravity as well . For that I have to gather information about different coordinates at various points on the skid . Right now I am using ID command and then enter that information manually in excel . 
Is there any way that I click on a point and its co-ordinate value information goes into the excel automatically ?
Thanks
Back to Top
CarlB View Drop Down
Senior Member
Senior Member


Joined: 16.Oct.2009
Location: United States
Status: Offline
Points: 321
Direct Link To This Post Posted: 27.Jan.2013 at 09:46
Are you trying to determine the center of gravity and moment of inertia of a structural shape? If so, you can use the MASSPROP command in AutoCAD.
 
If you really need the points in Excel, then yes it can be automated using a lisp routine. The data extraction could be coordinates of a polyline, or points you pick.  Output may be to a text or csv file, which Excel can open then parse into columns.
 
You should avoid manual entry.  At the minimum, copy and paste from the command line to lessen chance of errors.
Back to Top
designengineer View Drop Down
Newbie
Newbie


Joined: 27.Jan.2013
Location: Canada
Using: AutoCAD , Solidworks , Inventor
Status: Offline
Points: 3
Direct Link To This Post Posted: 27.Jan.2013 at 17:59
Thanks for the reply .
Massprop is a great idea but there is slight problem , as there is an engine and compressor on the skid . They are just block and I don't think they have the actual weights shown in the model .
Another thing is that I need the COG from the datum , which is from one end of the skid .
I think lisp will work perfectly but I have to learn it .
 
Back to Top
edwinprakoso View Drop Down
Groupie
Groupie


Joined: 23.Nov.2010
Location: Indonesia
Using: AutoCAD 2016
Status: Offline
Points: 64
Direct Link To This Post Posted: 28.Jan.2013 at 08:34
If you have drawn the points at those locations, you can extract their coordinates to excel using DATAEXTRACTION. However, it only extract available points in your drawing.
It will not export coordinates to excel everytime you click a point, like your original inquiry.


Edited by edwinprakoso - 28.Jan.2013 at 08:35
Back to Top
Vladimir Michl View Drop Down
Moderator Group
Moderator Group

Arkance Systems CZ

Joined: 26.Jul.2007
Location: Czech Republic
Using: Autodesk software
Status: Offline
Points: 2124
Direct Link To This Post Posted: 28.Jan.2013 at 14:48
See the related tip 8030 for the Click2XLS click-and-extract utility.
Vladimir Michl (moderator)
ARKANCE - https://arkance.world - Autodesk Platinum Partner
Back to Top

Related CAD tips:


 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0,134 seconds.