Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #329: Near Earth Objects

Powerhouse_21
9 - Comet
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
12 - Quasar
Spoiler

 

SPetrie_0-1658872011693.png

 

Kwebb
6 - Meteoroid

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