This is awesome, now I need to learn how to import this to my tracker. This will save 7-8 min per car
Just a quick guide on how to set up an Excel sheet so it automatically combines statistics from a bunch of CSVs:
- Read the part of the instructions in the topic that tells you how:
Big props for making this tool! It’s been a huge help.
The Dumb, Hard Way
Create a folder named anything you like.
Inside, create an Excel sheet and another folder (again, both named anything you like.) This second folder will hold your CSV files.
Put exported CSVs into your CSV folder.
Open your Excel sheet. In Excel, navigate to Data > Get Data > From File > From Folder.
Find the folder with your CSVs. Select that folder, then click Open.
Verify that the files you want are shown on-screen. If so, go to Combine > Combine & Load and click.
On the next screen, click OK.
Voila! Your sheet now contains all sorts of data.
Hide or delete columns that you don’t think will be relevant
At present, this sheet probably contains lots of data that you don’t really care about. You can either hide columns by selecting them by clicking and dragging on the column bars, right clicking, and clicking “hide.” You can also delete them altogether the same way.
Freeze panes with important information
You can keep important info (like car names and column labels) “pinned” to the top or side of the screen using the Freeze Panes option under View > Freeze Panes > Freeze Panes.
- Figure out which columns and rows you want to “pin” to the top and left sides of the screen. For example, let’s say we want to keep the first two columns and the first row.
- Select the top-rightmost cell that is not inside the area you want to freeze. In this case, that’s the cell in the third column and second row.
- Click View > Freeze Panes > Freeze Panes.
Refresh to add new data.
You may want to add in new CSV files later. In that case, go to the Query tab and click Refresh.
The new data should show up in your sheet.
Hope this helps!
Super handy tool, thank you so much for this!!
I did find a bug in the export - the Entertainment column listed Standard CD as Luxury CD - all those in green are actually Standard CD in automation.
Not sure if the right place to report it.
A new version of the exporter is now available
The release files have now been moved to GitHub releases
Source code is now available on GitHub as well to allow community contributions
Really glad to see this all open sourced! Should allow for more development of user exporters, between this and the SDK provided by Camshaft (which, I’ll admit, I never saw).
like karhgath said, not sure if this is a good place to paste bug reports - but the Model Name column currently exports the trim name. Also, is there any way we can get the stress thresholds for pistons, or are we stuck with the “engine explodes after one crank” thresholds?
Small bug report: The exporter throws errors if the car name ends with a space
Version 5 released
- Added export parameter saving
- Added car cost approximation with production presets
- Fixed issues caused by car names ending with whitespaces
- Added preset choice saving
- Fixed checkbox saving working incorrectly
- Improved whitespace handling
Legacy PostGo to newest version
CSVExporter 2 Released
See the original post for information on the new version
Hello! Sorry but I do not understand what the export is for, we can see more details of the car or something? Thank you!
It also looks something fun to do, I would like to learn hahaha
There’s very, very little (if anything) that this exporter exposes which isn’t already in the game.
What it does do, however, is collate the information for a bunch of cars in a spreadsheet incredibly easily. If you need to look at the stats of ten, twenty, fifty cars… this automatically puts them in a spreadsheet for you. You may never have needed to look at the stats of that many cars, but people hosting challenges here on the forum absolutely do. This cuts data entry which could take an entire day down to maybe an hour on the high side.
This is especially true for challenges with high turnouts (20 or more entrants), but it’s still useful even when there’s a small entry list of 10 or fewer entrants.
Thank you very much, it looks really useful for the forum and the challenges as well as for our own car brands, I’m going to try it!
- Updated the default dataset file to maintain data order
- Added toe values
Patch 2.2 Released
- Updated for the newest exporter API
- Added export parameter descriptions