Archer Queen hits per defense

[AMGamboa]

First of all this is my first thread in the CoC forums so please forgive me if I posted this in the wrong section.

Anyway, I've been searching around the internet and so far I haven't found a table or list that shows how many hits it takes an AQ to destroy a certain defense (depending on level). The reason I was searching for this is because I wanted to know what level I should leave my queen while I focus on my BK. This is especially useful now with the new AQ walk strategy.

Now, I understand that this is not all that useful to everyone especially since it only shows the number of hits to destroy defenses and not yet trash buildings, but I will update this soon when I have the time. I just wanted to share it in case some find it useful or if anyone has could leave suggestions, comments, and corrections to actually make it more useful.

-A QUICK GUIDE ON HOW TO USE THE SHEET-
Legend:
AT = Archer Tower
Ca = Cannon
Mo = Mortar
WT = Wizard Tower
HT = Hidden Tesla
AD = Air Defense
XB = X-Bow

The table is pretty straightforward. It shows the level of the AQ and how many hits it takes to destroy a defense BASED ON THE TOWN HALLS MAX LEVEL OF THAT DEFENSE (eg. for TH9 a lvl 11 Archer Tower and Canon, lvl 7 Mortar, Wiz Tower, Tesla and AD, and lv 3 X-Bow). As a reference you can refer to the 2nd sheet called "Defense HP" which shows the HP per defense level and color coded based on TH level (Yellow = TH7, Green = TH8, Blue = TH9, Red = TH10)

If it still doesn't make sense feel free to ask. I feel like I explained way more than I needed to

EXCEL FILE: https://drive.google.com/file/d/0B-2...ew?usp=sharing

[Jeeei]

wow well done mate! lot of work gone into that
Might be interesting to add in hits needed when in cloak mode too?

[Saleh47]

Good job mate putting all the info in such a clear and easy to read way. Would also be better to add while ability is activated as well

[Micheallo]

Good job mate putting all the info in such a clear and easy to read way. Would also be better to add while ability is activated as well

Alright saleh calm down there is no way of actually doing that with the endless possibilities of ways of activating the ability

[Micker99]

Awesome job! I did this on a piece of paper the other day lol. Was trying to see if I should level my aq or BK. Went with aq to 37, BK at 35 still.

Your chart is just against max defenses, just so people know. At th10, there are a few levels of Defenses, so there are even more one hit less jumps at certain levels.

Very cool though, how many hits it takes to take out a defense is what really matters, not dps. Some levels you will notice a sliver of hp left on a defense after a few aq hits. So she way over kills it and wastes time needing an extra shot.

[AMGamboa]

Thanks everyone! I tried to make it look as clean as possible. I was also thinking of adding the hits needed while using the cloak ability but I'm not entirely sure yet how I can sneak it in without making the chart look too clustered. (Especially since I might be add trash buildings in the near future as well)

Very cool though, how many hits it takes to take out a defense is what really matters, not dps. Some levels you will notice a sliver of hp left on a defense after a few aq hits. So she way over kills it and wastes time needing an extra shot.

I agree, that's one of the reasons I made this chart because the DPS alone isn't enough to calculate the hits to destroy a building. Which is also why I didn't bother adding the Queen's DPS in the chart and instead showed the damage per hit which is more useful to know anyway.

[Saleh47]

Alright saleh calm down there is no way of actually doing that with the endless possibilities of ways of activating the ability

How? When ability is activated the queen will have constant damage for a set amount of time. So it is possible. Not talking about she was hitting the defense then activated the ability(in this case yes we can't know)