• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 04:28
CEST 10:28
KST 17:28
  • 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 20255Power 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) Announced21BSL 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 I offer completely free coaching services 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 Dewalt's Show Matches in China BGH Auto Balance -> http://bghmmr.eu/ BW General Discussion Flash Announces (and Retracts) Hiatus From ASL
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
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
[\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: 665 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 32m
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
Nina 241
ProTech67
StarCraft: Brood War
Sea 4235
Hyuk 4120
firebathero 800
Hyun 703
Larva 604
Backho 163
zelot 98
Mind 82
EffOrt 65
scan(afreeca) 62
[ Show more ]
Free 35
Noble 31
Sacsri 21
soO 17
sorry 13
Bale 9
IntoTheRainbow 9
Dota 2
XcaliburYe394
Counter-Strike
Stewie2K985
Heroes of the Storm
Khaldor214
Other Games
gofns5399
Happy249
SortOf156
Organizations
StarCraft: Brood War
lovetv 13
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 12 non-featured ]
StarCraft 2
• Berry_CruncH271
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
Dota 2
• lizZardDota2174
Upcoming Events
FEL
32m
Krystianer vs sOs
SKillous vs ArT
MaNa vs Elazer
Spirit vs Gerald
Clem vs TBD
uThermal vs TBD
Reynor vs TBD
Lambo vs TBD
BSL20 Non-Korean Champi…
5h 32m
BSL20 Non-Korean Champi…
9h 32m
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
WardiTV European League
2 days
Online Event
2 days
uThermal 2v2 Circuit
3 days
The PondCast
4 days
Replay Cast
4 days
Korean StarCraft League
5 days
[ Show More ]
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.