The Golden Crusade Spirit of Harmony Optimizer

[notice]With version 1.0.0 of The Golden Crusade Shuffler obtained all the features of the Spirit of Harmony Optimizer. As of such the standalone Spirit of Harmony Optimizer is discontinued. This page is left up for those who might want the Optimizer without the rest of the shuffling features, but support will not be provided and the sheet will not be updated.[/notice]

The Golden Crusade Spirit of Harmony Optimizer is a spreadsheet designed to show you how to use your Spirit of Harmony to get the most gold for them.

Find The Golden Crusade Spirit of Harmony Optimizer on The Consortium Forums

[important]

Download

Download The Golden Crusade Spirit of Harmony Optimizer V1.0.0

Get The Golden Crusade Spirit of Harmony Optimizer V1.0.0 on Google Docs

[/important]

Features

  • Breaks down the valuation, in gold, of Spirit of Harmony for each craftable that can be sold on the Auction House
  • Quickly tells you the most profitable use of your Spirit of Harmony for each profession (includes purchases as well)
  • Auto populates prices based on data gathered from The Undermine Journal with XML, CSV, and IQY support

Instructions

[notice]The Noobist Colony has a youtube tutorial for this spreadsheet, find it here: http://www.youtube.com/watch?v=RnseSrz45wg[/notice]

  1. Download the latest version of the file (found towards the bottom of this page) and save it on your computer.
  2. Log into The Undermine Journal and download the Market Data for your realm in the format of your choice (XML, CSV, IQY).
  3. Insert the data file into the relevant tab (XML goes into the XML tab, CSV into the CSV tab, IQY into the IQY tab). You only need one of the three data options, and the spreadsheet will prioritize XML>CSV>IQY. For detailed instructions to insert each data type see below.
  4. Open the tab “Optimizer” and you will be presented with the main features of the spreadsheet. On this page you are presented with all the ways you can use your Spirit of Harmony. The spreadsheet tells you what the gold value of a Spirit of Harmony is in each application. The higher the better.

[notice]If you’re using the spreadsheet on Google Docs you will need to first save a copy for yourself. Once that is done you will need to use File>Import to get the data in the spreadsheet. It’s recommended you use the CSV option.[/notice]

XML

  1. Open the tab labeled “XML”
  2. Ensure cell A1 is selected
  3. Go to Data –> From Other Sources –> From XML Data Import and select the file you just downloaded
  4. If prompted select okay when Excel tells you the XML source does not refer to a schema
  5. Confirm you will be inserting XML table into existing worksheet at cell A1 (might show up as $A$1)
  6. Wait while it inserts the data, this may take a few moments
  7. You may be presented with several errors telling you some data was imported as text, ignore these and click OK

CSV

  1. Open the tab labeled “CSV”
  2. Ensure cell A1 is selected
  3. Got to Data –> From Text and select the file you just downloaded
  4. Click Next through Step 1
  5. In Step 2 uncheck Tab and check Comma; click next
  6. Confirm you will be inserting CSV data into existing worksheet at cell A1 (might show up as $A$1)

IQY

  1. Open the tab labeled “IQY”
  2. Ensure cell A1 is selected
  3. Go to Data –> From Other Sources –> From XML Data Import and select the file you just downloaded (you may have to change the box next to File Name to “All Files”
  4. Confirm you will be importing data into existing worksheet at cell A1 (may appear as $A$1)
  5. (Optional) Go to Data –> Connections select the connection you wish to edit (named <Faction>-<Realm>) and click “Properties…” Under Usage in Refresh Control you can control how often the IQY data refreshes itself

2 comments

1 ping

  1. Auberean

    I made use of your original GC shuffler to create a spreadsheet similar to this a little while back. It has imperial silk, sha crystal, scroll of wisdom, ironpaw token, a farm guide, and a few other interlinked optimizers. Feel free to use it if you are looking to make any updates :)

    http://stormspire.net/tools-programs-spreadsheets/9017-resource-allocator.html

    1. Eric Dekker

      Yea I saw yours but I’ve been sitting on this for a while figured I might as well release it haha.

      I ended up not doing things like Imperial silk and Scroll of Wisdom since they had much better ways to get them without Spirit of Harmony and they can’t be sold on the AH so valuation was too difficult

  1. The Golden Crusade Spirit of Harmony Shuffler

    […] Golden Crusade Spirit of Harmony Shuffler Go To The Golden Crusade Spirit of Harmony Optimizer A few weeks ago I posted in a thread about Spirit of Harmony a spreadsheet designed to show […]

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>


*