Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #247: Pairing Partners

DaisukeTsuchiya
13 - Pulsar

Interesting challenge!

 

Spoiler
キャプチャ.JPG
jasperlch
12 - Quasar
Spoiler
Capture.JPGCapture2.JPG
DeanWest
9 - Comet

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
14 - Magnetar
14 - Magnetar

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
16 - Nebula
16 - Nebula

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

 

Spoiler
Workflow:
247-1.png

Macro:
247-2.png
AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

I have reached no macro route.

Spoiler
AkimasaKajitani_0-1608639130551.png

 

Qiu
20 - Arcturus
20 - Arcturus

@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

 

Sashikumar
8 - Asteroid

Good one.

Spoiler
ch247.PNG
balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1608696633976.png