[Warrior] DPS Spreadsheet 2.3 and beyond
 

Warrior DPS by Grim13

- With items to choose
- Up to date
- With Makros for SEP and stuff
Warrior DPS by Grim13


Warrior DPS Spreadsheet 2.08

Requires Excel 2003 / OpenOffice 2.3 or higher.
- OO compatible
- No makros

Warrior DPS Spreadsheet 2.08
Warrior DPS Tabelle 2.08

So, after looking over the sheet a few times.

It seems the spreadsheet, under "Buffed DPS" I can't find where t6 4pc bonus is modeled.
It does appear under the "Buffed Threat", in cell B19

[top]H4*IF(Gear!V7,1.05,1)

Also under "Buffed DPS", the offhand factor is indeed.

50%+(5*Talents_Buffs!E20/100/2) Cell B9
Displaying the correct value of 62.5%

But under the "Buffed Threat", the offhand factor is
=0.5+Talents_Buffs!E20/100 Cell S5
Displaying an incorrect value of 55%

Are these meant to be like this? Or is the sheet missing things?

Also, what would the proc on Warglaives be modeled as? How much constant haste?

You are missing, that threat isn't modeled.
I didn't include the Warglaives. When you have both you don't need this sheet anymore. It's game over, maximum DPS achieved.


2.3 WW seems to be about more or less what we lose with Deathwish.

Ok, lol, well, I just wanted to make a benchmark with the modeling. But that's cool.

Ok, so I am missing it. Can you point out which cell its in? T6 bonus just seems very underwhelming.

Edit: I see it now with the new spreadsheet in cell H32

Hmm, was just testing out the new spreadsheet. Sticking the brutalizer into the offhand slot seem to yield more dps then a blade of infamy.

Are the calculations for Expertise accurate? seems like a very significant factor now.

Assuming it changes dodge/parry to hit rather than miss, 1% less dodge from expertise= 1% increase in dps, up to the maximum dodge value.

1% hit only increases your dps by 1% if you are below the hit cap for specials, otherwise it's about a .5% increase. In other words, if you already have 8.6% hit (easy to achieve), rating equivalences to increase your overall dps by 1% would be:

~32 hit rating = ~16 expertise rating = ~22 crit rating

So the current values they have on live, such as the Brutalizer with 21 axe skill rating, will = 21 expertise rating? Or is the conversion different? I haven't been able to copy onto test

Also, on the Talents_Buff sheet. You included the Damage taken. On the note you mentioned, that 50.000 is good fro fights like teron. Just wondering what values are you using as a basis? Is it damage taken per sec?

A couple questions for modeling the new stuff because I havent been able to get on the PTR either.

1. I am assuming WW shows up in 2 hits like mutilate. Do they each have their own hit chance, and is the OH affected by the OH damage penalty (50/62.5%)?

2. Does Sweeping Strikes count as special attacks or does it depend on abilities used. Does WW count as 2? Pretty much will there be any difference at all if you use it on a single target?


"So the current values they have on live, such as the Brutalizer with 21 axe skill rating, will = 21 expertise rating? Or is the conversion different?"
The notes say the conversion is the same at least. so 21 skill rating is 5 expertise, or 1.25% less dodge/parry. However before skill rating had to come out to a whole number, I wonder if that still is true.

Small update. Those S3 weapons are damn good -_-.

After getting 9% Hit, woulnd't it be smart getting 23 Weapon Expertise? It eliminates dodges on special as well as white hits

Rating is rating, the point of rating is that they all have the same itemization cost. I think what you're asking though is if it gets converted to expertise at the same rate weapon skill does (and if you weren't you should be =P). The general consensus is that the rating:point conversion is the same, and the point:effect conversion is 4:1 (ie 1 expertise is .25% off dodge and parry) but the wording of any official sources seem a bit hazy on the subject. Someone should run parses to make sure it works how we think it works, and that it does in fact work, as opposed to being bugged.

I wanted to check the spreadsheet but it wanted me to sign up for a webhosting service or something, so I'll just ask: is whirlwind now a better staple attack than bloodthirst when duel-wielding?

Thanks for the quick work - may I ask how exactly Whirlwind is calculated?

2 Attacks? Both full Damage or OH Attack reduced to 50/62.5%?

The way the bonus from Imp. zerker stance is calculated, is not correct. The 10% is applied for all AP you have, not only the AP from items. (Don't know exactly for unleashed rage as we dont have an ench shammy, but I guess its the same).

So cell H156 instead of

[top]H147*H150*H151+H153 should be

(H147+H153)*H150*H151


Cheers.

Second.

Are you sure, that it's item ap only?

No, I said the opposite. It applies on ALL ap you have. But the spreadsheet calculates only for the AP from items.