Protecting Pandaria, a Prot Warrior Spreadsheet

[Absø]

Thx for this clairification, I'd add I engaged the fight with a shattering throw and take a 4000 strength pot, which isnt mentioned by the WoL.
The massive attack seem to do physical dmg, according to the WoL; so we could think the formulation is bugged for this kind of special attack and do a mix between magical and physical formulation like : unmitigateg dmg/3 like you say in the second point of your Option 1.

Dunno if its possible to solo absorb this attack in heroic mod, but it could be a very usefull help to not reach the enrage timer.

I hope I havent poluate your thread.

[Quietsch]

As I see it, it should count as magical (rather some kind of Bleed) as it's not reduced by armor (which you can easily see, as everyone takes exactly the same (expected) damage, priest/mage as well as paladin)(but still it's reduced by defstance), so at least in this point it displays the expected behavior.

[Airowird]

Numbers are updated for 5.2, enjoy!!

[Pacottaja]

I'm currently the most interested in the Dodge vs Parry values, so am i correct when reading this:

"Paper doll Parry/Dodge ratio: Ideal: 1.6345 Yours: 2.2318"

As in: I need to get more dodge instead of Parry? I'm quite positive this is the case but i just want to double check :P

In the Food Buff section there is no Stamina food option (probably because it doesnt really have anything to do with the DPS calculations)...

Otherwise everything is looking good. I'm assuming "Bonus Health" in the stats tab is or Taurens.

[Airowird]

* Yup, Higher means you have too much Parry (Although the actual value will probably be <5% lower than Dodge, so always go Mastery > avoidance imho)
* I'll look into the Stamina food buff this week, see if I haven't made a mistake somewhere
* Bonus Health is for trinkets etc that give straight up HP and not Stamina. You can also use it for Ancestral Vigor, where a Resto Shaman grants 10% of his healing done as HP, stacking up to 10% of your max HP and lasts 15s.

[Fetzie]

The two stamina foods are

http://www.wowhead.com/item=74656 - 450 stamina (expensive)
http://www.wowhead.com/item=74655 - 415 stamina (same amount as the Pandaren Banquet)

[Booi]

Lowish priority.

But you're listing the default stamina buff as 5%, it's actually 10%.
And the paper doll value of stamina now includes the unwavering sentinel and plate specialization multipliers, meaning that you could likely bounce those out of the stamina calculation.


EDIT:
also, after juggling some buffs around pretty certain one of your INT() functions should be a CEILING().
Stats Tab, Cell F8.

EDIT2:
The two pink cells on the Stats page are the modifications I made, seems pretty solid now (using the new paper doll accounts for racial differences)
https://docs.google.com/spreadsheet/...UE&usp=sharing