6

Cataclysm Prospecting Spreadsheet For Obsidium, Elementium, and Pyrite

By on Dec 24, 2010 in Jewelcrafting, Spreadsheets, Tools, Warcraft Econ

An amazing spreadsheet by “flyinfungi” of the Elitist Jerks forums. This updated spreadsheet advises you on whether prospecting obsidium, elementium, and pyrite is profitable on your realm. Simply input the cost of gem prices and volatile earth and it does the math for you. It even shows columns estimating up to 20% less profit to account for falling market prices of gems. Happy Holidays to all of our readers and affiliates! Hope the spreadsheet was a good enough present for you! This is what they are working on for future versions:

To Do Work:

  • Uncommon Gem –> Rare Gem Xmute
  • Crafted items –>disenchant
  • Uncommon Gems –> Fire Prism
  • Uncommon Gems –> Metagems
  • Uncut Rare Gem –> Cut Gem
  • Gems –> Rare Crafted Item

This sort of analysis is expandable to various other economic areas. Please provide feedback if I am missing anything or any other good area. I have had a few emails requesting access to the spreadsheet. You should be able to copy this into another Google Doc if you want to do your own analysis. If you need more we can talk.

Prospecting Spreadsheet

Thanks to “flyinfungi” of ElitistJerks.com.

Click on File -> Download As -> Then choose your favorite format

DMCA.com


If you are new or have just discovered this blog not too long ago; here are 8 Ways to Get More Out of Warcraft Econ:

Subscribe to our RSS Feed
Follow us on Twitter
Add us on Facebook
Watch our YouTube Videos
Submit a Guest Post
Send me your questions and suggestions
Join the discussion by leaving a comment below.

About the Author

Oligopoly is a millionaire in various MMO economies is the founder/web administrator of Warcraft Econ and Diablo3Professions.com. He is one of the original gold cap WoW players. Launched in 2008, WarcraftEcon.net is one the longest running gold blogs and resources out there. We bring you news about the World of Warcraft economy, discuss strategies on making insane amounts of gold, and how to hit the gold cap. Enjoy your stay here!
  • Jason

    There seem to be no formulas in that, at least not where
    they should be. Looks like someone has messed with it.

  • Help please

    I open the spreadsheet, click file, click download as, and
    choose excel. After opening my saved excel sheet it
    doesn’t look like any of the formulas are present except
    for the G-J columns. Any advice from someone who has used the sheet
    successful would be appreciated! Thanks.

    • http://www.warcraftecon.net Warcraftecon

      I will leave a comment for the author when I get a chance later this evening.

      Author response: "Spreadsheet updated. There was a failure in copying from Excel to Google Docs."

      • Help please

        Hey thanks, I actually surfed away from this page but happened to see where you posted my comment on the EJ forum when I was cruising it. Going to go back to the spreadsheet and give it another go!

  • luiz

    We are supose to put the price per stack or per proc(5) ?

    • http://www.warcraftecon.net Warcraftecon

      Neither. You just enter the price of gems and it tells you how much each prospect or stack is worth.