We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #329: Near Earth Objects

Powerhouse_21
8 - Asteroid
Spoiler
Powerhouse_21_1-1658851514145.png

 

Original_Yodies
8 - Asteroid
Spoiler
Original_Yodies_0-1658853167114.png

 

btjahjonoAx
5 - Atom

attached is the workbook with my suggested solution. thanks.

SPetrie
11 - Bolide
Spoiler

 

SPetrie_0-1658872011693.png

 

Kwebb
5 - Atom

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.

 

Spoiler
Kwebb_0-1658877380408.png

 

akthorataks
7 - Meteor

here is my solution!!

Spoiler
akthorataks_0-1658900088552.png

 

rwinton
Alteryx
Alteryx

I love an excuse to relearn regex (until I forget it again!)

 

Spoiler
Screenshot_1.png

 

Robert Winton
Sales Engineer
Alteryx
FilipR
11 - Bolide

Solved.

 

Spoiler
FilipR_0-1658913850962.png

 

Aubry-Manon
6 - Meteoroid
Spoiler

AubryManon_0-1658915217237.png

 

FloSchoch
7 - Meteor
Spoiler
FloSchoch_0-1658929824665.png