|Ironpaw Token Shuffle - Veggies, Meat & Fish|
I went back to The Undermine Journal, to the Cooking section under the Gathered category & just stared at it a while. I realised that for me, at least, it didn't go far enough so I built another little spreadsheet for that extra step. This screenshot (from The Undermine Journal) shows how much it would cost to make a container of meats/fish or vegetables from each material available on the Auction House. In effect, it's the cost of an Ironpaw Token, dependant on which raw material you use. I've included the 100 Year Soy Sauce & Black pepper section because those are still selling well on my server & from this screenshot, you can easily see that there is profit to be made just by converting the cheapest raw materials to Ironpaw Tokens.
|The Undermine Journal, Cooking page, Ironpaw Token Calcs|
|Calculate Ironpaw Token Shuffle Costs|
It's going to be fairly rare for 100 vegetables of any sort to be a cost effective way of buying just 5 meat or fish - Giant Mantis Shrimp are just exceptionally expensive on my server today but using a single 20 stack of meat or fish can easily be cost effective to buy either 5 meat/fish bundle or a 25 vegetable bundle.
You can see that the Raw Turtle Meat & the Reef Octopus (red dots) are both really cheap today & in column F, it shows them at a converted price of 1g66s & 1g59s respectively - that means using either of these to buy a vegetable bundle (25's) will be the cheapest way to buy any of the vegetables except Pink Turnips & Mogu Pumpkins. The Reef Octopus is so cheap today that it's also the cheapest way to buy Wildfowl Breast, Raw Crocolisk Meat & Raw Crab Meat as well as all the fish below Jewel Danio in the fish section!
I've added this spreadsheet onto Google Docs & fingers crossed, in an editable, downloadable form. Just click Ironpaw Token Conversion spreadsheet and you should go straight to it. Feel free to edit it to suit yourself but please, only edit a downloaded copy. I tried to put a macro in for easy sorting but it didn't work (or I couldn't make it work!) so don't worry if you get a 'contains a macro' warning - I couldn't find it to get rid of it!
I hope this helps make the Ironpaw Token Shuffle a little easier & quicker for you. If you have any problems downloading or editing it, let me know either in comments, by email (top right under profile) or on Twitter @NevAHAddict & I'll do my best to help.
Edited: I had to change to Google Docs link above to return the file to it's original format. Please, please, download a copy before you edit anything. Thank you :)
Edited yet again! Following some feedback, I've extended this spreadsheet & uploaded a version 2 to google docs - I've also added some more analysis in a second post Ironpaw Tokens & Cooking Materials Shuffling - Revisited so to make sure you've got the most up to date version, pop over to the Revisited post & click the google docs link there :)
Image © USDAGov under Creative Commons licence