WotLK DPS spreadsheet - Page 149

Rezdan · 04/26/09, 3:41 AM

Originally Posted by Zoen

Hi, could you have a look at the mechanics of silencing shot in the shot rotation test tab? it seems to be waiting a GCD before casting the next shot.

Those mechanics are correct iirc. Silencing shot is on the gcd (waits for gcd to cast) but does not cause a gcd.

GwolfGarona · 04/26/09, 9:28 AM

Originally Posted by Argg0

I Still get no change on pet DPS by specing into feeding frenzy (Cunning)...

and [Relentless Edge] has not been included yet.

set boss health below 35% and see your DPS jump. The spreadsheet does not (can not?) reflect the target losing health over a duration. Kill Shot has an extra little box on the shot rotation tab that predicts the benefit of using it, but she has it currently set up to ignore feeding frenzy completely if you set the boss HP to over 35%.

Shandara · 04/26/09, 9:54 AM

Originally Posted by GwolfGarona

set boss health below 35% and see your DPS jump. The spreadsheet does not (can not?) reflect the target losing health over a duration. Kill Shot has an extra little box on the shot rotation tab that predicts the benefit of using it, but she has it currently set up to ignore feeding frenzy completely if you set the boss HP to over 35%.

I will adjust this to work the same as Kill Shot for the next release.

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.

Mr Tazza · 04/26/09, 6:34 PM

All hardmode loots but algalon's available on mmochamp! Go update!

Allara · 04/26/09, 6:52 PM

I wonder if it would be possible to identify the hard mode loot as such in the gear planner? I imagine it'd be nice to include a checkbox to turn that gear off, as well.

GwolfGarona · 04/26/09, 7: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, 12:17 AM

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

Sandrielle · 04/27/09, 6: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, 6: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, 6: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, 6: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, 7: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, 7: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, 8:32 AM

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

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