EPTI'm a bit of a control freak, and also a random player in SC2. So, it's reaaaally hard to keep track of my matchups, what race am i beating with which race, etcetera, and that drives me nuts. That's why I decidded to put together this "Training Control" Spreadsheet. The basic idea behind it, is to note down some information after every game you play (matchup, W/L, points earned/lost w/o bonus, map ), and then load it into the spreadsheet, which will automatically calculate your winning rates for every matchup and in general, and also keep track of the numbers of matches you've played for every matchup.
Soon, I'll be adding some more features, suchs as "real win rate" (taking into account the points won or lost), and win rates for every map.
Well, that's it. I made t in Google Spreadsheets, and it doesn't fucking works as a .xls, so I'm sharing a public version of my own file, with some test data. There are five copies, so if anyone destroys the formula in any of them, there are some sheets remaining. PLEASE, ONLY INSERT DATA IN THE COLUMNS TO THE LEFT, DO NOT TOUCH THE FORMULAS TO THE RIGHT. Without further ado, the link!:
Link! Click me!
PS: Does anybody know how to share only a certain range of cells of a Google Spreadsheet? Or , more specifically, how to share a whole document, but only allow a range of cells to be modified?
