My colony spreadsheet: Version 2-2

Version 2-2 available!

Download!

Will predict the final population, morale, harvesting and weapons output of any colony. Just enter the settings in the green areas of the spreadsheet.

This will only predict the final stats, not how long it takes to get there or what happens in the mean time.

Version history
1-0:
Basic model. Calculates population assuming 1500 morale

1-1:
Added coloured spreadsheet regions.
Is now accurate for any final morale level
Updated instructions

1-2:
Biodome level now taken into account.

1-3:
Research discoveries can be entered.
More space used by each colony (8 rows instead of 1)
Deleted instructions... oh well
Will now recommend a harvest setting based on what resources you need
Displays harvest rates.

1-4:
Menu headings row at the top are visible regardless of scrolling.
Recommends military settings based on harvesting and Military Tradition discovery.
Displays solar cannon performance
Displays weapons factory outputs
Harvest rates for equip (and ura) are reduced according to what the Weapons Factory is using.

1-5:
Improved solar burst calculation
Weapons outputs corrected for volcanic and prison colonies
Imposed minimum pop limit of zero
Military effectiveness limited to 100%
Solar bursts/min limited to 120
Rewrote instructions.

1-6:
Workforce allocations now use % format

2-0:
An attempt at accomodating for partial resource consumption has been made.
The user no longer inputs the resources to be consumed, and the spreadsheet does not recommend a harvest rate.
IGP harvesting rates added.

2-1:
Non-functional prototype

2-2:
Solar shot cost reduced to 25 ore each, in correspondence with the game.
Partial consumption averaging should work now.

lmao, nice, where'd you get such an idea to make this spreadseet?

Seemed like a good idea at the time. One day I'll get the harvesting data and it'll tell you how much stuff you're getting

Bump. New version as of May 2008. If anybody here has any stable colonies, can you test it for me? Thanks.