EPT1v1 Stats Spreadsheet - Page 7
| Forum Index > SC2 General |
|
PAD
United Kingdom15 Posts
| ||
|
odin607
United States23 Posts
Example: Overall stats winrate vs terran:=IF(ISERROR(KL12/KK12,0,KL12/KK12) | ||
|
WarpMePlz
United Kingdom76 Posts
On February 19 2012 20:23 odin607 wrote: To prevent "#DIV/0" use =IF(ISERROR(equation,0,equation)) Example: Overall stats winrate vs terran:=IF(ISERROR(KL12/KK12,0,KL12/KK12) Thanks! I didn't know about this function, it will definitely be included for next season! | ||
|
magnaflow
Canada1521 Posts
Also is there any way to just copy this over to a google spreadsheet? | ||
|
Mouffle
France2 Posts
| ||
|
stecman
United States14 Posts
1v1 Average game time 15:35 Average APM - 98 (it went up a lot more at the end of the season) Games Wins Loses Win rate 257 121 136 47.1% vs Games Wins Losses win rate Terran 79 51 28 64.6% Zerg 96 32 64 33.3% (ack!!) Protoss 82 38 44 46.3% Length of Game Win Rate Less than 10 minutes 49% 10-20 minutes 37% 20+ minutes 62% Map Games Wins Losses win rate Antiga Shipyard 46 24 22 52% Cloud Kingdom LE 48 23 25 48% Entombed Valley 4 3 1 75% Korhal Compound LE 47 23 24 49% Metalopolis 50 22 28 44% Shakuras Plateau 58 24 34 41% Tal'darim Altar LE NA/ Downvoted The Shattered Temple NA/Downvoted How did I get these stats? From this spreadsheet and an iphone app called SC2Stats. | ||
|
Norseman
United States223 Posts
| ||
|
bearhug
United States999 Posts
| ||
|
locrizak
Canada19 Posts
| ||
|
cesc
South Africa77 Posts
| ||
|
WarpMePlz
United Kingdom76 Posts
 shame about the vs Z lol :pI will look into season 7 changes tonight so I can get it done tomorrow (hopefully) I'm glad it's getting some good use and sorry about the link breaking (wtf? lol) - I have created an account with MediaFire now so hopefully it shouldn't happen again! On April 11 2012 04:02 stecman wrote: Can you make one for Season 7? Oh, just an FYI, here are my stats for season 6, thanks for your help! 1v1 Average game time 15:35 Average APM - 98 (it went up a lot more at the end of the season) Games Wins Loses Win rate 257 121 136 47.1% vs Games Wins Losses win rate Terran 79 51 28 64.6% Zerg 96 32 64 33.3% (ack!!) Protoss 82 38 44 46.3% Length of Game Win Rate Less than 10 minutes 49% 10-20 minutes 37% 20+ minutes 62% Map Games Wins Losses win rate Antiga Shipyard 46 24 22 52% Cloud Kingdom LE 48 23 25 48% Entombed Valley 4 3 1 75% Korhal Compound LE 47 23 24 49% Metalopolis 50 22 28 44% Shakuras Plateau 58 24 34 41% Tal'darim Altar LE NA/ Downvoted The Shattered Temple NA/Downvoted How did I get these stats? From this spreadsheet and an iphone app called SC2Stats. | ||
|
Muckles
Austria17 Posts
I realy want to keep track of my win/lose rate for a longer period of time. | ||
|
WarpMePlz
United Kingdom76 Posts
On April 11 2012 07:02 Muckles wrote: Will I be able to use my old stats from season 6 in the season 7 version? I realy want to keep track of my win/lose rate for a longer period of time. Yes, just copy and paste your old data into the new spreadsheet. | ||
|
Muckles
Austria17 Posts
| ||
|
stecman
United States14 Posts
| ||
|
Sabre
United Kingdom1086 Posts
| ||
|
WarpMePlz
United Kingdom76 Posts
On April 11 2012 23:12 Muckles wrote: Thx for the quick response i was just thinking it might be a problem when i also copy wins and loses from maps wich are not in the map pool in season 7. No problem mate. Stats from old maps will still count towards your overall winrate and winrate vsT vsZ vsP etc. Season 7 sheet is up btw :D | ||
|
retrobmx63
United States3 Posts
"The Excel 2007 "Big Grid" increases the maximum number of rows per worksheet from 65,536 to over 1 million, and the number of columns from 256 (IV) to 16,384 (XFD). " | ||
|
ShiaoPi
TAIWAN NUMBAH WAN5956 Posts
| ||
|
Muckles
Austria17 Posts
[B] Season 7 sheet is up btw :D Thanks man great job! | ||
| ||
