Great! I had almost stopped following this thread, since the spreadsheet updates were the high point for me and MaxDPS.com just doesn't cut it (too simplistic, doesn't consider consecration/exorcism).

Welcome back, PM incoming.

It's not "that" crazy. We know for sure that And we know as well that JoW proc from spells. Vindication could be (and from the two previous facts I'll tend to say is) considered as an offensive spell and can proc JoW like any other offensive spell. With sorry's wws moreover, I know I'll put a point in it next time I raid as ret (I'll try to record it to see if the numbers match the theory)


edit: Yeeeeeeah!

To make the SoB section of the spreadsheet as accurate as possible. Need confirmation on the following questions:-

1) Does SoB proc off Crusader Strike?
2) Does SoB proc off a windfury hit?
3) Can SoB be Fully Resisted?
4) Can SoB be Partially Resisted?
5) Can SoB be missed/dodge/parried/blocked?
6) Does SoB use Melee Crit?
7) Can JoB be Fully Resisted?
8) Can JoB be Partially Resisted?
9) Can JoB be missed/dodge/parried/blocked?
10) Does Job Use Melee Crit?

I also need to know:-

11) What are the spell damage coefficnets for the different ranks of consecration. I know Rank 1 is 46% and Rank 6 is 95%. Dont know the rest.

Cheers

Just a quick update. In the version of the spreadsheet i'm working on atm, all the functionality such as Item Analysis, Mana Efficiency, Skill Dps Breakdown now works for SoB.

As soon as i have the underlying calculations (as per previous mail sorted), should be ready for publishing (a lot quicker than i anticipated)

Durandel, i realised in my question list i used the same number multiple times. Have re-numbered them. If you get a sec to re-number your answers accordingly would be appreciated

Cheers

Slightly off topic, but I can really recommend Filefront for this purpose.

A benefit would be you could just link to your profile directory there on the front post of this thread and we could see new (and old) files without having to worry about posting single file links, just a "new spreadsheet up!" message

Since Vindication is an on-hit proc, it always accompanies a melee hit. We know melee hits proc JoW, so if Vindication can proc JoW, we'd expect to see two JoW procs from time to time. We do not seem to see these "double procs".


However, Sorry's WWS stats show an increase in JoW procs with Vindication, so it looks like Vindication does affect JoW proc-rate, but not in a way that allows "double procs".

Good to see you still around

I updated the OP.

Alright, I've been doing some tests to get the different co-efficients for Consecration and Exorcism for the spreadsheet (already PMed), when I stumbled on something very disturbing regarding JotC.

Consecration:

(To be read as follows: Rank x: Base damage per tick, Damage when using 222 spelldamage gear - co-efficient)

Rank 6: 64, 90 - 94%
Rank 5: 48, 74 - 94%
Rank 4: 35, 61 - 94%
Rank 3: 24, 45 - 76%
Rank 2: 15, 32 - 61%
Rank 1: 8, 21 - 47%

What was very intersting is that in contrast to normal spelldamage gained from gear, the spelldamage from JotC doesn't seem to be affected by the co-efficient decline when downranking.

Meaning that ALL ranks of Consecration gain 95% from the 219 spelldamage added by JotC.


After further testing, I also discovered that damage added from JotC is NOT affected by any multipliers like everything else (sanctity, imp sanctity, crusade, vengeance, avenging wrath).

This means that JotC will always add a static +26 DPS to consecration regardless of buffs or multipliers.


Consecration rank 6 on a humanoid (+3% from crusade), with 3 stacks of vengeance (+15%) and imp Sanctity aura (+12.2%) and 302 spelldamage (222 from gear + 80 from trinket stacks):

Test result 132 tick! Theorycraft: (64 + (302 * 0.95)/8) * 1.1 * 1.02 * 1.03 * 1.15 = 132.72 DPS

Add JotC ("26 DPS"):

Test result 159 tick! Theorycraft: 26 + (64 + (302 * 0.95)/8) * 1.1 * 1.02 * 1.03 * 1.15 = 158.72 DPS
Instead of 167.27 DPS if JotC spelldamage was affected by multipliers!

Add Avenging Wrath (+30%):

Test result 199 tick! Theorycraft: 26 + (64 + (302 * 0.95)/8) * 1.1 * 1.02 * 1.03 * 1.15 * 1.3 = 198.53 DPS
Instead of 217.45 DPS if JotC spelldamage was affected by multipliers!


As you can see, damage gained from JotC does not benefit from any multipliers

Summary:

-Spelldamage added by JotC does not receive a penalty coefficient when downranking
-Spelldamage added by JotC does not benefit from any multipliers
-JotC will always add "26" more per tick to any rank of consecration regardless of buffs or multipliers


Exorcism:

I did not have time to test this fully and somehow I think it's silly to downrank this spell, given that max rank (7) exorcism costs 340 mana every 15 seconds, which is very little.

I suggest you just model the max rank, which receives a 43% co-efficient.

Also regarding JotC the same behavoir can be experienced as with Consecration, it's rank independant and multiplier independant, meaning JotC always adds 94.17 to any rank of exorcism regardless of multipliers/buffs.


I'm afraid through this bit of testing I've discovered a glaring flaw in one of our core abilities (JotC), I wouldn't be surprised if it gives a static buff that doesn't benefit from any multipliers on all abilities (SoC, Holy Wrath, Crusader Strike atm).

This is a very big issue if you consider the loss of DPS to SoC and JoC (and currently Crusader Strike) from having the 219 holy spelldamage you gain from JotC NOT benefit from active multipliers.

As it stands, multipliers are the strong point of the retri dps and scalability, having JotC not benefit from it means we lose quiet a lot.

I used to consider JotC = +219 free spelldamage, but as I've learned now it is "219 spelldamage that does not benefit from any multipliers".

Multipliers:

Vengeance: +15%
Sanctity Aura: +10%
Crusade: +3%
Improved Sanctity Aura: +2%

[top]> Stacked

32.9% => JotC 219 spelldamage would be equivalent of 291 spelldamage

Further for SoC:

2h spec: +6%

[top]> Stacked

40.9% => JotC 219 spelldamage would be equivalent of 308.5 spelldamage

and Avenging Wrath (when used): +30%

[top]> Stacked

72.7% (83.1% for SoC) => JotC 219 spelldamage would be equivalent of 378.4 (401.1 for SoC) spelldamage


This means, through this mechanics bug, for all our abilities that benefit from JotC (JoC, Exorcism, Consecration, Holy Wrath), we're losing: 72 spelldamage!

For all SoC procs we're losing: 89.5 spelldamage!

Both these numbers should not be underestimated as they're a pretty huge chunk of DPS we're losing on a constant basis (all these multipliers should have 100% uptime 10 seconds into the fight).

Just compare, a [Flask of Supreme Power] or a trinket, would give you slightly less than the 72 (and 89.5) spelldamage we're losing here respectively by not having JotC benefit from our multipliers.

Also while AW is up we're losing: 159.4 spelldamage and 182 spelldamage to SoC!


This is pretty huge, I suggest the somewhat louder blizzard forum activists of this community take this to the blizz forums and demand a fix

Can anyone explain this :

That's the first time I've seen SoB partially resisted. I got multiple partial resists on that kill.

Oh, and

on that same kill.