cancel
Showing results 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

Atom

Nebula

Good puzzle.  It must take forever in physical form...you're carefully working your way through the combinations...and then your little brother comes along and spins the little wheels!  Doh!

Spoiler

Dan

Asteroid

For me the really tricky part was defining what combinations were tied to each other (i.e. if axis 1 is using a value on a certain wheel, then the axis to its right would necessarily be using the value to the right on that same wheel, etc.) and then keeping track of that ... finally got that to work.  :0)

Take a look (if you are having trouble on how to start - this may help because I always use lots of notes and descriptive labels)

:-)

Asteroid

fun - solved without a macro - I can't imagine doing this actual puzzle as I found there were 650 combinations that added up to 100!

Spoiler
my solution is a bit of a kludge/brute force - I created the string of all the options by creating numerical records from 111111 to 666666 and converted them to string.  Next I used regex to remove any records with a number not between 1 and 6 and then tokenized it to get each position in a column.  I then joined it all together, filtered on rows that summed to 100 and then looked for other rows that were the next sequence in line.

Quasar

Kudos to @patrick_digan@brianaburke002, and @DultonM for authoring this awesome challenge!

This one really stretched my brain, and it was a lot of fun to solve!

My solution:

Spoiler
Alteryx Certified Partner

Flexing the ol' Python skillz...

Spoiler
Python NotebookWorkflow
Alteryx Certified Partner

Had to have this done before next week, if I need to keep up with the pace.

I am not proud of this, I kind of had to brute force my solution, but after a while , I did get the result.

Spoiler

When I afterwards look at how others had solve it, I saw some that basically did the same, but it a much smarter way 😍 ⭐⭐⭐⭐

Until next week, have a nice weekend

/Thomas

Pulsar

I used iterative macro method to solve this puzzle.  Received 194 different combination of output.

Spoiler

Aurora

Thanks for letting us challenge the community @JoeM! Here is my solution:

Spoiler
Quasar

I really wanted to solve this mathematically but when staring at the pattern didn't work, I had to go macro. Edit: Basically like @jdunkerley79 did. That was the elegance I was originally going for. Nice work!!

Spoiler
append all files firstiterative macro

@danilang - I'm back :) :)