WotLK DPS spreadsheet - Page 91

Bifuu · 04/27/09, 7:16 PM

Originally Posted by Soliloquy

Shandara,

There is a problem when I click the "Load Gear from Armory" buttton.

It says "+15 Stamina and Minor Speed increase is not a supported feet enchant". This is the Tuskarr's Vitality enchant.

Its because the enchant is not really a dps enchant, which would be pointless to put into a dps spreadsheet. Lots of people (including myself) have it for some fights in ulduar so I'm sure a lot of people get this error, just hit ok and continue =)

Soliloquy · 04/27/09, 7:23 PM

Originally Posted by Bifuu

Its because the enchant is not really a dps enchant, which would be pointless to put into a dps spreadsheet. Lots of people (including myself) have it for some fights in ulduar so I'm sure a lot of people get this error, just hit ok and continue =)

Well it gives 5 ap, and yes I use it exactly for the reasons you mention.

Thing is, the enchant is listed in the enchant list, but it won't be recognized properly. Probably because it is actually not longer called "Tuskar's Vitaly" when you look at the enchant after it has been applied, but instead "15 Stamina and Minor Movement Increase".

Shandara · 04/27/09, 7:48 PM

Originally Posted by Soliloquy

Well it gives 5 ap, and yes I use it exactly for the reasons you mention.

Thing is, the enchant is listed in the enchant list, but it won't be recognized properly. Probably because it is actually not longer called "Tuskar's Vitaly" when you look at the enchant after it has been applied, but instead "15 Stamina and Minor Movement Increase".

This correct, it has been renamed with 3.1, which is why the sheet doesn't recognise it.

Iroared · 04/28/09, 2:48 AM

Does the spreadsheet version chimera shot assume that serpent sting is always up? Because when I do "test rotation" it never has a "serpent sting" line in it regardless of whether serpent comes before or after chimera shot in priority list. But when I switch the two the DPS changes.

Another question, I did not look into the implementation (I have no clue where macros in excel are), does the spreadsheet use a quick heuristic function to evaluate DPS every time I change an item or attribute, or does it actually test the rotation?

Shandara · 04/28/09, 5:58 AM

Update:

- Fixed socket on wrist/cloak slot
- Fixed Tuskarr's Vitality enchant name change
- With the Gear Planner. When comparing items, the enchant on the Gear tab is disregarded, the selected enchants on the Gear Planner are used for comparison. Enchant settings are used only for item types you are currently NOT equipping. I.e. if you dual-wield then the 2h enchant set on the planner is used for comparisons, but your dual-wield enchants are drawn from the Gear tab. And vice-versa for when you are using a 2-hander.
- Readiness no longer resets Berserking

I took VRoscioli's suggestion, with a tweak. I think personally that the planner should compare the listed items against what you have equipped on the Gear tab, which is what this change should effect for dual-wield vs 2-hander.

It's very hard to make the Gear Planner values match exactly with the dps increase you see in the sheet elsewhere because the averages that are calculated aren't quite constant. I still have some digging to do with the Gear Planner where it concerns +hit which is likely the biggest culprit.

Squinky001 · 04/28/09, 6:50 AM

There are leggings off of 10-man Yogg that don't appear to be in the spreadsheet: [Leggings of the Insatiable]

Keere · 04/28/09, 8:13 AM

I've been attempting to use this spreadsheet as much as possible, however, I have a Vista system (which runs MS Office 2007). None of the embedded spreadsheet tools seem to function when I run this file in compatibility mode. I've been digging through the forums to see if anyone else is having difficulties in order to find the fix, but as of yet, have not been able to.

Anyone have a working MS Excel 2007 version of this spreadsheet? Thanks.

Daymaker · 04/28/09, 10:46 AM

Feature request:
An ability to filter gems on the Gear tab to only show gems that match the socket color, as well as a setting to hide JC only gems, and also a setting to hide gems that are not yet in-game.

Pretty please?

Related question: When gems are sorted by DPS, does this take into account socket bonuses for the items?

Shandara · 04/28/09, 10:50 AM

Originally Posted by Daymaker

Feature request:
An ability to filter gems on the Gear tab to only show gems that match the socket color, as well as a setting to hide JC only gems, and also a setting to hide gems that are not yet in-game.

Pretty please?

Related question: When gems are sorted by DPS, does this take into account socket bonuses for the items?

You can already sort on color and there's an option to show only matching colors on the Settings tab.

When gems are sorted by DPS it means the pure stats on the gems only. Socket bonuses aren't considered (since the gem doesn't know what item it gets put into in any case).

Ravenfire · 04/28/09, 12:52 PM

Bug report:
Drape of the Faceless correctly shows as having a red and a yellow socket but the socket bonus is achieved regardless of what gem you have in the second socket, even if you leave it open (none) the bonus is achieved.

Iru · 04/28/09, 12:59 PM

A couple of quick feature requests.

1. Is it possible to associate toon level with the gear profile in some way or at least have pulling gear from the armory update the toon level the way it updates the race? I imported a 78a file into 78c - which breaks btw - and after re-pulling my gear from the armory had a screen full on #n/a until I realised I hadn't set the level in the overview tab.

2. Is it possible to associate glyphs with either talents or gear. As the spreadsheet will now load both primary and secondary specs and toon glyphs are now tied to those specs, it would make managing different specs easier as well. This may have been mentioned a few pages back but I don't recall you commenting on it, Shandara.

And while I'm being demanding, now that the pet skill selectors are smart enough to automatically select pet special & focus dump, would it be possible for the pet tree logic to include some additional validation. For example, while in theory Avoidance does not add DPS, its a required talent if you're going spec Rabid or Wolverine Bite so having just marked in red is misleading. Thinking about this further, Avoidance may be the only non-DPS talent for which this is true so maybe logic for that is all that's required. On a related note, why don't Great Stamina & Natural Armor have red backgrounds as well. Neither of them contributes to DPS except through enhanced pet survivability and by that logic, Bloodthirsty, Avoidance & Hart of the Phoenix also qualify (plus some others I'm sure).

Finally, as I haven't done this in a while: THANKS! This spreadsheet is invaluable for me in making gear & talent choices and building gear wish lists, and I for one deeply appreciate all your work on it, Shandara.

Shandara · 04/28/09, 1:08 PM

Originally Posted by Ravenfire

Bug report:
Drape of the Faceless correctly shows as having a red and a yellow socket but the socket bonus is achieved regardless of what gem you have in the second socket, even if you leave it open (none) the bonus is achieved.

Are you using v87c? It was working properly when I uploaded it and I just checked my local copy to make sure.

vongimi · 04/28/09, 1:35 PM

So why does the spreadsheet show that if I switch the proirity of black arrow and explosive shot, the same exact DPS is attained? Is it taking into effect the 6% extra damage on all attacks from black arrow? Because if you fired a black arrow before an explosive shot in a situation where you had to decide between the two, you could end up getting part, if not all, of a 3rd explosive shot being effected by the 6% extra damage from the black arrow. Where if you fired explosive first you could only 2 1/3rd (assuming the last 1/3 of the one fired before) shots effected by the 6% increase.

Shandara · 04/28/09, 1:41 PM

Originally Posted by vongimi

So why does the spreadsheet show that if I switch the proirity of black arrow and explosive shot, the same exact DPS is attained? Is it taking into effect the 6% extra damage on all attacks from black arrow? Because if you fired a black arrow before an explosive shot in a situation where you had to decide between the two, you could end up getting part, if not all, of a 3rd explosive shot being effected by the 6% extra damage from the black arrow. Where if you fired explosive first you could only 2 1/3rd (assuming the last 1/3 of the one fired before) shots effected by the 6% increase.

Because the 6% damage bonus is averaged out, regardless of the order in which the shots are fired. The uptime on Black Arrow is about 60% and the sheet assumes that 60% of your Explosive Shots are affected by it.

Anything other than averaging would require a full-blown hunter simulator to see which shots are affected by what procs/abilities/buffs, etc..

Esoth · 04/28/09, 4:36 PM

What do you think of adding weapon DPS (maybe this should be changing min and max instead) and perhaps even weapon speed +/- as hand adjusted settings, along with stats? Presumably this would enable the CalcAttributes macro to obtain values here as well. I realize this would run the risk of having a lot of columns in the Gear tab, but surely this is more important information than strength and spirit.

I've noticed other class spreadsheets normally include this value and would love to see it for hunters - especially because I suspect that unlike other classes, our weapon damage is much closer in value to our stats.

Edit: I actually played around with custom gear to see if I could calculate the value of adding 10 weapon DPS. Min=343, Max=613, Speed=2.9, DPS=(343+613)/2/2.9=164.8. That's roughly 10 more DPS than the Envoy I otherwise had in there. This yielded about 32.5 DPS, or 3.25 per weapon "DPS". This is better than my agility value of 1.359 by a fair amount, but not the massive rift that some physical classes see where 1 weapon DPS is worth about 9 str. Not sure if this is interesting to anyone else in the slightest, but there you go!

• VRoscioli · 04/28/09, 7:39 PM

In the current version, Readiness is still incorrectly resetting the cooldown of racial abilities.

• VRoscioli · 04/28/09, 7:42 PM

Originally Posted by Iru

2. Is it possible to associate glyphs with either talents or gear. As the spreadsheet will now load both primary and secondary specs and toon glyphs are now tied to those specs, it would make managing different specs easier as well. This may have been mentioned a few pages back but I don't recall you commenting on it, Shandara.

Tying other things, like the skinning/mining rank bonuses to the character would be useful as well, for those attempting to manage more than one character (or for continually importing to new versions of the SS).

Hunterlin · 04/29/09, 8:10 AM

Almost all PvP items already are in spreadsheet, but noticed 2 missing:
[Furious Gladiator's Wristguards of Triumph] ,
[Furious Gladiator's Sabatons of Triumph] .

Bokomatic · 04/29/09, 11:22 AM

Hi, Shandara.
I've downloaded spreadsheet v87c and found a little bug concerning 'Import' button.

Sheet36, Line 110
list = Worksheets("Gear").Range("W90").value

Sheet36, Line 113
If Not Worksheets(sheet).Range(list).Find(bit, , , xlWhole) Is Nothing Then

First operator assigns value "Set" to variable 'list'.
This value causes error 1004 at line 113.

After following small patch code works correctly.

Sheet36, Line 110

list = Worksheets("Gear").Range("W91").value

list = "GunAmmoList" and no error at Line 113

Shandara · 04/29/09, 11:27 AM

Cheers, adding the extra socket to the cloak needed adjustments in a great many places. This was one I obviously missed.

2. Is it possible to associate glyphs with either talents or gear. As the spreadsheet will now load both primary and secondary specs and toon glyphs are now tied to those specs, it would make managing different specs easier as well. This may have been mentioned a few pages back but I don't recall you commenting on it, Shandara.

Glyphs are already linked to gear profiles when you save/load them. It's just that the talent import will overwrite them. I can also link them saved talent spec profiles though. I will also link the Gathering skill to the gear profiles.

Esoth · 04/29/09, 2:21 PM

Correct me if I'm wrong, but the constant GC mentioned in his post seems to indicate that it is the target's level, not the player level. However Calculations!E20 is using player level. Similarly, the % reduction from armor in Overview!N21 is using player level instead of target level, which I think is incorrect.

Shandara · 04/29/09, 2:27 PM

Originally Posted by Esoth

Correct me if I'm wrong, but the constant GC mentioned in his post seems to indicate that it is the target's level, not the player level. However Calculations!E20 is using player level. Similarly, the % reduction from armor in Overview!N21 is using player level instead of target level, which I think is incorrect.

I am basing my calculations on the Combat Ratings at 80 thread which basically says that GC got it the wrong way around.

Seoman · 04/29/09, 6:41 PM

I generally view the spreadsheet with Aspect behavior set to "Always on" since until the recent mana-regen changes, that was pretty standard for 25 man raiding.

I tried switching it up recently to get more realistic DPS numbers. When I switch it to "Viper to OOM", DPS doesn't budge for my MM and SV builds, but declines for the BM build. "Viper - Regen" reduces DPS for all.

I understand that time spent in Viper means time with nerfed DPS, but what are the specific parameters of these two choices that take Viper into account?

EDIT: I took a look at the Mana regen calculations, and it looks like Judgment of Wisdom benefits BM less than other builds? I'm not sure what would be effecting JoW other than attack speed, and I would have thought that BM would generally have the highest attack speed.

sihyunie · 04/29/09, 10:49 PM

Are Season 6 gears added? I just looked at the [Furious Gladiator's Shotgun], and it might be the best weapon. I tried to use the custom gear to check, but it doesn't seem to be working (after sorting, the gun sorts to the bottom of the list right above none).

Iru · 04/30/09, 2:05 AM

Did you run the recalculation routine (the button on the overview tab) before sorting the ranged weapons?