Why even make this when a superior spreadsheet already exists?
I don't know. I made it for myself originally but decided to post it because there was a lot of comparsion going on. It does have more rows compared to yours but I haven't seen yours before so I wouldn't really know. Hell, its probably great and might as well be better than mine and kudos to you if it is.
Secondly, this spreadsheet is completely unnecessary for calculating Keen vs Intense vs Quick. Why? Because the only metric a player gets to control is power, crit rate, weapon choice and weapon rolls. Power isn't relevant in this case, and my thread already answered everything else for every kind of player
It can be used for that purpose. Like I said, it wasn't a tool dedicated to that only use. You need to consider power to compare etchings and such which was one of the functions I made for this to do.
Not only did you not include maths for berserkers or for 75% up time, you didn't even differentiate the base attack difference between VM and Discovery. You opt to use values (1.009, 1.018) only for VM4+15
What? It's 1.009 whether or not its enchanted at all. Also, I don't understand why I would have to compare Disco to VM. Elaborate please. As for the zerker stuff, I already mentioned it. I don't know enough about those classes and stuff to represent them mathematically properly.
Finally, despite acting so hostile and pretentious towards other theorycrafters
Uhh... okay? How am I hostile. All I stated was that an arbitrary comparison using various stats between two types of weapons, whilst interesting, doesn't help the population because everyone has different stats.
I have strong doubts about your formula for two reasons:
That's an assumption
It's been fairly accurate for me on skills that don't have a glyph that modifies crit rate for rates between 150-250. This is really your word against mine, and even though I admit it's most likely inaccurate, it's still far better than .18.