• Log In
  • Register
  • Settings
TeamLiquid TeamLiquidPro Liquipedia TSL4 LiquidPoker
EDT 05:17
CEST 11:17
KST 18:17
  • Home
  • Forum
  • Streams
  • Liquipedia
  • Features
  • Store
  • WCS
  • StarCraft 2
  • Dota 2
  • Brood War
  • WCS Portal
  • Liquibet
  • Fantasy StarCraft
  • TLPD
  • Events
  • BarCraft
  • StarCraft 2
  • Dota 2
  • Brood War
  • League of Legends
  • Blogs
Featured News
Dota 2 Super League Group …
[SPL] Round 6 Week 3 Revie…
Auction OSL - Ro32 Day 2 P…
Auction OSL - Day 1 Recap …
Auction OSL: Ro32 - Openin…
Community News
[SPL] Round 6 Week 4 Lineups
BlackBerry sponsors Virtus…
New Patch - Warp Prism buf…
ESL TV adds Shaun 'Apollo'…
WCS AM Season 2 to be run …
Confirmed Players at the M…
Defiler Tours #60, 61, 62 …
C Liquid Team News
HomeStory Cup VII!
Liquid Weekly Digest | June…
Zenio: Razer Replaypack of …
EG-TL vs Team Eight in Roun…
Dreamhack Summer Day 3: Sc2!
Sponsored Threads
New SC2Links Mobile App …
Gamers Wanted as Volunteer…
TL Advertising Features
C General
James Gandolfini Passes …
NeverWet - Water Proof E…
[TV] The Newsroom
Naruto (manga spoilers)
Queens of the Stone Age
C TL Community
TL.net Ten Commandments
Happy Birthday Antoine!!!
BarCraft Mania in Aachen W…
Happy birthday salle!
[Aus] Monash Uni SC2 Society
C Fan Clubs
The StarDust Fan Club!
The IdrA Fanclub
C User Streams
Stream prOxy
nSFlyingToilet streaming
C Tech Support
Teamliquid Monitor Thread
How to visit t he forums a…
Inaccurate mouse on big sc…
The Ultimate Headphone/Aud…
Razer Spectre Review
C SC2 General
UR Gaming acquires Sovie…
GM / Master map hacker a…
New Patch - Warp Prism b…
INnoVation and Cakegirl
[SPL] Round 6 Week 4 Lin…
Esports contributor: Azu…
C SC2 Tourneys
[OSL] Ro32 Groups C&D 2013…
[HSC VII] Day 1
[HSC] HomeStory Cup VII po…
SEANA Trials NA Qualifier …
[UK] epic.ELEVEN to host B…
C SC2 Strategy
The HotS Zerg Help Me Thread
CatZ CC first counter - a …
The HotS Protoss Help Me T…
[Q] Is Mech weaker then bi…
[G] The Triple Barrel Bust…
C Custom Maps
[A] Starbow
[M] (2) TPW Aldaris Betrayal
[P] Semmo's Map Thread
[M] (2) Crux Haeundae
[M] (4) TPW Roadrunner
C Dota 2 General
Dota 2 Super League Grou…
[stream] Sing
General Discussion
Valve confirms release t…
Inhouse Dota
BlackBerry sponsors Virt…
C Dota 2 Tourneys
Perfect World's Dota 2 Su…
Liquid Pasture Community L…
$2000 Dota 2 Open [Chicago]
RaidCall EMS One Americas …
Dota 2 General LR thread
C Dota 2 Strategy
Simple Questions, Simple A…
[G] Dark Seer, the master …
Does Visage deserve to be …
On the stomping of pubs
Learning Weaver?
C BW General
[TLS2 Ro16 Predictions]
No LAN ? O_o
[SOSPA] Event Matches
Nada's Body
"Your connection to Batt…
New Launcher for ICC and…
C BW Tourneys
[R&S] 14th SOSPA Ranking T…
[DRTL] All-Star Game
[CRTL] Finals: C Entus vs …
Defiler Tours #60, 61, 62 …
China vs Korea: Movie vs F…
C BW Strategy
DragOn's BW strategy reboot
Simple Questions, Simple A…
Practice Partner Thread
Tutorial videos for beginn…
C Sports & Games
The XBox One
2012 - 2013 Football Thr…
Confederations Cup 2013!
Path of Exile
[PS3] The Last of Us
C League of Legends
[Patch 3.08: Aatrox Patch]…
Was going to try LoL but c…
The Shikyo Memorial for QQ…
C LoL Tourneys
[NA LCS] Summer Week 2
[OGN] Champions Summer Qua…
[AMD-INVEN]GamExperience
C LoL Strategy
[Guide] Montegomery's Supe…
[Tricks] Warding
[Champion] Diana
C Diablo 3
D3 Hardcore Community
The: What is my item worth?
Diablo 3 Coming to Xbox 36…
C TL Mafia
ESPORTS Mafia (streamed ma…
Roulette Mini Mafia
Active List of Mafia Games
C Health & Fitness
Running Thread
Olympic Weightlifting Thread
The 2013 Weightlifting Pro…
C Featured Blogs
Girl with flowers…
Glider
Voice
thedeadhaji
WC3 Power Ranks!
monk
E3 2013
kierpanda
Sketch: Tap Out To…
Raihn
C Blogs
Quod Erat Dem…
Shiverfish
Dreamhack Summer…
Teodice
Theodicy and Mi…
Jerubaal
Les 24 Heures d…
HotShizz
Chilled Gaming M…
DJWilma
ISO Phil…
KING CHARLIE :D
The Grave Tempest…
gaymon
Leta - Movie
Michael - skyline
Anytime - Beast
By.Hero - Shuttle
Anytime - Pusan
Customize Sidebar...

Website Feedback

Closed Threads


IRC Web Chat

TeamSpeak 3 (38 users)


Active: 7172 users

Do you macro like a pro? - Page 52

Forum Index > StarCraft 2 Prev 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 Next
 
 XerrolAvengerII   United States. November 03 2011 06:40. Posts 464
Profile # 
i wish i macroed like a pro at least i make workers like a platinum player while in silver
Hey! Hey! Can I interest you in some fruit? Would you like a Banana!?...
Old Post

 
 HughJorgen   Australia. November 03 2011 08:04. Posts 37
Profile # 
Wow,

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
Old Post

 
 Nemireck   Canada. November 03 2011 08:16. Posts 807
Profile # 

On November 02 2011 10:16 TehTemplar wrote:

Show nested quote +
On October 30 2011 14:46 Cubbieblue66 wrote:
Is it worse to have an APM around 50 or a SQ around 50?


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."
Teamwork is awesome... As long as your team is doing all the work!
Old Post

 
 English   United States. November 03 2011 08:17. Posts 444
Profile # 
Wow, very cool.
 
Old Post

 
 Poopi   France. November 03 2011 21:51. Posts 4013
Profile # 
Average SQ from the 18 (well 20 but two of them were all-in with less then 600 income so I took them off) last games :
90.6
Too bad my upgrades are shit every game because of bad hotkey placement for ebays .
https://www.youtube.com/user/ChaTTmosh
Old Post

 
 MtlGuitarist97   United States. November 03 2011 22:39. Posts 367
Profile # 
My average SQ over my last 5 games was a 76.4 for a High Diamond Terran on NA :D
Old Post

 
 MrCash   United States. November 04 2011 06:07. Posts 1498
Profile # 
Amazing post.
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.
Old Post

 
 sAsThark   France. November 05 2011 11:01. Posts 26
Profile # 
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
Last edit: 2011-11-05 11:02:03
http://fedoraproject.org/
Old Post

 
 LetoAtreides82   United States. November 06 2011 09:11. Posts 1188
Profile # 

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!
The spice must flow
Old Post

 
 Iksf   United Kingdom. November 06 2011 11:46. Posts 369
Profile # 

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
 
Old Post

 
 bigwig123   November 06 2011 15:05. Posts 162
Profile Blog # 

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
Old Post

 
 sAsThark   France. November 07 2011 01:18. Posts 26
Profile # 
Hi, you were many to download it, so I have improve.

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..
Last edit: 2011-11-07 01:38:20
http://fedoraproject.org/
Old Post

 
 .kv   United States. November 12 2011 04:35. Posts 2155
Profile Blog # 
I feel like each race has their own macro system like warp gate mechanics (hence why protoss is generally lower in SQ) Do you feel like there should be 3 different equations for the 3 races?
FlatLine.776 | Grandmasters Protoss Stream: http://twitch.tv/FlatLineSC2 | Follow @ http://twitter.com/FlatLineSC2 | Subscribe @ http://youtube.com/FlatLineSC2 | ♥♫ ..:: d[^_^]b ::.. ♫♥
Old Post

  Techno   November 12 2011 04:46. Posts 1900Profile # 
Excellent post. I was suprised by the racial differences in workers created (Z>T>P) and in spending(T>Z>P). They arent *exactly* what you'd expect.
Hell, its awesome to LOSE to nukes!
Old Post

 
 Glycerine   United States. November 12 2011 04:53. Posts 7
Profile # 
Wow simply stunning, great post
916
Old Post

 
 Solirinn   Belgium. November 21 2011 09:03. Posts 2
Profile # 
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.

[image loading]

The main sheet where you can add games or switch between your races.

[image loading]

Your 'Equivalent League' distribution (also according to results or matchups).

[image loading]

More detailed graph of your 'Equivalent League' distribution

[image loading]

My favourite graph; shows your SQ's and their corresponding Income.

[image loading]

Same graph as the previous one, but this time the SQ's are coloured according to the matchup instead of the result.

[image loading]

Cumulative Average SQ (based on result)

[image loading]

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.


 
Old Post

 
 Crashburn   United States. November 23 2011 21:46. Posts 474
Profile Blog # 

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.
Old Post

 
 Nyast   Belgium. November 23 2011 22:48. Posts 501
Profile # 
Wow, that's nice, thanks Solirinn.
Old Post

 
 Akhee   Brazil. November 26 2011 05:10. Posts 805
Profile # 
edit: blablabla was messing up ".", thank you solirinn
Last edit: 2011-11-26 05:28:07
 
Old Post

 
 gavinashun   November 26 2011 10:01. Posts 101
Profile # 
Hi whatthefat

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!
Old Post

Prev 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 Next
Please log in or register to reply.
 
Refresh
 Calendar - June 
Th Fr Sa Su Mo Tu We
20212223242526
FEATURED ON AIR:
Wiki
[OSL] RO32 Group C&D
Stream: GOMTV
Stream: OnGameNet
Upcoming events:  [ More ]
1h 43m[HSC VII] Day 1
2h 43mASL Ro64
2h 43m[DSL] iG vs LGD.int
2h 43m[SRT] Ro16 Group A
6h 43m[D2L] Na'Vi vs. EG
6h 43m[EMS One] Group B
7h 43mAdroits #RC #3
7h 43mGo4SC2 #293
9h 43m[D2L] mouz vs. Na'Vi
10h 43m[LoL] NA LCS Summe…
10h 43mCTL ReDeYe & Natha…
12h 43m[WCS AM] Group E CL
12h 43m[D2L] Na'Vi vs. TL
13h 43m[URTL] Denial vs…
15h 43m[URTL] FXO.NA vs Op
16h 43mRules of Engagement
23h 53m[GSTL] Ax-Acer vs.…
1d 1h[HSC VII] Day 2
1d 7hXilence Cup 8
1d 10h[LoL] NA LCS Summe…
1d 12h[WCS AM] Group D
1d 17h[SPL] STX vs. WJS
1d 18hVengeance Cup Qual…
1d 18h[GSTL] AZUBU vs. FXO
1d 20h[SPL] CJ vs. SKT
1d 23hMST#07
2 daysWyN Master CUP
2 days[HSC VII] Day 3
2 daysAdroits RC #4
2 daysDenver June HOTS T…
2 daysSSRO #3
2 daysZOTAC NA #107
2 days[SPL] EG-TL vs. KHAN
2 days[SPL] KT vs. T8
2 days[AlienwareCup]Grou…
2 days[BW] Defiler Tour…
3 days[HSC VII] Day 4
3 daysGo4SC2 Sun €150
3 daysZOTAC EU #162
3 days[SPL] STX vs. CJ
3 days[SPL] WJS vs. SKT
4 days[AlienwareCup]Grou…
4 days[SPL] EG-TL vs. KT
4 days[OSL] RO32 Group E&F
5 days[AlienwareCup]Grou…
5 days[WCS EU] RO32 Grou…
5 days[AlienwareCup]Grou…
6 days[WCS EU] RO32 Grou…
6 days[OSL] RO32 Group G&H
Refresh
StarCraft: Brood War
snipealot2
bizzyT
StarCraft 2
coLTheStC
MillForGG
KawaiiRice
SjoW
HappyZerGling
ProTech
Dota 2
AdmiralBulldog
Wagamama
Liquid`Korok
Liquid`ixmike88
Bdiz
Other Notable Streams
PainUser
[ Show 55 non-featured ]
StarCraft: Brood War
• rel
StarCraft 2
• TMiweedamins
• KingCobra90
• 1MaSsan
• EmpireTVorg.ZERG
• Bonkarooni
• shindigs
• Cress
• aScPraiise
• BateToshko
• BlysK
• BabyCrusher
• boesthius
• HolyLand
• Gormeroth
• prOxySC2
• SchautiSC2
• VaPox
• druidzHermeS
• Impactsc2
• Havok_jj
• ThePowerHour
• DaemonVirus
• OSL0rd
• pch0210
• AirmaX
• MagmuHittsu
• Mecto
• Jimmeh
Dota 2
• phone_microwave
• Strayfah
• ThePengwin
• D4RKCIDE
• equixR
• FlyingToilet
League of Legends
• Obsessed w LoL
• Modroocka
• Barrizle
• -dcLookAtThis-
• VegetaLOL
Diablo III
• LastBless
Other Games
• SK.Testie
• Zilea
• Cdxsc2
• rizeupgaming
• Khaiine
• TunK904
• Varyak
• starheroz2
• LFHaunt
• RenJ-69
• Warnipple
• Crusaders TV
• maRkySC2
• hugar

» Recent SC2 Results
» Premier SC2 Tournaments

1. Sen
2. Stephano
3. Socke
4. mOOnGLaDe
5. Nerchio
1. Life
2. Curious
3. RorO
4. Symbol
5. PartinG
Sidebar Settings...

The Little App Factory



The opinions expressed by our users do not reflect the official position of TeamLiquid.net or its staff.

Advertising | Jobs | Privacy | Terms Of Use | Contact Us

Original banner artwork: Jim Warren. Ad tag: TF_US.
The contents of this webpage are copyright © 2002-2013 Teamliquid.net. All Rights Reserved