Jay very kindly created a little script for those who are gathering their Galaxy Screen data.
This is especially useful when playing in a team game and you want to gather the cost of buying Infrastructure across multiple Empires.
Each player can save the data to a text file and it can all be imported into a spreadsheet (like MS Excel, OpenOffice or Google Drive).
This is only recommended for those data mongers who like playing around with figures in spreadsheets to make coordinating a team streamlined. Less questions about spending, current costs and how much cash is left.
If you don’t like spreadsheets or looking at tables full of numbers, then this is not for you.
Instructions to run the script and save data:
Open up the Galaxy Screen window (mandatory for the script to work)
Type into the console, or Copy/Paste:
It will print a set if stats for each star that is displayed in the Galaxy screen, like this:
So what does this all mean?
Here is the key for each column:
universe.rawExportStar.push(star.r); (Star Resources)
universe.rawExportStar.push(star.n); (Star Name)
universe.rawExportStar.push(star.e); (Star Economy)
universe.rawExportStar.push(star.i); (Star Industry)
universe.rawExportStar.push(star.s); (Star Science)
universe.rawExportStar.push(star.uce); (Economy Upgrade Cost)
universe.rawExportStar.push(star.uci); (Industry Upgrade Cost)
universe.rawExportStar.push(star.ucs); (Science Upgrade Cost)
universe.rawExportStar.push(star.st); (Ships orbiting star, not including ships on carriers)
universe.rawExportStar.push(star.totalDefenses); (Total ships, including carriers, defending star)
Select and copy the text
Paste the data from the console into a basic text file editor (Notepad in Windows)
Save the file as a standard text file or comma separated values file (.txt or .csv)
Open a blank spreadsheet and Import that file. The software should have some automated settings to recognise and sort the data into columns without any change to the settings.
Add a row at the top and title each column according to the above key descriptions
Freeze that row and sort the columns by Economy, Industry or Science as needed (or use Auto Filters which freeze the top row anyway)
That is it. Get the data from your team mates as often as you want and compare the costs on the spreadsheet, instead of twenty questions each cycle.