Elitist Jerks (http://elitistjerks.com/forums.php)
-   Death Knights (http://elitistjerks.com/f72/)

 Tantlin 11/07/08 3:03 AM

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

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.

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 11/07/08 4:19 AM

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

Anyways, muchos thanks for this, looks awesome. :)

 Tantlin 11/07/08 4:37 AM

Updated to fix a few minor bugs

 frmorrison 11/08/08 10:22 PM

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

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 11/10/08 7:43 AM

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 11/10/08 9:23 AM

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 11/10/08 11:07 AM

Quote:
 Originally Posted by Hidden (Post 972029) 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.

 frmorrison 11/10/08 1:55 PM

Quote:
 Originally Posted by Hidden (Post 972029) 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

 Hidden 11/10/08 2:03 PM

Quote:
 Originally Posted by frmorrison (Post 972487) 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.

 Tantlin 11/10/08 7:58 PM

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 11/10/08 8:51 PM

Quote:
 Originally Posted by Hidden (Post 972501) 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.

 Crax 11/11/08 11:18 AM

Human Expertise should be 3

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

 Tantlin 11/11/08 12:23 PM

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 11/18/08 3:14 AM

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

 Gorgangio 11/18/08 7:44 AM

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

All times are GMT -4. The time now is 4:43 PM.