You will find that the format you suggest will not import very easily into excel, it gets very messy. The problem is that you don't know how many of the components such as C1, C2 and so on there will be on any line. So the totals would not appear in the same col. (That might not matter to you)
If you only want a total of each value such as 100nF 6 off then you can get that directly via excel from the standard lst file. Use excels pivot table function. First import the lst file into a worksheet, you should end up with two cols, ref and value Click on the first cell start the pivot table wizard, it should pick up the limits of the imported data click finish (let the wizard do the work) On the pivot table worksheet (will automatically pop up) drop ref into col fields drop val into row fields drop ref into data fields That will produce a grid with the totals at the end if you don't want to see the data and just get the totals drop rep into the page fields as well, and 6that will hide the data You can do quite a lot with the formatting and such like so it's worth having a play and working through the tutorials on pivot tables . There is of course a problem... You really need to include the footprint data as well, because the default output does not tell you what type of cap or resistor it is. You might have 47 ohm 1/8 watt Resistors, and a couple of 47 ohm 10 watt jobs in the project, likewise for caps, you may have 10V working, 50V and so on. For purchasing you need to know this. You may find that it's better to process the stuff file generated by Cvpcb to extract the additional data. You could also process the cmp file created by pcbnew. In either case it's prob a task better suited to access or a bit of programming than excel. Andy On Mon, 18 Jan 2010 08:53:12 +0100 "Stephrac74" <[email protected]> wrote: > Hi all, > > > > I’d like to generate the bill of material with the following format : > > > > Value References Quantity > > 100nF C1,C2,C8,C10 4 > > 47Kohms R1, R2, R3 3 > > > > Instead of having 1 line per reference like : > > 100nF C1 > > 100nF C2 > > 100 nf C8 > > > > That would be easier to import the BOM and use it directly in excel for > purchasing. > > > > Is there any way to do ? I don’t find the correct configuration > > > > > > Regards > > Stephane >
