• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 02:04
CEST 08:04
KST 15:04
  • 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
Serral wins EWC 202519Tournament Spotlight: FEL Cracow 20259Power Rank - Esports World Cup 202580RSL Season 1 - Final Week9[ASL19] Finals Recap: Standing Tall15
Community News
[BSL 2025] H2 - Team Wars, Weeklies & SB Ladder2EWC 2025 - Replay Pack2Google Play ASL (Season 20) Announced33BSL Team Wars - Bonyth, Dewalt, Hawk & Sziky teams10Weekly Cups (July 14-20): Final Check-up0
StarCraft 2
General
#1: Maru - Greatest Players of All Time Greatest Players of All Time: 2025 Update Serral wins EWC 2025 Power Rank - Esports World Cup 2025 EWC 2025 - Replay Pack
Tourneys
TaeJa vs Creator Bo7 SC Evo Showmatch Sparkling Tuna Cup - Weekly Open Tournament FEL Cracov 2025 (July 27) - $10,000 live event Esports World Cup 2025 $25,000 Streamerzone StarCraft Pro Series announced
Strategy
How did i lose this ZvP, whats the proper response
Custom Maps
External Content
Mutation # 484 Magnetic Pull Mutation #239 Bad Weather Mutation # 483 Kill Bot Wars Mutation # 482 Wheel of Misfortune
Brood War
General
Help: rep cant save Shield Battery Server New Patch Google Play ASL (Season 20) Announced [G] Progamer Settings StarCraft & BroodWar Campaign Speedrun Quest
Tourneys
[BSL] Non-Korean Championship - Final weekend [Megathread] Daily Proleagues [BSL20] Non-Korean Championship 4x BSL + 4x China CSL Xiamen International Invitational
Strategy
Does 1 second matter in StarCraft? Simple Questions, Simple Answers Muta micro map competition [G] Mineral Boosting
Other Games
General Games
Nintendo Switch Thread Stormgate/Frost Giant Megathread Total Annihilation Server - TAForever [MMORPG] Tree of Savior (Successor of Ragnarok) Path of Exile
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 UK Politics Mega-thread Russo-Ukrainian War Thread Stop Killing Games - European Citizens Initiative Things Aren’t Peaceful in Palestine
Fan Clubs
INnoVation Fan Club SKT1 Classic Fan Club!
Media & Entertainment
Anime Discussion Thread [\m/] Heavy Metal Thread Movie Discussion! [Manga] One Piece Korean Music Discussion
Sports
2024 - 2025 Football Thread Formula 1 Discussion TeamLiquid Health and Fitness Initiative For 2023 NBA General Discussion
World Cup 2022
Tech Support
Gtx660 graphics card replacement Installation of Windows 10 suck at "just a moment" Computer Build, Upgrade & Buying Resource Thread
TL Community
TeamLiquid Team Shirt On Sale The Automated Ban List
Blogs
Ping To Win? Pings And Their…
TrAiDoS
momentary artworks from des…
tankgirl
from making sc maps to makin…
Husyelt
StarCraft improvement
iopq
Socialism Anyone?
GreenHorizons
Eight Anniversary as a TL…
Mizenhauer
Customize Sidebar...

Website Feedback

Closed Threads



Active: 567 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 States1238 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
PiGosaur Monday
00:00
#42
davetesta132
Liquipedia
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
WinterStarcraft650
ProTech57
StarCraft: Brood War
Sea 4108
PianO 312
Snow 206
Leta 190
Bale 40
Noble 40
Sacsri 13
Icarus 10
Aegong 9
Dota 2
NeuroSwarm110
Counter-Strike
Stewie2K1207
Coldzera 475
Other Games
summit1g10972
shahzam700
Organizations
Other Games
gamesdonequick1330
StarCraft: Brood War
UltimateBattle 58
Other Games
BasetradeTV38
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 14 non-featured ]
StarCraft 2
• practicex 43
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• iopq 2
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
League of Legends
• Rush1860
• Stunt544
Upcoming Events
OSC
6h 26m
uThermal 2v2 Circuit
9h 56m
The PondCast
1d 3h
Online Event
1d 9h
Korean StarCraft League
2 days
CranKy Ducklings
3 days
BSL20 Non-Korean Champi…
3 days
Mihu vs QiaoGege
Zhanhun vs Dewalt
Fengzi vs TBD
Online Event
3 days
Sparkling Tuna Cup
4 days
BSL20 Non-Korean Champi…
4 days
Bonyth vs TBD
[ Show More ]
OSC
5 days
Liquipedia Results

Completed

BSL 20 Non-Korean Championship
FEL Cracow 2025
Underdog Cup #2

Ongoing

Copa Latinoamericana 4
Jiahua Invitational
BSL 20 Team Wars
CC Div. A S7
IEM Cologne 2025
FISSURE Playground #1
BLAST.tv Austin Major 2025
ESL Impact League Season 7
IEM Dallas 2025
PGL Astana 2025

Upcoming

BSL 21 Qualifiers
ASL Season 20: Qualifier #1
ASL Season 20: Qualifier #2
ASL Season 20
CSLPRO Chat StarLAN 3
BSL Season 21
RSL Revival: Season 2
Maestros of the Game
SEL Season 2 Championship
WardiTV Summer 2025
uThermal 2v2 Main Event
HCC Europe
Yuqilin POB S2
ESL Pro League S22
StarSeries Fall 2025
FISSURE Playground #2
BLAST Open Fall 2025
BLAST Open Fall Qual
Esports World Cup 2025
BLAST Bounty Fall 2025
BLAST Bounty Fall Qual
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.