BOM Expander

Subscribe to Thread

When you get a BOM like this: PartNo;ID's;Qty;Package ... - Nov 28, 2017 by Spoiltforchoice

Most of it can be re-formatted in Excel. In cases like this ... - Nov 28, 2017 by Evtimov

FactoryLogix from Aegis has this ability. It will also th... - Jan 19, 2018 by heatherc

Hi, Can you tell us why you need it? We have solutions t... - Jan 28, 2018 by Alexei Shkolnik

... Laziness, less work / Excel skills than Evitmovs solutio... - Jan 28, 2018 by Spoiltforchoice

Spoiltforchoice

#79386

BOM Expander | 28 November, 2017

When you get a BOM like this:

PartNo;ID's;Qty;Package

1234;c1,c2,c3,c76,c99;5;0805

Does anyone use any simple tools out there that would automatically expand the BOM to one ident/line so that things are easier to find & compare with the pick and place file for example.

reply »

Evtimov

#79392

BOM Expander | 28 November, 2017

Most of it can be re-formatted in Excel. In cases like this I will spend the time to write some macros that does it automatically. If it is just a single occasion, just format it in Excel. You can turn commas into columns and rows. You can change columns to rows, you can write your own functions to do exactly what you tell them(5 operations at one click)

reply »

heatherc

#79640

BOM Expander | 19 January, 2018

FactoryLogix from Aegis has this ability. It will also then compare the BOM to CAD in seconds. Some examples of the checks it will do - references missing on either (confirms non-pops), qty on BOM that mis-matches the number of references listed, etc.

reply »

Alexei Shkolnik

#79663

BOM Expander | 28 January, 2018

Hi,

Can you tell us why you need it? We have solutions that includes this feature as a part of process such as QPlace, QPlan etc. You can read about our solution on the website: http://www.proventustech.com

Best Regards, Alexei

reply »

Spoiltforchoice

#79665

BOM Expander | 28 January, 2018

... Laziness, less work / Excel skills than Evitmovs solution and less money than something like Aegis. However we've had a recent increase in small but complex jobs as well as a good sniff of a large steady one and you can sneak all sorts into a new line ;).

reply »