Challenge #307: Round-robin

[lwolfie]

phew.....that was a challenging one.

[Carolyn]

Solved!

Spoiler

App: 

Iterative Macro:

[sammyb84]

I'm confused with the data set.  The output sample says Team A and Team B but should this be 2 leagues?  

The way i'm reading this is that app says 5 teams in 5 weeks, each team gets to play once a week.  But there is only Team A and Team B?  I'm confused where there are 5 teams and what do the numbers represent under each Team?

[Kenda]

Hi @sammyb84 

Great questions!

Team A and Team B are just generic headers for the columns to show which teams are playing each other each week. The actual team names are 1, 2, 3, 4, 5. So in the sample output, team 1 plays team 5 and team 2 plays team 4.

Hopefully that helps clear it up!

[sammyb84]

I think I figured it out.  Looking at other people's solutions and validating against the Output set, The number of games played by each team is equal to # of teams - 1.  So in yours, in 5 weeks each team will have been able to play each other 4 times. Also if there is only one week then they play 4 times back to back which in tennis would probably mean death.

[Erin]

Thought I posted this earlier but it wasn't marked as solved on my list, so try try again...

[JBevan89]

Great Challenge

[shrestha_nitesh]

Workflow

Spoiler

Macro 1

Spoiler

Macro 2

Spoiler