Elitist Jerks
Register
Blogs
Urban Rivals
Forums
New Posts


Go Back   Elitist Jerks > Public Discussion > Class Mechanics
Elitist Jerks Login

gamerDNA Login

Welcome to Elitist Jerks
We're testing some new features on the site regarding OpenID registration and coordination with gamerDNA. If you experience any issues with registering an account, please take the time to fill out a report and send it to this e-mail address. We would appreciate any assistance you could provide in making sure everything is functioning as intended. Thanks!

If this is your first visit, please be sure to check out the FAQ and the forum rules. Users must register to post and new registrations are subject to a one day "mute" period to get acquainted with the community.

Reply
 
LinkBack (881) Thread Tools
Old 11/19/07, 4:28 PM   #276
Apate
Debleated
 
Apate's Avatar
 
@ChickenArise
Night Elf Warlock
 
No WoW Account
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.
 
User is offline.
Reply With Quote
Old 11/19/07, 8:43 PM   #277
Rallik
Von Kaiser
 
Tauren Warrior
 
Ner'zhul
automatic gear comparison formula

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.
=(D3+IF(OR(Y3="Red",Y3="Yellow"),5,IF(Y3="Meta",43,IF(Y3="Blue",10,0)))+IF(OR(Z3="Red",Z3="Yellow"),5,IF(Z3="Blue",10,0))+IF(OR(AA3="Red",AA3="Yellow"),5,IF(AA3="Blue",10,0))+IF(NOT(OR(Y3="Blue",Z3="Blue",AA3="Blue")),AD3,0))/10+(E3+IF(NOT(OR(Y3="Blue",Z3="Blue",AA3="Blue")),AE3,0))/10*[Warrior_DPS.xls]Gear!$V$4+(G3+IF(NOT(OR(Y3="Blue",Z3="Blue",AA3="Blue")),AG3,0))/20*[Warrior_DPS.xls]Gear!$V$7+(H3+IF(OR(Y3="Red",Y3="Yellow"),5,0)+IF(OR(Z3="Red",Z3="Yellow"),5,0)+IF(OR(AA3="Red",AA3="Yellow"),5,0)+IF(NOT(OR(Y3="Blue",Z3="Blue",AA3="Blue")),AH3,0))/10*[Warrior_DPS.xls]Gear!$V$8+(I3+IF(NOT(OR(Y3="Blue",Z3="Blue",AA3="Blue")),AI3,0))/10*[Warrior_DPS.xls]Gear!$V$9+J3/10*[Warrior_DPS.xls]Gear!$V$5+K3/100*[Warrior_DPS.xls]Gear!$V$6
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.

Last edited by Rallik : 11/19/07 at 8:51 PM.
 
User is offline.
Reply With Quote
Old 11/19/07, 10:24 PM   #278
dr_AllCOM3
Great Tiger
 
dr_AllCOM3's Avatar
 
Orc Death Knight
 
Blutkessel (EU)
I need something to parse wowhead/armory. I have a tool for alakhazam, but some stats are simply missing on that page (like Haste).
 
User is offline.
Reply With Quote
Old 11/20/07, 1:59 AM   #279
Davia
Piston Honda
 
Human Death Knight
 
Turalyon
Originally Posted by Apate View Post
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.
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.
 
User is offline.
Reply With Quote
Old 11/20/07, 7:16 AM   #280
nova
Glass Joe
 
Night Elf Warrior
 
Der Abyssische Rat (EU)
Originally Posted by dr_AllCOM3 View Post
I need something to parse wowhead/armory. I have a tool for alakhazam, but some stats are simply missing on that page (like Haste).
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?
 
User is offline.
Reply With Quote
Old 11/21/07, 8:30 AM   #281
kyote
Glass Joe
 
Orc Warrior
 
Der Rat von Dalaran (EU)
Originally Posted by Ego View Post
On the spreadsheet, expertise is calculated individually for the main hand and off hand weapons. In game, there is only one 'expertise' stat.

I'm fairly certain that an orc using an axe in the offhand and another weapon type in the main hand will grant the racial bonus for both hands.
Would anyone try to answer the question if this is true or false, please?
 
User is offline.
Reply With Quote
Old 11/21/07, 9:14 AM   #282
amethyst
Von Kaiser
 
Night Elf Warrior
 
Earthen Ring (EU)
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.
 
User is offline.
Reply With Quote
Old 11/21/07, 10:50 AM   #283
Sapphidia
Von Kaiser
 
Human Warrior
 
Earthen Ring (EU)
Originally Posted by kyote View Post
Would anyone try to answer the question if this is true or false, please?
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.
 
User is offline.
Reply With Quote
Old 11/21/07, 4:36 PM   #284
dr_AllCOM3
Great Tiger
 
dr_AllCOM3's Avatar
 
Orc Death Knight
 
Blutkessel (EU)
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.
 
User is offline.
Reply With Quote
Old 11/21/07, 5:22 PM   #285
Gruntle
King Hippo
 
Tauren Warrior
 
Earthen Ring (EU)
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.
 
User is offline.
Reply With Quote
Old 11/21/07, 6:15 PM   #286
Emeraude
Bald Bull
 
Emeraude's Avatar
 
Night Elf Warrior
 
Sargeras
Originally Posted by dr_AllCOM3 View Post
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.
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?
 
User is online.
Reply With Quote
Old 11/21/07, 7:33 PM   #287
dr_AllCOM3
Great Tiger
 
dr_AllCOM3's Avatar
 
Orc Death Knight
 
Blutkessel (EU)
Originally Posted by Gruntle View Post
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.
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.

Last edited by dr_AllCOM3 : 11/21/07 at 9:53 PM.
 
User is offline.
Reply With Quote
Old 11/22/07, 2:37 AM   #288
Panics
Glass Joe
 
Tauren Warrior
 
Frostmourne
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.
 
User is offline.
Reply With Quote
Old 11/22/07, 5:11 AM   #289
Gruntle
King Hippo
 
Tauren Warrior
 
Earthen Ring (EU)
Originally Posted by dr_AllCOM3 View Post
I wouldn't want to use it without the makros .
Switching stuff around shouldn't be the problem, I already have some ideas.

If I keep makros to a minimum, there might be a chance for OO.
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 ).
 
User is offline.
Reply With Quote
Old 11/22/07, 5:34 AM   #290
Gruntle
King Hippo
 
Tauren Warrior
 
Earthen Ring (EU)
Originally Posted by Panics View Post
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.

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.

Last edited by Gruntle : 11/22/07 at 5:43 AM.
 
User is offline.
Reply With Quote
Old 11/22/07, 8:50 AM   #291
Kurtov
Glass Joe
 
Orc Warrior
 
Durotan
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.
 
User is offline.
Reply With Quote
Old 11/22/07, 10:18 AM   #292
dr_AllCOM3
Great Tiger
 
dr_AllCOM3's Avatar
 
Orc Death Knight
 
Blutkessel (EU)
Originally Posted by Gruntle View Post
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. .
I have version 0.1.0.7 here and OO doesn't like it. Remember which version you tried?
 
User is offline.
Reply With Quote
Old 11/22/07, 12:22 PM   #293
Brissa
Not enough rage
 
Brissa's Avatar
 
Gnome Warrior
 
Argent Dawn (EU)
Originally Posted by Gruntle View Post
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.
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.
 
User is offline.
Reply With Quote
Old 11/22/07, 2:27 PM   #294
zecatone
Glass Joe
 
Human Warrior
 
Grim Batol (EU)
Spreadsheet

I Cant click on buttons like "load set", "delete" etc. Using MS OFFICE Enterprise, anyone know how to fix this?
 
User is offline.
Reply With Quote
Old 11/22/07, 3:07 PM   #295
Korlong
Von Kaiser
 
Troll Warrior
 
<BAD>
Demon Soul
Originally Posted by Brissa View Post
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.
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.
 
User is offline.
Reply With Quote
Old 11/22/07, 3:49 PM   #296
Salted
Von Kaiser
 
Dwarf Warrior
 
Dunemaul
[Warrior] AP the #1 stat?

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?
 
User is offline.
Reply With Quote
Old 11/22/07, 5:00 PM   #297
Emeraude
Bald Bull
 
Emeraude's Avatar
 
Night Elf Warrior
 
Sargeras
1) This really doesn't deserve it's own thread.

2) Those numbers are pretty low. :<
 
User is online.
Reply With Quote
Old 11/22/07, 7:08 PM   #298
ParrishLB
Glass Joe
 
Tauren Warrior
 
Lightning's Blade
Originally Posted by Emeraude View Post
1) This really doesn't deserve it's own thread.

2) Those numbers are pretty low. :<
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.
 
User is offline.
Reply With Quote
Old 11/22/07, 7:35 PM   #299
Emeraude
Bald Bull
 
Emeraude's Avatar
 
Night Elf Warrior
 
Sargeras
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.

Last edited by Emeraude : 11/22/07 at 7:42 PM.
 
User is online.
Reply With Quote
Old 11/22/07, 7:41 PM   #300
ParrishLB
Glass Joe
 
Tauren Warrior
 
Lightning's Blade
Originally Posted by Emeraude View Post
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.
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.
 
User is offline.
Reply With Quote
Reply

Go Back   Elitist Jerks > Public Discussion > Class Mechanics

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
DPS Warrior Spreadsheet Deathwing Class Mechanics 1901 11/06/07 5:32 PM
Possible to Fully Run Warrior Dps Spreadsheet Without Full Excel? DarthB Public Discussion 11 11/22/06 7:27 PM
Warrior Trinket Comparison (Earthstrike worth it for DW fury warrior?) Kasi Public Discussion 13 08/22/06 10:11 AM
Fury warrior / MS warrior vs. Rogues for raids? Petehmb Public Discussion 14 08/02/06 8:01 PM