Hell, its probably great and might as well be better than mine and kudos to you if it is.
You need to consider power to compare etchings and such which was one of the functions I made for this to do.
I didn't make the spreadsheet. It was someone else. It's better for 2 reasons:
It doesn't require you to go into the stat page and dig information, it works like a check box system.
It tells you exactly how far the DPS is off by, without having to go through manual calculations.
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.
Weapon, rings, necklace and brooch all give attack. The latter 3 is constant regardless of what weapon you use. The correct formula for each generation is therefore:
For Keen:
(WEAPATTK * 1.02 + (ring / neck / brooch)) / (WEAPATTK + (ring / neck / brooch))
For Quick:
(WEAPATTK * 1.01 + (ring / neck / brooch)) / (WEAPATTK + (ring / neck / brooch))
You don't need to be a maths wizard to realize that since (ring / neck / brooch) is constant, the higher your weapon attack, the closer the value will approach 1.02 and 1.01 respectively.
Uhh... okay? How am I hostile.
http://www.reddit.com/r/TeraOnline/comments/2y3gdb/quickkeenintense/cp642ni
Not only were you being a pretentious twat, you even dared to write:
Shrug. This is with more crit damage than your formula used, and with less crit chance overall, meaning that crit rate is even more valuable as it's not as diminishing in terms of dps.
Even though you reduced the crit rate conversion constant. Which is by far the most significant statistic for value of crit rate. Making your reasoning absolutely flawed.
- 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.
If you multiply a player's crit rate by 0.0018 for back and 0.001 for front at 75~85% back crit up time, you'll get far closer results than the equation you use.