The Perfect Grail
- Thread starter EasyG
- Start date
Sir Lister of Smeg
New member
I am 90% sure that lvl of CtC Holy Bolt on Boneslayer Blade doesn't vary, it's generated based on ilvl of the item, in similar way like generating levels of CtC skills or charged skills on rare items.
EDIT: The same for Hellslayer. (3.5 hours and I am at Hellslayer now)
Yes, I got as far as Lance Of Yagai or so and am now taking a break to actually play the game.
Would it be possible to read all the different stats from the game files (I know the answer is yes, I don't know how), so we won't have to deal with unreliable and contradicting sources of information. I actually went through them for the Boneslayer Blade, but I found I could not see from there what the actual range was, do you have more of an idea how to do that?
Quickdeath
New member
(3.5 hours and I am at Hellslayer now
Hrus, you must be the champion magic finder on the SPF. It will really be fascinating to learn your score. I'm surprised that Tigereyes achieved 77% (a tremendous accomplishment, Tigereyes!), so I imagine you'll be around 85-90%.
I'm interested in Sir Lister's score as well - this is an interesting way to compare the stashes of the elite players (of which I definitely am not!)
The one statement I don't agree with is that a "perfectly bad" S/U deserves a zero score. Pity the poor player who finally finds a Sander's Paragon (Defense varies from 3-5) only to discover that the Paragon has a defense of 3 and is worth zero on this spreadsheet. That's not right.
And Sir Lister, I agree with your comments about my scheme of ranking of modifiers from 1 to 5 - that's why I didn't put much work into the posting. I just wanted to see whether it made any sense to anyone else. Apparently not!
I am 90% sure that lvl of CtC Holy Bolt on Boneslayer Blade doesn't vary, it's generated based on ilvl of the item, in similar way like generating levels of CtC skills or charged skills on rare items.
EDIT: The same for Hellslayer. (3.5 hours and I am at Hellslayer now
To EasyGijs, I looked at my Boneslayer Blade, and I think it is safe to say that Hrus is correct, but the range should be 12-20.
My Bonelayer Blade looks like this:
Ilvl 55 => HBlvl 13
Ilvl 75 => HBlvl 18
Ilvl 82 => HBlvl 20
Ilvl 86 => HBlvl 20
Ilvl 99 => HBlvl 20
This must mean that the maximum HBlvl is 20 and the minimum is 13 or lower.
The Boneslayer has a qlvl of 50 and thereby must have a Ilvl of 50 or higher, I think this looks (from my 5 finds) like it corresponds to HBlvl 12.
So EasyGijs you should change the range of the Boneslayer Blade's HBlvl to 12-20. I think it should still be a variable in the perfection calculation.
My Hellslayer's looks like this:
Ilvl 86 => FBlvl 19
Ilvl 86 => FBlvl 19
Ilvl 86 => FBlvl 19
Ilvl 87 => FBlvl 19
Ilvl 88 => FBlvl 20
Ilvl 88 => FBlvl 20
Ilvl 88 => FBlvl 20
Ilvl 99 => FBlvl 20
So from this it can again be concluded that FBlvl 20 is max, but the min is somewhat elusive. The Hellslayer has a qlvl of 71 (Decapitator has a qlvl of 73) so the Ilvl must 71 or 73 (I am not sure here) but if this corresponds to FBlvl 16 is hard to say. But maybe someone has a lower Ilvl Hellslayer?
The same for Stormrider and The Rising Sun. IMHO they should be all counted as non-variable stats because they are not randomly chosen (they should be removed).
Also Seraph's hymn amulet has not listed Damage against undead and AR aginst undead variable properties.
I am done (it took around 7-8 hours) and I will post in the other thread soon
Also Seraph's hymn amulet has not listed Damage against undead and AR aginst undead variable properties.
I am done (it took around 7-8 hours) and I will post in the other thread soon
saracen85
Well-known member
wow.. now seeing those stats, now i know y all my hellslayers (fball lvl 19), boneslayer blades (hblvl 20) n rising sun amulets (meteor lvl 13) hv the same ctc levels..now i juz wonder this applies to lightsabre as well?all 7-10 that dropped for me hv ctc chain lightning lvl 18=P
Sir Lister of Smeg
New member
Since when am I an elite player?
As to your comment on perfectly bad items, I agree. So far I have one which is perfectly bad and it's one item that I do really appreciate in spite of it's imperfection, the only Darksight Helm I found so far, I wonder whether I'll encounter more like those.
I also was quite surprised that I do have a perfect IK set (luckily the armour is always perfect), but no perfect Iratha's set.
I'm only now continuing with Langer Briser, to my surprise I actually guessed correctly that the Lance Of Yaggai was the last one I did yesterday.
I'm sorry for the many mistakes in the sheets. You have to understand it was a pain to make them. ATM i do not have any time to work on the sheet, but I will fix all the corrections told in this forum. I will also give each update a version number and write in an extra sheet what is changed in each version and how you can change it in your own sheet, so you don't have to fill in a new sheet again.
I think us who filled in the spreadsheet understand a little about how much work you must have put in to this, thank you very much for doing this. It sounds like a good idea to change the corrections other people find and keep track of the corections like you plan.
purplelocust
New member
Thanks again, EasyGijs, for making the sheet! I entered a bunch of data and noticed a few problems, but it seems like everything that I noticed has already been mentioned earlier in this thread (Seraph's Hymn, etc.) A version number would be great and if the line numbers change, an explanation of how to cut and paste from earlier versions would be great. That is, for Seraph's, for example, you'll need to add a few lines of input, so that will change the row numbers if people want to paste in things from the earlier versions. Or maybe just an explantion of making the changes. As long as there is some easy way of updating without re-entering all the data, that would be great!
I said earlier that the sheet works fine with NeoOffice. I did notice one problem, which I think is a NeoOffice and OpenOffice problem since it happened in both, which is that beyond line 256 the perfection percentages don't appear. The calculations are there, but the results don't appear. It works fine with Google's spreadsheet though, which is pretty impressive. I'd never had occasion to use it before. It's at http://docs.google.com/
An update on the program calculating the perfection percent:
Using Java (never tried this before so there is a lot of trial and error stuff going on) and have finished a program which can read a txt-file in the form of a full ATMA dump and locate all "Axe of Fechmar" and calculate the perfection percent.
I think this is enough for today (always finish when on top, then it easier to pick it up again), now for some actual playing.
The next step would be to add more items, and after this is done ... I dont know yet, but guess I have some time before this happens.
Using Java (never tried this before so there is a lot of trial and error stuff going on) and have finished a program which can read a txt-file in the form of a full ATMA dump and locate all "Axe of Fechmar" and calculate the perfection percent.
I think this is enough for today (always finish when on top, then it easier to pick it up again), now for some actual playing.
The next step would be to add more items, and after this is done ... I dont know yet, but guess I have some time before this happens.
Sir Lister of Smeg
New member
Very odd, I'm using Open Office for it and have no such problem, which version are you using? I did however notice that whenever any perfection percentage is 0, it's not displayed as such, instead the cell remains empty. This applies however to the entire sheet and I don't regard it as a problem (although it would be nice if it would not happen, so I would get to see the 0% for my Darksight Helm). What I did notice, was that when entering new items, the total perfection percentage does not appear until all the cells belonging to that item have been filled, this is odd, considering how things are defined, this is however just as much the case before line 256. I must add that at least sometimes, the total percentage does appear before all cells have been filled. I just tried Astreon's, and the total percentage appeared after filling the four first cells, in spite of there being five in total (and that fifth is taken into account in the calculation).
purplelocust
New member
I'm using NeoOffice 1.2.2 and OpenOffice 1.2.2. This seems like some kind of display problem (this is on MacOS X- I didn't try it on any of our linux boxes), although it's strange and suspicious that it only starts after row 256. On the screen, those boxes appear empty, but printing or creating PDFs they are filled properly. So it's an inconvenience but not bad. As long as the google one is working well, I'm not going to worry about it!
Sir Lister of Smeg
New member
That looks like an 8-bit version of Open Office.:wink3:
My version is 2.0.4, looking at the version numbers you mention, is it just coincidence that NeoOffice and OpenOffice are the same version?
purplelocust
New member
No, I think they are built from the same source for the underlying code- it's the front ends that are different. I'll try the v2.x.y ones but there isn't much need as the google one currently works great.
purplelocust
New member
I did sort out the problem and it's working fine now under version 2 of NeoOffice. It wasn't a NeoOffice problem-- I think it was saving it in "xls" format after I made changes and then opening that and saving it in "sxc" somehow got the formatting tangled up. I started with a fresh copy and pasted the value data in and now it works fine, with all the cell formatting proper and percentages appearing where the should be.
I noticed a few more typos double checking:
cells that should be blank that are not:
B232, B233, B234 overcount Eschuta's
B283, B284, B285 overcount Goldstrike Arch
B293, B310, B397:B400, B404, B405, B415, B416
B549:B551, B561, B565:B567, B570, B572, B573
B588, B589, B643:B646, B702, B714
and cell B375 should read =IF(D375>0;1;0) instead of being blank
These aren't crucial mistakes and they don't affect the perfect items count or the overall perfect percentage. But they do keep an overall count of S/U by doing =sum(B3:B873) from being correct, mostly by overcounting items.
Thanks again for the spreadsheet, EasyGijs!
I noticed a few more typos double checking:
cells that should be blank that are not:
B232, B233, B234 overcount Eschuta's
B283, B284, B285 overcount Goldstrike Arch
B293, B310, B397:B400, B404, B405, B415, B416
B549:B551, B561, B565:B567, B570, B572, B573
B588, B589, B643:B646, B702, B714
and cell B375 should read =IF(D375>0;1;0) instead of being blank
These aren't crucial mistakes and they don't affect the perfect items count or the overall perfect percentage. But they do keep an overall count of S/U by doing =sum(B3:B873) from being correct, mostly by overcounting items.
Thanks again for the spreadsheet, EasyGijs!
purplelocust
New member
I missed the edit window on the last post and I have some more typos spotted: cells B154, B407, B547, B558 and B777 should be blank.
The reason I have been obsessing about that B column is that it can be used to get the usual, typical grail counts. If those B column entries are correct, then totaling it should give the number of s/u in the overall grail. I must still be missing a double-counted one or have some other typo, since I seem to be off by one. In B878 I have =871-COUNTBLANK(A3:A873) to give the total number of items (a correct 504) and in cell B877 I have =B878-SUM(B3:B873) which gives 43 for me, when I know I am missing 44 items for my grail. I haven't found the final problem and I'll look again at some future time...
The reason I have been obsessing about that B column is that it can be used to get the usual, typical grail counts. If those B column entries are correct, then totaling it should give the number of s/u in the overall grail. I must still be missing a double-counted one or have some other typo, since I seem to be off by one. In B878 I have =871-COUNTBLANK(A3:A873) to give the total number of items (a correct 504) and in cell B877 I have =B878-SUM(B3:B873) which gives 43 for me, when I know I am missing 44 items for my grail. I haven't found the final problem and I'll look again at some future time...
NacRuno
Member
i will try to organise my stashes and try to do a perfect count myself, however i assume there were a number of errors on the data sheet. does anyone know all the errors that needs to be changed? if someone can list the errors i can edit the file and host the edited file on a page for future use.
i am also planning to divide the list into sub menus like normal set, expansion set, elite unique... but i don't think it would help much to those already done their listing as relisting the items would be too bothersome =)
i am also planning to divide the list into sub menus like normal set, expansion set, elite unique... but i don't think it would help much to those already done their listing as relisting the items would be too bothersome =)
In my version of the spreadsheet, Kira's Guardian has three variables (B406,B407,B408). You only mentioned the overlap in B407, not the one in B408. Is this the one you missed?
purplelocust
New member
You had my hopes up there! But I did blank those two cells out, I just omitted mentioning B408, so that wasn't it. Thanks for looking and checking!