dr_AllCOM3

Where can we get it? The link in post #2 doesn't work.

DocsUI
DK Simulator

 

Feorthas

Fixed. The update notes post (2 above this one) has a working URL.

I am not your personal Frost Deathknight knowledge base. If you have a simple question, ask in the simple questions thread; if you have a more esoteric, specific, or complicated question, ask in the spec-appropriate thread.

My PM, WoWmail, and, especially, chat boxes are NOT the appropriate places for these questions.

 

kurokaze

Copied from the DW thread:

I was going to wait until I added in a solid gear database, but it seems we've reached critical mass on conflicting napkin math and wild speculation. I have no choice but to release some harder numbers. Hopefully Grigori or someone can provide some optimal post-patch rotations so that our numbers are as accurate as can be.

I'll run some of the more recent questions and edit in/post the results next, but I think it'll be most efficient to get the tool out there ASAP.

Caveats:
**Be sure to check 'Parameters' for a few variables that swing the calculation one way or another between the two popular specs:

Desecration uptime (this just represents the amount of time standing in it vs. not assuming it's up 100%; entering 50% will result in 25% uptime if your rotation keeps it up 50%)

Bone shield and UA uptime also self-explanatory. Target snared is for Glyph of Blood Strike, activate this (up to 100, not up to 1) if you expect to have FFB mages postpatch and want to estimate based on the claim that the FFB dot activates said glyph.

Ghoul uptime given x points in NotD - this is multiplied by 2/5 if you don't take MoG, which might not be the most realistic way to model things...

Merciless uptime might be a bit low on the estimate but shouldn't change much one way or the other.

**Additionally, check 'Buffs' to ensure that the proper buffs are selected regarding Crypt Fever and Ebon Plague. Particularly, make sure to include 3 CF if you're not the EP bitch and want to estimate stacking as it is on PTR.

**Rotationwise, the options are rather a mess. I'm pretty sure I cleaned out all the impossible rotations, but I wouldn't assume the optimal rotation for whatever spec is included or anything.

**I haven't fully tested the options regarding the optimization code for accuracy or workingness. All I know is that the numbers the estimate spits out don't raise too many red flags (provided the ones listed DO NOT USE are not used) and that in theory the non-estimate should be both more accurate and hellishly slow to calculate.

--

Additional non-DW related caveats:

DRW is a rough estimate and probably completely off in the outlier case of a 51 blood dual wielder.

If you add your own 2H weapon make sure to set its special property to Two-Hand in column T.

The unholy 2H rotation - for glyphed scourge strike, use 5xSS but replace an SS with PS/IT if diseases fall off - is in early stages/rough estimate.

Sudden Doom is completely untested but should work.

There is currently no way for 2H frost to estimate using HB when KM procs instead of OB.

--

Edit: A couple quick bugfixes:

Set Spec.Q47 to 1 and set Spec.D27 to OK.

 

elvindiva

Thanks for all your hard work, Kuro.

Might I suggest you set up an "enchant" on waist to handle the eternium belt buckle? It adds a socket which needs to be calculated in.

The belt buckle can be used by anyone. Only blacksmiths can add another socket to the bracers and gloves. That would require a reorganization of the columns to add a flag for that. At this point it would be easier to just adjust the gear page.

 

kurokaze

I'm not sure how that's superior to the current method of handling the belt buckle (manually adding it to each belt as a "Any" socket) given that there is no other belt enchant in game with a relevant effect. The concern I had with that method is that I'd have to add rows or columns to deal with enchantment sockets, and I'm trying to keep the Profiles page nice and clean and easy to use. I suppose I could just replace the fourth socket column, though, since no item that I know of has four (at least one belt I can think of has three, plus a buckle is why I included four).

You should also be able to add a "BS" socket to all bracers and gloves (I will do this when I implement professions fully) which currently acts identically to the "Any" socket but will later throw an error if Blacksmithing is not selected as a profession.

Do blacksmith sockets stack with enchants? Never even considered the matter. If they don't I'll have to add the socket in as a statless enchant and throw a socket error of a BS socket is used without the enchant present. No big deal.

My current project is an automatic gear optimizer (pretty basic, it'll just use strength gems in all sockets) and it's making my head hurt. I can easily optimize the gear around hitting the proper hit rating cap, but then I may be well over or under for expertise; then after optimizing for expertise it will probably botch the hit. I don't think multiple iterations would do anything except juggle back and forth. Maybe I could just prioritize expertise second and refuse to remove/add any hit along with it? That might work for dual wield but expertise isn't far behind hit for 2H builds, which should be more problematic anyway due to the lower hitcap.

 

Buanna

They do. On my version, I just added the "Any" socket to all gloves and bracers.

Boni and Bonii are not words.
Bonuses is.

 

kurokaze

In semi-response to a post on the DW thread questioning how I handle rotations:

- Rime (and Sudden Doom) are modeled in a rather approximate form regarding their effect on RP. Rather than being incorporated into Death Coil and Howling Blast, they are treated as separate additions thereafter. That is to say, the rotation segment IT HB will always be assumed to produce a total of 45 runic power (with appropriate talents/glyphs). The additional GCD and ability produced is modeled separately, such that IT HB Dump would result in IT, HB, DC, 15% chance of an additional HB, and 15% chance of causing a gcd worth of rotational pushback (reduced based on amount of free time at the end of the rotation before the next should begin). Sudden Doom autocrit is modeled separately from the free death coil and applies to the first one cast after the buff is gained. The 5 RP gain from Rime is not modeled.

- Runes are not modeled in any way shape or form. It is assumed that the rotation entered is valid and possible with respect to rune abilities. In the case of the rotations I enter, this is often not true. I'm considering writing some kind of rotation validator but I'm not really sure how to go about it.

- List of valid rotation commands:
Begin segment
End segment
A segment represents one full rune refresh (10 seconds). Basically, dividing the rotation into segments just says 'After the end of this segment, if it hasn't been 10 seconds yet, wait for runes to refresh.'
Plague Strike
Icy Touch
Blood Rune Strike
FU Rune Strike
Blood Rune Spell
Pretty self explanatory. The highest average damage per hit ability is calculated and used. One of the options calculated for the FU rune strike is to use Obliterate when Killing Machine is not active and Howling Blast when Killing Machine is active; the effect of this on RP when 4P T7 is worn is averaged out, so that the conditional strike will generate ~27 RP. RP generation is taken into account when deciding. The GCD is also averaged. Blood Rune Spell will always use Pestilence if 5 points are placed in Blood of the North.
Single RP Dump
Full RP Dump
If at any time an RP dump is attempted, and Unholy Blight has not been cast at all this rotation, is talented, and is higher total damage than other RP dumps, Unholy Blight is cast. Single RP dumps are binary; they do nothing if RP is less than 40 (or 32 or whatever). Full RP dumps will create multiple GCDs until RP = 0, pushing back the rotation if applicable. If less than 40 (32) RP but greater than 0 RP is present, it adds a corresponding percentage chance of an RP dump and the same percentage of rotation pushback if applicable.
Rime / Sudden Doom
This will check the chance that Rime has procced, then add that percentage chance of an HB and that percentage chance of a rotation pushback if applicable; then does the same with Sudden Doom.
---FU Disease Refresh
This is intended to represent using Scourge Strike if diseases are up and using PS/IT if not, for a glyphed 2H Unholy rotation. It doesn't seem to work very well though. I won't go into huge detail as this is not the 2H Unholy thread.
0.1 Sec Delay
Self explanatory. Allows waiting for runes to be in the right spot.
Rime or RP Dump
For creating 'tight' rotations that don't go (much) over 10 seconds. This will check the chance that Freezing Fog is active, add that chance of an HB, then add the remainder chance of a single RP dump. RP is removed in full.

- If any RP is remaining at the end of a rotation (which will not be the case if 'Full RP Dump' is used), it is added to the beginning and recalculated.

In typing out this I've definitely noticed some inconsistencies and some areas in which the model is highly inaccurate. I have a few options, and I'm not sure which way to go at this point:
- Leave it generally as is; it's good enough to approximate DPS using a 'standard' rotation. Let the rotation geeks use pen and paper or a separate tool to optimize.
- Fully implement an RP system such that Rime and Sudden Doom procs, as well as the 4P T7 Obliterate vs. Howling Blast discrepancy, are modeled. The only way I can think to do this without starting over and rewriting the entire thing as a full-on simulator is to split off 'scenarios' each time BS/HS or IT is used for each contingency subrotation. I'd end up with a lot of scenarios and quite a bit more complexity.
- Implement an averaging system to Rime and Sudden Doom similar to what I used for 4P T7, so that IT HB Dump results in an average of 42.75 RP instead of 45, et cetera. This may be near accurate but it doesn't account for potential rune delay.
- Fully implement runes. This would have probably more than twice the complexity of just fully implementing RP.
- Fully implement runes and a priority system. This would require significant recoding but allow much more accuracy than before, since most fights necessitate a priority system anyway.

I think I'm going to investigate what is necessary to implement a priority system. It may not be all that bad...

 

dr_AllCOM3

zSHARE - Doc_DK_DPS_v018.zip
Works with Excel2007 and OO
- Update: DPS wasn't added correctly

- hopefully bugfree
- improved UI
- KM, SEP, custom values implemented
- automatically generated wowhead link for item comparison

DocsUI
DK Simulator

 

dr_AllCOM3

I've updated my sheet. I'm still waiting for some constructive feedback .

DocsUI
DK Simulator

 

Oke

Your figuring Ghoul Ap wrong. Its not AP = Str * 2, they actually only get 1 AP per Str added to thier base AP.

Strength - Base_Str + Base_AP
Base Str = 331
Base Ap = 1167

In game my Ghoul has 1808 Str and 2644 ap (1808-331+1167 = 2644). Hope it helps.

 

dr_AllCOM3

Oh yes. This is what I expect . Thanks.

DocsUI
DK Simulator

 

Alandi

Great sheet Doc, I haven't run in to any real problems yet. But I was wondering how to add proc's from items like [Darkmoon Card: Greatness]? Also what about adding other races? how do you add in things like racial's?

 

Lotan

Nice page, good for quickly generating lists of what you should be getting in general.

Few (constructive) comments:

Might be worth also putting in a modifier for armor, if you spec into blood you will be getting 5 attack power per 180 armor making plate look a lot more attractive then it is currently looking on the page.

Is there a way to code in an expertise and hit cap (or someway of selecting gear so you get a warning when you go over your cap, which you can then input yourself ratingwise)?
Is there a way to code in being a jewelcrafter and having acces to 3 prismatic gems
Is there a way to hard code trinket effects? (assuming uptimes of these effects)

Just some ideas that sprung to mind, but I like the looks of this

 

dr_AllCOM3

zSHARE - Doc_DK_DPS_v022.zip
Works with Excel2007 and OO
- Update: some bugfixes

- hopefully bugfree, but I won't mind you looking it up
- improved UI
- KM, SEP, custom values implemented
- automatically generated wowhead link for item comparison

DocsUI
DK Simulator

 

dr_AllCOM3

There was a huge bug with IIT, it gave you 50% haste .
Now the DPS numbers are like you'd exspect them to be.

Edit: Another update.

DocsUI
DK Simulator

 

EdisonRogue

Any chance that one of the moderators would be kind enough to post the links to the latest versions of the spreadsheets and other tools at the top of the thread? This thread it no long enough that it is a problem to dig through, but it may get harder over time.

Thanks.

 

shed

Why do you have tanking necks in your neck section?

 

kurokaze

Tanking necks have Strength in large quantities. Strength is our best stat. Ergo, tanking necks can potentially eclipse DPS necks full of secondary/tertiary stats like agility and such, plus a heap of raw attack power that doesn't come near the value of strength for us.

This effect is exaggerated with the numbers he used because the version of my sheet he used has the ghoul gaining 2 AP per STR; it actually gains 1 AP per STR. This lowers the value of STR from about 3.2 AP to about 2.8 AP.

 

Hidden

Would you mind uploading your newest spreadsheet version, Kurokaze?
I'm really interested in how big the patch's effect on stat values is, I assume it won't have much of an effect on item choices though.

 

Goetterdaemmerung

Char!C116 should be =C115+E115*2.

Devotion aura could contribute to bladed armor.

I don't see the chaotic meta implemented? I think D5 could reasonably changed to 2.03 on each of the setup sheets.

 

dr_AllCOM3

I had to read that three times to understand it :o.

DocsUI
DK Simulator

 

Goetterdaemmerung

I can be more long-winded if you need me to be I prefer reading one line twice over reading ten lines once.

I'm assuming the following are NYI: Food, flask, gems, enchants. I've used the clear workaround of 'Custom Values' to make the stat subtotals equal what I see in my untalented character sheet, but this diminishes the value of inputting my gear at all.

Overall it seems relatively accurate and easy to understand.