ElusoryX Profile Blog Joined December 2010 Singapore 2041 Posts #2 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 why does everyone save in xlsx formati 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 xd

Firesilver Profile Joined December 2010 United Kingdom 1173 Posts #3 That looks pretty sweet, might use this over sc2 gears to get stats, It's extra work but looks alot neater. Caster at IMBA.tv -- www.twitter.com/IMBAFiresilver -- www.youtube.com/FiresilverTV

Sennap Profile Joined December 2010 Iceland 87 Posts #4 Looks very nice. Since I play random this would only be useful for me if I could insert my own race too.



Thanks,

Sennap

WarpMePlz Profile Joined January 2011 United Kingdom 76 Posts #5 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? This makes sense, I guess you could have 3 spreadsheets, one for each race?

Incognetus Profile Joined September 2010 United States 49 Posts #6



http://goo.gl/wjwh7



I wanted to have a bit more information so I know where I need to improve. I made something similar for myself. Have a few different features in there since it was more for me, it isn't as pretty.I wanted to have a bit more information so I know where I need to improve.

BigJoe Profile Joined January 2011 United States 210 Posts #7 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.

feebas Profile Joined February 2011 Finland 265 Posts #8 Thank you ever so much. paska peli

Rannasha Profile Blog Joined August 2010 Netherlands 2398 Posts #9 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. Such flammable little insects!

WarpMePlz Profile Joined January 2011 United Kingdom 76 Posts #10 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. 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.

HollowYoshi Profile Joined March 2011 United States 35 Posts #11 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.

WarpMePlz Profile Joined January 2011 United Kingdom 76 Posts #12 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. 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.

Sennap Profile Joined December 2010 Iceland 87 Posts #13 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? 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 ^^ lol. That's true. I can't believe that didn't cross my mind. You're smart dude ^^

jakethesnake Profile Blog Joined May 2011 Canada 4947 Posts Last Edited: 2011-07-20 21:49:15 #14



http://www.mediafire.com/?df78unc00rw2kpm - xlsx version



No guarantees on if it works perfectly as I just did a quick 'save as' for those that can't open xls. I play random so I thought I would upload my spreadsheet for anyone who cares. Nothing pretty (especially compared to the OP - might need to steal portions of that!), but hopefully useful for anyone who plays random like I do. http://www.mediafire.com/?g3co99awya49b27 xls version for those that care. No guarantees on if it works perfectly as I just did a quick 'save as' for those that can't open xls. Community News jjakji || jjakji || jjakji || jjakji || jjakji || jjakji || jjakji nshoseo.jpg

WarpMePlz Profile Joined January 2011 United Kingdom 76 Posts #15 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? 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 ^^ 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! Thanks bro :p There is a new version in the OP including new graphs and map data!

LuckyFool Profile Blog Joined June 2007 United States 9009 Posts #16 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

enecateReAP Profile Joined June 2011 United Kingdom 377 Posts #17 I will INSTNATLY download this once I get home, well done good sir! "Stargate units imba" - oGsMC

mavsfan0041 Profile Joined February 2011 United States 303 Posts #18 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. R.I.P. CheckSix

WarpMePlz Profile Joined January 2011 United Kingdom 76 Posts #19 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... ^.^ If only... ^.^

IIIOmegaIII Profile Joined May 2011 Sweden 319 Posts #20 awesome stuff, good job!

1 2 3 4 5 9 10 11 Next All