Monthly Archives: October 2012

The ancient Chinese military general Sun Tzu said it best:

“Victorious warriors win first and then go to war, while defeated warriors go to war first and then seek to win.”

Now, I have no idea what this means. What I do know is that if you are a Protection Warrior looking for best-in-slot pants, you’ll need to work on your Klaxxi reputation. At revered, you’ll unlock access to Kovok’s Riven Legguards. If you reach level 90 and don’t want to wait on your Klaxxi rep, you can either spend 2,250 Justice points on the Leggings of Ponderous Advance or pick up the Blacksmith-crafted Masterwork Spiritguard Legplates. You can then insta-queue for heroic Siege of Niuzao Temple and hope Vizier Jin’bak drops his pants, the Sap-Encrusted Legplates.

Kovok’s Riven Legguards 90 The Klaxxi Revered – 2,250 Valor 13,505
Sap-Encrusted Legplates 90 Vizier Jin’bak Siege of Niuzao Temple (Heroic) 11,693
Masterwork Spiritguard Legplates 90 Crafted Blacksmith 10,072
Leggings of Ponderous Advance 90 Justice Quartermaster 2,250 Justice 9,783
Mogu Warlord Legguards 87 Townlong Steppes 8,382
Temple Guardian Pantaloons 88 Townlong Steppes 7,804

A crafter should always know the value of his tools and materials. This is true for crafters making goods to skill up and for those creating items to sell on the auction house. Material value can be easily seen in the game by using the World of Warcraft addon LilSparky’s Workshop (LSW).

What is LilSparky’s Workshop?

Simply put: this addon calculates the cost to create an item and lists the item’s market price next to it. This is powerful information when determining what items to craft when attempting to make gold on the auction house. This addon supports auction house scanners AuctioneerAuctionLiteAuctionMaster, and Auctionator.

Configuring the AddOn

Assuming you have one of the four support scanners, LSW will start working right away with no configuration. It will modify any of the following trade skill interfaces:

If you right-click on the value or cost column, you can select auction, vendor, or disenchant pricing model. By default, the greatest value returned from the three models will be used for that item.

Using the AddOn

You should see both the value and cost columns in your trade skill interface. Your potential profit is the value of the crafted item, minus the cost. LSW formats the value text in bold for items with a profit greater than zero. I use AdvancedTradeSkillWindow (ATSW), and sort my craftables by “difficulty.” I can then eyeball items with a higher profit and make those while leveling a profession.

I haven’t found a way to use LSW and ATSW together to return items sorted by greatest potential profit first. Skillet, on the other hand, will allow you to sort by LSW values, including “LSW: Profit.” The ability to sort by profit is extremely helpful if you are mass producing items.

Download the AddOn

You can download LilSparky’s Workshop from WowAce. The current version as of this post is r138 (September 29, 2012). This addon is not current on Curse or Wowinterface.

Yesterday, I wrote an introduction on how to use The Undermine Journal‘s IQY data source for your gold-making strategies in World of Warcraft. Today, I’ll walk you through a scenario where I calculate the price point for Mists of Pandaria Darkmoon Faire cards.

Previously, I worked through the various calculations to determine a conservative herb milling-to-Darkmoon Faire card crafting rate. I figured that it takes about 212 MoP-level herbs to craft a single card. If you are buying herbs at or under market prices, you can then set your price for a potential, substantial profit when you list your card.

Create a Master Market Pricing File

To get started, generate an IQY file from the Undermine Journal and open it using Microsoft Excel. You will be prompted with a security notice, and it is your responsibility to understand what this means and allow/enable the security exception if you wish to proceed.

You should now have a new Excel workbook with a single worksheet that is populated with WoW auction house market price data. This will be your master market price data for all of your other workbooks. Now, save this workbook to your computer.

You will need to update this file manually in order to retrieve current market pricing, but if you link to it properly (as you’ll see below), then all of your other spreadsheet calculations will use current market prices instead of you having to search for them one at a time and enter them as static values.

How to Use the Master Market Pricing File in Your Formulas

Next, create a new Excel workbook, and type in an item name into a cell. The name must match the actual item name found in the game, or the search will fail. In another cell within the same row of the item name, type the following formula:

=VLOOKUP(<item name cell>, ‘[<pricing workbook file name>]<pricing workbook file name’s worksheet name>’!$F:$G, 2, FALSE)/10000

In my DMF Card calculator, my formula looks like this:

=VLOOKUP(A2, ‘[The Undermine Journal – H-Earthen Ring.xlsx]H-Earthen Ring’!$F:$G, 2, FALSE)/10000

For me, this returns a match for the item name in cell A2 when searching my pricing workbook, “The Undermine Journal – H-Earthen Ring.xlsx,” where my worksheet name is “H-Earthen Ring.” Columns F and G should represent the item names and market prices as returned by the IQY.

Sample Use to Determine Cost of Creating a Darkmoon Card of Mists

I multiply the market price value of each herb by 212 (135 for Fool’s cap) to determine the minimum price I should sell a card for given the current market price. Theoretically, I’m buying herbs below market price, so this value should already indicate a small profit.

Here’s an example of what my table looks like given the current market prices of herbs:

Green Tea Leaf 2.42 2.42 212 512.85
Rain Poppy 2.27 2.27 212 481.16
Desecrated Herb 2.48 2.48 212 525.70
Snow Lily 2.74 2.74 212 581.49
Silkweed 2.41 2.41 212 511.47
Fool’s Cap 4.25 2.85 135 573.75

The “MILL VAL” column is used to determine the milling value of Fool’s Cap when comparing the ink yield rate against the other herbs.

As you can see, it takes a decent investment just to make a single card. You also have to factor in the Scribe’s time to mill the herb, craft the inks, and diligence to make their Scroll of Wisdom each day.

You can use this method for just about every profession that makes use of raw materials to help you determine what you should sell your crafted item for at minimum. If you’re not someone that is interested in crafting, this can still be useful to you to determine whether or not an item is above or below cost.

If you’re like me, then you’re handsome, famous, and play World of Warcraft. If you’re not like me, then you hate spreadsheets. Don’t worry, I’m here to help you. Now, let’s take a stroll to the forbidden, seedy land of Microsoft Excel and Web Query Files.

The Undermine Journal (UJ) is a great resource for data mining market prices and the economy in World of Warcraft. You can search for an item at a time, or use their canned reports to find various types of deals. One of the many hidden gems UJ has to offer is the availability of market data as a data source. I had been using the CSV format of their market price data, but recently switched to IQY.

IQY is a Web Query File that is nothing more than a text file that includes a data source address for a Web Service or API. The IQY file is then recognized by Microsoft Excel and data returned from the service call is displayed in a worksheet.

Here’s how to generate an IQY file for Excel:

  1. Register an account on The Undermine Journal. You will not have access to the IQY data source unless you are logged in
  2. On the User Controls page, find the “Market Data XML and CSV” section, choose a realm, and click on “Excel Data Source” to access your IQY file
  3. Save and open the IQY file in Excel

Now that you have your data, you can start mining the market locally. While you could certainly use this to simply look up item values for buying and selling, this data is extremely useful for crafting. In my next post, I’ll describe how this process applies to my crafting of Darkmoon Faire cards, and formulas you can use to query the data.

Hunters have an abundance of loot to choose from while preparing for end-game raiding. With Mists of Pandaria, Hunters once again are forced to make some tough decisions.

For Gloves, Marksman Hunters will be looking at auctioneers and Leatherworkers for assistance. The BoE, crafted pair of Raven Lord’s Gloves will be a Marksman Hunter’s best-in-slot. The only downside is the Leatherworking pattern comes from Mogu’shan Vaults. So, as a Hunter, you can check the auction house for this item. Good luck to you with that as there are very few available if at all, and prices will be outrageous until more players enter MV.

In the meantime, start working on your August Celestials reputation. A cool 1,750 Valor points will grant you access to the Sentinel Commander’s Gauntlets. Quests from the Dread Wastes will be kind to Hunters as well. The level 89 Wind-Reaver Handwraps will be your best option as you enter heroics and embark on the reputation grind. You’ll get a decent break from Shado-Pan, who will offer you the level 90 Brushcutter’s Gloves at only Honored status.

Raven Lord’s Gloves  90 Crafted Leatherworking 6,973
Sentinel Commander’s Gauntlets  90 The August Celestials Revered – 1,750 Valor 5,649
Brushcutter’s Gloves  90 Shado-Pan Honored – 1,750 Justice 4,463
Hopecrusher Gauntlets  90 Sha of Doubt Temple of the Jade Serpent (Heroic) 4,354
Contender’s Dragonscale Gloves  90 Crafted 3,745
Wind-Reaver Handwraps  89 Rending Daggers (Quest) Dread Wastes 3,652
Archer’s Precision Grips  90 Commander Vo’jak Siege of Niuzao Temple (Heroic) 3,591
Gauntlets of Bloody Judgment  90 Unto Dust Thou Shalt Return (Quest) Scarlet Monastery 3,347
Wind-Reaver Gauntlets  89 Nope (Quest) Dread Wastes 3,253
Osul Peak Gauntlets  88 The Endless Swarm (Quest) Townlong Steppes 3,062