community
cancel
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #148: Rotating Century Puzzle

Alteryx Certified Partner
Alteryx Certified Partner

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

Quasar

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

Quasar
Quasar

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...)

Meteor
 
Alteryx Certified Partner

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.