Closed Thread
Results 1 to 7 of 7

schedule generator

  1. #1
    Registered User
    Join Date
    09-02-2012
    Location
    Maryland
    MS-Off Ver
    Excel 2003
    Posts
    1

    schedule generator

    Right now I have a sports league with 12 teams that will play for 13 weeks. I'd like to set up league schedule where each team plays each other at least once. Is there something that can help me?

  2. #2
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: schedule generator

    Over 11 weeks it would be as below. Don't know what you would want to do for the extra 2 weeks
    .
    ROUND 1 FIXTURES
    TEAM 2 v TEAM 1
    TEAM 8 v TEAM 6
    TEAM 9 v TEAM 5
    TEAM 10 v TEAM 4
    TEAM 11 v TEAM 3
    TEAM 12 v TEAM 7

    ROUND 2 FIXTURES
    TEAM 3 v TEAM 1
    TEAM 8 v TEAM 7
    TEAM 9 v TEAM 6
    TEAM 10 v TEAM 5
    TEAM 11 v TEAM 4
    TEAM 12 v TEAM 2

    ROUND 3 FIXTURES
    TEAM 3 v TEAM 2
    TEAM 4 v TEAM 1
    TEAM 9 v TEAM 7
    TEAM 10 v TEAM 6
    TEAM 11 v TEAM 5
    TEAM 12 v TEAM 8

    ROUND 4 FIXTURES
    TEAM 4 v TEAM 2
    TEAM 5 v TEAM 1
    TEAM 9 v TEAM 8
    TEAM 10 v TEAM 7
    TEAM 11 v TEAM 6
    TEAM 12 v TEAM 3

    ROUND 5 FIXTURES
    TEAM 4 v TEAM 3
    TEAM 5 v TEAM 2
    TEAM 6 v TEAM 1
    TEAM 10 v TEAM 8
    TEAM 11 v TEAM 7
    TEAM 12 v TEAM 9

    ROUND 6 FIXTURES
    TEAM 5 v TEAM 3
    TEAM 6 v TEAM 2
    TEAM 7 v TEAM 1
    TEAM 10 v TEAM 9
    TEAM 11 v TEAM 8
    TEAM 12 v TEAM 4

    ROUND 7 FIXTURES
    TEAM 5 v TEAM 4
    TEAM 6 v TEAM 3
    TEAM 7 v TEAM 2
    TEAM 8 v TEAM 1
    TEAM 11 v TEAM 9
    TEAM 12 v TEAM 10

    ROUND 8 FIXTURES
    TEAM 6 v TEAM 4
    TEAM 7 v TEAM 3
    TEAM 8 v TEAM 2
    TEAM 9 v TEAM 1
    TEAM 11 v TEAM 10
    TEAM 12 v TEAM 5

    ROUND 9 FIXTURES
    TEAM 6 v TEAM 5
    TEAM 7 v TEAM 4
    TEAM 8 v TEAM 3
    TEAM 9 v TEAM 2
    TEAM 10 v TEAM 1
    TEAM 12 v TEAM 11

    ROUND 10 FIXTURES
    TEAM 7 v TEAM 5
    TEAM 8 v TEAM 4
    TEAM 9 v TEAM 3
    TEAM 10 v TEAM 2
    TEAM 11 v TEAM 1
    TEAM 12 v TEAM 6

    ROUND 11 FIXTURES
    TEAM 7 v TEAM 6
    TEAM 8 v TEAM 5
    TEAM 9 v TEAM 4
    TEAM 10 v TEAM 3
    TEAM 11 v TEAM 2
    TEAM 12 v TEAM 1
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

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

    Re: schedule generator

    There's a workbook that does round-robin scheduling at https://www.box.com/s/z41sn0yrp5lo1cuozke3

    As WasWodge says, you can repeat any of the first 11 rounds for the last two.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: schedule generator

    I use Cad Delworth's fixture list generator for a few leagues at work. The advantage is you can type the names straight in.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-23-2012
    Location
    Lakewood,Wisconsin
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: schedule generator

    Hey Thanks a lot for the schedule generator. I needed a something for our Bar Pool League, works great. THANKS!

  6. #6
    Registered User
    Join Date
    04-12-2017
    Location
    Montreal
    MS-Off Ver
    2016
    Posts
    16

    Re: schedule generator

    hello
    im runing a darts league and wondering how to do a schedule
    we use 7 boards and we play twice each tuesday and we will play 4 to 6 times each teams
    can any one help me create a schedule with random board also

    thanks

  7. #7
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: schedule generator

    @kerm007
    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

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

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