# ShiftRegister

Implements a shift-register array, or data stream into which the values of a cell are buffered after each event.

Note: After a reset, the first value that is read fills the shift-register.
Inputs

The ShiftRegister function Functions are tools that are available in Spreadsheet for processing and analyzing acquisitions or other results. You can add functions to your Spreadsheet job to create tool chains and produce results for specific applications. has the following syntax:

ShiftRegister(Event, Value, Number of Steps, Reset)

See the table for a description of the available parameters.

Parameters | Description
Event | Specifies the update event on which to read Value. This parameter must be a reference to one of the following: The Image data structure in cell A1 . This is the default setting. A cell containing a Button function. Note: ShiftRegister buffers the state of the referenced value after that value is updated by any other function that depends on the specified Event.
Value | A reference to the cell containing the source data (-9999999 to 9999999; default = 0).
Number of Steps | Specifies the number of values of the internal shift-register array in the function between 1 to 5000. The default value is 10.
Reset | Forces the function to purge itself of previously read values. The first value read after Reset effectively fills the shift register.
0 = OFF (default) | The function continues to read in values to the data stream.
1 = ON | The function purged all values from the data stream.

Outputs

Returns | A Delay data structure containing statistics for the specified Value over an interval from Reset to current.
Results | When the function is initially inserted into a cell, a result table is created in the spreadsheet with the following Clocked Data Storage Vision Data Access functions:
Label | Function | Description
Last | GetValue(Delay, Index) | The last value contained in the structure.
Mean | GetMean(Delay) | The mean of all the values in the structure.
SDev | GetSDev(Delay) | The standard deviation of all the values in the structure.
Min | GetMin(Delay) | The smallest value contained in the structure.
Max | GetMax(Delay) | The largest value contained in the structure.