landsoul

***WARNING: DO NOT ATTEMPT TO USE THE SHEET UNTIL YOU HAVE READ THE DIRECTIONS. YOU MUST REFRESH EACH CHANGE UNTIL THE NUMBERS HAVE CONVERGED. REFRESH = CTRL+SHIFT+Y***

Current Version:
v1.319 Jun 25 2008
FuryDPS1.319.ods - FileFront.com 4.16 MB

Downlaod OpenOffice here
download: OpenOffice.org Downloads

Current Build Changes:
Added permutation calculations to Executioner and MOTB to solve issues regarding choosing ArP gear when dealing with soft caps on 6200 armor bosses. Made armor reduction calculations more accurate overall.
Added [Might of the Scourge] as a shoulder enchant.
Added [Brutal Gladiator's War Edge]
Fixed an issue where [Adamantine Chain of the Unbroken] was not showing its crit rating.
Removed damage procs completely from the sheet as all they were doing was taking up space.
OpenOffice 2.4 patch I believe converges the numbers more quickly, so less refreshing is required.


To Do:
Confirm exact PPM for all items.
Is DW slam viable? If so, how can a spreadsheet utilize this option?
Avoidance streaks: how can this reduce DPS by causing not enough rage to close rotation..
Crit Starvation: What is the chance to be crit starved and not be able to refresh rampage...
Execution: what is the most feasible and accurate, all combination spanning way to model execute DPS...

If you have any input or corrections to this sheet, please post them and include link of proof or any research done to facilitate worth to the proposed change.

About refreshing: I am looking into the possible reason this occurs.

Not too soon after the mechanics of the sheet finalize, I will release the mathematical proofs regarding the theorem in the sheet.

 

Korash

I'd say landsoul just did a typo, considering that he has the Warglaives enchanted with Executioner MH and Mongoose OH.
But I like the Spreadsheet a lot. Easy to use, most important Items are in. Keep up the good work.

 

Gruntle

Yeah, seems like a typo to me too, I must admit that this spreadsheet is now the one I'm using (I gave up on my own OO spreadsheet in favor of this). Simple to use, works in OpenOffice and is more stable than the other sheets (in my opinion). Great work landsoul!

 

Tauftamir

The cooldown begins when the buff starts. You should be able to find evidence of this in the DST Thread, if memory serves.

 

landsoul

If only the DST threat was more than just mindless speculation... what I really would love to see is a screenshot of a combat log with the buff coming up 10-15 seconds after it faded. that would be hot.

If thats true, then uptimes on hidden cooldown items will start going up and numbers will shift and maybe bump around certain SEP rankings with these items equipped.

 

landsoul

On topic of BS hammers: from [Warrior] DPS Spreadsheet 2.3 and beyond

There's a lot of conditions there that seem funky. That and also the whole thing of measuring PPM of something that procs a good amount of haste throws the whole thing off too. I'm biased towards things being either 1.0 or 1.5 ppm, but I guess I can remove the hidden CD. That being said I will probably have to bump it down to 1.0 instead of 1.5 ppm after that to make the uptime at all reasonable.

 

Possessed

First up, nice job on the spreadsheet thus far .

With a quick play around on v1.101 I thought of two suggestions:

-Items with procs dont have the DPS gained from the proc added to DPS gained from the passive stats (on the Gear Display sheet). EG: DST shows as ~19DPS, is it possible to add the DPS from the proc too?

-On the Gear sheet, perhaps underneath the section for unbuffed stats, there could be a buffed stats row too, just for a quicker reference rather than switching to the output sheet.

Also just wondering if using ctrl-shift-y (no biggy really, i just occassionally forget :P) is a permanent thing i'll have to remember to do because of a limitation in the program, or is a workaround in the works?

Looking forward to the execute stuff being implemented

 

Shha

Well reasonable value after everything is considered should be around 35%, which is what i see in raids. Given how Executioner ends up being 54% uptime with your sheet using 1 PPM and 15 sec duration, i guess 1 PPM +10 sec duration would do it.

As for the SEP values. Trying to play around and test it, but honestly , its pretty strange that your spreadsheet and other 2 differ so much here. Im trying to play around with different values before making a verdict, but its fishy (especially that when i set my crit rate near 0, the value of crit is lower then with normal gear, instead of higher which doesnt seem to make sense at all).

 

Machinator

-Still cant put executioner on OH.
-I dont understand how you figure out rage/sec. I cant find anything that looks like a rage formula and the rage/sec cell doesnt seem to reference anything that has the information you would need, like weapon speed, crit bonus, ect. It just looks like you multiply white dps by a constant which doesnt really make sense.

-"Wicked Edge of the Plains" should be "Wicked Edge of the Planes"
-The OH fury should have a red socket with a 4 AP socket bonus, sheet shows no sockets.
-Is there anyway to detect the proper Gem bonus? Gems/bonus dont go away when you switch to an item with no sockets.

Edit: I also linked the data showing mongoose/executioner proc rates to be more than 1 ppm in the other thread. Here it is again Link

"Information is ammunition."

 

Shha

Well if thats the case (rage = dps x constant) , it would explain the STR dominance in the chart. As haste/crit increase the rage generation by more then the added dps, while str doesnt. However, I dont have enough calc sheets knowledge to see if thats whats happening.

 

landsoul

About the Crit SEp thing when you lower it, I will analyze it when I get home from work.
I will definately change BS hammer to 1 PPM no cooldown.

On dual executioner: I do plan on putting it in, yet its not my priority at the moment. there are still a lot of things I need to fix before I do something secondary like that and for any conclusions to be made on that regard I dont want that to happen based on false information.

On: RAGE PER SECOND

A fury warrior's rage flow fully controls his second half of his DPS, his yellow attacks. To be able to determine how frequent he can use those abilities, we must arrive at an ideal RPS value.

Luckily, we already have our ideal white DPS and windfury values. All we have to do then, is to find a way to plug it into blizzard's rage generation formula, shown below for level 70.

(7.5d / 274.7 + f * WepSpd) / 2

f = 7 for MH crit, 3.5 for MH hit and OH crit, and 1.75 for OH hit

d is the damage dealt, or the damage you apply with armor taken into account. Blizzard wants us to get 1 rage for every 73.25 damage we deal plus a normalized amount based on our weapon speed and rolled hit. For example, if we were to crit with our 2.6 speed main hand for 1000 and hit with our 2.6 speed off hand for 300, we would get 22 and 6 rage.

Since we are working with infinites, we want to know rage over time, but this formula only shows the rage per hit. All I do is convert that rage per hit and multiply it by hits in MH and OH and WF per second, and combine a shit ton of terms.

RPS = .01365[WhiteDPS+WFDPS] + 21 / 8 * (1 - [%dodge] - [%misswhite] + [%crit])(1 + [%hasteAVG])(1 + .25[%FlurryUp])(1+[%AVGSpeed] + 1/3[AManage] + 3[UBWrathTP](MHWepSpd[MHWHSperSec] + OHWepSpd[OHWperSec]) + (20 + 3[ImpBR]) / 60 + ([MHWHSWFSpecperSec] + [OHWWWperSec])[%dodge][4pct4]+[RotSKprocperSec]

The proof is way too large to bother posting it at work, but I did work it out and go through it twice to make sure it was correct. I do however need to go back into it sometime and add the normalized portion of the WF hits into the formula, cause I honestly forgot when I made it. That will take some time and verification also.

The only real thing rage per second over rotation contributes to is Heroic strike, which tightens up our hits per second and adds a little bit of DPS, all while increasing our proc and flurry uptimes. One thing I might want to figure out is if spamming hamstring to increase proc uptimes is better than using rage for heroic strikes, but probably not.

Thanks for catching Wicked edge of the planes and fury. Those typos drive me nuts sometimes.
Also great idea on the buffed stats row. I will include one that lists static raid buffs, which will mostly only incerase your AP and crit or hit if you eat the food or if you have a Draenei.

I also have been doing a lot of reading about haste... well does PPM use listed weapon speed on the tooltip, or on the character sheet after haste and speed buffs?. I dont have the time or the energy to sit in F'in blasted lands and do this junk myself.

I do intend to add SEP values to procs from items into the item SEP value, but that will take some time, so just be patient! All will come in good time =)

 

Hozz

Any chance you could work sword spec into the talent portion?

 

landsoul

Possibly yes when I can start on damage procs but not yet

 

WernerVonBraun

1. [Rod of the Sun King] About 6 PPM, no CD. I don't think it's crucial, since it's not a very powerful proc. Maybe I'll test it properly (I would now, if the PTR was up...).
2. [Romulo's Poison Vial] 1 PPM or 1,2. Not very powerful anyway.
3. [Dragonstrike] No CD. Procrate feels like Mongoose/Executioner, so about 1 PPM.

[Madness of the Betrayer] What PPM does it have?
How do you do stuff like Tsunami/DST? Active every 45s?

 

landsoul

The only convincing argument based off of blizzard's design history is the 1.33 PPM or 1 proc per 45 seconds. It seems to follow the 15s/45s methodology, meaning 15 up 30 down every 45. I guess I can give that a shot.

Also I would love to know if haste, flurry, and speed affect PPM. Is PPm - > static weapon speed -> flat% chance indeed the rule? If that would be the case then 1.33 PPM would be too high for a MH.

Determining gem bonuses is possible, but requires way too much work right now to overcome someone's laziness. I am going for full functionality first before bells and whistles.

 

landsoul

MotB has 1.0 PPM

stuff with hidden CD uptime=
[buffduration] / ([cooldown]+[TimeToReapply])

tsunami
[TimeToReapply] = .1*[%crit] / ([MainHandWhiteHeroicWFInstperSec]+[OffHandWhiteWWperSec])

Dragonspine
[TimeToReapply] = 60sec / (1.0*([MainHandWhiteHeroicWFInstperSec]8MHspd+[OffHandWhiteWWperSec]*OHspd))

 

WernerVonBraun

There was a thread about that topic, maybe you'll find something in there:
http://elitistjerks.com/f40/t15553-p...chanics_haste/


I'm trying to collect all the things you need to know for a warrior sheet right now. Would be good to have an overview, so everyone could check and correct it.

 

landsoul

Rage per second Model

[top]0.01365*B3+21/8*(1-B31-B24+B21)*(1+H8)*(1+'Proc Data'.I10)*(1+0.25*H2)+E22*7/4*(1+B21-B24-B31)+1/3*'Talents and Raid'.F3+(20+'Talents and Raid'.F16*3)/60+3*'Talents and Raid'.F7*('Gear Display'.J83*H11+H14*'Gear Display'.J89)/60+(H15+H13)*B31*2*'Talents and Raid'.I10+'Proc Data'.I21

I'll break it down for you.
(7.5d / 274.7 + f * WepSpd) / 2


Unnormalized RPS
0.01365*B3
7.5 / 274.7 / 2

0.1365, then multiply by DPS of white and WF

Normalized RPS
21/8*(1-B31-B24+B21)*(1+H8)*(1+'Proc Data'.I10)*(1+0.25*H2)+E22*7/4*(1+B21-B24-B31)
f * WepSpd) / 2

MH f
7[%crit]+3.5[%hit or glance]
7[%crit]+3.5(1-[%crit]-[%miss]-[%dodge])
7[%crit]+3.5-3.5[%crit]-3.5[%miss]-3.5[%dodge]
3.5+3.5[%crit]-3.5[%miss]-3.5[%dodge]
3.5(1+[%crit]-[%miss]-[%dodge])

OH f
3.5[%crit]+1.75[%hit or glance]
3.5[%crit]+3.5(1-[%crit]-[%miss]-[%dodge])
3.5[%crit]+1.75-1.75[%crit]-1.75[%miss]-1.75[%dodge]
1.75+1.75[%crit]-1.75[%miss]-1.75[%dodge]
1.75(1+[%crit]-[%miss]-[%dodge])

WF f (see MH f)......

WepSpd / 2 * swings per second

WepSpdMH / 2 * ((1+.25[FlurryUp])(1+[Speed])(1+[Haste])/WepSpdMH)
+
WepSpdOH / 2 * ((1+.25[FlurryUp])(1+[Speed])(1+[Haste])/WepSpdOH)

= (1+.25[FlurryUp])(1+[Speed])(1+[Haste])/2 + ((1+.25[FlurryUp])(1+[Speed])(1+[Haste])/2


.....

(1+.25[FlurryUp])(1+[Speed])(1+[Haste])/2 * 3.5(1+[%crit]-[%miss]-[%dodge])
+
(1+.25[FlurryUp])(1+[Speed])(1+[Haste])/2 * 1.75(1+[%crit]-[%miss]-[%dodge])


= 21/8*(1+.25[FlurryUp])(1+[Speed])(1+[Haste])*(1+[%crit]-[%miss]-[%dodge]) + 7/4*[WFperSec](1+[%crit]-[%miss]-[%dodge])
again this is the normalized poriton

Other shit is unbridled wrath, 4T4 and ROTSK

 

xtreat

Thank you for your work on a excellent spreadsheet. One mistake though is Barrel-Blade LongRifle has 2 red gem slots and a 3 crit bonus.

 

landsoul

When I do -360 crit rating in the manual addition, SEp for crit jumps from .9 to 1.2, working as intended.

 

Machinator

Perhaps Im not following something but I dont see how that method accounts for crits or glances properly. I will look closer in a bit when I have time.

"Information is ammunition."

 

landsoul

glances do not affect normalized rage, only crits or landed hits.

 

Shha

I can say that , i tested DST as throughly as blacksmithing hammer. Ive NEVER seen it proc less then 25 sec after it faded. On other hand the proc rate is pretty insane , and in raids it comes uplike 1-3 seconds after the cooldown is over.
Isnt it just a semantic discussion though? Just say that dragonspine has 35 sec cooldown and you can use it as it worked from the moment the buff is applied. Its exactly the same for all purposes.

Anyway . if you have a trinket that procs every single time within like 25-28 seconds from fading, it makes it obvious for me that would the cooldown be shorter, it would have procced earlier over hundreds of procs i tested. But no, not a single time I had a proc under 25 sec from fading.

Dragonspine should be pretty easy to model too, given the huge proc rate/hidden cooldown, its very very reliable and over longer fights it stays really close to the teorethical 10/25+10 = 28.6%. In fact it often surpasses it slightly early on (because the proc sort of "comes first", so unless you look at uptime meter just as hidden cooldown is over, the proc time will be more then average).