View Full Version : Protection TPS Spreadsheet

04-19-2008, 04:36 AM
Hey Guys!

Out of a quick Idea, i've put together a TPS Spreadsheet, which i would like to share with you.

First of all, i'd like to introduce myself: I'm a german WoW Player (might notice due to my english skills :> ) and i'm playing a male draenei protection warrior called Nebulo (http://www.armory-light.com/eu/Blackrock/Nebulo/) on Blackrock-EU since BC. Before, i played Rogue since korean open beta.

Now let me tell you, what my Spreadsheet does:

Based on your stats, it calculates your personal TPS, using a perfect rotation with or without spamming heroic strike. It can also compute the value of stat upgrades, based on your current stats (i.e. how much more TPS do you gain by stacking 2 more Expertise Skill, while already having 20 Expertise).

At the moment, there a few things, it doesnt count in:

I assume a perfect Rotation. No rage generation issues are involved. This Spreadsheet also does not count in any effects through weapon procs, nor windfury, healing aggro (i.e. earth shield,...). These are likely to be added in future.

Some Explainations:

My Spreadsheet is done by using OpenOffice 2.4. This is a free Office Suite, which can be downloaded here (http://www.openoffice.org/). I did no testing with MS Office due to the fact that i won't purchase it.

I've used several colors: dark grey fields need to be filled out by yourself, i.e. stats, talents, mob stats. Blue-gray fields are used to show the most important results. Last but not least there are 2 red boxes that show your final TPS.

For now, i would just like you to test my TPS Spreadsheet and give me some feedback (via this thread or here (http://smy.liebesbude.de)), so i'll may improve it.

Download: Click here (http://nares.na.funpic.de/pics/ProtectionThreatv0.5.ods)


04-19-2008, 04:56 AM
Looks quite good, though the hit section need clarifying tbh it confuses me, is it the % extra that the tooltip shows? or a different hit value.



04-19-2008, 05:18 AM
Expertise (and tps gained from expertise) remains capped at 23 regardless of what you set boss parry to. Also, is the block value inputed by the user before or after shield mastery is accounted for?

04-19-2008, 05:39 AM
@Silthias: Hit section means your overall hit chance, i.e. as a draenei i get lets say 5% hit from items (shown in the character tab) + 1% hit racial bonus (not shown) -> 6 % alltogether.

@Dygrav: You're right, the Expertise cap doesn't scale as its just the "Soft Cap", i'll need to clarify this. But the TPS calculated scales well with Mob parry and you will gain TPS by stacking Expertise >23, when Mob parry is higher than 5,6%. Block Value is meant without Shield Mastery, its added via Formulas.

04-19-2008, 05:52 AM
It seems parry is being left out of the threat calculation somehow on your spreadsheet also. After setting mob parry rate to every whole number between 1 and 100 no change was made in threat per second. (This was with hit and expertise set to their caps)

04-19-2008, 05:58 AM
@Dygrav: i can't reproduce your error. With hit set to 9% an Expertise to 23, an increase in Mob Parry decreases your TPS as it should be. Maybe you would fill out your Spreadsheet and host it, so i can take it a look at it.

04-19-2008, 06:04 AM
Okay, everytime I hit enter while in that box my computer inserts a % symbol which skews the entire calculation. Never mind that part.

04-22-2008, 11:56 AM
Might I suggest you add an option to designate if your weapon is a dagger or not. The reason for this is, daggers have an attack power modifier of 1.7 on Devastate bonus damage, and swords/maces/axes have a modifier of 2.4.

Not many people use daggers, but based on a spreadsheet I made a little while back, my calculations show that a dagger is still a good thing to consider for non-orc and non-human tanks, especially if you're still using an old sword (i.e., Retainer's Blade when you're currently wielding Grom'tor's Charge as an interim while you wait for the Sun Eater or King's Defender).

Edit to add: you're also not considering glancing blows, it appears. White damage can glance for a 30% damage reduction, which may skew results slightly when comparing, for example, the threat from a 100dps 2.4spd weapon versus an 87dps 1.6spd weapon. The chance of a glancing blow appears to be: 10 + mob defense - player weapon skill, weapon skill being capped at 5 * level. For a level 73 mob, that's a 25% chance of glancing blow. A level 72's chance is 20%, 71 is 15%, and 70 is 10% (from wowwiki, not the best source but it was the first thing Google brought up)

04-23-2008, 09:01 AM
Nice spreadsheet!
Any chance to add threat scaling with respect to attack power?

04-24-2008, 02:40 PM
I'm a little busy with some studies, but i'll check for some improvements.

Edit: btw. glancing blows are properly included.

04-25-2008, 07:46 AM
When I put my stats in and then add execuitioner proc vs mongoose proc I get nearly exactly the same threat increase.
From what I've read they have the same proc rate.
So who are wrong, the people who say executioner gives a much higher threat increase, or this spreadsheet?

04-25-2008, 10:37 AM
Hey Guys!

Based on the feedback i received, i completely reworked my spreadsheet and made it cleaner and easier to use.

I added a lot of comments, just place your mouse over one of the fields with a red dot in the upper right corner and a tooltip will tell you (hopefully) useful things :)

Download: here (http://nares.na.funpic.de/pics/ProtectionThreatv0.5.ods)


Regarding executioner vs. mongoose, i haven't calculated it myself yet, but keep in mind that the armor pen from executioner will scale with SA and any other armor pen on your items very well, whereas the haste from mongoose doesn't scale that well with your equipment.