BOM with configurations

[dtheffron]

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?

 

[Regg]

Are you showing all three configs on the same drawing?

 

[macPT]

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

 

[macPT]

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

 

[dtheffron]

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?

 

[dtheffron]

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.

 

[SBaugh]

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*

 

[TateJ]

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​

 

[macPT]

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

 

[TateJ]

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​

 

[macPT]

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