This is my simple Bear Mitigation Spreadsheet. It is based heavily on Fasc’s Bear Tank Spreadsheet, and also based on a lot of input from Toskk who co-wrote the Toskk Bear TTL Calculator with Dorkasaur, both of which are not actively maintained anymore. I’ve made my spreadsheet focus on determining Relative Stat Values for a particular character’s current gear setup. I’ve also made it more accessible by implementing it as a Google Docs Spreadsheet.

Usage Instructions:

  1. Visit the Bear Mitigation Spreadsheet at http://goo.gl/ln8VE.
  2. The values in the yellow box section show the Relative Stat Value normalized against Agility (aka Agility Equivalent Points) for my current tanking gear.
  3. Go to File -> Make a Copy, to make a copy of the spreadsheet into your own Google Docs account. Alternatively, download the spreadsheet in your preferred format.
  4. Make sure you have no buffs activated.
  5. Make sure you are in caster form.
  6. When obtaining the armor values, you will need to separate armor and bonus armor. Mouse over your armor and you should see something like “Armor 11358 (11108 +250)”, in which case enter 11108 as your armor, and 250 as your bonus armor.
  7. The spreadsheet reports three measures. Mitigation RSV should be used by Mitigation-stacking fanbois, Time To Live should be used by Stamina-stacking fanbois, DPS is for… well.. DPSing.
  8. The stuff in the purple section can be modified to suit your needs if you understand what they are about. You probably should not touch anything else unless you know what you are doing.

Some known issues with the model used by the spreadsheet. They are generally very minor and generally a lot more trouble than it is worth to fix them, and should have little impact on the RSVs calculated.

  1. The Savage Defense is based on an over-idealized model, in reality Savage Defense uptime should be ~0.2-0.5% lower. This one requires Monte Carlo simulations beyond the scope of a spreadsheet to fix, but I may in future fix it using linear analysis modeling.
  2. The vengeance decay model is slightly inaccurate for bosses with attack speed > 2.0s
  3. Does not take into account procs and cooldowns usage.
  4. DPS model assumes fixed 18s rotation that doesn’t consider miss/parry/block, 100% Pulverize uptime, no Berserk procs and infinite rage.

Please try it out and let me know what you think, thanks!

22 Comments

  • Gameldar says:

    I’ve been playing around with the spreadsheet and in general get the idea – however I’m not sure exactly how to apply it in a practical sense when comparing gear.

    I guess what I’m trying to do is compare one item with another too see if it is an upgrade – when one of the items is what I’m currently equipping. Because the item is equipped it will be affecting the relative stat values. For example at present I’m comparing the Treads of Fleeting Joy with Fasc’s Preserved Boots (since I got lucky and got the appropriate random boss and they dropped on my first ZG run). From a rough comparison (i.e. what I was RatingBuster was giving) I was looking at 0.8 mastery from Fasc’s versus 0.7% dodge from the Treads.

    Now if I go to the spreadsheet and plug in my current gear (i.e. Treads equipped) the lack of mastery would end up placing a higher value on mastery than dodge (relatively). So what I’ve actually done is remove the value of the item I have equipped and used the RSV to compare the items. The other question there – is can I use the RSVs as a multiplier and then add up the totals to give the item an overall score (that is my understanding of how they can be used).

    Is this the way the spreadsheet should be used? It is more or less what Rhidach has done with his Combat Table Coverage spreadsheet (http://rhida.ch/2011/03/18/ctc-calculation-spreadsheet-for-gear/) for Paladin’s (although that calculation is a lot simpler because you are dealing with static values – rather than being dependent on up-times of SD etc).

    I guess one of the reasons I’m question my understanding of it is Reesi’s comments on 4.1 survival guide about Fasc’s versus the Storm Rider boots. Looking at my gear at least Treads is actually ahead on both Mitigation and TTL calculations against Fasc’s with Storm Rider’s even further ahead on Mitigation (but behind on TTL but I’ve gemmed for more stamina meeting the socket requirements on the Treads). I guess the other part is knowing how significant a difference I’m seeing – because they’re basically all within 2% of the average value of each other (e.g. Mitigation totals values are Fasc’s=1223 Treads=1232 Storm Riders=1247).

    Having worked this through as I write it, I guess I’m coming to the conclusion that the difference is pretty minor, particularly when I’m not worried about TTL and therefore the increase TPS from Fasc’s is looking rather attractive. But it would be useful to know I’m actually using the spreadsheet correctly!

    Thanks!

  • Tangedyn says:

    Using the RSVs to sum up the value of an item works well.
    It would be more accurate to enter in your full stats with the two different items before comparing the “Mitigation Value” in Cell B62 (subject to change if the spreadsheet updates!), but the results won’t be too far off.

  • Alteena says:

    When I click that link and open the spreadsheet up, it says Read Only at the top. When I go to File > “Make a Copy” is grayed out?

  • Tired says:

    Row 16 says “dodge rating”, but I think you’re using a dodge percentage there.

    You might want to give some basic instructions for newbs like us who haven’t used a spreadsheet for WoW before. Like “replace the numbers in green with the ones from your character window”. (And maybe some hints on what we’re supposed to do with lines 38-105; they seem to be the same in every column, but I don’t even know what I’m looking for at this point. Are the “m/CY/SW” abbreviations explained anywhere?)

    • Tangedyn says:

      No 35 is my actual dodge rating because i’m using a bearcat reforging strategy. Rows 38 to 105 are internal calculattion steps used by the spreadsheet, you probably don’t need to know too mucj about them unless you are interested in the theorycraft details and formulas. The stuff you shuld be interested in are in the yellow cells. The values in them are the stat values in agilty equivalent points.

  • Kappamus says:

    Hello,

    The dodge rating on the spreadsheet is 35. Is this value in terms of a percentage? I’m a bit confused as it appears the other values like expertise and crit rating are all actual rating values.

    Thanks for the spreadsheet. It must have taken a great deal of work and its much appreciated.

  • MrT says:

    If I have stacking agility trinkets and Kiril-staff which values should I enter in agility box?

    • Tangedyn says:

      Based on Kiril proccing approximately every 60 seconds, you should take the max agility bonus divided by 4, and add that your agility. E.g. for Normal Kiril, 1070 is the max bonus, so divide by 4 = 267.5

  • Krazyito says:

    I’m sorry, but I have been trying to figure it out by reading this whole page but can’t seem to figure out what I am suppose to do with these values once I have them.

    Any help?

    • Tangedyn says:

      Generally the spreadsheet is used to answer questions regarding the relative value of various stats. Once you’ve entered your profile, the stat values will appear in the yellow boxes, so Mastery having an AEP value of say 0.4 will mean 1 Mastery is approximately equivalent in value to 1 Agility. You can use these values to make gearing reforging and gemming decisions.

  • PJ says:

    Hi Tangedyn,

    I was wondering if you are planning a new sheet for MoP? I’m not in the beta, but the reports I’ve read seem to suggest a fundamental change in bear tanks desired stats, with stamina possibly becoming better than agility due to all the % based self healing and the lack of an attack power component to SD, haste and crit becoming awesome for rage generation for SD & FR uptime, expertise almost irrelevant due to rage generation on blocked & parried hits, and mastery likely a poor stat until later armour tiers where a multiplier means a much larger armour gain. Make me a happy bear and tell me you’ll do all the math for me so I can plug in the numbers and just base my decisions on my own playstyle :)

  • PJ says:

    Nevermind, just found a link to your MoP one :D

  • Wigur says:

    Hey everybody,

    from what I read about bear, correct usage of pulverize was said to be essential.

    Now, when playing with this spreadsheet I toggled pulverize uptime from 0 to 1 and saw an increase of equivalent health of only 3% and a dps increase of ~5%.

    This is far less than I imagined the effect to be. From this result I would guess pulverize can be neglected at almost any encounters. Only at cutting edge bosses or when dps is important even for the tank it may make sense to use pulverize at all.

    Did I get something wrong?

    • Tangedyn says:

      What else are you going to put the talent point in, that gives more than 3% EH and 5% damage?

    • Wigur says:

      Yes, but it’s not only that one point, it’s also quite a complex mechanic behind it.

      My main is blood DK and good usage of death strike has a much higher impact. I was under the impression that the pulverize mechanic might be almost as important as DS for blood, but from this result I guess it’s not.

      If you use DS on CD simply you are quite a bad DK, but if you don’t use pulverize I guess almost no healer would notice.

    • Tangedyn says:

      There is simply no justification not to take Pulverize and use it as long as you are tanking. It’s not like you are giving up doing something important to use Pulverize.

  • Sandizzie says:

    Hey there. Just looking at the spreadsheet, I was wondering if you had a list of “stat weights” that comprehensively that included all aspects of tanking combining survivability and threat generation. I am just getting into bear tanking at 85 and just want to know a base for which gear is better without specializing in “time to live” or “mitigation” specifically. Thank you so much ahead of time.

    • Tangedyn says:

      I’m afraid that would be highly subjective, so it won’t be a good idea.
      Just go with straight mitigation. It’s already proven that you can ignore TTL and threat and do well.

      Unless of course you want to do bearcat, but that’s in a separate guide.

Leave a Reply

Your email address will not be published. Required fields are marked *