Alchemical Potion Planner

Here is a spreadsheet that allows you to plan the potions you want to make and the ingredients you want to use for each potion.

describe:

This mod is a spreadsheet. It allows you to plan which of the two ingredients you want to use for each potion.

Each potion has a list of ingredients that can be used to create the potion. This list is updated based on available ingredients, so ingredients you don't have or have run out of will not appear on the list.

What this spreadsheet cannot do:

You can't plan a potion with multiple effects

You cannot plan to use a three-ingredient potion

You cannot plan to use a single potion with many different ingredients

You can't predict the value or size of a crafted potion

spreadsheet:

There are three visible tabs and one hidden tab on this spreadsheet:

Calculator where you will do almost anything

Ingredients-Effects, a list of ingredients and their corresponding effects

Effect ingredients, list of effects and their corresponding ingredients

List (hide) the dynamic component list for each effect. I recommend you don't touch this one.

You'll do almost all of your planning on the Calculator tab. The other two visible tabs are mainly here for your reference.

How to use:

To get started, start by going to the Calculator tab.

Enter the initial quantity of each ingredient in the green column

For each potion you want to make: select the first ingredient from the drop-down list in the yellow "Ingredient 1" column, select the second ingredient from the drop-down list in the yellow "Ingredient 2" column, and enter what you want in the blue "Craft Quantity" column. The ingredients shown in these drop-down lists will change depending on whether you have them or not.

When planning your potion, look at the "Ingredient 1 Remaining" and "Ingredient 2 Remaining" columns as well as the "Remaining" column (column D) to make sure you haven't used up all of the ingredients. If the values ​​are negative (if you used more ingredients than available), the cells in these columns will turn red.

To start over, click the Clear Input button below the Total Weight cell (macro must be enabled for this to work)

——————————————————————————————

DESCRIPTION:

This mod is a spreadsheet.  It lets you plan which two ingredients you're going to use for each potion that you make.

Each potion has a list of ingredients that are available to make the potion.  This list gets updated based on which ingredients are available, so ingredients that you don't have or have run out of won't appear in the list.

What you CAN'T do with this spreadsheet:

You can't plan out potions that have multiple effects

You can't plan out potions that use three ingredients

You can't plan out a single potion that uses multiple different pairs of ingredients

You can't predict the value or magnitude of your crafted potions

THE SPREADSHEET:

There are three visible tabs and one hidden tab on this spreadsheet:

Calculator, where you will do virtually all of the work

Ingredients-Effects, a list of ingredients and their corresponding effects

Effects-Ingredients, a list of effects and their corresponding ingredients

Lists (hidden), dynamic ingredient lists for each effect.  I recommend that you don't touch this one.

You're going to do pretty much all of the planning on the Calculator tab.  The other two visible tabs are there primarily for your reference.

HOW TO USE:

To begin, first go to the Calculator tab.

Enter the initial quantities for each ingredient that you have into the green column

For each potion you want to make: Select your first ingredient from the drop-down list in the yellow Ingredient 1 column, select your second ingredient from the drop-down list in the yellow Ingredient 2 column, and enter the amount of potions that you want to make in the blue Crafted Quantity column.  The ingredients that appear in these drop-down lists will change depending on if you have them or not.

As you're planning out your potions, make sure you're not running out of in …