Tantlin

Here's the third version of my tanking mitigation simulator.

Download DKTankCraftV3.12 Excel 2007

Download DKTankCraftV3.12 97-2003

Download DKTankCraftV3.12 Open Office


**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.

 

KnThrak

Noes, only the Excel version has the talent trees. *laments the unfairness and cruelty of the world*

Anyways, muchos thanks for this, looks awesome.

SQUEAK.
-- (The Death of Rats, Terry Pratchett, Soul Music)

 

Tantlin

Updated to fix a few minor bugs

 

• frmorrison

The interactive talent tree in Excel 07 was neat. Wow, Bone Shield is really good.

Comments:
I noticed you could negative point Unholy Blight (so the talent has -1 or -2 points instead of zero).

I would recommend that the grey fields (that do calculations) are locked so a user cannot change them.

 

Aeronx

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?

Anyway, that spreadsheet its fantastic

 

Hidden

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)

 

Flamingcloud

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.

 

• frmorrison

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

 

Hidden

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.

 

Tantlin

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.

 

Flamingcloud

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.

 

Crax

You have Human's having the same expertise as Dwarfs and Orcs. I believe Humans got nerfed to 3 expertise in Swords & Maces.

 

Tantlin

Definitely on break for the next week or more while I level, feel free to post but I won't be getting to these fixes for a bit, sorry.

Edit: One last update since I couldn't log on.

 

JerleMinara

Edit: I am retarded and missed the big warning at the top. Disregard

 

Gorgangio

I might be being silly but is there a way to add enchants to a weapon? All i can see is gems.

 

Shockolate

On the Mitigation page in the upper right there is a box that says MH Rune and OH Rune. Those are the runeforge enchants.

 

Gorgangio

Ah i see thank you

So if i have a runeforge enchant i couldnt have savagery for example?

 

Orfan

Not currently. Only one modifier to a piece of gear, still.

 

Asari

Frigid Deathplate in the Frost Tree is incorrect on this. The version on live reduces your chance to be hit by 1/2/3%.

 

mav1234

Excellent resource, it's interesting.

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?

 

Infiniteone

Just putting this out here btw.

Tps means absolutely nothing in WOTLK, if we're going to find a niche in tanking it has got to be solely based on utility and mitigation.

 

-Abakus-

I was under the impression that DW Tanking was just asking to be insta-gibbed by extra parry hasting. Has this changed in any way?

 

Yavon

Id like to know the same thing. Why would a DK want to go duel wield for tanking Frost or any other spec.

 

okkita

About DW:

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.

More on this starting from DK Tanking Discussion

 

-Abakus-

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