The ten best track cars, chosen by a spreadsheet

I’ve often wondered how successfully one could choose a car by looking purely at numbers, and nothing else. So, without further ado, here’s my list of the best road cars to drive on a race track, as declared by my spreadsheet.

Position Car

1st


Tesla Roadster Sport

2nd


Porsche Cayman R

3rd


Lamborghini Gallardo Coupe LP 570-4 Superleggera

4th


Ferrari 430 Scuderia

5th


Porsche 911 GT3 RS 4.0 Coupe

6th


Audi TT Coupe

7th


Audi R8 GT

8th


Aston Martin V8 Vantage S Coupé

9th


Mercedes-Benz SLS AMG

10th


Audi S4 Sedan 3.0

Okay, there you go. That’s that decided. Now, should you be interested, here’s how I got to this list.

  1. I downloaded the textfile version of Freebase’s automotive data
  2. I loaded it into Excel. I am now looking at 23, 812 cars
  3. I filtered out all the automatic transmissions – down to 6392 cars (presumably this data is somewhat skewed towards America)
  4. I filtered out the front-wheel drive cars – down to 5312
  5. I filtered for 0-60 times of less than 6 seconds – down to 355
  6. I took the lightest ten by curb weight

Here’s the list I had at this point:

2010 Tesla Roadster Sport
2010 Tesla Roadster
2011 Tesla Roadster Sport 2.5
2011 Tesla Roadster 2.5
2011 Porsche Boxster Spyder
2011 Porsche Cayman R
2011 Porsche Boxster Spyder AT
2011 Porsche Cayman R AT
2011 Porsche Cayman
2011 Porsche Boxster

The list is actually fairly reasonable, although unfortunately it’s not very exciting, because it only contains cars from two manufacturers, and a limited set of models at that. So for each car model we’ll take only the lightest, because they make the best racing cars anyway. This cuts my list down to:

2010 Tesla Roadster Sport
2011 Porsche Boxster Spyder
2011 Porsche Cayman R
2011 Lamborghini Gallardo Coupe LP 570-4 Superleggera
2008 Ferrari 430 Scuderia
2011 Porsche 911 GT3 RS 4.0 Coupe
2012 Audi TT Coupe
2011 Porsche 911 Carrera 4 Cabriolet
2012 Audi R8 GT
2010 Nissan 370Z Roadster

The only problem with this new list is the presence of the convertibles. Without trying to get into mud-slinging here, it’s a fairly well-established fact that convertibles don’t have great structural rigidity and so the hardtop version of a given car will normally race better than the convertible. It’s certainly true that when a car has both convertible and hardtop versions, the manufacturer does not tend to race the convertible. Fortunately there are no rag-tops here without a hardtop equivalent, so I didn’t feel too guilty when I filtered out the convertibles manually, leaving me the list at the top of the article.

Obviously this system of selecting cars isn’t perfect, but there are a few caveats beyond even that in this specific data set. The Freebase database has hardly any weights for cars more than two or three years old, and the acceleration figures are missing for many. I’d love to have included some other factors (lap times; weight distribution; price) but these things aren’t present in the data set.

The exercise did teach me a few things, though. First off, Aston Martins and AMGs aren’t quite as fat as I thought they were, and neither is the Tesla roadster, despite all those batteries. Next was the heavy presence of Audis, which aren’t really known as especially wonderful track cars, and the entire lack of BMW, which are (the M3 fell just short of the top ten). And the complete lack of my own car (but hey, maybe this shows I’m unbiased).

Ah well. It turns out there’s more to cars than numbers. But you knew that.


Want to do your own filtering? Download my spreadsheet and play away.

Posted in cars | 1 Comment

Mind the bollocks: A quiz about Britain



Many people have asked me whether I have ever written a quiz about Britain, to go along with my horrible book. Well, actually, only one person. No matter. I have now written a quiz.

Oh yes, I know you're sitting thinking "I don't have time for this nonsense". But, let's be honest, you're sitting at work, and what you're working on is so late that, frankly, ten minutes isn't going to save it.

If you get answers wrong, you can try them again (but you'll get fewer points).
Start Congratulations - you have completed this terrible quiz, and wasted another fifteen minutes in the office.

You scored %%PERCENTAGE%%.

    Perhaps the most logical thing to do now is find some more details about the book you hopefully have in the back of your mind. Or visit the web site, where most of the book's contents are available free of charge anyway. Bugger. I knew there was some reason I didn't make any money from this.
Your answers are highlighted below.
Posted in book | Comments Off

Flickr Explore photo now up

As promised, I am going to get a photo on Explore. This, my friends, is that photo. Here goes nothing.

Click the photo to view on Flickr.

Posted in photograph | Leave a comment

Pictures of funny things from my phone

Like any other mobile phone owner, I occasionally take photographs of things that I find amusing. Often, like other irritating pedants, these are linguistic mistakes. More often than not, they involve things in quotations. These just languish on my phone… when I get a new phone, I copy them to it, and then they languish there instead. Occasionally after a few beers I get into one of those “everyone show each other the funny pictures from their phone” sessions, which is the only time they get an outing. Well, not now. Now I’m giving them to the world!

And, well, here they all are. They’re from a mixture of countries and date back to 2000 or so. Perhaps I’ll start a brand new collection, and blog about that in 2020.

There's cost cutting, and there's cost cutting.

For when the police coffers get low.

When autocorrect doesn't help.

It's like beer, but without the uncomfortable wetness.

The most important thing about goals is that they're attainable.

Honesty is the best policy.

No coming in here unless you have permission from the managing director! Or some excuse.

This never normally happens...

If you have to ask what's in the grog, you don't want the grog.

Sore cock? Try some nice wine.

When picking a web site URL, make sure it works in all variants of English.

A straightforward misunderstanding, I think.

It's on us!

For when you've had one of those days.

It's like shooting fish in a barrel, but I still "love" it.

A bag for my paintbrush? Yeah, sure, I'll take a bag. Oh.

45 days into the project, eight builders were fired.

Sure, you can cook. But can you name a restaurant?

Football scarves on sale on Basle, Switzerland. It's not so much who you support...

It wasn't so much a year as an emotion.

That’s all, folks. Get back to work.

Posted in photos | Leave a comment