• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EST 15:20
CET 21:20
KST 05:20
  • 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
Behind the Blue - Team Liquid History Book15Clem wins HomeStory Cup 289HomeStory Cup 28 - Info & Preview13Rongyi Cup S3 - Preview & Info8herO wins SC2 All-Star Invitational14
Community News
ACS replaced by "ASL Season Open" - Starts 21/0220LiuLi Cup: 2025 Grand Finals (Feb 10-16)25Weekly Cups (Feb 2-8): Classic, Solar, MaxPax win2Nexon's StarCraft game could be FPS, led by UMS maker10PIG STY FESTIVAL 7.0! (19 Feb - 1 Mar)13
StarCraft 2
General
How do you think the 5.0.15 balance patch (Oct 2025) for StarCraft II has affected the game? Nexon's StarCraft game could be FPS, led by UMS maker Terran Scanner Sweep Behind the Blue - Team Liquid History Book Weekly Cups (Jan 12-18): herO, MaxPax, Solar win
Tourneys
RSL Season 4 announced for March-April LiuLi Cup: 2025 Grand Finals (Feb 10-16) PIG STY FESTIVAL 7.0! (19 Feb - 1 Mar) RSL Revival: Season 4 Korea Qualifier (Feb 14) Sparkling Tuna Cup - Weekly Open Tournament
Strategy
Custom Maps
Map Editor closed ? [A] Starcraft Sound Mod
External Content
The PondCast: SC2 News & Results Mutation # 512 Overclocked Mutation # 511 Temple of Rebirth Mutation # 510 Safety Violation
Brood War
General
ACS replaced by "ASL Season Open" - Starts 21/02 Which units you wish saw more use in the game? StarCraft player reflex TE scores [ASL21] Potential Map Candidates Gypsy to Korea
Tourneys
[Megathread] Daily Proleagues Escore Tournament StarCraft Season 1 Small VOD Thread 2.0 KCM Race Survival 2026 Season 1
Strategy
Fighting Spirit mining rates Zealot bombing is no longer popular? Simple Questions, Simple Answers Current Meta
Other Games
General Games
Nintendo Switch Thread Path of Exile Diablo 2 thread Battle Aces/David Kim RTS Megathread ZeroSpace Megathread
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
Deck construction bug Heroes of StarCraft mini-set
TL Mafia
TL Mafia Community Thread Mafia Game Mode Feedback/Ideas Vanilla Mini Mafia
Community
General
US Politics Mega-thread Ask and answer stupid questions here! European Politico-economics QA Mega-thread The Games Industry And ATVI Russo-Ukrainian War Thread
Fan Clubs
The IdrA Fan Club The herO Fan Club!
Media & Entertainment
[Req][Books] Good Fantasy/SciFi books [Manga] One Piece Anime Discussion Thread
Sports
2024 - 2026 Football Thread
World Cup 2022
Tech Support
TL Community
The Automated Ban List
Blogs
ADHD And Gaming Addiction…
TrAiDoS
My 2025 Magic: The Gathering…
DARKING
Life Update and thoughts.
FuDDx
How do archons sleep?
8882
StarCraft improvement
iopq
Customize Sidebar...

Website Feedback

Closed Threads



Active: 1927 users

Tracking your 1v1 games - Page 2

Forum Index > SC2 General
Post a Reply
Prev 1 2 3 4 5 Next All
Toxin451
Profile Blog Joined August 2010
United States34 Posts
March 20 2011 06:12 GMT
#21
On March 20 2011 12:30 jmbthirteen wrote:
Pretty cool man, good work!

Thanks.
Appreciate all the messages, everyone. I hope it helps. I'd love to hear if someone really gets some value out of it, like finding out that your "worst match" wasn't the one you thought it was - or something.
"you don't need to panic, because that is bad for you" Dimaga on Mr Bitter's 12 weeks
Toxin451
Profile Blog Joined August 2010
United States34 Posts
March 22 2011 20:38 GMT
#22
Added a couple more features and a new sheet and a "win/loss by date" chart. I think these will be my final updates before the new season starts.
"you don't need to panic, because that is bad for you" Dimaga on Mr Bitter's 12 weeks
daimyo
Profile Blog Joined March 2011
77 Posts
March 22 2011 21:07 GMT
#23
thank you very much for this. this is awesome.
CraZyWayne
Profile Joined August 2010
Germany357 Posts
March 22 2011 21:10 GMT
#24
Hahahahaha, it's 2011 and Starcraft 2 is out for several months now, but people have to make excel files to calculate win/loss ratios. Thank you Blizzard! ♥


Sad.
"tahts halo. dont worry"
Toxin451
Profile Blog Joined August 2010
United States34 Posts
March 23 2011 17:41 GMT
#25
On March 23 2011 06:10 CraZyWayne wrote:
Hahahahaha, it's 2011 and Starcraft 2 is out for several months now, but people have to make excel files to calculate win/loss ratios. Thank you Blizzard! ♥
Sad.


Oh it does so much more than that.............
"you don't need to panic, because that is bad for you" Dimaga on Mr Bitter's 12 weeks
Crankenstein
Profile Joined December 2010
Australia150 Posts
March 23 2011 21:45 GMT
#26
Thanks for the file... very awesome
Phinix
Profile Joined October 2010
United States116 Posts
March 23 2011 22:56 GMT
#27
Beautifully polished. Kudos! :-)
My wife thinks day[9] is hot
Toxin451
Profile Blog Joined August 2010
United States34 Posts
March 28 2011 23:32 GMT
#28
New season tomorrow! Don't forget to start tracking your 1v1 games!
"you don't need to panic, because that is bad for you" Dimaga on Mr Bitter's 12 weeks
Bizarro252
Profile Joined January 2011
180 Posts
March 29 2011 00:39 GMT
#29
Haha, I actually started working on putting one like this together for myself just yesterday and was going to post it when it was done, yours is already way better than mine so thanks!!
Ben...
Profile Joined January 2011
Canada3485 Posts
Last Edited: 2011-03-29 00:54:58
March 29 2011 00:46 GMT
#30
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.
"Cliiiiiiiiiiiiiiiiide" -Tastosis
alexhard
Profile Joined May 2010
Sweden317 Posts
March 29 2011 00:59 GMT
#31
Now if I could just directly paste the data from sc2gears into this file...
Gemini_19
Profile Joined June 2010
United States1252 Posts
March 29 2011 01:07 GMT
#32
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.


Yeh, it still has all your stuff in it. I would love this tho! I've been trying to figure out how to do this for ages now.
@GGemini19 GM Protoss | http://www.twitch.tv/geminisc2 | I <333 HerO & Trap | Check out my Build of the Week series on /r/allthingsprotoss, TL, or Spawning Tool
kYem
Profile Blog Joined March 2010
United Kingdom412 Posts
March 29 2011 01:09 GMT
#33
Well you could use sc2gears.... that will save a lot of time ...

I still have all my replays since release and i can see my win/lose with out much problem it really good to look at map win rates, other than that go for master league ! If win/loses is so important, you should be able to get in master rather soon.
Hell
AsianBullets
Profile Joined March 2011
United States26 Posts
March 29 2011 01:19 GMT
#34
How do I quickly delete all your data? I want to, well, of course, make room for my profile )
[Silverflame]
Profile Joined March 2009
Germany640 Posts
March 29 2011 01:37 GMT
#35
This is great work, thank you! If there would be something like this implemented into the b.net itself all my dreams would become true :D ... Well and hosting replays ofc^^
Fav P Stork / Fav T Fantasy / Fav Z Hoejja
duartesito
Profile Joined March 2010
Dominican Republic32 Posts
March 29 2011 02:26 GMT
#36
Thanks a lot! Gonna be using this a lot! One question though, how can i know what league my opponent is from?
Im just out buying soy souce
Moody
Profile Blog Joined August 2010
United States750 Posts
March 29 2011 02:35 GMT
#37
Neat!!
I don't know how to use it though

I think I might download SC2Gears now...
A marine walks into a bar and asks, "Where's the counter?"
Final3
Profile Joined August 2010
United States15 Posts
Last Edited: 2011-03-29 04:11:04
March 29 2011 03:50 GMT
#38
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?
Bizarro252
Profile Joined January 2011
180 Posts
March 29 2011 04:47 GMT
#39
Found a way to have the tables auto refresh everytime you open the file:

http://www.techonthenet.com/excel/pivottbls/on_open2007.php
Delay559
Profile Joined January 2011
France89 Posts
Last Edited: 2011-03-29 06:44:50
March 29 2011 06:43 GMT
#40
+ Show Spoiler +
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?



ya can anyone do this? i cant figure it out, any help on how to do it would be really... helpfull
Join erepublik! :D http://www.erepublik.com/en/referrer/RonanSC
Prev 1 2 3 4 5 Next All
Please log in or register to reply.
Live Events Refresh
AI Arena Tournament
20:00
Swiss - Final Day
Laughngamez YouTube
RSL Revival
18:00
S4 Europe Server Qualifier
IndyStarCraft 316
LiquipediaDiscussion
PSISTORM Gaming Misc
16:55
FSL TeamLeague S10: ASH vs POG
Freeedom20
Liquipedia
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
SteadfastSC 324
IndyStarCraft 316
BRAT_OK 88
mouzHeroMarine 2
StarCraft: Brood War
Calm 2088
nyoken 58
NaDa 5
Dota 2
febbydoto16
LuMiX1
Counter-Strike
fl0m4348
Dendi407
Super Smash Bros
Mew2King104
Heroes of the Storm
Khaldor540
MindelVK14
Other Games
gofns26830
Grubby5278
tarik_tv4256
FrodaN4030
Mlord600
KnowMe467
ToD258
Liquid`Hasu213
Trikslyr83
Organizations
Counter-Strike
PGL23920
Other Games
EGCTV1439
gamesdonequick1198
StarCraft 2
angryscii 27
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 18 non-featured ]
StarCraft 2
• printf 64
• Airneanach13
• sooper7s
• AfreecaTV YouTube
• intothetv
• Migwel
• Kozan
• IndyKCrew
• LaughNgamezSOOP
StarCraft: Brood War
• blackmanpl 26
• FirePhoenix4
• STPLYoutube
• ZZZeroYoutube
• BSLYoutube
Dota 2
• lizZardDota235
League of Legends
• Nemesis7657
Other Games
• imaqtpie1936
• Shiphtur559
Upcoming Events
Replay Cast
3h 41m
Sparkling Tuna Cup
13h 41m
LiuLi Cup
14h 41m
Maru vs Reynor
Serral vs Rogue
Ladder Legends
21h 41m
Replay Cast
1d 3h
Replay Cast
1d 12h
Wardi Open
1d 15h
Monday Night Weeklies
1d 20h
OSC
2 days
WardiTV Winter Champion…
2 days
[ Show More ]
Replay Cast
3 days
WardiTV Winter Champion…
3 days
Replay Cast
4 days
PiG Sty Festival
4 days
The PondCast
4 days
KCM Race Survival
4 days
WardiTV Winter Champion…
4 days
Replay Cast
5 days
PiG Sty Festival
5 days
Epic.LAN
5 days
Replay Cast
6 days
PiG Sty Festival
6 days
CranKy Ducklings
6 days
Epic.LAN
6 days
Liquipedia Results

Completed

Escore Tournament S1: W8
Rongyi Cup S3
Underdog Cup #3

Ongoing

KCM Race Survival 2026 Season 1
LiuLi Cup: 2025 Grand Finals
Nations Cup 2026
PGL Cluj-Napoca 2026
IEM Kraków 2026
BLAST Bounty Winter 2026
BLAST Bounty Winter Qual
eXTREMESLAND 2025
SL Budapest Major 2025

Upcoming

Escore Tournament S1: King of Kings
[S:21] ASL SEASON OPEN 1st Round
[S:21] ASL SEASON OPEN 1st Round Qualifier
[S:21] ASL SEASON OPEN 2nd Round
[S:21] ASL SEASON OPEN 2nd Round Qualifier
Acropolis #4
IPSL Spring 2026
HSC XXIX
uThermal 2v2 2026 Main Event
Bellum Gens Elite Stara Zagora 2026
RSL Revival: Season 4
WardiTV Winter 2026
BLAST Rivals Spring 2026
CCT Season 3 Global Finals
FISSURE Playground #3
IEM Rio 2026
PGL Bucharest 2026
Stake Ranked Episode 1
BLAST Open Spring 2026
ESL Pro League Season 23
ESL Pro League Season 23
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 © 2026 TLnet. All Rights Reserved.