• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 15:59
CEST 21:59
KST 04:59
  • 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
Serral wins HomeStory Cup 2914Serral wins Maestros of the Game 243ByuL, and the Limitations of Standard Play3Team Liquid Map Contest #22: Results and Winners7Code S Season 2 (2026): RO4 and Finals Preview12
Community News
IntoTheTV X SOOP SC2 League : Weekly & Monthly4Clem: "I don't have that much hope in Blizzard"2ZeroSpace Early Access is Now Live!28Weekly Cups (July 13-19): Terran & Protoss rise; Zerg falters2Balance hotfix patch 5.0.16b (July 16)94
StarCraft 2
General
Balance hotfix patch 5.0.16b (July 16) How would you feel about frequent/monthly balance patches for SC2? Reynor: GSL Loss Wasn't About Preparation Format What's the best tug of war? Clem: "I don't have that much hope in Blizzard"
Tourneys
RSL Revival: Season 6 - Qualifiers and Main Event PIG STY FESTIVAL 8.0! (13 - 23 August) IntoTheTV X SOOP SC2 League : Weekly & Monthly INu's Battles#18 - Cure, herO, Rogue & ByuN Master Swan Open (Global Bronze-Master 2)
Strategy
[G] Having the right mentality to improve
Custom Maps
[M] (2) Industrial Park New Map Maker - Looking for Advice - Love or Hate
External Content
Mutation # 536 Railroad Switch The PondCast: SC2 News & Results Mutation # 535 Assembly of Vengeance Mutation # 534 Burning Evacuation
Brood War
General
BGH Auto Balance -> http://bghmmr.eu/ BW General Discussion Recent recommended BW games screpdb: new Starcraft reporting tool ASL22 General Discussion
Tourneys
[Megathread] Daily Proleagues Star Con San Diego 2026 BSL LAN Party - Kraków 29-30 August - OPEN SIGNUPS Escore Tournament - Season 3
Strategy
Simple Questions, Simple Answers PvT advise for noobs Fighting Spirit mining rates Creating a full chart of Zerg builds
Other Games
General Games
ZeroSpace Early Access is Now Live! General RTS Discussion Thread Nintendo Switch Thread Path of Exile Diablo IV
Dota 2
Looking for a Dota Mentor Official 'what is Dota anymore' discussion
League of Legends
TSM pausing esports and CLG Dead
Heroes of the Storm
Heroes of the Storm 2.0
Hearthstone
Deck construction bug
TL Mafia
TL Mafia Power Rank TL Mafia Community Thread NeO.D_StephenKing vs This Guy From 1 Million Dance
Community
General
US Politics Mega-thread Russo-Ukrainian War Thread Artificial Intelligence Thread European Politico-economics QA Mega-thread How to buy a book - shipping from Korea to Europe
Fan Clubs
The IdrA Fan Club The HerO Fan Club!
Media & Entertainment
Movie Discussion! Anime Discussion Thread Series you have seen recently... [Req][Books] Good Fantasy/SciFi books
Sports
2024 - 2026 Football Thread 2026-27 Football Thread placeholder TeamLiquid Health and Fitness Initiative For 2023 Formula 1 Discussion MLB/Baseball 2023
World Cup 2022
Tech Support
Computer Build, Upgrade & Buying Resource Thread Simple Questions Simple Answers FPS when play League Of Legend on laptop
TL Community
Northern Ireland Global Starcraft The Automated Ban List
Blogs
Games, Hormones, and "Dark" …
TrAiDoS
Hello guys!
LIN1s
ASL S22 English Commentary…
namkraft
Poker (part 2)
Nebuchad
An Exploration of th…
waywardstrategy
Customize Sidebar...

Website Feedback

Closed Threads



Active: 6533 users

1v1 Stat Tracker (for Zerg) - Page 2

Forum Index > SC2 General
Post a Reply
Prev 1 2 All
BuddhiBadugi
Profile Joined June 2011
Germany45 Posts
Last Edited: 2011-11-26 11:21:54
November 26 2011 10:56 GMT
#21
On November 24 2011 07:33 Conquerer67 wrote:
Looks like you put a lot of effort into it, but why did you upload it in .xlsx format? It's not that hard for me to convert, but other people might have problems with doing so.

If you could provided a standard .xls format, that would be nice.


Will do the with the next update! Honestly didn't think about it.Thanks!
"My mum is da man" - Day[9]
BuddhiBadugi
Profile Joined June 2011
Germany45 Posts
November 26 2011 11:25 GMT
#22
On November 24 2011 09:46 korona wrote:

+ Show Spoiler +


Nicely done! Indeed there are lots of us who are into statistics and are annoyed as Blizzard provides no general statistics through SC2 (even basic loss & total games counts are hidden for players under masters). I myself have had a private statistics spreadsheet from the spring (that I extend as time goes on), which I use alongside with sc2gears data. It will remain private thought as I won't have time to clean it up for publishing. I might borrow some ideas from your sheet when I next time extend mine. Thanks

Suggestion regarding complementing win-ratio graphs: Their biggest problem is that when amount of played games increases, the win-ratios often approach 50% or some other figure. And thus as more games are played the information the graphs provide becomes more irrelevant. I myself have found that win-lose differential graphs for each match-up give much better progress information. Here is an example: http://imgur.com/g8gyA. You might want to add something similar to complement your win-ratio graphs. I also suggested to Dakota_Fanning to add win-lose differential charts into sc2gears in the future, but I am not sure if he was interested in this idea, but time will tell.



Thanks for the suggestion! This will really become a problem when there is a ton of games in the database. I adopted your approahc and will make it available with one other thing I'm working on. I you have anything else useful in your sheet, let me know!!
"My mum is da man" - Day[9]
BuddhiBadugi
Profile Joined June 2011
Germany45 Posts
Last Edited: 2011-11-26 11:28:33
November 26 2011 11:28 GMT
#23
On November 26 2011 16:10 Ahelvin wrote:

+ Show Spoiler +


He is using the Spawning Ratio from SC2Gears, by Dakota_Fanning.

Here is his/her explaination :

Example #1: If you first inject a hatchery at 3:00 and you keep reinjecting all the time exactly when the larva spawning ends up until 5:00 and you leave the game at 6:00, then you had your hatchery spawning larvas for 2 minutes, and 1 minute idle => average spawning ratio = 2/3 = 66%.

Example #2: let's assume a spawn larva takes 30 seconds. You first inject at 3:00, next at 4:00, next at 5:00 and you leave the game at 5:30. Then you had your hatchery spawning larva for 3x30 sec = 1.5 min, and it was idle for 2x30 sec = 1 min. In this case average spawning ratio = 1.5/2.5 = 60%.

Now let's look at the average injection gap:

Example #1: injection gap here is 0 second because you always re-injected. The time after the last injection is omitted (the last idle minute).

Example #2: you had 2 gaps between injections, first: 3:30-4:00 and the second: 4:30-5:00. Both gaps are 30 seconds long, the average injection gap is 30 seconds.

Sc2gears calculates the avg spawning ratio and the avg injection gap for all hatcheries and a global average (weighted average of all your hatcheries).



Nice explanation and thanks for the warm words before. I'm glad you like it!

Let me ask you this: what is the better benchmark for vomitting larvae in your opinion?
"My mum is da man" - Day[9]
zokj
Profile Joined July 2010
Canada136 Posts
November 26 2011 11:37 GMT
#24
great spreadsheet. you should consider adding a graph for SQ over time, games played.
BuddhiBadugi
Profile Joined June 2011
Germany45 Posts
November 26 2011 11:40 GMT
#25
On November 26 2011 20:37 zokj wrote:
great spreadsheet. you should consider adding a graph for SQ over time, games played.


It's in there...see 5th & 6th pic
"My mum is da man" - Day[9]
Ahelvin
Profile Blog Joined September 2010
France1866 Posts
November 26 2011 11:47 GMT
#26
On November 26 2011 20:28 BuddhiBadugi wrote:
Show nested quote +
On November 26 2011 16:10 Ahelvin wrote:

+ Show Spoiler +


He is using the Spawning Ratio from SC2Gears, by Dakota_Fanning.

Here is his/her explaination :

Example #1: If you first inject a hatchery at 3:00 and you keep reinjecting all the time exactly when the larva spawning ends up until 5:00 and you leave the game at 6:00, then you had your hatchery spawning larvas for 2 minutes, and 1 minute idle => average spawning ratio = 2/3 = 66%.

Example #2: let's assume a spawn larva takes 30 seconds. You first inject at 3:00, next at 4:00, next at 5:00 and you leave the game at 5:30. Then you had your hatchery spawning larva for 3x30 sec = 1.5 min, and it was idle for 2x30 sec = 1 min. In this case average spawning ratio = 1.5/2.5 = 60%.

Now let's look at the average injection gap:

Example #1: injection gap here is 0 second because you always re-injected. The time after the last injection is omitted (the last idle minute).

Example #2: you had 2 gaps between injections, first: 3:30-4:00 and the second: 4:30-5:00. Both gaps are 30 seconds long, the average injection gap is 30 seconds.

Sc2gears calculates the avg spawning ratio and the avg injection gap for all hatcheries and a global average (weighted average of all your hatcheries).



Nice explanation and thanks for the warm words before. I'm glad you like it!

Let me ask you this: what is the better benchmark for vomitting larvae in your opinion?


I think I like the average injection gap more. Because quite often I lose the game after a long, downward slope of ownage, and in this period I'm not injecting anymore since my queens are dead. The average injection gap is a good indicator of how well I'm faring in the actual game, when I still have a chance to win .
Join the Liquipedia Zerg Project ! PM me for more information :).
BuddhiBadugi
Profile Joined June 2011
Germany45 Posts
November 30 2011 18:25 GMT
#27
I just updated the file as suggested and added an Office2003 version. Felt this justifies a bump :-)

HF HF!!
"My mum is da man" - Day[9]
Last Raven
Profile Joined April 2011
Belgium14 Posts
December 11 2011 00:20 GMT
#28
awesome analyzer i like it
The power of my mind, The edge of my sword
Gregseh
Profile Joined November 2011
United Kingdom11 Posts
December 19 2011 12:59 GMT
#29
Is it just me or are the links dead? :/ If so, is there a chance of a reup?
Advocado
Profile Blog Joined September 2010
Denmark994 Posts
December 19 2011 13:04 GMT
#30
Yep the links are dead!
http://www.twitch.tv/advocadosc2
Neddal
Profile Joined July 2010
Netherlands85 Posts
Last Edited: 2011-12-19 13:16:46
December 19 2011 13:16 GMT
#31
Anybody tested it in OpenOffice? Links are down atm so can't test it myself
BuddhiBadugi
Profile Joined June 2011
Germany45 Posts
December 19 2011 14:38 GMT
#32
Will fix the links when i get home...Thx guys!!
"My mum is da man" - Day[9]
BuddhiBadugi
Profile Joined June 2011
Germany45 Posts
December 24 2011 11:49 GMT
#33
Hi Every1,

I uploaded the files to a different site now...mediafire deleted them after some time :-(

HF & Merry Christmas!!!
"My mum is da man" - Day[9]
Prev 1 2 All
Please log in or register to reply.
Live Events Refresh
Online Event
15:00
Yamato Cup #7
killerbeecast16
LiquipediaDiscussion
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
RotterdaM 882
ProTech100
BRAT_OK 88
ZombieGrub81
StarCraft: Brood War
Shuttle 946
Mini 698
ggaemo 231
Free 41
soO 40
Shine 18
NaDa 12
yabsab 8
firebathero 0
Dota 2
monkeys_forever235
League of Legends
Doublelift996
Counter-Strike
fl0m3283
minikerr63
Heroes of the Storm
Khaldor320
Other Games
Grubby2619
Beastyqt738
Mlord390
ArmadaUGS140
C9.Mang0133
Livibee87
Mew2King37
Organizations
Other Games
gamesdonequick1850
StarCraft 2
angryscii 34
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
[ Show 17 non-featured ]
StarCraft 2
• Reevou 14
• IndyKCrew
• AfreecaTV YouTube
• sooper7s
• intothetv
• Kozan
• LaughNgamezSOOP
• Migwel
StarCraft: Brood War
• blackmanpl 45
• FirePhoenix26
• Pr0nogo 7
• STPLYoutube
• ZZZeroYoutube
• BSLYoutube
League of Legends
• Jankos2413
• TFBlade351
Other Games
• Shiphtur443
Upcoming Events
WardiTV Weekly
15h 1m
Sparkling Tuna Cup
1d 14h
INu's Battles
1d 15h
Cure vs herO
ByuN vs Rogue
PiGosaur Cup
2 days
The PondCast
2 days
Kung Fu Cup
2 days
Patches Events
2 days
Replay Cast
3 days
CrankTV Team League
3 days
OSC
3 days
[ Show More ]
Replay Cast
4 days
CrankTV Team League
4 days
Replay Cast
5 days
Afreeca Starleague
5 days
RSL Revival
5 days
ByuN vs SHIN
Solar vs Lambo
WardiTV Summer Champion…
5 days
Afreeca Starleague
6 days
RSL Revival
6 days
Clem vs Serral
herO vs Rogue
WardiTV Summer Champion…
6 days
Liquipedia Results

Completed

ASL S22 SEASON OPEN Day 2
HSC XXIX
Eternal Conflict S2 E3

Ongoing

CSL 2026 Summer (S21)
KCM Race Survival 2026 Season 3
Proleague 2026-07-26
RSL Revival: Season 6
CranK Gathers Season 4: BW vs SC2 Team League
SCTL 2026 Spring
Eternal Conflict S2 Finale
BLAST Bounty Summer Qual
Stake Ranked Episode 3
XSE Pro League 2026
IEM Cologne Major 2026
Stake Ranked Episode 2
CS Asia Championships 2026
Asian Champions League 2026
IEM Atlanta 2026
PGL Astana 2026

Upcoming

Escore Tournament S3: W5
ASL Season 22: Qualifier #1
ASL Season 22: Qualifier #2
Acropolis #5
CSLAN 4
ASL Season 22
Blizzard Classic Cup 2026
HSC XXX
SC4ALL II: StarCraft II
Kung Fu Cup 2026 Grand Finals
PiG Sty Festival 8.0
Light Tournament 2026
ESL Pro League Season 24
Stake Ranked Episode 4
Logitech G Connect 2026
SL StarSeries Fall 2026
FISSURE Playground #5
BLAST Open Fall 2026
Esports World Cup 2026
BLAST Bounty Summer 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.