+ Reply to Thread
Results 1 to 2 of 2

Generating all possible combinations from my list?

  1. #1
    Registered User
    Join Date
    10-24-2020
    Location
    New Zealand
    MS-Off Ver
    2019
    Posts
    16

    Generating all possible combinations from my list?

    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

    -----------------------------------------------------------------------------------

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Generating all possible combinations from my list?

    your post was extremely long, and I did not read it all, however just based on your title, I wonder if you could modify the code in the attached files to suit your needs?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Generating Combinations
    By kiprotich in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2020, 11:23 AM
  2. Generating a list of combinations
    By tomhardy1491 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2015, 11:29 PM
  3. [SOLVED] Generating full list of scenarios (or combinations) of data in columns
    By cparker347 in forum Excel General
    Replies: 6
    Last Post: 07-28-2015, 10:28 AM
  4. generating all possible combinations
    By tuckertuesday in forum Excel General
    Replies: 3
    Last Post: 12-10-2014, 06:24 PM
  5. [SOLVED] Generating a List of Possible Permutation Combinations
    By glennchung in forum Excel General
    Replies: 3
    Last Post: 05-12-2014, 06:39 PM
  6. generating combinations
    By fern4500 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-11-2012, 08:47 AM
  7. Help generating combinations
    By JamRock in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-02-2006, 03:40 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1