Yet another thank you for another very pleased user.

I have been adding a few custom items to my spreadsheet but have run into a problem.
I wanted to evaluate the PVP set on this sheet since it has such an excellent 4 piece bonus.
Do you have any tips on how I would try to enter this bonus on the spreadsheet so that the pieces can be evaluated?
I am giving Resilience an EP Value of 0 since it has no effect on PVE.

I commented 2-set bonus for combat here.

As the sheet doesn't support set bonuses, I tried to evaluate 2-set bonus this way: I picked 2 pieces with the best stats for combat and added +35 agility as a socket bonus on both of them. I also had to change blue socket on leggings to be red socket, because in reality, we'll put red gem in there.

I guess you can do the same with 4-set bonus. But always keep in mind that items are as good as they show only if you equip all of them at once.

According to the sheet, [Vicious Gladiator's Shiv] is also best pre-raid offhand for combat.

As explained in the sheet, take the weapon recommendations with a grain of salt. While they are based on ShadowCraft's EP values, they are quite simplified to fit into the sheet (though they appeared to be more or less stable) and as well aren't necessarily correct for your gear (as always if you don't use personalized EP values).
The Shiv however is at least a decent off hand. And ridiculously easy to acquire.

That being said, I hope I'll be able to update the sheet tomorrow with some heroic gear etc. I'm making progress with my muted sound addon, so I can go back to item scraping. This and I really need an overview of heroic gear for myself by now.

Updated to r7.
It includes heroic gear now (and those nifty random enchanted legs from Al'akir). Also fixed the meta gem bug for C'thuns Helmet and added some PvP pieces (no blues though).

The most apparent change is probably that I added loot categories so that you can choose to not display e.g. heroic raid loot gear or questing/reputation items.*


* I hope that the dropdowns/checkboxes do work outside of a German Excel. Not so sure about this with Microsoft's policy to localize their formula function words (if anyone didn't understands what I was trying to say here: for example 'TRUE' becomes 'WAHR' in German Excel and I don't know if that's ok to use in a dropdown). Let me know if it doesn't work.


Also, OpenOffice users seems to suffer from a bug that the sorted list isn't updated correctly when you change your spec/EP values or loot categories. The EP calculation itself still seems to be correct, but it doesn't re-order (or hide) the items. You can manually force it do so if you remove one of numbers representing the position in the 'A' column and add it again. You only have to do this once - after that it updates the list just fine.
Again, let me know if you know why this behaviour occurs. Or how to fix it. I have no clue.


// Edit
Oh, and also, does anybody know what's the drop behaviour of the heroic tokens? Do they drop from all bosses on heroic mode or are they again split up amongst specific bosses?

Thanks for the update, I really like to use your sheet for browsing thru gear and planning possible upgrades.

I've got some feedback to the newest version:

1. Dropdowns work (in english excel 2007), but they show german "WAHR" and "FALSH". Not a big deal.
2. Although when I use the loot categories feature and uncheck any of them (for example "RaidHeroic") every single line in "Weapons incl. Speed & DPS" section goes blank, thats a bit annoying.
3. When we have those random enchanted legs from Al'akir now, what about the random enchanted belts and rings from Conclave of Wind? I have no problem adding them myself (it seems that wowhead already has all relevant drops data), but it would be nice to have those included out-of-the-box.
4. Regarding added Vicious armor pieces, did you consider implementing some kind of support of set bonuses? Again, it's not hard to add the extra agility manually, but in it's current state and without any comment about it, the value of those items may be a bit misleading for less experienced users.

Good catches all.
I added the missing waist/rings, updated the drop locations and the dropdown boxes should be working now as well (both in terms of language and functionality with the weapons).

This is more of a way MS localizes stuff, the internal function of the booleans is the same but localized versions may display it differently according to the language settings of the viewer and/or spreadsheet creator. Take it like most MS, it's not a bug, it's a feature.

Cloak of Biting Chill and Viewless Wings have the stats kind of weird too. Not sure if they were recently changed and r8 hasn't been updated to reflect the changes.

How so? I just double-checked everything against wowhead and the stats in R8 match those on the site.

Keep in mind you can fix/add items to the spread. I fixed the two necks mentioned above and after reforge it puts Strife 15 EP ahead of Rodrigo's (which I don't necessarily agree with since I'm a mastery whore). Hornet-Sting Band is also on par with Mistral Circle of the Zephyr after adding it.

/me idiot.

Just now realized all the stats on their are reforged values. My bad.

It is worth noting that 4.1 will presumably come out with another tier of raid content, so how the crafted gear compares to current-tier epics is somewhat less relevant. Those would have been highly useful changes in 4.0.6 (when they changed (most of) the other crafted gear), but by 4.1 I'm not sure how much it'll still matter.