• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EST 05:57
CET 11:57
KST 19:57
  • 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
LiuLi Cup: 2025 Grand Finals (Feb 10-16)13Weekly Cups (Feb 2-8): Classic, Solar, MaxPax win2Nexon's StarCraft game could be FPS, led by UMS maker9PIG STY FESTIVAL 7.0! (19 Feb - 1 Mar)12Weekly Cups (Jan 26-Feb 1): herO, Clem, ByuN, Classic win2
StarCraft 2
General
Nexon's StarCraft game could be FPS, led by UMS maker Terran Scanner Sweep How do you think the 5.0.15 balance patch (Oct 2025) for StarCraft II has affected the game? Behind the Blue - Team Liquid History Book Weekly Cups (Jan 12-18): herO, MaxPax, Solar win
Tourneys
LiuLi Cup: 2025 Grand Finals (Feb 10-16) RSL Revival: Season 4 Korea Qualifier (Feb 14) PIG STY FESTIVAL 7.0! (19 Feb - 1 Mar) Sparkling Tuna Cup - Weekly Open Tournament RSL Season 4 announced for March-April
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 Gypsy to Korea Liquipedia.net NEEDS editors for Brood War Recent recommended BW games [ASL21] Potential Map Candidates
Tourneys
Escore Tournament StarCraft Season 1 [Megathread] Daily Proleagues 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
Path of Exile Nintendo Switch Thread 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
Mafia Game Mode Feedback/Ideas Vanilla Mini Mafia TL Mafia Community Thread
Community
General
US Politics Mega-thread European Politico-economics QA Mega-thread Ask and answer stupid questions here! Russo-Ukrainian War Thread Sex and weight loss
Fan Clubs
The herO Fan Club! The IdrA Fan Club
Media & Entertainment
Anime Discussion Thread [Manga] One Piece
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
Customize Sidebar...

Website Feedback

Closed Threads



Active: 2634 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
Argentina411 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
Escore
10:00
Ro32
EscoreOfficial0
LiquipediaDiscussion
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
RotterdaM 213
Rex 47
ProTech17
TKL 15
BRAT_OK 0
StarCraft: Brood War
Bisu 4710
Rain 1984
PianO 1605
Jaedong 552
Hyuk 515
Stork 331
actioN 290
firebathero 265
Leta 207
Snow 164
[ Show more ]
Soulkey 164
Soma 140
Light 129
ZerO 119
Aegong 106
ggaemo 80
Rush 73
Killer 72
Mong 72
ToSsGirL 52
zelot 43
Sharp 39
Zeus 36
sSak 35
Nal_rA 26
Hm[arnc] 24
sorry 22
GoRush 21
JulyZerg 21
Noble 17
scan(afreeca) 16
soO 14
Terrorterran 13
Sacsri 9
ivOry 5
Dota 2
Fuzer 194
XcaliburYe85
League of Legends
JimRising 481
Counter-Strike
shoxiejesuss1279
zeus690
kRYSTAL_70
Super Smash Bros
Mew2King83
Heroes of the Storm
Khaldor157
Other Games
gofns12829
singsing1523
ceh9604
crisheroes267
B2W.Neo173
ZerO(Twitch)8
Organizations
StarCraft 2
IntoTheiNu 1
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 16 non-featured ]
StarCraft 2
• Berry_CruncH134
• StrangeGG 63
• LUISG 29
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• escodisco358
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
League of Legends
• Jankos1544
• Stunt637
Upcoming Events
LiuLi Cup
3m
Serral vs Zoun
Cure vs Classic
RotterdaM213
Rex47
Big Brain Bouts
6h 3m
ByuN vs GgMaChine
Serral vs Jumy
RSL Revival
16h 3m
RSL Revival
21h 3m
LiuLi Cup
1d
uThermal 2v2 Circuit
1d 1h
RSL Revival
1d 7h
Replay Cast
1d 13h
Sparkling Tuna Cup
1d 23h
LiuLi Cup
2 days
[ Show More ]
Replay Cast
2 days
Replay Cast
2 days
LiuLi Cup
3 days
Wardi Open
3 days
Monday Night Weeklies
3 days
OSC
3 days
WardiTV Winter Champion…
4 days
Replay Cast
4 days
WardiTV Winter Champion…
5 days
Replay Cast
5 days
The PondCast
5 days
KCM Race Survival
5 days
WardiTV Winter Champion…
6 days
Replay Cast
6 days
Liquipedia Results

Completed

Proleague 2026-02-10
Rongyi Cup S3
Underdog Cup #3

Ongoing

KCM Race Survival 2026 Season 1
Escore Tournament S1: W8
LiuLi Cup: 2025 Grand Finals
Nations Cup 2026
IEM Kraków 2026
BLAST Bounty Winter 2026
BLAST Bounty Winter Qual
eXTREMESLAND 2025
SL Budapest Major 2025

Upcoming

[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
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
PGL Cluj-Napoca 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.