Column

Column analysis tool

Overview

The Column analysis tool allows aggregation of area data in a column format.
This tool can be explored using the Infection example. See the [Examples] page.

The tool loads the layout and result files from PlateEditor and exposes the available result plates (1) in its menu panel, together with options to select the columns of data to display in the table (2).
Result and definition plates can be browsed using the plate selection control (1a/1b).
Pairing information for the selected result plate is indicated. Browsing result plate will automatically set the definition plates to their correct values, if defined. Changing the definition plate manually will refresh the pairing information, indicating any broken link with the current result plate. For more details about [Pairing], see the corresponding page.
Click the Select Data button to select the data to use in the table (2a). A new dialog will open, listing available data on the right and the selected data on the left. Data can be dragged from left to right and reorganized as desired (See below for more details).

Aggregation
In the Column analysis tool, Data aggregation is fixed to column (2b): all values are stacked in a single column.

Column selection form

Areas, ranges and concentration data will be exposed for selection in the left panel of the selection form (1).
Categories can be expanded on click and the desired data selected by drag-and-dropping to the drop areas on the right (2), using the Columns area (2). Two levels of grouping are possible, but the second level is only accessible after the first level is occupied (as shown in 2).
Selected data can be unselected by drag-and-dropping them to the trash area (3), moving them back to the left panel.
Press OK when done to register your choices (4).

In the main panel, parameters associated with the selected result file will be available for browsing (1) and preceded by the result index (#) from the result table. Parameters from other files are locked but the computed data are kept in cache.
For each parameter, several data tables are computed (2). Each table has a set of controls for data export (3):

• Export: click to download the table as a text (tab-separated) file.
• Printable version: click to display the table in a new browser window/tab, which facilitates copy/print operations
• Graph: click to view the table as a graph (only available for the Values tables). See the [Graph] page for more information.

Available tables in the Control analysis tool:

• Values: this tab shows the aggregated values of each selected area, for the selected plate (2).
• Plate Summary: this tab caches the average and SD values calculated for each visited plate. Data are aggregated by selected area. Statistics are computed for the values found accross plates: average, SD, total number of values. Note that this panel will not be displayed if the selected result file has only one plate defined, but clicking the Compute All button will force it to appear.

Note: CV (%) statistical data can also be displayed by ticking the corresponding option, see [Analysis].

Specific details

Cached data
Even if they are not displayed, some information in the Plate Summary panel are computed and kept in cache. This includes the CV (%) values, as well as the average/SD values for unselected area combinations.
This means there is no need to re-compute the average/SD values for visited plates even if some areas were unselected.

Export all
When exporting all the data using the Export All option (see [Analysis]), only values for the selected areas will be exported. However, both data tables (Values, Z-factors) will be exported, even if they are hidden in the main panel.
The zip file provided will have the following structure:

Result_File\Parameter_Name\Data_table.txt

As in the figure below: