HELP! Macro to eliminate 5 match numbers

[Kenya649]

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

 

[CMF]

So, your premise is that because 6 integers have appeared 17/10/2010 they can be eliminated and despite the draw being a random selection of 6 from 49 in your mind it is now 6 from 43 and if the next draw has different integers it is down to 37 and if again different down to 31. ie from 13,983,816 possibilities to 736,281.

You have enough draws in your local game to check this out. You may even find 4 consecutive draws with unique integers which according to your way of looking at it means there is only 177,100 possibilities for the 5th draw!

Check it out.

Colin Fairbrother

 

[Kenya649]

Thank you Colin for your reply.

What I want is to eliminate any combination that have a 5 numbers match from the existing drawn combinations e.g

17/10/2010 12 14 16 31 34 35

I should be able to eliminate 1,12,14,16,31,35 or 10,12,14,16,31,35 because both have a 5 number match in 12,14,16,31,34,35.

I hope it is clear now.

Thanks

 

[CMF]

Test it out by the simplest case.

As recently as September 10, 2009 the Bulgarian Pick 6, Pool 42 Lotto game had the same six integers occur in consecutive draws.

There is nothing wrong with coming up with ideas that you think might give you an advantage in Lotto but you should test them out. Some can easily be dismissed by the simple maths involved. If what you assert had even a whiff of credibility then the probability theorems that Lotto operators rely on would have to be re-written. You can test out the idea yourself by considering simple cases that don't involve millions of numbers.

For a Pool of 6 integers only one Pick 6 is possible. For a Pool of 7 there are 7 possible Pick 6 and for Pool 8 there are 28. The principles that apply to smaller Pools also apply to the large like Pool 49. You are saying for a hypothetical Pick 6, Pool 7 game that you can eliminate any CombFive in a nominated draw from appearing in whatever subsequent draws. Like I said check it out and the answer should be obvious. Now do the same with the 28 possibilities for a hypothetical Pick 6, Pool 8 game - one line eliminates 13 possibilities according to your premise or 46% of the possibilities. You don't have to do many random selections of 6 integers from a Pool of 8 to find this does not stack up.

Here is an online Random Number Generator you can use: -
http://randomizer.org/form.htm

Colin Fairbrother

 

[Frank]

I agree with Colin for all the reasons he gives. I also thought through the programming requirements for what you ask. It would involve identifying each of the 6 quins contained in each past draw and then for each of those, identifying the 44 possible 'parent' lines of 6 which might contain those quins. So that would identify 264 lines to eliminate for each past draw.
Even if your lottery has had 10000 past draws that would only eliminate 2,640,000 lines, approximately 18% of the available lines, assuming its 6/49. So even if your premise was correct, it is a very inefficient way of eliminating lines to reduce the odds, so I wouldn't consider it worth while writing the macro.

Regards,
Frank

 

[CMF]

Not much mileage in "eliminating" CombFives

Kenya649

I was hoping you would work it through and realize as Frank says that you are approaching it from the opposite angle to that usually adopted which is to restrict the integers although the basis for doing so is just as irrelevant.

Consider the draw if 01 02 03 04 05 06 - for 01 02 03 04 05 the possible CombSixes that can be formed end with 06 to 49 or only 44. For the other 5 CombFives there are 43 possibilities for each which means only 259 are "eliminated". For another draw like 07 08 09 10 11 12 you will have only 558 "eliminated". This is about as effective in terms of reducing the possibilities as firing a pea shooter at the USS Missouri.

My advice to you is to stop thinking about the occult stuff and put your efforts and attention into the structure of the set you play. It won't make any difference as far as winning Lotto first prize but you are at least on a valid line of inquiry as well as being a stimulant to the brain.

Colin Fairbrother