randomized League Schedule

[jcleary47]

Good afternoon,

I am having a problem created a randomized (somewhat) league schedule.

There are 10 teams in the league, and each team will play each other once over a 9 week period.

Is there an easy way to run a formula to generate a 9 week schedule with the 10 teams playing each other once?

Thanks

[shg]

See attached.

[kay18]

I tried opening the attachment to take a look at it but was unsuccessful.

[shg]

Opens fine for me, but there's a later version, unzipped, at https://app.box.com/s/z41sn0yrp5lo1cuozke3

[kay18]

Thanks so much. Is there a way I could change from a 9 week period to a 19 week period in the current spreadsheet, I was able to open it up using the unzipped link you provided? the number of teams remain the same (10).