鍊金藥水規劃師

這是一個電子表格，可讓您規劃要製作的藥水以及每種藥水要使用的成分。

描述：

這個mod是一個電子表格。它使您能夠計劃要爲每種藥水使用哪種兩種成分。

每個藥水都有製造藥水可用成分的列表。此列表會根據可用的食材進行更新，因此您沒有或用完的食材不會出現在列表中。

此電子表格無法執行的操作：

您不能計劃出具有多種功效的藥水

您不能計劃使用三種成分的藥水

您無法計劃使用多種不同成分的單一藥水

您無法預測精製藥水的價值或大小

電子表格：

此電子表格上有三個可見標籤和一個隱藏標籤：

計算器，您將在其中完成幾乎所有工作

成分-效果，成分及其對應效果的列表

效果成分，效果及其對應成分的列表

列出（隱藏）每種效果的動態成分列表。我建議您不要碰這一個。

您將在“計算器”選項卡上進行幾乎所有的計劃。其他兩個可見選項卡主要在此處供您參考。

如何使用：

首先，首先轉到“計算器”選項卡。

在綠色欄中輸入每種成分的初始數量

對於要製作的每種藥水：從黃色“成分1”列的下拉列表中選擇第一種成分，從黃色“成分2”列的下拉列表中選擇第二種成分，然後輸入想要在藍色的“手工數量”列中輸入。這些下拉列表中顯示的成分將根據您是否擁有而變化。

在計劃藥水時，請查看“成分1剩餘量”和“成分2剩餘量”列以及“剩餘量”列（D列），確保沒有耗盡所有成分。如果值是負數（如果您使用的成分多於可用成分），則這些列中的單元格將變爲紅色。

要重新開始，請單擊“總重量”單元格下方的“清除輸入”按鈕（必須啓用宏才能起作用）

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

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 ingredients by looking at the Ingredient 1 Remaining and Ingredient 2 Remaining columns, as well as the Remaining Quantity column (column D).  The cells in these columns will turn red if the values are negative (if you're using more of that ingredient than what's available).

To start over click the "Clear Inputs" button, underneath the Total Weight cell (macros must be enabled for this to work)