Roulette Win/Lose column

[SloJoe]

Hi, I'm working with Excel 97 and am making a basic spreadsheet to evaluate roulette results (single '0' and double '00' wheels) with even/odd (red/black) bets so I can compare results to probability percentages for different betting systems.


TIA

See Attachment:

[jj72uk]

If you can explain the rules of roulette im sure i can help

[JBeaucaire]

And I wouldn't mind knowing how doing calculations on previous roulette spins helps? Each spin of the wheel represents that exact same chances as the spin prior. Prior events have no causal effect on subsequent spins.

[zbor]

Unless it's a eletronic roulette, designed to cheat

[SloJoe]

Here is a basic explanation:

http://casino.bodog.com/guide/roulette.html


Here is a more detailed explanation:

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


My spreadsheet has to do with the Outside "even money" bets only.

[SloJoe]

No, my research has nothing to do with previous bets but with win/lose conditions.
And yes, I believe computer games can be set to cheat, and probably are.

[SloJoe]

OK, now I have figured out how to get '0' to come up as a 'L' for lose in C3 from A3 with:

[SloJoe]

Alright!! I got it all squared away and this section of the spreadsheet is SWEET!!

Thanks for all the help, you guys are just great. I'll know where NOT to go when I need help in the future.

And oh, by the way, I have found something that gives me a greater statistical advantage. I just wanted something that I can test my system on that will give me a much larger test population more quickly.

TTFN

[martindwilson]

well blow me ,what do you expect this isnt an instant fix it service!
its just over 24 hrs since your first post and you're moaning?

So now my question is, how to merge these two into one function and get it to compare with B3 with L for lose and W for win in C3.?

compare how? what result would you expect

And oh, by the way, I have found something that gives me a greater statistical advantage

well you must be the casino owner then!

[shg]

SJ, I think no one understood your question (I got the roulette part, but nary a clue as to the Excel part). On a good day, some kind soul would start a round of 20 Questions to find out; on others, people will just find another thread that is clearly stated and answer that.

Don't let that dissuade you, though, from following your gambler's instinct and not allowing us the opportunity to not assist you again.

[zbor]

well you must be the casino owner then!

lol.....

[JBeaucaire]

No such thing as a statistical advantage if you're actually playing roulette. Statistics are an interesting and fun exercise for the math buffs. But when the wheel spins...every number has an equal chance to occur on every spin. There is no causal effect from one spin to the next....Regardless of what the statistical results are.

The idea that people can be fooled into thinking there is an effect is why Roulette wheels now have the "past 20 spins panel" displayed proudly at every table. People actually stand there and stare at it as if the information there was actually meaningful .

Result: more money for casino.

[SloJoe]

LOL, some of you guys are really funny! If you want to learn something, go take a look at what a man named Demming was able to accomplish in Japan with statistics. From what you have said you show that you have NO IDEA of what you are talking about. I already told you that what I am researching has NOTHING to do with going to a roulette table and attempting to bet based on past results. Well, I am not going to explain to you what SPC is, but I have seen it work wonders. Have fun stumbling in the dark.

[martindwilson]

nope ,you are missing the point
what was your specific excel question ?
i didnt understand what you were asking hence the quote in my first post
and i'm glad we brightened up your day with some witty banter

[darkyam]

All hail SloJoe, the man who has figured out how to predict random events! Can you tell me what the lottery numbers for this week are going to be?

SPC is used when you can actually control, influence, or at least accurately measure the process producing the results. You won't even have access to the precise conditions of the process. Things that are random, like how fast the croupier spins the wheel and precisely when he lets the ball go, will not be under your control and will not be known until it is too late. Also, it's Deming, not Demming.

[zbor]

Here:

http://www.roulette-cheat-guide.com/

However, I didn't test it and I don't know what it's about (it's just first google output), I share above opinion that you can't beat casino (and main reason why it's true is because they still exist ), and I don't promote gambling.

You want easy money? Don't gamble, become politician

[xladept]

"Liars, Damn Liars and Statisticians" - Mark Twain