Thunders

Minor bugs for AC and Buffed Shield Block Value in Fitting Room.

The AC total given in the Fitting Room appears to be off slightly. The formula calculating it takes the bonuses from armor enchants into account.

Buffed SBV does not appear to add the bonus from Mark of the wild or Kings.

 

weirdaljr

Great post, didnt see executioner ranked... is it valid chant for a tank? Better then Mongoose?

 

• Jamor

I haven't done any testing, but I would assume it will be better for threat, where mongoose is more of a hybrid (adds some threat, but mostly adding to dodge) enchant.

 

Fellwraith

Mongoose proc:
240 AC
3.6% to crit
4.0% to dodge
2% haste

Executioner proc:
840 Armor piercing

A good chunk of our threat comes from innate threat on our attacks, not straight damage. You'd have to gain over 3.6% more damage from reduced mob AC to even consider it (not even factoring in the haste benefits). Best case scenario, executioner reduces an opponent from 840 AC (7.4% mitigation) to 0.

Taliafears, this is a nice tool. Do you have any plans to integrate the warrior TPS spreadsheet into this one? It'd be nice to have a comprehensive model that captures everything in one spot.

 

• Jamor

Well, crit doesn't do much for innate threat either. In any case, I plan on sticking with mongoose.

 

Allfury

Nice tool!
One small point, which gems should i socket instead of stamina in a specific slot, or does it not matter? Is it saying any gem is better than 12 stamina (of same rairty of course)?
Thanks

 

Ashlan

Great Tool!

btw:

Faceguard of the Endless Watch (Doomwalker) and
Topaz-Studded Battlegrips (Kazzak)

have wrong stats (pre-patch I think)

 

Taliafears

weirdaljr: I don't believe executioner would be considered a valid tanking enchant, even for threat purposes. I'll definitely keep my eye out for evidence to the contrary.

Fellwraith: I have indeed considered adding some information about threat here, though I hadn't really thought about lifting work from the TPS spreadsheet. It's a possibility.

Allfury: You can switch to the gems sheet and it will show you the stats of the best gem for each slot, and which gem is best regardless of color. Typically Enduring Talasite and Shifting Nightseye is the way to go in Yellow and Red slots, respectively, unless the socket bonus is underpowered - in which case you of course want to stack Solid Star of Elune.

Thanks for the reports, all issues mentioned are covered in the current version, which I'll upload in the morning.

 

Borodin

Text removed

 

Taliafears

New version uploaded.

-Parry rate back down to 5% for trash mobs, seems to be supported by the WWS I've checked
-AP in Unbuffed & Buffed Totals row should now reflect what's on the character sheet
-Unleashed Rage calculation improved again
-Trueshot Aura added to buff list
-AC calculations fixed - toughness no longer applies to enchants
-Buffed Block Value is now calculated correctly
-Gem sheet now shows the name of the best gem (typically Solid Star)
-updated stats for Kazzak/Doomwalker loot

 

Borodin

As always I've grabbed the latest version and had fun doing my gear again!

I've noticed that you assign a really high AEP to the weapons based around DPS and the optimal speed of 1.6 but can you tell me a bit more about how you came to this formula? Apolgies if you already did so.

3 Bugs / Questions / Minor things for next update

1. There's an odd extra bit to the Special formula for Mallet of the Tides (seems related to it's Expertise but not something added for The Brutalizer)

2. Enchant Cloak: Armour is giving only 109 AEP instead of 120 and Glove Reinforcements less than 240. Is the Toughness "fix" being applied twice here or did AEP assume 1AC from items was actually modified to 1.1AC in the first place?

3. Iron Shield Potions could use a Combo Box like the other buffs.

 

• Jamor

Enhance shaman might also main hand executioner as well, considering they share similar stat properties as warriors.

 

Taliafears

1) this was a carryover from when weapon skill rating used to... exist. Good catch.
2) it's the latter, I'm punishing enchants for being ineligible for toughness (if it's got points in it). This is a little weird but all my calculations have assumed Toughness, and since it's a holistic approach it's not necessarily mathematically sound to simply increase/decrease the value of armor by 10% globally. Bottom line, you should always calculate your stat weights with good assumptions about your talents/gear before putting them in this sheet.
3) fixed

About weapon dps and speed AEP values, they are totally intuitive - I don't yet have the mathematical tools to make a prediction, so for now those are just numbers that seem close...-ish. In reality all the threat values are basically intuitive, since you can't ever define how valuable threat is compared to survivability. I'd love to see a well laid out comparison of weapon dps to another threat stat though.. maybe AP?

 

Olon97

Precision and Weapon mastery would be nice as options on the talent tab for non-Prot OT's using the spreadsheet. (tactical mastery +MS/BT too if you start modelling threat more explicitly).

 

Xerophyte

A decent baseline for threat-vs-stamina would be following Blizzard's budgeting for the level-equivalent glove enchants and placing 15 agi = 2% threat = ~2% hit. With your current value for agi (17) that'd place 1 hit rating at 8 AEP and a threat enchant at 255 AEP. I think most warriors value threat slightly higher than this, but that might just be me projecting.

As for AP vs DPS, shouldn't be too difficult. A straight AP = DPS/14 applies for almost all attacks used by protection warriors, far as I know Devastate is the only effect (for protection, nota bene) that's normalised or only scales with either stat. If we assume a 1.6 speed weapon and 2 autoswings/devastate, which should be reasonably close to reality on bosses, we can account for normalisation and get a more accurate conversion of DPS = AP * 14 * (5 * 1.6) / (4*1.6 + 2.4) ≈ AP * 12.7

Edit: As for armour penetration and Executioner, the boss armour values thread gives a ballpark value of 6%ish extra damage for 840 ArP on a typical debuffed boss. Unsure what a reasonable uptime is for us but guesstimating 33% gets us 2% more damage for about 1.5% in additional threat over time: call it 200 AEP (+- 100 or so) as per the same threat-to-agi conversion as above. Not really worth the effort.

 

Taliafears

I actually started running some numbers comparing dps and speed to AP and came up with the same value, about 12-13 AP to a point of weapon dps. Also for speed I assumed a rage abundant scenario and figured out the threat from faster heroic strikes, then I modified it about 25% since faster weapons help evenly spread your rage/threat generation and avoid gaps where dps classes can pull aggro. The new numbers are in my copy of the sheet but don't change anything's position.

I still say there's no reasonable way to compare threat vs mitigation, I'm not particularly interested in re-using blizzard's appraisal, as they have more classes to consider than just warriors. I'm also wary of using agility since it's got so many functions.

I've found that in 2.3 I have no more problems at all with single target threat, with about 16 expertise and 50ish hit rating. If that changes I'll probably inch my threat stat weights up a bit higher. I don't have guildmates with >t4 gear either, so of course YMMV.

 

Gargantax

Love the spreadsheet.

Question though... the formula that calcs unbuffed and buffed health seem to have a 150hp difference in them even with all buffs turned off.

Specifically... G40*10+4264 vs. G41*10+4444

Where are these extra 150hps coming from?

 

Xanana

Nice work (and a lot of it)!

Was wondering why you did not include a couple of Trinks that I often use: The Commander's Badge (Netherwing Revered -- 45stam) and Romulo's Poison Vial?

 

Taliafears

Hey guys, sorry for the long delay between updates. I took a new job so it's been a little crazy lately.

I'm trying to get some more detailed stats together, so I created a new Stats sheet. I'm also trying to use those numbers to predict relative stat weights, so I'm generating time-to-live and crush-per-min and things like that. When I have some more time I really want to tackle threat-per-second, but it's not fleshed out yet at all.

I uploaded the latest version I have. I added the trinkets Xanana mentioned and the bug Gargantax pointed out is fixed.

 

Shinyuushi

Just a small thing with the spreadsheet - I noticed you set the crushing cell to 15%.

Can I suggest a slight modification of 15 + MIN(0,Normal Hit Cell), for those who have started to push crushings off the table.

 

Kurtov

The formula you have in C4 on the stats sheet is It should be since it's mitigation against a boss mob.

 

zuTee

cool work, here are some other stuff you might want to add;

Ring Enchants
Earthen Elixir
Elixir of Ironskin
Elixir of Mastery
Elixir of Brute Force

 

Edimus

Is there any way to add in our own items? I'd like to add all of the Season 3 items.

 

Taliafears

You can add your own items by inserting rows. You will need to "Fill Down" on columns B, W, Z, AA, and AB.

Also to get it to show up in the fitting room there's a variable name for each range of item types. To alter it in Open Office, go to Insert -> Names -> Define, find the variable in the list (e.g. "LegList" which is all the leg armor), highlight it, and change the data range (add 1 to the final number under "Assigned To").

Process is similar with Excel but I don't have it on hand at the moment so you'll just have to figure it out.

I have done quite a bit more work on getting threat calculated out and am pretty close to what I want. I'll get a new version of the sheet out soon (with a couple other bug fixes as well).

 

Sambuca

I am wondering where the 2.3 badges chest reward would fit in. Don't see it on the list