We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #247: Pairing Partners

marioyuwono
8 - Asteroid

247.png

ArtApa
Alteryx
Alteryx

Here is my solution. No macro was needed.

Spoiler
ArtApa_0-1609720662099.png

 

patrick_digan
16 - Nebula
16 - Nebula

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
patrick_digan_0-1609773681265.png

 

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.
patrick_digan_0-1609793383217.png

 

KilianL
Alteryx
Alteryx

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
247 - Round Robin Circle Alg - Kilian.png
aruiz-itp
11 - Bolide

Here the solution

hanykowska
10 - Fireball

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

 

Spoiler
main workflow
hanykowska_0-1609934306554.png


iterative macro inside

hanykowska_1-1609934334635.png

 

BelindaSpratt
7 - Meteor

No macros necessary 🙂

JosephSerpis
16 - Nebula
16 - Nebula

Challenge Completed

 

Spoiler
Weekly_Challenge_247.JPG

Weekly_Challenge_247_Macro.JPG
ponraj
13 - Pulsar

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
Main workflow.PNGMacro.PNG

 

 

 

A2H
11 - Bolide

Algorithm is not easy to set up !

 

Spoiler
Capture d’écran, le 2021-01-12 à 21.27.01.png