Well, it makes sense. Check your landed hits/second, if your OH is > the MH, that means WP would proc more on the OH, and the MH should be able to keep a decent uptime on DP.
Originally Posted by Aldriana
But while Vulajin is only a pale shadow of my brilliance, he still contributes a fair amount to the community so I'd feel guilty
I am having some trouble getting the spreadsheet to run. I don't know much of anything about Excel, so I am not sure how to fix it. Basically when I open the Spreadsheet after it downloads it brings up the menu of worksheets to important, and lists them in order Version History, Talents & Settings, etc. Version History loads just fine, however when I try to load anything else I get an error message : "Namebackenchantstat.. could not be translated. The name was either too long or in a format not supported by Works. Works will skip this record. Click Yes to continue loading and display other errors, Click No to continue loading and suppress further errors, or click cancel to stop loading the document". If I click yes it continuously scrolls through error messages and eventually shuts down with an error message saying Excel needs to be closed down. If I hit No it does the same thing. I was able to operate the Burning Crusade one just fine back in the day, if anyone can offer any solutions I would greatly appreciate it, and I apologize if this has been covered already, I was unable to find anything on this topic.
Now that I saw a little discussion about poisons, it made me curious about my own situation. I am a mace-specced rogue, because I am a dwarf. I got around 3300 AP, 26% crit and 227 hit rating, which gives me 6,92% increased chance to hit. Next to that I am expertise-capped. What would be the best poison to use? I am currently using wound poison on both hands.
You're asking this in a spreadsheet thread instead of using the sheet yourself?
Wound goes on the weapon with the most attacks and Deadly on the other. Only the spreadsheet can answer you if double Wound is a DPS gain for your gear.
Well, as the dwarven racial isn't properly implemented, I'm asking it in here. I don't understand why I received an infraction, because the sheet is not working properly in this case.
Well, as the dwarven racial isn't properly implemented, I'm asking it in here. I don't understand why I received an infraction, because the sheet is not working properly in this case.
Vulaj, your spreadsheet is indicating to me that 5s/5r is superior to 5s/5r/5evis, what would be the reason for this? I am running the Rupture glyph. Was under the impression 5/5/5 was the superior rotation these days.
Doing a 5/5/5 I never see SnD drop, but rupture can and does drop at times depending on the fight.
Any settings I should adjust on the sheet to maybe adjust for better results?
I wouldn't be at all surprised if Xs/5r cycles are still superior. However, I wouldn't say the cycle models are necessarily 100% accurate for any cycles involving Seal Fate or Glyph of Sinister Strike. Aldriana's Mutilate sheet has a much more accurate modeling style that I may adapt for Mutilate and Combat cycles in a future version of the sheet.
I wouldn't be at all surprised if Xs/5r cycles are still superior. However, I wouldn't say the cycle models are necessarily 100% accurate for any cycles involving Seal Fate or Glyph of Sinister Strike. Aldriana's Mutilate sheet has a much more accurate modeling style that I may adapt for Mutilate and Combat cycles in a future version of the sheet.
What machanics would make 5s5r superior to 5s5r5e if SnD never falls and Rupture only falls once in a blue moon? If I went 5s5r I would be overwriting SnD with 15-20+ seconds left.
Just because you have 36 or 34.5 or however many seconds of Slice and Dice time, doesn't mean you need to use every last one of them. Cutting your Slice and running 5s/5r means higher Rupture uptime, or in other words more effective Rupture DPS, which could conceivably be a greater gain than Eviscerating once per cycle.
Just because you have 36 or 34.5 or however many seconds of Slice and Dice time, doesn't mean you need to use every last one of them. Cutting your Slice and running 5s/5r means higher Rupture uptime, or in other words more effective Rupture DPS, which could conceivably be a greater gain than Eviscerating once per cycle.
Ya because of this I reglyphed for AR over SnD. Is the spreadsheet modeling the Glyph of AR in its current incarnation? With the 1 minute off KS as well? And has blizzard commented on this? Is it working as intended or bugged at the moment?
*Edit* The closer I get to 100% rupture uptime, the better 5s5r5e will become, correct?
*Edit* The closer I get to 100% rupture uptime, the better 5s5r5e will become, correct?
Yes. Assuming 100% SnD uptime and Rupture uptime, the only situation where it would not be better to run 5s5r5e over 5s5r would be if Sinister Strike had higher DPE than Eviscerate, which is not only unlikely but I'm not even sure if it happens at any possible AP.
My understanding of stat weights suggests that 32 AP should never outpace 16 agility for raw DPS. It seems unlikely that such a basic calculation is wrong in the spreadsheet, and so I'm left scratching my head. What have I overlooked?
Stat weights aren't static. If you think the spreadsheet rates every stat for the EP weight that's given to them, it does not. The spreadsheet weights stats in a much more complex manner.
Originally Posted by Aldriana
But while Vulajin is only a pale shadow of my brilliance, he still contributes a fair amount to the community so I'd feel guilty
Basically, and this is what I've discovered as well, it's best to test each potential gem slot individually using the spreadsheet to see what will produce the most dps, rather than assuming what worked previously will hold true again.
Stat weights aren't static. If you think the spreadsheet rates every stat for the EP weight that's given to them, it does not. The spreadsheet weights stats in a much more complex manner.
I appreciate your response, but I'm hoping to get a bit more detail. I am a pretty cookie cutter mut rogue.
16 Agility = 16 AP + 0.192% crit
and so my spreadsheet says that 0.192% crit chance < 16 AP
This seems to suggest that 2 AP will always be more powerful to raw DPS than 1 agility, as it was in BC. My understanding was that this had changed, largely due to Crit gaining value from Focused Attacks.
Is there some diminishing returns curve/spreadsheet on crit that someone could direct me to that would explain this discrepancy, or have I just been overestimating the value of crit?
Thank you
EDIT: My armory puts my crit chance at only 24.20%, including crit rating of 378, and my AP is 2357 if that adds any useful information.
I appreciate your response, but I'm hoping to get a bit more detail. I am a pretty cookie cutter mut rogue.
Neto- is saying that weighting and value for each stat will change as your gear/enchants/gems change. With your current level of gear it's likely that you gain a lot less DPS from abilities like Lethality and Focused Attacks than from Specials/White/Poisons that scale well with AP. Therefore, it's likely that AP is a better scaling stat. As you get better gear this may or may not change.
I appreciate your response, but I'm hoping to get a bit more detail. I am a pretty cookie cutter mut rogue.
16 Agility = 16 AP + 0.192% crit
and so my spreadsheet says that 0.192% crit chance < 16 AP
This seems to suggest that 2 AP will always be more powerful to raw DPS than 1 agility, as it was in BC. My understanding was that this had changed, largely due to Crit gaining value from Focused Attacks.
Is there some diminishing returns curve/spreadsheet on crit that someone could direct me to that would explain this discrepancy, or have I just been overestimating the value of crit?
Thank you
EDIT: My armory puts my crit chance at only 24.20%, including crit rating of 378, and my AP is 2357 if that adds any useful information.
Wherein does your confusion lie? 2 AP is better than 1 agility. You are probably overestimating the value of crit (also in regards to aggro generation, which is not even counted in the pure DPS)
Remember: AP affects evisc & envenom, raw autoattacking, and poisons as well.
I appreciate your response, but I'm hoping to get a bit more detail. I am a pretty cookie cutter mut rogue.
16 Agility = 16 AP + 0.192% crit
and so my spreadsheet says that 0.192% crit chance < 16 AP
This seems to suggest that 2 AP will always be more powerful to raw DPS than 1 agility, as it was in BC. My understanding was that this had changed, largely due to Crit gaining value from Focused Attacks.
Is there some diminishing returns curve/spreadsheet on crit that someone could direct me to that would explain this discrepancy, or have I just been overestimating the value of crit?
Thank you
EDIT: My armory puts my crit chance at only 24.20%, including crit rating of 378, and my AP is 2357 if that adds any useful information.
For some reason you seem to be under the impression that EP values are a fundamental aspect of mechanics and that spreadsheet models are based off those. In reality, EP values are calculated from spreadsheets (or simulations, for some other classes) that model the actual mechanics of the game. There are extremely complex interactions between a wide variety of factors that result in the DPS contributions you observe from different stats. There is no simple curve that incorporates all of these factors.
For example, crit does increase your Focused Attacks procs, therefore increasing the frequency with which you perform Mutilates and finishers, and it also increases the rate at which you crit everything you can crit, thereby increasing your average damage on those abilities. On the other hand, AP applies a direct increase in damage dealt by all of your attacks, including auto attack, Mutilates, finishers, and poisons. Each of these two stats also increases in value as you increase the other one.
I have been having a problem in which every time I go to replace one of my Rigid Autumns glow hit gems that when I go to replace it w/ Bright Flawless Ruby or even Bright Cardinal Ruby my dps always goes down. My hit is currently 315 and this just cant be.
The other day I even switched out my Drake-Champion's Bracers for the Wymrest Dragonfriend Bracers. Of course I know the Dragonfiend are better but I just wanted to test it out. My dps promply dropped in the spreadsheet from
2206.60 to 2204.90.
I asked on the wow forums and all told me that non of them had this problem w/ the spreadsheet and that it wasnt obsessed w/ having more hit like mine was. A few of them even put in all my stats and still had no idea how it was happening for me.
I have been having a problem in which every time I go to replace one of my Rigid Autumns glow hit gems that when I go to replace it w/ Bright Flawless Ruby or even Bright Cardinal Ruby my dps always goes down. My hit is currently 315 and this just cant be.
This is really getting old. Your metagem stopped working.
Originally Posted by Aldriana
But while Vulajin is only a pale shadow of my brilliance, he still contributes a fair amount to the community so I'd feel guilty
This is really getting old. Your metagem stopped working.
On this note, perhaps a few slight modifications to the "summary" box (at the top of the main pages) would be effective at putting an end to these types of questions.
In particular:
- A box that turns red when your meta gem is not properly activated, similar to the way the hit rating box turns red when you are below the special hit cap.
- Listing expertise on a per-hand basis.
Just a quick observation over the last few weeks of using the Spreadsheet since LK.
I'm currently running a 7/51/13 setup with 5/5 Sword Spec, 5/5 CQC and 1/2 SnD [For the record, using [Kel'Thuzad's Reach] MH and [Widow's Fury] OH]. However, even when switching back to a 7/51/13 with 5/5 CQC, 2/2 SnD (with the other points spread variously) using [Kel'Thuzad's Reach] MH and [Webbed Death] OH I don't gain any DPS, in turn, I actually lose DPS.
Doing some more testing I found DPS value doesn't change with either 1/2, or 2/2 in SnD. I was under the assumption the [Kel'Thuzad's Reach] MH and [Webbed Death] OH would be the most OPTIMAL setup for Combat [Subbing in [Calamity's Grasp] into MH obviously when attained].
Is this simply not showing an increase in DPS because the Spreadsheet assumes that with 1/2 SnD, SnD Glyph and Rupture Glyph you can keep a 4s/5r 100% uptime - and with the stats on [Widow's Fury] just buffs it that much more? Or does [Kel'Thuzad's Reach] MH and [Widow's Fury] OH infact pass due to Sword Spec?
If that is the case, would a 4/5 Sword Spec, 2/2 SnD be more optimal? Even though the Spreadsheet shows that 5/5 Sword Spec, 1/2 SnD more viable DPS.