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!

sertman

United States540 Posts

June 18 2012 19:32 GMT

#183

will it mess everything up if i add a column for game notes? like "got supply blocked, didnt inject during battle" etc

WarpMePlz

United Kingdom76 Posts

June 18 2012 19:56 GMT

#184

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.

WarpMePlz

United Kingdom76 Posts

June 18 2012 20:02 GMT

#185

On June 19 2012 03:05 Roxor9999 wrote:

Show nested quote +

http://office.microsoft.com/en-us/try/try-office-2010-FX101868838.aspx?WT.mc_id=mscom_enus_bnr_tryq4,MSCOM_EN_US_HP_FEATURE_124GMUS017361

Thanks for this - I will link this in the main post

sertman

United States540 Posts

June 18 2012 20:16 GMT

#186

On June 19 2012 04:56 WarpMePlz wrote:

Show nested quote +

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

WarpMePlz

United Kingdom76 Posts

June 18 2012 20:36 GMT

#187

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!

Muckles

Austria17 Posts

June 20 2012 15:01 GMT

#188

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 ^^.

CcCFlu

Switzerland68 Posts

June 20 2012 16:28 GMT

#189

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

Muckles

Austria17 Posts

June 20 2012 20:20 GMT

#190

Try to search your name here:

http://sc2ranks.com/

CcCFlu

Switzerland68 Posts

June 20 2012 23:00 GMT

#191

yes i can find my new name on sc2ranks
and then what?

Muckles

Austria17 Posts

June 21 2012 14:29 GMT

#192

Oh sorry, I ment to say your old name of course.

CcCFlu

Switzerland68 Posts

June 21 2012 15:32 GMT

#193

no i can't find my old name on sc2ranks

YouMake

United States262 Posts

June 21 2012 15:43 GMT

#194

or you could just go to StatCraft.net and use his website that is always updated and is better than this thing.

kuehlschrank

Germany33 Posts

June 26 2012 10:48 GMT

#195

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.

WarpMePlz

United Kingdom76 Posts

June 28 2012 23:36 GMT

#196

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

Scurvy

United States117 Posts

July 01 2012 01:40 GMT

#197

This is so useful! I had something like this for myself, but it was nowhere near as pretty as this one:D

Muckles

Austria17 Posts

July 11 2012 23:02 GMT

#198

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).