I just finished porting my spreadsheet into Google sheets. It retains full functionality with automatic price data. I have also updated the Jewelcrafting part of both versions of my spreadsheet. It now includes direct profit calculations of all the major crafts: Rare gem cuts, rings and epic gems. The newest version of my Excel sheet is always available at through my spreadsheet page.
The spreadsheet should be fairly self-explanatory in terms of the information that is shown for each profession. It currently contains Enchanting, Jewelcrafting and Leatherworking. My end goal is to have it include all professions, but it is quite a bit of work to add recipes so it will be a long term project.
How do you use it?
The spreadsheet contains one worksheet for each profession, one sheet for Blood of Sargeras and one sheet where the data is downloaded. The worksheets will show you the profits from all recipes and profit from disenchanting or obliterating where appropriate.
The spreadsheet will help you easily figure out which crafts from the professions are worthwhile. For Jewelcrafting it also calculates the expected value from prospecting both Leystone and Felslate, as well as the best possible use of your gems.
Before filling it out you need to make your own copy in your Google Drive. To do this just click File and then “Make a copy”. It should add a version to your Google drive instantly.
To set it up you need you TSM API key. You find it at www.tradeskillmaster.com/user If you are not a registered TSM user you will have to register to get access to the API. The API key should be pasted into cell marked in blue.
You then need to enter your Region (US or EU) in the top cell marked in green. Your realm name should be added to the bottom cell marked in green. Be aware that it should be all lower-case letters and no special characters. Spaces should be replaced with dashes. Examples: Vek’nilash = veknilash Grim Batol = grim-batol
To update the data just change the value in the red cell to anything new. IT updates the data every time the value in this cell is changed, so use it accordingly. Keep in mind that you are capped at 10 requests per day to the TSM API so don’t do it to much or you will run out of updates.
In addition to porting the spreadsheet to Google Sheets I added some functionality to the Jewelcrafting sheet. It now includes profit calculations for all the crafts that are included. I also fixed some smaller mistakes on the back end of the crafting calculations to more accurately reflect the value of Blood of Sargeras from disenchanting. These fixes have been added to both versions of the spreadsheet so play around with them as you want.
I hope you enjoy the new version, I’m really happy that the TSM API was updated so that I can much more easily implement it into google spreadsheets. If you have any requests for what to add next to my spreadsheet please tell me, I aim to help you guys the best way I can!