xellos

Landsoul's 2.4 Fury warrior spreadsheet should cover your needs. Go with slow anyways.

 

Lord Pendragon

Is version 331 the latest? Just downloaded it, and it still doesn't have the Vanir's Left Fist available as an off-hand.

Edit to add: Just realized this and landsoul's are two different spreadsheets. Are the two different in their uses/results? Or is it merely a matter of flavor?

 

Plonker

I've only recently discovered this spreadsheet (as I'm just getting back into the game), although the last few versions all have the same issue for me. The issue is that the mainhand weapons under "Execute" all have "1108" in their stats, and also the offhand weapons in the "Execute" section doesn't update when you change it, it only shows stats from the offhand in the top section (ie. the non-execute section).

Have I not got an excel addin enabled or something that is causing this?.. happened on my PC at home, and PC at work. Thanks for the top work on the sheet by the way.

 

Gellor

Has anyone looked at the WotLK talents that have been leaked at WotLK Information Wiki: WotLK Alpha Official Wiki ?

Could be false but there are lots of pics which appear to be legit. Bloodsurge with titans grip appears to be an insanely overpowered combination.

Warrior spells/talents:

Titan's Grip - Allows you to equip two-handed axes, maces and swords in one hand, but you attack 28/26/24/22/20% slower then normal (fury)
Strength of Arms - Increases your Strength and total health by 1/2/3/4/5%. (arms)
Shockwave - "Sends a wave of force in front of the warrior, causing ${$m3/100*$AP} damage (based on attack power) and stunning all enemy targets within 10 yards in a frontal cone for 4 sec. This ability causes a high amount of threat." [20 rage, 45 sec cooldown] (prot)
Sword and Board - When your Devastate and Shield Slam abilities deal damage they have a 2/4/6/8/10% chance of refreshing the cooldown of your Shield Slam ability and reducing its cost by 100% for 5 sec. (prot)
Safeguard - ,"Reduces damage taken by the target of your Intervene ability by 20/40/60% for 6 sec. In addition, your Charge, Intercept and Intervene abilities have a 33%/66%/100% chance to remove all movement impairing effects when used." (prot)
Trauma - "Your normal melee critical strikes increase the effectiveness of Bleed effects on the target by 15/30% for 15 sec."
_Bladestorm - Instantly Whirlwind all nearby targets and for the next 4.5 sec you will perform a whirlwind attack every 1.5 seconds. While under the effects of Bladestorm, you can move but cannot perform any other attacks or abilities but you do not feel pity or remorse or fear and you cannot be stopped unless killed. [25 rage, cooldown: 90 sec] (arms)
Stalwart Protector - You gain 1/2 rage every time you parry or dodge an attack.
Furious Resolve - Reduces threat caused by attacks in Battle and Berserker Stance by 4/7/10% and increases your total Stamina by 1/3/5%. (fury)
Bull Rush - Increases the duration of the Stun effect of your Charge and Intercept abilities by .4/.7/1 seconds. (arms)
Unrelenting Assault - Reduces the cooldown of your Overpower and Revenge abilities by 1/2/3 seconds. (arms)
Bloodsurge - Your Bloodthirst critical hits have a 33/66/100% chance of reducing the swing time of your next Slam by 100% for 5 sec. (fury)
Critical Block - Your successful blocks have a 10/20/30% chance to block double the normal amount. (prot)
Shield Break (Level 75, 15 rage, 1m cooldown) - Break down the enemy's defenses, disarming any shield they have equipped or reducing the chance the enemy will block by 3% for 10 sec.


Talent Tree - War Tools :: Talent tree Warrior WOTLK Talents.

 

• Sajukar

While bloodsurge may seem incredible, it won't be that strong if Slam still resets the swingtimer.

 

achaeon

I may be doing something completely wrong, but no matter what gear I change out in the gear1 tab, the DPS always says 1248.8, which was the default. What am I doing wrong? I've tried using F9 to update, with no success.

 

endurance90

I have a question about breatplate of ire....is it worth it? how well does it compare to netherforce chestpiece drops from last boss in H mgt.

 

xellos

Should be using the spreadsheets for this. Anyways, [Breastplate of Ire] has too many points invested in stamina. [Netherforce Chestplate] has more sockets and is better balanced stats wise.

 

endurance90

Sorry could u link me to spreadsheets, also was wondering if dragonstrike procs stacked with DW

 

Tallanor

The shattered sun necklace? It's called the [Shattered Sun Pendant of Might] with a chance to proc either 200 attack power for 10 seconds if Aldor, or 333 to 367 arcane direct damage strike if you are Scryer.

It looks like other people's testing confirm the results I've seen of the proc happening every 50 seconds or so for an average uptime of 20% (for the Aldor version anyway).

I'm still debating that necklace vrs the [Choker of Serrated Blades]. I guess I could just model the SSO necklace as 18 agility and 104 attack power to compare dps.

 

Werelds

It's been said before, but no. If you get two of them, they only refresh each other - this does mean though, that your haste uptime gets nearly doubled. I fiddled around with the spreadsheets a bit, but it's not really worth it.

 

Grim13

WarriorDPS v340 23MAY2008

Looks like the new rep necks compare well with the Choker of Serrated Blades and Pendant of the Perilous. A quick look showed them all within one DPS of one another on a mid-grade DW/Fury loadout.

v340 23MAY2008
If Imp. Slam is not specced, 2-hand builds will no longer use slam - this is to facilitate greater accuracy for dedicated PvP builds
Added model for Shattered Sun necks, Aldor and Scryer, based upon 1PPM/45s iCD base mechanic; need to find out for certain if Scryer version is 45s iCD….assuming it is for now
Corrected issue with execute weapons referencing primary weapon data
Added DPS breakdowns to Gear sheets showing DPS and DPS % for each attack type
Corrected "Axe" detection to include polearms for purposes of "poleaxe" spec, but not for racial expertise
Added Vanir's Left Fist
Added conditionals for BT, MS and Dev in the various cycles, resulting in significantly more accurate rage usage for off-spec cycles
Added Dragonstrike to offhand list, but have NOT modeled it's proc for off-hand

 

Opta

Good updates
There is a bug with latest version where it doesnt update due to circular reference on dps set 6.
Edit user error. it works fine.

It would be nice to have an offhand DS model.
Thanks

 

Kaoz

Warglaives seem to two issues in this spreadsheet. When i select warglaive in MH and I click the SEP button the values for ARpen are completely off and probably the others too. Also the check for warglaive set has a one row offset in the cell value that breaks it.

 

Grim13

WarriorDPS_v341 30MAY2008



v341 30MAY2008

• Added deep wounds model; Deep wounds can be toggeled in the Debuffs section of the "Buffs" sheet
• Added gem slot detection; If the gem slot type is "None", no stats will be counted from any gem placed in that slot
• Added missing haste to Vanir's Right Fist
• Went through and cleaned up the item lists
• Updated MH and added OH model for Dragonstrike; 1ppm, 10s
• Corrected bug causing Warglaive set bonus to not be applied
• Under certain situations, Haste (and maybe other stats) is not recalculating like it should. Make liberal use of F9 (manual recalc) until I manage to fix this issue.
• Due to haste bug, above, when doing SEP,highlight the tabs for all six Gearx sheers (use SHIFT-click) then hit the "SEP" button. For some reason the bug doesn't strike when calculating multiple sheets at once
• Changed SEP calculation back to 10 statmods, rather than 1, so values will seem lessened when near a cap, such as hit

 

Bulvine

Just download 3.41 and when I use a dual wield setup in gear set 3 i get errors. Gear sets 1, 2, and 4 give me no issues.

 

Grim13

Found it, and a few more little bugs to correct as well. I am also re-writing much of the UI and DPS engine. The UI changes are primarily in the way data is presented to the user. It will be much cleaner and intuitive. On the back-side, I am re-working the way cycle and execute sheets interact and form output. The new changes will compartmentalize things more effectively, and look to be more accurate as well. The re-write is also serving to identify various small bugs and inaccuracies that otherwise go unnoticed. I hope to have this update ready as a "late beta" quality release by Friday of this week, and after user input, have a true final release by the end of the month.

 

Mardraum

Thanks Grim, i really appreciate all the hard work on the spreadsheet.

Question tho, do you account for going "over" the arp cap? I think the version i have now arp will scale indefinitely, when in reality, once the mob hits 0 armor, anything going over the cap is 0 dps increase.

 

Kaan

Thanks for the hard work. Also, it would be nice if you would include various Raidbuffs/Debuffs: Demonslaying Elixir, Drums of Battle (users 1/2/3/4/5), Exp. Weakness (with Agility for the hunter), Improved Seal of the Crusader (Retribution) and Imp. Sanctity Aura. Also one more thing: Armor of 7700 bosses is actually 7685 armor.

 

Snukums

found incorrect information on 3.41

[Cloak of Darkness] and [Vengeance Wrap] have their bonuses inverted. Cloak should be +2 Crit and Wrap +2 Hit and in Warrior_ITEMS they're inversed.

Socket colors are correct though

 

Grim13

This is already covered. Once 0 AC is achieved you will no longer get any additional DPS from ArP. One thing to consider though, is how the spreadsheet calculates procs. Their effect is averaged out over time, meaning this while your average ArP may not be over the cap, it is possible, that if all of your ArP procs triggered at the same time, that you could go over the cap. The spreadsheet can't really account for that circumstance. It calculates average results over a period of time. It is not a simulator. However, the version 4.0.0 that I am working on will include both "hard" and "soft" caps for crit, hit, ArPn, haste, expertise and resillience. It will tell you how much more of the applicable rating to get to the cap, or how far over the cap you currently are.

 

• Jokal

When!?

 

Mardraum

Nice! Can't wait.

 

Grim13

I was going to release beta 1 today, but I had a problem with Warrior_Sim.xls last night which proved to be unrecoverable. Since I hadn't been doing daily back-ups or anything like that, the last version I have to revert to is the last release version, v341. I had re-written some key code, such as haste, as well as adding a complete "cap warning" system for crit, hit, haste, ArPn, expertise and resilience. On the bright side, all the work I've done to Warrior_DPS.xls and Warrior_Items.xls was preserved. I'll try and get things up and working by this afternoon and get something out the door, we'll see...

As to what v4.0.0 is...and what it is not... It is not a new sheet. It is more evolution, rather than revolution. The revolution is coming later, once I get version 4 bug free and feature complete. But it's too early to reveal my plans for later; someone might steal my idea. v4.0.0 will have a re-designed front-end, though it will remain functionally the same. It will present more data in an easy to read and understand format. If fact, I think it presents more data than v3xx, while looking better and being easier to understand. On the back-end, I've added more "idiot-proofing" to protect against stray gems or enchants from throwing off calculations and similar such features. I'm also in the process of re-writing much of the base code to improve accuracy and modularize computations, to make things easier to add or change later on, as well as making bug-hunting easier. Overall, I have to say that I am please with what I have so far. It looks a lot better, while having improved functionality and accessibility.

 

Bulvine

I suggested this for the other sheet and since I use both I figured i'd suggest it for your sheet too. On the Buffs tab can you put a G or R next to the buffs to designate whether they are group or raid buffs. So Windfury and Leader of the Pack would have G's designating group buff. Hunters Mark and Blood Frenzy would have R's since they are raid buffs. This would just be nice for easy reference when selecting your buffs.