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