Hey guys, this is posted at the request of @Kruhlest . It's not overly complicated, and may still have some bugs. . . I just threw it together pretty quickly. If people find it useful and find some major bugs or errors, just let me know and I'll patch it up real fast. Anyway, to get it to work, just download your XML data from TUJ for your realm. Then, on the spreadsheet, go to the XML tab located at the bottom left, and select the box that selects the entire spreadsheet (located above row 1, left of column A). Once selected, press the delete key to clear my XML data (only there for example purposes), and select cell A1. Then paste your data, and you should be good to go. Now, you can review the numbers for yourself if you want. However, the spreadsheet is designed to already tell you what you should do. Just follow the recommendations along the right side. However, until it is cleared up of any bugs (I'll edit this post with a note in red saying the bugs were cleared once it happens), I suggest you read over the data yourself. Here's a sample with my realms data. Have fun.
To explain the picture a little bit, this is how it will work. The first column are the base items. This means the items you would have in your inventory to start your conversions. Next you'll see how much that item is worth on your realm, then how many you need to create the Target Item (Column E). Column D is how much it would cost to make the Target Item converting the Base Items, and Column F is how much the Target Item costs from buying off the AH. The last Column, outside of the colored area, is what the final goal should be. It will select and show the recommended course of action. For example, when crafting Trillium Bars, depending on the price, it will tell you to do one of three things:
Buy your trill bars from AH.
Buy Ghost Iron Ore and smelt it into bars, then craft into Trillium Bars.
Buy Ghost Iron Bars and craft into Trillium Bars.
It does recommended actions for all the items, but it is still a rough sketch. Let me know if there's anything else you guys want added, or if you find any bugs/errors. Use with caution for the time being, but it doesn't account for transmute master bonuses yet. I'll add that in later. Let me know what you guys think.