Home World Forum
Stars! AutoHost web forums

Jump to Stars! AutoHost


 
 
Home » Primary Racial Traits » AR » AR Resources Calculation
AR Resources Calculation Sun, 08 April 2012 06:30 Go to next message
BeeKeeper is currently offline 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 05:34 Go to previous messageGo to next message
magic9mushroom is currently offline magic9mushroom

 
Commander

Messages: 1180
Registered: May 2008
We already knew this. How is this news? Confused

Report message to a moderator

Re: AR Resources Calculation Mon, 16 April 2012 09:20 Go to previous messageGo to next message
BeeKeeper is currently offline BeeKeeper

 
Officer Cadet 1st Year

Messages: 214
Registered: December 2007
Location: Devon, UK, GMT
It was news to me - it is not in the User Manual and I could not find it in the Wiki.

Report message to a moderator

Re: AR Resources Calculation Mon, 16 April 2012 14:57 Go to previous messageGo to next message
nmid

 
Commander

Messages: 1590
Registered: January 2011
Location: GMT +5.5

Always good to know and especially if it's in the right subforum xd.

Edit - ah, this should be shifted to the AR subforum Very Happy.


[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 Mon, 16 April 2012 20:08 Go to previous messageGo to next message
m.a@stars is currently offline m.a@stars

 
Commander

Messages: 2755
Registered: October 2004
Location: Third star to the left
BeeKeeper wrote on Mon, 16 April 2012 15:20

It was news to me - it is not in the User Manual and I could not find it in the Wiki.

The main "library" is still the old r.g.c.s. Usenet newsgroup. Lurking



So many Stars, so few Missiles!

In space no one can hear you scheme! Deal

Report message to a moderator

Re: AR Resources Calculation Tue, 17 April 2012 11:29 Go to previous messageGo to next message
BeeKeeper is currently offline BeeKeeper

 
Officer Cadet 1st Year

Messages: 214
Registered: December 2007
Location: Devon, UK, GMT
The main "library" is still the old r.g.c.s. Usenet newsgroup. Lurking[/quote]

I can't find anything much on that link about Stars. Do I need to subscribe to something?

Report message to a moderator

Re: AR Resources Calculation Wed, 18 April 2012 02:48 Go to previous messageGo to next message
Anonymous Coward
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 Fri, 20 April 2012 04:29 Go to previous messageGo to next message
gible

 
Commander

Messages: 1343
Registered: November 2002
Location: Hamilton, New Zealand

http://wiki.starsautohost.org/wiki/AR_Guide_by_Leonard_Dicke ns_-_Revised:_21st_September_2000

Report message to a moderator

Re: AR Resources Calculation Fri, 20 April 2012 12:18 Go to previous messageGo to next message
BeeKeeper is currently offline BeeKeeper

 
Officer Cadet 1st Year

Messages: 214
Registered: December 2007
Location: Devon, UK, GMT
Thank you - the 0.25 minimum hab value is mentioned but I must have missed it as it isn't actually shown in the formula itself. Which was why my version of the formula had the "IF" statement.

What I am still trying to work out is a (ideally) simple way of predicting the populations on starbases in the future so it might be possible to have a spreadsheet which could more accurately predict future resources.

The formula:

present pop + ((growth factor * present pop) * (1 - (present pop / starbase max pop)))

Gives an answer for the following year to within about 5% for the tests I have done so far but I need to test it more to see how accurate it will be for say 5 or 10 years in the future.

Report message to a moderator

Re: AR Resources Calculation Sat, 21 April 2012 23:20 Go to previous messageGo to next message
neilhoward

 
Commander

Messages: 1112
Registered: April 2008
Location: SW3 & 10023
http://wiki.starsautohost.org/wiki/Utilities/Calculators#For ceUser.27s_ISAR_Calculator

Report message to a moderator

Re: AR Resources Calculation Sun, 22 April 2012 06:18 Go to previous messageGo to next message
BeeKeeper is currently offline BeeKeeper

 
Officer Cadet 1st Year

Messages: 214
Registered: December 2007
Location: Devon, UK, GMT
?

Someone else gave me that link before but I already have the Stars! calc but that is not what I am after - I am looking for the formula for calculating future populations so I can put it in a spreadsheet.

Report message to a moderator

Re: AR Resources Calculation Wed, 02 May 2012 07:12 Go to previous messageGo to next message
gible

 
Commander

Messages: 1343
Registered: November 2002
Location: Hamilton, New Zealand

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 Wed, 02 May 2012 15:37 Go to previous messageGo to next message
BeeKeeper is currently offline BeeKeeper

 
Officer Cadet 1st Year

Messages: 214
Registered: December 2007
Location: Devon, UK, GMT
Thank you, I will have a search, but if I can predict future pop to within 100 that will be fine!

Report message to a moderator

Re: AR Resources Calculation Fri, 01 June 2012 05:04 Go to previous messageGo to next message
m.a@stars is currently offline m.a@stars

 
Commander

Messages: 2755
Registered: October 2004
Location: Third star to the left
BeeKeeper wrote on Tue, 17 April 2012 17:29

Quote:

The main "library" is still the old r.g.c.s. Usenet newsgroup. Lurking


I can't find anything much on that link about Stars. Do I need to subscribe to something?

Keep scrolling "down" past all the spam it has received in recent years. Even better: use the "search" functionality. Lurking



So many Stars, so few Missiles!

In space no one can hear you scheme! Deal

Report message to a moderator

Re: AR Resources Calculation Fri, 01 June 2012 15:51 Go to previous message
BeeKeeper is currently offline 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

Previous Topic: Some (hard-learned) tips on playing AR
Next Topic: AR another study
Goto Forum:
  


Current Time: Wed Aug 21 06:27:23 EDT 2019