Based on the awesome "AC Cars and Tracks Technical Data (Excel 2013) 1.11", I made my own with some vba stuff. Have fun.
These Excel files DO NOT contain ANY data at first. You have to feed it a "\cars" and "\tracks" directory. It works on click of a button, is reasonably fast and contains some macros. For inspection, the macros are included as textfiles too.
Paste cars/tracks dir or browse for it on the "control"-sheet and click on "scan". Anyway if the directory is not valid, you will be asked to browse for it. By providing any cars/tracks directory with valid AC json files in it you can also scan directories with turned-off- OR backup-cars.
To get more detailed information (in particular col "E", the drive+gears info), you must ensure the ".acd" datafile is already extracted for the desired cars - the only way to determine if the car is AWD/AWD2/RWD/FWD, as tags from "ui_car.json" are not always reliable. If available, drive-info from "\data\drivetrain.ini" will be used, the tag from "ui_car.json" wil be omitted. There are more AWD/AWD2 cars then you think!
If some data is not showing up, a second scan may magically help sometimes, especially after changing preview-size.
-lists data from files out of cars "\data"-dir if available
NOTE: a second hardcoded temp-dir one can use is "content\cars\examplecar\datadir" (where I extract my .acd files)
-lists data from all found "ui_car.json" and "ui_track.json" files
-Simple "mp/h" and "mph" -> "km/h" conversion for topspeed and track length (fails sometimes)
-wpratio is calculated, old value as cell-comment
-preview: none or small/medium/big/huge
-large preview on mouse over small one
-info about gear ratios as comment on column "drive" or "E"
- .(dot) is decimal-separator
-Made in 1080 res
-Dark+Light design available
-readonly: it doesnt change anything on your system
following files will be read:
skins\*\preview.jpg ' only the first one
*\map.png ' for tracks
-you have to ALLOW macros in the security options of Excel, to let it do its work
-can be painly slow, if you have a lot of cars
-saved excel file can be painly big (>50MB), if you have a lot of cars
.rar file contains:
ps: Got a bad Trackmap? Delete
\trackX\layout2\map.png (if there are more layouts)
AC recreates them on first start, but crashes. Next start will work!