|
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.
|
United States5139 Posts
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
|
|
|
I just dont get what we are suppose to do when we download...
Where is the excel sheet?
|
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!]
|
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.
|
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.
|
I'm getting an error509 in most of the cells. I'm using openoffice if that makes a difference.
|
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
|
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 compatibleI might have to actually code a site. XD
That worked, cheers.
|
Very cool and definitely appreciate the time put into this, thanks!
|
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)?
|
Thanks a lot for this, you are awesome!
|
|
|
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.
|
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!
|
|
|
|
|
|
EPT
