Skip to content

The legend and plate IDs

The legend is the name of the sample in every well. It appears in the well table, in the reports and in every export.

Editing the legend

The Legend tab shows the plate as a table: rows A, B, C ... and columns 1, 2, 3 ... Type a sample name into a cell.

Control Effect
Lock Vert What you type into a cell is also copied into every cell below it in the same column
Lock Hor What you type into a cell is also copied into every cell to its right in the same row
Save Save Table with Dataset - store the legend in the plate's INFO folder
Export / Import Write or read a legend file, kept in your Layouts folder
Use File Names as Legend Fill every cell with its well's file name

Tick File Names as Legend or untick ShowLegend on the Options tab to control what the well table shows.

The legend is also saved inside every project.

EZ import and export

These buttons exchange the legend with a plate-management system through simple text files with one row per well:

<plate ID>,<well>,<ploidy>,<sample name>

for example

CC0161,A1,2,Line 17-3
CC0161,A2,4,Line 17-4
Button Effect
EZ Import Read such a file. The sample names fill the legend (the ploidy column is ignored) and the plate ID appears on the toolbar
EZ Export Write the plate's IDs, wells, ploidy levels and sample names into your Excel template - see below. If Excel is not available you are asked for a CSV file name instead
EZ Save Write the file as <plate name>.csv into the plate folder, next to the data
CSV Export Write the file under a name you choose

EZ Save and CSV Export are in the pop-up next to the EZ buttons.

When a plate is opened, Xploid imports <plate name>.csv from the plate folder automatically - so a file written with EZ Save, or placed there by the plate-management system, is picked up without a click. If there is none, INFO\Zaden.csv is tried.

Without an imported plate ID, the plate name is used as the ID.

Excel template

EZ Export fills an existing Excel workbook. Set it up once on the Options tab:

Setting Meaning Default
Excel Template The workbook; v browses for it
Sheet Name The worksheet to fill PloidyPortrait
Row / Column The top-left cell of the table 18 / BA

The four columns - plate ID, well, ploidy, sample name - are written from that cell down, one row per well.