Gruntle

I appreciate that you're looking into this. I'm not sure if there are different versions of OO that can handle it different as well.

The spreadsheet version it's working in is 1.1.3, not sure if that was the latest version before you remade the sheet. but I guess the link to that version should still be in the old thread. If you can't find it I can probably post the script (or upload the sheet again). From what I can tell, that script is just a recorded macro (adding +1 to each of the stats, str/crit/agi/hit/AP and checking the output damage).

 

kyote

Ähem.
I just tried this new Badges Neck with Expertise an Hit Rating in the Spreadsheet, and it says, that its the best DPS Neck available at this time.

Am I making mistakes? Or is Expertise really that strong?

With my actual gear I could push my DPS up to 30 more with it.

 

Gruntle

Have you actually tried to look around in the thread before asking? There is a bug in the latest test version of the sheet with expertise (1% per expertise is used instead of 0.25% for gear and racial expertise). A fix was posted some pages ago.

 

kyote

Hm.
So im the Dumb because I missed this Information on a 13 Pages Thread? (that I've read, but not in fully detail)
KK


Thx for the Info anyways.

 

Alaron

I'd like to request that the sheet be updated to reflect the effects of a few talents in the Protection tree. Specifically, Vitality, One-Handed Weapon Specialization, Devastate, and the earlier mentioned Defiance expertise change in 2.3.2. Focused Rage would be helpful also, though it seems like that would be a more expansive change. None of the others seem like they would be particularly difficult to factor into the spreadsheet's equations, but I'd rather not fool around with them myself.

Protection warriors aren't by any means DPS machines, but when wearing DPS gear and using Devastate/WW "cycles" they can do non-trivial DPS. As an off-tank of a guild just breaking into Hyjal/BT, I'm working on setting up some DPS gear for the many fights that don't need me. Most of the gear selection is fairly intuitive, but I would be interested in a bit more of a quantitative look at various itemization optionss given the above talents. In the end, it might not make much impact on the raid, but it is still good for personal interest.

 

Gruntle

No you're not dumb, just lazy :P. I don't know which version of the spreadsheet you're using (I don't think the expertise bug is in the 9.1.6 version). You shouldn't be using test versions and expect them to be 100% correct.

The thread wouldn't be 13 pages long if people would try to read a bit in it before asking questions that others have asked before (and that has been answered).

 

dr_AllCOM3

I would really like to have a SEP makro that works in OO. It should contain all the basic stuff I need.

Originally Posted by kyote Hm. So im the Dumb because I missed this Information on a 13 Pages Thread? (that I've read, but not in fully detail) KK

Short: Yes.

This sheet covers real DPS specs. You don't DPS with a Prot spec or very rarely and just for fun.
Protip: Collect money in the guild bank for respecs.

 

Brissa

While I understand why you might not want to put in the work required to expand the spreadsheet to include prot talents your responses are just rude and downright foolish.

Prot is not a DPS spec that much everyone can agree on. But that does not mean that prot warriors should not have a spare set that they can use on fights where they are not tanking. Sure if its progression content then they should probably respec but just because something isnt progression doesnt mean that as an individual you shouldnt strive to perform.
A spreadsheet (an extended version of yours or someone elses) would help prot warriors decide on what kind of itemization they should get in order to perform all their tasks as well as possible.

 

zaon

I modified the spreadsheet and put in my gear and provided results for this earlier in this thread. Basically the gear should be almost the same as dual wield fury gear - so you don't really need to mod the spreadsheet to compare. The difference between 17/44 and 13/5/43 (3 points in deep wounds) went from 1450 to 1200 DPS for my gear with a 6 dev/1 WW cycle.

 

Brissa

There should be some difference because for example you wont have crit rating affect flurry uptime (it will be 0 anyway).

 

Randor

Nothing stopping you, or someone else, to make one. Personally, I like keeping tanking and dps theorycrafting apart as much as possible since it just gets muddled in-between.

Plus, it's easy to spec and re-spec as needed.

This is a computer-generated message and needs no signature.

 

Kurtov

When I switch from 17/44, to 0/46/15 and put the 6 expertise in the sheet, I gain DPS. I'm not sure what gear lvl this occurs at, as I have only have Kara and below gear as of yet. Food for thought.

 

starlon

The link leads to RapidShare's root, not to the file download.

 

Gruntle

For some weird reason the SEP macro works in OO on Linux but the same macro does not work on Windows. It's just a mess to make it work (i've pm'd you the macro, but I doubt you'll make it work).

I can record a macro in the new sheet in OOBasic for you, should have some time to look at that in a day or two.

 

Liar

Bless the 50 posts per page option <_<

 

Kurtov

I'm not using the test version jackass. I know how to read.

 

Gruntle

I've only tried a 3/44/14 spec, but then I lose some dps (not much, I'm seriously considering speccing this way). I would have thought that 3 imp HS would be worth more than imp exec, but maybe I'm wrong. Also, make sure that you update the sheet (F9 in OO, bot sure what key in Excel) a couple of times between the respecs, the circular refs makes the sheet require that.

It's also possible that you hit one of the "unstable" point in the spreadsheet, where a small change in rage income leads to the addition of one more HS in the cycle. More Expertise could possibly give you more rage than 17 in arms (Impale does nothing for rage generation).

 

Machinator

Why is number of HS per cycle forced to an integer anyway? I don't see anything in the sheet that requires it to be int and it would be more accurate if you could have fractions of a HS/cycle.

"Information is ammunition."

 

Duny

Please add 12 weapon dmg to adamantite sharpening/weight stone.

 

Mem

As long as your standard raid setup doesn't include only one prot warrior respeccing isn't an option. But nevertheless I understand that Niuta doesn't want to add another variant (even though I'd use it myself). I guess the best tip for protwarriors who are not in a permanent tanking assignment while raiding is to use a fury spec in for the purpose of evaluating your gear and gear accordingly while remembering that strength will raise in its relative value to crit (no flurry, no impale).

 

Tinkeree

Filled the spreadsheet for Tinkeree (my MS warrior) the other day and noticed it said "Do not execute under 20%". Seems to be because I'm using a slam rotation, never heard about that one before though!

Does this mean I should just keep on doing the rotation even when it's button bash time for most warriors?

 

Garithras

The slow swing speed of your 2-hander is going to make it so that you can't execute often enough for it to be more powerful than slam, MS, etc. You can try dual wielding to even out your rage generation in execute range.

 

Apate

If you do this, keep in mind that the weapon specs will apply to 1h weapons. For example, when I was using a Gorehowl as 33/28, I would DW swap to Decapitator (+Malchezeen because I have crappy luck with OH and I suck at PvP).

See you, auntie.

 

Tinkeree

*nod* Kept that in mind.

Since I've put my mind on Jin'rohk, swords would be a good idea. Right now using Gorehowl as 33/28 as well!

When I'm looking for 'execute weapons' should I try to find fast swords? In other words would Spiteblade be any good, or should I just grab my Sun Eater?

 

Gruntle

For the very best execute damage you'd want
a) high rage generation
b) fast weapons (both MH/OH) to generate as much rage as possible between gcds

If you have 2 good fast weapons that's what you should use, but you shouldn't gimp yourself and use a subpar fast weapon because then your rage generation will suffer. Not sure about Spiteblade vs Suneater, the stats on the Spiteblade might make up for the slowness.