NX 9.0 spreadsheet

[Karlis]

Hey everyone,
I would like to ask for some help or input on the following issue:
I have a series of solid bodies in my modelling file and I have used "measure bodies" feature on each body to determine the individual volumes.
I can see there is a button "spreadsheet" that explains it can export model data to a spreadsheet.
Is it possible to export the volume of each solid body to a single spreadsheet? I need to see the volumes as a changing graph in real time as I modify my bodies.
Thanks in advance

 

[JohnRBaker]

Attached is an example where I've created three solid bodies, created Measurement features for each one and then extracted the Expression values for the Volume into the Modeling Spreadsheet.

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Digital Factory
Cypress, CA
Siemens PLM:
UG/NX Museum:

To an Engineer, the glass is twice as big as it needs to be.

 

[Karlis]

Thank you for the good example John.
Though I am not sure how did you link those values to the spreadsheet?
I have tried:
- right click "body measurement" feature from the model history tree
- properties
- link to expression
- type a name
- select the type as "number"
- choose volume from the list of measurements

If I am going about it correctly, what do I type in the formula box? I can see you have defined all three expressions because they show up in the list of "link to expression" window though I can't easily understand how they are created.
Thanks for the help.

 

[JohnRBaker]

When you create a 'Body Measurement' the expressions get created automatically. Once they were created I edited the names of the three volume expressions just so that it would be easy to find them.

I then went to...

Tools - > Spreadsheet

...and in the menu titled 'Add-Ins' I selected the 'Extract Expr' item which then pulls all the expressions from the NX part file into the Spreadsheet. I then deleted the expressions that I was not interested in, added some details and that was it. When I closed the spreadsheet and I was asked if I want to save the changes I hit OK.

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Digital Factory
Cypress, CA
Siemens PLM:
UG/NX Museum:

To an Engineer, the glass is twice as big as it needs to be.

 

[Karlis]

Thanks John.
Brilliant help, as always