Greetings, I have been spending the last few days in making an as complete as possible threat calculator for paladins, it will accept all your stats, and calculate your threat out of it. Now, I would like to post it here so it is possible for other people to use it, and correct it (as I'm sure plenty of calculations errors have slipped in).

Out of my calculations I have also discovered the following. Even though most of this is largely known, here it is again (if they are correct)
- Seal of Vengeance outperforms all other seals for tanking as soon as it is stacked up and if it does not fall off (slow weapon needed) but due to better scaling of SoR it will outperform SoV at some point high spelldamage (which depends on current buffs)
- Seal of Blood is the worst tanking seal
- Judgement of Vengeance is the most efficient source of threat followed by holy shield
- A significant amount of our threat comes from power gains (are those included into KTM/Omen ?)

The file can be downloaded here: http://cncfanatic.free.fr/Palathreat.xls

NB: I'm planning to do more calculations regarding what talents give more threat then others on average and how much TPS one spelldmg adds, but I first want to be sure my calculations are correct.
NB 2: I hope it is ok for me to make a new thread about this, I think this doesn't completely suit in the Paladin MTing viability thread.

edit: I'd need information on how glancing blows work to include them into the sheet.

Considering they let the warrior TPS thread exist, I'd imagine you're safe.

Definitely going to get this when I get home, this should make a paladin friend of mine very happy. Thanks for putting in the effort.

Oh, and I think Omen counts power gains...I think KTM only tracks a few of them, though, like rage (from Bloodrage, if I recall correctly).

It's a narrow but important topic so of course it's a valid thread.

This is something I've noticed for a long time now. There's a very widespread belief amongst tanking Paladins that we somehow have some magical higher amount of threat. Unfortunately, this leads to players believing that 200 Spell Damage is all that will ever be necessary and gearing themselves in avoidance gear with really poor threat generation.

Playing alongside 2 crazy Prot Warriors who obsess about their TPS constantly, I get to see the brunt of this first hand.

It would be great to add spell damage to this. It's always been my "feeling" that 1 spell damage = 1 TPS (based on the coefficients to consec, sor/jor, and holy shield), but it would be good to see it math'ed.

I want 100% confirmation that my maths are correct first
It'd be a waste to calculate it and then find out my maths are wrong :p

I had stupidly forgotten it as I have 0 parry rating myself, fixed

Perfect, thanks so much for sharing this tool.

I have been chatting today with my friend who has a shadowpriest, and trying to figure out how much mana his Vampiric Touch would return in addition to the incoming healing. It really is only significant for the 'seconds before OOM' field on your sheet as far as I can tell.

I think it might be a bit out of scope for your spreadsheet, though (you would need to know the dps of the shadowpriest to figure it out) - but it is something to consider.

It might be worth spending a bit more time on the talents/ratings/etc. that you do not have if you want to make this something other pallies can use 'out of the box.'

The precision talent is another case of this: you have a spot for it on your talent sheet but I cannot find a reference to it in your 'melee chance to miss' calculation. A simple fix I think!

I am really quite thrilled with this sheet, and I hope my comments come across as constructive.

The sheet being so huge, its hard to control if everything is correct on my own. Fixed now

I hate to be nitpicky, but blanket statements about Paladin's not outperforming warriors on threat aren't appreciated. Either explain how you came to this conclusion or remove it. There is no magical TPS value for the Warrior class so making a blanket statement is very one sided and feeds people that will read your summary and completely ignore the mechanics.

I would greatly appreciate however, a table of TPS calculated from the warrior chart vs TPS calculated from your chart. This would allow people to gauge their spelldamage stats and see if they need to boost it up to compete with a well played and geared Prot Warrior.

Again I don't mind your comment, but I think a lot of people are going to misread it as a class difference rather than the real issue, which is a difference in gear and stat focus.

I think what he's getting is that, while that may be true for your Paladin, it isn't true for everybody's Paladins. Using your sheet I calculated that once I finish my Tier 5 suit I'll be sitting at a healthy 1050 TPS on non-undead targets, without any consumables or special buffs (like Wrath of Air, or Wizard Oil).

Also, for a bug report: if you set Exorcism to Rank 0 it still contributes some minute amount of threat to your final total. Seems a bit odd.

Hmmmm, that might indeed be the case, I'll remove the comment then (and fix Exorcism, damn bugs )

edit: when I open the xls, I get a macro warning,why's that (I didn't include any macro's in my sheet)?

edit 2: Fixed the rank 0 error for all spells, the problem was that the base damage was set to 0, but they would still scale with spelldamage, silly really .

That's not terribly far off from what I see from our highest-threat prot warriors. They tend to run in the neighborhood of 900-1000 TPS and we're still moving into the T5 content so they've got some upgrade room ahead of them.

Would be nice to know if that is with or without windfury, as , from the limited warrior knowledge I have. It seems that windfury totem is a huge threat upgrade for warriors (even better then wrath of air for paladins)

That's without windfury. I watched KTM today in SSC and the one prot warrior we had was hitting 1100-1200 with windfury.

Your formula for melee hit % (cell B95) is incorrectly duplicating the spell hit % formula. You'll want to update it to be something along the lines of "=(5+((B3-B2)*5*0.24))%" (5% base miss plus 0.24% per difference in weapon skill versus defense rating). Likewise, the formula for weapon skill (cell D95) should be updated to "=-D92*0.24%" which uses the correct weapon skill rating adjustment against a mob instead of the 0.04% against a player.

Your seal selection cell (D11) requires "Righteouss" to correctly calculate Righteousness on the threat sheet. You'll need to either update your formulas (preferable) or change the tool tip for the title cell.

If you're looking to calculate the point at which Vengeance and Righteousness intersect there was some theorycraft done in another thread here - Paladin: Seal Mechanics. Several of the variables mentioned in that thread such as initial and subsequent SoV +dmg application and SoR weapon buff procs are no longer relevant but it's a good place to start.

I only checked a few times, all of them on trash. I'll try to get a better look over the next few days.

Those have been fixed, wouldn't that make weapon skill a bit more appealing, 2.40% chance to hit and 0.5% chance to crit aint that bad if you have points to spare (unfortunatly, in the prot's tree current state, you do not )

Also I don't know the period over which KTM calculates threat. But I know it's rather short. I've seen KTM report 1300 TPS and then have the tank drop to 500 TPS a couple of seconds later because during the first half he's gotten a shield slam crit with a heroic strike hit and had lifebloom, PoM, and Earthshield go off, then got a string of misses later.

If you're glancing at KTM and just noticing the big numbers it's going to be way off. The only realistic way of seeing threat is to take threat generated divided by fight time, rather than the TPS over last 5 seconds or whatever KTM does.

As a paladin I spike threat much less than a warrior, but when able to go all out on trash (IE: able to use consecration) I can outpace them quickly. That is to say, KTM rates me much higher than them, but the TPS number is not necessarily higher, as my threat is very constant. Same amount of DPS from consecration every second, same amount from reflective damage, every SoR hit is the same amount of damage, judgements are on a fairly long CD.

The more gear I get the more I realize that threat is really my greatest asset. I went from despising the tiered sets for "wasting" itemization on spell damage, to really appreciating it. I have to go back to being bitter about the base hit point difference and the lack of a 40 stamina item for the ranged slot. It will be pretty soon that I don't have to consider crush immunity at all, (at the moment I still have to at least consider it, though not greatly) and I'm running at 347 spell damage. With the cheapness of flasks now, on any threat sensitive fight I'm using flask+basilisk+wizard oil, which puts me at 480 spell damage. I'm still working on my gear a lot, but even with ~500 spell damage I'm seeing huge gains in my threat generation, while I've noticed our warriors stay fairly static.

I can't work out what you're trying to do with your calculation for "Actual Hit" (cell D146), but the percentage you're not taking a hit of any kind should be one minus the sum of your dodge, parry and opponent's miss values. Currently you're including block in there which is then cascading down into the "Total Chance to take Damage" (cell D147) value and being counted twice which is incorrect because a) a block still means you're hit and taking damage, and b) it's being counted twice. I would suggest you rename "Actual hit" to "Actual chance not to be hit" (similar to B143) purely for informational purposes as the sum of miss, parry, dodge, then change "Total chance to take dmg" equal to 100% minus that value. This will give you a correct value for "Average time between dmg taken" (B78) on the Threat sheet which is the only place that cell value is referenced.

Also,

• There are several formulas still referencing the old "Righteouss" value, you can do a global replace to fix them.
• Shield Specialisation is listed twice on the Talents page.
• The formula for Judgement of Righteousness does not take into account spell crit value (the other two judgement formulas do include it, however).

Ok, It has all been fixed, unfortunatly, I'm currently at work and cannot upload my file at the moment (could someone upload it for me if I send it to him by mail please ? )