Edit Cell Data
Editing a single cell is as easy as navigating to that cell, entering the new value, and pressing the Enter key. To preserve the hierarchy of the data, E-DataAid does not allow the user to edit log-level values below the session level. Although log level variables may be renamed, the cells are gray to indicate that they are read-only. If any other cells are displayed in gray, this indicates that the experiment Administrator has placed security restrictions on the file and has set the cells as read-only.
Like other popular spreadsheet applications, E-DataAid provides common commands, such as Find, Replace, Fill Down, Copy, and Paste, to make the chore of editing many cells easier. Since these commands are not unique to E-DataAid, time is not spent describing them here.
All edits to a cell appear in red, and for each edit, E-DataAid writes an annotation to the file. Even if performed within a group operation, such as Replace All, E-DataAid will write an individual annotation to the file for each edited cell within the operation. For example, if a Replace All operation edits three session-level cells, E-DataAid will write three annotations to the file – one for each edit. Notice that an edit that is made at a higher level is propagated down throughout the file. For example, each session- level edit appears in every cell in the worksheet that is associated with that session: when you replace the session number, for instance, every block and trial row within the session shows the edited value). While this type of record keeping is necessary for a complete history of modifications, the number of annotations can quickly become very large, depending on the number of edits made to a file. To make the list of annotations more readable, refer to E-DATAAID: Understand the Audit Trail  for information concerning filtering the annotations list.