Malan

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.

Shitting up every single thread on EJ since '06

 

jubelio

This is good stuff.

 

Decker

Hunter sets are missing +hit in the Hunter tab.

http://www.paradosi.net

 

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.

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

Fuck me. Thanks for the catch on that.

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

Shitting up every single thread on EJ since '06

 

Malan

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.

Shitting up every single thread on EJ since '06

 

Dricen

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

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.

What are you waiting for, a certain shade of green?

 

Malan

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

Shitting up every single thread on EJ since '06

 

Omelet

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

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

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

Thanks

 

Malan

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?

Shitting up every single thread on EJ since '06

 

Taikero

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

 

snape

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).

 

Malan

My god man you're right. Tell ya what, my day is looking to be pretty boring here at work today, I'll work on the new version of it again and try to get it finished.
All I had left to complete on the newer one is adding paladins and mages, and completing the effective stats for a couple classes. Might be about 2 hours of work. Keep an eye on this post and I'll update it later.

Shitting up every single thread on EJ since '06

 

snape

I love how we're all weeknight warriors...I'm at work now too. Do a few minutes of work...check EJ forums...do more work...yep, that's a work day.

 

Taikero

Work is boring here too. I'll be around.

 

Omentuva

Evil. :P But wasn't the GCD 1.5 sec, making it 4 and 5 %?

 

snape

I don't know! On my Warlock, I have 2/5 Improved Corruption, reducing its casting time to 1.2 seconds...and I can ALWAYS WITHOUT FAIL cast Curse of Agony right after. This shouldn't be possible if the GCD is 1.5 seconds...unless there's funny lag things going on, but my ping is always below 100 ms.

 

Malan

In my case its "refresh EJ... refresh EJ... oh look something new to read... refresh EJ... refresh EJ....oh look a piece of work that will take 5 min to complete... refresh EJ"

Shitting up every single thread on EJ since '06

 

Karway

I think there is a typo...Priest Tab row 26 says "Priest Tier 3 to Tier 2.5 Upgrade Gain/Loss". I beleive that should read T2 to T3 like all the other tabs.

 

Bibdy

Errr...

Anyhoo, you could always try totalling up the bonuses from each set and then dividing each by the number of pieces of the set as a way of including the stats from the bracers, gloves and belt pieces. Or taking the stats from the non-set pieces found inside AQ40, e.g. Burrower's Bracers, Dark Storm Gauntlets and Eyestalk Waistcord.

There's always free cheese in the mouse traps, but the mice there ain't happy.

 

alienangel

It looks like the AP you're calculating for hunters is melee AP. While that's accurate, and pretty easy to for the reader to calculate ranged AP from, it's a little misleading unless pointed out :P

 

Aphyrax

The GC (at least for mages) is certainly 1.5 seconds. I am able to get the "spell not ready" message when scorching with mind quickening gem activated.