[Warrior] DPS Spreadsheet 2.3 and beyond - Page 61

Bersi · 04/02/08, 12:55 PM

Im wearing the Bracers of Eradication (5str/7sta) but after i got the Furious Shackles (5crit/5str) i saw my crit dropping, although it should stay the same (critrating 24 vs 19 + 5). I soon realized that the reason for the crit difference is the fact that i gain 12 agi when i equipp the Bracers of Eradication. Could someone confirm this behaviour?

orcsgotbooty · 04/02/08, 1:01 PM

Originally Posted by Bersi

Im wearing the Bracers of Eradication (5str/7sta) but after i got the Furious Shackles (5crit/5str) i saw my crit dropping, although it should stay the same (critrating 24 vs 19 + 5). I soon realized that the reason for the crit difference is the fact that i gain 12 agi when i equipp the Bracers of Eradication. Could someone confirm this behaviour?

You need your blue gem from Bracers of Eradication to activate your 12 agi 3% crit damage meta most likely.

Bersi · 04/02/08, 3:00 PM

Thx, thats it. I feel dumb now.

orcsgotbooty · 04/02/08, 3:03 PM

Originally Posted by Bersi

Thx, thats it. I feel dumb now.

Haha no reason to, I've made that same mistake a dozen times myself with other slots of gear in the past, its why I caught the mistake.

Xai · 04/02/08, 10:13 PM

Hi. Its my first time posting here, however I have been a reader of these forums for a while. I'm just curious how people who have used both or all the spreadsheets would rate the accuracy Landsoul versus the Grim or DrAllCOM3 sheets. Along this line of thought (and forgive my relative obliviousness here) but has rage generation with / without haste been modeled in combination with any of the other spreadsheets?

Just for reference, Im referring to the 2.4 Fury Dps sheet

Kaoz · 04/03/08, 12:17 PM

Why does the DW execute cooldown not consider haste gear or flurry?

Also, would it be possible to add a "heroism during execute" option or even "heroism recklessness execute". Both would be a very representative of actual in game situations.

Machinator · 04/03/08, 2:17 PM

It probably would be possible for him to add that, but people would have to very careful with fight length to get accurate results.

Apate · 04/03/08, 2:20 PM

Originally Posted by Kaoz

Why does the DW execute cooldown not consider haste gear or flurry?

Maybe I don't understand the question without the sheet opened - what do you mean by " the DW execute cooldown"? The 1.5s GCD isn't affected by melee haste.

Grim13 · 04/08/08, 12:55 PM

Originally Posted by Kaoz

Why does the DW execute cooldown not consider haste gear or flurry?

The short answer to this is it does. The long answer is, if you are looking at the involved cells, you will see that they reference average MH and OH speeds. These numbers already take haste, flurry, and anything else which modifies attack speed into account.

Originally Posted by Kaoz

Also, would it be possible to add a "heroism during execute" option or even "heroism recklessness execute". Both would be a very representative of actual in game situations.

before I split cycle and execute into separate sheets, this would have been problematic at best. As things currently stand, I could implement this rather easily. But I am loathe to do so. The reason being that the execute/cycle proportion is very rarely going to be a simple 80/20 time split, due to a multitude of factors, such as: ratio of warriors in the raid, are your other classes saving cooldowns for execute? Who has shamans and who doesn't? Blah blah blah. Add to this the fact that execute, even if just the warrior is involved is a damage split, not a time split, makes things more complicated. Until I work through at least approximate effects from these factors, I really don't wish to add a feature that could conceivably make the sheet less accurate.

Also, I wanted to apologize to everyone for not being around these passed two weeks. I had an outbreak of injuries, new and old, keep me from making it into the office. Hopefully I'll get some things done soon.

Also, I haven't played wow in about 6 weeks, so I may need to rely on you guys to keep be abreast (heh, I said breast) of developments in-game.

VirUzxZ · 04/08/08, 11:02 PM

not sure if this problem is just me or because of the version of excel i use but everytime i load up the newest version (321b) i get the following error msg

*edit* i just downloaded all the excel sheets from blavigne Profile, blavigne Details - FileFront.com from V310 to v321b and i get the same error for every workbook, now thinking that my version of office is corrupt i went ahead and did an uninstall & reinstall and i still get the same error any help would b greatly appreciated

"Microsoft Office Excel

Excel encountered an error and had to remove some formatting to avoid corrupting the workbook. Please re-check your formatting carefully."

and thus after clicking ok and enabling macros things get messed up dps numbers go down the drain into the region of #N/A and after countless clicking of the fix it button it still is teh broked so once again dunno if it's just me but yeah that's what i'm getting when i use the newest version.

just an FYI i am using Microsoft Office Excel 2007

**Update April 09/2008
Went ahead and changed my Macro Security settings to fully trust the workbook after Fogbug's suggestion but it doesn't help macros aren't the problem i'm getting the formatting error b4 macros are even disabled/enabled. I also went ahead and forwarded the dps spread sheet to a friend of mine that also has Office 2007 and he is also having the same issue, now i'm pretty sure not completely sure tho but sounds like 2003 users arn't having any problem with this so any help would be greatly appreciated.... *cry* i'm in withdrawal i need this to work!!!!

• Fogbug · 04/09/08, 2:34 PM

Change your security settings to make Office trust the spreadseet fully. I don't have access to Office from here and can't say exactly how this is done but that is almost definitely your problem

Grim13 · 04/09/08, 4:33 PM

This is a request for some assistance. Since I'm not playing right now, I was wondering if someone would be so kind as to compile a list of things that need to be added/tweaked/fixed. In particular, the new content from 2.4. Not knowing what I'm looking for would add a lot of time that I would prefer to use for other improvements/developements.

Thanks

rejdakon · 04/10/08, 4:32 AM

I have not yet spent too much time on playing around with the newest version, but I would like to note the following things:

1.) Concerning 2.4 changes: The Shard of Contempt is missing among the trinkets. I assume that i am not the only one really interested in seeing its theoretical effects.

2.) Akil'zon's Talonblade, dropping from Akil'zon in Zul'Aman is missing in the weapons list.

3.) The last version I used did not include dedicated execute weapons. When using this function in the new sheet I have stumbled across the following problem:

When leaving the values true/false at default value, the sheet works fine. However, when changing these values, the sheet for the respective equipment set completely screws up, yielding #XXX errors in most fields. This seems to be caused by my using a German language Excel version. Since the value for the "dedicated execute weapons"-field can only be "true" or "false" but in the German language version would have to be "wahr" or "falsch" (which are actually the default values but are changed to "true" or "false" with any change to this), any changes to this field make the sheet unusable.

Thairne · 04/10/08, 5:33 AM

Originally Posted by rejdakon

1.) Concerning 2.4 changes: The Shard of Contempt is missing among the trinkets. I assume that i am not the only one really interested in seeing its theoretical effects.

I´ve read somewhere else in this boards (me thinks it was the 2h PvE Endgame Thread) that the expertise is about equal to 85 AP. The Proc has 45s internal cooldown (also from the same thread i believe) with 20s duration, so roughly 30% uptime. Either my napkinmath is WAY off, or this trinket is hands down the very best, especially for arms, you can get.

Shha · 04/10/08, 5:56 AM

44 expertise is way more then 85 ap. In fact most spreadsheets show it at around 1.3 sep of str, so using this calculation its worth about 125ap. The proc is 45 sec cooldown after it procs with around 6 second proc time for me so 20/51 = 40% uptime aka 80-90 ap. Yea the trinket is ridiculously good, although DsT is still SLIGHTLY better for me. It does outperform everything else by huge margin though , with the exception of the one ugly trinket : Solarian Sapphire, that i do use on all sunwell fights QQ.