• landsoul

The following spreadsheet is the product of the need for a user friendly and accurate DPS calculation and gear selection tool and about two years of use/comments from players just like you. Please download the sheet and try it yourself and pass along your suggestions and also if you find any bugs, please send me a PM! You may also talk about cool findings while using the spreadsheet in this thread. The main goal of this project is to offer the most accurate and reliable tool on the internet, period.

Please be sure to read the directions on the intro page in full and familiarize yourself and play with the program before you post in this thread, or send me PM's with questions. The spreadsheet is only compatible with and designed in Microsoft Excel and 2007 SP2. Please do not try to use them with Google Docs, Open Office, Excel '97 or any other spreadsheet program for they will not work. Please don't use the spreadsheet to determine if fury is better than arms or not. It's just a metric to determine what gear to acquire to get the most efficient output. You should try both specs if you want to see which is better for what fight. Thank you for all your support!

Current Version:
2.503 October 23 2009 WoW 3.2.2a

Excel 2007 Compatible
Download WarriorDPS2.503Excel07.xlsm

Excel 1997/2003 Compatible
Unfortunately due to cell operation limits of 1997/2003, I have taken down support for these. If I find opportunity to allow some of the complicated cell calculations to be broken down so that the older excel can use them, I will, but that may take some time.

Changes in 2.503:
Fixed [Vengeance of the Forsaken] not having its Horde lookup in the proc values table.
[Hoperender] is spelled correctly on the Lookup Page.
Fixed an issue with the the green highlight for an equipped item extending sometimes to another slot table.
Fixed Improved Whirlwind and Unending Fury to stack additively.
Fixed an issue in ARMS where adding incoming DPS gave way too much additional heroic strike frequency. It now scales more appropriately and is now capped at 80%. HSF without any incoming damage is still capped at 50%.

Changes in 2.502:
-Increased the amount of armor penetration required for 1% from ~12.316 to ~13.996.
-5/5 Sword spec now grants a 10% on-hit chance for an extra attack, 6 second ICD.
-Changed stats of certain items reflecting the patch.
-Fixed some Horde/Alliance item name differences.
-Added all known Onyxia items.
-Fixed an issue with item comparisons when using a stat increment for SEP other than 1.
-Fixed an issue causing Siegebreaker Battlegear's (2pT8) haste proc not being added into DPS.

Best in Slot Hardmode set, Alliance item names
Arms may do more single target damage due to being able to passive cap ArP at the cost of expertise.

Slot	Fury	Arms
Head	[Wrynn's Helmet of Triumph]	[Wrynn's Helmet of Triumph]
Neck	[Charge of the Demon Lord]	[Collar of Ceaseless Torment]
Shoulder	[Wrynn's Shoulderplates of Triumph]	[Wrynn's Shoulderplates of Triumph]
Back	Vereesa's Dexterity (Heroic)	Vereesa's Dexterity (Heroic)
Chest	[Wrynn's Battleplate of Triumph]	[Wrynn's Battleplate of Triumph]
Wrist	1.,2.[Boneshatter Armplates]/3.[Bracers of Dark Determination]	[Bracers of the Untold Massacre]
Hands	[Gloves of Bitter Reprisal]	[Wrynn's Gauntlets of Triumph]
Waist	1.[Belt of Deathly Dominion]/2.,3.[Bloodbath Belt]	[Belt of Deathly Dominion]
Legs	[Wrynn's Legplates of Triumph]	[Legguards of the Lurking Threat]
Feet	1.,3.[Greaves of the 7th Legion]/2.[Icewalker Treads],[Sabatons of Ruthless Judgment]	[Greaves of the 7th Legion]
Ring1	[Band of the Violent Temperment]	[Carnivorous Band]
Ring2	[Ring of Callous Aggression]	A.[Brann's Signet Ring]/H.[Planestalker Band]
Trinket1	[Death's Verdict]	[Death's Verdict]
Trinket2	[Death's Verdict]/[Mjolnir Runestone]	[Death's Verdict]
Weapon	[Justicebringer] x2	[Justicebringer]
Ranged	[Talonstrike]	[Rhok'shalla, the Shadow's Bane]/[Twirling Blades]

If you wish to make a donation you may do so via Paypal, to technodragon@hotmail.com

Guidelines for submitting bugs or errors:
Page: FURY, ARMS, LOOKUP, WORKBOOK
Error Type: FORMAT, REFERENCE, CALCULATION, TYPO, CONCEPT, FORMULA
Include a brief description of the error
If you find the solution, please post it

Page: Arms
Type: Reference
Unbridled Wrath, Bloodrage, and Anger Management are not affecting heroic strike frequency.

Page: Arms, Fury
Type: Reference
[Blood of the Old God]'s AP proc not counted right in cosmetic displays due to a typo

Page: Arms, Fury
Type: Reference
-Crit damage Meta gem's SEP value is wrong with increments other than 1. To fix, go to the SEP calculator on both the Arms and Fury pages (it's on the left more towards the middle) and select cell G100. Instead of =(F100-$F$91)/$F$90 it should read =(F100-$F$91)/$G$89 and should fix everything.

Page: Arms, Fury
Type: Reference
-Crit damage Meta gem's SEP value is wrong with increments. To fix, go to the SEP calculator on both the Arms and Fury pages (it's on the left more towards the middle) and select cell G102, G104. Instead of =(F102-$F$91)/$F$90 it should read =(F102-$F$91)/$G$89 for G102 and =(F104-$F$91)/$G$89 for G104 should fix everything.

Page: Fury, Arms
Type: Languaging/Typo
SEP macro running causes error across entire sheet with EU formatted numbers.
Solution: Problems with SEP macro is caused by regional language differences. In US dot "." is used to separate wholes from decimals, and in Poland or Germany a comma ",". Cells C102 and C104 are formatted like "Text" and dot there is not automatically converted into comma. Therefore if you have problems with massive errors after running SEP macro all you have to do is to change "0.1" into "0,1" in cells mentioned above or something of that nature. Make sure to have all the ducks in a row with cells in proper format types before running the SEP macro.

WORKING NOTES LIST FOR 3.3
-Added known items.
-Fixed Crit damage meta, and weapon speeds not having proper SEP with increments other than 1.
-Corrected [Blood of the Old God]'s AP proc not counted right in cosmetic displays due to a typo
-Increased the amount of armor penetration permutations to accomidate the new trinket.
-Reformatted the Lookup page for cross-compatability for excel '97.
-Added a QuickNav bar to instantly navigate to any item's table from any location on the lookup page to reduce scrolling.
-Reformatted the arp and crit permutation tables for cross-compatability for excel '97.
-More developed instructions on the intro page.
-Added resilience to item tables as well as a resilience tally.

 

Emeraude

Dragging this over from the other thread since it was on the topic of this spreadsheet.

When I punched in the numbers here I found that gemming for hit was still superior to gemming for str up to the 10%(Assuming Dreanei racial/precision maxed). Was I doing something in error or what?

http://www.megaupload.com/?d=CX81UJZ8
For the lurking Phoenix Wright faithful.
What is the most important thing to you? Won't you grant me the pleasure of taking it away.

 

cryinfreeman

Emeraude, i have the same impression. Hit will probably give the most dps until you cap it. Or at least get close to the cap. The last part in the quoted text speaks of getting rage cap all the time. Seeing my rage bar in our Naxx raids, i can't say i agree. I have 8.72% hit with hit food and precision maxed and i can safely say that the misses were a bit of a problem. Maybe you don't need 14% hit. Maybe you could go with let's say 13% and see how it turns out.

About crit being valued over hit even if you are not capped (if that's the case), i think that Deep Wounds plays a really important role here. While in BC it was almost useless, the latest buff could really boost the crit value. I'll agree that crit along with strength are the best stats for warrior after you get the hit cap but i'll keep my doubts about crit or strength being more important if you are not.

 

• landsoul

Hit is superior once your AP and raid synergies become paramount. STR is additive and Hit is multiplicative. When I calculate at 5400 dps a Hit gets about 1.15 of a STR for me. When I take out the raid buffs STR evens out. This is of course, with all 80 heroic/raid loot at level 80, not 70.

I don't see error. Maybe he was saying this for 70?

 

Moogul

Not to nitpick, but this is really a misleading statement. Str is additive with Str, but multiplicative with hit (and crit, and agi, and armour pen, and expertise). Hit is multiplicative with Str, but additive with hit.

The value of strength will go up the more hit you have, and also the more crit you have. The value of hit will go up the more strength you have. Depending on your current ratio between the two, one will be worth more than the other.

Strength does not correspond to a static increase in dps. The more other stats you have, the more 'value for money' you get out of strength.

Ijago <Casual Jerks>

 

suicuique

Adding to this I do think it is important to keep in mind that each hit/str/crit addition has to be seen relative to the pool it is added to.

I cant think of a better way than to put it in a (highly theoretical) academic example:

While 20 STR may be superior to 20 Hit (even if not hit capped) at low AP values, it is just a drop in the bucket when reaching very high AP values e.g. of 10000 AP.
Everyone should agree that gemming for STR would result in severe "dimishing returns" (seen relatively to your total DPS) at these gear levels, and that crit/hit/exp would be the better stats to gem (until some caps).

I do not have a founded opinion where these lines may be, just experimenting around at the moment. I have prioritized heavily hit and crit in my gem slots. Well over the hit cap ... becuae I had the gut feeling rage drought moments severely hurt my DPS. Switching to STR shortly and see how it compares.

 

mmaker

Thanks for this. Quite abit different between this and maxdps. For example maxdps says titan impact chocker is better then 25 badge neck, while this says the opposite =)

Anyways dont know if im dumb but when i change food from 30 STR to 30 hit,crit or haste nothing happens with the dps. Same happens when i try change to DK Ice Talon, nothing happens.

Also adamantite stones cant be used on Wotlk weapons afaik.

 

Faeviactus

I am not sure Maxdps is really on topic with this but there are various bugs I have found with that site. Not the least of which is converts my old armor penetration value to armor penetration rating at import. Giving me values of like 960 in ArPR which immediately devalues ALL armor penetration on gear. Adjusting that number often fixes the gearing lists. I have noticed though different days switch the badge and the crafted neck, seemingly on whim as #1.

 

Konorel

When using the newest version of this spreadsheet, I changed all of the sockets to "None" on the glove slot, and when I changed the top right cell, my DPS and a lot of other values became #N/A, similar to what happened when changing the enchant value for the chest slot.

Edit: I also found that the 7 STR 7 Hit gem is actually calculated as a 7 STR 7 Haste gem.

 

Konorel

See previous post

 

Slevin

File: FuryDPS2.010BETAExcel07.xlsm

Obsidian Greathelm is listed as having 59 armor penetration instead of 59 expertise rating.

 

Slik

Is there any future plans to enable an arms option on this spreadsheet?

 

• LodeRunner

Here I thought we were in the FuryDPS Calculation Spreadsheet thread.

 

Webb

Very viable question, in my opinion. After the forum resets there is no arms discussions whatsoever. Do we need to make a new thread or can we add it to this one (without the permaban?)

 

• landsoul

It's a legitimate question, actually. I do plan on working in Arms once a legitimate means of accurate and reasonable modeling can be realized.... But that doesn't exist yet.

 

Squallalaha

I can use Weightstones on Titansteel Dest (Mace), But Can't use the Sharpening on the Colossus Axe.

 

cryinfreeman

I had the same problem with a blue axe. Dunno what was wrong, maybe it's because i had titanium chains.

 

Mendo

As far as I know, none of the weapon oils or stones are supposed to work on level 80 weapons. My guess is that they probably are supposed to stop working on either ilevel 187 or 200 weapons...but it seems that they possibly forgot about weightstones and only changed sharpening stones. I can't say for certain really, since I'm basing my assumptions on the observation of only two people having problems with stones and blades of some sort.

 

Corobi

I have the same problem. I've tried adding "None" to some of the Enchant/Gem lists that are missing that option, but my Dps, SEP and many other things change to #N/A when I try. I would love to learn and dig around deeper to find the problem on my own, but my knowledge of Excel is pretty limited.

A new version or update would be great if you find the time, or even just a way to make a quick fix if possible.

Thanks

 

Wolvynskye

Nice work as always landsoul on these spreadsheets, they are very helpful; just a quick question. Is the [Darkmoon Card: Greatness] going to be added to the trinket list? (The 90 Strength version) Thanks.

 

• landsoul

Never knew that was even in the game. This will be an interesting card to add. Sometimes you will have more agility than strength, because there are good mail and leather items, and also because there is Mongoose in the absence of Berserking. However I do believe that you will be able to choose between 90 STR and 90 Agility. I do see on wowhead that it is a 35% chance proc trigger spell, undoubtedly with a 45 second ICD.

There's a lot of talk on wowhead about this card right now, whether or not you can use the 90 str and 90 agi simultaneously, or even if you could, would the procs stack? That would be pretty rediculously awesome. I'd want to wait until some actual usable data/comments come out with it from the inscriptors after the actual Darkmoon event.

 

Wolvynskye

My alt rogue is an inscriber and this was a bitch to get a deck done. I was lucky enough to team up with a few other inscribers to make a full deck by trading cards of ones we had too many of. I am working on a second deck and have most of the cards for it. The worse part is random cards come out since there is 4 new decks in northrend and the materials are hard to come across without blowing a bunch of cash on the AH.

I am leaning toward the idea that the cooldowns will be shared, but it would be crazy good for a double proc; we shall see. I am going to try to finish another deck with the passive 90 agility for my tanking set, so I will get an opportunity to try them both together, being I finish the deck and I am not tempted to sell it since I am already getting 8k gold offers for my completed deck.

Nevermind, I just noticed on the tooltip its unique equipped, so there goes that idea of a double proc

 

• landsoul

The idea is that they are different items, one being strength and the other bring agility. They are not the same item therefore you could equip both.

 

Senjion

They share the same Name "Darkmoon Card: Greatness" and have a Unique-Equipped distinction. I am going to guess that you cannot equip more than one flavor of card.

Also: Has anyone tested to see if the quest can even be accepted more than once? After it is completed and you attempt to accept the quest again, there is the possibility that it will say "You have already completed this quest."

 

• landsoul

I did some reformulating of my weapon enchant uptime formulas. I updated them to the 1-(1-p)^(dv) model shown in the Proc Mechanics Thinktank. That incorporates the idea that self-refreshing buffs overlap their uptimes. THis will be in the upcoming build. Can anyone get a hold of some of the answers to "questions needing answered" please?