I have created a Spreadsheet that automatically calculates profits for the major crafts available in Legion professions.
You can download the Microsoft Excel version of the spreadsheet here via box.com: Lazy-Goldmakers-Legion-Spreads
. This version sadly only works on Windows-based systems.
The Google Sheets version of the spreadsheet can be found here: Lazy Goldmakers Spreadsheet Google Sheets Version
The Google Sheets version works on all systems and is available anywhere as it can be stored in the cloud. Make sure you make a personal copy by clicking File and then Make a Copy as the original is set to view only so it does not get changed.
The spreadsheet uses the TradeSkillMaster.com API to download pricing data. The documentation for the function used can be found here
if you are interested.
To download the data into the spreadsheet I have written a VBA macro that takes your API key and a region and server name and downloads the data automatically. A separate macro refreshes the data, but keep in mind that you can only query the TSM API 25 times per day for this data. If you try refreshing more than that it will fail, but updates approximately once per hour should be more than adequate.