		More Information
	Citrin 2 Overview Interactive Visualization & Graph Types Curve Fitting & Regression Exploring Your Data With Citrin Worksheet Features and Utilities Graphic Export Formats

Citrin Worksheets, Data Importers, and Utilities

Worksheets are Citrin's data storage mechanism, and provide numerous data management functions and utilities. They also act as dynamic data sources for data analysis and visualization.

Supported Data Import Formats

Citrin provides importers for:

Excel format: 95, 97-2004 workbook (.xls)
Delimited text data (tab, comma, semicolon, space, etc.)
Fortran formatted data
Delimited numeric matrix data
Binary numeric matrix formats (8 bit, 16 bit, 32 bit, and 64 bit)
dBase (II, III, IV) formats

To view the UI for delimited file importer, click here.

Quality Control of Numeric Data

Citrin's quality control tools allow:

Displaying report summary statistics for each variable with a single click
Checking the number of missing values of a variable (discontinuous data, etc.)
Detecting out-of-range values (impossible values, punching errors, etc.) and highlighting them in the corresponding worksheet rows
Dealing with out-of-range values using different options

Supported Variable Types

Citrin support:

Numbers (any legal numerical representation with no explicit sample space)
Date and Time (30 built-in date & time formats, and tools for custom-defining a format)
Text (with Unicode support)

The Worksheet Markers (Colored Symbols Used for Data Representation)

Markers are colored graphical symbols that allow identifying the plotted data, i.e., data sources, individual or groups of data objects, data series, etc.

The Significance of Markers

Object markers:

Each worksheet has a global marker that is shared by all data objects (the collective data source marker). The significance of this marker is to differentiate data that are sourced from different worksheets.
Each worksheet row can have its own local marker, i.e., local markers identify individual or groups of data objects based on uniqueness of the local marker (defined by its symbol, color, and size). The significance of this marker is to differentiate groups of data objects (see the right-hand side image).
When you change markers that represent data sources or groups of data objects on a graph, the change will be dynamically updated in the worksheet, and vice versa.

Variable markers:

In a graph that displays data series, the variable markers are initially taken from a pre-set definition for identifying variables in the order they are stored in the source worksheet. You can define and hot-link marker and other properties (e.g., fill color, line thickness, type, and color) to variables (worksheet columns).

Citrin Marker Symbols

Citrin provides 175 marker symbols, each of which can be scaled from 50 to 200% of the initial size (100%) in 20 steps.
The Citrin marker palette also has a blank "symbol" to allow removing markers from a graph:
This can be useful, for example, to compare regression curves without displaying data points.

Unicode Characters/Symbols/Glyphs

The Unicode palette can hold 176 characters/symbols/glyphs, each of which can be scaled from 50 to 200% of the initial size (100%) in 20 steps.
This palette can be customized, i.e., each item of the palette can be replaced by another Unicode character/symbol/glyph from the System character palette.

Numbers of Rows & Columns

Citrin does not impose limits on the number of rows and columns in worksheets. The limitation is mainly related to the speed penalty imposed by:

Currently available hardware technology and the CPU resources
Physical memory available to the application

Other factors that can impose speed penalty are (i) large amounts of complex Unicode textual data, and (ii) use of complex symbols, or Unicode symbols for graphing large data sets.

Formula Editor

The formula editor is integrated into Citrin worksheets.

It provides 46 pre-defined mathematical and statistical functions, and includes standard as well as Boolean/conditional operators.

In Citrin, variables are identified by names, and not by the position of worksheet columns. However, to facilitate sequential calculations, the formula editor provides functions that operate on variables by indices instead of names.

Citrin worksheet operations are column based. However, the optional feature of addressing worksheet row indices enables addressing the worksheet cells explicitly.

In addition to functions provided for column-wise calculations, the formula editor provides a number of functions for row-wise calculations.

Assign and calculate commands are provided for applying the same formula to multiple columns.

To view the UI, click here.

The Worksheet Data Management Features

Sorting worksheet data based on values of a selected variable (in either ascending or descending order)
Transposing columns, rows, or an area of cells, or the entire contents of a worksheet
Reordering rows and columns
Providing a palette for rapid scanning through data columns in a worksheet with large number of variables or for bringing a specific data column into the field of view
Mapping object markers to categorical data
Mapping markers to categorical data to be stored as integers or marker codes
Mapping marker codes to marker (if you have saved defined marker properties as marker codes, you can map the codes back to markers

The Worksheet Notebook

Citrin worksheet notebook has two functions:

It displays a list of all variables present in the worksheet
It provides a text area for storing notes, e.g., data source references, etc.

To view the UI, click here.