You might like to check this over, but I think it's ok - I had some spare time in the office, so taking Johhny's numbers from Rd3, I came up with this:
But by no means am I trying to take this over from you..
Caution .... although it shouldn't make much, if any, difference in the standings, I can't seem to figure out how to get my excel to work in inches, so the last two digits are a percentage of a foot. So if the final two numbers are .34, that equates to 4 inches.
I gave Kerry the actual laps (lap length is 71 feet, 4 inches) as well as the feet and inches for each car on the last lap. I think he's making sure my formula works and is correct before posting the final results.
Last edited by JohnnySlots; 06-06-2012 at 12:46 PM.
Just realised there's a bit of a problem in the overall spreadsheet - the formula for total distance (cells BF...) is missing the addition of Round 4 (cells AP...) - so the totals are still of just the first three rounds....
Anybody would think I stare at spreadsheets all day....
Just realised there's a bit of a problem in the overall spreadsheet - the formula for total distance (cells BF...) is missing the addition of Round 4 (cells AP...) - so the totals are still of just the first three rounds...
So does this mean that actually, I'm now leading, Tony?
I like numbers and trying to make sense of the results but heck if I can see any real correlation in this years final standings.
Anyone see anything of note in the statistics?
The one thing I saw was the the rankings of average G on the skid pad came the closest to the final standings as anything else.
If the skid pad results were close, I would say that you were successful in matching the track & race conditions (humidity, temperature) of most hosts in 2012. Although your results show that my car did an average of 1.5G on your skid pad, the results, in G, on my skid pad were a lot greater.