Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Public Discussion » Public Discussion

Reply
 
LinkBack Thread Tools
Old 07/27/06, 5:38 PM   #1
Malan
Mike Tyson
 
Malan's Avatar
 
Malan
Tauren Shaman
 
No WoW Account
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.

United States Offline
Reply With Quote
Old 07/27/06, 5:58 PM   #2
Thorb
Piston Honda
 
Murloc Warrior
 
Lothar
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.

Offline
Reply With Quote
Old 07/27/06, 6:02 PM   #3
 frmorrison
Protector
 
frmorrison's Avatar
 
Ashstrike
Human Paladin
 
No WoW Account
Interesting. I just took a short glance, it looked good.

United States Offline
Reply With Quote
Old 07/27/06, 6:17 PM   #4
Whiteknight
Bald Bull
 
Whiteknight's Avatar
 
Night Elf Warrior
 
Proudmoore
Dreadnaught Sabatons have incorrect values for STA and STR.

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

Offline
Reply With Quote
Old 07/27/06, 6:47 PM   #5
Malan
Mike Tyson
 
Malan's Avatar
 
Malan
Tauren Shaman
 
No WoW Account
Originally Posted by Whiteknight
Dreadnaught Sabatons have incorrect values for STA and STR.

AP-10 should be 34, not 26
AQ-10 should be 15, not 9
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.

United States Offline
Reply With Quote
Old 07/27/06, 7:13 PM   #6
Judia
Banned
 
Murloc Paladin
 
Grim Batol(EU)
Erm
You didnt include paladins.

Offline
Reply With Quote
Old 07/27/06, 7:54 PM   #7
 frmorrison
Protector
 
frmorrison's Avatar
 
Ashstrike
Human Paladin
 
No WoW Account
Originally Posted by Judia
You didnt include paladins.
The guy is a Shaman.

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

United States Offline
Reply With Quote
Old 07/28/06, 3:20 AM   #8
Judia
Banned
 
Murloc Paladin
 
Grim Batol(EU)
Originally Posted by frmorrison
Originally Posted by Judia
You didnt include paladins.
The guy is a Shaman.

On your Rogue tier 2.5 to 3 comparison, you forgot the AP on Tier 3 in your numbers.
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.

Offline
Reply With Quote
Old 07/28/06, 3:30 AM   #9
Grayson Carlyle
Take what ye can;
 
Grayson Carlyle's Avatar
 
Tauren Warrior
 
Turalyon
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.

/ 人◕ ‿‿ ◕人 \

Canada Offline
Reply With Quote
Old 07/28/06, 9:35 AM   #10
 Maestroquark
What Would You Have Me Do?
 
Maestroquark's Avatar
 
Ramala
Orc Rogue
 
No WoW Account
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.

Cally - EJBSG 27; Dee Baltar - EJBSG 22; Tory - EJBSG 20; Leoben - EJBSG 19; Helo - EJBSG 14; Starbuck - EJBSG 12

United States Offline
Reply With Quote
Old 07/28/06, 10:52 AM   #11
Malan
Mike Tyson
 
Malan's Avatar
 
Malan
Tauren Shaman
 
No WoW Account
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?

United States Offline
Reply With Quote
Old 07/28/06, 11:14 AM   #12
Decker
Piston Honda
 
Orc Hunter
 
Kargath
Hunter Tier 2 to 2.5 Upgrade (Gain/Loss) just 24 armor? :)

http://www.paradosi.net

Offline
Reply With Quote
Old 07/28/06, 1:56 PM   #13
 Maestroquark
What Would You Have Me Do?
 
Maestroquark's Avatar
 
Ramala
Orc Rogue
 
No WoW Account
Originally Posted by Malan
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?
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.

Cally - EJBSG 27; Dee Baltar - EJBSG 22; Tory - EJBSG 20; Leoben - EJBSG 19; Helo - EJBSG 14; Starbuck - EJBSG 12

United States Offline
Reply With Quote
Old 08/01/06, 10:57 AM   #14
Malan
Mike Tyson
 
Malan's Avatar
 
Malan
Tauren Shaman
 
No WoW Account
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?

United States Offline
Reply With Quote
Old 08/29/06, 9:27 AM   #15
Kalia
Glass Joe
 
Human Warrior
 
Bronzebeard
Bump. Sorry to ressurrect, but the link doesn't seem to be working for me, could someone rehost? thanks.

Offline
Reply With Quote
Reply

Go Back   Elitist Jerks » Public Discussion » Public Discussion

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Armor Analysis by Class - spreadsheet Malan Public Discussion 0 09/24/06 9:40 PM
Zero-Sum Upgrade Systems Hamlet Public Discussion 30 06/02/06 5:29 PM