×
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

Extracting Weight Info/Exporting To Excel

Extracting Weight Info/Exporting To Excel

Extracting Weight Info/Exporting To Excel

(OP)
Hi.

I need to extract some data from a model. I've exported all expressions to .exp file which I later import into a spreadsheet for further analysis.
I'm missing the following data: the weight of component and coordinates of component's centroid.
Is there any way of exporting the above so it can be used in Excel later on?

I'm running NX6 on 64bit Vista.

Thanks in advance for any hints.
 

RE: Extracting Weight Info/Exporting To Excel

Analysis -> Measure Bodies...

Make sure Associative is checked.  Select the body or bodies you wish to measure an select OK.  This will create measurement expressions that can be exported to a spreadsheet.  This will not give you center.

You can try Analysis -> Advanced Mass Properties -> Advance Weight Management

This will give center and will allow you to open the results in a spreadsheet.

RE: Extracting Weight Info/Exporting To Excel

(OP)
I've managed to get the weight by measuring bodies through expressions menu (I've got some other data extracted this way).
We produce more and more models for stress analysis. They require similar measurements to be taken from different models. I'm trying to simplify the process by creating a part file into which a model can be WAVElinked and then the data can be exported to Excel. I've tried messing around with journals but they are way over my head.
The only measurement I'm missing now is the centroid. I will have a look at advance weight management on Monday, when I get back to work.

Thank you for help.

Jake.

RE: Extracting Weight Info/Exporting To Excel

The only problem with getting the centroid is that the dimensions to the centroid will need to be relative to something.
If you look at your model after you do:
analysis > measure bodies > toggle associative "on" > select bodies > Ok
You will see a point someplace in the model. That is the centroid. How you define it (what to dimension to) is up to you.

RE: Extracting Weight Info/Exporting To Excel

(OP)
All the models I use are already positioned as they would be in an assembly. What I'm looking for is the the distance from the WCS. I'm only bothered about the z direction.

Thanks,

Jake.

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