# Variable dutching calculator

#### jt42cwrm

##### New Member
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:-

Can anyone give me any suggestions?

Last edited:

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

#### shg

##### MrExcel MVP
Can't you just enter the horse twice?

#### jt42cwrm

##### New Member
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

##### MrExcel MVP
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,

Code:
``````       -------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``````

Code:
``````       -------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``````

Code:
``````       -------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

##### MrExcel MVP

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

#### jt42cwrm

##### New Member
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

##### MrExcel MVP
You're welcome, good luck.

#### flavoz

##### New Member
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?

Replies
2
Views
289
Replies
0
Views
335
Replies
9
Views
454
Replies
6
Views
580
Replies
22
Views
539

1,148,397
Messages
5,746,460
Members
424,020
Latest member
LongDoo

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back