Betting Permutations

[Wonderboy89]

Hey,

I am trying to come up with a calculator for working out returns on betting permutations.

I have the sheet worked out to calculate the number of bets, the stake of the bets, the number of winning bets using the inputs. What I can't work out is how to calculate the returns on the winning permutations. So for anything marked as either a W(in) or P(ush) the decimal returns should be multiplied together and also multiplied by the appropriate stake unit per bet type.

Any help would be appreciated.

 

[bobaol]

Hi Wonderboy89, can you post the data here? just copy and paste into here and it'll work fine. More importantly, can you provide two or three examples of your request based on the image above? For example, in cell D3 with the W, what calculation should be made? is it (W*P), that is, ((7.34*1*1*1*1*1*1*1*1*1)*10). a few examples would really help. cheers!

 

[Wonderboy89]

Hi Wonderboy89, can you post the data here? just copy and paste into here and it'll work fine. More importantly, can you provide two or three examples of your request based on the image above? For example, in cell D3 with the W, what calculation should be made? is it (W*P), that is, ((7.34*1*1*1*1*1*1*1*1*1)*10). a few examples would really help. cheers!

Prices

Decimal Return

W/L/P

Selections

Bet Type

Number of bets

Stake unit per bet type

Total Stake per bet type

Number of winning bets

Returns

Profit

7.34

7.34

w

12​

Singles

1​

12​

10​

120​

10​

163.40​

43.40​

7.4

1

p

doubles

2​

66​

0.5​

33​

45​

1.2

0

l

trebles

3​

220​

0.5​

110​

120​

2.55

1

p

4 folds

4​

495​

0.5​

247.5​

210​

6.5

0

l

5 folds

5​

792​

0.5​

396​

252​

2

1

p

6 folds

6​

924​

0.5​

462​

210​

2

1

p

7 folds

7​

792​

0.5​

396​

120​

2

1

p

8 folds

8​

495​

0.5​

247.5​

45​

2

1

p

9 folds

9​

220​

0.5​

110​

10​

2

1

p

10 folds

10​

66​

0.5​

33​

1​

2

1

p

11 folds

11​

12​

0.5​

6​

#NUM!​

2

1

p

12 folds

12​

1​

0.5​

0.5​

#NUM!​

0

13 folds

13​

0​

0.5​

0​

#NUM!​

0

14 folds

14​

0​

0.5​

0​

#NUM!​

0

15 folds

15​

0​

0.5​

0​

#NUM!​

0

16 folds

16​

0​

0.5​

0​

#NUM!​

0

17 folds

17​

0​

0.5​

0​

#NUM!​

0

18 folds

18​

0​

0.5​

0​

#NUM!​

Total Stake

number of W or P

2161.5​

10

For cell T4 the calculation is all the possible combinations of 2 W's and P's decimal Return multiplied together and also multiplied by M4. So for example (C3*C4*M4)+(C3*C6*M4)+(C3*C8*M4) + all other combinations of 2 W's and P's (Should be 45 combinations in this example). Then for T5 it is all possible combinations of 3 W's and P's multiplied together multiplied by M5. So for example (C3*C4*C6*M5)+(C3*C4*C8*M5) + all other combinations of 3 W's and P's (should be 120 combinations in this example). This continues looking for all the combinations of the number shown in column J.

 

[bobaol]

Hi, I am not getting it. Would you please give the full example for T4 with the 45 combinations? and also for T5 the example for 120 combinations? What should be the answer for T4 and T5? What is the combination for T3? I think this is doable, with a ton of if-then statements, or using a macro to calculate one row at a time. In your example for T4, C3 is constant because of W. M4 is constant regardless if W, P, or L. But I don't understand how the 45 bet combinations or 120 bet combinations should be applied. Also, do you want to show your exact detailed work for T5 and T6? What should be the answer for T5 and T6? If you could post the exact formulas for T3, T4, T5, T6 then I might be able to understand your work. for now, this is all I have, but it's probably wrong. Cheers!

		sum in T4	33.03​
c3	c4	m4	multiplied
7.34​	1​	0.5​	3.67​
c3	c6	m4	multiplied
7.34​	1​	0.5​	3.67​
c3	c8	m4	multiplied
7.34​	1​	0.5​	3.67​
c3	c9	m4	multiplied
7.34​	1​	0.5​	3.67​
c3	c10	m4	multiplied
7.34​	1​	0.5​	3.67​
c3	c11	m4	multiplied
7.34​	1​	0.5​	3.67​
c3	c12	m4	multiplied
7.34​	1​	0.5​	3.67​
c3	c13	m4	multiplied
7.34​	1​	0.5​	3.67​
c3	c14	m4	multiplied
7.34​	1​	0.5​	3.67​