Particles wrote:Can felstriker proc on misses/dodges?
Not in this sheet; the totmh/s and oh/s numbers showing in that area of the sheet is shown after eventual misses/dodges has occured. If you click on the individual data (MHswings/s as example) you'll see that it accounts for those occurances. From what I have heard on Nostalrius certain procs can occur on misses and dodges, which of course wont be featured in the sheet unless there's a reliable source that states that X can proc in such manner.
Particles wrote:The felstriker proc damage also seems to be off. In the spreadsheet you calculate how many ss, MH, OH, and evisc will be affected by felstriker every minute, and then say felstriker is providing that times the crit modifier damage every minute.
Bit my tongue on this sentence, the fault is at (Damage_calculations!)AM28:AP28 and AM34:AP34. MHAtks factor in the miss chance on attack for the amount of time and provides that they are criticals, same applies to OHAtks whilst SS/Evisatks gains a critical strike boost. Due to the damage calculation in the above quoted cells currently factors the crit gain to dps as a whole, the factor was overvalued at ~1.53 (from ~26 to ~17dps when equipped in MH).
There is however a gain in the hitrate that I see is not fully accounted for hence the <2 factor. This hitrate gain needs to be calculated with an standalone to the MHswingsetc/s that only accounts to the unavoidable dodge chance on mh/oh hits in order to provide accurate gain from the hit gain during the uptime. I will most likely stick with the same uptime formula, although in reality the uptime may be a few 0,0XXsec higher than what stands in the sheet due to the increased chance to hit during the felstrikers uptime.
I will see if I can get this done before tomorrow, remember to turn back the clocks tonight
Edit (for Aslan)Aslan wrote:What was your calculation concerning crit cap based on on the spreadsheet, 5.6% dodge and the miss rate? 24.6 or 27?
Or following "vanilla"-wiki with the -2% miss reduction on 305 wpn skill and then the blabla formula there?
In terms of the base miss I went with the known blizzard value of 24,6%. In terms of calculating the crit cap in the damage_calculations spreadsheet you will see that depending on the choice of opponents the amount of glancing hits will vary (and thus increasing/decreasing the crit cap). In terms of the formula where the amount of hit gain/loss is greater after 11 skill points, it's a work in progress on the hold list as every raiding rogue will by default not be affected by it (315-305=10). When I however start adding more lowlevel items and the players choice to configurate their own levels this is something that I will need to implement (as players leveling are not bound to have +5skill from talents). I need to state though that obviously the difference between the opponents defence skill and your weapon skill will have affect on the dodge and miss chance.
Best of regards
Soyoen