kinematic data transfer from UG to Excel

[cbrn]

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

 

[jelmerra]

With a part family you could let excel drive the assembly or model parameters. At some stage there were some update issues with part families it was either nx2 or 3 not sure make sure if you use model parameters to update the model with a replay.

 

[Shadowspawn]

Cbrn,

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?