Import your plate reader data to begin
Upload an Excel file (.xlsx, .xls, .csv) containing your assay data. You'll identify which rows are calibrators and which are unknown samples, then OSMS Lab Tools will fit a 4PL curve and interpolate concentrations automatically.
| Sample | Mean OD | Interp. Conc. | n | Replicate SD | CV% | Status |
|---|
Your Excel file needs 3 columns (or 4 for triplicates). One row per calibrator or sample. The tool auto-detects calibrators vs samples from column A:
| Column | Calibrator Rows | Sample Rows |
|---|---|---|
| A | Known concentration (number, e.g. 125) | Sample name (text, e.g. "Patient 03") |
| B | Replicate reading 1 | Replicate reading 1 |
| C | Replicate reading 2 | Replicate reading 2 |
| D (optional) | Replicate reading 3 | Replicate reading 3 |
Each row = one calibrator or sample. The reading columns (B, C, etc.) are replicate measurements:
• Row with 62.5 in col A and 2 reading columns → calibrator at 62.5 pg/mL, n=2
• Row with Patient 03 in col A and 2 reading columns → sample, n=2
• If two rows share the same value in column A, their readings are pooled (e.g. 2 rows × 2 columns = n=4)
• Mean, SD, and CV% are computed across all replicate readings for each calibrator/sample
| Column A | Rep 1 | Rep 2 |
|---|---|---|
| 0 | 0.048 | 0.052 |
| 3.9 | 0.090 | 0.056 |
| 7.8 | 0.137 | 0.145 |
| 15.6 | 0.261 | 0.248 |
| 62.5 | 0.814 | 0.764 |
| 125 | 1.327 | 1.299 |
| 500 | 2.224 | 2.275 |
| 1000 | 2.583 | 2.536 |
| Patient 01 | 0.149 | 0.143 |
| Patient 02 | 0.352 | 0.344 |
| Patient 03 | 0.623 | 0.620 |
1. Click Import Data in the sidebar
2. Drop your .xlsx file or browse to select
3. Auto-detection scans column A:
Numbers → calibrators
Text → samples
Empty → skipped
4. Review detected rows, adjust if needed
5. Click Analyze → review 4PL fit
6. Click Load Dashboard — done
• Blank calibrators: use 0 in column A (not empty)
• A header row with text in all columns is auto-skipped
• Separate calibrators from samples with one empty row (optional but recommended)
• Supported formats: .xlsx .xls .csv
• The tool fits a 4-parameter logistic (4PL) curve and computes R², residuals, and interpolated concentrations
• CV% is calculated for any group with 2+ readings — singlets show "n=1"
Select the type of signal your plate reader produces. This changes axis labels and column headers throughout the dashboard and exported reports.
Current: Absorbance (OD) — this affects labels only, not calculations.