A program that easily converts export data to xlsx.

Banking and Finance DLC for Capitalism Lab
Post Reply
torajiro
Translation Contributor
Translation Contributor
Posts: 140
Joined: Mon Jul 15, 2019 9:33 am
Has thanked: 1 time

A program that easily converts export data to xlsx.

Post by torajiro »

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)
CL_ExportDataConverter.zip
(517.56 KiB) Downloaded 207 times
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
ctrl-e.png (67.47 KiB) Viewed 15400 times
2. Unzip my program to "Document \ My Games \ Capitalism Lab \ EXPORT". This is the folder containing the exported data.
unzip.png
unzip.png (8.44 KiB) Viewed 15400 times
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.
graph.png
graph.png (48.43 KiB) Viewed 15400 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
Last edited by torajiro on Tue Jan 17, 2023 9:54 am, edited 7 times in total.
rafaeltodero
Translation Contributor
Translation Contributor
Posts: 161
Joined: Fri Oct 19, 2018 6:58 pm
Has thanked: 17 times
Been thanked: 5 times

Re: A program that easily converts export data to xlsx.

Post by rafaeltodero »

my congratulations, great job.
Post Reply