• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EST 05:29
CET 11:29
KST 19:29
  • 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
Behind the Blue - Team Liquid History Book6Clem wins HomeStory Cup 288HomeStory Cup 28 - Info & Preview13Rongyi Cup S3 - Preview & Info4herO wins SC2 All-Star Invitational14
Community News
Weekly Cups (Jan 26-Feb 1): herO, Clem, ByuN, Classic win2RSL Season 4 announced for March-April7Weekly Cups (Jan 19-25): Bunny, Trigger, MaxPax win3Weekly Cups (Jan 12-18): herO, MaxPax, Solar win0BSL Season 2025 - Full Overview and Conclusion8
StarCraft 2
General
Clem wins HomeStory Cup 28 How do you think the 5.0.15 balance patch (Oct 2025) for StarCraft II has affected the game? Behind the Blue - Team Liquid History Book Rongyi Cup S3 - Preview & Info HomeStory Cup 28 - Info & Preview
Tourneys
PIG STY FESTIVAL 7.0! (19 Feb - 1 Mar) WardiTV Mondays $21,000 Rongyi Cup Season 3 announced (Jan 22-Feb 7) Sparkling Tuna Cup - Weekly Open Tournament $5,000 WardiTV Winter Championship 2026
Strategy
Custom Maps
Map Editor closed ? [A] Starcraft Sound Mod
External Content
The PondCast: SC2 News & Results Mutation # 511 Temple of Rebirth Mutation # 510 Safety Violation Mutation # 509 Doomsday Report
Brood War
General
BW General Discussion Recent recommended BW games BGH Auto Balance -> http://bghmmr.eu/ Can someone share very abbreviated BW cliffnotes? StarCraft player reflex TE scores
Tourneys
[Megathread] Daily Proleagues Escore Tournament StarCraft Season 1 Small VOD Thread 2.0 KCM Race Survival 2026 Season 1
Strategy
Zealot bombing is no longer popular? Simple Questions, Simple Answers Current Meta Soma's 9 hatch build from ASL Game 2
Other Games
General Games
Diablo 2 thread Battle Aces/David Kim RTS Megathread EVE Corporation Nintendo Switch Thread 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
Deck construction bug Heroes of StarCraft mini-set
TL Mafia
Vanilla Mini Mafia Mafia Game Mode Feedback/Ideas
Community
General
US Politics Mega-thread Russo-Ukrainian War Thread YouTube Thread The Games Industry And ATVI Things Aren’t Peaceful in Palestine
Fan Clubs
The herO Fan Club! The IdrA Fan Club
Media & Entertainment
[Manga] One Piece Anime Discussion Thread
Sports
2024 - 2026 Football Thread
World Cup 2022
Tech Support
TL Community
The Automated Ban List
Blogs
Play, Watch, Drink: Esports …
TrAiDoS
My 2025 Magic: The Gathering…
DARKING
Life Update and thoughts.
FuDDx
How do archons sleep?
8882
James Bond movies ranking - pa…
Topin
Customize Sidebar...

Website Feedback

Closed Threads



Active: 1516 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
Next event in 1h 31m
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
ProTech185
StarCraft: Brood War
Rain 7452
Calm 6543
GuemChi 1418
Flash 1346
firebathero 1029
Horang2 598
Larva 478
Soma 247
actioN 235
Mini 204
[ Show more ]
Leta 204
ZerO 124
Hyun 110
Mong 94
Last 90
Pusan 69
910 67
ggaemo 62
Shuttle 54
sorry 52
Sharp 49
Mind 48
Backho 32
sSak 30
NaDa 20
zelot 18
GoRush 17
Noble 17
Free 16
Shine 16
Sacsri 10
Movie 7
Dota 2
Fuzer 189
XcaliburYe127
Super Smash Bros
Mew2King92
Westballz48
Heroes of the Storm
Khaldor293
Other Games
gofns14519
singsing1304
B2W.Neo527
MindelVK23
ZerO(Twitch)18
Organizations
Other Games
gamesdonequick1225
BasetradeTV114
StarCraft: Brood War
lovetv 21
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 13 non-featured ]
StarCraft 2
• StrangeGG 37
• LUISG 22
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
League of Legends
• Jankos1823
Upcoming Events
uThermal 2v2 Circuit
1h 31m
WardiTV Winter Champion…
4h 31m
OSC
13h 31m
Replay Cast
22h 31m
Wardi Open
1d 1h
Monday Night Weeklies
1d 6h
Sparkling Tuna Cup
1d 23h
LiuLi Cup
2 days
Reynor vs Creator
Maru vs Lambo
PiGosaur Monday
2 days
LiuLi Cup
3 days
Clem vs Rogue
SHIN vs Cyan
[ Show More ]
The PondCast
3 days
KCM Race Survival
3 days
LiuLi Cup
4 days
Scarlett vs TriGGeR
ByuN vs herO
Online Event
4 days
LiuLi Cup
5 days
Serral vs Zoun
Cure vs Classic
LiuLi Cup
6 days
Sparkling Tuna Cup
6 days
Liquipedia Results

Completed

CSL 2025 WINTER (S19)
Rongyi Cup S3
Underdog Cup #3

Ongoing

KCM Race Survival 2026 Season 1
Nations Cup 2026
IEM Kraków 2026
BLAST Bounty Winter 2026
BLAST Bounty Winter Qual
eXTREMESLAND 2025
SL Budapest Major 2025
ESL Impact League Season 8

Upcoming

Escore Tournament S1: W8
Acropolis #4
IPSL Spring 2026
HSC XXIX
uThermal 2v2 2026 Main Event
Bellum Gens Elite Stara Zagora 2026
RSL Revival: Season 4
WardiTV Winter 2026
LiuLi Cup: 2025 Grand Finals
CCT Season 3 Global Finals
FISSURE Playground #3
IEM Rio 2026
PGL Bucharest 2026
Stake Ranked Episode 1
BLAST Open Spring 2026
ESL Pro League Season 23
ESL Pro League Season 23
PGL Cluj-Napoca 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.