Alchemy Spreadsheet

[Anotherfox]

I'm releasing my Cataclysm Alchemy Spreadsheet for others to use to figure out the most profitable items based on material costs for you server.

Simply type in the costs of the materials (even if you grind them yourself) and it will output the figures for all 3 masteries (which are located on different tabs).

The Spreadsheet can be located here (25kb). It was created by Excel 2007.


The required Virus Scan


And because I love you all..... an example screenshot.

[20kilo]

Transmute Living Elements can proc... I've see x15life into x14air + x14air

[Anotherfox]

I know... but its completely random as to what will proc. Could be anything, but that an be added for 100% net profit

[DK1989]

Very Nicely done ^.^ +rep

[bobbajobb]

having a bit of trouble downloading this:
the 'download now' in the middle is an ad
and the 'save file to your pc' says that the file url is invalid? D;

[Anotherfox]

having a bit of trouble downloading this:
the 'download now' in the middle is an ad
and the 'save file to your pc' says that the file url is invalid? D;

I've put it on better (direct) hosting now. No-one will have problems downloading it.

[Tmorris37]

I know... but its completely random as to what will proc. Could be anything, but that an be added for 100% net profit

Its not completely random... its based on what zone you're in.

[Anotherfox]

Its not completely random... its based on what zone you're in.

Yes, and that's factored in the spreadsheet (which even show what you will get in which zone).
What was commented on was the proc chance which is completely random regardless of the zone you're in.

Even the screenshot shows this.....

[Itsrambo]

Excellent. Bump and +rep

[Scrubs]

Very helpful, nice work, +rep.

[eradik]

works great lol, had to fix a few formulas, or should i say add them, other than that its awesome.... makes me sad tho, server is over run with Chinese farmerz.

T.T

[Anotherfox]

works great lol, had to fix a few formulas

Which ones? I can fix them for when others download.

[eradik]

okay sorry for the late reply, but im using the spreadsheet again and i am a little lost.

Im an alchemist (Elixir spec) and as i said before i've been trying to look at your formulas
Why is it

=((E13/100)*120)

for the fee I'm assuming you are talking about the AH cut?
Wouldn't this work a lil better then?

=((E15*0.05)+E15)

Since the AH cut is 5% not 20%.

Imo if you are talking about the deposit, I don't know why you would include it considering u get it back?
Tell me if i am missing something here. Also in my previous post im talking about the AH price column, in the pages there are some that dont have the complete formula just a number.

[Anotherfox]

okay sorry for the late reply, but im using the spreadsheet again and i am a little lost.

Im an alchemist (Elixir spec) and as i said before i've been trying to look at your formulas
Why is it

=((E13/100)*120)

for the fee I'm assuming you are talking about the AH cut?
Wouldn't this work a lil better then?

=((E15*0.05)+E15)

Since the AH cut is 5% not 20%.

Imo if you are talking about the deposit, I don't know why you would include it considering u get it back?
Tell me if i am missing something here. Also in my previous post im talking about the AH price column, in the pages there are some that dont have the complete formula just a number.

Its not the AH Cut or deposit, its a 20% mark up price suggested for selling. Basically its Reagents Cost + 20% crafting fee. Obviously that is the minimum you should be posting them for on the AH.

That Auction House field is to work out profitability. Some fields have a direct number (based on actual AH data), but if there was no item on the AH I simply put a 20% fee for the sake of working out profitability with procs.
On my server the economy is majorly screwed as people constantly undercut each other, which often leads to items on the AH costing more to craft then sell.