Spreadsheet martial DPS calculator (with defense calc)

[Supot]

Sharing this spreadsheet done on my first life Shintao Monk.
I make these to gauge what are the most important effects to have for gearing / enhancements / epic destiny abilities, etc.
I just keep adding rows for new abilities to test and compare.
This is just a measurement of a basic attack, so these values won't reflect real DPS being done.

Feel free to copy-paste it into your own Google sheets so you can edit or improve on it. Also pls let me know if u find any errors.

https://docs.google.com/spreadsheet...Ptu0wLWTP0/edit?gid=2039936202#gid=2039936202

 

[kemton]

When you said 2.55 hits / sec with haste boost I assume this is both MH and OH? this number seems off from past reported numbers which I thought was in the 140/minute range(MH only).

Did you test this yourself? I’m looking for verified APM numbers from all weapon styles.(haste boost / no haste boost)

 

[Supot]

When you said 2.55 hits / sec with haste boost I assume this is both MH and OH? this number seems off from past reported numbers which I thought was in the 140/minute range(MH only).

Did you test this yourself? I’m looking for verified APM numbers from all weapon styles.(haste boost / no haste boost)

I got it off from these calculations.

https://forums.ddo.com/index.php?threads/dps-formula.2949/page-2

In my spreadsheet, I was not accounting for offhand strikes so that is a mistake.
In the context of my DPS calc, the damage of the Kinesis DOT would be less per hit.

I tested the values of 153 Haste Boost and 113 Non Haste Boost
and I can confirm that these are roughly accurate.
153 hits in 1 minute = 2.55 hits per second.
113 hits in 1 minute = 1.887 hits per second
140 is the average of Haste Boost + No haste boost (20 sec haste boost + 10 sec non hasted)

Something to note in the testing was the Monk animation shows 5 attacks with 5 hit sound effects when hitting air, but only 4 attacks actually hit when there is an enemy. So for ease of counting, I test hitting air. I count 63-64 attacks with a 20 second haste boost.
63.5 x 3 = 190.5. I then multiply by 0.8 = 152.4.