I have a tool which reads a significant number of the .sii/.sui files that make up the static game data plus anything from one to many decrypted textual saved game files and creates up to 23 different CSV files with information about either the static data or my progress in game. That particular extract was just a subset of a Libre Office spreadsheet built from one of those CSVs that I use to track how many times I've visited each yard in the game to collect and/or deliver cargo as my current 'personal achievement' goal (having finished all of the Steam ones, at least until Iberia releases) is to have visited every depot whilst either delivering to or collecting from it. Since said sheet had filters already defined and including every city and company combination in the game it was the matter of moments to filter down to the two truck dealerships and copy into a post. It took me longer to get the formatting right than it did to collect the data.
Just to give a flavour of the sort of information I extract, here is a list of the files from a single run against the first game I saved after upgrading to v1.39 (and thus v50 of the saved file format):
Code: Select all
pittstruck_single_50_company_yards.csv
pittstruck_single_50_drivers.csv
pittstruck_single_50_driver_logs.csv
pittstruck_single_50_event_queue.csv
pittstruck_single_50_fleet.csv
pittstruck_single_50_fleet_logs.csv
pittstruck_single_50_freight_market.csv
pittstruck_single_50_garages.csv
pittstruck_single_50_input_details.csv
pittstruck_single_50_locations.csv
pittstruck_single_50_player_driver_cargoes.csv
pittstruck_single_50_player_driver_journeys.csv
pittstruck_single_50_player_driver_yard_visits.csv
pittstruck_single_50_static_cargo_company.csv
pittstruck_single_50_static_city_company_cargo_counts.csv
pittstruck_single_50_static_company_cargo_counts.csv
pittstruck_single_50_static_country_city.csv
pittstruck_single_50_static_trailer_cargo.csv
pittstruck_single_50_trailers.csv
pittstruck_single_50_trailer_parts.csv
pittstruck_single_50_truck_parts.csv
When run against multiple saved games it can also generate cross-reference sheets of every yard to every other in terms of mileages seen in freight market or driver logs and number of journeys but those and the static city company cargo counts file I can no longer load into Libre Office for analysis as they've exceeded the 1024 column limit due to the number of yards in the official maps! Only problem with multiple saves is that I now have more than 3,200 of them and it takes about 18 hours to process them all.
)
But the possibility to take one of those jobs was too good to let it go.