Dimpster

I'm pretty sure It depends on your spec, and current stat situation. If your looking for a good answer you should have a good question prepared. Some food for thought, it's something like 19 strength 11 crit 19 hit VS 350 armory pen.

 

Thorquiz

When geared in a couple of BT-items, Divine Retribution get better and better because of the with-itself-scaling of armor-pen. But if you are "poorly" geared (means: no other armor-pen on your gear respectively not decked out in t6-gear), than you may stick with Endless Rage.

But you're posting in a thread, where a warrior-dps-spreadsheet is developed and discussed. Why don't you just use it?

 

seasonlight

Well dimpster, thats why i have my armory on my thing. Easy to check ma gear.

 

Gruntle

seasonlight, why don't you do what Thorquiz told you to do and run the spreadsheet yourself? I doubt anyone want spend half an hour setting up the spreadsheet to check your gear and what would be best for you. If you can't run the spreadsheet why are you even posting in this thread?

 

Gruntle

Since there seems to be quite a few people who want to run the spreadsheet on OpenOffice I just thought I'd upload my version of the spreadsheet, that does work in OO. It's a basic version without any scripts and in principle just a copy of dr_AllCOM3s test spreadsheet posted quite a few pages back (i.e. the version before the beta). The ITEM sheet needs to be in the same directory as the DPS sheet. Whenever you change something in the sheet you should press F9 (to update all cells) a couple of times, the circular refs makes this needed.

Warrior DPS, OO version

Changes from 9.1.6
- Expertise bug sorted, should work fine now
- Rage generation computed for the entire fight => more accurate number of heroic strikes/cleave
- Added Defiance talent (2.3.2 version)
- Changed all Weapon skill to Expertise in the item sheet and updated the dps sheet accordingly.
- Scripts that start when you open the sheet disabled, you should be able to open the sheet with macros enabled.
- No script buttons will work, pressing them should do nothing. You can't load/save item sets or talent setups, and SEP cannot be calculated using the macro (you can do it manually however, see *)
- Some circular ref issues solved, if you run without circular refs and have flurry, the number of instants/sec (that's needed for Flurry calculations) is set to 0.2 (guesstimate).
- Corrected UBW talent, set to 15 ppm (as suggested by Rezarel on the previous page), fast and slow weapons now gain exactly the same amount of rage from UBW.

The circular references will probably mess things up when you run the spreadsheet at first. To solve this do the following:
a) Disable Mongoose on all weapons
b) go to the page Buffed DPS, change Use Circular refs to "FALSE" (cell B12). (-> You should now get a value for the total dps out)
c) change B12 back to "TRUE" (-> DPS will probably rise a bit, it should work now however)
d) Enable Mongoose if you want and press F9 a couple of times to make sure the sheet is updated.
You should only have to do this once when you start use the sheet, but sometimes the circular refs bugs out so you might have to do it again.

* SEP: (1) copying the total dps to the row "DPS before", E107-L107, (2) adding 10 to each of the abilities in the SEP row (3) manually copy the resulting dps after each +10 modification to the correct DPS after, don't forget to change back the 10 before doing next stat. Always press F9 (update) a couple of times between each copy-paste.

 

dr_AllCOM3

Can someone do me a favor?
http://rapidshare.com/files/77209961/test-language.xls.html
Does this say TRUE/FALSE in a non-german version? Excel uses true/false, OO wants 1/0. Kinda annoying.

 

Grim13

Upon opening:
A1 = TRUE (with a list box that has WAHR and FALSCH for choices. If I select one of the choices from the box, they're in German, and stay that way.)
B1 = TRUE (
C1 = y

If I use the list box in A1, the choices are in German. If I select one of them, B1 uses the German word. C1 then goes into a #VALUE error, as it does not recognize WAHR or FALSCH as being true/false input.

 

dr_AllCOM3

Thanks, I expected that .

 

Barmbul

My Guild is about to start BT Hyjal and right now I'm siting with 2/5 destroyer and S3 chest and helm. The spread sheet shows a marked dps increase when getting the 4p destroyer set bonus but I would most likely be replacing Gauntlets of Martial Perfection and the Season Three helm. Both of witch are better pieces than their Destroyer counterparts. Has anyone had experience with the 4 piece bonus did you see a marked difference? Just wanted to see if I could get some personal experience here.

Armory profile

 

Koshnek

For my warrior, the Hourglass is better than the Abacus, so i would assume that it is also better than Bladefist's breadth. Is the Abacus better than Bladefist's as well? Most of my slots are t5 or t4 epic quality (no actual tier pieces), and the ones that aren't epic are nearly epic. According to the spreadsheet, I'm at 1126.6 DPS raid buffed w/ 3326 AP, 39.7% to crit, and 15.3% to hit. (When I gem/enchant my gear correctly It'll be 1185.1 DPS).

I'm pretty nub with DPSing. I picked up a lot of epic DPS gear while raiding that no one else would take, so I figured I'd look into DPS a little bit. I listed out my stats in case it'd help because I read that the better your gear the more the value of items changes. Looking to finish epicing my DPS gear with what I can get without DKP, so I was wondering which trinket I should go for. I won't have badges for Brooch for a while because I still need two pieces of the badge tank gear, and I'm not paying the money for the card becuase I'll have DST eventually, lol, and the brooch is only marginally worse.

 

• promdates

I noticed, when trying to do some testing for our guild's DPS warrior, that you don't have an option for "Enhancing Totems" for Grace of Air and Strength of Earth, nor an option for Improved Blessing of Might.

Would it be possible to add those in, I wasn't able to find a way to do it myself

 

Koshnek

Deleted for being a nub and misreading the qusetion.

 

Koshnek

Are the gems bugged? If I plug in an 8 str and a 4 str/4 crit gem into an item and sometimes its the best combination. 8 str and 8 str is always second highest, and two 4 str/4 crit is third. I thought that two 8's or two 4/4 would be better than using one of each. Why does one of each come out with better DPS? (No socket bonus is involved).

I.E.:

Skullshatter Warboots: One 8 Str and one 4 Str/4 Crit always comes up as the best

Guantlets of Martial Perfection: One 8 Str and 4 Str/4 Crit is always the best.

But:

Red Belt of Battle: Two 8 Str is the best.

 

Gruntle

Which version of the sheet are you using Koshnek?

Could just be that the spreadsheet has not updated correctly after switching gems, try to manually update the sheet a couple of times when you have switched stuff around (F9 in OO, ? in Excel).

 

dr_AllCOM3

Warrior_DPS_1beta5.zip

- OO compatible
- No makros
- Up to date
- No items, just stats
- Easier to use. Many couldn't use it
- Not entirely finished, Beta, but it's correct. Total lack of a documentation

Bugs:
- Circular references in OO must be disabled at start or they bug
- DPS has to be calculated 3-4 times for a correct value (maybe related to circular references)

I also added this to the first post.

Edit: Seems like I could fix the bugs. Automatic circular references and they work . Same link.

 

Olon97

Edit: thanks by the way, looks good overall and pretty intuitive to use.

bug: chooses a devastate cycle for my DW set, but devastate talent is 0 for the selected fury talent set.

missing trinket: Abacus of Violent Odds (not a big deal, I'll get a better one soon).

another missing mechanic: Hyjal exalted DPS ring proc.

 

dr_AllCOM3

Devastate was using the WW damage . There will be more procs or trinkets I missed, thanks.

Edit, while we're at it:
Warrior DPS Spreadsheet 2.0

- Blabla, see first post

 

Valoroc

I just updated the spreadsheet and for some reason my DPS has jumped up a significant amount. The old spreadsheet I was using was one I got from here right before 2.3 was released. When I used that spreadsheet that required you to input the items and gems you use etc, I was sitting at about 1490 DPS. Now with the new spreadsheet I am sitting at 1956 DPS. I don't know why this is happening, b/c I have checked the talents/buffs/stats over and over and nothing seems incorrect.

Could someone check my armory and input my stuff into their spreadsheet and see what they are getting for DPS? And there is no way I can be reaching 1956DPS with my gear... cuz I am usually around 1200-1400. Do I just suck?

Here are my stats if you're too lazy to go to my armory:

STR- 564
AGI- 199
STAM- 589
AP- 2022
CRIT- 345 or 30.80% in zerker
HIT- 187
HASTE- 0
IGNORE ARMOR- 371
EXPERTISE- 0

Using [Wicked Edge of the Planes] and [Rod of the Sun King]

 

Gruntle

Great stuff, great work that you got it working in OO. Should be a lot easier to get going for most people.

Some bugs with DW fury:
- The calculation for haste for OH mongoose is pointing to the wrong cell, F25 instead of E25. I couldn't get any dps out until I changed this
- UBW is dependent on the weapon speed, should be changed to ppm (15 ppm according to tests By Rezarel, discussed a few pages back).
- The nice check for errors and circular refs is not working properly for me (maybe it was a translation problem), your version of it says:

[top]IF(OR("HASERROR"(N15);"HASERROR"(Q16));0,1)
(not sure what the function to check for errors is in english, I'm using the swedish language pack)
I changed this to

IF(E21>0;IF("HASERROR"(Q16);0;1);IF("HASERROR"(N15);0;1))
and it seems to be working.

 

Gruntle

You probably put in your full AP in the AP cell. It should only be the AP from gear in battle stance that goes into this cell. On the char screen this is found by checking the green number after the + sign in the tooltip for AP. All values should unbuffed, as far as I've understood things.

 

dr_AllCOM3

It should say =IF(OR(ISERROR(N15);ISERROR(Q16));0;1) in English. Strange, since Excel/OO translate such things at their own. HASERROR doesn't exist and "HASERROR" is treated like normal text. What OO do you use?

 

HeavyTwenty

Spreadsheet makes my armor penetration set seem a bit underpowered. Set 1 with 1211 armor penetration, 31.23% crit, 1942 attack-power was only 15 dps higher than Set 2 with 448 armor penetration, 35.40% crit, 1998 attack-power. (attack-power is lower than normal since I'm prot)

Do you guys rate that as accurate?

 

Gruntle

Oh you misunderstood me, it doesn't say "HASERROR" (hence the quotes) it says "ÄRFEL" (the swedish function), I just didn't know the english name of the function. Thanks for informing me

The problem with the cell is that it requires both the DW and 2h rage generation cells to be ok. This is rarely the case for me, the 2h calculations bugs out when you use a fast mh weapon (which I currently do). My version checks if you have an offhand weapon and then checks the rage generation cell for either 2h or DW.

 

Xerophyte

Only the first row on the talent tab allows protection talents to go above "1"

 

dr_AllCOM3

That's a much better explanation . I'm a 2h warrior and haven't tested DW yet. (Ärfel, lol^^)
Thanks.

Oh, I forgot.

Crit is good and Ignore Armor isn't overpowered.


Here:
Warrior DPS Spreadsheet 2.01