JC/Enc Spreadsheet - Massively improved and user friendly

[seafunk]

Hi everyone! This is my first post. I just found out about this site and I'm loving it!

First of all, thanks to the poster of the last JC/Enc spreadsheet. I used some of your formulas, but nothing you'll still recognize in this one!

So what is this? A spreadsheet (first I've ever created) for Enchanters/Jewelcrafters that'll let you input the prices of various mats and then tell you exactly how profitable prospecting/crafting/disenchanting each type of ore/gem will be.

It will also tell you which gems to sell and which to use for crafting which I was missing in the last spreadsheet. Plus, it doesn't contain any ads and I tried to make it as neat as possible.

There is one worksheet called "INPUT" which is the only one you need to be editing, all the important information will then be found on the third sheet, while the second just contains tons of details that aren't really critical to know in order to maximize profit.

Hopefully, noone from my server gets ahold of this. This has helped me for the first time to systematically make a whole lot of cash via ah, enabling me to mroe than double my investment every day so far.

If there're any mistakes in it, feel free to let me know and I'll edit it right away. Don't be too harsh, it's my first spreadsheet as mentioned earlier.

Enjoy!!


PS: Expect to see more spreadsheets coming up soon for other profs! Got one for darkmoon cards ready, but gonna wait to see how this one is received.



http://rapidshare.com/files/444083328/23898391.rar

[winterbg]

Great Spreadsheet mate! +rep

[Løki]

This is amazing! Well done! I just have a question about the ore prices before I test this out tomorrow. Under input, are you specifying the cost per ORE or the cost per FIVE ore (prospect) ?

[seafunk]

Per ore, but it'll make sense once you've input your values. If you type the per 5 ore value into the field there won't be any profit which has never been the case for prospecting ore, at least not on my server.
I improved the spreadsheet by enabling the user to read data from an Auctioneer.lua instead of manually inputting the values. If there's demand I could upload that as well. I would love to get into addon programming, but it's not gonna happen while I'm studying medicine with a daughter... :/