dr_AllCOM3

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

 

Eliminate2

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?

 

dr_AllCOM3

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.

 

Eliminate2

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

 

Eliminate2

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.

 

rayijin

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

 

Eliminate2

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?

 

Machinator

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.

"Information is ammunition."

 

dr_AllCOM3

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

 

Apfelkäse

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

 

PSGarak

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?

 

Bronwyn

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%?

 

mogun

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.

 

dr_AllCOM3

Second.

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

 

mogun

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

 

dr_AllCOM3

Yes, the order was wrong.

Also, update with more ZA stuff. Good stuff for casuals, bad for raiders.

 

Perinon

Would it be possible to add options to the spreadsheet for ~15 points into protection spec to get the +6 expertise from defiance? I'm fairly sure it will be a dps drop, but I'm curious how much of a drop it will be, and I'm not remotely competant enough to edit the spreadsheet myself.

 

Hidden

I know you can add it by yourself easily but could you please add some more items for future versions as I think they are quite good for Warriors as well?
The items I'm speaking of are:
Merciless Gladiator's Plate Legguards - They're as good as the Greaves of the Bloodwarder if I recall correctly
Kael'Thas' Leather Legguards - Don't know exactly but they should be quite good for 2h if you're hitcapped and they're worse than T5 for Rogues anyway
Bloodsea Brigand Vest from Karathress and Midnight Chestguard from Archimonde - They're under the top Warrior chestpieces for pure damage and worse than their Tier equivalences for Rogues
Leather Bracers from Rage Winterchill - Good alternative if Bracers of Eradication don't drop for your guild very often

The spreadsheet itself however is great, good work.

Edit: I found an error. Solarian's Sapphire increases your attack power by only 70 in the spreadsheet even though I have 5/5 imp. Battleshout and it's affected by the talent.

Edit2: Survival Hunter debuff is missing as well, it's easily calculated as 1/4 of a Hunter's Agility into AP. It's quite a big difference, our Hunter for example has around 1000 Agility raid buffed.

 

Gandharva

IMHO Weapon Expertise is pretty useless, because most of the time we are able to attack the bosses from behind to completely ignore doge/parry. But it's pretty useful for Tanks to build up more aggro.

 

Brissa

I hate to break this to you but mobs dodge when attacked from behind.

 

Bronwyn

Oh, hi Gandharva ^^

Not exactly: we don't ignore dodge from behind - just parry/block.

For tanks, it means much more than just threat generation! The chance to get a boss to 0 parry will mean that the tank will get less burst damage from unlucky parries.

 

Gandharva

My mistake. It's parry/block... Not dodge/parry.

 

Turpin

also good for pvp id say but ya not very useful for pve dps

 

Bronwyn

It is useful because it represents more than an alternative to HIT, why?

Once you reach 9% tohit, your styles won't miss anymore - but they can be dodged. Expertise will convert those dodges into hits. Since this also holds true for white damage, the amount of DPS you gain from expertise (after 9% toHit) is significantly higher than what you gain from an equal amount of hitrating.

 

Kloppy

I just modeled Expertise into my own DPS-Calculator and for my gear the difference between a 17/44 and a 0/47/14 or 1/46/14 build will be ~1,4% overall damage.

Its _very_ tempting to skill World of Warcraft Europe -> Game Guide -> Charakter -> Talente -> Krieger for example. Imagine the viability to tank heroics with the changes to tactical mastery.