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)
Good answer Andy,
That’s a way, not so useful, but which works at least.
In order to not mix references with same value but different type (power or
voltage as you said) the best is to specify it in the value field.
Usually, I write somewhere that all the values are for instance
Hi all,
Id like to generate the bill of material with the following format :
ValueReferencesQuantity
100nF C1,C2,C8,C10 4
47Kohms R1, R2, R3 3
Instead of having 1