Calculator I made for SGW

[Anarchy_]

well, it works
i didnt see nething wrong with it...

[Finarfin]

New update. Income works properly now.

[MLX]

it won't let me download it.

[Finarfin]

Yeah the site was temporarily suspended for something unrelated. Should work now.

[Finarfin]

Rwar.

[Milenko]

Great work mate

[GeneralChaos]

This needs to be rechecked for UP in ascension as admin tweaked charisma, and my level vs fleets does not much in game against the calculator.

EDIT: Income also seems to be out since the new update was put in place.

[Finarfin]

This needs to be rechecked for UP in ascension as admin tweaked charisma, and my level vs fleets does not much in game against the calculator.

EDIT: Income also seems to be out since the new update was put in place.

Hmm UP does seem to be not working quite right. I thought I had it worked out correctly, but alas not. I just bumped up my charisma to test it and you were right. It worked for the charisma I had .

Ill see what I can do.

[liam óg]

Hi great calculator you've made. I'd like to make a two suggestions on the calculator, as I'm sure your aware you can't increase your UP by 1 it has to be a multiple of 3. These changes tell what you actually have to spend, so if you enter 50,000 target it tells you the cost to increase your UP to 50,001. This is what you will have to spend anyway so I feel it's beneficial.

So change the formula in D6 to:

Code: Select all

(-1*(A6-CEILING(B6,3))/3)*((15000*((CEILING(B6,3)-1)/3)+15000*((A6+2)/3))/2)

And change cell F6 to

Code: Select all

(CEILING($B$6,3)-A6)/3

Anyhow hope this helps and again thanks for the great calculator.

[Finarfin]

Hi great calculator you've made. I'd like to make a two suggestions on the calculator, as I'm sure your aware you can't increase your UP by 1 it has to be a multiple of 3. These changes tell what you actually have to spend, so if you enter 50,000 target it tells you the cost to increase your UP to 50,001. This is what you will have to spend anyway so I feel it's beneficial.

So change the formula in D6 to:

Code: Select all

(-1*(A6-CEILING(B6,3))/3)*((15000*((CEILING(B6,3)-1)/3)+15000*((A6+2)/3))/2)

And change cell F6 to

Code: Select all

(CEILING($B$6,3)-A6)/3

Anyhow hope this helps and again thanks for the great calculator.

Wow! Ive never seen Excell do anything like that before! That will certainly go in there! Damn I didn't even know Excell could do that.

[liam óg]

Wow! Ive never seen Excell do anything like that before! That will certainly go in there! Damn I didn't even know Excell could do that.

No problem i'm a hacker (not the bad kind ) at heart so i'm always trying to find soloutions to problems people didn't know they had.

[Child of the wolf]

Hehe, nice little calc you got going here

one quick little fix, in G32, change it to

Code: Select all

=IF(B34=0,0,A32/B34)

not a bug of any kind, it just stops excel from having a fit about being asked to divide by 0

[Silicis]

Could this be made into an .exe? I don't have excel.

[cyberblade]

Could this be made into an .exe? I don't have excel.

you don't need excel... any standard spreadsheet software should work.

try this one if you don't have any: http://www.openoffice.org/

[bitz]

The Spy Power calculation seems wrong. The 1.56 multiplier you have in cell B18 needs to be 1.782. That gives me the correct answer for replicator, I don't know about other races.

Also the Spy Level Cost doesn't include the 10% discount for replicators.