|
Updated for upcoming Season 3 - see below for newest version of the file
I am only a gold platinum level player, and have been working hard to get better. I thought it would be helpful to start gathering data from my games so that I could recognize areas where I could improve. (edit: and it was helpful, I have been promoted to Platinum.)
So I made a spreadsheet workbook to help me analyze my games, and wanted to make it available to anyone who is interested. I think it could be helpful to any level player.
NEWEST UPDATED FILE, WITH SAMPLE DATA:
http://www.mediafire.com/?8a8jg22yytngg8e
You will need Excel 2007 or newer to enjoy the full functionality of the workbook.
The workbook has 6 sheets:
* Data Table - where you enter information from your games
* Data Breakdowns - contains pivot tables and charts that break the data into a usable format
* League Match by Date - shows what league BNET has been matching you against over time
* Race Match by Date - shows which races you have played against, over time
* Wins and Loss per day - A chart showing your W/L for each day
* Match Favor by date - shows trends of being matched against Even, Favored, Etc players
You can get some good data from the various sheets. For example: I know that I need to practice against Protoss on Scrap Station, and that BNET has stopped matching me against Bronze and started matching me against Platinum. Maybe my MMR is going up?
The file has data from my games so that you can see how to use it. Simply replace my data with yours. Do not delete the formula in the "Total Points" column.
You will also need to know how to Refresh Pivot Tables as they do not auto-update. (its easy, just google it)
Let me know what you think. I hope it helps.
PLEASE NOT: This is not another version of SC2 Gears. SC2 Gears is awesome, you should have it, but this spreadsheet does a different set of tasks than SC2 Gears does and presents the data in a different manner.
Here are some screen shots:
![[image loading]](http://i1080.photobucket.com/albums/j327/lshopkin/sc_022011-03-191841-1.jpg)
![[image loading]](http://i1080.photobucket.com/albums/j327/lshopkin/sc_012011-03-191840-1.jpg)
![[image loading]](http://i1080.photobucket.com/albums/j327/lshopkin/sc_032011-03-191841.jpg)
![[image loading]](http://i1080.photobucket.com/albums/j327/lshopkin/sc_062011-03-191917.jpg)
|
Hearing this makes me want my computer back so bad so I can use this! Can't wait until Monday. Macs are good, but.... Anyways, sounds really useful. I especially like how you can figure out which maps you struggle on, thats something that can be hard to figure out.
|
|
|
This is the kind of thing I'd really like to see incorporated into sc2 gears. Good for you though, knowledge is power especially in sc2!
|
This is actually really cool. Thanks a lot! I feel like I should of done this before, but I never thought of it. As an above poster said, pictures would make this perfect because people always understand better with them.
|
I don't mean this in a rude way. But the amount of time you spent crunching numbers and making spreadsheets, would of been better spent playing the game.
|
I "crunched the numbers" when playing SC2 wasn't an option. And then I better knew what to work on when I was playing.
|
On March 20 2011 09:46 woofwoof wrote:
I don't mean this in a rude way. But the amount of time you spent crunching numbers and making spreadsheets, would of been better spent playing the game.
amortized cost, broski
|
On March 20 2011 09:46 woofwoof wrote:
I don't mean this in a rude way. But the amount of time you spent crunching numbers and making spreadsheets, would of been better spent playing the game.
because taking a break from playing is never a good thing right...
As well, he gains valuable data, like which match-up to work on. He can track and see "well it seems like I lose most of my XvT alright, time to work on my BO for vs. terran.
Then next month he can look at the numbers and can definitively see "alright my XvT is my best matchup now, but I seem to be struggling vs P now...."
You can feel like "ok my XvT is fine, my weakness is XvZ" but the numbers might tell you a completely different story. Taking 30 minutes that you normally wouldn't be practicing to get this kind of data is well worth it.
|
Once the sheet is set up (what I have done) it is really easy to enter the data after each game, or set of games, and pretty soon the trends and numbers begin to be pretty valuable.
|
Fantastic! Thank you, this is something I've been meaning to do, but it looks like you've already done a fantastic job.
While it's certainly not going to make me shoot to Diamond overnight, it'll be a bit easier for me to get a more quantitative handle on how I think I'm doing and how I'm actually doing.
|
Does SC2 gears do this too?
|
SC2 Gears is pretty great! But I wanted to be able to customize the data in anyway I wanted. And I wanted to do it over time for all games.
|
Looks cool, I think I'll use that once the new season starts. Thanks for sharing! 
|
Neat stuff. Any details on what you lose out on if you run open office or numbers instead of excel?
|
I don't but i bet most of it is things like conditional formating and other pretty things. the formulas may still be good, and that is what counts.
|
|
|
Pretty cool man, good work!
|
On March 20 2011 09:46 woofwoof wrote:
I don't mean this in a rude way. But the amount of time you spent crunching numbers and making spreadsheets, would of been better spent playing the game.
I started to use this sheet. After every game I put the numbers and info, it literally takes less than 2 minutes.
|
United States17042 Posts
|
|
|
|
|
|
EPT
