Malan

Couple of weeks ago someone was asking if there were any numerical data floating around for comparison of all the possible set upgrades. Lengthy discussion of priorities for guilds followed but no such data ever emerged.

So, having a very boring job in the military right now I took the time over the past couple days to make some spreadsheets for the community.

Link to the file: (file is an Excel spreadsheet)
http://files.filefront.com/Tiered_Ar.../fileinfo.html

Note that the workbook has multiple pages. The first worksheet is "Sets" and is all the data for each piece of armor for T2, T2.5 and T3 for ALL classes on one page.
Each class then has its own worksheet (color coded by class) showing the gains/losses in stats for each Tier of Armor as you move between the 3 sets.

Edit - I hate when I hit submit and forget to paste the links.

Edit - Updated link after changing the file to reflect some bad values on the Warrior T2.5 set.

Shitting up every single thread on EJ since '06

 

Thorb

Interesting. For warriors why forget about agility? That's the main stats making conqueror interesting. Agi give dodges, crit and more AC, if you want a faire comparaison it need to include this and somewhat factor this into the net loss of dodge. This would be also usefull for other classes too.

 

• frmorrison

Interesting. I just took a short glance, it looked good.

DK - Ashbane Failure is the condiment that gives success its flavor.

 

Whiteknight

Dreadnaught Sabatons have incorrect values for STA and STR.

AP-10 should be 34, not 26
AQ-10 should be 15, not 9

 

Malan

Dammit. I think I made that error on an earlier version and propogated it.
Edit - Fixed the issue.

As to the question on Agility for warriors - That's my bad. I sort of changed the format I was using after a couple of classes into this and must have missed that. I'll update it for future versions. The computation is simply T3-T2.5 values or T2.5-T2 values if you want to see it for yourself.

Shitting up every single thread on EJ since '06

 

Judia

Erm
You didnt include paladins.

 

• frmorrison

The guy is a Shaman.

On your Rogue tier 2.5 to 3 comparison, you forgot the AP on Tier 3 in your numbers.

DK - Ashbane Failure is the condiment that gives success its flavor.

 

Judia

Yes, and so what ?
Its a nice piece of work, and well it would be nice if it didnt exclude 10% of the playerbase. At the very least he should mention it is horde only in his OP.

 

Grayson Carlyle

Not quite what Fog (the original requester) was going for. The idea was more along the lines of, say Desecrated Sandals dropped; which class would receive the most noticable upgrade for that slot; warlock, mage or priest? Taking into account set bonuses?

This information can be gleened from the spreadsheet, but it's organized in a less condusive fashion.

 

• Maestroquark

Losing dodge shoulders/boots is missing for Rogues T2 - T2.5 and T2 - T3.

One thing that could really help this is "effective" columns. Effective Armor, Effective AP, Effective Crit, etc ... how much you gain/lose including what the base stats give you.

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

 

Malan

Thanks for pointing out some of the errors, I'll see about getting this stuff worked in correctly on Saturday.

As for Paladins... yah I was going to include them and said "ah fuck it".

As for what you can gleen here for notable upgrades, up to you guys to decide that. I thought about putting a "analysis" box in there with my thoughts on each upgrade gain/loss, but I'm not nearly as hip with the numbers as some of you guys. I was just motivated enough to put it all in one spot for you.

Maestroquark - so you mean to say, have a set of columns that takes the class' base stat into account, and then showing what the final stat would be wearing the armor pieces?

Shitting up every single thread on EJ since '06

 

Decker

Hunter Tier 2 to 2.5 Upgrade (Gain/Loss) just 24 armor? :)

http://www.paradosi.net

 

• Maestroquark

Nope. For instance, take Rogues, Tier 2 to Tier 3 upgrade. You lose 71 agility, gain 8 strength, and gain 210 AP. In effective gains, it's 147 AP because AP = Agi + Str + AP for rogues. So you can have an "Effective AP" column for rogues that adds Str, Agi, and AP for the true AP. "Effective Crit" for Crit + Agi/29. Warriors can have an "Effective AP" that's AP + 2*Str, etc.

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

 

Malan

I'm in the process of redoing this spreadsheet with some of the suggestions made above.

As far as the "effective stats" - I'm doing it as an "effective gain/loss" based on Strength, Agility and any other stats that add to Armor, Dodge, Block Value, Crit, etc.
I was silly and hadn't seperated Crit into Physical and Spell crit which I will be correcting.
Also adding in the paladins.

Anything else that would have been nice to have included in the first run, or maybe some other data calculations that I can make that would aid in comparisons of the sets?

Shitting up every single thread on EJ since '06

 

Kalia

Bump. Sorry to ressurrect, but the link doesn't seem to be working for me, could someone rehost? thanks.

 

Malan

Fixed. Also should note I've been slowly making a newer version that is much much cleaner. Not sure what the interest was in it though so I've been terribly lazy about it.

Shitting up every single thread on EJ since '06

 

silversum

google... spreadsheets? jesus, they do everything now.

 

Malan

Unfortunately google spreadsheets doesn't support the format I've moved the data into.

Shitting up every single thread on EJ since '06