|
|
This has to get more attention because I would love to see data like this implemented in Bnet. That would be a dream come true^^ So now I gonna download the new spreadsheet version Thx for your great work man!
|
will it mess everything up if i add a column for game notes? like "got supply blocked, didnt inject during battle" etc
|
On June 19 2012 04:32 sertman wrote: will it mess everything up if i add a column for game notes? like "got supply blocked, didnt inject during battle" etc The "bottom" button won't work - To get it to work: 1. make sure first of all macros are enabled. 2. right click the "bottom" button and click "assign macro" then "edit" and change "N3" to "O3". This will fix it.
Apart from this everything else should automatically correct itself.
|
Thanks for this - I will link this in the main post
|
On June 19 2012 04:56 WarpMePlz wrote:Show nested quote +On June 19 2012 04:32 sertman wrote: will it mess everything up if i add a column for game notes? like "got supply blocked, didnt inject during battle" etc The "bottom" button won't work - To get it to work: 1. make sure first of all macros are enabled. 2. right click the "bottom" button and click "assign macro" then "edit" and change "N3" to "O3". This will fix it. Apart from this everything else should automatically correct itself.
After some experimenting i found if I add the column from VR (so the new column is VQ) it breaks nothing. Thanks for the timely response, i appreciate the work you've put into this :D
|
Thanks for all the support guys, it means a lot! I did put a lot of effort in to this update but the great reaction makes it worth it <3
On June 19 2012 02:43 Muckles wrote: Okay I realy like the new organisation line on the top and the new features, but it is a bit much to fill in now. I would say that it is now better then before and you should continue to make it like that (for every season i mean), because for the higher player it is realy helpful and if you don't want to fill so many cells after each game you can also leave them blanc.
I will not use this for now because i don't know if you are going to leave this desing in the spreadsheet but if you will continue with this new features I will use it for sure.
Very good work. :D Thanks man! The spreadsheet will be staying in this new format - I am only putting it through a bit of testing to try and find any errors in the calculations and get some feedback on the new graphs. The new data inputs will stay for sure so you can go ahead and use it. I have put extra time into making it so that it does not include your old data in the new "game length" and "SQ" stats and graphs. i.e. This just means your averages don't get messed up!
|
Short question: It seems like my graphs don't recongnice the month I entered. It worked fine till the beginning of june where I entered XX.Jun in the date column. So what am I supposed to fill in ^^.
|
for some reason it only shows the games that i played before i changed my name can i somehow adjust that? apart from that it looks fuckin amazing well done
|
|
yes i can find my new name on sc2ranks and then what?
|
Oh sorry, I ment to say your old name of course.
|
no i can't find my old name on sc2ranks
|
or you could just go to StatCraft.net and use his website that is always updated and is better than this thing.
|
I tried out v13 and got some issues with "today´s stats" as they don`t work although I entered the date for all games.
|
On June 26 2012 19:48 kuehlschrank wrote:I tried out v13 and got some issues with "today´s stats" as they don`t work although I entered the date for all games. The format of the date is wrong. Notice it appears "21.jun" rather than "21-jun". enter the date simply "21 jun" and it will enter it as a date rather than a word it cannot calculate. - To confirm this select the cell, and in the formula bar should be the date in the format 21/06/2012
|
This is so useful! I had something like this for myself, but it was nowhere near as pretty as this one:D
|
Can you add the average SQ somewhere? Edit: Maybe with an overview to se what you should have in your league.
Also you mixed up the possition of the Game Length vs Race and the Spending Quotient vs Race graph (it is not a big thing but maybe you want to change it in the next version).
|
Hey how i can insert my stats i dont understand it ?
|
Same question how can i analyse my stats... This only looks like some kind of an example WTF
|
|
|
|