• landsoul

If you wish to make a donation to ensure the interest in development, you may do so via Paypal, to technodragon@hotmail.com

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. Due to the lack of an accurate dynamic solution, the 4t10 set bonus is currently not supported for Sudden Death.

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. Please do not try to use them with Google Docs, Open Office, 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.

Before you do anything, please familiarize yourself with this first post. It gets regularly updated.

How to get this to work:
1. Get excel 97' or higher, I don't care how. There is a 2010 beta right now, which you can get free.
2. Download the spreadsheet.
2. Open it and read the directions.
3. Grats you are using the spreadsheet!

Also, I am getting quite frustrated with the amount of trash posts that end up in this thread. No one cares that you can get 1403 armor penetration rating. No one cares that you can properly answer the 'help me not suck at dps/armory link' posts so you can look smart. No one wants to read posts asking how to get the spreadsheet to work, when there are detailed directions there when you open it. Most issues can probably be remedied by reading the directions and understanding how the spreadsheet works before you attempt to use it. This thread is for discussing the spreadsheet only. Proper posts can include but are not limited to: Reporting errors, giving well-thought out and viable suggestions, discussing evaluations of items, discussing warrior mechanics that may pertain to the spreadsheet, asking/answering questions about operation of the spreadsheet, etc. Be intelligent with your post if you wish to make one. Please do your part to report any erroneous posts that you read (including old posts) to help keep poor posters off this forum, and to help keep mine and EJ's forum mods lives easier. Please do not PM me and go 'directly to the source' with your simple questions that can be easily answered by utilizing the 'simple questions and answers thread' or following directions. You may PM me with specific and detailed questions or concerns or that are not so easily answered via other means or utilizing the other threads. If you want serious help, I do offer personalized lessons for a reasonable price. I do also appreciate greatly donations. Thanks!!!!!

Programming and simulation help needed asap.
My programming language skills aren't that great, so I need some help. In order to find the right approach to a correct solution for a dynamic uses-per-second model for the arms rotation, I am in need of a simulation from which I can analyze it's numerical results from a wide range of inputs. If you are willing to spend a few hours collaborating with me in constructing a proper simulation and have great programming skills and proper language knowledge, please send me a message.

Current Version:
2.602 Feb 7 2010 WoW 3.3.2

Excel 2007/2010 Compatible
Download WarriorDPS2.602Excel07.xlsm

Excel 1997/2003 Compatible
Download WarriorDPS2.602Excel97.xls

Please not that any mods or translations listed below are not directly supported by me. I will not be responsible for any possible malicious software you may obtain by downloading these mods. I cannot directly help you with troubleshooting these mods. Contact it's creator for this.
A German Translation for 2007/2010 version 2.601 by Samot
Download WarriorDPS2.602Excel07_ger.xlsm from Sendspace.com - send big files the easy way

Best in Slot Sets
This list does not include any heroic items or Arthas loot. If you successfully execute an Arthas victory, you can probably get heroic ICC loot.

Slot	Fury	Arms (Best Guess)
Head	[Sanctified Ymirjar Lord's Helmet]	[Sanctified Ymirjar Lord's Helmet]
Neck	[Lana'thel's Chain of Flagellation]	[Wodin's Lucky Necklace]
Shoulder	[Sanctified Ymirjar Lord's Shoulderplates]	[Sanctified Ymirjar Lord's Shoulderplates]
Back	[Might of the Ocean Serpent]	[Recovered Scarlet Onslaught Cape]
Chest	[Sanctified Ymirjar Lord's Battleplate]	[Sanctified Ymirjar Lord's Battleplate]
Wrist	[Toskk's Maximized Wristguards]	[Toskk's Maximized Wristguards]
Hands	[Gatecrasher's Gauntlets]	[Sanctified Ymirjar Lord's Gauntlets]
Waist	[Astrylian's Sutured Cinch]/[Coldwraith Links]	[Coldwraith Links]
Legs	[Sanctified Ymirjar Lord's Legplates]	[Legplates of Painful Death]
Feet	[Blood-Soaked Saronite Stompers]	[Blood-Soaked Saronite Stompers]
Finger1	[Ashen Band of Endless Vengeance]	[Ashen Band of Endless Vengeance]
Finger2	[Frostbrood Sapphire Ring]	[Frostbrood Sapphire Ring]
Trinket1	[Deathbringer's Will]	[Deathbringer's Will]
Trinket2	[Whispering Fanged Skull]	[Death's Verdict]/[Death's Choice]
Weapon1	[Shadow's Edge]/[Shadowmourne]	[Shadow's Edge]/[Shadowmourne]
Weapon2	[Cryptmaker]
Ranged	[Stakethrower]	[Rhok'shalla, the Shadow's Bane]/[Frenzystrike Longbow]

This list has no difficulty restriction. Orc is oddly enough the same.

Slot	Fury	Fury+Shadowmourne
Head	[Sanctified Ymirjar Lord's Helmet]	[Sanctified Ymirjar Lord's Helmet]
Neck	[Sindragosa's Cruel Claw]	[Sindragosa's Cruel Claw]
Shoulder	[Sanctified Ymirjar Lord's Shoulderplates]	[Sanctified Ymirjar Lord's Shoulderplates]
Back	[Vereesa's Dexterity]/[Sylvanas' Cunning]	[Shadowvault Slayer's Cloak]/[Vereesa's Dexterity]/[Sylvanas' Cunning]
Chest	[Sanctified Ymirjar Lord's Battleplate]	[Sanctified Ymirjar Lord's Battleplate]
Wrist	[Toskk's Maximized Wristguards]	[Toskk's Maximized Wristguards]/[Polar Bear Claw Bracers]
Hands	[Sanctified Ymirjar Lord's Gauntlets]	[Aldriana's Gloves of Secrecy]
Waist	[Coldwraith Links]	[Coldwraith Links]
Legs	[Scourge Reaver's Legplates]	[Sanctified Ymirjar Lord's Legplates]
Feet	[Blood-Soaked Saronite Stompers]	[Blood-Soaked Saronite Stompers]
Finger1	[Ashen Band of Endless Vengeance]	[Ashen Band of Endless Vengeance]
Finger2	[Frostbrood Sapphire Ring]	[Frostbrood Sapphire Ring]
Trinket1	[Deathbringer's Will]	[Deathbringer's Will]
Trinket2	[Death's Verdict]/[Death's Choice]	[Death's Verdict]/[Death's Choice]
Weapon1	[Glorenzelg, High-Blade of the Silver Hand]	[Shadowmourne]
Weapon2	[Glorenzelg, High-Blade of the Silver Hand]	[Glorenzelg, High-Blade of the Silver Hand]
Ranged	[Fal'inrush, Defender of Quel'thalas]	[Fal'inrush, Defender of Quel'thalas]

Slot	Arms (Best Guess)
Head	[Sanctified Ymirjar Lord's Helmet]
Neck	[Sindragosa's Cruel Claw]
Shoulder	[Sanctified Ymirjar Lord's Shoulderplates]
Back	[Vereesa's Dexterity]/[Sylvanas' Cunning]
Chest	[Sanctified Ymirjar Lord's Battleplate]
Wrist	[Toskk's Maximized Wristguards]/[Polar Bear Claw Bracers]
Hands	[Sanctified Ymirjar Lord's Gauntlets]
Waist	[Coldwraith Links]
Legs	[Leggings of Northern Lights]
Feet	[Blood-Soaked Saronite Stompers]
Finger1	[Ashen Band of Endless Vengeance]
Finger2	[Frostbrood Sapphire Ring]
Trinket1	[Deathbringer's Will]
Trinket2	[Death's Verdict]/[Death's Choice]
Weapon	[Oathbinder, Charge of the Ranger-General]/[Shadowmourne]
Ranged	[Fal'inrush, Defender of Quel'thalas]

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

Notes for 2.502 update
-Added Arthas loot and season 8 items.
-Fixed the majority of incorrect item data.
-Crit conversion to hit is being replaced with the old crit depression. Blizzard hotfixed the system sometime recently without telling us.
-Fixed an issue where arms normalized rage gains were referencing the wrong cell for weapon speed.
-Added a thunderclap table for both Fury and Arms
-Added a Spell hit / Spell Crit / Spell Resist value into the hit table.
-Added spell buffs into the buff matrix.
-Made spell procs refer to the new values in the hit table.
-Fixed an issue where Armory Lookup macros pointed to the wrong point for incite in when parsing talents on wowarmory.
-Fixed haste gem in the lookup which was missing it's stat
-Fixed an issue where shoulder stats tally for gemslot2 (row276) in both fury and arms was not doing vlookup in the proper colums for agi or arp.
-Fixed [Tiny Abomination in a Jar] to proc MH damage more of the time, based on the first mote's activation. The DD occuring from the final mote is considered a melee strike and therefore should be able to proc Deep Wounds. It should rank higher on charts now. I don't plan to treat it's melee procs as regular melee strikes yet, as it becomes too complicated.
-Changed [Shadowmourne] strength proc to reflect the change to 30 str stacks. I'm not sure how the 270 str for 10 seconds and the 30 str stacks interact yet, or what the proc rate is so that will have to be figured out later.
-Fixed an issue where cell AE15 Fury/Arms refers to the wrong ring table in the lookup.
-Fixed the conditions in the DPS Metric cell at the top for prompting the user to switch the lookup to the appropriate spec needs to be adjusted.
-Fixced ShoulderLookup named range which did not span to the iLvL column. This caused the armory lookup problem to put a heroic tag on the shoulder at unnecessary times.
-Fixed Fury Rotation 11 which should have 1 slam instead of 0.

 

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?