community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #148: Rotating Century Puzzle

Alteryx Certified Partner

Completed, but it may be not really a nice solution.

Asteroid

Not as elegant as some of the macro solutions.  The formula to lock the relative ring positions to each other took some time, but ultimately let to a single (correct) solution.

Asteroid

I used join function for current position and next position. I don't know if this approach is dynamic enough. It will probably require a few more rounds of joining if it has > 6 positions.

Asteroid

I did this two different ways. I think there has to be a better way than i did it, neither are very dynamic and i do not like them but they both solve the puzzle.

 

Spoiler
The first way i used MOD to create a position key. My second solution was to create a key from the positions then find the next one along, after doing this twice i had only 6 results.
148.PNG
Asteroid

Decided to go the non-macro way... 

Bolide

My solution!

Bolide
Bolide

Loved this challenge - a true puzzle!  Had seen this challenge and a solution prior to it becoming a weekly challenge, but really took time to understand it for myself...so it's not as pretty, but gets the job done!  (It also pays to read the instructions carefully...)

 
Highlighted
Meteoroid

My solution to get the code then validate the code with a small macro to simulate turning.

Alteryx Certified Partner

Wow, a fun & complicated challenge as I like :-)

I did it with a batch macro.