• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 14:04
CEST 20:04
KST 03: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
Team TLMC #5 - Finalists & Open Tournaments0[ASL20] Ro16 Preview Pt2: Turbulence7Classic Games #3: Rogue vs Serral at BlizzCon9[ASL20] Ro16 Preview Pt1: Ascent10Maestros of the Game: Week 1/Play-in Preview12
Community News
Weekly Cups (Sept 8-14): herO & MaxPax split cups4WardiTV TL Team Map Contest #5 Tournaments1SC4ALL $6,000 Open LAN in Philadelphia8Weekly Cups (Sept 1-7): MaxPax rebounds & Clem saga continues29LiuLi Cup - September 2025 Tournaments3
StarCraft 2
General
Weekly Cups (Sept 8-14): herO & MaxPax split cups #1: Maru - Greatest Players of All Time Team Liquid Map Contest #21 - Presented by Monster Energy SpeCial on The Tasteless Podcast Team TLMC #5 - Finalists & Open Tournaments
Tourneys
SC4ALL $6,000 Open LAN in Philadelphia Sparkling Tuna Cup - Weekly Open Tournament WardiTV TL Team Map Contest #5 Tournaments Maestros of The Game—$20k event w/ live finals in Paris RSL: Revival, a new crowdfunded tournament series
Strategy
Custom Maps
External Content
Mutation # 491 Night Drive Mutation # 490 Masters of Midnight Mutation # 489 Bannable Offense Mutation # 488 What Goes Around
Brood War
General
[ASL20] Ro16 Preview Pt2: Turbulence Diplomacy, Cosmonarchy Edition BGH Auto Balance -> http://bghmmr.eu/ BW General Discussion ASL20 General Discussion
Tourneys
[ASL20] Ro16 Group D [ASL20] Ro16 Group C [Megathread] Daily Proleagues SC4ALL $1,500 Open Bracket LAN
Strategy
Simple Questions, Simple Answers Muta micro map competition Fighting Spirit mining rates [G] Mineral Boosting
Other Games
General Games
Stormgate/Frost Giant Megathread Path of Exile General RTS Discussion Thread Nintendo Switch Thread Borderlands 3
Dota 2
Official 'what is Dota anymore' discussion LiquidDota to reintegrate into TL.net
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
Community
General
US Politics Mega-thread Things Aren’t Peaceful in Palestine Canadian Politics Mega-thread Russo-Ukrainian War Thread The Big Programming Thread
Fan Clubs
The Happy Fan Club!
Media & Entertainment
Movie Discussion! [Manga] One Piece Anime Discussion Thread
Sports
2024 - 2026 Football Thread Formula 1 Discussion MLB/Baseball 2023
World Cup 2022
Tech Support
Linksys AE2500 USB WIFI keeps disconnecting Computer Build, Upgrade & Buying Resource Thread High temperatures on bridge(s)
TL Community
BarCraft in Tokyo Japan for ASL Season5 Final The Automated Ban List
Blogs
The Personality of a Spender…
TrAiDoS
A very expensive lesson on ma…
Garnet
hello world
radishsoup
Lemme tell you a thing o…
JoinTheRain
RTS Design in Hypercoven
a11
Evil Gacha Games and the…
ffswowsucks
Customize Sidebar...

Website Feedback

Closed Threads



Active: 1378 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
Next event in 4h 56m
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
mouzHeroMarine 648
UpATreeSC 90
ProTech87
JuggernautJason29
StarCraft: Brood War
Calm 4456
Bisu 1927
Shuttle 605
EffOrt 554
Mini 496
PianO 463
BeSt 308
Soulkey 146
Dewaltoss 118
Backho 91
[ Show more ]
hero 87
Rush 58
soO 41
Aegong 23
sorry 19
Noble 11
Terrorterran 6
Hm[arnc] 5
SilentControl 5
Dota 2
qojqva4018
Fuzer 288
capcasts74
Counter-Strike
fl0m720
Stewie2K238
oskar94
Other Games
ceh9628
FrodaN621
Beastyqt498
Hui .296
Grubby114
QueenE91
Trikslyr62
FunKaTv 53
NeuroSwarm48
MindelVK29
fpsfer 2
Organizations
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 18 non-featured ]
StarCraft 2
• Reevou 1
• Kozan
• sooper7s
• AfreecaTV YouTube
• Migwel
• LaughNgamezSOOP
• intothetv
• IndyKCrew
StarCraft: Brood War
• FirePhoenix12
• STPLYoutube
• ZZZeroYoutube
• BSLYoutube
Dota 2
• C_a_k_e 4428
• WagamamaTV646
League of Legends
• Nemesis3779
• TFBlade714
Other Games
• imaqtpie675
• Shiphtur216
Upcoming Events
OSC
4h 56m
PiGosaur Monday
5h 56m
LiuLi Cup
16h 56m
OSC
1d
RSL Revival
1d 15h
Maru vs Reynor
Cure vs TriGGeR
The PondCast
1d 18h
RSL Revival
2 days
Zoun vs Classic
Korean StarCraft League
3 days
BSL Open LAN 2025 - War…
3 days
RSL Revival
3 days
[ Show More ]
BSL Open LAN 2025 - War…
4 days
RSL Revival
4 days
Online Event
4 days
Wardi Open
5 days
Sparkling Tuna Cup
6 days
Liquipedia Results

Completed

Proleague 2025-09-10
Chzzk MurlocKing SC1 vs SC2 Cup #2
HCC Europe

Ongoing

BSL 20 Team Wars
KCM Race Survival 2025 Season 3
BSL 21 Points
ASL Season 20
CSL 2025 AUTUMN (S18)
LASL Season 20
RSL Revival: Season 2
Maestros of the Game
FISSURE Playground #2
BLAST Open Fall 2025
BLAST Open Fall Qual
Esports World Cup 2025
BLAST Bounty Fall 2025
BLAST Bounty Fall Qual
IEM Cologne 2025
FISSURE Playground #1

Upcoming

2025 Chongqing Offline CUP
BSL World Championship of Poland 2025
IPSL Winter 2025-26
BSL Season 21
SC4ALL: Brood War
BSL 21 Team A
Stellar Fest
SC4ALL: StarCraft II
EC S1
ESL Impact League Season 8
SL Budapest Major 2025
BLAST Rivals Fall 2025
IEM Chengdu 2025
PGL Masters Bucharest 2025
MESA Nomadic Masters Fall
Thunderpick World Champ.
CS Asia Championships 2025
ESL Pro League S22
StarSeries Fall 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.