GT5 Used Car Database [in progress]

Discussion in 'Gran Turismo 5' started by Famine, Nov 27, 2010.

  1. AspecBob

    AspecBob Premium

    Messages:
    1,909
    Location:
    Canada
    That site uses the lists that we are building in this thread. If it's down, just use the spreadsheet: the link is in TornadoAlley's signature (4 posts above yours).
     
  2. iainoflo85

    iainoflo85

    Messages:
    5,068
    Location:
    Scotland
    I don't know how it works - all I get is a Google Docs document that I can't do anything with. How does it work?
     
  3. TornadoAlley

    TornadoAlley

    Messages:
    405
    Location:
    United States
    You will need to download the spreadsheet to your computer (it's an Excel file). Click on File and then select download. Then you can use the first worksheet to search for where you are in the list (if there is a match).

    The spreadsheet isn't quite as slick as the website but I don't have any web-programming experience and don't have time to learn.
     
  4. iainoflo85

    iainoflo85

    Messages:
    5,068
    Location:
    Scotland
    Downloaded the spreadsheet but can't get the bit on the first page to work, so looking manually from the last day the site worked and going from there.
     
  5. TornadoAlley

    TornadoAlley

    Messages:
    405
    Location:
    United States
    Occasionally people have trouble if they have disabled macros in Excel. The spreadsheet requires them for the search to function.
     
  6. iainoflo85

    iainoflo85

    Messages:
    5,068
    Location:
    Scotland
    It wasn't that - I just didn't read the instructions - and started typing in the names of the cars, lol. Then I realised looking at it again that it says "drop-down menu". Sorry about that, lol.

    But really nice database - more info than on the gt5cars website, you have odometer and colour as well as pp and price, so I love this more.

    I just wish there was a way of keeping track of the cars that I have when I get them with this spreadsheet, like I can do with gt5cars.
     
  7. TornadoAlley

    TornadoAlley

    Messages:
    405
    Location:
    United States
    Glad you got it working. :tup:

    I'll have to think about a way to incorporate that...
     
  8. AspecBob

    AspecBob Premium

    Messages:
    1,909
    Location:
    Canada
    This should now finish patching another gap.
     
  9. Stefanisonline

    Stefanisonline

    Messages:
    10
    Location:
    Netherlands
    I checked ML1 and ML2 but on both I didn't see two Sauber Mercedes C9's at day 2536 so in what list am I?
     
  10. AspecBob

    AspecBob Premium

    Messages:
    1,909
    Location:
    Canada
    You would need to figure out what your offset is, not many people will have the exact same day number that is on the lists. Just use the first sheet to find out where you are in the list.
     
  11. Wagon Drifter

    Wagon Drifter

    Messages:
    19
    Just curious: but if one moves from a PS3 to another PS3, and begins playing on the newer hardware, does that change the place you are in the lists?

    I imagine that my original saves from my old ps3 which i backed up might stay on their spots of the list, and a new account on my new ps3 will start somewhere new. Has anyone tested this?

    I.e: I am on day 650 which is ML1 day 680 minus 1 from an old PS3 that has since been lost. does that mean that on this PS3 it is +30 minus a car, or on my old PS3?

    Edit: hell I'll start a new account on it and see if I get Day 31 minus a car as my day one or not.

    Edit 2: indeed my new account starts as ML1 day 31 minus a car ... I imagine its next to impossible that the two different PS3's had the same list and start point, statistically extremely unlikely, so I would have to think that when i started on my new PS3 the account I had saved from the old one started updating the list using a different start point. I can't confirm because I don't have the old PS3 anymore, but its probably decent to know.
     
    Last edited: Nov 26, 2012
  12. TornadoAlley

    TornadoAlley

    Messages:
    405
    Location:
    United States
    I (and others) checked this early on and if you switch hardware then you will be in a different spot in the lists.

    I seem to recall that if you used the same game saves it will still change where in the lists you are. Someone else might be able to confirm that.
     
  13. AspecBob

    AspecBob Premium

    Messages:
    1,909
    Location:
    Canada
    I switched PS3 once, and that is exactly what happened.
     
  14. ajns73

    ajns73

    Messages:
    1,106
    Location:
    United States
    Confirm x2. I think we decided that whatever the offset is, it is generated relative to some hardware setting as a result of this.
     
  15. Duck

    Duck

    Messages:
    2,624
    Location:
    Italy
    List #2:
    - update: day 4897.
    - revision: day 723.

    Still never saw 107 car versions (!)
     
    Last edited: Nov 29, 2012
  16. Musolini187

    Musolini187 (Banned)

    Messages:
    317
    Location:
    Netherlands
    ill be using this http://gt5cars.net/used_car_searches to find my missing cars. zz kaira, toyata gt1 and the mclaren f1 gtr. ive seen these cars only ones, they gotta be rare.
     
  17. Famine

    Famine Administrator

    Messages:
    69,479
    Location:
    United Kingdom
    GT5cars.net uses our UCD data as its source :D
     
  18. Duck

    Duck

    Messages:
    2,624
    Location:
    Italy
    And also it's 9 months without updates :sly:
     
  19. Duck

    Duck

    Messages:
    2,624
    Location:
    Italy
    #2 list updated: day 5034
    Revision up to day 876
     
  20. Wagon Drifter

    Wagon Drifter

    Messages:
    19
    Then where i see missing info in master list 1 around day 850 or so, is that mileage/cost info missing? Cause I'm there atm, and started taking pics of the UCD from the Mitsubishi 3000GT that is first unmarked for miles/cost

    I've probably got about 8 days of new info atm if thats the case, where can I add it?

    Edit: just got that dang CZ-3 Tarmac that never shows up!
     
  21. McMike

    McMike

    Messages:
    25
    Location:
    Belgium
    i only need:
    Chaparral 2J Race Car '70
    Pescarolo Sport Courage C60 - Peugeot Race Car '03
    Spoon S2000 Race Car '00
    Mercedes-Benz 300 SL coupé '54
    Cheverolet Z28 '69

    for as long as 1 know i only seen the chaparal and pescarolo only once and don't think i recall seeing the S200 entirely..

    the merc and chevy i missed and so far haven't seen them since, anyone can trade those i'ld be glad :)
     
  22. iainoflo85

    iainoflo85

    Messages:
    5,068
    Location:
    Scotland
    The bolded ones were only available from the OCD because they're standard versions of premium models.
     
  23. McMike

    McMike

    Messages:
    25
    Location:
    Belgium
    i know i bought all the others but i missed those 2 :(
     
  24. DarioZ

    DarioZ

    Messages:
    8
    Could someone please direct me to the link for the lists updated by Duck above.
    Many thanks
     
  25. TornadoAlley

    TornadoAlley

    Messages:
    405
    Location:
    United States
    I am working on updating all of this lists at this moment. Expect to have everything uploaded in the next 10 minutes. See my sig for links.

    Edit: Update completed. I've added a google spreadsheet for master list 1 and another sheet for master list 2. These can be viewed online by anyone. The top link in my sig is a Microsoft excel document that has a built in search function and contains all of the data for both lists in one file.
     
    Last edited: Jan 13, 2013
  26. DarioZ

    DarioZ

    Messages:
    8
    Thank you TornadoAlley:)
     
  27. LeGeNd-1

    LeGeNd-1 Premium

    Messages:
    6,006
    Location:
    Australia
    Has anybody actually seen the list reset? As in, on which day will the UCD show Day 1 cars again? I've heard numbers of 10,000 but nothing confirmed. Thanks.
     
  28. ajns73

    ajns73

    Messages:
    1,106
    Location:
    United States
    You can answer this one by answering the following:

    How many licks does it take to get to the center of a TootsieRoll TootsiePop?

    Sorry. The answer is no one has confirmed the list repeats.
     
  29. LeGeNd-1

    LeGeNd-1 Premium

    Messages:
    6,006
    Location:
    Australia
    Okay thanks. It's just that I'm on day 5000+ and I'm hunting down the last few LM race car colours, but they never show up or they keep showing up in colours I already have. Using the gt5cars website it always shows my UCD is not on record. Makes me wonder if the UCD doesn't loop at all...
     
  30. ajns73

    ajns73

    Messages:
    1,106
    Location:
    United States
    It most likely doesn't. If colors are what is hanging you up, you may want to try the Marketplace to get the last colors you need through trade. Also, read the OP. TA's latest update will make it the most current rendition of what we know about the UCD cycle. Unfortunately, after an update about 6 months ago, GT5cars has gone silent again. This is no guarantee that the info you need will be in that update (or that it will be the answer you want even if it is), but it is more current than gt5cars right now.