GT5 Used Car Database [in progress]

  • Thread starter Famine
  • 1,863 comments
  • 423,283 views
Goes a little further, in that (for road cars):
Cars manufactured 2006 onwards only have a mileage lower than 25,000km. Then...
2005 less than 30,000km,
2004 less than 35,000km,
It continues in a not-quite regular intervals until any car 1995 or earlier can be anything up to 99,999/100,000km.

The 300,000km cars are early/mid 60's but seems to depend on car type as much as a particular cut-off date.

Race cars appear to only be < 8000km, tuners < 3000km, concepts < 300km.
 
CLIBBY34
Goes a little further, in that (for road cars):
Cars manufactured 2006 onwards only have a mileage lower than 25,000km. Then...
2005 less than 30,000km,
2004 less than 35,000km,
It continues in a not-quite regular intervals until any car 1995 or earlier can be anything up to 99,999/100,000km.

The 300,000km cars are early/mid 60's but seems to depend on car type as much as a particular cut-off date.

Race cars appear to only be < 8000km, tuners < 3000km, concepts < 300km.
Click to expand...

I never thought of it , before you did your math for the list you created.

Now that you've completed that list I might think again before posting my own list of UCD car values.
I haven't used excel of any other application to collect the values thought , only memo and calculator.

I had got as far as collecting the values for all under 500,000 Cr. cars , because they could be sold.

Car prize as new = sell value divided by 0.3

Many cars cannot be sold , thus I started to collect those car's mileage and prize data to get an idea of the 0km values for them.
At some point during this data collecting I found out that 200000 is approximatedly the number of kilometers from which the car values are counted from.

How many kilometers left out of that 200000 was left = the car value.

I've been tracking this subject awhile now.

The first thread about car values vs mileage calculations.

UCD Kilometers vs. Years thread.

KM to Miles How does PD do math? - thread

So far we have pretty good idea how the mileage vs prizes work for cars in GT5 .

Next thing we could try to investigate is mileage vs power. - Wear down.

So far there is a thread about - Engine break-in, wear, overhaul, and oil change .
And Engine Overhauls Investigated. - link



MadMax
 
Thanks for those llinks, were a few I had no idea about - the search function can be very hit and miss!!

And yes, Excel makes things go a lot quicker, took about 2 hrs to calculate the 'new' prices I think (I used the UCD spreadsheets as a starting point, and expanded from there. Also meant I could test that the value and formula works for ~15-20 cars of each type).

Have had a (very) small look at mileage vs power, but need to compile myself some more data first. It's looks like it's different for each model, but need to look further to confirm...


Back onto original topic (:D) I'm slowly progressing a second account now, when I get up to where needed (whenever that may be!), I'll get filling in. With the autofill, it's probably just as quick to fill to fill in as you go along as it is to take photos and upload!!
 
CLIBBY34
With the autofill, it's probably just as quick to fill to fill in as you go along as it is to take photos and upload!!
Click to expand...

What do you mean by autofill?

Luckily i have the PS3 running on one monitor and my PC on a second right next to it. So after collecting 5 new days of UCD, whichever way (racing, licenses ...), i go through each car from bottom to the top and fill the data into my Excel spreadsheet on the PC.

Edit:
Regarding the original prices of cars. Here is a carlist with most the values in it.
 
I too, use a netbook with a ods sheet. Only help I use are abbreviations: I enter an abbreviation and a formula translates it into the full car label. I'd like a configurable autofill from upper cells, but Calc can't manage the 2500 paint names....
 
Check the excel attachment here, you'll have to enable macros.

Is a relatively simple set-up where you can double click in a cell and start typing, and it will select the next make/model with those characters. You can use up/down arrows to quickly locate nearby cars, or the drop down arrow to select normally.


Re. the paint names, you could probably group them by car type? So you'd have car make, a limited option of car models dependent on the make, then a further limited number of paints dependent on the car type?
 
One month ago! I completely missed it. Will give a try using it as a template for paint autofill.
 
TornadoAlley
The database in my sig is much more up to date. I hope to do another update on it this weekend. It isn't web based though which means you need Excel or something similar to use it.
Click to expand...

Yes I use it 👍

but now I am at day 6701 with one of my account :rolleyes:

:cheers:
 
Patclash
Hi, Duck,
but the database of this site asn't been update since 2011-05-21 :(
Click to expand...
I 'm aware of it, but fortunately they did further updates without changing the credited one (just forgot that one, I guess). The webmaster is also a GTP user. You can find some posts of him in this thread too.

Patclash
Yes I use it 👍
but now I am at day 6701 with one of my account :rolleyes:
:cheers:
Click to expand...
I was in day 3018 when started editing UCD lists, and was August 2011 after 9 months of play. Now in December I'm still in day 3610 :P This job slows down gaming a lot.

@all editors, users and TornadoAlley:
I was thinking about skipping PP and credits, as imho are quiet useless at this point compared to km and paint. What do you think?
 
I think that price is important. If somebody wants a car but doesn't know how much it costs, then they can look and see what the upcoming one will cost and save a certain amount of money for it.
 
Credits can be calculated exactly (barring a few expensive race cars, which would only be 1 credit out) from the mileage for all cars, so I would say yes that can be dropped.

I'm pretty sure the same could be done for PP, but I'm not aware of anyone that has found the PP/mileage drop-off ratios yet? Would likely be twinned with PP calculation, and that's still a ways off I believe...
 
Powermarty
I might be able to fill some gaps in ML #2

Days 1287 - 1477/78 (start is aligned to existing sheet from Tornado's link, end is 1 off because of my offset)
https://docs.google.com/spreadsheet/ccc?key=0AsdZjh5pbLDodHhscFhqTkl5ZENNUi1kRnIwTXRCWkE

I also added the race-/rally-car starting number, where available, and the color (guessed by me) in brackets in the color column for cars which have no color mentioned in the game. Reason for this is that sometimes different colors are available for those cars (e.g. Ford RS200 in Red and White, New Beetle Cup cars in different colors ...)

Edit:
01.12.2011: Updated till day 1515
02.12.2011: Updated till day 1549
03.12.2011: Updated till day 1579
05.12.2011: Updated till day 1609
08.12.2011: Updated till day 1654 (somehow i missed one car on day 1649 :grumpy:)
10.12.2011: Updated till day 1707
Click to expand...

Ok, i filled the gap. :)

Unfortunately i somehow missed 1 car at day 1649 (i still don't know why and i still could kick my a.. for it). So the last car for day 1648 and the four cars for day 1649 could be off by one spot. :grumpy:

Also day 1707 in my spreadsheet is actually day 1708 in TornadoAlley's spreadsheet. I don't know where this one day difference is coming from. Me missing a day or the TornodaAlley' spreadsheet is one off after the gap.

By my calculation my sheet looks correct:
I started at day 1287 (included) and finished at day 1707 (included). This is 421 days. With 6 lines for each day it should result in 2526 lines in the spreadsheet. And that's what i have. :confused:

I also corrected some typos in the carnames over my whole document and inserted the complete data again in the Google-Doc. So whoever already downloaded the partial data should download the complete data again.
 
Last edited:
beeblebrox237
I think that price is important. If somebody wants a car but doesn't know how much it costs, then they can look and see what the upcoming one will cost and save a certain amount of money for it.
Click to expand...
Price ranges and PP are easily found in mygranturimo.net or similar resources.

CLIBBY34
Credits can be calculated exactly (barring a few expensive race cars, which would only be 1 credit out) from the mileage for all cars, so I would say yes that can be dropped.

I'm pretty sure the same could be done for PP, but I'm not aware of anyone that has found the PP/mileage drop-off ratios yet? Would likely be twinned with PP calculation, and that's still a ways off I believe...
Click to expand...
... also buy the car, change the dirt oil and UCD list PP become useless.....

Powermarty
Ok, i filled the gap. :)

Unfortunately i somehow missed 1 car at day 1649...
Click to expand...

Great. I just wonder how you did it in this short time :drool:
Don't worry about the missing, my accounts are slowly approaching...... really slowly :D

EDIT: so I'm not alone with that feelings about PP and Cr. Also, as I use an offline sheet for collecting data, with a matrix formula for carnames, would be a joke adding a price vector and the n = u / (1 - 0.000005 * k) formula. As I find a good reduction rate for PP, I'll extrapolate that data too, rather than manually collecting. Any clues about the 1Cr. roundup for expensive cars? Can be easily fixed with an IF...
 
Last edited:
Powermarty
Also day 1707 in my spreadsheet is actually day 1708 in TornadoAlley's spreadsheet. I don't know where this one day difference is coming from. Me missing a day or the TornodaAlley' spreadsheet is one off after the gap.
Click to expand...

Ok, i think i found the solution while continuing. I had 2 days to fill the day 1714 gap in TornodaAlley' spreadsheet. In my spreadsheet, where the days 1708-1713 from Tornado are moved one day ahead to 1707-1712, i had a 2 day gap at day 1714. From day 1715 on we run in sync again.

(Added the link to my spreadsheet to my signature)
 
Error in TornadoAlley's spreadsheet for day 1785:

1785 Alfa Romeo - Giulia Sprint GTA 1600 '65 388.039 63.264 366 Bianco Spino
1785 Subaru - LEGACY Touring Wagon 2.0GT spec.B '03 5.868 29.411 439 Atlantic Blue Pearl
1785 Alfa Romeo - Giulia Sprint GTA 1600 '65 10.661 106.986 375 Rosso Alfa

Both Alfa's are Giulia Sprint GTA and not Giulia Sprint Speciale.
 
Powermarty
Error in TornadoAlley's spreadsheet for day 1785:

1785 Alfa Romeo - Giulia Sprint GTA 1600 '65 388.039 63.264 366 Bianco Spino
1785 Subaru - LEGACY Touring Wagon 2.0GT spec.B '03 5.868 29.411 439 Atlantic Blue Pearl
1785 Alfa Romeo - Giulia Sprint GTA 1600 '65 10.661 106.986 375 Rosso Alfa

Both Alfa's are Giulia Sprint GTA and not Giulia Sprint Speciale.
Click to expand...

I'll get those corrected. Is the mileage/color alright for those?

I'm sure that is the first of many small entry errors.

I'm working on getting the database updated with everyone's most recent data so hopefully I can get that uploaded soon.
 
TornadoAlley
I'll get those corrected. Is the mileage/color alright for those?
Click to expand...
The mileage and color was correct. The same as mentioned in my post.

No surprise of slight errors with this amount of data. It will need several verifications by different people to get correct.
 
That's good - those were two of the bigger anomalies I found when I was calculating 'as new' prices, I was worried as there were two of them - a single error I may have dismissed haha!

Also, looks like the GTA is the only one of the two that can be found with over 300,000km then...


I did find a couple more instances that looked like they could be a case of mistaken identity, rather than a mileage/price typo (not guaranteed mix-up, could be a typo I've not been able to work backwards with...):

Lancer Evolution VI GSR T.M. '00 - ML1 days 3309 & 3358.

Renaultsport Clio Renault Sport V6 Phase 2 '03 - ML1 day 1235.
Clio Renault Sport 2.0 16V '02 - ML1 day 1134
 
Last edited:
I hadn't thought of using that technique to look for errors. I will try and check the original files to see if I come up with anything.

Occasionally the car entry name is wrong and I have to make a guess as to what the most likely mistake was (car name and year don't match for example). In those cases I might make the wrong call on what the correct car is.
 
I used the price/mileage formula to look for errors a while back. There were plenty of anomalies that I made a note of and maybe plenty more I didn't make a note of. A little bit of trial and error usually gave me a number where there would most likely be a typo. I didn't consider it to be fully confirmed though so in the end I never raised the issue.

I also have 3 Impreza Sedan Version VI entries at ML2 days 1798, 1799 & 2306 recorded as LV5 when they should have been LV6.
They might be Impreza Sport Wagon Version VI which should be LV5, but they have the same price so I can't say whether I entered the wrong car or the wrong LV.

Glad to see the big gap has now been filled.
Big 👍 for all the ongoing work.
 
Hey guys, im looking for the Mercedes 190 Evolution Touring car. Ive only seen it once and that was in the Online car dealership. Im around day 2000, anyone know when it will appear?
 

Similar threads

M
Help with the FGT in GT5
Replies
3
Views
1K
MrGranTurismo
M
Raisen
In game issue with GT5 in RPCS3
Replies
5
Views
2K
OriginalCheezIt
OriginalCheezIt
CustomX
Used Car Dealership availability alerts for engine swap compatible cars
Replies
1
Views
2K
GTboyz
GTboyz
M
A Theory On Leftover PS2 tracks in Gran Turismo 5
Replies
2
Views
2K
MrGranTurismo
M
ArtekFantasy
GT Event Editor
Replies
6
Views
4K
Dave A
Dave A

Latest Posts

Back