RD Series on Simracing.GP

Daily WTCR races on Simracing.GP Weekly GT3 Endurance races on Simracing.GP Weekly GT3 Sprint Races on Simracing.GP Weekly GT4 Sprint Races on Simracing.GP
Resource icon

AC Cars+Tracks TecSpecs ExcelScanner 3.8a

Log in to download, or make sure to confirm your account via email
Based on the awesome "AC Cars and Tracks Technical Data (Excel 2013) 1.11", I made my own with some vba stuff. It works on click of a button, is reasonably fast and contains some macros. For inspection, the macros are included as textfiles too. Have fun.

These Excel files DO NOT contain ANY data at first. You have to feed it a "\cars" and "\tracks" directory. On "control"-sheet you can paste cars/tracks folder into Cell A2/A3 or browse for it with ".." buttons. Then use one of the "scan..." buttons.
1612299818995.png


Note: Because of VBA macros used - you have to ALLOW macros, its that yellow message, when opening the file. If you skip that, whole file is useless. And also in excel security settings you should set macros to: "Only run when asked" or something, when disabled it will not work.

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 drive/gear/tyre info), you must ensure "data.acd" file from cars directory is already extracted as "\data"-folder for the desired cars. Unpacking "data.acd" you do with quickBMS and latest ".acd"-script -or- with ContentManager in dev-mode on content/cars page.
Note: alternative second folder scanned in cars folder: "\datadir".

If available, info from "\data\drivetrain.ini" will be used to determine AWD/RWD/FWD, as tags from "ui_car.json" are not always reliable. 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.

Features:
-lists data from all found "ui_car.json" and "ui_track.json" files
-lists data from files out of cars "\data"-dir if available
NOTE: a second hardcoded temp-dir one can use is "\datadir" (where I extract my .acd files)
-preview images: none or small/medium/big/huge (default is "none"!)
-simple string filter on folder+file-names, using a comma separated list (not case sensitive):
1597151711880.png

-Simple "mp/h" and "mph" -> "km/h" conversion for topspeed and track length (fails sometimes)
-wpratio is calculated, old value as cell-comment
-large preview on mouse over small one (if enabled!)
-info about various stuff as comments (red mark on cells)
- .(dot) is decimal-separator
-Made in 1080 res
-Dark+Light design available (light is default)
-readonly: it doesn't change anything on your system

following files will be read:
ui\ui_car.json
ui\ui_track.json

with preview enabled (off by default):
skins\*\preview.jpg ' only the first one
*\map.png ' for tracks

if "data.acd" file is extracted also those files:
data\drivetrain.ini
data\brakes.ini
data\electronics.ini
data\engine.ini
data\tyres.ini
data\fuel_cons.ini
data\flames.ini
data\car.ini
data\wing_animations.ini
data\aero.ini
data\ai.ini
data\drs.ini
data\ers.ini
data\lights.ini
data\suspensions.ini

warning:
-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 and preview images on
-saved excel file can be painly big (>50MB), if you have a lot of cars and preview images on

.zip file contains:
\ACTecSpecs\ACTecSpecs_xx.xlsm (excel file with macros)
\ACTecSpecs\ACTecSpecs_xx.xls (excel 97 version)
\ACTecSpecs\....._readme.txt
\ACTecSpecs\src\AssettoCorsaScanner.bas (source code)
\ACTecSpecs\src\FormProgress.frm (progress window)
\ACTecSpecs\src\FormProgress.frx (progress window neccesary stuff)

---------------ps-----------------
Got a bad Trackmap? Delete the old "\trackX\map.png" !
(or \trackX\layout1\map.png, if there are more layouts)

Then run a session, AC creates a new "data\map.ini" on start
And also a JPEG file saved as "map.PNG" :coffee:.

Rename it to "map.jpg". Then open with image program of choice, remove black background and save as "map.png " with transparency.
-------------------------------------

Screenshots

Control sheet (with a string filter set)
(green background=edit this! - blue background=descriptions)
1597151852987.png

Filled in Car sheet, dark mode:
ACTecSpecs25_cars.png

Filled in Track sheet, dark mode:
ACTecSpecs25_tracks.png

Filled, dark mode, showing comment detail for gear column:
ACTecGearRatios.jpg

cars with * in timestamp column may have a sound problem:
ACTecSpecs30_INI_versions.png

filled, light mode, check if "street" or "race" tag is missing
1597151155928.png

tyre version column also contains calculated tyre dimensions
1597152192950.png
  • ACTecSpecsDark.jpg
    ACTecSpecsDark.jpg
    175.4 KB · Views: 7,273
  • ACTecSpecsLight.jpg
    ACTecSpecsLight.jpg
    174.7 KB · Views: 7,324
  • ACTecSpecs10.jpg
    ACTecSpecs10.jpg
    416.2 KB · Views: 6,462
  • ACTecSpecs25_default.png
    ACTecSpecs25_default.png
    18.6 KB · Views: 6,107
  • 1595411209816.png
    1595411209816.png
    2.1 KB · Views: 692
  • 1597151688515.png
    1597151688515.png
    4.7 KB · Views: 50

Latest updates

  1. v3.8a - 2021-02-17

    internal version # not changed ----------------- -fixed div by zero in cases
  2. v3.8 - 2021-02-06

    -fixed ers/kers info and tyre data -added note in tyre-column if "default tyreindex wrong" -made...
  3. 3.7 - 2020-08-30

    -fixed some "type mismatch" errors for some people, never had them myself. So if this did never...

Latest reviews

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.


Well I have clicked many buttons and watched many videos. Would be cool to use but for someone not well versed in this the description on how to use it is useless
Please Stop This
Please Stop This
You can ignore this first introduction-sentence in description.

Do not ignore next paragraph. And look at the picutres. Your complain is useless. What is your problem with the usage? You paste your AC-car or -track folder (or use ".." button to browse for it). Then just hit "scan". Easy! Afaik there aren't any videos about this tiny custom excel tool, that would be ridiculously funny. If there are any, please show me.

You can elaborate in discussion thread. https://www.racedepartment.com/threads/ac-cars-tracks-tecspecs-excelscanner.147152/

Edit: changed description page a bit now.
Upvote 0
I was looking for this. Genial.
Upvote 0
A must have - brilliant - thanks!
Upvote 0
Fantastic!
Upvote 0
Gracias
Upvote 0
Awesome tool!! but how can i extract ".acd" datafile?
Upvote 0
Awesome tool.
This saved me literally hours and hours of manual work...
Please Stop This
Please Stop This
Thank you very much. What where you looking for?
Upvote 0
Been using this already very good indeed.
I understand there's works till to do still .
Would like a Column added for the cars version and a column to filter assetto with mod cars.

Very good work.
Upvote 0
Author
Please Stop This
Downloads
716
File size
351.2 KB
Views
9,541
First release
Last update
Rating
4.64 star(s) 11 ratings

More resources from Please Stop This

Top