this BOM sorter is great! i too have been using it for some time
just make the CSV BOM from protel and run this macro to make a useable BOM
ds
_______________________________________________________________________ Integrated Controls, Inc. Tel: 415-647-0480 EXT 107 2851 21st Street Fax: 415-647-3003 San Francisco, CA 94110 www.integratedcontrolsinc.com
Carl Duncan wrote:
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]
