When filtering by rarity or source, column heading "INGREDIENT'S NAME" disappeared in Sheet1, line 22 (version 2.1) or 23 (versions 3 and 3.1), column 1.
You may have experienced an error message when searching for Restore Health as first effect. This is because there are 12 ingredients who also share Restore Stamina, and the ColorIndex list in Sheet5 (line 116 and following) wasn't long enough. Download new version or simply add some color indexes in the list, and press "Update Message" button. Same problem with "Restore Stamina" as first effect (13 Fortify Stamina", 12 "Restore Health" and 12 "Slow" ).
FIXED
This happened because of the addition of a great number of new ingredients and a programmer who was in the moon...
Thank you. I'm working (but I'm very lazy) to a Word file descripting more fully what the program does (the more you understand it, the better you'll use it) but translating everything in english gives me headaches...
Pour les utilisateurs fançais, avez-vous remarqué "Effet choisi 4" en mauve en cellule (12,16) -- en mode L1C1, il faut entrer d'abord le nméro de ligne, ensuite celui de colonne, comme pour les matrices -- de la troisième image ? Cette cellule devrait contenir "Effet choisi 3"...
Pour y remédier : 1. Ouvrez le fichier et allez en page 5 "Traduction (messages)" ; 2. Changez la valeur de la cellule (58,2) en "Effet choisi 3" ; 3. Appuyez sur le bouton "Mise à jour des messages".
Et voilà ; vous venez de modifier l'un des messages du programme.
Thank you for making this super spreadsheet in English. It is very helpful that it can look at 2 effect combinations! Maybe you should also list this wonderful utility with an English title so people who do not speak French realise they can use it too.
9 comments
ERROR LOG 2 :
When filtering by rarity or source, column heading "INGREDIENT'S NAME" disappeared in Sheet1, line 22 (version 2.1) or 23 (versions 3 and 3.1), column 1.
This had no incidence on the lists themselves.
FIXED.
ERROR LOG 1 : For v3 and v3.1 users
You may have experienced an error message when searching for Restore Health as first effect. This is because there are 12 ingredients who also share Restore Stamina, and the ColorIndex list in Sheet5 (line 116 and following) wasn't long enough.
Download new version or simply add some color indexes in the list, and press "Update Message" button.
Same problem with "Restore Stamina" as first effect (13 Fortify Stamina", 12 "Restore Health" and 12 "Slow" ).
FIXED
This happened because of the addition of a great number of new ingredients and a programmer who was in the moon...
Sorry for the inconvenience.
Thank you. I'm working (but I'm very lazy) to a Word file descripting more fully what the program does (the more you understand it, the better you'll use it) but translating everything in english gives me headaches...
Edit : done.
Pour les utilisateurs fançais, avez-vous remarqué "Effet choisi 4" en mauve en cellule (12,16) -- en mode L1C1, il faut entrer d'abord le nméro de ligne, ensuite celui de colonne, comme pour les matrices -- de la troisième image ? Cette cellule devrait contenir "Effet choisi 3"...
Pour y remédier :
1. Ouvrez le fichier et allez en page 5 "Traduction (messages)" ;
2. Changez la valeur de la cellule (58,2) en "Effet choisi 3" ;
3. Appuyez sur le bouton "Mise à jour des messages".
Et voilà ; vous venez de modifier l'un des messages du programme.
I thought it was explicit with the title "Composants alchimiques - Alchemy ingredients", but perhaps you are right.
I'll try it the other way...