• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 13:39
CEST 19:39
KST 02:39
  • 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
ByuL, and the Limitations of Standard Play3Team Liquid Map Contest #22: Results and Winners7Code S Season 2 (2026): RO4 and Finals Preview12TL.net Map Contest #22 - Voting & Ladder Map Selection7Code S Season 2 (2026) - RO8 Preview8
Community News
MC vs IdrA, Boxer vs Nal_rA to be Legacy Matches @ BlizzCon175.0.16 Hotfix (June 30) - Balance + Bug Fixes21Weekly Cups (June 22-28): Zergs thrive in new patch2[TLMC] Summer 2026 Ladder Map Rotation05.0.16 patch for SC2 goes live (8 worker start)99
StarCraft 2
General
5.0.16 Hotfix (June 30) - Balance + Bug Fixes MC vs IdrA, Boxer vs Nal_rA to be Legacy Matches @ BlizzCon 5.0.16 patch for SC2 goes live (8 worker start) Is the larve respawn broken? ByuL, and the Limitations of Standard Play
Tourneys
RSL Revival: Season 6 - Qualifiers and Main Event Douyu Cup 2026: $20,000 Legends Event (June 26-28) Maestros of The Game 2 announcement and schedule ! INu's Battles#17 <BO.9> Sparkling Tuna Cup - Weekly Open Tournament
Strategy
[G] Having the right mentality to improve
Custom Maps
New Map Maker - Looking for Advice - Love or Hate Work In Progress Melee Maps [D]RTS in all its shapes and glory <3
External Content
The PondCast: SC2 News & Results Mutation # 532 Nuclear Family Mutation # 531 Experimental Artillery Mutation # 530 One For All
Brood War
General
ASL 22 Proposed Map Pool Starcraft vs Retro Category on Twitch ProGamer Paychecks Story BW General Discussion Best thing happen to StarCraft since Remastered?
Tourneys
[Megathread] Daily Proleagues [ASL21] Grand Finals The Casual Games of the Week Thread [BSL22] GosuLeague Casts - Tue & Thu 22:00 CEST
Strategy
Simple Questions, Simple Answers Creating a full chart of Zerg builds Relatively freeroll strategies Why doesn't anyone use restoration?
Other Games
General Games
ZeroSpace at Steam NextFest - Last free demo Nintendo Switch Thread Path of Exile Stormgate/Frost Giant Megathread Beyond All Reason
Dota 2
Looking for a Dota Mentor 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
TL Mafia
[94721]Better Good-Health Signs Than 3-15 Bans/Yea TL Mafia Community Thread Vanilla Mini Mafia
Community
General
US Politics Mega-thread Russo-Ukrainian War Thread Men's Fashion Thread Canadian Politics Mega-thread The Games Industry And ATVI
Fan Clubs
The HerO Fan Club! The herO Fan Club!
Media & Entertainment
Movie Discussion! Series you have seen recently... [Req][Books] Good Fantasy/SciFi books [TV/BOOK] *SPOILERS* Game of Thrones Discussion
Sports
2024 - 2026 Football Thread TeamLiquid Health and Fitness Initiative For 2023 Formula 1 Discussion McBoner: A hockey love story Cricket [SPORT]
World Cup 2022
Tech Support
How to clean a TTe Thermaltake keyboard? Computer Build, Upgrade & Buying Resource Thread
TL Community
The Automated Ban List
Blogs
Listen To The Coaches!
TrAiDoS
An Exploration of th…
waywardstrategy
I'm an arrogant trash talke…
FlaShFTW
Gauntlet SC2: A Retrospectiv…
Ctone23
ramps on octagon
StaticNine
Funny Nicknames
LUCKY_NOOB
Evil Gacha Games and the…
ffswowsucks
Customize Sidebar...

Website Feedback

Closed Threads



Active: 7203 users

Tracking your 1v1 games - Page 4

Forum Index > SC2 General
Post a Reply
Prev 1 2 3 4 5 Next All
Defclone
Profile Joined December 2010
Mexico125 Posts
March 30 2011 12:36 GMT
#61
Started to use this for Season 2! Thanks a lot!
soso.501
Profile Blog Joined September 2010
32 Posts
March 30 2011 13:25 GMT
#62
Looks awesome, makes up for some clear deficiencies in battle.net
Crushgroove
Profile Joined July 2010
United States793 Posts
March 30 2011 13:31 GMT
#63
On March 20 2011 09:18 ntvarify wrote:
Hearing this makes me want my computer back so bad so I can use this! Can't wait until Monday. Macs are good, but.... Anyways, sounds really useful. I especially like how you can figure out which maps you struggle on, thats something that can be hard to figure out.


You can open this in numbers or excel on mac....
[In Korea on Vaca] "Why would I go to the park and climb a mountain? There are video games on f*cking TV!" - Kazuke
Melchior
Profile Joined January 2011
United States112 Posts
March 30 2011 13:35 GMT
#64
Thanks, this is pretty sweet! Now I need to figure out how to use pivot tables so I can add my own race (Random player) and look at all my matchups...
Gingerninja
Profile Blog Joined July 2010
United Kingdom1339 Posts
March 30 2011 14:02 GMT
#65
On March 20 2011 09:46 woofwoof wrote:
I don't mean this in a rude way. But the amount of time you spent crunching numbers and making spreadsheets, would of been better spent playing the game.


I takes 10 minutes to do something like this in excel... I did it last season (not the maps tho. just match-ups) there's no number crunching at all.
戦いの中に答えはある
duartesito
Profile Joined March 2010
Dominican Republic32 Posts
March 30 2011 22:17 GMT
#66
On March 30 2011 20:11 ShoGuN_sc2 wrote:
Anyone tried using this in OpenOffice? I can't quite get it to work, some of the formulae don't work.

Doesn't work on MAC's Numbers either


I tried LibreOffice (an OpenOffice fork) and a lot of formulas and customization is lost.
Im just out buying soy souce
Thanator
Profile Joined March 2011
Germany4 Posts
March 30 2011 22:34 GMT
#67
On March 31 2011 07:17 duartesito wrote:
Show nested quote +
On March 30 2011 20:11 ShoGuN_sc2 wrote:
Anyone tried using this in OpenOffice? I can't quite get it to work, some of the formulae don't work.

Doesn't work on MAC's Numbers either


I tried LibreOffice (an OpenOffice fork) and a lot of formulas and customization is lost.

Same for me. :-(
Contra1
Profile Joined February 2011
Netherlands25 Posts
March 30 2011 23:00 GMT
#68
Great I like it

I'm going to start using this now for the new season!
EmptyM
Profile Joined September 2010
Canada4 Posts
March 30 2011 23:28 GMT
#69
You could add another column, which would be similar to notes, but something you can sort by: openings. Like I would want to see what my best pvp openings are (winning % wise). That would be pretty cool. and Great job on this ^_^
Volka
Profile Joined December 2010
Argentina412 Posts
March 30 2011 23:31 GMT
#70
I have to manually enter the data?
Sc2gears does it automatically!
http://www.starsite.com.ar
AirbladeOrange
Profile Blog Joined June 2010
United States2574 Posts
March 31 2011 00:56 GMT
#71
I'm going to try using this for the new season. Thanks for the template.
rezyn8
Profile Joined September 2010
Australia216 Posts
March 31 2011 02:32 GMT
#72
Thanks for the spreadsheet - this and sc2gears are a good little combination.
Silicon Sports Founder :: siliconsports.net :: @rezyn8
Toxin451
Profile Blog Joined August 2010
United States34 Posts
March 31 2011 22:44 GMT
#73
Hey everyone. Glad it is helping.

two notes:
* once again, this isn't an sc2gears replacement, i use them both to get the entire picture i want

and also
*with just a few adjustments here and there you can customize this baby anyway you want. Check youtube for tutorials on charts, pivot tables, filters etc.

good luck on the ladders.
"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
May 25 2011 20:14 GMT
#74
Added link to updated file in original post
sample data is included, simply replace with your own data.
don't delete formula in "Total Points" column.
"you don't need to panic, because that is bad for you" Dimaga on Mr Bitter's 12 weeks
Juice!
Profile Joined January 2011
Belgium295 Posts
May 25 2011 20:53 GMT
#75
Can you make this for excel '03 ?

Because when i open it i can hardly edit anything, because of the new version etc ..

and awesome job!
Second place is just a fancy term for loser
Toxin451
Profile Blog Joined August 2010
United States34 Posts
May 25 2011 22:20 GMT
#76
Saved as Excel 2003
available here
http://www.mediafire.com/?k1jy33zgd7apsob

not sure what problems there may be from the conversion. hope it's not too bad
"you don't need to panic, because that is bad for you" Dimaga on Mr Bitter's 12 weeks
FenneK
Profile Joined November 2010
France1231 Posts
May 25 2011 22:41 GMT
#77
Cool idea, keep at it.
good luck have batman
Juice!
Profile Joined January 2011
Belgium295 Posts
May 26 2011 13:09 GMT
#78
Hey, i PM'ed you the error i had and still have in the 2003 version :s
Second place is just a fancy term for loser
Toxin451
Profile Blog Joined August 2010
United States34 Posts
May 26 2011 18:01 GMT
#79
i'll see if i can get it to work in 2003, but it utilizes a lot of the new features that were not available in previous versions.
sry
"you don't need to panic, because that is bad for you" Dimaga on Mr Bitter's 12 weeks
Talic_Zealot
Profile Blog Joined February 2010
688 Posts
May 26 2011 18:35 GMT
#80
This is something I have wanted, but with a way to extract the data from the profile non-manually. I don't know if your opponents' races are provided, but I'm sure that if they are sc2 ranks will soon give us those simple calculations right there in the profile.
There are three types of people in the universe: those who can count, and those who cant.
Prev 1 2 3 4 5 Next All
Please log in or register to reply.
Live Events Refresh
Next event in 6h 21m
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
RushiSC 113
BRAT_OK 61
MindelVK 10
StarCraft: Brood War
Britney 18420
Hyuk 947
EffOrt 905
BeSt 250
ggaemo 248
Dewaltoss 108
Zeus 66
Rush 53
Pusan 48
[sc1f]eonzerg 35
[ Show more ]
Mong 31
sorry 28
Free 25
scan(afreeca) 22
Rock 17
Bale 16
zelot 15
Sacsri 12
Shine 11
Dota 2
qojqva1809
420jenkins241
LuMiX1
Counter-Strike
fl0m1653
x6flipin513
adren_tv83
edward72
kRYSTAL_7
Other Games
Grubby1901
FrodaN1147
B2W.Neo943
ceh9708
Dendi602
Beastyqt515
RotterdaM342
C9.Mang0207
KnowMe121
UpATreeSC58
Trikslyr44
Mew2King44
JuggernautJason23
Organizations
Dota 2
PGL Dota 2 - Main Stream208
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
[ Show 17 non-featured ]
StarCraft 2
• IndyKCrew
• sooper7s
• AfreecaTV YouTube
• Migwel
• intothetv
• LaughNgamezSOOP
• Kozan
StarCraft: Brood War
• 80smullet 16
• FirePhoenix4
• STPLYoutube
• ZZZeroYoutube
• BSLYoutube
League of Legends
• Nemesis3312
• TFBlade850
Other Games
• imaqtpie413
• Shiphtur362
• tFFMrPink 11
Upcoming Events
Replay Cast
6h 21m
CrankTV Team League
17h 21m
Bombastic Starleague
1d 2h
The PondCast
1d 16h
HomeStory Cup
1d 17h
Replay Cast
2 days
HomeStory Cup
2 days
Replay Cast
3 days
HomeStory Cup
3 days
OSC
3 days
[ Show More ]
Sparkling Tuna Cup
4 days
WardiTV Weekly
5 days
The PondCast
6 days
Liquipedia Results

Completed

YSL S3
Douyu Cup 2026
Murky Cup 2026

Ongoing

IPSL Spring 2026
Acropolis #4
CSL Season 21: Qualifier 2
SCTL 2026 Spring
XSE Pro League 2026
IEM Cologne Major 2026
Stake Ranked Episode 2
CS Asia Championships 2026
Asian Champions League 2026
IEM Atlanta 2026
PGL Astana 2026
BLAST Rivals Spring 2026
IEM Rio 2026

Upcoming

CSL 2026 Summer (S21)
ASL Season 22:Wild Card Qualifier
CSLAN 4
Blizzard Classic Cup 2026
Kung Fu Cup 2026 Grand Finals
RSL Revival: Season 6
CranK Gathers Season 4: BW vs SC2 Team League
HSC XXIX
Light Tournament 2026
Eternal Conflict S2 Finale
Heroes Pulsing #3
Eternal Conflict S2 E1
FISSURE Playground #5
BLAST Open Fall 2026
Esports World Cup 2026
BLAST Bounty Summer 2026
BLAST Bounty Summer Qual
Stake Ranked Episode 3
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.