Wednesday, September 30, 2009

[Spreadsheet] JCing/Enchanting Combo

I won't go over how to use the JCing/Enchanting method as there are many guides posted all over the forums on how to do it.

For example:
Goldguide (Made 40k in one week)

Anyways I made myself this spreadsheet based on this method and I've found it to be pretty accurate. Of course, it can't be 100% accurate because all prospecting are based off % given from wowhead. That being said, the gem outcomes are approximated. It assumes that you get an equal amount of all green gems, and all blue gems (of course this will almost never be true in practice, and it really doesn't matter for the green gems, cause you do the same thing with all of them but the Dark Jade and Shadow Crystal). Also, the spreadsheet assumes that you get 1 blue gem for every stack of saronite. It also accounts for the odd chance that you get 2 green gems instead of one. The spreadsheet is assuming that you enter gold prices as gold.silver/bronze (2 decimals for silver, 2 decimals for bronze). The spreadsheet will also tell you how many eternal earths you need for the amount of saronite ore that you are purchasing.

File:
RapidShare: Easy Filehosting

How To Use:
Green sections: Don't touch, they're just guidelines for you.
Red Sections: Are where you enter how much the items are worth on your server. Of course, prices will vary from server to server. TIP: When entering prices for gems, either enter the price of the uncut gem, or the cut that you will be able to sell the easiest as it would be a good amount of gold to expect from the gems.
Pink Section: Will be the only section that you will regularly change. This is where you enter how many stacks of saronite you are buying/planning to buy.
Yellow Sections: Will update automatically once everything else is filled out correctly.

Anyways, I hope this helps some people.

0 comments:

Post a Comment


Powered by: BlogSpot