Welcome Guest
Log In | Register )
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
PrintE-mailLink
lottaloot's avatar - AvatarZ56
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

    SirMetro's avatar - center
    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)

     

    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 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

    NoabacbabccacbOUT
    0121114557129811
    02534374322
    0364823294411

    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

     

      emilyg's avatar - cat anm.gif

      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.

       

                                   

        lottaloot's avatar - AvatarZ56
        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

          lottaloot's avatar - AvatarZ56
          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

            lottaloot's avatar - AvatarZ56
            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