Calculator I made for SGW

[Finarfin]

http://www.fina.arc-focus.com/stuff/Mag ... ulator.xls

It requires that you have Excel or any other suitable program that can open xls files I guess.

It can:

Calculate UP (Tells you the multiple, you can insert the amount of naq you have and then input a UP level to see if you have enough naq for it - useful at times)

Calculate Spy Power, based on spies, level and appropriate race (Eg, Replicator, standard races or Ascended).

Cost per spy level for non replicators (If someone could tell me how Replicators effect cost I would be most grateful).

Income calculator, which factors in UU, Miners, Race Bonus, Officer Rate, realm alert, 10% bonus for no commander and automatically calculates the 1% from banner ads..

Enjoy. I know there are other calculators out there, but no need to mention them. You all know who they are.

Update: Income calculator now does not require officers rate to function correctly, so more accurate as a result.
Also automatically factors in the 1% income boost from having banner ad's enabled.
Nox is also calculated now
Race %'s now correct (Thanks to The Deity)
Now details the correct race % for Goa'Auld (Much embarrassment on my part when I realised I wrote 30% instead of 25%).

Update 2: Income calculator is now 100% working. Planets do not count to officer rate any longer.
Calculator also now has an option to input the 10% bonus from having no commander.
Planets fixed up a little as well.
Can now input amount of officers for easy discovery of what amount goes to each officer.

Update 3: Few more minor updates and nifty features. Nothing major added.

Update 4: Ascended elements currently being revised. Added ascension goodies - in particular, ascended income calculation and ascended UP calculators. UP calculator involves total planets with charisma and cost to get to a particular level. Hopefully that doesn't violate the rules in any way.

Update 5: Hid elements which were not working.
Added fleet costs for over 100k Fleets.
Added the Ceiling into some equations as suggested by liam óg

Anyone able to work out the effect that Charisma/Production enhancements have in mathematical terms?

Enjoy.

[The Xeno]

I'll add a link in the compendium after some reviews.

[Tok`ra]

It aint work...............





But if you use THE calc that pookie made .......... http://jason.streamdown.net/calc/

You get THIS result with the same input nunbers: 1,764 UP upgrades
At a cost of: 417,741,203,333 Naquadah




It seems that your calc has a bug.

[Finarfin]

Thats a decimal point mate

Although admittedly some countries do use decimal points as separators, over here we use commas. Sorry for that mix up. Its the same number just to 3 dec. places.

I just re-uploaded a new version which doesn't calculate it to a decimal point.

[Tok`ra]

Thats a decimal point mate

Although admittedly some countries do use decimal points as separators, over here we use commas. Sorry for that mix up. Its the same number just to 3 dec. places.

Yeah, we use decimal places in teh states too.

Im just not used to seeing them in connection to SGW :p

[Finarfin]

Thats a decimal point mate

Although admittedly some countries do use decimal points as separators, over here we use commas. Sorry for that mix up. Its the same number just to 3 dec. places.

Yeah, we use decimal places in teh states too.

Im just not used to seeing them in connection to SGW :p

Well I fixed it up now anyway.

[Lord Morlock]

eh, not like I need a new calc, but it works..

[Finarfin]

Make sure if you use it to leave a review

I want to know where I need to improve.

[sniper]

nice job on the sgw caculator, Finarfin i tried it and it works

[Finarfin]

I uploaded a new version that has a different calculation for income (I believe I messed up a calculation, this one seems far more accurate). If you have any discrepancies, please tell me

[The Deity]

I've been out of the loop for a while but I believe that Ascending past LG+1 stil lonly gives you a 1% bonus as opposed to a 5% one so your Spy Power Race Multipliers should read:
LG+1 6
LG+2 6.2
LG+3 6.4
LG+4 6.6
AG 6.8

And Nox is 10% of your Income.

[Finarfin]

Oo I never thought of that. Cheers for that. Ill fix up everything according to that then

[Mystake]

Finarfin do I got your permission to turn this into an EXE? Credits will be given where due in the program of course

[Finarfin]

Sure. I have no programming knowledge so it isn't as if I will launch an .exe myself.

[Finarfin]

Updated.