Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere is my submission.
Great challenge and back story!
Could do it with just one Formula probably, but decided to try it with Generate Rows just for fun.