Calculators

Locked
Quina Quen
Forum Addict
Posts: 4563
Joined: Thu Jul 07, 2005 12:22 pm
Alternate name(s): Diamond Dust

Calculators

Are there any available for Quantum?
The ascended entity formerly known as Diamond Dust
User avatar
™THE_LEGEND™
Forum Intermediate
Posts: 867
Joined: Sat Oct 29, 2005 3:41 pm
Alliance: ™F®G0TT3N L3G3NDS™
Race: F®G0TT3/\/
ID: 12795
Alternate name(s): ™THE_L3G3ND™
Location: U.S.A

Re: Calculators

I had one, but that was years ago haha Let me know if you find one mate!
Image
™F®G0TT3N L3G3NDS™ and ™IMM®T4L L3G3NDS™ it's a beautiful thing!

Avay Made By Murkar, Siggy Made By Retribution
Quina Quen
Forum Addict
Posts: 4563
Joined: Thu Jul 07, 2005 12:22 pm
Alternate name(s): Diamond Dust

Re: Calculators

Sure will do :)
The ascended entity formerly known as Diamond Dust
User avatar
[BoT] Jason
Forum History
Posts: 10120
Joined: Mon Sep 29, 2008 12:37 am
Alliance: TA
Race: DIEDAYDIEDAY
ID: 13003152
Alternate name(s): Pimp,Slenderman
Location: Right behind you

Re: Calculators

Poke S1eepy, HippyFool or High Empty

Best chances
Pimping

Feb 06, 06:16 Field Marshall Attack defended 15 88,977,968 0 x,x62,635,278,400 900,114 details

| | Hero of the Year | |

Winner: BMMJ13
Quina Quen
Forum Addict
Posts: 4563
Joined: Thu Jul 07, 2005 12:22 pm
Alternate name(s): Diamond Dust

Re: Calculators

Cheers Jason. Doubtful any exist to be honest as Q has a habit of changing each era. If I could remember how to use Excel properly from all that mind numbing training I received back in an old job a few years ago I would at least be able to figure out what I want to know (which is the cost of the techs). Oh well. I'll just keep throwing my naq around and hope that it's the most efficient route for the time being. ;)
The ascended entity formerly known as Diamond Dust
User avatar
[BoT] Jason
Forum History
Posts: 10120
Joined: Mon Sep 29, 2008 12:37 am
Alliance: TA
Race: DIEDAYDIEDAY
ID: 13003152
Alternate name(s): Pimp,Slenderman
Location: Right behind you

Re: Calculators

For tech costs you need to factor in top techs compared to yours and then work the cost to get to the top. Then counter in the jump in price from there followed by the constant quadractic increase of being top :P. Just jam 9999 into it and see what it tells you rather
Pimping

Feb 06, 06:16 Field Marshall Attack defended 15 88,977,968 0 x,x62,635,278,400 900,114 details

| | Hero of the Year | |

Winner: BMMJ13
Quina Quen
Forum Addict
Posts: 4563
Joined: Thu Jul 07, 2005 12:22 pm
Alternate name(s): Diamond Dust

Re: Calculators

Top techs compared to mine? Quadratic increases? I'm confused :smt022

This is an example of the attack techs (as they stand for me).

Weapons SuperCharger (increases all unit attack weapons power) 5,000

Cost to interface a new power cell is - 250,150,000

Ok, so I buy just 1.

Cost to interface another is now 250,200,000

Let's buy just 1 more to see if the pattern is consistent.

250,250,000

Ok, so we know that the increase is by 50,000 each time. How the hell do I make Excel deal with this information ;)?
The ascended entity formerly known as Diamond Dust
User avatar
Thel
Forum Irregular
Posts: 390
Joined: Mon Sep 06, 2010 12:53 pm
Alliance: ~Cloud Village~
ID: 1946016
Location: Ireland ;)

Re: Calculators

General Riviera wrote:Top techs compared to mine? Quadratic increases? I'm confused :smt022

This is an example of the attack techs (as they stand for me).

Weapons SuperCharger (increases all unit attack weapons power) 5,000

Cost to interface a new power cell is - 250,150,000

Ok, so I buy just 1.

Cost to interface another is now 250,200,000

Let's buy just 1 more to see if the pattern is consistent.

250,250,000

Ok, so we know that the increase is by 50,000 each time. How the hell do I make Excel deal with this information ;)?


x = (x-1) + 50000
so for example B1 = 50000
then use the formula to get B2
B2 = B1 + 50000
B2 = 50000 + 50000
B2 = 100000

I think in excel you have to put a "=" in first to show its a formula so it would be =B1+50000 stick that into the space B2 then drag it down and it should auto fill the rest.
Then the column A can be how many you've bought.

Also I should point out that sometimes games like this have a price increase after a certain amount reached, it might go up to 100000 a cell :-k
Image
Image
Image
War does not determine who is right - only who is left.
Nothing is true, Everything is permitted.
War....war never changes.
Quina Quen
Forum Addict
Posts: 4563
Joined: Thu Jul 07, 2005 12:22 pm
Alternate name(s): Diamond Dust

Re: Calculators

Hmm, a price increase would screw up the formula for certain. Not only that, it's going to be incredibly difficult to determine if and where these spikes appear.
The ascended entity formerly known as Diamond Dust
User avatar
Scenester
Forum Regular
Posts: 624
Joined: Tue May 12, 2009 2:08 pm
Location: Za Netherlands

Re: Calculators

The only thing you'd might want an excel calc for is UP,
For techs its simple, if you have 5000, and want to see howmuch 1000 more cost, just bank all your naq, and type in 1000, it will now say (for me)ontop of your screen:

Technology Center
Not enough resources (781,791,660,000) to upgrade!


With UP it will just say
Training
NO RESOURCES LEFT!!!


S1eepy always had some calcs, but since it differs each era and he hasn't played for a while I doubt he will bother...
Mothership The PukingRainbow
Image
Quina Quen
Forum Addict
Posts: 4563
Joined: Thu Jul 07, 2005 12:22 pm
Alternate name(s): Diamond Dust

Re: Calculators

Ahaha, that's actually quite clever Scenester! ;) Just goes to show, the simplest solutions are often the most overlooked.
The ascended entity formerly known as Diamond Dust
Locked

Return to “General”