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
148.JPG
Highlighted
8 - Asteroid

My Solution:

 

 

Highlighted
14 - Magnetar
14 - Magnetar
Spoiler
Capture.PNG
Highlighted
16 - Nebula
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)

 

Result.png

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.



Solution Part 1.png

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
Screenshot 2019-06-22 at 20.58.28.png
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? 148solved.png

Highlighted
Alteryx Certified Partner

22

 

Spoiler
iterative.PNGMainFlow.PNG
Highlighted
Alteryx Partner

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

Spoiler
148..png

 

Highlighted
8 - Asteroid

My solution: rotation, Cartesian, sum and filter.

Highlighted
Alteryx Partner
Spoiler
148. Data Analysis.PNG


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!