Spreadsheets in FCS Express 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.

 

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

 

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

 

Once data is tabulated, you can display it graphically using Charts (e.g. Pie Charts, Bar Charts, Scatter Plots,...). For example, Spreadsheets can be used to automate the process of generating titration curves.

 

Spreadsheets created within FCS Express may also be exported to various external file formats such as .xls, .xlsx, .csv, .html, .xml and .txt.

Formulas, formatting, and references will be preserved when selecting to save in the .xls or .xlsx file format.

 

Note: Spreadsheets replace Custom Data tables from previous versions of FCS Express but have the same capabilities. If you have Custom Data tables saved from previous versions FCS Express in your layout then FCS Express 6 will allow you to open them for use. New tables can only be create via the Spreadsheets feature.

 

Jump to:

•Creating a Spreadsheet

•Working with Spreadsheets

oFormatting Spreadsheet Cells

oSupported Spreadsheet Keystroke Commands

oUsing Find and Replace

•Using Spreadsheets to access statistics from files in the Data List

•Spreadsheet Formula Definitions

•Graphing Data with Charts (e.g. Pie Charts, Bar Plots, Scatter with Regression, and Box and Whisker Plots)

•List of and description Spreadsheet Statistics available via drag and drop from the data list

 

 

 

Additional Resources:

 

Tutorials:

•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