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

Excel? How often do the bottom 5 short sums produce hits?

Topic closed. 77 replies. Last post 6 years ago by lakerben.

Page 2 of 6
4.84
PrintE-mailLink
WIN  D's avatar - q05Q0
Stone Mountain*Georgia
United States
Member #828
November 2, 2002
10491 Posts
Offline
Posted: January 24, 2011, 10:52 am - IP Logged

Okay I'll give it another. Something more like this?

Draw MO DT YR   DIGITS   SUM  SS    0         1        2       3        4        5         6        7           8         9 <------ (TEN little Ponies ready to run)

5381,12,31,2010   661       13    3     23       5          28       0        3         8                 11        17         2  And they are off!
5382,1,1,2011      158       14    4     24       6        29       1        0        9         2        12        18          3
5383,1,3,2011      299       20    0             7        30        2        1      10         3         13        19          4
5384,1,4,2011      926       17    7      1       8        31        3        2      11                  0         20          5
5385,1,5,2011      188       17    7      2       9        32        4        3      12         5         0         21          6
5386,1,6,2011      320        5     5      3       10       33        5        4                  6         1          22         7
5387,1,7,2011      416       11     1      4              34        6        5        1          7         2         23         8
5388,1,8,2011      581       14     4       5              35        7        0        2         8         3          24         9
5389,1,10,2011    757       19     9      6       2       36        8        1        3         9                  25         0
5390,1,11,2011    571       13     3      7       3        37        0        2         4        10         5        26          1
5391,1,12,2011    123        6      6      8       4       38        1         3        5          0        6        27          2
5392,1,13,2011    067      13      3      9              39        0         4       6          1         7        28          3
5393,1,14,2011    948      21      1     10      0        40         1        5         7                  8        29           4
5394,1,15,2011    195      15      5     11      1       41         2        6        0           3        9        30          5
5395,1,17,2011    043       7      7     12       2      42         3               1         4                 31          6
5396,1,18,2011    711       9      9     13       3      43                  8                 5                 32           0
5397,1,19,2011    832      13     3     14       4       44                 9         3        6         2        33           1
5398,1,20,2011    614      11     1     15       0        45                10        4         7        3        34           2
5399,1,21,2011    877      22     2     16       1         0                 11        5         8        4        35           3
5400,1,22,2011    278      17     7     17       2        1         3        12        6         9        0        36           4

Pink numbers are the lowest five SS counts for each draw.

0 (Zero)  shows a hit. Probably should have used a different color.

Looks nicer in Excel too. LOL But you can track the SS/LDR with it.

  Thanks everyone .....thanks very much for your help on this tracking idea  ...... it has been haunting around the game for a long time.

 

  Garyo...... it looks as if you have done it. Good on you for that great excel tracking up there!

 Thank you very much. The results up there even in that smaller sample.... seem to confirm the power of our old friend the ...."Basic ODDS" of the game.

 It confirms when we get those "gut feelings"     we should always try to check them against the "real world stats" (preferably larger stat samples ) ...first! 

 Based on the results you were able to produce......they seem to point back to the old 50/50 expectations.

 Out of the 20 draws listed ...... there were 9 that did not work .....and 11 that did seem to work the way we might have hoped for.  Yes, it is a small sample......but it is enough for me to run back to our old friend .....(again)  "Basic ODDS"  until we can prove otherwise .

 There may still be a way to push this filter to our advantage. We still need to look at the the top 5 missing or skipping Sums as "Traps" perhaps...... not so much as a STATIC group..... but based on some sort of total missing or skips.  Now, that would take a larger sample to confirm any advantage for us for the next draw... or twoSad Cheers   

 It sure looks like we need to do some more research that surround those ......total skips amounts........or ...looking at when sums reach a certain number of total skips for one sum or as a group of sums. Sort of a  Break point indicator for the next draw....or couple of draws. That would be big help as well.   

 

 

The only real failure .....is the failure to try.                               

                              Luck is a very rare thing....... Odds not so much. 

                              Odds never change .....but probability does. 

                                                                                       Win d    

    JAP69's avatar - alas
    South Carolina
    United States
    Member #6
    November 4, 2001
    8790 Posts
    Offline
    Posted: January 24, 2011, 10:55 am - IP Logged

     Pick ...Three

     IF we track the 10 "short sums" (LDR's) hits each day ......and always arrange them in order from top to bottom.

     The top being the short sum that is the most out by the number of skips....... 

       For example. 

      1.               Short Sum 8......out 32 days

      2.                                 7......out 24 days

       3.                                3 ...out  17 days

      4.                                 2 .....out  8 days

       5.                                0.....out 6 days 

    __________________________________

       6.                       Sum  1. ....out 5 days

       7.                                4.....out  4 days

       8.                                 5.....out 3 days

        9.                                6.........out 2 days

        0.                                 9..........out 0 days   


      Blue group being the Top group .......1..thru 5   

       Pink group being the group in Question....   The "Hot" group  ...... how often does the pink group(numbers 6 thru 0)  contain the winning number before the draw each day.  By number ...or per cent. 

     

         Does anyone already track this stat in Excel etc ?    Thinking of...   Anyone ?     Steve perhaps...?   LOL   

     

         In this HORSE RACE....... HOW often does the winning horse each day......come out of the Pink Static GATES 6...thru 10 ....?   

     

     

     

     

     

     

     

    "

    Hi WIN D

    The last I looked at the software you use you could create your own mix of numbers for group tracking. Maybe you could take all the lottery numbers in the pink group and and run the tracking on them to come up with a stat.

    MAGA

      Raven62's avatar - binary
      New Jersey
      United States
      Member #17843
      June 28, 2005
      49784 Posts
      Offline
      Posted: January 24, 2011, 11:03 am - IP Logged

       Pick ...Three

       IF we track the 10 "short sums" (LDR's) hits each day ......and always arrange them in order from top to bottom.

       The top being the short sum that is the most out by the number of skips....... 

         For example. 

        1.               Short Sum 8......out 32 days

        2.                                 7......out 24 days

         3.                                3 ...out  17 days

        4.                                 2 .....out  8 days

         5.                                0.....out 6 days 

      __________________________________

         6.                       Sum  1. ....out 5 days

         7.                                4.....out  4 days

         8.                                 5.....out 3 days

          9.                                6.........out 2 days

          0.                                 9..........out 0 days   


        Blue group being the Top group .......1..thru 5   

         Pink group being the group in Question....   The "Hot" group  ...... how often does the pink group(numbers 6 thru 0)  contain the winning number before the draw each day.  By number ...or per cent. 

       

           Does anyone already track this stat in Excel etc ?    Thinking of...   Anyone ?     Steve perhaps...?   LOL   

       

           In this HORSE RACE....... HOW often does the winning horse each day......come out of the Pink Static GATES 6...thru 10 ....?   

       

       

       

       

       

       

       

      "

      Skip     SLD     0     1     2     3     4     5     6     7     8     9      Total
      ========================================
      0     32     35     33     27     31     26     30     46     37     35     332
      1     33     40     35     29     24     25     32     34     35     31     318
      2     28     33     28     34     17     35     21     25     25     28     274
      3     18     32     35     29     15     29     29     23     28     22     260
      4     19     26     18     26     16     15     25     20     25     19     209

      1393 out of the last 3359 (41.47%) NJ Midday Draws were in the Hot Group

      A mind once stretched by a new idea never returns to its original dimensions!

        WIN  D's avatar - q05Q0
        Stone Mountain*Georgia
        United States
        Member #828
        November 2, 2002
        10491 Posts
        Offline
        Posted: January 24, 2011, 11:06 am - IP Logged

        Hi WIN D

        The last I looked at the software you use you could create your own mix of numbers for group tracking. Maybe you could take all the lottery numbers in the pink group and and run the tracking on them to come up with a stat.

         Well... HELLO John !  Sure is good to hear from you. 

          Yes, I have been looking into that as well as CarBob. We are hoping that Ricky might take an interest in it too.

          Having Ricky around always seems to bring us Good Luck ....when we need to come up with brilliant tracking or filter solutions like this.  LOL

         

         .......and Raven , your post just popped up. Thanks for those pal.... will look those over. At first blush it also seems to be another confirmation of the 50/50 solutions. 

         

         

        The only real failure .....is the failure to try.                               

                                      Luck is a very rare thing....... Odds not so much. 

                                      Odds never change .....but probability does. 

                                                                                               Win d    

          Raven62's avatar - binary
          New Jersey
          United States
          Member #17843
          June 28, 2005
          49784 Posts
          Offline
          Posted: January 24, 2011, 11:21 am - IP Logged

           Well... HELLO John !  Sure is good to hear from you. 

            Yes, I have been looking into that as well as CarBob. We are hoping that Ricky might take an interest in it too.

            Having Ricky around always seems to bring us Good Luck ....when we need to come up with brilliant tracking or filter solutions like this.  LOL

           

           .......and Raven , your post just popped up. Thanks for those pal.... will look those over. At first blush it also seems to be another confirmation of the 50/50 solutions. 

          Maybe it would be worthwhile to apply String Theory to SLDs...

          A mind once stretched by a new idea never returns to its original dimensions!

            Instyle's avatar - Lottery-044.jpg

            United States
            Member #55821
            October 21, 2007
            161 Posts
            Offline
            Posted: January 24, 2011, 11:26 am - IP Logged

             Pick ...Three

             IF we track the 10 "short sums" (LDR's) hits each day ......and always arrange them in order from top to bottom.

             The top being the short sum that is the most out by the number of skips....... 

               For example. 

              1.               Short Sum 8......out 32 days

              2.                                 7......out 24 days

               3.                                3 ...out  17 days

              4.                                 2 .....out  8 days

               5.                                0.....out 6 days 

            __________________________________

               6.                       Sum  1. ....out 5 days

               7.                                4.....out  4 days

               8.                                 5.....out 3 days

                9.                                6.........out 2 days

                0.                                 9..........out 0 days   


              Blue group being the Top group .......1..thru 5   

               Pink group being the group in Question....   The "Hot" group  ...... how often does the pink group(numbers 6 thru 0)  contain the winning number before the draw each day.  By number ...or per cent. 

             

                 Does anyone already track this stat in Excel etc ?    Thinking of...   Anyone ?     Steve perhaps...?   LOL   

             

                 In this HORSE RACE....... HOW often does the winning horse each day......come out of the Pink Static GATES 6...thru 10 ....?   

             

             

             

             

             

             

             

            "

            Hey Win D

            I don't if this helps in your research but this is what I've found.  Ususally ldrs repeat in a 7 day period.  What I do is I reveiw the last draws, see what ldr has not repeated in a 7da y period  and play the numbers based on my workout that falls withing that ldr.  Lately its been working for Ga cash 3. when you have a chance take a look at a list of draws with ldrs and see if you notice the same or similar pattern.

            Just a suggestion,

            Live and Learn

              Jordans121's avatar - nw bookeep.jpg

              United States
              Member #69169
              January 5, 2009
              2122 Posts
              Offline
              Posted: January 24, 2011, 11:35 am - IP Logged

               Pick ...Three

               IF we track the 10 "short sums" (LDR's) hits each day ......and always arrange them in order from top to bottom.

               The top being the short sum that is the most out by the number of skips....... 

                 For example. 

                1.               Short Sum 8......out 32 days

                2.                                 7......out 24 days

                 3.                                3 ...out  17 days

                4.                                 2 .....out  8 days

                 5.                                0.....out 6 days 

              __________________________________

                 6.                       Sum  1. ....out 5 days

                 7.                                4.....out  4 days

                 8.                                 5.....out 3 days

                  9.                                6.........out 2 days

                  0.                                 9..........out 0 days   


                Blue group being the Top group .......1..thru 5   

                 Pink group being the group in Question....   The "Hot" group  ...... how often does the pink group(numbers 6 thru 0)  contain the winning number before the draw each day.  By number ...or per cent. 

               

                   Does anyone already track this stat in Excel etc ?    Thinking of...   Anyone ?     Steve perhaps...?   LOL   

               

                   In this HORSE RACE....... HOW often does the winning horse each day......come out of the Pink Static GATES 6...thru 10 ....?   

               

               

               

               

               

               

               

              "

              Logically, Shortsums can have the same effect as the first digit of a pick 3 number. Obviously its kinda hard to pick the first digit for str8 hits so I see Short-sums the same way regardless of the numbers order.

              "Many Strategies|One Game"

                WIN  D's avatar - q05Q0
                Stone Mountain*Georgia
                United States
                Member #828
                November 2, 2002
                10491 Posts
                Offline
                Posted: January 24, 2011, 12:32 pm - IP Logged

                Logically, Shortsums can have the same effect as the first digit of a pick 3 number. Obviously its kinda hard to pick the first digit for str8 hits so I see Short-sums the same way regardless of the numbers order.

                 Sure......those "Logical" assumptions or approaches are always good. They are alot safer... and usually go without saying for most us long time players. We usually settle into playing the same standards most of the time ...and I'm no exception. LOL 

                 ( Unfortunately, I am still losing most of time when I play that way as well. ) LOL

                 

                 However, many.... many years ago before it could be confirmed "Logically" .......or what some folks would interpose here as "mathematically" .... I proposed a term to define a long time observation of mine or a (gut feeling) before it was proven mathematically. I'm glad I didn't wait for those years. It was a big help to me and several others until then. 

                 Happily, several years later it was actually confirmed mathematically. So, I have been rewarded several times since then by following other gut instincts and researching them as best I could ....before falling back on the old established obvious standards.  It doesn't hurt anyway.  LOL 

                 

                 

                The only real failure .....is the failure to try.                               

                                              Luck is a very rare thing....... Odds not so much. 

                                              Odds never change .....but probability does. 

                                                                                                       Win d    

                  Raven62's avatar - binary
                  New Jersey
                  United States
                  Member #17843
                  June 28, 2005
                  49784 Posts
                  Offline
                  Posted: January 24, 2011, 12:53 pm - IP Logged

                  Logically, Shortsums can have the same effect as the first digit of a pick 3 number. Obviously its kinda hard to pick the first digit for str8 hits so I see Short-sums the same way regardless of the numbers order.

                  I Guess It All Depends on What Kind of Player You Are: A Shotgunner or a Sharpshooter!

                  A mind once stretched by a new idea never returns to its original dimensions!

                    garyo1954's avatar - garyo
                    Dallas, Texas
                    United States
                    Member #4549
                    May 2, 2004
                    1718 Posts
                    Online
                    Posted: January 24, 2011, 7:29 pm - IP Logged

                    Great WinD!

                    Didn't hit me until Raven posted the tracking chart what was happening. 

                    I have all the data in a 264K CSV file. I haven't had time to incorporate it into an Excel page.

                    I just ran the program, took the text output into Excel and copied a portion to see if helped. 

                    Give me a bit and I'll upload it or send it. Pretty interesting stuff.

                    Thanks!

                      winsumloosesum's avatar - Lottery-060.jpg
                      Pennsylvania
                      United States
                      Member #2218
                      September 1, 2003
                      5387 Posts
                      Offline
                      Posted: January 24, 2011, 7:46 pm - IP Logged

                      Hi Chaz,

                      This is the Midday chart for Tuesday's Midday draws.

                      Midday LDR

                       

                      The LDR = Short Sum

                      Short Sum

                      Current Skip

                      So for example, Arkansas Midday in cell G7 you see LDR 7 - 19.  So this would represent the Short Sum 7 and the current skip is 19. 

                      The Short Sums are all sorted from highest skip (left) to lowest (or current skip) to the right.

                      I have 2 charts.  One for the current drawing (right) and previous skip (left side).

                      I "bolded" the Gates 5 & 6.

                        winsumloosesum's avatar - Lottery-060.jpg
                        Pennsylvania
                        United States
                        Member #2218
                        September 1, 2003
                        5387 Posts
                        Offline
                        Posted: January 24, 2011, 7:48 pm - IP Logged

                        Combined Short Sums

                          winsumloosesum's avatar - Lottery-060.jpg
                          Pennsylvania
                          United States
                          Member #2218
                          September 1, 2003
                          5387 Posts
                          Offline
                          Posted: January 24, 2011, 7:49 pm - IP Logged

                          Evening Draws Short Sums Chart

                            winsumloosesum's avatar - Lottery-060.jpg
                            Pennsylvania
                            United States
                            Member #2218
                            September 1, 2003
                            5387 Posts
                            Offline
                            Posted: January 24, 2011, 8:44 pm - IP Logged

                            Chaz,

                            Below is New Jersey Midday results for the last 5 drawings.

                            In the last 5 draws the winning LDR was from either the "Gate" 1, 2, 3, 4, 5.

                            Just a thought here.  When either "gates" 1 and 2 reach 20 or more skips look for either of the 2 LDR to hit the next drawing?

                             

                            New Jersey Midday

                              LANTERN's avatar - kilroy 28_173_reasonably_small.jpg
                              Tx
                              United States
                              Member #4570
                              May 4, 2004
                              5180 Posts
                              Offline
                              Posted: January 24, 2011, 11:46 pm - IP Logged

                               Pick ...Three

                               IF we track the 10 "short sums" (LDR's) hits each day ......and always arrange them in order from top to bottom.

                               The top being the short sum that is the most out by the number of skips....... 

                                 For example. 

                                1.               Short Sum 8......out 32 days

                                2.                                 7......out 24 days

                                 3.                                3 ...out  17 days

                                4.                                 2 .....out  8 days

                                 5.                                0.....out 6 days 

                              __________________________________

                                 6.                       Sum  1. ....out 5 days

                                 7.                                4.....out  4 days

                                 8.                                 5.....out 3 days

                                  9.                                6.........out 2 days

                                  0.                                 9..........out 0 days   


                                Blue group being the Top group .......1..thru 5   

                                 Pink group being the group in Question....   The "Hot" group  ...... how often does the pink group(numbers 6 thru 0)  contain the winning number before the draw each day.  By number ...or per cent. 

                               

                                   Does anyone already track this stat in Excel etc ?    Thinking of...   Anyone ?     Steve perhaps...?   LOL   

                               

                                   In this HORSE RACE....... HOW often does the winning horse each day......come out of the Pink Static GATES 6...thru 10 ....?   

                               

                               

                               

                               

                               

                               

                               

                              "

                              Well I was the one who didn't understand, I let my own ideas get in the way instead of really reading your post.

                              Your idea and mine are not the same, but both would tell or give Hot-Cold stats.

                              Those people did the workouts right, just not my way.

                              Oh well, I must be getting older than I thought that I was.

                              Sorry!

                              50-50 Kind of stats were never my kind of thing anyway.

                              And I also was wrong about having to need 100 past draws in order to do the workout my way maybe, probably maybe anywhere from 20 to 50 past draws might have been enough.

                              Duplicate counts might be there regardless of how many draws are used, but using way too many past draws might make the Hot-Cold counts more 50-50 even than using fewer past draws, maybe.

                              The last digit of the sum is a good filter and so are the digits and the pairs.

                              But instead of just having Hot-Cold  a 2 ways filter, the 10 ways or a 5 ways might be of more use maybe.

                              To me, Yes or No seem harder to filter out than a 5 or 10 pattern filter where you filter 1 to 3 of the 10 or 1 to 2 of the 5.

                              Well, I leave now this thread alone.

                              Good Luck to all!

                              ----------

                              BibleOnline  ParishesOnline  ChristianRadioOnline   MassOnline   Mass

                              "Ten measures of beauty descended to the world, nine were taken by Jerusalem."