Version2.2 of Tiered Armor Analysis - Page 2

Malan · 09/21/06, 11:41 PM

Originally Posted by 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

The 2.2 version that was up there had some issues yah. The one I was revising into a new format fixes just about everything (I think). Kinda lost my motivation to finish it today though =\

Malan · 09/22/06, 5:09 PM

Version 3.0 of the file is uploaded, link is below.

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

See the first post in this thread for changes that have been made. All new structure/layout to the file btw, much nicer overall.

Haldane · 09/22/06, 5:38 PM

Great spreadsheet. One nitpick: the Belt of Ten Storms is missing its +1% spell crit. Just something I noticed as I was playing with the Shaman sets.

Malan · 09/22/06, 5:43 PM

Originally Posted by Haldane

Great spreadsheet. One nitpick: the Belt of Ten Storms is missing its +1% spell crit. Just something I noticed as I was playing with the Shaman sets.

I beat my head into my desk every time this happens. I'll upload it again....

Edit - corrected. v3.0.1

Edit - ok apparently I had all the damn chest pieces for rogues swapped with the wrong names, its been fixed now
v3.1 - http://files.filefront.com/ArmorAnal.../fileinfo.html

Karway · 09/22/06, 6:57 PM

I really like the latest spreadsheet (3.1)...but I must be blind because I dont see a mage tab.

I would like to see the effective stats for the comparison between the two sets stated in percentage increase/decrease as well as raw numbers. I would add the healing or damage changes to the effective stats area also.

Malan · 09/22/06, 8:26 PM

Originally Posted by Karway

I really like the latest spreadsheet (3.1)...but I must be blind because I dont see a mage tab.

Amazing. I fix one thing and break another. And somehow deleted that tab from ALL of my previous versions too. I'll have to rebuild that tab. :(

Originally Posted by Karway

I would like to see the effective stats for the comparison between the two sets stated in percentage increase/decrease as well as raw numbers. I would add the healing or damage changes to the effective stats area also.

You can see that in the 3rd table which lists all relative stat changes. "effective stats" are things that are dependent upon other stats. An example is Dodge, which is modified by your agility. Or Attack power which is modified by a variety of things. Now I probably *should* add Mana pool to that since I have Hitpoints already. Healing/Dmg is affected by no stat however - it is what it is.

• frmorrison · 09/22/06, 8:30 PM

Mage's sets are not present in your 3.1 version.

Also Rogues don't have a Bloodfang chest to pick from, however I looked into the Rogue items list and BF chest was there, it just isn't showing up in the drop down list.

When you first load the sheet, it says item not found (referring to BF chest).

I tried to add new items as well. If I added a row in the class x item list to insert the stats for a new item, but the spreadsheet didn't see the new entry.

Also your sig, you forget to put a ) at the end.

Malan · 09/22/06, 8:34 PM

Originally Posted by frmorrison

Also Rogues don't have a Bloodfang chest to pick from, however I looked into the Rogue items list and BF chest was there, it just isn't showing up in the drop down list.

When you first load the sheet, it says item not found (referring to BF chest).

Odd. I don't get an error but yah I see the #REF errors now. Somehow when I was cut/pasting the rogue shit around to fix the error earlier it jacked up the named list entry.

I tried to add new items as well. If I added a row in the class x item list to insert the stats for a new item, but the spreadsheet didn't see the new entry.

Its using named lists. You have to delete the named item from the Insert menu in Excel and then redefine it. You'd need to redefine both the list of item names, and the list of the stats (which includes the name for the cross reference)

Azgrim · 09/23/06, 2:35 AM

One error. You list Cryptstalker Headpiece as having 21 agility when it has 31.

Shaldome · 09/23/06, 12:53 PM

In the rogue tab you somehow screwd the columns. The dodge calculation factors in stamina instead of agility, physical crit stamina and dodge and hitpoints armor.

Flubber · 09/23/06, 3:28 PM

I saw you mention adding non-set pieces later on. Just to make your life easier when you decide to do that, here is all the great ilvl70+ elemental mail I could find:

http://www.wowhead.com/?search=elemental+fury
http://www.wowhead.com/?search=primalist%27s+link
http://www.wowhead.com/?item=21624
http://www.wowhead.com/?item=21607
http://www.wowhead.com/?item=21705
http://www.wowhead.com/?item=20638
http://www.wowhead.com/?item=21684
http://www.wowhead.com/?item=20629
http://www.wowhead.com/?item=18829
http://www.wowhead.com/?item=18546

That should be more than enough for a second 5pc 2.5 set and just chest/bracers short of another 8pc set. If you want more like this, feel free and send me a PM or just ask and I'll try and compile it for other classes. All ilvl70+.

Malan · 09/23/06, 5:13 PM

I've got all listed errors corrected, and I'll have a new link up as soon as SaveFile.com has its uploading enabled again, that way I can stop having to relink every damn time.