A spreadsheet for unit costs.
So, I created this to help me figure out how many unit producing structures I needed as Protoss or Terran. M% and G% values are what % of the production of a fully saturated base it would cost to constantly produce the unit. There is a 2nd sheet that has the values for upgrades.
- Minerals Per Minute - (Minerals+(Supply x 12.5)) x (60/Time)
- Gas Per Minute - Gas x (60/Time)
- M% - (MpM/816) x 100
- G% - (GpM/228) x 100
- @Max MR = Mineral Remainder at maximum from one base. 100-(MaxPerBase*M%). Ditto for GR.
Notes: The Protoss times are for Gateways, not Warpgates. Mules are not factored in to complete saturation. This all assumes that my formulas are correct and bases provide 816 MpM and 228 GpM. Please point out anything that's wrong.
Some things that this has told me:
Protoss can produce zealots and stalkers from 3 warpgates, while still producing probes.
Protoss can only afford to make Immortals and Colossi from 1 Robotics.
Terran can produce SCVs, 2 Marines, and 1 Marauder and ~.5 Medivacs from 1 base.
Edit: Fixed, and added a couple of more variables.
Posted Sep 29, 2010, 5:27 AM UTC · edited
Your numbers match up with mine pretty well. Nice work!
Cool, the bottom rows on your sheet are exactly the sort of analysis I was aiming for. My hope was to come up with a lot of that, and contribute the useful info to Liquipedia.