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.