Mithgaur

I'm getting a error here too, and also using Excel 2003. When I set execute to TRUE I get VALUE# on the cell that shows dps and a few other cells. Doesn't work putting the value back to false. I have to close the program without saving and running it again to the VALUE# error to go away.

EDIT: I'm using a Norwegian version of Excel 2003. Can this be a reason for the errors?

 

• Fogbug

Going by that it looks like the shard is our best pre-M'uru DPS trinket by a pretty good margin, assuming you're not capped on expertise. That or something is wrong with my shet

 

Gruntle

Matches what I've found, expertise is that good when not capped. In for some serious Heroic MgT grinding, should do wonders for my badge supply as well.

edit: I'm not getting that it's the best trinket before M'uru, it's clearly beaten by Madness of the betrayer and DST, though it seems to be better than Tsunami Talisman even when using a fast weapon. I'm not using Grim13s sheet though.

 

Grim13

Sorry about the lack of response. I work on this in my free time at the office, and i've been home with an injury. Anyways, I have not yet modeled any 2.4 procs. Hopefully I will get to it soon. As to the problems people are having, I will do my best to address them.

1) if the sheet isn't updating, try pressing F9
2) any errors in the DPS summary page are display only. I personally don't use it much so I forgot to error check it after the recent changes.
3) I'll get the rest cleaned up ASAP, hopefully today.



Oh, and I now own MMODPS.COM. Hopefully I'll be able to follow through and produce a site true to my vision, in both form and function.

 

Hidden

SoC IS better than MotB if you're not capped on expertise with it. The proc averages out to ~80-90 ap, so it's around 20 hit rating and 150 armor penetration vs 44 expertise with expertise being the very best stat until capped.

 

Graul

Is this still true when you have the Onslaught belt?

 

• Fogbug

According to my copy of Grim's sheet, yeah. That's as an undead warrior, though - For a human with the belt and the expertise talent both DST and madness show up as being a bit better

 

Whistles

15 points of Expertise caps you ((5.6-2)/.25=14.4 but there isn't partial Expertise) since you have Weapon Mastery. You have 5 expertise as your racial so 10 points of expertise at 3.94 rating per point is 39.4 expertise rating. Effectively SoC will give you 14 expertise rating (the rest is over the cap) so run the comparison like that.

Of course with both you could also not have Weapon Mastery and be as close to the cap as you can get without going over (4.25% dodge removed of 4.35% after your racial). Putting those points into Improved Execute might result in an increase in overall DPS from using DST. Too late to try to figure that out, apologies if this math is all messed up due to it being 6AM here.

 

Kaan

Shard of Contempt delivers 44 Expertise Rating, this is 11.16 Expertise @ lvl 70 (2,75% -dodge). So 1 Exp is wasted when you are human with weapon mastery.

 

sam

Just for clarification, does this mean that a lvl 70 human warrior with WM and the Shard should remove both points from WM and put it into a talent like Improved Execute?

 

Kaan

No. A human warrior with 2/2 Weapon Mastery and Shard of Contempt has -6% Dodge, so 0,40% Dodge is wasted assuming a boss dodges 5,6% of your attacks. Removing 1 point out of Weapon Mastery would mean you would need 0,60% -dodge to be expertise capped again. 1/2 Points in Improved Execute aren't worth 0,60% -dodge or even 1,6% -dodge.

Though, human warriors wearing T6 Belt with 2/2 Weapon Mastery have to wear another trinket (for example TT or MOTB) instead of Shard of Contempt, to not waste any DPS.

 

Whistles

He was specifically asking about if he combined it with the T6 belt. It does deliver 44 rating but 30 of that is over the cap. Setting the stats to 14 rating (since this is how much will be benefitting you) and running a comparison with MotB/DST/whatever will tell you which is better for you (although the answer is pretty obviously not SoC at that point).

 

Gruntle

Well, sure Expertise is the best stat, still ArP is not shabby either. I'd say that SoC is better than MotB if you have zero ArP otherwise, but if you're stacking ArP and the mob is fully debuffed MotB will probably be better. At least according to the spreadsheet.

It's hard to compare ArP to the other stats, due to how non-linear it is, but that doesn't mean it should be ignored just because Expertise is so damned good.

Ah well, time to start running heroic MgT to get the darned thing, my trinket luck is awful however so it'll probably be 100 runs before it drops

 

Graul

Just to bring up what was being mentioned in the Ret thread when they were discussing Mongoose vs Executioner, the higher a bosses natural AC the weaker ArP becomes compared to other stats on naturally lower armored targets. So far this only seems to apply to Brutallus, so it might not be worth worrying over, but if at least two other bosses in Sunwell sit at higher than the average BT/Hyjal boss in armor, it might be time to reevaluate ArP.

 

Akka

Mmh, haven't the bosses 6,5 % dodge rather than 5,6 % ?

If violence doesn't solve your problem...
... you simply haven't been violent enough !

 

ghorghor

hmm

I am wondering where the Shivering Felspine Polearm looses its DPS on the spreadsheet calculator vs Soulcleaver, S3 Sword and other BT weapons?

the high Max dam and 140,4 dps seem to be so nice, yet vs my S3 sword it doesnt hold up in any way.. and even soulcleaver with same Weapon specc wins in an all out race vs this ilevel 154 weapon

does anyone has an in depth reason for this?

 

dr_AllCOM3

Yes, 6,5%. All the sheets are wrong.


I guess the speed and the stats. Ignore armor is very good, AP and Agi aren't that hot.

 

Cavein

My own cursory check shows Shivering Felspine as the best slam weapon until Kil'jaeden.

Based on my current gear with raid buffs up and my guild's normal melee group setup my slam rotation gains a conservative value of approximately 16 dps by swapping from Cataclysm's Edge to Shivering Felspine (with Poleaxe rather than Sword Specialization).

I do not use the spreadsheets included here so I cannot examine why it's not showing up as it should.

 

plshk

Looks like Poleaxe spec counts only axes in spreadsheet, change "Poleaxe" to "2h Axe" in items table to "fix" it
According to sheet, it's better than CE

 

Mardraum

Plshk is right. Shows 24 dps increase for me after "fixing" it.

 

Breakbeat

...

 

Shha

Shivering Felspine isnt better in "real" play then CE simply because of sword spec. Sword spec = 15% more rage with perfect rotation (slam/instant twice per swing). Axe spec is around 3.3% more rage assuming you had 45% crit or so. Sword spec goes HUGE way against rage starvation. Spreadsheets for 2h ignore the streakiness of rage generation , and just check the average rage/sec which is usually enough to keep up rotation. In actual play you play on the chance of getting white crit/wf OR sword spec to keep your rage up and rotation going. Chance per swing with 45% crit of that happening is : 50% crit 20% wf = 60% to not get rage starved with axe and 45% crit 20% wf 15% SS = ~65% with sword.

 

Mardraum

All the things you are talking about are modeled in the spreadsheet, no?

 

plshk

Actually, I'm pretty much rage starving with sword because of nocrit=noflurry=nobf chains even with proc (glancings lolol). My crit rate is around 38% with s3 sword, CE never dropped for me and prolly never will so I'm definitely going for Felspine.

 

ghorghor

Even after i changed the Felspine to 2 handed axe, the swords CE and S3 still show higher DPS with my current gear.. and now people confirm my "stomach" feeling the first time i saw Felspine drop.. that in a flat out Slam Fight it should come out the winning specc

do i have to change something else than in /Items.. only the Name from polearm to 2 h axe? I see myself already bidding on the item so i can make my own parses

if you check my profile

its over there
<-----

( yes i know abou the bracers, need changes, but so close to onslaught bracers im waiting)


[edit] i didnt know i couldnt include my profile in post and received a warning and apparently my punctuation isnt up to the standards used in this forum, sorry but english is my 4th language and i dont write regularly in it ( german french and dutch being my first languages as belgian)