So, I have been buying older herbs and milling, for fun and profit. I had an instinctive feel for how much to pay for northrend herbs, but very little 'feel' for older herbs, and blackfallow inks are still expensive. So like any good min/maxer, I wrote a spreadsheet for milling. It is written as a google docs spreadsheet. If you use google docs, you can 'make a copy'. If you use Excel or OpenOffice, you can download it.
Auctioneer's milling values seem to be based on the value of pigments. Pigments are rarely traded at a reasonable value. Consider selling the odd pigment for a 'reasonalbe' value.
Enter 'your' values for herbs, pigments and inks. If the 'markeup' column is green (high profit), mill it. If it is red (loss), avoid it. If the markup is white (no profit) or yellow(small profit), consider it if you must.
This spreadsheet is still to be considered 'beta' quality. I am still finding a few mistakes in it, but as a whole it works for me.
Have fun
Posts
Thanks ^^ This seems very useful!
ReplyDeleteI'll test it soon :)
Nicely done. They way you did cost ratios and markup value is pretty sophisticated. I like how you can tweak both herb value and ink value to find a buy and or sale price.
ReplyDeleteA couple of your odds should be altered a little bit. Herbs with an ilvl ending in 7 and above drop 3 normal pigments and .5 rare pigments per mill. Some herbs are listed with low (2.5/.25) milling values (Lichbloom, Nightmare Vine, Wintersbite, Mana Thistle, some others).
Charlie, interesting point about the iLevel of herbs. I went through awhile back when I made my spreadsheet, and did my own analysis of each herb, but never mapped it to the iLevel.
ReplyDeleteMountain Silversage, which is iLevel 56, also averages 3 pigments, rather than 2.5, while Sungrass at 46, averages 2.5. So it seems iLevel x7-x0 is the range for the 3.0 average, but sometimes x6 as well.
Also, Kingsblood, at iLvl 24, averages 3.0, but Dreamfoil, at iLvl 54, average 2.5. I guess the formula isn't perfect.
ReplyDeleteThanks. Comments about things to fix are very welcome.
ReplyDeleteI have changed lichbloom, Nightmare vine, Wintersbite, Mana thistle, Mountain silversage and a 'couple others'.
I can't find Wintersbite on the AH, or in my alchemy recipee book anymore. It seems to be replaced with Dragon's teeth for the frost oil potion. Does it still exist?
You are correct. Wintersbite was renamed to Dragon's Teeth. Likewise, Plaguebloom was renamed to Sorrowmoss. I don't know why. Everything else about them remained the same, even their item number. /shrug
ReplyDeleteDear mate. I seriously love this writing and your current web site all in all! That article is very clearly created and also easily understandable. Your Blog theme is awesome as well! Would be great to learn exactly where My partner and i are able acquire it. Please continue to keep up the great job. We need more these web masters such as you online and much less spammers. Fantastic mate!
ReplyDelete