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

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

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.

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