WotLK DPS spreadsheet - Page 90

GwolfGarona · 04/26/09, 8:22 PM

MMO-champion is still missing thorium hard mode as well last I looked, but definitely 95% complete list.

She could add a column to show iLevel in the planner. That + location would clue you in to hard or not.

I would like to toggle off the NYI epic gems, they get in the way for me.

britomartis · 04/27/09, 1:17 AM

87a is missing [Rune-Etched Nightblade] - Ulduar 10, Iron Council

Sandrielle · 04/27/09, 7:14 AM

The cells for the standard gems in the settings tab are protected to me, actually most of the settings tab is protected now and cant be changed ...

arlen · 04/27/09, 7:28 AM

Change what gems you want to use in the Custom column of the settings tab. You're not suppose to change the default ones.

Daymaker · 04/27/09, 7:53 AM

Bug report:
In a locale where the decimal separator is a comma (such as Swedish), the pawn string on the overview tab is broken.

Feature request:
In the gear planner, some more filtering checkboxes would be nice, examples:

Hide negative dps items
Separate checkboxes for 10, 25 and ulduar-25 badges
Hard modes (already asked above)

Gibreel · 04/27/09, 7:54 AM

It would appear that "Lustrous Sky Sapphire (6Mp5)" is showing as a yellow gem as opposed to a blue.

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

Originally Posted by Daymaker

Bug report:
In a locale where the decimal separator is a comma (such as Swedish), the pawn string on the overview tab is broken.

This is not something I can do anything about, sadly enough. Your only option is to change Excel's locale or change the decimal separator itself. Unless someone knows a way to detect and/or change the locale from within Excel formulas.

Hard mode filter is in the works at the moment, since I actually think that one is fairly useful (and for future expansions as well). For the rest the amount of items available is just too minimal per slot that it doesn't really clutter up.

EDIT:
Pawn expects a US format no? I.e. a period as decimal separator. If so, I can just lock the cell to use that, regardless of what the user's locale is.

Daymaker · 04/27/09, 8:59 AM

Originally Posted by Shandara

Pawn expects a US format no? I.e. a period as decimal separator. If so, I can just lock the cell to use that, regardless of what the user's locale is.

Exactly, my pawn looks like this:

( Pawn: v1: "Current": Agility=1,517, Stamina=0,309, Intellect=0,54, [...]

Obviously it gets confused with the commas, so just hard-coding it (if possible) to use a period will fix it.

Sandrielle · 04/27/09, 9:32 AM

oh, thx arlen, so dumb i didnt find this myself ...

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

Update:

- Running the rotation test now properly ignores duplicate shots in the rotation. Also the shot priority table on the shot rotation tab is more robust when it comes to that too.
- Added an option to each shot on the shot rotation tab to determine whether crits from that ability can cause procs (i.e. GftT)
- Added "None" as a possible pet which will disable all pet dps and procs
- Added extra socket for cloaks, this might cause problems for importing and/or loading existing profiles.
- Concussive Barrage now maximum of 2 points
- Set default target to WotLK Boss and adjusted armor to 10643
- Changed Feeding Frenzy to be averaged over the boss fight (setting on Settings tab to set the time spent sub-35%, this is additive with the option for sub-20%)
- Added Hard Mode loot, some are missing socket bonuses, please report when you find out what they are.
- Tunic of Limber Stalker stats adjusted
- Changed Pawn String to always display a period as decimal separator, regardless of user Locale.
- Added an option on the Gear Planner to filter out downgrades. Does not apply to dual-slots (Rings, Trinkets, dual-wield melee)
- Removed +hit selection from settings tab.

Nothing new with fixing comparing melee enchants between 1h and 2h yet. I suggest you only use those fields to compare between dual-wield or between 2handers for now.

RoBoBOBR · 04/27/09, 9: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, 9: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, 10: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, 10: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, 1:14 PM

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

• VRoscioli · 04/27/09, 1: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, 2: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, 2: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, 2: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, 2: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, 2:15 PM

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

• VRoscioli · 04/27/09, 4: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, 6: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, 6:06 PM

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

Shandara · 04/27/09, 6: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.