|
Last Updated: 18 June Season 8 spreadsheet out now!!! #####################################################################################################
NEW - Please help (beta testers needed)
I Need help with testing the new spreadsheet. Please download and use it to help find any problems with it. I know there will be issues as I found quite a few myself with the little testing that I've managed to do. Anyway here's the link:
Download: + Show Spoiler +
Download Microsoft Excel Free 60 day Trial: + Show Spoiler +
Feedback, suggestions, bug reports will be appreciated, thanks.
#####################################################################################################
Track your progress in 1v1 Ladder using this spreadsheet!
Screenshot: (Old) + Show Spoiler +
New Features: + Show Spoiler +- New "bottom" click feature takes you to your last entered game to save you scrolling through! (You will understand why this is useful after 200+ games, trust me) Important! Please enable macro's for this to work!
Features: + Show Spoiler +- Win rate - Win rate vs race - Win rate on map - Win rate on map vs race - Win rate vs opponent league - Win rate vs opponent league and race - Graph: Map win rate - Graph: Opponent race distribution - Graph: Distribution of maps played - Graph: Activity timeline - Graph: Overall win rate - Graph: Win rate Vs race - Display previous "x" days stats
Download link: + Show Spoiler + Season 8
Important! Please enable macro's when prompted for certain features to work properly! (see New Features)
Enjoy!
Edit: - Version 11 Uploaded - Season 8 map pool updated ------------------------------------------------------------------------------------------------------------------------------ The season 6 spreadsheet had over 600 downloads!!! Thanks for your support! ------------------------------------------------------------------------------------------------------------------------------
|
why does everyone save in xlsx format i wish there is a proper xls one. an xls format that i've found doesn't seem to help me. but nice screenshot anyway.. :D
|
That looks pretty sweet, might use this over sc2 gears to get stats, It's extra work but looks alot neater.
|
Looks very nice. Since I play random this would only be useful for me if I could insert my own race too.
Thanks, Sennap
|
On July 21 2011 00:05 Sennap wrote: Looks very nice. Since I play random this would only be useful for me if I could insert my own race too.
Thanks, Sennap This makes sense, I guess you could have 3 spreadsheets, one for each race?
|
I made something similar for myself. Have a few different features in there since it was more for me, it isn't as pretty.
http://goo.gl/wjwh7
I wanted to have a bit more information so I know where I need to improve.
|
great post for the start of a new season coming next week! i kept a tally of my losses but this will be a lot more fun.
|
|
I think I prefer to keep using SC2Gears over this. Automatic replay-storing and a wider variety of statistics seals the deal. Nevertheless, it looks nice. One comment though, based on the screenshot, not on actual usage: The activity graph shows cumulative activity (as in, the sum of everything up to and including the day on the horizontal axis) rather than the activity on each day, which is a bit odd. Additionally, if you don't play for a few days, it doesn't show a flat line and then a jump when you start playing again, but instead it has no data-points for the days without any games, so it connects the last day before the break with the first day after. This way a user can't easily distinguish between playing 21 games every sunday and nothing the rest of the week and playing 3 games every day. Two widely different activity patterns that result in the same graph.
|
On July 21 2011 00:21 Rannasha wrote: I think I prefer to keep using SC2Gears over this. Automatic replay-storing and a wider variety of statistics seals the deal. Nevertheless, it looks nice. One comment though, based on the screenshot, not on actual usage: The activity graph shows cumulative activity (as in, the sum of everything up to and including the day on the horizontal axis) rather than the activity on each day, which is a bit odd. Additionally, if you don't play for a few days, it doesn't show a flat line and then a jump when you start playing again, but instead it has no data-points for the days without any games, so it connects the last day before the break with the first day after. This way a user can't easily distinguish between playing 21 games every sunday and nothing the rest of the week and playing 3 games every day. Two widely different activity patterns that result in the same graph. You can customise the graphs however you like, if you add data points it would solve the problem. As for the no. of games being cumulative, I think its easier to see where the majority of your games were racked up over a longer period of time. If you have a consistent training regime you should have a consistent line. Having the number of games played in a day would give a hard-to-read graph of spikes and over months of data would be unusuable.
|
Ok, I really love this spreadsheet and how fancy it looks, but I think it's lacking one key thing: an area to add map statistics. I like to track my win/loss ratio per each map as well so I know what maps I need to work on or what maps I should just veto. I would add it in myself but I'm really not that great with Excel, so I don't know how I would work it into your system.
|
On July 21 2011 05:06 HollowYoshi wrote: Ok, I really love this spreadsheet and how fancy it looks, but I think it's lacking one key thing: an area to add map statistics. I like to track my win/loss ratio per each map as well so I know what maps I need to work on or what maps I should just veto. I would add it in myself but I'm really not that great with Excel, so I don't know how I would work it into your system. Thanks for the feedback, I hadn't thought of including the maps. Shouldnt take long to add in.
Will edit the first post when it's done.
|
On July 21 2011 00:07 WarpMePlz wrote:Show nested quote +On July 21 2011 00:05 Sennap wrote: Looks very nice. Since I play random this would only be useful for me if I could insert my own race too.
Thanks, Sennap This makes sense, I guess you could have 3 spreadsheets, one for each race? lol. That's true. I can't believe that didn't cross my mind. You're smart dude ^^
|
|
On July 21 2011 06:11 Sennap wrote:Show nested quote +On July 21 2011 00:07 WarpMePlz wrote:On July 21 2011 00:05 Sennap wrote: Looks very nice. Since I play random this would only be useful for me if I could insert my own race too.
Thanks, Sennap This makes sense, I guess you could have 3 spreadsheets, one for each race? lol. That's true. I can't believe that didn't cross my mind. You're smart dude ^^ Thanks bro :p There is a new version in the OP including new graphs and map data!
|
I really like the map stats and such, I wish blizz had stuff like this in your bnet profile. I'm sure my winrate on Typhon Peaks is god awful
|
I will INSTNATLY download this once I get home, well done good sir!
|
Downloaded! This is pretty cool. Now I can see if I finally play as many ZvZs as I think I do. :| Jokes aside this will be really helpful to see which matchups and maps I need to work on.
|
On July 21 2011 07:43 LuckyFool wrote: I really like the map stats and such, I wish blizz had stuff like this in your bnet profile. If only... ^.^
|
|
|
|
|