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 