Welcome Guest
You last visited December 3, 2016, 4:44 pm
All times shown are
Eastern Time (GMT-5:00)

# Ideas on tracking pairs using date

Topic closed. 5 replies. Last post 11 years ago by lottaloot.

 Page 1 of 1
Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: May 7, 2006, 9:37 am - IP Logged

I am having the darnest time trying to figure out how to track time lapsed between pair hits using dates.

I am tracking doubles at the moment.

I am wondering anyone has been able to successfully track this & if so, could you please share.

L ttaL   T

East of Atlanta
United States
Member #6191
August 11, 2004
1389 Posts
Offline
 Posted: May 7, 2006, 12:51 pm - IP Logged

Problem in tracking with this method in Excel is you have to address ALL 6 possible combinations individually.

My basic spreadsheet looks like this (some of you may have seen it)

 Day Eve a b c ab ac ba bc ca cb H/L O/E Group Sum Sat 05/06/06 529 5 2 9 259 52 59 25 29 95 92 HLH OEO S HLHOEO 16

This setup is designed to allow me to track any number, pair and be broken down by the individual days (I stopped tracking individual day of the week because I never saw a usuable outcome).

As you can see, the ab thru cb columns will allow you to hunt down every possible combination. The formulas are setup such to not allow the same number to be repeated.

Now, if you simply setup your spreadsheet such to allow tracking of each individual column, you will be able to track the numbers easier. Once all the numbers is compiled, you can then write a formula that will allow you to simply pick and choose the smallest number of the 6 columns as the primary. In otherwords, your basic layout will look something like this

 No ab ac ba bc ca cb OUT 01 21 11 45 57 12 98 11 02 5 34 37 4 3 2 2 03 6 48 23 29 44 1 1

Now you can see how long it has been since a pair has hit (this chart is fictional and provided for example only). The long & short of it is, there is no shortcut to doing it. It will require a LOT of work to establish the chart. But, once it is done, sorting on the OUT column will allow you to track which pairs are out for a long time.

Hope this points you into the right direction.

Sir Metro

United States
Member #14
November 9, 2001
31339 Posts
Offline
 Posted: May 7, 2006, 12:53 pm - IP Logged

thanks sir metro

love to nibble those micey feet.

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: May 7, 2006, 2:25 pm - IP Logged

Thanks SirMetro.

I have your sheet & I am able to track how many draws out a pair is.

What I thought that I could do would be to track the in-between phases of the reoccurrences.

Say, the 22 pair

In MI, it is out 47 draws now.

But the time before that it was out 110 draws ago, etc.,etc

L ttaL   T

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: May 7, 2006, 2:52 pm - IP Logged

Though this is set up more towards Pick 6 games, this is sort of the type of info that I am looking for.

Thanks goes to WSLS.

Meanwhile, I am still looking.

http://www.techonthenet.com/excel/macros/pairs.php

L ttaL   T

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: May 7, 2006, 3:14 pm - IP Logged

I decided to try & play around with the above sheet.

Seems that I can adjust this sheet to fit my needs.

L ttaL   T

 Page 1 of 1