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

Bellator, it looks like you were on track for the changes for the 502 errors (I could really care less about the buttons, except that's it's annoying that I can't socket any gems). Why the sudden change?

Also, v17 for some reason popped up at the start with: "This file contains links to other files. Should they be updated?"

I told it "no" because it was different than the others.

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?

You guys should consider testing on the Halaa guards instead of Blasted Lands mobs. Even as a shaman with only ~5k armor, my healing stream totem (ticks for ~49? every 2 seconds) is enough to keep me alive for quite a long while (10+ minutes), and the Halaa guards have a ridiculous amount of health.

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?

Can anyone tell me if Dragonspine Trophy is worth using for a BE paladin? May sound noobish but im not the greatest with numbers!

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.

But I doubt a Warrior can Bless, keep Judgements up, provide 2% damage for his group, and give raidwide 3% crit while maintaining reasonable DPS.

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.

The new 30% threat reduction and precision change got patched in today on the PTR!

Gonna do some testing.

If Lightning Overload (36-40 point talent) can proc JoW then you can effectively increase this number by 20% over time. I'm not sure if it does though.

Edit: Nevermind, Blizzard decided it would be cute and let me actually log onto the PTR with an old build. Way to go!

900-950 dps in Blasted Lands with S2/3 PVP Gear and S2 Sword (only BoM/Crusader), up to 1100 dps with rang 1 concecration and AV with all out.

I'm an update freak, using the latest from everything, Excel v. 11.8169.8172 SP3

Since people keep talking about using consecration in the dps cycle, i thought i'd do some testing on this ability to see exactly how it works to perhaps include it in the model. From the testing i conducted the mechanics seem fubar. Can someone please confirm this:-

1) When it comes to normal spell damage from gear, the min rank does not get the same 0.95 coefficient as the max rank. There is scaleing involved. However the extra damage caused is modified by things such as sanctity aura, crusade etc.

2) When it comes to spell damage from JotC there is no scaleing, and the 219 is multiplied by 0.95 coefficient even at min rank. However, the extra damage this generates is not modified by things such as sanctity aura, crusade etc.

You can see the modifiers effecting different types of spell damage by:-
A) Put on SpDam gear, dont judge mob, pop consecration then pop AW and see the ticks go up by 30%
B) dont wear SpDam gear but judge the mob, pop consecration then pop AW and you will see the ticks dont go up by 30%

When I tried this out with SoR, the increased damage from JotC was being effected by multipliers, but not consecration. So this leaves me with 2 questions.

1) Why does Jotc +spdamage not scale like spdam on gear when it comes to downranking
2) Why does The extra consecration damage from +dmg get damage modifiers applied to it, but not extra damage from jotc

This just seemed really weird to me, however i ran the tests multiple times and came to these same conclusions. Can anyone verify these conclusions? Cheers

I don't know if it's a bug (probably is), but on the PTR the General's Scaled Greaves have got +12 agility on top of the previous stats (nothing reduced).
I checked the Veteran's and they remained unchanged.

Edit: wow that was a really stupid thing to say, forgot about the enchant

Its the enchant that is now shown white.

@Cromfel


SoC Rank6 Example
Mana consumption 45 mana per second
DPS : 1043
Melee 44 %
Seal of Command (Holy) 24 %
Crusader Strike 22 %
Judgement of Command (Holy) 10 %
DPS time : 3mn

This numbers were posted by you at the beginning. I did some testings myself and I was oom after 1 m 48 - 1 m 53 sec with 6843 mana

5 Tests
dps 918-983
melee 40-44 %
SoC 16-21 %
CS 26-30 %
JoC 10-12 %

1 m 51 sec theor. 18 CS and 13 JoC - I managed 17 CS and 11 JoC - that means 4012 + 3982-( 119x11)=6683 mana spent -> 60,2 mana/sec

There is a difference between % dmg of CS and SoC, this can result from my faster weapon pvp S2 Sword.
The biggest issue is mana, your fight lasted 3 min vs my fight 1m 51 sec. I have 60,2 mana/sec and you 45 mana/sec



Edit: I use PVP S2/3 Gear with BT haste Ring and SSC Neck and PVP S2 Sword->no mp5