For a "live" estimate of potential profit for milling stacks of herbs, see the following: [HR][/HR] X = Amount of Stacks of Herbs -30 = AH Price of a Stack of Herbs 6 = AH Price of an [Ink of Dreams] 40 = AH Price of a [Starlight Ink] =SUM(C1:C3) is the estimated PROFIT from selling inks from milling X stacks of herbs. =SUM(A6:B6) is the estimated PROFIT from vendoring shoulder enchants from milling X stacks of herbs. Copy and paste the following into a blank workbook in Excel, then modify the RED values based on your realm's auction house prices. [HR][/HR][table] [tr] [td]X[/td] [td]-30[/td] [td]=SUM(A1*B1)[/td] [/tr] [tr] [td]=SUM(A1*4.5)[/td] [td]6[/td] [td]=SUM(A2*B2)[/td] [/tr] [tr] [td]=SUM(A1*1.5)[/td] [td]40[/td] [td]=SUM(A3*B3)[/td] [/tr] [tr] [td]EMPTY[/td] [td]EMPTY[/td] [td]=SUM(C1:C3)[/td] [/tr] [tr] [td]EMPTY[/td] [td]EMPTY[/td] [td]EMPTY[/td] [/tr] [tr] [td]=SUM(A2/3)[/td] [td]=SUM(18.75-B2*(3))[/td] [td]=SUM(A6*B6)[/td] [/tr] [/table] [HR][/HR]NOTE: The estimated profit is based off of an estimated [Ink of Dreams]x4.5 and [Starlight Ink]x1.5 from each stack of herbs. [HR][/HR][table] [tr] [td]ROW 1: GOLD INVESTED IN STACKS OF HERBS[/td] [/tr] [tr] [td]ROW 2: VALUE OF [INK OF DREAMS] FROM X STACKS[/td] [/tr] [tr] [td]ROW 3: VALUE OF [STARLIGHT INK] FROM X STACKS[/td] [/tr] [tr] [td]ROW 4: ESTIMATED PROFIT FROM SELLING INKS[/td] [/tr] [tr] [td]ROW 5: EMPTY[/td] [/tr] [tr] [td]ROW 6: ESTIMATED PROFIT FROM VENDORING ENCHANTS[/td] [/tr] [/table]
Thank you, but i personally think not many of the people on here will understand/use this method to calculate the profit. Since they use public milling profiles which have a maximum AH Buyout of 30G/stack. Anyway good job and thanks.
It's more for us masochists out there that have to monitor our gold like silly school children, counting every penny; or, at least trying to ensure we allocate appropriate funds on the correct characters. Personally, I don't use an AH Bot, but for those that do, yea, they won't find much use of this.
It would be easier if you would just upload the sheet yourself, because I didn't understand shit about what you wrote.
