|
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!
|
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!!
|
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?
|
great spreadsheet. you should consider adding a graph for SQ over time, games played.
|
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
|
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 .
|
I just updated the file as suggested and added an Office2003 version. Felt this justifies a bump :-)
HF HF!!
|
awesome analyzer i like it
|
Is it just me or are the links dead? :/ If so, is there a chance of a reup?
|
|
|
Anybody tested it in OpenOffice? Links are down atm so can't test it myself
|
Will fix the links when i get home...Thx guys!!
|
Hi Every1,
I uploaded the files to a different site now...mediafire deleted them after some time :-(
HF & Merry Christmas!!!
|
|
|
|
|
|