+ Reply to Thread
Results 1 to 4 of 4

Scheduling

  1. #1
    Registered User
    Join Date
    08-01-2008
    Location
    ST. Louis
    Posts
    15

    Scheduling

    Ok I have been trying to find some software that will help me with this, but the average price is $100 and I don't want to spend that kind of money if I don't know if it will work.

    What I am trying to do is create a schedule for a 20 team fantasy baseball league.

    We have 4 divisions of 5 with a 21 weekly match ups.

    The divisions are as such:
    Cyan: Team 1, Team 2, Team 3, Team 4, Team 5
    Magenta: Team 6, Team 7, Team 8, Team 9, Team 10
    Yellow: Team 11, Team 12, Team 13, Team 14, Team 15
    Black: Team 16, Team 17, Team 18, Team 19, Team 20

    Each team will play the teams in their division twice, and the rest of the schedule is filled in with non divisional teams that you won't play more than once.

    I don't know if anyone can help with this, but every time I have had a problem that I couldn't figure out in Excel someone here has been able to help.

  2. #2
    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: Scheduling

    I don't understand...

    If you have 20 teams and they each play weekly, that's 10 games per week.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    08-01-2008
    Location
    ST. Louis
    Posts
    15

    Re: Scheduling

    What I want Excel to do is tell me who plays who what week. I can do this manually, but I thought that maybe Excel could do it for me. With 5 teams in each division they will play each other 2 times each, that leaves 13 games that each team will play outside the division. I was hoping, and it may not be possible, to have Excel randomize the schedule so that each team plays its division foes twice and an assortment of non divisional foes once. I am getting the feeling that this is going to be a manual process, but I wanted to check to see if any of the people here have experience with scheduling in Excel. If no one can help I understand, as I have been staring at a spreadsheet for over an hour with no luck.

  4. #4
    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: Scheduling

    Does this do what you want? It's two rounds of a round-robin for an odd number of teams, and the byes are non-divisional games.
    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)

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