• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EST 10:50
CET 16:50
KST 00:50
  • 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
[ASL22] Finals Preview: Sweet Victory!12[ASL22] Ro4 Preview: Mirror Mirror6[ASL22] Ro8 Preview: Within Reach5[ASL22] Ro8 Preview: In A Tizzy11[ASL22] Ro16 Preview: Holy Diver5
Community News
Dark completes military service, returns to SC28[BSL23] RO16 Group Stage19Weekly Cups (Nov 2-8): herO back on top?2Weekly Cups (Oct 26 - Nov 1): MaxPax, herO, Solar win0Weekly Cups (October 19-25): Clem triples first in 5.0.175
StarCraft 2
General
Greetings.. No more SC2 streamers on team liquid? Dark completes military service, returns to SC2 Serral's getting trashed by New Catsle's Mind Weekly Cups (Nov 2-8): herO back on top?
Tourneys
Sea Duckling Open (Global, Bronze-Diamond) Dark returns! GSL CK #7 4v4 Team Battle (Nov 19) soO & FanTaSy return! SC2 Kevin Scrim 4v4 (Nov 16) RSL goes to London! 2026 Offline Finals Nov 21-22 Tasteless Time Warp: SC Evo Showmatch (May 25)
Strategy
[H] ZvP Mid-Late Game: Stalkers Collossi HT
Custom Maps
[G] How to playtest arcade maps Starcraft 2 Advance [D] the control group Simple Questions/Answers
External Content
The PondCast: SC2 News & Results Mutation # 551 Robotic Revival Mutation # 550 Graveyard Shift Mutation # 549 Endless Sparkles
Brood War
General
List of top players active on ShieldBattery BW General Discussion Recommended BW Settings for Mouse and Video Starcraft:Brood War Discord Servers [BSL23] RO16 Group Stage
Tourneys
[$1250] International ShieldBattery League Bisu's Team vs Shuttle's Team 2026-11-14 2v2v2v2 Tournament Stage 1: Community Poll [BSL23] Ro16 Group C - Sunday 21:00 CET
Strategy
Pluto's TvP 5Marine 2Medic Push Simple Questions, Simple Answers Infested Terran strategies in 2026 Nuke strategy worked in K-League 2026-11-09
Other Games
General Games
Stormgate/Frost Giant Megathread Nintendo Switch Thread Free Space RTS Game, optimised f. Phone/Tablet etc List of Game Threads The PlayStation 5
Dota 2
League of Legends
[TL LoL EUW IHs] Teemo shall perish
Heroes of the Storm
Heroes of the Storm 2.0
Hearthstone
Deck construction bug
TL Mafia
TL Mafia Community Thread
Community
General
US Politics Mega-thread Artificial Intelligence Thread Trading/Investing Thread European Politico-economics QA Mega-thread Russo-Ukrainian War Thread
Fan Clubs
Fan Club Resource Thread Reynor Fan Club The Flash Fan Club
Media & Entertainment
Movie Discussion! Anime Discussion Thread [Manga] One Piece
Sports
TeamLiquid Health and Fitness Initiative For 2023 Football (Soccer) Thread MLB/Baseball 2023
World Cup 2022
Tech Support
Computer Build, Upgrade & Buying Resource Thread
TL Community
The Automated Ban List Recent Gifted Posts
Blogs
The time I organised my…
AssyrianKing
Why I built Repalyzer (1.1.…
BlueStar
Innovate or Game Over?
TrAiDoS
ShieldBattery on Mac
Kraekkling
Can Bots Beat Pros?? Starcr…
namkraft
Customize Sidebar...

Website Feedback

Closed Threads



Active: 10450 users

Do you macro like a pro? - Page 10

Forum Index > SC2 General
Post a Reply
Prev 1 8 9 10 11 12 63 Next
Xaeldaren
Profile Joined June 2010
Ireland588 Posts
September 16 2011 17:43 GMT
#181
On September 17 2011 02:41 TheLight wrote:
Show nested quote +
On September 17 2011 02:34 Xaeldaren wrote:
I'd love to calculate my SQ but I'm completely illiterate when it comes to Excel...I'm even using the 2000 version. Could anyone give me a hand and tell me how to go about it?


Here's a Excel 2000 template: http://www.mediafire.com/?h1cd1f2kdj16p6f

Just put in your numbers and it'll do the rest for you.


Thank you so much!
byanymeans
Profile Joined June 2011
United States27 Posts
September 16 2011 17:43 GMT
#182
wow i have to give a big props for the hard work you put in running these regressions haha


I really thing making the chart with the sq of various top players would be interesting
Laugh and the world laughs with you. Weep and you weep alone"-ella wilcox
ReAson75
Profile Blog Joined August 2010
United States130 Posts
September 16 2011 17:43 GMT
#183
This is an incredible post! You put in an amazing effort that yielded very interesting results. I look forward to seeing how these results are used to compare regional ladders in the future!
OneBk
Profile Joined February 2010
Sweden157 Posts
September 16 2011 17:44 GMT
#184
Omg... this is a nice analys. damn it, idont have excel. what can i use instead of Excel to calculate my SQ?
Bobbias
Profile Blog Joined March 2008
Canada1373 Posts
September 16 2011 17:44 GMT
#185
Wow, I'm absolutely amazed that you've actually found a somewhat useful way to track your macro progress. I may actually have to do this myself and start tracking my progress. The next thing we need to do is get someone to use the SC2gears plugin API to create a plugin for calculating your SQ.
Wuster
Profile Joined May 2011
1974 Posts
September 16 2011 17:45 GMT
#186
On September 17 2011 02:13 MrBarryObama wrote:
What surprised me the most was that protoss creates the least workers on average! I assumed it would be terran, since they have mules and protoss have chrono boost. Could it be that protoss expands the least, on average? Or that typically protoss loses the fewest probes?


I was wondering about this as well. My first thought was it must be counting Mules, but by the time the first mule is out, Protoss should have a worker lead unless they're chrono-ing tech/units.

The divergence appears to start at the 5-6 minute mark. It's possible for Terran to start the FE by then, but is it possible for the Terran to actually build from it to explain the difference? I know PvP is also the matchup with the latest expansion timing, so that could be dragging down Protoss as well?

Also, I wonder if this is being skewed by 4-gate, since you stop at 20 or so probes which is really early. Other than the 11/11, Terran openings/all-ins don't involve cutting workers do they (they super delay the expansion or pull workers to junk your economy)?
andycz
Profile Joined September 2011
288 Posts
September 16 2011 17:45 GMT
#187
This is so goddamn awesome, thanks!
Always looking for practice partners. EU: andy.1535
MapleLeafSirup
Profile Joined July 2009
Germany950 Posts
September 16 2011 17:46 GMT
#188
Is there a way to find out the data without having to watch every single replay until the end?
CScythe
Profile Joined June 2009
Canada810 Posts
September 16 2011 17:47 GMT
#189
Excellent post.
Ammoth
Profile Joined August 2011
Sweden391 Posts
Last Edited: 2011-09-16 17:49:26
September 16 2011 17:47 GMT
#190
I just put the SQ formula in excel and its quite funny to compare something like this. Seems my SQ as Protoss is around 70 and I'm in silver, had a very small amount of data, only put in like 5 games or so.

And as Terran its between 50-60. Maybe I should have stayed Protoss ^^^

Anyway great job by OP. Really interesting stuff. Someone awesome should make a kickass spreadsheet!

Nvm, seems the awesome people are faster than me as well! GJ on spreadsheet!
NmE_
Profile Joined December 2010
United States87 Posts
September 16 2011 17:49 GMT
#191
I am going to go print these graphs out and hang them in my bedroom. BEAUTIFUL!!!
Anachromy
Profile Blog Joined September 2010
United States194 Posts
September 16 2011 17:50 GMT
#192
Just Calculated my own SQ, took my last 10 ladder games (both wins, and losses) and got an SQ or 67.8, not too shabby for a Platinum League player I suppose
Demonhunter04
Profile Joined July 2011
1530 Posts
September 16 2011 17:50 GMT
#193
Great post, but you did not account for if a player maxes out quickly and then wins without losing significant portions of it, which would cause average unspent resources to skyrocket, and you also did not account for workers lost - losing workers is a big reason why players in higher leagues would need to make more.
"If you don't drop sweat today, you will drop tears tomorrow" - SlayerSMMA
OneBk
Profile Joined February 2010
Sweden157 Posts
September 16 2011 17:51 GMT
#194
On September 17 2011 02:41 Impervious wrote:
Wow. Awesome stuff!

Show nested quote +
On September 17 2011 01:52 Ihsahn wrote:
Is there any way this index could be integrated into sc2gears? I think that could help a lot!

Seriously, this is a good idea.


We should contact the wizzard of sc2gears!^^
Eurytos
Profile Joined August 2010
Singapore97 Posts
September 16 2011 17:51 GMT
#195
I'm truly impressed by the level of detail put in to this post. It explains clearly how the macro difference in terms of descending leagues. Good job!

I do have a question though for the SQ(spending quotient) part. As a fellow academician doing a physics degree with experience in modelling. What are the constraints of your SQ formula. Also, could you explain further on the derivation of it? My guess is that the SQ formula is an empirical formula based on the existing data that you had in hand. If that is the case, my suggestion is to collect a different set of data and compare whether the distribution fits the formula or not.

Once again, thank you for this truly educational post!!
alepov
Profile Joined December 2010
Netherlands1132 Posts
Last Edited: 2011-09-16 17:58:29
September 16 2011 17:52 GMT
#196
sickest post i've ever read here.

are you a wizard?
ლ(ಠ益ಠლ)
LittLeD
Profile Joined May 2010
Sweden7973 Posts
September 16 2011 17:52 GMT
#197
That was...an amazingly interesting read O-o. Truly eye-opening.

I applaud you, best sir.
☆Grubby ☆| Tod|DeMusliM|ThorZaiN|SaSe|Moon|Mana| ☆HerO ☆
Verator
Profile Joined June 2010
United States283 Posts
September 16 2011 17:52 GMT
#198
You can get far more accurate measures using sc2gears and piles of replays. (mlg, the dozens of replay sites around, etc.)

The way data is calculated, the length of masters/ GM games and the time spent maxed on army values would skew the results lower than the actual, and comparative difference in usage of macro mechanics also would stratify the leagues far more. Additionally, 100 games per league is far too few to really encompass a proper range, the likelihood of having a predominant trend in games or matchups is far too likely. (Ex. 2/3 of the protoss replays could easily be PvP.)

The idea is good though, and props on putting in the effort! Though, I can't help but feel a lot of the time spent doing this could be reduces or automated to be more accurate.
So far as I can remember, there is not one word in the Gospels in praise of intelligence. -- Bertrand Russell
Xaeldaren
Profile Joined June 2010
Ireland588 Posts
September 16 2011 17:52 GMT
#199
This doesn't seem right, since I'm a gold player and after inputting 20 games my average comes in at 71, which I presume is pretty good?
Aando
Profile Joined August 2011
1304 Posts
September 16 2011 17:53 GMT
#200
Tried out that SQ-thing as a gold zerg over 10 games:
SQ_avg = 57
SQ_max = 85
SQ_min = 37.

So if I'd take the SQ to it's edge one could say that at my best I macro like a GM and at my worst I macro like a bronzer! xD
Prev 1 8 9 10 11 12 63 Next
Please log in or register to reply.
Live Events Refresh
WardiTV Invitational
21:00
WardiTV Not-Summer Championshi
MaxPax vs Solar
herO vs TBD
Lambo vs TBD
Rogue vs TBD
WardiTV1135
IntoTheiNu 854
ComeBackTV 788
TaKeTV 389
IndyStarCraft 270
Rex115
Liquipedia
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
IndyStarCraft 270
Rex 115
StarCraft: Brood War
Britney 61491
Calm 5182
Rain 1659
Jaedong 1595
EffOrt 761
BeSt 678
FanTaSy 435
Rush 376
Larva 337
Shuttle 321
[ Show more ]
Hyun 194
ZerO 179
Dewaltoss 115
Mind 101
Last 80
Sharp 73
Sea.KH 69
sorry 46
Mong 39
Pusan 35
ToSsGirL 33
JYJ 31
Killer 28
hero 26
Terrorterran 23
Hm[arnc] 19
Movie 17
Aegong 15
Sacsri 14
Free 13
Rock 10
910 10
soO 10
ajuk12(nOOB) 9
Shine 9
LuMiX 2
Dota 2
qojqva2416
canceldota100
Counter-Strike
edward109
Heroes of the Storm
Khaldor382
MindelVK8
Other Games
FrodaN3795
singsing2214
Beastyqt513
byalli419
Lowko393
B2W.Neo389
KnowMe258
mouzStarbuck253
syndereN175
XaKoH 140
ToD111
DeMusliM98
ZerO(Twitch)25
Railgan11
ROOTIllusion10
CosmosSc2 9
fpsfer 1
Organizations
Other Games
EGCTV883
[ Show 15 non-featured ]
StarCraft 2
• Hinosc 43
• poizon28 19
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• Migwel
StarCraft: Brood War
• Azhi_Dahaki33
• ChaeLyn 8
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
Dota 2
• WagamamaTV723
League of Legends
• Jankos2676
Other Games
• Shiphtur2
Upcoming Events
IPSL
1h 10m
TerrOr vs IJ_Terran
rasowy vs Hazorath
BSL
4h 10m
TerrOr vs OyAji
UltrA vs Gosudark
Sparkling Tuna Cup
18h 10m
WardiTV Invitational
20h 10m
IPSL
1d 1h
Art_Of_Turtle vs KameZerg
Radley vs George
BSL
1d 4h
Artosis vs Dewalt
Ret vs Tech
SOOP
1d 18h
soO vs FanTaSy
WardiTV Weekly
1d 20h
Monday Night Weeklies
3 days
PiGosaur Cup
3 days
[ Show More ]
The PondCast
3 days
GSL
4 days
Replay Cast
5 days
KCM Race Survival
5 days
RSL Revival
6 days
Liquipedia Results

Completed

Proleague 2026-11-12
Blizzard Classic Cup 2026
HCC Season 3

Ongoing

Acropolis #5
KCM Race Survival 2026 Season 4
International ShieldBattery League
Individual League
BSL Season 23
IPSL Winter 2026-27
Calamity Cup Div. A Season 8
Underdog Cup 2026 Div 2-3
BLAST Rivals Fall 2026
IEM Beijing 2026
PGL Masters Bucharest 2026
Stake Ranked Episode 5
1win Private Club #2
Thunderpick World Champ. '26
ESL Pro League Season 24
Stake Ranked Episode 4
1win Private Club #1
Logitech G Play Connect 2026
SL StarSeries Fall 2026
FISSURE Playground #3
BLAST Open Fall 2026

Upcoming

YSL S4
Sector 591
SC4ALL II: Brood War
BSL 23: Non-Korean Championship
HSC XXX
Stellar Fest 2: Lunar Cup
StarCraft2 Weekly Open Tournament 2026 Grand Finals
SC4ALL II: StarCraft II
Kung Fu Cup 2026 Grand Finals
RSL Offline Finals
IEM Kraków 2027
PGL Bucharest 2027
BLAST Bounty Winter 2027
PGL Major Singapore 2026
Stake Ranked Episode 6
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 © 2026 TLnet. All Rights Reserved.