Discussion forum

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

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

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
designengineer Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 27.Jan.2013 Location: Canada Using: AutoCAD , Solidworks , Inventor Status: Offline Points: 3	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

CarlB Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 16.Oct.2009 Location: United States Status: Offline Points: 321	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.

designengineer Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 27.Jan.2013 Location: Canada Using: AutoCAD , Solidworks , Inventor Status: Offline Points: 3	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 .

edwinprakoso Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Groupie Joined: 23.Nov.2010 Location: Indonesia Using: AutoCAD 2016 Status: Offline Points: 65	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
	Edwin Prakoso CAD notes \| CAD tutorials and best practices

Vladimir Michl Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Moderator Group Arkance Systems CZ Joined: 26.Jul.2007 Location: Czech Republic Using: Autodesk software Status: Offline Points: 2151	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

Discussion forum

?CAD discussions, advices, exchange of experience

extracting point coordinates to excel

?
CAD discussions, advices, exchange of experience