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 #144: Secret Santa Assignments (BAH HUMBUG!)

Erin
9 - Comet

My output is different as I wanted to ensure that each person's Secret Santa wasn't the same as who they were the Secret Santa for. I can't think of an easier way to say that. I added some test tools in too for unique santa pairings and net scroochiness level not greater than 13. 

 

Spoiler
BronzeFox_0-1624142599863.png

 

derekbelyea
12 - Quasar
Spoiler
derekbelyea_0-1624326273409.png

 

Nethrah24
8 - Asteroid

Done

KatarinaH
6 - Meteoroid

KatarinaH_0-1624809583736.png

 

Raghusrnvs
5 - Atom

Here is my solution.

JackBurnham
8 - Asteroid

b

Jonny
11 - Bolide

I was going around the world in order to cross the street until I saw @patrick_digan 's solution!

Spoiler
Jonny_0-1626186307551.png
Jonny_1-1626186322509.png

 

 

TheOC
15 - Aurora
15 - Aurora

Nice easy challenge!

Spoiler
TheOC_0-1626441943053.png


I chose to do select records as i didn't trust that the challenge would be nice enough to give you an even filter split. In hindsight, tile tool would beat both of these options.


Cheers,
TheOC


Bulien
IraWatt
17 - Castor
17 - Castor

I got slightly different results but kept within the rules of the task. 

 

Spoiler
IraWatt_0-1626443493586.png

 

Elias_Nordlinder
11 - Bolide

Here is my solution 🙂

Spoiler
Just went with intuition,
1. Create RecordID for all 50
2. Split in two equal
3. Reverse sort order for second half
4. New RecordID
5. Join on new RecordID (As second half is sorted in reversed -> Highest from first = Lowest on Second (Scrooginess)
6. Do some fixing, adding Scrooginess etc.!
Elias_Nordlinder_0-1626872205686.pngElias_Nordlinder_1-1626872219712.png