+ Reply to Thread
Results 1 to 10 of 10

Excel round robin league scheduler

  1. #1
    Forum Contributor
    Join Date
    04-21-2010
    Location
    Canada
    MS-Off Ver
    Office 2013
    Posts
    120

    Post Excel round robin league scheduler

    Thanks to the help I got on these forums over the past week and a bit, I was able to put together a dynamic(up to 20 teams) single round robin league scheduler. On Sheet 1 enter your teams. If there are an uneven amount of teams, it will create a BYE slot.

    The matchups page will set up the matchups for each round, and is set to print 2 rounds per page. You can also enter scores for the matchups here and it will track win/loss/ties.

    The standings page will list the win/loss/ties stats (horizontally) for each team, and award points base on you setting the value (below the table) for wins/losses/ties.

    This is pretty much the first complete working draft, with no polish what so ever. Feel free to take it and use it to your heart's content.

    What I would like to know is if this doesn't seem useful as it is (I know the interface is not very user friendly right now...) what might it need to make it better? Thanks in advance for the feedback.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-28-2012
    Location
    Kansas
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Excel round robin league scheduler

    This is awesome!!

    It is so close to what I need. I am looking at your formulas trying to decipher. I am getting better at excel but not anywhere near this level.

    After I enter names on the 1st page. I just need the matchup to be listed in one column on another sheet. Instead of it being fancy with 1 vs. 2 in one cell. I would like 1 in cell B1. 2 in cell B2 on so forth down the page. This would allow me to copy the column into my backet spreadsheet that I have already made.

    Think you can help with that.

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO200;Win10/MSO2016
    Posts
    10,273

    Re: Excel round robin league scheduler

    markhallum, Welcome to the Forum, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
    Ben Van Johnson

  4. #4
    Registered User
    Join Date
    06-10-2015
    Location
    The Woodlands, TX
    MS-Off Ver
    LibreOffice
    Posts
    1

    Re: Excel round robin league scheduler

    This looked like exactly what I needed. Thanks!
    Last edited by gaulgr; 06-10-2015 at 11:55 PM.

  5. #5
    Registered User
    Join Date
    01-12-2016
    Location
    Oulainen, Finland
    MS-Off Ver
    2013
    Posts
    1

    Re: Excel round robin league scheduler

    Thanks! TeamScheduler4 is excellent!

  6. #6
    Registered User
    Join Date
    02-11-2016
    Location
    jakarta
    MS-Off Ver
    2010
    Posts
    1

    Re: Excel round robin league scheduler

    thanks alot, this is what i've been looking for

  7. #7
    Registered User
    Join Date
    06-27-2011
    Location
    AU
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Excel round robin league scheduler

    can TeamScheduler4 do alternating Home and Away, as in week 1 Team one is home and week two team one is away

  8. #8
    Registered User
    Join Date
    03-14-2016
    Location
    Wilmington, NC
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Excel round robin league scheduler

    I would really like to use this scheduler, could you help me customize it so that it fit my needs

  9. #9
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2016 & 365 but use also older versions
    Posts
    6,490

    Re: Excel round robin league scheduler

    Hi barnbogen,

    Have you seen post #3 - the same applies to you.

    As additional reading, I'd suggest this not_so_old thread on our forum: http://www.excelforum.com/showthread.php?t=995572 as well as Ian's here: http://www.devenezia.com/round-robin...=1142176312/23
    Best Regards,

    Kaper

  10. #10
    Registered User
    Join Date
    04-19-2016
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    1

    Re: Excel round robin league scheduler

    Thanks for the file that works

+ 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