For the other stats (apart from DPS) you could always put arrows beside the difference to the saved version and color the number. Here is how to do that in Excel ...

It'll put the ▲ or ● or ▼ depending upon whether the stat is increased, the same or decreased. You can use arrows or other symbols. Personally I like this as it shows the info, but doesn't give it a flashing color level of importance (and you could also try changing the text color also).

My turn!

I have taken a somewhat different approach.
- I don't care if my DPS is shown as 2139.84 or 2139.97. Therefore I let it show only whole numbers in the main DPS cell.
- DPS and Cycle are prominently placed, because that is what matters.
- DPS details are still visible, but placed to the right, out of the main focus.
- Splitted into DPS stats and Defensive Stats that help you to survive.
- I also borrowed the SnD & Rupture Uptime, which I think is a good idea.
- However not the Energy usage / Energy consumption, which I don't regard as that useful.
- No seperated Mainhand/Offhand. Not that important either IMO.


-> Sheet

Looks quite decent.
The MH/OH split i reckon is mostly important for human rogues or combat fist/sword spec. As well as using sharpening stones which improve crit rating.
I was considering splitting the offensive / defensive stats as well, it should definitely be attempted into the final version.

Just curious ... I picked up Hourglass of the Unraveller last night and plugged it in the spreadsheet, and it doesn't have any stats related to the proc. I assume it should, since Mongoose procs and the spreadsheet adds agility for the proc. Has this been left out purposely, or should there be something added in AP column for it?

I am using the spreadsheet to compare my rogue with my guild's "best" rogue. The other rogue is very good, but talents are not optimized for DPS, dagger combat spec-ed and has multiple +crit gems. The other rogue is geared much better than me, but because of this spreadsheet my rogue is theoretically neck and neck. I'll pass the other rogue's DPS in a week here when I get my new arena off hand sword and 'goose it!

A wonderful Good day to you all,

First off, I'd like to thank the community for this spread sheet its helped me optimizing my Rogue for some time now, but I believe I've found a small bug. Not with the sheet itself but with one item.
I very well could be wrong, but it seems that Grimgrin Faceguard is not showing the socket bonus even though the proper jewels are being used.

Has anyone else run into this?

Thank you very much and keep up the good work

Sometimes it happend In my raid that we just tank with a feral or a prot pala and a off warri keep sunder up.
i think about speccing imp expose armor and trying a cycel based on imp expose and snd,
the personal benefit of -475 armor could be better than rupture with high-end-gear
and the benefit for the other melees is very high too.

if i take my raid gear + standart buffs the sheet say´s:
2992.98 dps (2072,18dps white + 715,25dps sinister + 114.51dps Other + 91,04dps Finisher)

if ill add -475 armor(expose/snd cycel is equal too rupture /snd cycel in energy cost´s) and change 4/5 poisens to 2/4 poisens (2/2 imp expose dont count in the sheet yet) i got this :

3104,40 dps (2158,17dps white + 744,93dps sinister + 109,94dps Other (+) 91,36dps Finisher)


as i know SnD count as white dps so finisher dps ist only rupture and 1 evi every 5 min (ar)


so we got a diffrence 111,42 dps
but i loose my rupture dps ~91,36dps~

so i got a personal benefit of more than 20,06 dps (+1 evi every 5 min)

and -475armor for my raid witch is a lot dps im sure ^^
i get all this numers with 6200 boss armor

what you think about?



and another question if its not too difficulte is it possible too add imp expose
too the debuffs and maybe add some cycel´s with expose?



thanks for your good work with this sheet.

Elfila-
Yes, cut probably should be documented if it's not, although in the not too distant future, that terminology will be going away. In terms of the abbreviations, they are at least standard for these forums. Snd cut means that you will be cutting your SnD cycle short (refreshing it before it expires).

In practice what you want to do is let a little energy regen prior to the slice (in order to give you a buffer for next cycle) and "cut" the SnD cycle with a safety margin before your energy caps. The last thing you want to do is lose energy, but this type of cycle means using all the SnD time isn't important.
-----
Benybenson-
There has been some thought given to adding EA cycles, but that will be a fairly significant addition. I cannot give a timetable to when or if that might happen at this time. Adding it as a debuff option is more doable. The buffs section is in desperate need for a revamp, and that should be easy enough to add when I get to that revamp (if not before).
-----
Whysky-
I can't seem to reproduce that issue. Are you using Excel or Open Office, and which version?
-----
Morgan-McG-
The next version will have vastly improved modeling for the Hourglass which will have stats in-line. I already have that implemented in my working copy. So far I have the basics done. Still need to go back to the older enchants like Crusader and implement new discoveries about the SSO Scryer Neck proc as well as make one-more minor tweak to DST. Hoping to get a version out by Sunday or Monday.
-----
In terms of design, I think I like sp00n's. It's easy to read and well organized. I guess OH stats aren't really so important, so just using main hand is probably fine to keep it simple. More detail could be given in a revamped item compare sheet if I ever find the time to work on that. Of course some things probably won't be immediately implemented (like Armor or Parry) but I see no problem allocating the space for them ahead of time. Since the item data doesn't currently have these stats, those will have to wait until they do.

Thanks to all of those that submitted designs. We had some very good ideas. The Rupture and SnD uptimes are a very good idea for an addition.

As to arrows and ups and downs vs. saved DPS, I'm inclined not to add that at this time. I worry that it might lend credence to the idea that there might be an ideal hit or crit rating or whatever. Although most of us know better, I think we've all seen enough posts related to these misguided concepts. I also think it would distract from what's really important as sp00n so astutely pointed out, namely your cycle and expected DPS. Now, if someone wanted to do a redesign of the item compare sheet, I'd be all for that level of detail or more on that sheet. As it stands right now, I'm not sure that sheet is all that useful at the current time.

Maybe you could just add a comment on the cycle cell explaining what that term means, just like currently with the DPS upgrades (something like '4 points SnD, 5 points Rupture, if energy at ~60, refresh SnD regardless of remaining uptime').
And maybe even add the two closest alternative cycles in that comment as well.

I do have a question about the proposed Crit Red box. What do people think? Should Sleight of Hand be taken into account here or just Resilience. This is tricky because Sleight of Hand appears to only affect melee and ranged attacks while Resilience also affects DoTs. I'm leaning to ignoring Sleight of Hand but I'm not firmly set on that yet.

If it is really "crit reduction", I'd include the talent. Either that or put a comment on the box that says "does not include crit reduction from talents", or else label it "Crit Red. (from Resiliance)".

@Dontmindme
I'm using a German Version of Excel 2003 sp2.
I just changed the helm to Cursed Vision of Sargeras and back to Grimgrin Faceguard, now its working.
Must have been something with armory import from the europe side. Im very sorry about waisting your time.
Again, thank you very much for this spreedsheet its helped me alot.

Yeah, the Ringstats list ended up off one. I posted a 2.0.4.7a with a fix for that and a couple other missed bugs.

I'll take a quick look and make sure I'm not missing something in that Macro which might have caused that just in case. Just not sure if its a weird version specific Excel thing or a bug on my end.

I would like to make a suggestion next to the nice stuff you all are thinking about right now...

In our raid we always have our "melee" group and 3 of them are LW. We're planning on spamming Drums of Battle on boss encounters, so we have a 75% uptime. Is there a possibility to edit the sheet so u can fill in the amount of drums? Then there can be determined how much uptime you have.

Use the drop down menu just to the right to specify number of drums.

New version up...
New cycle model is progressing but not in this version.
The big features are:
1) The revamped Talent page. Oh, there might be problems with the Importation from another spreadsheet, I'd make sure Talents and Options are unchecked. You can reload them from the Combo boxes.
2) Vastly improved proc modeling with optimization through the AEP macro. Instructions for OO users on the Optimize page.

Just in case, I'm leaving some past versions up, just in case I missed something. New cycle work is in progress, but not yet live.

2.4.0.8 & 2.4.0.8NA & 2.4.0.8OO

2.4.0.8 dmm

Note: Extensive changes have been made. There could be bugs, please report such
on the Elitist Jerks forums in the Class Mechanics - Rogue DPS Spreadsheet thread.
Previous version is left available just in case

Added
Beaming Fire Opal
Bright Crimson Spinel (Quest ID)
Champion's Fire Opal
Defender's Tanzanite
Enduring Chrysoprase
Enduring Deep Peridot
Enduring Seaspray Emerald
Enduring Talasite
Eye of the Sea
Facet of Eternity
Flashing Crimson Spinel
Flashing Living Ruby
Glimmering Fire Opal
Glistening Fire Opal
Regal Nightseye
Resplendent Fire Opal
Splendid Fire Opal
Stalwart Fire Opal
Steady Seaspray Emerald
Thick Dawnstone
Thick Golden Draenite
Thick Lionseye
Option button on the Talent page to turn off Buffs.
Option button on Gear _ Buffs page to turn off defensive items from the lists (only works for gems right now)
Proc Optimization routine added to AEP button.
Instructions for Open Office "self" macro on Optimization page.
Righteous Weapon Coating (as 15% proc rate, 45 sec hidden cooldown)
Inspiring Presence (Draenei buff)
Heroic Presence (Draenei buff)

Changed
Row 75 now labeled "Talents" to hopefully help avoid confusion.
Proc mechanics now implemented and/or improved for many proc effects (see optimization page)
Remodeled Talent sheet
Tier 4 sample gear set
Remodeled Stat block
Improved Combobox functionality (Talents/Options)
Shattered Sun Pendant of Might (Scryer) now has increased damage with spell damage buffs
Mutilate now considered two instants for proc mechanics
Windfury now has a buff component (except finishers)
Ferocious Inspiration reduced to 94% uptime from 100%

Fixed
Crimson Sun gem now spelled correctly
Fixed bug in Leg socket fit formulas regarding 3 sockets where 3rd socket was checked twice instead of 1st.
Fixed various mislabeled gems in terms of quality.
Consecrated Sharpening Stone now spelled correctly and linked to mobtype.
Removed
Delicate Fire Ruby

Interesting...
Reminds me of the old Spymistress's Wristguards which had a socket bonus which didn't match the tooltip. It was giving attack power instead of dodge when socketed for the longest time. I remember trying to find where my spreadsheet was wrong (not this one, I had my own primitive one prior to finding these forums), only to figure out it was the wrists. Doing a web search it appears you are correct.

And the second, small fix for those looking for extreme accuracy.
I also discovered a small calculation error from what I intended on the Optimize page. For all the formulas in column D involving internal cooldowns,
where it reads =##/(##+1/..., it should read =##/(##-1/...
Amounted to a little more than a 1 dps difference with the default gear set.

Ohw, I didn't see that, srry for that

Importing from a previous version does indeed not work. As i immediately get the DPS to show up as !value, N/A.
Disabled options and talents, then import works ok.

I'm not sure what happened to the font on the talents page top display, as the font looks very weird. Could you set the font for the talents page the same as the one on the gear page?
Edit: Looks like it's Verdana which is not supported by Mac OSX, it should be set to arial like the rest of the sheets.

Are cells G7-H7, the chance for enemies to miss you?


I never use that sheet either, it's confusing and pretty much everything I need can be obtained trough the gear_buffs sheet.
A few extra fields in the top would make the gear_buff sheet even better. If you were to reduce the detail or move parts of the gear_buffs sheet to another part of the document this would probably reduce the overall usefulness. The merger or the buffed / unbuffed dps helps make room for some more information, thus it'd be nice if that space was utilized. The gear part is for most of us the main "working area" to improving a gear setup. As such i feel that splitting the MH and OH may be a good improvement for fine tuning the theorycraft certain races or odd specs would have. Such as fist/sword.

The talents page may not need a large amount of detail, but the gear_buffs page should definitely be expanded to include any useful information available. This is a theorycrafting spreadsheet after all.



Also from earlier in the thread, while outdoor buffs might not always be worth the effort to repeatedly obtain, encounters such as brutallus really push the limits of raid DPS. Since warlocks are now able to summon players straight to a boss inside the raid it has become a lot more feasible to use outdoor buffs. Perhaps the following buffs could be added to a future version of the sheet :

* Polished Armor : +10% armor, 30 minute duration. While not a DPS buff it can be beneficial under the right circumstances.
* Energizing Spores : +30 to all stats, 5 minute duration.
* Hellscream's Warsong : Increases hitpoints by 300. 15% haste to melee attacks. Horde only i think. Lasts 1 hour.
* Glowing Blood : Only 1 minute duration, but increases agility by 10%. This one is questionable due to the short duration. And, as the buff can not be reapplied during the fight it'll be impossible to model. Perhaps a field for the expected fight duration may need to be needed.
* Vibrant Blood : Like glowing blood, only it's even more questionable. Unsure whether it affects poisons at this time.

Also since fortitude is included, perhaps : Blood Pact should be included as well. It can be improved by talents.
Same for Ancestral Healing. Though it's use is fairly limited.

Furious Howl, while most hunters will not use this anymore, it is still available in game. For the sake of buff comparison this may be useful to add. The buff gives +45-57 damage every 10 seconds.

[Potential Bug] In the latest version 2.4.0.8 the [Hourglass of the Unraveller] appears to have the proc 'value' doubled via having a calculated 20-sec long proc vs. the actual 10-sec proc.

The apparent fix is to change the 20 to 10 in the Optimize sheet in cell D12.

Moreover it says 'Hourglass of the Unraveler', missing an L. *nitpick*

And I wonder, what does the row 'Used' stand for? Are these values actually used in the sheet or were they calculated by some other means, like in the old sheet?


// Edit
Moreover, I couldn't really follow the instructions on the right side. May be because I have the German version of Excel, and there is no Paste Special (only something like Paste Contents). However, reading those, I now think that the 'Used' column is only for OO and does nothing for Excel, is that correct?

Cells M8-Q8 on the talents sheet have the opposite conditional formating as cells A6-D6, while displaying the same information. Cells M8-Q8 go green for a DPS decrease, red for a DPS increase. This seems backwards to me.

However, I'm also seeing that cells M8-Q8 are highlighting the "saved DPS", so maybe that's why they have the opposite color scheme? That's somewhat confusing. I think I would advocate moving cells M8-Q8 up one row (to row 7), including another "difference" cell below them, and then using the same coloring there as is used to the left.

-----------------------

Are the hit/missed cells working right? For my gear and build, I show "hit" as "30.23%" and "miss" as "4.99%". What's up with that exactly? The cap should be ~28%, which implies that something isn't getting tallied right.

-----------------------

As an aside, I prefered the prior color coding of the DPS change cells: Bright Green and Bright Red. The more subtle red and green colors used now make those cells harder to pick out of the crowd.

-----------------------

And one additional point of note: For me, in a late T5 gear set, [Dragonspine Trophy] is falling slightly behind [Shard of Contempt] and [Ashtongue Talisman of Lethality] for my Mutilate build, and it comes in only 3 DPS ahead of [Warp-Spring Coil]. This should be of interest to other Mutilate rogues, as it means we should be targeting a different trinket set than Combat rogues.