Leto

I have been putting together a spreadsheet to model fan of knives damage and sustained dps, and have decided to share my work with the hope of refining the model through wider scrutiny.


Goals of the spreadsheet:

• To help determine the optimal combination of weapon types, speeds, talents, and ability usage for varying AoE situations.
• To refine the fan of knives model for use in future analysis.

Notes on the model:

Currently the spreadsheet only models the dps from FoK (and poisons proc'd by FoK) alone, though I have done my best to account for multiple sources of energy regen.

I modeled the focused attacks procs from fan of knives itself by effectively reducing its energy cost, while focused attacks procs from autoattacking add to the energy regen per second field.

Slice and dice is present as a binary state to affect the energy regen from autoattacking; the model does not consider the cost of maintaining slice and dice, but some elements may be valuable in additional analysis of its maintenance cost.


Notes on the spreadsheet:

All the settings are controlled on the "Main" sheet. Most raid buffs/debuffs are assumed, but there is the option to disable sunder or faerie fire. Most settings are handled with a binary value (1 for true, 0 for false), but some talents use the number of spent talent points.

I obtained most of the stats used by entering my gear into Aldriana's Combat spreadsheet then manually entering the values into my spreadsheet; armor penetration and haste use paper doll numbers.

Some of the buffs are split into two options: the sustained increase granted by using that buff on cool down, or the effect of the buff on FoK dps while the buff is active.

The sheet will automatically determine whether to use wound or instant poison based on the damage per hit, but enabling deadly poison will force its use in the off hand.



I would appreciate any and all feedback or assistance verifying the accuracy of the formulas in the calcs sheet. I apologize in advance for the low ease of use, but I tried my best to make the formulas easy to understand without excessive abstraction into multiple cells.

Please feel free to let me know if you have any questions about the current model or how to use the sheet.

Attached Files

FoK.xls (21.0 KB, 324 views)

Rogue at heart.

 

Aravan

It is not a bad start; however, you should consider including the damage cap on AoE spells. For instance, in Onyxia 25 man, the start of phase 2 has a good number (>20?) whelps. When I head in to FoK the damage does cap out, but the poison damage does not. Also the energy return from the T8 bonus makes it possible to energy cap me every GCD.

 

Leto

I've updated the spreadsheet to include the 3.3 AoE cap mechanics:
The pre-crit damage per hit is modified as follows:
dmg*10*(1/Max(10,Target_Count))

Poison damage remains unchanged.

I've also placed a cap of 1 FoK per second to account for the gcd.

Rogue at heart.

 

MassMan

One thing I have been wondering is whether HnS can proc multiple times from a single FoK?

Onyx whelps or Yogg+0 would be suitable scenarios to test it, but alas I don't have proper swords.

 

bural

To the best of my knowledge it can't.
This test was done over an hour using nothing but Fan of Knives while facing away from my current target while hitting 4 targets with Fan of Knives: World of Logs - Real Time Raid Analysis.
I didn't calculate the level reliatibility of the test but there isn't a single occurance of 2 successive Hack and Slash procs.

 

Leto

Wouldn't facing away from your target prevent HnS procs from hitting it? I'm not sure, but I would imagine HnS interaction with FoK would be similar to blade flurry's interaction, where FoK attacks would proc HnS on your target if it's in melee range.

I'd imagine the best way to test this would be to FoK multiple targets while in melee range without autoattacking your target, and use an axe in one hand, switching after multiple iterations to see if it can proc only from specific hands.

Rogue at heart.

 

bural

Yes, it does prevent the HnS proc from hitting anything, but you can't destinguis the proc from autohits without looking closely at the timestamps anyway. Even though the HnS proc can't hit anything, you still get the proc message, so you'd still expect to see successive messages of "1 extra attacks from Hack and Slash" prior to the FOK that actually procs it.

It can proc from offhand hits, but apparently never more than once per FOK. I had a lenghty discussion with a GM about it who at first was convinced it was only supposed to proc off off hits on your current target due to the tooltip. Took a fair bit of conversation and a few FOK hits while outside melee range of my current target to convince him otherwise. Eventually, he agreed the the limitation of 1 extra attack when damaging is really 1 extra attack when damaging per ability.

 

cerin616

Edited due to more information recieved

And i di in fact like the idea this spreadsheet brings up. You do in fact have the ability to switch weapons in mid combat, so a rogue looking to fully optimize himself (lets say in Onyxia) can use his/her usual weapon combo for the first phase, then when whelps spawn, pop a macro switching weapons that are already poisoned before the fight.

Excellent post sir.

 

bural

You'd expect 8 FOK hits to produce a HnS proc 8*0.05=40% of the time when using FOK and a double HnS proc 8*0.05*0.05=2% of the time. With 500 succesfull FOKs in a row the chance of not seeing a single double proc is 0.98^500=4.1*10^-5 or 0.0041% while expecting to see 10 double procs in total.

 

cerin616

Now does this mean we can never see 2 HnS in a single FoK? or is there a chance one mainahand hit can proc one and one offhand hit can proc one?

 

ravenhldt

So, if I'm understanding Bural's analysis correctly, then it follows that the expected outcomes when performing FoK with double HnS weapons is:

* Gaining Double HnS : Zero (chance should be 0.05*0.05, but only 1 attack happens)
* Gaining No HnS: 90.25% (0.95*0.95)
* Gaining Single HnS: 9.75% (1 - 0.95*0.95)