Exporting a spreadsheet of batched statistics using the Export Statistics Tool (for import into Prism, Spotfire, Excel, Tableau, etc.)

Background

The export statistics tool allows the creation of templates used to export batches of statistics from all files within an experiment.

Remember that it is also possible to export statistics directly from the Working Illustration.

If you want to follow along, look for the public Experiment called PBMC (fluorescence) or something similar on the Cytobank on which you have an account. This Experiment is used below as an example.

The templates used in the export statistics tool can be saved and loaded later into any Experiment, so long as the template makes sense for that Experiment.

 

Finding and using the export statistics tool

To enter the export statistics tool, first navigate into an Experiment and go to Actions > Export > Export Statistics.

 

(navigating to the export statistics tool)

 

Upon entering the tool, a screen may appear which allows the selection of a previously saved template. If this is not applicable, the option to define a new template can be chosen. Templates can also be saved and loaded at any time from the persistent menu on the left.

 

(click to load a saved template, or define a new one)

 

Once the interface loads, a template can be created. A template is populated with export definitions that become rows in the view at the bottom. Each row is a piece of information (generally statistics) that will be pulled from every file in the Experiment. Besides statistics, Sample Tag information and FCS file metadata can be extracted from the Experiment into the spreadsheet. This is beneficial for maintaining scientific context for your statistics upon import into another tool such as Prism, Spotfire, Excel, Tableau, etc., instead of just being limited to FCS file names.

 

(basic anatomy of the export statistics interface)

 

Video overview of the export statistics tool

The movie below demonstrates the use of the export statistics tool. Note the use of the Sample Tags attribute as well as FCS file metadata.

 

(A demonstration of building a template in the Export Statistics Interface. Each row in the template becomes a data point taken against all FCS files in the Experiment. Sample Tag information, as well as FCS file metadata can be exported. The resulting spreadsheet can be viewed below)

 

Example exported spreadsheet result

As mentioned above, each row is a piece of information that will be pulled from every file in the experiment. For example, if an experiment with 10 files has an export template with 10 row definitions, a 10 x 10 spreadsheet with 100 data points will result. For smaller situations such as the one demonstrated above, a spreadsheet such as the one below will result:

 

(the spreadsheet that results from the export in the movie above)

 

 



Have more questions? Submit a request