• landsoul

The following spreadsheet is the product of the need for a user friendly and accurate DPS calculation and gear selection tool and about a year 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 three main goals of this project are: accuracy, simplicity, and user-friendliness. Please be sure to read the directions on the intro page in full and familiarize yourself with the program before you post in this thread, or send me PM's with questions. These spreadsheets are only compatible with and designed in Microsoft Excel '97 and '07. 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. Thank you for all your support!



Current Version:
v2.406a June 16 2009 WoW 3.1.3

Excel 2007 Compatible
WarriorDPS2.406aExcel07.xlsm Download File

Excel 1997/2003 Compatible
WarriorDPS2.406aExcel97.xls Download File

What to look for soon
-Simultaneous 3.1 / 3.2PTR builds to download
-3.2 Sheet with new talent changes and gear.
-3.2 Sheet with new color formatting in lookup page based on item location
-Possibly some page cleanup

Bugs this build
-Sanctified Retribution should grant 3% DIM, not 2%.
-Comet's Trail Proc not working
-Dark Matter Proc not considering white crit cap
-Certain armory upload enchants break the sheet
-Some issues with windfury totem giving #div/0! errors.
-Unbuffed HP too high with Strength of arms.

Changes this build
-Lengthened slam2 and slam2,5 periods slightly due to WW being delayed
-Added a permutation where there are no slams at all
-Updated some of the item stats
-Added unbuffed HP to Tuskarr's Vitality
-Added Comet's Trail Trinket

Changes last build
-Fixed rage generation formula to reflect the new level 80 constant:

-BT cooldown is 4 seconds, 20 rage.
-Statistically distributed BT-WW-BT rotations using opportunity cost loss minimizations between BT, WW, and Slam.
-Some item fixed and additions
-Automatic set bonuses (no longer have to turn them on or off)
-A little helper number to tell you how much rating you are from an ArP cap

Questions I would love to be answered:
I would like someone to help with the programming of Arms. There's a lot of conditions where it makes referencing cells messy and there's got to be a better way to organize it than the way I have it now without it breaking all over the place.
What is the threshold in seconds of DWounds munching, a phenomenon occurs when you crit two attacks in succession very near eachother? How could a statistical model be derived from that information?

Best in Slot (Hard Mode, also some items near equivalent)

Slot	Fury	Arms
Head	[Conqueror's Siegebreaker Helmet]	[Conqueror's Siegebreaker Helmet]
Neck	[Pendulum of Infinity] / [Frigid Strength of Hodir]	[Frigid Strength of Hodir]
Shoulder	[Conqueror's Siegebreaker Shoulderplates]	[Conqueror's Siegebreaker Shoulderplates]
Back	[Drape of the Faceless General]	[Drape of the Faceless General]
Chest	[Conqueror's Siegebreaker Battleplate]	[Conqueror's Siegebreaker Battleplate]
Wrist	[Solar Bindings]	[Bitter Cold Armguards] / [Decimator's Armguards]
Hands	[Conqueror's Siegebreaker Gauntlets]	[Conqueror's Siegebreaker Gauntlets]
Waist	[Soul-Devouring Cinch]	[Soul-Devouring Cinch]
Legs	[Legguards of Cunning Deception]	[Legguards of Cunning Deception]
Feet	[Melancholy Sabatons]	[Melancholy Sabatons]
Ring1	[Seal of the Betrayed King]	[Seal of the Betrayed King]
Ring2	[Brann's Signet Ring]	[Brann's Signet Ring]
Trinket1	[Mjolnir Runestone]	[Mjolnir Runestone]
Trinket2	[Darkmoon Card: Greatness] / Comet's Trail	[Dark Matter]
Weapon	[Voldrethar, Dark Blade of Oblivion] x2	[Dark Edge of Depravity]
Ranged	[Twirling Blades]	[Twirling Blades] / [Skyforge Crossbow]

If you wish to make a donation, you may send it paypal to technodragon@hotmail.com

 

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.
http://bloodragingirl.blogspot.com/
My own blog!

 

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?