×
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

BOM with configurations

BOM with configurations

BOM with configurations

(OP)
How do I create a BOM for multiple configurations of my assmebly? I have the -01, -02, -03 configurations of the assembly that have 99% common parts.  How do I show the uncommon parts in the automated BOM?

RE: BOM with configurations

Are you showing all three configs on the same drawing?

RE: BOM with configurations

Huummm...!

- Do you have an excel macro to create BOM's in assemblies? (if not, it is not very difficult to find one in the internet). You need to make some modifications

- Before the BOM is created, instead of simply selecting the ActiveDoc, you should select each of the configs. You can create the BOM, for each config, in the same sheet, with no blank lines between them. This BOM I am referring can be only one or two columns (I would think in the part code and config name, for example).

- After BOM creation, for all configs, you should add extra Excel code to compare the items. First you should order the Excel sheet (alphabeticaly, for example). Then see if each line is equal to the following line. Count the number of equal hits and write it on the next collumn. At the end, you will have a list of used qty and select those with n. of hits = 1

Regards

RE: BOM with configurations

I forgot to tell that, after you have found equal ref. in following lines, check if the config name is the same (I gess that 1 component repeated in the same config has a different meaning than repeated in different configs).

Of course you can think in other things. For example, another way is to have each config on a different sheet (the sheet name can be the config name). This way you can have complete BOM's in different sheets. But the Excel code for components analysis will be more complex (I think!).

Regards

RE: BOM with configurations

(OP)
Sounds like this needs some Excel trickery.  That's unfortunate.  Thank you for your help.  Once I write this code, is there a good place to share it?

RE: BOM with configurations

(OP)
What is the Name of the Excel column that would display the configuration name?  EG to get the Item No., the entry would be ItemNo.

RE: BOM with configurations

Do you want to show the Config names in the BOM?

If so, then open the part, RMB the config and go to Properties. At the very bottom it lists the option you have for showing them in the BOM.

The Config name will show up in the Part No. if done correctly.

Best Regards,

Scott Baugh, CSWP
3DVision Technologies
credence69@REMOVEhotmail.com
http://www.3dvisiontech.com
http://www.3dmca.com

*When in doubt always check the help*

RE: BOM with configurations

I'm thinking this can be done without resorting to VBAdoo.
Unlese I'm missing something...
If you can view configs 01, 02 & 03 one-at-a-time in your assembly - then you can show each one one-at-a-time in the drawing BOM.
Make sure your drawing view that generated the BOM has the correct configuration in it.
Do this via right-click, properties and select the configuration.


Consume mass quantities...
tatej@usfilter.com

RE: BOM with configurations

OK TateJ, but how do you show the uncommon parts of all the configurations?

Doing it manually, you'll need to save each BOM you mention as *.xls and then, with Excel functions, find the uncommon parts.

Have you other ideas?

Regards


RE: BOM with configurations

So you want all the parts to show-up in the BOM - even if they are not used in the given assembly?
Set up your assembly configurations and HIDE rather than SUPPRESS the parts that aren't being used.
Is this what you want?
If not - then what do you mean by uncommon parts?


Consume mass quantities...
tatej@usfilter.com

RE: BOM with configurations

What I understand, from dtheffrom post, is that he wants to create a list of parts that are used in only one of the three configurations, but having the computer doing the all the job in an automated procedure.

Regards

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