ExcelBanter - League Schedule

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - League Schedule (https://www.excelbanter.com/excel-discussion-misc-queries/105408-league-schedule.html)

I would like to use excel to create different League Schedules. For example
there are 10 teams in our leage and we play a 11 week season. What makes
this a little more complicated is that within our league ther are two
divisions of 5. 1-5 and 6-10.
I would like to have it so that the two divisions play each team at least
once. And also have the same number of division games. I know there is
software that does this, but I don't want to pay for it, any ideas?

Thanks Vicks

Vick wrote:
I would like to use excel to create different League Schedules. For
example there are 10 teams in our leage and we play a 11 week season.
What makes this a little more complicated is that within our league
ther are two divisions of 5. 1-5 and 6-10.
I would like to have it so that the two divisions play each team at
least once. And also have the same number of division games. I know
there is software that does this, but I don't want to pay for it, any
ideas?

Thanks Vicks

Hi Vick,

I think this could be useful for you:

http://www.usd.edu/trio/tut/excel/adv/soccer.shtml

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy