If you have added a Spreadsheet, the Spreadsheet will appear on the layout and a node will appear in the Data Navigator with the name you assigned to the spreadsheet (Figure 11.2). Spreadsheets in FCS Express share much of the functionality included in Excel with the added benefit of live updating as statistics or data in your layout changes. A list of some of the common features in Excel that FCS Express will support are:

 

•Array Formulas

•Appearance Customization and Conditional Formatting

•Built in Operators and Functions

•Formula Creation and AutoSum

•Formatting Cells

•Find and Replace

•Comments

•Sorting

 

 
Jump to:

•Entering text or numeric data in the spreadsheet

•Creating a formula in a spreadsheet

•Using AutoSum

•Referencing cells in a spreadsheet

•Inserting a Token or Custom Token in a cell

•Inserting Token Tables

•Formatting Spreadsheet cells

•Spreadsheet Cell Value Tokens

•Analyzing Files from the Data List with Spreadsheets

oSpreadsheet Statistics Available from Data Files

 

 

 

The spreadsheet may be selected, de-selected, moved, re-sized, copied, and pasted just like any object in FCS Express.

 

A spreadsheet that has been copied and pasted will create a duplicate of itself. Any information that is entered in one of the copies will be updated in the additional copies. The copies will be visible in the Data Navigator as separate Data Grids/Spreadsheets under the same node (Figure 11.3)  Multiple spreadsheets may exist in the same layout and will appear as separate nodes in the Data Navigator (figure below).

 

 

Spreadsheets in FCS Express behave very similarly to Microsoft Excel. Just as in Excel there are countless features and options that can be performed. We will cover a few of the basic operations and important points for working with spreadsheets in FCS Express below.  

 

To enter text or numeric data in the spreadsheet:

 

1. Click on the cell in the spreadsheet.

2. Begin typing in the cell.

 

To create a formula in a spreadsheet:

 

1. Click on a cell in spreadsheet.

2. Enter an equals sign "=".

3. Enter a formula, function, or operator to evaluate.

4. The cell will return the value of the information entered.

 

You may select a cell in the spreadsheet and click on the Spreadsheet tab→Formulas. Click on the formula or function to use from the menu and it will populate the chosen cell as a blank formula.

 

AutoSum:

Alternatively, you may select a range of cells and choose a command from the AutoSum drop down (Figure 11.4). The AutoSum command you have chosen will be calculated across the selected range of data and appear below the final cell in the data range.

 

Available AutoSum functions are:

 

 

 

To reference cells in a spreadsheet:

 

1. Click on a cell in a spreadsheet.

2. Enter an equals sign "=".

3. Click on a different cell in the spreadsheet that contains data.

4. The original cell will display the data referenced from the second cell.

 

 

To insert a Token or Custom Token in a cell:

 

1. Right click in the cell.

2. Choose Insert Token.

3. Select a token to insert in the same manner as inserting a token into a text box.

 

Alternative 1: Drag and drop a statistic, plot, gate, or other FCS Express item from which tokens can be derived into a cell (see more about dragging and dropping tokens and token types)

 

The token value, or multiple token values, will appear in one or many cells.

 

Alternative 2:

1. Click on cell in the spreadsheet.

2. Click on the Spreadsheet tab→Layout tab→Tokens→Insert Token.

3. Choose the token of your choice to insert in the cell.

 

Tokens that are present in cells will update in real time as data updates in plots. Cells that reference other cells or formulas containing token values with also calculate and update in real time. Please note that tokens can also be used elsewhere in FCS Express to reference spreadsheet cells.

 

To insert Token Tables:

 

Tables in FCS Express from Compensations, Signatures, SOPs, Canned Comments, and Heat Maps may be inserted into a spreadsheet by (Figure 11.5):

 

1. Right clicking in a cell.

2. Choose Insert.

3. Select a token table to insert in the same manner as inserting a token into a text box.