+ Reply to Thread
Results 1 to 6 of 6

Fixture Generator

  1. #1
    Registered User
    Join Date
    02-08-2010
    Location
    Wellington, New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    3

    Exclamation Fixture Generator

    I'm looking for a Macro/Algorithm/anything? to take a set of fixtures and create a round robin draw for varying numbers of teams and rounds.

    The idea is for it to take each game and put it into a round so that each team only appears once in that round.
    ie it starts with a list of games -
    1v2,1v3,1v4, 2v3,2v4, 3v4

    It sorts them (randomly?) into
    Round 1 1v2, 3v4
    Round 2 1v4, 2v3
    Round 3 1v3, 2v4

    It doesn't need to create each game as we alrady have something for that.
    What we want to be able to do is take an uncompleted competition draw and recreate the draw less the games that have been played.

    Tony M.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Fixture Generator

    try this not excel but does the trick
    http://www.teamopolis.com/tools/roun...generator.aspx
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Fixture Generator

    Maybe like this. Change the value in B2.
    Attached Files Attached Files
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    02-08-2010
    Location
    Wellington, New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Fixture Generator

    Thanks Martin and SHG.
    What if after 3 rounds I need to completely redo the draw using only the remaining unplayed matches?

    It would need to be a bit more complicated than the 2 you have suggested.
    It would probably want to know what to do with the left over games if they didn't fit into a round

    Any suggestions?
    Last edited by SportZone; 02-09-2010 at 10:36 PM.

  5. #5
    Registered User
    Join Date
    02-08-2010
    Location
    Wellington, New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Fixture Generator

    Hi Team,

    I'm still looking for a solution to this problem. My previous query probably showed the problem too simply so I'll have another go.

    What I'm trying to solve is this -

    I have X number of teams in a round robin format league.

    A few rounds are played and then changes are made to the structure so teams may be removed or teams may be added.

    This means we'll need to regenerate the fixtures and rounds taking into account games that have been played and new games created and added to the league.
    To do this manually I take all teams now in the grade and generate a new set of fixtures.

    I remove any games that have already been played and show them as completed rounds.

    I then re-sort the remaining games into each round where each team appears once per round.

    Any games that can not fit into a round are grouped together at the end.

    Any ideas?

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,856

    Re: Fixture Generator

    Welcome back!

    Please update your forum profile with your current version of Excel.

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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