Warrior DPS Calculation Spreadsheet - Page 51

NaturesVoice · 05/07/09, 12:46 PM

Hello,

First of all I'm not sure if this is the best thread for me to post this in because it does not directly have to do with the spreadsheet but because it concerns both the fury and the arms tree I thought it was best to post here.

After seeing the BiS gear list of both fury and arms I noticed that they don't vary much from each other. So it crossed my mind to dual spec for both a fury and arms raiding spec.

Now I have gone through the fury dps and arms dps threads and this spreadsheet thread and tried to figure out which fights favor one or the other spec.

Sofar I found that stationary fights like xt-002 favor arms dps. I myself raid mainly as fury but I find the idea fun and challenging to change during a raid to an arms spec if that gives better dps.

So my list would be:
fury:
razorscale
ignis
iron counsil
hodir
thorim
freya
general vezax?

arms:
xt-002
kologarn
auriaya
general vezax?

We haven't gotten further then the general yet.

Thanks in advance.

Edit: grammar mistake

ebs2002 · 05/07/09, 1:19 PM

Basically gear-wise I dropped about 90 AP, 52 hit (unbuffed) to gain 45 ArP, about 0.9% crit, and 121 haste, which the spreadsheet was showing should be a 102 dps increase. I'll see what testing I can do tonight.

A loss of 52hit could change your heroic striking considerably; is it possible that you were HSing too frequently and rage-starving yourself?

I've found that any time my hit changes drastically, it takes me a day or so to get back into the rhythm of when to HS without thinking about it. Even if I'm HSing when I'm supposed to, my rotation can lag if I'm thinking about it too much.

Just a thought.

Wishmaster · 05/07/09, 3:29 PM

Hello everybody,
I'm a new member, I'm trying to follow up with the posts about fury dps, I'm not doing great following up

due to lots of things to do beside wow and reading forums. I have a question, as i couldn't understand the spreadsheet which i will try to find a post on how to read it, my question is that gear in the spreadsheet is it confirmed its the best dps gear so far? if not, what is the suggested best dps gear?

Finally, as we warriors depend on hit rating, my hit rating now is 209 which i know its low and i should increase it, but i was looking at ulduar gear, should i gem it as we used to do, strength? or use hit gems till i get to the hit cap again?

I really appreciate your help.
Best Regards

rocco1015 · 05/07/09, 3:43 PM

Originally Posted by Wishmaster

Hello everybody,
I'm a new member, I'm trying to follow up with the posts about fury dps, I'm not doing great following up

due to lots of things to do beside wow and reading forums. I have a question, as i couldn't understand the spreadsheet which i will try to find a post on how to read it, my question is that gear in the spreadsheet is it confirmed its the best dps gear so far? if not, what is the suggested best dps gear?

BiS gear is regularly updated on the first page of this very thread.

In regard to your hit rating question, in almost every situation, you should do your best, either with gear or gems, to get to the yellow hit cap for your spec. It would behoove you to continue playing with the spreadsheet until you get the hang of it. It is a great tool and worth the time it takes to learn how to use it.

vlj · 05/07/09, 11:10 PM

[Frigid Strength of Hodir] & [Soul-Devouring Cinch] for fury BiS list

rejdakon · 05/08/09, 3:35 AM

Originally Posted by Wishmaster

Finally, as we warriors depend on hit rating, my hit rating now is 209 which i know its low and i should increase it, but i was looking at ulduar gear, should i gem it as we used to do, strength? or use hit gems till i get to the hit cap again?

First of all, Warriors are no more dependant on Hit Rating than other mellee classes. I know some will contradict me, citing smooth rage generation as a reason, but above the soft cap, hit is not a warrior's main issue.

With 209 Hit Rating you are definitely not low on Hit Rating. As your Alliance-side, you should sit slightly below 10.5% to Hit with that. That's 2.5% above the soft cap and should be sufficient for reasonable HS Usage. At that amount of Hit Rating you should definitely NOT gem for Hit.

Even if you were only slightly above the soft cap, you should not gem for Hit. While it does make rage generation smoother and can prevent messing up your rotation due to miss streaks, it is worse than almost any other DpS-stat point for point (above the soft cap). In almost all cases, you can prevent messing up your rotation by using HS intelligently instead of mashing the button. If you want 100% HS usage in fights without incoming rage, Hit is probably the way to go at pre Ulduar gear level, but that will most likely not give you the maximum DpS.

Depending on your present gear, you should gem either for Strength oder for ArP, although with a few pieces of Ulduar Gear, ArP is very likely the way to go, especially if you're using Grim Toll or the Mjollnir Runestone.

But use the spread sheet to determine which stat is better at your level.

rejdakon · 05/08/09, 3:47 AM

Originally Posted by foopeemoa

I've actually noticed that lately as well and it's been puzzling me. I swapped some gear out for last night's raid, that according to the spreadsheet should've changed my theoretical dps from 5235 to 5337, yet my dps on bosses dropped from the 4600 range to around 4000. It was really confusing, all raid buffs should've been the same (unless someone stealth-respecced), and other dps classes didn't seem to have problems. Unfortunately I was the only dps warrior (we have a feral druid & combat rogue), so I didn't have anyone else in for comparison. Tonight I'll pull my old gear out of the bank and try to compare more thoroughly. My latency seemed consistent, it's always in the 60-90 ms range. I had no rage problems with either gearset, I was able to keep up HS nearly 100%. It's possible I was hitting Berserker Rage more often than before to maintain rage, but I'm not sure.

Basically gear-wise I dropped about 90 AP, 52 hit (unbuffed) to gain 45 ArP, about 0.9% crit, and 121 haste, which the spreadsheet was showing should be a 102 dps increase. I'll see what testing I can do tonight.

Relying on "empiric" observations is probably not the best way to go when monitoring your DpS-output. Especially if it's only for one night of fights. Log your fights and compare the numbers, and by that I don't mean the raw DpS-numbers but the reasons for differences in DpS. Did you miss some specials due to white hit miss streaks and rage starvation, HS usage, length of fights (this is a major factor for fury warriors), unlucky Crit percentage, missing buffs/debuffs, etc.

If the loss of 52 Hit does not take you below the soft cap, I see no way that trading 90 AP and 52 hit for 45 ArP 0.9% Crit and 121 Haste can lead to a loss of DpS, especially not 600 DpS. Something else must be seriously wrong.

Draganos · 05/08/09, 6:20 AM

anything new about excel solver to put in the best suited gems for max dps??

If anybody could tell us the right fields and secondary terms solver would be the ultimate tool for gems in our spreadsheet...

AND: Landsoul, you should impove the dropdown menu from the item selection with telling which items we alredy heave.

e.g. the drop down looks then for for helemts we have like.... all items we currently have in our inventory are marked with (x)! so its easier to try different items.

Guise of the Midgard Serpent (x)
Obsidian Greathelm
Warhelm of the Champion (x)
Garona's Guise (x)
Conqueror's Siegebreaker Helmet
Helm of the Furnace Master(x)
Valorous Siegebreaker Helmet

Well, a nice solution would be a simple checkbox right to every item in the lookup tables... that automaticly adds "(x)" after the name if you activate the checkbox...

I have not enough excel skills to realize it but maybe you can...

samot · 05/08/09, 6:54 AM

I'm missing
+26 Agility as Weapon Enh.
and the [Pristine Monarch Topaz] (+16 AP +8 Hit)

Schiwing · 05/08/09, 10:55 AM

Originally Posted by samot

I'm missing
+26 Agility as Weapon Enh.
and the [Pristine Monarch Topaz] (+16 AP +8 Hit)

These are two inferior enhancements; any other enchant is better, and there's an orange 8 strength + 8 hit gem cut.
But, if you want to see it, you can use the phoney stats section to add the stats you're missing.

Tenge · 05/08/09, 12:56 PM

Originally Posted by foopeemoa

I've actually noticed that lately as well and it's been puzzling me. I swapped some gear out for last night's raid, that according to the spreadsheet should've changed my theoretical dps from 5235 to 5337, yet my dps on bosses dropped from the 4600 range to around 4000. It was really confusing, all raid buffs should've been the same (unless someone stealth-respecced), and other dps classes didn't seem to have problems. Unfortunately I was the only dps warrior (we have a feral druid & combat rogue), so I didn't have anyone else in for comparison. Tonight I'll pull my old gear out of the bank and try to compare more thoroughly. My latency seemed consistent, it's always in the 60-90 ms range. I had no rage problems with either gearset, I was able to keep up HS nearly 100%. It's possible I was hitting Berserker Rage more often than before to maintain rage, but I'm not sure.

Basically gear-wise I dropped about 90 AP, 52 hit (unbuffed) to gain 45 ArP, about 0.9% crit, and 121 haste, which the spreadsheet was showing should be a 102 dps increase. I'll see what testing I can do tonight.

Who is usually applying your major armor debuff? (Though you did specify that you were the only 'dps' warrior, so perhaps you do have a prot' who was there in both scenarios.) Just a thought, when I saw 'only' and 'warrior'. Losing Sunder would be a pretty dramatic DPS loss, if that was in fact the case.

Draganos · 05/08/09, 3:08 PM

Landsoul...

I just wrote an VBA Macro which translates the lookup list into any other language, you only need a new sheet with the english word and the equivalent translation.

The macro works but every time the original names are changed (even without macro - changing by hand the name) the SEP calculation stops with error #NV ??

Whats going on? why is the name not changeable sometimes?

If we can get this working, a new sheet in your spreadsheet can translate all items into any desired language.

Pls Help. Why does sep calc stop when changing names in Lookup table?

EDIT:
I tested it. some items can be renamed successfully.

But e.g. renaming "Might of the Leviathan" into any other name makes the #NV error. there are other items i cannot specify now but why the hell is this??

Schiwing · 05/08/09, 3:50 PM

I found a problem with gem selection (possibly only '97/03 excel) a few builds ago and thought maybe it would have been corrected with the latest version, however, it persists.

When placing a +20 or some of the +10/10 gems into the leg's first gem slot, various N/A errors occur across the sheet.
This happens with Valorous Dreadnaught Legplates, Plated Leggings of Ruination, Legguards of Cunning Deception, and Conqueror's Siegebreaker Legplates.
I am sure these are not the only pieces that can induce this error; I wanted to rule out the error being caused by the item itself.

The following gems will cause the error.
+20: arp, exp, str, crit, haste, and hit
+10/10: agi/crit, agi/hit, exp/hit, str/crit, str/haste, and str/hit

I would like to add/reiterate that this only occurs with the first gem slot and not subsequent slots and is for the leg section only.

Kaan · 05/08/09, 8:34 PM

I've been using your spreadsheet for quite a while, and it's always been a really good measure for me - at least until recently. As you well know, the gear in non-hard mode Ulduar has the general theme of hit rating and armor penetration, and while equipping the pieces shows a nice increase on your spreadsheet, I'm finding my DPS is falling off drastically.

I've tested many gear setups with high hit and low hit - and the high hit setups were almost never worth the DPS shown in the spreadsheet. My speculation on that is, that the spreadsheet accounts for fight durations of 10 to 20 minutes. In 10 to 20 Minutes hit rating may be worth what the spreadsheet told you, because you miss a lot less on whitehits. But in shorter fights, there's not such a big possibility to miss lot of whitehits. That's leading to a possibility of DPS loss due to more or less useless hitrating (over the style cap).

Glory · 05/08/09, 9:01 PM

Originally Posted by Kaan

I've tested many gear setups with high hit and low hit - and the high hit setups were almost never worth the DPS shown in the spreadsheet. My speculation on that is, that the spreadsheet accounts for fight durations of 10 to 20 minutes. In 10 to 20 Minutes hit rating may be worth what the spreadsheet told you, because you miss a lot less on whitehits. But in shorter fights, there's not such a big possibility to miss lot of whitehits. That's leading to a possibility of DPS loss due to more or less useless hitrating (over the style cap).

Absolute Bullshit you write here. Shorter Fights = More RNG dependant -> less Hit = higher difference between max and min DPS.

Lets say you could Run with 0 Hitrating in a 1 Minute Fight. you have around 60 Attacks (as MS). You can have a lucky try and 0 misses. Or you Miss 20 Times. Dps difference = 50% or 33% (only depends on which dps number you take to compare). If you run a 10 Minute Fight its more likely to miss around 48 Times out of 600 Attacks with 0 Hitrating.