• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 10:46
CEST 16:46
KST 23:46
  • Home
  • Forum
  • Calendar
  • Streams
  • Liquipedia
  • Features
  • Store
  • EPT
  • TL+
  • StarCraft 2
  • Brood War
  • Smash
  • Heroes
  • Counter-Strike
  • Overwatch
  • Liquibet
  • Fantasy StarCraft
  • TLPD
  • StarCraft 2
  • Brood War
  • Blogs
Forum Sidebar
Events/Features
News
Featured News
[ASL20] Ro24 Preview Pt2: Take-Off7[ASL20] Ro24 Preview Pt1: Runway132v2 & SC: Evo Complete: Weekend Double Feature4Team Liquid Map Contest #21 - Presented by Monster Energy9uThermal's 2v2 Tour: $15,000 Main Event18
Community News
Weekly Cups (Aug 18-24): herO dethrones MaxPax6Maestros of The Game—$20k event w/ live finals in Paris34Weekly Cups (Aug 11-17): MaxPax triples again!13Weekly Cups (Aug 4-10): MaxPax wins a triple6SC2's Safe House 2 - October 18 & 195
StarCraft 2
General
+2347089754903, I want to join illuminati %™✓ BoxeR's Wings Episode 2 - Fan Translation Greatest Players of All Time: 2025 Update A Eulogy for the Six Pool #1: Maru - Greatest Players of All Time
Tourneys
LiuLi Cup - August 2025 Tournaments $5,000 WardiTV Summer Championship 2025 Maestros of The Game—$20k event w/ live finals in Paris $5,100+ SEL Season 2 Championship (SC: Evo) Esports World Cup 2025
Strategy
Custom Maps
External Content
Mutation # 488 What Goes Around Mutation # 487 Think Fast Mutation # 486 Watch the Skies Mutation # 485 Death from Below
Brood War
General
BW General Discussion Post ASL20 Ro24 discussion. No Rain in ASL20? BGH Auto Balance -> http://bghmmr.eu/ Recent recommended BW games
Tourneys
[ASL20] Ro24 Group F [ASL20] Ro24 Group E [IPSL] CSLAN Review and CSLPRO Reimagined! [ASL20] Ro24 Group D
Strategy
Muta micro map competition Simple Questions, Simple Answers Fighting Spirit mining rates [G] Mineral Boosting
Other Games
General Games
Stormgate/Frost Giant Megathread Nintendo Switch Thread General RTS Discussion Thread Mechabellum Dawn of War IV
Dota 2
Official 'what is Dota anymore' discussion
League of Legends
Heroes of the Storm
Simple Questions, Simple Answers Heroes of the Storm 2.0
Hearthstone
Heroes of StarCraft mini-set
TL Mafia
TL Mafia Community Thread Vanilla Mini Mafia
Community
General
US Politics Mega-thread Russo-Ukrainian War Thread Things Aren’t Peaceful in Palestine The year 2050 European Politico-economics QA Mega-thread
Fan Clubs
INnoVation Fan Club SKT1 Classic Fan Club!
Media & Entertainment
Anime Discussion Thread Movie Discussion! [Manga] One Piece [\m/] Heavy Metal Thread
Sports
2024 - 2026 Football Thread Formula 1 Discussion TeamLiquid Health and Fitness Initiative For 2023
World Cup 2022
Tech Support
Computer Build, Upgrade & Buying Resource Thread High temperatures on bridge(s) Gtx660 graphics card replacement
TL Community
The Automated Ban List TeamLiquid Team Shirt On Sale
Blogs
Lemme tell you a thing o…
JoinTheRain
How Culture and Conflict Imp…
TrAiDoS
RTS Design in Hypercoven
a11
Evil Gacha Games and the…
ffswowsucks
INDEPENDIENTE LA CTM
XenOsky
Customize Sidebar...

Website Feedback

Closed Threads



Active: 2863 users

1v1 Stats Spreadsheet - Page 7

Forum Index > SC2 General
Post a Reply
Prev 1 5 6 7 8 9 11 Next All
PAD
Profile Joined July 2011
United Kingdom15 Posts
February 19 2012 11:11 GMT
#121
thank you for ongoing support for the new season
rar tbh innit
odin607
Profile Joined October 2010
United States23 Posts
February 19 2012 11:23 GMT
#122
To prevent "#DIV/0" use =IF(ISERROR(equation,0,equation))

Example: Overall stats winrate vs terran:=IF(ISERROR(KL12/KK12,0,KL12/KK12)
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
February 19 2012 11:55 GMT
#123
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
Profile Joined August 2011
Canada1521 Posts
February 27 2012 14:41 GMT
#124
I was using this fine up until this morning. Now I can't enter the date or save any new information, it won't let me copy any of the information either does anyone know why?

Also is there any way to just copy this over to a google spreadsheet?
Mouffle
Profile Joined March 2011
France2 Posts
March 10 2012 11:24 GMT
#125
Very nice job thank you,
stecman
Profile Joined March 2011
United States14 Posts
April 10 2012 19:02 GMT
#126
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.
Norseman
Profile Joined May 2010
United States223 Posts
April 10 2012 19:43 GMT
#127
The link in the original post is coming up as a dead link for me. Is there an alternate place I can get this spreadsheet?
Become a better player: http://www.teamliquid.net/forum/viewmessage.php?topic_id=246138
bearhug
Profile Joined September 2010
United States999 Posts
April 10 2012 19:55 GMT
#128
Download link dead....
We are dusts in the vast cosmic arena. Need to make the most out of life when we still have it.
locrizak
Profile Joined June 2010
Canada19 Posts
April 10 2012 20:00 GMT
#129
sheeeet dead link was excited to kill some time looking at this
cesc
Profile Joined April 2011
South Africa77 Posts
April 10 2012 20:08 GMT
#130
need a new link this looks awesome :D/
www.kk-gaming.co.za | www.polarfluke.co.za
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
April 10 2012 20:17 GMT
#131
Wow nice shame about the vs Z lol :p

I 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
Profile Joined April 2012
Austria17 Posts
April 10 2012 22:02 GMT
#132
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.
People say the best weapon is the weapon you never need to use, I say the best weapon is the weapon you only use once!
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
April 10 2012 22:08 GMT
#133
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
Profile Joined April 2012
Austria17 Posts
April 11 2012 14:12 GMT
#134
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.
People say the best weapon is the weapon you never need to use, I say the best weapon is the weapon you only use once!
stecman
Profile Joined March 2011
United States14 Posts
April 11 2012 17:10 GMT
#135
Can't wait for season 7. Also, I've got some killer ideas of simple ways you can really make this even more awesome than it already is. I tried doing it myself, but I don't quite have the Excel Skills.
Sabre
Profile Blog Joined February 2011
United Kingdom1086 Posts
April 11 2012 17:11 GMT
#136
this should be pretty awesome
UK TrackMania Champion | Former SC2 player | http://www.twitter.com/Sabre_CS
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
April 11 2012 19:25 GMT
#137
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
Profile Joined February 2012
United States3 Posts
April 11 2012 20:01 GMT
#138
Shit looks like those of us still running Office 2003 are out of luck. I didn't realize you used so many damn columns. It breaks the conversion to the old xls format.

"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). "
I don't even know wtf a quail is...
ShiaoPi
Profile Blog Joined October 2011
TAIWAN NUMBAH WAN5956 Posts
April 11 2012 20:29 GMT
#139
Thanks for the great spreadsheet it looks totally awesome!
LiquidDota Staff@TW_ShiaoPi
TL+ Member
Muckles
Profile Joined April 2012
Austria17 Posts
April 11 2012 20:40 GMT
#140
[B] Season 7 sheet is up btw :D

Thanks man great job!
People say the best weapon is the weapon you never need to use, I say the best weapon is the weapon you only use once!
Prev 1 5 6 7 8 9 11 Next All
Please log in or register to reply.
Live Events Refresh
LiuLi Cup
11:00
Monthly Finals
Rogue vs ClassicLIVE!
herO vs TBD
WardiTV1081
TKL 237
Rex145
IndyStarCraft 128
CranKy Ducklings117
3DClanTV 33
IntoTheiNu 32
Liquipedia
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
mouzHeroMarine 368
TKL 237
Rex 145
IndyStarCraft 128
StarCraft: Brood War
Britney 43096
Calm 6230
Horang2 1825
Rain 1528
PianO 899
BeSt 501
EffOrt 461
Stork 435
actioN 425
Mini 388
[ Show more ]
Light 378
ggaemo 272
Snow 205
TY 185
Soulkey 177
firebathero 173
Hyuk 147
Zeus 138
Mong 131
Rush 127
Barracks 110
Mind 84
Hyun 80
Sea.KH 57
Yoon 43
Pusan 40
ToSsGirL 40
[sc1f]eonzerg 39
sorry 37
zelot 28
soO 25
Sacsri 24
Movie 22
Terrorterran 18
ajuk12(nOOB) 17
yabsab 13
HiyA 12
JulyZerg 11
Hm[arnc] 8
Dota 2
Gorgc5981
qojqva3102
syndereN296
XcaliburYe251
Counter-Strike
fl0m2604
byalli306
oskar189
Other Games
B2W.Neo742
Mlord489
Lowko459
Happy168
Liquid`VortiX141
Hui .115
KnowMe107
QueenE52
Mew2King42
Organizations
Other Games
Algost 2
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 16 non-featured ]
StarCraft 2
• intothetv
• IndyKCrew
• sooper7s
• AfreecaTV YouTube
• Migwel
• LaughNgamezSOOP
• Kozan
StarCraft: Brood War
• Michael_bg 6
• STPLYoutube
• ZZZeroYoutube
• BSLYoutube
Dota 2
• C_a_k_e 1003
• WagamamaTV558
League of Legends
• Jankos2717
• TFBlade654
• Stunt461
Upcoming Events
Cosmonarchy
1h 14m
OyAji vs Sziky
Sziky vs WolFix
WolFix vs OyAji
Big Brain Bouts
1h 14m
Iba vs GgMaChine
TriGGeR vs Bunny
Reynor vs Classic
Serral vs Clem
BSL Team Wars
4h 14m
Team Hawk vs Team Dewalt
BSL Team Wars
4h 14m
Team Hawk vs Team Bonyth
Code For Giants Cup
7h 44m
SC Evo League
21h 14m
TaeJa vs Cure
Rogue vs threepoint
ByuN vs Creator
MaNa vs Classic
Maestros of the Game
1d 1h
ShoWTimE vs Cham
GuMiho vs Ryung
Zoun vs Spirit
Rogue vs MaNa
[BSL 2025] Weekly
1d 3h
SC Evo League
1d 21h
Maestros of the Game
2 days
SHIN vs Creator
Astrea vs Lambo
Bunny vs SKillous
HeRoMaRinE vs TriGGeR
[ Show More ]
BSL Team Wars
2 days
Team Bonyth vs Team Sziky
BSL Team Wars
2 days
Team Dewalt vs Team Sziky
Monday Night Weeklies
3 days
Replay Cast
3 days
Sparkling Tuna Cup
3 days
PiGosaur Monday
4 days
LiuLi Cup
4 days
Replay Cast
5 days
The PondCast
5 days
RSL Revival
5 days
Maru vs SHIN
MaNa vs MaxPax
RSL Revival
6 days
Reynor vs Astrea
Classic vs sOs
Liquipedia Results

Completed

CSL Season 18: Qualifier 1
WardiTV Summer 2025
HCC Europe

Ongoing

Copa Latinoamericana 4
BSL 20 Team Wars
KCM Race Survival 2025 Season 3
BSL 21 Qualifiers
ASL Season 20
Acropolis #4 - TS1
CSL Season 18: Qualifier 2
SEL Season 2 Championship
BLAST Open Fall Qual
Esports World Cup 2025
BLAST Bounty Fall 2025
BLAST Bounty Fall Qual
IEM Cologne 2025
FISSURE Playground #1
BLAST.tv Austin Major 2025

Upcoming

CSL 2025 AUTUMN (S18)
LASL Season 20
BSL Season 21
BSL 21 Team A
Chzzk MurlocKing SC1 vs SC2 Cup #2
Maestros of the Game
EC S1
Sisters' Call Cup
Skyesports Masters 2025
IEM Chengdu 2025
PGL Masters Bucharest 2025
Thunderpick World Champ.
MESA Nomadic Masters Fall
CS Asia Championships 2025
ESL Pro League S22
StarSeries Fall 2025
FISSURE Playground #2
BLAST Open Fall 2025
TLPD

1. ByuN
2. TY
3. Dark
4. Solar
5. Stats
6. Nerchio
7. sOs
8. soO
9. INnoVation
10. Elazer
1. Rain
2. Flash
3. EffOrt
4. Last
5. Bisu
6. Soulkey
7. Mini
8. Sharp
Sidebar Settings...

Advertising | Privacy Policy | Terms Of Use | Contact Us

Original banner artwork: Jim Warren
The contents of this webpage are copyright © 2025 TLnet. All Rights Reserved.