|
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.
Just delete the info that is already in the table on the first sheet and put in your own info. then refresh the pivot tables on the other sheets (you can google how to refresh them - it's easy )
|
On March 29 2011 11:26 duartesito wrote:
Thanks a lot! Gonna be using this a lot! One question though, how can i know what league my opponent is from?
in the score screen click on your opponents name and use the drop down menu to select "see profile"
|
On March 29 2011 23:10 Toxin451 wrote:Show nested quote +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. Just delete the info that is already in the table on the first sheet and put in your own info. then refresh the pivot tables on the other sheets (you can google how to refresh them - it's easy )
I attempted to do this, but the Platinum, Diamond, and Masters doesn't show up on the pivot tables. Is there a way to make it so that it will?
|
Dude that's nice work I was thinking of doing somthing like this.... but I keep playing sc2 but mabey
|
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  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?
Check on the tables to make sure that they aren't filtering out the other leagues. It will accept any data you put into it so I am guessing that the view on the tables is just getting filtered by excel. Check the little drop down menu arrows at the top of each table.
However i posted in the original post another blank copy with all of the leagues in it.
|
On March 20 2011 09:18 ntvarify wrote:
Macs are good
I lol'd
|
Answering a few questions:
*Blanks - you can filter out any unwanted data on the tables by using the small drop down arrows at the top of each table. Just click the arrow and check or un-check what you want to be shown on the table
 eleting my data - on the first sheet, in the table, you can simply highlight all of the cells and hit delete, alternatively I have edited the original post with a link with an almost completely blank copy. just delete the little bit of data that is there and then start entering yours
|
This is really good work. I can see myself use this data to improve my matchups. However sadly I don't have excel 2007. Good work though!
OT: if you need a high plat to diamond level protoss, give me a pm. I'm probe,719
|
Dominican Republic32 Posts
OP: in the previous version, you had a formula that calculated the total points. what happened?
|
or just use sc2gears like everyone else
|
OP: Thanks for making this. I just downloaded it and it looks like a very useful utility.
|
O.O cool spreadsheet bro
Gonna download this as soon as i get home .
Thx for giving me another really usefull tool that i had no need of until now.
Edit: Just tested it, works greate.
|
On March 30 2011 00:14 duartesito wrote:
OP: in the previous version, you had a formula that calculated the total points. what happened?
good catch, thank you. I believe it is fixed now.
|
|
|
On March 30 2011 00:22 adelise wrote:
or just use sc2gears like everyone else
They aren't quite the same, I use both, and you can't customize SC2gears the way you can a simple spreadsheet.
|
but it gives you also win/loss ratio against a certain races or on certain maps and the BOs you used and much more information from the replay. and it doesn't need to be filled out by hand. and it doesn't require excel 2007 (which is a horrible piece of software and not free at all).
not to bash the spreadsheet at all, but i'll stick with sc2gears and i'm fine qq
|
Thanks, I'll give this a try. Good thing I saw this before I started my Season 2
|
Pretty neat tool, thanks!
|
Anyone tried using this in OpenOffice? I can't quite get it to work, some of the formulae don't work.
Doesn't work on MAC's Numbers either 
|
|
|
|
|
|
|
|
EPT
