Hey all, been working on a new spreadsheet for a while including all the changes in 2.1. Here's a link to a website I'm hosting, so everyone can use it free and help me work out all the bugs: http://d3barb.com. I plan on sprucing up the site a bit later on once the footwork of the calc is finished. I'd love some feedback and any errors you may encounter while using it! Here are some instructions on how to use the calc:
General DPS Calc Usage:
1.) Fill out all the gear stats from your in-game character.
2.) Fill out the "Paragon" section using the actual values, not paragon points (ex: 6.8 IAS, 45 CHD, 5 CHC)
3.) Use the "Sets" section to apply any set bonuses. **Currently only sets that directly increase damage are included. I will add CDR ones (Born's, Captains) in later.
4.) Use the "Skill" section to add in any passives / skills that will apply to your character sheet while standing/running in town. (Weapon Master, Hexing Pants, Battle Shout) Use this to verify your character DPS in-game matches the Calc. **If you are using a weapon with the +% damage modifier, there is a slight rounding issue in-game that results in very slight DPS differences in the Calc. Usually the difference is extremely minor due to fractional damage values on the base weapon damage.**
5.) Once you have re-created your in-game DPS in the Calc, apply any other skills / items / gems that you would like to see calculated in. **Good test skills for this are Wrath of the Berserker, Overpower, Battle Rage since you can verify the damage on your character sheet.**
*For Strongarm Bracers and Depth Diggers, you must put the % value of the bonus in before it will be calculated in.*
**Gems that are selected scale based on the LVL, and include any lvl 25 bonuses, so make sure you have your correct level included!**
If you follow these steps, you should see extremely reliable DPS numbers in the top right, broken down into Buffed DPS, Elemental DPS and Elemental / Elite DPS, as well as character stats that are all dynamic to the changes you make. I find this extremely useful when deciding which passives / skills do the most in a fully - buffed situation.
Skill Section Usage:
1.) Put the Weapon % value of the skill in the top box of each skill.
2.) If using Frenzy (Skill #1), make sure to select from the "skills" section with the Rune you have since the speed boost will be calculated under the skill DPS only, and not in your Sheet DPS. Other Primaries, just choose if you have a Damage boosting rune or not.
3.) Put the duration of the skill if a DoT for Skill #2 and Skill #3 (Rend, Earthquake)
4.) Select Ancients if using Ancients (Skill #3) since they currently multiply differently than other skills.
These numbers are a lot harder to verify, but so far I have seen pretty realistic numbers using this tool. Realize for AoE skills, this will only show you the DPS of attacking a single mob!
Made some updates to the Calc based on feedback in the Blizz forums! Pretty much set to go until any new changes arise. I was able to calc out a way to get ancients doing roughly 170 mil dps using gear I have, minus a few lvl 30-ish gems.
Discovered a multi-speed bonus in the formula for dual wield. Will have new version online tonight with the fix (already fixed on my end, just need to upload to server).
If I had any idea how to do that sort of stuff, I would. I have also been trying to figure out a way to save the filled-out calc locally, so people could re-load previous "builds", but so far haven't gotten very far
Possibly some kind of export/import feature? It's not exactly elegant but exporting text to a notepad program and copying it back into the website somewhere would be miles ahead of having to re-enter every time. No idea how difficult it is to design this stuff but that seems like it would be the simplest.
So you have no idea how to do something, but you think it would be easiest? What you described would require creating an export command that spits each of the 120+ input fields out into some sort of notated file, then an import command to read that file, and know where to put all the information back into the form.
If it was as simple as that, I would have tried it. In fact, I have tried similar using cookies to save values from session to session, but it doesn't quite work. I appreciate the feedback, but considering how much work I have already put into this, unless someone has a good link to check out or is willing to help with the code-end of things, nothing will be changing in the near future.
Well I am still unable to get it to work with a local saving feature, so here's the next best thing: The spreadsheet itself! There is a new link at the top to download the original spreadsheet used to create the webpage.
It is Excel 2007 file (.xlsx), and requires 2007 or newer to function due to some of the formulas. If you don't have Excel, I'm sorry but that's all can offer at the moment.
I'll continue to poke around with saving features, but this will allow you to save locally as many "builds" as you want!
Whirlwind is a different animal... there are speed breakpoints involved. The calc will give you extremely accurate results for "character sheet" dps including all buffs (many of which you can check in-game), and helps see which gem / item / skill combo will pump up your damage the most. As for the skills portion of the calc, it is meant to be a general guideline.
Whirlwind doing 325% weapon damage per second means it's actually doing several smaller hits (roughly 108% per hit) every .33 seconds. As you increase attack speed, you can actually reach a point where you begin hitting 4 times per second for the same value, increasing the overall damage per second. The calc will not accurately show that. Also, all skill damage is based on single target, so something like WW doing damage to 4-5 targets begins to become "guess-work".
Overall, the calc will help you decide your build / gear combo to min / max that character sheet damage, which should translate well with skill selection.
General DPS Calc Usage:
1.) Fill out all the gear stats from your in-game character.
2.) Fill out the "Paragon" section using the actual values, not paragon points (ex: 6.8 IAS, 45 CHD, 5 CHC)
3.) Use the "Sets" section to apply any set bonuses. **Currently only sets that directly increase damage are included. I will add CDR ones (Born's, Captains) in later.
4.) Use the "Skill" section to add in any passives / skills that will apply to your character sheet while standing/running in town. (Weapon Master, Hexing Pants, Battle Shout) Use this to verify your character DPS in-game matches the Calc. **If you are using a weapon with the +% damage modifier, there is a slight rounding issue in-game that results in very slight DPS differences in the Calc. Usually the difference is extremely minor due to fractional damage values on the base weapon damage.**
5.) Once you have re-created your in-game DPS in the Calc, apply any other skills / items / gems that you would like to see calculated in. **Good test skills for this are Wrath of the Berserker, Overpower, Battle Rage since you can verify the damage on your character sheet.**
*For Strongarm Bracers and Depth Diggers, you must put the % value of the bonus in before it will be calculated in.*
**Gems that are selected scale based on the LVL, and include any lvl 25 bonuses, so make sure you have your correct level included!**
If you follow these steps, you should see extremely reliable DPS numbers in the top right, broken down into Buffed DPS, Elemental DPS and Elemental / Elite DPS, as well as character stats that are all dynamic to the changes you make. I find this extremely useful when deciding which passives / skills do the most in a fully - buffed situation.
Skill Section Usage:
1.) Put the Weapon % value of the skill in the top box of each skill.
2.) If using Frenzy (Skill #1), make sure to select from the "skills" section with the Rune you have since the speed boost will be calculated under the skill DPS only, and not in your Sheet DPS. Other Primaries, just choose if you have a Damage boosting rune or not.
3.) Put the duration of the skill if a DoT for Skill #2 and Skill #3 (Rend, Earthquake)
4.) Select Ancients if using Ancients (Skill #3) since they currently multiply differently than other skills.
These numbers are a lot harder to verify, but so far I have seen pretty realistic numbers using this tool. Realize for AoE skills, this will only show you the DPS of attacking a single mob!
Changelog:
-8/25/2014
Is there any way we can be lazy and just export our battle.net profile so we don't have to enter each stats one by one?
If it was as simple as that, I would have tried it. In fact, I have tried similar using cookies to save values from session to session, but it doesn't quite work. I appreciate the feedback, but considering how much work I have already put into this, unless someone has a good link to check out or is willing to help with the code-end of things, nothing will be changing in the near future.
It is Excel 2007 file (.xlsx), and requires 2007 or newer to function due to some of the formulas. If you don't have Excel, I'm sorry but that's all can offer at the moment.
I'll continue to poke around with saving features, but this will allow you to save locally as many "builds" as you want!
Whirlwind doing 325% weapon damage per second means it's actually doing several smaller hits (roughly 108% per hit) every .33 seconds. As you increase attack speed, you can actually reach a point where you begin hitting 4 times per second for the same value, increasing the overall damage per second. The calc will not accurately show that. Also, all skill damage is based on single target, so something like WW doing damage to 4-5 targets begins to become "guess-work".
Overall, the calc will help you decide your build / gear combo to min / max that character sheet damage, which should translate well with skill selection.