Hi Heiko, I have released an updated version. This includes processing of all used column even when you have manually inserted a column or not plus all the checked fields from Eeschema. Any features you want to include kindly drop me a line.
Regards, Harold --- In [email protected], "oecherexpat" <heiko.la...@...> wrote: > > 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" > <haroldking@> 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 > > > > > >
