Welcome Guest
Log In | Register )
You last visited January 16, 2017, 5:37 am
All times shown are
Eastern Time (GMT-5:00)

Identifying 'string' and other repeating patterns on EXCEL - all lotteries

Topic closed. 13 replies. Last post 6 years ago by JosephusMinimus.

Page 1 of 1
PrintE-mailLink
Avatar

United States
Member #105312
January 29, 2011
435 Posts
Offline
Posted: March 23, 2011, 10:07 am - IP Logged

Everyone who considers past draws significant might already be doing this, so I won't go into the minute details unless there's interest.

I've found that spreading the matrix horizontally alongside each draw offers a wide range of options in filtering by results groupings by date than I've been able to get otherwise.  Breaking out the individual numbers in a long history of draws might be done some easier way but the EXCEL countifs function is the only one I've found.  It allows filtering all past draws by date and groupings of specific number-hit combinations.

If anyone isn't already doing this, wishes to know how to do it, or knows a better way of doing it this is an invitation for discussion and exchanging information and/or methods.

    ameriken's avatar - 33ojew2
    Denver, Co
    United States
    Member #103046
    December 29, 2010
    546 Posts
    Offline
    Posted: March 23, 2011, 12:00 pm - IP Logged

    I'm completely in the dark about these string and repeating patterns, and would love to learn more if you are willing.

      Kia69's avatar - Jailin
      Brooklyn, New York
      United States
      Member #106172
      February 13, 2011
      103 Posts
      Offline
      Posted: March 23, 2011, 12:29 pm - IP Logged

      I will like to learn too!

      kia

        Avatar

        United States
        Member #105312
        January 29, 2011
        435 Posts
        Offline
        Posted: March 23, 2011, 12:33 pm - IP Logged

        I'm completely in the dark about these string and repeating patterns, and would love to learn more if you are willing.

        Hi ameriken.  Thanks for the interest and reply.  The pick 5 thread:

        The Pick 5 Jackpot Winning Thread--Get Your Numbers!!

        http://www.lotterypost.com/thread/226337 explains a part of the concept more throughly than I could.

        Lottolaughs has gone to a lot of trouble to create a series of repeating patterns or groupings he calls strings. 

        But my intention here isn't to intrude on what he has established and sustains through constant work.

        I don't know what method he uses to identify and test the strings.

        But the concept of strings might well spill over into other uses.  It does for me.

        I can provide a method of producing or identifying similar patterns using countifs function.  There might be an easier way of doing it.  I'm not a power user of EXCEL.

          ameriken's avatar - 33ojew2
          Denver, Co
          United States
          Member #103046
          December 29, 2010
          546 Posts
          Offline
          Posted: March 23, 2011, 12:40 pm - IP Logged

          I am a completely oblivious non-user of excel and don't even know what the countifs function is, so I may not be a big help. However, I did stay at a Holiday Inn Express. Big Smile

          Seriously, I do have other lottery software that can do quite a bit as far as analyzing and filtering, so I may be able to reproduce whatever it is that excel is doing.

          I've seen the other thread, and while I appreciate what Lottolaughs is doing with providing those strings, I tend to like learning and discovering on my own so I can eventually do my own predictions.

          Can you explain your understanding of strings?

            Avatar

            United States
            Member #105312
            January 29, 2011
            435 Posts
            Offline
            Posted: March 23, 2011, 2:52 pm - IP Logged

            I am a completely oblivious non-user of excel and don't even know what the countifs function is, so I may not be a big help. However, I did stay at a Holiday Inn Express. Big Smile

            Seriously, I do have other lottery software that can do quite a bit as far as analyzing and filtering, so I may be able to reproduce whatever it is that excel is doing.

            I've seen the other thread, and while I appreciate what Lottolaughs is doing with providing those strings, I tend to like learning and discovering on my own so I can eventually do my own predictions.

            Can you explain your understanding of strings?

            Ameriken:  I'd be out of my depth immediately if I attempted to superimpose my own understanding of repeated patterns and the patterns behind them, or groupings and the patterns of groupings.  As nearly as I can tell every attempt to beat the odds printed on the back of a betslip by using some type of system relies completely on past draw results.  Every one of them.  Every thread on this forum. 

            The countifs function I mentioned just allows a different way of examining past draws in a way the sequences, timings, groupings can be interpreted.

            I'm not an expert on lottery systems.  I'm not a successful predictor anyone would wish to emulate.  I'm just another of the thousands of people here attempting to understand the numbers events reflected in lottery draws.  I do it for different reasons than most of the posters here, but we're all doing the same thing and the main difference between me and others here is that I don't lose any money doing it.

            Thanks for the reply.

              CARBOB's avatar - FL LOTTERY_LOGO.png
              ORLANDO, FLORIDA
              United States
              Member #4924
              June 3, 2004
              5959 Posts
              Online
              Posted: March 23, 2011, 2:54 pm - IP Logged

              Ameriken:  I'd be out of my depth immediately if I attempted to superimpose my own understanding of repeated patterns and the patterns behind them, or groupings and the patterns of groupings.  As nearly as I can tell every attempt to beat the odds printed on the back of a betslip by using some type of system relies completely on past draw results.  Every one of them.  Every thread on this forum. 

              The countifs function I mentioned just allows a different way of examining past draws in a way the sequences, timings, groupings can be interpreted.

              I'm not an expert on lottery systems.  I'm not a successful predictor anyone would wish to emulate.  I'm just another of the thousands of people here attempting to understand the numbers events reflected in lottery draws.  I do it for different reasons than most of the posters here, but we're all doing the same thing and the main difference between me and others here is that I don't lose any money doing it.

              Thanks for the reply.

              I would like to see some of your countif formulas!!!!

                Avatar

                United States
                Member #105312
                January 29, 2011
                435 Posts
                Offline
                Posted: March 23, 2011, 3:55 pm - IP Logged

                I would like to see some of your countif formulas!!!!

                Carbob:  I'll try to cut and paste this from text.  I'm not sure of any other way to do it:

                =COUNTIFS($C2:$E2,G$1)

                The top is frozen with the date, draw and individual numbers from the matrix running across.

                Source date     1 2 3 4 5 6 7 8 9 10

                The draw history goes below and everything to the right uses the cut and pasted formula with the dollar signs depicting the positions of constant cells.

                AZ p3 3/15/2010 6 2 5  0 1 0 0 1 1 0 0 0 0

                 

                Nothing much to it.  If the matrix changes just carry the numbers on the frozen cells to the right and modify the formula.  If you have the RAM you can even use it for Keno games.

                Thanks for the reply.

                  Avatar

                  United States
                  Member #105312
                  January 29, 2011
                  435 Posts
                  Offline
                  Posted: March 23, 2011, 6:15 pm - IP Logged

                  I should have mentioned in the first post that some combinations within each matrix are surprisingly rare.  One advantage a person might find to using some method of examining them similar to this one helps identify those.

                    CARBOB's avatar - FL LOTTERY_LOGO.png
                    ORLANDO, FLORIDA
                    United States
                    Member #4924
                    June 3, 2004
                    5959 Posts
                    Online
                    Posted: March 23, 2011, 6:34 pm - IP Logged

                    Carbob:  I'll try to cut and paste this from text.  I'm not sure of any other way to do it:

                    =COUNTIFS($C2:$E2,G$1)

                    The top is frozen with the date, draw and individual numbers from the matrix running across.

                    Source date     1 2 3 4 5 6 7 8 9 10

                    The draw history goes below and everything to the right uses the cut and pasted formula with the dollar signs depicting the positions of constant cells.

                    AZ p3 3/15/2010 6 2 5  0 1 0 0 1 1 0 0 0 0

                     

                    Nothing much to it.  If the matrix changes just carry the numbers on the frozen cells to the right and modify the formula.  If you have the RAM you can even use it for Keno games.

                    Thanks for the reply.

                    Thanks for responding.What does the values in red represent?

                     

                    AZ p3 3/15/2010 6 2 5  0 1 0 0 1 1 0 0 0 0

                     

                     

                    The data below is for Fla Mid. A 6-digit string that stands at 121 draws, after todays draw.

                     

                     1,2,4,7,8,9
                    DIGITS0
                    HITS72
                    MED9
                    MAX120
                    AVG14.43
                    CUR.SKIP120
                      Avatar

                      United States
                      Member #105312
                      January 29, 2011
                      435 Posts
                      Offline
                      Posted: March 23, 2011, 7:05 pm - IP Logged

                      Thanks for responding.What does the values in red represent?

                       

                      AZ p3 3/15/2010 6 2 5  0 1 0 0 1 1 0 0 0 0

                       

                       

                      The data below is for Fla Mid. A 6-digit string that stands at 121 draws, after todays draw.

                       

                       1,2,4,7,8,9
                      DIGITS0
                      HITS72
                      MED9
                      MAX120
                      AVG14.43
                      CUR.SKIP120

                      That's the product of the countifs.  Immediately above would be the matrix horizontally in the top cells.  It just means 2, 6 and 5 each hit once that draw.  By filtering the numbers in the matrix cells you are able to filter up to a million individual draws for specific combinations.  EXCEL won't allow more than a million draws, but most uses and draw histories wouldn't go beyond 15,000 anyway.

                      Thanks.

                        CARBOB's avatar - FL LOTTERY_LOGO.png
                        ORLANDO, FLORIDA
                        United States
                        Member #4924
                        June 3, 2004
                        5959 Posts
                        Online
                        Posted: March 23, 2011, 7:06 pm - IP Logged

                        Thanks for responding.What does the values in red represent?

                         

                        AZ p3 3/15/2010 6 2 5  0 1 0 0 1 1 0 0 0 0

                         

                         

                        The data below is for Fla Mid. A 6-digit string that stands at 121 draws, after todays draw.

                         

                         1,2,4,7,8,9
                        DIGITS0
                        HITS72
                        MED9
                        MAX120
                        AVG14.43
                        CUR.SKIP120

                        In case anyone is interested, these are the straight combos, 64 of them, when the string breaks.

                         

                        035, 036, 053, 056, 063, 065, 305, 306, 350, 356, 360, 365, 503, 506, 530, 536, 560, 563, 603, 605, 630, 635, 650, 653
                        003, 005, 006, 030, 033, 050, 055, 060, 066, 300, 303, 330, 335, 336, 353, 355, 363, 366, 500, 505, 533, 535, 550, 553, 556, 565, 566, 600, 606, 633, 636, 655, 656, 660, 663, 665
                        000, 333, 555, 666

                          Avatar

                          United States
                          Member #105312
                          January 29, 2011
                          435 Posts
                          Offline
                          Posted: March 23, 2011, 8:18 pm - IP Logged

                          Thanks Carbob.  I don't get into examining single digit draws usually but I'll look this over.

                            Avatar

                            United States
                            Member #105312
                            January 29, 2011
                            435 Posts
                            Offline
                            Posted: March 26, 2011, 11:11 am - IP Logged

                            Anyone with a preference for visual mapping of databases might find the countifs useful, as well.  This map of a recent series of pick 4 draws is an example of such mapping.

                            The double helix patterns might eventually become boring, however.

                             


                            -11-----2-
                            ----2-11--
                            -1-1---11-
                            -1-1-1---1
                            --1-12----
                            --1-11-1--
                            -1--1-1--1
                            -1-2----1-
                            ---11-1--1
                            ---1-11---
                            ---12---1-
                            -1-------3
                            -------121
                            ---1--11-1
                            -1-111----
                            --1-111---
                            -11-1-1---
                            --21-----1
                            ---1----11
                            --1--1----
                            ------12-1
                            --11---1--
                            --1-111---
                            ------11-2
                            --2-------
                            --1-1----2
                            --11-1---1
                            --1-----11
                            -2-1----1-
                            -1-----1-1
                            -11------1
                            -----1-111
                            --1-21----
                            ---11--2--
                            ----2-11--
                            ---111----
                            --11---1-1
                            --1-1-11--
                            --21--1---
                            -----21-1-
                            --12----1-
                            --------12
                            -11----1--
                            --111----1
                            -2----1---
                            ------1-2-
                            ---121----
                            -1--1---11
                            ----1---12
                            ----1-----
                            --111-1---
                            -2-----1-1
                            -1------1-
                            -1--1-11--
                            ------21-1
                            ---2--2---
                            -1--2----1
                            --2-----11
                            --111----1
                            ------11-2
                            ----1----3
                            -1--1--1-1