Ok, i can't seem to find this, and it's not very clear to me, but if i use a 5 SnD 5 Rupture 5 Envenom rotation on bosses, which cycle should i select in the spreadsheet?
The thing that got me going was the fact that i got [Split Greathammer], and the spreadsheet shows it as a DPS decrease from [Fang of Truth], which i find hard to believe, even with the 1.6 speed and me being sword specced at this moment.
Going off the top of my head here but the terminology might not be exact.
You would specify a XsYrZe cycle. Set it to Envenom over Eviscerate and set the combo points for each finisher at 5.
I didn't see a post about it anywhere, and you likely already know this, but the spreadsheet doesn't seem to account for human racials. I select my race as human, and I am using swords in both hands but my expertise is never accurate.
Is there a way to add this in myself so AEP and upgrades are calculated correctly?
The expertise for both dwarf and human racials is accommodated correctly by the spreadsheet, but it does not display in the headers on the four main settings sheets ("Talents & Settings," "Gear," "Buffs," "Cooldowns") because it is applied on a per-hand basis for each ability.
Originally Posted by Caffeine
I am a bit unsure about this, to me it seems that haste procs are not added properly. If I manually change a trinket without any on use effect or procs and set it to passive 74 crit rating and 92 haste rating (this is the average given for Meteorite Whetstone for my gear in DPS Calc 3) I get roughly 20 more DPS using this passive trinket than with Sphere of Red Dragon's Blood or the Meteorite Whetstone as it is implemented in the sheet.
Turns out you were correct and there will be a forthcoming update to fix the bug that was causing this.
Version 0.4.1 is available via the download link in the first post. Changes:
- Reordered calculation of armor effects on Killing Spree to be consistent with other calculations.
- Removed Drums of Battle and Drums of War.
- Added Enchant Gloves - Precision.
- Moved "Saved DPS" field to Gear sheet and added instructions.
- Fixed an error where haste procs were not properly feeding into the cooldown model.
- Fixed an error when selection "None" for your meta gem.
The error with respect to proc-based haste and the cooldown model is the most significant part of this update, and everyone who uses [Meteorite Whetstone] pretty much needs to download this. Most of the other changes are incidental.
Going off the top of my head here but the terminology might not be exact.
You would specify a XsYrZe cycle. Set it to Envenom over Eviscerate and set the combo points for each finisher at 5.
Made the changes, and even with this spec Talent Calculator - World of Warcraft it shows the mace as being a downgrade by about 10-15 dps.
Do you guys find this appropriate? I know it's a mace (1.6 speed) vs a sword (1.5 speed) but still, it has ~35 more dps, plus the stats.
Made the changes, and even with this spec Talent Calculator - World of Warcraft it shows the mace as being a downgrade by about 10-15 dps.
Do you guys find this appropriate? I know it's a mace (1.6 speed) vs a sword (1.5 speed) but still, it has ~35 more dps, plus the stats.
If you want to compare the two Weapons do it without any kind of weaponspecialisation selected. You will see the Mace indeed being superior to the sword.
The sword in your case is that good, as its faster Speed not only triggers more Combat-Potency Procs (increasing cyclespeeds) but also more Swordspec-Procs per minute (which are executed with your Mainhand-Weapon, meaning the better the Mainhand the better a slower offhand).
... but also more Swordspec-Procs per minute (which are executed with your Mainhand-Weapon, meaning the better the Mainhand the better a slower offhand).
I assume you wanted to say "faster offhand" because anything else wouldnt make sense. Just clarifying.
While checking out some gear upgrades, I noticed that the dps-gain of the 2-pieces and 4-pieces Bonescythe setbonus seems to be quite low and lackluster.
While checking out some gear upgrades, I noticed that the dps-gain of the 2-pieces and 4-pieces Bonescythe setbonus seems to be quite low and lackluster.
Added Rating Conversions and Pawn import strings for AEP, EP, and DPS
They are currently hard-coded to level 80, but why even bother with this if you're not 80 yet.
I updated the sheet to include your EP & DPS strings. Good idea.
However, the conversion to ratings was unnecessary, as the values already represented ratings, and not %. I updated the description to make that more clear.
I also fixed the stupid bug where 2 EP was worth only 1 point. Should be 2 of course. After all, these are values derived from AP...
No changes beside those, just did a quick check if it works with 0.4.1, which seems to be the case.
I don't have Excel on my computer, does anyone know any other way to get the spreadsheet to work without it? If not, then is using the AEP system my best way to compare upgrades?
Version 0.4.1 is available via the download link in the first post. Changes:
- Reordered calculation of armor effects on Killing Spree to be consistent with other calculations.
- Removed Drums of Battle and Drums of War.
- Added Enchant Gloves - Precision.
- Moved "Saved DPS" field to Gear sheet and added instructions.
- Fixed an error where haste procs were not properly feeding into the cooldown model.
- Fixed an error when selection "None" for your meta gem.
The error with respect to proc-based haste and the cooldown model is the most significant part of this update, and everyone who uses [Meteorite Whetstone] pretty much needs to download this. Most of the other changes are incidental.
Handful of notes:
1. Titansteel Shanker is not listed in the MH weapons
2. Greater Assault (wrist enchant) is 50 AP now, not 38
3. The bonus socket on the belt at least doesn't seem to work anymore. You can select Eternal Belt Buckle but it doesn't seem to add in the gem value anywhere
3. The bonus socket on the belt at least doesn't seem to work anymore. You can select Eternal Belt Buckle but it doesn't seem to add in the gem value anywhere
This part is because the A72 is looking for a Titanium Belt Buckle, instead of Eternal Belt Buckle for some reason. Can change it to fix that part.
Uh, I obviously know how to add it myself. But I mentioned it because I'd suspect it would be a common choice for a main hand weapon, and thus should be on the default list.
Also, the space isn't really limited because you can just add a row and change the named regions.
Pardon me if this has been answered earlier but out of curiosity, why is the armor value 11990 in spreadsheet? Are the armor values flawed in thread like Wrath boss armor testing or where does 11990 come from? I know it's really simple to change it, just curious which number is correct one.
With the appropriate spec and the same enchant shouldn't [Librarian's Paper Cutter] typically be a better OH than [Fang of Truth]? Even taking the significantly better weapon stats, human racial and the boost from sword spec in to account, .2 spd and 10 dps seems huge. However, I'm seeing the fang as giving me about 40 more dps on the sheet. I generally trust the sheet. What am I forgetting or misunderstanding?
EDIT: swapping my poisons narrowed the gap to 13 dps.