I'd like to report a new mail chestpiece that drops off M'uru.. Stats can be found here: http://www.worldofraids.com/2008/may...derhauberk.png

Had a feeling Berserker's Call was up there.
But damn, 40 AP the difference between 11th and 3rd. That just shows that the top 11 trinkets are pretty even, prolly the top 15 too.

I have found the new neck slot from the SSO reputation vendor listed in your items list, my question.."Is there a way to declare Scryer or Aldor for the slot and have the dammage difference for each proc be reflected in the spreadsheet?" The reason I ask this is because I have seen some math that calls the 2 procs virtually simmular and other math that has the Aldor proc as far suprior to that of the Scryer.

You can control your faction on the 'Settings and Results' tab.

There is currently no way to see total DPS side-by-side, but on the calculations tab you can see both procs together.

Thank you very much.

Hey Cheeky, great work as always. Just some things I'd thought I'd point out.

This spreadsheet doesn't seem to work with Office Mac 2004, can't click the macro buttons. Haven't tried on my windows machine (at work at the moment). Also, those who are trying to use Mac Office 2008 will also be out of luck as Mac Office 2008 doesn't accept Visual Basic macros for some strange reason.

Just thought I'd point those issues out for Mac users. It probably works all dandy on my Windows machine. Keep it up!

Oh yeah, those are actually separate lists now. I'll have to handle them in a special manner. I'm betting they don't change if you eliminate content and re-sort either.

Dunno if it's a bug but it seems strange to me. When I change between the 2 options of "Treat +hit as" there is no to little difference in the Item's DPS Value. it happened after I've hit the CalcAttributes button.

The difference only comes if you are already hit-capped. (Hit tends to be fairly linear in scale from 0 to the cap.)

Are you sure that DST it that low in DPS since I can see a HUGE increase in DPS when it proccs, maybe because I go from a 3:2 to 1:1 rotation with my ammount of haste ATM.

I also saw something weird in the Settings and Result tab that DST was modeled as a 1PPM trinket when during our last Illidan try my proccwatch registered it proccing at most 8seconds after the internal CD was done and more often then not ~1sec after the internal was over. Inputting DST at 2PPM makes it take the third place.

I agree that this is HIGHLY situational and I trust that countless hours have been put in modeling this trinket but I can't help defending it since I can with my own eyes see a huge decrease in DPS when using Bersekers and Ashtounge on Gurtugg (~100dps less) then with my DST.

Well ever since version 48 there been some strange stuff going on in the spreadsheet.
Like with the gear planner tab.

Showing you the updates that you can plan to purchase or get.

But now it actually shows that [The Blade of Harbingers] is the best
hunter weapon in the game at the moment.
When in version 47 it says its not. (*wen you run it in the gear tab*)

But now for some strange reason the updates pointed out by the gear planner tab
arrant correct accordingly to the gear tab.

for example:
on the gear planner tab it says :
[Vengeful Gladiator's Waraxe] < [Trollbane]
but
on the gear tab it says :
[Vengeful Gladiator's Waraxe] > [Trollbane]

When i would switch those weapons it would cost my about 7 dps and 12.3 total dps loss.
but still on the gear planner tab it says that [Trollbane]
is a very nice upgrade for me.

Also since version 48 the spreadsheet seems to love haste over every other stat.
Since all top 3 hunter items in the gear planner tab are haste related.
But stacking up haste wont that pretty much just cap you or wouldn't you
just hit the haste cap really fast.

I don't actually know the haste cap of hunters myself. but i did follow experiment.

In my haste gear i get the following.

Haste : 139
auto : 1.9
ss: 1.0

In my normal raiding gear i get

haste : 77
auto : 1.9
ss: 1.0

The only difference between the 2 is when IAH procs
in haste gear i get a 1.6 auto
and in normal raiding gear a 1.7 auto

So i don't think that the haste calculations or the interpretation of haste is correctly in the spreadsheet.
Claiming every item with haste is beter then normal items.

whit version 47 i rund every item of mount hyal threw the spreadsheet to see what was a upgrade and what not.
showing that

[Valestalker Girdle] < [Belt of the Black Eagle]
and now all of a suden its .
[Valestalker Girdle] >>>>>> [Belt of the Black Eagle]
then i go like ????

i know you work on the spreadsheet to update it and get the calculations as correct as possible
but where you guys so far off then with the haste calculation in version 47 ?

Also ever since i began to use version 48 loading and saving stuff takes ages
whit office 2007 professional.
What i don't have whit version 47 and below they save and load very smood.

But at far most i have to say the spreadsheet has helpt me alot nice work and keep up the good work

Haste is treated very differently is the gear vs planner sheets. The gear sheet will give you an accurate result (mostly), the planner is just to get a general idea of what you should try in the gear sheet. Especially with items with haste and armor pen, that don't have a linear effect this is the case.

Because of the way different stats interact with each other, the gear planner will never be 100% accurate. But I don't think it's so far off as to be useless, either.

Just testing it out, I would switch an item to "None", CalcAttributes, and then see how the theoretical numbers in the Gear Planner matched the spreadsheet output when I selected the item:

With no neck item I was at 2029.84 DPS
[Worgen Claw Necklace] : Gear Planner - 42.87 DPS, Plugging in item - 43.13 DPS.
[Shattered Sun Pendant of Might] : Gear Planner - 43.17 DPS, Plugging in item - 43.29
[Choker of Endless Nightmares] : Gear Planner - 57.55, Plugging in the item - 54.24

For the Choker, it took me 4 over the hit cap, wasting about 3.6 DPS of item budget.

Now, none of those items had any haste. Haste, as you add it, makes every other stat more valuable. It's hard to quantify that before seeing the numbers. Here is the same experiment using the chest slot:

With no chest I was at 1972.84 DPS
[Pattern: Embrace of the Phoenix] : Planner - 126.88, Plugged in - 129.9
[Scaled Drakeskin Chestguard] : Planner - 98.39, Plugged in - 100.13
[Rift Stalker Hauberk] : Planner - 90.26, Plugged in - 68.98
[Pattern: Carapace of Sun and Shadow] : Planner - 153.62, Plugged in - 129.38

Both the T5 chest and the Carapace put me way over the hit cap, again wasting item budget.

I guess I can try and figure out a way to factor the hit cap into the equations, but I'm not sure how much of an effort I want to put in making the Gear Planner super-accurate. Right now it's generally doing what I'd like it to do, which is point out items you may not have thought of.

None of the gray buttons such as load gear from armory and switch switching rotation in the spreadsheet seems to work for me. Does anyone know how to fix that?
I'm using Excel 2007 but I'm opening the spreadsheet as a Excel 97-2003 Worksheet

Making the gear planer tab super accurate will just make us use our Grey mass in our head even less.
But shown by your own experiments the gear planer is not very accurate at all.
Off course there is the in total calculation of the total stats going on.
That can make a single item less or more beneficial to you.

But the general idea of the gear planner tab is good and the intention of it.

Also i have noticed in version 48 that the list of items and gems are no longer alphabetically order
but more or less random.

Besides the issues with passing the hit cap, I'd say it came out pretty accurate.

The items in drop down lists (except weapons) are sorted backed on how you pick things in the Gear Planner to be sorted. This was a much-requested feature. You can always put them back in alphabetical order just like they were previously.

Hi, I just wanted to let you know that the Run-time error '91' still persists:

My collected information so far:
I use Microsoft Excel 2007 on Windows XP SP2.
It first occured in v47 of the spreadsheet and is still there in v49.
It seems to be related to one of these two items:
[Gronnstalker's Boots] and [Mantle of the Golden Forest]
The error occurs right after parsing the Mantle of the Golden Forest loaded from the Armory and seems not to occur if I don't wear these items.

The complete error text:
Run-time error '91':
Object variable or With block variable not set

I have a hard time believing that DST ranks below Bloodlust Brooch on the Gear Planner tab when it shows as a DPS upgrade on the Gear tab. Personal experience again tells me that DST should still rank higher than many of those trinkets.

Also, Angelista's Revenge shows as a DPS upgrade on the Gear tab but on the Gear Planner tab it ranks low. Switching to Deceitful Intent and even though I am only at 135 HR, it shows as a DPS downgrade on the Gear tab but a huge DPS upgrade on the Gear Planner tab. If I max out my hit by swapping in a neck with HR, Angelista's > Deceitful Intent on the Gear tab but Deceitful Intent > Angelista's on the Gear Planner tab.

Does this make sense?

Cheeky, please check the haste values of the Gear tab (not the gear planner tab). Haste is definately yielding only a small return per point invested and way lower than it did in version 47

Longjohnson

Are you using a different bow/buffs? Haste is still showing up just as effective for me now as in 47

Just a suggestion, on either the Gear Planner sheet or the Gear sheet put the DPS of the currently used item. If I look at, for example, the necks in the gear planner and the one I have isn't high enough to be ranked I'd like to see how it compares in DPS to the ones listed.

Thanks.

DST hidden CD removed/changed?Saw procs after 10 seconds and under after previous one expired...