I started by measuring the 'actual' travel distances between all of the settlements in the game. The data is saved to an Excel workbook.
Having read most of the pages that relate to the gameplay, I noticed that there were tables for the enchanted items in the game. Also, the tables were incomplete. I started by writing down in an Excel workbook the names, the materials, the attributes, the spells, the weight, and the cost of every weapon and piece of armour better than leather. I was trying to fill the gaps. When I started this, I was using my Windows XP to play the game in DOS-Box, while I used my Acer laptop with Windows 7 to record the data. It was not a quick process and it was not particularly ergonomic either. I recorded information for 3-4 settlements before I put the project on hold, for one reason or another.
Recently, I noticed that I could download and install Arena for free, so I installed it onto my HP laptop with Windows 10. With three screens and better software, I should be able to accomplish more in less time. However, it was still going to take time to record everything that I wanted.
I decided to change my strategy, after I rediscovered the lists of stores for each settlement. I manually selected, copied, and pasted the lists into a new Excel workbook. I did not care where the stores were located, I just needed the names. With nearly 2900 store names, I analysed the data using a PivotTable and a PivotChart. There were certain names that stood out, because they showed up so often.
When I looked again at the sorted entries in the PivotTable, I could see a pattern in the names. The leader was different, but the same 'types' of store kept showing up. I returned to the original column that I created and I add a new column for "Collections". According to the data, there are 10 separate collections.
- Accouterments
Armaments
Equipment Store
Gear Store
Merchandise
Provisions
Sundries
Supply Store
Tool Store
Weaponry Store
Returning to my previous project of recording what each store sells, based on my discovery above, I suspect that the list of items will be the same for all the stores that belong to a collection. My current sample size is too small, but I believe that after recording the data for 10, 20, or 30 stores, in a few of the collections, that it will be possible to extrapolate a better and more complete list of items.
I remember grinding out the game nearly 30 years ago to locate or to buy all the ebony items. I think that is as far as I got with it at the time because the old 486/66 DX2 just did not have the hardware necessary to play it well, or I switched to a different game.
So, if I decide to actually play the game now, I would like to have a roadmap to find everything that I want in order to equip my character.
And, that is why I am questioning the accuracy of the lists of stores in settlements in Arena. If they are complete, then I have reduced my work effort immensely. Also, if my hypothesis is correct, it might be possible to locate items in more stores then the respective tables indicate.
Anyway, if someone happens to know the answer to my question about the lists of stores, I would appreciate it before I get too far along.
Thank you.

