Demon Hunter Theory Crafting - MATH IS FUN YAY?!

[The_Gamdol]

So, to start off with, we use this basic (trust me it's basic) formula for DPS:

Demon Hunter Theory Crafting - MATH IS FUN YAY?!

All the values over 100 or 10000 are considered their original (non-percent) values, so if you have 25% IAS, you plug in 25, not .25 (the equation makes it .25 BUT THIS IS BEYOND THE POINT OK?). Now the cool thing we can do with this equation right here, is figure out which block is the lowest currently, which makes increasing that block by a significant amount (let's say the whole block +1) will have the greatest impact.

Let's plug in some hypothetical stats (minus sharpshooter, fuck sharpshooter).

1400 Dex
1100 DPS Crossbow (1.1 BAS)
-Average damage (total) 1000
-As a note, this damage already includes +Damage% and elemental damage, and is shown on weapon tooltips. However, I took IAS out of the tooltip values because IAS is weighted depending on the weapon. (25% of 1.6 is much better than 25% of 1.1)
20% critical
200% (bonus) critical damage (Character details here would show 300% critical damage)
50% attack speed

(1.1(1.5))(14)(1000)(1+(.2)(2)) = 32340 DPS (And also because fuck you sharpshooter, DPS with that stacked would be 92400)

Now, let's see, at this point, how much everything is weighted to improve upon this DPS. I'm going to ignore sharpshooter for this because fuck it and trying to weight anything while considering 100% crit means crit damage wins. Always. That makes for boring math. The way to figure this out is to take some value, and increase it by X, then figure out what you have to change the other values to to get them to the same value. Our baseline will be 10% attack speed increase (pretty small). New DPS is 34496. Plug this in as DPS, revert the IAS, keep all but 1 field static, solve for X.

10% IAS = 93.33 Dex = 66.66 Average Damage = 4.66% crit chance = 46.66% crit damage

So increasing any 1 stat by the above amount would result in the same DPS increase. In this example the Attack Speed was pretty low to start, so lets look at a build where IAS is more centric, a 1h crossbow build.

1400 Dex
900 DPS 1H Crossbow (1.6 BAS)
-Average damage (total) 562.5
-As a note, this damage already includes +Damage% and elemental damage, and is shown on weapon tooltips. However, I took IAS out of the tooltip values because IAS is weighted depending on the weapon. (25% of 1.6 is much better than 25% of 1.1)
30% critical
100% (bonus) critical damage (Character details here would show 200% critical damage)
100% attack speed

(1.6(2))(14)(562.5)(1+(.3)(1)) = 32760 DPS (Only 50400 DPS with Sharpshooter, the low crit damage really hurts the "OMG HIGH" dps numbers, as well as having a base higher crit chance)

Alright, same plan as before, upgrade IAS by 10%, see where the rest need to be to get the same effect! New DPS = 34398. Already we see that increasing IAS does less for this build, because its IAS was already so stacked.

10% IAS = 70 Dex = 28.125 Average Damage = 6.5% crit chance = 21.66% crit damage

As you can see, since the IAS and crit chance were higher to begin with, it is much easier to equate to 10% IAS for the other stats. For comparison:

Build 1: 10% IAS = 93.33 Dex = 66.66 Average Damage   = 4.66% crit chance = 46.66% crit damage
Build 2: 10% IAS = 70 Dex       = 28.125 Average Damage = 6.5% crit chance   = 21.66% crit damage

In build 1, IAS is clearly highly weighted, while in build 2, crit damage and weapon damage are very strong. Hopefully this equation makes it easier to figure out where you can get the highest damage increases before buying stuff off the auction house. To use for yourself, follow these easy steps:

Step 1: Plug in your numbers to the DPS equation, simplify it down like I did to (IAS block)(Dex block)(Damage block)(Crit block)
Step 2: Increase one of the values by a hypothetical amount, generally lower is better so things are more plausible, solve for new DPS
Step 3: Change one of the other values to X, change all other values to base amounts, solve for X to reach new DPS
Step3a: Repeat step 3 until you have equivalent values for each stat you can get.

Step X: Consider all the other random crap you can do, such as get on-hit effects. Generally each effect will have a stat that it works with the best.
-On-hit: IAS
-Sharpshooter: Crit damage

There you go, easy math for easy DPS calculations to figure out where you want to improve your stats to get the highest DPS returns. I recommend -never- considering Sharpshooter DPS as it will only cause you to place 0 weight on crit, and 1000x weight on crit damage.

Want to skip even more work? Use the spreadsheet online!

https://docs.google.com/spreadsheet/ccc?key=0AuBq96zIjVoldG1BYm5hVzBfZ0RnajVpWkRyN092dFE

[MetalMusicMan]

Fuck you I'm mad because your class isn't total shit like mine rawr rawr rawr.

[The_Gamdol]

To be fair, those numbers also directly translate into Monk DPS, but you're melee so fuck you.

[oograx]

just think will if this were diablo 2 your character might be permanently screwed because there's no way to change your build.

Luckily, there totally is!


Or level another character, that's fun too.

Since my barbarian is essentially SOL w/o either a full group of people to carry me while I get oneshot by everything or spending many millions on the auction house, I'm leveling a demon hunter which has actually been quite fun.

[The_Gamdol]

Demon Hunter (just like Barbarian) requires farming to go past Act 1.

[MetalMusicMan]

You can change builds in D2.  You get 3 respecs per character for free and can easily farm for more, it's been that way for like 2 years now.  Plus, re-leveling isn't an issue.  This is not about me fucking my character up and needing a new spec.  It is about my entire class being total shit and melee in general being completely, utterly, ridiculously fucked over. 

Anyway, less hijacking from me and more blowing Gamdol for this sweet and informational post   Good work.

[oograx]

Demon Hunter (just like Barbarian) requires farming to go past Act 1.

Barbarian requires farming act 1 before you can actually do act 1.


Well, or the auction house.

And yeah since I'm leveling my DH now (which is super duper awesome elemental arrow+runes owns so hard) this is actually totally useful.

[MetalMusicMan]

People saying "I can't do anything without the AH" are fucking MORONS.

That's like saying "I can't make a good character in D2 without trading".  Yeah, that's the whole fucking point, twats.

[oograx]

Hahaha, yeah.

I can't afford things on the auction house is more the issue.

[The_Gamdol]

People saying "I can't do anything without the AH" are fucking MORONS.

That's like saying "I can't make a good character in D2 without trading".  Yeah, that's the whole fucking point, twats.

Either that, or they get to Inferno, run to the first elite pack and then complain they're useless without the AH. Because they should be able to waltz into Inferno with their fresh 60 and be able to kill everything straight away.

On the bright side, AH prices have dropped -dramatically- since the first week. Originally a 1000 dps xbow was around 10 mil, now 1000 dps is 'low' and goes for a few hundred thousand, and 1300+ dps xbows are the 10 mil ones.

The top end gear is still really expensive, but the 'almost top end' gear is now extremely good as well.

[oograx]

I can totally kill some elite packs it's great.

[Voon]

I'm probably a moron for asking this, but how do you edit the spreadsheet you linked in OP?
It states "view only."
I tried downloading it in all the different formats, but when I did that some of the formulas broke, and simply read "#NAME?" instead of an actual number.
I also tried importing the csv and excel file into another google document spreadsheet, but the formulas behind the text were left behind.

I'm just a scrub that doesn't know anything about spreadsheets.
If i could get this working, you will have done me a great service, yet I've nothing to offer you but my gratitude.

[MetalMusicMan]

The Gamdolites have cometh!

I'm sure your fearless leader will be around to help you shortly

[The_Gamdol]

There were actually a lot of errors I found with that spreadsheet I found after the fact, and I've been working on a better one. The current version is here:

https://docs.google.com/spreadsheet/ccc?key=0AuBq96zIjVoldG1BYm5hVzBfZ0RnajVpWkRyN092dFE

This one also gets rid of all the possible #NAME errors. What you want to do to edit it is go to File in the corner and download the file. This will let you modify it. You might be able to do 'copy' if you're logged into a google account, which will allow you to modify it online if you don't have excel on your computer.

I'll keep this page updated with more information as I continue to update the spreadsheet, but what I hope to include is:

1. Make a copy of your gear in the bottom half of the spreadsheet.
2. Calculate the 'comparison' DPS from this gear. This will allow you to put in the stats of a piece from the AH and see a comparison, at least until they implement this function for you.
3. Anything else people think of.
4. DPS modifiers for more than just Sharpshooter, such as Siphon for WD's to check 5 stack int buff (I need to know how much INT each stack adds at 60 though)
5. Include armor/resist/vitality calculators to determine effective health

[Voon]

Thank you kind sir! All the problems I had are fixed. You are a god among men, and I vow to spread the good word to the limit of my ability.

I will, however, muster the nerve to suggest an improvement to your grandest of creations.
I would kindly request the old "equivalencies" section back.
It was so nice to be able to solve for each stat specifically. Granted the information can be accessed through this model just as well, but at a slight inconvenience. It looks tidier for sure, but as it happens, I value practicality over neatness in my spreadsheets.