Brought to you by TheJudge13 contributor Tourdog

It started with ICE’s, then gearboxes, now things have expanded a little. Lap times are where it’s at, and it was high-time somebody sorted through them.

So I did.

24,945 laps have been run in the 2015 F1 season from Australia through Hungary.

How do I know that you may ask?  Because I have inputted every single one of them into a spreadsheet.

Yes. Every. Single. One.

But it goes way beyond just lap times, because what good are lap times if you don’t know what tyre they were on? Or how much fuel they had in? or which turbo was in the car?

So I have compiled a much larger dataset for us to play with.

Here is an overview of the dataset:

So for each lap logged, the following information is logged with it:

• PU Manufacturer
• Gearbox Manufacturer
• Team
• Driver
• Race
• Session
• Lap #
• Lap Time (in seconds. example: a lap time of 1:12.237 is displayed as 72.237)
• Average speed (calculated as lap distance/time in Kph)
• Fuel Load
• Classification
• Points
• ICE #
• Turbo #
• MGU-H #
• MGU-K #
• Energy Store #
• Control Electronics #
• Gearbox #
• Chassis #
• Lap Distance
• Lap Type

Most of these are self explanatory. The options for the “Driver” category are limited to the drivers that have participated in at least one session in 2015, for example.

However, once I got things together, and I started to crunch numbers, I realised that the lap times were kind of useless. I had a whole lot of numbers, but there were some laps listed with a time stamp, instead of a lap time, some lap times were off the charts too long, there were lots of problems. This forced me to really look at HOW the times are compiled, and how I could use these times.

The first thing I needed to do was differentiate between “useful” laps, and worthless ones, and to do this we need to know how the FIA live timing works.

Let’s start with the mechanicals of it. There are timing beams laid out along the entire circuit length. These beams break the circuit into sectors (a maximum of 18 I believe) and allows the FIA to keep track of the cars. Each car has a unique transponder in the nose. When that transponder breaks the beam, a computer somewhere registers a time stamp in a database.

All we are really concerned with however, is the timing beam at the start finish line. Technically there are TWO timing beams at the start finish line. One beam spans across the track. The second beam spans the pit lane, and should be in the same plane as the circuit beam.

In practice and Qualifying, things are pretty simple. The clock starts the timing. Once the clock starts, the cars are free to leave the pits.

If a team’s garage is at the beginning of the pit lane, they will break the Pit timing beam, and the computer will register a time stamp.

If a team’s garage is at the end of the pit lane, they will not break the Pit timing beam. The first time stamp for one of these cars will occur once they either cycle back into the pits, or cross the start/finish timing beam.

Once the timestamp happens, what we will call the “Zero” lap time, each subsequent entry into the timing log will be a simple calculation of subtracting timestamps to come up with a lap time. This is how the FIA views their lap times, and then dumps the list of these times into a PDF file to post on their Website.

Unfortunately this makes it difficult to know what is actually the first lap a car runs the early session.

Example 1:

Let’s say Sauber is at the end of the pit lane, beyond the pit timing beam. We will use a random Lap time of 1:30.000.

FP1 starts, Nasr leaves the pit, circles the track, and immediately re-enters the pit. When he breaks the pit beam upon his return, the first timestamp happens. He now pulls the car in the garage for a 5 minute checkup.

Nasr leaves the pit again, and circles the track, this time not going into the pits, but continuing on across the circuit timing beams.

Nasr will now get his second timestamp, giving us a lap time for LAP 1, as 6:30.000.

But Nasr has done two laps.

Example 2:

Williams garage is at the beginning of the pits. At the end of FP2, Massa is running hot laps out on track. The session ends, and 30 seconds later he crossed the start/finish line.

This will register his last lap time. Massa then continues around the track, circling back into the starting boxes and does a practice start, circling the track one more time before parking in the garage.

The last two times Massa circled were not registered anywhere in the timing.

This of course doesn’t really matter in terms of useful information the Teams and Drivers can get out of the car, but an extra 2 laps per session on a PU in 2015 could add up to a statistically significant amount of distance when your PU only lasts 1000Km!

The race timing is a different ball of wax.

Think about how the races start. Unlike the Practice and Quali sessions, the actual “Lights Out” time for the race is random. Charlie decides when the race starts, not the clock.

So, the cars all form up in the start boxes, and once Charlie is satisfied, he will start the timing sequence.

Charlie presses and holds the start button, the lights count down, 5, 4, 3, 2, 1 and at 0, the computer registers a time stamp we will again call LAP 0.

Charlie, holds the start button until all the cars cross the start/finish line. Holding this button essentially “turns off” the start/finish timing beam, so that no cars register a time as they cross it.

The cars circle the track.

As each car crosses the start/finish, it registers a time stamp of that moment as LAP 1.

The second time a car crosses the start/finish (or pit) timing beam, the computer does a subtraction, and spits out a lap time.

The reason that this matters, is that NOWHERE could I find an official FIRST LAP time for any driver ever. The PDF files that the FIA makes public, have the time stamp as LAP 1, but since we do not know what the actual moment Charlie pushed the button was, we cannot calculate a lap time.

Even on the F1 app, and in live TV coverage, we never see a lap time for the first lap.

Go back and look, I didn’t realize it either.

So, in order to figure out what a driver’s lap time is for the first lap, we need 2 things, a sum total of all known lap times, and the official race classification time. Simply subtracting these two gives us a driver’s lap time for LAP 1. This is what I have done in our data for the races.

As far as the earlier sessions are concerned, I have not bothered to try and calculate a lap time. These times really don’t matter anyway. I have kept the time stamp as “Lap 1” in all of these sessions simply to signify that at least one lap was run, thereby getting us a little closer to being accurate in terms of distances.

I challenge you to find a lap time, anywhere online, for LAP 1 in a 2015 F1 race.

So now we know how to count laps, but the lap times given for some of these laps is way out out bounds, like  Example 1, I gave earlier. In order to be able to sort through these laps, I have given each and every lap a “type”, in the “lap type” field.

There are several different classifications of lap type, and they are as follows:

Pit: a pit-in or pit-out lap that is run during FP1, FP2, FP3, and Quali. These are always warm up or cool down laps and their times are useless.

Pit-in: Used to signify a pit-in lap during races only.

Pit-out: Used to signify a pit-out lap during races only.

Yellow: Any race lap run under a Yellow Flag.

Safety Car: Any race lap run under a safety car.

VSC: Any race lap run under a Virtual safety car.

Parade: every driver who makes it to the starting box before the formation lap gets 1 lap added to their race distance as a “parade” lap

Formation: Every driver that successfully makes it around the track and into their starting box for the green flag gets one lap added to their race distance as a “formation lap” (in Hungary all drivers got 2 formation laps added)

Podium: Any driver that crosses the finish line, gets one lap added to their race distance as a “podium” lap.

Green: is all Green flag laps in all sessions.

Scratch: This is my new catch-all for unwanted laps. Any lap whose time is beyond “normal” is called a scratch lap and thrown out of lap time calculations.

So what is a scratch lap you may ask?

As an example, after looking at all of his laps, I can see that Romain, in the early FP sessions, will often do alternating hot laps over a long run. So even numbered laps are often 8-10 seconds slower than odd numbered ones. This means Romain is alternating between hot laps, and cool-down laps, most likely doing practice quali runs. If we were to keep all of Romains lap times in our table as “green” laps, when we do our averaging calculations, Romains times are going to look comparatively slower. SO what I have done is filtered all of those slower laps out by calling them “scratch laps”.

Another example:

Sometimes the timing system freaks out, believe it or not. I have only seen it occur during FP sessions, but there are several occasions in the data, where anyone running out on track at a specific moment, will get 250 or so seconds added to a random lap time. Why? who knows, but it’s in the data, and the FIA PDF files do not call them out as Pit laps, so I have called those types of laps “scratch, as well.

Why should you care? Well, once we filter out any crazy, out-of bounds lap times, we can get a much clearer picture of exactly how fast a driver is. It also allows us to compare lap times on the same tire across multiple sessions.

At this point, I believe the largest hurdle to us getting right down to the meat of the data, is fuel loads. Fuel loads are something we just don’t have much data on. In an effort to narrow our focus, I have given one of several different types of fuel loads to each lap.

In FP1 for all races, fuel loads are “unknown”.

In all other sessions, fuel loads are either

• Unknown
• Heavy
• Medium
• Low
• Quali

We know Mercedes runs a heavy fuel load in FP2, and I figure Williams does as well.

We know Ferrari was running Medium fuel loads in FP2 up until June, since then I have them as running heavy fuel in FP2.

I have all teams as running Low Fuel in FP3

“Quali” fuel loads are listed for all qualifying sessions, and for the last 5-7 laps of all races.

The races are broken into chunks, with the first group of laps signified as “Heavy”, the next group as “Medium”, the next as “Low”, and, as I said, the final group as “Quali”.

It is by no means as exact as I would like it to be, but it is a start.

I would like to come up with a formula to calculate at least a rough percentage of load, but I am going to need someone with a little more expertise to help me come up with it.

Anyway. What all this work has done, is allowed me to spit out all of these wonderful graphs. We are working on a method for you to be able to search this data on your own, right here within the website, so keep your fingers crossed. Until then you can enjoy the tables I have started for us. If you have a suggestion as to a certain table or graph you would like to see, please leave a comment and I will see what I can do.

You can find all this good stuff in the CHANCERY’S ARCHIVE