• 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: 2663 users

1v1 Stats Spreadsheet - Page 9

Forum Index > SC2 General
Post a Reply
Prev 1 7 8 9 10 11 Next All
Chemist391
Profile Joined October 2010
United States366 Posts
June 13 2012 19:56 GMT
#161
Could you add a Spending Quotient column?

Thread containing the SQ formula.
Existor
Profile Joined July 2010
Russian Federation4295 Posts
June 13 2012 20:47 GMT
#162
Is it possible to add replay analyzer and info extractor into race,win/lose,map, etc ?
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
June 13 2012 21:35 GMT
#163
On June 14 2012 03:27 Muckles wrote:
It works fine again now thank you.

No problem

On June 14 2012 04:47 Existor wrote:
I dont understand. Is it possible to automatize that process? Or you must open it after every game and edit, adding map and matchup?

Anyway, great and giant work!

I don't know how to extract data from replays. I'm happy to add it in if someone knows how but I don't have the time or coding knowledge to look into it.

On June 14 2012 04:56 Chemist391 wrote:
Could you add a Spending Quotient column?

Thread containing the SQ formula.

Maybe - Looking into this now. Would mean having to fill in 3 more columns (and people are reluctant to fill in the exising 5 columns! lol) and not sure how this would fit in with exisitng spreadsheets with 1000s of games on. As I say - I'm looking into it but no promises



Apolo
Profile Joined May 2010
Portugal1259 Posts
June 13 2012 21:55 GMT
#164
I had done one myself, but this one is way prettier. Well done !
oGoZenob
Profile Joined December 2011
France1503 Posts
June 13 2012 21:56 GMT
#165
thanks dude, that's awesome !
I like starcraft
-Aura-
Profile Blog Joined March 2011
United States209 Posts
June 13 2012 22:09 GMT
#166
Every time I hit download it just refreshes the page for some reason...
¯\_(ツ)_/¯ Liquid get more Terrans please...
NVRLand
Profile Joined March 2012
Sweden203 Posts
June 13 2012 22:20 GMT
#167
Am I supposed to put the opponents league or my own league in the league column?


Awesome work btw. Don't bother me so much that it is manual. Just start Excel along with SC2 and enter the data after every game. Not that exhausting.
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
June 13 2012 22:24 GMT
#168
On June 14 2012 07:09 -Aura- wrote:
Every time I hit download it just refreshes the page for some reason...

No idea, try re-loading it. Maybe pop-ups are blocked?
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
June 13 2012 22:28 GMT
#169
On June 14 2012 07:20 NVRLand wrote:
Am I supposed to put the opponents league or my own league in the league column?


Awesome work btw. Don't bother me so much that it is manual. Just start Excel along with SC2 and enter the data after every game. Not that exhausting.

Thanks! You enter your opponent's league.

I am currently deciding whether to replace the league stats since this is not the best use of space as you rarely change league. And I have some ideas for more useful and interesting stats/charts! Look forward to it :D
skeldark
Profile Joined April 2010
Germany2223 Posts
June 13 2012 22:29 GMT
#170
for the people who are intrested in stats:
The season 7 data we collected with the mmr-stats tool.
Datafiles: Season 7 Data
Save gaming: kill esport
Muckles
Profile Joined April 2012
Austria17 Posts
June 14 2012 16:30 GMT
#171

I am currently deciding whether to replace the league stats since this is not the best use of space as you rarely change league. And I have some ideas for more useful and interesting stats/charts! Look forward to it :D



I think you should left the league stats in. It is ture that you don't chance the league very often but when you are about to get promoted you will play a lot more better players and this realy helps to keep track of it.

If you want to add something just trow it in I would say because you have nearly infinity space .
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!
Flooz
Profile Joined April 2012
United States37 Posts
June 14 2012 16:45 GMT
#172
AWESOME!!!! thanks!
"There is nothing cooler than being proud of the things you love" - Day[9]
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
Last Edited: 2012-06-18 01:29:40
June 18 2012 01:29 GMT
#173
Ok guys, I've made a lot of changes to the spreadsheet. Please try it out (download link on the 1st page) and let me know what you think about it.
SynergySC2
Profile Joined February 2012
United States27 Posts
June 18 2012 01:34 GMT
#174
so whats the program to open this file with? cuz i dont got it
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
June 18 2012 01:35 GMT
#175
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
SynergySC2
Profile Joined February 2012
United States27 Posts
June 18 2012 01:39 GMT
#176
On June 18 2012 10:35 WarpMePlz wrote:
Show nested quote +
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
Xkfyu
Profile Joined December 2006
United States165 Posts
June 18 2012 02:07 GMT
#177
This new version is sick. Can't wait to transfer my games over.
WarpMePlz
Profile Joined January 2011
United Kingdom76 Posts
June 18 2012 11:53 GMT
#178
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

I bought office 2007 a while ago, not sure where you can download it from sorry.
Muckles
Profile Joined April 2012
Austria17 Posts
June 18 2012 17:43 GMT
#179
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
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!
Roxas146
Profile Joined June 2012
United States7 Posts
June 18 2012 18:03 GMT
#180
Having done things like this before, I know how much time that you spent writing this. This will absolutely help me and I greatly appreciate your selfless work!
Prev 1 7 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.