Elitist Jerks
Register
Blogs
Urban Rivals
Forums
New Posts


Go Back   Elitist Jerks > Public Discussion > Class Mechanics > Warriors
Elitist Jerks Login

gamerDNA Login

Welcome to Elitist Jerks
We're testing some new features on the site regarding OpenID registration and coordination with gamerDNA. If you experience any issues with registering an account, please take the time to fill out a report and send it to this e-mail address. We would appreciate any assistance you could provide in making sure everything is functioning as intended. Thanks!

If this is your first visit, please be sure to check out the FAQ and the forum rules. Users must register to post and new registrations are subject to a one day "mute" period to get acquainted with the community.

Reply
 
LinkBack (747) Thread Tools
Old 11/25/08, 7:22 PM   722 links from elsewhere to this Post. Click to view. #1
 landsoul
Didn't reroll DK
 
landsoul's Avatar
 
Night Elf Warrior
 
Alterac Mountains
Warrior DPS Calculation Spreadsheet

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.
SlotFuryArms
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]
BackVereesa's Dexterity (Heroic)Vereesa's Dexterity (Heroic)
Chest[Wrynn's Battleplate of Triumph][Wrynn's Battleplate of Triumph]
Wrist1.,2.[Boneshatter Armplates]/3.[Bracers of Dark Determination][Bracers of the Untold Massacre]
Hands[Gloves of Bitter Reprisal][Wrynn's Gauntlets of Triumph]
Waist1.[Belt of Deathly Dominion]/2.,3.[Bloodbath Belt][Belt of Deathly Dominion]
Legs[Wrynn's Legplates of Triumph][Legguards of the Lurking Threat]
Feet1.,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.

Last edited by landsoul : Today at 12:14 AM.
 
User is offline.
Reply With Quote
Old 11/26/08, 1:56 AM   #2
Emeraude
Bald Bull
 
Emeraude's Avatar
 
Night Elf Warrior
 
Sargeras
Originally Posted by Shha View Post
Because haste requires less rating then crit for 1%. Additionally your gear haste % is usually way lower then crit % - meaning that increasing haste by 1% has more of an impact then crit. Im not saying haste is good, mostly answering your question LodeRunner. At some gear level haste will catch up to crit im sure. Right now however its lower.

Right now from my spreadsheets, as well as landsouls, and multiple sims stat priority seems to be:

1st) Str - yes EVEN if you are NOT hit or expertise capped, gemming str is best for TG. I find it a bit hard to believe - but when 5 different math models seem to give me that result... I see no other way but to accept it.

2nd) Hit/Expertise until cap. Both around 90% of STR value - at naxx gear level.

3rd) Crit - definitely above other non STR stats

4th) Agility/haste/ArP - depending on gear i use the value of those 3 switches. Most common is Agility>ArP>Haste

5th) Hit - its WAY lower after the cap then other ones.

Reason for the low hit/expertise/haste position:

Those are the stats that impact rage generation the most. Thats why they were high pre-WLK. Right now in raiding environment I *ALREADY* am capped on rage most of the time - using heroic on every swing etc. And thats beggining of the expansion. In short, raiding warriors now have infinite rage. Therefore hit only affects now offhand dps - since rage is enough to use everything else on cd, and heroics take place of MH swings. Haste is higher , but again - the rage generation boost from haste is unimportant. Same for expertise.
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.
 
User is offline.
Reply With Quote
Old 11/26/08, 2:33 AM   #3
cryinfreeman
Glass Joe
 
Tauren Warrior
 
Jaedenar (EU)
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.
 
User is offline.
Reply With Quote
Old 11/26/08, 2:39 AM   #4
 landsoul
Didn't reroll DK
 
landsoul's Avatar
 
Night Elf Warrior
 
Alterac Mountains
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?
 
User is offline.
Reply With Quote
Old 11/26/08, 6:50 AM   #5
Moogul
Captain Magic
 
Moogul's Avatar
 
Human Rogue
 
Argent Dawn (EU)
Originally Posted by landsoul View Post
STR is additive and Hit is multiplicative.
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>
 
User is offline.
Reply With Quote
Old 11/26/08, 7:26 AM   #6
suicuique
King Hippo
 
Night Elf Warrior
 
Antonidas (EU)
Originally Posted by Moogul View Post
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.
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.
 
User is offline.
Reply With Quote
Old 11/26/08, 8:23 AM   #7
mmaker
Von Kaiser
 
Undead Mage
 
Lightbringer (EU)
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.

Last edited by mmaker : 11/26/08 at 8:54 AM.
 
User is offline.
Reply With Quote
Old 11/26/08, 11:33 AM   #8
Faeviactus
Glass Joe
 
Human Warrior
 
Gorefiend
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.
 
User is offline.
Reply With Quote
Old 11/27/08, 12:05 AM   #9
Konorel
Glass Joe
 
Konorel's Avatar
 
Dwarf Rogue
 
Bloodhoof
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.

Last edited by Konorel : 11/27/08 at 12:24 PM. Reason: Accidental double post
 
User is offline.
Reply With Quote
Old 11/27/08, 1:01 AM   #10
Konorel
Glass Joe
 
Konorel's Avatar
 
Dwarf Rogue
 
Bloodhoof
See previous post

Last edited by Konorel : 11/27/08 at 12:24 PM. Reason: Accidental double post
 
User is offline.
Reply With Quote
Old 11/27/08, 7:09 AM   #11
Slevin
Glass Joe
 
Human Warrior
 
Ravencrest (EU)
File: FuryDPS2.010BETAExcel07.xlsm

Obsidian Greathelm is listed as having 59 armor penetration instead of 59 expertise rating.
 
User is offline.
Reply With Quote
Old 11/27/08, 3:33 PM   #12
Slik
Glass Joe
 
Undead Warrior
 
Bonechewer
Is there any future plans to enable an arms option on this spreadsheet?
 
User is offline.
Reply With Quote
Old 11/27/08, 10:37 PM   #13
 LodeRunner
Feed me a stray cat
 
LodeRunner's Avatar
 
Undead Warrior
 
Mal'Ganis
Here I thought we were in the FuryDPS Calculation Spreadsheet thread.

 
User is offline.
Reply With Quote
Old 11/28/08, 10:51 AM   #14
Webb
Von Kaiser
 
Tauren Warrior
 
Ravencrest (EU)
Originally Posted by Slik View Post
Is there any future plans to enable an arms option on this spreadsheet?
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?)
 
User is offline.
Reply With Quote
Old 11/28/08, 2:25 PM   #15
 landsoul
Didn't reroll DK
 
landsoul's Avatar
 
Night Elf Warrior
 
Alterac Mountains
Originally Posted by LodeRunner View Post
Here I thought we were in the FuryDPS Calculation Spreadsheet thread.
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.
 
User is offline.
Reply With Quote
Old 11/28/08, 10:48 PM   #16
Squallalaha
Glass Joe
 
Tauren Warrior
 
Andorhal
Originally Posted by mmaker View Post

Also adamantite stones cant be used on Wotlk weapons afaik.
I can use Weightstones on Titansteel Dest (Mace), But Can't use the Sharpening on the Colossus Axe.
 
User is offline.
Reply With Quote
Old 11/29/08, 12:03 PM   #17
cryinfreeman
Glass Joe
 
Tauren Warrior
 
Jaedenar (EU)
I had the same problem with a blue axe. Dunno what was wrong, maybe it's because i had titanium chains.
 
User is offline.
Reply With Quote
Old 11/29/08, 10:12 PM   #18
Mendo
Glass Joe
 
Night Elf Warrior
 
Bloodhoof
Originally Posted by cryinfreeman View Post
I had the same problem with a blue axe. Dunno what was wrong, maybe it's because i had titanium chains.
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.
 
User is offline.
Reply With Quote
Old 11/30/08, 5:52 AM   #19
Corobi
Glass Joe
 
Orc Warrior
 
Ghostlands
Originally Posted by Konorel View Post
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.
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
 
User is offline.
Reply With Quote
Old 12/01/08, 12:15 PM   #20
Wolvynskye
Glass Joe
 
Human Warrior
 
Misha
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.
 
User is offline.
Reply With Quote
Old 12/01/08, 1:01 PM   #21
 landsoul
Didn't reroll DK
 
landsoul's Avatar
 
Night Elf Warrior
 
Alterac Mountains
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.
 
User is offline.
Reply With Quote
Old 12/01/08, 1:43 PM   #22
Wolvynskye
Glass Joe
 
Human Warrior
 
Misha
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

Last edited by Wolvynskye : 12/01/08 at 1:48 PM.
 
User is offline.
Reply With Quote
Old 12/01/08, 3:27 PM   #23
 landsoul
Didn't reroll DK
 
landsoul's Avatar
 
Night Elf Warrior
 
Alterac Mountains
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.
 
User is offline.
Reply With Quote
Old 12/01/08, 4:54 PM   #24
Senjion
Glass Joe
 
Tauren Warrior
 
Blackrock
Originally Posted by landsoul View Post
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.
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."
 
User is offline.
Reply With Quote
Old 12/01/08, 5:28 PM   #25
 landsoul
Didn't reroll DK
 
landsoul's Avatar
 
Night Elf Warrior
 
Alterac Mountains
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?
 
User is offline.
Reply With Quote
Reply

Go Back   Elitist Jerks > Public Discussion > Class Mechanics > Warriors

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mongoose calculation or simulation? sag_ich_nicht Public Discussion 1 08/05/08 10:59 AM
[Rogue] Backstab damage calculation Karmon Class Mechanics 5 11/04/07 6:22 PM
Range Calculation Nite_Moogle Theorycrafting Think Tank 0 09/21/07 1:02 PM
Ilvl calculation Drauk Public Discussion 9 03/24/06 5:30 PM