Challenge #148: Rotating Century Puzzle

[danilang]

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

[aristiguieta]

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)

:-)

[KevinW]

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.

[ddiesel]

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

[PhilipMannering]

Flexing the ol' Python skillz...

Spoiler

Python NotebookWorkflow

[Verakso]

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 

[ponraj]

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

Spoiler

[patrick_digan]

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

Spoiler

[kat]

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