Diablo® III

theK1ll577's DH Spreadsheet! - UPDATE COMING!

THUMBS UP AND VOTE FOR STICKY PLEASE! KEEP THE PROJECT ALIVE!

Easy to use spread sheet, watch your damage change as you manipulate the values.

Features:
NOW SUPPORTS PARAGON LEVELS!!!
Now supports all defensive stats
Supports every wep type!
Allows you to change stats per piece of gear
Shows both Normal and SS Damage
Easily compare gear upgrades per single piece

Currently this is a v4.8 release.

***Change the sheet at the bottom for 2H, 1H, and Defensive Calculations!***

Screen Shots with some dummy values:
2H sheet:
http://tinypic.com/r/qmx5pc/6

1H Sheet:
http://tinypic.com/r/24qqrue/6

Defense Sheet:
http://tinypic.com/r/24myxw1/6

READ ONLY VERSION FOR DOWNLOAD:

**Click FILE at the top of Google Docs and download it as any file type you wish**

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

MediaFire Download Link:

http://www.mediafire.com/?1macgjahs4zleef


Legend:
Weapon Damage : wDPS
Weapon's APS : wAPS (IE: 1.10)
Gear DMG bonus : + Damage (Minimum for Red Gem in Wep, Average for other + damage)
Gear IAS : IAS (should be entered as a number not a percent, IE: 5 instead of 5%)
Crit Rate % : Crit Hit Chance
Dexterity : DEX
Skill Bonus %: SB (20% for using Steady Aim)
ssDPS : Final DPS with Sharp Shooter Passive


Things to know:
-To put in duel wielding values for weps use this model:

http://tinypic.com/r/11gufy0/6

-If an item gives 7-11 addition damage (must be separated by a dash) then you add the two values together (7+11) then divide by 2 for the value of 9.

-When changing values you only edit the ones for gear pieces, the total values and final values are automatically calculated!



Upcoming Changes:
Damage preview with passive skill modifiers OTHER then mainstream SS/Steady Aim
I need more suggestions!

Known Bugs:
-Duel wield sheet will be off by a marginal amount usually very little. This is due to blizzard rounding during calculations. I can only fix this so much. Always trying, always working!


Leave comments and feature requests in the comments below.

Thank you and please vote for sticky, this will be an ongoing project for a long time.
Edited by theK1ll577#1738 on 12/11/2012 11:21 AM PST
Reply Quote

Updates:

v4.8
-Added Paragon Support
-Fixed a lot of format errors that looked funny to me lol

v4.0
-Added Resistance Calculations
-Added Armor Calculations
-Added Follower skills to all sheets
-Add Set bonuses to all sheets
-Tightened the formulas to be more accurate
-Some minor aesthetics changes for ease of use

v3.0
-Added full support for 1H xbow users
-Tweaked calculations for better accuracy
-More aesthetics fixed for 1H and 2H page

v2.0
-Added full support for Bow users
-Fixed more aesthetic issues
-More retarded redundancy removed
-Added Help box with need to know information

v1.5
-Added IAS on boots slot for Boj Anglers
-Fixed some aesthetic issues
-Remove some redundancy
Edited by theK1ll577#1738 on 8/27/2012 5:29 PM PDT
Reply Quote
I'm finding this very helpful when determining what is and isn't an upgrade for me.

Thanks!
Reply Quote
Good to see a lot of you using the google docs version, at least some people are getting use of it :)

If you don't trust mediafire, you can click FILE at the top of Google Docs and download it as any file type you wish if you don't want to fight other people over writing your numbers.
Edited by theK1ll577#1738 on 6/16/2012 2:12 AM PDT
Reply Quote
someone screwed the google docs.. =(
Reply Quote
Working fine for me. Downloaded the Google Docs version. You should add IAS for boots as well (i.e. Boj Anglers). I just put the value on my own doc in a spare IAS box.
Edited by ErnDiggity#1435 on 6/16/2012 5:14 AM PDT
Reply Quote
Checking up on the google docs version and will get back to you. I knew it would happen eventually. The Media Fire version is legit so why not just DL that?

06/16/2012 05:07 AMPosted by ErnDiggity
You should add IAS for boots as well (i.e. Boj Anglers). I just put the value on my own doc in a spare IAS box.


Noted, thanks.
Edited by theK1ll577#1738 on 6/16/2012 8:50 AM PDT
Reply Quote
Google Docs is back up, click the new link in the original post to try out the sheet. I recommend downloading it from google or media fire using the steps originally posted as I will not keep a watch on it 24/7.

Again, votes and sticky request please guys. It would be a hassle to bump this.

EDIT: Read only Google Docs is up. Download at your leisure and please vote :)

New Release will be posted around dinner time EST with some fixes/etc
Edited by theK1ll577#1738 on 6/16/2012 9:22 AM PDT
Reply Quote
epic, needs sticky
Reply Quote
looks very good. gonna try later for sure
a+
Reply Quote
Easiest one yet, please add IAS to boots and lock the cells for final values so ppl don't screw up the formulas.
Reply Quote
06/16/2012 09:31 AMPosted by BdiZzLe
please add IAS to boots and lock the cells for final values


I am currently working on BOTH those things haha, stay tuned guys.
Reply Quote
checked all the values, but am not able to get the same dps value as ingame
tips?
Reply Quote
Yep someone just messed up your +Damage in final values.
Reply Quote
checked all the values, but am not able to get the same dps value as ingame
tips?


If you are using the unprotected Google Docs version people could be writing over your values. Also please remember that this is a v1.0, it assumes your passive skills are Steady Aim/Sharpshooter/Archery and that you are using a 2H crossbow.

Support for Bow users should be added tonight at around dinner time. I'm working on it now, and adding the passive skill modifier to not be built in but optional.

06/16/2012 09:59 AMPosted by BdiZzLe
Yep someone just messed up your +Damage in final values.


I'll fix it real fast but please go to the protected version and download it yourself as the open one for previewing will get defaced a lot by 12 year olds. Fixing now because I'm around.

EDIT: Fixed.
Edited by theK1ll577#1738 on 6/16/2012 10:02 AM PDT
Reply Quote
I have updated the project to v1.5 and fixed a couple minor things while I implement the bigger options. Enjoy the new links.
Reply Quote
The IAS for boots isn't working. Thanks for the prompt updates, awesome.

I fixed it for u.
Edited by BdiZzLe#1770 on 6/16/2012 11:17 AM PDT
Reply Quote
The IAS for boots isn't working. Thanks for the prompt updates, awesome.

I fixed it for u.


You know, I was just looking at the release and realized i didn't add the cell to the formula and was headed over to fix it.

I fixed the READ ONLY file of this bug and set it to a release version.
Edited by theK1ll577#1738 on 6/16/2012 11:21 AM PDT
Reply Quote
Great job. It's very easy to use and accurate.
Reply Quote

Please report any Code of Conduct violations, including:

Threats of violence. We take these seriously and will alert the proper authorities.

Posts containing personal information about other players. This includes physical addresses, e-mail addresses, phone numbers, and inappropriate photos and/or videos.

Harassing or discriminatory language. This will not be tolerated.

Forums Code of Conduct

Report Post # written by

Reason
Explain (256 characters max)
Submit Cancel

Reported!

[Close]