• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 11:06
CEST 17:06
KST 00:06
  • 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
[ASL21] Ro4 Preview: On Course12Code S Season 1 - RO8 Preview7[ASL21] Ro8 Preview Pt2: Progenitors8Code S Season 1 - RO12 Group A: Rogue, Percival, Solar, Zoun13[ASL21] Ro8 Preview Pt1: Inheritors16
Community News
Weekly Cups (May 4-10): Clem, MaxPax, herO win1Maestros of The Game 2 announcement and schedule !10Weekly Cups (April 27-May 4): Clem takes triple0RSL Revival: Season 5 - Qualifiers and Main Event12Code S Season 1 (2026) - RO12 Results1
StarCraft 2
General
MaNa leaves Team Liquid Weekly Cups (May 4-10): Clem, MaxPax, herO win Code S Season 1 - RO8 Preview Behind the Blue - Team Liquid History Book Weekly Cups (April 27-May 4): Clem takes triple
Tourneys
2026 GSL Season 2 Qualifiers $5,000 WardiTV Spring Championship 2026 Maestros of The Game 2 announcement and schedule ! SC2 INu's Battles#16 <BO.9> Master Swan Open (Global Bronze-Master 2)
Strategy
Custom Maps
[D]RTS in all its shapes and glory <3 [A] Nemrods 1/4 players
External Content
Mutation # 525 Wheel of Misfortune The PondCast: SC2 News & Results Mutation # 524 Death and Taxes Mutation # 523 Firewall
Brood War
General
ASL Tickets to Live Event Finals? Flashes ASL S21 Ro8 Review BW General Discussion Pros React To: Leta vs Tulbo (ASL S21, Ro.8) (Spoiler) Interview ASL Ro4 Day 2 Winner
Tourneys
[ASL21] Semifinals B [ASL21] Semifinals A [Megathread] Daily Proleagues [BSL22] RO16 Group Stage - 02 - 10 May
Strategy
Fighting Spirit mining rates [G] Hydra ZvZ: An Introduction Simple Questions, Simple Answers Muta micro map competition
Other Games
General Games
Warcraft III: The Frozen Throne Nintendo Switch Thread Stormgate/Frost Giant Megathread Starcraft Tabletop Miniature Game PC Games Sales Thread
Dota 2
The Story of Wings Gaming
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
Vanilla Mini Mafia Mafia Game Mode Feedback/Ideas TL Mafia Community Thread Five o'clock TL Mafia
Community
General
US Politics Mega-thread Russo-Ukrainian War Thread UK Politics Mega-thread YouTube Thread European Politico-economics QA Mega-thread
Fan Clubs
The IdrA Fan Club
Media & Entertainment
[Manga] One Piece Anime Discussion Thread [Req][Books] Good Fantasy/SciFi books
Sports
2024 - 2026 Football Thread McBoner: A hockey love story Formula 1 Discussion
World Cup 2022
Tech Support
streaming software Strange computer issues (software) [G] How to Block Livestream Ads
TL Community
The Automated Ban List
Blogs
How EEG Data Can Predict Gam…
TrAiDoS
ramps on octagon
StaticNine
Funny Nicknames
LUCKY_NOOB
Customize Sidebar...

Website Feedback

Closed Threads



Active: 1715 users

1v1 Stats Spreadsheet - Page 10

Forum Index > SC2 General
Post a Reply
Prev 1 8 9 10 11 Next All
Roxor9999
Profile Joined December 2011
Netherlands771 Posts
June 18 2012 18:05 GMT
#181
On June 18 2012 10:39 SynergySC2 wrote:
Show nested quote +
On June 18 2012 10:35 WarpMePlz wrote:
On June 18 2012 10:34 SynergySC2 wrote:
so whats the program to open this file with? cuz i dont got it

Microsoft Excel 2007 or newer


could u give me the download link because i think i got the wrong 1

http://office.microsoft.com/en-us/try/try-office-2010-FX101868838.aspx?WT.mc_id=mscom_enus_bnr_tryq4,MSCOM_EN_US_HP_FEATURE_124GMUS017361
[Silverflame]
Profile Joined March 2009
Germany640 Posts
June 18 2012 18:09 GMT
#182
This has to get more attention because I would love to see data like this implemented in Bnet. That would be a dream come true^^ So now I gonna download the new spreadsheet version Thx for your great work man!
Fav P Stork / Fav T Fantasy / Fav Z Hoejja
sertman
Profile Blog Joined February 2011
United States540 Posts
June 18 2012 19:32 GMT
#183
will it mess everything up if i add a column for game notes? like "got supply blocked, didnt inject during battle" etc
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
Last Edited: 2012-06-18 19:57:23
June 18 2012 19:56 GMT
#184
On June 19 2012 04:32 sertman wrote:
will it mess everything up if i add a column for game notes? like "got supply blocked, didnt inject during battle" etc

The "bottom" button won't work - To get it to work: 1. make sure first of all macros are enabled. 2. right click the "bottom" button and click "assign macro" then "edit" and change "N3" to "O3". This will fix it.

Apart from this everything else should automatically correct itself.
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
June 18 2012 20:02 GMT
#185
On June 19 2012 03:05 Roxor9999 wrote:
Show nested quote +
On June 18 2012 10:39 SynergySC2 wrote:
On June 18 2012 10:35 WarpMePlz wrote:
On June 18 2012 10:34 SynergySC2 wrote:
so whats the program to open this file with? cuz i dont got it

Microsoft Excel 2007 or newer


could u give me the download link because i think i got the wrong 1

http://office.microsoft.com/en-us/try/try-office-2010-FX101868838.aspx?WT.mc_id=mscom_enus_bnr_tryq4,MSCOM_EN_US_HP_FEATURE_124GMUS017361

Thanks for this - I will link this in the main post
sertman
Profile Blog Joined February 2011
United States540 Posts
June 18 2012 20:16 GMT
#186
On June 19 2012 04:56 WarpMePlz wrote:
Show nested quote +
On June 19 2012 04:32 sertman wrote:
will it mess everything up if i add a column for game notes? like "got supply blocked, didnt inject during battle" etc

The "bottom" button won't work - To get it to work: 1. make sure first of all macros are enabled. 2. right click the "bottom" button and click "assign macro" then "edit" and change "N3" to "O3". This will fix it.

Apart from this everything else should automatically correct itself.


After some experimenting i found if I add the column from VR (so the new column is VQ) it breaks nothing. Thanks for the timely response, i appreciate the work you've put into this :D
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
June 18 2012 20:36 GMT
#187
Thanks for all the support guys, it means a lot! I did put a lot of effort in to this update but the great reaction makes it worth it <3

On June 19 2012 02:43 Muckles wrote:
Okay I realy like the new organisation line on the top and the new features, but it is a bit much to fill in now.
I would say that it is now better then before and you should continue to make it like that (for every season i mean), because for the higher player it is realy helpful and if you don't want to fill so many cells after each game you can also leave them blanc.

I will not use this for now because i don't know if you are going to leave this desing in the spreadsheet but if you will continue with this new features I will use it for sure.

Very good work. :D

Thanks man! The spreadsheet will be staying in this new format - I am only putting it through a bit of testing to try and find any errors in the calculations and get some feedback on the new graphs. The new data inputs will stay for sure so you can go ahead and use it.
I have put extra time into making it so that it does not include your old data in the new "game length" and "SQ" stats and graphs. i.e. This just means your averages don't get messed up!
Muckles
Profile Joined April 2012
Austria17 Posts
June 20 2012 15:01 GMT
#188
Short question:
It seems like my graphs don't recongnice the month I entered.
It worked fine till the beginning of june where I entered XX.Jun in the date column.
So what am I supposed to fill in ^^.
People say the best weapon is the weapon you never need to use, I say the best weapon is the weapon you only use once!
CcCFlu
Profile Joined February 2011
Switzerland68 Posts
June 20 2012 16:28 GMT
#189
for some reason it only shows the games that i played before i changed my name
can i somehow adjust that?
apart from that it looks fuckin amazing
well done
For the fucking sworm!!!
Muckles
Profile Joined April 2012
Austria17 Posts
June 20 2012 20:20 GMT
#190
Try to search your name here:

http://sc2ranks.com/
People say the best weapon is the weapon you never need to use, I say the best weapon is the weapon you only use once!
CcCFlu
Profile Joined February 2011
Switzerland68 Posts
June 20 2012 23:00 GMT
#191
yes i can find my new name on sc2ranks
and then what?
For the fucking sworm!!!
Muckles
Profile Joined April 2012
Austria17 Posts
June 21 2012 14:29 GMT
#192
Oh sorry, I ment to say your old name of course.
People say the best weapon is the weapon you never need to use, I say the best weapon is the weapon you only use once!
CcCFlu
Profile Joined February 2011
Switzerland68 Posts
June 21 2012 15:32 GMT
#193
no i can't find my old name on sc2ranks
For the fucking sworm!!!
YouMake
Profile Blog Joined February 2010
United States262 Posts
June 21 2012 15:43 GMT
#194
or you could just go to StatCraft.net and use his website that is always updated and is better than this thing.
It's time to kick ass and chew bubble gum, but all out of bubble gum! - Duke Nukem!
kuehlschrank
Profile Joined February 2012
Germany33 Posts
June 26 2012 10:48 GMT
#195
I tried out v13 and got some issues with "today´s stats" as they don`t work although I entered the date for all games.

[image loading]
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
June 28 2012 23:36 GMT
#196
On June 26 2012 19:48 kuehlschrank wrote:
I tried out v13 and got some issues with "today´s stats" as they don`t work although I entered the date for all games.

[image loading]

The format of the date is wrong. Notice it appears "21.jun" rather than "21-jun". enter the date simply "21 jun" and it will enter it as a date rather than a word it cannot calculate. - To confirm this select the cell, and in the formula bar should be the date in the format 21/06/2012
Scurvy
Profile Joined March 2012
United States117 Posts
July 01 2012 01:40 GMT
#197
This is so useful! I had something like this for myself, but it was nowhere near as pretty as this one:D
With it or on it.
Muckles
Profile Joined April 2012
Austria17 Posts
Last Edited: 2012-07-11 23:28:51
July 11 2012 23:02 GMT
#198
Can you add the average SQ somewhere? Edit: Maybe with an overview to se what you should have in your league.


Also you mixed up the possition of the Game Length vs Race and the Spending Quotient vs Race graph (it is not a big thing but maybe you want to change it in the next version).

People say the best weapon is the weapon you never need to use, I say the best weapon is the weapon you only use once!
pvtmomo
Profile Joined February 2012
Germany80 Posts
July 13 2012 20:12 GMT
#199
Hey how i can insert my stats i dont understand it ?
Scepty
Profile Joined August 2011
22 Posts
July 15 2012 11:14 GMT
#200
Same question how can i analyse my stats... This only looks like some kind of an example WTF
I reject your reality and substitute my own
Prev 1 8 9 10 11 Next All
Please log in or register to reply.
Live Events Refresh
Kung Fu Cup
11:00
#7
IntoTheiNu 1216
WardiTV790
RotterdaM595
TKL 255
SteadfastSC135
Liquipedia
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
RotterdaM 595
TKL 255
Rex 143
SteadfastSC 135
sc2solar 68
herO (SOOP) 45
StarCraft: Brood War
Britney 73976
Calm 7770
Bisu 2468
Sea 1905
Horang2 1076
EffOrt 1040
firebathero 611
Mini 537
Soma 376
Larva 277
[ Show more ]
ZerO 202
Hyuk 195
hero 154
Rush 124
Zeus 116
ggaemo 89
Aegong 88
Mind 64
Sexy 64
Sharp 60
Pusan 60
ToSsGirL 51
sorry 43
Bale 25
Rock 20
soO 15
Terrorterran 15
ajuk12(nOOB) 9
IntoTheRainbow 9
Dota 2
Gorgc7181
qojqva1650
syndereN243
monkeys_forever143
Counter-Strike
olofmeister2611
byalli632
Other Games
singsing1896
B2W.Neo917
Beastyqt870
hiko702
Liquid`RaSZi408
Lowko340
Hui .250
KnowMe127
QueenE103
Mew2King92
elazer67
CosmosSc2 55
ArmadaUGS36
Livibee31
Trikslyr27
ZerO(Twitch)21
Organizations
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
[ Show 14 non-featured ]
StarCraft 2
• poizon28 13
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• HerbMon 23
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
League of Legends
• Nemesis6347
Other Games
• WagamamaTV308
Upcoming Events
Replay Cast
8h 54m
The PondCast
18h 54m
OSC
18h 54m
Replay Cast
1d 8h
RSL Revival
1d 18h
OSC
1d 21h
Korean StarCraft League
2 days
RSL Revival
2 days
BSL
3 days
GSL
3 days
Cure vs herO
SHIN vs Maru
[ Show More ]
BSL
4 days
Replay Cast
4 days
Monday Night Weeklies
5 days
Replay Cast
5 days
The PondCast
5 days
GSL
6 days
Liquipedia Results

Completed

Proleague 2026-05-12
WardiTV TLMC #16
Nations Cup 2026

Ongoing

BSL Season 22
ASL Season 21
IPSL Spring 2026
KCM Race Survival 2026 Season 2
Acropolis #4
KK 2v2 League Season 1
BSL 22 Non-Korean Championship
SCTL 2026 Spring
RSL Revival: Season 5
2026 GSL S1
Asian Champions League 2026
IEM Atlanta 2026
PGL Astana 2026
BLAST Rivals Spring 2026
IEM Rio 2026
PGL Bucharest 2026
Stake Ranked Episode 1
BLAST Open Spring 2026
ESL Pro League S23 Finals
ESL Pro League S23 Stage 1&2

Upcoming

Escore Tournament S2: W7
YSL S3
Escore Tournament S2: W8
CSLAN 4
Kung Fu Cup 2026 Grand Finals
HSC XXIX
uThermal 2v2 2026 Main Event
Maestros of the Game 2
WardiTV Spring 2026
2026 GSL S2
BLAST Bounty Summer 2026: Closed Qualifier
Stake Ranked Episode 3
XSE Pro League 2026
IEM Cologne Major 2026
Stake Ranked Episode 2
CS Asia Championships 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.