**Important Please Read**
There are a few circular formulas within the spreadsheet because of this it is possible that you will load the spread sheet and get a few N/A's in the sheet. If this is the case toggling the red cell on the mitigation sheet should fix it.
If this does not work, make sure Enable Iterative Calculations is checked in Excel Options/Formulas.
The Excel 2007 version has a fully functional talent tree that's plugged into the equations.
Stats based on talents, buffs, gear and race.
Works Just like the websites, left click to add points, right click to subtract. Even has tooltips.
Choose your gear.
TPS calculator that suggest the highest TPS rotation for your spec.
The Work Sheet isn't locked so feel free to modify it for your uses. If you find any bugs/mistakes please feel free to comment on them.
Known Bug List:
Unholy Blight can be negative values in excel 2007.
Well, I've got a little question that i can't get from anywhere.. How many Def, Dodge, Parry i need to tank at lvl 80? I mean, def should be the same that for a warrior, but they've got Block, so, i can't get the numbers.. any help?
As it's not been asked in this thread yet:
Fallen Crusader doesn't seem to have any uptime calculations currently, the spreadsheet just mulitplies your strength by 1.3 if there's Fallen Crusader on one of your weapons. Are you planning to model Fallen Crusader properly for each hand? (Does it stack by the way? Never tested DW on the Beta server)
As it's not been asked in this thread yet:
Fallen Crusader doesn't seem to have any uptime calculations currently, the spreadsheet just mulitplies your strength by 1.3 if there's Fallen Crusader on one of your weapons. Are you planning to model Fallen Crusader properly for each hand? (Does it stack by the way? Never tested DW on the Beta server)
Crusader mainhand should have something like 3ppm after specials are factored in so something like a 50-60% uptime, still way worse in terms of survivability than 2% parry, and due to the parry from strength being affected by diminishing returns, and the 2% not I doubt it even scales better. Obviously you would never go MH 2% OH Crusader like the spreadsheet indicates, your uptime would be horribly low. I doubt the tps benefit you gain would be worth it unless you horribly out gear the instance you are doing and are just looking to maximize your tanking dps.
As it's not been asked in this thread yet:
Fallen Crusader doesn't seem to have any uptime calculations currently, the spreadsheet just mulitplies your strength by 1.3 if there's Fallen Crusader on one of your weapons. Are you planning to model Fallen Crusader properly for each hand? (Does it stack by the way? Never tested DW on the Beta server)
You get two separate buffs when you DW Fallen Crusader, but I don't remember if it stacks.
Modeling Crusader for tanking isn't worthwhile, 2-4% parry is better. Also DKs can get port to the DK base to change their enchants, so a tank DK with Crusader can port to the base, then get summoned back with tanking enchant
You get two separate buffs when you DW Fallen Crusader, but I don't remember if it stacks.
Modeling Crusader for tanking isn't worthwhile, 2-4% parry is better. Also DKs can get port to the DK base to change their enchants, so a tank DK with Crusader can port to the base, then get summoned back with tanking enchant
With t7 gear accoding to the spreadsheet you're looking at nearly 1500 Strength without Fallen Crusader, so Fallen Crusader increases your Strength by more than 400 when it procs. If you're going by stat points, Fallen Crusader will definitely be worth more on your main hand than 2% parry. I think it's definitely worth modeling because it provides a large DPS and TPS boost for a low avoidance loss.
I have a build coming that will have up times modeled for FC based on PPM. Unfortunately that and a few other changes may not get put up until at least a week after Wrath as frankly I want to play too.
One thing I would love to see if if there are features you feel are missing and if so why, for example other meta gems.
Not promising I'll put them in, but it will definitely be considered.
With t7 gear accoding to the spreadsheet you're looking at nearly 1500 Strength without Fallen Crusader, so Fallen Crusader increases your Strength by more than 400 when it procs. If you're going by stat points, Fallen Crusader will definitely be worth more on your main hand than 2% parry. I think it's definitely worth modeling because it provides a large DPS and TPS boost for a low avoidance loss.
100 parry rating is already worse than 2% parry after diminishing, even if the uptime was 100%. Random mitigation that wont even be up 2/3 of the time might as well be considered zero. You basically know it is a significant TTL loss for a significant DPS/TPS gain. Unless you are in the very small situation of dual wield tanking, but care more about tps than survivability, but don't already have a dedicated threat set and instead go port for crusader situation.
Some features I would like to see include, being able to save gear sets, being able to save talent specs, and being able to save buff/debuff sets. Would be nice to be able to with a click of a button adjust things like buffs down to 10 man and see the impact, or quickly tell the difference between a threat or avoidance set for TTL, or your current set and dream set.
Little question about tanking stuff...
Does DR only come from dodge/parry "ratings"? aka, are stats (such as the +parry % from our weapons and talents) exempt from the DR penalty from stacking stats?
Nothing has been clearly discovered about DW as a tanking option compared with twohanders. The main reason people keep mentioning DW is because there's no avoidance twohanders in game yet... and probably will never be. On the other hand you have things like 2.8 tanking weapons and amazingly good quick tanking weapons like [Last Laugh], which spur conversations about using two of those to boost avoidance, instead of a twohander.
At high levels of gear it might be worth using two _really powerful_ onehanded tanking weapons, but nobody knows for sure yet. Parry-gibs _are_ a big issue.
the extra mitigation/avoidance provided from 2 one-handers doesn't make up for the fact that if you get poorly-timed parries in quick succession, your healers won't have time to react to the massive amount of incoming damage in such a short period of time. however, taking a bit more damage on average, but more steadily and predictably can be healed through.
and of course there are no 2h tank weapons in the game, since there have been no tanks that would use a 2h axe/sword before DKs were implemented. you may be referring to the stuff that's out in wotlk, but we're FAR from seeing all of the itemization available, since it's still so early.
EDIT: not to mention the extra item-budget you'd have to spend on hit to make up for the misses which would annihilate your aggro generation