• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 09:30
CEST 15:30
KST 22:30
  • 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
Greatest Players of All Time: 2025 Update A Eulogy for the Six Pool BoxeR's Wings Episode 2 - Fan Translation #1: Maru - Greatest Players of All Time Geoff 'iNcontroL' Robinson has passed away
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
Post ASL20 Ro24 discussion. BW General 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: 2663 users

1v1 Stats Spreadsheet - Page 5

Forum Index > SC2 General
Post a Reply
Prev 1 2 3 4 5 6 7 9 10 11 Next All
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
December 10 2011 14:35 GMT
#81
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
Someone92
Profile Joined April 2010
Sweden49 Posts
December 22 2011 12:50 GMT
#82
Are u still updating this ? Would love and update for season 5
Igaryu85
Profile Joined November 2010
Germany195 Posts
December 22 2011 22:10 GMT
#83
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!
acidbean
Profile Joined January 2011
Germany287 Posts
December 22 2011 22:44 GMT
#84
Just use the "Find & Replace" option in Excel. I did that last night and it seems to work fine.
Igaryu85
Profile Joined November 2010
Germany195 Posts
December 22 2011 23:54 GMT
#85
Thanks bean ;-)
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
Last Edited: 2011-12-23 14:10:55
December 23 2011 13:14 GMT
#86
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!
howLiN
Profile Blog Joined April 2011
Portugal1676 Posts
December 23 2011 14:00 GMT
#87
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...
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
December 23 2011 14:03 GMT
#88
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
Xkfyu
Profile Joined December 2006
United States165 Posts
December 23 2011 14:32 GMT
#89
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.
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
Last Edited: 2011-12-23 14:50:37
December 23 2011 14:46 GMT
#90
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
acidbean
Profile Joined January 2011
Germany287 Posts
December 23 2011 18:14 GMT
#91
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
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
Last Edited: 2011-12-24 12:03:03
December 24 2011 12:02 GMT
#92
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
docvoc
Profile Blog Joined July 2011
United States5491 Posts
December 24 2011 12:36 GMT
#93
on mac i keep having excel stop working whenever i run this! Any answers for how to make that not happen?
User was warned for too many mimes.
Malkavian183
Profile Joined February 2011
Turkey227 Posts
December 25 2011 21:50 GMT
#94
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.
Inject Bitch!
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
December 31 2011 17:26 GMT
#95
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.
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
December 31 2011 17:27 GMT
#96
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
coMbs
Profile Joined May 2011
United States50 Posts
January 10 2012 10:01 GMT
#97
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.
CatsnHats
Profile Joined October 2011
United States199 Posts
February 11 2012 02:00 GMT
#98
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?
meow
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
February 12 2012 15:30 GMT
#99
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!
Vague
Profile Joined April 2011
170 Posts
Last Edited: 2012-02-12 19:11:41
February 12 2012 18:45 GMT
#100
Prev 1 2 3 4 5 6 7 9 10 11 Next All
Please log in or register to reply.
Live Events Refresh
LiuLi Cup
11:00
Monthly Finals
Classic vs HeRoMaRinELIVE!
TriGGeR vs herO
Rogue vs TBD
WardiTV742
Harstem374
TKL 248
IndyStarCraft 158
Rex137
CranKy Ducklings93
IntoTheiNu 35
3DClanTV 11
Liquipedia
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
Harstem 374
TKL 248
mouzHeroMarine 206
IndyStarCraft 158
Rex 137
StarCraft: Brood War
Britney 39993
Calm 6202
Horang2 1675
Rain 1530
PianO 1078
Larva 710
Mini 434
EffOrt 429
Stork 397
BeSt 336
[ Show more ]
actioN 322
ggaemo 249
Hyuk 185
Leta 179
Light 177
Snow 175
Mong 165
firebathero 147
Soulkey 144
ZerO 139
Zeus 129
TY 126
Soma 122
Barracks 119
Rush 85
Hyun 85
Mind 62
JYJ55
Sharp 50
Sea.KH 44
Yoon 43
[sc1f]eonzerg 42
sorry 37
zelot 35
ToSsGirL 35
Pusan 31
Sacsri 29
soO 23
yabsab 14
ajuk12(nOOB) 13
Terrorterran 13
HiyA 6
Hm[arnc] 5
Dota 2
Gorgc4197
qojqva2460
XcaliburYe247
XaKoH 195
Counter-Strike
fl0m665
byalli251
flusha183
oskar167
Other Games
B2W.Neo1909
Lowko420
DeMusliM381
Mlord375
SortOf120
Hui .111
ArmadaUGS58
djWHEAT54
QueenE40
ZerO(Twitch)17
MindelVK8
Dewaltoss7
Liquid`VortiX7
Organizations
Counter-Strike
PGL3183
StarCraft: Brood War
UltimateBattle 1027
Other Games
Algost 1
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 15 non-featured ]
StarCraft 2
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• Michael_bg 1
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
Dota 2
• C_a_k_e 600
• WagamamaTV408
League of Legends
• Jankos1692
• Stunt391
Upcoming Events
Cosmonarchy
2h 30m
OyAji vs Sziky
Sziky vs WolFix
WolFix vs OyAji
Big Brain Bouts
2h 30m
Iba vs GgMaChine
TriGGeR vs Bunny
Reynor vs Classic
Serral vs Clem
BSL Team Wars
5h 30m
Team Hawk vs Team Dewalt
BSL Team Wars
5h 30m
Team Hawk vs Team Bonyth
Code For Giants Cup
9h
SC Evo League
22h 30m
TaeJa vs Cure
Rogue vs threepoint
ByuN vs Creator
MaNa vs Classic
Maestros of the Game
1d 2h
ShoWTimE vs Cham
GuMiho vs Ryung
Zoun vs Spirit
Rogue vs MaNa
[BSL 2025] Weekly
1d 4h
SC Evo League
1d 22h
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.