2017 Season - Rate the Drivers

[Chrill]

OK, so even though you have not yet rated Singapore it is time for me to post some stats.

Chrill's top 5:
Driver - Avg. Rating - Best score
Daniel Ricciardo - 8.167 - 2x10
Fernando Alonso - 7.889 - 2x10
Nico Hülkenberg - 7.692 - 1x10
Sebastian Vettel - 7.538 - 1x10
Lewis Hamilton - 7.462 - 4x10

Penfold's top 5:
Driver - Avg. Rating - Best score
Sebastian Vettel - 8.385 - 2x10
Fernando Alonso - 7.800 - 2x10
Lewis Hamilton - 7.769 - 3x10
Daniel Ricciardo - 7.583 - 4x9
Max Verstappen - 7.545 - 1x10


These are our leading men for every team:

Chrill
Team - Driver - Rating - Difference to team mate
Mercedes - Lewis Hamilton - 7.462 - (+0.077)
Red Bull - Daniel Ricciardo - 8.167 - (+1.667)
Ferrari - Sebastian Vettel - 7.538 - (+0.902)
Force India - Sergio Perez - 7.231 - (+0.154)
Williams - Felipe Massa - 7.077 - (+1.077)
McLaren - Fernando Alonso - 7.889 - (+1.972)
Toro Rosso - Carlos Sainz, Jr. - 7.250 - (+2.327)
Haas - Romain Grosjean - 6.538 - (+0.538)
Renault - Nico Hülkenberg - 7.692 - (+2.776)
Sauber - Marcus Ericsson - 6.615 - (+0.115)

Penfold
Team - Driver - Rating - Difference to team mate
Mercedes - Lewis Hamilton - 7.769 - (+0.769)
Red Bull - Daniel Ricciardo - 7.583 - (+0.038)
Ferrari - Sebastian Vettel - 8.385 - (+1.635)
Force India - Esteban Ocon - 7.308 - (+0.231)
Williams - Felipe Massa - 7.364 - (+1.671)
McLaren - Fernando Alonso - 7.800 - (+2.550)
Toro Rosso - Carlos Sainz, Jr. - 6.833 - (+1.372)
Haas - Romain Grosjean - 6.385 - (+0.538)
Renault - Nico Hülkenberg - 7.538 - (+3.266)
Sauber - Marcus Ericsson - 6.385 - (+0.085)

So yes. We both claim Ericsson to have had a better season than Wehrlein despite a 5-0 points advantage to the German. The margins are small.

We agree on every driver except Force India, but once again margins are indeed small.

With my newfound experience of Google Spreadsheets and similar, I shall make some more numbers. I shall then present them. Numbers such as which driver we most strongly disagree about.

[Matt]

It appears that Vettel is on pace to win both Penfold's "driver of the year" and "idiot of the year" awards.

[Chrill]

More stats. WOO!

Code Select Expand

Max Verstappen 1.045
Sebastian Vettel 0.846
Stoffel Vandoorne 0.667
Jolyon Palmer 0.644
Daniel Ricciardo 0.583
Daniil Kvyat 0.538
Carlos Sainz, Jr. 0.417
Valtteri Bottas 0.385
Lewis Hamilton 0.308
Lance Stroll 0.308
Esteban Ocon 0.231
Marcus Ericsson 0.231
Pascal Wehrlein 0.200
Sergio Perez 0.154
Kevin Magnussen 0.154
Nico Hülkenberg 0.154
Romain Grosjean 0.154
Felipe Massa 0.136
Kimi Räikkönen 0.114
Fernando Alonso 0.089

Put simply, this is the difference between any two drivers. This doesn't look at who rates which driver higher, it just shows the difference between our two ratings. Spending time at work figuring this out, because I need to know Excel at work anyway so I consider this educational 

[Penfold]

It appears that Vettel is on pace to win both Penfold's "driver of the year" and "idiot of the year" awards.

His Singapore score will drag him down, as did his Baku efforts, but the other twelve races thus far have been quality.  Anyway, I told you that Kvyat has pretty much got the 2017 'idiot' prize in the bag.

[Penfold]

I shall now score Singapore and render Chrill's averages obsolete:

Merc:
Hammy - 9 - Great drive in tricky conditions but Vettel obliterated any competition for the win.
Val - 6 - Miles off Hammy's pace..

Red Bull
Dan - 8 - Strong result with iffy gearbox but didn't exactly have to fight for it.
Max - X - Seb's biggest fan.

Ferrari:
Seb - 2 - What a dim-witted move.
Kimi - X - Seb's second biggest fan.

Force India:
Perez - 8 - One of many to gain a bunch of places courtesy of Seb; still a v. good drive but position is flattered.
Ocon - 5 - Shouldn't be finishing behind a Haas.

Williams
Baby - 4 - Beaten by Lance once more.  In danger of becoming a habit.
Stroll - 8 - So much more comfortable in the car than in the first part of the year, good to see.

McHonda
Alonso - X - Yet another casuality of Seb's recklessness.  Surely top 4 was a cert and perhaps he could've even had Bottas.
Van Door - 7 - Solid.

Toro Rosso:
Sainz - 9 - Best of the rest thanks to Hulk's retirement.
Kvyat - 4 - Good grief, he crashed his car... I almost can't believe it.

Haas:
Big Jean - 8 - Car didn't look fantastic but brought it home ahead of a Force India & a Willimas (and was running ahead of team-mate).
Son of Magnus - 7 - Just a tad off Romain.

Renault:
Hulk - 9 - Best of the rest until his retirement.
Palmer - 8 - Talk about driving for your career....

Sauber:
Chrill's mate Marcus - 5 - Points off for crash.
Blaise - 4 - Points off for being slow.

[Chrill]

Don't worry. All I need is to enter the digits and Google Spreadsheets do the calculations for me!

So, with Singapore in mind, THIS HAPPENED:

You no longer claim Ocon to be better than Perez. The difference between them is now 0.000. They both have a total score of 100 points this season.

This is now the difference between us two!

Code Select Expand

Driver Difference Highest rating
Max Verstappen 1.045 7.857
Daniel Ricciardo 0.551 7.929
Stoffel Vandoorne 0.532 8.167
Valtteri Bottas 0.456 7.143
Daniil Kvyat 0.434 6.750
Felipe Massa 0.417 4.917
Pascal Wehrlein 0.409 7.250
Lewis Hamilton 0.396 7.500
Sebastian Vettel 0.390 7.385
Jolyon Palmer 0.333 7.545
Marcus Ericsson 0.330 5.917
Carlos Sainz, Jr. 0.250 7.231
Lance Stroll 0.143 6.000
Kimi Räikkönen 0.114 6.615
Fernando Alonso 0.089 6.500
Sergio Perez 0.088 5.357
Kevin Magnussen 0.071 6.538
Esteban Ocon 0.066 7.889
Nico Hülkenberg 0.049 6.000
Romain Grosjean 0.038 7.692

[Matt]

It appears that Vettel is on pace to win both Penfold's "driver of the year" and "idiot of the year" awards.

His Singapore score will drag him down, as did his Baku efforts, but the other twelve races thus far have been quality.  Anyway, I told you that Kvyat has pretty much got the 2017 'idiot' prize in the bag.

I would go for Vettel over Kvyat. It's not that Kvyat has driven better than Vettel or made less mistakes, he hasn't. But Vettel has likely thrown away a chance at a championship, while Kvyat apparently won't even lose his job.

[Penfold]

That is a good point - consequences of stupidity rather than sheer volume.  So maybe Seb will deserve both the 'biggest idiot' & 'best driver' awards.

[Chrill]

MaMaMaMaMalaysia.

Mercedes:
Lewis Hamilton – 7/10 (Solid 2nd place finish from a great pole position. Can't be much more than 7/10 when dropping compared to your grid position)
Valtteri Bottas – 4/10 (Really really poor. Like very poor. He only just edged Perez in the end. Perez, sick with a stomach bug)

Red Bull:
Daniel Ricciardo – 8/10 (Made the podium thanks to fending off a very hungry German in a red car. Nice defending, decent drive)
Max Verstappen – 9/10 (Well, he won his second race in rather dominant fashion. He passed Hamilton on track. Still, it's not enough for me to call it 10/10)

Ferrari:
Sebastian Vettel – 10/10 (This is why Verstappen can't be a 10/10. Vettel. Wow. P4 is not a bad comeback. Definitely had by far the best car today. Would have finished half a minute ahead of Verstappen had he started where he should have)
Kimi Räikkönen – X/10 (So upsetting. With Vettel out of the equation, we really needed to hear the Finnish anthem today. We would have, had he simply managed to race)

Force India:
Sergio Perez – 10/10 (He was afraid he couldn't even complete the race due to exhaustion. Instead he finished P6 and best of the rest, the only driver from the midfield to not be lapped)
Esteban Ocon – 6/10 (I mean, points scored is never bad but P10 was not enough)

Williams:
Felipe Massa – 7/10 (With a damaged car after being part of a pink Force India sandwich at the start, he still followed his young friend across the line)
Lance Stroll – 7/10 (With a non-damaged car, he managed to pass his old friend and beat him to the line)

McLaren:
Fernando Alonso – 5/10 (Really quite poor. Is he simply giving up on 2017?)
Stoffel Vandoorne – 9/10 (Really very good. He has dominated the old Spaniard in these last two races. Sign of things to come?)

Toro Rosso:
Carlos Sainz Jr – 6/10 (Ran decently until he retired with an engine failure)
Pierre Gasly – 7/10 (Acceptable debut, not far behind his more experienced team mate. Replacing Kvyat? Good call)

Haas:
Romain Grosjean – 5/10 (Fairly mediocre. nuff said)
Kevin Magnussen – 6/10 (A tiny bit less mediocre, still pretty mediocre)

Renault:
Nico Hülkenberg – 5/10 (Not good! Strategy ended up poorly, and had to pit near the very end which shunted him far down the order)
Jolyon Palmer – 5/10 (Also not good! Can't blame strategy though, he was simply poor)

Sauber:
Marcus Ericsson – 4/10 (Definitely destroyed by his team mate this weekend. Half a second in quali, basically the same over the entire race)
Pascal Wehrlein – 8/10 (Can really do nothing more with his Sauber. Had a good weekend considering his equipment)



Obviously Vettel is my driver of the race. Good stuff.

[Penfold]

Malaysia:

Merc:
Hammy - 8 - Fortunate with Ferrari woes, but great pole and strong drive for second.
Val - 4 - Way, way off Hammy all weekend.

Red Bull
Dan - 8 - Nice bit of defensive driving at end.  Nice enough driving the rest of the time, too.
Max - 10 - Torn between awarding full marks or 'only' a 9, guess I'm feeling a little generous today.

Ferrari:
Seb - 9 - Strong recovery albeit in best car and with much of the midfield pitting themselves out of Seb's way.
Kimi - X - Bollocks.

Force India:
Perez - 10 - Bumped to a 10 for battling through illness.
Ocon - 7 - Got squeezed onto Massa at race start which meant early pit stop, could've still come 7th but for a clash with Sainz.

Williams
Baby - 7 - Can't be bothered to explain.
Stroll - 7 - See above.

McHonda
Alonso - 6 - Too long on first set of tyres, not sure why he or the team thought this a good idea.
Van Door - 10 - Didn't put a foot wrong.  Hope he continues in this vein.

Toro Rosso:
Sainz - 5 - One point deduction for clipping Ocon.
Gasly - 6 - Good effort.  He probably finished roughly where Kvyat would've, although there's a 1 in 3 chance the Russian would've crashed.

Haas:
Big Jean - 5 - Barely noticed him.
Son of Magnus - 6 - Enjoyed the tussle with Alonso.

Renault:
Hulk - 6 - Terrible strategy and the car didn't look much better.
Palmer - 4 - Spun by the wind?  Slower than the Hulk, obviously.

Sauber:
Chrill's mate Marcus - 4 - Poor showing in quali and race.
Blaise - 7 - Decent showing in both.

[Chrill]

Thank you.

I am VERY proud to announce my ability to create rules and formulas in Google Spreadsheets. So much so that I have created THIS:

Code Select Expand

Driver Diff. Highest Who rates them higher?
Max Verstappen 1.023 7.750 Penfold
Pierre Gasly 1.000 7.000 Chrill
D. Ricciardo 0.511 8.154 Chrill
Pascal Wehrlein 0.470 6.636 Chrill
S. Vandoorne 0.440 6.154 Chrill
Lewis Hamilton 0.438 7.867 Penfold
Daniil Kvyat 0.434 5.357 Penfold
Valtteri Bottas 0.410 7.143 Chrill
Felipe Massa 0.385 7.462 Chrill
Jolyon Palmer 0.385 4.923 Chrill
C. Sainz, Jr. 0.297 7.154 Chrill
Marcus Ericsson 0.295 6.429 Chrill
S. Vettel 0.286 8.000 Penfold
Lance Stroll 0.138 6.071 Chrill
Esteban Ocon 0.133 7.133 Penfold
Kimi Räikkönen 0.114 6.750 Penfold
Sergio Perez 0.095 7.429 Chrill
Kevin Magnussen 0.067 6.000 Chrill
Fernando Alonso 0.036 7.636 Penfold
Nico Hülkenberg 0.033 7.533 Penfold
Romain Grosjean 0.029 6.429 Chrill

Whenever I fill in your digits, it will automatically calculate their total score, their average score, their score in relation to their team mate. It will also calculate the above, that is the difference between your score and mine, their highest rating, and which one of us provided that highest rating.

This is the code:

Code Select Expand

=IFS(C2 = Penfold!W5,"Penfold", C2 = Chrill!W5,"Chrill", TRUE,"No match found")
It's simple. If field C2 (highest rating) matches you, make it say so. If it matches me, make it say so. If none of those are true, it will look at the third option which is always true and return "No match found".

YES THIS IS RELEVANT TO MY WORK. I'm actually learning Spreadsheets right now and this is genuinely relevant to me, it's good practice.

[Penfold]

Gets two thunbs up, or even thumbs up, from me.  Can't beat a good bit of solid data - although person inputting might want to take more care: I gave Gasly 6/10 not 8/10.

[Chrill]

Yes. It is true. It confused the order of drivers when I sorted them based on Difference. SORTED IT OUT NOW THOUGH.

If you are a Google user, then this link SHOULD work:
https://docs.google.com/spreadsheets/d/1dnPSeVbYFM6KP0SW2SPGzJch7KAiLuaUvD4hpSWSHek/edit?usp=sharing

[Penfold]

Link works just fine.

Max clearly odds-on to win the '2017 biggest difference of opinion between Chrill & Penfold' award.  Might need a snappier name.

[Chrill]

Japan.

Mercedes:
Lewis Hamilton - 9/10 (Controlled the race perfectly. Did what he had to do)
Valtteri Bottas - 6/10 (It's really not good enough. At least he kept Daniel close)

Red Bull:
Daniel Ricciardo - 7/10 (Couldn't challenge his team mate here)
Max Verstappen - 9/10 (At one point looked able to challenge Hamilton. In the end, P2 was a good result)

Ferrari:
Sebastian Vettel - X/10 (Stupid Ferrari engine failures. This is annoying)
Kimi R?ikk?nen - 7/10 (Drove an acceptable race from P10 but should've stayed closer to Bottas)

Force India:
Sergio Perez - 6/10 (Finished behind his team mate after qualifying behind)
Esteban Ocon - 8/10 (Finished ahead of his team mate after qualifying ahead)

Williams:
Felipe Massa - 5/10 (A point. Just. Started P8 and dropped back)
Lance Stroll - 6/10 (Well. He retired. Before that, looked stronger than his friend Massa)

McLaren:
Fernando Alonso - 7/10 (Outside points, did what he could, but never had the top speed)
Stoffel Vandoorne - 7/10 (Back to mediocre for the Belgian. Couldn't challenge today, although qualified really well)

Toro Rosso:
Carlos Sainz Jr - 4/10 (Crashed at the start by his own fault)
Pierre Gasly - 6/10 (Finished ahead of a McLaren and a Sauber. Second race, so more is to come)

Haas:
Romain Grosjean - 7/10 (Some decent points, but rather anonymous race)
Kevin Magnussen - 8/10 (Like Grosjean, bonus point for his brutal overtake of Massa. Neat stuff)

Renault:
Nico H?lkenberg - 7/10 (Was running OK before retiring with an open DRS wing. Unlucky)
Jolyon Palmer - 5/10 (Very unspectacular race)

Sauber:
Marcus Ericsson - 6/10 (Kept both McLarens behind him. Then forgot that Degner is a difficult corner and his car is shit, and so went too fast. Deducting 2 points for crash, still giving him 6)
Pascal Wehrlein - 4/10 (Very far behind Ericsson, and ran 30 seconds behind him after a really weird pit strategy he ordered himself)

Driver of the race? Uh.... Hamilton? Verstappen?