Wow. I have been importing the Protel format bom into excel for years. I have always had to re-order the parts afterward and that has been a real pain. This is much better. Mucho gracias David.
Regards, Steve Smith, C.I.D. Product Engineer Staco Energy Products Co. Web Site: www.stacoenergy.com & www.stacopower.com > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Carl Duncan > Sent: Thursday, April 28, 2005 8:03 AM > To: 'Protel EDA Discussion List' > Subject: RE: [PEDA] BOM sorter (Schematic .csv format) > > > David, > I have been using your bom sorter for almost a year now. > Thanks for you hard work in design this. It has saved me alot > of time in > doing my own bom's. > > I would highly recommend it to anyone generating bom from protel sch. > > > > Carl Duncan > Design Engineer > Audio International > [EMAIL PROTECTED] > www.audiointl.com > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 28, 2005 4:28 AM > 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]
