Import and map assay data

Prepare the file

Keep the authoritative instrument export. Assay files may be UTF-8 CSV, TSV or TXT, or a supported static XLSX workbook, up to 15 MiB. Limits include 10,000 rows, 1,024 columns and 250,000 rectangular cells; a workbook shares the cell limit across its supported worksheets. Select a 96-well or 384-well rectangle.

CSV permits comma or semicolon, TSV uses tab, and TXT permits comma, semicolon, tab or pipe. Select the delimiter yourself if the columns do not appear as expected.

Provenarium reads saved values from supported XLSX worksheets; it does not recalculate formulas. Save calculated values in Excel before uploading and check the imported measurements and units. Legacy XLS files, macros, external links and unsupported workbook objects are rejected.

You can add PDF and DOCX documents as supporting information when planning with assistance. Upload the measurements separately as an assay data file. Supporting files are limited to 5 MiB each; a message explains if any content cannot be read. Check formula results in supporting spreadsheets against the original workbook.

Select the source and exact plate region

1. In manual setup, use Choose file on Import plate measurements. Check the displayed filename. If the file is rejected, correct the stated encoding, format, size or workbook problem and select it again.
2. Under Data selection, inspect the Sheet and Delimiter when available. Select the worksheet that contains the intended measurements; different sheets can contain different experiments.
3. Check Plate size, Top-left cell and Selected range. The selected rectangle must contain just the measurement grid, not row/column headings or notes. Use the worksheet preview and its Previous/Next rows or columns controls if the region is outside the visible window.
4. If shown, choose Confirm exact range after inspecting it. Continue when the plate range is ready. For example, source cells B6:M13 become plate wells A1:H12: a source cell address and a plate well name are not the same coordinate.

Assign the used wells

1. On Map the plate, inspect the preparation list and names. Use + Add sample for another preparation and select the appropriate role. Relative potency needs a reference and test preparations; concentration work uses standards, unknowns, optional quality controls and blanks.
2. Select a measured well. In its editor, set Sample, Dilution level and Replicate to match the physical experiment. Repeat for each used well. The same preparation and level may have multiple replicates; a new sample name alone does not map any wells.
3. A template can provide a starting map, but inspect every assignment before continuing. Do not apply a template over a custom map unless you intend to replace those assignments.
4. Keep absent observations distinct from zero. Empty/missing wells are not measured zero responses and cannot be used as valid observations. Leave unused measurements unassigned.
5. For a scientifically justified manual exclusion, select the mapped well, use Exclude from fit and enter the required reason. Check the recorded exclusions; do not remove a result simply to improve fit or suitability.
6. Continue to Define the dilution series and inspect Mapped observations. Check preparation, response, level, replicate and calculated concentration together before choosing the model.

Resolve a wrong map or missing value

If measurements look shifted, return with Back and check the selected source region before changing scientific settings. If only a sample, level or replicate is wrong, correct that assignment in Map the plate and review Mapped observations again.

An invalid or insufficient design must be corrected before Run. In routine mode the recipe is locked: if the new plate does not match the approved layout, stop and use a compatible source or the controlled Method revision process.

Before continuing, check that every well you intend to use has the correct preparation, level and replicate assignment.