The Excel workbook for evaluating assay quality in physico-chemical laboratories includes the following key features, designed to facilitate quality control in laboratories and ensure reliable results:
Main Features
Evaluation with Reference Material:
Allows assessment of results obtained from a single reference material, generating control charts based on the central value and reproducibility standard deviations.
Recovery Evaluation with Multiple Reference Materials:
Analyzes results through the mean recovery obtained from different reference materials, considering associated uncertainties.
Recovery Analysis via Spiking:
Evaluates results obtained from spikes on the matrix or extracted matrix, with adjustable control charts for recovery values.
Quality Control with Standard Samples:
Performs assessments using control samples analyzed over a baseline period, using mean values and absolute standard deviations to evaluate precision.
Evaluation Using Relative Coefficient of Variation (CVR):
Provides a more specific analysis based on the relative coefficient of variation of control samples.
Repeatability Analysis (Absolute Value):
Evaluates the consistency of two assays performed under repeatability conditions, comparing them with predefined limits.
Reproducibility Analysis (Absolute Value):
Allows evaluation of two results obtained under reproducibility conditions, adjusted to specific working ranges.
Relative Repeatability (CVr):
Compares relative differences between two repeated assays, using specific criteria for low, medium, and high ranges.
Relative Reproducibility (CVR):
Evaluates relative differences between results obtained under reproducibility conditions, based on the coefficient of variation.
Control Chart Generation
All sheets generate automated control charts that visualize results in relation to control limits (±2 and ±3 standard deviations).
Charts include options to customize axes and adjust them to the specific ranges of each material, sample, or assay.
Results are clearly classified as:
Satisfactory: Within control limits.
Questionable: Outside warning limits but within control limits.
