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.

Toxin451

United States34 Posts

March 22 2011 20:38 GMT

#22

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.

daimyo

77 Posts

March 22 2011 21:07 GMT

#23

thank you very much for this. this is awesome.

CraZyWayne

Germany357 Posts

March 22 2011 21:10 GMT

#24

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.

Toxin451

United States34 Posts

March 23 2011 17:41 GMT

#25

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

Crankenstein

Australia150 Posts

March 23 2011 21:45 GMT

#26

Thanks for the file... very awesome

Phinix

United States116 Posts

March 23 2011 22:56 GMT

#27

Beautifully polished. Kudos! :-)

Toxin451

United States34 Posts

March 28 2011 23:32 GMT

#28

New season tomorrow! Don't forget to start tracking your 1v1 games!

Bizarro252

180 Posts

March 29 2011 00:39 GMT

#29

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!!

Ben...

Canada3485 Posts

March 29 2011 00:46 GMT

#30

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.

alexhard

Sweden317 Posts

March 29 2011 00:59 GMT

#31

Now if I could just directly paste the data from sc2gears into this file...

Gemini_19

United States1258 Posts

March 29 2011 01:07 GMT

#32

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.

kYem

United Kingdom412 Posts

March 29 2011 01:09 GMT

#33

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.

AsianBullets

United States26 Posts

March 29 2011 01:19 GMT

#34

How do I quickly delete all your data? I want to, well, of course, make room for my profile

)

[Silverflame]

Germany640 Posts

March 29 2011 01:37 GMT

#35

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

duartesito

Dominican Republic32 Posts

March 29 2011 02:26 GMT

#36

Thanks a lot! Gonna be using this a lot! One question though, how can i know what league my opponent is from?

Moody

United States750 Posts

March 29 2011 02:35 GMT

#37

Neat!!
I don't know how to use it though

I think I might download SC2Gears now...

Final3

United States15 Posts

March 29 2011 03:50 GMT

#38

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?

Bizarro252

180 Posts

March 29 2011 04:47 GMT

#39

Found a way to have the tables auto refresh everytime you open the file:

http://www.techonthenet.com/excel/pivottbls/on_open2007.php

Delay559

France89 Posts

March 29 2011 06:43 GMT

#40

+ 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

ya can anyone do this? i cant figure it out, any help on how to do it would be really... helpfull