Uncle_Joe wrote:I think I've spotted an error in the spreadsheet, but my Excel-Fu is pretty weak so I might not be understanding something.
But to me, it looks like the ORat and calculations for Marines/Mines/Tractor beams seem to be off. They look like they are referencing the row ABOVE the desired row (ie, your ORat for Mines is keyed off of how many Marines you have etc).
Thank you for spotting this error.
I have never had Excel-Fu maybe one day I'll get a book on it.
Uncle_Joe wrote:Also, are the Hospital/Cargo etc (Campaign specific components I imagine) supposed to be 133 SUs? That seems like an odd number to have chosen for them.
That came from the Starmada AE to SFO conversion where 133 SU = 1 SFO Cargo "Unit" (although AE figures get rounded)
Cargo and other auxiliary services are not normally a part of SFO ship construction but were requested through the forum. They play no part in normal Starmada games but can be used for some scenarios and where the ships are used in campaigns.
I have corrected the spreadsheet and posted it again (20120809_2)
I'd just like to say sorry to everyone that has been using this spreadsheet.