Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAattached is the workbook with my suggested solution. thanks.
I disagree with the count on #1. I'm seeing item duplication with multiple passes of same discovered objects. A distinct count gets you 169 distinct objects discovered in 2021 rather than 170. One object had 12 passes in 2020 and continued to get further away and decrease in velocity. Would each of these be counted as 'discoveries'? Maybe so, but that felt incorrect to me. Might even need to take it a step further and see if any id's were discovered in previous years and only take the first know recording.
here is my solution!!
I love an excuse to relearn regex (until I forget it again!)