Friday, June 8, 2012

Changes to the Gem Sheet

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

In the spirit of making the gem sheet a lot easier to read, I've made changes to the presentation.  The calculations are basically the same, but instead of using an obtuse -N grade formulation as previously, the chart now calculates based on a specific grade of gem.

This way, you can see crafting costs pegged to, say, Flawless Squares.  The sheet can help you find price efficiencies (which are not always at Flawless Squares) and gets regularly updated.  Unfortunately, although the sheet calculates an accurate cost, it does not tell you what materials you need.

This is a problem without an easy solution.  I considered adding two columns next to each cost calculation for number of gems required and Tome of Secrets required, but that would significantly expand the sheet.  The intent remains to give users a very quick overview on the cheapest path to the gems they desire.  It remains up to them to figure out that you need 729 Flawless Squares and 1631 Tomes of Secrets to make a Radiant Star out of Flawless Squares (hah, really? Lame.).

When the 1.03 patch rolls out, we'll be making changes to include more grades to help find new, and hopefully better, price points.


No comments:

Post a Comment