I have a list of conditions/criteria/filters for horse racing strategies. I have each type put into separate groups and what I'm trying to do is, in Excel, produce lists of all the possible combinations containing ONE from each group below. Can this be done in Excel or would I need something else? Here's what I have. As you can see, I have separated each group with a line:
----------------------------------------------
Can be maiden race *
Not maiden race
--------------------------------------------
Number of horses 8 to 13 *
Number of horses 8 to 12
Number of horses 8 to 11
Number of horses 8 to 10
Number of horses 8 to 9
Number of horses 8 to 8
----------------------------------------------
ONLY gallop races *
ONLY harness races
BOTH gallop races AND harness races
---------------------------------------------------
Track condition exactly the same as last race *
Track condition similar to or exactly what it was last race
Track condition can be completely different to what it was like last race (can be in any condition)
---------------------------------------------------------------
Last race of favourite was 21 days or less ago *
Last race of favourite was 20 days or less ago
Last race of favourite was 19 days or less ago
Last race of favourite was 18 days or less ago
Last race of favourite was 17 days or less ago
Last race of favourite was 16 days or less ago
Last race of favourite was 15 days or less ago
Last race of favourite was 14 days or less ago
Last race of favourite was 13 days or less ago
Last race of favourite was 12 days or less ago
Last race of favourite was 11 days or less ago
Last race of favourite was 10 days or less ago
Last race of favourite was 9 days or less ago
Last race of favourite was 8 days or less ago
Last race of favourite was 7 days or less ago
Last race of favourite was 6 days or less ago
Last race of favourite was 5 days or less ago
Last race of favourite was 4 days or less ago
Last race of favourite was 3 days or less ago
Last race of favourite was 2 days or less ago
Last race of favourite was 1 day ago (yesterday)
--------------------------------------------------------
Can have an apprentice jockey *
Doesn't have an apprentice jockey
-----------------------------------------------------------
Carrying the exact same weight as last race *
Carrying up to 1kg more than last race
Carrying up to 2kg more than last race
Carrying up to 3kg more than last race
Carrying up to 4kg more than last race
Carrying up to 5kg more than last race
Carrying up to 6kg more than last race
Carrying up to 7kg more than last race
Carrying up to 8kg more than last race
Carrying up to 9kg more than last race
Carrying up to 10kg more than last race
Carrying up to 1kg less than last race
Carrying up to 2kg less than last race
Carrying up to 3kg less than last race
Carrying up to 4kg less than last race
Carrying up to 5kg less than last race
Carrying up to 6kg less than last race
Carrying up to 7kg less than last race
Carrying up to 8kg less than last race
Carrying up to 9kg less than last race
Carrying up to 10kg less than last race
---------------------------------------------------
Open race *
Closed race
----------------------------------------------
Favourite came 1st, 2nd or 3rd in it's last race *
Favourite came 1st or 2nd in it's last race
Favourite came only 1st in it's last race
-----------------------------------------------------------
If favourite came 2nd or 3rd in last race, must've finished within 2 lenths of the winner. *
If favourite came 2nd or 3rd in last race, must've finished within 1.9 lenths of the winner.
If favourite came 2nd or 3rd in last race, must've finished within 1.8 lenths of the winner.
If favourite came 2nd or 3rd in last race, must've finished within 1.7 lenths of the winner.
If favourite came 2nd or 3rd in last race, must've finished within 1.6 lenths of the winner.
If favourite came 2nd or 3rd in last race, must've finished within 1.5 lenths of the winner.
If favourite came 2nd or 3rd in last race, must've finished within 1.4 lenths of the winner.
If favourite came 2nd or 3rd in last race, must've finished within 1.3 lenths of the winner.
If favourite came 2nd or 3rd in last race, must've finished within 1.2 lenths of the winner.
If favourite came 2nd or 3rd in last race, must've finished within 1.1 lenths of the winner.
If favourite came 2nd or 3rd in last race, must've finished within 1 lenths of the winner.
If favourite came 2nd or 3rd in last race, must've finished within 0.9 lenths of the winner.
If favourite came 2nd or 3rd in last race, must've finished within 0.8 lenths of the winner.
If favourite came 2nd or 3rd in last race, must've finished within 0.7 lenths of the winner.
If favourite came 2nd or 3rd in last race, must've finished within 0.6 lenths of the winner.
If favourite came 2nd or 3rd in last race, must've finished within 0.5 lenths of the winner.
If favourite came 2nd or 3rd in last race, must've finished within 0.4 lenths of the winner.
If favourite came 2nd or 3rd in last race, must've finished within 0.3 lenths of the winner.
If favourite came 2nd or 3rd in last race, must've finished within 0.2 lenths of the winner.
If favourite came 2nd or 3rd in last race, must've finished within 0.1 lenths of the winner.
------------------------------------------------------------
Track has to be the exact same length as favourite's last race *
Track shouldn't be anymore than 300 meters longer than favourite's last race
Track shouldn't be anymore than 290 meters longer than favourite's last race
Track shouldn't be anymore than 280 meters longer than favourite's last race
Track shouldn't be anymore than 270 meters longer than favourite's last race
Track shouldn't be anymore than 260 meters longer than favourite's last race
Track shouldn't be anymore than 250 meters longer than favourite's last race
Track shouldn't be anymore than 240 meters longer than favourite's last race
Track shouldn't be anymore than 230 meters longer than favourite's last race
Track shouldn't be anymore than 220 meters longer than favourite's last race
Track shouldn't be anymore than 210 meters longer than favourite's last race
Track shouldn't be anymore than 200 meters longer than favourite's last race
Track shouldn't be anymore than 190 meters longer than favourite's last race
Track shouldn't be anymore than 180 meters longer than favourite's last race
Track shouldn't be anymore than 170 meters longer than favourite's last race
Track shouldn't be anymore than 160 meters longer than favourite's last race
Track shouldn't be anymore than 150 meters longer than favourite's last race
Track shouldn't be anymore than 140 meters longer than favourite's last race
Track shouldn't be anymore than 130 meters longer than favourite's last race
Track shouldn't be anymore than 120 meters longer than favourite's last race
Track shouldn't be anymore than 110 meters longer than favourite's last race
Track shouldn't be anymore than 100 meters longer than favourite's last race
Track shouldn't be anymore than 90 meters longer than favourite's last race
Track shouldn't be anymore than 80 meters longer than favourite's last race
Track shouldn't be anymore than 70 meters longer than favourite's last race
Track shouldn't be anymore than 60 meters longer than favourite's last race
Track shouldn't be anymore than 50 meters longer than favourite's last race
Track shouldn't be anymore than 40 meters longer than favourite's last race
Track shouldn't be anymore than 30 meters longer than favourite's last race
Track shouldn't be anymore than 20 meters longer than favourite's last race
Track shouldn't be anymore than 10 meters longer than favourite's last race
Track shouldn't be anymore than 300 meters shorter than favourite's last race
Track shouldn't be anymore than 290 meters shorter than favourite's last race
Track shouldn't be anymore than 280 meters shorter than favourite's last race
Track shouldn't be anymore than 270 meters shorter than favourite's last race
Track shouldn't be anymore than 260 meters shorter than favourite's last race
Track shouldn't be anymore than 250 meters shorter than favourite's last race
Track shouldn't be anymore than 240 meters shorter than favourite's last race
Track shouldn't be anymore than 230 meters shorter than favourite's last race
Track shouldn't be anymore than 220 meters shorter than favourite's last race
Track shouldn't be anymore than 210 meters shorter than favourite's last race
Track shouldn't be anymore than 200 meters shorter than favourite's last race
Track shouldn't be anymore than 190 meters shorter than favourite's last race
Track shouldn't be anymore than 180 meters shorter than favourite's last race
Track shouldn't be anymore than 170 meters shorter than favourite's last race
Track shouldn't be anymore than 160 meters shorter than favourite's last race
Track shouldn't be anymore than 150 meters shorter than favourite's last race
Track shouldn't be anymore than 140 meters shorter than favourite's last race
Track shouldn't be anymore than 130 meters shorter than favourite's last race
Track shouldn't be anymore than 120 meters shorter than favourite's last race
Track shouldn't be anymore than 110 meters shorter than favourite's last race
Track shouldn't be anymore than 100 meters shorter than favourite's last race
Track shouldn't be anymore than 90 meters shorter than favourite's last race
Track shouldn't be anymore than 80 meters shorter than favourite's last race
Track shouldn't be anymore than 70 meters shorter than favourite's last race
Track shouldn't be anymore than 60 meters shorter than favourite's last race
Track shouldn't be anymore than 50 meters shorter than favourite's last race
Track shouldn't be anymore than 40 meters shorter than favourite's last race
Track shouldn't be anymore than 30 meters shorter than favourite's last race
Track shouldn't be anymore than 20 meters shorter than favourite's last race
Track shouldn't be anymore than 10 meters shorter than favourite's last race
-----------------------------------------------------------------
So, one example would be like this:
Not maiden race
Number of horses 8 to 11
ONLY harness races
Track condition similar to or exactly what it was last race
Last race of favourite was 15 days or less ago
Doesn't have an apprentice jockey
Carrying up to 6kg more than last race
Closed race
Favourite came 1st or 2nd in it's last race
If favourite came 2nd or 3rd in last race, must've finished within 1 lenths of the winner.
Track shouldn't be anymore than 300 meters longer than favourite's last race
-----------------------------------------------------------------------------------
Bookmarks