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:
where is the value of well in data column , and
is the coefficient in row , column 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.
Creating a table
On the Adjustments Tables tab:
- 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. - Enter a Table Name.
- 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. - 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:
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,05or1.05). - Empty cells and cells that are not numbers get the coefficient
1.0. - File types:
.xlsx,.xls,.csv.
Applying to columns
- Select the table in Existing Tables.
- Open the Select Columns tab. The card on the left shows the selected table.
- 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. - Click Apply Adjustments.
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.
- 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.