Duplicate/Replicate Report Tags

To place the calculated statistical data on a Microsoft Excel™ sheet , name the cell where the data is to be placed with the following reserved name tags. To make the XLS file easier to read, when a cell is named, enter the name of the cell as the cell value, within tilde characters (e.g. ~Scheme~).

Tag

Description

~AbsMean~

Absolute mean

~AbsStdDev~

Absolute standard deviation

~Analyte~

Analyte code

~CorrelationCoefficent~

Correlation coefficient

~DateFrom~

Analysis date from

~DateTo~

Analysis date to

~DegreesOfFreedom~

Degrees of freedom

~Gradient~

Gradient

~GradientError~

Gradient error

~GradientTValue~

Gradient T-value

~Intercept~

Intercept

~InterceptError~

Intercept error

~InterceptTValue~

Intercept T-value

~MaxPerDiff~

Maximum percentage difference

~MeanVal~

Mean value

~Methods~

Estimation method

~LimRep~

Limiting repeatability

~NoObs~

Number of observations

~NormalVal~

Normal value

~PerPosDiff~

Percentage positive difference

~PerDiff~

Percentage difference

~PrfArr1~

An array of calculated statistics for the estimated detection limit and the repeatability limit. The first row of this array includes: Action and Warning Limits for the Estimated Detection Limit. The second row of this array includes: Action and Warning Limits for the Repeatability Limit.

Note that the headers are purely text. It is just the 7 x 7 array that is placed by the ~PrfArr1~ tag.

~PrfArr2~

An array of calculated statistics for each concentration value, containing the concentration and percentage repeatability. Each row of this array includes: Concentration and Percentage Repeatability for a series of concentrations.

Note that the headers are purely text. It is just the 7 x 7 array that is placed by the ~PrfArr2~ tag.

~Scheme~

Scheme code

~StdDev~

Standard deviation

~Units~

Unit code

Table: Duplicate/Replicate Report Tags