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
|
|
|
|
|
Re: AR Resources Calculation |
Mon, 16 April 2012 14:57 |
|
|
Always good to know and especially if it's in the right subforum xd.
Edit - ah, this should be shifted to the AR subforum .
[Updated on: Mon, 16 April 2012 14:57]
I know my minefields.. but I'm a chaff sweeper.
I used to curse when I got stuck in traffic... till I realised I AM traffic.Report message to a moderator
|
|
|
|
|
Re: AR Resources Calculation |
Wed, 18 April 2012 02:48 |
|
|
I'm sure this is probably well known resource, but here you go:
www.starsfaq.com
Includes "RGCS Advanced & Technical FAQ", old StarsFAQ articles, and a wealth of categorized articled from an old Omonubi's site "Stars-R-Us".
I learned all I ever needed about playing AR (and other PRTs too!) from these articles.
Report message to a moderator
|
|
|
|
|
|
|
Re: AR Resources Calculation |
Wed, 02 May 2012 07:12 |
|
|
have a read around for general pop growth formulas....apart from the SB hab sizes, ARs aren't really any different from any other race. The complicating factor is thwt Stars! calculates pop to th nearest person (IIRC) but only displays in 100s.
Report message to a moderator
|
|
|
|
|
Re: AR Resources Calculation |
Fri, 01 June 2012 15:51 |
|
BeeKeeper | | Officer Cadet 1st Year | Messages: 214
Registered: December 2007 Location: Devon, UK, GMT | |
|
Many thanks - I will do that.
Report message to a moderator
|
|
|