ComputeStats
Calculates statistics for a referenced value.
ComputeStatsInputs
Syntax: ComputeStats(Event,Value,CountWhen Offline,ResetEvents.Manual,ResetEvents.Online,ResetEvents.Job Load)
Parameter | Description | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Specifies the event on which to incrementthe counter.This parameter must be a reference to one of the following:
|
|||||||||||||||||||
Specifies a required reference to the cell containing the source ofthe data to be computed.If no cell is referenced, the function returnsa #ERR for all results. |
|||||||||||||||||||
Specifies whether statistics will be calculatedwhile the sensor is Offline.For more information, see Online/Offline.
|
|||||||||||||||||||
Forces the computations to reset dependingon specific events.
|
ComputeStatsOutputs
Returns |
A Stats data structure containingthe computed statistics or #ERR if any of the input parameters are invalid. |
When ComputeStatsis initially inserted into a cell, a result table and a Reset button arecreated in the spreadsheet.When the Reset button is pressed, all counterswill be reset to zero. |
ComputeStatsVision Data Access Functions
The following Vision Data Access functions are automatically inserted into the spreadsheet to create the result table. For more information, see Stats.
Latest |
GetLatest(Stats) |
The most recent value. |
Minimum |
GetMin(Stats) |
The smallest value used to compute the statistics. |
Maximum |
GetMax(Stats) |
The largest value used to compute the statistics. |
Mean |
GetMean(Stats) |
The mean (average) of the values. |
Sum |
GetSum(Stats) |
The sum of the values. |
Standard Deviation |
GetSDev(Stats) |
The standard deviation of the values. |
Variance |
GetVariance(Stats) |
The variance in the values. |
Range |
GetRange(Stats) |
The range between the minimum and maximum values. |
NumError |
GetErrorCount(Stats) |
The total number of errors from the referenced value. |
NumSamples |
GetNumSamples(Stats) |
The total number of samples used for calculations. |