[Warrior] DPS Spreadsheet 2.3 and beyond - Page 50

Grim13 · 03/06/08, 1:45 PM

Originally Posted by Bersi

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

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.

mogun · 03/06/08, 5:46 PM

Originally Posted by Grim13

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?

Grayson Carlyle · 03/06/08, 6:02 PM

Originally Posted by Grim13

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.

It does.

Just like 1-hand weapon spec increases your damage with all physical attacks while you're wielding a one-hander, so does two-hand weapon spec increase all physical damage done while wielding a two-hander.

Jevade · 03/06/08, 6:47 PM

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.

Acy · 03/06/08, 7:26 PM

Originally Posted by Grim13

And....since I don't see any fresh errors brought to light while I was away, I'm going to post a "final" version of the sheet in it's current form. Work continues on the new version, and I think I am getting close to being able to release an alpha quality version, suitable for inspection by those who would be interested in checking my math/offering suggestions. Maybe by the end of this week.

WarriorDPS_v313

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).

issei · 03/07/08, 2:12 AM

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.

samspot · 03/07/08, 1:00 PM

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

Apate · 03/07/08, 1:14 PM

Originally Posted by issei

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.

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

samspot · 03/07/08, 3:23 PM

Wow, I plugged in all my gear, then buffs i had for a SV run yesterday, and the spreadsheet had my dps down to within 10dps of what my meter recorded. Thats amazing

Feryar · 03/07/08, 4:36 PM

Originally Posted by Machinator

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.

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.

landsoul · 03/07/08, 5:26 PM

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...

landsoul · 03/07/08, 5:27 PM

sorry double post, had to re-log the forums

Brissa · 03/08/08, 5:58 AM

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.

Gruntle · 03/08/08, 9:11 AM

Originally Posted by landsoul

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...

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).

Mupushalosho · 03/08/08, 7:12 PM

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