libra's Blog

My Father died of Lung cancer Today, at the age of 82. He fought it for over a year. I was there today when they took the life support off. They had done all they could for him. He smoked for most of his adult life. I will miss him.

Libra Dave

I'm wondering how many of you know how to to do the Math for due Pairs. It's really not that hard. All you need to Know is the Hit Average of the pair , and how many skips it has at the present. Then you Divide the Hit average into the skips, and this will give you an index number. The higher the index number the more due the Pair is. You can do this in Excel easy. In Column A put the 55 boxed pairs, in Column B put the Skips, in Column C  put the hit average. you only need to go 1 decimal  like 17.9 . Column D will be the Index column. Click on the first empty cell in Column  D ,and Click on the upsidedown triangle next to Autosum, then click on sum and Type in B2/C2 and hit enter. You should see a number in the cell.In the lower right corner of that cell is a little black square, when you put your pointer on it it shows a +. Click on it and the rest of the column will fill up. Then go to data and sort by the index or due number.  Here's a small sample of what it looks like.

NUM	SKIPS	AVE	DUE	P4BTH
35	38	10.3	3.69
37	23	9.7	2.37
66	43	20.8	2.07
59	20	10.1	1.98
28	18	9.5	1.89
57	19	10.1	1.88
05	19	10.3	1.84
04	18	10.8	1.67
48	15	9.3	1.61
78	15	10.5	1.43
33	23	16.3	1.41
44	26	19.0	1.37
18	12	9.9	1.21
45	13	10.8	1.20
22	21	18.5	1.14
15	12	11.0	1.09
58	12	11.0	1.09
01	11	10.1	1.09
06	10	9.7	1.03
12	11	10.7	1.03
17	11	10.9	1.01

As you can see it puts the doubles where they are not all at the top of the list. Since Doubles tend to move slower then unmatched. I used the last 2000 sets of numbers for this chart. I hope this has helped someone.

Libra Dave