Car database and track overview

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 with all the users of this forum, and hope the find it also useful as i do.

Here's a direct download link 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:


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/

 

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.

 

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 )

 

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.

 

I took the advice and removed the PW

 

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

 

Wow! That's dedication. Good job.

 

Sure is Spooky!!! Like this song!!! See you online over the weekend mate!

 

R.I.P Roy Castle

 

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!

 

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).