Kris, try updating your version of Excel 2003. The file was created in Excel 2003 (11.5612..6412)

For some reason, the Shoulder section has s1 and s2 chest pieces instead of shoulders.

Also, the trinket section is mising the skyguard exalted dps trinket.
Missing crafted weapons from weapons section.

I fully agree on that.


I personally think this is an unacceptable minimum, I set my minimum at judging JoC on every cooldown, for the damage and especially to make use of libram effects (whether the +2.4% crit from avengement or the 200 AP from the PTR libram).

However, this is obviously a matter of choice/opinions.

I agree with the rest of your post, as long as the point is brought across that one should not blindly pile on the damage stats without considering mana, I'm happy


On another note, bellator, I have to say I'm impressed by the notes on the new version, much respect for your work mate

I'll check it out when I get home.

Btw: Does the new spreadsheet account for the loss of libram effectiveness if you don't judge on every cooldown?

This is still on my list of things to do. I've just put it off as it involves tediously going through the entire code and replacing 'blanks' with 0's :p

Will be fixed in next version

I felt the trinket was more of a grinding trinket, but may add it in next version. Will try to get some of the craftable weapons/armour added in.


Cheers Avitus. Hopefully the new features will allow you to see the effects of int/mp5 etc on longevity ets. And yes, loss of libram effectivess is factored in.


On another note, can someone confirm which of the following abilities do/do not proc JoW, as want to confirm my calcs are correct:-

Melee,SoC,JoC,SoB,JoC,CS,WF attack.

Cheers

Someone also pointed out to me that Libram of Divine judgement is also being applied in my model to SoB dps when the tooltip only mentions SoC. The way everything is coded makes it a complete pain to remove this error. Best work around is just not to equip it when looking at SoB dps.

If you can tell me which "blanks" need to be left alone, I can go ahead and do it myself, but I understand where you're coming from. I'm not here to debate coding progress; after all, most of it's not even commented. :P

Can any BE confirm Requitals report of JoB being based on melee hit unlike JoC that is based on spell hit?

Ok, I was under the assumption that Mind Flay can proc JoW each tick of damage (like AM). If not the numbers will be much lower, I'll go ahead and update the list then. Thank you.

In 5 WWS (around 2000 JoB's) I only had partial resists - I never actually had a full resist, which I think is what would show up if I 'missed'. I had around 2% partial resist.

In that same 5 WWS series I had less than 100 JoC's and missed 10%, and about 2% partial resist.

Not such a fantastic number of samples, but as a comparison they're interesting. I'll try to actually test this tonight - someone earlier suggested using halaa guards. I'm not sure how forgiving the alliance will be for my testing, but I might try those since it involves hit.

ret pallies suck, l2heal imo and let a dps or tanking warrior have ur spot

Don't feed the trolls.

Updated the JoW list to include what I think is about right for Enhancement Shamans. Correct me if I'm wrong.

This may not all be accurate (but its the best I could find). These numbers assume a perfect 50% proc rate for JoW to make the math easier. These numbers assume a 100% hit rate to again make the math easier. These calculations only include spells and abilities that can proc JoW, even though there may be more in the rotation. Any haste effects, whether passive (+Haste rating) or talented (Flurry) or from items (Dragonspine Trophy proc), are not considered into the calculations. There is a reason this is the ideal situation test folks. Feel free to fix/add to them as you can.

Hunter
Beast Mastery
Typical Rotation: Autoshot, Steady Shot, repeat
Assumed Autoshot Speed: 2.1s
Ideal Mp5 from JoW: 176.19 Mp5

Marksmanship
Typical Rotation: Autoshot, Steady Shot, Special Shot, Autoshot, Steady Shot, repeat
Assumed Autoshot Speed: 2.5s
Ideal Mp5 from JoW: 185 Mp5

Survival
Typical Rotation: Autoshot, Steady Shot, Special Shot, Autoshot, Steady Shot, repeat
Assumed Autoshot Speed: 2.5s
Ideal M5 from JoW: 185 Mp5

Mage
Fire
Typical Rotation: (After Fire Vunerability x5 is applied) Fireball x8, Scorch, repeat
Ideal Mp5 from JoW: 65.29 Mp5

Frost
Typical Rotation: Frostbolt, repeat
Ideal Mp5 from JoW: 74

Arcane
Typical Rotation: Arcane Blast x2, Arcane Missiles x2, Scorch, repeat
Ideal Mp5 from JoW: 138.75 Mp5

Note for mages assumed 5/5 Improved Fireball/Frostbolt depending on spec

Shaman
Elemental
Typical Rotation: Lightning Bolt, repeat
Ideal Mp5 from JoW: 111 Mp5

Lightning Overload assumed perfect 20% proc rate

Enhancement (Duel Wielding)
Typical Rotation: Stormstrike, Flame Shock, Autoattack, Earth Shock, Autoattack, repeat
Assumed Autoattack Speed: 2.6 Seconds (both hands)
Ideal Mp5 from JoW: 142.3 Mp5

Enhancement (2 Handed)
Typical Rotation: Stormstrike, Flame Shock, Autoattack, Earth Shock, Autoattack, repeat
Assumed Autoattack Speed: 3.8 seconds
Ideal Mp5 from JoW: 102.78 Mp5

Windfury Weapon assumed perfect 20% proc rate on both weapons
Shocks assumed to have nontalented 6 second cooldown

Priest
Shadow
Typical Rotation: Vampiric Touch, Shadow Word: Pain, Mind Blast, Shadow Word: Death, Mind Flay x2, Mind Blast, reapply DoTs as needed
Ideal Mp5 from JoW: 92.5 Mp5

Both the Shadow Priest and Arcane Mage spell rotations are very complicated and vary greatly depending on fight and spec, so take those numbers with the largest grain of salt possible.