calculating formula

[repli**cator]

okay hi everyone i know what the Current UP to Desired UP formula is.

but does anyone know the Current UP + available naq formula??
what it does, is it calculates by how much UP you canadd to your current UP by looking at the NAQ available


i know about the online calculator but i'm trying to work something out on excell, so if anyone can help me, much appreciated.

[Lore]

talk to pookie, psicolix or legoless as they all have made calcs that work

[_Rube_Dragon_]

yea calculators help out alot

[Saber]

if I had to guess I would think the calc would run a calculation starting from your current UP and increasing by increments of one until the sum of the total naq spent is greater then that of your current naq holds then reduce by one and that is your value.

[Rich™]

if you have x to y UP cost formula, you can easily work it oout, i dont know what the x to y is, so can't help you out unless you post it

[urogard]

generally if you did arithmethic sequences in maths in high school you should know how to do it.
So if you graduated from school this shouldn't be a problem

Final up cost = Initial up cost + 15,000 * number of upgrades
naq available = (Initial up cost + Final up cost)*number of upgrades/2

rearrange this or just put it into excel and you will get your result

[repli**cator]

i'm not particularly well scholared in mathematics....