Variable dutching calculator

[jt42cwrm]

Hello,

I am struggling to figure out how to go about this, perhaps someone can point me in the right direction?

I wish to create a variable dutching calculator whereby, instead of all the runners in the field generating the same profit, one can be weighted to more than the rest. For example, Mr Ed's return to be 200% of all the other runners, whilst the overall stake remains constant.

Here is my standard dutching calculator:-

Excel 2010
	A	B	C	D	E	F	G
1	Winner	Price	% chance	% stake	Stake	Gross earnings	Net earnings
2	Mr Ed	12.5	8.00%	45.37%	£ 3.18	£ 32.75	£ 31.11
3	Silver	65.0	1.54%	8.72%	£ 0.61	£ 32.65	£ 31.02
4	Trigger	30.0	3.33%	18.90%	£ 1.32	£ 32.60	£ 30.97
5	Quick Draw McGraw	21.0	4.76%	27.00%	£ 1.89	£ 32.69	£ 31.06
6
7	Total stake	£ 7.00
8	Commission	5%
Sheet1

Cell Formulas
Range	Formula
C2	=1/$B2
C3	=1/$B3
C4	=1/$B4
C5	=1/$B5
D2	=$C2/SUM($C$2:$C$5)
D3	=$C3/SUM($C$2:$C$5)
D4	=$C4/SUM($C$2:$C$5)
D5	=$C5/SUM($C$2:$C$5)
E2	=ROUND($D2*$B$7,2)
E3	=ROUND($D3*$B$7,2)
E4	=ROUND($D4*$B$7,2)
E5	=ROUND($D5*$B$7,2)
F2	=($E2*$B2)-SUM($E$2:$E$5)
F3	=($E3*$B3)-SUM($E$2:$E$5)
F4	=($E4*$B4)-SUM($E$2:$E$5)
F5	=($E5*$B5)-SUM($E$2:$E$5)
G2	=ROUND($F2-($F2*$B$8),2)
G3	=ROUND($F3-($F3*$B$8),2)
G4	=ROUND($F4-($F4*$B$8),2)
G5	=ROUND($F5-($F5*$B$8),2)

Can anyone give me any suggestions?

 

[shg]

Can't you just enter the horse twice?

 

[jt42cwrm]

That would increase my total stake, which I want to remain the same. Plus I might want to set the variable return on that one "horse" to anything, ranging from 0% to 500% the return on the other runners.

 

[shg]

See https://www.box.com/s/5pt3sgepeuoj8q42lp36

I differs from what you asked for in that you choose a base amount to win, and the weights multiply that, rather than specifying your stake.

For example,

       -------B------- -C- ---D---- ----E----- ---F----
   2                       To Win W  $50.00            
   3                                                   
   4   Mud in Your Eye Wgt Dec Odds    Bets      Pays  
   5   Mud in Your Eye   1      10     $ 11.99 $ 119.86
   6   Hooves of Steel   2       8     $ 21.23 $ 169.86
   7   Speeding Bullet   3       6     $ 36.64 $ 219.86
   8   Rein Me In                                      
   9   Go Bob Go                                       
  10                          0.392 Total Bets   Net   
  11                                   $ 69.86  $ 50.00

       -------B------- -C- ---D---- ----E----- ---F----
   2                       To Win W  $50.00            
   3                                                   
   4   Hooves of Steel Wgt Dec Odds    Bets      Pays  
   5   Mud in Your Eye   1      10     $ 11.99 $ 119.86
   6   Hooves of Steel   2       8     $ 21.23 $ 169.86
   7   Speeding Bullet   3       6     $ 36.64 $ 219.86
   8   Rein Me In                                      
   9   Go Bob Go                                       
  10                          0.392 Total Bets   Net   
  11                                   $ 69.86 $ 100.00

       -------B------- -C- ---D---- ----E----- ---F----
   2                       To Win W  $50.00            
   3                                                   
   4   Speeding Bullet Wgt Dec Odds    Bets      Pays  
   5   Mud in Your Eye   1      10     $ 11.99 $ 119.86
   6   Hooves of Steel   2       8     $ 21.23 $ 169.86
   7   Speeding Bullet   3       6     $ 36.64 $ 219.86
   8   Rein Me In                                      
   9   Go Bob Go                                       
  10                          0.392 Total Bets   Net   
  11                                   $ 69.86 $ 150.00

 

[shg]

I made a change so you can enter either the stake or the amount to win. Same link.

 

[jt42cwrm]

Wow shg, thanks!
I haven't seen or used any mathematical equations like those for over 20 years so my head hurt just looking at them.

It does the trick perfectly, cheers.

 

[shg]

You're welcome, good luck.

 

[flavoz]

Really like what you've achieved with the Variable Dutch Book. Is it possible to go a step further and provide for a "saver" bet, i.e., bet an amount to break even on the "saver" bet and enable an increase in the amounts bet on remaining selections?
Also, do you have any views on how to convert a Dutching spreadsheet to a stand alone program?

 

[brerus72]

Hi shg love the tool you've created

However, I have the same problem where I want to create a variable dutching calculator whereby, instead of all the runners in the field generating the same profit, one can be weighted to more than the rest.

I have not been able to access the link Box

I have the old thread Variable dutching calculator

If anyone else knows how I can create this variable dutching calculator please let me know

Thank you,

brerus72

 

[brerus72]

I made a change so you can enter either the stake or the amount to win. Same link.

I couldn't access the link where you can do this. Is there a way around it?