Workbook

The Workbook shows results from calculations in tabular format.

 

Description

The data is presented on separate worksheets (e.g. Longitudanal ULS, Randolph’s Analysis etc.) which can be selected by clicking on the worksheet tabs at the bottom of the Workbook. Some worksheets have no data to display, in which case the worksheet displays a message to that effect.

In a worksheet, results are presented in a table where columns indicate properties and each row depicts a different result.

 

Workbook tab

When the Workbook is visible, the Workbook tab is displayed on the Ribbon, which provides buttons relating to the panel.

The Workbook tab indicates which worksheets have data to display and lets you switch between them.

It also enables you to Export the Workbook so that the results can be saved on an external program (e.g. Microsoft Excel) for future reference or printing.

 

Elements of the Workbook

Column context menu

Right-click on a column heading for more options to sort and group the data as well as to remove that column.

Workbook context menu

Right click elsewhere on the Workbook to reveal a second context menu allowing you to print or export the workbook.

Custom filter box

The custom filter box allows you to select from a list of parameters to filter the data by.

The list is accessible from drop down arrows in the left hand boxes.

Parameter values are entered in the right-hand boxes which have built-in calculators accessible from the drop down arrows.

 

 

How to . . .

Display a different selection of results

The default display only shows a small proportion of the available results.

  1. Left-click on the Asterisk * in the top left corner of the table to see a drop-down list of all available columns

  2. Left-click in the relevant tick boxes to show or hide the results you want displayed

 

  1. On the column context menu, choose Field Chooser to open a Customization dialog box

  2. Left-click and drag columns onto the worksheet to add them to the results table

Rearrange the column order

Group identical values in a particular column

This sorts all the results in ascending order by value for that column’s property. It also groups results with the same numerical value for that property

Sort the numerical values by a particular property

By default, data is sorted in ascending order by value in the furthest left column.

 

Filter results by their numerical values

  1. Left-click on the drop down arrow in the column heading of the property you want to filter by

  2. Left-click to tick the boxes of the values that you want to keep

This hides all results apart from those which have one of the ticked numerical values for that property

 

Customize the filter

  1. Left-click on the drop down arrow in the column heading of the property you want to filter by

  2. Left-click on (Custom...) to open the custom filter box for more advanced filtering options

 

Deselect the current filter

Current filters are displayed at the bottom of the workbook (above worksheet tabs).

To the right-hand side of the line describing the current filter, there is a drop down arrow which gives a list of previous filters so that they can be returned to easily. The Customize... button in the bottom right corner of the Workbook gives additional filter options.

Change results

To change the values shown in the results:

  1. Left-click on the data cell you wish to change

  2. Type a new value and press Enter

Note: if data values are greyed out then they can’t be modified.

Re-size columns

Export the Worksheet

  1. Right-click inside the panel to reveal the context menu and choose Export...

  2. Select the folder you want to save the file in

 

Print the Worksheet