Over 1.099.000 registered users (EN+CZ).
AutoCAD tips, Inventor tips, Revit tips, Civil tips, Fusion tips.
Try the new precise Engineering calculator.
New AutoCAD 2026 commands and variables.
Discussion forum
?CAD discussions, advices, exchange of experience

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.
|
Post Reply ![]() |
Author | |
designengineer ![]() Newbie ![]() Joined: 27.Jan.2013 Location: Canada Using: AutoCAD , Solidworks , Inventor Status: Offline Points: 3 |
![]() 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 ![]() Senior Member ![]() Joined: 16.Oct.2009 Location: United States Status: Offline Points: 321 |
![]() |
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 ![]() Newbie ![]() Joined: 27.Jan.2013 Location: Canada Using: AutoCAD , Solidworks , Inventor Status: Offline Points: 3 |
![]() |
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 ![]() Groupie ![]() Joined: 23.Nov.2010 Location: Indonesia Using: AutoCAD 2016 Status: Offline Points: 64 |
![]() |
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 |
|
![]() |
|
Vladimir Michl ![]() Moderator Group ![]() Arkance Systems CZ Joined: 26.Jul.2007 Location: Czech Republic Using: Autodesk software Status: Offline Points: 2124 |
![]() |
See the related tip 8030 for the Click2XLS click-and-extract utility.
|
|
Vladimir Michl (moderator)
ARKANCE - https://arkance.world - Autodesk Platinum Partner |
|
![]() |
Post Reply ![]() |
|
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0,134 seconds.