Commodities Return to the AH and a Handy Gem Spreadsheet

And in celebration, I'm including this (hopefully useful) Google doc:

https://docs.google.com/spreadsheet/ccc?key=0Ap184FzzQCX2dDg2UVhUdllmQzMyeko5djFrT3NLT1E

Its features may not be self evident.  This sheet uses the current AH prices for gems of grades 7 and up (Square to Radiant Star) to estimate crafting costs.  For instance, the sheet can estimate the cost of a Star Ruby using Radiant Square, Perfect Square, or Flawless Square Rubies (up to 3 grades below) based on their AH prices.

My original intent was to find efficiencies that I could exploit to profit.  In this vein, there are some columns that list the cost to craft (assuming you purchase all constituent parts at the AH), the AH list price, and your profit after the 15% reduction.

Since there's nothing really limiting the scarcity of gems, it's rather hard to find a profit.  For those of you eyeballing the profit margins of Radiant Star gems, remember that a lot of sunken costs go into crafting these (that include leveling up your gem crafter and purchasing a recipe, I didn't know how to amortize these costs per gem).  And most importantly, I imagine it's hard to find a buyer for Radiant Stars as these cost over 20 million gold.

Still, this sheet should be useful in helping you craft.  You may find that it's cheaper to craft using a lower quality gem than you originally anticipated.

I will attempt to keep this gem sheet updated (I have to enter the values by hand).  Any suggestions on streamlining this process are happily welcome.