DDO DPS Calculator!

[Kinerd]

I've found an error in the spreadsheet. It does not give half Strength bonus to off-hand attacks for TWF. The Brb 20 TWF listed gives 4.86 DPS per Strength bonus, but it should only be 4.86 * 1.4 / 1.8 = 3.78, or a difference of 1.08. For a 29 Strength bonus, this is a total of 31.32 DPS higher than it should be.

[Consumer]

I've found an error in the spreadsheet. It does not give half Strength bonus to off-hand attacks for TWF. The Brb 20 TWF listed gives 4.86 DPS per Strength bonus, but it should only be 4.86 * 1.4 / 1.8 = 3.78, or a difference of 1.08. For a 29 Strength bonus, this is a total of 31.32 DPS higher than it should be.

Checked and confirmed, offhand should give 1.079375 and total increase per str of 3.77675 DPS. However although increasing from 68-70 STR has this problem, increasing from 70-72 STR does not, it then comes back for 72-74 STR (due to offhand damage increasing every 4 STR).

[Aaxeyu]

I've found an error in the spreadsheet. It does not give half Strength bonus to off-hand attacks for TWF. The Brb 20 TWF listed gives 4.86 DPS per Strength bonus, but it should only be 4.86 * 1.4 / 1.8 = 3.78, or a difference of 1.08. For a 29 Strength bonus, this is a total of 31.32 DPS higher than it should be.

Offhand damage from strength is main hand damage/2 rounded down, as you never get "half a damage". This means taht offhand damage effectivly only increases every 4 point you get in strength.

If you look at the DPS difference from 66 to 68 strength ou'll find that it's 2.70.
So each strength mod increases DPS by 4.86 half the time and 2.70 the other half. So we can get the average DPS increase per strength mod by:
(2.70 + 4.86) / 2 = 3.78

[Aaxeyu]

A few notes on the latest version (2.1)

It now uses attackspeeds gotten from Vanshilar (http://forums.ddo.com/showthread.php?t=275144).
The lines for BAB and madstone does not do anything, as we only have attackspeeds for BAB 20!
There is also no correct attackspeeds for sword and board.

Human versatility damage boost is meant to only be used at the same time as haste boosts, as they can be activated at the same time, and thus no lost attacks.

Neg rep for this post? lol

[Kinerd]

If you look at the DPS difference from 66 to 68 strength ou'll find that it's 2.70.
So each strength mod increases DPS by 4.86 half the time and 2.70 the other half. So we can get the average DPS increase per strength mod by:
(2.70 + 4.86) / 2 = 3.78

Ah. Previous post retracted then.

[vrobel]

hey can someone re-upload it on another mirror pls ?filedropper dont works for me :/

[grodon9999]

Doesn't look like the HV damage boost is working right, gives the same amount as if there was just 5 more total damage per swing and not just when a haste-boost is going off.

Unless I'm doing something wrong . . .

[Aaxeyu]

Doesn't look like the HV damage boost is working right, gives the same amount as if there was just 5 more total damage per swing and not just when a haste-boost is going off.

Unless I'm doing something wrong . . .

Hmm, are you sure you type in the correct cell?

[grodon9999]

Hmm, are you sure you type in the correct cell?

No I'm not sure. My choices are:

Human Versatillity Damage Boost (Check note →) (put a number in here and it doesn't affect anything)

Damage from HV Put the number in here and it's the same as if it's a constant damage boost.

[Aaxeyu]

No I'm not sure. My choices are:

Human Versatillity Damage Boost (Check note →) (put a number in here and it doesn't affect anything)

Put a number here. It will affect your damage if you have haste boosts.

Damage from HV Put the number in here and it's the same as if it's a constant damage boost.

Don't touch this one.

[grodon9999]

Put a number here. It will affect your damage if you have haste boosts.

It's not working. I'll re-download it when I get home. I deleted the line that was giving the tempest speed, that may have fouled stuff up.

[Consumer]

http://forums.ddo.com/showpost.php?p...&postcount=299

Error shown here.

[Promethie]

I think the is an error but not an expert by any means:

for calculating glancing blows, the formula shows, =IF(ISNUMBER(FIND("THF";E$3));IF(D$186="THF";0.3+I F(D$101="Yes";0.1;0);IF(D$186="ITHF";0.4+IF(D$101= "Yes";0.1;0);IF(D$186="GTHF";0.5+IF(D$101="Yes";0. 1;0);0)))*D$65-D21;0)

This looks like if you don't have any of the thf lines or barbarian capstone, then you do 0 damage on glancing blows. If the monster has dr, then you are doing negative damage on glancing blows. I believe the formula should be:

=IF(ISNUMBER(FIND("THF";E$3));IF(D$186="THF";0.3+I F(D$101="Yes";0.1;0);IF(D$186="ITHF";0.4+IF(D$101= "Yes";0.1;0);IF(D$186="GTHF";0.5+IF(D$101="Yes";0. 1;0);0.2)))*D$65-D21;0)

note the 0.2 instead of 0 at the end, I of course may be completely wrong but I know you can't do negative damage on a glancing blow.

[Kinerd]

I noticed something today: if you go to the Fighter build and change the weapon to Longswords, changing Kensei from rank 3 to rank 2 does nothing. It does something for Khopesh, eSoS, HPick, and Rapier, but not Longswords, which is.. pretty perplexing. (Not as perplexing as a fighter using longswords, but still.)

[Kinerd]

It seems like the spreadsheet treats Frenzied Berserker and Elemental Burst as if the barbarian gets more damage out of Elemental Burst on rolls 19 and 20. I tested today on my FB II barbarian and found the following with a Flaming Burst Longsword on rolls of 19 and 20 while raging:

3 damage - 1
4 - 3
5 - 1
6 - 1
7 - 1
8 - 3
9 - 3
10 - 2

While not conclusive, this is fairly strong statistical evidence that Elemental Burst only takes into account the weapon's base critical multiplier, at least for FB II. Has anyone actually seen a Burst producing higher results with FB II, III, or Death Frenzy?

[Glenalth]

It seems like the spreadsheet treats Frenzied Berserker and Elemental Burst as if the barbarian gets more damage out of Elemental Burst on rolls 19 and 20. I tested today on my FB II barbarian and found the following with a Flaming Burst Longsword on rolls of 19 and 20 while raging:

3 damage - 1
4 - 3
5 - 1
6 - 1
7 - 1
8 - 3
9 - 3
10 - 2

While not conclusive, this is fairly strong statistical evidence that Elemental Burst only takes into account the weapon's base critical multiplier, at least for FB II. Has anyone actually seen a Burst producing higher results with FB II, III, or Death Frenzy?

I know that it works properly with Divine Sacrifice and Smite Evil. No Barbs to test that out on though.

[karl_k0ch]

I am not sure if it is already a known issue, but it might impact some monk-based calculations:

- Unarmed Off-Hand attacks seem to add only half the Str Mod to damage.
- Is the increased monk attack speed, compared to other TWFs included in the calc? (see here for more details: http://forums.ddo.com/showthread.php?t=275144)

I was looking for some DPS numbers and I was surprised how far behing the wraps were, compared to Khopesh, even in 100% fort cases.


Edit: Maybe I did something wrong - I will check later today. The PC I am on atm has no OOo.

[Absolute-Omniscience]

I am not sure if it is already a known issue, but it might impact some monk-based calculations:

- Unarmed Off-Hand attacks seem to add only half the Str Mod to damage.
- Is the increased monk attack speed, compared to other TWFs included in the calc? (see here for more details: http://forums.ddo.com/showthread.php?t=275144)

I was looking for some DPS numbers and I was surprised how far behing the wraps were, compared to Khopesh, even in 100% fort cases.

Hmm, that's very strange, did you choose "unarmed" at the dropdown near the top? Unarmed should be getting full str bonus in offhand, has been that way for a long time. Thanks for point it out though, will check up on it once I get off work.

Yes, unarmed should be getting higher attackspeed.

Take note that monk strikes are not in the calculator, so monks will have a little more DPS than what is shown. Add about 60 ish from tod and the rest and you're at your actual.

[karl_k0ch]

I took my time to look into this again. I did indeed forgot to plug in Unarmed instead of TWF - I was assuming that this would be done automatically with the weapon choice. Thanks for your support.

[brzytki]

I found that your Calc is missing Rogue's PL: Sneak of Shadows, it would be really interesting to see its effect on dps. I hope it will be finally implemented in incoming updates.