Diablo® III

Witch Doctor Damage Spreadsheet

90 Worgen Warlock
12145
Here is a spreadsheet that will allow you to calculate stat weights as well as how swapping in a piece of gear will change your damage. Editing is locked, so you will need to download it to enter the stats for your character. Feel free to build upon it and rehost.

Apologies if there are already such spreadsheets floating around. I couldn't find one.

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

It was accurate for my character down to 2 decimal places, but there are probably things I haven't accounted for. Notably, a table for calculating attacks per second should probably be built so that the actual number is used in place of the rounded number listed on the item.
Edited by Zey#1168 on 6/2/2012 11:10 AM PDT
Reply Quote
85 Tauren Shaman
10485
Messing with it now thanks for this been looking for something like this
Reply Quote
90 Worgen Warlock
12145
You know what would really help me further develop this spreadsheet? A 1000+ dps one hander with a 1.8s+ attack speed.... wtb rmah
Reply Quote
sorry for the newbie question but how can I download it?
Reply Quote
90 Worgen Warlock
12145
Diablofans.com posted about it on there front page and now the amount of traffic is affecting the ability to download. Refer to the post here please:

http://www.diablofans.com/topic/46860-dps-spreadsheet/
Reply Quote
how do i downlaod it
Reply Quote
Oh thanks btw for this!

Never got to say that but as soon as you posted this I have been abusing the hell out of it :p
Reply Quote
How do you download it? - _ -
Reply Quote
Anyone of you can explain how to download it?

Since its not edit able
Edited by Maki#2542 on 6/5/2012 10:44 AM PDT
Reply Quote
You need a gmail account to sign in. Then I believe it's file and edit. I don't really remember it. You can also download it from the File menu.

I use this spreadsheet a lot. Very helpful in determining whether or not a weapon is worth buying.
Reply Quote
2 Blood Elf Mage
0
I recommend you get a google account and then do a file save as - you will now have your own personal, private version of the ss.

The downside is that if the author changes it, you will have to go back.
The upside is you now have it, regedless of whether the author deletes it or makes it worse. And you can modify your copy of the ss.
Reply Quote
Does this take into account Pierce the Veil passive?
Reply Quote
06/05/2012 12:44 PMPosted by Arty
Does this take into account Pierce the Veil passive?


It has a "Total % dps increase from talents" field, so yes. You would put 20 in there for PtV
Reply Quote
I think there's something wrong with the formula. I've triple checked everything and the spreadsheet says I have 10 more dps than what the game says. Not a big issue, but just a fyi
Reply Quote
85 Undead Warlock
12125
Not sure if you are also looking for some feedback on the spreadsheet, but from what I've played with so far, I like the setup. I'll have to wait until I get home from work to plug in my WD's stats and see how accurate it is. I was able to download it though and started playing around with the layout to accomodate my own laziness.

1. Added an 'Planned items to swap' area at the top duplicating the GREEN areas with their row/column description from 'Your current damage' layout minus the 'Baseline' and 'Character Sheet Total' columns so I could use it to enter in the item(s) I am thinking of swapping out. I now just enter in 0's under OH in this area to compare a MH-OH setup to a 2HD setup if necessary although I prefer MH-OH. (ties into one of my pet peeves about the D3 tooltip comparison between weapons as 2HD only compares with MH and not MH-OH combined)

2. Changed the GREEN areas for 'Damage after proposed gear swap' to be formulas to pull from the 'Your current damage' by default unless I populate one of the GREEN fields in my new 'Planned items to swap' area.
Formula I used is: =IF(LEN(TRIM(<ItemSwapCell>))>0,<ItemSwapCell>,<CurrentDmgCell>)

3. Moved the 'difference:' to the top so I no longer need to scroll down to see how the gear swap changed my damage.

Just some of my thoughts on the appearance and layout. Very nice job though pulling that all together. I'm far too lazy to have tried working out the numbers.
Reply Quote
06/08/2012 01:57 PMPosted by Schrödinger
I think there's something wrong with the formula. I've triple checked everything and the spreadsheet says I have 10 more dps than what the game says. Not a big issue, but just a fyi

Game uses hidden decimals. Formula is perfect.
Reply Quote
Sticky requested. The need for this wouldn't be so obvious if blizzard allowed you to "peek" at the stats to see how they changed your char.
Edited by Computer#1711 on 6/8/2012 3:25 PM PDT
Reply Quote
Also an issue with some weapons -- a sword (1.4 base speed) with 21% attack speed will say 1.69 in the game, when it's really 1.694.

Putting in 1.69 gives incorrect numbers, 1.694 fixes it.

I don't think this can be solved in the spreadsheet, but may want to include a note that people should try this if they see wrong attack speed numbers (take base speed of weapon * 1.$(atkspdinc))
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]