1.11 The Perfect Grail Status Tables

[Tigereye]

Also, Natalya's Soul is missing its stats altogether. I suggest you update your spreadsheet with all these corrections, and then post the empty version as part of the table that gets carried from post to post.

I think EasyGijs is updating it as we find any corrections, The version I downloaded the Natalyas was fixed, like EasyGijs said he did in the thread he linked to.

I just downloaded it again and there has been some more corrections as far as I could see.

Edit: Damn spacebar is not working probably.

[Sir Lister of Smeg]

While filling it in, in addition to the issues mentioned by Quickdeath and Tigereye:

Arcanna's Flesh: defense is displayed at 100 higher in ATMA (looking at the Arreat Summit explained why)
Arctic Binding, Furs and Horn, whole Angelic set, Arcanna's Death Wand: B-column is missing with a result of no value in H either. (For the always perfect items among those (all except the Furs) this assumes one has to put the 1 in the D column, not the B column)

Only got as far as the A so far, now I'm back off to bed.

[Quickdeath]

                  Self-Found 1.11 The Perfect Grail
Name              Type                  Perfection [%]     #Perfect Items
Tigereye          1.11b Vanilla         77.40              191
EasyGijs          1.11 RWM/RRM          52.27              117
Quickdeath        1.11 Vanilla          51.94              129

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

I still have several items to find and enter in the table (both unique javelins and Marrowwalks) but the above numbers represents my most complete list to date.

[EasyG]

                  Self-Found 1.11 The Perfect Grail
Name              Type                  Perfection [%]     #Perfect Items
Tigereye          1.11b Vanilla         77.40              191
EasyGijs          1.11 RWM/RRM          59.87              132
Quickdeath        1.11 Vanilla          51.94              129

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

Wow allmost 80 percent :shocked:, I thought 70 or 75 was a realistic goal...
Anyway, I allmost reached the 60's and the shapes of the graphs at the 2nd and 3th sheet start to look nice. My most amazing finds are a perfect Tals Guardianship (Armor) 1:109 and a perfect Darksight Helm 1:210

[EasyG]

While filling it in, in addition to the issues mentioned by Quickdeath and Tigereye:

Arcanna's Flesh: defense is displayed at 100 higher in ATMA (looking at the Arreat Summit explained why)
Arctic Binding, Furs and Horn, whole Angelic set, Arcanna's Death Wand: B-column is missing with a result of no value in H either. (For the always perfect items among those (all except the Furs) this assumes one has to put the 1 in the D column, not the B column)

Only got as far as the A so far, now I'm back off to bed.

For the allways perfect ones you should fill in a 1 in the B column, not in the D column, that should fix the problem. For the furs, i repaired that.

[Tigereye]

My most amazing finds are a perfect Tals Guardianship (Armor) 1:109 and a perfect Darksight Helm 1:210

Nice Tal's Guardianship :wink3: .

My best 100% perfect finds are The Minotaur (1:366), Ginther's Rift (1:306) and Steelclash (1:246) all having dobbelt variable stats :grin: .

My worst find is probably my 5.91% Astreon's Iron Ward and my 6.67% Shaefer's Hammer :cry: .

[Hrus]

I will try to fill in my perfect grail, though I think I will not go through all my characters to check if there is somewhere a better version for all the items.
I also think that it's not necessary to forbid all eth items when most of them don't affect the perfection. I would just forbid those few eth items where the (base) Def is variable...

[Sir Lister of Smeg]

For the allways perfect ones you should fill in a 1 in the B column, not in the D column, that should fix the problem. For the furs, i repaired that.

In that case (and it does make sense), I suggest changing the yellow colouring for the always perfect items to be in the B column not the D column. (It would be less work to instead copy the formula as present in the B column for the potentially imperfect items to the B column for the always perfect items, this is what I did so far, but I'll change it back for consistency (spelling?))

Anyway, with all those minor changes that have to be made, how does one upgrade to a newer version of the sheet without having to reenter all the data? Is this possible with any type of spreadsheet? In other words how to separate the data on one hand and the calculations and form on the other? I can give some examples where this is used in the form of (scientific) documents and webpages. In documents, the data is in the (La)TeX file, while a class file is used to describe how these elements are displayed, very useful if one wants to try (or is forced to by a journal having a `housestyle') different styles. For webpages, the data is in the (x)html file or a database, while the formatting is in the css (or xls) file. Now afaik, neither of these can do the calculations needed. I can think of one way which works with spreadsheets and that is exporting the data after entering, and then reimporting into a newer version, still that does to me look like a few steps too many.

Anyway, I'll shut up and continue entering the data.

[Randall]

though I think I will not go through all my characters to check if there is somewhere a better version for all the items.

Starting from Flavie version 1.5b2 there is a "tab" items in Flavie. (in 1.5b3 some filters are added here, but these new filters only work with direct d2s/d2x reading.)

The table in the items "tab" displays 3 columns:
- fingerprint
- item name
- file name

When you use direct d2s/d2x reading, you can filter this tab with filters like "unique" and/or "set" items ("Armor" and/or "weapon") so it's more easy to find specific items.

Although you still have to check the items manually, at least you can find out which stash/character you need to check for a specific item.

[Quickdeath]

                  Self-Found 1.11 The Perfect Grail
Name              Type                  Perfection [%]     #Perfect Items
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 [%]

Well, I'm plugging away, but mostly doing a canvas of my stashes. Still can't find three items that I know I have somewhere. But I'm doomed to last place until someone else joins the list.

My best perfect is a Bonesnap - 101 variations. And its a useful variable mod on a very useful unique!