Combat and Mutilate Spreadsheets (Obsolete as of 4.0.x) - Page 118

Liquoid · 11/20/09, 7:16 AM

Originally Posted by poptya

Is there a way to imput the crit gained from skinning into the spreadsheet?

Imitate 40 crit by creating two BS sockets in bracers/gloves and fitting two +20 Crit (Smooth King's Amber) gems into those sockets.

Naganuina · 11/20/09, 10:03 AM

Originally Posted by poptya

Also in a question on spec. All builds except mace/dagger put a point in endurance, instead of unfair advantage. While the number of things to use an aoe that can be dodged to proc unfair advantage is minute (the trash in voa comes to mind), wouldnt this actually be best for dps? At the expense of around 275 hp of course.

If you are not putting any points in CQC you need to put in a filler point to get to the lower weapon specs(actually you need it just to get the the 15 point talents), mace currently uses one point of CQC since there are no OH maces in this tier.

zeroarmy27 · 11/20/09, 5:57 PM

I'm wondering if anyone else has come to this point, or if I'm seeing something strange.

My main spec is the common 51/13/7 mutilate build. I'm switching between this and ruptureless combat with a mace/dagger. I switch from the tier helm to hood of lethal intent and my 232 mace has a 20 ar.pen gem in it. It's saying this is all I need for ar.pen. Is the sheet taking into account the 15% from maces, or is there that much passive ar.pen on the 245 gear? I also use Mjolnir Runestone in both sets for lack of a better mutilate-oriented trinket.

Both specs yield about the same dps for me, but some fights in TOC really favor the cooldowns a combat spec offers.

You can see both of my armor sets on wow-heroes.com or I can upload both spreadsheets if needed.

Edit: It is taking maces into account, and working correctly. If I change to the Bloodfang Hood it suggests replacing the ar.pen gem with agility.

Nihil1ty · 11/20/09, 7:32 PM

Is there an updated Mutilate spreadsheet available since the Mutilate_1.1 sheet? I might have overlooked it searching through the forums.

thelasus · 11/21/09, 5:27 AM

i am using the beta 4 spreadsheet and trust the outcomes of the sheet normally but now i ran into something i cannot explain myself:

Generally said, the spreadsheet recommends to gem for ArPen and use a ruptureless-cyrcle. I have 791 ArPen from gear and gems and 327 hit rating.

i use Bloodfang Mask at the moment but have now the emblems to buy myself Hood of Lethal Intent.

That means that i gain 8 agi, 62 stam and 82 hit rating. I loose 2 AP, 58 crit and 2 Arpen without the gem and socket bonus. The socket bonus would mean a swap from 8 Arpen (EP value 2.1078) to 8 Agi (EP value 2.0834).

And now where it gets strange for me: The spreadsheet tells me that the swap would gain me 123.07 dps.

Could somebody please explain me why its such a big improvment?

edit for typo

Ericmelvin · 11/21/09, 7:05 AM

I would highly recommend downloading the latest (non-beta) version of the spreadsheet and see if that fixes anything.

Rahdik · 11/21/09, 9:13 AM

Bloodfang Mask had it's stats buffed either just before or just after the patch was released and the beta sheet may have the wrong stats.

Mortred_ · 11/21/09, 9:23 AM

either way, buff or not buff, a 123 dps difference between two ilvl 245 items with almost exactly same stats is pure nonsense. Are you talking about DPS or EP?

You should check carefully what you are doing there...

thelasus · 11/21/09, 9:29 AM

Thanks for all the response,

i checked the gear info in the spreadsheet and Rahdik was right. The information is wrong there. I checked if the hood is right there but for some strange reason, i didn't check for the mask before.

I corrected them and now the spreadsheet shows a reasonable dps-improvment of 19.99 if i take the hood.

Thanks again all for the help.

StoicRoivaS · 11/22/09, 5:28 AM

Ok, this has been bugging me for a while now, so as a last resort I guess I'm asking for someone with a bit of free time to check my sheets and spot what I'm missing. My current gearset is with 2PT9 and can be found on this sheet: Current. After picking up two more trophies to make my 4P bonus (and swapping boots, as I will explain) my sheet looks like this: New.

First thing to note is that swapping chests (Vest of Shifting Shadows (Heroic) for Garona's Breasplate of Triumph) trades an allotment of 67 arp for 82 hit (over poison cap atm) but trading helms (Mask of Lethal Intent for Garona's Helmet of Triumph) trades 82 hit for 74 expertise (at exp cap). So right off the bat the net effect is trading an arp allotment for an entirely useless expertise allotment, this in itself should be a dps loss. To offset this I swapped my current boots: Acidmaw Treads (Heroic) for a set without an expertise allotment: Icewalker Treads. Note that this swap traded 51 expertise for 59 arp. So the net effect of swapping to 4PT9 from 2PT9 and swapping boots to avoid being largely over the expertise cap is approximately 8 arp for 15 expertise. Now this is slightly misleading because 10-man HM gear tends to have an extra socket as it's reward, and other stats are off by a couple points here and there, but the global effect is a small bit of arp for some expertise (which is entirely wasted). My problem then is thus: the sheet representing my current setup is about 35dps ahead of the setup that swaps to 4PT9. So for sake of simplicity, lets just say I'm losing 8 arp in the end, I don't think it takes a genius to realize that 5% crit on sinister strike is worth far more than 8 arp rating.

To help you find my error, here are some things to consider: buffs should be identical, the "New" sheet was a copy of the current. Specs should be identical (and shouldn't change, because weapons aren't changing). As I pointed out, 10-man HM gear tends to be better than 25-man normal gear by a socket, so there could be a built in difference of two sockets that the current setup is "ahead" by, via virtue of 10-man HM gear being better than 25-man normal mode gear, but that's at the very most, and again, isn't worth the 110+ EP points that the 4P bonus is worth. The "current" sheet is sitting at 735 passive arp and the "new" sheet was slightly regemmed to bring it to 733 passive arp, so it's not a matter of forgetting to get back to the softcap. The two new tier pieces do have inferior socket colors, which does slightly matter, but again, that shouldn't trump the value of the 4P bonus. The "new" gear does however have a better blue socket bonus (by 2 agility) so that's a small factor in it's favor.

Those were essentially all the things that came to my mind to try and figure this out. I can see them being close, that makes total sense. Picking up a few points by virtue of 10-man HM gear being better and swapping a small handful of arp points for (entirely wasted) expertise is definitely worth something, but my gut tells me the bonus is worth more than that, and shouldn't be losing at all, especially by 35 dps. I appreciate any help anyone has to offer here. I've been over and over this and I can't figure it out. I even redownladed the current sheet and filled it in from scratch to rule out any settings bugs that may have gotten saved. Again, if you have the time to help me with this, you have my thanks.

sp00n · 11/22/09, 7:58 AM

Unhiding the Calcs sheet lets you see the stats :

Stat	Old	New	Diff
Str	20	20	0
Agi	1548	1454	-94
AP	2026	2021	-5
Crit	567	598	31
Hit	326	324	-2
Exp	138	161	23
Haste	241	241	0
ArPen	735	733	-2

So you're essentially trading 94 Agi for 31 Crit and 23 Expertise.
Note that you're already expertise capped in your old gear (10 through talents + 16.83 through gear), so all the Expertise you gain is utterly wasted (10+19.64).

AEP wise, you're looking at ~169 gained vs ~209 lost (already including the 4T9 bonus).

StoicRoivaS · 11/22/09, 5:53 PM

Originally Posted by sp00n

Unhiding the Calcs sheet lets you see the stats :

Stat	Old	New	Diff
Str	20	20	0
Agi	1548	1454	-94
AP	2026	2021	-5
Crit	567	598	31
Hit	326	324	-2
Exp	138	161	23
Haste	241	241	0
ArPen	735	733	-2

So you're essentially trading 94 Agi for 31 Crit and 23 Expertise.
Note that you're already expertise capped in your old gear (10 through talents + 16.83 through gear), so all the Expertise you gain is utterly wasted (10+19.64).

AEP wise, you're looking at ~169 gained vs ~209 lost (already including the 4T9 bonus).

Didn't even know those were there, would have saved me a lot of hand calcs trying to do essentially the same thing. I guess that does explain it, though certainly not what I expected. I guess they were just a little too favorable itemizing 10-man HM loot. I could swap my throwing for a hit one and drop some exp but that would probably just bring me closer to even instead of a net gain. Thank you very much for your time.

Onodrim · 11/23/09, 2:32 AM

Originally Posted by Nihil1ty

Is there an updated Mutilate spreadsheet available since the Mutilate_1.1 sheet? I might have overlooked it searching through the forums.

The latest available version of the mutilate spreadsheet is the Mutilate_1.1_(beta_2). For future reference, if you go to rogue forum's front page, you can click on the red attatchments icons immediately to the left of the last post field of a given thread to recieve a pop-up box displaying the documents attached to that particular thread. That way you don't have to search through a 71 page thread for a beta update that may or may not be there.

madman · 11/23/09, 5:52 AM

I'm getting a bit confused with all the talk about about ruptureless cycles and ArP. My gear is close to everything ilvl 245, except for trinkets (check link in profile). Yet in the Combat spreadsheet, a rupture cycle always comes out ahead of eviscerate (yes I also changed the spec and glyphs). Agi is still way better than ArP. And in addition, the 18/51/2 comes out ahead of 15/51/5 for the rupture cycle. All of this seems counterintuitive to what is being discussed here, so I'm wondering if I'm doing something wrong or if you are all assuming even better gear for the specs/cycles you are talking about.

robfang · 11/23/09, 8:18 AM

I don't know that post you are specifically referring to, but the ruptureless cycles are either concern mutilate builds or the new item tier for combat builds (ilvl 264). I have not tested for but maybe ruptureless cycles are viable for ilvl 258 best in slot items too. For the current combat builds however (with ilvl 245 items), rupture is still included in the cycles.