Calculate The Cost of Crafting Potions, Elixirs and Flasks menu

User Tag List

Results 1 to 13 of 13
  1. #1
    lilsniff's Avatar Contributor *snort*
    CoreCoins Purchaser
    Reputation
    242
    Join Date
    Mar 2008
    Posts
    701
    Thanks G/R
    137/89
    Trade Feedback
    1 (100%)
    Mentioned
    1 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) Weapon buffs - crafting prices for weapon buffs
    7) Other - this list contains Blasted Lands and other consumes

    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; 08-11-2020 at 04:00 AM. Reason: New additions

    Calculate The Cost of Crafting Potions, Elixirs and Flasks
  2. Thanks Augury13, Valois, Naxed, nugu, Krack3n, Zigurtt, Wasakada, P1trsavanger, Blinky (9 members gave Thanks to lilsniff for this useful post)
  3. #2
    lilsniff's Avatar Contributor *snort*
    CoreCoins Purchaser
    Reputation
    242
    Join Date
    Mar 2008
    Posts
    701
    Thanks G/R
    137/89
    Trade Feedback
    1 (100%)
    Mentioned
    1 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
    14
    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
    242
    Join Date
    Mar 2008
    Posts
    701
    Thanks G/R
    137/89
    Trade Feedback
    1 (100%)
    Mentioned
    1 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
    242
    Join Date
    Mar 2008
    Posts
    701
    Thanks G/R
    137/89
    Trade Feedback
    1 (100%)
    Mentioned
    1 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
    242
    Join Date
    Mar 2008
    Posts
    701
    Thanks G/R
    137/89
    Trade Feedback
    1 (100%)
    Mentioned
    1 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!

  11. #9
    lilsniff's Avatar Contributor *snort*
    CoreCoins Purchaser
    Reputation
    242
    Join Date
    Mar 2008
    Posts
    701
    Thanks G/R
    137/89
    Trade Feedback
    1 (100%)
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    UPDATE

    I've updated the spreadsheet with more consumables.

    Elixirs:
    - Mageblood Potion
    - Major Troll's Blood Potion
    - Elixir of Poison Resistance

    Potions:
    - Greater Arcane Protection Potion
    - Greater Frost Protection Potion
    - Greater Nature Protection Potion

    Food Buffs:
    - Smoked Desert Dumplings
    - Dirge's Kickin' Chimaerok Chops

    Weapon Buffs:
    - Brilliant Mana Oil
    - Brilliant Wizard Oil

    (NEW) Other:
    - Powerful Anti-Venom
    - Crystal Charge
    - Goblin Sapper Charge

    Blasted Lands section has been changed to "Other" to include other consumes instead of making a separate page for these.

    List of materials has been updated with new materials needed for the above.
    Last edited by lilsniff; 08-11-2020 at 04:03 AM.

  12. #10
    Blinky's Avatar Active Member
    Reputation
    23
    Join Date
    May 2007
    Posts
    184
    Thanks G/R
    1/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I've been using this spreadsheet for a while. Thanks!
    wut

  13. Thanks lilsniff (1 members gave Thanks to Blinky for this useful post)
  14. #11
    yeawatt's Avatar Member
    Reputation
    1
    Join Date
    Aug 2021
    Posts
    1
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    This is AMAZING

    Originally Posted by lilsniff View Post
    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) Weapon buffs - crafting prices for weapon buffs
    7) Other - this list contains Blasted Lands and other consumes

    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.


    Mate this is amazing any chance you have done this for TBC update?

  15. #12
    lilsniff's Avatar Contributor *snort*
    CoreCoins Purchaser
    Reputation
    242
    Join Date
    Mar 2008
    Posts
    701
    Thanks G/R
    137/89
    Trade Feedback
    1 (100%)
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by yeawatt View Post
    Mate this is amazing any chance you have done this for TBC update?
    I don't know if I'll have the time, sorry. I'll let you know if I do get around to it!

  16. #13
    anarchiatotal's Avatar Member
    Reputation
    2
    Join Date
    Jul 2020
    Posts
    6
    Thanks G/R
    6/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    if anyone want/can update this for tbc/wotlk would be dope

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 08:48 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search