User variable spreadsheet, Creating user variables – Watlow ANAWIN 2 User Manual

Page 116

Advertising
background image

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.

Advertising