Hi Harold, Just tried V1.5.1 and found that at least with Excel 2007 it doesn't seem to recognise the macro any more: It's not using the *.lst filter when opening and starts the text import filter rather then the macro. On V1.5 all this was working fine.
Cheers, Heiko P.S. I'm in Christchurch, today's miserable weather zone. --- In [email protected], "Harold King Tarun" <haroldk...@...> wrote: > > Hi Heiko, > > Just to let you know that I have made some changes to the MS Excel > file. It should now parse all the rows and columns (basically the > entire file). > > Cheers, Harold > > P.S. Yes I live in NZ too, I'm in Auckland. Where abouts are you? :-) > > --- In [email protected], "oecherexpat" <heiko.lange@> 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 > > > > > > > > > > > > > > > > > > > > >
