• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 12:17
CEST 18:17
KST 01:17
  • 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 20258Power Rank - Esports World Cup 202577RSL Season 1 - Final Week9[ASL19] Finals Recap: Standing Tall15HomeStory Cup 27 - Info & Preview18
Community News
Google Play ASL (Season 20) Announced24BSL 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
#1: Maru - Greatest Players of All Time Tournament Spotlight: FEL Cracow 2025 Power Rank - Esports World Cup 2025 I offer completely free coaching services What tournaments are world championships?
Tourneys
FEL Cracov 2025 (July 27) - $10,000 live event Esports World Cup 2025 $25,000 Streamerzone StarCraft Pro Series announced $5,000 WardiTV Summer Championship 2025 WardiTV Mondays
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 [Update] ShieldBattery: 2025 Redesign Dewalt's Show Matches in China BGH Auto Balance -> http://bghmmr.eu/ BW General Discussion
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
Stormgate/Frost Giant Megathread Nintendo Switch Thread 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
US Politics Mega-thread UK 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
Anime Discussion Thread [\m/] Heavy Metal Thread Movie Discussion! [Manga] One Piece Korean Music Discussion
Sports
Formula 1 Discussion 2024 - 2025 Football Thread 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: 778 users

Zerg Production Calculator [Excel Sheet]

Forum Index > SC2 General
Post a Reply
Cheree
Profile Joined January 2010
Canada123 Posts
Last Edited: 2010-03-22 01:52:43
March 22 2010 00:02 GMT
#1
I made this excel sheet that helps zerg players with their production. Maybe it can be of use to you.

Some examples of questions it can answer:
Q: I want to mass lings, what's the minimum economy I need?
A: With the production capacity of 6.5 units off of one base with queen, you need 12 drones mining to stream zerglings indefinitely and utilizing all your larva.

Q: I have an economy of 12 drones on gas and 32 on minerals, what can I afford?
A: There's a lot of combinations of units, for example you can do: 12 roaches every 40s, or 6 hydras and 6 pairs of zerglings every 40s..

Just remember your limiting factors.. Is it gas? Is it minerals? Is it production? Is it food?

The figures for minerals and gas per second per worker are from my own tests, feel free to change them if you have more accurate figures.

download link (excel 2007)

download link (excel 97-2003)


How to use
Step 1: Change the puke-orange-colored cells to any value to simulate your economy or purchases.
Step 2: /profit

I guess the plus side of not having the beta is I have time to devote to simulate some aspects of the game. XD Feel free to expand/use this sheet or point out any inaccuracies.

*wants beta*
Saracen
Profile Blog Joined December 2007
United States5139 Posts
Last Edited: 2010-03-22 00:23:41
March 22 2010 00:15 GMT
#2
Very cool. I see this being very useful for build orders once it's perfected. You might want to change baneling/broodlord cost to account for zergling/corruptor cost.

EDIT: To clarify, for a typical 2 base 4 gas zerg, you put in 32 under # of drones/patch saturation 2 and 12 under # of drones/gas saturation 3, right? By the way, where did you get your income rate numbers from?

EDIT 2: "The Larva is the base unit for Zerg. It spawns automatically from the Hatchery, Lair, or Hive every 15 seconds." Which makes 2.67larvae/40s, not 2.5/40
Rodiel
Profile Joined August 2006
France573 Posts
March 22 2010 00:17 GMT
#3
thx u !
Nuxar
Profile Joined February 2009
Canada212 Posts
March 22 2010 00:36 GMT
#4
I just dont get what we are suppose to do when we download...

Where is the excel sheet?
Cheree
Profile Joined January 2010
Canada123 Posts
Last Edited: 2010-03-22 00:52:46
March 22 2010 00:45 GMT
#5
On March 22 2010 09:15 Saracen wrote:
Very cool. I see this being very useful for build orders once it's perfected. You might want to change baneling/broodlord cost to account for zergling/corruptor cost.

EDIT: To clarify, for a typical 2 base 4 gas zerg, you put in 32 under # of drones/patch saturation 2 and 12 under # of drones/gas saturation 3, right? By the way, where did you get your income rate numbers from?

EDIT 2: "The Larva is the base unit for Zerg. It spawns automatically from the Hatchery, Lair, or Hive every 15 seconds." Which makes 2.67larvae/40s, not 2.5/40

Thanks! I think I'm going to keep the baneling/broodlord cost as is cause if I do change it, the simulation loses support for morphing existing units.

About Edit 1: Yes, that's right. I calculated the the income rates myself over a few minutes for each patch saturation. The only one I didn't do a test for is 1 drone / gas. I just used the same figure for 2 drones / gas. The measures were taken once everything was flowing nicely, it does not include the begining split where the ai tries to find free patches. The 3 per patch figure includes the mess the ai makes to keep looking for free patches when there aren't any.

About Edit 2: Ah, I thought it was every 16 seconds. Where did you get that info from? I'll change that after a preponderance of the evidence! :p [My Edit: K, found some support for that, changing!]
*wants beta*
Cheree
Profile Joined January 2010
Canada123 Posts
Last Edited: 2010-03-22 00:50:00
March 22 2010 00:46 GMT
#6
On March 22 2010 09:36 Zergling4life wrote:
I just dont get what we are suppose to do when we download...

Where is the excel sheet?

Save Target As: download link

Also, it's in Excel 2007 btw.
*wants beta*
16dots
Profile Joined March 2010
United States9 Posts
Last Edited: 2010-03-22 01:37:03
March 22 2010 01:36 GMT
#7
Be careful when downloading with Google Chrome, it'll save the file as a zip.

Try use IE or FF or maybe get a download manager like thunder.
Sup Dawg
Acies
Profile Joined September 2009
Australia196 Posts
March 22 2010 01:41 GMT
#8
I'm getting an error509 in most of the cells. I'm using openoffice if that makes a difference.
AvalancheGaming.org - SC2 Tournament and LAN in Bunbury, Western Australia
Cheree
Profile Joined January 2010
Canada123 Posts
Last Edited: 2010-03-22 01:51:23
March 22 2010 01:50 GMT
#9
On March 22 2010 10:41 Acies wrote:
I'm getting an error509 in most of the cells. I'm using openoffice if that makes a difference.

I'm not sure what I need to convert it to, but here's a shot at Excel 97-2003: link 97-2003 compatible

I might have to actually code a site. XD
*wants beta*
Acies
Profile Joined September 2009
Australia196 Posts
March 22 2010 01:55 GMT
#10
On March 22 2010 10:50 Cheree wrote:
Show nested quote +
On March 22 2010 10:41 Acies wrote:
I'm getting an error509 in most of the cells. I'm using openoffice if that makes a difference.

I'm not sure what I need to convert it to, but here's a shot at Excel 97-2003: link 97-2003 compatible

I might have to actually code a site. XD

That worked, cheers.
AvalancheGaming.org - SC2 Tournament and LAN in Bunbury, Western Australia
StayFrosty
Profile Joined February 2010
Canada743 Posts
March 22 2010 04:33 GMT
#11
Very cool and definitely appreciate the time put into this, thanks!
def0
Profile Joined February 2010
China13 Posts
March 22 2010 05:40 GMT
#12
Thanks a lot!

Just one issue i don't understand: why the speed in patch saturation 1 (0.70) is lower than patch saturation 2 (0.71)?
Perseverance
Profile Joined February 2010
Japan2800 Posts
March 22 2010 07:40 GMT
#13
Thanks a lot for this, you are awesome!
<3 Moonbattles
georgir
Profile Joined May 2009
Bulgaria253 Posts
March 22 2010 08:10 GMT
#14
heared of google docs?
Cheree
Profile Joined January 2010
Canada123 Posts
Last Edited: 2010-03-22 11:32:05
March 22 2010 11:29 GMT
#15
On March 22 2010 14:40 def0 wrote:
Thanks a lot!

Just one issue i don't understand: why the speed in patch saturation 1 (0.70) is lower than patch saturation 2 (0.71)?

Yeah, doesn't make much sense to me either. I just used the exact values of the tests I ran, If I could time it to the millisecond, I suppose they should both be the same over a long enough period of time. Feel free to change it with more accurate values.
*wants beta*
Cheree
Profile Joined January 2010
Canada123 Posts
Last Edited: 2010-03-22 11:31:29
March 22 2010 11:30 GMT
#16
On March 22 2010 17:10 georgir wrote:
heared of google docs?

I tried it at first, wouldn't accept my formulas.

Maybe I /fail at google docs. *shrug*

Thanks all!
*wants beta*
Please log in or register to reply.
Live Events Refresh
BSL20 Non-Korean Champi…
14:00
Bracket Day 2 - Final
LiquipediaDiscussion
FEL
09:00
Cracow 2025
Clem vs SKillousLIVE!
Reynor vs Lambo
RotterdaM2684
ComeBackTV 2057
IndyStarCraft 635
WardiTV447
CranKy Ducklings217
Rex163
3DClanTV 139
LiquipediaDiscussion
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
RotterdaM 2684
IndyStarCraft 635
Rex 163
BRAT_OK 63
MindelVK 41
StarCraft: Brood War
Britney 38939
Barracks 1338
EffOrt 1236
Larva 955
Nal_rA 594
BeSt 547
Stork 489
firebathero 358
Shine 266
Rush 184
[ Show more ]
Soulkey 182
Dewaltoss 157
Hyun 97
Movie 95
sorry 63
Sharp 55
sSak 44
zelot 42
Shinee 34
Free 28
yabsab 18
Terrorterran 15
IntoTheRainbow 7
Dota 2
Gorgc6788
qojqva3862
420jenkins396
Counter-Strike
fl0m2969
Heroes of the Storm
Khaldor593
Liquid`Hasu188
Other Games
Beastyqt1738
Hui .351
Fuzer 179
KnowMe126
QueenE123
Organizations
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 17 non-featured ]
StarCraft 2
• HeavenSC 45
• StrangeGG 19
• Legendk 8
• Kozan
• Migwel
• AfreecaTV YouTube
• intothetv
• sooper7s
• IndyKCrew
• LaughNgamezSOOP
StarCraft: Brood War
• Azhi_Dahaki4
• STPLYoutube
• ZZZeroYoutube
• BSLYoutube
Dota 2
• WagamamaTV746
League of Legends
• Jankos1583
Counter-Strike
• Nemesis1738
Upcoming Events
BSL20 Non-Korean Champi…
1h 43m
Bonyth vs Zhanhun
Dewalt vs Mihu
Hawk vs Sziky
Sziky vs QiaoGege
Mihu vs Hawk
Zhanhun vs Dewalt
Fengzi vs Bonyth
Wardi Open
18h 43m
Sparkling Tuna Cup
1d 17h
WardiTV European League
1d 23h
Online Event
2 days
uThermal 2v2 Circuit
2 days
The PondCast
3 days
Replay Cast
4 days
Korean StarCraft League
5 days
CranKy Ducklings
5 days
[ Show More ]
Sparkling Tuna Cup
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.