Spreadsheet

The Spreadsheet is the main method of viewing analysis data generated by Aivia. The spreadsheet collects the measurement values of all objects on the image and displays them in a sortable table. Selection in the spreadsheet is linked to the image panel and charts, allowing you to highlight objects of interests based on the analysis results.

Interface

The Spreadsheet is one of the six tabs that are found in the Content panel on the bottom of the Aivia window. An example of the Spreadsheet interface is shown below:

Open

Spreadsheet GUI

There are two sections: the toolbar and the data table. The data table is further subdivided into two sections, as highlighted in red and blue above for object instantaneous and temporal summary measurements respectively. You can adjust the width of the data table sections by dragging the separator between the sections.

Toolbar

The Spreadsheet toolbar contains a number of tools and options for interacting with the data table. The spreadsheet toolbar is shown below:

Open

Description and function for each tool are summarized in the table below:

Name	Icon	Description

Name	Icon	Description
Measurement tool	Open	Opens the Measurement Tool dialog
Relations tool	Open	Opens the Relations Tool dialog
Gate selected object	Open	Gate selected object into a new subset
Show summary panel	Open	Toggle display of summary panel below the data table
Auto-refresh columns	Open	Automatically refresh measurement values in the spreadsheet when progressing to a different time point when eabled
Auto-scroll to selected	Open	Automatically scroll to row of the most recently-selected object when enabled
Go to previous / next selected		Go to the previous or next select object row in the spreadsheet
Export data to Excel	Open	Opens the Export to Excel window for saving spreadsheet data to Excel
Spreadsheet options	Open	Opens the spreadsheet options dialog

On the right side opposite to the toolbar is the Object Set selector which allows you to display the measurements generated on a different object set on the image.

Data table

The data table contains the measurement data of all objects on the image. Each column represents a different measurement while each row represents a different object. The data table is split into two sections (see above)

• Instantaneous measurements are displayed on the left side of the data table and contains data about each object at the currently-displayed time point

• Temporal summary measurements are displayed on the right side of the data table and contains data about each object summarized over its entire lifetime

You can adjust the relative width of the two sections by dragging the separator between the sections.

Tabs across the bottom of the data table organizes the spreadsheet display into multiple pages. Each page includes different data on the given object set. Summary measurements over the entire image, as well as classification output and gated objects, can be viewed by clicking on the relevant tab. The tab also includes a count of all objects that are visible or displayed in the data table.

Using the spreadsheet

To launch the Spreadsheet, click on the Spreadsheet 

Select measurements

Measurements that are generated by Aivia (through applying a recipe) are shown in the Spreadsheet. You can add or modify the list of measurements by clicking on the Measurement Tool 

Instructions on how to add additional measurements to your analysis can be found in the How to add measurements to analysis results page.

Select objects

Each row in the data table represents a single object on the image. Clicking on a row will select the object in the Spreadsheet, Charts and on the image. You can select multiple objects on the image by holding down the Ctrl or Shift key during selection.

To navigate between selections, click on the backward or forward arrows 

Gate objects

After selection, you can create a subset containing just the selected objects by pressing the Gate 

Sort columns

You can sort the spreadsheet by any measurement as well as the name by clicking on the header of the table on the column you wish to sort by. When you click on the column header, a small indicator shows you the column that the Spreadsheet is being sorted by (see right).

Sort by descending value is indicated by a triangle pointing upward. To sort by ascending value, click on the column header again and the symbol will change to a triangle pointing downward.

Show summary

You can get statistical measurements of all measurements on a single time point by clicking the Show summary panel 

Open

Spreadsheet GUI with summary panel shown

Statistics for each measurements are calculated for all objects that are displayed on the given frame. You can specify  the statistic (total, maximum, minimum, average, mode and standard deviation) to calculate in the Spreadsheet options.

Export spreadsheet

You can export the spreadsheet data by clicking on the Export to Excel