• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EST 19:33
CET 01:33
KST 09:33
  • 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
[ASL22] Finals Preview: Sweet Victory!12[ASL22] Ro4 Preview: Mirror Mirror6[ASL22] Ro8 Preview: Within Reach5[ASL22] Ro8 Preview: In A Tizzy11[ASL22] Ro16 Preview: Holy Diver5
Community News
Weekly Cups (Oct 26 - Nov 1): MaxPax, herO, Solar win0Weekly Cups (October 19-25): Clem triples first in 5.0.175Evil Geniuses - shutting down23ISSL (IntoTheTV x SOOP SC2 League): Premier7Weekly Cups (October 12-18): 5.0.17 era begins1
StarCraft 2
General
Serral's getting trashed by New Catsle's Mind No more SC2 streamers on team liquid? StarCraft open world shooter announced at BlizzCon [D] Hacker peak in sc2 ? Liquibets sc2 season 30
Tourneys
SC2 iNu's Battles #22 SC4ALL: II Venue Change Announcement! Sparkling Tuna Cup - Weekly Open Tournament WardiTV Mondays ISSL (IntoTheTV x SOOP SC2 League): Premier
Strategy
[H] ZvP Mid-Late Game: Stalkers Collossi HT
Custom Maps
Starcraft 2 Advance [G] How to playtest arcade maps [D] the control group Simple Questions/Answers
External Content
The PondCast: SC2 News & Results Mutation # 551 Robotic Revival Mutation # 550 Graveyard Shift Mutation # 549 Endless Sparkles
Brood War
General
List of top players active on ShieldBattery BGH Auto Balance -> http://bghmmr.eu/ Rollback Netcode in Brood War [Megathread] Daily Funny Videos BW General Discussion
Tourneys
[Megathread] Daily Proleagues [$1250] International ShieldBattery League Small VOD Thread 2.0 KCM Race Survival 2026 Season 4
Strategy
50,000-Word Terran Builds Memo 2026-10-22 Cliff Jump Revisited (1 in a 1000 strategy) Simple Questions, Simple Answers
Other Games
General Games
ZeroSpace Early Access is Now Live! Path of Exile Nintendo Switch Thread General RTS Discussion Thread Stormgate/Frost Giant Megathread
Dota 2
Dota 2 Champions League Season 3 Begins April 25!
League of Legends
[TL LoL EUW IHs] Teemo shall perish
Heroes of the Storm
Heroes of the Storm 2.0
Hearthstone
Deck construction bug
TL Mafia
TL Mafia Community Thread
Community
General
US Politics Mega-thread Trading/Investing Thread Russo-Ukrainian War Thread Dating: How's your luck? Things Aren’t Peaceful in Palestine
Fan Clubs
Fan Club Resource Thread Reynor Fan Club The Flash Fan Club
Media & Entertainment
Movie Discussion! Anime Discussion Thread [Manga] One Piece
Sports
Football (Soccer) Thread TeamLiquid Health and Fitness Initiative For 2023 MLB/Baseball 2023
World Cup 2022
Tech Support
Computer Build, Upgrade & Buying Resource Thread
TL Community
The Automated Ban List Recent Gifted Posts
Blogs
The time I organised my…
AssyrianKing
Playlenda
Playlendapro
Why I built Repalyzer (1.1.…
BlueStar
Innovate or Game Over?
TrAiDoS
ShieldBattery on Mac
Kraekkling
[ASL22] Ro4 Day1 Ticket Giv…
bITt.mAN
Can Bots Beat Pros?? Starcr…
namkraft
Customize Sidebar...

Website Feedback

Closed Threads



Active: 11059 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
Replay Cast
08:00
ISSL: Premier - Final Day
CranKy Ducklings73
LiquipediaDiscussion
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
JimRising 468
StarCraft: Brood War
GuemChi 2456
Artosis 499
EG.Machine 7
Dota 2
canceldota226
League of Legends
Doublelift6797
Super Smash Bros
hungrybox254
AZ_Axe103
PPMD82
Other Games
summit1g9821
shahzam510
C9.Mang0217
B2W.Neo156
NeuroSwarm94
Maynarde84
Organizations
Other Games
gamesdonequick637
BasetradeTV148
Counter-Strike
PGL61
[ Show 11 non-featured ]
StarCraft 2
• Hupsaiya 83
• davetesta12
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• Migwel
StarCraft: Brood War
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
Other Games
• imaqtpie1094
Upcoming Events
Sparkling Tuna Cup
9h 27m
WardiTV Invitational
11h 27m
YoungYakov vs Lambo
SHIN vs TBD
Percival vs Shameless
Solar vs TBD
OSC
22h 27m
ByuN vs MaxPax
herO vs Krystianer
Percival vs Shameless
LetaleX vs YoungYakov
Nicoract vs Gerald
GgMaChine vs ArT
PiGosaur Cup
1d
INu's Battles
1d 11h
ByuN vs Classic
3D!Clan Event
1d 15h
The PondCast
2 days
KCM Race Survival
2 days
WardiTV Invitational
2 days
Ultimate Battle
3 days
[ Show More ]
CranKy Ducklings
4 days
IPSL
4 days
TerrOr vs IJ_Terran
rasowy vs Hazorath
Sparkling Tuna Cup
5 days
IPSL
5 days
Art_Of_Turtle vs KameZerg
Radley vs George
Replay Cast
5 days
WardiTV Weekly
6 days
Replay Cast
6 days
Liquipedia Results

Completed

Proleague 2026-11-06
Blizzard Classic Cup 2026
HCC Season 3

Ongoing

Acropolis #5
KCM Race Survival 2026 Season 4
International ShieldBattery League
Individual League
BSL Season 23
IPSL Winter 2026-27
Calamity Cup Div. A Season 8
IEM Beijing 2026
PGL Masters Bucharest 2026
Stake Ranked Episode 5
1win Private Club #2
Thunderpick World Champ. '26
ESL Pro League Season 24
Stake Ranked Episode 4
1win Private Club #1
Logitech G Play Connect 2026
SL StarSeries Fall 2026
FISSURE Playground #3
BLAST Open Fall 2026

Upcoming

YSL S4
Sector 951
SC4ALL II: Brood War
BSL 23: Non-Korean Championship
HSC XXX
Stellar Fest 2: Lunar Cup
StarCraft2 Weekly Open Tournament 2026 Grand Finals
SC4ALL II: StarCraft II
Kung Fu Cup 2026 Grand Finals
RSL Offline Finals
Underdog Cup 2026 Div 2-3
PGL Bucharest 2027
BLAST Bounty Winter 2027
eXTREMESLAND 2026
PGL Major Singapore 2026
Stake Ranked Episode 6
BLAST Rivals Fall 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.