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 #43: Inspire Europe '16 Grand Prix (L2)

danrh
13 - Pulsar
 
kat
12 - Quasar

7 minutes - but didn't filter my question 2 and 3 result on Leeds postcodes...

 

Spoiler
Challenge #43.PNG
PrivateStorm
8 - Asteroid

My solution to challenge #43 is attached.

lminors
9 - Comet

European Grand Prix Preliminary practice! Done.

 

Luke Minors

Consultant - Keyrus UK

OllieClarke
15 - Aurora
15 - Aurora

Did it in less than 10 mins, although my workflow looked like this:

Spoiler
challenge 43 -messy.PNG

Here's how the cleaned up version looked:

Spoiler
challenge 43 -clean.PNG
KOBoyle
11 - Bolide

Solution attached.

MarMu
8 - Asteroid

 

Fun challenge. Managed to solve it just below the time cap.

 

Spoiler
challenge_43_start_file_MarMu.png 

 

JoBen
11 - Bolide

Cheers!

kelly_gilbert
13 - Pulsar

I was able to complete the challenge in 10 minutes, but my solutions didn't match! Reasons inside the spoiler tag...

 

Spoiler
Since 1,211 records couldn't be matched to a post code, I answered questions 2 and 3 from the original dataset:

_orig.PNG


If I change my solution to use only the matched records, my solutions match the given solution:
_changed.PNG


Also, I and many others interpreted question #3 to be [2015] minus [2014] (a positive value, 0.009511), while the solution gives [2014] minus [2015], or -009511.

Wouter
8 - Asteroid

My solution:

Spoiler
challenge 43.jpg