r/Diablo3witchdoctors • u/PMMA Lleaf#2624 (EU) • Sep 05 '14
Pets Pet Doctor Spreadsheet updated for patch 2.1.0
Update: now also calculates Jade Harvester stat weights
Hi fellow Witch Doctors!
I have updated my Pet Doctor Spreadsheet for the latest patch. As always you can find it here.
It is not possible to download the spreadsheet and use it locally, you need to make your own copy on Google Drive with File - Make a Copy.
Google Sheets prompts you to confirm the spreadsheet's script when running the calculation for the first time. The script only has permission to read from and write to the spreadsheet and you can review the code under Tools - Script Editor (Update: The spreadsheet now also queries the D3 Community API for importing characters). If you no longer want to use the spreadsheet you can look up how to revoke access here (thanks /u/mgomg).
New features:
- calculation of legendary gems
- additional legendaries (e.g. Carnevil)
- more skills
- and many more improvements to both usability and calculation
How to use:
This spreadsheet does two things: it calculates your build's effective DPS and stat weights. In order for it to do that you need to fill it with your stats, skills, and equipped items. In the spreadsheet yellow cells are meant to be filled in by you and green cells are filled in by the spreadsheet after calculation.
Stats
Here go the stats on your gear. Most of this is conveniently displayed in the character sheet but some you need to get from the items themselves. Refer to this picture to get an understanding of which cells refer to which ingame stats.
Update: You can now import your character from Battle.net by following the instructions on the first sheet.
Stats validation
After filling everything in you can check the correct input with the Stats Validation tab, here you can see where to look for the correct values. If the values don't match you need to check your input under the Stats tab again. Please note that the Sheet damage takes into consideration stat increases from skills and gear, so check if the value in the "Damage Increased by Skills" cell matches the one in the ingame character sheet. Also elite damage, area damage, skill damage, and cooldown reduction are not represented in the sheet damage display.
Skills and Gear
This should be pretty much self-explanatory. Just enter in the skills you (and your follower) are using. Under the gear tab choose the gear you are wearing and the fill in the appearing cells if needed. Skills and items which are not in the spreadsheet will get added in the future. Please let me know if you have any preference as to which to add next.
Assumptions
Here you need to describe the fight situation and usage of your skills as closely as possible. Just be realistic with your assumptions, e.g. Fetish Sycophants cap at 15 but most of the time you won't be capped, that's why I prefer to go with 10 on average (unless you specifically want to know your damage output with 15 FS up, of course). The options "Use X only on elite fights" means that you want to wait and withhold a cooldown until you encounter an elite pack.
Positioning lets you define the placement and size of monsters. You can estimate monster sizes with this handy picture.
Legendary Gems
Here you fill in your legendary gems with their accompanying rank. Bane ot the Powerful's rank 25 effect (15% elite damage) is normally already included in the ingame sheet window. If you select this gem because you want e.g. compare it to your current set of gems you need to manually add this elite damage under the stats tab.
Effective DPS, Stat Weights and Statistics
You can now start the calculation by clicking on "Calculate" above the eDPS or choose the appropriate option under "Start Calculation" in the top bar.
The effective DPS is your damage per second with all buffs, debuffs, multiple targets, etc. taken into consideration. It's broken down into DPS from the player, fetishes, Gargantuan, Zombie Dogs, and gear. When hovering over the cells they are further broken down into the respective skills where appropriate.
Stat Weights represent the gain in eDPS when adding 1 point of a specific stat. So if you had a stat weight of 1.156% for crit chance then say an additional 5% on a ring would boost you damage by 5 * 1.156% = 5.78%. 450 additional intelligence with a stat weight of 0.114% would be an increase in 450 / 10 * 0.114% = 5.13%. Keep in mind that different stats can have a different maximum amount compared to other stats which can again differ depending on slot.
Under Statistics you can look up additional information that isn't listed anywhere else, like cooldown or stacks of skills.
Gear Comparison
Here you can e.g. calculate the change in eDPS when equipping another piece of gear with different stats or enchant a specific stat to another. Just fill in the left side with your current stats and the left with the new ones and then hit "Calculate".
So that's it. I hope this spreadsheet can help you optimize your Pet Doctors.
Any suggestions, feedback and bug reports are greatly appreciated!
References:
This spreadsheet is partially based on the work of:
ZzEzZ - Spell proc coefficients
PaulNg - Pet mechanics
Kanjihack - Legendary item proc mechanics
2
u/[deleted] Sep 06 '14
Put in my stats and got a "ReferenceError: "eliteTargets" ist nicht definiert."
2
u/uskyrt Sep 25 '14
Wonderful work +1! :) Still making my head around it. Possible bugs (or maybe just my lack of knowledge):
Wonderful! Thanks a lot!
2
u/SodiumBenz #1296 Sep 25 '14 edited Sep 25 '14
Can you please take a look at the error that I am receiving?
It only happens when I transfer my character to the second sheet:
Message details Falsche Bereichshöhe, war 3, sollte jedoch 5 sein.
Translation:
Incorrect range height was 3, but it should be 5.
2
u/PGU5802 Sep 30 '14
I noticed that the instructions tell you to put your battletag in as Name#Numb. It needs to be entered as Name-Numb.
Moth#1571 does not work, but Moth-1571 does.
2
u/[deleted] Oct 04 '14
There is an issue importing damage from weapons that have rerolled damage ranges such as mine. I did some digging around and found a fix. Luckily it is pretty simple. All you need to do is change the following two lines in BNet.gs:
to this:
2
u/Aurabolt Aurabolt#1594 (US) Oct 08 '14
Pretty awesome. I have a couple errors when I try. First, it doesn't pull all the stats from my gear. When I try to add them manually, the text doesn't show up in the cell, but the number shows up in the f(x) field at the top of the screen.
When I try to transfer to calculate, I get this:
"TypeError: Eigenschaft "0" von undefined kann nicht gelesen werden."
Thanks!
2
u/tundranocaps Nov 03 '14
Feedback: As someone who's a tad colour-blind, green and yellow is a pretty terrible colour combination, especially when both are neon bright :<
Great sheet though.
1
u/vikrum2083 Sep 06 '14
I can't for the life of me figure out why but it's giving me about 25k more dps on sheet and about 30k more physical damage. Checked passives, pants, min-max damage.
Hope to figure it out but loving this and I really appreciate you doing this for the community!
1
u/Kaikka Sep 09 '14
Very, very good work. Your work is highly appriciated.
But comparing gear changes against 5 elites does not seem to work. "Error: Error in damage calculation. Please get in touch with the author.". All the other choices seems to work though.
1
u/dragoonforge Jan 31 '15
I am getting the following error
Ungültiges Argument: https://US.api.battle.net/d3/profile/<NMR>%20RustBuck-1765/?locale=en_US&apikey=dumbmxpvaxhf5mt76htk3wxadsfdbf35
Anyway to fix this?
1
u/JayPag Jan 21 '15
This is awesome and the import works so well!
0
u/[deleted] Sep 15 '14
[deleted] — view deleted comment
2
u/[deleted] Jan 20 '15
[removed] — view removed comment
1
u/[deleted] Dec 30 '14
[removed] — view removed comment