Doc, where on your sheet can i find the rotation you're using for frost/unholy and frost/blood? Reason i ask is because I don't think anyone in the Frost 2h thread has found unholy > blood in dps tests.

The big blue box.




zSHARE - Doc_DK_DPS_v023.zip
Works with Excel2007 and OO, Apple/Mac-> here.
- Update: other fixes

Doc it seems there is something wrong with haste value for 2h Unholy. When I decrease Ghoul uptime, haste value increase while it should be the other way. Also hit value (pre-melee cap) does not change with Ghoul uptime like it should.

Also I found strange that Blood get so high hit values before and after cap. For example: 3.8 (!), 3.16 pre-cap. Compare that to 1.89 I got for Frost and 1.75 for Unholy. The hit value after melee cap is "strange" same way having double the value for Blood. I suspect something is not right there.

P.S. I recalculated SEP so that 1 AP = 1.0 always.

Foerthas - because of the way you handle the RP from Butchery, in some cases some of it is not used by the dmp. In the aggregate case, all of that RP would be used, though some of it would be from the rotation before this one - I suggest that the net rp from Butchery over the course of a rotation be added in at the beginning instead of along the way.

Doc how do I put enchants on weapons? I looked through the sheets and saw some of the modifiers for them but wasn't exactly sure how to add them in. Thanks in advance.

The spreadsheet has 'rotations' listed by title, but doesn't have any notes on what exactly those rotations are.
We could assume, but might be helpful to be specific.

Secondly, it would be helpful if fields which need to have data-entry are coloured-coded to say all one coloure, say yellow.

Hello dr_AllCOM3

Do you apply a DW Spreadsheet by your zSHARE - Doc_DK_DPS_v023.zip?

greetings

Uh, what?

Hey, thanks for making these spreadsheets. I am using Excel for Mac, and it doesn't seem to want to open your spreadsheet, dr_AllCOM3, with a .xlsm extension. It's probably just the fact that I have a mac I guess.

Also Feorthas, when I tried to use your spreadsheet in googledocs it wouldn't let me edit the stats block, and when I exported it there was an error about a looping macro or something.
I'm probably just doing something wrong?

I tried this spreadsheet on a Mac, and was told that Excel '08 for Mac doesn't support the Visual Basic macros in the sheet. That may well be the problem you're seeing.

Unless I'm looking at it wrong, it looks like your figuring the DKs AP simply as (Str * 2) + GearAP. It should be AP From Str + Base AP + Ap from Gear. Where Ap From Str = (Str * 2) - 20 and Base Ap = Lvl * 3 or simply 240 + (Str * 2) - 20 + ItemAP. Hope it helps.

That worked, thanks =)

OpenOffice.org would work as well.

I have not included race stats. You can't change your race anyway . It also is boring to implement .

Does anyone have an alternate download location for the spreadsheet? This zshare site is telling me I can't use it because I am using an ad-blocker and wants me to disable it.

I had the same problem, I just opened the link in Internet Explorer and it worked fine.

Nevermind, I disabled my torrent downloader and got it to work. Thanks anyways.

After looking over the sheet, I noticed that its' very rough. I assume this is how it will be, just want to be clear that I got the right sheet and not a previous one?

As such, will there be future implementation of putting in the gems we have, or is it assumed that every socket is 16str? (3x 27str if a jc, as I am). Also, will we have to input our own racial's into this sheet too?

I don't want to sound like I'm spitting in the face of all your hard work, I think the fact that you have our dps based on 3 diff specs at one time as an AMAZING feature unto itself, I only ask to know if I should start investing a lot of time to enchance my sheet for ally/gnome things and gear that maybe isnt top of that top, as it will never happen from the creator. Thoughts?

dr_AllCOM3: Why does razorice give a 1.1 bonus multiplier (rather than 1.05 for its 5% buff)? Also, I've ended up hardwiring it to 1.05 because it only toggles on if the sheet detects I'm DWing -- yet I receive the buff in my raid from another DWing DK. This is a nontrivial DPS gain for my 6xIT 2h spec (and slightly less so for other 2h frost) which the sheet overlooks.

dr_AllCOM3: I did not find any reference to it in spreadsheet but it does not seem to include UA into account ( entered 2 specs that are the same with the only difference being UA included in one and "filler" mind-freeze talent in another - same DPS produced in all rotations )

I noticed in Feorthas' spreadsheet that Impurity is affecting Frost Strike damage. It was my understanding that no strikes gained any benefit from Impurity. Is that correct? That could explain some inconsistencies I've seen between the predicted dps and what I've observed.

v025
zSHARE - Doc_DK_DPS.zip
alt. FileFactory - Doc_DK_DPS.zip
Works with Excel2007 and OO, Apple/Mac-> here.
- Update: Gems, Enchants
- OO gem fixes