nfct
03-21-2020, 07:01 PM
Hello Everyone,
I just wanted to stop by and give everyone the new toy I just created. It takes a little work on your part, but it will make your life a whole lot easier. This tool is meant to tell you exactly what you can and cannot research using words in your inventory and bank. It will also allow you to know what you need to get in order to research spells that you are looking for. Follow the instructions below to get it working:
1) Use the command "/outputfile inventory" within the game. This will spit out a text file in your base EQ directory called "character name - inventory.txt"
ex. https://i.imgur.com/fTktNCn.png
The easiest way to find this image would be to search for you character name in the base folder.
2) Open the text file, hit "CTRL-A" and then copy the entire document.
3) Open the Research Cheat Sheet (https://drive.google.com/open?id=1RerxVVLfm3KCV9OQqXXKwgvNdShJnV-M) (I suggest that you make a copy of this file to your own computer. This will make it so you can update it as needed.)
4) Go to the first worksheet in the file (It will be named "Inventory Dump")
5) Paste the raw data from the text file we created earlier. This will create 5 separate columns with data in all of them.
6) Move over to the second tab on the file, "Pivot".
https://i.imgur.com/Zg8qmNV.png
7) Right click on the actual table shown, and click "Refresh".
https://i.imgur.com/XTElZ8z.png
8) Profit!!!!
If you go to the "Necromancer" sheet, it will show you all of the re-searchable spells for Necros, as well as the reagents, how many of each you have, and if you have enough to do an attempt at the combine, as well as how many combines you can make.
EX.
https://i.imgur.com/VaNT46S.png
I plan on adding the other caster classes ASAP.
If anyone has any questions or concerns, feel free to message me here on the forums, reply to this post, or hit me up on discord at "eneffseetee#6712".
Have a great time killing all those halflings out there you necro heathens!
As a note: It seems as though it will not work properly if you are attempting to load the file with Google Sheets, as it is not able to properly refresh or update any pivot table information. For now stick to using excel or other similar stand alone software. Please let me know if you run into any bugs.
I just wanted to stop by and give everyone the new toy I just created. It takes a little work on your part, but it will make your life a whole lot easier. This tool is meant to tell you exactly what you can and cannot research using words in your inventory and bank. It will also allow you to know what you need to get in order to research spells that you are looking for. Follow the instructions below to get it working:
1) Use the command "/outputfile inventory" within the game. This will spit out a text file in your base EQ directory called "character name - inventory.txt"
ex. https://i.imgur.com/fTktNCn.png
The easiest way to find this image would be to search for you character name in the base folder.
2) Open the text file, hit "CTRL-A" and then copy the entire document.
3) Open the Research Cheat Sheet (https://drive.google.com/open?id=1RerxVVLfm3KCV9OQqXXKwgvNdShJnV-M) (I suggest that you make a copy of this file to your own computer. This will make it so you can update it as needed.)
4) Go to the first worksheet in the file (It will be named "Inventory Dump")
5) Paste the raw data from the text file we created earlier. This will create 5 separate columns with data in all of them.
6) Move over to the second tab on the file, "Pivot".
https://i.imgur.com/Zg8qmNV.png
7) Right click on the actual table shown, and click "Refresh".
https://i.imgur.com/XTElZ8z.png
8) Profit!!!!
If you go to the "Necromancer" sheet, it will show you all of the re-searchable spells for Necros, as well as the reagents, how many of each you have, and if you have enough to do an attempt at the combine, as well as how many combines you can make.
EX.
https://i.imgur.com/VaNT46S.png
I plan on adding the other caster classes ASAP.
If anyone has any questions or concerns, feel free to message me here on the forums, reply to this post, or hit me up on discord at "eneffseetee#6712".
Have a great time killing all those halflings out there you necro heathens!
As a note: It seems as though it will not work properly if you are attempting to load the file with Google Sheets, as it is not able to properly refresh or update any pivot table information. For now stick to using excel or other similar stand alone software. Please let me know if you run into any bugs.