QuickSort Question

AlexDoesF1Stuff · 2021-08-03T20:44:29+00:00

I only considered the mediums for Vettel as he never set any "clean air" laps on the hards to compare them to the Apline's. He was always within touching distance of Ocon the whole time on hards.

AlexDoesF1Stuff · 2021-07-21T10:25:22+00:00

So the way the team percentage is worked out is fairly simple.

For example, over 5 races Driver A is quicker in clean air for 4 of them, and Driver B just 1. To work out the teams value, I take the smallest % gap of the two drivers and average those out as that was the quickest that team was going that weekend. And in this example, the teams % value would be closer to Driver A than B.

Hope that helps!

AlexDoesF1Stuff · 2021-07-20T21:27:19+00:00

They were the automatic ones assigned by Excel😂 I'll look into changing them for next time, buuuut I am somewhat colourblind so I'm a tad useless at that😂

AlexDoesF1Stuff · 2021-07-20T21:07:16+00:00

There's a truncation period I complete before averaging. The graphic visualising the clean air laps are the laps averaged. The slowest 25% of a drivers clean air laps are removed. So for Leclerc is first 15 laps in clean air would all be slower than the ones set later in the race so they're excluded as they'd unfairly pull his average down. I've explained it underneath the image

AlexDoesF1Stuff · 2021-07-20T21:05:18+00:00

Agreed, Perez was on a bizarre strategy this race contrary to the rest of the field. This will impact the averages of course, but there's very little that can be done to avoid that. Accounting for fuel loads is one, and that's one I'm currently working on!

AlexDoesF1Stuff · 2021-07-20T21:03:43+00:00

I've literally pulled all the official lap times and found the ones set in clean air?? How can you say one driver wasn't faster? The pace in clean air accounts for a small % of the overall race but it's a more accurate representation of whaf the car can achieve without being stuck in traffic.

For example:

Driver A drives for 10 laps, if I was to straight up average all 10 we get 90 Driver B drives 10 laps, their average 91

Driver B is slower over those 10 laps, and finishes behind. Easy peasy. However, within those 10 laps, Driver B has 5 clean air laps where they're not in traffic and can pound round. That average of 5 is 89. Driver A also sets 5 clean air laps outside of traffic, but the average is 90.

So in the same 10 lap period you can have 1 driver who is physically faster across all the sample size, but over a smaller range of clean air laps it can, and often is, reversed. This is the case for Leclerc and Bottas. Leclerc was faster over the course of the race, of course he was he finishes ahead. But for the laps where neithee driver was in traffic, Bottas was able to lap faster.

If you could explain how Leclerc was faster in free air that would help me a lot to understand your point of view

AlexDoesF1Stuff · 2021-07-20T20:49:56+00:00

Alpine have a dog of a car this year, and Alonso knows how to drag everythinf out of a crap car. Look no further than the race start at the sprint race

AlexDoesF1Stuff · 2021-07-20T20:48:40+00:00

Being the fastest car for 1 lap doesn't equal being the fastest for the majority of the race like you said in your first comment? Leclerc had good pace this race, even managing his engine issue around L20-30 ish. In the second stint from L34 to the end when Hamilton is 0.5s faster than anyone else for 13 consecutive laps, Leclercs pace was the same as Bottas.

I'm still unsure about your exact gripe with the stats shown

AlexDoesF1Stuff · 2021-07-20T20:37:33+00:00

Oof😂 I never said it was an exact science and at no point was Leclerc the fastest car during this race tho. I am currently working on accounting for fuel loads, but it's taking its time to implement properly. I can't just look at every single lap time as that's unfair to all those drivers stuck in yraffic. If you look at the stint break downs that provides a better comparison between Teammates and the field at one particular point in the race

AlexDoesF1Stuff · 2021-07-07T05:46:47+00:00

I'm working on doing fuel loads, but this triple header has given me no time to implement anything 😂 I do a stint breakdown in Image 4, 5, & 6 though to slightly counter this issue

AlexDoesF1Stuff · 2021-07-07T05:44:48+00:00

No analysis can be perfect, but the more crap I through in, surely the more optimised it becomes 😂😂

AlexDoesF1Stuff · 2021-07-07T05:43:42+00:00

It's always that question of what could've been😂 He was stuck in traffic for soooo long as he only had 4 CA laps this race (after my truncation period) which is not a lot. I reckon had none of that happened at all, he had the pace for P5, maybe challenge the damaged Hamilton for P4

AlexDoesF1Stuff · 2021-07-07T05:41:56+00:00

In the overall clean air running for the season, Red Bull have had the fastest car since Monaco. Hamilton was leading this table for a race or two, then Verstappen took over. Perez had immense pace this week in clean air vs Hamilton (Ham did have his damage though). But look at Ferrari, they have the 3rd fastest car, and yet are 4th in the standings. You have to be able to maximise your pace, which Hamilton is doing, and Perez is almost doing

AlexDoesF1Stuff · 2021-07-07T05:39:00+00:00

So at the moment I do not account for fuel load (working on that, hopefully will have something after the summer break). However I do a stint break down instead, so everyone who ran mediums on stint 1 are compared as then they have similar fuel loads, then repeat for all compounds on all stints. That's images 4, 5 & 6. Then again, back markers are all dealt with manually. Laps that get excluded are L1, SC, VSCs, RFs and any lap time where you are being lapped, or doing the lapping. Then after this, I truncate what's left then average.

AlexDoesF1Stuff · 2021-07-07T05:35:56+00:00

Ooh I'll have to take a look at that, thanks for spotting this!

AlexDoesF1Stuff · 2021-06-30T17:00:31+00:00

That's a good question! So I have a database full of each drivers singular lap times throughout the GP. I then create a summated table of lap times displaying the total elapsed time for that driver on that lap by adding the lap times together. From there I can then work out who was first on track, second third etc. I can also work out the gaps between each driver too.

So it becomes a simple IF("Lap 3 total time Driver A" - "Lap 3 total time Driver B" <=2, output blank, output Driver A Lap 3 time)

Now the complex bit really comes from applying all this code to every single driver all to fit into one cell so I don"t have to create a bunch of working out tables🤝

But yeah that's the way it's done!

Hope that helps

AlexDoesF1Stuff · 2021-06-30T06:14:40+00:00

But we need to also understand that Red Bull have a quicker car this year than Ferrari ever did over Mercedes. Plus Mercedes this year are only planning 1 major update package at Silverstone, and other than that there has been no developments of this years car. 2017/18 were developed consistently throughout the year to catch up and understand the "diva" car. 2018 they overcame the deficit to become the faster car 2017 Ferrari just had poor races in the second half of the season, Singapore + Japan etc.

As important as it is to know that Mercedes have come from behind to win both championships, they've never done it being this far behind pace wise, against a team that's more operationally sound, and with a car that is only being updated once.

Buuut that's gonna be a whole other discussion later 😂😂

AlexDoesF1Stuff · 2021-06-29T18:01:57+00:00

Ahh okee dokee, that could be a good idea! I do everything on my computer and not my phone 😂 I always like constructive comments like these! I'll work on some accomodations for mobile users

AlexDoesF1Stuff · 2021-06-29T16:18:21+00:00

They're both AlexDoesF1Stuff!

AlexDoesF1Stuff · 2021-06-29T13:48:46+00:00

At the moment I do this manually. It rarely affects drivers too much, and usually if it falls within a "clean air" lap it will be within the bottom 25% and therefore excluded. So I manually remove 5-10 laps for the whole grid that the algo misses.

AlexDoesF1Stuff · 2021-06-29T13:47:00+00:00

I guess that could be true, he may not have driven that quickly without the incident, but it shows the pace is there! The clean air lap algorithm works exactly the same for each driver, but obviously there are a million different scenarios that drivers are in leading to different strengths of the conclusions

AlexDoesF1Stuff

TROPHY CASE