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






Reader Comments (Page 1 of 2)
Kolo Apr 21st 2009 11:11AM
Thank you so much for this post. 2 years playing a rogue, and I still get confused, especially by these spreadsheets.
SleepySlug Apr 21st 2009 11:22AM
Still find it rather confusing why someone would decide to skip over the new Lightning Reflexes in exchange for Endurance and Throwing Specialization. I find that Lightning Reflexes should now be standard for any and all Combat builds as Melee dmg still comprises the largest chunk of our overall dmg and Lightning Reflexes is essentially a 10% buff to that. (Little less than 10% once everything else is taken into account, I know, but that's still a nice chunk)
Thran Apr 21st 2009 11:44AM
Totally agree. You can eliminate Endurance and still leave one point Throwing Specialization.
http://www.wowhead.com/?talent#f0eb0xZMgV0xcxoruzxRtx
From what I've been reading there isn't that many AoE FoK friendly pulls in Ulduar.
Philip Apr 21st 2009 12:08PM
@ Thran
The build you linked is totally what I'm using except I disagree on Endurance:
Lots of fights in Ulduar involve some type of DoT. And by DoT, I mean anywhere from 2.5k/tick to 5k/tick.
Every little bit of stamina is going to help while you're learning these fights, and your healers will thank you for it later. With the recent nerfs to mana regen, staying alive for 1-2 seconds longer than you might have will be more important than it sounds. Ignis is a good example of this (just one of many in Ulduar). If Cloak Of Shadows isn't up, you'll need all the health you can get to survive the slag pot. The fight has gotten easier since they ninja-nerfed his health overnight on Sunday.
Braundo Apr 21st 2009 12:10PM
Agreed. Considering that the extra haste synergizes with Combat Potency, it's practically required for Combat builds now.
Rainslave Apr 21st 2009 11:32AM
http://www.wowhead.com/?talent#f0ef0exoVboIuVo0xV0xcZ0b
First time poster long time reader , Look at this build let me know what you guys think of this , i use this build now , I used it Uldur and done 5k Dmg , 10 man. wanted to some input from it
Thanks
Rainslave of aggramar
zappo Apr 21st 2009 11:43AM
I'm pretty sure relentless strikes will probably be a better gain then reflexes and close quarters. That may depend on what speed of weapon you're trying to leverage. Disclaimer: I haven't done any theory on that (nor do I use spreadsheets).
zappo Apr 21st 2009 11:49AM
Actually, now that I look a bit closer, it appears you're trying to maximize focused attacks. I'd be interested to hear how this works out for you.
Braundo Apr 21st 2009 12:13PM
This is pretty much the cookie-cutter Mutilate build, except with Lightning Reflexes instead of Relentless Strikes. It's pretty solid, though I'm not sure that the extra Haste is as useful for Mutilate as Relentless Strikes would be.
I'd spreadsheet it, in keeping with the theme of this post, but eh. :)
Lemons Apr 21st 2009 11:50AM
I'll probably just get desperate and figure out how to use Aldriana's spreadsheet, but I think people should know that about Vulajin Roguecraft spreadsheet (also found on EJ). It hasn't been updated for 3.1, but when it is I suggest you drop Aldriana's spreadsheet like a bad habit, simply because Vulajin's is way waaaayyyyy easier to use.
I mean...we have to enter a 1 to select which gear we're wearing? Come on...
darkslide Apr 21st 2009 11:51AM
How come encrypted text came out on Tuesday?
Don't get me wrong, I'm not complaining, its the only post I actually look forward to every week.
I use a spreadsheet regularly but I'm sure this will help many rogues
thanks for a great post :D
Braundo Apr 21st 2009 12:07PM
Excellent post. If more rogues knew how to use spreadsheets, we would see 95% less "which weapon is better" or "how should I gem" posts all over the place.
ghostface Apr 21st 2009 12:44PM
Aldriana's spreadsheets are garbage, even if Vula's is old, it still is 10 fold more accurate.
Jaffarn Apr 23rd 2009 4:18AM
uuuuhhhhh nope lol
Stanglered Apr 21st 2009 1:10PM
Thanks for the post. It's very helpful.
jurm Apr 21st 2009 1:24PM
Spreadsheets are nice, but I personally prefer testing against a combat dummy. A good half hour or so on a combat dummy will tell you which weapons to use in which hands, and which poisons to apply to which weapons. It will also help you practice watching timers and getting your rotation down.
This doesn't mirror fights against aoe trash pulls very well, but aoe trash pulls on a rogue are cake anymore anyway. Use TotT to MD to the tank, run into the middle, FoK 3 times (vigor + glyph of vigor allows this) blade flurry, killing spree, then FoK again. (I pull 7k+ dps doing this on the trash pulls in the spider wing of naxx25).
So yeah, spend some time against a combat dummy. In many cases it will mirror what the spreadsheet tells you; but in may others you'll find that some unorthodox combination actually works better.
John Apr 21st 2009 1:53PM
That burns a whole build of your Dual Spec on a Hybrid trash build that isn't necessary.
Also, I use Elitistjerks.com a lot but what about the other Rogue theorycrafters in the community?
Shadowpanther.net is a great site and extremely easy to use, with builds, gear, glyphs, gems etc etc.
Its nice to see you promote the Jerks I think they deserve it for all the work they do but don't forget about the other stellar roguecrafting sites out there.
Braundo Apr 21st 2009 2:19PM
Shadowpanther is flawed because it assumes that EP weights are constant across all levels of gear. To quote the TTT article:
"Rogue DPS is a complex interaction of a wide variety of stats: strength, agility, hit rating, crit rating, haste rating, expertise rating, armor penetration, and attack power. For example, increasing your agility increases both your attack power and your crit rate; increasing your attack power increases the value of hit, crit, haste, and expertise rating, and armor penetration; increasing your crit rate increases the value of attack power, haste rating, and armor penetration. Because of these interactions, it becomes very complicated to evaluate a piece of gear in a vacuum (i.e. with no assumptions about the rogue's stats before the item)."
Ends Apr 21st 2009 2:22PM
While that may be your personal preference, the only thing a test dummy is good for is for testing rotations. Even this its not a good indication of what your raid rotation is going to look like, simply because both mutilate and combat rotations are crit dependent for combo point generations and you have more crit in raid then out of it. If you can get 24 other people to debuff the target dummy and give you full raid buffs, more power to you. Chances are though minus raid buffs if some "unorthodox combination" does better dps, its not going to translate with raid buffs the same way.
On a side not: Reccomending people spec and glyph into vigor is just collossaly bad advice. It is a PVP talent. If you're using this for a couple niche pulls in naxxramas you are just bad. Here's a tip for you on your AoE packs hit Blade Flurry BEFORE you start your Fan of Knives span.
jurm Apr 21st 2009 2:32PM
Actually, that's my main raiding spec. It's a 20/51/0 build that's served me pretty well on both bosses and trash. I've been running heroics and raids for a while with this build, and the damage increase from vile poisons and improved poisons more than makes up for the loss of relentless strikes. I'm using Instant Poison on my MH (slow), and Deadly Poison on my OH (fast). Now, this pretty much flies in the face of some of the theorycrafting out there, but due either to my gear setup, or my play style, this is what works for me; as verified by targetting dummies, and several raids.
Here's the build (hopefully that link works - would love to have a preview button)