watching daves videos was interesting;
Lets assume that; ( all to be prooved, but based on Daves info )
(a) The distribution of resistors follows a normal distribution.
(b) Resistors of -/+1% tolerance have a standard deviation of 0.125
The mean value is 1.5R
What i'd like to know is the probability that two given resistors are more than 0.2% apart in value. my statistics is too rusty to do this.
I have played a bit with Dave's data (400 1% resistors) in excel. Only around 63% possible resistor pairs are within +/- 0.2% tolerance. This might be acceptable if only one resistor pair is used per board, but not in case of 48 pairs.
You need 0.5^(1/48)=98,6% pairs in spec to produce half of the boards w/o rework.
I only need each pair ( not all the 48 pairs ) to be matched. ( sorry if that was not clear ).
I wrote a bit of python to programatically work out the statistical likelyhood of picking two resistors at random that were closely enough matched. on the reel of 1% parts, there is about 55% chance that the two parts would be within a match. Thats not really good enough, as nearly half of the random pairs would not match.
Given that obtaining the .1% parts wont' really be possible, sorting them is the last option. Grrh.
Parts will arrive on a 8mm reel. I'm thinking i'll use a PNP machine to 'unload' the reel onto a custom made tray, that has cut outs the size of the resistor.. It should take about 10 minutes to unload it into the tray.
I'll make a little test tool, that has a pair of pogo pins, and with the help of a couple of index pins in the tray will line up nicely.
In stead of connecting to a multimeter, i'll make a small test circuit, that will simplfy it down, and will just beep two tones, indicating if its in the most common central bins, or if its outside. If its outside, we will just use a small vacum pick up tool to discard them. Probably will end up with keeping about 60% of the parts, and chucking the rest. Given the very low cost of the the parts, compared to the labour.
The tray can then go back on teh pnp machine.. I wont' need to tell it when there is missing parts in teh tray, as it will figure that out when it can't pick them up. and will retry in the next spot.