User variable spreadsheet, Creating user variables – Watlow ANAWIN 2 User Manual
Page 116
10-22 AnaWin User’s Guide
Using the Developer
User Variable Spreadsheet
Each row in the spreadsheet represents a different user variable. The
row numbers correspond to the user variable numbers that you specify
when you are adding a user variable to a custom overview screen or
using the user variable as a reference for an animation. Refer to “User
Variable Properties,” earlier in this chapter, for details about formatting
the text for user variables. Columns A, B, C, and D contain the raw data
from which you will construct the user variable.
Creating User Variables
Follow these steps to create user variables:
1.
Assign data to cells in columns A-D as follows:
a. Select the cell to which you want to assign the data by clicking
on it in the spreadsheet. The Assign Entry To <cell> button
now indicates that data will be assigned to the selected cell.
b. From the data entry controls, select the option corresponding to
the data type you want to enter: Number, Formula, or
Controller Value.
c. Enter data of the selected type. Refer to the descriptions of the
specific options, above, for details.
d. Click
Assign Entry To <cell> to assign the data to the selected
cell.
2.
Use the Formula/User Var column to enter a formula for the user
variable based on the number and calculations in the raw data cells
(columns A, B, C, and D).
3.
Use the User Var Name column to enter a name for the user vari-
able.
4.
Ensure that Updates Enabled is selected. This option must be
selected in order for AnaWin to calculate user variables.
5.
Click Save to save the user variables you defined in the spreadsheet.