I’m back from vacation with a bang. I have now brought my spreadsheet up to date with all the new 7.3 recipes and I finished a sheet for Engineering. Due to the large number of changes the google sheets link has been changes as I re-imported my spreadsheet completely. You can find the new link below and on my spreadsheet page:
I added all the engineering crafts that you can sell on the auction house. I also added obliterum calculations for the Skullblasters which I have used to great effect in my Zero to One Million Gold series.
I have it on good authority that a number of the recipes can be profitable, but you will have to experiment yourself to figure out how well they are doing on your realm.
Patch 7.3 added a lot of recipes to the game. It also added new materials and the new primal Obliterum. Most of the new materials can be traded and we can just use the Auction house price as their cost. The new Primal Sargerite is bind on pickup however. To find the value of one Primal Sargerite I took the price of one Primal Obliterum less the price of one Obliterum. This is used in all the crafting cost formulas and you can find the Primal Sargerite value in the renamed BoS and Primal Sarg sheet.
To get the correct rates for empyrium prospecting I went through all the data I could find on woweconomy. By adding up all the data from the following threads I could find the rates quite easily:
The results are summarised in the table below. I rounded down the rates to 3% and 1.5% per prospect respectively. 3% seems like the closest round number and I assume the same ratio of red/green gems as in Felslate and Leystone. I’d rather be slightly too conservative than too aggressive with the pricing assumptions.
To find the best method value of the new gems from empyrium prospecting i needed to find some way to value the gems when used in the new Empyrial crowns. To find the gem value I took the expected profit from the crown, divided by 8 to get the profit per gem. For each gem the best method value then equals the AH price of the gems plus the expected profit from the Empyrial crowns. From what I saw when checking this is truly where the empyrium value lies.
Google Sheets Update
I also added a new update button and a script to the google sheets version. It should now function like the excel sheet and not keep updating in the background. Shoutout to Solaris on my Discord server who wrote the script and has been sharing it with people there.