• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 18:32
CEST 00:32
KST 07:32
  • 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
[ASL22] Ro24 Preview: Summer's End6Serral wins HomeStory Cup 2915Serral wins Maestros of the Game 243ByuL, and the Limitations of Standard Play3Team Liquid Map Contest #22: Results and Winners7
Community News
Weekly Cups (August 10-16): SHIN doubles2GSTL Returns in 2026!44Weekly Cups (Aug 3-9): Protoss get shut out7RSL goes to London! 2026 Offline Finals Nov 21-2212Weekly Cups (July 27-Aug 2): SHIN's big week0
StarCraft 2
General
GSTL Returns in 2026! SC4ALL II: SC2 Player Announcement 6/8 - Maru Weekly Cups (August 10-16): SHIN doubles Balance hotfix patch 5.0.16b (July 16) SC4ALL: II Talent Announcement!
Tourneys
Master Swan Open (Global Bronze-Master 2) 2026 GSTL Announcement PIG STY FESTIVAL 8.0! (13 - 23 August) WardiTV Mondays 2026 KungFu Cup Announcement
Strategy
[G] Having the right mentality to improve
Custom Maps
Nexus Wars 2021 GUIDE [M] (2) Industrial Park
External Content
The PondCast: SC2 News & Results Mutation # 539 Thunder Dome Mutation # 538 Media Blackout Mutation # 537 Hostile Territory
Brood War
General
SC4ALL II: Brood War Player Announcement 3/4 - soO ALAMAT BCA KCU SUDIRMAN Telp:08218200203 ALAMAT BCA KCU KUNINGAN Telp:08218200233 BW General Discussion Rush's Odyssey Controversy
Tourneys
[ASL22] Ro24 Group B [ASL22] Ro24 Group A Small VOD Thread 2.0 CSLAN 4 is Coming!
Strategy
Odyssey Mineral Stack Saturation Fighting Spirit mining rates Any training maps people recommend? Simple Questions, Simple Answers
Other Games
General Games
Nintendo Switch Thread General RTS Discussion Thread Anyone here play Quakeworld back in the day? Stormgate/Frost Giant Megathread EVE Corporation
Dota 2
Official 'what is Dota anymore' discussion
League of Legends
[TL LoL EUW IHs] Teemo shall perish TSM pausing esports and CLG Dead
Heroes of the Storm
Heroes of the Storm 2.0
Hearthstone
Deck construction bug
TL Mafia
TL Mafia Power Rank TL Mafia Community Thread NeO.D_StephenKing vs This Guy From 1 Million Dance
Community
General
The Letting Off Steam Thread US Politics Mega-thread Artificial Intelligence Thread Russo-Ukrainian War Thread European Politico-economics QA Mega-thread
Fan Clubs
MarineLorD Fan Club The ShoWTimE Fan Club The herO Fan Club!
Media & Entertainment
Movie Discussion! Anime Discussion Thread Series you have seen recently...
Sports
Football (Soccer) Thread MLB/Baseball 2023 TeamLiquid Health and Fitness Initiative For 2023 NBA General Discussion Formula 1 Discussion
World Cup 2022
Tech Support
Computer Build, Upgrade & Buying Resource Thread Simple Questions Simple Answers FPS when play League Of Legend on laptop
TL Community
The Automated Ban List Northern Ireland Global Starcraft
Blogs
LOCKPICKING NOOB
LUCKY_NOOB
Chinese Gen Z: Between Dream…
TrAiDoS
Cathedral Of CS And NY pizza a…
FuDDx
Please support my new stand…
Peanutsc
Hello guys!
LIN1s
Customize Sidebar...

Website Feedback

Closed Threads



Active: 6141 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 States1260 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
Next event in 1h 28m
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
ProTech80
StarCraft: Brood War
Artosis 508
MaD[AoV]28
ajuk12(nOOB) 16
Counter-Strike
summit1g9005
Fnx 1031
minikerr21
Super Smash Bros
hungrybox432
PPMD50
Other Games
Grubby2985
Liquid`RaSZi1758
shahzam577
C9.Mang0214
Mew2King42
Trikslyr34
ViBE20
[ Show 11 non-featured ]
StarCraft 2
• RyuSc2 56
• davetesta37
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• Migwel
StarCraft: Brood War
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
Dota 2
• masondota21737
Upcoming Events
PiGosaur Cup
1h 28m
Replay Cast
10h 28m
Afreeca Starleague
11h 28m
BeSt vs Paralyze
Jaedong vs Speed
Kung Fu Cup
12h 28m
Replay Cast
1d 1h
The PondCast
1d 11h
KCM Race Survival
1d 11h
Replay Cast
2 days
Escore
2 days
PiG Sty Festival
2 days
[ Show More ]
CranKy Ducklings
3 days
PiG Sty Festival
3 days
Patches Events
3 days
Sparkling Tuna Cup
4 days
PiG Sty Festival
4 days
The Patches Monday
5 days
GSL
6 days
Liquipedia Results

Completed

CSLAN 4
CranK Gathers Season 4: BW vs SC2 Team League
Eternal Conflict S2 Finale

Ongoing

KCM Race Survival 2026 Season 3
K-JUNGMAN
ASL Season 22
Super Anchor Qualifying S3
RSL Revival: Season 6
PiG Sty Festival 8.0
META DYMY #4
Esports World Cup 2026
Esports World Cup 2026: LCQ
BLAST Bounty Summer 2026
BLAST Bounty Summer Qual
Stake Ranked Episode 3
XSE Pro League 2026
IEM Cologne Major 2026

Upcoming

CSL Season 22: Qualifier 1
Escore Tournament S3: W8
CSL Season 22: Qualifier 2
CSL 2026 AUTUMN (S22)
Acropolis #5
Acropolis #5 - TRS
Blizzard Classic Cup 2026
HSC XXX
SC4ALL II: StarCraft II
Kung Fu Cup 2026 Grand Finals
RSL Offline Finals
Big Dog Cup 2026 Div 1
Stake Ranked Episode 5
PGL Masters Bucharest 2026
Thunderpick World Champ. '26
ESL Pro League Season 24
Stake Ranked Episode 4
1win Private Club #1
Logitech G Play Connect 2026
SL StarSeries Fall 2026
FISSURE Playground #5
BLAST Open Fall 2026
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.