A spreadsheet for unit costs.

https://spreadsheets.google.com/pub?key=0Al-KDYxKWDSddDBSS19Bd2NDV01wUUhNVlo1Tk55eGc&hl=en&output=html

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

78
Fuddman•

Your numbers match up with mine pretty well. Nice work!

2
Jack_RubyOP•

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.

1
McHoff•

Shouldn't Minerals Per Minute be (Minerals+(Supply x 12.5)), as each supply costs 12.5? (100 / 8)

2
Jack_RubyOP•

You're absolutely right, thank you.

1
TheBaconExperiment•

Your Immortal is listed as 1 supply instead of 4.

2
Jack_RubyOP•

Thank you, fixed

1
Nimbal•

You made a self-post (no link to your spreadsheet). Maybe edit the link in, or put it in a comment?

There is also an (old) discussion about this topic over at TeamLiquid:

http://www.teamliquid.net/forum/viewmessage.php?topic_id=142183

1
Jack_RubyOP•

Thanks, I just noticed that. Added the link.

1