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

New Topic New Poll

WIN D

Stone Mountain*Georgia
United States
Member #828
November 2, 2002
10,491 Posts
Offline

Jan 24, 2011, 10:52 am

Quote: Originally posted by garyo1954 on Jan 24, 2011
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 1   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 0   7 30 2 1 10    3   13 19 4
5384,1,4,2011 926 17 7 1 8 31   3 2 11 4      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   0   6    1   22 7
5387,1,7,2011 416 11 1   4 0   34 6    5   1   7 2 23 8
5388,1,8,2011 581 14    4     5 1   35 7    0 2 8 3   24 9
5389,1,10,2011 757 19 9 6    2 36 8    1 3 9 4   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 5   39 0 4 6 1 7 28 3
5393,1,14,2011 948 21 1 10   0   40    1 5   7 2   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 7 1 4 0   31 6
5396,1,18,2011 711 9 9 13 3 43 4   8 2   5 1   32 0
5397,1,19,2011 832 13 3 14 4 44 0   9 3 6 2 33 1
5398,1,20,2011 614 11 1 15    0   45 1   10 4 7   3 34 2
5399,1,21,2011 877 22 2 16 1     0 2   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 two.

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

South Carolina
United States
Member #6
November 4, 2001
8,967 Posts
Offline

Jan 24, 2011, 10:55 am

Quote: Originally posted by WIN D on Jan 22, 2011
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 ? 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.

Numbers are where you find them.
Raven62

25

New Jersey
United States
Member #17,842
June 28, 2005
180,983 Posts
Offline

Jan 24, 2011, 11:03 am

Quote: Originally posted by WIN D on Jan 22, 2011
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 ? 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!

Catch-22: A dilemma or difficult circumstance from which there is no escape because of mutually conflicting or dependent conditions.

Corruptissima re publica plurimae leges: When the republic is at its most corrupt the laws are most numerous.

The best way to learn is to never stop being an Experiential Student!
WIN D

Stone Mountain*Georgia
United States
Member #828
November 2, 2002
10,491 Posts
Offline

Jan 24, 2011, 11:06 am

Quote: Originally posted by JAP69 on Jan 24, 2011
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

25

New Jersey
United States
Member #17,842
June 28, 2005
180,983 Posts
Offline

Jan 24, 2011, 11:21 am

Quote: Originally posted by WIN D on Jan 24, 2011
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!

Catch-22: A dilemma or difficult circumstance from which there is no escape because of mutually conflicting or dependent conditions.

Corruptissima re publica plurimae leges: When the republic is at its most corrupt the laws are most numerous.

The best way to learn is to never stop being an Experiential Student!
Instyle

United States
Member #55,819
October 21, 2007
182 Posts
Offline

Jan 24, 2011, 11:26 am

Quote: Originally posted by WIN D on Jan 22, 2011
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 ? 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

United States
Member #69,167
January 5, 2009
2,299 Posts
Offline

Jan 24, 2011, 11:35 am

Quote: Originally posted by WIN D on Jan 22, 2011
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 ? 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

Stone Mountain*Georgia
United States
Member #828
November 2, 2002
10,491 Posts
Offline

Jan 24, 2011, 12:32 pm

Quote: Originally posted by Jordans121 on Jan 24, 2011
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

25

New Jersey
United States
Member #17,842
June 28, 2005
180,983 Posts
Offline

Jan 24, 2011, 12:53 pm

Quote: Originally posted by Jordans121 on Jan 24, 2011
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!

Catch-22: A dilemma or difficult circumstance from which there is no escape because of mutually conflicting or dependent conditions.

Corruptissima re publica plurimae leges: When the republic is at its most corrupt the laws are most numerous.

The best way to learn is to never stop being an Experiential Student!
garyo1954

Texas
United States
Member #4,549
May 2, 2004
4,228 Posts
Offline

Jan 24, 2011, 7:29 pm

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

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Jan 24, 2011, 7:46 pm

Hi Chaz,

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

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

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Jan 24, 2011, 7:48 pm
winsumloosesum

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Jan 24, 2011, 7:49 pm
winsumloosesum

Philadelpia/Pennsylvania
United States
Member #2,218
September 1, 2003
6,802 Posts
Offline

Jan 24, 2011, 8:44 pm

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

Tx
United States
Member #4,570
May 4, 2004
5,180 Posts
Offline

Jan 24, 2011, 11:46 pm

Quote: Originally posted by WIN D on Jan 22, 2011
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 ? 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."

New Topic New Poll

Subscribe to this topic

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

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