Sounds like the right way to do it but I'm not an Excel expert.

I may do a LabVIEW program to do it.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Jim Parr
Sent: Wednesday, 23 November 2005 4:16 p.m.
To: Protel EDA Discussion List
Subject: Re: [PEDA] How combine Bill o Materials from two PCB's on 99SE

Hi Paul,

How about....
1    Generate BOM output using csv or spreadsheet option/s for each PCB.
2    Export both output files (if u use .DDB container mode).
3    Import BOM's into EXCEL.
4    Use spreadsheet tools (macro record or VB scripted auto becomes
option) to sort and concatenate BOM's with appropriate qty groupings etc
- whatever you need to do.

Regards,
Jim Parr

Paul Gaastra wrote:

>Does anyone know how to combine the Bill of Materials to give the order

>totals for two PCB's?
>
>
>My solution was to put the two schematics in a project. Re annotate the

>second PCB with component designators starting at 1000 and get the
>single BOM.
>
>
>Not a good solution because now I've messed up the component
>designators.
>
>
>Thanks
>
>
>
>
>
>
>______________________________________________________
>
>The contents of this e-mail are privileged and/or confidential to the
>named recipient and are not to be used by any other person and/or
>organisation. If you have received this e-mail in error, please notify
>
>the sender and delete all material pertaining to this e-mail.
>______________________________________________________
>
>____________________________________________________________

______________________________________________________

The contents of this e-mail are privileged and/or confidential to the
named recipient and are not to be used by any other person and/or
organisation. If you have received this e-mail in error, please notify
the sender and delete all material pertaining to this e-mail.
______________________________________________________


____________________________________________________________
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]

Reply via email to