I wanted to build a resistor kit for myself. Kits are available ready-made, but they are expensive. The lower-cost kits have a 5% tolerance but for prototype development purposes I'd rather just go for a 1% set with 100ppm temperature coefficient. This was just the sweet spot I decided on for my needs - not an extremely tight tolerance or tempco that would be expensive, and not such a loose tolerance/tempco either. Others will have different needs of course. There's nothing wrong with a 5% set or a very high precision thin film set. I just wanted a 1% low-cost (thick film) set with reasonable max temperature coefficient for general work.
I chose to build an 0805 set for now. It is easy to hand-solder.
Anyway, after some exploring I came up with a list of 172 different resistor values, and the part numbers were chosen to be low cost in a quantity of 100 each (i.e. 17,300 total resistors). I believe I've perhaps saved up to 50% by building the kit myself. The set contains approximately all E24 values (a few values are missing).
I figured it could be useful to document the order codes, in case anyone else wants to build a set.
The Excel file is attached to this blog post. The file is more useful in UK/Europe, because I used the Farnell order codes and most of these parts are of local stock. For US and other regions, there could be better part numbers preferable from Newark.
Also, there is no guarantee that this list will be useful forever. The parts could become out of stock at any time. They are currently in stock at the time of writing.
This is what the file looks like, in case you wish to create a custom order codes list, or edit this one:
Here is the entire list for informational purposes (the third column specifies the resistance in ohms), but please use the attached Excel file instead, since that is tested with the online Farnell BoM upload tool discussed below.
Part Number Quantity Description 2747563 100 0 2447599 100 1.2 2447631 100 2.7 2447656 100 3.3 2447657 100 3.9 2447714 100 6.2 2447724 100 7.5 2447734 100 8.2 2447741 100 9.1 2447556 100 10 2447566 100 12 2447586 100 18 2447609 100 22 2447615 100 24 2447614 100 24.9 2447621 100 27 2447640 100 33 2695047 100 36 2695056 100 43 2447684 100 53.6 2447690 100 56.2 2447698 100 61.9 2447703 100 64.9 2447707 100 68 2447717 100 71.5 2447730 100 82 2695100 100 90.9 2447738 100 91 2447558 100 110 2447568 100 130 2694996 100 160 2447583 100 180 2695006 100 187 2447611 100 240 2447618 100 270 2447619 100 274 2447633 100 300 2447645 100 390 2447679 100 510 2447686 100 560 2695073 100 562 2695085 100 681 2447716 100 715 2447719 100 750 2447726 100 820 2447728 100 825 2447736 100 910 2695107 100 953 2447588 100 1100 2694989 100 1400 2447593 100 1600 2447594 100 1780 2447595 100 1800 2447622 100 2000 2447623 100 2200 2447624 100 2260 2447625 100 2400 2447626 100 2490 2695027 100 2870 2447648 100 3000 2447650 100 3160 2447651 100 3300 2695042 100 3480 2447652 100 3600 2447653 100 3830 2447671 100 4640 2447674 100 4870 2447693 100 5600 2695076 100 5900 2695077 100 6040 2447709 100 6200 2447710 100 6490 2447711 100 6800 2447712 100 6810 2695089 100 7150 2447723 100 7870 2447739 100 9100 2447740 100 9530 2447553 100 10000 2447554 100 10500 2447559 100 11000 2447563 100 12000 2447565 100 12400 2447570 100 13300 2447571 100 14000 2447572 100 14700 2447578 100 16000 2694999 100 16200 2447579 100 16900 2447584 100 18000 2447585 100 18700 2447608 100 22600 2447613 100 24000 2447620 100 27000 2447634 100 30000 2695034 100 31600 2447639 100 33000 2695039 100 33200 2695046 100 36500 2447646 100 39000 2447660 100 43000 2447664 100 47000 2447665 100 47500 2695062 100 48700 2447668 100 49900 2447683 100 53600 2447688 100 56200 2695086 100 68100 2447729 100 82000 2695099 100 90900 2447551 100 100000 2447562 100 121000 2694990 100 140000 2447577 100 160000 2695000 100 169000 2447581 100 178000 2447582 100 180000 2447601 100 200000 2447632 100 300000 2695035 100 316000 2141769 100 348000 2447641 100 360000 2141927 100 365000 2141928 100 383000 2447644 100 390000 2695053 100 430000 2141933 100 442000 2141935 100 487000 2447667 100 499000 2447678 100 510000 2141939 100 562000 2447697 100 619000 2141943 100 649000 2447704 100 680000 2447718 100 750000 2141946 100 787000 2447725 100 820000 2447727 100 825000 2447731 100 866000 2141949 100 909000 2447735 100 910000 2141950 100 953000 2447596 100 1000000 2073588 100 1070000 2141953 100 1150000 2141956 100 1210000 2141958 100 1330000 2141960 100 1470000 2447597 100 1500000 2073590 100 1620000 2141964 100 1690000 2141968 100 1870000 2141969 100 1960000 2447628 100 2000000 2141971 100 2050000 2447629 100 2200000 2141975 100 2490000 2141976 100 2610000 2694975 100 2700000 2141983 100 3160000 2447655 100 3300000 2141985 100 3320000 2141989 100 3830000 2141992 100 4020000 2141994 100 4420000 2141995 100 4640000 2447676 100 4700000 2447695 100 5600000 2142000 100 5900000 2447713 100 6800000 2447733 100 8200000 2142008 100 9090000
To use the Excel file, this is what I did:
First, go to the farnell.com (or your local site) and then click on Tools->BoM Upload:
Next, the Excel file is uploaded to the website:
After a few seconds a Verify Fields page is shown. Using the drop-downs, set them as shown in the screenshot below. This is basically specifying what columns mean what in the Excel file.
Once Verify is clicked, there could be a delay of several minutes:
Finally, a page will appear showing the components! Click "Buy All"!
And that's it.. after that it is the usual order process. If there is a discount/offer, don't forget to apply it : )
Using the current discount/offer, I got the entire set for £84.40 plus tax. This is a lot less than ready-made resistor kits, and contains a lot more component values!
I will for sure need to expend effort to put them in some kit box, but I'm prepared to do that for the benefit that I get a lot more component values, reducing frustration when the value I want isn't handy, and saving money too!