Hi Heiko, You are right I missed some rows whenever the similar component is placed in a different row.
Will update the MS Excel file later as I am transferring to another web hosting service. Cheers, Harold --- In [email protected], "oecherexpat" <heiko.la...@...> wrote: > > 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" > <haroldking@> 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 > > > > > > > > > > > > > > >
