Hi Paul,
I'm not an expert either but I do use scripting quite a lot - poor man's
modeling tool.
Pivot table is not my world - yet - but what I had in mind was very
quick and simple and will get you most of the way there in a single
operation. Paste the second BOM directly beneath the first in EXCEL.
Then use _D_ata _S_ort utility to collect all info for similar
components into groups - 1 pass - very quick.
Then all you need to do is use simple sum formulas to add Qty totals.
If there are lots of different components you may need to get more
sophisticated - hence the pivot table suggestion may be more appropriate.
Regards,
Jim Parr
Ge wrote:
Paul Gaastra wrote:
Sounds like the right way to do it but I'm not an Excel expert.
I may do a LabVIEW program to do it.
What you want in Excel is a pivot table. Simplified: Import the one BOM in
one sheet, the other BOM in another sheet. Copy the data of both into a
third sheet, so that they form a single area. Make sure the columns have
proper headings. Then create a pivot table of that area in yet another
sheet (using the pivot table wizard).
Now experiment a bit with the pivot table and the fields in it; probably
doesn't take long until you "get it". Possibly a pivot table tutorial
beforehand helps. Much quicker than any programming.
Gerhard
____________________________________________________________
You are subscribed to the PEDA discussion forum
To Post messages:
mailto:[email protected]
Unsubscribe and Other Options:
http://techservinc.com/mailman/listinfo/peda_techservinc.com
Browse or Search Old Archives (2001-2004):
http://www.mail-archive.com/[email protected]
Browse or Search Current Archives (2004-Current):
http://www.mail-archive.com/[email protected]
____________________________________________________________
You are subscribed to the PEDA discussion forum
To Post messages:
mailto:[email protected]
Unsubscribe and Other Options:
http://techservinc.com/mailman/listinfo/peda_techservinc.com
Browse or Search Old Archives (2001-2004):
http://www.mail-archive.com/[email protected]
Browse or Search Current Archives (2004-Current):
http://www.mail-archive.com/[email protected]
