Cata JC/Enchanting Spreadsheet

[Crid]

Spreadsheet designed for calculating profit of direct prospecting and selling gems or crafting rings/neck/weapon or buying gems directly of the AH and disenchanting

• Calculates total Ore/Stack cost
• Approx amount of Gems received through prospecting
• Value of Gems, Total profit of prospecting
• # of Dust/Essences received if you make rings/necks/weapon out of gems
• Calculates approx profit if you were to buy gems directly off AH

Self-explanatory, easy to use and understand

Forgot to include my Autoit Macro for Prospecting while wow is minimized:

$hWnd = "World of Warcraft"
While 1 = 1
ControlSend($hWnd,"","","1")
Sleep (3300)
WEnd

Note: I have only done Obsidium ore at this point in time. I will add Elementium and Pyrite in the future, I paln on adding more then just JC/Enchanting in the future but im busy with Holidays and exams so I have little time right now



Crid's JC/Enchanting Spreadsheet

[Destony]

This is sick for planning on prospecting for gold +rep

[Crid]

Yep Ive spent about 20k just on ore and made roughly 45k since release

[upc523]

Damn man, that's legit! Thanks for the post!

[Speakerwire]

I love it. +rep

[Otra]

Great spreadsheet! I'm not sure how easy it'd be, but it would be nice to add the small chance for the JC rings etc to proc a blue version, and DE to a small or regular shard. In any case, making great use of it already, so +rep

[Crid]

I haven't done a lot of disenchanting because price of dust vs gem is low so I've mostly done direct sales. Once raiding gets going enchant mats should go up