PDA

View Full Version : New - Commander Tool



SGT Rud
10-09-2013, 09:12 AM
Wanted to say thank you again to Sledge 187, for his Health Regen Calculator a while back. I have added to it with a few other useful tabs.



Version 1.2

Has a new LTQ Energy Calculator - Able to have some #s plugged in and can calculate gold usage.

Has new Stamina Calculator - For those LTQs that require stamina. I also left it open in the event boost units ever roll out that effect stamina. I also wanted to keep the same layout between all the tabs but lost that layout during the faction LTQ portion.

Faction LTQ Calculator - Same thing as above, but tracks a whole faction.

And a new fortification calculator - informs you of cash and concrete costs.

Health Regen tab - Has been updated with boss health information. It now has an estimation block that can estimate how many free hits/cash hit/gold hits you need on bosses past 50. Can also calculate an estimate on total gold usage.

-------------------------------------------------------------------------------------

If you have any feedback, please let me know. Travis and I are both still running this doc to keep it moving and updated.

https://docs.google.com/spreadsheet/ccc?key=0ArpQRbEVWmWUdHZkd09xbG5vcEF6RldkZF8yV25NU mc&usp=drive_web#gid=10

This is open to the public, and you should only be allowed to change whats in yellow. Please download it for your own and faction use as to not mess someone else up who may be using it online.

SGT Rud
10-09-2013, 09:18 AM
I am missing 3 blocks of the bosses health, if the bosses health changes later, we can adjust and make changes to the doc and repost it. Also had to make some adjustments on the wall calc.


If you have any comments, please feel free to PM me.

This will be the last update for a while as I cant think of anything else it needs.

SGT Rud
10-09-2013, 11:18 AM
The boss health estimate was about as accurate as Travis and I could get it.

Kefa
10-09-2013, 11:36 AM
Thanks, that's awesome!

Kill Joy
10-09-2013, 11:52 AM
Thank you for taking your time to put this together

Emmerich
10-10-2013, 07:19 AM
Love this - thanks to everyone who participated in making it, and thanks to SGT Rud for pulling it together. :)

YJSONLY
10-10-2013, 08:00 AM
NEAT :eek::eek::eek::eek:

Mark-1
10-10-2013, 11:24 AM
Nice job guys. Really nice tool.

General Maximus
10-10-2013, 11:39 AM
Nice work!

S&H Max
10-10-2013, 12:25 PM
SGT I think your gold usage is wrong in two ways :

if you need 17 gold hits thats is not 80 gold for sure, 17 mega hits is 340 gold.

Maybe you could only count cash hits and for every 5 hits more than your max use 20 gold that would give a better estimate.

the other thing I see is that it only record gold usage for 80+85+90+95+100 but you still have to kill each boss inbetween those 5


Still sharp to help figure out when you need to start to use cash hits and when you need to plan starting using gold!!!

SGT Rud
10-10-2013, 12:44 PM
SGT I think your gold usage is wrong in two ways :

if you need 17 gold hits thats is not 80 gold for sure, 17 mega hits is 340 gold.

Maybe you could only count cash hits and for every 5 hits more than your max use 20 gold that would give a better estimate.

the other thing I see is that it only record gold usage for 80+85+90+95+100 but you still have to kill each boss inbetween those 5


Still sharp to help figure out when you need to start to use cash hits and when you need to plan starting using gold!!!

The 17 gold issue has been corrected. As for the other, we are still working on that formula. I will keep everyone posted on its progress. If you have it saved on your google docs, you can copy the single page over and replace your old one. If you have downloaded it, you can do the same or download a new version.

I am sorry for the trouble.\

S&H Max
10-10-2013, 12:52 PM
no trouble on that

If I was you I would count how many cash hits are needed, than susbtract the number of hit you can with the timer, lower by 1min for each refill you need, and split the number of extra cash hits by 5 and thats your number of refill needed X 20 gold

not sure at all if its clear but I'm sure you will figure out what I mean

last boss 240 mil lets say I am 2mil attack when I reach that

240mil at 2mil is 120 hits

I can personnaly do 25 with the timer

so still need 95hits with gold... so 19 refills (20gold each) so 380 gold for boss 100

the little twist is that I need 19min to make those 19 refill and wait my 26sec for the 5th hit

so in reality I need 20 refills because of the last time

so at 2mil attack in last tier boss 100 is 20 refill so 400gold

S&H Max
10-14-2013, 10:42 AM
SGT clean you inbox I can no longer answer you!

SGT Rud
11-01-2013, 08:24 AM
In the next couple weeks, we will be spitting out another update on this with a few minor corrections.

I want to thank RossS and RobieTuesday from RRH for helping on this project as well.

Socks
11-01-2013, 12:46 PM
Good work? Wouldn't know. It requires a Google login- something I'm weary of doing.

John 719166364
11-01-2013, 03:40 PM
Nice job sir.

TheDanimal
11-01-2013, 03:59 PM
Wow. Great work guys!

magic267
12-30-2013, 02:49 PM
+1 Great work and very helpful.