Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account 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 #407: Single Biggest Lottery Winner

Christina_H
14 - Magnetar

My solution

Spoiler
image.png
mceleavey
17 - Castor
17 - Castor

Nice example of a formatting issue:

 

Spoiler

I can longer paste anything for some reason so I'll explain it...

I simply formatted the prize money field for 6/6 matches by using regex to remove all punctuation, then divided the result by 100 to ensure the decimal point was in the right place.
I then simply filtered to where 6/6 matches = 1, sorted by the aforementioned value and sampled the first 1.
Simple.



Simple.



Bulien

BSilverblatt
8 - Asteroid

Thanks for the challenge! Here's my solution:

 

 

wren728
6 - Meteoroid
Spoiler
Spoiler

407.PNG

kdhdsny1
7 - Meteor
 
 

 

 

RashedDS
8 - Asteroid

Always make it simple.

407.JPG

FrederikE
13 - Pulsar
Spoiler
Screenshot 2024-01-08 193557.png

JamesCharnley
13 - Pulsar
Spoiler
image.png

Will win

tammybrown_tds
9 - Comet

My solution.

 

Spoiler
Screenshot 2024-01-08 162017.jpg