Calculate The Cost of Crafting Potions, Elixirs and Flasks

[lilsniff]

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.

[lilsniff]

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.

[l4m0r]

or simply use aux

[lilsniff]

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.

[lilsniff]

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.

[yondamine]

Thank you for this it's very nice

[generation311287]

is there a way to put in the Prices from tsm automatic?

[lilsniff]

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!

[lilsniff]

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.

[Blinky]

I've been using this spreadsheet for a while. Thanks!

[yeawatt]

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?

[lilsniff]

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!

[anarchiatotal]

if anyone want/can update this for tbc/wotlk would be dope