Originally Posted by TheeTova
On the agi tab I do reference the stat weight from the Results tab and times that but agi needed per dodge. That is then combined with the stat weight agi gets from providing crit. Should be right.
Could you elaborate on how 42% to 43% less damage is different percentage wise that 60% to 61%. If get hit for 100 have 42 to 43 reduces the damage by 1 and 60 to 61 reduce the dam by one relatively.
|
The glyphed SD stuff looks good.
I think Quincunx is right about Agi!B1. It's divided by Results!G15 which is Agi per crit, whereas Results!G16 looks like the correct cell (Agi per dodge). Another way to look at it is both Agi!B1 and Agi!B4 are divided by the same cell. With the change, Agi goes up some, but it doesn't seem to change any gemming choices.
Also, I think what Quincunx is saying is that when the damage is
reduced from 61 to 60, that's 1/61 (1.6%) damage reduction, but when the damage is reduced from 40 to 39, that's a 1/40 (2.5%) reduction. At least that's what I think is going on, but I've been looking at it a while and am still confused if it applies to the spreadsheet. It seems to me that any increase in total avoidance can be considered equal independent of its source (whether that be dodge or armor).
Anyways, I think it would be interesting to look at no-dodge, worst case scenario up to some certain "effective health" cap, and then look at normal-case, average dodge past that. Hopefully while also including the percent damage that is mitigatable. Then we could even include stamina in the mix.