Topic: Pointless Race Analysis
So what does a more or less retired engineer/scientist do after the race is over? Build a massive spreadsheet and analyze the data to death.
So here are some of the results from the recent Pointless race:
First, I start with us.
Laps Completed: 220
That sore of sounds like a lot, but the winner completed 281 laps. Normally, or rather recently, the winner is only about 30 laps ahead of us at the end of the race.
Miles Raced: 523.6 miles
The track distance was not include in the MyLaps or Specialty Timing reports so I just added 0.1 mile to the distance given for last fall's the Skankaway race.
Overall Position: 73, 42.69%
This sure isn't in the range we had been doing lately, but at least it is not our worse finish. Hey, it's a silver lining, even if it is tarnished.
Cars in Class: 57
Position in Class: 19, 33.33%
Number of Cars that Passed Us: 2001, or 9.10 per lap
It felt more like 30-40 cars per lap passing us. To get this number I just added up the number of laps more cars finishing ahead of us completed.
Number of Cars We Passed: 7085, or 32.20 per lap
I like that number. Unfortunately, most of our passing was of cars that were in the pits or on the trailer. To get this number I just added up the number of laps more cars finishing behind of us completed. This does not include cars with laps less than 0 laps. Maybe I should redo this one using results from cars that finished the race, but then it would probably drop to around 0.5 per lap.
Cars in the Race: 171
This includes cars that never completed one lap.
Hours Racing: 14.41
This was averaged from the total time raced by the top 5 cars.
Best Lap Time: 123.137 seconds, 2.03.137
Eyesore. Who did you expect?
Worse Lap Time: 206.748 seconds, 3.26.748
Pink Lloyd, and this probably included a tow, or push, or coasting half a lap. The back half of Infineon is slightly down hill. I can't wait to see the Lloyd running after its teething problems are taken care of.
Average Best Lap Time: 138.885 seconds, 2.18.885
We were slower than this, again, damn it.
Best Lap Speed: 69.58 mph (Eyesore)
Slowest Best Lap Speed: 41.44 mph (Lloyd)
Average Lap Speed: 62.07 mph
Cars Taking the Checkered: 118
This was estimated based on total race time plus time for two more laps.
Cars Not Taking the Checkered: 53
That's a failure rate of 31%
Total Laps Raced: 32536
I just added up everyone's laps.
Average Laps Raced: 194.83
At least we were above average in this category.
Total Miles Raced: 77435.68
Oldest Car: 1958, 54 years old, the Lloyd.
Newest Car: 2004, only 8 years old
Typical Age of Car: 1985 at 26.59 years of age
It's time to start shopping for the next model year LeMon, 1986!
Number of cars over 40 years old: 8
The Tinyvette is in his category.
Number of 40 or older C Class Cars: 4
It seems like all 40 year old cars would be in class C, just because.
Class Number of Cars Best Lap Time Average Lap Time Laps Completed Average Laps Completed Penalty Laps
X 4 123.137 147.54 803 200.75 2
A 88 124.962 133.45 17676 200.86 227
B 57 128.103 136.44 10571 185.46 32, plus 2.5 billion
C 22 138.683 152.74 3486 158.45 2
Total: 171 - - 32536 190.27 263
(The tabs/columns looked OK when composing this, but get screwed up in preview. Sorry.)
Distance traveled: 3.11 times the circumference of the Earth and nearly 1/3 the way to the moon. Not bad. But only 0.08% of the way to the sun, but, 10 billionths of a light year.
Estimated mpg: 12.41 mpg
This estimate is based on a 5 gallon/hour usage and average lap times.
Estimate Fuel Usage: 6237.76 gallons
About a tanker truck full, but not a small truck.
Estimate Carbon Footprint: 61.13 tons
I know you really care about this one, but it is still a fun number. 60 tons is equivalent to about 1/3 the weight of all of the cars in this race, assuming 2300 pounds per car.
More to come.