Why are there numbers next to trinket calculations? That's an ordered list it helps me keep track of things, I used it before but its not so needed now. How are trinkets calculated?

Average uptime * value of proc
Uptime = duration / (ICD + time to reproc)

Time to reproc can vary depending on the trinket

For example darkmoon card greatness has a 15 duration, 45 ICD and a 35% on all hits proc.

=

with 1.5 hits per second, this card gets 31.98% uptime.
thusly, the value of the proc is 95.94 strength.

something seems to be off with the crit rating conversion to crit%
I have 33.28% crit unbuffed and the spreadsheet says i have 29.76 unbuffed and in the hit table it says i have a 26.63% chance to crit.
When i add the flat modifiers of BLood poisoning and Rampage the hit table critchance goes up to 34.65

Is there some kind of unknown bug with the way scourgebane works right now, or should it be better than +85AP against undead? Every version of the spreadsheet has reported scourgebane as not being as good as greater savagery against undead. This shouldn't be the case right?

Scourgebane isnt put in yet. Why would you put Scourgebane on a weapon versus straight AP? In fact, I don't even know why I still have those names loaded in the list. I'll take them out I guess.

Zinv, if you have "Boss" in the Mlevel cell, it subtracts 4.8% from your crit rating. That is the crit rating depression found on bosses from new research. Due to your unbuffed crit being wrong, you should double check everything. Make sure "Berserker Stance?" cell has a 1 in it, make sure you are using the right gems, etc. Seems to work fine for me.

World of Warcraft PTR Patch 3.0.8

Hunters:

Call of the Wild: The benefit from this pet talent now applies to only the Hunter and their own pet.

WoW -> Test Realm Patch Notes

Landsoul, when I open the 2003 version of 2.110 in Office 2003 and flip to the Lookup tables, the gem SEP values for items with sockets are #VALUE!. On the black sidebar on the left, R Y and B are all #VALUE! and so is max. The SEP macro runs but doesn't fix any of the missing values, and the Sort button gives the following dialog: Microsoft Visual Basic popup, "Run-time error '438': Object doesn't support this property or method." One of the available options is Debug; when I hit that I am taken to the code of Module6, line:

It's basically the second line from the top. As far as I can tell I've followed the directions on the first page; in 2003, Excel Options -> Formulas becomes Tools -> Options -> Calculation, and the editable field (.many0s1) is max change, not min. Excel Options -> Trust becomes Tools -> Options -> Security -> Macro Security... and I have that set to no security.

Thank you for continuing to support 2003 for those of us who are broke and/or have stingy schools...

I think I know what's wrong. '03 can't nest more than 7 times. I'll have to problem solve a little bit more to fix the logic of the gems.

Found a bug that gave me the N/A error: Hand enchant lookup is:
Should be:

Note the range should be to 259, not 258 (259 contains the "none" option).

Note: I use 'none' as enchant/gems to calculate my SEPs before deciding on an enchant/gem (find the upgrade with the most SEP, select it, then re-calculate).

Fix uploaded.

I get a run-time error when I try to click the sort-by-SEP button for the item lookup tab. It says "Run-time error '438': Object doesn't support this property or method." Clicking debug shows that the line that causes the error is in Module6, subroutine SortLookup(), second line, which reads, "ActiveWorkbook.Worksheets("Lookup").Sort.SortFields.Clear". I am using the .xls version of the spreadsheet on Excel 2003.

You should probably add Wicked Monarch Topaz (16 AP + 8 Crit), because Inscribed Monarch Topaz (8 STR + 8 Crit) is not actually in the game right now. Also consider adding Stoneskin Totem, which increases armor by 1150, with 20% more talented. I imagine it doesn't stack with Devotion Aura, but I haven't tested it.