Car database and track overview

Discussion in 'Project CARS 1' started by davedauwerse, Aug 28, 2015.

  1. davedauwerse

    davedauwerse

    Messages:
    10
    I was wondering if there was an overview of a car database or something like that to decide what kind of car was the best for a race, but there wasn't any to find.
    So i wrote in excel a spreadsheet with a list of all the cars of Project Cars with al the information available that i could find.
    I also made a view to see how many horsepower (or pk) per kilo a car has, and i did some calculation fields about kilometers to miles etc. etc.
    In an other tab i show all the cars that i could find, and made a clear overview of all the track including the information about the tracks (for as far i could find the information)
    in practice this database appears to be very useful to me to make decisions, so i want to share this file[​IMG] with all the users of this forum, and hope the find it also useful as i do.

    Here's a direct download[​IMG] link[​IMG] of the excel file v1.2:


    For the people who only need the pdf file, or just want to see what the file looks like, this is the link[​IMG]:


    In the file there are 3 tabs, Car database, Cars and tracks.
    The cars and tracks are ranked alphabetically by name, which you can access with a button in top of the screen.
    If errors are discovered in the file, I would like to know so I can adjust them.

    Have fun with it.....


    UPDATE v1.3.1:

    Sort buttons (gray) have been created in the car database. Now each column can be sorted alphabetically from a-z with the button above each colmn.
    Ruf Rt 12R is added to the database and picture section.

    for the people who can appreciate my work, here is the direct download link for v1.3.1. (151,4Mb)

    To be able to use the sort buttons you need to turn on the macro's
    The file is scanned and virus free.

    Have fun with it




    The latest v1.5.0 update is available a this link:
    https://www.gtplanet.net/forum/threads/project-cars-database-v1-5-0-now-with-gear-overview.335401/
     
    Last edited: Oct 5, 2015
  2. Scuderia Paul

    Scuderia Paul

    Messages:
    5,600
    Location:
    Ireland
    Nice work and fair play to you for having the dedication required. I'll have a good look at it later.

    Putting the password on a public forum and then asking for it to not be shared is a little odd though.
     
  3. davedauwerse

    davedauwerse

    Messages:
    10
    It is? ok, i did it to prevent that when the file goes over the net everybody could mess around with my (hard) work
    and will take credit for all the work i had to write it. but if you think that it's not done i will consider to remove the password (hope this is good english for a dutch guy :))
     
  4. NLxAROSA

    NLxAROSA Premium

    Messages:
    7,907
    Location:
    Netherlands
    You can make the document read-only for everyone but yourself. And there's version history, so your work will always be saved. As said, posting the password here is NOT secure in any way. This is a public site so anything posted here is visible for the whole world.
     
    Spitfire77 likes this.
  5. davedauwerse

    davedauwerse

    Messages:
    10
    I took the advice and removed the PW
     
    Johnnypenso likes this.
  6. FS7

    FS7

    Messages:
    1,117
    Location:
    Brazil
    Very nice work!

    I see you included the car classes as listed on the car select screen, there are some discrepancies in-game between the classes listed in the car select screen and the classes listed in the race results screen after the end of the race (eg: Caterham SP300/R, Palmer Jaguar & Radicals listed as Prototype 2 in the car select screen and LMP3 in the race results screen, Ford Escort listed as Historic B in car select screen and Historic Touring 2 in the race results screen, etc).
    Here's a list I made with the car classes as listed in the race results screen just for reference:

    Open Wheel

    FA
    SMS Formula A

    FB
    SMS Formula B

    FC
    SMS Formula C

    F4
    Formula Gulf 1000

    F5
    SMS Formula Rookie

    Vintage F1 A
    Lotus 49 Cosworth

    Vintage F1 B
    Lotus 72D Cosworth
    Lotus 78 Cosworth

    Vintage F1 C
    Lotus 98T Renault

    Kart

    Super Kart
    SMS Superkart 250cc (Kart02)

    Kart One
    SMS Kart 125cc (Kart01)

    Prototype

    LMP1
    Audi R18 e-tron Quattro (Audi Ruapuna Park Track Expansion)
    Audi R18 TDI LMP1
    Marek RP339h (PM 06a) LMP1
    RWD P30 LMP1

    LMP2
    Alpine A450
    Marek RP219D LMP2
    Oreca 03 Nissan
    RWD P20 LMP2

    LMP900
    Audi R8 LMP900 (Audi Ruapuna Park Track Expansion)
    Bentley Speed8 LMGTP (Racing Icons Pack)
    BMW V12 LMR (Racing Icons Pack)

    Group C1
    Sauber C9 Mercedes (Limited Edition Car Pack)

    LMP3
    Caterham SP/300R
    Palmer Jaguar JP-LM
    Radical SR3 RS
    Radical SR8 RX

    GT

    GT1X
    Pagani Zonda R
    Ruf CTR3 SMS-R (Modified Car Pack)

    GT1
    McLaren F1 GTR (1997) (Racing Icons Pack)
    Mercedes-Benz CLK-LM (1998) (Racing Icons Pack)

    GT3
    Aston Martin Vantage GT3
    Audi R8 LMS Ultra
    Bentley Continental GT3 (Racing Icons Pack)
    BMW M3 GT (E92)
    BMW Z4 GT3
    Ginetta G55 GT3
    McLaren 12C GT3
    Mercedes-Benz SLS AMG GT3
    Ruf RGT-8 GT3

    GT4
    Aston Martin Rapide S Hydrogen Hybrid
    Aston Martin Vantage GT4
    BMW M3 GT4 (E92)
    Ford Mustang Boss 302R1
    Ginetta G55 GT4

    GT5
    Ginetta G40 Junior

    Group 5
    BMW 320 Turbo Gr.5 (E21)
    Ford Capri Zakspeed Gr.5

    Group 4
    BMW M1 Procar (E26/1) (Limited Edition Car Pack)

    Vintage GT
    Ford Mk. IV (Limited Edition Car Pack)

    Trans-Am
    Audi 90 IMSA GTO (Audi Ruapuna Park Track Expansion)
    Ford Mustang Cobra SCCA TransAm

    Touring

    DTM
    Mercedes-Benz C-Class Coupe DTM (Limited Edition Car Pack)

    TC2
    BMW 320TC WTCC (E90) (Old Vs New Car Pack)

    TC1
    Renault Clio Cup

    Group A
    BMW M3 Gr.A (E30)
    Ford Sierra RS500 Cosworth Gr.A
    Mercedes-Benz 190E 2.5-16 Evo2 DTM

    Historic Touring 2
    1973 BMW 2002 Turbo (Old Vs New Car Pack)
    Ford Escort RS1600
    1966 Ford Mustang 2+2 Fastback (Old Vs New Car Pack)
    Mercedes-Benz 300SEL 6.8 AMG

    American Stock Series

    Vintage Stockcar
    Caper Monterey Stockcar

    Road

    Road A
    Ariel Atom 500 V8
    Gumpert Apollo S
    McLaren 12C
    McLaren P1
    Pagani Huayra
    Pagani Zonda Cinque Roadster (Modified Car Pack)
    Ruf CTR3
    RUF RT 12 R (Free Car)
    W Motors Lykan HyperSport (Free Car)

    Road B
    Ariel Atom 300 Supercharged
    Ariel Atom Mugen (Modified Car Pack)
    Audi R8 V10 Plus
    BAC Mono
    Caterham Superlight R500
    2015 Ford Mustang GT
    McLaren F1 (Limited Edition Car Pack)
    Mercedes-Benz SLS AMG
    1987 Ruf CTR Yellowbird (Old Vs New Car Pack)
    Ruf RGT-8

    Road C1
    Audi A1 Quattro (Free car)
    BMW 1 M Coupé (E82)
    Mercedes-Benz A45 AMG
    Mitsubishi Lancer Evo X FQ400

    Road C2
    Ford Focus RS
    Renault Mégane R.S. 265

    Road D
    Caterham Seven Classic
     
  7. Spooky Wooky

    Spooky Wooky (Banned)

    Messages:
    1,654
    Location:
    England
    Wow! That's dedication. Good job.
     
    HammyMansell likes this.
  8. HammyMansell

    HammyMansell

    Messages:
    5,216
    Location:
    United Kingdom
    Sure is Spooky!!! Like this song!!! See you online over the weekend mate!

     
  9. Spooky Wooky

    Spooky Wooky (Banned)

    Messages:
    1,654
    Location:
    England
    R.I.P Roy Castle
     
    HammyMansell likes this.
  10. HammyMansell

    HammyMansell

    Messages:
    5,216
    Location:
    United Kingdom
    Absolutely!!!! The great man!!! Brings back many a memory of my childhood watching BBC kids tv in the 80's.....What a time...Thank god we have PCARS now, there's nothing much else to enjoy! ;)
     
  11. Fanapryde

    Fanapryde

    Messages:
    3,667
    Location:
    Belgium
    Great job !

    Am I missing it ? It would be even more complete if you could add the type of gearbox (H - SQ - paddles - number of gears).
    :tup: