Printed Circuit Board Assembly & PCB Design SMT Electronics Assembly Manufacturing Forum

Printed Circuit Board Assembly & PCB Design Forum

SMT electronics assembly manufacturing forum.

BOM Expander

Views: 8153

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 »

Equipment Auction - Eagle Comtronics: Low-Use Electronic Assembly & Machining Facility 2019 Europlacer iineo + Placement Machine Test & Inspection: Agilent | Tektronix | Mantis Machine Shop: Haas VF3 | Haas SL-20 | Mult. Lathes
Get your business noticed
Now Online
59
Visitors
2
Members

Who are SMTnet visitors?

Become a member now and receive the value and benefits of membership.

thru hole soldering and selective soldering needs
SMT feeders
One stop service for all SMT and PCB needs