need help to excel this number elimination for pick6 gamesPrev Topic Next Topic

New Topic New Poll

powerball1

MA
United States
Member #171,823
January 12, 2016
255 Posts
Offline

Jun 17, 2019, 4:20 pm
i need some help to excel a number elimination system i have seen here before that was designed by someone on lotto logix i think. it is done by grouping previous draws and then eliminating these groups of numbers i am gonna paste it here..i have been doing this manually but any help automating it in excel will be highly appreciated to cut down the numbers to wheel. hopefully excel can show me what numbers to eliminate in my wheel

how is works is we want to eliminate numbers in group B and E that arent in group A and C. the groups are 3 recent draws in group A , then the next 3 in group B then the next 4 draws in group C, the next 3 draws in group D and the last 3 draws in group E .. the draws look like this
```
Group E907 10/05/02 Sat 09-15-16-26-28-42908 10/09/02 Wed 10-20-26-40-41-47909 10/12/02 Sat 17-20-32-41-50-52Group D910 10/16/02 Wed 03-34-36-37-40-51911 10/19/02 Sat 11-27-30-36-43-52912 10/23/02 Wed 16-17-30-31-41-49Group C913 10/26/02 Sat 11-20-25-37-48-51914 10/30/02 Wed 05-19-20-23-29-31915 11/02/02 Sat 01-07-11-29-37-40916 11/06/02 Wed 05-09-12-21-27-38Group B917 11/09/02 Sat 04-15-24-25-36-44918 11/13/02 Wed 12-22-27-32-38-44919 11/16/02 Sat 01-02-09-15-23-40Group A920 11/20/02 Wed 12-17-21-23-39-44921 11/23/02 Sat 01-22-23-34-36-39922 11/27/02 Wed 04-05-17-28-32-37




any help will be appreciated


thanks
```
Mr-B 216

Ohio
United States
Member #179,976
February 15, 2017
1,283 Posts
Offline

Jun 17, 2019, 9:44 pm

See if this helps.

What goes around comes around.
winsumloosesum

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

Jun 17, 2019, 10:51 pm

BopP Link:

https://www.lotterypost.com/thread/174273

Excel

https://my.pcloud.com/publink/show?code=XZF6Va7Zbi0cFDrdru4oh35rhtolVSXB3S07

I wonder why Group D was never considered???

Credit to BobP

How to Eliminate Some Numbers: by Lotto-Logix cr 2002

Even though we'd like to put all the numbers into play, the
cost can be prohibitive. Even the addition of a few numbers
to a game sends the odds soaring and eliminating a few numbers
has the reverse effect.

The Florida game odds were raised from 6/49's 1 in 13.9
million to 6/53's 1 in 22.9 million. Four additional numbers
almost doubled the odds!!! On the other hand the successful
elimination of four or more numbers has an exactly opposite
effect lowering the odds an equal amount.

The standard method of eliminating numbers to bring a 6/53
game back to a 6/49 or to bring a 6/49 to 6/48 for wheeling or
even to 6/43 to eliminate 8 million combinations, is to not
play some or all of the numbers drawn in the prior draw. 45%
of the time none of the numbers from the prior draw are drawn
again in the next.

In other words, if on Sat. 12/07/02 01-03-07-32-34-49 is drawn
don't play any of those numbers in the next draw. On Wed
12/11/02 08-10-15-24-48-53 was drawn containing none of the
numbers from the previous drawing. This trick works about 45%
of the time and more often if you only eliminate one or two of
the previous drawn numbers for an easy divide by six.

The reason lotteries use games like 6/49 rather than 6/48 is
to make it harder (requiring more combinations) to cover the
numbers evenly. You can play all 48 numbers on 8 combinations
it becomes confusing trying to cover all 49 when 5 have to be
specially picked to go with the 49th.

How to Eliminate More Numbers

Sometimes you want to remove more than six numbers from play
at a time. The following method does this again about 45% of
the time. It can NOT be used in conjunction with the above
method of eliminating the previous six numbers, in fact it
requires you play them.

Print out the last 20 draws or more, whatever's easiest.

Draw a line after the most recent 3, the next most recent 3,
then most recent 4, and the next two most recent 3. This
gives us two groups of 3 draws, followed by a group of 4 draws
and finally two more groups of 3 draws. Like this . . .

Group E
907 10/05/02 Sat 09-15-16-26-28-42
908 10/09/02 Wed 10-20-26-40-41-47
909 10/12/02 Sat 17-20-32-41-50-52
Group D
910 10/16/02 Wed 03-34-36-37-40-51
911 10/19/02 Sat 11-27-30-36-43-52
912 10/23/02 Wed 16-17-30-31-41-49
Group C
913 10/26/02 Sat 11-20-25-37-48-51
914 10/30/02 Wed 05-19-20-23-29-31
915 11/02/02 Sat 01-07-11-29-37-40
916 11/06/02 Wed 05-09-12-21-27-38
Group B
917 11/09/02 Sat 04-15-24-25-36-44
918 11/13/02 Wed 12-22-27-32-38-44
919 11/16/02 Sat 01-02-09-15-23-40
Group A
920 11/20/02 Wed 12-17-21-23-39-44
921 11/23/02 Sat 01-22-23-34-36-39
922 11/27/02 Wed 04-05-17-28-32-37

Write out the numbers in your game, in this case it would be
from 01 to 53.

If the number appears in group A or C make a check next to it.
When done you should have 42 check marks. Count them.

If the number appears in group B or E and is not already
checked, put an "X" next to it. (ignore those with checks)

Play the numbers with and without check marks, don't play the
numbers with "X" next to them.

Let's see how this works out . . .

01 ** 16 X 31 * 46
02 X 17 ** 32 * 47 X
03 18 33 48 *
04 * 19 * 34 * 49
05 *** 20 ** 35 50 X
06 21 ** 36 * 51 *
07 * 22 * 37 *** 52 X
08 23 *** 38 * 53
09 * 24 X 39 **
10 X 25 * 40 *
11 ** 26 X 41 X
12 ** 27 * 42 X
13 28 * 43
14 29 ** 44 *
15 X 30 45

As you can see we have 42 checks [*] and 11 with an "X" so we
eliminated 11 numbers from play.

And the winning draw on 923 11/30/02 Sat was 05-07-12-13-43-49
all from the checked and blank numbers a success!!!

As I said this works about 45% of the time. When it does as
in this case we eliminated 11 numbers from play taking the
game from a 6/53 at 1 in 22.9 million odds to a 6/42 at 1 in
5.2 million a 17.7 million combination reduction in odds!!!

If this had been a 6/49 at 1 in 13.9 million combinations game
the successful elimination of 11 numbers would make it a 6/38
game for the draw at 1 in 2.8 million and this is before
you've created your first combination!
powerball1

MA
United States
Member #171,823
January 12, 2016
255 Posts
Offline

Jun 17, 2019, 11:08 pm

thank you so much winsum i greatly appreciate it

i dont know why it wasn't considered but so far in back testing the numbers in group B and E are excluded like he said 45% of the time...so far i have found every 4-5 draws they are excluded which bring the field down by usually 11 numbers or so...
winsumloosesum

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

Jun 17, 2019, 11:44 pm

This my 5/30 Treasure Hunt Game

Went back 1 game to Saturday and all 5 numbers hit but total sets would be reduced from 142,506 to 53,130 sets or 62.7% sets removed.
powerball1

MA
United States
Member #171,823
January 12, 2016
255 Posts
Offline

Jun 17, 2019, 11:53 pm

Quote: Originally posted by winsumloosesum on Jun 17, 2019
This my 5/30 Treasure Hunt Game

Went back 1 game to Saturday and all 5 numbers hit but total sets would be reduced from 142,506 to 53,130 sets or 62.7% sets removed.

interesting...i didnt know i could use it for pick 5...do i just leave the 6th position blank?

definitely going to do some back testing...

i think the system was designed to eliminate numbers from the pool thats why by default group D isnt considered much...all your winning numbers were in group A and C other than the 20 which isnt excluded by default...
winsumloosesum

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

Jun 18, 2019, 12:24 am

I can make you Excel files for your Game.

I'm going to make a Cash543 and 6/49 for Pennsylvania.

There is probably a ratio of how many draws to use versus how many numbers are in your game

I should probably reduce the number of games per draw.

53 number/6 balls drawn

Groups

A = 18 or 34% of 53 balls

C= 24 or 45.2% of 53 balls

Total 42 total numbers/53 total or 79%

Groups

B = 18 34%

E = 18 34%

Total 36 total numbers/ 53 total or 68%

So, 5/30

A + C = 24 total numbers? 10 + 14

B + E = 20 total numbers? 10 + 10
Mayte

Mexico
Member #193,547
November 3, 2018
310 Posts
Offline

Jun 18, 2019, 11:29 pm

Yes winsumloosesum i want your excel files please, can you make a excel file for a lotto 5/28 and 6/39 please

New Topic New Poll

Subscribe to this topic

need help to excel this number elimination for pick6 gamesPrev TopicNext Topic

need help to excel this number elimination for pick6 gamesPrev Topic Next Topic