Version2.2 of Tiered Armor Analysis

Malan · 08/03/06, 1:11 PM

Edit -

Version 3.1 of the Armor comparison spreadsheet between Tiered sets. Completed on 22 September '06.
New Link - http://files.filefront.com/ArmorAnal.../fileinfo.html

Changes-
Raw data for items is now hidden from view (you can unhide to edit/add new stuff if you are savvy with that stuff)
Each class has its own tab, armor for comparison is selected using drop down boxes
End-user of the spreadsheet can now mix/match the sets to decide what he wants to compare against (ie, compare 3pc T2.5 and 5pc T3 vs full 8pc T3)
Computed RAP for Hunters instead of Melee AP. (Whoopsie!)
Removed all the stats from each class that have no value (ie, priests don't need a Defense and Shield Block column)
More meaningful effective stats added for each class, tailored for that class.
Earthfury is available for comparsion on the shaman sets (the other classes are only T2, T2.5 and T3) because there are too many nubcakes still using it.
v3.0.1 - added the 1% spell crit to ten storms belt that I missed, link updated above
v3.0.2 - wow, major error on rogue bloodfang chest, it was sharing stats with the bonescythe chest.
v3.1 - the rogue chests had been swapped around with the wrong item name for each set of stats

I think you'll all like this version of the spreadsheet much more.

If anyone has info on other meaningful comparisons to make between the Tiers of armor, please let me know and I'll try to work it in.

Also - I am willing to update this with non-set items, for things like tanks who wear the AQ40 shoulders, things like that. If you want something added to the file that is generally accepted as a "good" item for that slot (not just some off the wall piece of shit you want to compare for shits and giggles) post a link to the data for the item in this thread and I'll work it into the file structure.

jubelio · 08/03/06, 1:53 PM

This is good stuff.

Decker · 08/03/06, 2:29 PM

Hunter sets are missing +hit in the Hunter tab.

Dricen · 08/03/06, 2:31 PM

The only detail i think is missing, when considering priorities for these sets, are the set bonuses, for instance, Doomcaller is huge improvement over Nemesis for a warlock as a PvE set, not because of raw stats but because of the full set bonus.

Of course i can't really say it's the #1 deciding factor for a lot of classes, just giving the warlock set as an example that i know of.

Other than that, awesome stuff :) .

Malan · 08/03/06, 2:34 PM

Originally Posted by Decker

Hunter sets are missing +hit in the Hunter tab.

Fuck me. Thanks for the catch on that.

New link with the update
http://files.filefront.com/Tiered_Ar.../fileinfo.html

Malan · 08/03/06, 2:39 PM

Originally Posted by Dricen

The only detail i think is missing, when considering priorities for these sets, are the set bonuses, for instance, Doomcaller is huge improvement over Nemesis for a warlock as a PvE set, not because of raw stats but because of the full set bonus.

Yah but how the hell do you compare set bonuses?

Shaman Tier3 2-set bonus is "Reduces the mana cost of your totem spells by 12%."
Shaman Tier2 3-set bonus is "Increases the amount healed by Chain Heal to targets beyond the first by 30%."

What sort of mathematical relationship would I establish to compare that? That's why I didn't even write them down, I can't think of a meaningful way to compare them. People either love or hate their set bonuses, as a for instance, my druids think their T3 is shit and don't want most of it. I personally think they're nuts.

Dricen · 08/03/06, 2:45 PM

indeed, i'm just mentioning it because the point of the sheet was to facilitate comparison and establish a priority for certain classes, and in the case of the warlock class it's all due to the set bonus really.

I can't think of a mathematical way to give a value to it, shrug, i guess you could add it on the disclaimer for something to keep in mind :?

• Maestroquark · 08/03/06, 2:49 PM

Originally Posted by Malan

Edit - now on v2.1 because of a stupid mistake on the hunter tab.
- Added "Effective" stats, showing how the base stats of Int, Str.. .etc will add to things like Crit, Dodge, Dmg Mitigation, etc

The Effective Phys Crit, at least, isn't accurate.

20 Agi = 1 crit for War
29 Agi = 1 crit for Rogue
Not sure what it is for Hunters, but it's 50 something.

Malan · 08/03/06, 2:55 PM

Originally Posted by Maestroquark

Originally Posted by Malan

Edit - now on v2.1 because of a stupid mistake on the hunter tab.
- Added "Effective" stats, showing how the base stats of Int, Str.. .etc will add to things like Crit, Dodge, Dmg Mitigation, etc

The Effective Phys Crit, at least, isn't accurate.

Sigh... used the wrong value for Rogues you're right. Hunters are 53 agi/crit btw.

Omelet · 08/03/06, 3:02 PM

Speaking of set bonuses, for Paladins tier 2 and tier 2.5 both contain a straight +damage/healing bonus :

Judgement 5 piece is +47 damage/healing
Avengers 5 piece is +71 damage/healing

This turns the defecit of 23 for 2.5 compared to tier 2 into advantage of 1 damage/healing.

However, I don't know of any other set bonuses that are so easily quantifiable.

Avs · 08/03/06, 3:11 PM

Originally Posted by Malan

Originally Posted by Dricen

The only detail i think is missing, when considering priorities for these sets, are the set bonuses, for instance, Doomcaller is huge improvement over Nemesis for a warlock as a PvE set, not because of raw stats but because of the full set bonus.

Yah but how the hell do you compare set bonuses?

Shaman Tier3 2-set bonus is "Reduces the mana cost of your totem spells by 12%."
Shaman Tier2 3-set bonus is "Increases the amount healed by Chain Heal to targets beyond the first by 30%."

What sort of mathematical relationship would I establish to compare that? That's why I didn't even write them down, I can't think of a meaningful way to compare them. People either love or hate their set bonuses, as a for instance, my druids think their T3 is shit and don't want most of it. I personally think they're nuts.

Its just more work. You would create a second worksheet or add onto the class worksheet that compares spell ranks, effect of their bonus, utility gains from partial sets, spells used (in conjunction with their ranks), number of targets affected, and so on and so forth. After a mulling around for a bit you'll end up with a couple scenarios in which one or the other will be emperically reinforced by a hypothetical point system you'd apply to every stat to generate some sort of ranking. Then you'd probably have to explain outliers for unique scenarios or give them a pro/con review.

Paxon-IC · 09/21/06, 11:44 AM

Is there a working link for this? I tried pulling it from filefront, but there are currently no servers with the file.

Thanks

Malan · 09/21/06, 11:57 AM

http://files.filefront.com/Tiered_Ar.../fileinfo.html

Sadly the newer version which is much nicer and allows you mix/match set items for comparison using drop downs is sitting at about 80% complete.
Is there enough interest in me completing it?

Taikero · 09/21/06, 11:59 AM

The download link doesn't work. Apparently there isn't a Filefront server that has the file.

snape · 09/21/06, 12:05 PM

For 8/8 NW, the set bonus is "roughly" equivalent to a 6% increase in overall DPS if you're Frost, or 6.66% if you're Fire (assuming that the global CD is 1 second, and your main nukes are Frostbolt and Fireball, respectively).