Clocked Data Storage

Note:
  • The GetCount, the GetMax, the GetMean, the GetMin, the GetSDev, the GetSum and the GetValue functions reference a Delay data structure for the first parameter.
  • For the GetErrorCount, the GetFailCount, the GetPassCount and the GetTotalCount functions, returned values are from a referenced Count structure, which is inserted in the spreadsheet when the CountPassFail function is created. For more information, see CountPassFail.

Function

Description

GetCount(Delay) Returns the Count value from a Delay structure.
GetErrorCount(Count) Returns the incremental count of errors from a Count structure. The counter is incremented when the returned Value is less than zero.
GetFailCount(Count) Returns the incremental count of failures from a Count structure. The counter is incremented when the returned Value is equal to zero.

GetLoopCount(Loop)

Returns the current index of the repeated iterations performed by a Repeat or RepeatUntil function stored in a Loop data structure. For more information, see Repeat and RepeatUntil.

Note: To ensure proper evaluation, place the GetLoopCount function within the selection of cells that the loop operates on; otherwise the function will only be evaluated once and will not update in sync with the loop.

GetLoopReset(Loop)

Returns a 1 (TRUE) prior to the first execution of a repeated iteration performed by a Repeat or RepeatUntil function stored in a Loop data structure. This function may also be used to clear the data from any functions that retain data within the loop, such as a StoreData cell. For more information, see Repeat, RepeatUntil and StoreData.

Note: To ensure proper evaluation, place the GetLoopReset function within the selection of cells that the loop operates on; otherwise the function will only be evaluated once and will not update in sync with the loop.
GetMax(Delay) Returns the Max Value from a Delay structure.
GetMean(Delay) Returns the Mean value from a Delay structure.
GetMin(Delay) Returns the Min value from a Delay structure.
GetPassCount(Count)

Returns the incremental count of passes from a Count structure. The counter is incremented when the returned Value is greater than zero. For more information, see CountPassFail.

GetSDev(Delay)

Returns the SDev value from a Delay structure.

Note: This calculation is a biased standard deviation, where the denominator is N-1 (an unbiased standard deviation has a denominator of N).

GetSum(Delay)

Returns the Sum value from a Delay structure.
GetTotalCount(Count) Returns the total number of passes, failures and errors from a Count structure.

GetValue(Delay)

Returns the value stored in a Delay structure.