cancel
Showing results for 
Search instead for 
Did you mean: 

Challenge #217: A Fast Blast From The Past

AYXAcademy
Alteryx

Challenge #217: A Fast Blast From The Past

A solution to last week’s challenge can be found hereSource: https://en.wikipedia.org/wiki/Formula_OneSource: https://en.wikipedia.org/wiki/Formula_One

 

Formula 1 racing is one of the most popular sports in the world and the 2011 season is considered one of the most dramatic in history! If you aren't familiar with this category of racing, know that F1 cars are the most sophisticated race cars in the world and they are created by legendary automobile manufacturers.

 

Each season, teams travel to different locations around the world to compete in races. At the end of the season, awards are presented to the top driver and top team based on a point scoring system. The scoring system awards points to both drivers and teams at the conclusion of each race (the scoring is presented in the Points table). Since the races take place at different race tracks, each race has a unique number of laps. Additionally, races are constrained to a 2 hour window. This means not all races will complete the scheduled number of laps.

 

For this week's challenge we have provided a sample of lap data from the 2011 F1 Season covering races 4 - 17. You'll find each driver's times for every lap completed in each race. Use the Race Data to figure out who finished in the points for each race and find the top three racers across this 13 race sample.

Attachment
Download this attachment
Attachment
Download this attachment
221 REPLIES 221
AYXAcademy
Alteryx

Challenge #217: A Fast Blast From The Past

A solution to last week’s challenge can be found hereSource: https://en.wikipedia.org/wiki/Formula_OneSource: https://en.wikipedia.org/wiki/Formula_One

 

Formula 1 racing is one of the most popular sports in the world and the 2011 season is considered one of the most dramatic in history! If you aren't familiar with this category of racing, know that F1 cars are the most sophisticated race cars in the world and they are created by legendary automobile manufacturers.

 

Each season, teams travel to different locations around the world to compete in races. At the end of the season, awards are presented to the top driver and top team based on a point scoring system. The scoring system awards points to both drivers and teams at the conclusion of each race (the scoring is presented in the Points table). Since the races take place at different race tracks, each race has a unique number of laps. Additionally, races are constrained to a 2 hour window. This means not all races will complete the scheduled number of laps.

 

For this week's challenge we have provided a sample of lap data from the 2011 F1 Season covering races 4 - 17. You'll find each driver's times for every lap completed in each race. Use the Race Data to figure out who finished in the points for each race and find the top three racers across this 13 race sample.

Attachment
Download this attachment
Attachment
Download this attachment
patrick_digan
17 - Castor

Re: Challenge #217: A Fast Blast From The Past

My answers are a little off, but I didn't see anything glaringly wrong.

Spoiler
patrick_digan_0-1590503953429.png

 


 

Attachment
Download this attachment
Blake
Quasar

Re: Challenge #217: A Fast Blast From The Past

My answer differs a bit from the given answer but I'm confident in what I have... 

 

Fun challenge!

 

 

Spoiler
Blake_0-1590503909138.png



EDIT : Added link to my video walk through and corrected statement at top of post.

Spoiler

 

Attachment
Download this attachment
dsmdavid
11 - Bolide

Re: Challenge #217: A Fast Blast From The Past

Same as Patrick above. What are we missing?

Spoiler
dsmdavid_0-1590503910530.png

 

Attachment
Download this attachment
johnemery
11 - Bolide

Re: Challenge #217: A Fast Blast From The Past

I agree with @patrick_digan. My results match his.

 

I spent some time just now on this site: https://www.formula1.com/en/results.html/2011/drivers/JENBUT01/jenson-button.html and my race-by-race results match exactly.

 

Spoiler
Capture.PNG

View my solution video here:

Spoiler

 

Attachment
Download this attachment
Aaron_Harter
11 - Bolide

Re: Challenge #217: A Fast Blast From The Past

Fun challenge this week, however my total points are off compared to the provided solution:

Spoiler
2.PNG
Attachment
Download this attachment
AYXAcademy
Alteryx

Re: Challenge #217: A Fast Blast From The Past

Thanks for pointing out the error @patrick_digan @Blake @dsmdavid @johnemery @Aaron_Harter !

 

The Output Text Input values were from a previous version of the challenge...The workflow has been updated.

DaisukeTsuchiya
14 - Magnetar

Re: Challenge #217: A Fast Blast From The Past

My answer was different but match with updated workflow.
 

Spoiler
capture.PNG

 

Attachment
Download this attachment
Kenda
16 - Nebula

Re: Challenge #217: A Fast Blast From The Past

Spoiler
Kenda_0-1590505330993.png

 

Attachment
Download this attachment
RolandSchubert
16 - Nebula

Re: Challenge #217: A Fast Blast From The Past

Fun challenge, like others, my results do not match the expected values.

 

Spoiler
217.png
Attachment
Download this attachment