• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 03:26
CEST 09:26
KST 16:26
  • 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
Power Rank - Esports World Cup 202562RSL Season 1 - Final Week9[ASL19] Finals Recap: Standing Tall15HomeStory Cup 27 - Info & Preview18Classic wins Code S Season 2 (2025)16
Community News
BSL Team Wars - Bonyth, Dewalt, Hawk & Sziky teams10Weekly Cups (July 14-20): Final Check-up0Esports World Cup 2025 - Brackets Revealed19Weekly Cups (July 7-13): Classic continues to roll8Team TLMC #5 - Submission re-extension5
StarCraft 2
General
#1: Maru - Greatest Players of All Time Power Rank - Esports World Cup 2025 The GOAT ranking of GOAT rankings Server Blocker Team TLMC #5 - Submission re-extension
Tourneys
Esports World Cup 2025 FEL Cracov 2025 (July 27) - $8000 live event Sparkling Tuna Cup - Weekly Open Tournament Master Swan Open (Global Bronze-Master 2) Sea Duckling Open (Global, Bronze-Diamond)
Strategy
How did i lose this ZvP, whats the proper response
Custom Maps
External Content
Mutation #239 Bad Weather Mutation # 483 Kill Bot Wars Mutation # 482 Wheel of Misfortune Mutation # 481 Fear and Lava
Brood War
General
Simple editing of Brood War save files? (.mlx) BGH Auto Balance -> http://bghmmr.eu/ Ginuda's JaeDong Interview Series [Update] ShieldBattery: 2025 Redesign BW General Discussion
Tourneys
[Megathread] Daily Proleagues [BSL20] Non-Korean Championship 4x BSL + 4x China CSL Xiamen International Invitational [CSLPRO] It's CSLAN Season! - Last Chance
Strategy
[G] Mineral Boosting Does 1 second matter in StarCraft? Simple Questions, Simple Answers
Other Games
General Games
Stormgate/Frost Giant Megathread Total Annihilation Server - TAForever Nintendo Switch Thread [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
Things Aren’t Peaceful in Palestine Stop Killing Games - European Citizens Initiative Russo-Ukrainian War Thread US Politics Mega-thread Post Pic of your Favorite Food!
Fan Clubs
INnoVation Fan Club SKT1 Classic Fan Club!
Media & Entertainment
[\m/] Heavy Metal Thread Anime Discussion Thread Movie Discussion! [Manga] One Piece Korean Music Discussion
Sports
Formula 1 Discussion 2024 - 2025 Football Thread TeamLiquid Health and Fitness Initiative For 2023 NBA General Discussion
World Cup 2022
Tech Support
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: 680 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
Argentina408 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 2h 34m
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
WinterStarcraft744
Nina 206
StarCraft: Brood War
Sea 3913
firebathero 352
Larva 279
ToSsGirL 172
Zeus 83
Dewaltoss 79
Free 50
Mind 12
ivOry 4
Dota 2
XcaliburYe300
League of Legends
JimRising 658
Heroes of the Storm
Khaldor149
Other Games
summit1g5035
Fuzer 229
Organizations
Other Games
gamesdonequick930
BasetradeTV45
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 15 non-featured ]
StarCraft 2
• Berry_CruncH237
• LUISG 14
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
Dota 2
• lizZardDota2151
League of Legends
• Lourlo1031
Other Games
• Scarra1439
Upcoming Events
CranKy Ducklings
2h 34m
BSL20 Non-Korean Champi…
6h 34m
CSO Cup
8h 34m
BSL20 Non-Korean Champi…
10h 34m
Bonyth vs Sziky
Dewalt vs Hawk
Hawk vs QiaoGege
Sziky vs Dewalt
Mihu vs Bonyth
Zhanhun vs QiaoGege
QiaoGege vs Fengzi
FEL
1d 1h
BSL20 Non-Korean Champi…
1d 6h
BSL20 Non-Korean Champi…
1d 10h
Bonyth vs Zhanhun
Dewalt vs Mihu
Hawk vs Sziky
Sziky vs QiaoGege
Mihu vs Hawk
Zhanhun vs Dewalt
Fengzi vs Bonyth
Sparkling Tuna Cup
3 days
Online Event
3 days
uThermal 2v2 Circuit
4 days
[ Show More ]
The PondCast
5 days
Replay Cast
5 days
Korean StarCraft League
6 days
Liquipedia Results

Completed

CSL Xiamen Invitational
Esports World Cup 2025
Murky Cup #2

Ongoing

Copa Latinoamericana 4
Jiahua Invitational
BSL20 Non-Korean Championship
BSL Team Wars
CSLPRO Last Chance 2025
CC Div. A S7
Underdog Cup #2
IEM Cologne 2025
FISSURE Playground #1
BLAST.tv Austin Major 2025
ESL Impact League Season 7
IEM Dallas 2025
PGL Astana 2025
Asian Champions League '25

Upcoming

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
uThermal 2v2 Main Event
FEL Cracov 2025
HCC Europe
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.