Hi Harold, Thanks, it's indeed including all my other data to the BOM.
And I figured another challenge: The BOM has grown further because I added some more components. Means, I have some same components further down the list. Here's an example: R1 10K 0805 R2 10K 0805 R3 47K 0805 R4 10K 0805 Looks to me that the macro scan the next line but not the entire file, right? The result I see would be for the above example: 2 R1, R2 10K 0805 1 R3 47K 0805 1 R4 10K 0805 Cheers, Heiko P.S. Just saw that you live in NZ, too ;-) --- In [email protected], "Harold King Tarun" <haroldk...@...> wrote: > > 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.lange@> 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 > > > > > > > > > >
