Purge assemblies?

Apr 06, 2007 2 Replies

I must not be alone in this case.



We have assemblies with lots of configs (some 60+). Those live and components (and mates) get added and suppressed. Then configs get erased. At a point we know there are components and mates that are suppressed in every config, and we would like to erase them. One solution is going the Excel table way, to check for "always suppressed components". Quite a process (need to have an "all unsupressed" config).



Is there a "purge" command "à la Autocad", or any macro that lists every "always suppressed components" and asks if you want to erase them?



Thanks for reading so far, and for your answers.


I'm not sure if a purge command exist, however, you can setup a formula in your excel DT to detect how many parts are used or not.

=3DIF(COUNTIF(A1:A20,"R")=3D0,"Not Used", "Used")

CountIF returns how many cells equal "R" or "Resolved", use which ever. Make sure you range of cells covers everything. IF says if there are zero "R" (all supressed), then return "Not Used", else return "Used" You could put this at the bottom of you design table, just make sure you skip a row under the last config.

Hope this helps!

a écrit dans le message de news: snipped-for-privacy@y80g2000hsf.googlegroups.com...

=IF(COUNTIF(A1:A20,"R")=0,"Not Used", "Used")

CountIF returns how many cells equal "R" or "Resolved", use which ever. Make sure you range of cells covers everything.

Thanks for the answer, but the idea is: I press a button, and I get a list of eraseable items.

I guess by the echo here, that either is not so much of a pb, or no easy solution, or both. JM

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required