Dontmindme

No, but because the Tier builds I used were imported from the Armory, it bugged the sheet up for any Helm that uses 3 sockets that doesn't have a Meta.

Late last night I figured out the resolution to a few issues:
Going back a few posts, I should have a new version out by the end of the week that includes the fixes for #2, #3 and #11.

Basically, I'll be adding those 3 columns back in.

Reformatting all the conditional formatting for Gems (re-doing it, fixes the issue with Open Office, still no idea why it currently works correctly in Excel but is different in OO with the exact same file...but anyway).

And I figured out how to adjust the Armory Import to avoid the 3rd Gem slot problem. The issue is a result of the Meta gem workaround. Whenever a helm is imported with a Metagem, it's leaving the 3rd gem slot blank instead of saying "none" which the spreadsheet wants (as the meta gem was moved to it's own spot). I just need to add a line that puts "none" in the correct place when it finds a Metagem. This has also propagated into the Default gear pulldowns and is an issue as the sheet is currently saved.

I hope to also make an adjustment to the new Macros to speed them up a bit. This *might* fix the Mac issue if the problem is a timeout issue. No guarantees.

I also took a quick look at adding new normal cycles into the spreadsheet. It looked promising, didn't seem to break anything, so I plan to add a number of them in the next major release (not the bug fix release) including a lot more 4e and 4r cycles which should be helpful to non-Mutilate Seal Fate builds (as well as the 2-pc T4 short dagger cycles).

Just an FYI, it will be at least until Wednesday before I can put the bug fix release together.

 

Dontmindme

Also, in terms of the new pulldowns and saved Talent/Gear/Options/Buffs features, I need to know if this is working on any Macs. Please post or PM me if they *are* working for you. Also include the version of Excel and which OS you are using. I need to know if this is an isolated issue, an issue specific to certain OS's or Excel versions. So far I have one report of it crashing on OS X with Excel 2004 for Mac.

 

Falkyrk

It appears the dagger Messenger of Fate is tied to the Reputation check box. Meaning, it won't appear in the drop down list unless the Reputation box is checked under Equip Options. It should be tied to the Black Temple list.

 

• Rerox

Since quite some amount of rogues use the feral PVP.-bracers it might be a good idea to include them in the sheet?
Vindicator's Dragonhide Bracers (ItemID: 33881)

 

Dread

ImageShack - Hosting :: compjg9.jpg

Some unconfirmed 2.4 items (Sunwell), don't know if you want to add them now or wait until 2.4 is released and add it in that version and make sure they got the correct stats instead of changing it twice :P

 

Stienz

those are fake.

 

gokpog

v2.3.2.8:
(Default)Shadowstep/Assassination build with 2 T4 and 3/3 Ruthlessness: The spreadsheet is calculating a 1s/5r cycle.
Is it intended to let SnD drop after 12 sec?

edit: 1/3 and 2/3 Ruthlessness give a 3s/5s/5r cycle

 

Drunk

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

 

Lextera

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.

 

Shaithis

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?

 

Modnoc

pretty sure they're fake:

2.4, Blue posts, UICentral, WoW Comic

link to the screenshot: http://static.mmo-champion.com/mmoc/...unwellfake.jpg

 

Dontmindme

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.

 

Drunk

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.

 

magicp

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.

 

Nurru

The post above mine has to be a joke.

 

tymoney321

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).

 

• sedrikk

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?

 

Left

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.

 

Sekkyo

Anyone else getting a 5000-5400 DPS increase with Thunderfury equipped in the MH or OH?

 

Dontmindme

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.

 

Dreshla

Just a quick question about something I saw recently on this forum. The item upgrade assumes all items have no gem slots? that seemed to be the gist of a comment earlier. Just need a clarification when time allows. Thanks much.

~Dreshla

 

Ariashley

I'm confused. On the cycle spreadsheet - it looks like the hemo formula is changed to the new formula. On the Buffed and Unbuffed DPS that feed forward to DPS on the Gear_Buffs sheet, those formulas are still showing 1.25 for hemo damage. I've been out of town and haven't kept up on all the forum posts. Is this or is it not updated for last tuesday's patch? I'm thinking not?

Btw - forgot to mention that I love the new layout and buttons and saving gear and talent selections. Makes comparisons a LOT faster.

Edit - nevermind - I see that it's pulling forward damage from the Buffed/Unbuffed Cycle calculations. If we don't need the other calcs there at all, can they be blank or something? I definitely got confused looking at it.

 

Dontmindme

Ariashley --- I fixed those non-calculation formulas last night as part of my Buffed/Unbuffed DPS sheet brush up. I'm guessing they are there so people can look at what their max damage could look like, maybe...since its against a 0 armor opponent. I figure it's there, so maybe people use it, might as well fix it (was a rather low priority but since I was looking over a couple other things on that page...).

Dreshla --- Actually it's a fair bit more complicated than that. The upgrade function uses the gems as they have been saved on the sheet. So, if a particular gem is in the first slot (even if it's grayed out because that item doesn't have sockets), that gem is used for calculation purposes for other items when socketed. It's really probably not the best solution (and hence the previous discussion). Much of the time it's going to work out as rogue sockets tend to be very similar in terms of order, especially if you are using Orange gems, you will often get the socket bonus active (since the spreadsheet does not discriminate on gemming order). It also works out for socketless items. Unfortunately, it doesn't work so well with items that have sockets in a strange order or different colors than what's currently socketed. Now, with Armory Import, that function actually blanks out non-used sockets (behind the gray) which further muddies it's value, as when you have equipped a non-socket item, socketed items won't be showing the benefit of gems being socketed at all. (Unless the Macro does more than I believe it does).

So, in some ways, you still benefit by selecting items individually at times, and personally selecting the appropriate gems to maximize DPS. The suggestion was to improve the Upgrade function to perform some of the selection process automatically.

 

Dontmindme

Ok, the bug fix version 2.3.2.9 should be posted in the near future.

Scratch the Mac tests...I think I'm onto the issue and may have a Mac fix for the Combo boxes this weekend. Looks like I'll have to write a workaround as Excel for Mac does not support OCX control features but there are commands that are usable with Combo Boxes that can substitute. This won't help Armory import, but all the other Macros should still be able to be used on a Mac.

 

OnTheHissay

Am I right in thinking that the planned change to -armor AEP will result in a better rating of the Executioner enchant? When I apply Executioner instead of Mongose in the Rogue DPS Spreadsheet I get a -7 DPS difference, but when I do the same in the Rogue Gear Spreadsheet I get a +7 DPS difference.