(The Last few Posts should probably all be in their own message thread, but oh well...)
Just so y'all know, I found a couple minor errors in the calculations; it doesn't change the final conclusion, it just means the spreadsheet is a tad inaccurate. I also did some tweaking for production and/or construction bonuses; nothing really changes until you can build the better facility in a single turn.
The corrected equation would be:
Upgrade plan net gain: 1387*N*N - 2700*N
where N=number of Mineral Miner Facilities being built.
Oh - minor point on build rates of 1250-1999; if the rate is 1500-1999, it's better to build the MMF1's and upgrade to MMF3's later. If your build rate is 1250-1500, it takes two turns to build any of the three MMF facilities, so it would be best to build the MMF3.
In case anyone missed it, the above information only applies if you have all three tech levels available; if you only have access to MMF1's or MMF2's, by all means, build them and don't worry about upgrading until you get the right tech level.
