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.
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.
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.
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.
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).
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).
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.
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.
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 .