Ideas on tracking pairs using date

Reply #5

lottaloot — Sun, 07 May 2006 19:14:24 GMT

I decided to try play around with the above sheet.

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

Reply #4

lottaloot — Sun, 07 May 2006 18:52:48 GMT

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

Reply #3

lottaloot — Sun, 07 May 2006 18:25:06 GMT

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

Reply #2

emilyg — Sun, 07 May 2006 16:53:28 GMT

thanks sir metro

Reply #1

SirMetro — Sun, 07 May 2006 16:51:33 GMT

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)

DayEve abc abacbabccacbH/LO/E Group Sum

Sat05/06/06529529259525925299592HLHOEOSHLHOEO16

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 a... [ More ]

Ideas on tracking pairs using date

lottaloot — Sun, 07 May 2006 13:37:47 GMT

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.