• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 19:33
CEST 01:33
KST 08:33
  • 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 202561RSL Season 1 - Final Week9[ASL19] Finals Recap: Standing Tall15HomeStory Cup 27 - Info & Preview18Classic wins Code S Season 2 (2025)16
Community News
BSL 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 roll8Team TLMC #5 - Submission re-extension4
StarCraft 2
General
The StarCraft 2 GOAT - An in-depth analysis #1: Maru - Greatest Players of All Time The GOAT ranking of GOAT rankings EWC 2025 details: $700k total prize; GSL, DH Dallas confirmed Power Rank - Esports World Cup 2025
Tourneys
Esports World Cup 2025 FEL Cracov 2025 (July 27) - $8000 live event Sparkling Tuna Cup - Weekly Open Tournament Master Swan Open (Global Bronze-Master 2) Sea Duckling Open (Global, Bronze-Diamond)
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
BITCOIN RECOVERY EXPERT | LOST RECOVERY MASTERS BGH Auto Balance -> http://bghmmr.eu/ Ginuda's JaeDong Interview Series [Update] ShieldBattery: 2025 Redesign BW General Discussion
Tourneys
[Megathread] Daily Proleagues CSL Xiamen International Invitational [CSLPRO] It's CSLAN Season! - Last Chance [BSL 2v2] ProLeague Season 3 - Friday 21:00 CET
Strategy
[G] Mineral Boosting Does 1 second matter in StarCraft? Simple Questions, Simple Answers
Other Games
General Games
Total Annihilation Server - TAForever Stormgate/Frost Giant Megathread Nintendo Switch Thread [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
Stop Killing Games - European Citizens Initiative Things Aren’t Peaceful in Palestine Russo-Ukrainian War Thread US Politics Mega-thread Post Pic of your Favorite Food!
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
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
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: 702 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
Next event in 10h 27m
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
Nathanias 186
StarCraft: Brood War
Larva 378
Dota 2
monkeys_forever552
capcasts173
League of Legends
Grubby4158
Counter-Strike
Fnx 2574
flusha436
Super Smash Bros
Mew2King158
AZ_Axe108
Liquid`Ken36
Other Games
tarik_tv22986
summit1g11260
gofns8736
C9.Mang0227
ViBE145
PPMD23
Organizations
Other Games
gamesdonequick644
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 20 non-featured ]
StarCraft 2
• Hupsaiya 77
• RyuSc2 43
• musti20045 39
• davetesta27
• Migwel
• sooper7s
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
StarCraft: Brood War
• HerbMon 30
• STPLYoutube
• ZZZeroYoutube
• BSLYoutube
Stormgate
• mYiSmile10
Dota 2
• masondota23272
League of Legends
• Doublelift4986
• TFBlade494
Other Games
• imaqtpie1033
Upcoming Events
CranKy Ducklings
10h 27m
BSL20 Non-Korean Champi…
14h 27m
CSO Cup
16h 27m
BSL20 Non-Korean Champi…
18h 27m
Bonyth vs Sziky
Dewalt vs Hawk
Hawk vs QiaoGege
Sziky vs Dewalt
Mihu vs Bonyth
Zhanhun vs QiaoGege
QiaoGege vs Fengzi
FEL
1d 9h
BSL20 Non-Korean Champi…
1d 14h
BSL20 Non-Korean Champi…
1d 18h
Bonyth vs Zhanhun
Dewalt vs Mihu
Hawk vs Sziky
Sziky vs QiaoGege
Mihu vs Hawk
Zhanhun vs Dewalt
Fengzi vs Bonyth
Sparkling Tuna Cup
3 days
Online Event
3 days
uThermal 2v2 Circuit
4 days
[ Show More ]
The PondCast
5 days
Replay Cast
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
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

CSLPRO Last Chance 2025
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
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
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.