Register
Page 1 of 3 123 Last
Results 1 to 10 of 21
  1. #1

    Lightbulb Profession Kit Calculation Spreadsheet. Making life easier!

    Profession Kit Spreadsheet


    Hey! Thanks for visiting my thread. Hopefully this little spreadsheet will make pricing up prof kits that little bit easier. Recently I've had some trouble making gold on my favorite server and have had to diversify greatly. I stumbled upon Namssob's post about profession kits and thought it was an excellent idea. I did a few trial runs and all where making me a nice chunk of gold. I decided the best way to proceed was to make a spreadsheet so i can quickly evaluate the market for the material costs. This is how the spreadsheet came to be.

    If you are new to profession kit's i highly recommend you thoroughly read through Namssob's thread here before you continue. Before i explain how to install and use the spreadsheet i want to express how this is only an estimate of the total cost based on TUJ's market prices, this spreadsheet does not guarantee a total end cost so check the price before you buy!



    Installation & initial setup


    First of all you need to download the spreadsheet from the attachments to this post. Once opened confirm the security prompts at the top of excel allowing you to edit the spreadsheet and such. Now, to import the data. We are going to be using the TUJ database so you are going to need an account there. Go to your control panel on the website and follow the instructions below.


    Step 1 - Download the database of the server+faction you plan to buy the mats on.



    Step 2 - Import the Data into excel

    Open the worksheet labelled TUJ data at the bottom of the excel file.
    Ensure you have cell A1 selected and open the data ribbon at the top of the screen.
    Click on the Existing Connections button on the data ribbon.
    Follow pictures below.











    Now wait a few moments while the data is being downloaded. After this has completed you should see something like this:



    Step 3 - Filter the data

    The functions i used in the spreadsheet require the list to be sorted alphabetically. To do this all you have to do is apply a filter as shown in screenshots below. (click thumbnails to open new window)









    Now the data is correctly set up. Return to the Main Sheet.




    Using the Spreadsheet



    Now you have everything set up correctly you can begin browsing through the spread sheet. Every tab is rather self explanatory with an overview on the main page. The annotated screenshot below gives a general idea of the format.


    Updating the database is very simple, although will sometimes need a quick re-sort. Follow screens below.









    About the Spreadsheet


    The spreadsheet is not yet entirely finished. I will be updating it as often as possible and the other modules should be working within a few days. Please leave me a comment if you like this spreadsheet and i appreciate any and all feedback you can give me. If you have any ideas on how to improve the spreadsheet please post them below.


    Attached Files Attached Files
    Last edited by Lodimas; January 15th, 2013 at 11:22 PM.

  2. #2
    Namssob's Avatar
    Posts
    1,485
    Reputation
    123
    Blog Entries
    1
    Tagged in
    454 Posts
    Add to this user's reputation
    First, GREAT WORK! I think this is an outstanding idea, and basically mimics almost exactly the spreadsheet I use personally for my kits.

    Second, here are some suggestions for improvements:

    1. I'm getting a lot of "#NA" errors when something is not listed on the AH. Figure out a way to set a default value on these items if the result is #NA.
    2. You're still missing some professions - but I'm sure you'll be populating them!
    3. Be careful with using the EXACT same quantities listed at wow-professions.com. One of the reasons my kits have been so successful, and my reputation for selling them on my server is really outstanding, is I identified (after selling several kits and tweaking the list) certain bottlenecks, and added extra "buffer" mats. For example, where the JC kit calls for 46 Eternal Earth, or 23/23 Earth/Shadow, I just round it up to 25 each, for a total of 50. Same with Copper Bars (I provide 120 instead of 100), and the Cataclysm Gems (I provide more than recommended).
    4. I'd personally change the formatting of the TOTAL cell / column to make it stand out more.


    I'll play with it more, but it's really great work! + 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

  3. #3
    The data import isent working for me, I have other spreadsheets so im not doing anything wrong (well I shouldent and there are pictures to follow dammit :P), any ideas?

    The "where do you wanna put your data window" dosent show up.

    Still, nice work!
    Last edited by Lill; January 17th, 2013 at 06:26 PM.

  4. #4
    Great job! I made myself a set of these spreadsheets when I started selling kits and they are such a valuable tool. A few suggestions (note I can't open these on my phone, just basing these off screenshots):

    1) Just personal preference, but I would remove the value in copper column and either the math to your gold column or do it somewhere else
    2) One thing that helped me was importing the quantity available on the AH. This allowed me to see if I could fully outsource and also provides more info on the "true value."
    3) For kits that require mining bars, I ended up switching to show the value of ore instead of bar. The bar values are pretty inflated (which can be a good or bad thing). Obviously need to double the values where 2 ores are needed for one bar. This could maybe be a toggled option?

    Anyway these are just personal picky things, this is a nice tool thank you for sharing

  5. #5
    this is awesome!!! kudos. any timeline on when the jewlcrafting will be ready?

  6. #6
    Dude this is awesome, i was thinking there should be of something like this anywere for the past 2 days and today boom! it just pop out on TUJ main page.

    Many thanks

  7. #7
    Quote Originally Posted by Namssob View Post
    First, GREAT WORK! I think this is an outstanding idea, and basically mimics almost exactly the spreadsheet I use personally for my kits.

    Second, here are some suggestions for improvements:

    1. I'm getting a lot of "#NA" errors when something is not listed on the AH. Figure out a way to set a default value on these items if the result is #NA.
    2. You're still missing some professions - but I'm sure you'll be populating them!
    3. Be careful with using the EXACT same quantities listed at wow-professions.com. One of the reasons my kits have been so successful, and my reputation for selling them on my server is really outstanding, is I identified (after selling several kits and tweaking the list) certain bottlenecks, and added extra "buffer" mats. For example, where the JC kit calls for 46 Eternal Earth, or 23/23 Earth/Shadow, I just round it up to 25 each, for a total of 50. Same with Copper Bars (I provide 120 instead of 100), and the Cataclysm Gems (I provide more than recommended).
    4. I'd personally change the formatting of the TOTAL cell / column to make it stand out more.


    I'll play with it more, but it's really great work! + rep!
    Are there any other bottlenecks you've found if you don't mind my asking?

  8. #8
    Excellent work. I've played a little with the spreadsheet and it looks awesome.

    One adjustment I made as a quality of life improvement was insert a column between F and G named 'Banked' to keep track of any mats I might have farmed on my own. I then modified the formulae in the hidden column (which is now column H) to be "=F3+G3-B3" and named that column "Needed". I know it shows negative numbers, but this helps me in determining how many of particular mats I need to farm up.

    Thanks again for this valuable resource and I look forward to seeing the other professions added in. Keep up the awesome work!

  9. #9
    McEG's Avatar
    Posts
    72
    Reputation
    0
    Tagged in
    25 Posts
    Add to this user's reputation
    How might i use this in open office? i cant seem to open the tuj data...

  10. #10
    Great job with the spreadsheet.

 

 

Similar Threads

  1. Consortium Profession Leveling Kit Spreadsheet
    By Sterling in forum Outdated Guides Archive
    Replies: 29
    Last Post: May 16th, 2014, 01:42 PM
  2. 4.3 Profession Spreadsheet (Updated often)
    By rangeupnow in forum Archive (Professions)
    Replies: 3
    Last Post: July 21st, 2012, 10:36 AM
  3. Easier, less profitable methods of gold making, with little competition.
    By Michaelc6 in forum Archive (Auction House)
    Replies: 16
    Last Post: July 17th, 2012, 04:34 PM