Hi

It looks a Great Site going here and I found it by accident and looks Very useful too.

I hope someone can help me here.

I have managed to create a way of finding Winners (and that of course is Very Exciting ) on the Horses front and need to use these Winners in Mixed Win Doubles, Trebles, Four Folds & Five Folds.
These Mixed Win Doubles, Trebles, Four Folds & Five Folds are different kinds of bets.

I have 2 Objectives. * For each Objective it would be great to have a handy Calculator to work it out each time.

Objective 1 - is to work out How Many Bets I have in Total for Win Doubles, Trebles, Four Folds & Five Folds
Objective 2 - is to work out the Profit & Loss for these bets preferably in an Excel sheet

* I know it is all about Numbers & the Formulas behind this - but I'm afraid I get a little lost at this point

Let's begin with Objective 1

First - let me give you what Doubles & Trebles & Four Folds & Five Folds mean:-
Double = 2 selections combined to form 1 bet from different races
Treble = 3 selections combined to form 1 bet from different races
Four Fold = 4 selections combined to form 1 bet from different races
Five Fold = 5 selections combined to form 1 bet from different races


Let us say we have 5 Races
Each race contains 3 horses

e.g.
Race 1 , Race 2, race 3, race 4 & race 5
Each race has 3 selections

e.g.
Race 1 = A, B, & C selections
Race 2 = D, E & F selections
Race 3 = G, H & I selections
Race 4 = J, K & L selections
Race 5 = M, N & O selections

Now the aim is to find out HOW Many Doubles, Trebles, Four Folds & Five Folds can I get from these 15 selections
and 5 races in Total...?

Of course - this is 5 races. Some days we may only have 4 races or even 3 races only.
So - depending on How many races we have, we have to work it the number of bets out again.

Here is an example of a Win Double from 2 races - aim is to trap just ONE Winning Double form these 2 races.

Race 1 = A, B & C selections
Race 2 = D, E & F selections

I can ONLY have ONE Winning Double from these 2 races.

However - the number of Bets I have are 9 in these 3 races

Here are the selections as would be in bets = AD, AE, AF, BD, BE, BF, CD, CE & CF
So - in this example I can get 9 possible bets BUT ONLY 1 Winning Double because ONLY 1 horse can win from 1 race & when you combine 2 winning horses from 2 races it forms 1 winning double.

The reason why you are combining this way is because you are covering ALL selections for any eventuality.
It doesn't matter if A wins, or B or C wins in the 1st race & it doesn't matter if D, E or F wins in the 2nd race - IF 1 wins from any of these selections in each race, you have a Winning Double.

* Have to say at this point - you cannot get a Treble from 2 races because a Treble consists of 3 horses which means you have to have a Minimum of 3 races

* Same with 4 Folds - you have to have a Minimum of 4 races & with 5 Folds = 5 Races minimum.

But now - this gets more complicated as we start to include 3 races or 4 races or 5 races, and then if you add in How many Trebles & 4 Folds & 5 Folds then yes the Number of Bets will shoot up dramatically, hence a handy auto calculator will be very handy or something in an Excel sheet that works it out quickly.

In trying to work out the Number of Trebles - it is the same as above except you have to have a Minimum of 3 races - could be more than 3 races but NEVER less than 3 races.

I know it appears complicated reading it - but it can be unravelled.

Can you please help me put on how to work out the number of bets with different scenarios..?

If you need any more information - or any explaining - I will provide it and no problems.

Obviously there are formulas to work these things out but be good to have them in an Excel sheet.

Anyway - please ask if there is anything that you don't understand or want to know more...

Thank You

xfan