To Variables
The To Variables function exports the contents of cells(s) to XLReporter variables. The variables can either be Function variables defined in the project (like a Register), Memory variables or Custom variables. Variables can be selected from the browser or manually entered at the top of the browser.
Settings | |
|---|---|
Input Cell (up to 4) | The cell containing the value to export to variable. |
Variable (up to 4) | The variable to export the cell value to. |
Example
A daily report is required to retrieve the maximum flow rate over the day and the time that it occurred. Then, a set of process values need to be retrieved at the time the maximum flow rate occurred for analysis purposes.
To accomplish this, first a Data Connection is configured to retrieve the daily maximum and the time that it occurred.
 |
Notice this connection is configured for Group 1.
A second data connection is configured to retrieve the sample values at the time that maximum occurred.
 |
Notice this connection is configured for Group 2.
Looking at the group itself, under the Time Period tab,
 |
The Type is set to Variable with the Start Date set to {Start Date}. This variable needs to be set with the time of the maximum flow rate for the day.
To set this, a Data Management To Variable function is configured.
 |
The Start Date Variable is set to Cell $B$5 which contains the time the maximum flow rate occurred.
This connection is also set to Group 1 so that the variable is set before the process data is retrieved.
In the Scheduler there are 2 actions required to run: the update of group 1 and then the update of group 2. These can be scheduled to run at same time as long as the group 1 update is listed first.