Page 1 of 9 123 ... LastLast
Results 1 to 10 of 83

Thread: Earthquake spell math not adding up - trying to make sense of it

  1. #1
    Trainee
    Join Date
    Mar 2014
    Posts
    13

    Earthquake spell math not adding up - trying to make sense of it

    Hey guys,
    I was trying to make some sense about the earthquake spell, and things didn't seem to be adding up. Am I missing something, or not doing the math correctly haha? What is described in the description/stats of the earthquake spell seems to be different than what is observed in game play. I will be focusing on walls here:

    A lvl1 earthquake spell says it does 6% damage to remaining hitpoints, and does 4x damage to walls. This can be either interpreted as taking 24% damage away from walls, or taking 6% damage away from walls 4 times (0.94 ^ 4 = 0.78075, so that would be equivalent to 21.925%. I will show both below:

    Lvl 1 Earthquake Spell Calculations:
    Spells Used Wall Hitpoints Remaining (using 24%) Wall Hitpoints Remaining (using 21.925%)
    0 100% 100%
    1 100 * 0.76 = 76% 100 * 0.78075 = 78.075%
    2 76 * 0.76 = 57.76% 78.075 * 0.78075 = 60.957%
    3 57.76 * 0.76 = 43.898% 60.957 * 0.78075 = 47.592%
    4 43.898 * 0.76 = 33.362% 47.592 * 0.78075 = 37.157%
    5 33.362 * 0.76 = 25.355% 37.157 * 0.78075 = 29.010%
    6 25.355 * 0.76 = 19.270% 29.010 * 0.78075 = 22.650%
    7 19.270 * 0.76 = 14.645% 22.650 * 0.78075 = 17.684%
    8 14.645 * 0.76 = 11.130% 17.684 * 0.78075 = 13.807%

    Below is what I have observed in the game using lvl 1 Earthquake spells. I got these percentages by taking screenshots of the game after each spell, and using photoshop to count the pixels of the percent bar. I would say this is accurate to roughly 2% or less.

    Lvl 1 Earthquake Spell Observations Vs. Calculations:
    Spells Used Wall Hitpoints Remaining (using 24%) Wall Hitpoints Remaining (using 21.925%) Observed
    0 100% 100% 100%
    1 76% 78.075% 72%
    2 57.76% 60.957% 53%
    3 43.898% 47.592% 34%
    4 33.362% 37.157% Destroyed

    As you can see, what is observed in the game does not correlate with the claimed 6% damage (x4) at all. You can also notice that the observed percentage of damage taken away for each spell is not even a consistent number (1st spell appears to take away 28%, second spell takes away 26%, 3rd spell takes away a whopping 36%!, and then the 4th spell destroys the wall completely).

    Now lets talk about the threshold at which the building collapses. In the earthquake spell description it mentions that buildings with low health will suddenly collapse. The reason for this is that if you only rely on a spell taking away a percentage, it will never reach 0 ever (its an asymptote), so there must be a threshold of some sort.

    I did the above calculations with a Lvl4 spell as well, and the 3rd spell takes walls down to 18%, and the 4th spell destroys the wall. This would imply that the threshold percent we mentioned earlier is less than 18% (like 17%?). In order for lvl1 spells to get a wall down to 17% it would take 7 earthquake spells... but the observed shows it only takes 4.

    And speaking of this threshhold percent, the observed threshold for lvl1 earthquake spell implies that walls will collapse at roughly 25 - 30%, but as you can see with lvl4 earthquakes - the 3rd spell takes walls down to 18% and the wall still remains. Is there different mechanics between lvl1 and lvl4? If that is the case, it almost seems better to leave the spell at lvl1! haha

    So you might be wondering why I care about all of this. This brings up a lot of questions for me:

    1. Is it worth upgrading to lvl4? Some of the above information would go to show that keeping it at lvl1 is just fine, and better in some scenarios.
    2. Is it hard coded into the game that there is a spell counter on the walls, and if any wall gets touched by 4 earthquake spells then it is destroyed - regardless of the damage done to the wall?
    3. What if a wall is already at 72% damage (damaged more than the first spell would do), would it take 4x more earthquake spells to destroy it? It looks like it might.
    4. If you drop an earthquake spell on a wall that is heavily damaged in an attempt to collapse it, what is that threshold? According to a lvl1 earthquake its at 25-30%, and according to a lvl4 earthquake its at roughly 17%.
    5. Is there some kind of a bug/glitch going on here that supercell might want to know about?


    So the only conclusion I can make at the moment is that the game mechanics for earthquake spells is completely different than what is described in the spell description. Let me know what you guys think

    EDIT:
    It was also brought up that it may be 4 multiplicative factors of 1.5% to get the 6%... which would be (1 - ((0.985)^4)^4) * 100 = 21.48%, which would make the discrepancy even larger.
    Last edited by Mahonroy; July 10th, 2015 at 06:51 PM.

  2. #2
    Banned
    Join Date
    Jun 2015
    Posts
    1,557
    The threshold is somewhere between 15-20% apparently, but I haven't seen proper confirmation.

    4 jump spells always break a wall.

    I would imagine they are two separate effects and you cannot mix and match other damage with a couple eq spells to achieve the same results. But this is again just speculation. But this makes sebse, otherwise it would mean lvl1 eq spells can more easily break walls and have a higher threshold than lvl4 spells which obviously doesn't make sense.

  3. #3
    Millennial Club lasmite's Avatar
    Join Date
    Jan 2014
    Posts
    1,049
    Awesome thread!

    As of now I have no personal experience with it, and haven't even read about the statistics and mechanics.
    I found this wiki page if it could help you understand: http://clashofclans.wikia.com/wiki/Earthquake_Spell

    cheers
    All your base are belong to us


    ❤️
    ฅ•ω•ฅ

  4. #4
    Senior Member
    Join Date
    May 2015
    Location
    Oregon, U.S.A.
    Posts
    218
    I haven't unlocked EQ yet, so I can't really contribute to the conversation. But I wanted to say good job for taking the time to do this.

    Kudos, man. Good job.

  5. #5
    Trainee
    Join Date
    Mar 2014
    Posts
    13
    Quote Originally Posted by lasmite View Post
    Awesome thread!

    As of now I have no personal experience with it, and haven't even read about the statistics and mechanics.
    I found this wiki page if it could help you understand: http://clashofclans.wikia.com/wiki/Earthquake_Spell

    cheers
    Thanks!
    As far as the clash of clans wiki you mentioned, this falls under the same discrepancy I am mentioning. This site is not created/maintained by supercell, its a 3rd party, so they can only relay what is mentioned in the game and their own interpretations.

  6. #6
    Super Member AnthonyVince's Avatar
    Join Date
    Mar 2015
    Posts
    968
    I have a question: will 3 Earthquake Spells take down a set of level 7 walls? Or does there have to be 4 spells used to break the walls? Need it for my upcoming war attack - I really hope I only need 3. Because I try doing the math inside my head, and nothing works out.
    Last edited by AnthonyVince; July 10th, 2015 at 07:35 PM.
    Quote Originally Posted by PRODlGY
    Time moves so fast. It's like yesterday it was 2015!
    Quote Originally Posted by Coloradokiwiboy
    I haven't showered since like.. last year

  7. #7
    Trainee
    Join Date
    Mar 2014
    Posts
    13
    Quote Originally Posted by AnthonyVince View Post
    I have a question: will 3 Earthquake Spells take down a set of level 7 walls? Or does there have to be 4 spells used to break the walls? Need it for my upcoming war attack - I really hope I only need 3. Because I try doing the math inside my head, and nothing works out.
    The earthquake spell removes a percentage of hitpoints from walls. With that being said, it does not matter if its lvl1 walls, or lvl11 walls, it will remove the same percentage of hitpoints (so it will always be 4 spells).

  8. #8
    Forum Elder Yoyobuae's Avatar
    Join Date
    Dec 2014
    Posts
    2,484
    Quote Originally Posted by Mahonroy View Post
    A lvl1 earthquake spell says it does 6% damage to remaining hitpoints, and does 4x damage to walls. This can be either interpreted as taking 24% damage away from walls, or taking 6% damage away from walls 4 times (0.94 ^ 4 = 0.78075, so that would be equivalent to 21.925%.
    It's neither. Each EQ spell actually consists of three hits. And for walls the damage of each hit is multiplied by four. For level 4 EQ spell:
    Damage of spell = 12%
    Damage of hit = 4.1% (because (100% - 4.1%)^3 = 88%)
    Damage of hit against wall = 16.4%
    Damage of spell against wall = 42% (because (100% - 16.4%)^3 = 58%)
    Damage of three spells against wall = 80% (actually slightly over 80%)

    The fourth spell then immediately destroys the wall (with the first hit), because the wall is slightly under 20% HP.

    Quote Originally Posted by Mahonroy View Post
    Lvl 1 Earthquake Spell Observations Vs. Calculations:
    Spells Used Wall Hitpoints Remaining (using 24%) Wall Hitpoints Remaining (using 21.925%) Observed
    0 100% 100% 100%
    1 76% 78.075% 72%
    2 57.76% 60.957% 53%
    3 43.898% 47.592% 34%
    4 33.362% 37.157% Destroyed

    As you can see, what is observed in the game does not correlate with the claimed 6% damage (x4) at all. You can also notice that the observed percentage of damage taken away for each spell is not even a consistent number (1st spell appears to take away 28%, second spell takes away 26%, 3rd spell takes away a whopping 36%!, and then the 4th spell destroys the wall completely).
    Not sure if it is a bug or intended, but level 1 EQ spell gets added the same bonus % damage against walls as the level 4 spell does.

    So level 4 spell gets added damage (per hit):
    16.4% - 4.1% = 12.3%

    And for some reason level 1 spell gets added the same damage increase (per hit):
    2.1% + 12.3% = 14.4%

    Thus one level 1 spell actually does:
    (100% - 14.4%)^3 = 63% (meaning 37% damage)

    Then doing the math for four level 1 spells:
    0 spells = 100%
    1 spell =63%
    2 spells = 40%
    3 spells = 25%
    4 spells = 16%
    (hmm, your observed numbers are around 10% higher than my calculations, maybe the HP bar has an offset of sorts?)

    On that last spell the first two hits actually lower the HP down to 21% and then 18%, and it is the very last hit the one which destroys the wall (because HP is under 20%). This also observable in replays (just drop spells one by one, making sure to hit a collector as well to count the hits as they happen).
    Last edited by Yoyobuae; July 10th, 2015 at 08:11 PM.
    Ignore list: rydogg20 bouges jarvee nerfedname Rampantarmadillo JohnSnow83 Vikky CriPpLeR RakeNoris ClashRoyaleTeam AsyanHari
    Quote Originally Posted by TooBizar4u View Post
    Only troop you need is the goblin. The rest are just luxury troops.

  9. #9
    Senior Member Ospite's Avatar
    Join Date
    Nov 2014
    Location
    Italy
    Posts
    222
    If it does a percentual based damage ON THE REMAINING HITPOINTS! Then an earthquake spell can never take out a building! Because a percentage is never the full value except for 100%! For example if you have a building with only 100 Hitpoints remaining and even if the earthquake spell would do 99% damage then the building would still have 1 hitpoint.... So can somebody explain me why earthquake spells can take out buildingS? Maybe I am just dumb in maths! Thanks
    Arrivederci Your Italian Guest
    TH Level: 9
    XP Level:150
    Walls: All Lavas
    King&Queen Level: 25 __ Defenses,Spells and Troops: Fully MAXED OUT for TH9

  10. #10
    Forum Elder Yoyobuae's Avatar
    Join Date
    Dec 2014
    Posts
    2,484
    Quote Originally Posted by Ospite View Post
    So can somebody explain me why earthquake spells can take out buildingS? Maybe I am just dumb in maths! Thanks
    If EQ hits a wall which is already lower than 20% HP the wall collapses instantly. It's a secondary feature of the spell (in addition to doing % damage).
    Ignore list: rydogg20 bouges jarvee nerfedname Rampantarmadillo JohnSnow83 Vikky CriPpLeR RakeNoris ClashRoyaleTeam AsyanHari
    Quote Originally Posted by TooBizar4u View Post
    Only troop you need is the goblin. The rest are just luxury troops.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •