• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 15:24
CEST 21:24
KST 04:24
  • 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 202550RSL 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 teams5Weekly 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
RSL Revival patreon money discussion thread The GOAT ranking of GOAT rankings Power Rank - Esports World Cup 2025 Jim claims he and Firefly were involved in match-fixing RSL Season 1 - Final Week
Tourneys
Esports World Cup 2025 Master Swan Open (Global Bronze-Master 2) Sparkling Tuna Cup - Weekly Open Tournament Sea Duckling Open (Global, Bronze-Diamond) FEL Cracov 2025 (July 27) - $8000 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
BW General Discussion [Update] ShieldBattery: 1v1 Fastest Support! BGH Auto Balance -> http://bghmmr.eu/ BSL Team Wars - Bonyth, Dewalt, Hawk & Sziky teams Ginuda's JaeDong Interview Series
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
Simple Questions, Simple Answers I am doing this better than progamers do.
Other Games
General Games
Stormgate/Frost Giant Megathread Nintendo Switch Thread [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 Post Pic of your Favorite Food! Things Aren’t Peaceful in Palestine Russo-Ukrainian War Thread The Games Industry And ATVI
Fan Clubs
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
Customize Sidebar...

Website Feedback

Closed Threads



Active: 826 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 15h 37m
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
Hui .296
BRAT_OK 104
ProTech70
MindelVK 35
ForJumy 32
Nathanias 17
StarCraft: Brood War
Mini 627
Mind 129
ivOry 4
Dota 2
420jenkins512
Counter-Strike
fl0m5413
sgares495
Foxcn225
oskar192
Fnx 37
Heroes of the Storm
Liquid`Hasu402
Other Games
FrodaN3139
Gorgc2886
qojqva805
Dendi753
Trikslyr76
QueenE73
ArmadaUGS56
Sick35
Organizations
Other Games
BasetradeTV44
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 17 non-featured ]
StarCraft 2
• Adnapsc2 10
• iHatsuTV 8
• intothetv
• sooper7s
• Migwel
• AfreecaTV YouTube
• LaughNgamezSOOP
• IndyKCrew
• Kozan
StarCraft: Brood War
• STPLYoutube
• ZZZeroYoutube
• BSLYoutube
Dota 2
• masondota22019
• WagamamaTV602
League of Legends
• Jankos2211
Other Games
• imaqtpie1734
• Shiphtur378
Upcoming Events
Esports World Cup
15h 37m
Serral vs Cure
Solar vs Classic
OSC
18h 37m
CranKy Ducklings
1d 14h
BSL20 Non-Korean Champi…
1d 18h
CSO Cup
1d 20h
BSL20 Non-Korean Champi…
1d 22h
Bonyth vs Sziky
Dewalt vs Hawk
Hawk vs QiaoGege
Sziky vs Dewalt
Mihu vs Bonyth
Zhanhun vs QiaoGege
QiaoGege vs Fengzi
FEL
2 days
BSL20 Non-Korean Champi…
2 days
BSL20 Non-Korean Champi…
2 days
Bonyth vs Zhanhun
Dewalt vs Mihu
Hawk vs Sziky
Sziky vs QiaoGege
Mihu vs Hawk
Zhanhun vs Dewalt
Fengzi vs Bonyth
Sparkling Tuna Cup
4 days
[ Show More ]
Online Event
4 days
uThermal 2v2 Circuit
5 days
The PondCast
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
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.