Electronics Forum | Tue Feb 24 11:42:06 EST 2009 | sys_steven
Hey Everyone: Does anyone have a simple tool for BOM Comparisions, Such as excel.....Thanks
Electronics Forum | Fri May 12 01:55:29 EDT 2006 | AR
If you are not talking about a large number of BOMs, the cheapest way would probably be to do a CSV export of the BOMs and write an Excel macro in VBA to do the actual comparison.
Electronics Forum | Wed Jul 14 11:56:35 EDT 2004 | Frank
Is there a freeware, or shareware, software that can merge my CAD data and BOMs? Maybe an Excel macro to do the trick? Thanks, Frank
Electronics Forum | Mon Aug 31 09:27:33 EDT 2009 | jamyboy
With Pronto Place I can generate a Mydata program and automatically merge an Excel bom in about 20 seconds. Takes longer if I need to produce assembly doxs...but still faster than Circuit Cam...have used the Mydata macro in the past also, but it does
Electronics Forum | Wed Apr 18 14:18:28 EDT 2007 | jdumont
Hi all, does anyone know of any free software (Excel Macro?) that can compare BOMs and show like pairs for reducing setup time from job to job?
Electronics Forum | Tue Nov 28 14:09:37 EST 2017 | emeto
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 col
Electronics Forum | Thu Oct 29 11:15:58 EST 1998 | Scott B
| | Does anyone know of any software programs that will verify a Pick & Place program to the Bill of Materials (BOM)? Verify meaning the Part # and Ref. Des. matching of the two files. | | We use GCPlace to merge our BOM with X/Y file | but ocas
Electronics Forum | Wed May 15 22:23:38 EDT 2002 | ianchan
Hi mates, need some help to resolve a thumb-twine situation. As a high-mix, low volume prototype build house, we always conduct a first article inspection (FAI) on every model setup conversion in the SMT production Lot run. we do this FAI by mounti
Electronics Forum | Mon Jun 13 07:56:37 EDT 2022 | spoiltforchoice
This is basic spreadsheet manipulation. Sort your exported BOM from your pick and place machine into the same order as your BOM. Now paste the columns you want to compare from one to into the other. In an empty adjacent column you can now put in a fo
Electronics Forum | Mon Sep 01 21:26:51 EDT 2014 | proy
We are a smaller company and have created our own systems using FilemakerPro, and it grows and evolves with us as we constantly improve it. Filemaker is a complete relational database system wrapped up WITH the tools to create your user interface -
