Frozen Synapse Player Statistics Tool
Find out the number of games you've played for each type, your true win/loss ratio, number of draws, progress and much more.
- Log in to the Grand Server, go to the player profile, click “Match History” to download ppAllGamesRec.txt in the FS's psychoff folder.
- Download the Windows or Mac OS X / Linux file converter and use it to convert ppAllGamesRec.txt into a CSV file.
- On Mac OS X / Linux you need to place ppAllGamesRec.txt and ppAllGamesRec-converter.awk in the same folder. Then open the Terminal with administrators rights, type cd then drop ppAllGamesRec.txt's folder into the Terminal window to paste its path - press Enter.
Then paste awk -f ppAllGamesRec-converter.awk < ppAllGamesRec.txt > ppAllGamesRec.csv and press Enter.
- Now open ppAllGamesRec.csv in a spreadsheet software such as Open Office. For Mac OS X and Apple Numbers you'll need to drop the file inside its window, not open it.
- It's advised to delete rows for games that are not over so that they don't create noise in your statistics.
- Eventually you can use my XLS spreadsheet (or .numbers) as a template. It already has some analysis and charts done.
Make sure both tables are sorted identically, then keep the template's header and delete all data inside the columns, then paste data from ppAllGamesRec.csv.