Sun Mar 15, 2015 1:17 am
LuaCSV [Export data from LUA to Excel]
Ok this is a first version of the Excel exporter that I promised.
I mostly wrote it for myself but it's also meant for people who run competitions and want to copy the values to Excel, as proposed in this thread. It currently only works with the (non Steam) Launcher version 1418. I will make it work for the current version once that is available to non Steam users. However even if you have updated to Steam it will be very handy to see an overview of your past designs. Of course I assume everyone made a backup of their designs, otherwise you're screwed
It currently extracts the following values:
Cars: Model Name Year Weight Configuration Cylinders Displacement Peak Power Torque Rpm Top Speed
Engines: Model Name Year Aspiration Configuration Cylinders Bore Stroke Displacement Peak Power Torque Rpm Weight Compression CamProfile Mixture* IgnitionTiming Compressor Turbine ARR Ratio Boost
*it currently cannot export fuel mixture because I did not find it
THE PROGRAM IS DISTRIBUTED "AS IS". NO WARRANTY OF ANY KIND IS EXPRESSED OR IMPLIED. YOU USE AT YOUR OWN RISK. IN NO CASE WILL THE AUTHOR OR THE AGENTS OF THE AUTHOR BE LIABLE FOR DATA LOSS, DAMAGES, LOSS OF PROFITS OR ANY OTHER KIND OF LOSS WHILE USING OR MISUSING THIS SOFTWARE
yadda blabla etc. You can do with the program and source code whatever you want, but at our own risk and responsibility.
Here is the sourcecode (C#) http://www.global-explorer.de/LuaCSV/Program.cs
It links to LuaInterface which can be downloaded here http://luaforge.net/projects/luainterface/
The program presumes that you put your models (cars) into the "Models" subfolder. Likewise engines go into the "Engines" subfolder. All required folders and files are already there, you only need to copy YOUR cars and engines to the appropriate subfolderr.
Run the program LuaCSV.exe . It is rather slow so it will take several seconds, that's normal.
If the program says OK, the results of the export will have been written into "models.txt" and "engines.txt"
Now open those files with a text editor and copy everything ( CTRL-A then CTRL-C )
paste everything into Excel [ CTRL-V ]. I provided two Excel files with the correct column headers for models and engines accordingly
You should know what you can do from there
And dont forget, if you want rows and columns exchanged, you can simply transpose the tables
I mostly wrote it for myself but it's also meant for people who run competitions and want to copy the values to Excel, as proposed in this thread. It currently only works with the (non Steam) Launcher version 1418. I will make it work for the current version once that is available to non Steam users. However even if you have updated to Steam it will be very handy to see an overview of your past designs. Of course I assume everyone made a backup of their designs, otherwise you're screwed
It currently extracts the following values:
Cars: Model Name Year Weight Configuration Cylinders Displacement Peak Power Torque Rpm Top Speed
Engines: Model Name Year Aspiration Configuration Cylinders Bore Stroke Displacement Peak Power Torque Rpm Weight Compression CamProfile Mixture* IgnitionTiming Compressor Turbine ARR Ratio Boost
*it currently cannot export fuel mixture because I did not find it
THE PROGRAM IS DISTRIBUTED "AS IS". NO WARRANTY OF ANY KIND IS EXPRESSED OR IMPLIED. YOU USE AT YOUR OWN RISK. IN NO CASE WILL THE AUTHOR OR THE AGENTS OF THE AUTHOR BE LIABLE FOR DATA LOSS, DAMAGES, LOSS OF PROFITS OR ANY OTHER KIND OF LOSS WHILE USING OR MISUSING THIS SOFTWARE
yadda blabla etc. You can do with the program and source code whatever you want, but at our own risk and responsibility.
Here is the sourcecode (C#) http://www.global-explorer.de/LuaCSV/Program.cs
It links to LuaInterface which can be downloaded here http://luaforge.net/projects/luainterface/
The program presumes that you put your models (cars) into the "Models" subfolder. Likewise engines go into the "Engines" subfolder. All required folders and files are already there, you only need to copy YOUR cars and engines to the appropriate subfolderr.
Run the program LuaCSV.exe . It is rather slow so it will take several seconds, that's normal.
If the program says OK, the results of the export will have been written into "models.txt" and "engines.txt"
Now open those files with a text editor and copy everything ( CTRL-A then CTRL-C )
paste everything into Excel [ CTRL-V ]. I provided two Excel files with the correct column headers for models and engines accordingly
You should know what you can do from there
And dont forget, if you want rows and columns exchanged, you can simply transpose the tables
- models.jpg (321.58 KiB) Viewed 9544 times
- engines.jpg (276.58 KiB) Viewed 9544 times
Last edited by BurningBridges on Sat Apr 04, 2015 9:29 pm, edited 14 times in total.
