Skip to Content
5-19-2010 @ 5:27PM
... It sounds to me like you've taken a huge functionality of the spreadsheet -- the ability to quickly evaluate upgrades -- and thrown it away, in favor of slightly easier setup.I don't play a rogue, so I don't know much about this, but I set up the combat rogue spreadsheet for my roommate, and she's been happy with it ever since. Sure, it took me 30 minutes or so to enter all of the gear -- this is a side effect of her abandoning her rogue for her druid at the start of TOC, I basically had to enter all of her gear by hand -- but once I did that, I didn't have to 'write down' DPS anymore, just fiddle with the drop downs to see DPS changes.If you're wearing more modern gear, this is even less of a concern. Pretty much all the drops from raiding are in there, and at least some of the ICC-5 gear is too. Unless you've got a lot of older gear lying around, setting up the sheet doesn't take that much time, and the effort seems well worth it, rather than manually changing stats to see how it would perform.(Also, doesn't this mess up the socket stuff? How do you know whether you should gem for a socket bonus, if you just have one piece of armor with 17 sockets on it?)
5-19-2010 @ 5:45PM
And on top of that, the trinket includes some fairly complex modeling details for slots like weapons, trinkets, enchants, and various procs like the Ashen Verdict rep ring and Heartpierce.Just copypasting the stats of those items weakens the sheets accuracy considerably.
5-19-2010 @ 5:51PM
This method doesn't work for trinkets/weapons, and I've noted that in the post.Imagine that not only was your gear not on the spreadsheet, but the gear you wanted to compare yourself to wasn't on the sheet either. It's obviously far, far easier to use if you've got relevant gear, but this guide was designed for those rogues who are still working on getting their gear up to the spreadsheet's minimum levels. If you have the time or inclination to program in your gear: by all means, do that. However, you can use the sheet to evaluate a simple gear upgrade in about two minutes, which is useful if you are getting new gear at a rapid rate. As soon as you move to an item on the spreadsheet, you start using that on the sheet, so the problem corrects itself as you gain more gear.
5-19-2010 @ 7:11PM
It actually works fine for most weapons, with the exception of ones like Heartpierce and Black Bruise with a proc. Some trinkets as well, for example Mirror of Truth, can be added if you know the ICD, or at least a decent approximation (the AP from Mirror of Truth as an average, rather than actually factoring in the procs).
5-19-2010 @ 7:13PM
The problem isn't so much that it doesn't work for weapons or trinkets - the problem is that by not taking weapons or trinkets into account you can vastly skew results. Specifically there are a number of trinkets and weapon choices that will have a substantial impact on the specific gearing choices you make.A suggested change to your method: When determining stats for [Chase's Cool Gloves] unequip weapons and trinkets, and then, add them in the sheet normally and select them from the drop downs properly. You'll get substantially better results.
First time? A confirmation email will be sent to you after submitting.
Members enter your username and password.
Enter your AOL or AIM screenname and password.
Please keep your comments relevant to this blog entry. Email addresses are never displayed, but they are required to confirm your comments.
When you enter your name and email address, you'll be sent a link to confirm your comment, and a password. To leave another comment, just use that password.
To create a live link, simply type the URL (including http://) or email address and we will make it a live link for you. You can put up to 3 URLs in your comments. Line breaks and paragraphs are automatically converted — no need to use <p> or <br /> tags.