Register
Page 1 of 3 123 Last
Results 1 to 10 of 30
  1. #1
    Sterling's Avatar
    Posts
    3,847
    Reputation
    376
    Blog Entries
    1
    Tagged in
    2126 Posts
    Add to this user's reputation

    Consortium Profession Leveling Kit Spreadsheet

    This spreadsheet is based off the work of @Namssob and his guide How to: Create and Sell Profession Kits. This thread was originally in the Ethereal Contributor Exclusive Area and has since been moved to the public forums.

    The purpose of this spreadsheet is to facilitate buying and selling profession leveling kits. I barked a few kits in trade for fun and there was a lot of interest, which prompted me to develop this.

    What can the spreadsheet do?
    • Evaluates the cheapest cost to level a profession based on wow-professions.com guides.
    • Pulls pricing data from The Undermine Journal.
    • Calculates the cheapest alternative when 2 or more options are available.
    • Evaluates the number of bank slots required.
    • Provides a flexible shopping list.
    • Options to level to 525, or to an intermediate step (ie: 485 tailoring/leatherworking). This allows you to avoid the most expensive part of leveling.
    • Does all of the above for Jewelcrafting (495), Alchemy (525), Tailoring (485/525), Leatherworking (485/525) and Blacksmithing (525).

    This spreadsheet does not:
    • Take into account current available stock.
    • Evaluate ALL options for leveling.
    • Evaluate ALL options for creating materials (ie: prospecting Ores to obtain gems).
    • Allow you to mindlessly make profession kits. You still have to use your head! I recommend using wow-profession guides in conjunction with this spreadsheet.

    How to Use:

    • Import TUJ pricing under the "TUJ data" tab. as you would do in the Shuffling Spreadsheet. Baconcheese wrote a quick guide on how to import TUJ's excel data, check it out. Otherwise, you must manually input item prices in the "Kit Price" tab.
    • Switch to the Parameters tab. Fill out the beige cells only. Leave the remaining cells alone. The Overview area shows how much a profession costs to level, your sale price, your profit, and the number of slots each profession requires.







    • Switch to the "Kit Prices" tab. This is where the logic for each step is calculated. Take a look around, and familiarize yourself with the inner workings of the spreadsheet.







    • Switch to the "Shopping Lists" tab. This tab is similar to the "Kit Prices" tab. Here, you must fill out the beige cells with materials that you have gathered. The spreadsheet shows your progress in terms of units remaining, and % complete.






    • REMEMBER: updating the TUJ tab will change the spreadsheet's recommendations. Today's cheapest route may not be the same tomorrow!

    This project is still in beta. Changes will be made at a fast pace, so make sure to check back for newer versions frequently.

    >> Download Link <<
    Last edited by Sterling; December 28th, 2011 at 12:03 PM.
    Must-See: Stormspire.net Survival Guide | How-to: Tooltips in your posts | Consortium Key Sender (CKS) | Phat Lewts' Learn TSM Series
    Legion Mastery Series: Sniper | Cross-Faction Trading | Cooking | Blacksmithing, Leatherworking, Tailoring Master
    Old World: Smelting | Garrisons Part 1 - Buildings | Garrisons Part 2 - Followers | Profitable Alchemy Crafts
    Archived: Enchanting | Jewelcrafting | Toy Box Guide | Blacksmithing Transmog Guide
    Want to get the most out of the site and support the community? Consider Premium Membership
    Find a post useful? Give the author rep! And above all, be respectful and friendly to everyone.

  2. #2
    Sterling and Namssob, YOU GUYS Rock!

    Since I am not an Excel Expert, is the data from TUJ imported the same way as the spreadsheet from WT Stede's post?

    Latest Shuffle Spreadsheet for the Masses.


    Thanks

    Edit: I got the data to import! Follow up question? The numbers in the "Have" column are inputs from the users?
    Last edited by Crkwizard; December 15th, 2011 at 07:33 AM.

  3. #3
    Sinshroud's Avatar
    Posts
    2,679
    Reputation
    260
    Tagged in
    1060 Posts
    Add to this user's reputation
    Quote Originally Posted by Crkwizard View Post
    Sterling and Namssob, YOU GUYS Rock!

    Since I am not an Excel Expert, is the data from TUJ imported the same way as the spreadsheet from WT Stede's post?

    Latest Shuffle Spreadsheet for the Masses.


    Thanks

    Edit: I got the data to import! Follow up question? The numbers in the "Have" column are inputs from the users?
    Yeah it is and good job Sterling, looks great.
    If someone makes a helpful post or useful thread, be sure to let them know by giving +reputation. Spread the love!

    If you are new to gold making, or want to expand your markets for greater profits, then consider becoming an Ethereal Contributor to gain access to additional guidance on gold making, as well as our private dedicated help and support forum.

    >> WoW Account Maximum Security Guide <<

    "If you spend too much time thinking about a thing, you'll never get it done." - Bruce Lee

  4. #4
    Namssob's Avatar
    Posts
    1,485
    Reputation
    123
    Blog Entries
    1
    Tagged in
    454 Posts
    Add to this user's reputation
    Quote Originally Posted by Crkwizard View Post
    Follow up question? The numbers in the "Have" column are inputs from the users?
    Yes, it appears so. In my original spreadsheet (the basic cheesy one that this cool one is based on), I needed a way to keep track of which mats I was missing. This was MOST important when I was working on making 3-4 kits at the same time since the numbers were so big. I've altered my system *slightly*. I've found that working on "completing" one full kit at a time results in more frequent sales. I can start advertising for kits earlier, while I finish farming/buying-up mats for the 2nd, 3rd kits, etc.

    So yeah, that "Have" field appears to be user-supplied. Notice when you change it, it adjusts the number in the "remaining" field on the right.
    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

  5. #5
    Thanks All, much appreciated!

  6. #6
    Wow, this is awesome. I spent a few hours earlier this week working up a profession leveling sheet for JC but it's nowhere near this good. Thank you!

  7. #7
    Fantastic work! I used to calculate by pen and paper like an animal....with thumbs. +rep

  8. #8
    Of course, now I can't get it to work, having my usual XML import problem since I don't have Excel and can only use Symphony or oO. One of these days I'll get that figured out. Even manually updating the information, it has a much neater format and better functionality than what I was working with!

  9. #9
    Sinshroud's Avatar
    Posts
    2,679
    Reputation
    260
    Tagged in
    1060 Posts
    Add to this user's reputation
    Finally released to the public, hope the Ethereal Contributors got good use out of it and that now everyone else can too

  10. #10
    Acry's Avatar
    Posts
    1,327
    Reputation
    67
    Blog Entries
    3
    Tagged in
    618 Posts
    Add to this user's reputation
    Doesn't work for me in Excel 2007. I just get #REF for every box after importing into the tuj tab(tried 3x in cell 1 to make sure)

    Transmutation quest was changed to Truegold and some other stuff as well.

 

 

Similar Threads

  1. Profitable Leveling Guide: Blacksmithing 1-525
    By Sterling in forum Outdated Guides Archive
    Replies: 16
    Last Post: September 5th, 2012, 04:58 PM
  2. Profitable Leveling Guide: Blacksmithing 1-525
    By Sterling in forum Archive (Professions)
    Replies: 0
    Last Post: January 31st, 2011, 09:47 PM
  3. Consortium Profession Leveling Guides: Enchanting 1-425
    By Sterling in forum Outdated Guides Archive
    Replies: 13
    Last Post: November 8th, 2010, 08:51 PM