Excel Data Export Profile Types

Row profile

A row profile transfers data to Excel on a row-by-row basis. Every session that is transferred to Excel becomes a row in the spreadsheet. Excel spreadsheets are limited to 256 columns, but the number of rows is practically unlimited. The profile generator automatically creates a sample profile that can be easily edited.

This format is useful for organizing data from many sessions so summary statistics can be organized for analysis. Formulas can be placed directly in the profile so the results are present the instant the data are transferred.

Table profiles
Table profiles transfer data in a tabular format to Excel. They provide a great deal of flexibility, but are not created automatically from sample Med-PC® data files in the same fashion as row profiles are.

There are three basic types of tables that can be created using the table editor:

Table profile Type 1: Freestyle

• The simplest table report, it starts with a blank table. Right click to paste special identifiers into profiles.

Table profile Type 2: table

Designed to present trial-oriented data along with session identifying information. Session identifiers, as well as data, can be placed in the “Header Titles” and “Header Elements” rows.
A key aspect of data tables is the ability to systematically extract data from an array variable without the need to explicitly type in every data element that should appear in the table. Ideal for creating tables displaying the results of trial-oriented sessions.
Table profile Type 3: record
Designed to transfer trial-oriented data to Excel with adequate descriptive information in each row so that the data in each row stands as an independent record.

For example, including subject and date information in each row with trial data allows one to sort or analyze all of the data for an entire experiment by these elements, perhaps broken down by ranges of dates or by subject subgroups. The key to producing this type of data structure is to place session identifiers, such as “Subject,” in the first few columns of the table, leaving the “Increment” and “Last Column Element” fields blank. The remaining columns contain data elements for each trial. This results in the identifier and data information being present in every row.