One of the most flexible features of the Recipe Builder is its ability to include formulas in recipes. A formula is like a programming assignment statement. It enables you to specify how the Recipe Builder should calculate a value for a recipe item or variable.
You can construct a formula by entering one or more of the formula items listed in the following table into the Formula column of the spreadsheet.
|
Formula |
|
|
String constant |
"John" |
|
Numeric constant |
5 or 0.5 |
|
Mathematical operators |
+, -, *, /,^, = =, <= |
|
Function |
Log(234) or Lookup (#BATCH;1;2;3;4;5) |
|
Variable name |
#COLOR |
|
Keyword |
#BATCH |
By combining the items listed above, you can represent a value as best fits your needs. For example, the sample recipe, you may remember, requires 150 pounds of yeast to be added during fermentation. You can represent this amount as a numeric constant by entering 150 in the Formula column for the appropriate tagname. If you prefer, you can also assign this value to a variable and then use the variable as the formula for the block as shown below:
|
Identifier |
Formula |
|
#Yeast |
150 |
|
FERMENT1:Q16F1.F_CV |
#Yeast |
You could also represent the quantity as a mathematical expression such as 100*1.5. Assuming 100 is the standard batch size and 1.5 is the amount of yeast required for every barrel of beer produced, you can also represent the quantity with the following keyword and variable as follows:
#STD_BATCH*#Lbs_Per_Barrel
