[Spreadsheet] JCing/Enchanting Combo

[n0skillS]

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:
http://www.mmowned.com/forums/wow-gu...-one-week.html

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.

[Broken_Sound]

Trying it out now, will update with thoughts later.

[dushkarn]

nice and easy to understand spreadsheet +rep

[buahbleah]

nice.. i like it, i'll put this link in my guide you mentioned, if thats ok
+Rep

[myanee]

Nice job mate, really nice. Will try it out and report later

[HolyGraal]

nice work... how did u calculated the amount of gems u get from prospecting?

+rep x2

[holydevil33]

nice one man

[JD!]

Very Usefull indeed +rep

[n0skillS]

nice.. i like it, i'll put this link in my guide you mentioned, if thats ok
+Rep

That would be great. Thanks :wave:.

nice work... how did u calculated the amount of gems u get from prospecting?

+rep x2

Honestly, I fluked out a bit when calculating how many green gems you will acquire. The formula I used was (how many stacks of ores) * 4 * 0.18. The 4 comes from you get to prospect 4 times a stack. The 18 is from the 18 that is given by wowhead for the % of each green gem. Again, it was just a fluke on how it worked so that it included the chance of getting multiple gems for one prospect. As for the blue gems, I just assumed that you get 1 blue gem from every stack.

[Black Gull]

I can't download it

[brokeuh]

the price u set in red section is that each or price a stack ?

coz atm if u spent like 500 g on mats to make it it says i only make 30 g profit

[n0skillS]

I can't download it

Hmmm, whats the message that you are getting. It seems that others are able to download it fine.

the price u set in red section is that each or price a stack ?

coz atm if u spent like 500 g on mats to make it it says i only make 30 g profit

Where you insert the prices, put in how much it costs PER STACK. Assuming that you are talking about the ore.

[engagedtosmile]

thanks for this. has helped a lot.

[moofman]

Wait, is it just the Saronite Ore Price is per stack? Is everything else the price of a single item or is everything per stack? Also, are the gems individual or stack?

[dann462]

"When entering amount of saronite ore to purchase, enter the # of stacks"