A new Spreadsheet tool has been added to FCS Express to allow you to easily analyze and organize statistics and information from your experiments.

 

A Spreadsheet may be added to a layout through the Data tab→Insert→New Spreadsheet command.

 

Once a spreadsheet is inserted you may click on the Spreadsheet to select it, which will make the Spreadsheet→Layout and Spreadsheet→Formula tabs appear (figures below).

 
Spreadsheets in FCS Express 6 can be used to perform most of the operations that Microsoft Excel provides. In addition, values in Spreadsheet cells can be derived directly from statistics within the layout, keywords, or from data files in the data list. Inserting statistics for data files in the data list allows additional flexibility in analysis of many statistics for many data files that are not currently open in the layout. Data contained in spreadsheets may be directly exported as .xlsx, .xls, .csv, .html, .xml and .txt files. When exporting as to Excel compatible formats equations and formatting from the FCS Express spreadsheet will be retained.

 

A number of specialized tutorials are available to guide you through some of the more advanced spreadsheet features:

 

•HLA Cross matching - Spreadsheet Use Case 1

oCreating a Spreadsheet for analysis

oPopulating a Spreadsheet with data

oWorking with Custom Tokens and Formula References in spreadsheets

oUsing Conditional Formatting to Classify Data

 

•Antibody Titration - Spreadsheets Use Case 2

 

•Calibration via Regression Analysis - Spreadsheets Use Case 3

oComplete a Spreadsheet and Insert a Scatter with Regression Plot

oWorking with Regression Tokens and Fit Equations

 

•Working with Pie, Bar, and Scatter Plots - Spreadsheets Use Case 4