Back to Table of Contents

1. Spreadsheet

The table spreadsheet is the functional heart of Vista 2.0, and this menu provides the numerous links to the other sections of the program.

The spreadsheet window is split into three main areas: the Quest file information, the spreadsheet, and the active functions.

The Quest file information in the top-left section of this window provides the user with a quick summary of the original Quest3D search of the CSD. The search fragment is shown together with a count of the number of parameters defined for this fragment. The number of refcodes kept by the search of the CSD is given as well as the total number of fragments located. A summary of the number of parameters and fragments that are currently selected or suppressed in the spreadsheet itself is also presented in this information box.

The scrollable table spreadsheet is the main feature of this window. The parameters form the columns of the spreadsheet with the fragments (represented by their refcodes) forming the rows.

In general, the spreadsheet operates on a policy of "first select data then perform function". To select either a row or a column, click on the grey bevelled numbered buttons. A selected row/column will be rendered in reverse video - white text on a black background. A selected row/column can be de-selected by clicking on the grey bevelled button again.

If a refcode has been suppressed, that particular row, will appear "greyed out"- dark grey text on light grey background. Such entries are effectively removed from the data set and from subsequent spreadsheet applications, until the user manually restores the data. These entries remain visible in the spreadsheet to remind the user that they are working with a reduced data-set.

The active functions are gathered to the right of the spreadsheet window. These are used to perform operations on data selected in the spreadsheet. A full description of the available functions now follows.

1.1 Load/Save Quest Files

If you need to load a new set of data or simply re-load the current data, click on Load. Enter the root name and either hit RETURN or click OK.

The same pop-up appears when you wish to save the files.

1.2 Histogram

Histogram production is a very straightforward procedure. Select one numerical parameter from the spreadsheet (click one of the grey numbered bevelled buttons) and then press Histogram. Vista 2.0 will automatically display the desired histogram using the plot window. Plot options are then available to the user (see section 2 for further details on the plot functions).

If more than one parameter is currently selected in the spreadsheet then Vista 2.0 will report an error. If this happens return to the spreadsheet, de-select unwanted parameters and then click Histogram again.

Histograms can only be produced for numerical parameters.

1.3 Scattergram

Scattergram production is also a simple procedure. This time two numerical parameters must be selected in the spreadsheet. The order of selection is important however as the first parameter picked in the spreadsheet will always be plotted as the Y axis in the resulting scattergram.

With two parameters selected press Scattergram and Vista 2.0 will display the desired scattergram in a plot window. Plot options are then available to the user (see section 2 for further details on the plot functions).

If more than two parameters are selected in the spreadsheet (or only one parameter) then an error will be reported. Return to the spreadsheet and ensure only two parameters are selected before proceeding with Scattergram.

Scattergrams can only be produced for numerical parameters.

1.4 Polar Histogram

Polar histograms can be generated using exactly the same procedure employed for plotting linear histograms (section 1.2).

Select one numerical parameter (usually an angle for meaningful polar plots, although Vista 2.0 will attempt to plot polar histograms for any selected numerical parameter) and then select Polar Histogram.

Vista 2.0 will automatically display the desired polar histogram using the plot window. Plot options are then available to the user (see section 2 for further details on the plot functions).

1.5 Polar Scattergram

Polar scattergrams can be produced in the same fashion as the linear scattergrams (section 1.3).

Select two numerical parameters in the spreadsheet. The order of selection is important and if one non-angular parameter is required to be plotted then this must be selected first, followed by the angular parameter.

With two parameters selected click Polar Scattergram and Vista 2.0 will automatically display the desired polar histogram using the plot window. Plot options are then available to the user (see section 2 for further details on the plot functions).

1.6 View Refcodes

Vista version 1.0 allowed the user to view the 1D,2D and 3D representations of selected refcodes, but restricted the user to selecting only one refcode at a time. Vista version 2.0 permits the user to build up a list of refcodes to be viewed in any order from within the ASER viewer window (see section 3).

There are several functions in Vista 2.0 for generating these refcode lists and they will be detailed later in this guide.

From the spreadsheet window the user can manually select refcode rows in the spreadsheet by clicking on the grey buttons. Pressing View REFCODes will take the user to the ASER viewer where the selected refcodes will be available for viewing.

If no rows are selected, an error message will appear.

1.7 Correlation/Covariance

The correlation/covariance option permits the investigation of statistical relationships between numerical parameters.

To use this function select as many numerical parameters as are required on the spreadsheet and then hit the Correlation/Covariance button. A new screen will appear.

Details of the Correlation/Covariance menu are given in section 4.

1.8 View Quest Fragment

At the top left hand side of the spreadsheet, there is a thumbnail image of the current test fragment, as defined in Quest. Its purpose is simply to remind the user of the nature of the current test.

An enlarged rendering of this fragment is available in a separate screen, which is activated by selecting View Quest Fragment.

Clicking on the thumbnail image of the fragment will also activate the View Quest Fragment window.

Details about this window and the information presented in it are available in section 5 of this guide.

Back to Table of Contents

Spreadsheet part 2 .