1.11 The Perfect Grail Status Tables

[Sir Lister of Smeg]

Some remarks:

Bverrit Keep: + duration is listed separately in ATMA, so I guess that is what should be listed instead of the total durability (this might be different in game though)
Cow King's Hooves: base defense is not listed, the only way I can guess it is by subtracting the + defense that is listed. (I feel this contradicts somehow with the above, but I might be wrong) The same problem probably applies to various other items. (same goes for Dark Adherent)
Ethereal Edge: Life after each demon kill, not life after each kill
Hellslayer: Range of fireball level different, the lowest I have is with level 13 (but that one is old, from before 1.10, so I guess it's okay)

[Hrus]

                  Self-Found 1.11 The Perfect Grail
Name              Type                  Perfection [%]     #Perfect Items
Hrus              1.11b Vanilla         86.81              190
Tigereye          1.11b Vanilla         77.40              191
EasyGijs          1.11 RWM/RRM          59.87              132
Quickdeath        1.11 Vanilla          53.08              139

                  1.11 The Perfect Grail Including Trade
Name                Type                       Perfection [%]

Finally typed all of this, the interesting thing is that I have the same number of perfect items as Tigereye...

My worst item is Todesfalle Flamme (27.5%).
My best items are probably Arioc's Needle and Bonesnap (perfect)

EDIT: Just found an error - Earthsifter is allways counted as perfect if you have one... So I have one less perfect item than Tigereye now.

[Sir Lister of Smeg]

I got to the N and noticed stamina listed for Natalya's Soul, I do however see no such mod on any of them in ATMA. (stamina per level yes, but that's fixed)

I guess I'll skip the item for now, unless I'd find one that is perfect otherwise (so I could fill in the highest value for stamina without creating a wrong percentage), but I know I don't have one.

Edit: I calculated the average from the other mods, multiplied that with 20 and added 100 to get the equivalent score for the stamina in the 100-120 range without influencing the score for the item from a nonexistent mod.

[Hrus]

I have no such a mod for Nat's boots in my spreadsheet. Are you sure you have the most recent version?

[Tigereye]

I have no such a mod for Nat's boots in my spreadsheet. Are you sure you have the most recent version?

The stamina mod has been in an intermediate spreadsheet. You can just delete the entire line and it should be OK.

[Sir Lister of Smeg]

The stamina mod has been in an intermediate spreadsheet. You can just delete the entire line and it should be OK.

If I download it again, I do again get the stamina mod there, but I'll try instead of opening it straight away, saving it first. I have a feeling that the temporary file is not overwritten. If that does not work, I can either try another browser which might (and only might since I'm using Linux) save it to a different temporary folder, or save my session and then delete private data.

Just one question, are you sure just deleting that row won't break other things? I've noticed most (if not all, I have not discovered any other) calculations are relative, but I do have an inherent distrust of spreadsheets (I had to do things in excel some five years ago, which was the trauma that probably caused this PTSS).

Edit: I did not try saving my session and deleting private data yet, however, I did download it in Firefox instead of Opera, and Firefox does save it to a different location (for some reason which starts to baffle me more and more and I need to change it, I'd set Firefox to automatically download to my desktop, Opera always asks for the location which is far nicer, and the default there is my home folder, not my desktop). I keep seeing the stamina though. So I have quite little hope that saving my session and deleting private dat would change anything.
I'm going to try something different, closing the apparently older version of the spreadsheet where I was entering the data so openoffice is completely shut down, and then I'll try to reopen one of the newly saved versions of the empty spreadsheet. The issue seems to be from bad handling of different versions (in different locations) of the same file by calc, not from the browsers.

Edit: (again) I closed all openoffice windows and tried again with no luck. Then I wanted to log out and log back in, but unfortunately pressed the reboot button instead (which I wanted to keep as a next step). Nevermind, after logging back in, I found that the spreadsheet does still contain the stamina for Natalya's Soul. Then I thought that maybe, just maybe, some of you have been referring to the spreadsheet as filled in by Easygijs instead of the empty version, so I checked that one, and indeed there there does no stamina appear. I had stayed away from that one (I opened it once just to look, but that's all), since I did not want to accidentally not delete an item which Gijs has and I don't. Anyway, I'll make a backup of my partially filled in version and then try and see what happens if I delete the stamina line from Natalya's Soul.

Btw, Gijs, do you have a list of all the changes made since the first version? This would facilitate checking whether there are any items that need changing. (and I don't want to fill in everything anew) I did already make some manual changes such as the high end of Aldur's Boots' defense being too low, and am now going to do the same for Natalya's Soul. But I think I remember Flamebellow being mentioned as well, and some more items.

[Sir Lister of Smeg]

Seraph's Hymn has a few more variable stats, in total (assuming Arreat Summit info is correct on this one):
defensive auras 1-2
enhance damage to demons 20-50
attack rating versus demons 150-250
enhance damage to undead 20-50
attack rating versus undead 150-250

[Sir Lister of Smeg]

                  Self-Found 1.11 The Perfect Grail
Name               Type                  Perfection [%]     #Perfect Items
Hrus               1.11b Vanilla         86.81              190
Tigereye           1.11b Vanilla         77.40              191
Sir Lister Of Smeg 1.11b RWM             70.72              183
EasyGijs           1.11 RWM/RRM          59.87              132
Quickdeath         1.11 Vanilla          53.08              139

                  1.11 The Perfect Grail Including Trade
Name                Type                       Perfection [%]

Finally finished, although I still have to go over a few things again to see if anything was changed in the newer sheet, a few things I did add in already, but I'll do a line for line comparison of the affixes that are variable. That should take far less time than filling in the sheet. I guess all in all it took me ten hours or so (Easygijs' estimate of 2 hours in the other thread was a bit optimistic for those of us who tend to pick up and keep every set/unique item, although I did sell a few lately) , but I didn't time it. Although I did say 1.11b above, I'm sure many least imperfect items were in fact 1.10, and a few 1.09 or earlier.

Furthermore I was a bit surprised about the (im)perfect sets, especially about Immortal King being perfect and Arctic, Iratha, Milabrega, Sander, and Vidala not:
Perfect: Angelic, Arcanna, Berserker, Cathan, Civerb, Cleglaw, Death, Hsarus, Hwanin, Immortal King, Infernal, Isenhart, Sigon, Tancred, Orphan.
Imperfect: Aldur, Arctic, Disciple, Iratha, Milabrega, Naj, Sander, Heaven, Vidala.
Incomplete: Bul-Kathos, Cow King, Griswold, M'avina, Natalya, Sazabi, Tal Rasha, Trang Oul.

Best and worst items:
Worst: Darksight Helm at 0% (so bad it's not even displayed), followed by Thunderstroke at 7% and Arachnid Mesh at 13.33% (the latter being the best of three)
Best: Civerb's Ward (the only one with three or more variable affixes that I do have in a perfect version, but a 1 in 12 chance).
or: Bartuc's Cut Throat (1 in 255)

(Close, but no cigar: Gimmershred 98%, The Battlebranch 97.5%, Spirit Forge 97.5%, Moser's Blessed Circle 97.5%, Doomslinger 97.5%, Demon's Arch 97%, Bonesnap 97%)

I was surprised the resistances on Skin Of The Vipermagi can go up to 35, I thought it was 30. (The highest I found so far was 27, with most having 21)

Snowclash: level of Blizzard on struck can vary, but might be item level dependent. I did not edit this in yet.

Steelgoad vs Steelclash: both have a modifier + to max durability, yet in one case that modifier is displayed in the sheet (Steelclash) and in the other the total durability (Steelgoad). In both cases the + max durability is displayed in ATMA, and in both cases the Arreat Summit does not display that modifier but says that the durability varies. (There are many other items to which this applies)

Tal Rasha's Fine Spun Cloth: in ATMA the 60 defense bonus is always displayed, even on a character having only that as only item, leading to defense ratings from 96-100 instead of 36-40. (it took me a while to figure out what was wrong here). In other words, an ATMA bug.

(The Eye Of Etlich: isn't the shortest cold duration the best one damage-wise? Of course not for chilling effect, I guess what's more perfect is debatable here. For most it will be the chilling effect not the damage.)


Typo's:
Ondal's Almighty, not Ondal's Almight.
Warpspear, not Warspear.
Whitstan's Guard, not Whitsan's Guard.

[Tigereye]

I just downloaded the empty file and do not see any stamina in Natalya's Soul, this is done in windows using ie.

[Sir Lister of Smeg]

I just downloaded the empty file and do not see any stamina in Natalya's Soul, this is done in windows using ie.

Immediately upon reading that, I tried again as well, but in linux using opera, and indeed this time the stamina has disappeared, apparently Gijs is updating.