Hi Harold, Thanks a lot, it is in fact a real help in generating BOMs.
However, I am squeezing everithing out of Kicad, that's - I guess - the reason why on my system it did only half the job by leaving quite some lines unconsilidated and only uses the first 3 columns. Let me explain: Instead of using simple names for schematic components like "10K" I rather use long and complex names like "10K_1%_W125_0805". Reason is that I use the name as part identifier ans link these to a unique stock/order number and some other information within the extra fields. Means, I am using most of the remaining fields. I am also not sure, how compatible the different MS-Office versions are in terms of handling macros. I am currently using Office 2007. I'll run more tests and will try to impove the macro but unfortunately I am flat out with the job for the next few weeks :-( Cheers, Heiko --- In [email protected], "Harold King Tarun" <haroldk...@...> wrote: > > Hi Heiko, > > Here's the MS Excel that you need to consolidate your BOM (including > instructions on how to use it). Hope you find it useful. You can get > the instructions here http://cybercircuits.co.cc/blog/?p=13 > > Any bug kindly let me know. > > Cheers > Harold > > --- In [email protected], "oecherexpat" <heiko.lange@> wrote: > > > > Kicad always creates the BOM with one part per line only. A suggestion > > to add a function was aparently never implemented (I found some nice > > screenshots in the files area). > > So, what I need is a tool that creates out of this: > > R1 10K 0805 > > R2 10K 0805 > > R3 47K 0805 > > > > something like this: > > 2 R1, R2 10K 0805 > > 1 R3 47K 0805 > > > > Does anyone have a solution how to create consolidated BOMs by using > > Openoffice (or MS-Office)? > > > > Thanks, Heiko > > >
