dutching bets - help!

[amoreira70]

hi there!

on image below you see a dutching calculator used for betting
I need the value 50€ to be distributed (based on the odds) to the bets (3 at image) so that the sum of values is equal to 50€ and all the odds multiplied for its valor result always in same value like on image 2 x 15 = 30; 6 x 5 = 30 etc

take in consideration that the higher the odd the lower the valor

can you please help me find a solution?

thanks

 

[pgc01]

Hmm. I think the first instance of Odds returns a single value via an implicit intersection -- no?

Calculating the sum of the reciprocals in every line is certainly redundant; were there not so few, I'd put it in a separate cell.

Yes, I agree with you on both,

calculating the sum of the reciprocals in every line is redundant, but that's not a problem here and, as you said, if it was you could always use an auxiliary cell to the the sum,

and it will use an implicit intersection and so it will work if entered in the correct row.

I guess it's just a case of personal preference, I don't like to use on 1 cell a formula that returns an array.

 

[amoreira70]

thanks a lot
used your file and adapted it to my needs

case closed

The workbook at the link does that. Using your example,
[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[TD]

F​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]

Stake​

[/TD]
[TD]

$ 50.00​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]

To Win​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]

Win​

[/TD]
[TD]

($ 20.00)​

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD]

Winner​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

8​

[/TD]
[TD]Aposta 1[/TD]
[TD]

Wgt​

[/TD]
[TD]

Dec Odds​

[/TD]
[TD]

Bets​

[/TD]
[TD]

Pays​

[/TD]
[/TR]
[TR]
[TD]

9​

[/TD]
[TD]Aposta 1[/TD]
[TD]

1​

[/TD]
[TD]

2​

[/TD]
[TD]

$ 15.00​

[/TD]
[TD]

$ 30.00​

[/TD]
[/TR]
[TR]
[TD]

10​

[/TD]
[TD]Aposta 2[/TD]
[TD]

1​

[/TD]
[TD]

6​

[/TD]
[TD]

$ 5.00​

[/TD]
[TD]

$ 30.00​

[/TD]
[/TR]
[TR]
[TD]

11​

[/TD]
[TD]Aposta 3[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

$ 30.00​

[/TD]
[TD]

$ 30.00​

[/TD]
[/TR]
[TR]
[TD]

12​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

13​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

14​

[/TD]
[TD][/TD]
[TD]

**F​

[/TD]
[TD]

(2.500)​

[/TD]
[TD]

Total Bets​

[/TD]
[TD]

Net​

[/TD]
[/TR]
[TR]
[TD]

15​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

$ 50.00 ​

[/TD]
[TD]

($ 20.00)​

[/TD]
[/TR]
</tbody>[/TABLE]

 

[shg]

You're welcome.

I added a sheet that has your simplified scheme -- same link.