StarGateWars Forums

Heya! I think this is the best forum for this... if its not then feel free to move it (not that me saying don't move it could or should stop you).

Im after a nice straight formula for UP planet cost, where you put in its UP and size, maybe starting cost, and it will simply tell you how much it will cost to get it to X UP.

It can be a nice set of instructions if it needs to be, but loops are a big no no.

I'm trying to get this to work in Excell so yeah.

All other attempts at this that ive seen have either used a loop, or just had a list of total costs ect, so no real hope there.

-Goodie

i would be interested in this also

7.01 mil base cost
1.1
1.2
1.3
...
are the multipliers

5k is the next upgrade.

takes me generally about 30 secs to find that out so i don't have the formula written down anywhere how it has to be in excel

UP planet:
amount for 1 __ for 100 ___ size
___ 1.1 ___ ___ 110 - tiny
___ 1.2 ___ ___ 120 - very small
___ 1.3 ___ ___ 130 - small
___ 1.4 ___ ___ 140 - normal
___ 1.5 ___ ___ 150 - above average
___ 1.6 ___ ___ 160- Large
___ 1.7 ___ ___ 170 - Huge
___ 1.8 ___ ___ 180 - Monsterous
___ 1.9 ___ ___ 190 - mind blowing

I use C++ to calculate accurate.

general SGW calc-very accurate and the Planet calculator will do what you're wanting.


http://www.arvystate.net/calc2/

cyberblade wrote:general SGW calc-very accurate and the Planet calculator will do what you're wanting.


http://www.arvystate.net/calc2/

Manage 10 planets? Tell me the total to upgrade defense, or UP, or by a planet by planet basis? And grand total? and easily updated?

I'm taking this a step further that everyone else (that I've seen) has. :p

-Goodie

goodie wrote:

cyberblade wrote:general SGW calc-very accurate and the Planet calculator will do what you're wanting.


http://www.arvystate.net/calc2/

Manage 10 planets? Tell me the total to upgrade defense, or UP, or by a planet by planet basis? And grand total? and easily updated?

I'm taking this a step further that everyone else (that I've seen) has. :p

-Goodie

Could you explain a bit? If you're trying to do what I think you are-you'll need to pull the formula's from here http://www.herebegames.com/StarGateWarsNew/viewtopic.php?t=58660 and then plug those into your own spreadsheet and add the extra functions...