![]() |
Ironpaw Cooking Materials Shuffle |
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 |
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
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.
ReplyDeleteI'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!
DeleteI too would love to be able to import TUJ csv! Would make it a lot easier than one by one importing!
DeleteGreat post Nev :) Happy Thanksgiving to you and your family :)
ReplyDeleteThank you Xtreme - have a good holiday yourself xxx
DeleteI 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!!
ReplyDeleteKeep your eyes peeled then - got a few more coming up soon :)
DeleteThis comment has been removed by the author.
ReplyDeleteHi! Awesome! Thanks for sharing this. I'd love a version like Noah mentioned making that imports TUJ prices. :)
ReplyDeleteAlso, 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. ;)
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.
ReplyDeleteHi 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 :)
DeleteAhaa! thanks!
DeleteGood 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.
ReplyDeleteI 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).
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!
DeleteAlso, you mention in the text that "Wildfowl breast" is in row 29; but in the picture, it's in row 21.
DeleteDigesting. Learning. Loving it!
ReplyDelete