Encrypted Text: How to use a spreadsheet
Every Wednesday (usually), Chase Christian of Encrypted Text invites you to enter the world of shadows, as we explore the secrets and mechanics of the Rogue class. This week, we discuss how to properly use a DPS spreadsheet.Patch 3.1 is finally released, and there is a ton of new gear available for Rogues. The Argent Tournament has some great gear for newly 80 Rogues looking for solid-quality blues and epics, Ulduar has over 800 new items (more than all of TBC's raids combined), and Arena Season 6 should be starting next week. There's multiple new epics for every slot and for every playstyle.
With this sudden influx of new gear, the infamous Rogue spreadsheets have seen a huge increase in download traffic. While I haven't seen any officially updated sheets from our friend Vulajin, Aldriana has published a pair of new Mutilate and Combat spreadsheets. While not quite as pretty as Vulajin's, Aldriana's has all of the major features that you need to plan your gear upgrades. Read on for detailed instructions on how to use a spreadsheet.
Download the spreadsheet:
If you're not familiar with the Elitist Jerks forums, you should educate yourself sometime soon. They're the nexus of some of the most progressive and comprehensive class discussions and theorycrafting around. I wouldn't recommend jumping in with both feet forward, however. Create an account, lurk for a few weeks, and then enter the discussion once you've gotten a feel for how the boards work. They're very strict with their content and posting rules, so please make sure to read their guidelines to ensure that you're falling within their approved posting format.
Once there, I spend most of my time reading the Rogue-specific class discussion board. You can find a lot of great information here about specs, gear, rotations, etc. You'll also be able to find Aldriana's spreadsheet thread, with basic instructions and download links. This will be your first stop: go download the spreadsheet, open it up, and continue reading.
Gear Tab:
There's a lot of information here, but once you get the flow, it will be much simpler to manage. Basically, listed here is every piece of decent Rogue gear available at 80, Ulduar included! At the top of the sheet, we find helms, followed by amulets, etc. The trick is to work your way down this big list of gear, and mark the gear that you are currently wearing. This is also where you'll select your enchants and gems.
The only area where you should edit is the "Equipped" column. For each type of item slot (helm, shoulders, chest), put a '1' next to the item that you are using (or considering). If you are not using a particular item, simply clear the cell (leave it blank). Ensure that you are only marking 1 item per slot, so that the spreadsheet doesn't think you're using two pairs of boots. The score value for each item also gives you an idea of each piece of gear's relative strength. This tab is where you'll spend most of your time.
Settings Tab:
I am using the Combat spreadsheet as a reference, as the Mutilate sheet lacks this tab. In the Combat sheet, we see two options: Instant Poison vs Wound Poison, and Envenom vs Eviscerate. Selecting your choice is done in much the same manner as it is selecting gear: just place a 1 next to your choice and clear the other option. As a rule, Mutilate uses Instant MH and Deadly OH, while Combat uses Wound MH and Deadly OH. With the buff in 3.1 to Deadly Poison, it will be in the offhand for every Rogue spec. Combat can fluctuate between Wound and Instant, depending on if you spec into Improved Poisons or not. Most Combat Rogues will be using Wound Poison, so leave this at default.
Mutilate will again always be using Envenom, as the new Master Poisoner and Deadly Poison buffs make it too attractive to pass up for Eviscerate. Combat can choose between the two, depending on your spec. 18/51/2 is the Poison-heavy Envenom spec, while 15/51/5 is the more common Eviscerate spec. I find 15/51/5 to be better, based on both usefulness and rotation solidity. 18/51/2 leaves Relentless Strikes only partially filled, which can cost you a lot of energy in the long run. For soloing, 15/51/5 is also the stronger suitor. I suggest trying both and sticking with the higher performing spec that meshes well with your needs.
Glyphs Tab:
The Combat sheet again has a few extra options, namely the ability to choose which Glyphs you would like to implement. The Mutilate sheet assumes you're using Mutilate, Rupture, and Hunger for Blood: these are far and away the best 3 Glyphs for the spec. Combat has a few options, and they're mostly fight-specific. On fights where Killing Spree is inappropriate, you can use Adrenaline Rush or Slice and Dice, for example. Typically, you'll want Sinister Strike, Rupture, and Killing Spree.
Talents Tab:
As a Mutilate build, this tab gives you the option to choose between the standard 51/13/7 and a Lightning Reflexes build (Mutilate-Combat as it is also known). It also gives you the choice between Turn the Tables and Master Poisoner, as Master Poisoner is currently a viable choice even in the event that another class is bringing the 3% crit buff to the group. To choose your talents, simply put the number of talent points you're using into the first column. The second column is the maximum number of points for that talent, for your reference. Be sure not to put more talents into this tab than you have available.
Combat is again more flexible in its spec, and therefore you have a few more options for talent point choices. The one key to the Combat Talents tab is the SnD size that you'll see at the top of the chart. This value will let you know how many Combo Points you should use for your Slice and Dice ability. The chart assumes a xs/5r/5e spec, which means that you'll use 'x' combo points on Slice and Dice (s), 5 combo points on Rupture (r), and 5 combo points on Eviscerate (e). When you want to reference Envenom, the Rogue community has fluctuated between (n) and (v), but I see (n) being used more commonly now.
If your SnD Size on the spreadsheet is 3, this means you should always use 3 combo points on Slice and Dice. If it's 2.5, this means that you should use 3 Combo Points, but may be able to sneak a 2 Combo Point SnD in and still maintain your rotation occasionally. The SnD Glyph greatly affects this value, so consider that as well in your Glyphing choices. Maintaining your xs/5r/5e rotation is key to maximizing your raid DPS.
Calcs Tab:
The calcs tab is the one area that you should definitely not touch unless you are 100% certain you know what you're doing. It does provide a very nice chart (at the very bottom) that will show you where your damage is coming from: It will break down White Damage versus Instant Poison Damage, for example. This can help you better understand how your spec is balanced versus another. Against a boss with high physical mitigation, a Poison-heavy spec would triumph, for example (though there are no fights quite like this).
Conclusion:
So now you understand the basics of the spreadsheet, it's time to start plugging in new gear and enchant choices and seeing how it affects your DPS value. The key is experimentation, trying out different gear combos and seeing which returns the highest value. Remember that the sheet does make several assumptions about your gear, talent, glyph, and playstyle choices: it may not apply 100% to the way that you play your Rogue. However, it provides a solid tool to be better informed about how your character works and how gear and talent choices interact with your DPS. Next week I will go over specific instructions for choosing new gear and talents, using the skills that you've learned here today.
Filed under: Rogue, Analysis / Opinion, How-tos, Guides, Classes, (Rogue) Encrypted Text
Patch 5.2 interview with Dave Kosak
Inside an old alt's vault
The latest patch 5.2 news
All of the latest Mists of Pandaria news





Reader Comments (Page 2 of 2)
jerzz80 Apr 22nd 2009 4:31PM
This article brings a tear to my eye. As of this week, I simply do not have it in me to continue with this game.
I joined WoW for PVP. Bad move, I know. I mean, it was cool for the first 3.5 seasons. But Blizz has since destroyed PVP.
I am holding out for Season 6 as a last hope, but I do not have faith in a resurection.
If we do not speak again, god speed.
jurm Apr 21st 2009 2:50PM
okay; link didn't work. Here it is in plain text: http://www.wowarmory.com/talent-calc.xml?cid=4&tal=00532010531000000000000000002520500500350102231005112510000000000000000000000000000
Also, When I say to practice against a targetting dummy, I do not mean that your dps against a targetting dummy = dps in a raid. What I meant to imply is that if setup 1 gets you more dps against a dummy than setup 2 does, then in most cases setup 1 will also give you more damage in a raid setting than setup 2 does.
I was under the impression that Blade Flurry would not affect FoK like it does with other attacks. (WoWWiki's entry on blade flurry predates FoK apparently, saying "Blade Flurry is the only ability which Rogues have to hit more than one target." If I'm wrong on this assumption, feel free to disregard my advice for trash pulls.
And just to be pedantic, I was not recommending that people use glyph of vigor, or follow my spec. I was recommending that they test things out and not consider a spreadsheet as holy doctrine. As others have said, your dps can vary greatly depending on the circumstances and your play style. If you want to know what works, practice and try things out!
M Apr 21st 2009 3:13PM
The gear you want to use can vary greatly depending on group composition and buffs you receive.
The consumables you want to use can vary greatly depending on group composition and buffs you receive.
The talents you want to use can vary greatly depending on group composition and buffs you receive.
... Sense a pattern? How do you determine what's best in all situations? Use a spreadsheet. The Rogue spreadsheets have always been rather more accurate than most others.
A combat dummy is only useful for practicing your rotation, and often not even that (because buffs and group composition can change the rotation you want to use too). More often than not, the training dummy is only useful to help test game mechanics that are used to generate the spreadsheets you don't want to use.
Tranzient Apr 22nd 2009 12:40AM
great job Chase this is what every rogue has been looking for. Very informative, which i think on this blog site is a rare thing. Keep it up.
sfo Apr 21st 2009 8:20PM
I've been wondering for a long time... Why would anyone Combat specced use Instant Poison over Anesthetic Poison?
Mathematically it does more damage.
In ten hits:
ap: 5 x ~250 = 1250 damage
ip: 2 x ~350 = 700 damage
Krypton Jul 8th 2009 7:19PM
IP has a chance on each strike to do 430 damage... AP has a 50% on each strike to do 218-280 damage... Not sure where you 350 came from on IP... o.O
Sonalita Apr 22nd 2009 3:59AM
"Why would anyone Combat specced use Instant Poison over Anesthetic Poison?"
Because AP doesn't scale with attackpower. IP /DP/WP does.
infractus Jul 8th 2009 7:22PM
doesn't matter, combat should be using deadly/wound anyways