Please help with MS Excel

Kavajo

Why six numbers? Has he got confused with the National Lottery? Roulette is one number at a time. If you're going to bet on six numbers, why not do 12 and make doubly 'sure'??

As for the person spinning the ball being a factor, that's just a red herring. You don't need maths to see through that one. Do you really think the croupier can successfully aim the ball? And why? They don't get paid commission. In my experience, croupiers are on players side and want them to win - but within the rules of course. If you put a bet on Red, they will want it to be Red so that you win. If there is noone else playing, they will say it out loud.

Blakespops

victor2 wrote: »

Not sure I understand that as they appear to contradict each other. Can a number be repeated in a group of six three or four times?

It's quite a challenge for Excel, any 6 from 37 numbers without any filtering applied and allowing for repetition gives just over 2.5 billion combinations. Of course, many of those would be the same 6 numbers, just in a different sequence, but I suspect you'll still end up needing quite a bit of paper to print the list on!:)

No he says when the combinations are sorted for example number 4 will be in a number of combinations and when they work out how to cover the bets they share them in such a way that some numbers overlap and thus more than one of them is betting on the same number as I say above although I hope you understand this explanation. he explained to me how they share out the combinations so I can deal with that as it is a repeating pattern. although trying to get the filtered combinations is giving me such a headache and useing all my supplies of coffee I am thinking of taking up smoking again to destress lol.

Blakespops

Kavajo wrote: »

Why six numbers? Has he got confused with the National Lottery? Roulette is one number at a time. If you're going to bet on six numbers, why not do 12 and make doubly 'sure'??

As for the person spinning the ball being a factor, that's just a red herring. You don't need maths to see through that one. Do you really think the croupier can successfully aim the ball? And why? They don't get paid commission. In my experience, croupiers are on players side and want them to win - but within the rules of course. If you put a bet on Red, they will want it to be Red so that you win. If there is noone else playing, they will say it out loud.

not sure I agree that they want you to win. I had a friend who worked in casino and he got paid bonus at end of month for most profitable table. although they rotate round casino on all games the eye in sky keeps eye on them and he told me that they know how fast they spin the ball and where they release it can judge to a degree 90% of the time what part of wheel it will land in and aim for any but biggest winning part for punters.


I asked about the six bets and he says as they cover the bets in the way he worked out having six people doing the betting makes it easy for each to remember their sets of numbers because 6 numbers is same as local phone numbers & if was three people with sets of 12 numbers it would be harder to remember them. and if more people covering fewer numbers he says it is just another person to share profits with when they are not needed.

he says they have roulette cards from casino that you are allowed to keep track of the game on, he uses these with their number patterns on and if they are stopped they just say they copy numbers that have been out. they have sets that put most money on red odd, red even, black odd, black even, then in other sets and combining the sets helps on table and as they do not bet every spin they wait for one to have not been out for a long time and then bet it until it wins and thats how they win. For me it is still down to luck but I just wish to learn something new on the filtering in marcos.

not sure if you or Victor are kind enough to be working on this for me Any help would be most welcome. but the theory of working it out is half the fun now nevermind why I need it lol.

victor2

Blakespops wrote: »

not sure if you or Victor are kind enough to be working on this for me Any help would be most welcome. but the theory of working it out is half the fun now nevermind why I need it lol.

It is fun to try. I'm not that up on Excel and VBA, but have tried some of the theory in a language I am more familiar with.

Am I right in that 0 0 0 11 11 11 is the first combination that meets the criteria?
So far, it tells me there are 1,638 valid combinations out of the first 50,000, it will find less as it goes on due to repetition, but I suspect there will be a lot of combinations!

Blakespops wrote: »

they do not bet every spin they wait for one to have not been out for a long time and then bet it until it wins and thats how they win.

Ah, bet on the wheel's memory, always a winning move.:rotfl:

Blakespops

victor2 wrote: »

Ah, bet on the wheel's memory, always a winning move.:rotfl:

Too true. Maybe he needs a new CPU himself never mind doing this, but hey whatever floats his boat. I am happy puttung my £5 on football pools every month with the odd bet on horses.

no not 0,0,0,11,11,11; 0,1,2,11,12,13 would be first. each player has 0-36 so each set is from that. I see what you have done but that is mixing all six players.

to simplify things it is one set of numbers with filters applied then they share the filtered numbers between themselves based on red odd, red even, black odd, black even, high, low. seems once the filters are applied they break down nice for them that way. he has invited me to go along with him next time he goes to see it working. told him he could make this easy for me by giving me his set of the numbers. he just said "nice try, you think this is easy and you can prove it that I am wrong then prove it? He even said he will buy me the new laptop I need if I can prove it that he can not make a profit from this.

victor2

Blakespops wrote: »

no not 0,0,0,11,11,11; 0,1,2,11,12,13 would be first. each player has 0-36 so each set is from that. I see what you have done but that is mixing all six players.

So does each player have to have a different number then? I'm a bit confused. Using the system I had thought you had, there were 34,670 valid combinations from the first million possible ones, but that will drop considerably if there can be no repetition within a set.

Keeping me quiet and my computer occupied anyway!:)

Kavajo

It is an interesting programming challenge, but I'm a bit lost here as to what the rules for this system are. Is the plan to look out for certain series of numbers and then make a bet? The fallacy with that has already been observed, that the previous spins have no effect on the next one. I'd like to have a go at testing it (not for real) if you can explain the rules more clearly.

victor2

Kavajo wrote: »

It is an interesting programming challenge, but I'm a bit lost here as to what the rules for this system are. Is the plan to look out for certain series of numbers and then make a bet? The fallacy with that has already been observed, that the previous spins have no effect on the next one. I'd like to have a go at testing it (not for real) if you can explain the rules more clearly.

Couldn't agree more. My understanding of the rules may have missed something, but I concluded a database was pretty much essential and using one brought my time to check 1 million combinations down from 58 minutes to 78 seconds. Left Excel out of it long ago!

Blakespops

victor2 wrote: »

So does each player have to have a different number then? I'm a bit confused. Using the system I had thought you had, there were 34,670 valid combinations from the first million possible ones, but that will drop considerably if there can be no repetition within a set.

Keeping me quiet and my computer occupied anyway!:)

Sorry if I have not explained what they do clearly. I will try as simply as I can. Someone earlier said something about the lottery, well this is what I told the guy that if he has worked this out for roulette why not do it on lottery as is same principle of betting on numbers and if each of his pals bets on six numbers at a time they could win more and he said that with this yes it is same principle to a point however as they bet based on roulette table layout and only need 1 number and not every bet placed is aimed at getting the big pay out he says half are so they get their combined money back the rest are sliding scale upwards to one that will give then 8x their combined bets. they do not bet every combination left as it would cost £1000's their way they have fun beating the house in a legal way and betting in a way that even doing the same amount every spin they can alter how spread the bets are.

From the numbers 0-36 they are 2324784 combinations of 6 numbers before the filters are applied (after filters he says is still lots these they devide into groups red odd, red even, black odd, black even, high, low. they then share these groups between the 6 of them and once they decide what group to bet on they each have their set of numbers to bet. he says each person is still left with more than enough in each group that they through playing instinct and the numbers covered in strict order dictate how they can make a profit the six of them are given equal combinations of the six number sets remaining after to bet on the roulette wheel. they filter out all combinations as said ( no more than 4 odd or 4 even in any set of six, no more than 2 consecutive numbers, no more than 3 from any 10(0-9,1-10 etc)) then as will still have lots of combinations left they do not have more than 3 numbers duplicated in any combination that they match up for betting. they then split the remaining sets to the roulette table, red odd red even etc. and if they see for example red and odd have not been out for a combined 3 spins they bet on all red odd sorted cards they have shared. as roulette only has 9 red odd among the numbers will be other numbers too that they would win small amounts on but as all six have to bet the 9 red odd numbers would be the ones that they direct most of the bets too ensuring they have huge bets placed where they see will come out.

This is where I tell him it is all down to luck as it could be another ten or more spins before red odd comes out and he said thats why with six of them splitting the combinations how he does they have enough cover to at least win their money back if any of their numbers and many times more when red odd wins, and always a way to move bets around, from high numbers, low numbers etc that as they are betting same amount everytime they bet the house do not say anything.

victor2

Blakespops wrote: »

From the numbers 0-36 they are 2324784 combinations of 6 numbers before the filters are applied

Where do you get that number from? It's way too small unless you're already applying some restrictions.

Blakespops wrote: »

no not 0,0,0,11,11,11; 0,1,2,11,12,13 would be first.

Surely there are more than 2 consecutive numbers in that, which is one of your rules?

Anyway, still fun to try.
I'd just let your friend go on winning. Meanwhile, I'll just buy lottery tickets with 1,2,3,4,5,6 on them. It's never won, so must be due to come up soon according to the laws of statistics!:D