1. We have added the ability to collapse/expand forum categories and widgets on forum home.
    Dismiss Notice
  2. Photobucket has changed its policy concerning hotlinking images and now requires an account with a $399.00 annual fee to allow hotlink. More information is available at: this link.
    Dismiss Notice
  3. All Civ avatars are brought back and available for selection in the Avatar Gallery! There are 945 avatars total.
    Dismiss Notice
  4. To make the site more secure, we have installed SSL certificates and enabled HTTPS for both the main site and forums.
    Dismiss Notice
  5. Civ6 is released! Order now! (Amazon US | Amazon UK | Amazon CA | Amazon DE | Amazon FR)
    Dismiss Notice
  6. Dismiss Notice
  7. Forum account upgrades are available for ad-free browsing.
    Dismiss Notice

Starships planet development calculator

Discussion in 'Starships' started by Minor Annoyance, Apr 15, 2015.

  1. Minor Annoyance

    Minor Annoyance Chieftain

    Joined:
    Jun 27, 2007
    Messages:
    2,247
    Gender:
    Male
    Location:
    Hamilton, Ontario
    I make a spreadsheet to calculate the time to the return on your investment when building new cities or improvements.
    You enter the number of cities and existing improvements on the correct special/biome row for the planet and it will tell you how many turns it would take for the extra resources you get from that improvement to add up to the cost of the improvement. You can also set different valuation for resources. I set energy higher and food lower but that can be changed. Also has switches for the three leaders that would change the calculation.
    It's also colour coded from green to red so that you can easily see what takes too long to get back. I set 10 as a point where it just blanks out that cell because most games take 10 turns total so anything that takes that long isn't worth considering.

    The trickiest part was the Primal worlds that increase in population every turn. I needed help from reddit to do the math for an increasing change of output.

    Spoiler :


    EDIT: Improved the file. Now includes switches for having Earth and Xanadu type planets in your federation. Made it slightly easier to read and added extra rows for the more common planets. I knew you'd have more than one planet with no type resource modifier but still with the same biome but I forgot it wasn't as easy to add new rows without adding them to all the calculation pages too, so I added two more for each biome with no resource modifying type. Also two more no type, no biome rows for if you capture homeworlds. You could catch more than two homeworlds but by that time you'd have your planets developed and are close to the end, so you wouldn't need to think about resources for long.
     
  2. Ampharos

    Ampharos Chieftain

    Joined:
    Aug 15, 2014
    Messages:
    28
    Location:
    New Jersey
    This is incredibly helpful. Thanks!
     
  3. Minor Annoyance

    Minor Annoyance Chieftain

    Joined:
    Jun 27, 2007
    Messages:
    2,247
    Gender:
    Male
    Location:
    Hamilton, Ontario
    Updated the file. Now includes switches for having Earth and Xanadu type planets in your federation. Made it slightly easier to read and added extra rows for the more common planets. I knew you'd have more than one planet with no type resource modifier but still with the same biome but I forgot it wasn't as easy to add new rows without adding them to all the calculation pages too, so I added two more for each biome with no resource modifying type. Also two more no type, no biome rows for if you capture homeworlds. You could catch more than two homeworlds but by that time you'd have your planets well developed and are close to the end, so you wouldn't need to think about resources for long.
     
  4. Minor Annoyance

    Minor Annoyance Chieftain

    Joined:
    Jun 27, 2007
    Messages:
    2,247
    Gender:
    Male
    Location:
    Hamilton, Ontario
    A most enraging error was found. The file was missing some modifiers for icy and arid biomes so it wasn't calculating a high enough return from those types of planets. It's fixed now. New file uploaded. Must have happened when I added the Earth and Xanadu modifiers, which are very small, and not often a factor. So a step in the wrong direction there.
     

Share This Page