User`s guide

E-Prime User’s Guide
Chapter 5: Data Handling
Page 181
Select the Block level in this dialog and click the OK button to collapse the spreadsheet at the
Block level. This will display only the unique occurrences at this level and all higher levels (i.e.,
Session level). Lower levels are hidden from view. The image below illustrates the
MergedData.emrg file, obtained from section 5.2.3.1 in this chapter, collapsed at the Block level.
The Tutorial experiment ran a single block of trials per subject, and the MergedData.EMRG file
contains data for 5 subjects. Thus, the spreadsheet, when collapsed at the block level, displays
the unique block level values for each of the 5 subjects. When the spreadsheet is collapsed
according to the lowest data level, this is equivalent to restoring it to its default format.
5.3.2.2 Arrange Columns
E-DataAid allows columns to be moved, hidden, and unhidden. Traditionally in a spreadsheet
application, a column is moved by first selecting it, then clicking the column header and, while
holding down the left mouse button, dragging and dropping it to a new location in the
spreadsheet. Similarly, a column is hidden or unhidden by first selecting it and then resizing it, or
using the Hide or Unhide commands on the application’s View menu. E-DataAid supports all of
these methods. However, these methods can be very cumbersome in a large spreadsheet.
Therefore, E-DataAid’s Arrange Columns command on the Tools menu provides an easier way to
move, hide, and unhide columns in the spreadsheet. The Arrange Columns command allows
selective viewing of a subset of the output variables in the experiment (e.g., show all dependent
measures but hide all other variables). The Arrange Columns command, available from the View
menu or by clicking the Arrange Columns tool button, displays the Arrange Columns dialog.
This dialog displays the hidden columns in the list on the left side of the dialog, and shows the
displayed columns on the right side of the dialog. By moving columns between the two lists, the
view status of the columns can be set. For example, select all columns beginning with “BlockList”
in the list on the right, and click the Remove button (Figure 1). The selected columns will be
moved to the list on the left (i.e., “Hide these columns”), as in Figure 2.