Descripción
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.
- Unsatisfactory: Exceeding control limits.
