Guide How Damage Is Calculated.

I need help....

...is it normal that this list is totally different from the multipliers you used in your excel calculator?

Spoiler: multipliers in excel

---
---
---


Also I've tested my BUILDer (this thing) with an assassin build... I entered the same values in your calculator (here) but the results are different (example spinattack):

my BUILDer and your calculator:

plz forgive the fidget spinner.... I don't know what icon to use for spin attack ;-;

As you can see the results are different ... I checked all the math and the formula between my BUILDer and your calculator and the only difference I've found (and tested to verify this is the problem) is this:


(I don't really understand this excel formula, but I get that the MAX(...) part is the actual formula to calculate the damage)

You use "$K$4+$B$11*G46" that translates to "(NeutralMinDamage * elemMultiplierThunder) + ???"...
what's that ??? ($K$4) ?

$K$4 is this cell:

that gets its value from Powders D11 cell:

Spoiler: another thing that might be wrong

in that formula:

shouldn't H4 be multiplied by 4 and not 3? (like we have F4 * 2, G4 * 3, I4 * 5.... H4 should be 4 no?)

I don't understant that formula so I'm probably wrong anyway....

and at this point I'm not able to understand this anymore.... anyone can explain me how that 85 is calculated?

Thanks!

 

*Feels like using Arial font*

That's because you had 3 T6 Thunder Powders in the list when you took the picture. 3 T6 Thunder converts 84% worth of Neutral into Thunder, so that section is there for the powder spell damage conversion. (It differs spells by spells, which confused me a lot.)

you're a genius
good job on the UI btw, I admire your skills

You probably haven't taken Powders into account in your calculator. I ended up using such messed up codes to calculate the damage properly.. so I'm not blaming you if you don't understand at a glance. :P

Code:

=IF(SIGN($K$4+$B$11*G46)=0,0,MAX((($K$4+$B$11*G46)*$L$14-$M$25)*$C$20*G43,0))

Firstly this formula tests if you have any Base damage in that Element (IF and SIGN part), and if you didn't (which is true for this IF query), it returns "0" to prevent outputting the damage when you do not even have the damage in the element but because of the Element Defense values.

K4 cell refers to the sum of the original Elemental Base damage of the weapon and the additional Base damage from the powders you have put on.

+16 Air Base damage to min. Base damage, +18 Air Base damage to max. Base damage, in this example.

So in your example, K4 cell shows 85 because the min. Base damage of Cataclysm is 70 and the additional min. Base damage by 3 T6 Thunder Powders is 15 (5 x 3). I personally call that "85" number a "Powdered Base."

Back to the main damage formula, (K4+B11*G46) is what the formula refers to the min. Thunder Base damage, where K4 refers to the "Powdered Base" including original Base and Powder's Base, B11 refers to the original Neutral Base, and G46 refers to the Spell Neutral Conversion Rate (to Thunder) which is 100% for Spin Attack as you have 84% Neutral->Thunder conversion rate from your powders.

And that makes your min. Thunder Base damage for Spin Attack to 155, with all the powders and neutral conversion rate considered.
So your Builder's formula (for Spin Attack min. damage) should NOT have been this:

Code:

70 * 4.3 * 2 * (1+(42 + 67 + 33.3 + 70.5) / 100) ≒ 1883

but this:

Code:

155 * 4.3 * 2 * (1+(42 + 67 + 33.3 + 70.5) / 100) ≒ 4170

That part calculates the "Powdered Base" from the sum of the original Elemental Base damage of your weapon and the powders' additional Base damage.
H4 signifies the amount of T5 Thunder powders you have, and the min. additional Base damage of them is 3, so that's fine.
https://forums.wynncraft.com/threads/powder-stats-for-damage-and-defense.152981/

Yeah the powder part is what confused me a lot while creating that calculator... gl :P

 

Yep... I'm stupid.

Thanks :3

Understood ... now I just need to think how to translate this into code D:


thanks!

 

It seems to be, through a few tests, that Chain Lightning doesn't diminish in damage as it goes.

 

I'm pretty sure about that, the damage of Chain Lightning does decrease as it chains.
My calculator works as well, although it's still not 100% accurate for each Thunder damage, the other elements damage seem to be calculated correctly.

 

Yo this is helpful... but i rather go do calculus instead SO MANY WORDS

 

From what I can tell thunder doesn't seem to change, though it's such a random assortment of damage it can look like it does.
I will, however, test for myself more, and get a few screen shots.
ok after a few more test I got a screen shot.
http://prntscr.com/ft7yjd
as you can see on the first hit of chain I did 3791 thunder and 3246 fire, on the next hit I got 5242 thunder, and though you can't see the fire damage it was 3100 in game, on the last one I managed to get in this screen shot, I had 4509 Thunder and 2911 fire.
as you can see my thunder damage varied a lot, though my fire did slightly decrease through each hit.
maybe the thunder isn't affected for some reason, or maybe thunder is so random that it doesn't seem to effect it, but really it is.

 

Well I don't think if that single screenshot will be enough, and what is more, thunder damage in Chain Lightning (hopefully) refers to your weapon's both Neutral and Thunder base damage, which means it probably has more possible dmg output range.
My guess is that thunder damage in Chain Lightning refers some extra boost or base damage, than what I am currently aware of.

 

I may refer to this one screenshot, but that's not to say I didn't have more, actual in total I toke 5 all seem to do the same thing. though this is what I was trying to say, I think the randomness of thunder makes it reliable to say it doesn't seem to decrease because of the possible damages rang.

 

What about your other elements? If those decrease as it chains, it's natural to think thunder damage does as well, that's what I'm thinking. At least I'm pretty sure Air does.

 

like I said, I assume it does as well, and the only reason it seems to stray is the range of thunders damage. though, its worth more looking into.

 

oh okay, I guess I just didn't understand your words xd
And yes, I'll be looking into what other elements may affect for thunder chain lightning damage. Currently my theoretical damage and actual damage in-game doesn't completely fit, so that's why.

 

ok

 

If with my build I reach (example) 50 strength points and my weapon gives me +10 stength points, when I calculate the damage should I use 50 strength or 60 strength?

 

60

 

As a guy who loves stats and enjoys looking at things like this, I still had a hard time understanding this, the amount of time you put into finding the correct attack speed stats along is insane, great work motoki, You have earned my respect.

________________________________

If you have a weapon that gives you a + in a skill category, you will count those stats in that category only when the weapon is being held in your hand, if it is in your inventory or hotbar but you are not holding it out, then the skill points you should apply would be the amount given by your actual points, any armor or jewelry, and the other item you are holding in your hand(if it has skill point bonuses)

 

@PlanetCookie founda bug in wynndata calculator .... so I tested it out and it seems to be a bug in your excel calculator too so I was hoping we can sort this out..

Basically he tried a build with a lot of raw spell damage (1403) but, in the calculators, arrow storm was dealing 140.3 (so raw spell damage * spell multiplier (0.1)) but, after a few tests in game, we found out that the neutral isn't multiplied by the spellMultiplier but its added as neutral as it is (so this build should do 1403 per arrow neutral).

I made a few tests with a random build (papyrus for some raw spell and Ensa Resolve):

Here's wynndata build calculations: click
Here's your excel calculator with the stats: click​

All inserted values are the same and in fact the arrow storm damages are pretty much the same (just some difference caused by round).

The problem is that I should make (per arrow) 11 neutral ~70 water ~55 air but instead...

 

(I hope I'm right in this case)
There is a bug with damage indicator when Raw Spell damage is involved, thus the actual damage and damage shown on the indicator are different.
If you're able to check, you're actually doing the damage with Raw spell damage that is multiplied by spellMultiplier, different from what the indicator shows.

Hopefully Jum is aware of this (because there's an issue on Wynn GitHub), but I'm not surprised if it's still not fixed, the current Wynn code is probably like a mass ball of mess..
https://github.com/Wynncraft/Issues/issues/7607

 

I'll try to check this asap (and I'm really hoping this is just a visual bug too....)

 

Took me a while but...



Detlas cizited = 20.000hp
Hp after 2 arrow hit = 19660
Damage taken = 340

Total elemental damage = 96 + 81 + 1 + 62 + 71 = 311
Neutral damage per 2 arrows hit = (340 - 311) / 2 = 14,5 damage neutral per arrow .... definetly not 97.



its just a visual glitch, our math is correct YEY