In a study, Blank template (CSV) at the top of Set up and Data gives the study's columns without example results. The carryover template also fills in the 21 positions and roles. Each study type that takes an import also has an example file below, with the same headings and made-up rows. To use one as a template, keep the header, replace the rows with your results and import it. The example data are built from these files.
Example files#
All files are comma-separated UTF-8 with a decimal point. Row counts leave out the header.
| File | Study type | Rows × columns | What it contains |
|---|---|---|---|
| descriptive.csv | Descriptive summary | 5 × 6 | Five results with IDs 00001 to 00005, one level, day and run |
| repeatability.csv | Repeatability | 21 × 8 | One control material QC-001, 21 replicates in one run. One row, result 1004, is excluded as a transcription error |
| precision.csv | Multi-day precision | 25 × 6 | One material QC1: 5 days × 1 run × 5 replicates |
| accuracy.csv | Bias against an assigned value | 10 × 2 | Ten results for reference material CRM-1. Enter the assigned value on Set up |
| linearity.csv | Linearity | 15 × 5 | Five expected concentrations (0, 25, 50, 100, 200) × 3 replicates |
| dilution.csv | Dilution verification | 7 × 9 | Two high specimens HP-1 and HP-2, diluted in saline. Dilutions are given as volumes (100 + 400), a stated factor (5) and serial steps (5, 2) |
| comparison.csv | Method comparison | 20 × 4 | 20 specimens, comparative and test results in one row each |
| comparability.csv | Instrument comparison | 18 × 5 | 6 specimens at 3 levels, each measured on Analyzer A, Analyzer B and Analyzer C, one row per result |
| lots.csv | Lot comparison | 14 × 4 | 6 patient specimens and one QC material QC-1 on LOT-A and LOT-B. On Set up, enter LOT-A as the Previous lot and LOT-B as the New lot |
| reference_verify.csv | Reference interval verification | 25 × 4 | 24 subjects in partitions adult (15 rows) and senior (10 rows). One subject has a second draw, replicate 2 |
| reference_establish.csv | Reference interval establishment | 41 × 4 | 40 subjects in partitions female and male. One subject has a second draw. A small set for learning the steps |
| reference_establish_120.csv | Reference interval establishment | 240 × 4 | 120 subjects each in female and male, one result per subject |
| qualitative_agreement.csv | Qualitative agreement | 42 × 4 | 40 specimens with positive/negative results by both methods, some equivocal or invalid, and two repeat rows (replicate 2) |
| qualitative_cutoff.csv | Near-cutoff precision | 105 × 5 | 7 concentrations (6 to 13) × 3 days × 5 replicates, with positive, negative and equivocal results |
| detection_lob.csv | Detection limits, LoB | 40 × 8 | Two blank materials BLK-A and BLK-B, 4 days × 5 replicates each |
| detection_lod.csv | Detection limits, LoD | 50 × 8 | Two blank materials and three low materials (assigned 0.30, 0.40 and 0.55), 10 results each |
| detection_loq.csv | Detection limits, LoQ | 40 × 8 | Four low materials assigned 0.5, 1, 2 and 4, 10 results each |
| carryover.csv | Carryover | 21 × 5 | One complete 21-position run R1, low material LOW-01 and high material HIGH-01 |
| carryover_21_template.csv | Carryover | 21 × 5 | Blank template with the same 21 positions and roles and empty results |
| interference.csv | Interference | 48 × 6 | Pools P1 and P2 at level low and P1 at level high, each with base, control (0) and test aliquots at 1, 2 and 5, three replicates each. Pool P2 at level high has test aliquots at 5 with no control |
| stability.csv | Stability | 80 × 5 | 5 specimens in duplicate: baseline at time 0, then Room temperature, unspun (2, 4, 8, 24) and Refrigerated, separated (4, 24, 72). Declare both conditions on Set up |
| adm-qc.csv | QC targets (ADM export) | 8 × 7 | The seven ADM export columns. Sodium, code NA, lot 00123, level 1, on P_CC_3 and P_CC_4 for three days each. Two censored <3.100 results for aHBs2 level Low on P_IM_4 |
Sigma metric studies have no file.
Manual-only examples#
Made-up files used in a chapter's worked example.
| File | Used in | What it contains |
|---|---|---|
| qualitative_ordinal.csv | Qualitative agreement | 30 specimens with ordered grades negative, 1+, 2+, 3+ by both methods |
Other downloads in the app#
From your own studies you can download:
- Your original import files under Imported files, and for workbooks the table as imported. See Downloading the original import.
- Save a copy of my edits, a file of the open study including unsaved edits. See Saving and revisions.
- Report PDFs, saved HTML, Study data (CSV), Calculation file (JSON) and plot images. See Exports.