×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

NX 9.0 spreadsheet

NX 9.0 spreadsheet

NX 9.0 spreadsheet

(OP)
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 :)

RE: NX 9.0 spreadsheet

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.

RE: NX 9.0 spreadsheet

(OP)
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.

RE: NX 9.0 spreadsheet

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.

RE: NX 9.0 spreadsheet

(OP)
Thanks John.
Brilliant help, as always :)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources