F1 2011 Spain Race - Pit Stop Analysis

One of the things I've started trying to pull together is a "comprehensive" spreadsheet organised by lap-and-driver containing all sorts of data grabbed directly from FIA timing sheets and also derived from that data (see the Data page for links).

This mega-spreadsheet can then been re-mined to produce all sorts of different reports.

So for example, here's the pitstop times for each driver during the Spanish Grand Prix:



(The columns in this table are sortable; click on a column header to sort by that column.)

The essential data for this table was grabbed from the Comprehensive data sheet using a pivot table of the form:



Howto embed the interactive table: View Source to see how I embedded the interactive table using data pulled dynamically from a Google spreadsheet.