Major system: for memorizing numbers

I suggest you look up the major system on the internet, because there are many good sources about it. I will just briefly present the gist of it. With the major system, we can convert numbers into words, which we can then place as pictures in a palace, so we can memorize them easily. In the major system, consonants are replaced by numbers, while vowels do not encode numbers. The letters q, w, h, y, x do not encode numbers either. Let's take an example: The word nail = 25, because n=2, l=5. Double consonants encode only one number, not two. For example, paddle = 915, and not 9115 (p=9 d=1 l=5). If you search for “major system generator” on the internet, the search engine will return several such generators, where if you enter a number, it will give you the words that encode this number. However, they do not only provide visualizeable words, but also everything else, and often they do not have a large enough word database to start from. The major system generator I created, however, only contains visualizeable words, so it is easy to use with a memory palace. I consider the memoria sillabarum more important than the major system because as a student I had to memorize many more concepts than numbers, but the major system is still very useful. Anyone can translate the list into their own language from the word lists I provided, and then anyone can create their own major system within an hour. It can be created in Microsoft Excel. In Excel, we remove the repeating values from the translated word list. Then the word list must be sorted in ascending order in Excel according to ABC, and then saved. Then we must make a copy of it, so we get 2 identical, sorted documents, which contain the same words in ABC order. In one of the documents, we need to replace consonants with numbers using the search-replace function according to the appropriate rules, which are described in the next paragraph. In the Excel file, we change the format from number format to text format, otherwise it tends to display numbers in exponential form, which is not good for us. First, we need to replace double consonants with numbers. So, we replace dd-double consonants with 1, tt-double consonants with 1, nn-double consonants with 2, and so on. So, for example, nn will be 2 in the list, not 22. After that we need to replace all consonants with the appropriate number. We replace d-letters with 1, t letters with 1, n-letters with 2, and so on. Only then can the vowels be replaced, the vowels must be replaced with nothing, so they disappear. The letters q, w, h, y, x are also replaced with nothing. Then we get a list of numbers instead of words. The sorted word list must be inserted after the list of numbers. For example, if the list of numbers is in column A, then the word list must be inserted in column B. Then the numbers must be selected together with the words, and then both columns must be sorted in ascending order. Thus, we get the list in ascending order from the number 1 upwards. Then I put a dot before and after the words, and an x before and after the numbers, so that the document can be easily searched with ctrl+f. I solved this in a separate Excel file, for example, I pasted the list of numbers into column B, and I copied X-s down into columns A and C. In cell D1, I entered =A1&B1&C1, and I copied this instruction all the way down to the bottom. This way, the x-s were placed before and after the numbers, so for example x1x x2x x19x etc. I did the same with the word list. In Excel, I copied dots all the way down into columns A and C. I pasted the word list into column B. In cell D1, I entered =A1&B1&C1, and copied this instruction all the way down to the bottom. 1-1 dots were placed before and after the words. Then, in a new Excel file, paste the resulting list of numbers into column A, and the resulting list of words into column B. You always have to paste it as a value, otherwise it won't work. In cell C1, type =A1&B1, and copy this command down to the bottom. Then copy column C and paste it into Microsoft Word. In Microsoft Word, replace the paragraph marks with spaces, and you're good to go. With that, the work is done. If I search for e.g. x2x in Microsoft Word, it will output the corresponding visualizable words that encode the number 2, e.g. x2x .Anna. x2x .honey. x2x .sun. etc.