Hi Heiko, The release only considers 3 columns and ignores the remaining columns.
The next release will be considering all columns regardless of how many custom fields you may have. If any of the field changes it will count as another component. By the way it was written on MS Office 2003 and should be compatible to any version of MS Office including MS Office 97. As for the OpenOffice compatibility I will try to check tonight. Cheers, 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 > > > > > >
