Using Excel 2010
Hello,
European roulette has 37 numbers 1 to 36 + 0, betting strait on single number for example 2€ in case of wins it pays 35 times + returns the betting amount so far 70€ + 2€ =72€.
In case of placing 2€ bet on 5 different numbers bet amount will be 10€ in this case winning number will pay 72€ in case of loss will be -10€
For example roulette table has starting amount from min bet 0.20€, 0.50€, 1.00€, 2.00€, 5.00€, 10.00€, 50.00€, & max 100.00€
If I chose 5 numbers and place 2.00€ on each number total bet will be 10.00€.
Here is my question from which number of consecutive losing round I should….
1- Increase the bet amount
2- How much it should be till full amount recovered.
Please I need a VBA or formula help in the column B which can calculate incremented amount after every bet is losses and finally when it wins fully amount is covered within at least 30 consecutive losses.
Note: in the first 7 bets no need increment of amount because the pay-outs are more than 7 consecutive losses.
Here below is attached a sample sheet in which after a loss bet increment is calculated manually so far if any betting round bet is win it cover all the losses even till last 30th bet pass bet .
Thank you all.
Regards,
Moti
Hello,
European roulette has 37 numbers 1 to 36 + 0, betting strait on single number for example 2€ in case of wins it pays 35 times + returns the betting amount so far 70€ + 2€ =72€.
In case of placing 2€ bet on 5 different numbers bet amount will be 10€ in this case winning number will pay 72€ in case of loss will be -10€
For example roulette table has starting amount from min bet 0.20€, 0.50€, 1.00€, 2.00€, 5.00€, 10.00€, 50.00€, & max 100.00€
If I chose 5 numbers and place 2.00€ on each number total bet will be 10.00€.
Here is my question from which number of consecutive losing round I should….
1- Increase the bet amount
2- How much it should be till full amount recovered.
Please I need a VBA or formula help in the column B which can calculate incremented amount after every bet is losses and finally when it wins fully amount is covered within at least 30 consecutive losses.
Note: in the first 7 bets no need increment of amount because the pay-outs are more than 7 consecutive losses.
Here below is attached a sample sheet in which after a loss bet increment is calculated manually so far if any betting round bet is win it cover all the losses even till last 30th bet pass bet .
Recovery question.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Bett For nº | Bet Amount | Min Bet-> | 0,20 € | Total | ||||
2 | 5 | 2,00 € | Payout | Payout | Accumulated | ||||
3 | Betting | Total € | In Case | In Case | Win | Net | |||
4 | Rounds | 10,00 € | Of Win | Of No Win | Loss | Loss / Profit | |||
5 | 1 | 10,00 € | 72,00 € | -10,00 € | Loss | -10,00 € | |||
6 | 2 | 10,00 € | 72,00 € | -10,00 € | Loss | -20,00 € | |||
7 | 3 | 10,00 € | 72,00 € | -10,00 € | Loss | -30,00 € | |||
8 | 4 | 10,00 € | 72,00 € | -10,00 € | Loss | -40,00 € | |||
9 | 5 | 10,00 € | 72,00 € | -10,00 € | Loss | -50,00 € | |||
10 | 6 | 10,00 € | 72,00 € | -10,00 € | Loss | -60,00 € | |||
11 | 7 | 10,00 € | 72,00 € | -10,00 € | Loss | -70,00 € | |||
12 | 8 | 11,40 € | 82,08 € | -11,40 € | Loss | -81,40 € | |||
13 | 9 | 13,20 € | 95,04 € | -13,20 € | Loss | -94,60 € | |||
14 | 10 | 15,40 € | 110,88 € | -15,40 € | Loss | -110,00 € | |||
15 | 11 | 17,80 € | 128,16 € | -17,80 € | Loss | -127,80 € | |||
16 | 12 | 20,80 € | 149,76 € | -20,80 € | Loss | -148,60 € | |||
17 | 13 | 24,00 € | 172,80 € | -24,00 € | Loss | -172,60 € | |||
18 | 14 | 28,00 € | 201,60 € | -28,00 € | Loss | -200,60 € | |||
19 | 15 | 32,40 € | 233,28 € | -32,40 € | Loss | -233,00 € | |||
20 | 16 | 37,60 € | 270,72 € | -37,60 € | Loss | -270,60 € | |||
21 | 17 | 43,80 € | 315,36 € | -43,80 € | Loss | -314,40 € | |||
22 | 18 | 50,80 € | 365,76 € | -50,80 € | Loss | -365,20 € | |||
23 | 19 | 59,00 € | 424,80 € | -59,00 € | Loss | -424,20 € | |||
24 | 20 | 68,60 € | 493,92 € | -68,60 € | Loss | -492,80 € | |||
25 | 21 | 79,60 € | 573,12 € | -79,60 € | Loss | -572,40 € | |||
26 | 22 | 92,40 € | 665,28 € | -92,40 € | Loss | -664,80 € | |||
27 | 23 | 107,40 € | 773,28 € | -107,40 € | Loss | -772,20 € | |||
28 | 24 | 124,60 € | 897,12 € | -124,60 € | Loss | -896,80 € | |||
29 | 25 | 144,80 € | 1.042,56 € | -144,80 € | Loss | -1.041,60 € | |||
30 | 26 | 168,00 € | 1.209,60 € | -168,00 € | Loss | -1.209,60 € | |||
31 | 27 | 195,20 € | 1.405,44 € | -195,20 € | Loss | -1.404,80 € | |||
32 | 28 | 226,60 € | 1.631,52 € | -226,60 € | Loss | -1.631,40 € | |||
33 | 29 | 263,20 € | 1.895,04 € | -263,20 € | Loss | -1.894,60 € | |||
34 | 30 | 305,60 € | 2.200,32 € | -305,60 € | Win | 0,12 € | |||
35 | |||||||||
36 | |||||||||
37 | |||||||||
38 | |||||||||
Sheet1 |
Thank you all.
Regards,
Moti
Last edited: