A program that easily converts export data to xlsx.
Posted: Sun Oct 04, 2020 1:39 pm
Hi,Did you know that in-game data is exported as a txt file? (Cash, earnings for the last 12 months, profits for the last 12 months)
This is a new feature added to Banking and Financial DLC since 6.6.03.
I made a program to easily convert a txt file of data exported by capitalismlab to an xlsx file(Excel file).
This is not compatible with the export data added in 8.2.00.（2023/1/17 - torajiro）
Please do not upload anywhere else.
*It seems that BitDefender Theta and Qihoo-360 will detect viruses, but they are incorrect.
Usage is simple.
1. Press ctrl + E on the Corporate Financial Overview screen at any time you like.
The data for Cash, Revenue in the past 12months, Profit in the past 12 months when you press ctrl + E will be exported.
2. Unzip my program to "Document \ My Games \ Capitalism Lab \ EXPORT". This is the folder containing the exported data.
3. Click CL_ExportDataConverter.exe. I think the txt file has been converted to an xlsx file.
-analyze.xlsx-
A file called analyze.xlsx will be created with the converted file.
This is a summary of the contents of the txt file for each company.
Cash, revenue and profit are separated into each sheet.
Also, the program has added a line graph.
----
"important point"
・ I think it is better not to edit the original txt file.
-If a new language is translated, an error may occur due to the calendar. In that case, make the second line of t_basic.txt the same as the English version of t_basic.txt. The language currently translated and uploaded is fine. (Brazilian Portuguese and Polish calendars have been added to the program)
・ When starting a new game, please be careful as the tables and graphs will be inaccurate if you mix the old txt files.
---
"What this program can't do"
-Items with numerical values other than "Cash, Revenue in the past 12months, Profit in the past 12 months" cannot be increased.
-It is not possible to automatically manufacture a txt file.
↑ These are functions on the capitalismlab side, so please make a request in the forum.
See this topic for export data.
viewtopic.php?f=52&t=7276
This is a new feature added to Banking and Financial DLC since 6.6.03.
I made a program to easily convert a txt file of data exported by capitalismlab to an xlsx file(Excel file).
This is not compatible with the export data added in 8.2.00.（2023/1/17 - torajiro）
Please do not upload anywhere else.
*It seems that BitDefender Theta and Qihoo-360 will detect viruses, but they are incorrect.
Usage is simple.
1. Press ctrl + E on the Corporate Financial Overview screen at any time you like.
The data for Cash, Revenue in the past 12months, Profit in the past 12 months when you press ctrl + E will be exported.
- ctrl-e.png (67.47 KiB) Viewed 16319 times
- unzip.png (8.44 KiB) Viewed 16319 times
-analyze.xlsx-
A file called analyze.xlsx will be created with the converted file.
This is a summary of the contents of the txt file for each company.
Cash, revenue and profit are separated into each sheet.
Also, the program has added a line graph.
- graph.png (48.43 KiB) Viewed 16319 times
"important point"
・ I think it is better not to edit the original txt file.
-If a new language is translated, an error may occur due to the calendar. In that case, make the second line of t_basic.txt the same as the English version of t_basic.txt. The language currently translated and uploaded is fine. (Brazilian Portuguese and Polish calendars have been added to the program)
・ When starting a new game, please be careful as the tables and graphs will be inaccurate if you mix the old txt files.
---
"What this program can't do"
-Items with numerical values other than "Cash, Revenue in the past 12months, Profit in the past 12 months" cannot be increased.
-It is not possible to automatically manufacture a txt file.
↑ These are functions on the capitalismlab side, so please make a request in the forum.
See this topic for export data.
viewtopic.php?f=52&t=7276