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.

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.

Thanks! TeamScheduler4 is excellent!

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

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

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

Thanks for the file that works