Register
Welcome to the Stormspire.net WoW Gold Forums!

Greetings, guest! Welcome to Stormspire.net, your #1 resource for WoW and Diablo 3 Gold, Professions, and everything in between!


Enjoy what the site offers? Consider Premium Membership if you wish to get the most out of the site. Premium Membership benefits include the acclaimed Goblineer's World of Warcraft Gold Guide, private forum access, a complimentary high-quality avatar, and much more!


If this is your first visit, make sure to check out the Stormspire.net Survival Guide for a quick site orientation. You may also register to unlock all standard forum features, and to get rid of these lovely ads!


We proudly host the Official forums for TradeSkillMaster, The Undermine Journal, and WoWuction.

Page 1 of 9 123 ... Last
Results 1 to 10 of 81
  1. #1
    US-Winterhoof(A)
    Wind Trader
    TheExile's Avatar
    Posts
    338
    Reputation
    48
    Tagged in
    137 Posts
    Add to this user's reputation

    TheExile's MoP Profession Kit Spread Sheet

    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!



    *****************NOTICE*****************

    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.



    Getting the Data


    For starters, let's cover what you will need to use the spreadsheet:



    • 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.

    1.png

    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".

    2.png

    Now scroll down and select the link to download your CSV data; be sure to save it somewhere that is easily accessible.

    3.png

    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]






    Ex1.png

    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.

    Ex2.png

    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:".

    Ex3.png

    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".

    Ex24.png

    After you select this, you will get a pop up - select "Browse for More" at the bottom left of the window.

    Ex25.png

    Navigate to the location you saved your Realm Data, and open it (you should still have cell A1 selected).

    Ex26.png

    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
    • Have
    • Needed
    • 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.

    Ex8.png


    Amount Required


    This column consists of the amount of each material required for the kit, as listed by WoW Professions.

    Ex9.png


    Have

    The amount of materials you currently have in stock. This column is manually updated by you, as you build the kit.

    Ex10.png


    Needed

    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.


    Ex11.png


    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.

    Ex12.png

    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.

    Ex13.png



    Quantity Available


    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.

    Ex14.png

    Remaining Mats


    The total number of mats you have left to buy.

    Ex15.png



    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.

    Ex16.png

    Ex17.png


    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.

    Ex18.png


    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.

    Ex13.png

    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.

    30.png




    Conclusion

    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!
    Attached Images Attached Images
    • File Type: png 1.png (30.2 KB, 0 views)
    • File Type: png 2.png (73.6 KB, 0 views)
    • File Type: png 3.png (65.7 KB, 0 views)
    Attached Files Attached Files
    Last edited by TheExile; September 8th, 2014 at 04:44 PM.
    MoP Profession Kit Spreadsheet | No Supply Custom Transmog Market
    Follow me @WoWTheExile
    Remember to +Rep someone if one of their posts help you!

  2. #2
    US-Stormrage(A)
    Entrepreneur
    Tristan's Avatar
    Posts
    405
    Reputation
    21
    Tagged in
    150 Posts
    Add to this user's reputation
    Excellent work man!! I likes it!!

    + rep

  3. #3
    US-Shattered Halls(H)
    Wind Trader
    PhatLewts's Avatar
    Posts
    837
    Reputation
    81
    Blog Entries
    2
    Tagged in
    448 Posts
    Add to this user's reputation
    Yeah very cool, love all the additions. Unfortunately my low pop server isn't the best for this, but I'm hoping to jump into these markets when Virtual Realms come out!

  4. #4
    US-Winterhoof(A)
    Wind Trader
    TheExile's Avatar
    Posts
    338
    Reputation
    48
    Tagged in
    137 Posts
    Add to this user's reputation
    Thanks @Tristan . @PhatLewts , I know what you mean. Until I moved to Stormrage, I couldn't build these because of the lack of supplies, and how easy it was to gouge items. To level up your Professions, you basically had to farm everything yourself, or you had to be willing to drop over 30k on supplies XD
    MoP Profession Kit Spreadsheet | No Supply Custom Transmog Market
    Follow me @WoWTheExile
    Remember to +Rep someone if one of their posts help you!

  5. #5
    US-Winterhoof(A)
    Wind Trader
    TheExile's Avatar
    Posts
    338
    Reputation
    48
    Tagged in
    137 Posts
    Add to this user's reputation
    @Drrwho , a 2003 version, just for you.
    Attached Files Attached Files
    MoP Profession Kit Spreadsheet | No Supply Custom Transmog Market
    Follow me @WoWTheExile
    Remember to +Rep someone if one of their posts help you!

  6. #6
    EU-Silvermoon(A)
    Ethereal Contributor
    tedj's Avatar
    Posts
    188
    Reputation
    20
    Tagged in
    90 Posts
    Add to this user's reputation
    Excellent, just excellent! You, of all people, know how this will be helpfull for me *winks* haha! I am currently working on it already!
    Goal - [Reins of the Swift Spectral Tiger] - Done!
    Sweet lord I love profession kits...

  7. #7
    US-Twisting Nether
    Moderator
    Caitlyn's Avatar
    Posts
    773
    Reputation
    71
    Tagged in
    374 Posts
    Add to this user's reputation
    This is very nice!

    One thing I love about it is how accessible and clear it is even for those with minimal spreadsheet experience. I see a lot of posts here from people asking for basic spreadsheet help, and I think your post could be useful for them on that basis as well.

    +rep and much appreciation for work well done.

  8. #8
    US-Drenden(A/H), US-Arathor(A)
    Wind Trader
    Namssob's Avatar
    Posts
    1,427
    Reputation
    114
    Blog Entries
    1
    Tagged in
    417 Posts
    Add to this user's reputation
    This is fantastic! Great tool, and I am in the process of abandoning my current "home grown" kits spreadsheet and replacing it with this one. Well done, and of course +rep!!
    How To: Create And Sell Profession Kits ---- MoP Shuffle Flowchart ---- Article: A Case For Dual Gathering
    "Never underestimate the sheer amount of derp the majority of WOW's playerbase possesses." -- Belrandir
    "They could have offered me free ERPing in Goldshire with real women over Skype for the next year and I would have passed." -- Zerohour
    "Scissors are OP. Rock is fine." --Paper

  9. #9
    EU-Draenor(H)
    Entrepreneur
    Saisa's Avatar
    Posts
    33
    Reputation
    1
    Tagged in
    11 Posts
    Add to this user's reputation
    This looks great! Even on my high pop server it's only been the past week or so I've seen 1 person selling a kit and it's only enchanting. So the gap is there and now you have given us this amazing tool it might be a gap I fill!

    +rep!

  10. #10
    Entrepreneur
    schwarzer's Avatar
    Posts
    27
    Reputation
    1
    Tagged in
    12 Posts
    Add to this user's reputation
    Great, and big thanks. About to have another L90 soon, so 2 professions to power level. This sheet will be helping me a lot

 

 
Page 1 of 9 123 ... Last

Similar Threads

  1. [Diablo III] Small AH Sheet
    By Kaspyn in forum Other Games Discussion
    Replies: 0
    Last Post: May 29th, 2012, 04:42 PM
  2. [Enchanting] Anyone have an exchanting spread sheet?
    By jimmyolsenblues in forum Professions
    Replies: 0
    Last Post: February 17th, 2012, 09:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •