Cataclysm Gear Sheet r14 [2011/11/29]
 

Ok, here we go.
Over the last few days I made a major update to the Rogue Cata Entry-Level Gear.

Its main purpose is to have a quick overview (albeit not 100% accurate, see below) for your own personal BiS list. Not more, not less.


What it features:

• Hopefully all current rogue specific gear.
• Automatic sorting of gear on a per slot basis according to the EP the user has entered.
• EP presets for all three specs.
• Automatic gemming of items, considering EP values and socket bonuses.
• A seperate overview of when socket bonuses are worth gemming for.
• Automatic reforging of items according to EP values (however, in a "dumb" way - see below)

What it does not:

• Calculate your DPS, EP values or cycles. Use Shadowcraft to do that.
• Obey caps. If (spell) hit is your best stat, it will value items with this stat the highest, even if you're long over the cap (a possible workaround is to set the EP value of hit to your second best EP stat, e.g. to haste or whatever).
• Calculate trinkets. They are assumed to have a static, averaged out permanent bonus instead of a proc.
• Reforge intelligently. It is kind of "dumb": if an item has 10 crit and 200 haste, it will reforge 4 crit into whatever stat is the best not currently present on the item. That may change in the future though.

How to use:

• Download the .rar file and unpack it with WinRAR (or any other program capable of handling .rar files).
• Read the "READ ME!" sheet.
• Switch to the "EP Values & Settings" sheet and enter your EP values and choose your spec (or leave them at default). Also you can define here which loot you want to be displayed (or not).
• Switch to "Gems" for an overview of what gems to use.
• Switch to "Sorted List - Reforged Stats" for a sorted list of the items.
• Use the "x" column to select which piece of equipment you have currently equipped (enter a '1' here and don't forget to remove it for my default gear).
• ???
• Profit

If you find any errors or missing items (besides heroic epics - I'll add them later), let me know. Most likely there will be at least a few.



A note to OpenOffice users:
The sheet does work in OpenOffice, but there seems to a bug (in at least 3.3) that the sorted list isn't updated correctly when you change your spec/EP values or loot categories. The EP calculation itself still seems to be correct, but it doesn't re-order (or hide) the items. You can manually force it do so if you remove one of numbers representing the position in the 'A' column and add it again. You only have to do this once - after that it updates the list just fine.
Again, let me know if you know why this behaviour occurs. Or how to fix it. I have no clue.

I've tested it in LibreOffice 3.4, and the bug is not present there, everything is working fine. Might also be the case for OO 3.4, I cannot say.



Current version:
r14 [2011/11/29]

Changelog:

• r14: Updated to Patch 4.3. Still relying on PTR items.
• r13: Updated to Patch 4.2. Heavy optimizations and speed-ups.
• r12: Added all known 4.2 PTR gear. Some internal corrections and fixes.
• r11: Added Patch 4.2 PTR gear. Corrected drop locations.
• r10: Update for 4.1.
• r9: Internal release, added Enchants tab.
• r8: Fixed a few bugs and added missing gear.
• r7: Added heroic gear, added loot selector.
• r6: Added weapon DPS and speed EP estimations.
• r5: Fixed 60% reforge bug. Corrected Embrace of the Night stats.
• r4: Fixed Combat and Subtlety spec not working.
• r3: First public release, added reforging and gemming.
• r2: Internal only.
• r1: Initial release in the Cataclysm Entry-Level Gear List thread.

Great stuff, been hoping for something along these lines while we wait for ShadowCraft to be completed. How do I update the "+-" column once I change which piece of gear is equipped? Using Excel 2010, if that's relevant.

Just a quick note that when you change the preset spec indicator to Combat, you get a circular reference error. The lines that reference cells for gem EP (and I would assume gear EP as well, but I could still be wrong) don't seem to be working properly when you get to the IF statements.

I.E On the row that the gem sheet references it's EP values from, the name of the spec will change but none of the actual values will update from their assassination levels.

@flippinpony
You don't, it should automatically. Maybe not in Excel2000, I don't know.

@Vlos
Correct, first major bug discovered. Currently only Assassination is working, will have to check later today after our raid.

I got it working, I guess switching specs to combat and getting the circular reference error made that field stop updating as well.

Ok, that was a quick fix, should be working now.

It's reforging 60% instead of 40% of the secondary stats.

Yeah, i've noticed that too. Also I think something is up with shoulders did the math manually and Embrace of the night comes out behind Caridean Epaulettes, seems like it was given 10 more agility than it actually has.

Corrected the 60% bug and Embrace of the Night stats.
That's a leftover from when I manually added the socket boni to the item stats in the first release, most likely there'll be others. Keep posting any findings.

For the weapons, would it be terribly hard to add a stat for "DPS", with which you convert the weapon's base DPS into EP? The reason I ask is because simply evaluating the 359 Vicious Gladiator's Shanker based on its inferior stats isn't very accurate. It's ridiculously easy to get right now (5 arena wins this week, 5 wins next week), so should probably be seriously considered as a viable early weapon.

You could maybe also use this to evaluate DMC:H's relative value also, if you convert it's proc into DPS, and then on to EP.

The spreadsheet only has a single group for rings. Wouldn't two groups be preferable?

@Andeh
Yes it would be. I could add a static value for the assassination OH DPS, but that's about it (Aldriana stated that 1 DPS is worth about 1.2 EP for assassination). I cannot do so for any other spec, and neither for the main hand.
In terms DMC:H, see this post by Aldriana for a more accurate overview of trinkets. Note the difference between the two specs, I could only enter either of those into the sheet. Remember that it's no DPS calculator, it only adds things up.

@Deathrind
Actually, in my previous gear sheets (which I didn't publish) I had two enries for rings and trinkets. However I felt this was unnecessary, as you can simply enter your inferior ring/trinket to see the upgrades.

The sheet is missing Nightrend Choker

Nightrend Choker - Item - World of Warcraft

Maimgor's Bite and Windslicer are both offhand only axes; at 2.6 speed it would seem to me that rogues are not the intended target for this gear.

Excuse me for the noobness but I am not able to open and read this. I opened it in excel once but all the fields were just weird symbols.

I saved the file as it is and when trying to open it from Excel 2007 it doesn't even acknowledge it exists. Any help would be appreciated.