Apate

Has anyone seen an offhand WW hit proc anything? I haven't tested it myself, but I recall reading one of the warrior threads here and seeing some concern about it.

See you, auntie.

 

Rallik

Since it was a little tiring to have to manually replace a piece of gear in every slot in order to determine whether or not it would be an upgrade, I added a quick formula to automatically total up stats on gear in the item spreadsheet and multiply it by current SEP values to give a piece an overall SEP rating. Gem slots are included as: all red and yellow gems being considered 5str/5crit, all blue gems being considered 10str, and the gem bonus being added so long as there are no blue gem slots. Those were chosen since strength and crit tended to be very close in value, with strength typically being slightly better. Meta gems were given an arbitrarily high strength equivalent value since I didn't want to go through the calculations to find their exact contribution, and it's fairly clear that any helm without a meta gem slot is significantly worse than one with.

Below is the formula for the first item, in row 3. I stuck it in the N column, but it shouldn't matter which if you copy it in. Simply copy and paste it from that row to any other, or doing the drag fill, and it will fill the correct cell locations in properly.
Edit:
I forgot to include that I'd edited the SEP value to show strength as 1, with the others in relation to it, instead of how it initially comes with the total DPS increase being shown. The above formula may give you odd results if that change isn't included too, and it find it easier to read this way anyways.
Replace the contents of E109 with: 1
F109 with: =(F108-F107)/E110
G109 with: =(G108-G107)/E110
H109 with: =(H108-H107)/E110

etc. for the other columns, up to and including column L.

 

dr_AllCOM3

I need something to parse wowhead/armory. I have a tool for alakhazam, but some stats are simply missing on that page (like Haste).

 

Davia

On PTR I procced mongoose off my OH on a WW, I bought a white 1h sword to MH and just stood there whirlwinding with autoattack off once i had the rage and Mongoose went up.

 

nova

Parsing wowhead is pretty straight forward, as they provide a really small xml view of your item if you add "&xml" to the items url.

http://www.wowhead.com/?item=32236&xml

I recently included item tooltips for our DKP, so I know how the data looks like, but I didn't have to write a parser as I could simply output the xml as a table with no editing at all.
Maybe you can find a nice xml parser written in Java or something?

 

kyote

Would anyone try to answer the question if this is true or false, please?

 

amethyst

Same as it only shows one crit % etc as well when dual wielding.

The character details screen is far from perfect, but the last time I remember seeing a Blizz blue post, it said that +crit, +hit, +weapon skill etc was worked out separately for each weapon. I would assume that expertise has been coded to follow the same.

 

Sapphidia

Certainly the character sheet seems to say this. Most interestingly (and I hope this hasnt been mentioned already), there's a weird issue with Human expertise ratings.

If a human warrior uses a Mace in one hand and a sword in the other, they get +10 expertise on the character sheet. It seems each of the expertise racials are done as "if this weapon type is equipped, toggle the racial on" rather than separate for each weapon. Mace spec AND Sword spec are two separate racial abilities and are both getting separate checks. Or at least, this is what the -character- sheet says.

I'll do some testing later to see if it actually does add a full +10 expertise to both hands if you dual wield one of each weapon. Shouldnt be too hard to test if I can find a duelling partner who can fine tune their dodge values.

 

dr_AllCOM3

I'm thinking about getting rid of all the item implementation and just making it stat-based. Comparing like 5-10 "sets" at a time with whatever values you enter. Options for specials like certain trinkets, sets, metagems and so on.
That would make everything a lot easier for me.

- less comfortable
- you have to look up the items for yourself
+ calculation stays the same
+ a LOT easier to use
+ maybe Open Office compatible


Oh, and stop writing silly PM's.

 

Gruntle

Well, that would certainly work as well, the important thing is the theorycrafting imo (and SEP values, that can give you a fair representation of the value of a certain item). I do think that it's quite nice to have a look at the item lists to try and plan ahead on what I want to get and so on, but if it's too much of a hassle to make it work I agree that you should focus on the dps calculations. Maybe put the gear page in the item sheet instead (you could even have 3 setups at the same time perhaps?), and calculate the total sum of gear there, that can then be input to the dps sheet (where you could also put in some other stat combinations to compare with).

The spreadsheet is OpenOffice compatible, the only things that doesn't work are the scripts. You can use it anyway, it's just a bit more work to get the SEP values and to switch gear around.

 

Emeraude

That would be awesome. I have no problems looking up my own gear and entering in stats.

There would still need to be a list of set bonuses and such like that right?

 

dr_AllCOM3

I wouldn't want to use it without the makros .
Switching stuff around shouldn't be the problem, I already have some ideas.

(Edit) Preview:


If I keep makros to a minimum, there might be a chance for OO.

 

Panics

I'm interested in looking at how to maximise my dps in execute range. I've had a brief look around the spreadsheet and couldn't find a way to model this. Underneath the dps cycle on the gear tab, is a cell with "execute below 20%". I tried to muck around with this but I've really got no idea how excel works.

To reiterate I basically want to model my dps with various weapons and enchants once I get into execute range. I imagine it would be easier to model than a typical dps cycle.

Any theorycrafting would be most welcome.

 

Gruntle

It's looking really nice . Actually, the SEP macro worked in the earlier version of the sheet (the Elic/Deathwing version), not sure what changed in your version of it. I tried to fix it, but just couldn't get it to work.

Would be good if you could keep most of the basic stuff working without macros (SEP would be really nice, but I'm guessing it might be tricky to make that without a macro, could be possible with some clever use of cells that update perhaps?). Fancy stuff like saving setups and such things could very well be macro'd (I don't use that much anyway ).

 

Gruntle

Well it is modeled in the sheet. The thing you need is the total rage income per second and transform that into execute damage over a known time. The dps from execute (for DW) can be found in cell Q25 on the Buffed dps page (in the test version at least), computed from the rage income. You could just watch this cell for what happens when you put in some different gear and talents. The total damage from execute will ofc also need information on how long this phase lasts for as well as the possible damage increase from popping Recklessness (not sure that is modeled actually).

edit: just realised that you won't be able to test the effects of fast-slow weapons on execute damage using the spreadsheet. The rage income is given as rage/sec, and the total rage available for each execute as rage/sec * gcd. This will not be a fair representation of the the true rage available for each execute for slow weapons, which might actually not hit at all for some gcd's (particularly with matched speeds) causing you to lose some executes. Some more elaborate modeling needs to be done to look at this.

 

Kurtov

Defiance (Protection) weapon expertise will now work in all stances. This was a bug that has been fixed.

Source

I suppose if you're letting us put raw stats in, it will still be easy enough to implement w/out any prot talents in the sheet.

 

dr_AllCOM3

I have version 0.1.0.7 here and OO doesn't like it. Remember which version you tried?

 

Brissa

I think the only way to do that is to have some sort of simulator such as the one the shamans used for their windfury mechanics.
The problem is that implementing a functional simulator is pretty hard work.

 

zecatone

I Cant click on buttons like "load set", "delete" etc. Using MS OFFICE Enterprise, anyone know how to fix this?

 

Korlong

It wouldn't be too hard to write an event-driven simulator for warrior DPS except that implementing all of the different proc behaviors would be an insane undertaking. You could probably average the proc value over time to simplify things, but that defeats the purpose of writing a simulator in the first place.

A windfury simulator for shamans is probably substantially easier, as you don't have to worry about procs or the damage to rage feedback loop.

 

Salted

I've never felt AP was the ultimate DPS factor that a lot of people claim it is so I decided to try dual-wield sword spec with bloodthirst, I believe it was 26/35/0. Even losing a lot of AP my dps is relatively similar, and I can only see it scaling higher with more haste(I only had swiftsteel shoulders and DST, no mongoose) and AP's damage mechanic being left behind.

Here is the WWS for SSC with that sword spec on 11/13:

Wow Web Stats

Hydross-Tidewalker Boss dmg average: 919dps

This is WWS for SSC up to Tidewalker standard 17/44/0 on 11/20:

Wow Web Stats

Hydross-Tidewalker Boss dmg average: 903


I would say my average raid-buff AP as 17/44 is ~3000 with rampage up.

Gear changes going sword spec:
Solarian trinket > hourglass
Wicked Edge w/mongoose > Talon w/potency
Season 2 OH mace w/ potency > Season 2 OH sword (unenchanted)

Like this I lost about 630 constant AP, you'd think my overall damage would be less? Apparently it was slightly higher - equal for argument's sake.

I suppose what I'm getting at is how other factors such as haste and crit are just as viable to strive for as AP for warriors, even with a bloodthirst build. Hell, if you want to get extreme, at 2300AP there is only 100dmg difference between MS and Bloodthirst with Talon of Ashara, so the less you depend on AP the less you'll need bloodthirst.


Has anyone else had similar experiences, or am I just insane and with too much time on my hands?

 

Emeraude

1) This really doesn't deserve it's own thread.

2) Those numbers are pretty low. :<

 

ParrishLB

He's gotta start somewhere you know? I mean flex all you want, but it's a valid question.

As for an answer to the OP question,

I'd say that when I was getting SSC and TK gear, I was curious as which combos are best. You can Armory many great geared fury warriors and pre 2.3 see many combos. Some would have a AP build with Potency on both weapons, some would go Mongoose MH/ Potency OH, some would go Double Mongoose.

From my perspective a lot of it deals with how static your party is. Are you the primary warrior in the melee DPS group with a Feral Druid, Enh Shaman, BM Hunter, LW Rogue? Or are you in a split group?

In my case, I was always grouped with Feral Druid and LW Rogue. I probably had the Shaman 50% of the time and the BM Hunter the other 50% and even on rare occasions both. Because of this I go with a more AP build on my gear and Double Mongoose on my weapons. Because of having LotP every raid I can afford to lose a little crit where others can't. Raid buffed I'm probably right at 35% and when single and double Mongoose procs it pushes me over 37 and 39 respectively.

If you're not getting LotP you will have to sacrifice stats a little more for more crit as you may find yourself not having flurry up enough.

This may not be the answer you're exactly looking for, but I think it's better than #2's post.

 

Emeraude

There are 2 threads where the question could have been asked:

http://elitistjerks.com/f31/t12386-w...e_dps_warrior/
[Warrior] DPS Spreadsheet 2.3 and beyond

In addition if you look up his armory, his DPS should be much much higher then it is. 800-900 DPS with his weapons, trinkets, and overall gear, is very low, he should be well over 1000.

It wasn't about flexing anything, it's an attempt to bring light to a gimp build, with gimp numbers, and doesn't really deserve it's own thread, unless it shows an overall drastic boast/change in DPS, which it doesn't, I've seen this asked on the public Warrior boards, "Should I go Fury with weapon specs", the answer is no. The AP outweighs it.

Not trying to be a bitch, just saying how it is.

 

ParrishLB

Then perhaps this post should've been your first one? I'm not trying to disrespect you, was just trying to help the guy out. I know his numbers are low, but that could also depend if he's getting LotP, WF, Drums, and flasking every attempt.