# Weekly Challenge

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

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

Submit Feedback
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.

## Challenge #148: Rotating Century Puzzle

Highlighted
6 - Meteoroid
Spoiler
Highlighted
8 - Asteroid

My Solution:

Highlighted
14 - Magnetar
Spoiler
Highlighted
16 - Nebula

🙂 this is a good challenge - makes you think about base 6 numbering systems...

Super impressed with @jdunkerley79 's and @EstherB47  's solution (few tools - exhaust the problem space)

Spoiler
The approach here was to think about all the combinations for 1 slice first
- In other words - take the numbers which are at the 12 O'clock position in each ring, and call them slice 0; then go round the circle in clockwise order then you'll find slice 1, 2,3,4,5
- For slice zero - you create every combination of the inner 5 rings
- Once you know slice zero - you can derive the other slices fairly easily

The trick is to figure out the combinations by generating numbers; converting using base 6 math a set of 6 digits (each from 0 to 5).    This makes it much easier than generating 1 rotation for every ring.

Once you have this, you can then do a quick lookup to find the value written on the ring, and do a simple sum.

Looking forward to reading the solutions from other folk.

Highlighted
Alteryx Certified Partner

Here's my solution... an assisted one as I couldn't have done it without peeking at @jdunkerley79 's MOD function.

Spoiler
Highlighted
8 - Asteroid

I just figured out  R1, R2 and R6 were in the correct order off the bat and R3 and R4 just needed to rotate up 1 sequence and R5 needed to rotate up 2 sequences. Patato Potato?

Highlighted
Alteryx Certified Partner

22

Spoiler
Highlighted
Alteryx Partner

Decided to reverse-engineer it so it's probably a shorter workflow than most

Spoiler

Highlighted
8 - Asteroid

My solution: rotation, Cartesian, sum and filter.

Highlighted
Alteryx Partner
Spoiler

Pleased with myself to get this one!

It was quite difficult, but I enjoyed it. I unfortunately used 5 slightly different macros one after the other to get it to find every possible combination, but I couldn't be bothered at that point to consolidate them. Then, as I'd used a recordID + grouping in each macro, I could find the one combination where everything was in the right order. Doesn't make too much sense, but hopefully the workflow does!