|
On December 09 2011 02:18 Snuggles wrote:
Ok so do I have enter in each game individually to get the data sorted out or is there an automated way?
I'd love if there was an automated way but I don't know how this would be done. I'm also pretty sure that it goes againsts the Terms and Conditions to mess with that stuff since it's connected to battle.net. Personally, i don't see it as being that annoying. I just enter it between games, it is very satisfying for them wins, and is motivation to win after those losses 
|
Are u still updating this ? Would love and update for season 5
|
Yea great spreadsheet would be cool if you could add the maps that are being used in Season 5 or tell us how to enable additional maps;)
Thanks for the great work!
|
Just use the "Find & Replace" option in Excel. I did that last night and it seems to work fine.
|
|
|
On December 23 2011 07:44 acidbean wrote:
Just use the "Find & Replace" option in Excel. I did that last night and it seems to work fine.
I don't endorse this advise lol! If u want to see how complicated the sheet is then un-hide the columns between the data and charts
A new version will be with you in the next hour or 2 :D
edit: It's up now!
|
Sorry to ask this here, but how do I edit the drop-down list so that I can add the seaon 5 maps to the file?
I don't want to make a new file when all my stats are in the old one...
|
On December 23 2011 23:00 GrungyMunchy wrote:
Sorry to ask this here, but how do I edit the drop-down list so that I can add the seaon 5 maps to the file?
I don't want to make a new file when all my stats are in the old one...
New version is uploaded, let me know if you have any problems with it
|
There are some things going on in the "Map Win Rates" and "Map Stats" sections with the new maps when a win is input.
A win on Entombed Valley results in a loss on Entombed Valley, a win on Arid Plateau, and as -1 losses on Arid Plateau.
A win on Arid Plateau results in a loss on Arid Plateau, a win on Entombed Valley, and as -1 losses on Entombed Valley.
Losses on both of these maps seem to be working properly as well as everything else on the sheet. Also, I'd like to say that I've been using this sheet ever since you released it and have loved it. Thanks a lot for putting it together and keeping it updated.
|
On December 23 2011 23:32 Xkfyu wrote:
There are some things going on in the "Map Win Rates" and "Map Stats" sections with the new maps when a win is input.
A win on Entombed Valley results in a loss on Entombed Valley, a win on Arid Plateau, and as -1 losses on Arid Plateau.
A win on Arid Plateau results in a loss on Arid Plateau, a win on Entombed Valley, and as -1 losses on Entombed Valley.
Losses on both of these maps seem to be working properly as well as everything else on the sheet. Also, I'd like to say that I've been using this sheet ever since you released it and have loved it. Thanks a lot for putting it together and keeping it updated.
Fixed! Thanks for letting me know xD I got the columns the wrong way around for the 2 new maps
Also, thanks for the support. And i'm glad you are finding it useful
|
On December 23 2011 22:14 WarpMePlz wrote:Show nested quote +On December 23 2011 07:44 acidbean wrote:
Just use the "Find & Replace" option in Excel. I did that last night and it seems to work fine. I don't endorse this advise lol! If u want to see how complicated the sheet is then un-hide the columns between the data and charts A new version will be with you in the next hour or 2 :D edit: It's up now!
I played like 15 games on the new maps and it works for me. Excel found "only" 5007 mentions of Nerazim Crypt plus another 5007 for Abyssal Caverns, cant image how much work you put into that.
Thanks for updating to Season 5, now I can delete my bandaidfixed version :D
|
On December 24 2011 03:14 acidbean wrote:Show nested quote +On December 23 2011 22:14 WarpMePlz wrote:On December 23 2011 07:44 acidbean wrote:
Just use the "Find & Replace" option in Excel. I did that last night and it seems to work fine. I don't endorse this advise lol! If u want to see how complicated the sheet is then un-hide the columns between the data and charts A new version will be with you in the next hour or 2 :D edit: It's up now! I played like 15 games on the new maps and it works for me. Excel found "only" 5007 mentions of Nerazim Crypt plus another 5007 for Abyssal Caverns, cant image how much work you put into that. Thanks for updating to Season 5, now I can delete my bandaidfixed version :D
You're welcome bro
|
on mac i keep having excel stop working whenever i run this! Any answers for how to make that not happen?
|
really nice spread sheet. started using 2 days ago and i think it will affect me really good on my stats. i was mad to blizzard for not letting us track our win-lose ratio below masters. thank you and awesome job.
|
On December 24 2011 21:36 docvoc wrote:
on mac i keep having excel stop working whenever i run this! Any answers for how to make that not happen?
No idea, sorry.
|
On December 26 2011 06:50 Apophenic wrote:
really nice spread sheet. started using 2 days ago and i think it will affect me really good on my stats. i was mad to blizzard for not letting us track our win-lose ratio below masters. thank you and awesome job.
Thanks for your awsome comment. Glad you like it
|
Posting again to say thank you . Just got back into starcraft and I'm happy to see you are still updating this because my old version was outdated.
|
This is a great spreadsheet. Thank you so much . I love putting my results in after every match. It's nice to see how I improve and what my best matchups and maps are.
P.S. Are you going to update the spreadsheet for the season 6 maps?
|
On February 11 2012 11:00 CatsnHats wrote:This is a great spreadsheet. Thank you so much . I love putting my results in after every match. It's nice to see how I improve and what my best matchups and maps are. P.S. Are you going to update the spreadsheet for the season 6 maps?
Thanks I have now updated the spreadsheet for season 6 so you can be prepared!
|
|
|
|
|
|
|
|
EPT
