Challenge #247: Pairing Partners

[marioyuwono]

[ArtApa]

Here is my solution. No macro was needed.

Spoiler

[patrick_digan]

So I got doing down the wrong path, but refused to admit it was total junk. So my solution involves a few hardcodes and isn't dynamic (and is indeed junk).

Spoiler

EDIT: I refused to give up. I finally found a way to solve it going down the wrong path.

Spoiler

If you set it up JUST RIGHT, I was able to use the optimization tool to get the pairs all lined up. I really struggle with the optimization tool as there are too many ways to do it wrong.

[KilianL]

No need to reinvent the wheel, so I implemented the circle algorithm for scheduling round robin tournaments (see Wikipedia).

Should work on any even number of participants. For uneven numbers, a dummy can be added to the input to make it even.

Comparing the results I get the same pairings, just in a different weekly order, success!

Spoiler

[randreag]

Here the solution

[hanykowska]

Definitely started with overcomplicating things, but I think I managed to find my way out!

Spoiler

main workflow

iterative macro inside

[BelindaSpratt]

No macros necessary 🙂

[JosephSerpis]

Challenge Completed

Spoiler

[ponraj]

Used iterative macro to solve this challenge.  Need to update maximum number of iteration manually when number of records changes. So that iteration stops once each people played each other people.  Example, iteration would be 5 for 6 people, it would be 7 for 8 people. it is kind of manual. I could not make it dynamic. However, made the pairing/partnering fully dynamic. 

Spoiler

[A2H]

Algorithm is not easy to set up !

Spoiler