Elitist Jerks - Rogues http://elitistjerks.com en-US Fri, 20 Nov 2009 22:23:55 GMT vBulletin 60 http://elitistjerks.com/images/chestnut/misc/rss.jpg Elitist Jerks - Rogues http://elitistjerks.com Modeling Fan of Knives http://elitistjerks.com/f78/t79100-modeling_fan_knives/new-post.html Mon, 26 Oct 2009 19:37:51 GMT 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
File Type: xls FoK.xls (21.0 KB)
]]> Rogues Leto http://elitistjerks.com/f78/t79100-modeling_fan_knives/