Hey guys! Well, after a decent amount of hard work, and a lot of learning on my part, I've finally completed it: MoP Profession Leveling Kit Spread Sheet! I just want to take a second to say thanks to the likes of @Valdron , @PhatLewts , @Drrwho , @Tristan , and anyone else who provided input/advice on my way to creating this tool! I'd also like to thank @tedj for brainstorming with me, and helping give me the initial motivation to build this.
I really think people underestimate the potential behind Profession Kits, because of the work they involve. However, once you get a decent idea of how they work, you'll know what to keep your eyes open for, and be able to build the kit from scratch in under an hour. Even though this may seem like a lot of time, you can easily invest 3-5k into a kit, then turn around and sell it for anywhere from 15k, to the upwards of 50k! It all depends on the buyer, and your own personal skill at negotiating prices. Also, this spreadsheet will not teach you how to build/use Profession Kits, it's just a tool to help greatly simplify the entire process. To learn the process from scratch, I highly suggest reading @Namssob 's guide - How to: Create and Sell Profession Kits Now, to the spread sheet!
TUJ XML Data is currently unavailable. When TUJ is running again, the guide will be updated with an up to date walkthrough for the data. It has been flagged with yellow text for now, but will stay up for reference.For starters, let's cover what you will need to use the spreadsheet:
Getting the Data
- Your realm's TUJ XML or WoWuction CSV Data
- The spreadsheet
- Microsoft Excel
WoWuction CSV Data
Now, to start, you will need to download the spreadsheet, which can be found at the bottom of this post. Once downloaded, open it up, and travel to the CSV tab near the bottom. Word to the wise, at first glance this may seem to be a lot of work and not worth it. However, trust me, it is very worth it, and there isn't much work at all. I just broke it down to every step, so that nobody would get confused.
Once there, you'll notice that it's blank. It's time to fill that in using your WoWuction CSV Data. Head to wowuction.com, and log in using any Google/Yahoo!/FaceBook account. Once logged in, select your realm (located right below the "Log In" button). Ensure your Realm, Faction, and Region are all correct.
Now that you're logged in and have your realm selected, it's time to get the data. Navigate to your Resources panel, and select "Data Export".
Now scroll down and select the link to download your CSV data; be sure to save it somewhere that is easily accessible.
From here there are two ways to import your CSV data to the spreadsheet; I'll only be covering one, as it is far more simple and has less room for error. Contact me in game or on the forums for the alternative solution.
You'll want to open your data (double click it) and spreadsheet at the same time. Once open, copy the entire data table and paste it into your CSV tab on the kit spreadsheet. Your spreadsheet is now ready to use!
[OUTDATED FOR NOW]TUJ XML Data [OUTDATED FOR NOW]
Once there, you'll notice that it's blank. It's time to fill that in, as that is where all of your realm AH info will be stored. To do this, go to theunderminejournal.com, and make sure to be logged in (if you've never logged in, just log in with Google or Yahoo, whatever you want.) Once logged in, you will be choose your realm. After this, you need to go to your control panel.
Once this page loads, scroll near the bottom, until you find the section named "Market Data XML and CSV". Select the drop box, and choose your Faction/Realm. After this, highlight the link next to "XML:".
After you highlight it, press "Ctrl+C" to copy the link, then paste (Ctrl+V) into your URL bar at the top of your screen. After you press enter, it will begin the download of your realms data, which should only take a few seconds. Make sure you know where your information is being downloaded to, as you will need to find it.
Once downloaded, open the XML tab and be sure to have cell A1 selected. Click the "Data" tab near the top, and click "Existing Connections".
After you select this, you will get a pop up - select "Browse for More" at the bottom left of the window.
Navigate to the location you saved your Realm Data, and open it (you should still have cell A1 selected).
After some time, your data will finish importing, and you can use the spreadsheet to it's full extent! To update your realm's data, simply delete all the information in the current XML tab, select cell A1, and redownload/import your realms data to the tab again (just like you did in the beginning steps of this spreadsheet).
[EDIT]: Sometimes, your realm imports it's data in a different order than the majority of realms (has only happened with one, and I have been testing realms as I go - but I can only do so much), and the spreadsheet will be broken. You will get a #VALUE! error. There is a very simple quick fix for this, which I have outlined here. Only use this option if you have finished importing your data and received the #VALUE! error in return.
See, that wasn't too bad, was it? The guide makes it seem like a lot, but it actually happens very quickly. Now, how to use the spreadsheet.
Using the Spreadsheet:Well, congratulations, you have now imported all of your realm's data, and can now use your spreadsheet to start effectively building Profession Kits! The parts we will cover are:
- WoW Professions Mats
- Amount Required
- AH Lowest Buyout/Market Average
- Quantity Available
- Remaining Mats
- Projected Kit Cost (Minimum/Average)
- Projected Remaining Cost (Minimum/Average)
- Pricing Options (Lowest Buyout/Market Average)
- Maximum Pricing (Percentage)
- Suggested Sale Price
Throughout this guide, we will be referencing the "Alchemy" tab, to keep consistency, and simply because it is the first tab in the spreadsheet. Now, to begin covering the parts of the spreadsheet.
WoW Professions Mats
This will simply be a list of all the Mats required for the Profession Kit, in order of usage, as provided by WoW Professions.
This column consists of the amount of each material required for the kit, as listed by WoW Professions.
The amount of materials you currently have in stock. This column is manually updated by you, as you build the kit.
The amount of materials you still need to complete the kit. This column is automatically updated as you update the "Have" column. The following screen cap shows an example of the Have column empty, and one with some data filled in.
AH Lowest Buyout/Realm Market Average
Here is where the spreadsheet starts to become very useful. This column will change depending if you set your Pricing Options to "Lowest Buyout" or "Market Average" (we will cover this later). When set to "Market Average", the title will be "Realm Market Average". This shows the average price of each mat for the past two weeks on your realm, so it is always up to date, as long as your realm AH data is up to date.
When your Pricing Options are set to "Lowest Buyout", it will show the lowest buyout options for each mat, according to the last snapshot of your AH that you updated. You can also set your Maximum Pricing to whatever percentage you want (default is 150%, we will discuss this more in depth later), and if a mat is higher than that specification, the price will turn red. This helps you watch for any items that may be gouged by other players, so definitely watch for these indicators! You can see an example of a red cell below.
This is a straightforward column, as it literally just shows the quantity of each mat on the AH. However, it has an interesting feature as well. If the Quantity Available is HIGHER than the value in your "Needed" column (the amount you still need to finish the kit), then the cell is green. However, if the Quantity Available is LOWER than the value in your "Needed" column, then it will turn red - indicating that you will not be able to buy enough off the AH to complete the kit. Examples of each below.
The total number of mats you have left to buy.
Projected Kit Cost (Minimum/Average) and Projected Remaining Cost (Minimum/Average)
Projected Kit Cost (Minimum/Average) is a rough estimation of the amount that the total kit will cost. If you set your pricing options to Lowest Buyout, then it will display how much the kit would cost if you somehow managed to buy everything for the kit at the current Lowest Buyout. With the pricing options set at Market Average, it shows how much the kit should cost if you buy everything at the market average for the past two weeks. An interesting feature that was unintended, but very useful, is to compare the two prices. If the (Minimum) option is set at a HIGHER cost than the (Average) option, then there are most likely more than one item on the list being gouged, and it may be worthwhile to be "Out of Stock" for a bit, or you'll have to jack the prices up higher, which will result in less sales.
Projected Remaining Cost (Minimum/Average) is a rough estimation of what you will have to spend to complete your kit. This works exactly the same as the previous version, except instead of having it calculate the cost of ALL the mats, it only calculates the cost of the mats you still have to buy. Very useful if you have some items in stock, and they happen to be the ones being gouged - you might still be able to get the kit for right around (or below) market average.
Pricing Options (Lowest Buyout/Market Average)
To select your pricing option, just select the cell, then select the drop box and choose which option you want. Lowest Buyout shows the current minimum pricing of each item on the spreadsheet, where Market Average shows the average price for each mat over the past two weeks. These choices are vital throughout the entire spreadsheet, and change almost everything.
Maximum Pricing (Percentage)
This is a handy feature I added last minute, thanks to @Drrwho . The percentage represents the percent of market value that you want to stop buying mats at. So, if you want to buy anything that is at 150% market value or less, just input "150". No "%" is required, and will actually mess up the formula, so don't use it. The default option is 150%, but feel free to change it however you want. Once Lowest Buyouts are over the threshold you set, the cell will turn red, as shown both below, and in the "AH Lowest Buyout" above.
Suggested Sale Price
The spreadsheet now offers a suggested sale price based off how much profit you want. Just input what percentage of profit you want, and the spreadsheet will tell you how much you should sell it for! The default for all kits is 50% profit.
Well guys, I hope this spreadsheet helps you out! I know it is (so far) working wonders for me. You will discover more interesting/useful ways to play with it, and use it to your advantage, as you go. Some words of advice:
- Feel free to edit things to try and make it cleaner, if you are experienced with Excel. Make sure to save often, but if you screw something up, you can usually Undo (Ctrl+Z) your way back to where you began editing.
- Remember to update your Realm Data at least daily if you build kits often, but don't update too often. After all, you only get 10 downloads per day.
- If you have any problems, you can feel free to contact me at any point in game or here in the forums.
If you have any errors, bugs, or something that could be done better, please let me know. This was a fairly simple change over from XML-only to XML and CSV, but it was done over weeks. I may have missed some things that I intended to fix, or was playing with something and never put it back to original standings. Thanks in advance!
I will be posting a version with an empty XML slot, so make sure the first thing you do is import your realm's data. Good luck, and happy goblineering!