A place for discussions and questions specifically about the UESP Wiki.
Thu Jun 24, 2021 3:43 am
I don't really have a recommendation about the sorting order for the columns, but your suggestion seems good to me. We can click on the column headings to sort by any column we want, so the default order isn't too critical, but I like the idea of being able to look at the tables and scroll down to find the province I'm in, then the city I'm in, to see what's available in that city.
As for combinations of items and effects that might not exist, my theory is that every possible combination can exist in the game, even if it isn't available for purchase from a Mages Guild or equipment store. That is to say, I think any "missing" combinations might be able to be found as randomly-generated loot within the dungeons and houses, as well as dropped by certain enemies.
Sat Jun 26, 2021 2:46 am
I was not able to do much data-mining today. Instead of starting a new province, I decided to revisit the previously surveyed settlements in Summurset Isle, Black Marsh, and the Imperial City. I have not verified the accuracy of the data compared to the existing tables. I just wanted to have full sets of data for a few provinces that I know that I have visited.
According to my research, it seems that a spell has been missed from the list in the Buying and Selling page. Instead of 30 spells, there should be 31. The extra one that I found is Toxic Cloud. It has two instances in my records: Black Marsh, Thorn -- Mark 5250; Summurset Isle, West Guard -- Mark, 6950. Since it is not part of the list, I cannot determine what the cost per charge might be. The equation is not providing integer values that make sense. More number crunching will be necessary
That particular mark was discovered in High Rock, Farrun and Summurset Isle, West Guard according to the table for marks. I have not checked the other three items to see if they have a combination with Toxic Cloud for their existing tables.
So, with 31 spells that can be combined with magical items, I have confirmed that a ring is combined with only 17 of the spells, for the moment. As well, after surveying Black Marsh, Elsweyr, Summurset Isle, and the Imperial City, I found only 32 rings. (185 marks; 83 crystals; 57 bracers) Once a complete inventory is taken, a full and proper analysis will be able to be performed. You mentioned 'Mark of Light'. I have located 12 of them with prices that vary from 1250 [5 charges] to 1750 [15 charges].
Hopefully, behind the scenes in the data and the code, there is a means for the game to use some random number generators (RNG) to create an object at random that is found as part of loot. Otherwise, if the data that I am gathering is any indication, some objects might be unobtainable within the game.
And to answer your question, no I have not done much looting. I played Arena back when it was new in the mid 90s. I have not 'played' since. Because I wanted to know where all the ebony was located, before I set out with a new character, I made a first attempt to collect the data. It was too difficult to do in 2013, when I reinstalled the game nearly 20 years later. Eight years after that, with three screens and a much more powerful computer, the task is feasible, and it is proceeding rather quickly.
It could take months to complete a similar survey of the equipment stores, but when all the magical items are recorded, any player will be able to use the information to find a specific item that will help to boost their character.
Sat Jun 26, 2021 10:23 pm
Today, I managed to get Morrowind and Valenwood finished. I was completing each province in about 3 hours, which is a bit better than my original estimate.
I have not analysed the data, but I am approaching 1500 magical items in my Excel workbook. If I can sustain this pace, I should be able to review Hammerfell, High Rock, and Skyrim in a couple days.
It was interesting to see that some of the Mages Guilds have duplicates even within the same 'store'. I guess that they are really proficient at crafting that particular item. If anyone believes that I made a transcription error, then they can review my work at a time of their choosing.
What is slowing me down is arriving at the settlements during the evening. I need to find an inn and wait until after 6 am, so that I can find the Mages Guild. Also, the requirement to walk up to the mages inside the buildings is getting very monotonous.
I will do my best to share my results before replacing the tables. I still need to figure out if the number of charges and the cost per charge are not resulting in integer values. Based on some number crunching last night, Toxic Cloud seems to be 850 per charge. That will need to be added to the table.
Sat Jul 03, 2021 5:55 pm
I replaced all eight of the tables for magical items. It should be easier for anyone to scroll through the list using the default sorting order that I applied to the data. The sort order is Province, City, and Price. It is still possible to sort using the table's properties. Those properties were maintained.
I might tackle maps of the settlements next, but it will depend on my free time.
I hope that my recent efforts to survey all the Mages Guilds will be useful.