 |
| 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 a 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.
|
11/25/08, 6:22 PM
|
#1
|
|
Didn't reroll DK
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 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)
If you wish to make a donation, you may send it paypal to technodragon@hotmail.com
Last edited by landsoul : 06/29/09 at 12:51 AM.
|
|
|
|
|
|
11/26/08, 12:56 AM
|
#2
|
|
Bald Bull
Night Elf Warrior
Sargeras
|

Originally Posted by Shha
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?
|
|
|
|
|
11/26/08, 1:33 AM
|
#3
|
|
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.
|
|
|
|
|
|
11/26/08, 1:39 AM
|
#4
|
|
Didn't reroll DK
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?
|
|
|
|
|
|
11/26/08, 5:50 AM
|
#5
|
|
heal fast and massive
|
Originally Posted by landsoul
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>
|
|
|
|
11/26/08, 6:26 AM
|
#6
|
|
King Hippo
Night Elf Warrior
Antonidas (EU)
|
Originally Posted by 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.
|
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.
|
|
|
|
|
|
11/26/08, 7:23 AM
|
#7
|
|
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 7:54 AM.
|
|
|
|
|
|
11/26/08, 10:33 AM
|
#8
|
|
Glass Joe
|
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.
|
|
|
|
|
|
11/26/08, 11:05 PM
|
#9
|
|
Glass Joe
|
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 11:24 AM.
Reason: Accidental double post
|
|
|
|
|
|
11/27/08, 12:01 AM
|
#10
|
|
Glass Joe
|
See previous post
Last edited by Konorel : 11/27/08 at 11:24 AM.
Reason: Accidental double post
|
|
|
|
|
|
11/27/08, 6:09 AM
|
#11
|
|
Glass Joe
Human Warrior
Ravencrest (EU)
|
File: FuryDPS2.010BETAExcel07.xlsm
Obsidian Greathelm is listed as having 59 armor penetration instead of 59 expertise rating.
|
|
|
|
|
|
11/27/08, 2:33 PM
|
#12
|
|
Glass Joe
Undead Warrior
Bonechewer
|
Is there any future plans to enable an arms option on this spreadsheet?
|
|
|
|
|
|
11/27/08, 9:37 PM
|
#13
|
|
Some kind of grammar strict police
|
Here I thought we were in the FuryDPS Calculation Spreadsheet thread.
|
|
|
|
|
11/28/08, 9:51 AM
|
#14
|
|
Von Kaiser
Tauren Warrior
Ravencrest (EU)
|
Originally Posted by Slik
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?)
|
|
|
|
|
|
11/28/08, 1:25 PM
|
#15
|
|
Didn't reroll DK
Night Elf Warrior
Alterac Mountains
|
Originally Posted by LodeRunner
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.
|
|
|
|
|
|
11/28/08, 9:48 PM
|
#16
|
|
Glass Joe
|
Originally Posted by mmaker
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.
|
|
|
|
|
|
11/29/08, 11:03 AM
|
#17
|
|
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.
|
|
|
|
|
|
11/29/08, 9:12 PM
|
#18
|
|
Glass Joe
Night Elf Warrior
Bloodhoof
|
Originally Posted by cryinfreeman
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.
|
|
|
|
|
|
11/30/08, 4:52 AM
|
#19
|
|
Glass Joe
|
Originally Posted by 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.
|
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
|
|
|
|
|
|
12/01/08, 11:15 AM
|
#20
|
|
Glass Joe
|
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.
|
|
|
|
|
|
12/01/08, 12:01 PM
|
#21
|
|
Didn't reroll DK
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.
|
|
|
|
|
|
12/01/08, 12:43 PM
|
#22
|
|
Glass Joe
|
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 12:48 PM.
|
|
|
|
|
|
12/01/08, 2:27 PM
|
#23
|
|
Didn't reroll DK
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.
|
|
|
|
|
|
12/01/08, 3:54 PM
|
#24
|
|
Glass Joe
|
Originally Posted by 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.
|
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."
|
|
|
|
|
|
12/01/08, 4:28 PM
|
#25
|
|
Didn't reroll DK
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?
|
|
|
|
|
|
|