Welcome Guest
The time is now 12:09 pm
You last visited April 28, 2017, 11:47 am
All times shown are
Eastern Time (GMT-5:00)

# libra's Blog

• libra's Blog has 2 entries (0 private) and has been viewed 10,922 times.
• libra is a Platinum member

## December 27, 2010, 8:48 pmMy Father Died today 12/27/10

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

Entry #2

## September 3, 2005, 11:58 pmFiguring Due Pairs

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

Entry #1