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

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.

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 . 

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.
edwinprakoso2013-01-28 08:35:13

See the related tip 8030 for the Click2XLS click-and-extract utility.