Graul

The Bludgeon seems to be competetive at low level - med BT gear levels, even after the 2.3 change. It seems to lose ground at higher levels.

 

Opalira

I've been doing a lot of work with the spreadsheet lately and I've found that the bludgeon remains very solid as an OH. The haste rating still scales very well with other gear, and since its not a dagger its fast speed isn't as big of an issue.

With my current gear set I show 1335 DPS, no other OH gives more. The slow S3 items are similar, but still a little less. To experiment I made an item with the Bludgeon's stats, but with the Blade of Infamy's damage range (2.6), and I get 1345 DPS.

 

Elistion

I've been going over the spreadsheet but am relatively new to its amazingness.

Is there anywhere to calculate enchant ring - striking into the spreadsheet?

 

Graul

In my current gear, with just a Bludgeon off hand, it shows 1308, which does in fact seem to beat every other off hand at my gear level, even the season 3 axe (by 1 DPS). But at a higher gear level (new neck, rings, boots, gloves, legs, chest, helm, ZA bow) it's 1458 with the Bludgeon and 1476 with a season 3 axe. I'm not actually sure this really even translates into a "real world" difference considering the majority of numbers you see from the spreadsheet are for "optimal, in a vacuum" theoreticals. The season 3 axe does however beat out my current main hand.

 

Gruntle

I answered that question for one of the previous versions of the spreadsheet:
http://elitistjerks.com/500521-post1837.html

(cell P12 should be cell I2/K2 (MH/OH) on the Buffed dps page in the current version of the spreadsheet)

 

Darkrenown

Yup. I was going to quote the patch notes but I can't find it now. It was fixed though.

 

hawkk

This got me thinking: is 2.3 going to be the effective end of warriors using daggers due to whirlwind changes and dagger normalization?

 

Emeraude

Yes, completely.

 

Gruntle

For similar dps weapons daggers will be severely disfavored both as MH and OH. Did some back-of-the-envelope maths and it seems that the difference between a 1.6 dagger and a 2.6 sword/mace/axe is about 10 dps for kara level gear and optimal usage of WW. So if you have a crappy offhand the dagger might be preferable (less so the faster the dagger is).

 

dr_AllCOM3

I don't have Office installed right now, but I don't think I have taken normalized speed for offhands into account.
So don't be too fast about 2.3 .

 

Solva

ok i recently downloaded and experimented with the spreadsheet so as new to this conversation i have a few questions:

a) is there any way to sort armor and weapons? if yes how?
b) i noticed +crit rating contributes much to the spreadsheet dps outcome. However my background so far and my private talks with other warriors suggested going heavy for +hit. is the value of +crit thorougly proved to be better? is it a balance of stats? is there a minimum value required for different stats like hit?
c) has anyone ever considered making a list similar the one rogues have at shadowpanther.net but for warriors. if anyone would be interested i would be happy to contribute in whatever way i can.

anyway keep it up

 

Amorpheus

Well, some napkin math about offhand whirlwind with 2000/3500 attack power:

Slow offhand: 300 avg hit + 343/600 from AP = 400/563 after OH penalty
Fast offhand: 180 avg hit + 343/600 from AP = 326/488 after OH penalty (20/15% worse than slow)
Dagger offhand: 190 avg hit + 242/425 from AP = 270/384 after OH penalty (~33% worse than slow in both cases)

IMHO Dagger users don't need to panic, but obviously priorities have changed so look for that offhand upgrade.

"You are better than I am," Inigo admitted.
"So it seems. But if that is true, then why are you smiling?"
"Because," Inigo answered, "I know something you don't know."
"And what is that?" asked the man in black.
"I'm not left-handed."

 

Apate

Past 9%, hit takes a steep drop for DW warriors in the relative value compared to other stats. Hit is still nice, and it smooths rage generation, but in the big picture, past 9% hit, crit is a superior stat.

See you, auntie.

 

Gellor

Not seen it posted in here, but weapon mastery 2/2 is now only -2% on the PTR.

 

MeanVanilla

Hello,

I'm quite new her eso I'd just like to start off with saying thx to dr_Alcomm for the brilliant spreadsheet, as well as thx to all other giving brilliant input and answers.

On to my question: I am currently in choosing a weapon for my new warrior, I'm selecting between Dragonmaw and Black Planar Edge. From moddeling my aproximate gear in the spreadsheet the axe commes in on top of the hammer for DPS. I should say my warrior is an Orc an hence get's the bonus for axes. But from what I've read before (not on this forum tho) the hammer was favoured for dps for it's haste proc.

My question is, is it 2.3 that have made the axe more favourable for orcs with the 1%crit or is the info I've read before with the hammer beeing better just drivel?

Cheers,
Mean

 

Darkrenown

The 3% hit you get currently from axe skill is far better than the 1% crit you'll get in 2.3. Nevertheless the axe is better then the mace since the haste nerf.

 

Brissa

That is assuming the modeling of the value of the haste proc present in the spreadsheet is correct. The spreadsheet assumes about 20% uptime on the haste effect while myself I seem to recall numbers closer to 35% (at least when using hamstring to incur more proccs)

 

Aten

is the first time im using the spreddsheet and prolly im doing something wrong but when i change the race from tauren to human i get ### and #NUM all over the tabs.

can anyone help me, please.

 

Bulvine

I have the same issue when I select human as my race. Also does the spreadsheet take into account what the human racial will be in 2.3?

BTW I just discovered the DPS spreadsheet a week ago and I want to say thank you to DR Allcom and whoever else helped make this possible.

 

Chadw

I only get that error if I have Dragonstrike in my main hand when I switch the race to human. I haven't had that error with any other mace or sword but it seems there is an error with the human racial in the new spreadsheet.

 

Aten

Yep thats exactly my MH, and i had S2 fist weapon to my OH, had to had it as dagger, tho cause it seems that fist isnt working properlly too.

BTW how do i had Doomplate set i still have 2 pieces and i want to put the + 35 hit.

Yes i know they suck but fighting againt tanks a and priest with prio sucks.


EDIT: The caracteres show on the AGI collumn, and all over the place in Buffed tab, also on the enhants tab just on mongoose, and executioner in MH and OH, still dunno why Executioner get changed cause i dont select it wahtsoever.

 

Milfeulle

I think I have found the problem in regards to the Dragonmaw+Human being borked.

In Buffed_DPS Sheet, there is an identical error in the MH Crit Racial and OH Crit Racial fields:

[top]IF(Gear!B11

"Human",IF(Gear!D13="2h Mace",1%,IF(Gear!D13="2h Sword",1%,IF(Gear!D13="Sword",1%,IF(Gear!D13="Mace",22,0)))),0)+IF(Gear!B11="Orc",IF(Gear!D13="2h Axe",1%,IF(Gear!D13="Axe",1%,0)),0)

As you can see in the bolded part, mace is currently giving 2200% bonus crit. So, changing the "22" (I assume this was for crit rating) in the formulae back to 1% fixes the problem.


EDIT:

P.S.: I see that the current version of the spreadsheet is giving expertise for Weapon Mastery. Since it is -2% dodge now, is it equivalent to edit the expertise given to 8 (assuming 2 points) instead?

 

Gruntle

To model Weapon mastery you could also unclick the talent points and just change Base dodge on the Buffed dps page to 3.6% instead of 5.6%.

The problems with "###" in the cells is probably caused by too narrow columns in the display (that's what it shows for me anyway), just widen the column by clicking on the border and dragging it to make it broader, the numbers should appear then.

 

dr_AllCOM3

I made an update.
Some fixes of things you mentioned.
Also now threat. Have a look into it and report wrong stuff.

[Prism of Inner Calm] is kinda underwhelming .

 

Talida

Thanks for the great work dr_AllCOM3, but i wonder if it is possible to add the ring enchants to the sheet, as well as the SV Hunter skill Expose Weakness (w/ dropdown menu to set the agility of the SV Hunter). That would be a great improvement for me and some others i guess.

Talida