WotLK DPS spreadsheet - Page 152

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

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

• VRoscioli · 04/28/09, 6: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, 7: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, 10: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, 10: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, 1: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, 1: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, 5: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, 9: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, 1:05 AM

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

Argg0 · 04/30/09, 2:53 AM

Yeah, furious isn't in... Deadly Long Bow shows up on my top 10 list (the bow with 141 dps)... so, I doubt Furious wouldn't reach higher than that.

And damn, will we have to PvP for a 170 dps Ranged weapon or are we going to get it from some obscure hard mode? >_<

Mr Tazza · 04/30/09, 6:44 AM

Algalon will most likely drop a 239 ranged (crossbow is my bet!), until then yes, 2.2k furious weapons will be BiS

Gotrage · 04/30/09, 12:02 PM

I already searched the thread looking for an answer, but couldn't find anything about it.

Is there a reason why Relentless Earthsiege Diamond is not listing 3% crit damage increase? Is this just a visual bug on the gem list?

I'm noticing a really small gain changing Chaotic Skyflare with the Relentless Earthsiege (around 1dps with my gear) and I believe that it should be around 10 or something with my current gear. I already tried to force meta requirements with a dragon's eye for test purpose and the dps gain is still around 3 points.

Hellifiknow · 04/30/09, 12:12 PM

When I ran the [Furious Gladiator's Recurve] through my spreadsheet as custom gear it showed as a DPS downgrade from Siren's Cry for me. Keep in mind I'm a troll so I have the racial, but even still both are bows. For me [Siren's Cry] offers nearly 30 more dps according to the spreadsheet.

Perhaps I made an error with some setting in the spreadsheet but I've gone over it multiple times and cannot see what it is I messed up.

My only other theory is that because the furious bow is a 3.0 speed weapon, maybe normalization plays a role as opposed to Siren's Cry which is 2.8 speed. Has anyone else had similar results?

Edit: This was as survival 0/15/56 with my current gear as the setup in the spreadsheet.

Argg0 · 04/30/09, 12:24 PM

Nope, it was an upgrade... quite a big one actually.

6425.96 with Furious.
6387.77 with Siren.

I'm a troll and my gear/spec can be seen on my armory.

Maybe it's an upgrade because I'm MM?