AR Resources Calculation |
Sun, 08 April 2012 06:30 |
|
BeeKeeper | | Officer Cadet 1st Year | Messages: 214
Registered: December 2007 Location: Devon, UK, GMT | |
|
In the Stars! User Guide there is a formula for calculating resources from an AR planet:
Resources = Habitability_Value * SQRT ( Population * Energy_Tech_Level / Efficiency Coefficient)
However, this formula does not work for planets with a negative habitability factor.
For a race with a single immunity the actual habitability factor to use is 25%, so the formula needs to be modified. If using a spread sheet you could use something like:
Resources = IF (Habitability_Value < 25% THEN 25% ELSE Habitability_Value) * SQRT etc... as before.
It is possible to make a spread sheet using the P file from the game. If this is opened in an Excel workbook as Sheet2 then the resources for each planet can be shown on Sheet 1 using a formula such as this:
=IF(Sheet2!F2<25%, 25%, Sheet2!F2)*SQRT(Sheet2!E2*Sheet1!D$1/Sheet1!B$1)
In this example, which looks at the second row (the top row being a header) D1 on Sheet 1 is the current Energy Tech level and B1 is the Efficiency coefficient for your race.
Sheet 2 is the P File but sorted by Planet Owner. For simplicity you could delete all other planets except your own.
If you paste this formula into the sheet for every row you have a planet and total it up it gives an answer within about 1%. You can then see what the advantages are of researching more tech or moving populations around etc.
I have not tested this for a Bi-Immune race but I assume the factor would be 50 not 25%? I have also not looked at what the formula should be for a race without an immunity. Any suggestions would be welcome.
Update: Have just tested it with both a Bi-Immune race and a race with no immunities and the minimum habitability factor remains at 25% for both races.
[Updated on: Sun, 08 April 2012 09:51] Report message to a moderator
|
|
|