DPS Craft: Warriors/Knights

[Ezmode]

Odd, I just gave it a shot and it seems to work fine, even switched to Guardian and Sentinel. Could you perhaps be using an older version? Whatever the case, would you mind PMing me the formulas in the Rating Tab (Right click any tab in the bottom left corner, select unhide, select Rating, hit OK), just for Cell X8.

I will update the rotation names. Oversight on my part.

[Veneilas]

hey this pretty cool, sorry if im just adding to the pile but here are some quick things i noticed:

-Greaves/legs swapped
-Can't find my legs ;x (columi vindicator jug)
-maybe a way to sort out in class whether you are a dps jug or tank jug etc and then sort out items that way

the biggest thing i noticed was not taking into account for stims and adrenals.

great work so far though!

[Skeleton Jack]

Ezmode, I'm working on a Priority System for Annihilation using your spread sheet. I've had some trouble so far getting the stats to match up properly, especially Surge for some reason... This is the preliminary short version without the examples to explain, but this is essentially T2 gear and weapons with a smattering of T3 worked in (my current in game gear). I've also already calculated the Empowerment probabilities, but I'm running into an issue with how to consider a value of ZERO rage cost. Such as when using Assault and Deadly Saber on the same GCD with an empowerment proc. Any ideas how to denote that?

Damage per GCD Priority (not DPR)

1. (3)Smash - 3966 dmg (3966 dpr) vs 3 targets
2. (4)Sweeping Slash - 3168 dmg (3168 dpr) vs 4 targets
3. Rupture - 2646, 2756, 2866 dmg (*4-6 ticks of Berserk)
4. (2)Smash - 2644 dmg (2644 dpr) vs 2 targets
5. Annihilate - 2561 dmg (640 dpr)
6. Rupture - 2426, 2536 dmg (*2-3 ticks of Berserk)
7. (3)Sweeping Slash - 2376 dmg (2376 dpr) vs 3 targets
8. Deadly Saber + Assault = 2347 dmg (*3 ticks of Berserk) (2347 dpr w/o empowerment) (1gcd, costs 1 rage)
9. Rupture - 2316 dmg (*1 tick of Berserk)
10. Vicious Throw - 2298 dmg (2298 dpr)
11. Rupture - 2206 dmg (2076 dpr)
12. Deadly Saber + Assault = 2188 dmg (*2 ticks of Berserk) (2188 dpr w/o empowerment) (1gcd, costs 1 rage)
13. Deadly Saber + Assault = 2030 dmg (*1 tick of Berserk) (2030 dpr w/o empowerment) (1gcd, costs 1 rage)
14. Ravage - 4003 dmg (2002 d/gcd)
15. Clipped Rupture - 1944 dmg (*5 ticks of the dot) (1780 dpr)
16. Deadly Saber + Assault = 1871 dmg (1871 d/gcd) (1871 dpr w/o empowerment) (1gcd, costs 1 rage)
17. Clipped Rupture - 1682 dmg (*4 ticks of the dot) (1480 dpr)
18. (2 gcd's)Annihilate + Assault = 3353 dmg (1677 d/gcd) (1677 dpr) (2 gcd's, costs 2 rage)
19. (2)Sweeping Slash - 1584 dmg (1584 dpr) vs 2 targets
20. Deadly Saber - 1555 dmg (*3 ticks of Berserk) (689 dpr) (no gcd)
21. Vicious Slash - 1519 dmg (759 dpr)
22. Clipped Rupture - 1420 dmg (*3 ticks of the dot) (1177 dpr)
23. Deadly Saber - 1396 dmg (*2 ticks of Berserk) (619 dpr) (no gcd)
24. Smash - 1322 dmg (1322 dpr)
25. (3 gcd's)Vicious Slash x2 + Assault = 3830 (1276 d/gcd) (1915 dpr) (3 gcd's, costs 2 rage)
26. Deadly Saber - 1238 dmg (*1 tick of Berserk) (549 dpr) (no gcd)
27. Clipped Rupture - 1158 dmg (*2 ticks of the dot) (875 dpr)
28. Deadly Saber - 1079 dmg (478 dpr) (no gcd)
29. Clipped Rupture - 896 dmg (*1 tick of the dot) (583 dpr)
30. Sweeping Slash - 792 dmg (792 dpr)
31. Assault - 792 dmg (+2)
32. Force Charge - 732 dmg (+3)
33. Battering Assault - 433 dmg (+6)
    

I manually edited out shields/absorption like you told me how to do. But in order for me to do some real work on Carnage/Combat I need a field that tells me how much damage the abilities will do with the Gore (Armor Pen) in effect.

I tried editing in that info you posted for the Deadly Saber crit chance, but it gave me an error. I ended up manually changing it to the proper % however as a short term fix.

If you're going to go back to the DPR stuff some method of easy editing might be a consideration. For example, Vicious Throw is a 1 Rage ability talented with 2 Piece Set Bonus.

Also I manually deleted the bleed and upfront damage for Rupture to figure out their total adjusted average, but separating the bleed and upfront damage would be helpful in the future for calculating changes based off of Berserk being active since Berserk will not affect the upfront portion.

Also does the spread sheet take into account the bugged +30% bleed dmg situation?

Lastly, the debuff Sunder Sources, could you explain that to me again as far as how you put it into the spread sheet?

Thanks for all the work man, this is giving me tons of stuff to work on!

[Ezmode]

Procs make modeling so much harder, without a sim there really isn't a way to account for Empowerment. I haven't put up the new version yet as I am working on rotation numbers for the DPS specs at the moment, but I have added a line for unmitigated damage, so that should be enough to show you raw damage for all abilities (Gore problem solved).

I haven't started putting in set bonuses yet. I do plan on getting to that very soon. Quite possibly after I finish the priority/rotation numbers.

I'll look at the formula for DS again and make sure. It might have been off because I must have added/removed rows in the meantime. Sorry. Berserk is affecting both Rupture DD and DoT? I'll have to fix that, thanks.

I am currently not accounting for any bugs, just numbers as they are intended. Would it be better to show the bugged calculations rather than intended?

Sunder sources basically means: Number of players that are capable of putting up a 20% Arp debuff on the target. So if you have 1 Jugg and 1 Merc, pick 2.

Since you are working on the Carnage, could I piggyback off your efforts so it saves me some time/effort? I'd like to send you a copy of what I have so far, after cleaning up the useless notes, so you can work out the Carnage rotation.

---

(01-27-2012 07:15 PM)Veneilas Wrote:  hey this pretty cool, sorry if im just adding to the pile but here are some quick things i noticed:

-Greaves/legs swapped
-Can't find my legs ;x (columi vindicator jug)
-maybe a way to sort out in class whether you are a dps jug or tank jug etc and then sort out items that way

the biggest thing i noticed was not taking into account for stims and adrenals.

great work so far though!

Gear lists were screwed up in the last version after running the EP Calc. Named ranged ended up being larger than intended and covered legs and feet for heavy armor. Sorting by DPS/Tank gear separately is too much extra work, at the moment you can sort via the EP Calc, if you choose Sort by: EH instead of DPS. Problem is when the legs/feet gear get jumbled.

[Skeleton Jack]

For Empowerment I simply calculated the probability of it occurring for each ability, and then the final damage numbers modified by full cost or full cost -1. Thats where the dpr numbers I am using are coming from. That method is fine for a base line comparison I feel because sitting down to calculate the probabilities of Empowerment occurring when both DS and Rup overlap is just something that's going to make my brain explode. If someone makes a sim then it would be best addressed there.

The unmitigated dmg column sounds awesome! Makes it easier than changing stuff every time.

When I mention Berserk for Rupture what I mean is this. I figured out the DPR of Rupture accounting for Empowerment per normal and then also with 1-6 ticks of Berserk being active, and then again when clipping Rupture. But it required some extra effort on my part to separate the upfront damage from the bleed damage in order to work all of that out. If you could have a field that shows *JUST* the total adjusted upfront damage and then a 2nd one for *JUST* the bleed damage, it makes calculating all of the variables so much easier.

With that said, I was assuming the Rupture and Deadly Saber numbers were just accounting for stats, crit, etc... You don't have some kind of Berserk modifier in there do you? Please tell you don't... Really need the numbers without Berserk.

As far as bugs, I think going with how it's supposed to work is best unless it ends up being a long term bug that doesn't get fixed. I'm not really 100% sure what the best call is, but it's good to know how it's being handled.

Yeah I can help you on the Carnage thing, but I'm not working on it until I finish everything for Annihilation first. That list was just a quick excerpt from the article I'm working on for Force Junkies. After Carnage I'm going to do Rage. Right now I'm still having issues with how to figure out 0 rage dmg...might have to shelf it as math isn't my area of expertise. I know there is a way to represent the value by multiplying all values by a set number...or something like that...but it's been so long since I took a math class I can't remember how that is done.

So the big issue I have to delve into now is calculating the effective damage per GCD of Annihilation and Vicious Slash after accounting for the probability of Rupture refreshing. If you've already done that, or have any good ideas I'm all ears. Still working out where to start on that one, especially due to An and VS probabilities combining... I'm thinking to instead determine the probability for just one of each, and ignoring ongoing probabilities, and calculating potential average dps gained by an early Rupture refresh. It's not as good of an answer, but it's subjective enough to at least indicate the priority placement.

[Ezmode]

Berserk is being accounted for, if you want to turn that off, on the Character sheet, under Buffs you can set Berserk to 0. I can put split the rows so they show average/adj. average for DD and Dots, I'll put that in later tonight while working on the Anni numbers.

I like your approach to the An/VS refreshing Rupture. I was talking to Rolfson last night, we determined that clipping Rupture really isn't a big deal, since the DoT lasts 6 seconds, and the minimum time to reapply Rupture is 3 seconds, 2GCDs (0 Rupture, 1.5 Ann/VS [refresh], 3.0 Rupture) and you can get at least 2, if not 3 ticks in depending on latency/reaction time if you are using ability queue or not. Still more damage done than from missing DoT ticks, though it depends on how much mitigation we are up against as well. Speaking of which, mitigation really needs to be confirmed. Rolfson said he'd look into it for me.

[Skeleton Jack]

(01-29-2012 10:09 AM)Ezmode Wrote:  Berserk is being accounted for...

/sob So much crap I gotta redo now, fml.

As to clipping, my Rupture numbers are inflated now it seems...but even with that at only 3 ticks Vicious Slash will do more dmg per GCD than a 3 tick Rupture, so it is still important to know where that cutoff happens to then adjust by the damage per rage if need be.

[Ezmode]

The inflation shouldn't be too high. For Rupture it is 20% uptime * 2/6 and DS is 20% uptime * 4/6 increased crit chance. Over all its only a 100, 150 damage unmitigated, with 1900 str, respectively.

[Ezmode]

v1.2.0 posted, changes in OP.

Additional note:
Annihilation is based on average expected ability uses depending on their cooldown, Rupture uses were calculated using weighted Annihilate and Vicious Slash uses.
Carnage follows a strict rotation where Ravage and Force Scream are used only during Gore, so it looks like:
http://www.mediafire.com/?nu3z9t7x5vozycx (First 100 seconds of combat)
BA - Mass - Gore - FS - Ravage - Rage builders + Mass - BA - Mass - Gore - FS - Mass - Mass - Rage builders + Mass - BA repeat.
May need changes/improvements.

Tanking rotation may need some work.
Shared tree rotations will be updated in the following versions.


Edit:

Apparently the vlookup formulas in B40:W53 weren't updated when I made a last minute change. And I will be making more changes on Carnage's rotation based on what LagunaD has done in http://sithwarrior.com/forums/Thread-Car...et-online.

[Ezmode]

v1.2.1 posted, changes in OP.

Please note, among other changes:
Added simple Stat input: Select "Gear" in cells (B37:B38) to calculate based on Gear+Mods selected (you can still add extra stats if you select "Gear"), "Input" for manually inputted values in Rows 37:38. You will still have to select Gear+Weapons (no need for mods) for Armor and Weapon damage to be calculated.

I will be spending time attempting to learn fancier math to try and make the spreadsheet more accurate and valid. In the meantime, I would greatly appreciate it if anyone could shed any light in any direction for improvements.