Monday 19 November 2012

Ironpaw Tokens & Cooking Materials Shuffle - Revisited

Ironpaw Cooking Materials Shuffle
After some comments, email feedback & a conversation with a fellow gold blogger, I've added some more stuff to the Ironpaw Tokens spreadsheet I uploaded a few days ago. It seems that as long as it took me to get my head around what I was trying to do, I still didn't quite manage to communicate it very well in my Ironpaw Tokens & Cooking Materials Shuffling post!

So version 2 has a whole bunch of extra columns which should show you at a glance which cooking material will make you some profit if you convert it to another via the Ironpaw Tokens trade-in. I've uploaded this as a second file called Ironpaw Conversion and Profits which you can download & edit freely. Please though - make sure you download before you edit - it just makes it easier for others if the original file is left untouched.

Ironpaw Token Profit Shuffle Spreadsheet
I took the original spreadsheet and extended the columns - one for each cooking material. Now all you have to do is type in the prices (in the yellow boxes) for your Auction House & it should calculate where any profitable conversions are. To use it, just choose the cooking material you have from column A & read across that row to find which other cooking material to convert it into for profit (or savings if you're leveling your cooking of course).

You don't need to worry whether you are converting vegetables to meat/fish or vice versa - I have adjusted the profit calculations accordingly within the sheet.

Also, you may want to sort each section (vegetable rows, fish rows, meat rows etc) by Column B once you've entered your AH prices - make sure you sort the whole section though otherwise the formulas will mess up big time! lol Sorting is optional but it does make it easier to read if your cheapest price is at the top of each section.

So an example might help I guess. If I have plenty of Wildfowl Breast & want to use those to convert to vegetables - I can see by reading along row 29 (wildfowl breast, column A) that converting to Juicycrunch Carrots, Green Cabbages or White Turnips will give me a loss, converting to Witchberries will give me profit of 1g63s per item but converting to Jade squash will give me a very nice profit of 6g 67s per item!

Please remember though - cooking materials are very volatile right now & prices are likely to vary widely over a few days - don't sink loads of gold in today then find out your 'profitable' material from the list above is the cheapest on the Auction House tomorrow. Spread your risk too - don't invest loads in just one cooking material - if you are going to convert a lot, convert to a range of different profitable items so that you are covered as prices change.

So there you go! Thank you to all the commenters, emailers & others who gave suggestions on the earlier version. I hope this one is closer to what you were hoping for from the earlier version.

Good luck & have fun


****************

Check out some of my Squidoo lenses! Gift Guide - Horde Edition | Gift Guide - Alliance Edition



Image © AW Sheffield under Creative Commons licence


16 comments:

  1. I edited and added a vlookup (to gather prices from TUJ .csv for my realm on sheet2) let me know if anyone wants this version.

    ReplyDelete
    Replies
    1. I'd love to see your vlookup sheet Noah - that's what I was trying to remember how to do but had forgotten the damned name of it! lol Been about 3 yrs since I did any extensive excel work!

      Delete
    2. I too would love to be able to import TUJ csv! Would make it a lot easier than one by one importing!

      Delete
  2. Great post Nev :) Happy Thanksgiving to you and your family :)

    ReplyDelete
    Replies
    1. Thank you Xtreme - have a good holiday yourself xxx

      Delete
  3. I love the short micro spread sheets, i make them for stuff like Living steel transmute to make sure i am using the least and making the most out of them. I will be adding this one to my collection. Great job Nev!!

    ReplyDelete
    Replies
    1. Keep your eyes peeled then - got a few more coming up soon :)

      Delete
  4. This comment has been removed by the author.

    ReplyDelete
  5. Hi! Awesome! Thanks for sharing this. I'd love a version like Noah mentioned making that imports TUJ prices. :)

    Also, on my copy I made some small formatting changes that make it easier for me personally to read, but just one I thought I'd share.

    To quickly see which things in col A might be worth trading, I added a conditional formatting to each row to fill it green if any column in that row is NOT a loss. So, for Pink Turnip, it would be matching this formula:
    =COUNTIF($F7:$AD7,"<>loss")

    I don't know how to do it more generally (like, do it once such that for each row in col A, check all profit columns in that row), so I just did it manually on each row: select the item > conditional formatting > new rule > Use a formula to determine which cells to format > paste formula and change row numbers > click format > fill > green. kind of annoying but it seems to work. ;)

    ReplyDelete
  6. I'm sorry if I missed something, but I import my Realm's data .csv as the second sheet- however the values do not readjust accordingly. Rather new to excel, but thought this would be a neat way to start getting familiar with it.

    ReplyDelete
    Replies
    1. Hi Ian, no you didn't miss anything - this file doesn't have the Vlookup formula in the main sheet so it won't pull through automatically. If you want to try for yourself, have a look at yesterday's post http://ahaddict.blogspot.co.uk/2012/12/Leather-converting-spreadsheet.html which has Vlookup instructions or you can comment/email/tweet me & I can add those quickly for you :)

      Delete
  7. Good sheet. It not too easy to use to find the best ROI when doing the shuffle. I am working on my own sheet I might share when I have finalized it.

    I don't know if it's a bug or not but is seems the profit/loss calculation for columns M to O (vegs) are using meat/fish token values (column D) instead of veg token values (column E).

    ReplyDelete
    Replies
    1. Oops! thank you for that - I had to re-do a lot of the calcs as someone edited the sheet before downloading it. I guess I missed a few or messed up the re-do!

      Delete
    2. Also, you mention in the text that "Wildfowl breast" is in row 29; but in the picture, it's in row 21.

      Delete
  8. Digesting. Learning. Loving it!

    ReplyDelete

Your comment is awaiting moderation - I hate to do this but so many spammers around these days :(