StarGateWars Forums

At the moment, I am trying to set up a spread sheet to compare the costs of mothership upgrades and tech levels. I have finally figured out the formula to calculate the exact cost of upgrading both weapons and shields based on current and target raw capacities:

Cost=([y*(y+1)/2]-[x*(x+1)/2])*10,000

where x is your current weapon capacity, and y is your desired capacity. For shields, you multiply by 12,000 instead of 10,000.

I cannot, however, manage to tweak it to give me the number of upgrades I can buy with a given amount of Naquadah. This is for all the gifted mathematicians out there.

Any help?

No worries.... found it.

Where?

did u check it against one of the calculators out there?

I would have used Cost = (y/2(2a+(y-1)*10000)) - (x/2(2a+(x-1)*10000))
x being ur current capacity, y being desired and a being ur first cost.
a = 10000.. Although mines is a bit more complicated

what equation u used for ur problem? i would have made ur equation a quadratic nd then solved for x

zizi710 wrote:did u check it against one of the calculators out there?

I would have used Cost = (y/2(2a+(y-1)*10000)) - (x/2(2a+(x-1)*10000))
x being ur current capacity, y being desired and a being ur first cost.
a = 10000.. Although mines is a bit more complicated

what equation u used for ur problem? i would have made ur equation a quadratic nd then solved for x

Guess how much of that i understood mate....
Wanna try again for us 'special' players...

zizi710 wrote:did u check it against one of the calculators out there?

I would have used Cost = (y/2(2a+(y-1)*10000)) - (x/2(2a+(x-1)*10000))
x being ur current capacity, y being desired and a being ur first cost.
a = 10000.. Although mines is a bit more complicated

what equation u used for ur problem? i would have made ur equation a quadratic nd then solved for x

Well.... I figured out that each weapon bay costs 10,000 x The Number of the capacity. i.e. if you have 100, 101st weapon bay would cost 1,010,000 and so forth. I just looked some mathematics websites, and found that the formula/rule that takes a number and adds every number between 1 and itself to it. i.e. the my example would be 101+100+99.....+1. That was the first formula I gave.

Now, to work out how many bays you can buy with a given amount of Naq, you already know "x" - your current raw bays - and "c" - the amount of naq it will cost. So I needed "y". I could not, for the life of me, solve the first equstion for "y"; but I found an online equation solver, which returned this solution:

y=((SQRT(2)*SQRT(5000*(x squared)+5000x+c+1250)-50)/100)-x

That will tell me how many weapon bays can be purchased from my current bays "x" with a given amount of Naq "c".

For shields, the equation is:

((SQRT(15)*SQRT(6000*(x squared)+6000x+c+1250)-150)/300)-x

I've been tinkering on a spreadsheet, and have rigged up a system in which you enter only your current raw bays and tech level; and the sheet will show you whether you will get a better result buying the next tech level, or spending the equivalent Naq on raw slots.

Well.. Every time u add a space to your weapon capacity the cost goes up by 10000 naquadah. So what we're trying to calculate here is the cost it would take to increase from one point to another considering the increase. Basically the 'number line' as it could be called is 10000,20000,30000,40000,50000,60000.. Now using that information we can substitute it into an equation called the Sn formula.. which is Sn = 2/n((2a+(n-1)d)) n = the term or the desired weapon capacity. a = to the first term , which in this case is 10000. d = the difference between the terms above.. basically 20000 - 10000 = 10000. put that all into the equation and presto!! ur answer math is a beautiful thing..

Could someone please give me some info regarding personels in ascended. I do not have sufficient data to formulate and equation. I'm guessing it is a Geometric sequence as there is distinctly no common difference..

Edit: Part above is for Vix..

ah yes thanks for that! i do understand how it managed to get the equation. My algebra is a bit screwed up
Try working on Ascended. Not many calculators offer help with ascended calculations.. add me on MSN : zizi710@live.com nd perhaps we could do it together

Edit: I got the Ascended!!!!!! Wasn't that difficult infact.. It's a geometric sequence therefore we're gona use Tn= ar(all raised to n-1).. i worked out r to be 1.0218.. this is a rounded off figure as the rest of the digits that follow seemed to have changed. a worked out to be 3282.133114 due to rounding off of r. When checking my calculation i was off by about 36140 Naq.. again it's the r thats causing that problem.. If someone could give me the EXACT amounts i would really appreciate it. If i can get the exact figures then i will work on the Sn formulae for working out totals when building Personels.

I just keep pressing buy till i run out of naq, thats my formula. Works well enough.

Bullseye wrote:I just keep pressing buy till i run out of naq, thats my formula. Works well enough.

I like this formula it works for me...

Bullseye wrote:I just keep pressing buy till i run out of naq, thats my formula. Works well enough.

You run out of naq?

Duderanch wrote:

Bullseye wrote:I just keep pressing buy till i run out of naq, thats my formula. Works well enough.

You run out of naq?

Rarely, if im about to run out, i increase my farming. So really no i never run out of naq. If there is war my vault is almost 1/2 full.