those are fake.

Woot glad to see tons of improvements in the sheet, thanks dude
Yeah I faced same problems but they will be gone in the bugfix, so leaving a question about upgrade button... currently it is very useful to compare items without sockets, for example rings, weapons, but useless for about everything else... comparing 2 items - one without any socket and one with 2 yellow, 1 red for example can be nasty but can be done by an educated guess. Giving 3 boxes where we can select prefered yellow, red and blue gems, item dps can be pretty correctly calculated by brute-force regemming it too, for example item having 1 yellow and 1 blue, socket value +4 AP will give best dps if socketed with 2xyellow and screwing up socket bonus.Yes, it will slow down upgrade search function but who cares for few seconds more if it can save you from downgrading your item Also, when upgrading, the metagem requirements should be considered filled all the time - tweaking the gear to meet them is easy and can be done with very little dps impact, but can mark vastly better item as tons worse. For example in your default gear list, changing shoulders to Wastewalker Shoulderpads, switching the blue gem to meet the meta and then pressing "upgrade" does not show Shoulderpads of the Stranger as an upgrade
I know met req can be switched off, but just think it should default to off during upgrade search

Apologies for going off-thread a tad here, but I really like the new spreadsheet and am frustrated by the OpenOffice (in my case NeoOffice) incompatibilities and can't help but feel there might be a better solution to the problem. Has there ever been any thought or effort to making this a web based application instead of a spreadsheet? Sure, the incompatibilities will probably still exist given the plethora of browsers available, however applying the basic "Keep It Simple Stupid" rules to it would eliminate the most annoying problems.

With the introduction of the armory, the need for saving user characters on the server side is somewhat unnecessary, although I would still want such a feature I think.

Taking this a step further, because I can imagine a day when such a site-owner/maintainer is ready to be done with wow, or they die or whatever, the source for such a site could be maintained through sourceforge or similar public source code repository.

Doubt it.

To OP: I am having issues importing from the armory with your sheet. I'm getting a compile error - cannot find project in library. Any idea what is going on?

Also, I have been trying to use this spreadsheet in order to model the effects of resilience on my target. What I did was (1) add a field where I could input the amount of resil my target has, (2) made a formula that divides this field by 39.4 to determine the crit chance reduction amount, (3) modified cell M8 on the unbuffed dps spreadsheet (dont care about buffed dps atm) by subtracting the amount calculated in (2) /100 from the total, (4) creating a formula that multi[lies the result of (2) by 2, and (5) reducing the total in cell Q23 on the unbuffed dps spreadsheet by the result of (4) /100.

As far as I can tell, these alterations should enable me to model the effects of resilience on my target before the impact of such talents as sleight of hand, etc. Do you see anything amiss with my alterations?

Ok, going backwards...

Shaithis---
1) Armory Import - Sounds like you need to download the MSXML6 library (link at rogue.raidcal.com as listed in the first post).
2) Resilience - Sounds like that should do it.

Lextera---
Web-based App - Unfortunately, that conversion is not likely to happen. Given the complexity of the current sheet, such a conversion would be non-trivial. Given that we are likely to see the expansion sometime this year, I'm trying to bring the sheet up to speed (simplified for the conversion) before that time arrives. That work has been somewhat sidetracked by the generous contributions of code and design recently that has led to a number of the new features now displayed in the spreadsheet. Granted, these aren't helping OO users much but I do plan to eventually try to make Macros work in Open Office. At the very least, any that I can.

Drunk---
1) Preferred gems for Upgrade search - You bring up some good points and I have thought about that before. I think there are some bigger fish to fry first, but I do think that auto selection of the correct gem types (in some way) for the Upgrade search is a desirable feature. I'll add it to the future development section, although it probably won't be added in the next few patches.
2) Meta gem require turned off during upgrades by default - I'd have to think about that more. For the time being, I'm probably going to leave that as it is. There are ways one can tweak the system (loading extra blues prior to upgrade search for example) or turning it off beforehand. i might do something if I get around to the preferred Gem selection for upgrades.

Gokpog---
Sheet selected cycle for ShS/Ass build - Apparently the sheet is calculating that as the best average cycle and the added chance for an extra combo point on finisher appears to be the deciding factor. I put in a similar build with about T4 level gear. I guess the sheet is saying letting it drop for 0.7 seconds on the cycle doesn't hurt and is made up for by the extra Rupture time. It is in my plans to go over the non-mutilate portion of the cycles sheets and add many more possible cycles. Many that I add might be more 2-pc T4 friendly. Not sure until I do that.

Dread---
Sunwell items - Well, at this point, with Armory Import features, I won't be adding new items until I can confirm an Item ID. I figure an appearance on Wowhead is also a good gauge of an item's authenticity.

Rerox---
Vindicator's Dragonhide Bracers (ItemID: 33881) - Hmm...never knew Rogues used those, but I'm open to adding any item that is in the general ballpark of Rogue usable.

Falkyrk---
Messenger of Fate - Will be fixed as part of the bug-patch.

Hey Dontmind (cool nick ), another suggestion: when you get to the point to implement the preferred gems (red, yellow, blue, meta), please use them to value the AEP stats. Currently they are just fixed user defined values and for example the meta is set to 13 value, shadowpanther values it 40, but it can be calculated and proper values put there based on your stats/talents/preferred gem for slot.

You can ignore the part of my previous post about Talon vs. Blade of Infamy. I think between the new formulas and because my hit rating has fallen the +hit on Talon outweighs the extra white damage of Blade of Infamy. I hadn't noticed just how far my hit rating had fallen (that's what I get for wearing tier 5). After talking it over with some others and doing a bit of testing it seems as though the spreadsheet is most likely correct and I'm most likely wrong.

I apologize for jumping to a conclusion, but with some of the other little things going on, I just assumed it was a spreadsheet issue instead of really investigating it. It's safe to just ignore that part of my previous post.

Well I have 333 hit and set the spreadsheet to eat spicy hot talbuk and It is still recommending me to use Talon of Azshara (which would overcap me).

I have imported my current gear and talent spec into the newest version of the spreadsheet, however my dps on this version has dropped by close to 50dps compared to the last version i used. I usually use both the gear spreadsheet and the dps ones and compare the two. Both come within a few dps of one another most of the time. However after i downloaded the latest versions of both spreadsheets yesterday this sheet is showing only 1353 buffed dps, while the gear spreadsheet is showing 1402 buffed dps with no difference in gear or buffs between the two. Is the disparity always that large?

Did you read the bug notes for this version? You need to perform the fix noted in this post to get Haste and -Armor working again, as well as fix some macro issues. For me, the difference was somewhere around 50 DPS.

DMM has stated he is working on getting a fixed version out.

That should be fixed in the bug-fix version (I think I got that working again last night, still need to double-check some things before posting a new update). It was brought to my attention that one of the references got screwed up (when Item ID's got added) and the proc dps for the 2 modeled weapons that still have defined procs (Revenger and Thunderfury) are not working as intended.

Sedrikk/tymoney321 ---
Not sure, we'll see what happens after the latest fixes. There are likely small differences in modeling between the 2 spreadsheets. The fact that both sheets even agree to within 50 dps, tells me that both sheets are doing something right. The way this sheet is modeled, there really isn't any difficulty with overcap. Anything over is 0 miss rate. Those are very similar weapons for DPS. It's still possible that the extra hit rating is still superior even though some of it is lost.

Magicp ---
Not a problem. I see where you were coming from. It was probably worth bringing up. I'm a little sensitive about the use of phrases like "clearly obvious" mostly because I've seen them misused so often in other contexts (God forbid comparative build discussions). On the other hand, Stealther's Helm of Second Sight could have be described as a "clearly obvious" error and it was an error.

Drunk ---
Good point. When I get to that point, I'll try to remember to do that. I would have probably overlooked that had it not been brought up.