• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 09:30
CEST 15:30
KST 22:30
  • 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
[ASL20] Ro24 Preview Pt2: Take-Off7[ASL20] Ro24 Preview Pt1: Runway132v2 & SC: Evo Complete: Weekend Double Feature4Team Liquid Map Contest #21 - Presented by Monster Energy9uThermal's 2v2 Tour: $15,000 Main Event18
Community News
Weekly Cups (Aug 18-24): herO dethrones MaxPax6Maestros of The Game—$20k event w/ live finals in Paris34Weekly Cups (Aug 11-17): MaxPax triples again!13Weekly Cups (Aug 4-10): MaxPax wins a triple6SC2's Safe House 2 - October 18 & 195
StarCraft 2
General
Greatest Players of All Time: 2025 Update A Eulogy for the Six Pool BoxeR's Wings Episode 2 - Fan Translation #1: Maru - Greatest Players of All Time Geoff 'iNcontroL' Robinson has passed away
Tourneys
LiuLi Cup - August 2025 Tournaments $5,000 WardiTV Summer Championship 2025 Maestros of The Game—$20k event w/ live finals in Paris $5,100+ SEL Season 2 Championship (SC: Evo) Esports World Cup 2025
Strategy
Custom Maps
External Content
Mutation # 488 What Goes Around Mutation # 487 Think Fast Mutation # 486 Watch the Skies Mutation # 485 Death from Below
Brood War
General
Post ASL20 Ro24 discussion. BW General Discussion No Rain in ASL20? BGH Auto Balance -> http://bghmmr.eu/ Recent recommended BW games
Tourneys
[ASL20] Ro24 Group F [ASL20] Ro24 Group E [IPSL] CSLAN Review and CSLPRO Reimagined! [ASL20] Ro24 Group D
Strategy
Muta micro map competition Simple Questions, Simple Answers Fighting Spirit mining rates [G] Mineral Boosting
Other Games
General Games
Stormgate/Frost Giant Megathread Nintendo Switch Thread General RTS Discussion Thread Mechabellum 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
Heroes of StarCraft mini-set
TL Mafia
TL Mafia Community Thread Vanilla Mini Mafia
Community
General
US Politics Mega-thread Russo-Ukrainian War Thread Things Aren’t Peaceful in Palestine The year 2050 European Politico-economics QA Mega-thread
Fan Clubs
INnoVation Fan Club SKT1 Classic Fan Club!
Media & Entertainment
Anime Discussion Thread Movie Discussion! [Manga] One Piece [\m/] Heavy Metal Thread
Sports
2024 - 2026 Football Thread Formula 1 Discussion TeamLiquid Health and Fitness Initiative For 2023
World Cup 2022
Tech Support
Computer Build, Upgrade & Buying Resource Thread High temperatures on bridge(s) Gtx660 graphics card replacement
TL Community
The Automated Ban List TeamLiquid Team Shirt On Sale
Blogs
Lemme tell you a thing o…
JoinTheRain
How Culture and Conflict Imp…
TrAiDoS
RTS Design in Hypercoven
a11
Evil Gacha Games and the…
ffswowsucks
INDEPENDIENTE LA CTM
XenOsky
Customize Sidebar...

Website Feedback

Closed Threads



Active: 2626 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
LiuLi Cup
11:00
Monthly Finals
Classic vs HeRoMaRinELIVE!
TriGGeR vs herO
Rogue vs TBD
WardiTV742
Harstem374
TKL 248
IndyStarCraft 158
Rex137
CranKy Ducklings93
IntoTheiNu 35
3DClanTV 11
Liquipedia
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
Harstem 374
TKL 248
mouzHeroMarine 206
IndyStarCraft 158
Rex 137
StarCraft: Brood War
Britney 39993
Calm 6202
Horang2 1675
Rain 1530
PianO 1078
Larva 710
Mini 434
EffOrt 429
Stork 397
BeSt 336
[ Show more ]
actioN 322
ggaemo 249
Hyuk 185
Leta 179
Light 177
Snow 175
Mong 165
firebathero 147
Soulkey 144
ZerO 139
Zeus 129
TY 126
Soma 122
Barracks 119
Rush 85
Hyun 85
Mind 62
JYJ55
Sharp 50
Sea.KH 44
Yoon 43
[sc1f]eonzerg 42
sorry 37
zelot 35
ToSsGirL 35
Pusan 31
Sacsri 29
soO 23
yabsab 14
ajuk12(nOOB) 13
Terrorterran 13
HiyA 6
Hm[arnc] 5
Dota 2
Gorgc4197
qojqva2460
XcaliburYe247
XaKoH 195
Counter-Strike
fl0m665
byalli251
flusha183
oskar167
Other Games
B2W.Neo1909
Lowko420
DeMusliM381
Mlord375
SortOf120
Hui .111
ArmadaUGS58
djWHEAT54
QueenE40
ZerO(Twitch)17
MindelVK8
Dewaltoss7
Liquid`VortiX7
Organizations
Counter-Strike
PGL3183
StarCraft: Brood War
UltimateBattle 1027
Other Games
Algost 1
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 15 non-featured ]
StarCraft 2
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• Michael_bg 1
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
Dota 2
• C_a_k_e 600
• WagamamaTV408
League of Legends
• Jankos1692
• Stunt391
Upcoming Events
Cosmonarchy
2h 30m
OyAji vs Sziky
Sziky vs WolFix
WolFix vs OyAji
Big Brain Bouts
2h 30m
Iba vs GgMaChine
TriGGeR vs Bunny
Reynor vs Classic
Serral vs Clem
BSL Team Wars
5h 30m
Team Hawk vs Team Dewalt
BSL Team Wars
5h 30m
Team Hawk vs Team Bonyth
Code For Giants Cup
9h
SC Evo League
22h 30m
TaeJa vs Cure
Rogue vs threepoint
ByuN vs Creator
MaNa vs Classic
Maestros of the Game
1d 2h
ShoWTimE vs Cham
GuMiho vs Ryung
Zoun vs Spirit
Rogue vs MaNa
[BSL 2025] Weekly
1d 4h
SC Evo League
1d 22h
Maestros of the Game
2 days
SHIN vs Creator
Astrea vs Lambo
Bunny vs SKillous
HeRoMaRinE vs TriGGeR
[ Show More ]
BSL Team Wars
2 days
Team Bonyth vs Team Sziky
BSL Team Wars
2 days
Team Dewalt vs Team Sziky
Monday Night Weeklies
3 days
Replay Cast
3 days
Sparkling Tuna Cup
3 days
PiGosaur Monday
4 days
LiuLi Cup
4 days
Replay Cast
5 days
The PondCast
5 days
RSL Revival
5 days
Maru vs SHIN
MaNa vs MaxPax
RSL Revival
6 days
Reynor vs Astrea
Classic vs sOs
Liquipedia Results

Completed

CSL Season 18: Qualifier 1
WardiTV Summer 2025
HCC Europe

Ongoing

Copa Latinoamericana 4
BSL 20 Team Wars
KCM Race Survival 2025 Season 3
BSL 21 Qualifiers
ASL Season 20
Acropolis #4 - TS1
CSL Season 18: Qualifier 2
SEL Season 2 Championship
BLAST Open Fall Qual
Esports World Cup 2025
BLAST Bounty Fall 2025
BLAST Bounty Fall Qual
IEM Cologne 2025
FISSURE Playground #1
BLAST.tv Austin Major 2025

Upcoming

CSL 2025 AUTUMN (S18)
LASL Season 20
BSL Season 21
BSL 21 Team A
Chzzk MurlocKing SC1 vs SC2 Cup #2
Maestros of the Game
EC S1
Sisters' Call Cup
Skyesports Masters 2025
IEM Chengdu 2025
PGL Masters Bucharest 2025
Thunderpick World Champ.
MESA Nomadic Masters Fall
CS Asia Championships 2025
ESL Pro League S22
StarSeries Fall 2025
FISSURE Playground #2
BLAST Open 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.