HELP! Macro to eliminate 5 match numbers

Reply #20

RJOh — Fri, 05 Nov 2010 03:49:54 GMT

All the winning numbers were in the mix, I just failed to get more than three of them on the same line so I can't blame them.

Reply #19

time*treat — Wed, 03 Nov 2010 21:56:01 GMT

I liked the numbers I picked tonight ...

Yeah, but will you still respect them after tonight's drawing

Reply #18

RJOh — Tue, 02 Nov 2010 18:24:39 GMT

I look at lottery predictions as an attempt to forecast lottery drawing results before the actual drawing based on past results, statistics and anything else that one thinks will help. At LP predictions are done for entertainment and as a hobby and is not meant to be taken to the bank regardless of the seriousness of the predictors. Playing and discussing the lotteries is a form of entertainment to me.

When some predictors post over 5000 combinations a day and are lucky to have even 1% of the... [ More ]

Reply #17

jimmy4164 — Tue, 02 Nov 2010 06:32:47 GMT

We that pick or own numbers are not predicting what will happen but rather play what we think or beleive will happen.

Hhhhmmmm...

Reply #16

RJOh — Tue, 02 Nov 2010 04:55:18 GMT

Tonight jackpot was raised to $12.8M, that's $6.4M cash or $425K+ yearly which is 10x my pension and SS so I could live with that. I could spend $5K weekly and have money left over.

I liked the numbers I picked tonight, only match 3 once with 20 lines but had I narrowed my selections to just the main group of numbers I selected I might have done better since all 6 winning numbers were in that group. Tonight's numbers didn't change the distribution of the numbers very much so I'll be trying We... [ More ]

Reply #15

Stack47 — Mon, 01 Nov 2010 22:56:52 GMT

According to my Classic Lotto statistics four numbers from the previous drawing have never been drawn so you could safely say it's highly unlikely any combination using four of those numbers will be drawn in the next drawing. Three numbers only repeated 10 times out of the 573 drawings I tested so a 1.7% chance is unlikely too. Four numbers from the previous two drawings are at a 1.9% chance too. Six numbers from the previous 4 drawings have only hit twice and five numbers were drawn 16 or 2.8%.... [ More ]

Reply #14

RL-RANDOMLOGIC — Mon, 01 Nov 2010 19:27:20 GMT

RJOH

I once read in the Bible that God caused a ass to speak. I though it was fable but now think it could

be Quite true. My wife has a system of hitting 2 or 3 numbers on one line with about 75% hit rate.

The odds for any one drawing are for selecting a set at random, does this mean that if the set is not

selected at random the odds do not apply? Way back, when I first studied statistics it was used by

applying certian data to the masses. If it is used to calculate a single event... [ More ]

Reply #13

jimmy4164 — Thu, 28 Oct 2010 05:32:07 GMT

RJOh,

With a little luck or more lines, I could have had a big winner.

Me too!

--Jimmy4164

P.S. Do you really think the results of 10 lines in one draw in a game with this many possibilities is of any significance? If you had matched all six it would have proved no more than that your ship came in. I don't think you read very carefully the bunch of words I referred you to.

Reply #12

RJOh — Thu, 28 Oct 2010 04:06:52 GMT

If you noticed the prediction board this evening, you saw I put into practice what I've been saying in my posts in my predictions for Ohio Classic Lotto with 10 lines.

The winning numbers for 10/27 were 29 31 34 36 45 47

I posted:

27 29 30 34 39 48

18 23 32 33 36 44

19 25 31 42 45 47

14 20 26 30 31 49

05 11 26 30 33 36

13 14 25 33 36 43

27 31 32 39 46 49

10 13 14 34 42 44

18 26 27 45 46 49

25 26 29 34 42 47

Everyone of those lines had at least one winning... [ More ]

Reply #11

jimmy4164 — Wed, 27 Oct 2010 22:07:23 GMT

RJOh,

None of us really likes to admit being wrong. One of the most seductive ways to avoid that is to change our opinions retroactively. We say, 'No, no, you just misunderstood, you thought I was saying X when I really said Y.' Or, even worse, sometimes we just stubbornly refuse to acknowledge the evidence in front of us.

Dean Esmay, April 17, 2002

http://www.deanesmay.com/posts/000656.html

--Jimmy4164

Reply #10

RJOh — Wed, 27 Oct 2010 13:32:23 GMT

When I said likely, I simply meant that they weren't part of the unlikely group that would match four of previous drawn combinations which I observed only came up 1% of the time in a 649 game. As I said before those combinations are just a drop in the bucket when you consider there are almost 14 millions possible combinations even though there are 13545 possible combinations that would match4 for every combination of 6 drawn.

When dealing that many possible combinations, there are always goin... [ More ]

Reply #9

jimmy4164 — Wed, 27 Oct 2010 02:37:58 GMT

RJOh,

When you write ...only a few of the most likely results, you reveal the mode of thinking which is hampering your ability to clearly see the impossibility of knowing WHICH few are more likely, OR if ANY are more likely. This might help you to see what I'm driving at:

http://en.wikipedia.org/wiki/Clustering_illusion

--Jimmy4164

P.S. I've alluded to AND pointed to this phenomenon in several other posts, but no one has engaged with it. I hope you will be the first.

Reply #8

RJOh — Tue, 26 Oct 2010 22:26:51 GMT

ON ANY GIVEN DAY, any of the nearly 14 millions combinations could come up. If you're only playing a few lines then you aren't trying to cover every possible result but only a few of the most likely results.

Reply #7

jimmy4164 — Mon, 25 Oct 2010 15:50:28 GMT

(Assuming the generally accepted definitions of unlikely and immediate, )

The way you stated it, unlikely to happen 90% of the time in the immediate future is true.

However, ON ANY GIVEN DAY, the chances that one of the 6 combos of 5 on your (6,49) ticket

matching one of the 6 determined by what the lottery draws, is STILL, 1:54,201.

Reply #6

RJOh — Mon, 25 Oct 2010 05:16:13 GMT

I checked the 557 drawings of Ohio Classic Lotto (6/49) and found only 3 combinations of five had repeated and when I combined those drawings with those of the old Ohio Super Lotto game, only 10 combination of five had repeated in those 1131 drawings.

That was more than I expected since the odds of matching 5of6 in a 649 game are 1:54,201 but never the less it showed the chances of matching a combination of five more than once had been 10:1131 or less than 1:100 thus my conclusion was it was... [ More ]

Reply #5

jimmy4164 — Mon, 25 Oct 2010 03:31:21 GMT

RJOh,

...the most unlikely draws...

...unlikely to be drawn...

Why?

--Jimmy4164

Reply #4

RJOh — Sun, 24 Oct 2010 23:09:56 GMT

He wouldn't be just eliminating any possible draws in the future but the most unlikely draws in the future. If you checked the history of any 6/49 game you'll find combinations of five seldom repeat so with each combinations of six, you can eliminate over 250 other combinations of sixes that are unlikely to be drawn and be right over 90% of the time. However that's a small drop in the bucket when you consider the fact that there are almost 14 millions possible combinations.

Reply #3

kenya649 — Sun, 24 Oct 2010 09:56:15 GMT

Thank you for your reply Phileight and Jimmy4164.

Let me have a close look on the macro.

Reply #2

jimmy4164 — Sun, 24 Oct 2010 02:00:36 GMT

Why would you want to eliminate any possible draws in the future?

Just because they've been drawn once, doesn't mean they won't be drawn again.

If not, I'd sure like to know why!

Even if your lottery had a policy to reject all draws that have already been drawn,

with millions of possibilities, have you figured out how old you would be before that

policy would become a significant factor

Reply #1

phileight — Sat, 23 Oct 2010 23:07:14 GMT

While it would be possible to remove these from a master list, it would be too time consuming. at some point you will generate a list of comb you want to consider. remove 5# matches from this list. the code below makes the following assumptions:

1. col 1 thru 4 starting in line 1 has all of the previous draws

2. col 10-15 starting with line 1 has comb that you want to check for 5 # matches

3. if a match is found the entire comb is removed from the list

as writen this code will on... [ More ]

HELP! Macro to eliminate 5 match numbers

kenya649 — Sat, 23 Oct 2010 07:46:33 GMT

My local game is a pick 6 (6/49) game and so far it has 385 draws.

Taking the latest draw

17/10/2010 12 14 16 31 34 35

it has

12,14,16,31,34

12,14,16,31,35

12,14,16,34,35

12,14,31,34,35

12,16,31,34,35

14,16,31,34,35

How do I write a macro to eliminate all the above from possible 13,983,816 and then for all the remaining draws?

looping each draw then each of 13,983,816 looking for a 5 match number takes too long to compute.

Thank you