|
Originally Posted by deathmancer
A few anomalies:
1st: for the Destruction-ruin setting you have a full listed as .5 and a none as 0, however you put 1 in the setting column. The multiplier at the top is also taking .5 and adding it to this value. Currently a 1 will set the crit multiplier to behave normally, a 0 will make you crit for half damage and a .5 will make you crit for hit damage... unless i'm reading this wrong.
|
Cell for ruin talent value should have 0 if you dont have ruin talent, or 0.5 if you have. That will add in 'crit multi' cell to 0.5 as you noticed, which will result in value showing how much bonus damage you get from crit. If I remember correctly, we have 50% bonus crit damage without any talent, and ruin increase crit for '100%', basically making bonus crit damage 2*50%=100%.
According to that, I consider that when you crit. total crit damage is calculated as NoCritDamage+ NoCritDamage* 1 if you have ruin, or as NoCritDamage+ NoCritDamage* 0.5 if you do not have bonus, where 0.5 or 1 are my cell 'crit multi'. Based on that, I calculate average spell damage as
AvgSpellDmg= NoCritDamage+ NoCritDamage * CritMulti * Crit%
Also 2nd: you are accounting for crit by multiplying by a % and doing another multiply to account for miss%. The game does a single roll to determine whether or not you have a hit crit or miss. The roll for partials is another roll however.
If you had 5 hit and 10 crit and you were up against a +3 level mob (17% base miss) then the roll table would be something like this:
1-10 crit
11-88 hit
89-100 miss
|
yes, I know that, but basically difference is small for normal miss/crit values, and it always apply across all builds - and considering I initially did not treat misses at all, I ignored this case ;p
But I changed anyway in XLS, and i used simpler method , for which I hope i was correct. Basically I divided my 'Crit Multi' by ( 2- MissRate)
It is based on :
RealCrit% = Crit% / (1- Miss%)
If Miss%=1%, then RealCrit%= Crit%/(1-0.01)= 1.01*Crit%
In extreme case, where Crit%=40% and Miss%=60%, RealCrit%= 0.4/(1-0.6)= 1 = 100%, as it should be
Since MissRate in my XLS is shown as 1+Miss% (1.14), (1-Miss%)= (2-MissRate). And since 'Crit Multi' is multiplied to every Crit% in calculations, I just divided Crit Multi with that value.