This looks like it could be a very valuable tool. I just wondered though, when the macro groups various components together, which columns does it compare? The reason I ask is that if you generate the BOM in protel format it groups components only based on "part type" and "footprint", and ignores other columns. We place our internal P/N in the first part field and use it in our BOM reports. Since it doesn't compare the part fields, in some cases it means that parts are grouped together that are actually different internal part numbers.
Thanks, Darcy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John A. Ross [Design] Sent: April 28, 2005 4:25 AM To: Protel EDA Discussion List Subject: RE: [PEDA] BOM sorter (Schematic .csv format) Dave Bom sorter V11 http://www.proteluser.com/showthread.php?t=38 John > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 28 April 2005 10:28 > To: Protel EDA Discussion List > Subject: [PEDA] BOM sorter (Schematic .csv format) > > > > > > Hi all, > A while ago, I wrote an Excel macro to convert the schematic > .csv BOM into a sensible format. It is available from: > > http://www.proteluser.com/ > Look for BOM sorter version 11 > > But I think I may be able to attach it, so here goes: > > (See attached file: bom_sorter_v11.zip) > > Regards > > David Watling > > > > > > > "Harry Lemmens" > > <[EMAIL PROTECTED] > > me.com.au> > To > Sent by: "Protel EDA Discussion > List" > [EMAIL PROTECTED] <[email protected]> > > servinc.com > cc > > > > Subject > 27/04/2005 18:43 RE: [PEDA] BOM from > 99SE Schematic > > > > > Please respond to > > Protel EDA > > Discussion List > > <[EMAIL PROTECTED] > > .com> > > > > > > > > > > Under "Reports" in 99SE there is a generate "Bill of > Materials" option, which launches a so called "Wizard". This > allows you to select A project or a single sheet, various > fields to include in the BOM, Certain Titles that you may > prefer, and what output format/s you may require. > > I generally select both the "Protel format" and the CSV > format. The Protel format is just text, and can be > manipulated in a text editor. The CSV format can be loaded > into a spreadsheet (Excel, or whatever) for manipulation). > > Hoping that who ever did the schematic filled in all the > relevant info (Like footprints, Part type, etc) otherwise > there is still a lot of work to do to turn the BOM into > something useful! > > > Cheers > Harry > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Behalf Of Jeff Condit > Sent: Thursday, April 28, 2005 2:26 AM > To: Protel EDA Forum > Subject: [PEDA] BOM from 99SE Schematic > > I have been given a 99SE schematic and need to create a BOM > from it. How do I do that? > > Jeff > > ____________________________________________________________ > 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] > > > ____________________________________________________________ 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]
