Is it possible to go back to your .zip download format? Macs cannot read .exe.

oops, that was acidental. changed back to .zip

Leggings of the Immortal Night should have 32 hit rather than 32 crit.
Bladed Chaos Tunic should have 120 AP rather than 12

First I want to thanks you for making this stylesheet, it has been a great help for me and many others.

The reason I'm posting is a question of weapons. I'm now wielding Talon of the Pheonix in MH and Fury with +8 Strength socket in OH.

We have just started BT and downed the two first bosses. Now, when I equip the weapon dropped from Supremus([Syphon of the Nathrezim]) in my OH, my estimated DPS drops

It strikes me as odd, Fury is good but I had believed that the weapon would be better with more AP and more dmg.

Any input would be welcome, and thanks again for the effort you put in to this.

Rising Tide wastes quite a lot of budget on stamina, whilst the Talon is one of the most perfectly statted weapons there is. Syphon is also not a very good warrior weapon and on top of that I'm not sure the proc is modelled correctly.

Aye, I checked it again. My problem isn't the Talon of the Pheonix. Rather my OH Fury. I rechecked it and Rising Tide does show a better result, but not the Syphon of the Nathrezim.

EDIT:

I did a little test:

When I equipt Blade of Infamy on OH:

Blade of Infamy
Binds when picked up
One-Hand Sword
182 - 339 Damage Speed 2.60
(100.2 damage per second)
+28 Agility
Durability 105 / 105
Requires Level 70
Equip: Increases attack power by 56.

I get 1219,5 DPS

Compared to Syphon of the Nathrezim:

Binds when picked up
One-Hand Mace
196 - 365 Damage Speed 2.80
(100.2 damage per second)
Durability 105 / 105
Requires Level 70
Equip: Increases attack power by 50.
Chance on hit: Fills you with fel energy allowing all melee attacks to drain life from opponents.

Granted it has 6 less AP and 28 less agilty, but it has a proc that steals around 30 hp from target(if I'm not mistaken). But with this I get: 1203,8 DPS

Does 28 agi and 6 ap make up 15,7 DPS?

For clarification, I know the Blade of Infamy is better. It just seems the Syphon is underestimated. Especially when its getting beaten in DPS by Fury.

With Fury equit and socketed with 8 strength, estimated DPS is 1206,2

I guess this is the best place to ask this.

I am trying to work on my own spreadsheet, but adding on more complicated bits like streaks. I dont remember enough of my stats class to figure this part out though.
I want to know, given a number a swings, the odds of each number of hits from the set, order doesnt matter. For example, if I swing 5 times with a 20% chance to miss, what are the odds of hitting 4 times? Hitting 5 times would be .8^5, but I dont know the formula for the rest of the values.

In Grims Sheet Syphon & Rod of the King dmg calculations dont include their proc, for this you have to d/l niutas sheet.

I believe the eternal champion ring from hyjal exalted is not figuring the ap proc.

As for the Rod of the Sun king I only think you would find a significant increase in DPS if you had rage problems then the proc would help you greatly but if you can already spam on cool down and HS with out rage starvation, the proc would be worthless or close to it.

I will address this issue. I was not aware of it.


On another note, does bloodthirst benefit from two-hand weapon spec in a 2h fury build? I am assuming no, but I am not 100% certain on this. Thanks.

I doubt it does because BT doesn't hit with weapon. Speaking of that I also think that BT might not even proc weapon enchants as well. Anyone did some testing on this tho?

Id like some input on what enchants to execute with. I will be using Boundless Agony ( Boundless Agony - Items - World of Warcraft) in MH and S3 Fast Axe in OH. Im assuming im going to keep executioner on MH and Mongoose OH.

thx for the new version sheet.

is it possible to add the new trinkets of patch 2.4? e.g. Blackened Naaru Sliver and Shard of Contempt

and according to the v313 sheet i found that haste rating is more and more important, my hit rating became very low.

is it normal? e.g Band of Ruinous Delight + Band of Devastation is higher dps than Band of Ruinous Delight + Stormrage Signet Ring.

is that saying something like for dw fury warriors, crit/hast/arpn/expert/str/ap always > hit after our hit reached 9%(no miss for yellow attack).

In terms of the raw numbers and equations, hit becomes overshadowed by other DPS stats right after hitting the special cap. However, practically speaking from my experience and that of the other DPS warriors in my guild, with more hit comes more even rage generation and easier maintenance of the rotation -- in the end, it has to be a personal choice.

Is there a mirror for the spreadsheet? Rapidshare is giving me a javascript error in three different web browsers.

Edit: Must have been a temporary issue, it works now

Are you suggesting a DPS difference, or just "easy"? That's certainly a "personal choice," but not what theorycrafting maximum DPS is about.

Hmm.. as noone gave you an answer yet I will see if I remember my statistics right. I do recommend you do some reading up on the subject though, especially if you're going to put it to use in a spreadsheet.

If order does not matter you need to work with combinatorics. If you want to know the probability of one miss and 4 hits you first have to consider that any one of your swings can be a miss for the given case to occur. That is you can have miss-hit-hit-hit-hit, hit-miss-hit-hit-hit, hit-hit-miss-hit-hit, hit-hit-hit-miss-hit and hit-hit-hit-hit-miss for a total of 5 combinations.
Next you look at the probability of each of these 5 specific cases, luckily they're all .8^4 * .2 = 0.08192. Since there are 5 of these cases that will yield the result you're looking for, your number should be 5 * 0.08192 = 0.4096.

Doing the math on 2 misses, 3 misses, 0 misses etc should show that this case has the highest probability of happening, as can be expected with a 20% miss ratio (1 in 5).


EDIT: Oh and since I was making a post anyway, I'd like to thank you guys for making the spreadsheets. Been following this thread with great interest for the last 3-4 months.

Hey I hate to be a worm in the apple of knowlege here, but as I am stumbling across this thread I have been working on my own DPS spreadsheet for a few months as soon as the first pieces of information from 2.4 was coming out. This table uses no data from the files posted here and is not an intent of stealing any credits, only a search for the "right answer" when comparing variations.

I'm not sure how versed the original creator of this sheet is at creating mathematical models for the dozens of different critical fury warrior functions that define the set, but I feel that at least some talent can be combined or that when my sheet is finished prior to the 2.4 official release it will not be trolled, shamed, or looked at as an infraction. I may have something to contribute to the community that was not known previous, I might not. My sheet calculates "circular reasoning beyond change in N degree." One example particularly, converting additional rage beyond rotation into additional heroic strike damage to white, and then including the gain in that benefit into other functions, which contributes back into rage generation and additional rage to heroic strike completing the cycle one time. Each of these cycles can be linked into another cycle and so on. Since this sheet may be protected, wether it can do that or not I wouldn'd be able to know unless the authors revealed it.

My sheet has complete lists of all blue+ desirable including certain leather items and -all- melee weapons epic or iLvL 115+. It includes all on use and all chance on hit or crit procs with visible proc uptime percentages. It includes user friendly item and gem selections, listed mostly known as most powerful to least. You can input any kind of buff, set bonus, talents, etc.

If anything I am asking the current updator of this sheet to meet with me and agree to terms on an ultimate sheet of mathematical and practical brilliance, or to agree to host two two seperate sheets, and let the public pick what they like and will use...

sorry double post, had to re-log the forums

Using version 313 of the sheet with excel 2007 I have found the following errors with the SEP calculations.

For some reason each increment for haste rating needs to be applied twice to stick.
Ie if you add 1 haste rating to the manual entries section the dps will not improve. However if you add the same value a second time it will correctly calculate the proper dps. This leads to the SEP value for haste rating being 0 due to the increment only being applied once.

The SEP values for ArP also seem incorrect and they show much to low. Looking at where the calculations are being made L109=L108-L107 and comparing the values in those cells to the surrounding ones I can see that the value of the original dps cell (L107) is not in agreement with that of surrounding cells. It seems that the value of this cell has been increased by some factor and the result is that ArP shows as being less good than it actually is in the SEP values.

As far as protected goes, that's just to avoid people meddling with stuff tehy don't need to worry about. You can always turn off the protection in some menu (I use OO so don't really know where to turn off "Protect" in MS Excel). Then you just mark all of the sheet and change colour of the text to something visible.

The statement "converting additional rage beyond rotation into additional heroic strike damage to white, and then including the gain in that benefit into other functions, which contributes back into rage generation and additional rage to heroic strike completing the cycle one time" strikes me as a bit strange. The extra damage from HS will be yellow and thus not give you any extra rage. It will also not affect flurry since the HS hit eats up a white hit. The current sheets already converts excess rage to HS. I can't really think of any other effect the extra HS damage would have that would force you to use some kind of circular calculations.

Also, I think you should feel free to work on your own spreadsheet and publish it, just make sure that you give credit to where it's due. The current sheet by Grim13 builds heavily on the sheet of drALLCOM3 (who himself borrowed most of the math models from earlier sheets).

Want to ask how the weapon dmg on character sheet is determined.For exaple i play with Deep thunder on live servers and with 1710 Atack power my top end dmg is 1042.Went on Trournament test realm with Merciless mace and 1780 AP the top dmg is 1049 on the common test realms i crafter Stormherald and the top dmg is 1079 with 1630 AP.So my question is why I have the same top dmg with Deep thunder with 1710AP when the wepon dmg is 541 and with Merciless 2h mace with 549 top dmg and 1780AP