Release 2.0 Settings file is compatible with the new version. New features: The last selected character is now saved and re-loaded the next time you launch the parser. Added HTML to the options for save file format. HTML files do not need to be closed during regeneration, just refresh the page once the parser is done. HTML will also display the number of learned recipes vs total recipes and number needed to max 350. Added a selection to generate EQ Traders or ZAM links to the recipes, last selected option will be saved and re-loaded the next time you launch the parser. I did a rough shot matching ZAM recipes so if you see any links that do not seem to match up please notify me though PM or email. As always, please consider donating to EQTC if you utilize the recipes from them. Please do not rehost, redistribute, relink, modify and only for personal usage. Script, materials, inputs, or generated files may not be used in any method soliciting or generating any compensation. What does my script do? Reads output file name and contents (no different than popular tools that read log files) Matches learned recipes versus a master list of known recipes that count for 300+ Master list accounts for recipes that share a common name, and identify the unique material for each of those combines Saves an Excel, CSV, or HTML file for each output file found with URLs to EQTC or ZAM recipes Excel file will list all recipes with clickable hyperlinks for the URLs, but will filter on what you have not learned CSV file will only list what you have not learned with non-clickable URLs, and will not save formatting (If you have an Office alternative, use Save As to a native workbook format to preserve formatting) HTML file will only list what you have not learned with clickable hyperlinks for the URLs, along with displaying the number of learned recipes vs total recipes and number needed to max 350. Saves a text file with recipes I do not have accounted for yet for easy submission to add to my master lists in future updates (please email file to SoulbansheeEQ@gmail.com or PM contents) Easy automation alleviates mistypes, accidentally skipping learned recipes, and forgetting to mark off recipes What doesn't my script do? Does not access EverQuest account or character information Does not access anything in memory Does not send anything to an outside source or access anything from an outside source Does not retain anything about your system other than saving the selected directory paths in the settings file that allow the script to run without prompting each time Requires PowerShell v5, Windows 7/8/8.1 will need to install an update. https://www.microsoft.com/en-us/download/details.aspx?id=50395 Note: It was pointed out to me that default settings is to not allow unsigned scripts to run. In order for my script to work, either system execution policy must be changed or the RUNME file included will bypass the restrictions. Download and extract this zip file into a directory on your computer, overwriting existing files: https://drive.google.com/open?id=12VbKr6AVkJY74ObIjbDpNroAh0680qDo In EverQuest, type /outputfile recipes <tradeskillname> for each TS and character you want to parse. You will have to do this command each time you learn new recipes if you want to update the spreadsheets with the parser. Either leave the output in your EverQuest directory or move them to a new location if you would prefer. The files are named <Character>-<Tradeskill>-Recipes.txt and are located in the base EverQuest installation directory. Double-click to execute the RUNME.cmd file. This will start PowerShell in a mode that will allow the script to run because it is not signed. (If your system is set unrestricted, you can right-click and select "Run with PowerShell" instead. Do not close the Windows PowerShell window in the background, it will exit within 2 seconds after you close the parse tool.) If you already set up the configuration, a directory will be displayed next to the "Load output files" button. If it is correct, skip the next step. Click the "Load output files" button, Browse for Folder will pop up, choose where the output files are located, so either the EQ directory or where you moved them. Any output files found will populate the character name in the first drop down. If there are no characters listed, then no files were found named <Character>-<Tradeskill>-Recipes.txt Select "All" to parse all character outputs found, else select a single character. Under "Tradeskills", check "Select All" or the combination of tradeskills you want to parse for the character(s) selected previously. If there are none or missing tradeskill check boxes, then the base files are missing. Select the save file format if necessary, else continue to the next step. CSV and HTML will be the only options if Excel 2010 or later is not installed. If you already set up the configuration, a directory will be displayed next to the "Select save file location" button. If it is correct, skip the next step. Click the "Select save file location" button, Browse for Folder will pop up, choose where you want the spreadsheets saved to. Select the source you want to generate the recipe links for if necessary, else continue to the next step. Check or uncheck "Overwrite files". Checked will overwrite files with the same name losing any manual changes. Unchecked will first move existing files to a "Backup" folder. Your selections for output file directory, character, save format, save file directory, recipe source, and overwrite will be saved to a settings.ini file and remembered when you run the script again. Click the "Generate files" button. The parser will run for a few minutes while the interface is greyed out. Everything will re-enable once complete. <Character>-<Tradeskill> files of the selected format will be created in the save file location. If you have any learned recipes that are not in my tradeskill files, a RecipeSubmit.txt file will be created also. Please email the whole file as an attachment to me at SoulbansheeEQ@gmail.com so that I may include it in a future update. Steps can be repeated without having to close or launch the parser again. Use "Load output files" to load new characters if necessary. Skip step 3 if the parser is already running. Click the "Close Parser" button to close the parser when finished. Notes: For Excel files, "Needs Verification" under learned means the recipe either needs to be confirmed as invalid, or I do not as of yet have the EverQuest Recipe ID. You should manually search for the recipe in the container for now to make sure you know it or not. The base files will get updated as I get more information. For Excel files, learned recipes are filtered out by default, you can use the filtering at the top to add them back in if you wish. Suggestions and feedback are welcome. FAQ Q. Nothing ran, no PowerShell window popped up. A. You need to have PowerShell v5 (see top link) and use the RUNME file to run the parser. Q. No Excel files were created after clicking "Generate files". A. The script will exit if there was an issue creating Excel workbooks. Also verify you are looking in the correct save file location.