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:
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.
The Spreadsheet toolbar contains a number of tools and options for interacting with the data table. The spreadsheet toolbar is shown below:
![](https://aivia-software.atlassian.net/wiki/download/attachments/102072602/image2018-8-9_17-10-29.png?version=1&modificationDate=1533859830659&cacheVersion=1&api=v2)
Description and function for each tool are summarized in the table below:
Name | Icon | Description |
---|
Measurement tool | | Opens the Measurement Tool dialog |
Relations tool | | Opens the Relations Tool dialog |
Gate selected object | | Gate selected object into a new subset |
Show summary panel | | Toggle display of summary panel below the data table |
Auto-refresh columns | | Automatically refresh measurement values in the spreadsheet when progressing to a different time point when eabled |
Auto-scroll to selected | | 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 | | Opens the Export to Excel window for saving spreadsheet data to Excel |
Spreadsheet options | | 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
button below the image panel in Aivia. This will open the Spreadsheet interface.
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
icon on the toolbar to open the Measurement window.
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 ![](https://aivia-software.atlassian.net/wiki/download/attachments/102072602/PreviousEventIcon%20copy.png?version=1&modificationDate=1538678531827&cacheVersion=1&api=v2)
to navigate to the previous and next selected object respectively. If you have auto-scroll to selected
enabled on the Spreadsheet toolbar, Aivia will automatically navigate to the row of the most recently-selected object in the Spreadsheet.
Gate objects
After selection, you can create a subset containing just the selected objects by pressing the Gate
button on the Spreadsheet toolbar. A new tab will be created at the bottom of the spreadsheet containing the subset of objects that were gated out. The gated objects will be shown in both the subset tab and the All Objects tab.