Covert power calculation.

[Finarfin]

I need a touch of help with this. I am using excel to make a UP/Covert Power/Covert Level calculator and I am stuck on the covert power one.

They gave the formula as this

( ( (sqrt(2^spyLvl) x spies x %increase techs x %increse race ) + spies ) * 10 )

So that comes out as (((2^spy level * spies * sum of techs/100 * 30/100; if lg) + spies ) * 10)

That is all well and good. I am wondering how much the techs add up to, because I never noted it down when I bought them from my last ascension.

I guessed it was 75%, ie, 0.7, but I want confirmation.

Also, going by the logic I showed above and putting in my spy level, spies and race bonus (30% as LG+1), I came out with 2 trillion. Thats a fair bit too much, so I am wondering what I calculated wrong.

Also, I am aware that there are other calculators out there, but I want to use my own .

[Tok`ra]

http://www.calc.streamdown.net/

[Finarfin]

Didn't help at all I'm afraid. I'm looking for help on the actual calculations, not something else to do it for me

That calc doesn't have covert power there anyway.

[Shalak]

(((SQRT(2^Spy Level)*Covert Agents*1.56*(1+(0.05*Number Of Ascensions))+Covert Agents)*10))

Thats what i have in my excel calculator and it works out perfect for me

[Finarfin]

That formula is brilliant. 100% accurate. Great work mate .

[Shalak]

no problem, glad i could help