Monday, May 23, 2011

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.

No comments:

Post a Comment

There seem to be a few issues with posting comments. I think you need to preview your comment before you can submit it... Any problems, send me a message on twitter: @psychemedia