• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EST 07:55
CET 13:55
KST 21:55
  • 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
TL.net Map Contest #21: Winners11Intel X Team Liquid Seoul event: Showmatches and Meet the Pros10[ASL20] Finals Preview: Arrival13TL.net Map Contest #21: Voting12[ASL20] Ro4 Preview: Descent11
Community News
[TLMC] Fall/Winter 2025 Ladder Map Rotation4Weekly Cups (Nov 3-9): Clem Conquers in Canada4SC: Evo Complete - Ranked Ladder OPEN ALPHA8StarCraft, SC2, HotS, WC3, Returning to Blizzcon!45$5,000+ WardiTV 2025 Championship7
StarCraft 2
General
[TLMC] Fall/Winter 2025 Ladder Map Rotation Mech is the composition that needs teleportation t Weekly Cups (Nov 3-9): Clem Conquers in Canada Craziest Micro Moments Of All Time? SC: Evo Complete - Ranked Ladder OPEN ALPHA
Tourneys
Constellation Cup - Main Event - Stellar Fest Tenacious Turtle Tussle Sparkling Tuna Cup - Weekly Open Tournament $5,000+ WardiTV 2025 Championship Merivale 8 Open - LAN - Stellar Fest
Strategy
Custom Maps
Map Editor closed ?
External Content
Mutation # 499 Chilling Adaptation Mutation # 498 Wheel of Misfortune|Cradle of Death Mutation # 497 Battle Haredened Mutation # 496 Endless Infection
Brood War
General
BW General Discussion FlaSh on: Biggest Problem With SnOw's Playstyle Terran 1:35 12 Gas Optimization BGH Auto Balance -> http://bghmmr.eu/ [ASL20] Ask the mapmakers — Drop your questions
Tourneys
[BSL21] RO32 Group D - Sunday 21:00 CET [BSL21] RO32 Group C - Saturday 21:00 CET [ASL20] Grand Finals [Megathread] Daily Proleagues
Strategy
Current Meta PvZ map balance How to stay on top of macro? Soma's 9 hatch build from ASL Game 2
Other Games
General Games
Nintendo Switch Thread Stormgate/Frost Giant Megathread Should offensive tower rushing be viable in RTS games? Path of Exile Dawn of War IV
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 SPIRED by.ASL Mafia {211640}
Community
General
US Politics Mega-thread Russo-Ukrainian War Thread Things Aren’t Peaceful in Palestine Canadian Politics Mega-thread The Games Industry And ATVI
Fan Clubs
White-Ra Fan Club The herO Fan Club!
Media & Entertainment
[Manga] One Piece Anime Discussion Thread Movie Discussion! Korean Music Discussion Series you have seen recently...
Sports
2024 - 2026 Football Thread Formula 1 Discussion NBA General Discussion MLB/Baseball 2023 TeamLiquid Health and Fitness Initiative For 2023
World Cup 2022
Tech Support
SC2 Client Relocalization [Change SC2 Language] Linksys AE2500 USB WIFI keeps disconnecting Computer Build, Upgrade & Buying Resource Thread
TL Community
The Automated Ban List
Blogs
Dyadica Gospel – a Pulp No…
Hildegard
Coffee x Performance in Espo…
TrAiDoS
Saturation point
Uldridge
DnB/metal remix FFO Mick Go…
ImbaTosS
Reality "theory" prov…
perfectspheres
Customize Sidebar...

Website Feedback

Closed Threads



Active: 1162 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
Argentina410 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 States2573 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
Kung Fu Cup
12:00
2025 Monthly #3: Day 1
Classic vs SolarLIVE!
herO vs Cure
Reynor vs GuMiho
ByuN vs ShoWTimE
RotterdaM366
TKL 163
Rex108
IntoTheiNu 87
SteadfastSC64
Liquipedia
OSC
11:30
Mid Season Playoffs
Spirit vs HarstemLIVE!
Cure vs TBD
Krystianer vs Percival
WardiTV401
Liquipedia
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
RotterdaM 366
TKL 163
Rex 108
Reynor 94
SteadfastSC 64
StarCraft: Brood War
Calm 5369
Rain 3233
Hyuk 2365
Bisu 1983
Horang2 1735
Backho 923
Flash 653
Soma 386
Stork 333
Last 255
[ Show more ]
Rush 215
Pusan 199
Soulkey 115
ZerO 111
hero 58
JulyZerg 43
sSak 42
Barracks 41
Aegong 37
zelot 32
Icarus 26
Killer 23
Noble 11
Hm[arnc] 8
Terrorterran 3
Dota 2
Dendi958
qojqva953
XcaliburYe192
Counter-Strike
olofmeister942
x6flipin604
allub195
Super Smash Bros
Mew2King136
Other Games
B2W.Neo904
crisheroes281
Pyrionflax247
DeMusliM172
Sick115
Fuzer 81
QueenE36
ZerO(Twitch)11
Organizations
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 14 non-featured ]
StarCraft 2
• Adnapsc2 11
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• iopq 1
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
Dota 2
• C_a_k_e 709
• WagamamaTV343
Upcoming Events
Tenacious Turtle Tussle
10h 6m
The PondCast
21h 6m
RSL Revival
21h 6m
Solar vs Zoun
MaxPax vs Bunny
Kung Fu Cup
23h 6m
WardiTV Korean Royale
23h 6m
PiGosaur Monday
1d 12h
RSL Revival
1d 21h
Classic vs Creator
Cure vs TriGGeR
Kung Fu Cup
1d 23h
CranKy Ducklings
2 days
RSL Revival
2 days
herO vs Gerald
ByuN vs SHIN
[ Show More ]
Kung Fu Cup
2 days
IPSL
3 days
ZZZero vs rasowy
Napoleon vs KameZerg
BSL 21
3 days
Tarson vs Julia
Doodle vs OldBoy
eOnzErG vs WolFix
StRyKeR vs Aeternum
Sparkling Tuna Cup
3 days
RSL Revival
3 days
Reynor vs sOs
Maru vs Ryung
Kung Fu Cup
3 days
WardiTV Korean Royale
3 days
BSL 21
4 days
JDConan vs Semih
Dragon vs Dienmax
Tech vs NewOcean
TerrOr vs Artosis
IPSL
4 days
Dewalt vs WolFix
eOnzErG vs Bonyth
Wardi Open
4 days
Monday Night Weeklies
5 days
WardiTV Korean Royale
5 days
The PondCast
6 days
Liquipedia Results

Completed

Proleague 2025-11-07
Stellar Fest: Constellation Cup
Eternal Conflict S1

Ongoing

C-Race Season 1
IPSL Winter 2025-26
KCM Race Survival 2025 Season 4
SOOP Univ League 2025
YSL S2
BSL Season 21
BLAST Rivals Fall 2025
IEM Chengdu 2025
PGL Masters Bucharest 2025
Thunderpick World Champ.
CS Asia Championships 2025
ESL Pro League S22
StarSeries Fall 2025
FISSURE Playground #2
BLAST Open Fall 2025
BLAST Open Fall Qual

Upcoming

SLON Tour Season 2
BSL 21 Non-Korean Championship
Acropolis #4
IPSL Spring 2026
HSC XXVIII
RSL Offline Finals
WardiTV 2025
RSL Revival: Season 3
META Madness #9
BLAST Bounty Winter 2026
BLAST Bounty Winter 2026: Closed Qualifier
eXTREMESLAND 2025
ESL Impact League Season 8
SL Budapest Major 2025
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.