×
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

Managing components of an assembly on spreadsheet

Managing components of an assembly on spreadsheet

Managing components of an assembly on spreadsheet

(OP)
Hi,

I work with big assembly (thousands of parts) and use arrangements. It would be much easier and faster for me to supress parts in external spreadsheet with some boolean value Y/N or 1/0. I imagine it should look like this:

__________| Arr.1 | Arr.2 | Arr.3 |
Part 1 ___|___1___|___0___|___0___|
Part 2 ___|___1___|___1___|___1___|
Part 3 ___|___1___|___1___|___0___|
...


I found a video on youtube and this is exactly what I need. But I don't know, how to do that and if it in NX 7.5 or 8 works (it's NX 9 in video).

Could anyone explain how to do that? Or may be there are other better ways? Thanks!

RE: Managing components of an assembly on spreadsheet

Yes. it'll work in NX 7.5 or NX 8.0.

You create your Assembly. Assign expressions to control the suppression of the Components. Create a Spreadsheet with a list of Components where you can toggle their values to be '1' or '0' ('0' is Suppressed and '1' is un-Suppressed). Then link the NX Expressions controlling the suppression of Components to the cells in the spreadsheet containing the '1' or '0'. After you edit the spreadsheet, you save is and then go to NX and select Tools -> Update -> Update for External Change and the Assembly will update.

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: Managing components of an assembly on spreadsheet

(OP)
Thank you for quick response, John!

Could you explain please how to get full list of components of my assebly in spreadsheet? Thanks again!

RE: Managing components of an assembly on spreadsheet

Hi,
You need to go to your ASSEMBLY NAVIGATOR. Right click inside it .....Expand all Components ...Right click again inside the Assembly Navigator and choose Export to Spreadsheet.

Best Regards
Kapil

RE: Managing components of an assembly on spreadsheet

(OP)
John, what exactly means "Assign expressions to control the suppression of the Components". Should I create a unique expression for each part of the assembly?

kapmnit123, thanks!

RE: Managing components of an assembly on spreadsheet

Only the ones that you wish to control.

In your Assembly file, create as many expressions as you expect there to be Components that you wish to control the suppression of, giving them names like 'Comp_01', etc. Initially give them all the value of '1'. Note that they do not need to have any dimensionality or units, a simple 'Constant' will do fine.

Now go to the Assembly Navigator, select a Component of interest, press MB3 and select the 'Suppression...' option. When the dialog opens, if you're using more than one Arrangement, select the Arrangement(s) that you wish this suppression setting to apply to. If you wish it to apply to ALL of them, select the button labeled 'Select All Arrangements'. Now toggle ON the 'Controlled by Expression' option and enter the name of the previously created relevant expression name below the item you just selected and hit OK.

Now all that you need to do to control the suppression status of a Component is to go to the Expression dialog and edit the value of the relevant expression, changing it from '1' to '0' ('1' is un-suppressed and '0' is suppressed).

That should get you started.

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.

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