Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Very cool challenge.
I had to read a few of the posts to get to the exact match. I assumed that the text would be in upper case as the description indicated. And what I would've assumed if ever I found my self in a similar situation as Matt Demon. :) Quite a pickle!
I appended the start position of the camera on the rover and used Multi-Row formula to calculate the next position. Then I could join the table with its self to get the next position. And voila, a circle.
I considered that, with a man stranded on Mars, we'd want to be as efficient as possible. So, the camera can move either direction, depending on the shortest distance to the next card, and whitespace and punctuation are out. Everything is title case to easily denote new words since we don't have punctuation, and the camera pauses for 1 second on each card. In the case of repeat cards, it just sits there for another second. Seems like these were very similar assumptions to others. I got the message there in 27.07 minutes. You're welcome, Matt Damon.
My output is just smaller than the solution, but fortunately my workflow is quite similar to the solution workflow.