In eCerto: Statistical Tests for the Production of Reference Materials

Data upload

Option 1

Please prepare data in a single Excel file using the Agilent MassHunter Software.

**Info** Excel format for Validation data. Cell background indicates imported information (green and red).

The information in columns Name and Type are kept for later reference only. The information on analyte names is extracted from the red area. The information on calibration levels (similar for all analytes) and according analyte concentrations within each level (analyte specific) is used as the independent variable $x$ in all figures and tables. The information on peak area of each analyte and its respective internal standard (IS) is used to calculate the dependent variables $y=f(x)$ in all figures and tables.

Note! Empty cells in the columns Level and Exp. Conc. will be filled with the closest finite value above, i.e. it is assumed that all samples in rows 4 to 12 in the example are replicates of calibration level 1 (as defined in row 3).

Option 2

Alternatively you can set up your data similar to the following layout.

**Info** Alternative Excel format for Validation data.

eCerto will try to determine the used format upon upload automatically.

Option 3

You can store any data imported from Excel together with all specified parameters in an RData file. Such an RData file can be loaded similar to one of the Excel files described above. The advantage in using such an RData file is that user defined parameters (alpha, k, filters...) are stored together with the raw data.