zur Startseite

Freeware programmes

Here we offer some EXCEL programmes for quality control charts and for the estimation of measurement uncertainty as well as assisting programmes for the evaluation of PTs.


Quality control charts are important and helpful tools of internal quality control in analytical laboratories. Therefore they are widely used and required by international standards such as ISO/IEC 17025

ExcelKontrol is a simple Excel® macro, intended for the daily operation of quality control charts in the laboratory.

With ExcelKontrol you may operate x-charts, r-charts, r%-charts, blank charts, differences charts and recovery charts.

All types of charts may be used as Shewhart-charts (with statistically determined limits) or as target charts. In the latter case the limits are defined by external quality requirements independent from the data.

The program is based on the description of quality control charts in the following publications:

  • Funk, W., Dammann, V. and Donnevert, G., 2007. Quality Assurance in Analycal Chemistry. 2. Auflage, Wiley-VCH, Weinheim
  • ISO 7870-2 Control charts.
  • NORDTEST, 2011. Internal Quality Control – Handbook for Chemical Laboratories. NORDTEST Report TR 569, available here

System requirements
Microsoft Excel 2007 or later

Author: Dr.-Ing. Michael Koch

Copyright: This program is subject to the copyright of the author. It may be freely copied and distributed, as long as the copyright notice is not removed.

Warranty and liability: This software is provided "as-is," without any expressed or implied warranty.
In no event shall the author be held liable for any damages arising from the
use of this software.

Improvement of the program: If you have suggestions for improvement of the program or you want to report bugs, you are invited to contact the authors. We gratefully acknowledge any support.

Save the file ExcelKontrol_2.4_setup_en.zip to your computer. The file must be unzipped, then you may install the programm with a double click on "ExcelKontrol_2.4_setup_en.exe". Please consider the EXCEL macro security options for the excution of EXCEL macros. You will find more details in the info text shown during installation or in the manual.

ExcelKontrol is available in German as well as in English.

Estimation of measurement uncertainty from validation and quality control data

  • In the NORDTEST- Handbook for calculation of measurement uncertainty in environmental laboratories as well as in ISO 11352 on the estimation of measurement uncertainty based on validation and quality control data a procedure for the estimation of measurement uncertainties is presented. We have implemented these calculations in an EXCEL workbook. At present two versions are available:

Estimation of uncertainty from sampling

Assisting programmes for the evaluation of PTs

If you have questions regarding these programmes, please do not hesitate to contact us.