• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 14:12
CEST 20:12
KST 03:12
  • 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
Power Rank - Esports World Cup 202529RSL Season 1 - Final Week8[ASL19] Finals Recap: Standing Tall15HomeStory Cup 27 - Info & Preview18Classic wins Code S Season 2 (2025)16
Community News
Weekly Cups (July 14-20): Final Check-up0Esports World Cup 2025 - Brackets Revealed19Weekly Cups (July 7-13): Classic continues to roll8Team TLMC #5 - Submission re-extension4Firefly given lifetime ban by ESIC following match-fixing investigation17
StarCraft 2
General
The GOAT ranking of GOAT rankings Power Rank - Esports World Cup 2025 RSL Revival patreon money discussion thread Esports World Cup 2025 - Final Player Roster Why doesnt SC2 scene costream tournaments
Tourneys
Esports World Cup 2025 Sparkling Tuna Cup - Weekly Open Tournament Sea Duckling Open (Global, Bronze-Diamond) FEL Cracov 2025 (July 27) - $8000 live event RSL: Revival, a new crowdfunded tournament series
Strategy
How did i lose this ZvP, whats the proper response
Custom Maps
External Content
Mutation # 483 Kill Bot Wars Mutation # 482 Wheel of Misfortune Mutation # 481 Fear and Lava Mutation # 480 Moths to the Flame
Brood War
General
BW General Discussion Flash Announces (and Retracts) Hiatus From ASL BGH Auto Balance -> http://bghmmr.eu/ Corsair Pursuit Micro? Pro gamer house photos
Tourneys
[Megathread] Daily Proleagues [BSL 2v2] ProLeague Season 3 - Friday 21:00 CET The Casual Games of the Week Thread BWCL Season 63 Announcement
Strategy
Simple Questions, Simple Answers I am doing this better than progamers do.
Other Games
General Games
Nintendo Switch Thread Stormgate/Frost Giant Megathread [MMORPG] Tree of Savior (Successor of Ragnarok) Path of Exile CCLP - Command & Conquer League Project
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
Heroes of StarCraft mini-set
TL Mafia
TL Mafia Community Thread Vanilla Mini Mafia
Community
General
US Politics Mega-thread Things Aren’t Peaceful in Palestine Russo-Ukrainian War Thread The Games Industry And ATVI Stop Killing Games - European Citizens Initiative
Fan Clubs
SKT1 Classic Fan Club! Maru Fan Club
Media & Entertainment
Anime Discussion Thread Movie Discussion! [Manga] One Piece Korean Music Discussion [\m/] Heavy Metal Thread
Sports
2024 - 2025 Football Thread Formula 1 Discussion TeamLiquid Health and Fitness Initiative For 2023 NBA General Discussion
World Cup 2022
Tech Support
Computer Build, Upgrade & Buying Resource Thread
TL Community
The Automated Ban List
Blogs
Ping To Win? Pings And Their…
TrAiDoS
momentary artworks from des…
tankgirl
from making sc maps to makin…
Husyelt
StarCraft improvement
iopq
Socialism Anyone?
GreenHorizons
Customize Sidebar...

Website Feedback

Closed Threads



Active: 922 users

Do you macro like a pro? - Page 52

Forum Index > SC2 General
Post a Reply
Prev 1 50 51 52 53 54 63 Next
XerrolAvengerII
Profile Joined January 2010
United States510 Posts
November 02 2011 21:40 GMT
#1021
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!?...
HughJorgen
Profile Joined May 2010
Australia37 Posts
November 02 2011 23:04 GMT
#1022
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
Nemireck
Profile Joined October 2010
Canada1875 Posts
November 02 2011 23:16 GMT
#1023
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!
English
Profile Joined April 2010
United States475 Posts
November 02 2011 23:17 GMT
#1024
Wow, very cool.
Poopi
Profile Blog Joined November 2010
France12801 Posts
November 03 2011 12:51 GMT
#1025
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 .
WriterMaru
MtlGuitarist97
Profile Blog Joined July 2011
United States1539 Posts
November 03 2011 13:39 GMT
#1026
My average SQ over my last 5 games was a 76.4 for a High Diamond Terran on NA :D
MrCash
Profile Joined October 2011
United States1504 Posts
November 03 2011 21:07 GMT
#1027
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.
sAsThark
Profile Joined September 2011
France27 Posts
Last Edited: 2011-11-05 02:02:03
November 05 2011 02:01 GMT
#1028
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
http://fedoraproject.org/
LetoAtreides82
Profile Joined January 2011
United States1188 Posts
November 06 2011 00:11 GMT
#1029
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
Iksf
Profile Joined March 2011
United Kingdom444 Posts
November 06 2011 02:46 GMT
#1030
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
Profile Blog Joined September 2010
163 Posts
November 06 2011 06:05 GMT
#1031
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
Profile Joined September 2011
France27 Posts
Last Edited: 2011-11-06 16:38:20
November 06 2011 16:18 GMT
#1032
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..
http://fedoraproject.org/
.kv
Profile Blog Joined August 2010
United States2332 Posts
November 11 2011 19:35 GMT
#1033
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?
Techno
Profile Joined June 2010
1900 Posts
November 11 2011 19:46 GMT
#1034
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!
Glycerine
Profile Joined July 2005
United States10 Posts
November 11 2011 19:53 GMT
#1035
Wow simply stunning, great post
916
Solirinn
Profile Joined November 2011
Belgium2 Posts
November 21 2011 00:03 GMT
#1036
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.


Crashburn
Profile Blog Joined October 2010
United States476 Posts
November 23 2011 12:46 GMT
#1037
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
Profile Joined November 2010
Belgium554 Posts
November 23 2011 13:48 GMT
#1038
Wow, that's nice, thanks Solirinn.
Akhee
Profile Joined January 2011
Brazil811 Posts
Last Edited: 2011-11-25 20:28:07
November 25 2011 20:10 GMT
#1039
edit: blablabla was messing up ".", thank you solirinn
gavinashun
Profile Joined October 2010
101 Posts
November 26 2011 01:01 GMT
#1040
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!
Prev 1 50 51 52 53 54 63 Next
Please log in or register to reply.
Live Events Refresh
Esports World Cup
10:00
2025 - Day 1
EWC_Arena7289
ComeBackTV 2310
TaKeTV 689
Hui .423
3DClanTV 352
CranKy Ducklings226
Berry_CruncH214
EnkiAlexander 213
UpATreeSC208
mcanning189
Rex169
Reynor152
davetesta19
Liquipedia
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
EWC_Arena7289
Hui .423
UpATreeSC 208
mcanning 189
Rex 169
Reynor 152
StarCraft: Brood War
Barracks 901
Mini 671
Larva 599
EffOrt 477
Stork 222
Aegong 62
scan(afreeca) 30
PianO 27
soO 22
Sharp 13
[ Show more ]
Movie 11
JulyZerg 8
League of Legends
Dendi1207
Counter-Strike
fl0m2120
oskar232
byalli229
Heroes of the Storm
Khaldor371
XaKoH 139
Liquid`Hasu85
Other Games
ceh92449
singsing1883
FrodaN417
Trikslyr53
Organizations
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 20 non-featured ]
StarCraft 2
• LUISG 5
• Kozan
• sooper7s
• Migwel
• AfreecaTV YouTube
• LaughNgamezSOOP
• intothetv
• IndyKCrew
StarCraft: Brood War
• Michael_bg 8
• FirePhoenix4
• STPLYoutube
• ZZZeroYoutube
• BSLYoutube
Dota 2
• C_a_k_e 3116
• masondota21103
• WagamamaTV467
League of Legends
• Nemesis4709
• TFBlade945
Other Games
• imaqtpie1036
• Shiphtur408
Upcoming Events
Esports World Cup
15h 48m
ByuN vs Zoun
SHIN vs TriGGeR
Cyan vs ShoWTimE
Rogue vs HeRoMaRinE
Clem vs Solar
Reynor vs Maru
herO vs Cure
Serral vs Classic
Esports World Cup
1d 15h
Esports World Cup
2 days
CranKy Ducklings
3 days
BSL20 Non-Korean Champi…
3 days
CSO Cup
3 days
BSL20 Non-Korean Champi…
3 days
Bonyth vs Sziky
Dewalt vs Hawk
Hawk vs QiaoGege
Sziky vs Dewalt
Mihu vs Bonyth
Zhanhun vs QiaoGege
QiaoGege vs Fengzi
FEL
4 days
BSL20 Non-Korean Champi…
4 days
BSL20 Non-Korean Champi…
4 days
Bonyth vs Zhanhun
Dewalt vs Mihu
Hawk vs Sziky
Sziky vs QiaoGege
Mihu vs Hawk
Zhanhun vs Dewalt
Fengzi vs Bonyth
[ Show More ]
Sparkling Tuna Cup
6 days
Online Event
6 days
Liquipedia Results

Completed

CSL Xiamen Invitational
Championship of Russia 2025
Murky Cup #2

Ongoing

Copa Latinoamericana 4
Jiahua Invitational
BSL20 Non-Korean Championship
Esports World Cup 2025
CC Div. A S7
Underdog Cup #2
FISSURE Playground #1
BLAST.tv Austin Major 2025
ESL Impact League Season 7
IEM Dallas 2025
PGL Astana 2025
Asian Champions League '25

Upcoming

CSLPRO Last Chance 2025
CSLPRO Chat StarLAN 3
BSL Season 21
RSL Revival: Season 2
SEL Season 2 Championship
uThermal 2v2 Main Event
FEL Cracov 2025
HCC Europe
ESL Pro League S22
StarSeries Fall 2025
FISSURE Playground #2
BLAST Open Fall 2025
BLAST Open Fall Qual
Esports World Cup 2025
BLAST Bounty Fall 2025
BLAST Bounty Fall Qual
IEM Cologne 2025
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 © 2025 TLnet. All Rights Reserved.