Testing a system

[753951]

Is there any way you can test a system for roulette?

I have something I'd like to try but can't really be bothered to sit and click constantly at some online casino. I just want to see how my system would after after, for example 1,000 spins.

Can it be done on a spreadsheet.. And if so does anybody know how?

Thanks for any help,

753951

[alexross1977]

are u a bot?

[753951]

Err... No :P

I think I've worked out a way to do it on Excel. Now I just need help with IF statements... Anybody any good on Excel?

[Scott]

cant be assed to load it my self and check but you will want a cell forumula something very much like

=Randomize Time_ RND(1)*36

[753951]

Thanks, I have actually generated some random numbers but now just need help with an IF statement.

I have my numbers like this -

1
34
0
3
18
etc
etc

and want an IF statement that will display IF Awhatever=1, 3, 7, etc then display "-5" but with my bets there are 4 possible outcomes and include different number ranges. Do I even need an IF statement? Or am I making this too hard for myself.. Is there a program (Preferably for free) that allows you to test roulette systems. Actually, even a roulette wheel that just displays the numebr rather than spinning for ages and then bouncing around would do.

[geoff365]

Yes, RX.

[Scott]

quickest way to analsye numbers like this is with excel..

However you are completly wasting your time, your system does not, nor will it it ever, work.

[753951]

I know I know, you can't beat roulette. I just wanna try it out.

I can't seem to find GX, do you have a link?

Thanks.

[KasinoKing]

Thanks, I have actually generated some random numbers but now just need help with an IF statement.

I have my numbers like this -

1
34
0
3
18
etc
etc

and want an IF statement that will display IF Awhatever=1, 3, 7, etc then display "-5" but with my bets there are 4 possible outcomes and include different number ranges. Do I even need an IF statement? Or am I making this too hard for myself.. Is there a program (Preferably for free) that allows you to test roulette systems. Actually, even a roulette wheel that just displays the number rather than spinning for ages and then bouncing around would do.

I've done quite a bit of roulette system testing with Excel (and proved none of them work ) and the 'IF' function is what you need to use.

For example, I was looking at betting on the groups of 12 numbers Lo-Med-Hi, so I had the random number going down column A, and then formulas like this in columns C, D & E:
=IF(AND(A5>0,A5<13),"X","")
This puts an 'X' in column B if the number is between 1 & 12.

Then, further across I did more columns like this:-
=IF(C5="X",0,H4+1)
This adds up the number of times the same group does not hit in a row - it resets to zero once the selection hits again.
(Example below).

Once you master this function, it is quite simple to add extra columns to analyse the data further, or in a different way, or 'experiment' with different betting patterns.

In this particular example, you can see the the 'Lo 12' hits twice, then doesn't hit for 11 spins before it hits again...

[Scott]

make sure your numbers are random else you will see patterns and prolly see the same results if you started from scratch and get all excited.

I cant recall what RAND uses to seed but I know VB's RND fucntion was notorious for giving the exact same sequence every time suggesting it didnt even use something as basic as the time.