Updated and uploaded RC4. Changes from RC3:

Bug report:

When testing with the same gear/enchants in both current and dream, the instant poison calculations in mainhand are off. Every stat except IP calculations are the same. BF 3piece checked on both current and dream. Specifically blessed qiraji pugio with +5 dmg and instant poison on it. Only mainhand calculations are off, offhand are same.


On another note, is there any way to manually alter the talent build to 16/25/10?

Hmm, according to the spreadsheet in good gear (I chose End-of-BWL as base dream gear):

- Band of Accuria is the second best ring in the game after Master Dragonlayer's Ring, even better than the Signet Ring.
- +15 Agi is a better mainhand enchant than +5 Weapon damage, even when using BQP as mainand

I found this surprising to say the least. Are there flaws in the excel, or is my math just not up to date?

Caught this bug, thanks. Will fix it for rc5.

Well, if you're assuming that you keep 100% SnD efficiency even with only 2/3 Imp. SnD, you can alter this by adding 1% more crit to the "Talents" row on the gear and buffs sheet.

Yes. This is simply because the 1% additional hit on Accuria scales more than the 8 agility (so 8 ap 0.25% crit) of the Exalted Signet Ring. (EDIT - At least in a theoretical situation where you're getting 100% of possible white DPS).

15 Agi scales, +5 main hand damage doesn't. If you are raid buffed, and have BWL+ gear, yeah, 15 agi wins out.

I wondered about this too. What's the point of 17/24/10 as default if you're assuming you never get a rupture in? If you never have to kick or feint, 16/25/10 is enough to keep up SnD.

A small problem i noticed. I am using my information being displayed by CTProfiles and that could be the one that is wrong, but i believe they are fairly accurate. Here is a link to my profile:
http://ctprofiles.net/20935

The Dodge is off by .02% when i apply all of my gear.

I do have some slight confusion with the Band/Seal of Jin. When i put the ring in by themselves... the numbers work out just fine. When i add Band of Jin w/ Set Bonus it gives me an extra 30 AP. I don't know if this is intended, but since the band/seal of jin work just fine... maybe you should remove that option from the list to remove confusion. Besides that keep up the good work.

Edit:
I also noticed that when i add AGI to my MH dagger instead of Crusader, my unbuffed AP goes down =/.

Yes, this is because for Crusader averaging it just adds it as ~29ish Strength, which will show up as "unbuffed AP." Same thing for Earthstrike, which it adds as ~47 AP in the "Unbuffed."

Oh okay... i get it now. That is why i thought the ZG ring combo wasn't working, because Crusader was being added in and making up the AP differnce. And "Unbuffed" in your sheet != Unbuffed to your Character Profile for all cases.

Bug report #2

I compare my gear, +5dmg MH enchant in current, +15 agi MH enchant on dream, everything else the same. Then I change back from +5 dmg to +15 agi in current, making the profiles identical. Poisons are turned off. In the offhand adjusted damage field, in both unbuffed and buffed tabs, the damage differs between current and dream.

Hmm, that one I do not seem to be getting. Do you happen to have say, a Hand of Justice equipped or something?

Only thing equipped thats not trivial Id guess be muggers belt.

edit: Think I isolated the bug to tiles F15 F16 in Dream Buffed DPS tab. I use dagger in mainhand, sword in offhand. It claims my dream buffed offhand crit rate is 4% higher, and hit rate 4% lower than the current buffed dps tab. Identical gear. Bug goes away if I change offhand to dagger.

Appears to be a bug with instant poison on MH with current vs dream. I put my current gear and dream gear exactly the same, and there is a slight difference in damage. Once I take IP off both, they are exactly the same again.

Yes, this is a bug which will be fixed in RC5.

Hot off the presses, RC5

Awesome - looks good, and I know what gear I want now. :) How many months it will take to get is another story, and I'm sure I'll get sidetracked and distracted.

Looks good, since you have a few Nax items, why not add the new trinket? 280 AP (just like Earthstrike) + a static 30 AP. Also there is a new Neck, 16 STA, 2% crit, +28AP, no name though :(.

Kingsfall - Crusader - Windfury
Death's Sting - Agility (+15 Agility) - Instant Poison VI
Striker's Mark
Bonescythe Helm - Death's Embrace
Barbed Choker
Deathdealer's Spaulders - Zandalar Signet of Might
Bonescythe Breastplate - Greater Stats (+4 All Stats)
Belt of Never-ending Agony
Bonescythe Leggings - Death's Embrace
Deathdealer's Boots - Minor Speed (No Stat Boost)
Bonescythe Bracers - Superior Strength (+9 Strength)
Aged Core Leather Gloves - Greater Agility (+7 Agility)
Cloak of the Fallen God - Lesser Agility (+3 Agility)
Master Dragonslayer's Ring
Bonescythe Ring
Earthstrike (will be the click trinket with 30AP passive)
Drake Fang Talisman

Let me know if anyone finds glaring bugs! I think we're getting really close to release version 1.0.

Nice spreadsheet, any chance of making a swords one?

I could have swore there was a post discussing:
1) a modified version that another poster had made
2) a response from the OP stating they were working on it, however that it would be caveated to a certain 'cycle' only.

However, I can't seem to find the specific post for you. Does sound like it's in the works though.

Call me a n00b, but I thought the damage bonus to BS from Opportunity didn't apply to the additive damage, i.e. it looks like

1.8*(MHDam + 1.7*AP/14) + 225

instead of

1.5*(MHDam+1.7*AP/14)+225)*1.2

the difference, of course, being 20% of 225.

I believe that's how it's reported in the tooltip (which after playing D2 should tip me off that it's actually incorrect) but help me out here, I'm trying to get my theorycraft up to speed for this forum.

P.S. Awesome work.