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

DaisukeTsuchiya
12 - Quasar

Interesting challenge!

 

Spoiler
キャプチャ.JPG
jasperlch
12 - Quasar
Spoiler
Capture.JPGCapture2.JPG
DeanWest
8 - Asteroid

Late to the party today, but this was a fun challenge to start the week!

 

Spoiler
Create the Round Robin Pairs (including all round variations)
challenge_247_solution_DeanWest_snippet-1.png
Spoiler
Batch Macro joins the RecordID's made in the Round Robin Table to get names from the original data set.
challenge_247_solution_DeanWest_snippet-2.png
T_Willins
13 - Pulsar
13 - Pulsar

Another fun challenge.  To solve the advanced challenge I used an Iterative Macro to create all the pairings.  Bonus:  Not only is it dynamic to the number of participants, but also will manage odd numbers of participants by adding a "Bye Week" for one participant each week.

 

Spoiler
Iterative MacroIterative Macro

 

WorkflowWorkflow

 

RolandSchubert
15 - Aurora
15 - Aurora

Great challenge! Used an iterative macro based on circle method.

 

Spoiler
Workflow:
247-1.png

Macro:
247-2.png
AkimasaKajitani
14 - Magnetar

My solution.

 

I have reached no macro route.

Spoiler
AkimasaKajitani_0-1608639130551.png

 

Qiu
17 - Castor

@PhilipMannering Congratulations.

Followed the round-robin tournament with a batch macro

Spoiler
en-247-01.PNGen-247-02.PNG
Greg_Murray
12 - Quasar

@PhilipManneringI thought this looked familiar. 

 

Here is my solve, much improved from what I posted a few weeks ago.

Spoiler
workflow
Greg_Murray_0-1608647205119.png

iterative macro

Greg_Murray_1-1608647226103.png

 

skumar_31
8 - Asteroid

Good one.

Spoiler
ch247.PNG
balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1608696633976.png