• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 23:54
CEST 05:54
KST 12:54
  • 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
Tournament Spotlight: FEL Cracow 20253Power Rank - Esports World Cup 202576RSL Season 1 - Final Week9[ASL19] Finals Recap: Standing Tall15HomeStory Cup 27 - Info & Preview18
Community News
Google Play ASL (Season 20) Announced18BSL Team Wars - Bonyth, Dewalt, Hawk & Sziky teams10Weekly Cups (July 14-20): Final Check-up0Esports World Cup 2025 - Brackets Revealed19Weekly Cups (July 7-13): Classic continues to roll8
StarCraft 2
General
Tournament Spotlight: FEL Cracow 2025 ETH RECOVERY EXPERT \\ TECHY FORCE CYBER RETRIEVAL #1: Maru - Greatest Players of All Time Power Rank - Esports World Cup 2025 What tournaments are world championships?
Tourneys
Esports World Cup 2025 $25,000 Streamerzone StarCraft Pro Series announced $5,000 WardiTV Summer Championship 2025 WardiTV Mondays FEL Cracov 2025 (July 27) - $10,000 live event
Strategy
How did i lose this ZvP, whats the proper response
Custom Maps
External Content
Mutation #239 Bad Weather Mutation # 483 Kill Bot Wars Mutation # 482 Wheel of Misfortune Mutation # 481 Fear and Lava
Brood War
General
Google Play ASL (Season 20) Announced BGH Auto Balance -> http://bghmmr.eu/ BW General Discussion Flash Announces (and Retracts) Hiatus From ASL Dewalt's Show Matches in China
Tourneys
[Megathread] Daily Proleagues [BSL20] Non-Korean Championship 4x BSL + 4x China CSL Xiamen International Invitational [CSLPRO] It's CSLAN Season! - Last Chance
Strategy
Simple Questions, Simple Answers [G] Mineral Boosting Does 1 second matter in StarCraft?
Other Games
General Games
Nintendo Switch Thread Stormgate/Frost Giant Megathread Total Annihilation Server - TAForever [MMORPG] Tree of Savior (Successor of Ragnarok) Path of Exile
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
UK Politics Mega-thread US Politics Mega-thread Stop Killing Games - European Citizens Initiative Things Aren’t Peaceful in Palestine Russo-Ukrainian War Thread
Fan Clubs
INnoVation Fan Club SKT1 Classic Fan Club!
Media & Entertainment
[\m/] Heavy Metal Thread Anime Discussion Thread Movie Discussion! [Manga] One Piece Korean Music Discussion
Sports
2024 - 2025 Football Thread Formula 1 Discussion TeamLiquid Health and Fitness Initiative For 2023 NBA General Discussion
World Cup 2022
Tech Support
Installation of Windows 10 suck at "just a moment" Computer Build, Upgrade & Buying Resource Thread
TL Community
TeamLiquid Team Shirt On Sale 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
Eight Anniversary as a TL…
Mizenhauer
Customize Sidebar...

Website Feedback

Closed Threads



Active: 584 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
France12873 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
Next event in 5h 6m
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
WinterStarcraft529
Nina 243
RuFF_SC2 197
StarCraft: Brood War
Sea 4887
Stork 143
NaDa 95
Larva 79
Sharp 73
Sexy 65
sSak 59
Dota 2
LuMiX2
League of Legends
JimRising 794
Heroes of the Storm
Khaldor154
Other Games
summit1g13198
tarik_tv10407
ViBE219
kaitlyn18
Organizations
Other Games
gamesdonequick1493
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 12 non-featured ]
StarCraft 2
• Hupsaiya 54
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
League of Legends
• Lourlo1017
Upcoming Events
FEL
5h 6m
BSL20 Non-Korean Champi…
10h 6m
BSL20 Non-Korean Champi…
14h 6m
Bonyth vs Zhanhun
Dewalt vs Mihu
Hawk vs Sziky
Sziky vs QiaoGege
Mihu vs Hawk
Zhanhun vs Dewalt
Fengzi vs Bonyth
Sparkling Tuna Cup
2 days
Online Event
2 days
uThermal 2v2 Circuit
3 days
The PondCast
4 days
Replay Cast
4 days
Korean StarCraft League
5 days
CranKy Ducklings
6 days
Liquipedia Results

Completed

CSLPRO Last Chance 2025
Esports World Cup 2025
Murky Cup #2

Ongoing

Copa Latinoamericana 4
Jiahua Invitational
BSL 20 Non-Korean Championship
BSL 20 Team Wars
FEL Cracov 2025
CC Div. A S7
Underdog Cup #2
IEM Cologne 2025
FISSURE Playground #1
BLAST.tv Austin Major 2025
ESL Impact League Season 7
IEM Dallas 2025
PGL Astana 2025
Asian Champions League '25

Upcoming

ASL Season 20: Qualifier #1
ASL Season 20: Qualifier #2
ASL Season 20
CSLPRO Chat StarLAN 3
BSL Season 21
RSL Revival: Season 2
Maestros of the Game
SEL Season 2 Championship
WardiTV Summer 2025
uThermal 2v2 Main Event
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
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.