kinematic data transfer from UG to Excel
kinematic data transfer from UG to Excel
(OP)
Hi,
I hope someone could give some advice on this matter:
Object:
I've got a UG NX2 model of a kinematic chain. It's parametric. It represents a servo acting, through a cascade of levers, on a rotating device. This kinematic chain must be analyzed in Excel.
Problem:
Supposed that the driving parameter is the rotation angle of the operated device, I need to build a table in Excel, for n given rotation angles, where the other kinematic parameters are listed (e.g. the servo stroke, and several other distances and angles)
Question:
is there a straight way to do that with UG? Is there a reasonable way to do that with GRIP? Or with some other programming (I mean, UG could be "driving" Excel, but also Excel could be "driving" UG)?
Thank you very much in advance,
Regards
I hope someone could give some advice on this matter:
Object:
I've got a UG NX2 model of a kinematic chain. It's parametric. It represents a servo acting, through a cascade of levers, on a rotating device. This kinematic chain must be analyzed in Excel.
Problem:
Supposed that the driving parameter is the rotation angle of the operated device, I need to build a table in Excel, for n given rotation angles, where the other kinematic parameters are listed (e.g. the servo stroke, and several other distances and angles)
Question:
is there a straight way to do that with UG? Is there a reasonable way to do that with GRIP? Or with some other programming (I mean, UG could be "driving" Excel, but also Excel could be "driving" UG)?
Thank you very much in advance,
Regards





RE: kinematic data transfer from UG to Excel
RE: kinematic data transfer from UG to Excel
Grip would not be a good choice in this scenerio (IMHO); there's no associativity using grip. You can pull data from a file to load expressions, but there's no actual link between the two. Other programming languages (VB, C++, Java, etc...) have much greater functionality, one of these languages would be a better choice...
Have you looked at linking the spreadsheet to UG, which then drives the parameters for your file?
Regards,
SS
CAD should pay for itself, shouldn't it?