[Excel] Estimated Profits from Milling Stacks of Herbs

[y2krazy]

For a "live" estimate of potential profit for milling stacks of herbs, see the following:

---

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.

---

X	-30	=SUM(A1*B1)
=SUM(A1*4.5)	6	=SUM(A2*B2)
=SUM(A1*1.5)	40	=SUM(A3*B3)
EMPTY	EMPTY	=SUM(C1:C3)
EMPTY	EMPTY	EMPTY
=SUM(A2/3)	=SUM(18.75-B2*(3))	=SUM(A6*B6)

---

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.

---

ROW 1: GOLD INVESTED IN STACKS OF HERBS

ROW 2: VALUE OF [INK OF DREAMS] FROM X STACKS

ROW 3: VALUE OF [STARLIGHT INK] FROM X STACKS

ROW 4: ESTIMATED PROFIT FROM SELLING INKS

ROW 5: EMPTY

ROW 6: ESTIMATED PROFIT FROM VENDORING ENCHANTS

 

[Svenstar123]

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.

 

[y2krazy]

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.

 

[furyz0r]

It would be easier if you would just upload the sheet yourself, because I didn't understand shit about what you wrote.

 

[Teveel]

It would be easier if you would just upload the sheet yourself, because I didn't understand shit about what you wrote.

If you don't understand what he wrote furyz0r then him uploading a sheet won't help you either.

 

[seaway]

Thank you for this. It gave me a good place to start

 

[y2krazy]

Thank you for this. It gave me a good place to start

You're welcome! Now go make some gold!!