Tools & Templates
ISO4Lab develops practical laboratory quality tools, Excel-based applications, SOP templates, and technical resources designed to support laboratories, proficiency testing providers, and CRM producers in accreditation, quality assurance, and technical activities.
Excel Tools
ISO4Lab develops practical Excel-based tools designed to support laboratories, proficiency testing providers, and CRM producers in method validation, measurement uncertainty, internal quality control, proficiency testing evaluation, and accreditation-related technical activities.
Basic Laboratory Calculator
Excel-based calculator tool designed to support routine laboratory statistical calculations and basic data evaluation activities.
Key Features
• Mean, median, minimum, and maximum
• Standard deviation and variance
• Standard error calculation
• Range evaluation
• Statistical evaluation for up to 100 data points
Bias & Recovery Evaluation Tool
Excel-based tool designed to support evaluation of method bias and recovery using proficiency testing results, reference materials, method comparison data, and spiking studies.
Key Features
• Bias evaluation from one or multiple PT rounds
• Bias evaluation using reference materials and t-test
• Constant and variable bias assessment
• Bias evaluation considering measurement uncertainty
• Recovery evaluation using reference materials, blank spikes, and spiked samples
• Supports up to 30 data sets per calculation sheet
Intermediate Precision Tool
Excel-based tool developed to support evaluation of intermediate precision using ANOVA-based and single-dataset approaches for within-laboratory reproducibility studies.
Key Features
• Intermediate precision evaluation using ANOVA
• Intermediate precision evaluation from single datasets
• Intermediate standard deviation and relative standard deviation calculation
• Intermediate precision limit (Rw) calculation
• F-test for comparison against performance criteria
• Supports up to 30 data sets per worksheet
• Suitable for studies involving different analysts, days, and instrument
Linearity Evaluation Tool
Excel-based tool designed to support evaluation of method linearity and calibration performance during method validation studies.
Key Features
• Linear regression evaluation
• Correlation coefficient (R) and coefficient of determination (R²) calculation
• Calibration curve assessment
• Residual evaluation
• Slope and intercept calculation
• Graphical evaluation of calibration data
• Supports multiple calibration levels and replicate measurements
LOD & LOQ Evaluation Tool
Excel-based tool designed to support evaluation of limit of detection (LOD) and limit of quantification (LOQ) using multiple complementary statistical and graphical approaches during method validation studies.
Key Features
• Graphical evaluation using signal standard deviation
• Graphical evaluation using concentration standard deviation
• Low-level sample approach
• Concentration-based blank approach
• Signal-based blank approach
• Matrix blank approach
• Pseudo blank approach
• Calibration curve approach
• Automatic calculation of LOD and LOQ values
• Graphical and statistical evaluation support
• Supports up to 30 data sets per worksheet
Method Comparison Tool
Excel-based tool designed to support statistical comparison of analytical methods using reference method evaluation, paired difference analysis, and regression analysis approaches.
Key Features
• Reference method evaluation using paired measurements
• F-test for equivalence of variances
• t-test for comparison of analytical methods
• Paired difference analysis for bias evaluation
• Linear regression analysis between methods
• Supports up to 30 paired datasets per worksheet
Outliers Evaluation Tool
Excel-based statistical tool designed to support identification and evaluation of outliers in laboratory datasets during method validation, proficiency testing, and quality control activities.
Key Features
• Dixon outlier test
• Grubbs’ outlier test
• Cochran variance test
• Statistical interpretation support
• Suitable for single-result and variance-based evaluations
• Supports laboratory quality assurance and method validation studies
• Applicable to proficiency testing and interlaboratory datasets
Repeatability Evaluation Tool
Excel-based tool designed to support repeatability evaluation using multiple statistical approaches for datasets generated under repeatability conditions.
Key Features
• Pooled standard deviation from multiple sets of replicates
• Repeatability evaluation from duplicate differences
• Repeatability evaluation from a single dataset
• Standard deviation from squared differences of replicates
• Repeatability standard deviation, RSDr/CVr, and repeatability limit calculation
• F-test comparison against user-defined performance criteria
• Supports up to 30 datasets per worksheet
Robustness Evaluation Tool
Excel-based tool designed to support robustness (ruggedness) evaluation of analytical methods using Plackett–Burman experimental designs and statistical significance testing.
Key Features
• Robustness evaluation using 3-factor Plackett–Burman design
• Robustness evaluation using 7-factor Plackett–Burman design
• Evaluation of controlled factor variations at two levels
• Main effect calculation for critical method parameters
• Statistical significance evaluation using t-tests
• Assessment of robustness against repeatability performance
• Suitable for screening studies and method validation studies
• Supports evaluation of multiple critical parameters simultaneously
PT Evaluation Tool (Coming Soon)
Comprehensive Excel-based tool designed to support statistical evaluation of proficiency testing (PT) programs for laboratories and PT providers in accordance with ISO 13528 and ISO/IEC 17043 principles.
Key Features
• Assigned value evaluation using multiple approaches
• Performance scoring including z-score, z′-score, zeta score, and En evaluation
• Support for single-result and replicate-result PT schemes
• Robust statistical evaluation and outlier handling
• Homogeneity and stability evaluation modules
• Method-based statistical analysis
• Measurement uncertainty integration
• Graphical and statistical interpretation support
• Designed for PT providers and accreditation-related PT activities
SOP Templates
ISO4Lab develops practical SOP templates, forms, and laboratory quality management documents designed to support laboratories, proficiency testing providers, and CRM producers in implementing and maintaining accreditation systems and quality management activities.