Hello, Im trying to prove to a friend that his roulette system doesnt work but I am lacking the excel skills to produce a model that will simulate the system.

The system is as follows

You write down the no's 01234 on a piece of paper. You add up the first and last digits of that string...so 4 in this case and bet four on either red or black. If you win you delete the first and last numbers of the string so it looks like this

123

if you lose you add the amount you bet to the string so it looks like this...you continue betting the sum of the first and last no's until you have won enough times to delete all of the numbers in the sequence

012344

you continue betting the sum of the first and last no's until you have won enough times to delete all of the numbers in the sequence


so a sequence would look like this

Start 01234
lose 012344
lose 0123444
win 12344
win 234
lose 2346
lose 23468
win 346
win 4
lose 44
win end of sequence

The other stipulation is that if you lose twice in a row then you stop betting until your colour comes up. ie if you're betting on red and black comes up twice, you spin the wheel without making a bet until red comes up again and you continue to bet

Im at a loss as to how I can simulate this on excel