Hi all
Inspired by Yiktiki's excellent Beastlord spreadsheet i've been using a spreadsheet myself now for some time to calculate weapon dps and generate a weapon ranking to help me decide with weapon upgrades.
I felt it was time for an update, because the old calculations using modal damage simply weren't sufficient anymore in today's EQ, and so many weapons have procs now (augmented or not) that you cant simply ignore them. So I've used the results of my recent ATK and proc rate parses to make the calculations better.
I've cleaned it up a bit and added notes to certain cells so i hope it'll be relatively easy to use. Link to the latest version of the Excel spreadsheet is here:
dpscalc.zip.
Its in ZIPped format. If you don't have Excel, there's a link in Yikitiki's beastlord spreadsheet post in the Library forum.
Features:
1) Uses your ATK rating to calculate average damage per hit. Should be accurate in the ~900-1900 ATK range
2) Incorporates the effects of many AA skills that affect weapon dps
3) Also calculates proc dps (for DD and lifetap procs only so far), based on your Dexterity, and uses an equivalent proc damage for weapons for pet procs.
4) Incorporates elemental damage (but not bane damage)
5) pc- and moblevel hitratios and proc resist rates
What it
doesn't do:
1) Give the complete list of all BST-usable weapons. It's a lot of work putting in all the details (i had to add a few more then given in Yiktiki's sheet, so it's more then a cut-and-paste job). Frankly, i could use y'alls help with this. If you see a weapon missing from the DB and know all the details (the ones in the grey fields), pm them to me and i'll add em
2) Give exactly the same dps numbers as your parser does. There are several reasons for this:
- Calculations are based on ideal conditions, that is 100% uptime. In reality combat casting, getting stunned, out-of-range etc will lower your dps. This effect gets worse as the base delay of the weapon gets faster. Also, calculations remove the statistical variance which can be quite large in short parses.
- No riposte damage. Riposte damage increases with the base damage of the MH weapon. Effect is very small tho and won't change the ranking significantly
- Your parser may not be giving you the correct dps number either. Determining the exact fight-time isnt as easy as it looks programmatically.
As a result some parsers underestimate dps a bit
- The accuracy of the calculations is best for characters lvl 60-70 but decreases if your toon is of lower level. Toons below lvl 60 are on a damage table that leads to noticeable lower dps and this is not taken into account. If its just a weapon comparison you're after this isnt too big an issue. The dps number themselves may not be very meaningful anymore, but the ranking would be affected in only a few places. (Note: this has considerably improved since the introduction of the level-dependent version)
How to use
On the Stats'n skills-sheet you can enter your level, ATK rating, haste%, dexterity and AA skills. I think most of it is self-explanatory, and i've added notes to the input cells to help out. The database sheets should automatically recalculate using the new values (unless you have this disabled in excel's options. If you have, you'll prolly also know how to manually recalculate)
If your weapon isnt in the database yet, there are also fields on the Stats 'n skills sheet where you can enter a weapon setup. You'll have to enter the weapon details yourself.
If you have any problems using the spreadsheet don't hesitate to ask.
Comments/questions/criticisms are always welcomed
/hugs
