WotLK DPS spreadsheet - Page 150

RoBoBOBR · 04/27/09, 8:57 AM

I'm specced MM now, so i input SrS and Chimera shot in rotation, hit test - and the spreadsheet shows no Serpents been shot. In priority table it's listed as "refreshed", and that's right, but what about initial application?

Shandara · 04/27/09, 8:58 AM

Originally Posted by RoBoBOBR

I'm specced MM now, so i input SrS and Chimera shot in rotation, hit test - and the spreadsheet shows no Serpents been shot. In priority table it's listed as "refreshed", and that's right, but what about initial application?

For the sake of simplicity, the first application is discarded. The damage from SrS is still counted though.

Daymaker · 04/27/09, 9:08 AM

Awesome and quick changes, we love you

.

Bug report:
Pendulum of Infinity is sorted as Ulduar-10 when it is in fact a Ulduar-25 Hard mode drop.
Soul-Devouring Cinch is misspelled as "Sould-Devouring".

Shandara · 04/27/09, 9:45 AM

Originally Posted by Daymaker

Awesome and quick changes, we love you

.

Bug report:
Pendulum of Infinity is sorted as Ulduar-10 when it is in fact a Ulduar-25 Hard mode drop.
Soul-Devouring Cinch is misspelled as "Sould-Devouring".

Good catch. Also you didn't mention that the Cinch ended up as a pair of gloves. I've re-uploaded V87b fixing these 2 items.

EDIT:
Another re-upload fixing some typo's I found myself. Also changed the layout on the ArP section of Calculations to be more readable.

Dralmoo · 04/27/09, 12:14 PM

[Gloves of the Stonereaper] are still missing their socket bonus of +4 agility.

• VRoscioli · 04/27/09, 12:57 PM

Originally Posted by Shandara

As for the Gear Planner, I've been considering how to 'fix' it so comparisons between 1h and 2h are accurate, but Excel formulas are such a kludgy way of doing it.

My suggestion on how to do this would be to always compare the gear planner items as though they have the "default" enchant.

So, for example (using version 87a for this example), Melee!C145 currently reads:

=VLOOKUP(GPMHEnchant,MeleeEnchantStats,3,FALSE)-VLOOKUP(MainEnchant,MeleeEnchantStats,3,FALSE)

I suggest a change to something like:

=IF("Gear Planner"!I102<>"2-Hander",0,(VLOOKUP(GPMHEnchant,MeleeEnchantStats,3,FALSE)-VLOOKUP(GP2HEnchant,MeleeEnchantStats,3,FALSE))/2)

(and the same for the OH enchant adjustment, but using GPOHEnchant instead of GPMHEnchant). Similarly, change Melee!C147 to something like:

=IF("Gear Planner"!I102<>"2-Hander",VLOOKUP(GP2HEnchant,MeleeEnchantStats,3,FALSE)-VLOOKUP(GPMHEnchant,MeleeEnchantStats,3,FALSE)-VLOOKUP(GPOHEnchant,MeleeEnchantStats,3,FALSE),0)

(Disclaimer: I haven't actually tried these, there's probably at least a few typos somewhere, but you get the idea)

Scharfschütz · 04/27/09, 1:07 PM

There is a bug with Pendulum of Infinity. When I use a Delicate Stormjewel (20 agi) it shows total dps as 7424.80 but if I change it to a Delicate Dragon's Eye (27 agi) and gain the socket bonus (4 agi) it increases total dps to 7626.49 which is a gain of 201.69 dps from just 11 agility which seems horribly wrong.

• VRoscioli · 04/27/09, 1:10 PM

Originally Posted by Scharfschütz

There is a bug with Pendulum of Infinity. When I use a Delicate Stormjewel (20 agi) it shows total dps as 7424.80 but if I change it to a Delicate Dragon's Eye (27 agi) and gain the socket bonus (4 agi) it increases total dps to 7626.49 which is a gain of 201.69 dps from just 11 agility which seems horribly wrong.

Is the change to Delicate Dragon's Eye activating your meta-gem, by any chance?

alienangel · 04/27/09, 1:10 PM

Originally Posted by Scharfschütz

There is a bug with Pendulum of Infinity. When I use a Delicate Stormjewel (20 agi) it shows total dps as 7424.80 but if I change it to a Delicate Dragon's Eye (27 agi) and gain the socket bonus (4 agi) it increases total dps to 7626.49 which is a gain of 201.69 dps from just 11 agility which seems horribly wrong.

Dragon's Eye is prismatic, and counts as one gem of each color (simultaneously) for meta-gem requirements. Are you sure your meta was active with the Stormjewel in place?

Soliloquy · 04/27/09, 1:11 PM

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.

Esoth · 04/27/09, 1:15 PM

Wrists do not appear to have socket 1 (maybe it's hidden?).

• VRoscioli · 04/27/09, 3:39 PM

Bug Report: In the Rotation Test, Readiness is (incorrectly) resetting the cooldown on Berserking (and presumably other racial abilities)

Shandara · 04/27/09, 5:03 PM

Originally Posted by Scharfschütz

There is a bug with Pendulum of Infinity. When I use a Delicate Stormjewel (20 agi) it shows total dps as 7424.80 but if I change it to a Delicate Dragon's Eye (27 agi) and gain the socket bonus (4 agi) it increases total dps to 7626.49 which is a gain of 201.69 dps from just 11 agility which seems horribly wrong.

The Stormjewels are not prismatic in the sheet at the moment. This is a bug I'll have fixed soon.

greendef · 04/27/09, 5:06 PM

Stormjewels aren't prismatic in game either, they are all mono coloured.

Shandara · 04/27/09, 5:32 PM

Originally Posted by greendef

Stormjewels aren't prismatic in game either, they are all mono coloured.

Ah, I must be confusing them with the Dragon Eyes then.