Calculate The Cost of Crafting Potions, Elixirs and Flasks menu

User Tag List

Results 1 to 8 of 8
  1. #1
    lilsniff's Avatar Contributor *snort*
    CoreCoins Purchaser
    Reputation
    229
    Join Date
    Mar 2008
    Posts
    704
    Thanks G/R
    126/86
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Calculate The Cost of Crafting Consumables

    Hello!

    I made this spreadsheet showing how much consumables cost based on the value of their materials. These values need to be updated by the user.

    NOTE: I've got notifications from users who want access to edit the sheet, as stated below you will have to download your own version. Requests to edit the sheet will not be accepted.

    This spreadsheet does not contain every single potion, flask or elixir etc, but those who are worth noting for the upcoming BWL release. If you notice something missing that should be included in this sheet, let me know!

    Here is a link to the spreadsheet: ConsumablesOC

    The spreadsheet contains seven sheets:
    1) Materials - this is where you update the AH prices for materials needed to craft the consumables
    2) Elixirs - crafting prices of elixirs
    3) Potions - crafting prices of potions
    4) Flasks - crafting prices of flasks
    5) Food buffs - crafting prices of food
    6) Blasted Lands consumables - total price for materials from AH
    7) Weapon buffs - crafting prices for weapon buffs

    To edit the spreadsheet you will have to download your own copy, hit "FIle" -> "Download" etc.

    Note that the gold/silver/copper values shown in the seven latter sheets do not need updating, only the first sheet with costs of the herbs etc.

    Here's a screenshot of how one of the pages looks like:



    Let me know if you have any suggestions/comments, of if you find any wrong formulas etc.
    Last edited by lilsniff; 02-25-2020 at 06:46 AM. Reason: New additions

    These ads disappear when you log in.

  2. Thanks tmanowen, Valois, Naxed, nugu, Krack3n, Zigurtt, Wasakada, P1trsavanger (8 members gave Thanks to lilsniff for this useful post)
  3. #2
    lilsniff's Avatar Contributor *snort*
    CoreCoins Purchaser
    Reputation
    229
    Join Date
    Mar 2008
    Posts
    704
    Thanks G/R
    126/86
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    UPDATE

    I've updated the spreadsheet with more consumables.

    Elixirs:
    - Elixir of Greater Firepower (not that useful at the moment, as it will be in the future and it's craftable now I decided to add it)
    - (Fire Oil, used to make Greater Firepower)

    Potions:
    - Greater Stoneshield Potion
    - Restorative Potion
    - Major Rejuvenation Potion
    - Mighty Rage Potion

    (NEW) Food Buffs:
    - Runn Tum Tuber Surprise
    - Nightfin Soup
    - Grilled Squid

    The Food Buff-section is not entirely complete, I'll add more when I get the time.

    List of materials has been updated with new materials needed for the above.

  4. Thanks Krack3n, Zigurtt (2 members gave Thanks to lilsniff for this useful post)
  5. #3
    l4m0r's Avatar Member
    Reputation
    9
    Join Date
    Dec 2008
    Posts
    84
    Thanks G/R
    0/3
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    or simply use aux

  6. #4
    lilsniff's Avatar Contributor *snort*
    CoreCoins Purchaser
    Reputation
    229
    Join Date
    Mar 2008
    Posts
    704
    Thanks G/R
    126/86
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by l4m0r View Post
    or simply use aux
    From what I've read and tested the crafting cost-function of Aux only shows in the actual profession window, so if you don't have Alchemy and want to easily know the crafting costs of your raid consumables Aux doesn't help much.

  7. #5
    lilsniff's Avatar Contributor *snort*
    CoreCoins Purchaser
    Reputation
    229
    Join Date
    Mar 2008
    Posts
    704
    Thanks G/R
    126/86
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    UPDATE

    I've updated the spreadsheet with more consumables. I've also done some cosmetic changes to all the sheets and sorted the materials page.

    Elixirs:
    - Oil of Immolation
    - Gift of Arthas

    Food Buffs:
    - Poached Sunscale Salmon
    - Monster Omelet
    - Tender Wolf Streak
    - Spiced Chili Crab
    - Spider Sausage
    - Heavy Kodo Stew
    - Dragonbreath Chili
    - Thistle Tea
    - Savory Deviate Delight (everyone knows you need to raid as either a pirate or a ninja!)

    (NEW) Blasted Lands consumables:
    - Ground Scorpok Assay
    - Gizzard Gum
    - Lung Juice Cocktail
    - Cerebral Cortex Compound

    (NEW) Temporary Weapon Buffs:
    - Dense Sharpening Stone
    - Elemental Sharpening Stone

    List of materials has been updated with new materials needed for the above.

  8. #6
    yondamine's Avatar Member
    Reputation
    1
    Join Date
    May 2008
    Posts
    12
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you for this it's very nice

  9. #7
    generation311287's Avatar Member
    Reputation
    1
    Join Date
    Feb 2011
    Posts
    1
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    is there a way to put in the Prices from tsm automatic?

  10. #8
    lilsniff's Avatar Contributor *snort*
    CoreCoins Purchaser
    Reputation
    229
    Join Date
    Mar 2008
    Posts
    704
    Thanks G/R
    126/86
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by generation311287 View Post
    is there a way to put in the Prices from tsm automatic?
    The sheet isn't made with that intention, but it's probably possible to change it to use TSM database instead. But I don't plan on doing this myself, you're welcome to look into it!

Similar Threads

  1. the cost of leveling your profession
    By Hordelife in forum World of Warcraft Guides
    Replies: 12
    Last Post: 02-15-2009, 05:31 PM
  2. [Exploit] Get T5 at the cost of honor points!
    By Ghowlish in forum World of Warcraft Exploits
    Replies: 60
    Last Post: 07-02-2008, 11:06 AM
  3. Basic Introduction to the structure of WoW's files and hexediting
    By schlumpf in forum WoW ME Tools & Guides
    Replies: 11
    Last Post: 04-12-2008, 12:47 PM
  4. The cost of living
    By djudo123 in forum World of Warcraft Exploits
    Replies: 12
    Last Post: 03-28-2008, 03:52 PM
All times are GMT -5. The time now is 02:20 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2020 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search