EPT
at least i make workers like a platinum player while in silver 
Do you macro like a pro? - Page 52
| Forum Index > SC2 General |
|
XerrolAvengerII
United States510 Posts
at least i make workers like a platinum player while in silver | ||
|
HughJorgen
Australia37 Posts
If nobody's said this already I think you deserve an honorary masters in SC2 studies. Make the post 20 times longer for the doctorate :-p | ||
|
Nemireck
Canada1875 Posts
On November 02 2011 10:16 TehTemplar wrote: I say sq, because my SQ is usually double my apm. Neither. When taken out of context, both are completely arbitrary statistics that don't tell you anything meaningful about the skill of the player. Your APM can be 50 but completely wasted on moving 6 lings around the map til you lose. Your SQ can be 50, but you can dominate another player with an SQ of 90 because they're on one base, and you're on 8 base and maxed for 10 minutes. People need to stop looking at their APM and SQ and wondering why they lost. I can't help but shake my head when I see players say things like "I'm stuck in gold, but my APM is 150 and my SQ average is 90, so really I'm a Low Masters player, but I keep losing to cheese/imba/weird strategies." | ||
|
English
United States475 Posts
| ||
Poopi
France12911 Posts
90.6 Too bad my upgrades are shit every game because of bad hotkey placement for ebays . | ||
|
MtlGuitarist97
United States1539 Posts
| ||
|
MrCash
United States1504 Posts
The title should be "do you play like a pro" because this is the fundamental necessity of becoming good, good micro is the icing for the best of the best. | ||
|
sAsThark
France27 Posts
| ||
|
LetoAtreides82
United States1188 Posts
On November 05 2011 11:01 sAsThark wrote: I have make this little application if someone here was looking for a tool like that : http://www.sas-team.net/download/file.php?id=1281 Thank you so much! | ||
|
Iksf
United Kingdom444 Posts
On November 05 2011 11:01 sAsThark wrote: I have make this little application if someone here was looking for a tool like that : http://www.sas-team.net/download/file.php?id=1281 Wow that app, though so simple, impressed me a lot, please get it added to OP | ||
|
bigwig123
163 Posts
On November 05 2011 11:01 sAsThark wrote: I have make this little application if someone here was looking for a tool like that : http://www.sas-team.net/download/file.php?id=1281 thx | ||
|
sAsThark
France27 Posts
http://www.sas-team.net/download/file.php?id=1295 If anyone see features I can add, don t be shy to ask me by pm.. | ||
|
.kv
United States2332 Posts
| ||
|
Techno
1900 Posts
| ||
|
Glycerine
United States10 Posts
| ||
|
Solirinn
Belgium2 Posts
![[image loading]](http://i.imgur.com/6L83P.png) The main sheet where you can add games or switch between your races. ![[image loading]](http://i.imgur.com/b70ND.png) Your 'Equivalent League' distribution (also according to results or matchups). ![[image loading]](http://i.imgur.com/lMJQO.png) More detailed graph of your 'Equivalent League' distribution ![[image loading]](http://i.imgur.com/uaUQb.png) My favourite graph; shows your SQ's and their corresponding Income. ![[image loading]](http://i.imgur.com/peiOl.png) Same graph as the previous one, but this time the SQ's are coloured according to the matchup instead of the result. ![[image loading]](http://i.imgur.com/m6V1w.png) Cumulative Average SQ (based on result) ![[image loading]](http://i.imgur.com/h02q5.png) Keeps track of your winratios in your matchups. It still doesn't require much input: you just have to add Average Unspent Resources, Average Income, Result (W or L) and the Match up (P T Z) in the Main sheet (='1v1'). Unfortunately I'm still not very proficient with Excel so after you've added a game (or multiple games), you've got to press the update button on that page as well to get some filters refreshed (which is necessary for some sheets to update their data). This Excel-file contains sheets for the 3 races so you can just pick your's in the '1v1' sheet, or switch between them if you play random. You'll probably notice there are some graphs that represent the same data but visualise it slightly different ('SQ ...' and 'Avg SQ ...' and their second versions 'SQ ... 2'). I meant this so you could decide for yourself which one you wanted to keep/delete, because I couldn't. If you want to delete one of them (or if you want to delete other sheets obviously): don't forget to delete the relevant lines in the macros as well. Link to the file: http://www.mediafire.com/?jvj4t7bqcryysyf p.s. You will be asked if you want to enable macros in this Excel file. You'll need to do this in order for them to work. | ||
|
Crashburn
United States476 Posts
On November 21 2011 09:03 Solirinn wrote: I know it's been a while since the OP but I want to share my spreadsheet anyway. After I read this post I used a spreadsheet created by The_Austin (I believe). However I thought it'd be nice if some of the data was presented visually and secondly if I could analyse my SQ a bit more (Is my SQ different when I win or lose or in a certain matchup?). Therefore I extended his spreadsheet quite a bit. Here are some images of the most relevant sheets to give you a general idea. [snip] Keeps track of your winratios in your matchups. It still doesn't require much input: you just have to add Average Unspent Resources, Average Income, Result (W or L) and the Match up (P T Z) in the Main sheet (='1v1'). Unfortunately I'm still not very proficient with Excel so after you've added a game (or multiple games), you've got to press the update button on that page as well to get some filters refreshed (which is necessary for some sheets to update their data). This Excel-file contains sheets for the 3 races so you can just pick your's in the '1v1' sheet, or switch between them if you play random. You'll probably notice there are some graphs that represent the same data but visualise it slightly different ('SQ ...' and 'Avg SQ ...' and their second versions 'SQ ... 2'). I meant this so you could decide for yourself which one you wanted to keep/delete, because I couldn't. If you want to delete one of them (or if you want to delete other sheets obviously): don't forget to delete the relevant lines in the macros as well. Link to the file: http://www.mediafire.com/?jvj4t7bqcryysyf p.s. You will be asked if you want to enable macros in this Excel file. You'll need to do this in order for them to work. Thank you for the spreadsheet. I find it extremely useful. | ||
|
Nyast
Belgium554 Posts
| ||
|
Akhee
Brazil811 Posts
| ||
|
gavinashun
101 Posts
Really awesome analysis, thanks! Seems like a lot of folks have focused on calculating and tracking SQ, and using this as a metric to compare vs. leagues. Which is great. I'm also interested to do the same for workers produced at a couple different time points through out the game (e.g. maybe 15 min and 25 min, or whatever). I don't think there is enough info in the OP to do this however. Do you have a benchmark of average workers by race and by league for several time points? I.e. what is the average works at 15 minutes for a gold vs plat vs diamond vs masters Terran ... how about 25 min? How about zerg? Etc. This would allow us to then track and benchmark this metric as well as SQ. Thanks and thanks again for the ridiculously cool analysis! | ||
| ||
