|
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
|
On March 20 2011 12:30 jmbthirteen wrote:
Pretty cool man, good work!
Thanks.
Appreciate all the messages, everyone. I hope it helps. I'd love to hear if someone really gets some value out of it, like finding out that your "worst match" wasn't the one you thought it was - or something.
|
Added a couple more features and a new sheet and a "win/loss by date" chart. I think these will be my final updates before the new season starts.
|
thank you very much for this. this is awesome.
|
Hahahahaha, it's 2011 and Starcraft 2 is out for several months now, but people have to make excel files to calculate win/loss ratios. Thank you Blizzard! ♥
Sad.
|
On March 23 2011 06:10 CraZyWayne wrote:
Hahahahaha, it's 2011 and Starcraft 2 is out for several months now, but people have to make excel files to calculate win/loss ratios. Thank you Blizzard! ♥
Sad.
Oh it does so much more than that.............
|
Thanks for the file... very awesome
|
Beautifully polished. Kudos! :-)
|
New season tomorrow! Don't forget to start tracking your 1v1 games!
|
Haha, I actually started working on putting one like this together for myself just yesterday and was going to post it when it was done, yours is already way better than mine so thanks!!
|
I'm so starting this for the new season. The math and stats nerd in me demands it.
Edit: just a note: it seems to already be filled in. Is this just an example and we are supposed to reset it or are you accidentally saving over the master file? Sorry I'm a bit of a nub when it comes to Excel. I took the basic class back when I was in Commerce but that's it.
|
Now if I could just directly paste the data from sc2gears into this file...
|
On March 29 2011 09:46 Ben... wrote:
I'm so starting this for the new season. The math and stats nerd in me demands it.
Edit: just a note: it seems to already be filled in. Is this just an example and we are supposed to reset it or are you accidentally saving over the master file? Sorry I'm a bit of a nub when it comes to Excel. I took the basic class back when I was in Commerce but that's it.
Yeh, it still has all your stuff in it. I would love this tho! I've been trying to figure out how to do this for ages now.
|
Well you could use sc2gears.... that will save a lot of time ...
I still have all my replays since release and i can see my win/lose with out much problem it really good to look at map win rates, other than that go for master league ! If win/loses is so important, you should be able to get in master rather soon.
|
How do I quickly delete all your data? I want to, well, of course, make room for my profile )
|
This is great work, thank you! If there would be something like this implemented into the b.net itself all my dreams would become true :D ... Well and hosting replays ofc^^
|
Dominican Republic32 Posts
Thanks a lot! Gonna be using this a lot! One question though, how can i know what league my opponent is from?
|
Neat!!
I don't know how to use it though 
I think I might download SC2Gears now...
|
I'd love to use this, but the "blanks" in it are kind of confusing me. Also, how would I set it up for Gold Platinum Diamond and Masters? Any help would be great! Thanks
EDIT: Do I just put the stats in it and refresh on the other pages and it updates them?
EDIT2: I figured out how it works, but it won't track my league if I put anything higher then Gold in. Any help?
|
|
|
+ Show Spoiler +On March 29 2011 12:50 Final3 wrote:I'd love to use this, but the "blanks" in it are kind of confusing me. Also, how would I set it up for Gold Platinum Diamond and Masters? Any help would be great! Thanks EDIT: Do I just put the stats in it and refresh on the other pages and it updates them? EDIT2: I figured out how it works, but it won't track my league if I put anything higher then Gold in. Any help?
ya can anyone do this? i cant figure it out, any help on how to do it would be really... helpfull
|
On March 29 2011 09:46 Ben... wrote:
I'm so starting this for the new season. The math and stats nerd in me demands it.
Edit: just a note: it seems to already be filled in. Is this just an example and we are supposed to reset it or are you accidentally saving over the master file? Sorry I'm a bit of a nub when it comes to Excel. I took the basic class back when I was in Commerce but that's it.
Just delete the info that is already in the table on the first sheet and put in your own info. then refresh the pivot tables on the other sheets (you can google how to refresh them - it's easy )
|
On March 29 2011 11:26 duartesito wrote:
Thanks a lot! Gonna be using this a lot! One question though, how can i know what league my opponent is from?
in the score screen click on your opponents name and use the drop down menu to select "see profile"
|
On March 29 2011 23:10 Toxin451 wrote:Show nested quote +On March 29 2011 09:46 Ben... wrote:
I'm so starting this for the new season. The math and stats nerd in me demands it.
Edit: just a note: it seems to already be filled in. Is this just an example and we are supposed to reset it or are you accidentally saving over the master file? Sorry I'm a bit of a nub when it comes to Excel. I took the basic class back when I was in Commerce but that's it. Just delete the info that is already in the table on the first sheet and put in your own info. then refresh the pivot tables on the other sheets (you can google how to refresh them - it's easy )
I attempted to do this, but the Platinum, Diamond, and Masters doesn't show up on the pivot tables. Is there a way to make it so that it will?
|
Dude that's nice work I was thinking of doing somthing like this.... but I keep playing sc2 but mabey
|
On March 29 2011 12:50 Final3 wrote:I'd love to use this, but the "blanks" in it are kind of confusing me. Also, how would I set it up for Gold Platinum Diamond and Masters? Any help would be great! Thanks EDIT: Do I just put the stats in it and refresh on the other pages and it updates them? EDIT2: I figured out how it works, but it won't track my league if I put anything higher then Gold in. Any help?
Check on the tables to make sure that they aren't filtering out the other leagues. It will accept any data you put into it so I am guessing that the view on the tables is just getting filtered by excel. Check the little drop down menu arrows at the top of each table.
However i posted in the original post another blank copy with all of the leagues in it.
|
On March 20 2011 09:18 ntvarify wrote:
Macs are good
I lol'd
|
Answering a few questions:
*Blanks - you can filter out any unwanted data on the tables by using the small drop down arrows at the top of each table. Just click the arrow and check or un-check what you want to be shown on the table
 eleting my data - on the first sheet, in the table, you can simply highlight all of the cells and hit delete, alternatively I have edited the original post with a link with an almost completely blank copy. just delete the little bit of data that is there and then start entering yours
|
This is really good work. I can see myself use this data to improve my matchups. However sadly I don't have excel 2007. Good work though!
OT: if you need a high plat to diamond level protoss, give me a pm. I'm probe,719
|
Dominican Republic32 Posts
OP: in the previous version, you had a formula that calculated the total points. what happened?
|
or just use sc2gears like everyone else
|
OP: Thanks for making this. I just downloaded it and it looks like a very useful utility.
|
O.O cool spreadsheet bro
Gonna download this as soon as i get home .
Thx for giving me another really usefull tool that i had no need of until now.
Edit: Just tested it, works greate.
|
On March 30 2011 00:14 duartesito wrote:
OP: in the previous version, you had a formula that calculated the total points. what happened?
good catch, thank you. I believe it is fixed now.
|
|
|
On March 30 2011 00:22 adelise wrote:
or just use sc2gears like everyone else
They aren't quite the same, I use both, and you can't customize SC2gears the way you can a simple spreadsheet.
|
but it gives you also win/loss ratio against a certain races or on certain maps and the BOs you used and much more information from the replay. and it doesn't need to be filled out by hand. and it doesn't require excel 2007 (which is a horrible piece of software and not free at all).
not to bash the spreadsheet at all, but i'll stick with sc2gears and i'm fine qq
|
Thanks, I'll give this a try. Good thing I saw this before I started my Season 2
|
Pretty neat tool, thanks!
|
Anyone tried using this in OpenOffice? I can't quite get it to work, some of the formulae don't work.
Doesn't work on MAC's Numbers either
|
|
|
Started to use this for Season 2! Thanks a lot!
|
Looks awesome, makes up for some clear deficiencies in battle.net
|
On March 20 2011 09:18 ntvarify wrote:
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.
You can open this in numbers or excel on mac....
|
Thanks, this is pretty sweet! Now I need to figure out how to use pivot tables so I can add my own race (Random player) and look at all my matchups...
|
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 takes 10 minutes to do something like this in excel... I did it last season (not the maps tho. just match-ups) there's no number crunching at all.
|
Dominican Republic32 Posts
On March 30 2011 20:11 ShoGuN_sc2 wrote:Anyone tried using this in OpenOffice? I can't quite get it to work, some of the formulae don't work. Doesn't work on MAC's Numbers either
I tried LibreOffice (an OpenOffice fork) and a lot of formulas and customization is lost.
|
On March 31 2011 07:17 duartesito wrote:Show nested quote +On March 30 2011 20:11 ShoGuN_sc2 wrote:Anyone tried using this in OpenOffice? I can't quite get it to work, some of the formulae don't work. Doesn't work on MAC's Numbers either I tried LibreOffice (an OpenOffice fork) and a lot of formulas and customization is lost.
Same for me. :-(
|
Great I like it
I'm going to start using this now for the new season!
|
You could add another column, which would be similar to notes, but something you can sort by: openings. Like I would want to see what my best pvp openings are (winning % wise). That would be pretty cool. and Great job on this ^_^
|
I have to manually enter the data?
Sc2gears does it automatically!
|
I'm going to try using this for the new season. Thanks for the template.
|
Thanks for the spreadsheet - this and sc2gears are a good little combination.
|
Hey everyone. Glad it is helping.
two notes:
* once again, this isn't an sc2gears replacement, i use them both to get the entire picture i want
and also
*with just a few adjustments here and there you can customize this baby anyway you want. Check youtube for tutorials on charts, pivot tables, filters etc.
good luck on the ladders.
|
Added link to updated file in original post
sample data is included, simply replace with your own data.
don't delete formula in "Total Points" column.
|
Can you make this for excel '03 ?
Because when i open it i can hardly edit anything, because of the new version etc ..
and awesome job!
|
|
|
|
|
Hey, i PM'ed you the error i had and still have in the 2003 version :s
|
i'll see if i can get it to work in 2003, but it utilizes a lot of the new features that were not available in previous versions.
sry
|
This is something I have wanted, but with a way to extract the data from the profile non-manually. I don't know if your opponents' races are provided, but I'm sure that if they are sc2 ranks will soon give us those simple calculations right there in the profile.
|
On May 27 2011 03:35 Talic_Zealot wrote:
This is something I have wanted, but with a way to extract the data from the profile non-manually. I don't know if your opponents' races are provided, but I'm sure that if they are sc2 ranks will soon give us those simple calculations right there in the profile.
Use Sc2Gears which has all the features of the spreadsheet and 100 additonal ones and is automatic.
|
Use Sc2Gears which has all the features of the spreadsheet and 100 additonal ones and is automatic.
Though very awesome and very helpful. SC2 Gear does NOT do the same thing as the spreadsheet does. they are different tools. I use them both.
|
Updated with a few new features
|
Can u plz point out what the actual differce precisly is? (serious question, im curious)
|
good stinking question.
cleaned up some formulas and pivot tables
added win ration to "data breakdowns"
added "Game and loss ratios" to "data breakdowns" this shows the percent of total games that you have played against a particular race, and the percent of total losses that said race has provided you.
Added "Ratio by my league" to "data breakdowns" this shows the win ratio in each league you have played in
If you are planning to start a new workbook for season 3 than I would suggest using this one. If you want, you can copy information from a sheet into a previous version into a sheet in this new version.
|
|
|
|
|
|
EPT
