Register
Results 1 to 5 of 5
  1. #1
    Reverb's Avatar
    Posts
    919
    Reputation
    102
    Tagged in
    304 Posts
    Add to this user's reputation

    Excel Spreadsheet for Cataclysm Potions Profit Margins

    Warwithin posted a spreadsheet that calculated the net profit per unit and per 40 units of various Cataclysm potions on mmo-champion, which some of you may not look at ever and have missed this. It is posted here http://www.mmo-champion.com/threads/...s-in-tha-golds) It's well done. I took the liberty to make some changes to the file to account for a few missing potions (deepstone oil, potion of concentration, potion of illusion) and also to account for the reduction in material costs when factoring in potion specialization (that is what the value in A1 represents with .8 corresponding to the 20% greater production in potions, 1 for non-potion specialization people).

    The link to the edited version is here: http://db.tt/atDGGvT
    Last edited by Reverb; April 25th, 2011 at 06:15 AM.

  2. #2
    Namssob's Avatar
    Posts
    1,485
    Reputation
    123
    Blog Entries
    1
    Tagged in
    454 Posts
    Add to this user's reputation
    Very nice. I wouldn't mind seeing something like this for Flasks as well.
    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
    Reverb's Avatar
    Posts
    919
    Reputation
    102
    Tagged in
    304 Posts
    Add to this user's reputation
    Quote Originally Posted by Namssob View Post
    Very nice. I wouldn't mind seeing something like this for Flasks as well.
    I updated the file to include the missing potions from the Cataclysm expansion, flasks, and to take into account the 5% AH cut for same faction auction houses. The unit price of materials for flasks is taken from the table on the right most part of the potion table, so there is no redundant input. Fixed a mismatching calculation for the flasks table. Enabled Freezepane for Column 1 so that you can see the context of the information at all times.
    Last edited by Reverb; April 25th, 2011 at 08:30 AM.

  4. #4
    Much appreciated. thx

  5. #5
    Whoa, pretty neat!

    Added the Volatile Life and Truegold transmute (without additional proccs) and added an easier price list that doubles as a snatch list for Auctionator, just copy and paste into import. After searching, order by name, update the spread sheet and rake profits!

    http://dl.dropbox.com/u/14937631/Alc...Transmutes.ods

 

 

Similar Threads

  1. My Spreadsheet
    By thc1967 in forum Official Forum of The Undermine Journal
    Replies: 9
    Last Post: April 1st, 2011, 08:56 AM