Originally Posted by Saltycracker
-Additional mastery increases damage at a linear rate. Simply 1% increase in mastery directly translates to 1%*TEB/4 in damage due to the monk generating the same number of TEB stacks. Each stack just does more damage.
|
I didn't delve very deep into your spreadsheet, but i think this is a flaw in the crit/mastery comparison. You don't use homogeneous formulas for crit scaling and mastery scaling. You write that mastery increases damage in a linear fashion, but you don't use the same "type of increase" for crit. What you're doing is :
Mastery scaling = Damage(1% mastery) / Damage (zero mastery)
Crit scaling = Damage(current_crit + 1%) / Damage(current_crit)
You can of course say that mastery increases damage linearly, but then you should do the same for crit and make 1% crit being a 1% damage increase, instead of a 0.76-ish if you have a "base" 32% crit. Thus you should either calculate :
Mastery scaling = Damage(1% mastery) / Damage (zero mastery)
Crit scaling = Damage(1% crit) / Damage(zero crit)
Modified spreadsheet :
http://www.filedropper.com/rotundwin...difiedabsolute
OR
Mastery scaling = Damage(current_mastery + 1%) / Damage(current_mastery)
Crit scaling = Damage(current_crit + 1%) / Damage(current_crit)
Modified spreadsheet :
http://www.filedropper.com/rotundwin...difiedrelative
(the Excel files were uploaded from my French Excel document, i hope the formulas will be translated)
The second option (which is probably the more relevant) is mainly about replacing your formula in V3 :
vlookup(1+round(V27,1)/100,A:Y,16)/4*.01
by :
(1+((V25+1)/100)*(vlookup((1+(round(V27;1)/100));A:Y;16)/4))/(1+((V25)/100)*(vlookup((1+(round(V27;1)/100));A:Y;16)/4))-1
Both ways of calculating scaling will give crit>mastery in your spreadsheet, unless you have a lot of haste (about 25%+). What you did in the original spreadsheet was a handicap for crit, because you said :
- Going from 30% crit to 31% crit is an increase of 1.31/1.3 - 1 = 0.77%
- Having a 4% overall damage increase from 1% mastery is an increase of 1.04/1 - 1 = 4%
Instead of either :
- Having a 1% overall damage increase from 1% crit is an increase of 1.01/1 - 1 = 1%
- Having a 4% overall damage increase from 1% mastery is an increase of 1.04/1 - 1 = 4%
OR
- Going from 30% crit to 31% crit is an increase of 1.31/1.3 - 1 = 0.77%
- Going from a 16% damage increase with 4% mastery to 20% damage increase with 5% mastery is an increase of 1.2/1.16 - 1 = 3.4%
Am i correct, or do i misunderstand your spreadsheet ?