Spreadsheet Part 2

Back to Table of Contents

1.11 Search

Search is another new function available in Vista 2.0 and allows any one parameter to be tested for a number of conditions.

Choose one parameter from the spreadsheet and press Search. There is no restriction on parameter type as the routine automatically determines the format of the data. The Search pop-up menu will appear.

In the simple case of a number, a cut-off value is typed into the Limit text field. One of the FORTRAN conditional operators needs to be selected. The default is .EQ.. If the parameter being tested is composed of characters then characters can also be entered into the Limit field.

In the case of a real value, the tolerance field is active. This allows for experimental error. For an integer value, this field is automatically greyed out. In the case of character string searches, the tolerance field is also disabled.

The Exact match button is only active for string searches. If for example you wished to search for the refcode ABCDEF, with the Exact match button disabled, the following refcodes could be matched (if they appear in the table file and are active) ABCDEF, ABCDEF10, ABCDEF21, etc. With the Exact match button activated, only the first of the above refcodes would have been matched.

Once the Search criteria have been specified, hit OK and the function will be performed (choosing CANCEL will return to the spreadsheet). All of the entries that are matched by the Search criteria will appear highlighted in the spreadsheet. The dialogue bar at the top of the spreadsheet window will also report the number of hits satisfied by this Search function for that particular dataset.

1.12 Re-name

More meaningful names can be given to the parameters. Re-naming can only be applied to one parameter at a time.

Select one parameter in the spreadsheet and hit Re-name. The Re-name Parameter pop-up menu will appear allowing the user to type in a new parameter name.

The text keyed into the text field will be converted into upper case and the new name will be compared against the others to check for duplicates. An error pop-up will inform if the name is unsuitable. To remain consistent with Quest, the parameter names have a maximum length of 6 characters.

1.13 Export

Another new feature for Vista 2.0 is the ability to export tables of data. This operation will allow users to write selected columns of data to an ASCII text file in a form which is then suitable for import into other statistical or spreadsheet packages.

To export data, select the parameters of interest and press Export. The order of selection is mirrored in the output file column order. The Export Table File pop-up menu will appear.

The user can choose from the variety of column separators given in the scrolling list, with the default setting being to TAB delimited text. The export filename can be specified in this menu with the default being filename.exp. Parameter names can be added as Column Headings and a column of the Line Numbers can also be inserted. Any suppressed data in the spreadsheet will not be exported.

1.14 Swap

Any two selected parameters can be swapped. This operation simply interchanges the parameters' relative positions in the spreadsheet.

This feature may be particularly useful if there is a need to visually compare, line-by-line, two columns which are not adjacent in the spreadsheet.

If more than two parameters are selected in the spreadsheet an error message will be reported. This is also true if only one parameter is selected.

For consistency reasons the NFRAG and REFCOD fields are not permitted to be swapped with any other fields.

1.15 Select Parameters

Selects (highlights) all of the parameters.

If one or more parameters are already selected when Select Par is pressed, the previous selection order is erased and a new order imposed which follows sequentially from 1 (NFRAG) to N.

1.16 Clear Parameters

De-selects all of the parameters. This action has no effect on suppressed refcodes.

1.17 Delete Parameters

Selected columns of data can be removed from the spreadsheet by hitting the Delete button. This function should be used with care as there is no undo facility available in Vista 2.0.

NFRAG and REFCOD are protected against deletion.

1.18 Select Refcodes

All the rows in the spreadsheet are selected. Suppressed entries remain suppressed

1.19 Clear Refcodes

All the rows in the spreadsheet are de-selected. This action has no effect on suppressed refcodes and suppressed entries remain suppressed.

1.20 Invert

Performs a logical NOT on the refcode selections. Those that are selected are unselected and vice-versa. Suppressed entries remain suppressed.

Back to Table of Contents

Spreadsheet part 4 .