12.64%

  • Thread starter raceur
  • 2 comments
  • 1,329 views
The average difference between the Normal and Tuned times for the top 450 drivers. Maximum variations 11.48 and 13.97%.

May help if you're wondering which car to work on. I left the Tuned till about a week ago and was wondering what time I could expect to achieve and this is one way to know whether you're in the ballpark or are doing much better on one that the other.

If you want to play around with your own stats from:

http://gtdb.net/?tt

simply select the table and Paste Special, Plain Text it into an Excel spreadsheet and you're away. It comes out nicely formatted into columns and rows and from there it's easy to ask the data a few questions.

The times come out like so:

1'35.418 1'47.495

which can't be worked with directly, but if you do this:

=MID(D5,3,10)+60

where cell D5 is say the 1.35, that'll pull out the seconds, add 60 and then you have a number to work with. I'm now going to say:

"there is no better way to do that"

thus invoking the wrath of the Internet gods and ensuring that at least 500 people will promptly post a much better formula, from which I can take careful notes.

Anyway hope this is of interest.
 
If you're logged in at gtdb, you can pull all records (nearly 5,000) in one go as a csv file:

http://gtdb.net/?tt/csv

(Columns 3 and 5 are the update time - in seconds since 1970-1-1 - of the preceding lap times in columns 2 and 4. This value is 0 if the record existed before 2010-1-4 0h GMT. Last column is the controller type.)
 
Nice idea with time difference between 2 cars raceur.

Mine is currently 12,635% hahaha - which should I work on then ? both ?;)

For top 4956 players it is 12,798 %, min 7,738% PADA driver max 18,777% also PADA driver

standard deviation - 0,725% ;)

So mine tuned car time could be few thousandths better...

BDW I always changed 1' to =60+ ... :)

This csv file is the best, thanks again zabeu.
 
Last edited:
Back