Skip to main content

Adjustments table

An adjustments table is a grid of coefficients, one per well of the plate. Applying it multiplies the values of the chosen data columns well by well. Open it with ADJ (Data Adjustments) in the Analysis Tools panel of the Data stage.

What adjustments are for​

Photos are rarely lit evenly: wells near the edge of the plate or under a reflection come out lighter or darker than the same solution in the centre. If you know this bias, for example from a photo of a plate filled with one reference solution, you can remove it with a coefficient per position:

xw,j′=xw,j⋅cr(w), k(w)x'_{w,j} = x_{w,j} \cdot c_{r(w),\,k(w)}

where xw,jx_{w,j} is the value of well ww in data column jj, and cr,kc_{r,k} is the coefficient in row rr, column kk of the table for the plate position of that well. A coefficient of 1.0 leaves the value unchanged, 1.05 raises it by 5 %.

One simple way to get the coefficients from a reference plate: for each well, divide the mean value of the plate by the value of that well.

Adjustments tables belong to your account, not to one experiment. You can reuse a table in every experiment with the same plate size.

Interactive demo. The demo plate has 3 × 4 wells.

Creating a table​

On the Adjustments Tables tab:

  1. Click Create New. The editor (Create New Table) shows a grid of the plate size filled with 1.0. Rows are labelled A, B, C…, columns 1, 2, 3…, as on the plate.
  2. Enter a Table Name.
  3. Type the coefficients into the grid. Bulk Update All Cells sets every cell to the value you type; Reset to 1.0 returns all cells to 1.0.
  4. Click Create Table. The table appears in Existing Tables.

To change a table, click its card in Existing Tables (the selected card has a blue border), edit the name or the grid in Edit Selected Table and click Update Table. The trash button deletes a table at once, without a confirmation.

Uploading an adjustments table​

In Upload Coefficients from Excel/CSV, choose a file and click Upload & Load. The new table is named after the Table Name field or, if it is empty, after the file. When processing is finished, the table appears in Existing Tables with the status completed; click it to select it.

The file must contain only the grid of numbers, one spreadsheet cell per well, laid out like the plate:

3 × 4 plate: 3 rows and 4 columns of cells, starting at cell A1
1.02 1.00 0.99 1.01
1.03 1.00 0.98 1.00
1.05 1.01 0.97 0.99
  • No header row and no row labels. The first row and the first column of the file are coefficients too. A header row 1 2 3 … would be read as the coefficients of row A.
  • The size of the grid in the file is the size of the table. It must match the plate schema (the dialog shows the expected size, for example The file should contain 8x12 numeric values).
  • A comma or a dot can be the decimal separator (1,05 or 1.05).
  • Empty cells and cells that are not numbers get the coefficient 1.0.
  • File types: .xlsx, .xls, .csv.

Applying to columns​

  1. Select the table in Existing Tables.
  2. Open the Select Columns tab. The card on the left shows the selected table.
  3. Tick the data columns to adjust. They are grouped by photo; each shows its channel (R, G, B, intensity…) and calculate type. Quick buttons: Select All, All RGB (channels R, G, B), All Intensity (intensity, rg_intensity, rb_intensity, gb_intensity), Clear All.
  4. Click Apply Adjustments.
The Select Columns tab with a table selected.

The dialog closes, the stage shows Applying adjustments..., then Adjustments applied successfully! and reloads the table with the new values. Only data columns are changed; sample and class columns are never touched.

Applying is not reversible
  • The values in the table are replaced. Applying the same table twice multiplies the values twice. There is no undo: to get the original values back, generate the table again or import an exported copy. Export the table before applying if you may need the raw values.
  • Adjustments are applied to the table saved on the server, and the table is reloaded afterwards. Click Save Changes before applying, or unsaved edits in the table are lost.
  • Fill in cleared (empty) data cells before applying. An empty cell makes the whole adjustment fail (Adjustments failed: …).

Adjustments and imported tables​

Coefficients are matched to rows by the plate position of the well. A table generated from photos knows the position of every row. An imported table does not: its rows are assigned positions in file order, 12 wells per plate row (row 1 → A1, row 13 → B1). Adjustments give correct results for imported data only when the file lists the wells in that order on a 12-column plate. Otherwise apply the correction before you import the file.

Errors​

  • Please select or create an adjustments table / Please select at least one column to adjust — select a table and at least one column (Apply Adjustments stays disabled until both are chosen).
  • Table dimensions must be RxC to match plate schema — the table has a different size than the plate of this experiment.
  • Adjustment table dimensions (…) do not match plate dimensions (…) — the same check on the server, for an uploaded table of the wrong size.
  • Adjustments failed: … — the adjustment stopped on the server. Common causes: empty data cells, an imported table with more rows than the plate has wells. Reload the page; if the table is not shown, generate or import it again.