Strangely enough, mine recommends gemming Agi the entire way, with ArP=Agi off and 3.2.2 on. It's probably a lot more dependent on your current level of gear than anything (and how much base ArP you got. I have 249 base, but even with Bloodfang @ 343, it still recommends Agi).

I do believe that this is because you do not have enough passive ArP on your gear that with even gems, ArP would not be viable over the stats that you would gain from Agi.

In general, gemming Armor Pen isn't worth doing except when you are able to approach either the soft cap (w/runestone/GT) or the hard cap (w/o them). Looking at your armory, you have neither trinket, so expect to need 500+ more ArP (or a new trinket) before your gem reccomendations change.

Could it be possible to include the [Relentless Gladiator's Right Ripper] in the Combat spreadsheet?

Bottom of the Sheet there is a tab 'Gear', you can manually enter in the stats. If the tab is not shown for whatever reason go to the top menu: Format>Sheet>Show>Check Gear


My question: I am trying to add a 20haste gem in the sheet to mess around with...I can add the gem, the 20haste stat, but where do I get the value for it at...just my current haste ep multiplied by 20?

If you're adding the gem properly, fields like value should be automatically calculated. The easiest way to properly add the gem is to copy a row like the one for say, a 20 hit gem, insert a new row in the middle of the existing range of gems(this part is important), paste in the copied row, and change the name and stats.

If you have 1.3 beta 4, in the settings tab there's a option for using 3.2.2 arp conversion rating.

EDIT: 1.3beta 4 download link is in this post: http://elitistjerks.com/f78/t39136-c...1/#post1388377

There is an option on the settings tab for the ArPen change.

Using the latest spreadsheet, a weird 7 / 51 / 13 Spec with Serrated Blades and Blood Splatter comes out on top of the DPS, beating my "standard" 18 / 51 / 2 Spec by around 50 DPS.

However, this seems to be nowhere noted as "the best" spec for any situation or gear (I have two 196DPS weapons, sword/axe, and 4/5 T8.5).

Maybe this information will be useful. I recently picked up [Tempered Vis'kag the Bloodletter] recently. Today I sat at a Lv60 dummy and auto attacked. No poisons. No gear. Just the sword.

Here is the parse for that session:

World of Logs - Real Time Raid Analysis

Spell	Damage	%	Hit #	Hit Avg	Hit Total	Crit #	Crit Avg	CritTotal
Melee	1,167,421	84.6	1,808	496.4	897,534	228	1,183.7	269,887
Fatal Wound	212,304	15.4	95	1,784.3	169,511	10	4,279.3	42,793

I downloaded the Beta spreadsheet and I am having trouble using it correctly. Your previous versions would include a cycle example like 2.1s/5r/5e but this current version doesn't seem to have that. I know that with the new gear and people breaking their t8 4piece set bonus, rupture is getting thrown out the window from DPS rotations. However, in the earlier version of your spreadsheet, my DPS was around 8140, and with the new spreadsheet it drops down to 7700 (I didn't use the ArP change to 3.2.2, so theoretically, my DPS should remain the same from the older version to this one).

The reason behind this drop in DPS is that the spreadsheet implicitly assumes I don't use rupture in my rotation. In the settings tab, there is no mention as to a preferred rotation.

So unless I'm completely mistaken, could it be possible to re-include rupture in the base rotation, depending on if the person has 4piece t8 equipped. Sometimes I see "low rupture rotation" appear, but that doesn't specify if I should be doing 1 2 3 4 or 5 combo point ruptures, or if i should be keeping it up the entire time or only when I have some spare combo points to dump (if there is such a thing).

As always, thanks for the work you put into this.

edit: received a warning about signing my post, my bad, wasn't aware of this rule

(I started to put this in the questions thread, but it tied so much to Aldriana's spreadsheet calculations, I decided to post it here). I've had gear discussions with other rogues lately, and the idea of limiting crit% for combat has come up repeatedly.

Basically, they've told me that because of the nature of diminishing returns on Crit rating, having anything over 45% or so unbuffed, as a combat rogue is pointless and starts to become "wasted" stat allocation. They feel that hitting that point unbuffed will get you up over 50% raid buffed, and at that point, having more crit is significantly less effective and gearing/gemming for other stats makes more sense.

MY understanding, however, is that this point of significant diminishing returns is actually quite individualized, based on gear, and simply saying "anything over 45% crit is going to be wasted" is oversimplifying. For instance, I'm currently running Hack and Slash with Death's Choice (245) and Blood of the Old God for trinkets. My in-game crit chance is 38.5%. Aldriana's spreadsheet shows me having almost 47% "MH Base Crit Rate" with almost 65% "White Crit Cap" - *I* understand that until I hit that 65% cap raid buffed, crit isn't really "wasted."

Now Paragon procs get me about 5 1/2 percent alone taking me to right at 44%. Raid buffs get me up in the low-mid-50's. That's still significantly below my "White Crit Cap" of 65% - so shouldn't my PERSONAL "ideal unbuffed crit %" really be that 65% minus trinket procs and what I can expect from raid buffs (and I realize that number will change with different gear, hit rating, expertise, etc.)? Am I missing something stupidly obvious?

Either way, even if there's more to the calculation, if Aldriana's sheet is showing 65% being my crit cap, 45% seems low as an "ideal" unbuffed crit % for combat. Am I right?

Thanks for any feedback,

Gawwin

It depends on your expertise and hit rating. The higher they are (pushing dodges and misses off the table), the more you can crit. The spreadsheet takes this into account when it lists your crit cap.

45% might be a good rough guidelines in the case for someone who has no expertise and abysmal hit rate, or someone with a Dark Matter; but you're right, it's an individual thing. The value of crit does not lessen until you hit the crit cap, at which point it drops drastically.

45% unbuffed is a good 'warning light' number at which you're going to really want to carefully watch what procs you have on your gear (trinkets, mongoose, etc.), and pay close attention to what your crit cap is and how close you are to it. The specific number of course, varies pretty wildly with gear though.

This probably has to do with the default Glyphs and Spec. Make sure to spec out of imp. Eviscerate and into Blood Spatter, and switch from Glyph of Eviscerate to Rupture. In combination with wearing 4pc T8, this should result in the sheet recommending the so-called "High Rupture" rotation, which, as far as i know, is the one resembling the old 3 Snd, 5 Rupture, X Evis rotations you are talking about.
This should also get your calculated Dps closer to what it originally was.

However, as Aldriana has noted several times, those numbers of combopoints are rather average values for the cycles you should be performing than guidelines for what you should actually be doing in a raid situation. Note that in an ideal situation, you would always want to use your finishers only at 5 CPs in order to maximize Damage per Energy. As this is not really possible without wasting great amounts of CPs, the use of abilities for a rogue works like a priority system.

E.G. a "High Rupture" rotation means you keep up SnD as your nr. 1 priority and Rupture as your nr. 2 priority, if there is enough time left on SnD. As a sidenote, I guess the definition of "enough" is extremely vague at this point and may also depened on the amount of energy you have in that exact moment and the procs that are active, because sometimes it might be worthwhile doing a 1- or 2-point SnD (low Dmg per Energy), if that enables you to get off a 5-point Rupture with a lot of procs up just before that.
Eviscerate is your nr. 3 priority and is only used when you can make sure not to let SnD drop and still be able to reapply Rupture quickly after it expires. The difference between "High Rupture" and "Low Rupture" is, that "High Rupture" in some cases would still use Sinister Strike even if at 5 CPs to prevent energy capping while waiting for the previous Rupture to drop (in order to reapply Rupture directly afterwards, thus increasing Rupture uptime but wasting CPs), whereas "Low Rupture" would simply weave in an Evis if at 5 CPs with Rupture still running and in danger of energy capping.
This results in the "Low Rupture" behaviour being modeled at around 70% Rupture uptime in the sheet and the "High Rupture" one at about 90% uptime.

Sorry for the wall of text and hopefully I didn't mess up, but this is how i interpreted Aldriana's posts concerning the new "cycles" in the spreadsheet. Take a look at posts nr. 1221, 1244 and 1250 if you would like to read it in Aldriana's words.

Just a random little thing.
I've been gemming ArP myself and gotten up to around 600 + Mjolnir, one of my mates suggested me to pick up serrated blades and go back to agi gemming because SR gives 640 arp by itself. Even though this talent increases Rupture damage aswell, that I don't use at all in this 'ArP spec' would it be worth it? Thinking of a spec like 7/51/13 with imp evis.

A quick note about what I posted a few lines up. All though raid buffs do not affect the bonus damage, Armor Penetration does. This makes sense since the bonus damage is affected by how much armor a mob has. Around 600 ArP, your base damage on Fatal Wound hits for about 2150+ on a regular hit and crits for 5300+. I'll be reporting a log as soon as I can with the procs and 600+ ArP.

Would it be possible to add a field for "improved flasks" with alchemy?

Just fake it with a LW enchant or 2 ring enchants.

Still not an answer to the question, including mine regarding this 7 / 51 / 13.

The spreadsheet suggests it's a DPS increase... but is this really possible as there are officially only three viable combat specs?

Yes this works, and there probably are more important additions that need made but I agree the option should probably be added at some point.
The fact that multiple people ask about it, and it has to be explained multiple times how to "work around" it, seems to be good enough of a reason for what should be a simple addition.

According to spreadsheet, Classic 15/51/5 and 18/51/2 are within 5 DPS difference for my current gear, while 7/51/13 pulls ahead by ~50 DPS.

Considering the fact that my recommended rotation is "High Rupture" with 4pcT8, I'd say that 7/51/13 is favorable not because of 640 Armor reduction from 3/3 SB, but because of 30% Rupture damage gain from 3/3 SB. So I wouldn't gem ArP in that case.