tag:blogger.com,1999:blog-6690056124011845308.post4069933656882533689..comments2023-11-03T08:44:13.780+00:00Comments on Auction House Addict: Ironpaw Tokens & Cooking Materials Shuffle - RevisitedNevhttp://www.blogger.com/profile/10570175016961442358noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-6690056124011845308.post-37881276787781389192013-04-21T16:21:04.739+01:002013-04-21T16:21:04.739+01:00Digesting. Learning. Loving it!Digesting. Learning. Loving it!GrayzBDFhttps://www.blogger.com/profile/15791503783873797617noreply@blogger.comtag:blogger.com,1999:blog-6690056124011845308.post-88160570278300663282013-04-02T10:38:04.936+01:002013-04-02T10:38:04.936+01:00Also, you mention in the text that "Wildfowl ...Also, you mention in the text that "Wildfowl breast" is in row 29; but in the picture, it's in row 21.Dàchénghttps://www.blogger.com/profile/02994982502333811797noreply@blogger.comtag:blogger.com,1999:blog-6690056124011845308.post-21351649170941522222013-03-18T19:14:13.587+00:002013-03-18T19:14:13.587+00:00Oops! thank you for that - I had to re-do a lot of...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!Nevhttps://www.blogger.com/profile/10570175016961442358noreply@blogger.comtag:blogger.com,1999:blog-6690056124011845308.post-57901476741019528692013-03-18T13:45:26.461+00:002013-03-18T13:45:26.461+00:00Good sheet. It not too easy to use to find the bes...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.<br /><br />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).Unknownhttps://www.blogger.com/profile/07645874241751272824noreply@blogger.comtag:blogger.com,1999:blog-6690056124011845308.post-39675154378406875182012-12-05T15:39:24.770+00:002012-12-05T15:39:24.770+00:00Ahaa! thanks!Ahaa! thanks!Anonymoushttps://www.blogger.com/profile/04591899138106984869noreply@blogger.comtag:blogger.com,1999:blog-6690056124011845308.post-23762041837755840562012-12-05T15:32:37.480+00:002012-12-05T15:32:37.480+00:00Hi Ian, no you didn't miss anything - this fil...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 :)Nevhttps://www.blogger.com/profile/10570175016961442358noreply@blogger.comtag:blogger.com,1999:blog-6690056124011845308.post-88149600024327880172012-12-05T14:33:26.648+00:002012-12-05T14:33:26.648+00:00I'm sorry if I missed something, but I import ...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.Anonymoushttps://www.blogger.com/profile/04591899138106984869noreply@blogger.comtag:blogger.com,1999:blog-6690056124011845308.post-73658051777859848272012-11-24T20:25:01.354+00:002012-11-24T20:25:01.354+00:00I too would love to be able to import TUJ csv! Wou...I too would love to be able to import TUJ csv! Would make it a lot easier than one by one importing!Topher O'Neilhttps://www.blogger.com/profile/09753656931112102810noreply@blogger.comtag:blogger.com,1999:blog-6690056124011845308.post-76691945425375283772012-11-23T17:57:48.183+00:002012-11-23T17:57:48.183+00:00Hi! Awesome! Thanks for sharing this. I'd love...Hi! Awesome! Thanks for sharing this. I'd love a version like Noah mentioned making that imports TUJ prices. :)<br /><br />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.<br /><br />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:<br /> =COUNTIF($F7:$AD7,"<>loss")<br /><br />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. ;)mgpbhttps://www.blogger.com/profile/08223292240330475394noreply@blogger.comtag:blogger.com,1999:blog-6690056124011845308.post-61827415339501573522012-11-21T01:56:20.297+00:002012-11-21T01:56:20.297+00:00This comment has been removed by the author.Tungstenhttps://www.blogger.com/profile/02146733392521748372noreply@blogger.comtag:blogger.com,1999:blog-6690056124011845308.post-90877157639738659582012-11-20T14:00:15.884+00:002012-11-20T14:00:15.884+00:00Keep your eyes peeled then - got a few more coming...Keep your eyes peeled then - got a few more coming up soon :)Nevhttps://www.blogger.com/profile/10570175016961442358noreply@blogger.comtag:blogger.com,1999:blog-6690056124011845308.post-88741651579576301282012-11-20T13:59:48.772+00:002012-11-20T13:59:48.772+00:00Thank you Xtreme - have a good holiday yourself xx...Thank you Xtreme - have a good holiday yourself xxx<br />Nevhttps://www.blogger.com/profile/10570175016961442358noreply@blogger.comtag:blogger.com,1999:blog-6690056124011845308.post-80267396936323248592012-11-20T12:56:37.785+00:002012-11-20T12:56:37.785+00:00I love the short micro spread sheets, i make them ...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!!r9sid9nt9vilhttps://www.blogger.com/profile/17708167892196603186noreply@blogger.comtag:blogger.com,1999:blog-6690056124011845308.post-46243867644685836972012-11-20T03:25:48.765+00:002012-11-20T03:25:48.765+00:00Great post Nev :) Happy Thanksgiving to you and yo...Great post Nev :) Happy Thanksgiving to you and your family :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6690056124011845308.post-26409537767573301312012-11-19T20:00:18.964+00:002012-11-19T20:00:18.964+00:00I'd love to see your vlookup sheet Noah - that...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!Nevhttps://www.blogger.com/profile/10570175016961442358noreply@blogger.comtag:blogger.com,1999:blog-6690056124011845308.post-30781948204162969432012-11-19T17:16:17.317+00:002012-11-19T17:16:17.317+00:00I edited and added a vlookup (to gather prices fro...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.Noahhttps://www.blogger.com/profile/08562374002291349448noreply@blogger.com