Welcome Guest
Log In | Register )
You last visited December 2, 2016, 7:21 pm
All times shown are
Eastern Time (GMT-5:00)

Pick3 Game Index Digits

Topic closed. 55 replies. Last post 4 years ago by boise.

Page 1 of 4
54
PrintE-mailLink
pavizlo$'s avatar - binary
OKC, OK
United States
Member #120575
December 22, 2011
811 Posts
Offline
Posted: November 9, 2012, 11:14 pm - IP Logged

This method has been differently discussed sometime ago. The purpose of this method is to sort the hottest

digits in the last 20 draws of your state pick3 history. This method select only 2 digits among the low, 2 digits among the medium, and 2 digits among the high.

The digits are defined as follow:

(L) Low digits are 0, 1,2

(M) Medium digits are 3,4,5,6

(H) high digits are 7,8,9.

Thanks to CarliG the exel program will do all for you.

Here the link  https://www.box.com/s/vzpnd7fosydoe9ojdl9f

How to play:

You will need to enter the last 20 draws of your pick3 drawing history.

The "Game Index" table show the sorted digits among the Low (L), Medium (M), and the (H) High digits.

In the "Index Plays" table are the numbers ready to be played for the next 3 days.

The "Draw Digits Frequency Numerical Order" table show all the digits and thier frequencies.

Please back test it for your state by picking any month and 20 draws of its  history. 

GOOD LUCK EVERYONE

    Scott311's avatar - 311 logo01.jpg
    N.C.
    United States
    Member #59229
    March 9, 2008
    327 Posts
    Offline
    Posted: November 9, 2012, 11:39 pm - IP Logged

    Is this file working correctly? I enter numbers and the Game Index and the other boxes do not change. I've used CarliG's excel programs in the past with no issues.

      pavizlo$'s avatar - binary
      OKC, OK
      United States
      Member #120575
      December 22, 2011
      811 Posts
      Offline
      Posted: November 9, 2012, 11:46 pm - IP Logged

      Is this file working correctly? I enter numbers and the Game Index and the other boxes do not change. I've used CarliG's excel programs in the past with no issues.

      I just double check it is working, here it is again

      https://www.box.com/s/vzpnd7fosydoe9ojdl9f

      GOOD LUCK EVERYONE

        lakerben's avatar - spherewall
        New Mexico
        United States
        Member #86099
        January 29, 2010
        11114 Posts
        Online
        Posted: November 10, 2012, 12:15 am - IP Logged

        I just double check it is working, here it is again

        https://www.box.com/s/vzpnd7fosydoe9ojdl9f

        The gi stays at 167 ,238 no matter what input I enter.

        How about them cowboys!

         

         

        US Flag

          Scott311's avatar - 311 logo01.jpg
          N.C.
          United States
          Member #59229
          March 9, 2008
          327 Posts
          Offline
          Posted: November 10, 2012, 12:19 am - IP Logged

          The gi stays at 167 ,238 no matter what input I enter.

          I Agree!....Yep, no matter what you enter the numbers stay the same in the boxes.

            Avatar
            Florida
            United States
            Member #66575
            October 30, 2008
            3549 Posts
            Offline
            Posted: November 10, 2012, 12:31 am - IP Logged

            I Agree!....Yep, no matter what you enter the numbers stay the same in the boxes.

            Thanks for the heads up guys ,

            I will disable the download till I can get it figured out.

            If I remember correctly , I had this issue before and it had to do with what excel version user had and how I hve is saved ,

            Thanks

            Carlig

              Avatar
              Florida
              United States
              Member #66575
              October 30, 2008
              3549 Posts
              Offline
              Posted: November 10, 2012, 12:35 am - IP Logged

              I Agree!....Yep, no matter what you enter the numbers stay the same in the boxes.

              Scott ,

               

              Are you using Excel  7  or  10  ??

              Thanks

              CG

                Avatar
                Florida
                United States
                Member #66575
                October 30, 2008
                3549 Posts
                Offline
                Posted: November 10, 2012, 12:39 am - IP Logged

                I just downloaded it from the link I provided and it works just fine ..

                If you look down at the "Frequency "  numbers, are you seeing them change  ???

                CG

                  Scott311's avatar - 311 logo01.jpg
                  N.C.
                  United States
                  Member #59229
                  March 9, 2008
                  327 Posts
                  Offline
                  Posted: November 10, 2012, 12:41 am - IP Logged

                  Scott ,

                   

                  Are you using Excel  7  or  10  ??

                  Thanks

                  CG

                  I am actually using OpenOffice, all of your other files in the past worked with no issue..... P.S. I wanted to thank you for all the work you do here on the forums. You're an Excel wiz!Thumbs Up

                    Scott311's avatar - 311 logo01.jpg
                    N.C.
                    United States
                    Member #59229
                    March 9, 2008
                    327 Posts
                    Offline
                    Posted: November 10, 2012, 12:45 am - IP Logged

                    I just downloaded it from the link I provided and it works just fine ..

                    If you look down at the "Frequency "  numbers, are you seeing them change  ???

                    CG

                    What link do you have? When I use the two links posted above, none of the numbers change when I enter the results.

                      Avatar
                      Florida
                      United States
                      Member #66575
                      October 30, 2008
                      3549 Posts
                      Offline
                      Posted: November 10, 2012, 12:46 am - IP Logged

                      I am actually using OpenOffice, all of your other files in the past worked with no issue..... P.S. I wanted to thank you for all the work you do here on the forums. You're an Excel wiz!Thumbs Up

                      Thanks Scott ,

                      Lakerben also uses Open Office, so Im wondering now if that is the issue ....

                      If anyone that uses excel , is having issues, hope they will speak up .

                      Im not sure there is anything I can do to get it open office compatible .

                      Maybe if Pogo is around , he can take a look and maybe comeup

                      with something .

                      Sorry Guys

                      Carlig

                        Avatar
                        Florida
                        United States
                        Member #66575
                        October 30, 2008
                        3549 Posts
                        Offline
                        Posted: November 10, 2012, 12:56 am - IP Logged

                        What link do you have? When I use the two links posted above, none of the numbers change when I enter the results.

                        So not even the frequency changes, Down at the bottom ??

                        It may be the formulas are too complex for open office ??

                        Keep in mind that the index itself is not going to change every day. So to test I would pad the lowest frequency and see if that changes anything .

                        Hope I said that right lol

                        CG

                          Avatar
                          New Member

                          United States
                          Member #116073
                          September 3, 2011
                          21 Posts
                          Offline
                          Posted: November 10, 2012, 12:56 am - IP Logged

                          Hi Carlig,  I downloaded the file and it is working fine for me.  I am using Excel 2003.  I did change the formula in columns C, D, and E.  This formula does count the zeros even if you don't put the 0 in the original number. Like 83, when it should be 083.  Column C formala = (INT(B2/100), Column D formula =INT((B2-(C2*100))/10), and Column E =INT((B2-((C2*100)+D2*10))).

                          I hope this helps.

                            Avatar
                            New Member

                            United States
                            Member #116073
                            September 3, 2011
                            21 Posts
                            Offline
                            Posted: November 10, 2012, 12:58 am - IP Logged

                            P.S.  I have downloaded alot of excel file you post and you have helped me a lot.  Thank you for all you do.

                              Avatar
                              Florida
                              United States
                              Member #66575
                              October 30, 2008
                              3549 Posts
                              Offline
                              Posted: November 10, 2012, 1:05 am - IP Logged

                              Hi Carlig,  I downloaded the file and it is working fine for me.  I am using Excel 2003.  I did change the formula in columns C, D, and E.  This formula does count the zeros even if you don't put the 0 in the original number. Like 83, when it should be 083.  Column C formala = (INT(B2/100), Column D formula =INT((B2-(C2*100))/10), and Column E =INT((B2-((C2*100)+D2*10))).

                              I hope this helps.

                              Thanks , Let me take a look at original and see what formulas say .

                              Really appreciate the input.. I am surely no wiz at this stuff. I just saw a need for it and started reading excel help sites , trying to learn , but its a slow process .

                              I will save this formula for sure..  I usually format the input as text to eliminate that issue, but doings so does give me trouble sometimes .

                              I will change that and reupload and let Scot or Laker try it..

                              Thanks

                              CG