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!